DBA Data[Home] [Help]

APPS.WF_SYSTEMS_PKG dependencies on WF_EVENT

Line 40: wf_event.raise('oracle.apps.wf.event.system.create',x_guid);

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

Line 68: wf_event.raise('oracle.apps.wf.event.system.update',x_guid);

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);

Line 80: wf_event.raise('oracle.apps.wf.event.system.delete',x_guid);

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:

Line 155: l_root := wf_event_xml.newtag (l_doc, l_root, wf_event_xml.masterTagName);

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',

Line 156: l_header := wf_event_xml.newtag(l_doc, l_root, m_table_name);

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));

Line 157: l_node := wf_event_xml.newtag(l_doc, l_header, wf_event_xml.versionTagName,

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);

Line 159: l_node := wf_event_xml.newtag(l_doc, l_header, 'GUID',

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));

Line 161: l_node := wf_event_xml.newtag(l_doc, l_header, 'NAME', l_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));
164: l_node := wf_event_xml.newtag(l_doc, l_header, 'DISPLAY_NAME',
165: l_display_name);

Line 162: l_node := wf_event_xml.newtag(l_doc, l_header, 'MASTER_GUID',

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);

Line 164: l_node := wf_event_xml.newtag(l_doc, l_header, 'DISPLAY_NAME',

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);

Line 166: l_node := wf_event_xml.newtag(l_doc, l_header, 'DESCRIPTION', l_description);

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;

Line 197: l_message := WF_EVENT_SYNCHRONIZE_PKG.SetGUID(l_message); -- update #NEW

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);

Line 198: l_message := WF_EVENT_SYNCHRONIZE_PKG.SetSYSTEMGUID(l_message); -- update #LOCAL

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);

Line 199: l_message := WF_EVENT_SYNCHRONIZE_PKG.SetSID(l_message); -- update #SID

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:

Line 201: l_node_list := wf_event_xml.findTable(l_message, m_table_name);

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

Line 225: elsif(l_node_name = wf_event_xml.versionTagName) then

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);