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 213: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

209: l_msg_count NUMBER;
210: l_msg_data VARCHAR2 (2000);
211: l_qty_reserved NUMBER;
212: l_reservation_id NUMBER;
213: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
214: l_in_serial_num inv_reservation_global.serial_number_tbl_type;
215: l_out_serial_num inv_reservation_global.serial_number_tbl_type;
216:
217: --Bug#4604943

Line 214: l_in_serial_num inv_reservation_global.serial_number_tbl_type;

210: l_msg_data VARCHAR2 (2000);
211: l_qty_reserved NUMBER;
212: l_reservation_id NUMBER;
213: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
214: l_in_serial_num inv_reservation_global.serial_number_tbl_type;
215: l_out_serial_num inv_reservation_global.serial_number_tbl_type;
216:
217: --Bug#4604943
218: invalid_mtl_for_rsrv EXCEPTION;

Line 215: l_out_serial_num inv_reservation_global.serial_number_tbl_type;

211: l_qty_reserved NUMBER;
212: l_reservation_id NUMBER;
213: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
214: l_in_serial_num inv_reservation_global.serial_number_tbl_type;
215: l_out_serial_num inv_reservation_global.serial_number_tbl_type;
216:
217: --Bug#4604943
218: invalid_mtl_for_rsrv EXCEPTION;
219: create_resvn_err EXCEPTION;

Line 291: inv_reservation_global.g_source_type_inv;

287: l_rsv_rec.autodetail_group_id := NULL;
288: l_rsv_rec.external_source_code := NULL;
289: l_rsv_rec.external_source_line_id := NULL;
290: l_rsv_rec.supply_source_type_id :=
291: inv_reservation_global.g_source_type_inv;
292: l_rsv_rec.supply_source_header_id := NULL;
293: l_rsv_rec.supply_source_line_id := NULL;
294: l_rsv_rec.supply_source_name := NULL;
295: l_rsv_rec.supply_source_line_detail := NULL;

Line 714: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

710: l_api_name CONSTANT VARCHAR2 (30) := 'delete_reservation';
711: l_return_status VARCHAR2 (1);
712: l_msg_count NUMBER;
713: l_msg_data VARCHAR2 (2000);
714: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
715: l_serial_number inv_reservation_global.serial_number_tbl_type;
716: del_resvn_error EXCEPTION;
717: BEGIN
718: IF g_debug <= gme_debug.g_log_procedure THEN

Line 715: l_serial_number inv_reservation_global.serial_number_tbl_type;

711: l_return_status VARCHAR2 (1);
712: l_msg_count NUMBER;
713: l_msg_data VARCHAR2 (2000);
714: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
715: l_serial_number inv_reservation_global.serial_number_tbl_type;
716: del_resvn_error EXCEPTION;
717: BEGIN
718: IF g_debug <= gme_debug.g_log_procedure THEN
719: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'

Line 952: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

948: l_msg_count NUMBER;
949: l_prim_relieve_qty NUMBER;
950: l_prim_remain_qty NUMBER;
951: l_msg_data VARCHAR2 (2000);
952: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
953: l_serial_number inv_reservation_global.serial_number_tbl_type;
954: relieve_resvn_error EXCEPTION;
955: BEGIN
956: IF g_debug <= gme_debug.g_log_procedure THEN

Line 953: l_serial_number inv_reservation_global.serial_number_tbl_type;

949: l_prim_relieve_qty NUMBER;
950: l_prim_remain_qty NUMBER;
951: l_msg_data VARCHAR2 (2000);
952: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
953: l_serial_number inv_reservation_global.serial_number_tbl_type;
954: relieve_resvn_error EXCEPTION;
955: BEGIN
956: IF g_debug <= gme_debug.g_log_procedure THEN
957: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'

Line 1044: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

1040: l_api_name CONSTANT VARCHAR2 (30) := 'update_reservation';
1041: l_return_status VARCHAR2 (1);
1042: l_msg_count NUMBER;
1043: l_msg_data VARCHAR2 (2000);
1044: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1045: l_orig_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1046: l_serial_number inv_reservation_global.serial_number_tbl_type;
1047: update_resvn_error EXCEPTION;
1048: query_resvn_error EXCEPTION;

Line 1045: l_orig_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

1041: l_return_status VARCHAR2 (1);
1042: l_msg_count NUMBER;
1043: l_msg_data VARCHAR2 (2000);
1044: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1045: l_orig_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1046: l_serial_number inv_reservation_global.serial_number_tbl_type;
1047: update_resvn_error EXCEPTION;
1048: query_resvn_error EXCEPTION;
1049: BEGIN

Line 1046: l_serial_number inv_reservation_global.serial_number_tbl_type;

1042: l_msg_count NUMBER;
1043: l_msg_data VARCHAR2 (2000);
1044: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1045: l_orig_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1046: l_serial_number inv_reservation_global.serial_number_tbl_type;
1047: update_resvn_error EXCEPTION;
1048: query_resvn_error EXCEPTION;
1049: BEGIN
1050: IF g_debug <= gme_debug.g_log_procedure THEN

Line 1139: ,x_reservation_rec OUT NOCOPY inv_reservation_global.mtl_reservation_rec_type

1135:
1136: /* Pass reservation ID to be queried */
1137: PROCEDURE query_reservation (
1138: p_reservation_id IN NUMBER
1139: ,x_reservation_rec OUT NOCOPY inv_reservation_global.mtl_reservation_rec_type
1140: ,x_return_status OUT NOCOPY VARCHAR2)
1141: IS
1142: l_api_name CONSTANT VARCHAR2 (30) := 'query_reservation';
1143: l_return_status VARCHAR2 (1);

Line 1148: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

1144: l_error_code NUMBER;
1145: l_rsv_count NUMBER;
1146: l_msg_count NUMBER;
1147: l_msg_data VARCHAR2 (2000);
1148: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1149: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
1150: l_serial_number inv_reservation_global.serial_number_tbl_type;
1151: update_resvn_error EXCEPTION;
1152: BEGIN

Line 1149: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;

1145: l_rsv_count NUMBER;
1146: l_msg_count NUMBER;
1147: l_msg_data VARCHAR2 (2000);
1148: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1149: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
1150: l_serial_number inv_reservation_global.serial_number_tbl_type;
1151: update_resvn_error EXCEPTION;
1152: BEGIN
1153: IF g_debug <= gme_debug.g_log_procedure THEN

Line 1150: l_serial_number inv_reservation_global.serial_number_tbl_type;

1146: l_msg_count NUMBER;
1147: l_msg_data VARCHAR2 (2000);
1148: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1149: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
1150: l_serial_number inv_reservation_global.serial_number_tbl_type;
1151: update_resvn_error EXCEPTION;
1152: BEGIN
1153: IF g_debug <= gme_debug.g_log_procedure THEN
1154: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'

Line 1178: ,p_sort_by_req_date => inv_reservation_global.g_query_no_sort

1174: ,x_msg_count => l_msg_count
1175: ,x_msg_data => l_msg_data
1176: ,p_query_input => l_rsv_rec
1177: ,p_lock_records => fnd_api.g_false
1178: ,p_sort_by_req_date => inv_reservation_global.g_query_no_sort
1179: ,p_cancel_order_mode => inv_reservation_global.g_cancel_order_no
1180: ,x_mtl_reservation_tbl => l_rsv_tbl
1181: ,x_mtl_reservation_tbl_count => l_rsv_count
1182: ,x_error_code => l_error_code);

Line 1179: ,p_cancel_order_mode => inv_reservation_global.g_cancel_order_no

1175: ,x_msg_data => l_msg_data
1176: ,p_query_input => l_rsv_rec
1177: ,p_lock_records => fnd_api.g_false
1178: ,p_sort_by_req_date => inv_reservation_global.g_query_no_sort
1179: ,p_cancel_order_mode => inv_reservation_global.g_cancel_order_no
1180: ,x_mtl_reservation_tbl => l_rsv_tbl
1181: ,x_mtl_reservation_tbl_count => l_rsv_count
1182: ,x_error_code => l_error_code);
1183:

Line 1542: l_reservations_tbl inv_reservation_global.mtl_reservation_tbl_type;

1538: l_api_name CONSTANT VARCHAR2 (30) := 'auto_detail_line';
1539: l_item_rec mtl_system_items_b%ROWTYPE;
1540: l_rsv_rec mtl_reservations%ROWTYPE;
1541: l_rsv_tbl gme_common_pvt.reservations_tab;
1542: l_reservations_tbl inv_reservation_global.mtl_reservation_tbl_type;
1543: l_rsv_type NUMBER;
1544: l_open_qty NUMBER;
1545: l_msg_count NUMBER;
1546: l_msg_data VARCHAR2 (2000);