Get information on all the procedures you have access to using all_procedures. : all_procedures « System Tables Data Dictionary « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. System Tables Data Dictionary
3. all_procedures

SQL>
SQL> desc all_procedures;
 Name                  Null?    Type
 ----------------------

 OWNER                 NOT NULL VARCHAR2(30)
 OBJECT_NAME           NOT NULL VARCHAR2(30)
 PROCEDURE_NAME                 VARCHAR2(30)
 AGGREGATE                      VARCHAR2(3)
 PIPELINED                      VARCHAR2(3)
 IMPLTYPEOWNER                  VARCHAR2(30)
 IMPLTYPENAME                   VARCHAR2(30)
 PARALLEL                       VARCHAR2(3)
 INTERFACE                      VARCHAR2(3)
 DETERMINISTIC                  VARCHAR2(3)
 AUTHID                         VARCHAR2(12)

SQL>
SQL> --select * from all_procedures;
SQL>
SQL>
SQL>