[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
Procedure dt_insert_dml
(p_rec in out nocopy pqh_asa_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 pqh_assign_accommodations_f t
where t.assignment_acco_id = p_rec.assignment_acco_id
and t.effective_start_date =
pqh_asa_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 pqh_assign_accommodations_f.last_update_date%TYPE;
l_last_updated_by pqh_assign_accommodations_f.last_updated_by%TYPE;
l_last_update_login pqh_assign_accommodations_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 pqh_assign_accommodations_f
(assignment_acco_id
,effective_start_date
,effective_end_date
,business_group_id
,assignment_id
,accommodation_given
,temporary_assignment
,accommodation_id
,acceptance_date
,moving_date
,refusal_date
,comments
,indemnity_entitlement
,indemnity_amount
,type_of_payment
,information_category
,information1
,information2
,information3
,information4
,information5
,information6
,information7
,information8
,information9
,information10
,information11
,information12
,information13
,information14
,information15
,information16
,information17
,information18
,information19
,information20
,information21
,information22
,information23
,information24
,information25
,information26
,information27
,information28
,information29
,information30
,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
,object_version_number
,reason_for_no_acco
,indemnity_currency
,created_by
,creation_date
,last_update_date
,last_updated_by
,last_update_login
)
Values
(p_rec.assignment_acco_id
,p_rec.effective_start_date
,p_rec.effective_end_date
,p_rec.business_group_id
,p_rec.assignment_id
,p_rec.accommodation_given
,p_rec.temporary_assignment
,p_rec.accommodation_id
,p_rec.acceptance_date
,p_rec.moving_date
,p_rec.refusal_date
,p_rec.comments
,p_rec.indemnity_entitlement
,p_rec.indemnity_amount
,p_rec.type_of_payment
,p_rec.information_category
,p_rec.information1
,p_rec.information2
,p_rec.information3
,p_rec.information4
,p_rec.information5
,p_rec.information6
,p_rec.information7
,p_rec.information8
,p_rec.information9
,p_rec.information10
,p_rec.information11
,p_rec.information12
,p_rec.information13
,p_rec.information14
,p_rec.information15
,p_rec.information16
,p_rec.information17
,p_rec.information18
,p_rec.information19
,p_rec.information20
,p_rec.information21
,p_rec.information22
,p_rec.information23
,p_rec.information24
,p_rec.information25
,p_rec.information26
,p_rec.information27
,p_rec.information28
,p_rec.information29
,p_rec.information30
,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.object_version_number
,p_rec.reason_for_no_acco
,p_rec.indemnity_currency
,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 pqh_asa_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';
pqh_asa_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 pqh_asa_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 C_Sel1 is select pqh_assign_accommodations_s.nextval from sys.dual;
Select null
from pqh_assign_accommodations_f
where assignment_acco_id =
pqh_asa_ins.g_assignment_acco_id_i;
l_proc varchar2(72) := g_package||'pre_insert';
End pre_insert;
Procedure post_insert
(p_rec in pqh_asa_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';
pqh_asa_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_assignment_acco_id
=> p_rec.assignment_acco_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_assignment_id
=> p_rec.assignment_id
,p_accommodation_given
=> p_rec.accommodation_given
,p_temporary_assignment
=> p_rec.temporary_assignment
,p_accommodation_id
=> p_rec.accommodation_id
,p_acceptance_date
=> p_rec.acceptance_date
,p_moving_date
=> p_rec.moving_date
,p_refusal_date
=> p_rec.refusal_date
,p_comments
=> p_rec.comments
,p_indemnity_entitlement
=> p_rec.indemnity_entitlement
,p_indemnity_amount
=> p_rec.indemnity_amount
,p_type_of_payment
=> p_rec.type_of_payment
,p_information_category
=> p_rec.information_category
,p_information1
=> p_rec.information1
,p_information2
=> p_rec.information2
,p_information3
=> p_rec.information3
,p_information4
=> p_rec.information4
,p_information5
=> p_rec.information5
,p_information6
=> p_rec.information6
,p_information7
=> p_rec.information7
,p_information8
=> p_rec.information8
,p_information9
=> p_rec.information9
,p_information10
=> p_rec.information10
,p_information11
=> p_rec.information11
,p_information12
=> p_rec.information12
,p_information13
=> p_rec.information13
,p_information14
=> p_rec.information14
,p_information15
=> p_rec.information15
,p_information16
=> p_rec.information16
,p_information17
=> p_rec.information17
,p_information18
=> p_rec.information18
,p_information19
=> p_rec.information19
,p_information20
=> p_rec.information20
,p_information21
=> p_rec.information21
,p_information22
=> p_rec.information22
,p_information23
=> p_rec.information23
,p_information24
=> p_rec.information24
,p_information25
=> p_rec.information25
,p_information26
=> p_rec.information26
,p_information27
=> p_rec.information27
,p_information28
=> p_rec.information28
,p_information29
=> p_rec.information29
,p_information30
=> p_rec.information30
,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_object_version_number
=> p_rec.object_version_number
,p_reason_for_no_acco
=> p_rec.reason_for_no_acco
,p_indemnity_currency
=> p_rec.indemnity_currency
);
End post_insert;
l_datetrack_mode varchar2(30) := hr_api.g_insert;
pqh_asa_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
);
pqh_asa_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
);
pqh_asa_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
);
pqh_asa_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
);