The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
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
,created_by
from irc_interview_details
where interview_details_id = p_interview_details_id;
update irc_interview_details t
set t.end_date = p_new_end_date
, t.object_version_number = l_object_version_number
where t.interview_details_id = p_interview_details_id
and p_effective_date
between t.start_date and t.end_date;
select
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
,created_by
from irc_interview_details
where interview_details_id = p_interview_details_id
and sysdate between start_date and end_date
for update nowait;
If (p_datetrack_mode <> hr_api.g_insert) then
--
-- We must select and lock the current row.
--
Open C_Sel1;
if (p_datetrack_mode = hr_api.g_update) then
p_validation_start_date := p_effective_date;
elsif (p_datetrack_mode = hr_api.g_delete) then
p_validation_start_date := p_effective_date;
select nvl(max(t.object_version_number),0) + 1
into l_ovn
from irc_interview_details t
where t.interview_details_id = p_interview_details_id;