Create a Validation Check Batch

Use this API to create a validation check batch.

Name

DME_PUB_VALIDATION_CHECK.CreateValidationCheckBatch

Signature

PROCEDURE CREATEVALIDATIONCHECKBATCH,
( P_API_VERSION IN VARCHAR2,  P_INIT_MSG_LIST IN VARCHAR2 DEFAULT CDR_PUB_DEF_CONSTANTS.G_FALSE,  P_COMMIT IN VARCHAR2 default CDR_PUB_DEF_CONSTANTS.G_FALSE,  P_VALIDATION_LEVEL IN NUMBER default CDR_PUB_DEF_CONSTANTS.G_VALID_LEVEL_FULL,  X_RETURN_STATUS OUT NOCOPY VARCHAR2,  X_MSG_COUNT OUT NOCOPY NUMBER,  X_MSG_DATA OUT NOCOPY VARCHAR2,  PI_SOURCEMODELCOMPID IN OUT NOCOPY CDR_NAMINGS.COMPANY_ID%TYPE,  PI_SOURCEMODELOBJID IN OUT NOCOPY CDR_NAMINGS.OBJ_ID%TYPE,  PI_SOURCEMODELOBJVER IN OUT NOCOPY CDR_NAMING_VERSIONS.OBJ_VER%TYPE,  PI_BATCHNAME IN OUT NOCOPY CDR_NAMINGS.NAME%TYPE,  PI_BATCHDESCRIPTION IN CDR_NAMING_VERSIONS.DESCRIPTION%TYPE,  PI_ISORDEREDFOREXECUTION IN VARCHAR2,  PI_CANBETRIGGERED  IN VARCHAR DEFAULT '$YESNO$NO',
  );

Parameters

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

  • PI_SOURCEMODELCOMPID (Mandatory). Enter COMPANY_ID of Source Data Model.
  • PI_SOURCEMODELOBJID (Mandatory). Enter the obj_id of the table instance which contains the data record.
  • PI_SOURCEMODELOBJVER (Mandatory). Enter OBJ_VER of Source Data Model.
  • PI_BATCHNAME (Mandatory). Enter Batch Name for new VC Batch.
  • PI_BATCHDESCRIPTION (Optional). Enter Batch Description if you want for new VC Batch.
  • PI_ISORDEREDFOREXECUTION (Optional). Enter $YESNO$YES, if Validation Checks under new Batch must be executed in particular order. Otherwise enter $YESNO$NO. If entered as NULL, systems defaults it to $YESNO$NO.
  • PI_CANBETRIGGERED (Mandatory). Enter $YESNO$YES. This allows the successful completion of a transformation writing to the clinical data model that this batch runs against to trigger the execution of this batch. Entering a different value may result in unexpected behavior.