APPS.PAY_GB_ROLLBACK_PKG dependencies on PAY_GB_FPS_DETAILS

Line 18: in PAY_GB_FPS_DETAILS table.

14: 14-Sep-2012 krreddy 115.0 14576477 Created.
15: 03-Oct-2012 krreddy 115.1 14704814 Included Additional Rollback funtionality
16: for EAS Process.
17: 02-Nov-2012 ssarap 115.2 For NI only aggregation deleting the orphan data
18: in PAY_GB_FPS_DETAILS table.
19: 02-Nov-2012 kvinayku 115.3 14843731 Added one more condition to reset pensioner RTI sent flag.
20: 26-Nov-2012 sampmand 115.4 EAS 2013 Changes-Added RTI_EAS_REP_13 for new EAS program
21: 29-Nov-2012 rajganga 115.5 15914459 Fixed Rti sent for other asgs of PAYE Agg.
22: 27-Dec-2012 rajganga 115.6 15890022 FPS 2013-14 Changes.

Line 187: -- Delete from pay_gb_fps_details

183: IF l_ovn IS NOT NULL THEN
184: hr_assignment_extra_info_api.update_assignment_extra_info (p_validate => false, p_object_version_number => l_ovn, p_assignment_extra_info_id => l_aei_id, p_aei_information_category => 'GB_RTI_ASG_DETAILS', p_aei_information8 => 'N');
185: END IF;
186: END IF;
187: -- Delete from pay_gb_fps_details
188: DELETE
189: FROM pay_gb_fps_details
190: WHERE FPS_ASG_ACT_ID = archive_rec.ASSIGNMENT_ACTION_ID
191: AND ASSIGNMENT_ID = archive_rec.ASSIGNMENT_ID;

Line 189: FROM pay_gb_fps_details

185: END IF;
186: END IF;
187: -- Delete from pay_gb_fps_details
188: DELETE
189: FROM pay_gb_fps_details
190: WHERE FPS_ASG_ACT_ID = archive_rec.ASSIGNMENT_ACTION_ID
191: AND ASSIGNMENT_ID = archive_rec.ASSIGNMENT_ID;
192: END LOOP;
193: FOR del_rec IN csr_get_all_actions

Line 195: -- Delete from pay_gb_fps_details

191: AND ASSIGNMENT_ID = archive_rec.ASSIGNMENT_ID;
192: END LOOP;
193: FOR del_rec IN csr_get_all_actions
194: loop
195: -- Delete from pay_gb_fps_details
196: DELETE
197: FROM pay_gb_fps_details
198: WHERE FPS_ASG_ACT_ID = del_rec.ASSIGNMENT_ACTION_ID
199: AND ASSIGNMENT_ID = del_rec.ASSIGNMENT_ID;

Line 197: FROM pay_gb_fps_details

193: FOR del_rec IN csr_get_all_actions
194: loop
195: -- Delete from pay_gb_fps_details
196: DELETE
197: FROM pay_gb_fps_details
198: WHERE FPS_ASG_ACT_ID = del_rec.ASSIGNMENT_ACTION_ID
199: AND ASSIGNMENT_ID = del_rec.ASSIGNMENT_ID;
200: end loop;
201: ELSE -- for IF (p_asgactid is null) THEN condition

Line 232: -- Delete from pay_gb_fps_details

228: IF l_ovn IS NOT NULL THEN
229: hr_assignment_extra_info_api.update_assignment_extra_info (p_validate => false, p_object_version_number => l_ovn, p_assignment_extra_info_id => l_aei_id, p_aei_information_category => 'GB_RTI_ASG_DETAILS', p_aei_information8 => 'N');
230: END IF;
231: END IF;
232: -- Delete from pay_gb_fps_details
233: DELETE
234: FROM pay_gb_fps_details
235: WHERE FPS_ASG_ACT_ID = l_asgact_rec.ASSIGNMENT_ACTION_ID
236: AND ASSIGNMENT_ID = l_asgact_rec.ASSIGNMENT_ID;

Line 234: FROM pay_gb_fps_details

230: END IF;
231: END IF;
232: -- Delete from pay_gb_fps_details
233: DELETE
234: FROM pay_gb_fps_details
235: WHERE FPS_ASG_ACT_ID = l_asgact_rec.ASSIGNMENT_ACTION_ID
236: AND ASSIGNMENT_ID = l_asgact_rec.ASSIGNMENT_ID;
237: CLOSE csr_archive_asgact_details;
238: