Submit Clinical One Data load

Use this API to invoke a data load from Clinical One on demand.

Name

DME_PUB_DF_DATA_MODEL. StartC1DataLoad

Signature

PROCEDURE StartC1DataLoad(p_api_version       IN NUMBER
                              ,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_Study_id        IN CDR_NAMINGS.OBJ_ID%TYPE
                              ,pi_context         IN VARCHAR2
                              ,pi_run_mode        IN VARCHAR2 default '$RUNMODES$INCREMENTAL'
                              ,x_job_id           OUT NOCOPY  NUMBER);

Parameters

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

• PI_STUDY_ID (Mandatory). Enter STUDY_ID of Clinical One Data Model.
• PI_CONTEXT (Mandatory). Enter Lifecycle context values like $LIFECYCLE$DEV, $LIFECYCLE$QC or $LIFECYCLE$PROD.
• PI_RUN_MODE. Enter '$RUNMODES$FULL' or '$RUNMODES$INCREMENTAL'.
• X_JOB_ID. On calling this procedure, it submits a job. So this output parameter returns a job ID of successfully submitted job.

This API returns the Job ID.