168: p_primary_uom_code IN VARCHAR2
169: )
170: RETURN VARCHAR2 IS
171:
172: l_display_val MTL_UNITS_OF_MEASURE_TL.DESCRIPTION%TYPE;
173:
174: CURSOR c_uom_desc(p_uom_code VARCHAR) IS
175: SELECT description
176: FROM mtl_units_of_measure_tl
172: l_display_val MTL_UNITS_OF_MEASURE_TL.DESCRIPTION%TYPE;
173:
174: CURSOR c_uom_desc(p_uom_code VARCHAR) IS
175: SELECT description
176: FROM mtl_units_of_measure_tl
177: WHERE language = userenv('LANG')
178: AND uom_code = p_uom_code;
179:
180: BEGIN