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.