APPS.CSI_HANDLE_EVENT_PKG dependencies on WF_EVENT

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 14: wf_event_subscriptions sub,

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'
18: AND eve.guid = sub.event_filter_guid

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';

Line 115: wf_event.AddParameterToList(p_name => 'CUSTOMER_PRODUCT_ID'

111: IF SUBSTR(l_event,1,16) <> 'oracle.apps.csi.' THEN
112: RAISE EventNotCSI;
113: END IF;
114:
115: wf_event.AddParameterToList(p_name => 'CUSTOMER_PRODUCT_ID'
116: ,p_value => p_instance_id
117: ,p_parameterlist => l_parameter_list);
118:
119: wf_event.AddParameterToList(p_name => 'CHILD_CUSTOMER_PRODUCT_ID'

Line 119: wf_event.AddParameterToList(p_name => 'CHILD_CUSTOMER_PRODUCT_ID'

115: wf_event.AddParameterToList(p_name => 'CUSTOMER_PRODUCT_ID'
116: ,p_value => p_instance_id
117: ,p_parameterlist => l_parameter_list);
118:
119: wf_event.AddParameterToList(p_name => 'CHILD_CUSTOMER_PRODUCT_ID'
120: ,p_value => p_subject_instance_id
121: ,p_parameterlist => l_parameter_list);
122:
123: wf_event.AddParameterToList(p_name => 'Q_CORRELATION_ID'

Line 123: wf_event.AddParameterToList(p_name => 'Q_CORRELATION_ID'

119: wf_event.AddParameterToList(p_name => 'CHILD_CUSTOMER_PRODUCT_ID'
120: ,p_value => p_subject_instance_id
121: ,p_parameterlist => l_parameter_list);
122:
123: wf_event.AddParameterToList(p_name => 'Q_CORRELATION_ID'
124: ,p_value => p_correlation_value
125: ,p_parameterlist => l_parameter_list);
126:
127: Wf_Event.Raise

Line 127: Wf_Event.Raise

123: wf_event.AddParameterToList(p_name => 'Q_CORRELATION_ID'
124: ,p_value => p_correlation_value
125: ,p_parameterlist => l_parameter_list);
126:
127: Wf_Event.Raise
128: (p_event_name => l_event,
129: p_event_key => p_event_key,
130: p_parameters => l_parameter_list);
131: