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 INV_RESERVATION_GLOBAL

Line 11: -- Please refers to inv_reservation_global package spec for the definitions

7: -- Standard.
8: ------------------------------------------------------------------------------
9:
10: ------------------------------------------------------------------------------
11: -- Please refers to inv_reservation_global package spec for the definitions
12: -- of mtl_reservation_rec_type, mtl_reservation_rec_type and
13: -- serial_number_tbl_type
14: ------------------------------------------------------------------------------
15:

Line 82: -- l_rsv inv_reservation_global.mtl_reservation_rec_type;

78: -- supply from inventory, subinventory Stores. The item is not
79: -- under revision, lot or locator control
80: --
81: -- DECLARE
82: -- l_rsv inv_reservation_global.mtl_reservation_rec_type;
83: -- l_msg_count NUMBER;
84: -- l_msg_data VARCHAR2(240);
85: -- l_rsv_id NUMBER;
86: -- l_dummy_sn inv_reservation_global.serial_number_tbl_type;

Line 86: -- l_dummy_sn inv_reservation_global.serial_number_tbl_type;

82: -- l_rsv inv_reservation_global.mtl_reservation_rec_type;
83: -- l_msg_count NUMBER;
84: -- l_msg_data VARCHAR2(240);
85: -- l_rsv_id NUMBER;
86: -- l_dummy_sn inv_reservation_global.serial_number_tbl_type;
87: -- l_status VARCHAR2(1);
88: -- BEGIN
89: -- l_rsv.reservation_id := NULL; -- cannot know
90: -- l_rsv.requirement_date := Sysdate+30;

Line 95: -- inv_reservation_global.g_source_type_oe; -- order entry

91: -- l_rsv.organization_id := 207;
92: -- l_rsv.inventory_item_id := 149;
93:
94: -- l_rsv.demand_source_type_id :=
95: -- inv_reservation_global.g_source_type_oe; -- order entry
96:
97: -- l_rsv.demand_source_name := NULL;
98: -- l_rsv.demand_source_header_id := 1234567; -- oe order number
99: -- l_rsv.demand_source_line_id := 3; -- oe order line number

Line 111: -- inv_reservation_global.g_source_type_inv;

107: -- l_rsv.external_source_code := NULL;
108: -- l_rsv.external_source_line_id := NULL;
109:
110: -- l_rsv.supply_source_type_id :=
111: -- inv_reservation_global.g_source_type_inv;
112:
113: -- l_rsv.supply_source_header_id := NULL;
114: -- l_rsv.supply_source_line_id := NULL;
115: -- l_rsv.supply_source_name := NULL;

Line 181: IN inv_reservation_global.mtl_reservation_rec_type

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
181: IN inv_reservation_global.mtl_reservation_rec_type
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

Line 183: IN inv_reservation_global.serial_number_tbl_type

179: , x_msg_data OUT NOCOPY VARCHAR2
180: , p_rsv_rec
181: IN inv_reservation_global.mtl_reservation_rec_type
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

Line 185: OUT NOCOPY inv_reservation_global.serial_number_tbl_type

181: IN inv_reservation_global.mtl_reservation_rec_type
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

Line 207: IN inv_reservation_global.mtl_reservation_rec_type

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
207: IN inv_reservation_global.mtl_reservation_rec_type
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

Line 209: IN inv_reservation_global.serial_number_tbl_type

205: , x_msg_data OUT NOCOPY VARCHAR2
206: , p_rsv_rec
207: IN inv_reservation_global.mtl_reservation_rec_type
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

Line 211: OUT NOCOPY inv_reservation_global.serial_number_tbl_type

207: IN inv_reservation_global.mtl_reservation_rec_type
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

Line 307: , p_original_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type

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
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

Line 308: , p_to_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type

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
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

Line 309: , p_original_serial_number IN inv_reservation_global.serial_number_tbl_type

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
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

Line 310: , p_to_serial_number IN inv_reservation_global.serial_number_tbl_type

306: , x_msg_data OUT NOCOPY VARCHAR2
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: );

Line 398: -- l_rsv_old inv_reservation_global.mtl_reservation_rec_type;

