APPS.BSC_IM_UTILS dependencies on USER_VIEWS

Line 1761: g_stmt:='select 1 from user_views where view_name=:a';

1757: TYPE CurTyp IS REF CURSOR;
1758: cv CurTyp;
1759: Begin
1760: if p_view_owner is null then
1761: g_stmt:='select 1 from user_views where view_name=:a';
1762: write_to_debug_n(g_stmt||' using '||p_view_name);
1763: open cv for g_stmt using p_view_name;
1764: else
1765: g_stmt:='select 1 from all_views where view_name=:a and owner=:b';

Line 3201: cursor c1(p_view varchar2) is select 1 from user_views where view_name like p_view;

3197: function is_view_present(p_view_like varchar2) return boolean is
3198: l_present boolean;
3199: l_res number;
3200: ---------------------------
3201: cursor c1(p_view varchar2) is select 1 from user_views where view_name like p_view;
3202: ---------------------------
3203: Begin
3204: if g_debug then
3205: write_to_log_file_n('select 1 from user_views where view_name like '||p_view_like);

Line 3205: write_to_log_file_n('select 1 from user_views where view_name like '||p_view_like);

3201: cursor c1(p_view varchar2) is select 1 from user_views where view_name like p_view;
3202: ---------------------------
3203: Begin
3204: if g_debug then
3205: write_to_log_file_n('select 1 from user_views where view_name like '||p_view_like);
3206: end if;
3207: open c1(p_view_like);
3208: fetch c1 into l_res;
3209: close c1;