APPS.OTA_EVT_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_evt_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'update_dml';

Line: 69

  update ota_events
  set
  event_id                          = p_rec.event_id,
  vendor_id                         = p_rec.vendor_id,
  activity_version_id               = p_rec.activity_version_id,
  business_group_id                 = p_rec.business_group_id,
  organization_id                   = p_rec.organization_id,
  event_type                        = p_rec.event_type,
  object_version_number             = p_rec.object_version_number,
  title                             = p_rec.title,
  budget_cost                       = p_rec.budget_cost,
  actual_cost                       = p_rec.actual_cost,
  budget_currency_code              = p_rec.budget_currency_code,
  centre                            = p_rec.centre,
  comments                          = p_rec.comments,
  course_end_date                   = p_rec.course_end_date,
  course_end_time                   = p_rec.course_end_time,
  course_start_date                 = p_rec.course_start_date,
  course_start_time                 = p_rec.course_start_time,
  duration                          = p_rec.duration,
  duration_units                    = p_rec.duration_units,
  enrolment_end_date                = p_rec.enrolment_end_date,
  enrolment_start_date              = p_rec.enrolment_start_date,
  language_id                       = p_rec.language_id,
  user_status                       = p_rec.user_status,
  development_event_type            = p_rec.development_event_type,
  event_status                      = p_rec.event_status,
  price_basis                       = p_rec.price_basis,
  currency_code                     = p_rec.currency_code,
  maximum_attendees                 = p_rec.maximum_attendees,
  maximum_internal_attendees        = p_rec.maximum_internal_attendees,
  minimum_attendees                 = p_rec.minimum_attendees,
  standard_price                    = p_rec.standard_price,
  category_code                     = p_rec.category_code,
  parent_event_id                   = p_rec.parent_event_id,
  book_independent_flag             = p_rec.book_independent_flag,
  public_event_flag                 = p_rec.public_event_flag,
  secure_event_flag                 = p_rec.secure_event_flag,
  evt_information_category          = p_rec.evt_information_category,
  evt_information1                  = p_rec.evt_information1,
  evt_information2                  = p_rec.evt_information2,
  evt_information3                  = p_rec.evt_information3,
  evt_information4                  = p_rec.evt_information4,
  evt_information5                  = p_rec.evt_information5,
  evt_information6                  = p_rec.evt_information6,
  evt_information7                  = p_rec.evt_information7,
  evt_information8                  = p_rec.evt_information8,
  evt_information9                  = p_rec.evt_information9,
  evt_information10                 = p_rec.evt_information10,
  evt_information11                 = p_rec.evt_information11,
  evt_information12                 = p_rec.evt_information12,
  evt_information13                 = p_rec.evt_information13,
  evt_information14                 = p_rec.evt_information14,
  evt_information15                 = p_rec.evt_information15,
  evt_information16                 = p_rec.evt_information16,
  evt_information17                 = p_rec.evt_information17,
  evt_information18                 = p_rec.evt_information18,
  evt_information19                 = p_rec.evt_information19,
  evt_information20                 = p_rec.evt_information20,
  project_id                        = p_rec.project_id,
  owner_id					        = p_rec.owner_id,
  line_id					        = p_rec.line_id,
  org_id					        = p_rec.org_id,
  training_center_id                = p_rec.training_center_id,
  location_id                       = p_rec.location_id,
  offering_id				        = p_rec.offering_id,
  timezone			     		    = p_rec.timezone,
  parent_offering_id				= p_rec.parent_offering_id,
  data_source 				        = p_rec.data_source,
  event_availability                = p_rec.event_availability
  where event_id = p_rec.event_id;

Line: 164

End update_dml;

Line: 198

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

Line: 206

End pre_update;

Line: 240

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

Line: 256

End post_update;

Line: 641

  ota_evt_bus.update_validate(temp_var);

Line: 649

  pre_update(p_rec);

Line: 653

  update_dml(p_rec);

Line: 659

  post_update(p_rec);

Line: 732

            	p_event_fired => 'oracle.apps.ota.api.event_api.update_class_schedule',
                 p_type  => 'class_reschedule');

Line: 740

            	p_event_fired => 'oracle.apps.ota.api.event_api.update_class_schedule',
              p_type  => 'class_title_change');

Line: 748

           p_event_fired => 'oracle.apps.ota.api.event_api.update_trng_cntr_and_location');

Line: 754

           p_event_fired => 'oracle.apps.ota.api.event_api.update_location');

Line: 761

            p_event_fired => 'oracle.apps.ota.api.event_api.update_training_center');