eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBC_CITEM_ADMIN_GRP dependencies on XMLDOM

Line 1629: dom_doc XMLDOM.DOMDocument;

1625: )
1626: IS
1627: temp_bundle CLOB; -- temporary clob to hold text information while creating
1628: xml_parser XMLPARSER.parser;
1629: dom_doc XMLDOM.DOMDocument;
1630: dom_node_list XMLDOM.DOMNodeList; -- base nodes
1631: att_node_list XMLDOM.DOMNodeList; -- attribute nodes
1632: dom_node XMLDOM.DOMNode; -- base node
1633: total_att_count NUMBER; -- temp variable to hold total count of attributes found

Line 1630: dom_node_list XMLDOM.DOMNodeList; -- base nodes

1626: IS
1627: temp_bundle CLOB; -- temporary clob to hold text information while creating
1628: xml_parser XMLPARSER.parser;
1629: dom_doc XMLDOM.DOMDocument;
1630: dom_node_list XMLDOM.DOMNodeList; -- base nodes
1631: att_node_list XMLDOM.DOMNodeList; -- attribute nodes
1632: dom_node XMLDOM.DOMNode; -- base node
1633: total_att_count NUMBER; -- temp variable to hold total count of attributes found
1634: temp_node_list XMLDOM.DOMNodeList; -- temporary nodes for use inside creation loop

Line 1631: att_node_list XMLDOM.DOMNodeList; -- attribute nodes

1627: temp_bundle CLOB; -- temporary clob to hold text information while creating
1628: xml_parser XMLPARSER.parser;
1629: dom_doc XMLDOM.DOMDocument;
1630: dom_node_list XMLDOM.DOMNodeList; -- base nodes
1631: att_node_list XMLDOM.DOMNodeList; -- attribute nodes
1632: dom_node XMLDOM.DOMNode; -- base node
1633: total_att_count NUMBER; -- temp variable to hold total count of attributes found
1634: temp_node_list XMLDOM.DOMNodeList; -- temporary nodes for use inside creation loop
1635: temp_node XMLDOM.DOMNode;

Line 1632: dom_node XMLDOM.DOMNode; -- base node

1628: xml_parser XMLPARSER.parser;
1629: dom_doc XMLDOM.DOMDocument;
1630: dom_node_list XMLDOM.DOMNodeList; -- base nodes
1631: att_node_list XMLDOM.DOMNodeList; -- attribute nodes
1632: dom_node XMLDOM.DOMNode; -- base node
1633: total_att_count NUMBER; -- temp variable to hold total count of attributes found
1634: temp_node_list XMLDOM.DOMNodeList; -- temporary nodes for use inside creation loop
1635: temp_node XMLDOM.DOMNode;
1636: char_data XMLDOM.DOMCharacterData;

Line 1634: temp_node_list XMLDOM.DOMNodeList; -- temporary nodes for use inside creation loop

1630: dom_node_list XMLDOM.DOMNodeList; -- base nodes
1631: att_node_list XMLDOM.DOMNodeList; -- attribute nodes
1632: dom_node XMLDOM.DOMNode; -- base node
1633: total_att_count NUMBER; -- temp variable to hold total count of attributes found
1634: temp_node_list XMLDOM.DOMNodeList; -- temporary nodes for use inside creation loop
1635: temp_node XMLDOM.DOMNode;
1636: char_data XMLDOM.DOMCharacterData;
1637: counter NUMBER := 1; -- variable for return arrays(tables)
1638:

Line 1635: temp_node XMLDOM.DOMNode;

1631: att_node_list XMLDOM.DOMNodeList; -- attribute nodes
1632: dom_node XMLDOM.DOMNode; -- base node
1633: total_att_count NUMBER; -- temp variable to hold total count of attributes found
1634: temp_node_list XMLDOM.DOMNodeList; -- temporary nodes for use inside creation loop
1635: temp_node XMLDOM.DOMNode;
1636: char_data XMLDOM.DOMCharacterData;
1637: counter NUMBER := 1; -- variable for return arrays(tables)
1638:
1639: CHUNKSIZE CONSTANT NUMBER := 4000;

