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_NHS_API SQL Statements

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

Line: 287


procedure update_non_ota_histories
  (p_validate                      in   boolean    default false
  ,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_some_warning                  out nocopy   boolean
  ) is


  l_effective_date   date;

Line: 337


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

Line: 343


  savepoint update_histories;

Line: 354


    OTA_NHS_BK2.update_non_ota_histories_b
  (p_effective_date     => l_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       => l_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
  );

Line: 401


        (p_module_name => 'update_non_ota_histories_b'
        ,p_hook_type   => 'BP'
        );

Line: 465


    OTA_NHS_BK2.update_non_ota_histories_b
  (p_effective_date     => l_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       => l_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
  );

Line: 512


        (p_module_name => 'update_non_ota_histories_a'
        ,p_hook_type   => 'AP'
        );

Line: 536


    rollback to update_histories;

Line: 550


    rollback to update_histories;

Line: 553


end update_non_ota_histories;

Line: 560


procedure delete_external_learning
  (p_validate                      in   boolean    default false
  ,p_nota_history_id                    in number
  ,p_object_version_number              in number
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc                    varchar2(72) := g_package||' delete external learning';

Line: 577


  savepoint delete_external_learning;

Line: 582


  ota_external_learning_bk3.delete_external_learning_b
  (p_nota_history_id            => p_nota_history_id
  ,p_object_version_number       => p_object_version_number
  );

Line: 589


        (p_module_name => 'delete_external_learning_b'
        ,p_hook_type   => 'BP'
        );

Line: 608


  ota_external_learning_bk3.delete_external_learning_a
  (p_nota_history_id            => p_nota_history_id
  ,p_object_version_number       => p_object_version_number
  );

Line: 615


        (p_module_name => 'delete_external_learning_a'
        ,p_hook_type   => 'AP'
        );

Line: 637


    rollback to delete_external_learning;

Line: 648


    rollback to delete_external_learning;

Line: 652


end delete_external_learning;