APPS.QP_PURGE_PRICING_REQUESTS dependencies on QP_DEBUG_REQ_LDETS

Line 50: DELETE QP_DEBUG_REQ_LDETS WHERE request_id in

46: COMMIT;
47: END LOOP;
48:
49: LOOP
50: DELETE QP_DEBUG_REQ_LDETS WHERE request_id in
51: (SELECT request_id FROM qp_debug_req
52: WHERE TO_DATE(creation_date, 'DD-MM-YYYY') <=
53: TO_DATE((SYSDATE - l_no_of_days), 'DD-MM-YYYY') AND
54: request_name like l_request_name

Line 158: DELETE QP_DEBUG_REQ_LDETS WHERE request_id in

154: COMMIT;
155: END LOOP;
156:
157: LOOP
158: DELETE QP_DEBUG_REQ_LDETS WHERE request_id in
159: (SELECT request_id FROM qp_debug_req
160: WHERE TO_DATE(creation_date, 'DD-MM-YYYY') <=
161: TO_DATE((SYSDATE - l_no_of_days), 'DD-MM-YYYY')
162: ) AND rownum <= 500;

Line 260: DELETE QP_DEBUG_REQ_LDETS WHERE request_id in

256: COMMIT;
257: END LOOP;
258:
259: LOOP
260: DELETE QP_DEBUG_REQ_LDETS WHERE request_id in
261: (SELECT request_id FROM qp_debug_req
262: WHERE request_name like l_request_name
263: ) AND rownum <= 500;
264:

Line 344: l_stmt := 'TRUNCATE TABLE ' || l_qp_schema || '.QP_DEBUG_REQ_LDETS';

340:
341: l_stmt := 'TRUNCATE TABLE ' || l_qp_schema || '.QP_DEBUG_REQ_LINES';
342: EXECUTE IMMEDIATE l_stmt;
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;