APPS.OTA_TAV_INS SQL Statements

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

Line: 69

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

Line: 81

  insert into ota_activity_versions
  (	activity_version_id,
	activity_id,
	superseded_by_act_version_id,
	developer_organization_id,
	controlling_person_id,
	object_version_number,
	version_name,
	comments,
	description,
	duration,
	duration_units,
	end_date,
	intended_audience,
	language_id,
	maximum_attendees,
	minimum_attendees,
	objectives,
	start_date,
	success_criteria,
	user_status,
        vendor_id,
        actual_cost,
        budget_cost,
        budget_currency_code,
        expenses_allowed,
        professional_credit_type,
        professional_credits,
        maximum_internal_attendees,
	tav_information_category,
	tav_information1,
	tav_information2,
	tav_information3,
	tav_information4,
	tav_information5,
	tav_information6,
	tav_information7,
	tav_information8,
	tav_information9,
	tav_information10,
	tav_information11,
	tav_information12,
	tav_information13,
	tav_information14,
	tav_information15,
	tav_information16,
	tav_information17,
	tav_information18,
	tav_information19,
	tav_information20,
      inventory_item_id,
      organization_id,
      rco_id,
      version_code,
      business_group_id,
      data_source,
      competency_update_level,
      eres_enabled

  )
  Values
  (	p_rec.activity_version_id,
	p_rec.activity_id,
	p_rec.superseded_by_act_version_id,
	p_rec.developer_organization_id,
	p_rec.controlling_person_id,
	p_rec.object_version_number,
	p_rec.version_name,
	p_rec.comments,
	p_rec.description,
	p_rec.duration,
	p_rec.duration_units,
	p_rec.end_date,
	p_rec.intended_audience,
	p_rec.language_id,
	p_rec.maximum_attendees,
	p_rec.minimum_attendees,
	p_rec.objectives,
	p_rec.start_date,
	p_rec.success_criteria,
	p_rec.user_status,
        p_rec.vendor_id,
        p_rec.actual_cost,
        p_rec.budget_cost,
        p_rec.budget_currency_code,
        p_rec.expenses_allowed,
        p_rec.professional_credit_type,
        p_rec.professional_credits,
        p_rec.maximum_internal_attendees,
	p_rec.tav_information_category,
	p_rec.tav_information1,
	p_rec.tav_information2,
	p_rec.tav_information3,
	p_rec.tav_information4,
	p_rec.tav_information5,
	p_rec.tav_information6,
	p_rec.tav_information7,
	p_rec.tav_information8,
	p_rec.tav_information9,
	p_rec.tav_information10,
	p_rec.tav_information11,
	p_rec.tav_information12,
	p_rec.tav_information13,
	p_rec.tav_information14,
	p_rec.tav_information15,
	p_rec.tav_information16,
	p_rec.tav_information17,
	p_rec.tav_information18,
	p_rec.tav_information19,
	p_rec.tav_information20,
      p_rec.inventory_item_id,
      p_rec.organization_id,
      p_rec.rco_id,
      p_rec.version_code,
      p_rec.business_group_id,
      p_rec.data_source ,
      p_rec.competency_update_level,
      p_rec.eres_enabled
  );

Line: 223

End insert_dml;

Line: 262

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

Line: 266

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

Line: 270

    Select null
      from ota_activity_versions
     where activity_version_id =
             ota_tav_ins.g_activity_version_id_i;

Line: 316

End pre_insert;

Line: 350

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

Line: 361

End post_insert;

Line: 388

  ota_tav_bus.insert_validate(p_rec);

Line: 395

  pre_insert(p_rec);

Line: 399

  insert_dml(p_rec);

Line: 403

  post_insert(p_rec);

Line: 485

  ,p_competency_update_level        in     varchar2,
  p_eres_enabled                 in varchar2

 ) is
--
  l_rec	  ota_tav_shd.g_rec_type;

Line: 557

  ,p_competency_update_level,
  p_eres_enabled

  );