470: where guid = x_guid;
471:
472: l_doc := xmldom.newDOMDocument;
473: l_root := xmldom.makeNode(l_doc);
474: l_root := wf_event_xml.newtag (l_doc, l_root, wf_event_xml.masterTagName);
475: l_header := wf_event_xml.newtag(l_doc, l_root, m_table_name);
476: l_node := wf_event_xml.newtag(l_doc, l_header, wf_event_xml.versionTagName,
477: m_package_version);
478: -- l_node := wf_event_xml.newtag(l_doc, l_header, 'GUID',
471:
472: l_doc := xmldom.newDOMDocument;
473: l_root := xmldom.makeNode(l_doc);
474: l_root := wf_event_xml.newtag (l_doc, l_root, wf_event_xml.masterTagName);
475: l_header := wf_event_xml.newtag(l_doc, l_root, m_table_name);
476: l_node := wf_event_xml.newtag(l_doc, l_header, wf_event_xml.versionTagName,
477: m_package_version);
478: -- l_node := wf_event_xml.newtag(l_doc, l_header, 'GUID',
479: -- rawtohex(x_GUID));
472: l_doc := xmldom.newDOMDocument;
473: l_root := xmldom.makeNode(l_doc);
474: l_root := wf_event_xml.newtag (l_doc, l_root, wf_event_xml.masterTagName);
475: l_header := wf_event_xml.newtag(l_doc, l_root, m_table_name);
476: l_node := wf_event_xml.newtag(l_doc, l_header, wf_event_xml.versionTagName,
477: m_package_version);
478: -- l_node := wf_event_xml.newtag(l_doc, l_header, 'GUID',
479: -- rawtohex(x_GUID));
480: l_node := wf_event_xml.newtag(l_doc, l_header, 'GUID', '#NEW');
474: l_root := wf_event_xml.newtag (l_doc, l_root, wf_event_xml.masterTagName);
475: l_header := wf_event_xml.newtag(l_doc, l_root, m_table_name);
476: l_node := wf_event_xml.newtag(l_doc, l_header, wf_event_xml.versionTagName,
477: m_package_version);
478: -- l_node := wf_event_xml.newtag(l_doc, l_header, 'GUID',
479: -- rawtohex(x_GUID));
480: l_node := wf_event_xml.newtag(l_doc, l_header, 'GUID', '#NEW');
481: l_node := wf_event_xml.newtag(l_doc, l_header, 'NAME',
482: l_name);
476: l_node := wf_event_xml.newtag(l_doc, l_header, wf_event_xml.versionTagName,
477: m_package_version);
478: -- l_node := wf_event_xml.newtag(l_doc, l_header, 'GUID',
479: -- rawtohex(x_GUID));
480: l_node := wf_event_xml.newtag(l_doc, l_header, 'GUID', '#NEW');
481: l_node := wf_event_xml.newtag(l_doc, l_header, 'NAME',
482: l_name);
483: l_node := wf_event_xml.newtag(l_doc, l_header, 'TYPE',
484: l_type);
477: m_package_version);
478: -- l_node := wf_event_xml.newtag(l_doc, l_header, 'GUID',
479: -- rawtohex(x_GUID));
480: l_node := wf_event_xml.newtag(l_doc, l_header, 'GUID', '#NEW');
481: l_node := wf_event_xml.newtag(l_doc, l_header, 'NAME',
482: l_name);
483: l_node := wf_event_xml.newtag(l_doc, l_header, 'TYPE',
484: l_type);
485: l_node := wf_event_xml.newtag(l_doc, l_header, 'STATUS',
479: -- rawtohex(x_GUID));
480: l_node := wf_event_xml.newtag(l_doc, l_header, 'GUID', '#NEW');
481: l_node := wf_event_xml.newtag(l_doc, l_header, 'NAME',
482: l_name);
483: l_node := wf_event_xml.newtag(l_doc, l_header, 'TYPE',
484: l_type);
485: l_node := wf_event_xml.newtag(l_doc, l_header, 'STATUS',
486: l_status);
487: l_node := wf_event_xml.newtag(l_doc, l_header, 'GENERATE_FUNCTION',
481: l_node := wf_event_xml.newtag(l_doc, l_header, 'NAME',
482: l_name);
483: l_node := wf_event_xml.newtag(l_doc, l_header, 'TYPE',
484: l_type);
485: l_node := wf_event_xml.newtag(l_doc, l_header, 'STATUS',
486: l_status);
487: l_node := wf_event_xml.newtag(l_doc, l_header, 'GENERATE_FUNCTION',
488: l_generate_function);
489: l_node := wf_event_xml.newtag(l_doc, l_header, 'OWNER_NAME',
483: l_node := wf_event_xml.newtag(l_doc, l_header, 'TYPE',
484: l_type);
485: l_node := wf_event_xml.newtag(l_doc, l_header, 'STATUS',
486: l_status);
487: l_node := wf_event_xml.newtag(l_doc, l_header, 'GENERATE_FUNCTION',
488: l_generate_function);
489: l_node := wf_event_xml.newtag(l_doc, l_header, 'OWNER_NAME',
490: l_owner_name);
491: l_node := wf_event_xml.newtag(l_doc, l_header, 'OWNER_TAG',
485: l_node := wf_event_xml.newtag(l_doc, l_header, 'STATUS',
486: l_status);
487: l_node := wf_event_xml.newtag(l_doc, l_header, 'GENERATE_FUNCTION',
488: l_generate_function);
489: l_node := wf_event_xml.newtag(l_doc, l_header, 'OWNER_NAME',
490: l_owner_name);
491: l_node := wf_event_xml.newtag(l_doc, l_header, 'OWNER_TAG',
492: l_owner_tag);
493: l_node := wf_event_xml.newtag(l_doc, l_header, 'CUSTOMIZATION_LEVEL',
487: l_node := wf_event_xml.newtag(l_doc, l_header, 'GENERATE_FUNCTION',
488: l_generate_function);
489: l_node := wf_event_xml.newtag(l_doc, l_header, 'OWNER_NAME',
490: l_owner_name);
491: l_node := wf_event_xml.newtag(l_doc, l_header, 'OWNER_TAG',
492: l_owner_tag);
493: l_node := wf_event_xml.newtag(l_doc, l_header, 'CUSTOMIZATION_LEVEL',
494: NVL(l_customization_level, 'L'));
495: l_node := wf_event_xml.newtag(l_doc, l_header, 'LICENSED_FLAG',
489: l_node := wf_event_xml.newtag(l_doc, l_header, 'OWNER_NAME',
490: l_owner_name);
491: l_node := wf_event_xml.newtag(l_doc, l_header, 'OWNER_TAG',
492: l_owner_tag);
493: l_node := wf_event_xml.newtag(l_doc, l_header, 'CUSTOMIZATION_LEVEL',
494: NVL(l_customization_level, 'L'));
495: l_node := wf_event_xml.newtag(l_doc, l_header, 'LICENSED_FLAG',
496: NVL(l_licensed_flag, 'Y'));
497:
491: l_node := wf_event_xml.newtag(l_doc, l_header, 'OWNER_TAG',
492: l_owner_tag);
493: l_node := wf_event_xml.newtag(l_doc, l_header, 'CUSTOMIZATION_LEVEL',
494: NVL(l_customization_level, 'L'));
495: l_node := wf_event_xml.newtag(l_doc, l_header, 'LICENSED_FLAG',
496: NVL(l_licensed_flag, 'Y'));
497:
498: --Bug 3328673
499: --New tag for loader
496: NVL(l_licensed_flag, 'Y'));
497:
498: --Bug 3328673
499: --New tag for loader
500: l_node := wf_event_xml.newtag(l_doc, l_header, 'JAVA_GENERATE_FUNC',
501: l_javagenerate);
502:
503: l_node := wf_event_xml.newtag(l_doc, l_header, 'DISPLAY_NAME',
504: l_display_name);
499: --New tag for loader
500: l_node := wf_event_xml.newtag(l_doc, l_header, 'JAVA_GENERATE_FUNC',
501: l_javagenerate);
502:
503: l_node := wf_event_xml.newtag(l_doc, l_header, 'DISPLAY_NAME',
504: l_display_name);
505: l_node := wf_event_xml.newtag(l_doc, l_header, 'DESCRIPTION',
506: l_description);
507:
501: l_javagenerate);
502:
503: l_node := wf_event_xml.newtag(l_doc, l_header, 'DISPLAY_NAME',
504: l_display_name);
505: l_node := wf_event_xml.newtag(l_doc, l_header, 'DESCRIPTION',
506: l_description);
507:
508: if (l_irep_annotation is null) then
509: -- create an annotation template
521: -- event was reviewed for annotation and decided not to be annotated
522: l_irep_annotation := null;
523: end if;
524:
525: -- l_node := wf_event_xml.newCDATATag(l_doc, l_header, 'IREP_ANNOTATION', l_irep_annotation);
526: l_node := wf_event_xml.newtag(l_doc, l_header, 'IREP_ANNOTATION', l_irep_annotation);
527:
528: xmldom.writeToBuffer(l_root, buf);
529:
522: l_irep_annotation := null;
523: end if;
524:
525: -- l_node := wf_event_xml.newCDATATag(l_doc, l_header, 'IREP_ANNOTATION', l_irep_annotation);
526: l_node := wf_event_xml.newtag(l_doc, l_header, 'IREP_ANNOTATION', l_irep_annotation);
527:
528: xmldom.writeToBuffer(l_root, buf);
529:
530: return buf;
565: l_message := WF_EVENT_SYNCHRONIZE_PKG.SetGUID(l_message); -- update #NEW
566: l_message := WF_EVENT_SYNCHRONIZE_PKG.SetSYSTEMGUID(l_message); -- update #LOCAL
567: l_message := WF_EVENT_SYNCHRONIZE_PKG.SetSID(l_message); -- update #SID
568:
569: l_node_list := wf_event_xml.findTable(l_message, m_table_name);
570: l_length := xmldom.getLength(l_node_list);
571:
572: -- loop through elements that we received.
573: for i in 0..l_length-1 loop
601: elsif(l_node_name = 'CUSTOMIZATION_LEVEL') then
602: l_CUSTOMIZATION_LEVEL := l_value;
603: elsif(l_node_name = 'LICENSED_FLAG') then
604: l_LICENSED_FLAG := l_value;
605: elsif(l_node_name = wf_event_xml.versionTagName) then
606: l_version := l_value;
607: elsif(l_node_name = 'JAVA_GENERATE_FUNC') then
608: l_javagenerate := l_value;
609: elsif(l_node_name = 'IREP_ANNOTATION') then