16.8.1.3 Displaying Temp File Names and Types

Show temporary upload file names and readable file types in a report region.

Show the end-user the file names and user-friendly file types in temporary storage using a report region with a query like:

select filename, 
       case mime_type
          when 'application/pdf' then 'PDF Document'
          when 'image/jpeg'      then 'JPEG Image'
          when 'image/png'       then 'PNG Image'
          when 'image/gif'       then 'GIF Image'
          when 'text/plain'      then 'Text File'
          when 'application/zip' then 'ZIP Archive'
          when 'text/csv'        then 'CSV File'
          when 'application/vnd.openxmlformats-officedocument.wordprocessingml.document'
          then 'Word Document'
          when 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'
          then 'Excel Spreadsheet'
          when 'application/vnd.openxmlformats-officedocument.presentationml.presentation'
          then 'PowerPoint Presentation'
          else 'Other Type'
       end as file_type_description 
 from apex_application_temp_files 
where application_id = :APP_ID