How to validate profile value against fnd_profile_options.sql_validation programmatically
Hello, we would know if it is posible to create a plsql function that before set a profile user value check if this value is valid against sql_validation in fnd_profile_options table
for example how to use this text:
SQL="SELECT MEANING \"Log Enabled\", LOOKUP_CODE
into :visible_option_value,
:profile_option_value
from fnd_lookups
where lookup_type = 'YES_NO'"
COLUMN="\"Log Enabled\"(30)"
in plsql code to check if a value pass it, it was an example of the sql_validation field for a profile we would like to use in gral for any profile defined
thank you