APPS.PER_SOLUTION_API SQL Statements

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

Line: 143

procedure update_solution
  (p_validate                      in     boolean  default false
  ,p_effective_date                in     date
  ,p_solution_id                   in     number
  ,p_solution_name                 in     varchar2
  ,p_solution_type_name            in     varchar2
  ,p_description                   in     varchar2   default hr_api.g_varchar2
  ,p_link_to_full_description      in     varchar2   default hr_api.g_varchar2
  ,p_vertical                      in     varchar2   default hr_api.g_varchar2
  ,p_legislation_code              in     varchar2   default hr_api.g_varchar2
  ,p_user_id                       in     varchar2   default hr_api.g_varchar2
  ,p_object_version_number         in out nocopy number
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc                  varchar2(72) := g_package||'UPDATE_SOLUTION';

Line: 167

  savepoint UPDATE_SOLUTION;

Line: 180

    PER_SOLUTION_BK2.UPDATE_SOLUTION_b
      (p_effective_date            => l_effective_date
      ,p_solution_id               => p_solution_id
      ,p_object_version_number     => p_object_version_number
      ,p_solution_name             => p_solution_name
      ,p_solution_type_name        => p_solution_type_name
      ,p_description               => p_description
      ,p_link_to_full_description  => p_link_to_full_description
      ,p_vertical                  => p_vertical
      ,p_legislation_code          => p_legislation_code
      ,p_user_id                   => p_user_id
    );

Line: 195

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

Line: 217

    PER_SOLUTION_BK2.UPDATE_SOLUTION_a
      (p_effective_date            => l_effective_date
      ,p_solution_id               => p_solution_id
      ,p_object_version_number     => p_object_version_number
      ,p_solution_name             => p_solution_name
      ,p_solution_type_name        => p_solution_type_name
      ,p_description               => p_description
      ,p_link_to_full_description  => p_link_to_full_description
      ,p_vertical                  => p_vertical
      ,p_legislation_code          => p_legislation_code
      ,p_user_id                   => p_user_id
      );

Line: 232

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

Line: 255

    rollback to UPDATE_SOLUTION;

Line: 266

    rollback to UPDATE_SOLUTION;

Line: 269

end UPDATE_SOLUTION;

Line: 276

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

Line: 289

  savepoint DELETE_SOLUTION;

Line: 294

    PER_SOLUTION_BK3.DELETE_SOLUTION_b
    (p_solution_id              => p_solution_id
    ,p_object_version_number    => p_object_version_number
    );

Line: 301

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

Line: 312

    PER_SOLUTION_BK3.DELETE_SOLUTION_a
      (p_solution_id              => p_solution_id
      ,p_object_version_number    => p_object_version_number
       );

Line: 319

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

Line: 337

    rollback to DELETE_SOLUTION;

Line: 342

   rollback to DELETE_SOLUTION;

Line: 348

end DELETE_SOLUTION;