[Home] [Help]
PACKAGE: APPS.INV_MWB_CG_TRANSFER
Source
1 PACKAGE INV_MWB_CG_TRANSFER AUTHID CURRENT_USER AS
2 /* $Header: INVCGTRS.pls 120.2 2005/06/17 03:23:09 appldev $ */
3
4 PROCEDURE TRANSFER(
5 X_RETURN_STATUS OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
6 X_MSG_COUNT OUT NOCOPY /* file.sql.39 change */ NUMBER,
7 X_MSG_DATA OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
8 X_TRANSACTION_HEADER_ID IN OUT NOCOPY /* file.sql.39 change */ NUMBER,
9 P_IS_REVISION_CONTROLLED IN VARCHAR2,
10 P_IS_LOT_CONTROLLED IN VARCHAR2,
11 P_IS_SERIAL_CONTROLLED IN VARCHAR2,
12 P_ORG_ID IN NUMBER,
13 P_INVENTORY_ITEM_ID IN NUMBER,
14 P_REVISION IN VARCHAR2,
15 P_SUBINVENTORY IN VARCHAR2,
16 P_LOCATOR_ID IN NUMBER,
17 P_LPN_ID IN NUMBER,
18 P_LOT_NUMBER IN VARCHAR2,
19 P_EXP_DATE IN DATE,
20 P_SERIAL_NUMBER IN VARCHAR2,
21 P_ONHAND IN NUMBER,
22 P_AVAILABILITY IN NUMBER,
23 P_UOM IN VARCHAR2,
24 P_PRIMARY_UOM IN VARCHAR2,
25 P_COSTGROUP_ID IN NUMBER,
26 P_XFR_COSTGROUP_ID IN NUMBER,
27 P_USER_ID IN NUMBER
28 );
29
30 PROCEDURE VALIDATE(
31 X_RETURN_STATUS OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
32 X_MSG_COUNT OUT NOCOPY /* file.sql.39 change */ NUMBER,
33 X_MSG_DATA OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
34 X_ONHAND IN OUT NOCOPY /* file.sql.39 change */ NUMBER,
35 X_AVAILABILITY IN OUT NOCOPY /* file.sql.39 change */ NUMBER,
36 P_IS_REVISION_CONTROLLED IN VARCHAR2,
37 P_IS_LOT_CONTROLLED IN VARCHAR2,
38 P_IS_SERIAL_CONTROLLED IN VARCHAR2,
39 P_ORG_ID IN NUMBER,
40 P_INVENTORY_ITEM_ID IN NUMBER,
41 P_REVISION IN VARCHAR2,
42 P_SUBINVENTORY IN VARCHAR2,
43 P_LOCATOR_ID IN NUMBER,
44 P_LPN_ID IN NUMBER,
45 P_LOT_NUMBER IN VARCHAR2,
46 P_SERIAL_NUMBER IN VARCHAR2,
47 P_IS_LPN_REQUIRED IN VARCHAR2,
48 P_COST_GROUP_ID IN NUMBER
49 );
50
51 PROCEDURE UPDATE_QUANTITY_TREE(
52 X_RETURN_STATUS OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
53 X_MSG_COUNT OUT NOCOPY /* file.sql.39 change */ NUMBER,
54 X_MSG_DATA OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
55 P_IS_LOT_CONTROLLED IN VARCHAR2,
56 P_IS_SERIAL_CONTROLLED IN VARCHAR2,
57 P_IS_LPN_REQUIRED IN VARCHAR2,
58 P_ORG_ID IN NUMBER,
59 P_INVENTORY_ITEM_ID IN NUMBER,
60 P_REVISION IN VARCHAR2,
61 P_SUBINVENTORY IN VARCHAR2,
62 P_LOCATOR_ID IN NUMBER,
63 P_LOT_NUMBER IN VARCHAR2,
64 P_ONHAND IN NUMBER,
65 P_UOM IN VARCHAR2,
66 P_PRIMARY_UOM IN VARCHAR2,
67 P_COSTGROUP_ID IN NUMBER,
68 P_XFR_COSTGROUP_ID IN NUMBER
69 );
70
71 END INV_MWB_CG_TRANSFER;