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

Line 60: l_fpo_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

56: , X_msg_data OUT NOCOPY VARCHAR2
57: ) IS
58:
59: l_api_name CONSTANT VARCHAR2 (30) := 'create_reservation_from_FPO';
60: l_fpo_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
61: l_batch_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
62: l_fpo_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
63: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
64: l_fpo_rsv_count NUMBER;

Line 61: l_batch_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

57: ) IS
58:
59: l_api_name CONSTANT VARCHAR2 (30) := 'create_reservation_from_FPO';
60: l_fpo_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
61: l_batch_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
62: l_fpo_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
63: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
64: l_fpo_rsv_count NUMBER;
65:

Line 62: l_fpo_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;

58:
59: l_api_name CONSTANT VARCHAR2 (30) := 'create_reservation_from_FPO';
60: l_fpo_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
61: l_batch_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
62: l_fpo_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
63: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
64: l_fpo_rsv_count NUMBER;
65:
66: l_batch_line_id NUMBER;

Line 63: l_dummy_sn inv_reservation_global.serial_number_tbl_type;

59: l_api_name CONSTANT VARCHAR2 (30) := 'create_reservation_from_FPO';
60: l_fpo_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
61: l_batch_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
62: l_fpo_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
63: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
64: l_fpo_rsv_count NUMBER;
65:
66: l_batch_line_id NUMBER;
67: l_fpo_batch_line_id NUMBER;

Line 96: -- and demand_source_type_id = inv_reservation_global.g_source_type_oe

92: Select distinct organization_id
93: From mtl_reservations
94: Where supply_source_line_id = p_batch_line_id
95: and supply_source_type_id = 5
96: -- and demand_source_type_id = inv_reservation_global.g_source_type_oe
97: and demand_source_type_id IN (inv_reservation_global.g_source_type_oe, gme_common_pvt.g_txn_source_type) -- Bug 13630492
98: and reservation_quantity<>0
99: ;
100:

Line 97: and demand_source_type_id IN (inv_reservation_global.g_source_type_oe, gme_common_pvt.g_txn_source_type) -- Bug 13630492

93: From mtl_reservations
94: Where supply_source_line_id = p_batch_line_id
95: and supply_source_type_id = 5
96: -- and demand_source_type_id = inv_reservation_global.g_source_type_oe
97: and demand_source_type_id IN (inv_reservation_global.g_source_type_oe, gme_common_pvt.g_txn_source_type) -- Bug 13630492
98: and reservation_quantity<>0
99: ;
100:
101: Cursor get_batch_line (p_batch_id IN NUMBER) IS

Line 116: and demand_source_type_id = inv_reservation_global.g_source_type_oe

112: Select *
113: From mtl_reservations
114: Where supply_source_line_id = p_batch_line_id
115: and supply_source_type_id = 5
116: and demand_source_type_id = inv_reservation_global.g_source_type_oe
117: and organization_id = p_organization_id
118: and reservation_quantity <> 0
119: Order by requirement_date
120: ;

Line 199: l_fpo_rsv_rec.supply_source_type_id := 5 ;--inv_reservation_global.g_source_type_wip;

195: /* process the reservations made in this whse */
196:
197: l_fpo_rsv_rec.organization_id := l_organization_id;
198: l_fpo_rsv_rec.inventory_item_id := l_inventory_item_id;
199: l_fpo_rsv_rec.supply_source_type_id := 5 ;--inv_reservation_global.g_source_type_wip;
200: l_fpo_rsv_rec.supply_source_header_id := p_fpo_batch_id;
201: l_fpo_rsv_rec.supply_source_line_id := l_fpo_batch_line_id;
202: inv_reservation_pub.query_reservation
203: (

Line 210: , p_sort_by_req_date => inv_reservation_global.g_query_req_date_asc

206: , x_return_status => x_return_status
207: , x_msg_count => x_msg_count
208: , x_msg_data => x_msg_data
209: , p_query_input => l_fpo_rsv_rec
210: , p_sort_by_req_date => inv_reservation_global.g_query_req_date_asc
211: , x_mtl_reservation_tbl => l_fpo_rsv_tbl
212: , x_mtl_reservation_tbl_count => l_fpo_rsv_count
213: , x_error_code => l_api_error_code
214: );

Line 806: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;

802: l_api_name CONSTANT VARCHAR2 (30) := 'transfer_reservation_to_inv';
803: l_return_status VARCHAR2 (1);
804: l_msg_count NUMBER;
805: l_msg_data VARCHAR2 (2000);
806: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
807: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
808: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
809: l_rsv_rec_inq inv_reservation_global.mtl_reservation_rec_type;
810: l_mmt_rec mtl_material_transactions%ROWTYPE;

