XML Publisher and Bursting.

Creating the XML File:

     XML File

Creating XML Bursting Control File

  To Get the Location URL: Use the below query

 select application_short_name||'.'||

        TEMPLATE_CODE ||'.'||

        DEFAULT_LANGUAGE ||'.'||

        DEFAULT_TERRITORY url

   from xdo_templates_b

  where template_code = 'XXEXPD_EMPLOYEE_DET';

    XML Burst Ctrl File Download

Queries for XML Publishers

SELECT *  FROM XDO_DS_DEFINITIONS_B

WHERE DATA_SOURCE_CODE like 'XXEXPD_AR_PART_PAY_INV_RPT%';

SELECT *  FROM XDO_DS_DEFINITIONS_TL

WHERE DATA_SOURCE_CODE = 'XXEXPD_AR_PART_PAY_INV_RPT';

 

SELECT *  FROM XDO_LOBS

WHERE LOB_CODE = 'XXEXPD_AR_PART_PAY_INV_RPT';

 

SELECT *  FROM XDO_CONFIG_VALUES

WHERE DATA_SOURCE_CODE = 'XXEXPD_AR_PART_PAY_INV_RPT';

select * From XDO_TEMPLATES_B

Concurrent Program

Data Definition Registration

Template Registration

Quick Reference

<xsl:variable name="no_of_lines_per_page" select="number(37)"/>

<?for-each:$inner_group?>

<?if:position()>=$first_rec and position()<$first_rec+$no_of_lines_per_page?>

<?xdoxslt:set_variable($_XDOCTX, 'net_amt', 0)?>  
<?xdoxslt:set_variable($_XDOCTX, 'dis_amt', 0)?>


<?for-each:$inner_group?><?if:position()>=$first_rec and position()<$first_rec+$no_of_lines_per_page?>


<?for-each@section:OutboundPayment?>

<xsl:variable xdofo:ctx="incontext" name="inner_group" select="DocumentPayable"/>

<?for-each:$inner_group?><?if:(position()-1) mod $no_of_lines_per_page=0?>

<xsl:variable name="first_rec" xdofo:ctx="incontext" select="position()"/>


Printing Stars

<?xdofx:lpad('*',12-length(substr((PaymentAmount/Value),1,length(PaymentAmount/Value)-instr((PaymentAmount/Value),'.')+1)),'*')?>


<?PaymentAmount/Value?><?xdoxslt:set_variable($_XDOCTX,'net_amt', xdoxslt:get_variable($_XDOCTX,'net_amt')+ PaymentAmount/Value)?>

                                                                <?xdoxslt:get_variable($_XDOCTX,'net_amt') = PaymentAmount/Value?>


Form Field
==========
138 Characters is the Maximum after that we can write in the Help Tab.

Templates
=========

<?call-template:Header?>
<?template:countdown?>
Temp_Param

Recursive_Template
<?end template?>

Simple if
=========

<?xdofx:if COMM ='' then 'NULL' else ','?>

Simple Loop
===========
<?for-each:GROUP_NAE?> <?end for-each?>

Setting Variables
=================
<?xdoxslt:set_variable($_XDOCTX, 'net_amt', 0)?>  
<?xdoxslt:set_variable($_XDOCTX, 'dis_amt', 0)?>

Getting Variables
=================
<?xdoxslt:set_variable($_XDOCTX, 'net_amt', 0)?>  
<?xdoxslt:set_variable($_XDOCTX, 'dis_amt', 0)?>


Formatting Dates and Numbers
=============================
<?xdofx:to_char(PaymentDate,'DD-MON-YYYY')?>
<?format-number(PaymentAmount/Value, '#,##0.00;(-#,##0.00)')?>


Choose LayOut
=============
<?choose:?>
<?when:Payer/Address/Country='US'?>
<?Payer/Address/City?>
<?xdofx:if Payer/Address/State !='' then ',' end if?>
<?Payer/Address/S
<?end otherwise?>
<?end choose?>


Eg:2
<?choose:?><?when:Payer/Address/Country!='US'?>
<?Payer/Address/City?>
<?xdofx:if Payer/Address/State !='' then ',' end if?>
<?end otherwise?>
<?end choose?>

Number of Lines Per Pages
==========================
<?xdoxslt:set_variable($_XDOCTX, ’Counter’, 0)?> --outside the for-each 
<?xdoxslt:set_variable($_XDOCTX, ’Counter’, xdoxslt: get_variable($_XDOCTX, ’Counter’) + 2)?> 
<?if: xdoxslt:get_variable($_XDOCTX, ’Counter’) mod 10=0?> <?split-by-page-break:?> 
<?end if?> 

Adding Page Totals
==================

<?add-page-total:pt3;'COUNTED_VALUE'?>
<?add-page-total:pt2;'COUNTED_QTY'?>

Printing Page Total
====================

<?show-page-total:pt2?>
<?if:P_PRINT_ACTUAL_COUNTS='Y'?><?show-page-total:pt3?><?end if?>

Printing Numbers to Words
=========================
<?show-page-total:pt;'to_check_number:0;CASE_INIT_CAP'?>
<?show-page-total:pt2;'to_check_number:0;CASE_INIT_CAP'?>
<?show-page-total:pt3;'to_check_number:RUB;CASE_INIT_CAP;DECIMAL_STYLE_FRACTION2'?>

XXRL_UTILITIES_PKG.money_to_char(:AMT, :CURRENCY,'RU')


Printing Report Totals
======================
<?format-number:sum(ACCOUNTED_QTY);LC_FORMAT_STR?>
<?sum(ACCOUNTED_QTY)?>


Printing Serial Numbers
=======================
<?xdoxslt:set_variable($_XDOCTX, 'RTotVar', xdoxslt:get_variable($_XDOCTX, 'RTotVar') + 1)?>
<?xdoxslt:get_variable($_XDOCTX, 'RTotVar')?>

Printing Only the Decimal Part
==============================
<?xdofx:rpad(substr(ACTUAL_AMT_IN_NUM,instr(ACTUAL_AMT_IN_NUM, '.',1)+1),2,0)?>