APPS.PQH_ATL_UPD SQL Statements

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

Line: 48

Procedure update_dml(p_rec in out nocopy pqh_atl_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'update_dml';

Line: 58

  update pqh_attributes_tl
  set
  attribute_id                      = p_rec.attribute_id,
  attribute_name                    = p_rec.attribute_name,
  language                          = p_rec.language,
  source_lang                       = p_rec.source_lang
  where attribute_id = p_rec.attribute_id
  and   language = p_rec.language;

Line: 85

End update_dml;

Line: 119

Procedure pre_update(p_rec in pqh_atl_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'pre_update';

Line: 127

End pre_update;

Line: 161

Procedure post_update(p_rec in pqh_atl_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'post_update';

Line: 173

    pqh_atl_rku.after_update
      (
  p_attribute_id                  =>p_rec.attribute_id
 ,p_attribute_name                =>p_rec.attribute_name
 ,p_language                      =>p_rec.language
 ,p_source_lang                   =>p_rec.source_lang
 ,p_attribute_name_o              =>pqh_atl_shd.g_old_rec.attribute_name
 ,p_language_o                    =>pqh_atl_shd.g_old_rec.language
 ,p_source_lang_o                 =>pqh_atl_shd.g_old_rec.source_lang
      );

Line: 198

End post_update;

Line: 297

  pqh_atl_bus.update_validate(p_rec);

Line: 301

  pre_update(p_rec);

Line: 305

  update_dml(p_rec);

Line: 309

  post_update(p_rec);

Line: 360

     select atl.language
       from pqh_attributes_tl atl
      where atl.attribute_id = p_attribute_id
        AND p_language_code in (atl.language,atl.source_lang);

Line: 398

 select attribute_id
 from pqh_attributes
 where key_column_name = p_att_col_name
   and nvl(legislation_code,'$$$') = nvl(p_legislation_code,'$$$')
   and nvl(master_table_route_id,-1) = nvl(p_table_id, -1);

Line: 405

 select table_route_id
 from pqh_table_route
 where table_alias = p_table_alias;

Line: 415

X_LAST_UPDATE_DATE DATE;

Line: 416

X_LAST_UPDATED_BY NUMBER;

Line: 417

X_LAST_UPDATE_LOGIN NUMBER;

Line: 435

    X_LAST_UPDATED_BY := -1;

Line: 438

    X_LAST_UPDATED_BY := 0;

Line: 442

  X_LAST_UPDATE_DATE := sysdate;

Line: 443

  X_LAST_UPDATE_LOGIN := 0;

Line: 444

  X_LAST_UPDATED_BY := fnd_load_util.owner_id(p_owner);

Line: 446

    update pqh_attributes_tl
    set attribute_name    = p_attribute_name ,
        last_update_date  = X_LAST_UPDATE_DATE,
        last_updated_by   = X_LAST_UPDATED_BY,
        last_update_login = X_LAST_UPDATE_LOGIN,
        source_lang = USERENV('LANG')
    where USERENV('LANG') in (language,source_lang)
    and attribute_id  = l_attribute_id ;