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';
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)
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:
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||'
Notification Message from WF_NOTIFICATION_IN | ' || s.NAME || ' | ' sys_name,' || a.status ||' | ' status
---|