eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_VACANCY_API SQL Statements

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

Line: 343


procedure update_vacancy
(
  P_VALIDATE                    in     boolean          default false
, P_EFFECTIVE_DATE              in     date             default null
, P_VACANCY_ID                  in     number
, P_OBJECT_VERSION_NUMBER       in out nocopy number
, P_DATE_FROM                   in     date            default hr_api.g_date
, P_POSITION_ID                 in     number          default hr_api.g_number
, P_JOB_ID                      in     number          default hr_api.g_number
, P_GRADE_ID                    in     number          default hr_api.g_number
, P_ORGANIZATION_ID             in     number          default hr_api.g_number
, P_PEOPLE_GROUP_ID             in     number          default hr_api.g_number
, P_LOCATION_ID                 in     number          default hr_api.g_number
, P_RECRUITER_ID                in     number          default hr_api.g_number
, P_DATE_TO                     in     date            default hr_api.g_date
, P_SECURITY_METHOD             in     varchar2        default hr_api.g_varchar2
, P_DESCRIPTION                 in     varchar2        default hr_api.g_varchar2
, P_NUMBER_OF_OPENINGS          in     number          default hr_api.g_number
, P_STATUS                      in     varchar2        default hr_api.g_varchar2
, P_BUDGET_MEASUREMENT_TYPE     in     varchar2        default hr_api.g_varchar2
, P_BUDGET_MEASUREMENT_VALUE    in     number          default hr_api.g_number
, P_VACANCY_CATEGORY            in     varchar2        default hr_api.g_varchar2
, P_MANAGER_ID                  in     number           default hr_api.g_number
, P_PRIMARY_POSTING_ID          in     number          default hr_api.g_number
, P_ASSESSMENT_ID               in     number          default hr_api.g_number
, P_ATTRIBUTE_CATEGORY          in     varchar2        default hr_api.g_varchar2
, P_ATTRIBUTE1                  in     varchar2        default hr_api.g_varchar2
, P_ATTRIBUTE2                  in     varchar2        default hr_api.g_varchar2
, P_ATTRIBUTE3                  in     varchar2        default hr_api.g_varchar2
, P_ATTRIBUTE4                  in     varchar2        default hr_api.g_varchar2
, P_ATTRIBUTE5                  in     varchar2        default hr_api.g_varchar2
, P_ATTRIBUTE6                  in     varchar2        default hr_api.g_varchar2
, P_ATTRIBUTE7                  in     varchar2        default hr_api.g_varchar2
, P_ATTRIBUTE8                  in     varchar2        default hr_api.g_varchar2
, P_ATTRIBUTE9                  in     varchar2        default hr_api.g_varchar2
, P_ATTRIBUTE10                 in     varchar2        default hr_api.g_varchar2
, P_ATTRIBUTE11                 in     varchar2        default hr_api.g_varchar2
, P_ATTRIBUTE12                 in     varchar2        default hr_api.g_varchar2
, P_ATTRIBUTE13                 in     varchar2        default hr_api.g_varchar2
, P_ATTRIBUTE14                 in     varchar2        default hr_api.g_varchar2
, P_ATTRIBUTE15                 in     varchar2        default hr_api.g_varchar2
, P_ATTRIBUTE16                 in     varchar2        default hr_api.g_varchar2
, P_ATTRIBUTE17                 in     varchar2        default hr_api.g_varchar2
, P_ATTRIBUTE18                 in     varchar2        default hr_api.g_varchar2
, P_ATTRIBUTE19                 in     varchar2        default hr_api.g_varchar2
, P_ATTRIBUTE20                 in     varchar2        default hr_api.g_varchar2
, P_ATTRIBUTE21                 in     varchar2        default hr_api.g_varchar2
, P_ATTRIBUTE22                 in     varchar2        default hr_api.g_varchar2
, P_ATTRIBUTE23                 in     varchar2        default hr_api.g_varchar2
, P_ATTRIBUTE24                 in     varchar2        default hr_api.g_varchar2
, P_ATTRIBUTE25                 in     varchar2        default hr_api.g_varchar2
, P_ATTRIBUTE26                 in     varchar2        default hr_api.g_varchar2
, P_ATTRIBUTE27                 in     varchar2        default hr_api.g_varchar2
, P_ATTRIBUTE28                 in     varchar2        default hr_api.g_varchar2
, P_ATTRIBUTE29                 in     varchar2        default hr_api.g_varchar2
, P_ATTRIBUTE30                 in     varchar2        default hr_api.g_varchar2
, P_ASSIGNMENT_CHANGED             out nocopy boolean
,p_inv_pos_grade_warning           out nocopy boolean
,p_inv_job_grade_warning           out nocopy boolean
)
is
  --
  -- Declare cursors and local variables
  --
  l_proc                        varchar2(72)    := g_package||'update_vacancy';

Line: 429


              select assignment_id,paf.object_version_number
                from per_all_assignments_f paf,
                     per_all_vacancies pav
               where paf.vacancy_id = p_vacancy_id
                 and paf.vacancy_id = pav.vacancy_id
                 and paf.assignment_type = 'A';

Line: 440


  savepoint update_vacancy;

Line: 453


   PER_VACANCY_BK2.update_vacancy_b
   (P_EFFECTIVE_DATE                    => l_effective_date
  , P_VACANCY_ID                        => P_VACANCY_ID
  , P_OBJECT_VERSION_NUMBER             => l_object_version_number
  , P_DATE_FROM                         => l_date_from
  , P_POSITION_ID                       => P_POSITION_ID
  , P_JOB_ID                            => P_JOB_ID
  , P_GRADE_ID                          => P_GRADE_ID
  , P_ORGANIZATION_ID                   => P_ORGANIZATION_ID
  , P_PEOPLE_GROUP_ID                   => P_PEOPLE_GROUP_ID
  , P_LOCATION_ID                       => P_LOCATION_ID
  , P_RECRUITER_ID                      => P_RECRUITER_ID
  , P_DATE_TO                           => l_date_to
  , P_SECURITY_METHOD                   => P_SECURITY_METHOD
  , P_DESCRIPTION                       => P_DESCRIPTION
  , P_NUMBER_OF_OPENINGS                => P_NUMBER_OF_OPENINGS
  , P_STATUS                            => P_STATUS
  , P_BUDGET_MEASUREMENT_TYPE           => P_BUDGET_MEASUREMENT_TYPE
  , P_BUDGET_MEASUREMENT_VALUE          => P_BUDGET_MEASUREMENT_VALUE
  , P_VACANCY_CATEGORY                  => P_VACANCY_CATEGORY
  , P_MANAGER_ID                        => P_MANAGER_ID
  , P_PRIMARY_POSTING_ID                => P_PRIMARY_POSTING_ID
  , P_ASSESSMENT_ID                     => P_ASSESSMENT_ID
  , P_ATTRIBUTE_CATEGORY                => P_ATTRIBUTE_CATEGORY
  , P_ATTRIBUTE1                        => P_ATTRIBUTE1
  , P_ATTRIBUTE2                        => P_ATTRIBUTE2
  , P_ATTRIBUTE3                        => P_ATTRIBUTE3
  , P_ATTRIBUTE4                        => P_ATTRIBUTE4
  , P_ATTRIBUTE5                        => P_ATTRIBUTE5
  , P_ATTRIBUTE6                        => P_ATTRIBUTE6
  , P_ATTRIBUTE7                        => P_ATTRIBUTE7
  , P_ATTRIBUTE8                        => P_ATTRIBUTE8
  , P_ATTRIBUTE9                        => P_ATTRIBUTE9
  , P_ATTRIBUTE10                       => P_ATTRIBUTE10
  , P_ATTRIBUTE11                       => P_ATTRIBUTE11
  , P_ATTRIBUTE12                       => P_ATTRIBUTE12
  , P_ATTRIBUTE13                       => P_ATTRIBUTE13
  , P_ATTRIBUTE14                       => P_ATTRIBUTE14
  , P_ATTRIBUTE15                       => P_ATTRIBUTE15
  , P_ATTRIBUTE16                       => P_ATTRIBUTE16
  , P_ATTRIBUTE17                       => P_ATTRIBUTE17
  , P_ATTRIBUTE18                       => P_ATTRIBUTE18
  , P_ATTRIBUTE19                       => P_ATTRIBUTE19
  , P_ATTRIBUTE20                       => P_ATTRIBUTE20
  , P_ATTRIBUTE21                       => P_ATTRIBUTE21
  , P_ATTRIBUTE22                       => P_ATTRIBUTE22
  , P_ATTRIBUTE23                       => P_ATTRIBUTE23
  , P_ATTRIBUTE24                       => P_ATTRIBUTE24
  , P_ATTRIBUTE25                       => P_ATTRIBUTE25
  , P_ATTRIBUTE26                       => P_ATTRIBUTE26
  , P_ATTRIBUTE27                       => P_ATTRIBUTE27
  , P_ATTRIBUTE28                       => P_ATTRIBUTE28
  , P_ATTRIBUTE29                       => P_ATTRIBUTE29
  , P_ATTRIBUTE30                       => P_ATTRIBUTE30
  );

Line: 511


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

Line: 638


    update per_all_assignments_f asg
    set asg.organization_id = nvl(l_organization_id, asg.organization_id)
    ,asg.job_id          = nvl(l_job_id, asg.job_id)
    ,asg.grade_id        = nvl(l_grade_id, asg.grade_id)
    ,asg.people_group_id = nvl(l_people_group_id, asg.people_group_id)
    ,asg.location_id     = nvl(l_location_id, asg.location_id)
    ,asg.recruiter_id    = nvl(l_recruiter_id, asg.recruiter_id)
    ,asg.supervisor_id   = nvl(l_manager_id, asg.supervisor_id)
    ,asg.position_id     = decode
                        (l_organization_id||'.'||l_job_id,
                         per_vac_shd.g_old_rec.organization_id||'.'||per_vac_shd.g_old_rec.job_id,
                         nvl(l_position_id, asg.position_id),
                          l_position_id)
      where  asg.assignment_type = 'A'
      and    asg.vacancy_id = p_vacancy_id
      and (  asg.organization_id         <> nvl(l_organization_id,asg.organization_id)
         or nvl(asg.job_id,          -1) <> nvl(l_job_id,nvl(asg.job_id, -1))
         or nvl(asg.grade_id,        -1) <> nvl(l_grade_id,nvl(asg.grade_id, -1))
         or nvl(asg.people_group_id, -1) <> nvl(l_people_group_id, nvl(asg.people_group_id, -1))
         or nvl(asg.position_id,     -1) <> nvl(l_position_id,nvl(asg.position_id, -1))
         or nvl(asg.location_id,     -1) <> nvl(l_location_id, nvl(asg.location_id, -1))
         or nvl(asg.recruiter_id,    -1) <> nvl(l_recruiter_id, nvl(asg.recruiter_id, -1))
         or nvl(asg.supervisor_id,   -1) <> nvl(l_manager_id, nvl(asg.supervisor_id, -1))
         );

