APPS.MSD_DEM_COLLECT_UOMS dependencies on MSD_DEM_ENTITIES_INUSE

Line 239: from msd_dem_entities_inuse

235: as
236:
237: cursor get_uom_metadata is
238: select table_name, column_name
239: from msd_dem_entities_inuse
240: where ebs_entity = 'UOM'
241: and demantra_entity = 'DISPLAY_UNIT'
242: and internal_name = p_uom_code;
243:

Line 302: msd_dem_entities_inuse

298: as
299:
300: cursor verify_entities_inuse is
301: select 1 from
302: msd_dem_entities_inuse
303: where internal_name = p_uom_code
304: and ebs_entity = 'UOM';
305:
306: type c_get_new_uom_display_unit is ref cursor;

Line 365: l_stmt := 'insert into msd_dem_entities_inuse(

361: end if;
362: close get_new_uom_display_unit;
363:
364:
365: l_stmt := 'insert into msd_dem_entities_inuse(
366: ebs_entity
367: ,demantra_entity
368: ,internal_name
369: ,table_name

Line 448: l_stmt := 'update msd_dem_entities_inuse set table_name = (select data_table from ' || get_lookup_value('MSD_DEM_TABLES', 'DISPLAY_UNITS') || ' where display_units = :1)' ||

444: execute immediate l_stmt using l_component_id_sop,new_uom.display_units_id;
445:
446: else
447: l_stmt := null;
448: l_stmt := 'update msd_dem_entities_inuse set table_name = (select data_table from ' || get_lookup_value('MSD_DEM_TABLES', 'DISPLAY_UNITS') || ' where display_units = :1)' ||
449: ', column_name = (select data_field from ' || get_lookup_value('MSD_DEM_TABLES', 'DISPLAY_UNITS') || ' where display_units = :2)' ||
450: 'where ebs_entity = ''UOM'' and demantra_entity = ''DISPLAY_UNIT'' and internal_name = :3';
451:
452: msd_dem_common_utilities.log_debug(l_stmt);