CO Spectral Line Energy Distributions of IR-luminous galaxies and AGN