Search notes:

Oracle: DBA_PROCEDURES

Lists all procedures and functions (including those that are found in PL/SQL packages, PL/SQL types and triggers).
This view comes in all four variants: 
select
   prc.owner,
   prc.object_name,
   prc.object_type,
   prc.procedure_name,
   prc.subprogram_id,
   prc.aggregate,
   prc.result_cache,
   prc.authid,
   prc.deterministic,
   prc.interface,
   prc.overload,
   prc.parallel,
   prc.pipelined,
   prc.polymorphic,
   prc.impltypename,
   prc.impltypeowner,
   prc.origin_con_id,
   prc.object_id
from
   dba_procedures prc
where
   prc.owner        =  user    and
   prc.object_name  = 'XYZ'
order by
   prc.object_type,
   prc.object_name,
   prc.procedure_name
;

OBJECT_NAME, PROCEDURE_NAME

Names of global stored procedures and functions (that are not defined in a PL/SQL package) are recorded in object_name.
Names of stored procedures and functions that are defined in a PL/SQL package are recorded in procedure_name. In this case, object_name is the name of the PL/SQL package.

See also

A procedure's or function's argument names and types are listed in dba_arguments.
The source code of a PL/SQL object (function, procedure, package or type) can be queried from dba_source.

Index