[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
Procedure insert_dml
(p_rec in out nocopy ben_cpd_shd.g_rec_type
) is
--
l_proc varchar2(72) := g_package||'insert_dml';
insert into ben_cwb_pl_dsgn
(pl_id
,lf_evt_ocrd_dt
,oipl_id
,effective_date
,name
,group_pl_id
,group_oipl_id
,opt_hidden_flag
,opt_id
,pl_uom
,pl_ordr_num
,oipl_ordr_num
,pl_xchg_rate
,opt_count
,uses_bdgt_flag
,prsrv_bdgt_cd
,upd_start_dt
,upd_end_dt
,approval_mode
,enrt_perd_start_dt
,enrt_perd_end_dt
,yr_perd_start_dt
,yr_perd_end_dt
,wthn_yr_start_dt
,wthn_yr_end_dt
,enrt_perd_id
,yr_perd_id
,business_group_id
,perf_revw_strt_dt
,asg_updt_eff_date
,emp_interview_typ_cd
,salary_change_reason
,ws_abr_id
,ws_nnmntry_uom
,ws_rndg_cd
,ws_sub_acty_typ_cd
,dist_bdgt_abr_id
,dist_bdgt_nnmntry_uom
,dist_bdgt_rndg_cd
,ws_bdgt_abr_id
,ws_bdgt_nnmntry_uom
,ws_bdgt_rndg_cd
,rsrv_abr_id
,rsrv_nnmntry_uom
,rsrv_rndg_cd
,elig_sal_abr_id
,elig_sal_nnmntry_uom
,elig_sal_rndg_cd
,misc1_abr_id
,misc1_nnmntry_uom
,misc1_rndg_cd
,misc2_abr_id
,misc2_nnmntry_uom
,misc2_rndg_cd
,misc3_abr_id
,misc3_nnmntry_uom
,misc3_rndg_cd
,stat_sal_abr_id
,stat_sal_nnmntry_uom
,stat_sal_rndg_cd
,rec_abr_id
,rec_nnmntry_uom
,rec_rndg_cd
,tot_comp_abr_id
,tot_comp_nnmntry_uom
,tot_comp_rndg_cd
,oth_comp_abr_id
,oth_comp_nnmntry_uom
,oth_comp_rndg_cd
,actual_flag
,acty_ref_perd_cd
,legislation_code
,pl_annulization_factor
,pl_stat_cd
,uom_precision
,ws_element_type_id
,ws_input_value_id
,data_freeze_date
,ws_amt_edit_cd
,ws_amt_edit_enf_cd_for_nulls
,ws_over_budget_edit_cd
,ws_over_budget_tolerance_pct
,bdgt_over_budget_edit_cd
,bdgt_over_budget_tolerance_pct
,auto_distr_flag
,pqh_document_short_name
,ovrid_rt_strt_dt
,do_not_process_flag
,ovr_perf_revw_strt_dt
,object_version_number
)
Values
(p_rec.pl_id
,p_rec.lf_evt_ocrd_dt
,p_rec.oipl_id
,p_rec.effective_date
,p_rec.name
,p_rec.group_pl_id
,p_rec.group_oipl_id
,p_rec.opt_hidden_flag
,p_rec.opt_id
,p_rec.pl_uom
,p_rec.pl_ordr_num
,p_rec.oipl_ordr_num
,p_rec.pl_xchg_rate
,p_rec.opt_count
,p_rec.uses_bdgt_flag
,p_rec.prsrv_bdgt_cd
,p_rec.upd_start_dt
,p_rec.upd_end_dt
,p_rec.approval_mode
,p_rec.enrt_perd_start_dt
,p_rec.enrt_perd_end_dt
,p_rec.yr_perd_start_dt
,p_rec.yr_perd_end_dt
,p_rec.wthn_yr_start_dt
,p_rec.wthn_yr_end_dt
,p_rec.enrt_perd_id
,p_rec.yr_perd_id
,p_rec.business_group_id
,p_rec.perf_revw_strt_dt
,p_rec.asg_updt_eff_date
,p_rec.emp_interview_typ_cd
,p_rec.salary_change_reason
,p_rec.ws_abr_id
,p_rec.ws_nnmntry_uom
,p_rec.ws_rndg_cd
,p_rec.ws_sub_acty_typ_cd
,p_rec.dist_bdgt_abr_id
,p_rec.dist_bdgt_nnmntry_uom
,p_rec.dist_bdgt_rndg_cd
,p_rec.ws_bdgt_abr_id
,p_rec.ws_bdgt_nnmntry_uom
,p_rec.ws_bdgt_rndg_cd
,p_rec.rsrv_abr_id
,p_rec.rsrv_nnmntry_uom
,p_rec.rsrv_rndg_cd
,p_rec.elig_sal_abr_id
,p_rec.elig_sal_nnmntry_uom
,p_rec.elig_sal_rndg_cd
,p_rec.misc1_abr_id
,p_rec.misc1_nnmntry_uom
,p_rec.misc1_rndg_cd
,p_rec.misc2_abr_id
,p_rec.misc2_nnmntry_uom
,p_rec.misc2_rndg_cd
,p_rec.misc3_abr_id
,p_rec.misc3_nnmntry_uom
,p_rec.misc3_rndg_cd
,p_rec.stat_sal_abr_id
,p_rec.stat_sal_nnmntry_uom
,p_rec.stat_sal_rndg_cd
,p_rec.rec_abr_id
,p_rec.rec_nnmntry_uom
,p_rec.rec_rndg_cd
,p_rec.tot_comp_abr_id
,p_rec.tot_comp_nnmntry_uom
,p_rec.tot_comp_rndg_cd
,p_rec.oth_comp_abr_id
,p_rec.oth_comp_nnmntry_uom
,p_rec.oth_comp_rndg_cd
,p_rec.actual_flag
,p_rec.acty_ref_perd_cd
,p_rec.legislation_code
,p_rec.pl_annulization_factor
,p_rec.pl_stat_cd
,p_rec.uom_precision
,p_rec.ws_element_type_id
,p_rec.ws_input_value_id
,p_rec.data_freeze_date
,p_rec.ws_amt_edit_cd
,p_rec.ws_amt_edit_enf_cd_for_nulls
,p_rec.ws_over_budget_edit_cd
,p_rec.ws_over_budget_tolerance_pct
,p_rec.bdgt_over_budget_edit_cd
,p_rec.bdgt_over_budget_tolerance_pct
,p_rec.auto_distr_flag
,p_rec.pqh_document_short_name
,p_rec.ovrid_rt_strt_dt
,p_rec.do_not_process_flag
,p_rec.ovr_perf_revw_strt_dt
,p_rec.object_version_number
);
End insert_dml;
Procedure pre_insert
(p_rec in out nocopy ben_cpd_shd.g_rec_type
) is
--
Cursor C_Sel1 is
Select null
from ben_cwb_pl_dsgn
where pl_id =
ben_cpd_ins.g_pl_id_i
or lf_evt_ocrd_dt =
ben_cpd_ins.g_lf_evt_ocrd_dt_i
or oipl_id =
ben_cpd_ins.g_oipl_id_i;
l_proc varchar2(72) := g_package||'pre_insert';
End pre_insert;
Procedure post_insert
(p_rec in ben_cpd_shd.g_rec_type
) is
--
l_proc varchar2(72) := g_package||'post_insert';
ben_cpd_rki.after_insert
(p_pl_id
=> p_rec.pl_id
,p_lf_evt_ocrd_dt
=> p_rec.lf_evt_ocrd_dt
,p_oipl_id
=> p_rec.oipl_id
,p_effective_date
=> p_rec.effective_date
,p_name
=> p_rec.name
,p_group_pl_id
=> p_rec.group_pl_id
,p_group_oipl_id
=> p_rec.group_oipl_id
,p_opt_hidden_flag
=> p_rec.opt_hidden_flag
,p_opt_id
=> p_rec.opt_id
,p_pl_uom
=> p_rec.pl_uom
,p_pl_ordr_num
=> p_rec.pl_ordr_num
,p_oipl_ordr_num
=> p_rec.oipl_ordr_num
,p_pl_xchg_rate
=> p_rec.pl_xchg_rate
,p_opt_count
=> p_rec.opt_count
,p_uses_bdgt_flag
=> p_rec.uses_bdgt_flag
,p_prsrv_bdgt_cd
=> p_rec.prsrv_bdgt_cd
,p_upd_start_dt
=> p_rec.upd_start_dt
,p_upd_end_dt
=> p_rec.upd_end_dt
,p_approval_mode
=> p_rec.approval_mode
,p_enrt_perd_start_dt
=> p_rec.enrt_perd_start_dt
,p_enrt_perd_end_dt
=> p_rec.enrt_perd_end_dt
,p_yr_perd_start_dt
=> p_rec.yr_perd_start_dt
,p_yr_perd_end_dt
=> p_rec.yr_perd_end_dt
,p_wthn_yr_start_dt
=> p_rec.wthn_yr_start_dt
,p_wthn_yr_end_dt
=> p_rec.wthn_yr_end_dt
,p_enrt_perd_id
=> p_rec.enrt_perd_id
,p_yr_perd_id
=> p_rec.yr_perd_id
,p_business_group_id
=> p_rec.business_group_id
,p_perf_revw_strt_dt
=> p_rec.perf_revw_strt_dt
,p_asg_updt_eff_date
=> p_rec.asg_updt_eff_date
,p_emp_interview_typ_cd
=> p_rec.emp_interview_typ_cd
,p_salary_change_reason
=> p_rec.salary_change_reason
,p_ws_abr_id
=> p_rec.ws_abr_id
,p_ws_nnmntry_uom
=> p_rec.ws_nnmntry_uom
,p_ws_rndg_cd
=> p_rec.ws_rndg_cd
,p_ws_sub_acty_typ_cd
=> p_rec.ws_sub_acty_typ_cd
,p_dist_bdgt_abr_id
=> p_rec.dist_bdgt_abr_id
,p_dist_bdgt_nnmntry_uom
=> p_rec.dist_bdgt_nnmntry_uom
,p_dist_bdgt_rndg_cd
=> p_rec.dist_bdgt_rndg_cd
,p_ws_bdgt_abr_id
=> p_rec.ws_bdgt_abr_id
,p_ws_bdgt_nnmntry_uom
=> p_rec.ws_bdgt_nnmntry_uom
,p_ws_bdgt_rndg_cd
=> p_rec.ws_bdgt_rndg_cd
,p_rsrv_abr_id
=> p_rec.rsrv_abr_id
,p_rsrv_nnmntry_uom
=> p_rec.rsrv_nnmntry_uom
,p_rsrv_rndg_cd
=> p_rec.rsrv_rndg_cd
,p_elig_sal_abr_id
=> p_rec.elig_sal_abr_id
,p_elig_sal_nnmntry_uom
=> p_rec.elig_sal_nnmntry_uom
,p_elig_sal_rndg_cd
=> p_rec.elig_sal_rndg_cd
,p_misc1_abr_id
=> p_rec.misc1_abr_id
,p_misc1_nnmntry_uom
=> p_rec.misc1_nnmntry_uom
,p_misc1_rndg_cd
=> p_rec.misc1_rndg_cd
,p_misc2_abr_id
=> p_rec.misc2_abr_id
,p_misc2_nnmntry_uom
=> p_rec.misc2_nnmntry_uom
,p_misc2_rndg_cd
=> p_rec.misc2_rndg_cd
,p_misc3_abr_id
=> p_rec.misc3_abr_id
,p_misc3_nnmntry_uom
=> p_rec.misc3_nnmntry_uom
,p_misc3_rndg_cd
=> p_rec.misc3_rndg_cd
,p_stat_sal_abr_id
=> p_rec.stat_sal_abr_id
,p_stat_sal_nnmntry_uom
=> p_rec.stat_sal_nnmntry_uom
,p_stat_sal_rndg_cd
=> p_rec.stat_sal_rndg_cd
,p_rec_abr_id
=> p_rec.rec_abr_id
,p_rec_nnmntry_uom
=> p_rec.rec_nnmntry_uom
,p_rec_rndg_cd
=> p_rec.rec_rndg_cd
,p_tot_comp_abr_id
=> p_rec.tot_comp_abr_id
,p_tot_comp_nnmntry_uom
=> p_rec.tot_comp_nnmntry_uom
,p_tot_comp_rndg_cd
=> p_rec.tot_comp_rndg_cd
,p_oth_comp_abr_id
=> p_rec.oth_comp_abr_id
,p_oth_comp_nnmntry_uom
=> p_rec.oth_comp_nnmntry_uom
,p_oth_comp_rndg_cd
=> p_rec.oth_comp_rndg_cd
,p_actual_flag
=> p_rec.actual_flag
,p_acty_ref_perd_cd
=> p_rec.acty_ref_perd_cd
,p_legislation_code
=> p_rec.legislation_code
,p_pl_annulization_factor
=> p_rec.pl_annulization_factor
,p_pl_stat_cd
=> p_rec.pl_stat_cd
,p_uom_precision
=> p_rec.uom_precision
,p_ws_element_type_id
=> p_rec.ws_element_type_id
,p_ws_input_value_id
=> p_rec.ws_input_value_id
,p_data_freeze_date
=> p_rec.data_freeze_date
,p_ws_amt_edit_cd
=> p_rec.ws_amt_edit_cd
,p_ws_amt_edit_enf_cd_for_nul
=> p_rec.ws_amt_edit_enf_cd_for_nulls
,p_ws_over_budget_edit_cd
=> p_rec.ws_over_budget_edit_cd
,p_ws_over_budget_tol_pct
=> p_rec.ws_over_budget_tolerance_pct
,p_bdgt_over_budget_edit_cd
=> p_rec.bdgt_over_budget_edit_cd
,p_bdgt_over_budget_tol_pct
=> p_rec.bdgt_over_budget_tolerance_pct
,p_auto_distr_flag
=> p_rec.auto_distr_flag
,p_pqh_document_short_name
=> p_rec.pqh_document_short_name
,p_ovrid_rt_strt_dt
=> p_rec.ovrid_rt_strt_dt
,p_do_not_process_flag
=> p_rec.do_not_process_flag
,p_ovr_perf_revw_strt_dt
=> p_rec.ovr_perf_revw_strt_dt
,p_object_version_number
=> p_rec.object_version_number
);
End post_insert;
ben_cpd_bus.insert_validate
(p_rec
);
ben_cpd_ins.pre_insert(p_rec);
ben_cpd_ins.insert_dml(p_rec);
ben_cpd_ins.post_insert
(p_rec
);