The following lines contain the word 'select', 'insert', 'update' or 'delete':
procedure update_batch_ler_info
(p_validate in boolean default false
,p_batch_ler_id in number
,p_benefit_action_id in number default hr_api.g_number
,p_person_id in number default hr_api.g_number
,p_ler_id in number default hr_api.g_number
,p_lf_evt_ocrd_dt in date default hr_api.g_date
,p_replcd_flag in varchar2 default hr_api.g_varchar2
,p_crtd_flag in varchar2 default hr_api.g_varchar2
,p_tmprl_flag in varchar2 default hr_api.g_varchar2
,p_dltd_flag in varchar2 default hr_api.g_varchar2
,p_open_and_clsd_flag in varchar2 default hr_api.g_varchar2
,p_clsd_flag in varchar2 default hr_api.g_varchar2
,p_not_crtd_flag in varchar2 default hr_api.g_varchar2
,p_stl_actv_flag in varchar2 default hr_api.g_varchar2
,p_clpsd_flag in varchar2 default hr_api.g_varchar2
,p_clsn_flag in varchar2 default hr_api.g_varchar2
,p_no_effect_flag in varchar2 default hr_api.g_varchar2
,p_cvrge_rt_prem_flag in varchar2 default hr_api.g_varchar2
,p_per_in_ler_id in number default hr_api.g_number
,p_business_group_id in number default hr_api.g_number
,p_object_version_number in out nocopy number
,p_effective_date in date) is
--
-- Declare cursors and local variables
--
l_proc varchar2(72) := g_package||'update_batch_ler_info';
savepoint update_batch_ler_info;
ben_batch_ler_info_bk2.update_batch_ler_info_b
(p_batch_ler_id => p_batch_ler_id
,p_benefit_action_id => p_benefit_action_id
,p_person_id => p_person_id
,p_ler_id => p_ler_id
,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt
,p_replcd_flag => p_replcd_flag
,p_crtd_flag => p_crtd_flag
,p_tmprl_flag => p_tmprl_flag
,p_dltd_flag => p_dltd_flag
,p_open_and_clsd_flag => p_open_and_clsd_flag
,p_clsd_flag => p_clsd_flag
,p_not_crtd_flag => p_not_crtd_flag
,p_stl_actv_flag => p_stl_actv_flag
,p_clpsd_flag => p_clpsd_flag
,p_clsn_flag => p_clsn_flag
,p_no_effect_flag => p_no_effect_flag
,p_cvrge_rt_prem_flag => p_cvrge_rt_prem_flag
,p_per_in_ler_id => p_per_in_ler_id
,p_business_group_id => p_business_group_id
,p_object_version_number => p_object_version_number
,p_effective_date => trunc(p_effective_date));
(p_module_name => 'UPDATE_batch_ler_info'
,p_hook_type => 'BP');
ben_batch_ler_info_bk2.update_batch_ler_info_a
(p_batch_ler_id => p_batch_ler_id
,p_benefit_action_id => p_benefit_action_id
,p_person_id => p_person_id
,p_ler_id => p_ler_id
,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt
,p_replcd_flag => p_replcd_flag
,p_crtd_flag => p_crtd_flag
,p_tmprl_flag => p_tmprl_flag
,p_dltd_flag => p_dltd_flag
,p_open_and_clsd_flag => p_open_and_clsd_flag
,p_clsd_flag => p_clsd_flag
,p_not_crtd_flag => p_not_crtd_flag
,p_stl_actv_flag => p_stl_actv_flag
,p_clpsd_flag => p_clpsd_flag
,p_clsn_flag => p_clsn_flag
,p_no_effect_flag => p_no_effect_flag
,p_cvrge_rt_prem_flag => p_cvrge_rt_prem_flag
,p_per_in_ler_id => p_per_in_ler_id
,p_business_group_id => p_business_group_id
,p_object_version_number => l_object_version_number
,p_effective_date => trunc(p_effective_date));
(p_module_name => 'UPDATE_batch_ler_info'
,p_hook_type => 'AP');
ROLLBACK TO update_batch_ler_info;
ROLLBACK TO update_batch_ler_info;
end update_batch_ler_info;
procedure delete_batch_ler_info
(p_validate in boolean default false
,p_batch_ler_id in number
,p_object_version_number in out nocopy number
,p_effective_date in date) is
--
-- Declare cursors and local variables
--
l_proc varchar2(72) := g_package||'update_batch_ler_info';
savepoint delete_batch_ler_info;
ben_batch_ler_info_bk3.delete_batch_ler_info_b
(p_batch_ler_id => p_batch_ler_id
,p_object_version_number => p_object_version_number
,p_effective_date => trunc(p_effective_date));
(p_module_name => 'DELETE_batch_ler_info'
,p_hook_type => 'BP');
ben_batch_ler_info_bk3.delete_batch_ler_info_a
(p_batch_ler_id => p_batch_ler_id
,p_object_version_number => l_object_version_number
,p_effective_date => trunc(p_effective_date));
(p_module_name => 'DELETE_batch_ler_info'
,p_hook_type => 'AP');
ROLLBACK TO delete_batch_ler_info;
ROLLBACK TO delete_batch_ler_info;
end delete_batch_ler_info;