DBA Data[Home] [Help]

APPS.HR_UTIL_MISC_SS dependencies on XMLDOM

Line 1785: rootNode xmldom.DOMNode;

1781: lr_hr_api_transaction_rec hr_api_transactions%rowtype;
1782: l_save_attachment_old varchar2(30) := null;
1783: l_save_attachment_new varchar2(30) := null;
1784: l_save_attach boolean;
1785: rootNode xmldom.DOMNode;
1786: l_Attach_Node xmldom.DOMNode;
1787: l_TransCtx_Node xmldom.DOMNode;
1788: l_TransCtx_NodeList xmldom.DOMNodeList;
1789: l_Attach_NodeList xmldom.DOMNodeList;

Line 1786: l_Attach_Node xmldom.DOMNode;

1782: l_save_attachment_old varchar2(30) := null;
1783: l_save_attachment_new varchar2(30) := null;
1784: l_save_attach boolean;
1785: rootNode xmldom.DOMNode;
1786: l_Attach_Node xmldom.DOMNode;
1787: l_TransCtx_Node xmldom.DOMNode;
1788: l_TransCtx_NodeList xmldom.DOMNodeList;
1789: l_Attach_NodeList xmldom.DOMNodeList;
1790:

Line 1787: l_TransCtx_Node xmldom.DOMNode;

1783: l_save_attachment_new varchar2(30) := null;
1784: l_save_attach boolean;
1785: rootNode xmldom.DOMNode;
1786: l_Attach_Node xmldom.DOMNode;
1787: l_TransCtx_Node xmldom.DOMNode;
1788: l_TransCtx_NodeList xmldom.DOMNodeList;
1789: l_Attach_NodeList xmldom.DOMNodeList;
1790:
1791: cursor csr_trans_rec is

Line 1788: l_TransCtx_NodeList xmldom.DOMNodeList;

1784: l_save_attach boolean;
1785: rootNode xmldom.DOMNode;
1786: l_Attach_Node xmldom.DOMNode;
1787: l_TransCtx_Node xmldom.DOMNode;
1788: l_TransCtx_NodeList xmldom.DOMNodeList;
1789: l_Attach_NodeList xmldom.DOMNodeList;
1790:
1791: cursor csr_trans_rec is
1792: select *

Line 1789: l_Attach_NodeList xmldom.DOMNodeList;

1785: rootNode xmldom.DOMNode;
1786: l_Attach_Node xmldom.DOMNode;
1787: l_TransCtx_Node xmldom.DOMNode;
1788: l_TransCtx_NodeList xmldom.DOMNodeList;
1789: l_Attach_NodeList xmldom.DOMNodeList;
1790:
1791: cursor csr_trans_rec is
1792: select *
1793: from hr_api_transactions

Line 1824: rootNode := xmldom.makeNode(hr_transaction_swi.convertCLOBtoXMLElement(lr_hr_api_transaction_rec.transaction_document));

1820: l_save_attach := false;
1821:
1822: if( lr_hr_api_transaction_rec.transaction_document is not null) then
1823:
1824: rootNode := xmldom.makeNode(hr_transaction_swi.convertCLOBtoXMLElement(lr_hr_api_transaction_rec.transaction_document));
1825: l_TransCtx_NodeList :=xmldom.getChildrenByTagName(xmldom.makeElement(rootNode),'TransCtx');
1826:
1827: IF (xmldom.getLength(l_TransCtx_NodeList) > 0) THEN
1828: l_TransCtx_Node :=xmldom.item(l_TransCtx_NodeList,0);

Line 1825: l_TransCtx_NodeList :=xmldom.getChildrenByTagName(xmldom.makeElement(rootNode),'TransCtx');

1821:
1822: if( lr_hr_api_transaction_rec.transaction_document is not null) then
1823:
1824: rootNode := xmldom.makeNode(hr_transaction_swi.convertCLOBtoXMLElement(lr_hr_api_transaction_rec.transaction_document));
1825: l_TransCtx_NodeList :=xmldom.getChildrenByTagName(xmldom.makeElement(rootNode),'TransCtx');
1826:
1827: IF (xmldom.getLength(l_TransCtx_NodeList) > 0) THEN
1828: l_TransCtx_Node :=xmldom.item(l_TransCtx_NodeList,0);
1829: l_Attach_NodeList :=xmldom.getChildrenByTagName(xmldom.makeElement(l_TransCtx_Node),'AttachCheck');

