APPS.AP_WEB_ARCHIVE_PURGE_ER dependencies on AP_NOTES

Line 1372: -- Insert into AP Notes

1368: where gt.report_header_id = a.report_header_id);
1369:
1370: fnd_file.put_line(fnd_file.log,'Archived ' || SQL%ROWCOUNT || ' Policy Violations');
1371:
1372: -- Insert into AP Notes
1373: ----------------------------------------------------------------------
1374: l_debug_info := 'Insert into AP Notes.';
1375: ----------------------------------------------------------------------
1376:

Line 1374: l_debug_info := 'Insert into AP Notes.';

1370: fnd_file.put_line(fnd_file.log,'Archived ' || SQL%ROWCOUNT || ' Policy Violations');
1371:
1372: -- Insert into AP Notes
1373: ----------------------------------------------------------------------
1374: l_debug_info := 'Insert into AP Notes.';
1375: ----------------------------------------------------------------------
1376:
1377: insert into ap_notes_arc (
1378: ARC_REQ_ID,

Line 1377: insert into ap_notes_arc (

1373: ----------------------------------------------------------------------
1374: l_debug_info := 'Insert into AP Notes.';
1375: ----------------------------------------------------------------------
1376:
1377: insert into ap_notes_arc (
1378: ARC_REQ_ID,
1379: ARCHIVE_DATE,
1380: NOTE_ID,
1381: SOURCE_OBJECT_CODE,

Line 1408: from ap_notes a, AP_EXP_REPORT_HEADERS_GT gt

1404: A.CREATED_BY,
1405: A.LAST_UPDATE_DATE,
1406: A.LAST_UPDATED_BY,
1407: A.LAST_UPDATE_LOGIN
1408: from ap_notes a, AP_EXP_REPORT_HEADERS_GT gt
1409: where gt.report_header_id = a.source_object_id);
1410:
1411: fnd_file.put_line(fnd_file.log,'Archived ' || SQL%ROWCOUNT || ' Notes');
1412:

Line 1444: -- Delete AP Notes.

1440: BEGIN
1441: -- The where clause in all the delete sqls below make sure that only the records
1442: -- that were archived in this run are deleted.
1443:
1444: -- Delete AP Notes.
1445: ----------------------------------------------------------------------
1446: l_debug_info := 'Delete AP Notes.';
1447: ----------------------------------------------------------------------
1448:

Line 1446: l_debug_info := 'Delete AP Notes.';

1442: -- that were archived in this run are deleted.
1443:
1444: -- Delete AP Notes.
1445: ----------------------------------------------------------------------
1446: l_debug_info := 'Delete AP Notes.';
1447: ----------------------------------------------------------------------
1448:
1449: DELETE FROM ap_notes
1450: WHERE source_object_id IN (

Line 1449: DELETE FROM ap_notes

1445: ----------------------------------------------------------------------
1446: l_debug_info := 'Delete AP Notes.';
1447: ----------------------------------------------------------------------
1448:
1449: DELETE FROM ap_notes
1450: WHERE source_object_id IN (
1451: SELECT source_object_id
1452: FROM ap_notes_arc
1453: WHERE arc_req_id = p_request_id);

Line 1452: FROM ap_notes_arc

1448:
1449: DELETE FROM ap_notes
1450: WHERE source_object_id IN (
1451: SELECT source_object_id
1452: FROM ap_notes_arc
1453: WHERE arc_req_id = p_request_id);
1454:
1455: fnd_file.put_line(fnd_file.log,'Purged ' || SQL%ROWCOUNT || ' Notes');
1456: