eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_CONVERT dependencies on INV_CACHE

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

1434: Get Item Info. Used Cache if available.
1435: ===========================================*/
1436:
1437:
1438: IF NOT (INV_CACHE.set_item_rec(p_organization_id, p_inventory_item_id)) THEN
1439: RAISE INVALID_ITEM;
1440: END IF;
1441:
1442: /*=============================================

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

1442: /*=============================================
1443: Determine if the Deviation Check is Required.
1444: =============================================*/
1445:
1446: IF (INV_CACHE.item_rec.tracking_quantity_ind = 'PS' or
1447: INV_CACHE.item_rec.ont_pricing_qty_source = 'S') THEN
1448: /*===================================================
1449: Get uom codes when units_of_measure are sent in.
1450: ===================================================*/

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

1443: Determine if the Deviation Check is Required.
1444: =============================================*/
1445:
1446: IF (INV_CACHE.item_rec.tracking_quantity_ind = 'PS' or
1447: INV_CACHE.item_rec.ont_pricing_qty_source = 'S') THEN
1448: /*===================================================
1449: Get uom codes when units_of_measure are sent in.
1450: ===================================================*/
1451: IF (p_unit_of_measure1 IS NOT NULL) THEN

Line 1479: print_debug('secondary_default_ind : '||INV_CACHE.item_rec.secondary_default_ind , l_procname);

1475: RAISE INVALID_UOM_CONV;
1476: END IF;
1477:
1478: if (l_debug = 1) then
1479: print_debug('secondary_default_ind : '||INV_CACHE.item_rec.secondary_default_ind , l_procname);
1480: end if;
1481:
1482: /*====================================
1483: If the secondary default is fixed

Line 1492: IF (((INV_CACHE.item_rec.secondary_default_ind = 'F') OR ( INV_CACHE.item_rec.secondary_default_ind IN ('D','N')

1488: --Due to rounding to 5 places even for fixed conversion as well
1489: --there could be deviation of at most 0.00001 qty.
1490: --if the diff is more than 0.00001 then raise error.
1491:
1492: IF (((INV_CACHE.item_rec.secondary_default_ind = 'F') OR ( INV_CACHE.item_rec.secondary_default_ind IN ('D','N')
1493: AND INV_CACHE.item_rec.dual_uom_deviation_high = 0
1494: AND INV_CACHE.item_rec.dual_uom_deviation_low = 0)) AND
1495: (abs(l_converted_qty - p_quantity2) >0.00001) ) THEN
1496:

Line 1493: AND INV_CACHE.item_rec.dual_uom_deviation_high = 0

1489: --there could be deviation of at most 0.00001 qty.
1490: --if the diff is more than 0.00001 then raise error.
1491:
1492: IF (((INV_CACHE.item_rec.secondary_default_ind = 'F') OR ( INV_CACHE.item_rec.secondary_default_ind IN ('D','N')
1493: AND INV_CACHE.item_rec.dual_uom_deviation_high = 0
1494: AND INV_CACHE.item_rec.dual_uom_deviation_low = 0)) AND
1495: (abs(l_converted_qty - p_quantity2) >0.00001) ) THEN
1496:
1497: --ADM bug 9959125, reconverting sec to primary to check whether that matches instead of just checking sec qty match.

Line 1494: AND INV_CACHE.item_rec.dual_uom_deviation_low = 0)) AND

1490: --if the diff is more than 0.00001 then raise error.
1491:
1492: IF (((INV_CACHE.item_rec.secondary_default_ind = 'F') OR ( INV_CACHE.item_rec.secondary_default_ind IN ('D','N')
1493: AND INV_CACHE.item_rec.dual_uom_deviation_high = 0
1494: AND INV_CACHE.item_rec.dual_uom_deviation_low = 0)) AND
1495: (abs(l_converted_qty - p_quantity2) >0.00001) ) THEN
1496:
1497: --ADM bug 9959125, reconverting sec to primary to check whether that matches instead of just checking sec qty match.
1498: l_converted_prim_qty := inv_um_convert(p_inventory_item_id, p_lot_number,

Line 1529: print_debug('dual_uom_deviation_high : '||INV_CACHE.item_rec.dual_uom_deviation_high ||'%', l_procname);

1525: Compute upper/lower boundaries.
1526: =================================*/
1527:
1528: if (l_debug = 1) then
1529: print_debug('dual_uom_deviation_high : '||INV_CACHE.item_rec.dual_uom_deviation_high ||'%', l_procname);
1530: print_debug('dual_uom_deviation_low : '||INV_CACHE.item_rec.dual_uom_deviation_low ||'%', l_procname);
1531: end if;
1532:
1533: l_high_boundary := l_converted_qty * (1 + (INV_CACHE.item_rec.dual_uom_deviation_high/100));

Line 1530: print_debug('dual_uom_deviation_low : '||INV_CACHE.item_rec.dual_uom_deviation_low ||'%', l_procname);

1526: =================================*/
1527:
1528: if (l_debug = 1) then
1529: print_debug('dual_uom_deviation_high : '||INV_CACHE.item_rec.dual_uom_deviation_high ||'%', l_procname);
1530: print_debug('dual_uom_deviation_low : '||INV_CACHE.item_rec.dual_uom_deviation_low ||'%', l_procname);
1531: end if;
1532:
1533: l_high_boundary := l_converted_qty * (1 + (INV_CACHE.item_rec.dual_uom_deviation_high/100));
1534: l_low_boundary := l_converted_qty * (1 - (INV_CACHE.item_rec.dual_uom_deviation_low/100));

Line 1533: l_high_boundary := l_converted_qty * (1 + (INV_CACHE.item_rec.dual_uom_deviation_high/100));

1529: print_debug('dual_uom_deviation_high : '||INV_CACHE.item_rec.dual_uom_deviation_high ||'%', l_procname);
1530: print_debug('dual_uom_deviation_low : '||INV_CACHE.item_rec.dual_uom_deviation_low ||'%', l_procname);
1531: end if;
1532:
1533: l_high_boundary := l_converted_qty * (1 + (INV_CACHE.item_rec.dual_uom_deviation_high/100));
1534: l_low_boundary := l_converted_qty * (1 - (INV_CACHE.item_rec.dual_uom_deviation_low/100));
1535:
1536: if (l_debug = 1) then
1537: print_debug('Is '||p_quantity2 ||' between '|| l_low_boundary ||' and '||l_high_boundary ||'?', l_procname);

Line 1534: l_low_boundary := l_converted_qty * (1 - (INV_CACHE.item_rec.dual_uom_deviation_low/100));

1530: print_debug('dual_uom_deviation_low : '||INV_CACHE.item_rec.dual_uom_deviation_low ||'%', l_procname);
1531: end if;
1532:
1533: l_high_boundary := l_converted_qty * (1 + (INV_CACHE.item_rec.dual_uom_deviation_high/100));
1534: l_low_boundary := l_converted_qty * (1 - (INV_CACHE.item_rec.dual_uom_deviation_low/100));
1535:
1536: if (l_debug = 1) then
1537: print_debug('Is '||p_quantity2 ||' between '|| l_low_boundary ||' and '||l_high_boundary ||'?', l_procname);
1538: end if;