Night shifts at Nissan's Sunderland plant in north east England are to end, according to the local union.