APPS.INV_FLEX_LOT_ALLOCATION_PUB dependencies on INV_CACHE

Line 50: IF inv_cache.set_item_rec(P_ORGANIZATION_ID, P_INVENTORY_ITEM_ID) THEN

46: RETURN 'Y';
47: END IF;
48:
49: --If an item already has allocation without lots, we will not allocate lots for new allocations
50: IF inv_cache.set_item_rec(P_ORGANIZATION_ID, P_INVENTORY_ITEM_ID) THEN
51: IF inv_cache.item_rec.lot_control_code = 2 THEN
52: begin
53: select 'Y' into l_existSgstWithoutLot
54: from MTL_MATERIAL_TRANSACTIONS_TEMP MMTT

Line 51: IF inv_cache.item_rec.lot_control_code = 2 THEN

47: END IF;
48:
49: --If an item already has allocation without lots, we will not allocate lots for new allocations
50: IF inv_cache.set_item_rec(P_ORGANIZATION_ID, P_INVENTORY_ITEM_ID) THEN
51: IF inv_cache.item_rec.lot_control_code = 2 THEN
52: begin
53: select 'Y' into l_existSgstWithoutLot
54: from MTL_MATERIAL_TRANSACTIONS_TEMP MMTT
55: where INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID

Line 72: IF inv_cache.set_org_rec(p_organization_id) THEN

68: END IF;
69: END IF;
70:
71: --Get real allocate_lot_flag value
72: IF inv_cache.set_org_rec(p_organization_id) THEN
73: --Bug 16780709,Does Not enable 'Optional Lot Allocation' For OPM Organizations
74: IF NVL(inv_cache.org_rec.process_enabled_flag,'N') = 'Y' THEN
75: print_debug('OPM Organization,Does Not enable Optional Lot Allocation Feature');
76: RETURN 'Y';

Line 74: IF NVL(inv_cache.org_rec.process_enabled_flag,'N') = 'Y' THEN

70:
71: --Get real allocate_lot_flag value
72: IF inv_cache.set_org_rec(p_organization_id) THEN
73: --Bug 16780709,Does Not enable 'Optional Lot Allocation' For OPM Organizations
74: IF NVL(inv_cache.org_rec.process_enabled_flag,'N') = 'Y' THEN
75: print_debug('OPM Organization,Does Not enable Optional Lot Allocation Feature');
76: RETURN 'Y';
77: END IF;
78:

Line 79: l_allocate_lot_flag := NVL (inv_cache.org_rec.allocate_lot_flag,'Y');

75: print_debug('OPM Organization,Does Not enable Optional Lot Allocation Feature');
76: RETURN 'Y';
77: END IF;
78:
79: l_allocate_lot_flag := NVL (inv_cache.org_rec.allocate_lot_flag,'Y');
80: END IF;
81:
82:
83: --User Stub Code goes here to overwrite org parameter