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 1102: l_event_t wf_event_t;

1098: l_temp varchar2(32767);
1099: l_cells tdType;
1100: i pls_integer;
1101: l_retention varchar2(40);
1102: l_event_t wf_event_t;
1103:
1104: type t_jmsq is ref cursor;
1105: c_jmsq t_jmsq;
1106:

Line 1138: wf_event_t.Initialize(l_event_t);

1134: l_cells(8) := 'Dequeue Time';
1135: i := 8;
1136:
1137:
1138: wf_event_t.Initialize(l_event_t);
1139:
1140: -- org
1141: open c_jmsq for 'select msg_id, corr_id, msg_state, consumer_name, queue, exception_queue, '||
1142: ' retry_count, enq_time, deq_time, user_data'||

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

1150:
1151: -- deserialize DOES NOT updates l_event_t.correlation_id field, so we have
1152: -- to use l_jmsq_rec.corr_id to compare
1153:
1154: wf_event_ojmstext_qh.deserialize(l_jmsq_rec.user_data, l_event_t);
1155:
1156:
1157:
1158: if ( (l_event_t.event_key like p_event_key) AND

Line 1765: l_evt wf_event_t;

1761: p_event_name varchar2(100);
1762: p_event_key varchar2(100);
1763: p_parameter_list wf_parameter_list_t;
1764: l_doc clob;
1765: l_evt wf_event_t;
1766: l_parameters wf_parameter_list_t;
1767: l_erragt wf_agent_t;
1768: l_role varchar2(320);
1769: l_msg_type varchar2(8);

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

1798: when others then
1799: wf_core.context('WF_DIAGNOSTICS', 'Fetch Role', to_char(p_nid));
1800: raise;
1801: end;
1802: wf_event.AddParameterToList('NOTIFICATION_ID', to_char(p_nid), l_parameters);
1803: wf_event.AddParameterToList('ROLE', l_role, l_parameters);
1804: wf_event.AddParameterToList('GROUP_ID', to_char(p_nid), l_parameters);
1805: wf_event.addParameterToList('Q_CORRELATION_ID', l_msg_type, l_parameters);
1806:

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

1799: wf_core.context('WF_DIAGNOSTICS', 'Fetch Role', to_char(p_nid));
1800: raise;
1801: end;
1802: wf_event.AddParameterToList('NOTIFICATION_ID', to_char(p_nid), l_parameters);
1803: wf_event.AddParameterToList('ROLE', l_role, l_parameters);
1804: wf_event.AddParameterToList('GROUP_ID', to_char(p_nid), l_parameters);
1805: wf_event.addParameterToList('Q_CORRELATION_ID', l_msg_type, l_parameters);
1806:
1807: dbms_lob.CreateTemporary(l_doc, false, dbms_lob.Call);

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

1800: raise;
1801: end;
1802: wf_event.AddParameterToList('NOTIFICATION_ID', to_char(p_nid), l_parameters);
1803: wf_event.AddParameterToList('ROLE', l_role, l_parameters);
1804: wf_event.AddParameterToList('GROUP_ID', to_char(p_nid), l_parameters);
1805: wf_event.addParameterToList('Q_CORRELATION_ID', l_msg_type, l_parameters);
1806:
1807: dbms_lob.CreateTemporary(l_doc, false, dbms_lob.Call);
1808:

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

1801: end;
1802: wf_event.AddParameterToList('NOTIFICATION_ID', to_char(p_nid), l_parameters);
1803: wf_event.AddParameterToList('ROLE', l_role, l_parameters);
1804: wf_event.AddParameterToList('GROUP_ID', to_char(p_nid), l_parameters);
1805: wf_event.addParameterToList('Q_CORRELATION_ID', l_msg_type, l_parameters);
1806:
1807: dbms_lob.CreateTemporary(l_doc, false, dbms_lob.Call);
1808:
1809: wf_mail.test_flag := TRUE;

Line 1874: l_evt wf_event_t;

1870: p_event_name varchar2(100);
1871: p_event_key varchar2(100);
1872: p_parameter_list wf_parameter_list_t;
1873: l_doc clob;
1874: l_evt wf_event_t;
1875: l_parameters wf_parameter_list_t;
1876: l_erragt wf_agent_t;
1877: l_role varchar2(320);
1878: l_msg_type varchar2(8);

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

1899: l_result := l_result||'';
1900: l_result := l_result||'Notification Message in XML format';
1902:
1903: wf_event.AddParameterToList('ROLE_NAME', p_role, l_parameters);
1904: -- Set AQs correlation id to item type i.e. 'WFMAIL'
1905: wf_event.addParameterToList('Q_CORRELATION_ID', 'WFMAIL', l_parameters);
1906:
1907: -- wf_event.AddParameterToList('GROUP_ID', to_char(0), l_parameters);

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

1901: ' color='||th_fontcolor||'>Notification Message in XML format';
1902:
1903: wf_event.AddParameterToList('ROLE_NAME', p_role, l_parameters);
1904: -- Set AQs correlation id to item type i.e. 'WFMAIL'
1905: wf_event.addParameterToList('Q_CORRELATION_ID', 'WFMAIL', l_parameters);
1906:
1907: -- wf_event.AddParameterToList('GROUP_ID', to_char(0), l_parameters);
1908: dbms_lob.CreateTemporary(l_doc, false, dbms_lob.Call);
1909:

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

1903: wf_event.AddParameterToList('ROLE_NAME', p_role, l_parameters);
1904: -- Set AQs correlation id to item type i.e. 'WFMAIL'
1905: wf_event.addParameterToList('Q_CORRELATION_ID', 'WFMAIL', l_parameters);
1906:
1907: -- wf_event.AddParameterToList('GROUP_ID', to_char(0), l_parameters);
1908: dbms_lob.CreateTemporary(l_doc, false, dbms_lob.Call);
1909:
1910: wf_mail.test_flag := TRUE;
1911:

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

3125: DECODE(sub.guid, NULL, 'Subscription Not Defined',
3126: DECODE(sub.out_agent_guid, NULL, 'Not Defined',
3127: oa.name || '@' || oas.name)) OUT_AGENT,
3128: sub.status STATUS
3129: FROM WF_EVENTS e, WF_SYSTEMS s, WF_EVENT_SUBSCRIPTIONS sub, WF_AGENTS oa, WF_SYSTEMS oas
3130: WHERE e.NAME IN ('oracle.apps.wf.notification.send.group',
3131: 'oracle.apps.fnd.cp.gsc.bes.control.group',
3132: 'oracle.apps.wf.notification.summary.send')
3133: AND e.guid = sub.event_filter_guid(+)

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

3144: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
3145:
3146: l_temp_result := '';
3147:
3148: SELECT WF_EVENT.LOCAL_SYSTEM_NAME INTO l_sys_name FROM dual;
3149:
3150: l_temp_result := l_temp_result || '';
3151:
3152: l_temp_result := l_temp_result || '

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

Line 3799: from wf_events

3795: customization_level cust_level,
3796: licensed_flag lic_flag
3797: into l_type, l_status, l_own_name, l_own_tag,
3798: l_gen_func, l_jgen_func, l_cust_level, l_lic_flag
3799: from wf_events
3800: where name = p_event_name;
3801:
3802: l_cells(9) := l_type;
3803: l_cells(10) := l_status;

Line 3826: l_subs_list wf_event_subs_tab;

3822: return varchar2
3823: is
3824: l_result varchar2(32000);
3825: l_temp varchar2(32000);
3826: l_subs_list wf_event_subs_tab;
3827:
3828: l_cells tdType;
3829: j pls_integer;
3830: l_agent_tmp varchar2(80);

Line 4037: from wf_events

4033:
4034: begin
4035: select null
4036: into l_dummy
4037: from wf_events
4038: where name = p_event_name;
4039: exception
4040: when NO_DATA_FOUND then
4041: l_cells(1) := 'WH: Event '||p_event_name||' has been purged and is not available in the Database.';