DBA Data[Home] [Help]

APPS.GMO_CBR_GRP dependencies on WF_EVENT_SUBSCRIPTIONS

Line 27: wf_event_subscriptions b

23: ,a.DISPLAY_NAME
24: ,a.DESCRIPTION
25: FROM
26: wf_events_vl a,
27: wf_event_subscriptions b
28: WHERE a.GUID = b.EVENT_FILTER_GUID
29: and b.RULE_FUNCTION in ('GMO_CBR_GRP.PROCESS_EVENT','GMO_CBR_GRP.PROCESS_INSTANCE_INSTR_SET');
30:
31: --

Line 67: wf_event_subscriptions b

63: ,b.ON_ERROR_CODE
64: ,b.ACTION_CODE
65: FROM
66: wf_events_vl a,
67: wf_event_subscriptions b
68: WHERE a.GUID = b.EVENT_FILTER_GUID
69: AND b.RULE_FUNCTION='EDR_PSIG_RULE.PSIG_RULE'
70: AND a.name = l_event_name
71: and b.owner_tag <> 'GMO'

Line 110: wf_event_subscriptions b

106: ,b.ON_ERROR_CODE
107: ,b.ACTION_CODE
108: FROM
109: wf_events_vl a,
110: wf_event_subscriptions b
111: WHERE a.GUID = b.EVENT_FILTER_GUID
112: AND a.name = l_event_name
113: AND b.owner_tag = 'GMO'
114: AND b.status = 'DISABLED' ;

Line 166: WF_EVENT_SUBSCRIPTIONS_PKG.UPDATE_ROW(X_GUID => l_CBR_EVENT_SUBCRIPTIONS_REC.GUID

162: fnd_message.set_token('EVENT', l_EVENT_REC.DISPLAY_NAME);
163: fnd_file.put_line(fnd_file.output, fnd_message.get);
164: fnd_file.new_line(fnd_file.output, 2);
165:
166: WF_EVENT_SUBSCRIPTIONS_PKG.UPDATE_ROW(X_GUID => l_CBR_EVENT_SUBCRIPTIONS_REC.GUID
167: ,X_SYSTEM_GUID => l_CBR_EVENT_SUBCRIPTIONS_REC.SYSTEM_GUID
168: ,X_SOURCE_TYPE => l_CBR_EVENT_SUBCRIPTIONS_REC.SOURCE_TYPE
169: ,X_SOURCE_AGENT_GUID => l_CBR_EVENT_SUBCRIPTIONS_REC.SOURCE_AGENT_GUID
170: ,X_EVENT_FILTER_GUID => l_CBR_EVENT_SUBCRIPTIONS_REC.EVENT_FILTER_GUID

Line 207: WF_EVENT_SUBSCRIPTIONS_PKG.UPDATE_ROW(X_GUID => l_CBR_GMO_SUBCRIPTIONS_REC.GUID

203:
204: --
205: -- enable ERES Event subscriptions owned by GMO
206: --
207: WF_EVENT_SUBSCRIPTIONS_PKG.UPDATE_ROW(X_GUID => l_CBR_GMO_SUBCRIPTIONS_REC.GUID
208: ,X_SYSTEM_GUID => l_CBR_GMO_SUBCRIPTIONS_REC.SYSTEM_GUID
209: ,X_SOURCE_TYPE => l_CBR_GMO_SUBCRIPTIONS_REC.SOURCE_TYPE
210: ,X_SOURCE_AGENT_GUID => l_CBR_GMO_SUBCRIPTIONS_REC.SOURCE_AGENT_GUID
211: ,X_EVENT_FILTER_GUID => l_CBR_GMO_SUBCRIPTIONS_REC.EVENT_FILTER_GUID