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.PO_COMM_FPDSNG_PVT dependencies on DBMS_XMLGEN

Line 240: context DBMS_XMLGEN.ctxHandle;

236: l_file_name VARCHAR2(200);
237: l_media_id VARCHAR2(200);
238: l_language VARCHAR2(10);
239: l_doc_type VARCHAR2(25);
240: context DBMS_XMLGEN.ctxHandle;
241:
242: l_idvidQuery VARCHAR2(1000);
243: l_refidvidQuery VARCHAR2(1000);
244:

Line 457: context := dbms_xmlgen.newContext(l_idvidQuery);

453: END IF;
454:
455: /*IDVID */
456: l_progress:='018';
457: context := dbms_xmlgen.newContext(l_idvidQuery);
458: dbms_xmlgen.setRowsetTag(context,'IDVID');
459: dbms_xmlgen.setRowTag(context,NULL);
460: dbms_xmlgen.setConvertSpecialChars ( context, TRUE);
461: l_xml_result := dbms_xmlgen.getXML(context,DBMS_XMLGEN.NONE);

Line 458: dbms_xmlgen.setRowsetTag(context,'IDVID');

454:
455: /*IDVID */
456: l_progress:='018';
457: context := dbms_xmlgen.newContext(l_idvidQuery);
458: dbms_xmlgen.setRowsetTag(context,'IDVID');
459: dbms_xmlgen.setRowTag(context,NULL);
460: dbms_xmlgen.setConvertSpecialChars ( context, TRUE);
461: l_xml_result := dbms_xmlgen.getXML(context,DBMS_XMLGEN.NONE);
462: dbms_xmlgen.closeContext(context);

Line 459: dbms_xmlgen.setRowTag(context,NULL);

455: /*IDVID */
456: l_progress:='018';
457: context := dbms_xmlgen.newContext(l_idvidQuery);
458: dbms_xmlgen.setRowsetTag(context,'IDVID');
459: dbms_xmlgen.setRowTag(context,NULL);
460: dbms_xmlgen.setConvertSpecialChars ( context, TRUE);
461: l_xml_result := dbms_xmlgen.getXML(context,DBMS_XMLGEN.NONE);
462: dbms_xmlgen.closeContext(context);
463:

Line 460: dbms_xmlgen.setConvertSpecialChars ( context, TRUE);

456: l_progress:='018';
457: context := dbms_xmlgen.newContext(l_idvidQuery);
458: dbms_xmlgen.setRowsetTag(context,'IDVID');
459: dbms_xmlgen.setRowTag(context,NULL);
460: dbms_xmlgen.setConvertSpecialChars ( context, TRUE);
461: l_xml_result := dbms_xmlgen.getXML(context,DBMS_XMLGEN.NONE);
462: dbms_xmlgen.closeContext(context);
463:
464: /*REFERENCE IDVID */

Line 461: l_xml_result := dbms_xmlgen.getXML(context,DBMS_XMLGEN.NONE);

457: context := dbms_xmlgen.newContext(l_idvidQuery);
458: dbms_xmlgen.setRowsetTag(context,'IDVID');
459: dbms_xmlgen.setRowTag(context,NULL);
460: dbms_xmlgen.setConvertSpecialChars ( context, TRUE);
461: l_xml_result := dbms_xmlgen.getXML(context,DBMS_XMLGEN.NONE);
462: dbms_xmlgen.closeContext(context);
463:
464: /*REFERENCE IDVID */
465: l_progress:='019';

Line 462: dbms_xmlgen.closeContext(context);

458: dbms_xmlgen.setRowsetTag(context,'IDVID');
459: dbms_xmlgen.setRowTag(context,NULL);
460: dbms_xmlgen.setConvertSpecialChars ( context, TRUE);
461: l_xml_result := dbms_xmlgen.getXML(context,DBMS_XMLGEN.NONE);
462: dbms_xmlgen.closeContext(context);
463:
464: /*REFERENCE IDVID */
465: l_progress:='019';
466: context := dbms_xmlgen.newContext(l_refidvidQuery);

