APPS.WF_EVENT_SYNCHRONIZE_PKG dependencies on WF_SYSTEMS

Line 12: g_system varchar2(100) := '';

8: g_begin_clob varchar2(100) := '';
9: g_end_clob varchar2(100) := '';
10: g_begin_string varchar2(100) := '';
11: g_end_string varchar2(100) := '';
12: g_system varchar2(100) := '';
13: g_agent varchar2(100) := '';
14: g_agent_group varchar2(100) := '';
15: g_event varchar2(100) := '';
16: g_event_group varchar2(100) := '';

Line 548: select guid from wf_systems

544: l_clob clob;
545: returnclob clob;
546:
547: cursor systems is
548: select guid from wf_systems
549: where name like nvl(p_key,'%');
550:
551: begin
552:

Line 1188: wf_systems_pkg.receive(p_messagedata);

1184:
1185: begin
1186:
1187: IF p_objecttype = g_system THEN
1188: wf_systems_pkg.receive(p_messagedata);
1189: ELSIF p_objecttype = g_agent THEN
1190: wf_agents_pkg.receive(p_messagedata);
1191: ELSIF p_objecttype = g_agent_group THEN
1192: wf_agent_groups_pkg.receive(p_messagedata);

Line 1224: from WF_SYSTEMS;

1220: begin
1221: if g_guid is not null then
1222: select count(*)
1223: into l_count
1224: from WF_SYSTEMS;
1225: if (l_count = 0) then
1226: update WF_RESOURCES
1227: set text=g_guid
1228: where name='WF_SYSTEM_GUID';

Line 1291: g_beg_system varchar2(100) := '';

1287: ) return varchar2 is
1288:
1289: g_guid varchar2(100) := '#NEW';
1290: g_guid2 varchar2(100) := '#NEW';
1291: g_beg_system varchar2(100) := '';
1292: g_end_system varchar2(100) := '';
1293: retStr varchar2(32000) default null;
1294: l_guid raw(16) default null;
1295:

Line 1292: g_end_system varchar2(100) := '';

1288:
1289: g_guid varchar2(100) := '#NEW';
1290: g_guid2 varchar2(100) := '#NEW';
1291: g_beg_system varchar2(100) := '';
1292: g_end_system varchar2(100) := '';
1293: retStr varchar2(32000) default null;
1294: l_guid raw(16) default null;
1295:
1296: begin

Line 1863: 'WF_SYSTEMS',

1859: l_module_name varchar2(30) := 'Prepare_Zero_Down_Time';
1860: l_tem_tab_name varchar2(50);
1861: TYPE TableName is VARRAY(8) OF VARCHAR2(50);
1862: WFTable TableName:=TableName ('WF_RESOURCES',
1863: 'WF_SYSTEMS',
1864: 'WF_AGENTS',
1865: 'WF_AGENT_GROUPS',
1866: 'WF_EVENTS',
1867: 'WF_EVENTS_TL',