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 2568: -- Fetches the notification content from WF_NOTIFICATION_IN queue

2564: end Get_Summary_Msg_From_Out;
2565:
2566: --
2567: -- Get_Ntf_Msg_From_In
2568: -- Fetches the notification content from WF_NOTIFICATION_IN queue
2569: --
2570: procedure Get_Ntf_Msg_From_In(p_nid in varchar2,
2571: p_corr_id in varchar2,
2572: p_value in out nocopy clob)

Line 2581: from wf_notification_in nin

2577: i pls_integer := 1;
2578:
2579: cursor cin is
2580: select nin.user_data.text_lob lob
2581: from wf_notification_in nin
2582: where instr(nin.user_data.get_string_property('BES_EVENT_KEY'), p_nid) > 0
2583: and (p_corr_id is null or upper(nin.corrid) like upper(p_corr_id))
2584: order by ENQ_TIME;
2585:

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

2589: l_offset pls_integer;
2590: l_buffer varchar2(32767);
2591:
2592: begin
2593: l_cells(1) := 'WH:Content from WF_NOTIFICATION_IN';
2594: Get_Table(l_cells, 1, 'H', l_result);
2595: l_cells.DELETE;
2596:
2597: l_result := l_result||'';

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

2596:
2597: l_result := l_result||'

';
2598: l_result := l_result||'';
2599: l_result := l_result||'';
2601:
2602: for l_lob_rec in cin loop
2603: l_doc := l_lob_rec.lob;
2604: if (i=1) then

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

2638:
2639: exception
2640: when others then
2641: l_cells(1) := '10%:Note';
2642: l_cells(2) := 'Error when fetching Notification Message from WF_NOTIFICATION_IN for nid '||p_nid;
2643: l_cells(3) := '10%:Error';
2644: l_cells(4) := sqlerrm;
2645: Get_Table(l_cells, 2, 'V', l_result);
2646: dbms_lob.WriteAppend(p_value, length(l_result), l_result);

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

2647: end Get_Ntf_Msg_From_In;
2648:
2649: --
2650: -- Get_Ntf_Msg_From_In
2651: -- Fetches the notification content from WF_NOTIFICATION_IN queue
2652: --
2653: procedure Get_Ntf_Msg_From_In(p_nid in number,
2654: p_value in out nocopy clob)
2655: is

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

2937: l_temp_result := 'Go to top
'||wf_core.newline;
2939: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
2940:
2941: -- XML Message for the notification from WF_NOTIFICATION_IN
2942: l_temp_result := '
'||wf_core.newline;
2943: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
2944: Get_Ntf_Msg_From_In(p_nid, l_value);
2945: l_temp_result := '

3113: '

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

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

4360:
4361: l_temp_result := '
'||wf_core.newline;
4362: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4363:
4364: -- XML Message for the notification from WF_NOTIFICATION_IN
4365: Get_Ntf_Msg_From_In(p_idstring, l_user || ':' || p_module || '%', l_value);
4366:
4367: l_temp_result := '
'||wf_core.newline;
4368: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);

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