APPS.IRC_VACANCY_CONSIDERATIONS_API SQL Statements

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

Line: 22

    select first_name
      from per_all_people_f
     where  person_id = p_person_id;

Line: 27

    select ppl.full_name
         , pj.name  job_name
      from per_all_people_f ppl
         , per_all_assignments_f pasg
         , per_jobs pj
     where ppl.person_id = fnd_global.employee_id
       and ppl.person_id = pasg.person_id
       and pasg.primary_flag = 'Y'
       and pasg.job_id = pj.job_id(+)
       and p_effective_date
           between ppl.effective_start_date
               and ppl.effective_end_date
       and p_effective_date
           between pasg.effective_start_date
               and pasg.effective_end_date;

Line: 44

    select pctl.brief_description
         , pctl.job_title
         , pctl.posting_content_id
         , pctl.name
      from per_recruitment_activity_for raf
         , per_recruitment_activities ra
         , irc_posting_contents_tl pctl
     where raf.vacancy_id = p_vacancy_id
       and raf.recruitment_activity_id = ra.recruitment_activity_id
       and ra.posting_content_id = pctl.posting_content_id
       and userenv('LANG') = pctl.language
       and rownum = 1;

Line: 179

    select first_name
      from per_all_people_f
     where  person_id = p_person_id;

Line: 184

    select ppl.full_name
         , pj.name  job_name
      from per_all_people_f ppl
         , per_all_assignments_f pasg
         , per_jobs pj
     where ppl.person_id = fnd_global.employee_id
       and ppl.person_id = pasg.person_id
       and pasg.primary_flag = 'Y'
       and pasg.job_id = pj.job_id(+)
       and p_effective_date
           between ppl.effective_start_date
               and ppl.effective_end_date
       and p_effective_date
           between pasg.effective_start_date
               and pasg.effective_end_date;

Line: 201

    select pctl.brief_description
         , pctl.job_title
         , pctl.posting_content_id
         , pctl.name
      from per_recruitment_activity_for raf
         , per_recruitment_activities ra
         , irc_posting_contents_tl pctl
     where raf.vacancy_id = p_vacancy_id
       and raf.recruitment_activity_id = ra.recruitment_activity_id
       and ra.posting_content_id = pctl.posting_content_id
       and userenv('LANG') = pctl.language
       and rownum = 1;

Line: 343

    select null
      from per_recruitment_activity_for raf
         , per_recruitment_activities ra
         , irc_posting_contents_tl pctl
     where raf.vacancy_id = p_vacancy_id
       and raf.recruitment_activity_id = ra.recruitment_activity_id
       and ra.posting_content_id = pctl.posting_content_id
       and userenv('LANG') = pctl.language
       and rownum = 1;

Line: 524

procedure update_vacancy_consideration
  (p_validate                      in     boolean  default false
  ,p_vacancy_consideration_id      in     number
  ,p_party_id                      in     number   default hr_api.g_number
  ,p_consideration_status          in     varchar2 default hr_api.g_varchar2
  ,p_object_version_number         in out nocopy number
  ,p_effective_date                in     date
  ) is
--
  --
  -- Declare cursors and local variables
  --
  l_proc              varchar2(72) := g_package||
                                           'update_vacancy_consideration';

Line: 543

      Select person_id, vacancy_id
        from irc_vacancy_considerations
       where vacancy_consideration_id = p_vacancy_consideration_id;

Line: 552

  savepoint update_vacancy_consideration;

Line: 561

    IRC_VACANCY_CONSIDERATIONS_BK2.UPDATE_VACANCY_CONSIDERATION_B
    (
     p_vacancy_consideration_id =>   p_vacancy_consideration_id
    ,p_party_id                 =>   p_party_id
    ,p_consideration_status     =>   p_consideration_status
    ,p_object_version_number    =>   l_object_version_number
    ,p_effective_date           =>   l_effective_date
    );

Line: 572

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

Line: 602

    IRC_VACANCY_CONSIDERATIONS_BK2.UPDATE_VACANCY_CONSIDERATION_A
    (p_vacancy_consideration_id => p_vacancy_consideration_id
    ,p_party_id                 => p_party_id
    ,p_consideration_status     => p_consideration_status
    ,p_object_version_number    => l_object_version_number
    ,p_effective_date           => l_effective_date
    );

Line: 612

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

Line: 634

    rollback to UPDATE_VACANCY_CONSIDERATION;

Line: 646

    rollback to UPDATE_VACANCY_CONSIDERATION;

Line: 653

end UPDATE_VACANCY_CONSIDERATION;

Line: 659

procedure delete_vacancy_consideration
  (p_validate                      in     boolean  default false
  ,p_vacancy_consideration_id      in     number
  ,p_object_version_number         in     number
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc                varchar2(72) := g_package||
                                        'delete_vacancy_consideration';

Line: 674

  savepoint delete_vacancy_consideration;

Line: 679

    IRC_VACANCY_CONSIDERATIONS_BK3.DELETE_VACANCY_CONSIDERATION_B
    (p_vacancy_consideration_id      => p_vacancy_consideration_id
    ,p_object_version_number         => p_object_version_number
    );

Line: 686

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

Line: 701

     IRC_VACANCY_CONSIDERATIONS_BK3.DELETE_VACANCY_CONSIDERATION_A
    (
     p_vacancy_consideration_id  => p_vacancy_consideration_id
    ,p_object_version_number     => p_object_version_number
    );

Line: 709

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

Line: 730

    rollback to DELETE_VACANCY_CONSIDERATION;

Line: 741

    rollback to DELETE_VACANCY_CONSIDERATION;

Line: 744

end DELETE_VACANCY_CONSIDERATION;