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 46: l_fpo_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

42: , X_msg_data OUT NOCOPY VARCHAR2
43: ) IS
44:
45: l_api_name CONSTANT VARCHAR2 (30) := 'create_reservation_from_FPO';
46: l_fpo_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
47: l_batch_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
48: l_fpo_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
49: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
50: l_fpo_rsv_count NUMBER;

Line 47: l_batch_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

43: ) IS
44:
45: l_api_name CONSTANT VARCHAR2 (30) := 'create_reservation_from_FPO';
46: l_fpo_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
47: l_batch_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
48: l_fpo_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
49: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
50: l_fpo_rsv_count NUMBER;
51:

Line 48: l_fpo_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;

44:
45: l_api_name CONSTANT VARCHAR2 (30) := 'create_reservation_from_FPO';
46: l_fpo_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
47: l_batch_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
48: l_fpo_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
49: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
50: l_fpo_rsv_count NUMBER;
51:
52: l_batch_line_id NUMBER;

Line 49: l_dummy_sn inv_reservation_global.serial_number_tbl_type;

45: l_api_name CONSTANT VARCHAR2 (30) := 'create_reservation_from_FPO';
46: l_fpo_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
47: l_batch_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
48: l_fpo_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
49: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
50: l_fpo_rsv_count NUMBER;
51:
52: l_batch_line_id NUMBER;
53: l_fpo_batch_line_id NUMBER;

Line 81: and demand_source_type_id = inv_reservation_global.g_source_type_oe

77: Select distinct organization_id
78: From mtl_reservations
79: Where supply_source_line_id = p_batch_line_id
80: and supply_source_type_id = 5
81: and demand_source_type_id = inv_reservation_global.g_source_type_oe
82: and reservation_quantity<>0
83: ;
84:
85: Cursor get_batch_line (p_batch_id IN NUMBER) IS

Line 100: and demand_source_type_id = inv_reservation_global.g_source_type_oe

96: Select *
97: From mtl_reservations
98: Where supply_source_line_id = p_batch_line_id
99: and supply_source_type_id = 5
100: and demand_source_type_id = inv_reservation_global.g_source_type_oe
101: and organization_id = p_organization_id
102: and reservation_quantity <> 0
103: Order by requirement_date
104: ;

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

179: /* process the reservations made in this whse */
180:
181: l_fpo_rsv_rec.organization_id := l_organization_id;
182: l_fpo_rsv_rec.inventory_item_id := l_inventory_item_id;
183: l_fpo_rsv_rec.supply_source_type_id := 5 ;--inv_reservation_global.g_source_type_wip;
184: l_fpo_rsv_rec.supply_source_header_id := p_fpo_batch_id;
185: l_fpo_rsv_rec.supply_source_line_id := l_fpo_batch_line_id;
186: inv_reservation_pub.query_reservation
187: (

Line 194: , p_sort_by_req_date => inv_reservation_global.g_query_req_date_asc

190: , x_return_status => x_return_status
191: , x_msg_count => x_msg_count
192: , x_msg_data => x_msg_data
193: , p_query_input => l_fpo_rsv_rec
194: , p_sort_by_req_date => inv_reservation_global.g_query_req_date_asc
195: , x_mtl_reservation_tbl => l_fpo_rsv_tbl
196: , x_mtl_reservation_tbl_count => l_fpo_rsv_count
197: , x_error_code => l_api_error_code
198: );

Line 790: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;

786: l_api_name CONSTANT VARCHAR2 (30) := 'transfer_reservation_to_inv';
787: l_return_status VARCHAR2 (1);
788: l_msg_count NUMBER;
789: l_msg_data VARCHAR2 (2000);
790: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
791: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
792: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
793: l_rsv_rec_inq inv_reservation_global.mtl_reservation_rec_type;
794: l_mmt_rec mtl_material_transactions%ROWTYPE;

Line 791: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

787: l_return_status VARCHAR2 (1);
788: l_msg_count NUMBER;
789: l_msg_data VARCHAR2 (2000);
790: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
791: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
792: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
793: l_rsv_rec_inq inv_reservation_global.mtl_reservation_rec_type;
794: l_mmt_rec mtl_material_transactions%ROWTYPE;
795: l_mmln_tbl gme_common_pvt.mtl_trans_lots_num_tbl;

