The following lines contain the word 'select', 'insert', 'update' or 'delete':
Procedure dt_insert_dml
(p_rec in out nocopy per_ctc_shd.g_rec_type,
p_effective_date in date,
p_datetrack_mode in varchar2,
p_validation_start_date in date,
p_validation_end_date in date) is
--
-- Cursor to select 'old' created AOL who column values
--
Cursor C_Sel1 Is
select t.created_by,
t.creation_date
from per_contracts_f t
where t.contract_id = p_rec.contract_id
and t.effective_start_date =
per_ctc_shd.g_old_rec.effective_start_date
and t.effective_end_date = (p_validation_start_date - 1);
l_proc varchar2(72) := g_package||'dt_insert_dml';
l_last_update_date per_contracts_f.last_update_date%TYPE;
l_last_updated_by per_contracts_f.last_updated_by%TYPE;
l_last_update_login per_contracts_f.last_update_login%TYPE;
If (p_datetrack_mode <> 'INSERT') then
hr_utility.set_location(l_proc, 10);
l_last_update_date := sysdate;
l_last_updated_by := fnd_global.user_id;
l_last_update_login := fnd_global.login_id;
insert into per_contracts_f
( 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
, created_by,
creation_date,
last_update_date,
last_updated_by,
last_update_login
)
Values
( p_rec.contract_id,
p_rec.effective_start_date,
p_rec.effective_end_date,
p_rec.business_group_id,
p_rec.object_version_number,
p_rec.person_id,
p_rec.reference,
p_rec.type,
p_rec.status,
p_rec.status_reason,
p_rec.doc_status,
p_rec.doc_status_change_date,
p_rec.description,
p_rec.duration,
p_rec.duration_units,
p_rec.contractual_job_title,
p_rec.parties,
p_rec.start_reason,
p_rec.end_reason,
p_rec.number_of_extensions,
p_rec.extension_reason,
p_rec.extension_period,
p_rec.extension_period_units,
p_rec.ctr_information_category,
p_rec.ctr_information1,
p_rec.ctr_information2,
p_rec.ctr_information3,
p_rec.ctr_information4,
p_rec.ctr_information5,
p_rec.ctr_information6,
p_rec.ctr_information7,
p_rec.ctr_information8,
p_rec.ctr_information9,
p_rec.ctr_information10,
p_rec.ctr_information11,
p_rec.ctr_information12,
p_rec.ctr_information13,
p_rec.ctr_information14,
p_rec.ctr_information15,
p_rec.ctr_information16,
p_rec.ctr_information17,
p_rec.ctr_information18,
p_rec.ctr_information19,
p_rec.ctr_information20,
p_rec.attribute_category,
p_rec.attribute1,
p_rec.attribute2,
p_rec.attribute3,
p_rec.attribute4,
p_rec.attribute5,
p_rec.attribute6,
p_rec.attribute7,
p_rec.attribute8,
p_rec.attribute9,
p_rec.attribute10,
p_rec.attribute11,
p_rec.attribute12,
p_rec.attribute13,
p_rec.attribute14,
p_rec.attribute15,
p_rec.attribute16,
p_rec.attribute17,
p_rec.attribute18,
p_rec.attribute19,
p_rec.attribute20
, l_created_by,
l_creation_date,
l_last_update_date,
l_last_updated_by,
l_last_update_login
);
End dt_insert_dml;
Procedure insert_dml
(p_rec in out nocopy per_ctc_shd.g_rec_type,
p_effective_date in date,
p_datetrack_mode in varchar2,
p_validation_start_date in date,
p_validation_end_date in date) is
--
l_proc varchar2(72) := g_package||'insert_dml';
dt_insert_dml(p_rec => p_rec,
p_effective_date => p_effective_date,
p_datetrack_mode => p_datetrack_mode,
p_validation_start_date => p_validation_start_date,
p_validation_end_date => p_validation_end_date);
End insert_dml;
Procedure pre_insert
(p_rec in out nocopy per_ctc_shd.g_rec_type,
p_effective_date in date,
p_datetrack_mode in varchar2,
p_validation_start_date in date,
p_validation_end_date in date) is
--
l_proc varchar2(72) := g_package||'pre_insert';
Cursor C_Sel1 is select per_contracts_s.nextval from sys.dual;
End pre_insert;
Procedure post_insert
(p_rec in per_ctc_shd.g_rec_type,
p_effective_date in date,
p_datetrack_mode in varchar2,
p_validation_start_date in date,
p_validation_end_date in date) is
--
l_proc varchar2(72) := g_package||'post_insert';
per_ctc_rki.after_insert
(
p_contract_id => p_rec.contract_id,
p_effective_start_date => p_rec.effective_start_date,
p_effective_end_date => p_rec.effective_end_date,
p_business_group_id => p_rec.business_group_id,
p_object_version_number => p_rec.object_version_number,
p_person_id => p_rec.person_id,
p_reference => p_rec.reference,
p_type => p_rec.type,
p_status => p_rec.status,
p_status_reason => p_rec.status_reason,
p_doc_status => p_rec.doc_status,
p_doc_status_change_date => p_rec.doc_status_change_date,
p_description => p_rec.description,
p_duration => p_rec.duration,
p_duration_units => p_rec.duration_units,
p_contractual_job_title => p_rec.contractual_job_title,
p_parties => p_rec.parties,
p_start_reason => p_rec.start_reason,
p_end_reason => p_rec.end_reason ,
p_number_of_extensions => p_rec.number_of_extensions,
p_extension_reason => p_rec.extension_reason,
p_extension_period => p_rec.extension_period,
p_extension_period_units => p_rec.extension_period_units,
p_ctr_information_category => p_rec.ctr_information_category,
p_ctr_information1 => p_rec.ctr_information1,
p_ctr_information2 => p_rec.ctr_information2,
p_ctr_information3 => p_rec.ctr_information3,
p_ctr_information4 => p_rec.ctr_information4,
p_ctr_information5 => p_rec.ctr_information5,
p_ctr_information6 => p_rec.ctr_information6,
p_ctr_information7 => p_rec.ctr_information7,
p_ctr_information8 => p_rec.ctr_information8,
p_ctr_information9 => p_rec.ctr_information9,
p_ctr_information10 => p_rec.ctr_information10,
p_ctr_information11 => p_rec.ctr_information11,
p_ctr_information12 => p_rec.ctr_information12,
p_ctr_information13 => p_rec.ctr_information13,
p_ctr_information14 => p_rec.ctr_information14,
p_ctr_information15 => p_rec.ctr_information15,
p_ctr_information16 => p_rec.ctr_information16,
p_ctr_information17 => p_rec.ctr_information17,
p_ctr_information18 => p_rec.ctr_information18,
p_ctr_information19 => p_rec.ctr_information19,
p_ctr_information20 => p_rec.ctr_information20,
p_attribute_category => p_rec.attribute_category,
p_attribute1 => p_rec.attribute1,
p_attribute2 => p_rec.attribute2,
p_attribute3 => p_rec.attribute3,
p_attribute4 => p_rec.attribute4,
p_attribute5 => p_rec.attribute5,
p_attribute6 => p_rec.attribute6,
p_attribute7 => p_rec.attribute7,
p_attribute8 => p_rec.attribute8,
p_attribute9 => p_rec.attribute9,
p_attribute10 => p_rec.attribute10,
p_attribute11 => p_rec.attribute11,
p_attribute12 => p_rec.attribute12,
p_attribute13 => p_rec.attribute13,
p_attribute14 => p_rec.attribute14,
p_attribute15 => p_rec.attribute15,
p_attribute16 => p_rec.attribute16,
p_attribute17 => p_rec.attribute17,
p_attribute18 => p_rec.attribute18,
p_attribute19 => p_rec.attribute19,
p_attribute20 => p_rec.attribute20,
p_effective_date => p_effective_date,
p_validation_start_date => p_validation_start_date,
p_validation_end_date => p_validation_end_date
);
End post_insert;
l_datetrack_mode varchar2(30) := 'INSERT';
per_ctc_bus.insert_validate
(p_rec => p_rec,
p_effective_date => p_effective_date,
p_datetrack_mode => l_datetrack_mode,
p_validation_start_date => l_validation_start_date,
p_validation_end_date => l_validation_end_date);
pre_insert
(p_rec => p_rec,
p_effective_date => p_effective_date,
p_datetrack_mode => l_datetrack_mode,
p_validation_start_date => l_validation_start_date,
p_validation_end_date => l_validation_end_date);
insert_dml
(p_rec => p_rec,
p_effective_date => p_effective_date,
p_datetrack_mode => l_datetrack_mode,
p_validation_start_date => l_validation_start_date,
p_validation_end_date => l_validation_end_date);
post_insert
(p_rec => p_rec,
p_effective_date => p_effective_date,
p_datetrack_mode => l_datetrack_mode,
p_validation_start_date => l_validation_start_date,
p_validation_end_date => l_validation_end_date);