394: -- the primary_reservation_quantity to 30, and requirement
395: -- date to today + 60 days.
396: --
397: -- DECLARE
398: -- l_rsv_old inv_reservation_global.mtl_reservation_rec_type;
399: -- l_rsv_new inv_reservation_global.mtl_reservation_rec_type;
400: -- l_msg_count NUMBER;
401: -- l_msg_data VARCHAR2(240);
402: -- l_rsv_id NUMBER;

Line 399: -- l_rsv_new inv_reservation_global.mtl_reservation_rec_type;

395: -- date to today + 60 days.
396: --
397: -- DECLARE
398: -- l_rsv_old inv_reservation_global.mtl_reservation_rec_type;
399: -- l_rsv_new inv_reservation_global.mtl_reservation_rec_type;
400: -- l_msg_count NUMBER;
401: -- l_msg_data VARCHAR2(240);
402: -- l_rsv_id NUMBER;
403: -- l_dummy_sn inv_reservation_global.serial_number_tbl_type;

Line 403: -- l_dummy_sn inv_reservation_global.serial_number_tbl_type;

399: -- l_rsv_new inv_reservation_global.mtl_reservation_rec_type;
400: -- l_msg_count NUMBER;
401: -- l_msg_data VARCHAR2(240);
402: -- l_rsv_id NUMBER;
403: -- l_dummy_sn inv_reservation_global.serial_number_tbl_type;
404: -- l_status VARCHAR2(1);
405: -- l_quantity_reserved NUMBER;
406: -- BEGIN
407: -- -- find the existing reservation

Line 411: -- inv_reservation_global.g_source_type_oe; -- order entry

407: -- -- find the existing reservation
408: -- l_rsv_old.organization_id := 207;
409: -- l_rsv_old.inventory_item_id := 149;
410: -- l_rsv_old.demand_source_type_id :=
411: -- inv_reservation_global.g_source_type_oe; -- order entry
412: --
413: -- l_rsv_old.demand_source_header_id := 1234567; -- oe order number
414: -- l_rsv_old.demand_source_line_id := 3; -- oe order line number
415: --

Line 462: , p_original_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type

458: , x_msg_count OUT NOCOPY NUMBER
459: , x_msg_data OUT NOCOPY VARCHAR2
460: , x_quantity_reserved OUT NOCOPY NUMBER
461: , x_secondary_quantity_reserved OUT NOCOPY NUMBER
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

Line 463: , p_to_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type

459: , x_msg_data OUT NOCOPY VARCHAR2
460: , x_quantity_reserved OUT NOCOPY NUMBER
461: , x_secondary_quantity_reserved OUT NOCOPY NUMBER
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

Line 464: , p_original_serial_number IN inv_reservation_global.serial_number_tbl_type

460: , x_quantity_reserved OUT NOCOPY NUMBER
461: , x_secondary_quantity_reserved OUT NOCOPY NUMBER
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

Line 465: , p_to_serial_number IN inv_reservation_global.serial_number_tbl_type

461: , x_secondary_quantity_reserved OUT NOCOPY NUMBER
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

Line 515: -- l_rsv inv_reservation_global.mtl_reservation_rec_type;

511: -- for demand source OE, order number 1234567 and line 3, with
512: -- supply from inventory, subinventory Stores.
513: --
514: -- DECLARE
515: -- l_rsv inv_reservation_global.mtl_reservation_rec_type;
516: -- l_msg_count NUMBER;
517: -- l_msg_data VARCHAR2(240);
518: -- l_rsv_id NUMBER;
519: -- l_dummy_sn inv_reservation_global.serial_number_tbl_type;

Line 519: -- l_dummy_sn inv_reservation_global.serial_number_tbl_type;

515: -- l_rsv inv_reservation_global.mtl_reservation_rec_type;
516: -- l_msg_count NUMBER;
517: -- l_msg_data VARCHAR2(240);
518: -- l_rsv_id NUMBER;
519: -- l_dummy_sn inv_reservation_global.serial_number_tbl_type;
520: -- l_status VARCHAR2(1);
521: -- BEGIN
522: -- l_rsv.organization_id := 207;
523: -- l_rsv.inventory_item_id := 149;

