APPS.PAY_CORE_XDO_UTILS dependencies on PAY_FILE_DETAILS

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

210: END IF; /* print_files & xdo_run*/
211: hr_utility.trace ('Leaving '|| lv_proc_name);
212: end ARCHIVE_DEINIT;
213:
214: /* Procedure to remove data from pay_file_details*/
215: PROCEDURE del_file_details(pactid IN NUMBER) IS
216:
217: Type file_detid_list is Table of pay_file_details.file_detail_id%type;
218: fdetlst file_detid_list;

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

213:
214: /* Procedure to remove data from pay_file_details*/
215: PROCEDURE del_file_details(pactid IN NUMBER) IS
216:
217: Type file_detid_list is Table of pay_file_details.file_detail_id%type;
218: fdetlst file_detid_list;
219:
220: Cursor csr_get_file_detl(payroll_act_id in number) is
221: select file_detail_id

Line 222: from pay_file_details

218: fdetlst file_detid_list;
219:
220: Cursor csr_get_file_detl(payroll_act_id in number) is
221: select file_detail_id
222: from pay_file_details
223: where source_id = payroll_act_id
224: or source_id in (select assignment_action_id
225: from pay_assignment_actions paa
226: where payroll_action_id = payroll_act_id);

Line 233: delete from pay_file_details

229: Open csr_get_file_detl(pactid);
230: Loop
231: Fetch csr_get_file_detl bulk collect into fdetlst limit 1000;
232: forall i in 1..fdetlst.count
233: delete from pay_file_details
234: where file_detail_id = fdetlst(i);
235:
236: exit when csr_get_file_detl%notfound;
237: End loop;

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

321: where pa1.payroll_action_id = pactid;
322: --
323: if (remove_act is null or remove_act = 'Y') then
324: del_file_details(pactid);
325: hr_utility.trace ('pay_file_details deleted');
326: pay_archive.remove_report_actions(pactid);
327: hr_utility.trace ('Removed Payroll and assignment actions');
328: end if;
329: