The following lines contain the word 'select', 'insert', 'update' or 'delete':
select pl_id
from ben_cwb_pl_dsgn
where group_pl_id = p_group_pl_id
and pl_id <> group_pl_id -- Exclude group plan
and oipl_id = -1
and lf_evt_ocrd_dt = p_lf_evt_ocrd_dt;
select oipl_id
from ben_cwb_pl_dsgn
where pl_id = p_pl_id
and oipl_id <> -1 -- Exclude Plans
and lf_evt_ocrd_dt = p_lf_evt_ocrd_dt;
select pl_id
,oipl_id
from ben_cwb_pl_dsgn
where group_pl_id = p_group_pl_id
and oipl_id <> -1 -- Exclude Plans
and pl_id <> p_group_pl_id -- Exclude Group Options
and lf_evt_ocrd_dt = p_lf_evt_ocrd_dt;
select pl_id
,oipl_id
from ben_cwb_pl_dsgn
where group_pl_id = p_group_pl_id
and oipl_id <> -1 -- Exclude Plans
and pl_id <> p_group_pl_id -- Exclude Group Options
and group_oipl_id = p_group_oipl_id
and lf_evt_ocrd_dt = p_lf_evt_ocrd_dt;
select object_version_number
into l_ovn
from ben_cwb_pl_dsgn
where pl_id = pl.pl_id
and oipl_id = -1
and lf_evt_ocrd_dt = p_lf_evt_ocrd_dt;
update_plan_or_option
(p_call_data_syncopation => 'N' -- no recursive calls
,p_pl_id => pl.pl_id
,p_oipl_id => -1
,p_group_pl_id => p_group_pl_id
,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt
,p_effective_date => p_effective_date
,p_upd_start_dt => p_upd_start_dt
,p_upd_end_dt => p_upd_end_dt
,p_approval_mode => p_approval_mode
,p_enrt_perd_start_dt => p_enrt_perd_start_dt
,p_enrt_perd_end_dt => p_enrt_perd_end_dt
,p_yr_perd_start_dt => p_yr_perd_start_dt
,p_yr_perd_end_dt => p_yr_perd_end_dt
,p_wthn_yr_start_dt => p_wthn_yr_start_dt
,p_wthn_yr_end_dt => p_wthn_yr_end_dt
,p_perf_revw_strt_dt => p_perf_revw_strt_dt
,p_asg_updt_eff_date => p_asg_updt_eff_date
,p_emp_interview_typ_cd => p_emp_interview_typ_cd
,p_salary_change_reason => p_salary_change_reason
,p_data_freeze_date => p_data_freeze_date
,p_object_version_number => l_ovn);
select object_version_number
into l_ovn
from ben_cwb_pl_dsgn
where pl_id = p_pl_id
and oipl_id = oipl.oipl_id
and lf_evt_ocrd_dt = p_lf_evt_ocrd_dt;
update_plan_or_option
(p_call_data_syncopation => 'N' -- no recursive calls
,p_pl_id => p_pl_id
,p_oipl_id => oipl.oipl_id
,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt
,p_effective_date => p_effective_date
,p_group_pl_id => p_group_pl_id
,p_pl_uom => p_pl_uom
,p_pl_xchg_rate => p_pl_xchg_rate
,p_business_group_id => p_business_group_id
,p_actual_flag => p_actual_flag
,p_acty_ref_perd_cd => p_acty_ref_perd_cd
,p_legislation_code => p_legislation_code
,p_pl_annulization_factor => p_pl_annulization_factor
,p_pl_stat_cd => p_pl_stat_cd
,p_uom_precision => p_uom_precision
,p_object_version_number => l_ovn);
select object_version_number
into l_ovn
from ben_cwb_pl_dsgn
where pl_id = opt.pl_id
and oipl_id = opt.oipl_id
and lf_evt_ocrd_dt = p_lf_evt_ocrd_dt;
update_plan_or_option
(p_call_data_syncopation => 'N' -- no recursive calls
,p_pl_id => opt.pl_id
,p_oipl_id => opt.oipl_id
,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt
,p_effective_date => p_effective_date
,p_group_pl_id => p_group_pl_id
,p_object_version_number => l_ovn);
select object_version_number
into l_ovn
from ben_cwb_pl_dsgn
where pl_id = p_pl_id
and oipl_id = oipl.oipl_id
and lf_evt_ocrd_dt = p_lf_evt_ocrd_dt;
update_plan_or_option
(p_call_data_syncopation => 'N' -- no recursive calls
,p_pl_id => p_pl_id
,p_oipl_id => oipl.oipl_id
,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt
,p_effective_date => p_effective_date
,p_group_pl_id => p_group_pl_id
,p_pl_uom => p_pl_uom
,p_pl_ordr_num => p_pl_ordr_num
,p_pl_xchg_rate => p_pl_xchg_rate
,p_business_group_id => p_business_group_id
,p_actual_flag => p_actual_flag
,p_acty_ref_perd_cd => p_acty_ref_perd_cd
,p_legislation_code => p_legislation_code
,p_pl_annulization_factor => p_pl_annulization_factor
,p_pl_stat_cd => p_pl_stat_cd
,p_uom_precision => p_uom_precision
,p_object_version_number => l_ovn);
select object_version_number
into l_ovn
from ben_cwb_pl_dsgn
where pl_id = opt.pl_id
and oipl_id = opt.oipl_id
and lf_evt_ocrd_dt = p_lf_evt_ocrd_dt;
update_plan_or_option
(p_call_data_syncopation => 'N' -- no recursive calls
,p_pl_id => opt.pl_id
,p_oipl_id => opt.oipl_id
,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt
,p_effective_date => p_effective_date
,p_group_pl_id => p_group_pl_id
,p_group_oipl_id => p_group_oipl_id
,p_oipl_ordr_num => p_oipl_ordr_num
,p_object_version_number => l_ovn);
procedure update_plan_or_option
(p_validate in boolean default false
,p_pl_id in number
,p_oipl_id in number
,p_lf_evt_ocrd_dt in date
,p_effective_date in date default hr_api.g_date
,p_name in varchar2 default hr_api.g_varchar2
,p_group_pl_id in number default hr_api.g_number
,p_group_oipl_id in number default hr_api.g_number
,p_opt_hidden_flag in varchar2 default hr_api.g_varchar2
,p_opt_id in number default hr_api.g_number
,p_pl_uom in varchar2 default hr_api.g_varchar2
,p_pl_ordr_num in number default hr_api.g_number
,p_oipl_ordr_num in number default hr_api.g_number
,p_pl_xchg_rate in number default hr_api.g_number
,p_opt_count in number default hr_api.g_number
,p_uses_bdgt_flag in varchar2 default hr_api.g_varchar2
,p_prsrv_bdgt_cd in varchar2 default hr_api.g_varchar2
,p_upd_start_dt in date default hr_api.g_date
,p_upd_end_dt in date default hr_api.g_date
,p_approval_mode in varchar2 default hr_api.g_varchar2
,p_enrt_perd_start_dt in date default hr_api.g_date
,p_enrt_perd_end_dt in date default hr_api.g_date
,p_yr_perd_start_dt in date default hr_api.g_date
,p_yr_perd_end_dt in date default hr_api.g_date
,p_wthn_yr_start_dt in date default hr_api.g_date
,p_wthn_yr_end_dt in date default hr_api.g_date
,p_enrt_perd_id in number default hr_api.g_number
,p_yr_perd_id in number default hr_api.g_number
,p_business_group_id in number default hr_api.g_number
,p_perf_revw_strt_dt in date default hr_api.g_date
,p_asg_updt_eff_date in date default hr_api.g_date
,p_emp_interview_typ_cd in varchar2 default hr_api.g_varchar2
,p_salary_change_reason in varchar2 default hr_api.g_varchar2
,p_ws_abr_id in number default hr_api.g_number
,p_ws_nnmntry_uom in varchar2 default hr_api.g_varchar2
,p_ws_rndg_cd in varchar2 default hr_api.g_varchar2
,p_ws_sub_acty_typ_cd in varchar2 default hr_api.g_varchar2
,p_dist_bdgt_abr_id in number default hr_api.g_number
,p_dist_bdgt_nnmntry_uom in varchar2 default hr_api.g_varchar2
,p_dist_bdgt_rndg_cd in varchar2 default hr_api.g_varchar2
,p_ws_bdgt_abr_id in number default hr_api.g_number
,p_ws_bdgt_nnmntry_uom in varchar2 default hr_api.g_varchar2
,p_ws_bdgt_rndg_cd in varchar2 default hr_api.g_varchar2
,p_rsrv_abr_id in number default hr_api.g_number
,p_rsrv_nnmntry_uom in varchar2 default hr_api.g_varchar2
,p_rsrv_rndg_cd in varchar2 default hr_api.g_varchar2
,p_elig_sal_abr_id in number default hr_api.g_number
,p_elig_sal_nnmntry_uom in varchar2 default hr_api.g_varchar2
,p_elig_sal_rndg_cd in varchar2 default hr_api.g_varchar2
,p_misc1_abr_id in number default hr_api.g_number
,p_misc1_nnmntry_uom in varchar2 default hr_api.g_varchar2
,p_misc1_rndg_cd in varchar2 default hr_api.g_varchar2
,p_misc2_abr_id in number default hr_api.g_number
,p_misc2_nnmntry_uom in varchar2 default hr_api.g_varchar2
,p_misc2_rndg_cd in varchar2 default hr_api.g_varchar2
,p_misc3_abr_id in number default hr_api.g_number
,p_misc3_nnmntry_uom in varchar2 default hr_api.g_varchar2
,p_misc3_rndg_cd in varchar2 default hr_api.g_varchar2
,p_stat_sal_abr_id in number default hr_api.g_number
,p_stat_sal_nnmntry_uom in varchar2 default hr_api.g_varchar2
,p_stat_sal_rndg_cd in varchar2 default hr_api.g_varchar2
,p_rec_abr_id in number default hr_api.g_number
,p_rec_nnmntry_uom in varchar2 default hr_api.g_varchar2
,p_rec_rndg_cd in varchar2 default hr_api.g_varchar2
,p_tot_comp_abr_id in number default hr_api.g_number
,p_tot_comp_nnmntry_uom in varchar2 default hr_api.g_varchar2
,p_tot_comp_rndg_cd in varchar2 default hr_api.g_varchar2
,p_oth_comp_abr_id in number default hr_api.g_number
,p_oth_comp_nnmntry_uom in varchar2 default hr_api.g_varchar2
,p_oth_comp_rndg_cd in varchar2 default hr_api.g_varchar2
,p_actual_flag in varchar2 default hr_api.g_varchar2
,p_acty_ref_perd_cd in varchar2 default hr_api.g_varchar2
,p_legislation_code in varchar2 default hr_api.g_varchar2
,p_pl_annulization_factor in number default hr_api.g_number
,p_pl_stat_cd in varchar2 default hr_api.g_varchar2
,p_uom_precision in number default hr_api.g_number
,p_ws_element_type_id in number default hr_api.g_number
,p_ws_input_value_id in number default hr_api.g_number
,p_data_freeze_date in date default hr_api.g_date
,p_ws_amt_edit_cd in varchar2 default hr_api.g_varchar2
,p_ws_amt_edit_enf_cd_for_nul in varchar2 default hr_api.g_varchar2
,p_ws_over_budget_edit_cd in varchar2 default hr_api.g_varchar2
,p_ws_over_budget_tol_pct in number default hr_api.g_number
,p_bdgt_over_budget_edit_cd in varchar2 default hr_api.g_varchar2
,p_bdgt_over_budget_tol_pct in number default hr_api.g_number
,p_auto_distr_flag in varchar2 default hr_api.g_varchar2
,p_pqh_document_short_name in varchar2 default hr_api.g_varchar2
,p_call_data_syncopation in varchar2 default 'Y'
,p_ovrid_rt_strt_dt in date default hr_api.g_date
,p_do_not_process_flag in varchar2 default 'N'
,p_ovr_perf_revw_strt_dt in date default hr_api.g_date
,p_object_version_number in out nocopy number
) is
--
-- Declare cursors and local variables
--
l_object_version_number number;
l_proc varchar2(72) := g_package||'update_plan_or_option';
savepoint update_plan_or_option;
ben_cwb_pl_dsgn_bk2.update_plan_or_option_b
(p_pl_id => p_pl_id
,p_oipl_id => p_oipl_id
,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt
,p_effective_date => p_effective_date
,p_name => p_name
,p_group_pl_id => p_group_pl_id
,p_group_oipl_id => p_group_oipl_id
,p_opt_hidden_flag => p_opt_hidden_flag
,p_opt_id => p_opt_id
,p_pl_uom => p_pl_uom
,p_pl_ordr_num => p_pl_ordr_num
,p_oipl_ordr_num => p_oipl_ordr_num
,p_pl_xchg_rate => p_pl_xchg_rate
,p_opt_count => p_opt_count
,p_uses_bdgt_flag => p_uses_bdgt_flag
,p_prsrv_bdgt_cd => p_prsrv_bdgt_cd
,p_upd_start_dt => p_upd_start_dt
,p_upd_end_dt => p_upd_end_dt
,p_approval_mode => p_approval_mode
,p_enrt_perd_start_dt => p_enrt_perd_start_dt
,p_enrt_perd_end_dt => p_enrt_perd_end_dt
,p_yr_perd_start_dt => p_yr_perd_start_dt
,p_yr_perd_end_dt => p_yr_perd_end_dt
,p_wthn_yr_start_dt => p_wthn_yr_start_dt
,p_wthn_yr_end_dt => p_wthn_yr_end_dt
,p_enrt_perd_id => p_enrt_perd_id
,p_yr_perd_id => p_yr_perd_id
,p_business_group_id => p_business_group_id
,p_perf_revw_strt_dt => p_perf_revw_strt_dt
,p_asg_updt_eff_date => p_asg_updt_eff_date
,p_emp_interview_typ_cd => p_emp_interview_typ_cd
,p_salary_change_reason => p_salary_change_reason
,p_ws_abr_id => p_ws_abr_id
,p_ws_nnmntry_uom => p_ws_nnmntry_uom
,p_ws_rndg_cd => p_ws_rndg_cd
,p_ws_sub_acty_typ_cd => p_ws_sub_acty_typ_cd
,p_dist_bdgt_abr_id => p_dist_bdgt_abr_id
,p_dist_bdgt_nnmntry_uom => p_dist_bdgt_nnmntry_uom
,p_dist_bdgt_rndg_cd => p_dist_bdgt_rndg_cd
,p_ws_bdgt_abr_id => p_ws_bdgt_abr_id
,p_ws_bdgt_nnmntry_uom => p_ws_bdgt_nnmntry_uom
,p_ws_bdgt_rndg_cd => p_ws_bdgt_rndg_cd
,p_rsrv_abr_id => p_rsrv_abr_id
,p_rsrv_nnmntry_uom => p_rsrv_nnmntry_uom
,p_rsrv_rndg_cd => p_rsrv_rndg_cd
,p_elig_sal_abr_id => p_elig_sal_abr_id
,p_elig_sal_nnmntry_uom => p_elig_sal_nnmntry_uom
,p_elig_sal_rndg_cd => p_elig_sal_rndg_cd
,p_misc1_abr_id => p_misc1_abr_id
,p_misc1_nnmntry_uom => p_misc1_nnmntry_uom
,p_misc1_rndg_cd => p_misc1_rndg_cd
,p_misc2_abr_id => p_misc2_abr_id
,p_misc2_nnmntry_uom => p_misc2_nnmntry_uom
,p_misc2_rndg_cd => p_misc2_rndg_cd
,p_misc3_abr_id => p_misc3_abr_id
,p_misc3_nnmntry_uom => p_misc3_nnmntry_uom
,p_misc3_rndg_cd => p_misc3_rndg_cd
,p_stat_sal_abr_id => p_stat_sal_abr_id
,p_stat_sal_nnmntry_uom => p_stat_sal_nnmntry_uom
,p_stat_sal_rndg_cd => p_stat_sal_rndg_cd
,p_rec_abr_id => p_rec_abr_id
,p_rec_nnmntry_uom => p_rec_nnmntry_uom
,p_rec_rndg_cd => p_rec_rndg_cd
,p_tot_comp_abr_id => p_tot_comp_abr_id
,p_tot_comp_nnmntry_uom => p_tot_comp_nnmntry_uom
,p_tot_comp_rndg_cd => p_tot_comp_rndg_cd
,p_oth_comp_abr_id => p_oth_comp_abr_id
,p_oth_comp_nnmntry_uom => p_oth_comp_nnmntry_uom
,p_oth_comp_rndg_cd => p_oth_comp_rndg_cd
,p_actual_flag => p_actual_flag
,p_acty_ref_perd_cd => p_acty_ref_perd_cd
,p_legislation_code => p_legislation_code
,p_pl_annulization_factor => p_pl_annulization_factor
,p_pl_stat_cd => p_pl_stat_cd
,p_uom_precision => p_uom_precision
,p_ws_element_type_id => p_ws_element_type_id
,p_ws_input_value_id => p_ws_input_value_id
,p_data_freeze_date => p_data_freeze_date
,p_ws_amt_edit_cd => p_ws_amt_edit_cd
,p_ws_amt_edit_enf_cd_for_nul => p_ws_amt_edit_enf_cd_for_nul
,p_ws_over_budget_edit_cd => p_ws_over_budget_edit_cd
,p_ws_over_budget_tol_pct => p_ws_over_budget_tol_pct
,p_bdgt_over_budget_edit_cd => p_bdgt_over_budget_edit_cd
,p_bdgt_over_budget_tol_pct => p_bdgt_over_budget_tol_pct
,p_auto_distr_flag => p_auto_distr_flag
,p_pqh_document_short_name => p_pqh_document_short_name
,p_ovrid_rt_strt_dt => p_ovrid_rt_strt_dt
,p_do_not_process_flag => p_do_not_process_flag
,p_ovr_perf_revw_strt_dt => p_ovr_perf_revw_strt_dt
,p_object_version_number => l_object_version_number
);
(p_module_name => 'update_plan_or_option'
,p_hook_type => 'BP'
);
ben_cwb_pl_dsgn_bk2.update_plan_or_option_a
(p_pl_id => p_pl_id
,p_oipl_id => p_oipl_id
,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt
,p_effective_date => p_effective_date
,p_name => p_name
,p_group_pl_id => p_group_pl_id
,p_group_oipl_id => p_group_oipl_id
,p_opt_hidden_flag => p_opt_hidden_flag
,p_opt_id => p_opt_id
,p_pl_uom => p_pl_uom
,p_pl_ordr_num => p_pl_ordr_num
,p_oipl_ordr_num => p_oipl_ordr_num
,p_pl_xchg_rate => p_pl_xchg_rate
,p_opt_count => p_opt_count
,p_uses_bdgt_flag => p_uses_bdgt_flag
,p_prsrv_bdgt_cd => p_prsrv_bdgt_cd
,p_upd_start_dt => p_upd_start_dt
,p_upd_end_dt => p_upd_end_dt
,p_approval_mode => p_approval_mode
,p_enrt_perd_start_dt => p_enrt_perd_start_dt
,p_enrt_perd_end_dt => p_enrt_perd_end_dt
,p_yr_perd_start_dt => p_yr_perd_start_dt
,p_yr_perd_end_dt => p_yr_perd_end_dt
,p_wthn_yr_start_dt => p_wthn_yr_start_dt
,p_wthn_yr_end_dt => p_wthn_yr_end_dt
,p_enrt_perd_id => p_enrt_perd_id
,p_yr_perd_id => p_yr_perd_id
,p_business_group_id => p_business_group_id
,p_perf_revw_strt_dt => p_perf_revw_strt_dt
,p_asg_updt_eff_date => p_asg_updt_eff_date
,p_emp_interview_typ_cd => p_emp_interview_typ_cd
,p_salary_change_reason => p_salary_change_reason
,p_ws_abr_id => p_ws_abr_id
,p_ws_nnmntry_uom => p_ws_nnmntry_uom
,p_ws_rndg_cd => p_ws_rndg_cd
,p_ws_sub_acty_typ_cd => p_ws_sub_acty_typ_cd
,p_dist_bdgt_abr_id => p_dist_bdgt_abr_id
,p_dist_bdgt_nnmntry_uom => p_dist_bdgt_nnmntry_uom
,p_dist_bdgt_rndg_cd => p_dist_bdgt_rndg_cd
,p_ws_bdgt_abr_id => p_ws_bdgt_abr_id
,p_ws_bdgt_nnmntry_uom => p_ws_bdgt_nnmntry_uom
,p_ws_bdgt_rndg_cd => p_ws_bdgt_rndg_cd
,p_rsrv_abr_id => p_rsrv_abr_id
,p_rsrv_nnmntry_uom => p_rsrv_nnmntry_uom
,p_rsrv_rndg_cd => p_rsrv_rndg_cd
,p_elig_sal_abr_id => p_elig_sal_abr_id
,p_elig_sal_nnmntry_uom => p_elig_sal_nnmntry_uom
,p_elig_sal_rndg_cd => p_elig_sal_rndg_cd
,p_misc1_abr_id => p_misc1_abr_id
,p_misc1_nnmntry_uom => p_misc1_nnmntry_uom
,p_misc1_rndg_cd => p_misc1_rndg_cd
,p_misc2_abr_id => p_misc2_abr_id
,p_misc2_nnmntry_uom => p_misc2_nnmntry_uom
,p_misc2_rndg_cd => p_misc2_rndg_cd
,p_misc3_abr_id => p_misc3_abr_id
,p_misc3_nnmntry_uom => p_misc3_nnmntry_uom
,p_misc3_rndg_cd => p_misc3_rndg_cd
,p_stat_sal_abr_id => p_stat_sal_abr_id
,p_stat_sal_nnmntry_uom => p_stat_sal_nnmntry_uom
,p_stat_sal_rndg_cd => p_stat_sal_rndg_cd
,p_rec_abr_id => p_rec_abr_id
,p_rec_nnmntry_uom => p_rec_nnmntry_uom
,p_rec_rndg_cd => p_rec_rndg_cd
,p_tot_comp_abr_id => p_tot_comp_abr_id
,p_tot_comp_nnmntry_uom => p_tot_comp_nnmntry_uom
,p_tot_comp_rndg_cd => p_tot_comp_rndg_cd
,p_oth_comp_abr_id => p_oth_comp_abr_id
,p_oth_comp_nnmntry_uom => p_oth_comp_nnmntry_uom
,p_oth_comp_rndg_cd => p_oth_comp_rndg_cd
,p_actual_flag => p_actual_flag
,p_acty_ref_perd_cd => p_acty_ref_perd_cd
,p_legislation_code => p_legislation_code
,p_pl_annulization_factor => p_pl_annulization_factor
,p_pl_stat_cd => p_pl_stat_cd
,p_uom_precision => p_uom_precision
,p_ws_element_type_id => p_ws_element_type_id
,p_ws_input_value_id => p_ws_input_value_id
,p_data_freeze_date => p_data_freeze_date
,p_ws_amt_edit_cd => p_ws_amt_edit_cd
,p_ws_amt_edit_enf_cd_for_nul => p_ws_amt_edit_enf_cd_for_nul
,p_ws_over_budget_edit_cd => p_ws_over_budget_edit_cd
,p_ws_over_budget_tol_pct => p_ws_over_budget_tol_pct
,p_bdgt_over_budget_edit_cd => p_bdgt_over_budget_edit_cd
,p_bdgt_over_budget_tol_pct => p_bdgt_over_budget_tol_pct
,p_auto_distr_flag => p_auto_distr_flag
,p_pqh_document_short_name => p_pqh_document_short_name
,p_ovrid_rt_strt_dt => p_ovrid_rt_strt_dt
,p_do_not_process_flag => p_do_not_process_flag
,p_ovr_perf_revw_strt_dt => p_ovr_perf_revw_strt_dt
,p_object_version_number => l_object_version_number
);
(p_module_name => 'update_plan_or_option'
,p_hook_type => 'AP'
);
rollback to update_plan_or_option;
rollback to update_plan_or_option;
end update_plan_or_option;
procedure delete_plan_or_option
(p_validate in boolean default false
,p_pl_id in number
,p_oipl_id in number
,p_lf_evt_ocrd_dt in date
,p_object_version_number in number
) is
--
-- Declare cursors and local variables
--
l_object_version_number number;
l_proc varchar2(72) := g_package||'delete_plan_or_option';
savepoint delete_plan_or_option;
BEN_CWB_PL_DSGN_BK3.delete_plan_or_option_b
(p_pl_id => p_pl_id
,p_oipl_id => p_oipl_id
,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt
,p_object_version_number => l_object_version_number
);
(p_module_name => 'delete_plan_or_option'
,p_hook_type => 'BP'
);
ben_cwb_pl_dsgn_bk3.delete_plan_or_option_a
(p_pl_id => p_pl_id
,p_oipl_id => p_oipl_id
,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt
,p_object_version_number => l_object_version_number
);
(p_module_name => 'delete_plan_or_option'
,p_hook_type => 'AP'
);
rollback to delete_plan_or_option;
rollback to delete_plan_or_option;
end delete_plan_or_option;