APPS.FND_JOBS_PKG dependencies on DBMS_JOB

Line 57: DBMS_JOB.REMOVE(JOB_NUMBER);

53: and J.JOB = R.JOB(+);
54: */
55: if (JOB_BROKEN = 'Y') then
56: -- If the job is broken, remove it (### and resubmit ###)
57: DBMS_JOB.REMOVE(JOB_NUMBER);
58: elsif (JOB_SID is null) then
59: return(null); -- Job is pending but not running
60: end if;
61: exception when NO_DATA_FOUND then

Line 65: DBMS_JOB.SUBMIT(JOB_NUMBER, JOB_STRING);

61: exception when NO_DATA_FOUND then
62: JOB_NUMBER := null;
63: end;
64: /* Job is either running or doesn't exist, so submit it */
65: DBMS_JOB.SUBMIT(JOB_NUMBER, JOB_STRING);
66: return(JOB_NUMBER);
67: exception when OTHERS then
68: return(0); -- Job submission failed for some reason
69: end SUBMIT_JOB;