<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 Upload Example (API without parameters) -->
 <REPORTS_ROW>
  <GUID>424FC1B6E3CA06E8E0636DFB09057CCB</GUID><ENABLED>Y</ENABLED>
  <SQL_TEXT>select
null action_,
null status_,
null message_,
null modified_columns_,
xue.id,
xue.name,
xue.date_of_birth,
to_number(null) upload_row
from
xxen_upload_example xue
where
1=1</SQL_TEXT>
  <VERSION_COMMENTS>Hidden column Upload Row added to keep the uploaded row order in the result.</VERSION_COMMENTS>
  <TYPE>U</TYPE>
  <UPLOAD_TYPE>A</UPLOAD_TYPE>
  <UPLOAD_OBJECT>xxen_upload_example_api.create_update_record_no_params</UPLOAD_OBJECT>
  <REPORT_TRANSLATIONS>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>US</LANGUAGE>
    <REPORT_NAME>Blitz Upload Example (API without parameters)</REPORT_NAME>
    <DESCRIPTION>Example upload to copy (Tools&gt;Copy Report) when creating an upload whose API processes all uploaded rows in one call, without parameters.

The upload framework calls the API once. The API reads the valid rows from the upload&apos;s data view, shown in the Data View field of the setup window, and writes each row&apos;s status and message back to it. For this upload: select * from xxen_blitz_upload_examp_9718_u xu where xu.status_code_=xxen_upload.status_valid

A copied upload has its own data view, so replace the view name in the copied API.</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>
  <PARAMETERS>
   <PARAMETERS_ROW>
    <SORT_ORDER>1</SORT_ORDER>
    <DISPLAY_SEQUENCE>10</DISPLAY_SEQUENCE>
    <ANCHOR>1=1</ANCHOR>
    <SQL_TEXT>:p_upload_mode like &apos;%&apos; || xxen_upload.action_update</SQL_TEXT>
    <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>1=1</ANCHOR>
    <SQL_TEXT>xue.name=:name</SQL_TEXT>
    <PARAMETER_TYPE_DSP>LOV custom</PARAMETER_TYPE_DSP>
    <LOV_QUERY_DSP>select distinct
xue.name value,
null description
from
xxen_upload_example xue
order by
xue.name</LOV_QUERY_DSP>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Name</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
  </PARAMETERS>
  <TEMPLATES>
   <TEMPLATES_ROW>
    <GUID>6DD4AFBC047F490C96EFBB7BC24510A6</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>DATE_OF_BIRTH</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>1</DISPLAY_SEQUENCE>
      <COLUMN_NAME>ID</COLUMN_NAME>
     </TEMPLATE_COLUMNS_ROW>
     <TEMPLATE_COLUMNS_ROW>
      <DISPLAY_SEQUENCE>2</DISPLAY_SEQUENCE>
      <COLUMN_NAME>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_ROW>
      <PARAMETER_NAME>Upload Mode</PARAMETER_NAME>
      <DEFAULT_VALUE>C,U</DEFAULT_VALUE>
     </TEMPLATE_PARAMETER_DEFAULTS_ROW>
    </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>6DD4AFBC047F490C96EFBB7BC24510A6</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>ID</COLUMN_NAME>
    <COLUMN_TYPE_DSP>Number</COLUMN_TYPE_DSP>
    <DATA_TYPE>number</DATA_TYPE>
    <REQUIRED>Y</REQUIRED>
    <READ_ONLY>Y</READ_ONLY>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>6</COLUMN_NUMBER>
    <COLUMN_NAME>NAME</COLUMN_NAME>
    <COLUMN_TYPE_DSP>Char</COLUMN_TYPE_DSP>
    <DATA_TYPE>varchar2</DATA_TYPE>
    <DATA_LENGTH>400</DATA_LENGTH>
    <REQUIRED>Y</REQUIRED>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>7</COLUMN_NUMBER>
    <COLUMN_NAME>DATE_OF_BIRTH</COLUMN_NAME>
    <COLUMN_TYPE_DSP>Date</COLUMN_TYPE_DSP>
    <DATA_TYPE>date</DATA_TYPE>
    <REQUIRED>Y</REQUIRED>
   </UPLOAD_COLUMNS_ROW>
   <UPLOAD_COLUMNS_ROW>
    <COLUMN_NUMBER>8</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>
  <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, id</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_,
xue.id,
xue.name,
xue.date_of_birth,
xu.upload_row
from
xxen_blitz_upload_examp_9718_u xu,
xxen_upload_example xue
where
xue.id=xu.id and
xu.status_code_=xxen_upload.status_success</SQL_TEXT>
   </UPLOAD_SQLS_ROW>
  </UPLOAD_SQLS>
 </REPORTS_ROW>
</REPORTS>
</ROOT>
