Get Displayed Parameter Values
Use this API to get the Parameter value(s) that must be displayed in the submission Execution Setup in cases where the displayed value differs from the value used internally: for a Parameter with a classification list of values, this API returns a comma-separated list of the terms in the appropriate classification level (instead of the term_id used internally); for a Report Set Entry Title Parameter, the API returns the title (instead of the RSE obj_id); and for a Parameter with a look-up value, the API returns a display value; for example, 'Yes' instead of $YESNO$YES. You can also use this API to populate a default value for a Parameter in an Execution Setup.
Name
CDR_PUB_DF_PARAMETER.GetDefaultCLAVvalue
Signature
FUNCTION GETDEFAULTCLAVALUE( P_API_VERSION IN NUMBER, P_INIT_MSG_LIST IN VARCHAR2 := CDR_PUB_DEF_CONSTANTS.G_FALSE, P_COMMIT IN VARCHAR2 := CDR_PUB_DEF_CONSTANTS.G_FALSE, P_VALIDATION_LEVEL IN NUMBER := CDR_PUB_DEF_CONSTANTS.G_VALID_LEVEL_FULL, PALLOWEDVALUE IN CDR_PARAMETERS.ALLOWED_VALUES_RC%TYPE, PDEFAULTVALUE IN VARCHAR2 ) RETURN VARCHAR2;
Parameters
This API has standard parameters (see Standard Parameters) and the following parameters:
- P_COMMIT (Optional) Accept the default value (FND_API.G_FALSE) to ensure that this individual API does not commit upon completion. Pass FND_API.G_TRUE to override the default behavior.
- P_VALIDATION_LEVEL (Optional) Accept the default value to perform full validation. No other values are currently supported.
- PALLOWEDVALUE (Optional) To get the allowed values for a Parameter with a classification LOV, enter $PARAMALLOWVALS$CLALOV. To get the title for a Report Set Entry, enter $PARAMALLOWVALS$ENTRYLOV. To get a look-up value or enter a default value, do not enter a value here.
- PDEFAULTVALUE (Optional) To get the allowed values for a Parameter with a classification LOV, enter the level ID of the Parameter's LOV. To get a look-up value, enter $PARAMALLOWVALS$LOV. To get the title for a Report Set Entry, enter the RSE object ID. To set a default value for a Parameter in the Execution Setup, enter the string you want to serve as the default value. The API returns the string.
Parent topic: Define and Modify Parameters