Transactions SQL statements uses UDF's those needs to be part of transaction

UDF can have SQL statements , Those should be able work with current transaction context.
If SELECT those are fine. If mutation statements Those need to be treated single Unit of work as far original SQL statement considered and statement level atomicity must be maintained.