[Home] [Help]
51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml
55: (p_rec in out nocopy ben_cpd_shd.g_rec_type
56: ) is
57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: --
62: --
63: -- Increment the object version
64: p_rec.object_version_number := p_rec.object_version_number + 1;
65: --
66: ben_cpd_shd.g_api_dml := true; -- Set the api dml status
67: --
68: -- Update the ben_cwb_pl_dsgn Row
69: --
70: update ben_cwb_pl_dsgn
162: where pl_id = p_rec.pl_id
163: and lf_evt_ocrd_dt = p_rec.lf_evt_ocrd_dt
164: and oipl_id = p_rec.oipl_id;
165: --
166: ben_cpd_shd.g_api_dml := false; -- Unset the api dml status
167: --
168: hr_utility.set_location(' Leaving:'||l_proc, 10);
169: --
170: Exception
169: --
170: Exception
171: When hr_api.check_integrity_violated Then
172: -- A check constraint has been violated
173: ben_cpd_shd.g_api_dml := false; -- Unset the api dml status
174: ben_cpd_shd.constraint_error
175: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
176: When hr_api.parent_integrity_violated Then
177: -- Parent integrity has been violated
170: Exception
171: When hr_api.check_integrity_violated Then
172: -- A check constraint has been violated
173: ben_cpd_shd.g_api_dml := false; -- Unset the api dml status
174: ben_cpd_shd.constraint_error
175: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
176: When hr_api.parent_integrity_violated Then
177: -- Parent integrity has been violated
178: ben_cpd_shd.g_api_dml := false; -- Unset the api dml status
174: ben_cpd_shd.constraint_error
175: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
176: When hr_api.parent_integrity_violated Then
177: -- Parent integrity has been violated
178: ben_cpd_shd.g_api_dml := false; -- Unset the api dml status
179: ben_cpd_shd.constraint_error
180: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
181: When hr_api.unique_integrity_violated Then
182: -- Unique integrity has been violated
175: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
176: When hr_api.parent_integrity_violated Then
177: -- Parent integrity has been violated
178: ben_cpd_shd.g_api_dml := false; -- Unset the api dml status
179: ben_cpd_shd.constraint_error
180: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
181: When hr_api.unique_integrity_violated Then
182: -- Unique integrity has been violated
183: ben_cpd_shd.g_api_dml := false; -- Unset the api dml status
179: ben_cpd_shd.constraint_error
180: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
181: When hr_api.unique_integrity_violated Then
182: -- Unique integrity has been violated
183: ben_cpd_shd.g_api_dml := false; -- Unset the api dml status
184: ben_cpd_shd.constraint_error
185: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
186: When Others Then
187: ben_cpd_shd.g_api_dml := false; -- Unset the api dml status
180: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
181: When hr_api.unique_integrity_violated Then
182: -- Unique integrity has been violated
183: ben_cpd_shd.g_api_dml := false; -- Unset the api dml status
184: ben_cpd_shd.constraint_error
185: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
186: When Others Then
187: ben_cpd_shd.g_api_dml := false; -- Unset the api dml status
188: Raise;
183: ben_cpd_shd.g_api_dml := false; -- Unset the api dml status
184: ben_cpd_shd.constraint_error
185: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
186: When Others Then
187: ben_cpd_shd.g_api_dml := false; -- Unset the api dml status
188: Raise;
189: End update_dml;
190: --
191: -- ----------------------------------------------------------------------------
220: --
221: -- {End Of Comments}
222: -- ----------------------------------------------------------------------------
223: Procedure pre_update
224: (p_rec in ben_cpd_shd.g_rec_type
225: ) is
226: --
227: l_proc varchar2(72) := g_package||'pre_update';
228: --
264: --
265: -- {End Of Comments}
266: -- ----------------------------------------------------------------------------
267: Procedure post_update
268: (p_rec in ben_cpd_shd.g_rec_type
269: ) is
270: --
271: l_proc varchar2(72) := g_package||'post_update';
272: --
455: => p_rec.ovr_perf_revw_strt_dt
456: ,p_object_version_number
457: => p_rec.object_version_number
458: ,p_effective_date_o
459: => ben_cpd_shd.g_old_rec.effective_date
460: ,p_name_o
461: => ben_cpd_shd.g_old_rec.name
462: ,p_group_pl_id_o
463: => ben_cpd_shd.g_old_rec.group_pl_id
457: => p_rec.object_version_number
458: ,p_effective_date_o
459: => ben_cpd_shd.g_old_rec.effective_date
460: ,p_name_o
461: => ben_cpd_shd.g_old_rec.name
462: ,p_group_pl_id_o
463: => ben_cpd_shd.g_old_rec.group_pl_id
464: ,p_group_oipl_id_o
465: => ben_cpd_shd.g_old_rec.group_oipl_id
459: => ben_cpd_shd.g_old_rec.effective_date
460: ,p_name_o
461: => ben_cpd_shd.g_old_rec.name
462: ,p_group_pl_id_o
463: => ben_cpd_shd.g_old_rec.group_pl_id
464: ,p_group_oipl_id_o
465: => ben_cpd_shd.g_old_rec.group_oipl_id
466: ,p_opt_hidden_flag_o
467: => ben_cpd_shd.g_old_rec.opt_hidden_flag
461: => ben_cpd_shd.g_old_rec.name
462: ,p_group_pl_id_o
463: => ben_cpd_shd.g_old_rec.group_pl_id
464: ,p_group_oipl_id_o
465: => ben_cpd_shd.g_old_rec.group_oipl_id
466: ,p_opt_hidden_flag_o
467: => ben_cpd_shd.g_old_rec.opt_hidden_flag
468: ,p_opt_id_o
469: => ben_cpd_shd.g_old_rec.opt_id
463: => ben_cpd_shd.g_old_rec.group_pl_id
464: ,p_group_oipl_id_o
465: => ben_cpd_shd.g_old_rec.group_oipl_id
466: ,p_opt_hidden_flag_o
467: => ben_cpd_shd.g_old_rec.opt_hidden_flag
468: ,p_opt_id_o
469: => ben_cpd_shd.g_old_rec.opt_id
470: ,p_pl_uom_o
471: => ben_cpd_shd.g_old_rec.pl_uom
465: => ben_cpd_shd.g_old_rec.group_oipl_id
466: ,p_opt_hidden_flag_o
467: => ben_cpd_shd.g_old_rec.opt_hidden_flag
468: ,p_opt_id_o
469: => ben_cpd_shd.g_old_rec.opt_id
470: ,p_pl_uom_o
471: => ben_cpd_shd.g_old_rec.pl_uom
472: ,p_pl_ordr_num_o
473: => ben_cpd_shd.g_old_rec.pl_ordr_num
467: => ben_cpd_shd.g_old_rec.opt_hidden_flag
468: ,p_opt_id_o
469: => ben_cpd_shd.g_old_rec.opt_id
470: ,p_pl_uom_o
471: => ben_cpd_shd.g_old_rec.pl_uom
472: ,p_pl_ordr_num_o
473: => ben_cpd_shd.g_old_rec.pl_ordr_num
474: ,p_oipl_ordr_num_o
475: => ben_cpd_shd.g_old_rec.oipl_ordr_num
469: => ben_cpd_shd.g_old_rec.opt_id
470: ,p_pl_uom_o
471: => ben_cpd_shd.g_old_rec.pl_uom
472: ,p_pl_ordr_num_o
473: => ben_cpd_shd.g_old_rec.pl_ordr_num
474: ,p_oipl_ordr_num_o
475: => ben_cpd_shd.g_old_rec.oipl_ordr_num
476: ,p_pl_xchg_rate_o
477: => ben_cpd_shd.g_old_rec.pl_xchg_rate
471: => ben_cpd_shd.g_old_rec.pl_uom
472: ,p_pl_ordr_num_o
473: => ben_cpd_shd.g_old_rec.pl_ordr_num
474: ,p_oipl_ordr_num_o
475: => ben_cpd_shd.g_old_rec.oipl_ordr_num
476: ,p_pl_xchg_rate_o
477: => ben_cpd_shd.g_old_rec.pl_xchg_rate
478: ,p_opt_count_o
479: => ben_cpd_shd.g_old_rec.opt_count
473: => ben_cpd_shd.g_old_rec.pl_ordr_num
474: ,p_oipl_ordr_num_o
475: => ben_cpd_shd.g_old_rec.oipl_ordr_num
476: ,p_pl_xchg_rate_o
477: => ben_cpd_shd.g_old_rec.pl_xchg_rate
478: ,p_opt_count_o
479: => ben_cpd_shd.g_old_rec.opt_count
480: ,p_uses_bdgt_flag_o
481: => ben_cpd_shd.g_old_rec.uses_bdgt_flag
475: => ben_cpd_shd.g_old_rec.oipl_ordr_num
476: ,p_pl_xchg_rate_o
477: => ben_cpd_shd.g_old_rec.pl_xchg_rate
478: ,p_opt_count_o
479: => ben_cpd_shd.g_old_rec.opt_count
480: ,p_uses_bdgt_flag_o
481: => ben_cpd_shd.g_old_rec.uses_bdgt_flag
482: ,p_prsrv_bdgt_cd_o
483: => ben_cpd_shd.g_old_rec.prsrv_bdgt_cd
477: => ben_cpd_shd.g_old_rec.pl_xchg_rate
478: ,p_opt_count_o
479: => ben_cpd_shd.g_old_rec.opt_count
480: ,p_uses_bdgt_flag_o
481: => ben_cpd_shd.g_old_rec.uses_bdgt_flag
482: ,p_prsrv_bdgt_cd_o
483: => ben_cpd_shd.g_old_rec.prsrv_bdgt_cd
484: ,p_upd_start_dt_o
485: => ben_cpd_shd.g_old_rec.upd_start_dt
479: => ben_cpd_shd.g_old_rec.opt_count
480: ,p_uses_bdgt_flag_o
481: => ben_cpd_shd.g_old_rec.uses_bdgt_flag
482: ,p_prsrv_bdgt_cd_o
483: => ben_cpd_shd.g_old_rec.prsrv_bdgt_cd
484: ,p_upd_start_dt_o
485: => ben_cpd_shd.g_old_rec.upd_start_dt
486: ,p_upd_end_dt_o
487: => ben_cpd_shd.g_old_rec.upd_end_dt
481: => ben_cpd_shd.g_old_rec.uses_bdgt_flag
482: ,p_prsrv_bdgt_cd_o
483: => ben_cpd_shd.g_old_rec.prsrv_bdgt_cd
484: ,p_upd_start_dt_o
485: => ben_cpd_shd.g_old_rec.upd_start_dt
486: ,p_upd_end_dt_o
487: => ben_cpd_shd.g_old_rec.upd_end_dt
488: ,p_approval_mode_o
489: => ben_cpd_shd.g_old_rec.approval_mode
483: => ben_cpd_shd.g_old_rec.prsrv_bdgt_cd
484: ,p_upd_start_dt_o
485: => ben_cpd_shd.g_old_rec.upd_start_dt
486: ,p_upd_end_dt_o
487: => ben_cpd_shd.g_old_rec.upd_end_dt
488: ,p_approval_mode_o
489: => ben_cpd_shd.g_old_rec.approval_mode
490: ,p_enrt_perd_start_dt_o
491: => ben_cpd_shd.g_old_rec.enrt_perd_start_dt
485: => ben_cpd_shd.g_old_rec.upd_start_dt
486: ,p_upd_end_dt_o
487: => ben_cpd_shd.g_old_rec.upd_end_dt
488: ,p_approval_mode_o
489: => ben_cpd_shd.g_old_rec.approval_mode
490: ,p_enrt_perd_start_dt_o
491: => ben_cpd_shd.g_old_rec.enrt_perd_start_dt
492: ,p_enrt_perd_end_dt_o
493: => ben_cpd_shd.g_old_rec.enrt_perd_end_dt
487: => ben_cpd_shd.g_old_rec.upd_end_dt
488: ,p_approval_mode_o
489: => ben_cpd_shd.g_old_rec.approval_mode
490: ,p_enrt_perd_start_dt_o
491: => ben_cpd_shd.g_old_rec.enrt_perd_start_dt
492: ,p_enrt_perd_end_dt_o
493: => ben_cpd_shd.g_old_rec.enrt_perd_end_dt
494: ,p_yr_perd_start_dt_o
495: => ben_cpd_shd.g_old_rec.yr_perd_start_dt
489: => ben_cpd_shd.g_old_rec.approval_mode
490: ,p_enrt_perd_start_dt_o
491: => ben_cpd_shd.g_old_rec.enrt_perd_start_dt
492: ,p_enrt_perd_end_dt_o
493: => ben_cpd_shd.g_old_rec.enrt_perd_end_dt
494: ,p_yr_perd_start_dt_o
495: => ben_cpd_shd.g_old_rec.yr_perd_start_dt
496: ,p_yr_perd_end_dt_o
497: => ben_cpd_shd.g_old_rec.yr_perd_end_dt
491: => ben_cpd_shd.g_old_rec.enrt_perd_start_dt
492: ,p_enrt_perd_end_dt_o
493: => ben_cpd_shd.g_old_rec.enrt_perd_end_dt
494: ,p_yr_perd_start_dt_o
495: => ben_cpd_shd.g_old_rec.yr_perd_start_dt
496: ,p_yr_perd_end_dt_o
497: => ben_cpd_shd.g_old_rec.yr_perd_end_dt
498: ,p_wthn_yr_start_dt_o
499: => ben_cpd_shd.g_old_rec.wthn_yr_start_dt
493: => ben_cpd_shd.g_old_rec.enrt_perd_end_dt
494: ,p_yr_perd_start_dt_o
495: => ben_cpd_shd.g_old_rec.yr_perd_start_dt
496: ,p_yr_perd_end_dt_o
497: => ben_cpd_shd.g_old_rec.yr_perd_end_dt
498: ,p_wthn_yr_start_dt_o
499: => ben_cpd_shd.g_old_rec.wthn_yr_start_dt
500: ,p_wthn_yr_end_dt_o
501: => ben_cpd_shd.g_old_rec.wthn_yr_end_dt
495: => ben_cpd_shd.g_old_rec.yr_perd_start_dt
496: ,p_yr_perd_end_dt_o
497: => ben_cpd_shd.g_old_rec.yr_perd_end_dt
498: ,p_wthn_yr_start_dt_o
499: => ben_cpd_shd.g_old_rec.wthn_yr_start_dt
500: ,p_wthn_yr_end_dt_o
501: => ben_cpd_shd.g_old_rec.wthn_yr_end_dt
502: ,p_enrt_perd_id_o
503: => ben_cpd_shd.g_old_rec.enrt_perd_id
497: => ben_cpd_shd.g_old_rec.yr_perd_end_dt
498: ,p_wthn_yr_start_dt_o
499: => ben_cpd_shd.g_old_rec.wthn_yr_start_dt
500: ,p_wthn_yr_end_dt_o
501: => ben_cpd_shd.g_old_rec.wthn_yr_end_dt
502: ,p_enrt_perd_id_o
503: => ben_cpd_shd.g_old_rec.enrt_perd_id
504: ,p_yr_perd_id_o
505: => ben_cpd_shd.g_old_rec.yr_perd_id
499: => ben_cpd_shd.g_old_rec.wthn_yr_start_dt
500: ,p_wthn_yr_end_dt_o
501: => ben_cpd_shd.g_old_rec.wthn_yr_end_dt
502: ,p_enrt_perd_id_o
503: => ben_cpd_shd.g_old_rec.enrt_perd_id
504: ,p_yr_perd_id_o
505: => ben_cpd_shd.g_old_rec.yr_perd_id
506: ,p_business_group_id_o
507: => ben_cpd_shd.g_old_rec.business_group_id
501: => ben_cpd_shd.g_old_rec.wthn_yr_end_dt
502: ,p_enrt_perd_id_o
503: => ben_cpd_shd.g_old_rec.enrt_perd_id
504: ,p_yr_perd_id_o
505: => ben_cpd_shd.g_old_rec.yr_perd_id
506: ,p_business_group_id_o
507: => ben_cpd_shd.g_old_rec.business_group_id
508: ,p_perf_revw_strt_dt_o
509: => ben_cpd_shd.g_old_rec.perf_revw_strt_dt
503: => ben_cpd_shd.g_old_rec.enrt_perd_id
504: ,p_yr_perd_id_o
505: => ben_cpd_shd.g_old_rec.yr_perd_id
506: ,p_business_group_id_o
507: => ben_cpd_shd.g_old_rec.business_group_id
508: ,p_perf_revw_strt_dt_o
509: => ben_cpd_shd.g_old_rec.perf_revw_strt_dt
510: ,p_asg_updt_eff_date_o
511: => ben_cpd_shd.g_old_rec.asg_updt_eff_date
505: => ben_cpd_shd.g_old_rec.yr_perd_id
506: ,p_business_group_id_o
507: => ben_cpd_shd.g_old_rec.business_group_id
508: ,p_perf_revw_strt_dt_o
509: => ben_cpd_shd.g_old_rec.perf_revw_strt_dt
510: ,p_asg_updt_eff_date_o
511: => ben_cpd_shd.g_old_rec.asg_updt_eff_date
512: ,p_emp_interview_typ_cd_o
513: => ben_cpd_shd.g_old_rec.emp_interview_typ_cd
507: => ben_cpd_shd.g_old_rec.business_group_id
508: ,p_perf_revw_strt_dt_o
509: => ben_cpd_shd.g_old_rec.perf_revw_strt_dt
510: ,p_asg_updt_eff_date_o
511: => ben_cpd_shd.g_old_rec.asg_updt_eff_date
512: ,p_emp_interview_typ_cd_o
513: => ben_cpd_shd.g_old_rec.emp_interview_typ_cd
514: ,p_salary_change_reason_o
515: => ben_cpd_shd.g_old_rec.salary_change_reason
509: => ben_cpd_shd.g_old_rec.perf_revw_strt_dt
510: ,p_asg_updt_eff_date_o
511: => ben_cpd_shd.g_old_rec.asg_updt_eff_date
512: ,p_emp_interview_typ_cd_o
513: => ben_cpd_shd.g_old_rec.emp_interview_typ_cd
514: ,p_salary_change_reason_o
515: => ben_cpd_shd.g_old_rec.salary_change_reason
516: ,p_ws_abr_id_o
517: => ben_cpd_shd.g_old_rec.ws_abr_id
511: => ben_cpd_shd.g_old_rec.asg_updt_eff_date
512: ,p_emp_interview_typ_cd_o
513: => ben_cpd_shd.g_old_rec.emp_interview_typ_cd
514: ,p_salary_change_reason_o
515: => ben_cpd_shd.g_old_rec.salary_change_reason
516: ,p_ws_abr_id_o
517: => ben_cpd_shd.g_old_rec.ws_abr_id
518: ,p_ws_nnmntry_uom_o
519: => ben_cpd_shd.g_old_rec.ws_nnmntry_uom
513: => ben_cpd_shd.g_old_rec.emp_interview_typ_cd
514: ,p_salary_change_reason_o
515: => ben_cpd_shd.g_old_rec.salary_change_reason
516: ,p_ws_abr_id_o
517: => ben_cpd_shd.g_old_rec.ws_abr_id
518: ,p_ws_nnmntry_uom_o
519: => ben_cpd_shd.g_old_rec.ws_nnmntry_uom
520: ,p_ws_rndg_cd_o
521: => ben_cpd_shd.g_old_rec.ws_rndg_cd
515: => ben_cpd_shd.g_old_rec.salary_change_reason
516: ,p_ws_abr_id_o
517: => ben_cpd_shd.g_old_rec.ws_abr_id
518: ,p_ws_nnmntry_uom_o
519: => ben_cpd_shd.g_old_rec.ws_nnmntry_uom
520: ,p_ws_rndg_cd_o
521: => ben_cpd_shd.g_old_rec.ws_rndg_cd
522: ,p_ws_sub_acty_typ_cd_o
523: => ben_cpd_shd.g_old_rec.ws_sub_acty_typ_cd
517: => ben_cpd_shd.g_old_rec.ws_abr_id
518: ,p_ws_nnmntry_uom_o
519: => ben_cpd_shd.g_old_rec.ws_nnmntry_uom
520: ,p_ws_rndg_cd_o
521: => ben_cpd_shd.g_old_rec.ws_rndg_cd
522: ,p_ws_sub_acty_typ_cd_o
523: => ben_cpd_shd.g_old_rec.ws_sub_acty_typ_cd
524: ,p_dist_bdgt_abr_id_o
525: => ben_cpd_shd.g_old_rec.dist_bdgt_abr_id
519: => ben_cpd_shd.g_old_rec.ws_nnmntry_uom
520: ,p_ws_rndg_cd_o
521: => ben_cpd_shd.g_old_rec.ws_rndg_cd
522: ,p_ws_sub_acty_typ_cd_o
523: => ben_cpd_shd.g_old_rec.ws_sub_acty_typ_cd
524: ,p_dist_bdgt_abr_id_o
525: => ben_cpd_shd.g_old_rec.dist_bdgt_abr_id
526: ,p_dist_bdgt_nnmntry_uom_o
527: => ben_cpd_shd.g_old_rec.dist_bdgt_nnmntry_uom
521: => ben_cpd_shd.g_old_rec.ws_rndg_cd
522: ,p_ws_sub_acty_typ_cd_o
523: => ben_cpd_shd.g_old_rec.ws_sub_acty_typ_cd
524: ,p_dist_bdgt_abr_id_o
525: => ben_cpd_shd.g_old_rec.dist_bdgt_abr_id
526: ,p_dist_bdgt_nnmntry_uom_o
527: => ben_cpd_shd.g_old_rec.dist_bdgt_nnmntry_uom
528: ,p_dist_bdgt_rndg_cd_o
529: => ben_cpd_shd.g_old_rec.dist_bdgt_rndg_cd
523: => ben_cpd_shd.g_old_rec.ws_sub_acty_typ_cd
524: ,p_dist_bdgt_abr_id_o
525: => ben_cpd_shd.g_old_rec.dist_bdgt_abr_id
526: ,p_dist_bdgt_nnmntry_uom_o
527: => ben_cpd_shd.g_old_rec.dist_bdgt_nnmntry_uom
528: ,p_dist_bdgt_rndg_cd_o
529: => ben_cpd_shd.g_old_rec.dist_bdgt_rndg_cd
530: ,p_ws_bdgt_abr_id_o
531: => ben_cpd_shd.g_old_rec.ws_bdgt_abr_id
525: => ben_cpd_shd.g_old_rec.dist_bdgt_abr_id
526: ,p_dist_bdgt_nnmntry_uom_o
527: => ben_cpd_shd.g_old_rec.dist_bdgt_nnmntry_uom
528: ,p_dist_bdgt_rndg_cd_o
529: => ben_cpd_shd.g_old_rec.dist_bdgt_rndg_cd
530: ,p_ws_bdgt_abr_id_o
531: => ben_cpd_shd.g_old_rec.ws_bdgt_abr_id
532: ,p_ws_bdgt_nnmntry_uom_o
533: => ben_cpd_shd.g_old_rec.ws_bdgt_nnmntry_uom
527: => ben_cpd_shd.g_old_rec.dist_bdgt_nnmntry_uom
528: ,p_dist_bdgt_rndg_cd_o
529: => ben_cpd_shd.g_old_rec.dist_bdgt_rndg_cd
530: ,p_ws_bdgt_abr_id_o
531: => ben_cpd_shd.g_old_rec.ws_bdgt_abr_id
532: ,p_ws_bdgt_nnmntry_uom_o
533: => ben_cpd_shd.g_old_rec.ws_bdgt_nnmntry_uom
534: ,p_ws_bdgt_rndg_cd_o
535: => ben_cpd_shd.g_old_rec.ws_bdgt_rndg_cd
529: => ben_cpd_shd.g_old_rec.dist_bdgt_rndg_cd
530: ,p_ws_bdgt_abr_id_o
531: => ben_cpd_shd.g_old_rec.ws_bdgt_abr_id
532: ,p_ws_bdgt_nnmntry_uom_o
533: => ben_cpd_shd.g_old_rec.ws_bdgt_nnmntry_uom
534: ,p_ws_bdgt_rndg_cd_o
535: => ben_cpd_shd.g_old_rec.ws_bdgt_rndg_cd
536: ,p_rsrv_abr_id_o
537: => ben_cpd_shd.g_old_rec.rsrv_abr_id
531: => ben_cpd_shd.g_old_rec.ws_bdgt_abr_id
532: ,p_ws_bdgt_nnmntry_uom_o
533: => ben_cpd_shd.g_old_rec.ws_bdgt_nnmntry_uom
534: ,p_ws_bdgt_rndg_cd_o
535: => ben_cpd_shd.g_old_rec.ws_bdgt_rndg_cd
536: ,p_rsrv_abr_id_o
537: => ben_cpd_shd.g_old_rec.rsrv_abr_id
538: ,p_rsrv_nnmntry_uom_o
539: => ben_cpd_shd.g_old_rec.rsrv_nnmntry_uom
533: => ben_cpd_shd.g_old_rec.ws_bdgt_nnmntry_uom
534: ,p_ws_bdgt_rndg_cd_o
535: => ben_cpd_shd.g_old_rec.ws_bdgt_rndg_cd
536: ,p_rsrv_abr_id_o
537: => ben_cpd_shd.g_old_rec.rsrv_abr_id
538: ,p_rsrv_nnmntry_uom_o
539: => ben_cpd_shd.g_old_rec.rsrv_nnmntry_uom
540: ,p_rsrv_rndg_cd_o
541: => ben_cpd_shd.g_old_rec.rsrv_rndg_cd
535: => ben_cpd_shd.g_old_rec.ws_bdgt_rndg_cd
536: ,p_rsrv_abr_id_o
537: => ben_cpd_shd.g_old_rec.rsrv_abr_id
538: ,p_rsrv_nnmntry_uom_o
539: => ben_cpd_shd.g_old_rec.rsrv_nnmntry_uom
540: ,p_rsrv_rndg_cd_o
541: => ben_cpd_shd.g_old_rec.rsrv_rndg_cd
542: ,p_elig_sal_abr_id_o
543: => ben_cpd_shd.g_old_rec.elig_sal_abr_id
537: => ben_cpd_shd.g_old_rec.rsrv_abr_id
538: ,p_rsrv_nnmntry_uom_o
539: => ben_cpd_shd.g_old_rec.rsrv_nnmntry_uom
540: ,p_rsrv_rndg_cd_o
541: => ben_cpd_shd.g_old_rec.rsrv_rndg_cd
542: ,p_elig_sal_abr_id_o
543: => ben_cpd_shd.g_old_rec.elig_sal_abr_id
544: ,p_elig_sal_nnmntry_uom_o
545: => ben_cpd_shd.g_old_rec.elig_sal_nnmntry_uom
539: => ben_cpd_shd.g_old_rec.rsrv_nnmntry_uom
540: ,p_rsrv_rndg_cd_o
541: => ben_cpd_shd.g_old_rec.rsrv_rndg_cd
542: ,p_elig_sal_abr_id_o
543: => ben_cpd_shd.g_old_rec.elig_sal_abr_id
544: ,p_elig_sal_nnmntry_uom_o
545: => ben_cpd_shd.g_old_rec.elig_sal_nnmntry_uom
546: ,p_elig_sal_rndg_cd_o
547: => ben_cpd_shd.g_old_rec.elig_sal_rndg_cd
541: => ben_cpd_shd.g_old_rec.rsrv_rndg_cd
542: ,p_elig_sal_abr_id_o
543: => ben_cpd_shd.g_old_rec.elig_sal_abr_id
544: ,p_elig_sal_nnmntry_uom_o
545: => ben_cpd_shd.g_old_rec.elig_sal_nnmntry_uom
546: ,p_elig_sal_rndg_cd_o
547: => ben_cpd_shd.g_old_rec.elig_sal_rndg_cd
548: ,p_misc1_abr_id_o
549: => ben_cpd_shd.g_old_rec.misc1_abr_id
543: => ben_cpd_shd.g_old_rec.elig_sal_abr_id
544: ,p_elig_sal_nnmntry_uom_o
545: => ben_cpd_shd.g_old_rec.elig_sal_nnmntry_uom
546: ,p_elig_sal_rndg_cd_o
547: => ben_cpd_shd.g_old_rec.elig_sal_rndg_cd
548: ,p_misc1_abr_id_o
549: => ben_cpd_shd.g_old_rec.misc1_abr_id
550: ,p_misc1_nnmntry_uom_o
551: => ben_cpd_shd.g_old_rec.misc1_nnmntry_uom
545: => ben_cpd_shd.g_old_rec.elig_sal_nnmntry_uom
546: ,p_elig_sal_rndg_cd_o
547: => ben_cpd_shd.g_old_rec.elig_sal_rndg_cd
548: ,p_misc1_abr_id_o
549: => ben_cpd_shd.g_old_rec.misc1_abr_id
550: ,p_misc1_nnmntry_uom_o
551: => ben_cpd_shd.g_old_rec.misc1_nnmntry_uom
552: ,p_misc1_rndg_cd_o
553: => ben_cpd_shd.g_old_rec.misc1_rndg_cd
547: => ben_cpd_shd.g_old_rec.elig_sal_rndg_cd
548: ,p_misc1_abr_id_o
549: => ben_cpd_shd.g_old_rec.misc1_abr_id
550: ,p_misc1_nnmntry_uom_o
551: => ben_cpd_shd.g_old_rec.misc1_nnmntry_uom
552: ,p_misc1_rndg_cd_o
553: => ben_cpd_shd.g_old_rec.misc1_rndg_cd
554: ,p_misc2_abr_id_o
555: => ben_cpd_shd.g_old_rec.misc2_abr_id
549: => ben_cpd_shd.g_old_rec.misc1_abr_id
550: ,p_misc1_nnmntry_uom_o
551: => ben_cpd_shd.g_old_rec.misc1_nnmntry_uom
552: ,p_misc1_rndg_cd_o
553: => ben_cpd_shd.g_old_rec.misc1_rndg_cd
554: ,p_misc2_abr_id_o
555: => ben_cpd_shd.g_old_rec.misc2_abr_id
556: ,p_misc2_nnmntry_uom_o
557: => ben_cpd_shd.g_old_rec.misc2_nnmntry_uom
551: => ben_cpd_shd.g_old_rec.misc1_nnmntry_uom
552: ,p_misc1_rndg_cd_o
553: => ben_cpd_shd.g_old_rec.misc1_rndg_cd
554: ,p_misc2_abr_id_o
555: => ben_cpd_shd.g_old_rec.misc2_abr_id
556: ,p_misc2_nnmntry_uom_o
557: => ben_cpd_shd.g_old_rec.misc2_nnmntry_uom
558: ,p_misc2_rndg_cd_o
559: => ben_cpd_shd.g_old_rec.misc2_rndg_cd
553: => ben_cpd_shd.g_old_rec.misc1_rndg_cd
554: ,p_misc2_abr_id_o
555: => ben_cpd_shd.g_old_rec.misc2_abr_id
556: ,p_misc2_nnmntry_uom_o
557: => ben_cpd_shd.g_old_rec.misc2_nnmntry_uom
558: ,p_misc2_rndg_cd_o
559: => ben_cpd_shd.g_old_rec.misc2_rndg_cd
560: ,p_misc3_abr_id_o
561: => ben_cpd_shd.g_old_rec.misc3_abr_id
555: => ben_cpd_shd.g_old_rec.misc2_abr_id
556: ,p_misc2_nnmntry_uom_o
557: => ben_cpd_shd.g_old_rec.misc2_nnmntry_uom
558: ,p_misc2_rndg_cd_o
559: => ben_cpd_shd.g_old_rec.misc2_rndg_cd
560: ,p_misc3_abr_id_o
561: => ben_cpd_shd.g_old_rec.misc3_abr_id
562: ,p_misc3_nnmntry_uom_o
563: => ben_cpd_shd.g_old_rec.misc3_nnmntry_uom
557: => ben_cpd_shd.g_old_rec.misc2_nnmntry_uom
558: ,p_misc2_rndg_cd_o
559: => ben_cpd_shd.g_old_rec.misc2_rndg_cd
560: ,p_misc3_abr_id_o
561: => ben_cpd_shd.g_old_rec.misc3_abr_id
562: ,p_misc3_nnmntry_uom_o
563: => ben_cpd_shd.g_old_rec.misc3_nnmntry_uom
564: ,p_misc3_rndg_cd_o
565: => ben_cpd_shd.g_old_rec.misc3_rndg_cd
559: => ben_cpd_shd.g_old_rec.misc2_rndg_cd
560: ,p_misc3_abr_id_o
561: => ben_cpd_shd.g_old_rec.misc3_abr_id
562: ,p_misc3_nnmntry_uom_o
563: => ben_cpd_shd.g_old_rec.misc3_nnmntry_uom
564: ,p_misc3_rndg_cd_o
565: => ben_cpd_shd.g_old_rec.misc3_rndg_cd
566: ,p_stat_sal_abr_id_o
567: => ben_cpd_shd.g_old_rec.stat_sal_abr_id
561: => ben_cpd_shd.g_old_rec.misc3_abr_id
562: ,p_misc3_nnmntry_uom_o
563: => ben_cpd_shd.g_old_rec.misc3_nnmntry_uom
564: ,p_misc3_rndg_cd_o
565: => ben_cpd_shd.g_old_rec.misc3_rndg_cd
566: ,p_stat_sal_abr_id_o
567: => ben_cpd_shd.g_old_rec.stat_sal_abr_id
568: ,p_stat_sal_nnmntry_uom_o
569: => ben_cpd_shd.g_old_rec.stat_sal_nnmntry_uom
563: => ben_cpd_shd.g_old_rec.misc3_nnmntry_uom
564: ,p_misc3_rndg_cd_o
565: => ben_cpd_shd.g_old_rec.misc3_rndg_cd
566: ,p_stat_sal_abr_id_o
567: => ben_cpd_shd.g_old_rec.stat_sal_abr_id
568: ,p_stat_sal_nnmntry_uom_o
569: => ben_cpd_shd.g_old_rec.stat_sal_nnmntry_uom
570: ,p_stat_sal_rndg_cd_o
571: => ben_cpd_shd.g_old_rec.stat_sal_rndg_cd
565: => ben_cpd_shd.g_old_rec.misc3_rndg_cd
566: ,p_stat_sal_abr_id_o
567: => ben_cpd_shd.g_old_rec.stat_sal_abr_id
568: ,p_stat_sal_nnmntry_uom_o
569: => ben_cpd_shd.g_old_rec.stat_sal_nnmntry_uom
570: ,p_stat_sal_rndg_cd_o
571: => ben_cpd_shd.g_old_rec.stat_sal_rndg_cd
572: ,p_rec_abr_id_o
573: => ben_cpd_shd.g_old_rec.rec_abr_id
567: => ben_cpd_shd.g_old_rec.stat_sal_abr_id
568: ,p_stat_sal_nnmntry_uom_o
569: => ben_cpd_shd.g_old_rec.stat_sal_nnmntry_uom
570: ,p_stat_sal_rndg_cd_o
571: => ben_cpd_shd.g_old_rec.stat_sal_rndg_cd
572: ,p_rec_abr_id_o
573: => ben_cpd_shd.g_old_rec.rec_abr_id
574: ,p_rec_nnmntry_uom_o
575: => ben_cpd_shd.g_old_rec.rec_nnmntry_uom
569: => ben_cpd_shd.g_old_rec.stat_sal_nnmntry_uom
570: ,p_stat_sal_rndg_cd_o
571: => ben_cpd_shd.g_old_rec.stat_sal_rndg_cd
572: ,p_rec_abr_id_o
573: => ben_cpd_shd.g_old_rec.rec_abr_id
574: ,p_rec_nnmntry_uom_o
575: => ben_cpd_shd.g_old_rec.rec_nnmntry_uom
576: ,p_rec_rndg_cd_o
577: => ben_cpd_shd.g_old_rec.rec_rndg_cd
571: => ben_cpd_shd.g_old_rec.stat_sal_rndg_cd
572: ,p_rec_abr_id_o
573: => ben_cpd_shd.g_old_rec.rec_abr_id
574: ,p_rec_nnmntry_uom_o
575: => ben_cpd_shd.g_old_rec.rec_nnmntry_uom
576: ,p_rec_rndg_cd_o
577: => ben_cpd_shd.g_old_rec.rec_rndg_cd
578: ,p_tot_comp_abr_id_o
579: => ben_cpd_shd.g_old_rec.tot_comp_abr_id
573: => ben_cpd_shd.g_old_rec.rec_abr_id
574: ,p_rec_nnmntry_uom_o
575: => ben_cpd_shd.g_old_rec.rec_nnmntry_uom
576: ,p_rec_rndg_cd_o
577: => ben_cpd_shd.g_old_rec.rec_rndg_cd
578: ,p_tot_comp_abr_id_o
579: => ben_cpd_shd.g_old_rec.tot_comp_abr_id
580: ,p_tot_comp_nnmntry_uom_o
581: => ben_cpd_shd.g_old_rec.tot_comp_nnmntry_uom
575: => ben_cpd_shd.g_old_rec.rec_nnmntry_uom
576: ,p_rec_rndg_cd_o
577: => ben_cpd_shd.g_old_rec.rec_rndg_cd
578: ,p_tot_comp_abr_id_o
579: => ben_cpd_shd.g_old_rec.tot_comp_abr_id
580: ,p_tot_comp_nnmntry_uom_o
581: => ben_cpd_shd.g_old_rec.tot_comp_nnmntry_uom
582: ,p_tot_comp_rndg_cd_o
583: => ben_cpd_shd.g_old_rec.tot_comp_rndg_cd
577: => ben_cpd_shd.g_old_rec.rec_rndg_cd
578: ,p_tot_comp_abr_id_o
579: => ben_cpd_shd.g_old_rec.tot_comp_abr_id
580: ,p_tot_comp_nnmntry_uom_o
581: => ben_cpd_shd.g_old_rec.tot_comp_nnmntry_uom
582: ,p_tot_comp_rndg_cd_o
583: => ben_cpd_shd.g_old_rec.tot_comp_rndg_cd
584: ,p_oth_comp_abr_id_o
585: => ben_cpd_shd.g_old_rec.oth_comp_abr_id
579: => ben_cpd_shd.g_old_rec.tot_comp_abr_id
580: ,p_tot_comp_nnmntry_uom_o
581: => ben_cpd_shd.g_old_rec.tot_comp_nnmntry_uom
582: ,p_tot_comp_rndg_cd_o
583: => ben_cpd_shd.g_old_rec.tot_comp_rndg_cd
584: ,p_oth_comp_abr_id_o
585: => ben_cpd_shd.g_old_rec.oth_comp_abr_id
586: ,p_oth_comp_nnmntry_uom_o
587: => ben_cpd_shd.g_old_rec.oth_comp_nnmntry_uom
581: => ben_cpd_shd.g_old_rec.tot_comp_nnmntry_uom
582: ,p_tot_comp_rndg_cd_o
583: => ben_cpd_shd.g_old_rec.tot_comp_rndg_cd
584: ,p_oth_comp_abr_id_o
585: => ben_cpd_shd.g_old_rec.oth_comp_abr_id
586: ,p_oth_comp_nnmntry_uom_o
587: => ben_cpd_shd.g_old_rec.oth_comp_nnmntry_uom
588: ,p_oth_comp_rndg_cd_o
589: => ben_cpd_shd.g_old_rec.oth_comp_rndg_cd
583: => ben_cpd_shd.g_old_rec.tot_comp_rndg_cd
584: ,p_oth_comp_abr_id_o
585: => ben_cpd_shd.g_old_rec.oth_comp_abr_id
586: ,p_oth_comp_nnmntry_uom_o
587: => ben_cpd_shd.g_old_rec.oth_comp_nnmntry_uom
588: ,p_oth_comp_rndg_cd_o
589: => ben_cpd_shd.g_old_rec.oth_comp_rndg_cd
590: ,p_actual_flag_o
591: => ben_cpd_shd.g_old_rec.actual_flag
585: => ben_cpd_shd.g_old_rec.oth_comp_abr_id
586: ,p_oth_comp_nnmntry_uom_o
587: => ben_cpd_shd.g_old_rec.oth_comp_nnmntry_uom
588: ,p_oth_comp_rndg_cd_o
589: => ben_cpd_shd.g_old_rec.oth_comp_rndg_cd
590: ,p_actual_flag_o
591: => ben_cpd_shd.g_old_rec.actual_flag
592: ,p_acty_ref_perd_cd_o
593: => ben_cpd_shd.g_old_rec.acty_ref_perd_cd
587: => ben_cpd_shd.g_old_rec.oth_comp_nnmntry_uom
588: ,p_oth_comp_rndg_cd_o
589: => ben_cpd_shd.g_old_rec.oth_comp_rndg_cd
590: ,p_actual_flag_o
591: => ben_cpd_shd.g_old_rec.actual_flag
592: ,p_acty_ref_perd_cd_o
593: => ben_cpd_shd.g_old_rec.acty_ref_perd_cd
594: ,p_legislation_code_o
595: => ben_cpd_shd.g_old_rec.legislation_code
589: => ben_cpd_shd.g_old_rec.oth_comp_rndg_cd
590: ,p_actual_flag_o
591: => ben_cpd_shd.g_old_rec.actual_flag
592: ,p_acty_ref_perd_cd_o
593: => ben_cpd_shd.g_old_rec.acty_ref_perd_cd
594: ,p_legislation_code_o
595: => ben_cpd_shd.g_old_rec.legislation_code
596: ,p_pl_annulization_factor_o
597: => ben_cpd_shd.g_old_rec.pl_annulization_factor
591: => ben_cpd_shd.g_old_rec.actual_flag
592: ,p_acty_ref_perd_cd_o
593: => ben_cpd_shd.g_old_rec.acty_ref_perd_cd
594: ,p_legislation_code_o
595: => ben_cpd_shd.g_old_rec.legislation_code
596: ,p_pl_annulization_factor_o
597: => ben_cpd_shd.g_old_rec.pl_annulization_factor
598: ,p_pl_stat_cd_o
599: => ben_cpd_shd.g_old_rec.pl_stat_cd
593: => ben_cpd_shd.g_old_rec.acty_ref_perd_cd
594: ,p_legislation_code_o
595: => ben_cpd_shd.g_old_rec.legislation_code
596: ,p_pl_annulization_factor_o
597: => ben_cpd_shd.g_old_rec.pl_annulization_factor
598: ,p_pl_stat_cd_o
599: => ben_cpd_shd.g_old_rec.pl_stat_cd
600: ,p_uom_precision_o
601: => ben_cpd_shd.g_old_rec.uom_precision
595: => ben_cpd_shd.g_old_rec.legislation_code
596: ,p_pl_annulization_factor_o
597: => ben_cpd_shd.g_old_rec.pl_annulization_factor
598: ,p_pl_stat_cd_o
599: => ben_cpd_shd.g_old_rec.pl_stat_cd
600: ,p_uom_precision_o
601: => ben_cpd_shd.g_old_rec.uom_precision
602: ,p_ws_element_type_id_o
603: => ben_cpd_shd.g_old_rec.ws_element_type_id
597: => ben_cpd_shd.g_old_rec.pl_annulization_factor
598: ,p_pl_stat_cd_o
599: => ben_cpd_shd.g_old_rec.pl_stat_cd
600: ,p_uom_precision_o
601: => ben_cpd_shd.g_old_rec.uom_precision
602: ,p_ws_element_type_id_o
603: => ben_cpd_shd.g_old_rec.ws_element_type_id
604: ,p_ws_input_value_id_o
605: => ben_cpd_shd.g_old_rec.ws_input_value_id
599: => ben_cpd_shd.g_old_rec.pl_stat_cd
600: ,p_uom_precision_o
601: => ben_cpd_shd.g_old_rec.uom_precision
602: ,p_ws_element_type_id_o
603: => ben_cpd_shd.g_old_rec.ws_element_type_id
604: ,p_ws_input_value_id_o
605: => ben_cpd_shd.g_old_rec.ws_input_value_id
606: ,p_data_freeze_date_o
607: => ben_cpd_shd.g_old_rec.data_freeze_date
601: => ben_cpd_shd.g_old_rec.uom_precision
602: ,p_ws_element_type_id_o
603: => ben_cpd_shd.g_old_rec.ws_element_type_id
604: ,p_ws_input_value_id_o
605: => ben_cpd_shd.g_old_rec.ws_input_value_id
606: ,p_data_freeze_date_o
607: => ben_cpd_shd.g_old_rec.data_freeze_date
608: ,p_ws_amt_edit_cd_o
609: => ben_cpd_shd.g_old_rec.ws_amt_edit_cd
603: => ben_cpd_shd.g_old_rec.ws_element_type_id
604: ,p_ws_input_value_id_o
605: => ben_cpd_shd.g_old_rec.ws_input_value_id
606: ,p_data_freeze_date_o
607: => ben_cpd_shd.g_old_rec.data_freeze_date
608: ,p_ws_amt_edit_cd_o
609: => ben_cpd_shd.g_old_rec.ws_amt_edit_cd
610: ,p_ws_amt_edit_enf_cd_for_nul_o
611: => ben_cpd_shd.g_old_rec.ws_amt_edit_enf_cd_for_nulls
605: => ben_cpd_shd.g_old_rec.ws_input_value_id
606: ,p_data_freeze_date_o
607: => ben_cpd_shd.g_old_rec.data_freeze_date
608: ,p_ws_amt_edit_cd_o
609: => ben_cpd_shd.g_old_rec.ws_amt_edit_cd
610: ,p_ws_amt_edit_enf_cd_for_nul_o
611: => ben_cpd_shd.g_old_rec.ws_amt_edit_enf_cd_for_nulls
612: ,p_ws_over_budget_edit_cd_o
613: => ben_cpd_shd.g_old_rec.ws_over_budget_edit_cd
607: => ben_cpd_shd.g_old_rec.data_freeze_date
608: ,p_ws_amt_edit_cd_o
609: => ben_cpd_shd.g_old_rec.ws_amt_edit_cd
610: ,p_ws_amt_edit_enf_cd_for_nul_o
611: => ben_cpd_shd.g_old_rec.ws_amt_edit_enf_cd_for_nulls
612: ,p_ws_over_budget_edit_cd_o
613: => ben_cpd_shd.g_old_rec.ws_over_budget_edit_cd
614: ,p_ws_over_budget_tol_pct_o
615: => ben_cpd_shd.g_old_rec.ws_over_budget_tolerance_pct
609: => ben_cpd_shd.g_old_rec.ws_amt_edit_cd
610: ,p_ws_amt_edit_enf_cd_for_nul_o
611: => ben_cpd_shd.g_old_rec.ws_amt_edit_enf_cd_for_nulls
612: ,p_ws_over_budget_edit_cd_o
613: => ben_cpd_shd.g_old_rec.ws_over_budget_edit_cd
614: ,p_ws_over_budget_tol_pct_o
615: => ben_cpd_shd.g_old_rec.ws_over_budget_tolerance_pct
616: ,p_bdgt_over_budget_edit_cd_o
617: => ben_cpd_shd.g_old_rec.bdgt_over_budget_edit_cd
611: => ben_cpd_shd.g_old_rec.ws_amt_edit_enf_cd_for_nulls
612: ,p_ws_over_budget_edit_cd_o
613: => ben_cpd_shd.g_old_rec.ws_over_budget_edit_cd
614: ,p_ws_over_budget_tol_pct_o
615: => ben_cpd_shd.g_old_rec.ws_over_budget_tolerance_pct
616: ,p_bdgt_over_budget_edit_cd_o
617: => ben_cpd_shd.g_old_rec.bdgt_over_budget_edit_cd
618: ,p_bdgt_over_budget_tol_pct_o
619: => ben_cpd_shd.g_old_rec.bdgt_over_budget_tolerance_pct
613: => ben_cpd_shd.g_old_rec.ws_over_budget_edit_cd
614: ,p_ws_over_budget_tol_pct_o
615: => ben_cpd_shd.g_old_rec.ws_over_budget_tolerance_pct
616: ,p_bdgt_over_budget_edit_cd_o
617: => ben_cpd_shd.g_old_rec.bdgt_over_budget_edit_cd
618: ,p_bdgt_over_budget_tol_pct_o
619: => ben_cpd_shd.g_old_rec.bdgt_over_budget_tolerance_pct
620: ,p_auto_distr_flag_o
621: => ben_cpd_shd.g_old_rec.auto_distr_flag
615: => ben_cpd_shd.g_old_rec.ws_over_budget_tolerance_pct
616: ,p_bdgt_over_budget_edit_cd_o
617: => ben_cpd_shd.g_old_rec.bdgt_over_budget_edit_cd
618: ,p_bdgt_over_budget_tol_pct_o
619: => ben_cpd_shd.g_old_rec.bdgt_over_budget_tolerance_pct
620: ,p_auto_distr_flag_o
621: => ben_cpd_shd.g_old_rec.auto_distr_flag
622: ,p_pqh_document_short_name_o
623: => ben_cpd_shd.g_old_rec.pqh_document_short_name
617: => ben_cpd_shd.g_old_rec.bdgt_over_budget_edit_cd
618: ,p_bdgt_over_budget_tol_pct_o
619: => ben_cpd_shd.g_old_rec.bdgt_over_budget_tolerance_pct
620: ,p_auto_distr_flag_o
621: => ben_cpd_shd.g_old_rec.auto_distr_flag
622: ,p_pqh_document_short_name_o
623: => ben_cpd_shd.g_old_rec.pqh_document_short_name
624: ,p_ovrid_rt_strt_dt_o
625: => ben_cpd_shd.g_old_rec.ovrid_rt_strt_dt
619: => ben_cpd_shd.g_old_rec.bdgt_over_budget_tolerance_pct
620: ,p_auto_distr_flag_o
621: => ben_cpd_shd.g_old_rec.auto_distr_flag
622: ,p_pqh_document_short_name_o
623: => ben_cpd_shd.g_old_rec.pqh_document_short_name
624: ,p_ovrid_rt_strt_dt_o
625: => ben_cpd_shd.g_old_rec.ovrid_rt_strt_dt
626: ,p_do_not_process_flag_o
627: => ben_cpd_shd.g_old_rec.do_not_process_flag
621: => ben_cpd_shd.g_old_rec.auto_distr_flag
622: ,p_pqh_document_short_name_o
623: => ben_cpd_shd.g_old_rec.pqh_document_short_name
624: ,p_ovrid_rt_strt_dt_o
625: => ben_cpd_shd.g_old_rec.ovrid_rt_strt_dt
626: ,p_do_not_process_flag_o
627: => ben_cpd_shd.g_old_rec.do_not_process_flag
628: ,p_ovr_perf_revw_strt_dt_o
629: => ben_cpd_shd.g_old_rec.ovr_perf_revw_strt_dt
623: => ben_cpd_shd.g_old_rec.pqh_document_short_name
624: ,p_ovrid_rt_strt_dt_o
625: => ben_cpd_shd.g_old_rec.ovrid_rt_strt_dt
626: ,p_do_not_process_flag_o
627: => ben_cpd_shd.g_old_rec.do_not_process_flag
628: ,p_ovr_perf_revw_strt_dt_o
629: => ben_cpd_shd.g_old_rec.ovr_perf_revw_strt_dt
630: ,p_object_version_number_o
631: => ben_cpd_shd.g_old_rec.object_version_number
625: => ben_cpd_shd.g_old_rec.ovrid_rt_strt_dt
626: ,p_do_not_process_flag_o
627: => ben_cpd_shd.g_old_rec.do_not_process_flag
628: ,p_ovr_perf_revw_strt_dt_o
629: => ben_cpd_shd.g_old_rec.ovr_perf_revw_strt_dt
630: ,p_object_version_number_o
631: => ben_cpd_shd.g_old_rec.object_version_number
632: );
633: --
627: => ben_cpd_shd.g_old_rec.do_not_process_flag
628: ,p_ovr_perf_revw_strt_dt_o
629: => ben_cpd_shd.g_old_rec.ovr_perf_revw_strt_dt
630: ,p_object_version_number_o
631: => ben_cpd_shd.g_old_rec.object_version_number
632: );
633: --
634: exception
635: --
687: --
688: -- {End Of Comments}
689: -- ----------------------------------------------------------------------------
690: Procedure convert_defs
691: (p_rec in out nocopy ben_cpd_shd.g_rec_type
692: ) is
693: --
694: Begin
695: --
699: -- is being used then we must set to the 'current' argument value.
700: --
701: If (p_rec.effective_date = hr_api.g_date) then
702: p_rec.effective_date :=
703: ben_cpd_shd.g_old_rec.effective_date;
704: End If;
705: If (p_rec.name = hr_api.g_varchar2) then
706: p_rec.name :=
707: ben_cpd_shd.g_old_rec.name;
703: ben_cpd_shd.g_old_rec.effective_date;
704: End If;
705: If (p_rec.name = hr_api.g_varchar2) then
706: p_rec.name :=
707: ben_cpd_shd.g_old_rec.name;
708: End If;
709: If (p_rec.group_pl_id = hr_api.g_number) then
710: p_rec.group_pl_id :=
711: ben_cpd_shd.g_old_rec.group_pl_id;
707: ben_cpd_shd.g_old_rec.name;
708: End If;
709: If (p_rec.group_pl_id = hr_api.g_number) then
710: p_rec.group_pl_id :=
711: ben_cpd_shd.g_old_rec.group_pl_id;
712: End If;
713: If (p_rec.group_oipl_id = hr_api.g_number) then
714: p_rec.group_oipl_id :=
715: ben_cpd_shd.g_old_rec.group_oipl_id;
711: ben_cpd_shd.g_old_rec.group_pl_id;
712: End If;
713: If (p_rec.group_oipl_id = hr_api.g_number) then
714: p_rec.group_oipl_id :=
715: ben_cpd_shd.g_old_rec.group_oipl_id;
716: End If;
717: If (p_rec.opt_hidden_flag = hr_api.g_varchar2) then
718: p_rec.opt_hidden_flag :=
719: ben_cpd_shd.g_old_rec.opt_hidden_flag;
715: ben_cpd_shd.g_old_rec.group_oipl_id;
716: End If;
717: If (p_rec.opt_hidden_flag = hr_api.g_varchar2) then
718: p_rec.opt_hidden_flag :=
719: ben_cpd_shd.g_old_rec.opt_hidden_flag;
720: End If;
721: If (p_rec.opt_id = hr_api.g_number) then
722: p_rec.opt_id :=
723: ben_cpd_shd.g_old_rec.opt_id;
719: ben_cpd_shd.g_old_rec.opt_hidden_flag;
720: End If;
721: If (p_rec.opt_id = hr_api.g_number) then
722: p_rec.opt_id :=
723: ben_cpd_shd.g_old_rec.opt_id;
724: End If;
725: If (p_rec.pl_uom = hr_api.g_varchar2) then
726: p_rec.pl_uom :=
727: ben_cpd_shd.g_old_rec.pl_uom;
723: ben_cpd_shd.g_old_rec.opt_id;
724: End If;
725: If (p_rec.pl_uom = hr_api.g_varchar2) then
726: p_rec.pl_uom :=
727: ben_cpd_shd.g_old_rec.pl_uom;
728: End If;
729: If (p_rec.pl_ordr_num = hr_api.g_number) then
730: p_rec.pl_ordr_num :=
731: ben_cpd_shd.g_old_rec.pl_ordr_num;
727: ben_cpd_shd.g_old_rec.pl_uom;
728: End If;
729: If (p_rec.pl_ordr_num = hr_api.g_number) then
730: p_rec.pl_ordr_num :=
731: ben_cpd_shd.g_old_rec.pl_ordr_num;
732: End If;
733: If (p_rec.oipl_ordr_num = hr_api.g_number) then
734: p_rec.oipl_ordr_num :=
735: ben_cpd_shd.g_old_rec.oipl_ordr_num;
731: ben_cpd_shd.g_old_rec.pl_ordr_num;
732: End If;
733: If (p_rec.oipl_ordr_num = hr_api.g_number) then
734: p_rec.oipl_ordr_num :=
735: ben_cpd_shd.g_old_rec.oipl_ordr_num;
736: End If;
737: If (p_rec.pl_xchg_rate = hr_api.g_number) then
738: p_rec.pl_xchg_rate :=
739: ben_cpd_shd.g_old_rec.pl_xchg_rate;
735: ben_cpd_shd.g_old_rec.oipl_ordr_num;
736: End If;
737: If (p_rec.pl_xchg_rate = hr_api.g_number) then
738: p_rec.pl_xchg_rate :=
739: ben_cpd_shd.g_old_rec.pl_xchg_rate;
740: End If;
741: If (p_rec.opt_count = hr_api.g_number) then
742: p_rec.opt_count :=
743: ben_cpd_shd.g_old_rec.opt_count;
739: ben_cpd_shd.g_old_rec.pl_xchg_rate;
740: End If;
741: If (p_rec.opt_count = hr_api.g_number) then
742: p_rec.opt_count :=
743: ben_cpd_shd.g_old_rec.opt_count;
744: End If;
745: If (p_rec.uses_bdgt_flag = hr_api.g_varchar2) then
746: p_rec.uses_bdgt_flag :=
747: ben_cpd_shd.g_old_rec.uses_bdgt_flag;
743: ben_cpd_shd.g_old_rec.opt_count;
744: End If;
745: If (p_rec.uses_bdgt_flag = hr_api.g_varchar2) then
746: p_rec.uses_bdgt_flag :=
747: ben_cpd_shd.g_old_rec.uses_bdgt_flag;
748: End If;
749: If (p_rec.prsrv_bdgt_cd = hr_api.g_varchar2) then
750: p_rec.prsrv_bdgt_cd :=
751: ben_cpd_shd.g_old_rec.prsrv_bdgt_cd;
747: ben_cpd_shd.g_old_rec.uses_bdgt_flag;
748: End If;
749: If (p_rec.prsrv_bdgt_cd = hr_api.g_varchar2) then
750: p_rec.prsrv_bdgt_cd :=
751: ben_cpd_shd.g_old_rec.prsrv_bdgt_cd;
752: End If;
753: If (p_rec.upd_start_dt = hr_api.g_date) then
754: p_rec.upd_start_dt :=
755: ben_cpd_shd.g_old_rec.upd_start_dt;
751: ben_cpd_shd.g_old_rec.prsrv_bdgt_cd;
752: End If;
753: If (p_rec.upd_start_dt = hr_api.g_date) then
754: p_rec.upd_start_dt :=
755: ben_cpd_shd.g_old_rec.upd_start_dt;
756: End If;
757: If (p_rec.upd_end_dt = hr_api.g_date) then
758: p_rec.upd_end_dt :=
759: ben_cpd_shd.g_old_rec.upd_end_dt;
755: ben_cpd_shd.g_old_rec.upd_start_dt;
756: End If;
757: If (p_rec.upd_end_dt = hr_api.g_date) then
758: p_rec.upd_end_dt :=
759: ben_cpd_shd.g_old_rec.upd_end_dt;
760: End If;
761: If (p_rec.approval_mode = hr_api.g_varchar2) then
762: p_rec.approval_mode :=
763: ben_cpd_shd.g_old_rec.approval_mode;
759: ben_cpd_shd.g_old_rec.upd_end_dt;
760: End If;
761: If (p_rec.approval_mode = hr_api.g_varchar2) then
762: p_rec.approval_mode :=
763: ben_cpd_shd.g_old_rec.approval_mode;
764: End If;
765: If (p_rec.enrt_perd_start_dt = hr_api.g_date) then
766: p_rec.enrt_perd_start_dt :=
767: ben_cpd_shd.g_old_rec.enrt_perd_start_dt;
763: ben_cpd_shd.g_old_rec.approval_mode;
764: End If;
765: If (p_rec.enrt_perd_start_dt = hr_api.g_date) then
766: p_rec.enrt_perd_start_dt :=
767: ben_cpd_shd.g_old_rec.enrt_perd_start_dt;
768: End If;
769: If (p_rec.enrt_perd_end_dt = hr_api.g_date) then
770: p_rec.enrt_perd_end_dt :=
771: ben_cpd_shd.g_old_rec.enrt_perd_end_dt;
767: ben_cpd_shd.g_old_rec.enrt_perd_start_dt;
768: End If;
769: If (p_rec.enrt_perd_end_dt = hr_api.g_date) then
770: p_rec.enrt_perd_end_dt :=
771: ben_cpd_shd.g_old_rec.enrt_perd_end_dt;
772: End If;
773: If (p_rec.yr_perd_start_dt = hr_api.g_date) then
774: p_rec.yr_perd_start_dt :=
775: ben_cpd_shd.g_old_rec.yr_perd_start_dt;
771: ben_cpd_shd.g_old_rec.enrt_perd_end_dt;
772: End If;
773: If (p_rec.yr_perd_start_dt = hr_api.g_date) then
774: p_rec.yr_perd_start_dt :=
775: ben_cpd_shd.g_old_rec.yr_perd_start_dt;
776: End If;
777: If (p_rec.yr_perd_end_dt = hr_api.g_date) then
778: p_rec.yr_perd_end_dt :=
779: ben_cpd_shd.g_old_rec.yr_perd_end_dt;
775: ben_cpd_shd.g_old_rec.yr_perd_start_dt;
776: End If;
777: If (p_rec.yr_perd_end_dt = hr_api.g_date) then
778: p_rec.yr_perd_end_dt :=
779: ben_cpd_shd.g_old_rec.yr_perd_end_dt;
780: End If;
781: If (p_rec.wthn_yr_start_dt = hr_api.g_date) then
782: p_rec.wthn_yr_start_dt :=
783: ben_cpd_shd.g_old_rec.wthn_yr_start_dt;
779: ben_cpd_shd.g_old_rec.yr_perd_end_dt;
780: End If;
781: If (p_rec.wthn_yr_start_dt = hr_api.g_date) then
782: p_rec.wthn_yr_start_dt :=
783: ben_cpd_shd.g_old_rec.wthn_yr_start_dt;
784: End If;
785: If (p_rec.wthn_yr_end_dt = hr_api.g_date) then
786: p_rec.wthn_yr_end_dt :=
787: ben_cpd_shd.g_old_rec.wthn_yr_end_dt;
783: ben_cpd_shd.g_old_rec.wthn_yr_start_dt;
784: End If;
785: If (p_rec.wthn_yr_end_dt = hr_api.g_date) then
786: p_rec.wthn_yr_end_dt :=
787: ben_cpd_shd.g_old_rec.wthn_yr_end_dt;
788: End If;
789: If (p_rec.enrt_perd_id = hr_api.g_number) then
790: p_rec.enrt_perd_id :=
791: ben_cpd_shd.g_old_rec.enrt_perd_id;
787: ben_cpd_shd.g_old_rec.wthn_yr_end_dt;
788: End If;
789: If (p_rec.enrt_perd_id = hr_api.g_number) then
790: p_rec.enrt_perd_id :=
791: ben_cpd_shd.g_old_rec.enrt_perd_id;
792: End If;
793: If (p_rec.yr_perd_id = hr_api.g_number) then
794: p_rec.yr_perd_id :=
795: ben_cpd_shd.g_old_rec.yr_perd_id;
791: ben_cpd_shd.g_old_rec.enrt_perd_id;
792: End If;
793: If (p_rec.yr_perd_id = hr_api.g_number) then
794: p_rec.yr_perd_id :=
795: ben_cpd_shd.g_old_rec.yr_perd_id;
796: End If;
797: If (p_rec.business_group_id = hr_api.g_number) then
798: p_rec.business_group_id :=
799: ben_cpd_shd.g_old_rec.business_group_id;
795: ben_cpd_shd.g_old_rec.yr_perd_id;
796: End If;
797: If (p_rec.business_group_id = hr_api.g_number) then
798: p_rec.business_group_id :=
799: ben_cpd_shd.g_old_rec.business_group_id;
800: End If;
801: If (p_rec.perf_revw_strt_dt = hr_api.g_date) then
802: p_rec.perf_revw_strt_dt :=
803: ben_cpd_shd.g_old_rec.perf_revw_strt_dt;
799: ben_cpd_shd.g_old_rec.business_group_id;
800: End If;
801: If (p_rec.perf_revw_strt_dt = hr_api.g_date) then
802: p_rec.perf_revw_strt_dt :=
803: ben_cpd_shd.g_old_rec.perf_revw_strt_dt;
804: End If;
805: If (p_rec.asg_updt_eff_date = hr_api.g_date) then
806: p_rec.asg_updt_eff_date :=
807: ben_cpd_shd.g_old_rec.asg_updt_eff_date;
803: ben_cpd_shd.g_old_rec.perf_revw_strt_dt;
804: End If;
805: If (p_rec.asg_updt_eff_date = hr_api.g_date) then
806: p_rec.asg_updt_eff_date :=
807: ben_cpd_shd.g_old_rec.asg_updt_eff_date;
808: End If;
809: If (p_rec.emp_interview_typ_cd = hr_api.g_varchar2) then
810: p_rec.emp_interview_typ_cd :=
811: ben_cpd_shd.g_old_rec.emp_interview_typ_cd;
807: ben_cpd_shd.g_old_rec.asg_updt_eff_date;
808: End If;
809: If (p_rec.emp_interview_typ_cd = hr_api.g_varchar2) then
810: p_rec.emp_interview_typ_cd :=
811: ben_cpd_shd.g_old_rec.emp_interview_typ_cd;
812: End If;
813: If (p_rec.salary_change_reason = hr_api.g_varchar2) then
814: p_rec.salary_change_reason :=
815: ben_cpd_shd.g_old_rec.salary_change_reason;
811: ben_cpd_shd.g_old_rec.emp_interview_typ_cd;
812: End If;
813: If (p_rec.salary_change_reason = hr_api.g_varchar2) then
814: p_rec.salary_change_reason :=
815: ben_cpd_shd.g_old_rec.salary_change_reason;
816: End If;
817: If (p_rec.ws_abr_id = hr_api.g_number) then
818: p_rec.ws_abr_id :=
819: ben_cpd_shd.g_old_rec.ws_abr_id;
815: ben_cpd_shd.g_old_rec.salary_change_reason;
816: End If;
817: If (p_rec.ws_abr_id = hr_api.g_number) then
818: p_rec.ws_abr_id :=
819: ben_cpd_shd.g_old_rec.ws_abr_id;
820: End If;
821: If (p_rec.ws_nnmntry_uom = hr_api.g_varchar2) then
822: p_rec.ws_nnmntry_uom :=
823: ben_cpd_shd.g_old_rec.ws_nnmntry_uom;
819: ben_cpd_shd.g_old_rec.ws_abr_id;
820: End If;
821: If (p_rec.ws_nnmntry_uom = hr_api.g_varchar2) then
822: p_rec.ws_nnmntry_uom :=
823: ben_cpd_shd.g_old_rec.ws_nnmntry_uom;
824: End If;
825: If (p_rec.ws_rndg_cd = hr_api.g_varchar2) then
826: p_rec.ws_rndg_cd :=
827: ben_cpd_shd.g_old_rec.ws_rndg_cd;
823: ben_cpd_shd.g_old_rec.ws_nnmntry_uom;
824: End If;
825: If (p_rec.ws_rndg_cd = hr_api.g_varchar2) then
826: p_rec.ws_rndg_cd :=
827: ben_cpd_shd.g_old_rec.ws_rndg_cd;
828: End If;
829: If (p_rec.ws_sub_acty_typ_cd = hr_api.g_varchar2) then
830: p_rec.ws_sub_acty_typ_cd :=
831: ben_cpd_shd.g_old_rec.ws_sub_acty_typ_cd;
827: ben_cpd_shd.g_old_rec.ws_rndg_cd;
828: End If;
829: If (p_rec.ws_sub_acty_typ_cd = hr_api.g_varchar2) then
830: p_rec.ws_sub_acty_typ_cd :=
831: ben_cpd_shd.g_old_rec.ws_sub_acty_typ_cd;
832: End If;
833: If (p_rec.dist_bdgt_abr_id = hr_api.g_number) then
834: p_rec.dist_bdgt_abr_id :=
835: ben_cpd_shd.g_old_rec.dist_bdgt_abr_id;
831: ben_cpd_shd.g_old_rec.ws_sub_acty_typ_cd;
832: End If;
833: If (p_rec.dist_bdgt_abr_id = hr_api.g_number) then
834: p_rec.dist_bdgt_abr_id :=
835: ben_cpd_shd.g_old_rec.dist_bdgt_abr_id;
836: End If;
837: If (p_rec.dist_bdgt_nnmntry_uom = hr_api.g_varchar2) then
838: p_rec.dist_bdgt_nnmntry_uom :=
839: ben_cpd_shd.g_old_rec.dist_bdgt_nnmntry_uom;
835: ben_cpd_shd.g_old_rec.dist_bdgt_abr_id;
836: End If;
837: If (p_rec.dist_bdgt_nnmntry_uom = hr_api.g_varchar2) then
838: p_rec.dist_bdgt_nnmntry_uom :=
839: ben_cpd_shd.g_old_rec.dist_bdgt_nnmntry_uom;
840: End If;
841: If (p_rec.dist_bdgt_rndg_cd = hr_api.g_varchar2) then
842: p_rec.dist_bdgt_rndg_cd :=
843: ben_cpd_shd.g_old_rec.dist_bdgt_rndg_cd;
839: ben_cpd_shd.g_old_rec.dist_bdgt_nnmntry_uom;
840: End If;
841: If (p_rec.dist_bdgt_rndg_cd = hr_api.g_varchar2) then
842: p_rec.dist_bdgt_rndg_cd :=
843: ben_cpd_shd.g_old_rec.dist_bdgt_rndg_cd;
844: End If;
845: If (p_rec.ws_bdgt_abr_id = hr_api.g_number) then
846: p_rec.ws_bdgt_abr_id :=
847: ben_cpd_shd.g_old_rec.ws_bdgt_abr_id;
843: ben_cpd_shd.g_old_rec.dist_bdgt_rndg_cd;
844: End If;
845: If (p_rec.ws_bdgt_abr_id = hr_api.g_number) then
846: p_rec.ws_bdgt_abr_id :=
847: ben_cpd_shd.g_old_rec.ws_bdgt_abr_id;
848: End If;
849: If (p_rec.ws_bdgt_nnmntry_uom = hr_api.g_varchar2) then
850: p_rec.ws_bdgt_nnmntry_uom :=
851: ben_cpd_shd.g_old_rec.ws_bdgt_nnmntry_uom;
847: ben_cpd_shd.g_old_rec.ws_bdgt_abr_id;
848: End If;
849: If (p_rec.ws_bdgt_nnmntry_uom = hr_api.g_varchar2) then
850: p_rec.ws_bdgt_nnmntry_uom :=
851: ben_cpd_shd.g_old_rec.ws_bdgt_nnmntry_uom;
852: End If;
853: If (p_rec.ws_bdgt_rndg_cd = hr_api.g_varchar2) then
854: p_rec.ws_bdgt_rndg_cd :=
855: ben_cpd_shd.g_old_rec.ws_bdgt_rndg_cd;
851: ben_cpd_shd.g_old_rec.ws_bdgt_nnmntry_uom;
852: End If;
853: If (p_rec.ws_bdgt_rndg_cd = hr_api.g_varchar2) then
854: p_rec.ws_bdgt_rndg_cd :=
855: ben_cpd_shd.g_old_rec.ws_bdgt_rndg_cd;
856: End If;
857: If (p_rec.rsrv_abr_id = hr_api.g_number) then
858: p_rec.rsrv_abr_id :=
859: ben_cpd_shd.g_old_rec.rsrv_abr_id;
855: ben_cpd_shd.g_old_rec.ws_bdgt_rndg_cd;
856: End If;
857: If (p_rec.rsrv_abr_id = hr_api.g_number) then
858: p_rec.rsrv_abr_id :=
859: ben_cpd_shd.g_old_rec.rsrv_abr_id;
860: End If;
861: If (p_rec.rsrv_nnmntry_uom = hr_api.g_varchar2) then
862: p_rec.rsrv_nnmntry_uom :=
863: ben_cpd_shd.g_old_rec.rsrv_nnmntry_uom;
859: ben_cpd_shd.g_old_rec.rsrv_abr_id;
860: End If;
861: If (p_rec.rsrv_nnmntry_uom = hr_api.g_varchar2) then
862: p_rec.rsrv_nnmntry_uom :=
863: ben_cpd_shd.g_old_rec.rsrv_nnmntry_uom;
864: End If;
865: If (p_rec.rsrv_rndg_cd = hr_api.g_varchar2) then
866: p_rec.rsrv_rndg_cd :=
867: ben_cpd_shd.g_old_rec.rsrv_rndg_cd;
863: ben_cpd_shd.g_old_rec.rsrv_nnmntry_uom;
864: End If;
865: If (p_rec.rsrv_rndg_cd = hr_api.g_varchar2) then
866: p_rec.rsrv_rndg_cd :=
867: ben_cpd_shd.g_old_rec.rsrv_rndg_cd;
868: End If;
869: If (p_rec.elig_sal_abr_id = hr_api.g_number) then
870: p_rec.elig_sal_abr_id :=
871: ben_cpd_shd.g_old_rec.elig_sal_abr_id;
867: ben_cpd_shd.g_old_rec.rsrv_rndg_cd;
868: End If;
869: If (p_rec.elig_sal_abr_id = hr_api.g_number) then
870: p_rec.elig_sal_abr_id :=
871: ben_cpd_shd.g_old_rec.elig_sal_abr_id;
872: End If;
873: If (p_rec.elig_sal_nnmntry_uom = hr_api.g_varchar2) then
874: p_rec.elig_sal_nnmntry_uom :=
875: ben_cpd_shd.g_old_rec.elig_sal_nnmntry_uom;
871: ben_cpd_shd.g_old_rec.elig_sal_abr_id;
872: End If;
873: If (p_rec.elig_sal_nnmntry_uom = hr_api.g_varchar2) then
874: p_rec.elig_sal_nnmntry_uom :=
875: ben_cpd_shd.g_old_rec.elig_sal_nnmntry_uom;
876: End If;
877: If (p_rec.elig_sal_rndg_cd = hr_api.g_varchar2) then
878: p_rec.elig_sal_rndg_cd :=
879: ben_cpd_shd.g_old_rec.elig_sal_rndg_cd;
875: ben_cpd_shd.g_old_rec.elig_sal_nnmntry_uom;
876: End If;
877: If (p_rec.elig_sal_rndg_cd = hr_api.g_varchar2) then
878: p_rec.elig_sal_rndg_cd :=
879: ben_cpd_shd.g_old_rec.elig_sal_rndg_cd;
880: End If;
881: If (p_rec.misc1_abr_id = hr_api.g_number) then
882: p_rec.misc1_abr_id :=
883: ben_cpd_shd.g_old_rec.misc1_abr_id;
879: ben_cpd_shd.g_old_rec.elig_sal_rndg_cd;
880: End If;
881: If (p_rec.misc1_abr_id = hr_api.g_number) then
882: p_rec.misc1_abr_id :=
883: ben_cpd_shd.g_old_rec.misc1_abr_id;
884: End If;
885: If (p_rec.misc1_nnmntry_uom = hr_api.g_varchar2) then
886: p_rec.misc1_nnmntry_uom :=
887: ben_cpd_shd.g_old_rec.misc1_nnmntry_uom;
883: ben_cpd_shd.g_old_rec.misc1_abr_id;
884: End If;
885: If (p_rec.misc1_nnmntry_uom = hr_api.g_varchar2) then
886: p_rec.misc1_nnmntry_uom :=
887: ben_cpd_shd.g_old_rec.misc1_nnmntry_uom;
888: End If;
889: If (p_rec.misc1_rndg_cd = hr_api.g_varchar2) then
890: p_rec.misc1_rndg_cd :=
891: ben_cpd_shd.g_old_rec.misc1_rndg_cd;
887: ben_cpd_shd.g_old_rec.misc1_nnmntry_uom;
888: End If;
889: If (p_rec.misc1_rndg_cd = hr_api.g_varchar2) then
890: p_rec.misc1_rndg_cd :=
891: ben_cpd_shd.g_old_rec.misc1_rndg_cd;
892: End If;
893: If (p_rec.misc2_abr_id = hr_api.g_number) then
894: p_rec.misc2_abr_id :=
895: ben_cpd_shd.g_old_rec.misc2_abr_id;
891: ben_cpd_shd.g_old_rec.misc1_rndg_cd;
892: End If;
893: If (p_rec.misc2_abr_id = hr_api.g_number) then
894: p_rec.misc2_abr_id :=
895: ben_cpd_shd.g_old_rec.misc2_abr_id;
896: End If;
897: If (p_rec.misc2_nnmntry_uom = hr_api.g_varchar2) then
898: p_rec.misc2_nnmntry_uom :=
899: ben_cpd_shd.g_old_rec.misc2_nnmntry_uom;
895: ben_cpd_shd.g_old_rec.misc2_abr_id;
896: End If;
897: If (p_rec.misc2_nnmntry_uom = hr_api.g_varchar2) then
898: p_rec.misc2_nnmntry_uom :=
899: ben_cpd_shd.g_old_rec.misc2_nnmntry_uom;
900: End If;
901: If (p_rec.misc2_rndg_cd = hr_api.g_varchar2) then
902: p_rec.misc2_rndg_cd :=
903: ben_cpd_shd.g_old_rec.misc2_rndg_cd;
899: ben_cpd_shd.g_old_rec.misc2_nnmntry_uom;
900: End If;
901: If (p_rec.misc2_rndg_cd = hr_api.g_varchar2) then
902: p_rec.misc2_rndg_cd :=
903: ben_cpd_shd.g_old_rec.misc2_rndg_cd;
904: End If;
905: If (p_rec.misc3_abr_id = hr_api.g_number) then
906: p_rec.misc3_abr_id :=
907: ben_cpd_shd.g_old_rec.misc3_abr_id;
903: ben_cpd_shd.g_old_rec.misc2_rndg_cd;
904: End If;
905: If (p_rec.misc3_abr_id = hr_api.g_number) then
906: p_rec.misc3_abr_id :=
907: ben_cpd_shd.g_old_rec.misc3_abr_id;
908: End If;
909: If (p_rec.misc3_nnmntry_uom = hr_api.g_varchar2) then
910: p_rec.misc3_nnmntry_uom :=
911: ben_cpd_shd.g_old_rec.misc3_nnmntry_uom;
907: ben_cpd_shd.g_old_rec.misc3_abr_id;
908: End If;
909: If (p_rec.misc3_nnmntry_uom = hr_api.g_varchar2) then
910: p_rec.misc3_nnmntry_uom :=
911: ben_cpd_shd.g_old_rec.misc3_nnmntry_uom;
912: End If;
913: If (p_rec.misc3_rndg_cd = hr_api.g_varchar2) then
914: p_rec.misc3_rndg_cd :=
915: ben_cpd_shd.g_old_rec.misc3_rndg_cd;
911: ben_cpd_shd.g_old_rec.misc3_nnmntry_uom;
912: End If;
913: If (p_rec.misc3_rndg_cd = hr_api.g_varchar2) then
914: p_rec.misc3_rndg_cd :=
915: ben_cpd_shd.g_old_rec.misc3_rndg_cd;
916: End If;
917: If (p_rec.stat_sal_abr_id = hr_api.g_number) then
918: p_rec.stat_sal_abr_id :=
919: ben_cpd_shd.g_old_rec.stat_sal_abr_id;
915: ben_cpd_shd.g_old_rec.misc3_rndg_cd;
916: End If;
917: If (p_rec.stat_sal_abr_id = hr_api.g_number) then
918: p_rec.stat_sal_abr_id :=
919: ben_cpd_shd.g_old_rec.stat_sal_abr_id;
920: End If;
921: If (p_rec.stat_sal_nnmntry_uom = hr_api.g_varchar2) then
922: p_rec.stat_sal_nnmntry_uom :=
923: ben_cpd_shd.g_old_rec.stat_sal_nnmntry_uom;
919: ben_cpd_shd.g_old_rec.stat_sal_abr_id;
920: End If;
921: If (p_rec.stat_sal_nnmntry_uom = hr_api.g_varchar2) then
922: p_rec.stat_sal_nnmntry_uom :=
923: ben_cpd_shd.g_old_rec.stat_sal_nnmntry_uom;
924: End If;
925: If (p_rec.stat_sal_rndg_cd = hr_api.g_varchar2) then
926: p_rec.stat_sal_rndg_cd :=
927: ben_cpd_shd.g_old_rec.stat_sal_rndg_cd;
923: ben_cpd_shd.g_old_rec.stat_sal_nnmntry_uom;
924: End If;
925: If (p_rec.stat_sal_rndg_cd = hr_api.g_varchar2) then
926: p_rec.stat_sal_rndg_cd :=
927: ben_cpd_shd.g_old_rec.stat_sal_rndg_cd;
928: End If;
929: If (p_rec.rec_abr_id = hr_api.g_number) then
930: p_rec.rec_abr_id :=
931: ben_cpd_shd.g_old_rec.rec_abr_id;
927: ben_cpd_shd.g_old_rec.stat_sal_rndg_cd;
928: End If;
929: If (p_rec.rec_abr_id = hr_api.g_number) then
930: p_rec.rec_abr_id :=
931: ben_cpd_shd.g_old_rec.rec_abr_id;
932: End If;
933: If (p_rec.rec_nnmntry_uom = hr_api.g_varchar2) then
934: p_rec.rec_nnmntry_uom :=
935: ben_cpd_shd.g_old_rec.rec_nnmntry_uom;
931: ben_cpd_shd.g_old_rec.rec_abr_id;
932: End If;
933: If (p_rec.rec_nnmntry_uom = hr_api.g_varchar2) then
934: p_rec.rec_nnmntry_uom :=
935: ben_cpd_shd.g_old_rec.rec_nnmntry_uom;
936: End If;
937: If (p_rec.rec_rndg_cd = hr_api.g_varchar2) then
938: p_rec.rec_rndg_cd :=
939: ben_cpd_shd.g_old_rec.rec_rndg_cd;
935: ben_cpd_shd.g_old_rec.rec_nnmntry_uom;
936: End If;
937: If (p_rec.rec_rndg_cd = hr_api.g_varchar2) then
938: p_rec.rec_rndg_cd :=
939: ben_cpd_shd.g_old_rec.rec_rndg_cd;
940: End If;
941: If (p_rec.tot_comp_abr_id = hr_api.g_number) then
942: p_rec.tot_comp_abr_id :=
943: ben_cpd_shd.g_old_rec.tot_comp_abr_id;
939: ben_cpd_shd.g_old_rec.rec_rndg_cd;
940: End If;
941: If (p_rec.tot_comp_abr_id = hr_api.g_number) then
942: p_rec.tot_comp_abr_id :=
943: ben_cpd_shd.g_old_rec.tot_comp_abr_id;
944: End If;
945: If (p_rec.tot_comp_nnmntry_uom = hr_api.g_varchar2) then
946: p_rec.tot_comp_nnmntry_uom :=
947: ben_cpd_shd.g_old_rec.tot_comp_nnmntry_uom;
943: ben_cpd_shd.g_old_rec.tot_comp_abr_id;
944: End If;
945: If (p_rec.tot_comp_nnmntry_uom = hr_api.g_varchar2) then
946: p_rec.tot_comp_nnmntry_uom :=
947: ben_cpd_shd.g_old_rec.tot_comp_nnmntry_uom;
948: End If;
949: If (p_rec.tot_comp_rndg_cd = hr_api.g_varchar2) then
950: p_rec.tot_comp_rndg_cd :=
951: ben_cpd_shd.g_old_rec.tot_comp_rndg_cd;
947: ben_cpd_shd.g_old_rec.tot_comp_nnmntry_uom;
948: End If;
949: If (p_rec.tot_comp_rndg_cd = hr_api.g_varchar2) then
950: p_rec.tot_comp_rndg_cd :=
951: ben_cpd_shd.g_old_rec.tot_comp_rndg_cd;
952: End If;
953: If (p_rec.oth_comp_abr_id = hr_api.g_number) then
954: p_rec.oth_comp_abr_id :=
955: ben_cpd_shd.g_old_rec.oth_comp_abr_id;
951: ben_cpd_shd.g_old_rec.tot_comp_rndg_cd;
952: End If;
953: If (p_rec.oth_comp_abr_id = hr_api.g_number) then
954: p_rec.oth_comp_abr_id :=
955: ben_cpd_shd.g_old_rec.oth_comp_abr_id;
956: End If;
957: If (p_rec.oth_comp_nnmntry_uom = hr_api.g_varchar2) then
958: p_rec.oth_comp_nnmntry_uom :=
959: ben_cpd_shd.g_old_rec.oth_comp_nnmntry_uom;
955: ben_cpd_shd.g_old_rec.oth_comp_abr_id;
956: End If;
957: If (p_rec.oth_comp_nnmntry_uom = hr_api.g_varchar2) then
958: p_rec.oth_comp_nnmntry_uom :=
959: ben_cpd_shd.g_old_rec.oth_comp_nnmntry_uom;
960: End If;
961: If (p_rec.oth_comp_rndg_cd = hr_api.g_varchar2) then
962: p_rec.oth_comp_rndg_cd :=
963: ben_cpd_shd.g_old_rec.oth_comp_rndg_cd;
959: ben_cpd_shd.g_old_rec.oth_comp_nnmntry_uom;
960: End If;
961: If (p_rec.oth_comp_rndg_cd = hr_api.g_varchar2) then
962: p_rec.oth_comp_rndg_cd :=
963: ben_cpd_shd.g_old_rec.oth_comp_rndg_cd;
964: End If;
965: If (p_rec.actual_flag = hr_api.g_varchar2) then
966: p_rec.actual_flag :=
967: ben_cpd_shd.g_old_rec.actual_flag;
963: ben_cpd_shd.g_old_rec.oth_comp_rndg_cd;
964: End If;
965: If (p_rec.actual_flag = hr_api.g_varchar2) then
966: p_rec.actual_flag :=
967: ben_cpd_shd.g_old_rec.actual_flag;
968: End If;
969: If (p_rec.acty_ref_perd_cd = hr_api.g_varchar2) then
970: p_rec.acty_ref_perd_cd :=
971: ben_cpd_shd.g_old_rec.acty_ref_perd_cd;
967: ben_cpd_shd.g_old_rec.actual_flag;
968: End If;
969: If (p_rec.acty_ref_perd_cd = hr_api.g_varchar2) then
970: p_rec.acty_ref_perd_cd :=
971: ben_cpd_shd.g_old_rec.acty_ref_perd_cd;
972: End If;
973: If (p_rec.legislation_code = hr_api.g_varchar2) then
974: p_rec.legislation_code :=
975: ben_cpd_shd.g_old_rec.legislation_code;
971: ben_cpd_shd.g_old_rec.acty_ref_perd_cd;
972: End If;
973: If (p_rec.legislation_code = hr_api.g_varchar2) then
974: p_rec.legislation_code :=
975: ben_cpd_shd.g_old_rec.legislation_code;
976: End If;
977: If (p_rec.pl_annulization_factor = hr_api.g_number) then
978: p_rec.pl_annulization_factor :=
979: ben_cpd_shd.g_old_rec.pl_annulization_factor;
975: ben_cpd_shd.g_old_rec.legislation_code;
976: End If;
977: If (p_rec.pl_annulization_factor = hr_api.g_number) then
978: p_rec.pl_annulization_factor :=
979: ben_cpd_shd.g_old_rec.pl_annulization_factor;
980: End If;
981: If (p_rec.pl_stat_cd = hr_api.g_varchar2) then
982: p_rec.pl_stat_cd :=
983: ben_cpd_shd.g_old_rec.pl_stat_cd;
979: ben_cpd_shd.g_old_rec.pl_annulization_factor;
980: End If;
981: If (p_rec.pl_stat_cd = hr_api.g_varchar2) then
982: p_rec.pl_stat_cd :=
983: ben_cpd_shd.g_old_rec.pl_stat_cd;
984: End If;
985: If (p_rec.uom_precision = hr_api.g_number) then
986: p_rec.uom_precision :=
987: ben_cpd_shd.g_old_rec.uom_precision;
983: ben_cpd_shd.g_old_rec.pl_stat_cd;
984: End If;
985: If (p_rec.uom_precision = hr_api.g_number) then
986: p_rec.uom_precision :=
987: ben_cpd_shd.g_old_rec.uom_precision;
988: End If;
989: If (p_rec.ws_element_type_id = hr_api.g_number) then
990: p_rec.ws_element_type_id :=
991: ben_cpd_shd.g_old_rec.ws_element_type_id;
987: ben_cpd_shd.g_old_rec.uom_precision;
988: End If;
989: If (p_rec.ws_element_type_id = hr_api.g_number) then
990: p_rec.ws_element_type_id :=
991: ben_cpd_shd.g_old_rec.ws_element_type_id;
992: End If;
993: If (p_rec.ws_input_value_id = hr_api.g_number) then
994: p_rec.ws_input_value_id :=
995: ben_cpd_shd.g_old_rec.ws_input_value_id;
991: ben_cpd_shd.g_old_rec.ws_element_type_id;
992: End If;
993: If (p_rec.ws_input_value_id = hr_api.g_number) then
994: p_rec.ws_input_value_id :=
995: ben_cpd_shd.g_old_rec.ws_input_value_id;
996: End if;
997: If (p_rec.data_freeze_date = hr_api.g_date) then
998: p_rec.data_freeze_date :=
999: ben_cpd_shd.g_old_rec.data_freeze_date;
995: ben_cpd_shd.g_old_rec.ws_input_value_id;
996: End if;
997: If (p_rec.data_freeze_date = hr_api.g_date) then
998: p_rec.data_freeze_date :=
999: ben_cpd_shd.g_old_rec.data_freeze_date;
1000: End If;
1001: If (p_rec.ws_amt_edit_cd = hr_api.g_varchar2) then
1002: p_rec.ws_amt_edit_cd :=
1003: ben_cpd_shd.g_old_rec.ws_amt_edit_cd;
999: ben_cpd_shd.g_old_rec.data_freeze_date;
1000: End If;
1001: If (p_rec.ws_amt_edit_cd = hr_api.g_varchar2) then
1002: p_rec.ws_amt_edit_cd :=
1003: ben_cpd_shd.g_old_rec.ws_amt_edit_cd;
1004: End If;
1005: If (p_rec.ws_amt_edit_enf_cd_for_nulls = hr_api.g_varchar2) then
1006: p_rec.ws_amt_edit_enf_cd_for_nulls :=
1007: ben_cpd_shd.g_old_rec.ws_amt_edit_enf_cd_for_nulls;
1003: ben_cpd_shd.g_old_rec.ws_amt_edit_cd;
1004: End If;
1005: If (p_rec.ws_amt_edit_enf_cd_for_nulls = hr_api.g_varchar2) then
1006: p_rec.ws_amt_edit_enf_cd_for_nulls :=
1007: ben_cpd_shd.g_old_rec.ws_amt_edit_enf_cd_for_nulls;
1008: End If;
1009: If (p_rec.ws_over_budget_edit_cd = hr_api.g_varchar2) then
1010: p_rec.ws_over_budget_edit_cd :=
1011: ben_cpd_shd.g_old_rec.ws_over_budget_edit_cd;
1007: ben_cpd_shd.g_old_rec.ws_amt_edit_enf_cd_for_nulls;
1008: End If;
1009: If (p_rec.ws_over_budget_edit_cd = hr_api.g_varchar2) then
1010: p_rec.ws_over_budget_edit_cd :=
1011: ben_cpd_shd.g_old_rec.ws_over_budget_edit_cd;
1012: End If;
1013: If (p_rec.ws_over_budget_tolerance_pct = hr_api.g_number) then
1014: p_rec.ws_over_budget_tolerance_pct :=
1015: ben_cpd_shd.g_old_rec.ws_over_budget_tolerance_pct;
1011: ben_cpd_shd.g_old_rec.ws_over_budget_edit_cd;
1012: End If;
1013: If (p_rec.ws_over_budget_tolerance_pct = hr_api.g_number) then
1014: p_rec.ws_over_budget_tolerance_pct :=
1015: ben_cpd_shd.g_old_rec.ws_over_budget_tolerance_pct;
1016: End If;
1017: If (p_rec.bdgt_over_budget_edit_cd = hr_api.g_varchar2) then
1018: p_rec.bdgt_over_budget_edit_cd :=
1019: ben_cpd_shd.g_old_rec.bdgt_over_budget_edit_cd;
1015: ben_cpd_shd.g_old_rec.ws_over_budget_tolerance_pct;
1016: End If;
1017: If (p_rec.bdgt_over_budget_edit_cd = hr_api.g_varchar2) then
1018: p_rec.bdgt_over_budget_edit_cd :=
1019: ben_cpd_shd.g_old_rec.bdgt_over_budget_edit_cd;
1020: End If;
1021: If (p_rec.bdgt_over_budget_tolerance_pct = hr_api.g_number) then
1022: p_rec.bdgt_over_budget_tolerance_pct :=
1023: ben_cpd_shd.g_old_rec.bdgt_over_budget_tolerance_pct;
1019: ben_cpd_shd.g_old_rec.bdgt_over_budget_edit_cd;
1020: End If;
1021: If (p_rec.bdgt_over_budget_tolerance_pct = hr_api.g_number) then
1022: p_rec.bdgt_over_budget_tolerance_pct :=
1023: ben_cpd_shd.g_old_rec.bdgt_over_budget_tolerance_pct;
1024: End If;
1025: If (p_rec.auto_distr_flag = hr_api.g_varchar2) then
1026: p_rec.auto_distr_flag :=
1027: ben_cpd_shd.g_old_rec.auto_distr_flag;
1023: ben_cpd_shd.g_old_rec.bdgt_over_budget_tolerance_pct;
1024: End If;
1025: If (p_rec.auto_distr_flag = hr_api.g_varchar2) then
1026: p_rec.auto_distr_flag :=
1027: ben_cpd_shd.g_old_rec.auto_distr_flag;
1028: End If;
1029: If (p_rec.pqh_document_short_name = hr_api.g_varchar2) then
1030: p_rec.pqh_document_short_name :=
1031: ben_cpd_shd.g_old_rec.pqh_document_short_name;
1027: ben_cpd_shd.g_old_rec.auto_distr_flag;
1028: End If;
1029: If (p_rec.pqh_document_short_name = hr_api.g_varchar2) then
1030: p_rec.pqh_document_short_name :=
1031: ben_cpd_shd.g_old_rec.pqh_document_short_name;
1032: End If;
1033: If (p_rec.ovrid_rt_strt_dt = hr_api.g_date) then
1034: p_rec.ovrid_rt_strt_dt :=
1035: ben_cpd_shd.g_old_rec.ovrid_rt_strt_dt;
1031: ben_cpd_shd.g_old_rec.pqh_document_short_name;
1032: End If;
1033: If (p_rec.ovrid_rt_strt_dt = hr_api.g_date) then
1034: p_rec.ovrid_rt_strt_dt :=
1035: ben_cpd_shd.g_old_rec.ovrid_rt_strt_dt;
1036: End If;
1037: If (p_rec.do_not_process_flag = hr_api.g_varchar2) then
1038: p_rec.do_not_process_flag :=
1039: ben_cpd_shd.g_old_rec.do_not_process_flag;
1035: ben_cpd_shd.g_old_rec.ovrid_rt_strt_dt;
1036: End If;
1037: If (p_rec.do_not_process_flag = hr_api.g_varchar2) then
1038: p_rec.do_not_process_flag :=
1039: ben_cpd_shd.g_old_rec.do_not_process_flag;
1040: End If;
1041: If (p_rec.ovr_perf_revw_strt_dt = hr_api.g_date) then
1042: p_rec.ovr_perf_revw_strt_dt :=
1043: ben_cpd_shd.g_old_rec.ovr_perf_revw_strt_dt;
1039: ben_cpd_shd.g_old_rec.do_not_process_flag;
1040: End If;
1041: If (p_rec.ovr_perf_revw_strt_dt = hr_api.g_date) then
1042: p_rec.ovr_perf_revw_strt_dt :=
1043: ben_cpd_shd.g_old_rec.ovr_perf_revw_strt_dt;
1044: End If;
1045: --
1046: End convert_defs;
1047: --
1048: -- ----------------------------------------------------------------------------
1049: -- |---------------------------------< upd >----------------------------------|
1050: -- ----------------------------------------------------------------------------
1051: Procedure upd
1052: (p_rec in out nocopy ben_cpd_shd.g_rec_type
1053: ) is
1054: --
1055: l_proc varchar2(72) := g_package||'upd';
1056: --
1058: hr_utility.set_location('Entering:'||l_proc, 5);
1059: --
1060: -- We must lock the row which we need to update.
1061: --
1062: ben_cpd_shd.lck
1063: (p_rec.pl_id
1064: ,p_rec.lf_evt_ocrd_dt
1065: ,p_rec.oipl_id
1066: ,p_rec.object_version_number
1193: ,p_do_not_process_flag in varchar2 default hr_api.g_varchar2
1194: ,p_ovr_perf_revw_strt_dt in date default hr_api.g_date
1195: ) is
1196: --
1197: l_rec ben_cpd_shd.g_rec_type;
1198: l_proc varchar2(72) := g_package||'upd';
1199: --
1200: Begin
1201: hr_utility.set_location('Entering:'||l_proc, 5);
1203: -- Call conversion function to turn arguments into the
1204: -- l_rec structure.
1205: --
1206: l_rec :=
1207: ben_cpd_shd.convert_args
1208: (p_pl_id
1209: ,p_oipl_id
1210: ,p_lf_evt_ocrd_dt
1211: ,p_effective_date