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.GME_RESERVATIONS_PVT dependencies on INV_RESERVATION_GLOBAL

Line 273: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

269: l_msg_count NUMBER;
270: l_msg_data VARCHAR2 (2000);
271: l_qty_reserved NUMBER;
272: l_reservation_id NUMBER;
273: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
274: l_in_serial_num inv_reservation_global.serial_number_tbl_type;
275: l_out_serial_num inv_reservation_global.serial_number_tbl_type;
276:
277: --Bug#4604943

Line 274: l_in_serial_num inv_reservation_global.serial_number_tbl_type;

270: l_msg_data VARCHAR2 (2000);
271: l_qty_reserved NUMBER;
272: l_reservation_id NUMBER;
273: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
274: l_in_serial_num inv_reservation_global.serial_number_tbl_type;
275: l_out_serial_num inv_reservation_global.serial_number_tbl_type;
276:
277: --Bug#4604943
278: invalid_mtl_for_rsrv EXCEPTION;

Line 275: l_out_serial_num inv_reservation_global.serial_number_tbl_type;

271: l_qty_reserved NUMBER;
272: l_reservation_id NUMBER;
273: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
274: l_in_serial_num inv_reservation_global.serial_number_tbl_type;
275: l_out_serial_num inv_reservation_global.serial_number_tbl_type;
276:
277: --Bug#4604943
278: invalid_mtl_for_rsrv EXCEPTION;
279: create_resvn_err EXCEPTION;

Line 354: inv_reservation_global.g_source_type_inv;

350: l_rsv_rec.autodetail_group_id := NULL;
351: l_rsv_rec.external_source_code := NULL;
352: l_rsv_rec.external_source_line_id := NULL;
353: l_rsv_rec.supply_source_type_id :=
354: inv_reservation_global.g_source_type_inv;
355: l_rsv_rec.supply_source_header_id := NULL;
356: l_rsv_rec.supply_source_line_id := NULL;
357: l_rsv_rec.supply_source_name := NULL;
358: l_rsv_rec.supply_source_line_detail := NULL;

Line 548: AND supply_source_type_id = inv_reservation_global.g_source_type_inv;

544: AND demand_source_type_id = gme_common_pvt.g_txn_source_type
545: AND demand_source_header_id = v_batch_id
546: AND demand_source_line_id = v_material_detail_id
547: AND staged_flag = 'Y'
548: AND supply_source_type_id = inv_reservation_global.g_source_type_inv;
549: --ORDER BY mr.requirement_date, mr.reservation_id;
550: error_dispense_mat EXCEPTION;
551: BEGIN
552: IF g_debug <= gme_debug.g_log_procedure THEN

Line 994: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

990: l_api_name CONSTANT VARCHAR2 (30) := 'delete_reservation';
991: l_return_status VARCHAR2 (1);
992: l_msg_count NUMBER;
993: l_msg_data VARCHAR2 (2000);
994: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
995: l_serial_number inv_reservation_global.serial_number_tbl_type;
996: del_resvn_error EXCEPTION;
997: BEGIN
998: IF g_debug <= gme_debug.g_log_procedure THEN

Line 995: l_serial_number inv_reservation_global.serial_number_tbl_type;

991: l_return_status VARCHAR2 (1);
992: l_msg_count NUMBER;
993: l_msg_data VARCHAR2 (2000);
994: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
995: l_serial_number inv_reservation_global.serial_number_tbl_type;
996: del_resvn_error EXCEPTION;
997: BEGIN
998: IF g_debug <= gme_debug.g_log_procedure THEN
999: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'

Line 1245: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

1241: l_msg_count NUMBER;
1242: l_prim_relieve_qty NUMBER;
1243: l_prim_remain_qty NUMBER;
1244: l_msg_data VARCHAR2 (2000);
1245: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1246: l_serial_number inv_reservation_global.serial_number_tbl_type;
1247: relieve_resvn_error EXCEPTION;
1248: BEGIN
1249: IF g_debug <= gme_debug.g_log_procedure THEN

Line 1246: l_serial_number inv_reservation_global.serial_number_tbl_type;

1242: l_prim_relieve_qty NUMBER;
1243: l_prim_remain_qty NUMBER;
1244: l_msg_data VARCHAR2 (2000);
1245: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1246: l_serial_number inv_reservation_global.serial_number_tbl_type;
1247: relieve_resvn_error EXCEPTION;
1248: BEGIN
1249: IF g_debug <= gme_debug.g_log_procedure THEN
1250: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'

Line 1337: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

1333: l_api_name CONSTANT VARCHAR2 (30) := 'update_reservation';
1334: l_return_status VARCHAR2 (1);
1335: l_msg_count NUMBER;
1336: l_msg_data VARCHAR2 (2000);
1337: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1338: l_orig_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1339: l_serial_number inv_reservation_global.serial_number_tbl_type;
1340: update_resvn_error EXCEPTION;
1341: query_resvn_error EXCEPTION;

