APPS.FND_OAM_DSCRAM_RUNS_PKG SQL Statements

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

Line: 135

         SELECT run_status, target_dbname
         FROM fnd_oam_dscram_runs_b
         WHERE run_id = p_run_id;

Line: 181

      SELECT UPPER(name)
         INTO l_current_dbname
         FROM V$DATABASE;

Line: 223

         SELECT run_status
         FROM fnd_oam_dscram_runs_b
         WHERE run_id = b_run_info.run_id;

Line: 305

         SELECT last_run_stat_id, valid_check_interval, run_mode
         FROM fnd_oam_dscram_runs_b
         WHERE run_id = p_run_id;

Line: 310

         SELECT 1
         FROM sys.dual
         WHERE EXISTS (SELECT 1
                       FROM fnd_oam_dscram_stats
                       WHERE stat_id = c_stat_id);

Line: 374

      delete from FND_OAM_DSCRAM_RUNS_TL T
         where not exists
            (select NULL
             from FND_OAM_DSCRAM_RUNS_B B
             where B.RUN_ID = T.RUN_ID
             );

Line: 381

  update FND_OAM_DSCRAM_RUNS_TL T set (
      DISPLAY_NAME,
      DESCRIPTION
    ) = (select
      B.DISPLAY_NAME,
      B.DESCRIPTION
    from FND_OAM_DSCRAM_RUNS_TL B
    where B.RUN_ID = T.RUN_ID
    and B.LANGUAGE = T.SOURCE_LANG)
  where (
      T.RUN_ID,
      T.LANGUAGE
  ) in (select
      SUBT.RUN_ID,
      SUBT.LANGUAGE
    from FND_OAM_DSCRAM_RUNS_TL SUBB, FND_OAM_DSCRAM_RUNS_TL SUBT
    where SUBB.RUN_ID = SUBT.RUN_ID
    and SUBB.LANGUAGE = SUBT.SOURCE_LANG
    and (SUBB.DISPLAY_NAME <> SUBT.DISPLAY_NAME
      or SUBB.DESCRIPTION <> SUBT.DESCRIPTION
      or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
      or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
  ));

Line: 405

  insert into FND_OAM_DSCRAM_RUNS_TL (
    RUN_ID,
    DISPLAY_NAME,
    DESCRIPTION,
    CREATED_BY,
    CREATION_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATE_LOGIN,
    LANGUAGE,
    SOURCE_LANG
  ) select /*+ ORDERED */
    B.RUN_ID,
    B.DISPLAY_NAME,
    B.DESCRIPTION,
    B.CREATED_BY,
    B.CREATION_DATE,
    B.LAST_UPDATED_BY,
    B.LAST_UPDATE_DATE,
    B.LAST_UPDATE_LOGIN,
    L.LANGUAGE_CODE,
    B.SOURCE_LANG
  from FND_OAM_DSCRAM_RUNS_TL B, FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and B.LANGUAGE = userenv('LANG')
  and not exists
    (select NULL
    from FND_OAM_DSCRAM_RUNS_TL T
    where T.RUN_ID = B.RUN_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);