Songwriter, who had a decades-long writing partnership with husband Barry Mann, best known for penning 'You've Lost That Lovin' Feeling'