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.IRC_POSTING_CONTENT_API SQL Statements

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

Line: 20


    select oracle_username
      from fnd_oracle_userid
     where oracle_id = 800;

Line: 485


procedure update_posting_content
(
 P_VALIDATE                   in boolean  default false
,P_POSTING_CONTENT_ID         in number
,P_DISPLAY_MANAGER_INFO       in varchar2 default hr_api.g_varchar2
,P_DISPLAY_RECRUITER_INFO     in varchar2 default hr_api.g_varchar2
,P_LANGUAGE_CODE              in varchar2 default hr_api.userenv_lang
,P_NAME                       in varchar2 default hr_api.g_varchar2
,P_ORG_NAME                   in varchar2 default hr_api.g_varchar2
,P_ORG_DESCRIPTION            in varchar2 default hr_api.g_varchar2
,P_JOB_TITLE                  in varchar2 default hr_api.g_varchar2
,P_BRIEF_DESCRIPTION          in varchar2 default hr_api.g_varchar2
,P_DETAILED_DESCRIPTION       in varchar2 default hr_api.g_varchar2
,P_JOB_REQUIREMENTS           in varchar2 default hr_api.g_varchar2
,P_ADDITIONAL_DETAILS         in varchar2 default hr_api.g_varchar2
,P_HOW_TO_APPLY               in varchar2 default hr_api.g_varchar2
,P_BENEFIT_INFO               in varchar2 default hr_api.g_varchar2
,P_IMAGE_URL                  in varchar2 default hr_api.g_varchar2
,P_ALT_IMAGE_URL              in varchar2 default hr_api.g_varchar2
,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_IPC_INFORMATION_CATEGORY   in varchar2 default hr_api.g_varchar2
,P_IPC_INFORMATION1           in varchar2 default hr_api.g_varchar2
,P_IPC_INFORMATION2           in varchar2 default hr_api.g_varchar2
,P_IPC_INFORMATION3           in varchar2 default hr_api.g_varchar2
,P_IPC_INFORMATION4           in varchar2 default hr_api.g_varchar2
,P_IPC_INFORMATION5           in varchar2 default hr_api.g_varchar2
,P_IPC_INFORMATION6           in varchar2 default hr_api.g_varchar2
,P_IPC_INFORMATION7           in varchar2 default hr_api.g_varchar2
,P_IPC_INFORMATION8           in varchar2 default hr_api.g_varchar2
,P_IPC_INFORMATION9           in varchar2 default hr_api.g_varchar2
,P_IPC_INFORMATION10          in varchar2 default hr_api.g_varchar2
,P_IPC_INFORMATION11          in varchar2 default hr_api.g_varchar2
,P_IPC_INFORMATION12          in varchar2 default hr_api.g_varchar2
,P_IPC_INFORMATION13          in varchar2 default hr_api.g_varchar2
,P_IPC_INFORMATION14          in varchar2 default hr_api.g_varchar2
,P_IPC_INFORMATION15          in varchar2 default hr_api.g_varchar2
,P_IPC_INFORMATION16          in varchar2 default hr_api.g_varchar2
,P_IPC_INFORMATION17          in varchar2 default hr_api.g_varchar2
,P_IPC_INFORMATION18          in varchar2 default hr_api.g_varchar2
,P_IPC_INFORMATION19          in varchar2 default hr_api.g_varchar2
,P_IPC_INFORMATION20          in varchar2 default hr_api.g_varchar2
,P_IPC_INFORMATION21          in varchar2 default hr_api.g_varchar2
,P_IPC_INFORMATION22          in varchar2 default hr_api.g_varchar2
,P_IPC_INFORMATION23          in varchar2 default hr_api.g_varchar2
,P_IPC_INFORMATION24          in varchar2 default hr_api.g_varchar2
,P_IPC_INFORMATION25          in varchar2 default hr_api.g_varchar2
,P_IPC_INFORMATION26          in varchar2 default hr_api.g_varchar2
,P_IPC_INFORMATION27          in varchar2 default hr_api.g_varchar2
,P_IPC_INFORMATION28          in varchar2 default hr_api.g_varchar2
,P_IPC_INFORMATION29          in varchar2 default hr_api.g_varchar2
,P_IPC_INFORMATION30          in varchar2 default hr_api.g_varchar2
,P_DATE_APPROVED              in date     default hr_api.g_date
,P_OBJECT_VERSION_NUMBER      in out nocopy number
)
is
  --
  -- Declare cursors and local variables
  --
  l_proc varchar2(72)    := g_package||'update_posting_content';

