I want to change values of following access locked parameters using relations.
Here HOLE_TYPE is the user input parameter. Depending on the User input I want govern the Feature HOLE_2
You would need to do two thing to make this happened; one create your own custom hole table for the hole parameters and two, use family tables for the optional holes.
I say this because holes are a feature built on core Creo capabilities and a lot happens that you cannot access other than with hole tables. Also, changing hole type (different table entries) deletes and replaces the the hole in question. In a family table, you can toggle one or the other, but you cannot replace them.
Having said that, you could go back to the old behavior and just make a hole and a cosmetic thread. You can change the values of these at will (or even a revolve or extrude cut). With these more rudimentary features, you can use the relations to drive if statements.
This is not possible using the built-in standard holes. While you can change some of the dimensions of a hole feature via relations, you cannot change the selected size.
It's unfortunate too, because the built-in holes can do some things that homemade holes (groups of independent features) cannot.
I've attached a PDF showing the different hole parameters and where they can be accessed. FWIW.