[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
disability_id
,effective_start_date
,effective_end_date
,person_id
,incident_id
,organization_id
,registration_id
,registration_date
,registration_exp_date
,category
,status
,description
,degree
,quota_fte
,reason
,pre_registration_job
,work_restriction
,attribute_category
,attribute1
,attribute2
,attribute3
,attribute4
,attribute5
,attribute6
,attribute7
,attribute8
,attribute9
,attribute10
,attribute11
,attribute12
,attribute13
,attribute14
,attribute15
,attribute16
,attribute17
,attribute18
,attribute19
,attribute20
,attribute21
,attribute22
,attribute23
,attribute24
,attribute25
,attribute26
,attribute27
,attribute28
,attribute29
,attribute30
,dis_information_category
,dis_information1
,dis_information2
,dis_information3
,dis_information4
,dis_information5
,dis_information6
,dis_information7
,dis_information8
,dis_information9
,dis_information10
,dis_information11
,dis_information12
,dis_information13
,dis_information14
,dis_information15
,dis_information16
,dis_information17
,dis_information18
,dis_information19
,dis_information20
,dis_information21
,dis_information22
,dis_information23
,dis_information24
,dis_information25
,dis_information26
,dis_information27
,dis_information28
,dis_information29
,dis_information30
,object_version_number
from per_disabilities_f
where disability_id = p_disability_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';
select
t.person_id
from per_disabilities_f t
where t.disability_id = p_base_key_value
and p_effective_date
between t.effective_start_date and t.effective_end_date;
,p_delete => p_delete
,p_future_change => p_future_change
,p_delete_next_change => p_delete_next_change
);
update per_disabilities_f t
set t.effective_end_date = p_new_effective_end_date
, t.object_version_number = l_object_version_number
where t.disability_id = p_base_key_value
and p_effective_date
between t.effective_start_date and t.effective_end_date;
select
disability_id
,effective_start_date
,effective_end_date
,person_id
,incident_id
,organization_id
,registration_id
,registration_date
,registration_exp_date
,category
,status
,description
,degree
,quota_fte
,reason
,pre_registration_job
,work_restriction
,attribute_category
,attribute1
,attribute2
,attribute3
,attribute4
,attribute5
,attribute6
,attribute7
,attribute8
,attribute9
,attribute10
,attribute11
,attribute12
,attribute13
,attribute14
,attribute15
,attribute16
,attribute17
,attribute18
,attribute19
,attribute20
,attribute21
,attribute22
,attribute23
,attribute24
,attribute25
,attribute26
,attribute27
,attribute28
,attribute29
,attribute30
,dis_information_category
,dis_information1
,dis_information2
,dis_information3
,dis_information4
,dis_information5
,dis_information6
,dis_information7
,dis_information8
,dis_information9
,dis_information10
,dis_information11
,dis_information12
,dis_information13
,dis_information14
,dis_information15
,dis_information16
,dis_information17
,dis_information18
,dis_information19
,dis_information20
,dis_information21
,dis_information22
,dis_information23
,dis_information24
,dis_information25
,dis_information26
,dis_information27
,dis_information28
,dis_information29
,dis_information30
,object_version_number
from per_disabilities_f
where disability_id = p_disability_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;