<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) -->
 <REPORTS_ROW>
  <GUID>0EF78F69BCD7104AE0630100007F95B0</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</UPLOAD_OBJECT>
  <REPORT_TRANSLATIONS>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>US</LANGUAGE>
    <REPORT_NAME>Blitz Upload Example (API)</REPORT_NAME>
    <DESCRIPTION>Example upload, which can be used as a template by copying (Tools&gt;Copy Report) to create new uploads using an 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>A9CCC1C94EB54A8C8EFAA51842C93FA0</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>A9CCC1C94EB54A8C8EFAA51842C93FA0</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_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>1</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_id</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Number</PARAMETER_TYPE>
    <COLUMN_NAME>ID</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>2</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_name</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Char</PARAMETER_TYPE>
    <COLUMN_NAME>NAME</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>3</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>p_date_of_birth</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Date</PARAMETER_TYPE>
    <COLUMN_NAME>DATE_OF_BIRTH</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>4</DISPLAY_SEQUENCE>
    <PARAMETER_NAME>action_</PARAMETER_NAME>
    <IN_OUT>in</IN_OUT>
    <PARAMETER_TYPE>Char</PARAMETER_TYPE>
    <COLUMN_NAME>ACTION_CODE_</COLUMN_NAME>
   </UPLOAD_PARAMETERS_ROW>
   <UPLOAD_PARAMETERS_ROW>
    <SOURCE>U</SOURCE>
    <DISPLAY_SEQUENCE>5</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>6</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, 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_4014_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>
