APPS.WF_DIAGNOSTICS dependencies on WF_NOTIFICATION_OUT

Line 32: WFD_NTF_OUT varchar2(30) := 'WF_NOTIFICATION_OUT';

28: -- Queue owner
29: g_qowner varchar2(30) := Wf_Core.Translate('WF_SCHEMA');
30:
31: -- Queue name constants
32: WFD_NTF_OUT varchar2(30) := 'WF_NOTIFICATION_OUT';
33: WFD_NTF_IN varchar2(30) := 'WF_NOTIFICATION_IN';
34: WFD_DEFERRED varchar2(30) := 'WF_DEFERRED';
35: WFD_ERROR varchar2(30) := 'WF_ERROR';
36: WFD_PROV_OUT varchar2(30) := 'WF_PROV_OUT';

Line 2363: -- Fetches the notification content from WF_NOTIFICATION_OUT queue

2359: end Get_Mailer_TOC;
2360:
2361: --
2362: -- Get_Ntf_Msg_From_Out
2363: -- Fetches the notification content from WF_NOTIFICATION_OUT queue
2364: --
2365: procedure Get_Ntf_Msg_From_Out(p_nid in varchar2,
2366: p_corr_id in varchar2,
2367: p_value in out nocopy clob)

Line 2377: from wf_notification_out nout

2373:
2374:
2375: cursor cout is
2376: select nout.user_data.text_lob lob
2377: from wf_notification_out nout
2378: where instr(nout.user_data.get_string_property('BES_EVENT_KEY'), p_nid) > 0
2379: and (p_corr_id is null or nout.corrid like p_corr_id)
2380: order by ENQ_TIME;
2381:

Line 2390: l_cells(1) := 'WH:Content from WF_NOTIFICATION_OUT';

2386: l_buffer varchar2(32767);
2387:
2388: begin
2389:
2390: l_cells(1) := 'WH:Content from WF_NOTIFICATION_OUT';
2391: Get_Table(l_cells, 1, 'H', l_result);
2392: l_cells.DELETE;
2393:
2394: l_result := l_result||'';

Line 2397: ' color='||th_fontcolor||'>Notification Message from WF_NOTIFICATION_OUT';

2393:
2394: l_result := l_result||'

';
2395: l_result := l_result||'';
2396: l_result := l_result||'';
2398:
2399: for l_lob_rec in cout loop
2400: l_doc := l_lob_rec.lob;
2401:

Line 2443: 'from WF_NOTIFICATION_OUT for nid '||p_nid;

2439: exception
2440: when others then
2441: l_cells(1) := '10%:Note';
2442: l_cells(2) := 'Error when fetching Notification Message ' ||
2443: 'from WF_NOTIFICATION_OUT for nid '||p_nid;
2444: l_cells(3) := '10%:Error';
2445: l_cells(4) := sqlerrm;
2446: Get_Table(l_cells, 2, 'V', l_result);
2447: dbms_lob.WriteAppend(p_value, length(l_result), l_result);

Line 2452: -- Fetches the notification content from WF_NOTIFICATION_OUT queue

2448: end Get_Ntf_Msg_From_Out;
2449:
2450: --
2451: -- Get_Ntf_Msg_From_Out
2452: -- Fetches the notification content from WF_NOTIFICATION_OUT queue
2453: --
2454: procedure Get_Ntf_Msg_From_Out(p_nid in number,
2455: p_value in out nocopy clob)
2456: is

Line 2469: -- Fetches the notification content from WF_NOTIFICATION_OUT queue

2465:
2466:
2467: --
2468: -- Get_Summary_Msg_From_Out
2469: -- Fetches the notification content from WF_NOTIFICATION_OUT queue
2470: --
2471: procedure Get_Summary_Msg_From_Out(p_role in varchar2,
2472: p_value in out nocopy clob)
2473: is

Line 2492: l_cells(1) := 'WH:Content from WF_NOTIFICATION_OUT AQ';

2488: l_offset pls_integer;
2489: l_buffer varchar2(32767);
2490:
2491: begin
2492: l_cells(1) := 'WH:Content from WF_NOTIFICATION_OUT AQ';
2493: Get_Table(l_cells, 1, 'H', l_result);
2494: l_cells.DELETE;
2495:
2496: l_result := l_result||'

Notification Message from WF_NOTIFICATION_OUT

';

Line 2500: ' WF_NOTIFICATION_OUT AQ ';

2496: l_result := l_result||'

';
2497: l_result := l_result||'';
2498: l_result := l_result||'';
2501: l_result := l_result||'

XML for Summary Message from ' || 2500: ' WF_NOTIFICATION_OUT AQ

';
2502:
2503: -- SQL string to get XML from wf_notification_out queue
2504: l_sql_str := ' select tab.user_data.text_lob '||

Line 2503: -- SQL string to get XML from wf_notification_out queue

2499: ' color='||th_fontcolor||'>XML for Summary Message from ' ||
2500: ' WF_NOTIFICATION_OUT AQ ';
2501: l_result := l_result||'';
2502:
2503: -- SQL string to get XML from wf_notification_out queue
2504: l_sql_str := ' select tab.user_data.text_lob '||
2505: ' from '||g_qowner||'.aq$wf_notification_out tab' ||
2506: ' where instr(tab.user_data.get_string_property(''ROLE_NAME''), :p1) > 0 ' ||
2507: ' order by tab.enq_time desc';

Line 2505: ' from '||g_qowner||'.aq$wf_notification_out tab' ||

2501: l_result := l_result||'';
2502:
2503: -- SQL string to get XML from wf_notification_out queue
2504: l_sql_str := ' select tab.user_data.text_lob '||
2505: ' from '||g_qowner||'.aq$wf_notification_out tab' ||
2506: ' where instr(tab.user_data.get_string_property(''ROLE_NAME''), :p1) > 0 ' ||
2507: ' order by tab.enq_time desc';
2508:
2509: open c_ntf_out for l_sql_str using p_role;

Line 2559: ' WF_NOTIFICATION_OUT for role '||p_role;

2555: exception
2556: when others then
2557: l_cells(1) := '10%:Note';
2558: l_cells(2) := 'Error when fetching Summary Ntf. Message from ' ||
2559: ' WF_NOTIFICATION_OUT for role '||p_role;
2560: l_cells(3) := '10%:Error';
2561: l_cells(4) := sqlerrm;
2562: Get_Table(l_cells, 2, 'V', l_result);
2563: dbms_lob.WriteAppend(p_value, length(l_result), l_result);

Line 2933: -- XML Message for the notification from WF_NOTIFICATION_OUT

2929: l_temp_result := 'Go to top
'||wf_core.newline;
2931: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
2932:
2933: -- XML Message for the notification from WF_NOTIFICATION_OUT
2934: l_temp_result := '
'||wf_core.newline;
2935: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
2936: Get_Ntf_Msg_From_Out(p_nid, l_value);
2937: l_temp_result := '

3113: ' ' || s.NAME || '' sys_name,
3114: ' ' || a.status ||'' status
3115: FROM WF_AGENTS a, WF_SYSTEMS s
3116: WHERE a.system_guid = s.guid
3117: AND a.name IN ('WF_CONTROL', 'WF_NOTIFICATION_IN', 'WF_NOTIFICATION_OUT',
3118: 'WF_DEFERRED', 'WF_ERROR');
3119:
3120: cursor c_sub is
3121: SELECT e.name EVENT_NAME,