APPS.PQH_FR_GLOBAL_PAYSCALE_SWI SQL Statements

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

Line: 243

PROCEDURE delete_global_index
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_effective_date               in     date
  ,p_datetrack_mode               in     varchar2
  ,p_global_index_id              in     number
  ,p_object_version_number        in out nocopy number
  ,p_effective_start_date            out nocopy date
  ,p_effective_end_date              out nocopy date
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 261

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

Line: 267

  savepoint delete_global_index_swi;

Line: 288

  pqh_fr_global_payscale_api.delete_global_index
    (p_validate                     => l_validate
    ,p_effective_date               => p_effective_date
    ,p_datetrack_mode               => p_datetrack_mode
    ,p_global_index_id              => p_global_index_id
    ,p_object_version_number        => p_object_version_number
    ,p_effective_start_date         => p_effective_start_date
    ,p_effective_end_date           => p_effective_end_date
    );

Line: 319

    rollback to delete_global_index_swi;

Line: 336

    rollback to delete_global_index_swi;

Line: 349

end delete_global_index;

Line: 353

PROCEDURE delete_indemnity_rate
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_effective_date               in     date
  ,p_datetrack_mode               in     varchar2
  ,p_global_index_id              in     number
  ,p_object_version_number        in out nocopy number
  ,p_effective_start_date            out nocopy date
  ,p_effective_end_date              out nocopy date
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 371

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

Line: 377

  savepoint delete_indemnity_rate_swi;

Line: 398

  pqh_fr_global_payscale_api.delete_indemnity_rate
    (p_validate                     => l_validate
    ,p_effective_date               => p_effective_date
    ,p_datetrack_mode               => p_datetrack_mode
    ,p_global_index_id              => p_global_index_id
    ,p_object_version_number        => p_object_version_number
    ,p_effective_start_date         => p_effective_start_date
    ,p_effective_end_date           => p_effective_end_date
    );

Line: 429

    rollback to delete_indemnity_rate_swi;

Line: 446

    rollback to delete_indemnity_rate_swi;

Line: 459

end delete_indemnity_rate;

Line: 463

PROCEDURE update_global_index
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_effective_date               in     date
  ,p_datetrack_mode               in     varchar2
  ,p_global_index_id              in     number
  ,p_object_version_number        in out nocopy number
  ,p_gross_index                  in     number    default hr_api.g_number
  ,p_increased_index              in     number    default hr_api.g_number
  ,p_effective_start_date            out nocopy date
  ,p_effective_end_date              out nocopy date
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 483

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

Line: 489

  savepoint update_global_index_swi;

Line: 510

  pqh_fr_global_payscale_api.update_global_index
    (p_validate                     => l_validate
    ,p_effective_date               => p_effective_date
    ,p_datetrack_mode               => p_datetrack_mode
    ,p_global_index_id              => p_global_index_id
    ,p_object_version_number        => p_object_version_number
    ,p_gross_index                  => p_gross_index
    ,p_increased_index              => p_increased_index
    ,p_effective_start_date         => p_effective_start_date
    ,p_effective_end_date           => p_effective_end_date
    );

Line: 543

    rollback to update_global_index_swi;

Line: 560

    rollback to update_global_index_swi;

Line: 573

end update_global_index;

Line: 577

PROCEDURE update_indemnity_rate
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_effective_date               in     date
  ,p_datetrack_mode               in     varchar2
  ,p_global_index_id              in     number
  ,p_object_version_number        in out nocopy number
  ,p_basic_salary_rate            in     number    default hr_api.g_number
  ,p_housing_indemnity_rate            in     number    default hr_api.g_number
  ,p_currency_code                in     varchar2
  ,p_effective_start_date            out nocopy date
  ,p_effective_end_date              out nocopy date
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 598

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

Line: 604

  savepoint update_indemnity_rate_swi;

Line: 626

  pqh_fr_global_payscale_api.update_indemnity_rate
    (p_validate                     => l_validate
    ,p_effective_date               => p_effective_date
    ,p_datetrack_mode               => p_datetrack_mode
    ,p_global_index_id              => p_global_index_id
    ,p_object_version_number        => p_object_version_number
    ,p_basic_salary_rate            => p_basic_salary_rate
    ,p_housing_indemnity_rate            => p_housing_indemnity_rate
    ,p_currency_code                => p_currency_code
    ,p_effective_start_date         => p_effective_start_date
    ,p_effective_end_date           => p_effective_end_date
    );

Line: 660

    rollback to update_indemnity_rate_swi;

Line: 677

    rollback to update_indemnity_rate_swi;

Line: 690

end update_indemnity_rate;