APPS.PQP_HROSS_INTEGRATION dependencies on HR_API_MODULES

Line 3795: FROM hr_api_modules

3791: -- DP interface tables
3792: CURSOR csr_get_dp_mode (c_batch_id IN Number
3793: ,c_link_value IN Number) IS
3794: SELECT 'CREATE'
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

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 3929: l_api_name hr_api_modules.module_name%TYPE;

3925: l_proc_name CONSTANT Varchar2(150):= g_pkg ||'HR_DataPumpErr';
3926:
3927: l_dp_mode Varchar2(10);
3928: l_if_end_dated Varchar2(20);
3929: l_api_name hr_api_modules.module_name%TYPE;
3930: l_user_person_type per_person_types.user_person_type%TYPE;
3931: l_pay_basis_name per_pay_bases.NAME%TYPE;
3932: l_organization_name hr_all_organization_units.NAME%TYPE;
3933: l_location_code hr_locations_all.location_code%TYPE;