piss bucket drunk
Keeping a piss bucket by the side of the bed because you're so drunk you can't even get up to take a piss.
Frankie is piss bucket drunk. He's been on such a bender that he just stays in bed all day and pisses into a bucket when he has to take a leak.