[Home] [Help]
699: END IF;
700:
701: /* Convert the routing qty from its uom to the routing class UOM */
702: /* Routing UOM needs to be convertible to the routing class UOM */
703: l_routing_qty := INV_CONVERT.inv_um_convert(item_id => 0
704: ,precision => 5
705: ,from_quantity => l_routing_qty
706: ,from_unit => l_item_um
707: ,to_unit => l_routing_uom
756: CLOSE get_total_qty_cur;
757: IF (l_recipe_qty IS NULL) THEN
758: l_recipe_qty := -20;
759: ELSE
760: l_recipe_qty := INV_CONVERT.inv_um_convert(item_id => 0
761: ,precision => 5
762: ,from_quantity => l_recipe_qty
763: ,from_unit => l_uom
764: ,to_unit => l_routing_uom
1111: /*Bug 2880618 - Thomas Daniel */
1112: /*Need to compute only for ingredients contributing to yield */
1113: l_material_tab(i).contribute_yield_ind = 'Y' THEN
1114: -- NPD Conv.
1115: l_temp_qty := INV_CONVERT.inv_um_convert( item_id => l_material_tab(i).inventory_item_id
1116: ,precision => 9
1117: ,from_quantity => l_material_tab(i).qty
1118: ,from_unit => l_material_tab(i).detail_uom
1119: ,to_unit => x_uom
1134: /* Now let us calculate the product total quantities */
1135: FOR i IN 1..l_material_tab.COUNT LOOP
1136: IF l_material_tab(i).line_type IN (1,2) THEN
1137: -- NPD Conv.
1138: l_temp_qty := INV_CONVERT.inv_um_convert( item_id => l_material_tab(i).inventory_item_id
1139: ,precision => 9
1140: ,from_quantity => l_material_tab(i).qty
1141: ,from_unit => l_material_tab(i).detail_uom
1142: ,to_unit => x_uom
1227: l_routing_id := vRouting_Id;
1228: l_calculate_step_qty := 0;
1229: END IF;
1230: --Modified the following code for bug 13112823 by calling Calculate_Total_Qty first
1231: --if product qty is not > 0 then call INV_CONVERT.inv_um_convert.
1232: FOR rout_rec IN get_routrecipe_qty(l_formula_Id, l_routing_Id) LOOP
1233: IF(l_calculate_step_qty <> 1) THEN
1234: IF (rout_rec.rout_uom <> rout_rec.yield_typ_uom) THEN
1235: l_uom := rout_rec.rout_uom;
1242: ,x_msg_data => l_msg_data);
1243: IF l_product_qty > 0 THEN
1244: l_recipe_qty := l_product_qty;
1245: ELSE
1246: l_recipe_qty := INV_CONVERT.inv_um_convert(item_id => 0
1247: ,precision => 9
1248: ,from_quantity => rout_rec.recipe_qty
1249: ,from_unit => rout_rec.yield_typ_uom
1250: ,to_unit => rout_rec.rout_uom
1277: return x_Routing_Scale_factor;
1278:
1279: /*commented the following code for bug 13112823
1280: IF (rout_rec.rout_uom <> rout_rec.yield_typ_uom) THEN
1281: l_recipe_qty := INV_CONVERT.inv_um_convert(item_id => 0
1282: ,precision => 5
1283: ,from_quantity => rout_rec.recipe_qty
1284: ,from_unit => rout_rec.yield_typ_uom
1285: ,to_unit => rout_rec.rout_uom
1573:
1574: /* The min of max_capacity needs to derived for a step */
1575: /* Please remember if the max capacity is -ve */
1576: /* it probably means that the capcity conversion to step qty um was not set */
1577: l_max_capacity := INV_CONVERT.inv_um_convert(item_id => 0
1578: ,precision => 5
1579: ,from_quantity => nvl(Capacity_rec.max_cap,0)
1580: ,from_unit => Capacity_rec.capacity_um
1581: ,to_unit => l_step_qty_uom
1603: /* process_um but convertible to the mass_ref_um */
1604: IF (l_max_capacity < 0) THEN
1605: l_step_qty := P_step_tbl(i).step_mass_qty;
1606: l_step_qty_uom := P_step_tbl(i).step_mass_uom;
1607: l_max_capacity := INV_CONVERT.inv_um_convert(item_id => 0
1608: ,precision => 5
1609: ,from_quantity => Capacity_rec.max_cap
1610: ,from_unit => l_capacity_uom
1611: ,to_unit => l_step_qty_uom
1622: /* process_um and mass_um but convertible to the volume_ref_um */
1623: IF (l_max_capacity < 0) THEN
1624: l_step_qty := P_step_tbl(i).step_vol_qty;
1625: l_step_qty_uom := P_step_tbl(i).step_vol_uom;
1626: l_max_capacity := INV_CONVERT.inv_um_convert(item_id => 0
1627: ,precision => 5
1628: ,from_quantity => Capacity_rec.max_cap
1629: ,from_unit => l_capacity_uom
1630: ,to_unit => l_step_qty_uom
2758: FOR i IN 1 .. l_material_tab.COUNT
2759: LOOP
2760: IF l_different_uom = 'Y'
2761: THEN
2762: l_temp_qty := INV_CONVERT.inv_um_convert(item_id => l_material_tab (i).inventory_item_id
2763: ,precision => 5
2764: ,from_quantity => l_material_tab (i).qty
2765: ,from_unit => l_material_tab (i).detail_uom
2766: ,to_unit => l_conv_uom
2851: -- Changed
2852: IF l_different_uom = 'Y'
2853: THEN
2854: /* Bug No.9399933 - Changed item_id from l_material_tab(i).inventory_item_id to temp_prod_tbl1 (i).inventory_item_id */
2855: l_temp_qty := INV_CONVERT.inv_um_convert(item_id => temp_prod_tbl1 (i).inventory_item_id
2856: ,precision => 5
2857: ,from_quantity => l_one_prodqty
2858: ,from_unit => l_conv_uom
2859: ,to_unit => temp_prod_tbl1 (i).orig_uom