DBA Data[Home] [Help]

APPS.BSC_UPDATE_VAL dependencies on BSC_UPDATE_DIM

Line 153: h_dbi_dim_data BSC_UPDATE_DIM.t_dbi_dim_data;

149: h_column_name bsc_db_tables_cols.column_name%TYPE;
150: h_level_table_name bsc_sys_dim_levels_b.level_view_name%TYPE;
151: h_level_short_name bsc_sys_dim_levels_b.short_name%TYPE;
152: h_level_source bsc_sys_dim_levels_b.short_name%TYPE;
153: h_dbi_dim_data BSC_UPDATE_DIM.t_dbi_dim_data;
154:
155: h_sql VARCHAR2(2000);
156:
157: h_periodicity NUMBER;

Line 266: BSC_UPDATE_DIM.Get_Dbi_Dim_Data(h_level_short_name, h_dbi_dim_data);

262: -- the DBI dimension. It has USER_CODE column. Note that is only in MV Architecture.
263:
264: IF BSC_APPS.bsc_mv THEN
265: IF (h_level_source = 'PMF') AND (h_level_short_name IS NOT NULL) THEN
266: BSC_UPDATE_DIM.Get_Dbi_Dim_Data(h_level_short_name, h_dbi_dim_data);
267: IF (h_dbi_dim_data.short_name IS NOT NULL) AND
268: (h_dbi_dim_data.table_name IS NOT NULL) AND
269: (h_dbi_dim_data.materialized='YES') THEN
270: IF BSC_APPS.Table_Exists(h_dbi_dim_data.table_name) THEN