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

Line 628: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

624: l_msg_count NUMBER;
625: l_msg_data VARCHAR2 (2000);
626: l_qty_reserved NUMBER;
627: l_reservation_id NUMBER;
628: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
629: l_in_serial_num inv_reservation_global.serial_number_tbl_type;
630: l_out_serial_num inv_reservation_global.serial_number_tbl_type;
631: --Bug#4604943
632: invalid_mtl_for_rsrv EXCEPTION;

Line 629: l_in_serial_num inv_reservation_global.serial_number_tbl_type;

625: l_msg_data VARCHAR2 (2000);
626: l_qty_reserved NUMBER;
627: l_reservation_id NUMBER;
628: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
629: l_in_serial_num inv_reservation_global.serial_number_tbl_type;
630: l_out_serial_num inv_reservation_global.serial_number_tbl_type;
631: --Bug#4604943
632: invalid_mtl_for_rsrv EXCEPTION;
633: create_resvn_err EXCEPTION;

Line 630: l_out_serial_num inv_reservation_global.serial_number_tbl_type;

626: l_qty_reserved NUMBER;
627: l_reservation_id NUMBER;
628: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
629: l_in_serial_num inv_reservation_global.serial_number_tbl_type;
630: l_out_serial_num inv_reservation_global.serial_number_tbl_type;
631: --Bug#4604943
632: invalid_mtl_for_rsrv EXCEPTION;
633: create_resvn_err EXCEPTION;
634: l_get_revision mtl_onhand_quantities%ROWTYPE;

Line 722: inv_reservation_global.g_source_type_inv;

718: l_rsv_rec.autodetail_group_id := NULL;
719: l_rsv_rec.external_source_code := NULL;
720: l_rsv_rec.external_source_line_id := NULL;
721: l_rsv_rec.supply_source_type_id :=
722: inv_reservation_global.g_source_type_inv;
723: l_rsv_rec.supply_source_header_id := NULL;
724: l_rsv_rec.supply_source_line_id := NULL;
725: l_rsv_rec.supply_source_name := NULL;
726: l_rsv_rec.supply_source_line_detail := NULL;

Line 882: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

878: l_api_name CONSTANT VARCHAR2 (30) := 'update_reservation';
879: l_return_status VARCHAR2 (1);
880: l_msg_count NUMBER;
881: l_msg_data VARCHAR2 (2000);
882: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
883: l_orig_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
884: l_serial_number inv_reservation_global.serial_number_tbl_type;
885: update_resvn_error EXCEPTION;
886: query_resvn_error EXCEPTION;

Line 883: l_orig_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

879: l_return_status VARCHAR2 (1);
880: l_msg_count NUMBER;
881: l_msg_data VARCHAR2 (2000);
882: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
883: l_orig_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
884: l_serial_number inv_reservation_global.serial_number_tbl_type;
885: update_resvn_error EXCEPTION;
886: query_resvn_error EXCEPTION;
887: l_get_revision mtl_onhand_quantities%ROWTYPE;

Line 884: l_serial_number inv_reservation_global.serial_number_tbl_type;

880: l_msg_count NUMBER;
881: l_msg_data VARCHAR2 (2000);
882: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
883: l_orig_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
884: l_serial_number inv_reservation_global.serial_number_tbl_type;
885: update_resvn_error EXCEPTION;
886: query_resvn_error EXCEPTION;
887: l_get_revision mtl_onhand_quantities%ROWTYPE;
888: CURSOR cur_get_revision (v_org_id NUMBER, v_inventory_item_id NUMBER,v_subinv varchar2,v_lot varchar2,v_locator number)

Line 961: ,x_reservation_rec OUT NOCOPY inv_reservation_global.mtl_reservation_rec_type

957: END update_reservation;
958:
959: PROCEDURE query_reservation (
960: p_reservation_id IN NUMBER
961: ,x_reservation_rec OUT NOCOPY inv_reservation_global.mtl_reservation_rec_type
962: ,x_return_status OUT NOCOPY VARCHAR2)
963: IS
964: l_api_name CONSTANT VARCHAR2 (30) := 'query_reservation';
965: l_return_status VARCHAR2 (1);

Line 970: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

966: l_error_code NUMBER;
967: l_rsv_count NUMBER;
968: l_msg_count NUMBER;
969: l_msg_data VARCHAR2 (2000);
970: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
971: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
972: l_serial_number inv_reservation_global.serial_number_tbl_type;
973: update_resvn_error EXCEPTION;
974: BEGIN

Line 971: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;

967: l_rsv_count NUMBER;
968: l_msg_count NUMBER;
969: l_msg_data VARCHAR2 (2000);
970: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
971: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
972: l_serial_number inv_reservation_global.serial_number_tbl_type;
973: update_resvn_error EXCEPTION;
974: BEGIN
975: /*IF g_debug <= gme_debug.g_log_procedure THEN

Line 972: l_serial_number inv_reservation_global.serial_number_tbl_type;

968: l_msg_count NUMBER;
969: l_msg_data VARCHAR2 (2000);
970: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
971: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
972: l_serial_number inv_reservation_global.serial_number_tbl_type;
973: update_resvn_error EXCEPTION;
974: BEGIN
975: /*IF g_debug <= gme_debug.g_log_procedure THEN
976: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'

Line 997: ,p_sort_by_req_date => inv_reservation_global.g_query_no_sort

993: ,x_msg_count => l_msg_count
994: ,x_msg_data => l_msg_data
995: ,p_query_input => l_rsv_rec
996: ,p_lock_records => fnd_api.g_false
997: ,p_sort_by_req_date => inv_reservation_global.g_query_no_sort
998: ,p_cancel_order_mode => inv_reservation_global.g_cancel_order_no
999: ,x_mtl_reservation_tbl => l_rsv_tbl
1000: ,x_mtl_reservation_tbl_count => l_rsv_count
1001: ,x_error_code => l_error_code);

Line 998: ,p_cancel_order_mode => inv_reservation_global.g_cancel_order_no

994: ,x_msg_data => l_msg_data
995: ,p_query_input => l_rsv_rec
996: ,p_lock_records => fnd_api.g_false
997: ,p_sort_by_req_date => inv_reservation_global.g_query_no_sort
998: ,p_cancel_order_mode => inv_reservation_global.g_cancel_order_no
999: ,x_mtl_reservation_tbl => l_rsv_tbl
1000: ,x_mtl_reservation_tbl_count => l_rsv_count
1001: ,x_error_code => l_error_code);
1002: /* IF g_debug <= gme_debug.g_log_statement THEN