APPS.GMD_VALIDITY_RULES dependencies on GMICUOM

Line 419: -- NPD Conv. Changed the call to INV_CONVERT.inv_um_convert from gmicuom.uom_conversion

415: IF (l_scale_type = 1) THEN
416: l_item_qty := l_item_qty * l_output_ratio;
417: IF (l_line_um <> get_rec.detail_uom) THEN
418:
419: -- NPD Conv. Changed the call to INV_CONVERT.inv_um_convert from gmicuom.uom_conversion
420:
421: l_item_qty := INV_CONVERT.inv_um_convert(item_id => get_rec.inventory_item_id
422: ,precision => 5
423: ,from_quantity => l_item_qty

Line 431: /* gmicuom.icuomcv(get_rec.item_id, 0, l_item_qty, l_line_um, get_rec.item_um, l_item_qty); */

427: ,to_name => NULL);
428: IF l_item_qty < 0 THEN
429: RAISE UOM_CONVERSION_ERROR;
430: END IF;
431: /* gmicuom.icuomcv(get_rec.item_id, 0, l_item_qty, l_line_um, get_rec.item_um, l_item_qty); */
432: END IF;
433: IF (l_item_qty >= get_rec.min_qty AND l_item_qty <= get_rec.max_qty) THEN
434: IF p_least_cost_validity = 'T' THEN
435: GMD_VALIDITY_RULES.get_formula_cost (p_formula_id => l_formula_id

Line 465: -- NPD Conv. Changed the call to INV_CONVERT.inv_um_convert from gmicuom.uom_conversion

461: FETCH cur_item_uom INTO l_item_uom;
462: CLOSE cur_item_uom;
463:
464: IF (p_uom <> l_item_uom) THEN
465: -- NPD Conv. Changed the call to INV_CONVERT.inv_um_convert from gmicuom.uom_conversion
466: l_quantity := ROUND(gmicuom.uom_conversion(p_item_id,0,p_product_qty, p_uom, l_item_uom, 0),9);
467:
468: l_quantity := INV_CONVERT.inv_um_convert(item_id => p_item_id
469: ,precision => 5

Line 466: l_quantity := ROUND(gmicuom.uom_conversion(p_item_id,0,p_product_qty, p_uom, l_item_uom, 0),9);

462: CLOSE cur_item_uom;
463:
464: IF (p_uom <> l_item_uom) THEN
465: -- NPD Conv. Changed the call to INV_CONVERT.inv_um_convert from gmicuom.uom_conversion
466: l_quantity := ROUND(gmicuom.uom_conversion(p_item_id,0,p_product_qty, p_uom, l_item_uom, 0),9);
467:
468: l_quantity := INV_CONVERT.inv_um_convert(item_id => p_item_id
469: ,precision => 5
470: ,from_quantity => p_product_qty

Line 575: -- NPD Conv. Changed the call to INV_CONVERT.inv_um_convert from gmicuom.uom_conversion

571: /* Bug No.8643350 - END */
572:
573: IF p_product_qty IS NOT NULL THEN -- Add Check to see if Prod Qty. is passed as NULL
574: -- check uom conversion here
575: -- NPD Conv. Changed the call to INV_CONVERT.inv_um_convert from gmicuom.uom_conversion
576: l_quantity := INV_CONVERT.inv_um_convert(item_id => p_item_id
577: ,precision => 5
578: ,from_quantity => p_product_qty
579: ,from_unit => p_uom

Line 821: -- NPD Conv. Changed the call to INV_CONVERT.inv_um_convert from gmicuom.uom_conversion

817: LOOP
818: IF (get_rec.scale_type = 0) THEN
819: IF (get_rec.detail_uom <> p_yield_um) THEN
820:
821: -- NPD Conv. Changed the call to INV_CONVERT.inv_um_convert from gmicuom.uom_conversion
822: l_conv_qty := INV_CONVERT.inv_um_convert(item_id => get_rec.inventory_item_id
823: ,precision => 5
824: ,from_quantity => get_rec.qty
825: ,from_unit => get_rec.detail_uom

Line 892: -- NPD Conv. Changed the call to INV_CONVERT.inv_um_convert from gmicuom.uom_conversion

888: --Get sum of products in yield UM.
889: FOR get_rec IN Cur_get_details(1)
890: LOOP
891: IF (get_rec.detail_uom <> p_yield_um) THEN
892: -- NPD Conv. Changed the call to INV_CONVERT.inv_um_convert from gmicuom.uom_conversion
893: l_conv_qty := INV_CONVERT.inv_um_convert(item_id => get_rec.inventory_item_id
894: ,precision => 5
895: ,from_quantity => get_rec.qty
896: ,from_unit => get_rec.detail_uom

Line 916: -- NPD Conv. Changed the call to INV_CONVERT.inv_um_convert from gmicuom.uom_conversion

912: FOR get_rec IN Cur_get_details(-1)
913: LOOP
914: IF (get_rec.contribute_yield_ind = 'Y') THEN
915: IF (get_rec.detail_uom <> p_yield_um) THEN
916: -- NPD Conv. Changed the call to INV_CONVERT.inv_um_convert from gmicuom.uom_conversion
917: l_conv_qty := INV_CONVERT.inv_um_convert(item_id => get_rec.inventory_item_id
918: ,precision => 5
919: ,from_quantity => get_rec.qty
920: ,from_unit => get_rec.detail_uom

Line 993: -- NPD Conv. Changed the call to INV_CONVERT.inv_um_convert from gmicuom.uom_conversion

989: FOR get_rec IN Cur_get_ingreds LOOP
990: IF (get_rec.scale_type = 0) THEN
991: IF (get_rec.detail_uom <> p_yield_um) THEN
992:
993: -- NPD Conv. Changed the call to INV_CONVERT.inv_um_convert from gmicuom.uom_conversion
994: l_conv_qty := INV_CONVERT.inv_um_convert(item_id => get_rec.inventory_item_id
995: ,precision => 5
996: ,from_quantity => get_rec.qty
997: ,from_unit => get_rec.detail_uom

Line 1071: -- NPD Conv. Changed the call to INV_CONVERT.inv_um_convert from gmicuom.uom_conversion

1067: FOR get_rec IN Cur_get_ingreds LOOP
1068: IF (get_rec.contribute_yield_ind = 'Y') THEN
1069: /* Convert all ingredient values to yield UM and determine contributing qty */
1070: IF (get_rec.detail_uom <> p_yield_um) THEN
1071: -- NPD Conv. Changed the call to INV_CONVERT.inv_um_convert from gmicuom.uom_conversion
1072: l_conv_qty := INV_CONVERT.inv_um_convert(item_id => get_rec.inventory_item_id
1073: ,precision => 5
1074: ,from_quantity => get_rec.qty
1075: ,from_unit => get_rec.detail_uom

Line 1159: -- NPD Conv. Changed the call to INV_CONVERT.inv_um_convert from gmicuom.uom_conversion

1155: FOR get_rec IN Cur_get_prods LOOP
1156: IF (get_rec.scale_type = 0) THEN
1157: IF (get_rec.detail_uom <> p_yield_um) THEN
1158:
1159: -- NPD Conv. Changed the call to INV_CONVERT.inv_um_convert from gmicuom.uom_conversion
1160: l_conv_qty := INV_CONVERT.inv_um_convert(item_id => get_rec.inventory_item_id
1161: ,precision => 5
1162: ,from_quantity => get_rec.qty
1163: ,from_unit => get_rec.detail_uom

Line 1524: -- NPD Conv. Changed the call to INV_CONVERT.inv_um_convert from gmicuom.uom_conversion

1520: LOOP
1521: IF l_prod_rec.detail_uom = p_std_um THEN
1522: l_prod_qty := l_prod_qty + l_prod_rec.qty;
1523: ELSE
1524: -- NPD Conv. Changed the call to INV_CONVERT.inv_um_convert from gmicuom.uom_conversion
1525: l_temp_qty := INV_CONVERT.inv_um_convert(item_id => p_item_id
1526: ,precision => 5
1527: ,from_quantity => l_prod_rec.qty
1528: ,from_unit => l_prod_rec.detail_uom