APPS.PO_POXREQIM_XMLP_PKG SQL Statements

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

Line: 13

        and P_delete_flag = 'Y' then
             DELETE po_interface_errors
              WHERE interface_type = 'REQIMPORT';

Line: 16

             DELETE po_requisitions_interface
              WHERE process_flag = 'ERROR';

Line: 18

              DELETE po_req_dist_interface
	      WHERE process_flag='ERROR';

Line: 24

        and P_delete_flag = 'Y' then
             DELETE po_interface_errors
              WHERE interface_type = 'REQIMPORT'
                AND interface_transaction_id IN
                   (SELECT transaction_id
                      FROM po_requisitions_interface
                     WHERE process_flag = 'ERROR'
                      AND interface_source_code = P_interface_source_code
                   );

Line: 33

             DELETE po_requisitions_interface
              WHERE process_flag = 'ERROR'
                AND interface_source_code = P_interface_source_code;

Line: 36

             DELETE po_req_dist_interface
	      WHERE process_flag='ERROR'
		AND  interface_source_code = P_interface_source_code;

Line: 42

        and P_delete_flag = 'Y' then
             DELETE po_interface_errors
              WHERE interface_type = 'REQIMPORT'
                AND interface_transaction_id IN
                   (SELECT transaction_id
                      FROM po_requisitions_interface
                     WHERE process_flag = 'ERROR'
                      AND batch_id = P_batch_id
                   );

Line: 51

             DELETE po_requisitions_interface
              WHERE process_flag = 'ERROR'
                AND batch_id = P_batch_id ;

Line: 54

             DELETE po_req_dist_interface
              WHERE process_flag='ERROR'
		AND batch_id=P_batch_id;

Line: 61

        and P_delete_flag = 'Y' then
            DELETE po_interface_errors
             WHERE interface_type = 'REQIMPORT'
               AND interface_transaction_id IN
                  (SELECT transaction_id
                     FROM po_requisitions_interface
                    WHERE process_flag = 'ERROR'
                      AND interface_source_code = P_interface_source_code
                      AND batch_id = P_batch_id
                  );

Line: 71

            DELETE po_requisitions_interface
             WHERE process_flag = 'ERROR'
               AND interface_source_code = P_interface_source_code
               AND batch_id = P_batch_id;

Line: 75

           DELETE po_req_dist_interface
	      WHERE process_flag='ERROR'
		AND interface_source_code=P_interface_source_code
		AND  batch_id=P_batch_id;