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 53: wf_agents agt1 ,

49: CURSOR agent_group_members(agent_name varchar2,system_name varchar2) is
50: select agt2.name as agt_name,
51: agt2.queue_handler as queue_handler
52: from wf_agent_groups agp ,
53: wf_agents agt1 ,
54: wf_agents agt2 ,
55: wf_systems sys
56: where agt1.name = agent_name
57: and agt1.type = 'GROUP'

Line 54: wf_agents agt2 ,

50: select agt2.name as agt_name,
51: agt2.queue_handler as queue_handler
52: from wf_agent_groups agp ,
53: wf_agents agt1 ,
54: wf_agents agt2 ,
55: wf_systems sys
56: where agt1.name = agent_name
57: and agt1.type = 'GROUP'
58: and agt1.status = 'ENABLED'

Line 892: outguid WF_AGENTS.GUID%TYPE;

888: /*
889: ** send -
890: */
891: PROCEDURE send(p_event in out nocopy wf_event_t) is
892: outguid WF_AGENTS.GUID%TYPE;
893: toagtname WF_AGENTS.NAME%TYPE;
894: toagtsys WF_SYSTEMS.NAME%TYPE;
895: outagtname WF_AGENTS.NAME%TYPE;
896: outagtsys WF_SYSTEMS.NAME%TYPE;

Line 893: toagtname WF_AGENTS.NAME%TYPE;

889: ** send -
890: */
891: PROCEDURE send(p_event in out nocopy wf_event_t) is
892: outguid WF_AGENTS.GUID%TYPE;
893: toagtname WF_AGENTS.NAME%TYPE;
894: toagtsys WF_SYSTEMS.NAME%TYPE;
895: outagtname WF_AGENTS.NAME%TYPE;
896: outagtsys WF_SYSTEMS.NAME%TYPE;
897: l_to_type WF_AGENTS.TYPE%TYPE;

Line 895: outagtname WF_AGENTS.NAME%TYPE;

891: PROCEDURE send(p_event in out nocopy wf_event_t) is
892: outguid WF_AGENTS.GUID%TYPE;
893: toagtname WF_AGENTS.NAME%TYPE;
894: toagtsys WF_SYSTEMS.NAME%TYPE;
895: outagtname WF_AGENTS.NAME%TYPE;
896: outagtsys WF_SYSTEMS.NAME%TYPE;
897: l_to_type WF_AGENTS.TYPE%TYPE;
898: -- l_mem_agt_name WF_AGENTS.NAME%TYPE;
899: l_to_queue_handler WF_AGENTS.QUEUE_HANDLER%TYPE;

Line 897: l_to_type WF_AGENTS.TYPE%TYPE;

893: toagtname WF_AGENTS.NAME%TYPE;
894: toagtsys WF_SYSTEMS.NAME%TYPE;
895: outagtname WF_AGENTS.NAME%TYPE;
896: outagtsys WF_SYSTEMS.NAME%TYPE;
897: l_to_type WF_AGENTS.TYPE%TYPE;
898: -- l_mem_agt_name WF_AGENTS.NAME%TYPE;
899: l_to_queue_handler WF_AGENTS.QUEUE_HANDLER%TYPE;
900:
901: -- wf bes cache implementation

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

894: toagtsys WF_SYSTEMS.NAME%TYPE;
895: outagtname WF_AGENTS.NAME%TYPE;
896: outagtsys WF_SYSTEMS.NAME%TYPE;
897: l_to_type WF_AGENTS.TYPE%TYPE;
898: -- l_mem_agt_name WF_AGENTS.NAME%TYPE;
899: l_to_queue_handler WF_AGENTS.QUEUE_HANDLER%TYPE;
900:
901: -- wf bes cache implementation
902: l_to_agt_obj wf_agent_obj;

Line 899: l_to_queue_handler WF_AGENTS.QUEUE_HANDLER%TYPE;

895: outagtname WF_AGENTS.NAME%TYPE;
896: outagtsys WF_SYSTEMS.NAME%TYPE;
897: l_to_type WF_AGENTS.TYPE%TYPE;
898: -- l_mem_agt_name WF_AGENTS.NAME%TYPE;
899: l_to_queue_handler WF_AGENTS.QUEUE_HANDLER%TYPE;
900:
901: -- wf bes cache implementation
902: l_to_agt_obj wf_agent_obj;
903: l_out_agt_obj wf_agent_obj;

Line 1010: l_to_address WF_AGENTS.ADDRESS%TYPE;

