DBA Data[Home] [Help]

APPS.CSD_UPDATE_PROGRAMS_PVT dependencies on MTL_UNITS_OF_MEASURE

Line 347: l_from_uom_code mtl_units_of_measure.uom_code%type;

343: l_api_name CONSTANT VARCHAR2(30) := 'CONVERT_TO_RO_UOM';
344: l_api_version CONSTANT NUMBER := 1.0;
345:
346: -- Variables used in the API
347: l_from_uom_code mtl_units_of_measure.uom_code%type;
348:
349: -- Variables used in FND Log
350: l_error_level number := FND_LOG.LEVEL_ERROR;
351: l_mod_name varchar2(2000) := 'csd.plsql.csd_update_programs_pvt.convert_to_ro_uom';

Line 368: from mtl_units_of_measure

364: IF (NVL(p_from_uom_code, 'ZZZ') = 'ZZZ') THEN
365: Begin
366: select uom_code
367: into l_from_uom_code
368: from mtl_units_of_measure
369: where unit_of_measure = p_from_uom;
370: Exception
371: WHEN NO_DATA_FOUND THEN
372: IF ( l_error_level >= G_debug_level) THEN