APPS.PAY_GB_RTI dependencies on PAY_ACTION_INFORMATION

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

1529:
1530: hr_utility.trace('Leaving set_new_starter_rti_sent');
1531: end set_new_starter_rti_sent;
1532:
1533: -- Procedure to insert data to the archive table pay_action_information
1534: PROCEDURE insert_archive_row(p_assactid IN NUMBER,
1535: p_effective_date IN DATE,
1536: p_tab_rec_data IN action_info_table) IS
1537: l_proc CONSTANT VARCHAR2(50):= g_package||'insert_archive_row';

Line 1547: pay_action_information_api.create_action_information(

1543: for i in p_tab_rec_data.first .. p_tab_rec_data.last loop
1544: hr_utility.trace('Defining category '|| p_tab_rec_data(i).action_info_category);
1545: hr_utility.trace('action_context_id = '|| p_assactid);
1546: if p_tab_rec_data(i).action_info_category is not null then
1547: pay_action_information_api.create_action_information(
1548: p_action_information_id => l_action_id,
1549: p_object_version_number => l_ovn,
1550: p_action_information_category => p_tab_rec_data(i).action_info_category,
1551: p_action_context_id => p_assactid,

Line 2856: from pay_action_information pai_emp,

2852: pai_emp.action_information17 emp_no1,
2853: to_char(to_date(substr(pai_asg.action_information5,1,10),'YYYY-MM-DD'),'DD-MON-RRRR') start_date,
2854: to_char(to_date(substr(pai_asg.action_information6,1,10),'YYYY-MM-DD'),'DD-MON-RRRR') end_date,
2855: pai_emp.action_information17 emp_no2
2856: from pay_action_information pai_emp,
2857: pay_action_information pai_asg,
2858: pay_assignment_actions paa
2859: where paa.payroll_action_id = pactid and paa.ACTION_STATUS = 'C' and paa.assignment_id = c_assignment_id
2860: and pai_emp.action_context_id = paa.assignment_action_id

Line 2857: pay_action_information pai_asg,

2853: to_char(to_date(substr(pai_asg.action_information5,1,10),'YYYY-MM-DD'),'DD-MON-RRRR') start_date,
2854: to_char(to_date(substr(pai_asg.action_information6,1,10),'YYYY-MM-DD'),'DD-MON-RRRR') end_date,
2855: pai_emp.action_information17 emp_no2
2856: from pay_action_information pai_emp,
2857: pay_action_information pai_asg,
2858: pay_assignment_actions paa
2859: where paa.payroll_action_id = pactid and paa.ACTION_STATUS = 'C' and paa.assignment_id = c_assignment_id
2860: and pai_emp.action_context_id = paa.assignment_action_id
2861: and pai_emp.action_information_category = 'GB RTI EMPLOYEE DETAILS'

Line 3101: delete from pay_action_information pai

3097: BEGIN
3098: hr_utility.trace('Entering deinit: '||l_proc);
3099:
3100: -- To avoid re-archiving while Retry
3101: delete from pay_action_information pai
3102: where pai.action_context_id = pactid
3103: and pai.action_context_type = 'PA'
3104: and pai.action_information_category in ('RTI PAYROLL INFO');
3105:

Line 3120: pay_action_information_api.create_action_information (

3116: hr_utility.set_location('l_request_id = '||l_payroll_rec.request_id,50);
3117:
3118: hr_utility.set_location('Archiving RTI PAYROLL INFO',60);
3119:
3120: pay_action_information_api.create_action_information (
3121: p_action_information_id => l_action_info_id
3122: , p_action_context_id => pactid
3123: , p_action_context_type => 'PA'
3124: , p_object_version_number => l_ovn