procedures,functions,packages

select object_name from dba_objects where owner='jephe' and object_type='PROCEDURE';
note: select all procedures from jephe tablespace.