479: l_return_status VARCHAR2(1);
480: l_object_version_number number;
481: l_agency_vacancy_id number;
482: l_commitElement xmldom.DOMElement;
483: l_parser xmlparser.Parser;
484: l_CommitNode xmldom.DOMNode;
485:
486: l_proc varchar2(72) := g_package || 'process_offers_api';
487: l_effective_date date := trunc(sysdate);
490: --
491: hr_utility.set_location(' Entering:' || l_proc,10);
492: hr_utility.set_location(' CLOB --> xmldom.DOMNode:' || l_proc,15);
493: --
494: l_parser := xmlparser.newParser;
495: xmlparser.ParseCLOB(l_parser,p_document);
496: l_CommitNode := xmldom.makeNode(xmldom.getDocumentElement(xmlparser.getDocument(l_parser)));
497: --
498: hr_utility.set_location('Extracting the PostState:' || l_proc,20);
491: hr_utility.set_location(' Entering:' || l_proc,10);
492: hr_utility.set_location(' CLOB --> xmldom.DOMNode:' || l_proc,15);
493: --
494: l_parser := xmlparser.newParser;
495: xmlparser.ParseCLOB(l_parser,p_document);
496: l_CommitNode := xmldom.makeNode(xmldom.getDocumentElement(xmlparser.getDocument(l_parser)));
497: --
498: hr_utility.set_location('Extracting the PostState:' || l_proc,20);
499:
492: hr_utility.set_location(' CLOB --> xmldom.DOMNode:' || l_proc,15);
493: --
494: l_parser := xmlparser.newParser;
495: xmlparser.ParseCLOB(l_parser,p_document);
496: l_CommitNode := xmldom.makeNode(xmldom.getDocumentElement(xmlparser.getDocument(l_parser)));
497: --
498: hr_utility.set_location('Extracting the PostState:' || l_proc,20);
499:
500: l_commitElement := xmldom.makeElement(l_CommitNode);