APPS.WF_EVENT_HTML dependencies on ALL_QUEUES

Line 6148: all_queues aq

6144: wfa.queue_name SCHEMA_QUEUE_NAME,
6145: aq.queue_table QUEUE_TABLE,
6146: upper(wfa.queue_handler) QUEUE_HANDLER
6147: from wf_agents wfa ,
6148: all_queues aq
6149: where wfa.system_guid = hextoraw(wf_core.translate('WF_SYSTEM_GUID'))
6150: --and upper(wfa.queue_handler) = 'WF_EVENT_QH'
6151: and aq.name = substr(wfa.queue_name,instr(wfa.queue_name,'.',1)+1)
6152: and aq.owner = substr(wfa.queue_name,1,instr(wfa.queue_name,'.',1)-1)

Line 6383: all_queues aq

6379: cursor queues_cursor is
6380: select
6381: substr(wfa.queue_name,instr(wfa.queue_name,'.',1)+1) QUEUE_NAME
6382: from wf_agents wfa ,
6383: all_queues aq
6384: where wfa.system_guid = hextoraw(wf_core.translate('WF_SYSTEM_GUID'))
6385: and aq.name = substr(wfa.queue_name,instr(wfa.queue_name,'.',1)+1)
6386: and aq.name like nvl(p_queue_name,'%')
6387: and aq.owner = substr(wfa.queue_name,1,instr(wfa.queue_name,'.',1)-1)

Line 6549: all_queues aq

6545: cursor queues_cursor is
6546: select
6547: substr(wfa.queue_name,instr(wfa.queue_name,'.',1)+1) QUEUE_NAME
6548: from wf_agents wfa ,
6549: all_queues aq
6550: where wfa.system_guid = hextoraw(wf_core.translate('WF_SYSTEM_GUID'))
6551: and aq.name = substr(wfa.queue_name,instr(wfa.queue_name,'.',1)+1)
6552: and aq.name like nvl(p_queue_name,'%')
6553: and aq.owner = substr(wfa.queue_name,1,instr(wfa.queue_name,'.',1)-1)

Line 6718: all_queues aq

6714: cursor queues_cursor is
6715: select
6716: substr(wfa.queue_name,instr(wfa.queue_name,'.',1)+1) QUEUE_NAME
6717: from wf_agents wfa ,
6718: all_queues aq
6719: where wfa.system_guid = hextoraw(wf_core.translate('WF_SYSTEM_GUID'))
6720: and aq.name = substr(wfa.queue_name,instr(wfa.queue_name,'.',1)+1)
6721: and aq.name like nvl(p_queue_name,'%')
6722: and aq.owner = substr(wfa.queue_name,1,instr(wfa.queue_name,'.',1)-1)

Line 7025: all_queues aq

7021: -- begin
7022: select aq.queue_table
7023: into l_qtable
7024: from wf_agents wfa ,
7025: all_queues aq
7026: where aq.name = p_queue_name
7027: and substr(wfa.queue_name,instr(wfa.queue_name,'.',1)+1) = aq.name
7028: and aq.owner = substr(wfa.queue_name,1,instr(wfa.queue_name,'.',1)-1);
7029: -- exception

Line 7031: --use the direct query on all_queues

7027: and substr(wfa.queue_name,instr(wfa.queue_name,'.',1)+1) = aq.name
7028: and aq.owner = substr(wfa.queue_name,1,instr(wfa.queue_name,'.',1)-1);
7029: -- exception
7030: -- when no_data_found then
7031: --use the direct query on all_queues
7032: --with rownum = 1 to take the first hit
7033: --SELECT queue_table INTO l_qtable
7034: --FROM all_queues
7035: --WHERE name = p_queue_name

Line 7034: --FROM all_queues

7030: -- when no_data_found then
7031: --use the direct query on all_queues
7032: --with rownum = 1 to take the first hit
7033: --SELECT queue_table INTO l_qtable
7034: --FROM all_queues
7035: --WHERE name = p_queue_name
7036: --AND rownum = 1;
7037: -- end;
7038: