APPS.PER_VACANCY_SWI dependencies on XMLDOM

Line 579: l_commitElement xmldom.DOMElement;

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

Line 581: l_CommitNode xmldom.DOMNode;

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

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

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

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

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

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

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

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

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

Line 771: commitNode in xmldom.DOMNode,

767:
768: end process_api;
769: --
770: Function getNumberValueP2(
771: commitNode in xmldom.DOMNode,
772: attributeName in VARCHAR2,
773: gmisc_value in number default hr_api.g_number)
774: return NUMBER IS
775: --

Line 778: l_element xmldom.DOMElement;

774: return NUMBER IS
775: --
776: l_number NUMBER(22,2);
777: l_isNull VARCHAR2(22);
778: l_element xmldom.DOMElement;
779: l_proc varchar2(72) := g_package || 'getNumberValue';
780: --
781: Begin
782: --

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

781: Begin
782: --
783: hr_utility.set_location(' Entering:' || l_proc,10);
784: l_number := xslprocessor.valueof(commitNode,attributeName);
785: l_element := xmldom.makeElement(commitNode);
786: l_isNull := xmldom.getAttribute(l_element, 'null');
787: if l_isNull = 'true' then
788: l_number := NULL;
789: else

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

782: --
783: hr_utility.set_location(' Entering:' || l_proc,10);
784: l_number := xslprocessor.valueof(commitNode,attributeName);
785: l_element := xmldom.makeElement(commitNode);
786: l_isNull := xmldom.getAttribute(l_element, 'null');
787: if l_isNull = 'true' then
788: l_number := NULL;
789: else
790: l_number := NVL(l_number, gmisc_value);