Public Morals (1996)

Fogarty arrests veteran prostitute Vivian La Rue. While interrogating her, he seeks some advice after admitting that the pressures of acting as captain is making it hard for him to satisfy his sexually demanding wife. A few days later, he announces to the squad room that Captain Chung has died in hospital. He is now gripped by even more nerves about giving the eulogy at Chung's funeral and the prospect of becoming captain. He eventually rises to both challenges and is able to report to Vivian that his wife is happy too.