APPS.JMF_GTA_ARTRX_PROC dependencies on MTL_UNITS_OF_MEASURE_TL

Line 4434: l_unit_of_measure mtl_units_of_measure_tl.unit_of_measure%TYPE;

4430: -- 11-Oct2005: Jim Zheng Created.
4431: --===========================================================================
4432: PROCEDURE get_uom_name(p_uom_code IN VARCHAR2,
4433: x_uom_name OUT NOCOPY VARCHAR2) IS
4434: l_unit_of_measure mtl_units_of_measure_tl.unit_of_measure%TYPE;
4435: l_procedure_name VARCHAR2(30) := 'get_uom_name';
4436: BEGIN
4437: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4438: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE,

Line 4446: FROM mtl_units_of_measure_tl uom

4442:
4443: BEGIN
4444: SELECT uom.unit_of_measure
4445: INTO l_unit_of_measure
4446: FROM mtl_units_of_measure_tl uom
4447: WHERE uom.uom_code = p_uom_code
4448: AND uom.LANGUAGE = userenv('LANG');
4449:
4450: EXCEPTION