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 30: , p_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type

26: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
27: , x_return_status OUT NOCOPY VARCHAR2
28: , x_msg_count OUT NOCOPY NUMBER
29: , x_msg_data OUT NOCOPY VARCHAR2
30: , p_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
31: , p_serial_number IN inv_reservation_global.serial_number_tbl_type
32: , x_serial_number OUT NOCOPY inv_reservation_global.serial_number_tbl_type
33: , p_partial_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false
34: , p_force_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false

Line 31: , p_serial_number IN inv_reservation_global.serial_number_tbl_type

27: , x_return_status OUT NOCOPY VARCHAR2
28: , x_msg_count OUT NOCOPY NUMBER
29: , x_msg_data OUT NOCOPY VARCHAR2
30: , p_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
31: , p_serial_number IN inv_reservation_global.serial_number_tbl_type
32: , x_serial_number OUT NOCOPY inv_reservation_global.serial_number_tbl_type
33: , p_partial_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false
34: , p_force_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false
35: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true

Line 32: , x_serial_number OUT NOCOPY inv_reservation_global.serial_number_tbl_type

28: , x_msg_count OUT NOCOPY NUMBER
29: , x_msg_data OUT NOCOPY VARCHAR2
30: , p_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
31: , p_serial_number IN inv_reservation_global.serial_number_tbl_type
32: , x_serial_number OUT NOCOPY inv_reservation_global.serial_number_tbl_type
33: , p_partial_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false
34: , p_force_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false
35: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true
36: , p_over_reservation_flag IN NUMBER DEFAULT 0

Line 49: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

45: l_api_name CONSTANT VARCHAR2(30) := 'Create_Reservation';
46: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
47: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
48:
49: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
50: l_progress NUMBER;
51: l_secondary_quantity_reserved NUMBER;
52:
53: BEGIN

Line 199: , p_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type

195: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
196: , x_return_status OUT NOCOPY VARCHAR2
197: , x_msg_count OUT NOCOPY NUMBER
198: , x_msg_data OUT NOCOPY VARCHAR2
199: , p_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
200: , p_serial_number IN inv_reservation_global.serial_number_tbl_type
201: , x_serial_number OUT NOCOPY inv_reservation_global.serial_number_tbl_type
202: , p_partial_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false
203: , p_force_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false

Line 200: , p_serial_number IN inv_reservation_global.serial_number_tbl_type

196: , x_return_status OUT NOCOPY VARCHAR2
197: , x_msg_count OUT NOCOPY NUMBER
198: , x_msg_data OUT NOCOPY VARCHAR2
199: , p_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
200: , p_serial_number IN inv_reservation_global.serial_number_tbl_type
201: , x_serial_number OUT NOCOPY inv_reservation_global.serial_number_tbl_type
202: , p_partial_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false
203: , p_force_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false
204: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true

Line 201: , x_serial_number OUT NOCOPY inv_reservation_global.serial_number_tbl_type

197: , x_msg_count OUT NOCOPY NUMBER
198: , x_msg_data OUT NOCOPY VARCHAR2
199: , p_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
200: , p_serial_number IN inv_reservation_global.serial_number_tbl_type
201: , x_serial_number OUT NOCOPY inv_reservation_global.serial_number_tbl_type
202: , p_partial_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false
203: , p_force_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false
204: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true
205: , p_over_reservation_flag IN NUMBER DEFAULT 0

Line 221: -- l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;

217: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
218: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
219:
220: /**** {{ R12 Enhanced reservations code changes }}****/
221: -- l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;
222: -- l_from_rsv_rec inv_reservation_global.mtl_reservation_rec_type := p_rsv_rec;
223: -- l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
224: -- l_mtl_reservation_tbl_count NUMBER;
225: l_error_code NUMBER;

Line 222: -- l_from_rsv_rec inv_reservation_global.mtl_reservation_rec_type := p_rsv_rec;

218: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
219:
220: /**** {{ R12 Enhanced reservations code changes }}****/
221: -- l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;
222: -- l_from_rsv_rec inv_reservation_global.mtl_reservation_rec_type := p_rsv_rec;
223: -- l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
224: -- l_mtl_reservation_tbl_count NUMBER;
225: l_error_code NUMBER;
226: -- l_rsv_updated BOOLEAN :=FALSE;

