Submit an Execution Setup for Instances

Use this API to submit an Execution Setup for Report Set instances and Workflow instances. You must call the loadESTempTable API before calling this API.

Name

CDR_PUB_DF_EXECUTIONSETUP.SubmitExecutionSetup

Signature

PROCEDURE SUBMITEXECUTIONSETUP( 
  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, 
  PI_EXECUTIONSETUP  IN OUT    CDR_BASE_OBJ_TYPE, 
  PIO_CHANGEDSYSTEMPARAMETERCOLL  IN OUT    CDR_SUBMISSION_DETAILS_COLL, 
  PI_TICOLL  IN    CDR_SNAPSHOT_TABLE_COLL, 
  PO_CURRENTJOBID  OUT    VARCHAR2, 
  PI_OUTPUTTITLE  IN    VARCHAR2, 
  PI_OUTPUTDESC  IN    VARCHAR2 
); 

Parameters

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

• PI_EXECUTIONSETUP (Mandatory) This is a parameter of cdr_base_obj_type.

  Enter values for attributes that describe the Execution Setup: COMPANY_ID, OBJ_ID, OBJ_VER, NAMESPACE_OBJ_ID, NAMESPACE_OBJ_VER,OBJECT_VERSION_NUMBER.

• PIO_CHANGEDSYSTEMPARAMETERCOLL (Mandatory) This is a parameter of cdr_submission_details_coll type.

  You must provide values for the following system parameters: company_id (use CDR_DF_PUB_DEF_CONSTANTS.CURRENT_COMPANY_ID); submission_id (enter null); prref_id (enter -1), prref_ver (enter -1), parameter_ref_obj_id, and parameter_ref_obj_id. Query cdr_parameters on company_id, obj_id, and obj_ver to find values for the default_value attribute. Use this value to set the attribute parameter_value.

• PI_TICOLL (Mandatory) This is a collection of data snapshots. This value may be null if you want to use current data.

  Otherwise the required attributes are: TI_OBJ_ID,TI_OBJ_VER,SRC_MASTER_JOB_ID,SRC_COMPANY_ID

• PO_CURRENTJOBID (Mandatory) This is an output parameter. The system generates a Job ID for the submitted Execution Setup. You can print this parameter through your program.
• PI_OUTPUTTITLE (Mandatory) Enter a title for the Execution Setup. It is easy to track an Execution Setup with a meaningful title.
• PI_OUTPUTDESC (Mandatory) Enter a description for the Execution Setup output.