DBA Data[Home] [Help]

APPS.INV_DETAIL_UTIL_PVT dependencies on INV_CACHE

Line 263: If (inv_cache.set_mtt_rec(l_txn_type_id) AND

259: l_primary_quantity := x_request_line_rec.primary_quantity;
260: l_txn_type_id := x_request_line_rec.transaction_type_id;
261: l_inventory_item_id := x_request_line_rec.inventory_item_id;
262: l_organization_id := x_request_line_rec.organization_id;
263: If (inv_cache.set_mtt_rec(l_txn_type_id) AND
264: inv_cache.set_item_rec(l_organization_id, l_inventory_item_id) AND
265: inv_cache.set_org_rec(l_organization_id)) THEN
266:
267: print_debug('initing request_context ');

Line 264: inv_cache.set_item_rec(l_organization_id, l_inventory_item_id) AND

260: l_txn_type_id := x_request_line_rec.transaction_type_id;
261: l_inventory_item_id := x_request_line_rec.inventory_item_id;
262: l_organization_id := x_request_line_rec.organization_id;
263: If (inv_cache.set_mtt_rec(l_txn_type_id) AND
264: inv_cache.set_item_rec(l_organization_id, l_inventory_item_id) AND
265: inv_cache.set_org_rec(l_organization_id)) THEN
266:
267: print_debug('initing request_context ');
268: x_request_context.transaction_action_id := inv_cache.mtt_rec.transaction_action_id;

Line 265: inv_cache.set_org_rec(l_organization_id)) THEN

261: l_inventory_item_id := x_request_line_rec.inventory_item_id;
262: l_organization_id := x_request_line_rec.organization_id;
263: If (inv_cache.set_mtt_rec(l_txn_type_id) AND
264: inv_cache.set_item_rec(l_organization_id, l_inventory_item_id) AND
265: inv_cache.set_org_rec(l_organization_id)) THEN
266:
267: print_debug('initing request_context ');
268: x_request_context.transaction_action_id := inv_cache.mtt_rec.transaction_action_id;
269: x_request_context.transaction_source_type_id := inv_cache.mtt_rec.transaction_source_type_id;

Line 268: x_request_context.transaction_action_id := inv_cache.mtt_rec.transaction_action_id;

264: inv_cache.set_item_rec(l_organization_id, l_inventory_item_id) AND
265: inv_cache.set_org_rec(l_organization_id)) THEN
266:
267: print_debug('initing request_context ');
268: x_request_context.transaction_action_id := inv_cache.mtt_rec.transaction_action_id;
269: x_request_context.transaction_source_type_id := inv_cache.mtt_rec.transaction_source_type_id;
270: x_request_context.primary_uom_code := inv_cache.item_rec.primary_uom_code;
271: x_request_context.secondary_uom_code := inv_cache.item_rec.secondary_uom_code;
272: x_request_context.item_revision_control := inv_cache.item_rec.revision_qty_control_code;

Line 269: x_request_context.transaction_source_type_id := inv_cache.mtt_rec.transaction_source_type_id;

265: inv_cache.set_org_rec(l_organization_id)) THEN
266:
267: print_debug('initing request_context ');
268: x_request_context.transaction_action_id := inv_cache.mtt_rec.transaction_action_id;
269: x_request_context.transaction_source_type_id := inv_cache.mtt_rec.transaction_source_type_id;
270: x_request_context.primary_uom_code := inv_cache.item_rec.primary_uom_code;
271: x_request_context.secondary_uom_code := inv_cache.item_rec.secondary_uom_code;
272: x_request_context.item_revision_control := inv_cache.item_rec.revision_qty_control_code;
273: x_request_context.item_lot_control_code := inv_cache.item_rec.lot_control_code;

Line 270: x_request_context.primary_uom_code := inv_cache.item_rec.primary_uom_code;

266:
267: print_debug('initing request_context ');
268: x_request_context.transaction_action_id := inv_cache.mtt_rec.transaction_action_id;
269: x_request_context.transaction_source_type_id := inv_cache.mtt_rec.transaction_source_type_id;
270: x_request_context.primary_uom_code := inv_cache.item_rec.primary_uom_code;
271: x_request_context.secondary_uom_code := inv_cache.item_rec.secondary_uom_code;
272: x_request_context.item_revision_control := inv_cache.item_rec.revision_qty_control_code;
273: x_request_context.item_lot_control_code := inv_cache.item_rec.lot_control_code;
274: x_request_context.item_serial_control_code := inv_cache.item_rec.serial_number_control_code;

