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 103: , p_rec_to_check IN INV_Reservation_Global.mtl_reservation_rec_type

99: g_co_code IC_TRAN_PND.CO_CODE%TYPE;
100:
101: PROCEDURE Check_Missing
102: ( p_event IN VARCHAR2
103: , p_rec_to_check IN INV_Reservation_Global.mtl_reservation_rec_type
104: , x_return_status OUT NOCOPY VARCHAR2
105: , x_msg_count OUT NOCOPY NUMBER
106: , x_msg_data OUT NOCOPY VARCHAR2
107: ) IS

Line 296: ( p_query_input IN inv_reservation_global.mtl_reservation_rec_type

292:
293: END Check_Missing;
294:
295: PROCEDURE Validation_for_Query
296: ( p_query_input IN inv_reservation_global.mtl_reservation_rec_type
297: , x_opm_um OUT NOCOPY VARCHAR2
298: , x_apps_um OUT NOCOPY VARCHAR2
299: , x_ic_item_mst_rec OUT NOCOPY GMI_Reservation_Util.ic_item_mst_rec
300: , x_return_status OUT NOCOPY VARCHAR2

Line 736: ( p_mtl_rsv_rec IN INV_Reservation_Global.mtl_reservation_rec_type

732:
733: END Create_Default_Lot;
734:
735: PROCEDURE Validation_Before_Allocate
736: ( p_mtl_rsv_rec IN INV_Reservation_Global.mtl_reservation_rec_type
737: , x_allocation_rec OUT NOCOPY GMI_Auto_Allocate_PUB.gmi_allocation_rec
738: , x_ic_item_mst_rec OUT NOCOPY GMI_Reservation_Util.ic_item_mst_rec
739: , x_orgn_code OUT NOCOPY VARCHAR2
740: , x_return_status OUT NOCOPY VARCHAR2

Line 1384: ( p_query_input IN inv_reservation_global.mtl_reservation_rec_type

1380:
1381: END Get_OPM_item_from_Apps;
1382:
1383: PROCEDURE Reallocate
1384: ( p_query_input IN inv_reservation_global.mtl_reservation_rec_type
1385: , x_allocated_trans OUT NOCOPY NUMBER
1386: , x_allocated_qty OUT NOCOPY NUMBER
1387: , x_return_status OUT NOCOPY VARCHAR2
1388: , x_msg_count OUT NOCOPY NUMBER

Line 1394: l_serial_number inv_reservation_global.serial_number_tbl_type;

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

Line 1398: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;

1394: l_serial_number inv_reservation_global.serial_number_tbl_type;
1395: l_partial_reservation_flag VARCHAR2(2) := FND_API.G_FALSE;
1396: l_quantity_reserved NUMBER(19,9);
1397: l_reservation_id NUMBER;
1398: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;
1399: l_mtl_reservation_rec inv_reservation_global.mtl_reservation_rec_type;
1400: l_reservation_count NUMBER;
1401: l_error_code NUMBER;
1402:

Line 1399: l_mtl_reservation_rec inv_reservation_global.mtl_reservation_rec_type;

1395: l_partial_reservation_flag VARCHAR2(2) := FND_API.G_FALSE;
1396: l_quantity_reserved NUMBER(19,9);
1397: l_reservation_id NUMBER;
1398: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;
1399: l_mtl_reservation_rec inv_reservation_global.mtl_reservation_rec_type;
1400: l_reservation_count NUMBER;
1401: l_error_code NUMBER;
1402:
1403: l_default_lot_index BINARY_INTEGER;

Line 2274: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

2270: l_whse_code VARCHAR2(4);
2271: l_commit VARCHAR2(5) := FND_API.G_FALSE;
2272: l_validation_level VARCHAR2(4) := FND_API.G_VALID_LEVEL_FULL;
2273: l_validation_flag VARCHAR2(10) := FND_API.G_TRUE;
2274: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
2275: l_serial_number inv_reservation_global.serial_number_tbl_type;
2276: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;
2277: l_mtl_reservation_tbl_count NUMBER;
2278: l_error_code NUMBER;

Line 2275: l_serial_number inv_reservation_global.serial_number_tbl_type;

2271: l_commit VARCHAR2(5) := FND_API.G_FALSE;
2272: l_validation_level VARCHAR2(4) := FND_API.G_VALID_LEVEL_FULL;
2273: l_validation_flag VARCHAR2(10) := FND_API.G_TRUE;
2274: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
2275: l_serial_number inv_reservation_global.serial_number_tbl_type;
2276: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;
2277: l_mtl_reservation_tbl_count NUMBER;
2278: l_error_code NUMBER;
2279: l_default_lot_index NUMBER;

Line 2276: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;

2272: l_validation_level VARCHAR2(4) := FND_API.G_VALID_LEVEL_FULL;
2273: l_validation_flag VARCHAR2(10) := FND_API.G_TRUE;
2274: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
2275: l_serial_number inv_reservation_global.serial_number_tbl_type;
2276: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;
2277: l_mtl_reservation_tbl_count NUMBER;
2278: l_error_code NUMBER;
2279: l_default_lot_index NUMBER;
2280: l_original_tran_index NUMBER;

Line 2584: , p_cancel_order_mode => INV_RESERVATION_GLOBAL.G_CANCEL_ORDER_YES

2580: , x_msg_count => x_msg_count
2581: , x_msg_data => x_msg_data
2582: , p_validation_flag => l_validation_flag
2583: , p_query_input => l_rsv_rec
2584: , p_cancel_order_mode => INV_RESERVATION_GLOBAL.G_CANCEL_ORDER_YES
2585: , x_mtl_reservation_tbl => l_mtl_reservation_tbl
2586: , x_mtl_reservation_tbl_count => l_mtl_reservation_tbl_count
2587: , x_error_code => l_error_code
2588: , p_lock_records => FND_API.G_FALSE

Line 2589: , p_sort_by_req_date => INV_RESERVATION_GLOBAL.G_QUERY_NO_SORT

2585: , x_mtl_reservation_tbl => l_mtl_reservation_tbl
2586: , x_mtl_reservation_tbl_count => l_mtl_reservation_tbl_count
2587: , x_error_code => l_error_code
2588: , p_lock_records => FND_API.G_FALSE
2589: , p_sort_by_req_date => INV_RESERVATION_GLOBAL.G_QUERY_NO_SORT
2590: );
2591:
2592: /* ======================================================================================= */
2593: /* There may not be any rows, and it should be possible ! (if not auto-allocate before) */

Line 3438: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

3434: l_validation_level VARCHAR2(4) := FND_API.G_VALID_LEVEL_FULL;
3435:
3436: l_temp_tran_row ic_tran_pnd%ROWTYPE;
3437: l_original_tran_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
3438: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
3439: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;
3440: l_mtl_reservation_tbl_count NUMBER;
3441: l_error_code NUMBER;
3442:

Line 3439: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;

3435:
3436: l_temp_tran_row ic_tran_pnd%ROWTYPE;
3437: l_original_tran_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
3438: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
3439: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;
3440: l_mtl_reservation_tbl_count NUMBER;
3441: l_error_code NUMBER;
3442:
3443: ll_trans_id NUMBER;

Line 3576: , p_cancel_order_mode => INV_RESERVATION_GLOBAL.G_CANCEL_ORDER_YES

3572: , x_msg_count => x_msg_count
3573: , x_msg_data => x_msg_data
3574: , p_validation_flag => l_validation_flag
3575: , p_query_input => l_rsv_rec
3576: , p_cancel_order_mode => INV_RESERVATION_GLOBAL.G_CANCEL_ORDER_YES
3577: , x_mtl_reservation_tbl => l_mtl_reservation_tbl
3578: , x_mtl_reservation_tbl_count => l_mtl_reservation_tbl_count
3579: , x_error_code => l_error_code
3580: , p_lock_records => FND_API.G_FALSE

Line 3581: , p_sort_by_req_date => INV_RESERVATION_GLOBAL.G_QUERY_NO_SORT

3577: , x_mtl_reservation_tbl => l_mtl_reservation_tbl
3578: , x_mtl_reservation_tbl_count => l_mtl_reservation_tbl_count
3579: , x_error_code => l_error_code
3580: , p_lock_records => FND_API.G_FALSE
3581: , p_sort_by_req_date => INV_RESERVATION_GLOBAL.G_QUERY_NO_SORT
3582: );
3583:
3584: /* There may not be any rows, and it should be possible ! (if not auto-allocate before) */
3585: IF (GMI_Reservation_Util.ic_tran_rec_tbl.COUNT = 0)