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.
Parent topic: Retrieve Information about Ongoing Jobs