APPS.PER_SOLUTION_TYPE_API SQL Statements

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

Line: 17

  ,p_updateable                    in     varchar2   default null
  ,p_object_version_number            out nocopy number
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc                varchar2(72) := g_package||'CREATE_SOLUTION_TYPE';

Line: 50

    ,p_updateable                => p_updateable
    );

Line: 65

    ,p_updateable                => p_updateable
    ,p_object_version_number     => l_object_version_number
  );

Line: 76

      ,p_updateable                => p_updateable
      ,p_object_version_number     => p_object_version_number
      );

Line: 128

procedure update_solution_type
  (p_validate                      in     boolean  default false
  ,p_effective_date                in     date
  ,p_solution_type_name            in     varchar2
  ,p_solution_category             in     varchar2   default hr_api.g_varchar2
  ,p_updateable                    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_TYPE';

Line: 146

  savepoint UPDATE_SOLUTION_TYPE;

Line: 159

    PER_SOLUTION_TYPE_BK2.UPDATE_SOLUTION_TYPE_b
      (p_effective_date            => l_effective_date
      ,p_object_version_number     => p_object_version_number
      ,p_solution_type_name        => p_solution_type_name
      ,p_solution_category         => p_solution_category
      ,p_updateable                => p_updateable
    );

Line: 169

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

Line: 180

      ,p_updateable                => p_updateable
  );

Line: 186

    PER_SOLUTION_TYPE_BK2.UPDATE_SOLUTION_TYPE_a
      (p_effective_date            => l_effective_date
      ,p_object_version_number     => p_object_version_number
      ,p_solution_type_name        => p_solution_type_name
      ,p_solution_category         => p_solution_category
      ,p_updateable                => p_updateable
      );

Line: 196

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

Line: 219

    rollback to UPDATE_SOLUTION_TYPE;

Line: 230

    rollback to UPDATE_SOLUTION_TYPE;

Line: 233

end UPDATE_SOLUTION_TYPE;

Line: 240

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

Line: 253

  savepoint DELETE_SOLUTION_TYPE;

Line: 258

    PER_SOLUTION_TYPE_BK3.DELETE_SOLUTION_TYPE_b
    (p_solution_type_name       => p_solution_type_name
    ,p_object_version_number    => p_object_version_number
    );

Line: 265

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

Line: 276

    PER_SOLUTION_TYPE_BK3.DELETE_SOLUTION_TYPE_a
      (p_solution_type_name       => p_solution_type_name
      ,p_object_version_number    => p_object_version_number
       );

Line: 283

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

Line: 301

    rollback to DELETE_SOLUTION_TYPE;

Line: 306

   rollback to DELETE_SOLUTION_TYPE;

Line: 312

end DELETE_SOLUTION_TYPE;