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

510: l_msg_count NUMBER;
511: l_msg_data VARCHAR2 (2000);
512: l_qty_reserved NUMBER;
513: l_reservation_id NUMBER;
514: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
515: l_in_serial_num inv_reservation_global.serial_number_tbl_type;
516: l_out_serial_num inv_reservation_global.serial_number_tbl_type;
517: --Bug#4604943
518: invalid_mtl_for_rsrv EXCEPTION;

Line 515: l_in_serial_num inv_reservation_global.serial_number_tbl_type;

511: l_msg_data VARCHAR2 (2000);
512: l_qty_reserved NUMBER;
513: l_reservation_id NUMBER;
514: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
515: l_in_serial_num inv_reservation_global.serial_number_tbl_type;
516: l_out_serial_num inv_reservation_global.serial_number_tbl_type;
517: --Bug#4604943
518: invalid_mtl_for_rsrv EXCEPTION;
519: create_resvn_err EXCEPTION;

Line 516: l_out_serial_num inv_reservation_global.serial_number_tbl_type;

512: l_qty_reserved NUMBER;
513: l_reservation_id NUMBER;
514: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
515: l_in_serial_num inv_reservation_global.serial_number_tbl_type;
516: l_out_serial_num inv_reservation_global.serial_number_tbl_type;
517: --Bug#4604943
518: invalid_mtl_for_rsrv EXCEPTION;
519: create_resvn_err EXCEPTION;
520: l_get_revision mtl_onhand_quantities%ROWTYPE;

Line 608: inv_reservation_global.g_source_type_inv;

604: l_rsv_rec.autodetail_group_id := NULL;
605: l_rsv_rec.external_source_code := NULL;
606: l_rsv_rec.external_source_line_id := NULL;
607: l_rsv_rec.supply_source_type_id :=
608: inv_reservation_global.g_source_type_inv;
609: l_rsv_rec.supply_source_header_id := NULL;
610: l_rsv_rec.supply_source_line_id := NULL;
611: l_rsv_rec.supply_source_name := NULL;
612: l_rsv_rec.supply_source_line_detail := NULL;

Line 766: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

762: l_api_name CONSTANT VARCHAR2 (30) := 'update_reservation';
763: l_return_status VARCHAR2 (1);
764: l_msg_count NUMBER;
765: l_msg_data VARCHAR2 (2000);
766: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
767: l_orig_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
768: l_serial_number inv_reservation_global.serial_number_tbl_type;
769: update_resvn_error EXCEPTION;
770: query_resvn_error EXCEPTION;

Line 767: l_orig_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

763: l_return_status VARCHAR2 (1);
764: l_msg_count NUMBER;
765: l_msg_data VARCHAR2 (2000);
766: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
767: l_orig_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
768: l_serial_number inv_reservation_global.serial_number_tbl_type;
769: update_resvn_error EXCEPTION;
770: query_resvn_error EXCEPTION;
771: l_get_revision mtl_onhand_quantities%ROWTYPE;

Line 768: l_serial_number inv_reservation_global.serial_number_tbl_type;

764: l_msg_count NUMBER;
765: l_msg_data VARCHAR2 (2000);
766: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
767: l_orig_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
768: l_serial_number inv_reservation_global.serial_number_tbl_type;
769: update_resvn_error EXCEPTION;
770: query_resvn_error EXCEPTION;
771: l_get_revision mtl_onhand_quantities%ROWTYPE;
772: CURSOR cur_get_revision (v_org_id NUMBER, v_inventory_item_id NUMBER,v_subinv varchar2,v_lot varchar2,v_locator number)

Line 869: ,x_reservation_rec OUT NOCOPY inv_reservation_global.mtl_reservation_rec_type

865: END update_reservation;
866:
867: PROCEDURE query_reservation (
868: p_reservation_id IN NUMBER
869: ,x_reservation_rec OUT NOCOPY inv_reservation_global.mtl_reservation_rec_type
870: ,x_return_status OUT NOCOPY VARCHAR2)
871: IS
872: l_api_name CONSTANT VARCHAR2 (30) := 'query_reservation';
873: l_return_status VARCHAR2 (1);

Line 878: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

874: l_error_code NUMBER;
875: l_rsv_count NUMBER;
876: l_msg_count NUMBER;
877: l_msg_data VARCHAR2 (2000);
878: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
879: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
880: l_serial_number inv_reservation_global.serial_number_tbl_type;
881: update_resvn_error EXCEPTION;
882: BEGIN

Line 879: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;

875: l_rsv_count NUMBER;
876: l_msg_count NUMBER;
877: l_msg_data VARCHAR2 (2000);
878: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
879: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
880: l_serial_number inv_reservation_global.serial_number_tbl_type;
881: update_resvn_error EXCEPTION;
882: BEGIN
883: /*IF g_debug <= gme_debug.g_log_procedure THEN

Line 880: l_serial_number inv_reservation_global.serial_number_tbl_type;

876: l_msg_count NUMBER;
877: l_msg_data VARCHAR2 (2000);
878: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
879: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
880: l_serial_number inv_reservation_global.serial_number_tbl_type;
881: update_resvn_error EXCEPTION;
882: BEGIN
883: /*IF g_debug <= gme_debug.g_log_procedure THEN
884: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'

Line 905: ,p_sort_by_req_date => inv_reservation_global.g_query_no_sort

901: ,x_msg_count => l_msg_count
902: ,x_msg_data => l_msg_data
903: ,p_query_input => l_rsv_rec
904: ,p_lock_records => fnd_api.g_false
905: ,p_sort_by_req_date => inv_reservation_global.g_query_no_sort
906: ,p_cancel_order_mode => inv_reservation_global.g_cancel_order_no
907: ,x_mtl_reservation_tbl => l_rsv_tbl
908: ,x_mtl_reservation_tbl_count => l_rsv_count
909: ,x_error_code => l_error_code);

Line 906: ,p_cancel_order_mode => inv_reservation_global.g_cancel_order_no

902: ,x_msg_data => l_msg_data
903: ,p_query_input => l_rsv_rec
904: ,p_lock_records => fnd_api.g_false
905: ,p_sort_by_req_date => inv_reservation_global.g_query_no_sort
906: ,p_cancel_order_mode => inv_reservation_global.g_cancel_order_no
907: ,x_mtl_reservation_tbl => l_rsv_tbl
908: ,x_mtl_reservation_tbl_count => l_rsv_count
909: ,x_error_code => l_error_code);
910: /* IF g_debug <= gme_debug.g_log_statement THEN