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_PVT dependencies on INV_RESERVATION_GLOBAL

Line 132: , p_query_input IN inv_reservation_global.mtl_reservation_rec_type

128: x_return_status OUT NOCOPY VARCHAR2
129: , x_msg_count OUT NOCOPY NUMBER
130: , x_msg_data OUT NOCOPY VARCHAR2
131: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true
132: , p_query_input IN inv_reservation_global.mtl_reservation_rec_type
133: , p_lock_records IN VARCHAR2 DEFAULT fnd_api.g_false
134: , x_mtl_reservation_tbl OUT NOCOPY inv_reservation_global.mtl_reservation_tbl_type
135: , x_mtl_reservation_tbl_count OUT NOCOPY NUMBER
136: , x_error_code OUT NOCOPY NUMBER

Line 134: , x_mtl_reservation_tbl OUT NOCOPY inv_reservation_global.mtl_reservation_tbl_type

130: , x_msg_data OUT NOCOPY VARCHAR2
131: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true
132: , p_query_input IN inv_reservation_global.mtl_reservation_rec_type
133: , p_lock_records IN VARCHAR2 DEFAULT fnd_api.g_false
134: , x_mtl_reservation_tbl OUT NOCOPY inv_reservation_global.mtl_reservation_tbl_type
135: , x_mtl_reservation_tbl_count OUT NOCOPY NUMBER
136: , x_error_code OUT NOCOPY NUMBER
137: ) IS
138:

Line 372: x_mtl_reservation_tbl(rec_index).demand_source_type_id := INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_OE;

368: x_mtl_reservation_tbl(rec_index).inventory_item_id := l_ic_item_mst_rec.inventory_item_id;
369: x_mtl_reservation_tbl(rec_index).demand_source_header_id := GMI_Reservation_Util.ic_tran_rec_tbl(rec_index).doc_id;
370: x_mtl_reservation_tbl(rec_index).demand_source_line_id := GMI_Reservation_Util.ic_tran_rec_tbl(rec_index).line_id;
371: /* hwahdani 1388867 */
372: x_mtl_reservation_tbl(rec_index).demand_source_type_id := INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_OE;
373: x_mtl_reservation_tbl(rec_index).requirement_date := GMI_RESERVATION_UTIL.ic_tran_rec_tbl(rec_index).trans_date;
374: /* end of 1388867 */
375:
376: /* Quantities in mtl_reservation_tbl are >0, those in ic_tran_rec_tbl are <=0. */

Line 475: , p_rsv_rec IN INV_reservation_global.mtl_reservation_rec_type

471: x_return_status OUT NOCOPY VARCHAR2
472: , x_msg_count OUT NOCOPY NUMBER
473: , x_msg_data OUT NOCOPY VARCHAR2
474: , p_validation_flag IN VARCHAR2 DEFAULT FND_API.G_TRUE
475: , p_rsv_rec IN INV_reservation_global.mtl_reservation_rec_type
476: , p_serial_number IN INV_reservation_global.serial_number_tbl_type
477: , x_serial_number OUT NOCOPY INV_reservation_global.serial_number_tbl_type
478: , p_partial_reservation_flag IN VARCHAR2 DEFAULT FND_API.G_FALSE
479: , p_force_reservation_flag IN VARCHAR2 DEFAULT FND_API.G_FALSE

Line 476: , p_serial_number IN INV_reservation_global.serial_number_tbl_type

472: , x_msg_count OUT NOCOPY NUMBER
473: , x_msg_data OUT NOCOPY VARCHAR2
474: , p_validation_flag IN VARCHAR2 DEFAULT FND_API.G_TRUE
475: , p_rsv_rec IN INV_reservation_global.mtl_reservation_rec_type
476: , p_serial_number IN INV_reservation_global.serial_number_tbl_type
477: , x_serial_number OUT NOCOPY INV_reservation_global.serial_number_tbl_type
478: , p_partial_reservation_flag IN VARCHAR2 DEFAULT FND_API.G_FALSE
479: , p_force_reservation_flag IN VARCHAR2 DEFAULT FND_API.G_FALSE
480: , x_quantity_reserved OUT NOCOPY NUMBER

Line 477: , x_serial_number OUT NOCOPY INV_reservation_global.serial_number_tbl_type

