SYSTEM.AD_INVOKER dependencies on DBA_SOURCE

Line 883: select text from dba_source

879: is
880: success_with_comp_error exception;
881: PRAGMA EXCEPTION_INIT(success_with_comp_error, -24344);
882: cursor c1 is
883: select text from dba_source
884: where owner = upper(rewrite_a_package.owner)
885: and name = upper(rewrite_a_package.name)
886: and type = upper(rewrite_a_package.type)
887: order by line;

Line 2471: select text from dba_source

2467: -- even though this is not true.
2468: --
2469: is
2470: cursor c1 is
2471: select text from dba_source
2472: where owner = upper(classify_plsql_object.owner)
2473: and name = upper(classify_plsql_object.name)
2474: and type = upper(classify_plsql_object.type)
2475: order by line;

Line 2483: from dba_source s

2479: select
2480: substr(s.text, instr(s.text,'$Header'||': '),
2481: ((instr(s.text,' $', instr(s.text,'$Header'||': ')) + 2)
2482: - instr(s.text,'$Header'||': ')))
2483: from dba_source s
2484: where s.owner= upper(c_owner)
2485: and s.name = upper(c_name)
2486: and s.type = upper(c_type)
2487: and s.line between 2 and 5