DBA Data[Home] [Help]

APPS.WMS_STRATEGY_PVT dependencies on INV_CACHE

Line 264: IF inv_cache.set_mol_rec(p_transaction_temp_id) THEN

260:
261:
262: --- Added the following code as part bug fix 5265024 --
263: -- Set and get the MO line values
264: IF inv_cache.set_mol_rec(p_transaction_temp_id) THEN
265: x_transaction_type_id := inv_cache.mol_rec.transaction_type_id;
266: x_inventory_item_id := inv_cache.mol_rec.inventory_item_id;
267: x_transaction_source_type_id := inv_cache.mol_rec.transaction_source_type_id;
268:

Line 265: x_transaction_type_id := inv_cache.mol_rec.transaction_type_id;

261:
262: --- Added the following code as part bug fix 5265024 --
263: -- Set and get the MO line values
264: IF inv_cache.set_mol_rec(p_transaction_temp_id) THEN
265: x_transaction_type_id := inv_cache.mol_rec.transaction_type_id;
266: x_inventory_item_id := inv_cache.mol_rec.inventory_item_id;
267: x_transaction_source_type_id := inv_cache.mol_rec.transaction_source_type_id;
268:
269: l_transaction_action_id := inv_cache.mtt_rec.transaction_action_id;

Line 266: x_inventory_item_id := inv_cache.mol_rec.inventory_item_id;

262: --- Added the following code as part bug fix 5265024 --
263: -- Set and get the MO line values
264: IF inv_cache.set_mol_rec(p_transaction_temp_id) THEN
265: x_transaction_type_id := inv_cache.mol_rec.transaction_type_id;
266: x_inventory_item_id := inv_cache.mol_rec.inventory_item_id;
267: x_transaction_source_type_id := inv_cache.mol_rec.transaction_source_type_id;
268:
269: l_transaction_action_id := inv_cache.mtt_rec.transaction_action_id;
270:

Line 267: x_transaction_source_type_id := inv_cache.mol_rec.transaction_source_type_id;

263: -- Set and get the MO line values
264: IF inv_cache.set_mol_rec(p_transaction_temp_id) THEN
265: x_transaction_type_id := inv_cache.mol_rec.transaction_type_id;
266: x_inventory_item_id := inv_cache.mol_rec.inventory_item_id;
267: x_transaction_source_type_id := inv_cache.mol_rec.transaction_source_type_id;
268:
269: l_transaction_action_id := inv_cache.mtt_rec.transaction_action_id;
270:
271: --- This code is added to handle direct-org xfers

Line 269: l_transaction_action_id := inv_cache.mtt_rec.transaction_action_id;

265: x_transaction_type_id := inv_cache.mol_rec.transaction_type_id;
266: x_inventory_item_id := inv_cache.mol_rec.inventory_item_id;
267: x_transaction_source_type_id := inv_cache.mol_rec.transaction_source_type_id;
268:
269: l_transaction_action_id := inv_cache.mtt_rec.transaction_action_id;
270:
271: --- This code is added to handle direct-org xfers
272: IF l_transaction_action_id = 3 THEN
273: l_to_organization_id := inv_cache.mol_rec.to_organization_id;

Line 273: l_to_organization_id := inv_cache.mol_rec.to_organization_id;

269: l_transaction_action_id := inv_cache.mtt_rec.transaction_action_id;
270:
271: --- This code is added to handle direct-org xfers
272: IF l_transaction_action_id = 3 THEN
273: l_to_organization_id := inv_cache.mol_rec.to_organization_id;
274: ELSE
275: l_from_organization_id := inv_cache.mol_rec.organization_id;
276: END IF;
277:

Line 275: l_from_organization_id := inv_cache.mol_rec.organization_id;

271: --- This code is added to handle direct-org xfers
272: IF l_transaction_action_id = 3 THEN
273: l_to_organization_id := inv_cache.mol_rec.to_organization_id;
274: ELSE
275: l_from_organization_id := inv_cache.mol_rec.organization_id;
276: END IF;
277:
278: IF p_type_code = 1 AND l_transaction_action_id = 3 THEN
279: x_organization_id := l_to_organization_id;

