Previous  Next          Contents  Index  Navigation  Glossary  Library

Using Variables with Special and Pair Validation

You can use bind variables in your special validation user exit calls:

:$FLEX$. value_set_name Retrieves a value (the hidden ID value, if a hidden ID value is defined) in a prior segment.
:$PROFILES$. profile_option Retrieves the current value of a profile option. You must specify the option name of the profile option, such as GL_SET_OF_BKS_ID (which does not contain the Accounting Flexfield structure number).
Note that your profile option must be set wherever you use this value set (including the View Requests form if this value set is used as a report parameter and the user tries to view the status of the report after submission), or your user will see error messages.
:block.field Gets the current value in a field. You must ensure that this value set is only used for forms that have the same block.field.

Warning: The :block.field mechanism is present for backward compatibility only. Value sets that use this mechanism will not be compatible with a future release of Oracle Applications.

For example, the following user exit on a Validate event obtains the Structure (NUM) of the key flexfield from a profile option:

FND VALID 
	APPL_SHORT_NAME=SQLGL
	CODE="GL#"
	NUM=:$PROFILES$.MY_STRUCTURE_ID
	REQUIRED=Y
	VALIDATE=FULL
	ID=:!ID
	SEG=:!VALUE
	DESC=:!MEANING
	DINSERT=N 

See Also

Bind Variables: page - 38


         Previous  Next          Contents  Index  Navigation  Glossary  Library