Line 1636: char_data XMLDOM.DOMCharacterData;

1632: dom_node XMLDOM.DOMNode; -- base node
1633: total_att_count NUMBER; -- temp variable to hold total count of attributes found
1634: temp_node_list XMLDOM.DOMNodeList; -- temporary nodes for use inside creation loop
1635: temp_node XMLDOM.DOMNode;
1636: char_data XMLDOM.DOMCharacterData;
1637: counter NUMBER := 1; -- variable for return arrays(tables)
1638:
1639: CHUNKSIZE CONSTANT NUMBER := 4000;
1640: l_res_buffer VARCHAR2(32767);

Line 1714: --dom_node_list := XMLDOM.getElementsByTagName(dom_doc, p_ctype_code);

1710: XMLPARSER.parseClob(xml_parser, temp_bundle);
1711: -- getting document
1712: dom_doc := XMLPARSER.getDocument(xml_parser);
1713: -- getting base node
1714: --dom_node_list := XMLDOM.getElementsByTagName(dom_doc, p_ctype_code);
1715: --dom_node := XMLDOM.item(dom_node_list, 0);
1716: dom_node := XMLDOM.makeNode(XMLDOM.getDocumentElement(dom_doc));
1717: -- getting child nodes
1718: att_node_list := XMLDOM.getChildNodes(dom_node);

Line 1715: --dom_node := XMLDOM.item(dom_node_list, 0);

1711: -- getting document
1712: dom_doc := XMLPARSER.getDocument(xml_parser);
1713: -- getting base node
1714: --dom_node_list := XMLDOM.getElementsByTagName(dom_doc, p_ctype_code);
1715: --dom_node := XMLDOM.item(dom_node_list, 0);
1716: dom_node := XMLDOM.makeNode(XMLDOM.getDocumentElement(dom_doc));
1717: -- getting child nodes
1718: att_node_list := XMLDOM.getChildNodes(dom_node);
1719: total_att_count := XMLDOM.getLength(att_node_list);

Line 1716: dom_node := XMLDOM.makeNode(XMLDOM.getDocumentElement(dom_doc));

1712: dom_doc := XMLPARSER.getDocument(xml_parser);
1713: -- getting base node
1714: --dom_node_list := XMLDOM.getElementsByTagName(dom_doc, p_ctype_code);
1715: --dom_node := XMLDOM.item(dom_node_list, 0);
1716: dom_node := XMLDOM.makeNode(XMLDOM.getDocumentElement(dom_doc));
1717: -- getting child nodes
1718: att_node_list := XMLDOM.getChildNodes(dom_node);
1719: total_att_count := XMLDOM.getLength(att_node_list);
1720:

Line 1718: att_node_list := XMLDOM.getChildNodes(dom_node);

1714: --dom_node_list := XMLDOM.getElementsByTagName(dom_doc, p_ctype_code);
1715: --dom_node := XMLDOM.item(dom_node_list, 0);
1716: dom_node := XMLDOM.makeNode(XMLDOM.getDocumentElement(dom_doc));
1717: -- getting child nodes
1718: att_node_list := XMLDOM.getChildNodes(dom_node);
1719: total_att_count := XMLDOM.getLength(att_node_list);
1720:
1721: -- Tracing output to show what nodes are available for this item
1722: -- for i in 0..total_att_count-1 loop

Line 1719: total_att_count := XMLDOM.getLength(att_node_list);

1715: --dom_node := XMLDOM.item(dom_node_list, 0);
1716: dom_node := XMLDOM.makeNode(XMLDOM.getDocumentElement(dom_doc));
1717: -- getting child nodes
1718: att_node_list := XMLDOM.getChildNodes(dom_node);
1719: total_att_count := XMLDOM.getLength(att_node_list);
1720:
1721: -- Tracing output to show what nodes are available for this item
1722: -- for i in 0..total_att_count-1 loop
1723: -- --DBMS_OUTPUT.put_line(XMLDOM.getNodeName(XMLDOM.item(att_node_list, i)));

Line 1723: -- --DBMS_OUTPUT.put_line(XMLDOM.getNodeName(XMLDOM.item(att_node_list, i)));

