APPS.PER_SOLUTION_CMPT_NAME_API SQL Statements

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

Line: 153

procedure update_solution_cmpt_name
  (p_validate                      in     boolean  default false
  ,p_solution_id                   in     number
  ,p_component_name                in     varchar2
  ,p_solution_type_name            in     varchar2
  ,p_name                          in     varchar2   default hr_api.g_varchar2
  ,p_template_file                 in     varchar2
  ,p_object_version_number         in out nocopy number
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc                 varchar2(72) := g_package||'UPDATE_SOLUTION_CMPT_NAME';

Line: 172

  savepoint UPDATE_SOLUTION_CMPT_NAME;

Line: 183

    PER_SOLUTION_CMPT_NAME_BK2.UPDATE_SOLUTION_CMPT_NAME_b
      (p_object_version_number     => p_object_version_number
      ,p_solution_id               => p_solution_id
      ,p_component_name            => p_component_name
      ,p_solution_type_name        => p_solution_type_name
      ,p_name                      => p_name
    );

Line: 193

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

Line: 210

    PER_SOLUTION_CMPT_NAME_BK2.UPDATE_SOLUTION_CMPT_NAME_a
      (p_object_version_number     => p_object_version_number
      ,p_solution_id               => p_solution_id
      ,p_component_name            => p_component_name
      ,p_solution_type_name        => p_solution_type_name
      ,p_name                      => p_name
      );

Line: 220

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

Line: 243

    rollback to UPDATE_SOLUTION_CMPT_NAME;

Line: 254

    rollback to UPDATE_SOLUTION_CMPT_NAME;

Line: 257

end UPDATE_SOLUTION_CMPT_NAME;

Line: 264

procedure delete_solution_cmpt_name
  (p_validate                      in     boolean  default false
  ,p_solution_id                   in     number
  ,p_component_name                in     varchar2
  ,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_CMPT_NAME';

Line: 279

  savepoint DELETE_SOLUTION_CMPT_NAME;

Line: 284

    PER_SOLUTION_CMPT_NAME_BK3.DELETE_SOLUTION_CMPT_NAME_b
    (p_solution_id        => p_solution_id
    ,p_component_name     => p_component_name
    ,p_solution_type_name => p_solution_type_name
    ,p_object_version_number => p_object_version_number
    );

Line: 293

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

Line: 306

    PER_SOLUTION_CMPT_NAME_BK3.DELETE_SOLUTION_CMPT_NAME_a
      (p_solution_id            => p_solution_id
      ,p_component_name         => p_component_name
      ,p_solution_type_name     => p_solution_type_name
      ,p_object_version_number  => p_object_version_number
       );

Line: 315

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

Line: 333

    rollback to DELETE_SOLUTION_CMPT_NAME;

Line: 338

   rollback to DELETE_SOLUTION_CMPT_NAME;

Line: 344

end DELETE_SOLUTION_CMPT_NAME;