The following lines contain the word 'select', 'insert', 'update' or 'delete':
Procedure delete_dml
(p_rec in hr_icx_shd.g_rec_type
) is
--
l_proc varchar2(72) := g_package||'delete_dml';
delete from hr_item_contexts
where item_context_id = p_rec.item_context_id;
End delete_dml;
Procedure pre_delete(p_rec in hr_icx_shd.g_rec_type) is
--
l_proc varchar2(72) := g_package||'pre_delete';
End pre_delete;
Procedure post_delete(p_rec in hr_icx_shd.g_rec_type) is
--
l_proc varchar2(72) := g_package||'post_delete';
hr_icx_rkd.after_delete
(p_item_context_id
=> p_rec.item_context_id
,p_object_version_number_o
=> hr_icx_shd.g_old_rec.object_version_number
,p_id_flex_num_o
=> hr_icx_shd.g_old_rec.id_flex_num
,p_summary_flag_o
=> hr_icx_shd.g_old_rec.summary_flag
,p_enabled_flag_o
=> hr_icx_shd.g_old_rec.enabled_flag
,p_start_date_active_o
=> hr_icx_shd.g_old_rec.start_date_active
,p_end_date_active_o
=> hr_icx_shd.g_old_rec.end_date_active
,p_segment1_o
=> hr_icx_shd.g_old_rec.segment1
,p_segment2_o
=> hr_icx_shd.g_old_rec.segment2
,p_segment3_o
=> hr_icx_shd.g_old_rec.segment3
,p_segment4_o
=> hr_icx_shd.g_old_rec.segment4
,p_segment5_o
=> hr_icx_shd.g_old_rec.segment5
,p_segment6_o
=> hr_icx_shd.g_old_rec.segment6
,p_segment7_o
=> hr_icx_shd.g_old_rec.segment7
,p_segment8_o
=> hr_icx_shd.g_old_rec.segment8
,p_segment9_o
=> hr_icx_shd.g_old_rec.segment9
,p_segment10_o
=> hr_icx_shd.g_old_rec.segment10
,p_segment11_o
=> hr_icx_shd.g_old_rec.segment11
,p_segment12_o
=> hr_icx_shd.g_old_rec.segment12
,p_segment13_o
=> hr_icx_shd.g_old_rec.segment13
,p_segment14_o
=> hr_icx_shd.g_old_rec.segment14
,p_segment15_o
=> hr_icx_shd.g_old_rec.segment15
,p_segment16_o
=> hr_icx_shd.g_old_rec.segment16
,p_segment17_o
=> hr_icx_shd.g_old_rec.segment17
,p_segment18_o
=> hr_icx_shd.g_old_rec.segment18
,p_segment19_o
=> hr_icx_shd.g_old_rec.segment19
,p_segment20_o
=> hr_icx_shd.g_old_rec.segment20
,p_segment21_o
=> hr_icx_shd.g_old_rec.segment21
,p_segment22_o
=> hr_icx_shd.g_old_rec.segment22
,p_segment23_o
=> hr_icx_shd.g_old_rec.segment23
,p_segment24_o
=> hr_icx_shd.g_old_rec.segment24
,p_segment25_o
=> hr_icx_shd.g_old_rec.segment25
,p_segment26_o
=> hr_icx_shd.g_old_rec.segment26
,p_segment27_o
=> hr_icx_shd.g_old_rec.segment27
,p_segment28_o
=> hr_icx_shd.g_old_rec.segment28
,p_segment29_o
=> hr_icx_shd.g_old_rec.segment29
,p_segment30_o
=> hr_icx_shd.g_old_rec.segment30
);
End post_delete;
hr_icx_bus.delete_validate(p_rec);
hr_icx_del.pre_delete(p_rec);
hr_icx_del.delete_dml(p_rec);
hr_icx_del.post_delete(p_rec);