[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
Procedure update_dml
(p_rec in out nocopy ben_cpd_shd.g_rec_type
) is
--
l_proc varchar2(72) := g_package||'update_dml';
update ben_cwb_pl_dsgn
set
pl_id = p_rec.pl_id
,lf_evt_ocrd_dt = p_rec.lf_evt_ocrd_dt
,oipl_id = p_rec.oipl_id
,effective_date = p_rec.effective_date
,name = p_rec.name
,group_pl_id = p_rec.group_pl_id
,group_oipl_id = p_rec.group_oipl_id
,opt_hidden_flag = p_rec.opt_hidden_flag
,opt_id = p_rec.opt_id
,pl_uom = p_rec.pl_uom
,pl_ordr_num = p_rec.pl_ordr_num
,oipl_ordr_num = p_rec.oipl_ordr_num
,pl_xchg_rate = p_rec.pl_xchg_rate
,opt_count = p_rec.opt_count
,uses_bdgt_flag = p_rec.uses_bdgt_flag
,prsrv_bdgt_cd = p_rec.prsrv_bdgt_cd
,upd_start_dt = p_rec.upd_start_dt
,upd_end_dt = p_rec.upd_end_dt
,approval_mode = p_rec.approval_mode
,enrt_perd_start_dt = p_rec.enrt_perd_start_dt
,enrt_perd_end_dt = p_rec.enrt_perd_end_dt
,yr_perd_start_dt = p_rec.yr_perd_start_dt
,yr_perd_end_dt = p_rec.yr_perd_end_dt
,wthn_yr_start_dt = p_rec.wthn_yr_start_dt
,wthn_yr_end_dt = p_rec.wthn_yr_end_dt
,enrt_perd_id = p_rec.enrt_perd_id
,yr_perd_id = p_rec.yr_perd_id
,business_group_id = p_rec.business_group_id
,perf_revw_strt_dt = p_rec.perf_revw_strt_dt
,asg_updt_eff_date = p_rec.asg_updt_eff_date
,emp_interview_typ_cd = p_rec.emp_interview_typ_cd
,salary_change_reason = p_rec.salary_change_reason
,ws_abr_id = p_rec.ws_abr_id
,ws_nnmntry_uom = p_rec.ws_nnmntry_uom
,ws_rndg_cd = p_rec.ws_rndg_cd
,ws_sub_acty_typ_cd = p_rec.ws_sub_acty_typ_cd
,dist_bdgt_abr_id = p_rec.dist_bdgt_abr_id
,dist_bdgt_nnmntry_uom = p_rec.dist_bdgt_nnmntry_uom
,dist_bdgt_rndg_cd = p_rec.dist_bdgt_rndg_cd
,ws_bdgt_abr_id = p_rec.ws_bdgt_abr_id
,ws_bdgt_nnmntry_uom = p_rec.ws_bdgt_nnmntry_uom
,ws_bdgt_rndg_cd = p_rec.ws_bdgt_rndg_cd
,rsrv_abr_id = p_rec.rsrv_abr_id
,rsrv_nnmntry_uom = p_rec.rsrv_nnmntry_uom
,rsrv_rndg_cd = p_rec.rsrv_rndg_cd
,elig_sal_abr_id = p_rec.elig_sal_abr_id
,elig_sal_nnmntry_uom = p_rec.elig_sal_nnmntry_uom
,elig_sal_rndg_cd = p_rec.elig_sal_rndg_cd
,misc1_abr_id = p_rec.misc1_abr_id
,misc1_nnmntry_uom = p_rec.misc1_nnmntry_uom
,misc1_rndg_cd = p_rec.misc1_rndg_cd
,misc2_abr_id = p_rec.misc2_abr_id
,misc2_nnmntry_uom = p_rec.misc2_nnmntry_uom
,misc2_rndg_cd = p_rec.misc2_rndg_cd
,misc3_abr_id = p_rec.misc3_abr_id
,misc3_nnmntry_uom = p_rec.misc3_nnmntry_uom
,misc3_rndg_cd = p_rec.misc3_rndg_cd
,stat_sal_abr_id = p_rec.stat_sal_abr_id
,stat_sal_nnmntry_uom = p_rec.stat_sal_nnmntry_uom
,stat_sal_rndg_cd = p_rec.stat_sal_rndg_cd
,rec_abr_id = p_rec.rec_abr_id
,rec_nnmntry_uom = p_rec.rec_nnmntry_uom
,rec_rndg_cd = p_rec.rec_rndg_cd
,tot_comp_abr_id = p_rec.tot_comp_abr_id
,tot_comp_nnmntry_uom = p_rec.tot_comp_nnmntry_uom
,tot_comp_rndg_cd = p_rec.tot_comp_rndg_cd
,oth_comp_abr_id = p_rec.oth_comp_abr_id
,oth_comp_nnmntry_uom = p_rec.oth_comp_nnmntry_uom
,oth_comp_rndg_cd = p_rec.oth_comp_rndg_cd
,actual_flag = p_rec.actual_flag
,acty_ref_perd_cd = p_rec.acty_ref_perd_cd
,legislation_code = p_rec.legislation_code
,pl_annulization_factor = p_rec.pl_annulization_factor
,pl_stat_cd = p_rec.pl_stat_cd
,uom_precision = p_rec.uom_precision
,ws_element_type_id = p_rec.ws_element_type_id
,ws_input_value_id = p_rec.ws_input_value_id
,data_freeze_date = p_rec.data_freeze_date
,ws_amt_edit_cd = p_rec.ws_amt_edit_cd
,ws_amt_edit_enf_cd_for_nulls = p_rec.ws_amt_edit_enf_cd_for_nulls
,ws_over_budget_edit_cd = p_rec.ws_over_budget_edit_cd
,ws_over_budget_tolerance_pct = p_rec.ws_over_budget_tolerance_pct
,bdgt_over_budget_edit_cd = p_rec.bdgt_over_budget_edit_cd
,bdgt_over_budget_tolerance_pct = p_rec.bdgt_over_budget_tolerance_pct
,auto_distr_flag = p_rec.auto_distr_flag
,pqh_document_short_name = p_rec.pqh_document_short_name
,ovrid_rt_strt_dt = p_rec.ovrid_rt_strt_dt
,do_not_process_flag = p_rec.do_not_process_flag
,ovr_perf_revw_strt_dt = p_rec.ovr_perf_revw_strt_dt
,object_version_number = p_rec.object_version_number
where pl_id = p_rec.pl_id
and lf_evt_ocrd_dt = p_rec.lf_evt_ocrd_dt
and oipl_id = p_rec.oipl_id;
End update_dml;
Procedure pre_update
(p_rec in ben_cpd_shd.g_rec_type
) is
--
l_proc varchar2(72) := g_package||'pre_update';
End pre_update;
Procedure post_update
(p_rec in ben_cpd_shd.g_rec_type
) is
--
l_proc varchar2(72) := g_package||'post_update';
ben_cpd_rku.after_update
(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
,p_effective_date_o
=> ben_cpd_shd.g_old_rec.effective_date
,p_name_o
=> ben_cpd_shd.g_old_rec.name
,p_group_pl_id_o
=> ben_cpd_shd.g_old_rec.group_pl_id
,p_group_oipl_id_o
=> ben_cpd_shd.g_old_rec.group_oipl_id
,p_opt_hidden_flag_o
=> ben_cpd_shd.g_old_rec.opt_hidden_flag
,p_opt_id_o
=> ben_cpd_shd.g_old_rec.opt_id
,p_pl_uom_o
=> ben_cpd_shd.g_old_rec.pl_uom
,p_pl_ordr_num_o
=> ben_cpd_shd.g_old_rec.pl_ordr_num
,p_oipl_ordr_num_o
=> ben_cpd_shd.g_old_rec.oipl_ordr_num
,p_pl_xchg_rate_o
=> ben_cpd_shd.g_old_rec.pl_xchg_rate
,p_opt_count_o
=> ben_cpd_shd.g_old_rec.opt_count
,p_uses_bdgt_flag_o
=> ben_cpd_shd.g_old_rec.uses_bdgt_flag
,p_prsrv_bdgt_cd_o
=> ben_cpd_shd.g_old_rec.prsrv_bdgt_cd
,p_upd_start_dt_o
=> ben_cpd_shd.g_old_rec.upd_start_dt
,p_upd_end_dt_o
=> ben_cpd_shd.g_old_rec.upd_end_dt
,p_approval_mode_o
=> ben_cpd_shd.g_old_rec.approval_mode
,p_enrt_perd_start_dt_o
=> ben_cpd_shd.g_old_rec.enrt_perd_start_dt
,p_enrt_perd_end_dt_o
=> ben_cpd_shd.g_old_rec.enrt_perd_end_dt
,p_yr_perd_start_dt_o
=> ben_cpd_shd.g_old_rec.yr_perd_start_dt
,p_yr_perd_end_dt_o
=> ben_cpd_shd.g_old_rec.yr_perd_end_dt
,p_wthn_yr_start_dt_o
=> ben_cpd_shd.g_old_rec.wthn_yr_start_dt
,p_wthn_yr_end_dt_o
=> ben_cpd_shd.g_old_rec.wthn_yr_end_dt
,p_enrt_perd_id_o
=> ben_cpd_shd.g_old_rec.enrt_perd_id
,p_yr_perd_id_o
=> ben_cpd_shd.g_old_rec.yr_perd_id
,p_business_group_id_o
=> ben_cpd_shd.g_old_rec.business_group_id
,p_perf_revw_strt_dt_o
=> ben_cpd_shd.g_old_rec.perf_revw_strt_dt
,p_asg_updt_eff_date_o
=> ben_cpd_shd.g_old_rec.asg_updt_eff_date
,p_emp_interview_typ_cd_o
=> ben_cpd_shd.g_old_rec.emp_interview_typ_cd
,p_salary_change_reason_o
=> ben_cpd_shd.g_old_rec.salary_change_reason
,p_ws_abr_id_o
=> ben_cpd_shd.g_old_rec.ws_abr_id
,p_ws_nnmntry_uom_o
=> ben_cpd_shd.g_old_rec.ws_nnmntry_uom
,p_ws_rndg_cd_o
=> ben_cpd_shd.g_old_rec.ws_rndg_cd
,p_ws_sub_acty_typ_cd_o
=> ben_cpd_shd.g_old_rec.ws_sub_acty_typ_cd
,p_dist_bdgt_abr_id_o
=> ben_cpd_shd.g_old_rec.dist_bdgt_abr_id
,p_dist_bdgt_nnmntry_uom_o
=> ben_cpd_shd.g_old_rec.dist_bdgt_nnmntry_uom
,p_dist_bdgt_rndg_cd_o
=> ben_cpd_shd.g_old_rec.dist_bdgt_rndg_cd
,p_ws_bdgt_abr_id_o
=> ben_cpd_shd.g_old_rec.ws_bdgt_abr_id
,p_ws_bdgt_nnmntry_uom_o
=> ben_cpd_shd.g_old_rec.ws_bdgt_nnmntry_uom
,p_ws_bdgt_rndg_cd_o
=> ben_cpd_shd.g_old_rec.ws_bdgt_rndg_cd
,p_rsrv_abr_id_o
=> ben_cpd_shd.g_old_rec.rsrv_abr_id
,p_rsrv_nnmntry_uom_o
=> ben_cpd_shd.g_old_rec.rsrv_nnmntry_uom
,p_rsrv_rndg_cd_o
=> ben_cpd_shd.g_old_rec.rsrv_rndg_cd
,p_elig_sal_abr_id_o
=> ben_cpd_shd.g_old_rec.elig_sal_abr_id
,p_elig_sal_nnmntry_uom_o
=> ben_cpd_shd.g_old_rec.elig_sal_nnmntry_uom
,p_elig_sal_rndg_cd_o
=> ben_cpd_shd.g_old_rec.elig_sal_rndg_cd
,p_misc1_abr_id_o
=> ben_cpd_shd.g_old_rec.misc1_abr_id
,p_misc1_nnmntry_uom_o
=> ben_cpd_shd.g_old_rec.misc1_nnmntry_uom
,p_misc1_rndg_cd_o
=> ben_cpd_shd.g_old_rec.misc1_rndg_cd
,p_misc2_abr_id_o
=> ben_cpd_shd.g_old_rec.misc2_abr_id
,p_misc2_nnmntry_uom_o
=> ben_cpd_shd.g_old_rec.misc2_nnmntry_uom
,p_misc2_rndg_cd_o
=> ben_cpd_shd.g_old_rec.misc2_rndg_cd
,p_misc3_abr_id_o
=> ben_cpd_shd.g_old_rec.misc3_abr_id
,p_misc3_nnmntry_uom_o
=> ben_cpd_shd.g_old_rec.misc3_nnmntry_uom
,p_misc3_rndg_cd_o
=> ben_cpd_shd.g_old_rec.misc3_rndg_cd
,p_stat_sal_abr_id_o
=> ben_cpd_shd.g_old_rec.stat_sal_abr_id
,p_stat_sal_nnmntry_uom_o
=> ben_cpd_shd.g_old_rec.stat_sal_nnmntry_uom
,p_stat_sal_rndg_cd_o
=> ben_cpd_shd.g_old_rec.stat_sal_rndg_cd
,p_rec_abr_id_o
=> ben_cpd_shd.g_old_rec.rec_abr_id
,p_rec_nnmntry_uom_o
=> ben_cpd_shd.g_old_rec.rec_nnmntry_uom
,p_rec_rndg_cd_o
=> ben_cpd_shd.g_old_rec.rec_rndg_cd
,p_tot_comp_abr_id_o
=> ben_cpd_shd.g_old_rec.tot_comp_abr_id
,p_tot_comp_nnmntry_uom_o
=> ben_cpd_shd.g_old_rec.tot_comp_nnmntry_uom
,p_tot_comp_rndg_cd_o
=> ben_cpd_shd.g_old_rec.tot_comp_rndg_cd
,p_oth_comp_abr_id_o
=> ben_cpd_shd.g_old_rec.oth_comp_abr_id
,p_oth_comp_nnmntry_uom_o
=> ben_cpd_shd.g_old_rec.oth_comp_nnmntry_uom
,p_oth_comp_rndg_cd_o
=> ben_cpd_shd.g_old_rec.oth_comp_rndg_cd
,p_actual_flag_o
=> ben_cpd_shd.g_old_rec.actual_flag
,p_acty_ref_perd_cd_o
=> ben_cpd_shd.g_old_rec.acty_ref_perd_cd
,p_legislation_code_o
=> ben_cpd_shd.g_old_rec.legislation_code
,p_pl_annulization_factor_o
=> ben_cpd_shd.g_old_rec.pl_annulization_factor
,p_pl_stat_cd_o
=> ben_cpd_shd.g_old_rec.pl_stat_cd
,p_uom_precision_o
=> ben_cpd_shd.g_old_rec.uom_precision
,p_ws_element_type_id_o
=> ben_cpd_shd.g_old_rec.ws_element_type_id
,p_ws_input_value_id_o
=> ben_cpd_shd.g_old_rec.ws_input_value_id
,p_data_freeze_date_o
=> ben_cpd_shd.g_old_rec.data_freeze_date
,p_ws_amt_edit_cd_o
=> ben_cpd_shd.g_old_rec.ws_amt_edit_cd
,p_ws_amt_edit_enf_cd_for_nul_o
=> ben_cpd_shd.g_old_rec.ws_amt_edit_enf_cd_for_nulls
,p_ws_over_budget_edit_cd_o
=> ben_cpd_shd.g_old_rec.ws_over_budget_edit_cd
,p_ws_over_budget_tol_pct_o
=> ben_cpd_shd.g_old_rec.ws_over_budget_tolerance_pct
,p_bdgt_over_budget_edit_cd_o
=> ben_cpd_shd.g_old_rec.bdgt_over_budget_edit_cd
,p_bdgt_over_budget_tol_pct_o
=> ben_cpd_shd.g_old_rec.bdgt_over_budget_tolerance_pct
,p_auto_distr_flag_o
=> ben_cpd_shd.g_old_rec.auto_distr_flag
,p_pqh_document_short_name_o
=> ben_cpd_shd.g_old_rec.pqh_document_short_name
,p_ovrid_rt_strt_dt_o
=> ben_cpd_shd.g_old_rec.ovrid_rt_strt_dt
,p_do_not_process_flag_o
=> ben_cpd_shd.g_old_rec.do_not_process_flag
,p_ovr_perf_revw_strt_dt_o
=> ben_cpd_shd.g_old_rec.ovr_perf_revw_strt_dt
,p_object_version_number_o
=> ben_cpd_shd.g_old_rec.object_version_number
);
End post_update;
ben_cpd_bus.update_validate
(p_rec
);
ben_cpd_upd.pre_update(p_rec);
ben_cpd_upd.update_dml(p_rec);
ben_cpd_upd.post_update
(p_rec
);