APPS.WF_QUEUE dependencies on WF_QUEUES

Line 1656: from wf_queues wfq

1652: select wfq.protocol,
1653: wfq.inbound_outbound,
1654: wfq.description,
1655: wfq.queue_count
1656: from wf_queues wfq
1657: where NVL(wfq.disable_flag, 'N') = 'N'
1658: order by wfq.protocol, wfq.inbound_outbound;
1659:
1660: rowcount number;

Line 1869: FROM wf_queues

1865: END IF;
1866:
1867: SELECT queue_count
1868: INTO l_count
1869: FROM wf_queues
1870: WHERE UPPER(p_protocol) = protocol
1871: AND p_inbound_outbound = inbound_outbound;
1872:
1873: -- Column headers

Line 2216: FROM wf_queues

2212: SELECT description,
2213: queue_count
2214: INTO l_description,
2215: l_queue_count
2216: FROM wf_queues
2217: WHERE protocol = p_protocol
2218: AND inbound_outbound = p_inbound_outbound;
2219:
2220: END IF;

Line 2527: FROM wf_queues

2523: IF (p_original_protocol IS NULL) THEN
2524:
2525: SELECT count(1)
2526: INTO l_count
2527: FROM wf_queues
2528: WHERE UPPER(p_protocol) = protocol
2529: AND p_inbound_outbound = inbound_outbound;
2530:
2531: if (l_count > 0) then

Line 2616: from wf_queues wfq

2612: ** Check to see if the queue name already exists
2613: */
2614: select count(1)
2615: into l_count
2616: from wf_queues wfq
2617: where wfq.protocol = p_protocol
2618: and wfq.inbound_outbound = p_inbound_outbound;
2619:
2620: /*

Line 2666: ** Create an entry in WF_QUEUES table

2662:
2663: end loop;
2664:
2665: /*
2666: ** Create an entry in WF_QUEUES table
2667: */
2668: insert into wf_queues
2669: (protocol,
2670: inbound_outbound,

Line 2668: insert into wf_queues

2664:
2665: /*
2666: ** Create an entry in WF_QUEUES table
2667: */
2668: insert into wf_queues
2669: (protocol,
2670: inbound_outbound,
2671: description,
2672: queue_count,

Line 2708: from wf_queues wfq

2704: begin
2705:
2706: select queue_count
2707: into l_queue_count
2708: from wf_queues wfq
2709: where wfq.protocol = p_protocol
2710: and wfq.inbound_outbound = p_inbound_outbound;
2711:
2712: exception

Line 2734: ** delete an entry in WF_QUEUES table

2730: wf_queue.generic_queue_delete_queues(p_protocol, p_inbound_outbound,
2731: 1, l_queue_count);
2732:
2733: /*
2734: ** delete an entry in WF_QUEUES table
2735: */
2736: delete from wf_queues
2737: where protocol = p_protocol
2738: and inbound_outbound = p_inbound_outbound;

Line 2736: delete from wf_queues

2732:
2733: /*
2734: ** delete an entry in WF_QUEUES table
2735: */
2736: delete from wf_queues
2737: where protocol = p_protocol
2738: and inbound_outbound = p_inbound_outbound;
2739:
2740: exception

Line 2766: from wf_queues

2762: l_queue_name varchar2(30) := null;
2763:
2764: cursor get_queues is
2765: select protocol, inbound_outbound, queue_count
2766: from wf_queues
2767: order by protocol, inbound_outbound;
2768:
2769: begin
2770:

Line 2778: for wf_queues_list in get_queues loop

2774: */
2775: if (wf_queue.queue_names_index.count < 1) then
2776:
2777: -- Show all nodes
2778: for wf_queues_list in get_queues loop
2779:
2780: wf_queue.queue_names_index(ii).protocol := wf_queues_list.protocol;
2781: wf_queue.queue_names_index(ii).inbound_outbound := wf_queues_list.inbound_outbound;
2782: wf_queue.queue_names_index(ii).queue_count := wf_queues_list.queue_count;

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

2776:
2777: -- Show all nodes
2778: for wf_queues_list in get_queues loop
2779:
2780: wf_queue.queue_names_index(ii).protocol := wf_queues_list.protocol;
2781: wf_queue.queue_names_index(ii).inbound_outbound := wf_queues_list.inbound_outbound;
2782: wf_queue.queue_names_index(ii).queue_count := wf_queues_list.queue_count;
2783:
2784: ii := ii + 1;

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

2777: -- Show all nodes
2778: for wf_queues_list in get_queues loop
2779:
2780: wf_queue.queue_names_index(ii).protocol := wf_queues_list.protocol;
2781: wf_queue.queue_names_index(ii).inbound_outbound := wf_queues_list.inbound_outbound;
2782: wf_queue.queue_names_index(ii).queue_count := wf_queues_list.queue_count;
2783:
2784: ii := ii + 1;
2785:

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

2778: for wf_queues_list in get_queues loop
2779:
2780: wf_queue.queue_names_index(ii).protocol := wf_queues_list.protocol;
2781: wf_queue.queue_names_index(ii).inbound_outbound := wf_queues_list.inbound_outbound;
2782: wf_queue.queue_names_index(ii).queue_count := wf_queues_list.queue_count;
2783:
2784: ii := ii + 1;
2785:
2786: end loop;