[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
193: BEGIN
194: SELECT application_id,APPLICATION_SHORT_NAME into l_application_id,l_application_code
195: FROM FND_APPLICATION
196: WHERE APPLICATION_SHORT_NAME in
197: (SELECT OWNER_TAG from WF_EVENTS WHERE NAME=evt.getEventName( ));
198:
199: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_EVENT_APP_CODE');
200: fnd_message.set_token( 'APPCODE', l_application_code);
201: fnd_file.put_line(fnd_file.output, fnd_message.get);
1212:
1213: CURSOR c1 is
1214: SELECT DISPLAY_NAME
1215: from
1216: wf_events_vl
1217: WHERE NAME= P_EVENT;
1218:
1219: BEGIN
1220: OPEN C1;
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'
1788: SELECT application_id,APPLICATION_SHORT_NAME into l_application_id,
1789: l_application_code
1790: FROM FND_APPLICATION
1791: WHERE APPLICATION_SHORT_NAME in
1792: (SELECT OWNER_TAG from WF_EVENTS
1793: WHERE NAME=evt.getEventName( ));
1794: --For the obtained AME transaction, fetch the rules that are are
1795: --applicable for the specified transaction id.
1796: