The following lines contain the word 'select', 'insert', 'update' or 'delete':
procedure update_batch_proc_info
(p_validate in boolean default false
,p_batch_proc_id in number
,p_benefit_action_id in number default hr_api.g_number
,p_strt_dt in date default hr_api.g_date
,p_end_dt in date default hr_api.g_date
,p_strt_tm in varchar2 default hr_api.g_varchar2
,p_end_tm in varchar2 default hr_api.g_varchar2
,p_elpsd_tm in varchar2 default hr_api.g_varchar2
,p_per_slctd in number default hr_api.g_number
,p_per_proc in number default hr_api.g_number
,p_per_unproc in number default hr_api.g_number
,p_per_proc_succ in number default hr_api.g_number
,p_per_err 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) is
--
-- Declare cursors and local variables
--
l_proc varchar2(72) := g_package||'update_batch_proc_info';
savepoint update_batch_proc_info;
ben_batch_proc_info_bk2.update_batch_proc_info_b
(p_batch_proc_id => p_batch_proc_id
,p_benefit_action_id => p_benefit_action_id
,p_strt_dt => p_strt_dt
,p_end_dt => p_end_dt
,p_strt_tm => p_strt_tm
,p_end_tm => p_end_tm
,p_elpsd_tm => p_elpsd_tm
,p_per_slctd => p_per_slctd
,p_per_proc => p_per_proc
,p_per_unproc => p_per_unproc
,p_per_proc_succ => p_per_proc_succ
,p_per_err => p_per_err
,p_business_group_id => p_business_group_id
,p_object_version_number => p_object_version_number);
(p_module_name => 'UPDATE_batch_proc_info'
,p_hook_type => 'BP');
ben_batch_proc_info_bk2.update_batch_proc_info_a
(p_batch_proc_id => p_batch_proc_id
,p_benefit_action_id => p_benefit_action_id
,p_strt_dt => p_strt_dt
,p_end_dt => p_end_dt
,p_strt_tm => p_strt_tm
,p_end_tm => p_end_tm
,p_elpsd_tm => p_elpsd_tm
,p_per_slctd => p_per_slctd
,p_per_proc => p_per_proc
,p_per_unproc => p_per_unproc
,p_per_proc_succ => p_per_proc_succ
,p_per_err => p_per_err
,p_business_group_id => p_business_group_id
,p_object_version_number => l_object_version_number);
(p_module_name => 'UPDATE_batch_proc_info'
,p_hook_type => 'AP');
ROLLBACK TO update_batch_proc_info;
ROLLBACK TO update_batch_proc_info;
end update_batch_proc_info;
procedure delete_batch_proc_info
(p_validate in boolean default false
,p_batch_proc_id in number
,p_object_version_number in out nocopy number) is
--
-- Declare cursors and local variables
--
l_proc varchar2(72) := g_package||'update_batch_proc_info';
savepoint delete_batch_proc_info;
ben_batch_proc_info_bk3.delete_batch_proc_info_b
(p_batch_proc_id => p_batch_proc_id
,p_object_version_number => p_object_version_number);
(p_module_name => 'DELETE_batch_proc_info'
,p_hook_type => 'BP');
ben_batch_proc_info_bk3.delete_batch_proc_info_a
(p_batch_proc_id => p_batch_proc_id
,p_object_version_number => l_object_version_number);
(p_module_name => 'DELETE_batch_proc_info'
,p_hook_type => 'AP');
ROLLBACK TO delete_batch_proc_info;
ROLLBACK TO delete_batch_proc_info;
end delete_batch_proc_info;