Line: 582


  savepoint update_posting_content;

Line: 591


  IRC_POSTING_CONTENT_BK2.update_posting_content_b
  (
   P_POSTING_CONTENT_ID       => P_POSTING_CONTENT_ID
  ,P_DISPLAY_MANAGER_INFO     => P_DISPLAY_MANAGER_INFO
  ,P_DISPLAY_RECRUITER_INFO   => P_DISPLAY_RECRUITER_INFO
  ,P_LANGUAGE_CODE            => l_language_code
  ,P_NAME                     => P_NAME
  ,P_ORG_NAME                 => P_ORG_NAME
  ,P_ORG_DESCRIPTION          => P_ORG_DESCRIPTION
  ,P_JOB_TITLE                => P_JOB_TITLE
  ,P_BRIEF_DESCRIPTION        => P_BRIEF_DESCRIPTION
  ,P_DETAILED_DESCRIPTION     => P_DETAILED_DESCRIPTION
  ,P_JOB_REQUIREMENTS         => P_JOB_REQUIREMENTS
  ,P_ADDITIONAL_DETAILS       => P_ADDITIONAL_DETAILS
  ,P_HOW_TO_APPLY             => P_HOW_TO_APPLY
  ,P_BENEFIT_INFO             => P_BENEFIT_INFO
  ,P_IMAGE_URL                => P_IMAGE_URL
  ,P_ALT_IMAGE_URL            => P_ALT_IMAGE_URL
  ,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_IPC_INFORMATION_CATEGORY => P_IPC_INFORMATION_CATEGORY
  ,P_IPC_INFORMATION1         => P_IPC_INFORMATION1
  ,P_IPC_INFORMATION2         => P_IPC_INFORMATION2
  ,P_IPC_INFORMATION3         => P_IPC_INFORMATION3
  ,P_IPC_INFORMATION4         => P_IPC_INFORMATION4
  ,P_IPC_INFORMATION5         => P_IPC_INFORMATION5
  ,P_IPC_INFORMATION6         => P_IPC_INFORMATION6
  ,P_IPC_INFORMATION7         => P_IPC_INFORMATION7
  ,P_IPC_INFORMATION8         => P_IPC_INFORMATION8
  ,P_IPC_INFORMATION9         => P_IPC_INFORMATION9
  ,P_IPC_INFORMATION10        => P_IPC_INFORMATION10
  ,P_IPC_INFORMATION11        => P_IPC_INFORMATION11
  ,P_IPC_INFORMATION12        => P_IPC_INFORMATION12
  ,P_IPC_INFORMATION13        => P_IPC_INFORMATION13
  ,P_IPC_INFORMATION14        => P_IPC_INFORMATION14
  ,P_IPC_INFORMATION15        => P_IPC_INFORMATION15
  ,P_IPC_INFORMATION16        => P_IPC_INFORMATION16
  ,P_IPC_INFORMATION17        => P_IPC_INFORMATION17
  ,P_IPC_INFORMATION18        => P_IPC_INFORMATION18
  ,P_IPC_INFORMATION19        => P_IPC_INFORMATION19
  ,P_IPC_INFORMATION20        => P_IPC_INFORMATION20
  ,P_IPC_INFORMATION21        => P_IPC_INFORMATION21
  ,P_IPC_INFORMATION22        => P_IPC_INFORMATION22
  ,P_IPC_INFORMATION23        => P_IPC_INFORMATION23
  ,P_IPC_INFORMATION24        => P_IPC_INFORMATION24
  ,P_IPC_INFORMATION25        => P_IPC_INFORMATION25
  ,P_IPC_INFORMATION26        => P_IPC_INFORMATION26
  ,P_IPC_INFORMATION27        => P_IPC_INFORMATION27
  ,P_IPC_INFORMATION28        => P_IPC_INFORMATION28
  ,P_IPC_INFORMATION29        => P_IPC_INFORMATION29
  ,P_IPC_INFORMATION30        => P_IPC_INFORMATION30
  ,P_DATE_APPROVED            => l_date_approved
  ,P_OBJECT_VERSION_NUMBER    => l_object_version_number
  );

