Create a Submission
This API creates a Submission from the initial Job.
Name
CDR_PUB_EXE_SUBMISSION.CreateSubmission
Signature
PROCEDURE CREATESUBMISSION( 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_OSUBMISSION IN OUT CDR_SUBMISSION_OBJ_TYPE, PIO_COPROGRAMSUBDETAILS IN OUT CDR_SUBMISSION_DETAILS_COLL, PIO_COSYSTEMSUBDETAILS IN OUT CDR_SUBMISSION_DETAILS_COLL, PI_NOAACCOUNTID IN CDR_SUBMISSIONS.OA_ACCOUNT_ID%TYPE := NULL, PI_COSNAPSHOT IN CDR_SNAPSHOT_TABLE_COLL := CDR_SNAPSHOT_TABLE_COLL() );
Parameters
This API has standard parameters (see Standard Parameters) and the following parameters:
- PIO_OSUBMISSION Object containing Submission attributes like submission_type_rc, execution_setup_id, master_prref_id etc.
- PIO_COPROGRAMSUBDETAILS This is part of submission details which is a collection of runtime parameters.
- PIO_COSYSTEMSUBDETAILS This is part of submission details which is a collection of system parameters.
- PI_NOAACCOUNTID Enter the OA account ID of the user making the submission.
- PI_COSNAPSHOT This is a collection of snapshots attributes like Tables Obj_id, Obj_Ver, source_master_job_Id etc.
Parent topic: Create Submission Records