[Home] [Help]
610: -- Bug 2458540
611: -- IF p_serial_control_code NOT IN (1,6) THEN
612: IF p_serial_control_code NOT IN(1) THEN
613: -- serial numbers were also inserted in serials temp table
614: INSERT INTO rcv_serials_interface
615: (
616: interface_transaction_id
617: , last_update_date
618: , last_updated_by
664: --
665: -- IF p_serial_control_code NOT IN (1,6) THEN
666: IF p_serial_control_code NOT IN(1) THEN
667: -- serial numbers were also inserted in serials temp table
668: INSERT INTO rcv_serials_interface
669: (
670: interface_transaction_id
671: , last_update_date
672: , last_updated_by
1449: --Store the interface_transaction_id in a global variable which would later
1450: --be used for splitting lots and serials
1451: g_interface_transaction_id := l_interface_transaction_id;
1452:
1453: -- Create the necessary rcv_lots_interface and rcv_serials_interface
1454: -- rows based on the rows created in the mtl_transactions_lots_temp
1455: -- and the mtl_serial_numbers_temp table.
1456: -- There is an issue here between v10 and 10sc.
1457: -- In 10 we inserted rows into the rcv_lots_interface
1454: -- rows based on the rows created in the mtl_transactions_lots_temp
1455: -- and the mtl_serial_numbers_temp table.
1456: -- There is an issue here between v10 and 10sc.
1457: -- In 10 we inserted rows into the rcv_lots_interface
1458: -- and rcv_serials_interface tables through the
1459: -- lot and serial forms. In 10sc we are using the Inventory lot and
1460: -- serial forms which insert into the mtl_transaction_lots_temp and
1461: -- the mtl_serial_numbers_temp table. The issue here is that if the
1462: -- transaction_interface row was created by a 10 client then we want
5238: SAVEPOINT sp_update_rss;
5239:
5240: SELECT rsi.fm_serial_num
5241: INTO l_serial_number
5242: FROM rcv_serials_interface rsi, rcv_transactions_interface rti
5243: WHERE rti.shipment_line_id = p_shipment_line_id
5244: AND rti.interface_transaction_id = rsi.interface_transaction_id;
5245:
5246: IF (l_debug = 1) THEN