The following lines contain the word 'select', 'insert', 'update' or 'delete':
Procedure dt_delete_dml
(p_rec in out nocopy irc_irf_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||'dt_delete_dml';
If (p_datetrack_mode = hr_api.g_delete_next_change) then
--
--
-- Delete the where the effective start date is equal
-- to the validation end date.
--
delete from irc_referral_info
where referral_info_id = p_rec.referral_info_id
and start_date = p_validation_start_date;
delete from irc_referral_info
where referral_info_id = p_rec.referral_info_id
and start_date >= p_validation_start_date;*/
End dt_delete_dml;
Procedure delete_dml
(p_rec in out nocopy irc_irf_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||'delete_dml';
irc_irf_del.dt_delete_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 delete_dml;
Procedure dt_pre_delete
(p_rec in out nocopy irc_irf_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||'dt_pre_delete';
If (p_datetrack_mode = hr_api.g_delete) then
p_rec.end_date := p_validation_start_date;
End dt_pre_delete;
Procedure pre_delete
(p_rec in out nocopy irc_irf_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_delete';
irc_irf_del.dt_pre_delete
(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 pre_delete;
Procedure post_delete
(p_rec in irc_irf_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_delete';
irc_irf_rkd.after_delete
(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
,p_referral_info_id => p_rec.referral_info_id
,p_start_date => p_rec.start_date
,p_end_date => p_rec.end_date
,p_object_id_o => irc_irf_shd.g_old_rec.object_id
,p_object_type_o => irc_irf_shd.g_old_rec.object_type
,p_start_date_o => irc_irf_shd.g_old_rec.start_date
,p_end_date_o => irc_irf_shd.g_old_rec.end_date
,p_source_type_o => irc_irf_shd.g_old_rec.source_type
,p_source_name_o => irc_irf_shd.g_old_rec.source_name
,p_source_criteria1_o => irc_irf_shd.g_old_rec.source_criteria1
,p_source_value1_o => irc_irf_shd.g_old_rec.source_value1
,p_source_criteria2_o => irc_irf_shd.g_old_rec.source_criteria2
,p_source_value2_o => irc_irf_shd.g_old_rec.source_value2
,p_source_criteria3_o => irc_irf_shd.g_old_rec.source_criteria3
,p_source_value3_o => irc_irf_shd.g_old_rec.source_value3
,p_source_criteria4_o => irc_irf_shd.g_old_rec.source_criteria4
,p_source_value4_o => irc_irf_shd.g_old_rec.source_value4
,p_source_criteria5_o => irc_irf_shd.g_old_rec.source_criteria5
,p_source_value5_o => irc_irf_shd.g_old_rec.source_value5
,p_source_person_id_o => irc_irf_shd.g_old_rec.source_person_id
,p_candidate_comment_o => irc_irf_shd.g_old_rec.candidate_comment
,p_employee_comment_o => irc_irf_shd.g_old_rec.employee_comment
,p_irf_attribute_category_o => irc_irf_shd.g_old_rec.irf_attribute_category
,p_irf_attribute1_o => irc_irf_shd.g_old_rec.irf_attribute1
,p_irf_attribute2_o => irc_irf_shd.g_old_rec.irf_attribute2
,p_irf_attribute3_o => irc_irf_shd.g_old_rec.irf_attribute3
,p_irf_attribute4_o => irc_irf_shd.g_old_rec.irf_attribute4
,p_irf_attribute5_o => irc_irf_shd.g_old_rec.irf_attribute5
,p_irf_attribute6_o => irc_irf_shd.g_old_rec.irf_attribute6
,p_irf_attribute7_o => irc_irf_shd.g_old_rec.irf_attribute7
,p_irf_attribute8_o => irc_irf_shd.g_old_rec.irf_attribute8
,p_irf_attribute9_o => irc_irf_shd.g_old_rec.irf_attribute9
,p_irf_attribute10_o => irc_irf_shd.g_old_rec.irf_attribute10
,p_irf_information_category_o => irc_irf_shd.g_old_rec.irf_information_category
,p_irf_information1_o => irc_irf_shd.g_old_rec.irf_information1
,p_irf_information2_o => irc_irf_shd.g_old_rec.irf_information2
,p_irf_information3_o => irc_irf_shd.g_old_rec.irf_information3
,p_irf_information4_o => irc_irf_shd.g_old_rec.irf_information4
,p_irf_information5_o => irc_irf_shd.g_old_rec.irf_information5
,p_irf_information6_o => irc_irf_shd.g_old_rec.irf_information6
,p_irf_information7_o => irc_irf_shd.g_old_rec.irf_information7
,p_irf_information8_o => irc_irf_shd.g_old_rec.irf_information8
,p_irf_information9_o => irc_irf_shd.g_old_rec.irf_information9
,p_irf_information10_o => irc_irf_shd.g_old_rec.irf_information10
,p_object_created_by_o => irc_irf_shd.g_old_rec.object_created_by
,p_created_by_o => irc_irf_shd.g_old_rec.created_by
,p_object_version_number_o => irc_irf_shd.g_old_rec.object_version_number
);
End post_delete;
irc_irf_del.pre_delete
(p_rec => p_rec
,p_effective_date => p_effective_date
,p_datetrack_mode => p_datetrack_mode
,p_validation_start_date => l_validation_start_date
,p_validation_end_date => l_validation_end_date
);
irc_irf_del.delete_dml
(p_rec => p_rec
,p_effective_date => p_effective_date
,p_datetrack_mode => p_datetrack_mode
,p_validation_start_date => l_validation_start_date
,p_validation_end_date => l_validation_end_date
);
irc_irf_del.post_delete
(p_rec => p_rec
,p_effective_date => p_effective_date
,p_datetrack_mode => p_datetrack_mode
,p_validation_start_date => l_validation_start_date
,p_validation_end_date => l_validation_end_date
);