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

Line 107: , p_rec_to_check IN INV_Reservation_Global.mtl_reservation_rec_type

103: g_co_code IC_TRAN_PND.CO_CODE%TYPE;
104:
105: PROCEDURE Check_Missing
106: ( p_event IN VARCHAR2
107: , p_rec_to_check IN INV_Reservation_Global.mtl_reservation_rec_type
108: , x_return_status OUT NOCOPY VARCHAR2
109: , x_msg_count OUT NOCOPY NUMBER
110: , x_msg_data OUT NOCOPY VARCHAR2
111: ) IS

Line 300: ( p_query_input IN inv_reservation_global.mtl_reservation_rec_type

296:
297: END Check_Missing;
298:
299: PROCEDURE Validation_for_Query
300: ( p_query_input IN inv_reservation_global.mtl_reservation_rec_type
301: , x_opm_um OUT NOCOPY VARCHAR2
302: , x_apps_um OUT NOCOPY VARCHAR2
303: , x_ic_item_mst_rec OUT NOCOPY GMI_Reservation_Util.ic_item_mst_rec
304: , x_return_status OUT NOCOPY VARCHAR2

Line 740: ( p_mtl_rsv_rec IN INV_Reservation_Global.mtl_reservation_rec_type

736:
737: END Create_Default_Lot;
738:
739: PROCEDURE Validation_Before_Allocate
740: ( p_mtl_rsv_rec IN INV_Reservation_Global.mtl_reservation_rec_type
741: , x_allocation_rec OUT NOCOPY GMI_Auto_Allocate_PUB.gmi_allocation_rec
742: , x_ic_item_mst_rec OUT NOCOPY GMI_Reservation_Util.ic_item_mst_rec
743: , x_orgn_code OUT NOCOPY VARCHAR2
744: , x_return_status OUT NOCOPY VARCHAR2

Line 1388: ( p_query_input IN inv_reservation_global.mtl_reservation_rec_type

1384:
1385: END Get_OPM_item_from_Apps;
1386:
1387: PROCEDURE Reallocate
1388: ( p_query_input IN inv_reservation_global.mtl_reservation_rec_type
1389: , x_allocated_trans OUT NOCOPY NUMBER
1390: , x_allocated_qty OUT NOCOPY NUMBER
1391: , x_return_status OUT NOCOPY VARCHAR2
1392: , x_msg_count OUT NOCOPY NUMBER

Line 1398: l_serial_number inv_reservation_global.serial_number_tbl_type;

1394: ) IS
1395:
1396: l_api_name CONSTANT VARCHAR2 (30) := 'Reallocate';
1397:
1398: l_serial_number inv_reservation_global.serial_number_tbl_type;
1399: l_partial_reservation_flag VARCHAR2(2) := FND_API.G_FALSE;
1400: l_quantity_reserved NUMBER(19,9);
1401: l_reservation_id NUMBER;
1402: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;

Line 1402: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;

1398: l_serial_number inv_reservation_global.serial_number_tbl_type;
1399: l_partial_reservation_flag VARCHAR2(2) := FND_API.G_FALSE;
1400: l_quantity_reserved NUMBER(19,9);
1401: l_reservation_id NUMBER;
1402: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;
1403: l_mtl_reservation_rec inv_reservation_global.mtl_reservation_rec_type;
1404: l_reservation_count NUMBER;
1405: l_error_code NUMBER;
1406:

Line 1403: l_mtl_reservation_rec inv_reservation_global.mtl_reservation_rec_type;

1399: l_partial_reservation_flag VARCHAR2(2) := FND_API.G_FALSE;
1400: l_quantity_reserved NUMBER(19,9);
1401: l_reservation_id NUMBER;
1402: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;
1403: l_mtl_reservation_rec inv_reservation_global.mtl_reservation_rec_type;
1404: l_reservation_count NUMBER;
1405: l_error_code NUMBER;
1406:
1407: l_default_lot_index BINARY_INTEGER;

Line 2286: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

2282: l_whse_code VARCHAR2(4);
2283: l_commit VARCHAR2(5) := FND_API.G_FALSE;
2284: l_validation_level VARCHAR2(4) := FND_API.G_VALID_LEVEL_FULL;
2285: l_validation_flag VARCHAR2(10) := FND_API.G_TRUE;
2286: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
2287: l_serial_number inv_reservation_global.serial_number_tbl_type;
2288: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;
2289: l_mtl_reservation_tbl_count NUMBER;
2290: l_error_code NUMBER;

Line 2287: l_serial_number inv_reservation_global.serial_number_tbl_type;

2283: l_commit VARCHAR2(5) := FND_API.G_FALSE;
2284: l_validation_level VARCHAR2(4) := FND_API.G_VALID_LEVEL_FULL;
2285: l_validation_flag VARCHAR2(10) := FND_API.G_TRUE;
2286: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
2287: l_serial_number inv_reservation_global.serial_number_tbl_type;
2288: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;
2289: l_mtl_reservation_tbl_count NUMBER;
2290: l_error_code NUMBER;
2291: l_default_lot_index NUMBER;

Line 2288: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;

2284: l_validation_level VARCHAR2(4) := FND_API.G_VALID_LEVEL_FULL;
2285: l_validation_flag VARCHAR2(10) := FND_API.G_TRUE;
2286: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
2287: l_serial_number inv_reservation_global.serial_number_tbl_type;
2288: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;
2289: l_mtl_reservation_tbl_count NUMBER;
2290: l_error_code NUMBER;
2291: l_default_lot_index NUMBER;
2292: l_original_tran_index NUMBER;

Line 2596: , p_cancel_order_mode => INV_RESERVATION_GLOBAL.G_CANCEL_ORDER_YES

2592: , x_msg_count => x_msg_count
2593: , x_msg_data => x_msg_data
2594: , p_validation_flag => l_validation_flag
2595: , p_query_input => l_rsv_rec
2596: , p_cancel_order_mode => INV_RESERVATION_GLOBAL.G_CANCEL_ORDER_YES
2597: , x_mtl_reservation_tbl => l_mtl_reservation_tbl
2598: , x_mtl_reservation_tbl_count => l_mtl_reservation_tbl_count
2599: , x_error_code => l_error_code
2600: , p_lock_records => FND_API.G_FALSE

Line 2601: , p_sort_by_req_date => INV_RESERVATION_GLOBAL.G_QUERY_NO_SORT

2597: , x_mtl_reservation_tbl => l_mtl_reservation_tbl
2598: , x_mtl_reservation_tbl_count => l_mtl_reservation_tbl_count
2599: , x_error_code => l_error_code
2600: , p_lock_records => FND_API.G_FALSE
2601: , p_sort_by_req_date => INV_RESERVATION_GLOBAL.G_QUERY_NO_SORT
2602: );
2603:
2604: /* ======================================================================================= */
2605: /* There may not be any rows, and it should be possible ! (if not auto-allocate before) */

Line 3450: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

3446: l_validation_level VARCHAR2(4) := FND_API.G_VALID_LEVEL_FULL;
3447:
3448: l_temp_tran_row ic_tran_pnd%ROWTYPE;
3449: l_original_tran_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
3450: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
3451: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;
3452: l_mtl_reservation_tbl_count NUMBER;
3453: l_error_code NUMBER;
3454:

Line 3451: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;

3447:
3448: l_temp_tran_row ic_tran_pnd%ROWTYPE;
3449: l_original_tran_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
3450: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
3451: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;
3452: l_mtl_reservation_tbl_count NUMBER;
3453: l_error_code NUMBER;
3454:
3455: ll_trans_id NUMBER;

Line 3588: , p_cancel_order_mode => INV_RESERVATION_GLOBAL.G_CANCEL_ORDER_YES

3584: , x_msg_count => x_msg_count
3585: , x_msg_data => x_msg_data
3586: , p_validation_flag => l_validation_flag
3587: , p_query_input => l_rsv_rec
3588: , p_cancel_order_mode => INV_RESERVATION_GLOBAL.G_CANCEL_ORDER_YES
3589: , x_mtl_reservation_tbl => l_mtl_reservation_tbl
3590: , x_mtl_reservation_tbl_count => l_mtl_reservation_tbl_count
3591: , x_error_code => l_error_code
3592: , p_lock_records => FND_API.G_FALSE

Line 3593: , p_sort_by_req_date => INV_RESERVATION_GLOBAL.G_QUERY_NO_SORT

3589: , x_mtl_reservation_tbl => l_mtl_reservation_tbl
3590: , x_mtl_reservation_tbl_count => l_mtl_reservation_tbl_count
3591: , x_error_code => l_error_code
3592: , p_lock_records => FND_API.G_FALSE
3593: , p_sort_by_req_date => INV_RESERVATION_GLOBAL.G_QUERY_NO_SORT
3594: );
3595:
3596: /* There may not be any rows, and it should be possible ! (if not auto-allocate before) */
3597: IF (GMI_Reservation_Util.ic_tran_rec_tbl.COUNT = 0)