eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OTA_EXTERNAL_LEARNING_SWI SQL Statements

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

Line: 191


PROCEDURE update_external_learning
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_effective_date               in     date
  ,p_nota_history_id              in     number
  ,p_person_id                    in     number
  ,p_contact_id                   in     number    default hr_api.g_number
  ,p_trng_title                   in     varchar2
  ,p_provider                     in     varchar2
  ,p_type                         in     varchar2  default hr_api.g_varchar2
  ,p_centre                       in     varchar2  default hr_api.g_varchar2
  ,p_completion_date              in     date
  ,p_award                        in     varchar2  default hr_api.g_varchar2
  ,p_rating                       in     varchar2  default hr_api.g_varchar2
  ,p_duration                     in     number    default hr_api.g_number
  ,p_duration_units               in     varchar2  default hr_api.g_varchar2
  ,p_activity_version_id          in     number    default hr_api.g_number
  ,p_status                       in     varchar2  default hr_api.g_varchar2
  ,p_verified_by_id               in     number    default hr_api.g_number
  ,p_nth_information_category     in     varchar2  default hr_api.g_varchar2
  ,p_nth_information1             in     varchar2  default hr_api.g_varchar2
  ,p_nth_information2             in     varchar2  default hr_api.g_varchar2
  ,p_nth_information3             in     varchar2  default hr_api.g_varchar2
  ,p_nth_information4             in     varchar2  default hr_api.g_varchar2
  ,p_nth_information5             in     varchar2  default hr_api.g_varchar2
  ,p_nth_information6             in     varchar2  default hr_api.g_varchar2
  ,p_nth_information7             in     varchar2  default hr_api.g_varchar2
  ,p_nth_information8             in     varchar2  default hr_api.g_varchar2
  ,p_nth_information9             in     varchar2  default hr_api.g_varchar2
  ,p_nth_information10            in     varchar2  default hr_api.g_varchar2
  ,p_nth_information11            in     varchar2  default hr_api.g_varchar2
  ,p_nth_information12            in     varchar2  default hr_api.g_varchar2
  ,p_nth_information13            in     varchar2  default hr_api.g_varchar2
  ,p_nth_information15            in     varchar2  default hr_api.g_varchar2
  ,p_nth_information16            in     varchar2  default hr_api.g_varchar2
  ,p_nth_information17            in     varchar2  default hr_api.g_varchar2
  ,p_nth_information18            in     varchar2  default hr_api.g_varchar2
  ,p_nth_information19            in     varchar2  default hr_api.g_varchar2
  ,p_nth_information20            in     varchar2  default hr_api.g_varchar2
  ,p_org_id                       in     number    default hr_api.g_number
  ,p_object_version_number        in out nocopy number
  ,p_business_group_id            in     number
  ,p_nth_information14            in     varchar2  default hr_api.g_varchar2
  ,p_customer_id                  in     number    default hr_api.g_number
  ,p_organization_id              in     number    default hr_api.g_number
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 246


  l_proc    varchar2(72) := g_package ||'update_external_learning';

Line: 252


  savepoint update_external_learning_swi;

Line: 273


  ota_nhs_api.update_non_ota_histories
    (p_validate                     => l_validate
    ,p_effective_date               => p_effective_date
    ,p_nota_history_id              => p_nota_history_id
    ,p_person_id                    => p_person_id
    ,p_contact_id                   => p_contact_id
    ,p_trng_title                   => p_trng_title
    ,p_provider                     => p_provider
    ,p_type                         => p_type
    ,p_centre                       => p_centre
    ,p_completion_date              => p_completion_date
    ,p_award                        => p_award
    ,p_rating                       => p_rating
    ,p_duration                     => p_duration
    ,p_duration_units               => p_duration_units
    ,p_activity_version_id          => p_activity_version_id
    ,p_status                       => p_status
    ,p_verified_by_id               => p_verified_by_id
    ,p_nth_information_category     => p_nth_information_category
    ,p_nth_information1             => p_nth_information1
    ,p_nth_information2             => p_nth_information2
    ,p_nth_information3             => p_nth_information3
    ,p_nth_information4             => p_nth_information4
    ,p_nth_information5             => p_nth_information5
    ,p_nth_information6             => p_nth_information6
    ,p_nth_information7             => p_nth_information7
    ,p_nth_information8             => p_nth_information8
    ,p_nth_information9             => p_nth_information9
    ,p_nth_information10            => p_nth_information10
    ,p_nth_information11            => p_nth_information11
    ,p_nth_information12            => p_nth_information12
    ,p_nth_information13            => p_nth_information13
    ,p_nth_information15            => p_nth_information15
    ,p_nth_information16            => p_nth_information16
    ,p_nth_information17            => p_nth_information17
    ,p_nth_information18            => p_nth_information18
    ,p_nth_information19            => p_nth_information19
    ,p_nth_information20            => p_nth_information20
    ,p_org_id                       => p_org_id
    ,p_object_version_number        => p_object_version_number
    ,p_business_group_id            => p_business_group_id
    ,p_nth_information14            => p_nth_information14
    ,p_customer_id                  => p_customer_id
    ,p_organization_id              => p_organization_id
    ,p_some_warning                 => l_some_warning
    );

Line: 340


    rollback to update_external_learning_swi;

Line: 355


    rollback to update_external_learning_swi;

Line: 366


end update_external_learning;

Line: 370


PROCEDURE delete_external_learning
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_nota_history_id              in     number
  ,p_object_version_number        in     number
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 383


  l_proc    varchar2(72) := g_package ||'delete_external_learning';

Line: 389


  savepoint delete_external_learning_swi;

Line: 409


  ota_nhs_api.delete_external_learning
    (p_validate                     => l_validate
    ,p_nota_history_id              => p_nota_history_id
    ,p_object_version_number        => p_object_version_number
    );

Line: 436


    rollback to delete_external_learning_swi;

Line: 450


    rollback to delete_external_learning_swi;

Line: 460


end delete_external_learning;