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

Line 246: l_qry_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

242: , p_suggestions OUT NOCOPY g_suggestion_list_rec_type
243: ) IS
244: l_api_version CONSTANT NUMBER := 1.0;
245: l_api_name VARCHAR2(30) := 'Suggest_Reservations';
246: l_qry_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
247: l_new_reservation inv_reservation_global.mtl_reservation_rec_type;
248: l_orig_reservation inv_reservation_global.mtl_reservation_rec_type;
249: l_last_reservation inv_reservation_global.mtl_reservation_rec_type;
250: -- Record for querying up matching reservations for the move order line

Line 247: l_new_reservation inv_reservation_global.mtl_reservation_rec_type;

243: ) IS
244: l_api_version CONSTANT NUMBER := 1.0;
245: l_api_name VARCHAR2(30) := 'Suggest_Reservations';
246: l_qry_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
247: l_new_reservation inv_reservation_global.mtl_reservation_rec_type;
248: l_orig_reservation inv_reservation_global.mtl_reservation_rec_type;
249: l_last_reservation inv_reservation_global.mtl_reservation_rec_type;
250: -- Record for querying up matching reservations for the move order line
251: l_demand_rsvs_ordered inv_reservation_global.mtl_reservation_tbl_type;

Line 248: l_orig_reservation inv_reservation_global.mtl_reservation_rec_type;

244: l_api_version CONSTANT NUMBER := 1.0;
245: l_api_name VARCHAR2(30) := 'Suggest_Reservations';
246: l_qry_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
247: l_new_reservation inv_reservation_global.mtl_reservation_rec_type;
248: l_orig_reservation inv_reservation_global.mtl_reservation_rec_type;
249: l_last_reservation inv_reservation_global.mtl_reservation_rec_type;
250: -- Record for querying up matching reservations for the move order line
251: l_demand_rsvs_ordered inv_reservation_global.mtl_reservation_tbl_type;
252: l_demand_reservations inv_reservation_global.mtl_reservation_tbl_type;

Line 249: l_last_reservation inv_reservation_global.mtl_reservation_rec_type;

245: l_api_name VARCHAR2(30) := 'Suggest_Reservations';
246: l_qry_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
247: l_new_reservation inv_reservation_global.mtl_reservation_rec_type;
248: l_orig_reservation inv_reservation_global.mtl_reservation_rec_type;
249: l_last_reservation inv_reservation_global.mtl_reservation_rec_type;
250: -- Record for querying up matching reservations for the move order line
251: l_demand_rsvs_ordered inv_reservation_global.mtl_reservation_tbl_type;
252: l_demand_reservations inv_reservation_global.mtl_reservation_tbl_type;
253: l_rsv_qty_available NUMBER;

Line 251: l_demand_rsvs_ordered inv_reservation_global.mtl_reservation_tbl_type;

247: l_new_reservation inv_reservation_global.mtl_reservation_rec_type;
248: l_orig_reservation inv_reservation_global.mtl_reservation_rec_type;
249: l_last_reservation inv_reservation_global.mtl_reservation_rec_type;
250: -- Record for querying up matching reservations for the move order line
251: l_demand_rsvs_ordered inv_reservation_global.mtl_reservation_tbl_type;
252: l_demand_reservations inv_reservation_global.mtl_reservation_tbl_type;
253: l_rsv_qty_available NUMBER;
254:
255: l_rsv_qty2_available NUMBER; --BUG#7377744 Added a secondary quantity available to reserve to make it consistent with process_reservations call

Line 252: l_demand_reservations inv_reservation_global.mtl_reservation_tbl_type;

