The following lines contain the word 'select', 'insert', 'update' or 'delete':
Procedure update_dml
(p_rec in out nocopy hr_icx_shd.g_rec_type
) is
--
l_proc varchar2(72) := g_package||'update_dml';
update hr_item_contexts
set
item_context_id = p_rec.item_context_id
,object_version_number = p_rec.object_version_number
,id_flex_num = p_rec.id_flex_num
,summary_flag = p_rec.summary_flag
,enabled_flag = p_rec.enabled_flag
,start_date_active = p_rec.start_date_active
,end_date_active = p_rec.end_date_active
,segment1 = p_rec.segment1
,segment2 = p_rec.segment2
,segment3 = p_rec.segment3
,segment4 = p_rec.segment4
,segment5 = p_rec.segment5
,segment6 = p_rec.segment6
,segment7 = p_rec.segment7
,segment8 = p_rec.segment8
,segment9 = p_rec.segment9
,segment10 = p_rec.segment10
,segment11 = p_rec.segment11
,segment12 = p_rec.segment12
,segment13 = p_rec.segment13
,segment14 = p_rec.segment14
,segment15 = p_rec.segment15
,segment16 = p_rec.segment16
,segment17 = p_rec.segment17
,segment18 = p_rec.segment18
,segment19 = p_rec.segment19
,segment20 = p_rec.segment20
,segment21 = p_rec.segment21
,segment22 = p_rec.segment22
,segment23 = p_rec.segment23
,segment24 = p_rec.segment24
,segment25 = p_rec.segment25
,segment26 = p_rec.segment26
,segment27 = p_rec.segment27
,segment28 = p_rec.segment28
,segment29 = p_rec.segment29
,segment30 = p_rec.segment30
where item_context_id = p_rec.item_context_id;
End update_dml;
Procedure pre_update
(p_rec in hr_icx_shd.g_rec_type
) is
--
l_proc varchar2(72) := g_package||'pre_update';
End pre_update;
Procedure post_update
(p_effective_date in date
,p_rec in hr_icx_shd.g_rec_type
) is
--
l_proc varchar2(72) := g_package||'post_update';
hr_icx_rku.after_update
(p_effective_date => p_effective_date
,p_object_version_number
=> p_rec.object_version_number
,p_item_context_id
=> p_rec.item_context_id
,p_id_flex_num
=> p_rec.id_flex_num
,p_summary_flag
=> p_rec.summary_flag
,p_enabled_flag
=> p_rec.enabled_flag
,p_start_date_active
=> p_rec.start_date_active
,p_end_date_active
=> p_rec.end_date_active
,p_segment1
=> p_rec.segment1
,p_segment2
=> p_rec.segment2
,p_segment3
=> p_rec.segment3
,p_segment4
=> p_rec.segment4
,p_segment5
=> p_rec.segment5
,p_segment6
=> p_rec.segment6
,p_segment7
=> p_rec.segment7
,p_segment8
=> p_rec.segment8
,p_segment9
=> p_rec.segment9
,p_segment10
=> p_rec.segment10
,p_segment11
=> p_rec.segment11
,p_segment12
=> p_rec.segment12
,p_segment13
=> p_rec.segment13
,p_segment14
=> p_rec.segment14
,p_segment15
=> p_rec.segment15
,p_segment16
=> p_rec.segment16
,p_segment17
=> p_rec.segment17
,p_segment18
=> p_rec.segment18
,p_segment19
=> p_rec.segment19
,p_segment20
=> p_rec.segment20
,p_segment21
=> p_rec.segment21
,p_segment22
=> p_rec.segment22
,p_segment23
=> p_rec.segment23
,p_segment24
=> p_rec.segment24
,p_segment25
=> p_rec.segment25
,p_segment26
=> p_rec.segment26
,p_segment27
=> p_rec.segment27
,p_segment28
=> p_rec.segment28
,p_segment29
=> p_rec.segment29
,p_segment30
=> p_rec.segment30
,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_update;
SELECT id_flex_num
FROM fnd_id_flex_structures
WHERE id_flex_structure_code = p_context_type
AND application_id = 800
AND id_flex_code = 'ICX';
hr_icx_bus.update_validate
(p_effective_date
,p_rec
);
hr_icx_upd.pre_update(p_rec);
hr_icx_upd.update_dml(p_rec);
hr_icx_upd.post_update
(p_effective_date
,p_rec
);