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: begin
185: l_message := x_message;
186: l_message := WF_EVENT_SYNCHRONIZE_PKG.SetGUID(l_message); -- update #NEW

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

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

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

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

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

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

Line 197: if xmldom.hasChildNodes(l_node) then

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

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

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

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

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

Line 254: l_doc xmldom.DOMDocument;

250: X_GROUP_NAME in varchar2,
251: X_MEMBER_NAME in varchar2
252: ) return varchar2 is
253: buf varchar2(32000);
254: l_doc xmldom.DOMDocument;
255: l_element xmldom.DOMElement;
256: l_root xmldom.DOMNode;
257: l_node xmldom.DOMNode;
258: l_header xmldom.DOMNode;

Line 255: l_element xmldom.DOMElement;

251: X_MEMBER_NAME in varchar2
252: ) return varchar2 is
253: buf varchar2(32000);
254: l_doc xmldom.DOMDocument;
255: l_element xmldom.DOMElement;
256: l_root xmldom.DOMNode;
257: l_node xmldom.DOMNode;
258: l_header xmldom.DOMNode;
259:

Line 256: l_root xmldom.DOMNode;

252: ) return varchar2 is
253: buf varchar2(32000);
254: l_doc xmldom.DOMDocument;
255: l_element xmldom.DOMElement;
256: l_root xmldom.DOMNode;
257: l_node xmldom.DOMNode;
258: l_header xmldom.DOMNode;
259:
260: begin

Line 257: l_node xmldom.DOMNode;

253: buf varchar2(32000);
254: l_doc xmldom.DOMDocument;
255: l_element xmldom.DOMElement;
256: l_root xmldom.DOMNode;
257: l_node xmldom.DOMNode;
258: l_header xmldom.DOMNode;
259:
260: begin
261:

Line 258: l_header xmldom.DOMNode;

254: l_doc xmldom.DOMDocument;
255: l_element xmldom.DOMElement;
256: l_root xmldom.DOMNode;
257: l_node xmldom.DOMNode;
258: l_header xmldom.DOMNode;
259:
260: begin
261:
262: l_doc := xmldom.newDOMDocument;

Line 262: l_doc := xmldom.newDOMDocument;

258: l_header xmldom.DOMNode;
259:
260: begin
261:
262: l_doc := xmldom.newDOMDocument;
263: l_root := xmldom.makeNode(l_doc);
264: l_root := wf_event_xml.newtag (l_doc, l_root, wf_event_xml.masterTagName);
265: l_header := wf_event_xml.newtag(l_doc, l_root, m_table_name);
266: l_node := wf_event_xml.newtag(l_doc, l_header, wf_event_xml.versionTagName,

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

259:
260: begin
261:
262: l_doc := xmldom.newDOMDocument;
263: l_root := xmldom.makeNode(l_doc);
264: l_root := wf_event_xml.newtag (l_doc, l_root, wf_event_xml.masterTagName);
265: l_header := wf_event_xml.newtag(l_doc, l_root, m_table_name);
266: l_node := wf_event_xml.newtag(l_doc, l_header, wf_event_xml.versionTagName,
267: m_package_version);

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

267: m_package_version);
268: l_node := wf_event_xml.newtag(l_doc, l_header, 'GROUP_NAME', x_group_name);
269: l_node := wf_event_xml.newtag(l_doc, l_header, 'MEMBER_NAME', x_member_name);
270:
271: xmldom.writeToBuffer(l_root, buf);
272: return buf;
273:
274: null;
275: exception