36: if (c%notfound) then
37: close c;
38: raise no_data_found;
39: else
40: wf_event.raise('oracle.apps.wf.event.system.create',x_guid);
41: end if;
42: close c;
43: exception
44: when others then
64:
65: if (sql%notfound) then
66: raise no_data_found;
67: else
68: wf_event.raise('oracle.apps.wf.event.system.update',x_guid);
69: end if;
70: exception
71: when others then
72: wf_core.context('Wf_Systems_Pkg', 'Update_row', x_guid, x_name);
76: procedure DELETE_ROW (
77: X_GUID in raw
78: ) is
79: begin
80: wf_event.raise('oracle.apps.wf.event.system.delete',x_guid);
81:
82: delete from wf_systems
83: where guid = X_GUID;
84:
151: where guid = x_guid;
152:
153: l_doc := xmldom.newDOMDocument;
154: l_root := xmldom.makeNode(l_doc);
155: l_root := wf_event_xml.newtag (l_doc, l_root, wf_event_xml.masterTagName);
156: l_header := wf_event_xml.newtag(l_doc, l_root, m_table_name);
157: l_node := wf_event_xml.newtag(l_doc, l_header, wf_event_xml.versionTagName,
158: m_package_version);
159: l_node := wf_event_xml.newtag(l_doc, l_header, 'GUID',
152:
153: l_doc := xmldom.newDOMDocument;
154: l_root := xmldom.makeNode(l_doc);
155: l_root := wf_event_xml.newtag (l_doc, l_root, wf_event_xml.masterTagName);
156: l_header := wf_event_xml.newtag(l_doc, l_root, m_table_name);
157: l_node := wf_event_xml.newtag(l_doc, l_header, wf_event_xml.versionTagName,
158: m_package_version);
159: l_node := wf_event_xml.newtag(l_doc, l_header, 'GUID',
160: rawtohex(x_guid));
153: l_doc := xmldom.newDOMDocument;
154: l_root := xmldom.makeNode(l_doc);
155: l_root := wf_event_xml.newtag (l_doc, l_root, wf_event_xml.masterTagName);
156: l_header := wf_event_xml.newtag(l_doc, l_root, m_table_name);
157: l_node := wf_event_xml.newtag(l_doc, l_header, wf_event_xml.versionTagName,
158: m_package_version);
159: l_node := wf_event_xml.newtag(l_doc, l_header, 'GUID',
160: rawtohex(x_guid));
161: l_node := wf_event_xml.newtag(l_doc, l_header, 'NAME', l_name);
155: l_root := wf_event_xml.newtag (l_doc, l_root, wf_event_xml.masterTagName);
156: l_header := wf_event_xml.newtag(l_doc, l_root, m_table_name);
157: l_node := wf_event_xml.newtag(l_doc, l_header, wf_event_xml.versionTagName,
158: m_package_version);
159: l_node := wf_event_xml.newtag(l_doc, l_header, 'GUID',
160: rawtohex(x_guid));
161: l_node := wf_event_xml.newtag(l_doc, l_header, 'NAME', l_name);
162: l_node := wf_event_xml.newtag(l_doc, l_header, 'MASTER_GUID',
163: rawtohex(l_master_guid));
157: l_node := wf_event_xml.newtag(l_doc, l_header, wf_event_xml.versionTagName,
158: m_package_version);
159: l_node := wf_event_xml.newtag(l_doc, l_header, 'GUID',
160: rawtohex(x_guid));
161: l_node := wf_event_xml.newtag(l_doc, l_header, 'NAME', l_name);
162: l_node := wf_event_xml.newtag(l_doc, l_header, 'MASTER_GUID',
163: rawtohex(l_master_guid));
164: l_node := wf_event_xml.newtag(l_doc, l_header, 'DISPLAY_NAME',
165: l_display_name);
158: m_package_version);
159: l_node := wf_event_xml.newtag(l_doc, l_header, 'GUID',
160: rawtohex(x_guid));
161: l_node := wf_event_xml.newtag(l_doc, l_header, 'NAME', l_name);
162: l_node := wf_event_xml.newtag(l_doc, l_header, 'MASTER_GUID',
163: rawtohex(l_master_guid));
164: l_node := wf_event_xml.newtag(l_doc, l_header, 'DISPLAY_NAME',
165: l_display_name);
166: l_node := wf_event_xml.newtag(l_doc, l_header, 'DESCRIPTION', l_description);
160: rawtohex(x_guid));
161: l_node := wf_event_xml.newtag(l_doc, l_header, 'NAME', l_name);
162: l_node := wf_event_xml.newtag(l_doc, l_header, 'MASTER_GUID',
163: rawtohex(l_master_guid));
164: l_node := wf_event_xml.newtag(l_doc, l_header, 'DISPLAY_NAME',
165: l_display_name);
166: l_node := wf_event_xml.newtag(l_doc, l_header, 'DESCRIPTION', l_description);
167:
168: xmldom.writeToBuffer(l_root, buf);
162: l_node := wf_event_xml.newtag(l_doc, l_header, 'MASTER_GUID',
163: rawtohex(l_master_guid));
164: l_node := wf_event_xml.newtag(l_doc, l_header, 'DISPLAY_NAME',
165: l_display_name);
166: l_node := wf_event_xml.newtag(l_doc, l_header, 'DESCRIPTION', l_description);
167:
168: xmldom.writeToBuffer(l_root, buf);
169:
170: return buf;
193: l_node_list xmldom.DOMNodeList;
194: begin
195:
196: l_message := x_message;
197: l_message := WF_EVENT_SYNCHRONIZE_PKG.SetGUID(l_message); -- update #NEW
198: l_message := WF_EVENT_SYNCHRONIZE_PKG.SetSYSTEMGUID(l_message); -- update #LOCAL
199: l_message := WF_EVENT_SYNCHRONIZE_PKG.SetSID(l_message); -- update #SID
200:
201: l_node_list := wf_event_xml.findTable(l_message, m_table_name);
194: begin
195:
196: l_message := x_message;
197: l_message := WF_EVENT_SYNCHRONIZE_PKG.SetGUID(l_message); -- update #NEW
198: l_message := WF_EVENT_SYNCHRONIZE_PKG.SetSYSTEMGUID(l_message); -- update #LOCAL
199: l_message := WF_EVENT_SYNCHRONIZE_PKG.SetSID(l_message); -- update #SID
200:
201: l_node_list := wf_event_xml.findTable(l_message, m_table_name);
202: l_length := xmldom.getLength(l_node_list);
195:
196: l_message := x_message;
197: l_message := WF_EVENT_SYNCHRONIZE_PKG.SetGUID(l_message); -- update #NEW
198: l_message := WF_EVENT_SYNCHRONIZE_PKG.SetSYSTEMGUID(l_message); -- update #LOCAL
199: l_message := WF_EVENT_SYNCHRONIZE_PKG.SetSID(l_message); -- update #SID
200:
201: l_node_list := wf_event_xml.findTable(l_message, m_table_name);
202: l_length := xmldom.getLength(l_node_list);
203:
197: l_message := WF_EVENT_SYNCHRONIZE_PKG.SetGUID(l_message); -- update #NEW
198: l_message := WF_EVENT_SYNCHRONIZE_PKG.SetSYSTEMGUID(l_message); -- update #LOCAL
199: l_message := WF_EVENT_SYNCHRONIZE_PKG.SetSID(l_message); -- update #SID
200:
201: l_node_list := wf_event_xml.findTable(l_message, m_table_name);
202: l_length := xmldom.getLength(l_node_list);
203:
204: -- loop through elements that we received.
205: for i in 0..l_length-1 loop
221: elsif(l_node_name = 'DISPLAY_NAME') then
222: l_display_name := l_value;
223: elsif(l_node_name = 'DESCRIPTION') then
224: l_description := l_value;
225: elsif(l_node_name = wf_event_xml.versionTagName) then
226: l_version := l_value;
227: else
228: Wf_Core.Token('REASON', 'Invalid column name found:' ||
229: l_node_name || ' with value:'||l_value);