APPS.OTA_TAD_API SQL Statements

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

Line: 178

    select 'Y'
      from ota_activity_definitions_vl      tad
     where tad.name                 =    p_name
       and tad.business_group_id    =    p_business_group_id
       and (p_activity_id is null or tad.activity_id <> p_activity_id);

Line: 228

    select activity_id
      from ota_activity_definitions_vl      tad
     where tad.name                 =    p_name
       and tad.business_group_id    =    p_business_group_id;

Line: 291

    select 'Y'
      from ota_activity_versions   tav
     where tav.activity_id    =    p_activity_id;

Line: 340

    select 'Y'
    from OTA_TRAINING_PLAN_MEMBERS
    where activity_definition_id = p_activity_id;

Line: 463

    select tav.activity_version_id
         , tav.start_date
         , tav.end_date
      from ota_activity_versions    tav
     where tav.activity_id        = p_activity_id
  order by activity_version_id;

Line: 471

    select tav.activity_version_id
         , tav.start_date
         , tav.end_date
      from ota_activity_versions      tav
     where tav.activity_id          = p_activity_id
       and tav.activity_version_id  > pcurs_version_id
  order by activity_version_id;

Line: 623

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

Line: 635

  insert into ota_activity_definitions
  (	activity_id,
	business_group_id,
	name,
	comments,
	description,
	multiple_con_versions_flag,
	object_version_number,
	tad_information_category,
	tad_information1,
	tad_information2,
	tad_information3,
	tad_information4,
	tad_information5,
	tad_information6,
	tad_information7,
	tad_information8,
	tad_information9,
	tad_information10,
	tad_information11,
	tad_information12,
	tad_information13,
	tad_information14,
	tad_information15,
	tad_information16,
	tad_information17,
	tad_information18,
	tad_information19,
	tad_information20,
      category_usage_id
  )
  Values
  (	p_rec.activity_id,
	p_rec.business_group_id,
	p_rec.name,
	p_rec.comments,
	p_rec.description,
	p_rec.multiple_con_versions_flag,
	p_rec.object_version_number,
	p_rec.tad_information_category,
	p_rec.tad_information1,
	p_rec.tad_information2,
	p_rec.tad_information3,
	p_rec.tad_information4,
	p_rec.tad_information5,
	p_rec.tad_information6,
	p_rec.tad_information7,
	p_rec.tad_information8,
	p_rec.tad_information9,
	p_rec.tad_information10,
	p_rec.tad_information11,
	p_rec.tad_information12,
	p_rec.tad_information13,
	p_rec.tad_information14,
	p_rec.tad_information15,
	p_rec.tad_information16,
	p_rec.tad_information17,
	p_rec.tad_information18,
	p_rec.tad_information19,
	p_rec.tad_information20,
      p_rec.category_usage_id
  );

Line: 715

End insert_dml;

Line: 758

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

Line: 773

  update ota_activity_definitions
  set
  activity_id                       = p_rec.activity_id,
  business_group_id                 = p_rec.business_group_id,
  name                              = p_rec.name,
  comments                          = p_rec.comments,
  description                       = p_rec.description,
  multiple_con_versions_flag        = p_rec.multiple_con_versions_flag,
  object_version_number             = p_rec.object_version_number,
  tad_information_category          = p_rec.tad_information_category,
  tad_information1                  = p_rec.tad_information1,
  tad_information2                  = p_rec.tad_information2,
  tad_information3                  = p_rec.tad_information3,
  tad_information4                  = p_rec.tad_information4,
  tad_information5                  = p_rec.tad_information5,
  tad_information6                  = p_rec.tad_information6,
  tad_information7                  = p_rec.tad_information7,
  tad_information8                  = p_rec.tad_information8,
  tad_information9                  = p_rec.tad_information9,
  tad_information10                 = p_rec.tad_information10,
  tad_information11                 = p_rec.tad_information11,
  tad_information12                 = p_rec.tad_information12,
  tad_information13                 = p_rec.tad_information13,
  tad_information14                 = p_rec.tad_information14,
  tad_information15                 = p_rec.tad_information15,
  tad_information16                 = p_rec.tad_information16,
  tad_information17                 = p_rec.tad_information17,
  tad_information18                 = p_rec.tad_information18,
  tad_information19                 = p_rec.tad_information19,
  tad_information20                 = p_rec.tad_information20,
  category_usage_id                 = p_rec.category_usage_id
  where activity_id = p_rec.activity_id;

Line: 824

End update_dml;

Line: 865

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

Line: 876

  delete from ota_activity_definitions
  where activity_id = p_rec.activity_id;

Line: 903

End delete_dml;

Line: 939

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

Line: 943

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

Line: 956

End pre_insert;

Line: 987

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

Line: 995

End pre_update;

Line: 1026

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

Line: 1034

End pre_delete;

Line: 1065

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

Line: 1073

End post_insert;

Line: 1104

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

Line: 1112

End post_update;

Line: 1143

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

Line: 1151

End post_delete;

Line: 1207

    select 	activity_id,
	business_group_id,
	name,
	comments,
	description,
	multiple_con_versions_flag,
	object_version_number,
	tad_information_category,
	tad_information1,
	tad_information2,
	tad_information3,
	tad_information4,
	tad_information5,
	tad_information6,
	tad_information7,
	tad_information8,
	tad_information9,
	tad_information10,
	tad_information11,
	tad_information12,
	tad_information13,
	tad_information14,
	tad_information15,
	tad_information16,
	tad_information17,
	tad_information18,
	tad_information19,
	tad_information20,
      category_usage_id
    from	ota_activity_definitions
    where	activity_id = p_activity_id
    and    object_version_number + 0 = p_object_version_number
    for	update nowait;

Line: 1562

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

Line: 1578

End insert_validate;

Line: 1609

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

Line: 1645

End update_validate;

Line: 1676

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

Line: 1689

End delete_validate;

Line: 1770

  insert_validate(p_rec);

Line: 1774

  pre_insert(p_rec);

Line: 1778

  insert_dml(p_rec);

Line: 1782

  post_insert(p_rec);

Line: 2028

  update_validate(convert_defs(p_rec));

Line: 2032

  pre_update(p_rec);

Line: 2036

  update_dml(p_rec);

Line: 2040

  post_update(p_rec);

Line: 2269

  delete_validate(p_rec);

Line: 2273

  pre_delete(p_rec);

Line: 2277

  delete_dml(p_rec);

Line: 2281

  post_delete(p_rec);