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.BSC_OLAP_MAIN dependencies on BSC_METADATA_OPTIMIZER_PKG

Line 56: if bsc_metadata_optimizer_pkg.gGAA_RUN_MODE=0 then

52: --create table
53: l_stmt:= 'create table '||g_col_type_table_name||' (level_table_name varchar2(100), data_type varchar2(100))'|| g_summary_table_tbs_clause;
54: BSC_APPS.Do_DDL(l_stmt, ad_ddl.create_table, g_col_type_table_name);
55:
56: if bsc_metadata_optimizer_pkg.gGAA_RUN_MODE=0 then
57: --if running in all objective mode then consider all indicators
58: l_stmt := ' insert into '||g_col_type_table_name||'(level_table_name, data_type)
59: select distinct dim.level_table_name,col.data_type
60: from

Line 79: l_counter := BSC_METADATA_OPTIMIZER_PKG.gIndicators.first;

75: and col.owner =:4';
76: else --if incremental or seletive then consider production mode indicators and
77: -- indictors in current mode
78: l_cur_run_kpis:=BSC_MO_HELPER_PKG.Get_New_Big_In_Cond_Number( 20, 'KPI.INDICATOR');
79: l_counter := BSC_METADATA_OPTIMIZER_PKG.gIndicators.first;
80: if BSC_METADATA_OPTIMIZER_PKG.gIndicators.count <> 0 then
81: loop
82: BSC_MO_HELPER_PKG.Add_Value_Big_In_Cond_Number(20, BSC_METADATA_OPTIMIZER_PKG.gindicators(l_counter).code);
83: EXIT WHEN l_counter=BSC_METADATA_OPTIMIZER_PKG.gIndicators.last;

Line 80: if BSC_METADATA_OPTIMIZER_PKG.gIndicators.count <> 0 then

76: else --if incremental or seletive then consider production mode indicators and
77: -- indictors in current mode
78: l_cur_run_kpis:=BSC_MO_HELPER_PKG.Get_New_Big_In_Cond_Number( 20, 'KPI.INDICATOR');
79: l_counter := BSC_METADATA_OPTIMIZER_PKG.gIndicators.first;
80: if BSC_METADATA_OPTIMIZER_PKG.gIndicators.count <> 0 then
81: loop
82: BSC_MO_HELPER_PKG.Add_Value_Big_In_Cond_Number(20, BSC_METADATA_OPTIMIZER_PKG.gindicators(l_counter).code);
83: EXIT WHEN l_counter=BSC_METADATA_OPTIMIZER_PKG.gIndicators.last;
84: l_counter := BSC_METADATA_OPTIMIZER_PKG.gIndicators.next(l_counter);

Line 82: BSC_MO_HELPER_PKG.Add_Value_Big_In_Cond_Number(20, BSC_METADATA_OPTIMIZER_PKG.gindicators(l_counter).code);

78: l_cur_run_kpis:=BSC_MO_HELPER_PKG.Get_New_Big_In_Cond_Number( 20, 'KPI.INDICATOR');
79: l_counter := BSC_METADATA_OPTIMIZER_PKG.gIndicators.first;
80: if BSC_METADATA_OPTIMIZER_PKG.gIndicators.count <> 0 then
81: loop
82: BSC_MO_HELPER_PKG.Add_Value_Big_In_Cond_Number(20, BSC_METADATA_OPTIMIZER_PKG.gindicators(l_counter).code);
83: EXIT WHEN l_counter=BSC_METADATA_OPTIMIZER_PKG.gIndicators.last;
84: l_counter := BSC_METADATA_OPTIMIZER_PKG.gIndicators.next(l_counter);
85: end loop;
86: end if;

Line 83: EXIT WHEN l_counter=BSC_METADATA_OPTIMIZER_PKG.gIndicators.last;

79: l_counter := BSC_METADATA_OPTIMIZER_PKG.gIndicators.first;
80: if BSC_METADATA_OPTIMIZER_PKG.gIndicators.count <> 0 then
81: loop
82: BSC_MO_HELPER_PKG.Add_Value_Big_In_Cond_Number(20, BSC_METADATA_OPTIMIZER_PKG.gindicators(l_counter).code);
83: EXIT WHEN l_counter=BSC_METADATA_OPTIMIZER_PKG.gIndicators.last;
84: l_counter := BSC_METADATA_OPTIMIZER_PKG.gIndicators.next(l_counter);
85: end loop;
86: end if;
87:

Line 84: l_counter := BSC_METADATA_OPTIMIZER_PKG.gIndicators.next(l_counter);

80: if BSC_METADATA_OPTIMIZER_PKG.gIndicators.count <> 0 then
81: loop
82: BSC_MO_HELPER_PKG.Add_Value_Big_In_Cond_Number(20, BSC_METADATA_OPTIMIZER_PKG.gindicators(l_counter).code);
83: EXIT WHEN l_counter=BSC_METADATA_OPTIMIZER_PKG.gIndicators.last;
84: l_counter := BSC_METADATA_OPTIMIZER_PKG.gIndicators.next(l_counter);
85: end loop;
86: end if;
87:
88: l_stmt := 'insert into '||g_col_type_table_name||'(level_table_name, data_type)