APPS.QP_PURGE_PRICING_REQUESTS SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 25

       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;

Line: 36

          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;

Line: 50

          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;

Line: 64

          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;

Line: 78

          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;

Line: 92

          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;

Line: 106

          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;

Line: 120

          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;

Line: 136

       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');

Line: 145

          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;

Line: 158

          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;

Line: 171

          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;

Line: 184

          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;

Line: 197

          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;

Line: 210

          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;

Line: 223

          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;

Line: 240

       SELECT COUNT(*) INTO l_count FROM QP_DEBUG_REQ
       WHERE request_name like l_request_name;

Line: 248

          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;

Line: 260

          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;

Line: 272

          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;

Line: 284

          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;

Line: 296

          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;

Line: 308

          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;

Line: 320

          DELETE QP_DEBUG_REQ
          WHERE request_name like l_request_name AND
                rownum <= 500;

Line: 333

       SELECT COUNT(*) INTO l_count FROM QP_DEBUG_REQ;

Line: 378

            fnd_file.put_line(FND_FILE.LOG,'No Data Found - 0 Records Deleted');

Line: 379

            err_buff := 'No Data Found - 0 Records Deleted';