Line 223: -- l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

219:
220: /**** {{ R12 Enhanced reservations code changes }}****/
221: -- l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;
222: -- l_from_rsv_rec inv_reservation_global.mtl_reservation_rec_type := p_rsv_rec;
223: -- l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
224: -- l_mtl_reservation_tbl_count NUMBER;
225: l_error_code NUMBER;
226: -- l_rsv_updated BOOLEAN :=FALSE;
227: -- l_primary_uom_code VARCHAR2(3);

Line 614: , p_original_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type

610: , x_msg_count OUT NOCOPY NUMBER
611: , x_msg_data OUT NOCOPY VARCHAR2
612: , x_quantity_reserved OUT NOCOPY NUMBER
613: , x_secondary_quantity_reserved OUT NOCOPY NUMBER
614: , p_original_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
615: , p_to_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
616: , p_original_serial_number IN inv_reservation_global.serial_number_tbl_type
617: , p_to_serial_number IN inv_reservation_global.serial_number_tbl_type
618: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true

Line 615: , p_to_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type

611: , x_msg_data OUT NOCOPY VARCHAR2
612: , x_quantity_reserved OUT NOCOPY NUMBER
613: , x_secondary_quantity_reserved OUT NOCOPY NUMBER
614: , p_original_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
615: , p_to_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
616: , p_original_serial_number IN inv_reservation_global.serial_number_tbl_type
617: , p_to_serial_number IN inv_reservation_global.serial_number_tbl_type
618: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true
619: , p_partial_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false

Line 616: , p_original_serial_number IN inv_reservation_global.serial_number_tbl_type

612: , x_quantity_reserved OUT NOCOPY NUMBER
613: , x_secondary_quantity_reserved OUT NOCOPY NUMBER
614: , p_original_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
615: , p_to_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
616: , p_original_serial_number IN inv_reservation_global.serial_number_tbl_type
617: , p_to_serial_number IN inv_reservation_global.serial_number_tbl_type
618: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true
619: , p_partial_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false
620: , p_check_availability IN VARCHAR2 DEFAULT fnd_api.g_false

Line 617: , p_to_serial_number IN inv_reservation_global.serial_number_tbl_type

613: , x_secondary_quantity_reserved OUT NOCOPY NUMBER
614: , p_original_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
615: , p_to_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
616: , p_original_serial_number IN inv_reservation_global.serial_number_tbl_type
617: , p_to_serial_number IN inv_reservation_global.serial_number_tbl_type
618: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true
619: , p_partial_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false
620: , p_check_availability IN VARCHAR2 DEFAULT fnd_api.g_false
621: , p_over_reservation_flag IN NUMBER DEFAULT 0

Line 742: , p_original_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type

738: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
739: , x_return_status OUT NOCOPY VARCHAR2
740: , x_msg_count OUT NOCOPY NUMBER
741: , x_msg_data OUT NOCOPY VARCHAR2
742: , p_original_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
743: , p_to_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
744: , p_original_serial_number IN inv_reservation_global.serial_number_tbl_type
745: , p_to_serial_number IN inv_reservation_global.serial_number_tbl_type
746: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true

Line 743: , p_to_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type

739: , x_return_status OUT NOCOPY VARCHAR2
740: , x_msg_count OUT NOCOPY NUMBER
741: , x_msg_data OUT NOCOPY VARCHAR2
742: , p_original_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
743: , p_to_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
744: , p_original_serial_number IN inv_reservation_global.serial_number_tbl_type
745: , p_to_serial_number IN inv_reservation_global.serial_number_tbl_type
746: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true
747: , p_check_availability IN VARCHAR2 DEFAULT fnd_api.g_false

Line 744: , p_original_serial_number IN inv_reservation_global.serial_number_tbl_type

740: , x_msg_count OUT NOCOPY NUMBER
741: , x_msg_data OUT NOCOPY VARCHAR2
742: , p_original_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
743: , p_to_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
744: , p_original_serial_number IN inv_reservation_global.serial_number_tbl_type
745: , p_to_serial_number IN inv_reservation_global.serial_number_tbl_type
746: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true
747: , p_check_availability IN VARCHAR2 DEFAULT fnd_api.g_false
748: , p_over_reservation_flag IN NUMBER DEFAULT 0

Line 745: , p_to_serial_number IN inv_reservation_global.serial_number_tbl_type

741: , x_msg_data OUT NOCOPY VARCHAR2
742: , p_original_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
743: , p_to_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
744: , p_original_serial_number IN inv_reservation_global.serial_number_tbl_type
745: , p_to_serial_number IN inv_reservation_global.serial_number_tbl_type
746: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true
747: , p_check_availability IN VARCHAR2 DEFAULT fnd_api.g_false
748: , p_over_reservation_flag IN NUMBER DEFAULT 0
749: ) IS

Line 871: IN inv_reservation_global.mtl_reservation_rec_type

867: , x_return_status OUT NOCOPY VARCHAR2
868: , x_msg_count OUT NOCOPY NUMBER
869: , x_msg_data OUT NOCOPY VARCHAR2
870: , p_rsv_rec
871: IN inv_reservation_global.mtl_reservation_rec_type
872: , p_primary_relieved_quantity IN NUMBER
873: , p_relieve_all IN VARCHAR2 DEFAULT fnd_api.g_true
874: , p_original_serial_number
875: IN inv_reservation_global.serial_number_tbl_type

Line 875: IN inv_reservation_global.serial_number_tbl_type

871: IN inv_reservation_global.mtl_reservation_rec_type
872: , p_primary_relieved_quantity IN NUMBER
873: , p_relieve_all IN VARCHAR2 DEFAULT fnd_api.g_true
874: , p_original_serial_number
875: IN inv_reservation_global.serial_number_tbl_type
876: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true
877: , x_primary_relieved_quantity OUT NOCOPY NUMBER
878: , x_primary_remain_quantity OUT NOCOPY NUMBER
879: ) IS

Line 979: IN inv_reservation_global.mtl_reservation_rec_type

975: , x_return_status OUT NOCOPY VARCHAR2
976: , x_msg_count OUT NOCOPY NUMBER
977: , x_msg_data OUT NOCOPY VARCHAR2
978: , p_rsv_rec
979: IN inv_reservation_global.mtl_reservation_rec_type
980: , p_primary_relieved_quantity IN NUMBER
981: , p_secondary_relieved_quantity IN NUMBER
982: , p_relieve_all IN VARCHAR2 DEFAULT fnd_api.g_true
983: , p_original_serial_number

Line 984: IN inv_reservation_global.serial_number_tbl_type

980: , p_primary_relieved_quantity IN NUMBER
981: , p_secondary_relieved_quantity IN NUMBER
982: , p_relieve_all IN VARCHAR2 DEFAULT fnd_api.g_true
983: , p_original_serial_number
984: IN inv_reservation_global.serial_number_tbl_type
985: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true
986: , x_primary_relieved_quantity OUT NOCOPY NUMBER
987: , x_secondary_relieved_quantity OUT NOCOPY NUMBER
988: , x_primary_remain_quantity OUT NOCOPY NUMBER

Line 1083: IN inv_reservation_global.mtl_reservation_rec_type

1079: , x_return_status OUT NOCOPY VARCHAR2
1080: , x_msg_count OUT NOCOPY NUMBER
1081: , x_msg_data OUT NOCOPY VARCHAR2
1082: , p_rsv_rec
1083: IN inv_reservation_global.mtl_reservation_rec_type
1084: , p_serial_number
1085: IN inv_reservation_global.serial_number_tbl_type
1086: )IS
1087: l_api_version_number CONSTANT NUMBER := 1.0;

Line 1085: IN inv_reservation_global.serial_number_tbl_type

1081: , x_msg_data OUT NOCOPY VARCHAR2
1082: , p_rsv_rec
1083: IN inv_reservation_global.mtl_reservation_rec_type
1084: , p_serial_number
1085: IN inv_reservation_global.serial_number_tbl_type
1086: )IS
1087: l_api_version_number CONSTANT NUMBER := 1.0;
1088: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Reservation';
1089: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

Line 1177: IN inv_reservation_global.mtl_reservation_rec_type

1173: , x_msg_count OUT NOCOPY NUMBER
1174: , x_msg_data OUT NOCOPY VARCHAR2
1175: , p_is_transfer_supply IN VARCHAR2 DEFAULT fnd_api.g_true
1176: , p_original_rsv_rec
1177: IN inv_reservation_global.mtl_reservation_rec_type
1178: , p_to_rsv_rec
1179: IN inv_reservation_global.mtl_reservation_rec_type
1180: , p_original_serial_number
1181: IN inv_reservation_global.serial_number_tbl_type

Line 1179: IN inv_reservation_global.mtl_reservation_rec_type

1175: , p_is_transfer_supply IN VARCHAR2 DEFAULT fnd_api.g_true
1176: , p_original_rsv_rec
1177: IN inv_reservation_global.mtl_reservation_rec_type
1178: , p_to_rsv_rec
1179: IN inv_reservation_global.mtl_reservation_rec_type
1180: , p_original_serial_number
1181: IN inv_reservation_global.serial_number_tbl_type
1182: , p_to_serial_number
1183: IN inv_reservation_global.serial_number_tbl_type

Line 1181: IN inv_reservation_global.serial_number_tbl_type

1177: IN inv_reservation_global.mtl_reservation_rec_type
1178: , p_to_rsv_rec
1179: IN inv_reservation_global.mtl_reservation_rec_type
1180: , p_original_serial_number
1181: IN inv_reservation_global.serial_number_tbl_type
1182: , p_to_serial_number
1183: IN inv_reservation_global.serial_number_tbl_type
1184: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true
1185: , p_over_reservation_flag IN NUMBER DEFAULT 0

Line 1183: IN inv_reservation_global.serial_number_tbl_type

1179: IN inv_reservation_global.mtl_reservation_rec_type
1180: , p_original_serial_number
1181: IN inv_reservation_global.serial_number_tbl_type
1182: , p_to_serial_number
1183: IN inv_reservation_global.serial_number_tbl_type
1184: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true
1185: , p_over_reservation_flag IN NUMBER DEFAULT 0
1186: , x_to_reservation_id OUT NOCOPY NUMBER
1187: ) IS

Line 1309: IN inv_reservation_global.mtl_reservation_rec_type

1305: , x_return_status OUT NOCOPY VARCHAR2
1306: , x_msg_count OUT NOCOPY NUMBER
1307: , x_msg_data OUT NOCOPY VARCHAR2
1308: , p_query_input
1309: IN inv_reservation_global.mtl_reservation_rec_type
1310: , p_lock_records IN VARCHAR2 DEFAULT fnd_api.g_false
1311: , p_sort_by_req_date
1312: IN NUMBER DEFAULT inv_reservation_global.g_query_no_sort
1313: , p_cancel_order_mode

Line 1312: IN NUMBER DEFAULT inv_reservation_global.g_query_no_sort

1308: , p_query_input
1309: IN inv_reservation_global.mtl_reservation_rec_type
1310: , p_lock_records IN VARCHAR2 DEFAULT fnd_api.g_false
1311: , p_sort_by_req_date
1312: IN NUMBER DEFAULT inv_reservation_global.g_query_no_sort
1313: , p_cancel_order_mode
1314: IN NUMBER DEFAULT inv_reservation_global.g_cancel_order_no
1315: , x_mtl_reservation_tbl
1316: OUT NOCOPY inv_reservation_global.mtl_reservation_tbl_type

Line 1314: IN NUMBER DEFAULT inv_reservation_global.g_cancel_order_no

1310: , p_lock_records IN VARCHAR2 DEFAULT fnd_api.g_false
1311: , p_sort_by_req_date
1312: IN NUMBER DEFAULT inv_reservation_global.g_query_no_sort
1313: , p_cancel_order_mode
1314: IN NUMBER DEFAULT inv_reservation_global.g_cancel_order_no
1315: , x_mtl_reservation_tbl
1316: OUT NOCOPY inv_reservation_global.mtl_reservation_tbl_type
1317: , x_mtl_reservation_tbl_count OUT NOCOPY NUMBER
1318: , x_error_code OUT NOCOPY NUMBER

Line 1316: OUT NOCOPY inv_reservation_global.mtl_reservation_tbl_type

1312: IN NUMBER DEFAULT inv_reservation_global.g_query_no_sort
1313: , p_cancel_order_mode
1314: IN NUMBER DEFAULT inv_reservation_global.g_cancel_order_no
1315: , x_mtl_reservation_tbl
1316: OUT NOCOPY inv_reservation_global.mtl_reservation_tbl_type
1317: , x_mtl_reservation_tbl_count OUT NOCOPY NUMBER
1318: , x_error_code OUT NOCOPY NUMBER
1319: ) IS
1320: l_api_version_number CONSTANT NUMBER := 1.0;

Line 1324: l_query_input inv_reservation_global.mtl_reservation_rec_type

1320: l_api_version_number CONSTANT NUMBER := 1.0;
1321: l_api_name CONSTANT VARCHAR2(30) := 'Query_Reservation';
1322: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
1323: -- OPM BUG 1415345 BEGIN
1324: l_query_input inv_reservation_global.mtl_reservation_rec_type
1325: := p_query_input;
1326: -- OPM BUG 1415345 END
1327: BEGIN
1328: -- Standard call to check for call compatibility

Line 1443: IN inv_reservation_global.mtl_reservation_rec_type

1439: , x_return_status OUT NOCOPY VARCHAR2
1440: , x_msg_count OUT NOCOPY NUMBER
1441: , x_msg_data OUT NOCOPY VARCHAR2
1442: , p_query_input
1443: IN inv_reservation_global.mtl_reservation_rec_type
1444: , p_lock_records IN VARCHAR2 DEFAULT fnd_api.g_false
1445: , p_sort_by_req_date
1446: IN NUMBER DEFAULT inv_reservation_global.g_query_no_sort
1447: , p_cancel_order_mode

Line 1446: IN NUMBER DEFAULT inv_reservation_global.g_query_no_sort

1442: , p_query_input
1443: IN inv_reservation_global.mtl_reservation_rec_type
1444: , p_lock_records IN VARCHAR2 DEFAULT fnd_api.g_false
1445: , p_sort_by_req_date
1446: IN NUMBER DEFAULT inv_reservation_global.g_query_no_sort
1447: , p_cancel_order_mode
1448: IN NUMBER DEFAULT inv_reservation_global.g_cancel_order_no
1449: , x_mtl_reservation_tbl
1450: OUT NOCOPY inv_reservation_global.mtl_reservation_tbl_type

Line 1448: IN NUMBER DEFAULT inv_reservation_global.g_cancel_order_no

1444: , p_lock_records IN VARCHAR2 DEFAULT fnd_api.g_false
1445: , p_sort_by_req_date
1446: IN NUMBER DEFAULT inv_reservation_global.g_query_no_sort
1447: , p_cancel_order_mode
1448: IN NUMBER DEFAULT inv_reservation_global.g_cancel_order_no
1449: , x_mtl_reservation_tbl
1450: OUT NOCOPY inv_reservation_global.mtl_reservation_tbl_type
1451: , x_mtl_reservation_tbl_count OUT NOCOPY NUMBER
1452: , x_error_code OUT NOCOPY NUMBER

Line 1450: OUT NOCOPY inv_reservation_global.mtl_reservation_tbl_type

1446: IN NUMBER DEFAULT inv_reservation_global.g_query_no_sort
1447: , p_cancel_order_mode
1448: IN NUMBER DEFAULT inv_reservation_global.g_cancel_order_no
1449: , x_mtl_reservation_tbl
1450: OUT NOCOPY inv_reservation_global.mtl_reservation_tbl_type
1451: , x_mtl_reservation_tbl_count OUT NOCOPY NUMBER
1452: , x_error_code OUT NOCOPY NUMBER
1453: ) IS
1454: l_api_version_number CONSTANT NUMBER := 1.0;

Line 1458: l_query_input inv_reservation_global.mtl_reservation_rec_type

1454: l_api_version_number CONSTANT NUMBER := 1.0;
1455: l_api_name CONSTANT VARCHAR2(30) := 'Query_Reservation';
1456: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
1457: -- OPM BUG 1415345 BEGIN
1458: l_query_input inv_reservation_global.mtl_reservation_rec_type
1459: := p_query_input;
1460: -- OPM BUG 1415345 END
1461: BEGIN
1462: -- Standard call to check for call compatibility