DBA Data[Home] [Help]

APPS.INV_CONVERT dependencies on INV_CACHE

Line 1187: IF NOT (INV_CACHE.set_item_rec(p_organization_id, p_inventory_item_id)) THEN

1183: Get Item Info. Used Cache if available.
1184: ===========================================*/
1185:
1186:
1187: IF NOT (INV_CACHE.set_item_rec(p_organization_id, p_inventory_item_id)) THEN
1188: RAISE INVALID_ITEM;
1189: END IF;
1190:
1191: /*=============================================

Line 1195: IF (INV_CACHE.item_rec.tracking_quantity_ind = 'PS' or

1191: /*=============================================
1192: Determine if the Deviation Check is Required.
1193: =============================================*/
1194:
1195: IF (INV_CACHE.item_rec.tracking_quantity_ind = 'PS' or
1196: INV_CACHE.item_rec.ont_pricing_qty_source = 'S') THEN
1197: /*===================================================
1198: Get uom codes when units_of_measure are sent in.
1199: ===================================================*/

Line 1196: INV_CACHE.item_rec.ont_pricing_qty_source = 'S') THEN

1192: Determine if the Deviation Check is Required.
1193: =============================================*/
1194:
1195: IF (INV_CACHE.item_rec.tracking_quantity_ind = 'PS' or
1196: INV_CACHE.item_rec.ont_pricing_qty_source = 'S') THEN
1197: /*===================================================
1198: Get uom codes when units_of_measure are sent in.
1199: ===================================================*/
1200: IF (p_unit_of_measure1 IS NOT NULL) THEN

Line 1231: IF (INV_CACHE.item_rec.secondary_default_ind = 'F' AND

1227: /*====================================
1228: If the secondary default is fixed
1229: make sure the quantities match.
1230: ====================================*/
1231: IF (INV_CACHE.item_rec.secondary_default_ind = 'F' AND
1232: p_quantity2 <> l_converted_qty) THEN
1233: RAISE INCORRECT_FIXED_VALUE;
1234: END IF;
1235:

Line 1241: l_converted_qty * (1 + (INV_CACHE.item_rec.dual_uom_deviation_high/100));

1237: Compute upper/lower boundaries.
1238: =================================*/
1239:
1240: l_high_boundary :=
1241: l_converted_qty * (1 + (INV_CACHE.item_rec.dual_uom_deviation_high/100));
1242: l_low_boundary :=
1243: l_converted_qty * (1 - (INV_CACHE.item_rec.dual_uom_deviation_low/100));
1244:
1245: if (l_debug = 1) then

Line 1243: l_converted_qty * (1 - (INV_CACHE.item_rec.dual_uom_deviation_low/100));

1239:
1240: l_high_boundary :=
1241: l_converted_qty * (1 + (INV_CACHE.item_rec.dual_uom_deviation_high/100));
1242: l_low_boundary :=
1243: l_converted_qty * (1 - (INV_CACHE.item_rec.dual_uom_deviation_low/100));
1244:
1245: if (l_debug = 1) then
1246: print_debug('Is '||p_quantity2 ||' between '|| l_low_boundary ||' and '||l_high_boundary ||'?', l_procname);
1247: end if;