DBA Data[Home] [Help]

APPS.BSC_OLAP_MAIN dependencies on AD_DDL

Line 13: BSC_APPS.Do_DDL(l_stmt, ad_ddl.drop_table, g_col_type_table_name);

9: --drop table
10: bsc_apps.init_bsc_apps;
11: b_table_col_type_created:=false;
12: l_stmt:= 'drop table '||g_col_type_table_name;
13: BSC_APPS.Do_DDL(l_stmt, ad_ddl.drop_table, g_col_type_table_name);
14:
15: Exception when others then
16: null;
17: end;

Line 54: BSC_APPS.Do_DDL(l_stmt, ad_ddl.create_table, g_col_type_table_name);

50: -- If we are running GDB in incremental/selective mode then we will consider
51: -- kpis only in prototype mode or being processed in current run.
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)

Line 119: BSC_APPS.Do_DDL(l_stmt, ad_ddl.create_index, g_col_type_table_name||'_u1');

115: END IF;
116: execute immediate l_stmt using 'CODE', bsc_apps.get_user_schema('BSC'), 'CODE', bsc_apps.get_user_schema('APPS') ;
117: --create index on table
118: l_stmt := 'create unique index '||g_col_type_table_name||'_u1 on '||g_col_type_table_name||'(level_table_name)'||g_summary_index_tbs_clause;
119: BSC_APPS.Do_DDL(l_stmt, ad_ddl.create_index, g_col_type_table_name||'_u1');
120: if g_debug then
121: write_to_log_file_n('End of create_tmp_col_type_table '||get_time);
122: end if;
123: return true;