APPS.IEO_SVR_TYPES_SEED_PKG SQL Statements

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

Line: 4

  PROCEDURE Insert_Row (p_svr_types_rec IN uwq_svr_types_rec_type) IS

    CURSOR c IS SELECT 'X' FROM ieo_svr_types_b
    WHERE  type_id = p_svr_types_rec.type_id;

Line: 14

    INSERT INTO ieo_svr_types_b (
      type_id,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      last_update_login,
      type_uuid,
      rt_refresh_rate,
      max_major_load_factor,
      max_minor_load_factor,
      application_short_name
    ) VALUES (
      p_svr_types_rec.type_id,
      p_svr_types_rec.created_by,
      p_svr_types_rec.creation_date,
      p_svr_types_rec.last_updated_by,
      p_svr_types_rec.last_update_date,
      p_svr_types_rec.last_update_login,
      p_svr_types_rec.type_uuid,
      p_svr_types_rec.rt_refresh_rate,
      p_svr_types_rec.max_major_load_factor,
      p_svr_types_rec.max_minor_load_factor,
      p_svr_types_rec.application_short_name
    );

Line: 40

    INSERT INTO ieo_svr_types_tl (
      type_id,
      language,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      last_update_login,
      type_name,
      source_lang,
      type_description,
      type_extra
    ) SELECT
         p_svr_types_rec.type_id,
         l.language_code,
         p_svr_types_rec.created_by,
         p_svr_types_rec.creation_date,
         p_svr_types_rec.last_updated_by,
         p_svr_types_rec.last_update_date,
         p_svr_types_rec.last_update_login,
         p_svr_types_rec.type_name,
         USERENV('LANG'),
         p_svr_types_rec.type_description,
         p_svr_types_rec.type_extra
      FROM fnd_languages l
      WHERE l.installed_flag IN ('I', 'B')
      AND NOT EXISTS
        (SELECT NULL
         FROM ieo_svr_types_tl t
         WHERE t.type_id = p_svr_types_rec.type_id
         AND t.language = l.language_code);

Line: 81

  END Insert_Row;

Line: 83

  PROCEDURE Update_Row (p_svr_types_rec IN uwq_svr_types_rec_type) IS

  BEGIN
     -- API body
    UPDATE ieo_svr_types_b SET
      last_updated_by   = p_svr_types_rec.last_updated_by,
      last_update_date  = p_svr_types_rec.last_update_date,
      last_update_login = p_svr_types_rec.last_update_login,
      type_uuid = p_svr_types_rec.type_uuid,
      rt_refresh_rate = p_svr_types_rec.rt_refresh_rate,
      max_major_load_factor = p_svr_types_rec.max_major_load_factor,
      max_minor_load_factor = p_svr_types_rec.max_minor_load_factor,
      application_short_name = p_svr_types_rec.application_short_name
    WHERE type_id = p_svr_types_rec.type_id;

Line: 102

    UPDATE ieo_svr_types_tl SET
      type_name = p_svr_types_rec.type_name,
      source_lang = USERENV('LANG'),
      type_description = p_svr_types_rec.type_description,
      last_updated_by  = p_svr_types_rec.last_updated_by,
      last_update_date = p_svr_types_rec.last_update_date,
      last_update_login = p_svr_types_rec.last_update_login,
      type_extra = p_svr_types_rec.type_extra
    WHERE type_id = p_svr_types_rec.type_id
    AND USERENV('LANG') IN (language, source_lang);

Line: 118

  END Update_Row;

Line: 151

      l_svr_types_rec.last_update_date := sysdate;

Line: 152

      l_svr_types_rec.last_updated_by := user_id;

Line: 153

      l_svr_types_rec.last_update_login := 0;

Line: 156

      Update_Row (p_svr_types_rec => l_svr_types_rec);

Line: 167

      l_svr_types_rec.last_update_date := sysdate;

Line: 168

      l_svr_types_rec.last_updated_by := user_id;

Line: 169

      l_svr_types_rec.last_update_login := 0;

Line: 174

      Insert_Row (p_svr_types_rec => l_svr_types_rec);

Line: 189

     UPDATE ieo_svr_types_tl SET
     type_name = p_type_name,
     source_lang = userenv('LANG'),
     type_description = p_type_description,
     type_extra = p_type_extra,
     last_update_date = sysdate,
     last_updated_by = decode(p_owner, 'SEED', 1, 0),
     last_update_login = 0
     WHERE type_id = p_type_id
     AND   userenv('LANG') IN (language, source_lang);

Line: 205

  delete from IEO_SVR_TYPES_TL T
  where not exists
    (select NULL
    from IEO_SVR_TYPES_B B
    where B.TYPE_ID = T.TYPE_ID
    );

Line: 212

  update IEO_SVR_TYPES_TL T set (
      TYPE_NAME,
      TYPE_DESCRIPTION,
      TYPE_EXTRA
    ) = (select
      B.TYPE_NAME,
      B.TYPE_DESCRIPTION,
      B.TYPE_EXTRA
    from IEO_SVR_TYPES_TL B
    where B.TYPE_ID = T.TYPE_ID
    and B.LANGUAGE = T.SOURCE_LANG)
  where (
      T.TYPE_ID,
      T.LANGUAGE
  ) in (select
      SUBT.TYPE_ID,
      SUBT.LANGUAGE
    from IEO_SVR_TYPES_TL SUBB, IEO_SVR_TYPES_TL SUBT
    where SUBB.TYPE_ID = SUBT.TYPE_ID
    and SUBB.LANGUAGE = SUBT.SOURCE_LANG
    and (SUBB.TYPE_NAME <> SUBT.TYPE_NAME
      or SUBB.TYPE_DESCRIPTION <> SUBT.TYPE_DESCRIPTION
      or (SUBB.TYPE_DESCRIPTION is null and SUBT.TYPE_DESCRIPTION is not null)
      or (SUBB.TYPE_DESCRIPTION is not null and SUBT.TYPE_DESCRIPTION is null)
      or SUBB.TYPE_EXTRA <> SUBT.TYPE_EXTRA
      or (SUBB.TYPE_EXTRA is null and SUBT.TYPE_EXTRA is not null)
      or (SUBB.TYPE_EXTRA is not null and SUBT.TYPE_EXTRA is null)
  ));

Line: 241

  insert into IEO_SVR_TYPES_TL (
    TYPE_ID,
    CREATED_BY,
    CREATION_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATE_LOGIN,
    TYPE_NAME,
    TYPE_DESCRIPTION,
    TYPE_EXTRA,
    LANGUAGE,
    SOURCE_LANG
  ) select
    B.TYPE_ID,
    B.CREATED_BY,
    B.CREATION_DATE,
    B.LAST_UPDATED_BY,
    B.LAST_UPDATE_DATE,
    B.LAST_UPDATE_LOGIN,
    B.TYPE_NAME,
    B.TYPE_DESCRIPTION,
    B.TYPE_EXTRA,
    L.LANGUAGE_CODE,
    B.SOURCE_LANG
  from IEO_SVR_TYPES_TL B, FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and B.LANGUAGE = userenv('LANG')
  and not exists
    (select NULL
    from IEO_SVR_TYPES_TL T
    where T.TYPE_ID = B.TYPE_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);