DBA Data[Home] [Help]

APPS.IRC_LOCATION_PREFERENCES_SWI dependencies on XMLDOM

Line 607: l_commitElement xmldom.DOMElement;

603: IS
604: l_postState VARCHAR2(2);
605: l_return_status VARCHAR2(1);
606: l_object_version_number number;
607: l_commitElement xmldom.DOMElement;
608: l_parser xmlparser.Parser;
609: l_CommitNode xmldom.DOMNode;
610: l_proc varchar2(72) := g_package || 'PROCESS_VAC_REC_AREA_API';
611:

Line 609: l_CommitNode xmldom.DOMNode;

605: l_return_status VARCHAR2(1);
606: l_object_version_number number;
607: l_commitElement xmldom.DOMElement;
608: l_parser xmlparser.Parser;
609: l_CommitNode xmldom.DOMNode;
610: l_proc varchar2(72) := g_package || 'PROCESS_VAC_REC_AREA_API';
611:
612: -- Variables for OUT parameters
613: l_vac_rec_area_id number;

Line 620: hr_utility.set_location(' CLOB --> xmldom.DOMNode:' || l_proc,15);

616: --
617: BEGIN
618: --
619: hr_utility.set_location(' Entering:' || l_proc,10);
620: hr_utility.set_location(' CLOB --> xmldom.DOMNode:' || l_proc,15);
621: --
622: l_parser := xmlparser.newParser;
623: xmlparser.ParseCLOB(l_parser,p_document);
624: l_CommitNode := xmldom.makeNode(xmldom.getDocumentElement(xmlparser.getDocument(l_parser)));

Line 624: l_CommitNode := xmldom.makeNode(xmldom.getDocumentElement(xmlparser.getDocument(l_parser)));

620: hr_utility.set_location(' CLOB --> xmldom.DOMNode:' || l_proc,15);
621: --
622: l_parser := xmlparser.newParser;
623: xmlparser.ParseCLOB(l_parser,p_document);
624: l_CommitNode := xmldom.makeNode(xmldom.getDocumentElement(xmlparser.getDocument(l_parser)));
625: --
626:
627: hr_utility.set_location('Extracting the PostState:' || l_proc,20);
628:

Line 629: l_commitElement := xmldom.makeElement(l_CommitNode);

625: --
626:
627: hr_utility.set_location('Extracting the PostState:' || l_proc,20);
628:
629: l_commitElement := xmldom.makeElement(l_CommitNode);
630: l_postState := xmldom.getAttribute(l_commitElement, 'PS');
631: --
632: --Get the values for in/out parameters
633: --

Line 630: l_postState := xmldom.getAttribute(l_commitElement, 'PS');

626:
627: hr_utility.set_location('Extracting the PostState:' || l_proc,20);
628:
629: l_commitElement := xmldom.makeElement(l_CommitNode);
630: l_postState := xmldom.getAttribute(l_commitElement, 'PS');
631: --
632: --Get the values for in/out parameters
633: --
634: l_vac_rec_area_id := hr_transaction_swi.getNumberValue(l_CommitNode,'VacRecAreaId');

Line 710: l_commitElement xmldom.DOMElement;

706: IS
707: l_postState VARCHAR2(2);
708: l_return_status VARCHAR2(1);
709: l_object_version_number number;
710: l_commitElement xmldom.DOMElement;
711: l_parser xmlparser.Parser;
712: l_CommitNode xmldom.DOMNode;
713: l_proc varchar2(72) := g_package || 'PROCESS_LOCATION_PREF_API';
714:

Line 712: l_CommitNode xmldom.DOMNode;

708: l_return_status VARCHAR2(1);
709: l_object_version_number number;
710: l_commitElement xmldom.DOMElement;
711: l_parser xmlparser.Parser;
712: l_CommitNode xmldom.DOMNode;
713: l_proc varchar2(72) := g_package || 'PROCESS_LOCATION_PREF_API';
714:
715: -- Variables for OUT parameters
716: l_location_pref_id number;

Line 722: hr_utility.set_location(' CLOB --> xmldom.DOMNode:' || l_proc,15);

718: --
719: BEGIN
720: --
721: hr_utility.set_location(' Entering:' || l_proc,10);
722: hr_utility.set_location(' CLOB --> xmldom.DOMNode:' || l_proc,15);
723: --
724: l_parser := xmlparser.newParser;
725: xmlparser.ParseCLOB(l_parser,p_document);
726: l_CommitNode := xmldom.makeNode(xmldom.getDocumentElement(xmlparser.getDocument(l_parser)));

Line 726: l_CommitNode := xmldom.makeNode(xmldom.getDocumentElement(xmlparser.getDocument(l_parser)));

722: hr_utility.set_location(' CLOB --> xmldom.DOMNode:' || l_proc,15);
723: --
724: l_parser := xmlparser.newParser;
725: xmlparser.ParseCLOB(l_parser,p_document);
726: l_CommitNode := xmldom.makeNode(xmldom.getDocumentElement(xmlparser.getDocument(l_parser)));
727: --
728:
729: hr_utility.set_location('Extracting the PostState:' || l_proc,20);
730:

Line 731: l_commitElement := xmldom.makeElement(l_CommitNode);

727: --
728:
729: hr_utility.set_location('Extracting the PostState:' || l_proc,20);
730:
731: l_commitElement := xmldom.makeElement(l_CommitNode);
732: l_postState := xmldom.getAttribute(l_commitElement, 'PS');
733: --
734: --Get the values for in/out parameters
735: --

Line 732: l_postState := xmldom.getAttribute(l_commitElement, 'PS');

728:
729: hr_utility.set_location('Extracting the PostState:' || l_proc,20);
730:
731: l_commitElement := xmldom.makeElement(l_CommitNode);
732: l_postState := xmldom.getAttribute(l_commitElement, 'PS');
733: --
734: --Get the values for in/out parameters
735: --
736: l_location_pref_id := hr_transaction_swi.getNumberValue(l_CommitNode,'LocationPrefId');