These are Oracle based PLSQL packages or SQL scripts.  Some have been updated to work with the latest versions of the Oracle database, others may be restricted to specific versions.  See the documentation for specific details.