ALL_PROCEDURES

Description of all procedures available to the user

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