DBA Data[Home] [Help]

APPS.WF_EVENT_GROUPS_PKG dependencies on XMLDOM

Line 119: l_doc xmldom.DOMDocument;

115: X_GROUP_GUID in raw,
116: X_MEMBER_GUID in raw
117: ) return varchar2 is
118: buf varchar2(32000);
119: l_doc xmldom.DOMDocument;
120: l_element xmldom.DOMElement;
121: l_root xmldom.DOMNode;
122: l_node xmldom.DOMNode;
123: l_header xmldom.DOMNode;

Line 120: l_element xmldom.DOMElement;

116: X_MEMBER_GUID in raw
117: ) return varchar2 is
118: buf varchar2(32000);
119: l_doc xmldom.DOMDocument;
120: l_element xmldom.DOMElement;
121: l_root xmldom.DOMNode;
122: l_node xmldom.DOMNode;
123: l_header xmldom.DOMNode;
124:

Line 121: l_root xmldom.DOMNode;

117: ) return varchar2 is
118: buf varchar2(32000);
119: l_doc xmldom.DOMDocument;
120: l_element xmldom.DOMElement;
121: l_root xmldom.DOMNode;
122: l_node xmldom.DOMNode;
123: l_header xmldom.DOMNode;
124:
125: begin

Line 122: l_node xmldom.DOMNode;

118: buf varchar2(32000);
119: l_doc xmldom.DOMDocument;
120: l_element xmldom.DOMElement;
121: l_root xmldom.DOMNode;
122: l_node xmldom.DOMNode;
123: l_header xmldom.DOMNode;
124:
125: begin
126: -- select DISPLAY_NAME, DESCRIPTION

Line 123: l_header xmldom.DOMNode;

119: l_doc xmldom.DOMDocument;
120: l_element xmldom.DOMElement;
121: l_root xmldom.DOMNode;
122: l_node xmldom.DOMNode;
123: l_header xmldom.DOMNode;
124:
125: begin
126: -- select DISPLAY_NAME, DESCRIPTION
127: -- into l_display_name, l_description

Line 132: l_doc := xmldom.newDOMDocument;

128: -- from wf_event_groups
129: -- where group_guid = x_guid
130: -- and member_guid = x_member_guid;
131:
132: l_doc := xmldom.newDOMDocument;
133: l_root := xmldom.makeNode(l_doc);
134: l_root := wf_event_xml.newtag (l_doc, l_root, wf_event_xml.masterTagName);
135: l_header := wf_event_xml.newtag(l_doc, l_root, m_table_name);
136: l_node := wf_event_xml.newtag(l_doc, l_header, wf_event_xml.versionTagName,

Line 133: l_root := xmldom.makeNode(l_doc);

129: -- where group_guid = x_guid
130: -- and member_guid = x_member_guid;
131:
132: l_doc := xmldom.newDOMDocument;
133: l_root := xmldom.makeNode(l_doc);
134: l_root := wf_event_xml.newtag (l_doc, l_root, wf_event_xml.masterTagName);
135: l_header := wf_event_xml.newtag(l_doc, l_root, m_table_name);
136: l_node := wf_event_xml.newtag(l_doc, l_header, wf_event_xml.versionTagName,
137: m_package_version);

Line 143: xmldom.writeToBuffer(l_root, buf);

139: rawtohex(x_GROUP_GUID));
140: l_node := wf_event_xml.newtag(l_doc, l_header, 'MEMBER_GUID',
141: rawtohex(x_MEMBER_GUID));
142:
143: xmldom.writeToBuffer(l_root, buf);
144: return buf;
145:
146: null;
147: exception

Line 178: l_node xmldom.DOMNode;

174: l_version varchar2(80);
175: l_message varchar2(32000);
176:
177: l_node_name varchar2(255);
178: l_node xmldom.DOMNode;
179: l_child xmldom.DOMNode;
180: l_value varchar2(32000);
181: l_length integer;
182: l_node_list xmldom.DOMNodeList;

Line 179: l_child xmldom.DOMNode;

175: l_message varchar2(32000);
176:
177: l_node_name varchar2(255);
178: l_node xmldom.DOMNode;
179: l_child xmldom.DOMNode;
180: l_value varchar2(32000);
181: l_length integer;
182: l_node_list xmldom.DOMNodeList;
183:

Line 182: l_node_list xmldom.DOMNodeList;

