Live and Let Die: Did Paul McCartney write the Bond theme? Did it win an Oscar?

LIVE AND LET DIE has been regularly lauded as the best James Bond theme song - but did Paul McCartney write it?