<ROOT>
 <APPS_INITIALIZE_DATA>
  <USER_NAME>ENGINATICS</USER_NAME>
  <RESPONSIBILITY_KEY>SYSTEM_ADMINISTRATOR</RESPONSIBILITY_KEY>
  <APPLICATION_SHORT_NAME>SYSADMIN</APPLICATION_SHORT_NAME>
 </APPS_INITIALIZE_DATA>
<REPORTS>
<!-- loader xml for Enginatics Blitz Report: XTR Program - Update Settlement Bank Account Execution -->
 <REPORTS_ROW>
  <GUID>82288223F57C3869E053B46B63588994</GUID><ENABLED>Y</ENABLED>
  <SQL_TEXT>select cfur.amount_date, xat.amount_name, cfur.cashflow_amount, xdt.user_deal_type, cfur.deal_number, cfur.transaction_number, cfur.message_name, 
decode(cfur.updated_flag, &apos;N&apos;, nvl(:P_MESSAGE_CODE_FOR_ERROR,rpad(&apos; &apos;,4000,&apos; &apos;)), nvl(:P_MESSAGE_CODE_FOR_UPDATE,rpad(&apos; &apos;,4000,&apos; &apos;))) upd_rec
from xtr_cflow_updated_records cfur, xtr_deal_types xdt, xtr_amount_types xat
where cfur.cashflow_request_details_id = :P_CFLOW_REQUEST_DETAILS_ID
and xdt.deal_type = cfur.deal_type
and xat.amount_type = cfur.amount_type
and xat.deal_type = cfur.deal_type
and :P_NO_RECORDS_UPDATED = &apos;N&apos;
ORDER BY 8 desc
</SQL_TEXT>
  <XDO_APPLICATION_SHORT_NAME>XTR</XDO_APPLICATION_SHORT_NAME>
  <XDO_DATA_SOURCE_CODE>XTRUPREP_XML</XDO_DATA_SOURCE_CODE>
  <REPORT_TRANSLATIONS>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>AR</LANGUAGE>
    <REPORT_NAME>XTR البرنامج - تقرير تحديث تنفيذ حساب بنك التسوية (بتنسيق XML)</REPORT_NAME>
    <DESCRIPTION>Application: الخزانة
Source: البرنامج - تقرير تحديث تنفيذ حساب بنك التسوية (بتنسيق XML)
Short Name: XTRUPREP_XML
DB package: XTR_XTRUPREP_XMLP_PKG</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>D</LANGUAGE>
    <REPORT_NAME>XTR Programm - Abrechnungsbankkonto aktualisieren - Ergebnisse</REPORT_NAME>
    <DESCRIPTION>Application: Treasury
Source: Programm - Abrechnungsbankkonto aktualisieren - Ergebnisse (XML)
Short Name: XTRUPREP_XML
DB package: XTR_XTRUPREP_XMLP_PKG</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>F</LANGUAGE>
    <REPORT_NAME>XTR Programme - Compte rendu d&apos;exécution de la mise à jour du compte bancaire de liquidation</REPORT_NAME>
    <DESCRIPTION>Application: Treasury
Source: Programme - Compte rendu d&apos;exécution de la mise à jour du compte bancaire de liquidation (XML)
Short Name: XTRUPREP_XML
DB package: XTR_XTRUPREP_XMLP_PKG</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>US</LANGUAGE>
    <REPORT_NAME>XTR Program - Update Settlement Bank Account Execution</REPORT_NAME>
    <DESCRIPTION>Application: Treasury
Source: Program - Update Settlement Bank Account Execution Report (XML)
Short Name: XTRUPREP_XML
DB package: XTR_XTRUPREP_XMLP_PKG</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>ZHS</LANGUAGE>
    <REPORT_NAME>XTR 程序 - 更新结算银行帐户执行报表</REPORT_NAME>
    <DESCRIPTION>Application: 理财管理系统
Source: 程序 - 更新结算银行帐户执行报表 (XML)
Short Name: XTRUPREP_XML
DB package: XTR_XTRUPREP_XMLP_PKG</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
  </REPORT_TRANSLATIONS>
  <CATEGORY_ASSIGNMENTS>
   <CATEGORY_ASSIGNMENTS_ROW>
    <CATEGORY>BI Publisher</CATEGORY>
   </CATEGORY_ASSIGNMENTS_ROW>
  </CATEGORY_ASSIGNMENTS>
  <ANCHORS>
   <ANCHORS_ROW>
    <ANCHOR>:p_cflow_request_details_id</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_conc_request_id</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_deal_type</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_ending_date</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_ending_deal_no</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_execution_date</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_include_journalized</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_message_code_for_error</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_message_code_for_update</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_message_text_for_no_records</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_new_account</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_no_records_updated</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_old_account</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_party_code</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_starting_date</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_starting_deal_no</ANCHOR>
   </ANCHORS_ROW>
  </ANCHORS>
  <PARAMETERS>
   <PARAMETERS_ROW>
    <SORT_ORDER>1</SORT_ORDER>
    <DISPLAY_SEQUENCE>10</DISPLAY_SEQUENCE>
    <ANCHOR>:p_cflow_request_details_id</ANCHOR>
    <PARAMETER_TYPE_DSP>LOV Oracle</PARAMETER_TYPE_DSP>
    <LOV_NAME>XTR_CFLOW_REQUESTS</LOV_NAME>
    <VALIDATE_FROM_LIST_DSP>Y</VALIDATE_FROM_LIST_DSP>
    <LOV_QUERY_DSP>select
xtrcf.cashflow_request_details_id id,
xtrcf.request_id value,
null description
from
xtr_cflow_request_details xtrcf
where xtrcf.request_id is not null order by request_id</LOV_QUERY_DSP>
    <REQUIRED>Y</REQUIRED>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>AR</LANGUAGE>
      <PARAMETER_NAME>رقم الطلب</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>D</LANGUAGE>
      <PARAMETER_NAME>Prozessnummer</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>F</LANGUAGE>
      <PARAMETER_NAME>Numéro de traitement</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Request Number</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>ZHS</LANGUAGE>
      <PARAMETER_NAME>请求编号</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
  </PARAMETERS>
  <TEMPLATES>
  </TEMPLATES>
  <DEFAULT_TEMPLATES>
  </DEFAULT_TEMPLATES>
  <UPLOAD_COLUMNS>
  </UPLOAD_COLUMNS>
  <UPLOAD_PARAMETERS>
  </UPLOAD_PARAMETERS>
  <UPLOAD_SQLS>
  </UPLOAD_SQLS>
 </REPORTS_ROW>
</REPORTS>
</ROOT>
