APPS.HZ_EVENT_PKG dependencies on WF_EVENT

Line 70: -- WF_EVENT_SUBSCRIPTIONS_N1 defined on

66: -- Otherwise it returns 'N'
67: -----------------------------------------------------------------------
68: IS
69: -- Bug 3784725 : Modify the cursor so that it can use index
70: -- WF_EVENT_SUBSCRIPTIONS_N1 defined on
71: -- table wf_event_subscriptions for better performance.
72: CURSOR cu0 IS
73: SELECT 'Y'
74: FROM wf_events eve,

Line 71: -- table wf_event_subscriptions for better performance.

67: -----------------------------------------------------------------------
68: IS
69: -- Bug 3784725 : Modify the cursor so that it can use index
70: -- WF_EVENT_SUBSCRIPTIONS_N1 defined on
71: -- table wf_event_subscriptions for better performance.
72: CURSOR cu0 IS
73: SELECT 'Y'
74: FROM wf_events eve,
75: wf_event_subscriptions sub,

Line 74: FROM wf_events eve,

70: -- WF_EVENT_SUBSCRIPTIONS_N1 defined on
71: -- table wf_event_subscriptions for better performance.
72: CURSOR cu0 IS
73: SELECT 'Y'
74: FROM wf_events eve,
75: wf_event_subscriptions sub,
76: wf_systems ws
77: WHERE eve.name = p_event_name
78: AND eve.status = 'ENABLED'

Line 75: wf_event_subscriptions sub,

71: -- table wf_event_subscriptions for better performance.
72: CURSOR cu0 IS
73: SELECT 'Y'
74: FROM wf_events eve,
75: wf_event_subscriptions sub,
76: wf_systems ws
77: WHERE eve.name = p_event_name
78: AND eve.status = 'ENABLED'
79: AND eve.guid = sub.event_filter_guid

Line 116: FROM wf_events

112: IS
113: RetEvent VARCHAR2(240);
114: BEGIN
115: SELECT name INTO RetEvent
116: FROM wf_events
117: WHERE name = p_event_name;
118: IF SQL%NOTFOUND THEN
119: RetEvent := 'NOTFOUND';
120: END IF;

Line 268: Wf_Event.Raise

264: IF SUBSTR(l_event,1,18) <> 'oracle.apps.ar.hz.' THEN
265: RAISE EventNotHZ;
266: END IF;
267:
268: Wf_Event.Raise
269: ( p_event_name => l_event,
270: p_event_key => p_event_key,
271: p_parameters => p_parameters,
272: p_event_data => p_data);