APPS.QP_PURGE_PRICING_REQUESTS dependencies on QP_DEBUG_FORMULA_STEP_VALUES

Line 92: DELETE QP_DEBUG_FORMULA_STEP_VALUES WHERE request_id in

88: COMMIT;
89: END LOOP;
90:
91: LOOP
92: DELETE QP_DEBUG_FORMULA_STEP_VALUES WHERE request_id in
93: (SELECT request_id FROM qp_debug_req
94: WHERE TO_DATE(creation_date, 'DD-MM-YYYY') <=
95: TO_DATE((SYSDATE - l_no_of_days), 'DD-MM-YYYY') AND
96: request_name like l_request_name

Line 197: DELETE QP_DEBUG_FORMULA_STEP_VALUES WHERE request_id in

193: COMMIT;
194: END LOOP;
195:
196: LOOP
197: DELETE QP_DEBUG_FORMULA_STEP_VALUES WHERE request_id in
198: (SELECT request_id FROM qp_debug_req
199: WHERE TO_DATE(creation_date, 'DD-MM-YYYY') <=
200: TO_DATE((SYSDATE - l_no_of_days), 'DD-MM-YYYY')
201: ) AND rownum <= 500;

Line 296: DELETE QP_DEBUG_FORMULA_STEP_VALUES WHERE request_id in

292: COMMIT;
293: END LOOP;
294:
295: LOOP
296: DELETE QP_DEBUG_FORMULA_STEP_VALUES WHERE request_id in
297: (SELECT request_id FROM qp_debug_req
298: WHERE request_name like l_request_name
299: ) AND rownum <= 500;
300:

Line 353: l_stmt := 'TRUNCATE TABLE ' || l_qp_schema || '.QP_DEBUG_FORMULA_STEP_VALUES';

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;
355:
356: l_stmt := 'TRUNCATE TABLE ' || l_qp_schema || '.QP_DEBUG_TEXT';
357: EXECUTE IMMEDIATE l_stmt;