APPS.WF_EVENT_HTML dependencies on WF_EVENT_SUBSCRIPTIONS

Line 35: from WF_EVENT_SUBSCRIPTIONS

31: end if;
32:
33: -- if there is any subscription, it has detail and is not deletable.
34: select count(1) into member_count
35: from WF_EVENT_SUBSCRIPTIONS
36: where EVENT_FILTER_GUID = x_guid;
37:
38: -- do not bother to check further if there are subscriptions.
39: if (member_count > 0) then

Line 47: from WF_EVENT_SUBSCRIPTIONS

43: elsif (x_type = 'SYSTEM_S' or x_type = 'SYSTEM') then
44: -- SYSTEM_S is for checking subscription only.
45: -- if there is any subscrption, it is not deletable.
46: select count(1) into member_count
47: from WF_EVENT_SUBSCRIPTIONS
48: where SYSTEM_GUID = x_guid;
49:
50: -- SYSTEM_S also needs to check the new MASTER requirement
51: -- to see if it is a master of some body else

Line 64: from WF_EVENT_SUBSCRIPTIONS

60: end if;
61:
62: elsif (x_type = 'AGENT') then
63: select count(1) into member_count
64: from WF_EVENT_SUBSCRIPTIONS
65: where SOURCE_AGENT_GUID = x_guid
66: or OUT_AGENT_GUID = x_guid
67: or TO_AGENT_GUID = x_guid;
68:

Line 73: from WF_EVENT_SUBSCRIPTIONS

69: elsif (x_type = 'SUBSCRIPTION') then
70: -- there is no dependency at this moment
71: -- but later on, we may check the runtime table
72: select count(1) into member_count
73: from WF_EVENT_SUBSCRIPTIONS
74: where GUID = x_guid
75: and CUSTOMIZATION_LEVEL in ('C','L');
76:
77: -- do not bother to check further if the event is of type Core/Limit

Line 164: from wf_event_subscriptions

160:
161: -- SUBSCRIPTIONS: check if any event subscriptions for LOCAL
162: if x_type = 'SUBSCRIPTIONS' then
163: select count(*) into l_count
164: from wf_event_subscriptions
165: where system_guid = hextoraw(wf_core.translate('WF_SYSTEM_GUID'));
166: end if;
167:
168: -- If the count is zero, we didn't find what we were looking for

Line 561: from WF_EVENT_SUBSCRIPTIONS

557:
558: dTab(i).selectable := FALSE;
559:
560: select count(1) into acnt
561: from WF_EVENT_SUBSCRIPTIONS
562: where SYSTEM_GUID = asystem.guid;
563:
564: if (acnt = 0) then
565: dTab(i).deletable := Wf_Event_Html.isDeletable(asystem.guid, 'SYSTEM');

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 3073: from WF_EVENT_SUBSCRIPTIONS

3069: l_wfpname,
3070: l_param,
3071: l_customization_level,
3072: l_desc
3073: from WF_EVENT_SUBSCRIPTIONS
3074: where GUID = h_guid;
3075:
3076: -- take care of the double quote problem
3077: -- Description is handle entirely differently, no need for substitution.

Line 4246: Wf_Event_Subscriptions_Pkg.Update_Row (

4242: if (h_guid is not null) then
4243: l_guid := hextoraw(h_guid);
4244:
4245: -- update
4246: Wf_Event_Subscriptions_Pkg.Update_Row (
4247: X_GUID=>l_guid,
4248: X_SYSTEM_GUID=>l_sysguid,
4249: X_SOURCE_TYPE=>h_source_type,
4250: X_SOURCE_AGENT_GUID=>l_fagnguid,

Line 4271: Wf_Event_Subscriptions_Pkg.Insert_Row (

4267: else
4268: l_guid := sys_guid();
4269:
4270: -- insert
4271: Wf_Event_Subscriptions_Pkg.Insert_Row (
4272: X_ROWID=>row_id,
4273: X_GUID=>l_guid,
4274: X_SYSTEM_GUID=>l_sysguid,
4275: X_SOURCE_TYPE=>h_source_type,

Line 4794: Wf_Event_Subscriptions_Pkg.Delete_Row(h_guid);

4790: h_guid in raw default null)
4791: is
4792: begin
4793: if (isDeletable(h_guid, 'SUBSCRIPTION')) then
4794: Wf_Event_Subscriptions_Pkg.Delete_Row(h_guid);
4795: end if;
4796:
4797: -- go back to ListSubscriptions
4798: htp.p('