The following lines contain the word 'select', 'insert', 'update' or 'delete':
Procedure dt_update_dml
(p_rec in out nocopy pay_pbc_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 pay_balance_categories_f
set
balance_category_id = p_rec.balance_category_id
,category_name = p_rec.category_name
,legislation_code = p_rec.legislation_code
,business_group_id = p_rec.business_group_id
,save_run_balance_enabled = p_rec.save_run_balance_enabled
,user_category_name = p_rec.user_category_name
,pbc_information_category = p_rec.pbc_information_category
,pbc_information1 = p_rec.pbc_information1
,pbc_information2 = p_rec.pbc_information2
,pbc_information3 = p_rec.pbc_information3
,pbc_information4 = p_rec.pbc_information4
,pbc_information5 = p_rec.pbc_information5
,pbc_information6 = p_rec.pbc_information6
,pbc_information7 = p_rec.pbc_information7
,pbc_information8 = p_rec.pbc_information8
,pbc_information9 = p_rec.pbc_information9
,pbc_information10 = p_rec.pbc_information10
,pbc_information11 = p_rec.pbc_information11
,pbc_information12 = p_rec.pbc_information12
,pbc_information13 = p_rec.pbc_information13
,pbc_information14 = p_rec.pbc_information14
,pbc_information15 = p_rec.pbc_information15
,pbc_information16 = p_rec.pbc_information16
,pbc_information17 = p_rec.pbc_information17
,pbc_information18 = p_rec.pbc_information18
,pbc_information19 = p_rec.pbc_information19
,pbc_information20 = p_rec.pbc_information20
,pbc_information21 = p_rec.pbc_information21
,pbc_information22 = p_rec.pbc_information22
,pbc_information23 = p_rec.pbc_information23
,pbc_information24 = p_rec.pbc_information24
,pbc_information25 = p_rec.pbc_information25
,pbc_information26 = p_rec.pbc_information26
,pbc_information27 = p_rec.pbc_information27
,pbc_information28 = p_rec.pbc_information28
,pbc_information29 = p_rec.pbc_information29
,pbc_information30 = p_rec.pbc_information30
,object_version_number = p_rec.object_version_number
where balance_category_id = p_rec.balance_category_id
and effective_start_date = p_validation_start_date
and effective_end_date = p_validation_end_date;
End dt_update_dml;
Procedure update_dml
(p_rec in out nocopy pay_pbc_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';
pay_pbc_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 pay_pbc_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
--
pay_pbc_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
);
pay_pbc_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 pay_pbc_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 pay_pbc_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';
pay_pbc_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_balance_category_id => p_rec.balance_category_id
,p_effective_start_date => p_rec.effective_start_date
,p_effective_end_date => p_rec.effective_end_date
,p_save_run_balance_enabled => p_rec.save_run_balance_enabled
,p_user_category_name => p_rec.user_category_name
,p_pbc_information_category => p_rec.pbc_information_category
,p_pbc_information1 => p_rec.pbc_information1
,p_pbc_information2 => p_rec.pbc_information2
,p_pbc_information3 => p_rec.pbc_information3
,p_pbc_information4 => p_rec.pbc_information4
,p_pbc_information5 => p_rec.pbc_information5
,p_pbc_information6 => p_rec.pbc_information6
,p_pbc_information7 => p_rec.pbc_information7
,p_pbc_information8 => p_rec.pbc_information8
,p_pbc_information9 => p_rec.pbc_information9
,p_pbc_information10 => p_rec.pbc_information10
,p_pbc_information11 => p_rec.pbc_information11
,p_pbc_information12 => p_rec.pbc_information12
,p_pbc_information13 => p_rec.pbc_information13
,p_pbc_information14 => p_rec.pbc_information14
,p_pbc_information15 => p_rec.pbc_information15
,p_pbc_information16 => p_rec.pbc_information16
,p_pbc_information17 => p_rec.pbc_information17
,p_pbc_information18 => p_rec.pbc_information18
,p_pbc_information19 => p_rec.pbc_information19
,p_pbc_information20 => p_rec.pbc_information20
,p_pbc_information21 => p_rec.pbc_information21
,p_pbc_information22 => p_rec.pbc_information22
,p_pbc_information23 => p_rec.pbc_information23
,p_pbc_information24 => p_rec.pbc_information24
,p_pbc_information25 => p_rec.pbc_information25
,p_pbc_information26 => p_rec.pbc_information26
,p_pbc_information27 => p_rec.pbc_information27
,p_pbc_information28 => p_rec.pbc_information28
,p_pbc_information29 => p_rec.pbc_information29
,p_pbc_information30 => p_rec.pbc_information30
,p_object_version_number => p_rec.object_version_number
,p_category_name_o => pay_pbc_shd.g_old_rec.category_name
,p_effective_start_date_o => pay_pbc_shd.g_old_rec.effective_start_date
,p_effective_end_date_o => pay_pbc_shd.g_old_rec.effective_end_date
,p_legislation_code_o => pay_pbc_shd.g_old_rec.legislation_code
,p_business_group_id_o => pay_pbc_shd.g_old_rec.business_group_id
,p_save_run_balance_enabled_o
=> pay_pbc_shd.g_old_rec.save_run_balance_enabled
,p_user_category_name_o => pay_pbc_shd.g_old_rec.user_category_name
,p_pbc_information_category_o
=> pay_pbc_shd.g_old_rec.pbc_information_category
,p_pbc_information1_o => pay_pbc_shd.g_old_rec.pbc_information1
,p_pbc_information2_o => pay_pbc_shd.g_old_rec.pbc_information2
,p_pbc_information3_o => pay_pbc_shd.g_old_rec.pbc_information3
,p_pbc_information4_o => pay_pbc_shd.g_old_rec.pbc_information4
,p_pbc_information5_o => pay_pbc_shd.g_old_rec.pbc_information5
,p_pbc_information6_o => pay_pbc_shd.g_old_rec.pbc_information6
,p_pbc_information7_o => pay_pbc_shd.g_old_rec.pbc_information7
,p_pbc_information8_o => pay_pbc_shd.g_old_rec.pbc_information8
,p_pbc_information9_o => pay_pbc_shd.g_old_rec.pbc_information9
,p_pbc_information10_o => pay_pbc_shd.g_old_rec.pbc_information10
,p_pbc_information11_o => pay_pbc_shd.g_old_rec.pbc_information11
,p_pbc_information12_o => pay_pbc_shd.g_old_rec.pbc_information12
,p_pbc_information13_o => pay_pbc_shd.g_old_rec.pbc_information13
,p_pbc_information14_o => pay_pbc_shd.g_old_rec.pbc_information14
,p_pbc_information15_o => pay_pbc_shd.g_old_rec.pbc_information15
,p_pbc_information16_o => pay_pbc_shd.g_old_rec.pbc_information16
,p_pbc_information17_o => pay_pbc_shd.g_old_rec.pbc_information17
,p_pbc_information18_o => pay_pbc_shd.g_old_rec.pbc_information18
,p_pbc_information19_o => pay_pbc_shd.g_old_rec.pbc_information19
,p_pbc_information20_o => pay_pbc_shd.g_old_rec.pbc_information20
,p_pbc_information21_o => pay_pbc_shd.g_old_rec.pbc_information21
,p_pbc_information22_o => pay_pbc_shd.g_old_rec.pbc_information22
,p_pbc_information23_o => pay_pbc_shd.g_old_rec.pbc_information23
,p_pbc_information24_o => pay_pbc_shd.g_old_rec.pbc_information24
,p_pbc_information25_o => pay_pbc_shd.g_old_rec.pbc_information25
,p_pbc_information26_o => pay_pbc_shd.g_old_rec.pbc_information26
,p_pbc_information27_o => pay_pbc_shd.g_old_rec.pbc_information27
,p_pbc_information28_o => pay_pbc_shd.g_old_rec.pbc_information28
,p_pbc_information29_o => pay_pbc_shd.g_old_rec.pbc_information29
,p_pbc_information30_o => pay_pbc_shd.g_old_rec.pbc_information30
,p_object_version_number_o => pay_pbc_shd.g_old_rec.object_version_number
);
End post_update;
pay_pbc_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
);