1 PACKAGE MTL_RESERVATIONS_PKG AS
2 /* $Header: INVRSV6S.pls 120.2 2006/09/20 11:27:23 bradha ship $ */
3
4 -- INV CONV
5 -- Add columns to signatures as follows:
6 -- secondary_uom_code
7 -- secondary_uom_id
8 -- secondary_reservation_quantity
9 -- secondary_detailed_quantity
10 PROCEDURE INSERT_ROW (
11 x_rowid IN OUT NOCOPY VARCHAR2
12 ,x_reservation_id IN OUT NOCOPY NUMBER
13 ,x_requirement_date IN DATE
14 ,x_organization_id IN NUMBER
15 ,x_inventory_item_id IN NUMBER
16 ,x_demand_source_type_id IN NUMBER
17 ,x_demand_source_name IN VARCHAR2
18 ,x_demand_source_header_id IN NUMBER
19 ,x_demand_source_line_id IN NUMBER
20 ,x_demand_source_delivery IN NUMBER
21 ,x_primary_uom_code IN VARCHAR2
22 ,x_primary_uom_id IN NUMBER
23 ,x_secondary_uom_code IN VARCHAR2
24 ,x_secondary_uom_id IN NUMBER
25 ,x_reservation_uom_code IN VARCHAR2
26 ,x_reservation_uom_id IN NUMBER
27 ,x_reservation_quantity IN NUMBER
28 ,x_primary_reservation_quantity IN NUMBER
29 ,x_second_reservation_quantity IN NUMBER
30 ,x_detailed_quantity IN NUMBER
31 ,x_secondary_detailed_quantity IN NUMBER
32 ,x_autodetail_group_id IN NUMBER
33 ,x_external_source_code IN VARCHAR2
34 ,x_external_source_line_id IN NUMBER
35 ,x_supply_source_type_id IN NUMBER
36 ,x_supply_source_header_id IN NUMBER
37 ,x_supply_source_line_id IN NUMBER
38 ,x_supply_source_line_detail IN NUMBER
39 ,x_supply_source_name IN VARCHAR2
40 ,x_revision IN VARCHAR2
41 ,x_subinventory_code IN VARCHAR2
42 ,x_subinventory_id IN NUMBER
43 ,x_locator_id IN NUMBER
44 ,x_lot_number IN VARCHAR2
45 ,x_lot_number_id IN NUMBER
46 ,x_serial_number IN VARCHAR2
47 ,x_serial_number_id IN NUMBER
48 ,x_partial_quantities_allowed IN NUMBER
49 ,x_auto_detailed IN NUMBER
50 ,x_pick_slip_number IN NUMBER
51 ,x_lpn_id IN NUMBER
52 ,x_last_update_date IN DATE
53 ,x_last_updated_by IN NUMBER
54 ,x_creation_date IN DATE
55 ,x_created_by IN NUMBER
56 ,x_last_update_login IN NUMBER
57 ,x_request_id IN NUMBER
58 ,x_program_application_id IN NUMBER
59 ,x_program_id IN NUMBER
60 ,x_program_update_date IN DATE
61 ,x_attribute_category IN VARCHAR2
62 ,x_attribute1 IN VARCHAR2
63 ,x_attribute2 IN VARCHAR2
64 ,x_attribute3 IN VARCHAR2
65 ,x_attribute4 IN VARCHAR2
66 ,x_attribute5 IN VARCHAR2
67 ,x_attribute6 IN VARCHAR2
68 ,x_attribute7 IN VARCHAR2
69 ,x_attribute8 IN VARCHAR2
70 ,x_attribute9 IN VARCHAR2
71 ,x_attribute10 IN VARCHAR2
72 ,x_attribute11 IN VARCHAR2
73 ,x_attribute12 IN VARCHAR2
74 ,x_attribute13 IN VARCHAR2
75 ,x_attribute14 IN VARCHAR2
76 ,x_attribute15 IN VARCHAR2
77 ,x_ship_ready_flag IN NUMBER
78 );
79
80 PROCEDURE LOCK_ROW (
81 x_reservation_id IN NUMBER
82 ,x_requirement_date IN DATE
83 ,x_organization_id IN NUMBER
84 ,x_inventory_item_id IN NUMBER
85 ,x_demand_source_type_id IN NUMBER
86 ,x_demand_source_name IN VARCHAR2
87 ,x_demand_source_header_id IN NUMBER
88 ,x_demand_source_line_id IN NUMBER
89 ,x_demand_source_delivery IN NUMBER
90 ,x_primary_uom_code IN VARCHAR2
91 ,x_primary_uom_id IN NUMBER
92 ,x_secondary_uom_code IN VARCHAR2
93 ,x_secondary_uom_id IN NUMBER
94 ,x_reservation_uom_code IN VARCHAR2
95 ,x_reservation_uom_id IN NUMBER
96 ,x_reservation_quantity IN NUMBER
97 ,x_primary_reservation_quantity IN NUMBER
98 ,x_second_reservation_quantity IN NUMBER
99 ,x_detailed_quantity IN NUMBER
100 ,x_secondary_detailed_quantity IN NUMBER
101 ,x_autodetail_group_id IN NUMBER
102 ,x_external_source_code IN VARCHAR2
103 ,x_external_source_line_id IN NUMBER
104 ,x_supply_source_type_id IN NUMBER
105 ,x_supply_source_header_id IN NUMBER
106 ,x_supply_source_line_id IN NUMBER
107 ,x_supply_source_line_detail IN NUMBER
108 ,x_supply_source_name IN VARCHAR2
109 ,x_revision IN VARCHAR2
110 ,x_subinventory_code IN VARCHAR2
111 ,x_subinventory_id IN NUMBER
112 ,x_locator_id IN NUMBER
113 ,x_lot_number IN VARCHAR2
114 ,x_lot_number_id IN NUMBER
115 ,x_serial_number IN VARCHAR2
116 ,x_serial_number_id IN NUMBER
117 ,x_partial_quantities_allowed IN NUMBER
118 ,x_auto_detailed IN NUMBER
119 ,x_pick_slip_number IN NUMBER
120 ,x_lpn_id IN NUMBER
121 ,x_request_id IN NUMBER
122 ,x_program_application_id IN NUMBER
123 ,x_program_id IN NUMBER
124 ,x_program_update_date IN DATE
125 ,x_attribute_category IN VARCHAR2
126 ,x_attribute1 IN VARCHAR2
127 ,x_attribute2 IN VARCHAR2
128 ,x_attribute3 IN VARCHAR2
129 ,x_attribute4 IN VARCHAR2
130 ,x_attribute5 IN VARCHAR2
131 ,x_attribute6 IN VARCHAR2
132 ,x_attribute7 IN VARCHAR2
133 ,x_attribute8 IN VARCHAR2
134 ,x_attribute9 IN VARCHAR2
135 ,x_attribute10 IN VARCHAR2
136 ,x_attribute11 IN VARCHAR2
137 ,x_attribute12 IN VARCHAR2
138 ,x_attribute13 IN VARCHAR2
139 ,x_attribute14 IN VARCHAR2
140 ,x_attribute15 IN VARCHAR2
141 ,x_ship_ready_flag IN NUMBER
142 );
143
144 PROCEDURE UPDATE_ROW (
145 x_reservation_id IN NUMBER
146 ,x_requirement_date IN DATE
147 ,x_organization_id IN NUMBER
148 ,x_inventory_item_id IN NUMBER
149 ,x_demand_source_type_id IN NUMBER
150 ,x_demand_source_name IN VARCHAR2
151 ,x_demand_source_header_id IN NUMBER
152 ,x_demand_source_line_id IN NUMBER
153 ,x_demand_source_delivery IN NUMBER
154 ,x_primary_uom_code IN VARCHAR2
155 ,x_primary_uom_id IN NUMBER
156 ,x_secondary_uom_code IN VARCHAR2
157 ,x_secondary_uom_id IN NUMBER
158 ,x_reservation_uom_code IN VARCHAR2
159 ,x_reservation_uom_id IN NUMBER
160 ,x_reservation_quantity IN NUMBER
161 ,x_primary_reservation_quantity IN NUMBER
162 ,x_second_reservation_quantity IN NUMBER
163 ,x_detailed_quantity IN NUMBER
164 ,x_secondary_detailed_quantity IN NUMBER
165 ,x_autodetail_group_id IN NUMBER
166 ,x_external_source_code IN VARCHAR2
167 ,x_external_source_line_id IN NUMBER
168 ,x_supply_source_type_id IN NUMBER
169 ,x_supply_source_header_id IN NUMBER
170 ,x_supply_source_line_id IN NUMBER
171 ,x_supply_source_line_detail IN NUMBER
172 ,x_supply_source_name IN VARCHAR2
173 ,x_revision IN VARCHAR2
174 ,x_subinventory_code IN VARCHAR2
175 ,x_subinventory_id IN NUMBER
176 ,x_locator_id IN NUMBER
177 ,x_lot_number IN VARCHAR2
178 ,x_lot_number_id IN NUMBER
179 ,x_serial_number IN VARCHAR2
180 ,x_serial_number_id IN NUMBER
181 ,x_partial_quantities_allowed IN NUMBER
182 ,x_auto_detailed IN NUMBER
183 ,x_pick_slip_number IN NUMBER
184 ,x_lpn_id IN NUMBER
185 ,x_last_update_date IN DATE
186 ,x_last_updated_by IN NUMBER
187 ,x_last_update_login IN NUMBER
188 ,x_request_id IN NUMBER
189 ,x_program_application_id IN NUMBER
190 ,x_program_id IN NUMBER
191 ,x_program_update_date IN DATE
192 ,x_attribute_category IN VARCHAR2
193 ,x_attribute1 IN VARCHAR2
194 ,x_attribute2 IN VARCHAR2
195 ,x_attribute3 IN VARCHAR2
196 ,x_attribute4 IN VARCHAR2
197 ,x_attribute5 IN VARCHAR2
198 ,x_attribute6 IN VARCHAR2
199 ,x_attribute7 IN VARCHAR2
200 ,x_attribute8 IN VARCHAR2
201 ,x_attribute9 IN VARCHAR2
202 ,x_attribute10 IN VARCHAR2
203 ,x_attribute11 IN VARCHAR2
204 ,x_attribute12 IN VARCHAR2
205 ,x_attribute13 IN VARCHAR2
206 ,x_attribute14 IN VARCHAR2
207 ,x_attribute15 IN VARCHAR2
208 ,x_ship_ready_flag IN NUMBER
209 );
210
211 PROCEDURE INSERT_ROW (
212 x_rowid IN OUT NOCOPY VARCHAR2
213 ,x_reservation_id IN OUT NOCOPY NUMBER
214 ,x_requirement_date IN DATE
215 ,x_organization_id IN NUMBER
216 ,x_inventory_item_id IN NUMBER
217 ,x_demand_source_type_id IN NUMBER
218 ,x_demand_source_name IN VARCHAR2
219 ,x_demand_source_header_id IN NUMBER
220 ,x_demand_source_line_id IN NUMBER
221 ,x_demand_source_delivery IN NUMBER
222 ,x_primary_uom_code IN VARCHAR2
223 ,x_primary_uom_id IN NUMBER
224 ,x_secondary_uom_code IN VARCHAR2
225 ,x_secondary_uom_id IN NUMBER
226 ,x_reservation_uom_code IN VARCHAR2
227 ,x_reservation_uom_id IN NUMBER
228 ,x_reservation_quantity IN NUMBER
229 ,x_primary_reservation_quantity IN NUMBER
230 ,x_second_reservation_quantity IN NUMBER
231 ,x_detailed_quantity IN NUMBER
232 ,x_secondary_detailed_quantity IN NUMBER
233 ,x_autodetail_group_id IN NUMBER
234 ,x_external_source_code IN VARCHAR2
235 ,x_external_source_line_id IN NUMBER
236 ,x_supply_source_type_id IN NUMBER
237 ,x_supply_source_header_id IN NUMBER
241 ,x_revision IN VARCHAR2
238 ,x_supply_source_line_id IN NUMBER
239 ,x_supply_source_line_detail IN NUMBER
240 ,x_supply_source_name IN VARCHAR2
242 ,x_subinventory_code IN VARCHAR2
243 ,x_subinventory_id IN NUMBER
244 ,x_locator_id IN NUMBER
245 ,x_lot_number IN VARCHAR2
246 ,x_lot_number_id IN NUMBER
247 ,x_serial_number IN VARCHAR2
248 ,x_serial_number_id IN NUMBER
249 ,x_partial_quantities_allowed IN NUMBER
250 ,x_auto_detailed IN NUMBER
251 ,x_pick_slip_number IN NUMBER
252 ,x_lpn_id IN NUMBER
253 ,x_last_update_date IN DATE
254 ,x_last_updated_by IN NUMBER
255 ,x_creation_date IN DATE
256 ,x_created_by IN NUMBER
257 ,x_last_update_login IN NUMBER
258 ,x_request_id IN NUMBER
259 ,x_program_application_id IN NUMBER
260 ,x_program_id IN NUMBER
261 ,x_program_update_date IN DATE
262 ,x_attribute_category IN VARCHAR2
263 ,x_attribute1 IN VARCHAR2
264 ,x_attribute2 IN VARCHAR2
265 ,x_attribute3 IN VARCHAR2
266 ,x_attribute4 IN VARCHAR2
267 ,x_attribute5 IN VARCHAR2
268 ,x_attribute6 IN VARCHAR2
269 ,x_attribute7 IN VARCHAR2
270 ,x_attribute8 IN VARCHAR2
271 ,x_attribute9 IN VARCHAR2
272 ,x_attribute10 IN VARCHAR2
273 ,x_attribute11 IN VARCHAR2
274 ,x_attribute12 IN VARCHAR2
275 ,x_attribute13 IN VARCHAR2
276 ,x_attribute14 IN VARCHAR2
277 ,x_attribute15 IN VARCHAR2
278 ,x_ship_ready_flag IN NUMBER
279 ,x_staged_flag IN VARCHAR2
280 /**** {{ R12 Enhanced reservations code changes }}****/
281 , x_crossdock_flag IN VARCHAR2
282 , x_crossdock_criteria_id IN NUMBER
283 , x_demand_source_line_detail IN NUMBER
284 , x_serial_reservation_quantity IN NUMBER
285 , x_supply_receipt_date IN DATE
286 , x_demand_ship_date IN DATE
287 , x_project_id IN NUMBER
288 , x_task_id IN NUMBER
289 , x_orig_supply_type_id IN NUMBER
290 , x_orig_supply_header_id IN NUMBER
291 , x_orig_supply_line_id IN NUMBER
292 , x_orig_supply_line_detail IN NUMBER
293 , x_orig_demand_type_id IN NUMBER
294 , x_orig_demand_header_id IN NUMBER
295 , x_orig_demand_line_id IN NUMBER
296 , x_orig_demand_line_detail IN NUMBER
297 /*** End R12 ***/
298 );
299
300 PROCEDURE LOCK_ROW (
301 x_reservation_id IN NUMBER
302 ,x_requirement_date IN DATE
303 ,x_organization_id IN NUMBER
304 ,x_inventory_item_id IN NUMBER
305 ,x_demand_source_type_id IN NUMBER
306 ,x_demand_source_name IN VARCHAR2
307 ,x_demand_source_header_id IN NUMBER
308 ,x_demand_source_line_id IN NUMBER
309 ,x_demand_source_delivery IN NUMBER
310 ,x_primary_uom_code IN VARCHAR2
311 ,x_primary_uom_id IN NUMBER
312 ,x_secondary_uom_code IN VARCHAR2
313 ,x_secondary_uom_id IN NUMBER
314 ,x_reservation_uom_code IN VARCHAR2
315 ,x_reservation_uom_id IN NUMBER
316 ,x_reservation_quantity IN NUMBER
317 ,x_primary_reservation_quantity IN NUMBER
318 ,x_second_reservation_quantity IN NUMBER
319 ,x_detailed_quantity IN NUMBER
320 ,x_secondary_detailed_quantity IN NUMBER
321 ,x_autodetail_group_id IN NUMBER
322 ,x_external_source_code IN VARCHAR2
323 ,x_external_source_line_id IN NUMBER
324 ,x_supply_source_type_id IN NUMBER
325 ,x_supply_source_header_id IN NUMBER
326 ,x_supply_source_line_id IN NUMBER
327 ,x_supply_source_line_detail IN NUMBER
328 ,x_supply_source_name IN VARCHAR2
329 ,x_revision IN VARCHAR2
330 ,x_subinventory_code IN VARCHAR2
331 ,x_subinventory_id IN NUMBER
332 ,x_locator_id IN NUMBER
333 ,x_lot_number IN VARCHAR2
334 ,x_lot_number_id IN NUMBER
335 ,x_serial_number IN VARCHAR2
336 ,x_serial_number_id IN NUMBER
337 ,x_partial_quantities_allowed IN NUMBER
338 ,x_auto_detailed IN NUMBER
339 ,x_pick_slip_number IN NUMBER
340 ,x_lpn_id IN NUMBER
341 ,x_request_id IN NUMBER
342 ,x_program_application_id IN NUMBER
343 ,x_program_id IN NUMBER
344 ,x_program_update_date IN DATE
345 ,x_attribute_category IN VARCHAR2
349 ,x_attribute4 IN VARCHAR2
346 ,x_attribute1 IN VARCHAR2
347 ,x_attribute2 IN VARCHAR2
348 ,x_attribute3 IN VARCHAR2
350 ,x_attribute5 IN VARCHAR2
351 ,x_attribute6 IN VARCHAR2
352 ,x_attribute7 IN VARCHAR2
353 ,x_attribute8 IN VARCHAR2
354 ,x_attribute9 IN VARCHAR2
355 ,x_attribute10 IN VARCHAR2
356 ,x_attribute11 IN VARCHAR2
357 ,x_attribute12 IN VARCHAR2
358 ,x_attribute13 IN VARCHAR2
359 ,x_attribute14 IN VARCHAR2
360 ,x_attribute15 IN VARCHAR2
361 ,x_ship_ready_flag IN NUMBER
362 ,x_staged_flag IN VARCHAR2
363 /**** {{ R12 Enhanced reservations code changes }}****/
364 , x_crossdock_flag IN VARCHAR2
365 , x_crossdock_criteria_id IN NUMBER
366 , x_demand_source_line_detail IN NUMBER
367 , x_serial_reservation_quantity IN NUMBER
368 , x_supply_receipt_date IN DATE
369 , x_demand_ship_date IN DATE
370 , x_project_id IN NUMBER
371 , x_task_id IN NUMBER
372 , x_orig_supply_type_id IN NUMBER
373 , x_orig_supply_header_id IN NUMBER
374 , x_orig_supply_line_id IN NUMBER
375 , x_orig_supply_line_detail IN NUMBER
376 , x_orig_demand_type_id IN NUMBER
377 , x_orig_demand_header_id IN NUMBER
378 , x_orig_demand_line_id IN NUMBER
379 , x_orig_demand_line_detail IN NUMBER
380 /*** End R12 ***/
381 );
382
383 PROCEDURE UPDATE_ROW (
384 x_reservation_id IN NUMBER
385 ,x_requirement_date IN DATE
386 ,x_organization_id IN NUMBER
387 ,x_inventory_item_id IN NUMBER
388 ,x_demand_source_type_id IN NUMBER
389 ,x_demand_source_name IN VARCHAR2
390 ,x_demand_source_header_id IN NUMBER
391 ,x_demand_source_line_id IN NUMBER
392 ,x_demand_source_delivery IN NUMBER
393 ,x_primary_uom_code IN VARCHAR2
394 ,x_primary_uom_id IN NUMBER
395 ,x_secondary_uom_code IN VARCHAR2
396 ,x_secondary_uom_id IN NUMBER
397 ,x_reservation_uom_code IN VARCHAR2
398 ,x_reservation_uom_id IN NUMBER
399 ,x_reservation_quantity IN NUMBER
400 ,x_primary_reservation_quantity IN NUMBER
401 ,x_second_reservation_quantity IN NUMBER
402 ,x_detailed_quantity IN NUMBER
403 ,x_secondary_detailed_quantity IN NUMBER
404 ,x_autodetail_group_id IN NUMBER
405 ,x_external_source_code IN VARCHAR2
406 ,x_external_source_line_id IN NUMBER
407 ,x_supply_source_type_id IN NUMBER
408 ,x_supply_source_header_id IN NUMBER
409 ,x_supply_source_line_id IN NUMBER
410 ,x_supply_source_line_detail IN NUMBER
411 ,x_supply_source_name IN VARCHAR2
412 ,x_revision IN VARCHAR2
413 ,x_subinventory_code IN VARCHAR2
414 ,x_subinventory_id IN NUMBER
415 ,x_locator_id IN NUMBER
416 ,x_lot_number IN VARCHAR2
417 ,x_lot_number_id IN NUMBER
418 ,x_serial_number IN VARCHAR2
419 ,x_serial_number_id IN NUMBER
420 ,x_partial_quantities_allowed IN NUMBER
421 ,x_auto_detailed IN NUMBER
422 ,x_pick_slip_number IN NUMBER
423 ,x_lpn_id IN NUMBER
424 ,x_last_update_date IN DATE
425 ,x_last_updated_by IN NUMBER
426 ,x_last_update_login IN NUMBER
427 ,x_request_id IN NUMBER
428 ,x_program_application_id IN NUMBER
429 ,x_program_id IN NUMBER
430 ,x_program_update_date IN DATE
431 ,x_attribute_category IN VARCHAR2
432 ,x_attribute1 IN VARCHAR2
433 ,x_attribute2 IN VARCHAR2
434 ,x_attribute3 IN VARCHAR2
435 ,x_attribute4 IN VARCHAR2
436 ,x_attribute5 IN VARCHAR2
437 ,x_attribute6 IN VARCHAR2
438 ,x_attribute7 IN VARCHAR2
439 ,x_attribute8 IN VARCHAR2
440 ,x_attribute9 IN VARCHAR2
441 ,x_attribute10 IN VARCHAR2
442 ,x_attribute11 IN VARCHAR2
443 ,x_attribute12 IN VARCHAR2
444 ,x_attribute13 IN VARCHAR2
445 ,x_attribute14 IN VARCHAR2
446 ,x_attribute15 IN VARCHAR2
447 ,x_ship_ready_flag IN NUMBER
448 ,x_staged_flag IN VARCHAR2
449 /**** {{ R12 Enhanced reservations code changes }}****/
450 , x_crossdock_flag IN VARCHAR2
451 , x_crossdock_criteria_id IN NUMBER
452 , x_demand_source_line_detail IN NUMBER
453 , x_serial_reservation_quantity IN NUMBER
454 , x_supply_receipt_date IN DATE
455 , x_demand_ship_date IN DATE
456 , x_project_id IN NUMBER
457 , x_task_id IN NUMBER
458 /*** End R12 ***/
459 );
460
461 PROCEDURE DELETE_ROW (
462 x_reservation_id IN NUMBER
463 ,x_to_reservation_id IN NUMBER DEFAULT NULL
464
465 );
466 END MTL_RESERVATIONS_PKG;