DBA Data[Home] [Help]

APPS.AR_GTA_ARTRX_PROC dependencies on MTL_UNITS_OF_MEASURE_TL

Line 5003: l_unit_of_measure mtl_units_of_measure_tl.unit_of_measure%TYPE;

4999: -- 11-Oct2005: Jim Zheng Created.
5000: --===========================================================================
5001: PROCEDURE get_uom_name(p_uom_code IN VARCHAR2,
5002: x_uom_name OUT NOCOPY VARCHAR2) IS
5003: l_unit_of_measure mtl_units_of_measure_tl.unit_of_measure%TYPE;
5004: l_procedure_name VARCHAR2(30) := 'get_uom_name';
5005: BEGIN
5006: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5007: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE,

Line 5015: FROM mtl_units_of_measure_tl uom

5011:
5012: BEGIN
5013: SELECT uom.unit_of_measure
5014: INTO l_unit_of_measure
5015: FROM mtl_units_of_measure_tl uom
5016: WHERE uom.uom_code = p_uom_code
5017: AND uom.LANGUAGE = userenv('LANG');
5018:
5019: EXCEPTION