Line 1338: l_orig_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

1334: l_return_status VARCHAR2 (1);
1335: l_msg_count NUMBER;
1336: l_msg_data VARCHAR2 (2000);
1337: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1338: l_orig_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1339: l_serial_number inv_reservation_global.serial_number_tbl_type;
1340: update_resvn_error EXCEPTION;
1341: query_resvn_error EXCEPTION;
1342: BEGIN

Line 1339: l_serial_number inv_reservation_global.serial_number_tbl_type;

1335: l_msg_count NUMBER;
1336: l_msg_data VARCHAR2 (2000);
1337: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1338: l_orig_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1339: l_serial_number inv_reservation_global.serial_number_tbl_type;
1340: update_resvn_error EXCEPTION;
1341: query_resvn_error EXCEPTION;
1342: BEGIN
1343: IF g_debug <= gme_debug.g_log_procedure THEN

Line 1432: ,x_reservation_rec OUT NOCOPY inv_reservation_global.mtl_reservation_rec_type

1428:
1429: /* Pass reservation ID to be queried */
1430: PROCEDURE query_reservation (
1431: p_reservation_id IN NUMBER
1432: ,x_reservation_rec OUT NOCOPY inv_reservation_global.mtl_reservation_rec_type
1433: ,x_return_status OUT NOCOPY VARCHAR2)
1434: IS
1435: l_api_name CONSTANT VARCHAR2 (30) := 'query_reservation';
1436: l_return_status VARCHAR2 (1);

Line 1441: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

1437: l_error_code NUMBER;
1438: l_rsv_count NUMBER;
1439: l_msg_count NUMBER;
1440: l_msg_data VARCHAR2 (2000);
1441: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1442: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
1443: l_serial_number inv_reservation_global.serial_number_tbl_type;
1444: update_resvn_error EXCEPTION;
1445: BEGIN

Line 1442: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;

1438: l_rsv_count NUMBER;
1439: l_msg_count NUMBER;
1440: l_msg_data VARCHAR2 (2000);
1441: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1442: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
1443: l_serial_number inv_reservation_global.serial_number_tbl_type;
1444: update_resvn_error EXCEPTION;
1445: BEGIN
1446: IF g_debug <= gme_debug.g_log_procedure THEN

Line 1443: l_serial_number inv_reservation_global.serial_number_tbl_type;

1439: l_msg_count NUMBER;
1440: l_msg_data VARCHAR2 (2000);
1441: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1442: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
1443: l_serial_number inv_reservation_global.serial_number_tbl_type;
1444: update_resvn_error EXCEPTION;
1445: BEGIN
1446: IF g_debug <= gme_debug.g_log_procedure THEN
1447: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'

Line 1471: ,p_sort_by_req_date => inv_reservation_global.g_query_no_sort

1467: ,x_msg_count => l_msg_count
1468: ,x_msg_data => l_msg_data
1469: ,p_query_input => l_rsv_rec
1470: ,p_lock_records => fnd_api.g_false
1471: ,p_sort_by_req_date => inv_reservation_global.g_query_no_sort
1472: ,p_cancel_order_mode => inv_reservation_global.g_cancel_order_no
1473: ,x_mtl_reservation_tbl => l_rsv_tbl
1474: ,x_mtl_reservation_tbl_count => l_rsv_count
1475: ,x_error_code => l_error_code);

Line 1472: ,p_cancel_order_mode => inv_reservation_global.g_cancel_order_no

1468: ,x_msg_data => l_msg_data
1469: ,p_query_input => l_rsv_rec
1470: ,p_lock_records => fnd_api.g_false
1471: ,p_sort_by_req_date => inv_reservation_global.g_query_no_sort
1472: ,p_cancel_order_mode => inv_reservation_global.g_cancel_order_no
1473: ,x_mtl_reservation_tbl => l_rsv_tbl
1474: ,x_mtl_reservation_tbl_count => l_rsv_count
1475: ,x_error_code => l_error_code);
1476:

Line 1842: l_reservations_tbl inv_reservation_global.mtl_reservation_tbl_type;

1838: l_api_name CONSTANT VARCHAR2 (30) := 'auto_detail_line';
1839: l_item_rec mtl_system_items_b%ROWTYPE;
1840: l_rsv_rec mtl_reservations%ROWTYPE;
1841: l_rsv_tbl gme_common_pvt.reservations_tab;
1842: l_reservations_tbl inv_reservation_global.mtl_reservation_tbl_type;
1843: l_rsv_type NUMBER;
1844: l_open_qty NUMBER :=0;
1845: l_mo_allocated_qty NUMBER := 0;
1846: -- Bug 9856765