APPS.HR_KI_TOPICS_API SQL Statements

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

Line: 151

procedure update_topic
  (p_validate                      in     boolean  default false
  ,p_language_code                 in     varchar2 default hr_api.userenv_lang
  ,p_handler                       in     varchar2 default hr_api.g_varchar2
  ,p_name                          in     varchar2 default hr_api.g_varchar2
  ,p_topic_id                      in     number
  ,p_object_version_number         in out nocopy   number
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc                varchar2(72) := g_package||'update_topic';

Line: 171

  savepoint update_topic;

Line: 184

    hr_ki_topics_bk2.update_topic_b
      ( p_language_code          => l_language_code
       ,p_handler                => p_handler
       ,p_name                   => p_name
       ,p_topic_id               => p_topic_id
       ,p_object_version_number  => p_object_version_number

      );

Line: 195

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

Line: 221

    hr_ki_topics_bk2.update_topic_a
      (
       p_language_code           =>    l_language_code
      ,p_handler                 =>    p_handler
      ,p_name                    =>    p_name
      ,p_topic_id                =>    p_topic_id
      ,p_object_version_number   =>    p_object_version_number
      );

Line: 232

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

Line: 253

    rollback to update_topic;

Line: 267

    rollback to update_topic;

Line: 277

end update_topic;

Line: 284

procedure delete_topic
  (
   p_validate                 in boolean	 default false
  ,P_topic_id                 in number
  ,p_object_version_number    in number
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc                varchar2(72) := g_package||'delete_topic';

Line: 300

  savepoint delete_topic;

Line: 308

    hr_ki_topics_bk3.delete_topic_b
      (
       p_topic_id          => p_topic_id
      ,p_object_version_number  => p_object_version_number

      );

Line: 317

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

Line: 344

    hr_ki_topics_bk3.delete_topic_a
      (
       p_topic_id          =>    p_topic_id
      ,p_object_version_number   =>    p_object_version_number
      );

Line: 352

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

Line: 374

    rollback to delete_topic;

Line: 386

    rollback to delete_topic;

Line: 393

end delete_topic;