DBA Data[Home] [Help]

APPS.WF_AGENT_GROUPS_PKG dependencies on WF_EVENT

Line 30: wf_event.raise('oracle.apps.wf.agent.group.create',x_group_guid||'/'||x_member_guid);

26: if (c%notfound) then
27: close c;
28: raise no_data_found;
29: else
30: wf_event.raise('oracle.apps.wf.agent.group.create',x_group_guid||'/'||x_member_guid);
31: end if;
32: close c;
33:
34: exception

Line 55: wf_event.raise('oracle.apps.wf.agent.group.update',x_group_guid||'/'||x_member_guid);

51:
52: if (sql%notfound) then
53: raise no_data_found;
54: else
55: wf_event.raise('oracle.apps.wf.agent.group.update',x_group_guid||'/'||x_member_guid);
56: end if;
57:
58: exception
59: when others then

Line 95: wf_event.raise('oracle.apps.wf.agent.group.delete',x_group_guid||'/'||x_member_guid);

91: X_GROUP_GUID in raw,
92: X_MEMBER_GUID in raw
93: ) is
94: begin
95: wf_event.raise('oracle.apps.wf.agent.group.delete',x_group_guid||'/'||x_member_guid);
96:
97: delete from wf_agent_groups
98: where group_guid = X_GROUP_GUID
99: and member_guid = X_MEMBER_GUID;

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

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

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

130:
131: l_doc := xmldom.newDOMDocument;
132: l_root := xmldom.makeNode(l_doc);
133: l_root := wf_event_xml.newtag (l_doc, l_root, wf_event_xml.masterTagName);
134: l_header := wf_event_xml.newtag(l_doc, l_root, m_table_name);
135: l_node := wf_event_xml.newtag(l_doc, l_header, wf_event_xml.versionTagName,
136: m_package_version);
137: l_node := wf_event_xml.newtag(l_doc, l_header, 'GROUP_GUID',
138: rawtohex(x_GROUP_GUID));

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

