APPS.HR_LEI_DEL SQL Statements

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

Line: 51

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

Line: 62

  delete from hr_location_extra_info
  where location_extra_info_id = p_rec.location_extra_info_id;

Line: 78

End delete_dml;

Line: 112

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

Line: 120

End pre_delete;

Line: 154

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

Line: 164

     hr_lei_rkd.after_delete	(
	p_location_extra_info_id_o	=>	hr_lei_shd.g_old_rec.location_extra_info_id,
	p_information_type_o		=>	hr_lei_shd.g_old_rec.information_type,
	p_location_id_o			=>	hr_lei_shd.g_old_rec.location_id,
	p_request_id_o			=>	hr_lei_shd.g_old_rec.request_id	,
	p_program_application_id_o	=>	hr_lei_shd.g_old_rec.program_application_id,
	p_program_id_o			=>	hr_lei_shd.g_old_rec.program_id	,
	p_program_update_date_o		=>	hr_lei_shd.g_old_rec.program_update_date,
	p_lei_attribute_category_o	=>	hr_lei_shd.g_old_rec.lei_attribute_category,
	p_lei_attribute1_o		=>	hr_lei_shd.g_old_rec.lei_attribute1,
	p_lei_attribute2_o		=>	hr_lei_shd.g_old_rec.lei_attribute2,
	p_lei_attribute3_o		=>	hr_lei_shd.g_old_rec.lei_attribute3,
	p_lei_attribute4_o		=>	hr_lei_shd.g_old_rec.lei_attribute4,
	p_lei_attribute5_o		=>	hr_lei_shd.g_old_rec.lei_attribute5,
	p_lei_attribute6_o		=>	hr_lei_shd.g_old_rec.lei_attribute6,
	p_lei_attribute7_o		=>	hr_lei_shd.g_old_rec.lei_attribute7,
	p_lei_attribute8_o		=>	hr_lei_shd.g_old_rec.lei_attribute8,
	p_lei_attribute9_o		=>	hr_lei_shd.g_old_rec.lei_attribute9,
	p_lei_attribute10_o		=>	hr_lei_shd.g_old_rec.lei_attribute10,
	p_lei_attribute11_o		=>	hr_lei_shd.g_old_rec.lei_attribute11,
	p_lei_attribute12_o		=>	hr_lei_shd.g_old_rec.lei_attribute12,
	p_lei_attribute13_o		=>	hr_lei_shd.g_old_rec.lei_attribute13,
	p_lei_attribute14_o		=>	hr_lei_shd.g_old_rec.lei_attribute14,
	p_lei_attribute15_o		=>	hr_lei_shd.g_old_rec.lei_attribute15,
	p_lei_attribute16_o		=>	hr_lei_shd.g_old_rec.lei_attribute16,
	p_lei_attribute17_o		=>	hr_lei_shd.g_old_rec.lei_attribute17,
	p_lei_attribute18_o		=>	hr_lei_shd.g_old_rec.lei_attribute18,
	p_lei_attribute19_o		=>	hr_lei_shd.g_old_rec.lei_attribute19,
	p_lei_attribute20_o		=>	hr_lei_shd.g_old_rec.lei_attribute20,
	p_lei_information_category_o	=>	hr_lei_shd.g_old_rec.lei_information_category,
	p_lei_information1_o		=>	hr_lei_shd.g_old_rec.lei_information1,
	p_lei_information2_o		=>	hr_lei_shd.g_old_rec.lei_information2,
	p_lei_information3_o		=>	hr_lei_shd.g_old_rec.lei_information3,
	p_lei_information4_o		=>	hr_lei_shd.g_old_rec.lei_information4,
	p_lei_information5_o		=>	hr_lei_shd.g_old_rec.lei_information5,
	p_lei_information6_o		=>	hr_lei_shd.g_old_rec.lei_information6,
	p_lei_information7_o		=>	hr_lei_shd.g_old_rec.lei_information7,
	p_lei_information8_o		=>	hr_lei_shd.g_old_rec.lei_information8,
	p_lei_information9_o		=>	hr_lei_shd.g_old_rec.lei_information9,
	p_lei_information10_o		=>	hr_lei_shd.g_old_rec.lei_information10,
	p_lei_information11_o		=>	hr_lei_shd.g_old_rec.lei_information11,
	p_lei_information12_o		=>	hr_lei_shd.g_old_rec.lei_information12,
	p_lei_information13_o		=>	hr_lei_shd.g_old_rec.lei_information13,
	p_lei_information14_o		=>	hr_lei_shd.g_old_rec.lei_information14,
	p_lei_information15_o		=>	hr_lei_shd.g_old_rec.lei_information15,
	p_lei_information16_o		=>	hr_lei_shd.g_old_rec.lei_information16,
	p_lei_information17_o		=>	hr_lei_shd.g_old_rec.lei_information17,
	p_lei_information18_o		=>	hr_lei_shd.g_old_rec.lei_information18,
	p_lei_information19_o		=>	hr_lei_shd.g_old_rec.lei_information19,
	p_lei_information20_o		=>	hr_lei_shd.g_old_rec.lei_information20,
	p_lei_information21_o		=>	hr_lei_shd.g_old_rec.lei_information21,
	p_lei_information22_o		=>	hr_lei_shd.g_old_rec.lei_information22,
	p_lei_information23_o		=>	hr_lei_shd.g_old_rec.lei_information23,
	p_lei_information24_o		=>	hr_lei_shd.g_old_rec.lei_information24,
	p_lei_information25_o		=>	hr_lei_shd.g_old_rec.lei_information25,
	p_lei_information26_o		=>	hr_lei_shd.g_old_rec.lei_information26,
	p_lei_information27_o		=>	hr_lei_shd.g_old_rec.lei_information27,
	p_lei_information28_o		=>	hr_lei_shd.g_old_rec.lei_information28,
	p_lei_information29_o		=>	hr_lei_shd.g_old_rec.lei_information29,
	p_lei_information30_o		=>	hr_lei_shd.g_old_rec.lei_information30
	);

Line: 235

End post_delete;

Line: 270

  hr_lei_bus.delete_validate(p_rec);

Line: 274

  pre_delete(p_rec);

Line: 278

  delete_dml(p_rec);

Line: 282

  post_delete(p_rec);