APPS.PER_VACANCY_SWI dependencies on XMLDOM

Line 583: l_commitElement xmldom.DOMElement;

579: IS
580: l_postState VARCHAR2(2);
581: l_return_status VARCHAR2(1);
582: l_object_version_number number;
583: l_commitElement xmldom.DOMElement;
584: l_parser xmlparser.Parser;
585: l_CommitNode xmldom.DOMNode;
586: l_proc varchar2(72) := g_package || 'process_api';
587:

Line 585: l_CommitNode xmldom.DOMNode;

581: l_return_status VARCHAR2(1);
582: l_object_version_number number;
583: l_commitElement xmldom.DOMElement;
584: l_parser xmlparser.Parser;
585: l_CommitNode xmldom.DOMNode;
586: l_proc varchar2(72) := g_package || 'process_api';
587:
588: -- Variables for OUT parameters
589: l_effective_date date := trunc(sysdate);

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

595:
596: BEGIN
597: --
598: hr_utility.set_location(' Entering:' || l_proc,10);
599: hr_utility.set_location(' CLOB --> xmldom.DOMNode:' || l_proc,15);
600: --
601: g_commiting_via_workflow:='TRUE';
602: l_parser := xmlparser.newParser;
603: xmlparser.ParseCLOB(l_parser,p_document);

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

600: --
601: g_commiting_via_workflow:='TRUE';
602: l_parser := xmlparser.newParser;
603: xmlparser.ParseCLOB(l_parser,p_document);
604: l_CommitNode := xmldom.makeNode(xmldom.getDocumentElement(xmlparser.getDocument(l_parser)));
605: --
606: hr_utility.set_location('Extracting the PostState:' || l_proc,20);
607: l_commitElement := xmldom.makeElement(l_CommitNode);
608: l_postState := xmldom.getAttribute(l_commitElement, 'PS');

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

603: xmlparser.ParseCLOB(l_parser,p_document);
604: l_CommitNode := xmldom.makeNode(xmldom.getDocumentElement(xmlparser.getDocument(l_parser)));
605: --
606: hr_utility.set_location('Extracting the PostState:' || l_proc,20);
607: l_commitElement := xmldom.makeElement(l_CommitNode);
608: l_postState := xmldom.getAttribute(l_commitElement, 'PS');
609: --
610: --Get the values for in/out parameters
611: --

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

604: l_CommitNode := xmldom.makeNode(xmldom.getDocumentElement(xmlparser.getDocument(l_parser)));
605: --
606: hr_utility.set_location('Extracting the PostState:' || l_proc,20);
607: l_commitElement := xmldom.makeElement(l_CommitNode);
608: l_postState := xmldom.getAttribute(l_commitElement, 'PS');
609: --
610: --Get the values for in/out parameters
611: --
612: l_object_version_number := hr_transaction_swi.getNumberValue(l_CommitNode,'ObjectVersionNumber');

Line 777: commitNode in xmldom.DOMNode,

773:
774: end process_api;
775: --
776: Function getNumberValueP2(
777: commitNode in xmldom.DOMNode,
778: attributeName in VARCHAR2,
779: gmisc_value in number default hr_api.g_number)
780: return NUMBER IS
781: --

Line 784: l_element xmldom.DOMElement;

780: return NUMBER IS
781: --
782: l_number NUMBER(22,2);
783: l_isNull VARCHAR2(22);
784: l_element xmldom.DOMElement;
785: l_proc varchar2(72) := g_package || 'getNumberValue';
786: --
787: Begin
788: --

Line 791: l_element := xmldom.makeElement(commitNode);

787: Begin
788: --
789: hr_utility.set_location(' Entering:' || l_proc,10);
790: l_number := xslprocessor.valueof(commitNode,attributeName);
791: l_element := xmldom.makeElement(commitNode);
792: l_isNull := xmldom.getAttribute(l_element, 'null');
793: if l_isNull = 'true' then
794: l_number := NULL;
795: else

Line 792: l_isNull := xmldom.getAttribute(l_element, 'null');

788: --
789: hr_utility.set_location(' Entering:' || l_proc,10);
790: l_number := xslprocessor.valueof(commitNode,attributeName);
791: l_element := xmldom.makeElement(commitNode);
792: l_isNull := xmldom.getAttribute(l_element, 'null');
793: if l_isNull = 'true' then
794: l_number := NULL;
795: else
796: l_number := NVL(l_number, gmisc_value);