APPS.PER_SOLUTION_TYPE_CMPT_API SQL Statements

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

Line: 20

  ,p_updateable                    in     varchar2  default null
  ,p_extensible                    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_CMPT';

Line: 61

    ,p_updateable                => p_updateable
    ,p_extensible                => p_extensible
    );

Line: 80

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

Line: 95

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

Line: 148

procedure update_solution_type_cmpt
  (p_validate                      in     boolean  default false
  ,p_effective_date                in     date
  ,p_component_name                in     varchar2
  ,p_solution_type_name            in     varchar2
  ,p_legislation_code              in     varchar2
  ,p_api_name                      in     varchar2  default hr_api.g_varchar2
  ,p_parent_component_name         in     varchar2  default hr_api.g_varchar2
  ,p_updateable                    in     varchar2  default hr_api.g_varchar2
  ,p_extensible                    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_CMPT';

Line: 170

  savepoint UPDATE_SOLUTION_TYPE_CMPT;

Line: 183

    PER_SOLUTION_TYPE_CMPT_BK2.UPDATE_SOLUTION_TYPE_CMPT_b
      (p_effective_date            => l_effective_date
      ,p_object_version_number     => p_object_version_number
      ,p_component_name            => p_component_name
      ,p_solution_type_name        => p_solution_type_name
      ,p_legislation_code          => p_legislation_code
      ,p_api_name                  => p_api_name
      ,p_parent_component_name     => p_parent_component_name
      ,p_updateable                => p_updateable
      ,p_extensible                => p_extensible
    );

Line: 197

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

Line: 211

      ,p_updateable                => p_updateable
      ,p_extensible                => p_extensible
  );

Line: 218

    PER_SOLUTION_TYPE_CMPT_BK2.UPDATE_SOLUTION_TYPE_CMPT_a
      (p_effective_date            => l_effective_date
      ,p_object_version_number     => p_object_version_number
      ,p_component_name            => p_component_name
      ,p_solution_type_name        => p_solution_type_name
      ,p_legislation_code          => p_legislation_code
      ,p_api_name                  => p_api_name
      ,p_parent_component_name     => p_parent_component_name
      ,p_updateable                => p_updateable
      ,p_extensible                => p_extensible
      );

Line: 232

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

Line: 255

    rollback to UPDATE_SOLUTION_TYPE_CMPT;

Line: 266

    rollback to UPDATE_SOLUTION_TYPE_CMPT;

Line: 269

end UPDATE_SOLUTION_TYPE_CMPT;

Line: 276

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

Line: 291

  savepoint DELETE_SOLUTION_TYPE_CMPT;

Line: 296

    PER_SOLUTION_TYPE_CMPT_BK3.DELETE_SOLUTION_TYPE_CMPT_b
    (p_component_name           => p_component_name
    ,p_solution_type_name       => p_solution_type_name
    ,p_legislation_code         => p_legislation_code
    ,p_object_version_number    => p_object_version_number
    );

Line: 305

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

Line: 318

    PER_SOLUTION_TYPE_CMPT_BK3.DELETE_SOLUTION_TYPE_CMPT_a
      (p_component_name           => p_component_name
      ,p_solution_type_name       => p_solution_type_name
      ,p_legislation_code         => p_legislation_code
      ,p_object_version_number    => p_object_version_number
       );

Line: 327

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

Line: 345

    rollback to DELETE_SOLUTION_TYPE_CMPT;

Line: 350

   rollback to DELETE_SOLUTION_TYPE_CMPT;

Line: 356

end DELETE_SOLUTION_TYPE_CMPT;