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.