[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
Procedure dt_insert_dml
(p_rec in out nocopy per_dis_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_disabilities_f t
where t.disability_id = p_rec.disability_id
and t.effective_start_date =
per_dis_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_disabilities_f.last_update_date%TYPE;
l_last_updated_by per_disabilities_f.last_updated_by%TYPE;
l_last_update_login per_disabilities_f.last_update_login%TYPE;
If (p_datetrack_mode <> hr_api.g_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_disabilities_f
(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
,created_by
,creation_date
,last_update_date
,last_updated_by
,last_update_login
)
Values
(p_rec.disability_id
,p_rec.effective_start_date
,p_rec.effective_end_date
,p_rec.person_id
,p_rec.incident_id
,p_rec.organization_id
,p_rec.registration_id
,p_rec.registration_date
,p_rec.registration_exp_date
,p_rec.category
,p_rec.status
,p_rec.description
,p_rec.degree
,p_rec.quota_fte
,p_rec.reason
,p_rec.pre_registration_job
,p_rec.work_restriction
,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
,p_rec.attribute21
,p_rec.attribute22
,p_rec.attribute23
,p_rec.attribute24
,p_rec.attribute25
,p_rec.attribute26
,p_rec.attribute27
,p_rec.attribute28
,p_rec.attribute29
,p_rec.attribute30
,p_rec.dis_information_category
,p_rec.dis_information1
,p_rec.dis_information2
,p_rec.dis_information3
,p_rec.dis_information4
,p_rec.dis_information5
,p_rec.dis_information6
,p_rec.dis_information7
,p_rec.dis_information8
,p_rec.dis_information9
,p_rec.dis_information10
,p_rec.dis_information11
,p_rec.dis_information12
,p_rec.dis_information13
,p_rec.dis_information14
,p_rec.dis_information15
,p_rec.dis_information16
,p_rec.dis_information17
,p_rec.dis_information18
,p_rec.dis_information19
,p_rec.dis_information20
,p_rec.dis_information21
,p_rec.dis_information22
,p_rec.dis_information23
,p_rec.dis_information24
,p_rec.dis_information25
,p_rec.dis_information26
,p_rec.dis_information27
,p_rec.dis_information28
,p_rec.dis_information29
,p_rec.dis_information30
,p_rec.object_version_number
,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_dis_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';
per_dis_ins.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_dis_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_disabilities_s.nextval from sys.dual;
End pre_insert;
Procedure post_insert
(p_rec in per_dis_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_dis_rki.after_insert
(p_effective_date
=> p_effective_date
,p_validation_start_date
=> p_validation_start_date
,p_validation_end_date
=> p_validation_end_date
,p_disability_id
=> p_rec.disability_id
,p_effective_start_date
=> p_rec.effective_start_date
,p_effective_end_date
=> p_rec.effective_end_date
,p_person_id
=> p_rec.person_id
,p_incident_id
=> p_rec.incident_id
,p_organization_id
=> p_rec.organization_id
,p_registration_id
=> p_rec.registration_id
,p_registration_date
=> p_rec.registration_date
,p_registration_exp_date
=> p_rec.registration_exp_date
,p_category
=> p_rec.category
,p_status
=> p_rec.status
,p_description
=> p_rec.description
,p_degree
=> p_rec.degree
,p_quota_fte
=> p_rec.quota_fte
,p_reason
=> p_rec.reason
,p_pre_registration_job
=> p_rec.pre_registration_job
,p_work_restriction
=> p_rec.work_restriction
,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_attribute21
=> p_rec.attribute21
,p_attribute22
=> p_rec.attribute22
,p_attribute23
=> p_rec.attribute23
,p_attribute24
=> p_rec.attribute24
,p_attribute25
=> p_rec.attribute25
,p_attribute26
=> p_rec.attribute26
,p_attribute27
=> p_rec.attribute27
,p_attribute28
=> p_rec.attribute28
,p_attribute29
=> p_rec.attribute29
,p_attribute30
=> p_rec.attribute30
,p_dis_information_category
=> p_rec.dis_information_category
,p_dis_information1
=> p_rec.dis_information1
,p_dis_information2
=> p_rec.dis_information2
,p_dis_information3
=> p_rec.dis_information3
,p_dis_information4
=> p_rec.dis_information4
,p_dis_information5
=> p_rec.dis_information5
,p_dis_information6
=> p_rec.dis_information6
,p_dis_information7
=> p_rec.dis_information7
,p_dis_information8
=> p_rec.dis_information8
,p_dis_information9
=> p_rec.dis_information9
,p_dis_information10
=> p_rec.dis_information10
,p_dis_information11
=> p_rec.dis_information11
,p_dis_information12
=> p_rec.dis_information12
,p_dis_information13
=> p_rec.dis_information13
,p_dis_information14
=> p_rec.dis_information14
,p_dis_information15
=> p_rec.dis_information15
,p_dis_information16
=> p_rec.dis_information16
,p_dis_information17
=> p_rec.dis_information17
,p_dis_information18
=> p_rec.dis_information18
,p_dis_information19
=> p_rec.dis_information19
,p_dis_information20
=> p_rec.dis_information20
,p_dis_information21
=> p_rec.dis_information21
,p_dis_information22
=> p_rec.dis_information22
,p_dis_information23
=> p_rec.dis_information23
,p_dis_information24
=> p_rec.dis_information24
,p_dis_information25
=> p_rec.dis_information25
,p_dis_information26
=> p_rec.dis_information26
,p_dis_information27
=> p_rec.dis_information27
,p_dis_information28
=> p_rec.dis_information28
,p_dis_information29
=> p_rec.dis_information29
,p_dis_information30
=> p_rec.dis_information30
,p_object_version_number
=> p_rec.object_version_number
);
End post_insert;
l_datetrack_mode varchar2(30) := hr_api.g_insert;
per_dis_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
);
per_dis_ins.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
);
per_dis_ins.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
);
per_dis_ins.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
);