APPS.WF_DIAGNOSTICS dependencies on WF_NOTIFICATION_IN

Line 33: WFD_NTF_IN varchar2(30) := 'WF_NOTIFICATION_IN';

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';
37: WFD_PROV_IN varchar2(30) := 'WF_PROV_IN';

Line 2808: -- Fetches the notification content from WF_NOTIFICATION_IN queue

2804: end Get_Summary_Msg_From_Out;
2805:
2806: --
2807: -- Get_Ntf_Msg_From_In
2808: -- Fetches the notification content from WF_NOTIFICATION_IN queue
2809: --
2810: procedure Get_Ntf_Msg_From_In(p_nid in varchar2,
2811: p_corr_id in varchar2,
2812: p_value in out nocopy clob)

Line 2821: from wf_notification_in nin

2817: i pls_integer := 1;
2818:
2819: cursor cin is
2820: select nin.user_data.text_lob lob
2821: from wf_notification_in nin
2822: where instr(nin.user_data.get_string_property('BES_EVENT_KEY'), p_nid) > 0
2823: and (p_corr_id is null or upper(nin.corrid) like upper(p_corr_id))
2824: order by ENQ_TIME;
2825:

Line 2833: l_cells(1) := 'WH:Content from WF_NOTIFICATION_IN';

2829: l_offset pls_integer;
2830: l_buffer varchar2(32767);
2831:
2832: begin
2833: l_cells(1) := 'WH:Content from WF_NOTIFICATION_IN';
2834: Get_Table(l_cells, 1, 'H', l_result);
2835: l_cells.DELETE;
2836:
2837: l_result := l_result||'';

Line 2840: ' color='||th_fontcolor||'>Notification Message from WF_NOTIFICATION_IN';

2836:
2837: l_result := l_result||'

';
2838: l_result := l_result||'';
2839: l_result := l_result||'';
2841:
2842: for l_lob_rec in cin loop
2843: l_doc := l_lob_rec.lob;
2844: if (i=1) then

Line 2882: l_cells(2) := 'Error when fetching Notification Message from WF_NOTIFICATION_IN for nid '||p_nid;

2878:
2879: exception
2880: when others then
2881: l_cells(1) := '10%:Note';
2882: l_cells(2) := 'Error when fetching Notification Message from WF_NOTIFICATION_IN for nid '||p_nid;
2883: l_cells(3) := '10%:Error';
2884: l_cells(4) := sqlerrm;
2885: Get_Table(l_cells, 2, 'V', l_result);
2886: dbms_lob.WriteAppend(p_value, length(l_result), l_result);

Line 2891: -- Fetches the notification content from WF_NOTIFICATION_IN queue

2887: end Get_Ntf_Msg_From_In;
2888:
2889: --
2890: -- Get_Ntf_Msg_From_In
2891: -- Fetches the notification content from WF_NOTIFICATION_IN queue
2892: --
2893: procedure Get_Ntf_Msg_From_In(p_nid in number,
2894: p_value in out nocopy clob)
2895: is

Line 3284: -- XML Message for the notification from WF_NOTIFICATION_IN

3280: l_temp_result := 'Go to top
'||wf_core.newline;
3282: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
3283:
3284: -- XML Message for the notification from WF_NOTIFICATION_IN
3285: l_temp_result := '
'||wf_core.newline;
3286: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
3287: Get_Ntf_Msg_From_In(p_nid, l_value);
3288: l_temp_result := '

3464: '

' sys_name,
3465: '' 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,

Line 4715: -- XML Message for the notification from WF_NOTIFICATION_IN

4711:
4712: l_temp_result := '
'||wf_core.newline;
4713: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4714:
4715: -- XML Message for the notification from WF_NOTIFICATION_IN
4716: Get_Ntf_Msg_From_In(p_idstring, l_user || ':' || p_module || '%', l_value);
4717:
4718: l_temp_result := '
'||wf_core.newline;
4719: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);

Notification Message from WF_NOTIFICATION_IN
' || s.NAME || '	' || a.status ||'