<data name="IBaccountBalanceDetailType" serviceNamespace="http://www.lolc.com/IBaccountBalanceDetailType" transports="http https local">
   <config id="oracleIB1">
      <property name="driverClassName">oracle.jdbc.driver.OracleDriver</property>
      <property name="url">jdbc:oracle:thin:@(description=(address_list=(load_balance=off)(failover=on)(address=(protocol=tcp)(host=xxx.xxx.xxx.xxx)(port=xxxx))(address=(protocol=tcp)(host=xxx.xxx.xxx.xxx)(port=xxxx)))(connect_data=(service_name=xxxxx)(failover_mode=(type=select)(method=basic))))</property>
      <property name="username">xxxxxx</property>
      <property name="password">xxxxxx</property>
   </config>
   <query id="functionQuery" useConfig="oracleIB1">
      <sql>{call ?:=PKG_CYBER_IB_PROXY_SAVI_ACCDTL.sent_ib_acc_balinq_detail_typ(:p_acc_no,:p_acc_type,:req_type_id,:token_id,:rep_chnl)}</sql>
      <result defaultNamespace="http://lolc.com/details" element="details" rowName="detail">
         <element column="returnParameter[0]" name="account_number" xsdType="string"/>
         <element column="returnParameter[1]" name="account_type" xsdType="string"/>
         <element column="returnParameter[2]" name="amount" xsdType="integer"/>
         <element column="returnParameter[3]" name="available_balance" xsdType="integer"/>
         <element column="returnParameter[4]" name="currency_code" xsdType="string"/>
         <element column="returnParameter[5]" name="account_status" xsdType="string"/>
         <element column="returnParameter[6]" name="cif_no" xsdType="integer"/>
         <element column="returnParameter[7]" name="start_date" xsdType="date"/>
         <element column="returnParameter[8]" name="end_date" xsdType="date"/>
         <element column="returnParameter[9]" name="due_day" xsdType="string"/>
         <element column="returnParameter[10]" name="int_rate" xsdType="string"/>
         <element column="returnParameter[11]" name="invester_ratio" xsdType="string"/>
         <element column="returnParameter[12]" name="company_ratio" xsdType="string"/>
         <element column="returnParameter[13]" name="profit_ratio" xsdType="string"/>
         <element column="returnParameter[14]" name="no_of_month" xsdType="string"/>
         <element column="returnParameter[15]" name="pay_mode" xsdType="string"/>
         <element column="returnParameter[16]" name="original_fd_no" xsdType="string"/>
         <element column="returnParameter[17]" name="renewal_indicater" xsdType="string"/>
         <element column="returnParameter[18]" name="monthly_rental" xsdType="integer"/>
         <element column="returnParameter[19]" name="rentals_in_arrears_amount" xsdType="integer"/>
         <element column="returnParameter[20]" name="current_due" xsdType="integer"/>
         <element column="returnParameter[21]" name="future_resiables" xsdType="integer"/>
         <element column="returnParameter[22]" name="vehicle_number" xsdType="string"/>
         <element column="returnParameter[23]" name="location_address" xsdType="string"/>
         <element column="returnParameter[24]" name="policy_period" xsdType="string"/>
      </result>
      <param name="returnParameter" ordinal="1" paramType="ARRAY" sqlType="STRUCT" structType="dbt_ib_acc_balinq_detail" type="OUT"/>
      <param name="p_acc_no" sqlType="STRING"/>
      <param name="p_acc_type" sqlType="STRING"/>
      <param name="req_type_id" sqlType="STRING"/>
      <param name="token_id" sqlType="STRING"/>
      <param name="rep_chnl" sqlType="STRING"/>
   </query>
   <operation name="getAccountBalanceDetailType">
      <call-query href="functionQuery">
         <with-param name="p_acc_no" query-param="p_acc_no"/>
         <with-param name="p_acc_type" query-param="p_acc_type"/>
         <with-param name="req_type_id" query-param="req_type_id"/>
         <with-param name="token_id" query-param="token_id"/>
         <with-param name="rep_chnl" query-param="rep_chnl"/>
      </call-query>
   </operation>
</data>
