eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMO_CBR_GRP dependencies on WF_EVENT

Line 26: wf_events_vl a,

22: ,a.CUSTOMIZATION_LEVEL
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:

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 66: wf_events_vl a,

62: ,b.JAVA_RULE_FUNC
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

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 109: wf_events_vl a,

105: ,b.JAVA_RULE_FUNC
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'

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 141: WF_EVENTS_PKG.UPDATE_ROW(X_GUID => l_EVENT_REC.GUID

137:
138: --
139: -- Enable ERES Event for Control Batch Recording
140: --
141: WF_EVENTS_PKG.UPDATE_ROW(X_GUID => l_EVENT_REC.GUID
142: ,X_NAME => l_EVENT_REC.NAME
143: ,X_TYPE => l_EVENT_REC.TYPE
144: ,X_STATUS => 'ENABLED'
145: ,X_GENERATE_FUNCTION => l_EVENT_REC.GENERATE_FUNCTION

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

Line 630: FUNCTION PROCESS_EVENT (P_SUBSCRIPTION_GUID IN RAW, P_EVENT IN OUT NOCOPY WF_EVENT_T) RETURN VARCHAR2 IS

626:
627:
628:
629:
630: FUNCTION PROCESS_EVENT (P_SUBSCRIPTION_GUID IN RAW, P_EVENT IN OUT NOCOPY WF_EVENT_T) RETURN VARCHAR2 IS
631: l_batch_prog_rec GMO_BATCH_PROGRESSION%ROWTYPE;
632: l_batch_progression_id NUMBER := NULL;
633: l_event_name varchar2(2000) := NULL;
634: l_event_key varchar2(2000) := NULL;

Line 702: l_user_key_label := wf_event.getValueForParameter('PSIG_USER_KEY_LABEL',p_event.Parameter_List);

698: -- Get parameters from ef_event structure for processing
699: --
700: l_event_name := p_event.getEventName();
701: l_event_key := p_event.getEventKey();
702: l_user_key_label := wf_event.getValueForParameter('PSIG_USER_KEY_LABEL',p_event.Parameter_List);
703: l_user_key_value := wf_event.getValueForParameter('PSIG_USER_KEY_VALUE',p_event.Parameter_List);
704: l_erecord_id := wf_event.getValueForParameter('#ERECORD_ID',p_event.Parameter_List);
705: l_map_code := wf_event.getValueForParameter('CBR_XML_MAP_CODE',p_event.Parameter_List);
706: l_compare_XML := nvl(wf_event.getValueForParameter('COMPARE_XML',p_event.Parameter_List),'Y');

Line 703: l_user_key_value := wf_event.getValueForParameter('PSIG_USER_KEY_VALUE',p_event.Parameter_List);

699: --
700: l_event_name := p_event.getEventName();
701: l_event_key := p_event.getEventKey();
702: l_user_key_label := wf_event.getValueForParameter('PSIG_USER_KEY_LABEL',p_event.Parameter_List);
703: l_user_key_value := wf_event.getValueForParameter('PSIG_USER_KEY_VALUE',p_event.Parameter_List);
704: l_erecord_id := wf_event.getValueForParameter('#ERECORD_ID',p_event.Parameter_List);
705: l_map_code := wf_event.getValueForParameter('CBR_XML_MAP_CODE',p_event.Parameter_List);
706: l_compare_XML := nvl(wf_event.getValueForParameter('COMPARE_XML',p_event.Parameter_List),'Y');
707:

Line 704: l_erecord_id := wf_event.getValueForParameter('#ERECORD_ID',p_event.Parameter_List);

700: l_event_name := p_event.getEventName();
701: l_event_key := p_event.getEventKey();
702: l_user_key_label := wf_event.getValueForParameter('PSIG_USER_KEY_LABEL',p_event.Parameter_List);
703: l_user_key_value := wf_event.getValueForParameter('PSIG_USER_KEY_VALUE',p_event.Parameter_List);
704: l_erecord_id := wf_event.getValueForParameter('#ERECORD_ID',p_event.Parameter_List);
705: l_map_code := wf_event.getValueForParameter('CBR_XML_MAP_CODE',p_event.Parameter_List);
706: l_compare_XML := nvl(wf_event.getValueForParameter('COMPARE_XML',p_event.Parameter_List),'Y');
707:
708: l_error_text := 'Event Name:'|| l_event_name || 'Event Key:'||l_event_key;

Line 705: l_map_code := wf_event.getValueForParameter('CBR_XML_MAP_CODE',p_event.Parameter_List);

701: l_event_key := p_event.getEventKey();
702: l_user_key_label := wf_event.getValueForParameter('PSIG_USER_KEY_LABEL',p_event.Parameter_List);
703: l_user_key_value := wf_event.getValueForParameter('PSIG_USER_KEY_VALUE',p_event.Parameter_List);
704: l_erecord_id := wf_event.getValueForParameter('#ERECORD_ID',p_event.Parameter_List);
705: l_map_code := wf_event.getValueForParameter('CBR_XML_MAP_CODE',p_event.Parameter_List);
706: l_compare_XML := nvl(wf_event.getValueForParameter('COMPARE_XML',p_event.Parameter_List),'Y');
707:
708: l_error_text := 'Event Name:'|| l_event_name || 'Event Key:'||l_event_key;
709: --Diagnostics Start

Line 706: l_compare_XML := nvl(wf_event.getValueForParameter('COMPARE_XML',p_event.Parameter_List),'Y');

702: l_user_key_label := wf_event.getValueForParameter('PSIG_USER_KEY_LABEL',p_event.Parameter_List);
703: l_user_key_value := wf_event.getValueForParameter('PSIG_USER_KEY_VALUE',p_event.Parameter_List);
704: l_erecord_id := wf_event.getValueForParameter('#ERECORD_ID',p_event.Parameter_List);
705: l_map_code := wf_event.getValueForParameter('CBR_XML_MAP_CODE',p_event.Parameter_List);
706: l_compare_XML := nvl(wf_event.getValueForParameter('COMPARE_XML',p_event.Parameter_List),'Y');
707:
708: l_error_text := 'Event Name:'|| l_event_name || 'Event Key:'||l_event_key;
709: --Diagnostics Start
710: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');

Line 1054: wf_event.AddParameterToList('BATCH_PROGRESSION_ID', l_batch_progression_id,p_event.Parameter_List);

1050: FALSE
1051: );
1052: end if;
1053: gmo_cbr_grp.insert_event(l_batch_prog_rec,l_batch_progression_id);
1054: wf_event.AddParameterToList('BATCH_PROGRESSION_ID', l_batch_progression_id,p_event.Parameter_List);
1055: return 'SUCCESS';
1056: END;
1057:
1058:

Line 1610: FUNCTION PROCESS_INSTANCE_INSTR_SET(P_SUBSCRIPTION_GUID IN RAW, P_EVENT IN OUT NOCOPY WF_EVENT_T) RETURN VARCHAR2 IS

1606: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.GMO_CBR_GRP.PROCESS_INSTR_XML', FALSE);
1607: end if;
1608: END PROCESS_INSTR_XML;
1609:
1610: FUNCTION PROCESS_INSTANCE_INSTR_SET(P_SUBSCRIPTION_GUID IN RAW, P_EVENT IN OUT NOCOPY WF_EVENT_T) RETURN VARCHAR2 IS
1611: l_xml_map_code varchar2(240);
1612: l_result XMLType;
1613: l_temp XMLType;
1614: l_entity_name VARCHAR2(200);

Line 1638: l_xml_map_code := NVL(wf_event.getValueForParameter('GMO_XML_MAP_CODE',p_event.Parameter_List),

1634:
1635: l_return_status:=wf_rule.setParametersIntoParameterList(p_subscription_guid,p_event);
1636: l_event_name:=p_event.getEventName();
1637: l_event_key:=p_event.getEventKey();
1638: l_xml_map_code := NVL(wf_event.getValueForParameter('GMO_XML_MAP_CODE',p_event.Parameter_List),
1639: P_EVENT.getEventName( ));
1640: -- Get the Instruction Set XML
1641: GET_INSTR_XML(l_event_key,l_xml_map_code,l_result);
1642: l_entity_name := getValue(l_result,'//ENTITY_NAME');