Line 284: x_transaction_uom := inv_cache.mol_rec.uom_code;

280: ELSE
281: x_organization_id := l_from_organization_id;
282: END IF;
283:
284: x_transaction_uom := inv_cache.mol_rec.uom_code;
285: -- Change for bug 9836630. Clearing cache.
286:
287: IF inv_cache.set_item_rec(inv_cache.mol_rec.organization_id, inv_cache.mol_rec.inventory_item_id) THEN
288:

Line 287: IF inv_cache.set_item_rec(inv_cache.mol_rec.organization_id, inv_cache.mol_rec.inventory_item_id) THEN

283:
284: x_transaction_uom := inv_cache.mol_rec.uom_code;
285: -- Change for bug 9836630. Clearing cache.
286:
287: IF inv_cache.set_item_rec(inv_cache.mol_rec.organization_id, inv_cache.mol_rec.inventory_item_id) THEN
288:
289: IF (l_debug = 1) THEN
290: log_procedure(l_api_name,'start', 'Primary UOM for the Item:'||inv_cache.item_rec.primary_uom_code);
291: log_procedure(l_api_name,'start', 'Secondary UOM for the Item:'||inv_cache.item_rec.secondary_uom_code);

Line 290: log_procedure(l_api_name,'start', 'Primary UOM for the Item:'||inv_cache.item_rec.primary_uom_code);

286:
287: IF inv_cache.set_item_rec(inv_cache.mol_rec.organization_id, inv_cache.mol_rec.inventory_item_id) THEN
288:
289: IF (l_debug = 1) THEN
290: log_procedure(l_api_name,'start', 'Primary UOM for the Item:'||inv_cache.item_rec.primary_uom_code);
291: log_procedure(l_api_name,'start', 'Secondary UOM for the Item:'||inv_cache.item_rec.secondary_uom_code);
292: END IF;
293: x_primary_uom := inv_cache.item_rec.primary_uom_code;
294: x_secondary_uom := inv_cache.item_rec.secondary_uom_code ;

Line 291: log_procedure(l_api_name,'start', 'Secondary UOM for the Item:'||inv_cache.item_rec.secondary_uom_code);

287: IF inv_cache.set_item_rec(inv_cache.mol_rec.organization_id, inv_cache.mol_rec.inventory_item_id) THEN
288:
289: IF (l_debug = 1) THEN
290: log_procedure(l_api_name,'start', 'Primary UOM for the Item:'||inv_cache.item_rec.primary_uom_code);
291: log_procedure(l_api_name,'start', 'Secondary UOM for the Item:'||inv_cache.item_rec.secondary_uom_code);
292: END IF;
293: x_primary_uom := inv_cache.item_rec.primary_uom_code;
294: x_secondary_uom := inv_cache.item_rec.secondary_uom_code ;
295: END IF;

Line 293: x_primary_uom := inv_cache.item_rec.primary_uom_code;

289: IF (l_debug = 1) THEN
290: log_procedure(l_api_name,'start', 'Primary UOM for the Item:'||inv_cache.item_rec.primary_uom_code);
291: log_procedure(l_api_name,'start', 'Secondary UOM for the Item:'||inv_cache.item_rec.secondary_uom_code);
292: END IF;
293: x_primary_uom := inv_cache.item_rec.primary_uom_code;
294: x_secondary_uom := inv_cache.item_rec.secondary_uom_code ;
295: END IF;
296:
297: open inphead1;

Line 294: x_secondary_uom := inv_cache.item_rec.secondary_uom_code ;

290: log_procedure(l_api_name,'start', 'Primary UOM for the Item:'||inv_cache.item_rec.primary_uom_code);
291: log_procedure(l_api_name,'start', 'Secondary UOM for the Item:'||inv_cache.item_rec.secondary_uom_code);
292: END IF;
293: x_primary_uom := inv_cache.item_rec.primary_uom_code;
294: x_secondary_uom := inv_cache.item_rec.secondary_uom_code ;
295: END IF;
296:
297: open inphead1;
298: fetch inphead1 into

