APPS.WF_EVENT_HTML dependencies on WF_SYSTEMS

Line 54: from WF_SYSTEMS

50: -- SYSTEM_S also needs to check the new MASTER requirement
51: -- to see if it is a master of some body else
52: if (member_count = 0) then
53: select count(1) into member_count
54: from WF_SYSTEMS
55: where MASTER_GUID = x_guid;
56: end if;
57:
58: if (member_count > 0) then

Line 136: from wf_systems

132: -- check there is a record in the system table
133: -- that matched the WF_SYSTEM_GUID
134: -- this is always checked
135: select count(*) into l_count
136: from wf_systems
137: where guid = hextoraw(wf_core.translate('WF_SYSTEM_GUID'));
138:
139: if l_count = 0 then
140: wf_core.raise('WFE_NO_SYSTEM');

Line 415: from WF_SYSTEMS

411: )
412: is
413: cursor syscurs(mguid raw, xn varchar2, xdn varchar2) is
414: select GUID, DISPLAY_NAME, NAME, MASTER_GUID
415: from WF_SYSTEMS
416: where (xdn is null or lower(DISPLAY_NAME) like '%'||lower(xdn)||'%')
417: and (xn is null or lower(NAME) like '%'||lower(xn)||'%')
418: and (mguid is null or MASTER_GUID = mguid)
419: order by NAME;

Line 543: from WF_SYSTEMS

539: if (l_mguid is null or l_mname is null) then
540: begin
541: select NAME
542: into l_mname
543: from WF_SYSTEMS
544: where GUID = asystem.master_guid;
545: exception
546: when NO_DATA_FOUND then
547: wf_core.token('GUID', rawtohex(asystem.master_guid));

Line 688: from WF_AGENTS A, WF_SYSTEMS S

684: xd varchar2, xs varchar2) is
685: select A.GUID, A.NAME, A.PROTOCOL, A.ADDRESS,
686: S.NAME SYSTEM_NAME,
687: A.DIRECTION, A.STATUS
688: from WF_AGENTS A, WF_SYSTEMS S
689: where (xn is null or lower(A.NAME) like '%'||lower(xn)||'%')
690: and (xp is null or A.PROTOCOL = xp)
691: and (xa is null or A.ADDRESS = xa)
692: and (sguid is null or S.GUID = sguid)

Line 1010: from WF_EVENT_SUBSCRIPTIONS ES, WF_EVENTS E, WF_SYSTEMS SY

1006: ES.STATUS,
1007: ES.OUT_AGENT_GUID, ES.TO_AGENT_GUID,
1008: ES.RULE_FUNCTION, ES.WF_PROCESS_TYPE, ES.WF_PROCESS_NAME,
1009: SY.NAME SYSTEM_NAME, E.NAME EVENT_NAME
1010: from WF_EVENT_SUBSCRIPTIONS ES, WF_EVENTS E, WF_SYSTEMS SY
1011: where (eguid is null or ES.EVENT_FILTER_GUID = eguid)
1012: and (xt = '*' or ES.SOURCE_TYPE = xt)
1013: and (sguid is null or ES.SYSTEM_GUID = sguid)
1014: and (xs = '*' or ES.STATUS = xs)

Line 1129: from WF_SYSTEMS

1125: -- from system
1126: begin
1127: select NAME
1128: into l_name
1129: from WF_SYSTEMS
1130: where GUID = l_sguid;
1131: exception
1132: when OTHERS then
1133: l_name := null;

Line 1270: from WF_AGENTS A, WF_SYSTEMS S

1266: -- find the system name
1267: begin
1268: select S.NAME
1269: into dTab(i).col03
1270: from WF_AGENTS A, WF_SYSTEMS S
1271: where A.GUID = ssr.out_agent_guid
1272: and A.SYSTEM_GUID = S.GUID;
1273: exception
1274: when OTHERS then

Line 1309: from WF_AGENTS A, WF_SYSTEMS S

1305: -- find the system name
1306: begin
1307: select S.NAME
1308: into dTab(i).col04
1309: from WF_AGENTS A, WF_SYSTEMS S
1310: where A.GUID = ssr.to_agent_guid
1311: and A.SYSTEM_GUID = S.GUID;
1312: exception
1313: when OTHERS then

Line 2376: from WF_SYSTEMS

