...
/* Следующие операторы GRANT сгенерированы автоматически */

GRANT EXECUTE ON PACKAGE CHECK_NAME_UTILS TO PACKAGE CHECK_NAME_UTILS;
...

SET TERM ^ ;

CREATE OR ALTER PACKAGE MY_PACK
AS
begin
 
end^

RECREATE PACKAGE BODY MY_PACK
AS
begin
  procedure P1
  as
  begin
  end

  procedure P2
  as
  begin
    execute procedure MY_PACK.P1;
  end
end^

SET TERM ; ^

/* Следующие операторы GRANT сгенерированы автоматически */

GRANT EXECUTE ON PACKAGE MY_PACK TO PACKAGE MY_PACK;