178: l_node xmldom.DOMNode;
179: l_child xmldom.DOMNode;
180: l_value varchar2(32000);
181: l_length integer;
182: l_node_list xmldom.DOMNodeList;
183:
184: l_event_name varchar2(255);
185:
186: begin

Line 193: l_length := xmldom.getLength(l_node_list);

189: l_message := WF_EVENT_SYNCHRONIZE_PKG.SetSYSTEMGUID(l_message); -- update #LOCAL
190: l_message := WF_EVENT_SYNCHRONIZE_PKG.SetSID(l_message); -- update #SID
191:
192: l_node_list := wf_event_xml.findTable(l_message, m_table_name);
193: l_length := xmldom.getLength(l_node_list);
194:
195: -- loop through elements that we received.
196: for i in 0..l_length-1 loop
197: l_node := xmldom.item(l_node_list, i);

Line 197: l_node := xmldom.item(l_node_list, i);

193: l_length := xmldom.getLength(l_node_list);
194:
195: -- loop through elements that we received.
196: for i in 0..l_length-1 loop
197: l_node := xmldom.item(l_node_list, i);
198: l_node_name := xmldom.getNodeName(l_node);
199: if xmldom.hasChildNodes(l_node) then
200: l_child := xmldom.GetFirstChild(l_node);
201: l_value := xmldom.getNodevalue(l_child);

Line 198: l_node_name := xmldom.getNodeName(l_node);

194:
195: -- loop through elements that we received.
196: for i in 0..l_length-1 loop
197: l_node := xmldom.item(l_node_list, i);
198: l_node_name := xmldom.getNodeName(l_node);
199: if xmldom.hasChildNodes(l_node) then
200: l_child := xmldom.GetFirstChild(l_node);
201: l_value := xmldom.getNodevalue(l_child);
202: else

Line 199: if xmldom.hasChildNodes(l_node) then

195: -- loop through elements that we received.
196: for i in 0..l_length-1 loop
197: l_node := xmldom.item(l_node_list, i);
198: l_node_name := xmldom.getNodeName(l_node);
199: if xmldom.hasChildNodes(l_node) then
200: l_child := xmldom.GetFirstChild(l_node);
201: l_value := xmldom.getNodevalue(l_child);
202: else
203: l_value := NULL;

Line 200: l_child := xmldom.GetFirstChild(l_node);

196: for i in 0..l_length-1 loop
197: l_node := xmldom.item(l_node_list, i);
198: l_node_name := xmldom.getNodeName(l_node);
199: if xmldom.hasChildNodes(l_node) then
200: l_child := xmldom.GetFirstChild(l_node);
201: l_value := xmldom.getNodevalue(l_child);
202: else
203: l_value := NULL;
204: end if;

Line 201: l_value := xmldom.getNodevalue(l_child);

197: l_node := xmldom.item(l_node_list, i);
198: l_node_name := xmldom.getNodeName(l_node);
199: if xmldom.hasChildNodes(l_node) then
200: l_child := xmldom.GetFirstChild(l_node);
201: l_value := xmldom.getNodevalue(l_child);
202: else
203: l_value := NULL;
204: end if;
205:

Line 227: l_node := xmldom.item(l_node_list, j);

223: if(l_event_name is null) then
224:
225: -- loop through elements to get the event name
226: for j in i..l_length-1 loop
227: l_node := xmldom.item(l_node_list, j);
228: l_node_name := xmldom.getNodeName(l_node);
229:
230: if (l_node_name = 'MEMBER_NAME') then
231: if xmldom.hasChildNodes(l_node) then

Line 228: l_node_name := xmldom.getNodeName(l_node);

224:
225: -- loop through elements to get the event name
226: for j in i..l_length-1 loop
227: l_node := xmldom.item(l_node_list, j);
228: l_node_name := xmldom.getNodeName(l_node);
229:
230: if (l_node_name = 'MEMBER_NAME') then
231: if xmldom.hasChildNodes(l_node) then
232: l_child := xmldom.GetFirstChild(l_node);

Line 231: if xmldom.hasChildNodes(l_node) then

227: l_node := xmldom.item(l_node_list, j);
228: l_node_name := xmldom.getNodeName(l_node);
229:
230: if (l_node_name = 'MEMBER_NAME') then
231: if xmldom.hasChildNodes(l_node) then
232: l_child := xmldom.GetFirstChild(l_node);
233: l_event_name := xmldom.getNodevalue(l_child);
234: else
235: l_event_name := NULL;

