 How to Erase (or) Reset The User Parameters? [message #282378] |
Wed, 21 November 2007 14:14 |
mnanias
Messages: 40
Registered: September 2007
Location: AMERICA
|
Member |
|
|
Hi all,
My requirement is something similar to this.
I need to display the records in a typical Emp table where the user parameters will be job_type which could be 'Manager'
or 'Clerk'. I had created two user parameters called Manager and Clerk and gave LOV's to both parameters as 'Y' and 'N'. The records will be retreived based on whichever value is 'Y'. For that I created a before report trigger like this.
IF :MANAGER='Y' AND :CLERK='N' THEN
:P_JOB_TYPE:='MANAGER';
ELSIF :MANAGER='N' AND :CLERK='Y' THEN
:P_JOB_TYPE:='CLERK';
ELSIF :MANAGER='Y' AND :CLERK='Y' THEN
:P_JOB_TYPE:='MANAGER OR CLERK';
ELSE -- where both the parameters are set to 'N'
SRW.MESSAGE(1,'YOU MUST SELECT ATLEAST ONE JOB TYPE');
END IF;
WHERE P_JOB_TYPE is a lexical parameter is passed to the query.
After the message prompt, its displaying all the records for manager and clerk whereas I want to reset the given parameters and prompt for the user to enter 'Y' for atleast one parameter. How can I implement this?
Any advice is appreciated.
Thanks.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
