call XXX.YYY.AlterAllInvalidObjects(NULL,'PACKAGE BODY');

GRANT EXECUTE ANY PROCEDURE TO user;

select 'GRANT EXECUTE ON '||owner||'.'||object_name||' TO user;'
from all_objects
where owner = 'xxx'
and object_type='FUNCTION';