Report Parameters Validations

Defaulting the previous parameter Value

Validating the Date which should not be more than 90 days than the from date

SPECIAL VSET:

FND PLSQL "DECLARE
l_frm_dte DATE:=to_date(':$FLEX$.P_FROM_INV_DATE','YYYY/MM/DD HH24:MI:SS');
l_to_dte DATE:= :!VALUE;
BEGIN
IF l_to_dte > l_frm_dte + 90 THEN
FND_MESSAGE.SET_NAME('FND','FND_GENERIC_MESSAGE');
FND_MESSAGE.SET_TOKEN('MESSAGE','Please enter date range less than 90 days.');
FND_MESSAGE.RAISE_ERROR;
END IF;
END;"

Getting values of Parameter based on Other Parameter

:$FLEX$.VALSET_NAME

Showing All Values in Parameter if depending Parameter is given as null

ORG_ID = NVL(:$FLEX$.VALSET_NAME:NULL,ORG_ID)