APPS.IEU_WP_UI_COMP_CATG_PKG SQL Statements

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

Line: 4

procedure insert_row(
x_rowid in out nocopy Varchar2,
p_ui_comp_catg_id in number,
p_object_version_number in number,
p_created_by in number,
p_creation_date in date,
p_last_updated_by in number,
p_last_update_date in date,
p_last_update_login in number,
p_ui_comp_catg_code in varchar2,
p_ui_comp_catg_label in varchar2,
p_ui_comp_catg_desc in varchar2
) is
  cursor C is select ROWID from IEU_WP_UI_COMP_CATG_B
    where UI_COMP_CATG_ID = P_UI_COMP_CATG_ID;

Line: 21

  insert into IEU_WP_UI_COMP_CATG_B (
  UI_COMP_CATG_ID,
  OBJECT_VERSION_NUMBER,
  CREATED_BY,
  CREATION_DATE,
  LAST_UPDATED_BY,
  LAST_UPDATE_DATE,
  LAST_UPDATE_LOGIN,
  UI_COMP_CATG_CODE
  )
  VALUES(
  p_ui_comp_catg_id,
  p_object_version_number,
  p_created_by,
  p_creation_date,
  p_last_updated_by,
  p_last_update_date,
  p_last_update_login,
  p_ui_comp_catg_code
  );

Line: 42

  insert into IEU_WP_UI_COMP_CATG_TL (
  UI_COMP_CATG_ID,
  OBJECT_VERSION_NUMBER,
  CREATED_BY,
  CREATION_DATE,
  LAST_UPDATED_BY,
  LAST_UPDATE_DATE,
  LAST_UPDATE_LOGIN,
  UI_COMP_CATG_LABEL,
  UI_COMP_CATG_DESC,
  LANGUAGE,
  SOURCE_LANG
  ) select
  p_ui_comp_catg_id,
  p_object_version_number,
  p_created_by,
  p_creation_date,
  p_last_updated_by,
  p_last_update_date,
  p_last_update_login,
  p_ui_comp_catg_label,
  p_ui_comp_catg_desc,
  l.language_code,
  userenv('LANG')
  from fnd_languages l
  where l.installed_flag in ('I', 'B')
  and not exists
  (select null from ieu_wp_ui_comp_catg_tl t
   where t.ui_comp_catg_id = p_ui_comp_catg_id
   and t.language = l.language_code);

Line: 81

END INSERT_ROW;

Line: 91

cursor c is select
  object_version_number,
  ui_comp_catg_code
  from ieu_wp_ui_comp_catg_b
  where ui_comp_catg_id = p_ui_comp_catg_id
  for update of ui_comp_catg_id nowait;

Line: 99

cursor c1 is select
  ui_comp_catg_label,
  ui_comp_catg_desc,
  decode(language, userenv('LANG'), 'Y', 'N') BASELANG
  from ieu_wp_ui_comp_catg_tl
  where ui_comp_catg_id = p_ui_comp_catg_id
  and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
  for update of ui_comp_catg_id nowait;

Line: 113

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

Line: 142

procedure update_row(
p_ui_comp_catg_id in number,
p_last_updated_by in number,
p_last_update_date in date,
p_last_update_login in number,
p_ui_comp_catg_code in varchar2,
p_ui_comp_catg_label in varchar2,
p_ui_comp_catg_desc in varchar2
) is
begin
   update IEU_WP_UI_COMP_CATG_B set
   object_version_number = object_version_number+1,
   ui_comp_catg_code = p_ui_comp_catg_code,
   last_update_date = p_last_update_date,
   last_updated_by = p_last_updated_by,
   last_update_login = p_last_update_login
   where ui_comp_catg_id = p_ui_comp_catg_id;

Line: 164

   update IEU_WP_UI_COMP_CATG_TL set
   ui_comp_catg_label = p_ui_comp_catg_label,
   ui_comp_catg_desc = p_ui_comp_catg_desc,
   last_update_date = p_last_update_date,
   last_updated_by = p_last_updated_by,
   last_update_login = p_last_update_login,
   object_version_number = object_version_number+1,
   source_lang = userenv('LANG')
   where ui_comp_catg_id = p_ui_comp_catg_id
   and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line: 179

END UPDATE_ROW;

Line: 182

