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.WF_DIAGNOSTICS dependencies on WF_EVENT

Line 1280: l_event_t wf_event_t;

1276: l_temp varchar2(32767);
1277: l_cells tdType;
1278: i pls_integer;
1279: l_retention varchar2(40);
1280: l_event_t wf_event_t;
1281:
1282: type t_jmsq is ref cursor;
1283: c_jmsq t_jmsq;
1284:

Line 1316: wf_event_t.Initialize(l_event_t);

1312: l_cells(8) := 'Dequeue Time';
1313: i := 8;
1314:
1315:
1316: wf_event_t.Initialize(l_event_t);
1317:
1318: -- org
1319: open c_jmsq for 'select msg_id, corr_id, msg_state, consumer_name, queue, exception_queue, '||
1320: ' retry_count, enq_time, deq_time, user_data'||

Line 1332: wf_event_ojmstext_qh.deserialize(l_jmsq_rec.user_data, l_event_t);

1328:
1329: -- deserialize DOES NOT updates l_event_t.correlation_id field, so we have
1330: -- to use l_jmsq_rec.corr_id to compare
1331:
1332: wf_event_ojmstext_qh.deserialize(l_jmsq_rec.user_data, l_event_t);
1333:
1334:
1335:
1336: if ( (l_event_t.event_key like p_event_key) AND

Line 1952: l_evt wf_event_t;

1948: p_event_name varchar2(100);
1949: p_event_key varchar2(100);
1950: p_parameter_list wf_parameter_list_t;
1951: l_doc clob;
1952: l_evt wf_event_t;
1953: l_parameters wf_parameter_list_t;
1954: l_erragt wf_agent_t;
1955: l_role varchar2(320);
1956: l_msg_type varchar2(8);

Line 1989: wf_event.AddParameterToList('NOTIFICATION_ID', to_char(p_nid), l_parameters);

1985: when others then
1986: wf_core.context('WF_DIAGNOSTICS', 'Fetch Role', to_char(p_nid));
1987: raise;
1988: end;
1989: wf_event.AddParameterToList('NOTIFICATION_ID', to_char(p_nid), l_parameters);
1990: wf_event.AddParameterToList('ROLE', l_role, l_parameters);
1991: wf_event.AddParameterToList('GROUP_ID', to_char(p_nid), l_parameters);
1992: wf_event.addParameterToList('Q_CORRELATION_ID', l_msg_type, l_parameters);
1993:

Line 1990: wf_event.AddParameterToList('ROLE', l_role, l_parameters);

1986: wf_core.context('WF_DIAGNOSTICS', 'Fetch Role', to_char(p_nid));
1987: raise;
1988: end;
1989: wf_event.AddParameterToList('NOTIFICATION_ID', to_char(p_nid), l_parameters);
1990: wf_event.AddParameterToList('ROLE', l_role, l_parameters);
1991: wf_event.AddParameterToList('GROUP_ID', to_char(p_nid), l_parameters);
1992: wf_event.addParameterToList('Q_CORRELATION_ID', l_msg_type, l_parameters);
1993:
1994: dbms_lob.CreateTemporary(l_doc, false, dbms_lob.Call);

Line 1991: wf_event.AddParameterToList('GROUP_ID', to_char(p_nid), l_parameters);

1987: raise;
1988: end;
1989: wf_event.AddParameterToList('NOTIFICATION_ID', to_char(p_nid), l_parameters);
1990: wf_event.AddParameterToList('ROLE', l_role, l_parameters);
1991: wf_event.AddParameterToList('GROUP_ID', to_char(p_nid), l_parameters);
1992: wf_event.addParameterToList('Q_CORRELATION_ID', l_msg_type, l_parameters);
1993:
1994: dbms_lob.CreateTemporary(l_doc, false, dbms_lob.Call);
1995:

Line 1992: wf_event.addParameterToList('Q_CORRELATION_ID', l_msg_type, l_parameters);

1988: end;
1989: wf_event.AddParameterToList('NOTIFICATION_ID', to_char(p_nid), l_parameters);
1990: wf_event.AddParameterToList('ROLE', l_role, l_parameters);
1991: wf_event.AddParameterToList('GROUP_ID', to_char(p_nid), l_parameters);
1992: wf_event.addParameterToList('Q_CORRELATION_ID', l_msg_type, l_parameters);
1993:
1994: dbms_lob.CreateTemporary(l_doc, false, dbms_lob.Call);
1995:
1996: wf_mail.test_flag := TRUE;

Line 2061: l_evt wf_event_t;

2057: p_event_name varchar2(100);
2058: p_event_key varchar2(100);
2059: p_parameter_list wf_parameter_list_t;
2060: l_doc clob;
2061: l_evt wf_event_t;
2062: l_parameters wf_parameter_list_t;
2063: l_erragt wf_agent_t;
2064: l_role varchar2(320);
2065: l_msg_type varchar2(8);

Line 2090: wf_event.AddParameterToList('ROLE_NAME', p_role, l_parameters);

2086: l_result := l_result||'';
2087: l_result := l_result||'Notification Message in XML format';
2089:
2090: wf_event.AddParameterToList('ROLE_NAME', p_role, l_parameters);
2091: -- Set AQs correlation id to item type i.e. 'WFMAIL'
2092: wf_event.addParameterToList('Q_CORRELATION_ID', 'WFMAIL', l_parameters);
2093:
2094: -- wf_event.AddParameterToList('GROUP_ID', to_char(0), l_parameters);

Line 2092: wf_event.addParameterToList('Q_CORRELATION_ID', 'WFMAIL', l_parameters);

2088: ' color='||th_fontcolor||'>Notification Message in XML format';
2089:
2090: wf_event.AddParameterToList('ROLE_NAME', p_role, l_parameters);
2091: -- Set AQs correlation id to item type i.e. 'WFMAIL'
2092: wf_event.addParameterToList('Q_CORRELATION_ID', 'WFMAIL', l_parameters);
2093:
2094: -- wf_event.AddParameterToList('GROUP_ID', to_char(0), l_parameters);
2095: dbms_lob.CreateTemporary(l_doc, false, dbms_lob.Call);
2096:

Line 2094: -- wf_event.AddParameterToList('GROUP_ID', to_char(0), l_parameters);

2090: wf_event.AddParameterToList('ROLE_NAME', p_role, l_parameters);
2091: -- Set AQs correlation id to item type i.e. 'WFMAIL'
2092: wf_event.addParameterToList('Q_CORRELATION_ID', 'WFMAIL', l_parameters);
2093:
2094: -- wf_event.AddParameterToList('GROUP_ID', to_char(0), l_parameters);
2095: dbms_lob.CreateTemporary(l_doc, false, dbms_lob.Call);
2096:
2097: wf_mail.test_flag := TRUE;
2098:

Line 3480: FROM WF_EVENTS e, WF_SYSTEMS s, WF_EVENT_SUBSCRIPTIONS sub, WF_AGENTS oa, WF_SYSTEMS oas

3476: DECODE(sub.guid, NULL, 'Subscription Not Defined',
3477: DECODE(sub.out_agent_guid, NULL, 'Not Defined',
3478: oa.name || '@' || oas.name)) OUT_AGENT,
3479: sub.status STATUS
3480: FROM WF_EVENTS e, WF_SYSTEMS s, WF_EVENT_SUBSCRIPTIONS sub, WF_AGENTS oa, WF_SYSTEMS oas
3481: WHERE e.NAME IN ('oracle.apps.wf.notification.send.group',
3482: 'oracle.apps.fnd.cp.gsc.bes.control.group',
3483: 'oracle.apps.wf.notification.summary.send')
3484: AND e.guid = sub.event_filter_guid(+)

Line 3499: SELECT WF_EVENT.LOCAL_SYSTEM_NAME INTO l_sys_name FROM dual;

3495: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
3496:
3497: l_temp_result := '';
3498:
3499: SELECT WF_EVENT.LOCAL_SYSTEM_NAME INTO l_sys_name FROM dual;
3500:
3501: l_temp_result := l_temp_result || '';
3502:
3503: l_temp_result := l_temp_result || '

The local System Name is ' || l_sys_name || '
';

Line 4150: from wf_events

4146: customization_level cust_level,
4147: licensed_flag lic_flag
4148: into l_type, l_status, l_own_name, l_own_tag,
4149: l_gen_func, l_jgen_func, l_cust_level, l_lic_flag
4150: from wf_events
4151: where name = p_event_name;
4152:
4153: l_cells(9) := l_type;
4154: l_cells(10) := l_status;

Line 4177: l_subs_list wf_event_subs_tab;

4173: return varchar2
4174: is
4175: l_result varchar2(32000);
4176: l_temp varchar2(32000);
4177: l_subs_list wf_event_subs_tab;
4178:
4179: l_cells tdType;
4180: j pls_integer;
4181: l_agent_tmp varchar2(80);

Line 4388: from wf_events

4384:
4385: begin
4386: select null
4387: into l_dummy
4388: from wf_events
4389: where name = p_event_name;
4390: exception
4391: when NO_DATA_FOUND then
4392: l_cells(1) := 'WH: Event '||p_event_name||' has been purged and is not available in the Database.';