Line 466: context := dbms_xmlgen.newContext(l_refidvidQuery);

462: dbms_xmlgen.closeContext(context);
463:
464: /*REFERENCE IDVID */
465: l_progress:='019';
466: context := dbms_xmlgen.newContext(l_refidvidQuery);
467: dbms_xmlgen.setRowsetTag(context,'referencedIDVID');
468: dbms_xmlgen.setRowTag(context,NULL);
469: dbms_xmlgen.setConvertSpecialChars ( context, TRUE);
470: l_referencedidvid := dbms_xmlgen.getXML(context,DBMS_XMLGEN.NONE);

Line 467: dbms_xmlgen.setRowsetTag(context,'referencedIDVID');

463:
464: /*REFERENCE IDVID */
465: l_progress:='019';
466: context := dbms_xmlgen.newContext(l_refidvidQuery);
467: dbms_xmlgen.setRowsetTag(context,'referencedIDVID');
468: dbms_xmlgen.setRowTag(context,NULL);
469: dbms_xmlgen.setConvertSpecialChars ( context, TRUE);
470: l_referencedidvid := dbms_xmlgen.getXML(context,DBMS_XMLGEN.NONE);
471: dbms_xmlgen.closeContext(context);

Line 468: dbms_xmlgen.setRowTag(context,NULL);

464: /*REFERENCE IDVID */
465: l_progress:='019';
466: context := dbms_xmlgen.newContext(l_refidvidQuery);
467: dbms_xmlgen.setRowsetTag(context,'referencedIDVID');
468: dbms_xmlgen.setRowTag(context,NULL);
469: dbms_xmlgen.setConvertSpecialChars ( context, TRUE);
470: l_referencedidvid := dbms_xmlgen.getXML(context,DBMS_XMLGEN.NONE);
471: dbms_xmlgen.closeContext(context);
472:

Line 469: dbms_xmlgen.setConvertSpecialChars ( context, TRUE);

465: l_progress:='019';
466: context := dbms_xmlgen.newContext(l_refidvidQuery);
467: dbms_xmlgen.setRowsetTag(context,'referencedIDVID');
468: dbms_xmlgen.setRowTag(context,NULL);
469: dbms_xmlgen.setConvertSpecialChars ( context, TRUE);
470: l_referencedidvid := dbms_xmlgen.getXML(context,DBMS_XMLGEN.NONE);
471: dbms_xmlgen.closeContext(context);
472:
473:

Line 470: l_referencedidvid := dbms_xmlgen.getXML(context,DBMS_XMLGEN.NONE);

466: context := dbms_xmlgen.newContext(l_refidvidQuery);
467: dbms_xmlgen.setRowsetTag(context,'referencedIDVID');
468: dbms_xmlgen.setRowTag(context,NULL);
469: dbms_xmlgen.setConvertSpecialChars ( context, TRUE);
470: l_referencedidvid := dbms_xmlgen.getXML(context,DBMS_XMLGEN.NONE);
471: dbms_xmlgen.closeContext(context);
472:
473:
474: IF (PO_COMM_FPDSNG_PVT.getReleaseId()) IS NOT null THEN

Line 471: dbms_xmlgen.closeContext(context);

467: dbms_xmlgen.setRowsetTag(context,'referencedIDVID');
468: dbms_xmlgen.setRowTag(context,NULL);
469: dbms_xmlgen.setConvertSpecialChars ( context, TRUE);
470: l_referencedidvid := dbms_xmlgen.getXML(context,DBMS_XMLGEN.NONE);
471: dbms_xmlgen.closeContext(context);
472:
473:
474: IF (PO_COMM_FPDSNG_PVT.getReleaseId()) IS NOT null THEN
475: /*relevantContractDates */

Line 477: context := dbms_xmlgen.newContext(l_ContractDatesQuery);

