select * from all_object a where a.object_type='procedure' and a.object_name like '%XXX%';

select * from all_object a where a.object_type='procedure' and a.object_name like '%XXX%';