The Dirty Little Mind of Martin Fink (1991)

Martin Fink, a sexually inexperienced play-write is hired by porn studio boss to crank out erotic screenplays. He gets a mentor in the deal, a burned-out hard-drinking porn hack named Bill Dollars, and further help from a couple loose women Bill knows.