eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSD_DEM_CREATE_DEM_SEED dependencies on MSD_DEM_COMMON_UTILITIES

Line 216: /*DM_COMPONENT := msd_dem_common_utilities.get_lookup_value('MSD_DEM_COMPONENTS', 'DEMAND_MANAGEMENT');

212:
213: -- Bug#7199587 syenamar
214: -- replacing code using hard coded english names with ids for demantra objects
215:
216: /*DM_COMPONENT := msd_dem_common_utilities.get_lookup_value('MSD_DEM_COMPONENTS', 'DEMAND_MANAGEMENT');
217:
218: DM_COMPONENT := 'Demand Management';
219:
220: if DM_COMPONENT is null then

Line 232: l_component_id := to_number(msd_dem_common_utilities.get_lookup_value('MSD_DEM_COMPONENTS', 'DEMAND_MANAGEMENT'));

228: open get_component for l_stmt_get_component;
229: fetch get_component into l_component_id;
230: close get_component;*/
231:
232: l_component_id := to_number(msd_dem_common_utilities.get_lookup_value('MSD_DEM_COMPONENTS', 'DEMAND_MANAGEMENT'));
233: dbms_output.put_line(l_component_id);
234:
235: l_stmt_user_id := 'select user_id from ' || msd_dem_common_utilities.get_lookup_value('MSD_DEM_TABLES', 'DCM_PRODUCTS') || ' where dcm_product_id = ' || l_component_id;
236: dbms_output.put_line(l_stmt_user_id);

Line 235: l_stmt_user_id := 'select user_id from ' || msd_dem_common_utilities.get_lookup_value('MSD_DEM_TABLES', 'DCM_PRODUCTS') || ' where dcm_product_id = ' || l_component_id;

231:
232: l_component_id := to_number(msd_dem_common_utilities.get_lookup_value('MSD_DEM_COMPONENTS', 'DEMAND_MANAGEMENT'));
233: dbms_output.put_line(l_component_id);
234:
235: l_stmt_user_id := 'select user_id from ' || msd_dem_common_utilities.get_lookup_value('MSD_DEM_TABLES', 'DCM_PRODUCTS') || ' where dcm_product_id = ' || l_component_id;
236: dbms_output.put_line(l_stmt_user_id);
237:
238: open get_user_id for l_stmt_user_id;
239: fetch get_user_id into l_user_id;

Line 246: 'where tq.transfer_id = ' || msd_dem_common_utilities.get_lookup_value('MSD_DEM_DEMANTRA_OBJECT_ID', 'INTG_INF_EBS_PRICE_LIST');

242:
243: l_stmt_query_id := 'select tq.id from ' ||
244: -- DEMANTRA_SCHEMA || '.transfer_list tl, ' || --> removing this as integration interface id is obtained from lookup
245: DEMANTRA_SCHEMA || '.transfer_query tq ' ||
246: 'where tq.transfer_id = ' || msd_dem_common_utilities.get_lookup_value('MSD_DEM_DEMANTRA_OBJECT_ID', 'INTG_INF_EBS_PRICE_LIST');
247: dbms_output.put_line(l_stmt_query_id);
248:
249: open get_query_id for l_stmt_query_id;
250: fetch get_query_id into l_query_id;