OWAPUB.OWA_UTIL dependencies on ALL_SYNONYMS

Line 87: o_name out all_synonyms.table_name%type,

83: /**************************************/
84: function get_synonym_defn(
85: csynonym in varchar2,
86: cschema in varchar2,
87: o_name out all_synonyms.table_name%type,
88: o_owner out all_synonyms.table_owner%type,
89: o_db_link out all_synonyms.db_link%type
90: ) return boolean is
91: stmt_cursor number; -- stmt cursor

Line 88: o_owner out all_synonyms.table_owner%type,

84: function get_synonym_defn(
85: csynonym in varchar2,
86: cschema in varchar2,
87: o_name out all_synonyms.table_name%type,
88: o_owner out all_synonyms.table_owner%type,
89: o_db_link out all_synonyms.db_link%type
90: ) return boolean is
91: stmt_cursor number; -- stmt cursor
92: rc number; -- return code

Line 89: o_db_link out all_synonyms.db_link%type

85: csynonym in varchar2,
86: cschema in varchar2,
87: o_name out all_synonyms.table_name%type,
88: o_owner out all_synonyms.table_owner%type,
89: o_db_link out all_synonyms.db_link%type
90: ) return boolean is
91: stmt_cursor number; -- stmt cursor
92: rc number; -- return code
93: name all_synonyms.table_name%type;

Line 93: name all_synonyms.table_name%type;

89: o_db_link out all_synonyms.db_link%type
90: ) return boolean is
91: stmt_cursor number; -- stmt cursor
92: rc number; -- return code
93: name all_synonyms.table_name%type;
94: owner all_synonyms.table_owner%type;
95: db_link all_synonyms.db_link%type;
96: begin
97: stmt_cursor := dbms_sql.open_cursor;

Line 94: owner all_synonyms.table_owner%type;

90: ) return boolean is
91: stmt_cursor number; -- stmt cursor
92: rc number; -- return code
93: name all_synonyms.table_name%type;
94: owner all_synonyms.table_owner%type;
95: db_link all_synonyms.db_link%type;
96: begin
97: stmt_cursor := dbms_sql.open_cursor;
98: sys.dbms_sys_sql.parse_as_user(stmt_cursor,

Line 95: db_link all_synonyms.db_link%type;

91: stmt_cursor number; -- stmt cursor
92: rc number; -- return code
93: name all_synonyms.table_name%type;
94: owner all_synonyms.table_owner%type;
95: db_link all_synonyms.db_link%type;
96: begin
97: stmt_cursor := dbms_sql.open_cursor;
98: sys.dbms_sys_sql.parse_as_user(stmt_cursor,
99: 'begin

Line 102: from all_synonyms

98: sys.dbms_sys_sql.parse_as_user(stmt_cursor,
99: 'begin
100: select table_name, table_owner, db_link
101: into :name, :owner, :db_link
102: from all_synonyms
103: where synonym_name = upper(:csynonym)
104: and owner = upper(:cschema);
105: exception
106: when others then