Posted on August 5th, 2007 by Sanjit Anand |
Print This Post
|
Email This Post
In oracle application there are several advanced techniques by which we can use when defining value sets for validating input. Normally such techniques use values obtained from a location other than a list specifically defined for the value set. These locations may includes:
- Values retrieved from an application table
- The current value for a particular profile option
- A value used earlier in a field on the form
- A value used earlier in another value set
Here are some information with advance validation options.
• Using $PROFILES$
This is used to reference the current value of a profile option in a WHERE clause by prefixing the name of the profile option with $PROFILES$.
Usage:
:$PROFILES$.profile_option_name
A typical example with the use this keyword in a WHERE clause to reference a profile option value.
….WHERE SET_OF_BOOKS_ID = :$PROFILES$.GL_SET_OF_BOOKS_ID
so what happen when ever the SET_OF_BOOKS_ID need to pass the $PROFILES$ options simply reference the value which is retrived at form level.
A list of available Profile options can be found in one of the last post.
• Using :Block.field
This is used to references the value of an earlier appearing field on the same form
Using :block.field is different from using a descriptive flex field reference field in that the flex field structure does not change based on the
different :block.field values.By Using this value set only with flex fields on windows that have the same block.field available.
• Using $FLEX$
This is used to references the value from a value set used earlier on the same form
You can refer to the current value of a previously used value set on the same form by using $FLEX$.value_set_name.
Usage
……WHERE JOURNAL_TYPE = :$FLEX$.GL_SRS_JOURNAL_TYPE