Another user's package bodies will only be visible if you have select privileges on the sys.dba_objects and sys.dba_source views. The "Use DBA views if available" preference (Tools > Preferences > Options tab page) needs to be enabled. To debug another user's package bodies you additionally need the "create any procedure" system privilege. This is an Oracle Debug requirement.