The following lines contain the word 'select', 'insert', 'update' or 'delete':
Procedure delete_dml
(p_rec in hr_tis_shd.g_rec_type
) is
--
l_proc varchar2(72) := g_package||'delete_dml';
delete from hr_ki_topic_integrations
where topic_integrations_id = p_rec.topic_integrations_id;
End delete_dml;
Procedure pre_delete(p_rec in hr_tis_shd.g_rec_type) is
--
l_proc varchar2(72) := g_package||'pre_delete';
End pre_delete;
Procedure post_delete(p_rec in hr_tis_shd.g_rec_type) is
--
l_proc varchar2(72) := g_package||'post_delete';
hr_tis_rkd.after_delete
(p_topic_integrations_id => p_rec.topic_integrations_id
,p_topic_id_o => hr_tis_shd.g_old_rec.topic_id
,p_integration_id_o => hr_tis_shd.g_old_rec.integration_id
,p_param_name1_o => hr_tis_shd.g_old_rec.param_name1
,p_param_value1_o => hr_tis_shd.g_old_rec.param_value1
,p_param_name2_o => hr_tis_shd.g_old_rec.param_name2
,p_param_value2_o => hr_tis_shd.g_old_rec.param_value2
,p_param_name3_o => hr_tis_shd.g_old_rec.param_name3
,p_param_value3_o => hr_tis_shd.g_old_rec.param_value3
,p_param_name4_o => hr_tis_shd.g_old_rec.param_name4
,p_param_value4_o => hr_tis_shd.g_old_rec.param_value4
,p_param_name5_o => hr_tis_shd.g_old_rec.param_name5
,p_param_value5_o => hr_tis_shd.g_old_rec.param_value5
,p_param_name6_o => hr_tis_shd.g_old_rec.param_name6
,p_param_value6_o => hr_tis_shd.g_old_rec.param_value6
,p_param_name7_o => hr_tis_shd.g_old_rec.param_name7
,p_param_value7_o => hr_tis_shd.g_old_rec.param_value7
,p_param_name8_o => hr_tis_shd.g_old_rec.param_name8
,p_param_value8_o => hr_tis_shd.g_old_rec.param_value8
,p_param_name9_o => hr_tis_shd.g_old_rec.param_name9
,p_param_value9_o => hr_tis_shd.g_old_rec.param_value9
,p_param_name10_o => hr_tis_shd.g_old_rec.param_name10
,p_param_value10_o => hr_tis_shd.g_old_rec.param_value10
,p_object_version_number_o => hr_tis_shd.g_old_rec.object_version_number
);
End post_delete;
hr_tis_bus.delete_validate(p_rec);
hr_tis_del.pre_delete(p_rec);
hr_tis_del.delete_dml(p_rec);
hr_tis_del.post_delete(p_rec);