DBA Data[Home] [Help]

APPS.BSC_OLAP_MAIN dependencies on BSC_BSC_ADAPTER

Line 162: if BSC_BSC_ADAPTER.load_metadata_for_indicators(p_kpi,g_options,g_number_options)=false then

158: write_to_log_file_n('================================================');
159: write_to_log_file('Implement BSC MV '||p_kpi);
160: write_to_log_file_n('================================================');
161: end if;
162: if BSC_BSC_ADAPTER.load_metadata_for_indicators(p_kpi,g_options,g_number_options)=false then
163: p_error_message:=BSC_IM_UTILS.g_status_message;
164: return false;
165: end if;
166: if BSC_MV_ADAPTER.create_mv_kpi(p_kpi,'BSC',g_options,g_number_options)=false then

Line 194: if BSC_BSC_ADAPTER.load_metadata_for_indicators(p_kpi,g_options,g_number_options)=false then

190: if init_all(g_options,g_number_options)=false then
191: p_error_message:=BSC_IM_UTILS.g_status_message;
192: return false;
193: end if;
194: if BSC_BSC_ADAPTER.load_metadata_for_indicators(p_kpi,g_options,g_number_options)=false then
195: p_error_message:=BSC_IM_UTILS.g_status_message;
196: return false;
197: end if;
198: if BSC_MV_ADAPTER.drop_mv_kpi(p_kpi,'BSC',g_options,g_number_options)=false then

Line 251: if BSC_BSC_ADAPTER.load_metadata_for_indicators(p_kpi,g_options,g_number_options)=false then

247: write_to_log_file_n('================================================');
248: write_to_log_file('Refresh BSC MV '||p_kpi);
249: write_to_log_file_n('================================================');
250: end if;
251: if BSC_BSC_ADAPTER.load_metadata_for_indicators(p_kpi,g_options,g_number_options)=false then
252: p_error_message:=BSC_IM_UTILS.g_status_message;
253: return false;
254: end if;
255: if BSC_MV_ADAPTER.refresh_mv_kpi(p_kpi,'BSC',g_options,g_number_options)=false then

Line 288: --Instead call BSC_BSC_ADAPTER.create_int_md_fk(p_mv)

284: write_to_log_file('Refresh Summary MV '||p_mv||' '||p_kpi);
285: write_to_log_file_n('================================================');
286: end if;
287: -- Bug#3899842: Performance fix: Comment out these lines.
288: --Instead call BSC_BSC_ADAPTER.create_int_md_fk(p_mv)
289: /*
290: if BSC_IM_UTILS.is_cube_present(p_kpi,'BSC')=false then
291: --see if any cube is present.
292: if BSC_IM_UTILS.is_cube_present(null,'BSC') then

Line 296: if BSC_BSC_ADAPTER.load_metadata_for_indicators(p_kpi,g_options,g_number_options)=false then

292: if BSC_IM_UTILS.is_cube_present(null,'BSC') then
293: reset;
294: end if;
295: --populate the int metadata
296: if BSC_BSC_ADAPTER.load_metadata_for_indicators(p_kpi,g_options,g_number_options)=false then
297: p_error_message:=BSC_IM_UTILS.g_status_message;
298: return false;
299: end if;
300: end if;

Line 302: BSC_BSC_ADAPTER.create_int_md_fk(p_mv);

298: return false;
299: end if;
300: end if;
301: */
302: BSC_BSC_ADAPTER.create_int_md_fk(p_mv);
303: if BSC_MV_ADAPTER.refresh_mv(p_mv,p_kpi,g_options,g_number_options)=false then
304: p_error_message:=BSC_MV_ADAPTER.g_status_message;
305: return false;
306: end if;

Line 338: if BSC_BSC_ADAPTER.load_reporting_calendar(g_options,g_number_options)=false then

334: write_to_log_file('Load Reporting Calendar, Apps='||p_apps);
335: write_to_log_file_n('================================================');
336: end if;
337: if p_apps='BSC' then
338: if BSC_BSC_ADAPTER.load_reporting_calendar(g_options,g_number_options)=false then
339: p_error_message:=BSC_IM_UTILS.g_status_message;
340: return false;
341: end if;
342: end if;

Line 375: if BSC_BSC_ADAPTER.load_reporting_calendar(p_calendar_id, g_options,g_number_options)=false then

371: write_to_log_file('Load Reporting Calendar, calendar id='||p_calendar_id||' Apps='||p_apps);
372: write_to_log_file_n('================================================');
373: end if;
374: if p_apps='BSC' then
375: if BSC_BSC_ADAPTER.load_reporting_calendar(p_calendar_id, g_options,g_number_options)=false then
376: p_error_message:=BSC_IM_UTILS.g_status_message;
377: return false;
378: end if;
379: end if;

Line 397: bsc_bsc_adapter.get_list_of_rec_dim(p_dim_list,p_num_dim_list,p_error_message);

393: p_dim_list out nocopy bsc_varchar2_table_type,
394: p_num_dim_list out nocopy number,
395: p_error_message out nocopy varchar2) is
396: Begin
397: bsc_bsc_adapter.get_list_of_rec_dim(p_dim_list,p_num_dim_list,p_error_message);
398: Exception when others then
399: BSC_IM_UTILS.g_status_message:=sqlerrm;
400: p_error_message:=BSC_IM_UTILS.g_status_message;
401: raise;

Line 412: bsc_bsc_adapter.set_and_get_dim_sql(p_dim_level_short_name,p_dim_level_value,p_num_dim_level,

408: p_dim_level_sql out nocopy bsc_varchar2_table_type,
409: p_error_message out nocopy varchar2
410: ) is
411: Begin
412: bsc_bsc_adapter.set_and_get_dim_sql(p_dim_level_short_name,p_dim_level_value,p_num_dim_level,
413: p_dim_level_sql,p_error_message);
414: Exception when others then
415: BSC_IM_UTILS.g_status_message:=sqlerrm;
416: p_error_message:=BSC_IM_UTILS.g_status_message;

Line 459: BSC_BSC_ADAPTER.set_globals(g_debug);

455: BSC_IM_UTILS.set_globals(g_debug);
456: if BSC_IM_UTILS.set_global_dimensions=false then
457: return false;
458: end if;
459: BSC_BSC_ADAPTER.set_globals(g_debug);
460: BSC_IM_INT_MD.set_globals(g_debug);
461: BSC_MV_ADAPTER.set_globals(g_debug);
462: return true;
463: Exception when others then