APPS.OTA_TSP_UPD SQL Statements

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

Line: 54

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

Line: 69

  update ota_skill_provisions
  set
  skill_provision_id                = p_rec.skill_provision_id,
  activity_version_id               = p_rec.activity_version_id,
  object_version_number             = p_rec.object_version_number,
  type                              = p_rec.type,
  comments                          = p_rec.comments,
  tsp_information_category          = p_rec.tsp_information_category,
  tsp_information1                  = p_rec.tsp_information1,
  tsp_information2                  = p_rec.tsp_information2,
  tsp_information3                  = p_rec.tsp_information3,
  tsp_information4                  = p_rec.tsp_information4,
  tsp_information5                  = p_rec.tsp_information5,
  tsp_information6                  = p_rec.tsp_information6,
  tsp_information7                  = p_rec.tsp_information7,
  tsp_information8                  = p_rec.tsp_information8,
  tsp_information9                  = p_rec.tsp_information9,
  tsp_information10                 = p_rec.tsp_information10,
  tsp_information11                 = p_rec.tsp_information11,
  tsp_information12                 = p_rec.tsp_information12,
  tsp_information13                 = p_rec.tsp_information13,
  tsp_information14                 = p_rec.tsp_information14,
  tsp_information15                 = p_rec.tsp_information15,
  tsp_information16                 = p_rec.tsp_information16,
  tsp_information17                 = p_rec.tsp_information17,
  tsp_information18                 = p_rec.tsp_information18,
  tsp_information19                 = p_rec.tsp_information19,
  tsp_information20                 = p_rec.tsp_information20,
  analysis_criteria_id              = p_rec.analysis_criteria_id
  where skill_provision_id = p_rec.skill_provision_id;

Line: 123

End update_dml;

Line: 157

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

Line: 165

End pre_update;

Line: 199

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

Line: 207

End post_update;

Line: 411

  ota_tsp_bus.update_validate(convert_defs(p_rec));

Line: 415

  pre_update(p_rec);

Line: 419

  update_dml(p_rec);

Line: 423

  post_update(p_rec);