APPS.PQH_CTL_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_ctl_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'update_dml';

Line: 59

  update pqh_transaction_categories_tl
  set
  transaction_category_id           = p_rec.transaction_category_id,
  name                              = p_rec.name,
  language                          = p_rec.language,
  source_lang                       = p_rec.source_lang
  where transaction_category_id = p_rec.transaction_category_id
  and   language = p_rec.language;

Line: 86

End update_dml;

Line: 120

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

Line: 128

End pre_update;

Line: 162

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

Line: 174

    pqh_ctl_rku.after_update
      (
  p_transaction_category_id       =>p_rec.transaction_category_id
 ,p_name                          =>p_rec.name
 ,p_language                      =>p_rec.language
 ,p_source_lang                   =>p_rec.source_lang
 ,p_name_o                        =>pqh_ctl_shd.g_old_rec.name
 ,p_language_o                    =>pqh_ctl_shd.g_old_rec.language
 ,p_source_lang_o                 =>pqh_ctl_shd.g_old_rec.source_lang
      );

Line: 199

End post_update;

Line: 298

  pqh_ctl_bus.update_validate(p_rec);

Line: 302

  pre_update(p_rec);

Line: 306

  update_dml(p_rec);

Line: 310

  post_update(p_rec);

Line: 362

     select ctl.language
       from pqh_transaction_categories_tl ctl
      where ctl.transaction_category_id = p_transaction_category_id
        AND p_language_code in (ctl.language,ctl.source_lang);

Line: 400

   l_last_updated_by            pqh_transaction_categories.last_updated_by%TYPE;

Line: 402

   l_last_update_date           pqh_transaction_categories.last_update_date%TYPE;

Line: 403

   l_last_update_login          pqh_transaction_categories.last_update_login%TYPE;

Line: 407

    Select transaction_category_id
      From pqh_transaction_categories_vl
     Where short_name = p_short_name;

Line: 424

    l_last_updated_by := -1;

Line: 427

    l_last_updated_by := 0;

Line: 431

  l_last_updated_by := fnd_load_util.owner_id(p_owner);

Line: 434

  l_last_update_date := sysdate;

Line: 435

  l_last_update_login := 0;

Line: 438

    update pqh_transaction_categories_tl
    set name        = p_name ,
         last_updated_by                =  l_last_updated_by,
         last_update_date               =  l_last_update_date,
         last_update_login              =  l_last_update_login,
        source_lang = USERENV('LANG')
    where USERENV('LANG') in (language,source_lang)
    and transaction_category_id  = l_transaction_category_id ;