DBA Data[Home] [Help]

APPS.CSI_HANDLE_EVENT_PKG dependencies on WF_EVENTS

Line 13: FROM wf_events eve,

9: FUNCTION exist_subscription(p_event_name IN VARCHAR2) RETURN VARCHAR2
10: IS
11: CURSOR cu0 IS
12: SELECT 'Y'
13: FROM wf_events eve,
14: wf_event_subscriptions sub,
15: wf_systems ws
16: WHERE eve.name = p_event_name
17: AND eve.status = 'ENABLED'

Line 58: FROM wf_events

54: RetEvent VARCHAR2(240);
55: BEGIN
56: SELECT name
57: INTO RetEvent
58: FROM wf_events
59: WHERE name = p_event_name;
60:
61: IF SQL%NOTFOUND THEN
62: RetEvent := 'NOTFOUND';