1 package MTL_LOT_CONV_AUD_DET_PKG AUTHID CURRENT_USER as
2 /* $Header: INVHLCDS.pls 120.0 2005/05/25 06:05:03 appldev noship $ */
3
4 PROCEDURE INSERT_ROW(
5 X_CONV_AUDIT_DETAIL_ID IN OUT NOCOPY NUMBER,
6 X_CONV_AUDIT_ID IN NUMBER,
7 X_REVISION IN VARCHAR2,
8 X_ORGANIZATION_ID IN NUMBER,
9 X_SUBINVENTORY_CODE IN VARCHAR2,
10 X_LPN_ID IN NUMBER,
11 X_LOCATOR_ID IN NUMBER,
12 X_OLD_PRIMARY_QTY IN NUMBER,
13 X_OLD_SECONDARY_QTY IN NUMBER,
14 X_NEW_PRIMARY_QTY IN NUMBER,
15 X_NEW_SECONDARY_QTY IN NUMBER,
16 X_TRANSACTION_PRIMARY_QTY IN NUMBER,
17 X_TRANSACTION_SECONDARY_QTY IN NUMBER,
18 X_TRANSACTION_UPDATE_FLAG IN VARCHAR2,
19 X_CREATED_BY IN NUMBER,
20 X_CREATION_DATE IN DATE,
21 X_LAST_UPDATED_BY IN NUMBER,
22 X_LAST_UPDATE_DATE IN DATE,
23 X_LAST_UPDATE_LOGIN IN NUMBER,
24 x_return_status OUT NOCOPY VARCHAR2,
25 x_msg_count OUT NOCOPY NUMBER,
26 x_msg_data OUT NOCOPY VARCHAR2);
27
28
29 PROCEDURE UPDATE_ROW(
30 X_CONV_AUDIT_DETAIL_ID IN NUMBER,
31 X_CONV_AUDIT_ID IN NUMBER,
32 X_REVISION IN VARCHAR2,
33 X_ORGANIZATION_ID IN NUMBER,
34 X_SUBINVENTORY_CODE IN VARCHAR2,
35 X_LPN_ID IN NUMBER,
36 X_LOCATOR_ID IN NUMBER,
37 X_OLD_PRIMARY_QTY IN NUMBER,
38 X_OLD_SECONDARY_QTY IN NUMBER,
39 X_NEW_PRIMARY_QTY IN NUMBER,
40 X_NEW_SECONDARY_QTY IN NUMBER,
41 X_TRANSACTION_PRIMARY_QTY IN NUMBER,
42 X_TRANSACTION_SECONDARY_QTY IN NUMBER,
43 X_TRANSACTION_UPDATE_FLAG IN VARCHAR2,
44 X_LAST_UPDATED_BY IN NUMBER,
45 X_LAST_UPDATE_DATE IN DATE,
46 X_LAST_UPDATE_LOGIN IN NUMBER,
47 x_return_status OUT NOCOPY VARCHAR2,
48 x_msg_count OUT NOCOPY NUMBER,
49 x_msg_data OUT NOCOPY VARCHAR2);
50
51
52
53 END MTL_LOT_CONV_AUD_DET_PKG;
[Home] [Help]