280:
281: FUNCTION get_uom_code(p_uom IN VARCHAR2) RETURN VARCHAR2 IS
282: CURSOR c_uom_code IS
283: SELECT uom_code
284: FROM mtl_units_of_measure
285: WHERE unit_of_measure = p_uom;
286:
287: lv_uom_code MTL_UNITS_OF_MEASURE.uom_code%TYPE;
288: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_general_pkg.get_uom_code';
283: SELECT uom_code
284: FROM mtl_units_of_measure
285: WHERE unit_of_measure = p_uom;
286:
287: lv_uom_code MTL_UNITS_OF_MEASURE.uom_code%TYPE;
288: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_general_pkg.get_uom_code';
289:
290: BEGIN
291: OPEN c_uom_code;
351: app_exception.raise_exception;
352: END get_matched_boe_no;
353:
354: FUNCTION trxn_to_primary_conv_rate(
355: p_transaction_uom_code IN MTL_UNITS_OF_MEASURE.uom_code%TYPE,
356: p_primary_uom_code IN MTL_UNITS_OF_MEASURE.uom_code%TYPE,
357: p_inventory_item_id IN MTL_SYSTEM_ITEMS.inventory_item_id%TYPE
358: ) RETURN NUMBER IS
359: vTransToPrimaryUOMConv NUMBER;
352: END get_matched_boe_no;
353:
354: FUNCTION trxn_to_primary_conv_rate(
355: p_transaction_uom_code IN MTL_UNITS_OF_MEASURE.uom_code%TYPE,
356: p_primary_uom_code IN MTL_UNITS_OF_MEASURE.uom_code%TYPE,
357: p_inventory_item_id IN MTL_SYSTEM_ITEMS.inventory_item_id%TYPE
358: ) RETURN NUMBER IS
359: vTransToPrimaryUOMConv NUMBER;
360: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_general_pkg.trxn_to_primary_conv_rate';