Script to find Oracle API's in any module

  SELECT SUBSTR (a.OWNER, 1, 20) "OWNER",
         SUBSTR (a.NAME, 1, 20) "NAME",
         SUBSTR (a.TYPE, 1, 20) "TYPE",
         SUBSTR (u.STATUS, 1, 20) "STAT",
         u.last_ddl_time,
         SUBSTR (text, 1, 80) "DESC"
    FROM dba_source a, dba_objects u
   WHERE     1 = 1
         AND u.object_name = a.name
         AND a.text LIKE '%Header%'
         AND a.TYPE = u.object_type
         AND a.name LIKE '%&NAME%'     -- GIVE THE NAME
ORDER BY A.OWNER, A.NAME