DBA Data[Home] [Help]

APPS.WF_AGENTS_PKG dependencies on WF_EVENT

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

56: if (c%notfound) then
57: close c;
58: raise no_data_found;
59: else
60: wf_event.raise('oracle.apps.wf.event.agent.create',x_guid);
61: end if;
62: close c;
63:
64: exception

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

117:
118: if (sql%notfound) then
119: raise no_data_found;
120: else
121: wf_event.raise('oracle.apps.wf.event.agent.update',x_guid);
122: end if;
123:
124: exception
125: when others then

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

230: procedure DELETE_ROW (
231: X_GUID in raw
232: ) is
233: begin
234: wf_event.raise('oracle.apps.wf.event.agent.delete',x_guid);
235:
236: delete from wf_agents where guid = X_GUID;
237:
238: if (sql%notfound) then

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

281: where guid = x_guid;
282:
283: l_doc := xmldom.newDOMDocument;
284: l_root := xmldom.makeNode(l_doc);
285: l_root := wf_event_xml.newtag(l_doc, l_root, wf_event_xml.masterTagName);
286: l_header := wf_event_xml.newtag(l_doc, l_root, m_table_name);
287:
288: l_node := wf_event_xml.newtag(l_doc, l_header, wf_event_xml.versionTagName,
289: m_package_version);

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

