APPS.GHR_REI_DEL SQL Statements

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

Line: 51

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

Line: 60

  delete from ghr_pa_request_extra_info
  where pa_request_extra_info_id = p_rec.pa_request_extra_info_id;

Line: 72

End delete_dml;

Line: 106

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

Line: 114

End pre_delete;

Line: 148

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

Line: 158

     ghr_rei_rkd.after_delete	(
		p_pa_request_extra_info_id_o 	=>	ghr_rei_shd.g_old_rec.pa_request_extra_info_id	,
		p_pa_request_id_o		 	=>	ghr_rei_shd.g_old_rec.pa_request_id 		,
		p_information_type_o 		=>	ghr_rei_shd.g_old_rec.information_type		,
		p_rei_attribute_category_o	=>	ghr_rei_shd.g_old_rec.rei_attribute_category	,
		p_rei_attribute1_o	 	=>	ghr_rei_shd.g_old_rec.rei_attribute1		,
		p_rei_attribute2_o 		=>	ghr_rei_shd.g_old_rec.rei_attribute2 		,
		p_rei_attribute3_o 		=>	ghr_rei_shd.g_old_rec.rei_attribute3 		,
		p_rei_attribute4_o 		=>	ghr_rei_shd.g_old_rec.rei_attribute4 		,
		p_rei_attribute5_o 		=>	ghr_rei_shd.g_old_rec.rei_attribute5 		,
		p_rei_attribute6_o 		=>	ghr_rei_shd.g_old_rec.rei_attribute6 		,
		p_rei_attribute7_o 		=>	ghr_rei_shd.g_old_rec.rei_attribute7 		,
		p_rei_attribute8_o 		=>	ghr_rei_shd.g_old_rec.rei_attribute8 		,
		p_rei_attribute9_o 		=>	ghr_rei_shd.g_old_rec.rei_attribute9 		,
		p_rei_attribute10_o 		=>	ghr_rei_shd.g_old_rec.rei_attribute10 		,
		p_rei_attribute11_o 		=>	ghr_rei_shd.g_old_rec.rei_attribute11 		,
		p_rei_attribute12_o 		=>	ghr_rei_shd.g_old_rec.rei_attribute12 		,
		p_rei_attribute13_o 		=>	ghr_rei_shd.g_old_rec.rei_attribute13 		,
		p_rei_attribute14_o 		=>	ghr_rei_shd.g_old_rec.rei_attribute14 		,
		p_rei_attribute15_o 		=>	ghr_rei_shd.g_old_rec.rei_attribute15 		,
		p_rei_attribute16_o 		=>	ghr_rei_shd.g_old_rec.rei_attribute16 		,
		p_rei_attribute17_o 		=>	ghr_rei_shd.g_old_rec.rei_attribute17 		,
		p_rei_attribute18_o 		=>	ghr_rei_shd.g_old_rec.rei_attribute18 		,
		p_rei_attribute19_o		=>	ghr_rei_shd.g_old_rec.rei_attribute19		,
		p_rei_attribute20_o		=>	ghr_rei_shd.g_old_rec.rei_attribute20		,
		p_rei_information_category_o 	=>	ghr_rei_shd.g_old_rec.rei_information_category	,
		p_rei_information1_o		=>	ghr_rei_shd.g_old_rec.rei_information1 		,
		p_rei_information2_o 		=>	ghr_rei_shd.g_old_rec.rei_information2 		,
		p_rei_information3_o 		=>	ghr_rei_shd.g_old_rec.rei_information3 		,
		p_rei_information4_o 		=>	ghr_rei_shd.g_old_rec.rei_information4 		,
		p_rei_information5_o 		=>	ghr_rei_shd.g_old_rec.rei_information5 		,
		p_rei_information6_o 		=>	ghr_rei_shd.g_old_rec.rei_information6 		,
		p_rei_information7_o 		=>	ghr_rei_shd.g_old_rec.rei_information7 		,
		p_rei_information8_o 		=>	ghr_rei_shd.g_old_rec.rei_information8 		,
		p_rei_information9_o 		=>	ghr_rei_shd.g_old_rec.rei_information9 		,
		p_rei_information10_o 		=>	ghr_rei_shd.g_old_rec.rei_information10 		,
		p_rei_information11_o 		=>	ghr_rei_shd.g_old_rec.rei_information11 		,
		p_rei_information12_o 		=>	ghr_rei_shd.g_old_rec.rei_information12 		,
		p_rei_information13_o 		=>	ghr_rei_shd.g_old_rec.rei_information13 		,
		p_rei_information14_o 		=>	ghr_rei_shd.g_old_rec.rei_information14 		,
		p_rei_information15_o		=>	ghr_rei_shd.g_old_rec.rei_information15 		,
		p_rei_information16_o 		=>	ghr_rei_shd.g_old_rec.rei_information16 		,
		p_rei_information17_o		=>	ghr_rei_shd.g_old_rec.rei_information17 		,
		p_rei_information18_o 		=>	ghr_rei_shd.g_old_rec.rei_information18 		,
		p_rei_information19_o 		=>	ghr_rei_shd.g_old_rec.rei_information19 		,
		p_rei_information20_o 		=>	ghr_rei_shd.g_old_rec.rei_information20 		,
		p_rei_information21_o 		=>	ghr_rei_shd.g_old_rec.rei_information21 		,
		p_rei_information22_o 		=>	ghr_rei_shd.g_old_rec.rei_information22 		,
		p_rei_information28_o 		=>	ghr_rei_shd.g_old_rec.rei_information28 		,
		p_rei_information29_o 		=>	ghr_rei_shd.g_old_rec.rei_information29 		,
		p_rei_information23_o 		=>	ghr_rei_shd.g_old_rec.rei_information23 		,
		p_rei_information24_o 		=>	ghr_rei_shd.g_old_rec.rei_information24 		,
		p_rei_information25_o 		=>	ghr_rei_shd.g_old_rec.rei_information25 		,
		p_rei_information26_o 		=>	ghr_rei_shd.g_old_rec.rei_information26 		,
		p_rei_information27_o 		=>	ghr_rei_shd.g_old_rec.rei_information27 		,
		p_rei_information30_o 		=>	ghr_rei_shd.g_old_rec.rei_information30 		,
		p_request_id_o			=>	ghr_rei_shd.g_old_rec.request_id			,
		p_program_application_id_o 	=>	ghr_rei_shd.g_old_rec.program_application_id	,
		p_program_id_o 			=>	ghr_rei_shd.g_old_rec.program_id			,
		p_program_update_date_o 	=>	ghr_rei_shd.g_old_rec.program_update_date
	);

Line: 228

End post_delete;

Line: 263

  ghr_rei_bus.delete_validate(p_rec);

Line: 267

  pre_delete(p_rec);

Line: 271

  delete_dml(p_rec);

Line: 275

  post_delete(p_rec);