APPS.QP_PURGE_PRICING_REQUESTS dependencies on QP_DEBUG_REQ_LINES

Line 36: DELETE QP_DEBUG_REQ_LINES WHERE request_id in

32: END IF;
33:
34:
35: LOOP
36: DELETE QP_DEBUG_REQ_LINES WHERE request_id in
37: (SELECT request_id FROM qp_debug_req
38: WHERE TO_DATE(creation_date, 'DD-MM-YYYY') <=
39: TO_DATE((SYSDATE - l_no_of_days), 'DD-MM-YYYY') AND
40: request_name like l_request_name

Line 145: DELETE QP_DEBUG_REQ_LINES WHERE request_id in

141: RAISE NO_DATA_FOUND;
142: END IF;
143:
144: LOOP
145: DELETE QP_DEBUG_REQ_LINES WHERE request_id in
146: (SELECT request_id FROM qp_debug_req
147: WHERE TO_DATE(creation_date, 'DD-MM-YYYY') <=
148: TO_DATE((SYSDATE - l_no_of_days), 'DD-MM-YYYY')
149: ) AND rownum <= 500;

Line 248: DELETE QP_DEBUG_REQ_LINES WHERE request_id in

244: RAISE NO_DATA_FOUND;
245: END IF;
246:
247: LOOP
248: DELETE QP_DEBUG_REQ_LINES WHERE request_id in
249: (SELECT request_id FROM qp_debug_req
250: WHERE request_name like l_request_name
251: ) AND rownum <= 500;
252:

Line 341: l_stmt := 'TRUNCATE TABLE ' || l_qp_schema || '.QP_DEBUG_REQ_LINES';

337: END IF;
338:
339: IF (FND_INSTALLATION.GET_APP_INFO('QP', l_status, l_industry, l_qp_schema)) THEN
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;