APPS.PER_SOLUTIONS_SELECTED_API SQL Statements

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

Line: 12

procedure create_solutions_selected
  (p_validate                      in     boolean  default false
  ,p_solution_id                   in     number
  ,p_solution_set_name             in     varchar2
  ,p_user_id                       in     number
  ,p_object_version_number            out nocopy number
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc                varchar2(72) := g_package||'CREATE_SOLUTIONS_SELECTED';

Line: 24

  l_solution_id         PER_SOLUTIONS_SELECTED.SOLUTION_ID%TYPE;

Line: 25

  l_solution_set_name   PER_SOLUTIONS_SELECTED.SOLUTION_SET_NAME%TYPE;

Line: 26

  l_user_id             PER_SOLUTIONS_SELECTED.USER_ID%TYPE;

Line: 27

  l_object_version_number PER_SOLUTIONS_SELECTED.OBJECT_VERSION_NUMBER%TYPE;

Line: 32

  savepoint CREATE_SOLUTIONS_SELECTED;

Line: 47

    PER_SOLUTIONS_SELECTED_BK1.CREATE_SOLUTIONS_SELECTED_b
    (p_solution_id               => p_solution_id
    ,p_solution_set_name         => p_solution_set_name
    ,p_user_id                   => p_user_id
    );

Line: 55

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

Line: 71

    PER_SOLUTIONS_SELECTED_BK1.CREATE_SOLUTIONS_SELECTED_a
      (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: 80

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

Line: 102

    rollback to CREATE_SOLUTIONS_SELECTED;

Line: 115

    rollback to CREATE_SOLUTIONS_SELECTED;

Line: 118

end CREATE_SOLUTIONS_SELECTED;

Line: 126

procedure update_solutions_selected
  (p_validate                      in     boolean  default false
  ,p_solution_id                   in     number
  ,p_solution_set_name             in     varchar2
  ,p_user_id                       in     number
  ,p_object_version_number         in out nocopy number
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc                  varchar2(72) := g_package||'UPDATE_SOLUTIONS_SELECTED';

Line: 138

  l_object_version_number PER_SOLUTIONS_SELECTED.OBJECT_VERSION_NUMBER%TYPE;

Line: 143

  savepoint UPDATE_SOLUTIONS_SELECTED;

Line: 154

    PER_SOLUTIONS_SELECTED_BK2.UPDATE_SOLUTIONS_SELECTED_b
      (p_object_version_number     => p_object_version_number
      ,p_solution_id               => p_solution_id
      ,p_solution_set_name         => p_solution_set_name
      ,p_user_id                   => p_user_id
    );

Line: 163

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

Line: 179

    PER_SOLUTIONS_SELECTED_BK2.UPDATE_SOLUTIONS_SELECTED_a
      (p_object_version_number     => p_object_version_number
      ,p_solution_id               => p_solution_id
      ,p_solution_set_name         => p_solution_set_name
      ,p_user_id                   => p_user_id
      );

Line: 188

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

Line: 211

    rollback to UPDATE_SOLUTIONS_SELECTED;

Line: 222

    rollback to UPDATE_SOLUTIONS_SELECTED;

Line: 225

end UPDATE_SOLUTIONS_SELECTED;

Line: 232

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

Line: 247

  savepoint DELETE_SOLUTIONS_SELECTED;

Line: 252

    PER_SOLUTIONS_SELECTED_BK3.DELETE_SOLUTIONS_SELECTED_b
    (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: 261

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

Line: 274

    PER_SOLUTIONS_SELECTED_BK3.DELETE_SOLUTIONS_SELECTED_a
      (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: 283

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

Line: 301

    rollback to DELETE_SOLUTIONS_SELECTED;

Line: 306

   rollback to DELETE_SOLUTIONS_SELECTED;

Line: 312

end DELETE_SOLUTIONS_SELECTED;