eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_RESERVATION_PUB dependencies on FND_API

Line 30: -- Should be fnd_api.g_false or fnd_api.g_true

26: -- p_api_version_number API version number (current version is 1.0)
27: --
28: -- p_init_msg_lst Whether initialize the error message list or
29: -- not.
30: -- Should be fnd_api.g_false or fnd_api.g_true
31: --
32: -- p_rsv_rec Contains info to be used to create the
33: -- reservation
34: --

Line 39: -- Should be fnd_api.g_false or fnd_api.g_true

35: -- p_serial_number Contains serial numbers to be reserved
36: --
37: -- p_partial_reservation_flag If there is not enough quantity, whether or not
38: -- to reserve the amount that is available
39: -- Should be fnd_api.g_false or fnd_api.g_true
40: --
41: -- p_force_reservation_flag Whether or not to reserve without quantity
42: -- check.
43: -- Currently the api (public) will always ignore

Line 55: -- x_return_status = fnd_api.g_ret_sts_success, if succeeded

51: -- If passed as true we will query reservations
52: -- and update them else new reservations are created.
53: --
54: -- Output Parameters
55: -- x_return_status = fnd_api.g_ret_sts_success, if succeeded
56: -- = fnd_api.g_ret_sts_exc_error, if an expected
57: -- error occurred
58: -- = fnd_api.g_ret_sts_unexp_error, if
59: -- an unexpected error occurred

Line 56: -- = fnd_api.g_ret_sts_exc_error, if an expected

52: -- and update them else new reservations are created.
53: --
54: -- Output Parameters
55: -- x_return_status = fnd_api.g_ret_sts_success, if succeeded
56: -- = fnd_api.g_ret_sts_exc_error, if an expected
57: -- error occurred
58: -- = fnd_api.g_ret_sts_unexp_error, if
59: -- an unexpected error occurred
60: --

Line 58: -- = fnd_api.g_ret_sts_unexp_error, if

54: -- Output Parameters
55: -- x_return_status = fnd_api.g_ret_sts_success, if succeeded
56: -- = fnd_api.g_ret_sts_exc_error, if an expected
57: -- error occurred
58: -- = fnd_api.g_ret_sts_unexp_error, if
59: -- an unexpected error occurred
60: --
61: -- x_msg_count Number of error message in the error message
62: -- list

Line 145: -- , p_init_msg_lst => fnd_api.g_ture

141: --
142: -- inv_reservation_pub.create_reservation
143: -- (
144: -- p_api_version_number => 1.0
145: -- , p_init_msg_lst => fnd_api.g_ture
146: -- , x_return_status => l_status
147: -- , x_msg_count => l_msg_count
148: -- , x_msg_data => l_msg_data
149: -- , p_rsv_rec => l_rsv

Line 152: -- , p_partial_reservation_flag => fnd_api.g_ture

148: -- , x_msg_data => l_msg_data
149: -- , p_rsv_rec => l_rsv
150: -- , p_serial_number => l_dummy_sn
151: -- , x_serial_number => l_dummy_sn
152: -- , p_partial_reservation_flag => fnd_api.g_ture
153: -- , p_force_reservation_flag => fnd_api.g_false
154: -- , p_validation_flag => fnd_api.g_true
155: -- , x_quantity_reserved => l_qty
156: -- , x_reservation_id => l_rsv_id

Line 153: -- , p_force_reservation_flag => fnd_api.g_false

149: -- , p_rsv_rec => l_rsv
150: -- , p_serial_number => l_dummy_sn
151: -- , x_serial_number => l_dummy_sn
152: -- , p_partial_reservation_flag => fnd_api.g_ture
153: -- , p_force_reservation_flag => fnd_api.g_false
154: -- , p_validation_flag => fnd_api.g_true
155: -- , x_quantity_reserved => l_qty
156: -- , x_reservation_id => l_rsv_id
157: -- );

Line 154: -- , p_validation_flag => fnd_api.g_true

150: -- , p_serial_number => l_dummy_sn
151: -- , x_serial_number => l_dummy_sn
152: -- , p_partial_reservation_flag => fnd_api.g_ture
153: -- , p_force_reservation_flag => fnd_api.g_false
154: -- , p_validation_flag => fnd_api.g_true
155: -- , x_quantity_reserved => l_qty
156: -- , x_reservation_id => l_rsv_id
157: -- );
158:

Line 159: -- IF l_status != fnd_api.g_ret_sts_success THEN

155: -- , x_quantity_reserved => l_qty
156: -- , x_reservation_id => l_rsv_id
157: -- );
158:
159: -- IF l_status != fnd_api.g_ret_sts_success THEN
160: -- dbms_output.put_line('Quantity reserved: ' || To_char(l_qty));
161: -- ELSE
162: -- IF l_msg_count = 1 THEN
163: -- dbms_output.put_line('Error: '|| l_msg_data);

Line 176: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false

