APPS.BSC_OLAP_MAIN dependencies on BSC_APPS

Line 10: bsc_apps.init_bsc_apps;

6: procedure drop_tmp_col_type_table is
7: l_stmt varchar2(200);
8: begin
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:

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 21: g_summary_table_tbs_name := BSC_APPS.get_tablespace_name(BSC_APPS.summary_table_tbs_type);

17: end;
18:
19: procedure init_tbs_clause is
20: begin
21: g_summary_table_tbs_name := BSC_APPS.get_tablespace_name(BSC_APPS.summary_table_tbs_type);
22: g_summary_index_tbs_name := BSC_APPS.get_tablespace_name(BSC_APPS.summary_index_tbs_type);
23: if (g_summary_table_tbs_name is not null) then
24: g_summary_table_tbs_clause := ' TABLESPACE '|| g_summary_table_tbs_name;
25: end if;

Line 22: g_summary_index_tbs_name := BSC_APPS.get_tablespace_name(BSC_APPS.summary_index_tbs_type);

18:
19: procedure init_tbs_clause is
20: begin
21: g_summary_table_tbs_name := BSC_APPS.get_tablespace_name(BSC_APPS.summary_table_tbs_type);
22: g_summary_index_tbs_name := BSC_APPS.get_tablespace_name(BSC_APPS.summary_index_tbs_type);
23: if (g_summary_table_tbs_name is not null) then
24: g_summary_table_tbs_clause := ' TABLESPACE '|| g_summary_table_tbs_name;
25: end if;
26: if (g_summary_index_tbs_name is not null) then

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 116: execute immediate l_stmt using 'CODE', bsc_apps.get_user_schema('BSC'), 'CODE', bsc_apps.get_user_schema('APPS') ;

112: and col.column_name=:3
113: and col.owner =:4';
114:
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

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;