1719: total_att_count := XMLDOM.getLength(att_node_list);
1720:
1721: -- Tracing output to show what nodes are available for this item
1722: -- for i in 0..total_att_count-1 loop
1723: -- --DBMS_OUTPUT.put_line(XMLDOM.getNodeName(XMLDOM.item(att_node_list, i)));
1724: -- end loop;
1725:
1726: -- Loading attribute information
1727: FOR i IN 0..total_att_count-1 LOOP

Line 1730: IF ( (XMLDOM.getNodeName(XMLDOM.item(att_node_list, i)) <> 'NAME') AND

1726: -- Loading attribute information
1727: FOR i IN 0..total_att_count-1 LOOP
1728:
1729: -- ignoring the built-in attributes
1730: IF ( (XMLDOM.getNodeName(XMLDOM.item(att_node_list, i)) <> 'NAME') AND
1731: (XMLDOM.getNodeName(XMLDOM.item(att_node_list, i)) <> 'DESCRIPTION') ) THEN
1732: attribute_type_codes.extend;
1733: attribute_type_names.extend;
1734: attributes.extend;

Line 1731: (XMLDOM.getNodeName(XMLDOM.item(att_node_list, i)) <> 'DESCRIPTION') ) THEN

1727: FOR i IN 0..total_att_count-1 LOOP
1728:
1729: -- ignoring the built-in attributes
1730: IF ( (XMLDOM.getNodeName(XMLDOM.item(att_node_list, i)) <> 'NAME') AND
1731: (XMLDOM.getNodeName(XMLDOM.item(att_node_list, i)) <> 'DESCRIPTION') ) THEN
1732: attribute_type_codes.extend;
1733: attribute_type_names.extend;
1734: attributes.extend;
1735: atc := XMLDOM.getNodeName(XMLDOM.item(att_node_list, i));

Line 1735: atc := XMLDOM.getNodeName(XMLDOM.item(att_node_list, i));

1731: (XMLDOM.getNodeName(XMLDOM.item(att_node_list, i)) <> 'DESCRIPTION') ) THEN
1732: attribute_type_codes.extend;
1733: attribute_type_names.extend;
1734: attributes.extend;
1735: atc := XMLDOM.getNodeName(XMLDOM.item(att_node_list, i));
1736:
1737: SELECT
1738: attl.attribute_type_name,
1739: atb.data_type_code

Line 1760: temp_node := XMLDOM.getFirstChild(XMLDOM.item(att_node_list, i));

1756:
1757: attribute_type_codes(counter) := atc;
1758: attribute_type_names(counter) := atn;
1759:
1760: temp_node := XMLDOM.getFirstChild(XMLDOM.item(att_node_list, i));
1761: attributes(counter) := NULL;
1762: IF (NOT XMLDOM.isNull(temp_node)) THEN
1763: -- Reading Data from XML node thru char_Data because of 4K limitation
1764: -- Replacing: attributes(counter) := XMLDOM.getNodeValue(temp_node);

Line 1762: IF (NOT XMLDOM.isNull(temp_node)) THEN

1758: attribute_type_names(counter) := atn;
1759:
1760: temp_node := XMLDOM.getFirstChild(XMLDOM.item(att_node_list, i));
1761: attributes(counter) := NULL;
1762: IF (NOT XMLDOM.isNull(temp_node)) THEN
1763: -- Reading Data from XML node thru char_Data because of 4K limitation
1764: -- Replacing: attributes(counter) := XMLDOM.getNodeValue(temp_node);
1765: char_data := XMLDOM.makecharacterdata(temp_node);
1766: l_total_length := XMLDOM.getlength(char_data);

Line 1764: -- Replacing: attributes(counter) := XMLDOM.getNodeValue(temp_node);

1760: temp_node := XMLDOM.getFirstChild(XMLDOM.item(att_node_list, i));
1761: attributes(counter) := NULL;
1762: IF (NOT XMLDOM.isNull(temp_node)) THEN
1763: -- Reading Data from XML node thru char_Data because of 4K limitation
1764: -- Replacing: attributes(counter) := XMLDOM.getNodeValue(temp_node);
1765: char_data := XMLDOM.makecharacterdata(temp_node);
1766: l_total_length := XMLDOM.getlength(char_data);
1767:
1768: WHILE l_total_length > 0 LOOP