Line: 677


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

Line: 776


   IRC_POSTING_CONTENT_BK2.update_posting_content_a
     (
      P_POSTING_CONTENT_ID       => P_POSTING_CONTENT_ID
     ,P_DISPLAY_MANAGER_INFO     => P_DISPLAY_MANAGER_INFO
     ,P_DISPLAY_RECRUITER_INFO   => P_DISPLAY_RECRUITER_INFO
     ,P_LANGUAGE_CODE            => l_language_code
     ,P_NAME                     => P_NAME
     ,P_ORG_NAME                 => P_ORG_NAME
     ,P_ORG_DESCRIPTION          => P_ORG_DESCRIPTION
     ,P_JOB_TITLE                => P_JOB_TITLE
     ,P_BRIEF_DESCRIPTION        => P_BRIEF_DESCRIPTION
     ,P_DETAILED_DESCRIPTION     => P_DETAILED_DESCRIPTION
     ,P_JOB_REQUIREMENTS         => P_JOB_REQUIREMENTS
     ,P_ADDITIONAL_DETAILS       => P_ADDITIONAL_DETAILS
     ,P_HOW_TO_APPLY             => P_HOW_TO_APPLY
     ,P_BENEFIT_INFO             => P_BENEFIT_INFO
     ,P_IMAGE_URL                => P_IMAGE_URL
     ,P_ALT_IMAGE_URL            => P_ALT_IMAGE_URL
     ,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_IPC_INFORMATION_CATEGORY => P_IPC_INFORMATION_CATEGORY
     ,P_IPC_INFORMATION1         => P_IPC_INFORMATION1
     ,P_IPC_INFORMATION2         => P_IPC_INFORMATION2
     ,P_IPC_INFORMATION3         => P_IPC_INFORMATION3
     ,P_IPC_INFORMATION4         => P_IPC_INFORMATION4
     ,P_IPC_INFORMATION5         => P_IPC_INFORMATION5
     ,P_IPC_INFORMATION6         => P_IPC_INFORMATION6
     ,P_IPC_INFORMATION7         => P_IPC_INFORMATION7
     ,P_IPC_INFORMATION8         => P_IPC_INFORMATION8
     ,P_IPC_INFORMATION9         => P_IPC_INFORMATION9
     ,P_IPC_INFORMATION10        => P_IPC_INFORMATION10
     ,P_IPC_INFORMATION11        => P_IPC_INFORMATION11
     ,P_IPC_INFORMATION12        => P_IPC_INFORMATION12
     ,P_IPC_INFORMATION13        => P_IPC_INFORMATION13
     ,P_IPC_INFORMATION14        => P_IPC_INFORMATION14
     ,P_IPC_INFORMATION15        => P_IPC_INFORMATION15
     ,P_IPC_INFORMATION16        => P_IPC_INFORMATION16
     ,P_IPC_INFORMATION17        => P_IPC_INFORMATION17
     ,P_IPC_INFORMATION18        => P_IPC_INFORMATION18
     ,P_IPC_INFORMATION19        => P_IPC_INFORMATION19
     ,P_IPC_INFORMATION20        => P_IPC_INFORMATION20
     ,P_IPC_INFORMATION21        => P_IPC_INFORMATION21
     ,P_IPC_INFORMATION22        => P_IPC_INFORMATION22
     ,P_IPC_INFORMATION23        => P_IPC_INFORMATION23
     ,P_IPC_INFORMATION24        => P_IPC_INFORMATION24
     ,P_IPC_INFORMATION25        => P_IPC_INFORMATION25
     ,P_IPC_INFORMATION26        => P_IPC_INFORMATION26
     ,P_IPC_INFORMATION27        => P_IPC_INFORMATION27
     ,P_IPC_INFORMATION28        => P_IPC_INFORMATION28
     ,P_IPC_INFORMATION29        => P_IPC_INFORMATION29
     ,P_IPC_INFORMATION30        => P_IPC_INFORMATION30
     ,P_DATE_APPROVED            => l_date_approved
     ,P_OBJECT_VERSION_NUMBER    => l_object_version_number
  );

