APPS.HR_ELC_RESULT_API SQL Statements

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

Line: 45

     select job_group_id
     from per_jobs
     where job_id = p_job_id;

Line: 84

 hr_elc_candidate_api.update_election_candidate
     (p_election_candidate_id         => p_election_candidate_id
     ,p_object_version_number         => l_ovn_election_candidates
     ,p_business_group_id             => p_business_group_id
     ,p_person_id                     => p_person_id
     ,p_election_id                   => p_election_id
     ,p_rank                          => p_rank
     ,p_role_id                       => l_role_id);

Line: 143

procedure update_election_result
  (p_validate                      in     boolean  default false
  ,p_effective_date                in     date
  ,p_role_id                       in     number
  ,p_ovn_per_roles                 in out nocopy number
  ,p_job_id                        in     number   default hr_api.g_number
  ,p_person_id                     in     number   default hr_api.g_number
  ,p_start_date                    in     date     default hr_api.g_date
  ,p_end_date                      in     date     default hr_api.g_date
  ,p_primary_contact_flag          in     varchar2 default hr_api.g_varchar2
  ,p_election_candidate_id         in     number   default hr_api.g_number
  ,p_business_group_id             in     number   default hr_api.g_number
  ,p_election_id                   in     number   default hr_api.g_number
  ,p_ovn_election_candidates       in out nocopy number
  ,p_rank                          in     number   default hr_api.g_number
  ) is

  --
  -- Declare cursors and local variables
  --

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

Line: 174

     select job_group_id
     from per_jobs
     where job_id = p_job_id;

Line: 183

  savepoint update_election_result;

Line: 201

  per_supplementary_role_api.update_supplementary_role
      (p_effective_date                => l_effective_date
      ,p_role_id                       => p_role_id
      ,p_object_version_number         => l_ovn_per_roles
      ,p_start_date                    => l_start_date
      ,p_end_date                      => l_end_date
      ,p_primary_contact_flag          => p_primary_contact_flag);

Line: 213

 hr_elc_candidate_api.update_election_candidate
     (p_election_candidate_id         => p_election_candidate_id
     ,p_object_version_number        => l_ovn_election_candidates
     ,p_business_group_id             => p_business_group_id
     ,p_election_id                   => p_election_id
     ,p_person_id                     => p_person_id
     ,p_rank                          => p_rank
     ,p_role_id                       => p_role_id);

Line: 233

    rollback to update_election_result;

Line: 256

end update_election_result;