248: l_orig_reservation inv_reservation_global.mtl_reservation_rec_type;
249: l_last_reservation inv_reservation_global.mtl_reservation_rec_type;
250: -- Record for querying up matching reservations for the move order line
251: l_demand_rsvs_ordered inv_reservation_global.mtl_reservation_tbl_type;
252: l_demand_reservations inv_reservation_global.mtl_reservation_tbl_type;
253: l_rsv_qty_available NUMBER;
254:
255: l_rsv_qty2_available NUMBER; --BUG#7377744 Added a secondary quantity available to reserve to make it consistent with process_reservations call
256: l_new_reservation_id NUMBER;

Line 260: l_dummy_sn inv_reservation_global.serial_number_tbl_type;

256: l_new_reservation_id NUMBER;
257: l_qty_succ_reserved NUMBER;
258: l_rsv_index NUMTBLTYPE;
259: l_demand_info wsh_inv_delivery_details_v%ROWTYPE;
260: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
261: l_reserved_serials inv_reservation_global.serial_number_tbl_type;
262: l_suggested_serials inv_reservation_global.serial_number_tbl_type;
263: l_reservation_count_by_id NUMBER;
264: l_requirement_date DATE;

Line 261: l_reserved_serials inv_reservation_global.serial_number_tbl_type;

257: l_qty_succ_reserved NUMBER;
258: l_rsv_index NUMTBLTYPE;
259: l_demand_info wsh_inv_delivery_details_v%ROWTYPE;
260: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
261: l_reserved_serials inv_reservation_global.serial_number_tbl_type;
262: l_suggested_serials inv_reservation_global.serial_number_tbl_type;
263: l_reservation_count_by_id NUMBER;
264: l_requirement_date DATE;
265: l_primary_uom_code VARCHAR2(10) ;

Line 262: l_suggested_serials inv_reservation_global.serial_number_tbl_type;

258: l_rsv_index NUMTBLTYPE;
259: l_demand_info wsh_inv_delivery_details_v%ROWTYPE;
260: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
261: l_reserved_serials inv_reservation_global.serial_number_tbl_type;
262: l_suggested_serials inv_reservation_global.serial_number_tbl_type;
263: l_reservation_count_by_id NUMBER;
264: l_requirement_date DATE;
265: l_primary_uom_code VARCHAR2(10) ;
266: l_simulation_mode NUMBER;

Line 306: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

302:
303: l_return_status VARCHAR2 (1);
304: l_msg_count NUMBER;
305: l_msg_data VARCHAR2 (400);
306: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
307: l_original_serial_number inv_reservation_global.serial_number_tbl_type;
308: del_resvn_error EXCEPTION;
309: l_lot_divisible_flag VARCHAR2(1):='Y'; -- Added for Bug 13910013
310: l_lot_control_code NUMBER; -- Added for Bug 16203819

Line 307: l_original_serial_number inv_reservation_global.serial_number_tbl_type;

303: l_return_status VARCHAR2 (1);
304: l_msg_count NUMBER;
305: l_msg_data VARCHAR2 (400);
306: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
307: l_original_serial_number inv_reservation_global.serial_number_tbl_type;
308: del_resvn_error EXCEPTION;
309: l_lot_divisible_flag VARCHAR2(1):='Y'; -- Added for Bug 13910013
310: l_lot_control_code NUMBER; -- Added for Bug 16203819
311:

Line 754: l_new_reservation.supply_source_type_id := inv_reservation_global.g_source_type_inv;

750:
751: /* Set new_rsv record from the grouped suggestion record */
752: l_new_reservation.organization_id := p_mo_line_rec.organization_id;
753: l_new_reservation.inventory_item_id := p_mo_line_rec.inventory_item_id;
754: l_new_reservation.supply_source_type_id := inv_reservation_global.g_source_type_inv;
755: l_new_reservation.revision := l_grp_sugg_rec.revision;
756: l_new_reservation.lot_number := l_grp_sugg_rec.lot_number;
757: l_new_reservation.subinventory_code := l_grp_sugg_rec.from_subinventory_code;
758: l_new_reservation.locator_id := l_grp_sugg_rec.from_locator_id;