procedure delete_row(
p_ui_comp_catg_id in number
) is
begin
  delete from IEU_WP_UI_COMP_CATG_TL
  where ui_comp_catg_id = p_ui_comp_catg_id;

Line: 193

  delete from ieu_wp_ui_comp_catg_b
  where ui_comp_catg_id = p_ui_comp_catg_id;

Line: 200

END DELETE_ROW;

Line: 206

  delete from IEU_WP_UI_COMP_CATG_TL t
  where not exists
     (select null
      from ieu_wp_ui_comp_catg_b b
       where b.ui_comp_catg_id = t.ui_comp_catg_id);

Line: 212

  update ieu_wp_ui_comp_catg_tl t
  set (ui_comp_catg_label, ui_comp_catg_desc)
      = (select b.ui_comp_catg_label,
         b.ui_comp_catg_desc
         from ieu_wp_ui_comp_catg_tl b
         where b.ui_comp_catg_id = t.ui_comp_catg_id
         and b.language= t.source_lang)
   where ( t.ui_comp_catg_id, t.language )
   in (select subt.ui_comp_catg_id, subt.language
       from ieu_wp_ui_comp_catg_tl subb, ieu_wp_ui_comp_catg_tl subt
       where subb.ui_comp_catg_id = subt.ui_comp_catg_id
        and subb.language = subt.source_lang
        and (subb.ui_comp_catg_label <> subt.ui_comp_catg_label
            or subb.ui_comp_catg_desc <> subt.ui_comp_catg_desc));

Line: 227

   insert into ieu_wp_ui_comp_catg_tl(
    UI_COMP_CATG_ID,
    OBJECT_VERSION_NUMBER,
    CREATED_BY,
    CREATION_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATE_LOGIN,
    UI_COMP_CATG_LABEL,
    UI_COMP_CATG_DESC,
    LANGUAGE,
    SOURCE_LANG
    ) select /*+ ORDERED */
    b.ui_comp_catg_id,
    b.object_version_number,
    b.created_by,
    b.creation_date,
    b.last_updated_by,
    b.last_update_date,
    b.last_update_login,
    b.ui_comp_catg_label,
    b.ui_comp_catg_desc,
    l.language_code,
    b.source_lang
    from ieu_wp_ui_comp_catg_tl b, fnd_languages l
    where l.installed_flag in ('I', 'B')
    and b.language= userenv('LANG')
    and not exists
        (select null from ieu_wp_ui_comp_catg_tl t
         where t.ui_comp_catg_id = b.ui_comp_catg_id
        and t.language = l.language_code);

Line: 279

     update_row(
     p_ui_comp_catg_id => p_ui_comp_catg_id,
     --p_last_updated_by => l_user_id,
     p_last_updated_by => fnd_load_util.owner_id(p_owner),
     p_last_update_date => sysdate,
     p_last_update_login => 0,
     p_ui_comp_catg_code => p_ui_comp_catg_code,
     p_ui_comp_catg_label => p_ui_comp_catg_label,
     p_ui_comp_catg_desc => p_ui_comp_catg_desc);

Line: 294

     insert_row(
      x_rowid => l_rowid,
      p_ui_comp_catg_id => p_ui_comp_catg_id,
      p_object_version_number => 1,
      --p_created_by => l_user_id,
      p_created_by => fnd_load_util.owner_id(p_owner),
      p_creation_date => sysdate,
      --p_last_updated_by => l_user_id,
      p_last_updated_by => fnd_load_util.owner_id(p_owner),
      p_last_update_date => sysdate,
      p_last_update_login => 0,
      p_ui_comp_catg_code => p_ui_comp_catg_code,
      p_ui_comp_catg_label => p_ui_comp_catg_label,
      p_ui_comp_catg_desc => p_ui_comp_catg_desc);

Line: 319

  update IEU_WP_UI_COMP_CATG_TL
  set source_lang = userenv('LANG'),
  ui_comp_catg_label = p_ui_comp_catg_label,
  ui_comp_catg_desc = p_ui_comp_catg_desc,
  last_update_date = sysdate,
  --last_updated_by = decode(p_owner, 'SEED', 1, 0),
  last_updated_by = fnd_load_util.owner_id(p_owner),
  last_update_login = 0
  where (ui_comp_catg_id = p_ui_comp_catg_id)
  and (userenv('LANG') IN (LANGUAGE, SOURCE_LANG));