APPS.WF_QUEUE dependencies on WF_QUEUES

Line 1636: from wf_queues wfq

1632: select wfq.protocol,
1633: wfq.inbound_outbound,
1634: wfq.description,
1635: wfq.queue_count
1636: from wf_queues wfq
1637: where NVL(wfq.disable_flag, 'N') = 'N'
1638: order by wfq.protocol, wfq.inbound_outbound;
1639:
1640: rowcount number;

Line 1849: FROM wf_queues

1845: END IF;
1846:
1847: SELECT queue_count
1848: INTO l_count
1849: FROM wf_queues
1850: WHERE UPPER(p_protocol) = protocol
1851: AND p_inbound_outbound = inbound_outbound;
1852:
1853: -- Column headers

Line 2196: FROM wf_queues

2192: SELECT description,
2193: queue_count
2194: INTO l_description,
2195: l_queue_count
2196: FROM wf_queues
2197: WHERE protocol = p_protocol
2198: AND inbound_outbound = p_inbound_outbound;
2199:
2200: END IF;

Line 2507: FROM wf_queues

2503: IF (p_original_protocol IS NULL) THEN
2504:
2505: SELECT count(1)
2506: INTO l_count
2507: FROM wf_queues
2508: WHERE UPPER(p_protocol) = protocol
2509: AND p_inbound_outbound = inbound_outbound;
2510:
2511: if (l_count > 0) then

Line 2596: from wf_queues wfq

2592: ** Check to see if the queue name already exists
2593: */
2594: select count(1)
2595: into l_count
2596: from wf_queues wfq
2597: where wfq.protocol = p_protocol
2598: and wfq.inbound_outbound = p_inbound_outbound;
2599:
2600: /*

Line 2646: ** Create an entry in WF_QUEUES table

2642:
2643: end loop;
2644:
2645: /*
2646: ** Create an entry in WF_QUEUES table
2647: */
2648: insert into wf_queues
2649: (protocol,
2650: inbound_outbound,

Line 2648: insert into wf_queues

2644:
2645: /*
2646: ** Create an entry in WF_QUEUES table
2647: */
2648: insert into wf_queues
2649: (protocol,
2650: inbound_outbound,
2651: description,
2652: queue_count,

Line 2688: from wf_queues wfq

2684: begin
2685:
2686: select queue_count
2687: into l_queue_count
2688: from wf_queues wfq
2689: where wfq.protocol = p_protocol
2690: and wfq.inbound_outbound = p_inbound_outbound;
2691:
2692: exception

Line 2714: ** delete an entry in WF_QUEUES table

2710: wf_queue.generic_queue_delete_queues(p_protocol, p_inbound_outbound,
2711: 1, l_queue_count);
2712:
2713: /*
2714: ** delete an entry in WF_QUEUES table
2715: */
2716: delete from wf_queues
2717: where protocol = p_protocol
2718: and inbound_outbound = p_inbound_outbound;

Line 2716: delete from wf_queues

2712:
2713: /*
2714: ** delete an entry in WF_QUEUES table
2715: */
2716: delete from wf_queues
2717: where protocol = p_protocol
2718: and inbound_outbound = p_inbound_outbound;
2719:
2720: exception

Line 2746: from wf_queues

2742: l_queue_name varchar2(30) := null;
2743:
2744: cursor get_queues is
2745: select protocol, inbound_outbound, queue_count
2746: from wf_queues
2747: order by protocol, inbound_outbound;
2748:
2749: begin
2750:

Line 2758: for wf_queues_list in get_queues loop

2754: */
2755: if (wf_queue.queue_names_index.count < 1) then
2756:
2757: -- Show all nodes
2758: for wf_queues_list in get_queues loop
2759:
2760: wf_queue.queue_names_index(ii).protocol := wf_queues_list.protocol;
2761: wf_queue.queue_names_index(ii).inbound_outbound := wf_queues_list.inbound_outbound;
2762: wf_queue.queue_names_index(ii).queue_count := wf_queues_list.queue_count;

Line 2760: wf_queue.queue_names_index(ii).protocol := wf_queues_list.protocol;

2756:
2757: -- Show all nodes
2758: for wf_queues_list in get_queues loop
2759:
2760: wf_queue.queue_names_index(ii).protocol := wf_queues_list.protocol;
2761: wf_queue.queue_names_index(ii).inbound_outbound := wf_queues_list.inbound_outbound;
2762: wf_queue.queue_names_index(ii).queue_count := wf_queues_list.queue_count;
2763:
2764: ii := ii + 1;

Line 2761: wf_queue.queue_names_index(ii).inbound_outbound := wf_queues_list.inbound_outbound;

2757: -- Show all nodes
2758: for wf_queues_list in get_queues loop
2759:
2760: wf_queue.queue_names_index(ii).protocol := wf_queues_list.protocol;
2761: wf_queue.queue_names_index(ii).inbound_outbound := wf_queues_list.inbound_outbound;
2762: wf_queue.queue_names_index(ii).queue_count := wf_queues_list.queue_count;
2763:
2764: ii := ii + 1;
2765:

Line 2762: wf_queue.queue_names_index(ii).queue_count := wf_queues_list.queue_count;

2758: for wf_queues_list in get_queues loop
2759:
2760: wf_queue.queue_names_index(ii).protocol := wf_queues_list.protocol;
2761: wf_queue.queue_names_index(ii).inbound_outbound := wf_queues_list.inbound_outbound;
2762: wf_queue.queue_names_index(ii).queue_count := wf_queues_list.queue_count;
2763:
2764: ii := ii + 1;
2765:
2766: end loop;