<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 Custom Reports Converter -->
 <REPORTS_ROW>
  <GUID>51E3BF0C73BA1799E0630100007FF20F</GUID><ENABLED>Y</ENABLED>
  <SQL_TEXT>select
case when :select_all_programs=&apos;Y&apos; then xxen_upload.action_meaning(xxen_upload.action_update) end action_,
case when :select_all_programs=&apos;Y&apos; then xxen_upload.status_meaning(xxen_upload.status_new) end status_,
case when :select_all_programs=&apos;Y&apos; then xxen_util.description(&apos;U_EXCEL_MSG_VALIDATION_PENDING&apos;,&apos;XXEN_REPORT_TRANSLATIONS&apos;,0) end message_,
cast(null as varchar2(240)) gather_status,
null modified_columns_,
xxen_util.yes(:select_all_programs) convert_program,
x.application,
x.program,
x.short_name,
x.program_type,
x.executable,
x.method,
x.execution_file_name,
x.output_format,
x.run_count,
x.distinct_users,
x.last_run_date,
x.first_run_date,
x.created_by,
x.creation_date,
x.concurrent_program_id,
x.application_id,
upper(:customer_abbreviation) customer_abbreviation,
upper(:custom_prefix) custom_prefix,
cast(null as number) request_id_,
rownum upload_row
from
(
select
fav.application_name application,
fcpv.user_concurrent_program_name program,
fcpv.concurrent_program_name short_name,
case
when fev.executable_name like &apos;XXE4A%&apos; then &apos;Excel4apps&apos;
when exists (select null from xdo_ds_definitions_b xddb where xddb.data_source_code=fcpv.concurrent_program_name and xddb.application_short_name=fav.application_short_name) then &apos;BI Publisher&apos;
when fev.execution_method_code=&apos;P&apos; then &apos;RDF&apos;
else &apos;Data Extract&apos;
end program_type,
fev.executable_name executable,
xxen_util.meaning(fev.execution_method_code,&apos;CP_EXECUTION_METHOD_CODE&apos;,0) method,
fev.execution_file_name,
xxen_util.meaning(fcpv.output_file_type,&apos;CP_OUTPUT_FILE_TYPE&apos;,0) output_format,
nvl(stats.run_count,0) run_count,
nvl(stats.distinct_users,0) distinct_users,
xxen_util.client_time(stats.last_run_date) last_run_date,
xxen_util.client_time(stats.first_run_date) first_run_date,
xxen_util.user_name(fcpv.created_by) created_by,
xxen_util.client_time(fcpv.creation_date) creation_date,
fcpv.concurrent_program_id,
fcpv.application_id
from
fnd_application_vl fav,
fnd_concurrent_programs_vl fcpv,
fnd_executables_vl fev,
(
select
fcr.concurrent_program_id,
fcr.program_application_id,
count(*) run_count,
count(distinct fcr.requested_by) distinct_users,
max(fcr.actual_start_date) last_run_date,
min(fcr.actual_start_date) first_run_date
from
fnd_concurrent_requests fcr
group by
fcr.concurrent_program_id,
fcr.program_application_id
) stats
where
3=3 and
fav.application_id=fcpv.application_id and
fcpv.executable_application_id=fev.application_id and
fcpv.executable_id=fev.executable_id and
fcpv.concurrent_program_id=stats.concurrent_program_id(+) and
fcpv.application_id=stats.program_application_id(+) and
nvl(fcpv.enabled_flag,&apos;Y&apos;)=&apos;Y&apos;
union all
select
dv.owner application,
dv.view_name program,
dv.view_name short_name,
&apos;Custom View&apos; program_type,
null executable,
&apos;View&apos; method,
null execution_file_name,
null output_format,
to_number(null) run_count,
to_number(null) distinct_users,
to_date(null) last_run_date,
to_date(null) first_run_date,
null created_by,
xxen_util.client_time(do.created) creation_date,
to_number(null) concurrent_program_id,
to_number(null) application_id
from
dba_views dv,
dba_objects do
where
2=2 and
:include_custom_views=&apos;Y&apos; and
dv.owner=do.owner and
dv.view_name=do.object_name and
do.object_type=&apos;VIEW&apos;
union all
select
&apos;Noetix&apos; application,
dv.view_name program,
dv.view_name short_name,
&apos;Noetix View&apos; program_type,
null executable,
&apos;View&apos; method,
null execution_file_name,
null output_format,
to_number(null) run_count,
to_number(null) distinct_users,
to_date(null) last_run_date,
to_date(null) first_run_date,
null created_by,
xxen_util.client_time(do.created) creation_date,
to_number(null) concurrent_program_id,
to_number(null) application_id
from
dba_views dv,
dba_objects do
where
:include_noetix_views=&apos;Y&apos; and
dv.owner=&apos;NOETIX_SYS&apos; and
dv.view_name not like &apos;XXK%&apos; and
dv.view_name not like &apos;%#&apos; and
dv.view_name not like &apos;%\_BASE&apos; escape &apos;\&apos; and
dv.view_name not like &apos;N\_%&apos; escape &apos;\&apos; and
dv.owner=do.owner and
dv.view_name=do.object_name and
do.object_type=&apos;VIEW&apos;
union all
select
fav.application_name application,
biv.user_name program,
biv.integrator_code short_name,
&apos;WebADI Integrator&apos; program_type,
interfaces.interface_name executable,
null method,
null execution_file_name,
null output_format,
to_number(null) run_count,
to_number(null) distinct_users,
to_date(null) last_run_date,
to_date(null) first_run_date,
xxen_util.user_name(biv.created_by) created_by,
xxen_util.client_time(biv.creation_date) creation_date,
to_number(null) concurrent_program_id,
biv.application_id
from
fnd_application_vl fav,
bne_integrators_vl biv,
(
select
bib.integrator_app_id,
bib.integrator_code,
listagg(bib.interface_name,&apos;, &apos;) within group (order by bib.upload_order,bib.interface_name) interface_name
from
bne_interfaces_b bib
group by
bib.integrator_app_id,
bib.integrator_code
) interfaces
where
4=4 and
:include_webadi_integrators=&apos;Y&apos; and
fav.application_id=biv.application_id and
biv.application_id=interfaces.integrator_app_id(+) and
biv.integrator_code=interfaces.integrator_code(+) and
biv.enabled_flag=&apos;Y&apos;
union all
select
fav.application_name application,
forms.user_form_name program,
forms.form_name short_name,
&apos;Forms Personalization&apos; program_type,
null executable,
null method,
null execution_file_name,
null output_format,
to_number(null) run_count,
to_number(null) distinct_users,
to_date(null) last_run_date,
to_date(null) first_run_date,
xxen_util.user_name(forms.created_by) created_by,
xxen_util.client_time(forms.creation_date) creation_date,
to_number(null) concurrent_program_id,
forms.application_id
from
fnd_application_vl fav,
(
select
ffv.form_name,
max(ffv.user_form_name) keep (dense_rank first order by ffv.form_id) user_form_name,
max(ffv.application_id) keep (dense_rank first order by ffv.form_id) application_id,
max(ffcr.created_by) keep (dense_rank first order by ffcr.creation_date) created_by,
min(ffcr.creation_date) creation_date
from
fnd_form_custom_rules ffcr,
fnd_form_vl ffv
where
ffcr.rule_key is null and
ffcr.form_name=ffv.form_name
group by
ffv.form_name
) forms
where
:include_forms_personalizations=&apos;Y&apos; and
forms.application_id=fav.application_id
) x
where
1=1</SQL_TEXT>
  <VERSION_COMMENTS>New parameter Include Forms Personalizations lists the forms that carry customer Forms Personalizations as program type Forms Personalization, so their personalization ldt and the custom objects it references are gathered.</VERSION_COMMENTS>
  <TYPE>U</TYPE>
  <UPLOAD_TYPE>A</UPLOAD_TYPE>
  <UPLOAD_OBJECT>xxen_report_converter.process_row</UPLOAD_OBJECT>
  <UPLOAD_POST_PROCEDURE>xxen_report_converter.submit_converter</UPLOAD_POST_PROCEDURE>
  <REPORT_TRANSLATIONS>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>US</LANGUAGE>
    <REPORT_NAME>Blitz Report Custom Reports Converter</REPORT_NAME>
    <DESCRIPTION>Lists Oracle EBS concurrent programs that are candidates for conversion to Blitz Report - RDF reports, BI Publisher reports, and other data-extract concurrent programs - with usage statistics. Select the programs to convert with the Convert Program column, then upload the file. The upload submits a host concurrent program that gathers each selected program&apos;s source artifacts (.rdf, .ldt, data definition, template, related packages and custom dependencies) into a single zip file for analysis by Enginatics.

With Select All Programs set to Yes, every listed row is downloaded with Convert Program set to Yes and already flagged for upload, so after filtering the list you only need to set Convert Program to No on the programs you do not want and upload the file.

With Include Custom Views set to Yes, the list additionally shows custom database views whose name starts with the Custom Object Prefix. Selecting a view gathers its definition and its custom dependency closure into the same zip - use this to extract the views that Discoverer-migrated or other custom reports are based on.

With Include Noetix Views set to Yes on an instance running NoetixViews, the NOETIX_SYS query views are listed as program type Noetix View. Selecting one gathers the complete view definition closure - the view, its NOETIX_SYS helper views and packages, and the security wrapper views - into a noetix subfolder of the zip, as input for migrating Noetix based reporting to Blitz Report. Excel4apps Reports Wand programs show as program type Excel4apps and gather their report SQL.

With Include WebADI Integrators set to Yes, the enabled WebADI integrators are listed as program type WebADI Integrator, with their interface tables or procedures as Executable. Selecting one gathers the complete integrator definition (interfaces, layouts, contents, mappings, importer, lists of values and security rules), its custom dependencies and the responsibilities that can use it, as input for converting the integrator to a Blitz Upload. Run counts and dates are not shown for integrators.

With Include Forms Personalizations set to Yes, every form that carries customer Forms Personalizations is listed as program type Forms Personalization. Selecting one gathers all its form and function level personalization rules as an FNDLOAD file (affrmcus.lct) and the custom objects they reference, for example to review the SQL of their conditions and actions for performance. Oracle-delivered personalizations (with a rule key) are not included.</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>2=2</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>3=3</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>4=4</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:custom_prefix</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:customer_abbreviation</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:include_custom_views</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:include_forms_personalizations</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:include_noetix_views</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:include_webadi_integrators</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:select_all_programs</ANCHOR>
   </ANCHORS_ROW>
  </ANCHORS>
  <PARAMETERS>
   <PARAMETERS_ROW>
    <SORT_ORDER>1</SORT_ORDER>
    <DISPLAY_SEQUENCE>10</DISPLAY_SEQUENCE>
    <ANCHOR>:customer_abbreviation</ANCHOR>
    <PARAMETER_TYPE_DSP>Char</PARAMETER_TYPE_DSP>
    <REQUIRED>Y</REQUIRED>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Customer Abbreviation</PARAMETER_NAME>
      <DESCRIPTION>1–5 alphanumeric characters (e.g. ACME), agreed with Enginatics.</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>2</SORT_ORDER>
    <DISPLAY_SEQUENCE>20</DISPLAY_SEQUENCE>
    <ANCHOR>:custom_prefix</ANCHOR>
    <PARAMETER_TYPE_DSP>Char</PARAMETER_TYPE_DSP>
    <DEFAULT_VALUE>XX</DEFAULT_VALUE>
    <REQUIRED>Y</REQUIRED>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Custom Object Prefix</PARAMETER_NAME>
      <DESCRIPTION>Override only if your custom objects don’t follow Oracle’s XX convention. If you identify your custom objects with more than one prefix, enter them separated by semicolons, for example XX;APL. Every prefix is used when collecting the custom dependencies of the programs you select.</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>3</SORT_ORDER>
    <DISPLAY_SEQUENCE>30</DISPLAY_SEQUENCE>
    <ANCHOR>:select_all_programs</ANCHOR>
    <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>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Select All Programs</PARAMETER_NAME>
      <DESCRIPTION>Downloads every listed row with Convert Program set to Yes and already flagged for upload. Set Convert Program to No on the rows you do not want, then upload the file.</DESCRIPTION>
     </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>x.application=:application</SQL_TEXT>
    <PARAMETER_TYPE_DSP>LOV</PARAMETER_TYPE_DSP>
    <LOV_NAME>FND Application Name</LOV_NAME>
    <LOV_GUID>8E2FF36EDE9879D2E0530100007F1FF2</LOV_GUID>
    <LOV_QUERY_DSP>select
fav.application_id id,
fav.application_name value,
fav.application_short_name description
from
fnd_application_vl fav
order by
fav.application_name</LOV_QUERY_DSP>
    <ID_OR_VALUE>value</ID_OR_VALUE>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Application</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>x.program_type=:program_type</SQL_TEXT>
    <PARAMETER_TYPE_DSP>LOV custom</PARAMETER_TYPE_DSP>
    <LOV_QUERY_DSP>select &apos;RDF&apos; value, &apos;Oracle Reports (.rdf) report&apos; description from dual union all
select &apos;BI Publisher&apos; value, &apos;XML Publisher / BI Publisher report&apos; description from dual union all
select &apos;Data Extract&apos; value, &apos;Other concurrent program producing a data file&apos; description from dual union all
select &apos;Excel4apps&apos; value, &apos;Excel4apps Reports Wand report&apos; description from dual union all
select &apos;Custom View&apos; value, &apos;Custom database view (definition gather only)&apos; description from dual union all
select &apos;Noetix View&apos; value, &apos;NoetixViews query view (view closure gather only)&apos; description from dual union all
select &apos;WebADI Integrator&apos; value, &apos;WebADI integrator, for conversion to Blitz Upload&apos; description from dual union all
select &apos;Forms Personalization&apos; value, &apos;Forms Personalizations of a form (definition gather only)&apos; description from dual</LOV_QUERY_DSP>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Program Type</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>6</SORT_ORDER>
    <DISPLAY_SEQUENCE>60</DISPLAY_SEQUENCE>
    <ANCHOR>3=3</ANCHOR>
    <SQL_TEXT>fev.execution_method_code=xxen_util.lookup_code(:execution_method,&apos;CP_EXECUTION_METHOD_CODE&apos;,0)</SQL_TEXT>
    <PARAMETER_TYPE_DSP>LOV</PARAMETER_TYPE_DSP>
    <LOV_NAME>FND Concurrent Execution Method</LOV_NAME>
    <LOV_GUID>8E2FF36EDED979D2E0530100007F1FF2</LOV_GUID>
    <LOV_QUERY_DSP>select
flvv.meaning value,
flvv.lookup_code description
from
fnd_lookup_values_vl flvv
where
flvv.lookup_type=&apos;CP_EXECUTION_METHOD_CODE&apos; and
flvv.view_application_id=0 and
flvv.security_group_id=0
order by
flvv.meaning</LOV_QUERY_DSP>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Execution Method</PARAMETER_NAME>
      <DESCRIPTION>The execution method of the program&apos;s executable, for example Oracle Reports, PL/SQL Stored Procedure, Host or SQL*Loader. Finer grained than Program Type. Does not restrict view, WebADI integrator or Forms Personalization rows.</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>7</SORT_ORDER>
    <DISPLAY_SEQUENCE>70</DISPLAY_SEQUENCE>
    <ANCHOR>3=3</ANCHOR>
    <SQL_TEXT>fcpv.user_concurrent_program_name=:program_name</SQL_TEXT>
    <PARAMETER_TYPE_DSP>LOV</PARAMETER_TYPE_DSP>
    <LOV_NAME>FND Concurrent Program Name</LOV_NAME>
    <LOV_GUID>8E2FF36EDE9D79D2E0530100007F1FF2</LOV_GUID>
    <LOV_QUERY_DSP>select
fcpt.user_concurrent_program_name value,
fav.application_name||nvl2(fcpt.description,&apos;: &apos;,null)||fcpt.description description
from
fnd_application_vl fav,
fnd_concurrent_programs_tl fcpt
where
fcpt.language=userenv(&apos;lang&apos;) and
fcpt.application_id=fav.application_id
order by
fcpt.user_concurrent_program_name</LOV_QUERY_DSP>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>User Concurrent Program Name</PARAMETER_NAME>
      <DESCRIPTION>Exact match on the user visible concurrent program name. Several programs can be selected at once with the multiple values option.</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>8</SORT_ORDER>
    <DISPLAY_SEQUENCE>80</DISPLAY_SEQUENCE>
    <ANCHOR>3=3</ANCHOR>
    <SQL_TEXT>upper(fcpv.user_concurrent_program_name) like &apos;%&apos;||upper(:program_name_contains)||&apos;%&apos;</SQL_TEXT>
    <PARAMETER_TYPE_DSP>LOV</PARAMETER_TYPE_DSP>
    <LOV_NAME>FND Concurrent Program Name</LOV_NAME>
    <LOV_GUID>8E2FF36EDE9D79D2E0530100007F1FF2</LOV_GUID>
    <FREE_TEXT>Y</FREE_TEXT>
    <LOV_QUERY_DSP>select
fcpt.user_concurrent_program_name value,
fav.application_name||nvl2(fcpt.description,&apos;: &apos;,null)||fcpt.description description
from
fnd_application_vl fav,
fnd_concurrent_programs_tl fcpt
where
fcpt.language=userenv(&apos;lang&apos;) and
fcpt.application_id=fav.application_id
order by
fcpt.user_concurrent_program_name</LOV_QUERY_DSP>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>User Concurrent Program Name (contains)</PARAMETER_NAME>
      <DESCRIPTION>Lists every program whose user visible name contains the entered text. The list of values only suggests values, any text can be typed. Single value only.</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>9</SORT_ORDER>
    <DISPLAY_SEQUENCE>90</DISPLAY_SEQUENCE>
    <ANCHOR>3=3</ANCHOR>
    <SQL_TEXT>fcpv.concurrent_program_name=:short_name</SQL_TEXT>
    <PARAMETER_TYPE_DSP>LOV</PARAMETER_TYPE_DSP>
    <LOV_NAME>FND Concurrent Program Short Name</LOV_NAME>
    <LOV_GUID>8E2FF36EDEA179D2E0530100007F1FF2</LOV_GUID>
    <LOV_QUERY_DSP>select
fcpv.concurrent_program_name value,
fav.application_name||&apos;: &apos;||fcpv.user_concurrent_program_name description
from
fnd_application_vl fav,
fnd_concurrent_programs_vl fcpv
where
fav.application_id=fcpv.application_id
order by
fcpv.concurrent_program_name</LOV_QUERY_DSP>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Concurrent Program Short Name</PARAMETER_NAME>
      <DESCRIPTION>Exact match on the internal concurrent program short name, which is also the name used for the gathered source files. Several programs can be selected at once with the multiple values option.</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>10</SORT_ORDER>
    <DISPLAY_SEQUENCE>100</DISPLAY_SEQUENCE>
    <ANCHOR>3=3</ANCHOR>
    <SQL_TEXT>upper(fcpv.concurrent_program_name) like &apos;%&apos;||upper(:short_name_contains)||&apos;%&apos;</SQL_TEXT>
    <PARAMETER_TYPE_DSP>LOV</PARAMETER_TYPE_DSP>
    <LOV_NAME>FND Concurrent Program Short Name</LOV_NAME>
    <LOV_GUID>8E2FF36EDEA179D2E0530100007F1FF2</LOV_GUID>
    <FREE_TEXT>Y</FREE_TEXT>
    <LOV_QUERY_DSP>select
fcpv.concurrent_program_name value,
fav.application_name||&apos;: &apos;||fcpv.user_concurrent_program_name description
from
fnd_application_vl fav,
fnd_concurrent_programs_vl fcpv
where
fav.application_id=fcpv.application_id
order by
fcpv.concurrent_program_name</LOV_QUERY_DSP>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Concurrent Program Short Name (contains)</PARAMETER_NAME>
      <DESCRIPTION>Lists every program whose short name contains the entered text, for example a module abbreviation. The list of values only suggests values, any text can be typed. Single value only.</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>11</SORT_ORDER>
    <DISPLAY_SEQUENCE>110</DISPLAY_SEQUENCE>
    <ANCHOR>3=3</ANCHOR>
    <SQL_TEXT>regexp_like(fcpv.concurrent_program_name,&apos;^(&apos;||regexp_replace(upper(:custom_prefix),&apos;[[:space:]]*[,;][[:space:]]*&apos;,&apos;|&apos;)||&apos;)&apos;)</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>Custom Programs Only</PARAMETER_NAME>
      <DESCRIPTION>Restricts the list to programs and WebADI integrators whose short name starts with any of the prefixes entered in Custom Object Prefix, which is usually the quickest way to isolate a customer&apos;s own developments.</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>12</SORT_ORDER>
    <ANCHOR>4=4</ANCHOR>
    <SQL_TEXT>regexp_like(biv.integrator_code,&apos;^(&apos;||regexp_replace(upper(:custom_prefix),&apos;[[:space:]]*[,;][[:space:]]*&apos;,&apos;|&apos;)||&apos;)&apos;)</SQL_TEXT>
    <MATCHING_VALUE>Y</MATCHING_VALUE>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Custom Programs Only</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>13</SORT_ORDER>
    <DISPLAY_SEQUENCE>120</DISPLAY_SEQUENCE>
    <ANCHOR>3=3</ANCHOR>
    <SQL_TEXT>upper(fev.execution_file_name) like &apos;%&apos;||upper(:execution_file_name)||&apos;%&apos;</SQL_TEXT>
    <PARAMETER_TYPE_DSP>LOV custom</PARAMETER_TYPE_DSP>
    <FREE_TEXT>Y</FREE_TEXT>
    <LOV_QUERY_DSP>select distinct
fev.execution_file_name value,
null description
from
fnd_executables_vl fev
where
fev.execution_file_name is not null
order by
fev.execution_file_name</LOV_QUERY_DSP>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Execution File Name (contains)</PARAMETER_NAME>
      <DESCRIPTION>Lists every program whose executable file name contains the entered text. Useful to find all programs sharing the same report file, which only needs to be converted once.</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>14</SORT_ORDER>
    <DISPLAY_SEQUENCE>130</DISPLAY_SEQUENCE>
    <ANCHOR>3=3</ANCHOR>
    <SQL_TEXT>exists (
select
null
from
fnd_request_groups frg,
fnd_request_group_units frgu
where
frg.request_group_name=:request_group and
frg.application_id=frgu.application_id and
frg.request_group_id=frgu.request_group_id and
frgu.unit_application_id=fcpv.application_id and
(frgu.request_unit_type=&apos;A&apos; or frgu.request_unit_type=&apos;P&apos; and frgu.request_unit_id=fcpv.concurrent_program_id)
)</SQL_TEXT>
    <PARAMETER_TYPE_DSP>LOV</PARAMETER_TYPE_DSP>
    <LOV_NAME>FND Request Group</LOV_NAME>
    <LOV_GUID>8E2FF36EDE8F79D2E0530100007F1FF2</LOV_GUID>
    <LOV_QUERY_DSP>select
frg.request_group_name value,
frg.description
from
fnd_request_groups frg
where
(:$flex$.fnd_application_name is null or frg.application_id in (select fav.application_id from fnd_application_vl fav where fav.application_name=:$flex$.fnd_application_name))
order by
frg.request_group_name</LOV_QUERY_DSP>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Request Group</PARAMETER_NAME>
      <DESCRIPTION>Lists the programs a request group can run, either assigned individually or through one of its applications. Programs reachable only through a request set in the group are not listed. Request group names are not unique across applications, so a name used by several applications matches the programs of all of them.</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>15</SORT_ORDER>
    <DISPLAY_SEQUENCE>140</DISPLAY_SEQUENCE>
    <ANCHOR>3=3</ANCHOR>
    <SQL_TEXT>exists (
select
null
from
fnd_responsibility_vl frv,
fnd_request_group_units frgu
where
frv.responsibility_name=:responsibility and
frv.group_application_id=frgu.application_id and
frv.request_group_id=frgu.request_group_id and
frgu.unit_application_id=fcpv.application_id and
(frgu.request_unit_type=&apos;A&apos; or frgu.request_unit_type=&apos;P&apos; and frgu.request_unit_id=fcpv.concurrent_program_id)
)</SQL_TEXT>
    <PARAMETER_TYPE_DSP>LOV</PARAMETER_TYPE_DSP>
    <LOV_NAME>FND Responsibility Name</LOV_NAME>
    <LOV_GUID>8E2FF36EDE9E79D2E0530100007F1FF2</LOV_GUID>
    <LOV_QUERY_DSP>select
frv.responsibility_name value,
frv.description
from
fnd_responsibility_vl frv
order by
frv.responsibility_name</LOV_QUERY_DSP>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Responsibility</PARAMETER_NAME>
      <DESCRIPTION>Lists the programs a responsibility can run through its request group. Programs reachable only through a request set are not listed. Responsibility names are not unique across applications, so a name used by several applications matches the programs of all of them.</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>16</SORT_ORDER>
    <DISPLAY_SEQUENCE>150</DISPLAY_SEQUENCE>
    <ANCHOR>1=1</ANCHOR>
    <SQL_TEXT>(x.run_count&gt;=:minimum_run_count or x.program_type in (&apos;Custom View&apos;,&apos;Noetix View&apos;,&apos;WebADI Integrator&apos;,&apos;Forms Personalization&apos;))</SQL_TEXT>
    <PARAMETER_TYPE_DSP>Number</PARAMETER_TYPE_DSP>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Minimum Run Count</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>17</SORT_ORDER>
    <DISPLAY_SEQUENCE>160</DISPLAY_SEQUENCE>
    <ANCHOR>1=1</ANCHOR>
    <SQL_TEXT>(x.distinct_users&gt;=:minimum_distinct_users or x.program_type in (&apos;Custom View&apos;,&apos;Noetix View&apos;,&apos;WebADI Integrator&apos;,&apos;Forms Personalization&apos;))</SQL_TEXT>
    <PARAMETER_TYPE_DSP>Number</PARAMETER_TYPE_DSP>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Minimum Distinct Users</PARAMETER_NAME>
      <DESCRIPTION>Only lists programs run by at least this many different users, which helps to separate widely used reports from one off developments.</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>18</SORT_ORDER>
    <DISPLAY_SEQUENCE>170</DISPLAY_SEQUENCE>
    <ANCHOR>1=1</ANCHOR>
    <SQL_TEXT>(x.last_run_date&gt;=:last_run_date_from or x.program_type in (&apos;Custom View&apos;,&apos;Noetix View&apos;,&apos;WebADI Integrator&apos;,&apos;Forms Personalization&apos;))</SQL_TEXT>
    <PARAMETER_TYPE_DSP>Date</PARAMETER_TYPE_DSP>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Last Run Date From</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>19</SORT_ORDER>
    <DISPLAY_SEQUENCE>180</DISPLAY_SEQUENCE>
    <ANCHOR>1=1</ANCHOR>
    <SQL_TEXT>(x.last_run_date&lt;:last_run_date_to+1 or x.program_type in (&apos;Custom View&apos;,&apos;Noetix View&apos;,&apos;WebADI Integrator&apos;,&apos;Forms Personalization&apos;))</SQL_TEXT>
    <PARAMETER_TYPE_DSP>Date</PARAMETER_TYPE_DSP>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Last Run Date To</PARAMETER_NAME>
      <DESCRIPTION>Only lists programs last run on or before this date. Left empty by default so that entering Last Run Date From on its own keeps its usual meaning of everything still in use since that date.</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>20</SORT_ORDER>
    <DISPLAY_SEQUENCE>190</DISPLAY_SEQUENCE>
    <ANCHOR>:include_custom_views</ANCHOR>
    <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>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Include Custom Views</PARAMETER_NAME>
      <DESCRIPTION>Additionally list custom database views whose name starts with the Custom Object Prefix, so their definitions can be gathered for analysis (e.g. views that Discoverer-migrated reports are based on).</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>21</SORT_ORDER>
    <DISPLAY_SEQUENCE>200</DISPLAY_SEQUENCE>
    <ANCHOR>2=2</ANCHOR>
    <SQL_TEXT>regexp_like(dv.view_name,&apos;^(&apos;||regexp_replace(upper(:custom_view_prefix),&apos;[[:space:]]*[,;][[:space:]]*&apos;,&apos;|&apos;)||&apos;)&apos;)</SQL_TEXT>
    <PARAMETER_TYPE_DSP>LOV custom</PARAMETER_TYPE_DSP>
    <FREE_TEXT>Y</FREE_TEXT>
    <LOV_QUERY_DSP>select distinct
dv.view_name id,
dv.view_name value,
null description
from dba_views dv
where :$flex$.include_custom_views=&apos;Y&apos;
order by 1</LOV_QUERY_DSP>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Custom View prefix</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>22</SORT_ORDER>
    <DISPLAY_SEQUENCE>210</DISPLAY_SEQUENCE>
    <ANCHOR>:include_noetix_views</ANCHOR>
    <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>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Include Noetix Views</PARAMETER_NAME>
      <DESCRIPTION>Additionally list the NOETIX_SYS query views of a NoetixViews installation as program type Noetix View, so their view definition closure can be gathered for migration.</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>23</SORT_ORDER>
    <DISPLAY_SEQUENCE>220</DISPLAY_SEQUENCE>
    <ANCHOR>:include_webadi_integrators</ANCHOR>
    <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>
    <DEFAULT_VALUE>case when :$flex$.program_type=&apos;WebADI Integrator&apos; then &apos;Y&apos; end</DEFAULT_VALUE>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Include WebADI Integrators</PARAMETER_NAME>
      <DESCRIPTION>Additionally list the enabled WebADI integrators as program type WebADI Integrator, so their definition and custom dependencies can be gathered for conversion to Blitz Upload. EBS 11i has no integrator download, so there only the responsibilities that can use an integrator are gathered.</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>24</SORT_ORDER>
    <DISPLAY_SEQUENCE>230</DISPLAY_SEQUENCE>
    <ANCHOR>:include_forms_personalizations</ANCHOR>
    <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>
    <DEFAULT_VALUE>case when :$flex$.program_type=&apos;Forms Personalization&apos; then &apos;Y&apos; end</DEFAULT_VALUE>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Include Forms Personalizations</PARAMETER_NAME>
      <DESCRIPTION>Additionally list the forms that carry customer Forms Personalizations as program type Forms Personalization, so their personalization rules can be gathered as an FNDLOAD file.</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
  </PARAMETERS>
  <TEMPLATES>
   <TEMPLATES_ROW>
    <GUID>80B933A2A9234FE5B97A66E577E9458E</GUID>
    <TEMPLATE_NAME>Default</TEMPLATE_NAME>
    <DESCRIPTION>All columns.</DESCRIPTION>
    <OWNER>ENGINATICS</OWNER>
    <TEMPLATE_COLUMNS>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>3</DISPLAY_SEQUENCE>
      <COLUMN_NAME>APPLICATION</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>2</DISPLAY_SEQUENCE>
      <COLUMN_NAME>CONVERT_PROGRAM</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>15</DISPLAY_SEQUENCE>
      <COLUMN_NAME>CREATED_BY</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>16</DISPLAY_SEQUENCE>
      <COLUMN_NAME>CREATION_DATE</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>12</DISPLAY_SEQUENCE>
      <COLUMN_NAME>DISTINCT_USERS</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>7</DISPLAY_SEQUENCE>
      <COLUMN_NAME>EXECUTABLE</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>9</DISPLAY_SEQUENCE>
      <COLUMN_NAME>EXECUTION_FILE_NAME</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>14</DISPLAY_SEQUENCE>
      <COLUMN_NAME>FIRST_RUN_DATE</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>1</DISPLAY_SEQUENCE>
      <COLUMN_NAME>GATHER_STATUS</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>13</DISPLAY_SEQUENCE>
      <COLUMN_NAME>LAST_RUN_DATE</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>8</DISPLAY_SEQUENCE>
      <COLUMN_NAME>METHOD</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>10</DISPLAY_SEQUENCE>
      <COLUMN_NAME>OUTPUT_FORMAT</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>4</DISPLAY_SEQUENCE>
      <COLUMN_NAME>PROGRAM</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>6</DISPLAY_SEQUENCE>
      <COLUMN_NAME>PROGRAM_TYPE</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>11</DISPLAY_SEQUENCE>
      <COLUMN_NAME>RUN_COUNT</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>5</DISPLAY_SEQUENCE>
      <COLUMN_NAME>SHORT_NAME</COLUMN_NAME>
      <FREEZE_PANES>Y</FREEZE_PANES>
     </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>80B933A2A9234FE5B97A66E577E9458E</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>GATHER_STATUS</COLUMN_NAME>
    <COLUMN_TYPE_DSP>Char</COLUMN_TYPE_DSP>
    <DATA_TYPE>varchar2</DATA_TYPE>
    <DATA_LENGTH>240</DATA_LENGTH>
    <READ_ONLY>Y</READ_ONLY>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>5</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>6</COLUMN_NUMBER>
    <COLUMN_NAME>CONVERT_PROGRAM</COLUMN_NAME>
    <COLUMN_TYPE_DSP>LOV Oracle</COLUMN_TYPE_DSP>
    <DATA_TYPE>varchar2</DATA_TYPE>
    <DATA_LENGTH>10</DATA_LENGTH>
    <LOV_NAME>Yes_No</LOV_NAME>
    <LOV_QUERY_DSP>select
