1 PACKAGE inv_loc_wms_pub AUTHID CURRENT_USER AS
2 /* $Header: INVLOCPS.pls 120.2.12000000.1 2007/01/17 16:19:55 appldev ship $*/
3 /*#
4 * The Locator Maintenance procedures allow users to create, update and delete
5 * stock locators in an inventory organization. Users can also use these procedures
6 * to assign an item to a locator as required.
7 * @rep:scope public
8 * @rep:product INV
9 * @rep:lifecycle active
10 * @rep:displayname Locator Maintenance API
11 * @rep:category BUSINESS_ENTITY INV_ORGANIZATION_SETUP
12 */
13
14 /*
15 ** ---------------------------------------------------------------------------
16 ** procedure : create_locator
17 ** description : this procedure creates a new locator in a given organization
18 **
19 ** i/p :
20 ** p_organization_id
21 ** identifier of organization in which locator is to
22 ** be created.
23 ** p_organization_code
24 ** organization code of organziation in which locator
25 ** is to be created. Either p_organization_id or
26 ** p_organziation_code MUST be passed
27 ** p_concatenated_segments
28 ** concatenated segment string with separator
29 ** of the locator to be created. Eg:A.1.1
30 ** p_description
31 ** locator description
32 ** p_inventory_location_type
33 ** type of locator.
34 ** dock door(1) or staging lane(2) or storage locator(3)
35 ** p_picking_order
36 ** number that identifies relative position of locator
37 ** for travel optimization during picking and task dispatching.
38 ** It has a a higher precedence over x,y,z coordinates.
39 ** p_location_maximum_units
40 ** Maxmimum units the locator can hold
41 ** p_subinventory_code
42 ** Subinventory to which locator belongs
43 ** p_location_weight_uom_code
44 ** UOM of locator's max weight capacity
45 ** p_max_weight
46 ** Max weight locator can hold
47 ** p_volume_uom_code
48 ** UOM of locator's max volume capacity
49 ** p_max_cubic_area
50 ** Max volume capacity of the locator
51 ** p_x_coordinate
52 ** X-position of the locator in space. Used
53 ** for travel optimization during picking and task dispatching.
54 ** p_y_coordinate
55 ** Y-position of the locator in space. Used
56 ** for travel optimization during picking and task dispatching.
57 ** p_z_coordinate
58 ** Z-position of the locator in space. Used
59 ** for travel optimization during picking and task dispatching.
60 ** p_physical_location_id
61 ** locators that are the same physically have the same
62 ** inventory_location_id in this column
63 ** p_pick_uom_code
64 ** UOM in which material is picked from locator
65 ** p_dimension_uom_code
66 ** UOM in which locator dimensions are expressed
67 ** p_length
68 ** Length of the locator
69 ** p_width
70 ** Width of the locator
71 ** p_height
72 ** Height of the locator
73 ** p_status_id
74 ** Material Status that needs to be associated to locator
75 ** p_dropping_order
76 ** For ordering drop-off locators and also to order by putaway
77 ** drop-off operations (bug 2681871)
78 **
79 ** o/p:
80 ** x_return_status
81 ** return status indicating success, error, unexpected error
82 ** x_msg_count
83 ** number of messages in message list
84 ** x_msg_data
85 ** if the number of messages in message list is 1, contains
86 ** message text
87 ** x_inventory_location_id
88 ** identifier of newly created locator or existing locator
89 ** x_locator_exists
90 ** Y - locator exists for given input
91 ** N - locator created for given input
92 **
93 ** ---------------------------------------------------------------------------
94 */
95 /*#
96 * Use this procedure to create a new locator in an organization.
97 * For given organization and the concatenated locator segments provided, this
98 * procedure creates a
99 * new locator in the organization and returns the locator identifier. If a
100 * locator already exists with the same concatenated segments, the procedure
101 * returns the locator identifier.
102 * @param x_return_status Return status indicating success or failure
103 * @paraminfo {@rep:required}
104 * @param x_msg_count Returns the number of messages in message list
105 * @paraminfo {@rep:required}
106 * @param x_msg_data Returns the message text if the number of messages in message list is one
107 * @paraminfo {@rep:required}
108 * @param x_inventory_location_id Identifier of newly created locator or existing locator
109 * @paraminfo {@rep:required}
110 * @param x_locator_exists Returns 'Y' if the locator exists for the given input and 'N' if a new locator is created for given input
111 * @paraminfo {@rep:required}
112 * @param p_organization_id Organization Id in which locator is to be created, is passed as input in this variable
113 * @paraminfo {@rep:required}
114 * @param p_organization_code Organization code in which locator is to be created, is passed as input in this variable
115 * @paraminfo {@rep:required}
116 * @param p_concatenated_segments Concatenated segment string (with separator) of the locator to be created is passed as input in this variable
117 * @paraminfo {@rep:required}
118 * @param p_description Locator description is passed as input in this variable
119 * @paraminfo {@rep:required}
120 * @param p_inventory_location_type Type of locator is passed as input in this variable
121 * @paraminfo {@rep:required}
122 * @param p_picking_order Number that identifies relative position of locator for travel optimization during task dipatching is passed as input in this variable
123 * @paraminfo {@rep:required}
124 * @param p_location_maximum_units Maximum units the locator can hold is passed as input in this variable
125 * @paraminfo {@rep:required}
126 * @param p_subinventory_code Sub inventory to which locator belongs is passed as input in this variable
127 * @paraminfo {@rep:required}
128 * @param p_location_weight_uom_code UOM of locator's maximum weight capacity is passed as input in this variable
129 * @paraminfo {@rep:required}
130 * @param p_max_weight Maximum weight the locator can hold is passed as input in this variable
131 * @paraminfo {@rep:required}
132 * @param p_volume_uom_code UOM of locator's max volume capacity is passed as input in this variable
133 * @paraminfo {@rep:required}
134 * @param p_max_cubic_area Max volume capacity of the locator is passed as input in this variable
135 * @paraminfo {@rep:required}
136 * @param p_x_coordinate X-position of the locator in space is passed as input in this variable
137 * @paraminfo {@rep:required}
138 * @param p_y_coordinate Y-position of the locator in space is passed as input in this variable
139 * @paraminfo {@rep:required}
140 * @param p_z_coordinate Z-position of the locator in space is passed as input in this variable
141 * @paraminfo {@rep:required}
142 * @param p_physical_location_id Locators that are the same physically have the same inventory_location_id passed as input in this variable
143 * @paraminfo {@rep:required}
144 * @param p_pick_uom_code UOM in which material is picked from locator is passed as input in this variable
145 * @paraminfo {@rep:required}
146 * @param p_dimension_uom_code UOM in which locator dimensions are expressed is passed as input in this variable
147 * @paraminfo {@rep:required}
148 * @param p_length Length of the locator is passed as input in this variable
149 * @paraminfo {@rep:required}
150 * @param p_width Width of the locator is passed as input in this variable
151 * @paraminfo {@rep:required}
152 * @param p_height Height of the locator is passed as input in this variable
153 * @paraminfo {@rep:required}
154 * @param p_status_id Material Status that needs to be associated to locator is passed as input in this variable
155 * @paraminfo {@rep:required}
156 * @param p_dropping_order Number that identifies relative position of locator for consolidation and put away drop-off operations is passed as input in this variable
157 * @paraminfo {@rep:required}
158 * @param p_attribute_category Holds the Context of the Descriptive FlexField for the Locator
159 * @paraminfo {@rep:Not Mandatory}
160 * @param p_attribute1 Holds the Descriptive FlexField attribute for the Locator
161 * @paraminfo {@rep:Not Mandatory}
162 * @param p_attribute2 Holds the Descriptive FlexField attribute for the Locator
163 * @paraminfo {@rep:Not Mandatory}
164 * @param p_attribute3 Holds the Descriptive FlexField attribute for the Locator
165 * @paraminfo {@rep:Not Mandatory}
166 * @param p_attribute4 Holds the Descriptive FlexField attribute for the Locator
167 * @paraminfo {@rep:Not Mandatory}
168 * @param p_attribute5 Holds the Descriptive FlexField attribute for the Locator
169 * @paraminfo {@rep:Not Mandatory}
170 * @param p_attribute6 Holds the Descriptive FlexField attribute for the Locator
171 * @paraminfo {@rep:Not Mandatory}
172 * @param p_attribute7 Holds the Descriptive FlexField attribute for the Locator
173 * @paraminfo {@rep:Not Mandatory}
174 * @param p_attribute8 Holds the Descriptive FlexField attribute for the Locator
175 * @paraminfo {@rep:Not Mandatory}
176 * @param p_attribute9 Holds the Descriptive FlexField attribute for the Locator
177 * @paraminfo {@rep:Not Mandatory}
178 * @param p_attribute10 Holds the Descriptive FlexField attribute for the Locator
179 * @paraminfo {@rep:Not Mandatory}
180 * @param p_attribute11 Holds the Descriptive FlexField attribute for the Locator
181 * @paraminfo {@rep:Not Mandatory}
182 * @param p_attribute12 Holds the Descriptive FlexField attribute for the Locator
183 * @paraminfo {@rep:Not Mandatory}
184 * @param p_attribute13 Holds the Descriptive FlexField attribute for the Locator
185 * @paraminfo {@rep:Not Mandatory}
186 * @param p_attribute14 Holds the Descriptive FlexField attribute for the Locator
187 * @paraminfo {@rep:Not Mandatory}
188 * @param p_attribute15 Holds the Descriptive FlexField attribute for the Locator
189 * @paraminfo {@rep:Not Mandatory}
190 * @rep:scope public
191 * @rep:lifecycle active
192 * @rep:displayname Create Locator
193 */
194 PROCEDURE CREATE_LOCATOR (x_return_status OUT NOCOPY VARCHAR2,
195 x_msg_count OUT NOCOPY NUMBER,
196 x_msg_data OUT NOCOPY VARCHAR2,
197 x_inventory_location_id OUT NOCOPY NUMBER,
198 x_locator_exists OUT NOCOPY VARCHAR2,
199 p_organization_id IN NUMBER ,
200 p_organization_code IN VARCHAR2,
201 p_concatenated_segments IN VARCHAR2,
202 p_description IN VARCHAR2,
203 p_inventory_location_type IN NUMBER ,
204 p_picking_order IN NUMBER ,
205 p_location_maximum_units IN NUMBER ,
206 p_SUBINVENTORY_CODE IN VARCHAR2,
207 p_LOCATION_WEIGHT_UOM_CODE IN VARCHAR2,
208 p_mAX_WEIGHT IN NUMBER,
209 p_vOLUME_UOM_CODE IN VARCHAR2,
210 p_mAX_CUBIC_AREA IN NUMBER,
211 p_x_COORDINATE IN NUMBER,
212 p_Y_COORDINATE IN NUMBER,
213 p_Z_COORDINATE IN NUMBER,
214 p_PHYSICAL_LOCATION_ID IN NUMBER,
215 p_PICK_UOM_CODE IN VARCHAR2,
216 p_DIMENSION_UOM_CODE IN VARCHAR2,
217 p_LENGTH IN NUMBER,
218 p_WIDTH IN NUMBER,
219 p_HEIGHT IN NUMBER,
220 p_STATUS_ID IN NUMBER,
221 p_dropping_order IN NUMBER,
222 p_attribute_category IN VARCHAR2 DEFAULT NULL,
223 p_attribute1 IN VARCHAR2 DEFAULT NULL
224 , p_attribute2 IN VARCHAR2 DEFAULT NULL
225 , p_attribute3 IN VARCHAR2 DEFAULT NULL
226 , p_attribute4 IN VARCHAR2 DEFAULT NULL
227 , p_attribute5 IN VARCHAR2 DEFAULT NULL
228 , p_attribute6 IN VARCHAR2 DEFAULT NULL
229 , p_attribute7 IN VARCHAR2 DEFAULT NULL
230 , p_attribute8 IN VARCHAR2 DEFAULT NULL
231 , p_attribute9 IN VARCHAR2 DEFAULT NULL
232 , p_attribute10 IN VARCHAR2 DEFAULT NULL
233 , p_attribute11 IN VARCHAR2 DEFAULT NULL
234 , p_attribute12 IN VARCHAR2 DEFAULT NULL
235 , p_attribute13 IN VARCHAR2 DEFAULT NULL
236 , p_attribute14 IN VARCHAR2 DEFAULT NULL
237 , p_attribute15 IN VARCHAR2 DEFAULT NULL
238 , p_alias IN VARCHAR2 DEFAULT NULL
239 ) ;
240
241 /*
242 ** ---------------------------------------------------------------------------
243 ** procedure : update_locator
244 ** description : this procedure updates an existing locator
245 **
246 ** i/p :
247 ** NOTE:
248 ** if the default value of the input parameter is used, then
249 ** that column retains its original value and is not changed
250 ** during update.
251 ** this can be achieved by not passing this parameter during the
252 ** API call.
253 **
254 ** p_organization_id
255 ** identifier of organization in which locator is to
256 ** be updated.
257 ** p_organization_code
258 ** organization code of organziation in which locator
259 ** is to be updated. Either p_organization_id or
260 ** p_organziation_code MUST be passed
261 ** p_inventory_location_id
262 ** identifier of locator to be updated
263 ** p_concatenated_segments
264 ** concatenated segment string with separator
265 ** of the locator to be updated. Eg:A.1.1
266 ** either p_inventory_location_id or p_concatenated_segments
267 ** MUST be passed.
268 ** p_description
269 ** locator description
270 ** p_inventory_location_type
271 ** type of locator.
272 ** dock door(1) or staging lane(2) or storage locator(3)
273 ** p_picking_order
274 ** number that identifies physical position of locator
275 ** for travel optimization during picking and task dispatching.
276 ** It has a a higher precedence over x,y,z coordinates.
277 ** p_location_maximum_units
278 ** Maxmimum units the locator can hold
279 ** p_subinventory_code
280 ** Subinventory to which locator belongs
281 ** p_location_weight_uom_code
282 ** UOM of locator's max weight capacity
283 ** p_max_weight
284 ** Max weight locator can hold
285 ** p_volume_uom_code
286 ** UOM of locator's max volume capacity
287 ** p_max_cubic_area
288 ** Max volume capacity of the locator
289 ** p_x_coordinate
290 ** X-position of the locator in space. Used
291 ** for travel optimization during picking and task dispatching.
292 ** p_y_coordinate
293 ** Y-position of the locator in space. Used
294 ** for travel optimization during picking and task dispatching.
295 ** p_z_coordinate
296 ** Z-position of the locator in space. Used
297 ** for travel optimization during picking and task dispatching.
298 ** p_physical_location_id
299 ** locators that are the same physically have the same
300 ** inventory_location_id in this column
301 ** p_pick_uom_code
302 ** UOM in which material is picked from locator
303 ** p_dimension_uom_code
304 ** UOM in which locator dimensions are expressed
305 ** p_length
306 ** Length of the locator
307 ** p_width
308 ** Width of the locator
309 ** p_height
310 ** Height of the locator
311 ** p_status_id
312 ** Material Status that needs to be associated to locator
313 ** p_dropping_order
314 ** For ordering drop-off locators and also to order by putaway
315 ** drop-off operations (bug 2681871)
316 **
317 ** o/p:
318 ** x_return_status
319 ** return status indicating success, error, unexpected error
320 ** x_msg_count
321 ** number of messages in message list
322 ** x_msg_data
323 ** if the number of messages in message list is 1, contains
324 ** message text
325 **
326 ** ---------------------------------------------------------------------------
327 */
328 /*#
329 * Use this procedure to update an existing locator in an organization.
330 * This procedure updates an existing locator with the information provided as input
331 * parameters. If the default value is passed, the corresponding locator column will
332 * retain its original value.
333 * @param x_return_status Return status indicating success or failure
334 * @paraminfo {@rep:required}
335 * @param x_msg_count Returns the number of messages in message list
336 * @paraminfo {@rep:required}
340 * @paraminfo {@rep:required}
337 * @param x_msg_data Returns the message text if the number of messages in message list is one
338 * @paraminfo {@rep:required}
339 * @param p_organization_id Organization Id in which locator exists, is passed as input in this variable
341 * @param p_organization_code Organization code in which locator exists, is passed as input in this variable
342 * @paraminfo {@rep:required}
343 * @param p_inventory_location_id Identifier of locator to be updated is passed as input in this variable
344 * @paraminfo {@rep:required}
345 * @param p_concatenated_segments Concatenated segment string (with separator) of the locator to be updated is passed as input in this variable
346 * @paraminfo {@rep:required}
347 * @param p_description Locator description is passed as input in this variable
348 * @param p_disabled_date Date on which the locator would be disabled is paused as input in this variable
349 * @param p_inventory_location_type Type of locator is passed as input in this variable
350 * @param p_picking_order Number that identifies relative position of locator for travel optimization during task dipatching is passed as input in this variable
351 * @param p_location_maximum_units Maximum units the locator can hold is passed as input in this variable
352 * @param p_location_weight_uom_code UOM of locator's maximum weight capacity is passed as input in this variable
353 * @param p_max_weight Maximum weight the locator can hold is passed as input in this variable
354 * @param p_volume_uom_code UOM of locator's max volume capacity is passed as input in this variable
355 * @param p_max_cubic_area Max volume capacity of the locator is passed as input in this variable
356 * @param p_x_coordinate X-position of the locator in space is passed as input in this variable
357 * @param p_y_coordinate Y-position of the locator in space is passed as input in this variable
358 * @param p_z_coordinate Z-position of the locator in space is passed as input in this variable
359 * @param p_physical_location_id Locators that are the same physically have the same inventory_location_id passed as input in this variable
360 * @param p_pick_uom_code UOM in which material is picked from locator is passed as input in this variable
361 * @param p_dimension_uom_code UOM in which locator dimensions are expressed is passed as input in this variable
362 * @param p_length Length of the locator is passed as input in this variable
363 * @param p_width Width of the locator is passed as input in this variable
364 * @param p_height Height of the locator is passed as input in this variable
365 * @param p_status_id Material Status that needs to be associated to locator is passed as input in this variable
366 * @param p_dropping_order Number that identifies relative position of locator for consolidation and put away drop-off operations is passed as input in this variable* @rep:scope public
367 ** For the DFF attributes mentioned below, to update correctly use the following strategy
368 ** To retain the value in the table, do not pass any value OR pass NULL as i/p
369 ** To update the attribute with NULL, pass fnd_api.g_miss_char
370 ** To update with any other value, pass the appropriate value
371 * @param p_attribute_category Holds the Context of the Descriptive FlexField for the Locator
372 * @paraminfo {@rep:Not Mandatory}
373 * @param p_attribute1 Holds the Descriptive FlexField attribute for the Locator
374 * @paraminfo {@rep:Not Mandatory}
375 * @param p_attribute2 Holds the Descriptive FlexField attribute for the Locator
376 * @paraminfo {@rep:Not Mandatory}
377 * @param p_attribute3 Holds the Descriptive FlexField attribute for the Locator
378 * @paraminfo {@rep:Not Mandatory}
379 * @param p_attribute4 Holds the Descriptive FlexField attribute for the Locator
380 * @paraminfo {@rep:Not Mandatory}
381 * @param p_attribute5 Holds the Descriptive FlexField attribute for the Locator
382 * @paraminfo {@rep:Not Mandatory}
383 * @param p_attribute6 Holds the Descriptive FlexField attribute for the Locator
384 * @paraminfo {@rep:Not Mandatory}
385 * @param p_attribute7 Holds the Descriptive FlexField attribute for the Locator
386 * @paraminfo {@rep:Not Mandatory}
387 * @param p_attribute8 Holds the Descriptive FlexField attribute for the Locator
388 * @paraminfo {@rep:Not Mandatory}
389 * @param p_attribute9 Holds the Descriptive FlexField attribute for the Locator
390 * @paraminfo {@rep:Not Mandatory}
391 * @param p_attribute10 Holds the Descriptive FlexField attribute for the Locator
392 * @paraminfo {@rep:Not Mandatory}
393 * @param p_attribute11 Holds the Descriptive FlexField attribute for the Locator
394 * @paraminfo {@rep:Not Mandatory}
395 * @param p_attribute12 Holds the Descriptive FlexField attribute for the Locator
396 * @paraminfo {@rep:Not Mandatory}
397 * @param p_attribute13 Holds the Descriptive FlexField attribute for the Locator
398 * @paraminfo {@rep:Not Mandatory}
399 * @param p_attribute14 Holds the Descriptive FlexField attribute for the Locator
400 * @paraminfo {@rep:Not Mandatory}
401 * @param p_attribute15 Holds the Descriptive FlexField attribute for the Locator
402 * @paraminfo {@rep:Not Mandatory}
403 * @rep:scope public
404 * @rep:lifecycle active
405 * @rep:displayname Update Locator
406 */
407 PROCEDURE UPDATE_LOCATOR (x_return_status OUT NOCOPY VARCHAR2,
408 x_msg_count OUT NOCOPY NUMBER,
409 x_msg_data OUT NOCOPY VARCHAR2,
410 p_organization_id IN NUMBER ,
411 p_organization_code IN VARCHAR2,
412 p_inventory_location_id IN NUMBER,
413 p_concatenated_segments IN VARCHAR2,
414 p_description IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
418 p_location_maximum_units IN NUMBER DEFAULT FND_API.G_MISS_NUM,
415 p_disabled_date IN DATE DEFAULT FND_API.G_MISS_DATE,
416 p_inventory_location_type IN NUMBER DEFAULT FND_API.G_MISS_NUM,
417 p_picking_order IN NUMBER DEFAULT FND_API.G_MISS_NUM,
419 p_location_Weight_uom_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
420 p_max_weight IN NUMBER DEFAULT FND_API.G_MISS_NUM,
421 p_volume_uom_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
422 p_max_cubic_area IN NUMBER DEFAULT FND_API.G_MISS_NUM,
423 p_x_coordinate IN NUMBER DEFAULT FND_API.G_MISS_NUM,
424 p_y_coordinate IN NUMBER DEFAULT FND_API.G_MISS_NUM,
425 p_z_coordinate IN NUMBER DEFAULT FND_API.G_MISS_NUM,
426 p_physical_location_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
427 p_pick_uom_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
428 p_dimension_uom_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
429 p_length IN NUMBER DEFAULT FND_API.G_MISS_NUM,
430 p_width IN NUMBER DEFAULT FND_API.G_MISS_NUM,
431 p_height IN NUMBER DEFAULT FND_API.G_MISS_NUM,
432 p_status_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
433 p_dropping_order IN NUMBER DEFAULT FND_API.G_MISS_NUM,
434 p_attribute_category IN VARCHAR2 DEFAULT NULL,
435 p_attribute1 IN VARCHAR2 DEFAULT NULL
436 , p_attribute2 IN VARCHAR2 DEFAULT NULL
437 , p_attribute3 IN VARCHAR2 DEFAULT NULL
438 , p_attribute4 IN VARCHAR2 DEFAULT NULL
439 , p_attribute5 IN VARCHAR2 DEFAULT NULL
440 , p_attribute6 IN VARCHAR2 DEFAULT NULL
441 , p_attribute7 IN VARCHAR2 DEFAULT NULL
442 , p_attribute8 IN VARCHAR2 DEFAULT NULL
443 , p_attribute9 IN VARCHAR2 DEFAULT NULL
444 , p_attribute10 IN VARCHAR2 DEFAULT NULL
445 , p_attribute11 IN VARCHAR2 DEFAULT NULL
446 , p_attribute12 IN VARCHAR2 DEFAULT NULL
447 , p_attribute13 IN VARCHAR2 DEFAULT NULL
448 , p_attribute14 IN VARCHAR2 DEFAULT NULL
449 , p_attribute15 IN VARCHAR2 DEFAULT NULL
450 , p_alias IN VARCHAR2 DEFAULT NULL
451 );
452 /*
453 ** ---------------------------------------------------------------------------
454 ** procedure : create_loc_item_tie
455 ** description : For a given set of organization, subinventory, item and
456 ** locator, this API ties the given item to the given locator.
457 ** i/p :
458
459 ** p_inventory_item_id
460 ** Identifier of item .
461 ** p_item
462 ** Concatenated segment string with separator of the item.
463 ** Either P_inventory_item_id or the p_item MUST be passed
464 ** p_organization_id
465 ** Identifier of organization
466 ** p_organization_code
467 ** Organization code of organziation in which locator is to
468 ** be updated. Either p_organization_id or p_organziation_code
469 ** MUST be passed
470 ** p_subinventory_code
471 ** The subinventory to which the locator need to be attached to .
472 ** p_inventory_location_id
473 ** Identifier of locator to be attached to the specified subinventory
474 ** p_locator
475 ** Concatenated segment string with separator of the locator to be
476 ** updated. Eg:A.1.1 either p_inventory_location_id or
477 ** p_concatenated_segments MUST be passed.
478 ** p_status_id
479 ** Identifier of status
480 ** p_par_level Indicates the the maximum quantity
481 **
482 ** o/p:
483 **
484 ** x_return_status
485 ** return status indicating success, error, unexpected error
486 ** x_msg_count
487 ** number of messages in message list
488 ** x_msg_data
489 ** if the number of messages in message list is 1, contains
490 ** message text
491 **
492 ** ---------------------------------------------------------------------------
493 */
494 /*#
495 * Use this procedure to assign an item to a locator in an organization.
496 * For a given organization, subinventory, item and locator, this procedure ties
497 * the item to the locator.
498 * @param x_return_status Return status indicating success or failure
499 * @paraminfo {@rep:required}
500 * @param x_msg_count Returns the number of messages in message list
501 * @paraminfo {@rep:required}
502 * @param x_msg_data Returns the message text if the number of messages in message list is one
503 * @paraminfo {@rep:required}
504 * @param p_inventory_item_id Identifier of the item that is to be tied to a locator is passed as input in this variable
505 * @paraminfo {@rep:required}
506 * @param p_item Concatenated segment string (with separator) of the item to be tied to a locator is passed as input in this variable
507 * @paraminfo {@rep:required}
508 * @param p_organization_id Organization Id in which the item and locator exist, is passed as input in this variable
509 * @paraminfo {@rep:required}
510 * @param p_organization_code Organization code in which the item and locator exist, is passed as input in this variable
511 * @paraminfo {@rep:required}
515 * @paraminfo {@rep:required}
512 * @param p_subinventory_code Sub inventory to which locator belongs is passed as input in this variable
513 * @paraminfo {@rep:required}
514 * @param p_inventory_location_id Identifier of locator to be attached to the specified item is passed as input in this variable
516 * @param p_locator Concatenated segment string (with separator) of the locator is passed as input in this variable
517 * @paraminfo {@rep:required}
518 * @param p_status_id Material Status of the locator is passed as input in this variable
519 * @paraminfo {@rep:required}
520 * @param p_par_level PAR level for the Item-Locator is passed as input in this variable
521 * @rep:scope public
522 * @rep:lifecycle active
523 * @rep:displayname Create Item-Locator Tie
524 */
525 PROCEDURE CREATE_LOC_ITEM_TIE( x_return_status OUT NOCOPY VARCHAR2,
526 x_msg_count OUT NOCOPY NUMBER,
527 x_msg_data OUT NOCOPY VARCHAR2,
528 p_inventory_item_id IN NUMBER,
529 p_item IN VARCHAR2,
530 p_organization_id IN NUMBER,
531 p_organization_code IN VARCHAR2,
532 p_subinventory_code IN VARCHAR2,
533 p_inventory_location_id IN NUMBER,
534 p_locator IN VARCHAR2,
535 p_status_id IN NUMBER,
536 p_par_level IN NUMBER DEFAULT NULL
537 );
538 /*
539 **-----------------------------------------------------------------------------------
540 **
541 ** procedure : delete_locator
542 ** description : this procedure deletes a locator in a given organization.
543 ** i/p :
544 ** p_inventory_location_id
545 ** identifier of locator to be deleted
546 ** p_concatenated_segments
547 ** concatenated segment string with separator of the locator to be deleted. Eg:A.1.1
548 ** p_organization_id
549 ** identifier of organization in which locator is to be deleted.
550 ** p_organization_code
551 ** organization code of organziation in which locator is to be deleted.
552 ** Either p_organization_id or p_organziation_code MUST be passed
553
554 ** p_validation_req_flag
555 ** the flag which determines whether validation is required or not.
556 ** If it is 'N',the locator is deleted without any further validation
557 ** on its existence in other tables.If it is'Y', the locator is deleted
558 ** only if doesnot exist in other tables.
559 **
560 ** o/p
561 ** x_return_status
562 ** return status indicating success, error, unexpected error
563 ** x_msg_count
564 ** number of messages in message list
565 ** x_msg_data :
566 ** if the number of messages in message list is 1,
567 ** contains message text x_inventory_location_id
568 **
569 **-----------------------------------------------------------------------------------
570 */
571 /*#
572 * Use this procedure to delete an existing locator in an organization.
573 * For a given organization and locator, this procedure deletes the existing locator after ensuring that
574 * the locator is obsolete and does not exist in any core Inventory tables (i.e.
575 * it has no on hand balances or pending material transactions).
576 * @param x_return_status Return status indicating success or failure
577 * @paraminfo {@rep:required}
578 * @param x_msg_count Returns the number of messages in message list
579 * @paraminfo {@rep:required}
580 * @param x_msg_data Returns the message text if the number of messages in message list is one
581 * @paraminfo {@rep:required}
582 * @param p_inventory_location_id Identifier of locator to be deleted is passed as input in this variable
583 * @paraminfo {@rep:required}
587 * @paraminfo {@rep:required}
584 * @param p_concatenated_segments Concatenated segment string (with separator) of the locator to be deleted is passed as input in this variable
585 * @paraminfo {@rep:required}
586 * @param p_organization_id Organization Id in which the locator exists, is passed as input in this variable
588 * @param p_organization_code Organization code in which the locator exists, is passed as input in this variable
589 * @paraminfo {@rep:required}
590 * @param p_validation_req_flag The flag that determines whether validation is required or not is passed as input in this variable
591 * @rep:scope public
592 * @rep:lifecycle active
593 * @rep:displayname Delete Locator
594 */
595 PROCEDURE DELETE_LOCATOR
596 ( x_return_status OUT NOCOPY VARCHAR2,
597 x_msg_count OUT NOCOPY NUMBER,
601 p_organization_id IN NUMBER,
598 x_msg_data OUT NOCOPY VARCHAR2,
599 p_inventory_location_id IN NUMBER,
600 p_concatenated_segments IN VARCHAR2,
602 p_organization_code IN VARCHAR2,
603 p_validation_req_flag IN VARCHAR2 DEFAULT 'Y'
604 );
605 END inv_loc_wms_pub;
606