DBA Data[Home] [Help]

APPS.BSC_IM_UTILS dependencies on USER_SYNONYMS

Line 1199: cursor c1(p_table varchar2) is select table_owner from user_synonyms where synonym_name=p_table;

1195:
1196: function get_table_owner(p_table varchar2) return varchar2 is
1197: l_owner varchar2(400);
1198: l_stmt varchar2(4000);
1199: cursor c1(p_table varchar2) is select table_owner from user_synonyms where synonym_name=p_table;
1200: -----------------------------------
1201: Begin
1202: if g_debug then
1203: write_to_log_file_n('In get_table_owner'||get_time);

Line 1235: cursor c1(p_table varchar2) is select table_owner from user_synonyms where synonym_name=p_table;

1231:
1232: function get_object_owner(p_object varchar2) return varchar2 is
1233: l_owner varchar2(400);
1234: l_stmt varchar2(4000);
1235: cursor c1(p_table varchar2) is select table_owner from user_synonyms where synonym_name=p_table;
1236: Begin
1237: if g_debug then
1238: write_to_log_file_n('In get_object_owner '||p_object);
1239: end if;

Line 2635: g_stmt:='select TABLE_NAME,TABLE_OWNER from user_synonyms where synonym_name=:1';

2631: )return boolean is
2632: TYPE CurTyp IS REF CURSOR;
2633: cv CurTyp;
2634: Begin
2635: g_stmt:='select TABLE_NAME,TABLE_OWNER from user_synonyms where synonym_name=:1';
2636: if g_debug then
2637: write_to_log_file_n(g_stmt||' '||p_synonym);
2638: end if;
2639: open cv for g_stmt using p_synonym;