473:
474: IF (PO_COMM_FPDSNG_PVT.getReleaseId()) IS NOT null THEN
475: /*relevantContractDates */
476: l_progress:='020';
477: context := dbms_xmlgen.newContext(l_ContractDatesQuery);
478: dbms_xmlgen.setRowsetTag(context,'relevantContractDates');
479: dbms_xmlgen.setRowTag(context,NULL);
480: dbms_xmlgen.setConvertSpecialChars ( context, TRUE);
481: l_ContractDates := dbms_xmlgen.getXML(context,DBMS_XMLGEN.NONE);

Line 478: dbms_xmlgen.setRowsetTag(context,'relevantContractDates');

474: IF (PO_COMM_FPDSNG_PVT.getReleaseId()) IS NOT null THEN
475: /*relevantContractDates */
476: l_progress:='020';
477: context := dbms_xmlgen.newContext(l_ContractDatesQuery);
478: dbms_xmlgen.setRowsetTag(context,'relevantContractDates');
479: dbms_xmlgen.setRowTag(context,NULL);
480: dbms_xmlgen.setConvertSpecialChars ( context, TRUE);
481: l_ContractDates := dbms_xmlgen.getXML(context,DBMS_XMLGEN.NONE);
482: dbms_xmlgen.closeContext(context);

Line 479: dbms_xmlgen.setRowTag(context,NULL);

475: /*relevantContractDates */
476: l_progress:='020';
477: context := dbms_xmlgen.newContext(l_ContractDatesQuery);
478: dbms_xmlgen.setRowsetTag(context,'relevantContractDates');
479: dbms_xmlgen.setRowTag(context,NULL);
480: dbms_xmlgen.setConvertSpecialChars ( context, TRUE);
481: l_ContractDates := dbms_xmlgen.getXML(context,DBMS_XMLGEN.NONE);
482: dbms_xmlgen.closeContext(context);
483: END IF;

Line 480: dbms_xmlgen.setConvertSpecialChars ( context, TRUE);

476: l_progress:='020';
477: context := dbms_xmlgen.newContext(l_ContractDatesQuery);
478: dbms_xmlgen.setRowsetTag(context,'relevantContractDates');
479: dbms_xmlgen.setRowTag(context,NULL);
480: dbms_xmlgen.setConvertSpecialChars ( context, TRUE);
481: l_ContractDates := dbms_xmlgen.getXML(context,DBMS_XMLGEN.NONE);
482: dbms_xmlgen.closeContext(context);
483: END IF;
484:

Line 481: l_ContractDates := dbms_xmlgen.getXML(context,DBMS_XMLGEN.NONE);

477: context := dbms_xmlgen.newContext(l_ContractDatesQuery);
478: dbms_xmlgen.setRowsetTag(context,'relevantContractDates');
479: dbms_xmlgen.setRowTag(context,NULL);
480: dbms_xmlgen.setConvertSpecialChars ( context, TRUE);
481: l_ContractDates := dbms_xmlgen.getXML(context,DBMS_XMLGEN.NONE);
482: dbms_xmlgen.closeContext(context);
483: END IF;
484:
485: /*Dollarvalues */

Line 482: dbms_xmlgen.closeContext(context);

478: dbms_xmlgen.setRowsetTag(context,'relevantContractDates');
479: dbms_xmlgen.setRowTag(context,NULL);
480: dbms_xmlgen.setConvertSpecialChars ( context, TRUE);
481: l_ContractDates := dbms_xmlgen.getXML(context,DBMS_XMLGEN.NONE);
482: dbms_xmlgen.closeContext(context);
483: END IF;
484:
485: /*Dollarvalues */
486: l_progress:='021';

Line 487: context := dbms_xmlgen.newContext(l_dollarValueQuery);

483: END IF;
484:
485: /*Dollarvalues */
486: l_progress:='021';
487: context := dbms_xmlgen.newContext(l_dollarValueQuery);
488: dbms_xmlgen.setRowsetTag(context,'dollarValues');
489: dbms_xmlgen.setRowTag(context,NULL);
490: dbms_xmlgen.setConvertSpecialChars ( context, TRUE);
491: l_dollarValues := dbms_xmlgen.getXML(context,DBMS_XMLGEN.NONE);

