Dunno if there is a term for the type of joke, but it seems to come from the same family as the 'Tom Swifties' (another thread somewhere here), and the old t-shirt ones: "Dress designers do it in style", "Accountants do it with double entries" and so on.

cheer

the sunshine warrior

ps: bladdered, wasted, out of it, arseholed come to mind...