DBA Data[Home] [Help]

APPS.BSC_UPDATE_BASE dependencies on BSC_UPDATE_DIM

Line 1616: h_dbi_dim_data BSC_UPDATE_DIM.t_dbi_dim_data;

1612:
1613: h_level_table_name VARCHAR2(30);
1614: h_level_short_name VARCHAR2(80);
1615: h_level_source VARCHAR2(10);
1616: h_dbi_dim_data BSC_UPDATE_DIM.t_dbi_dim_data;
1617:
1618: --Fix bug#3875046: need this variables
1619: h_lst_data_columns_temp_p VARCHAR2(32700);
1620: h_row_count NUMBER;

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

1755: FROM bsc_sys_dim_levels_b
1756: WHERE level_view_name = h_level_table_name;
1757:
1758: IF (h_level_source = 'PMF') AND (h_level_short_name IS NOT NULL) THEN
1759: BSC_UPDATE_DIM.Get_Dbi_Dim_Data(h_level_short_name, h_dbi_dim_data);
1760: IF (h_dbi_dim_data.short_name IS NOT NULL) AND
1761: (h_dbi_dim_data.table_name IS NOT NULL) AND
1762: (h_dbi_dim_data.materialized='YES') THEN
1763: IF BSC_APPS.Table_Exists(h_dbi_dim_data.table_name) THEN