APPS.INV_LOGICAL_TRANSACTIONS_PVT dependencies on MTL_SERIAL_NUMBERS

Line 2647: UPDATE mtl_serial_numbers

2643: debug_print('p_invventory_item_id = ' || p_inventory_item_id, 9);
2644: END IF;
2645:
2646: forall i in p_ser_num_tbl.FIRST..p_ser_num_tbl.LAST
2647: UPDATE mtl_serial_numbers
2648: SET current_status = 4
2649: WHERE current_organization_id = p_organization_id
2650: AND serial_number = p_ser_num_tbl(i)
2651: AND inventory_item_id = p_inventory_item_id;

Line 2655: debug_print('The number of rows updated in mtl_serial_numbers is not equals

2651: AND inventory_item_id = p_inventory_item_id;
2652:
2653: IF (SQL%ROWCOUNT <> p_ser_num_tbl.COUNT) THEN
2654: IF (l_debug = 1) THEN
2655: debug_print('The number of rows updated in mtl_serial_numbers is not equals
2656: to the number of serial numbers that needed to be updated', 9);
2657: END IF;
2658: END IF;
2659: EXCEPTION