Will illegal immigration to the US from South/Central America wane due to new oil discoveries to the south?

No, the governments south of the boarder will not increase their welfare programs. They will not have free medical, and hospitalization. They will not have Social Security without having never paid into it. Their governments will not send their kids through college for nothing.