473: , x_msg_data OUT NOCOPY VARCHAR2
474: , p_validation_flag IN VARCHAR2 DEFAULT FND_API.G_TRUE
475: , p_rsv_rec IN INV_reservation_global.mtl_reservation_rec_type
476: , p_serial_number IN INV_reservation_global.serial_number_tbl_type
477: , x_serial_number OUT NOCOPY INV_reservation_global.serial_number_tbl_type
478: , p_partial_reservation_flag IN VARCHAR2 DEFAULT FND_API.G_FALSE
479: , p_force_reservation_flag IN VARCHAR2 DEFAULT FND_API.G_FALSE
480: , x_quantity_reserved OUT NOCOPY NUMBER
481: , x_reservation_id OUT NOCOPY NUMBER

Line 487: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;

483:
484: /* ==== Variables ============================================================== */
485: l_api_name CONSTANT VARCHAR2 (30) := 'Create_Reservation';
486: l_default_lot_index BINARY_INTEGER;
487: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;
488: l_mtl_rsv_tbl_count NUMBER;
489: x_error_code NUMBER;
490: l_lock_status BOOLEAN;
491: l_allocation_rec GMI_AUTO_ALLOCATE_PUB.gmi_allocation_rec;

Line 585: , p_cancel_order_mode => INV_RESERVATION_GLOBAL.G_CANCEL_ORDER_YES

581: , x_msg_count => x_msg_count
582: , x_msg_data => x_msg_data
583: , p_validation_flag => p_validation_flag
584: , p_query_input => p_rsv_rec
585: , p_cancel_order_mode => INV_RESERVATION_GLOBAL.G_CANCEL_ORDER_YES
586: , x_mtl_reservation_tbl => l_mtl_reservation_tbl
587: , x_mtl_reservation_tbl_count => l_mtl_rsv_tbl_count
588: , x_error_code => x_error_code
589: , p_lock_records => FND_API.G_FALSE

Line 590: , p_sort_by_req_date => inv_reservation_global.g_query_no_sort

586: , x_mtl_reservation_tbl => l_mtl_reservation_tbl
587: , x_mtl_reservation_tbl_count => l_mtl_rsv_tbl_count
588: , x_error_code => x_error_code
589: , p_lock_records => FND_API.G_FALSE
590: , p_sort_by_req_date => inv_reservation_global.g_query_no_sort
591: );
592:
593: /* There may have been a problem getting the rows */
594: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)

Line 972: , p_original_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type

968: x_return_status OUT NOCOPY VARCHAR2
969: , x_msg_count OUT NOCOPY NUMBER
970: , x_msg_data OUT NOCOPY VARCHAR2
971: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true
972: , p_original_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
973: , p_to_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
974: , p_original_serial_number IN inv_reservation_global.serial_number_tbl_type
975: , p_to_serial_number IN inv_reservation_global.serial_number_tbl_type
976: ) IS

Line 973: , p_to_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type

969: , x_msg_count OUT NOCOPY NUMBER
970: , x_msg_data OUT NOCOPY VARCHAR2
971: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true
972: , p_original_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
973: , p_to_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
974: , p_original_serial_number IN inv_reservation_global.serial_number_tbl_type
975: , p_to_serial_number IN inv_reservation_global.serial_number_tbl_type
976: ) IS
977:

Line 974: , p_original_serial_number IN inv_reservation_global.serial_number_tbl_type

970: , x_msg_data OUT NOCOPY VARCHAR2
971: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true
972: , p_original_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
973: , p_to_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
974: , p_original_serial_number IN inv_reservation_global.serial_number_tbl_type
975: , p_to_serial_number IN inv_reservation_global.serial_number_tbl_type
976: ) IS
977:
978: l_commit VARCHAR2(5) := fnd_api.g_false;

Line 975: , p_to_serial_number IN inv_reservation_global.serial_number_tbl_type

971: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true
972: , p_original_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
973: , p_to_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
974: , p_original_serial_number IN inv_reservation_global.serial_number_tbl_type
975: , p_to_serial_number IN inv_reservation_global.serial_number_tbl_type
976: ) IS
977:
978: l_commit VARCHAR2(5) := fnd_api.g_false;
979: l_validation_level VARCHAR2(4) := fnd_api.g_valid_level_full;