282:
283: l_doc := xmldom.newDOMDocument;
284: l_root := xmldom.makeNode(l_doc);
285: l_root := wf_event_xml.newtag(l_doc, l_root, wf_event_xml.masterTagName);
286: l_header := wf_event_xml.newtag(l_doc, l_root, m_table_name);
287:
288: l_node := wf_event_xml.newtag(l_doc, l_header, wf_event_xml.versionTagName,
289: m_package_version);
290: l_node := wf_event_xml.newtag(l_doc, l_header, 'GUID',

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

284: l_root := xmldom.makeNode(l_doc);
285: l_root := wf_event_xml.newtag(l_doc, l_root, wf_event_xml.masterTagName);
286: l_header := wf_event_xml.newtag(l_doc, l_root, m_table_name);
287:
288: l_node := wf_event_xml.newtag(l_doc, l_header, wf_event_xml.versionTagName,
289: m_package_version);
290: l_node := wf_event_xml.newtag(l_doc, l_header, 'GUID',
291: rawtohex(x_guid));
292: l_node := wf_event_xml.newtag(l_doc, l_header, 'NAME',

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

286: l_header := wf_event_xml.newtag(l_doc, l_root, m_table_name);
287:
288: l_node := wf_event_xml.newtag(l_doc, l_header, wf_event_xml.versionTagName,
289: m_package_version);
290: l_node := wf_event_xml.newtag(l_doc, l_header, 'GUID',
291: rawtohex(x_guid));
292: l_node := wf_event_xml.newtag(l_doc, l_header, 'NAME',
293: l_name);
294: l_node := wf_event_xml.newtag(l_doc, l_header, 'SYSTEM_GUID',

Line 292: l_node := wf_event_xml.newtag(l_doc, l_header, 'NAME',

288: l_node := wf_event_xml.newtag(l_doc, l_header, wf_event_xml.versionTagName,
289: m_package_version);
290: l_node := wf_event_xml.newtag(l_doc, l_header, 'GUID',
291: rawtohex(x_guid));
292: l_node := wf_event_xml.newtag(l_doc, l_header, 'NAME',
293: l_name);
294: l_node := wf_event_xml.newtag(l_doc, l_header, 'SYSTEM_GUID',
295: rawtohex(l_system_guid));
296: l_node := wf_event_xml.newtag(l_doc, l_header, 'PROTOCOL',

Line 294: l_node := wf_event_xml.newtag(l_doc, l_header, 'SYSTEM_GUID',

290: l_node := wf_event_xml.newtag(l_doc, l_header, 'GUID',
291: rawtohex(x_guid));
292: l_node := wf_event_xml.newtag(l_doc, l_header, 'NAME',
293: l_name);
294: l_node := wf_event_xml.newtag(l_doc, l_header, 'SYSTEM_GUID',
295: rawtohex(l_system_guid));
296: l_node := wf_event_xml.newtag(l_doc, l_header, 'PROTOCOL',
297: l_protocol);
298: l_node := wf_event_xml.newtag(l_doc, l_header, 'ADDRESS',

Line 296: l_node := wf_event_xml.newtag(l_doc, l_header, 'PROTOCOL',

292: l_node := wf_event_xml.newtag(l_doc, l_header, 'NAME',
293: l_name);
294: l_node := wf_event_xml.newtag(l_doc, l_header, 'SYSTEM_GUID',
295: rawtohex(l_system_guid));
296: l_node := wf_event_xml.newtag(l_doc, l_header, 'PROTOCOL',
297: l_protocol);
298: l_node := wf_event_xml.newtag(l_doc, l_header, 'ADDRESS',
299: l_address);
300: l_node := wf_event_xml.newtag(l_doc, l_header, 'QUEUE_HANDLER',

Line 298: l_node := wf_event_xml.newtag(l_doc, l_header, 'ADDRESS',

294: l_node := wf_event_xml.newtag(l_doc, l_header, 'SYSTEM_GUID',
295: rawtohex(l_system_guid));
296: l_node := wf_event_xml.newtag(l_doc, l_header, 'PROTOCOL',
297: l_protocol);
298: l_node := wf_event_xml.newtag(l_doc, l_header, 'ADDRESS',
299: l_address);
300: l_node := wf_event_xml.newtag(l_doc, l_header, 'QUEUE_HANDLER',
301: l_queue_handler);
302: --Bug 3328673

Line 300: l_node := wf_event_xml.newtag(l_doc, l_header, 'QUEUE_HANDLER',

296: l_node := wf_event_xml.newtag(l_doc, l_header, 'PROTOCOL',
297: l_protocol);
298: l_node := wf_event_xml.newtag(l_doc, l_header, 'ADDRESS',
299: l_address);
300: l_node := wf_event_xml.newtag(l_doc, l_header, 'QUEUE_HANDLER',
301: l_queue_handler);
302: --Bug 3328673
303: --Add the new tag for java queue handler
304: l_node := wf_event_xml.newtag(l_doc, l_header, 'JAVA_QUEUE_HANDLER',

Line 304: l_node := wf_event_xml.newtag(l_doc, l_header, 'JAVA_QUEUE_HANDLER',

300: l_node := wf_event_xml.newtag(l_doc, l_header, 'QUEUE_HANDLER',
301: l_queue_handler);
302: --Bug 3328673
303: --Add the new tag for java queue handler
304: l_node := wf_event_xml.newtag(l_doc, l_header, 'JAVA_QUEUE_HANDLER',
305: l_javaqhandler);
306:
307: l_node := wf_event_xml.newtag(l_doc, l_header, 'QUEUE_NAME',
308: l_queue_name);

Line 307: l_node := wf_event_xml.newtag(l_doc, l_header, 'QUEUE_NAME',

303: --Add the new tag for java queue handler
304: l_node := wf_event_xml.newtag(l_doc, l_header, 'JAVA_QUEUE_HANDLER',
305: l_javaqhandler);
306:
307: l_node := wf_event_xml.newtag(l_doc, l_header, 'QUEUE_NAME',
308: l_queue_name);
309: l_node := wf_event_xml.newtag(l_doc, l_header, 'DIRECTION',
310: l_direction);
311: l_node := wf_event_xml.newtag(l_doc, l_header, 'STATUS',

Line 309: l_node := wf_event_xml.newtag(l_doc, l_header, 'DIRECTION',

305: l_javaqhandler);
306:
307: l_node := wf_event_xml.newtag(l_doc, l_header, 'QUEUE_NAME',
308: l_queue_name);
309: l_node := wf_event_xml.newtag(l_doc, l_header, 'DIRECTION',
310: l_direction);
311: l_node := wf_event_xml.newtag(l_doc, l_header, 'STATUS',
312: l_status);
313: l_node := wf_event_xml.newtag(l_doc, l_header, 'DISPLAY_NAME',

Line 311: l_node := wf_event_xml.newtag(l_doc, l_header, 'STATUS',

307: l_node := wf_event_xml.newtag(l_doc, l_header, 'QUEUE_NAME',
308: l_queue_name);
309: l_node := wf_event_xml.newtag(l_doc, l_header, 'DIRECTION',
310: l_direction);
311: l_node := wf_event_xml.newtag(l_doc, l_header, 'STATUS',
312: l_status);
313: l_node := wf_event_xml.newtag(l_doc, l_header, 'DISPLAY_NAME',
314: l_display_name);
315: l_node := wf_event_xml.newtag(l_doc, l_header, 'DESCRIPTION',

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

309: l_node := wf_event_xml.newtag(l_doc, l_header, 'DIRECTION',
310: l_direction);
311: l_node := wf_event_xml.newtag(l_doc, l_header, 'STATUS',
312: l_status);
313: l_node := wf_event_xml.newtag(l_doc, l_header, 'DISPLAY_NAME',
314: l_display_name);
315: l_node := wf_event_xml.newtag(l_doc, l_header, 'DESCRIPTION',
316: l_description);
317: l_node := wf_event_xml.newtag(l_doc, l_header, 'TYPE',

Line 315: l_node := wf_event_xml.newtag(l_doc, l_header, 'DESCRIPTION',

311: l_node := wf_event_xml.newtag(l_doc, l_header, 'STATUS',
312: l_status);
313: l_node := wf_event_xml.newtag(l_doc, l_header, 'DISPLAY_NAME',
314: l_display_name);
315: l_node := wf_event_xml.newtag(l_doc, l_header, 'DESCRIPTION',
316: l_description);
317: l_node := wf_event_xml.newtag(l_doc, l_header, 'TYPE',
318: l_type);
319:

Line 317: l_node := wf_event_xml.newtag(l_doc, l_header, 'TYPE',

313: l_node := wf_event_xml.newtag(l_doc, l_header, 'DISPLAY_NAME',
314: l_display_name);
315: l_node := wf_event_xml.newtag(l_doc, l_header, 'DESCRIPTION',
316: l_description);
317: l_node := wf_event_xml.newtag(l_doc, l_header, 'TYPE',
318: l_type);
319:
320: xmldom.writeToBuffer(l_root, buf);
321:

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

364:
365: begin
366:
367: l_message := x_message;
368: -- l_message := WF_EVENT_SYNCHRONIZE_PKG.SetGUID(l_message); -- update #NEW
369: l_message := WF_EVENT_SYNCHRONIZE_PKG.SetSYSTEMGUID(l_message); -- update #LOCAL
370: l_message := WF_EVENT_SYNCHRONIZE_PKG.SetSID(l_message); -- update #SID
371:
372: l_node_list := wf_event_xml.findTable(l_message, m_table_name);

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

365: begin
366:
367: l_message := x_message;
368: -- l_message := WF_EVENT_SYNCHRONIZE_PKG.SetGUID(l_message); -- update #NEW
369: l_message := WF_EVENT_SYNCHRONIZE_PKG.SetSYSTEMGUID(l_message); -- update #LOCAL
370: l_message := WF_EVENT_SYNCHRONIZE_PKG.SetSID(l_message); -- update #SID
371:
372: l_node_list := wf_event_xml.findTable(l_message, m_table_name);
373: l_length := xmldom.getLength(l_node_list);

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

366:
367: l_message := x_message;
368: -- l_message := WF_EVENT_SYNCHRONIZE_PKG.SetGUID(l_message); -- update #NEW
369: l_message := WF_EVENT_SYNCHRONIZE_PKG.SetSYSTEMGUID(l_message); -- update #LOCAL
370: l_message := WF_EVENT_SYNCHRONIZE_PKG.SetSID(l_message); -- update #SID
371:
372: l_node_list := wf_event_xml.findTable(l_message, m_table_name);
373: l_length := xmldom.getLength(l_node_list);
374:

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

368: -- l_message := WF_EVENT_SYNCHRONIZE_PKG.SetGUID(l_message); -- update #NEW
369: l_message := WF_EVENT_SYNCHRONIZE_PKG.SetSYSTEMGUID(l_message); -- update #LOCAL
370: l_message := WF_EVENT_SYNCHRONIZE_PKG.SetSID(l_message); -- update #SID
371:
372: l_node_list := wf_event_xml.findTable(l_message, m_table_name);
373: l_length := xmldom.getLength(l_node_list);
374:
375: -- loop through elements that we received.
376: for i in 0..l_length-1 loop

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

412: elsif(l_node_name = 'DESCRIPTION') then
413: l_description := l_value;
414: elsif(l_node_name = 'TYPE') then
415: l_type := l_value;
416: elsif(l_node_name = wf_event_xml.versionTagName) then
417: l_version := l_value;
418: else
419: Wf_Core.Token('REASON', 'Invalid column name found:' ||
420: l_node_name || ' with value:'||l_value);