APPS.AP_WEB_ARCHIVE_PURGE_ER dependencies on AP_EXPENSE_REPORT_HEADERS_ARC

Line 74: insert into ap_expense_report_headers_arc (

70: ---------------------------------------------------------------------
71: l_debug_info := 'Insert into Headers.';
72: ---------------------------------------------------------------------
73:
74: insert into ap_expense_report_headers_arc (
75: ARC_REQ_ID,
76: ARCHIVE_DATE,
77: REPORT_HEADER_ID,
78: EMPLOYEE_ID,

Line 1426: from ap_expense_report_headers_arc

1422:
1423: l_debug_info VARCHAR2(2000);
1424: CURSOR c_exp_reports(l_request_id IN NUMBER) is
1425: select report_header_id
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

Line 1432: l_report_header_id ap_expense_report_headers_arc.report_header_id%TYPE;

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;
1435: l_wf_active BOOLEAN := FALSE;
1436: l_wf_exist BOOLEAN := FALSE;

Line 1595: FROM ap_expense_report_headers_arc

1591:
1592: DELETE FROM ap_expense_report_headers_all
1593: WHERE report_header_id IN (
1594: SELECT report_header_id
1595: FROM ap_expense_report_headers_arc
1596: WHERE arc_req_id = p_request_id);
1597:
1598: fnd_file.put_line(fnd_file.log,'Purged ' || SQL%ROWCOUNT || ' Headers');
1599: