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

213: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
214: , x_return_status OUT NOCOPY VARCHAR2
215: , x_msg_count OUT NOCOPY NUMBER
216: , x_msg_data OUT NOCOPY VARCHAR2
217: , p_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
218: , p_serial_number IN inv_reservation_global.serial_number_tbl_type
219: , x_serial_number OUT NOCOPY inv_reservation_global.serial_number_tbl_type
220: , p_partial_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false
221: , p_force_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false

Line 218: , p_serial_number IN inv_reservation_global.serial_number_tbl_type

214: , x_return_status OUT NOCOPY VARCHAR2
215: , x_msg_count OUT NOCOPY NUMBER
216: , x_msg_data OUT NOCOPY VARCHAR2
217: , p_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
218: , p_serial_number IN inv_reservation_global.serial_number_tbl_type
219: , x_serial_number OUT NOCOPY inv_reservation_global.serial_number_tbl_type
220: , p_partial_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false
221: , p_force_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false
222: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true

Line 219: , x_serial_number OUT NOCOPY inv_reservation_global.serial_number_tbl_type

215: , x_msg_count OUT NOCOPY NUMBER
216: , x_msg_data OUT NOCOPY VARCHAR2
217: , p_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
218: , p_serial_number IN inv_reservation_global.serial_number_tbl_type
219: , x_serial_number OUT NOCOPY inv_reservation_global.serial_number_tbl_type
220: , p_partial_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false
221: , p_force_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false
222: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true
223: , p_over_reservation_flag IN NUMBER DEFAULT 0

Line 239: -- l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;

235: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
236: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
237:
238: /**** {{ R12 Enhanced reservations code changes }}****/
239: -- l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;
240: -- l_from_rsv_rec inv_reservation_global.mtl_reservation_rec_type := p_rsv_rec;
241: -- l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
242: -- l_mtl_reservation_tbl_count NUMBER;
243: l_error_code NUMBER;

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

236: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
237:
238: /**** {{ R12 Enhanced reservations code changes }}****/
239: -- l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;
240: -- l_from_rsv_rec inv_reservation_global.mtl_reservation_rec_type := p_rsv_rec;
241: -- l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
242: -- l_mtl_reservation_tbl_count NUMBER;
243: l_error_code NUMBER;
244: -- l_rsv_updated BOOLEAN :=FALSE;

Line 241: -- l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

237:
238: /**** {{ R12 Enhanced reservations code changes }}****/
239: -- l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;
240: -- l_from_rsv_rec inv_reservation_global.mtl_reservation_rec_type := p_rsv_rec;
241: -- l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
242: -- l_mtl_reservation_tbl_count NUMBER;
243: l_error_code NUMBER;
244: -- l_rsv_updated BOOLEAN :=FALSE;
245: -- l_primary_uom_code VARCHAR2(3);

Line 632: , p_original_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type

628: , x_msg_count OUT NOCOPY NUMBER
629: , x_msg_data OUT NOCOPY VARCHAR2
630: , x_quantity_reserved OUT NOCOPY NUMBER
631: , x_secondary_quantity_reserved OUT NOCOPY NUMBER
632: , p_original_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
633: , p_to_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
634: , p_original_serial_number IN inv_reservation_global.serial_number_tbl_type
635: , p_to_serial_number IN inv_reservation_global.serial_number_tbl_type
636: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true

Line 633: , p_to_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type

629: , x_msg_data OUT NOCOPY VARCHAR2
630: , x_quantity_reserved OUT NOCOPY NUMBER
631: , x_secondary_quantity_reserved OUT NOCOPY NUMBER
632: , p_original_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
633: , p_to_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
634: , p_original_serial_number IN inv_reservation_global.serial_number_tbl_type
635: , p_to_serial_number IN inv_reservation_global.serial_number_tbl_type
636: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true
637: , p_partial_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false

Line 634: , p_original_serial_number IN inv_reservation_global.serial_number_tbl_type

630: , x_quantity_reserved OUT NOCOPY NUMBER
631: , x_secondary_quantity_reserved OUT NOCOPY NUMBER
632: , p_original_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
633: , p_to_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
634: , p_original_serial_number IN inv_reservation_global.serial_number_tbl_type
635: , p_to_serial_number IN inv_reservation_global.serial_number_tbl_type
636: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true
637: , p_partial_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false
638: , p_check_availability IN VARCHAR2 DEFAULT fnd_api.g_false

Line 635: , p_to_serial_number IN inv_reservation_global.serial_number_tbl_type

631: , x_secondary_quantity_reserved OUT NOCOPY NUMBER
632: , p_original_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
633: , p_to_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
634: , p_original_serial_number IN inv_reservation_global.serial_number_tbl_type
635: , p_to_serial_number IN inv_reservation_global.serial_number_tbl_type
636: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true
637: , p_partial_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false
638: , p_check_availability IN VARCHAR2 DEFAULT fnd_api.g_false
639: , p_over_reservation_flag IN NUMBER DEFAULT 0

Line 760: , p_original_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type

756: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
757: , x_return_status OUT NOCOPY VARCHAR2
758: , x_msg_count OUT NOCOPY NUMBER
759: , x_msg_data OUT NOCOPY VARCHAR2
760: , p_original_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
761: , p_to_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
762: , p_original_serial_number IN inv_reservation_global.serial_number_tbl_type
763: , p_to_serial_number IN inv_reservation_global.serial_number_tbl_type
764: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true

Line 761: , p_to_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type

757: , x_return_status OUT NOCOPY VARCHAR2
758: , x_msg_count OUT NOCOPY NUMBER
759: , x_msg_data OUT NOCOPY VARCHAR2
760: , p_original_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
761: , p_to_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
762: , p_original_serial_number IN inv_reservation_global.serial_number_tbl_type
763: , p_to_serial_number IN inv_reservation_global.serial_number_tbl_type
764: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true
765: , p_check_availability IN VARCHAR2 DEFAULT fnd_api.g_false

Line 762: , p_original_serial_number IN inv_reservation_global.serial_number_tbl_type

758: , x_msg_count OUT NOCOPY NUMBER
759: , x_msg_data OUT NOCOPY VARCHAR2
760: , p_original_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
761: , p_to_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
762: , p_original_serial_number IN inv_reservation_global.serial_number_tbl_type
763: , p_to_serial_number IN inv_reservation_global.serial_number_tbl_type
764: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true
765: , p_check_availability IN VARCHAR2 DEFAULT fnd_api.g_false
766: , p_over_reservation_flag IN NUMBER DEFAULT 0

Line 763: , p_to_serial_number IN inv_reservation_global.serial_number_tbl_type

759: , x_msg_data OUT NOCOPY VARCHAR2
760: , p_original_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
761: , p_to_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
762: , p_original_serial_number IN inv_reservation_global.serial_number_tbl_type
763: , p_to_serial_number IN inv_reservation_global.serial_number_tbl_type
764: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true
765: , p_check_availability IN VARCHAR2 DEFAULT fnd_api.g_false
766: , p_over_reservation_flag IN NUMBER DEFAULT 0
767: ) IS

Line 889: IN inv_reservation_global.mtl_reservation_rec_type

885: , x_return_status OUT NOCOPY VARCHAR2
886: , x_msg_count OUT NOCOPY NUMBER
887: , x_msg_data OUT NOCOPY VARCHAR2
888: , p_rsv_rec
889: IN inv_reservation_global.mtl_reservation_rec_type
890: , p_primary_relieved_quantity IN NUMBER
891: , p_relieve_all IN VARCHAR2 DEFAULT fnd_api.g_true
892: , p_original_serial_number
893: IN inv_reservation_global.serial_number_tbl_type

Line 893: IN inv_reservation_global.serial_number_tbl_type

889: IN inv_reservation_global.mtl_reservation_rec_type
890: , p_primary_relieved_quantity IN NUMBER
891: , p_relieve_all IN VARCHAR2 DEFAULT fnd_api.g_true
892: , p_original_serial_number
893: IN inv_reservation_global.serial_number_tbl_type
894: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true
895: , x_primary_relieved_quantity OUT NOCOPY NUMBER
896: , x_primary_remain_quantity OUT NOCOPY NUMBER
897: ) IS

Line 997: IN inv_reservation_global.mtl_reservation_rec_type

993: , x_return_status OUT NOCOPY VARCHAR2
994: , x_msg_count OUT NOCOPY NUMBER
995: , x_msg_data OUT NOCOPY VARCHAR2
996: , p_rsv_rec
997: IN inv_reservation_global.mtl_reservation_rec_type
998: , p_primary_relieved_quantity IN NUMBER
999: , p_secondary_relieved_quantity IN NUMBER
1000: , p_relieve_all IN VARCHAR2 DEFAULT fnd_api.g_true
1001: , p_original_serial_number

Line 1002: IN inv_reservation_global.serial_number_tbl_type

998: , p_primary_relieved_quantity IN NUMBER
999: , p_secondary_relieved_quantity IN NUMBER
1000: , p_relieve_all IN VARCHAR2 DEFAULT fnd_api.g_true
1001: , p_original_serial_number
1002: IN inv_reservation_global.serial_number_tbl_type
1003: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true
1004: , x_primary_relieved_quantity OUT NOCOPY NUMBER
1005: , x_secondary_relieved_quantity OUT NOCOPY NUMBER
1006: , x_primary_remain_quantity OUT NOCOPY NUMBER

Line 1101: IN inv_reservation_global.mtl_reservation_rec_type

1097: , x_return_status OUT NOCOPY VARCHAR2
1098: , x_msg_count OUT NOCOPY NUMBER
1099: , x_msg_data OUT NOCOPY VARCHAR2
1100: , p_rsv_rec
1101: IN inv_reservation_global.mtl_reservation_rec_type
1102: , p_serial_number
1103: IN inv_reservation_global.serial_number_tbl_type
1104: )IS
1105: l_api_version_number CONSTANT NUMBER := 1.0;

Line 1103: IN inv_reservation_global.serial_number_tbl_type

1099: , x_msg_data OUT NOCOPY VARCHAR2
1100: , p_rsv_rec
1101: IN inv_reservation_global.mtl_reservation_rec_type
1102: , p_serial_number
1103: IN inv_reservation_global.serial_number_tbl_type
1104: )IS
1105: l_api_version_number CONSTANT NUMBER := 1.0;
1106: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Reservation';
1107: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

Line 1195: IN inv_reservation_global.mtl_reservation_rec_type

1191: , x_msg_count OUT NOCOPY NUMBER
1192: , x_msg_data OUT NOCOPY VARCHAR2
1193: , p_is_transfer_supply IN VARCHAR2 DEFAULT fnd_api.g_true
1194: , p_original_rsv_rec
1195: IN inv_reservation_global.mtl_reservation_rec_type
1196: , p_to_rsv_rec
1197: IN inv_reservation_global.mtl_reservation_rec_type
1198: , p_original_serial_number
1199: IN inv_reservation_global.serial_number_tbl_type

Line 1197: IN inv_reservation_global.mtl_reservation_rec_type

1193: , p_is_transfer_supply IN VARCHAR2 DEFAULT fnd_api.g_true
1194: , p_original_rsv_rec
1195: IN inv_reservation_global.mtl_reservation_rec_type
1196: , p_to_rsv_rec
1197: IN inv_reservation_global.mtl_reservation_rec_type
1198: , p_original_serial_number
1199: IN inv_reservation_global.serial_number_tbl_type
1200: , p_to_serial_number
1201: IN inv_reservation_global.serial_number_tbl_type

Line 1199: IN inv_reservation_global.serial_number_tbl_type

1195: IN inv_reservation_global.mtl_reservation_rec_type
1196: , p_to_rsv_rec
1197: IN inv_reservation_global.mtl_reservation_rec_type
1198: , p_original_serial_number
1199: IN inv_reservation_global.serial_number_tbl_type
1200: , p_to_serial_number
1201: IN inv_reservation_global.serial_number_tbl_type
1202: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true
1203: , p_over_reservation_flag IN NUMBER DEFAULT 0

Line 1201: IN inv_reservation_global.serial_number_tbl_type

1197: IN inv_reservation_global.mtl_reservation_rec_type
1198: , p_original_serial_number
1199: IN inv_reservation_global.serial_number_tbl_type
1200: , p_to_serial_number
1201: IN inv_reservation_global.serial_number_tbl_type
1202: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true
1203: , p_over_reservation_flag IN NUMBER DEFAULT 0
1204: , x_to_reservation_id OUT NOCOPY NUMBER
1205: ) IS

Line 1327: IN inv_reservation_global.mtl_reservation_rec_type

1323: , x_return_status OUT NOCOPY VARCHAR2
1324: , x_msg_count OUT NOCOPY NUMBER
1325: , x_msg_data OUT NOCOPY VARCHAR2
1326: , p_query_input
1327: IN inv_reservation_global.mtl_reservation_rec_type
1328: , p_lock_records IN VARCHAR2 DEFAULT fnd_api.g_false
1329: , p_sort_by_req_date
1330: IN NUMBER DEFAULT inv_reservation_global.g_query_no_sort
1331: , p_cancel_order_mode

Line 1330: IN NUMBER DEFAULT inv_reservation_global.g_query_no_sort

1326: , p_query_input
1327: IN inv_reservation_global.mtl_reservation_rec_type
1328: , p_lock_records IN VARCHAR2 DEFAULT fnd_api.g_false
1329: , p_sort_by_req_date
1330: IN NUMBER DEFAULT inv_reservation_global.g_query_no_sort
1331: , p_cancel_order_mode
1332: IN NUMBER DEFAULT inv_reservation_global.g_cancel_order_no
1333: , x_mtl_reservation_tbl
1334: OUT NOCOPY inv_reservation_global.mtl_reservation_tbl_type

Line 1332: IN NUMBER DEFAULT inv_reservation_global.g_cancel_order_no

1328: , p_lock_records IN VARCHAR2 DEFAULT fnd_api.g_false
1329: , p_sort_by_req_date
1330: IN NUMBER DEFAULT inv_reservation_global.g_query_no_sort
1331: , p_cancel_order_mode
1332: IN NUMBER DEFAULT inv_reservation_global.g_cancel_order_no
1333: , x_mtl_reservation_tbl
1334: OUT NOCOPY inv_reservation_global.mtl_reservation_tbl_type
1335: , x_mtl_reservation_tbl_count OUT NOCOPY NUMBER
1336: , x_error_code OUT NOCOPY NUMBER

Line 1334: OUT NOCOPY inv_reservation_global.mtl_reservation_tbl_type

1330: IN NUMBER DEFAULT inv_reservation_global.g_query_no_sort
1331: , p_cancel_order_mode
1332: IN NUMBER DEFAULT inv_reservation_global.g_cancel_order_no
1333: , x_mtl_reservation_tbl
1334: OUT NOCOPY inv_reservation_global.mtl_reservation_tbl_type
1335: , x_mtl_reservation_tbl_count OUT NOCOPY NUMBER
1336: , x_error_code OUT NOCOPY NUMBER
1337: ) IS
1338: l_api_version_number CONSTANT NUMBER := 1.0;

Line 1342: l_query_input inv_reservation_global.mtl_reservation_rec_type

1338: l_api_version_number CONSTANT NUMBER := 1.0;
1339: l_api_name CONSTANT VARCHAR2(30) := 'Query_Reservation';
1340: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
1341: -- OPM BUG 1415345 BEGIN
1342: l_query_input inv_reservation_global.mtl_reservation_rec_type
1343: := p_query_input;
1344: -- OPM BUG 1415345 END
1345: BEGIN
1346: -- Standard call to check for call compatibility

Line 1461: IN inv_reservation_global.mtl_reservation_rec_type

1457: , x_return_status OUT NOCOPY VARCHAR2
1458: , x_msg_count OUT NOCOPY NUMBER
1459: , x_msg_data OUT NOCOPY VARCHAR2
1460: , p_query_input
1461: IN inv_reservation_global.mtl_reservation_rec_type
1462: , p_lock_records IN VARCHAR2 DEFAULT fnd_api.g_false
1463: , p_sort_by_req_date
1464: IN NUMBER DEFAULT inv_reservation_global.g_query_no_sort
1465: , p_cancel_order_mode

Line 1464: IN NUMBER DEFAULT inv_reservation_global.g_query_no_sort

1460: , p_query_input
1461: IN inv_reservation_global.mtl_reservation_rec_type
1462: , p_lock_records IN VARCHAR2 DEFAULT fnd_api.g_false
1463: , p_sort_by_req_date
1464: IN NUMBER DEFAULT inv_reservation_global.g_query_no_sort
1465: , p_cancel_order_mode
1466: IN NUMBER DEFAULT inv_reservation_global.g_cancel_order_no
1467: , x_mtl_reservation_tbl
1468: OUT NOCOPY inv_reservation_global.mtl_reservation_tbl_type

Line 1466: IN NUMBER DEFAULT inv_reservation_global.g_cancel_order_no

1462: , p_lock_records IN VARCHAR2 DEFAULT fnd_api.g_false
1463: , p_sort_by_req_date
1464: IN NUMBER DEFAULT inv_reservation_global.g_query_no_sort
1465: , p_cancel_order_mode
1466: IN NUMBER DEFAULT inv_reservation_global.g_cancel_order_no
1467: , x_mtl_reservation_tbl
1468: OUT NOCOPY inv_reservation_global.mtl_reservation_tbl_type
1469: , x_mtl_reservation_tbl_count OUT NOCOPY NUMBER
1470: , x_error_code OUT NOCOPY NUMBER

Line 1468: OUT NOCOPY inv_reservation_global.mtl_reservation_tbl_type

1464: IN NUMBER DEFAULT inv_reservation_global.g_query_no_sort
1465: , p_cancel_order_mode
1466: IN NUMBER DEFAULT inv_reservation_global.g_cancel_order_no
1467: , x_mtl_reservation_tbl
1468: OUT NOCOPY inv_reservation_global.mtl_reservation_tbl_type
1469: , x_mtl_reservation_tbl_count OUT NOCOPY NUMBER
1470: , x_error_code OUT NOCOPY NUMBER
1471: ) IS
1472: l_api_version_number CONSTANT NUMBER := 1.0;

Line 1476: l_query_input inv_reservation_global.mtl_reservation_rec_type

1472: l_api_version_number CONSTANT NUMBER := 1.0;
1473: l_api_name CONSTANT VARCHAR2(30) := 'Query_Reservation';
1474: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
1475: -- OPM BUG 1415345 BEGIN
1476: l_query_input inv_reservation_global.mtl_reservation_rec_type
1477: := p_query_input;
1478: -- OPM BUG 1415345 END
1479: BEGIN
1480: -- Standard call to check for call compatibility