APPS.QP_PURGE_PRICING_REQUESTS dependencies on QP_DEBUG_REQ_LINE_ATTRS

Line 64: DELETE QP_DEBUG_REQ_LINE_ATTRS WHERE request_id in

60: COMMIT;
61: END LOOP;
62:
63: LOOP
64: DELETE QP_DEBUG_REQ_LINE_ATTRS WHERE request_id in
65: (SELECT request_id FROM qp_debug_req
66: WHERE TO_DATE(creation_date, 'DD-MM-YYYY') <=
67: TO_DATE((SYSDATE - l_no_of_days), 'DD-MM-YYYY') AND
68: request_name like l_request_name

Line 171: DELETE QP_DEBUG_REQ_LINE_ATTRS WHERE request_id in

167: COMMIT;
168: END LOOP;
169:
170: LOOP
171: DELETE QP_DEBUG_REQ_LINE_ATTRS WHERE request_id in
172: (SELECT request_id FROM qp_debug_req
173: WHERE TO_DATE(creation_date, 'DD-MM-YYYY') <=
174: TO_DATE((SYSDATE - l_no_of_days), 'DD-MM-YYYY')
175: ) AND rownum <= 500;

Line 272: DELETE QP_DEBUG_REQ_LINE_ATTRS WHERE request_id in

268: COMMIT;
269: END LOOP;
270:
271: LOOP
272: DELETE QP_DEBUG_REQ_LINE_ATTRS WHERE request_id in
273: (SELECT request_id FROM qp_debug_req
274: WHERE request_name like l_request_name
275: ) AND rownum <= 500;
276:

Line 347: l_stmt := 'TRUNCATE TABLE ' || l_qp_schema || '.QP_DEBUG_REQ_LINE_ATTRS';

343:
344: l_stmt := 'TRUNCATE TABLE ' || l_qp_schema || '.QP_DEBUG_REQ_LDETS';
345: EXECUTE IMMEDIATE l_stmt;
346:
347: l_stmt := 'TRUNCATE TABLE ' || l_qp_schema || '.QP_DEBUG_REQ_LINE_ATTRS';
348: EXECUTE IMMEDIATE l_stmt;
349:
350: l_stmt := 'TRUNCATE TABLE ' || l_qp_schema || '.QP_DEBUG_REQ_RLTD_LINES';
351: EXECUTE IMMEDIATE l_stmt;