DBA Data[Home] [Help]

APPS.GMD_VALIDITY_RULES dependencies on INV_CONVERT

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

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

Line 420: l_item_qty := INV_CONVERT.inv_um_convert(item_id => get_rec.inventory_item_id

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

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

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

Line 467: l_quantity := INV_CONVERT.inv_um_convert(item_id => p_item_id

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

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

564: CLOSE get_form_prod;
565:
566: IF p_product_qty IS NOT NULL THEN -- Add Check to see if Prod Qty. is passed as NULL
567: -- check uom conversion here
568: -- NPD Conv. Changed the call to INV_CONVERT.inv_um_convert from gmicuom.uom_conversion
569: l_quantity := INV_CONVERT.inv_um_convert(item_id => p_item_id
570: ,precision => 5
571: ,from_quantity => p_product_qty
572: ,from_unit => p_uom

Line 569: l_quantity := INV_CONVERT.inv_um_convert(item_id => p_item_id

565:
566: IF p_product_qty IS NOT NULL THEN -- Add Check to see if Prod Qty. is passed as NULL
567: -- check uom conversion here
568: -- NPD Conv. Changed the call to INV_CONVERT.inv_um_convert from gmicuom.uom_conversion
569: l_quantity := INV_CONVERT.inv_um_convert(item_id => p_item_id
570: ,precision => 5
571: ,from_quantity => p_product_qty
572: ,from_unit => p_uom
573: ,to_unit => l_item_uom

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

795: LOOP
796: IF (get_rec.scale_type = 0) THEN
797: IF (get_rec.detail_uom <> p_yield_um) THEN
798:
799: -- NPD Conv. Changed the call to INV_CONVERT.inv_um_convert from gmicuom.uom_conversion
800: l_conv_qty := INV_CONVERT.inv_um_convert(item_id => get_rec.inventory_item_id
801: ,precision => 5
802: ,from_quantity => get_rec.qty
803: ,from_unit => get_rec.detail_uom

Line 800: l_conv_qty := INV_CONVERT.inv_um_convert(item_id => get_rec.inventory_item_id

796: IF (get_rec.scale_type = 0) THEN
797: IF (get_rec.detail_uom <> p_yield_um) THEN
798:
799: -- NPD Conv. Changed the call to INV_CONVERT.inv_um_convert from gmicuom.uom_conversion
800: l_conv_qty := INV_CONVERT.inv_um_convert(item_id => get_rec.inventory_item_id
801: ,precision => 5
802: ,from_quantity => get_rec.qty
803: ,from_unit => get_rec.detail_uom
804: ,to_unit => p_yield_um

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

866: --Get sum of products in yield UM.
867: FOR get_rec IN Cur_get_details(1)
868: LOOP
869: IF (get_rec.detail_uom <> p_yield_um) THEN
870: -- NPD Conv. Changed the call to INV_CONVERT.inv_um_convert from gmicuom.uom_conversion
871: l_conv_qty := INV_CONVERT.inv_um_convert(item_id => get_rec.inventory_item_id
872: ,precision => 5
873: ,from_quantity => get_rec.qty
874: ,from_unit => get_rec.detail_uom

Line 871: l_conv_qty := INV_CONVERT.inv_um_convert(item_id => get_rec.inventory_item_id

867: FOR get_rec IN Cur_get_details(1)
868: LOOP
869: IF (get_rec.detail_uom <> p_yield_um) THEN
870: -- NPD Conv. Changed the call to INV_CONVERT.inv_um_convert from gmicuom.uom_conversion
871: l_conv_qty := INV_CONVERT.inv_um_convert(item_id => get_rec.inventory_item_id
872: ,precision => 5
873: ,from_quantity => get_rec.qty
874: ,from_unit => get_rec.detail_uom
875: ,to_unit => p_yield_um

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

890: FOR get_rec IN Cur_get_details(-1)
891: LOOP
892: IF (get_rec.contribute_yield_ind = 'Y') THEN
893: IF (get_rec.detail_uom <> p_yield_um) THEN
894: -- NPD Conv. Changed the call to INV_CONVERT.inv_um_convert from gmicuom.uom_conversion
895: l_conv_qty := INV_CONVERT.inv_um_convert(item_id => get_rec.inventory_item_id
896: ,precision => 5
897: ,from_quantity => get_rec.qty
898: ,from_unit => get_rec.detail_uom

Line 895: l_conv_qty := INV_CONVERT.inv_um_convert(item_id => get_rec.inventory_item_id

891: LOOP
892: IF (get_rec.contribute_yield_ind = 'Y') THEN
893: IF (get_rec.detail_uom <> p_yield_um) THEN
894: -- NPD Conv. Changed the call to INV_CONVERT.inv_um_convert from gmicuom.uom_conversion
895: l_conv_qty := INV_CONVERT.inv_um_convert(item_id => get_rec.inventory_item_id
896: ,precision => 5
897: ,from_quantity => get_rec.qty
898: ,from_unit => get_rec.detail_uom
899: ,to_unit => p_yield_um

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

967: FOR get_rec IN Cur_get_ingreds LOOP
968: IF (get_rec.scale_type = 0) THEN
969: IF (get_rec.detail_uom <> p_yield_um) THEN
970:
971: -- NPD Conv. Changed the call to INV_CONVERT.inv_um_convert from gmicuom.uom_conversion
972: l_conv_qty := INV_CONVERT.inv_um_convert(item_id => get_rec.inventory_item_id
973: ,precision => 5
974: ,from_quantity => get_rec.qty
975: ,from_unit => get_rec.detail_uom

Line 972: l_conv_qty := INV_CONVERT.inv_um_convert(item_id => get_rec.inventory_item_id

968: IF (get_rec.scale_type = 0) THEN
969: IF (get_rec.detail_uom <> p_yield_um) THEN
970:
971: -- NPD Conv. Changed the call to INV_CONVERT.inv_um_convert from gmicuom.uom_conversion
972: l_conv_qty := INV_CONVERT.inv_um_convert(item_id => get_rec.inventory_item_id
973: ,precision => 5
974: ,from_quantity => get_rec.qty
975: ,from_unit => get_rec.detail_uom
976: ,to_unit => p_yield_um

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

1045: FOR get_rec IN Cur_get_ingreds LOOP
1046: IF (get_rec.contribute_yield_ind = 'Y') THEN
1047: /* Convert all ingredient values to yield UM and determine contributing qty */
1048: IF (get_rec.detail_uom <> p_yield_um) THEN
1049: -- NPD Conv. Changed the call to INV_CONVERT.inv_um_convert from gmicuom.uom_conversion
1050: l_conv_qty := INV_CONVERT.inv_um_convert(item_id => get_rec.inventory_item_id
1051: ,precision => 5
1052: ,from_quantity => get_rec.qty
1053: ,from_unit => get_rec.detail_uom

Line 1050: l_conv_qty := INV_CONVERT.inv_um_convert(item_id => get_rec.inventory_item_id

1046: IF (get_rec.contribute_yield_ind = 'Y') THEN
1047: /* Convert all ingredient values to yield UM and determine contributing qty */
1048: IF (get_rec.detail_uom <> p_yield_um) THEN
1049: -- NPD Conv. Changed the call to INV_CONVERT.inv_um_convert from gmicuom.uom_conversion
1050: l_conv_qty := INV_CONVERT.inv_um_convert(item_id => get_rec.inventory_item_id
1051: ,precision => 5
1052: ,from_quantity => get_rec.qty
1053: ,from_unit => get_rec.detail_uom
1054: ,to_unit => p_yield_um

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

1133: FOR get_rec IN Cur_get_prods LOOP
1134: IF (get_rec.scale_type = 0) THEN
1135: IF (get_rec.detail_uom <> p_yield_um) THEN
1136:
1137: -- NPD Conv. Changed the call to INV_CONVERT.inv_um_convert from gmicuom.uom_conversion
1138: l_conv_qty := INV_CONVERT.inv_um_convert(item_id => get_rec.inventory_item_id
1139: ,precision => 5
1140: ,from_quantity => get_rec.qty
1141: ,from_unit => get_rec.detail_uom

Line 1138: l_conv_qty := INV_CONVERT.inv_um_convert(item_id => get_rec.inventory_item_id

1134: IF (get_rec.scale_type = 0) THEN
1135: IF (get_rec.detail_uom <> p_yield_um) THEN
1136:
1137: -- NPD Conv. Changed the call to INV_CONVERT.inv_um_convert from gmicuom.uom_conversion
1138: l_conv_qty := INV_CONVERT.inv_um_convert(item_id => get_rec.inventory_item_id
1139: ,precision => 5
1140: ,from_quantity => get_rec.qty
1141: ,from_unit => get_rec.detail_uom
1142: ,to_unit => p_yield_um

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

1498: LOOP
1499: IF l_prod_rec.detail_uom = p_std_um THEN
1500: l_prod_qty := l_prod_qty + l_prod_rec.qty;
1501: ELSE
1502: -- NPD Conv. Changed the call to INV_CONVERT.inv_um_convert from gmicuom.uom_conversion
1503: l_temp_qty := INV_CONVERT.inv_um_convert(item_id => p_item_id
1504: ,precision => 5
1505: ,from_quantity => l_prod_rec.qty
1506: ,from_unit => l_prod_rec.detail_uom

Line 1503: l_temp_qty := INV_CONVERT.inv_um_convert(item_id => p_item_id

1499: IF l_prod_rec.detail_uom = p_std_um THEN
1500: l_prod_qty := l_prod_qty + l_prod_rec.qty;
1501: ELSE
1502: -- NPD Conv. Changed the call to INV_CONVERT.inv_um_convert from gmicuom.uom_conversion
1503: l_temp_qty := INV_CONVERT.inv_um_convert(item_id => p_item_id
1504: ,precision => 5
1505: ,from_quantity => l_prod_rec.qty
1506: ,from_unit => l_prod_rec.detail_uom
1507: ,to_unit => p_std_um