Line: 670


  PER_VACANCY_BK2.update_vacancy_a(
   P_EFFECTIVE_DATE                     => l_effective_date
  ,P_VACANCY_ID                         => P_VACANCY_ID
  ,P_OBJECT_VERSION_NUMBER              => p_object_version_number
  ,P_DATE_FROM                          => l_date_from
  ,P_POSITION_ID                        => P_POSITION_ID
  ,P_JOB_ID                             => P_JOB_ID
  ,P_GRADE_ID                           => P_GRADE_ID
  ,P_ORGANIZATION_ID                    => P_ORGANIZATION_ID
  ,P_PEOPLE_GROUP_ID                    => P_PEOPLE_GROUP_ID
  ,P_LOCATION_ID                        => P_LOCATION_ID
  ,P_RECRUITER_ID                       => P_RECRUITER_ID
  ,P_DATE_TO                            => l_date_to
  ,P_SECURITY_METHOD                    => P_SECURITY_METHOD
  ,P_DESCRIPTION                        => P_DESCRIPTION
  ,P_NUMBER_OF_OPENINGS                 => P_NUMBER_OF_OPENINGS
  ,P_STATUS                             => P_STATUS
  ,P_BUDGET_MEASUREMENT_TYPE            => P_BUDGET_MEASUREMENT_TYPE
  ,P_BUDGET_MEASUREMENT_VALUE           => P_BUDGET_MEASUREMENT_VALUE
  ,P_VACANCY_CATEGORY                   => P_VACANCY_CATEGORY
  ,P_MANAGER_ID                         => P_MANAGER_ID
  ,P_PRIMARY_POSTING_ID                 => P_PRIMARY_POSTING_ID
  ,P_ASSESSMENT_ID                      => P_ASSESSMENT_ID
  ,P_ATTRIBUTE_CATEGORY                 => P_ATTRIBUTE_CATEGORY
  ,P_ATTRIBUTE1                         => P_ATTRIBUTE1
  ,P_ATTRIBUTE2                         => P_ATTRIBUTE2
  ,P_ATTRIBUTE3                         => P_ATTRIBUTE3
  ,P_ATTRIBUTE4                         => P_ATTRIBUTE4
  ,P_ATTRIBUTE5                         => P_ATTRIBUTE5
  ,P_ATTRIBUTE6                         => P_ATTRIBUTE6
  ,P_ATTRIBUTE7                         => P_ATTRIBUTE7
  ,P_ATTRIBUTE8                         => P_ATTRIBUTE8
  ,P_ATTRIBUTE9                         => P_ATTRIBUTE9
  ,P_ATTRIBUTE10                        => P_ATTRIBUTE10
  ,P_ATTRIBUTE11                        => P_ATTRIBUTE11
  ,P_ATTRIBUTE12                        => P_ATTRIBUTE12
  ,P_ATTRIBUTE13                        => P_ATTRIBUTE13
  ,P_ATTRIBUTE14                        => P_ATTRIBUTE14
  ,P_ATTRIBUTE15                        => P_ATTRIBUTE15
  ,P_ATTRIBUTE16                        => P_ATTRIBUTE16
  ,P_ATTRIBUTE17                        => P_ATTRIBUTE17
  ,P_ATTRIBUTE18                        => P_ATTRIBUTE18
  ,P_ATTRIBUTE19                        => P_ATTRIBUTE19
  ,P_ATTRIBUTE20                        => P_ATTRIBUTE20
  ,P_ATTRIBUTE21                        => P_ATTRIBUTE21
  ,P_ATTRIBUTE22                        => P_ATTRIBUTE22
  ,P_ATTRIBUTE23                        => P_ATTRIBUTE23
  ,P_ATTRIBUTE24                        => P_ATTRIBUTE24
  ,P_ATTRIBUTE25                        => P_ATTRIBUTE25
  ,P_ATTRIBUTE26                        => P_ATTRIBUTE26
  ,P_ATTRIBUTE27                        => P_ATTRIBUTE27
  ,P_ATTRIBUTE28                        => P_ATTRIBUTE28
  ,P_ATTRIBUTE29                        => P_ATTRIBUTE29
  ,P_ATTRIBUTE30                        => P_ATTRIBUTE30
  ,P_ASSIGNMENT_CHANGED                 => l_assignment_changed
  ,p_inv_pos_grade_warning              => l_inv_pos_grade_warning
  ,p_inv_job_grade_warning              => l_inv_job_grade_warning

  );

Line: 732


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

Line: 757


    rollback to update_vacancy;

Line: 775


    rollback to update_vacancy;

Line: 778


end update_vacancy;

Line: 784


procedure delete_vacancy
(
  P_VALIDATE                    in boolean    default false
, P_OBJECT_VERSION_NUMBER       in number
, P_VACANCY_ID                  in number
)
is
  --
  -- Declare cursors and local variables
  --

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

Line: 801


  savepoint delete_vacancy;

Line: 810


  PER_VACANCY_BK3.delete_vacancy_b
   (
    P_OBJECT_VERSION_NUMBER
   ,P_VACANCY_ID
  );

Line: 818


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

Line: 836


    PER_VACANCY_BK3.delete_vacancy_a
     (
      P_OBJECT_VERSION_NUMBER
     ,P_VACANCY_ID
    );

Line: 844


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

Line: 865


    rollback to delete_vacancy;

Line: 876


    rollback to delete_vacancy;

Line: 879


end delete_vacancy;