Line: 862


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

Line: 884


    rollback to update_posting_content;

Line: 896


    rollback to update_posting_content;

Line: 901


end update_posting_content;

Line: 907


procedure delete_posting_content
(
 P_VALIDATE                 in boolean	 default false
,P_POSTING_CONTENT_ID       in number
,P_OBJECT_VERSION_NUMBER    in number
)
is
  --
  -- Declare cursors and local variables
  --
  l_proc   varchar2(72)	:= g_package||'delete_posting_content';

Line: 923


  savepoint delete_posting_content;

Line: 930


    IRC_POSTING_CONTENT_BK3.delete_posting_content_b
    (
     P_POSTING_CONTENT_ID    => P_POSTING_CONTENT_ID
    ,P_OBJECT_VERSION_NUMBER => P_OBJECT_VERSION_NUMBER
    );

Line: 938


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

Line: 962


     IRC_POSTING_CONTENT_BK3.delete_posting_content_a
     (
         P_POSTING_CONTENT_ID    => P_POSTING_CONTENT_ID
        ,P_OBJECT_VERSION_NUMBER => P_OBJECT_VERSION_NUMBER
     );

Line: 970


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

Line: 991


    rollback to delete_posting_content;

Line: 1004


    rollback to delete_posting_content;

Line: 1007


end delete_posting_content;

Line: 1016


    select
       ppf.full_name
     , ppf.email_address
     , pp.phone_number
     , ipc.posting_content_id
     , ipc.object_version_number
    from per_all_vacancies pv
       , per_recruitment_activity_for RAF
       , per_recruitment_activities pra
       , irc_posting_contents ipc
       , irc_all_recruiting_sites iars
       , per_all_people_f ppf
       , per_phones pp
    where pv.vacancy_id = raf.vacancy_id
          and pv.status='APPROVED'
          and raf.recruitment_activity_id = pra.recruitment_activity_id
          and pra.recruiting_site_id = iars.recruiting_site_id
          and iars.external='Y'
          and pra.posting_content_id = ipc.posting_content_id
          and pv.recruiter_id = ppf.person_id
          and sysdate between ppf.effective_start_date
          and ppf.effective_end_date
          and pv.recruiter_id = pp.parent_id(+)
          and pp.parent_table(+)='PER_ALL_PEOPLE_F'
          and pp.phone_type(+)='W1'
          and sysdate between nvl(pp.date_from, sysdate) and nvl(pp.date_to, sysdate)
          and ( nvl(ipc.recruiter_full_name,'-1') <> ppf.full_name
                OR nvl(ipc.recruiter_email,'-1') <> nvl(ppf.email_address,'-1')
                OR nvl(ipc.recruiter_work_telephone,'-1') <> nvl(pp.phone_number,'-1')
               );

Line: 1047


    select
       ppf.full_name
     , ppf.email_address
     , pp.phone_number
     , ipc.posting_content_id
     , ipc.object_version_number
    from per_all_vacancies pv
       , per_recruitment_activity_for RAF
       , per_recruitment_activities pra
       , irc_posting_contents ipc
       , irc_all_recruiting_sites iars
       , per_all_people_f ppf
       , per_phones pp
    where pv.vacancy_id = raf.vacancy_id
          and pv.status='APPROVED'
          and raf.recruitment_activity_id = pra.recruitment_activity_id
          and pra.recruiting_site_id = iars.recruiting_site_id
          and iars.external='Y'
          and pra.posting_content_id = ipc.posting_content_id
          and pv.manager_id = ppf.person_id
          and sysdate between ppf.effective_start_date
          and ppf.effective_end_date
          and pv.recruiter_id = pp.parent_id(+)
          and pp.parent_table(+)='PER_ALL_PEOPLE_F'
          and pp.phone_type(+)='W1'
          and sysdate between nvl(pp.date_from, sysdate) and nvl(pp.date_to, sysdate)
          and ( nvl(ipc.manager_full_name,'-1') <> ppf.full_name
                OR nvl(ipc.manager_email,'-1') <> nvl(ppf.email_address,'-1')
                OR nvl(ipc.manager_work_telephone,'-1') <> nvl(pp.phone_number,'-1')
               );