lookup_code id,
meaning value,
null description
from
fnd_lookups
where fnd_lookups.lookup_type=&apos;YES_NO&apos;
order by value,description</LOV_QUERY_DSP>
    <COMMENTS>Set to Yes for each program you want to convert to Blitz Report. No or blank excludes the program.</COMMENTS>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>7</COLUMN_NUMBER>
    <COLUMN_NAME>APPLICATION</COLUMN_NAME>
    <COLUMN_TYPE_DSP>Char</COLUMN_TYPE_DSP>
    <DATA_TYPE>varchar2</DATA_TYPE>
    <DATA_LENGTH>240</DATA_LENGTH>
    <READ_ONLY>Y</READ_ONLY>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>8</COLUMN_NUMBER>
    <COLUMN_NAME>PROGRAM</COLUMN_NAME>
    <COLUMN_TYPE_DSP>Char</COLUMN_TYPE_DSP>
    <DATA_TYPE>varchar2</DATA_TYPE>
    <DATA_LENGTH>240</DATA_LENGTH>
    <READ_ONLY>Y</READ_ONLY>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>9</COLUMN_NUMBER>
    <COLUMN_NAME>SHORT_NAME</COLUMN_NAME>
    <COLUMN_TYPE_DSP>Char</COLUMN_TYPE_DSP>
    <DATA_TYPE>varchar2</DATA_TYPE>
    <DATA_LENGTH>128</DATA_LENGTH>
    <READ_ONLY>Y</READ_ONLY>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>10</COLUMN_NUMBER>
    <COLUMN_NAME>PROGRAM_TYPE</COLUMN_NAME>
    <COLUMN_TYPE_DSP>Char</COLUMN_TYPE_DSP>
    <DATA_TYPE>varchar2</DATA_TYPE>
    <DATA_LENGTH>12</DATA_LENGTH>
    <READ_ONLY>Y</READ_ONLY>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>11</COLUMN_NUMBER>
    <COLUMN_NAME>EXECUTABLE</COLUMN_NAME>
    <COLUMN_TYPE_DSP>Char</COLUMN_TYPE_DSP>
    <DATA_TYPE>varchar2</DATA_TYPE>
    <DATA_LENGTH>30</DATA_LENGTH>
    <READ_ONLY>Y</READ_ONLY>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>12</COLUMN_NUMBER>
    <COLUMN_NAME>METHOD</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>13</COLUMN_NUMBER>
    <COLUMN_NAME>EXECUTION_FILE_NAME</COLUMN_NAME>
    <COLUMN_TYPE_DSP>Char</COLUMN_TYPE_DSP>
    <DATA_TYPE>varchar2</DATA_TYPE>
    <DATA_LENGTH>61</DATA_LENGTH>
    <READ_ONLY>Y</READ_ONLY>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>14</COLUMN_NUMBER>
    <COLUMN_NAME>OUTPUT_FORMAT</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>15</COLUMN_NUMBER>
    <COLUMN_NAME>RUN_COUNT</COLUMN_NAME>
    <COLUMN_TYPE_DSP>Number</COLUMN_TYPE_DSP>
    <DATA_TYPE>number</DATA_TYPE>
    <READ_ONLY>Y</READ_ONLY>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>16</COLUMN_NUMBER>
    <COLUMN_NAME>DISTINCT_USERS</COLUMN_NAME>
    <COLUMN_TYPE_DSP>Number</COLUMN_TYPE_DSP>
    <DATA_TYPE>number</DATA_TYPE>
    <READ_ONLY>Y</READ_ONLY>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>17</COLUMN_NUMBER>
    <COLUMN_NAME>LAST_RUN_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>18</COLUMN_NUMBER>
    <COLUMN_NAME>FIRST_RUN_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>19</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>20</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>21</COLUMN_NUMBER>
    <COLUMN_NAME>CONCURRENT_PROGRAM_ID</COLUMN_NAME>
    <COLUMN_TYPE_DSP>Number</COLUMN_TYPE_DSP>
    <DATA_TYPE>number</DATA_TYPE>
    <READ_ONLY>Y</READ_ONLY>
    <HIDDEN>Y</HIDDEN>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>22</COLUMN_NUMBER>
    <COLUMN_NAME>APPLICATION_ID</COLUMN_NAME>
    <COLUMN_TYPE_DSP>Number</COLUMN_TYPE_DSP>
    <DATA_TYPE>number</DATA_TYPE>
    <READ_ONLY>Y</READ_ONLY>
    <HIDDEN>Y</HIDDEN>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>23</COLUMN_NUMBER>
    <COLUMN_NAME>CUSTOMER_ABBREVIATION</COLUMN_NAME>
    <COLUMN_TYPE_DSP>Char</COLUMN_TYPE_DSP>
    <DATA_TYPE>varchar2</DATA_TYPE>
    <DATA_LENGTH>2000</DATA_LENGTH>
    <READ_ONLY>Y</READ_ONLY>
    <HIDDEN>Y</HIDDEN>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>24</COLUMN_NUMBER>
    <COLUMN_NAME>CUSTOM_PREFIX</COLUMN_NAME>
    <COLUMN_TYPE_DSP>Char</COLUMN_TYPE_DSP>
    <DATA_TYPE>varchar2</DATA_TYPE>
    <DATA_LENGTH>2000</DATA_LENGTH>
    <READ_ONLY>Y</READ_ONLY>
    <HIDDEN>Y</HIDDEN>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>25</COLUMN_NUMBER>
    <COLUMN_NAME>REQUEST_ID_</COLUMN_NAME>
    <COLUMN_TYPE_DSP>Number</COLUMN_TYPE_DSP>
    <DATA_TYPE>number</DATA_TYPE>
    <READ_ONLY>Y</READ_ONLY>
    <HIDDEN>Y</HIDDEN>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>26</COLUMN_NUMBER>
    <COLUMN_NAME>UPLOAD_ROW</COLUMN_NAME>
    <COLUMN_TYPE_DSP>Number</COLUMN_TYPE_DSP>
    <DATA_TYPE>number</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_convert</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Char</PARAMETER_TYPE>
    <COLUMN_NAME>CONVERT_PROGRAM</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>4</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_concurrent_program_id</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Number</PARAMETER_TYPE>
    <COLUMN_NAME>CONCURRENT_PROGRAM_ID</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>5</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_application_id</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Number</PARAMETER_TYPE>
    <COLUMN_NAME>APPLICATION_ID</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>6</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_program_type</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Char</PARAMETER_TYPE>
    <COLUMN_NAME>PROGRAM_TYPE</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>7</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_program</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Char</PARAMETER_TYPE>
    <COLUMN_NAME>PROGRAM</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>8</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_short_name</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Char</PARAMETER_TYPE>
    <DEFAULTED>Y</DEFAULTED>
    <COLUMN_NAME>SHORT_NAME</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>P</SOURCE>
    <DISPLAY_SEQUENCE>1</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_convert</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Char</PARAMETER_TYPE>
    <COLUMN_NAME>CONVERT_PROGRAM</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>P</SOURCE>
    <DISPLAY_SEQUENCE>2</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>request_id_</PARAMETER_NAME>
    <IN_OUT>out</IN_OUT>
    <PARAMETER_TYPE>Number</PARAMETER_TYPE>
    <COLUMN_NAME>REQUEST_ID_</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>P</SOURCE>
    <DISPLAY_SEQUENCE>3</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>P</SOURCE>
    <DISPLAY_SEQUENCE>4</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>
  <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</SQL_TEXT>
   </UPLOAD_SQLS_ROW>
   <UPLOAD_SQLS_ROW>
    <SQL_TYPE>Success SQL</SQL_TYPE>
    <SQL_TEXT>select
xu.action_,
xu.status_,
xu.message_,
xu.gather_status,
xu.modified_columns_,
xu.convert_program,
xu.application,
xu.program,
xu.short_name,
xu.program_type,
xu.executable,
xu.method,
xu.execution_file_name,
xu.output_format,
xu.run_count,
xu.distinct_users,
xu.last_run_date,
xu.first_run_date,
xu.created_by,
xu.creation_date,
xu.concurrent_program_id,
xu.application_id,
xu.customer_abbreviation,
xu.custom_prefix,
xu.request_id_,
xu.upload_row
from
xxen_blitz_report_custo_8552_u xu
where
xu.status_code_=xxen_upload.status_success</SQL_TEXT>
   </UPLOAD_SQLS_ROW>
  </UPLOAD_SQLS>
 </REPORTS_ROW>
</REPORTS>
</ROOT>
