APPS.PQH_RANK_PROCESS_API SQL Statements

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

Line: 173

procedure update_rank_process
  (p_validate                      in     boolean  default false
  ,p_effective_date                in     date
  ,p_rank_process_id               in     number
  ,p_pgm_id                        in     number default hr_api.g_number
  ,p_pl_id                         in     number default hr_api.g_number
  ,p_oipl_id                       in     number default hr_api.g_number
  ,p_process_cd                    in     varchar2
  ,p_process_date                  in     date
  ,p_benefit_action_id             in     number default hr_api.g_number
  ,p_person_id                     in     number
  ,p_assignment_id                 in     number
  ,p_total_score                   in     number default hr_api.g_number
  ,p_request_id                    in     number default hr_api.g_number
  ,p_business_group_id             in     number default hr_api.g_number
  ,p_object_version_number         in out nocopy number
  ,p_per_in_ler_id                 in     number default hr_api.g_number
  ) is
  --
  -- Declare cursors and local variables
  --
  l_object_version_number    number;

Line: 197

  l_proc constant varchar2(72):= g_package||'update_rank_process';

Line: 203

  savepoint UPDATE_RANK_PROCESS;

Line: 218

    pqh_rank_process_bk2.update_rank_process_b
      (p_effective_date                => l_effective_date
      ,p_rank_process_id               => p_rank_process_id
      ,p_pgm_id                        => p_pgm_id
      ,p_pl_id                         => p_pl_id
      ,p_oipl_id                       => p_oipl_id
      ,p_process_cd                    => p_process_cd
      ,p_process_date                  => p_process_date
      ,p_benefit_action_id             => p_benefit_action_id
      ,p_person_id                     => p_person_id
      ,p_assignment_id                 => p_assignment_id
      ,p_total_score                   => p_total_score
      ,p_request_id                    => p_request_id
      ,p_business_group_id             => p_business_group_id
      ,p_object_version_number         => l_object_version_number
      ,p_per_in_ler_id                 => p_per_in_ler_id
      );

Line: 268

    pqh_rank_process_bk2.update_rank_process_a
      (p_effective_date                => l_effective_date
      ,p_rank_process_id               => p_rank_process_id
      ,p_pgm_id                        => p_pgm_id
      ,p_pl_id                         => p_pl_id
      ,p_oipl_id                       => p_oipl_id
      ,p_process_cd                    => p_process_cd
      ,p_process_date                  => p_process_date
      ,p_benefit_action_id             => p_benefit_action_id
      ,p_person_id                     => p_person_id
      ,p_assignment_id                 => p_assignment_id
      ,p_total_score                   => p_total_score
      ,p_request_id                    => p_request_id
      ,p_business_group_id             => p_business_group_id
      ,p_object_version_number         => l_object_version_number
      ,p_per_in_ler_id                 => p_per_in_ler_id
      );

Line: 311

    rollback to UPDATE_RANK_PROCESS;

Line: 323

    rollback to UPDATE_RANK_PROCESS;

Line: 331

end update_rank_process;

Line: 337

procedure delete_rank_process
  (p_validate                      in     boolean  default false
  ,p_effective_date                in     date
  ,p_rank_process_id               in     number
  ,p_object_version_number         in     number
  ) is
  --
  -- Declare cursors and local variables
  --
  l_object_version_number    number;

Line: 348

  l_proc constant varchar2(72):= g_package||'delete_rank_process';

Line: 354

  savepoint DELETE_RANK_PROCESS;

Line: 365

    pqh_rank_process_bk3.delete_rank_process_b
      (p_effective_date                => l_effective_date
      ,p_rank_process_id               => p_rank_process_id
      ,p_object_version_number         => p_object_version_number
      );

Line: 390

    pqh_rank_process_bk3.delete_rank_process_a
      (p_effective_date                => l_effective_date
      ,p_rank_process_id               => p_rank_process_id
      ,p_object_version_number         => p_object_version_number
      );

Line: 418

    rollback to DELETE_RANK_PROCESS;

Line: 425

    rollback to DELETE_RANK_PROCESS;

Line: 429

end delete_rank_process;