2: /* $Header: WFOAMUTB.pls 120.3 2005/07/02 03:16:33 appldev noship $ */
3:
4: --
5: -- getWfEventTParameters
6: -- To convert the the parameter list in WF_EVENT_T to
7: -- string
8:
9: FUNCTION getWfEventTParameters(l_paramlist in wf_parameter_list_t)
10: RETURN VARCHAR2
30: -- Function wrapper around wf_event_ojmstext_qh.deserialize
31: --
32:
33: FUNCTION getWfEventT(l_aq_jms_text in sys.aq$_jms_text_message)
34: RETURN WF_EVENT_T
35: IS
36: l_wf_event_t wf_event_t;
37: l_jms sys.aq$_jms_text_message;
38: begin
32:
33: FUNCTION getWfEventT(l_aq_jms_text in sys.aq$_jms_text_message)
34: RETURN WF_EVENT_T
35: IS
36: l_wf_event_t wf_event_t;
37: l_jms sys.aq$_jms_text_message;
38: begin
39: l_jms := l_aq_jms_text;
40: wf_event_ojmstext_qh.deserialize(l_jms,l_wf_event_t);
36: l_wf_event_t wf_event_t;
37: l_jms sys.aq$_jms_text_message;
38: begin
39: l_jms := l_aq_jms_text;
40: wf_event_ojmstext_qh.deserialize(l_jms,l_wf_event_t);
41: return l_wf_event_t;
42: end getWfEventT;
43:
44: --
37: l_jms sys.aq$_jms_text_message;
38: begin
39: l_jms := l_aq_jms_text;
40: wf_event_ojmstext_qh.deserialize(l_jms,l_wf_event_t);
41: return l_wf_event_t;
42: end getWfEventT;
43:
44: --
45: -- getViewXMLURL
140: p_itemtype in varchar2,
141: p_itemkey in varchar2)
142: RETURN clob
143: IS
144: l_event_t wf_event_t;
145: l_eventdata clob;
146: begin
147:
148: l_event_t := wf_engine.GetItemAttrEvent(
163: IS
164: TYPE queue_contents_t IS REF CURSOR;
165: l_qcontents queue_contents_t;
166: l_sqlstmt varchar2(32000);
167: l_message wf_event_t;
168: l_eventdata clob;
169: begin
170:
171: -- Get the Clob