APPS.PAY_GB_RTI_EAS dependencies on PAY_ACTION_INFORMATION

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

2026: hr_utility.trace('Leaving set_new_starter_rti_sent');
2027:
2028: end set_new_starter_rti_sent;
2029:
2030: -- Procedure to insert data to the archive table pay_action_information
2031: PROCEDURE insert_archive_row(p_assactid IN NUMBER,
2032: p_effective_date IN DATE,
2033: p_tab_rec_data IN action_info_table) IS
2034: l_proc CONSTANT VARCHAR2(50):= g_package||'insert_archive_row';

Line 2044: pay_action_information_api.create_action_information(

2040: for i in p_tab_rec_data.first .. p_tab_rec_data.last loop
2041: hr_utility.trace('Defining category '|| p_tab_rec_data(i).action_info_category);
2042: hr_utility.trace('action_context_id = '|| p_assactid);
2043: if p_tab_rec_data(i).action_info_category is not null then
2044: pay_action_information_api.create_action_information(
2045: p_action_information_id => l_action_id,
2046: p_object_version_number => l_ovn,
2047: p_action_information_category => p_tab_rec_data(i).action_info_category,
2048: p_action_context_id => p_assactid,

Line 3686: from pay_action_information pai_emp,

3682: pai_emp.action_information17 emp_no1,
3683: to_char(to_date(substr(pai_asg.action_information5,1,10),'YYYY-MM-DD'),'DD-MON-RRRR') start_date,
3684: to_char(to_date(substr(pai_asg.action_information6,1,10),'YYYY-MM-DD'),'DD-MON-RRRR') end_date,
3685: pai_emp.action_information17 emp_no2
3686: from pay_action_information pai_emp,
3687: pay_action_information pai_asg,
3688: pay_assignment_actions paa
3689: where paa.payroll_action_id = pactid and paa.ACTION_STATUS = 'C' and paa.assignment_id = c_assignment_id
3690: and pai_emp.action_context_id = paa.assignment_action_id

Line 3687: pay_action_information pai_asg,

3683: to_char(to_date(substr(pai_asg.action_information5,1,10),'YYYY-MM-DD'),'DD-MON-RRRR') start_date,
3684: to_char(to_date(substr(pai_asg.action_information6,1,10),'YYYY-MM-DD'),'DD-MON-RRRR') end_date,
3685: pai_emp.action_information17 emp_no2
3686: from pay_action_information pai_emp,
3687: pay_action_information pai_asg,
3688: pay_assignment_actions paa
3689: where paa.payroll_action_id = pactid and paa.ACTION_STATUS = 'C' and paa.assignment_id = c_assignment_id
3690: and pai_emp.action_context_id = paa.assignment_action_id
3691: and pai_emp.action_information_category = 'GB RTI EMPLOYEE DETAILS'

Line 3988: delete from pay_action_information pai

3984: BEGIN
3985: hr_utility.trace('Entering deinit: '||l_proc);
3986:
3987: -- To avoid re-archiving while Retry
3988: delete from pay_action_information pai
3989: where pai.action_context_id = pactid
3990: and pai.action_context_type = 'PA'
3991: and pai.action_information_category in ('RTI PAYROLL INFO');
3992:

Line 4012: pay_action_information_api.create_action_information (

4008:
4009:
4010: hr_utility.set_location('Archiving RTI PAYROLL INFO',60);
4011:
4012: pay_action_information_api.create_action_information (
4013: p_action_information_id => l_action_info_id
4014: , p_action_context_id => pactid
4015: , p_action_context_type => 'PA'
4016: , p_object_version_number => l_ovn