1 PACKAGE MTL_INV_VALIDATE_GRP AS
2 /* $Header: INVGIVVS.pls 120.2 2005/06/22 09:56:00 appldev ship $ */
3
4 -- computes date which corresponds to offset from a given date
5 --Added NOCOPY hint to x_return_status,x_msg_count,x_msg_data x_result_date
6 --OUT parameters to comply with GSCC File.Sql.39 standard .Bug:4410902
7 procedure Get_Offset_Date(
8 p_api_version IN NUMBER ,
9 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
10 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
11 x_return_status OUT NOCOPY VARCHAR2 ,
12 x_msg_count OUT NOCOPY NUMBER ,
13 x_msg_data OUT NOCOPY VARCHAR2 ,
14 p_start_date IN DATE,
15 p_offset_days IN NUMBER,
16 p_calendar_code IN VARCHAR2,
17 p_exception_set_id IN NUMBER,
18 x_result_date OUT NOCOPY DATE);
19
20 --
21 -- Derive Count Uom
22 PROCEDURE Get_CountUom(
23 p_uom_code IN VARCHAR2 )
24 ;
25 --
26 -- Dervies Item and SKU information from the given Count List Sequence
27 PROCEDURE Get_Item_SKU(
28 p_cycle_count_entry_rec IN MTL_CYCLE_COUNT_ENTRIES%ROWTYPE )
29 ;
30 --
31 -- Get the STOCK_LOCATOR_CONTROL_CODE from the given ORG_ID
32 PROCEDURE Get_StockLocatorControlCode(
33 p_organization_id IN NUMBER )
34 ;
35 --
36 -- Validates the adjustment account
37 --Added NOCOPY hint to x_return_status,x_msg_count,x_msg_data
38 --OUT parameters to comply with GSCC File.Sql.39 standard .Bug:4410902
39 PROCEDURE Validate_AdjustAccount(
40 p_api_version IN NUMBER ,
41 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
42 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
43 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
44 x_return_status OUT NOCOPY VARCHAR2 ,
45 x_msg_count OUT NOCOPY NUMBER ,
46 x_msg_data OUT NOCOPY VARCHAR2 ,
47 p_adjustaccount_rec IN MTL_CCEOI_VAR_PVT.ADJUSTACCOUNT_REC_TYPE )
48 ;
49 --
50 -- Validates the count date
51 --Added NOCOPY hint to x_return_status,x_msg_count,x_msg_data ,x_errorcode
52 --OUT parameters to comply with GSCC File.Sql.39 standard .Bug:4410902
53 PROCEDURE Validate_CountDate(
54 p_api_version IN NUMBER ,
55 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
56 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
57 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
58 x_return_status OUT NOCOPY VARCHAR2 ,
59 x_msg_count OUT NOCOPY NUMBER ,
60 x_msg_data OUT NOCOPY VARCHAR2 ,
61 x_errorcode OUT NOCOPY NUMBER ,
62 p_count_date IN DATE )
63 ;
64 --
65 -- Validate count header
66 --Added NOCOPY hint to x_return_status,x_msg_count,x_msg_data ,x_errorcode
67 --OUT parameters to comply with GSCC File.Sql.39 standard .Bug:4410902
68 PROCEDURE Validate_CountHeader(
69 p_api_version IN NUMBER ,
70 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
71 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
72 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
73 x_return_status OUT NOCOPY VARCHAR2 ,
74 x_msg_count OUT NOCOPY NUMBER ,
75 x_msg_data OUT NOCOPY VARCHAR2 ,
76 x_errorcode OUT NOCOPY VARCHAR2 ,
77 p_cycle_count_header_id IN NUMBER DEFAULT NULL,
78 p_cycle_count_header_name IN VARCHAR2 DEFAULT NULL)
79 ;
80 --
81 -- Validate count_list_sequence
82 --Added NOCOPY hint to x_return_status,x_msg_count,x_msg_data ,x_errorcode
83 --OUT parameters to comply with GSCC File.Sql.39 standard .Bug:4410902
84 PROCEDURE Validate_CountListSequence(
85 p_api_version NUMBER ,
86 p_init_msg_list VARCHAR2 DEFAULT FND_API.G_FALSE,
87 p_commit VARCHAR2 DEFAULT FND_API.G_FALSE,
88 p_validation_level NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
89 x_return_status OUT NOCOPY VARCHAR2 ,
90 x_msg_count OUT NOCOPY NUMBER ,
91 x_msg_data OUT NOCOPY VARCHAR2 ,
92 x_errorcode OUT NOCOPY number ,
93 p_cycle_count_header_id IN number ,
94 p_cycle_count_entry_id IN number ,
95 p_count_list_sequence IN number ,
96 p_organization_id IN NUMBER )
97 ;
98 --
99 -- Validate the count quantity (if negative)
100 --Added NOCOPY hint to x_return_status,x_msg_count,x_msg_data ,x_errorcode
101 --OUT parameters to comply with GSCC File.Sql.39 standard .Bug:4410902
102 PROCEDURE Validate_CountQuantity(
103 p_api_version IN NUMBER ,
104 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
105 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
106 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
107 x_return_status OUT NOCOPY VARCHAR2 ,
108 x_msg_count OUT NOCOPY NUMBER ,
109 x_msg_data OUT NOCOPY VARCHAR2 ,
110 x_errorcode OUT NOCOPY NUMBER ,
111 p_count_quantity IN NUMBER )
112 ;
113 --
114 -- Validates Control information this item
115 --Added NOCOPY hint to x_return_status,x_msg_count,x_msg_data ,x_errorcode
116 --OUT parameters to comply with GSCC File.Sql.39 standard .Bug:4410902
117 PROCEDURE Validate_Ctrol(
118 p_api_version IN NUMBER ,
119 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
120 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
121 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
122 x_return_status OUT NOCOPY VARCHAR2 ,
123 x_msg_count OUT NOCOPY NUMBER ,
124 x_msg_data OUT NOCOPY VARCHAR2 ,
125 x_errorcode OUT NOCOPY NUMBER ,
126 p_inventory_item_id IN NUMBER ,
127 p_organization_id IN NUMBER ,
128 p_locator_rec IN MTL_CCEOI_VAR_PVT.INV_LOCATOR_REC_TYPE ,
129 p_lot_number IN VARCHAR2 ,
130 p_revision IN VARCHAR2 ,
131 p_serial_number IN VARCHAR2 ,
132 p_locator_control IN NUMBER )
133 ;
134 --
135 -- Validates Count UOM or/and Unit of Measure
136 --Added NOCOPY hint to x_return_status,x_msg_count,x_msg_data ,x_errorcode
137 --OUT parameters to comply with GSCC File.Sql.39 standard .Bug:4410902
138 PROCEDURE Validate_CountUOM(
139 p_api_version IN NUMBER ,
140 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
141 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
142 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
143 x_return_status OUT NOCOPY VARCHAR2 ,
144 x_msg_count OUT NOCOPY NUMBER ,
145 x_msg_data OUT NOCOPY VARCHAR2 ,
146 x_errorcode OUT NOCOPY NUMBER ,
147 p_count_uom IN VARCHAR2 DEFAULT NULL,
148 p_count_unit_of_measure IN VARCHAR2 DEFAULT NULL,
149 p_organization_id IN NUMBER ,
150 p_inventory_item_id IN NUMBER )
151 ;
152 --
153 --
154 -- Validates Item information
155 --Added NOCOPY hint to x_return_status,x_msg_count,x_msg_data ,x_errorcode
156 --OUT parameters to comply with GSCC File.Sql.39 standard .Bug:4410902
157 PROCEDURE Validate_Item(
158 p_api_version IN NUMBER ,
159 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
160 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
161 P_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
162 x_return_status OUT NOCOPY VARCHAR2 ,
163 x_msg_count OUT NOCOPY NUMBER ,
164 x_msg_data OUT NOCOPY VARCHAR2 ,
165 x_errorcode OUT NOCOPY NUMBER ,
166 p_inventory_item_rec IN MTL_CCEOI_VAR_PVT.INV_ITEM_REC_TYPE ,
167 p_organization_id IN NUMBER ,
168 p_cycle_count_header_id IN NUMBER DEFAULT NULL)
169 ;
170 --
171 -- Validates locator information
172 --Added NOCOPY hint to x_return_status,x_msg_count,x_msg_data ,x_errorcode
173 --OUT parameters to comply with GSCC File.Sql.39 standard .Bug:4410902
174 PROCEDURE Validate_Locator(
175 p_api_version IN NUMBER ,
176 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
177 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
178 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
179 x_return_status OUT NOCOPY VARCHAR2 ,
180 x_msg_count OUT NOCOPY NUMBER ,
181 x_msg_data OUT NOCOPY VARCHAR2 ,
182 x_errorcode OUT NOCOPY NUMBER ,
183 p_locator_rec IN MTL_CCEOI_VAR_PVT.INV_LOCATOR_REC_TYPE ,
184 p_organization_id IN NUMBER ,
185 P_subinventory IN VARCHAR2 ,
186 p_inventory_item_id IN NUMBER ,
187 p_locator_control IN NUMBER ,
188 p_control_level IN NUMBER ,
189 p_restrict_control IN NUMBER,
190 p_simulate IN VARCHAR2 DEFAULT FND_API.G_FALSE)
191 ;
192 --
193 --
194 -- Validate the primary uom quantity
195 --Added NOCOPY hint to x_return_status,x_msg_count,x_msg_data ,x_errorcode
196 --OUT parameters to comply with GSCC File.Sql.39 standard .Bug:4410902
197 PROCEDURE Validate_PrimaryUomQuantity(
198 p_api_version IN NUMBER ,
199 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
200 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
201 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
202 x_return_status OUT NOCOPY VARCHAR2 ,
203 x_msg_count OUT NOCOPY NUMBER ,
204 x_msg_data OUT NOCOPY VARCHAR2 ,
205 x_errorcode OUT NOCOPY NUMBER ,
206 p_primary_uom_quantity IN NUMBER ,
207 p_primary_uom_code IN VARCHAR2 )
208 ;
209 --
210 -- Validates subinventory
211 --Added NOCOPY hint to x_return_status,x_msg_count,x_msg_data ,x_errorcode
212 --OUT parameters to comply with GSCC File.Sql.39 standard .Bug:4410902
213 PROCEDURE Validate_Subinv(
214 p_api_version IN NUMBER ,
215 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
216 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
217 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
218 x_return_status OUT NOCOPY VARCHAR2 ,
219 x_msg_count OUT NOCOPY NUMBER ,
220 x_msg_data OUT NOCOPY VARCHAR2 ,
221 x_errorcode OUT NOCOPY NUMBER ,
222 p_subinventory IN VARCHAR2 ,
223 p_organization_id IN NUMBER ,
224 p_orientation_code IN NUMBER DEFAULT MTL_CCEOI_VAR_PVT.G_ORIENTATION_CODE,
225 p_cycle_count_header_id IN NUMBER DEFAULT MTL_CCEOI_VAR_PVT.G_CC_HEADER_ID)
226 ;
227 --
228 -- Is the item under Locator control
229 --Added NOCOPY hint to x_return_status,x_msg_count,x_msg_data ,x_locator_control
230 --x_level OUT parameters to comply with GSCC File.Sql.39 standard .Bug:4410902
231 PROCEDURE Locator_Control(
232 p_api_version IN NUMBER ,
233 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
234 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
235 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
236 x_return_status OUT NOCOPY VARCHAR2 ,
237 x_msg_count OUT NOCOPY NUMBER ,
238 x_msg_data OUT NOCOPY VARCHAR2 ,
239 p_org_control IN NUMBER ,
240 p_sub_control IN NUMBER ,
241 p_item_control IN NUMBER DEFAULT NULL,
242 p_restrict_flag IN NUMBER DEFAULT NULL,
243 p_neg_flag IN NUMBER DEFAULT NULL,
244 p_action IN NUMBER DEFAULT NULL,
245 x_locator_control OUT NOCOPY NUMBER ,
246 x_level OUT NOCOPY NUMBER )
247 ;
248 --
249 -- .
250 FUNCTION No_Neg_Balance(
251 restrict_flag IN NUMBER ,
252 neg_flag IN NUMBER DEFAULT 38,
253 action IN NUMBER DEFAULT 38)
254 RETURN VARCHAR2;
255 --
256
257 -- BEGIN INVCONV
258 PROCEDURE validate_secondarycountuom (
259 p_api_version IN NUMBER
260 , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
261 , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
262 , p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full
263 , x_return_status OUT NOCOPY VARCHAR2
264 , x_msg_count OUT NOCOPY NUMBER
265 , x_msg_data OUT NOCOPY VARCHAR2
266 , x_errorcode OUT NOCOPY NUMBER
267 , p_organization_id IN NUMBER
268 , p_inventory_item_id IN NUMBER
269 , p_secondary_uom IN VARCHAR2
270 , p_secondary_unit_of_measure IN VARCHAR2
271 , p_tracking_quantity_ind IN VARCHAR2);
272
273 PROCEDURE validate_secondarycountqty (
274 p_api_version IN NUMBER
275 , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
276 , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
277 , p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full
278 , p_precision IN NUMBER DEFAULT 5
279 , x_return_status OUT NOCOPY VARCHAR2
280 , x_msg_count OUT NOCOPY NUMBER
281 , x_msg_data OUT NOCOPY VARCHAR2
282 , x_errorcode OUT NOCOPY NUMBER
283 , p_organization_id IN NUMBER
284 , p_inventory_item_id IN NUMBER
285 , p_lot_number IN VARCHAR2
286 , p_count_uom IN VARCHAR2
287 , p_count_quantity IN NUMBER
288 , p_secondary_uom IN VARCHAR2
289 , p_secondary_quantity IN VARCHAR2
290 , p_tracking_quantity_ind IN VARCHAR2
291 , p_secondary_default_ind IN VARCHAR2);
292
293 -- END INVCONV
294
295 END MTL_INV_VALIDATE_GRP;