Line 526: -- inv_reservation_global.g_source_type_oe; -- order entry

522: -- l_rsv.organization_id := 207;
523: -- l_rsv.inventory_item_id := 149;
524:
525: -- l_rsv.demand_source_type_id :=
526: -- inv_reservation_global.g_source_type_oe; -- order entry
527:
528: -- l_rsv.demand_source_header_id := 1234567; -- oe order number
529: -- l_rsv.demand_source_line_id := 3; -- oe order line number
530: -- l_rsv.supply_source_type_id :=

Line 531: -- inv_reservation_global.g_source_type_inv;

527:
528: -- l_rsv.demand_source_header_id := 1234567; -- oe order number
529: -- l_rsv.demand_source_line_id := 3; -- oe order line number
530: -- l_rsv.supply_source_type_id :=
531: -- inv_reservation_global.g_source_type_inv;
532: --
533: -- l_rsv.subinventory_code := 'Stores';
534:
535: -- inv_reservation_pub.delete_reservation

Line 568: IN inv_reservation_global.mtl_reservation_rec_type

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
568: IN inv_reservation_global.mtl_reservation_rec_type
569: , p_serial_number
570: IN inv_reservation_global.serial_number_tbl_type
571: );
572: --

Line 570: IN inv_reservation_global.serial_number_tbl_type

566: , x_msg_data OUT NOCOPY VARCHAR2
567: , p_rsv_rec
568: IN inv_reservation_global.mtl_reservation_rec_type
569: , p_serial_number
570: IN inv_reservation_global.serial_number_tbl_type
571: );
572: --
573: -- Procedure
574: -- relieve_reservation

Line 622: IN inv_reservation_global.mtl_reservation_rec_type

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
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

Line 626: IN inv_reservation_global.serial_number_tbl_type

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
629: , x_primary_remain_quantity OUT NOCOPY NUMBER
630: );

Line 642: IN inv_reservation_global.mtl_reservation_rec_type

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
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

Line 647: IN inv_reservation_global.serial_number_tbl_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
650: , x_secondary_relieved_quantity OUT NOCOPY NUMBER
651: , x_primary_remain_quantity OUT NOCOPY NUMBER

Line 756: -- l_rsv_old inv_reservation_global.mtl_reservation_rec_type;

752: -- , demand_source_line_id 3. It is a partial transfer of quantity of 5
753: -- and the new subinventory is FGI
754: --
755: -- DECLARE
756: -- l_rsv_old inv_reservation_global.mtl_reservation_rec_type;
757: -- l_rsv_new inv_reservation_global.mtl_reservation_rec_type;
758: -- l_msg_count NUMBER;
759: -- l_msg_data VARCHAR2(240);
760: -- l_rsv_id NUMBER;

Line 757: -- l_rsv_new inv_reservation_global.mtl_reservation_rec_type;

753: -- and the new subinventory is FGI
754: --
755: -- DECLARE
756: -- l_rsv_old inv_reservation_global.mtl_reservation_rec_type;
757: -- l_rsv_new inv_reservation_global.mtl_reservation_rec_type;
758: -- l_msg_count NUMBER;
759: -- l_msg_data VARCHAR2(240);
760: -- l_rsv_id NUMBER;
761: -- l_dummy_sn inv_reservation_global.serial_number_tbl_type;

Line 761: -- l_dummy_sn inv_reservation_global.serial_number_tbl_type;

757: -- l_rsv_new inv_reservation_global.mtl_reservation_rec_type;
758: -- l_msg_count NUMBER;
759: -- l_msg_data VARCHAR2(240);
760: -- l_rsv_id NUMBER;
761: -- l_dummy_sn inv_reservation_global.serial_number_tbl_type;
762: -- l_status VARCHAR2(1);
763: -- BEGIN
764: -- -- find the existing reservation
765: -- l_rsv_old.organization_id := 207;

Line 768: -- inv_reservation_global.g_source_type_oe; -- order entry

