The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT COUNT(*) INTO l_count FROM QP_DEBUG_REQ
WHERE TO_DATE(creation_date, 'DD-MM-YYYY') <=
TO_DATE((SYSDATE - l_no_of_days), 'DD-MM-YYYY') AND
request_name like l_request_name;
DELETE QP_DEBUG_REQ_LINES WHERE request_id in
(SELECT request_id FROM qp_debug_req
WHERE TO_DATE(creation_date, 'DD-MM-YYYY') <=
TO_DATE((SYSDATE - l_no_of_days), 'DD-MM-YYYY') AND
request_name like l_request_name
) AND rownum <= 500;
DELETE QP_DEBUG_REQ_LDETS WHERE request_id in
(SELECT request_id FROM qp_debug_req
WHERE TO_DATE(creation_date, 'DD-MM-YYYY') <=
TO_DATE((SYSDATE - l_no_of_days), 'DD-MM-YYYY') AND
request_name like l_request_name
) AND rownum <= 500;
DELETE QP_DEBUG_REQ_LINE_ATTRS WHERE request_id in
(SELECT request_id FROM qp_debug_req
WHERE TO_DATE(creation_date, 'DD-MM-YYYY') <=
TO_DATE((SYSDATE - l_no_of_days), 'DD-MM-YYYY') AND
request_name like l_request_name
) AND rownum <= 500;
DELETE QP_DEBUG_REQ_RLTD_LINES WHERE request_id in
(SELECT request_id FROM qp_debug_req
WHERE TO_DATE(creation_date, 'DD-MM-YYYY') <=
TO_DATE((SYSDATE - l_no_of_days), 'DD-MM-YYYY') AND
request_name like l_request_name
) AND rownum <= 500;
DELETE QP_DEBUG_FORMULA_STEP_VALUES WHERE request_id in
(SELECT request_id FROM qp_debug_req
WHERE TO_DATE(creation_date, 'DD-MM-YYYY') <=
TO_DATE((SYSDATE - l_no_of_days), 'DD-MM-YYYY') AND
request_name like l_request_name
) AND rownum <= 500;
DELETE QP_DEBUG_TEXT WHERE request_id in
(SELECT request_id FROM qp_debug_req
WHERE TO_DATE(creation_date, 'DD-MM-YYYY') <=
TO_DATE((SYSDATE - l_no_of_days), 'DD-MM-YYYY') AND
request_name like l_request_name
) AND rownum <= 500;
DELETE QP_DEBUG_REQ
WHERE TO_DATE(creation_date, 'DD-MM-YYYY') <=
TO_DATE((SYSDATE - l_no_of_days), 'DD-MM-YYYY') AND
request_name like l_request_name AND
rownum <= 500;
SELECT COUNT(*) INTO l_count FROM QP_DEBUG_REQ
WHERE TO_DATE(creation_date, 'DD-MM-YYYY') <=
TO_DATE((SYSDATE - l_no_of_days), 'DD-MM-YYYY');
DELETE QP_DEBUG_REQ_LINES WHERE request_id in
(SELECT request_id FROM qp_debug_req
WHERE TO_DATE(creation_date, 'DD-MM-YYYY') <=
TO_DATE((SYSDATE - l_no_of_days), 'DD-MM-YYYY')
) AND rownum <= 500;
DELETE QP_DEBUG_REQ_LDETS WHERE request_id in
(SELECT request_id FROM qp_debug_req
WHERE TO_DATE(creation_date, 'DD-MM-YYYY') <=
TO_DATE((SYSDATE - l_no_of_days), 'DD-MM-YYYY')
) AND rownum <= 500;
DELETE QP_DEBUG_REQ_LINE_ATTRS WHERE request_id in
(SELECT request_id FROM qp_debug_req
WHERE TO_DATE(creation_date, 'DD-MM-YYYY') <=
TO_DATE((SYSDATE - l_no_of_days), 'DD-MM-YYYY')
) AND rownum <= 500;
DELETE QP_DEBUG_REQ_RLTD_LINES WHERE request_id in
(SELECT request_id FROM qp_debug_req
WHERE TO_DATE(creation_date, 'DD-MM-YYYY') <=
TO_DATE((SYSDATE - l_no_of_days), 'DD-MM-YYYY')
) AND rownum <= 500;
DELETE QP_DEBUG_FORMULA_STEP_VALUES WHERE request_id in
(SELECT request_id FROM qp_debug_req
WHERE TO_DATE(creation_date, 'DD-MM-YYYY') <=
TO_DATE((SYSDATE - l_no_of_days), 'DD-MM-YYYY')
) AND rownum <= 500;
DELETE QP_DEBUG_TEXT WHERE request_id in
(SELECT request_id FROM qp_debug_req
WHERE TO_DATE(creation_date, 'DD-MM-YYYY') <=
TO_DATE((SYSDATE - l_no_of_days), 'DD-MM-YYYY')
) AND rownum <= 500;
DELETE QP_DEBUG_REQ
WHERE TO_DATE(creation_date, 'DD-MM-YYYY') <=
TO_DATE((SYSDATE - l_no_of_days), 'DD-MM-YYYY') AND
rownum <= 500;
SELECT COUNT(*) INTO l_count FROM QP_DEBUG_REQ
WHERE request_name like l_request_name;
DELETE QP_DEBUG_REQ_LINES WHERE request_id in
(SELECT request_id FROM qp_debug_req
WHERE request_name like l_request_name
) AND rownum <= 500;
DELETE QP_DEBUG_REQ_LDETS WHERE request_id in
(SELECT request_id FROM qp_debug_req
WHERE request_name like l_request_name
) AND rownum <= 500;
DELETE QP_DEBUG_REQ_LINE_ATTRS WHERE request_id in
(SELECT request_id FROM qp_debug_req
WHERE request_name like l_request_name
) AND rownum <= 500;
DELETE QP_DEBUG_REQ_RLTD_LINES WHERE request_id in
(SELECT request_id FROM qp_debug_req
WHERE request_name like l_request_name
) AND rownum <= 500;
DELETE QP_DEBUG_FORMULA_STEP_VALUES WHERE request_id in
(SELECT request_id FROM qp_debug_req
WHERE request_name like l_request_name
) AND rownum <= 500;
DELETE QP_DEBUG_TEXT WHERE request_id in
(SELECT request_id FROM qp_debug_req
WHERE request_name like l_request_name
) AND rownum <= 500;
DELETE QP_DEBUG_REQ
WHERE request_name like l_request_name AND
rownum <= 500;
SELECT COUNT(*) INTO l_count FROM QP_DEBUG_REQ;
fnd_file.put_line(FND_FILE.LOG,'No Data Found - 0 Records Deleted');
err_buff := 'No Data Found - 0 Records Deleted';