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

Line: 59

  update pqh_rule_sets_tl
  set
  rule_set_id                       = p_rec.rule_set_id,
  rule_set_name                     = p_rec.rule_set_name,
  description			    = p_rec.description,
  language                          = p_rec.language,
  source_lang                       = p_rec.source_lang
  where rule_set_id = p_rec.rule_set_id
  and   language = p_rec.language;

Line: 87

End update_dml;

Line: 121

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

Line: 129

End pre_update;

Line: 163

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

Line: 175

    pqh_rtl_rku.after_update
      (
  p_rule_set_id                   =>p_rec.rule_set_id
 ,p_rule_set_name                 =>p_rec.rule_set_name
 ,p_description			  =>p_rec.description
 ,p_language                      =>p_rec.language
 ,p_source_lang                   =>p_rec.source_lang
 ,p_rule_set_name_o               =>pqh_rtl_shd.g_old_rec.rule_set_name
 ,p_description_o		  =>pqh_rtl_shd.g_old_rec.description
 ,p_language_o                    =>pqh_rtl_shd.g_old_rec.language
 ,p_source_lang_o                 =>pqh_rtl_shd.g_old_rec.source_lang
      );

Line: 202

End post_update;

Line: 305

  pqh_rtl_bus.update_validate(p_rec);

Line: 309

  pre_update(p_rec);

Line: 313

  update_dml(p_rec);

Line: 317

  post_update(p_rec);

Line: 372

     select rtl.language
       from pqh_rule_sets_tl rtl
      where rtl.rule_set_id = p_rule_set_id
        AND p_language_code in (rtl.language,rtl.source_lang);

Line: 414

   l_last_updated_by            pqh_rule_sets.last_updated_by%TYPE;

Line: 416

   l_last_update_date           pqh_rule_sets.last_update_date%TYPE;

Line: 417

   l_last_update_login          pqh_rule_sets.last_update_login%TYPE;

Line: 420

  Cursor c1 is select rule_set_id
               from pqh_rule_sets
               where short_name = p_short_name ;

Line: 437

    l_last_updated_by := -1;

Line: 440

    l_last_updated_by := 0;

Line: 444

  l_last_update_date := sysdate;

Line: 445

  l_last_update_login := 0;

Line: 449

    update pqh_rule_sets_tl
    set rule_set_name  = p_rule_set_name ,
        description    = p_description,
         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 rule_set_id  = l_rule_set_id ;