764: -- -- find the existing reservation
765: -- l_rsv_old.organization_id := 207;
766: -- l_rsv_old.inventory_item_id := 149;
767: -- l_rsv_old.demand_source_type_id :=
768: -- inv_reservation_global.g_source_type_oe; -- order entry
769: --
770: -- l_rsv_old.demand_source_header_id := 1234567; -- oe order number
771: -- l_rsv_old.demand_source_line_id := 3; -- oe order line number
772: --

Line 816: IN inv_reservation_global.mtl_reservation_rec_type

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
819: , p_original_serial_number
820: IN inv_reservation_global.serial_number_tbl_type

Line 818: IN inv_reservation_global.mtl_reservation_rec_type

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
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

Line 820: IN inv_reservation_global.serial_number_tbl_type

816: IN inv_reservation_global.mtl_reservation_rec_type
817: , p_to_rsv_rec
818: IN inv_reservation_global.mtl_reservation_rec_type
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

Line 822: IN inv_reservation_global.serial_number_tbl_type

818: IN inv_reservation_global.mtl_reservation_rec_type
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: );

Line 884: -- l_rsv inv_reservation_global.mtl_reservation_rec_type;

880: -- Example
881: -- The following code query all reservations for of item id 149 in org 207.
882: --
883: -- DECLARE
884: -- l_rsv inv_reservation_global.mtl_reservation_rec_type;
885: -- l_msg_count NUMBER;
886: -- l_msg_data VARCHAR2(240);
887: -- l_rsv_id NUMBER;
888: -- l_status VARCHAR2(1);

Line 889: -- l_rsv_array inv_reservation_global.mtl_reservation_tbl_type;

885: -- l_msg_count NUMBER;
886: -- l_msg_data VARCHAR2(240);
887: -- l_rsv_id NUMBER;
888: -- l_status VARCHAR2(1);
889: -- l_rsv_array inv_reservation_global.mtl_reservation_tbl_type;
890: -- l_size NUMBER;
891: -- BEGIN
892: -- l_rsv.organization_id := 207;
893: -- l_rsv.inventory_item_id := 149;

Line 930: IN inv_reservation_global.mtl_reservation_rec_type

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
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

Line 933: IN NUMBER DEFAULT inv_reservation_global.g_query_no_sort

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
936: , x_mtl_reservation_tbl
937: OUT NOCOPY inv_reservation_global.mtl_reservation_tbl_type

Line 935: IN NUMBER DEFAULT inv_reservation_global.g_cancel_order_no

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
936: , x_mtl_reservation_tbl
937: OUT NOCOPY inv_reservation_global.mtl_reservation_tbl_type
938: , x_mtl_reservation_tbl_count OUT NOCOPY NUMBER
939: , x_error_code OUT NOCOPY NUMBER

Line 937: OUT NOCOPY inv_reservation_global.mtl_reservation_tbl_type

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
936: , x_mtl_reservation_tbl
937: OUT NOCOPY inv_reservation_global.mtl_reservation_tbl_type
938: , x_mtl_reservation_tbl_count OUT NOCOPY NUMBER
939: , x_error_code OUT NOCOPY NUMBER
940: );
941:

Line 972: IN inv_reservation_global.mtl_reservation_rec_type

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
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

Line 975: IN NUMBER DEFAULT inv_reservation_global.g_query_no_sort

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
978: , x_mtl_reservation_tbl
979: OUT NOCOPY inv_reservation_global.mtl_reservation_tbl_type

Line 977: IN NUMBER DEFAULT inv_reservation_global.g_cancel_order_no

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
978: , x_mtl_reservation_tbl
979: OUT NOCOPY inv_reservation_global.mtl_reservation_tbl_type
980: , x_mtl_reservation_tbl_count OUT NOCOPY NUMBER
981: , x_error_code OUT NOCOPY NUMBER

Line 979: OUT NOCOPY inv_reservation_global.mtl_reservation_tbl_type

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
978: , x_mtl_reservation_tbl
979: OUT NOCOPY inv_reservation_global.mtl_reservation_tbl_type
980: , x_mtl_reservation_tbl_count OUT NOCOPY NUMBER
981: , x_error_code OUT NOCOPY NUMBER
982: );
983: