Closed operator functional calculus in Banach modules and applications