1 PACKAGE wms_parameter_pvt AUTHID CURRENT_USER AS
2 /* $Header: WMSVPPPS.pls 120.1.12020000.2 2013/01/31 07:20:36 ssrikaku ship $ */
3 --
4 -- File : WMSVPPPS.pls
5 -- Content : WMS_Parameter_PVT package specification
6 -- Description : WMS parameters private APIs
7 -- This package contains two types of functions:
8 -- 1. functions related to flexfield
9 -- 2. functions related to various quantity functions
10 --
11 -- Notes :
12 -- Modified : 02/08/99 mzeckzer created
13 -- 11/08/99 bitang moved to wms and added comment
14 --
15 -- Global Type and Constant Definition
16 --
17 -- Local copy of fnd globals to prevent pragma violations of api functions
18 -- to be used within 'select', 'where' and 'order by' clauses of dynamic
19 -- SQL build by wms rules engine
20 --
21 g_miss_num CONSTANT NUMBER := fnd_api.g_miss_num;
22 g_miss_char CONSTANT VARCHAR2(1) := fnd_api.g_miss_char;
23 g_miss_date CONSTANT DATE := fnd_api.g_miss_date;
24
25
26 -- Following global variables are use to cache the locator_id and and the qty_onhand to improve
27 -- the performance of the getItemonhand function() used in the rules defination query
28
29 TYPE g_itemOnhand_tab is table of Number index by binary_integer;
30 g_bulkCollect_Locator g_itemOnhand_tab;
31 g_bulkCollect_quantity g_itemOnhand_tab;
32 g_locator_item_quantity g_itemOnhand_tab;
33
34 -- Adding a global variable to cache the useage of new rule. These variable are initilized
35 -- after the rule is executed
36
37 g_GetItemOnhq_IsRuleCached VARCHAR2(1):= 'N';
38 g_GetProjAttr_IsRuleCached VARCHAR2(1):= 'N';
39
40 --
41 -- API name : ClearCache
42 -- Type : Private
43 -- Function : Clears the global cache used in the parameters file.
44 -- This will be called from the WMS_RULE_PVT package.
45 PROCEDURE ClearCache;
46
47 --
48 -- Functions Related To Flexfield
49 --
50 -- API name : IfFlexThenAvailable
51 -- Type : Private
52 -- Function : Returns 'N' if actual parameter is a key or descriptive
53 -- flexfield segment and not configured yet, returns 'Y' in
54 -- any other case.
55 -- ( Needed for all forms base views and LOV's regarding
56 -- parameters like rules, restrictions and sort criteria )
57 --
58 -- Input Parameters :
59 -- See the definition of corresponding column in WMS_PARAMETERS for
60 -- update-to-date information about the following input parameters.
61 --
62 -- p_db_object_ref_type_code:
63 -- 1 - single referenced ; 2 - multiple referenced
64 -- p_parameter_type_code:
65 -- 1 - column ; 2 - expression
66 -- p_flexfield_usage_code:
67 -- 'K' - key flexfield; 'D' - descriptive flexfield ;
68 -- null - not used in flexfield
69 -- p_flexfield_application_id:
70 -- id of the application in which the flexfield is defined
71 -- p_flexfield_name:
72 -- code of the key flexfield or name of the descriptive flexfield
73 -- p_column_name:
74 -- column name if the parameter is based on a table/view column
75 --
76 -- Notes : works for global segments only, not for context segments
77 --
78 FUNCTION IfFlexThenAvailable
79 ( p_db_object_ref_type_code IN NUMBER DEFAULT g_miss_num
80 ,p_parameter_type_code IN NUMBER DEFAULT g_miss_num
81 ,p_flexfield_usage_code IN VARCHAR2 DEFAULT g_miss_char
82 ,p_flexfield_application_id IN NUMBER DEFAULT g_miss_num
83 ,p_flexfield_name IN VARCHAR2 DEFAULT g_miss_char
84 ,p_column_name IN VARCHAR2 DEFAULT g_miss_char
85 ) RETURN VARCHAR2;
86 --
87 -- API name : GetFlexDataTypeCode
88 -- Type : Private
89 -- Function : Returns user-defined segment data type if actual parameter is
90 -- a key or descriptive flexfield segment and configured,
91 -- returns original data type in any other case.
92 -- ( Needed for all forms base views and LOV's regarding
93 -- parameters like rules, restrictions and sort criteria )
94 -- Input Parameters :
95 -- p_data_type_code:
96 -- data type of the flexfield segment
97 -- 1 - number ; 2 - character; 3 - date ; null - not given
98 --
99 -- See the comment in function IfFlexThenAvailable for the
100 -- meaning of the following input parameters.
101 --
102 -- p_db_object_ref_type_code
103 -- p_parameter_type_code
104 -- p_flexfield_usage_code
105 -- p_flexfield_application_id
106 -- p_flexfield_name
107 -- p_column_name
108 --
109 -- Notes : works for global segments only, not for context segments
110 FUNCTION GetFlexDataTypeCode
111 ( p_data_type_code IN NUMBER DEFAULT g_miss_num
112 ,p_db_object_ref_type_code IN NUMBER DEFAULT g_miss_num
113 ,p_parameter_type_code IN NUMBER DEFAULT g_miss_num
114 ,p_flexfield_usage_code IN VARCHAR2 DEFAULT g_miss_char
115 ,p_flexfield_application_id IN NUMBER DEFAULT g_miss_num
116 ,p_flexfield_name IN VARCHAR2 DEFAULT g_miss_char
117 ,p_column_name IN VARCHAR2 DEFAULT g_miss_char
118 ) RETURN NUMBER;
119 --
120 -- API name : GetFlexName
121 -- Type : Private
122 -- Function : Returns user-defined segment name if actual parameter is
123 -- a key or descriptive flexfield segment and configured,
124 -- returns original name in any other case.
125 -- ( Needed for all forms base views and LOV's regarding
126 -- parameters like rules, restrictions and sort criteria )
127 --
128 -- Input Parameters :
129 -- p_name:
130 -- name of the flexfield segment
131 --
132 -- See the comment in function IfFlexThenAvailable for the
133 -- meaning of the following input parameters.
134 --
135 -- p_db_object_ref_type_code
136 -- p_parameter_type_code
137 -- p_flexfield_usage_code
138 -- p_flexfield_application_id
139 -- p_flexfield_name
140 -- p_column_name
141 --
142 -- Notes : works for global segments only, not for context segments
143 --
144 FUNCTION GetFlexName
145 ( p_name IN VARCHAR2 DEFAULT g_miss_char
146 ,p_db_object_ref_type_code IN NUMBER DEFAULT g_miss_num
147 ,p_parameter_type_code IN NUMBER DEFAULT g_miss_num
148 ,p_flexfield_usage_code IN VARCHAR2 DEFAULT g_miss_char
149 ,p_flexfield_application_id IN NUMBER DEFAULT g_miss_num
150 ,p_flexfield_name IN VARCHAR2 DEFAULT g_miss_char
151 ,p_column_name IN VARCHAR2 DEFAULT g_miss_char
152 ) RETURN VARCHAR2;
153 --
154 -- API name : GetFlexDescription
155 -- Type : Private
156 -- Function : Returns user-defined segment description if actual parameter
157 -- is a key or descriptive flexfield segment and configured,
158 -- returns original description in any other case.
159 -- ( Needed for all forms base views and LOV's regarding
160 -- parameters like rules, restrictions and sort criteria )
161 --
162 -- Input Parameters:
163 -- p_description:
164 -- description of the flexfield segment
165 -- p_db_object_ref_type_code
166 -- p_parameter_type_code
167 -- p_flexfield_usage_code
168 -- p_flexfield_application_id
169 -- p_flexfield_name
170 -- p_column_name
171 --
172 -- Notes : works for global segments only, not for context segments
173 FUNCTION GetFlexDescription
174 ( p_description IN VARCHAR2 DEFAULT g_miss_char
175 ,p_db_object_ref_type_code IN NUMBER DEFAULT g_miss_num
176 ,p_parameter_type_code IN NUMBER DEFAULT g_miss_num
177 ,p_flexfield_usage_code IN VARCHAR2 DEFAULT g_miss_char
178 ,p_flexfield_application_id IN NUMBER DEFAULT g_miss_num
179 ,p_flexfield_name IN VARCHAR2 DEFAULT g_miss_char
180 ,p_column_name IN VARCHAR2 DEFAULT g_miss_char
181 ) RETURN VARCHAR2;
182 --
183 --
184 -- Functions related to quantity functions
185 --
186 -- API name : RoundUp
187 -- Type : Private
188 -- Function : Returns quantity, rounded up according actual and base units
189 -- of measure and the conversion defined between them.
190 -- ( Used for capacity and on-hand calculation parameters )
191 FUNCTION RoundUp
192 ( p_quantity IN NUMBER DEFAULT g_miss_num
193 ,p_transaction_uom IN VARCHAR2 DEFAULT g_miss_char
194 ,p_inventory_item_id IN NUMBER DEFAULT g_miss_num
195 ,p_base_uom IN VARCHAR2 DEFAULT g_miss_char
196 ) RETURN NUMBER;
197 --
198 -- API name : RoundDown
199 -- Type : Private
200 -- Function : Returns quantity, rounded down according actual and base
201 -- units of measure and the conversion defined between them.
202 -- ( Used for capacity and on-hand calculation parameters )
203 FUNCTION RoundDown
204 ( p_quantity IN NUMBER DEFAULT g_miss_num
205 ,p_transaction_uom IN VARCHAR2 DEFAULT g_miss_char
206 ,p_inventory_item_id IN NUMBER DEFAULT g_miss_num
207 ,p_base_uom IN VARCHAR2 DEFAULT g_miss_char
208 ) RETURN NUMBER;
209 --
210 -- API name : GetTotalUnitCapacity
211 -- Type : Private
212 -- Function : Returns total unit capacity of a location regardless any unit
213 -- of measure.
214 -- ( Used for capacity calculation parameters )
215 -- Notes : Since there are several situations, where unit capacity can
216 -- not be calculated, the following definitions are made:
217 -- - in case of subinventories w/o locators, capacity is
218 -- infinite
219 -- - in case of missing setup data at the locator, capacity is
220 -- infinite
221 FUNCTION GetTotalUnitCapacity
222 ( p_organization_id IN NUMBER DEFAULT g_miss_num
223 ,p_subinventory_code IN VARCHAR2 DEFAULT g_miss_char
224 ,p_locator_id IN NUMBER DEFAULT g_miss_num
225 ) RETURN NUMBER;
226 --
227 -- API name : GetOccupiedUnitCapacity
228 -- Type : Private
229 -- Function : Returns occupied unit capacity of a location regardless any
230 -- unit of measure.
231 -- ( Used for capacity calculation parameters )
232 FUNCTION GetOccupiedUnitCapacity
233 ( p_organization_id IN NUMBER DEFAULT g_miss_num
234 ,p_subinventory_code IN VARCHAR2 DEFAULT g_miss_char
235 ,p_locator_id IN NUMBER DEFAULT g_miss_num
236 ) RETURN NUMBER;
237 --
238 -- API name : GetAvailableUnitCapacity
239 -- Type : Private
240 -- Function : Returns available unit capacity of a location considering
241 -- on-hand stock regardless any unit of measure.
242 -- ( Used for capacity calculation parameters )
243 -- Notes : Since there are several situations, where unit capacity can
244 -- not be calculated, the following definitions are made:
245 -- - in case of subinventories w/o locators, capacity is
246 -- infinite
247 -- - in case of missing setup data at the locator, capacity is
248 -- infinite
249 FUNCTION GetAvailableUnitCapacity
250 ( p_organization_id IN NUMBER DEFAULT g_miss_num
251 ,p_subinventory_code IN VARCHAR2 DEFAULT g_miss_char
252 ,p_locator_id IN NUMBER DEFAULT g_miss_num
253 ) RETURN NUMBER;
254 --
255 -- API name : GetRemainingUnitCapacity
256 -- Type : Private
257 -- Function : Returns remaining unit capacity of a location, assuming the
258 -- actual receipt would have been performed already, regardless
259 -- any unit of measure.
260 -- ( Used for capacity calculation parameters )
261 -- Notes : Since there are several situations, where unit capacity can
262 -- not be calculated, the following definitions are made:
263 -- - in case of subinventories w/o locators, capacity is
264 -- infinite
265 -- - in case of missing setup data at the locator, capacity is
266 -- infinite
267 FUNCTION GetRemainingUnitCapacity
268 ( p_organization_id IN NUMBER DEFAULT g_miss_num
269 ,p_subinventory_code IN VARCHAR2 DEFAULT g_miss_char
270 ,p_locator_id IN NUMBER DEFAULT g_miss_num
271 ,p_transaction_quantity IN NUMBER DEFAULT g_miss_num
272 ) RETURN NUMBER;
273 --
274 -- API name : GetTotalVolumeCapacity
275 -- Type : Private
276 -- Function : Returns total volume or weight capacity of a location
277 -- measured in transaction UOM of the actual item.
278 -- Meaning: The function determines, how many items, measured in
279 -- transaction UOM, will fit into the location
280 -- according to their volume or weight.
281 -- ( Used for capacity calculation parameters )
282 -- Notes : Since there are several situations, where volume or weight
283 -- capacity can not be calculated, the following definitions are
284 -- made:
285 -- - in case of subinventories w/o locators, capacity is
286 -- infinite
287 -- - in case of missing setup data at the locator, capacity is
288 -- infinite
289 -- - in case of missing setup data at the item, capacity is
290 -- infinite ( meaning: item then has no volume or weight )
291 FUNCTION GetTotalVolumeCapacity
292 ( p_organization_id IN NUMBER DEFAULT g_miss_num
293 ,p_subinventory_code IN VARCHAR2 DEFAULT g_miss_char
294 ,p_locator_id IN NUMBER DEFAULT g_miss_num
295 ,p_inventory_item_id IN NUMBER DEFAULT g_miss_num
296 ,p_unit_volume IN NUMBER DEFAULT g_miss_num
297 ,p_unit_volume_uom_code IN VARCHAR2 DEFAULT g_miss_char
298 ,p_primary_uom IN VARCHAR2 DEFAULT g_miss_char
299 ,p_transaction_uom IN VARCHAR2 DEFAULT g_miss_char
300 ,p_base_uom IN VARCHAR2 DEFAULT g_miss_char
301 ) RETURN NUMBER;
302 --
303 -- API name : GetTotalWeightCapacity
304 -- Type : Private
305 -- Function : Returns total weight capacity of a location
309 -- according to their volume or weight.
306 -- measured in transaction UOM of the actual item.
307 -- Meaning: The function determines, how many items, measured in
308 -- transaction UOM, will fit into the location
310 -- ( Used for capacity calculation parameters )
311 -- Notes : Since there are several situations, where weight
312 -- capacity can not be calculated, the following definitions are
313 -- made:
314 -- - in case of subinventories w/o locators, capacity is
315 -- infinite
316 -- - in case of missing setup data at the locator, capacity is
317 -- infinite
318 -- - in case of missing setup data at the item, capacity is
319 -- infinite ( meaning: item then has no volume or weight )
320 FUNCTION GetTotalWeightCapacity
321 ( p_organization_id IN NUMBER DEFAULT g_miss_num
322 ,p_subinventory_code IN VARCHAR2 DEFAULT g_miss_char
323 ,p_locator_id IN NUMBER DEFAULT g_miss_num
324 ,p_inventory_item_id IN NUMBER DEFAULT g_miss_num
325 ,p_unit_weight IN NUMBER DEFAULT g_miss_num
326 ,p_unit_weight_uom_code IN VARCHAR2 DEFAULT g_miss_char
327 ,p_primary_uom IN VARCHAR2 DEFAULT g_miss_char
328 ,p_transaction_uom IN VARCHAR2 DEFAULT g_miss_char
329 ,p_base_uom IN VARCHAR2 DEFAULT g_miss_char
330 ) RETURN NUMBER;
331 --
332 -- API name : GetOccupiedVolumeCapacity
333 -- Type : Private
334 -- Function : Returns occupied volume capacity of a location measured in
335 -- transaction UOM of the actual item.
336 -- Meaning: The function determines, how many items, measured in
337 -- transaction UOM, virtually occupy the location
338 -- already according to their volume.
339 -- ( Used for capacity calculation parameters )
340 -- Notes : Since there are several situations, where volume capacity can
341 -- not be calculated, the following definitions are made:
342 -- - in case of missing setup data at the item, occupied
343 -- capacity is zero ( meaning: item then has no volume )
344 FUNCTION GetOccupiedVolumeCapacity
345 ( p_organization_id IN NUMBER DEFAULT g_miss_num
346 ,p_subinventory_code IN VARCHAR2 DEFAULT g_miss_char
347 ,p_locator_id IN NUMBER DEFAULT g_miss_num
348 ,p_inventory_item_id IN NUMBER DEFAULT g_miss_num
349 ,p_unit_volume IN NUMBER DEFAULT g_miss_num
350 ,p_unit_volume_uom_code IN VARCHAR2 DEFAULT g_miss_char
351 ,p_primary_uom IN VARCHAR2 DEFAULT g_miss_char
352 ,p_transaction_uom IN VARCHAR2 DEFAULT g_miss_char
353 ,p_base_uom IN VARCHAR2 DEFAULT g_miss_char
354 ) RETURN NUMBER;
355 --
356 -- API name : GetOccupiedWeightCapacity
357 -- Type : Private
358 -- Function : Returns occupied weight capacity of a location measured in
359 -- transaction UOM of the actual item.
360 -- Meaning: The function determines, how many items, measured in
361 -- transaction UOM, virtually occupy the location
362 -- already according to their weight.
363 -- ( Used for capacity calculation parameters )
364 -- Notes : Since there are several situations, where weight capacity can
365 -- not be calculated, the following definitions are made:
366 -- - in case of missing setup data at the item, occupied
367 -- capacity is zero ( meaning: item then has no weight )
368 FUNCTION GetOccupiedWeightCapacity
369 ( p_organization_id IN NUMBER DEFAULT g_miss_num
370 ,p_subinventory_code IN VARCHAR2 DEFAULT g_miss_char
371 ,p_locator_id IN NUMBER DEFAULT g_miss_num
372 ,p_inventory_item_id IN NUMBER DEFAULT g_miss_num
373 ,p_unit_weight IN NUMBER DEFAULT g_miss_num
374 ,p_unit_weight_uom_code IN VARCHAR2 DEFAULT g_miss_char
375 ,p_primary_uom IN VARCHAR2 DEFAULT g_miss_char
376 ,p_transaction_uom IN VARCHAR2 DEFAULT g_miss_char
377 ,p_base_uom IN VARCHAR2 DEFAULT g_miss_char
378 ) RETURN NUMBER;
379 --
380 -- API name : GetAvailableVolumeCapacity
381 -- Type : Private
382 -- Function : Returns available volume capacity of a location measured in
383 -- transaction UOM of the actual item.
384 -- Meaning: The function determines, how many items, measured in
385 -- transaction UOM, will fit into the location
386 -- according to their volume considering the capacity
387 -- already occupied by on-hand stock.
388 -- ( Used for capacity calculation parameters )
389 -- Notes : Since there are several situations, where volume capacity can
390 -- not be calculated, the following definitions are made:
391 -- - in case of subinventories w/o locators, capacity is
392 -- infinite
393 -- - in case of missing setup data at the locator, capacity is
394 -- infinite
395 -- - in case of missing setup data at the item, capacity is
396 -- infinite ( meaning: item then has no volume )
397 FUNCTION GetAvailableVolumeCapacity
398 ( p_organization_id IN NUMBER DEFAULT g_miss_num
399 ,p_subinventory_code IN VARCHAR2 DEFAULT g_miss_char
400 ,p_locator_id IN NUMBER DEFAULT g_miss_num
401 ,p_inventory_item_id IN NUMBER DEFAULT g_miss_num
402 ,p_unit_volume IN NUMBER DEFAULT g_miss_num
403 ,p_unit_volume_uom_code IN VARCHAR2 DEFAULT g_miss_char
404 ,p_primary_uom IN VARCHAR2 DEFAULT g_miss_char
405 ,p_transaction_uom IN VARCHAR2 DEFAULT g_miss_char
409 -- API name : GetAvailableWeightCapacity
406 ,p_base_uom IN VARCHAR2 DEFAULT g_miss_char
407 ) RETURN NUMBER;
408 --
410 -- Type : Private
411 -- Function : Returns available weight capacity of a location measured in
412 -- transaction UOM of the actual item.
413 -- Meaning: The function determines, how many items, measured in
414 -- transaction UOM, will fit into the location
415 -- according to their weight considering the capacity
416 -- already occupied by on-hand stock.
417 -- ( Used for capacity calculation parameters )
418 -- Notes : Since there are several situations, where weight capacity can
419 -- not be calculated, the following definitions are made:
420 -- - in case of subinventories w/o locators, capacity is
421 -- infinite
422 -- - in case of missing setup data at the locator, capacity is
423 -- infinite
424 -- - in case of missing setup data at the item, capacity is
425 -- infinite ( meaning: item then has no weight )
426 FUNCTION GetAvailableWeightCapacity
427 ( p_organization_id IN NUMBER DEFAULT g_miss_num
428 ,p_subinventory_code IN VARCHAR2 DEFAULT g_miss_char
429 ,p_locator_id IN NUMBER DEFAULT g_miss_num
430 ,p_inventory_item_id IN NUMBER DEFAULT g_miss_num
431 ,p_unit_weight IN NUMBER DEFAULT g_miss_num
432 ,p_unit_weight_uom_code IN VARCHAR2 DEFAULT g_miss_char
433 ,p_primary_uom IN VARCHAR2 DEFAULT g_miss_char
434 ,p_transaction_uom IN VARCHAR2 DEFAULT g_miss_char
435 ,p_base_uom IN VARCHAR2 DEFAULT g_miss_char
436 ) RETURN NUMBER;
437 --
438 -- API name : GetRemainingVolumeCapacity
439 -- Type : Private
440 -- Function : Returns remaining available volume capacity of a location
441 -- measured in transaction UOM of the actual item.
442 -- Meaning: The function determines, how many items, measured in
443 -- transaction UOM, will fit into the location
444 -- according to their volume considering the capacity
445 -- already occupied by on-hand stock and assuming the
446 -- actual receipt would have been performed already.
447 -- ( Used for capacity calculation parameters )
448 -- Notes : Since there are several situations, where volume capacity can
449 -- not be calculated, the following definitions are made:
450 -- - in case of subinventories w/o locators, capacity is
451 -- infinite
452 -- - in case of missing setup data at the locator, capacity is
453 -- infinite
454 -- - in case of missing setup data at the item, capacity is
455 -- infinite ( meaning: item then has no volume )
456 FUNCTION GetRemainingVolumeCapacity
457 ( p_organization_id IN NUMBER DEFAULT g_miss_num
458 ,p_subinventory_code IN VARCHAR2 DEFAULT g_miss_char
459 ,p_locator_id IN NUMBER DEFAULT g_miss_num
460 ,p_inventory_item_id IN NUMBER DEFAULT g_miss_num
461 ,p_unit_volume IN NUMBER DEFAULT g_miss_num
462 ,p_unit_volume_uom_code IN VARCHAR2 DEFAULT g_miss_char
463 ,p_primary_uom IN VARCHAR2 DEFAULT g_miss_char
464 ,p_transaction_uom IN VARCHAR2 DEFAULT g_miss_char
465 ,p_base_uom IN VARCHAR2 DEFAULT g_miss_char
466 ,p_transaction_quantity IN NUMBER DEFAULT g_miss_num
467 ) RETURN NUMBER;
468 --
469 -- API name : GetRemainingWeightCapacity
470 -- Type : Private
471 -- Function : Returns remaining available weight capacity of a location
472 -- measured in transaction UOM of the actual item.
473 -- Meaning: The function determines, how many items, measured in
474 -- transaction UOM, will fit into the location
475 -- according to their weight considering the capacity
476 -- already occupied by on-hand stock and assuming the
477 -- actual receipt would have been performed already.
478 -- ( Used for capacity calculation parameters )
479 -- Notes : Since there are several situations, where weight capacity can
480 -- not be calculated, the following definitions are made:
481 -- - in case of subinventories w/o locators, capacity is
482 -- infinite
483 -- - in case of missing setup data at the locator, capacity is
484 -- infinite
485 -- - in case of missing setup data at the item, capacity is
486 -- infinite ( meaning: item then has no weight )
487 FUNCTION GetRemainingWeightCapacity
488 ( p_organization_id IN NUMBER DEFAULT g_miss_num
489 ,p_subinventory_code IN VARCHAR2 DEFAULT g_miss_char
490 ,p_locator_id IN NUMBER DEFAULT g_miss_num
491 ,p_inventory_item_id IN NUMBER DEFAULT g_miss_num
492 ,p_unit_weight IN NUMBER DEFAULT g_miss_num
493 ,p_unit_weight_uom_code IN VARCHAR2 DEFAULT g_miss_char
494 ,p_primary_uom IN VARCHAR2 DEFAULT g_miss_char
495 ,p_transaction_uom IN VARCHAR2 DEFAULT g_miss_char
496 ,p_base_uom IN VARCHAR2 DEFAULT g_miss_char
497 ,p_transaction_quantity IN NUMBER DEFAULT g_miss_num
498 ) RETURN NUMBER;
499 --
500 -- API name : GetMinimumTotalVWCapacity
501 -- Type : Private
502 -- Function : Returns the minimum of total volume and total weight capacity
503 -- of a location measured in transaction UOM of the actual item.
504 -- ( Used for capacity calculation parameters )
505 -- Notes : refer to notes regarding the corresponding separate volume
509 ( p_organization_id IN NUMBER DEFAULT g_miss_num
506 -- and weight capacity functions.
507 --
508 FUNCTION GetMinimumTotalVWCapacity
510 ,p_subinventory_code IN VARCHAR2 DEFAULT g_miss_char
511 ,p_locator_id IN NUMBER DEFAULT g_miss_num
512 ,p_inventory_item_id IN NUMBER DEFAULT g_miss_num
513 ,p_unit_volume IN NUMBER DEFAULT g_miss_num
514 ,p_unit_volume_uom_code IN VARCHAR2 DEFAULT g_miss_char
515 ,p_unit_weight IN NUMBER DEFAULT g_miss_num
516 ,p_unit_weight_uom_code IN VARCHAR2 DEFAULT g_miss_char
517 ,p_primary_uom IN VARCHAR2 DEFAULT g_miss_char
518 ,p_transaction_uom IN VARCHAR2 DEFAULT g_miss_char
519 ,p_base_uom IN VARCHAR2 DEFAULT g_miss_char
520 ) RETURN NUMBER;
521
522 --
523 -- API name : GetMinimumTotalVWCapacity {OverLoaded}
524 -- Type : Private
525 -- Function : Returns the minimum of total volume and total weight capacity
526 -- of a location measured in transaction UOM of the actual item.
530 --
527 -- ( Used for capacity calculation parameters )
528 -- Notes : refer to notes regarding the corresponding separate volume
529 -- and weight capacity functions.
531 FUNCTION GetMinimumTotalVWCapacity
532 ( p_organization_id IN NUMBER DEFAULT g_miss_num
533 ,p_subinventory_code IN VARCHAR2 DEFAULT g_miss_char
534 ,p_locator_id IN NUMBER DEFAULT g_miss_num
535 ,p_inventory_item_id IN NUMBER DEFAULT g_miss_num
536 ,p_unit_volume IN NUMBER DEFAULT g_miss_num
537 ,p_unit_volume_uom_code IN VARCHAR2 DEFAULT g_miss_char
538 ,p_unit_weight IN NUMBER DEFAULT g_miss_num
539 ,p_unit_weight_uom_code IN VARCHAR2 DEFAULT g_miss_char
540 ,p_primary_uom IN VARCHAR2 DEFAULT g_miss_char
541 ,p_transaction_uom IN VARCHAR2 DEFAULT g_miss_char
542 ,p_base_uom IN VARCHAR2 DEFAULT g_miss_char
543 ,p_location_maximum_units IN NUMBER
544 ,p_location_current_units IN NUMBER
545 ,p_location_suggested_units IN NUMBER
546 ,p_location_available_units IN NUMBER
547 ,p_weight_uom_code IN VARCHAR2
548 ,p_max_weight IN NUMBER
549 ,p_current_weight IN NUMBER
550 ,p_suggested_weight IN NUMBER
551 ,p_available_weight IN NUMBER
552 ,p_volume_uom_code IN VARCHAR2
553 ,p_max_cubic_area IN NUMBER
554 ,p_current_cubic_area IN NUMBER
555 ,p_suggested_cubic_area IN NUMBER
556 ,p_available_cubic_area IN NUMBER
557 ) RETURN NUMBER;
558
559
560
561 --
562 -- API name : GetMaximumOccupiedVWCapacity
563 -- Type : Private
564 -- Function : Returns the maximum of occupied volume and occupied weight
565 -- capacity of a location measured in transaction UOM of the
566 -- actual item.
567 -- ( Used for capacity calculation parameters )
568 -- Notes : refer to notes regarding the corresponding separate volume
569 -- and weight capacity functions.
570 FUNCTION GetMaximumOccupiedVWCapacity
571 ( p_organization_id IN NUMBER DEFAULT g_miss_num
572 ,p_subinventory_code IN VARCHAR2 DEFAULT g_miss_char
573 ,p_locator_id IN NUMBER DEFAULT g_miss_num
574 ,p_inventory_item_id IN NUMBER DEFAULT g_miss_num
575 ,p_unit_volume IN NUMBER DEFAULT g_miss_num
576 ,p_unit_volume_uom_code IN VARCHAR2 DEFAULT g_miss_char
577 ,p_unit_weight IN NUMBER DEFAULT g_miss_num
578 ,p_unit_weight_uom_code IN VARCHAR2 DEFAULT g_miss_char
579 ,p_primary_uom IN VARCHAR2 DEFAULT g_miss_char
580 ,p_transaction_uom IN VARCHAR2 DEFAULT g_miss_char
581 ,p_base_uom IN VARCHAR2 DEFAULT g_miss_char
582 ) RETURN NUMBER;
583
584
585 --
586 -- API name : GetMaximumOccupiedVWCapacity {OverLoaded}
587 -- Type : Private
588 -- Function : Returns the maximum of occupied volume and occupied weight
589 -- capacity of a location measured in transaction UOM of the
590 -- actual item.
591 -- ( Used for capacity calculation parameters )
592 -- Notes : refer to notes regarding the corresponding separate volume
593 -- and weight capacity functions.
594 FUNCTION GetMaximumOccupiedVWCapacity
595 ( p_organization_id IN NUMBER DEFAULT g_miss_num
596 ,p_subinventory_code IN VARCHAR2 DEFAULT g_miss_char
597 ,p_locator_id IN NUMBER DEFAULT g_miss_num
598 ,p_inventory_item_id IN NUMBER DEFAULT g_miss_num
599 ,p_unit_volume IN NUMBER DEFAULT g_miss_num
600 ,p_unit_volume_uom_code IN VARCHAR2 DEFAULT g_miss_char
601 ,p_unit_weight IN NUMBER DEFAULT g_miss_num
602 ,p_unit_weight_uom_code IN VARCHAR2 DEFAULT g_miss_char
603 ,p_primary_uom IN VARCHAR2 DEFAULT g_miss_char
604 ,p_transaction_uom IN VARCHAR2 DEFAULT g_miss_char
605 ,p_base_uom IN VARCHAR2 DEFAULT g_miss_char
606 ,p_location_maximum_units IN NUMBER
607 ,p_location_current_units IN NUMBER
608 ,p_location_suggested_units IN NUMBER
609 ,p_location_available_units IN NUMBER
610 ,p_weight_uom_code IN VARCHAR2
611 ,p_max_weight IN NUMBER
612 ,p_current_weight IN NUMBER
613 ,p_suggested_weight IN NUMBER
614 ,p_available_weight IN NUMBER
615 ,p_volume_uom_code IN VARCHAR2
616 ,p_max_cubic_area IN NUMBER
617 ,p_current_cubic_area IN NUMBER
618 ,p_suggested_cubic_area IN NUMBER
619 ,p_available_cubic_area IN NUMBER
620 ) RETURN NUMBER;
621
622 --
623 -- API name : GetMinimumAvailableVWCapacity
624 -- Type : Private
625 -- Function : Returns the minimum of available volume and available weight
626 -- capacity of a location measured in transaction UOM of the
627 -- actual item.
628 -- ( Used for capacity calculation parameters )
629 -- Notes : refer to notes regarding the corresponding separate volume
630 -- and weight capacity functions.
631 FUNCTION GetMinimumAvailableVWCapacity
632 ( p_organization_id IN NUMBER DEFAULT g_miss_num
633 ,p_subinventory_code IN VARCHAR2 DEFAULT g_miss_char
634 ,p_locator_id IN NUMBER DEFAULT g_miss_num
635 ,p_inventory_item_id IN NUMBER DEFAULT g_miss_num
636 ,p_unit_volume IN NUMBER DEFAULT g_miss_num
637 ,p_unit_volume_uom_code IN VARCHAR2 DEFAULT g_miss_char
638 ,p_unit_weight IN NUMBER DEFAULT g_miss_num
639 ,p_unit_weight_uom_code IN VARCHAR2 DEFAULT g_miss_char
640 ,p_primary_uom IN VARCHAR2 DEFAULT g_miss_char
641 ,p_transaction_uom IN VARCHAR2 DEFAULT g_miss_char
642 ,p_base_uom IN VARCHAR2 DEFAULT g_miss_char
643 ) RETURN NUMBER;
644
645 --
649 -- capacity of a location measured in transaction UOM of the
646 -- API name : GetMinimumAvailableVWCapacity {OverLoaded}
647 -- Type : Private
648 -- Function : Returns the minimum of available volume and available weight
650 -- actual item.
651 -- ( Used for capacity calculation parameters )
652 -- Notes : refer to notes regarding the corresponding separate volume
653 -- and weight capacity functions.
654 FUNCTION GetMinimumAvailableVWCapacity
655 ( p_organization_id IN NUMBER DEFAULT g_miss_num
656 ,p_subinventory_code IN VARCHAR2 DEFAULT g_miss_char
657 ,p_locator_id IN NUMBER DEFAULT g_miss_num
658 ,p_inventory_item_id IN NUMBER DEFAULT g_miss_num
659 ,p_unit_volume IN NUMBER DEFAULT g_miss_num
660 ,p_unit_volume_uom_code IN VARCHAR2 DEFAULT g_miss_char
661 ,p_unit_weight IN NUMBER DEFAULT g_miss_num
665 ,p_base_uom IN VARCHAR2 DEFAULT g_miss_char
662 ,p_unit_weight_uom_code IN VARCHAR2 DEFAULT g_miss_char
663 ,p_primary_uom IN VARCHAR2 DEFAULT g_miss_char
664 ,p_transaction_uom IN VARCHAR2 DEFAULT g_miss_char
666 ,p_location_maximum_units IN NUMBER
667 ,p_location_current_units IN NUMBER
668 ,p_location_suggested_units IN NUMBER
669 ,p_location_available_units IN NUMBER
670 ,p_weight_uom_code IN VARCHAR2
671 ,p_max_weight IN NUMBER
672 ,p_current_weight IN NUMBER
673 ,p_suggested_weight IN NUMBER
674 ,p_available_weight IN NUMBER
675 ,p_volume_uom_code IN VARCHAR2
676 ,p_max_cubic_area IN NUMBER
677 ,p_current_cubic_area IN NUMBER
678 ,p_suggested_cubic_area IN NUMBER
679 ,p_available_cubic_area IN NUMBER
680 ) RETURN NUMBER;
681
682
683
684 --
685 -- API name : GetMinimumRemainingVWCapacity
686 -- Type : Private
687 -- Function : Returns the minimum of remaining available volume and
691 -- Notes : refer to notes regarding the corresponding separate volume
688 -- remaining available weight capacity of a location measured in
689 -- transaction UOM of the actual item.
690 -- ( Used for capacity calculation parameters )
692 -- and weight capacity functions.
693 FUNCTION GetMinimumRemainingVWCapacity
694 ( p_organization_id IN NUMBER DEFAULT g_miss_num
695 ,p_subinventory_code IN VARCHAR2 DEFAULT g_miss_char
696 ,p_locator_id IN NUMBER DEFAULT g_miss_num
697 ,p_inventory_item_id IN NUMBER DEFAULT g_miss_num
698 ,p_unit_volume IN NUMBER DEFAULT g_miss_num
699 ,p_unit_volume_uom_code IN VARCHAR2 DEFAULT g_miss_char
700 ,p_unit_weight IN NUMBER DEFAULT g_miss_num
701 ,p_unit_weight_uom_code IN VARCHAR2 DEFAULT g_miss_char
702 ,p_primary_uom IN VARCHAR2 DEFAULT g_miss_char
703 ,p_transaction_uom IN VARCHAR2 DEFAULT g_miss_char
704 ,p_base_uom IN VARCHAR2 DEFAULT g_miss_char
705 ,p_transaction_quantity IN NUMBER DEFAULT g_miss_num
706 ) RETURN NUMBER;
707
708 --
709 -- API name : GetMinimumRemainingVWCapacity {OverLoaded}
710 -- Type : Private
711 -- Function : Returns the minimum of remaining available volume and
712 -- remaining available weight capacity of a location measured in
713 -- transaction UOM of the actual item.
714 -- ( Used for capacity calculation parameters )
715 -- Notes : refer to notes regarding the corresponding separate volume
716 -- and weight capacity functions.
717 FUNCTION GetMinimumRemainingVWCapacity
718 ( p_organization_id IN NUMBER DEFAULT g_miss_num
719 ,p_subinventory_code IN VARCHAR2 DEFAULT g_miss_char
720 ,p_locator_id IN NUMBER DEFAULT g_miss_num
721 ,p_inventory_item_id IN NUMBER DEFAULT g_miss_num
722 ,p_unit_volume IN NUMBER DEFAULT g_miss_num
723 ,p_unit_volume_uom_code IN VARCHAR2 DEFAULT g_miss_char
724 ,p_unit_weight IN NUMBER DEFAULT g_miss_num
725 ,p_unit_weight_uom_code IN VARCHAR2 DEFAULT g_miss_char
726 ,p_primary_uom IN VARCHAR2 DEFAULT g_miss_char
727 ,p_transaction_uom IN VARCHAR2 DEFAULT g_miss_char
728 ,p_base_uom IN VARCHAR2 DEFAULT g_miss_char
729 ,p_transaction_quantity IN NUMBER DEFAULT g_miss_num
730 ,p_location_maximum_units IN NUMBER
731 ,p_location_current_units IN NUMBER
732 ,p_location_suggested_units IN NUMBER
733 ,p_location_available_units IN NUMBER
734 ,p_weight_uom_code IN VARCHAR2
735 ,p_max_weight IN NUMBER
736 ,p_current_weight IN NUMBER
737 ,p_suggested_weight IN NUMBER
738 ,p_available_weight IN NUMBER
739 ,p_volume_uom_code IN VARCHAR2
740 ,p_max_cubic_area IN NUMBER
741 ,p_current_cubic_area IN NUMBER
742 ,p_suggested_cubic_area IN NUMBER
743 ,p_available_cubic_area IN NUMBER
744 ) RETURN NUMBER;
745
746 --
747 -- API name : GetMinimumTotalUVWCapacity
748 -- Type : Private
749 -- Function : Returns the minimum of total unit, total volume and total
750 -- weight capacity of a location measured in transaction UOM of
751 -- the actual item.
752 -- ( Used for capacity calculation parameters )
753 -- Notes : refer to notes regarding the corresponding separate unit,
754 -- volume and weight capacity functions.
755 FUNCTION GetMinimumTotalUVWCapacity
756 ( p_organization_id IN NUMBER DEFAULT g_miss_num
757 ,p_subinventory_code IN VARCHAR2 DEFAULT g_miss_char
758 ,p_locator_id IN NUMBER DEFAULT g_miss_num
759 ,p_inventory_item_id IN NUMBER DEFAULT g_miss_num
760 ,p_unit_volume IN NUMBER DEFAULT g_miss_num
761 ,p_unit_volume_uom_code IN VARCHAR2 DEFAULT g_miss_char
762 ,p_unit_weight IN NUMBER DEFAULT g_miss_num
763 ,p_unit_weight_uom_code IN VARCHAR2 DEFAULT g_miss_char
764 ,p_primary_uom IN VARCHAR2 DEFAULT g_miss_char
765 ,p_transaction_uom IN VARCHAR2 DEFAULT g_miss_char
766 ,p_base_uom IN VARCHAR2 DEFAULT g_miss_char
767 ) RETURN NUMBER;
768 --
769 -- API name : GetMinimumTotalUVWCapacity {OverLoaded}
770 -- Type : Private
771 -- Function : Returns the minimum of total unit, total volume and total
772 -- weight capacity of a location measured in transaction UOM of
773 -- the actual item.
774 -- ( Used for capacity calculation parameters )
775 -- Notes : refer to notes regarding the corresponding separate unit,
776 -- volume and weight capacity functions.
777 FUNCTION GetMinimumTotalUVWCapacity
778 ( p_organization_id IN NUMBER DEFAULT g_miss_num
779 ,p_subinventory_code IN VARCHAR2 DEFAULT g_miss_char
780 ,p_locator_id IN NUMBER DEFAULT g_miss_num
781 ,p_inventory_item_id IN NUMBER DEFAULT g_miss_num
782 ,p_unit_volume IN NUMBER DEFAULT g_miss_num
783 ,p_unit_volume_uom_code IN VARCHAR2 DEFAULT g_miss_char
784 ,p_unit_weight IN NUMBER DEFAULT g_miss_num
785 ,p_unit_weight_uom_code IN VARCHAR2 DEFAULT g_miss_char
786 ,p_primary_uom IN VARCHAR2 DEFAULT g_miss_char
787 ,p_transaction_uom IN VARCHAR2 DEFAULT g_miss_char
788 ,p_base_uom IN VARCHAR2 DEFAULT g_miss_char
789 ,p_location_maximum_units IN NUMBER
790 ,p_location_current_units IN NUMBER
791 ,p_location_suggested_units IN NUMBER
792 ,p_location_available_units IN NUMBER
793 ,p_weight_uom_code IN VARCHAR2
794 ,p_max_weight IN NUMBER
795 ,p_current_weight IN NUMBER
799 ,p_max_cubic_area IN NUMBER
796 ,p_suggested_weight IN NUMBER
797 ,p_available_weight IN NUMBER
798 ,p_volume_uom_code IN VARCHAR2
800 ,p_current_cubic_area IN NUMBER
801 ,p_suggested_cubic_area IN NUMBER
802 ,p_available_cubic_area IN NUMBER
803 ) RETURN NUMBER;
804
805 --
806 -- API name : GetMaximumOccupiedUVWCapacity
807 -- Type : Private
808 -- Function : Returns the maximum of occupied unit, occupied volume and
809 -- occupied weight capacity of a location measured in
810 -- transaction UOM of the actual item.
811 -- ( Used for capacity calculation parameters )
812 -- Notes : refer to notes regarding the corresponding separate unit,
813 -- volume and weight capacity functions.
814 FUNCTION GetMaximumOccupiedUVWCapacity
815 ( p_organization_id IN NUMBER DEFAULT g_miss_num
816 ,p_subinventory_code IN VARCHAR2 DEFAULT g_miss_char
817 ,p_locator_id IN NUMBER DEFAULT g_miss_num
818 ,p_inventory_item_id IN NUMBER DEFAULT g_miss_num
819 ,p_unit_volume IN NUMBER DEFAULT g_miss_num
820 ,p_unit_volume_uom_code IN VARCHAR2 DEFAULT g_miss_char
821 ,p_unit_weight IN NUMBER DEFAULT g_miss_num
822 ,p_unit_weight_uom_code IN VARCHAR2 DEFAULT g_miss_char
823 ,p_primary_uom IN VARCHAR2 DEFAULT g_miss_char
824 ,p_transaction_uom IN VARCHAR2 DEFAULT g_miss_char
825 ,p_base_uom IN VARCHAR2 DEFAULT g_miss_char
826 ) RETURN NUMBER;
827 --
828 -- API name : GetMaximumOccupiedUVWCapacity {OverLoaded}
829 -- Type : Private
830 -- Function : Returns the maximum of occupied unit, occupied volume and
831 -- occupied weight capacity of a location measured in
832 -- transaction UOM of the actual item.
833 -- ( Used for capacity calculation parameters )
834 -- Notes : refer to notes regarding the corresponding separate unit,
835 -- volume and weight capacity functions.
836 FUNCTION GetMaximumOccupiedUVWCapacity
837 ( p_organization_id IN NUMBER DEFAULT g_miss_num
838 ,p_subinventory_code IN VARCHAR2 DEFAULT g_miss_char
839 ,p_locator_id IN NUMBER DEFAULT g_miss_num
840 ,p_inventory_item_id IN NUMBER DEFAULT g_miss_num
841 ,p_unit_volume IN NUMBER DEFAULT g_miss_num
842 ,p_unit_volume_uom_code IN VARCHAR2 DEFAULT g_miss_char
843 ,p_unit_weight IN NUMBER DEFAULT g_miss_num
844 ,p_unit_weight_uom_code IN VARCHAR2 DEFAULT g_miss_char
845 ,p_primary_uom IN VARCHAR2 DEFAULT g_miss_char
846 ,p_transaction_uom IN VARCHAR2 DEFAULT g_miss_char
847 ,p_base_uom IN VARCHAR2 DEFAULT g_miss_char
848 ,p_location_maximum_units IN NUMBER
849 ,p_location_current_units IN NUMBER
850 ,p_location_suggested_units IN NUMBER
851 ,p_location_available_units IN NUMBER
852 ,p_weight_uom_code IN VARCHAR2
853 ,p_max_weight IN NUMBER
854 ,p_current_weight IN NUMBER
855 ,p_suggested_weight IN NUMBER
856 ,p_available_weight IN NUMBER
857 ,p_volume_uom_code IN VARCHAR2
858 ,p_max_cubic_area IN NUMBER
859 ,p_current_cubic_area IN NUMBER
860 ,p_suggested_cubic_area IN NUMBER
861 ,p_available_cubic_area IN NUMBER
862 ) RETURN NUMBER;
863 --
864 -- API name : GetMinimumAvailableUVWCapacity
865 -- Type : Private
866 -- Function : Returns the minimum of available unit, available volume and
867 -- available weight capacity of a location measured in
868 -- transaction UOM of the actual item.
869 -- ( Used for capacity calculation parameters )
870 -- Notes : refer to notes regarding the corresponding separate unit,
871 -- volume and weight capacity functions.
872 FUNCTION GetMinimumAvailableUVWCapacity
873 ( p_organization_id IN NUMBER DEFAULT g_miss_num
874 ,p_subinventory_code IN VARCHAR2 DEFAULT g_miss_char
875 ,p_locator_id IN NUMBER DEFAULT g_miss_num
876 ,p_inventory_item_id IN NUMBER DEFAULT g_miss_num
877 ,p_unit_volume IN NUMBER DEFAULT g_miss_num
878 ,p_unit_volume_uom_code IN VARCHAR2 DEFAULT g_miss_char
879 ,p_unit_weight IN NUMBER DEFAULT g_miss_num
880 ,p_unit_weight_uom_code IN VARCHAR2 DEFAULT g_miss_char
881 ,p_primary_uom IN VARCHAR2 DEFAULT g_miss_char
882 ,p_transaction_uom IN VARCHAR2 DEFAULT g_miss_char
883 ,p_base_uom IN VARCHAR2 DEFAULT g_miss_char
884 ) RETURN NUMBER;
885 --
886 -- API name : GetMinimumAvailableUVWCapacity {OverLoaded}
887 -- Type : Private
888 -- Function : Returns the minimum of available unit, available volume and
889 -- available weight capacity of a location measured in
890 -- transaction UOM of the actual item.
891 -- ( Used for capacity calculation parameters )
892 -- Notes : refer to notes regarding the corresponding separate unit,
896 ,p_subinventory_code IN VARCHAR2 DEFAULT g_miss_char
893 -- volume and weight capacity functions.
894 FUNCTION GetMinimumAvailableUVWCapacity
895 ( p_organization_id IN NUMBER DEFAULT g_miss_num
897 ,p_locator_id IN NUMBER DEFAULT g_miss_num
898 ,p_inventory_item_id IN NUMBER DEFAULT g_miss_num
899 ,p_unit_volume IN NUMBER DEFAULT g_miss_num
900 ,p_unit_volume_uom_code IN VARCHAR2 DEFAULT g_miss_char
901 ,p_unit_weight IN NUMBER DEFAULT g_miss_num
902 ,p_unit_weight_uom_code IN VARCHAR2 DEFAULT g_miss_char
903 ,p_primary_uom IN VARCHAR2 DEFAULT g_miss_char
904 ,p_transaction_uom IN VARCHAR2 DEFAULT g_miss_char
905 ,p_base_uom IN VARCHAR2 DEFAULT g_miss_char
906 ,p_location_maximum_units IN NUMBER
907 ,p_location_current_units IN NUMBER
908 ,p_location_suggested_units IN NUMBER
909 ,p_location_available_units IN NUMBER
910 ,p_weight_uom_code IN VARCHAR2
911 ,p_max_weight IN NUMBER
912 ,p_current_weight IN NUMBER
913 ,p_suggested_weight IN NUMBER
914 ,p_available_weight IN NUMBER
915 ,p_volume_uom_code IN VARCHAR2
916 ,p_max_cubic_area IN NUMBER
917 ,p_current_cubic_area IN NUMBER
918 ,p_suggested_cubic_area IN NUMBER
919 ,p_available_cubic_area IN NUMBER
920 ) RETURN NUMBER;
921
922 --
923 -- API name : GetMinimumRemainingUVWCapacity
924 -- Type : Private
925 -- Function : Returns the minimum of remaining available unit, remaining
926 -- available volume and remaining available weight capacity of
927 -- a location measured in transaction UOM of the actual item.
931 FUNCTION GetMinimumRemainingUVWCapacity
928 -- ( Used for capacity calculation parameters )
929 -- Notes : refer to notes regarding the corresponding separate unit,
930 -- volume and weight capacity functions.
932 ( p_organization_id IN NUMBER DEFAULT g_miss_num
933 ,p_subinventory_code IN VARCHAR2 DEFAULT g_miss_char
934 ,p_locator_id IN NUMBER DEFAULT g_miss_num
935 ,p_inventory_item_id IN NUMBER DEFAULT g_miss_num
936 ,p_unit_volume IN NUMBER DEFAULT g_miss_num
937 ,p_unit_volume_uom_code IN VARCHAR2 DEFAULT g_miss_char
938 ,p_unit_weight IN NUMBER DEFAULT g_miss_num
939 ,p_unit_weight_uom_code IN VARCHAR2 DEFAULT g_miss_char
940 ,p_primary_uom IN VARCHAR2 DEFAULT g_miss_char
941 ,p_transaction_uom IN VARCHAR2 DEFAULT g_miss_char
942 ,p_base_uom IN VARCHAR2 DEFAULT g_miss_char
943 ,p_transaction_quantity IN NUMBER DEFAULT g_miss_num
944 ) RETURN NUMBER;
945
946 --
947 -- API name : GetMinimumRemainingUVWCapacity {OverLoaded}
948 -- Type : Private
949 -- Function : Returns the minimum of remaining available unit, remaining
950 -- available volume and remaining available weight capacity of
951 -- a location measured in transaction UOM of the actual item.
952 -- ( Used for capacity calculation parameters )
953 -- Notes : refer to notes regarding the corresponding separate unit,
954 -- volume and weight capacity functions.
955 FUNCTION GetMinimumRemainingUVWCapacity
956 ( p_organization_id IN NUMBER DEFAULT g_miss_num
957 ,p_subinventory_code IN VARCHAR2 DEFAULT g_miss_char
958 ,p_locator_id IN NUMBER DEFAULT g_miss_num
959 ,p_inventory_item_id IN NUMBER DEFAULT g_miss_num
960 ,p_unit_volume IN NUMBER DEFAULT g_miss_num
961 ,p_unit_volume_uom_code IN VARCHAR2 DEFAULT g_miss_char
962 ,p_unit_weight IN NUMBER DEFAULT g_miss_num
963 ,p_unit_weight_uom_code IN VARCHAR2 DEFAULT g_miss_char
964 ,p_primary_uom IN VARCHAR2 DEFAULT g_miss_char
965 ,p_transaction_uom IN VARCHAR2 DEFAULT g_miss_char
966 ,p_base_uom IN VARCHAR2 DEFAULT g_miss_char
970 ,p_location_suggested_units IN NUMBER
967 ,p_transaction_quantity IN NUMBER DEFAULT g_miss_num
968 ,p_location_maximum_units IN NUMBER
969 ,p_location_current_units IN NUMBER
971 ,p_location_available_units IN NUMBER
972 ,p_weight_uom_code IN VARCHAR2
973 ,p_max_weight IN NUMBER
974 ,p_current_weight IN NUMBER
975 ,p_suggested_weight IN NUMBER
976 ,p_available_weight IN NUMBER
977 ,p_volume_uom_code IN VARCHAR2
978 ,p_max_cubic_area IN NUMBER
979 ,p_current_cubic_area IN NUMBER
980 ,p_suggested_cubic_area IN NUMBER
981 ,p_available_cubic_area IN NUMBER
982 ) RETURN NUMBER;
983
984 -- API name : GetItemOnHand
985 -- Type : Private
986 -- Function : Returns on hand stock of a given inventory item
987 -- in the transaction UOM.
988 -- ( Used for capacity calculation parameters )
989 FUNCTION GetItemOnHand
990 ( p_organization_id IN NUMBER DEFAULT g_miss_num
991 ,p_inventory_item_id IN NUMBER DEFAULT g_miss_num
992 ,p_subinventory_code IN VARCHAR2 DEFAULT g_miss_char
993 ,p_locator_id IN NUMBER DEFAULT g_miss_num
994 ,p_primary_uom IN VARCHAR2 DEFAULT g_miss_char
995 ,p_transaction_uom IN VARCHAR2 DEFAULT g_miss_char
996 ,p_locator_inventory_item_id IN NUMBER DEFAULT NULL
997 ,p_location_current_units IN NUMBER DEFAULT NULL
998 ) RETURN NUMBER;
999
1000 -- API name : GetTotalOnHand
1001 -- Type : Private
1002 -- Function : Returns on hand stock of a given locator
1003 -- (all items) in the transaction UOM
1004 -- ( Used for capacity calculation parameters )
1005 FUNCTION GetTotalOnHand
1006 ( p_organization_id IN NUMBER DEFAULT g_miss_num
1007 ,p_subinventory_code IN VARCHAR2 DEFAULT g_miss_char
1008 ,p_locator_id IN NUMBER DEFAULT g_miss_num
1009 ,p_transaction_uom IN VARCHAR2 DEFAULT g_miss_char
1010 ,p_locator_inventory_item_id IN NUMBER DEFAULT NULL
1011 ,p_location_current_units IN NUMBER DEFAULT NULL
1012 ,p_empty_flag IN VARCHAR2 DEFAULT NULL
1013 ) RETURN NUMBER;
1014
1015 -- API name : IsItemInLocator
1016 -- Type : Private
1017 -- Function : Returns 'Y' if the given item resides in the given
1018 -- locator, 'N' otherwise
1019 FUNCTION IsItemInLocator
1020 ( p_organization_id IN NUMBER
1021 ,p_inventory_item_id IN NUMBER
1022 ,p_subinventory_code IN VARCHAR2
1023 ,p_locator_id IN NUMBER
1024 ) RETURN VARCHAR2;
1025
1026 -- API name : GetOuterLpnQuantityRevLot
1027 -- Type : Private
1028 -- Function : Returns quantity of the given item, revision, and lot
1029 -- in the outermost LPN containing the given LPN
1030 FUNCTION GetOuterLpnQuantityRevLot
1031 ( p_lpn_id IN NUMBER
1032 ,p_inventory_item_id IN NUMBER
1033 ,p_revision IN VARCHAR2
1034 ,p_lot_number IN VARCHAR2
1035 ) RETURN NUMBER;
1036
1037 -- API name : GetOuterLpnQuantity
1038 -- Type : Private
1039 -- Function : Returns quantity of the given item
1040 -- in the outermost LPN containing the given LPN
1041 FUNCTION GetOuterLpnQuantity
1042 ( p_lpn_id IN NUMBER
1043 ,p_inventory_item_id IN NUMBER
1044 ) RETURN NUMBER;
1045
1046 -- API name : GetOuterLpnNumOtherItems
1047 -- Type : Private
1048 -- Function : Returns number of items - 1
1049 -- in the outermost LPN containing the given LPN
1050 FUNCTION GetOuterLpnNumOtherItems
1051 ( p_lpn_id IN NUMBER
1052 ) RETURN NUMBER;
1053
1054 -- API name : GetOuterLpnNumOtherRevs
1055 -- Type : Private
1056 -- Function : Returns number of revisions of this item - 1
1057 -- in the outermost LPN containing the given LPN
1058 FUNCTION GetOuterLpnNumOtherRevs
1059 ( p_lpn_id IN NUMBER
1060 ,p_inventory_item_id IN NUMBER
1061 ) RETURN NUMBER;
1062
1063 -- API name : GetOuterLpnNumOtherRevs
1064 -- Type : Private
1065 -- Function : Returns number of lots of this item - 1
1066 -- in the outermost LPN containing the given LPN
1067 FUNCTION GetOuterLpnNumOtherLots
1068 ( p_lpn_id IN NUMBER
1069 ,p_inventory_item_id IN NUMBER
1070 ) RETURN NUMBER;
1071
1072
1073 -- API name : GetLpnQuantityRevLot
1074 -- Type : Private
1075 -- Function : Returns quantity of the given item, revision, and lot
1076 -- in the given LPN
1080 ,p_revision IN VARCHAR2
1077 FUNCTION GetLpnQuantityRevLot
1078 ( p_lpn_id IN NUMBER
1079 ,p_inventory_item_id IN NUMBER
1081 ,p_lot_number IN VARCHAR2
1082 ) RETURN NUMBER;
1083
1084 -- API name : GetLpnQuantity
1085 -- Type : Private
1086 -- Function : Returns quantity of the given item
1087 -- in the given LPN
1088 FUNCTION GetLpnQuantity
1089 ( p_lpn_id IN NUMBER
1090 ,p_inventory_item_id IN NUMBER
1091 ) RETURN NUMBER;
1092
1093 -- API name : GetLpnNumOtherItems
1094 -- Type : Private
1095 -- Function : Returns number of items - 1
1096 -- in the the given LPN
1097 FUNCTION GetLpnNumOtherItems
1098 ( p_lpn_id IN NUMBER
1099 ) RETURN NUMBER;
1100
1101 -- API name : GetLpnNumOtherRevs
1102 -- Type : Private
1103 -- Function : Returns number of revisions of this item - 1
1104 -- in the given LPN
1105 FUNCTION GetLpnNumOtherRevs
1106 ( p_lpn_id IN NUMBER
1107 ,p_inventory_item_id IN NUMBER
1108 ) RETURN NUMBER;
1109
1110 -- API name : GetLpnNumOtherLots
1111 -- Type : Private
1112 -- Function : Returns number of lots of this item - 1
1113 -- in the the given LPN
1114 FUNCTION GetLpnNumOtherLots
1115 ( p_lpn_id IN NUMBER
1116 ,p_inventory_item_id IN NUMBER
1117 ) RETURN NUMBER;
1118
1119 -- API name : GetLpnNumNestedLevels
1120 -- Type : Private
1121 -- Function : Returns number of LPNs between this LPN and the outermost
1122 -- LPN containing this LPN
1123 FUNCTION GetLpnNumNestedLevels
1124 ( p_lpn_id IN NUMBER
1125 ) RETURN NUMBER;
1126
1127
1128 --==============================================================
1129 -- API name : GetPOHeaderLineID
1130 -- Type : Private
1131 -- Function : Returns PO Header ID or Line ID based on Move Order Line
1132 -- Reference and Reference ID and header or line flag.
1133 -- ( Used for join condition in seed data )
1134 FUNCTION GetPOHeaderLineID
1135 ( p_transaction_source_type_id IN NUMBER
1136 ,p_reference IN VARCHAR2 DEFAULT g_miss_char
1137 ,p_reference_id IN NUMBER DEFAULT g_miss_num
1138 ,p_header_flag IN VARCHAR2 DEFAULT 'N'
1139 ,p_line_flag IN VARCHAR2 DEFAULT 'N'
1140 ) RETURN NUMBER;
1141
1142 -- API name : GetProxPickOrder
1143 -- Type : Private
1144 -- Function : Returns the minimum distance between this locator
1145 -- and the nearest locator containing the item,
1146 -- as calculated using locator picking order
1147 -- ( Used for building rules)
1148 FUNCTION GetProxPickOrder(
1149 p_organization_id IN NUMBER,
1150 p_inventory_item_id IN NUMBER,
1151 p_subinventory_code IN VARCHAR2,
1152 p_locator_id IN NUMBER
1153 ) RETURN NUMBER;
1154
1155 -- API name : GetProxCoordinates
1156 -- Type : Private
1157 -- Function : Returns the minimum distance between this locator
1158 -- and the nearest locator containing the item,
1159 -- as calculated using xyz coordinates
1160 -- ( Used for building rules)
1161 FUNCTION GetProxCoordinates(
1162 p_organization_id IN NUMBER,
1163 p_inventory_item_id IN NUMBER,
1164 p_subinventory_code IN VARCHAR2,
1165 p_locator_id IN NUMBER
1166 ) RETURN NUMBER;
1167
1168 -- API name : GetNumOtherItems
1169 -- Type : Private
1170 -- Function : Returns the number of items within the locator
1171 -- other than the item passed in as a parameter
1172 -- ( Used for building rules)
1173 FUNCTION GetNumOtherItems(
1174 p_organization_id IN NUMBER,
1175 p_inventory_item_id IN NUMBER,
1176 p_subinventory_code IN VARCHAR2,
1177 p_locator_id IN NUMBER,
1178 p_locator_inventory_item_id IN NUMBER DEFAULT NULL
1179 ) RETURN NUMBER;
1180
1181 -- API name : GetNumOtherLots
1182 -- Type : Private
1183 -- Function : Returns the number of lots for the given item
1184 -- within the locator other than the given lot
1185 -- ( Used for building rules)
1186 FUNCTION GetNumOtherLots(
1187 p_organization_id IN NUMBER,
1188 p_inventory_item_id IN NUMBER,
1189 p_subinventory_code IN VARCHAR2,
1190 p_locator_id IN NUMBER,
1191 p_lot_number IN VARCHAR2
1192 ) RETURN NUMBER;
1193
1194 -- API name : GetNumOtherRevisions
1195 -- Type : Private
1196 -- Function : Returns the number of revisions for the given item
1197 -- within the locator other than the given revision
1198 -- ( Used for building rules)
1199 FUNCTION GetNumOtherRevisions(
1200 p_organization_id IN NUMBER,
1201 p_inventory_item_id IN NUMBER,
1202 p_subinventory_code IN VARCHAR2,
1203 p_locator_id IN NUMBER,
1204 p_revision IN VARCHAR2
1205 ) RETURN NUMBER;
1206
1207 -- API name : GetNumEmptyLocators
1208 -- Type : Private
1209 -- Function : Returns the number of empty locators in the given
1210 -- subinventory and organization.
1214 ,p_subinventory_code IN VARCHAR2
1211 -- ( Used for building rules)
1212 FUNCTION GetNumEmptyLocators(
1213 p_organization_id IN NUMBER
1215 ) RETURN NUMBER;
1216
1217 --
1218 --==============================================================
1219 -- API name : GetSOHeaderLineID
1220 -- Type : Private
1221 -- Function : Returns Sale Order Header ID or Line ID based
1222 -- on Move Order Line reference and Reference ID
1223 -- and header or line flag.
1224 -- ( Used for join condition in seed data )
1225
1226 FUNCTION GetSOHeaderLineID
1227 ( p_line_id IN NUMBER
1228 ,p_transaction_source_type_id IN NUMBER DEFAULT g_miss_num
1229 ,p_reference IN VARCHAR2 DEFAULT g_miss_char
1230 ,p_reference_id IN NUMBER DEFAULT g_miss_num
1231 ,p_header_flag IN VARCHAR2 DEFAULT 'N'
1232 ,p_line_flag IN VARCHAR2 DEFAULT 'N'
1233 ) RETURN NUMBER;
1234
1235 FUNCTION CART_LPN_CONTAINS_ENTIRE_DEL
1236 (p_lpn_id IN NUMBER,
1237 p_delivery_id IN NUMBER,
1238 p_business_flow_code IN NUMBER)
1239 return VARCHAR2;
1240
1241 FUNCTION GetEarliestReceiptDate
1242 ( p_org_id IN NUMBER
1243 ,p_item_id IN NUMBER
1244 ,p_sub IN VARCHAR2
1245 ,p_loc_id IN NUMBER DEFAULT NULL
1249
1246 ,p_lot IN VARCHAR2 DEFAULT NULL
1247 ,p_rev IN VARCHAR2 DEFAULT NULL
1248 ) RETURN Date;
1250 FUNCTION IS_WIP_TRANSACTION
1251 (p_transaction_temp_id IN NUMBER)
1252 RETURN VARCHAR2;
1253
1254 FUNCTION IS_WIP_MOVE_ORDER(p_header_id IN NUMBER)
1255 RETURN VARCHAR2;
1256
1257 /*LPN Status Project*/
1258 FUNCTION GET_MATERIAL_STATUS(
1259 p_status_id IN NUMBER DEFAULT NULL)
1260 RETURN VARCHAR2;
1261
1262 -- addition starts for bug 16245506
1263
1264 -- API name : GetOuterLpnSecQuantity
1265 -- Type : Private
1266 -- Function : Returns secondary quantity of the given item
1267 -- in the outermost LPN containing the given LPN
1268 FUNCTION GetOuterLpnSecQuantity
1269 ( p_lpn_id IN NUMBER
1270 ,p_inventory_item_id IN NUMBER
1271 ) RETURN NUMBER;
1272
1273 -- API name : GetLpnSecQuantity
1274 -- Type : Private
1275 -- Function : Returns Secondary quantity of the given item
1276 -- in the given LPN
1277
1278 FUNCTION GetLpnSecQuantity
1279 ( p_lpn_id IN NUMBER
1280 , p_inventory_item_id IN NUMBER
1281 ) RETURN NUMBER;
1282
1283 -- addition ends for bug 16245506
1284
1285 /*LPN Status Project*/
1286
1287 FUNCTION GET_PROJECT_ATTRIBUTE(
1288 P_ATTRIBUTE_TYPE IN VARCHAR2 DEFAULT g_miss_char,
1289 P_INVENTORY_ORGANIZATION_ID IN NUMBER DEFAULT g_miss_num,
1290 P_PROJECT_ID IN NUMBER DEFAULT g_miss_num)
1291 RETURN VARCHAR2;
1292
1293 END wms_parameter_pvt;