The following lines contain the word 'select', 'insert', 'update' or 'delete':
Procedure dt_insert_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
-- Cursor to select 'old' created AOL who column values
--
Cursor C_Sel1 Is
select t.creation_date
from irc_referral_info t
where t.referral_info_id = p_rec.referral_info_id
and t.start_date =
irc_irf_shd.g_old_rec.start_date
and t.end_date = p_validation_start_date;
l_proc varchar2(72) := g_package||'dt_insert_dml';
If (p_datetrack_mode <> hr_api.g_insert) then
hr_utility.set_location(l_proc, 10);
insert into irc_referral_info
(referral_info_id
,object_id
,object_type
,start_date
,end_date
,source_type
,source_name
,source_criteria1
,source_value1
,source_criteria2
,source_value2
,source_criteria3
,source_value3
,source_criteria4
,source_value4
,source_criteria5
,source_value5
,source_person_id
,candidate_comment
,employee_comment
,irf_attribute_category
,irf_attribute1
,irf_attribute2
,irf_attribute3
,irf_attribute4
,irf_attribute5
,irf_attribute6
,irf_attribute7
,irf_attribute8
,irf_attribute9
,irf_attribute10
,irf_information_category
,irf_information1
,irf_information2
,irf_information3
,irf_information4
,irf_information5
,irf_information6
,irf_information7
,irf_information8
,irf_information9
,irf_information10
,object_created_by
,created_by
,object_version_number
)
Values
(p_rec.referral_info_id
,p_rec.object_id
,p_rec.object_type
,p_rec.start_date
,p_rec.end_date
,p_rec.source_type
,p_rec.source_name
,p_rec.source_criteria1
,p_rec.source_value1
,p_rec.source_criteria2
,p_rec.source_value2
,p_rec.source_criteria3
,p_rec.source_value3
,p_rec.source_criteria4
,p_rec.source_value4
,p_rec.source_criteria5
,p_rec.source_value5
,p_rec.source_person_id
,p_rec.candidate_comment
,p_rec.employee_comment
,p_rec.irf_attribute_category
,p_rec.irf_attribute1
,p_rec.irf_attribute2
,p_rec.irf_attribute3
,p_rec.irf_attribute4
,p_rec.irf_attribute5
,p_rec.irf_attribute6
,p_rec.irf_attribute7
,p_rec.irf_attribute8
,p_rec.irf_attribute9
,p_rec.irf_attribute10
,p_rec.irf_information_category
,p_rec.irf_information1
,p_rec.irf_information2
,p_rec.irf_information3
,p_rec.irf_information4
,p_rec.irf_information5
,p_rec.irf_information6
,p_rec.irf_information7
,p_rec.irf_information8
,p_rec.irf_information9
,p_rec.irf_information10
,p_rec.object_created_by
,p_rec.created_by
,p_rec.object_version_number
);
End dt_insert_dml;
Procedure insert_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||'insert_dml';
irc_irf_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 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
--
Cursor C_Sel1 is select irc_referral_info_s.nextval from sys.dual;
Select null
from irc_referral_info
where object_id = p_rec.object_id
and object_type = p_rec.object_type
and p_effective_date between start_date
and end_date;
l_proc varchar2(72) := g_package||'pre_insert';
End pre_insert;
Procedure post_insert
(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_insert';
irc_irf_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_referral_info_id => p_rec.referral_info_id
,p_object_id => p_rec.object_id
,p_object_type => p_rec.object_type
,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
);
End post_insert;
l_datetrack_mode varchar2(30) := hr_api.g_insert;
irc_irf_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
);
irc_irf_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
);
irc_irf_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
);
irc_irf_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
);