Public intoxication is a class C misdemeanor in Texas, punishable only with a civil fine. It's the criminal equivalent of a traffic infraction. So the worst your friend is looking at is a fine. There would be a record of his conviction if he pled guilty to this, but that record doesn't go any higher than the local court level. By that I mean,there's a copy of this filed with the court, but it should not show up on an official state or federal background check.
According to Sec. 12.03(c) of the Texas penal code, a conviction on a class C misdemeanor doesn't impose any kind of criminal or legal liability on the offender. So it is not in the state or Federal criminal data base and your friend wouldn't have to disclose it.
On the other hand, a copy remains in the courthouse and it is not under seal. That means it's a public record and could potentially be found by private background check companies. It won't turn up on his RAP sheet, but someone doing a thorough background check could potentially find it anyway.
Texas will not remove convictions from a person's record unless they have first been pardoned by the governor, even for a Class C misdemeanor. So your friend may want to retain a lawyer and see if he could negotiate a diversion type of disposition. This is where he'd have a period of supervision, pay some fines, do some community service and stay out of further trouble with the law.
Complete it all successfully and the case gets dismissed. Diversion is more work than paying a fine, but in the long run it's worth it because If your friend can get diversion, then his record can be expunged. If your friend can't get diversion but can get a deferral and community supervision, he could get an order of non-disclosure, which means the record would be sealed.
If you require additional information, please post your follow up here on this question thread, and I’ll be happy to provide it.
If I have addressed all of your concerns, please take the time to rate my service to you by selecting 3, 4, or 5 stars, as that is the only way that JustAnswer gives us Experts credit for our work here. You would still be able to ask further follow ups about this incident for no additional cost, even after I've been rated.