Line 1003: l_old_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;

999: l_new_rsv_to_item_um_qty NUMBER;
1000: l_new_rsv_to_item_um_qty2 NUMBER;
1001: l_default_lot_quantity NUMBER;
1002: l_default_loct VARCHAR2(4) := fnd_profile.value('IC$DEFAULT_LOCT');
1003: l_old_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;
1004: l_old_mtl_rsv_tbl_count NUMBER;
1005: x_error_code NUMBER;
1006:
1007:

Line 1039: ,p_cancel_order_mode => INV_RESERVATION_GLOBAL.G_CANCEL_ORDER_YES

1035: ,x_msg_count => x_msg_count
1036: ,x_msg_data => x_msg_data
1037: ,p_validation_flag => p_validation_flag
1038: ,p_query_input => p_original_rsv_rec
1039: ,p_cancel_order_mode => INV_RESERVATION_GLOBAL.G_CANCEL_ORDER_YES
1040: ,x_mtl_reservation_tbl => l_old_mtl_reservation_tbl
1041: ,x_mtl_reservation_tbl_count => l_old_mtl_rsv_tbl_count
1042: ,x_error_code => x_error_code
1043: ,p_lock_records => fnd_api.g_false

Line 1044: ,p_sort_by_req_date => inv_reservation_global.g_query_no_sort

1040: ,x_mtl_reservation_tbl => l_old_mtl_reservation_tbl
1041: ,x_mtl_reservation_tbl_count => l_old_mtl_rsv_tbl_count
1042: ,x_error_code => x_error_code
1043: ,p_lock_records => fnd_api.g_false
1044: ,p_sort_by_req_date => inv_reservation_global.g_query_no_sort
1045: );
1046:
1047: /* There may not be any rows*/
1048: IF (GMI_Reservation_Util.ic_tran_rec_tbl.COUNT = 0) THEN

Line 1366: ,p_cancel_order_mode => INV_RESERVATION_GLOBAL.G_CANCEL_ORDER_YES

1362: ,x_msg_data => x_msg_data
1363: ,p_validation_flag => p_validation_flag
1364: --,p_query_input => p_to_rsv_rec
1365: ,p_query_input => p_original_rsv_rec
1366: ,p_cancel_order_mode => INV_RESERVATION_GLOBAL.G_CANCEL_ORDER_YES
1367: ,x_mtl_reservation_tbl => l_old_mtl_reservation_tbl
1368: ,x_mtl_reservation_tbl_count => l_old_mtl_rsv_tbl_count
1369: ,x_error_code => x_error_code
1370: ,p_lock_records => fnd_api.g_false

Line 1371: ,p_sort_by_req_date => inv_reservation_global.g_query_no_sort

1367: ,x_mtl_reservation_tbl => l_old_mtl_reservation_tbl
1368: ,x_mtl_reservation_tbl_count => l_old_mtl_rsv_tbl_count
1369: ,x_error_code => x_error_code
1370: ,p_lock_records => fnd_api.g_false
1371: ,p_sort_by_req_date => inv_reservation_global.g_query_no_sort
1372: );
1373:
1374: /* There may not be any rows*/
1375: IF (GMI_Reservation_Util.ic_tran_rec_tbl.COUNT = 0)

Line 1467: , p_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type

1463: x_return_status OUT NOCOPY VARCHAR2
1464: , x_msg_count OUT NOCOPY NUMBER
1465: , x_msg_data OUT NOCOPY VARCHAR2
1466: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true
1467: , p_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
1468: , p_serial_number IN inv_reservation_global.serial_number_tbl_type
1469: ) IS
1470:
1471: l_api_name CONSTANT VARCHAR2 (30) := 'Delete_Reservation';

Line 1468: , p_serial_number IN inv_reservation_global.serial_number_tbl_type

1464: , x_msg_count OUT NOCOPY NUMBER
1465: , x_msg_data OUT NOCOPY VARCHAR2
1466: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true
1467: , p_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
1468: , p_serial_number IN inv_reservation_global.serial_number_tbl_type
1469: ) IS
1470:
1471: l_api_name CONSTANT VARCHAR2 (30) := 'Delete_Reservation';
1472:

Line 1486: x_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;

