eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BSC_BSC_ADAPTER dependencies on BSC_UPDATE_DIM

Line 3304: l_dbi_dim_data BSC_UPDATE_DIM.t_dbi_dim_data;

3300: --------------------------------------------
3301: cursor c1(p_col varchar2) is select level_table_name,short_name from bsc_sys_dim_levels_b where upper(level_pk_col)=upper(p_col);
3302: --------------------------------------------
3303: l_name varchar2(200);
3304: l_dbi_dim_data BSC_UPDATE_DIM.t_dbi_dim_data;
3305:
3306: Begin
3307: if NOT g_level_info_cached then
3308: cache_level_info;

Line 3335: BSC_UPDATE_DIM.Get_Dbi_Dim_Data(l_name,l_dbi_dim_data);

3331: p_rec_dim_key:=null;
3332:
3333: --BSC E2E : see if this is a dbi dimension and see if there is table associated with this level
3334:
3335: BSC_UPDATE_DIM.Get_Dbi_Dim_Data(l_name,l_dbi_dim_data);
3336: if l_dbi_dim_data.table_name is null then
3337: -- Check if this is a non-DBI recursive dimension
3338: if is_recursive_dim(p_level, p_rec_dim)=false then
3339: return false;

Line 6323: write_to_log_file_n('Going to call bsc_update_dim.Create_Dbi_Dim_Tables');

6319: write_to_log_file_n('In create_dbi_dim_tables');
6320: end if;
6321: if g_create_dbi_dim_tables is null or g_create_dbi_dim_tables=false then
6322: if g_debug then
6323: write_to_log_file_n('Going to call bsc_update_dim.Create_Dbi_Dim_Tables');
6324: end if;
6325: if bsc_update_dim.Create_Dbi_Dim_Tables(l_error_message)=false then
6326: BSC_IM_UTILS.g_status_message:=l_error_message;
6327: g_status_message:=l_error_message;

Line 6325: if bsc_update_dim.Create_Dbi_Dim_Tables(l_error_message)=false then

6321: if g_create_dbi_dim_tables is null or g_create_dbi_dim_tables=false then
6322: if g_debug then
6323: write_to_log_file_n('Going to call bsc_update_dim.Create_Dbi_Dim_Tables');
6324: end if;
6325: if bsc_update_dim.Create_Dbi_Dim_Tables(l_error_message)=false then
6326: BSC_IM_UTILS.g_status_message:=l_error_message;
6327: g_status_message:=l_error_message;
6328: write_to_log_file_n('Error bsc_update_dim.Create_Dbi_Dim_Tables '||l_error_message);
6329: return false;

Line 6328: write_to_log_file_n('Error bsc_update_dim.Create_Dbi_Dim_Tables '||l_error_message);

6324: end if;
6325: if bsc_update_dim.Create_Dbi_Dim_Tables(l_error_message)=false then
6326: BSC_IM_UTILS.g_status_message:=l_error_message;
6327: g_status_message:=l_error_message;
6328: write_to_log_file_n('Error bsc_update_dim.Create_Dbi_Dim_Tables '||l_error_message);
6329: return false;
6330: end if;
6331: g_create_dbi_dim_tables:=true; --create these tables only once
6332: end if;

Line 6349: l_dbi_dim_data BSC_UPDATE_DIM.t_array_dbi_dim_data;

6345: p_dim_list out nocopy bsc_varchar2_table_type,
6346: p_num_dim_list out nocopy number,
6347: p_error_message out nocopy varchar2) is
6348: --
6349: l_dbi_dim_data BSC_UPDATE_DIM.t_array_dbi_dim_data;
6350: l_num_dbi_dim_data number;
6351: --
6352: Begin
6353: --p_dim_list.delete;

Line 6355: BSC_UPDATE_DIM.Get_All_Dbi_Dim_Data(l_dbi_dim_data);

6351: --
6352: Begin
6353: --p_dim_list.delete;
6354: p_num_dim_list:=0;
6355: BSC_UPDATE_DIM.Get_All_Dbi_Dim_Data(l_dbi_dim_data);
6356: l_num_dbi_dim_data:=l_dbi_dim_data.count;
6357: p_dim_list:=bsc_varchar2_table_type();
6358: for i in 1..l_num_dbi_dim_data loop
6359: if l_dbi_dim_data(i).top_n_levels is not null and l_dbi_dim_data(i).top_n_levels>0 then

Line 6373: p_dim_list out nocopy BSC_UPDATE_DIM.t_array_dbi_dim_data

6369: End;
6370:
6371: --internal API
6372: procedure get_list_of_rec_dim(
6373: p_dim_list out nocopy BSC_UPDATE_DIM.t_array_dbi_dim_data
6374: ) is
6375: --
6376: l_dbi_dim_data BSC_UPDATE_DIM.t_array_dbi_dim_data;
6377: l_num_dbi_dim_data number;

Line 6376: l_dbi_dim_data BSC_UPDATE_DIM.t_array_dbi_dim_data;

6372: procedure get_list_of_rec_dim(
6373: p_dim_list out nocopy BSC_UPDATE_DIM.t_array_dbi_dim_data
6374: ) is
6375: --
6376: l_dbi_dim_data BSC_UPDATE_DIM.t_array_dbi_dim_data;
6377: l_num_dbi_dim_data number;
6378: l_count number;
6379: --
6380: Begin

Line 6382: BSC_UPDATE_DIM.Get_All_Dbi_Dim_Data(l_dbi_dim_data);

6378: l_count number;
6379: --
6380: Begin
6381: p_dim_list.delete;
6382: BSC_UPDATE_DIM.Get_All_Dbi_Dim_Data(l_dbi_dim_data);
6383: l_num_dbi_dim_data:=l_dbi_dim_data.count;
6384: l_count:=0;
6385: for i in 1..l_num_dbi_dim_data loop
6386: if l_dbi_dim_data(i).top_n_levels is not null and l_dbi_dim_data(i).top_n_levels>0 then