APPS.WF_SETUP dependencies on DBMS_JOB

Line 701: -- List the content of DBMS_JOB for a local agent

697: end Create_Queue;
698:
699: --
700: -- List_Listener
701: -- List the content of DBMS_JOB for a local agent
702: --
703: procedure List_Listener(
704: aguid in raw
705: ) is

Line 1352: -- Put in the change to the DBMS_JOB for Wf_Event.Listen().

1348:
1349:
1350: --
1351: -- SubmitListener
1352: -- Put in the change to the DBMS_JOB for Wf_Event.Listen().
1353: --
1354: procedure SubmitListener(
1355: h_job in varchar2,
1356: h_name in varchar2,

Line 1424: DBMS_JOB.Submit(

1420: into l_name
1421: from wf_agents
1422: where name = upper(h_name);
1423:
1424: DBMS_JOB.Submit(
1425: job=>l_job,
1426: what=>'Wf_Event.Listen('''||h_name||''');',
1427: next_date=>nvl(l_rundate, sysdate),
1428: interval=>to_date(null)

Line 1435: DBMS_JOB.Next_Date(

1431: -- Invalid Agent so raising error.
1432: wf_core.raise('WFE_AGENT_NOTEXIST');
1433: end;
1434: else
1435: DBMS_JOB.Next_Date(
1436: job=>l_job,
1437: next_date=>nvl(l_rundate, sysdate)
1438: );
1439: end if;

Line 1449: DBMS_JOB.Interval(

1445: wf_core.raise('WFE_LATER_INTERVAL');
1446: end if;
1447: end if;
1448:
1449: DBMS_JOB.Interval(
1450: job=>l_job,
1451: interval=>'Wf_Setup.JobNextRunDate('||to_char(l_job)||','||
1452: to_char(l_day)||','||
1453: to_char(l_hour)||','||

Line 1460: DBMS_JOB.Run(

1456: );
1457:
1458: -- force it to run the first time
1459: if (l_rundate is null) then
1460: DBMS_JOB.Run(
1461: job=>l_job
1462: );
1463: end if;
1464:

Line 1591: DBMS_JOB.Remove(h_job);

1587: else
1588: wf_core.raise('WF_NOTADMIN');
1589: end if;
1590:
1591: DBMS_JOB.Remove(h_job);
1592:
1593: -- go back to the specified URL
1594: Wfe_Html_Util.gotoURL(h_url);
1595: exception

Line 1637: -- Return the next run date for DBMS_JOB

1633: end DeletePropagation;
1634:
1635: --
1636: -- JobNextRunDate (Private)
1637: -- Return the next run date for DBMS_JOB
1638: --
1639: function JobNextRunDate(
1640: jobnum in pls_integer,
1641: mday in number ,