Subversion Repositories DevTools

SELECT *
  FROM  (
  
                /* ------- ERROR: Package Information Section Incomplete ------- */
                SELECT DISTINCT 'enum_MSG_PACKAGE_CHANGETYPE_INCOMPLETE' AS err_message,
                                            'fixed_issues.asp' AS rfile,
                                        '#CHANGE_TYPE' AS anchor,
                                1 AS priority,
                                            'ERROR' AS products_msg
                                   FROM PACKAGE_VERSIONS pv
                                  WHERE pv.pv_id = :PV_ID
                                    AND ( pv.CHANGE_TYPE IS NULL )
                                                    
                UNION

                /* ------- ERROR: Subversion to CC regression ------- */
                SELECT DISTINCT 'enum_MSG_VCS_SUBVERSION_CC_MIX' AS err_message,
                           'fixed_issues.asp' AS rfile,
                       '#PACKAGE_INFORMATION' AS anchor,
               11 AS priority,
                           'ERROR' AS products_msg
         FROM  PACKAGE_VERSIONS pv,
               VCS_TYPE vt
                 WHERE pv.pv_id = :PV_ID
           AND pv.vcs_type_id  = vt.vcs_type_id
                   AND ( vt.tag = 'CC' or vt.tag = 'CVS' )
                   AND ( PK_RMAPI.IsSVN(pv.pkg_id) > 0 )

         
                ) errmsg
ORDER BY priority