DBA Data[Home] [Help]

APPS.BSC_UPDATE_VAL dependencies on BSC_APPS

Line 264: IF BSC_APPS.bsc_mv THEN

260: -- BSC-BIS-DIMENSIONS: If the dimension is a DBI dimension and it is materialized and
261: -- the table exists then we validate against the table created in BSC to materialize
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

Line 270: IF BSC_APPS.Table_Exists(h_dbi_dim_data.table_name) 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
271: h_level_table_name := h_dbi_dim_data.table_name;
272: END IF;
273: END IF;
274: END IF;