SYS.OWA_UTIL dependencies on ALL_SOURCE

Line 221: /* Function to open cursor for all_source to get definition of proc/fn */

217: o_procname := procname;
218: end name_resolve;
219:
220: /***********************************************************************/
221: /* Function to open cursor for all_source to get definition of proc/fn */
222: /***********************************************************************/
223: function open_source_cursor(
224: o in varchar2, -- procowner
225: n in varchar2 -- procname

Line 230: line all_source.line%type;

226: ) return number is
227: stmt_cursor number; -- stmt cursor
228: rc number; -- return code
229: nm varchar2(255);
230: line all_source.line%type;
231: text all_source.text%type;
232: begin
233: rc := instr(n, '.');
234: if (rc > 0)

Line 231: text all_source.text%type;

227: stmt_cursor number; -- stmt cursor
228: rc number; -- return code
229: nm varchar2(255);
230: line all_source.line%type;
231: text all_source.text%type;
232: begin
233: rc := instr(n, '.');
234: if (rc > 0)
235: then

Line 243: from all_source

239: end if;
240: stmt_cursor := dbms_sql.open_cursor;
241: sys.dbms_sys_sql.parse_as_user(stmt_cursor,
242: 'select line, text
243: from all_source
244: where name = upper(:n)
245: and owner = upper(:o)
246: order by type, line', dbms_sql.v7);
247: dbms_sql.bind_variable(stmt_cursor, ':o', o);

Line 256: /* Function to fetch cursor for all_source to get definition of proc/fn */

252: return(stmt_cursor);
253: end open_source_cursor;
254:
255: /************************************************************************/
256: /* Function to fetch cursor for all_source to get definition of proc/fn */
257: /************************************************************************/
258: function fetch_source_cursor(
259: stmt_cursor in number,
260: line out number,

Line 275: /* Function to close cursor for all_source */

271: end if;
272: end fetch_source_cursor;
273:
274: /*******************************************/
275: /* Function to close cursor for all_source */
276: /*******************************************/
277: procedure close_source_cursor(stmt_cursor in out number) is
278: begin
279: dbms_sql.close_cursor(stmt_cursor);

Line 292: line all_source.line%type;

288:
289: stmt_cursor number; -- stmt cursor
290:
291: line1s integer := 0;
292: line all_source.line%type;
293: text all_source.text%type;
294: begin
295:
296: name_resolve(cname, procowner, procname);

Line 293: text all_source.text%type;

289: stmt_cursor number; -- stmt cursor
290:
291: line1s integer := 0;
292: line all_source.line%type;
293: text all_source.text%type;
294: begin
295:
296: name_resolve(cname, procowner, procname);
297: