APPS.PAY_GB_DEO dependencies on PAY_ACTION_INFORMATION

Line 169: -- Procedure to insert data to the archive table pay_action_information

165: return l_arch;
166: END fetch_person_rec;
167: --
168: --
169: -- Procedure to insert data to the archive table pay_action_information
170: PROCEDURE insert_archive_row(p_assactid IN NUMBER,
171: p_effective_date IN DATE,
172: p_tab_rec_data IN action_info_table) IS
173: l_proc CONSTANT VARCHAR2(50):= g_package||'insert_archive_row';

Line 183: pay_action_information_api.create_action_information(

179: for i in p_tab_rec_data.first .. p_tab_rec_data.last loop
180: hr_utility.trace('Defining category '|| p_tab_rec_data(i).action_info_category);
181: hr_utility.trace('action_context_id = '|| p_assactid);
182: if p_tab_rec_data(i).action_info_category is not null then
183: pay_action_information_api.create_action_information(
184: p_action_information_id => l_action_id,
185: p_object_version_number => l_ovn,
186: p_action_information_category => p_tab_rec_data(i).action_info_category,
187: p_action_context_id => p_assactid,

Line 971: from pay_action_information pai_emp,

967: select pai_emp.action_information3 f_name,
968: pai_emp.action_information4 l_name,
969: nvl(pai_emp.action_information5,' ')ni_no,
970: nvl(pai_emp.action_information6,' ')emp_no
971: from pay_action_information pai_emp,
972: pay_assignment_actions paa
973: where paa.payroll_action_id = pactid and paa.ACTION_STATUS = 'C' and paa.assignment_id = c_assignment_id
974: and pai_emp.action_context_id = paa.assignment_action_id
975: and pai_emp.action_information_category = 'GB DEO EMPLOYEE DETAILS';

Line 1044: delete from pay_action_information pai

1040:
1041: hr_utility.set_location('Entering deinit: '||l_proc,1);
1042:
1043: -- To avoid re-archiving while Retry
1044: delete from pay_action_information pai
1045: where pai.action_context_id = pactid
1046: and pai.action_context_type = 'PA'
1047: and pai.action_information_category in ('GB DEO EMPLOYER DETAILS');
1048:

Line 1071: pay_action_information_api.create_action_information (

1067: hr_utility.set_location('Payment to date = '||l_emp_rec.payment_to_date,60);
1068:
1069: hr_utility.set_location('Archiving GB DEO EMPLOYER DETAILS',60);
1070:
1071: pay_action_information_api.create_action_information (
1072: p_action_information_id => l_action_info_id
1073: , p_action_context_id => pactid
1074: , p_action_context_type => 'PA'
1075: , p_object_version_number => l_ovn