Line 807: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

803: l_return_status VARCHAR2 (1);
804: l_msg_count NUMBER;
805: l_msg_data VARCHAR2 (2000);
806: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
807: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
808: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
809: l_rsv_rec_inq inv_reservation_global.mtl_reservation_rec_type;
810: l_mmt_rec mtl_material_transactions%ROWTYPE;
811: l_mmln_tbl gme_common_pvt.mtl_trans_lots_num_tbl;

Line 808: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

804: l_msg_count NUMBER;
805: l_msg_data VARCHAR2 (2000);
806: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
807: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
808: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
809: l_rsv_rec_inq inv_reservation_global.mtl_reservation_rec_type;
810: l_mmt_rec mtl_material_transactions%ROWTYPE;
811: l_mmln_tbl gme_common_pvt.mtl_trans_lots_num_tbl;
812: l_rsv_count NUMBER;

Line 809: l_rsv_rec_inq inv_reservation_global.mtl_reservation_rec_type;

805: l_msg_data VARCHAR2 (2000);
806: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
807: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
808: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
809: l_rsv_rec_inq inv_reservation_global.mtl_reservation_rec_type;
810: l_mmt_rec mtl_material_transactions%ROWTYPE;
811: l_mmln_tbl gme_common_pvt.mtl_trans_lots_num_tbl;
812: l_rsv_count NUMBER;
813: l_rsv_id NUMBER;

Line 822: l_dummy_sn inv_reservation_global.serial_number_tbl_type;

818: l_transfer_secondary NUMBER := 0;
819: l_yield_txn_counter NUMBER;
820: l_transfer_complete VARCHAR2 (1) := 'N';
821: l_SO_RSV_exist VARCHAR2 (1) := 'Y';
822: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
823: -- ======================================================================
824: l_txn_quantity NUMBER;
825: l_txn_primary NUMBER;
826: l_txn_secondary NUMBER;

Line 1145: l_to_rsv_rec.supply_source_type_id := inv_reservation_global.g_source_type_inv;

1141: l_to_rsv_rec.lot_number := l_txn_lot;
1142: l_to_rsv_rec.lpn_id := l_mmt_rec.transfer_lpn_id; -- Bug 8343517
1143: l_to_rsv_rec.subinventory_id := NULL;
1144: l_to_rsv_rec.lot_number_id := NULL;
1145: l_to_rsv_rec.supply_source_type_id := inv_reservation_global.g_source_type_inv;
1146: l_to_rsv_rec.supply_source_header_id := NULL;
1147: l_to_rsv_rec.supply_source_line_id := NULL;
1148: l_to_rsv_rec.supply_source_name := NULL;
1149: l_to_rsv_rec.supply_source_line_detail := NULL;

Line 1193: IF l_rsv_rec.demand_source_type_id = inv_reservation_global.g_source_type_oe THEN

1189: || l_rsv_rec.supply_source_line_id);
1190: END IF;
1191: -- If demand is from sales, issue Notification Advising that Reservation Transfer is not possible
1192: -- ==============================================================================================
1193: IF l_rsv_rec.demand_source_type_id = inv_reservation_global.g_source_type_oe THEN
1194: GME_SUPPLY_RES_PVT.notify_CSR
1195: ( P_Batch_id => NULL
1196: , P_Batch_line_id => l_rsv_rec.supply_source_line_id
1197: , P_So_line_id => l_rsv_rec.demand_source_line_id

Line 1338: ,x_mtl_reservation_tbl OUT NOCOPY inv_reservation_global.mtl_reservation_tbl_type

1334: END transfer_reservation_to_inv;
1335:
1336: PROCEDURE query_prod_supply_reservations(
1337: p_matl_dtl_rec IN gme_material_details%ROWTYPE
1338: ,x_mtl_reservation_tbl OUT NOCOPY inv_reservation_global.mtl_reservation_tbl_type
1339: ,x_mtl_reservation_tbl_count OUT NOCOPY NUMBER
1340: ,x_msg_count OUT NOCOPY NUMBER
1341: ,x_msg_data OUT NOCOPY VARCHAR2
1342: ,x_return_status OUT NOCOPY VARCHAR2)

Line 1350: l_rsv_rec_inq inv_reservation_global.mtl_reservation_rec_type;

1346: l_msg_count NUMBER;
1347: l_msg_data VARCHAR2 (2000);
1348: l_total_primary_demand NUMBER;
1349:
1350: l_rsv_rec_inq inv_reservation_global.mtl_reservation_rec_type;
1351: l_error_code NUMBER;
1352: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
1353: -- ======================================================================
1354: query_reservation_error EXCEPTION;

Line 1352: l_dummy_sn inv_reservation_global.serial_number_tbl_type;

1348: l_total_primary_demand NUMBER;
1349:
1350: l_rsv_rec_inq inv_reservation_global.mtl_reservation_rec_type;
1351: l_error_code NUMBER;
1352: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
1353: -- ======================================================================
1354: query_reservation_error EXCEPTION;
1355: BEGIN
1356: IF g_debug <= gme_debug.g_log_procedure THEN

Line 1407: ,p_sort_by_req_date => inv_reservation_global.g_query_req_date_asc

1403: ,x_msg_count => x_msg_count
1404: ,x_msg_data => x_msg_data
1405: ,p_query_input => l_rsv_rec_inq
1406: ,p_lock_records => fnd_api.g_false
1407: ,p_sort_by_req_date => inv_reservation_global.g_query_req_date_asc
1408: ,x_mtl_reservation_tbl => x_mtl_reservation_tbl
1409: ,x_mtl_reservation_tbl_count => x_mtl_reservation_tbl_count
1410: ,x_error_code => l_error_code);
1411:

Line 1477: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

1473: l_primary_to_unreserve NUMBER;
1474: l_secondary_to_unreserve NUMBER;
1475: l_total_primary_demand NUMBER;
1476: l_available_quantity NUMBER;
1477: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1478: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
1479: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
1480: l_primary_relieved NUMBER;
1481: l_secondary_relieved NUMBER;

Line 1478: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;

1474: l_secondary_to_unreserve NUMBER;
1475: l_total_primary_demand NUMBER;
1476: l_available_quantity NUMBER;
1477: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1478: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
1479: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
1480: l_primary_relieved NUMBER;
1481: l_secondary_relieved NUMBER;
1482: l_primary_remain NUMBER;

Line 1479: l_dummy_sn inv_reservation_global.serial_number_tbl_type;

1475: l_total_primary_demand NUMBER;
1476: l_available_quantity NUMBER;
1477: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1478: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
1479: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
1480: l_primary_relieved NUMBER;
1481: l_secondary_relieved NUMBER;
1482: l_primary_remain NUMBER;
1483: l_secondary_remain NUMBER;

Line 1778: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

1774: l_api_name CONSTANT VARCHAR2 (30) := 'delete_prod_supply_resv';
1775: l_rsv_count NUMBER;
1776:
1777: l_matl_dtl_rec gme_material_details%ROWTYPE;
1778: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1779: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
1780: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
1781: -- ======================================================================
1782: query_reservation_error EXCEPTION;

Line 1779: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;

1775: l_rsv_count NUMBER;
1776:
1777: l_matl_dtl_rec gme_material_details%ROWTYPE;
1778: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1779: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
1780: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
1781: -- ======================================================================
1782: query_reservation_error EXCEPTION;
1783: update_reservation_err EXCEPTION;

Line 1780: l_dummy_sn inv_reservation_global.serial_number_tbl_type;

1776:
1777: l_matl_dtl_rec gme_material_details%ROWTYPE;
1778: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1779: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
1780: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
1781: -- ======================================================================
1782: query_reservation_error EXCEPTION;
1783: update_reservation_err EXCEPTION;
1784: delete_reservation_err EXCEPTION;

Line 1966: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

1962: l_api_name CONSTANT VARCHAR2 (30) := 'delete_prod_supply_resv';
1963: l_rsv_count NUMBER;
1964:
1965: l_matl_dtl_rec gme_material_details%ROWTYPE;
1966: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1967: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
1968: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
1969: -- ======================================================================
1970: query_reservation_error EXCEPTION;

Line 1967: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;

1963: l_rsv_count NUMBER;
1964:
1965: l_matl_dtl_rec gme_material_details%ROWTYPE;
1966: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1967: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
1968: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
1969: -- ======================================================================
1970: query_reservation_error EXCEPTION;
1971: update_reservation_err EXCEPTION;

Line 1968: l_dummy_sn inv_reservation_global.serial_number_tbl_type;

1964:
1965: l_matl_dtl_rec gme_material_details%ROWTYPE;
1966: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1967: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
1968: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
1969: -- ======================================================================
1970: query_reservation_error EXCEPTION;
1971: update_reservation_err EXCEPTION;
1972: delete_reservation_err EXCEPTION;