eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMO_CBR_GRP dependencies on DBMS_XMLDOM

Line 1300: l_srcDoc dbms_xmldom.DOMDocument;

1296: l_result XMLType;
1297: l_erecID NUMBER(22);
1298: --This holds the query context.
1299: qryCtx DBMS_XMLGEN.ctxHandle;
1300: l_srcDoc dbms_xmldom.DOMDocument;
1301: l_srcDocEle dbms_xmldom.DOMELEMENT;
1302: l_parentRootNode DBMS_XMLDOM.DOMNODE;
1303: l_sigHDRDoc DBMS_XMLDOM.DOMDOCUMENT;
1304: l_childRootNode DBMS_XMLDOM.DOMNODE;

Line 1301: l_srcDocEle dbms_xmldom.DOMELEMENT;

1297: l_erecID NUMBER(22);
1298: --This holds the query context.
1299: qryCtx DBMS_XMLGEN.ctxHandle;
1300: l_srcDoc dbms_xmldom.DOMDocument;
1301: l_srcDocEle dbms_xmldom.DOMELEMENT;
1302: l_parentRootNode DBMS_XMLDOM.DOMNODE;
1303: l_sigHDRDoc DBMS_XMLDOM.DOMDOCUMENT;
1304: l_childRootNode DBMS_XMLDOM.DOMNODE;
1305: l_sigHDRDocEle dbms_xmldom.DOMELEMENT;

Line 1302: l_parentRootNode DBMS_XMLDOM.DOMNODE;

1298: --This holds the query context.
1299: qryCtx DBMS_XMLGEN.ctxHandle;
1300: l_srcDoc dbms_xmldom.DOMDocument;
1301: l_srcDocEle dbms_xmldom.DOMELEMENT;
1302: l_parentRootNode DBMS_XMLDOM.DOMNODE;
1303: l_sigHDRDoc DBMS_XMLDOM.DOMDOCUMENT;
1304: l_childRootNode DBMS_XMLDOM.DOMNODE;
1305: l_sigHDRDocEle dbms_xmldom.DOMELEMENT;
1306: l_childNodeList dbms_xmldom.DOMNodeList;

Line 1303: l_sigHDRDoc DBMS_XMLDOM.DOMDOCUMENT;

1299: qryCtx DBMS_XMLGEN.ctxHandle;
1300: l_srcDoc dbms_xmldom.DOMDocument;
1301: l_srcDocEle dbms_xmldom.DOMELEMENT;
1302: l_parentRootNode DBMS_XMLDOM.DOMNODE;
1303: l_sigHDRDoc DBMS_XMLDOM.DOMDOCUMENT;
1304: l_childRootNode DBMS_XMLDOM.DOMNODE;
1305: l_sigHDRDocEle dbms_xmldom.DOMELEMENT;
1306: l_childNodeList dbms_xmldom.DOMNodeList;
1307: l_childNode dbms_xmldom.DOMNode;

Line 1304: l_childRootNode DBMS_XMLDOM.DOMNODE;

1300: l_srcDoc dbms_xmldom.DOMDocument;
1301: l_srcDocEle dbms_xmldom.DOMELEMENT;
1302: l_parentRootNode DBMS_XMLDOM.DOMNODE;
1303: l_sigHDRDoc DBMS_XMLDOM.DOMDOCUMENT;
1304: l_childRootNode DBMS_XMLDOM.DOMNODE;
1305: l_sigHDRDocEle dbms_xmldom.DOMELEMENT;
1306: l_childNodeList dbms_xmldom.DOMNodeList;
1307: l_childNode dbms_xmldom.DOMNode;
1308: l_nodeListDel dbms_xmldom.DOMNodeList;

Line 1305: l_sigHDRDocEle dbms_xmldom.DOMELEMENT;

1301: l_srcDocEle dbms_xmldom.DOMELEMENT;
1302: l_parentRootNode DBMS_XMLDOM.DOMNODE;
1303: l_sigHDRDoc DBMS_XMLDOM.DOMDOCUMENT;
1304: l_childRootNode DBMS_XMLDOM.DOMNODE;
1305: l_sigHDRDocEle dbms_xmldom.DOMELEMENT;
1306: l_childNodeList dbms_xmldom.DOMNodeList;
1307: l_childNode dbms_xmldom.DOMNode;
1308: l_nodeListDel dbms_xmldom.DOMNodeList;
1309: l_tmpnode dbms_xmldom.DOMNode;

