331:
332:
333: select count(*)
334: into l_count
335: from mtl_units_of_measure_tl
336: where uom_code = p_uom_code
337: and language = USERENV('LANG');
338:
339: if (l_count = 0) then
351: else /* l_count = 1*/
352:
353: select unit_of_measure
354: into p_unit_of_measure
355: from mtl_units_of_measure_tl
356: where uom_code = p_uom_code
357: and language = USERENV('LANG');
358:
359: end if;