[Home] [Help]
752: and e.guid = s.event_filter_guid;
753:
754: l_doc := xmldom.newDOMDocument;
755: l_root := xmldom.makeNode(l_doc);
756: l_root := wf_event_xml.newtag (l_doc, l_root, wf_event_xml.masterTagName);
757: l_header := wf_event_xml.newtag(l_doc, l_root, m_table_name);
758: l_node := wf_event_xml.newtag(l_doc, l_header, wf_event_xml.versionTagName,
759: m_package_version);
760: l_node := wf_event_xml.newtag(l_doc, l_header, 'GUID',
753:
754: l_doc := xmldom.newDOMDocument;
755: l_root := xmldom.makeNode(l_doc);
756: l_root := wf_event_xml.newtag (l_doc, l_root, wf_event_xml.masterTagName);
757: l_header := wf_event_xml.newtag(l_doc, l_root, m_table_name);
758: l_node := wf_event_xml.newtag(l_doc, l_header, wf_event_xml.versionTagName,
759: m_package_version);
760: l_node := wf_event_xml.newtag(l_doc, l_header, 'GUID',
761: rawtohex(x_guid));
754: l_doc := xmldom.newDOMDocument;
755: l_root := xmldom.makeNode(l_doc);
756: l_root := wf_event_xml.newtag (l_doc, l_root, wf_event_xml.masterTagName);
757: l_header := wf_event_xml.newtag(l_doc, l_root, m_table_name);
758: l_node := wf_event_xml.newtag(l_doc, l_header, wf_event_xml.versionTagName,
759: m_package_version);
760: l_node := wf_event_xml.newtag(l_doc, l_header, 'GUID',
761: rawtohex(x_guid));
762: l_node := wf_event_xml.newtag(l_doc, l_header, 'SYSTEM_GUID',
756: l_root := wf_event_xml.newtag (l_doc, l_root, wf_event_xml.masterTagName);
757: l_header := wf_event_xml.newtag(l_doc, l_root, m_table_name);
758: l_node := wf_event_xml.newtag(l_doc, l_header, wf_event_xml.versionTagName,
759: m_package_version);
760: l_node := wf_event_xml.newtag(l_doc, l_header, 'GUID',
761: rawtohex(x_guid));
762: l_node := wf_event_xml.newtag(l_doc, l_header, 'SYSTEM_GUID',
763: rawtohex(l_system_guid));
764: l_node := wf_event_xml.newtag(l_doc, l_header, 'SOURCE_TYPE',
758: l_node := wf_event_xml.newtag(l_doc, l_header, wf_event_xml.versionTagName,
759: m_package_version);
760: l_node := wf_event_xml.newtag(l_doc, l_header, 'GUID',
761: rawtohex(x_guid));
762: l_node := wf_event_xml.newtag(l_doc, l_header, 'SYSTEM_GUID',
763: rawtohex(l_system_guid));
764: l_node := wf_event_xml.newtag(l_doc, l_header, 'SOURCE_TYPE',
765: l_source_type);
766: l_node := wf_event_xml.newtag(l_doc, l_header, 'SOURCE_AGENT_GUID',
760: l_node := wf_event_xml.newtag(l_doc, l_header, 'GUID',
761: rawtohex(x_guid));
762: l_node := wf_event_xml.newtag(l_doc, l_header, 'SYSTEM_GUID',
763: rawtohex(l_system_guid));
764: l_node := wf_event_xml.newtag(l_doc, l_header, 'SOURCE_TYPE',
765: l_source_type);
766: l_node := wf_event_xml.newtag(l_doc, l_header, 'SOURCE_AGENT_GUID',
767: rawtohex(l_source_agent_guid));
768: l_node := wf_event_xml.newtag(l_doc, l_header, 'EVENT_FILTER_GUID', l_event_filter_name);
762: l_node := wf_event_xml.newtag(l_doc, l_header, 'SYSTEM_GUID',
763: rawtohex(l_system_guid));
764: l_node := wf_event_xml.newtag(l_doc, l_header, 'SOURCE_TYPE',
765: l_source_type);
766: l_node := wf_event_xml.newtag(l_doc, l_header, 'SOURCE_AGENT_GUID',
767: rawtohex(l_source_agent_guid));
768: l_node := wf_event_xml.newtag(l_doc, l_header, 'EVENT_FILTER_GUID', l_event_filter_name);
769:
770: l_node := wf_event_xml.newtag(l_doc, l_header, 'PHASE',
764: l_node := wf_event_xml.newtag(l_doc, l_header, 'SOURCE_TYPE',
765: l_source_type);
766: l_node := wf_event_xml.newtag(l_doc, l_header, 'SOURCE_AGENT_GUID',
767: rawtohex(l_source_agent_guid));
768: l_node := wf_event_xml.newtag(l_doc, l_header, 'EVENT_FILTER_GUID', l_event_filter_name);
769:
770: l_node := wf_event_xml.newtag(l_doc, l_header, 'PHASE',
771: l_phase);
772: l_node := wf_event_xml.newtag(l_doc, l_header, 'STATUS',
766: l_node := wf_event_xml.newtag(l_doc, l_header, 'SOURCE_AGENT_GUID',
767: rawtohex(l_source_agent_guid));
768: l_node := wf_event_xml.newtag(l_doc, l_header, 'EVENT_FILTER_GUID', l_event_filter_name);
769:
770: l_node := wf_event_xml.newtag(l_doc, l_header, 'PHASE',
771: l_phase);
772: l_node := wf_event_xml.newtag(l_doc, l_header, 'STATUS',
773: l_status);
774: l_node := wf_event_xml.newtag(l_doc, l_header, 'RULE_DATA',
768: l_node := wf_event_xml.newtag(l_doc, l_header, 'EVENT_FILTER_GUID', l_event_filter_name);
769:
770: l_node := wf_event_xml.newtag(l_doc, l_header, 'PHASE',
771: l_phase);
772: l_node := wf_event_xml.newtag(l_doc, l_header, 'STATUS',
773: l_status);
774: l_node := wf_event_xml.newtag(l_doc, l_header, 'RULE_DATA',
775: l_rule_data);
776: l_node := wf_event_xml.newtag(l_doc, l_header, 'OUT_AGENT_GUID',
770: l_node := wf_event_xml.newtag(l_doc, l_header, 'PHASE',
771: l_phase);
772: l_node := wf_event_xml.newtag(l_doc, l_header, 'STATUS',
773: l_status);
774: l_node := wf_event_xml.newtag(l_doc, l_header, 'RULE_DATA',
775: l_rule_data);
776: l_node := wf_event_xml.newtag(l_doc, l_header, 'OUT_AGENT_GUID',
777: rawtohex(l_out_agent_guid));
778: l_node := wf_event_xml.newtag(l_doc, l_header, 'TO_AGENT_GUID',
772: l_node := wf_event_xml.newtag(l_doc, l_header, 'STATUS',
773: l_status);
774: l_node := wf_event_xml.newtag(l_doc, l_header, 'RULE_DATA',
775: l_rule_data);
776: l_node := wf_event_xml.newtag(l_doc, l_header, 'OUT_AGENT_GUID',
777: rawtohex(l_out_agent_guid));
778: l_node := wf_event_xml.newtag(l_doc, l_header, 'TO_AGENT_GUID',
779: rawtohex(l_to_agent_guid));
780: l_node := wf_event_xml.newtag(l_doc, l_header, 'PRIORITY',
774: l_node := wf_event_xml.newtag(l_doc, l_header, 'RULE_DATA',
775: l_rule_data);
776: l_node := wf_event_xml.newtag(l_doc, l_header, 'OUT_AGENT_GUID',
777: rawtohex(l_out_agent_guid));
778: l_node := wf_event_xml.newtag(l_doc, l_header, 'TO_AGENT_GUID',
779: rawtohex(l_to_agent_guid));
780: l_node := wf_event_xml.newtag(l_doc, l_header, 'PRIORITY',
781: l_PRIORITY);
782: l_node := wf_event_xml.newtag(l_doc, l_header, 'RULE_FUNCTION',
776: l_node := wf_event_xml.newtag(l_doc, l_header, 'OUT_AGENT_GUID',
777: rawtohex(l_out_agent_guid));
778: l_node := wf_event_xml.newtag(l_doc, l_header, 'TO_AGENT_GUID',
779: rawtohex(l_to_agent_guid));
780: l_node := wf_event_xml.newtag(l_doc, l_header, 'PRIORITY',
781: l_PRIORITY);
782: l_node := wf_event_xml.newtag(l_doc, l_header, 'RULE_FUNCTION',
783: l_RULE_FUNCTION);
784: --Bug 3328673
778: l_node := wf_event_xml.newtag(l_doc, l_header, 'TO_AGENT_GUID',
779: rawtohex(l_to_agent_guid));
780: l_node := wf_event_xml.newtag(l_doc, l_header, 'PRIORITY',
781: l_PRIORITY);
782: l_node := wf_event_xml.newtag(l_doc, l_header, 'RULE_FUNCTION',
783: l_RULE_FUNCTION);
784: --Bug 3328673
785: --Add new tags for JBES support
786: l_node := wf_event_xml.newtag(l_doc, l_header, 'JAVA_RULE_FUNC',
782: l_node := wf_event_xml.newtag(l_doc, l_header, 'RULE_FUNCTION',
783: l_RULE_FUNCTION);
784: --Bug 3328673
785: --Add new tags for JBES support
786: l_node := wf_event_xml.newtag(l_doc, l_header, 'JAVA_RULE_FUNC',
787: l_javarulefunc);
788: l_node := wf_event_xml.newtag(l_doc, l_header, 'STANDARD_TYPE',
789: l_standardtype);
790: l_node := wf_event_xml.newtag(l_doc, l_header, 'STANDARD_CODE',
784: --Bug 3328673
785: --Add new tags for JBES support
786: l_node := wf_event_xml.newtag(l_doc, l_header, 'JAVA_RULE_FUNC',
787: l_javarulefunc);
788: l_node := wf_event_xml.newtag(l_doc, l_header, 'STANDARD_TYPE',
789: l_standardtype);
790: l_node := wf_event_xml.newtag(l_doc, l_header, 'STANDARD_CODE',
791: l_standardcode);
792: l_node := wf_event_xml.newtag(l_doc, l_header, 'ON_ERROR_CODE',
786: l_node := wf_event_xml.newtag(l_doc, l_header, 'JAVA_RULE_FUNC',
787: l_javarulefunc);
788: l_node := wf_event_xml.newtag(l_doc, l_header, 'STANDARD_TYPE',
789: l_standardtype);
790: l_node := wf_event_xml.newtag(l_doc, l_header, 'STANDARD_CODE',
791: l_standardcode);
792: l_node := wf_event_xml.newtag(l_doc, l_header, 'ON_ERROR_CODE',
793: l_onerror);
794: l_node := wf_event_xml.newtag(l_doc, l_header, 'ACTION_CODE',
788: l_node := wf_event_xml.newtag(l_doc, l_header, 'STANDARD_TYPE',
789: l_standardtype);
790: l_node := wf_event_xml.newtag(l_doc, l_header, 'STANDARD_CODE',
791: l_standardcode);
792: l_node := wf_event_xml.newtag(l_doc, l_header, 'ON_ERROR_CODE',
793: l_onerror);
794: l_node := wf_event_xml.newtag(l_doc, l_header, 'ACTION_CODE',
795: l_actioncode);
796:
790: l_node := wf_event_xml.newtag(l_doc, l_header, 'STANDARD_CODE',
791: l_standardcode);
792: l_node := wf_event_xml.newtag(l_doc, l_header, 'ON_ERROR_CODE',
793: l_onerror);
794: l_node := wf_event_xml.newtag(l_doc, l_header, 'ACTION_CODE',
795: l_actioncode);
796:
797: l_node := wf_event_xml.newtag(l_doc, l_header, 'WF_PROCESS_TYPE',
798: l_wf_process_type);
793: l_onerror);
794: l_node := wf_event_xml.newtag(l_doc, l_header, 'ACTION_CODE',
795: l_actioncode);
796:
797: l_node := wf_event_xml.newtag(l_doc, l_header, 'WF_PROCESS_TYPE',
798: l_wf_process_type);
799: l_node := wf_event_xml.newtag(l_doc, l_header, 'WF_PROCESS_NAME',
800: l_wf_process_name);
801: l_node := wf_event_xml.newtag(l_doc, l_header, 'PARAMETERS',
795: l_actioncode);
796:
797: l_node := wf_event_xml.newtag(l_doc, l_header, 'WF_PROCESS_TYPE',
798: l_wf_process_type);
799: l_node := wf_event_xml.newtag(l_doc, l_header, 'WF_PROCESS_NAME',
800: l_wf_process_name);
801: l_node := wf_event_xml.newtag(l_doc, l_header, 'PARAMETERS',
802: l_PARAMETERS);
803: l_node := wf_event_xml.newtag(l_doc, l_header, 'OWNER_NAME',
797: l_node := wf_event_xml.newtag(l_doc, l_header, 'WF_PROCESS_TYPE',
798: l_wf_process_type);
799: l_node := wf_event_xml.newtag(l_doc, l_header, 'WF_PROCESS_NAME',
800: l_wf_process_name);
801: l_node := wf_event_xml.newtag(l_doc, l_header, 'PARAMETERS',
802: l_PARAMETERS);
803: l_node := wf_event_xml.newtag(l_doc, l_header, 'OWNER_NAME',
804: l_OWNER_NAME);
805: l_node := wf_event_xml.newtag(l_doc, l_header, 'OWNER_TAG',
799: l_node := wf_event_xml.newtag(l_doc, l_header, 'WF_PROCESS_NAME',
800: l_wf_process_name);
801: l_node := wf_event_xml.newtag(l_doc, l_header, 'PARAMETERS',
802: l_PARAMETERS);
803: l_node := wf_event_xml.newtag(l_doc, l_header, 'OWNER_NAME',
804: l_OWNER_NAME);
805: l_node := wf_event_xml.newtag(l_doc, l_header, 'OWNER_TAG',
806: l_OWNER_TAG);
807: l_node := wf_event_xml.newtag(l_doc, l_header, 'CUSTOMIZATION_LEVEL',
801: l_node := wf_event_xml.newtag(l_doc, l_header, 'PARAMETERS',
802: l_PARAMETERS);
803: l_node := wf_event_xml.newtag(l_doc, l_header, 'OWNER_NAME',
804: l_OWNER_NAME);
805: l_node := wf_event_xml.newtag(l_doc, l_header, 'OWNER_TAG',
806: l_OWNER_TAG);
807: l_node := wf_event_xml.newtag(l_doc, l_header, 'CUSTOMIZATION_LEVEL',
808: NVL(l_customization_level, 'L'));
809: l_node := wf_event_xml.newtag(l_doc, l_header, 'LICENSED_FLAG',
803: l_node := wf_event_xml.newtag(l_doc, l_header, 'OWNER_NAME',
804: l_OWNER_NAME);
805: l_node := wf_event_xml.newtag(l_doc, l_header, 'OWNER_TAG',
806: l_OWNER_TAG);
807: l_node := wf_event_xml.newtag(l_doc, l_header, 'CUSTOMIZATION_LEVEL',
808: NVL(l_customization_level, 'L'));
809: l_node := wf_event_xml.newtag(l_doc, l_header, 'LICENSED_FLAG',
810: NVL(l_licensed_flag, 'Y'));
811: l_node := wf_event_xml.newtag(l_doc, l_header, 'DESCRIPTION',
805: l_node := wf_event_xml.newtag(l_doc, l_header, 'OWNER_TAG',
806: l_OWNER_TAG);
807: l_node := wf_event_xml.newtag(l_doc, l_header, 'CUSTOMIZATION_LEVEL',
808: NVL(l_customization_level, 'L'));
809: l_node := wf_event_xml.newtag(l_doc, l_header, 'LICENSED_FLAG',
810: NVL(l_licensed_flag, 'Y'));
811: l_node := wf_event_xml.newtag(l_doc, l_header, 'DESCRIPTION',
812: l_DESCRIPTION);
813: l_node := wf_event_xml.newtag(l_doc, l_header, 'EXPRESSION',
807: l_node := wf_event_xml.newtag(l_doc, l_header, 'CUSTOMIZATION_LEVEL',
808: NVL(l_customization_level, 'L'));
809: l_node := wf_event_xml.newtag(l_doc, l_header, 'LICENSED_FLAG',
810: NVL(l_licensed_flag, 'Y'));
811: l_node := wf_event_xml.newtag(l_doc, l_header, 'DESCRIPTION',
812: l_DESCRIPTION);
813: l_node := wf_event_xml.newtag(l_doc, l_header, 'EXPRESSION',
814: l_EXPRESSION);
815: xmldom.writeToBuffer(l_root, buf);
809: l_node := wf_event_xml.newtag(l_doc, l_header, 'LICENSED_FLAG',
810: NVL(l_licensed_flag, 'Y'));
811: l_node := wf_event_xml.newtag(l_doc, l_header, 'DESCRIPTION',
812: l_DESCRIPTION);
813: l_node := wf_event_xml.newtag(l_doc, l_header, 'EXPRESSION',
814: l_EXPRESSION);
815: xmldom.writeToBuffer(l_root, buf);
816:
817: return buf;
876: --Replace agent names by their GUIDs
877: l_message := WF_EVENT_SYNCHRONIZE_PKG.SetAgent2('
878: l_message := WF_EVENT_SYNCHRONIZE_PKG.SetAgent2('
879: l_message := WF_EVENT_SYNCHRONIZE_PKG.SetAgent2('
880: l_node_list := wf_event_xml.findTable(l_message, m_table_name);
881: l_length := xmldom.getLength(l_node_list);
882:
883: -- loop through elements that we received.
884: for i in 0..l_length-1 loop