Line 271: x_request_context.secondary_uom_code := inv_cache.item_rec.secondary_uom_code;

267: print_debug('initing request_context ');
268: x_request_context.transaction_action_id := inv_cache.mtt_rec.transaction_action_id;
269: x_request_context.transaction_source_type_id := inv_cache.mtt_rec.transaction_source_type_id;
270: x_request_context.primary_uom_code := inv_cache.item_rec.primary_uom_code;
271: x_request_context.secondary_uom_code := inv_cache.item_rec.secondary_uom_code;
272: x_request_context.item_revision_control := inv_cache.item_rec.revision_qty_control_code;
273: x_request_context.item_lot_control_code := inv_cache.item_rec.lot_control_code;
274: x_request_context.item_serial_control_code := inv_cache.item_rec.serial_number_control_code;
275: x_request_context.item_locator_control_code := inv_cache.item_rec.location_control_code;

Line 272: x_request_context.item_revision_control := inv_cache.item_rec.revision_qty_control_code;

268: x_request_context.transaction_action_id := inv_cache.mtt_rec.transaction_action_id;
269: x_request_context.transaction_source_type_id := inv_cache.mtt_rec.transaction_source_type_id;
270: x_request_context.primary_uom_code := inv_cache.item_rec.primary_uom_code;
271: x_request_context.secondary_uom_code := inv_cache.item_rec.secondary_uom_code;
272: x_request_context.item_revision_control := inv_cache.item_rec.revision_qty_control_code;
273: x_request_context.item_lot_control_code := inv_cache.item_rec.lot_control_code;
274: x_request_context.item_serial_control_code := inv_cache.item_rec.serial_number_control_code;
275: x_request_context.item_locator_control_code := inv_cache.item_rec.location_control_code;
276: x_request_context.org_locator_control_code := inv_cache.org_rec.stock_locator_control_code;

Line 273: x_request_context.item_lot_control_code := inv_cache.item_rec.lot_control_code;

269: x_request_context.transaction_source_type_id := inv_cache.mtt_rec.transaction_source_type_id;
270: x_request_context.primary_uom_code := inv_cache.item_rec.primary_uom_code;
271: x_request_context.secondary_uom_code := inv_cache.item_rec.secondary_uom_code;
272: x_request_context.item_revision_control := inv_cache.item_rec.revision_qty_control_code;
273: x_request_context.item_lot_control_code := inv_cache.item_rec.lot_control_code;
274: x_request_context.item_serial_control_code := inv_cache.item_rec.serial_number_control_code;
275: x_request_context.item_locator_control_code := inv_cache.item_rec.location_control_code;
276: x_request_context.org_locator_control_code := inv_cache.org_rec.stock_locator_control_code;
277: x_request_context.unit_volume := inv_cache.item_rec.unit_volume;

Line 274: x_request_context.item_serial_control_code := inv_cache.item_rec.serial_number_control_code;

270: x_request_context.primary_uom_code := inv_cache.item_rec.primary_uom_code;
271: x_request_context.secondary_uom_code := inv_cache.item_rec.secondary_uom_code;
272: x_request_context.item_revision_control := inv_cache.item_rec.revision_qty_control_code;
273: x_request_context.item_lot_control_code := inv_cache.item_rec.lot_control_code;
274: x_request_context.item_serial_control_code := inv_cache.item_rec.serial_number_control_code;
275: x_request_context.item_locator_control_code := inv_cache.item_rec.location_control_code;
276: x_request_context.org_locator_control_code := inv_cache.org_rec.stock_locator_control_code;
277: x_request_context.unit_volume := inv_cache.item_rec.unit_volume;
278: x_request_context.volume_uom_code := inv_cache.item_rec.volume_uom_code;

Line 275: x_request_context.item_locator_control_code := inv_cache.item_rec.location_control_code;

271: x_request_context.secondary_uom_code := inv_cache.item_rec.secondary_uom_code;
272: x_request_context.item_revision_control := inv_cache.item_rec.revision_qty_control_code;
273: x_request_context.item_lot_control_code := inv_cache.item_rec.lot_control_code;
274: x_request_context.item_serial_control_code := inv_cache.item_rec.serial_number_control_code;
275: x_request_context.item_locator_control_code := inv_cache.item_rec.location_control_code;
276: x_request_context.org_locator_control_code := inv_cache.org_rec.stock_locator_control_code;
277: x_request_context.unit_volume := inv_cache.item_rec.unit_volume;
278: x_request_context.volume_uom_code := inv_cache.item_rec.volume_uom_code;
279: x_request_context.unit_weight := inv_cache.item_rec.unit_weight;

