APPS.PE_AEI_DEL SQL Statements

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

Line: 45

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

Line: 54

  delete from per_assignment_extra_info
  where assignment_extra_info_id = p_rec.assignment_extra_info_id;

Line: 66

End delete_dml;

Line: 100

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

Line: 108

End pre_delete;

Line: 142

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

Line: 152

     pe_aei_rkd.after_delete	(
	p_assignment_extra_info_id_o	=>	pe_aei_shd.g_old_rec.assignment_extra_info_id		,
	p_assignment_id_o			=>	pe_aei_shd.g_old_rec.assignment_id				,
	p_information_type_o		=>	pe_aei_shd.g_old_rec.information_type			,
	p_request_id_o			=>	pe_aei_shd.g_old_rec.request_id				,
	p_program_application_id_o	=>	pe_aei_shd.g_old_rec.program_application_id		,
	p_program_id_o			=>	pe_aei_shd.g_old_rec.program_id				,
	p_program_update_date_o		=>	pe_aei_shd.g_old_rec.program_update_date			,
	p_aei_attribute_category_o	=>	pe_aei_shd.g_old_rec.aei_attribute_category		,
	p_aei_attribute1_o		=>	pe_aei_shd.g_old_rec.aei_attribute1				,
	p_aei_attribute2_o		=>	pe_aei_shd.g_old_rec.aei_attribute2				,
	p_aei_attribute3_o		=>	pe_aei_shd.g_old_rec.aei_attribute3				,
	p_aei_attribute4_o		=>	pe_aei_shd.g_old_rec.aei_attribute4				,
	p_aei_attribute5_o		=>	pe_aei_shd.g_old_rec.aei_attribute5				,
	p_aei_attribute6_o		=>	pe_aei_shd.g_old_rec.aei_attribute6				,
	p_aei_attribute7_o		=>	pe_aei_shd.g_old_rec.aei_attribute7				,
	p_aei_attribute8_o		=>	pe_aei_shd.g_old_rec.aei_attribute8				,
	p_aei_attribute9_o		=>	pe_aei_shd.g_old_rec.aei_attribute9				,
	p_aei_attribute10_o		=>	pe_aei_shd.g_old_rec.aei_attribute10			,
	p_aei_attribute11_o		=>	pe_aei_shd.g_old_rec.aei_attribute11			,
	p_aei_attribute12_o		=>	pe_aei_shd.g_old_rec.aei_attribute12			,
	p_aei_attribute13_o		=>	pe_aei_shd.g_old_rec.aei_attribute13			,
	p_aei_attribute14_o		=>	pe_aei_shd.g_old_rec.aei_attribute14			,
	p_aei_attribute15_o		=>	pe_aei_shd.g_old_rec.aei_attribute15			,
	p_aei_attribute16_o		=>	pe_aei_shd.g_old_rec.aei_attribute16			,
	p_aei_attribute17_o		=>	pe_aei_shd.g_old_rec.aei_attribute17			,
	p_aei_attribute18_o		=>	pe_aei_shd.g_old_rec.aei_attribute18			,
	p_aei_attribute19_o		=>	pe_aei_shd.g_old_rec.aei_attribute19			,
	p_aei_attribute20_o		=>	pe_aei_shd.g_old_rec.aei_attribute20			,
	p_aei_information_category_o	=>	pe_aei_shd.g_old_rec.aei_information_category		,
	p_aei_information1_o		=>	pe_aei_shd.g_old_rec.aei_information1			,
	p_aei_information2_o		=>	pe_aei_shd.g_old_rec.aei_information2			,
	p_aei_information3_o		=>	pe_aei_shd.g_old_rec.aei_information3			,
	p_aei_information4_o		=>	pe_aei_shd.g_old_rec.aei_information4			,
	p_aei_information5_o		=>	pe_aei_shd.g_old_rec.aei_information5			,
	p_aei_information6_o		=>	pe_aei_shd.g_old_rec.aei_information6			,
	p_aei_information7_o		=>	pe_aei_shd.g_old_rec.aei_information7			,
	p_aei_information8_o		=>	pe_aei_shd.g_old_rec.aei_information8			,
	p_aei_information9_o		=>	pe_aei_shd.g_old_rec.aei_information9			,
	p_aei_information10_o		=>	pe_aei_shd.g_old_rec.aei_information10	,
	p_aei_information11_o		=>	pe_aei_shd.g_old_rec.aei_information11	,
	p_aei_information12_o		=>	pe_aei_shd.g_old_rec.aei_information12	,
	p_aei_information13_o		=>	pe_aei_shd.g_old_rec.aei_information13	,
	p_aei_information14_o		=>	pe_aei_shd.g_old_rec.aei_information14	,
	p_aei_information15_o		=>	pe_aei_shd.g_old_rec.aei_information15	,
	p_aei_information16_o		=>	pe_aei_shd.g_old_rec.aei_information16	,
	p_aei_information17_o		=>	pe_aei_shd.g_old_rec.aei_information17	,
	p_aei_information18_o		=>	pe_aei_shd.g_old_rec.aei_information18	,
	p_aei_information19_o		=>	pe_aei_shd.g_old_rec.aei_information19	,
	p_aei_information20_o		=>	pe_aei_shd.g_old_rec.aei_information20	,
	p_aei_information21_o		=>	pe_aei_shd.g_old_rec.aei_information21	,
	p_aei_information22_o		=>	pe_aei_shd.g_old_rec.aei_information22	,
	p_aei_information23_o		=>	pe_aei_shd.g_old_rec.aei_information23	,
	p_aei_information24_o		=>	pe_aei_shd.g_old_rec.aei_information24	,
	p_aei_information25_o		=>	pe_aei_shd.g_old_rec.aei_information25	,
	p_aei_information26_o		=>	pe_aei_shd.g_old_rec.aei_information26	,
	p_aei_information27_o		=>	pe_aei_shd.g_old_rec.aei_information27	,
	p_aei_information28_o		=>	pe_aei_shd.g_old_rec.aei_information28	,
	p_aei_information29_o		=>	pe_aei_shd.g_old_rec.aei_information29	,
	p_aei_information30_o		=>	pe_aei_shd.g_old_rec.aei_information30
	);

Line: 223

End post_delete;

Line: 258

  pe_aei_bus.delete_validate(p_rec);

Line: 262

  pre_delete(p_rec);

Line: 266

  delete_dml(p_rec);

Line: 270

  post_delete(p_rec);