[Home] [Help]
PACKAGE: APPS.INV_CONVERT
Source
1 PACKAGE inv_convert AS
2 /* $Header: INVUMCNS.pls 120.2 2008/01/21 07:59:18 anagupta noship $ */
3
4 /* ppuranik: bug 1323973
5 ** ReadNoPackageState (RNPS) is added, so that
6 ** inv_um_convert can be executed remotely with
7 ** same purity level or lower.
8 */
9
10 G_TRUE CONSTANT NUMBER := 1;
11 G_FALSE CONSTANT NUMBER := 0;
12
13 --Start Bug 6761510
14 -- The following types are used to cache the UOM conversions. The three keys to this
15 -- are the inventory item, from UOM code, and to UOM code. This will yield the conversion
16 -- rate by using a nested PLSQL table structure.
17 TYPE to_uom_code_tb IS TABLE OF NUMBER INDEX BY VARCHAR2(3);
18 TYPE from_uom_code_tb IS TABLE OF to_uom_code_tb INDEX BY VARCHAR2(3);
19 TYPE item_uom_conversion_tb IS TABLE OF from_uom_code_tb INDEX BY BINARY_INTEGER;
20
21 g_item_uom_conversion_tb item_uom_conversion_tb;
22
23 FUNCTION inv_um_convert(p_item_id IN NUMBER,
24 p_from_uom_code IN VARCHAR2,
25 p_to_uom_code IN VARCHAR2) RETURN NUMBER;
26 --End Bug 6761510
27
28 PROCEDURE pick_uom_convert(
29 p_org_id NUMBER,
30 p_item_id NUMBER,
31 p_sub_code VARCHAR2,
32 p_loc_id NUMBER,
33 p_alloc_uom VARCHAR2,
34 p_alloc_qty NUMBER,
35 x_pick_uom OUT NOCOPY VARCHAR2,
36 x_pick_qty OUT NOCOPY NUMBER,
37 x_uom_string OUT NOCOPY VARCHAR2,
38 x_return_status OUT NOCOPY VARCHAR2,
39 x_msg_data OUT NOCOPY VARCHAR2,
40 x_msg_count OUT NOCOPY NUMBER);
41
42 PROCEDURE inv_um_conversion(
43 from_unit varchar2,
44 to_unit varchar2,
45 item_id number,
46 lot_number varchar2 DEFAULT NULL,
47 organization_id number,
48 uom_rate out nocopy number );
49 pragma restrict_references(inv_um_conversion, WNDS,WNPS, RNPS);
50
51 PROCEDURE inv_um_conversion(
52 from_unit varchar2,
53 to_unit varchar2,
54 item_id number,
55 uom_rate out nocopy number );
56 pragma restrict_references(inv_um_conversion, WNDS,WNPS, RNPS);
57
58 -- Will call the function inv_um_convert with NULL for lot number and org.
59 FUNCTION inv_um_convert(
60 item_id number,
61 precision number,
62 from_quantity number,
63 from_unit varchar2,
64 to_unit varchar2,
65 from_name varchar2,
66 to_name varchar2) RETURN number;
67 pragma restrict_references(inv_um_convert, WNDS,WNPS, RNPS);
68
69 FUNCTION inv_um_convert(
70 item_id number,
71 lot_number varchar2 DEFAULT NULL,
72 organization_id number,
73 precision number,
74 from_quantity number,
75 from_unit varchar2,
76 to_unit varchar2,
77 from_name varchar2,
78 to_name varchar2) RETURN number;
79 pragma restrict_references(inv_um_convert, WNDS,WNPS, RNPS);
80
81 FUNCTION inv_um_convert_new(
82 item_id number,
83 precision number,
84 from_quantity number,
85 from_unit varchar2,
86 to_unit varchar2,
87 from_name varchar2,
88 to_name varchar2,
89 capacity_type varchar2 ) RETURN number;
90
91
92
93 FUNCTION inv_um_convert_new(
94 item_id number,
95 lot_number varchar2 DEFAULT NULL,
96 organization_id number,
97 precision number,
98 from_quantity number,
99 from_unit varchar2,
100 to_unit varchar2,
101 from_name varchar2,
102 to_name varchar2,
103 capacity_type varchar2 ) RETURN number;
104
105
106 FUNCTION validate_item_uom (p_uom_code IN VARCHAR2,
107 p_item_id IN NUMBER,
108 p_organization_id IN NUMBER)
109 return BOOLEAN;
110
111 pragma restrict_references (validate_item_uom, WNDS,WNPS, RNPS);
112
113 -- Checks if quantities entered for dual uoms are within deviation.
114
115 FUNCTION within_deviation(
116 p_organization_id IN number,
117 p_inventory_item_id IN number,
118 p_lot_number IN varchar2 DEFAULT NULL,
119 p_precision IN number,
120 p_quantity IN number,
121 p_uom_code1 IN varchar2,
122 p_quantity2 IN number,
123 p_uom_code2 IN varchar2,
124 p_unit_of_measure1 IN varchar2 DEFAULT NULL,
125 p_unit_of_measure2 IN varchar2 DEFAULT NULL)
126 RETURN NUMBER;
127
128
129
130 END inv_convert;