APPS.INV_RCV_MOBILE_PROCESS_TXN SQL Statements

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

Line: 29

   SELECT   COUNT(1)
     INTO   l_rec_count
     FROM   RCV_TRANSACTIONS_INTERFACE
    WHERE   group_id = p_group_id;

Line: 171

   DELETE_ROWS   BOOLEAN := FALSE;

Line: 212

         UPDATE RCV_TRANSACTIONS_INTERFACE
         SET PROCESSING_MODE_CODE =  'ONLINE'
         WHERE GROUP_ID = inv_rcv_common_apis.g_rcv_global_var.interface_group_id
         AND  PROCESSING_MODE_CODE <> 'ONLINE';

Line: 219

        print_debug('no record found in rti which requires update  ',1);

Line: 244

	 SELECT 'ERROR'
	   INTO l_outcome
	   FROM dual
	   WHERE EXISTS (SELECT 1
			 FROM   rcv_transactions_interface
			 WHERE  group_id = l_group_id
			 AND    (transaction_status_code = 'ERROR' OR
				 processing_status_code = 'ERROR'));

Line: 286

	 --DELETE_ROWS := TRUE;

Line: 337

	 DELETE_ROWS := TRUE;

Line: 406

	 DELETE_ROWS := TRUE;

Line: 425

   IF (DELETE_ROWS) THEN
     BEGIN

       /* Bug# 6081470
        * Commented out the below update statement as the same record set
        * is getting deleted below
        */
/*      UPDATE rcv_transactions_interface
          SET processing_status_code = 'COMPLETED'
            , transaction_status_code = 'ERROR'
        WHERE group_id = inv_RCV_COMMON_APIS.g_rcv_global_var.interface_group_id;

Line: 444

          print_debug('INV_RCV_MOBILE_PROCESS_TXN.rcv_online_request in delete rows for group_id:'
                          || inv_RCV_COMMON_APIS.g_rcv_global_var.interface_group_id,4);

Line: 448

        delete from rcv_transactions_interface
        where group_id = inv_RCV_COMMON_APIS.g_rcv_global_var.interface_group_id;

Line: 452

         * Added code to also delete the rcv_headers_interface records as the
         * corresponding rcv_transactions_interface records are being deleted above.
         * Hence this becomes an orphan RHI record and there is no use of this record.
         */
        delete from rcv_headers_interface
        where group_id = inv_RCV_COMMON_APIS.g_rcv_global_var.interface_group_id;