Line 1306: l_childNodeList dbms_xmldom.DOMNodeList;

1302: l_parentRootNode DBMS_XMLDOM.DOMNODE;
1303: l_sigHDRDoc DBMS_XMLDOM.DOMDOCUMENT;
1304: l_childRootNode DBMS_XMLDOM.DOMNODE;
1305: l_sigHDRDocEle dbms_xmldom.DOMELEMENT;
1306: l_childNodeList dbms_xmldom.DOMNodeList;
1307: l_childNode dbms_xmldom.DOMNode;
1308: l_nodeListDel dbms_xmldom.DOMNodeList;
1309: l_tmpnode dbms_xmldom.DOMNode;
1310: l_esigNode dbms_xmldom.DOMNode;

Line 1307: l_childNode dbms_xmldom.DOMNode;

1303: l_sigHDRDoc DBMS_XMLDOM.DOMDOCUMENT;
1304: l_childRootNode DBMS_XMLDOM.DOMNODE;
1305: l_sigHDRDocEle dbms_xmldom.DOMELEMENT;
1306: l_childNodeList dbms_xmldom.DOMNodeList;
1307: l_childNode dbms_xmldom.DOMNode;
1308: l_nodeListDel dbms_xmldom.DOMNodeList;
1309: l_tmpnode dbms_xmldom.DOMNode;
1310: l_esigNode dbms_xmldom.DOMNode;
1311: l_ehdrNode dbms_xmldom.DOMNode;

Line 1308: l_nodeListDel dbms_xmldom.DOMNodeList;

1304: l_childRootNode DBMS_XMLDOM.DOMNODE;
1305: l_sigHDRDocEle dbms_xmldom.DOMELEMENT;
1306: l_childNodeList dbms_xmldom.DOMNodeList;
1307: l_childNode dbms_xmldom.DOMNode;
1308: l_nodeListDel dbms_xmldom.DOMNodeList;
1309: l_tmpnode dbms_xmldom.DOMNode;
1310: l_esigNode dbms_xmldom.DOMNode;
1311: l_ehdrNode dbms_xmldom.DOMNode;
1312: l_eleNodeList dbms_xmldom.DOMNodeList;

Line 1309: l_tmpnode dbms_xmldom.DOMNode;

1305: l_sigHDRDocEle dbms_xmldom.DOMELEMENT;
1306: l_childNodeList dbms_xmldom.DOMNodeList;
1307: l_childNode dbms_xmldom.DOMNode;
1308: l_nodeListDel dbms_xmldom.DOMNodeList;
1309: l_tmpnode dbms_xmldom.DOMNode;
1310: l_esigNode dbms_xmldom.DOMNode;
1311: l_ehdrNode dbms_xmldom.DOMNode;
1312: l_eleNodeList dbms_xmldom.DOMNodeList;
1313: l_eleNode dbms_xmldom.DOMNode;

Line 1310: l_esigNode dbms_xmldom.DOMNode;

1306: l_childNodeList dbms_xmldom.DOMNodeList;
1307: l_childNode dbms_xmldom.DOMNode;
1308: l_nodeListDel dbms_xmldom.DOMNodeList;
1309: l_tmpnode dbms_xmldom.DOMNode;
1310: l_esigNode dbms_xmldom.DOMNode;
1311: l_ehdrNode dbms_xmldom.DOMNode;
1312: l_eleNodeList dbms_xmldom.DOMNodeList;
1313: l_eleNode dbms_xmldom.DOMNode;
1314: esigHdrFinalXML XMLType;

Line 1311: l_ehdrNode dbms_xmldom.DOMNode;

1307: l_childNode dbms_xmldom.DOMNode;
1308: l_nodeListDel dbms_xmldom.DOMNodeList;
1309: l_tmpnode dbms_xmldom.DOMNode;
1310: l_esigNode dbms_xmldom.DOMNode;
1311: l_ehdrNode dbms_xmldom.DOMNode;
1312: l_eleNodeList dbms_xmldom.DOMNodeList;
1313: l_eleNode dbms_xmldom.DOMNode;
1314: esigHdrFinalXML XMLType;
1315: l_debug_level number(2):=6;

