Wednesday 20 February 2019

How to Pass Muliple Values in Parameter and parse data in rtf

Sample XML:

<?xml version = '1.0' encoding = 'utf-8'?>
<DATA_DS>
<P_AIW>[1000,5000,9000,12000]</P_AIW>
<getAmt>
<return><amount>1000</amount>
<amountAr> آلف   درهم إماراتى</amountAr>
</return>
<return><amount>5000</amount>
<amountAr>خمسة الآف   درهم إماراتى</amountAr>
</return>
<return><amount>9000</amount>
<amountAr>تسعة الآف   درهم إماراتى</amountAr>
</return>
<return><amount>12000</amount>
<amountAr>إثناعشر آلف   درهم إماراتى</amountAr>
</return>
</getAmt>
<DATA_DS>
<G_PAYMENT_VOUCHER>
<ORG_ID>3000</ORG_ID><INVOICE_NUM>Invoice #1</INVOICE_NUM><PAYMENT_CURRENCY_CODE>AED</PAYMENT_CURRENCY_CODE><INVOICE_AMOUNT>1000</INVOICE_AMOUNT>
</G_PAYMENT_VOUCHER>
<G_PAYMENT_VOUCHER>
<ORG_ID>3000</ORG_ID><INVOICE_NUM>Invoice #2</INVOICE_NUM><PAYMENT_CURRENCY_CODE>AED</PAYMENT_CURRENCY_CODE><INVOICE_AMOUNT>5000</INVOICE_AMOUNT>
<G_PAYMENT_VOUCHER>
<G_PAYMENT_VOUCHER>
<ORG_ID>3000</ORG_ID><INVOICE_NUM>Invoice #3</INVOICE_NUM><PAYMENT_CURRENCY_CODE>AED</PAYMENT_CURRENCY_CODE><INVOICE_AMOUNT>9000</INVOICE_AMOUNT>
</G_PAYMENT_VOUCHER>
<G_PAYMENT_VOUCHER>
<ORG_ID>3000</ORG_ID><INVOICE_NUM>Invoice #4</INVOICE_NUM><PAYMENT_CURRENCY_CODE>AED</PAYMENT_CURRENCY_CODE><INVOICE_AMOUNT>12000</INVOICE_AMOUNT>
</G_PAYMENT_VOUCHER>
</DATA_DS>
</DATA_DS>


RTF template


<?xdoxslt:set_variable($_XDOCTX, ‘inv_amt2’, 0)?>

BU_NAME
INVOICE_NUM
Arabic
INVOICE_AMOUNT
F1 ORG_ID
<?xdoxslt:set_variable($_XDOCTX, 'inv_amt2', INVOICE_AMOUNT)?>
INVOICE_NUM
F <?if@inlines:number(amount)=xdoxslt:get_variable($_XDOCTX,‘inv_amt’)?><?amountAr?><?end if?> E  
INVOICE_AMOUNT  E1



F1 <?for-each:G_PAYMENT_VOUCHER?>
F2 <?for-each://getAmt/return?>
E1 <?end for-each?>
E2 <?end for-each?>

if@inlines is used to suppress spaces or line breaks created by for-each loop

1 comment:

  1. Oracle Apps R12 and Fusion Cloud Self Paced Training Videos Published on Udemy with Live Meeting Support. Please Check https://www.oracleappstechnical.com

    ReplyDelete