APPS.EDR_ERES_EVENT_PUB dependencies on WF_EVENTS

Line 6: /** Validate if the event name exists in the WF_EVENTS table **/

2: /* $Header: EDRPEVTB.pls 120.3.12000000.1 2007/01/18 05:54:30 appldev ship $*/
3:
4: -- Private Utility Functions and/or procedures --
5:
6: /** Validate if the event name exists in the WF_EVENTS table **/
7:
8: FUNCTION VALID_EVENT_NAME (p_event_name IN varchar2)
9: return BOOLEAN
10: is

Line 13: from wf_events_vl

9: return BOOLEAN
10: is
11: cursor l_count_csr is
12: select count(*)
13: from wf_events_vl
14: where name = p_event_name;
15:
16: l_count NUMBER;
17:

Line 308: from wf_events a, wf_event_subscriptions b

304:
305: -- Bug Start: 5087502
306: -- Verify if an active ERES subscription is available for current event.
307: select count(*) INTO l_no_enabled_eres_sub
308: from wf_events a, wf_event_subscriptions b
309: where a.GUID = b.EVENT_FILTER_GUID
310: and a.name = p_event_name
311: and b.RULE_FUNCTION='EDR_PSIG_RULE.PSIG_RULE'
312: and b.STATUS = 'ENABLED'