<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: Blitz Report Column Translation Upload -->
 <REPORTS_ROW>
  <GUID>3C7A91E8D4B2470FA6E15C83B90D2F44</GUID><ENABLED>Y</ENABLED>
  <SQL_TEXT>select
null action_,
null status_,
null message_,
null modified_columns_,
xrc.column_name,
xrc.number_format,
flv.description language,
xrct.translation,
xxen_util.user_name(xrct.created_by) created_by,
xxen_util.client_time(xrct.creation_date) creation_date,
xxen_util.user_name(xrct.last_updated_by) last_updated_by,
xxen_util.client_time(xrct.last_update_date) last_update_date,
null delete_,
null upload_row
from
fnd_languages_vl flv,
xxen_report_columns xrc,
(select xrct.* from xxen_report_columns_tl xrct where :p_upload_mode&lt;&gt;xxen_upload.action_create) xrct
where
1=1 and
flv.language_code=:language_code and
nvl(:p_create_empty_file,&apos;x&apos;)&lt;&gt;&apos;Y&apos; and
xrc.column_id=xrct.column_id(+) and
flv.language_code=xrct.language(+)</SQL_TEXT>
  <VERSION_COMMENTS>Initial version of the Blitz Report Column Translation Upload.</VERSION_COMMENTS>
  <TYPE>U</TYPE>
  <UPLOAD_TYPE>A</UPLOAD_TYPE>
  <UPLOAD_OBJECT>xxen_report_upload.create_update_col_translation</UPLOAD_OBJECT>
  <REPORT_TRANSLATIONS>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>US</LANGUAGE>
    <REPORT_NAME>Blitz Report Column Translation Upload</REPORT_NAME>
    <DESCRIPTION>Upload to maintain the Blitz Report column translations and number formats, which control how a report column heading is displayed in each language and how its values are formatted in Excel.

Translations are matched to reports by column name at run time, so one row here applies to every report producing a column of that name. A Column Name is stored in lower case with underscores in place of blanks, the form in which report columns are matched, so Invoice Amount maintains the translations of invoice_amount.

The Language parameter is required, because a single language already covers around twenty thousand column names.

Run modes:

- Create, Update: downloads the existing translations of the chosen language for editing. Set Delete to Yes to remove a translation.

- Create with &apos;Missing Translations Only&apos; = Yes: downloads only the column names that have no translation yet in the chosen language, ready to be filled in.

- Create with &apos;Create Empty File&apos; = Yes: opens an empty file to enter new column names.

The Number Format is an Excel format mask held once per column name, not per language. It repeats on every language row of the same column and is only written when it differs from the stored value, so editing it on any one row is enough.</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
  </REPORT_TRANSLATIONS>
  <CATEGORY_ASSIGNMENTS>
   <CATEGORY_ASSIGNMENTS_ROW>
    <CATEGORY>Enginatics</CATEGORY>
   </CATEGORY_ASSIGNMENTS_ROW>
   <CATEGORY_ASSIGNMENTS_ROW>
    <CATEGORY>Upload</CATEGORY>
   </CATEGORY_ASSIGNMENTS_ROW>
  </CATEGORY_ASSIGNMENTS>
  <ANCHORS>
   <ANCHORS_ROW>
    <ANCHOR>1=1</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:language_code</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_create_empty_file</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_upload_mode</ANCHOR>
   </ANCHORS_ROW>
  </ANCHORS>
  <PARAMETERS>
   <PARAMETERS_ROW>
    <SORT_ORDER>1</SORT_ORDER>
    <DISPLAY_SEQUENCE>10</DISPLAY_SEQUENCE>
    <ANCHOR>:p_upload_mode</ANCHOR>
    <PARAMETER_TYPE_DSP>LOV</PARAMETER_TYPE_DSP>
    <LOV_NAME>Blitz Upload Mode</LOV_NAME>
    <LOV_GUID>E811F942597A2075E0530100007FF4F2</LOV_GUID>
    <LOV_QUERY_DSP>select xxen_upload.action_create id, xxen_upload.action_meaning(xxen_upload.action_create) value, null description from dual union all
