1 package MTL_LOT_CONV_AUDIT_PKG AUTHID CURRENT_USER as
2 /* $Header: INVHLCAS.pls 120.0 2005/05/25 05:27:52 appldev noship $ */
3
4 PROCEDURE INSERT_ROW(
5 X_CONV_AUDIT_ID IN OUT NOCOPY NUMBER,
6 X_CONVERSION_ID IN NUMBER,
7 X_CONVERSION_DATE IN DATE,
8 X_UPDATE_TYPE_INDICATOR IN NUMBER,
9 X_BATCH_ID IN NUMBER,
10 X_REASON_ID IN NUMBER,
11 X_OLD_CONVERSION_RATE IN NUMBER,
12 X_NEW_CONVERSION_RATE IN NUMBER,
13 X_EVENT_SPEC_DISP_ID IN NUMBER,
14 X_CREATED_BY IN NUMBER,
15 X_CREATION_DATE IN DATE,
16 X_LAST_UPDATED_BY IN NUMBER,
17 X_LAST_UPDATE_DATE IN DATE,
18 X_LAST_UPDATE_LOGIN IN NUMBER,
19 x_return_status OUT NOCOPY VARCHAR2,
20 x_msg_count OUT NOCOPY NUMBER,
21 x_msg_data OUT NOCOPY VARCHAR2);
22
23 PROCEDURE UPDATE_ROW(
24 X_CONV_AUDIT_ID IN NUMBER,
25 X_CONVERSION_ID IN NUMBER,
26 X_CONVERSION_DATE IN DATE,
27 X_UPDATE_TYPE_INDICATOR IN NUMBER,
28 X_BATCH_ID IN NUMBER,
29 X_REASON_ID IN NUMBER,
30 X_OLD_CONVERSION_RATE IN NUMBER,
31 X_NEW_CONVERSION_RATE IN NUMBER,
32 X_EVENT_SPEC_DISP_ID IN NUMBER,
33 X_LAST_UPDATED_BY IN NUMBER,
34 X_LAST_UPDATE_DATE IN DATE,
35 X_LAST_UPDATE_LOGIN IN NUMBER,
36 x_return_status OUT NOCOPY VARCHAR2,
37 x_msg_count OUT NOCOPY NUMBER,
38 x_msg_data OUT NOCOPY VARCHAR2);
39
40
41
42 END MTL_LOT_CONV_AUDIT_PKG;