DBA Data[Home] [Help]

APPS.CSD_UPDATE_PROGRAMS_PVT dependencies on MTL_UNITS_OF_MEASURE

Line 354: l_from_uom_code mtl_units_of_measure.uom_code%type;

350: l_api_name CONSTANT VARCHAR2(30) := 'CONVERT_TO_RO_UOM';
351: l_api_version CONSTANT NUMBER := 1.0;
352:
353: -- Variables used in the API
354: l_from_uom_code mtl_units_of_measure.uom_code%type;
355:
356: -- Variables used in FND Log
357: l_error_level number := FND_LOG.LEVEL_ERROR;
358: l_mod_name varchar2(2000) := 'csd.plsql.csd_update_programs_pvt.convert_to_ro_uom';

Line 375: from mtl_units_of_measure

371: IF (NVL(p_from_uom_code, 'ZZZ') = 'ZZZ') THEN
372: Begin
373: select uom_code
374: into l_from_uom_code
375: from mtl_units_of_measure
376: where unit_of_measure = p_from_uom;
377: Exception
378: WHEN NO_DATA_FOUND THEN
379: IF ( l_error_level >= G_debug_level) THEN