2372: if (h_guid is not null) then
2373: begin
2374: select NAME, DISPLAY_NAME, DESCRIPTION, MASTER_GUID
2375: into l_name, l_dname, l_desc, l_mguid
2376: from WF_SYSTEMS
2377: where GUID = h_guid;
2378:
2379: exception
2380: when NO_DATA_FOUND then

Line 2388: from WF_SYSTEMS

2384: if (l_mguid is not null) then
2385: begin
2386: select NAME
2387: into l_mname
2388: from WF_SYSTEMS
2389: where GUID = l_mguid;
2390: exception
2391: when NO_DATA_FOUND then
2392: wf_core.token('GUID', rawtohex(l_mguid));

Line 2629: from WF_AGENTS A, WF_SYSTEMS S

2625: A.DIRECTION, A.STATUS, S.NAME
2626: into l_name, l_dname, l_desc, l_protocol, l_address,
2627: l_sysguid, l_qhandler, l_qname,
2628: l_direction, l_status, l_system
2629: from WF_AGENTS A, WF_SYSTEMS S
2630: where A.GUID = h_guid
2631: and A.SYSTEM_GUID = S.GUID;
2632:
2633: -- take care of the double quote problem

Line 3145: from WF_SYSTEMS

3141: if (l_sysguid is not null) then
3142: begin
3143: select NAME
3144: into l_system_name
3145: from WF_SYSTEMS
3146: where GUID = l_sysguid;
3147:
3148: exception
3149: when NO_DATA_FOUND then

Line 3178: from WF_AGENTS A, WF_SYSTEMS S

3174: if (l_srcagnguid is not null) then
3175: begin
3176: select A.NAME||'@'||S.NAME
3177: into l_srcagn_dname
3178: from WF_AGENTS A, WF_SYSTEMS S
3179: where A.GUID = l_srcagnguid
3180: and A.SYSTEM_GUID (+)= S.GUID;
3181:
3182: exception

Line 3194: from WF_AGENTS A, WF_SYSTEMS S

3190: if (l_outagnguid is not null) then
3191: begin
3192: select A.NAME||'@'||S.NAME
3193: into l_outagn_dname
3194: from WF_AGENTS A, WF_SYSTEMS S
3195: where A.GUID = l_outagnguid
3196: and A.SYSTEM_GUID (+)= S.GUID;
3197:
3198: exception

Line 3210: from WF_AGENTS A, WF_SYSTEMS S

3206: if (l_toagnguid is not null) then
3207: begin
3208: select A.NAME||'@'||S.NAME
3209: into l_toagn_dname
3210: from WF_AGENTS A, WF_SYSTEMS S
3211: where A.GUID = l_toagnguid
3212: and A.SYSTEM_GUID (+)= S.GUID;
3213:
3214: exception

Line 3252: from WF_SYSTEMS

3248: if (h_sguid is not null) then
3249: begin
3250: select NAME
3251: into l_system_name
3252: from WF_SYSTEMS
3253: where GUID = h_sguid;
3254:
3255: exception
3256: when NO_DATA_FOUND then

Line 4013: Wf_Systems_Pkg.Update_Row(

4009: if (h_guid is not null) then
4010: l_guid := hextoraw(h_guid);
4011:
4012: -- update
4013: Wf_Systems_Pkg.Update_Row(
4014: X_GUID=>l_guid,
4015: X_NAME=>h_name,
4016: X_MASTER_GUID=>l_mguid,
4017: X_DISPLAY_NAME=>h_display_name,

Line 4025: Wf_Systems_Pkg.Insert_Row(

4021: else
4022: l_guid := sys_guid();
4023:
4024: -- insert
4025: Wf_Systems_Pkg.Insert_Row(
4026: X_ROWID=>row_id,
4027: X_GUID=>l_guid,
4028: X_NAME=>h_name,
4029: X_MASTER_GUID=>l_mguid,

Line 4739: Wf_Systems_Pkg.Delete_Row(h_guid);

4735: h_guid in raw default null)
4736: is
4737: begin
4738: if (isDeletable(h_guid, 'SYSTEM')) then
4739: Wf_Systems_Pkg.Delete_Row(h_guid);
4740: end if;
4741:
4742: -- go back to ListSystems
4743: htp.p('