APPS.PE_POI_DEL SQL Statements

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

Line: 45

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

Line: 54

  delete from per_position_extra_info
  where position_extra_info_id = p_rec.position_extra_info_id;

Line: 66

End delete_dml;

Line: 100

Procedure pre_delete(p_rec in pe_poi_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_poi_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'post_delete';

Line: 152

     pe_poi_rkd.after_delete	(
	p_position_extra_info_id_o	=>	pe_poi_shd.g_old_rec.position_extra_info_id	,
	p_position_id_o			=>	pe_poi_shd.g_old_rec.position_id			,
	p_information_type_o		=>	pe_poi_shd.g_old_rec.information_type		,
	p_request_id_o			=>	pe_poi_shd.g_old_rec.request_id			,
	p_program_application_id_o	=>	pe_poi_shd.g_old_rec.program_application_id	,
	p_program_id_o			=>	pe_poi_shd.g_old_rec.program_id			,
	p_program_update_date_o		=>	pe_poi_shd.g_old_rec.program_update_date		,
	p_poei_attribute_category_o	=>	pe_poi_shd.g_old_rec.poei_attribute_category	,
	p_poei_attribute1_o		=>	pe_poi_shd.g_old_rec.poei_attribute1	,
	p_poei_attribute2_o		=>	pe_poi_shd.g_old_rec.poei_attribute2	,
	p_poei_attribute3_o		=>	pe_poi_shd.g_old_rec.poei_attribute3	,
	p_poei_attribute4_o		=>	pe_poi_shd.g_old_rec.poei_attribute4	,
	p_poei_attribute5_o		=>	pe_poi_shd.g_old_rec.poei_attribute5	,
	p_poei_attribute6_o		=>	pe_poi_shd.g_old_rec.poei_attribute6	,
	p_poei_attribute7_o		=>	pe_poi_shd.g_old_rec.poei_attribute7	,
	p_poei_attribute8_o		=>	pe_poi_shd.g_old_rec.poei_attribute8	,
	p_poei_attribute9_o		=>	pe_poi_shd.g_old_rec.poei_attribute9	,
	p_poei_attribute10_o		=>	pe_poi_shd.g_old_rec.poei_attribute10	,
	p_poei_attribute11_o		=>	pe_poi_shd.g_old_rec.poei_attribute11	,
	p_poei_attribute12_o		=>	pe_poi_shd.g_old_rec.poei_attribute12	,
	p_poei_attribute13_o		=>	pe_poi_shd.g_old_rec.poei_attribute13	,
	p_poei_attribute14_o		=>	pe_poi_shd.g_old_rec.poei_attribute14	,
	p_poei_attribute15_o		=>	pe_poi_shd.g_old_rec.poei_attribute15	,
	p_poei_attribute16_o		=>	pe_poi_shd.g_old_rec.poei_attribute16	,
	p_poei_attribute17_o		=>	pe_poi_shd.g_old_rec.poei_attribute17	,
	p_poei_attribute18_o		=>	pe_poi_shd.g_old_rec.poei_attribute18	,
	p_poei_attribute19_o		=>	pe_poi_shd.g_old_rec.poei_attribute19	,
	p_poei_attribute20_o		=>	pe_poi_shd.g_old_rec.poei_attribute20	,
	p_poei_information_category_o	=>	pe_poi_shd.g_old_rec.poei_information_category	,
	p_poei_information1_o		=>	pe_poi_shd.g_old_rec.poei_information1	,
	p_poei_information2_o		=>	pe_poi_shd.g_old_rec.poei_information2	,
	p_poei_information3_o		=>	pe_poi_shd.g_old_rec.poei_information3	,
	p_poei_information4_o		=>	pe_poi_shd.g_old_rec.poei_information4	,
	p_poei_information5_o		=>	pe_poi_shd.g_old_rec.poei_information5	,
	p_poei_information6_o		=>	pe_poi_shd.g_old_rec.poei_information6	,
	p_poei_information7_o		=>	pe_poi_shd.g_old_rec.poei_information7	,
	p_poei_information8_o		=>	pe_poi_shd.g_old_rec.poei_information8	,
	p_poei_information9_o		=>	pe_poi_shd.g_old_rec.poei_information9	,
	p_poei_information10_o		=>	pe_poi_shd.g_old_rec.poei_information10	,
	p_poei_information11_o		=>	pe_poi_shd.g_old_rec.poei_information11	,
	p_poei_information12_o		=>	pe_poi_shd.g_old_rec.poei_information12	,
	p_poei_information13_o		=>	pe_poi_shd.g_old_rec.poei_information13	,
	p_poei_information14_o		=>	pe_poi_shd.g_old_rec.poei_information14	,
	p_poei_information15_o		=>	pe_poi_shd.g_old_rec.poei_information15	,
	p_poei_information16_o		=>	pe_poi_shd.g_old_rec.poei_information16	,
	p_poei_information17_o		=>	pe_poi_shd.g_old_rec.poei_information17	,
	p_poei_information18_o		=>	pe_poi_shd.g_old_rec.poei_information18	,
	p_poei_information19_o		=>	pe_poi_shd.g_old_rec.poei_information19	,
	p_poei_information20_o		=>	pe_poi_shd.g_old_rec.poei_information20	,
	p_poei_information21_o		=>	pe_poi_shd.g_old_rec.poei_information21	,
	p_poei_information22_o		=>	pe_poi_shd.g_old_rec.poei_information22	,
	p_poei_information23_o		=>	pe_poi_shd.g_old_rec.poei_information23	,
	p_poei_information24_o		=>	pe_poi_shd.g_old_rec.poei_information24	,
	p_poei_information25_o		=>	pe_poi_shd.g_old_rec.poei_information25	,
	p_poei_information26_o		=>	pe_poi_shd.g_old_rec.poei_information26	,
	p_poei_information27_o		=>	pe_poi_shd.g_old_rec.poei_information27	,
	p_poei_information28_o		=>	pe_poi_shd.g_old_rec.poei_information28	,
	p_poei_information29_o		=>	pe_poi_shd.g_old_rec.poei_information29	,
	p_poei_information30_o		=>	pe_poi_shd.g_old_rec.poei_information30
	);

Line: 223

End post_delete;

Line: 258

  pe_poi_bus.delete_validate(p_rec);

Line: 262

  pre_delete(p_rec);

Line: 266

  delete_dml(p_rec);

Line: 270

  post_delete(p_rec);