1482: l_new_default_lot_quantity1 NUMBER;
1483: l_new_default_lot_quantity2 NUMBER;
1484: x_error_code NUMBER;
1485: x_mtl_reservation_tbl_count NUMBER;
1486: x_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;
1487:
1488: -- Begin 3248046 (lswamy)
1489: Cursor get_line_rec(l_line_id IN NUMBER)IS
1490: Select ship_from_org_id

Line 1526: , p_cancel_order_mode => INV_RESERVATION_GLOBAL.G_CANCEL_ORDER_YES

1522: , x_msg_count => x_msg_count
1523: , x_msg_data => x_msg_data
1524: , p_validation_flag => p_validation_flag
1525: , p_query_input => p_rsv_rec
1526: , p_cancel_order_mode => INV_RESERVATION_GLOBAL.G_CANCEL_ORDER_YES
1527: , x_mtl_reservation_tbl => x_mtl_reservation_tbl
1528: , x_mtl_reservation_tbl_count => x_mtl_reservation_tbl_count
1529: , x_error_code => x_error_code
1530: , p_lock_records => fnd_api.g_false

Line 1531: , p_sort_by_req_date => inv_reservation_global.g_query_no_sort

1527: , x_mtl_reservation_tbl => x_mtl_reservation_tbl
1528: , x_mtl_reservation_tbl_count => x_mtl_reservation_tbl_count
1529: , x_error_code => x_error_code
1530: , p_lock_records => fnd_api.g_false
1531: , p_sort_by_req_date => inv_reservation_global.g_query_no_sort
1532: );
1533:
1534: /* If we were able to find records then*/
1535: IF (GMI_Reservation_Util.ic_tran_rec_tbl.COUNT <= 0)

Line 1791: , p_original_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type

1787: , x_msg_count OUT NOCOPY NUMBER
1788: , x_msg_data OUT NOCOPY VARCHAR2
1789: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true
1790: , p_is_transfer_supply IN VARCHAR2 DEFAULT fnd_api.g_true
1791: , p_original_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
1792: , p_to_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
1793: , p_original_serial_number IN inv_reservation_global.serial_number_tbl_type
1794: , p_to_serial_number IN inv_reservation_global.serial_number_tbl_type
1795: , x_to_reservation_id OUT NOCOPY NUMBER

Line 1792: , p_to_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type

1788: , x_msg_data OUT NOCOPY VARCHAR2
1789: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true
1790: , p_is_transfer_supply IN VARCHAR2 DEFAULT fnd_api.g_true
1791: , p_original_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
1792: , p_to_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
1793: , p_original_serial_number IN inv_reservation_global.serial_number_tbl_type
1794: , p_to_serial_number IN inv_reservation_global.serial_number_tbl_type
1795: , x_to_reservation_id OUT NOCOPY NUMBER
1796: ) IS

Line 1793: , p_original_serial_number IN inv_reservation_global.serial_number_tbl_type

1789: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true
1790: , p_is_transfer_supply IN VARCHAR2 DEFAULT fnd_api.g_true
1791: , p_original_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
1792: , p_to_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
1793: , p_original_serial_number IN inv_reservation_global.serial_number_tbl_type
1794: , p_to_serial_number IN inv_reservation_global.serial_number_tbl_type
1795: , x_to_reservation_id OUT NOCOPY NUMBER
1796: ) IS
1797:

Line 1794: , p_to_serial_number IN inv_reservation_global.serial_number_tbl_type

1790: , p_is_transfer_supply IN VARCHAR2 DEFAULT fnd_api.g_true
1791: , p_original_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
1792: , p_to_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
1793: , p_original_serial_number IN inv_reservation_global.serial_number_tbl_type
1794: , p_to_serial_number IN inv_reservation_global.serial_number_tbl_type
1795: , x_to_reservation_id OUT NOCOPY NUMBER
1796: ) IS
1797:
1798: l_api_name CONSTANT VARCHAR2 (30) := 'Transfer_Reservation';

Line 2374: ( p_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type

2370: +==========================================================================+
2371: Api end of comments
2372: */
2373: PROCEDURE Check_Shipping_Details
2374: ( p_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
2375: , x_return_status OUT NOCOPY VARCHAR2
2376: , x_msg_count OUT NOCOPY NUMBER
2377: , x_msg_data OUT NOCOPY VARCHAR2
2378: ) IS