1 PACKAGE inv_mwb_tree AS
2 /* $Header: INVMWBTS.pls 120.0 2005/05/25 06:59:52 appldev noship $ */
3
4 PROCEDURE add_orgs(
5 p_organization_id IN NUMBER DEFAULT NULL
6 , p_subinventory_code IN VARCHAR2 DEFAULT NULL
7 , p_locator_id IN NUMBER DEFAULT NULL
8 , p_inventory_item_id IN NUMBER DEFAULT NULL
9 , p_revision IN VARCHAR2 DEFAULT NULL
10 , p_lot_number_from IN VARCHAR2 DEFAULT NULL
11 , p_lot_number_to IN VARCHAR2 DEFAULT NULL
12 , p_lot_controlled IN NUMBER DEFAULT 0
13 , p_serial_number_from IN VARCHAR2 DEFAULT NULL
14 , p_serial_number_to IN VARCHAR2 DEFAULT NULL
15 , p_serial_controlled IN NUMBER DEFAULT 0
16 , p_lpn_from IN VARCHAR2 DEFAULT NULL
17 , p_lpn_to IN VARCHAR2 DEFAULT NULL
18 , p_containerized IN NUMBER DEFAULT 0
19 , p_prepacked IN NUMBER DEFAULT NULL
20 , p_cost_group_id IN NUMBER DEFAULT NULL
21 , p_status_id IN NUMBER DEFAULT NULL
22 , p_lot_attr_query IN VARCHAR2 DEFAULT NULL
23 , p_mln_context_code IN VARCHAR2 DEFAULT NULL
24 , p_project_id IN NUMBER DEFAULT NULL
25 , p_task_id IN NUMBER DEFAULT NULL
26 , p_unit_number IN VARCHAR2 DEFAULT NULL
27 , -- consinged changes
28 p_owning_qry_mode IN NUMBER DEFAULT NULL
29 , p_planning_query_mode IN NUMBER DEFAULT NULL
30 , p_owning_org IN NUMBER DEFAULT NULL
31 , p_planning_org IN NUMBER DEFAULT NULL
32 , -- consigned changes
33 p_serial_attr_query IN VARCHAR2 DEFAULT NULL
34 , p_node_state IN NUMBER
35 , p_node_high_value IN NUMBER
36 , p_node_low_value IN NUMBER
37 , p_sub_type IN NUMBER DEFAULT NULL --RCVLOCATORSSUPPORT
38 --ER(3338592) Changes
39 , p_item_description IN VARCHAR2 DEFAULT NULL
40 , p_qty_from IN NUMBER DEFAULT NULL
41 , p_qty_to IN NUMBER DEFAULT NULL
42 , p_detailed IN NUMBER DEFAULT 0 -- Bug #3412002
43 --End of ER Changes
44 , p_view_by IN VARCHAR2 DEFAULT NULL -- Bug #3411938
45 , p_responsibility_id IN NUMBER DEFAULT NULL
46 , p_resp_application_id IN NUMBER DEFAULT NULL
47 , x_node_value IN OUT NOCOPY NUMBER
48 , x_node_tbl IN OUT NOCOPY fnd_apptree.node_tbl_type
49 , x_tbl_index IN OUT NOCOPY NUMBER
50 -- NSRIVAST, INVCONV, Start
51 , p_grade_from IN VARCHAR2 DEFAULT NULL
52 , p_grade_code IN VARCHAR2 DEFAULT NULL
53 , p_grade_controlled IN NUMBER DEFAULT 0
54 -- NSRIVAST, INVCONV, End
55 );
56
57 PROCEDURE add_statuses(
58 p_organization_id IN NUMBER DEFAULT NULL
59 , p_subinventory_code IN VARCHAR2 DEFAULT NULL
60 , p_locator_id IN NUMBER DEFAULT NULL
61 , p_inventory_item_id IN NUMBER DEFAULT NULL
62 , p_revision IN VARCHAR2 DEFAULT NULL
63 , p_lot_number_from IN VARCHAR2 DEFAULT NULL
64 , p_lot_number_to IN VARCHAR2 DEFAULT NULL
65 , p_serial_number_from IN VARCHAR2 DEFAULT NULL
66 , p_serial_number_to IN VARCHAR2 DEFAULT NULL
67 , p_lpn_from IN VARCHAR2 DEFAULT NULL
68 , p_lpn_to IN VARCHAR2 DEFAULT NULL
69 , p_cost_group_id IN NUMBER DEFAULT NULL
70 , p_status_id IN NUMBER DEFAULT NULL
71 , p_lot_attr_query IN VARCHAR2 DEFAULT NULL
72 , p_mln_context_code IN VARCHAR2 DEFAULT NULL
73 , p_project_id IN NUMBER DEFAULT NULL
74 , p_task_id IN NUMBER DEFAULT NULL
75 , p_unit_number IN VARCHAR2 DEFAULT NULL
76 , -- consinged changes
77 p_owning_qry_mode IN NUMBER DEFAULT NULL
78 , p_planning_query_mode IN NUMBER DEFAULT NULL
79 , p_owning_org IN NUMBER DEFAULT NULL
80 , p_planning_org IN NUMBER DEFAULT NULL
81 , -- consigned changes
82 p_serial_attr_query IN VARCHAR2 DEFAULT NULL
83 , p_node_state IN NUMBER
84 , p_node_high_value IN NUMBER
85 , p_node_low_value IN NUMBER
86 --ER(3338592) Changes
87 , p_item_description IN VARCHAR2 DEFAULT NULL
88 , p_qty_from IN NUMBER DEFAULT NULL
89 , p_qty_to IN NUMBER DEFAULT NULL
90 --End of ER Changes
91 , p_responsibility_id IN NUMBER DEFAULT NULL -- Bug #3411938
92 , p_resp_application_id IN NUMBER DEFAULT NULL
93 , x_node_value IN OUT NOCOPY NUMBER
94 , x_node_tbl IN OUT NOCOPY fnd_apptree.node_tbl_type
95 , x_tbl_index IN OUT NOCOPY NUMBER
96 -- NSRIVAST, INVCONV, Start
97 , p_grade_from IN VARCHAR2 DEFAULT NULL
98 , p_grade_code IN VARCHAR2 DEFAULT NULL
99 , p_grade_controlled IN NUMBER DEFAULT 0
100 -- NSRIVAST, INVCONV, End
101 );
102
103 PROCEDURE add_subs(
104 p_organization_id IN NUMBER DEFAULT NULL
105 , p_subinventory_code IN VARCHAR2 DEFAULT NULL
106 , p_locator_id IN NUMBER DEFAULT NULL
107 , p_inventory_item_id IN NUMBER DEFAULT NULL
108 , p_revision IN VARCHAR2 DEFAULT NULL
109 , p_lot_number_from IN VARCHAR2 DEFAULT NULL
110 , p_lot_number_to IN VARCHAR2 DEFAULT NULL
111 , p_serial_number_from IN VARCHAR2 DEFAULT NULL
112 , p_serial_number_to IN VARCHAR2 DEFAULT NULL
113 , p_lpn_from IN VARCHAR2 DEFAULT NULL
114 , p_lpn_to IN VARCHAR2 DEFAULT NULL
115 , p_cost_group_id IN NUMBER DEFAULT NULL
116 , p_status_id IN NUMBER DEFAULT NULL
117 , p_lot_attr_query IN VARCHAR2 DEFAULT NULL
118 , p_mln_context_code IN VARCHAR2 DEFAULT NULL
119 , p_project_id IN NUMBER DEFAULT NULL
120 , p_task_id IN NUMBER DEFAULT NULL
121 , p_unit_number IN VARCHAR2 DEFAULT NULL
122 , -- consinged changes
123 p_owning_qry_mode IN NUMBER DEFAULT NULL
124 , p_planning_query_mode IN NUMBER DEFAULT NULL
125 , p_owning_org IN NUMBER DEFAULT NULL
126 , p_planning_org IN NUMBER DEFAULT NULL
127 , -- consigned changes
128 p_serial_attr_query IN VARCHAR2 DEFAULT NULL
129 , p_only_subinventory_status IN NUMBER DEFAULT 1
130 , p_node_state IN NUMBER
131 , p_node_high_value IN NUMBER
132 , p_node_low_value IN NUMBER
133 , p_sub_type IN NUMBER DEFAULT NULL --RCVLOCATORSSUPPORT
134 --ER(3338592) Changes
135 , p_item_description IN VARCHAR2 DEFAULT NULL
136 --End of ER Changes
137 , x_node_value IN OUT NOCOPY NUMBER
138 , x_node_tbl IN OUT NOCOPY fnd_apptree.node_tbl_type
139 , x_tbl_index IN OUT NOCOPY NUMBER
140 -- NSRIVAST, INVCONV, Start
141 , p_grade_from IN VARCHAR2 DEFAULT NULL
142 , p_grade_code IN VARCHAR2 DEFAULT NULL
143 , p_grade_controlled IN NUMBER DEFAULT 0
144 -- NSRIVAST, INVCONV, End
145 );
146
147 PROCEDURE add_locs(
148 p_organization_id IN NUMBER DEFAULT NULL
149 , p_subinventory_code IN VARCHAR2 DEFAULT NULL
150 , p_locator_id IN NUMBER DEFAULT NULL
151 , p_inventory_item_id IN NUMBER DEFAULT NULL
152 , p_revision IN VARCHAR2 DEFAULT NULL
153 , p_lot_number_from IN VARCHAR2 DEFAULT NULL
154 , p_lot_number_to IN VARCHAR2 DEFAULT NULL
155 , p_serial_number_from IN VARCHAR2 DEFAULT NULL
156 , p_serial_number_to IN VARCHAR2 DEFAULT NULL
157 , p_lpn_from IN VARCHAR2 DEFAULT NULL
158 , p_lpn_to IN VARCHAR2 DEFAULT NULL
159 , p_cost_group_id IN NUMBER DEFAULT NULL
160 , p_status_id IN NUMBER DEFAULT NULL
161 , p_lot_attr_query IN VARCHAR2 DEFAULT NULL
162 , p_mln_context_code IN VARCHAR2 DEFAULT NULL
163 , p_project_id IN NUMBER DEFAULT NULL
164 , p_task_id IN NUMBER DEFAULT NULL
165 , p_unit_number IN VARCHAR2 DEFAULT NULL
166 , -- consinged changes
167 p_owning_qry_mode IN NUMBER DEFAULT NULL
168 , p_planning_query_mode IN NUMBER DEFAULT NULL
169 , p_owning_org IN NUMBER DEFAULT NULL
170 , p_planning_org IN NUMBER DEFAULT NULL
171 , -- consigned changes
172 p_serial_attr_query IN VARCHAR2 DEFAULT NULL
173 , p_only_locator_status IN NUMBER DEFAULT 1
174 , p_node_state IN NUMBER
175 , p_node_high_value IN NUMBER
176 , p_node_low_value IN NUMBER
177 , p_sub_type IN NUMBER DEFAULT NULL --RCVLOCATORSSUPPORT
178 --ER(3338592) Changes
179 , p_item_description IN VARCHAR2 DEFAULT NULL
180 --End of ER Changes
181 , x_node_value IN OUT NOCOPY NUMBER
182 , x_node_tbl IN OUT NOCOPY fnd_apptree.node_tbl_type
183 , x_tbl_index IN OUT NOCOPY NUMBER
184 -- NSRIVAST, INVCONV, Start
185 , p_grade_from IN VARCHAR2 DEFAULT NULL
186 , p_grade_code IN VARCHAR2 DEFAULT NULL
187 , p_grade_controlled IN NUMBER DEFAULT 0
188 -- NSRIVAST, INVCONV, End
189 );
190
191 PROCEDURE add_cgs(
192 p_organization_id IN NUMBER DEFAULT NULL
193 , p_subinventory_code IN VARCHAR2 DEFAULT NULL
194 , p_locator_id IN NUMBER DEFAULT NULL
195 , p_inventory_item_id IN NUMBER DEFAULT NULL
196 , p_revision IN VARCHAR2 DEFAULT NULL
197 , p_lot_number_from IN VARCHAR2 DEFAULT NULL
198 , p_lot_number_to IN VARCHAR2 DEFAULT NULL
199 , p_serial_number_from IN VARCHAR2 DEFAULT NULL
200 , p_serial_number_to IN VARCHAR2 DEFAULT NULL
201 , p_lpn_from IN VARCHAR2 DEFAULT NULL
202 , p_lpn_to IN VARCHAR2 DEFAULT NULL
203 , p_cost_group_id IN NUMBER DEFAULT NULL
204 , p_status_id IN NUMBER DEFAULT NULL
205 , p_lot_attr_query IN VARCHAR2 DEFAULT NULL
206 , p_mln_context_code IN VARCHAR2 DEFAULT NULL
207 , p_project_id IN NUMBER DEFAULT NULL
208 , p_task_id IN NUMBER DEFAULT NULL
209 , p_unit_number IN VARCHAR2 DEFAULT NULL
210 , -- consinged changes
211 p_owning_qry_mode IN NUMBER DEFAULT NULL
212 , p_planning_query_mode IN NUMBER DEFAULT NULL
213 , p_owning_org IN NUMBER DEFAULT NULL
214 , p_planning_org IN NUMBER DEFAULT NULL
215 , -- consigned changes
216 p_serial_attr_query IN VARCHAR2 DEFAULT NULL
217 , p_node_state IN NUMBER
218 , p_node_high_value IN NUMBER
219 , p_node_low_value IN NUMBER
220 --ER(3338592) Changes
221 , p_item_description IN VARCHAR2 DEFAULT NULL
222 , p_qty_from IN NUMBER DEFAULT NULL
223 , p_qty_to IN NUMBER DEFAULT NULL
224 --End of ER Changes
225 , p_responsibility_id IN NUMBER DEFAULT NULL -- Bug #3411938
226 , p_resp_application_id IN NUMBER DEFAULT NULL
227 , x_node_value IN OUT NOCOPY NUMBER
228 , x_node_tbl IN OUT NOCOPY fnd_apptree.node_tbl_type
229 , x_tbl_index IN OUT NOCOPY NUMBER
230 -- NSRIVAST, INVCONV, Start
231 , p_grade_from IN VARCHAR2 DEFAULT NULL
232 , p_grade_code IN VARCHAR2 DEFAULT NULL
233 , p_grade_controlled IN NUMBER DEFAULT 0
234 -- NSRIVAST, INVCONV, End
235 );
236
237 PROCEDURE add_lpns(
238 p_organization_id IN NUMBER DEFAULT NULL
239 , p_subinventory_code IN VARCHAR2 DEFAULT NULL
240 , p_locator_id IN NUMBER DEFAULT NULL
241 , p_locator_controlled IN NUMBER DEFAULT 0
242 , p_inventory_item_id IN NUMBER DEFAULT NULL
243 , p_revision IN VARCHAR2 DEFAULT NULL
244 , p_lot_number_from IN VARCHAR2 DEFAULT NULL
245 , p_lot_number_to IN VARCHAR2 DEFAULT NULL
246 , p_serial_number_from IN VARCHAR2 DEFAULT NULL
247 , p_serial_number_to IN VARCHAR2 DEFAULT NULL
248 , p_lpn_from IN VARCHAR2 DEFAULT NULL
249 , p_lpn_to IN VARCHAR2 DEFAULT NULL
250 , p_parent_lpn_id IN VARCHAR2 DEFAULT NULL
251 , p_prepacked IN NUMBER DEFAULT NULL
252 , p_cost_group_id IN NUMBER DEFAULT NULL
253 , p_status_id IN NUMBER DEFAULT NULL
254 , p_lot_attr_query IN VARCHAR2 DEFAULT NULL
255 , p_mln_context_code IN VARCHAR2 DEFAULT NULL
256 , p_project_id IN NUMBER DEFAULT NULL
257 , p_task_id IN NUMBER DEFAULT NULL
258 , p_unit_number IN VARCHAR2 DEFAULT NULL
259 , -- consinged changes
260 p_owning_qry_mode IN NUMBER DEFAULT NULL
261 , p_planning_query_mode IN NUMBER DEFAULT NULL
262 , p_owning_org IN NUMBER DEFAULT NULL
263 , p_planning_org IN NUMBER DEFAULT NULL
264 , -- consigned changes
265 p_serial_attr_query IN VARCHAR2 DEFAULT NULL
266 , p_node_state IN NUMBER
267 , p_node_high_value IN NUMBER
268 , p_node_low_value IN NUMBER
269 , p_sub_type IN NUMBER DEFAULT NULL --RCVLOCATORSSUPPORT
270 , p_inserted_under_org IN VARCHAR2 DEFAULT 'N'
271 --ER(3338592) Changes
272 , p_item_description IN VARCHAR2 DEFAULT NULL
273 --End of ER Changes
274 , x_node_value IN OUT NOCOPY NUMBER
275 , x_node_tbl IN OUT NOCOPY fnd_apptree.node_tbl_type
276 , x_tbl_index IN OUT NOCOPY NUMBER
277 -- NSRIVAST, INVCONV, Start
278 , p_grade_from IN VARCHAR2 DEFAULT NULL
279 , p_grade_code IN VARCHAR2 DEFAULT NULL
280 , p_grade_controlled IN NUMBER DEFAULT 0
281 -- NSRIVAST, INVCONV, End
282 );
283
284 PROCEDURE add_items(
285 p_organization_id IN NUMBER DEFAULT NULL
286 , p_subinventory_code IN VARCHAR2 DEFAULT NULL
287 , p_locator_id IN NUMBER DEFAULT NULL
288 , p_locator_controlled IN NUMBER DEFAULT 0
289 , p_inventory_item_id IN NUMBER DEFAULT NULL
290 , p_revision IN VARCHAR2 DEFAULT NULL
291 , p_lot_number_from IN VARCHAR2 DEFAULT NULL
292 , p_lot_number_to IN VARCHAR2 DEFAULT NULL
293 , p_lot_number IN VARCHAR2 DEFAULT NULL
294 , p_serial_number_from IN VARCHAR2 DEFAULT NULL
295 , p_serial_number_to IN VARCHAR2 DEFAULT NULL
296 , p_serial_number IN VARCHAR2 DEFAULT NULL
297 , p_lpn_from IN VARCHAR2 DEFAULT NULL
298 , p_lpn_to IN VARCHAR2 DEFAULT NULL
299 , p_parent_lpn_id IN VARCHAR2 DEFAULT NULL
300 , p_containerized IN NUMBER DEFAULT 0
301 , p_prepacked IN NUMBER DEFAULT NULL
302 , p_cost_group_id IN NUMBER DEFAULT NULL
303 , p_status_id IN NUMBER DEFAULT NULL
304 , p_lot_attr_query IN VARCHAR2 DEFAULT NULL
305 , p_mln_context_code IN VARCHAR2 DEFAULT NULL
306 , p_project_id IN NUMBER DEFAULT NULL
307 , p_task_id IN NUMBER DEFAULT NULL
308 , p_unit_number IN VARCHAR2 DEFAULT NULL
309 , -- consinged changes
310 p_owning_qry_mode IN NUMBER DEFAULT NULL
311 , p_planning_query_mode IN NUMBER DEFAULT NULL
312 , p_owning_org IN NUMBER DEFAULT NULL
313 , p_planning_org IN NUMBER DEFAULT NULL
314 , -- consigned changes
315 p_serial_attr_query IN VARCHAR2 DEFAULT NULL
316 , p_node_state IN NUMBER
317 , p_node_high_value IN NUMBER
318 , p_node_low_value IN NUMBER
319 , p_sub_type IN NUMBER DEFAULT NULL --RCVLOCATORSSUPPORT
320 , p_inserted_under_org IN VARCHAR2 DEFAULT 'N'
321 --ER(3338592) Changes
322 , p_item_description IN VARCHAR2 DEFAULT NULL
323 --End of ER Changes
324 , p_responsibility_id IN NUMBER DEFAULT NULL -- Bug #3411938
325 , p_resp_application_id IN NUMBER DEFAULT NULL
326 , p_qty_from IN NUMBER DEFAULT NULL --Bug #3539766
327 , p_qty_to IN NUMBER DEFAULT NULL
328 , x_node_value IN OUT NOCOPY NUMBER
329 , x_node_tbl IN OUT NOCOPY fnd_apptree.node_tbl_type
330 , x_tbl_index IN OUT NOCOPY NUMBER
331 -- NSRIVAST, INVCONV, Start
332 , p_grade_from IN VARCHAR2 DEFAULT NULL
333 , p_grade_code IN VARCHAR2 DEFAULT NULL
334 , p_grade_controlled IN NUMBER DEFAULT 0
335 -- NSRIVAST, INVCONV, End
336 );
337
338 PROCEDURE add_revs(
339 p_organization_id IN NUMBER DEFAULT NULL
340 , p_subinventory_code IN VARCHAR2 DEFAULT NULL
341 , p_locator_id IN NUMBER DEFAULT NULL
342 , p_locator_controlled IN NUMBER DEFAULT 0
343 , p_inventory_item_id IN NUMBER DEFAULT NULL
344 , p_revision IN VARCHAR2 DEFAULT NULL
345 , p_lot_number_from IN VARCHAR2 DEFAULT NULL
346 , p_lot_number_to IN VARCHAR2 DEFAULT NULL
347 , p_lot_number IN VARCHAR2 DEFAULT NULL
348 , p_serial_number_from IN VARCHAR2 DEFAULT NULL
349 , p_serial_number_to IN VARCHAR2 DEFAULT NULL
350 , p_serial_number IN VARCHAR2 DEFAULT NULL
351 , p_lpn_from IN VARCHAR2 DEFAULT NULL
352 , p_lpn_to IN VARCHAR2 DEFAULT NULL
353 , p_parent_lpn_id IN VARCHAR2 DEFAULT NULL
354 , p_containerized IN NUMBER DEFAULT 0
355 , p_prepacked IN NUMBER DEFAULT NULL
356 , p_cost_group_id IN NUMBER DEFAULT NULL
357 , p_status_id IN NUMBER DEFAULT NULL
358 , p_lot_attr_query IN VARCHAR2 DEFAULT NULL
359 , p_mln_context_code IN VARCHAR2 DEFAULT NULL
360 , p_project_id IN NUMBER DEFAULT NULL
361 , p_task_id IN NUMBER DEFAULT NULL
362 , p_unit_number IN VARCHAR2 DEFAULT NULL
363 , -- consinged changes
364 p_owning_qry_mode IN NUMBER DEFAULT NULL
365 , p_planning_query_mode IN NUMBER DEFAULT NULL
366 , p_owning_org IN NUMBER DEFAULT NULL
367 , p_planning_org IN NUMBER DEFAULT NULL
368 , -- consigned changes
369 p_serial_attr_query IN VARCHAR2 DEFAULT NULL
370 , p_node_state IN NUMBER
371 , p_node_high_value IN NUMBER
372 , p_node_low_value IN NUMBER
373 , p_sub_type IN NUMBER DEFAULT NULL --RCVLOCATORSSUPPORT
374 --ER(3338592) Changes
375 , p_item_description IN VARCHAR2 DEFAULT NULL
376 --End of ER Changes
377 , x_node_value IN OUT NOCOPY NUMBER
378 , x_node_tbl IN OUT NOCOPY fnd_apptree.node_tbl_type
379 , x_tbl_index IN OUT NOCOPY NUMBER
380 -- NSRIVAST, INVCONV, Start
381 , p_grade_from IN VARCHAR2 DEFAULT NULL
382 , p_grade_code IN VARCHAR2 DEFAULT NULL
383 , p_grade_controlled IN NUMBER DEFAULT 0
384 -- NSRIVAST, INVCONV, End
385 );
386
387 PROCEDURE add_lots(
388 p_organization_id IN NUMBER DEFAULT NULL
389 , p_subinventory_code IN VARCHAR2 DEFAULT NULL
390 , p_locator_id IN NUMBER DEFAULT NULL
391 , p_locator_controlled IN NUMBER DEFAULT 0
392 , p_inventory_item_id IN NUMBER DEFAULT NULL
393 , p_revision IN VARCHAR2 DEFAULT NULL
394 , p_revision_controlled IN NUMBER DEFAULT 0
395 , p_lot_number_from IN VARCHAR2 DEFAULT NULL
396 , p_lot_number_to IN VARCHAR2 DEFAULT NULL
397 , p_serial_number_from IN VARCHAR2 DEFAULT NULL
398 , p_serial_number_to IN VARCHAR2 DEFAULT NULL
399 , p_serial_number IN VARCHAR2 DEFAULT NULL
400 , p_serial_controlled IN NUMBER DEFAULT 0
401 , p_lpn_from IN VARCHAR2 DEFAULT NULL
402 , p_lpn_to IN VARCHAR2 DEFAULT NULL
403 , p_parent_lpn_id IN VARCHAR2 DEFAULT NULL
404 , p_containerized IN NUMBER DEFAULT 0
405 , p_prepacked IN NUMBER DEFAULT NULL
406 , p_cost_group_id IN NUMBER DEFAULT NULL
407 , p_status_id IN NUMBER DEFAULT NULL
408 , p_lot_attr_query IN VARCHAR2 DEFAULT NULL
409 , p_mln_context_code IN VARCHAR2 DEFAULT NULL
410 , p_project_id IN NUMBER DEFAULT NULL
411 , p_task_id IN NUMBER DEFAULT NULL
412 , p_unit_number IN VARCHAR2 DEFAULT NULL
413 , -- consinged changes
414 p_owning_qry_mode IN NUMBER DEFAULT NULL
415 , p_planning_query_mode IN NUMBER DEFAULT NULL
416 , p_owning_org IN NUMBER DEFAULT NULL
417 , p_planning_org IN NUMBER DEFAULT NULL
418 , -- consigned changes
419 p_serial_attr_query IN VARCHAR2 DEFAULT NULL
420 , p_only_lot_status IN NUMBER DEFAULT 1
421 , p_node_state IN NUMBER
422 , p_node_high_value IN NUMBER
423 , p_node_low_value IN NUMBER
424 , p_sub_type IN NUMBER DEFAULT NULL --RCVLOCATORSSUPPORT
425 --ER(3338592) Changes
426 , p_item_description IN VARCHAR2 DEFAULT NULL
427 --End of ER Changes
428 , x_node_value IN OUT NOCOPY NUMBER
429 , x_node_tbl IN OUT NOCOPY fnd_apptree.node_tbl_type
430 , x_tbl_index IN OUT NOCOPY NUMBER
431 -- NSRIVAST, INVCONV, Start
432 , p_grade_from IN VARCHAR2 DEFAULT NULL
433 , p_grade_code IN VARCHAR2 DEFAULT NULL
434 , p_grade_controlled IN NUMBER DEFAULT 0
435 -- NSRIVAST, INVCONV, End
436 );
437
438 PROCEDURE add_serials(
439 p_organization_id IN NUMBER DEFAULT NULL
440 , p_subinventory_code IN VARCHAR2 DEFAULT NULL
441 , p_locator_id IN NUMBER DEFAULT NULL
442 , p_locator_controlled IN NUMBER DEFAULT 0
443 , p_inventory_item_id IN NUMBER DEFAULT NULL
444 , p_revision IN VARCHAR2 DEFAULT NULL
445 , p_revision_controlled IN NUMBER DEFAULT 0
446 , p_lot_number_from IN VARCHAR2 DEFAULT NULL
447 , p_lot_number_to IN VARCHAR2 DEFAULT NULL
448 , p_lot_number IN VARCHAR2 DEFAULT NULL
449 , p_lot_controlled IN NUMBER DEFAULT 0
450 , p_serial_number_from IN VARCHAR2 DEFAULT NULL
451 , p_serial_number_to IN VARCHAR2 DEFAULT NULL
452 , p_lpn_from IN VARCHAR2 DEFAULT NULL
453 , p_lpn_to IN VARCHAR2 DEFAULT NULL
454 , p_parent_lpn_id IN VARCHAR2 DEFAULT NULL
455 , p_containerized IN NUMBER DEFAULT 0
456 , p_prepacked IN NUMBER DEFAULT NULL
457 , p_cost_group_id IN NUMBER DEFAULT NULL
458 , p_status_id IN NUMBER DEFAULT NULL
459 , p_lot_attr_query IN VARCHAR2 DEFAULT NULL
460 , p_mln_context_code IN VARCHAR2 DEFAULT NULL
461 , p_project_id IN NUMBER DEFAULT NULL
462 , p_task_id IN NUMBER DEFAULT NULL
463 , p_unit_number IN VARCHAR2 DEFAULT NULL
464 , -- consinged changes
465 p_owning_qry_mode IN NUMBER DEFAULT NULL
466 , p_planning_query_mode IN NUMBER DEFAULT NULL
467 , p_owning_org IN NUMBER DEFAULT NULL
468 , p_planning_org IN NUMBER DEFAULT NULL
469 , -- consigned changes
470 p_serial_attr_query IN VARCHAR2 DEFAULT NULL
471 , p_only_serial_status IN NUMBER DEFAULT 1
472 , p_node_state IN NUMBER
473 , p_node_high_value IN NUMBER
474 , p_node_low_value IN NUMBER
475 , p_sub_type IN NUMBER DEFAULT NULL --RCVLOCATORSSUPPORT
476 --ER(3338592) Changes
477 , p_item_description IN VARCHAR2 DEFAULT NULL
478 --End of ER Changes
479 , x_node_value IN OUT NOCOPY NUMBER
480 , x_node_tbl IN OUT NOCOPY fnd_apptree.node_tbl_type
481 , x_tbl_index IN OUT NOCOPY NUMBER
482 -- NSRIVAST, INVCONV, Start
483 , p_grade_from IN VARCHAR2 DEFAULT NULL
484 , p_grade_code IN VARCHAR2 DEFAULT NULL
485 , p_grade_controlled IN NUMBER DEFAULT 0
486 -- NSRIVAST, INVCONV, End
487 );
488
489 -- NSRIVAST, INVCONV, Start
490 -- Procedure to give grade nodes for view by Grade
491 PROCEDURE add_grades
492 ( p_organization_id IN NUMBER DEFAULT NULL
493 , p_subinventory_code IN VARCHAR2 DEFAULT NULL
494 , p_locator_id IN NUMBER DEFAULT NULL
495 , p_locator_controlled IN NUMBER DEFAULT 0
496 , p_inventory_item_id IN NUMBER DEFAULT NULL
497 , p_revision IN VARCHAR2 DEFAULT NULL
498 , p_revision_controlled IN NUMBER DEFAULT 0
499 , p_lot_number_from IN VARCHAR2 DEFAULT NULL
500 , p_lot_number_to IN VARCHAR2 DEFAULT NULL
501 , p_serial_number_from IN VARCHAR2 DEFAULT NULL
502 , p_serial_number_to IN VARCHAR2 DEFAULT NULL
503 , p_serial_number IN VARCHAR2 DEFAULT NULL
504 , p_grade_from IN VARCHAR2 DEFAULT NULL
505 , p_grade_code IN VARCHAR2 DEFAULT NULL
506 , p_serial_controlled IN NUMBER DEFAULT 0
507 , p_lpn_from IN VARCHAR2 DEFAULT NULL
508 , p_lpn_to IN VARCHAR2 DEFAULT NULL
509 , p_parent_lpn_id IN VARCHAR2 DEFAULT NULL
510 , p_containerized IN NUMBER DEFAULT 0
511 , p_prepacked IN NUMBER DEFAULT 1
512 , p_cost_group_id IN NUMBER DEFAULT NULL
513 , p_status_id IN NUMBER DEFAULT NULL
514 , p_lot_attr_query IN VARCHAR2 DEFAULT NULL
515 , p_mln_context_code IN VARCHAR2 DEFAULT NULL
516 , p_project_id IN NUMBER DEFAULT NULL
517 , p_task_id IN NUMBER DEFAULT NULL
518 , p_unit_number IN VARCHAR2 DEFAULT NULL
519 -- consinged changes
520 , p_owning_qry_mode IN NUMBER DEFAULT NULL
521 , p_planning_query_mode IN NUMBER DEFAULT NULL
522 , p_owning_org IN NUMBER DEFAULT NULL
523 , p_planning_org IN NUMBER DEFAULT NULL
524 , p_only_lot_status IN NUMBER DEFAULT 1
525 -- consinged changes
526 , p_serial_attr_query IN VARCHAR2 DEFAULT NULL
527 , p_node_state IN NUMBER
528 , p_node_high_value IN NUMBER
529 , p_node_low_value IN NUMBER
530 , p_sub_type IN NUMBER DEFAULT NULL --RCVLOCATORSSUPPORT
531 , p_item_description IN VARCHAR2 DEFAULT NULL --ER(3338592) Changes
532 , p_qty_from IN NUMBER DEFAULT NULL
533 , p_qty_to IN NUMBER DEFAULT NULL
534 , p_responsibility_id IN NUMBER DEFAULT NULL
535 , p_resp_application_id IN NUMBER DEFAULT NULL
536 , x_node_value IN OUT NOCOPY NUMBER
537 , x_node_tbl IN OUT NOCOPY fnd_apptree.node_tbl_type
538 , x_tbl_index IN OUT NOCOPY NUMBER
539 );
540 -- NSRIVAST, INVCONV, End
541
542 -- Procedure to get the flexfield structure of mtl_lot_numbers flexfield.
543 -- This procedure appends the entries to a table that has
544 -- already been populated
545 PROCEDURE get_mln_attributes_structure(
546 x_attributes IN OUT NOCOPY inv_lot_sel_attr.lot_sel_attributes_tbl_type
547 , x_attributes_count OUT NOCOPY NUMBER
548 , x_return_status OUT NOCOPY VARCHAR2
549 , x_msg_count OUT NOCOPY NUMBER
550 , x_msg_data OUT NOCOPY NUMBER
551 , p_mln_context_code IN VARCHAR2);
552
553 -- Procedure to get the values populated in MTL_LOT_NUMBERS of the enabled segments
554 -- This procedure appends the entries to a table that has
555 -- already been populated
556 PROCEDURE get_mln_attributes(
557 x_attribute_values IN OUT NOCOPY inv_lot_sel_attr.lot_sel_attributes_tbl_type
558 , x_attribute_prompts IN OUT NOCOPY inv_lot_sel_attr.lot_sel_attributes_tbl_type
559 , x_attributes_count OUT NOCOPY NUMBER
560 , x_return_status OUT NOCOPY VARCHAR2
561 , x_msg_count OUT NOCOPY NUMBER
562 , x_msg_data OUT NOCOPY NUMBER
563 , p_organization_id IN NUMBER
564 , p_inventory_item_id IN NUMBER
565 , p_lot_number IN VARCHAR2);
566
567 PROCEDURE get_msn_attributes_structure(
568 x_attributes IN OUT NOCOPY inv_lot_sel_attr.lot_sel_attributes_tbl_type
569 , x_attributes_count OUT NOCOPY NUMBER
570 , x_return_status OUT NOCOPY VARCHAR2
571 , x_msg_count OUT NOCOPY NUMBER
572 , x_msg_data OUT NOCOPY NUMBER
573 , p_msn_context_code IN VARCHAR2);
574
575 PROCEDURE get_msn_attributes(
576 x_attribute_values IN OUT NOCOPY inv_lot_sel_attr.lot_sel_attributes_tbl_type
577 , x_attribute_prompts IN OUT NOCOPY inv_lot_sel_attr.lot_sel_attributes_tbl_type
578 , x_attributes_count OUT NOCOPY NUMBER
579 , x_return_status OUT NOCOPY VARCHAR2
580 , x_msg_count OUT NOCOPY NUMBER
581 , x_msg_data OUT NOCOPY NUMBER
582 , p_organization_id IN NUMBER
583 , p_inventory_item_id IN NUMBER
584 , p_serial_number IN VARCHAR2);
585 END inv_mwb_tree;