APPS.WF_QUEUE dependencies on WF_AGENTS

Line 2962: from wf_agents

2958:
2959: -- Changed upper(name) to name as queue_name should be recorded in upper case.
2960: cursor c_localagents(p_agent varchar2) is
2961: select queue_name
2962: from wf_agents
2963: where system_guid = hextoraw(wf_core.translate('WF_SYSTEM_GUID'))
2964: and name like upper(p_agent);
2965:
2966: /*

Line 3126: FROM wf_agents

3122:
3123: begin
3124: SELECT TRIM(queue_name), TRIM(queue_handler)
3125: INTO l_queue_name, l_queue_handler
3126: FROM wf_agents
3127: WHERE name = upper(p_agent_name)
3128: AND SYSTEM_GUID = wf_event.local_system_guid;
3129: exception
3130: when no_data_found then

Line 3293: FROM wf_agents

3289: l_xcount := 0;
3290:
3291: SELECT queue_name
3292: INTO l_queue_name
3293: FROM wf_agents
3294: WHERE name = upper(p_agent_name)
3295: AND SYSTEM_GUID = wf_event.local_system_guid;
3296:
3297: l_pos := instr(l_queue_name, '.', 1, 1);

Line 3327: -- Seeded WF agents

3323: --Set the Correlation ID for dequeue only if available
3324: --If the given agent is a Workflow Agent then append the
3325: --Account Name before the Correlation ID
3326: if ((p_correlation is not null) or (p_correlation <> '')) then
3327: -- Seeded WF agents
3328: if (upper(p_agent_name) like 'WF_%') then
3329: if (wf_event.account_name is null) then
3330: wf_event.SetAccountName;
3331: end if;

Line 3481: FROM wf_agents

3477: l_xcount := 0;
3478:
3479: SELECT queue_name
3480: INTO l_queue_name
3481: FROM wf_agents
3482: WHERE name = upper(p_agent_name)
3483: AND SYSTEM_GUID = wf_event.local_system_guid;
3484:
3485: l_pos := instr(l_queue_name, '.', 1, 1);

Line 3521: -- Seeded WF agents

3517: -- All the message ids older than the specified age are queried
3518: -- and the dequeue is done on the retrieved message ids
3519: --
3520: if ((p_correlation is not null) or (p_correlation <> '')) then
3521: -- Seeded WF agents
3522: if (upper(p_agent_name) like 'WF_%') then
3523: if (wf_event.account_name is null) then
3524: wf_event.SetAccountName;
3525: end if;