select xxen_upload.action_create||&apos;,&apos;||xxen_upload.action_update id, xxen_upload.action_meaning(xxen_upload.action_create)||&apos;, &apos;||xxen_upload.action_meaning(xxen_upload.action_update) value, null description from dual</LOV_QUERY_DSP>
    <DEFAULT_VALUE>C,U</DEFAULT_VALUE>
    <REQUIRED>Y</REQUIRED>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Upload Mode</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>2</SORT_ORDER>
    <DISPLAY_SEQUENCE>20</DISPLAY_SEQUENCE>
    <ANCHOR>:language_code</ANCHOR>
    <PARAMETER_TYPE_DSP>LOV</PARAMETER_TYPE_DSP>
    <LOV_NAME>FND Language</LOV_NAME>
    <LOV_GUID>A799FAF8BE9D469190B426B9A19EE06C</LOV_GUID>
    <LOV_QUERY_DSP>select
flv.language_code id,
flv.description value,
decode(flv.installed_flag,&apos;B&apos;,&apos;Base language&apos;,&apos;I&apos;,&apos;Installed&apos;) description
from
fnd_languages_vl flv
order by
decode(flv.installed_flag,&apos;B&apos;,1,&apos;I&apos;,2,3),
flv.description</LOV_QUERY_DSP>
    <DEFAULT_VALUE>select flv.description from fnd_languages_vl flv where flv.language_code=userenv(&apos;lang&apos;)</DEFAULT_VALUE>
    <REQUIRED>Y</REQUIRED>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Language</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>3</SORT_ORDER>
    <DISPLAY_SEQUENCE>30</DISPLAY_SEQUENCE>
    <ANCHOR>:p_create_empty_file</ANCHOR>
    <PARAMETER_TYPE_DSP>LOV</PARAMETER_TYPE_DSP>
    <LOV_NAME>Copy Existing Budget</LOV_NAME>
    <LOV_GUID>15B2E2DBB743E8CCE0630100007F9602</LOV_GUID>
    <LOV_QUERY_DSP>select 
&apos;Y&apos; id,
xxen_util.meaning(&apos;Y&apos;,&apos;YES_NO&apos;,0) value, 
null description 
from 
dual
where 
:$flex$.upload_mode = xxen_upload.action_create</LOV_QUERY_DSP>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Create Empty File</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>4</SORT_ORDER>
    <DISPLAY_SEQUENCE>40</DISPLAY_SEQUENCE>
    <ANCHOR>1=1</ANCHOR>
    <SQL_TEXT>xrc.column_id not in (select xrct2.column_id from xxen_report_columns_tl xrct2 where xrct2.language=:language_code and xrct2.translation is not null)</SQL_TEXT>
    <PARAMETER_TYPE_DSP>LOV</PARAMETER_TYPE_DSP>
    <LOV_NAME>Yes</LOV_NAME>
    <LOV_GUID>8E2FF36EDEA679D2E0530100007F1FF2</LOV_GUID>
    <LOV_QUERY_DSP>select &apos;Y&apos; id, xxen_util.meaning(&apos;Y&apos;,&apos;YES_NO&apos;,0) value, null description from dual</LOV_QUERY_DSP>
    <MATCHING_VALUE>Y</MATCHING_VALUE>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Missing Translations Only</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>5</SORT_ORDER>
    <DISPLAY_SEQUENCE>50</DISPLAY_SEQUENCE>
    <ANCHOR>1=1</ANCHOR>
    <SQL_TEXT>xrc.column_name like :column_name_starts_with||&apos;%&apos;</SQL_TEXT>
    <PARAMETER_TYPE_DSP>LOV custom</PARAMETER_TYPE_DSP>
    <FREE_TEXT>Y</FREE_TEXT>
    <LOV_QUERY_DSP>select
xrc.column_name value,
xrc.number_format description
from
xxen_report_columns xrc
order by
xrc.column_name</LOV_QUERY_DSP>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Column Name starts with</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
  </PARAMETERS>
  <TEMPLATES>
   <TEMPLATES_ROW>
    <GUID>6E181491CBB64CA8BD0344AC6C8CED85</GUID>
    <TEMPLATE_NAME>Default</TEMPLATE_NAME>
    <DESCRIPTION>All columns.</DESCRIPTION>
    <OWNER>ENGINATICS</OWNER>
    <TEMPLATE_COLUMNS>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>1</DISPLAY_SEQUENCE>
      <COLUMN_NAME>COLUMN_NAME</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>5</DISPLAY_SEQUENCE>
      <COLUMN_NAME>CREATED_BY</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>6</DISPLAY_SEQUENCE>
      <COLUMN_NAME>CREATION_DATE</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>9</DISPLAY_SEQUENCE>
      <COLUMN_NAME>DELETE_</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>3</DISPLAY_SEQUENCE>
      <COLUMN_NAME>LANGUAGE</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>7</DISPLAY_SEQUENCE>
      <COLUMN_NAME>LAST_UPDATED_BY</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>8</DISPLAY_SEQUENCE>
      <COLUMN_NAME>LAST_UPDATE_DATE</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>2</DISPLAY_SEQUENCE>
      <COLUMN_NAME>NUMBER_FORMAT</COLUMN_NAME>
      <FREEZE_PANES>Y</FREEZE_PANES>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>4</DISPLAY_SEQUENCE>
      <COLUMN_NAME>TRANSLATION</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
    </TEMPLATE_COLUMNS>
    <TEMPLATE_PIVOT>
    </TEMPLATE_PIVOT>
    <TEMPLATE_SHARED_STRINGS>
    </TEMPLATE_SHARED_STRINGS>
    <TEMPLATE_PARAMETER_DEFAULTS>
    </TEMPLATE_PARAMETER_DEFAULTS>
    <TEMPLATE_STYLES>
    </TEMPLATE_STYLES>
    <TEMPLATE_SHARING>
     <TEMPLATE_SHARING_ROW>
      <SHARING_LEVEL>S</SHARING_LEVEL>
      <LEVEL_VALUE>Site</LEVEL_VALUE>
     </TEMPLATE_SHARING_ROW>
    </TEMPLATE_SHARING>
    <PARAMETER_EXCLUSION>
    </PARAMETER_EXCLUSION>
    <TEMPLATE_CONDITIONS>
    </TEMPLATE_CONDITIONS>
   </TEMPLATES_ROW>
  </TEMPLATES>
  <DEFAULT_TEMPLATES>
   <DEFAULT_TEMPLATES_ROW>
    <TEMPLATE_GUID>6E181491CBB64CA8BD0344AC6C8CED85</TEMPLATE_GUID>
   </DEFAULT_TEMPLATES_ROW>
  </DEFAULT_TEMPLATES>
  <UPLOAD_COLUMNS>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>1</COLUMN_NUMBER>
    <COLUMN_NAME>ACTION_</COLUMN_NAME>
    <COLUMN_TYPE_DSP>Char</COLUMN_TYPE_DSP>
    <DATA_TYPE>varchar2</DATA_TYPE>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>2</COLUMN_NUMBER>
    <COLUMN_NAME>STATUS_</COLUMN_NAME>
    <COLUMN_TYPE_DSP>Char</COLUMN_TYPE_DSP>
    <DATA_TYPE>varchar2</DATA_TYPE>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>3</COLUMN_NUMBER>
    <COLUMN_NAME>MESSAGE_</COLUMN_NAME>
    <COLUMN_TYPE_DSP>Char</COLUMN_TYPE_DSP>
    <DATA_TYPE>varchar2</DATA_TYPE>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>4</COLUMN_NUMBER>
    <COLUMN_NAME>MODIFIED_COLUMNS_</COLUMN_NAME>
    <COLUMN_TYPE_DSP>Char</COLUMN_TYPE_DSP>
    <DATA_TYPE>varchar2</DATA_TYPE>
    <HIDDEN>Y</HIDDEN>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>5</COLUMN_NUMBER>
    <COLUMN_NAME>COLUMN_NAME</COLUMN_NAME>
    <COLUMN_TYPE_DSP>LOV custom</COLUMN_TYPE_DSP>
    <DATA_TYPE>varchar2</DATA_TYPE>
    <DATA_LENGTH>251</DATA_LENGTH>
    <FREE_TEXT>Y</FREE_TEXT>
    <LOV_QUERY_DSP>select
xrc.column_name value,
xrc.number_format description
from
xxen_report_columns xrc
order by
xrc.column_name</LOV_QUERY_DSP>
    <REQUIRED>Y</REQUIRED>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>6</COLUMN_NUMBER>
    <COLUMN_NAME>NUMBER_FORMAT</COLUMN_NAME>
    <COLUMN_TYPE_DSP>Char</COLUMN_TYPE_DSP>
    <DATA_TYPE>varchar2</DATA_TYPE>
    <DATA_LENGTH>80</DATA_LENGTH>
    <DEFAULT_VALUE>select xrc.number_format from xxen_report_columns xrc where xrc.column_name=lower(trim(&apos;_&apos; from translate(:$column$.column_name,&apos; &apos;,&apos;_&apos;)))</DEFAULT_VALUE>
    <COMMENTS>select &apos;Excel number format mask for this column, for example #,##0.00 or dd-mon-yyyy. Held once per column name and shared by all languages.&apos; from dual</COMMENTS>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>7</COLUMN_NUMBER>
    <COLUMN_NAME>LANGUAGE</COLUMN_NAME>
    <COLUMN_TYPE_DSP>LOV</COLUMN_TYPE_DSP>
    <DATA_TYPE>varchar2</DATA_TYPE>
    <DATA_LENGTH>80</DATA_LENGTH>
    <LOV_NAME>FND Language</LOV_NAME>
    <LOV_GUID>A799FAF8BE9D469190B426B9A19EE06C</LOV_GUID>
    <LOV_QUERY_DSP>select