Line 276: x_request_context.org_locator_control_code := inv_cache.org_rec.stock_locator_control_code;

272: x_request_context.item_revision_control := inv_cache.item_rec.revision_qty_control_code;
273: x_request_context.item_lot_control_code := inv_cache.item_rec.lot_control_code;
274: x_request_context.item_serial_control_code := inv_cache.item_rec.serial_number_control_code;
275: x_request_context.item_locator_control_code := inv_cache.item_rec.location_control_code;
276: x_request_context.org_locator_control_code := inv_cache.org_rec.stock_locator_control_code;
277: x_request_context.unit_volume := inv_cache.item_rec.unit_volume;
278: x_request_context.volume_uom_code := inv_cache.item_rec.volume_uom_code;
279: x_request_context.unit_weight := inv_cache.item_rec.unit_weight;
280: x_request_context.weight_uom_code := inv_cache.item_rec.weight_uom_code;

Line 277: x_request_context.unit_volume := inv_cache.item_rec.unit_volume;

273: x_request_context.item_lot_control_code := inv_cache.item_rec.lot_control_code;
274: x_request_context.item_serial_control_code := inv_cache.item_rec.serial_number_control_code;
275: x_request_context.item_locator_control_code := inv_cache.item_rec.location_control_code;
276: x_request_context.org_locator_control_code := inv_cache.org_rec.stock_locator_control_code;
277: x_request_context.unit_volume := inv_cache.item_rec.unit_volume;
278: x_request_context.volume_uom_code := inv_cache.item_rec.volume_uom_code;
279: x_request_context.unit_weight := inv_cache.item_rec.unit_weight;
280: x_request_context.weight_uom_code := inv_cache.item_rec.weight_uom_code;
281: x_request_context.item_reservable_type := inv_cache.item_rec.reservable_type;

Line 278: x_request_context.volume_uom_code := inv_cache.item_rec.volume_uom_code;

274: x_request_context.item_serial_control_code := inv_cache.item_rec.serial_number_control_code;
275: x_request_context.item_locator_control_code := inv_cache.item_rec.location_control_code;
276: x_request_context.org_locator_control_code := inv_cache.org_rec.stock_locator_control_code;
277: x_request_context.unit_volume := inv_cache.item_rec.unit_volume;
278: x_request_context.volume_uom_code := inv_cache.item_rec.volume_uom_code;
279: x_request_context.unit_weight := inv_cache.item_rec.unit_weight;
280: x_request_context.weight_uom_code := inv_cache.item_rec.weight_uom_code;
281: x_request_context.item_reservable_type := inv_cache.item_rec.reservable_type;
282: l_end_assembly_pegging_flag := NVL(inv_cache.item_rec.end_assembly_pegging_flag,'N');

Line 279: x_request_context.unit_weight := inv_cache.item_rec.unit_weight;

275: x_request_context.item_locator_control_code := inv_cache.item_rec.location_control_code;
276: x_request_context.org_locator_control_code := inv_cache.org_rec.stock_locator_control_code;
277: x_request_context.unit_volume := inv_cache.item_rec.unit_volume;
278: x_request_context.volume_uom_code := inv_cache.item_rec.volume_uom_code;
279: x_request_context.unit_weight := inv_cache.item_rec.unit_weight;
280: x_request_context.weight_uom_code := inv_cache.item_rec.weight_uom_code;
281: x_request_context.item_reservable_type := inv_cache.item_rec.reservable_type;
282: l_end_assembly_pegging_flag := NVL(inv_cache.item_rec.end_assembly_pegging_flag,'N');
283: l_allocate_serial_flag := inv_cache.org_rec.allocate_serial_flag;

Line 280: x_request_context.weight_uom_code := inv_cache.item_rec.weight_uom_code;

276: x_request_context.org_locator_control_code := inv_cache.org_rec.stock_locator_control_code;
277: x_request_context.unit_volume := inv_cache.item_rec.unit_volume;
278: x_request_context.volume_uom_code := inv_cache.item_rec.volume_uom_code;
279: x_request_context.unit_weight := inv_cache.item_rec.unit_weight;
280: x_request_context.weight_uom_code := inv_cache.item_rec.weight_uom_code;
281: x_request_context.item_reservable_type := inv_cache.item_rec.reservable_type;
282: l_end_assembly_pegging_flag := NVL(inv_cache.item_rec.end_assembly_pegging_flag,'N');
283: l_allocate_serial_flag := inv_cache.org_rec.allocate_serial_flag;
284: ELSE