Line 488: dbms_xmlgen.setRowsetTag(context,'dollarValues');

484:
485: /*Dollarvalues */
486: l_progress:='021';
487: context := dbms_xmlgen.newContext(l_dollarValueQuery);
488: dbms_xmlgen.setRowsetTag(context,'dollarValues');
489: dbms_xmlgen.setRowTag(context,NULL);
490: dbms_xmlgen.setConvertSpecialChars ( context, TRUE);
491: l_dollarValues := dbms_xmlgen.getXML(context,DBMS_XMLGEN.NONE);
492: dbms_xmlgen.closeContext(context);

Line 489: dbms_xmlgen.setRowTag(context,NULL);

485: /*Dollarvalues */
486: l_progress:='021';
487: context := dbms_xmlgen.newContext(l_dollarValueQuery);
488: dbms_xmlgen.setRowsetTag(context,'dollarValues');
489: dbms_xmlgen.setRowTag(context,NULL);
490: dbms_xmlgen.setConvertSpecialChars ( context, TRUE);
491: l_dollarValues := dbms_xmlgen.getXML(context,DBMS_XMLGEN.NONE);
492: dbms_xmlgen.closeContext(context);
493:

Line 490: dbms_xmlgen.setConvertSpecialChars ( context, TRUE);

486: l_progress:='021';
487: context := dbms_xmlgen.newContext(l_dollarValueQuery);
488: dbms_xmlgen.setRowsetTag(context,'dollarValues');
489: dbms_xmlgen.setRowTag(context,NULL);
490: dbms_xmlgen.setConvertSpecialChars ( context, TRUE);
491: l_dollarValues := dbms_xmlgen.getXML(context,DBMS_XMLGEN.NONE);
492: dbms_xmlgen.closeContext(context);
493:
494: /*contract Marketing Data */

Line 491: l_dollarValues := dbms_xmlgen.getXML(context,DBMS_XMLGEN.NONE);

487: context := dbms_xmlgen.newContext(l_dollarValueQuery);
488: dbms_xmlgen.setRowsetTag(context,'dollarValues');
489: dbms_xmlgen.setRowTag(context,NULL);
490: dbms_xmlgen.setConvertSpecialChars ( context, TRUE);
491: l_dollarValues := dbms_xmlgen.getXML(context,DBMS_XMLGEN.NONE);
492: dbms_xmlgen.closeContext(context);
493:
494: /*contract Marketing Data */
495: l_progress:='022';

Line 492: dbms_xmlgen.closeContext(context);

488: dbms_xmlgen.setRowsetTag(context,'dollarValues');
489: dbms_xmlgen.setRowTag(context,NULL);
490: dbms_xmlgen.setConvertSpecialChars ( context, TRUE);
491: l_dollarValues := dbms_xmlgen.getXML(context,DBMS_XMLGEN.NONE);
492: dbms_xmlgen.closeContext(context);
493:
494: /*contract Marketing Data */
495: l_progress:='022';
496: context := dbms_xmlgen.newContext(l_contractMarketingQuery);

Line 496: context := dbms_xmlgen.newContext(l_contractMarketingQuery);

492: dbms_xmlgen.closeContext(context);
493:
494: /*contract Marketing Data */
495: l_progress:='022';
496: context := dbms_xmlgen.newContext(l_contractMarketingQuery);
497: dbms_xmlgen.setRowsetTag(context,'contractMarketingData');
498: dbms_xmlgen.setRowTag(context,NULL);
499: l_contractMarketingData := dbms_xmlgen.getXML(context,DBMS_XMLGEN.NONE);
500: dbms_xmlgen.closeContext(context);

Line 497: dbms_xmlgen.setRowsetTag(context,'contractMarketingData');