172: --
173: PROCEDURE create_reservation
174: (
175: p_api_version_number IN NUMBER
176: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
177: , x_return_status OUT NOCOPY VARCHAR2
178: , x_msg_count OUT NOCOPY NUMBER
179: , x_msg_data OUT NOCOPY VARCHAR2
180: , p_rsv_rec

Line 186: , p_partial_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false

182: , p_serial_number
183: IN inv_reservation_global.serial_number_tbl_type
184: , x_serial_number
185: OUT NOCOPY inv_reservation_global.serial_number_tbl_type
186: , p_partial_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false
187: , p_force_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false
188: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true
189: , p_over_reservation_flag IN NUMBER DEFAULT 0
190: , x_quantity_reserved OUT NOCOPY NUMBER

Line 187: , p_force_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false

183: IN inv_reservation_global.serial_number_tbl_type
184: , x_serial_number
185: OUT NOCOPY inv_reservation_global.serial_number_tbl_type
186: , p_partial_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false
187: , p_force_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false
188: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true
189: , p_over_reservation_flag IN NUMBER DEFAULT 0
190: , x_quantity_reserved OUT NOCOPY NUMBER
191: , x_reservation_id OUT NOCOPY NUMBER

Line 188: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true

184: , x_serial_number
185: OUT NOCOPY inv_reservation_global.serial_number_tbl_type
186: , p_partial_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false
187: , p_force_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false
188: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true
189: , p_over_reservation_flag IN NUMBER DEFAULT 0
190: , x_quantity_reserved OUT NOCOPY NUMBER
191: , x_reservation_id OUT NOCOPY NUMBER
192: , p_partial_rsv_exists IN BOOLEAN DEFAULT FALSE

Line 202: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false

198: -- Create_Reservation OVERLOAD to incorporate secondary quantities
199: PROCEDURE create_reservation
200: (
201: p_api_version_number IN NUMBER
202: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
203: , x_return_status OUT NOCOPY VARCHAR2
204: , x_msg_count OUT NOCOPY NUMBER
205: , x_msg_data OUT NOCOPY VARCHAR2
206: , p_rsv_rec

Line 212: , p_partial_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false

208: , p_serial_number
209: IN inv_reservation_global.serial_number_tbl_type
210: , x_serial_number
211: OUT NOCOPY inv_reservation_global.serial_number_tbl_type
212: , p_partial_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false
213: , p_force_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false
214: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true
215: , p_over_reservation_flag IN NUMBER DEFAULT 0
216: , x_quantity_reserved OUT NOCOPY NUMBER

Line 213: , p_force_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false

209: IN inv_reservation_global.serial_number_tbl_type
210: , x_serial_number
211: OUT NOCOPY inv_reservation_global.serial_number_tbl_type
212: , p_partial_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false
213: , p_force_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false
214: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true
215: , p_over_reservation_flag IN NUMBER DEFAULT 0
216: , x_quantity_reserved OUT NOCOPY NUMBER
217: , x_secondary_quantity_reserved OUT NOCOPY NUMBER

Line 214: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true

210: , x_serial_number
211: OUT NOCOPY inv_reservation_global.serial_number_tbl_type
212: , p_partial_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false
213: , p_force_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false
214: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true
215: , p_over_reservation_flag IN NUMBER DEFAULT 0
216: , x_quantity_reserved OUT NOCOPY NUMBER
217: , x_secondary_quantity_reserved OUT NOCOPY NUMBER
218: , x_reservation_id OUT NOCOPY NUMBER

Line 236: -- Should be fnd_api.g_false or fnd_api.g_true

232: -- p_api_version_number API version number (current version is 1.0)
233: --
234: -- p_init_msg_lst Whether initialize the error message list or
235: -- not.
236: -- Should be fnd_api.g_false or fnd_api.g_true
237: --
238: -- p_original_rsv_rec Contains info for identifying the existing
239: -- reservation. If reservation id is passed (not
240: -- null and not equals to fnd_api.g_miss_num),

Line 240: -- null and not equals to fnd_api.g_miss_num),

236: -- Should be fnd_api.g_false or fnd_api.g_true
237: --
238: -- p_original_rsv_rec Contains info for identifying the existing
239: -- reservation. If reservation id is passed (not
240: -- null and not equals to fnd_api.g_miss_num),
241: -- it is used to identify the existing reservation
242: -- and all other attributes in this record are
243: -- ignored. Otherwise, all attributes with values
244: -- not equals to fnd_api.g_miss_xxx are used to

Line 244: -- not equals to fnd_api.g_miss_xxx are used to

240: -- null and not equals to fnd_api.g_miss_num),
241: -- it is used to identify the existing reservation
242: -- and all other attributes in this record are
243: -- ignored. Otherwise, all attributes with values
244: -- not equals to fnd_api.g_miss_xxx are used to
245: -- identify the existing reservation.
246: --
247: -- p_to_rsv_rec Contains new values of the attributes to be
248: -- updated. If the value of an attribute of the

Line 254: -- in this record should be fnd_api.g_miss_xxx.

250: -- value of the attribute should be assigned
251: -- to the attribute in this record.
252: -- For attributes whose value are not to be
253: -- updated, the values of these attributes
254: -- in this record should be fnd_api.g_miss_xxx.
255: -- Notice that attributes of the record type
256: -- are initialized to fnd_api.g_miss_xxx.
257: -- So if you don't assign a value to an
258: -- attribute in this record, it is defaulted

Line 256: -- are initialized to fnd_api.g_miss_xxx.

252: -- For attributes whose value are not to be
253: -- updated, the values of these attributes
254: -- in this record should be fnd_api.g_miss_xxx.
255: -- Notice that attributes of the record type
256: -- are initialized to fnd_api.g_miss_xxx.
257: -- So if you don't assign a value to an
258: -- attribute in this record, it is defaulted
259: -- to fnd_api.g_miss_xxx.
260: --

Line 259: -- to fnd_api.g_miss_xxx.

255: -- Notice that attributes of the record type
256: -- are initialized to fnd_api.g_miss_xxx.
257: -- So if you don't assign a value to an
258: -- attribute in this record, it is defaulted
259: -- to fnd_api.g_miss_xxx.
260: --
261: -- p_original_serial_number Contains serial numbers reserved by
262: -- the existing reservation and to be updated.
263: -- (currently not used)

Line 270: -- Should be fnd_api.g_false or fnd_api.g_true

266: -- instead.
267: -- (currently not used)
268: -- p_partial_reservation_flag If there is not enough quantity, whether or not
269: -- to reserve the amount that is available
270: -- Should be fnd_api.g_false or fnd_api.g_true
271: --
272: --
273: -- p_validation_flag Whether or not to reserve without validation.
274: -- Currently the api (public) will always ignore

