The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
contract_id,
effective_start_date,
effective_end_date,
business_group_id,
object_version_number,
person_id,
reference,
type,
status,
status_reason,
doc_status,
doc_status_change_date,
description,
duration,
duration_units,
contractual_job_title,
parties,
start_reason,
end_reason,
number_of_extensions,
extension_reason,
extension_period,
extension_period_units,
ctr_information_category,
ctr_information1,
ctr_information2,
ctr_information3,
ctr_information4,
ctr_information5,
ctr_information6,
ctr_information7,
ctr_information8,
ctr_information9,
ctr_information10,
ctr_information11,
ctr_information12,
ctr_information13,
ctr_information14,
ctr_information15,
ctr_information16,
ctr_information17,
ctr_information18,
ctr_information19,
ctr_information20,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
attribute16,
attribute17,
attribute18,
attribute19,
attribute20
from per_contracts_f
where contract_id = p_contract_id
and p_effective_date
between effective_start_date and effective_end_date;
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 ctc.person_id
from per_contracts_f ctc
where ctc.contract_id = p_base_key_value
and p_effective_date between ctc.effective_start_date
and ctc.effective_end_date;
p_delete => p_delete,
p_future_change => p_future_change,
p_delete_next_change => p_delete_next_change);
p_delete := False;
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);
update per_contracts_f t
set t.effective_end_date = p_new_effective_end_date,
t.object_version_number = l_object_version_number
where t.contract_id = p_base_key_value
and p_effective_date
between t.effective_start_date and t.effective_end_date;
select
contract_id,
effective_start_date,
effective_end_date,
business_group_id,
object_version_number,
person_id,
reference,
type,
status,
status_reason,
doc_status,
doc_status_change_date,
description,
duration,
duration_units,
contractual_job_title,
parties,
start_reason,
end_reason,
number_of_extensions,
extension_reason,
extension_period,
extension_period_units,
ctr_information_category,
ctr_information1,
ctr_information2,
ctr_information3,
ctr_information4,
ctr_information5,
ctr_information6,
ctr_information7,
ctr_information8,
ctr_information9,
ctr_information10,
ctr_information11,
ctr_information12,
ctr_information13,
ctr_information14,
ctr_information15,
ctr_information16,
ctr_information17,
ctr_information18,
ctr_information19,
ctr_information20,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
attribute16,
attribute17,
attribute18,
attribute19,
attribute20
from per_contracts_f
where contract_id = p_contract_id
and p_effective_date
between effective_start_date and effective_end_date
for update nowait;
If (p_datetrack_mode <> 'INSERT') then
--
-- We must select and lock the current row.
--
Open C_Sel1;
select
contract_id,
effective_start_date,
effective_end_date,
business_group_id,
object_version_number,
person_id,
reference,
type,
status,
status_reason,
doc_status,
doc_status_change_date,
description,
duration,
duration_units,
contractual_job_title,
parties,
start_reason,
end_reason,
number_of_extensions,
extension_reason,
extension_period,
extension_period_units,
ctr_information_category,
ctr_information1,
ctr_information2,
ctr_information3,
ctr_information4,
ctr_information5,
ctr_information6,
ctr_information7,
ctr_information8,
ctr_information9,
ctr_information10,
ctr_information11,
ctr_information12,
ctr_information13,
ctr_information14,
ctr_information15,
ctr_information16,
ctr_information17,
ctr_information18,
ctr_information19,
ctr_information20,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
attribute16,
attribute17,
attribute18,
attribute19,
attribute20
from per_contracts_f
where contract_id = p_contract_id
and p_effective_date
between effective_start_date and effective_end_date
for update nowait;