DBA Data[Home] [Help]

APPS.BSC_BIA_WRAPPER dependencies on BSC_APPS

Line 15: OWNNAME => BSC_APPS.BSC_APPS_SCHEMA,

11: BEGIN
12: IF Do_Analyze THEN
13: -- Fix perf bug#4583017: pass cascade = false
14: FND_STATS.gather_table_stats(
15: OWNNAME => BSC_APPS.BSC_APPS_SCHEMA,
16: TABNAME => p_table_name,
17: CASCADE => FALSE);
18: END IF;
19: END Analyze_Table;

Line 237: l_tablespace_param_tbl := 'TABLESPACE='||BSC_APPS.Get_Tablespace_Name(BSC_APPS.summary_table_tbs_type);

233: BEGIN
234:
235: l_kpi := TO_CHAR(p_kpi);
236:
237: l_tablespace_param_tbl := 'TABLESPACE='||BSC_APPS.Get_Tablespace_Name(BSC_APPS.summary_table_tbs_type);
238: l_tablespace_param_idx := 'INDEX TABLESPACE='||BSC_APPS.Get_Tablespace_Name(BSC_APPS.summary_index_tbs_type);
239:
240: l_storage_param := BSC_APPS.bsc_storage_clause;
241: -- Remove any other hint after ) like INITRANS

Line 238: l_tablespace_param_idx := 'INDEX TABLESPACE='||BSC_APPS.Get_Tablespace_Name(BSC_APPS.summary_index_tbs_type);

234:
235: l_kpi := TO_CHAR(p_kpi);
236:
237: l_tablespace_param_tbl := 'TABLESPACE='||BSC_APPS.Get_Tablespace_Name(BSC_APPS.summary_table_tbs_type);
238: l_tablespace_param_idx := 'INDEX TABLESPACE='||BSC_APPS.Get_Tablespace_Name(BSC_APPS.summary_index_tbs_type);
239:
240: l_storage_param := BSC_APPS.bsc_storage_clause;
241: -- Remove any other hint after ) like INITRANS
242: h_pos := INSTR(l_storage_param, ')');

Line 240: l_storage_param := BSC_APPS.bsc_storage_clause;

236:
237: l_tablespace_param_tbl := 'TABLESPACE='||BSC_APPS.Get_Tablespace_Name(BSC_APPS.summary_table_tbs_type);
238: l_tablespace_param_idx := 'INDEX TABLESPACE='||BSC_APPS.Get_Tablespace_Name(BSC_APPS.summary_index_tbs_type);
239:
240: l_storage_param := BSC_APPS.bsc_storage_clause;
241: -- Remove any other hint after ) like INITRANS
242: h_pos := INSTR(l_storage_param, ')');
243: IF h_pos > 0 THEN
244: l_storage_param := SUBSTR(l_storage_param, 1, h_pos);

Line 582: l_tablespace_param_idx := 'INDEX TABLESPACE='||BSC_APPS.Get_Tablespace_Name(BSC_APPS.summary_index_tbs_type);

578: -- The MV does not have corresponding KPI. So we do not need to refresh that MV.
579: RETURN TRUE;
580: END IF;
581:
582: l_tablespace_param_idx := 'INDEX TABLESPACE='||BSC_APPS.Get_Tablespace_Name(BSC_APPS.summary_index_tbs_type);
583:
584: l_storage_param := BSC_APPS.bsc_storage_clause;
585: -- Remove any other hint after ) like INITRANS
586: h_pos := INSTR(l_storage_param, ')');

Line 584: l_storage_param := BSC_APPS.bsc_storage_clause;

580: END IF;
581:
582: l_tablespace_param_idx := 'INDEX TABLESPACE='||BSC_APPS.Get_Tablespace_Name(BSC_APPS.summary_index_tbs_type);
583:
584: l_storage_param := BSC_APPS.bsc_storage_clause;
585: -- Remove any other hint after ) like INITRANS
586: h_pos := INSTR(l_storage_param, ')');
587: IF h_pos > 0 THEN
588: l_storage_param := SUBSTR(l_storage_param, 1, h_pos);