Line 281: -- x_return_status = fnd_api.g_ret_sts_success, if succeeded

277: -- p_check_availability This flag will check for availability before
278: -- updating the reservation
279: --
280: -- Output Parameters
281: -- x_return_status = fnd_api.g_ret_sts_success, if succeeded
282: -- = fnd_api.g_ret_sts_exc_error, if an expected
283: -- error occurred
284: -- = fnd_api.g_ret_sts_unexp_error, if an
285: -- unexpected error occurred

Line 282: -- = fnd_api.g_ret_sts_exc_error, if an expected

278: -- updating the reservation
279: --
280: -- Output Parameters
281: -- x_return_status = fnd_api.g_ret_sts_success, if succeeded
282: -- = fnd_api.g_ret_sts_exc_error, if an expected
283: -- error occurred
284: -- = fnd_api.g_ret_sts_unexp_error, if an
285: -- unexpected error occurred
286: --

Line 284: -- = fnd_api.g_ret_sts_unexp_error, if an

280: -- Output Parameters
281: -- x_return_status = fnd_api.g_ret_sts_success, if succeeded
282: -- = fnd_api.g_ret_sts_exc_error, if an expected
283: -- error occurred
284: -- = fnd_api.g_ret_sts_unexp_error, if an
285: -- unexpected error occurred
286: --
287: -- x_msg_count Number of error message in the error
288: -- message list

Line 303: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false

299:
300: PROCEDURE update_reservation
301: (
302: p_api_version_number IN NUMBER
303: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
304: , x_return_status OUT NOCOPY VARCHAR2
305: , x_msg_count OUT NOCOPY NUMBER
306: , x_msg_data OUT NOCOPY VARCHAR2
307: , p_original_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type

Line 311: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true

307: , p_original_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
308: , p_to_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
309: , p_original_serial_number IN inv_reservation_global.serial_number_tbl_type
310: , p_to_serial_number IN inv_reservation_global.serial_number_tbl_type
311: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true
312: , p_check_availability IN VARCHAR2 DEFAULT fnd_api.g_false
313: , p_over_reservation_flag IN NUMBER DEFAULT 0
314: );
315:

Line 312: , p_check_availability IN VARCHAR2 DEFAULT fnd_api.g_false

308: , p_to_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
309: , p_original_serial_number IN inv_reservation_global.serial_number_tbl_type
310: , p_to_serial_number IN inv_reservation_global.serial_number_tbl_type
311: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true
312: , p_check_availability IN VARCHAR2 DEFAULT fnd_api.g_false
313: , p_over_reservation_flag IN NUMBER DEFAULT 0
314: );
315:
316:

Line 330: -- Should be fnd_api.g_false or fnd_api.g_true

326: -- p_api_version_number API version number (current version is 1.0)
327: --
328: -- p_init_msg_lst Whether initialize the error message list or
329: -- not.
330: -- Should be fnd_api.g_false or fnd_api.g_true
331: --
332: -- p_original_rsv_rec Contains info for identifying the existing
333: -- reservation. If reservation id is passed (not
334: -- null and not equals to fnd_api.g_miss_num),

Line 334: -- null and not equals to fnd_api.g_miss_num),

330: -- Should be fnd_api.g_false or fnd_api.g_true
331: --
332: -- p_original_rsv_rec Contains info for identifying the existing
333: -- reservation. If reservation id is passed (not
334: -- null and not equals to fnd_api.g_miss_num),
335: -- it is used to identify the existing reservation
336: -- and all other attributes in this record are
337: -- ignored. Otherwise, all attributes with values
338: -- not equals to fnd_api.g_miss_xxx are used to

Line 338: -- not equals to fnd_api.g_miss_xxx are used to

334: -- null and not equals to fnd_api.g_miss_num),
335: -- it is used to identify the existing reservation
336: -- and all other attributes in this record are
337: -- ignored. Otherwise, all attributes with values
338: -- not equals to fnd_api.g_miss_xxx are used to
339: -- identify the existing reservation.
340: --
341: -- p_to_rsv_rec Contains new values of the attributes to be
342: -- updated. If the value of an attribute of the

Line 348: -- in this record should be fnd_api.g_miss_xxx.

344: -- value of the attribute should be assigned
345: -- to the attribute in this record.
346: -- For attributes whose value are not to be
347: -- updated, the values of these attributes
348: -- in this record should be fnd_api.g_miss_xxx.
349: -- Notice that attributes of the record type
350: -- are initialized to fnd_api.g_miss_xxx.
351: -- So if you don't assign a value to an
352: -- attribute in this record, it is defaulted

Line 350: -- are initialized to fnd_api.g_miss_xxx.

346: -- For attributes whose value are not to be
347: -- updated, the values of these attributes
348: -- in this record should be fnd_api.g_miss_xxx.
349: -- Notice that attributes of the record type
350: -- are initialized to fnd_api.g_miss_xxx.
351: -- So if you don't assign a value to an
352: -- attribute in this record, it is defaulted
353: -- to fnd_api.g_miss_xxx.
354: --

Line 353: -- to fnd_api.g_miss_xxx.

349: -- Notice that attributes of the record type
350: -- are initialized to fnd_api.g_miss_xxx.
351: -- So if you don't assign a value to an
352: -- attribute in this record, it is defaulted
353: -- to fnd_api.g_miss_xxx.
354: --
355: -- p_original_serial_number Contains serial numbers reserved by
356: -- the existing reservation and to be updated.
357: -- (currently not used)

Line 364: -- Should be fnd_api.g_false or fnd_api.g_true

360: -- instead.
361: -- (currently not used)
362: -- p_partial_reservation_flag If there is not enough quantity, whether or not
363: -- to reserve the amount that is available
364: -- Should be fnd_api.g_false or fnd_api.g_true
365: --
366: -- p_check_availability This flag will check for availability before
367: -- updating the reservation
368: --

