APPS.HR_LOT_INS SQL Statements

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

Line: 47

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

Line: 56

  insert into hr_locations_all_tl
  (	location_id,
	language,
	source_lang,
	location_code,
	description
  )
  Values
  (	p_rec.location_id,
	p_rec.language,
	p_rec.source_lang,
	p_rec.location_code,
	p_rec.description
  );

Line: 87

End insert_dml;

Line: 126

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

Line: 139

End pre_insert;

Line: 173

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

Line: 185

    hr_lot_rki.after_insert
      (
    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
      );

Line: 208

End post_insert;

Line: 227

  hr_lot_bus.insert_validate(p_rec, p_business_group_id);

Line: 231

  pre_insert(p_rec, p_location_id);

Line: 235

  insert_dml(p_rec);

Line: 239

  post_insert(p_rec);

Line: 305

    select l.language_code
      from fnd_languages l
     where l.installed_flag in ('I', 'B')
       and not exists (select null
                         from hr_locations_all_tl lot
                         where lot.location_id = p_location_id
                         and   lot.language    = l.language_code);

Line: 315

  l_inserted_anything    boolean := false;

Line: 332

     l_inserted_anything := true;

Line: 335

  if not l_inserted_anything then
     hr_utility.set_message(800, 'PER_52517_NO_MLS_INSERTS');