The following lines contain the word 'select', 'insert', 'update' or 'delete':
Procedure update_dml(p_rec in out nocopy pay_etm_shd.g_rec_type) is
--
l_proc varchar2(72) := g_package||'update_dml';
update pay_element_templates
set
base_processing_priority = p_rec.base_processing_priority,
version_number = p_rec.version_number,
max_base_name_length = p_rec.max_base_name_length,
preference_info_category = p_rec.preference_info_category,
preference_information1 = p_rec.preference_information1,
preference_information2 = p_rec.preference_information2,
preference_information3 = p_rec.preference_information3,
preference_information4 = p_rec.preference_information4,
preference_information5 = p_rec.preference_information5,
preference_information6 = p_rec.preference_information6,
preference_information7 = p_rec.preference_information7,
preference_information8 = p_rec.preference_information8,
preference_information9 = p_rec.preference_information9,
preference_information10 = p_rec.preference_information10,
preference_information11 = p_rec.preference_information11,
preference_information12 = p_rec.preference_information12,
preference_information13 = p_rec.preference_information13,
preference_information14 = p_rec.preference_information14,
preference_information15 = p_rec.preference_information15,
preference_information16 = p_rec.preference_information16,
preference_information17 = p_rec.preference_information17,
preference_information18 = p_rec.preference_information18,
preference_information19 = p_rec.preference_information19,
preference_information20 = p_rec.preference_information20,
preference_information21 = p_rec.preference_information21,
preference_information22 = p_rec.preference_information22,
preference_information23 = p_rec.preference_information23,
preference_information24 = p_rec.preference_information24,
preference_information25 = p_rec.preference_information25,
preference_information26 = p_rec.preference_information26,
preference_information27 = p_rec.preference_information27,
preference_information28 = p_rec.preference_information28,
preference_information29 = p_rec.preference_information29,
preference_information30 = p_rec.preference_information30,
configuration_info_category = p_rec.configuration_info_category,
configuration_information1 = p_rec.configuration_information1,
configuration_information2 = p_rec.configuration_information2,
configuration_information3 = p_rec.configuration_information3,
configuration_information4 = p_rec.configuration_information4,
configuration_information5 = p_rec.configuration_information5,
configuration_information6 = p_rec.configuration_information6,
configuration_information7 = p_rec.configuration_information7,
configuration_information8 = p_rec.configuration_information8,
configuration_information9 = p_rec.configuration_information9,
configuration_information10 = p_rec.configuration_information10,
configuration_information11 = p_rec.configuration_information11,
configuration_information12 = p_rec.configuration_information12,
configuration_information13 = p_rec.configuration_information13,
configuration_information14 = p_rec.configuration_information14,
configuration_information15 = p_rec.configuration_information15,
configuration_information16 = p_rec.configuration_information16,
configuration_information17 = p_rec.configuration_information17,
configuration_information18 = p_rec.configuration_information18,
configuration_information19 = p_rec.configuration_information19,
configuration_information20 = p_rec.configuration_information20,
configuration_information21 = p_rec.configuration_information21,
configuration_information22 = p_rec.configuration_information22,
configuration_information23 = p_rec.configuration_information23,
configuration_information24 = p_rec.configuration_information24,
configuration_information25 = p_rec.configuration_information25,
configuration_information26 = p_rec.configuration_information26,
configuration_information27 = p_rec.configuration_information27,
configuration_information28 = p_rec.configuration_information28,
configuration_information29 = p_rec.configuration_information29,
configuration_information30 = p_rec.configuration_information30,
object_version_number = p_rec.object_version_number
where template_id = p_rec.template_id;
End update_dml;
Procedure pre_update(p_rec in pay_etm_shd.g_rec_type) is
--
l_proc varchar2(72) := g_package||'pre_update';
End pre_update;
Procedure post_update(p_rec in pay_etm_shd.g_rec_type) is
--
l_proc varchar2(72) := g_package||'post_update';
End post_update;
pay_etm_bus.update_validate(p_effective_date, p_rec);
pre_update(p_rec);
update_dml(p_rec);
post_update(p_rec);