Line 1765: char_data := XMLDOM.makecharacterdata(temp_node);

1761: attributes(counter) := NULL;
1762: IF (NOT XMLDOM.isNull(temp_node)) THEN
1763: -- Reading Data from XML node thru char_Data because of 4K limitation
1764: -- Replacing: attributes(counter) := XMLDOM.getNodeValue(temp_node);
1765: char_data := XMLDOM.makecharacterdata(temp_node);
1766: l_total_length := XMLDOM.getlength(char_data);
1767:
1768: WHILE l_total_length > 0 LOOP
1769:

Line 1766: l_total_length := XMLDOM.getlength(char_data);

1762: IF (NOT XMLDOM.isNull(temp_node)) THEN
1763: -- Reading Data from XML node thru char_Data because of 4K limitation
1764: -- Replacing: attributes(counter) := XMLDOM.getNodeValue(temp_node);
1765: char_data := XMLDOM.makecharacterdata(temp_node);
1766: l_total_length := XMLDOM.getlength(char_data);
1767:
1768: WHILE l_total_length > 0 LOOP
1769:
1770: IF l_total_length > CHUNKSIZE THEN

Line 1771: l_res_buffer := XMLDOM.substringdata(char_data,XMLDOM.getlength(char_data) - l_total_length,CHUNKSIZE);

1767:
1768: WHILE l_total_length > 0 LOOP
1769:
1770: IF l_total_length > CHUNKSIZE THEN
1771: l_res_buffer := XMLDOM.substringdata(char_data,XMLDOM.getlength(char_data) - l_total_length,CHUNKSIZE);
1772: ELSE
1773: l_res_buffer := XMLDOM.substringdata(char_data,XMLDOM.getlength(char_data) - l_total_length, l_total_length);
1774: END IF;
1775:

Line 1773: l_res_buffer := XMLDOM.substringdata(char_data,XMLDOM.getlength(char_data) - l_total_length, l_total_length);

1769:
1770: IF l_total_length > CHUNKSIZE THEN
1771: l_res_buffer := XMLDOM.substringdata(char_data,XMLDOM.getlength(char_data) - l_total_length,CHUNKSIZE);
1772: ELSE
1773: l_res_buffer := XMLDOM.substringdata(char_data,XMLDOM.getlength(char_data) - l_total_length, l_total_length);
1774: END IF;
1775:
1776: l_total_length := l_total_length - LENGTH(l_res_buffer);
1777: attributes(counter) := attributes(counter) || l_res_buffer;

Line 2491: dom_doc XMLDOM.DOMDocument;

2487: citem_desc IBC_CITEM_VERSIONS_TL.description%TYPE; -- content item description
2488: attach_file_id IBC_CITEM_VERSIONS_TL.attachment_file_id%TYPE;
2489: temp_bundle CLOB; -- temporary clob to hold text information while creating
2490: xml_parser XMLPARSER.parser;
2491: dom_doc XMLDOM.DOMDocument;
2492: dom_node_list XMLDOM.DOMNodeList; -- base nodes
2493: att_node_list XMLDOM.DOMNodeList; -- attribute nodes
2494: temp_node_list XMLDOM.DOMNodeList; -- temporary nodes for use inside validation loop
2495: dom_node XMLDOM.DOMNode; -- base node

Line 2492: dom_node_list XMLDOM.DOMNodeList; -- base nodes

2488: attach_file_id IBC_CITEM_VERSIONS_TL.attachment_file_id%TYPE;
2489: temp_bundle CLOB; -- temporary clob to hold text information while creating
2490: xml_parser XMLPARSER.parser;
2491: dom_doc XMLDOM.DOMDocument;
2492: dom_node_list XMLDOM.DOMNodeList; -- base nodes
2493: att_node_list XMLDOM.DOMNodeList; -- attribute nodes
2494: temp_node_list XMLDOM.DOMNodeList; -- temporary nodes for use inside validation loop
2495: dom_node XMLDOM.DOMNode; -- base node
2496: temp_node XMLDOM.DOMNode; -- temp node for use inside validation loop

Line 2493: att_node_list XMLDOM.DOMNodeList; -- attribute nodes

2489: temp_bundle CLOB; -- temporary clob to hold text information while creating
2490: xml_parser XMLPARSER.parser;
2491: dom_doc XMLDOM.DOMDocument;
2492: dom_node_list XMLDOM.DOMNodeList; -- base nodes
2493: att_node_list XMLDOM.DOMNodeList; -- attribute nodes
2494: temp_node_list XMLDOM.DOMNodeList; -- temporary nodes for use inside validation loop
2495: dom_node XMLDOM.DOMNode; -- base node
2496: temp_node XMLDOM.DOMNode; -- temp node for use inside validation loop
2497: valid_element_count NUMBER; -- temp variable to hold count of how many valid elements found

Line 2494: temp_node_list XMLDOM.DOMNodeList; -- temporary nodes for use inside validation loop

2490: xml_parser XMLPARSER.parser;
2491: dom_doc XMLDOM.DOMDocument;
2492: dom_node_list XMLDOM.DOMNodeList; -- base nodes
2493: att_node_list XMLDOM.DOMNodeList; -- attribute nodes
2494: temp_node_list XMLDOM.DOMNodeList; -- temporary nodes for use inside validation loop
2495: dom_node XMLDOM.DOMNode; -- base node
2496: temp_node XMLDOM.DOMNode; -- temp node for use inside validation loop
2497: valid_element_count NUMBER; -- temp variable to hold count of how many valid elements found
2498: total_att_count NUMBER; -- temp variable to hold total count of attributes found

Line 2495: dom_node XMLDOM.DOMNode; -- base node

2491: dom_doc XMLDOM.DOMDocument;
2492: dom_node_list XMLDOM.DOMNodeList; -- base nodes
2493: att_node_list XMLDOM.DOMNodeList; -- attribute nodes
2494: temp_node_list XMLDOM.DOMNodeList; -- temporary nodes for use inside validation loop
2495: dom_node XMLDOM.DOMNode; -- base node
2496: temp_node XMLDOM.DOMNode; -- temp node for use inside validation loop
2497: valid_element_count NUMBER; -- temp variable to hold count of how many valid elements found
2498: total_att_count NUMBER; -- temp variable to hold total count of attributes found
2499:

Line 2496: temp_node XMLDOM.DOMNode; -- temp node for use inside validation loop

2492: dom_node_list XMLDOM.DOMNodeList; -- base nodes
2493: att_node_list XMLDOM.DOMNodeList; -- attribute nodes
2494: temp_node_list XMLDOM.DOMNodeList; -- temporary nodes for use inside validation loop
2495: dom_node XMLDOM.DOMNode; -- base node
2496: temp_node XMLDOM.DOMNode; -- temp node for use inside validation loop
2497: valid_element_count NUMBER; -- temp variable to hold count of how many valid elements found
2498: total_att_count NUMBER; -- temp variable to hold total count of attributes found
2499:
2500: -- used to loop through all the attributes

Line 2523: char_data XMLDOM.DOMCharacterData;

2519:
2520:
2521: node_value VARCHAR2(32767);
2522:
2523: char_data XMLDOM.DOMCharacterData;
2524: CHUNKSIZE CONSTANT NUMBER := 4000;
2525: l_res_buffer VARCHAR2(32767);
2526: l_total_length NUMBER;
2527:

Line 2624: --dom_node_list := XMLDOM.getElementsByTagName(dom_doc, ctype_code);

2620: XMLPARSER.parseClob(xml_parser, temp_bundle);
2621: -- getting document
2622: dom_doc := XMLPARSER.getDocument(xml_parser);
2623: -- getting base node
2624: --dom_node_list := XMLDOM.getElementsByTagName(dom_doc, ctype_code);
2625: --dom_node := XMLDOM.item(dom_node_list, 0);
2626: dom_node := XMLDOM.makeNode(XMLDOM.getDocumentElement(dom_doc));
2627: -- getting child nodes
2628: att_node_list := XMLDOM.getChildNodes(dom_node);

Line 2625: --dom_node := XMLDOM.item(dom_node_list, 0);

2621: -- getting document
2622: dom_doc := XMLPARSER.getDocument(xml_parser);
2623: -- getting base node
2624: --dom_node_list := XMLDOM.getElementsByTagName(dom_doc, ctype_code);
2625: --dom_node := XMLDOM.item(dom_node_list, 0);
2626: dom_node := XMLDOM.makeNode(XMLDOM.getDocumentElement(dom_doc));
2627: -- getting child nodes
2628: att_node_list := XMLDOM.getChildNodes(dom_node);
2629: total_att_count := XMLDOM.getLength(att_node_list);

Line 2626: dom_node := XMLDOM.makeNode(XMLDOM.getDocumentElement(dom_doc));

2622: dom_doc := XMLPARSER.getDocument(xml_parser);
2623: -- getting base node
2624: --dom_node_list := XMLDOM.getElementsByTagName(dom_doc, ctype_code);
2625: --dom_node := XMLDOM.item(dom_node_list, 0);
2626: dom_node := XMLDOM.makeNode(XMLDOM.getDocumentElement(dom_doc));
2627: -- getting child nodes
2628: att_node_list := XMLDOM.getChildNodes(dom_node);
2629: total_att_count := XMLDOM.getLength(att_node_list);
2630:

Line 2628: att_node_list := XMLDOM.getChildNodes(dom_node);

2624: --dom_node_list := XMLDOM.getElementsByTagName(dom_doc, ctype_code);
2625: --dom_node := XMLDOM.item(dom_node_list, 0);
2626: dom_node := XMLDOM.makeNode(XMLDOM.getDocumentElement(dom_doc));
2627: -- getting child nodes
2628: att_node_list := XMLDOM.getChildNodes(dom_node);
2629: total_att_count := XMLDOM.getLength(att_node_list);
2630:
2631: -- Tracing output of XML content
2632: --IF IBC_DEBUG_PVT.debug_enabled THEN

Line 2629: total_att_count := XMLDOM.getLength(att_node_list);

2625: --dom_node := XMLDOM.item(dom_node_list, 0);
2626: dom_node := XMLDOM.makeNode(XMLDOM.getDocumentElement(dom_doc));
2627: -- getting child nodes
2628: att_node_list := XMLDOM.getChildNodes(dom_node);
2629: total_att_count := XMLDOM.getLength(att_node_list);
2630:
2631: -- Tracing output of XML content
2632: --IF IBC_DEBUG_PVT.debug_enabled THEN
2633: -- DECLARE

Line 2649: -- --DBMS_OUTPUT.put_line(XMLDOM.getNodeName(XMLDOM.item(att_node_list, i)));

2645: --END IF;
2646:
2647: -- Tracing output to show what nodes are available for this item
2648: -- for i in 0..total_att_count-1 loop
2649: -- --DBMS_OUTPUT.put_line(XMLDOM.getNodeName(XMLDOM.item(att_node_list, i)));
2650: -- end loop;
2651:
2652: -- VALIDATION LOOP
2653: FOR r_attribute IN c_attributes(ctype_code) LOOP

Line 2744: temp_node_list := XMLDOM.getChildrenByTagName(XMLDOM.makeElement(dom_node), r_attribute.atc);

2740:
2741: -- data type code -- (validated on insert)
2742:
2743: -- finding and counting all the elements that are of this attribute type
2744: temp_node_list := XMLDOM.getChildrenByTagName(XMLDOM.makeElement(dom_node), r_attribute.atc);
2745: valid_element_count := XMLDOM.getLength(temp_node_list);
2746:
2747: -- mini
2748: IF (valid_element_count < r_attribute.mini) THEN

Line 2745: valid_element_count := XMLDOM.getLength(temp_node_list);

2741: -- data type code -- (validated on insert)
2742:
2743: -- finding and counting all the elements that are of this attribute type
2744: temp_node_list := XMLDOM.getChildrenByTagName(XMLDOM.makeElement(dom_node), r_attribute.atc);
2745: valid_element_count := XMLDOM.getLength(temp_node_list);
2746:
2747: -- mini
2748: IF (valid_element_count < r_attribute.mini) THEN
2749: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2778: temp_node := XMLDOM.getFirstChild(XMLDOM.item(temp_node_list, i));

