Xml Publisher Part 2

How to use SQL Functions in .rtf File :
---------------------------------------------

Ex : <?sum(AMOUNT)?>
Ex : <?count(INVOICE_NUM)?>

To Change Field Properties :
----------------------------------
Ex : Number Formatting


How to Split the Pages in .rtf file :
----------------------------------------
-> By Using <?split-by-page-break:?>


How to Print Logos or Images in .rtf :
---------------------------------------------

if we have multiple images
by using <call-template>

Define Template :
---------------------
<?template:A?>
Image1
<?end template:A?>

<?template:B?>
Image2
<?end template:B?>

<?template:C?>
Image3
<?end template:C?>

Call Template :
-----------------
 <?call-template:A?>


Format Triggers in .rtf :
----------------------------
-- Formatting the attributes of Objects.
Ex : No Data Found
-- By Using If Conditions

Syntax :
---------
<?if:col_name = 0?> Print Layout <?end if?>


How to Display the Parameter Values in .rtf :
----------------------------------------------------
in .rdf,
Formula Column

Ex : 1
-------
function CF_P_ORG_VALFormula return Number is
begin
  RETURN :P_ORG_ID;
end;

Ex : 2
-------
function CF_INVOICE_NUM_VALFormula return Char is
begin
  RETURN :P_INVOICE_NUM;
end;



XML Publisher Report with out using .rdf :
------------------------------------------------
-- by Using PLSQL Method

.xml data file format :
-------------------------
<Report Name>
<XXAP_INV_MASTER_DETAILS>
  for loop
      <G_OU_NAME>

                    <OU_NAME>Vision Operations</OU_NAME>
     <INVOICE_NUM>3m_inv1</INVOICE_NUM>

       </G_OU_NAME>
  end for loop;
-- Report Level Columns
</XXAP_INV_MASTER_DETAILS>


SELECT    HOU.NAME OU_NAME,
    AIA.INVOICE_NUM,
    AIA.INVOICE_TYPE_LOOKUP_CODE,
    APS.VENDOR_NAME,
    ASSA.VENDOR_SITE_CODE,
    AIA.INVOICE_AMOUNT,
    AILA.LINE_NUMBER,
    AILA.LINE_TYPE_LOOKUP_CODE,
    (SELECT NAME FROM HR_OPERATING_UNITS
     WHERE ORGANIZATION_ID = AILA.ORG_ID) LINE_OU_NAME,
    AILA.AMOUNT,
    GCC.CONCATENATED_SEGMENTS DIST_ACCOUNT
FROM    HR_OPERATING_UNITS HOU,
    AP_INVOICES_ALL AIA,
    AP_SUPPLIERS APS,
    AP_SUPPLIER_SITES_ALL ASSA,
    AP_INVOICE_LINES_ALL AILA,
    AP_INVOICE_DISTRIBUTIONS_ALL AIDA,
    GL_CODE_COMBINATIONS_KFV GCC
WHERE    1=1
AND    HOU.ORGANIZATION_ID = AIA.ORG_ID
AND    AIA.VENDOR_ID = APS.VENDOR_ID
AND    APS.VENDOR_ID = ASSA.VENDOR_ID
AND    ASSA.VENDOR_SITE_ID = AIA.VENDOR_SITE_ID
AND    ASSA.ORG_ID = HOU.ORGANIZATION_ID
AND     AIA.INVOICE_ID = AILA.INVOICE_ID
AND     AILA.LINE_NUMBER = AIDA.INVOICE_LINE_NUMBER
AND     AIDA.INVOICE_ID = AIA.INVOICE_ID
AND     AIDA.DIST_CODE_COMBINATION_ID = GCC.CODE_COMBINATION_ID
AND    ORGANIZATION_ID = :P_ORG_ID
AND    AIA.VENDOR_ID = NVL(:P_VENDOR_ID, AIA.VENDOR_ID)
AND    AIA.VENDOR_SITE_ID = NVL(:P_VENDOR_SITE_ID,AIA.VENDOR_SITE_ID)
AND    AIA.INVOICE_NUM = NVL(:P_INVOICE_NUM,AIA.INVOICE_NUM);