1 package MTL_LOT_UOM_CONV_PKG as
2 /* $Header: INVHLUCS.pls 120.0 2005/05/24 17:57:31 appldev noship $ */
3
4 PROCEDURE INSERT_ROW(
5 X_CONVERSION_ID IN OUT NOCOPY NUMBER,
6 X_LOT_NUMBER IN VARCHAR2,
7 X_ORGANIZATION_ID IN NUMBER,
8 X_INVENTORY_ITEM_ID IN NUMBER,
9 X_FROM_UNIT_OF_MEASURE IN VARCHAR2,
10 X_FROM_UOM_CODE IN VARCHAR2,
11 X_FROM_UOM_CLASS IN VARCHAR2,
12 X_TO_UNIT_OF_MEASURE IN VARCHAR2,
13 X_TO_UOM_CODE IN VARCHAR2,
14 X_TO_UOM_CLASS IN VARCHAR2,
15 X_CONVERSION_RATE IN NUMBER,
16 X_DISABLE_DATE IN DATE,
17 X_EVENT_SPEC_DISP_ID IN NUMBER,
18 X_CREATED_BY IN NUMBER,
19 X_CREATION_DATE IN DATE,
20 X_LAST_UPDATED_BY IN NUMBER,
21 X_LAST_UPDATE_DATE IN DATE,
22 X_LAST_UPDATE_LOGIN IN NUMBER,
23 X_REQUEST_ID IN NUMBER,
24 X_PROGRAM_APPLICATION_ID IN NUMBER,
25 X_PROGRAM_ID IN NUMBER,
26 X_PROGRAM_UPDATE_DATE IN DATE,
27 x_return_status OUT NOCOPY VARCHAR2,
28 x_msg_count OUT NOCOPY NUMBER,
29 x_msg_data OUT NOCOPY VARCHAR2);
30
31 PROCEDURE UPDATE_ROW(
32 X_CONVERSION_ID IN NUMBER,
33 X_LOT_NUMBER IN VARCHAR2,
34 X_ORGANIZATION_ID IN NUMBER,
35 X_INVENTORY_ITEM_ID IN NUMBER,
36 X_FROM_UNIT_OF_MEASURE IN VARCHAR2,
37 X_FROM_UOM_CODE IN VARCHAR2,
38 X_FROM_UOM_CLASS IN VARCHAR2,
39 X_TO_UNIT_OF_MEASURE IN VARCHAR2,
40 X_TO_UOM_CODE IN VARCHAR2,
41 X_TO_UOM_CLASS IN VARCHAR2,
42 X_CONVERSION_RATE IN NUMBER,
43 X_DISABLE_DATE IN DATE,
44 X_EVENT_SPEC_DISP_ID IN NUMBER,
45 X_LAST_UPDATED_BY IN NUMBER,
46 X_LAST_UPDATE_DATE IN DATE,
47 X_LAST_UPDATE_LOGIN IN NUMBER,
48 X_REQUEST_ID IN NUMBER,
49 X_PROGRAM_APPLICATION_ID IN NUMBER,
50 X_PROGRAM_ID IN NUMBER,
51 X_PROGRAM_UPDATE_DATE IN DATE,
52 x_return_status OUT NOCOPY VARCHAR2,
53 x_msg_count OUT NOCOPY NUMBER,
54 x_msg_data OUT NOCOPY VARCHAR2);
55
56 PROCEDURE DELETE_ROW(
57 X_CONVERSION_ID IN NUMBER,
58 X_DISABLE_DATE IN DATE,
59 X_LAST_UPDATED_BY IN NUMBER,
60 X_LAST_UPDATE_DATE IN DATE,
61 X_LAST_UPDATE_LOGIN IN NUMBER,
62 X_REQUEST_ID IN NUMBER,
63 X_PROGRAM_APPLICATION_ID IN NUMBER,
64 X_PROGRAM_ID IN NUMBER,
65 X_PROGRAM_UPDATE_DATE IN DATE,
66 x_return_status OUT NOCOPY VARCHAR2,
67 x_msg_count OUT NOCOPY NUMBER,
68 x_msg_data OUT NOCOPY VARCHAR2);
69
70
71 PROCEDURE lock_row(
72 x_conversion_id NUMBER
73 , x_lot_number VARCHAR2
74 , x_organization_id NUMBER
75 , x_inventory_item_id NUMBER
76 , x_from_unit_of_measure VARCHAR2
77 , x_from_uom_code VARCHAR2
78 , x_from_uom_class VARCHAR2
79 , x_to_unit_of_measure VARCHAR2
80 , x_to_uom_code VARCHAR2
81 , x_to_uom_class VARCHAR2
82 , x_conversion_rate NUMBER
83 , x_disable_date DATE
84 , x_event_spec_disp_id NUMBER
85 );
86
87
88
89 END MTL_LOT_UOM_CONV_PKG;