APPS.WF_EVENT dependencies on WF_SYSTEMS

Line 55: wf_systems sys

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'
59: and agt1.system_guid = sys.guid

Line 894: toagtsys WF_SYSTEMS.NAME%TYPE;

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;
898: -- l_mem_agt_name WF_AGENTS.NAME%TYPE;

Line 896: outagtsys WF_SYSTEMS.NAME%TYPE;

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;
900:

Line 1089: l_to_system_name WF_SYSTEMS.NAME%TYPE;

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
1093: i number := 0;

Line 3703: from wf_systems

3699:
3700: wf_event.local_system_status := wf_core.translate('WF_SYSTEM_STATUS');
3701:
3702: select name into wf_event.local_system_name
3703: from wf_systems
3704: where guid = wf_event.local_system_guid;
3705: ---------------------------------------------------------------------------
3706: wf_event.schema_name := wf_core.translate('WF_SCHEMA');
3707: