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        		      