APPS.OTA_ACTIVITY_CATEGORY_SWI SQL Statements

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

Line: 169

PROCEDURE delete_act_cat_inclusion
  (p_activity_version_id          in     number
  ,p_category_usage_id            in     varchar2
  ,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: 183

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

Line: 189

  savepoint delete_act_cat_inclusion_swi;

Line: 209

  ota_activity_category_api.delete_act_cat_inclusion
    (p_activity_version_id          => p_activity_version_id
    ,p_category_usage_id            => p_category_usage_id
    ,p_object_version_number        => p_object_version_number
    ,p_validate                     => l_validate
    );

Line: 237

    rollback to delete_act_cat_inclusion_swi;

Line: 251

    rollback to delete_act_cat_inclusion_swi;

Line: 261

end delete_act_cat_inclusion;

Line: 265

PROCEDURE update_act_cat_inclusion
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_effective_date               in     date
  ,p_activity_version_id          in     number
  ,p_activity_category            in     varchar2
  ,p_comments                     in     varchar2  default hr_api.g_varchar2
  ,p_object_version_number        in out nocopy number
  ,p_aci_information_category     in     varchar2  default hr_api.g_varchar2
  ,p_aci_information1             in     varchar2  default hr_api.g_varchar2
  ,p_aci_information2             in     varchar2  default hr_api.g_varchar2
  ,p_aci_information3             in     varchar2  default hr_api.g_varchar2
  ,p_aci_information4             in     varchar2  default hr_api.g_varchar2
  ,p_aci_information5             in     varchar2  default hr_api.g_varchar2
  ,p_aci_information6             in     varchar2  default hr_api.g_varchar2
  ,p_aci_information7             in     varchar2  default hr_api.g_varchar2
  ,p_aci_information8             in     varchar2  default hr_api.g_varchar2
  ,p_aci_information9             in     varchar2  default hr_api.g_varchar2
  ,p_aci_information10            in     varchar2  default hr_api.g_varchar2
  ,p_aci_information11            in     varchar2  default hr_api.g_varchar2
  ,p_aci_information12            in     varchar2  default hr_api.g_varchar2
  ,p_aci_information13            in     varchar2  default hr_api.g_varchar2
  ,p_aci_information14            in     varchar2  default hr_api.g_varchar2
  ,p_aci_information15            in     varchar2  default hr_api.g_varchar2
  ,p_aci_information16            in     varchar2  default hr_api.g_varchar2
  ,p_aci_information17            in     varchar2  default hr_api.g_varchar2
  ,p_aci_information18            in     varchar2  default hr_api.g_varchar2
  ,p_aci_information19            in     varchar2  default hr_api.g_varchar2
  ,p_aci_information20            in     varchar2  default hr_api.g_varchar2
  ,p_start_date_active            in     date      default hr_api.g_date
  ,p_end_date_active              in     date      default hr_api.g_date
  ,p_primary_flag                 in     varchar2  default hr_api.g_varchar2
  ,p_category_usage_id            in     number
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 307

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

Line: 313

  savepoint update_act_cat_inclusion_swi;

Line: 334

  ota_activity_category_api.update_act_cat_inclusion
    (p_validate                     => l_validate
    ,p_effective_date               => p_effective_date
    ,p_activity_version_id          => p_activity_version_id
    ,p_activity_category            => p_activity_category
    ,p_comments                     => p_comments
    ,p_object_version_number        => p_object_version_number
    ,p_aci_information_category     => p_aci_information_category
    ,p_aci_information1             => p_aci_information1
    ,p_aci_information2             => p_aci_information2
    ,p_aci_information3             => p_aci_information3
    ,p_aci_information4             => p_aci_information4
    ,p_aci_information5             => p_aci_information5
    ,p_aci_information6             => p_aci_information6
    ,p_aci_information7             => p_aci_information7
    ,p_aci_information8             => p_aci_information8
    ,p_aci_information9             => p_aci_information9
    ,p_aci_information10            => p_aci_information10
    ,p_aci_information11            => p_aci_information11
    ,p_aci_information12            => p_aci_information12
    ,p_aci_information13            => p_aci_information13
    ,p_aci_information14            => p_aci_information14
    ,p_aci_information15            => p_aci_information15
    ,p_aci_information16            => p_aci_information16
    ,p_aci_information17            => p_aci_information17
    ,p_aci_information18            => p_aci_information18
    ,p_aci_information19            => p_aci_information19
    ,p_aci_information20            => p_aci_information20
    ,p_start_date_active            => p_start_date_active
    ,p_end_date_active              => p_end_date_active
    ,p_primary_flag                 => p_primary_flag
    ,p_category_usage_id            => p_category_usage_id
    );

Line: 389

    rollback to update_act_cat_inclusion_swi;

Line: 404

    rollback to update_act_cat_inclusion_swi;

Line: 415

end update_act_cat_inclusion;

Line: 419

PROCEDURE validate_delete_aci
  (p_activity_version_id          in     number
  ,p_category_usage_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_aci';

Line: 434

  savepoint validate_delete_aci_swi;

Line: 461

    rollback to validate_delete_aci_swi;

Line: 475

    rollback to validate_delete_aci_swi;

Line: 485

end validate_delete_aci;