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

Line: 69

  update ota_notrng_histories
  set
  nota_history_id                   = p_rec.nota_history_id,
  person_id                         = p_rec.person_id,
  contact_id                        = p_rec.contact_id,
  trng_title                        = p_rec.trng_title,
  provider                          = p_rec.provider,
  type                              = p_rec.type,
  centre                            = p_rec.centre,
  completion_date                   = p_rec.completion_date,
  award                             = p_rec.award,
  rating                            = p_rec.rating,
  duration                          = p_rec.duration,
  duration_units                    = p_rec.duration_units,
  activity_version_id               = p_rec.activity_version_id,
  status                            = p_rec.status,
  verified_by_id                    = p_rec.verified_by_id,
  nth_information_category          = p_rec.nth_information_category,
  nth_information1                  = p_rec.nth_information1,
  nth_information2                  = p_rec.nth_information2,
  nth_information3                  = p_rec.nth_information3,
  nth_information4                  = p_rec.nth_information4,
  nth_information5                  = p_rec.nth_information5,
  nth_information6                  = p_rec.nth_information6,
  nth_information7                  = p_rec.nth_information7,
  nth_information8                  = p_rec.nth_information8,
  nth_information9                  = p_rec.nth_information9,
  nth_information10                 = p_rec.nth_information10,
  nth_information11                 = p_rec.nth_information11,
  nth_information12                 = p_rec.nth_information12,
  nth_information13                 = p_rec.nth_information13,
  nth_information15                 = p_rec.nth_information15,
  nth_information16                 = p_rec.nth_information16,
  nth_information17                 = p_rec.nth_information17,
  nth_information18                 = p_rec.nth_information18,
  nth_information19                 = p_rec.nth_information19,
  nth_information20                 = p_rec.nth_information20,
  org_id                            = p_rec.org_id,
  object_version_number             = p_rec.object_version_number,
  business_group_id                 = p_rec.business_group_id,
  nth_information14                 = p_rec.nth_information14,
  customer_id            = p_rec.customer_id,
  organization_id             = p_rec.organization_id
  where nota_history_id = p_rec.nota_history_id;

Line: 137

End update_dml;

Line: 171

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

Line: 179

End pre_update;

Line: 213

Procedure post_update(p_effective_date in date,
            p_rec in ota_nhs_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'post_update';

Line: 223

    ota_nhs_rku.after_update
      (p_effective_date              => p_effective_date
      ,p_nota_history_id
      => p_rec.nota_history_id
      ,p_person_id
      => p_rec.person_id
      ,p_contact_id
      => p_rec.contact_id
      ,p_trng_title
      => p_rec.trng_title
      ,p_provider
      => p_rec.provider
      ,p_type
      => p_rec.type
      ,p_centre
      => p_rec.centre
      ,p_completion_date
      => p_rec.completion_date
      ,p_award
      => p_rec.award
      ,p_rating
      => p_rec.rating
      ,p_duration
      => p_rec.duration
      ,p_duration_units
      => p_rec.duration_units
      ,p_activity_version_id
      => p_rec.activity_version_id
      ,p_status
      => p_rec.status
      ,p_verified_by_id
      => p_rec.verified_by_id
      ,p_nth_information_category
      => p_rec.nth_information_category
      ,p_nth_information1
      => p_rec.nth_information1
      ,p_nth_information2
      => p_rec.nth_information2
      ,p_nth_information3
      => p_rec.nth_information3
      ,p_nth_information4
      => p_rec.nth_information4
      ,p_nth_information5
      => p_rec.nth_information5
      ,p_nth_information6
      => p_rec.nth_information6
      ,p_nth_information7
      => p_rec.nth_information7
      ,p_nth_information8
      => p_rec.nth_information8
      ,p_nth_information9
      => p_rec.nth_information9
      ,p_nth_information10
      => p_rec.nth_information10
      ,p_nth_information11
      => p_rec.nth_information11
      ,p_nth_information12
      => p_rec.nth_information12
      ,p_nth_information13
      => p_rec.nth_information13
      ,p_nth_information15
      => p_rec.nth_information15
      ,p_nth_information16
      => p_rec.nth_information16
      ,p_nth_information17
      => p_rec.nth_information17
      ,p_nth_information18
      => p_rec.nth_information18
      ,p_nth_information19
      => p_rec.nth_information19
      ,p_nth_information20
      => p_rec.nth_information20
   ,p_org_id
      => p_rec.org_id
      ,p_object_version_number
      => p_rec.object_version_number
   ,p_business_group_id
      => p_rec.business_group_id
      ,p_nth_information14
      => p_rec.nth_information14
   ,p_customer_id
      => p_rec.customer_id
      ,p_organization_id
      => p_rec.organization_id
      ,p_person_id_o
      => ota_nhs_shd.g_old_rec.person_id
      ,p_contact_id_o
      => ota_nhs_shd.g_old_rec.contact_id
      ,p_trng_title_o
      => ota_nhs_shd.g_old_rec.trng_title
      ,p_provider_o
      => ota_nhs_shd.g_old_rec.provider
      ,p_type_o
      => ota_nhs_shd.g_old_rec.type
      ,p_centre_o
      => ota_nhs_shd.g_old_rec.centre
      ,p_completion_date_o
      => ota_nhs_shd.g_old_rec.completion_date
      ,p_award_o
      => ota_nhs_shd.g_old_rec.award
      ,p_rating_o
      => ota_nhs_shd.g_old_rec.rating
      ,p_duration_o
      => ota_nhs_shd.g_old_rec.duration
      ,p_duration_units_o
      => ota_nhs_shd.g_old_rec.duration_units
      ,p_activity_version_id_o
      => ota_nhs_shd.g_old_rec.activity_version_id
      ,p_status_o
      => ota_nhs_shd.g_old_rec.status
      ,p_verified_by_id_o
      => ota_nhs_shd.g_old_rec.verified_by_id
      ,p_nth_information_category_o
      => ota_nhs_shd.g_old_rec.nth_information_category
      ,p_nth_information1_o
      => ota_nhs_shd.g_old_rec.nth_information1
      ,p_nth_information2_o
      => ota_nhs_shd.g_old_rec.nth_information2
      ,p_nth_information3_o
      => ota_nhs_shd.g_old_rec.nth_information3
      ,p_nth_information4_o
      => ota_nhs_shd.g_old_rec.nth_information4
      ,p_nth_information5_o
      => ota_nhs_shd.g_old_rec.nth_information5
      ,p_nth_information6_o
      => ota_nhs_shd.g_old_rec.nth_information6
      ,p_nth_information7_o
      => ota_nhs_shd.g_old_rec.nth_information7
      ,p_nth_information8_o
      => ota_nhs_shd.g_old_rec.nth_information8
      ,p_nth_information9_o
      => ota_nhs_shd.g_old_rec.nth_information9
      ,p_nth_information10_o
      => ota_nhs_shd.g_old_rec.nth_information10
      ,p_nth_information11_o
      => ota_nhs_shd.g_old_rec.nth_information11
      ,p_nth_information12_o
      => ota_nhs_shd.g_old_rec.nth_information12
      ,p_nth_information13_o
      => ota_nhs_shd.g_old_rec.nth_information13
      ,p_nth_information15_o
      => ota_nhs_shd.g_old_rec.nth_information15
      ,p_nth_information16_o
      => ota_nhs_shd.g_old_rec.nth_information16
      ,p_nth_information17_o
      => ota_nhs_shd.g_old_rec.nth_information17
      ,p_nth_information18_o
      => ota_nhs_shd.g_old_rec.nth_information18
      ,p_nth_information19_o
      => ota_nhs_shd.g_old_rec.nth_information19
      ,p_nth_information20_o
      => ota_nhs_shd.g_old_rec.nth_information20
   ,p_org_id_o
      => ota_nhs_shd.g_old_rec.org_id
      ,p_object_version_number_o
      => ota_nhs_shd.g_old_rec.object_version_number
   ,p_business_group_id_o
      => ota_nhs_shd.g_old_rec.business_group_id
      ,p_nth_information14_o
      => ota_nhs_shd.g_old_rec.nth_information14
   ,p_customer_id_o
      => ota_nhs_shd.g_old_rec.customer_id
      ,p_organization_id_o
      => ota_nhs_shd.g_old_rec.organization_id
      );

Line: 402

End post_update;

Line: 653

ota_nhs_bus.update_validate(p_effective_date ,
                              p_rec);

Line: 658

  pre_update(p_rec);

Line: 663

  update_dml(p_rec);

Line: 668

  post_update(p_effective_date ,
              p_rec);