Line 792: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

788: l_msg_count NUMBER;
789: l_msg_data VARCHAR2 (2000);
790: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
791: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
792: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
793: l_rsv_rec_inq inv_reservation_global.mtl_reservation_rec_type;
794: l_mmt_rec mtl_material_transactions%ROWTYPE;
795: l_mmln_tbl gme_common_pvt.mtl_trans_lots_num_tbl;
796: l_rsv_count NUMBER;

Line 793: l_rsv_rec_inq inv_reservation_global.mtl_reservation_rec_type;

789: l_msg_data VARCHAR2 (2000);
790: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
791: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
792: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
793: l_rsv_rec_inq inv_reservation_global.mtl_reservation_rec_type;
794: l_mmt_rec mtl_material_transactions%ROWTYPE;
795: l_mmln_tbl gme_common_pvt.mtl_trans_lots_num_tbl;
796: l_rsv_count NUMBER;
797: l_rsv_id NUMBER;

Line 806: l_dummy_sn inv_reservation_global.serial_number_tbl_type;

802: l_transfer_secondary NUMBER := 0;
803: l_yield_txn_counter NUMBER;
804: l_transfer_complete VARCHAR2 (1) := 'N';
805: l_SO_RSV_exist VARCHAR2 (1) := 'Y';
806: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
807: -- ======================================================================
808: l_txn_quantity NUMBER;
809: l_txn_primary NUMBER;
810: l_txn_secondary NUMBER;

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

1082: l_to_rsv_rec.lot_number := l_txn_lot;
1083: l_to_rsv_rec.lpn_id := NULL;
1084: l_to_rsv_rec.subinventory_id := NULL;
1085: l_to_rsv_rec.lot_number_id := NULL;
1086: l_to_rsv_rec.supply_source_type_id := inv_reservation_global.g_source_type_inv;
1087: l_to_rsv_rec.supply_source_header_id := NULL;
1088: l_to_rsv_rec.supply_source_line_id := NULL;
1089: l_to_rsv_rec.supply_source_name := NULL;
1090: l_to_rsv_rec.supply_source_line_detail := NULL;

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

1130: || l_rsv_rec.supply_source_line_id);
1131: END IF;
1132: -- If demand is from sales, issue Notification Advising that Reservation Transfer is not possible
1133: -- ==============================================================================================
1134: IF l_rsv_rec.demand_source_type_id = inv_reservation_global.g_source_type_oe THEN
1135: GME_SUPPLY_RES_PVT.notify_CSR
1136: ( P_Batch_id => NULL
1137: , P_Batch_line_id => l_rsv_rec.supply_source_line_id
1138: , P_So_line_id => l_rsv_rec.demand_source_line_id

Line 1275: ,x_mtl_reservation_tbl OUT NOCOPY inv_reservation_global.mtl_reservation_tbl_type

1271: END transfer_reservation_to_inv;
1272:
1273: PROCEDURE query_prod_supply_reservations(
1274: p_matl_dtl_rec IN gme_material_details%ROWTYPE
1275: ,x_mtl_reservation_tbl OUT NOCOPY inv_reservation_global.mtl_reservation_tbl_type
1276: ,x_mtl_reservation_tbl_count OUT NOCOPY NUMBER
1277: ,x_msg_count OUT NOCOPY NUMBER
1278: ,x_msg_data OUT NOCOPY VARCHAR2
1279: ,x_return_status OUT NOCOPY VARCHAR2)

Line 1287: l_rsv_rec_inq inv_reservation_global.mtl_reservation_rec_type;

1283: l_msg_count NUMBER;
1284: l_msg_data VARCHAR2 (2000);
1285: l_total_primary_demand NUMBER;
1286:
1287: l_rsv_rec_inq inv_reservation_global.mtl_reservation_rec_type;
1288: l_error_code NUMBER;
1289: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
1290: -- ======================================================================
1291: query_reservation_error EXCEPTION;

Line 1289: l_dummy_sn inv_reservation_global.serial_number_tbl_type;

1285: l_total_primary_demand NUMBER;
1286:
1287: l_rsv_rec_inq inv_reservation_global.mtl_reservation_rec_type;
1288: l_error_code NUMBER;
1289: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
1290: -- ======================================================================
1291: query_reservation_error EXCEPTION;
1292: BEGIN
1293: IF g_debug <= gme_debug.g_log_procedure THEN

Line 1344: ,p_sort_by_req_date => inv_reservation_global.g_query_req_date_asc

1340: ,x_msg_count => x_msg_count
1341: ,x_msg_data => x_msg_data
1342: ,p_query_input => l_rsv_rec_inq
1343: ,p_lock_records => fnd_api.g_false
1344: ,p_sort_by_req_date => inv_reservation_global.g_query_req_date_asc
1345: ,x_mtl_reservation_tbl => x_mtl_reservation_tbl
1346: ,x_mtl_reservation_tbl_count => x_mtl_reservation_tbl_count
1347: ,x_error_code => l_error_code);
1348:

