1 PACKAGE MTL_CC_TRANSACT_PKG AUTHID CURRENT_USER as
2 /* $Header: INVATC2S.pls 120.0 2005/05/25 06:48:51 appldev noship $ */
3
4 -- This function is used for cycle count adjustment transactions
5 -- The lpn_discrepancy parameter is used when during cycle counting,
6 -- an LPN discrepancy is found and a subinventory transfer on that LPN
7 -- needs to be issued. It defaults to 2 for no, 1 when an LPN discrepancy
8 -- transaction is processed
9 FUNCTION CC_TRANSACT( org_id NUMBER ,
10 cc_header_id NUMBER ,
11 item_id NUMBER ,
12 sub VARCHAR2 ,
13 PUOMQty NUMBER ,
14 TxnQty NUMBER ,
15 TxnUOM VARCHAR2 ,
16 TxnDate DATE ,
17 TxnAcctId NUMBER ,
18 LotNum VARCHAR2 ,
19 LotExpDate DATE ,
20 rev VARCHAR2 ,
21 locator_id NUMBER ,
22 TxnRef VARCHAR2 ,
23 ReasonId NUMBER ,
24 UserId NUMBER ,
25 cc_entry_id NUMBER ,
26 LoginId NUMBER ,
27 TxnProcMode NUMBER ,
28 TxnHeaderId NUMBER ,
29 SerialNum VARCHAR2 ,
30 TxnTempId NUMBER ,
31 SerialPrefix VARCHAR2 ,
32 lpn_id NUMBER ,
33 transfer_sub VARCHAR2 DEFAULT NULL ,
34 transfer_loc_id NUMBER DEFAULT NULL ,
35 cost_group_id NUMBER DEFAULT NULL ,
36 lpn_discrepancy NUMBER DEFAULT 2
37 ,secUOM VARCHAR2 DEFAULT NULL -- INVCONV,NSRIVAST
38 ,secQty NUMBER DEFAULT NULL -- INVCONV,NSRIVAST
39 )
40 RETURN Number;
41
42 END MTL_CC_TRANSACT_PKG;