1 PACKAGE RCV_LOT_SERIAL_SV AS
2 /* $Header: RCVTXLSS.pls 120.1 2005/06/14 18:28:40 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
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
16 to continue to insert into the mtl_ tables. If this trx was
17 generated through a 10sc client then we need to insert into the
18 10sc tables. We are adding a flag use_mtl_lot_serial that is null
19 allowable to tell us whether to use the rcv_ tables or the mtl_
20 tables)
21
22 Args: IN: interface_trx_id - ID of the transaction to be rejected.
23 IN: status - New status of the transaction
24 Reqs:
25 Mods:
26 Err : return(FALSE) on error. Error messages returned on AOL message stack
27 Algr: update rcv_transactions_interface to set new status
28 Note:
29 =============================================================================*/
30 PROCEDURE create_rcv_lotserial(interface_trx_id IN NUMBER,
31 use_mtl_lot IN NUMBER,
32 use_mtl_serial IN NUMBER);
33
34 END RCV_LOT_SERIAL_SV;
35