Line 232: l_child := xmldom.GetFirstChild(l_node);

228: l_node_name := xmldom.getNodeName(l_node);
229:
230: if (l_node_name = 'MEMBER_NAME') then
231: if xmldom.hasChildNodes(l_node) then
232: l_child := xmldom.GetFirstChild(l_node);
233: l_event_name := xmldom.getNodevalue(l_child);
234: else
235: l_event_name := NULL;
236: end if;

Line 233: l_event_name := xmldom.getNodevalue(l_child);

229:
230: if (l_node_name = 'MEMBER_NAME') then
231: if xmldom.hasChildNodes(l_node) then
232: l_child := xmldom.GetFirstChild(l_node);
233: l_event_name := xmldom.getNodevalue(l_child);
234: else
235: l_event_name := NULL;
236: end if;
237: exit;

Line 288: l_doc xmldom.DOMDocument;

284: X_GROUP_NAME in varchar2,
285: X_MEMBER_NAME in varchar2
286: ) return varchar2 is
287: buf varchar2(32000);
288: l_doc xmldom.DOMDocument;
289: l_element xmldom.DOMElement;
290: l_root xmldom.DOMNode;
291: l_node xmldom.DOMNode;
292: l_header xmldom.DOMNode;

Line 289: l_element xmldom.DOMElement;

285: X_MEMBER_NAME in varchar2
286: ) return varchar2 is
287: buf varchar2(32000);
288: l_doc xmldom.DOMDocument;
289: l_element xmldom.DOMElement;
290: l_root xmldom.DOMNode;
291: l_node xmldom.DOMNode;
292: l_header xmldom.DOMNode;
293:

Line 290: l_root xmldom.DOMNode;

286: ) return varchar2 is
287: buf varchar2(32000);
288: l_doc xmldom.DOMDocument;
289: l_element xmldom.DOMElement;
290: l_root xmldom.DOMNode;
291: l_node xmldom.DOMNode;
292: l_header xmldom.DOMNode;
293:
294: begin

Line 291: l_node xmldom.DOMNode;

287: buf varchar2(32000);
288: l_doc xmldom.DOMDocument;
289: l_element xmldom.DOMElement;
290: l_root xmldom.DOMNode;
291: l_node xmldom.DOMNode;
292: l_header xmldom.DOMNode;
293:
294: begin
295:

Line 292: l_header xmldom.DOMNode;

288: l_doc xmldom.DOMDocument;
289: l_element xmldom.DOMElement;
290: l_root xmldom.DOMNode;
291: l_node xmldom.DOMNode;
292: l_header xmldom.DOMNode;
293:
294: begin
295:
296: l_doc := xmldom.newDOMDocument;

Line 296: l_doc := xmldom.newDOMDocument;

292: l_header xmldom.DOMNode;
293:
294: begin
295:
296: l_doc := xmldom.newDOMDocument;
297: l_root := xmldom.makeNode(l_doc);
298: l_root := wf_event_xml.newtag (l_doc, l_root, wf_event_xml.masterTagName);
299: l_header := wf_event_xml.newtag(l_doc, l_root, m_table_name);
300: l_node := wf_event_xml.newtag(l_doc, l_header, wf_event_xml.versionTagName,

Line 297: l_root := xmldom.makeNode(l_doc);

293:
294: begin
295:
296: l_doc := xmldom.newDOMDocument;
297: l_root := xmldom.makeNode(l_doc);
298: l_root := wf_event_xml.newtag (l_doc, l_root, wf_event_xml.masterTagName);
299: l_header := wf_event_xml.newtag(l_doc, l_root, m_table_name);
300: l_node := wf_event_xml.newtag(l_doc, l_header, wf_event_xml.versionTagName,
301: m_package_version);

Line 305: xmldom.writeToBuffer(l_root, buf);

301: m_package_version);
302: l_node := wf_event_xml.newtag(l_doc, l_header, 'GROUP_NAME', x_group_name);
303: l_node := wf_event_xml.newtag(l_doc, l_header, 'MEMBER_NAME', x_member_name);
304:
305: xmldom.writeToBuffer(l_root, buf);
306: return buf;
307:
308: null;
309: exception