eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_GB_RTI_FPS_ARCHIVE dependencies on PAY_ACTION_INFORMATION

Line 2123: from pay_action_information

2119: --Below cursor fetches the New Asg Number reported in Last FPS
2120: CURSOR csr_last_asg_num_submitted(c_last_fps_asg_act_id NUMBER, c_asg_id NUMBER)
2121: IS
2122: select ACTION_INFORMATION13
2123: from pay_action_information
2124: where action_context_id = c_last_fps_asg_act_id
2125: and action_information_category = 'GB_RTI_FPS_ASG_DET1'
2126: and assignment_id = c_asg_id;
2127:

Line 2899: from pay_action_information

2895: --Below cursor fetches the New Asg Number reported in Last FPS
2896: CURSOR csr_last_asg_num_submitted(c_last_fps_asg_act_id NUMBER, c_asg_id NUMBER)
2897: IS
2898: select ACTION_INFORMATION13
2899: from pay_action_information
2900: where action_context_id = c_last_fps_asg_act_id
2901: and action_information_category = 'GB_RTI_FPS_ASG_DET1'
2902: and assignment_id = c_asg_id;
2903:

Line 3702: from pay_action_information

3698: --Below cursor fetches the New Asg Number reported in Last FPS
3699: CURSOR csr_last_asg_num_submitted(c_last_fps_asg_act_id NUMBER, c_asg_id NUMBER)
3700: IS
3701: select ACTION_INFORMATION13
3702: from pay_action_information
3703: where action_context_id = c_last_fps_asg_act_id
3704: and action_information_category = 'GB_RTI_FPS_ASG_DET1'
3705: and assignment_id = c_asg_id;
3706:

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

6480:
6481: hr_utility.trace('Leaving set_address_fields');
6482: end set_address_fields;
6483:
6484: -- Procedure to insert data to the archive table pay_action_information
6485: PROCEDURE insert_archive_row
6486: (
6487: p_assactid IN NUMBER,
6488: p_effective_date IN DATE,

Line 6508: pay_action_information_api.create_action_information( p_action_information_id => l_action_id,

6504: )
6505: ;
6506: hr_utility.trace('action_context_id = '|| p_assactid);
6507: IF p_tab_rec_data(i).action_info_category IS NOT NULL THEN
6508: pay_action_information_api.create_action_information( p_action_information_id => l_action_id,
6509: p_object_version_number => l_ovn,
6510: p_action_information_category => p_tab_rec_data(i).action_info_category,
6511: p_action_context_id => p_assactid,
6512: p_action_context_type => 'AAP',

Line 6550: -- Procedure to insert data to the archive table pay_action_information.

6546: END LOOP;
6547: END IF;
6548: hr_utility.set_location('Leaving: '||l_proc,999);
6549: END insert_archive_row;
6550: -- Procedure to insert data to the archive table pay_action_information.
6551: -- This is used in PAYE aggregation case inaddition to the procedure insert_archive_row
6552: PROCEDURE insert_archive_row_agg
6553: (
6554: p_assactid IN NUMBER,

Line 6581: pay_action_information_api.create_action_information( p_action_information_id => l_action_id,

6577: select paa.assignment_action_id into l_assact_id from pay_assignment_actions paa
6578: where paa.payroll_action_id = g_payroll_action_id
6579: and paa.assignment_id = p_tab_rec_data(i).assignment_id;
6580:
6581: pay_action_information_api.create_action_information( p_action_information_id => l_action_id,
6582: p_object_version_number => l_ovn,
6583: p_action_information_category => p_tab_rec_data(i).action_info_category,
6584: p_action_context_id => l_assact_id,
6585: p_action_context_type => 'AAP',

Line 8945: FROM pay_action_information pai

8941: action_information29,
8942: action_information30,
8943: effective_date,
8944: assignment_id
8945: FROM pay_action_information pai
8946: WHERE pai.action_context_id = p_assignment_action_id
8947: AND pai.action_context_type = 'AAP'
8948: AND pai.action_information_category = p_act_info_cat;
8949:

Line 8954: FROM pay_action_information pai

8950: --Below cursor fetches archived records count
8951: CURSOR csr_archived_records_count(p_assignment_action_id NUMBER)
8952: IS
8953: SELECT COUNT(*)
8954: FROM pay_action_information pai
8955: WHERE pai.action_context_id = p_assignment_action_id;
8956:
8957: CURSOR csr_bacs_payment_exists (c_prepay_payroll_action_id NUMBER,
8958: c_prepay_asg_action_id NUMBER)

Line 9199: from pay_action_information where action_context_id = (select max(FPS_ASG_ACT_ID) from pay_gb_fps_details where assignment_id = c_asg_id

9195: ,ACTION_INFORMATION27
9196: ,ACTION_INFORMATION28
9197: ,ACTION_INFORMATION29
9198: ,ACTION_INFORMATION30
9199: from pay_action_information where action_context_id = (select max(FPS_ASG_ACT_ID) from pay_gb_fps_details where assignment_id = c_asg_id
9200: and FPS_PAY_ACT_ID <> g_payroll_action_id) --= 9789749
9201: and ACTION_CONTEXT_TYPE = 'AAP' and
9202: ACTION_INFORMATION_CATEGORY in( 'GB_RTI_FPS_ASG_DET1', 'GB_RTI_FPS_ASG_DET2');
9203:

Line 13622: delete from pay_action_information pai

13618: BEGIN
13619: hr_utility.trace('Entering deinit: '||l_proc);
13620:
13621: -- To avoid re-archiving while Retry
13622: delete from pay_action_information pai
13623: where pai.action_context_id = pactid
13624: and pai.action_context_type = 'PA'
13625: and pai.action_information_category in ('RTI PAYROLL INFO');
13626:

Line 13627: delete from pay_action_information pai

13623: where pai.action_context_id = pactid
13624: and pai.action_context_type = 'PA'
13625: and pai.action_information_category in ('RTI PAYROLL INFO');
13626:
13627: delete from pay_action_information pai
13628: where pai.action_context_id = pactid
13629: and pai.action_context_type = 'PA'
13630: and pai.action_information_category in ('GB_RTI_FPS_EXTRA_DET');
13631:

Line 13671: pay_action_information_api.create_action_information ( p_action_information_id => l_action_info_id ,

13667: hr_utility.set_location('g_start_year = '||g_start_year,60);
13668:
13669: hr_utility.set_location('Archiving RTI PAYROLL INFO',60);
13670:
13671: pay_action_information_api.create_action_information ( p_action_information_id => l_action_info_id ,
13672: p_action_context_id => pactid ,
13673: p_action_context_type => 'PA' ,
13674: p_object_version_number => l_ovn ,
13675: p_source_id => NULL ,

Line 13692: pay_action_information_api.create_action_information ( p_action_information_id => l_action_info_id ,

13688: p_action_information15 => to_char(g_end_year,'RRRR'),
13689: p_action_information16 => l_tax_details.sautr,
13690: p_action_information17 => l_tax_details.cotaxref);
13691: ---
13692: pay_action_information_api.create_action_information ( p_action_information_id => l_action_info_id ,
13693: p_action_context_id => pactid ,
13694: p_action_context_type => 'PA' ,
13695: p_object_version_number => l_ovn ,
13696: p_source_id => NULL ,