Remove Parameter Relations

Use this API to delete one or more Parameter relations from a Report Set or Workflow.

Name

CDR_PUB_DF_PARAM_RELATION.RemoveParrelColl

Signature

PROCEDURE REMOVEPARRELCOLL(   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 ); 

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 delete, initialize a CDR_PARAM_RELATION_OBJ_TYPE and then extend the collection.

The following attributes are required: COMPANY_ID, SRC_PARENT_OBJ_ID, SRC_PARENT_OBJ_VER, SRC_PAR_REF_OBJ_ID, SRC_PAR_REF_OBJ_VER, TGT_PARENT_OBJ_ID, TGT_PARENT_OBJ_VER, TGT_PAR_REF_OBJ_ID, TGT_PAR_REF_OBJ_VER.