The following lines contain the word 'select', 'insert', 'update' or 'delete':
Procedure dt_update_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_update_dml';
update irc_referral_info
set
referral_info_id = p_rec.referral_info_id
,start_date = p_rec.start_date
,end_date = p_rec.end_date
,source_type = p_rec.source_type
,source_name = p_rec.source_name
,source_criteria1 = p_rec.source_criteria1
,source_value1 = p_rec.source_value1
,source_criteria2 = p_rec.source_criteria2
,source_value2 = p_rec.source_value2
,source_criteria3 = p_rec.source_criteria3
,source_value3 = p_rec.source_value3
,source_criteria4 = p_rec.source_criteria4
,source_value4 = p_rec.source_value4
,source_criteria5 = p_rec.source_criteria5
,source_value5 = p_rec.source_value5
,source_person_id = p_rec.source_person_id
,candidate_comment = p_rec.candidate_comment
,employee_comment = p_rec.employee_comment
,irf_attribute_category = p_rec.irf_attribute_category
,irf_attribute1 = p_rec.irf_attribute1
,irf_attribute2 = p_rec.irf_attribute2
,irf_attribute3 = p_rec.irf_attribute3
,irf_attribute4 = p_rec.irf_attribute4
,irf_attribute5 = p_rec.irf_attribute5
,irf_attribute6 = p_rec.irf_attribute6
,irf_attribute7 = p_rec.irf_attribute7
,irf_attribute8 = p_rec.irf_attribute8
,irf_attribute9 = p_rec.irf_attribute9
,irf_attribute10 = p_rec.irf_attribute10
,irf_information_category = p_rec.irf_information_category
,irf_information1 = p_rec.irf_information1
,irf_information2 = p_rec.irf_information2
,irf_information3 = p_rec.irf_information3
,irf_information4 = p_rec.irf_information4
,irf_information5 = p_rec.irf_information5
,irf_information6 = p_rec.irf_information6
,irf_information7 = p_rec.irf_information7
,irf_information8 = p_rec.irf_information8
,irf_information9 = p_rec.irf_information9
,irf_information10 = p_rec.irf_information10
,object_created_by = p_rec.object_created_by
,object_version_number = p_rec.object_version_number
where referral_info_id = p_rec.referral_info_id
and start_date = p_validation_start_date
and ((p_validation_end_date is null and end_date is null) or
(end_date = p_validation_end_date));
End dt_update_dml;
Procedure update_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||'update_dml';
irc_irf_upd.dt_update_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 update_dml;
Procedure dt_pre_update
(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_update';
If (p_datetrack_mode = hr_api.g_update_override) then
--
-- As the datetrack mode is 'UPDATE_OVERRIDE' then we must
-- delete any future rows
--
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 => p_validation_start_date
,p_validation_end_date => p_validation_end_date
);
irc_irf_ins.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 dt_pre_update;
Procedure pre_update
(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_update';
dt_pre_update
(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_update;
Procedure post_update
(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_update';
irc_irf_rku.after_update
(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_source_type => p_rec.source_type
,p_source_name => p_rec.source_name
,p_source_criteria1 => p_rec.source_criteria1
,p_source_value1 => p_rec.source_value1
,p_source_criteria2 => p_rec.source_criteria2
,p_source_value2 => p_rec.source_value2
,p_source_criteria3 => p_rec.source_criteria3
,p_source_value3 => p_rec.source_value3
,p_source_criteria4 => p_rec.source_criteria4
,p_source_value4 => p_rec.source_value4
,p_source_criteria5 => p_rec.source_criteria5
,p_source_value5 => p_rec.source_value5
,p_source_person_id => p_rec.source_person_id
,p_candidate_comment => p_rec.candidate_comment
,p_employee_comment => p_rec.employee_comment
,p_irf_attribute_category => p_rec.irf_attribute_category
,p_irf_attribute1 => p_rec.irf_attribute1
,p_irf_attribute2 => p_rec.irf_attribute2
,p_irf_attribute3 => p_rec.irf_attribute3
,p_irf_attribute4 => p_rec.irf_attribute4
,p_irf_attribute5 => p_rec.irf_attribute5
,p_irf_attribute6 => p_rec.irf_attribute6
,p_irf_attribute7 => p_rec.irf_attribute7
,p_irf_attribute8 => p_rec.irf_attribute8
,p_irf_attribute9 => p_rec.irf_attribute9
,p_irf_attribute10 => p_rec.irf_attribute10
,p_irf_information_category => p_rec.irf_information_category
,p_irf_information1 => p_rec.irf_information1
,p_irf_information2 => p_rec.irf_information2
,p_irf_information3 => p_rec.irf_information3
,p_irf_information4 => p_rec.irf_information4
,p_irf_information5 => p_rec.irf_information5
,p_irf_information6 => p_rec.irf_information6
,p_irf_information7 => p_rec.irf_information7
,p_irf_information8 => p_rec.irf_information8
,p_irf_information9 => p_rec.irf_information9
,p_irf_information10 => p_rec.irf_information10
,p_object_created_by => p_rec.object_created_by
,p_created_by => p_rec.created_by
,p_object_version_number => p_rec.object_version_number
,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_update;
irc_irf_bus.update_validate
(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
);
pre_update
(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
);
update_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
);
post_update
(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
);