493:
494: /*contract Marketing Data */
495: l_progress:='022';
496: context := dbms_xmlgen.newContext(l_contractMarketingQuery);
497: dbms_xmlgen.setRowsetTag(context,'contractMarketingData');
498: dbms_xmlgen.setRowTag(context,NULL);
499: l_contractMarketingData := dbms_xmlgen.getXML(context,DBMS_XMLGEN.NONE);
500: dbms_xmlgen.closeContext(context);
501:

Line 498: dbms_xmlgen.setRowTag(context,NULL);

494: /*contract Marketing Data */
495: l_progress:='022';
496: context := dbms_xmlgen.newContext(l_contractMarketingQuery);
497: dbms_xmlgen.setRowsetTag(context,'contractMarketingData');
498: dbms_xmlgen.setRowTag(context,NULL);
499: l_contractMarketingData := dbms_xmlgen.getXML(context,DBMS_XMLGEN.NONE);
500: dbms_xmlgen.closeContext(context);
501:
502: /*contract Data */

Line 499: l_contractMarketingData := dbms_xmlgen.getXML(context,DBMS_XMLGEN.NONE);

495: l_progress:='022';
496: context := dbms_xmlgen.newContext(l_contractMarketingQuery);
497: dbms_xmlgen.setRowsetTag(context,'contractMarketingData');
498: dbms_xmlgen.setRowTag(context,NULL);
499: l_contractMarketingData := dbms_xmlgen.getXML(context,DBMS_XMLGEN.NONE);
500: dbms_xmlgen.closeContext(context);
501:
502: /*contract Data */
503: l_progress:='023';

Line 500: dbms_xmlgen.closeContext(context);

496: context := dbms_xmlgen.newContext(l_contractMarketingQuery);
497: dbms_xmlgen.setRowsetTag(context,'contractMarketingData');
498: dbms_xmlgen.setRowTag(context,NULL);
499: l_contractMarketingData := dbms_xmlgen.getXML(context,DBMS_XMLGEN.NONE);
500: dbms_xmlgen.closeContext(context);
501:
502: /*contract Data */
503: l_progress:='023';
504: context := dbms_xmlgen.newContext(l_contractDataQuery);

Line 504: context := dbms_xmlgen.newContext(l_contractDataQuery);

500: dbms_xmlgen.closeContext(context);
501:
502: /*contract Data */
503: l_progress:='023';
504: context := dbms_xmlgen.newContext(l_contractDataQuery);
505: dbms_xmlgen.setRowsetTag(context,'contractData');
506: dbms_xmlgen.setRowTag(context,NULL);
507: l_contractData := dbms_xmlgen.getXML(context,DBMS_XMLGEN.NONE);
508: dbms_xmlgen.closeContext(context);

Line 505: dbms_xmlgen.setRowsetTag(context,'contractData');

501:
502: /*contract Data */
503: l_progress:='023';
504: context := dbms_xmlgen.newContext(l_contractDataQuery);
505: dbms_xmlgen.setRowsetTag(context,'contractData');
506: dbms_xmlgen.setRowTag(context,NULL);
507: l_contractData := dbms_xmlgen.getXML(context,DBMS_XMLGEN.NONE);
508: dbms_xmlgen.closeContext(context);
509:

Line 506: dbms_xmlgen.setRowTag(context,NULL);

502: /*contract Data */
503: l_progress:='023';
504: context := dbms_xmlgen.newContext(l_contractDataQuery);
505: dbms_xmlgen.setRowsetTag(context,'contractData');
506: dbms_xmlgen.setRowTag(context,NULL);
507: l_contractData := dbms_xmlgen.getXML(context,DBMS_XMLGEN.NONE);
508: dbms_xmlgen.closeContext(context);
509:
510: /*ProductOrserrvice */

Line 507: l_contractData := dbms_xmlgen.getXML(context,DBMS_XMLGEN.NONE);

503: l_progress:='023';
504: context := dbms_xmlgen.newContext(l_contractDataQuery);
505: dbms_xmlgen.setRowsetTag(context,'contractData');
506: dbms_xmlgen.setRowTag(context,NULL);
507: l_contractData := dbms_xmlgen.getXML(context,DBMS_XMLGEN.NONE);
508: dbms_xmlgen.closeContext(context);
509:
510: /*ProductOrserrvice */
511: l_progress:='024';

Line 508: dbms_xmlgen.closeContext(context);

504: context := dbms_xmlgen.newContext(l_contractDataQuery);
505: dbms_xmlgen.setRowsetTag(context,'contractData');
506: dbms_xmlgen.setRowTag(context,NULL);
507: l_contractData := dbms_xmlgen.getXML(context,DBMS_XMLGEN.NONE);
508: dbms_xmlgen.closeContext(context);
509:
510: /*ProductOrserrvice */
511: l_progress:='024';
512: context := dbms_xmlgen.newContext(l_ProductInfoQuery);

Line 512: context := dbms_xmlgen.newContext(l_ProductInfoQuery);

508: dbms_xmlgen.closeContext(context);
509:
510: /*ProductOrserrvice */
511: l_progress:='024';
512: context := dbms_xmlgen.newContext(l_ProductInfoQuery);
513: dbms_xmlgen.setRowsetTag(context,'productOrServiceInfromation');
514: dbms_xmlgen.setRowTag(context,NULL);
515: dbms_xmlgen.setConvertSpecialChars ( context, TRUE);
516: l_productInfo := dbms_xmlgen.getXML(context,DBMS_XMLGEN.NONE);

Line 513: dbms_xmlgen.setRowsetTag(context,'productOrServiceInfromation');

509:
510: /*ProductOrserrvice */
511: l_progress:='024';
512: context := dbms_xmlgen.newContext(l_ProductInfoQuery);
513: dbms_xmlgen.setRowsetTag(context,'productOrServiceInfromation');
514: dbms_xmlgen.setRowTag(context,NULL);
515: dbms_xmlgen.setConvertSpecialChars ( context, TRUE);
516: l_productInfo := dbms_xmlgen.getXML(context,DBMS_XMLGEN.NONE);
517: dbms_xmlgen.closeContext(context);

Line 514: dbms_xmlgen.setRowTag(context,NULL);

510: /*ProductOrserrvice */
511: l_progress:='024';
512: context := dbms_xmlgen.newContext(l_ProductInfoQuery);
513: dbms_xmlgen.setRowsetTag(context,'productOrServiceInfromation');
514: dbms_xmlgen.setRowTag(context,NULL);
515: dbms_xmlgen.setConvertSpecialChars ( context, TRUE);
516: l_productInfo := dbms_xmlgen.getXML(context,DBMS_XMLGEN.NONE);
517: dbms_xmlgen.closeContext(context);
518:

Line 515: dbms_xmlgen.setConvertSpecialChars ( context, TRUE);

511: l_progress:='024';
512: context := dbms_xmlgen.newContext(l_ProductInfoQuery);
513: dbms_xmlgen.setRowsetTag(context,'productOrServiceInfromation');
514: dbms_xmlgen.setRowTag(context,NULL);
515: dbms_xmlgen.setConvertSpecialChars ( context, TRUE);
516: l_productInfo := dbms_xmlgen.getXML(context,DBMS_XMLGEN.NONE);
517: dbms_xmlgen.closeContext(context);
518:
519: /*Vendor Header*/

Line 516: l_productInfo := dbms_xmlgen.getXML(context,DBMS_XMLGEN.NONE);

512: context := dbms_xmlgen.newContext(l_ProductInfoQuery);
513: dbms_xmlgen.setRowsetTag(context,'productOrServiceInfromation');
514: dbms_xmlgen.setRowTag(context,NULL);
515: dbms_xmlgen.setConvertSpecialChars ( context, TRUE);
516: l_productInfo := dbms_xmlgen.getXML(context,DBMS_XMLGEN.NONE);
517: dbms_xmlgen.closeContext(context);
518:
519: /*Vendor Header*/
520: l_progress:='025';

Line 517: dbms_xmlgen.closeContext(context);

513: dbms_xmlgen.setRowsetTag(context,'productOrServiceInfromation');
514: dbms_xmlgen.setRowTag(context,NULL);
515: dbms_xmlgen.setConvertSpecialChars ( context, TRUE);
516: l_productInfo := dbms_xmlgen.getXML(context,DBMS_XMLGEN.NONE);
517: dbms_xmlgen.closeContext(context);
518:
519: /*Vendor Header*/
520: l_progress:='025';
521: context := dbms_xmlgen.newContext(l_vendorHeaderQuery);

Line 521: context := dbms_xmlgen.newContext(l_vendorHeaderQuery);

517: dbms_xmlgen.closeContext(context);
518:
519: /*Vendor Header*/
520: l_progress:='025';
521: context := dbms_xmlgen.newContext(l_vendorHeaderQuery);
522: dbms_xmlgen.setRowsetTag(context,'vendorHeader');
523: dbms_xmlgen.setRowTag(context,NULL);
524: dbms_xmlgen.setConvertSpecialChars ( context, TRUE);
525: l_vendorHeader := dbms_xmlgen.getXML(context,DBMS_XMLGEN.NONE);

Line 522: dbms_xmlgen.setRowsetTag(context,'vendorHeader');

518:
519: /*Vendor Header*/
520: l_progress:='025';
521: context := dbms_xmlgen.newContext(l_vendorHeaderQuery);
522: dbms_xmlgen.setRowsetTag(context,'vendorHeader');
523: dbms_xmlgen.setRowTag(context,NULL);
524: dbms_xmlgen.setConvertSpecialChars ( context, TRUE);
525: l_vendorHeader := dbms_xmlgen.getXML(context,DBMS_XMLGEN.NONE);
526: dbms_xmlgen.closeContext(context);

Line 523: dbms_xmlgen.setRowTag(context,NULL);

519: /*Vendor Header*/
520: l_progress:='025';
521: context := dbms_xmlgen.newContext(l_vendorHeaderQuery);
522: dbms_xmlgen.setRowsetTag(context,'vendorHeader');
523: dbms_xmlgen.setRowTag(context,NULL);
524: dbms_xmlgen.setConvertSpecialChars ( context, TRUE);
525: l_vendorHeader := dbms_xmlgen.getXML(context,DBMS_XMLGEN.NONE);
526: dbms_xmlgen.closeContext(context);
527:

Line 524: dbms_xmlgen.setConvertSpecialChars ( context, TRUE);

520: l_progress:='025';
521: context := dbms_xmlgen.newContext(l_vendorHeaderQuery);
522: dbms_xmlgen.setRowsetTag(context,'vendorHeader');
523: dbms_xmlgen.setRowTag(context,NULL);
524: dbms_xmlgen.setConvertSpecialChars ( context, TRUE);
525: l_vendorHeader := dbms_xmlgen.getXML(context,DBMS_XMLGEN.NONE);
526: dbms_xmlgen.closeContext(context);
527:
528: /*VendorLocation */

Line 525: l_vendorHeader := dbms_xmlgen.getXML(context,DBMS_XMLGEN.NONE);

521: context := dbms_xmlgen.newContext(l_vendorHeaderQuery);
522: dbms_xmlgen.setRowsetTag(context,'vendorHeader');
523: dbms_xmlgen.setRowTag(context,NULL);
524: dbms_xmlgen.setConvertSpecialChars ( context, TRUE);
525: l_vendorHeader := dbms_xmlgen.getXML(context,DBMS_XMLGEN.NONE);
526: dbms_xmlgen.closeContext(context);
527:
528: /*VendorLocation */
529: l_progress:='026';

Line 526: dbms_xmlgen.closeContext(context);

522: dbms_xmlgen.setRowsetTag(context,'vendorHeader');
523: dbms_xmlgen.setRowTag(context,NULL);
524: dbms_xmlgen.setConvertSpecialChars ( context, TRUE);
525: l_vendorHeader := dbms_xmlgen.getXML(context,DBMS_XMLGEN.NONE);
526: dbms_xmlgen.closeContext(context);
527:
528: /*VendorLocation */
529: l_progress:='026';
530: context := dbms_xmlgen.newContext(l_vendorLocQuery);

Line 530: context := dbms_xmlgen.newContext(l_vendorLocQuery);

526: dbms_xmlgen.closeContext(context);
527:
528: /*VendorLocation */
529: l_progress:='026';
530: context := dbms_xmlgen.newContext(l_vendorLocQuery);
531: dbms_xmlgen.setRowsetTag(context,'vendorLocation');
532: dbms_xmlgen.setRowTag(context,NULL);
533: dbms_xmlgen.setConvertSpecialChars ( context, TRUE);
534: l_vendorLocation := dbms_xmlgen.getXML(context,DBMS_XMLGEN.NONE);

Line 531: dbms_xmlgen.setRowsetTag(context,'vendorLocation');

527:
528: /*VendorLocation */
529: l_progress:='026';
530: context := dbms_xmlgen.newContext(l_vendorLocQuery);
531: dbms_xmlgen.setRowsetTag(context,'vendorLocation');
532: dbms_xmlgen.setRowTag(context,NULL);
533: dbms_xmlgen.setConvertSpecialChars ( context, TRUE);
534: l_vendorLocation := dbms_xmlgen.getXML(context,DBMS_XMLGEN.NONE);
535: dbms_xmlgen.closeContext(context);

Line 532: dbms_xmlgen.setRowTag(context,NULL);

528: /*VendorLocation */
529: l_progress:='026';
530: context := dbms_xmlgen.newContext(l_vendorLocQuery);
531: dbms_xmlgen.setRowsetTag(context,'vendorLocation');
532: dbms_xmlgen.setRowTag(context,NULL);
533: dbms_xmlgen.setConvertSpecialChars ( context, TRUE);
534: l_vendorLocation := dbms_xmlgen.getXML(context,DBMS_XMLGEN.NONE);
535: dbms_xmlgen.closeContext(context);
536:

Line 533: dbms_xmlgen.setConvertSpecialChars ( context, TRUE);

529: l_progress:='026';
530: context := dbms_xmlgen.newContext(l_vendorLocQuery);
531: dbms_xmlgen.setRowsetTag(context,'vendorLocation');
532: dbms_xmlgen.setRowTag(context,NULL);
533: dbms_xmlgen.setConvertSpecialChars ( context, TRUE);
534: l_vendorLocation := dbms_xmlgen.getXML(context,DBMS_XMLGEN.NONE);
535: dbms_xmlgen.closeContext(context);
536:
537: IF g_debug_stmt THEN

Line 534: l_vendorLocation := dbms_xmlgen.getXML(context,DBMS_XMLGEN.NONE);

530: context := dbms_xmlgen.newContext(l_vendorLocQuery);
531: dbms_xmlgen.setRowsetTag(context,'vendorLocation');
532: dbms_xmlgen.setRowTag(context,NULL);
533: dbms_xmlgen.setConvertSpecialChars ( context, TRUE);
534: l_vendorLocation := dbms_xmlgen.getXML(context,DBMS_XMLGEN.NONE);
535: dbms_xmlgen.closeContext(context);
536:
537: IF g_debug_stmt THEN
538: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'XML Data Generated after', l_progress);

Line 535: dbms_xmlgen.closeContext(context);

531: dbms_xmlgen.setRowsetTag(context,'vendorLocation');
532: dbms_xmlgen.setRowTag(context,NULL);
533: dbms_xmlgen.setConvertSpecialChars ( context, TRUE);
534: l_vendorLocation := dbms_xmlgen.getXML(context,DBMS_XMLGEN.NONE);
535: dbms_xmlgen.closeContext(context);
536:
537: IF g_debug_stmt THEN
538: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'XML Data Generated after', l_progress);
539: END IF;