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

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

Line: 242


procedure update_irc_interview_details
  (p_validate                      in     boolean  default false
  ,p_interview_details_id          in     number
  ,p_status                        in     varchar2 default hr_api.g_varchar2
  ,p_feedback                      in     varchar2 default hr_api.g_varchar2
  ,p_notes                         in     varchar2 default hr_api.g_varchar2
  ,p_notes_to_candidate            in     varchar2  default hr_api.g_varchar2
  ,p_category                      in     varchar2  default hr_api.g_varchar2
  ,p_result                        in     varchar2  default hr_api.g_varchar2
  ,p_iid_information_category      in     varchar2  default hr_api.g_varchar2
  ,p_iid_information1              in     varchar2  default hr_api.g_varchar2
  ,p_iid_information2              in     varchar2  default hr_api.g_varchar2
  ,p_iid_information3              in     varchar2  default hr_api.g_varchar2
  ,p_iid_information4              in     varchar2  default hr_api.g_varchar2
  ,p_iid_information5              in     varchar2  default hr_api.g_varchar2
  ,p_iid_information6              in     varchar2  default hr_api.g_varchar2
  ,p_iid_information7              in     varchar2  default hr_api.g_varchar2
  ,p_iid_information8              in     varchar2  default hr_api.g_varchar2
  ,p_iid_information9              in     varchar2  default hr_api.g_varchar2
  ,p_iid_information10             in     varchar2  default hr_api.g_varchar2
  ,p_iid_information11             in     varchar2  default hr_api.g_varchar2
  ,p_iid_information12             in     varchar2  default hr_api.g_varchar2
  ,p_iid_information13             in     varchar2  default hr_api.g_varchar2
  ,p_iid_information14             in     varchar2  default hr_api.g_varchar2
  ,p_iid_information15             in     varchar2  default hr_api.g_varchar2
  ,p_iid_information16             in     varchar2  default hr_api.g_varchar2
  ,p_iid_information17             in     varchar2  default hr_api.g_varchar2
  ,p_iid_information18             in     varchar2  default hr_api.g_varchar2
  ,p_iid_information19             in     varchar2  default hr_api.g_varchar2
  ,p_iid_information20             in     varchar2  default hr_api.g_varchar2
  ,p_event_id                      in     number
  ,p_object_version_number         in out nocopy   number
  ,p_start_date                       out nocopy   date
  ,p_end_date                         out nocopy   date
  ) is
  --
  -- Declare cursors and local variables
  --
  l_object_version_number    number;

Line: 284


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

Line: 290


  savepoint update_irc_interview_details;

Line: 295


    irc_interview_details_bk2.update_irc_interview_details_b
                 (p_interview_details_id         => p_interview_details_id
                 ,p_status                    => p_status
                 ,p_feedback                  => p_feedback
                 ,p_notes                     => p_notes
		 ,p_notes_to_candidate        => p_notes_to_candidate
		 ,p_category                  => p_category
                 ,p_result                    => p_result
		 ,p_iid_information_category  => p_iid_information_category
		 ,p_iid_information1          => p_iid_information1
		 ,p_iid_information2          => p_iid_information2
		 ,p_iid_information3          => p_iid_information3
		 ,p_iid_information4          => p_iid_information4
		 ,p_iid_information5          => p_iid_information5
		 ,p_iid_information6          => p_iid_information6
		 ,p_iid_information7          => p_iid_information7
		 ,p_iid_information8          => p_iid_information8
		 ,p_iid_information9          => p_iid_information9
		 ,p_iid_information10         => p_iid_information10
		 ,p_iid_information11         => p_iid_information11
		 ,p_iid_information12         => p_iid_information12
		 ,p_iid_information13         => p_iid_information13
		 ,p_iid_information14         => p_iid_information14
		 ,p_iid_information15         => p_iid_information15
		 ,p_iid_information16         => p_iid_information16
		 ,p_iid_information17         => p_iid_information17
		 ,p_iid_information18         => p_iid_information18
		 ,p_iid_information19         => p_iid_information19
		 ,p_iid_information20         => p_iid_information20
                 ,p_object_version_number     => p_object_version_number
                 );

Line: 329


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

Line: 345


                 ,p_datetrack_mode            => 'UPDATE'
                 ,p_interview_details_id      => p_interview_details_id
                 ,p_object_version_number     => l_object_version_number
                 ,p_status                    => p_status
                 ,p_feedback                  => p_feedback
                 ,p_notes                     => p_notes
 		 ,p_notes_to_candidate        => p_notes_to_candidate
		 ,p_category                  => p_category
                 ,p_result                    => p_result
		 ,p_iid_information_category  => p_iid_information_category
		 ,p_iid_information1          => p_iid_information1
		 ,p_iid_information2          => p_iid_information2
		 ,p_iid_information3          => p_iid_information3
		 ,p_iid_information4          => p_iid_information4
		 ,p_iid_information5          => p_iid_information5
		 ,p_iid_information6          => p_iid_information6
		 ,p_iid_information7          => p_iid_information7
		 ,p_iid_information8          => p_iid_information8
		 ,p_iid_information9          => p_iid_information9
		 ,p_iid_information10         => p_iid_information10
		 ,p_iid_information11         => p_iid_information11
		 ,p_iid_information12         => p_iid_information12
		 ,p_iid_information13         => p_iid_information13
		 ,p_iid_information14         => p_iid_information14
		 ,p_iid_information15         => p_iid_information15
		 ,p_iid_information16         => p_iid_information16
		 ,p_iid_information17         => p_iid_information17
		 ,p_iid_information18         => p_iid_information18
		 ,p_iid_information19         => p_iid_information19
		 ,p_iid_information20         => p_iid_information20
                 ,p_event_id                  => p_event_id
                 ,p_start_date                => l_start_date
                 ,p_end_date                  => l_end_date
                 );

