SYS.OWA_UTIL dependencies on ALL_SYNONYMS

Line 118: o_name out all_synonyms.table_name%type,

114: /**************************************/
115: function get_synonym_defn(
116: csynonym in varchar2,
117: cschema in varchar2,
118: o_name out all_synonyms.table_name%type,
119: o_owner out all_synonyms.table_owner%type,
120: o_db_link out all_synonyms.db_link%type
121: ) return boolean is
122: stmt_cursor number; -- stmt cursor

Line 119: o_owner out all_synonyms.table_owner%type,

115: function get_synonym_defn(
116: csynonym in varchar2,
117: cschema in varchar2,
118: o_name out all_synonyms.table_name%type,
119: o_owner out all_synonyms.table_owner%type,
120: o_db_link out all_synonyms.db_link%type
121: ) return boolean is
122: stmt_cursor number; -- stmt cursor
123: rc number; -- return code

Line 120: o_db_link out all_synonyms.db_link%type

116: csynonym in varchar2,
117: cschema in varchar2,
118: o_name out all_synonyms.table_name%type,
119: o_owner out all_synonyms.table_owner%type,
120: o_db_link out all_synonyms.db_link%type
121: ) return boolean is
122: stmt_cursor number; -- stmt cursor
123: rc number; -- return code
124: name all_synonyms.table_name%type;

Line 124: name all_synonyms.table_name%type;

120: o_db_link out all_synonyms.db_link%type
121: ) return boolean is
122: stmt_cursor number; -- stmt cursor
123: rc number; -- return code
124: name all_synonyms.table_name%type;
125: owner all_synonyms.table_owner%type;
126: db_link all_synonyms.db_link%type;
127: begin
128: stmt_cursor := dbms_sql.open_cursor;

Line 125: owner all_synonyms.table_owner%type;

121: ) return boolean is
122: stmt_cursor number; -- stmt cursor
123: rc number; -- return code
124: name all_synonyms.table_name%type;
125: owner all_synonyms.table_owner%type;
126: db_link all_synonyms.db_link%type;
127: begin
128: stmt_cursor := dbms_sql.open_cursor;
129: sys.dbms_sys_sql.parse_as_user(stmt_cursor,

Line 126: db_link all_synonyms.db_link%type;

122: stmt_cursor number; -- stmt cursor
123: rc number; -- return code
124: name all_synonyms.table_name%type;
125: owner all_synonyms.table_owner%type;
126: db_link all_synonyms.db_link%type;
127: begin
128: stmt_cursor := dbms_sql.open_cursor;
129: sys.dbms_sys_sql.parse_as_user(stmt_cursor,
130: 'begin

Line 133: from all_synonyms

129: sys.dbms_sys_sql.parse_as_user(stmt_cursor,
130: 'begin
131: select table_name, table_owner, db_link
132: into :name, :owner, :db_link
133: from all_synonyms
134: where synonym_name = upper(:csynonym)
135: and owner = upper(:cschema);
136: exception
137: when others then