Line 374: -- x_return_status = fnd_api.g_ret_sts_success, if succeeded

370: -- Currently the api (public) will always ignore
371: -- this flag, and always does validation.
372: --
373: -- Output Parameters
374: -- x_return_status = fnd_api.g_ret_sts_success, if succeeded
375: -- = fnd_api.g_ret_sts_exc_error, if an expected
376: -- error occurred
377: -- = fnd_api.g_ret_sts_unexp_error, if an
378: -- unexpected error occurred

Line 375: -- = fnd_api.g_ret_sts_exc_error, if an expected

371: -- this flag, and always does validation.
372: --
373: -- Output Parameters
374: -- x_return_status = fnd_api.g_ret_sts_success, if succeeded
375: -- = fnd_api.g_ret_sts_exc_error, if an expected
376: -- error occurred
377: -- = fnd_api.g_ret_sts_unexp_error, if an
378: -- unexpected error occurred
379: --

Line 377: -- = fnd_api.g_ret_sts_unexp_error, if an

373: -- Output Parameters
374: -- x_return_status = fnd_api.g_ret_sts_success, if succeeded
375: -- = fnd_api.g_ret_sts_exc_error, if an expected
376: -- error occurred
377: -- = fnd_api.g_ret_sts_unexp_error, if an
378: -- unexpected error occurred
379: --
380: -- x_msg_count Number of error message in the error
381: -- message list

Line 423: -- , p_init_msg_lst => fnd_api.g_ture

419: --
420: -- inv_reservation_pub.update_reservation
421: -- (
422: -- p_api_version_number => 1.0
423: -- , p_init_msg_lst => fnd_api.g_ture
424: -- , x_return_status => l_status
425: -- , x_msg_count => l_msg_count
426: -- , x_msg_data => l_msg_data
427: -- , x_quantity_reserved => l_quantity_reserved

Line 432: -- , p_validation_flag => fnd_api.g_true

428: -- , p_original_rsv_rec => l_rsv_old
429: -- , p_to_rsv_rec => l_rsv_new
430: -- , p_original_serial_number => l_dummy_sn -- no serial contorl
431: -- , p_to_serial_number => l_dummy_sn -- no serial control
432: -- , p_validation_flag => fnd_api.g_true
433: -- , p_partial_reservation_flag => fnd_api.g_galse
434: -- , p_check_availability => fnd_api.g_galse
435: -- );
436: --

Line 433: -- , p_partial_reservation_flag => fnd_api.g_galse

429: -- , p_to_rsv_rec => l_rsv_new
430: -- , p_original_serial_number => l_dummy_sn -- no serial contorl
431: -- , p_to_serial_number => l_dummy_sn -- no serial control
432: -- , p_validation_flag => fnd_api.g_true
433: -- , p_partial_reservation_flag => fnd_api.g_galse
434: -- , p_check_availability => fnd_api.g_galse
435: -- );
436: --
437: -- IF l_status != fnd_api.g_ret_sts_success THEN

Line 434: -- , p_check_availability => fnd_api.g_galse

430: -- , p_original_serial_number => l_dummy_sn -- no serial contorl
431: -- , p_to_serial_number => l_dummy_sn -- no serial control
432: -- , p_validation_flag => fnd_api.g_true
433: -- , p_partial_reservation_flag => fnd_api.g_galse
434: -- , p_check_availability => fnd_api.g_galse
435: -- );
436: --
437: -- IF l_status != fnd_api.g_ret_sts_success THEN
438: -- dbms_output.put_line('Update Done');

Line 437: -- IF l_status != fnd_api.g_ret_sts_success THEN

433: -- , p_partial_reservation_flag => fnd_api.g_galse
434: -- , p_check_availability => fnd_api.g_galse
435: -- );
436: --
437: -- IF l_status != fnd_api.g_ret_sts_success THEN
438: -- dbms_output.put_line('Update Done');
439: -- ELSE
440: -- IF l_msg_count = 1 THEN
441: -- dbms_output.put_line('Error: '|| l_msg_data);

Line 456: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false

452: -- Change signature to incorporate secondary_quantity_reserved
453: PROCEDURE update_reservation
454: (
455: p_api_version_number IN NUMBER
456: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
457: , x_return_status OUT NOCOPY VARCHAR2
458: , x_msg_count OUT NOCOPY NUMBER
459: , x_msg_data OUT NOCOPY VARCHAR2
460: , x_quantity_reserved OUT NOCOPY NUMBER

Line 466: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true

462: , p_original_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
463: , p_to_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
464: , p_original_serial_number IN inv_reservation_global.serial_number_tbl_type
465: , p_to_serial_number IN inv_reservation_global.serial_number_tbl_type
466: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true
467: , p_partial_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false
468: , p_check_availability IN VARCHAR2 DEFAULT fnd_api.g_false
469: , p_over_reservation_flag IN NUMBER DEFAULT 0
470: );

Line 467: , p_partial_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false

463: , p_to_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
464: , p_original_serial_number IN inv_reservation_global.serial_number_tbl_type
465: , p_to_serial_number IN inv_reservation_global.serial_number_tbl_type
466: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true
467: , p_partial_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false
468: , p_check_availability IN VARCHAR2 DEFAULT fnd_api.g_false
469: , p_over_reservation_flag IN NUMBER DEFAULT 0
470: );
471:

Line 468: , p_check_availability IN VARCHAR2 DEFAULT fnd_api.g_false

464: , p_original_serial_number IN inv_reservation_global.serial_number_tbl_type
465: , p_to_serial_number IN inv_reservation_global.serial_number_tbl_type
466: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true
467: , p_partial_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false
468: , p_check_availability IN VARCHAR2 DEFAULT fnd_api.g_false
469: , p_over_reservation_flag IN NUMBER DEFAULT 0
470: );
471:
472:

