The following lines contain the word 'select', 'insert', 'update' or 'delete':
Procedure update_dml
(p_rec in out nocopy hxc_htr_shd.g_rec_type
) is
--
l_proc varchar2(72);
l_proc := g_package||'update_dml';
update hxc_time_recipients
set
time_recipient_id = p_rec.time_recipient_id
,name = p_rec.name
,application_id = p_rec.application_id
,object_version_number = p_rec.object_version_number
,application_retrieval_function = p_rec.application_retrieval_function
,application_update_process = p_rec.application_update_process
,appl_validation_process = p_rec.appl_validation_process
,application_period_function = p_rec.application_period_function
,appl_dynamic_template_process = p_rec.appl_dynamic_template_process
,extension_function1 = p_rec.extension_function1
,extension_function2 = p_rec.extension_function2
,last_updated_by = fnd_global.user_id
,last_update_date = sysdate
,last_update_login = fnd_global.login_id
where time_recipient_id = p_rec.time_recipient_id;
End update_dml;
Procedure pre_update
(p_rec in hxc_htr_shd.g_rec_type
) is
--
l_proc varchar2(72);
l_proc := g_package||'pre_update';
End pre_update;
Procedure post_update
(p_effective_date in date
,p_rec in hxc_htr_shd.g_rec_type
) is
--
l_proc varchar2(72);
l_proc := g_package||'post_update';
hxc_htr_rku.after_update
(p_effective_date => p_effective_date
,p_time_recipient_id
=> p_rec.time_recipient_id
,p_name
=> p_rec.name
,p_appl_retrieval_function
=> p_rec.application_retrieval_function
,p_appl_update_process
=> p_rec.application_update_process
,p_appl_validation_process
=> p_rec.appl_validation_process
,p_appl_period_function
=> p_rec.application_period_function
,p_appl_dyn_template_process
=> p_rec.appl_dynamic_template_process
,p_extension_function1
=> p_rec.extension_function1
,p_extension_function2
=> p_rec.extension_function2
,p_application_id
=> p_rec.application_id
,p_object_version_number
=> p_rec.object_version_number
,p_name_o
=> hxc_htr_shd.g_old_rec.name
,p_appl_retrieval_function_o
=> hxc_htr_shd.g_old_rec.application_retrieval_function
,p_appl_update_process_o
=> hxc_htr_shd.g_old_rec.application_update_process
,p_appl_validation_process_o
=> hxc_htr_shd.g_old_rec.appl_validation_process
,p_appl_period_function_o
=> hxc_htr_shd.g_old_rec.application_period_function
,p_appl_dyn_template_process_o
=> hxc_htr_shd.g_old_rec.appl_dynamic_template_process
,p_extension_function1_o
=> hxc_htr_shd.g_old_rec.extension_function1
,p_extension_function2_o
=> hxc_htr_shd.g_old_rec.extension_function2
,p_application_id_o
=> hxc_htr_shd.g_old_rec.application_id
,p_object_version_number_o
=> hxc_htr_shd.g_old_rec.object_version_number
);
End post_update;
hxc_htr_bus.update_validate
(p_effective_date
,p_rec
);
hxc_htr_upd.pre_update(p_rec);
hxc_htr_upd.update_dml(p_rec);
hxc_htr_upd.post_update
(p_effective_date
,p_rec
);
,p_appl_update_process in varchar2 default NULL
,p_appl_validation_process in varchar2 default NULL
,p_appl_period_function in varchar2 default NULL
,p_appl_dyn_template_process in varchar2 default NULL
,p_extension_function1 in varchar2 default NULL
,p_extension_function2 in varchar2 default NULL
,p_object_version_number in out nocopy number
,p_name in varchar2 default hr_api.g_varchar2
,p_application_id in number default hr_api.g_number
) is
--
l_rec hxc_htr_shd.g_rec_type;
,p_appl_update_process
,p_appl_validation_process
,p_appl_period_function
,p_appl_dyn_template_process
,p_extension_function1
,p_extension_function2
,p_application_id
,p_object_version_number
);