APPS.PAY_EMP_ACTION_ARCH dependencies on PAY_ACTION_INFORMATION

Line 23: for payslip in pay_action_information table.

19:
20: Name : pay_emp_action_arch
21:
22: Description : This package populates the global data
23: for payslip in pay_action_information table.
24: The action_information_categories that it
25: populates are:
26: - EMPLOYEE DEATLS
27: - ADDRESS DETAILS

Line 490: pay_action_information_api.create_action_information(

486: hr_utility.trace('act_info6 is'|| p_tab_rec_data(i).act_info6);
487: hr_utility.trace('act_info30 is'|| p_tab_rec_data(i).act_info30);
488:
489: hr_utility.set_location(gv_package || '.' || lv_procedure_name, 30);
490: pay_action_information_api.create_action_information(
491: p_action_information_id => l_action_information_id_1,
492: p_object_version_number => l_object_version_number_1,
493: p_action_information_category
494: => p_tab_rec_data(i).action_info_category,

Line 2548: -- insert rows in pay_action_information table

2544: close c_get_organization;
2545:
2546: hr_utility.set_location(gv_package || lv_procedure_name, 140);
2547:
2548: -- insert rows in pay_action_information table
2549: if pay_emp_action_arch.ltr_ppa_arch.count > 0 then
2550: insert_rows_thro_api_process(
2551: p_action_context_id => p_payroll_action_id
2552: ,p_action_context_type => 'PA'

Line 2602: from pay_action_information pai

2598: cursor c_employer_info (cp_payroll_action_id in number) is
2599: select distinct
2600: nvl(pai.tax_unit_id, -1)
2601: ,pai.action_information2 organization_id
2602: from pay_action_information pai
2603: ,pay_assignment_actions paa
2604: where pai.action_information_category = 'EMPLOYEE DETAILS'
2605: and pai.action_context_type = 'AAP'
2606: and pai.action_context_id = paa.assignment_action_id

Line 2625: delete from pay_action_information pai

2621: BEGIN
2622: lv_procedure_name := '.arch_pay_action_level_data_deinit';
2623: hr_utility.set_location(gv_package || lv_procedure_name, 1);
2624:
2625: delete from pay_action_information pai
2626: where pai.action_context_id = p_payroll_action_id
2627: and pai.action_context_type = 'PA'
2628: and pai.action_information_category in ('EMPLOYEE OTHER INFORMATION',
2629: 'ADDRESS DETAILS')

Line 2668: -- insert rows in pay_action_information table

2664: close c_employer_info;
2665:
2666: hr_utility.set_location(gv_package || lv_procedure_name, 100);
2667:
2668: -- insert rows in pay_action_information table
2669: if pay_emp_action_arch.ltr_ppa_arch.count > 0 then
2670: insert_rows_thro_api_process(
2671: p_action_context_id => p_payroll_action_id
2672: ,p_action_context_type => 'PA'