[Home] [Help]
2: /* $Header: RCVTXLSB.pls 120.2 2005/06/21 18:57:50 wkunz noship $*/
3:
4: /*=============================================================================
5: Name: create_rcv_lotserial
6: Desc: Create the necessary rcv_lots_interface and rcv_serials_interface
7: rows based on the rows created in the mtl_transactions_lots_temp
8: and the mtl_serial_numbers_temp table.
9: There is an issue here between v10 and 10sc.
10: In 10 we inserted rows into the rcv_lots_interface
7: rows based on the rows created in the mtl_transactions_lots_temp
8: and the mtl_serial_numbers_temp table.
9: There is an issue here between v10 and 10sc.
10: In 10 we inserted rows into the rcv_lots_interface
11: and rcv_serials_interface tables through the
12: lot and serial forms. In 10sc we are using the Inventory lot and
13: serial forms which insert into the mtl_transaction_lots_temp and
14: the mtl_serial_numbers_temp table. The issue here is that if the
15: transaction_interface row was created by a 10 client then we want
107: IF (use_mtl_serial = 2) THEN
108:
109: X_progress := '020';
110:
111: INSERT INTO rcv_serials_interface (
112: INTERFACE_TRANSACTION_ID,
113: LAST_UPDATE_DATE,
114: LAST_UPDATED_BY,
115: CREATION_DATE,
163: ELSIF (use_mtl_serial = 5) THEN
164:
165: X_progress := '030';
166:
167: INSERT INTO rcv_serials_interface (
168: INTERFACE_TRANSACTION_ID,
169: LAST_UPDATE_DATE,
170: LAST_UPDATED_BY,
171: CREATION_DATE,