DBA Data[Home] [Help]

APPS.WF_SETUP dependencies on DBMS_AQADM

Line 663: dbms_aqadm.create_queue_table

659: wf_core.raise('WFE_SYSTEM_NOTLOCAL');
660: end if;
661:
662: -- create queue table
663: dbms_aqadm.create_queue_table
664: (
665: queue_table => qtable,
666: queue_payload_type => wf_core.translate('WF_SCHEMA')||'.WF_EVENT_T',
667: sort_list => 'ENQ_TIME',

Line 674: dbms_aqadm.create_queue

670: multiple_consumers => TRUE
671: );
672:
673: -- create queue
674: dbms_aqadm.create_queue
675: (
676: queue_name => qname,
677: queue_table => qtable
678: );

Line 681: dbms_aqadm.start_queue

677: queue_table => qtable
678: );
679:
680: -- start queue
681: dbms_aqadm.start_queue
682: (
683: queue_name => qname
684: );
685:

Line 1481: -- Put in the change to the DBMS_AQADM.Schedule_Propagation.

1477:
1478:
1479: --
1480: -- SubmitPropagation
1481: -- Put in the change to the DBMS_AQADM.Schedule_Propagation.
1482: --
1483: procedure SubmitPropagation(
1484: h_qname in varchar2,
1485: h_system in varchar2,

Line 1547: DBMS_AQADM.Schedule_Propagation(

1543: end if;
1544: end if;
1545:
1546: -- schedule propagation
1547: DBMS_AQADM.Schedule_Propagation(
1548: queue_name=>h_qname,
1549: destination=>h_system,
1550: duration=>l_duration,
1551: next_time=>l_nextrun,

Line 1625: dbms_aqadm.UnSchedule_Propagation(

1621: else
1622: wf_core.raise('WF_NOTADMIN');
1623: end if;
1624:
1625: dbms_aqadm.UnSchedule_Propagation(
1626: queue_name=>h_qname,
1627: destination=>h_system
1628: );
1629: exception

Line 1701: DBMS_AQADM.Schedule_Propagation(

1697: -- In case an existing propagation schedule exists
1698: Wf_Setup.DeletePropagation(h_qname, h_system);
1699:
1700: -- schedule propagation
1701: DBMS_AQADM.Schedule_Propagation(
1702: queue_name=>h_qname,
1703: destination=>h_system,
1704: duration=>l_duration,
1705: latency=>l_latency