APPS.MSD_DEM_CTO dependencies on MSD_DEM_UPDATE_LEVEL_CODES

Line 218: msd_dem_update_level_codes.update_code(errbuf ,

214:
215: msd_dem_common_utilities.log_message ('Update the site codes to descriptive format');
216:
217: msd_dem_common_utilities.log_debug ('Start Updating Site codes - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
218: msd_dem_update_level_codes.update_code(errbuf ,
219: retcode,
220: p_sr_instance_id,
221: 'SITE',
222: msd_dem_common_utilities.get_lookup_value ('MSD_DEM_DM_STAGING_TABLES', 'SALES_STAGING_TABLE'),

Line 239: msd_dem_update_level_codes.convert_site_code(

235: msd_dem_common_utilities.log_message ('In msd_dem_cto.populate_staging_table - '
236: || 'Updating site codes to descriptive format in BIIO_CTO_DATA ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
237:
238: msd_dem_common_utilities.log_debug ('Start Updating Site codes - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
239: msd_dem_update_level_codes.convert_site_code(
240: errbuf,
241: retcode,
242: p_sr_instance_id,
243: 'SITE',

Line 314: msd_dem_update_level_codes.update_code(errbuf ,

310:
311: msd_dem_common_utilities.log_message ('Update the site codes to descriptive format');
312:
313: msd_dem_common_utilities.log_debug ('Start Updating Site codes - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
314: msd_dem_update_level_codes.update_code(errbuf ,
315: retcode,
316: p_sr_instance_id,
317: 'SITE',
318: msd_dem_common_utilities.get_lookup_value ('MSD_DEM_DM_STAGING_TABLES', 'SALES_STAGING_TABLE'),