APPS.PER_GB_P11D_TEMPLATE SQL Statements

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

Line: 14

      SELECT program_name
        INTO l_file_name
        FROM fnd_lobs
       WHERE file_id = p_file_id;

Line: 20

      DELETE FROM per_gb_xdo_templates
            WHERE file_name = l_file_name AND
                  effective_start_date = l_start_date AND
                  effective_end_date = l_end_date;

Line: 25

      INSERT INTO per_gb_xdo_templates
                  (file_id,
                   file_name,
                   file_description,
                   effective_start_date,
                   effective_end_date)
         SELECT p_file_id, l_file_name, 'Template for year 2002-2003',
                l_start_date, l_end_date
           FROM fnd_lobs
          WHERE file_id = p_file_id;

Line: 48

      SELECT program_name
        INTO l_file_name
        FROM fnd_lobs
       WHERE file_id = p_file_id;

Line: 54

      DELETE FROM per_gb_xdo_templates
            WHERE file_name = l_file_name AND
                  effective_start_date = l_start_date AND
                  effective_end_date = l_end_date;

Line: 59

      INSERT INTO per_gb_xdo_templates
                  (file_id,
                   file_name,
                   file_description,
                   effective_start_date,
                   effective_end_date)
         SELECT p_file_id, l_file_name, 'Template for year 2003-2004',
                l_start_date, l_end_date
           FROM fnd_lobs
          WHERE file_id = p_file_id;

Line: 82

      SELECT program_name
        INTO l_file_name
        FROM fnd_lobs
       WHERE file_id = p_file_id;

Line: 88

      DELETE FROM per_gb_xdo_templates
            WHERE file_name = l_file_name AND
                  effective_start_date = l_start_date AND
                  effective_end_date = l_end_date;

Line: 93

      INSERT INTO per_gb_xdo_templates
                  (file_id,
                   file_name,
                   file_description,
                   effective_start_date,
                   effective_end_date)
         SELECT p_file_id, l_file_name, 'Template for year 2004-2005',
                l_start_date, l_end_date
           FROM fnd_lobs
          WHERE file_id = p_file_id;