Line 281: x_request_context.item_reservable_type := inv_cache.item_rec.reservable_type;

277: x_request_context.unit_volume := inv_cache.item_rec.unit_volume;
278: x_request_context.volume_uom_code := inv_cache.item_rec.volume_uom_code;
279: x_request_context.unit_weight := inv_cache.item_rec.unit_weight;
280: x_request_context.weight_uom_code := inv_cache.item_rec.weight_uom_code;
281: x_request_context.item_reservable_type := inv_cache.item_rec.reservable_type;
282: l_end_assembly_pegging_flag := NVL(inv_cache.item_rec.end_assembly_pegging_flag,'N');
283: l_allocate_serial_flag := inv_cache.org_rec.allocate_serial_flag;
284: ELSE
285: print_debug('init request_context no data found');

Line 282: l_end_assembly_pegging_flag := NVL(inv_cache.item_rec.end_assembly_pegging_flag,'N');

278: x_request_context.volume_uom_code := inv_cache.item_rec.volume_uom_code;
279: x_request_context.unit_weight := inv_cache.item_rec.unit_weight;
280: x_request_context.weight_uom_code := inv_cache.item_rec.weight_uom_code;
281: x_request_context.item_reservable_type := inv_cache.item_rec.reservable_type;
282: l_end_assembly_pegging_flag := NVL(inv_cache.item_rec.end_assembly_pegging_flag,'N');
283: l_allocate_serial_flag := inv_cache.org_rec.allocate_serial_flag;
284: ELSE
285: print_debug('init request_context no data found');
286: IF inv_pp_debug.is_debug_mode THEN

Line 283: l_allocate_serial_flag := inv_cache.org_rec.allocate_serial_flag;

279: x_request_context.unit_weight := inv_cache.item_rec.unit_weight;
280: x_request_context.weight_uom_code := inv_cache.item_rec.weight_uom_code;
281: x_request_context.item_reservable_type := inv_cache.item_rec.reservable_type;
282: l_end_assembly_pegging_flag := NVL(inv_cache.item_rec.end_assembly_pegging_flag,'N');
283: l_allocate_serial_flag := inv_cache.org_rec.allocate_serial_flag;
284: ELSE
285: print_debug('init request_context no data found');
286: IF inv_pp_debug.is_debug_mode THEN
287: inv_pp_debug.send_message_to_pipe('mo context not found');

Line 367: print_debug('inv_cache.item_rec.tracking_quantity_ind '||inv_cache.item_rec.tracking_quantity_ind);

363:
364: l_quantity_to_detail := x_request_line_rec.quantity;
365:
366: /* Start Bug 9172258 */
367: print_debug('inv_cache.item_rec.tracking_quantity_ind '||inv_cache.item_rec.tracking_quantity_ind);
368: print_debug('(1)x_request_line_rec.secondary_quantity '||x_request_line_rec.secondary_quantity);
369: IF (inv_cache.item_rec.tracking_quantity_ind = 'PS') THEN
370: -- this item is dual UOM
371: l_secondary_quantity_to_detail := x_request_line_rec.secondary_quantity;

Line 369: IF (inv_cache.item_rec.tracking_quantity_ind = 'PS') THEN

365:
366: /* Start Bug 9172258 */
367: print_debug('inv_cache.item_rec.tracking_quantity_ind '||inv_cache.item_rec.tracking_quantity_ind);
368: print_debug('(1)x_request_line_rec.secondary_quantity '||x_request_line_rec.secondary_quantity);
369: IF (inv_cache.item_rec.tracking_quantity_ind = 'PS') THEN
370: -- this item is dual UOM
371: l_secondary_quantity_to_detail := x_request_line_rec.secondary_quantity;
372: END IF;
373: /* End Bug 9172258 */

Line 380: IF (inv_cache.item_rec.tracking_quantity_ind = 'PS') THEN

376: x_request_line_rec.required_quantity < l_quantity_to_detail THEN
377:
378: l_quantity_to_detail := x_request_line_rec.required_quantity;
379: /* Start Bug 9172258 */
380: IF (inv_cache.item_rec.tracking_quantity_ind = 'PS') THEN
381: -- this item is dual UOM
382: l_secondary_quantity_to_detail := x_request_line_rec.secondary_required_quantity;
383: END IF;
384: /* End Bug 9172258 */

