APPS.RCV_GARBAGE_COLLECTOR_SV SQL Statements

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

Line: 23

SELECT   rhi.header_interface_id,
         COUNT (rti.interface_transaction_id) error_count
FROM     rcv_transactions_interface rti,
         rcv_headers_interface rhi
WHERE    rhi.header_interface_id = rti.header_interface_id
AND      rhi.processing_status_code = 'PENDING'
AND      (rti.document_num IS NOT NULL OR rti.oe_order_num IS NOT NULL)
AND      NOT EXISTS (SELECT 'x'
                     FROM   po_headers_all poha
                     WHERE  poha.segment1 = rti.document_num)
AND      rhi.GROUP_ID = DECODE (p_group_id, 0, rhi.GROUP_ID, p_group_id)
AND      (   rhi.processing_request_id IS NULL
          OR rhi.processing_request_id = p_request_id
         )
GROUP BY rhi.header_interface_id;

Line: 65

      update rcv_transactions_interface rti
      SET    rti.processing_status_code = 'RUNNING',
             rti.processing_request_id =decode(p_request_id,null,null,
							p_request_id)
      where exists (select 'x' from rcv_headers_interface rhi
                    where rhi.header_interface_id = rti.header_interface_id and
                          rhi.processing_status_code = 'RUNNING' and
                          (rhi.processing_request_id is null or
                          rhi.processing_request_id = p_request_id)) and
	     rti.group_id = decode(p_group_id, 0, rti.group_id, p_group_id) and
             rti.processing_status_code = 'PENDING' ;

Line: 90

     select count(*)
     into v_total_count
     from rcv_transactions_interface rti
     where
        rti.header_interface_id = c1_rec.header_interface_id;

Line: 109

        update rcv_headers_interface
	set processing_status_code = 'RUNNING',
	 processing_request_id = decode(p_request_id,null,null, p_request_id)
        where processing_status_code  = 'PENDING' and
              header_interface_id = c1_rec.header_interface_id;

Line: 121

        update rcv_transactions_interface
        SET    processing_status_code = 'RUNNING',
               processing_request_id = decode(p_request_id,null,null,
						p_request_id)
	WHERE 	processing_status_code = 'PENDING'
	AND   	(processing_request_id is null OR
	   	processing_request_id  = p_request_id)
	AND    group_id = decode(p_group_id,0,group_id,p_group_id)
        AND     header_interface_id = c1_rec.header_interface_id;