flv.language_code id,
flv.description value,
decode(flv.installed_flag,&apos;B&apos;,&apos;Base language&apos;,&apos;I&apos;,&apos;Installed&apos;) description
from
fnd_languages_vl flv
order by
decode(flv.installed_flag,&apos;B&apos;,1,&apos;I&apos;,2,3),
flv.description</LOV_QUERY_DSP>
    <DEFAULT_VALUE>select flv.description from fnd_languages_vl flv where flv.language_code=:$flex$.Language</DEFAULT_VALUE>
    <REQUIRED>Y</REQUIRED>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>8</COLUMN_NUMBER>
    <COLUMN_NAME>TRANSLATION</COLUMN_NAME>
    <COLUMN_TYPE_DSP>Char</COLUMN_TYPE_DSP>
    <DATA_TYPE>varchar2</DATA_TYPE>
    <DATA_LENGTH>753</DATA_LENGTH>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>9</COLUMN_NUMBER>
    <COLUMN_NAME>CREATED_BY</COLUMN_NAME>
    <COLUMN_TYPE_DSP>Char</COLUMN_TYPE_DSP>
    <DATA_TYPE>varchar2</DATA_TYPE>
    <READ_ONLY>Y</READ_ONLY>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>10</COLUMN_NUMBER>
    <COLUMN_NAME>CREATION_DATE</COLUMN_NAME>
    <COLUMN_TYPE_DSP>Date</COLUMN_TYPE_DSP>
    <DATA_TYPE>date</DATA_TYPE>
    <READ_ONLY>Y</READ_ONLY>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>11</COLUMN_NUMBER>
    <COLUMN_NAME>LAST_UPDATED_BY</COLUMN_NAME>
    <COLUMN_TYPE_DSP>Char</COLUMN_TYPE_DSP>
    <DATA_TYPE>varchar2</DATA_TYPE>
    <READ_ONLY>Y</READ_ONLY>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>12</COLUMN_NUMBER>
    <COLUMN_NAME>LAST_UPDATE_DATE</COLUMN_NAME>
    <COLUMN_TYPE_DSP>Date</COLUMN_TYPE_DSP>
    <DATA_TYPE>date</DATA_TYPE>
    <READ_ONLY>Y</READ_ONLY>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>13</COLUMN_NUMBER>
    <COLUMN_NAME>DELETE_</COLUMN_NAME>
    <COLUMN_TYPE_DSP>LOV</COLUMN_TYPE_DSP>
    <DATA_TYPE>varchar2</DATA_TYPE>
    <LOV_NAME>Yes</LOV_NAME>
    <LOV_GUID>8E2FF36EDEA679D2E0530100007F1FF2</LOV_GUID>
    <LOV_QUERY_DSP>select &apos;Y&apos; id, xxen_util.meaning(&apos;Y&apos;,&apos;YES_NO&apos;,0) value, null description from dual</LOV_QUERY_DSP>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>14</COLUMN_NUMBER>
    <COLUMN_NAME>UPLOAD_ROW</COLUMN_NAME>
    <COLUMN_TYPE_DSP>Char</COLUMN_TYPE_DSP>
    <DATA_TYPE>varchar2</DATA_TYPE>
    <HIDDEN>Y</HIDDEN>
   </UPLOAD_COLUMNS_ROW>
  </UPLOAD_COLUMNS>
  <UPLOAD_PARAMETERS>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>1</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>status_</PARAMETER_NAME>
    <IN_OUT>out</IN_OUT>
    <PARAMETER_TYPE>Char</PARAMETER_TYPE>
    <COLUMN_NAME>STATUS_CODE_</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>2</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>message_</PARAMETER_NAME>
    <IN_OUT>out</IN_OUT>
    <PARAMETER_TYPE>Char</PARAMETER_TYPE>
    <COLUMN_NAME>MESSAGE_</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>3</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_column_name</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Char</PARAMETER_TYPE>
    <COLUMN_NAME>COLUMN_NAME</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>4</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_number_format</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Char</PARAMETER_TYPE>
    <COLUMN_NAME>NUMBER_FORMAT</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>5</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_language_code</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Char</PARAMETER_TYPE>
    <COLUMN_NAME>LANGUAGE</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>6</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_translation</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Char</PARAMETER_TYPE>
    <COLUMN_NAME>TRANSLATION</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>7</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_delete</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Char</PARAMETER_TYPE>
    <COLUMN_NAME>DELETE_</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
  </UPLOAD_PARAMETERS>
  <UPLOAD_SQLS>
   <UPLOAD_SQLS_ROW>
    <SQL_TYPE>Error SQL</SQL_TYPE>
   </UPLOAD_SQLS_ROW>
   <UPLOAD_SQLS_ROW>
    <SQL_TYPE>Order By</SQL_TYPE>
    <SQL_TEXT>upload_row,
column_name,
language</SQL_TEXT>
   </UPLOAD_SQLS_ROW>
   <UPLOAD_SQLS_ROW>
    <SQL_TYPE>Success SQL</SQL_TYPE>
    <SQL_TEXT>select
xu.action_,
xu.status_,
xu.message_,
xu.modified_columns_,
nvl(xrc.column_name,xu.column_name) column_name,
nvl(xrc.number_format,xu.number_format) number_format,
nvl(flv.description,xu.language) language,
nvl(xrct.translation,xu.translation) translation,
xxen_util.user_name(xrct.created_by) created_by,
xxen_util.client_time(xrct.creation_date) creation_date,
xxen_util.user_name(xrct.last_updated_by) last_updated_by,
xxen_util.client_time(xrct.last_update_date) last_update_date,
xu.delete_,
xu.upload_row
from
xxen_blitz_report_colum_9216_u xu,
fnd_languages_vl flv,
xxen_report_columns xrc,
xxen_report_columns_tl xrct
where
xu.status_code_=xxen_upload.status_success and
xu.language=flv.description(+) and
lower(trim(&apos;_&apos; from translate(xu.column_name,&apos; &apos;,&apos;_&apos;)))=xrc.column_name(+) and
xrc.column_id=xrct.column_id(+) and
flv.language_code=xrct.language(+)</SQL_TEXT>
   </UPLOAD_SQLS_ROW>
  </UPLOAD_SQLS>
 </REPORTS_ROW>
</REPORTS>
</ROOT>