Line 1414: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

1410: l_primary_to_unreserve NUMBER;
1411: l_secondary_to_unreserve NUMBER;
1412: l_total_primary_demand NUMBER;
1413: l_available_quantity NUMBER;
1414: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1415: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
1416: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
1417: l_primary_relieved NUMBER;
1418: l_secondary_relieved NUMBER;

Line 1415: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;

1411: l_secondary_to_unreserve NUMBER;
1412: l_total_primary_demand NUMBER;
1413: l_available_quantity NUMBER;
1414: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1415: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
1416: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
1417: l_primary_relieved NUMBER;
1418: l_secondary_relieved NUMBER;
1419: l_primary_remain NUMBER;

Line 1416: l_dummy_sn inv_reservation_global.serial_number_tbl_type;

1412: l_total_primary_demand NUMBER;
1413: l_available_quantity NUMBER;
1414: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1415: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
1416: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
1417: l_primary_relieved NUMBER;
1418: l_secondary_relieved NUMBER;
1419: l_primary_remain NUMBER;
1420: l_secondary_remain NUMBER;

Line 1715: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

1711: l_api_name CONSTANT VARCHAR2 (30) := 'delete_prod_supply_resv';
1712: l_rsv_count NUMBER;
1713:
1714: l_matl_dtl_rec gme_material_details%ROWTYPE;
1715: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1716: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
1717: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
1718: -- ======================================================================
1719: query_reservation_error EXCEPTION;

Line 1716: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;

1712: l_rsv_count NUMBER;
1713:
1714: l_matl_dtl_rec gme_material_details%ROWTYPE;
1715: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1716: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
1717: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
1718: -- ======================================================================
1719: query_reservation_error EXCEPTION;
1720: update_reservation_err EXCEPTION;

Line 1717: l_dummy_sn inv_reservation_global.serial_number_tbl_type;

1713:
1714: l_matl_dtl_rec gme_material_details%ROWTYPE;
1715: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1716: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
1717: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
1718: -- ======================================================================
1719: query_reservation_error EXCEPTION;
1720: update_reservation_err EXCEPTION;
1721: delete_reservation_err EXCEPTION;

Line 1903: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

1899: l_api_name CONSTANT VARCHAR2 (30) := 'delete_prod_supply_resv';
1900: l_rsv_count NUMBER;
1901:
1902: l_matl_dtl_rec gme_material_details%ROWTYPE;
1903: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1904: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
1905: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
1906: -- ======================================================================
1907: query_reservation_error EXCEPTION;

Line 1904: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;

1900: l_rsv_count NUMBER;
1901:
1902: l_matl_dtl_rec gme_material_details%ROWTYPE;
1903: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1904: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
1905: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
1906: -- ======================================================================
1907: query_reservation_error EXCEPTION;
1908: update_reservation_err EXCEPTION;

Line 1905: l_dummy_sn inv_reservation_global.serial_number_tbl_type;

1901:
1902: l_matl_dtl_rec gme_material_details%ROWTYPE;
1903: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1904: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
1905: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
1906: -- ======================================================================
1907: query_reservation_error EXCEPTION;
1908: update_reservation_err EXCEPTION;
1909: delete_reservation_err EXCEPTION;