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_PENDING_DATA_SWI SQL Statements

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

Line: 61


  ,p_last_update_date             in     date
  ,p_pending_data_id              in     number
  ,p_allow_access                 in     varchar2 default null
  ,p_user_guid                    in     raw      default null
  ,p_visitor_resp_key             in     varchar2 default null
  ,p_visitor_resp_appl_id         in     number   default null
  ,p_security_group_key           in     varchar2 default null
  ,p_return_status                out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 155


    ,p_last_update_date             => p_last_update_date
    ,p_pending_data_id              => l_pending_data_id
    ,p_allow_access                 => p_allow_access
    ,p_user_guid                    => p_user_guid
    ,p_visitor_resp_key             => p_visitor_resp_key
    ,p_visitor_resp_appl_id         => p_visitor_resp_appl_id
    ,p_security_group_key           => p_security_group_key
	);

Line: 213


PROCEDURE update_pending_data
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_pending_data_id              in     number
  ,p_email_address                in     varchar2  default hr_api.g_varchar2
  ,p_last_name                    in     varchar2  default hr_api.g_varchar2
  ,p_vacancy_id                   in     number    default hr_api.g_number
  ,p_first_name                   in     varchar2  default hr_api.g_varchar2
  ,p_user_password                in     varchar2  default hr_api.g_varchar2
  ,p_resume_file_name             in     varchar2  default hr_api.g_varchar2
  ,p_resume_description           in     varchar2  default hr_api.g_varchar2
  ,p_resume_mime_type             in     varchar2  default hr_api.g_varchar2
  ,p_source_type                  in     varchar2  default hr_api.g_varchar2
  ,p_job_post_source_name         in     varchar2  default hr_api.g_varchar2
  ,p_posting_content_id           in     number    default hr_api.g_number
  ,p_person_id                    in     number    default hr_api.g_number
  ,p_processed                    in     varchar2  default hr_api.g_varchar2
  ,p_sex                          in     varchar2  default hr_api.g_varchar2
  ,p_date_of_birth                in     date      default hr_api.g_date
  ,p_per_information_category     in     varchar2  default hr_api.g_varchar2
  ,p_per_information1             in     varchar2  default hr_api.g_varchar2
  ,p_per_information2             in     varchar2  default hr_api.g_varchar2
  ,p_per_information3             in     varchar2  default hr_api.g_varchar2
  ,p_per_information4             in     varchar2  default hr_api.g_varchar2
  ,p_per_information5             in     varchar2  default hr_api.g_varchar2
  ,p_per_information6             in     varchar2  default hr_api.g_varchar2
  ,p_per_information7             in     varchar2  default hr_api.g_varchar2
  ,p_per_information8             in     varchar2  default hr_api.g_varchar2
  ,p_per_information9             in     varchar2  default hr_api.g_varchar2
  ,p_per_information10            in     varchar2  default hr_api.g_varchar2
  ,p_per_information11            in     varchar2  default hr_api.g_varchar2
  ,p_per_information12            in     varchar2  default hr_api.g_varchar2
  ,p_per_information13            in     varchar2  default hr_api.g_varchar2
  ,p_per_information14            in     varchar2  default hr_api.g_varchar2
  ,p_per_information15            in     varchar2  default hr_api.g_varchar2
  ,p_per_information16            in     varchar2  default hr_api.g_varchar2
  ,p_per_information17            in     varchar2  default hr_api.g_varchar2
  ,p_per_information18            in     varchar2  default hr_api.g_varchar2
  ,p_per_information19            in     varchar2  default hr_api.g_varchar2
  ,p_per_information20            in     varchar2  default hr_api.g_varchar2
  ,p_per_information21            in     varchar2  default hr_api.g_varchar2
  ,p_per_information22            in     varchar2  default hr_api.g_varchar2
  ,p_per_information23            in     varchar2  default hr_api.g_varchar2
  ,p_per_information24            in     varchar2  default hr_api.g_varchar2
  ,p_per_information25            in     varchar2  default hr_api.g_varchar2
  ,p_per_information26            in     varchar2  default hr_api.g_varchar2
  ,p_per_information27            in     varchar2  default hr_api.g_varchar2
  ,p_per_information28            in     varchar2  default hr_api.g_varchar2
  ,p_per_information29            in     varchar2  default hr_api.g_varchar2
  ,p_per_information30            in     varchar2  default hr_api.g_varchar2
  ,p_error_message                in     varchar2  default hr_api.g_varchar2
  ,p_creation_date                in     date      default hr_api.g_date
  ,p_last_update_date             in     date      default hr_api.g_date
  ,p_allow_access                 in     varchar2  default hr_api.g_varchar2
  ,p_user_guid                    in     raw       default null
  ,p_visitor_resp_key             in     varchar2  default hr_api.g_varchar2
  ,p_visitor_resp_appl_id         in     number    default hr_api.g_number
  ,p_security_group_key           in     varchar2  default hr_api.g_varchar2
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 279


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

