[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
170: where pl_id = p_rec.pl_id
171: and lf_evt_ocrd_dt = p_rec.lf_evt_ocrd_dt
172: and oipl_id = p_rec.oipl_id;
173: --
174: ben_cpd_shd.g_api_dml := false; -- Unset the api dml status
175: --
176: hr_utility.set_location(' Leaving:'||l_proc, 10);
177: --
178: Exception
177: --
178: Exception
179: When hr_api.check_integrity_violated Then
180: -- A check constraint has been violated
181: ben_cpd_shd.g_api_dml := false; -- Unset the api dml status
182: ben_cpd_shd.constraint_error
183: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
184: When hr_api.parent_integrity_violated Then
185: -- Parent integrity has been violated
178: Exception
179: When hr_api.check_integrity_violated Then
180: -- A check constraint has been violated
181: ben_cpd_shd.g_api_dml := false; -- Unset the api dml status
182: ben_cpd_shd.constraint_error
183: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
184: When hr_api.parent_integrity_violated Then
185: -- Parent integrity has been violated
186: ben_cpd_shd.g_api_dml := false; -- Unset the api dml status
182: ben_cpd_shd.constraint_error
183: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
184: When hr_api.parent_integrity_violated Then
185: -- Parent integrity has been violated
186: ben_cpd_shd.g_api_dml := false; -- Unset the api dml status
187: ben_cpd_shd.constraint_error
188: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
189: When hr_api.unique_integrity_violated Then
190: -- Unique integrity has been violated
183: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
184: When hr_api.parent_integrity_violated Then
185: -- Parent integrity has been violated
186: ben_cpd_shd.g_api_dml := false; -- Unset the api dml status
187: ben_cpd_shd.constraint_error
188: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
189: When hr_api.unique_integrity_violated Then
190: -- Unique integrity has been violated
191: ben_cpd_shd.g_api_dml := false; -- Unset the api dml status
187: ben_cpd_shd.constraint_error
188: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
189: When hr_api.unique_integrity_violated Then
190: -- Unique integrity has been violated
191: ben_cpd_shd.g_api_dml := false; -- Unset the api dml status
192: ben_cpd_shd.constraint_error
193: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
194: When Others Then
195: ben_cpd_shd.g_api_dml := false; -- Unset the api dml status
188: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
189: When hr_api.unique_integrity_violated Then
190: -- Unique integrity has been violated
191: ben_cpd_shd.g_api_dml := false; -- Unset the api dml status
192: ben_cpd_shd.constraint_error
193: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
194: When Others Then
195: ben_cpd_shd.g_api_dml := false; -- Unset the api dml status
196: Raise;
191: ben_cpd_shd.g_api_dml := false; -- Unset the api dml status
192: ben_cpd_shd.constraint_error
193: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
194: When Others Then
195: ben_cpd_shd.g_api_dml := false; -- Unset the api dml status
196: Raise;
197: End update_dml;
198: --
199: -- ----------------------------------------------------------------------------
228: --
229: -- {End Of Comments}
230: -- ----------------------------------------------------------------------------
231: Procedure pre_update
232: (p_rec in ben_cpd_shd.g_rec_type
233: ) is
234: --
235: l_proc varchar2(72) := g_package||'pre_update';
236: --
272: --
273: -- {End Of Comments}
274: -- ----------------------------------------------------------------------------
275: Procedure post_update
276: (p_rec in ben_cpd_shd.g_rec_type
277: ) is
278: --
279: l_proc varchar2(72) := g_package||'post_update';
280: --
477: => p_rec.email_subject
478: ,p_email_sample_address
479: => p_rec.email_sample_address
480: ,p_effective_date_o
481: => ben_cpd_shd.g_old_rec.effective_date
482: ,p_name_o
483: => ben_cpd_shd.g_old_rec.name
484: ,p_group_pl_id_o
485: => ben_cpd_shd.g_old_rec.group_pl_id
479: => p_rec.email_sample_address
480: ,p_effective_date_o
481: => ben_cpd_shd.g_old_rec.effective_date
482: ,p_name_o
483: => ben_cpd_shd.g_old_rec.name
484: ,p_group_pl_id_o
485: => ben_cpd_shd.g_old_rec.group_pl_id
486: ,p_group_oipl_id_o
487: => ben_cpd_shd.g_old_rec.group_oipl_id
481: => ben_cpd_shd.g_old_rec.effective_date
482: ,p_name_o
483: => ben_cpd_shd.g_old_rec.name
484: ,p_group_pl_id_o
485: => ben_cpd_shd.g_old_rec.group_pl_id
486: ,p_group_oipl_id_o
487: => ben_cpd_shd.g_old_rec.group_oipl_id
488: ,p_opt_hidden_flag_o
489: => ben_cpd_shd.g_old_rec.opt_hidden_flag
483: => ben_cpd_shd.g_old_rec.name
484: ,p_group_pl_id_o
485: => ben_cpd_shd.g_old_rec.group_pl_id
486: ,p_group_oipl_id_o
487: => ben_cpd_shd.g_old_rec.group_oipl_id
488: ,p_opt_hidden_flag_o
489: => ben_cpd_shd.g_old_rec.opt_hidden_flag
490: ,p_opt_id_o
491: => ben_cpd_shd.g_old_rec.opt_id
485: => ben_cpd_shd.g_old_rec.group_pl_id
486: ,p_group_oipl_id_o
487: => ben_cpd_shd.g_old_rec.group_oipl_id
488: ,p_opt_hidden_flag_o
489: => ben_cpd_shd.g_old_rec.opt_hidden_flag
490: ,p_opt_id_o
491: => ben_cpd_shd.g_old_rec.opt_id
492: ,p_pl_uom_o
493: => ben_cpd_shd.g_old_rec.pl_uom
487: => ben_cpd_shd.g_old_rec.group_oipl_id
488: ,p_opt_hidden_flag_o
489: => ben_cpd_shd.g_old_rec.opt_hidden_flag
490: ,p_opt_id_o
491: => ben_cpd_shd.g_old_rec.opt_id
492: ,p_pl_uom_o
493: => ben_cpd_shd.g_old_rec.pl_uom
494: ,p_pl_ordr_num_o
495: => ben_cpd_shd.g_old_rec.pl_ordr_num
489: => ben_cpd_shd.g_old_rec.opt_hidden_flag
490: ,p_opt_id_o
491: => ben_cpd_shd.g_old_rec.opt_id
492: ,p_pl_uom_o
493: => ben_cpd_shd.g_old_rec.pl_uom
494: ,p_pl_ordr_num_o
495: => ben_cpd_shd.g_old_rec.pl_ordr_num
496: ,p_oipl_ordr_num_o
497: => ben_cpd_shd.g_old_rec.oipl_ordr_num
491: => ben_cpd_shd.g_old_rec.opt_id
492: ,p_pl_uom_o
493: => ben_cpd_shd.g_old_rec.pl_uom
494: ,p_pl_ordr_num_o
495: => ben_cpd_shd.g_old_rec.pl_ordr_num
496: ,p_oipl_ordr_num_o
497: => ben_cpd_shd.g_old_rec.oipl_ordr_num
498: ,p_pl_xchg_rate_o
499: => ben_cpd_shd.g_old_rec.pl_xchg_rate
493: => ben_cpd_shd.g_old_rec.pl_uom
494: ,p_pl_ordr_num_o
495: => ben_cpd_shd.g_old_rec.pl_ordr_num
496: ,p_oipl_ordr_num_o
497: => ben_cpd_shd.g_old_rec.oipl_ordr_num
498: ,p_pl_xchg_rate_o
499: => ben_cpd_shd.g_old_rec.pl_xchg_rate
500: ,p_opt_count_o
501: => ben_cpd_shd.g_old_rec.opt_count
495: => ben_cpd_shd.g_old_rec.pl_ordr_num
496: ,p_oipl_ordr_num_o
497: => ben_cpd_shd.g_old_rec.oipl_ordr_num
498: ,p_pl_xchg_rate_o
499: => ben_cpd_shd.g_old_rec.pl_xchg_rate
500: ,p_opt_count_o
501: => ben_cpd_shd.g_old_rec.opt_count
502: ,p_uses_bdgt_flag_o
503: => ben_cpd_shd.g_old_rec.uses_bdgt_flag
497: => ben_cpd_shd.g_old_rec.oipl_ordr_num
498: ,p_pl_xchg_rate_o
499: => ben_cpd_shd.g_old_rec.pl_xchg_rate
500: ,p_opt_count_o
501: => ben_cpd_shd.g_old_rec.opt_count
502: ,p_uses_bdgt_flag_o
503: => ben_cpd_shd.g_old_rec.uses_bdgt_flag
504: ,p_prsrv_bdgt_cd_o
505: => ben_cpd_shd.g_old_rec.prsrv_bdgt_cd
499: => ben_cpd_shd.g_old_rec.pl_xchg_rate
500: ,p_opt_count_o
501: => ben_cpd_shd.g_old_rec.opt_count
502: ,p_uses_bdgt_flag_o
503: => ben_cpd_shd.g_old_rec.uses_bdgt_flag
504: ,p_prsrv_bdgt_cd_o
505: => ben_cpd_shd.g_old_rec.prsrv_bdgt_cd
506: ,p_upd_start_dt_o
507: => ben_cpd_shd.g_old_rec.upd_start_dt
501: => ben_cpd_shd.g_old_rec.opt_count
502: ,p_uses_bdgt_flag_o
503: => ben_cpd_shd.g_old_rec.uses_bdgt_flag
504: ,p_prsrv_bdgt_cd_o
505: => ben_cpd_shd.g_old_rec.prsrv_bdgt_cd
506: ,p_upd_start_dt_o
507: => ben_cpd_shd.g_old_rec.upd_start_dt
508: ,p_upd_end_dt_o
509: => ben_cpd_shd.g_old_rec.upd_end_dt
503: => ben_cpd_shd.g_old_rec.uses_bdgt_flag
504: ,p_prsrv_bdgt_cd_o
505: => ben_cpd_shd.g_old_rec.prsrv_bdgt_cd
506: ,p_upd_start_dt_o
507: => ben_cpd_shd.g_old_rec.upd_start_dt
508: ,p_upd_end_dt_o
509: => ben_cpd_shd.g_old_rec.upd_end_dt
510: ,p_approval_mode_o
511: => ben_cpd_shd.g_old_rec.approval_mode
505: => ben_cpd_shd.g_old_rec.prsrv_bdgt_cd
506: ,p_upd_start_dt_o
507: => ben_cpd_shd.g_old_rec.upd_start_dt
508: ,p_upd_end_dt_o
509: => ben_cpd_shd.g_old_rec.upd_end_dt
510: ,p_approval_mode_o
511: => ben_cpd_shd.g_old_rec.approval_mode
512: ,p_enrt_perd_start_dt_o
513: => ben_cpd_shd.g_old_rec.enrt_perd_start_dt
507: => ben_cpd_shd.g_old_rec.upd_start_dt
508: ,p_upd_end_dt_o
509: => ben_cpd_shd.g_old_rec.upd_end_dt
510: ,p_approval_mode_o
511: => ben_cpd_shd.g_old_rec.approval_mode
512: ,p_enrt_perd_start_dt_o
513: => ben_cpd_shd.g_old_rec.enrt_perd_start_dt
514: ,p_enrt_perd_end_dt_o
515: => ben_cpd_shd.g_old_rec.enrt_perd_end_dt
509: => ben_cpd_shd.g_old_rec.upd_end_dt
510: ,p_approval_mode_o
511: => ben_cpd_shd.g_old_rec.approval_mode
512: ,p_enrt_perd_start_dt_o
513: => ben_cpd_shd.g_old_rec.enrt_perd_start_dt
514: ,p_enrt_perd_end_dt_o
515: => ben_cpd_shd.g_old_rec.enrt_perd_end_dt
516: ,p_yr_perd_start_dt_o
517: => ben_cpd_shd.g_old_rec.yr_perd_start_dt
511: => ben_cpd_shd.g_old_rec.approval_mode
512: ,p_enrt_perd_start_dt_o
513: => ben_cpd_shd.g_old_rec.enrt_perd_start_dt
514: ,p_enrt_perd_end_dt_o
515: => ben_cpd_shd.g_old_rec.enrt_perd_end_dt
516: ,p_yr_perd_start_dt_o
517: => ben_cpd_shd.g_old_rec.yr_perd_start_dt
518: ,p_yr_perd_end_dt_o
519: => ben_cpd_shd.g_old_rec.yr_perd_end_dt
513: => ben_cpd_shd.g_old_rec.enrt_perd_start_dt
514: ,p_enrt_perd_end_dt_o
515: => ben_cpd_shd.g_old_rec.enrt_perd_end_dt
516: ,p_yr_perd_start_dt_o
517: => ben_cpd_shd.g_old_rec.yr_perd_start_dt
518: ,p_yr_perd_end_dt_o
519: => ben_cpd_shd.g_old_rec.yr_perd_end_dt
520: ,p_wthn_yr_start_dt_o
521: => ben_cpd_shd.g_old_rec.wthn_yr_start_dt
515: => ben_cpd_shd.g_old_rec.enrt_perd_end_dt
516: ,p_yr_perd_start_dt_o
517: => ben_cpd_shd.g_old_rec.yr_perd_start_dt
518: ,p_yr_perd_end_dt_o
519: => ben_cpd_shd.g_old_rec.yr_perd_end_dt
520: ,p_wthn_yr_start_dt_o
521: => ben_cpd_shd.g_old_rec.wthn_yr_start_dt
522: ,p_wthn_yr_end_dt_o
523: => ben_cpd_shd.g_old_rec.wthn_yr_end_dt
517: => ben_cpd_shd.g_old_rec.yr_perd_start_dt
518: ,p_yr_perd_end_dt_o
519: => ben_cpd_shd.g_old_rec.yr_perd_end_dt
520: ,p_wthn_yr_start_dt_o
521: => ben_cpd_shd.g_old_rec.wthn_yr_start_dt
522: ,p_wthn_yr_end_dt_o
523: => ben_cpd_shd.g_old_rec.wthn_yr_end_dt
524: ,p_enrt_perd_id_o
525: => ben_cpd_shd.g_old_rec.enrt_perd_id
519: => ben_cpd_shd.g_old_rec.yr_perd_end_dt
520: ,p_wthn_yr_start_dt_o
521: => ben_cpd_shd.g_old_rec.wthn_yr_start_dt
522: ,p_wthn_yr_end_dt_o
523: => ben_cpd_shd.g_old_rec.wthn_yr_end_dt
524: ,p_enrt_perd_id_o
525: => ben_cpd_shd.g_old_rec.enrt_perd_id
526: ,p_yr_perd_id_o
527: => ben_cpd_shd.g_old_rec.yr_perd_id
521: => ben_cpd_shd.g_old_rec.wthn_yr_start_dt
522: ,p_wthn_yr_end_dt_o
523: => ben_cpd_shd.g_old_rec.wthn_yr_end_dt
524: ,p_enrt_perd_id_o
525: => ben_cpd_shd.g_old_rec.enrt_perd_id
526: ,p_yr_perd_id_o
527: => ben_cpd_shd.g_old_rec.yr_perd_id
528: ,p_business_group_id_o
529: => ben_cpd_shd.g_old_rec.business_group_id
523: => ben_cpd_shd.g_old_rec.wthn_yr_end_dt
524: ,p_enrt_perd_id_o
525: => ben_cpd_shd.g_old_rec.enrt_perd_id
526: ,p_yr_perd_id_o
527: => ben_cpd_shd.g_old_rec.yr_perd_id
528: ,p_business_group_id_o
529: => ben_cpd_shd.g_old_rec.business_group_id
530: ,p_perf_revw_strt_dt_o
531: => ben_cpd_shd.g_old_rec.perf_revw_strt_dt
525: => ben_cpd_shd.g_old_rec.enrt_perd_id
526: ,p_yr_perd_id_o
527: => ben_cpd_shd.g_old_rec.yr_perd_id
528: ,p_business_group_id_o
529: => ben_cpd_shd.g_old_rec.business_group_id
530: ,p_perf_revw_strt_dt_o
531: => ben_cpd_shd.g_old_rec.perf_revw_strt_dt
532: ,p_asg_updt_eff_date_o
533: => ben_cpd_shd.g_old_rec.asg_updt_eff_date
527: => ben_cpd_shd.g_old_rec.yr_perd_id
528: ,p_business_group_id_o
529: => ben_cpd_shd.g_old_rec.business_group_id
530: ,p_perf_revw_strt_dt_o
531: => ben_cpd_shd.g_old_rec.perf_revw_strt_dt
532: ,p_asg_updt_eff_date_o
533: => ben_cpd_shd.g_old_rec.asg_updt_eff_date
534: ,p_emp_interview_typ_cd_o
535: => ben_cpd_shd.g_old_rec.emp_interview_typ_cd
529: => ben_cpd_shd.g_old_rec.business_group_id
530: ,p_perf_revw_strt_dt_o
531: => ben_cpd_shd.g_old_rec.perf_revw_strt_dt
532: ,p_asg_updt_eff_date_o
533: => ben_cpd_shd.g_old_rec.asg_updt_eff_date
534: ,p_emp_interview_typ_cd_o
535: => ben_cpd_shd.g_old_rec.emp_interview_typ_cd
536: ,p_salary_change_reason_o
537: => ben_cpd_shd.g_old_rec.salary_change_reason
531: => ben_cpd_shd.g_old_rec.perf_revw_strt_dt
532: ,p_asg_updt_eff_date_o
533: => ben_cpd_shd.g_old_rec.asg_updt_eff_date
534: ,p_emp_interview_typ_cd_o
535: => ben_cpd_shd.g_old_rec.emp_interview_typ_cd
536: ,p_salary_change_reason_o
537: => ben_cpd_shd.g_old_rec.salary_change_reason
538: ,p_ws_abr_id_o
539: => ben_cpd_shd.g_old_rec.ws_abr_id
533: => ben_cpd_shd.g_old_rec.asg_updt_eff_date
534: ,p_emp_interview_typ_cd_o
535: => ben_cpd_shd.g_old_rec.emp_interview_typ_cd
536: ,p_salary_change_reason_o
537: => ben_cpd_shd.g_old_rec.salary_change_reason
538: ,p_ws_abr_id_o
539: => ben_cpd_shd.g_old_rec.ws_abr_id
540: ,p_ws_nnmntry_uom_o
541: => ben_cpd_shd.g_old_rec.ws_nnmntry_uom
535: => ben_cpd_shd.g_old_rec.emp_interview_typ_cd
536: ,p_salary_change_reason_o
537: => ben_cpd_shd.g_old_rec.salary_change_reason
538: ,p_ws_abr_id_o
539: => ben_cpd_shd.g_old_rec.ws_abr_id
540: ,p_ws_nnmntry_uom_o
541: => ben_cpd_shd.g_old_rec.ws_nnmntry_uom
542: ,p_ws_rndg_cd_o
543: => ben_cpd_shd.g_old_rec.ws_rndg_cd
537: => ben_cpd_shd.g_old_rec.salary_change_reason
538: ,p_ws_abr_id_o
539: => ben_cpd_shd.g_old_rec.ws_abr_id
540: ,p_ws_nnmntry_uom_o
541: => ben_cpd_shd.g_old_rec.ws_nnmntry_uom
542: ,p_ws_rndg_cd_o
543: => ben_cpd_shd.g_old_rec.ws_rndg_cd
544: ,p_ws_sub_acty_typ_cd_o
545: => ben_cpd_shd.g_old_rec.ws_sub_acty_typ_cd
539: => ben_cpd_shd.g_old_rec.ws_abr_id
540: ,p_ws_nnmntry_uom_o
541: => ben_cpd_shd.g_old_rec.ws_nnmntry_uom
542: ,p_ws_rndg_cd_o
543: => ben_cpd_shd.g_old_rec.ws_rndg_cd
544: ,p_ws_sub_acty_typ_cd_o
545: => ben_cpd_shd.g_old_rec.ws_sub_acty_typ_cd
546: ,p_dist_bdgt_abr_id_o
547: => ben_cpd_shd.g_old_rec.dist_bdgt_abr_id
541: => ben_cpd_shd.g_old_rec.ws_nnmntry_uom
542: ,p_ws_rndg_cd_o
543: => ben_cpd_shd.g_old_rec.ws_rndg_cd
544: ,p_ws_sub_acty_typ_cd_o
545: => ben_cpd_shd.g_old_rec.ws_sub_acty_typ_cd
546: ,p_dist_bdgt_abr_id_o
547: => ben_cpd_shd.g_old_rec.dist_bdgt_abr_id
548: ,p_dist_bdgt_nnmntry_uom_o
549: => ben_cpd_shd.g_old_rec.dist_bdgt_nnmntry_uom
543: => ben_cpd_shd.g_old_rec.ws_rndg_cd
544: ,p_ws_sub_acty_typ_cd_o
545: => ben_cpd_shd.g_old_rec.ws_sub_acty_typ_cd
546: ,p_dist_bdgt_abr_id_o
547: => ben_cpd_shd.g_old_rec.dist_bdgt_abr_id
548: ,p_dist_bdgt_nnmntry_uom_o
549: => ben_cpd_shd.g_old_rec.dist_bdgt_nnmntry_uom
550: ,p_dist_bdgt_rndg_cd_o
551: => ben_cpd_shd.g_old_rec.dist_bdgt_rndg_cd
545: => ben_cpd_shd.g_old_rec.ws_sub_acty_typ_cd
546: ,p_dist_bdgt_abr_id_o
547: => ben_cpd_shd.g_old_rec.dist_bdgt_abr_id
548: ,p_dist_bdgt_nnmntry_uom_o
549: => ben_cpd_shd.g_old_rec.dist_bdgt_nnmntry_uom
550: ,p_dist_bdgt_rndg_cd_o
551: => ben_cpd_shd.g_old_rec.dist_bdgt_rndg_cd
552: ,p_ws_bdgt_abr_id_o
553: => ben_cpd_shd.g_old_rec.ws_bdgt_abr_id
547: => ben_cpd_shd.g_old_rec.dist_bdgt_abr_id
548: ,p_dist_bdgt_nnmntry_uom_o
549: => ben_cpd_shd.g_old_rec.dist_bdgt_nnmntry_uom
550: ,p_dist_bdgt_rndg_cd_o
551: => ben_cpd_shd.g_old_rec.dist_bdgt_rndg_cd
552: ,p_ws_bdgt_abr_id_o
553: => ben_cpd_shd.g_old_rec.ws_bdgt_abr_id
554: ,p_ws_bdgt_nnmntry_uom_o
555: => ben_cpd_shd.g_old_rec.ws_bdgt_nnmntry_uom
549: => ben_cpd_shd.g_old_rec.dist_bdgt_nnmntry_uom
550: ,p_dist_bdgt_rndg_cd_o
551: => ben_cpd_shd.g_old_rec.dist_bdgt_rndg_cd
552: ,p_ws_bdgt_abr_id_o
553: => ben_cpd_shd.g_old_rec.ws_bdgt_abr_id
554: ,p_ws_bdgt_nnmntry_uom_o
555: => ben_cpd_shd.g_old_rec.ws_bdgt_nnmntry_uom
556: ,p_ws_bdgt_rndg_cd_o
557: => ben_cpd_shd.g_old_rec.ws_bdgt_rndg_cd
551: => ben_cpd_shd.g_old_rec.dist_bdgt_rndg_cd
552: ,p_ws_bdgt_abr_id_o
553: => ben_cpd_shd.g_old_rec.ws_bdgt_abr_id
554: ,p_ws_bdgt_nnmntry_uom_o
555: => ben_cpd_shd.g_old_rec.ws_bdgt_nnmntry_uom
556: ,p_ws_bdgt_rndg_cd_o
557: => ben_cpd_shd.g_old_rec.ws_bdgt_rndg_cd
558: ,p_rsrv_abr_id_o
559: => ben_cpd_shd.g_old_rec.rsrv_abr_id
553: => ben_cpd_shd.g_old_rec.ws_bdgt_abr_id
554: ,p_ws_bdgt_nnmntry_uom_o
555: => ben_cpd_shd.g_old_rec.ws_bdgt_nnmntry_uom
556: ,p_ws_bdgt_rndg_cd_o
557: => ben_cpd_shd.g_old_rec.ws_bdgt_rndg_cd
558: ,p_rsrv_abr_id_o
559: => ben_cpd_shd.g_old_rec.rsrv_abr_id
560: ,p_rsrv_nnmntry_uom_o
561: => ben_cpd_shd.g_old_rec.rsrv_nnmntry_uom
555: => ben_cpd_shd.g_old_rec.ws_bdgt_nnmntry_uom
556: ,p_ws_bdgt_rndg_cd_o
557: => ben_cpd_shd.g_old_rec.ws_bdgt_rndg_cd
558: ,p_rsrv_abr_id_o
559: => ben_cpd_shd.g_old_rec.rsrv_abr_id
560: ,p_rsrv_nnmntry_uom_o
561: => ben_cpd_shd.g_old_rec.rsrv_nnmntry_uom
562: ,p_rsrv_rndg_cd_o
563: => ben_cpd_shd.g_old_rec.rsrv_rndg_cd
557: => ben_cpd_shd.g_old_rec.ws_bdgt_rndg_cd
558: ,p_rsrv_abr_id_o
559: => ben_cpd_shd.g_old_rec.rsrv_abr_id
560: ,p_rsrv_nnmntry_uom_o
561: => ben_cpd_shd.g_old_rec.rsrv_nnmntry_uom
562: ,p_rsrv_rndg_cd_o
563: => ben_cpd_shd.g_old_rec.rsrv_rndg_cd
564: ,p_elig_sal_abr_id_o
565: => ben_cpd_shd.g_old_rec.elig_sal_abr_id
559: => ben_cpd_shd.g_old_rec.rsrv_abr_id
560: ,p_rsrv_nnmntry_uom_o
561: => ben_cpd_shd.g_old_rec.rsrv_nnmntry_uom
562: ,p_rsrv_rndg_cd_o
563: => ben_cpd_shd.g_old_rec.rsrv_rndg_cd
564: ,p_elig_sal_abr_id_o
565: => ben_cpd_shd.g_old_rec.elig_sal_abr_id
566: ,p_elig_sal_nnmntry_uom_o
567: => ben_cpd_shd.g_old_rec.elig_sal_nnmntry_uom
561: => ben_cpd_shd.g_old_rec.rsrv_nnmntry_uom
562: ,p_rsrv_rndg_cd_o
563: => ben_cpd_shd.g_old_rec.rsrv_rndg_cd
564: ,p_elig_sal_abr_id_o
565: => ben_cpd_shd.g_old_rec.elig_sal_abr_id
566: ,p_elig_sal_nnmntry_uom_o
567: => ben_cpd_shd.g_old_rec.elig_sal_nnmntry_uom
568: ,p_elig_sal_rndg_cd_o
569: => ben_cpd_shd.g_old_rec.elig_sal_rndg_cd
563: => ben_cpd_shd.g_old_rec.rsrv_rndg_cd
564: ,p_elig_sal_abr_id_o
565: => ben_cpd_shd.g_old_rec.elig_sal_abr_id
566: ,p_elig_sal_nnmntry_uom_o
567: => ben_cpd_shd.g_old_rec.elig_sal_nnmntry_uom
568: ,p_elig_sal_rndg_cd_o
569: => ben_cpd_shd.g_old_rec.elig_sal_rndg_cd
570: ,p_misc1_abr_id_o
571: => ben_cpd_shd.g_old_rec.misc1_abr_id
565: => ben_cpd_shd.g_old_rec.elig_sal_abr_id
566: ,p_elig_sal_nnmntry_uom_o
567: => ben_cpd_shd.g_old_rec.elig_sal_nnmntry_uom
568: ,p_elig_sal_rndg_cd_o
569: => ben_cpd_shd.g_old_rec.elig_sal_rndg_cd
570: ,p_misc1_abr_id_o
571: => ben_cpd_shd.g_old_rec.misc1_abr_id
572: ,p_misc1_nnmntry_uom_o
573: => ben_cpd_shd.g_old_rec.misc1_nnmntry_uom
567: => ben_cpd_shd.g_old_rec.elig_sal_nnmntry_uom
568: ,p_elig_sal_rndg_cd_o
569: => ben_cpd_shd.g_old_rec.elig_sal_rndg_cd
570: ,p_misc1_abr_id_o
571: => ben_cpd_shd.g_old_rec.misc1_abr_id
572: ,p_misc1_nnmntry_uom_o
573: => ben_cpd_shd.g_old_rec.misc1_nnmntry_uom
574: ,p_misc1_rndg_cd_o
575: => ben_cpd_shd.g_old_rec.misc1_rndg_cd
569: => ben_cpd_shd.g_old_rec.elig_sal_rndg_cd
570: ,p_misc1_abr_id_o
571: => ben_cpd_shd.g_old_rec.misc1_abr_id
572: ,p_misc1_nnmntry_uom_o
573: => ben_cpd_shd.g_old_rec.misc1_nnmntry_uom
574: ,p_misc1_rndg_cd_o
575: => ben_cpd_shd.g_old_rec.misc1_rndg_cd
576: ,p_misc2_abr_id_o
577: => ben_cpd_shd.g_old_rec.misc2_abr_id
571: => ben_cpd_shd.g_old_rec.misc1_abr_id
572: ,p_misc1_nnmntry_uom_o
573: => ben_cpd_shd.g_old_rec.misc1_nnmntry_uom
574: ,p_misc1_rndg_cd_o
575: => ben_cpd_shd.g_old_rec.misc1_rndg_cd
576: ,p_misc2_abr_id_o
577: => ben_cpd_shd.g_old_rec.misc2_abr_id
578: ,p_misc2_nnmntry_uom_o
579: => ben_cpd_shd.g_old_rec.misc2_nnmntry_uom
573: => ben_cpd_shd.g_old_rec.misc1_nnmntry_uom
574: ,p_misc1_rndg_cd_o
575: => ben_cpd_shd.g_old_rec.misc1_rndg_cd
576: ,p_misc2_abr_id_o
577: => ben_cpd_shd.g_old_rec.misc2_abr_id
578: ,p_misc2_nnmntry_uom_o
579: => ben_cpd_shd.g_old_rec.misc2_nnmntry_uom
580: ,p_misc2_rndg_cd_o
581: => ben_cpd_shd.g_old_rec.misc2_rndg_cd
575: => ben_cpd_shd.g_old_rec.misc1_rndg_cd
576: ,p_misc2_abr_id_o
577: => ben_cpd_shd.g_old_rec.misc2_abr_id
578: ,p_misc2_nnmntry_uom_o
579: => ben_cpd_shd.g_old_rec.misc2_nnmntry_uom
580: ,p_misc2_rndg_cd_o
581: => ben_cpd_shd.g_old_rec.misc2_rndg_cd
582: ,p_misc3_abr_id_o
583: => ben_cpd_shd.g_old_rec.misc3_abr_id
577: => ben_cpd_shd.g_old_rec.misc2_abr_id
578: ,p_misc2_nnmntry_uom_o
579: => ben_cpd_shd.g_old_rec.misc2_nnmntry_uom
580: ,p_misc2_rndg_cd_o
581: => ben_cpd_shd.g_old_rec.misc2_rndg_cd
582: ,p_misc3_abr_id_o
583: => ben_cpd_shd.g_old_rec.misc3_abr_id
584: ,p_misc3_nnmntry_uom_o
585: => ben_cpd_shd.g_old_rec.misc3_nnmntry_uom
579: => ben_cpd_shd.g_old_rec.misc2_nnmntry_uom
580: ,p_misc2_rndg_cd_o
581: => ben_cpd_shd.g_old_rec.misc2_rndg_cd
582: ,p_misc3_abr_id_o
583: => ben_cpd_shd.g_old_rec.misc3_abr_id
584: ,p_misc3_nnmntry_uom_o
585: => ben_cpd_shd.g_old_rec.misc3_nnmntry_uom
586: ,p_misc3_rndg_cd_o
587: => ben_cpd_shd.g_old_rec.misc3_rndg_cd
581: => ben_cpd_shd.g_old_rec.misc2_rndg_cd
582: ,p_misc3_abr_id_o
583: => ben_cpd_shd.g_old_rec.misc3_abr_id
584: ,p_misc3_nnmntry_uom_o
585: => ben_cpd_shd.g_old_rec.misc3_nnmntry_uom
586: ,p_misc3_rndg_cd_o
587: => ben_cpd_shd.g_old_rec.misc3_rndg_cd
588: ,p_stat_sal_abr_id_o
589: => ben_cpd_shd.g_old_rec.stat_sal_abr_id
583: => ben_cpd_shd.g_old_rec.misc3_abr_id
584: ,p_misc3_nnmntry_uom_o
585: => ben_cpd_shd.g_old_rec.misc3_nnmntry_uom
586: ,p_misc3_rndg_cd_o
587: => ben_cpd_shd.g_old_rec.misc3_rndg_cd
588: ,p_stat_sal_abr_id_o
589: => ben_cpd_shd.g_old_rec.stat_sal_abr_id
590: ,p_stat_sal_nnmntry_uom_o
591: => ben_cpd_shd.g_old_rec.stat_sal_nnmntry_uom
585: => ben_cpd_shd.g_old_rec.misc3_nnmntry_uom
586: ,p_misc3_rndg_cd_o
587: => ben_cpd_shd.g_old_rec.misc3_rndg_cd
588: ,p_stat_sal_abr_id_o
589: => ben_cpd_shd.g_old_rec.stat_sal_abr_id
590: ,p_stat_sal_nnmntry_uom_o
591: => ben_cpd_shd.g_old_rec.stat_sal_nnmntry_uom
592: ,p_stat_sal_rndg_cd_o
593: => ben_cpd_shd.g_old_rec.stat_sal_rndg_cd
587: => ben_cpd_shd.g_old_rec.misc3_rndg_cd
588: ,p_stat_sal_abr_id_o
589: => ben_cpd_shd.g_old_rec.stat_sal_abr_id
590: ,p_stat_sal_nnmntry_uom_o
591: => ben_cpd_shd.g_old_rec.stat_sal_nnmntry_uom
592: ,p_stat_sal_rndg_cd_o
593: => ben_cpd_shd.g_old_rec.stat_sal_rndg_cd
594: ,p_rec_abr_id_o
595: => ben_cpd_shd.g_old_rec.rec_abr_id
589: => ben_cpd_shd.g_old_rec.stat_sal_abr_id
590: ,p_stat_sal_nnmntry_uom_o
591: => ben_cpd_shd.g_old_rec.stat_sal_nnmntry_uom
592: ,p_stat_sal_rndg_cd_o
593: => ben_cpd_shd.g_old_rec.stat_sal_rndg_cd
594: ,p_rec_abr_id_o
595: => ben_cpd_shd.g_old_rec.rec_abr_id
596: ,p_rec_nnmntry_uom_o
597: => ben_cpd_shd.g_old_rec.rec_nnmntry_uom
591: => ben_cpd_shd.g_old_rec.stat_sal_nnmntry_uom
592: ,p_stat_sal_rndg_cd_o
593: => ben_cpd_shd.g_old_rec.stat_sal_rndg_cd
594: ,p_rec_abr_id_o
595: => ben_cpd_shd.g_old_rec.rec_abr_id
596: ,p_rec_nnmntry_uom_o
597: => ben_cpd_shd.g_old_rec.rec_nnmntry_uom
598: ,p_rec_rndg_cd_o
599: => ben_cpd_shd.g_old_rec.rec_rndg_cd
593: => ben_cpd_shd.g_old_rec.stat_sal_rndg_cd
594: ,p_rec_abr_id_o
595: => ben_cpd_shd.g_old_rec.rec_abr_id
596: ,p_rec_nnmntry_uom_o
597: => ben_cpd_shd.g_old_rec.rec_nnmntry_uom
598: ,p_rec_rndg_cd_o
599: => ben_cpd_shd.g_old_rec.rec_rndg_cd
600: ,p_tot_comp_abr_id_o
601: => ben_cpd_shd.g_old_rec.tot_comp_abr_id
595: => ben_cpd_shd.g_old_rec.rec_abr_id
596: ,p_rec_nnmntry_uom_o
597: => ben_cpd_shd.g_old_rec.rec_nnmntry_uom
598: ,p_rec_rndg_cd_o
599: => ben_cpd_shd.g_old_rec.rec_rndg_cd
600: ,p_tot_comp_abr_id_o
601: => ben_cpd_shd.g_old_rec.tot_comp_abr_id
602: ,p_tot_comp_nnmntry_uom_o
603: => ben_cpd_shd.g_old_rec.tot_comp_nnmntry_uom
597: => ben_cpd_shd.g_old_rec.rec_nnmntry_uom
598: ,p_rec_rndg_cd_o
599: => ben_cpd_shd.g_old_rec.rec_rndg_cd
600: ,p_tot_comp_abr_id_o
601: => ben_cpd_shd.g_old_rec.tot_comp_abr_id
602: ,p_tot_comp_nnmntry_uom_o
603: => ben_cpd_shd.g_old_rec.tot_comp_nnmntry_uom
604: ,p_tot_comp_rndg_cd_o
605: => ben_cpd_shd.g_old_rec.tot_comp_rndg_cd
599: => ben_cpd_shd.g_old_rec.rec_rndg_cd
600: ,p_tot_comp_abr_id_o
601: => ben_cpd_shd.g_old_rec.tot_comp_abr_id
602: ,p_tot_comp_nnmntry_uom_o
603: => ben_cpd_shd.g_old_rec.tot_comp_nnmntry_uom
604: ,p_tot_comp_rndg_cd_o
605: => ben_cpd_shd.g_old_rec.tot_comp_rndg_cd
606: ,p_oth_comp_abr_id_o
607: => ben_cpd_shd.g_old_rec.oth_comp_abr_id
601: => ben_cpd_shd.g_old_rec.tot_comp_abr_id
602: ,p_tot_comp_nnmntry_uom_o
603: => ben_cpd_shd.g_old_rec.tot_comp_nnmntry_uom
604: ,p_tot_comp_rndg_cd_o
605: => ben_cpd_shd.g_old_rec.tot_comp_rndg_cd
606: ,p_oth_comp_abr_id_o
607: => ben_cpd_shd.g_old_rec.oth_comp_abr_id
608: ,p_oth_comp_nnmntry_uom_o
609: => ben_cpd_shd.g_old_rec.oth_comp_nnmntry_uom
603: => ben_cpd_shd.g_old_rec.tot_comp_nnmntry_uom
604: ,p_tot_comp_rndg_cd_o
605: => ben_cpd_shd.g_old_rec.tot_comp_rndg_cd
606: ,p_oth_comp_abr_id_o
607: => ben_cpd_shd.g_old_rec.oth_comp_abr_id
608: ,p_oth_comp_nnmntry_uom_o
609: => ben_cpd_shd.g_old_rec.oth_comp_nnmntry_uom
610: ,p_oth_comp_rndg_cd_o
611: => ben_cpd_shd.g_old_rec.oth_comp_rndg_cd
605: => ben_cpd_shd.g_old_rec.tot_comp_rndg_cd
606: ,p_oth_comp_abr_id_o
607: => ben_cpd_shd.g_old_rec.oth_comp_abr_id
608: ,p_oth_comp_nnmntry_uom_o
609: => ben_cpd_shd.g_old_rec.oth_comp_nnmntry_uom
610: ,p_oth_comp_rndg_cd_o
611: => ben_cpd_shd.g_old_rec.oth_comp_rndg_cd
612: ,p_actual_flag_o
613: => ben_cpd_shd.g_old_rec.actual_flag
607: => ben_cpd_shd.g_old_rec.oth_comp_abr_id
608: ,p_oth_comp_nnmntry_uom_o
609: => ben_cpd_shd.g_old_rec.oth_comp_nnmntry_uom
610: ,p_oth_comp_rndg_cd_o
611: => ben_cpd_shd.g_old_rec.oth_comp_rndg_cd
612: ,p_actual_flag_o
613: => ben_cpd_shd.g_old_rec.actual_flag
614: ,p_acty_ref_perd_cd_o
615: => ben_cpd_shd.g_old_rec.acty_ref_perd_cd
609: => ben_cpd_shd.g_old_rec.oth_comp_nnmntry_uom
610: ,p_oth_comp_rndg_cd_o
611: => ben_cpd_shd.g_old_rec.oth_comp_rndg_cd
612: ,p_actual_flag_o
613: => ben_cpd_shd.g_old_rec.actual_flag
614: ,p_acty_ref_perd_cd_o
615: => ben_cpd_shd.g_old_rec.acty_ref_perd_cd
616: ,p_legislation_code_o
617: => ben_cpd_shd.g_old_rec.legislation_code
611: => ben_cpd_shd.g_old_rec.oth_comp_rndg_cd
612: ,p_actual_flag_o
613: => ben_cpd_shd.g_old_rec.actual_flag
614: ,p_acty_ref_perd_cd_o
615: => ben_cpd_shd.g_old_rec.acty_ref_perd_cd
616: ,p_legislation_code_o
617: => ben_cpd_shd.g_old_rec.legislation_code
618: ,p_pl_annulization_factor_o
619: => ben_cpd_shd.g_old_rec.pl_annulization_factor
613: => ben_cpd_shd.g_old_rec.actual_flag
614: ,p_acty_ref_perd_cd_o
615: => ben_cpd_shd.g_old_rec.acty_ref_perd_cd
616: ,p_legislation_code_o
617: => ben_cpd_shd.g_old_rec.legislation_code
618: ,p_pl_annulization_factor_o
619: => ben_cpd_shd.g_old_rec.pl_annulization_factor
620: ,p_pl_stat_cd_o
621: => ben_cpd_shd.g_old_rec.pl_stat_cd
615: => ben_cpd_shd.g_old_rec.acty_ref_perd_cd
616: ,p_legislation_code_o
617: => ben_cpd_shd.g_old_rec.legislation_code
618: ,p_pl_annulization_factor_o
619: => ben_cpd_shd.g_old_rec.pl_annulization_factor
620: ,p_pl_stat_cd_o
621: => ben_cpd_shd.g_old_rec.pl_stat_cd
622: ,p_uom_precision_o
623: => ben_cpd_shd.g_old_rec.uom_precision
617: => ben_cpd_shd.g_old_rec.legislation_code
618: ,p_pl_annulization_factor_o
619: => ben_cpd_shd.g_old_rec.pl_annulization_factor
620: ,p_pl_stat_cd_o
621: => ben_cpd_shd.g_old_rec.pl_stat_cd
622: ,p_uom_precision_o
623: => ben_cpd_shd.g_old_rec.uom_precision
624: ,p_ws_element_type_id_o
625: => ben_cpd_shd.g_old_rec.ws_element_type_id
619: => ben_cpd_shd.g_old_rec.pl_annulization_factor
620: ,p_pl_stat_cd_o
621: => ben_cpd_shd.g_old_rec.pl_stat_cd
622: ,p_uom_precision_o
623: => ben_cpd_shd.g_old_rec.uom_precision
624: ,p_ws_element_type_id_o
625: => ben_cpd_shd.g_old_rec.ws_element_type_id
626: ,p_ws_input_value_id_o
627: => ben_cpd_shd.g_old_rec.ws_input_value_id
621: => ben_cpd_shd.g_old_rec.pl_stat_cd
622: ,p_uom_precision_o
623: => ben_cpd_shd.g_old_rec.uom_precision
624: ,p_ws_element_type_id_o
625: => ben_cpd_shd.g_old_rec.ws_element_type_id
626: ,p_ws_input_value_id_o
627: => ben_cpd_shd.g_old_rec.ws_input_value_id
628: ,p_data_freeze_date_o
629: => ben_cpd_shd.g_old_rec.data_freeze_date
623: => ben_cpd_shd.g_old_rec.uom_precision
624: ,p_ws_element_type_id_o
625: => ben_cpd_shd.g_old_rec.ws_element_type_id
626: ,p_ws_input_value_id_o
627: => ben_cpd_shd.g_old_rec.ws_input_value_id
628: ,p_data_freeze_date_o
629: => ben_cpd_shd.g_old_rec.data_freeze_date
630: ,p_ws_amt_edit_cd_o
631: => ben_cpd_shd.g_old_rec.ws_amt_edit_cd
625: => ben_cpd_shd.g_old_rec.ws_element_type_id
626: ,p_ws_input_value_id_o
627: => ben_cpd_shd.g_old_rec.ws_input_value_id
628: ,p_data_freeze_date_o
629: => ben_cpd_shd.g_old_rec.data_freeze_date
630: ,p_ws_amt_edit_cd_o
631: => ben_cpd_shd.g_old_rec.ws_amt_edit_cd
632: ,p_ws_amt_edit_enf_cd_for_nul_o
633: => ben_cpd_shd.g_old_rec.ws_amt_edit_enf_cd_for_nulls
627: => ben_cpd_shd.g_old_rec.ws_input_value_id
628: ,p_data_freeze_date_o
629: => ben_cpd_shd.g_old_rec.data_freeze_date
630: ,p_ws_amt_edit_cd_o
631: => ben_cpd_shd.g_old_rec.ws_amt_edit_cd
632: ,p_ws_amt_edit_enf_cd_for_nul_o
633: => ben_cpd_shd.g_old_rec.ws_amt_edit_enf_cd_for_nulls
634: ,p_ws_over_budget_edit_cd_o
635: => ben_cpd_shd.g_old_rec.ws_over_budget_edit_cd
629: => ben_cpd_shd.g_old_rec.data_freeze_date
630: ,p_ws_amt_edit_cd_o
631: => ben_cpd_shd.g_old_rec.ws_amt_edit_cd
632: ,p_ws_amt_edit_enf_cd_for_nul_o
633: => ben_cpd_shd.g_old_rec.ws_amt_edit_enf_cd_for_nulls
634: ,p_ws_over_budget_edit_cd_o
635: => ben_cpd_shd.g_old_rec.ws_over_budget_edit_cd
636: ,p_ws_over_budget_tol_pct_o
637: => ben_cpd_shd.g_old_rec.ws_over_budget_tolerance_pct
631: => ben_cpd_shd.g_old_rec.ws_amt_edit_cd
632: ,p_ws_amt_edit_enf_cd_for_nul_o
633: => ben_cpd_shd.g_old_rec.ws_amt_edit_enf_cd_for_nulls
634: ,p_ws_over_budget_edit_cd_o
635: => ben_cpd_shd.g_old_rec.ws_over_budget_edit_cd
636: ,p_ws_over_budget_tol_pct_o
637: => ben_cpd_shd.g_old_rec.ws_over_budget_tolerance_pct
638: ,p_bdgt_over_budget_edit_cd_o
639: => ben_cpd_shd.g_old_rec.bdgt_over_budget_edit_cd
633: => ben_cpd_shd.g_old_rec.ws_amt_edit_enf_cd_for_nulls
634: ,p_ws_over_budget_edit_cd_o
635: => ben_cpd_shd.g_old_rec.ws_over_budget_edit_cd
636: ,p_ws_over_budget_tol_pct_o
637: => ben_cpd_shd.g_old_rec.ws_over_budget_tolerance_pct
638: ,p_bdgt_over_budget_edit_cd_o
639: => ben_cpd_shd.g_old_rec.bdgt_over_budget_edit_cd
640: ,p_bdgt_over_budget_tol_pct_o
641: => ben_cpd_shd.g_old_rec.bdgt_over_budget_tolerance_pct
635: => ben_cpd_shd.g_old_rec.ws_over_budget_edit_cd
636: ,p_ws_over_budget_tol_pct_o
637: => ben_cpd_shd.g_old_rec.ws_over_budget_tolerance_pct
638: ,p_bdgt_over_budget_edit_cd_o
639: => ben_cpd_shd.g_old_rec.bdgt_over_budget_edit_cd
640: ,p_bdgt_over_budget_tol_pct_o
641: => ben_cpd_shd.g_old_rec.bdgt_over_budget_tolerance_pct
642: ,p_auto_distr_flag_o
643: => ben_cpd_shd.g_old_rec.auto_distr_flag
637: => ben_cpd_shd.g_old_rec.ws_over_budget_tolerance_pct
638: ,p_bdgt_over_budget_edit_cd_o
639: => ben_cpd_shd.g_old_rec.bdgt_over_budget_edit_cd
640: ,p_bdgt_over_budget_tol_pct_o
641: => ben_cpd_shd.g_old_rec.bdgt_over_budget_tolerance_pct
642: ,p_auto_distr_flag_o
643: => ben_cpd_shd.g_old_rec.auto_distr_flag
644: ,p_pqh_document_short_name_o
645: => ben_cpd_shd.g_old_rec.pqh_document_short_name
639: => ben_cpd_shd.g_old_rec.bdgt_over_budget_edit_cd
640: ,p_bdgt_over_budget_tol_pct_o
641: => ben_cpd_shd.g_old_rec.bdgt_over_budget_tolerance_pct
642: ,p_auto_distr_flag_o
643: => ben_cpd_shd.g_old_rec.auto_distr_flag
644: ,p_pqh_document_short_name_o
645: => ben_cpd_shd.g_old_rec.pqh_document_short_name
646: ,p_ovrid_rt_strt_dt_o
647: => ben_cpd_shd.g_old_rec.ovrid_rt_strt_dt
641: => ben_cpd_shd.g_old_rec.bdgt_over_budget_tolerance_pct
642: ,p_auto_distr_flag_o
643: => ben_cpd_shd.g_old_rec.auto_distr_flag
644: ,p_pqh_document_short_name_o
645: => ben_cpd_shd.g_old_rec.pqh_document_short_name
646: ,p_ovrid_rt_strt_dt_o
647: => ben_cpd_shd.g_old_rec.ovrid_rt_strt_dt
648: ,p_do_not_process_flag_o
649: => ben_cpd_shd.g_old_rec.do_not_process_flag
643: => ben_cpd_shd.g_old_rec.auto_distr_flag
644: ,p_pqh_document_short_name_o
645: => ben_cpd_shd.g_old_rec.pqh_document_short_name
646: ,p_ovrid_rt_strt_dt_o
647: => ben_cpd_shd.g_old_rec.ovrid_rt_strt_dt
648: ,p_do_not_process_flag_o
649: => ben_cpd_shd.g_old_rec.do_not_process_flag
650: ,p_ovr_perf_revw_strt_dt_o
651: => ben_cpd_shd.g_old_rec.ovr_perf_revw_strt_dt
645: => ben_cpd_shd.g_old_rec.pqh_document_short_name
646: ,p_ovrid_rt_strt_dt_o
647: => ben_cpd_shd.g_old_rec.ovrid_rt_strt_dt
648: ,p_do_not_process_flag_o
649: => ben_cpd_shd.g_old_rec.do_not_process_flag
650: ,p_ovr_perf_revw_strt_dt_o
651: => ben_cpd_shd.g_old_rec.ovr_perf_revw_strt_dt
652: ,p_post_zero_salary_increase_o
653: => ben_cpd_shd.g_old_rec.post_zero_salary_increase
647: => ben_cpd_shd.g_old_rec.ovrid_rt_strt_dt
648: ,p_do_not_process_flag_o
649: => ben_cpd_shd.g_old_rec.do_not_process_flag
650: ,p_ovr_perf_revw_strt_dt_o
651: => ben_cpd_shd.g_old_rec.ovr_perf_revw_strt_dt
652: ,p_post_zero_salary_increase_o
653: => ben_cpd_shd.g_old_rec.post_zero_salary_increase
654: ,p_show_appraisals_n_days_o
655: => ben_cpd_shd.g_old_rec.show_appraisals_n_days
649: => ben_cpd_shd.g_old_rec.do_not_process_flag
650: ,p_ovr_perf_revw_strt_dt_o
651: => ben_cpd_shd.g_old_rec.ovr_perf_revw_strt_dt
652: ,p_post_zero_salary_increase_o
653: => ben_cpd_shd.g_old_rec.post_zero_salary_increase
654: ,p_show_appraisals_n_days_o
655: => ben_cpd_shd.g_old_rec.show_appraisals_n_days
656: ,p_grade_range_validation_o
657: => ben_cpd_shd.g_old_rec.grade_range_validation
651: => ben_cpd_shd.g_old_rec.ovr_perf_revw_strt_dt
652: ,p_post_zero_salary_increase_o
653: => ben_cpd_shd.g_old_rec.post_zero_salary_increase
654: ,p_show_appraisals_n_days_o
655: => ben_cpd_shd.g_old_rec.show_appraisals_n_days
656: ,p_grade_range_validation_o
657: => ben_cpd_shd.g_old_rec.grade_range_validation
658: ,p_object_version_number_o
659: => ben_cpd_shd.g_old_rec.object_version_number
653: => ben_cpd_shd.g_old_rec.post_zero_salary_increase
654: ,p_show_appraisals_n_days_o
655: => ben_cpd_shd.g_old_rec.show_appraisals_n_days
656: ,p_grade_range_validation_o
657: => ben_cpd_shd.g_old_rec.grade_range_validation
658: ,p_object_version_number_o
659: => ben_cpd_shd.g_old_rec.object_version_number
660: ,p_email_password_protected_o
661: => ben_cpd_shd.g_old_rec.email_password_protected
655: => ben_cpd_shd.g_old_rec.show_appraisals_n_days
656: ,p_grade_range_validation_o
657: => ben_cpd_shd.g_old_rec.grade_range_validation
658: ,p_object_version_number_o
659: => ben_cpd_shd.g_old_rec.object_version_number
660: ,p_email_password_protected_o
661: => ben_cpd_shd.g_old_rec.email_password_protected
662: ,p_email_cc_manager_o
663: => ben_cpd_shd.g_old_rec.email_cc_manager
657: => ben_cpd_shd.g_old_rec.grade_range_validation
658: ,p_object_version_number_o
659: => ben_cpd_shd.g_old_rec.object_version_number
660: ,p_email_password_protected_o
661: => ben_cpd_shd.g_old_rec.email_password_protected
662: ,p_email_cc_manager_o
663: => ben_cpd_shd.g_old_rec.email_cc_manager
664: ,p_email_subject_o
665: => ben_cpd_shd.g_old_rec.email_subject
659: => ben_cpd_shd.g_old_rec.object_version_number
660: ,p_email_password_protected_o
661: => ben_cpd_shd.g_old_rec.email_password_protected
662: ,p_email_cc_manager_o
663: => ben_cpd_shd.g_old_rec.email_cc_manager
664: ,p_email_subject_o
665: => ben_cpd_shd.g_old_rec.email_subject
666: ,p_email_sample_address_o
667: => ben_cpd_shd.g_old_rec.email_sample_address
661: => ben_cpd_shd.g_old_rec.email_password_protected
662: ,p_email_cc_manager_o
663: => ben_cpd_shd.g_old_rec.email_cc_manager
664: ,p_email_subject_o
665: => ben_cpd_shd.g_old_rec.email_subject
666: ,p_email_sample_address_o
667: => ben_cpd_shd.g_old_rec.email_sample_address
668: );
669: --
663: => ben_cpd_shd.g_old_rec.email_cc_manager
664: ,p_email_subject_o
665: => ben_cpd_shd.g_old_rec.email_subject
666: ,p_email_sample_address_o
667: => ben_cpd_shd.g_old_rec.email_sample_address
668: );
669: --
670: exception
671: --
723: --
724: -- {End Of Comments}
725: -- ----------------------------------------------------------------------------
726: Procedure convert_defs
727: (p_rec in out nocopy ben_cpd_shd.g_rec_type
728: ) is
729: --
730: Begin
731: --
735: -- is being used then we must set to the 'current' argument value.
736: --
737: If (p_rec.effective_date = hr_api.g_date) then
738: p_rec.effective_date :=
739: ben_cpd_shd.g_old_rec.effective_date;
740: End If;
741: If (p_rec.name = hr_api.g_varchar2) then
742: p_rec.name :=
743: ben_cpd_shd.g_old_rec.name;
739: ben_cpd_shd.g_old_rec.effective_date;
740: End If;
741: If (p_rec.name = hr_api.g_varchar2) then
742: p_rec.name :=
743: ben_cpd_shd.g_old_rec.name;
744: End If;
745: If (p_rec.group_pl_id = hr_api.g_number) then
746: p_rec.group_pl_id :=
747: ben_cpd_shd.g_old_rec.group_pl_id;
743: ben_cpd_shd.g_old_rec.name;
744: End If;
745: If (p_rec.group_pl_id = hr_api.g_number) then
746: p_rec.group_pl_id :=
747: ben_cpd_shd.g_old_rec.group_pl_id;
748: End If;
749: If (p_rec.group_oipl_id = hr_api.g_number) then
750: p_rec.group_oipl_id :=
751: ben_cpd_shd.g_old_rec.group_oipl_id;
747: ben_cpd_shd.g_old_rec.group_pl_id;
748: End If;
749: If (p_rec.group_oipl_id = hr_api.g_number) then
750: p_rec.group_oipl_id :=
751: ben_cpd_shd.g_old_rec.group_oipl_id;
752: End If;
753: If (p_rec.opt_hidden_flag = hr_api.g_varchar2) then
754: p_rec.opt_hidden_flag :=
755: ben_cpd_shd.g_old_rec.opt_hidden_flag;
751: ben_cpd_shd.g_old_rec.group_oipl_id;
752: End If;
753: If (p_rec.opt_hidden_flag = hr_api.g_varchar2) then
754: p_rec.opt_hidden_flag :=
755: ben_cpd_shd.g_old_rec.opt_hidden_flag;
756: End If;
757: If (p_rec.opt_id = hr_api.g_number) then
758: p_rec.opt_id :=
759: ben_cpd_shd.g_old_rec.opt_id;
755: ben_cpd_shd.g_old_rec.opt_hidden_flag;
756: End If;
757: If (p_rec.opt_id = hr_api.g_number) then
758: p_rec.opt_id :=
759: ben_cpd_shd.g_old_rec.opt_id;
760: End If;
761: If (p_rec.pl_uom = hr_api.g_varchar2) then
762: p_rec.pl_uom :=
763: ben_cpd_shd.g_old_rec.pl_uom;
759: ben_cpd_shd.g_old_rec.opt_id;
760: End If;
761: If (p_rec.pl_uom = hr_api.g_varchar2) then
762: p_rec.pl_uom :=
763: ben_cpd_shd.g_old_rec.pl_uom;
764: End If;
765: If (p_rec.pl_ordr_num = hr_api.g_number) then
766: p_rec.pl_ordr_num :=
767: ben_cpd_shd.g_old_rec.pl_ordr_num;
763: ben_cpd_shd.g_old_rec.pl_uom;
764: End If;
765: If (p_rec.pl_ordr_num = hr_api.g_number) then
766: p_rec.pl_ordr_num :=
767: ben_cpd_shd.g_old_rec.pl_ordr_num;
768: End If;
769: If (p_rec.oipl_ordr_num = hr_api.g_number) then
770: p_rec.oipl_ordr_num :=
771: ben_cpd_shd.g_old_rec.oipl_ordr_num;
767: ben_cpd_shd.g_old_rec.pl_ordr_num;
768: End If;
769: If (p_rec.oipl_ordr_num = hr_api.g_number) then
770: p_rec.oipl_ordr_num :=
771: ben_cpd_shd.g_old_rec.oipl_ordr_num;
772: End If;
773: If (p_rec.pl_xchg_rate = hr_api.g_number) then
774: p_rec.pl_xchg_rate :=
775: ben_cpd_shd.g_old_rec.pl_xchg_rate;
771: ben_cpd_shd.g_old_rec.oipl_ordr_num;
772: End If;
773: If (p_rec.pl_xchg_rate = hr_api.g_number) then
774: p_rec.pl_xchg_rate :=
775: ben_cpd_shd.g_old_rec.pl_xchg_rate;
776: End If;
777: If (p_rec.opt_count = hr_api.g_number) then
778: p_rec.opt_count :=
779: ben_cpd_shd.g_old_rec.opt_count;
775: ben_cpd_shd.g_old_rec.pl_xchg_rate;
776: End If;
777: If (p_rec.opt_count = hr_api.g_number) then
778: p_rec.opt_count :=
779: ben_cpd_shd.g_old_rec.opt_count;
780: End If;
781: If (p_rec.uses_bdgt_flag = hr_api.g_varchar2) then
782: p_rec.uses_bdgt_flag :=
783: ben_cpd_shd.g_old_rec.uses_bdgt_flag;
779: ben_cpd_shd.g_old_rec.opt_count;
780: End If;
781: If (p_rec.uses_bdgt_flag = hr_api.g_varchar2) then
782: p_rec.uses_bdgt_flag :=
783: ben_cpd_shd.g_old_rec.uses_bdgt_flag;
784: End If;
785: If (p_rec.prsrv_bdgt_cd = hr_api.g_varchar2) then
786: p_rec.prsrv_bdgt_cd :=
787: ben_cpd_shd.g_old_rec.prsrv_bdgt_cd;
783: ben_cpd_shd.g_old_rec.uses_bdgt_flag;
784: End If;
785: If (p_rec.prsrv_bdgt_cd = hr_api.g_varchar2) then
786: p_rec.prsrv_bdgt_cd :=
787: ben_cpd_shd.g_old_rec.prsrv_bdgt_cd;
788: End If;
789: If (p_rec.upd_start_dt = hr_api.g_date) then
790: p_rec.upd_start_dt :=
791: ben_cpd_shd.g_old_rec.upd_start_dt;
787: ben_cpd_shd.g_old_rec.prsrv_bdgt_cd;
788: End If;
789: If (p_rec.upd_start_dt = hr_api.g_date) then
790: p_rec.upd_start_dt :=
791: ben_cpd_shd.g_old_rec.upd_start_dt;
792: End If;
793: If (p_rec.upd_end_dt = hr_api.g_date) then
794: p_rec.upd_end_dt :=
795: ben_cpd_shd.g_old_rec.upd_end_dt;
791: ben_cpd_shd.g_old_rec.upd_start_dt;
792: End If;
793: If (p_rec.upd_end_dt = hr_api.g_date) then
794: p_rec.upd_end_dt :=
795: ben_cpd_shd.g_old_rec.upd_end_dt;
796: End If;
797: If (p_rec.approval_mode = hr_api.g_varchar2) then
798: p_rec.approval_mode :=
799: ben_cpd_shd.g_old_rec.approval_mode;
795: ben_cpd_shd.g_old_rec.upd_end_dt;
796: End If;
797: If (p_rec.approval_mode = hr_api.g_varchar2) then
798: p_rec.approval_mode :=
799: ben_cpd_shd.g_old_rec.approval_mode;
800: End If;
801: If (p_rec.enrt_perd_start_dt = hr_api.g_date) then
802: p_rec.enrt_perd_start_dt :=
803: ben_cpd_shd.g_old_rec.enrt_perd_start_dt;
799: ben_cpd_shd.g_old_rec.approval_mode;
800: End If;
801: If (p_rec.enrt_perd_start_dt = hr_api.g_date) then
802: p_rec.enrt_perd_start_dt :=
803: ben_cpd_shd.g_old_rec.enrt_perd_start_dt;
804: End If;
805: If (p_rec.enrt_perd_end_dt = hr_api.g_date) then
806: p_rec.enrt_perd_end_dt :=
807: ben_cpd_shd.g_old_rec.enrt_perd_end_dt;
803: ben_cpd_shd.g_old_rec.enrt_perd_start_dt;
804: End If;
805: If (p_rec.enrt_perd_end_dt = hr_api.g_date) then
806: p_rec.enrt_perd_end_dt :=
807: ben_cpd_shd.g_old_rec.enrt_perd_end_dt;
808: End If;
809: If (p_rec.yr_perd_start_dt = hr_api.g_date) then
810: p_rec.yr_perd_start_dt :=
811: ben_cpd_shd.g_old_rec.yr_perd_start_dt;
807: ben_cpd_shd.g_old_rec.enrt_perd_end_dt;
808: End If;
809: If (p_rec.yr_perd_start_dt = hr_api.g_date) then
810: p_rec.yr_perd_start_dt :=
811: ben_cpd_shd.g_old_rec.yr_perd_start_dt;
812: End If;
813: If (p_rec.yr_perd_end_dt = hr_api.g_date) then
814: p_rec.yr_perd_end_dt :=
815: ben_cpd_shd.g_old_rec.yr_perd_end_dt;
811: ben_cpd_shd.g_old_rec.yr_perd_start_dt;
812: End If;
813: If (p_rec.yr_perd_end_dt = hr_api.g_date) then
814: p_rec.yr_perd_end_dt :=
815: ben_cpd_shd.g_old_rec.yr_perd_end_dt;
816: End If;
817: If (p_rec.wthn_yr_start_dt = hr_api.g_date) then
818: p_rec.wthn_yr_start_dt :=
819: ben_cpd_shd.g_old_rec.wthn_yr_start_dt;
815: ben_cpd_shd.g_old_rec.yr_perd_end_dt;
816: End If;
817: If (p_rec.wthn_yr_start_dt = hr_api.g_date) then
818: p_rec.wthn_yr_start_dt :=
819: ben_cpd_shd.g_old_rec.wthn_yr_start_dt;
820: End If;
821: If (p_rec.wthn_yr_end_dt = hr_api.g_date) then
822: p_rec.wthn_yr_end_dt :=
823: ben_cpd_shd.g_old_rec.wthn_yr_end_dt;
819: ben_cpd_shd.g_old_rec.wthn_yr_start_dt;
820: End If;
821: If (p_rec.wthn_yr_end_dt = hr_api.g_date) then
822: p_rec.wthn_yr_end_dt :=
823: ben_cpd_shd.g_old_rec.wthn_yr_end_dt;
824: End If;
825: If (p_rec.enrt_perd_id = hr_api.g_number) then
826: p_rec.enrt_perd_id :=
827: ben_cpd_shd.g_old_rec.enrt_perd_id;
823: ben_cpd_shd.g_old_rec.wthn_yr_end_dt;
824: End If;
825: If (p_rec.enrt_perd_id = hr_api.g_number) then
826: p_rec.enrt_perd_id :=
827: ben_cpd_shd.g_old_rec.enrt_perd_id;
828: End If;
829: If (p_rec.yr_perd_id = hr_api.g_number) then
830: p_rec.yr_perd_id :=
831: ben_cpd_shd.g_old_rec.yr_perd_id;
827: ben_cpd_shd.g_old_rec.enrt_perd_id;
828: End If;
829: If (p_rec.yr_perd_id = hr_api.g_number) then
830: p_rec.yr_perd_id :=
831: ben_cpd_shd.g_old_rec.yr_perd_id;
832: End If;
833: If (p_rec.business_group_id = hr_api.g_number) then
834: p_rec.business_group_id :=
835: ben_cpd_shd.g_old_rec.business_group_id;
831: ben_cpd_shd.g_old_rec.yr_perd_id;
832: End If;
833: If (p_rec.business_group_id = hr_api.g_number) then
834: p_rec.business_group_id :=
835: ben_cpd_shd.g_old_rec.business_group_id;
836: End If;
837: If (p_rec.perf_revw_strt_dt = hr_api.g_date) then
838: p_rec.perf_revw_strt_dt :=
839: ben_cpd_shd.g_old_rec.perf_revw_strt_dt;
835: ben_cpd_shd.g_old_rec.business_group_id;
836: End If;
837: If (p_rec.perf_revw_strt_dt = hr_api.g_date) then
838: p_rec.perf_revw_strt_dt :=
839: ben_cpd_shd.g_old_rec.perf_revw_strt_dt;
840: End If;
841: If (p_rec.asg_updt_eff_date = hr_api.g_date) then
842: p_rec.asg_updt_eff_date :=
843: ben_cpd_shd.g_old_rec.asg_updt_eff_date;
839: ben_cpd_shd.g_old_rec.perf_revw_strt_dt;
840: End If;
841: If (p_rec.asg_updt_eff_date = hr_api.g_date) then
842: p_rec.asg_updt_eff_date :=
843: ben_cpd_shd.g_old_rec.asg_updt_eff_date;
844: End If;
845: If (p_rec.emp_interview_typ_cd = hr_api.g_varchar2) then
846: p_rec.emp_interview_typ_cd :=
847: ben_cpd_shd.g_old_rec.emp_interview_typ_cd;
843: ben_cpd_shd.g_old_rec.asg_updt_eff_date;
844: End If;
845: If (p_rec.emp_interview_typ_cd = hr_api.g_varchar2) then
846: p_rec.emp_interview_typ_cd :=
847: ben_cpd_shd.g_old_rec.emp_interview_typ_cd;
848: End If;
849: If (p_rec.salary_change_reason = hr_api.g_varchar2) then
850: p_rec.salary_change_reason :=
851: ben_cpd_shd.g_old_rec.salary_change_reason;
847: ben_cpd_shd.g_old_rec.emp_interview_typ_cd;
848: End If;
849: If (p_rec.salary_change_reason = hr_api.g_varchar2) then
850: p_rec.salary_change_reason :=
851: ben_cpd_shd.g_old_rec.salary_change_reason;
852: End If;
853: If (p_rec.ws_abr_id = hr_api.g_number) then
854: p_rec.ws_abr_id :=
855: ben_cpd_shd.g_old_rec.ws_abr_id;
851: ben_cpd_shd.g_old_rec.salary_change_reason;
852: End If;
853: If (p_rec.ws_abr_id = hr_api.g_number) then
854: p_rec.ws_abr_id :=
855: ben_cpd_shd.g_old_rec.ws_abr_id;
856: End If;
857: If (p_rec.ws_nnmntry_uom = hr_api.g_varchar2) then
858: p_rec.ws_nnmntry_uom :=
859: ben_cpd_shd.g_old_rec.ws_nnmntry_uom;
855: ben_cpd_shd.g_old_rec.ws_abr_id;
856: End If;
857: If (p_rec.ws_nnmntry_uom = hr_api.g_varchar2) then
858: p_rec.ws_nnmntry_uom :=
859: ben_cpd_shd.g_old_rec.ws_nnmntry_uom;
860: End If;
861: If (p_rec.ws_rndg_cd = hr_api.g_varchar2) then
862: p_rec.ws_rndg_cd :=
863: ben_cpd_shd.g_old_rec.ws_rndg_cd;
859: ben_cpd_shd.g_old_rec.ws_nnmntry_uom;
860: End If;
861: If (p_rec.ws_rndg_cd = hr_api.g_varchar2) then
862: p_rec.ws_rndg_cd :=
863: ben_cpd_shd.g_old_rec.ws_rndg_cd;
864: End If;
865: If (p_rec.ws_sub_acty_typ_cd = hr_api.g_varchar2) then
866: p_rec.ws_sub_acty_typ_cd :=
867: ben_cpd_shd.g_old_rec.ws_sub_acty_typ_cd;
863: ben_cpd_shd.g_old_rec.ws_rndg_cd;
864: End If;
865: If (p_rec.ws_sub_acty_typ_cd = hr_api.g_varchar2) then
866: p_rec.ws_sub_acty_typ_cd :=
867: ben_cpd_shd.g_old_rec.ws_sub_acty_typ_cd;
868: End If;
869: If (p_rec.dist_bdgt_abr_id = hr_api.g_number) then
870: p_rec.dist_bdgt_abr_id :=
871: ben_cpd_shd.g_old_rec.dist_bdgt_abr_id;
867: ben_cpd_shd.g_old_rec.ws_sub_acty_typ_cd;
868: End If;
869: If (p_rec.dist_bdgt_abr_id = hr_api.g_number) then
870: p_rec.dist_bdgt_abr_id :=
871: ben_cpd_shd.g_old_rec.dist_bdgt_abr_id;
872: End If;
873: If (p_rec.dist_bdgt_nnmntry_uom = hr_api.g_varchar2) then
874: p_rec.dist_bdgt_nnmntry_uom :=
875: ben_cpd_shd.g_old_rec.dist_bdgt_nnmntry_uom;
871: ben_cpd_shd.g_old_rec.dist_bdgt_abr_id;
872: End If;
873: If (p_rec.dist_bdgt_nnmntry_uom = hr_api.g_varchar2) then
874: p_rec.dist_bdgt_nnmntry_uom :=
875: ben_cpd_shd.g_old_rec.dist_bdgt_nnmntry_uom;
876: End If;
877: If (p_rec.dist_bdgt_rndg_cd = hr_api.g_varchar2) then
878: p_rec.dist_bdgt_rndg_cd :=
879: ben_cpd_shd.g_old_rec.dist_bdgt_rndg_cd;
875: ben_cpd_shd.g_old_rec.dist_bdgt_nnmntry_uom;
876: End If;
877: If (p_rec.dist_bdgt_rndg_cd = hr_api.g_varchar2) then
878: p_rec.dist_bdgt_rndg_cd :=
879: ben_cpd_shd.g_old_rec.dist_bdgt_rndg_cd;
880: End If;
881: If (p_rec.ws_bdgt_abr_id = hr_api.g_number) then
882: p_rec.ws_bdgt_abr_id :=
883: ben_cpd_shd.g_old_rec.ws_bdgt_abr_id;
879: ben_cpd_shd.g_old_rec.dist_bdgt_rndg_cd;
880: End If;
881: If (p_rec.ws_bdgt_abr_id = hr_api.g_number) then
882: p_rec.ws_bdgt_abr_id :=
883: ben_cpd_shd.g_old_rec.ws_bdgt_abr_id;
884: End If;
885: If (p_rec.ws_bdgt_nnmntry_uom = hr_api.g_varchar2) then
886: p_rec.ws_bdgt_nnmntry_uom :=
887: ben_cpd_shd.g_old_rec.ws_bdgt_nnmntry_uom;
883: ben_cpd_shd.g_old_rec.ws_bdgt_abr_id;
884: End If;
885: If (p_rec.ws_bdgt_nnmntry_uom = hr_api.g_varchar2) then
886: p_rec.ws_bdgt_nnmntry_uom :=
887: ben_cpd_shd.g_old_rec.ws_bdgt_nnmntry_uom;
888: End If;
889: If (p_rec.ws_bdgt_rndg_cd = hr_api.g_varchar2) then
890: p_rec.ws_bdgt_rndg_cd :=
891: ben_cpd_shd.g_old_rec.ws_bdgt_rndg_cd;
887: ben_cpd_shd.g_old_rec.ws_bdgt_nnmntry_uom;
888: End If;
889: If (p_rec.ws_bdgt_rndg_cd = hr_api.g_varchar2) then
890: p_rec.ws_bdgt_rndg_cd :=
891: ben_cpd_shd.g_old_rec.ws_bdgt_rndg_cd;
892: End If;
893: If (p_rec.rsrv_abr_id = hr_api.g_number) then
894: p_rec.rsrv_abr_id :=
895: ben_cpd_shd.g_old_rec.rsrv_abr_id;
891: ben_cpd_shd.g_old_rec.ws_bdgt_rndg_cd;
892: End If;
893: If (p_rec.rsrv_abr_id = hr_api.g_number) then
894: p_rec.rsrv_abr_id :=
895: ben_cpd_shd.g_old_rec.rsrv_abr_id;
896: End If;
897: If (p_rec.rsrv_nnmntry_uom = hr_api.g_varchar2) then
898: p_rec.rsrv_nnmntry_uom :=
899: ben_cpd_shd.g_old_rec.rsrv_nnmntry_uom;
895: ben_cpd_shd.g_old_rec.rsrv_abr_id;
896: End If;
897: If (p_rec.rsrv_nnmntry_uom = hr_api.g_varchar2) then
898: p_rec.rsrv_nnmntry_uom :=
899: ben_cpd_shd.g_old_rec.rsrv_nnmntry_uom;
900: End If;
901: If (p_rec.rsrv_rndg_cd = hr_api.g_varchar2) then
902: p_rec.rsrv_rndg_cd :=
903: ben_cpd_shd.g_old_rec.rsrv_rndg_cd;
899: ben_cpd_shd.g_old_rec.rsrv_nnmntry_uom;
900: End If;
901: If (p_rec.rsrv_rndg_cd = hr_api.g_varchar2) then
902: p_rec.rsrv_rndg_cd :=
903: ben_cpd_shd.g_old_rec.rsrv_rndg_cd;
904: End If;
905: If (p_rec.elig_sal_abr_id = hr_api.g_number) then
906: p_rec.elig_sal_abr_id :=
907: ben_cpd_shd.g_old_rec.elig_sal_abr_id;
903: ben_cpd_shd.g_old_rec.rsrv_rndg_cd;
904: End If;
905: If (p_rec.elig_sal_abr_id = hr_api.g_number) then
906: p_rec.elig_sal_abr_id :=
907: ben_cpd_shd.g_old_rec.elig_sal_abr_id;
908: End If;
909: If (p_rec.elig_sal_nnmntry_uom = hr_api.g_varchar2) then
910: p_rec.elig_sal_nnmntry_uom :=
911: ben_cpd_shd.g_old_rec.elig_sal_nnmntry_uom;
907: ben_cpd_shd.g_old_rec.elig_sal_abr_id;
908: End If;
909: If (p_rec.elig_sal_nnmntry_uom = hr_api.g_varchar2) then
910: p_rec.elig_sal_nnmntry_uom :=
911: ben_cpd_shd.g_old_rec.elig_sal_nnmntry_uom;
912: End If;
913: If (p_rec.elig_sal_rndg_cd = hr_api.g_varchar2) then
914: p_rec.elig_sal_rndg_cd :=
915: ben_cpd_shd.g_old_rec.elig_sal_rndg_cd;
911: ben_cpd_shd.g_old_rec.elig_sal_nnmntry_uom;
912: End If;
913: If (p_rec.elig_sal_rndg_cd = hr_api.g_varchar2) then
914: p_rec.elig_sal_rndg_cd :=
915: ben_cpd_shd.g_old_rec.elig_sal_rndg_cd;
916: End If;
917: If (p_rec.misc1_abr_id = hr_api.g_number) then
918: p_rec.misc1_abr_id :=
919: ben_cpd_shd.g_old_rec.misc1_abr_id;
915: ben_cpd_shd.g_old_rec.elig_sal_rndg_cd;
916: End If;
917: If (p_rec.misc1_abr_id = hr_api.g_number) then
918: p_rec.misc1_abr_id :=
919: ben_cpd_shd.g_old_rec.misc1_abr_id;
920: End If;
921: If (p_rec.misc1_nnmntry_uom = hr_api.g_varchar2) then
922: p_rec.misc1_nnmntry_uom :=
923: ben_cpd_shd.g_old_rec.misc1_nnmntry_uom;
919: ben_cpd_shd.g_old_rec.misc1_abr_id;
920: End If;
921: If (p_rec.misc1_nnmntry_uom = hr_api.g_varchar2) then
922: p_rec.misc1_nnmntry_uom :=
923: ben_cpd_shd.g_old_rec.misc1_nnmntry_uom;
924: End If;
925: If (p_rec.misc1_rndg_cd = hr_api.g_varchar2) then
926: p_rec.misc1_rndg_cd :=
927: ben_cpd_shd.g_old_rec.misc1_rndg_cd;
923: ben_cpd_shd.g_old_rec.misc1_nnmntry_uom;
924: End If;
925: If (p_rec.misc1_rndg_cd = hr_api.g_varchar2) then
926: p_rec.misc1_rndg_cd :=
927: ben_cpd_shd.g_old_rec.misc1_rndg_cd;
928: End If;
929: If (p_rec.misc2_abr_id = hr_api.g_number) then
930: p_rec.misc2_abr_id :=
931: ben_cpd_shd.g_old_rec.misc2_abr_id;
927: ben_cpd_shd.g_old_rec.misc1_rndg_cd;
928: End If;
929: If (p_rec.misc2_abr_id = hr_api.g_number) then
930: p_rec.misc2_abr_id :=
931: ben_cpd_shd.g_old_rec.misc2_abr_id;
932: End If;
933: If (p_rec.misc2_nnmntry_uom = hr_api.g_varchar2) then
934: p_rec.misc2_nnmntry_uom :=
935: ben_cpd_shd.g_old_rec.misc2_nnmntry_uom;
931: ben_cpd_shd.g_old_rec.misc2_abr_id;
932: End If;
933: If (p_rec.misc2_nnmntry_uom = hr_api.g_varchar2) then
934: p_rec.misc2_nnmntry_uom :=
935: ben_cpd_shd.g_old_rec.misc2_nnmntry_uom;
936: End If;
937: If (p_rec.misc2_rndg_cd = hr_api.g_varchar2) then
938: p_rec.misc2_rndg_cd :=
939: ben_cpd_shd.g_old_rec.misc2_rndg_cd;
935: ben_cpd_shd.g_old_rec.misc2_nnmntry_uom;
936: End If;
937: If (p_rec.misc2_rndg_cd = hr_api.g_varchar2) then
938: p_rec.misc2_rndg_cd :=
939: ben_cpd_shd.g_old_rec.misc2_rndg_cd;
940: End If;
941: If (p_rec.misc3_abr_id = hr_api.g_number) then
942: p_rec.misc3_abr_id :=
943: ben_cpd_shd.g_old_rec.misc3_abr_id;
939: ben_cpd_shd.g_old_rec.misc2_rndg_cd;
940: End If;
941: If (p_rec.misc3_abr_id = hr_api.g_number) then
942: p_rec.misc3_abr_id :=
943: ben_cpd_shd.g_old_rec.misc3_abr_id;
944: End If;
945: If (p_rec.misc3_nnmntry_uom = hr_api.g_varchar2) then
946: p_rec.misc3_nnmntry_uom :=
947: ben_cpd_shd.g_old_rec.misc3_nnmntry_uom;
943: ben_cpd_shd.g_old_rec.misc3_abr_id;
944: End If;
945: If (p_rec.misc3_nnmntry_uom = hr_api.g_varchar2) then
946: p_rec.misc3_nnmntry_uom :=
947: ben_cpd_shd.g_old_rec.misc3_nnmntry_uom;
948: End If;
949: If (p_rec.misc3_rndg_cd = hr_api.g_varchar2) then
950: p_rec.misc3_rndg_cd :=
951: ben_cpd_shd.g_old_rec.misc3_rndg_cd;
947: ben_cpd_shd.g_old_rec.misc3_nnmntry_uom;
948: End If;
949: If (p_rec.misc3_rndg_cd = hr_api.g_varchar2) then
950: p_rec.misc3_rndg_cd :=
951: ben_cpd_shd.g_old_rec.misc3_rndg_cd;
952: End If;
953: If (p_rec.stat_sal_abr_id = hr_api.g_number) then
954: p_rec.stat_sal_abr_id :=
955: ben_cpd_shd.g_old_rec.stat_sal_abr_id;
951: ben_cpd_shd.g_old_rec.misc3_rndg_cd;
952: End If;
953: If (p_rec.stat_sal_abr_id = hr_api.g_number) then
954: p_rec.stat_sal_abr_id :=
955: ben_cpd_shd.g_old_rec.stat_sal_abr_id;
956: End If;
957: If (p_rec.stat_sal_nnmntry_uom = hr_api.g_varchar2) then
958: p_rec.stat_sal_nnmntry_uom :=
959: ben_cpd_shd.g_old_rec.stat_sal_nnmntry_uom;
955: ben_cpd_shd.g_old_rec.stat_sal_abr_id;
956: End If;
957: If (p_rec.stat_sal_nnmntry_uom = hr_api.g_varchar2) then
958: p_rec.stat_sal_nnmntry_uom :=
959: ben_cpd_shd.g_old_rec.stat_sal_nnmntry_uom;
960: End If;
961: If (p_rec.stat_sal_rndg_cd = hr_api.g_varchar2) then
962: p_rec.stat_sal_rndg_cd :=
963: ben_cpd_shd.g_old_rec.stat_sal_rndg_cd;
959: ben_cpd_shd.g_old_rec.stat_sal_nnmntry_uom;
960: End If;
961: If (p_rec.stat_sal_rndg_cd = hr_api.g_varchar2) then
962: p_rec.stat_sal_rndg_cd :=
963: ben_cpd_shd.g_old_rec.stat_sal_rndg_cd;
964: End If;
965: If (p_rec.rec_abr_id = hr_api.g_number) then
966: p_rec.rec_abr_id :=
967: ben_cpd_shd.g_old_rec.rec_abr_id;
963: ben_cpd_shd.g_old_rec.stat_sal_rndg_cd;
964: End If;
965: If (p_rec.rec_abr_id = hr_api.g_number) then
966: p_rec.rec_abr_id :=
967: ben_cpd_shd.g_old_rec.rec_abr_id;
968: End If;
969: If (p_rec.rec_nnmntry_uom = hr_api.g_varchar2) then
970: p_rec.rec_nnmntry_uom :=
971: ben_cpd_shd.g_old_rec.rec_nnmntry_uom;
967: ben_cpd_shd.g_old_rec.rec_abr_id;
968: End If;
969: If (p_rec.rec_nnmntry_uom = hr_api.g_varchar2) then
970: p_rec.rec_nnmntry_uom :=
971: ben_cpd_shd.g_old_rec.rec_nnmntry_uom;
972: End If;
973: If (p_rec.rec_rndg_cd = hr_api.g_varchar2) then
974: p_rec.rec_rndg_cd :=
975: ben_cpd_shd.g_old_rec.rec_rndg_cd;
971: ben_cpd_shd.g_old_rec.rec_nnmntry_uom;
972: End If;
973: If (p_rec.rec_rndg_cd = hr_api.g_varchar2) then
974: p_rec.rec_rndg_cd :=
975: ben_cpd_shd.g_old_rec.rec_rndg_cd;
976: End If;
977: If (p_rec.tot_comp_abr_id = hr_api.g_number) then
978: p_rec.tot_comp_abr_id :=
979: ben_cpd_shd.g_old_rec.tot_comp_abr_id;
975: ben_cpd_shd.g_old_rec.rec_rndg_cd;
976: End If;
977: If (p_rec.tot_comp_abr_id = hr_api.g_number) then
978: p_rec.tot_comp_abr_id :=
979: ben_cpd_shd.g_old_rec.tot_comp_abr_id;
980: End If;
981: If (p_rec.tot_comp_nnmntry_uom = hr_api.g_varchar2) then
982: p_rec.tot_comp_nnmntry_uom :=
983: ben_cpd_shd.g_old_rec.tot_comp_nnmntry_uom;
979: ben_cpd_shd.g_old_rec.tot_comp_abr_id;
980: End If;
981: If (p_rec.tot_comp_nnmntry_uom = hr_api.g_varchar2) then
982: p_rec.tot_comp_nnmntry_uom :=
983: ben_cpd_shd.g_old_rec.tot_comp_nnmntry_uom;
984: End If;
985: If (p_rec.tot_comp_rndg_cd = hr_api.g_varchar2) then
986: p_rec.tot_comp_rndg_cd :=
987: ben_cpd_shd.g_old_rec.tot_comp_rndg_cd;
983: ben_cpd_shd.g_old_rec.tot_comp_nnmntry_uom;
984: End If;
985: If (p_rec.tot_comp_rndg_cd = hr_api.g_varchar2) then
986: p_rec.tot_comp_rndg_cd :=
987: ben_cpd_shd.g_old_rec.tot_comp_rndg_cd;
988: End If;
989: If (p_rec.oth_comp_abr_id = hr_api.g_number) then
990: p_rec.oth_comp_abr_id :=
991: ben_cpd_shd.g_old_rec.oth_comp_abr_id;
987: ben_cpd_shd.g_old_rec.tot_comp_rndg_cd;
988: End If;
989: If (p_rec.oth_comp_abr_id = hr_api.g_number) then
990: p_rec.oth_comp_abr_id :=
991: ben_cpd_shd.g_old_rec.oth_comp_abr_id;
992: End If;
993: If (p_rec.oth_comp_nnmntry_uom = hr_api.g_varchar2) then
994: p_rec.oth_comp_nnmntry_uom :=
995: ben_cpd_shd.g_old_rec.oth_comp_nnmntry_uom;
991: ben_cpd_shd.g_old_rec.oth_comp_abr_id;
992: End If;
993: If (p_rec.oth_comp_nnmntry_uom = hr_api.g_varchar2) then
994: p_rec.oth_comp_nnmntry_uom :=
995: ben_cpd_shd.g_old_rec.oth_comp_nnmntry_uom;
996: End If;
997: If (p_rec.oth_comp_rndg_cd = hr_api.g_varchar2) then
998: p_rec.oth_comp_rndg_cd :=
999: ben_cpd_shd.g_old_rec.oth_comp_rndg_cd;
995: ben_cpd_shd.g_old_rec.oth_comp_nnmntry_uom;
996: End If;
997: If (p_rec.oth_comp_rndg_cd = hr_api.g_varchar2) then
998: p_rec.oth_comp_rndg_cd :=
999: ben_cpd_shd.g_old_rec.oth_comp_rndg_cd;
1000: End If;
1001: If (p_rec.actual_flag = hr_api.g_varchar2) then
1002: p_rec.actual_flag :=
1003: ben_cpd_shd.g_old_rec.actual_flag;
999: ben_cpd_shd.g_old_rec.oth_comp_rndg_cd;
1000: End If;
1001: If (p_rec.actual_flag = hr_api.g_varchar2) then
1002: p_rec.actual_flag :=
1003: ben_cpd_shd.g_old_rec.actual_flag;
1004: End If;
1005: If (p_rec.acty_ref_perd_cd = hr_api.g_varchar2) then
1006: p_rec.acty_ref_perd_cd :=
1007: ben_cpd_shd.g_old_rec.acty_ref_perd_cd;
1003: ben_cpd_shd.g_old_rec.actual_flag;
1004: End If;
1005: If (p_rec.acty_ref_perd_cd = hr_api.g_varchar2) then
1006: p_rec.acty_ref_perd_cd :=
1007: ben_cpd_shd.g_old_rec.acty_ref_perd_cd;
1008: End If;
1009: If (p_rec.legislation_code = hr_api.g_varchar2) then
1010: p_rec.legislation_code :=
1011: ben_cpd_shd.g_old_rec.legislation_code;
1007: ben_cpd_shd.g_old_rec.acty_ref_perd_cd;
1008: End If;
1009: If (p_rec.legislation_code = hr_api.g_varchar2) then
1010: p_rec.legislation_code :=
1011: ben_cpd_shd.g_old_rec.legislation_code;
1012: End If;
1013: If (p_rec.pl_annulization_factor = hr_api.g_number) then
1014: p_rec.pl_annulization_factor :=
1015: ben_cpd_shd.g_old_rec.pl_annulization_factor;
1011: ben_cpd_shd.g_old_rec.legislation_code;
1012: End If;
1013: If (p_rec.pl_annulization_factor = hr_api.g_number) then
1014: p_rec.pl_annulization_factor :=
1015: ben_cpd_shd.g_old_rec.pl_annulization_factor;
1016: End If;
1017: If (p_rec.pl_stat_cd = hr_api.g_varchar2) then
1018: p_rec.pl_stat_cd :=
1019: ben_cpd_shd.g_old_rec.pl_stat_cd;
1015: ben_cpd_shd.g_old_rec.pl_annulization_factor;
1016: End If;
1017: If (p_rec.pl_stat_cd = hr_api.g_varchar2) then
1018: p_rec.pl_stat_cd :=
1019: ben_cpd_shd.g_old_rec.pl_stat_cd;
1020: End If;
1021: If (p_rec.uom_precision = hr_api.g_number) then
1022: p_rec.uom_precision :=
1023: ben_cpd_shd.g_old_rec.uom_precision;
1019: ben_cpd_shd.g_old_rec.pl_stat_cd;
1020: End If;
1021: If (p_rec.uom_precision = hr_api.g_number) then
1022: p_rec.uom_precision :=
1023: ben_cpd_shd.g_old_rec.uom_precision;
1024: End If;
1025: If (p_rec.ws_element_type_id = hr_api.g_number) then
1026: p_rec.ws_element_type_id :=
1027: ben_cpd_shd.g_old_rec.ws_element_type_id;
1023: ben_cpd_shd.g_old_rec.uom_precision;
1024: End If;
1025: If (p_rec.ws_element_type_id = hr_api.g_number) then
1026: p_rec.ws_element_type_id :=
1027: ben_cpd_shd.g_old_rec.ws_element_type_id;
1028: End If;
1029: If (p_rec.ws_input_value_id = hr_api.g_number) then
1030: p_rec.ws_input_value_id :=
1031: ben_cpd_shd.g_old_rec.ws_input_value_id;
1027: ben_cpd_shd.g_old_rec.ws_element_type_id;
1028: End If;
1029: If (p_rec.ws_input_value_id = hr_api.g_number) then
1030: p_rec.ws_input_value_id :=
1031: ben_cpd_shd.g_old_rec.ws_input_value_id;
1032: End if;
1033: If (p_rec.data_freeze_date = hr_api.g_date) then
1034: p_rec.data_freeze_date :=
1035: ben_cpd_shd.g_old_rec.data_freeze_date;
1031: ben_cpd_shd.g_old_rec.ws_input_value_id;
1032: End if;
1033: If (p_rec.data_freeze_date = hr_api.g_date) then
1034: p_rec.data_freeze_date :=
1035: ben_cpd_shd.g_old_rec.data_freeze_date;
1036: End If;
1037: If (p_rec.ws_amt_edit_cd = hr_api.g_varchar2) then
1038: p_rec.ws_amt_edit_cd :=
1039: ben_cpd_shd.g_old_rec.ws_amt_edit_cd;
1035: ben_cpd_shd.g_old_rec.data_freeze_date;
1036: End If;
1037: If (p_rec.ws_amt_edit_cd = hr_api.g_varchar2) then
1038: p_rec.ws_amt_edit_cd :=
1039: ben_cpd_shd.g_old_rec.ws_amt_edit_cd;
1040: End If;
1041: If (p_rec.ws_amt_edit_enf_cd_for_nulls = hr_api.g_varchar2) then
1042: p_rec.ws_amt_edit_enf_cd_for_nulls :=
1043: ben_cpd_shd.g_old_rec.ws_amt_edit_enf_cd_for_nulls;
1039: ben_cpd_shd.g_old_rec.ws_amt_edit_cd;
1040: End If;
1041: If (p_rec.ws_amt_edit_enf_cd_for_nulls = hr_api.g_varchar2) then
1042: p_rec.ws_amt_edit_enf_cd_for_nulls :=
1043: ben_cpd_shd.g_old_rec.ws_amt_edit_enf_cd_for_nulls;
1044: End If;
1045: If (p_rec.ws_over_budget_edit_cd = hr_api.g_varchar2) then
1046: p_rec.ws_over_budget_edit_cd :=
1047: ben_cpd_shd.g_old_rec.ws_over_budget_edit_cd;
1043: ben_cpd_shd.g_old_rec.ws_amt_edit_enf_cd_for_nulls;
1044: End If;
1045: If (p_rec.ws_over_budget_edit_cd = hr_api.g_varchar2) then
1046: p_rec.ws_over_budget_edit_cd :=
1047: ben_cpd_shd.g_old_rec.ws_over_budget_edit_cd;
1048: End If;
1049: If (p_rec.ws_over_budget_tolerance_pct = hr_api.g_number) then
1050: p_rec.ws_over_budget_tolerance_pct :=
1051: ben_cpd_shd.g_old_rec.ws_over_budget_tolerance_pct;
1047: ben_cpd_shd.g_old_rec.ws_over_budget_edit_cd;
1048: End If;
1049: If (p_rec.ws_over_budget_tolerance_pct = hr_api.g_number) then
1050: p_rec.ws_over_budget_tolerance_pct :=
1051: ben_cpd_shd.g_old_rec.ws_over_budget_tolerance_pct;
1052: End If;
1053: If (p_rec.bdgt_over_budget_edit_cd = hr_api.g_varchar2) then
1054: p_rec.bdgt_over_budget_edit_cd :=
1055: ben_cpd_shd.g_old_rec.bdgt_over_budget_edit_cd;
1051: ben_cpd_shd.g_old_rec.ws_over_budget_tolerance_pct;
1052: End If;
1053: If (p_rec.bdgt_over_budget_edit_cd = hr_api.g_varchar2) then
1054: p_rec.bdgt_over_budget_edit_cd :=
1055: ben_cpd_shd.g_old_rec.bdgt_over_budget_edit_cd;
1056: End If;
1057: If (p_rec.bdgt_over_budget_tolerance_pct = hr_api.g_number) then
1058: p_rec.bdgt_over_budget_tolerance_pct :=
1059: ben_cpd_shd.g_old_rec.bdgt_over_budget_tolerance_pct;
1055: ben_cpd_shd.g_old_rec.bdgt_over_budget_edit_cd;
1056: End If;
1057: If (p_rec.bdgt_over_budget_tolerance_pct = hr_api.g_number) then
1058: p_rec.bdgt_over_budget_tolerance_pct :=
1059: ben_cpd_shd.g_old_rec.bdgt_over_budget_tolerance_pct;
1060: End If;
1061: If (p_rec.auto_distr_flag = hr_api.g_varchar2) then
1062: p_rec.auto_distr_flag :=
1063: ben_cpd_shd.g_old_rec.auto_distr_flag;
1059: ben_cpd_shd.g_old_rec.bdgt_over_budget_tolerance_pct;
1060: End If;
1061: If (p_rec.auto_distr_flag = hr_api.g_varchar2) then
1062: p_rec.auto_distr_flag :=
1063: ben_cpd_shd.g_old_rec.auto_distr_flag;
1064: End If;
1065: If (p_rec.pqh_document_short_name = hr_api.g_varchar2) then
1066: p_rec.pqh_document_short_name :=
1067: ben_cpd_shd.g_old_rec.pqh_document_short_name;
1063: ben_cpd_shd.g_old_rec.auto_distr_flag;
1064: End If;
1065: If (p_rec.pqh_document_short_name = hr_api.g_varchar2) then
1066: p_rec.pqh_document_short_name :=
1067: ben_cpd_shd.g_old_rec.pqh_document_short_name;
1068: End If;
1069: If (p_rec.ovrid_rt_strt_dt = hr_api.g_date) then
1070: p_rec.ovrid_rt_strt_dt :=
1071: ben_cpd_shd.g_old_rec.ovrid_rt_strt_dt;
1067: ben_cpd_shd.g_old_rec.pqh_document_short_name;
1068: End If;
1069: If (p_rec.ovrid_rt_strt_dt = hr_api.g_date) then
1070: p_rec.ovrid_rt_strt_dt :=
1071: ben_cpd_shd.g_old_rec.ovrid_rt_strt_dt;
1072: End If;
1073: If (p_rec.do_not_process_flag = hr_api.g_varchar2) then
1074: p_rec.do_not_process_flag :=
1075: ben_cpd_shd.g_old_rec.do_not_process_flag;
1071: ben_cpd_shd.g_old_rec.ovrid_rt_strt_dt;
1072: End If;
1073: If (p_rec.do_not_process_flag = hr_api.g_varchar2) then
1074: p_rec.do_not_process_flag :=
1075: ben_cpd_shd.g_old_rec.do_not_process_flag;
1076: End If;
1077: If (p_rec.ovr_perf_revw_strt_dt = hr_api.g_date) then
1078: p_rec.ovr_perf_revw_strt_dt :=
1079: ben_cpd_shd.g_old_rec.ovr_perf_revw_strt_dt;
1075: ben_cpd_shd.g_old_rec.do_not_process_flag;
1076: End If;
1077: If (p_rec.ovr_perf_revw_strt_dt = hr_api.g_date) then
1078: p_rec.ovr_perf_revw_strt_dt :=
1079: ben_cpd_shd.g_old_rec.ovr_perf_revw_strt_dt;
1080: End If;
1081: If (p_rec.post_zero_salary_increase = hr_api.g_varchar2) then
1082: p_rec.post_zero_salary_increase :=
1083: ben_cpd_shd.g_old_rec.post_zero_salary_increase;
1079: ben_cpd_shd.g_old_rec.ovr_perf_revw_strt_dt;
1080: End If;
1081: If (p_rec.post_zero_salary_increase = hr_api.g_varchar2) then
1082: p_rec.post_zero_salary_increase :=
1083: ben_cpd_shd.g_old_rec.post_zero_salary_increase;
1084: End If;
1085: If (p_rec.show_appraisals_n_days = hr_api.g_number) then
1086: p_rec.show_appraisals_n_days :=
1087: ben_cpd_shd.g_old_rec.show_appraisals_n_days;
1083: ben_cpd_shd.g_old_rec.post_zero_salary_increase;
1084: End If;
1085: If (p_rec.show_appraisals_n_days = hr_api.g_number) then
1086: p_rec.show_appraisals_n_days :=
1087: ben_cpd_shd.g_old_rec.show_appraisals_n_days;
1088: End If;
1089: If (p_rec.grade_range_validation = hr_api.g_varchar2) then
1090: p_rec.grade_range_validation :=
1091: ben_cpd_shd.g_old_rec.grade_range_validation;
1087: ben_cpd_shd.g_old_rec.show_appraisals_n_days;
1088: End If;
1089: If (p_rec.grade_range_validation = hr_api.g_varchar2) then
1090: p_rec.grade_range_validation :=
1091: ben_cpd_shd.g_old_rec.grade_range_validation;
1092: End If;
1093: If (p_rec.email_password_protected = hr_api.g_varchar2) then
1094: p_rec.email_password_protected :=
1095: ben_cpd_shd.g_old_rec.email_password_protected;
1091: ben_cpd_shd.g_old_rec.grade_range_validation;
1092: End If;
1093: If (p_rec.email_password_protected = hr_api.g_varchar2) then
1094: p_rec.email_password_protected :=
1095: ben_cpd_shd.g_old_rec.email_password_protected;
1096: End If;
1097: If (p_rec.email_cc_manager = hr_api.g_varchar2) then
1098: p_rec.email_cc_manager :=
1099: ben_cpd_shd.g_old_rec.email_cc_manager;
1095: ben_cpd_shd.g_old_rec.email_password_protected;
1096: End If;
1097: If (p_rec.email_cc_manager = hr_api.g_varchar2) then
1098: p_rec.email_cc_manager :=
1099: ben_cpd_shd.g_old_rec.email_cc_manager;
1100: End If;
1101: If (p_rec.email_subject = hr_api.g_varchar2) then
1102: p_rec.email_subject :=
1103: ben_cpd_shd.g_old_rec.email_subject;
1099: ben_cpd_shd.g_old_rec.email_cc_manager;
1100: End If;
1101: If (p_rec.email_subject = hr_api.g_varchar2) then
1102: p_rec.email_subject :=
1103: ben_cpd_shd.g_old_rec.email_subject;
1104: End If;
1105: If (p_rec.email_content = empty_clob()) then
1106: p_rec.email_content :=
1107: ben_cpd_shd.g_old_rec.email_content;
1103: ben_cpd_shd.g_old_rec.email_subject;
1104: End If;
1105: If (p_rec.email_content = empty_clob()) then
1106: p_rec.email_content :=
1107: ben_cpd_shd.g_old_rec.email_content;
1108: End If;
1109: If (p_rec.email_sample_address = hr_api.g_varchar2) then
1110: p_rec.email_sample_address :=
1111: ben_cpd_shd.g_old_rec.email_sample_address;
1107: ben_cpd_shd.g_old_rec.email_content;
1108: End If;
1109: If (p_rec.email_sample_address = hr_api.g_varchar2) then
1110: p_rec.email_sample_address :=
1111: ben_cpd_shd.g_old_rec.email_sample_address;
1112: End If;
1113: --
1114: End convert_defs;
1115: --
1116: -- ----------------------------------------------------------------------------
1117: -- |---------------------------------< upd >----------------------------------|
1118: -- ----------------------------------------------------------------------------
1119: Procedure upd
1120: (p_rec in out nocopy ben_cpd_shd.g_rec_type
1121: ) is
1122: --
1123: l_proc varchar2(72) := g_package||'upd';
1124: --
1126: hr_utility.set_location('Entering:'||l_proc, 5);
1127: --
1128: -- We must lock the row which we need to update.
1129: --
1130: ben_cpd_shd.lck
1131: (p_rec.pl_id
1132: ,p_rec.lf_evt_ocrd_dt
1133: ,p_rec.oipl_id
1134: ,p_rec.object_version_number
1269: ,p_email_content in clob default empty_clob()
1270: ,p_email_sample_address in varchar2 default hr_api.g_varchar2
1271: ) is
1272: --
1273: l_rec ben_cpd_shd.g_rec_type;
1274: l_proc varchar2(72) := g_package||'upd';
1275: --
1276: Begin
1277: hr_utility.set_location('Entering:'||l_proc, 5);
1279: -- Call conversion function to turn arguments into the
1280: -- l_rec structure.
1281: --
1282: l_rec :=
1283: ben_cpd_shd.convert_args
1284: (p_pl_id
1285: ,p_oipl_id
1286: ,p_lf_evt_ocrd_dt
1287: ,p_effective_date