Line 2018: l_wms_installed := INV_CACHE.wms_installed;

2014: IF (g_debug IS NULL) THEN
2015: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2016: END IF;
2017: l_debug := g_debug;
2018: l_wms_installed := INV_CACHE.wms_installed;
2019:
2020:
2021: IF p_quick_pick_flag = 'Q' THEN
2022: l_qty_tree_allowed := 'N' ;

Line 2102: If inv_cache.is_pickrelease then

2098: end if;
2099:
2100: --Added for bug3237702
2101: -- Check whether this is a pick release process and if locator is specified
2102: If inv_cache.is_pickrelease then
2103: is_pickrelease := true;
2104: l_req_locator_id := inv_cache.tolocator_id;
2105: l_req_subinventory_code := inv_cache.tosubinventory_code;
2106: ELSIF p_wave_simulation_mode = 'Y' THEN

Line 2104: l_req_locator_id := inv_cache.tolocator_id;

2100: --Added for bug3237702
2101: -- Check whether this is a pick release process and if locator is specified
2102: If inv_cache.is_pickrelease then
2103: is_pickrelease := true;
2104: l_req_locator_id := inv_cache.tolocator_id;
2105: l_req_subinventory_code := inv_cache.tosubinventory_code;
2106: ELSIF p_wave_simulation_mode = 'Y' THEN
2107: l_req_locator_id := inv_cache.tolocator_id;
2108: l_req_subinventory_code := inv_cache.tosubinventory_code;

Line 2105: l_req_subinventory_code := inv_cache.tosubinventory_code;

2101: -- Check whether this is a pick release process and if locator is specified
2102: If inv_cache.is_pickrelease then
2103: is_pickrelease := true;
2104: l_req_locator_id := inv_cache.tolocator_id;
2105: l_req_subinventory_code := inv_cache.tosubinventory_code;
2106: ELSIF p_wave_simulation_mode = 'Y' THEN
2107: l_req_locator_id := inv_cache.tolocator_id;
2108: l_req_subinventory_code := inv_cache.tosubinventory_code;
2109: End if;

Line 2107: l_req_locator_id := inv_cache.tolocator_id;

2103: is_pickrelease := true;
2104: l_req_locator_id := inv_cache.tolocator_id;
2105: l_req_subinventory_code := inv_cache.tosubinventory_code;
2106: ELSIF p_wave_simulation_mode = 'Y' THEN
2107: l_req_locator_id := inv_cache.tolocator_id;
2108: l_req_subinventory_code := inv_cache.tosubinventory_code;
2109: End if;
2110: --bug3237702 ends
2111:

Line 2108: l_req_subinventory_code := inv_cache.tosubinventory_code;

2104: l_req_locator_id := inv_cache.tolocator_id;
2105: l_req_subinventory_code := inv_cache.tosubinventory_code;
2106: ELSIF p_wave_simulation_mode = 'Y' THEN
2107: l_req_locator_id := inv_cache.tolocator_id;
2108: l_req_subinventory_code := inv_cache.tosubinventory_code;
2109: End if;
2110: --bug3237702 ends
2111:
2112: -- make sure, everything is clean

Line 2116: l_lot_divisible_flag := inv_cache.item_rec.lot_divisible_flag;

2112: -- make sure, everything is clean
2113: FreeGlobals;
2114:
2115: -- [ Initilizing the lot control valuse from cache
2116: l_lot_divisible_flag := inv_cache.item_rec.lot_divisible_flag;
2117: l_lot_control_code := inv_cache.item_rec.lot_control_code;
2118: -- ]
2119:
2120: --if simulation mode is put away rule, but we are doing picking,

Line 2117: l_lot_control_code := inv_cache.item_rec.lot_control_code;

2113: FreeGlobals;
2114:
2115: -- [ Initilizing the lot control valuse from cache
2116: l_lot_divisible_flag := inv_cache.item_rec.lot_divisible_flag;
2117: l_lot_control_code := inv_cache.item_rec.lot_control_code;
2118: -- ]
2119:
2120: --if simulation mode is put away rule, but we are doing picking,
2121: -- ignore simulation modea