Wait for a Job to Complete

Use this API to enable synchronous execution so that program control waits for a Job to complete before proceeding with the rest of the logic.

Name

CDR_PUB_EXE_EXTERNAL.WaitForFinalStatus

Signature

PROCEDURE WAITFORFINALSTATUS( 
  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_NJOBID  IN    NUMBER, 
  PI_NTIMEOUT  IN    NUMBER, 
  PI_NSERVICEINSTANCEID  IN    NUMBER 
); 

Parameters

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

• PI_NJOBID (Mandatory) Enter the Job ID of the Job in process. The Job_ID is returned by the API CDR_PUB_EXE_SUBMISSION.CREATE SUBMISSION and in the UI.
• PI_NTIMEOUT (Mandatory) Enter in seconds, the job completion period before the API times out.
• PI_NSERVICEINSTANCEID (Mandatory) Enter the service instance that is processing the job. Get the ID from the cdr_jobs_v view using the Job_Id.