APPS.PAY_CORE_XDO_UTILS dependencies on PAY_FILE_DETAILS

Line 228: /* Procedure to remove data from pay_file_details*/

224: END IF; /* print_files & xdo_run*/
225: hr_utility.trace ('Leaving '|| lv_proc_name);
226: end ARCHIVE_DEINIT;
227:
228: /* Procedure to remove data from pay_file_details*/
229: PROCEDURE del_file_details(pactid IN NUMBER) IS
230:
231: Type file_detid_list is Table of pay_file_details.file_detail_id%type;
232: fdetlst file_detid_list;

Line 231: Type file_detid_list is Table of pay_file_details.file_detail_id%type;

227:
228: /* Procedure to remove data from pay_file_details*/
229: PROCEDURE del_file_details(pactid IN NUMBER) IS
230:
231: Type file_detid_list is Table of pay_file_details.file_detail_id%type;
232: fdetlst file_detid_list;
233:
234: Cursor csr_get_file_detl(payroll_act_id in number) is
235: select file_detail_id

Line 236: from pay_file_details

232: fdetlst file_detid_list;
233:
234: Cursor csr_get_file_detl(payroll_act_id in number) is
235: select file_detail_id
236: from pay_file_details
237: where source_id = payroll_act_id
238: or source_id in (select assignment_action_id
239: from pay_assignment_actions paa
240: where payroll_action_id = payroll_act_id);

Line 247: delete from pay_file_details

243: Open csr_get_file_detl(pactid);
244: Loop
245: Fetch csr_get_file_detl bulk collect into fdetlst limit 1000;
246: forall i in 1..fdetlst.count
247: delete from pay_file_details
248: where file_detail_id = fdetlst(i);
249:
250: exit when csr_get_file_detl%notfound;
251: End loop;

Line 339: hr_utility.trace ('pay_file_details deleted');

335: where pa1.payroll_action_id = pactid;
336: --
337: if (remove_act is null or remove_act = 'Y') then
338: del_file_details(pactid);
339: hr_utility.trace ('pay_file_details deleted');
340: pay_archive.remove_report_actions(pactid);
341: hr_utility.trace ('Removed Payroll and assignment actions');
342: end if;
343: