The Coca-Cola Co has scrapped plans for a campaign featuring footballer Wayne Rooney, following allegations that he slept with prostitutes.