The six-time Grammy-winner and three-time Oscar recipient wrote chart-topping classics including "Walk on By" and "I Say a Little Prayer."