APPS.PQP_HROSS_INTEGRATION dependencies on HR_PUMP_BATCH_LINES

Line 2689: FROM hr_pump_batch_lines

2685: -- Cursor gets the link_value for the record. It is the value 1 added to the
2686: -- maximum value of Link_Value for that batch_id
2687: CURSOR csr_get_link_value (c_batch_id Number) IS
2688: SELECT Max(link_value) + 1
2689: FROM hr_pump_batch_lines
2690: WHERE batch_id = c_batch_id;
2691:
2692: -- Cursor to get the Assignment details of duplicate person
2693: CURSOR csr_asg (c_person_id IN Number

Line 3799: FROM hr_pump_batch_lines

3795: FROM hr_api_modules
3796: WHERE module_name = 'CREATE_EMPLOYEE'
3797: AND module_package = 'HR_EMPLOYEE_API'
3798: AND api_module_id IN (SELECT api_module_id
3799: FROM hr_pump_batch_lines
3800: WHERE batch_id = c_batch_id
3801: AND link_value = c_link_value);
3802:
3803: -- Cursor to get all the api_ids which have LINE_STATUS in status 'C' or 'U'

Line 3807: FROM hr_pump_batch_lines hpbl, hr_api_modules ham

3803: -- Cursor to get all the api_ids which have LINE_STATUS in status 'C' or 'U'
3804: CURSOR csr_get_api_names (c_batch_id IN Number
3805: ,c_link_value IN Number) IS
3806: SELECT module_name
3807: FROM hr_pump_batch_lines hpbl, hr_api_modules ham
3808: WHERE batch_id = c_batch_id
3809: AND link_value = c_link_value
3810: AND line_status IN ('U', 'E')
3811: AND hpbl.api_module_id = ham.api_module_id;

Line 3822: -- FROM hr_pump_batch_lines hpbl, hr_api_modules ham

3818: -- FROM dual
3819: -- WHERE
3820: -- 'UPDATE_PERSON_ADDRESS' IN
3821: -- (SELECT module_name
3822: -- FROM hr_pump_batch_lines hpbl, hr_api_modules ham
3823: -- WHERE batch_id = c_batch_id
3824: -- AND link_value = c_link_value
3825: -- AND hpbl.api_module_id = ham.api_module_id
3826: -- AND line_status IN ('U', 'E'))

Line 3829: -- FROM hr_pump_batch_lines hpbl, hr_api_modules ham

3825: -- AND hpbl.api_module_id = ham.api_module_id
3826: -- AND line_status IN ('U', 'E'))
3827: -- AND 'CREATE_PERSON_ADDRESS' IN
3828: -- (SELECT module_name
3829: -- FROM hr_pump_batch_lines hpbl, hr_api_modules ham
3830: -- WHERE batch_id = c_batch_id
3831: -- AND link_value = c_link_value
3832: -- AND hpbl.api_module_id = ham.api_module_id
3833: -- AND line_status IN ('U', 'E'));

Line 3945: -- duplicate person id based on the API_MODULE_ID in hr_pump_batch_lines

3941: BEGIN
3942: hr_utility.set_location('Entering: ' || l_proc_name, 10);
3943:
3944: -- Check if operation being corrected was insert or update because of
3945: -- duplicate person id based on the API_MODULE_ID in hr_pump_batch_lines
3946: -- and then set dp_mode flag respectively
3947:
3948: OPEN csr_get_dp_mode (c_batch_id => p_batch_id
3949: ,c_link_value => p_data_pump_batch_line_id

Line 3988: -- which we will require in newly created entry in HR_PUMP_BATCH_LINES

3984: -- NOTE : We will be calling the same "INSERT_BATCH_LINES" for updation
3985: -- as internally "INSERT_BATCH_LINES" deletes the previous entry
3986: -- for corresponding Batch_line_Id and makes a fresh entry.
3987: -- Hence, in the cursor we will temporarily store some of the data
3988: -- which we will require in newly created entry in HR_PUMP_BATCH_LINES
3989:
3990:
3991: LOOP
3992: