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

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

Line: 71


  ,p_competency_update_level        in     varchar2  default null
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 169


    ,p_competency_update_level      => p_competency_update_level

    );

Line: 224


PROCEDURE delete_activity_version
  (p_activity_version_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: 237


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

Line: 243


  savepoint delete_activity_version_swi;

Line: 263


  ota_activity_version_api.delete_activity_version
    (p_activity_version_id          => p_activity_version_id
    ,p_object_version_number        => p_object_version_number
    ,p_validate                     => l_validate
    );

Line: 290


    rollback to delete_activity_version_swi;

Line: 304


    rollback to delete_activity_version_swi;

Line: 314


end delete_activity_version;

Line: 318


PROCEDURE update_activity_version
  (p_effective_date               in     date
  ,p_activity_version_id          in     number
  ,p_activity_id                  in     number    default hr_api.g_number
  ,p_superseded_by_act_version_id in     number    default hr_api.g_number
  ,p_developer_organization_id    in     number    default hr_api.g_number
  ,p_controlling_person_id        in     number    default hr_api.g_number
  ,p_object_version_number        in out nocopy number
  ,p_version_name                 in     varchar2  default hr_api.g_varchar2
  ,p_comments                     in     varchar2  default hr_api.g_varchar2
  ,p_description                  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_end_date                     in     date      default hr_api.g_date
  ,p_intended_audience            in     varchar2  default hr_api.g_varchar2
  ,p_language_id                  in     number    default hr_api.g_number
  ,p_maximum_attendees            in     number    default hr_api.g_number
  ,p_minimum_attendees            in     number    default hr_api.g_number
  ,p_objectives                   in     varchar2  default hr_api.g_varchar2
  ,p_start_date                   in     date      default hr_api.g_date
  ,p_success_criteria             in     varchar2  default hr_api.g_varchar2
  ,p_user_status                  in     varchar2  default hr_api.g_varchar2
  ,p_vendor_id                    in     number    default hr_api.g_number
  ,p_actual_cost                  in     number    default hr_api.g_number
  ,p_budget_cost                  in     number    default hr_api.g_number
  ,p_budget_currency_code         in     varchar2  default hr_api.g_varchar2
  ,p_expenses_allowed             in     varchar2  default hr_api.g_varchar2
  ,p_professional_credit_type     in     varchar2  default hr_api.g_varchar2
  ,p_professional_credits         in     number    default hr_api.g_number
  ,p_maximum_internal_attendees   in     number    default hr_api.g_number
  ,p_tav_information_category     in     varchar2  default hr_api.g_varchar2
  ,p_tav_information1             in     varchar2  default hr_api.g_varchar2
  ,p_tav_information2             in     varchar2  default hr_api.g_varchar2
  ,p_tav_information3             in     varchar2  default hr_api.g_varchar2
  ,p_tav_information4             in     varchar2  default hr_api.g_varchar2
  ,p_tav_information5             in     varchar2  default hr_api.g_varchar2
  ,p_tav_information6             in     varchar2  default hr_api.g_varchar2
  ,p_tav_information7             in     varchar2  default hr_api.g_varchar2
  ,p_tav_information8             in     varchar2  default hr_api.g_varchar2
  ,p_tav_information9             in     varchar2  default hr_api.g_varchar2
  ,p_tav_information10            in     varchar2  default hr_api.g_varchar2
  ,p_tav_information11            in     varchar2  default hr_api.g_varchar2
  ,p_tav_information12            in     varchar2  default hr_api.g_varchar2
  ,p_tav_information13            in     varchar2  default hr_api.g_varchar2
  ,p_tav_information14            in     varchar2  default hr_api.g_varchar2
  ,p_tav_information15            in     varchar2  default hr_api.g_varchar2
  ,p_tav_information16            in     varchar2  default hr_api.g_varchar2
  ,p_tav_information17            in     varchar2  default hr_api.g_varchar2
  ,p_tav_information18            in     varchar2  default hr_api.g_varchar2
  ,p_tav_information19            in     varchar2  default hr_api.g_varchar2
  ,p_tav_information20            in     varchar2  default hr_api.g_varchar2
  ,p_inventory_item_id            in     number    default hr_api.g_number
  ,p_organization_id              in     number    default hr_api.g_number
  ,p_rco_id                       in     number    default hr_api.g_number
  ,p_version_code                 in     varchar2  default hr_api.g_varchar2
  ,p_keywords                     in     varchar2  default hr_api.g_varchar2
  ,p_business_group_id            in     number    default hr_api.g_number
  ,p_validate                     in     number    default hr_api.g_false_num
  ,p_return_status                   out nocopy varchar2
  ,p_data_source                  in     varchar2  default hr_api.g_varchar2
  ,p_competency_update_level        in     varchar2  default hr_api.g_varchar2

  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 389


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

Line: 395


  savepoint update_activity_version_swi;

Line: 416


  ota_activity_version_api.update_activity_version
    (p_effective_date               => p_effective_date
    ,p_activity_version_id          => p_activity_version_id
    ,p_activity_id                  => p_activity_id
    ,p_superseded_by_act_version_id => p_superseded_by_act_version_id
    ,p_developer_organization_id    => p_developer_organization_id
    ,p_controlling_person_id        => p_controlling_person_id
    ,p_object_version_number        => p_object_version_number
    ,p_version_name                 => p_version_name
    ,p_comments                     => p_comments
    ,p_description                  => p_description
    ,p_duration                     => p_duration
    ,p_duration_units               => p_duration_units
    ,p_end_date                     => p_end_date
    ,p_intended_audience            => p_intended_audience
    ,p_language_id                  => p_language_id
    ,p_maximum_attendees            => p_maximum_attendees
    ,p_minimum_attendees            => p_minimum_attendees
    ,p_objectives                   => p_objectives
    ,p_start_date                   => p_start_date
    ,p_success_criteria             => p_success_criteria
    ,p_user_status                  => p_user_status
    ,p_vendor_id                    => p_vendor_id
    ,p_actual_cost                  => p_actual_cost
    ,p_budget_cost                  => p_budget_cost
    ,p_budget_currency_code         => p_budget_currency_code
    ,p_expenses_allowed             => p_expenses_allowed
    ,p_professional_credit_type     => p_professional_credit_type
    ,p_professional_credits         => p_professional_credits
    ,p_maximum_internal_attendees   => p_maximum_internal_attendees
    ,p_tav_information_category     => p_tav_information_category
    ,p_tav_information1             => p_tav_information1
    ,p_tav_information2             => p_tav_information2
    ,p_tav_information3             => p_tav_information3
    ,p_tav_information4             => p_tav_information4
    ,p_tav_information5             => p_tav_information5
    ,p_tav_information6             => p_tav_information6
    ,p_tav_information7             => p_tav_information7
    ,p_tav_information8             => p_tav_information8
    ,p_tav_information9             => p_tav_information9
    ,p_tav_information10            => p_tav_information10
    ,p_tav_information11            => p_tav_information11
    ,p_tav_information12            => p_tav_information12
    ,p_tav_information13            => p_tav_information13
    ,p_tav_information14            => p_tav_information14
    ,p_tav_information15            => p_tav_information15
    ,p_tav_information16            => p_tav_information16
    ,p_tav_information17            => p_tav_information17
    ,p_tav_information18            => p_tav_information18
    ,p_tav_information19            => p_tav_information19
    ,p_tav_information20            => p_tav_information20
    ,p_inventory_item_id            => p_inventory_item_id
    ,p_organization_id              => p_organization_id
    ,p_rco_id                       => p_rco_id
    ,p_version_code                 => p_version_code
    ,p_keywords                     => p_keywords
    ,p_business_group_id            => p_business_group_id
    ,p_validate                     => l_validate
    ,p_data_source                  => p_data_source
    ,p_competency_update_level      => p_competency_update_level

    );

Line: 500


    rollback to update_activity_version_swi;

Line: 515


    rollback to update_activity_version_swi;

Line: 526


end update_activity_version;

Line: 530


PROCEDURE validate_delete_act_ver
  (p_activity_version_id          in     number
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for IN/OUT parameters
  --
  -- Other variables
  l_proc    varchar2(72) := g_package ||'validate_delete_act_ver';

Line: 544


  savepoint validate_delete_act_ver_swi;

Line: 589


    rollback to validate_delete_act_ver_swi;

Line: 603


    rollback to validate_delete_act_ver_swi;

Line: 613


end validate_delete_act_ver;