APPS.ICX_CAT_DOWNLOAD_FILES_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 4

PROCEDURE insert_instruction_files
IS
  l_err_loc PLS_INTEGER;

Line: 9

  DELETE FROM icx_por_template_files;

Line: 12

  INSERT INTO icx_por_template_files
    (filename, usage, template_type, description)
  SELECT 'Readme_Spreadsheet.htm', 'TXT', 'ALL', 'Instructions for TXT upload.'
  FROM dual;

Line: 18

  INSERT INTO icx_por_template_files
    (filename, usage, template_type, description)
  SELECT 'Readme_XML.htm', 'XML', 'ALL', 'Instructions for XML upload.'
  FROM dual;

Line: 24

  INSERT INTO icx_por_template_files
    (filename, usage, template_type, description)
  SELECT 'Readme_cXML.htm', 'CXML', 'ALL', 'Instructions for cXML upload.'
  FROM dual;

Line: 30

  INSERT INTO icx_por_template_files
    (filename, usage, template_type, description)
  SELECT 'Readme_CIF.htm', 'CIF', 'ALL', 'Instructions for CIF upload.'
  FROM dual;

Line: 36

  INSERT INTO icx_por_template_files
    (filename, usage, template_type, description)
  SELECT 'Readme_Schema.htm', 'SCHEMA', 'ALL', 'Instructions for schema upload.'
  FROM dual;

Line: 42

  INSERT INTO icx_por_template_files
    (filename, usage, template_type, description)
  SELECT 'Readme_Converter.htm', 'CONVERTER', 'ALL', 'Instructions for converter.'
  FROM dual;

Line: 55

     'Exception at ICX_CAT_DOWNLOAD_FILES_PVT.insert_instruction_files(' ||
     l_err_loc || '), ' || SQLERRM);

Line: 58

END insert_instruction_files;