API to identify whether form/web (oaf) interface using sql
Hi All,
Is there are way to identify the interface in which the query is being run - Forms or OAF page - using sql?
Why do I need this?
There is a table type validation query we are using to display Yes/No values in a DFF segment.
The select query is like this
SELECT meaning, lookup_code
fnd_lookup_values
WHERE LOOKUP_TYPE = 'YES_NO_LOOKUP'
AND ENABLED_FLAG = 'Y'
AND LANGUAGE = USERENV('LANG')
This is store the translated value in backend from OAF page as per user language.
If one stores information in French in the DFF segment(Forms/OAF interface) and views the same using Forms interface in English, it will display error message that value is not present in value set.