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(80) := NULL;
634: l_event_key varchar2(80) := NULL;

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

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

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

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

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

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

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

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

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

701: l_user_key_label := wf_event.getValueForParameter('PSIG_USER_KEY_LABEL',p_event.Parameter_List);
702: l_user_key_value := wf_event.getValueForParameter('PSIG_USER_KEY_VALUE',p_event.Parameter_List);
703: l_erecord_id := wf_event.getValueForParameter('#ERECORD_ID',p_event.Parameter_List);
704: l_map_code := wf_event.getValueForParameter('CBR_XML_MAP_CODE',p_event.Parameter_List);
705: l_compare_XML := nvl(wf_event.getValueForParameter('COMPARE_XML',p_event.Parameter_List),'Y');
706:
707: --
708: -- process Oracle Quality Events
709: --

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

986: END IF;
987: l_batch_prog_rec.XML_MAP_CODE := l_map_code;
988: l_batch_prog_rec.compare_xml:=l_compare_XML;
989: gmo_cbr_grp.insert_event(l_batch_prog_rec,l_batch_progression_id);
990: wf_event.AddParameterToList('BATCH_PROGRESSION_ID', l_batch_progression_id,p_event.Parameter_List);
991: return 'SUCCESS';
992: END;
993:
994:

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

1542: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.GMO_CBR_GRP.PROCESS_INSTR_XML', FALSE);
1543: end if;
1544: END PROCESS_INSTR_XML;
1545:
1546: FUNCTION PROCESS_INSTANCE_INSTR_SET(P_SUBSCRIPTION_GUID IN RAW, P_EVENT IN OUT NOCOPY WF_EVENT_T) RETURN VARCHAR2 IS
1547: l_xml_map_code varchar2(240);
1548: l_result XMLType;
1549: l_temp XMLType;
1550: l_entity_name VARCHAR2(200);

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

1570:
1571: l_return_status:=wf_rule.setParametersIntoParameterList(p_subscription_guid,p_event);
1572: l_event_name:=p_event.getEventName();
1573: l_event_key:=p_event.getEventKey();
1574: l_xml_map_code := NVL(wf_event.getValueForParameter('GMO_XML_MAP_CODE',p_event.Parameter_List),
1575: P_EVENT.getEventName( ));
1576: -- Get the Instruction Set XML
1577: GET_INSTR_XML(l_event_key,l_xml_map_code,l_result);
1578: l_entity_name := getValue(l_result,'//ENTITY_NAME');