1006: p_to_agent_name in varchar2,
1007: p_to_system_name in varchar2,
1008: p_out_queue_handler in varchar2)
1009: return sys.aq$_agent is
1010: l_to_address WF_AGENTS.ADDRESS%TYPE;
1011: l_to_protocol WF_AGENTS.PROTOCOL%TYPE;
1012: l_to_queue_name WF_AGENTS.QUEUE_NAME%TYPE;
1013: l_to_protocol_number NUMBER := 0; -- Hard code as SQLNET
1014:

Line 1011: l_to_protocol WF_AGENTS.PROTOCOL%TYPE;

1007: p_to_system_name in varchar2,
1008: p_out_queue_handler in varchar2)
1009: return sys.aq$_agent is
1010: l_to_address WF_AGENTS.ADDRESS%TYPE;
1011: l_to_protocol WF_AGENTS.PROTOCOL%TYPE;
1012: l_to_queue_name WF_AGENTS.QUEUE_NAME%TYPE;
1013: l_to_protocol_number NUMBER := 0; -- Hard code as SQLNET
1014:
1015: -- wf bes cache implementation

Line 1012: l_to_queue_name WF_AGENTS.QUEUE_NAME%TYPE;

1008: p_out_queue_handler in varchar2)
1009: return sys.aq$_agent is
1010: l_to_address WF_AGENTS.ADDRESS%TYPE;
1011: l_to_protocol WF_AGENTS.PROTOCOL%TYPE;
1012: l_to_queue_name WF_AGENTS.QUEUE_NAME%TYPE;
1013: l_to_protocol_number NUMBER := 0; -- Hard code as SQLNET
1014:
1015: -- wf bes cache implementation
1016: l_to_agt_obj wf_agent_obj;

Line 1087: l_to_type WF_AGENTS.TYPE%TYPE;

1083: PROCEDURE Set_Recipient_List(p_event in wf_event_t,
1084: p_out_agent_name in varchar2,
1085: p_out_system_name in varchar2,
1086: x_message_properties in out nocopy dbms_aq.message_properties_t) IS
1087: l_to_type WF_AGENTS.TYPE%TYPE;
1088: l_to_agent_name WF_AGENTS.NAME%TYPE;
1089: l_to_system_name WF_SYSTEMS.NAME%TYPE;
1090: l_out_queue_handler WF_AGENTS.QUEUE_HANDLER%TYPE;
1091: l_recipient_agent sys.aq$_agent;

Line 1088: l_to_agent_name WF_AGENTS.NAME%TYPE;

1084: p_out_agent_name in varchar2,
1085: p_out_system_name in varchar2,
1086: x_message_properties in out nocopy dbms_aq.message_properties_t) IS
1087: l_to_type WF_AGENTS.TYPE%TYPE;
1088: l_to_agent_name WF_AGENTS.NAME%TYPE;
1089: l_to_system_name WF_SYSTEMS.NAME%TYPE;
1090: l_out_queue_handler WF_AGENTS.QUEUE_HANDLER%TYPE;
1091: l_recipient_agent sys.aq$_agent;
1092: --Bug 2676549

Line 1090: l_out_queue_handler WF_AGENTS.QUEUE_HANDLER%TYPE;

1086: x_message_properties in out nocopy dbms_aq.message_properties_t) IS
1087: l_to_type WF_AGENTS.TYPE%TYPE;
1088: l_to_agent_name WF_AGENTS.NAME%TYPE;
1089: l_to_system_name WF_SYSTEMS.NAME%TYPE;
1090: l_out_queue_handler WF_AGENTS.QUEUE_HANDLER%TYPE;
1091: l_recipient_agent sys.aq$_agent;
1092: --Bug 2676549
1093: i number := 0;
1094:

Line 2297: -- qh is from WF_AGENTS.QUEUE_HANDLER

2293:
2294: WF_AGT_DYN_FUNCS.StaticEnqueue(qh, p_event, p_out_agent_override, p_executed);
2295:
2296: if (not p_executed) then
2297: -- qh is from WF_AGENTS.QUEUE_HANDLER
2298: -- BINDVAR_SCAN_IGNORE
2299: cmd := 'begin '||qh||'.enqueue(:v1, :v2); end;';
2300: execute immediate cmd using in p_event,
2301: in p_out_agent_override;

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

3180: 'Get Agent Details');
3181: end if;
3182:
3183: if(agent_name is not null and agent_name <> wf_event.pv_last_agent_name) then
3184: -- for a given agent name Query wf_agents to get the agent info
3185:
3186: l_agent_obj := wf_bes_cache.GetAgentByName(agent_name, null);
3187: if (l_agent_obj is not null) then
3188: l_queue_name := l_agent_obj.QUEUE_NAME;