APPS.INV_LOGICAL_TRANSACTIONS_PVT dependencies on MTL_SERIAL_NUMBERS

Line 2595: UPDATE mtl_serial_numbers

2591: debug_print('p_invventory_item_id = ' || p_inventory_item_id, 9);
2592: END IF;
2593:
2594: forall i in p_ser_num_tbl.FIRST..p_ser_num_tbl.LAST
2595: UPDATE mtl_serial_numbers
2596: SET current_status = 4
2597: WHERE current_organization_id = p_organization_id
2598: AND serial_number = p_ser_num_tbl(i)
2599: AND inventory_item_id = p_inventory_item_id;

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

2599: AND inventory_item_id = p_inventory_item_id;
2600:
2601: IF (SQL%ROWCOUNT <> p_ser_num_tbl.COUNT) THEN
2602: IF (l_debug = 1) THEN
2603: debug_print('The number of rows updated in mtl_serial_numbers is not equals
2604: to the number of serial numbers that needed to be updated', 9);
2605: END IF;
2606: END IF;
2607: EXCEPTION