DBA Data[Home] [Help]

APPS.JTF_FM_REQUEST_GRP dependencies on XMLDOM

Line 876: doc IN OUT NOCOPY xmldom.DOMDocument,

872: END GET_CONTENT_NUMBER;
873:
874: -- prints the attributes of each element in a document
875: PROCEDURE Modify_XML(
876: doc IN OUT NOCOPY xmldom.DOMDocument,
877: p_request_id IN NUMBER,
878: remove_query IN Boolean)
879: is
880: nl xmldom.DOMNodeList;

Line 880: nl xmldom.DOMNodeList;

876: doc IN OUT NOCOPY xmldom.DOMDocument,
877: p_request_id IN NUMBER,
878: remove_query IN Boolean)
879: is
880: nl xmldom.DOMNodeList;
881: len1 number;
882: len2 number;
883: n xmldom.DOMNode;
884: e xmldom.DOMElement;

Line 883: n xmldom.DOMNode;

879: is
880: nl xmldom.DOMNodeList;
881: len1 number;
882: len2 number;
883: n xmldom.DOMNode;
884: e xmldom.DOMElement;
885: nnm xmldom.DOMNamedNodeMap;
886: attrname varchar2(100);
887: attrval varchar2(100);

Line 884: e xmldom.DOMElement;

880: nl xmldom.DOMNodeList;
881: len1 number;
882: len2 number;
883: n xmldom.DOMNode;
884: e xmldom.DOMElement;
885: nnm xmldom.DOMNamedNodeMap;
886: attrname varchar2(100);
887: attrval varchar2(100);
888: childNode xmldom.DOMNode;

Line 885: nnm xmldom.DOMNamedNodeMap;

881: len1 number;
882: len2 number;
883: n xmldom.DOMNode;
884: e xmldom.DOMElement;
885: nnm xmldom.DOMNamedNodeMap;
886: attrname varchar2(100);
887: attrval varchar2(100);
888: childNode xmldom.DOMNode;
889: child varchar2(250);

Line 888: childNode xmldom.DOMNode;

884: e xmldom.DOMElement;
885: nnm xmldom.DOMNamedNodeMap;
886: attrname varchar2(100);
887: attrval varchar2(100);
888: childNode xmldom.DOMNode;
889: child varchar2(250);
890: bind_present boolean;
891: headers_present boolean;
892: is_content_present boolean := false;

Line 902: nl := xmldom.getElementsByTagName(doc, 'file');

898:
899: begin
900:
901: -- get all elements
902: nl := xmldom.getElementsByTagName(doc, 'file');
903: len1 := xmldom.getLength(nl);
904:
905: -- loop through elements
906: for j in 0..len1-1 loop

Line 903: len1 := xmldom.getLength(nl);

899: begin
900:
901: -- get all elements
902: nl := xmldom.getElementsByTagName(doc, 'file');
903: len1 := xmldom.getLength(nl);
904:
905: -- loop through elements
906: for j in 0..len1-1 loop
907: queryId := null; -- reset the query_id

Line 908: n := xmldom.item(nl, j);

904:
905: -- loop through elements
906: for j in 0..len1-1 loop
907: queryId := null; -- reset the query_id
908: n := xmldom.item(nl, j);
909: e := xmldom.makeElement(n);
910:
911: queryId := xmldom.getAttribute(e,'query_id');
912: file_id := xmldom.getAttribute(e,'id');

Line 909: e := xmldom.makeElement(n);

905: -- loop through elements
906: for j in 0..len1-1 loop
907: queryId := null; -- reset the query_id
908: n := xmldom.item(nl, j);
909: e := xmldom.makeElement(n);
910:
911: queryId := xmldom.getAttribute(e,'query_id');
912: file_id := xmldom.getAttribute(e,'id');
913: IF queryId IS NOT NULL THEN

Line 911: queryId := xmldom.getAttribute(e,'query_id');

