17: and language = 'US';
18:
19: cursor get_schema_name is
20: select fnd_profile.value('MSD_DEM_SCHEMA')
21: from dual;
22:
23: l_lookup_value varchar2(200);
24: l_schema_name varchar2(200);
25:
309: close get_component;
310:
311: l_stmt := 'insert into ' || get_lookup_value('MSD_DEM_TABLES', 'DCM_PRODUCTS_UNITS') ||
312: ' (dcm_product_id ,display_units_id) ' ||
313: ' (select :1, :2 from dual)';
314:
315: msd_dem_common_utilities.log_debug(l_stmt);
316: execute immediate l_stmt using l_component_id,new_prl.display_units_id;
317:
336: close get_component_sop;
337:
338: l_stmt := 'insert into ' || get_lookup_value('MSD_DEM_TABLES', 'DCM_PRODUCTS_UNITS') ||
339: ' (dcm_product_id ,display_units_id) ' ||
340: ' (select :1, :2 from dual)';
341:
342: msd_dem_common_utilities.log_debug(l_stmt);
343: execute immediate l_stmt using l_component_id_sop,new_prl.display_units_id;
344: