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.CSR_RULES_PVT dependencies on DBMS_XMLDOM

Line 12: TYPE node_tbl_type IS TABLE OF DBMS_XMLDOM.DOMNode;

8:
9: -- Parameter Name and XPath Map
10: g_rule_param_names_tbl jtf_varchar2_table_300;
11:
12: TYPE node_tbl_type IS TABLE OF DBMS_XMLDOM.DOMNode;
13:
14: PROCEDURE debug(p_message VARCHAR2, p_module VARCHAR2, p_level NUMBER) IS
15: BEGIN
16: IF p_level >= fnd_profile.value_specific('AFLOG_LEVEL') THEN

Line 135: p_rule_dom DBMS_XMLDOM.DOMDocument

131: END IF;
132: END is_param_valid_for_eligibility;
133:
134: FUNCTION get_param_grp_dom_node(
135: p_rule_dom DBMS_XMLDOM.DOMDocument
136: , p_tag_name VARCHAR2
137: , p_create BOOLEAN
138: )
139: RETURN DBMS_XMLDOM.DOMNode IS

Line 139: RETURN DBMS_XMLDOM.DOMNode IS

135: p_rule_dom DBMS_XMLDOM.DOMDocument
136: , p_tag_name VARCHAR2
137: , p_create BOOLEAN
138: )
139: RETURN DBMS_XMLDOM.DOMNode IS
140: l_dom_node DBMS_XMLDOM.DOMNode;
141: BEGIN
142: l_dom_node := DBMS_XMLDOM.item(DBMS_XMLDOM.getElementsByTagName(p_rule_dom, p_tag_name), 0);
143: IF DBMS_XMLDOM.isNull(l_dom_node) AND p_create THEN

Line 140: l_dom_node DBMS_XMLDOM.DOMNode;

136: , p_tag_name VARCHAR2
137: , p_create BOOLEAN
138: )
139: RETURN DBMS_XMLDOM.DOMNode IS
140: l_dom_node DBMS_XMLDOM.DOMNode;
141: BEGIN
142: l_dom_node := DBMS_XMLDOM.item(DBMS_XMLDOM.getElementsByTagName(p_rule_dom, p_tag_name), 0);
143: IF DBMS_XMLDOM.isNull(l_dom_node) AND p_create THEN
144: l_dom_node :=

Line 142: l_dom_node := DBMS_XMLDOM.item(DBMS_XMLDOM.getElementsByTagName(p_rule_dom, p_tag_name), 0);

138: )
139: RETURN DBMS_XMLDOM.DOMNode IS
140: l_dom_node DBMS_XMLDOM.DOMNode;
141: BEGIN
142: l_dom_node := DBMS_XMLDOM.item(DBMS_XMLDOM.getElementsByTagName(p_rule_dom, p_tag_name), 0);
143: IF DBMS_XMLDOM.isNull(l_dom_node) AND p_create THEN
144: l_dom_node :=
145: DBMS_XMLDOM.appendChild(
146: DBMS_XMLDOM.MAKENODE(DBMS_XMLDOM.getDocumentElement(p_rule_dom))

Line 143: IF DBMS_XMLDOM.isNull(l_dom_node) AND p_create THEN

139: RETURN DBMS_XMLDOM.DOMNode IS
140: l_dom_node DBMS_XMLDOM.DOMNode;
141: BEGIN
142: l_dom_node := DBMS_XMLDOM.item(DBMS_XMLDOM.getElementsByTagName(p_rule_dom, p_tag_name), 0);
143: IF DBMS_XMLDOM.isNull(l_dom_node) AND p_create THEN
144: l_dom_node :=
145: DBMS_XMLDOM.appendChild(
146: DBMS_XMLDOM.MAKENODE(DBMS_XMLDOM.getDocumentElement(p_rule_dom))
147: , DBMS_XMLDOM.MAKENODE(DBMS_XMLDOM.createElement(p_rule_dom, p_tag_name, g_rules_ns))

Line 145: DBMS_XMLDOM.appendChild(

141: BEGIN
142: l_dom_node := DBMS_XMLDOM.item(DBMS_XMLDOM.getElementsByTagName(p_rule_dom, p_tag_name), 0);
143: IF DBMS_XMLDOM.isNull(l_dom_node) AND p_create THEN
144: l_dom_node :=
145: DBMS_XMLDOM.appendChild(
146: DBMS_XMLDOM.MAKENODE(DBMS_XMLDOM.getDocumentElement(p_rule_dom))
147: , DBMS_XMLDOM.MAKENODE(DBMS_XMLDOM.createElement(p_rule_dom, p_tag_name, g_rules_ns))
148: );
149: END IF;

Line 146: DBMS_XMLDOM.MAKENODE(DBMS_XMLDOM.getDocumentElement(p_rule_dom))

142: l_dom_node := DBMS_XMLDOM.item(DBMS_XMLDOM.getElementsByTagName(p_rule_dom, p_tag_name), 0);
143: IF DBMS_XMLDOM.isNull(l_dom_node) AND p_create THEN
144: l_dom_node :=
145: DBMS_XMLDOM.appendChild(
146: DBMS_XMLDOM.MAKENODE(DBMS_XMLDOM.getDocumentElement(p_rule_dom))
147: , DBMS_XMLDOM.MAKENODE(DBMS_XMLDOM.createElement(p_rule_dom, p_tag_name, g_rules_ns))
148: );
149: END IF;
150:

Line 147: , DBMS_XMLDOM.MAKENODE(DBMS_XMLDOM.createElement(p_rule_dom, p_tag_name, g_rules_ns))

143: IF DBMS_XMLDOM.isNull(l_dom_node) AND p_create THEN
144: l_dom_node :=
145: DBMS_XMLDOM.appendChild(
146: DBMS_XMLDOM.MAKENODE(DBMS_XMLDOM.getDocumentElement(p_rule_dom))
147: , DBMS_XMLDOM.MAKENODE(DBMS_XMLDOM.createElement(p_rule_dom, p_tag_name, g_rules_ns))
148: );
149: END IF;
150:
151: RETURN l_dom_node;

Line 570: l_rule_document DBMS_XMLDOM.DOMDocument;

566: , p_old_rule_doc XMLTYPE
567: , p_window_names jtf_varchar2_table_300
568: , p_window_descriptions jtf_varchar2_table_1500
569: ) IS
570: l_rule_document DBMS_XMLDOM.DOMDocument;
571: l_root_element DBMS_XMLDOM.DOMElement;
572: l_window_nodelist DBMS_XMLDOM.DOMNodelist;
573: l_num_of_windows PLS_INTEGER;
574: l_window_node DBMS_XMLDOM.DOMNode;

Line 571: l_root_element DBMS_XMLDOM.DOMElement;

567: , p_window_names jtf_varchar2_table_300
568: , p_window_descriptions jtf_varchar2_table_1500
569: ) IS
570: l_rule_document DBMS_XMLDOM.DOMDocument;
571: l_root_element DBMS_XMLDOM.DOMElement;
572: l_window_nodelist DBMS_XMLDOM.DOMNodelist;
573: l_num_of_windows PLS_INTEGER;
574: l_window_node DBMS_XMLDOM.DOMNode;
575: l_window_attrs DBMS_XMLDOM.DOMNamedNodeMap;

Line 572: l_window_nodelist DBMS_XMLDOM.DOMNodelist;

568: , p_window_descriptions jtf_varchar2_table_1500
569: ) IS
570: l_rule_document DBMS_XMLDOM.DOMDocument;
571: l_root_element DBMS_XMLDOM.DOMElement;
572: l_window_nodelist DBMS_XMLDOM.DOMNodelist;
573: l_num_of_windows PLS_INTEGER;
574: l_window_node DBMS_XMLDOM.DOMNode;
575: l_window_attrs DBMS_XMLDOM.DOMNamedNodeMap;
576: l_window_id_node DBMS_XMLDOM.DOMNode;

Line 574: l_window_node DBMS_XMLDOM.DOMNode;

570: l_rule_document DBMS_XMLDOM.DOMDocument;
571: l_root_element DBMS_XMLDOM.DOMElement;
572: l_window_nodelist DBMS_XMLDOM.DOMNodelist;
573: l_num_of_windows PLS_INTEGER;
574: l_window_node DBMS_XMLDOM.DOMNode;
575: l_window_attrs DBMS_XMLDOM.DOMNamedNodeMap;
576: l_window_id_node DBMS_XMLDOM.DOMNode;
577: l_window_id PLS_INTEGER;
578: l_windows_id_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

Line 575: l_window_attrs DBMS_XMLDOM.DOMNamedNodeMap;

571: l_root_element DBMS_XMLDOM.DOMElement;
572: l_window_nodelist DBMS_XMLDOM.DOMNodelist;
573: l_num_of_windows PLS_INTEGER;
574: l_window_node DBMS_XMLDOM.DOMNode;
575: l_window_attrs DBMS_XMLDOM.DOMNamedNodeMap;
576: l_window_id_node DBMS_XMLDOM.DOMNode;
577: l_window_id PLS_INTEGER;
578: l_windows_id_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
579:

Line 576: l_window_id_node DBMS_XMLDOM.DOMNode;

572: l_window_nodelist DBMS_XMLDOM.DOMNodelist;
573: l_num_of_windows PLS_INTEGER;
574: l_window_node DBMS_XMLDOM.DOMNode;
575: l_window_attrs DBMS_XMLDOM.DOMNamedNodeMap;
576: l_window_id_node DBMS_XMLDOM.DOMNode;
577: l_window_id PLS_INTEGER;
578: l_windows_id_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
579:
580: l_debug CONSTANT VARCHAR2(1) := fnd_profile.value('AFLOG_ENABLED');

Line 585: l_rule_document := DBMS_XMLDOM.newDOMDocument(p_new_rule_doc);

581: l_api_name CONSTANT VARCHAR2(30) := 'HANDLE_RULE_WINDOWS';
582: BEGIN
583:
584: -- Loop through the New Document to find out whether we have Windows Defined.
585: l_rule_document := DBMS_XMLDOM.newDOMDocument(p_new_rule_doc);
586: l_root_element := DBMS_XMLDOM.getDocumentElement(l_rule_document);
587: l_window_nodelist := DBMS_XMLDOM.getElementsByTagName(l_root_element, 'window');
588: l_num_of_windows := DBMS_XMLDOM.GetLength(l_window_nodelist);
589: FOR i IN 1..l_num_of_windows LOOP

Line 586: l_root_element := DBMS_XMLDOM.getDocumentElement(l_rule_document);

582: BEGIN
583:
584: -- Loop through the New Document to find out whether we have Windows Defined.
585: l_rule_document := DBMS_XMLDOM.newDOMDocument(p_new_rule_doc);
586: l_root_element := DBMS_XMLDOM.getDocumentElement(l_rule_document);
587: l_window_nodelist := DBMS_XMLDOM.getElementsByTagName(l_root_element, 'window');
588: l_num_of_windows := DBMS_XMLDOM.GetLength(l_window_nodelist);
589: FOR i IN 1..l_num_of_windows LOOP
590: l_window_node := DBMS_XMLDOM.item(l_window_nodelist, i-1);

Line 587: l_window_nodelist := DBMS_XMLDOM.getElementsByTagName(l_root_element, 'window');

583:
584: -- Loop through the New Document to find out whether we have Windows Defined.
585: l_rule_document := DBMS_XMLDOM.newDOMDocument(p_new_rule_doc);
586: l_root_element := DBMS_XMLDOM.getDocumentElement(l_rule_document);
587: l_window_nodelist := DBMS_XMLDOM.getElementsByTagName(l_root_element, 'window');
588: l_num_of_windows := DBMS_XMLDOM.GetLength(l_window_nodelist);
589: FOR i IN 1..l_num_of_windows LOOP
590: l_window_node := DBMS_XMLDOM.item(l_window_nodelist, i-1);
591: l_window_attrs := DBMS_XMLDOM.getAttributes(l_window_node);

Line 588: l_num_of_windows := DBMS_XMLDOM.GetLength(l_window_nodelist);

584: -- Loop through the New Document to find out whether we have Windows Defined.
585: l_rule_document := DBMS_XMLDOM.newDOMDocument(p_new_rule_doc);
586: l_root_element := DBMS_XMLDOM.getDocumentElement(l_rule_document);
587: l_window_nodelist := DBMS_XMLDOM.getElementsByTagName(l_root_element, 'window');
588: l_num_of_windows := DBMS_XMLDOM.GetLength(l_window_nodelist);
589: FOR i IN 1..l_num_of_windows LOOP
590: l_window_node := DBMS_XMLDOM.item(l_window_nodelist, i-1);
591: l_window_attrs := DBMS_XMLDOM.getAttributes(l_window_node);
592: l_window_id_node := DBMS_XMLDOM.getNamedItem(l_window_attrs, 'windowId');

Line 590: l_window_node := DBMS_XMLDOM.item(l_window_nodelist, i-1);

586: l_root_element := DBMS_XMLDOM.getDocumentElement(l_rule_document);
587: l_window_nodelist := DBMS_XMLDOM.getElementsByTagName(l_root_element, 'window');
588: l_num_of_windows := DBMS_XMLDOM.GetLength(l_window_nodelist);
589: FOR i IN 1..l_num_of_windows LOOP
590: l_window_node := DBMS_XMLDOM.item(l_window_nodelist, i-1);
591: l_window_attrs := DBMS_XMLDOM.getAttributes(l_window_node);
592: l_window_id_node := DBMS_XMLDOM.getNamedItem(l_window_attrs, 'windowId');
593: l_window_id := DBMS_XMLDOM.getNodeValue(l_window_id_node);
594: --

Line 591: l_window_attrs := DBMS_XMLDOM.getAttributes(l_window_node);

587: l_window_nodelist := DBMS_XMLDOM.getElementsByTagName(l_root_element, 'window');
588: l_num_of_windows := DBMS_XMLDOM.GetLength(l_window_nodelist);
589: FOR i IN 1..l_num_of_windows LOOP
590: l_window_node := DBMS_XMLDOM.item(l_window_nodelist, i-1);
591: l_window_attrs := DBMS_XMLDOM.getAttributes(l_window_node);
592: l_window_id_node := DBMS_XMLDOM.getNamedItem(l_window_attrs, 'windowId');
593: l_window_id := DBMS_XMLDOM.getNodeValue(l_window_id_node);
594: --
595: --adding to list so that we can compare with old WTP windows

Line 592: l_window_id_node := DBMS_XMLDOM.getNamedItem(l_window_attrs, 'windowId');

588: l_num_of_windows := DBMS_XMLDOM.GetLength(l_window_nodelist);
589: FOR i IN 1..l_num_of_windows LOOP
590: l_window_node := DBMS_XMLDOM.item(l_window_nodelist, i-1);
591: l_window_attrs := DBMS_XMLDOM.getAttributes(l_window_node);
592: l_window_id_node := DBMS_XMLDOM.getNamedItem(l_window_attrs, 'windowId');
593: l_window_id := DBMS_XMLDOM.getNodeValue(l_window_id_node);
594: --
595: --adding to list so that we can compare with old WTP windows
596: l_windows_id_list.extend;

Line 593: l_window_id := DBMS_XMLDOM.getNodeValue(l_window_id_node);

589: FOR i IN 1..l_num_of_windows LOOP
590: l_window_node := DBMS_XMLDOM.item(l_window_nodelist, i-1);
591: l_window_attrs := DBMS_XMLDOM.getAttributes(l_window_node);
592: l_window_id_node := DBMS_XMLDOM.getNamedItem(l_window_attrs, 'windowId');
593: l_window_id := DBMS_XMLDOM.getNodeValue(l_window_id_node);
594: --
595: --adding to list so that we can compare with old WTP windows
596: l_windows_id_list.extend;
597: l_windows_id_list(i):=l_window_id;

Line 628: DBMS_XMLDOM.setNodeValue(l_window_id_node, l_window_id);

624: , fnd_global.login_id
625: FROM fnd_languages l
626: WHERE l.installed_flag in ('I','B');
627:
628: DBMS_XMLDOM.setNodeValue(l_window_id_node, l_window_id);
629: ELSE
630: UPDATE csr_rule_windows_tl
631: SET window_name = p_window_names(i)
632: , description = p_window_descriptions(i)

Line 645: l_rule_document := DBMS_XMLDOM.newDOMDocument(p_old_rule_doc);

641: -- If there is any Window not defined in the New Document, but defined in the Old
642: -- Document, then we have to delete the Window Names in CSR_RULE_WINDOWS_TL
643: -- to avoid Dangling References.
644: IF p_old_rule_doc IS NOT NULL THEN
645: l_rule_document := DBMS_XMLDOM.newDOMDocument(p_old_rule_doc);
646: l_root_element := DBMS_XMLDOM.getDocumentElement(l_rule_document);
647: l_window_nodelist := DBMS_XMLDOM.getElementsByTagName(l_root_element, 'window');
648: l_num_of_windows := DBMS_XMLDOM.GetLength(l_window_nodelist);
649:

Line 646: l_root_element := DBMS_XMLDOM.getDocumentElement(l_rule_document);

642: -- Document, then we have to delete the Window Names in CSR_RULE_WINDOWS_TL
643: -- to avoid Dangling References.
644: IF p_old_rule_doc IS NOT NULL THEN
645: l_rule_document := DBMS_XMLDOM.newDOMDocument(p_old_rule_doc);
646: l_root_element := DBMS_XMLDOM.getDocumentElement(l_rule_document);
647: l_window_nodelist := DBMS_XMLDOM.getElementsByTagName(l_root_element, 'window');
648: l_num_of_windows := DBMS_XMLDOM.GetLength(l_window_nodelist);
649:
650: FOR i IN 1..l_num_of_windows LOOP

Line 647: l_window_nodelist := DBMS_XMLDOM.getElementsByTagName(l_root_element, 'window');

643: -- to avoid Dangling References.
644: IF p_old_rule_doc IS NOT NULL THEN
645: l_rule_document := DBMS_XMLDOM.newDOMDocument(p_old_rule_doc);
646: l_root_element := DBMS_XMLDOM.getDocumentElement(l_rule_document);
647: l_window_nodelist := DBMS_XMLDOM.getElementsByTagName(l_root_element, 'window');
648: l_num_of_windows := DBMS_XMLDOM.GetLength(l_window_nodelist);
649:
650: FOR i IN 1..l_num_of_windows LOOP
651: l_window_node := DBMS_XMLDOM.item(l_window_nodelist, i-1);

Line 648: l_num_of_windows := DBMS_XMLDOM.GetLength(l_window_nodelist);

644: IF p_old_rule_doc IS NOT NULL THEN
645: l_rule_document := DBMS_XMLDOM.newDOMDocument(p_old_rule_doc);
646: l_root_element := DBMS_XMLDOM.getDocumentElement(l_rule_document);
647: l_window_nodelist := DBMS_XMLDOM.getElementsByTagName(l_root_element, 'window');
648: l_num_of_windows := DBMS_XMLDOM.GetLength(l_window_nodelist);
649:
650: FOR i IN 1..l_num_of_windows LOOP
651: l_window_node := DBMS_XMLDOM.item(l_window_nodelist, i-1);
652: l_window_attrs := DBMS_XMLDOM.getAttributes(l_window_node);

Line 651: l_window_node := DBMS_XMLDOM.item(l_window_nodelist, i-1);

647: l_window_nodelist := DBMS_XMLDOM.getElementsByTagName(l_root_element, 'window');
648: l_num_of_windows := DBMS_XMLDOM.GetLength(l_window_nodelist);
649:
650: FOR i IN 1..l_num_of_windows LOOP
651: l_window_node := DBMS_XMLDOM.item(l_window_nodelist, i-1);
652: l_window_attrs := DBMS_XMLDOM.getAttributes(l_window_node);
653: l_window_id := DBMS_XMLDOM.getNodeValue(DBMS_XMLDOM.getNamedItem(l_window_attrs, 'windowId'));
654:
655: IF l_debug = 'Y' THEN

Line 652: l_window_attrs := DBMS_XMLDOM.getAttributes(l_window_node);

648: l_num_of_windows := DBMS_XMLDOM.GetLength(l_window_nodelist);
649:
650: FOR i IN 1..l_num_of_windows LOOP
651: l_window_node := DBMS_XMLDOM.item(l_window_nodelist, i-1);
652: l_window_attrs := DBMS_XMLDOM.getAttributes(l_window_node);
653: l_window_id := DBMS_XMLDOM.getNodeValue(DBMS_XMLDOM.getNamedItem(l_window_attrs, 'windowId'));
654:
655: IF l_debug = 'Y' THEN
656: debug('cheking for '||l_window_id||' with new doc window list ' , l_api_name, fnd_log.level_statement);

Line 653: l_window_id := DBMS_XMLDOM.getNodeValue(DBMS_XMLDOM.getNamedItem(l_window_attrs, 'windowId'));

649:
650: FOR i IN 1..l_num_of_windows LOOP
651: l_window_node := DBMS_XMLDOM.item(l_window_nodelist, i-1);
652: l_window_attrs := DBMS_XMLDOM.getAttributes(l_window_node);
653: l_window_id := DBMS_XMLDOM.getNodeValue(DBMS_XMLDOM.getNamedItem(l_window_attrs, 'windowId'));
654:
655: IF l_debug = 'Y' THEN
656: debug('cheking for '||l_window_id||' with new doc window list ' , l_api_name, fnd_log.level_statement);
657: END IF;

Line 676: l_baserule_dom DBMS_XMLDOM.DOMDocument;

672: , p_force IN VARCHAR2
673: ) RETURN BOOLEAN IS
674:
675: l_baserule_doc XMLTYPE;
676: l_baserule_dom DBMS_XMLDOM.DOMDocument;
677: l_childrule_dom DBMS_XMLDOM.DOMDocument;
678: l_baserule_root DBMS_XMLDOM.DOMElement;
679:
680:

Line 677: l_childrule_dom DBMS_XMLDOM.DOMDocument;

673: ) RETURN BOOLEAN IS
674:
675: l_baserule_doc XMLTYPE;
676: l_baserule_dom DBMS_XMLDOM.DOMDocument;
677: l_childrule_dom DBMS_XMLDOM.DOMDocument;
678: l_baserule_root DBMS_XMLDOM.DOMElement;
679:
680:
681: l_child DBMS_XMLDOM.DOMNode;

Line 678: l_baserule_root DBMS_XMLDOM.DOMElement;

674:
675: l_baserule_doc XMLTYPE;
676: l_baserule_dom DBMS_XMLDOM.DOMDocument;
677: l_childrule_dom DBMS_XMLDOM.DOMDocument;
678: l_baserule_root DBMS_XMLDOM.DOMElement;
679:
680:
681: l_child DBMS_XMLDOM.DOMNode;
682: l_nodelist DBMS_XMLDOM.DOMNodelist;

Line 681: l_child DBMS_XMLDOM.DOMNode;

677: l_childrule_dom DBMS_XMLDOM.DOMDocument;
678: l_baserule_root DBMS_XMLDOM.DOMElement;
679:
680:
681: l_child DBMS_XMLDOM.DOMNode;
682: l_nodelist DBMS_XMLDOM.DOMNodelist;
683: l_node DBMS_XMLDOM.DOMNode;
684: l_child_text_node DBMS_XMLDOM.DOMNode;
685: l_base_text_node DBMS_XMLDOM.DOMNode;

Line 682: l_nodelist DBMS_XMLDOM.DOMNodelist;

678: l_baserule_root DBMS_XMLDOM.DOMElement;
679:
680:
681: l_child DBMS_XMLDOM.DOMNode;
682: l_nodelist DBMS_XMLDOM.DOMNodelist;
683: l_node DBMS_XMLDOM.DOMNode;
684: l_child_text_node DBMS_XMLDOM.DOMNode;
685: l_base_text_node DBMS_XMLDOM.DOMNode;
686:

Line 683: l_node DBMS_XMLDOM.DOMNode;

679:
680:
681: l_child DBMS_XMLDOM.DOMNode;
682: l_nodelist DBMS_XMLDOM.DOMNodelist;
683: l_node DBMS_XMLDOM.DOMNode;
684: l_child_text_node DBMS_XMLDOM.DOMNode;
685: l_base_text_node DBMS_XMLDOM.DOMNode;
686:
687: l_child_node DBMS_XMLDOM.DOMNode;

Line 684: l_child_text_node DBMS_XMLDOM.DOMNode;

680:
681: l_child DBMS_XMLDOM.DOMNode;
682: l_nodelist DBMS_XMLDOM.DOMNodelist;
683: l_node DBMS_XMLDOM.DOMNode;
684: l_child_text_node DBMS_XMLDOM.DOMNode;
685: l_base_text_node DBMS_XMLDOM.DOMNode;
686:
687: l_child_node DBMS_XMLDOM.DOMNode;
688: l_child_attrs DBMS_XMLDOM.DOMNamedNodeMap;

Line 685: l_base_text_node DBMS_XMLDOM.DOMNode;

681: l_child DBMS_XMLDOM.DOMNode;
682: l_nodelist DBMS_XMLDOM.DOMNodelist;
683: l_node DBMS_XMLDOM.DOMNode;
684: l_child_text_node DBMS_XMLDOM.DOMNode;
685: l_base_text_node DBMS_XMLDOM.DOMNode;
686:
687: l_child_node DBMS_XMLDOM.DOMNode;
688: l_child_attrs DBMS_XMLDOM.DOMNamedNodeMap;
689: l_inherited VARCHAR2(1);

Line 687: l_child_node DBMS_XMLDOM.DOMNode;

683: l_node DBMS_XMLDOM.DOMNode;
684: l_child_text_node DBMS_XMLDOM.DOMNode;
685: l_base_text_node DBMS_XMLDOM.DOMNode;
686:
687: l_child_node DBMS_XMLDOM.DOMNode;
688: l_child_attrs DBMS_XMLDOM.DOMNamedNodeMap;
689: l_inherited VARCHAR2(1);
690: l_wtp_nodename CONSTANT VARCHAR2(20) := 'wtpParameters';
691: l_child_modified BOOLEAN := FALSE;

Line 688: l_child_attrs DBMS_XMLDOM.DOMNamedNodeMap;

684: l_child_text_node DBMS_XMLDOM.DOMNode;
685: l_base_text_node DBMS_XMLDOM.DOMNode;
686:
687: l_child_node DBMS_XMLDOM.DOMNode;
688: l_child_attrs DBMS_XMLDOM.DOMNamedNodeMap;
689: l_inherited VARCHAR2(1);
690: l_wtp_nodename CONSTANT VARCHAR2(20) := 'wtpParameters';
691: l_child_modified BOOLEAN := FALSE;
692:

Line 708: l_baserule_dom := DBMS_XMLDOM.newDOMDocument(l_baserule_doc);

704: RETURN TRUE;
705: END IF;
706:
707: l_baserule_doc := p_base_doc;
708: l_baserule_dom := DBMS_XMLDOM.newDOMDocument(l_baserule_doc);
709: l_baserule_root := DBMS_XMLDOM.getDocumentElement(l_baserule_dom);
710: l_child := DBMS_XMLDOM.getFirstChild(DBMS_XMLDOM.makeNode(l_baserule_root));
711:
712: -- Parse the Base Rule and Store the Nodes of the

Line 709: l_baserule_root := DBMS_XMLDOM.getDocumentElement(l_baserule_dom);

705: END IF;
706:
707: l_baserule_doc := p_base_doc;
708: l_baserule_dom := DBMS_XMLDOM.newDOMDocument(l_baserule_doc);
709: l_baserule_root := DBMS_XMLDOM.getDocumentElement(l_baserule_dom);
710: l_child := DBMS_XMLDOM.getFirstChild(DBMS_XMLDOM.makeNode(l_baserule_root));
711:
712: -- Parse the Base Rule and Store the Nodes of the
713: -- Base Rule ( schedulerParameters/costParameters/routerConfig)

Line 710: l_child := DBMS_XMLDOM.getFirstChild(DBMS_XMLDOM.makeNode(l_baserule_root));

706:
707: l_baserule_doc := p_base_doc;
708: l_baserule_dom := DBMS_XMLDOM.newDOMDocument(l_baserule_doc);
709: l_baserule_root := DBMS_XMLDOM.getDocumentElement(l_baserule_dom);
710: l_child := DBMS_XMLDOM.getFirstChild(DBMS_XMLDOM.makeNode(l_baserule_root));
711:
712: -- Parse the Base Rule and Store the Nodes of the
713: -- Base Rule ( schedulerParameters/costParameters/routerConfig)
714: WHILE NOT DBMS_XMLDOM.isNull(l_child) LOOP

Line 714: WHILE NOT DBMS_XMLDOM.isNull(l_child) LOOP

710: l_child := DBMS_XMLDOM.getFirstChild(DBMS_XMLDOM.makeNode(l_baserule_root));
711:
712: -- Parse the Base Rule and Store the Nodes of the
713: -- Base Rule ( schedulerParameters/costParameters/routerConfig)
714: WHILE NOT DBMS_XMLDOM.isNull(l_child) LOOP
715: IF DBMS_XMLDOM.getTagName(DBMS_XMLDOM.makeElement(l_child)) <> l_wtp_nodename THEN
716: l_nodelist := DBMS_XMLDOM.getChildNodes(l_child);
717: FOR i IN 0..DBMS_XMLDOM.getLength(l_nodelist) - 1 LOOP
718: l_baserule_node_list.EXTEND(1);

Line 715: IF DBMS_XMLDOM.getTagName(DBMS_XMLDOM.makeElement(l_child)) <> l_wtp_nodename THEN

711:
712: -- Parse the Base Rule and Store the Nodes of the
713: -- Base Rule ( schedulerParameters/costParameters/routerConfig)
714: WHILE NOT DBMS_XMLDOM.isNull(l_child) LOOP
715: IF DBMS_XMLDOM.getTagName(DBMS_XMLDOM.makeElement(l_child)) <> l_wtp_nodename THEN
716: l_nodelist := DBMS_XMLDOM.getChildNodes(l_child);
717: FOR i IN 0..DBMS_XMLDOM.getLength(l_nodelist) - 1 LOOP
718: l_baserule_node_list.EXTEND(1);
719: l_baserule_node_list(l_baserule_node_list.COUNT) := DBMS_XMLDOM.item(l_nodelist, i);

Line 716: l_nodelist := DBMS_XMLDOM.getChildNodes(l_child);

712: -- Parse the Base Rule and Store the Nodes of the
713: -- Base Rule ( schedulerParameters/costParameters/routerConfig)
714: WHILE NOT DBMS_XMLDOM.isNull(l_child) LOOP
715: IF DBMS_XMLDOM.getTagName(DBMS_XMLDOM.makeElement(l_child)) <> l_wtp_nodename THEN
716: l_nodelist := DBMS_XMLDOM.getChildNodes(l_child);
717: FOR i IN 0..DBMS_XMLDOM.getLength(l_nodelist) - 1 LOOP
718: l_baserule_node_list.EXTEND(1);
719: l_baserule_node_list(l_baserule_node_list.COUNT) := DBMS_XMLDOM.item(l_nodelist, i);
720: END LOOP;

Line 717: FOR i IN 0..DBMS_XMLDOM.getLength(l_nodelist) - 1 LOOP

713: -- Base Rule ( schedulerParameters/costParameters/routerConfig)
714: WHILE NOT DBMS_XMLDOM.isNull(l_child) LOOP
715: IF DBMS_XMLDOM.getTagName(DBMS_XMLDOM.makeElement(l_child)) <> l_wtp_nodename THEN
716: l_nodelist := DBMS_XMLDOM.getChildNodes(l_child);
717: FOR i IN 0..DBMS_XMLDOM.getLength(l_nodelist) - 1 LOOP
718: l_baserule_node_list.EXTEND(1);
719: l_baserule_node_list(l_baserule_node_list.COUNT) := DBMS_XMLDOM.item(l_nodelist, i);
720: END LOOP;
721: END IF;

Line 719: l_baserule_node_list(l_baserule_node_list.COUNT) := DBMS_XMLDOM.item(l_nodelist, i);

715: IF DBMS_XMLDOM.getTagName(DBMS_XMLDOM.makeElement(l_child)) <> l_wtp_nodename THEN
716: l_nodelist := DBMS_XMLDOM.getChildNodes(l_child);
717: FOR i IN 0..DBMS_XMLDOM.getLength(l_nodelist) - 1 LOOP
718: l_baserule_node_list.EXTEND(1);
719: l_baserule_node_list(l_baserule_node_list.COUNT) := DBMS_XMLDOM.item(l_nodelist, i);
720: END LOOP;
721: END IF;
722: l_child := DBMS_XMLDOM.getNextSibling(l_child);
723: END LOOP;

Line 722: l_child := DBMS_XMLDOM.getNextSibling(l_child);

718: l_baserule_node_list.EXTEND(1);
719: l_baserule_node_list(l_baserule_node_list.COUNT) := DBMS_XMLDOM.item(l_nodelist, i);
720: END LOOP;
721: END IF;
722: l_child := DBMS_XMLDOM.getNextSibling(l_child);
723: END LOOP;
724:
725: l_childrule_dom := DBMS_XMLDOM.newDOMDocument(p_child_doc);
726:

Line 725: l_childrule_dom := DBMS_XMLDOM.newDOMDocument(p_child_doc);

721: END IF;
722: l_child := DBMS_XMLDOM.getNextSibling(l_child);
723: END LOOP;
724:
725: l_childrule_dom := DBMS_XMLDOM.newDOMDocument(p_child_doc);
726:
727: IF l_debug = 'Y' THEN
728: debug('Updating Rule#' || p_child_rule_id, l_api_name, fnd_log.level_event);
729: DECLARE

Line 732: DBMS_XMLDOM.WRITETOBUFFER(l_childrule_dom, buffer);

728: debug('Updating Rule#' || p_child_rule_id, l_api_name, fnd_log.level_event);
729: DECLARE
730: buffer VARCHAR2(8000);
731: BEGIN
732: DBMS_XMLDOM.WRITETOBUFFER(l_childrule_dom, buffer);
733: debug(' --> XML Doc#1 = ' || substr(buffer, 1, 3900), l_api_name, fnd_log.level_statement);
734: debug(' --> XML Doc#2 = ' || substr(buffer, 3901, 3900), l_api_name, fnd_log.level_statement);
735: END;
736: END IF;

Line 741: l_child_node := DBMS_XMLDOM.item(DBMS_XMLDOM.getElementsByTagName

737:
738: i := l_baserule_node_list.FIRST;
739: WHILE i IS NOT NULL LOOP
740: l_node := l_baserule_node_list(i);
741: l_child_node := DBMS_XMLDOM.item(DBMS_XMLDOM.getElementsByTagName
742: (l_childrule_dom, DBMS_XMLDOM.getTagName(
743: DBMS_XMLDOM.makeElement(l_node)
744: )
745: ),0);

Line 742: (l_childrule_dom, DBMS_XMLDOM.getTagName(

738: i := l_baserule_node_list.FIRST;
739: WHILE i IS NOT NULL LOOP
740: l_node := l_baserule_node_list(i);
741: l_child_node := DBMS_XMLDOM.item(DBMS_XMLDOM.getElementsByTagName
742: (l_childrule_dom, DBMS_XMLDOM.getTagName(
743: DBMS_XMLDOM.makeElement(l_node)
744: )
745: ),0);
746: l_child_attrs := DBMS_XMLDOM.getAttributes(l_child_node);

Line 743: DBMS_XMLDOM.makeElement(l_node)

739: WHILE i IS NOT NULL LOOP
740: l_node := l_baserule_node_list(i);
741: l_child_node := DBMS_XMLDOM.item(DBMS_XMLDOM.getElementsByTagName
742: (l_childrule_dom, DBMS_XMLDOM.getTagName(
743: DBMS_XMLDOM.makeElement(l_node)
744: )
745: ),0);
746: l_child_attrs := DBMS_XMLDOM.getAttributes(l_child_node);
747: -- Propagate the Changes from a Parent Rule's XML Element to Child Rule's Element Only

Line 746: l_child_attrs := DBMS_XMLDOM.getAttributes(l_child_node);

742: (l_childrule_dom, DBMS_XMLDOM.getTagName(
743: DBMS_XMLDOM.makeElement(l_node)
744: )
745: ),0);
746: l_child_attrs := DBMS_XMLDOM.getAttributes(l_child_node);
747: -- Propagate the Changes from a Parent Rule's XML Element to Child Rule's Element Only
748: -- if it is either inherited OR its a force updation.
749: l_inherited := DBMS_XMLDOM.getNodeValue(DBMS_XMLDOM.getNamedItem(l_child_attrs, 'inherited'));
750: IF l_inherited = 'Y' OR p_force = 'Y' THEN

Line 749: l_inherited := DBMS_XMLDOM.getNodeValue(DBMS_XMLDOM.getNamedItem(l_child_attrs, 'inherited'));

745: ),0);
746: l_child_attrs := DBMS_XMLDOM.getAttributes(l_child_node);
747: -- Propagate the Changes from a Parent Rule's XML Element to Child Rule's Element Only
748: -- if it is either inherited OR its a force updation.
749: l_inherited := DBMS_XMLDOM.getNodeValue(DBMS_XMLDOM.getNamedItem(l_child_attrs, 'inherited'));
750: IF l_inherited = 'Y' OR p_force = 'Y' THEN
751: l_child_text_node := DBMS_XMLDOM.getFirstChild(l_child_node);
752: l_base_text_node := DBMS_XMLDOM.getFirstChild(l_node);
753: DBMS_XMLDOM.setNodeValue(l_child_text_node, DBMS_XMLDOM.getNodeValue(l_base_text_node));

Line 751: l_child_text_node := DBMS_XMLDOM.getFirstChild(l_child_node);

747: -- Propagate the Changes from a Parent Rule's XML Element to Child Rule's Element Only
748: -- if it is either inherited OR its a force updation.
749: l_inherited := DBMS_XMLDOM.getNodeValue(DBMS_XMLDOM.getNamedItem(l_child_attrs, 'inherited'));
750: IF l_inherited = 'Y' OR p_force = 'Y' THEN
751: l_child_text_node := DBMS_XMLDOM.getFirstChild(l_child_node);
752: l_base_text_node := DBMS_XMLDOM.getFirstChild(l_node);
753: DBMS_XMLDOM.setNodeValue(l_child_text_node, DBMS_XMLDOM.getNodeValue(l_base_text_node));
754: l_child_modified := TRUE;
755: IF l_debug = 'Y' THEN

Line 752: l_base_text_node := DBMS_XMLDOM.getFirstChild(l_node);

748: -- if it is either inherited OR its a force updation.
749: l_inherited := DBMS_XMLDOM.getNodeValue(DBMS_XMLDOM.getNamedItem(l_child_attrs, 'inherited'));
750: IF l_inherited = 'Y' OR p_force = 'Y' THEN
751: l_child_text_node := DBMS_XMLDOM.getFirstChild(l_child_node);
752: l_base_text_node := DBMS_XMLDOM.getFirstChild(l_node);
753: DBMS_XMLDOM.setNodeValue(l_child_text_node, DBMS_XMLDOM.getNodeValue(l_base_text_node));
754: l_child_modified := TRUE;
755: IF l_debug = 'Y' THEN
756: debug('Modified XML Element:' ||DBMS_XMLDOM.getNodeName(l_child_text_node)

Line 753: DBMS_XMLDOM.setNodeValue(l_child_text_node, DBMS_XMLDOM.getNodeValue(l_base_text_node));

749: l_inherited := DBMS_XMLDOM.getNodeValue(DBMS_XMLDOM.getNamedItem(l_child_attrs, 'inherited'));
750: IF l_inherited = 'Y' OR p_force = 'Y' THEN
751: l_child_text_node := DBMS_XMLDOM.getFirstChild(l_child_node);
752: l_base_text_node := DBMS_XMLDOM.getFirstChild(l_node);
753: DBMS_XMLDOM.setNodeValue(l_child_text_node, DBMS_XMLDOM.getNodeValue(l_base_text_node));
754: l_child_modified := TRUE;
755: IF l_debug = 'Y' THEN
756: debug('Modified XML Element:' ||DBMS_XMLDOM.getNodeName(l_child_text_node)
757: , l_api_name, fnd_log.level_statement);

Line 756: debug('Modified XML Element:' ||DBMS_XMLDOM.getNodeName(l_child_text_node)

752: l_base_text_node := DBMS_XMLDOM.getFirstChild(l_node);
753: DBMS_XMLDOM.setNodeValue(l_child_text_node, DBMS_XMLDOM.getNodeValue(l_base_text_node));
754: l_child_modified := TRUE;
755: IF l_debug = 'Y' THEN
756: debug('Modified XML Element:' ||DBMS_XMLDOM.getNodeName(l_child_text_node)
757: , l_api_name, fnd_log.level_statement);
758: END IF;
759: END IF;
760: i := l_baserule_node_list.NEXT(i);

Line 898: DBMS_XMLDOM.WRITETOBUFFER(DBMS_XMLDOM.NEWDOMDOCUMENT(p_rule_doc), buffer);

894: debug(' --> Res ID = ' || p_resource_id, l_api_name, fnd_log.level_statement);
895: DECLARE
896: buffer VARCHAR2(8000);
897: BEGIN
898: DBMS_XMLDOM.WRITETOBUFFER(DBMS_XMLDOM.NEWDOMDOCUMENT(p_rule_doc), buffer);
899: debug(' --> XML Doc#1 = ' || substr(buffer, 1, 3900), l_api_name, fnd_log.level_statement);
900: debug(' --> XML Doc#2 = ' || substr(buffer, 3901, 3900), l_api_name, fnd_log.level_statement);
901: END;
902: END IF;

Line 1069: DBMS_XMLDOM.WRITETOBUFFER(DBMS_XMLDOM.NEWDOMDOCUMENT(p_rule_doc), buffer);

1065: debug(' --> Res ID = ' || p_resource_id, l_api_name, fnd_log.level_statement);
1066: DECLARE
1067: buffer VARCHAR2(8000);
1068: BEGIN
1069: DBMS_XMLDOM.WRITETOBUFFER(DBMS_XMLDOM.NEWDOMDOCUMENT(p_rule_doc), buffer);
1070: debug(' --> XML Doc#1 = ' || substr(buffer, 1, 3900), l_api_name, fnd_log.level_statement);
1071: debug(' --> XML Doc#2 = ' || substr(buffer, 3901, 3900), l_api_name, fnd_log.level_statement);
1072: END;
1073: END IF;

Line 1683: l_rule_document DBMS_XMLDOM.DOMDocument;

1679: l_object_version_num NUMBER;
1680: --
1681: l_new_param_values jtf_varchar2_table_100;
1682: --
1683: l_rule_document DBMS_XMLDOM.DOMDocument;
1684: l_root_element DBMS_XMLDOM.DOMELEMENT;
1685: l_dom_node DBMS_XMLDOM.DOMNode;
1686: l_dom_text_node DBMS_XMLDOM.DOMNode;
1687: l_dom_node_value VARCHAR2(100);

Line 1684: l_root_element DBMS_XMLDOM.DOMELEMENT;

1680: --
1681: l_new_param_values jtf_varchar2_table_100;
1682: --
1683: l_rule_document DBMS_XMLDOM.DOMDocument;
1684: l_root_element DBMS_XMLDOM.DOMELEMENT;
1685: l_dom_node DBMS_XMLDOM.DOMNode;
1686: l_dom_text_node DBMS_XMLDOM.DOMNode;
1687: l_dom_node_value VARCHAR2(100);
1688: l_parent_dom_node DBMS_XMLDOM.DOMNode;

Line 1685: l_dom_node DBMS_XMLDOM.DOMNode;

1681: l_new_param_values jtf_varchar2_table_100;
1682: --
1683: l_rule_document DBMS_XMLDOM.DOMDocument;
1684: l_root_element DBMS_XMLDOM.DOMELEMENT;
1685: l_dom_node DBMS_XMLDOM.DOMNode;
1686: l_dom_text_node DBMS_XMLDOM.DOMNode;
1687: l_dom_node_value VARCHAR2(100);
1688: l_parent_dom_node DBMS_XMLDOM.DOMNode;
1689: --

Line 1686: l_dom_text_node DBMS_XMLDOM.DOMNode;

1682: --
1683: l_rule_document DBMS_XMLDOM.DOMDocument;
1684: l_root_element DBMS_XMLDOM.DOMELEMENT;
1685: l_dom_node DBMS_XMLDOM.DOMNode;
1686: l_dom_text_node DBMS_XMLDOM.DOMNode;
1687: l_dom_node_value VARCHAR2(100);
1688: l_parent_dom_node DBMS_XMLDOM.DOMNode;
1689: --
1690: CURSOR c_rule_details IS

Line 1688: l_parent_dom_node DBMS_XMLDOM.DOMNode;

1684: l_root_element DBMS_XMLDOM.DOMELEMENT;
1685: l_dom_node DBMS_XMLDOM.DOMNode;
1686: l_dom_text_node DBMS_XMLDOM.DOMNode;
1687: l_dom_node_value VARCHAR2(100);
1688: l_parent_dom_node DBMS_XMLDOM.DOMNode;
1689: --
1690: CURSOR c_rule_details IS
1691: SELECT b.rule_doc, b.rule_rank, t.rule_name, t.description
1692: FROM csr_rules_b b, csr_rules_tl t

Line 1826: l_rule_document := DBMS_XMLDOM.newDOMDocument(l_rule.rule_doc);

1822: l_new_param_values(55) := p_cp_travel_per_unit_distance;
1823: l_new_param_values(56) := p_cp_travel_per_unit_duration;
1824: l_new_param_values(57) := p_cp_defer_same_site;
1825:
1826: l_rule_document := DBMS_XMLDOM.newDOMDocument(l_rule.rule_doc);
1827: l_root_element := DBMS_XMLDOM.getDocumentElement(l_rule_document);
1828:
1829: FOR i IN 1..g_rule_param_names_tbl.COUNT LOOP
1830: l_dom_node := DBMS_XMLDOM.item(DBMS_XMLDOM.getElementsByTagName(l_rule_document, g_rule_param_names_tbl(i)), 0);

Line 1827: l_root_element := DBMS_XMLDOM.getDocumentElement(l_rule_document);

1823: l_new_param_values(56) := p_cp_travel_per_unit_duration;
1824: l_new_param_values(57) := p_cp_defer_same_site;
1825:
1826: l_rule_document := DBMS_XMLDOM.newDOMDocument(l_rule.rule_doc);
1827: l_root_element := DBMS_XMLDOM.getDocumentElement(l_rule_document);
1828:
1829: FOR i IN 1..g_rule_param_names_tbl.COUNT LOOP
1830: l_dom_node := DBMS_XMLDOM.item(DBMS_XMLDOM.getElementsByTagName(l_rule_document, g_rule_param_names_tbl(i)), 0);
1831:

Line 1830: l_dom_node := DBMS_XMLDOM.item(DBMS_XMLDOM.getElementsByTagName(l_rule_document, g_rule_param_names_tbl(i)), 0);

1826: l_rule_document := DBMS_XMLDOM.newDOMDocument(l_rule.rule_doc);
1827: l_root_element := DBMS_XMLDOM.getDocumentElement(l_rule_document);
1828:
1829: FOR i IN 1..g_rule_param_names_tbl.COUNT LOOP
1830: l_dom_node := DBMS_XMLDOM.item(DBMS_XMLDOM.getElementsByTagName(l_rule_document, g_rule_param_names_tbl(i)), 0);
1831:
1832: -- If the Node already exists in the RULE_DOC, then we just need to update the Value
1833: IF DBMS_XMLDOM.isNull(l_dom_node) = FALSE THEN
1834: l_dom_node_value := DBMS_XMLDOM.getNodeValue(DBMS_XMLDOM.getFirstChild(l_dom_node));

Line 1833: IF DBMS_XMLDOM.isNull(l_dom_node) = FALSE THEN

1829: FOR i IN 1..g_rule_param_names_tbl.COUNT LOOP
1830: l_dom_node := DBMS_XMLDOM.item(DBMS_XMLDOM.getElementsByTagName(l_rule_document, g_rule_param_names_tbl(i)), 0);
1831:
1832: -- If the Node already exists in the RULE_DOC, then we just need to update the Value
1833: IF DBMS_XMLDOM.isNull(l_dom_node) = FALSE THEN
1834: l_dom_node_value := DBMS_XMLDOM.getNodeValue(DBMS_XMLDOM.getFirstChild(l_dom_node));
1835:
1836: -- Delete the Node if the new value is NULL
1837: IF l_new_param_values(i) IS NULL THEN

Line 1834: l_dom_node_value := DBMS_XMLDOM.getNodeValue(DBMS_XMLDOM.getFirstChild(l_dom_node));

1830: l_dom_node := DBMS_XMLDOM.item(DBMS_XMLDOM.getElementsByTagName(l_rule_document, g_rule_param_names_tbl(i)), 0);
1831:
1832: -- If the Node already exists in the RULE_DOC, then we just need to update the Value
1833: IF DBMS_XMLDOM.isNull(l_dom_node) = FALSE THEN
1834: l_dom_node_value := DBMS_XMLDOM.getNodeValue(DBMS_XMLDOM.getFirstChild(l_dom_node));
1835:
1836: -- Delete the Node if the new value is NULL
1837: IF l_new_param_values(i) IS NULL THEN
1838: l_dom_node := DBMS_XMLDOM.removeChild(DBMS_XMLDOM.getParentNode(l_dom_node), l_dom_node);

Line 1838: l_dom_node := DBMS_XMLDOM.removeChild(DBMS_XMLDOM.getParentNode(l_dom_node), l_dom_node);

1834: l_dom_node_value := DBMS_XMLDOM.getNodeValue(DBMS_XMLDOM.getFirstChild(l_dom_node));
1835:
1836: -- Delete the Node if the new value is NULL
1837: IF l_new_param_values(i) IS NULL THEN
1838: l_dom_node := DBMS_XMLDOM.removeChild(DBMS_XMLDOM.getParentNode(l_dom_node), l_dom_node);
1839: ELSE
1840: IF NVL(l_new_param_values(i), '-') <> NVL(l_dom_node_value, '-') THEN
1841: DBMS_XMLDOM.setAttribute(DBMS_XMLDOM.makeElement(l_dom_node), 'inherited', 'N');
1842: END IF;

Line 1841: DBMS_XMLDOM.setAttribute(DBMS_XMLDOM.makeElement(l_dom_node), 'inherited', 'N');

1837: IF l_new_param_values(i) IS NULL THEN
1838: l_dom_node := DBMS_XMLDOM.removeChild(DBMS_XMLDOM.getParentNode(l_dom_node), l_dom_node);
1839: ELSE
1840: IF NVL(l_new_param_values(i), '-') <> NVL(l_dom_node_value, '-') THEN
1841: DBMS_XMLDOM.setAttribute(DBMS_XMLDOM.makeElement(l_dom_node), 'inherited', 'N');
1842: END IF;
1843: DBMS_XMLDOM.setNodeValue(DBMS_XMLDOM.getFirstChild(l_dom_node), l_new_param_values(i));
1844: END IF;
1845: ELSIF l_new_param_values(i) IS NOT NULL AND is_param_valid_for_eligibility(l_rule.rule_rank, i) THEN

Line 1843: DBMS_XMLDOM.setNodeValue(DBMS_XMLDOM.getFirstChild(l_dom_node), l_new_param_values(i));

1839: ELSE
1840: IF NVL(l_new_param_values(i), '-') <> NVL(l_dom_node_value, '-') THEN
1841: DBMS_XMLDOM.setAttribute(DBMS_XMLDOM.makeElement(l_dom_node), 'inherited', 'N');
1842: END IF;
1843: DBMS_XMLDOM.setNodeValue(DBMS_XMLDOM.getFirstChild(l_dom_node), l_new_param_values(i));
1844: END IF;
1845: ELSIF l_new_param_values(i) IS NOT NULL AND is_param_valid_for_eligibility(l_rule.rule_rank, i) THEN
1846: -- Node doesnt exists. If a value is provided in the parameter and the parameter is valid
1847: -- for the current eligibility, we have to create a Node.

Line 1848: l_dom_node := DBMS_XMLDOM.makeNode(DBMS_XMLDOM.createElement(l_rule_document, g_rule_param_names_tbl(i), g_rules_ns));

1844: END IF;
1845: ELSIF l_new_param_values(i) IS NOT NULL AND is_param_valid_for_eligibility(l_rule.rule_rank, i) THEN
1846: -- Node doesnt exists. If a value is provided in the parameter and the parameter is valid
1847: -- for the current eligibility, we have to create a Node.
1848: l_dom_node := DBMS_XMLDOM.makeNode(DBMS_XMLDOM.createElement(l_rule_document, g_rule_param_names_tbl(i), g_rules_ns));
1849: l_dom_text_node := DBMS_XMLDOM.appendChild(l_dom_node, DBMS_XMLDOM.MAKENODE(DBMS_XMLDOM.createTextNode(l_rule_document, l_new_param_values(i))));
1850: DBMS_XMLDOM.setAttribute(DBMS_XMLDOM.makeElement(l_dom_node), 'inherited', 'N');
1851: l_parent_dom_node := get_param_grp_dom_node(l_rule_document, CASE WHEN i<33 THEN 'schedulerParameters' WHEN i<45 THEN 'routerConfig' ELSE 'costParameters' END, TRUE);
1852: l_dom_node := DBMS_XMLDOM.appendChild(l_parent_dom_node, l_dom_node);

Line 1849: l_dom_text_node := DBMS_XMLDOM.appendChild(l_dom_node, DBMS_XMLDOM.MAKENODE(DBMS_XMLDOM.createTextNode(l_rule_document, l_new_param_values(i))));

1845: ELSIF l_new_param_values(i) IS NOT NULL AND is_param_valid_for_eligibility(l_rule.rule_rank, i) THEN
1846: -- Node doesnt exists. If a value is provided in the parameter and the parameter is valid
1847: -- for the current eligibility, we have to create a Node.
1848: l_dom_node := DBMS_XMLDOM.makeNode(DBMS_XMLDOM.createElement(l_rule_document, g_rule_param_names_tbl(i), g_rules_ns));
1849: l_dom_text_node := DBMS_XMLDOM.appendChild(l_dom_node, DBMS_XMLDOM.MAKENODE(DBMS_XMLDOM.createTextNode(l_rule_document, l_new_param_values(i))));
1850: DBMS_XMLDOM.setAttribute(DBMS_XMLDOM.makeElement(l_dom_node), 'inherited', 'N');
1851: l_parent_dom_node := get_param_grp_dom_node(l_rule_document, CASE WHEN i<33 THEN 'schedulerParameters' WHEN i<45 THEN 'routerConfig' ELSE 'costParameters' END, TRUE);
1852: l_dom_node := DBMS_XMLDOM.appendChild(l_parent_dom_node, l_dom_node);
1853: END IF;

Line 1850: DBMS_XMLDOM.setAttribute(DBMS_XMLDOM.makeElement(l_dom_node), 'inherited', 'N');

1846: -- Node doesnt exists. If a value is provided in the parameter and the parameter is valid
1847: -- for the current eligibility, we have to create a Node.
1848: l_dom_node := DBMS_XMLDOM.makeNode(DBMS_XMLDOM.createElement(l_rule_document, g_rule_param_names_tbl(i), g_rules_ns));
1849: l_dom_text_node := DBMS_XMLDOM.appendChild(l_dom_node, DBMS_XMLDOM.MAKENODE(DBMS_XMLDOM.createTextNode(l_rule_document, l_new_param_values(i))));
1850: DBMS_XMLDOM.setAttribute(DBMS_XMLDOM.makeElement(l_dom_node), 'inherited', 'N');
1851: l_parent_dom_node := get_param_grp_dom_node(l_rule_document, CASE WHEN i<33 THEN 'schedulerParameters' WHEN i<45 THEN 'routerConfig' ELSE 'costParameters' END, TRUE);
1852: l_dom_node := DBMS_XMLDOM.appendChild(l_parent_dom_node, l_dom_node);
1853: END IF;
1854: END LOOP;

Line 1852: l_dom_node := DBMS_XMLDOM.appendChild(l_parent_dom_node, l_dom_node);

1848: l_dom_node := DBMS_XMLDOM.makeNode(DBMS_XMLDOM.createElement(l_rule_document, g_rule_param_names_tbl(i), g_rules_ns));
1849: l_dom_text_node := DBMS_XMLDOM.appendChild(l_dom_node, DBMS_XMLDOM.MAKENODE(DBMS_XMLDOM.createTextNode(l_rule_document, l_new_param_values(i))));
1850: DBMS_XMLDOM.setAttribute(DBMS_XMLDOM.makeElement(l_dom_node), 'inherited', 'N');
1851: l_parent_dom_node := get_param_grp_dom_node(l_rule_document, CASE WHEN i<33 THEN 'schedulerParameters' WHEN i<45 THEN 'routerConfig' ELSE 'costParameters' END, TRUE);
1852: l_dom_node := DBMS_XMLDOM.appendChild(l_parent_dom_node, l_dom_node);
1853: END IF;
1854: END LOOP;
1855:
1856: l_object_version_num := p_object_version_number;