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_PRICING_ATTRIBUTES

Line 151: --Delete from QP_ARCH_PRICING_ATTRIBUTES

147: IF SQL%FOUND THEN
148: COMMIT;
149: END IF;
150:
151: --Delete from QP_ARCH_PRICING_ATTRIBUTES
152:
153: DELETE QP_ARCH_PRICING_ATTRIBUTES WHERE ARCH_PURG_REQUEST_ID = l_request_id;
154: IF SQL%FOUND THEN
155: COMMIT;

Line 153: DELETE QP_ARCH_PRICING_ATTRIBUTES WHERE ARCH_PURG_REQUEST_ID = l_request_id;

149: END IF;
150:
151: --Delete from QP_ARCH_PRICING_ATTRIBUTES
152:
153: DELETE QP_ARCH_PRICING_ATTRIBUTES WHERE ARCH_PURG_REQUEST_ID = l_request_id;
154: IF SQL%FOUND THEN
155: COMMIT;
156: END IF;
157:

Line 257: --Delete from QP_ARCH_PRICING_ATTRIBUTES

253: END IF;
254: COMMIT;
255: END LOOP;
256:
257: --Delete from QP_ARCH_PRICING_ATTRIBUTES
258:
259: LOOP
260: DELETE QP_ARCH_PRICING_ATTRIBUTES WHERE ARCH_PURG_REQUEST_ID in (select c.request_id from
261: QP_ARCH_CRITERIA_LINES a , QP_ARCH_CRITERIA_LINES b ,QP_ARCH_CRITERIA_HEADERS c

Line 260: DELETE QP_ARCH_PRICING_ATTRIBUTES WHERE ARCH_PURG_REQUEST_ID in (select c.request_id from

256:
257: --Delete from QP_ARCH_PRICING_ATTRIBUTES
258:
259: LOOP
260: DELETE QP_ARCH_PRICING_ATTRIBUTES WHERE ARCH_PURG_REQUEST_ID in (select c.request_id from
261: QP_ARCH_CRITERIA_LINES a , QP_ARCH_CRITERIA_LINES b ,QP_ARCH_CRITERIA_HEADERS c
262: where c.request_id = a.request_id and
263: a.REQUEST_ID = b.REQUEST_ID
264: and c.purge_flag = 'N'

Line 401: --Delete from QP_ARCH_PRICING_ATTRIBUTES

397: END IF;
398: COMMIT;
399: END LOOP;
400:
401: --Delete from QP_ARCH_PRICING_ATTRIBUTES
402:
403: LOOP
404: DELETE QP_ARCH_PRICING_ATTRIBUTES
405: WHERE ARCH_PURG_REQUEST_ID in (select request_id from QP_ARCH_CRITERIA_HEADERS

Line 404: DELETE QP_ARCH_PRICING_ATTRIBUTES

400:
401: --Delete from QP_ARCH_PRICING_ATTRIBUTES
402:
403: LOOP
404: DELETE QP_ARCH_PRICING_ATTRIBUTES
405: WHERE ARCH_PURG_REQUEST_ID in (select request_id from QP_ARCH_CRITERIA_HEADERS
406: where trunc(creation_date) between trunc(fnd_date.canonical_to_date(p_archive_start_date))
407: 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)
408: AND rownum <= 500;