2484: IS
2485: l_postState VARCHAR2(2);
2486: l_return_status VARCHAR2(1);
2487: l_object_version_number number;
2488: l_commitElement xmldom.DOMElement;
2489: l_parser xmlparser.Parser;
2490: l_CommitNode xmldom.DOMNode;
2491: l_proc varchar2(72) := g_package || 'process_offers_api';
2492:
2486: l_return_status VARCHAR2(1);
2487: l_object_version_number number;
2488: l_commitElement xmldom.DOMElement;
2489: l_parser xmlparser.Parser;
2490: l_CommitNode xmldom.DOMNode;
2491: l_proc varchar2(72) := g_package || 'process_offers_api';
2492:
2493: -- Variables for OUT parameters
2494: l_offer_id number;
2504:
2505: BEGIN
2506: --
2507: hr_utility.set_location(' Entering:' || l_proc,10);
2508: hr_utility.set_location(' CLOB --> xmldom.DOMNode:' || l_proc,15);
2509: --
2510: l_parser := xmlparser.newParser;
2511: xmlparser.ParseCLOB(l_parser,p_document);
2512: l_CommitNode := xmldom.makeNode(xmldom.getDocumentElement(xmlparser.getDocument(l_parser)));
2508: hr_utility.set_location(' CLOB --> xmldom.DOMNode:' || l_proc,15);
2509: --
2510: l_parser := xmlparser.newParser;
2511: xmlparser.ParseCLOB(l_parser,p_document);
2512: l_CommitNode := xmldom.makeNode(xmldom.getDocumentElement(xmlparser.getDocument(l_parser)));
2513: --
2514: hr_utility.set_location('Extracting the PostState:' || l_proc,20);
2515:
2516: l_commitElement := xmldom.makeElement(l_CommitNode);
2512: l_CommitNode := xmldom.makeNode(xmldom.getDocumentElement(xmlparser.getDocument(l_parser)));
2513: --
2514: hr_utility.set_location('Extracting the PostState:' || l_proc,20);
2515:
2516: l_commitElement := xmldom.makeElement(l_CommitNode);
2517: l_postState := xmldom.getAttribute(l_commitElement, 'PS');
2518: --
2519: --Get the values for in/out parameters
2520: --
2513: --
2514: hr_utility.set_location('Extracting the PostState:' || l_proc,20);
2515:
2516: l_commitElement := xmldom.makeElement(l_CommitNode);
2517: l_postState := xmldom.getAttribute(l_commitElement, 'PS');
2518: --
2519: --Get the values for in/out parameters
2520: --
2521: l_offer_id := hr_transaction_swi.getNumberValue(l_CommitNode,'OfferId');
2630: )
2631: IS
2632: l_postState VARCHAR2(2);
2633: l_return_status VARCHAR2(1);
2634: l_commitElement xmldom.DOMElement;
2635: l_parser xmlparser.Parser;
2636: l_CommitNode xmldom.DOMNode;
2637: l_proc varchar2(72) := g_package || 'process_asg_api';
2638:
2632: l_postState VARCHAR2(2);
2633: l_return_status VARCHAR2(1);
2634: l_commitElement xmldom.DOMElement;
2635: l_parser xmlparser.Parser;
2636: l_CommitNode xmldom.DOMNode;
2637: l_proc varchar2(72) := g_package || 'process_asg_api';
2638:
2639: --
2640: l_assignment_id number;
2655:
2656: BEGIN
2657:
2658: hr_utility.set_location(' Entering:' || l_proc,10);
2659: hr_utility.set_location(' CLOB --> xmldom.DOMNode:' || l_proc,15);
2660:
2661: l_parser := xmlparser.newParser;
2662: xmlparser.ParseCLOB(l_parser,p_document);
2663: l_CommitNode := xmldom.makeNode(xmldom.getDocumentElement(xmlparser.getDocument(l_parser)));
2659: hr_utility.set_location(' CLOB --> xmldom.DOMNode:' || l_proc,15);
2660:
2661: l_parser := xmlparser.newParser;
2662: xmlparser.ParseCLOB(l_parser,p_document);
2663: l_CommitNode := xmldom.makeNode(xmldom.getDocumentElement(xmlparser.getDocument(l_parser)));
2664:
2665: hr_utility.set_location('Extracting the PostState:' || l_proc,20);
2666:
2667: l_commitElement := xmldom.makeElement(l_CommitNode);
2663: l_CommitNode := xmldom.makeNode(xmldom.getDocumentElement(xmlparser.getDocument(l_parser)));
2664:
2665: hr_utility.set_location('Extracting the PostState:' || l_proc,20);
2666:
2667: l_commitElement := xmldom.makeElement(l_CommitNode);
2668: l_postState := xmldom.getAttribute(l_commitElement, 'PS');
2669:
2670: --Get the values for in/out parameters
2671: l_assignment_id := hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentId');
2664:
2665: hr_utility.set_location('Extracting the PostState:' || l_proc,20);
2666:
2667: l_commitElement := xmldom.makeElement(l_CommitNode);
2668: l_postState := xmldom.getAttribute(l_commitElement, 'PS');
2669:
2670: --Get the values for in/out parameters
2671: l_assignment_id := hr_transaction_swi.getNumberValue(l_CommitNode,'AssignmentId');
2672: l_offer_id := hr_transaction_swi.getNumberValue(l_CommitNode,'OfferId');