APPS.PAY_SD_CREATE_TEMPLATES SQL Statements

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

Line: 13

  PROCEDURE post_insert(file_id IN NUMBER) IS
    CURSOR csr_fnd_lob(p_file_id NUMBER) IS
      SELECT file_name,
             file_data
        FROM fnd_lobs
       WHERE file_id = p_file_id;

Line: 22

    l_proc      varchar2(72) := g_package || 'POST_INSERT';

Line: 32

      SELECT count(1) INTO l_count
        FROM per_solution_cmpt_names
       WHERE name = l_file_name;

Line: 38

         UPDATE per_solution_cmpt_names SET template_file = cur_fnd_lob_rec.file_data
          WHERE name = l_file_name;

Line: 48

  END post_insert;