weenieheaded

adj.

Sufficiently drunk to become a small-minded nuisance of no practical value.

Source: Wiktionary