Line 486: -- not. Should be fnd_api.g_false or

482: -- Input Paramters
483: -- p_api_version_number API version number (current version is 1.0)
484: --
485: -- p_init_msg_lst Whether initialize the error message list or
486: -- not. Should be fnd_api.g_false or
487: -- fnd_api.g_true
488: --
489: -- p_rsv_rec Contains info to be used to identify the
490: -- existing reservation

Line 487: -- fnd_api.g_true

483: -- p_api_version_number API version number (current version is 1.0)
484: --
485: -- p_init_msg_lst Whether initialize the error message list or
486: -- not. Should be fnd_api.g_false or
487: -- fnd_api.g_true
488: --
489: -- p_rsv_rec Contains info to be used to identify the
490: -- existing reservation
491: --

Line 496: -- x_return_status = fnd_api.g_ret_sts_success, if succeeded

492: -- p_serial_number Contains serial numbers reserved by the
493: -- existing reservation
494: --
495: -- Output Parameters
496: -- x_return_status = fnd_api.g_ret_sts_success, if succeeded
497: -- = fnd_api.g_ret_sts_exc_error, if an expected
498: -- error occurred
499: -- = fnd_api.g_ret_sts_unexp_error, if an
500: -- unexpected error occurred

Line 497: -- = fnd_api.g_ret_sts_exc_error, if an expected

493: -- existing reservation
494: --
495: -- Output Parameters
496: -- x_return_status = fnd_api.g_ret_sts_success, if succeeded
497: -- = fnd_api.g_ret_sts_exc_error, if an expected
498: -- error occurred
499: -- = fnd_api.g_ret_sts_unexp_error, if an
500: -- unexpected error occurred
501: --

Line 499: -- = fnd_api.g_ret_sts_unexp_error, if an

495: -- Output Parameters
496: -- x_return_status = fnd_api.g_ret_sts_success, if succeeded
497: -- = fnd_api.g_ret_sts_exc_error, if an expected
498: -- error occurred
499: -- = fnd_api.g_ret_sts_unexp_error, if an
500: -- unexpected error occurred
501: --
502: -- x_msg_count Number of error message in the error message
503: -- list

Line 538: -- , p_init_msg_lst => fnd_api.g_ture

534:
535: -- inv_reservation_pub.delete_reservation
536: -- (
537: -- p_api_version_number => 1.0
538: -- , p_init_msg_lst => fnd_api.g_ture
539: -- , x_return_status => l_status
540: -- , x_msg_count => l_msg_count
541: -- , x_msg_data => l_msg_data
542: -- , p_rsv_rec => l_rsv

Line 546: -- IF l_status != fnd_api.g_ret_sts_success THEN

542: -- , p_rsv_rec => l_rsv
543: -- , p_serial_number => l_dummy_sn
544: -- );
545:
546: -- IF l_status != fnd_api.g_ret_sts_success THEN
547: -- dbms_output.put_line('reservation deleted');
548: -- ELSE
549: -- IF l_msg_count = 1 THEN
550: -- dbms_output.put_line('Error: '|| l_msg_data);

Line 563: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false

