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 526: pay_action_information_api.create_action_information(

522: hr_utility.trace('act_info6 is'|| p_tab_rec_data(i).act_info6);
523: hr_utility.trace('act_info30 is'|| p_tab_rec_data(i).act_info30);
524:
525: hr_utility.set_location(gv_package || '.' || lv_procedure_name, 30);
526: pay_action_information_api.create_action_information(
527: p_action_information_id => l_action_information_id_1,
528: p_object_version_number => l_object_version_number_1,
529: p_action_information_category
530: => p_tab_rec_data(i).action_info_category,

Line 2651: -- insert rows in pay_action_information table

2647: close c_get_organization;
2648:
2649: hr_utility.set_location(gv_package || lv_procedure_name, 140);
2650:
2651: -- insert rows in pay_action_information table
2652: if pay_emp_action_arch.ltr_ppa_arch.count > 0 then
2653: insert_rows_thro_api_process(
2654: p_action_context_id => p_payroll_action_id
2655: ,p_action_context_type => 'PA'

Line 2705: from pay_action_information pai

2701: cursor c_employer_info (cp_payroll_action_id in number) is
2702: select distinct
2703: nvl(pai.tax_unit_id, -1)
2704: ,pai.action_information2 organization_id
2705: from pay_action_information pai
2706: ,pay_assignment_actions paa
2707: where pai.action_information_category = 'EMPLOYEE DETAILS'
2708: and pai.action_context_type = 'AAP'
2709: and pai.action_context_id = paa.assignment_action_id

Line 2728: delete from pay_action_information pai

2724: BEGIN
2725: lv_procedure_name := '.arch_pay_action_level_data_deinit';
2726: hr_utility.set_location(gv_package || lv_procedure_name, 1);
2727:
2728: delete from pay_action_information pai
2729: where pai.action_context_id = p_payroll_action_id
2730: and pai.action_context_type = 'PA'
2731: and pai.action_information_category in ('EMPLOYEE OTHER INFORMATION',
2732: 'ADDRESS DETAILS')

Line 2771: -- insert rows in pay_action_information table

2767: close c_employer_info;
2768:
2769: hr_utility.set_location(gv_package || lv_procedure_name, 100);
2770:
2771: -- insert rows in pay_action_information table
2772: if pay_emp_action_arch.ltr_ppa_arch.count > 0 then
2773: insert_rows_thro_api_process(
2774: p_action_context_id => p_payroll_action_id
2775: ,p_action_context_type => 'PA'