select *
    FROM USER_IDENTIFIERS u
      WHERE u.Object_Type = 'PACKAGE' and u.type in ('FUNCTION','PROCEDURE') and u.object_name = 'my_package'

select *
    FROM USER_IDENTIFIERS u
      WHERE u.Object_Type = 'PACKAGE BODY' and u.type in ('FUNCTION','PROCEDURE') and u.object_name = 'my_package'

select  name, 
       type,
       decode(usage,'DECLARATION', 'body only', 'DEFINITION', 'spec and body', usage) defined_on,
       line body_line
  from user_identifiers ui
  where type in ('PROCEDURE', 'FUNCTION')
  and usage_context_id = (select usage_id
    from user_identifiers
      where object_name = ui.object_name
        and object_type = ui.object_type
        and usage_context_id = 0)
  and object_name = 'my_package'
  and object_type = 'PACKAGE BODY'
  order by name