216: IS
217: l_postState VARCHAR2(2);
218: l_return_status VARCHAR2(1);
219: l_object_version_number number;
220: l_commitElement xmldom.DOMElement;
221: l_parser xmlparser.Parser;
222: l_CommitNode xmldom.DOMNode;
223:
224: l_proc varchar2(72) := g_package || 'process_offers_api';
218: l_return_status VARCHAR2(1);
219: l_object_version_number number;
220: l_commitElement xmldom.DOMElement;
221: l_parser xmlparser.Parser;
222: l_CommitNode xmldom.DOMNode;
223:
224: l_proc varchar2(72) := g_package || 'process_offers_api';
225: l_effective_date date := trunc(sysdate);
226:
226:
227: BEGIN
228: --
229: hr_utility.set_location(' Entering:' || l_proc,10);
230: hr_utility.set_location(' CLOB --> xmldom.DOMNode:' || l_proc,15);
231: --
232: l_parser := xmlparser.newParser;
233: xmlparser.ParseCLOB(l_parser,p_document);
234: l_CommitNode := xmldom.makeNode(xmldom.getDocumentElement(xmlparser.getDocument(l_parser)));
230: hr_utility.set_location(' CLOB --> xmldom.DOMNode:' || l_proc,15);
231: --
232: l_parser := xmlparser.newParser;
233: xmlparser.ParseCLOB(l_parser,p_document);
234: l_CommitNode := xmldom.makeNode(xmldom.getDocumentElement(xmlparser.getDocument(l_parser)));
235: --
236: hr_utility.set_location('Extracting the PostState:' || l_proc,20);
237:
238: l_commitElement := xmldom.makeElement(l_CommitNode);
234: l_CommitNode := xmldom.makeNode(xmldom.getDocumentElement(xmlparser.getDocument(l_parser)));
235: --
236: hr_utility.set_location('Extracting the PostState:' || l_proc,20);
237:
238: l_commitElement := xmldom.makeElement(l_CommitNode);
239: l_postState := xmldom.getAttribute(l_commitElement, 'PS');
240: --
241: --Get the values for in/out parameters
242: --
235: --
236: hr_utility.set_location('Extracting the PostState:' || l_proc,20);
237:
238: l_commitElement := xmldom.makeElement(l_CommitNode);
239: l_postState := xmldom.getAttribute(l_commitElement, 'PS');
240: --
241: --Get the values for in/out parameters
242: --
243: l_object_version_number := hr_transaction_swi.getNumberValue(l_CommitNode,'ObjectVersionNumber');