DBA Data[Home] [Help]

APPS.AP_WEB_ARCHIVE_PURGE_ER dependencies on AP_NOTES_ARC

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