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 2603: -- Fetches the notification content from WF_NOTIFICATION_OUT queue

2599: end Get_Mailer_TOC;
2600:
2601: --
2602: -- Get_Ntf_Msg_From_Out
2603: -- Fetches the notification content from WF_NOTIFICATION_OUT queue
2604: --
2605: procedure Get_Ntf_Msg_From_Out(p_nid in varchar2,
2606: p_corr_id in varchar2,
2607: p_value in out nocopy clob)

Line 2617: from wf_notification_out nout

2613:
2614:
2615: cursor cout is
2616: select nout.user_data.text_lob lob
2617: from wf_notification_out nout
2618: where instr(nout.user_data.get_string_property('BES_EVENT_KEY'), p_nid) > 0
2619: and (p_corr_id is null or nout.corrid like p_corr_id)
2620: order by ENQ_TIME;
2621:

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

2626: l_buffer varchar2(32767);
2627:
2628: begin
2629:
2630: l_cells(1) := 'WH:Content from WF_NOTIFICATION_OUT';
2631: Get_Table(l_cells, 1, 'H', l_result);
2632: l_cells.DELETE;
2633:
2634: l_result := l_result||'';

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

2633:
2634: l_result := l_result||'

';
2635: l_result := l_result||'';
2636: l_result := l_result||'';
2638:
2639: for l_lob_rec in cout loop
2640: l_doc := l_lob_rec.lob;
2641:

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

2679: exception
2680: when others then
2681: l_cells(1) := '10%:Note';
2682: l_cells(2) := 'Error when fetching Notification Message ' ||
2683: 'from WF_NOTIFICATION_OUT for nid '||p_nid;
2684: l_cells(3) := '10%:Error';
2685: l_cells(4) := sqlerrm;
2686: Get_Table(l_cells, 2, 'V', l_result);
2687: dbms_lob.WriteAppend(p_value, length(l_result), l_result);

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

2688: end Get_Ntf_Msg_From_Out;
2689:
2690: --
2691: -- Get_Ntf_Msg_From_Out
2692: -- Fetches the notification content from WF_NOTIFICATION_OUT queue
2693: --
2694: procedure Get_Ntf_Msg_From_Out(p_nid in number,
2695: p_value in out nocopy clob)
2696: is

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

2705:
2706:
2707: --
2708: -- Get_Summary_Msg_From_Out
2709: -- Fetches the notification content from WF_NOTIFICATION_OUT queue
2710: --
2711: procedure Get_Summary_Msg_From_Out(p_role in varchar2,
2712: p_value in out nocopy clob)
2713: is

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

2728: l_offset pls_integer;
2729: l_buffer varchar2(32767);
2730:
2731: begin
2732: l_cells(1) := 'WH:Content from WF_NOTIFICATION_OUT AQ';
2733: Get_Table(l_cells, 1, 'H', l_result);
2734: l_cells.DELETE;
2735:
2736: l_result := l_result||'

Notification Message from WF_NOTIFICATION_OUT

';

Line 2740: ' WF_NOTIFICATION_OUT AQ ';

2736: l_result := l_result||'

';
2737: l_result := l_result||'';
2738: l_result := l_result||'';
2741: l_result := l_result||'

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

';
2742:
2743: -- SQL string to get XML from wf_notification_out queue
2744: l_sql_str := ' select tab.user_data.text_lob '||

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

2739: ' color='||th_fontcolor||'>XML for Summary Message from ' ||
2740: ' WF_NOTIFICATION_OUT AQ ';
2741: l_result := l_result||'';
2742:
2743: -- SQL string to get XML from wf_notification_out queue
2744: l_sql_str := ' select tab.user_data.text_lob '||
2745: ' from '||g_qowner||'.aq$wf_notification_out tab' ||
2746: ' where instr(tab.user_data.get_string_property(''ROLE_NAME''), :p1) > 0 ' ||
2747: ' order by tab.enq_time desc';

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

2741: l_result := l_result||'';
2742:
2743: -- SQL string to get XML from wf_notification_out queue
2744: l_sql_str := ' select tab.user_data.text_lob '||
2745: ' from '||g_qowner||'.aq$wf_notification_out tab' ||
2746: ' where instr(tab.user_data.get_string_property(''ROLE_NAME''), :p1) > 0 ' ||
2747: ' order by tab.enq_time desc';
2748:
2749: open c_ntf_out for l_sql_str using p_role;

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

2795: exception
2796: when others then
2797: l_cells(1) := '10%:Note';
2798: l_cells(2) := 'Error when fetching Summary Ntf. Message from ' ||
2799: ' WF_NOTIFICATION_OUT for role '||p_role;
2800: l_cells(3) := '10%:Error';
2801: l_cells(4) := sqlerrm;
2802: Get_Table(l_cells, 2, 'V', l_result);
2803: dbms_lob.WriteAppend(p_value, length(l_result), l_result);

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

3272: l_temp_result := 'Go to top
'||wf_core.newline;
3274: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
3275:
3276: -- XML Message for the notification from WF_NOTIFICATION_OUT
3277: l_temp_result := '
'||wf_core.newline;
3278: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
3279: Get_Ntf_Msg_From_Out(p_nid, l_value);
3280: l_temp_result := '

3464: ' ' || s.NAME || '' sys_name,
3465: ' ' || a.status ||'' status
3466: FROM WF_AGENTS a, WF_SYSTEMS s
3467: WHERE a.system_guid = s.guid
3468: AND a.name IN ('WF_CONTROL', 'WF_NOTIFICATION_IN', 'WF_NOTIFICATION_OUT',
3469: 'WF_DEFERRED', 'WF_ERROR');
3470:
3471: cursor c_sub is
3472: SELECT e.name EVENT_NAME,