Get list of all Stored Procedure in ORACLE

To get list of all Stored Procedure in an Oracle DB, run the following query:

Select * from ALL_OBJECTS
WHERE OBJECT_TYPE IN ('PACKAGE')

..............

If you want to search through a specific stored procedure use the following as an example:

Select * from ALL_OBJECTS
WHERE OBJECT_TYPE IN ('PACKAGE')

AND
OBJECT_NAME like '%VILTERSH%'