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.