APPS.GHR_REI_INS SQL Statements

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

Line: 53

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

Line: 63

  insert into ghr_pa_request_extra_info
  (	pa_request_extra_info_id,
	pa_request_id,
	information_type,
	rei_attribute_category,
	rei_attribute1,
	rei_attribute2,
	rei_attribute3,
	rei_attribute4,
	rei_attribute5,
	rei_attribute6,
	rei_attribute7,
	rei_attribute8,
	rei_attribute9,
	rei_attribute10,
	rei_attribute11,
	rei_attribute12,
	rei_attribute13,
	rei_attribute14,
	rei_attribute15,
	rei_attribute16,
	rei_attribute17,
	rei_attribute18,
	rei_attribute19,
	rei_attribute20,
	rei_information_category,
	rei_information1,
	rei_information2,
	rei_information3,
	rei_information4,
	rei_information5,
	rei_information6,
	rei_information7,
	rei_information8,
	rei_information9,
	rei_information10,
	rei_information11,
	rei_information12,
	rei_information13,
	rei_information14,
	rei_information15,
	rei_information16,
	rei_information17,
	rei_information18,
	rei_information19,
	rei_information20,
	rei_information21,
	rei_information22,
	rei_information28,
	rei_information29,
	rei_information23,
	rei_information24,
	rei_information25,
	rei_information26,
	rei_information27,
	rei_information30,
	object_version_number,
	request_id,
	program_application_id,
	program_id,
	program_update_date
  )
  Values
  (	p_rec.pa_request_extra_info_id,
	p_rec.pa_request_id,
	p_rec.information_type,
	p_rec.rei_attribute_category,
	p_rec.rei_attribute1,
	p_rec.rei_attribute2,
	p_rec.rei_attribute3,
	p_rec.rei_attribute4,
	p_rec.rei_attribute5,
	p_rec.rei_attribute6,
	p_rec.rei_attribute7,
	p_rec.rei_attribute8,
	p_rec.rei_attribute9,
	p_rec.rei_attribute10,
	p_rec.rei_attribute11,
	p_rec.rei_attribute12,
	p_rec.rei_attribute13,
	p_rec.rei_attribute14,
	p_rec.rei_attribute15,
	p_rec.rei_attribute16,
	p_rec.rei_attribute17,
	p_rec.rei_attribute18,
	p_rec.rei_attribute19,
	p_rec.rei_attribute20,
	p_rec.rei_information_category,
	p_rec.rei_information1,
	p_rec.rei_information2,
	p_rec.rei_information3,
	p_rec.rei_information4,
	p_rec.rei_information5,
	p_rec.rei_information6,
	p_rec.rei_information7,
	p_rec.rei_information8,
	p_rec.rei_information9,
	p_rec.rei_information10,
	p_rec.rei_information11,
	p_rec.rei_information12,
	p_rec.rei_information13,
	p_rec.rei_information14,
	p_rec.rei_information15,
	p_rec.rei_information16,
	p_rec.rei_information17,
	p_rec.rei_information18,
	p_rec.rei_information19,
	p_rec.rei_information20,
	p_rec.rei_information21,
	p_rec.rei_information22,
	p_rec.rei_information28,
	p_rec.rei_information29,
	p_rec.rei_information23,
	p_rec.rei_information24,
	p_rec.rei_information25,
	p_rec.rei_information26,
	p_rec.rei_information27,
	p_rec.rei_information30,
	p_rec.object_version_number,
	p_rec.request_id,
	p_rec.program_application_id,
	p_rec.program_id,
	p_rec.program_update_date
  );

Line: 204

End insert_dml;

Line: 243

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

Line: 246

  Cursor C_Sel1 is select ghr_pa_request_extra_info_s.nextval from sys.dual;

Line: 261

End pre_insert;

Line: 295

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

Line: 305

     ghr_rei_rki.after_insert	(
		p_pa_request_extra_info_id 	=>	p_rec.pa_request_extra_info_id,
		p_pa_request_id 			=>	p_rec.pa_request_id 		,
		p_information_type 		=>	p_rec.information_type 		,
		p_rei_attribute_category	=>	p_rec.rei_attribute_category 	,
		p_rei_attribute1 			=>	p_rec.rei_attribute1	 	,
		p_rei_attribute2 			=>	p_rec.rei_attribute2 		,
		p_rei_attribute3 			=>	p_rec.rei_attribute3 		,
		p_rei_attribute4 			=>	p_rec.rei_attribute4 		,
		p_rei_attribute5 			=>	p_rec.rei_attribute5 		,
		p_rei_attribute6 			=>	p_rec.rei_attribute6 		,
		p_rei_attribute7 			=>	p_rec.rei_attribute7 		,
		p_rei_attribute8 			=>	p_rec.rei_attribute8 		,
		p_rei_attribute9 			=>	p_rec.rei_attribute9 		,
		p_rei_attribute10 		=>	p_rec.rei_attribute10 		,
		p_rei_attribute11 		=>	p_rec.rei_attribute11 		,
		p_rei_attribute12 		=>	p_rec.rei_attribute12 		,
		p_rei_attribute13 		=>	p_rec.rei_attribute13 		,
		p_rei_attribute14 		=>	p_rec.rei_attribute14 		,
		p_rei_attribute15 		=>	p_rec.rei_attribute15 		,
		p_rei_attribute16 		=>	p_rec.rei_attribute16 		,
		p_rei_attribute17 		=>	p_rec.rei_attribute17 		,
		p_rei_attribute18 		=>	p_rec.rei_attribute18 		,
		p_rei_attribute19		 	=>	p_rec.rei_attribute19 		,
		p_rei_attribute20	 		=>	p_rec.rei_attribute20 		,
		p_rei_information_category 	=>	p_rec.rei_information_category,
		p_rei_information1	 	=>	p_rec.rei_information1 		,
		p_rei_information2 		=>	p_rec.rei_information2 		,
		p_rei_information3 		=>	p_rec.rei_information3 		,
		p_rei_information4 		=>	p_rec.rei_information4 		,
		p_rei_information5 		=>	p_rec.rei_information5 		,
		p_rei_information6 		=>	p_rec.rei_information6 		,
		p_rei_information7 		=>	p_rec.rei_information7 		,
		p_rei_information8 		=>	p_rec.rei_information8 		,
		p_rei_information9 		=>	p_rec.rei_information9 		,
		p_rei_information10 		=>	p_rec.rei_information10 	,
		p_rei_information11 		=>	p_rec.rei_information11 	,
		p_rei_information12 		=>	p_rec.rei_information12 	,
		p_rei_information13 		=>	p_rec.rei_information13 	,
		p_rei_information14 		=>	p_rec.rei_information14 	,
		p_rei_information15	 	=>	p_rec.rei_information15 	,
		p_rei_information16 		=>	p_rec.rei_information16 	,
		p_rei_information17	 	=>	p_rec.rei_information17 	,
		p_rei_information18 		=>	p_rec.rei_information18 	,
		p_rei_information19 		=>	p_rec.rei_information19 	,
		p_rei_information20 		=>	p_rec.rei_information20 	,
		p_rei_information21 		=>	p_rec.rei_information21 	,
		p_rei_information22 		=>	p_rec.rei_information22 	,
		p_rei_information28 		=>	p_rec.rei_information28 	,
		p_rei_information29 		=>	p_rec.rei_information29 	,
		p_rei_information23 		=>	p_rec.rei_information23 	,
		p_rei_information24 		=>	p_rec.rei_information24 	,
		p_rei_information25 		=>	p_rec.rei_information25 	,
		p_rei_information26 		=>	p_rec.rei_information26 	,
		p_rei_information27 		=>	p_rec.rei_information27 	,
		p_rei_information30 		=>	p_rec.rei_information30 	,
		p_request_id 			=>	p_rec.request_id 			,
		p_program_application_id 	=>	p_rec.program_application_id 	,
		p_program_id 			=>	p_rec.program_id 			,
		p_program_update_date 		=>	p_rec.program_update_date
	);

Line: 375

End post_insert;

Line: 402

  ghr_rei_bus.insert_validate(p_rec);

Line: 406

  pre_insert(p_rec);

Line: 410

  insert_dml(p_rec);

Line: 414

  post_insert(p_rec);

Line: 496

  p_program_update_date          in date             default null,
  p_validate                     in boolean   default false
  ) is
--
  l_rec	  ghr_rei_shd.g_rec_type;

Line: 571

  p_program_update_date
  );