Line 424: IF (inv_cache.item_rec.tracking_quantity_ind = 'PS') THEN

420: /* Start Bug 9172258 */
421: print_debug('l_secondary_quantity_to_detail '||l_secondary_quantity_to_detail);
422: print_debug('x_request_line_rec.secondary_quantity_detailed '||x_request_line_rec.secondary_quantity_detailed);
423: print_debug('x_request_line_rec.secondary_quantity_delivered '||x_request_line_rec.secondary_quantity_delivered);
424: IF (inv_cache.item_rec.tracking_quantity_ind = 'PS') THEN
425: -- this item is dual UOM
426: x_request_line_rec.secondary_quantity := l_secondary_quantity_to_detail -
427: greatest(NVL(x_request_line_rec.secondary_quantity_detailed ,0),
428: NVL(x_request_line_rec.secondary_quantity_delivered,0));

Line 1302: AND (inv_cache.is_pickrelease)) THEN --Bug 5246569

1298: IF p_subinventory_code IS NOT NULL THEN
1299: -- get status
1300: IF (nvl(g_isllta_subinventory_code,'@@@') = p_subinventory_code
1301: AND nvl(g_isllta_transaction_type_id, -1) = p_transaction_type_id
1302: AND (inv_cache.is_pickrelease)) THEN --Bug 5246569
1303: l_sub_return := g_sub_return;
1304: ELSE
1305: OPEN c_sub_status;
1306: FETCH c_sub_status INTO l_sub_status;

Line 1340: AND (inv_cache.is_pickrelease)) THEN --Bug 5246569

1336: IF p_locator_id IS NOT NULL THEN
1337: --get status
1338: IF (nvl(g_isllta_locator_id,-1) = p_locator_id
1339: AND nvl(g_isllta_transaction_type_id, -1) = p_transaction_type_id
1340: AND (inv_cache.is_pickrelease)) THEN --Bug 5246569
1341: l_loc_return := g_loc_return;
1342: ELSE
1343: OPEN c_loc_status;
1344: FETCH c_loc_status INTO l_loc_status;

Line 1396: AND (inv_cache.is_pickrelease)) THEN --Bug 5246569

1392: if l_lot_status_enabled = 'Y' AND p_lot_number IS NOT NULL THEN
1393: --get status
1394: IF (nvl(g_isllta_lot_number,'@@@') = p_lot_number
1395: AND nvl(g_isllta_transaction_type_id, -1) = p_transaction_type_id
1396: AND (inv_cache.is_pickrelease)) THEN --Bug 5246569
1397: l_lot_return := g_lot_return;
1398: ELSE
1399: OPEN c_lot_status;
1400: FETCH c_lot_status INTO l_lot_status;

Line 1815: IF g_debug IS NULL or NOT INV_CACHE.is_pickrelease THEN

1811: x_return_status := fnd_api.g_ret_sts_success ;
1812: x_available_sl_qty := 0;
1813: x_serial_index := 0;
1814:
1815: IF g_debug IS NULL or NOT INV_CACHE.is_pickrelease THEN
1816: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),2);
1817: END IF;
1818: l_debug := g_debug;
1819:

Line 1826: IF ( inv_cache.set_org_rec(p_organization_id) ) THEN

1822: print_debug('orgid='||p_organization_id||' itm='||p_inventory_item_id||' rev='||p_revision||' lot='||p_lot_number||' sub='||p_subinventory_code||' loc='||p_locator_id||' qty='||p_required_sl_qty||' fmsn='||p_from_range||' tosn='||p_to_range, 4);
1823: print_debug('unt='||p_unit_number||' det='||p_detail_any_serial||' cg='||p_cost_group_id||' trxtyp='||p_transaction_type_id||' styp='||p_demand_source_type_id||' shdr='||p_demand_source_header_id||' sln='||p_demand_source_line_id, 4);
1824: END IF;
1825:
1826: IF ( inv_cache.set_org_rec(p_organization_id) ) THEN
1827: l_allocate_serial_flag := inv_cache.org_rec.allocate_serial_flag;
1828: IF ( l_debug = 1 ) THEN
1829: print_debug('allocate_serial_flag= '||l_allocate_serial_flag);
1830: END IF;

Line 1827: l_allocate_serial_flag := inv_cache.org_rec.allocate_serial_flag;

