APPS.HR_KI_OPTION_TYPES_API SQL Statements

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

Line: 151

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

Line: 171

  savepoint update_option_type;

Line: 184

    hr_ki_option_types_bk2.update_option_type_b
      ( p_language_code          => l_language_code
       ,p_display_type           => p_display_type
       ,p_option_name            => p_option_name
       ,p_option_type_id         => p_option_type_id
       ,p_object_version_number  => p_object_version_number

      );

Line: 195

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

Line: 221

    hr_ki_option_types_bk2.update_option_type_a
      (
       p_language_code           =>    l_language_code
      ,p_display_type            =>    p_display_type
      ,p_option_name             =>    p_option_name
      ,p_option_type_id          =>    p_option_type_id
      ,p_object_version_number   =>    p_object_version_number
      );

Line: 232

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

Line: 254

    rollback to update_option_type;

Line: 268

    rollback to update_option_type;

Line: 278

end update_option_type;

Line: 285

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

Line: 301

  savepoint delete_option_type;

Line: 309

    hr_ki_option_types_bk3.delete_option_type_b
      (
       p_option_type_id          => p_option_type_id
       ,p_object_version_number  => p_object_version_number

      );

Line: 318

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

Line: 345

    hr_ki_option_types_bk3.delete_option_type_a
      (
       p_option_type_id          =>    p_option_type_id
      ,p_object_version_number   =>    p_object_version_number
      );

Line: 353

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

Line: 375

    rollback to delete_option_type;

Line: 387

    rollback to delete_option_type;

Line: 394

end delete_option_type;