Get Parameter Instances for Value Passing
Use this API to get a list of Parameters that would be valid for either receiving a value from, or passing a value to, the Parameter you specify in the Report Set or Workflow you specify.
Name
CDR_PUB_DF_PARAM_RELATION.GetParameterRefs
Signature
PROCEDURE GETPARAMETERREFS( 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, X_RETURN_STATUS OUT VARCHAR2, X_MSG_COUNT OUT NUMBER, X_MSG_DATA OUT VARCHAR2, PI_PSNSCOMPANYID IN CDR_NAMINGS.COMPANY_ID%TYPE, PI_PSNSOBJID IN CDR_NAMINGS.OBJ_ID%TYPE, PI_PSNSOBJVER IN CDR_NAMING_VERSIONS.OBJ_VER%TYPE, PI_PAROBJID IN CDR_NAMINGS.OBJ_ID%TYPE, PI_PAROBJVER IN CDR_NAMING_VERSIONS.OBJ_VER%TYPE, PO_PARCOLL OUT CDR_PARAM_RELATION_COLL, PI_SHARE IN VARCHAR2 );
Parameters
This API has standard parameters (see Standard Parameters) and the following parameters:
- PI_PSNSCOMPANYID (Mandatory) Enter the company ID of the Report Set or Workflow.
- PI_PSNSOBJID (Mandatory) Enter the object ID of the Report Set or Workflow.
- PI_PSNSOBJVER (Mandatory) Enter the version number of the Report Set or Workflow.
- PI_PAROBJID (Mandatory) Enter the object ID of the Parameter.
- PI_PAROBJVER (Mandatory) Enter the version number of the Parameter.
- PO_PARCOLL This output parameter is a collection of CDR_PARAM_RELATION_OBJ_TYPEs containing Parameter instances in the Report Set or Workflow.
- PI_SHARE Enter SHAREDFROM to get a list of potential source Parameters that could pass their value to the Parameter you specified. Enter SHAREDTO to get a list of potential target Parameters that could receive their value from the Parameter you specified.
Parent topic: Define Parameter Relations