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.
Parent topic: Create and Modify Execution Setups