559: --
560: PROCEDURE delete_reservation
561: (
562: p_api_version_number IN NUMBER
563: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
564: , x_return_status OUT NOCOPY VARCHAR2
565: , x_msg_count OUT NOCOPY NUMBER
566: , x_msg_data OUT NOCOPY VARCHAR2
567: , p_rsv_rec

Line 581: -- not. Should be fnd_api.g_false or

577: -- Input Parameters
578: -- p_api_version_number API version number (current version is 1.0)
579: --
580: -- p_init_msg_lst Whether initialize the error message list or
581: -- not. Should be fnd_api.g_false or
582: -- fnd_api.g_true
583: --
584: -- p_rsv_rec Contains info to be used to identify the
585: -- existing reservation

Line 582: -- fnd_api.g_true

578: -- p_api_version_number API version number (current version is 1.0)
579: --
580: -- p_init_msg_lst Whether initialize the error message list or
581: -- not. Should be fnd_api.g_false or
582: -- fnd_api.g_true
583: --
584: -- p_rsv_rec Contains info to be used to identify the
585: -- existing reservation
586: --

Line 589: -- p_relieve_all = fnd_api.g_false

585: -- existing reservation
586: --
587: -- p_primary_relieved_quantity Quantity to relieve in primary uom code
588: -- this parameter is required if
589: -- p_relieve_all = fnd_api.g_false
590: --
591: -- p_relieve_all If equals to fnd_api.g_true, the api
592: -- will relieve all quantity of the reservation
593: --

Line 591: -- p_relieve_all If equals to fnd_api.g_true, the api

587: -- p_primary_relieved_quantity Quantity to relieve in primary uom code
588: -- this parameter is required if
589: -- p_relieve_all = fnd_api.g_false
590: --
591: -- p_relieve_all If equals to fnd_api.g_true, the api
592: -- will relieve all quantity of the reservation
593: --
594: -- p_original_serial_number Contains serial numbers reserved by the
595: -- existing reservation

Line 598: -- x_return_status = fnd_api.g_ret_sts_success, if succeeded

594: -- p_original_serial_number Contains serial numbers reserved by the
595: -- existing reservation
596: --
597: -- Output Parameters
598: -- x_return_status = fnd_api.g_ret_sts_success, if succeeded
599: -- = fnd_api.g_ret_sts_exc_error, if an expected
600: -- error occurred
601: -- = fnd_api.g_ret_sts_unexp_error, if an
602: -- unexpected error occurred

Line 599: -- = fnd_api.g_ret_sts_exc_error, if an expected

595: -- existing reservation
596: --
597: -- Output Parameters
598: -- x_return_status = fnd_api.g_ret_sts_success, if succeeded
599: -- = fnd_api.g_ret_sts_exc_error, if an expected
600: -- error occurred
601: -- = fnd_api.g_ret_sts_unexp_error, if an
602: -- unexpected error occurred
603: --

Line 601: -- = fnd_api.g_ret_sts_unexp_error, if an

597: -- Output Parameters
598: -- x_return_status = fnd_api.g_ret_sts_success, if succeeded
599: -- = fnd_api.g_ret_sts_exc_error, if an expected
600: -- error occurred
601: -- = fnd_api.g_ret_sts_unexp_error, if an
602: -- unexpected error occurred
603: --
604: -- x_msg_count Number of error message in the error message
605: -- list

Line 617: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false

613: -- primary uom
614: PROCEDURE relieve_reservation
615: (
616: p_api_version_number IN NUMBER
617: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
618: , x_return_status OUT NOCOPY VARCHAR2
619: , x_msg_count OUT NOCOPY NUMBER
620: , x_msg_data OUT NOCOPY VARCHAR2
621: , p_rsv_rec

Line 624: , p_relieve_all IN VARCHAR2 DEFAULT fnd_api.g_true

620: , x_msg_data OUT NOCOPY VARCHAR2
621: , p_rsv_rec
622: IN inv_reservation_global.mtl_reservation_rec_type
623: , p_primary_relieved_quantity IN NUMBER
624: , p_relieve_all IN VARCHAR2 DEFAULT fnd_api.g_true
625: , p_original_serial_number
626: IN inv_reservation_global.serial_number_tbl_type
627: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true
628: , x_primary_relieved_quantity OUT NOCOPY NUMBER

Line 627: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true

623: , p_primary_relieved_quantity IN NUMBER
624: , p_relieve_all IN VARCHAR2 DEFAULT fnd_api.g_true
625: , p_original_serial_number
626: IN inv_reservation_global.serial_number_tbl_type
627: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true
628: , x_primary_relieved_quantity OUT NOCOPY NUMBER
629: , x_primary_remain_quantity OUT NOCOPY NUMBER
630: );
631:

Line 637: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false

633: -- OVERLOAD definition - incorporates secondary quantity
634: PROCEDURE relieve_reservation
635: (
636: p_api_version_number IN NUMBER
637: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
638: , x_return_status OUT NOCOPY VARCHAR2
639: , x_msg_count OUT NOCOPY NUMBER
640: , x_msg_data OUT NOCOPY VARCHAR2
641: , p_rsv_rec

Line 645: , p_relieve_all IN VARCHAR2 DEFAULT fnd_api.g_true

641: , p_rsv_rec
642: IN inv_reservation_global.mtl_reservation_rec_type
643: , p_primary_relieved_quantity IN NUMBER
644: , p_secondary_relieved_quantity IN NUMBER
645: , p_relieve_all IN VARCHAR2 DEFAULT fnd_api.g_true
646: , p_original_serial_number
647: IN inv_reservation_global.serial_number_tbl_type
648: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true
649: , x_primary_relieved_quantity OUT NOCOPY NUMBER

Line 648: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true

644: , p_secondary_relieved_quantity IN NUMBER
645: , p_relieve_all IN VARCHAR2 DEFAULT fnd_api.g_true
646: , p_original_serial_number
647: IN inv_reservation_global.serial_number_tbl_type
648: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true
649: , x_primary_relieved_quantity OUT NOCOPY NUMBER
650: , x_secondary_relieved_quantity OUT NOCOPY NUMBER
651: , x_primary_remain_quantity OUT NOCOPY NUMBER
652: , x_secondary_remain_quantity OUT NOCOPY NUMBER

Line 685: -- not. Should be fnd_api.g_false or

681: -- Input Paramters
682: -- p_api_version_number API version number (current version is 1.0)
683: --
684: -- p_init_msg_lst Whether initialize the error message list or
685: -- not. Should be fnd_api.g_false or
686: -- fnd_api.g_true
687: --
688: -- p_original_rsv_rec Contains info for identifying the existing
689: -- reservation. If reservation id is passed

Line 686: -- fnd_api.g_true

682: -- p_api_version_number API version number (current version is 1.0)
683: --
684: -- p_init_msg_lst Whether initialize the error message list or
685: -- not. Should be fnd_api.g_false or
686: -- fnd_api.g_true
687: --
688: -- p_original_rsv_rec Contains info for identifying the existing
689: -- reservation. If reservation id is passed
690: -- (not null and not equals to fnd_api.g_miss_num)

Line 690: -- (not null and not equals to fnd_api.g_miss_num)

686: -- fnd_api.g_true
687: --
688: -- p_original_rsv_rec Contains info for identifying the existing
689: -- reservation. If reservation id is passed
690: -- (not null and not equals to fnd_api.g_miss_num)
691: -- , it is used to identify the existing
692: -- reservationand all other attributes in this
693: -- ignored. Otherwise, all attributes with values
694: -- record are not equals to fnd_api.g_miss_xxx

Line 694: -- record are not equals to fnd_api.g_miss_xxx

690: -- (not null and not equals to fnd_api.g_miss_num)
691: -- , it is used to identify the existing
692: -- reservationand all other attributes in this
693: -- ignored. Otherwise, all attributes with values
694: -- record are not equals to fnd_api.g_miss_xxx
695: -- are used to identify the existing reservation.
696: --
697: -- p_to_rsv_rec Contains new values of the attributes for the
698: -- target reservation of the transfer. If the

Line 705: -- fnd_api.g_miss_xxx.

701: -- reservation , the new value should be assigned
702: -- to the attribute in this record. For attributes
703: -- whose value are the same, the values of these
704: -- attributes in this record should be
705: -- fnd_api.g_miss_xxx.
706: -- Notice that attributes of the record type are
707: -- initialized to fnd_api.g_miss_xxx. So if you
708: -- don't assign a value to an attribute in this
709: -- record, it is defaulted to fnd_api.g_miss_xxx.

Line 707: -- initialized to fnd_api.g_miss_xxx. So if you

703: -- whose value are the same, the values of these
704: -- attributes in this record should be
705: -- fnd_api.g_miss_xxx.
706: -- Notice that attributes of the record type are
707: -- initialized to fnd_api.g_miss_xxx. So if you
708: -- don't assign a value to an attribute in this
709: -- record, it is defaulted to fnd_api.g_miss_xxx.
710: -- One important aspect: if you want to transfer
711: -- all quantity reserved, you can leave the

Line 709: -- record, it is defaulted to fnd_api.g_miss_xxx.

705: -- fnd_api.g_miss_xxx.
706: -- Notice that attributes of the record type are
707: -- initialized to fnd_api.g_miss_xxx. So if you
708: -- don't assign a value to an attribute in this
709: -- record, it is defaulted to fnd_api.g_miss_xxx.
710: -- One important aspect: if you want to transfer
711: -- all quantity reserved, you can leave the
712: -- attribute primary_reservation_quantity
713: -- and reservation_quantity as fnd_api.g_miss_xxx

Line 713: -- and reservation_quantity as fnd_api.g_miss_xxx

709: -- record, it is defaulted to fnd_api.g_miss_xxx.
710: -- One important aspect: if you want to transfer
711: -- all quantity reserved, you can leave the
712: -- attribute primary_reservation_quantity
713: -- and reservation_quantity as fnd_api.g_miss_xxx
714: -- and the api will transfer all
715: -- quantity reserved.
716: --
717: -- p_original_serial_number Contains serial numbers reserved by the

Line 729: -- x_return_status = fnd_api.g_ret_sts_success, if succeeded

725: -- Currently the api (public) will always ignore
726: -- this flag, and always does validation.
727: --
728: -- Output Parameters
729: -- x_return_status = fnd_api.g_ret_sts_success, if succeeded
730: -- = fnd_api.g_ret_sts_exc_error, if an expected
731: -- error occurred
732: -- = fnd_api.g_ret_sts_unexp_error, if an
733: -- unexpected error occurred

Line 730: -- = fnd_api.g_ret_sts_exc_error, if an expected

726: -- this flag, and always does validation.
727: --
728: -- Output Parameters
729: -- x_return_status = fnd_api.g_ret_sts_success, if succeeded
730: -- = fnd_api.g_ret_sts_exc_error, if an expected
731: -- error occurred
732: -- = fnd_api.g_ret_sts_unexp_error, if an
733: -- unexpected error occurred
734: --

Line 732: -- = fnd_api.g_ret_sts_unexp_error, if an

728: -- Output Parameters
729: -- x_return_status = fnd_api.g_ret_sts_success, if succeeded
730: -- = fnd_api.g_ret_sts_exc_error, if an expected
731: -- error occurred
732: -- = fnd_api.g_ret_sts_unexp_error, if an
733: -- unexpected error occurred
734: --
735: -- x_msg_count Number of error message in the error message
736: -- list

Line 780: -- , p_init_msg_lst => fnd_api.g_ture

776: --
777: -- inv_reservation_pub.transfer_reservation
778: -- (
779: -- p_api_version_number => 1.0
780: -- , p_init_msg_lst => fnd_api.g_ture
781: -- , x_return_status => l_status
782: -- , x_msg_count => l_msg_count
783: -- , x_msg_data => l_msg_data
784: -- , p_original_rsv_rec => l_rsv_old

Line 788: -- , p_validation_flag => fnd_api.g_true

784: -- , p_original_rsv_rec => l_rsv_old
785: -- , p_to_rsv_rec => l_rsv_new
786: -- , p_original_serial_number => l_dummy_sn -- no serial contorl
787: -- , p_to_serial_number => l_dummy_sn -- no serial control
788: -- , p_validation_flag => fnd_api.g_true
789: -- , x_reservation_id => l_new_rsv_id
790: -- );
791: --
792: -- IF l_status != fnd_api.g_ret_sts_success THEN

Line 792: -- IF l_status != fnd_api.g_ret_sts_success THEN

788: -- , p_validation_flag => fnd_api.g_true
789: -- , x_reservation_id => l_new_rsv_id
790: -- );
791: --
792: -- IF l_status != fnd_api.g_ret_sts_success THEN
793: -- dbms_output.put_line
794: -- ('the new reservation id is '|| to_char(l_new_rsv_id));
795: -- ELSE
796: -- IF l_msg_count = 1 THEN

Line 810: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false

806: --
807: PROCEDURE transfer_reservation
808: (
809: p_api_version_number IN NUMBER
810: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
811: , x_return_status OUT NOCOPY VARCHAR2
812: , x_msg_count OUT NOCOPY NUMBER
813: , x_msg_data OUT NOCOPY VARCHAR2
814: , p_is_transfer_supply IN VARCHAR2 DEFAULT fnd_api.g_true

Line 814: , p_is_transfer_supply IN VARCHAR2 DEFAULT fnd_api.g_true

810: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
811: , x_return_status OUT NOCOPY VARCHAR2
812: , x_msg_count OUT NOCOPY NUMBER
813: , x_msg_data OUT NOCOPY VARCHAR2
814: , p_is_transfer_supply IN VARCHAR2 DEFAULT fnd_api.g_true
815: , p_original_rsv_rec
816: IN inv_reservation_global.mtl_reservation_rec_type
817: , p_to_rsv_rec
818: IN inv_reservation_global.mtl_reservation_rec_type

Line 823: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true

819: , p_original_serial_number
820: IN inv_reservation_global.serial_number_tbl_type
821: , p_to_serial_number
822: IN inv_reservation_global.serial_number_tbl_type
823: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true
824: , p_over_reservation_flag IN NUMBER DEFAULT 0
825: , x_to_reservation_id OUT NOCOPY NUMBER
826: );
827:

Line 837: -- or not. Should be fnd_api.g_false or

833: -- Input Paramters
834: -- p_api_version_number API version number (current version is 1.0)
835: --
836: -- p_init_msg_lst Whether initialize the error message list
837: -- or not. Should be fnd_api.g_false or
838: -- fnd_api.g_true
839: --
840: -- p_query_input Contains info to be used to identify the
841: -- reservations.

Line 838: -- fnd_api.g_true

834: -- p_api_version_number API version number (current version is 1.0)
835: --
836: -- p_init_msg_lst Whether initialize the error message list
837: -- or not. Should be fnd_api.g_false or
838: -- fnd_api.g_true
839: --
840: -- p_query_input Contains info to be used to identify the
841: -- reservations.
842: -- p_lock_records

Line 843: -- fnd_api.g_true or fnd_api.g_false (default).

839: --
840: -- p_query_input Contains info to be used to identify the
841: -- reservations.
842: -- p_lock_records
843: -- fnd_api.g_true or fnd_api.g_false (default).
844: -- Specify whether to lock matching records
845: --
846: -- p_sort_by_req_date
847: -- Specify whether to sort the return

Line 857: -- x_return_status = fnd_api.g_ret_sts_success, if succeeded

853: -- want to query related reservations, they will
854: -- be returned in a specific order
855: --
856: -- Output Parameters
857: -- x_return_status = fnd_api.g_ret_sts_success, if succeeded
858: -- = fnd_api.g_ret_sts_exc_error, if an
859: -- expected error occurred
860: -- = fnd_api.g_ret_sts_unexp_error, if an
861: -- unexpected error occurred

Line 858: -- = fnd_api.g_ret_sts_exc_error, if an

854: -- be returned in a specific order
855: --
856: -- Output Parameters
857: -- x_return_status = fnd_api.g_ret_sts_success, if succeeded
858: -- = fnd_api.g_ret_sts_exc_error, if an
859: -- expected error occurred
860: -- = fnd_api.g_ret_sts_unexp_error, if an
861: -- unexpected error occurred
862: --

Line 860: -- = fnd_api.g_ret_sts_unexp_error, if an

856: -- Output Parameters
857: -- x_return_status = fnd_api.g_ret_sts_success, if succeeded
858: -- = fnd_api.g_ret_sts_exc_error, if an
859: -- expected error occurred
860: -- = fnd_api.g_ret_sts_unexp_error, if an
861: -- unexpected error occurred
862: --
863: -- x_msg_count Number of error message in the error message
864: -- list

Line 877: -- fnd_api.g_ret_sts_error.

873: --
874: -- x_error_code
875: -- This error code is only meaningful
876: -- if x_return_status equals
877: -- fnd_api.g_ret_sts_error.
878: -- see INVRSVGS.pls for error code definition
879: --
880: -- Example
881: -- The following code query all reservations for of item id 149 in org 207.

Line 898: -- , p_init_msg_lst => fnd_api.g_ture

894: --
895: -- inv_reservation_pub.query_reservation
896: -- (
897: -- p_api_version_number => 1.0
898: -- , p_init_msg_lst => fnd_api.g_ture
899: -- , x_return_status => l_status
900: -- , x_msg_count => l_msg_count
901: -- , x_msg_data => l_msg_data
902: -- , p_query_input => l_rsv

Line 907: -- IF l_status != fnd_api.g_ret_sts_success THEN

903: -- , x_mtl_reservation_tbl => l_rsv_array
904: -- , x_mtl_reservation_tbl_count => l_size
905: -- );
906:
907: -- IF l_status != fnd_api.g_ret_sts_success THEN
908: -- dbms_output.put_line
909: -- ('number of reservations found: '||to_char(l_size));
910: -- ELSE
911: -- IF l_msg_count = 1 THEN

Line 925: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false

921: --
922: PROCEDURE query_reservation
923: (
924: p_api_version_number IN NUMBER
925: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
926: , x_return_status OUT NOCOPY VARCHAR2
927: , x_msg_count OUT NOCOPY NUMBER
928: , x_msg_data OUT NOCOPY VARCHAR2
929: , p_query_input

Line 931: , p_lock_records IN VARCHAR2 DEFAULT fnd_api.g_false

927: , x_msg_count OUT NOCOPY NUMBER
928: , x_msg_data OUT NOCOPY VARCHAR2
929: , p_query_input
930: IN inv_reservation_global.mtl_reservation_rec_type
931: , p_lock_records IN VARCHAR2 DEFAULT fnd_api.g_false
932: , p_sort_by_req_date
933: IN NUMBER DEFAULT inv_reservation_global.g_query_no_sort
934: , p_cancel_order_mode
935: IN NUMBER DEFAULT inv_reservation_global.g_cancel_order_no

Line 967: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false

963:
964: PROCEDURE query_reservation_om_hdr_line
965: (
966: p_api_version_number IN NUMBER
967: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
968: , x_return_status OUT NOCOPY VARCHAR2
969: , x_msg_count OUT NOCOPY NUMBER
970: , x_msg_data OUT NOCOPY VARCHAR2
971: , p_query_input

Line 973: , p_lock_records IN VARCHAR2 DEFAULT fnd_api.g_false

969: , x_msg_count OUT NOCOPY NUMBER
970: , x_msg_data OUT NOCOPY VARCHAR2
971: , p_query_input
972: IN inv_reservation_global.mtl_reservation_rec_type
973: , p_lock_records IN VARCHAR2 DEFAULT fnd_api.g_false
974: , p_sort_by_req_date
975: IN NUMBER DEFAULT inv_reservation_global.g_query_no_sort
976: , p_cancel_order_mode
977: IN NUMBER DEFAULT inv_reservation_global.g_cancel_order_no