APPS.BSC_UPDATE_BASE_V2 dependencies on BSC_UPDATE_DIM

Line 2740: h_dbi_dim_data BSC_UPDATE_DIM.t_dbi_dim_data;

2736:
2737: h_level_table_name VARCHAR2(100);
2738: h_level_short_name VARCHAR2(300);
2739: h_level_source VARCHAR2(100);
2740: h_dbi_dim_data BSC_UPDATE_DIM.t_dbi_dim_data;
2741:
2742: h_proc_name VARCHAR2(30);
2743: h_proc_temp VARCHAR2(30);
2744: h_proc_occur NUMBER;

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

2761: FROM bsc_sys_dim_levels_b
2762: WHERE level_view_name = h_level_table_name;
2763:
2764: IF (h_level_source = 'PMF') AND (h_level_short_name IS NOT NULL) THEN
2765: BSC_UPDATE_DIM.Get_Dbi_Dim_Data(h_level_short_name, h_dbi_dim_data);
2766: IF (h_dbi_dim_data.short_name IS NOT NULL) AND
2767: (h_dbi_dim_data.table_name IS NOT NULL) AND
2768: (h_dbi_dim_data.materialized='YES') THEN
2769: IF BSC_APPS.Table_Exists(h_dbi_dim_data.table_name) THEN

Line 2942: h_dbi_dim_data BSC_UPDATE_DIM.t_dbi_dim_data;

2938:
2939: h_level_table_name VARCHAR2(100);
2940: h_level_short_name VARCHAR2(300);
2941: h_level_source VARCHAR2(100);
2942: h_dbi_dim_data BSC_UPDATE_DIM.t_dbi_dim_data;
2943:
2944: h_bind_vars_values BSC_UPDATE_UTIL.t_array_of_number;
2945: h_num_bind_vars NUMBER;
2946:

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

2967: FROM bsc_sys_dim_levels_b
2968: WHERE level_view_name = h_level_table_name;
2969:
2970: IF (h_level_source = 'PMF') AND (h_level_short_name IS NOT NULL) THEN
2971: BSC_UPDATE_DIM.Get_Dbi_Dim_Data(h_level_short_name, h_dbi_dim_data);
2972: IF (h_dbi_dim_data.short_name IS NOT NULL) AND
2973: (h_dbi_dim_data.table_name IS NOT NULL) AND
2974: (h_dbi_dim_data.materialized='YES') THEN
2975: IF BSC_APPS.Table_Exists(h_dbi_dim_data.table_name) THEN