Create
Dependent Value set for Date
Requirement:-
If User Pass 'Y' in GL_Date_Flag parameter then
GL_DATE_FROM and GL_DATE_TO enable to pass value
TRANSACTION_DATE_FROM and TRANSACTION_DATE_TO Disabled
If User Pass 'N' in GL_Date_Flag parameter then
GL_DATE_FROM and GL_DATE_TO Disabled to pass value
TRANSACTION_DATE_FROM and TRANSACTION_DATE_TO Enable
Solution:-
For
this Do below steps
1) parameter name :- GL Date Yes No Flag
value Set name :- XXDMN_GL_DATE_Y_N (independent value set)
Value :- N and Y
2) Parameter name :-Dummy Value1
value Set name :-XXDMN_DUMMY1(None Value Set)
Default type :- Sql Statement
default value :-SQL :- SELECT 1 FROM Dual WHERE :$FLEX$.XXDMN_GL_DATE_Y_N = 'N'
3) Parameter name :-Dummy Value2 :- XXDMN_DUMMY2 SQL:-
value Set name :-XXDMN_DUMMY1(None Value Set)
Default type :- Sql Statement
default value :-SQL :- SELECT 1 FROM Dual WHERE :$FLEX$.XXDMN_GL_DATE_Y_N = 'Y'
4) Parameter name :- Trx From Date
Value Set name :- XXDMN_TRX_DATE (Special Value Set with format type :- Standard Date upper case only)
In Edit information :- Event :- Validate
Function:-
FND PLSQL "BEGIN
IF ':$FLEX$.XXDMN_DUMMY1' <>'1' THEN
NULL;
END IF;
END;"
5) Parameter name :- TRX To Date
Value Set name :- :- XXDMN_TRX_DATE (Special Value Set with format type :- Standard Date upper case only)
In Edit information :- Event :- Validate
Function:-
FND PLSQL "BEGIN
IF ':$FLEX$.XXDMN_DUMMY1' <>'1' THEN
NULL;
END IF;
END;"
6) Parameter name :- Trx From Date
Value Set name :- :- XXDMN_GL_DATE (Special Value Set with format type :- Standard Date upper case only)
Value Set name :- XXDMN_GL_DATE (Special Value Set with format type :- Standard Date upper case only)
In Edit information :- Event :- Validate
Function:-
FND PLSQL "BEGIN
IF ':$FLEX$.XXDMN_DUMMY2' <>'1' THEN
NULL;
END IF;
END;"
7) Parameter name :- Trx From Date
Value Set name :- XXDMN_GL_DATE (Special Value Set with format type :- Standard Date upper case only)
In Edit information :- Event :- Validate
Function:-
FND PLSQL "BEGIN
IF ':$FLEX$.XXDMN_DUMMY2' <>'1' THEN
NULL;
END IF;
END;"
thank you :)