Line 1827: IF (xmldom.getLength(l_TransCtx_NodeList) > 0) THEN

1823:
1824: rootNode := xmldom.makeNode(hr_transaction_swi.convertCLOBtoXMLElement(lr_hr_api_transaction_rec.transaction_document));
1825: l_TransCtx_NodeList :=xmldom.getChildrenByTagName(xmldom.makeElement(rootNode),'TransCtx');
1826:
1827: IF (xmldom.getLength(l_TransCtx_NodeList) > 0) THEN
1828: l_TransCtx_Node :=xmldom.item(l_TransCtx_NodeList,0);
1829: l_Attach_NodeList :=xmldom.getChildrenByTagName(xmldom.makeElement(l_TransCtx_Node),'AttachCheck');
1830: END IF;
1831:

Line 1828: l_TransCtx_Node :=xmldom.item(l_TransCtx_NodeList,0);

1824: rootNode := xmldom.makeNode(hr_transaction_swi.convertCLOBtoXMLElement(lr_hr_api_transaction_rec.transaction_document));
1825: l_TransCtx_NodeList :=xmldom.getChildrenByTagName(xmldom.makeElement(rootNode),'TransCtx');
1826:
1827: IF (xmldom.getLength(l_TransCtx_NodeList) > 0) THEN
1828: l_TransCtx_Node :=xmldom.item(l_TransCtx_NodeList,0);
1829: l_Attach_NodeList :=xmldom.getChildrenByTagName(xmldom.makeElement(l_TransCtx_Node),'AttachCheck');
1830: END IF;
1831:
1832: l_Attach_Node := xmldom.item(l_Attach_NodeList,0);

Line 1829: l_Attach_NodeList :=xmldom.getChildrenByTagName(xmldom.makeElement(l_TransCtx_Node),'AttachCheck');

1825: l_TransCtx_NodeList :=xmldom.getChildrenByTagName(xmldom.makeElement(rootNode),'TransCtx');
1826:
1827: IF (xmldom.getLength(l_TransCtx_NodeList) > 0) THEN
1828: l_TransCtx_Node :=xmldom.item(l_TransCtx_NodeList,0);
1829: l_Attach_NodeList :=xmldom.getChildrenByTagName(xmldom.makeElement(l_TransCtx_Node),'AttachCheck');
1830: END IF;
1831:
1832: l_Attach_Node := xmldom.item(l_Attach_NodeList,0);
1833: l_Attach_Node := xmldom.getFirstChild(l_Attach_Node);

Line 1832: l_Attach_Node := xmldom.item(l_Attach_NodeList,0);

1828: l_TransCtx_Node :=xmldom.item(l_TransCtx_NodeList,0);
1829: l_Attach_NodeList :=xmldom.getChildrenByTagName(xmldom.makeElement(l_TransCtx_Node),'AttachCheck');
1830: END IF;
1831:
1832: l_Attach_Node := xmldom.item(l_Attach_NodeList,0);
1833: l_Attach_Node := xmldom.getFirstChild(l_Attach_Node);
1834: l_save_attachment_new :=xmldom.getNodeValue(l_Attach_Node);
1835: else
1836:

Line 1833: l_Attach_Node := xmldom.getFirstChild(l_Attach_Node);

1829: l_Attach_NodeList :=xmldom.getChildrenByTagName(xmldom.makeElement(l_TransCtx_Node),'AttachCheck');
1830: END IF;
1831:
1832: l_Attach_Node := xmldom.item(l_Attach_NodeList,0);
1833: l_Attach_Node := xmldom.getFirstChild(l_Attach_Node);
1834: l_save_attachment_new :=xmldom.getNodeValue(l_Attach_Node);
1835: else
1836:
1837: l_save_attachment_old := wf_engine.getitemattrtext(lr_hr_api_transaction_rec.item_type,

Line 1834: l_save_attachment_new :=xmldom.getNodeValue(l_Attach_Node);

1830: END IF;
1831:
1832: l_Attach_Node := xmldom.item(l_Attach_NodeList,0);
1833: l_Attach_Node := xmldom.getFirstChild(l_Attach_Node);
1834: l_save_attachment_new :=xmldom.getNodeValue(l_Attach_Node);
1835: else
1836:
1837: l_save_attachment_old := wf_engine.getitemattrtext(lr_hr_api_transaction_rec.item_type,
1838: lr_hr_api_transaction_rec.item_key,