APPS.OTA_SKILL_PROVISION_SWI SQL Statements

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

Line: 161

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

Line: 174

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

Line: 180

  savepoint delete_skill_provision_swi;

Line: 200

  ota_skill_provision_api.delete_skill_provision
    (p_skill_provision_id           => p_skill_provision_id
    ,p_object_version_number        => p_object_version_number
    ,p_validate                     => l_validate
    );

Line: 227

    rollback to delete_skill_provision_swi;

Line: 241

    rollback to delete_skill_provision_swi;

Line: 251

end delete_skill_provision;

Line: 255

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     number    default hr_api.g_false_num
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 294

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

Line: 300

  savepoint update_skill_provision_swi;

Line: 321

  ota_skill_provision_api.update_skill_provision
    (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
    ,p_validate                     => l_validate
    );

Line: 373

    rollback to update_skill_provision_swi;

Line: 388

    rollback to update_skill_provision_swi;

Line: 399

end update_skill_provision;