Line 1312: l_eleNodeList dbms_xmldom.DOMNodeList;

1308: l_nodeListDel dbms_xmldom.DOMNodeList;
1309: l_tmpnode dbms_xmldom.DOMNode;
1310: l_esigNode dbms_xmldom.DOMNode;
1311: l_ehdrNode dbms_xmldom.DOMNode;
1312: l_eleNodeList dbms_xmldom.DOMNodeList;
1313: l_eleNode dbms_xmldom.DOMNode;
1314: esigHdrFinalXML XMLType;
1315: l_debug_level number(2):=6;
1316: l_error_code pls_integer;

Line 1313: l_eleNode dbms_xmldom.DOMNode;

1309: l_tmpnode dbms_xmldom.DOMNode;
1310: l_esigNode dbms_xmldom.DOMNode;
1311: l_ehdrNode dbms_xmldom.DOMNode;
1312: l_eleNodeList dbms_xmldom.DOMNodeList;
1313: l_eleNode dbms_xmldom.DOMNode;
1314: esigHdrFinalXML XMLType;
1315: l_debug_level number(2):=6;
1316: l_error_code pls_integer;
1317: l_log_file varchar2(2000);

Line 1342: l_srcDoc := dbms_xmldom.newDOMDocument(l_result);

1338:
1339: -- construct the XML Type object
1340: l_result := xmltype(l_xml);
1341:
1342: l_srcDoc := dbms_xmldom.newDOMDocument(l_result);
1343: l_srcDocEle := dbms_xmldom.getDocumentElement(l_srcDoc);
1344: l_parentRootNode := DBMS_XMLDOM.makeNode(l_srcDocEle);
1345: l_eleNodeList := dbms_xmldom.getElementsByTagName(l_srcDocEle,'InstrErecID');
1346: For i in 0..dbms_xmldom.getLength(l_eleNodeList)-1 LOOP

Line 1343: l_srcDocEle := dbms_xmldom.getDocumentElement(l_srcDoc);

1339: -- construct the XML Type object
1340: l_result := xmltype(l_xml);
1341:
1342: l_srcDoc := dbms_xmldom.newDOMDocument(l_result);
1343: l_srcDocEle := dbms_xmldom.getDocumentElement(l_srcDoc);
1344: l_parentRootNode := DBMS_XMLDOM.makeNode(l_srcDocEle);
1345: l_eleNodeList := dbms_xmldom.getElementsByTagName(l_srcDocEle,'InstrErecID');
1346: For i in 0..dbms_xmldom.getLength(l_eleNodeList)-1 LOOP
1347: l_eleNode := dbms_xmldom.item(l_eleNodeList, i);

Line 1344: l_parentRootNode := DBMS_XMLDOM.makeNode(l_srcDocEle);

1340: l_result := xmltype(l_xml);
1341:
1342: l_srcDoc := dbms_xmldom.newDOMDocument(l_result);
1343: l_srcDocEle := dbms_xmldom.getDocumentElement(l_srcDoc);
1344: l_parentRootNode := DBMS_XMLDOM.makeNode(l_srcDocEle);
1345: l_eleNodeList := dbms_xmldom.getElementsByTagName(l_srcDocEle,'InstrErecID');
1346: For i in 0..dbms_xmldom.getLength(l_eleNodeList)-1 LOOP
1347: l_eleNode := dbms_xmldom.item(l_eleNodeList, i);
1348: -- import Erec Header node and signature node

Line 1345: l_eleNodeList := dbms_xmldom.getElementsByTagName(l_srcDocEle,'InstrErecID');

