Как проверить stateful/stateless пакета : Oracle

alter package ХХХ.ХХХ compile package; 

select i.object_name AS package,
       i.type,
       i.name        AS variable_name,
       i.object_type
  from user_identifiers i
 where i.object_type IN ('PACKAGE', 'PACKAGE BODY')
   and i.usage = 'DECLARATION'
   and i.type in ('VARIABLE', 'CONSTANT')
   and i.usage_context_id in
       (select i1.usage_id
          from user_identifiers i1
         where i1.type = 'PACKAGE'
           and i1.object_name = i.object_name);