1922: l_return_status VARCHAR2(1);
1923: l_object_version_number number;
1924: l_search_criteria_id number;
1925: l_commitElement xmldom.DOMElement;
1926: l_parser xmlparser.Parser;
1927: l_CommitNode xmldom.DOMNode;
1928:
1929: l_proc varchar2(72) := g_package || 'process_offers_api';
1930: l_effective_date date := trunc(sysdate);
1933: --
1934: hr_utility.set_location(' Entering:' || l_proc,10);
1935: hr_utility.set_location(' CLOB --> xmldom.DOMNode:' || l_proc,15);
1936: --
1937: l_parser := xmlparser.newParser;
1938: xmlparser.ParseCLOB(l_parser,p_document);
1939: l_CommitNode := xmldom.makeNode(xmldom.getDocumentElement(xmlparser.getDocument(l_parser)));
1940: --
1941: hr_utility.set_location('Extracting the PostState:' || l_proc,20);
1934: hr_utility.set_location(' Entering:' || l_proc,10);
1935: hr_utility.set_location(' CLOB --> xmldom.DOMNode:' || l_proc,15);
1936: --
1937: l_parser := xmlparser.newParser;
1938: xmlparser.ParseCLOB(l_parser,p_document);
1939: l_CommitNode := xmldom.makeNode(xmldom.getDocumentElement(xmlparser.getDocument(l_parser)));
1940: --
1941: hr_utility.set_location('Extracting the PostState:' || l_proc,20);
1942:
1935: hr_utility.set_location(' CLOB --> xmldom.DOMNode:' || l_proc,15);
1936: --
1937: l_parser := xmlparser.newParser;
1938: xmlparser.ParseCLOB(l_parser,p_document);
1939: l_CommitNode := xmldom.makeNode(xmldom.getDocumentElement(xmlparser.getDocument(l_parser)));
1940: --
1941: hr_utility.set_location('Extracting the PostState:' || l_proc,20);
1942:
1943: l_commitElement := xmldom.makeElement(l_CommitNode);