361: l_postState VARCHAR2(2);
362: l_return_status VARCHAR2(1);
363: l_object_version_number number;
364: l_rec_team_member_id number;
365: l_commitElement xmldom.DOMElement;
366: l_parser xmlparser.Parser;
367: l_CommitNode xmldom.DOMNode;
368:
369: l_proc varchar2(72) := g_package || 'process_offers_api';
363: l_object_version_number number;
364: l_rec_team_member_id number;
365: l_commitElement xmldom.DOMElement;
366: l_parser xmlparser.Parser;
367: l_CommitNode xmldom.DOMNode;
368:
369: l_proc varchar2(72) := g_package || 'process_offers_api';
370: l_effective_date date := trunc(sysdate);
371:
371:
372: BEGIN
373: --
374: hr_utility.set_location(' Entering:' || l_proc,10);
375: hr_utility.set_location(' CLOB --> xmldom.DOMNode:' || l_proc,15);
376: --
377: l_parser := xmlparser.newParser;
378: xmlparser.ParseCLOB(l_parser,p_document);
379: l_CommitNode := xmldom.makeNode(xmldom.getDocumentElement(xmlparser.getDocument(l_parser)));
375: hr_utility.set_location(' CLOB --> xmldom.DOMNode:' || l_proc,15);
376: --
377: l_parser := xmlparser.newParser;
378: xmlparser.ParseCLOB(l_parser,p_document);
379: l_CommitNode := xmldom.makeNode(xmldom.getDocumentElement(xmlparser.getDocument(l_parser)));
380: --
381: hr_utility.set_location('Extracting the PostState:' || l_proc,20);
382:
383: l_commitElement := xmldom.makeElement(l_CommitNode);
379: l_CommitNode := xmldom.makeNode(xmldom.getDocumentElement(xmlparser.getDocument(l_parser)));
380: --
381: hr_utility.set_location('Extracting the PostState:' || l_proc,20);
382:
383: l_commitElement := xmldom.makeElement(l_CommitNode);
384: l_postState := xmldom.getAttribute(l_commitElement, 'PS');
385: --
386: --Get the values for in/out parameters
387: --
380: --
381: hr_utility.set_location('Extracting the PostState:' || l_proc,20);
382:
383: l_commitElement := xmldom.makeElement(l_CommitNode);
384: l_postState := xmldom.getAttribute(l_commitElement, 'PS');
385: --
386: --Get the values for in/out parameters
387: --
388: l_object_version_number := hr_transaction_swi.getNumberValue(l_CommitNode,'ObjectVersionNumber');