APPS.QP_PURGE_PRICING_REQUESTS dependencies on QP_DEBUG_TEXT

Line 106: DELETE QP_DEBUG_TEXT WHERE request_id in

102: COMMIT;
103: END LOOP;
104:
105: LOOP
106: DELETE QP_DEBUG_TEXT WHERE request_id in
107: (SELECT request_id FROM qp_debug_req
108: WHERE TO_DATE(creation_date, 'DD-MM-YYYY') <=
109: TO_DATE((SYSDATE - l_no_of_days), 'DD-MM-YYYY') AND
110: request_name like l_request_name

Line 210: DELETE QP_DEBUG_TEXT WHERE request_id in

206: COMMIT;
207: END LOOP;
208:
209: LOOP
210: DELETE QP_DEBUG_TEXT WHERE request_id in
211: (SELECT request_id FROM qp_debug_req
212: WHERE TO_DATE(creation_date, 'DD-MM-YYYY') <=
213: TO_DATE((SYSDATE - l_no_of_days), 'DD-MM-YYYY')
214: ) AND rownum <= 500;

Line 308: DELETE QP_DEBUG_TEXT WHERE request_id in

304: COMMIT;
305: END LOOP;
306:
307: LOOP
308: DELETE QP_DEBUG_TEXT WHERE request_id in
309: (SELECT request_id FROM qp_debug_req
310: WHERE request_name like l_request_name
311: ) AND rownum <= 500;
312:

Line 356: l_stmt := 'TRUNCATE TABLE ' || l_qp_schema || '.QP_DEBUG_TEXT';

352:
353: l_stmt := 'TRUNCATE TABLE ' || l_qp_schema || '.QP_DEBUG_FORMULA_STEP_VALUES';
354: EXECUTE IMMEDIATE l_stmt;
355:
356: l_stmt := 'TRUNCATE TABLE ' || l_qp_schema || '.QP_DEBUG_TEXT';
357: EXECUTE IMMEDIATE l_stmt;
358:
359: l_stmt := 'TRUNCATE TABLE ' || l_qp_schema || '.QP_DEBUG_REQ';
360: EXECUTE IMMEDIATE l_stmt;