APPS.QP_PURGE_PRICING_REQUESTS dependencies on QP_DEBUG_REQ_RLTD_LINES

Line 78: DELETE QP_DEBUG_REQ_RLTD_LINES WHERE request_id in

74: COMMIT;
75: END LOOP;
76:
77: LOOP
78: DELETE QP_DEBUG_REQ_RLTD_LINES WHERE request_id in
79: (SELECT request_id FROM qp_debug_req
80: WHERE TO_DATE(creation_date, 'DD-MM-YYYY') <=
81: TO_DATE((SYSDATE - l_no_of_days), 'DD-MM-YYYY') AND
82: request_name like l_request_name

Line 184: DELETE QP_DEBUG_REQ_RLTD_LINES WHERE request_id in

180: COMMIT;
181: END LOOP;
182:
183: LOOP
184: DELETE QP_DEBUG_REQ_RLTD_LINES WHERE request_id in
185: (SELECT request_id FROM qp_debug_req
186: WHERE TO_DATE(creation_date, 'DD-MM-YYYY') <=
187: TO_DATE((SYSDATE - l_no_of_days), 'DD-MM-YYYY')
188: ) AND rownum <= 500;

Line 284: DELETE QP_DEBUG_REQ_RLTD_LINES WHERE request_id in

280: COMMIT;
281: END LOOP;
282:
283: LOOP
284: DELETE QP_DEBUG_REQ_RLTD_LINES WHERE request_id in
285: (SELECT request_id FROM qp_debug_req
286: WHERE request_name like l_request_name
287: ) AND rownum <= 500;
288:

Line 350: l_stmt := 'TRUNCATE TABLE ' || l_qp_schema || '.QP_DEBUG_REQ_RLTD_LINES';

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;
352:
353: l_stmt := 'TRUNCATE TABLE ' || l_qp_schema || '.QP_DEBUG_FORMULA_STEP_VALUES';
354: EXECUTE IMMEDIATE l_stmt;