The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
contact_extra_info_id
,effective_start_date
,effective_end_date
,contact_relationship_id
,information_type
,cei_information_category
,cei_information1
,cei_information2
,cei_information3
,cei_information4
,cei_information5
,cei_information6
,cei_information7
,cei_information8
,cei_information9
,cei_information10
,cei_information11
,cei_information12
,cei_information13
,cei_information14
,cei_information15
,cei_information16
,cei_information17
,cei_information18
,cei_information19
,cei_information20
,cei_information21
,cei_information22
,cei_information23
,cei_information24
,cei_information25
,cei_information26
,cei_information27
,cei_information28
,cei_information29
,cei_information30
,cei_attribute_category
,cei_attribute1
,cei_attribute2
,cei_attribute3
,cei_attribute4
,cei_attribute5
,cei_attribute6
,cei_attribute7
,cei_attribute8
,cei_attribute9
,cei_attribute10
,cei_attribute11
,cei_attribute12
,cei_attribute13
,cei_attribute14
,cei_attribute15
,cei_attribute16
,cei_attribute17
,cei_attribute18
,cei_attribute19
,cei_attribute20
,object_version_number
,request_id
,program_application_id
,program_id
,program_update_date
from per_contact_extra_info_f
where contact_extra_info_id = p_contact_extra_info_id
and p_effective_date
between effective_start_date and effective_end_date;
,p_update out nocopy boolean
,p_update_override out nocopy boolean
,p_update_change_insert out nocopy boolean
) is
--
l_proc varchar2(72) := g_package||'find_dt_upd_modes';
,p_update => p_update
,p_update_override => p_update_override
,p_update_change_insert => p_update_change_insert
);
,p_delete out nocopy boolean
,p_future_change out nocopy boolean
,p_delete_next_change out nocopy boolean
) is
--
l_proc varchar2(72) := g_package||'find_dt_del_modes';
,p_delete => p_delete
,p_future_change => p_future_change
,p_delete_next_change => p_delete_next_change
);
update per_contact_extra_info_f t
set t.effective_end_date = p_new_effective_end_date
, t.object_version_number = l_object_version_number
where t.contact_extra_info_id = p_base_key_value
and p_effective_date
between t.effective_start_date and t.effective_end_date;
select
contact_extra_info_id
,effective_start_date
,effective_end_date
,contact_relationship_id
,information_type
,cei_information_category
,cei_information1
,cei_information2
,cei_information3
,cei_information4
,cei_information5
,cei_information6
,cei_information7
,cei_information8
,cei_information9
,cei_information10
,cei_information11
,cei_information12
,cei_information13
,cei_information14
,cei_information15
,cei_information16
,cei_information17
,cei_information18
,cei_information19
,cei_information20
,cei_information21
,cei_information22
,cei_information23
,cei_information24
,cei_information25
,cei_information26
,cei_information27
,cei_information28
,cei_information29
,cei_information30
,cei_attribute_category
,cei_attribute1
,cei_attribute2
,cei_attribute3
,cei_attribute4
,cei_attribute5
,cei_attribute6
,cei_attribute7
,cei_attribute8
,cei_attribute9
,cei_attribute10
,cei_attribute11
,cei_attribute12
,cei_attribute13
,cei_attribute14
,cei_attribute15
,cei_attribute16
,cei_attribute17
,cei_attribute18
,cei_attribute19
,cei_attribute20
,object_version_number
,request_id
,program_application_id
,program_id
,program_update_date
from per_contact_extra_info_f
where contact_extra_info_id = p_contact_extra_info_id
and p_effective_date
between effective_start_date and effective_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;
select person_id
into l_person_id
from per_contact_relationships
where contact_relationship_id = g_old_rec.contact_relationship_id;
,p_program_update_date in date
)
Return g_rec_type is
--
l_rec g_rec_type;
l_rec.program_update_date := p_program_update_date;