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.CS_ERES_INT_PKG dependencies on DBMS_XMLDOM

Line 318: ( p_doc IN dbms_xmldom.domdocument

314: -- 10/25/05 grwang Created
315: -- 10/31/05 smisra added log messages
316: --------------------------------------------------------------------------------
317: FUNCTION make_node
318: ( p_doc IN dbms_xmldom.domdocument
319: , p_element_name IN VARCHAR2
320: , p_value IN VARCHAR2) RETURN dbms_xmldom.DOMNode AS
321:
322: elem dbms_xmldom.DOMElement;

Line 320: , p_value IN VARCHAR2) RETURN dbms_xmldom.DOMNode AS

316: --------------------------------------------------------------------------------
317: FUNCTION make_node
318: ( p_doc IN dbms_xmldom.domdocument
319: , p_element_name IN VARCHAR2
320: , p_value IN VARCHAR2) RETURN dbms_xmldom.DOMNode AS
321:
322: elem dbms_xmldom.DOMElement;
323: nelem dbms_xmldom.DOMNode;
324: agnode dbms_xmldom.DOMNode;

Line 322: elem dbms_xmldom.DOMElement;

318: ( p_doc IN dbms_xmldom.domdocument
319: , p_element_name IN VARCHAR2
320: , p_value IN VARCHAR2) RETURN dbms_xmldom.DOMNode AS
321:
322: elem dbms_xmldom.DOMElement;
323: nelem dbms_xmldom.DOMNode;
324: agnode dbms_xmldom.DOMNode;
325: text dbms_xmldom.DOMText;
326: tempnode dbms_xmldom.DOMNode := NULL;

Line 323: nelem dbms_xmldom.DOMNode;

319: , p_element_name IN VARCHAR2
320: , p_value IN VARCHAR2) RETURN dbms_xmldom.DOMNode AS
321:
322: elem dbms_xmldom.DOMElement;
323: nelem dbms_xmldom.DOMNode;
324: agnode dbms_xmldom.DOMNode;
325: text dbms_xmldom.DOMText;
326: tempnode dbms_xmldom.DOMNode := NULL;
327: BEGIN

Line 324: agnode dbms_xmldom.DOMNode;

320: , p_value IN VARCHAR2) RETURN dbms_xmldom.DOMNode AS
321:
322: elem dbms_xmldom.DOMElement;
323: nelem dbms_xmldom.DOMNode;
324: agnode dbms_xmldom.DOMNode;
325: text dbms_xmldom.DOMText;
326: tempnode dbms_xmldom.DOMNode := NULL;
327: BEGIN
328:

Line 325: text dbms_xmldom.DOMText;

321:
322: elem dbms_xmldom.DOMElement;
323: nelem dbms_xmldom.DOMNode;
324: agnode dbms_xmldom.DOMNode;
325: text dbms_xmldom.DOMText;
326: tempnode dbms_xmldom.DOMNode := NULL;
327: BEGIN
328:
329: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 326: tempnode dbms_xmldom.DOMNode := NULL;

322: elem dbms_xmldom.DOMElement;
323: nelem dbms_xmldom.DOMNode;
324: agnode dbms_xmldom.DOMNode;
325: text dbms_xmldom.DOMText;
326: tempnode dbms_xmldom.DOMNode := NULL;
327: BEGIN
328:
329: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
330: IF FND_LOG.TEST(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_ERES_INT_PKG.START_APPROVAL_PROCESS') THEN

Line 337: elem := dbms_xmldom.createelement(p_doc, p_element_name);

333: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_ERES_INT_PKG.START_APPROVAL_PROCESS', 'P_value :' || p_value);
334: END IF;
335: END IF;
336: --
337: elem := dbms_xmldom.createelement(p_doc, p_element_name);
338: agnode := dbms_xmldom.makenode(elem);
339:
340: -- create a text node
341: text := dbms_xmldom.createtextnode(p_doc, p_value);

Line 338: agnode := dbms_xmldom.makenode(elem);

334: END IF;
335: END IF;
336: --
337: elem := dbms_xmldom.createelement(p_doc, p_element_name);
338: agnode := dbms_xmldom.makenode(elem);
339:
340: -- create a text node
341: text := dbms_xmldom.createtextnode(p_doc, p_value);
342: -- make node

Line 341: text := dbms_xmldom.createtextnode(p_doc, p_value);

337: elem := dbms_xmldom.createelement(p_doc, p_element_name);
338: agnode := dbms_xmldom.makenode(elem);
339:
340: -- create a text node
341: text := dbms_xmldom.createtextnode(p_doc, p_value);
342: -- make node
343: nelem := dbms_xmldom.makeNode(text);
344:
345: tempnode := dbms_xmldom.appendchild(agnode,nelem);

Line 343: nelem := dbms_xmldom.makeNode(text);

339:
340: -- create a text node
341: text := dbms_xmldom.createtextnode(p_doc, p_value);
342: -- make node
343: nelem := dbms_xmldom.makeNode(text);
344:
345: tempnode := dbms_xmldom.appendchild(agnode,nelem);
346:
347: IF((FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN

Line 345: tempnode := dbms_xmldom.appendchild(agnode,nelem);

341: text := dbms_xmldom.createtextnode(p_doc, p_value);
342: -- make node
343: nelem := dbms_xmldom.makeNode(text);
344:
345: tempnode := dbms_xmldom.appendchild(agnode,nelem);
346:
347: IF((FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN
348: IF (FND_LOG.TEST(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_ERES_INT_PKG.START_APPROVAL_PROCESS')) THEN
349: dbg_msg := 'Returning Successfully from make_Node function';

Line 387: indomdoc dbms_xmldom.domdocument;

383: , p_xml_doc IN CLOB) RETURN CLOB AS
384:
385: xmldoc CLOB := p_xml_doc;
386:
387: indomdoc dbms_xmldom.domdocument;
388: innode dbms_xmldom.domnode;
389: childnode dbms_xmldom.DOMNode;
390: srnode dbms_xmldom.DOMNode;
391: myParser dbms_xmlparser.Parser;

Line 388: innode dbms_xmldom.domnode;

384:
385: xmldoc CLOB := p_xml_doc;
386:
387: indomdoc dbms_xmldom.domdocument;
388: innode dbms_xmldom.domnode;
389: childnode dbms_xmldom.DOMNode;
390: srnode dbms_xmldom.DOMNode;
391: myParser dbms_xmlparser.Parser;
392:

Line 389: childnode dbms_xmldom.DOMNode;

385: xmldoc CLOB := p_xml_doc;
386:
387: indomdoc dbms_xmldom.domdocument;
388: innode dbms_xmldom.domnode;
389: childnode dbms_xmldom.DOMNode;
390: srnode dbms_xmldom.DOMNode;
391: myParser dbms_xmlparser.Parser;
392:
393: elem dbms_xmldom.DOMElement;

Line 390: srnode dbms_xmldom.DOMNode;

386:
387: indomdoc dbms_xmldom.domdocument;
388: innode dbms_xmldom.domnode;
389: childnode dbms_xmldom.DOMNode;
390: srnode dbms_xmldom.DOMNode;
391: myParser dbms_xmlparser.Parser;
392:
393: elem dbms_xmldom.DOMElement;
394: attrm dbms_xmldom.DOMElement;

Line 393: elem dbms_xmldom.DOMElement;

389: childnode dbms_xmldom.DOMNode;
390: srnode dbms_xmldom.DOMNode;
391: myParser dbms_xmlparser.Parser;
392:
393: elem dbms_xmldom.DOMElement;
394: attrm dbms_xmldom.DOMElement;
395: topm dbms_xmldom.DOMElement;
396: topattrm dbms_xmldom.DOMElement;
397: topn dbms_xmldom.DOMNode;

Line 394: attrm dbms_xmldom.DOMElement;

390: srnode dbms_xmldom.DOMNode;
391: myParser dbms_xmlparser.Parser;
392:
393: elem dbms_xmldom.DOMElement;
394: attrm dbms_xmldom.DOMElement;
395: topm dbms_xmldom.DOMElement;
396: topattrm dbms_xmldom.DOMElement;
397: topn dbms_xmldom.DOMNode;
398: topattrn dbms_xmldom.DOMNode;

Line 395: topm dbms_xmldom.DOMElement;

391: myParser dbms_xmlparser.Parser;
392:
393: elem dbms_xmldom.DOMElement;
394: attrm dbms_xmldom.DOMElement;
395: topm dbms_xmldom.DOMElement;
396: topattrm dbms_xmldom.DOMElement;
397: topn dbms_xmldom.DOMNode;
398: topattrn dbms_xmldom.DOMNode;
399: nelem dbms_xmldom.DOMNode;

Line 396: topattrm dbms_xmldom.DOMElement;

392:
393: elem dbms_xmldom.DOMElement;
394: attrm dbms_xmldom.DOMElement;
395: topm dbms_xmldom.DOMElement;
396: topattrm dbms_xmldom.DOMElement;
397: topn dbms_xmldom.DOMNode;
398: topattrn dbms_xmldom.DOMNode;
399: nelem dbms_xmldom.DOMNode;
400: attrelem dbms_xmldom.DOMNode;

Line 397: topn dbms_xmldom.DOMNode;

393: elem dbms_xmldom.DOMElement;
394: attrm dbms_xmldom.DOMElement;
395: topm dbms_xmldom.DOMElement;
396: topattrm dbms_xmldom.DOMElement;
397: topn dbms_xmldom.DOMNode;
398: topattrn dbms_xmldom.DOMNode;
399: nelem dbms_xmldom.DOMNode;
400: attrelem dbms_xmldom.DOMNode;
401: agnode dbms_xmldom.DOMNode;

Line 398: topattrn dbms_xmldom.DOMNode;

394: attrm dbms_xmldom.DOMElement;
395: topm dbms_xmldom.DOMElement;
396: topattrm dbms_xmldom.DOMElement;
397: topn dbms_xmldom.DOMNode;
398: topattrn dbms_xmldom.DOMNode;
399: nelem dbms_xmldom.DOMNode;
400: attrelem dbms_xmldom.DOMNode;
401: agnode dbms_xmldom.DOMNode;
402: attrnode dbms_xmldom.DOMNode;

Line 399: nelem dbms_xmldom.DOMNode;

395: topm dbms_xmldom.DOMElement;
396: topattrm dbms_xmldom.DOMElement;
397: topn dbms_xmldom.DOMNode;
398: topattrn dbms_xmldom.DOMNode;
399: nelem dbms_xmldom.DOMNode;
400: attrelem dbms_xmldom.DOMNode;
401: agnode dbms_xmldom.DOMNode;
402: attrnode dbms_xmldom.DOMNode;
403:

Line 400: attrelem dbms_xmldom.DOMNode;

396: topattrm dbms_xmldom.DOMElement;
397: topn dbms_xmldom.DOMNode;
398: topattrn dbms_xmldom.DOMNode;
399: nelem dbms_xmldom.DOMNode;
400: attrelem dbms_xmldom.DOMNode;
401: agnode dbms_xmldom.DOMNode;
402: attrnode dbms_xmldom.DOMNode;
403:
404: attr_disp_value_node_ele dbms_xmldom.DOMElement;

Line 401: agnode dbms_xmldom.DOMNode;

397: topn dbms_xmldom.DOMNode;
398: topattrn dbms_xmldom.DOMNode;
399: nelem dbms_xmldom.DOMNode;
400: attrelem dbms_xmldom.DOMNode;
401: agnode dbms_xmldom.DOMNode;
402: attrnode dbms_xmldom.DOMNode;
403:
404: attr_disp_value_node_ele dbms_xmldom.DOMElement;
405: attr_disp_value_node dbms_xmldom.DOMNode;

Line 402: attrnode dbms_xmldom.DOMNode;

398: topattrn dbms_xmldom.DOMNode;
399: nelem dbms_xmldom.DOMNode;
400: attrelem dbms_xmldom.DOMNode;
401: agnode dbms_xmldom.DOMNode;
402: attrnode dbms_xmldom.DOMNode;
403:
404: attr_disp_value_node_ele dbms_xmldom.DOMElement;
405: attr_disp_value_node dbms_xmldom.DOMNode;
406:

Line 404: attr_disp_value_node_ele dbms_xmldom.DOMElement;

400: attrelem dbms_xmldom.DOMNode;
401: agnode dbms_xmldom.DOMNode;
402: attrnode dbms_xmldom.DOMNode;
403:
404: attr_disp_value_node_ele dbms_xmldom.DOMElement;
405: attr_disp_value_node dbms_xmldom.DOMNode;
406:
407: attr_disp_value_text_ele dbms_xmldom.DOMText;
408: attr_disp_value_text_node dbms_xmldom.DOMNode;

Line 405: attr_disp_value_node dbms_xmldom.DOMNode;

401: agnode dbms_xmldom.DOMNode;
402: attrnode dbms_xmldom.DOMNode;
403:
404: attr_disp_value_node_ele dbms_xmldom.DOMElement;
405: attr_disp_value_node dbms_xmldom.DOMNode;
406:
407: attr_disp_value_text_ele dbms_xmldom.DOMText;
408: attr_disp_value_text_node dbms_xmldom.DOMNode;
409:

Line 407: attr_disp_value_text_ele dbms_xmldom.DOMText;

403:
404: attr_disp_value_node_ele dbms_xmldom.DOMElement;
405: attr_disp_value_node dbms_xmldom.DOMNode;
406:
407: attr_disp_value_text_ele dbms_xmldom.DOMText;
408: attr_disp_value_text_node dbms_xmldom.DOMNode;
409:
410:
411: text dbms_xmldom.DOMText;

Line 408: attr_disp_value_text_node dbms_xmldom.DOMNode;

404: attr_disp_value_node_ele dbms_xmldom.DOMElement;
405: attr_disp_value_node dbms_xmldom.DOMNode;
406:
407: attr_disp_value_text_ele dbms_xmldom.DOMText;
408: attr_disp_value_text_node dbms_xmldom.DOMNode;
409:
410:
411: text dbms_xmldom.DOMText;
412: attrtext dbms_xmldom.DOMText;

Line 411: text dbms_xmldom.DOMText;

407: attr_disp_value_text_ele dbms_xmldom.DOMText;
408: attr_disp_value_text_node dbms_xmldom.DOMNode;
409:
410:
411: text dbms_xmldom.DOMText;
412: attrtext dbms_xmldom.DOMText;
413: tempnode dbms_xmldom.DOMNode;
414: sreanode dbms_xmldom.DOMNode;
415:

Line 412: attrtext dbms_xmldom.DOMText;

408: attr_disp_value_text_node dbms_xmldom.DOMNode;
409:
410:
411: text dbms_xmldom.DOMText;
412: attrtext dbms_xmldom.DOMText;
413: tempnode dbms_xmldom.DOMNode;
414: sreanode dbms_xmldom.DOMNode;
415:
416: l_extensibility_table CS_ServiceRequest_PUB.EXT_ATTR_GRP_TBL_TYPE;

Line 413: tempnode dbms_xmldom.DOMNode;

409:
410:
411: text dbms_xmldom.DOMText;
412: attrtext dbms_xmldom.DOMText;
413: tempnode dbms_xmldom.DOMNode;
414: sreanode dbms_xmldom.DOMNode;
415:
416: l_extensibility_table CS_ServiceRequest_PUB.EXT_ATTR_GRP_TBL_TYPE;
417: l_ext_attr_table CS_ServiceRequest_PUB.EXT_ATTR_TBL_TYPE;

Line 414: sreanode dbms_xmldom.DOMNode;

410:
411: text dbms_xmldom.DOMText;
412: attrtext dbms_xmldom.DOMText;
413: tempnode dbms_xmldom.DOMNode;
414: sreanode dbms_xmldom.DOMNode;
415:
416: l_extensibility_table CS_ServiceRequest_PUB.EXT_ATTR_GRP_TBL_TYPE;
417: l_ext_attr_table CS_ServiceRequest_PUB.EXT_ATTR_TBL_TYPE;
418:

Line 479: innode := dbms_xmldom.makeNode(indomdoc);

475: THEN
476: myParser := dbms_xmlparser.newParser;
477: dbms_xmlparser.parseBuffer(myParser, xmldoc);
478: indomdoc := dbms_xmlparser.getDocument(myParser);
479: innode := dbms_xmldom.makeNode(indomdoc);
480:
481: childnode := dbms_xmldom.getfirstchild(innode);
482: srnode := dbms_xmldom.getfirstchild(childnode);
483:

Line 481: childnode := dbms_xmldom.getfirstchild(innode);

477: dbms_xmlparser.parseBuffer(myParser, xmldoc);
478: indomdoc := dbms_xmlparser.getDocument(myParser);
479: innode := dbms_xmldom.makeNode(indomdoc);
480:
481: childnode := dbms_xmldom.getfirstchild(innode);
482: srnode := dbms_xmldom.getfirstchild(childnode);
483:
484: -- make sr ea node
485: elem := dbms_xmldom.createelement(indomdoc, 'EXTATTR');

Line 482: srnode := dbms_xmldom.getfirstchild(childnode);

478: indomdoc := dbms_xmlparser.getDocument(myParser);
479: innode := dbms_xmldom.makeNode(indomdoc);
480:
481: childnode := dbms_xmldom.getfirstchild(innode);
482: srnode := dbms_xmldom.getfirstchild(childnode);
483:
484: -- make sr ea node
485: elem := dbms_xmldom.createelement(indomdoc, 'EXTATTR');
486: sreanode := dbms_xmldom.makenode(elem);

Line 485: elem := dbms_xmldom.createelement(indomdoc, 'EXTATTR');

481: childnode := dbms_xmldom.getfirstchild(innode);
482: srnode := dbms_xmldom.getfirstchild(childnode);
483:
484: -- make sr ea node
485: elem := dbms_xmldom.createelement(indomdoc, 'EXTATTR');
486: sreanode := dbms_xmldom.makenode(elem);
487:
488:
489: FOR i IN l_extensibility_table.First..l_extensibility_table.LAST

Line 486: sreanode := dbms_xmldom.makenode(elem);

482: srnode := dbms_xmldom.getfirstchild(childnode);
483:
484: -- make sr ea node
485: elem := dbms_xmldom.createelement(indomdoc, 'EXTATTR');
486: sreanode := dbms_xmldom.makenode(elem);
487:
488:
489: FOR i IN l_extensibility_table.First..l_extensibility_table.LAST
490: LOOP

Line 492: topm := dbms_xmldom.createelement(indomdoc, 'ATTR_GROUP');

488:
489: FOR i IN l_extensibility_table.First..l_extensibility_table.LAST
490: LOOP
491:
492: topm := dbms_xmldom.createelement(indomdoc, 'ATTR_GROUP');
493: topn := dbms_xmldom.makenode(topm);
494:
495: -- add attribute group display name
496: tempnode := dbms_xmldom.appendchild

Line 493: topn := dbms_xmldom.makenode(topm);

489: FOR i IN l_extensibility_table.First..l_extensibility_table.LAST
490: LOOP
491:
492: topm := dbms_xmldom.createelement(indomdoc, 'ATTR_GROUP');
493: topn := dbms_xmldom.makenode(topm);
494:
495: -- add attribute group display name
496: tempnode := dbms_xmldom.appendchild
497: ( topn

Line 496: tempnode := dbms_xmldom.appendchild

492: topm := dbms_xmldom.createelement(indomdoc, 'ATTR_GROUP');
493: topn := dbms_xmldom.makenode(topm);
494:
495: -- add attribute group display name
496: tempnode := dbms_xmldom.appendchild
497: ( topn
498: , Make_Node
499: ( indomdoc
500: , 'ATTR_GROUP_DISP_NAME'

Line 508: tempnode := dbms_xmldom.appendchild

504: -- end attribute group display name
505:
506:
507: -- add_context
508: tempnode := dbms_xmldom.appendchild
509: ( topn
510: , Make_Node
511: ( indomdoc
512: , 'CONTEXT'

Line 524: topattrm := dbms_xmldom.createelement(indomdoc, 'ATTRS');

520:
521: IF l_extensibility_table(i).ROW_IDENTIFIER = l_ext_attr_table(j).ROW_IDENTIFIER
522: THEN
523: -- add attributes
524: topattrm := dbms_xmldom.createelement(indomdoc, 'ATTRS');
525: topattrn := dbms_xmldom.makenode(topattrm);
526:
527: -- add attr_name
528: tempnode := dbms_xmldom.appendchild

Line 525: topattrn := dbms_xmldom.makenode(topattrm);

521: IF l_extensibility_table(i).ROW_IDENTIFIER = l_ext_attr_table(j).ROW_IDENTIFIER
522: THEN
523: -- add attributes
524: topattrm := dbms_xmldom.createelement(indomdoc, 'ATTRS');
525: topattrn := dbms_xmldom.makenode(topattrm);
526:
527: -- add attr_name
528: tempnode := dbms_xmldom.appendchild
529: ( topattrn

Line 528: tempnode := dbms_xmldom.appendchild

524: topattrm := dbms_xmldom.createelement(indomdoc, 'ATTRS');
525: topattrn := dbms_xmldom.makenode(topattrm);
526:
527: -- add attr_name
528: tempnode := dbms_xmldom.appendchild
529: ( topattrn
530: , Make_Node
531: ( indomdoc
532: , 'ATTR_DISP_NAME'

Line 542: tempnode := dbms_xmldom.appendchild

538: -- attr_value_display
539: IF l_ext_attr_table(j).ATTR_VALUE_DATE IS NOT NULL THEN
540: IF l_timezone_enabled = 'Y' THEN
541:
542: tempnode := dbms_xmldom.appendchild
543: ( topattrn
544: , Make_Node
545: ( indomdoc
546: , 'ATTR_VALUE_DISPLAY'

Line 551: tempnode := dbms_xmldom.appendchild

547: , to_char(hz_timezone_pub.convert_datetime(l_server_timezone_id,l_client_timezone_id,l_ext_attr_table(j).ATTR_VALUE_DATE),l_date_format)
548: )
549: );
550: ELSE
551: tempnode := dbms_xmldom.appendchild
552: ( topattrn
553: , Make_Node
554: ( indomdoc
555: , 'ATTR_VALUE_DISPLAY'

Line 561: tempnode := dbms_xmldom.appendchild

557: )
558: );
559: END IF;
560: ELSE
561: tempnode := dbms_xmldom.appendchild
562: ( topattrn
563: , Make_Node
564: ( indomdoc
565: , 'ATTR_VALUE_DISPLAY'

Line 572: tempnode := dbms_xmldom.appendchild

568: );
569: END IF ;
570: -- attr_value_display_eof
571:
572: tempnode := dbms_xmldom.appendchild
573: ( topattrn
574: , Make_Node
575: ( indomdoc
576: , 'ATTR_UNIT_OF_MEASURE'

Line 580: tempnode := dbms_xmldom.appendchild(topn, topattrn);

576: , 'ATTR_UNIT_OF_MEASURE'
577: , l_ext_attr_table(j).ATTR_UNIT_OF_MEASURE
578: )
579: );
580: tempnode := dbms_xmldom.appendchild(topn, topattrn);
581:
582: END IF;
583:
584: END LOOP;

Line 586: tempnode := dbms_xmldom.appendchild(sreanode, topn);

582: END IF;
583:
584: END LOOP;
585:
586: tempnode := dbms_xmldom.appendchild(sreanode, topn);
587:
588: END LOOP; -- l_extensibility_table_end_loop
589:
590: tempnode := dbms_xmldom.appendchild(srnode,sreanode);

Line 590: tempnode := dbms_xmldom.appendchild(srnode,sreanode);

586: tempnode := dbms_xmldom.appendchild(sreanode, topn);
587:
588: END LOOP; -- l_extensibility_table_end_loop
589:
590: tempnode := dbms_xmldom.appendchild(srnode,sreanode);
591: dbms_xmldom.writetoclob(innode, xmldoc);
592:
593: END IF; --if_l_extensibility_table_null_eof
594: --

Line 591: dbms_xmldom.writetoclob(innode, xmldoc);

587:
588: END LOOP; -- l_extensibility_table_end_loop
589:
590: tempnode := dbms_xmldom.appendchild(srnode,sreanode);
591: dbms_xmldom.writetoclob(innode, xmldoc);
592:
593: END IF; --if_l_extensibility_table_null_eof
594: --
595: IF((FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN