Load Parameter Details
Use this API to insert all parameters into a CDR_ES_TEMP table before submitting Report Set instance and Work Flow instance jobs.
Name
CDR_PUB_DF_EXECUTIONSETUP.LoadESTempTable
Signature
PROCEDURE LOADESTEMPTABLE( 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_BASEOBJ IN CDR_BASE_OBJ_TYPE, PI_NODEPRREFID IN NUMBER := NULL, PI_NODEPRREFVER IN NUMBER := NULL, PI_JOBID IN NUMBER := NULL );
Parameters
This API has standard parameters (see Standard Parameters) and the following parameters:
- PI_BASEOBJ (Mandatory) This is a parameter of cdr_base_obj type for the Execution Setup. Enter the necessary attributes.
- PI_NODEPRREFID (Mandatory) If you are submitting a single RSE, enter the prref_id of that RSE, else enter NULL.
- PI_NODEPRREFVER (Mandatory) If you are submitting a single RSE, enter the prref_ver of that RSE, else enter NULL.
- PI_JOBID (Mandatory) If you are re-submitting an existing job, enter the previous job_id, else enter NULL.
Parent topic: Create and Modify Execution Setups