APPS.AP_WEB_ARCHIVE_PURGE_ER dependencies on AP_EXPENSE_REPORT_LINES_ARC

Line 317: insert into ap_expense_report_lines_arc (

313: -- Insert into Lines
314: ----------------------------------------------------------------------
315: l_debug_info := 'Insert into Lines.';
316: ----------------------------------------------------------------------
317: insert into ap_expense_report_lines_arc (
318: ARC_REQ_ID,
319: ARCHIVE_DATE,
320: REPORT_HEADER_ID,
321: LAST_UPDATE_DATE,

Line 1430: from ap_expense_report_lines_arc

1426: from ap_expense_report_headers_arc
1427: where arc_req_id = l_request_id;
1428: CURSOR c_exp_report_lines(l_request_id IN NUMBER) is
1429: select report_line_id
1430: from ap_expense_report_lines_arc
1431: where arc_req_id = l_request_id;
1432: l_report_header_id ap_expense_report_headers_arc.report_header_id%TYPE;
1433: l_report_line_id ap_expense_report_lines_arc.report_line_id%TYPE;
1434: l_childItemKeySeq NUMBER;

Line 1433: l_report_line_id ap_expense_report_lines_arc.report_line_id%TYPE;

1429: select report_line_id
1430: from ap_expense_report_lines_arc
1431: where arc_req_id = l_request_id;
1432: l_report_header_id ap_expense_report_headers_arc.report_header_id%TYPE;
1433: l_report_line_id ap_expense_report_lines_arc.report_line_id%TYPE;
1434: l_childItemKeySeq NUMBER;
1435: l_wf_active BOOLEAN := FALSE;
1436: l_wf_exist BOOLEAN := FALSE;
1437: l_end_date wf_items.end_date%TYPE;

Line 1582: FROM ap_expense_report_lines_arc

1578:
1579: DELETE FROM ap_expense_report_lines_all
1580: WHERE report_line_id IN (
1581: SELECT report_line_id
1582: FROM ap_expense_report_lines_arc
1583: WHERE arc_req_id = p_request_id);
1584:
1585: fnd_file.put_line(fnd_file.log,'Purged ' || SQL%ROWCOUNT || ' Lines');
1586: