APPS.OTA_PMM_INS SQL Statements

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

Line: 53

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

Line: 65

  insert into ota_program_memberships
  (	program_membership_id,
	event_id,
	program_event_id,
	object_version_number,
	comments,
	group_name,
	required_flag,
	role,
	sequence,
	pmm_information_category,
	pmm_information1,
	pmm_information2,
	pmm_information3,
	pmm_information4,
	pmm_information5,
	pmm_information6,
	pmm_information7,
	pmm_information8,
	pmm_information9,
	pmm_information10,
	pmm_information11,
	pmm_information12,
	pmm_information13,
	pmm_information14,
	pmm_information15,
	pmm_information16,
	pmm_information17,
	pmm_information18,
	pmm_information19,
	pmm_information20
  )
  Values
  (	p_rec.program_membership_id,
	p_rec.event_id,
	p_rec.program_event_id,
	p_rec.object_version_number,
	p_rec.comments,
	p_rec.group_name,
	p_rec.required_flag,
	p_rec.role,
	p_rec.sequence,
	p_rec.pmm_information_category,
	p_rec.pmm_information1,
	p_rec.pmm_information2,
	p_rec.pmm_information3,
	p_rec.pmm_information4,
	p_rec.pmm_information5,
	p_rec.pmm_information6,
	p_rec.pmm_information7,
	p_rec.pmm_information8,
	p_rec.pmm_information9,
	p_rec.pmm_information10,
	p_rec.pmm_information11,
	p_rec.pmm_information12,
	p_rec.pmm_information13,
	p_rec.pmm_information14,
	p_rec.pmm_information15,
	p_rec.pmm_information16,
	p_rec.pmm_information17,
	p_rec.pmm_information18,
	p_rec.pmm_information19,
	p_rec.pmm_information20
  );

Line: 152

End insert_dml;

Line: 191

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

Line: 195

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

Line: 208

End pre_insert;

Line: 242

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

Line: 250

End post_insert;

Line: 277

  ota_pmm_bus.insert_validate(p_rec);

Line: 281

  pre_insert(p_rec);

Line: 285

  insert_dml(p_rec);

Line: 289

  post_insert(p_rec);