APPS.INV_PHY_INV_LOVS dependencies on INV_CACHE

Line 2465: IF inv_cache.set_item_rec(i.organization_id,i.inventory_item_id) THEN

2461: l_rec_count := l_rec_count+1;
2462:
2463: Mydebug(' Inside IF ... Phy Adj Id: ' || i.xfr_adjustment_id);
2464:
2465: IF inv_cache.set_item_rec(i.organization_id,i.inventory_item_id) THEN
2466: l_uom_code := inv_cache.item_rec.primary_uom_code;
2467: l_sec_uom_code := inv_cache.item_rec.secondary_uom_code;
2468: ELSE
2469: Mydebug(' Errors while fetching UOM : ' || substr(sqlerrm,1,100));

Line 2466: l_uom_code := inv_cache.item_rec.primary_uom_code;

2462:
2463: Mydebug(' Inside IF ... Phy Adj Id: ' || i.xfr_adjustment_id);
2464:
2465: IF inv_cache.set_item_rec(i.organization_id,i.inventory_item_id) THEN
2466: l_uom_code := inv_cache.item_rec.primary_uom_code;
2467: l_sec_uom_code := inv_cache.item_rec.secondary_uom_code;
2468: ELSE
2469: Mydebug(' Errors while fetching UOM : ' || substr(sqlerrm,1,100));
2470: app_exception.raise_exception;

Line 2467: l_sec_uom_code := inv_cache.item_rec.secondary_uom_code;

2463: Mydebug(' Inside IF ... Phy Adj Id: ' || i.xfr_adjustment_id);
2464:
2465: IF inv_cache.set_item_rec(i.organization_id,i.inventory_item_id) THEN
2466: l_uom_code := inv_cache.item_rec.primary_uom_code;
2467: l_sec_uom_code := inv_cache.item_rec.secondary_uom_code;
2468: ELSE
2469: Mydebug(' Errors while fetching UOM : ' || substr(sqlerrm,1,100));
2470: app_exception.raise_exception;
2471: x_proc_status := -99;