APPS.IRC_INTERVIEW_DETAILS_SWI SQL Statements

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

Line: 175

PROCEDURE update_irc_interview_details
  (p_validate                      in     number    default hr_api.g_false_num
  ,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
  ,p_return_status                    out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 219

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

Line: 225

  savepoint update_interview_details_swi;

Line: 246

  irc_interview_details_api.update_irc_interview_details
    (p_validate                  => l_validate
    ,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_event_id                  => p_event_id
    ,p_object_version_number     => p_object_version_number
    ,p_start_date                => p_start_date
    ,p_end_date                  => p_end_date
    );

Line: 303

    rollback to update_interview_details_swi;

Line: 320

    rollback to update_interview_details_swi;

Line: 333

end update_irc_interview_details;