APPS.BSC_METADATA dependencies on BSC_UPDATE_DIM

Line 150: for now, we will call bsc_update_dim.Get_Dbi_Dim_Data

146: /*
147: for DBI dim. read the static package
148:
149: discussed with arun : 03/10/05
150: for now, we will call bsc_update_dim.Get_Dbi_Dim_Data
151:
152: called only for NON REC dim
153: DBI dim are single level dim. we should modify this api to handle multi level dim
154: */

Line 163: l_data_source BSC_UPDATE_DIM.t_dbi_dim_data;

159: p_inc_data_source out nocopy varchar2
160: ) is
161: --
162: l_level_short_name varchar2(100);
163: l_data_source BSC_UPDATE_DIM.t_dbi_dim_data;
164: l_code varchar2(100);
165: Begin
166: for i in 1..p_level_list.count loop
167: l_level_short_name:=get_level_short_name(p_level_list(i));

Line 168: bsc_update_dim.Get_Dbi_Dim_Data(l_level_short_name,l_data_source);

164: l_code varchar2(100);
165: Begin
166: for i in 1..p_level_list.count loop
167: l_level_short_name:=get_level_short_name(p_level_list(i));
168: bsc_update_dim.Get_Dbi_Dim_Data(l_level_short_name,l_data_source);
169: if l_data_source.short_name is not null then
170: --this is dbi dim
171: l_code:='CODE';
172: if l_data_source.code_col is not null then

Line 209: l_data_source BSC_UPDATE_DIM.t_dbi_dim_data;

205: p_denorm_change_data_source out nocopy varchar2
206: ) is
207: --
208: l_level_short_name varchar2(100);
209: l_data_source BSC_UPDATE_DIM.t_dbi_dim_data;
210: l_value varchar2(100);
211: l_string varchar2(8000);
212: Begin
213: l_level_short_name:=get_level_short_name(p_dim_level);

Line 214: bsc_update_dim.Get_Dbi_Dim_Data(l_level_short_name,l_data_source);

210: l_value varchar2(100);
211: l_string varchar2(8000);
212: Begin
213: l_level_short_name:=get_level_short_name(p_dim_level);
214: bsc_update_dim.Get_Dbi_Dim_Data(l_level_short_name,l_data_source);
215: if l_data_source.denorm_table is not null then
216: p_child_col:=l_data_source.child_col;
217: p_parent_col:=l_data_source.parent_col;
218: p_position_col:=l_data_source.parent_level_col;