APPS.PQH_RANK_PROCESS_APPROVAL_API SQL Statements

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

Line: 148

procedure update_rank_process_approval
  (p_validate                      in     boolean  default false
  ,p_effective_date                in     date
  ,p_rank_process_approval_id      in     number
  ,p_rank_process_id               in     number
  ,p_approval_date                 in     date
  ,p_supervisor_id                 in     number  default hr_api.g_number
  ,p_system_rank                   in     number  default hr_api.g_number
  ,p_population_count              in     number  default hr_api.g_number
  ,p_proposed_rank                 in     number  default hr_api.g_number
  ,p_object_version_number         in out nocopy   number
  ) is
  --
  -- Declare cursors and local variables
  --
  l_object_version_number    number;

Line: 165

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

Line: 171

  savepoint UPDATE_RANK_PROCESS_APPROVAL;

Line: 186

    pqh_rank_process_approval_bk2.update_rank_process_approval_b
      (p_effective_date                => l_effective_date
      ,p_rank_process_approval_id      => p_rank_process_approval_id
      ,p_rank_process_id               => p_rank_process_id
      ,p_approval_date                 => p_approval_date
      ,p_supervisor_id                 => p_supervisor_id
      ,p_system_rank                   => p_system_rank
      ,p_population_count              => p_population_count
      ,p_proposed_rank                 => p_proposed_rank
      ,p_object_version_number         => l_object_version_number
      );

Line: 223

    pqh_rank_process_approval_bk2.update_rank_process_approval_a
      (p_effective_date                => l_effective_date
      ,p_rank_process_approval_id      => p_rank_process_approval_id
      ,p_rank_process_id               => p_rank_process_id
      ,p_approval_date                 => p_approval_date
      ,p_supervisor_id                 => p_supervisor_id
      ,p_system_rank                   => p_system_rank
      ,p_population_count              => p_population_count
      ,p_proposed_rank                 => p_proposed_rank
      ,p_object_version_number         => l_object_version_number
      );

Line: 260

    rollback to UPDATE_RANK_PROCESS_APPROVAL;

Line: 272

    rollback to UPDATE_RANK_PROCESS_APPROVAL;

Line: 280

end update_rank_process_approval;

Line: 286

procedure delete_rank_process_approval
  (p_validate                      in     boolean  default false
  ,p_effective_date                in     date
  ,p_rank_process_approval_id      in     number
  ,p_object_version_number         in     number
  ) is
  --
  -- Declare cursors and local variables
  --
  l_effective_date      date;

Line: 296

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

Line: 302

  savepoint DELETE_RANK_PROCESS_APPROVAL;

Line: 313

    pqh_rank_process_approval_bk3.delete_rank_process_approval_b
      (p_effective_date                => l_effective_date
      ,p_rank_process_approval_id      => p_rank_process_approval_id
      ,p_object_version_number         => p_object_version_number
      );

Line: 338

    pqh_rank_process_approval_bk3.delete_rank_process_approval_a
      (p_effective_date                => l_effective_date
      ,p_rank_process_approval_id      => p_rank_process_approval_id
      ,p_object_version_number         => p_object_version_number
      );

Line: 366

    rollback to DELETE_RANK_PROCESS_APPROVAL;

Line: 373

    rollback to DELETE_RANK_PROCESS_APPROVAL;

Line: 377

end delete_rank_process_approval;