APPS.WF_QUEUE dependencies on ALL_QUEUES

Line 893: -- Enqueues a message onto any WF queue (because all queues have same payload)

889: --
890: -- ====================================================================
891: --
892: -- Enqueue_Event (PRIVATE)
893: -- Enqueues a message onto any WF queue (because all queues have same payload)
894: --
895:
896: procedure Enqueue_Event(queuename in varchar2,
897: itemtype in varchar2,

Line 1907: -- Show all queues for the given protocol

1903: htp.tableRowClose;
1904: htp.tableRowOpen;
1905: htp.tableRowClose;
1906:
1907: -- Show all queues for the given protocol
1908: for ii in 1..l_count loop
1909:
1910: htp.tableRowOpen(null, 'TOP');
1911:

Line 2855: from all_queues

2851: end if;
2852: begin
2853: select queue_table, dequeue_enabled
2854: into l_queue_table, l_dequeue_enabled
2855: from all_queues
2856: where owner = l_schema_name
2857: and name = l_queue_name;
2858: l_exception_queue := l_schema_name||'.'||'AQ$_'||
2859: l_queue_table||'_E';

Line 2914: FROM all_queues

2910: queue_name varchar2(80);
2911: l_qname varchar2(80);
2912: CURSOR q_disabled (schema varchar2, queue_name varchar2) is
2913: SELECT name
2914: FROM all_queues
2915: WHERE name = queue_name
2916: AND owner = schema
2917: AND ((trim(enqueue_enabled) = 'NO') OR (trim(dequeue_enabled) = 'NO'));
2918:

Line 2996: from all_queues

2992:
2993: -- Changed non-cursor single row query to cursor based for improved perf.
2994: cursor c_qtable is
2995: select queue_table
2996: from all_queues
2997: where owner = l_schema
2998: and name = l_qname;
2999: --and queue_type = 'NORMAL_QUEUE';
3000:

Line 3167: FROM all_queues

3163: FROM all_queue_tables
3164: WHERE queue_table in
3165: (
3166: SELECT queue_table
3167: FROM all_queues
3168: WHERE name = l_qname
3169: AND owner = l_schema
3170: )
3171: AND owner=l_schema;

Line 3327: FROM all_queues

3323: FROM all_queue_tables
3324: WHERE queue_table in
3325: (
3326: SELECT queue_table
3327: FROM all_queues
3328: WHERE name = l_qname
3329: AND owner = l_schema
3330: )
3331: AND owner=l_schema;

Line 3515: FROM all_queues

3511: FROM all_queue_tables
3512: WHERE queue_table in
3513: (
3514: SELECT queue_table
3515: FROM all_queues
3516: WHERE name = l_qname
3517: AND owner = l_schema
3518: )
3519: AND owner=l_schema;