[Home] [Help]
586: -- Bug 2458540
587: -- IF p_serial_control_code NOT IN (1,6) THEN
588: IF p_serial_control_code NOT IN(1) THEN
589: -- serial numbers were also inserted in serials temp table
590: INSERT INTO rcv_serials_interface
591: (
592: interface_transaction_id
593: , last_update_date
594: , last_updated_by
640: --
641: -- IF p_serial_control_code NOT IN (1,6) THEN
642: IF p_serial_control_code NOT IN(1) THEN
643: -- serial numbers were also inserted in serials temp table
644: INSERT INTO rcv_serials_interface
645: (
646: interface_transaction_id
647: , last_update_date
648: , last_updated_by
1415: --Store the interface_transaction_id in a global variable which would later
1416: --be used for splitting lots and serials
1417: g_interface_transaction_id := l_interface_transaction_id;
1418:
1419: -- Create the necessary rcv_lots_interface and rcv_serials_interface
1420: -- rows based on the rows created in the mtl_transactions_lots_temp
1421: -- and the mtl_serial_numbers_temp table.
1422: -- There is an issue here between v10 and 10sc.
1423: -- In 10 we inserted rows into the rcv_lots_interface
1420: -- rows based on the rows created in the mtl_transactions_lots_temp
1421: -- and the mtl_serial_numbers_temp table.
1422: -- There is an issue here between v10 and 10sc.
1423: -- In 10 we inserted rows into the rcv_lots_interface
1424: -- and rcv_serials_interface tables through the
1425: -- lot and serial forms. In 10sc we are using the Inventory lot and
1426: -- serial forms which insert into the mtl_transaction_lots_temp and
1427: -- the mtl_serial_numbers_temp table. The issue here is that if the
1428: -- transaction_interface row was created by a 10 client then we want
5116: SAVEPOINT sp_update_rss;
5117:
5118: SELECT rsi.fm_serial_num
5119: INTO l_serial_number
5120: FROM rcv_serials_interface rsi, rcv_transactions_interface rti
5121: WHERE rti.shipment_line_id = p_shipment_line_id
5122: AND rti.interface_transaction_id = rsi.interface_transaction_id;
5123:
5124: IF (l_debug = 1) THEN