1341:
1342: l_srcDoc := dbms_xmldom.newDOMDocument(l_result);
1343: l_srcDocEle := dbms_xmldom.getDocumentElement(l_srcDoc);
1344: l_parentRootNode := DBMS_XMLDOM.makeNode(l_srcDocEle);
1345: l_eleNodeList := dbms_xmldom.getElementsByTagName(l_srcDocEle,'InstrErecID');
1346: For i in 0..dbms_xmldom.getLength(l_eleNodeList)-1 LOOP
1347: l_eleNode := dbms_xmldom.item(l_eleNodeList, i);
1348: -- import Erec Header node and signature node
1349: l_erecID := TO_NUMBER(DBMS_XMLDOM.getNodeValue(DBMS_XMLDOM.getFirstChild(l_eleNode)));

Line 1346: For i in 0..dbms_xmldom.getLength(l_eleNodeList)-1 LOOP

1342: l_srcDoc := dbms_xmldom.newDOMDocument(l_result);
1343: l_srcDocEle := dbms_xmldom.getDocumentElement(l_srcDoc);
1344: l_parentRootNode := DBMS_XMLDOM.makeNode(l_srcDocEle);
1345: l_eleNodeList := dbms_xmldom.getElementsByTagName(l_srcDocEle,'InstrErecID');
1346: For i in 0..dbms_xmldom.getLength(l_eleNodeList)-1 LOOP
1347: l_eleNode := dbms_xmldom.item(l_eleNodeList, i);
1348: -- import Erec Header node and signature node
1349: l_erecID := TO_NUMBER(DBMS_XMLDOM.getNodeValue(DBMS_XMLDOM.getFirstChild(l_eleNode)));
1350: EDR_PSIG.GET_EVENT_XML(P_EVENT_NAME =>null,

Line 1347: l_eleNode := dbms_xmldom.item(l_eleNodeList, i);

1343: l_srcDocEle := dbms_xmldom.getDocumentElement(l_srcDoc);
1344: l_parentRootNode := DBMS_XMLDOM.makeNode(l_srcDocEle);
1345: l_eleNodeList := dbms_xmldom.getElementsByTagName(l_srcDocEle,'InstrErecID');
1346: For i in 0..dbms_xmldom.getLength(l_eleNodeList)-1 LOOP
1347: l_eleNode := dbms_xmldom.item(l_eleNodeList, i);
1348: -- import Erec Header node and signature node
1349: l_erecID := TO_NUMBER(DBMS_XMLDOM.getNodeValue(DBMS_XMLDOM.getFirstChild(l_eleNode)));
1350: EDR_PSIG.GET_EVENT_XML(P_EVENT_NAME =>null,
1351: P_EVENT_KEY => null,

Line 1349: l_erecID := TO_NUMBER(DBMS_XMLDOM.getNodeValue(DBMS_XMLDOM.getFirstChild(l_eleNode)));

1345: l_eleNodeList := dbms_xmldom.getElementsByTagName(l_srcDocEle,'InstrErecID');
1346: For i in 0..dbms_xmldom.getLength(l_eleNodeList)-1 LOOP
1347: l_eleNode := dbms_xmldom.item(l_eleNodeList, i);
1348: -- import Erec Header node and signature node
1349: l_erecID := TO_NUMBER(DBMS_XMLDOM.getNodeValue(DBMS_XMLDOM.getFirstChild(l_eleNode)));
1350: EDR_PSIG.GET_EVENT_XML(P_EVENT_NAME =>null,
1351: P_EVENT_KEY => null,
1352: P_ERECORD_ID => l_erecID,
1353: P_GET_ERECORD_XML =>'F',

Line 1363: l_sigHDRDoc := DBMS_XMLDOM.newDOMDocument(esigHdrFinalXML);

1359: esigHdrFinalXML := xmltype(l_final_xml);
1360:
1361:
1362: -- construct ESIG HDR Node
1363: l_sigHDRDoc := DBMS_XMLDOM.newDOMDocument(esigHdrFinalXML);
1364: -- make the Header Noe
1365: l_sigHDRDocEle := DBMS_XMLDOM.getDocumentElement(l_sigHDRDoc);
1366: l_childRootNode := DBMS_XMLDOM.makeNode(l_sigHDRDocEle);
1367:

Line 1365: l_sigHDRDocEle := DBMS_XMLDOM.getDocumentElement(l_sigHDRDoc);

1361:
1362: -- construct ESIG HDR Node
1363: l_sigHDRDoc := DBMS_XMLDOM.newDOMDocument(esigHdrFinalXML);
1364: -- make the Header Noe
1365: l_sigHDRDocEle := DBMS_XMLDOM.getDocumentElement(l_sigHDRDoc);
1366: l_childRootNode := DBMS_XMLDOM.makeNode(l_sigHDRDocEle);
1367:
1368: -- get the Heder Details node
1369: l_childNodeList := dbms_xmldom.getElementsByTagName(l_sigHDRDocEle,'ERECORD_HEADER_DETAILS');

Line 1366: l_childRootNode := DBMS_XMLDOM.makeNode(l_sigHDRDocEle);

1362: -- construct ESIG HDR Node
1363: l_sigHDRDoc := DBMS_XMLDOM.newDOMDocument(esigHdrFinalXML);
1364: -- make the Header Noe
1365: l_sigHDRDocEle := DBMS_XMLDOM.getDocumentElement(l_sigHDRDoc);
1366: l_childRootNode := DBMS_XMLDOM.makeNode(l_sigHDRDocEle);
1367:
1368: -- get the Heder Details node
1369: l_childNodeList := dbms_xmldom.getElementsByTagName(l_sigHDRDocEle,'ERECORD_HEADER_DETAILS');
1370: l_ehdrNode := dbms_xmldom.item(l_childNodeList, 0);

Line 1369: l_childNodeList := dbms_xmldom.getElementsByTagName(l_sigHDRDocEle,'ERECORD_HEADER_DETAILS');

1365: l_sigHDRDocEle := DBMS_XMLDOM.getDocumentElement(l_sigHDRDoc);
1366: l_childRootNode := DBMS_XMLDOM.makeNode(l_sigHDRDocEle);
1367:
1368: -- get the Heder Details node
1369: l_childNodeList := dbms_xmldom.getElementsByTagName(l_sigHDRDocEle,'ERECORD_HEADER_DETAILS');
1370: l_ehdrNode := dbms_xmldom.item(l_childNodeList, 0);
1371: -- get the Node to be deleted
1372: l_nodeListDel := dbms_xmldom.getElementsByTagName(l_sigHDRDocEle,'DOC_PARAM_DETAILS');
1373: For i in 0..dbms_xmldom.getLength(l_nodeListDel)-1 LOOP

Line 1370: l_ehdrNode := dbms_xmldom.item(l_childNodeList, 0);

1366: l_childRootNode := DBMS_XMLDOM.makeNode(l_sigHDRDocEle);
1367:
1368: -- get the Heder Details node
1369: l_childNodeList := dbms_xmldom.getElementsByTagName(l_sigHDRDocEle,'ERECORD_HEADER_DETAILS');
1370: l_ehdrNode := dbms_xmldom.item(l_childNodeList, 0);
1371: -- get the Node to be deleted
1372: l_nodeListDel := dbms_xmldom.getElementsByTagName(l_sigHDRDocEle,'DOC_PARAM_DETAILS');
1373: For i in 0..dbms_xmldom.getLength(l_nodeListDel)-1 LOOP
1374: l_tmpnode := dbms_xmldom.item(l_nodeListDel, i);

Line 1372: l_nodeListDel := dbms_xmldom.getElementsByTagName(l_sigHDRDocEle,'DOC_PARAM_DETAILS');

1368: -- get the Heder Details node
1369: l_childNodeList := dbms_xmldom.getElementsByTagName(l_sigHDRDocEle,'ERECORD_HEADER_DETAILS');
1370: l_ehdrNode := dbms_xmldom.item(l_childNodeList, 0);
1371: -- get the Node to be deleted
1372: l_nodeListDel := dbms_xmldom.getElementsByTagName(l_sigHDRDocEle,'DOC_PARAM_DETAILS');
1373: For i in 0..dbms_xmldom.getLength(l_nodeListDel)-1 LOOP
1374: l_tmpnode := dbms_xmldom.item(l_nodeListDel, i);
1375: l_childNode := dbms_xmldom.removeChild(l_ehdrNode,l_tmpnode);
1376: END LOOP;

Line 1373: For i in 0..dbms_xmldom.getLength(l_nodeListDel)-1 LOOP

1369: l_childNodeList := dbms_xmldom.getElementsByTagName(l_sigHDRDocEle,'ERECORD_HEADER_DETAILS');
1370: l_ehdrNode := dbms_xmldom.item(l_childNodeList, 0);
1371: -- get the Node to be deleted
1372: l_nodeListDel := dbms_xmldom.getElementsByTagName(l_sigHDRDocEle,'DOC_PARAM_DETAILS');
1373: For i in 0..dbms_xmldom.getLength(l_nodeListDel)-1 LOOP
1374: l_tmpnode := dbms_xmldom.item(l_nodeListDel, i);
1375: l_childNode := dbms_xmldom.removeChild(l_ehdrNode,l_tmpnode);
1376: END LOOP;
1377:

Line 1374: l_tmpnode := dbms_xmldom.item(l_nodeListDel, i);

1370: l_ehdrNode := dbms_xmldom.item(l_childNodeList, 0);
1371: -- get the Node to be deleted
1372: l_nodeListDel := dbms_xmldom.getElementsByTagName(l_sigHDRDocEle,'DOC_PARAM_DETAILS');
1373: For i in 0..dbms_xmldom.getLength(l_nodeListDel)-1 LOOP
1374: l_tmpnode := dbms_xmldom.item(l_nodeListDel, i);
1375: l_childNode := dbms_xmldom.removeChild(l_ehdrNode,l_tmpnode);
1376: END LOOP;
1377:
1378: -- get the Signature Details node

Line 1375: l_childNode := dbms_xmldom.removeChild(l_ehdrNode,l_tmpnode);

1371: -- get the Node to be deleted
1372: l_nodeListDel := dbms_xmldom.getElementsByTagName(l_sigHDRDocEle,'DOC_PARAM_DETAILS');
1373: For i in 0..dbms_xmldom.getLength(l_nodeListDel)-1 LOOP
1374: l_tmpnode := dbms_xmldom.item(l_nodeListDel, i);
1375: l_childNode := dbms_xmldom.removeChild(l_ehdrNode,l_tmpnode);
1376: END LOOP;
1377:
1378: -- get the Signature Details node
1379: l_childNodeList := dbms_xmldom.getElementsByTagName(l_sigHDRDocEle,'ERECORD_SIGNATURE_DETAILS');

Line 1379: l_childNodeList := dbms_xmldom.getElementsByTagName(l_sigHDRDocEle,'ERECORD_SIGNATURE_DETAILS');

1375: l_childNode := dbms_xmldom.removeChild(l_ehdrNode,l_tmpnode);
1376: END LOOP;
1377:
1378: -- get the Signature Details node
1379: l_childNodeList := dbms_xmldom.getElementsByTagName(l_sigHDRDocEle,'ERECORD_SIGNATURE_DETAILS');
1380: l_esigNode := dbms_xmldom.item(l_childNodeList, 0);
1381: -- get the Node to be deleted
1382: l_nodeListDel := dbms_xmldom.getElementsByTagName(l_sigHDRDocEle,'SIGNATURE_PARAMS');
1383: For i in 0..dbms_xmldom.getLength(l_nodeListDel)-1 LOOP

Line 1380: l_esigNode := dbms_xmldom.item(l_childNodeList, 0);

1376: END LOOP;
1377:
1378: -- get the Signature Details node
1379: l_childNodeList := dbms_xmldom.getElementsByTagName(l_sigHDRDocEle,'ERECORD_SIGNATURE_DETAILS');
1380: l_esigNode := dbms_xmldom.item(l_childNodeList, 0);
1381: -- get the Node to be deleted
1382: l_nodeListDel := dbms_xmldom.getElementsByTagName(l_sigHDRDocEle,'SIGNATURE_PARAMS');
1383: For i in 0..dbms_xmldom.getLength(l_nodeListDel)-1 LOOP
1384: l_tmpnode := dbms_xmldom.item(l_nodeListDel, i);

Line 1382: l_nodeListDel := dbms_xmldom.getElementsByTagName(l_sigHDRDocEle,'SIGNATURE_PARAMS');

1378: -- get the Signature Details node
1379: l_childNodeList := dbms_xmldom.getElementsByTagName(l_sigHDRDocEle,'ERECORD_SIGNATURE_DETAILS');
1380: l_esigNode := dbms_xmldom.item(l_childNodeList, 0);
1381: -- get the Node to be deleted
1382: l_nodeListDel := dbms_xmldom.getElementsByTagName(l_sigHDRDocEle,'SIGNATURE_PARAMS');
1383: For i in 0..dbms_xmldom.getLength(l_nodeListDel)-1 LOOP
1384: l_tmpnode := dbms_xmldom.item(l_nodeListDel, i);
1385: l_childNode := dbms_xmldom.removeChild(l_esigNode,l_tmpnode);
1386: END LOOP;

Line 1383: For i in 0..dbms_xmldom.getLength(l_nodeListDel)-1 LOOP

1379: l_childNodeList := dbms_xmldom.getElementsByTagName(l_sigHDRDocEle,'ERECORD_SIGNATURE_DETAILS');
1380: l_esigNode := dbms_xmldom.item(l_childNodeList, 0);
1381: -- get the Node to be deleted
1382: l_nodeListDel := dbms_xmldom.getElementsByTagName(l_sigHDRDocEle,'SIGNATURE_PARAMS');
1383: For i in 0..dbms_xmldom.getLength(l_nodeListDel)-1 LOOP
1384: l_tmpnode := dbms_xmldom.item(l_nodeListDel, i);
1385: l_childNode := dbms_xmldom.removeChild(l_esigNode,l_tmpnode);
1386: END LOOP;
1387: -- append Signature node into Header node

Line 1384: l_tmpnode := dbms_xmldom.item(l_nodeListDel, i);

1380: l_esigNode := dbms_xmldom.item(l_childNodeList, 0);
1381: -- get the Node to be deleted
1382: l_nodeListDel := dbms_xmldom.getElementsByTagName(l_sigHDRDocEle,'SIGNATURE_PARAMS');
1383: For i in 0..dbms_xmldom.getLength(l_nodeListDel)-1 LOOP
1384: l_tmpnode := dbms_xmldom.item(l_nodeListDel, i);
1385: l_childNode := dbms_xmldom.removeChild(l_esigNode,l_tmpnode);
1386: END LOOP;
1387: -- append Signature node into Header node
1388: if (dbms_xmldom.isNull(l_esigNode) = false) THEN

Line 1385: l_childNode := dbms_xmldom.removeChild(l_esigNode,l_tmpnode);

1381: -- get the Node to be deleted
1382: l_nodeListDel := dbms_xmldom.getElementsByTagName(l_sigHDRDocEle,'SIGNATURE_PARAMS');
1383: For i in 0..dbms_xmldom.getLength(l_nodeListDel)-1 LOOP
1384: l_tmpnode := dbms_xmldom.item(l_nodeListDel, i);
1385: l_childNode := dbms_xmldom.removeChild(l_esigNode,l_tmpnode);
1386: END LOOP;
1387: -- append Signature node into Header node
1388: if (dbms_xmldom.isNull(l_esigNode) = false) THEN
1389: l_tmpnode := dbms_xmldom.appendChild(l_ehdrNode,l_esigNode);

Line 1388: if (dbms_xmldom.isNull(l_esigNode) = false) THEN

1384: l_tmpnode := dbms_xmldom.item(l_nodeListDel, i);
1385: l_childNode := dbms_xmldom.removeChild(l_esigNode,l_tmpnode);
1386: END LOOP;
1387: -- append Signature node into Header node
1388: if (dbms_xmldom.isNull(l_esigNode) = false) THEN
1389: l_tmpnode := dbms_xmldom.appendChild(l_ehdrNode,l_esigNode);
1390: END IF;
1391:
1392: -- import the Hdr node in Source Document

Line 1389: l_tmpnode := dbms_xmldom.appendChild(l_ehdrNode,l_esigNode);

1385: l_childNode := dbms_xmldom.removeChild(l_esigNode,l_tmpnode);
1386: END LOOP;
1387: -- append Signature node into Header node
1388: if (dbms_xmldom.isNull(l_esigNode) = false) THEN
1389: l_tmpnode := dbms_xmldom.appendChild(l_ehdrNode,l_esigNode);
1390: END IF;
1391:
1392: -- import the Hdr node in Source Document
1393: l_childRootNode := dbms_xmldom.importNode(l_srcDoc,l_childRootNode,TRUE);

Line 1393: l_childRootNode := dbms_xmldom.importNode(l_srcDoc,l_childRootNode,TRUE);

1389: l_tmpnode := dbms_xmldom.appendChild(l_ehdrNode,l_esigNode);
1390: END IF;
1391:
1392: -- import the Hdr node in Source Document
1393: l_childRootNode := dbms_xmldom.importNode(l_srcDoc,l_childRootNode,TRUE);
1394: -- append the HDR node in Source XML
1395: l_parentRootNode := dbms_xmldom.appendChild(dbms_xmldom.getParentNode(l_eleNode),l_childRootNode);
1396: if (dbms_xmldom.isNull(l_sigHDRDoc) = false) THEN
1397: dbms_xmldom.freeDocument(l_sigHDRDoc);

Line 1395: l_parentRootNode := dbms_xmldom.appendChild(dbms_xmldom.getParentNode(l_eleNode),l_childRootNode);

1391:
1392: -- import the Hdr node in Source Document
1393: l_childRootNode := dbms_xmldom.importNode(l_srcDoc,l_childRootNode,TRUE);
1394: -- append the HDR node in Source XML
1395: l_parentRootNode := dbms_xmldom.appendChild(dbms_xmldom.getParentNode(l_eleNode),l_childRootNode);
1396: if (dbms_xmldom.isNull(l_sigHDRDoc) = false) THEN
1397: dbms_xmldom.freeDocument(l_sigHDRDoc);
1398: End IF;
1399: END LOOP;

Line 1396: if (dbms_xmldom.isNull(l_sigHDRDoc) = false) THEN

1392: -- import the Hdr node in Source Document
1393: l_childRootNode := dbms_xmldom.importNode(l_srcDoc,l_childRootNode,TRUE);
1394: -- append the HDR node in Source XML
1395: l_parentRootNode := dbms_xmldom.appendChild(dbms_xmldom.getParentNode(l_eleNode),l_childRootNode);
1396: if (dbms_xmldom.isNull(l_sigHDRDoc) = false) THEN
1397: dbms_xmldom.freeDocument(l_sigHDRDoc);
1398: End IF;
1399: END LOOP;
1400:

Line 1397: dbms_xmldom.freeDocument(l_sigHDRDoc);

1393: l_childRootNode := dbms_xmldom.importNode(l_srcDoc,l_childRootNode,TRUE);
1394: -- append the HDR node in Source XML
1395: l_parentRootNode := dbms_xmldom.appendChild(dbms_xmldom.getParentNode(l_eleNode),l_childRootNode);
1396: if (dbms_xmldom.isNull(l_sigHDRDoc) = false) THEN
1397: dbms_xmldom.freeDocument(l_sigHDRDoc);
1398: End IF;
1399: END LOOP;
1400:
1401: X_FINAL_XML := l_result.extract('//INSTRUCTION_SET');

Line 1402: if (dbms_xmldom.isNull(l_srcDoc) = false) THEN

1398: End IF;
1399: END LOOP;
1400:
1401: X_FINAL_XML := l_result.extract('//INSTRUCTION_SET');
1402: if (dbms_xmldom.isNull(l_srcDoc) = false) THEN
1403: dbms_xmldom.freeDocument(l_srcDoc);
1404: End IF;
1405: EXCEPTION
1406: when DB_TO_XML_ERROR then

Line 1403: dbms_xmldom.freeDocument(l_srcDoc);

1399: END LOOP;
1400:
1401: X_FINAL_XML := l_result.extract('//INSTRUCTION_SET');
1402: if (dbms_xmldom.isNull(l_srcDoc) = false) THEN
1403: dbms_xmldom.freeDocument(l_srcDoc);
1404: End IF;
1405: EXCEPTION
1406: when DB_TO_XML_ERROR then
1407: FND_MESSAGE.SET_NAME('GMO','GMO_VALIDATE_XML_GEN_ERR');