[Home] [Help]
1839: -- present for the parent event
1840: --
1841:
1842: select count(*) INTO l_no_enabled_eres_sub
1843: from wf_events a, wf_event_subscriptions b
1844: where a.GUID = b.EVENT_FILTER_GUID
1845: and a.name = l_parent_event
1846: and b.RULE_FUNCTION='EDR_PSIG_RULE.PSIG_RULE'
1847: --Bug No 4912782- Start
1857: -- for parent event. if more than one ERES subscription is ENABLED
1858: -- Raise Multiple ERES Subscriptions error
1859: --
1860: select count(*) INTO l_no_enabled_eres_sub
1861: from wf_events a, wf_event_subscriptions b
1862: where a.GUID = b.EVENT_FILTER_GUID
1863: and a.name = l_parent_event
1864: and b.RULE_FUNCTION='EDR_PSIG_RULE.PSIG_RULE'
1865: and b.STATUS = 'ENABLED'
1914: -- for current event. if more than one ERES subscription is ENABLED
1915: -- Raise Multiple ERES Subscriptions error
1916: --
1917: select count(*) INTO l_no_enabled_eres_sub
1918: from wf_events a, wf_event_subscriptions b
1919: where a.GUID = b.EVENT_FILTER_GUID
1920: and a.name = p_event.event_name
1921: and b.RULE_FUNCTION='EDR_PSIG_RULE.PSIG_RULE'
1922: and b.STATUS = 'ENABLED'
1934: /* Select APPLICATION_ID of the Event. This is required by AME. Assumption made here
1935: is OWNER_TAG will always be set to application Short Name */
1936:
1937: SELECT application_id,APPLICATION_SHORT_NAME into l_application_id,l_application_code
1938: FROM FND_APPLICATION A, WF_EVENTS B
1939: WHERE A.APPLICATION_SHORT_NAME = B.OWNER_TAG
1940: AND B.NAME=P_EVENT.getEventName( );
1941:
1942: wf_log_pkg.string(1, 'EDR_PSIG_RULE.psig_rule','Application_id :'||l_application_id );