PL/SQL (MOSC)

MOSC Banner

Enable/ Disable paramters based on another parameter - SPECIAL ValueSet

edited Jun 12, 2015 9:43AM in PL/SQL (MOSC) 1 comment

Hi Guys
I have a requirement to enable and disable the parameters of a concurrent program.....

The requirement is I have four date parameters
1. From Date
2. To Date
3. Original From Date
4. Original To Date

and also an ORG_ID parameter in my concurrent program

So i want From Date and To Date = DISABLED and Original From Date and To Date = ENABLED when ORG_ID= 123

and  From Date and To Date = ENABLED and Original From Date and To Date = DISABLED when ORG_ID <> 123

How can you achieve it using DUMMY.... do we have to use special VALUE SET.....if so can you please share with me the piece of code with a small example on how to disable and enable both sets of date parameters

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center