APPS.PAY_ETM_INS SQL Statements

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

Line: 47

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

Line: 57

  insert into pay_element_templates
  (	template_id,
	template_type,
	template_name,
	base_processing_priority,
	business_group_id,
	legislation_code,
	version_number,
	base_name,
	max_base_name_length,
	preference_info_category,
	preference_information1,
	preference_information2,
	preference_information3,
	preference_information4,
	preference_information5,
	preference_information6,
	preference_information7,
	preference_information8,
	preference_information9,
	preference_information10,
	preference_information11,
	preference_information12,
	preference_information13,
	preference_information14,
	preference_information15,
	preference_information16,
	preference_information17,
	preference_information18,
	preference_information19,
	preference_information20,
	preference_information21,
	preference_information22,
	preference_information23,
	preference_information24,
	preference_information25,
	preference_information26,
	preference_information27,
	preference_information28,
	preference_information29,
	preference_information30,
	configuration_info_category,
	configuration_information1,
	configuration_information2,
	configuration_information3,
	configuration_information4,
	configuration_information5,
	configuration_information6,
	configuration_information7,
	configuration_information8,
	configuration_information9,
	configuration_information10,
	configuration_information11,
	configuration_information12,
	configuration_information13,
	configuration_information14,
	configuration_information15,
	configuration_information16,
	configuration_information17,
	configuration_information18,
	configuration_information19,
	configuration_information20,
	configuration_information21,
	configuration_information22,
	configuration_information23,
	configuration_information24,
	configuration_information25,
	configuration_information26,
	configuration_information27,
	configuration_information28,
	configuration_information29,
	configuration_information30,
	object_version_number
  )
  Values
  (	p_rec.template_id,
	p_rec.template_type,
	p_rec.template_name,
	p_rec.base_processing_priority,
	p_rec.business_group_id,
	p_rec.legislation_code,
	p_rec.version_number,
	p_rec.base_name,
	p_rec.max_base_name_length,
	p_rec.preference_info_category,
	p_rec.preference_information1,
	p_rec.preference_information2,
	p_rec.preference_information3,
	p_rec.preference_information4,
	p_rec.preference_information5,
	p_rec.preference_information6,
	p_rec.preference_information7,
	p_rec.preference_information8,
	p_rec.preference_information9,
	p_rec.preference_information10,
	p_rec.preference_information11,
	p_rec.preference_information12,
	p_rec.preference_information13,
	p_rec.preference_information14,
	p_rec.preference_information15,
	p_rec.preference_information16,
	p_rec.preference_information17,
	p_rec.preference_information18,
	p_rec.preference_information19,
	p_rec.preference_information20,
	p_rec.preference_information21,
	p_rec.preference_information22,
	p_rec.preference_information23,
	p_rec.preference_information24,
	p_rec.preference_information25,
	p_rec.preference_information26,
	p_rec.preference_information27,
	p_rec.preference_information28,
	p_rec.preference_information29,
	p_rec.preference_information30,
	p_rec.configuration_info_category,
	p_rec.configuration_information1,
	p_rec.configuration_information2,
	p_rec.configuration_information3,
	p_rec.configuration_information4,
	p_rec.configuration_information5,
	p_rec.configuration_information6,
	p_rec.configuration_information7,
	p_rec.configuration_information8,
	p_rec.configuration_information9,
	p_rec.configuration_information10,
	p_rec.configuration_information11,
	p_rec.configuration_information12,
	p_rec.configuration_information13,
	p_rec.configuration_information14,
	p_rec.configuration_information15,
	p_rec.configuration_information16,
	p_rec.configuration_information17,
	p_rec.configuration_information18,
	p_rec.configuration_information19,
	p_rec.configuration_information20,
	p_rec.configuration_information21,
	p_rec.configuration_information22,
	p_rec.configuration_information23,
	p_rec.configuration_information24,
	p_rec.configuration_information25,
	p_rec.configuration_information26,
	p_rec.configuration_information27,
	p_rec.configuration_information28,
	p_rec.configuration_information29,
	p_rec.configuration_information30,
	p_rec.object_version_number
  );

Line: 222

End insert_dml;

Line: 261

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

Line: 265

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

Line: 278

End pre_insert;

Line: 312

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

Line: 320

End post_insert;

Line: 337

  pay_etm_bus.insert_validate(p_effective_date, p_rec);

Line: 341

  pre_insert(p_rec);

Line: 345

  insert_dml(p_rec);

Line: 349

  post_insert(p_rec);