Line: 383


    irc_interview_details_bk2.update_irc_interview_details_a
                 (p_interview_details_id         => p_interview_details_id
                 ,p_status                    => p_status
                 ,p_feedback                  => p_feedback
                 ,p_notes                     => p_notes
		 ,p_notes_to_candidate        => p_notes_to_candidate
		 ,p_category                  => p_category
                 ,p_result                    => p_result
		 ,p_iid_information_category  => p_iid_information_category
		 ,p_iid_information1          => p_iid_information1
		 ,p_iid_information2          => p_iid_information2
		 ,p_iid_information3          => p_iid_information3
		 ,p_iid_information4          => p_iid_information4
		 ,p_iid_information5          => p_iid_information5
		 ,p_iid_information6          => p_iid_information6
		 ,p_iid_information7          => p_iid_information7
		 ,p_iid_information8          => p_iid_information8
		 ,p_iid_information9          => p_iid_information9
		 ,p_iid_information10         => p_iid_information10
		 ,p_iid_information11         => p_iid_information11
		 ,p_iid_information12         => p_iid_information12
		 ,p_iid_information13         => p_iid_information13
		 ,p_iid_information14         => p_iid_information14
		 ,p_iid_information15         => p_iid_information15
		 ,p_iid_information16         => p_iid_information16
		 ,p_iid_information17         => p_iid_information17
		 ,p_iid_information18         => p_iid_information18
		 ,p_iid_information19         => p_iid_information19
		 ,p_iid_information20         => p_iid_information20
                 ,p_object_version_number     => p_object_version_number
                 );

Line: 417


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

Line: 441


    rollback to update_irc_interview_details;

Line: 454


    rollback to update_irc_interview_details;

Line: 463


end update_irc_interview_details;

Line: 487


  Cursor C_Sel1 is select irc_interview_details_s.nextval from sys.dual;

Line: 491


  select *
  from per_events
  where assignment_id=p_assignment_id;

Line: 497


  select *
  from irc_interview_details
  where event_id = p_event_id;

Line: 564


  insert into irc_interview_details
      (interview_details_id
      ,status
      ,feedback
      ,notes
      ,notes_to_candidate
      ,category
      ,result
      ,iid_information_category
      ,iid_information1
      ,iid_information2
      ,iid_information3
      ,iid_information4
      ,iid_information5
      ,iid_information6
      ,iid_information7
      ,iid_information8
      ,iid_information9
      ,iid_information10
      ,iid_information11
      ,iid_information12
      ,iid_information13
      ,iid_information14
      ,iid_information15
      ,iid_information16
      ,iid_information17
      ,iid_information18
      ,iid_information19
      ,iid_information20
      ,start_date
      ,end_date
      ,event_id
      ,object_version_number
      )
  Values
     (l_interview_details_id
     ,l_interview_det_rec.status
     ,l_interview_det_rec.feedback
     ,l_interview_det_rec.notes
     ,l_interview_det_rec.notes_to_candidate
     ,l_interview_det_rec.category
     ,l_interview_det_rec.result
     ,l_interview_det_rec.iid_information_category
     ,l_interview_det_rec.iid_information1
     ,l_interview_det_rec.iid_information2
     ,l_interview_det_rec.iid_information3
     ,l_interview_det_rec.iid_information4
     ,l_interview_det_rec.iid_information5
     ,l_interview_det_rec.iid_information6
     ,l_interview_det_rec.iid_information7
     ,l_interview_det_rec.iid_information8
     ,l_interview_det_rec.iid_information9
     ,l_interview_det_rec.iid_information10
     ,l_interview_det_rec.iid_information11
     ,l_interview_det_rec.iid_information12
     ,l_interview_det_rec.iid_information13
     ,l_interview_det_rec.iid_information14
     ,l_interview_det_rec.iid_information15
     ,l_interview_det_rec.iid_information16
     ,l_interview_det_rec.iid_information17
     ,l_interview_det_rec.iid_information18
     ,l_interview_det_rec.iid_information19
     ,l_interview_det_rec.iid_information20
     ,l_interview_det_rec.start_date
     ,l_interview_det_rec.end_date
     ,l_event_id
     ,l_interview_det_rec.object_version_number
     );