Get a list of all functions and procedures in an Oracle database
SELECT * FROM ALL_OBJECTS WHERE OBJECT_TYPE IN ('FUNCTION','PROCEDURE','PACKAGE')
You could use the view ALL_PROCEDURES.
SELECT * FROM ALL_PROCEDURES
From the results, the column OBJECT_NAME will show you the name of standalone functions and procedures, and packages names. The column PROCEDURE_NAME will show you the names of functions and procedures inside a package.