APPS.IEU_UWQ_MEDIA_TYPES_SEED_PKG SQL Statements

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

Line: 4

  PROCEDURE Insert_Row (p_uwq_media_types_rec IN uwq_media_types_rec_type) IS

    CURSOR c IS         SELECT 'X' FROM ieu_uwq_media_types_b
                WHERE media_type_id = p_uwq_media_types_rec.media_type_id;

Line: 14

    INSERT INTO ieu_uwq_media_types_b (
      media_type_id,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      last_update_login,
      media_type_uuid,
      simple_blending_order,
      tel_reqd_flag,
      svr_login_rule_id,
      application_id,
      sh_category_type,
         image_file_name,
      classification_query_proc,
      blended_flag,
      blended_dir
    ) VALUES (
      p_uwq_media_types_rec.media_type_id,
      p_uwq_media_types_rec.created_by,
      p_uwq_media_types_rec.creation_date,
      p_uwq_media_types_rec.last_updated_by,
      p_uwq_media_types_rec.last_update_date,
      p_uwq_media_types_rec.last_update_login,
      p_uwq_media_types_rec.media_type_uuid,
      p_uwq_media_types_rec.simple_blending_order,
      p_uwq_media_types_rec.tel_reqd_flag,
      p_uwq_media_types_rec.svr_login_rule_id,
      p_uwq_media_types_rec.application_id,
         p_uwq_media_types_rec.sh_category_type,
         p_uwq_media_types_rec.image_file_name,
      p_uwq_media_types_rec.classification_query_proc,
      p_uwq_media_types_rec.blended_flag,
      p_uwq_media_types_rec.blended_dir
    );

Line: 50

    INSERT INTO ieu_uwq_media_types_tl (
      media_type_id,
      language,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      last_update_login,
      media_type_name,
      source_lang,
      media_type_description
    ) SELECT
        p_uwq_media_types_rec.media_type_id,
        l.language_code,
        p_uwq_media_types_rec.created_by,
        p_uwq_media_types_rec.creation_date,
        p_uwq_media_types_rec.last_updated_by,
        p_uwq_media_types_rec.last_update_date,
        p_uwq_media_types_rec.last_update_login,
        p_uwq_media_types_rec.media_type_name,
        USERENV('LANG'),
        p_uwq_media_types_rec.media_type_description
      FROM fnd_languages l
      WHERE l.installed_flag IN ('I', 'B')
      AND NOT EXISTS
        (SELECT NULL
         FROM ieu_uwq_media_types_tl t
         WHERE t.media_type_id = p_uwq_media_types_rec.media_type_id
         AND t.language = l.language_code);

Line: 89

  END Insert_Row;

Line: 91

  PROCEDURE Update_Row (p_uwq_media_types_rec IN uwq_media_types_rec_type) IS

  BEGIN
     -- API body
    UPDATE ieu_uwq_media_types_b SET
      last_updated_by = p_uwq_media_types_rec.last_updated_by,
      last_update_date = p_uwq_media_types_rec.last_update_date,
      last_update_login = p_uwq_media_types_rec.last_update_login,
      media_type_uuid = p_uwq_media_types_rec.media_type_uuid,
      simple_blending_order = p_uwq_media_types_rec.simple_blending_order,
      tel_reqd_flag = p_uwq_media_types_rec.tel_reqd_flag,
      svr_login_rule_id = p_uwq_media_types_rec.svr_login_rule_id,
      application_id = p_uwq_media_types_rec.application_id,
         image_file_name = p_uwq_media_types_rec.image_file_name,
         sh_category_type = p_uwq_media_types_rec.sh_category_type,
      classification_query_proc = p_uwq_media_types_rec.classification_query_proc,
      blended_flag = p_uwq_media_types_rec.blended_flag,
      blended_dir = p_uwq_media_types_rec.blended_dir
    WHERE media_type_id = p_uwq_media_types_rec.media_type_id;

Line: 115

    UPDATE ieu_uwq_media_types_tl SET
      media_type_name = p_uwq_media_types_rec.media_type_name,
      source_lang = USERENV('LANG'),
      media_type_description = p_uwq_media_types_rec.media_type_description,
      last_updated_by = p_uwq_media_types_rec.last_updated_by,
      last_update_date = p_uwq_media_types_rec.last_update_date,
      last_update_login = p_uwq_media_types_rec.last_update_login
    WHERE media_type_id = p_uwq_media_types_rec.media_type_id
    AND USERENV('LANG') IN (language, source_lang);

Line: 130

  END Update_Row;

Line: 173

        l_uwq_media_types_rec.last_update_date := sysdate;

Line: 174

        l_uwq_media_types_rec.last_updated_by := user_id;

Line: 175

           l_uwq_media_types_rec.last_update_login := 0;

Line: 177

       Update_Row (p_uwq_media_types_rec => l_uwq_media_types_rec);

Line: 194

        l_uwq_media_types_rec.last_update_date := sysdate;

Line: 195

        l_uwq_media_types_rec.last_updated_by := user_id;

Line: 196

        l_uwq_media_types_rec.last_update_login := 0;

Line: 200

        Insert_Row (p_uwq_media_types_rec => l_uwq_media_types_rec);

Line: 215

      UPDATE ieu_uwq_media_types_tl SET
        media_type_name = p_media_type_name,
        source_lang = userenv('LANG'),
        media_type_description = p_media_type_description,
        last_update_date = sysdate,
        last_updated_by = decode(p_owner, 'SEED', 1, 0),
        last_update_login = 0
      WHERE media_type_id = p_media_type_id
      AND   userenv('LANG') IN (language, source_lang);

Line: 230

  delete from IEU_UWQ_MEDIA_TYPES_TL T
  where not exists
    (select NULL
    from IEU_UWQ_MEDIA_TYPES_B B
    where B.MEDIA_TYPE_ID = T.MEDIA_TYPE_ID
    );

Line: 237

  update IEU_UWQ_MEDIA_TYPES_TL T set (
      MEDIA_TYPE_NAME,
      MEDIA_TYPE_DESCRIPTION
    ) = (select
      B.MEDIA_TYPE_NAME,
      B.MEDIA_TYPE_DESCRIPTION
    from IEU_UWQ_MEDIA_TYPES_TL B
    where B.MEDIA_TYPE_ID = T.MEDIA_TYPE_ID
    and B.LANGUAGE = T.SOURCE_LANG)
  where (
      T.MEDIA_TYPE_ID,
      T.LANGUAGE
  ) in (select
      SUBT.MEDIA_TYPE_ID,
      SUBT.LANGUAGE
    from IEU_UWQ_MEDIA_TYPES_TL SUBB, IEU_UWQ_MEDIA_TYPES_TL SUBT
    where SUBB.MEDIA_TYPE_ID = SUBT.MEDIA_TYPE_ID
    and SUBB.LANGUAGE = SUBT.SOURCE_LANG
    and (SUBB.MEDIA_TYPE_NAME <> SUBT.MEDIA_TYPE_NAME
      or SUBB.MEDIA_TYPE_DESCRIPTION <> SUBT.MEDIA_TYPE_DESCRIPTION
      or (SUBB.MEDIA_TYPE_DESCRIPTION is null and SUBT.MEDIA_TYPE_DESCRIPTION is not null)
      or (SUBB.MEDIA_TYPE_DESCRIPTION is not null and SUBT.MEDIA_TYPE_DESCRIPTION is null)
  ));

Line: 261

  insert into IEU_UWQ_MEDIA_TYPES_TL (
    MEDIA_TYPE_ID,
    CREATED_BY,
    CREATION_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATE_LOGIN,
    MEDIA_TYPE_NAME,
    MEDIA_TYPE_DESCRIPTION,
    LANGUAGE,
    SOURCE_LANG
  ) select
    B.MEDIA_TYPE_ID,
    B.CREATED_BY,
    B.CREATION_DATE,
    B.LAST_UPDATED_BY,
    B.LAST_UPDATE_DATE,
    B.LAST_UPDATE_LOGIN,
    B.MEDIA_TYPE_NAME,
    B.MEDIA_TYPE_DESCRIPTION,
    L.LANGUAGE_CODE,
    B.SOURCE_LANG
  from IEU_UWQ_MEDIA_TYPES_TL B, FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and B.LANGUAGE = userenv('LANG')
  and not exists
    (select NULL
    from IEU_UWQ_MEDIA_TYPES_TL T
    where T.MEDIA_TYPE_ID = B.MEDIA_TYPE_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 295

procedure DELETE_ROW (
  X_MEDIA_TYPE_ID in NUMBER
  ) is
  begin
    delete from IEU_UWQ_MEDIA_TYPES_TL
    where MEDIA_TYPE_ID = X_MEDIA_TYPE_ID;

Line: 306

    delete from IEU_UWQ_MEDIA_TYPES_B
    where MEDIA_TYPE_ID = X_MEDIA_TYPE_ID;

Line: 312

 end DELETE_ROW;

Line: 321

 X_LAST_UPDATED_BY in NUMBER,
 X_LAST_UPDATE_DATE in DATE,
 X_MEDIA_TYPE_NAME in VARCHAR2,
 X_SOURCE_LANG in VARCHAR2,
 X_MEDIA_TYPE_DESCRIPTION in VARCHAR2,
 X_OBJECT_VERSION_NUMBER in NUMBER
) is


cursor c is select
 MEDIA_TYPE_UUID
 from IEU_UWQ_MEDIA_TYPES_B
 where MEDIA_TYPE_ID = X_MEDIA_TYPE_ID
 for update of MEDIA_TYPE_ID nowait;

Line: 337

cursor c1 is select
 MEDIA_TYPE_ID,
 language,
 CREATED_BY,
 CREATION_DATE,
 LAST_UPDATED_BY,
 LAST_UPDATE_DATE,
 MEDIA_TYPE_NAME,
 SOURCE_LANG,
 MEDIA_TYPE_DESCRIPTION,
 OBJECT_VERSION_NUMBER,
 decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
 from IEU_UWQ_MEDIA_TYPES_TL
 where MEDIA_TYPE_ID = X_MEDIA_TYPE_ID
 and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
 for update of MEDIA_TYPE_ID nowait;

Line: 359

    fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

Line: 377

        AND (tlinfo.LAST_UPDATED_BY = X_LAST_UPDATED_BY)
        AND (tlinfo.LAST_UPDATE_DATE = X_LAST_UPDATE_DATE)
        AND (tlinfo.MEDIA_TYPE_NAME = X_MEDIA_TYPE_NAME)
        AND ((tlinfo.SOURCE_LANG = X_SOURCE_LANG)
                OR ((tlinfo.SOURCE_LANG is null) AND (X_SOURCE_LANG is null)))
        AND ((tlinfo.MEDIA_TYPE_DESCRIPTION = X_MEDIA_TYPE_DESCRIPTION)
                OR ((tlinfo.MEDIA_TYPE_DESCRIPTION is null) AND (X_MEDIA_TYPE_DESCRIPTION is null)))
        AND ((tlinfo.OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER)
                OR ((tlinfo.OBJECT_VERSION_NUMBER is null) AND (X_OBJECT_VERSION_NUMBER is null)))
        ) then
                null;