APPS.OTA_PLE_UPD SQL Statements

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

Line: 54

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

Line: 69

  update ota_price_list_entries
  set
  price_list_entry_id               = p_rec.price_list_entry_id,
  vendor_supply_id                  = p_rec.vendor_supply_id,
  activity_version_id               = p_rec.activity_version_id,
  price_list_id                     = p_rec.price_list_id,
  object_version_number             = p_rec.object_version_number,
  price                             = p_rec.price,
  price_basis                       = p_rec.price_basis,
  start_date                        = p_rec.start_date,
  comments                          = p_rec.comments,
  end_date                          = p_rec.end_date,
  maximum_attendees                 = p_rec.maximum_attendees,
  minimum_attendees                 = p_rec.minimum_attendees,
  ple_information_category          = p_rec.ple_information_category,
  ple_information1                  = p_rec.ple_information1,
  ple_information2                  = p_rec.ple_information2,
  ple_information3                  = p_rec.ple_information3,
  ple_information4                  = p_rec.ple_information4,
  ple_information5                  = p_rec.ple_information5,
  ple_information6                  = p_rec.ple_information6,
  ple_information7                  = p_rec.ple_information7,
  ple_information8                  = p_rec.ple_information8,
  ple_information9                  = p_rec.ple_information9,
  ple_information10                 = p_rec.ple_information10,
  ple_information11                 = p_rec.ple_information11,
  ple_information12                 = p_rec.ple_information12,
  ple_information13                 = p_rec.ple_information13,
  ple_information14                 = p_rec.ple_information14,
  ple_information15                 = p_rec.ple_information15,
  ple_information16                 = p_rec.ple_information16,
  ple_information17                 = p_rec.ple_information17,
  ple_information18                 = p_rec.ple_information18,
  ple_information19                 = p_rec.ple_information19,
  ple_information20                 = p_rec.ple_information20
  where price_list_entry_id = p_rec.price_list_entry_id;

Line: 129

End update_dml;

Line: 163

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

Line: 171

End pre_update;

Line: 205

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

Line: 213

End post_update;

Line: 441

  ota_ple_bus.update_validate(convert_defs(p_rec));

Line: 445

  pre_update(p_rec);

Line: 449

  update_dml(p_rec);

Line: 453

  post_update(p_rec);