APPS.OTA_ACTIVITY_CATEGORY_API SQL Statements

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

Line: 230

procedure update_act_cat_inclusion
  (p_validate                      in     boolean  default false
  ,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
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc                    varchar2(72) := g_package||' update_act_cat_inclusion ';

Line: 275

  savepoint update_act_cat_inclusion ;

Line: 286

    ota_activity_category_bk2.update_act_cat_inclusion_b
   (p_effective_date             => l_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: 322

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

Line: 368

  OTA_activity_category_bk2.update_act_cat_inclusion_a
   (p_effective_date             => l_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: 403

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

Line: 425

    rollback to update_act_cat_inclusion ;

Line: 437

    rollback to update_act_cat_inclusion ;

Line: 441

end update_act_cat_inclusion ;

Line: 448

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 boolean default false

  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc                    varchar2(72) := g_package||' delete_act_cat_inclusion ';

Line: 465

  savepoint delete_act_cat_inclusion ;

Line: 470

    OTA_activity_category_bk3.delete_act_cat_inclusion_b
    (p_activity_version_id        => p_activity_version_id ,
     p_category_usage_id           => p_category_usage_id,
     p_object_version_number       => p_object_version_number);

Line: 478

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

Line: 496

  OTA_activity_category_bk3.delete_act_cat_inclusion_a
    (p_activity_version_id        => p_activity_version_id ,
     p_category_usage_id           => p_category_usage_id,
     p_object_version_number       => p_object_version_number);

Line: 503

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

Line: 524

    rollback to delete_act_cat_inclusion ;

Line: 535

    rollback to delete_act_cat_inclusion ;

Line: 538

end delete_act_cat_inclusion;