Submit an Execution Setup

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    CDR_BASE_OBJ_TYPE, 
  PI_CHANGEDSYSTEMPARAMETERCOLL  IN    CDR_SUBMISSION_DETAILS_COLL, 
  PI_TICOLL  IN    CDR_SNAPSHOT_TABLE_COLL, 
  PI_INCLUDEDOBJCOLL  IN    CDR_SUBMISSION_DETAILS_COLL, 
  PI_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 table type CDR_BASE_OBJ_TYPE. Enter values to identify the Execution Setup that you want to submit.
The following attributes are required: COMPANY_ID,OBJ_ID,OBJ_VER,OBJECT_VERSION_NUMBER,NAMESPACE_OBJ_ID,NAMESPACE_OBJ_VER.
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 CDR_SNAPSHOT_TABLE_OBJ_TYPE.
PI_INCLUDEDOBJCOLL (Mandatory) This is a collection of CDR_SUBMISSION_DETAILS_OBJ_TYPE that contains PRREF_IDs of Programs to include in the Execution Setup. For Report Sets and Report Set Entries, the user can include only selected Report Sets for execution. Enter only those PRREF_IDs.
PI_CURRENTJOBID (Mandatory) Enter the JOB_ID of the Job that this Execution Setup submission created. This parameter is used to generate user's feedback.
PI_OUTPUTTITLE (Mandatory) Enter a title for the output from this Execution Setup.
PI_OUTPUTDESC (Mandatory) Enter the description for the output from this Execution Setup.