You would have to verify fitment by matching the RPO code in the glovebox for the manual trans, and have the seller confirm it, but, most junkyards do not keep that info on hand for used parts, they just list make/model/year, GM is also notorious for having multiple part #'s and revisions for the same thing, and none of the Aveo models were actually built by GM, but by Daewoo further complicating the actual #'s...
However.... I looked at a GM part online site and came up with only ONE
manual trans for all Aveo/Aveo5/G3/Wave 2005-11:
RPO: Y4M
GM part #: 96957196 @ $1,600.00 (This is a replacement part #, not the same indexing system used for parts on a production line)
So it appears that any manual from a 2005-11 would work, as long as it is for a US/Can car. If the bearings can't be replaced (in my searching I was unable to find service parts for the box itself, only a new unit, I would consult a shop that has verifiable experience with manual boxes before taking it to them), then the lowest mileage box not crying oil out from the seals would be the only option, well beside that fancy new $1,600 unit...
The bearings can be replaced, of this I am sure, finding out what bearing size/type they are and removing the gearsets to access them would be the hardest part. In other words, if you can find a good local shop willing (key word) to do the work, it may be gone for a week or two while they wait on parts. But places like AAMCO/Goodyear service centers will only replace the entire unit, contrary to popular opinion, neither operation rebuilds one single part. They just swap 'em out!