907: queryId := null; -- reset the query_id
908: n := xmldom.item(nl, j);
909: e := xmldom.makeElement(n);
910:
911: queryId := xmldom.getAttribute(e,'query_id');
912: file_id := xmldom.getAttribute(e,'id');
913: IF queryId IS NOT NULL THEN
914: xmldom.setattribute(e, 'body', 'merge');
915: IF remove_query THEN

Line 912: file_id := xmldom.getAttribute(e,'id');

908: n := xmldom.item(nl, j);
909: e := xmldom.makeElement(n);
910:
911: queryId := xmldom.getAttribute(e,'query_id');
912: file_id := xmldom.getAttribute(e,'id');
913: IF queryId IS NOT NULL THEN
914: xmldom.setattribute(e, 'body', 'merge');
915: IF remove_query THEN
916: xmldom.removeattribute(e,'query_id');

Line 914: xmldom.setattribute(e, 'body', 'merge');

910:
911: queryId := xmldom.getAttribute(e,'query_id');
912: file_id := xmldom.getAttribute(e,'id');
913: IF queryId IS NOT NULL THEN
914: xmldom.setattribute(e, 'body', 'merge');
915: IF remove_query THEN
916: xmldom.removeattribute(e,'query_id');
917: END IF;
918: END IF;

Line 916: xmldom.removeattribute(e,'query_id');

912: file_id := xmldom.getAttribute(e,'id');
913: IF queryId IS NOT NULL THEN
914: xmldom.setattribute(e, 'body', 'merge');
915: IF remove_query THEN
916: xmldom.removeattribute(e,'query_id');
917: END IF;
918: END IF;
919: contentNo := xmldom.getattribute(e,'content_no');
920: IF contentNo is NULL THEN

Line 919: contentNo := xmldom.getattribute(e,'content_no');

915: IF remove_query THEN
916: xmldom.removeattribute(e,'query_id');
917: END IF;
918: END IF;
919: contentNo := xmldom.getattribute(e,'content_no');
920: IF contentNo is NULL THEN
921: l_content_no := GET_CONTENT_NUMBER(p_request_id, file_id);
922: xmldom.setAttribute(e,'content_no', l_content_no);
923: END IF;

Line 922: xmldom.setAttribute(e,'content_no', l_content_no);

918: END IF;
919: contentNo := xmldom.getattribute(e,'content_no');
920: IF contentNo is NULL THEN
921: l_content_no := GET_CONTENT_NUMBER(p_request_id, file_id);
922: xmldom.setAttribute(e,'content_no', l_content_no);
923: END IF;
924: end loop;
925: end Modify_XML;
926:

Line 930: doc IN xmldom.DOMDocument,

926:
927:
928: -- prints the attributes of each element in a document
929: procedure BUILD_BIND(
930: doc IN xmldom.DOMDocument,
931: l_xml OUT NOCOPY LONG) is
932: nl xmldom.DOMNodeList;
933: len1 number;
934: len2 number;

Line 932: nl xmldom.DOMNodeList;

928: -- prints the attributes of each element in a document
929: procedure BUILD_BIND(
930: doc IN xmldom.DOMDocument,
931: l_xml OUT NOCOPY LONG) is
932: nl xmldom.DOMNodeList;
933: len1 number;
934: len2 number;
935: n xmldom.DOMNode;
936: e xmldom.DOMElement;

Line 935: n xmldom.DOMNode;

931: l_xml OUT NOCOPY LONG) is
932: nl xmldom.DOMNodeList;
933: len1 number;
934: len2 number;
935: n xmldom.DOMNode;
936: e xmldom.DOMElement;
937: nnm xmldom.DOMNamedNodeMap;
938: attrname varchar2(100);
939: attrval varchar2(100);

Line 936: e xmldom.DOMElement;

932: nl xmldom.DOMNodeList;
933: len1 number;
934: len2 number;
935: n xmldom.DOMNode;
936: e xmldom.DOMElement;
937: nnm xmldom.DOMNamedNodeMap;
938: attrname varchar2(100);
939: attrval varchar2(100);
940:

Line 937: nnm xmldom.DOMNamedNodeMap;

933: len1 number;
934: len2 number;
935: n xmldom.DOMNode;
936: e xmldom.DOMElement;
937: nnm xmldom.DOMNamedNodeMap;
938: attrname varchar2(100);
939: attrval varchar2(100);
940:
941: begin

Line 944: nl := xmldom.getElementsByTagName(doc, '*');

940:
941: begin
942:
943: -- get all elements
944: nl := xmldom.getElementsByTagName(doc, '*');
945: len1 := xmldom.getLength(nl);
946:
947: l_xml := '';
948:

Line 945: len1 := xmldom.getLength(nl);

941: begin
942:
943: -- get all elements
944: nl := xmldom.getElementsByTagName(doc, '*');
945: len1 := xmldom.getLength(nl);
946:
947: l_xml := '';
948:
949: -- loop through elements

Line 951: n := xmldom.item(nl, j);

947: l_xml := '';
948:
949: -- loop through elements
950: for j in 0..len1-1 loop
951: n := xmldom.item(nl, j);
952: e := xmldom.makeElement(n);
953: --dbms_output.put_line(xmldom.getTagName(e) || ':');
954:
955: IF (xmldom.getTagName(e) = 'var' ) THEN

Line 952: e := xmldom.makeElement(n);

948:
949: -- loop through elements
950: for j in 0..len1-1 loop
951: n := xmldom.item(nl, j);
952: e := xmldom.makeElement(n);
953: --dbms_output.put_line(xmldom.getTagName(e) || ':');
954:
955: IF (xmldom.getTagName(e) = 'var' ) THEN
956:

Line 953: --dbms_output.put_line(xmldom.getTagName(e) || ':');

949: -- loop through elements
950: for j in 0..len1-1 loop
951: n := xmldom.item(nl, j);
952: e := xmldom.makeElement(n);
953: --dbms_output.put_line(xmldom.getTagName(e) || ':');
954:
955: IF (xmldom.getTagName(e) = 'var' ) THEN
956:
957: -- get all attributes of element

Line 955: IF (xmldom.getTagName(e) = 'var' ) THEN

951: n := xmldom.item(nl, j);
952: e := xmldom.makeElement(n);
953: --dbms_output.put_line(xmldom.getTagName(e) || ':');
954:
955: IF (xmldom.getTagName(e) = 'var' ) THEN
956:
957: -- get all attributes of element
958: nnm := xmldom.getAttributes(n);
959:

Line 958: nnm := xmldom.getAttributes(n);

954:
955: IF (xmldom.getTagName(e) = 'var' ) THEN
956:
957: -- get all attributes of element
958: nnm := xmldom.getAttributes(n);
959:
960: if (xmldom.isNull(nnm) = FALSE) then
961: len2 := xmldom.getLength(nnm);
962:

Line 960: if (xmldom.isNull(nnm) = FALSE) then

956:
957: -- get all attributes of element
958: nnm := xmldom.getAttributes(n);
959:
960: if (xmldom.isNull(nnm) = FALSE) then
961: len2 := xmldom.getLength(nnm);
962:
963: -- loop through attributes
964: for i in 0..len2-1 loop

Line 961: len2 := xmldom.getLength(nnm);

957: -- get all attributes of element
958: nnm := xmldom.getAttributes(n);
959:
960: if (xmldom.isNull(nnm) = FALSE) then
961: len2 := xmldom.getLength(nnm);
962:
963: -- loop through attributes
964: for i in 0..len2-1 loop
965: n := xmldom.item(nnm, i);

Line 965: n := xmldom.item(nnm, i);

961: len2 := xmldom.getLength(nnm);
962:
963: -- loop through attributes
964: for i in 0..len2-1 loop
965: n := xmldom.item(nnm, i);
966: attrname := xmldom.getNodeName(n);
967: attrval := xmldom.getNodeValue(n);
968: IF attrname = 'name' THEN
969: l_xml := l_xml || '