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,
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: