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

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

Line: 210


procedure update_skill_provision
  (
  p_skill_provision_id           in number,
  p_activity_version_id          in number           default hr_api.g_number,
  p_object_version_number        in out nocopy number,
  p_type                         in varchar2         default hr_api.g_varchar2,
  p_comments                     in varchar2         default hr_api.g_varchar2,
  p_tsp_information_category     in varchar2         default hr_api.g_varchar2,
  p_tsp_information1             in varchar2         default hr_api.g_varchar2,
  p_tsp_information2             in varchar2         default hr_api.g_varchar2,
  p_tsp_information3             in varchar2         default hr_api.g_varchar2,
  p_tsp_information4             in varchar2         default hr_api.g_varchar2,
  p_tsp_information5             in varchar2         default hr_api.g_varchar2,
  p_tsp_information6             in varchar2         default hr_api.g_varchar2,
  p_tsp_information7             in varchar2         default hr_api.g_varchar2,
  p_tsp_information8             in varchar2         default hr_api.g_varchar2,
  p_tsp_information9             in varchar2         default hr_api.g_varchar2,
  p_tsp_information10            in varchar2         default hr_api.g_varchar2,
  p_tsp_information11            in varchar2         default hr_api.g_varchar2,
  p_tsp_information12            in varchar2         default hr_api.g_varchar2,
  p_tsp_information13            in varchar2         default hr_api.g_varchar2,
  p_tsp_information14            in varchar2         default hr_api.g_varchar2,
  p_tsp_information15            in varchar2         default hr_api.g_varchar2,
  p_tsp_information16            in varchar2         default hr_api.g_varchar2,
  p_tsp_information17            in varchar2         default hr_api.g_varchar2,
  p_tsp_information18            in varchar2         default hr_api.g_varchar2,
  p_tsp_information19            in varchar2         default hr_api.g_varchar2,
  p_tsp_information20            in varchar2         default hr_api.g_varchar2,
  p_analysis_criteria_id         in number           default hr_api.g_number,
  p_validate                     in boolean      default false
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc                    varchar2(72) := g_package||' Update Skill Provision';

Line: 251


  savepoint UPDATE_SKILL_PROVISION;

Line: 255


    ota_skill_provision_bk2.update_skill_provision_a
  (p_skill_provision_id         => p_skill_provision_id       ,
   p_activity_version_id        => p_activity_version_id      ,
  p_object_version_number      => p_object_version_number    ,
  p_type                       => p_type                     ,
  p_comments                   => p_comments                 ,
  p_tsp_information_category   => p_tsp_information_category ,
  p_tsp_information1           => p_tsp_information1         ,
  p_tsp_information2           => p_tsp_information2         ,
  p_tsp_information3           => p_tsp_information3         ,
  p_tsp_information4           => p_tsp_information4         ,
  p_tsp_information5           => p_tsp_information5         ,
  p_tsp_information6           => p_tsp_information6         ,
  p_tsp_information7           => p_tsp_information7         ,
  p_tsp_information8           => p_tsp_information8         ,
  p_tsp_information9           => p_tsp_information9         ,
  p_tsp_information10          => p_tsp_information10        ,
  p_tsp_information11          => p_tsp_information11        ,
  p_tsp_information12          => p_tsp_information12        ,
  p_tsp_information13          => p_tsp_information13        ,
  p_tsp_information14          => p_tsp_information14        ,
  p_tsp_information15          => p_tsp_information15        ,
  p_tsp_information16          => p_tsp_information16        ,
  p_tsp_information17          => p_tsp_information17        ,
  p_tsp_information18          => p_tsp_information18        ,
  p_tsp_information19          => p_tsp_information19        ,
  p_tsp_information20          => p_tsp_information20        ,
  p_analysis_criteria_id       => p_analysis_criteria_id     );

Line: 286


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

Line: 329


    ota_skill_provision_bk2.update_skill_provision_a
  (p_skill_provision_id         => p_skill_provision_id       ,
   p_activity_version_id        => p_activity_version_id      ,
  p_object_version_number      => l_object_version_number    ,
  p_type                       => p_type                     ,
  p_comments                   => p_comments                 ,
  p_tsp_information_category   => p_tsp_information_category ,
  p_tsp_information1           => p_tsp_information1         ,
  p_tsp_information2           => p_tsp_information2         ,
  p_tsp_information3           => p_tsp_information3         ,
  p_tsp_information4           => p_tsp_information4         ,
  p_tsp_information5           => p_tsp_information5         ,
  p_tsp_information6           => p_tsp_information6         ,
  p_tsp_information7           => p_tsp_information7         ,
  p_tsp_information8           => p_tsp_information8         ,
  p_tsp_information9           => p_tsp_information9         ,
  p_tsp_information10          => p_tsp_information10        ,
  p_tsp_information11          => p_tsp_information11        ,
  p_tsp_information12          => p_tsp_information12        ,
  p_tsp_information13          => p_tsp_information13        ,
  p_tsp_information14          => p_tsp_information14        ,
  p_tsp_information15          => p_tsp_information15        ,
  p_tsp_information16          => p_tsp_information16        ,
  p_tsp_information17          => p_tsp_information17        ,
  p_tsp_information18          => p_tsp_information18        ,
  p_tsp_information19          => p_tsp_information19        ,
  p_tsp_information20          => p_tsp_information20        ,
  p_analysis_criteria_id       => p_analysis_criteria_id     );

Line: 360


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

Line: 381


    rollback to UPDATE_SKILL_PROVISION;

Line: 393


    rollback to UPDATE_SKILL_PROVISION;

Line: 397


end update_skill_provision;

Line: 403


procedure delete_skill_provision
  (
  p_skill_provision_id                in number,
  p_object_version_number              in number,
  p_validate                           in boolean
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc                    varchar2(72) := g_package||' Delete Skill Provision';

Line: 420


  savepoint DELETE_SKILL_PROVISION;

Line: 426


    ota_skill_provision_bk3.delete_skill_provision_b
  (p_skill_provision_id         => p_skill_provision_id       ,
  p_object_version_number    => p_object_version_number
       );

Line: 433


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

Line: 454


    ota_skill_provision_bk3.delete_skill_provision_b
  (p_skill_provision_id         => p_skill_provision_id       ,
  p_object_version_number    => p_object_version_number
       );

Line: 461


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

Line: 479


    rollback to DELETE_SKILL_PROVISION;

Line: 490


    rollback to DELETE_SKILL_PROVISION;

Line: 493


end delete_skill_provision;