[Home] [Help]
61: i integer;
62: CURSOR GET_EVT_SUBSCRIPTION_DETAILS IS
63: select b.guid,A.status,b.status
64: from
65: wf_events a, wf_event_subscriptions b
66: where a.GUID = b.EVENT_FILTER_GUID
67: and a.name = p_event
68: and b.RULE_FUNCTION='EDR_PSIG_RULE.PSIG_RULE'
69: --Bug No 4912782- Start
108: -- Verify is more than one active ERES subscriptions are present
109: --
110: select count(*) INTO l_no_enabled_eres_sub
111: from
112: wf_events a, wf_event_subscriptions b
113: where a.GUID = b.EVENT_FILTER_GUID
114: and a.name = p_event
115: and b.RULE_FUNCTION='EDR_PSIG_RULE.PSIG_RULE'
116: and b.STATUS = 'ENABLED'
122: RAISE MULTIPLE_ERES_SUBSCRIPTIONS;
123: ELSE
124: select count(*) INTO l_no_enabled_eres_sub
125: from
126: wf_events a, wf_event_subscriptions b
127: where a.GUID = b.EVENT_FILTER_GUID
128: and a.name = p_event
129: and b.RULE_FUNCTION='EDR_PSIG_RULE.PSIG_RULE'
130: --Bug No 4912782- Start
1681: -- bug 5586151 : End
1682: CURSOR GET_EVT_SUBSCRIPTION_DETAILS IS
1683: select b.guid,A.status,b.status
1684: from
1685: wf_events a, wf_event_subscriptions b
1686: where a.GUID = b.EVENT_FILTER_GUID
1687: and a.name = p_event_name
1688: and b.RULE_FUNCTION='EDR_PSIG_RULE.PSIG_RULE'
1689: -- bug 5586151 : start
1713:
1714:
1715: --Obtain the number of ERES subscriptions enabled for this event.
1716: select count(*) INTO l_no_enabled_eres_sub
1717: from wf_events a, wf_event_subscriptions b
1718: where a.GUID = b.EVENT_FILTER_GUID
1719: and a.name = p_event_name
1720: and b.RULE_FUNCTION='EDR_PSIG_RULE.PSIG_RULE'
1721: and b.STATUS = 'ENABLED'