APPS.QP_PURGE_ENTITY dependencies on QP_ARCH_RLTD_MODIFIERS

Line 158: --Delete from QP_ARCH_RLTD_MODIFIERS

154: IF SQL%FOUND THEN
155: COMMIT;
156: END IF;
157:
158: --Delete from QP_ARCH_RLTD_MODIFIERS
159:
160: DELETE QP_ARCH_RLTD_MODIFIERS WHERE ARCH_PURG_REQUEST_ID = l_request_id;
161: IF SQL%FOUND THEN
162: COMMIT;

Line 160: DELETE QP_ARCH_RLTD_MODIFIERS WHERE ARCH_PURG_REQUEST_ID = l_request_id;

156: END IF;
157:
158: --Delete from QP_ARCH_RLTD_MODIFIERS
159:
160: DELETE QP_ARCH_RLTD_MODIFIERS WHERE ARCH_PURG_REQUEST_ID = l_request_id;
161: IF SQL%FOUND THEN
162: COMMIT;
163: END IF;
164:

Line 276: --Delete from QP_ARCH_RLTD_MODIFIERS

272: END IF;
273: COMMIT;
274: END LOOP;
275:
276: --Delete from QP_ARCH_RLTD_MODIFIERS
277:
278: LOOP
279: DELETE QP_ARCH_RLTD_MODIFIERS WHERE ARCH_PURG_REQUEST_ID in
280: (select c.request_id from

Line 279: DELETE QP_ARCH_RLTD_MODIFIERS WHERE ARCH_PURG_REQUEST_ID in

275:
276: --Delete from QP_ARCH_RLTD_MODIFIERS
277:
278: LOOP
279: DELETE QP_ARCH_RLTD_MODIFIERS WHERE ARCH_PURG_REQUEST_ID in
280: (select c.request_id from
281: QP_ARCH_CRITERIA_LINES a , QP_ARCH_CRITERIA_LINES b ,QP_ARCH_CRITERIA_HEADERS c
282: where c.request_id = a.request_id and
283: a.REQUEST_ID = b.REQUEST_ID

Line 416: --Delete from QP_ARCH_RLTD_MODIFIERS

412: END IF;
413: COMMIT;
414: END LOOP;
415:
416: --Delete from QP_ARCH_RLTD_MODIFIERS
417:
418: LOOP
419: DELETE QP_ARCH_RLTD_MODIFIERS
420: WHERE ARCH_PURG_REQUEST_ID in (select request_id from QP_ARCH_CRITERIA_HEADERS

Line 419: DELETE QP_ARCH_RLTD_MODIFIERS

415:
416: --Delete from QP_ARCH_RLTD_MODIFIERS
417:
418: LOOP
419: DELETE QP_ARCH_RLTD_MODIFIERS
420: WHERE ARCH_PURG_REQUEST_ID in (select request_id from QP_ARCH_CRITERIA_HEADERS
421: where trunc(creation_date) between trunc(fnd_date.canonical_to_date(p_archive_start_date))
422: 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)
423: AND rownum <= 500;