how about

select owner, object_name from all_objects
where object_type in ('PROCEDURE', 'FUNCTION', 'PACKAGE')
and owner <> user
/