Create a Parameter Relation Collection

Program instance contained in the Workflow and an input Parameter of another Program instance that is executed later in the Workflow.

Name

CDR_PUB_DF_PARAM_RELATION.CreateParrelColl

Signature

PROCEDURE CREATEPARRELCOLL( 
  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, 
  PIO_PARCOLL  IN OUT    CDR_PARAM_RELATION_COLL, 
  PI_VALIDATERELATIONS  IN    VARCHAR := 'T' 
); 

Parameters

This API has standard parameters (see Standard Parameters) and the following parameters:

• PIO_PARCOLL (Mandatory) This is a collection of CDR_PARAM_RELATION_OBJ_TYPEs.

  For each Parameter relation that you want to create, initialize a CDR_PARAM_RELATION_OBJ_TYPE and then extend the collection. For the SRC attributes enter information about the Parameter whose value will be passed to another Parameter. For the TGT attributes, enter information about the target Parameter that will receive its value from the source Parameter. For RELATION_TYPE enter either LINK or SHARE.

• PI_VALIDATERELATIONS (Mandatory) Accept the default value of 'T' to validate the parameter relations in the collection. Enter 'F' to skip validation.