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;

Line: 542

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

Line: 666

    l_qty_update_tbl           MTL_LOT_UOM_CONV_PUB.quantity_update_rec_type;

Line: 679

               SELECT   unit_of_measure_tl, uom_class
               INTO     l_from_unit_of_measure, l_from_uom_class
               FROM     MTL_UNITS_OF_MEASURE
               WHERE    UOM_CODE = p_from_uom_code;

Line: 689

               SELECT   unit_of_measure_tl, uom_class
               INTO     l_to_unit_of_measure, l_to_uom_class
               FROM     MTL_UNITS_OF_MEASURE
               WHERE    UOM_CODE = p_to_uom_code;

Line: 730

                  l_lot_uom_conv_rec.last_updated_by        :=       FND_GLOBAL.user_id;

Line: 731

                  l_lot_uom_conv_rec.last_update_date       :=       SYSDATE;

Line: 732

                  l_lot_uom_conv_rec.last_update_login      :=       FND_GLOBAL.login_id;

Line: 736

                  l_lot_uom_conv_rec.program_update_date    :=       NULL;

Line: 746

                  , p_update_type_indicator  =>          5
                  , p_reason_id              =>          NULL
                  , p_batch_id               =>          0
                  , p_process_data           =>          'Y'
                  , p_lot_uom_conv_rec       =>          l_lot_uom_conv_rec
                  , p_qty_update_tbl         =>          l_qty_update_tbl
                  , x_return_status          =>          l_return_status
                  , x_msg_count              =>          l_msg_count
                  , x_msg_data               =>          l_msg_data
                  , x_sequence               =>          l_sequence
                  );

Line: 794

            SELECT 1
            INTO l_exists
            FROM mtl_lot_numbers
            WHERE inventory_item_id = p_item_id
            AND organization_id = p_org_id
            AND lot_number = p_lot_number
            AND  ROWNUM = 1;

Line: 804

                  SELECT 1
                  INTO l_exists
                  FROM mtl_transaction_lots_temp a
                     , mtl_material_transactions_temp b
                  WHERE b.inventory_item_id = p_item_id
                  AND a.lot_number = p_lot_number
                  AND a.transaction_temp_id = b.transaction_temp_id
                  AND rownum = 1
                  AND b.organization_id = p_org_id;

Line: 816

                        SELECT 1
                        INTO l_exists
                           FROM mtl_material_transactions_temp mtl
                           WHERE mtl.inventory_item_id <> p_item_id
                           AND mtl.lot_number = p_lot_number
                           AND mtl.organization_id = p_org_id
                           AND rownum = 1;