APPS.PER_SOLUTIONS_SELECTED_SWI SQL Statements

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

Line: 11

PROCEDURE create_solutions_selected
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_solution_id                  in     number
  ,p_solution_set_name            in     varchar2
  ,p_user_id                      in     number
  ,p_object_version_number           out nocopy number
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 26

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

Line: 32

  savepoint create_solutions_selected_swi;

Line: 52

  per_solutions_selected_api.create_solutions_selected
    (p_validate                     => l_validate
    ,p_solution_id                  => p_solution_id
    ,p_solution_set_name            => p_solution_set_name
    ,p_user_id                      => p_user_id
    ,p_object_version_number        => p_object_version_number
    );

Line: 81

    rollback to create_solutions_selected_swi;

Line: 96

    rollback to create_solutions_selected_swi;

Line: 107

end create_solutions_selected;

Line: 111

PROCEDURE delete_solutions_selected
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_solution_id                  in     number
  ,p_solution_set_name            in     varchar2
  ,p_user_id                      in     number
  ,p_object_version_number        in     number
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 126

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

Line: 132

  savepoint delete_solutions_selected_swi;

Line: 152

  per_solutions_selected_api.delete_solutions_selected
    (p_validate                     => l_validate
    ,p_solution_id                  => p_solution_id
    ,p_solution_set_name            => p_solution_set_name
    ,p_user_id                      => p_user_id
    ,p_object_version_number        => p_object_version_number
    );

Line: 181

    rollback to delete_solutions_selected_swi;

Line: 195

    rollback to delete_solutions_selected_swi;

Line: 205

end delete_solutions_selected;

Line: 209

PROCEDURE update_solutions_selected
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_solution_id                  in     number
  ,p_solution_set_name            in     varchar2
  ,p_user_id                      in     number
  ,p_object_version_number        in out nocopy number
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 225

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

Line: 231

  savepoint update_solutions_selected_swi;

Line: 252

  per_solutions_selected_api.update_solutions_selected
    (p_validate                     => l_validate
    ,p_solution_id                  => p_solution_id
    ,p_solution_set_name            => p_solution_set_name
    ,p_user_id                      => p_user_id
    ,p_object_version_number        => p_object_version_number
    );

Line: 281

    rollback to update_solutions_selected_swi;

Line: 296

    rollback to update_solutions_selected_swi;

Line: 307

end update_solutions_selected;