You can get SQL_TEXT/SQL_FULLTEXT from V$SQLAREA by PROGRAM_ID, PROGRAM_LINE# , where PROGRAM_ID is OBJECT_ID from DBA_OBJECTS. But considering the dynamic nature of those packages, I don't think it's worth to reverse-engineer them.