eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WF_EVENT dependencies on WF_AGENTS

Line 36: wf_agents agt1 ,

32: CURSOR agent_group_members(agent_name varchar2,system_name varchar2) is
33: select agt2.name as agt_name,
34: agt2.queue_handler as queue_handler
35: from wf_agent_groups agp ,
36: wf_agents agt1 ,
37: wf_agents agt2 ,
38: wf_systems sys
39: where agt1.name = agent_name
40: and agt1.type = 'GROUP'

Line 37: wf_agents agt2 ,

33: select agt2.name as agt_name,
34: agt2.queue_handler as queue_handler
35: from wf_agent_groups agp ,
36: wf_agents agt1 ,
37: wf_agents agt2 ,
38: wf_systems sys
39: where agt1.name = agent_name
40: and agt1.type = 'GROUP'
41: and agt1.status = 'ENABLED'

Line 862: outguid WF_AGENTS.GUID%TYPE;

858: /*
859: ** send -
860: */
861: PROCEDURE send(p_event in out nocopy wf_event_t) is
862: outguid WF_AGENTS.GUID%TYPE;
863: toagtname WF_AGENTS.NAME%TYPE;
864: toagtsys WF_SYSTEMS.NAME%TYPE;
865: outagtname WF_AGENTS.NAME%TYPE;
866: outagtsys WF_SYSTEMS.NAME%TYPE;

Line 863: toagtname WF_AGENTS.NAME%TYPE;

859: ** send -
860: */
861: PROCEDURE send(p_event in out nocopy wf_event_t) is
862: outguid WF_AGENTS.GUID%TYPE;
863: toagtname WF_AGENTS.NAME%TYPE;
864: toagtsys WF_SYSTEMS.NAME%TYPE;
865: outagtname WF_AGENTS.NAME%TYPE;
866: outagtsys WF_SYSTEMS.NAME%TYPE;
867: l_to_type WF_AGENTS.TYPE%TYPE;

Line 865: outagtname WF_AGENTS.NAME%TYPE;

861: PROCEDURE send(p_event in out nocopy wf_event_t) is
862: outguid WF_AGENTS.GUID%TYPE;
863: toagtname WF_AGENTS.NAME%TYPE;
864: toagtsys WF_SYSTEMS.NAME%TYPE;
865: outagtname WF_AGENTS.NAME%TYPE;
866: outagtsys WF_SYSTEMS.NAME%TYPE;
867: l_to_type WF_AGENTS.TYPE%TYPE;
868: -- l_mem_agt_name WF_AGENTS.NAME%TYPE;
869: l_to_queue_handler WF_AGENTS.QUEUE_HANDLER%TYPE;

Line 867: l_to_type WF_AGENTS.TYPE%TYPE;

863: toagtname WF_AGENTS.NAME%TYPE;
864: toagtsys WF_SYSTEMS.NAME%TYPE;
865: outagtname WF_AGENTS.NAME%TYPE;
866: outagtsys WF_SYSTEMS.NAME%TYPE;
867: l_to_type WF_AGENTS.TYPE%TYPE;
868: -- l_mem_agt_name WF_AGENTS.NAME%TYPE;
869: l_to_queue_handler WF_AGENTS.QUEUE_HANDLER%TYPE;
870:
871: -- wf bes cache implementation

Line 868: -- l_mem_agt_name WF_AGENTS.NAME%TYPE;

864: toagtsys WF_SYSTEMS.NAME%TYPE;
865: outagtname WF_AGENTS.NAME%TYPE;
866: outagtsys WF_SYSTEMS.NAME%TYPE;
867: l_to_type WF_AGENTS.TYPE%TYPE;
868: -- l_mem_agt_name WF_AGENTS.NAME%TYPE;
869: l_to_queue_handler WF_AGENTS.QUEUE_HANDLER%TYPE;
870:
871: -- wf bes cache implementation
872: l_to_agt_obj wf_agent_obj;

Line 869: l_to_queue_handler WF_AGENTS.QUEUE_HANDLER%TYPE;

865: outagtname WF_AGENTS.NAME%TYPE;
866: outagtsys WF_SYSTEMS.NAME%TYPE;
867: l_to_type WF_AGENTS.TYPE%TYPE;
868: -- l_mem_agt_name WF_AGENTS.NAME%TYPE;
869: l_to_queue_handler WF_AGENTS.QUEUE_HANDLER%TYPE;
870:
871: -- wf bes cache implementation
872: l_to_agt_obj wf_agent_obj;
873: l_out_agt_obj wf_agent_obj;

Line 980: l_to_address WF_AGENTS.ADDRESS%TYPE;

