DBA_PROCEDURES

Description of all procedures

Columns
   ___________________________
 
   OWNER
      --
   OBJECT_NAME
      Name of the object : top level function/procedure/package name
   PROCEDURE_NAME
      Name of the procedure
   AGGREGATE
      Is it an aggregate function ?
   PIPELINED
      Is it a pipelined table function ?
   IMPLTYPEOWNER
      Name of the owner of the implementation type (if any)
   IMPLTYPENAME
      Name of the implementation type (if any)
   PARALLEL
      Is the procedure parallel enabled ?
   INTERFACE
      --
   DETERMINISTIC
      --
   AUTHID
      --

Related:

Simon Sheppard
SS64.com