2774: -- looping through all elements this type to check size and value (vs. default)
2775: FOR i IN 0..valid_element_count-1 LOOP
2776:
2777: -- getting node value
2778: temp_node := XMLDOM.getFirstChild(XMLDOM.item(temp_node_list, i));
2779:
2780: node_value := NULL;
2781: IF (NOT XMLDOM.isNull(temp_node)) THEN
2782: -- Reading Data from XML node thru char_Data because of 4K limitation

Line 2781: IF (NOT XMLDOM.isNull(temp_node)) THEN

2777: -- getting node value
2778: temp_node := XMLDOM.getFirstChild(XMLDOM.item(temp_node_list, i));
2779:
2780: node_value := NULL;
2781: IF (NOT XMLDOM.isNull(temp_node)) THEN
2782: -- Reading Data from XML node thru char_Data because of 4K limitation
2783: -- Replacing: node_value := XMLDOM.getNodeValue(temp_node);
2784: char_data := XMLDOM.makecharacterdata(temp_node);
2785: l_total_length := XMLDOM.getlength(char_data);

Line 2783: -- Replacing: node_value := XMLDOM.getNodeValue(temp_node);

2779:
2780: node_value := NULL;
2781: IF (NOT XMLDOM.isNull(temp_node)) THEN
2782: -- Reading Data from XML node thru char_Data because of 4K limitation
2783: -- Replacing: node_value := XMLDOM.getNodeValue(temp_node);
2784: char_data := XMLDOM.makecharacterdata(temp_node);
2785: l_total_length := XMLDOM.getlength(char_data);
2786:
2787: WHILE l_total_length > 0 LOOP

Line 2784: char_data := XMLDOM.makecharacterdata(temp_node);

2780: node_value := NULL;
2781: IF (NOT XMLDOM.isNull(temp_node)) THEN
2782: -- Reading Data from XML node thru char_Data because of 4K limitation
2783: -- Replacing: node_value := XMLDOM.getNodeValue(temp_node);
2784: char_data := XMLDOM.makecharacterdata(temp_node);
2785: l_total_length := XMLDOM.getlength(char_data);
2786:
2787: WHILE l_total_length > 0 LOOP
2788:

Line 2785: l_total_length := XMLDOM.getlength(char_data);

2781: IF (NOT XMLDOM.isNull(temp_node)) THEN
2782: -- Reading Data from XML node thru char_Data because of 4K limitation
2783: -- Replacing: node_value := XMLDOM.getNodeValue(temp_node);
2784: char_data := XMLDOM.makecharacterdata(temp_node);
2785: l_total_length := XMLDOM.getlength(char_data);
2786:
2787: WHILE l_total_length > 0 LOOP
2788:
2789: IF l_total_length > CHUNKSIZE THEN

Line 2790: l_res_buffer := XMLDOM.substringdata(char_data,XMLDOM.getlength(char_data) - l_total_length,CHUNKSIZE);

2786:
2787: WHILE l_total_length > 0 LOOP
2788:
2789: IF l_total_length > CHUNKSIZE THEN
2790: l_res_buffer := XMLDOM.substringdata(char_data,XMLDOM.getlength(char_data) - l_total_length,CHUNKSIZE);
2791: ELSE
2792: l_res_buffer := XMLDOM.substringdata(char_data,XMLDOM.getlength(char_data) - l_total_length, l_total_length);
2793: END IF;
2794:

Line 2792: l_res_buffer := XMLDOM.substringdata(char_data,XMLDOM.getlength(char_data) - l_total_length, l_total_length);

2788:
2789: IF l_total_length > CHUNKSIZE THEN
2790: l_res_buffer := XMLDOM.substringdata(char_data,XMLDOM.getlength(char_data) - l_total_length,CHUNKSIZE);
2791: ELSE
2792: l_res_buffer := XMLDOM.substringdata(char_data,XMLDOM.getlength(char_data) - l_total_length, l_total_length);
2793: END IF;
2794:
2795: l_total_length := l_total_length - LENGTH(l_res_buffer);
2796: