Data Definition Template -- How to pass in Parameters
Hi Gurus,I have created one xml template in place of rdf.
---------------------------------------------------------------------------------------------------------------------------------------
<?xml version = "1.0" encoding = "UTF-8" ?>
<dataTemplate name="EQXCUST111" defaultPackage="EQXCUST_XMLP_PKG" version="1.0">
<properties>
<property name="xml_tag_case" value="upper"/>
</properties>
<parameters>
<parameter name="P_CONC_REQUEST_ID" dataType = "number" defaultValue="0"/>
<parameter name="P_COLLECTOR" dataType="character"/>
<parameter name="P_STATEMENT_NUMBER" dataType="number"/>
<parameter name="P_FROM_CUSTOMER" dataType="character"/>
<parameter name="P_TO_CUSTOMER" dataType="character"/>
</parameters>
<lexicals/>
<dataQuery>
<sqlStatement name="Q_MAIN">
<![CDATA[
SELECT STATEMENT_NUMBER,
to_char(STATEMENT_DATE,'MM/DD/YYYY') STATEMENT_DATE ,
PAYMENT_TERMS,
CUSTOMER,
CUSTOMER_ACCOUNT,
CUSTOMER_ADDRESS_1,
CUSTOMER_ADDRESS_2,
---------------------------------------------------------------------------------------------------------------------------------------
<?xml version = "1.0" encoding = "UTF-8" ?>
<dataTemplate name="EQXCUST111" defaultPackage="EQXCUST_XMLP_PKG" version="1.0">
<properties>
<property name="xml_tag_case" value="upper"/>
</properties>
<parameters>
<parameter name="P_CONC_REQUEST_ID" dataType = "number" defaultValue="0"/>
<parameter name="P_COLLECTOR" dataType="character"/>
<parameter name="P_STATEMENT_NUMBER" dataType="number"/>
<parameter name="P_FROM_CUSTOMER" dataType="character"/>
<parameter name="P_TO_CUSTOMER" dataType="character"/>
</parameters>
<lexicals/>
<dataQuery>
<sqlStatement name="Q_MAIN">
<![CDATA[
SELECT STATEMENT_NUMBER,
to_char(STATEMENT_DATE,'MM/DD/YYYY') STATEMENT_DATE ,
PAYMENT_TERMS,
CUSTOMER,
CUSTOMER_ACCOUNT,
CUSTOMER_ADDRESS_1,
CUSTOMER_ADDRESS_2,
0