131: l_doc := xmldom.newDOMDocument;
132: l_root := xmldom.makeNode(l_doc);
133: l_root := wf_event_xml.newtag (l_doc, l_root, wf_event_xml.masterTagName);
134: l_header := wf_event_xml.newtag(l_doc, l_root, m_table_name);
135: l_node := wf_event_xml.newtag(l_doc, l_header, wf_event_xml.versionTagName,
136: m_package_version);
137: l_node := wf_event_xml.newtag(l_doc, l_header, 'GROUP_GUID',
138: rawtohex(x_GROUP_GUID));
139: l_node := wf_event_xml.newtag(l_doc, l_header, 'MEMBER_GUID',

Line 137: l_node := wf_event_xml.newtag(l_doc, l_header, 'GROUP_GUID',

133: l_root := wf_event_xml.newtag (l_doc, l_root, wf_event_xml.masterTagName);
134: l_header := wf_event_xml.newtag(l_doc, l_root, m_table_name);
135: l_node := wf_event_xml.newtag(l_doc, l_header, wf_event_xml.versionTagName,
136: m_package_version);
137: l_node := wf_event_xml.newtag(l_doc, l_header, 'GROUP_GUID',
138: rawtohex(x_GROUP_GUID));
139: l_node := wf_event_xml.newtag(l_doc, l_header, 'MEMBER_GUID',
140: rawtohex(x_MEMBER_GUID));
141:

Line 139: l_node := wf_event_xml.newtag(l_doc, l_header, 'MEMBER_GUID',

135: l_node := wf_event_xml.newtag(l_doc, l_header, wf_event_xml.versionTagName,
136: m_package_version);
137: l_node := wf_event_xml.newtag(l_doc, l_header, 'GROUP_GUID',
138: rawtohex(x_GROUP_GUID));
139: l_node := wf_event_xml.newtag(l_doc, l_header, 'MEMBER_GUID',
140: rawtohex(x_MEMBER_GUID));
141:
142: xmldom.writeToBuffer(l_root, buf);
143: return buf;

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

169: -- and member_guid = x_member_guid;
170:
171: l_doc := xmldom.newDOMDocument;
172: l_root := xmldom.makeNode(l_doc);
173: l_root := wf_event_xml.newtag (l_doc, l_root, wf_event_xml.masterTagName);
174: l_header := wf_event_xml.newtag(l_doc, l_root, m_table_name);
175: l_node := wf_event_xml.newtag(l_doc, l_header, wf_event_xml.versionTagName,
176: m_package_version);
177: l_node := wf_event_xml.newtag(l_doc, l_header, 'GROUP_NAME',

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

170:
171: l_doc := xmldom.newDOMDocument;
172: l_root := xmldom.makeNode(l_doc);
173: l_root := wf_event_xml.newtag (l_doc, l_root, wf_event_xml.masterTagName);
174: l_header := wf_event_xml.newtag(l_doc, l_root, m_table_name);
175: l_node := wf_event_xml.newtag(l_doc, l_header, wf_event_xml.versionTagName,
176: m_package_version);
177: l_node := wf_event_xml.newtag(l_doc, l_header, 'GROUP_NAME',
178: x_GROUP_GUID);

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

171: l_doc := xmldom.newDOMDocument;
172: l_root := xmldom.makeNode(l_doc);
173: l_root := wf_event_xml.newtag (l_doc, l_root, wf_event_xml.masterTagName);
174: l_header := wf_event_xml.newtag(l_doc, l_root, m_table_name);
175: l_node := wf_event_xml.newtag(l_doc, l_header, wf_event_xml.versionTagName,
176: m_package_version);
177: l_node := wf_event_xml.newtag(l_doc, l_header, 'GROUP_NAME',
178: x_GROUP_GUID);
179: l_node := wf_event_xml.newtag(l_doc, l_header, 'MEMBER_NAME',

Line 177: l_node := wf_event_xml.newtag(l_doc, l_header, 'GROUP_NAME',

173: l_root := wf_event_xml.newtag (l_doc, l_root, wf_event_xml.masterTagName);
174: l_header := wf_event_xml.newtag(l_doc, l_root, m_table_name);
175: l_node := wf_event_xml.newtag(l_doc, l_header, wf_event_xml.versionTagName,
176: m_package_version);
177: l_node := wf_event_xml.newtag(l_doc, l_header, 'GROUP_NAME',
178: x_GROUP_GUID);
179: l_node := wf_event_xml.newtag(l_doc, l_header, 'MEMBER_NAME',
180: x_MEMBER_GUID);
181:

Line 179: l_node := wf_event_xml.newtag(l_doc, l_header, 'MEMBER_NAME',

175: l_node := wf_event_xml.newtag(l_doc, l_header, wf_event_xml.versionTagName,
176: m_package_version);
177: l_node := wf_event_xml.newtag(l_doc, l_header, 'GROUP_NAME',
178: x_GROUP_GUID);
179: l_node := wf_event_xml.newtag(l_doc, l_header, 'MEMBER_NAME',
180: x_MEMBER_GUID);
181:
182: xmldom.writeToBuffer(l_root, buf);
183: return buf;

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

206: l_node_list xmldom.DOMNodeList;
207:
208: begin
209: l_message := x_message;
210: l_message := WF_EVENT_SYNCHRONIZE_PKG.SetGUID(l_message); -- update #NEW
211: l_message := WF_EVENT_SYNCHRONIZE_PKG.SetSYSTEMGUID(l_message); -- update #LOCAL
212: l_message := WF_EVENT_SYNCHRONIZE_PKG.SetSID(l_message); -- update #SID
213:
214: l_node_list := wf_event_xml.findTable(l_message, m_table_name);

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

207:
208: begin
209: l_message := x_message;
210: l_message := WF_EVENT_SYNCHRONIZE_PKG.SetGUID(l_message); -- update #NEW
211: l_message := WF_EVENT_SYNCHRONIZE_PKG.SetSYSTEMGUID(l_message); -- update #LOCAL
212: l_message := WF_EVENT_SYNCHRONIZE_PKG.SetSID(l_message); -- update #SID
213:
214: l_node_list := wf_event_xml.findTable(l_message, m_table_name);
215: l_length := xmldom.getLength(l_node_list);

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

208: begin
209: l_message := x_message;
210: l_message := WF_EVENT_SYNCHRONIZE_PKG.SetGUID(l_message); -- update #NEW
211: l_message := WF_EVENT_SYNCHRONIZE_PKG.SetSYSTEMGUID(l_message); -- update #LOCAL
212: l_message := WF_EVENT_SYNCHRONIZE_PKG.SetSID(l_message); -- update #SID
213:
214: l_node_list := wf_event_xml.findTable(l_message, m_table_name);
215: l_length := xmldom.getLength(l_node_list);
216:

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

210: l_message := WF_EVENT_SYNCHRONIZE_PKG.SetGUID(l_message); -- update #NEW
211: l_message := WF_EVENT_SYNCHRONIZE_PKG.SetSYSTEMGUID(l_message); -- update #LOCAL
212: l_message := WF_EVENT_SYNCHRONIZE_PKG.SetSID(l_message); -- update #SID
213:
214: l_node_list := wf_event_xml.findTable(l_message, m_table_name);
215: l_length := xmldom.getLength(l_node_list);
216:
217: -- loop through elements that we received.
218: for i in 0..l_length-1 loop

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

238: Select guid
239: into l_member_guid
240: from wf_agents
241: where name=l_value;
242: elsif(l_node_name = wf_event_xml.versionTagName) then
243: l_version := l_value;
244: else
245: Wf_Core.Token('REASON', 'Invalid column name found:' ||
246: l_node_name || ' with value:'||l_value);