Get Additional Job Information (Overloaded)

Use this API to retrieve information about a Job, including whether it is a Master job or a Top Level job, by passing its JOB_ID.

Name

CDR_PUB_EXE_RUNTIME.GetJobInfo

Signature

PROCEDURE GETJOBINFO( 
  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    CDR_JOBS.JOB_ID%TYPE, 
  PO_RSUBMISSION  OUT    CDR_SUBMISSIONS%ROWTYPE, 
  PO_RJOB  OUT    CDR_JOBS%ROWTYPE, 
  PO_BISTOPLEVELJOB  OUT    BOOLEAN, 
  PO_BISMASTERJOB  OUT    BOOLEAN 
); 

Parameters

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

• PI_NJOBID (Mandatory) Enter the JOB ID.
• PO_RSUBMISSION This is an output parameter. The API returns the row corresponding to the SUBMISSION_ID (associated with the JOB_ID value in CDR_JOBS) from the CDR_SUBMISSIONS table.
• PO_RJOB This is an output parameter. The API returns the row corresponding to the JOB_ID from the CDR_JOBS table.
• PO_BISTOPLEVELJOB This is an output parameter. The API returns "T" if the Job is a Top Level Job.
• PO_BISMASTERJOB This is an output parameter. The API returns "T" if the job is a Master job.