1 PACKAGE inv_reservation_form_pkg AUTHID CURRENT_USER AS
2 /* $Header: INVRSVFS.pls 120.6 2006/03/16 21:15:10 rambrose noship $ */
3 -- INVCONV Overloaded- Incorporate secondaries into parameter list
4 --R12- Project - SU : Added variables p_Serial_Number_Tbl and p_CrossDock_Flag
5 PROCEDURE create_reservation(
6 p_api_version_number IN NUMBER
7 , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_true
8 , x_return_status OUT NOCOPY VARCHAR2
9 , x_msg_count OUT NOCOPY NUMBER
10 , x_msg_data OUT NOCOPY VARCHAR2
11 , p_requirement_date IN DATE
12 , p_organization_id IN NUMBER
13 , p_inventory_item_id IN NUMBER
14 , p_demand_type_id IN NUMBER
15 , p_demand_name IN VARCHAR2
16 , p_demand_header_id IN NUMBER
17 , p_demand_line_id IN NUMBER
18 , p_demand_delivery_id IN NUMBER DEFAULT NULL
19 , p_primary_uom_code IN VARCHAR2
20 , p_primary_uom_id IN NUMBER
21 , p_secondary_uom_code IN VARCHAR2 DEFAULT NULL
22 , p_secondary_uom_id IN NUMBER DEFAULT NULL
23 , p_reservation_uom_code IN VARCHAR2
24 , p_reservation_uom_id IN NUMBER
25 , p_reservation_quantity IN NUMBER
26 , p_primary_rsv_quantity IN NUMBER
27 , p_secondary_rsv_quantity IN NUMBER DEFAULT NULL
28 , p_autodetail_group_id IN NUMBER
29 , p_external_source_code IN VARCHAR2
30 , p_external_source_line IN NUMBER
31 , p_supply_type_id IN NUMBER
32 , p_supply_header_id IN NUMBER
33 , p_supply_line_id IN NUMBER
34 , p_supply_name IN VARCHAR2
35 , p_supply_line_detail IN NUMBER
36 , p_revision IN VARCHAR2
37 , p_subinventory_code IN VARCHAR2
38 , p_subinventory_id IN NUMBER
39 , p_locator_id IN NUMBER
40 , p_lot_number IN VARCHAR2
41 , p_lot_number_id IN NUMBER
42 , p_pick_slip_number IN NUMBER
43 , p_lpn_id IN NUMBER
44 , p_project_id IN NUMBER Default Null
45 , p_task_id IN NUMBER Default Null
46 , p_Serial_Number_Tbl In Inv_Reservation_Global.Serial_Number_Tbl_Type
47 , p_ship_ready_flag IN NUMBER
48 , p_CrossDock_Flag In Varchar2 Default Null
49 , p_attribute_category IN VARCHAR2 DEFAULT NULL
50 , p_attribute1 IN VARCHAR2 DEFAULT NULL
51 , p_attribute2 IN VARCHAR2 DEFAULT NULL
52 , p_attribute3 IN VARCHAR2 DEFAULT NULL
53 , p_attribute4 IN VARCHAR2 DEFAULT NULL
54 , p_attribute5 IN VARCHAR2 DEFAULT NULL
55 , p_attribute6 IN VARCHAR2 DEFAULT NULL
56 , p_attribute7 IN VARCHAR2 DEFAULT NULL
57 , p_attribute8 IN VARCHAR2 DEFAULT NULL
58 , p_attribute9 IN VARCHAR2 DEFAULT NULL
59 , p_attribute10 IN VARCHAR2 DEFAULT NULL
60 , p_attribute11 IN VARCHAR2 DEFAULT NULL
61 , p_attribute12 IN VARCHAR2 DEFAULT NULL
62 , p_attribute13 IN VARCHAR2 DEFAULT NULL
63 , p_attribute14 IN VARCHAR2 DEFAULT NULL
64 , p_attribute15 IN VARCHAR2 DEFAULT NULL
65 , p_partial_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false
66 , p_force_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false
67 , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true
68 , x_quantity_reserved OUT NOCOPY NUMBER
69 , x_secondary_quantity_reserved OUT NOCOPY NUMBER
70 , x_reservation_id OUT NOCOPY NUMBER
71 );
72
73 PROCEDURE create_reservation(
74 p_api_version_number IN NUMBER
75 , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_true
76 , x_return_status OUT NOCOPY VARCHAR2
77 , x_msg_count OUT NOCOPY NUMBER
78 , x_msg_data OUT NOCOPY VARCHAR2
79 , p_requirement_date IN DATE
80 , p_organization_id IN NUMBER
81 , p_inventory_item_id IN NUMBER
82 , p_demand_type_id IN NUMBER
83 , p_demand_name IN VARCHAR2
84 , p_demand_header_id IN NUMBER
85 , p_demand_line_id IN NUMBER
86 , p_demand_delivery_id IN NUMBER DEFAULT NULL
87 , p_primary_uom_code IN VARCHAR2
88 , p_primary_uom_id IN NUMBER
89 , p_reservation_uom_code IN VARCHAR2
90 , p_reservation_uom_id IN NUMBER
91 , p_reservation_quantity IN NUMBER
92 , p_primary_rsv_quantity IN NUMBER
93 , p_autodetail_group_id IN NUMBER
94 , p_external_source_code IN VARCHAR2
95 , p_external_source_line IN NUMBER
96 , p_supply_type_id IN NUMBER
97 , p_supply_header_id IN NUMBER
98 , p_supply_line_id IN NUMBER
99 , p_supply_name IN VARCHAR2
100 , p_supply_line_detail IN NUMBER
101 , p_revision IN VARCHAR2
102 , p_subinventory_code IN VARCHAR2
103 , p_subinventory_id IN NUMBER
104 , p_locator_id IN NUMBER
105 , p_lot_number IN VARCHAR2
106 , p_lot_number_id IN NUMBER
107 , p_pick_slip_number IN NUMBER
108 , p_lpn_id IN NUMBER
109 , p_ship_ready_flag IN NUMBER
110 , p_attribute_category IN VARCHAR2 DEFAULT NULL
111 , p_attribute1 IN VARCHAR2 DEFAULT NULL
112 , p_attribute2 IN VARCHAR2 DEFAULT NULL
113 , p_attribute3 IN VARCHAR2 DEFAULT NULL
114 , p_attribute4 IN VARCHAR2 DEFAULT NULL
115 , p_attribute5 IN VARCHAR2 DEFAULT NULL
116 , p_attribute6 IN VARCHAR2 DEFAULT NULL
117 , p_attribute7 IN VARCHAR2 DEFAULT NULL
118 , p_attribute8 IN VARCHAR2 DEFAULT NULL
119 , p_attribute9 IN VARCHAR2 DEFAULT NULL
120 , p_attribute10 IN VARCHAR2 DEFAULT NULL
121 , p_attribute11 IN VARCHAR2 DEFAULT NULL
122 , p_attribute12 IN VARCHAR2 DEFAULT NULL
123 , p_attribute13 IN VARCHAR2 DEFAULT NULL
124 , p_attribute14 IN VARCHAR2 DEFAULT NULL
125 , p_attribute15 IN VARCHAR2 DEFAULT NULL
126 , p_partial_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false
127 , p_force_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false
128 , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true
129 , x_quantity_reserved OUT NOCOPY NUMBER
130 , x_reservation_id OUT NOCOPY NUMBER
131 );
132
133 --
134 -- INVCONV - Incorporate secondaries into parameter list
135 PROCEDURE update_reservation(
136 p_api_version_number IN NUMBER
137 , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_true
138 , x_return_status OUT NOCOPY VARCHAR2
139 , x_msg_count OUT NOCOPY NUMBER
140 , x_msg_data OUT NOCOPY VARCHAR2
141 , p_from_reservation_id IN NUMBER
142 , p_from_requirement_date IN DATE
143 , p_from_organization_id IN NUMBER
144 , p_from_inventory_item_id IN NUMBER
145 , p_from_demand_type_id IN NUMBER
146 , p_from_demand_name IN VARCHAR2
147 , p_from_demand_header_id IN NUMBER
148 , p_from_demand_line_id IN NUMBER
149 , p_from_demand_delivery_id IN NUMBER DEFAULT NULL
150 , p_from_primary_uom_code IN VARCHAR2
151 , p_from_primary_uom_id IN NUMBER
152 , p_from_secondary_uom_code IN VARCHAR2 DEFAULT NULL
153 , p_from_secondary_uom_id IN NUMBER DEFAULT NULL
154 , p_from_reservation_uom_code IN VARCHAR2
155 , p_from_reservation_uom_id IN NUMBER
156 , p_from_reservation_quantity IN NUMBER
157 , p_from_primary_rsv_quantity IN NUMBER
158 , p_from_secondary_rsv_quantity IN NUMBER DEFAULT NULL
159 , p_from_autodetail_group_id IN NUMBER
160 , p_from_external_source_code IN VARCHAR2
161 , p_from_external_source_line IN NUMBER
162 , p_from_supply_type_id IN NUMBER
163 , p_from_supply_header_id IN NUMBER
164 , p_from_supply_line_id IN NUMBER
165 , p_from_supply_name IN VARCHAR2
166 , p_from_supply_line_detail IN NUMBER
167 , p_from_revision IN VARCHAR2
168 , p_from_subinventory_code IN VARCHAR2
169 , p_from_subinventory_id IN NUMBER
170 , p_from_locator_id IN NUMBER
171 , p_from_lot_number IN VARCHAR2
172 , p_from_lot_number_id IN NUMBER
173 , p_from_pick_slip_number IN NUMBER
174 , p_from_lpn_id IN NUMBER
175 , p_from_project_id IN NUMBER Default Null
176 , p_from_task_id IN NUMBER Default Null
177 , p_From_Serial_Number_Tbl In Inv_Reservation_Global.Serial_Number_Tbl_Type
178 , p_from_ship_ready_flag IN NUMBER
179 , p_From_CrossDock_Flag In Varchar2 Default Null
180 , p_from_attribute_category IN VARCHAR2 DEFAULT NULL
181 , p_from_attribute1 IN VARCHAR2 DEFAULT NULL
182 , p_from_attribute2 IN VARCHAR2 DEFAULT NULL
183 , p_from_attribute3 IN VARCHAR2 DEFAULT NULL
184 , p_from_attribute4 IN VARCHAR2 DEFAULT NULL
185 , p_from_attribute5 IN VARCHAR2 DEFAULT NULL
186 , p_from_attribute6 IN VARCHAR2 DEFAULT NULL
187 , p_from_attribute7 IN VARCHAR2 DEFAULT NULL
188 , p_from_attribute8 IN VARCHAR2 DEFAULT NULL
189 , p_from_attribute9 IN VARCHAR2 DEFAULT NULL
190 , p_from_attribute10 IN VARCHAR2 DEFAULT NULL
191 , p_from_attribute11 IN VARCHAR2 DEFAULT NULL
192 , p_from_attribute12 IN VARCHAR2 DEFAULT NULL
193 , p_from_attribute13 IN VARCHAR2 DEFAULT NULL
194 , p_from_attribute14 IN VARCHAR2 DEFAULT NULL
195 , p_from_attribute15 IN VARCHAR2 DEFAULT NULL
196 , p_to_requirement_date IN DATE
197 , p_to_demand_type_id IN NUMBER
198 , p_to_demand_name IN VARCHAR2
199 , p_to_demand_header_id IN NUMBER
200 , p_to_demand_line_id IN NUMBER
201 , p_to_demand_delivery_id IN NUMBER DEFAULT NULL
202 , p_to_reservation_uom_code IN VARCHAR2 DEFAULT NULL
203 , p_to_reservation_uom_id IN NUMBER DEFAULT NULL
204 , p_to_reservation_quantity IN NUMBER
205 , p_to_primary_rsv_quantity IN NUMBER
206 , p_to_secondary_rsv_quantity IN NUMBER DEFAULT NULL
207 , p_to_autodetail_group_id IN NUMBER
208 , p_to_external_source_code IN VARCHAR2
209 , p_to_external_source_line IN NUMBER
210 , p_to_supply_type_id IN NUMBER
211 , p_to_supply_header_id IN NUMBER
212 , p_to_supply_line_id IN NUMBER
213 , p_to_supply_name IN VARCHAR2
214 , p_to_supply_line_detail IN NUMBER
215 , p_to_revision IN VARCHAR2
216 , p_to_subinventory_code IN VARCHAR2
217 , p_to_subinventory_id IN NUMBER
218 , p_to_locator_id IN NUMBER
219 , p_to_lot_number IN VARCHAR2
220 , p_to_lot_number_id IN NUMBER
221 , p_to_pick_slip_number IN NUMBER
222 , p_to_lpn_id IN NUMBER
223 , p_to_project_id IN NUMBER Default Null
224 , p_to_task_id IN NUMBER Default Null
225 , p_To_Serial_Number_Tbl In Inv_Reservation_Global.Serial_Number_Tbl_Type
226 , p_to_ship_ready_flag IN NUMBER
227 , p_To_CrossDock_Flag In Varchar2 Default Null
228 , p_to_attribute_category IN VARCHAR2 DEFAULT NULL
229 , p_to_attribute1 IN VARCHAR2 DEFAULT NULL
230 , p_to_attribute2 IN VARCHAR2 DEFAULT NULL
231 , p_to_attribute3 IN VARCHAR2 DEFAULT NULL
232 , p_to_attribute4 IN VARCHAR2 DEFAULT NULL
233 , p_to_attribute5 IN VARCHAR2 DEFAULT NULL
234 , p_to_attribute6 IN VARCHAR2 DEFAULT NULL
235 , p_to_attribute7 IN VARCHAR2 DEFAULT NULL
236 , p_to_attribute8 IN VARCHAR2 DEFAULT NULL
237 , p_to_attribute9 IN VARCHAR2 DEFAULT NULL
238 , p_to_attribute10 IN VARCHAR2 DEFAULT NULL
239 , p_to_attribute11 IN VARCHAR2 DEFAULT NULL
240 , p_to_attribute12 IN VARCHAR2 DEFAULT NULL
241 , p_to_attribute13 IN VARCHAR2 DEFAULT NULL
242 , p_to_attribute14 IN VARCHAR2 DEFAULT NULL
243 , p_to_attribute15 IN VARCHAR2 DEFAULT NULL
244 , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true
245 );
246
247 --
248 -- INVCONV - Incorporate secondaries into parameter list
249 PROCEDURE delete_reservation(
250 p_api_version_number IN NUMBER
251 , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_true
252 , x_return_status OUT NOCOPY VARCHAR2
253 , x_msg_count OUT NOCOPY NUMBER
254 , x_msg_data OUT NOCOPY VARCHAR2
255 , p_reservation_id IN NUMBER
256 , p_requirement_date IN DATE
257 , p_organization_id IN NUMBER
258 , p_inventory_item_id IN NUMBER
262 , p_demand_line_id IN NUMBER
259 , p_demand_type_id IN NUMBER
260 , p_demand_name IN VARCHAR2
261 , p_demand_header_id IN NUMBER
263 , p_demand_delivery_id IN NUMBER DEFAULT NULL
264 , p_primary_uom_code IN VARCHAR2
265 , p_primary_uom_id IN NUMBER
266 , p_secondary_uom_code IN VARCHAR2 DEFAULT NULL
267 , p_secondary_uom_id IN NUMBER DEFAULT NULL
268 , p_reservation_uom_code IN VARCHAR2
269 , p_reservation_uom_id IN NUMBER
270 , p_reservation_quantity IN NUMBER
271 , p_primary_rsv_quantity IN NUMBER
272 , p_secondary_rsv_quantity IN NUMBER DEFAULT NULL
273 , p_autodetail_group_id IN NUMBER
274 , p_external_source_code IN VARCHAR2
275 , p_external_source_line IN NUMBER
276 , p_supply_type_id IN NUMBER
277 , p_supply_header_id IN NUMBER
278 , p_supply_line_id IN NUMBER
279 , p_supply_name IN VARCHAR2
280 , p_supply_line_detail IN NUMBER
281 , p_revision IN VARCHAR2
282 , p_subinventory_code IN VARCHAR2
283 , p_subinventory_id IN NUMBER
284 , p_locator_id IN NUMBER
285 , p_lot_number IN VARCHAR2
286 , p_lot_number_id IN NUMBER
287 , p_pick_slip_number IN NUMBER
288 , p_lpn_id IN NUMBER
289 , p_Serial_Number_Tbl In Inv_Reservation_Global.Serial_Number_Tbl_Type
290 , p_ship_ready_flag IN NUMBER
291 , p_CrossDock_Flag In Varchar2 Default Null
292 , p_attribute_category IN VARCHAR2 DEFAULT NULL
293 , p_attribute1 IN VARCHAR2 DEFAULT NULL
294 , p_attribute2 IN VARCHAR2 DEFAULT NULL
295 , p_attribute3 IN VARCHAR2 DEFAULT NULL
296 , p_attribute4 IN VARCHAR2 DEFAULT NULL
297 , p_attribute5 IN VARCHAR2 DEFAULT NULL
298 , p_attribute6 IN VARCHAR2 DEFAULT NULL
299 , p_attribute7 IN VARCHAR2 DEFAULT NULL
300 , p_attribute8 IN VARCHAR2 DEFAULT NULL
301 , p_attribute9 IN VARCHAR2 DEFAULT NULL
302 , p_attribute10 IN VARCHAR2 DEFAULT NULL
303 , p_attribute11 IN VARCHAR2 DEFAULT NULL
304 , p_attribute12 IN VARCHAR2 DEFAULT NULL
305 , p_attribute13 IN VARCHAR2 DEFAULT NULL
306 , p_attribute14 IN VARCHAR2 DEFAULT NULL
307 , p_attribute15 IN VARCHAR2 DEFAULT NULL
308 , p_validation_flag IN VARCHAR2 DEFAULT 'T' --Bug 2354735
309 );
310
311 --
312 PROCEDURE transfer_supply(
313 p_api_version_number IN NUMBER
314 , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_true
315 , x_return_status OUT NOCOPY VARCHAR2
316 , x_msg_count OUT NOCOPY NUMBER
317 , x_msg_data OUT NOCOPY VARCHAR2
318 , p_from_reservation_id IN NUMBER
319 , p_from_requirement_date IN DATE
320 , p_from_organization_id IN NUMBER
321 , p_from_inventory_item_id IN NUMBER
322 , p_from_demand_type_id IN NUMBER
323 , p_from_demand_name IN VARCHAR2
324 , p_from_demand_header_id IN NUMBER
325 , p_from_demand_line_id IN NUMBER
326 , p_from_demand_delivery_id IN NUMBER DEFAULT NULL
327 , p_from_primary_uom_code IN VARCHAR2
328 , p_from_primary_uom_id IN NUMBER
329 , p_from_secondary_uom_code IN VARCHAR2
330 , p_from_secondary_uom_id IN NUMBER
331 , p_from_reservation_uom_code IN VARCHAR2
332 , p_from_reservation_uom_id IN NUMBER
333 , p_from_reservation_quantity IN NUMBER
334 , p_from_primary_rsv_quantity IN NUMBER
335 , p_from_secondary_rsv_quantity IN NUMBER
336 , p_from_autodetail_group_id IN NUMBER
337 , p_from_external_source_code IN VARCHAR2
338 , p_from_external_source_line IN NUMBER
339 , p_from_supply_type_id IN NUMBER
340 , p_from_supply_header_id IN NUMBER
341 , p_from_supply_line_id IN NUMBER
342 , p_from_supply_name IN VARCHAR2
343 , p_from_supply_line_detail IN NUMBER
344 , p_from_revision IN VARCHAR2
345 , p_from_subinventory_code IN VARCHAR2
346 , p_from_subinventory_id IN NUMBER
347 , p_from_locator_id IN NUMBER
348 , p_from_lot_number IN VARCHAR2
349 , p_from_lot_number_id IN NUMBER
350 , p_from_pick_slip_number IN NUMBER
351 , p_from_lpn_id IN NUMBER
352 , p_from_ship_ready_flag IN NUMBER
353 , p_from_attribute_category IN VARCHAR2 DEFAULT NULL
354 , p_from_attribute1 IN VARCHAR2 DEFAULT NULL
355 , p_from_attribute2 IN VARCHAR2 DEFAULT NULL
356 , p_from_attribute3 IN VARCHAR2 DEFAULT NULL
357 , p_from_attribute4 IN VARCHAR2 DEFAULT NULL
358 , p_from_attribute5 IN VARCHAR2 DEFAULT NULL
359 , p_from_attribute6 IN VARCHAR2 DEFAULT NULL
360 , p_from_attribute7 IN VARCHAR2 DEFAULT NULL
361 , p_from_attribute8 IN VARCHAR2 DEFAULT NULL
362 , p_from_attribute9 IN VARCHAR2 DEFAULT NULL
363 , p_from_attribute10 IN VARCHAR2 DEFAULT NULL
364 , p_from_attribute11 IN VARCHAR2 DEFAULT NULL
365 , p_from_attribute12 IN VARCHAR2 DEFAULT NULL
366 , p_from_attribute13 IN VARCHAR2 DEFAULT NULL
367 , p_from_attribute14 IN VARCHAR2 DEFAULT NULL
368 , p_from_attribute15 IN VARCHAR2 DEFAULT NULL
369 , p_to_reservation_uom_code IN VARCHAR2
370 , p_to_secondary_uom_code IN VARCHAR2
371 , p_to_reservation_quantity IN NUMBER
372 , p_to_secondary_rsv_quantity IN NUMBER
376 , p_to_supply_name IN VARCHAR2
373 , p_to_supply_type_id IN NUMBER
374 , p_to_supply_header_id IN NUMBER
375 , p_to_supply_line_id IN NUMBER
377 , p_to_supply_line_detail IN NUMBER
378 , p_to_revision IN VARCHAR2
379 , p_to_subinventory_code IN VARCHAR2
380 , p_to_subinventory_id IN NUMBER
381 , p_to_locator_id IN NUMBER
382 , p_to_lot_number IN VARCHAR2
383 , p_to_lot_number_id IN NUMBER
384 , p_to_pick_slip_number IN NUMBER
385 , p_to_lpn_id IN NUMBER
386 , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true
387 , x_to_reservation_id OUT NOCOPY NUMBER
388 );
389
390 --
391 PROCEDURE transfer_demand(
392 p_api_version_number IN NUMBER
393 , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_true
394 , x_return_status OUT NOCOPY VARCHAR2
395 , x_msg_count OUT NOCOPY NUMBER
396 , x_msg_data OUT NOCOPY VARCHAR2
397 , p_from_reservation_id IN NUMBER
398 , p_from_requirement_date IN DATE
399 , p_from_organization_id IN NUMBER
400 , p_from_inventory_item_id IN NUMBER
401 , p_from_demand_type_id IN NUMBER
402 , p_from_demand_name IN VARCHAR2
403 , p_from_demand_header_id IN NUMBER
404 , p_from_demand_line_id IN NUMBER
405 , p_from_demand_delivery_id IN NUMBER DEFAULT NULL
406 , p_from_primary_uom_code IN VARCHAR2
407 , p_from_primary_uom_id IN NUMBER
408 , p_from_secondary_uom_code IN VARCHAR2
409 , p_from_secondary_uom_id IN NUMBER
410 , p_from_reservation_uom_code IN VARCHAR2
411 , p_from_reservation_uom_id IN NUMBER
412 , p_from_reservation_quantity IN NUMBER
413 , p_from_primary_rsv_quantity IN NUMBER
414 , p_from_secondary_rsv_quantity IN NUMBER
415 , p_from_autodetail_group_id IN NUMBER
416 , p_from_external_source_code IN VARCHAR2
417 , p_from_external_source_line IN NUMBER
418 , p_from_supply_type_id IN NUMBER
419 , p_from_supply_header_id IN NUMBER
420 , p_from_supply_line_id IN NUMBER
421 , p_from_supply_name IN VARCHAR2
422 , p_from_supply_line_detail IN NUMBER
423 , p_from_revision IN VARCHAR2
424 , p_from_subinventory_code IN VARCHAR2
425 , p_from_subinventory_id IN NUMBER
426 , p_from_locator_id IN NUMBER
427 , p_from_lot_number IN VARCHAR2
428 , p_from_lot_number_id IN NUMBER
429 , p_from_pick_slip_number IN NUMBER
430 , p_from_lpn_id IN NUMBER
431 , p_from_project_id IN NUMBER Default Null
432 , p_from_task_id IN NUMBER Default Null
433 , p_from_ship_ready_flag IN NUMBER
434 , p_from_attribute_category IN VARCHAR2 DEFAULT NULL
435 , p_from_attribute1 IN VARCHAR2 DEFAULT NULL
436 , p_from_attribute2 IN VARCHAR2 DEFAULT NULL
437 , p_from_attribute3 IN VARCHAR2 DEFAULT NULL
438 , p_from_attribute4 IN VARCHAR2 DEFAULT NULL
439 , p_from_attribute5 IN VARCHAR2 DEFAULT NULL
440 , p_from_attribute6 IN VARCHAR2 DEFAULT NULL
441 , p_from_attribute7 IN VARCHAR2 DEFAULT NULL
442 , p_from_attribute8 IN VARCHAR2 DEFAULT NULL
443 , p_from_attribute9 IN VARCHAR2 DEFAULT NULL
444 , p_from_attribute10 IN VARCHAR2 DEFAULT NULL
445 , p_from_attribute11 IN VARCHAR2 DEFAULT NULL
446 , p_from_attribute12 IN VARCHAR2 DEFAULT NULL
447 , p_from_attribute13 IN VARCHAR2 DEFAULT NULL
448 , p_from_attribute14 IN VARCHAR2 DEFAULT NULL
449 , p_from_attribute15 IN VARCHAR2 DEFAULT NULL
450 , p_to_demand_type_id IN NUMBER
451 , p_to_demand_name IN VARCHAR2
452 , p_to_demand_header_id IN NUMBER
453 , p_to_demand_line_id IN NUMBER
454 , p_to_demand_delivery_id IN NUMBER DEFAULT NULL
455 , p_to_reservation_uom_code IN VARCHAR2
456 , p_to_reservation_quantity IN NUMBER
457 , p_to_secondary_uom_code IN VARCHAR2 -- INVCONV
458 , p_to_secondary_rsv_quantity IN NUMBER -- INVCONV
459 , p_to_project_id IN NUMBER Default Null
460 , p_to_task_id IN NUMBER Default Null
461 , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true
462 , x_to_reservation_id OUT NOCOPY NUMBER
463 );
464
465 --
466 PROCEDURE query_reservation(
467 p_api_version_number IN NUMBER
468 , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
469 , x_return_status OUT NOCOPY VARCHAR2
470 , x_msg_count OUT NOCOPY NUMBER
471 , x_msg_data OUT NOCOPY VARCHAR2
472 , p_reservation_id IN NUMBER
473 , p_lock_records IN VARCHAR2 DEFAULT fnd_api.g_false
474 , p_sort_by_req_date IN NUMBER
475 , p_cancel_order_mode IN NUMBER
476 , x_mtl_reservation_tbl OUT NOCOPY inv_reservation_global.mtl_reservation_tbl_type
477 , x_mtl_reservation_tbl_count OUT NOCOPY NUMBER
478 , x_error_code OUT NOCOPY NUMBER
479 );
480
481 --
482 PROCEDURE get_reservable_quantity(
483 p_api_version_number IN NUMBER
484 , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
485 , x_return_status OUT NOCOPY VARCHAR2
486 , x_msg_count OUT NOCOPY NUMBER
487 , x_msg_data OUT NOCOPY VARCHAR2
491 , p_demand_name IN VARCHAR2
488 , p_reservation_id IN NUMBER
489 , p_reservation_uom_code IN VARCHAR2
490 , p_demand_type_id IN NUMBER
492 , p_demand_header_id IN NUMBER
493 , p_demand_line_id IN NUMBER
494 , p_demand_delivery_id IN NUMBER DEFAULT NULL
495 , p_Project_Id In Number
496 , p_Task_Id In Number
497 , x_reservable_quantity OUT NOCOPY NUMBER
498 , x_reservation_margin_above OUT NOCOPY NUMBER -- INVCONV
499 );
500 -- GME CONVERGENCE BEGIN
501 PROCEDURE create_move_order_header
502 (
503 p_api_version_number IN NUMBER
504 , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
505 , p_organization_id IN NUMBER
506 , x_return_status OUT NOCOPY VARCHAR2
507 , x_msg_count OUT NOCOPY NUMBER
508 , x_msg_data OUT NOCOPY VARCHAR2
509 , x_header_id OUT NOCOPY NUMBER
510 );
511
512 PROCEDURE create_move_order_line
513 (
514 p_api_version_number IN NUMBER
515 , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
516 , p_organization_id IN NUMBER
517 , p_move_order_header_id IN NUMBER
518 , p_inventory_item_id IN NUMBER
519 , p_quantity IN NUMBER
520 , p_uom_code IN VARCHAR2
521 , p_secondary_quantity IN NUMBER DEFAULT NULL
522 , p_secondary_uom IN VARCHAR2 DEFAULT NULL
523 , p_revision IN VARCHAR2
524 , p_date_required IN DATE
525 , p_source_type_id IN NUMBER
526 , p_source_id IN NUMBER
527 , p_source_line_id IN NUMBER
528 , p_grade_code IN VARCHAR2
529 , x_return_status OUT NOCOPY VARCHAR2
530 , x_msg_count OUT NOCOPY NUMBER
531 , x_msg_data OUT NOCOPY VARCHAR2
532 , x_line_id OUT NOCOPY NUMBER
533 );
534
535 PROCEDURE delete_move_order
536 (
537 p_api_version_number IN NUMBER
538 , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
539 , p_move_order_header_id IN NUMBER
540 , x_return_status OUT NOCOPY VARCHAR2
541 , x_msg_count OUT NOCOPY NUMBER
542 , x_msg_data OUT NOCOPY VARCHAR2
543 );
544 -- GME CONVERGENCE END
545
546 --bug 4097848
547
548 FUNCTION demand_source_line_number(
549 p_line_number IN NUMBER
550 , p_shipment_number IN NUMBER
551 , p_option_number IN NUMBER
552 , p_component_number IN NUMBER
553 , p_service_number IN NUMBER
554 )
555 RETURN VARCHAR2;
556
557 END inv_reservation_form_pkg;
[Home] [Help]