APPS.IRC_VACANCY_CONSIDERATIONS_API SQL Statements

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

Line: 63

    select first_name
      from per_all_people_f
     where  person_id = p_person_id;

Line: 68

    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: 85

    select substr(pctl.brief_description,1,500)
         , length(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: 217

    select first_name
      from per_all_people_f
     where  person_id = p_person_id;

Line: 222

    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: 239

    select substr(pctl.brief_description,1,500)
         , length(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: 380

    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: 392

      select NLS_LANGUAGE
        from fnd_languages_vl
       where language_code = p_dft_lang;

Line: 397

  select FND_PROFILE.value_specific('ICX_LANGUAGE',usr.user_id)
         from fnd_user usr
         where usr.user_name = p_user_name;

Line: 598

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: 617

      Select person_id, vacancy_id
        from irc_vacancy_considerations
       where vacancy_consideration_id = p_vacancy_consideration_id;

Line: 626

  savepoint update_vacancy_consideration;

Line: 635

    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: 646

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

Line: 676

    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: 686

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

Line: 708

    rollback to UPDATE_VACANCY_CONSIDERATION;

Line: 720

    rollback to UPDATE_VACANCY_CONSIDERATION;

Line: 727

end UPDATE_VACANCY_CONSIDERATION;

Line: 733

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: 748

  savepoint delete_vacancy_consideration;

Line: 753

    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: 760

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

Line: 775

     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: 783

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

Line: 804

    rollback to DELETE_VACANCY_CONSIDERATION;

Line: 815

    rollback to DELETE_VACANCY_CONSIDERATION;

Line: 818

end DELETE_VACANCY_CONSIDERATION;