APPS.HR_LOT_DEL SQL Statements

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

Line: 45

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

Line: 54

  delete from hr_locations_all_tl
  where location_id = p_rec.location_id
  and   language = p_rec.language;

Line: 67

End delete_dml;

Line: 101

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

Line: 109

End pre_delete;

Line: 143

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

Line: 155

    hr_lot_rkd.after_delete
      (
    p_location_id                   =>p_rec.location_id
   ,p_language                      =>p_rec.language
   ,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: 178

End post_delete;

Line: 203

  hr_lot_bus.delete_validate(p_rec);

Line: 207

  pre_delete(p_rec);

Line: 211

  delete_dml(p_rec);

Line: 215

  post_delete(p_rec);

Line: 263

    select lot.language
      from hr_locations_all_tl lot
     where lot.location_id = p_location_id;

Line: 268

  l_deleted_anything  boolean := false;

Line: 280

    l_deleted_anything := true;

Line: 283

  if not l_deleted_anything then
     hr_utility.set_message(800, 'HR_7220_INVALID_PRIMARY_KEY');