Hi

You can get that from all_objects..

something like

select object_name,owner,object_type
from all_objects
where object_type in ('PROCEEDURE','FUNCTION');

regards
Hrishy