DBA Data[Home] [Help]

APPS.GMD_FORMULA_ANALYSIS dependencies on INV_CONVERT

Line 127: X_conv_qty := INV_CONVERT.inv_um_convert( item_id => get_rec.inventory_item_id

123:
124: FOR get_rec IN Cur_prods_byprods LOOP
125: IF (get_rec.detail_uom <> p_rep_um) THEN
126: -- NPD Conv.
127: X_conv_qty := INV_CONVERT.inv_um_convert( item_id => get_rec.inventory_item_id
128: ,precision => 5
129: ,from_quantity => get_rec.qty
130: ,from_unit => get_rec.detail_uom
131: ,to_unit => p_rep_um

Line 690: X_conv_qty := INV_CONVERT.inv_um_convert( item_id => p_rec.item_id

686: FETCH Cur_product_qty INTO X_prod_qty, X_item_um;
687: CLOSE Cur_product_qty;
688: IF (X_item_um <> p_rec.item_um) THEN
689: --X_conv_qty := gmicuom.uom_conversion(p_rec.item_id, 0, X_prod_qty, X_item_um, p_rec.item_um, 0);
690: X_conv_qty := INV_CONVERT.inv_um_convert( item_id => p_rec.item_id
691: ,precision => 5
692: ,from_quantity => X_prod_qty
693: ,from_unit => X_item_um
694: ,to_unit => p_rec.item_um

Line 1000: X_conv_qty := INV_CONVERT.inv_um_convert( item_id => p_rec.item_id

996: IF (X_um_type = P_mass_um_type) THEN
997: /* Calculate qty in terms of mass UM */
998: IF (p_rec.item_um <> P_mass_um) THEN
999: -- X_conv_qty := gmicuom.uom_conversion(p_rec.item_id, 0, p_rec.qty, p_rec.item_um, P_mass_um, 0);
1000: X_conv_qty := INV_CONVERT.inv_um_convert( item_id => p_rec.item_id
1001: ,precision => 5
1002: ,from_quantity => p_rec.qty
1003: ,from_unit => p_rec.item_um
1004: ,to_unit => P_mass_um

Line 1019: X_conv_qty := INV_CONVERT.inv_um_convert( item_id => p_rec.item_id

1015: END IF;
1016: p_rec.mass_qty := X_conv_qty;
1017: IF (NVL(X_density,0) = 0) THEN
1018: -- X_conv_qty := gmicuom.uom_conversion(p_rec.item_id, 0, p_rec.mass_qty, P_mass_um, P_vol_um, 0);
1019: X_conv_qty := INV_CONVERT.inv_um_convert( item_id => p_rec.item_id
1020: ,precision => 5
1021: ,from_quantity => p_rec.mass_qty
1022: ,from_unit => P_mass_um
1023: ,to_unit => P_vol_um

Line 1047: X_conv_qty := INV_CONVERT.inv_um_convert( item_id => p_rec.item_id

1043: ELSIF (X_um_type = P_vol_um_type) THEN
1044: /* Calculate qty in terms of volume UM */
1045: IF (p_rec.item_um <> P_vol_um) THEN
1046: -- X_conv_qty := gmicuom.uom_conversion(p_rec.item_id, 0, p_rec.qty, p_rec.item_um, P_vol_um, 0);
1047: X_conv_qty := INV_CONVERT.inv_um_convert( item_id => p_rec.item_id
1048: ,precision => 5
1049: ,from_quantity => p_rec.qty
1050: ,from_unit => p_rec.item_um
1051: ,to_unit => P_vol_um

Line 1066: X_conv_qty := INV_CONVERT.inv_um_convert( item_id => p_rec.item_id

1062: END IF;
1063: p_rec.vol_qty := X_conv_qty;
1064: IF (NVL(X_density,0) = 0) THEN
1065: -- X_conv_qty := gmicuom.uom_conversion(p_rec.item_id, 0, p_rec.vol_qty, P_vol_um, P_mass_um, 0);
1066: X_conv_qty := INV_CONVERT.inv_um_convert( item_id => p_rec.item_id
1067: ,precision => 5
1068: ,from_quantity => p_rec.vol_qty
1069: ,from_unit => P_vol_um
1070: ,to_unit => P_mass_um