Human Capital Management - EBS (MOSC)

MOSC Banner

Get Created Assignment Number through create_secondary_emp_asg

edited Sep 9, 2017 1:46PM in Human Capital Management - EBS (MOSC) Question

I'm creating a Secondary assignment number by using HR_ASSIGNMENT_API.CREATE_SECONDARY_EMP_ASG API as shown in the sample below (please note the variable ln_assignment_number):

set serveroutput on;declare    cursor ict_emp_dtls_cur is    select        -- New Details            lin.ICT_TRX_LINE_ID         ICT_TRX_LINE_ID        ,   lin.CURRENT_ASSIGNMENT_ID   CURRENT_ASSIGNMENT_ID        ,   LIN.EMPLOYEE_NUMBER         EMPLOYEE_NUMBER        ,   LIN.NEW_PAYROLL_ID          NEW_PAYROLL_ID        ,   LIN.NEW_JOB_ID              NEW_JOB_ID        ,   LIN.NEW_ORG_ID              NEW_ORG_ID        ,   LIN.NEW_LOCATION_ID         NEW_LOCATION_ID        ,   LIN.NEW_PAY_BASIS_ID        NEW_PAY_BASIS_ID        ,   LIN.NEW_SUPERVISOR_ID       NEW_SUPERVISOR_ID        ,   LIN.NEW_PROJECT_NUMBER      NEW_PROJECT_NUMBER        ,   LIN.NEW_KRONOS_TERMINAL     NEW_KRONOS_TERMINAL        ,   LIN.NEW_EMP_CAT_CODE        NEW_EMP_CAT_CODE        ,   LIN.NEW_SALARY              NEW_SALARY        ,   LIN.NEW_ADDRESS_LINE_1      NEW_ADDRESS_LINE_1        ,   LIN.NEW_ADDRESS_LINE_2      NEW_ADDRESS_LINE_2        ,   LIN.NEW_ADDRESS_LINE_3      NEW_ADDRESS_LINE_3        ,   LIN.NEW_CITY                NEW_CITY        ,   LIN.NEW_STATE               NEW_STATE        ,   LIN.NEW_ZIP                 NEW_ZIP        ,   LIN.NEW_COUNTY              NEW_COUNTY        -- Current Asg Details        ,   PPX.*        -- SCL        ,   scl.segment1                scl_segment1        ,   scl.segment2                scl_segment2        ,   scl.segment3                scl_segment3        ,   scl.segment4                scl_segment4        ,   scl.segment5                scl_segment5        ,   scl.segment6                scl_segment6        ,   scl.segment7                scl_segment7        ,   scl.segment8               

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center