APPS.AP_WEB_ARCHIVE_PURGE_ER dependencies on AP_AUD_AUDIT_REASONS

Line 1297: insert into ap_aud_audit_reasons_arc (

1293: ----------------------------------------------------------------------
1294: l_debug_info := 'Insert into Audit Reasons.';
1295: ----------------------------------------------------------------------
1296:
1297: insert into ap_aud_audit_reasons_arc (
1298: ARC_REQ_ID,
1299: ARCHIVE_DATE,
1300: AUDIT_REASON_ID,
1301: REPORT_HEADER_ID,

Line 1318: from ap_aud_audit_reasons a, AP_EXP_REPORT_HEADERS_GT gt

1314: A.CREATED_BY,
1315: A.LAST_UPDATE_LOGIN,
1316: A.LAST_UPDATE_DATE,
1317: A.LAST_UPDATED_BY
1318: from ap_aud_audit_reasons a, AP_EXP_REPORT_HEADERS_GT gt
1319: where gt.report_header_id = a.report_header_id);
1320:
1321: fnd_file.put_line(fnd_file.log,'Archived ' || SQL%ROWCOUNT || ' Audit Reasons');
1322:

Line 1475: DELETE FROM ap_aud_audit_reasons

1471: ----------------------------------------------------------------------
1472: l_debug_info := 'Delete Audit reasons.';
1473: ----------------------------------------------------------------------
1474:
1475: DELETE FROM ap_aud_audit_reasons
1476: WHERE audit_reason_id IN (
1477: SELECT audit_reason_id
1478: FROM ap_aud_audit_reasons_arc
1479: WHERE arc_req_id = p_request_id);

Line 1478: FROM ap_aud_audit_reasons_arc

1474:
1475: DELETE FROM ap_aud_audit_reasons
1476: WHERE audit_reason_id IN (
1477: SELECT audit_reason_id
1478: FROM ap_aud_audit_reasons_arc
1479: WHERE arc_req_id = p_request_id);
1480:
1481: fnd_file.put_line(fnd_file.log,'Purged ' || SQL%ROWCOUNT || ' Audit Reasons');
1482: