eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QP_PURGE_ENTITY dependencies on QP_ARCH_LIST_LINES

Line 144: --Delete from QP_ARCH_LIST_LINES

140: IF SQL%FOUND THEN
141: COMMIT;
142: END IF;
143:
144: --Delete from QP_ARCH_LIST_LINES
145:
146: DELETE QP_ARCH_LIST_LINES WHERE ARCH_PURG_REQUEST_ID = l_request_id;
147: IF SQL%FOUND THEN
148: COMMIT;

Line 146: DELETE QP_ARCH_LIST_LINES WHERE ARCH_PURG_REQUEST_ID = l_request_id;

142: END IF;
143:
144: --Delete from QP_ARCH_LIST_LINES
145:
146: DELETE QP_ARCH_LIST_LINES WHERE ARCH_PURG_REQUEST_ID = l_request_id;
147: IF SQL%FOUND THEN
148: COMMIT;
149: END IF;
150:

Line 238: --Delete from QP_ARCH_LIST_LINES

234: END IF;
235: COMMIT;
236: END LOOP;
237:
238: --Delete from QP_ARCH_LIST_LINES
239:
240: LOOP
241: DELETE QP_ARCH_LIST_LINES WHERE ARCH_PURG_REQUEST_ID in (select c.request_id from
242: QP_ARCH_CRITERIA_LINES a , QP_ARCH_CRITERIA_LINES b ,QP_ARCH_CRITERIA_HEADERS c

Line 241: DELETE QP_ARCH_LIST_LINES WHERE ARCH_PURG_REQUEST_ID in (select c.request_id from

237:
238: --Delete from QP_ARCH_LIST_LINES
239:
240: LOOP
241: DELETE QP_ARCH_LIST_LINES WHERE ARCH_PURG_REQUEST_ID in (select c.request_id from
242: QP_ARCH_CRITERIA_LINES a , QP_ARCH_CRITERIA_LINES b ,QP_ARCH_CRITERIA_HEADERS c
243: where c.request_id = a.request_id and
244: a.REQUEST_ID = b.REQUEST_ID
245: and c.purge_flag = 'N'

Line 386: --Delete from QP_ARCH_LIST_LINES

382: END IF;
383: COMMIT;
384: END LOOP;
385:
386: --Delete from QP_ARCH_LIST_LINES
387:
388: LOOP
389: DELETE QP_ARCH_LIST_LINES
390: WHERE ARCH_PURG_REQUEST_ID in (select request_id from QP_ARCH_CRITERIA_HEADERS

Line 389: DELETE QP_ARCH_LIST_LINES

385:
386: --Delete from QP_ARCH_LIST_LINES
387:
388: LOOP
389: DELETE QP_ARCH_LIST_LINES
390: WHERE ARCH_PURG_REQUEST_ID in (select request_id from QP_ARCH_CRITERIA_HEADERS
391: where trunc(creation_date) between trunc(fnd_date.canonical_to_date(p_archive_start_date))
392: and trunc(fnd_date.canonical_to_date(p_archive_end_date)) and purge_flag = 'N' and REQUEST_TYPE = 'ARCHIVE' and source_system= p_source_system_code)
393: AND rownum <= 500;