976: p_to_agent_name in varchar2,
977: p_to_system_name in varchar2,
978: p_out_queue_handler in varchar2)
979: return sys.aq$_agent is
980: l_to_address WF_AGENTS.ADDRESS%TYPE;
981: l_to_protocol WF_AGENTS.PROTOCOL%TYPE;
982: l_to_queue_name WF_AGENTS.QUEUE_NAME%TYPE;
983: l_to_protocol_number NUMBER := 0; -- Hard code as SQLNET
984:

Line 981: l_to_protocol WF_AGENTS.PROTOCOL%TYPE;

977: p_to_system_name in varchar2,
978: p_out_queue_handler in varchar2)
979: return sys.aq$_agent is
980: l_to_address WF_AGENTS.ADDRESS%TYPE;
981: l_to_protocol WF_AGENTS.PROTOCOL%TYPE;
982: l_to_queue_name WF_AGENTS.QUEUE_NAME%TYPE;
983: l_to_protocol_number NUMBER := 0; -- Hard code as SQLNET
984:
985: -- wf bes cache implementation

Line 982: l_to_queue_name WF_AGENTS.QUEUE_NAME%TYPE;

978: p_out_queue_handler in varchar2)
979: return sys.aq$_agent is
980: l_to_address WF_AGENTS.ADDRESS%TYPE;
981: l_to_protocol WF_AGENTS.PROTOCOL%TYPE;
982: l_to_queue_name WF_AGENTS.QUEUE_NAME%TYPE;
983: l_to_protocol_number NUMBER := 0; -- Hard code as SQLNET
984:
985: -- wf bes cache implementation
986: l_to_agt_obj wf_agent_obj;

Line 1057: l_to_type WF_AGENTS.TYPE%TYPE;

1053: PROCEDURE Set_Recipient_List(p_event in wf_event_t,
1054: p_out_agent_name in varchar2,
1055: p_out_system_name in varchar2,
1056: x_message_properties in out nocopy dbms_aq.message_properties_t) IS
1057: l_to_type WF_AGENTS.TYPE%TYPE;
1058: l_to_agent_name WF_AGENTS.NAME%TYPE;
1059: l_to_system_name WF_SYSTEMS.NAME%TYPE;
1060: l_out_queue_handler WF_AGENTS.QUEUE_HANDLER%TYPE;
1061: l_recipient_agent sys.aq$_agent;

Line 1058: l_to_agent_name WF_AGENTS.NAME%TYPE;

1054: p_out_agent_name in varchar2,
1055: p_out_system_name in varchar2,
1056: x_message_properties in out nocopy dbms_aq.message_properties_t) IS
1057: l_to_type WF_AGENTS.TYPE%TYPE;
1058: l_to_agent_name WF_AGENTS.NAME%TYPE;
1059: l_to_system_name WF_SYSTEMS.NAME%TYPE;
1060: l_out_queue_handler WF_AGENTS.QUEUE_HANDLER%TYPE;
1061: l_recipient_agent sys.aq$_agent;
1062: --Bug 2676549

Line 1060: l_out_queue_handler WF_AGENTS.QUEUE_HANDLER%TYPE;

1056: x_message_properties in out nocopy dbms_aq.message_properties_t) IS
1057: l_to_type WF_AGENTS.TYPE%TYPE;
1058: l_to_agent_name WF_AGENTS.NAME%TYPE;
1059: l_to_system_name WF_SYSTEMS.NAME%TYPE;
1060: l_out_queue_handler WF_AGENTS.QUEUE_HANDLER%TYPE;
1061: l_recipient_agent sys.aq$_agent;
1062: --Bug 2676549
1063: i number := 0;
1064:

Line 2240: -- qh is from WF_AGENTS.QUEUE_HANDLER

2236:
2237: WF_AGT_DYN_FUNCS.StaticEnqueue(qh, p_event, p_out_agent_override, p_executed);
2238:
2239: if (not p_executed) then
2240: -- qh is from WF_AGENTS.QUEUE_HANDLER
2241: -- BINDVAR_SCAN_IGNORE
2242: cmd := 'begin '||qh||'.enqueue(:v1, :v2); end;';
2243: execute immediate cmd using in p_event,
2244: in p_out_agent_override;

Line 3122: -- for a given agent name Query wf_agents to get the agent info

3118: 'Get Agent Details');
3119: end if;
3120:
3121: if(agent_name is not null and agent_name <> wf_event.pv_last_agent_name) then
3122: -- for a given agent name Query wf_agents to get the agent info
3123:
3124: l_agent_obj := wf_bes_cache.GetAgentByName(agent_name, null);
3125: if (l_agent_obj is not null) then
3126: l_queue_name := l_agent_obj.QUEUE_NAME;