Thaumasiotes has already explained the situation on campus in regards what is considered drunk and consent, but even in the wider world you can only give consent when not intoxicated. The level of intoxication is not clear cut, but at least in Australia it needs to be “substantial” [1]. What exactly is substantial is up to the jury.
The US case law is much more murky as this article explains [2].