APPS.HR_LOT_UPD SQL Statements

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

Line: 48

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

Line: 57

  update hr_locations_all_tl
  set
  location_id                       = p_rec.location_id,
  language                          = p_rec.language,
  source_lang                       = p_rec.source_lang,
  location_code                     = p_rec.location_code,
  description                       = p_rec.description
  where location_id = p_rec.location_id
  and   language = p_rec.language;

Line: 85

End update_dml;

Line: 119

Procedure pre_update(p_rec in hr_lot_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 hr_lot_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'post_update';

Line: 173

    hr_lot_rku.after_update
      (
    p_location_id                   =>p_rec.location_id
   ,p_language                      =>p_rec.language
   ,p_source_lang                   =>p_rec.source_lang
   ,p_location_code                 =>p_rec.location_code
   ,p_description                   =>p_rec.description
   ,p_source_lang_o                 =>hr_lot_shd.g_old_rec.source_lang
   ,p_location_code_o               =>hr_lot_shd.g_old_rec.location_code
   ,p_description_o                 =>hr_lot_shd.g_old_rec.description
        );

Line: 199

End post_update;

Line: 303

  hr_lot_bus.update_validate(p_rec, p_business_group_id);

Line: 307

  pre_update(p_rec);

Line: 311

  update_dml(p_rec);

Line: 315

  post_update(p_rec);

Line: 377

    select lot.language
      from hr_locations_all_tl lot
     where lot.location_id = p_location_id
       and p_language_code in (lot.language, lot.source_lang);

Line: 384

  l_updated_anything      boolean := false;

Line: 406

      l_updated_anything := true;

Line: 409

  if not l_updated_anything then
     hr_utility.set_message(800, 'PER_52518_NO_MLS_UPDATES');