Submit a Validation Check Batch

Use this API to submit a validation check batch.

Name

DME_PUB_VALIDATION_CHECK.submitValidationCheckBatch

Signature

FUNCTION SUBMITVALIDATIONCHECKBATCH
(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_VCBATCHMODELCOMPANYID IN CDR_NAMINGS.COMPANY_ID%TYPE
PI_VCBATCHMODELOBJID IN CDR_NAMINGS.OBJ_ID%TYPE,
PI_VCBATCHMODELOBJVER IN CDR_NAMING_VERSIONS.OBJ_VER%TYPE,
PI_SUBMISSION_TYPE IN VARCHAR2 DEFAULT '$SUBMISSTYPES$IMMEDIATE',
PI_CONTEXT IN VARCHAR2 DEFAULT '$LIFECYCLE$DEV',
PI_SCHED_START_TS IN DATE DEFAULT NULL,
PI_SCHED_END_TS  IN DATE DEFAULT NULL,
PI_SCHED_REPEAT_INTERVAL IN VARCHAR2 DEFAULT NULL,
PI_SCHED_REPEAT_LIST IN VARCHAR2 DEFAULT NULL,
PI_FORCE_EXECUTION_FLAG_RC IN VARCHAR2 DEFAULT '$YESNO$NO',
PI_RUN_MODE_RC IN VARCHAR2,
PI_EXECUTE_DISABLEDVC IN VARCHAR2 DEFAULT '$YESNO$NO'
) RETURN CDR_JOBS.JOB_ID%TYPE;

Parameters

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

  • PI_VCBATCHMODELCOMPANYID (Mandatory). Company ID of Validation Checks Batch Model.
  • PI_VCBATCHMODELOBJID (Mandatory). OBJ_ID of Validation Checks Batch Model.
  • PI_VCBATCHMODELOBJVER (Mandatory). OBJ_VER of Validation Checks Batch Model.
  • PI_RUN_MODE_RC (Mandatory). Enter '$RUNMODES$FULL' or '$RUNMODES$INCREMENT'.
  • PI_SUBMISSION_TYPE. Enter '$SUBMISSTYPES$IMMEDIATE 'or '$SUBMISSTYPES$SCHEDULED' or '$SUBMISSTYPES$DEFERRED'.
  • PI_CONTEXT. Lifecycle context values like $LIFECYCLE$DEV, $LIFECYCLE$QC or $LIFECYCLE$PROD.
  • PI_SCHED_START_TS. Enter start time if submission is scheduled/deferred.
  • PI_SCHED_END_TS. Enter end time if submission is scheduled.
  • PI_SCHED_REPEAT_INTERVAL. Enter interval time if submission is scheduled.
  • PI_SCHED_REPEAT_LIST. Enter if submission is scheduled. Accepted values are $SUBMISSTYPES$HOURLY, $SUBMISSTYPES$DAILY, $SUBMISSTYPES$WEEKLY, $SUBMISSTYPES$MONTHLY.
  • PI_FORCE_EXECUTION_FLAG_RC. Enter '$YESNO$NO ' or '$YESNO$YES'.
  • PI_EXECUTE_DISABLEDVC. Enter '$YESNO$YES' to execute disabled VCs to close discrepancies. The default value is '$YESNO$NO'.

This API returns the Job Id.