Line: 285


  savepoint update_pending_data_swi;

Line: 299


  irc_pending_data_api.update_pending_data
    (p_validate                     => l_validate
	,p_pending_data_id              => p_pending_data_id
    ,p_email_address                => p_email_address
    ,p_last_name                    => p_last_name
    ,p_vacancy_id                   => p_vacancy_id
    ,p_first_name                   => p_first_name
    ,p_user_password                => p_user_password
    ,p_resume_file_name             => p_resume_file_name
    ,p_resume_description           => p_resume_description
    ,p_resume_mime_type             => p_resume_mime_type
    ,p_source_type                  => p_source_type
    ,p_job_post_source_name         => p_job_post_source_name
    ,p_posting_content_id           => p_posting_content_id
    ,p_person_id                    => p_person_id
    ,p_processed                    => p_processed
    ,p_sex                          => p_sex
    ,p_date_of_birth                => p_date_of_birth
    ,p_per_information_category     => p_per_information_category
    ,p_per_information1             => p_per_information1
    ,p_per_information2             => p_per_information2
    ,p_per_information3             => p_per_information3
    ,p_per_information4             => p_per_information4
    ,p_per_information5             => p_per_information5
    ,p_per_information6             => p_per_information6
    ,p_per_information7             => p_per_information7
    ,p_per_information8             => p_per_information8
    ,p_per_information9             => p_per_information9
    ,p_per_information10            => p_per_information10
    ,p_per_information11            => p_per_information11
    ,p_per_information12            => p_per_information12
    ,p_per_information13            => p_per_information13
    ,p_per_information14            => p_per_information14
    ,p_per_information15            => p_per_information15
    ,p_per_information16            => p_per_information16
    ,p_per_information17            => p_per_information17
    ,p_per_information18            => p_per_information18
    ,p_per_information19            => p_per_information19
    ,p_per_information20            => p_per_information20
    ,p_per_information21            => p_per_information21
    ,p_per_information22            => p_per_information22
    ,p_per_information23            => p_per_information23
    ,p_per_information24            => p_per_information24
    ,p_per_information25            => p_per_information25
    ,p_per_information26            => p_per_information26
    ,p_per_information27            => p_per_information27
    ,p_per_information28            => p_per_information28
    ,p_per_information29            => p_per_information29
    ,p_per_information30            => p_per_information30
    ,p_error_message                => p_error_message
    ,p_creation_date                => p_creation_date
    ,p_last_update_date             => p_last_update_date
    ,p_allow_access                 => p_allow_access
    ,p_user_guid                    => p_user_guid
    ,p_visitor_resp_key             => p_visitor_resp_key
    ,p_visitor_resp_appl_id         => p_visitor_resp_appl_id
    ,p_security_group_key           => p_security_group_key
	);

Line: 379


    rollback to update_pending_data_swi;

Line: 393


    rollback to update_pending_data_swi;

Line: 403


end update_pending_data;

Line: 407


PROCEDURE delete_pending_data
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_pending_data_id              in     number
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 419


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

Line: 425


  savepoint delete_pending_data_swi;

Line: 439


  irc_pending_data_api.delete_pending_data
    (p_validate                     => l_validate
	,p_pending_data_id              => p_pending_data_id
    );

Line: 465


    rollback to delete_pending_data_swi;

Line: 479


    rollback to delete_pending_data_swi;

Line: 489


end delete_pending_data;