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.