select object_name from all_objects
where object_type in ('PROCEDURE', 'FUNCTION', 'PACKAGE')

may be is this what you are looking for?