APPS.BSC_DBI_CALENDAR dependencies on BIS_LEVELS

Line 42: l_stmt := 'select 1 from bis_levels lvl, bis_dimensions dim where lvl.dimension_id=dim.dimension_id and dim.short_name =:1 and lvl.short_name=:2';

38: cv CurTyp;
39: l_stmt varchar2(1000);
40: begin
41: --making it dynamic sql to not intorduce any bis dependency
42: l_stmt := 'select 1 from bis_levels lvl, bis_dimensions dim where lvl.dimension_id=dim.dimension_id and dim.short_name =:1 and lvl.short_name=:2';
43: open cv for l_stmt using p_dim, p_dim_object;
44: fetch cv into l_val;
45: close cv;
46: if (l_val=1) then

Line 3105: --cursor c1(p_dim varchar2) is select name from bis_levels_vl where short_name=p_dim;

3101: End;
3102:
3103: function get_bis_dim_long_name(p_dim varchar2, p_lang varchar2, p_source_lang out nocopy varchar2) return varchar2 is
3104: --
3105: --cursor c1(p_dim varchar2) is select name from bis_levels_vl where short_name=p_dim;
3106: cursor c1 is select name, source_lang from bis_levels_tl tl, bis_levels l
3107: where l.short_name = p_dim and
3108: l.level_id = tl.level_id and
3109: tl.language = p_lang;

Line 3106: cursor c1 is select name, source_lang from bis_levels_tl tl, bis_levels l

3102:
3103: function get_bis_dim_long_name(p_dim varchar2, p_lang varchar2, p_source_lang out nocopy varchar2) return varchar2 is
3104: --
3105: --cursor c1(p_dim varchar2) is select name from bis_levels_vl where short_name=p_dim;
3106: cursor c1 is select name, source_lang from bis_levels_tl tl, bis_levels l
3107: where l.short_name = p_dim and
3108: l.level_id = tl.level_id and
3109: tl.language = p_lang;
3110: --

Line 3114: write_to_log_file_n('select name from bis_levels_vl where short_name='||p_dim);

3110: --
3111: l_name varchar2(4000);
3112: Begin
3113: if g_debug then
3114: write_to_log_file_n('select name from bis_levels_vl where short_name='||p_dim);
3115: end if;
3116: open c1;
3117: fetch c1 into l_name,p_source_lang;
3118: close c1;