APPS.IEU_WP_UI_COMPONENTS_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_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_form_comp_code in varchar2,
p_form_comp_avail_no in number,
p_property_class in varchar2,
p_ui_comp_label in varchar2,
p_ui_comp_desc in varchar2
) is
  cursor C is select ROWID from IEU_WP_UI_COMPONENTS_B
    where UI_COMP_ID = P_UI_COMP_ID;

Line: 24

  insert into IEU_WP_UI_COMPONENTS_B (
  UI_COMP_ID ,
  OBJECT_VERSION_NUMBER,
  CREATED_BY,
  CREATION_DATE,
  LAST_UPDATED_BY,
  LAST_UPDATE_DATE,
  LAST_UPDATE_LOGIN,
  UI_COMP_CATG_CODE,
  FORM_COMP_CODE,
  FORM_COMP_AVAIL_NO,
  PROPERTY_CLASS
 )
  VALUES(
  p_ui_comp_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,
  p_form_comp_code,
  p_form_comp_avail_no,
  p_property_class
  );

Line: 51

  insert into IEU_WP_UI_COMPONENTS_TL (
  UI_COMP_ID,
  OBJECT_VERSION_NUMBER,
  CREATED_BY,
  CREATION_DATE,
  LAST_UPDATED_BY,
  LAST_UPDATE_DATE,
  LAST_UPDATE_LOGIN,
  UI_COMP_LABEL,
  UI_COMP_DESC,
  LANGUAGE,
  SOURCE_LANG
  ) select
  p_ui_comp_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_label,
  p_ui_comp_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_components_tl t
   where t.ui_comp_id = p_ui_comp_id
   and t.language = l.language_code);

Line: 90

END INSERT_ROW;

Line: 103

cursor c is select
  object_version_number,
  ui_comp_catg_code,
  form_comp_code,
  form_comp_avail_no,
  property_class
  from ieu_wp_ui_components_b
  where ui_comp_id = p_ui_comp_id
  for update of ui_comp_id nowait;

Line: 114

cursor c1 is select
  ui_comp_label,
  ui_comp_desc,
  decode(language, userenv('LANG'), 'Y', 'N') BASELANG
  from ieu_wp_ui_components_tl
  where ui_comp_id = p_ui_comp_id
  and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
  for update of ui_comp_id nowait;

Line: 128

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

Line: 160

procedure update_row(
p_ui_comp_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_form_comp_code in varchar2,
p_form_comp_avail_no in number,
p_property_class in varchar2,
p_ui_comp_label in varchar2,
p_ui_comp_desc in varchar2
) is
begin
   update IEU_WP_UI_COMPONENTS_B set
   object_version_number = object_version_number+1,
   ui_comp_catg_code = p_ui_comp_catg_code,
   form_comp_code = p_form_comp_code,
   form_comp_avail_no = p_form_comp_avail_no,
   property_class = p_property_class,
   last_update_date = p_last_update_date,
   last_updated_by = p_last_updated_by,
   last_update_login = p_last_update_login
   where ui_comp_id = p_ui_comp_id;

Line: 188

   update IEU_WP_UI_COMPONENTS_TL set
   ui_comp_label = p_ui_comp_label,
   ui_comp_desc = p_ui_comp_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_id = p_ui_comp_id
   and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line: 203

END UPDATE_ROW;

Line: 206

procedure delete_row(
p_ui_comp_id in number
) is
begin
  delete from IEU_WP_UI_COMPONENTS_TL
  where ui_comp_id = p_ui_comp_id;

Line: 217

  delete from ieu_wp_ui_components_b
  where ui_comp_id = p_ui_comp_id;

Line: 224

END DELETE_ROW;

Line: 230

  delete from IEU_WP_UI_COMPONENTS_TL t
  where not exists
     (select null
      from ieu_wp_ui_components_b b
       where b.ui_comp_id = t.ui_comp_id);

Line: 236

  update ieu_wp_ui_components_tl t
  set (ui_comp_label, ui_comp_desc)
      = (select b.ui_comp_label,
         b.ui_comp_desc
         from ieu_wp_ui_components_tl b
         where b.ui_comp_id = t.ui_comp_id
         and b.language= t.source_lang)
   where ( t.ui_comp_id, t.language )
   in (select subt.ui_comp_id, subt.language
       from ieu_wp_ui_components_tl subb, ieu_wp_ui_components_tl subt
       where subb.ui_comp_id = subt.ui_comp_id
        and subb.language = subt.source_lang
        and (subb.ui_comp_label <> subt.ui_comp_label
            or subb.ui_comp_desc <> subt.ui_comp_desc));

Line: 251

   insert into ieu_wp_ui_components_tl(
    UI_COMP_ID,
    OBJECT_VERSION_NUMBER,
    CREATED_BY,
    CREATION_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATE_LOGIN,
    UI_COMP_LABEL,
    UI_COMP_DESC,
    LANGUAGE,
    SOURCE_LANG
    ) select /*+ ORDERED */
    b.ui_comp_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_label,
    b.ui_comp_desc,
    l.language_code,
    b.source_lang
    from ieu_wp_ui_components_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_components_tl t
         where t.ui_comp_id = b.ui_comp_id
        and t.language = l.language_code);

Line: 306

     update_row(
     p_ui_comp_id => p_ui_comp_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_form_comp_code => p_form_comp_code,
     p_form_comp_avail_no => p_form_comp_avail_no,
     p_property_class => p_property_class,
     p_ui_comp_label => p_ui_comp_label,
     p_ui_comp_desc => p_ui_comp_desc);

Line: 324

     insert_row(
      x_rowid => l_rowid,
      p_ui_comp_id => p_ui_comp_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_form_comp_code => p_form_comp_code,
      p_form_comp_avail_no => p_form_comp_avail_no,
      p_property_class => p_property_class,
      p_ui_comp_label => p_ui_comp_label,
      p_ui_comp_desc => p_ui_comp_desc);

Line: 352

  update IEU_WP_UI_COMPONENTS_TL
  set source_lang = userenv('LANG'),
  ui_comp_label = p_ui_comp_label,
  ui_comp_desc = p_ui_comp_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_id = p_ui_comp_id)
  and (userenv('LANG') IN (LANGUAGE, SOURCE_LANG));