1823: print_debug('unt='||p_unit_number||' det='||p_detail_any_serial||' cg='||p_cost_group_id||' trxtyp='||p_transaction_type_id||' styp='||p_demand_source_type_id||' shdr='||p_demand_source_header_id||' sln='||p_demand_source_line_id, 4);
1824: END IF;
1825:
1826: IF ( inv_cache.set_org_rec(p_organization_id) ) THEN
1827: l_allocate_serial_flag := inv_cache.org_rec.allocate_serial_flag;
1828: IF ( l_debug = 1 ) THEN
1829: print_debug('allocate_serial_flag= '||l_allocate_serial_flag);
1830: END IF;
1831: ELSE

Line 3266: IF g_debug IS NULL or NOT INV_CACHE.is_pickrelease THEN

3262: inv_pp_debug.send_message_to_pipe('enter '||g_pkg_name||'.'||l_api_name);
3263: END IF;
3264: -- end of debugging section
3265: --
3266: IF g_debug IS NULL or NOT INV_CACHE.is_pickrelease THEN
3267: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),2);
3268: END IF;
3269: l_debug := g_debug;
3270:

Line 3822: l_today := nvl(inv_cache.mo_transaction_date, SYSDATE);

3818: END IF;
3819:
3820: --l_mmtt_tbl(l_mmtt_tbl_size).transaction_source_name :=
3821: -- p_request_line_rec.transaction_source_name;
3822: l_today := nvl(inv_cache.mo_transaction_date, SYSDATE);
3823:
3824: l_mmtt_tbl(l_mmtt_tbl_size).transaction_date := l_today;
3825: -- get accounting period id
3826: IF p_request_context.transfer_flag -- transfer

Line 3880: l_task_priority := NVL(inv_cache.wpb_rec.task_priority,-1);

3876: ELSIF p_request_context.item_serial_control_code <> 1 THEN
3877: l_mmtt_tbl(l_mmtt_tbl_size).serial_allocated_flag := 'N';
3878: END IF;
3879: -- 4292157: task priority project
3880: l_task_priority := NVL(inv_cache.wpb_rec.task_priority,-1);
3881: IF l_task_priority > 0 AND inv_cache.wms_installed
3882: THEN
3883: l_mmtt_tbl(l_mmtt_tbl_size).task_priority := l_task_priority;
3884: END IF;

Line 3881: IF l_task_priority > 0 AND inv_cache.wms_installed

3877: l_mmtt_tbl(l_mmtt_tbl_size).serial_allocated_flag := 'N';
3878: END IF;
3879: -- 4292157: task priority project
3880: l_task_priority := NVL(inv_cache.wpb_rec.task_priority,-1);
3881: IF l_task_priority > 0 AND inv_cache.wms_installed
3882: THEN
3883: l_mmtt_tbl(l_mmtt_tbl_size).task_priority := l_task_priority;
3884: END IF;
3885:

Line 3907: IF inv_cache.set_mtt_rec(p_request_line_rec.transaction_type_id) THEN

3903: p_request_line_rec.project_id;
3904: l_mmtt_tbl(l_mmtt_tbl_size).source_task_id :=
3905: p_request_line_rec.task_id;
3906: ELSE
3907: IF inv_cache.set_mtt_rec(p_request_line_rec.transaction_type_id) THEN
3908: l_proj_enabled := NVL(inv_cache.mtt_rec.type_class,2);
3909: END IF;
3910:
3911: --find out if network logistics is installed

Line 3908: l_proj_enabled := NVL(inv_cache.mtt_rec.type_class,2);

3904: l_mmtt_tbl(l_mmtt_tbl_size).source_task_id :=
3905: p_request_line_rec.task_id;
3906: ELSE
3907: IF inv_cache.set_mtt_rec(p_request_line_rec.transaction_type_id) THEN
3908: l_proj_enabled := NVL(inv_cache.mtt_rec.type_class,2);
3909: END IF;
3910:
3911: --find out if network logistics is installed
3912: IF g_nl_installed is NULL THEN

Line 4240: inv_cache.mo_transaction_date := p_date;

4236:
4237: PROCEDURE set_mo_transact_date (
4238: p_date IN DATE) IS
4239: BEGIN
4240: inv_cache.mo_transaction_date := p_date;
4241: END;
4242:
4243: PROCEDURE clear_mo_transact_date IS
4244: BEGIN

Line 4245: inv_cache.mo_transaction_date := NULL;

4241: END;
4242:
4243: PROCEDURE clear_mo_transact_date IS
4244: BEGIN
4245: inv_cache.mo_transaction_date := NULL;
4246: END;
4247:
4248:
4249: -- LPN Status Project