[Home] [Help]
54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: Procedure dt_update_dml
58: (p_rec in out nocopy ben_bpr_shd.g_rec_type,
59: p_effective_date in date,
60: p_datetrack_mode in varchar2,
61: p_validation_start_date in date,
62: p_validation_end_date in date) is
77: (p_base_table_name => 'ben_bnft_pool_rlovr_rqmt_f',
78: p_base_key_column => 'bnft_pool_rlovr_rqmt_id',
79: p_base_key_value => p_rec.bnft_pool_rlovr_rqmt_id);
80: --
81: ben_bpr_shd.g_api_dml := true; -- Set the api dml status
82: --
83: -- Update the ben_bnft_pool_rlovr_rqmt_f Row
84: --
85: update ben_bnft_pool_rlovr_rqmt_f
142: where bnft_pool_rlovr_rqmt_id = p_rec.bnft_pool_rlovr_rqmt_id
143: and effective_start_date = p_validation_start_date
144: and effective_end_date = p_validation_end_date;
145: --
146: ben_bpr_shd.g_api_dml := false; -- Unset the api dml status
147: --
148: -- Set the effective start and end dates
149: --
150: p_rec.effective_start_date := p_validation_start_date;
154: hr_utility.set_location(' Leaving:'||l_proc, 15);
155: Exception
156: When hr_api.check_integrity_violated Then
157: -- A check constraint has been violated
158: ben_bpr_shd.g_api_dml := false; -- Unset the api dml status
159: ben_bpr_shd.constraint_error
160: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
161: When hr_api.unique_integrity_violated Then
162: -- Unique integrity has been violated
155: Exception
156: When hr_api.check_integrity_violated Then
157: -- A check constraint has been violated
158: ben_bpr_shd.g_api_dml := false; -- Unset the api dml status
159: ben_bpr_shd.constraint_error
160: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
161: When hr_api.unique_integrity_violated Then
162: -- Unique integrity has been violated
163: ben_bpr_shd.g_api_dml := false; -- Unset the api dml status
159: ben_bpr_shd.constraint_error
160: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
161: When hr_api.unique_integrity_violated Then
162: -- Unique integrity has been violated
163: ben_bpr_shd.g_api_dml := false; -- Unset the api dml status
164: ben_bpr_shd.constraint_error
165: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
166: When Others Then
167: ben_bpr_shd.g_api_dml := false; -- Unset the api dml status
160: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
161: When hr_api.unique_integrity_violated Then
162: -- Unique integrity has been violated
163: ben_bpr_shd.g_api_dml := false; -- Unset the api dml status
164: ben_bpr_shd.constraint_error
165: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
166: When Others Then
167: ben_bpr_shd.g_api_dml := false; -- Unset the api dml status
168: Raise;
163: ben_bpr_shd.g_api_dml := false; -- Unset the api dml status
164: ben_bpr_shd.constraint_error
165: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
166: When Others Then
167: ben_bpr_shd.g_api_dml := false; -- Unset the api dml status
168: Raise;
169: End dt_update_dml;
170: --
171: -- ----------------------------------------------------------------------------
199: --
200: -- {End Of Comments}
201: -- ----------------------------------------------------------------------------
202: Procedure update_dml
203: (p_rec in out nocopy ben_bpr_shd.g_rec_type,
204: p_effective_date in date,
205: p_datetrack_mode in varchar2,
206: p_validation_start_date in date,
207: p_validation_end_date in date) is
263: --
264: -- {End Of Comments}
265: -- ----------------------------------------------------------------------------
266: Procedure dt_pre_update
267: (p_rec in out nocopy ben_bpr_shd.g_rec_type,
268: p_effective_date in date,
269: p_datetrack_mode in varchar2,
270: p_validation_start_date in date,
271: p_validation_end_date in date) is
279: hr_utility.set_location(l_proc, 10);
280: --
281: -- Update the current effective end date
282: --
283: ben_bpr_shd.upd_effective_end_date
284: (p_effective_date => p_effective_date,
285: p_base_key_value => p_rec.bnft_pool_rlovr_rqmt_id,
286: p_new_effective_end_date => (p_validation_start_date - 1),
287: p_validation_start_date => p_validation_start_date,
348: --
349: -- {End Of Comments}
350: -- ----------------------------------------------------------------------------
351: Procedure pre_update
352: (p_rec in out nocopy ben_bpr_shd.g_rec_type,
353: p_effective_date in date,
354: p_datetrack_mode in varchar2,
355: p_validation_start_date in date,
356: p_validation_end_date in date) is
404: --
405: -- {End Of Comments}
406: -- ----------------------------------------------------------------------------
407: Procedure post_update
408: (p_rec in ben_bpr_shd.g_rec_type,
409: p_effective_date in date,
410: p_datetrack_mode in varchar2,
411: p_validation_start_date in date,
412: p_validation_end_date in date) is
483: ,p_effective_date =>p_effective_date
484: ,p_datetrack_mode =>p_datetrack_mode
485: ,p_validation_start_date =>p_validation_start_date
486: ,p_validation_end_date =>p_validation_end_date
487: ,p_effective_start_date_o =>ben_bpr_shd.g_old_rec.effective_start_date
488: ,p_effective_end_date_o =>ben_bpr_shd.g_old_rec.effective_end_date
489: ,p_no_mn_rlovr_pct_dfnd_flag_o =>ben_bpr_shd.g_old_rec.no_mn_rlovr_pct_dfnd_flag
490: ,p_no_mx_rlovr_pct_dfnd_flag_o =>ben_bpr_shd.g_old_rec.no_mx_rlovr_pct_dfnd_flag
491: ,p_no_mn_rlovr_val_dfnd_flag_o =>ben_bpr_shd.g_old_rec.no_mn_rlovr_val_dfnd_flag
484: ,p_datetrack_mode =>p_datetrack_mode
485: ,p_validation_start_date =>p_validation_start_date
486: ,p_validation_end_date =>p_validation_end_date
487: ,p_effective_start_date_o =>ben_bpr_shd.g_old_rec.effective_start_date
488: ,p_effective_end_date_o =>ben_bpr_shd.g_old_rec.effective_end_date
489: ,p_no_mn_rlovr_pct_dfnd_flag_o =>ben_bpr_shd.g_old_rec.no_mn_rlovr_pct_dfnd_flag
490: ,p_no_mx_rlovr_pct_dfnd_flag_o =>ben_bpr_shd.g_old_rec.no_mx_rlovr_pct_dfnd_flag
491: ,p_no_mn_rlovr_val_dfnd_flag_o =>ben_bpr_shd.g_old_rec.no_mn_rlovr_val_dfnd_flag
492: ,p_no_mx_rlovr_val_dfnd_flag_o =>ben_bpr_shd.g_old_rec.no_mx_rlovr_val_dfnd_flag
485: ,p_validation_start_date =>p_validation_start_date
486: ,p_validation_end_date =>p_validation_end_date
487: ,p_effective_start_date_o =>ben_bpr_shd.g_old_rec.effective_start_date
488: ,p_effective_end_date_o =>ben_bpr_shd.g_old_rec.effective_end_date
489: ,p_no_mn_rlovr_pct_dfnd_flag_o =>ben_bpr_shd.g_old_rec.no_mn_rlovr_pct_dfnd_flag
490: ,p_no_mx_rlovr_pct_dfnd_flag_o =>ben_bpr_shd.g_old_rec.no_mx_rlovr_pct_dfnd_flag
491: ,p_no_mn_rlovr_val_dfnd_flag_o =>ben_bpr_shd.g_old_rec.no_mn_rlovr_val_dfnd_flag
492: ,p_no_mx_rlovr_val_dfnd_flag_o =>ben_bpr_shd.g_old_rec.no_mx_rlovr_val_dfnd_flag
493: ,p_rlovr_val_incrmt_num_o =>ben_bpr_shd.g_old_rec.rlovr_val_incrmt_num
486: ,p_validation_end_date =>p_validation_end_date
487: ,p_effective_start_date_o =>ben_bpr_shd.g_old_rec.effective_start_date
488: ,p_effective_end_date_o =>ben_bpr_shd.g_old_rec.effective_end_date
489: ,p_no_mn_rlovr_pct_dfnd_flag_o =>ben_bpr_shd.g_old_rec.no_mn_rlovr_pct_dfnd_flag
490: ,p_no_mx_rlovr_pct_dfnd_flag_o =>ben_bpr_shd.g_old_rec.no_mx_rlovr_pct_dfnd_flag
491: ,p_no_mn_rlovr_val_dfnd_flag_o =>ben_bpr_shd.g_old_rec.no_mn_rlovr_val_dfnd_flag
492: ,p_no_mx_rlovr_val_dfnd_flag_o =>ben_bpr_shd.g_old_rec.no_mx_rlovr_val_dfnd_flag
493: ,p_rlovr_val_incrmt_num_o =>ben_bpr_shd.g_old_rec.rlovr_val_incrmt_num
494: ,p_rlovr_val_rl_o =>ben_bpr_shd.g_old_rec.rlovr_val_rl
487: ,p_effective_start_date_o =>ben_bpr_shd.g_old_rec.effective_start_date
488: ,p_effective_end_date_o =>ben_bpr_shd.g_old_rec.effective_end_date
489: ,p_no_mn_rlovr_pct_dfnd_flag_o =>ben_bpr_shd.g_old_rec.no_mn_rlovr_pct_dfnd_flag
490: ,p_no_mx_rlovr_pct_dfnd_flag_o =>ben_bpr_shd.g_old_rec.no_mx_rlovr_pct_dfnd_flag
491: ,p_no_mn_rlovr_val_dfnd_flag_o =>ben_bpr_shd.g_old_rec.no_mn_rlovr_val_dfnd_flag
492: ,p_no_mx_rlovr_val_dfnd_flag_o =>ben_bpr_shd.g_old_rec.no_mx_rlovr_val_dfnd_flag
493: ,p_rlovr_val_incrmt_num_o =>ben_bpr_shd.g_old_rec.rlovr_val_incrmt_num
494: ,p_rlovr_val_rl_o =>ben_bpr_shd.g_old_rec.rlovr_val_rl
495: ,p_mn_rlovr_val_o =>ben_bpr_shd.g_old_rec.mn_rlovr_val
488: ,p_effective_end_date_o =>ben_bpr_shd.g_old_rec.effective_end_date
489: ,p_no_mn_rlovr_pct_dfnd_flag_o =>ben_bpr_shd.g_old_rec.no_mn_rlovr_pct_dfnd_flag
490: ,p_no_mx_rlovr_pct_dfnd_flag_o =>ben_bpr_shd.g_old_rec.no_mx_rlovr_pct_dfnd_flag
491: ,p_no_mn_rlovr_val_dfnd_flag_o =>ben_bpr_shd.g_old_rec.no_mn_rlovr_val_dfnd_flag
492: ,p_no_mx_rlovr_val_dfnd_flag_o =>ben_bpr_shd.g_old_rec.no_mx_rlovr_val_dfnd_flag
493: ,p_rlovr_val_incrmt_num_o =>ben_bpr_shd.g_old_rec.rlovr_val_incrmt_num
494: ,p_rlovr_val_rl_o =>ben_bpr_shd.g_old_rec.rlovr_val_rl
495: ,p_mn_rlovr_val_o =>ben_bpr_shd.g_old_rec.mn_rlovr_val
496: ,p_mx_rlovr_val_o =>ben_bpr_shd.g_old_rec.mx_rlovr_val
489: ,p_no_mn_rlovr_pct_dfnd_flag_o =>ben_bpr_shd.g_old_rec.no_mn_rlovr_pct_dfnd_flag
490: ,p_no_mx_rlovr_pct_dfnd_flag_o =>ben_bpr_shd.g_old_rec.no_mx_rlovr_pct_dfnd_flag
491: ,p_no_mn_rlovr_val_dfnd_flag_o =>ben_bpr_shd.g_old_rec.no_mn_rlovr_val_dfnd_flag
492: ,p_no_mx_rlovr_val_dfnd_flag_o =>ben_bpr_shd.g_old_rec.no_mx_rlovr_val_dfnd_flag
493: ,p_rlovr_val_incrmt_num_o =>ben_bpr_shd.g_old_rec.rlovr_val_incrmt_num
494: ,p_rlovr_val_rl_o =>ben_bpr_shd.g_old_rec.rlovr_val_rl
495: ,p_mn_rlovr_val_o =>ben_bpr_shd.g_old_rec.mn_rlovr_val
496: ,p_mx_rlovr_val_o =>ben_bpr_shd.g_old_rec.mx_rlovr_val
497: ,p_val_rndg_cd_o =>ben_bpr_shd.g_old_rec.val_rndg_cd
490: ,p_no_mx_rlovr_pct_dfnd_flag_o =>ben_bpr_shd.g_old_rec.no_mx_rlovr_pct_dfnd_flag
491: ,p_no_mn_rlovr_val_dfnd_flag_o =>ben_bpr_shd.g_old_rec.no_mn_rlovr_val_dfnd_flag
492: ,p_no_mx_rlovr_val_dfnd_flag_o =>ben_bpr_shd.g_old_rec.no_mx_rlovr_val_dfnd_flag
493: ,p_rlovr_val_incrmt_num_o =>ben_bpr_shd.g_old_rec.rlovr_val_incrmt_num
494: ,p_rlovr_val_rl_o =>ben_bpr_shd.g_old_rec.rlovr_val_rl
495: ,p_mn_rlovr_val_o =>ben_bpr_shd.g_old_rec.mn_rlovr_val
496: ,p_mx_rlovr_val_o =>ben_bpr_shd.g_old_rec.mx_rlovr_val
497: ,p_val_rndg_cd_o =>ben_bpr_shd.g_old_rec.val_rndg_cd
498: ,p_val_rndg_rl_o =>ben_bpr_shd.g_old_rec.val_rndg_rl
491: ,p_no_mn_rlovr_val_dfnd_flag_o =>ben_bpr_shd.g_old_rec.no_mn_rlovr_val_dfnd_flag
492: ,p_no_mx_rlovr_val_dfnd_flag_o =>ben_bpr_shd.g_old_rec.no_mx_rlovr_val_dfnd_flag
493: ,p_rlovr_val_incrmt_num_o =>ben_bpr_shd.g_old_rec.rlovr_val_incrmt_num
494: ,p_rlovr_val_rl_o =>ben_bpr_shd.g_old_rec.rlovr_val_rl
495: ,p_mn_rlovr_val_o =>ben_bpr_shd.g_old_rec.mn_rlovr_val
496: ,p_mx_rlovr_val_o =>ben_bpr_shd.g_old_rec.mx_rlovr_val
497: ,p_val_rndg_cd_o =>ben_bpr_shd.g_old_rec.val_rndg_cd
498: ,p_val_rndg_rl_o =>ben_bpr_shd.g_old_rec.val_rndg_rl
499: ,p_pct_rndg_cd_o =>ben_bpr_shd.g_old_rec.pct_rndg_cd
492: ,p_no_mx_rlovr_val_dfnd_flag_o =>ben_bpr_shd.g_old_rec.no_mx_rlovr_val_dfnd_flag
493: ,p_rlovr_val_incrmt_num_o =>ben_bpr_shd.g_old_rec.rlovr_val_incrmt_num
494: ,p_rlovr_val_rl_o =>ben_bpr_shd.g_old_rec.rlovr_val_rl
495: ,p_mn_rlovr_val_o =>ben_bpr_shd.g_old_rec.mn_rlovr_val
496: ,p_mx_rlovr_val_o =>ben_bpr_shd.g_old_rec.mx_rlovr_val
497: ,p_val_rndg_cd_o =>ben_bpr_shd.g_old_rec.val_rndg_cd
498: ,p_val_rndg_rl_o =>ben_bpr_shd.g_old_rec.val_rndg_rl
499: ,p_pct_rndg_cd_o =>ben_bpr_shd.g_old_rec.pct_rndg_cd
500: ,p_pct_rndg_rl_o =>ben_bpr_shd.g_old_rec.pct_rndg_rl
493: ,p_rlovr_val_incrmt_num_o =>ben_bpr_shd.g_old_rec.rlovr_val_incrmt_num
494: ,p_rlovr_val_rl_o =>ben_bpr_shd.g_old_rec.rlovr_val_rl
495: ,p_mn_rlovr_val_o =>ben_bpr_shd.g_old_rec.mn_rlovr_val
496: ,p_mx_rlovr_val_o =>ben_bpr_shd.g_old_rec.mx_rlovr_val
497: ,p_val_rndg_cd_o =>ben_bpr_shd.g_old_rec.val_rndg_cd
498: ,p_val_rndg_rl_o =>ben_bpr_shd.g_old_rec.val_rndg_rl
499: ,p_pct_rndg_cd_o =>ben_bpr_shd.g_old_rec.pct_rndg_cd
500: ,p_pct_rndg_rl_o =>ben_bpr_shd.g_old_rec.pct_rndg_rl
501: ,p_prtt_elig_rlovr_rl_o =>ben_bpr_shd.g_old_rec.prtt_elig_rlovr_rl
494: ,p_rlovr_val_rl_o =>ben_bpr_shd.g_old_rec.rlovr_val_rl
495: ,p_mn_rlovr_val_o =>ben_bpr_shd.g_old_rec.mn_rlovr_val
496: ,p_mx_rlovr_val_o =>ben_bpr_shd.g_old_rec.mx_rlovr_val
497: ,p_val_rndg_cd_o =>ben_bpr_shd.g_old_rec.val_rndg_cd
498: ,p_val_rndg_rl_o =>ben_bpr_shd.g_old_rec.val_rndg_rl
499: ,p_pct_rndg_cd_o =>ben_bpr_shd.g_old_rec.pct_rndg_cd
500: ,p_pct_rndg_rl_o =>ben_bpr_shd.g_old_rec.pct_rndg_rl
501: ,p_prtt_elig_rlovr_rl_o =>ben_bpr_shd.g_old_rec.prtt_elig_rlovr_rl
502: ,p_mx_rchd_dflt_ordr_num_o =>ben_bpr_shd.g_old_rec.mx_rchd_dflt_ordr_num
495: ,p_mn_rlovr_val_o =>ben_bpr_shd.g_old_rec.mn_rlovr_val
496: ,p_mx_rlovr_val_o =>ben_bpr_shd.g_old_rec.mx_rlovr_val
497: ,p_val_rndg_cd_o =>ben_bpr_shd.g_old_rec.val_rndg_cd
498: ,p_val_rndg_rl_o =>ben_bpr_shd.g_old_rec.val_rndg_rl
499: ,p_pct_rndg_cd_o =>ben_bpr_shd.g_old_rec.pct_rndg_cd
500: ,p_pct_rndg_rl_o =>ben_bpr_shd.g_old_rec.pct_rndg_rl
501: ,p_prtt_elig_rlovr_rl_o =>ben_bpr_shd.g_old_rec.prtt_elig_rlovr_rl
502: ,p_mx_rchd_dflt_ordr_num_o =>ben_bpr_shd.g_old_rec.mx_rchd_dflt_ordr_num
503: ,p_pct_rlovr_incrmt_num_o =>ben_bpr_shd.g_old_rec.pct_rlovr_incrmt_num
496: ,p_mx_rlovr_val_o =>ben_bpr_shd.g_old_rec.mx_rlovr_val
497: ,p_val_rndg_cd_o =>ben_bpr_shd.g_old_rec.val_rndg_cd
498: ,p_val_rndg_rl_o =>ben_bpr_shd.g_old_rec.val_rndg_rl
499: ,p_pct_rndg_cd_o =>ben_bpr_shd.g_old_rec.pct_rndg_cd
500: ,p_pct_rndg_rl_o =>ben_bpr_shd.g_old_rec.pct_rndg_rl
501: ,p_prtt_elig_rlovr_rl_o =>ben_bpr_shd.g_old_rec.prtt_elig_rlovr_rl
502: ,p_mx_rchd_dflt_ordr_num_o =>ben_bpr_shd.g_old_rec.mx_rchd_dflt_ordr_num
503: ,p_pct_rlovr_incrmt_num_o =>ben_bpr_shd.g_old_rec.pct_rlovr_incrmt_num
504: ,p_mn_rlovr_pct_num_o =>ben_bpr_shd.g_old_rec.mn_rlovr_pct_num
497: ,p_val_rndg_cd_o =>ben_bpr_shd.g_old_rec.val_rndg_cd
498: ,p_val_rndg_rl_o =>ben_bpr_shd.g_old_rec.val_rndg_rl
499: ,p_pct_rndg_cd_o =>ben_bpr_shd.g_old_rec.pct_rndg_cd
500: ,p_pct_rndg_rl_o =>ben_bpr_shd.g_old_rec.pct_rndg_rl
501: ,p_prtt_elig_rlovr_rl_o =>ben_bpr_shd.g_old_rec.prtt_elig_rlovr_rl
502: ,p_mx_rchd_dflt_ordr_num_o =>ben_bpr_shd.g_old_rec.mx_rchd_dflt_ordr_num
503: ,p_pct_rlovr_incrmt_num_o =>ben_bpr_shd.g_old_rec.pct_rlovr_incrmt_num
504: ,p_mn_rlovr_pct_num_o =>ben_bpr_shd.g_old_rec.mn_rlovr_pct_num
505: ,p_mx_rlovr_pct_num_o =>ben_bpr_shd.g_old_rec.mx_rlovr_pct_num
498: ,p_val_rndg_rl_o =>ben_bpr_shd.g_old_rec.val_rndg_rl
499: ,p_pct_rndg_cd_o =>ben_bpr_shd.g_old_rec.pct_rndg_cd
500: ,p_pct_rndg_rl_o =>ben_bpr_shd.g_old_rec.pct_rndg_rl
501: ,p_prtt_elig_rlovr_rl_o =>ben_bpr_shd.g_old_rec.prtt_elig_rlovr_rl
502: ,p_mx_rchd_dflt_ordr_num_o =>ben_bpr_shd.g_old_rec.mx_rchd_dflt_ordr_num
503: ,p_pct_rlovr_incrmt_num_o =>ben_bpr_shd.g_old_rec.pct_rlovr_incrmt_num
504: ,p_mn_rlovr_pct_num_o =>ben_bpr_shd.g_old_rec.mn_rlovr_pct_num
505: ,p_mx_rlovr_pct_num_o =>ben_bpr_shd.g_old_rec.mx_rlovr_pct_num
506: ,p_crs_rlovr_procg_cd_o =>ben_bpr_shd.g_old_rec.crs_rlovr_procg_cd
499: ,p_pct_rndg_cd_o =>ben_bpr_shd.g_old_rec.pct_rndg_cd
500: ,p_pct_rndg_rl_o =>ben_bpr_shd.g_old_rec.pct_rndg_rl
501: ,p_prtt_elig_rlovr_rl_o =>ben_bpr_shd.g_old_rec.prtt_elig_rlovr_rl
502: ,p_mx_rchd_dflt_ordr_num_o =>ben_bpr_shd.g_old_rec.mx_rchd_dflt_ordr_num
503: ,p_pct_rlovr_incrmt_num_o =>ben_bpr_shd.g_old_rec.pct_rlovr_incrmt_num
504: ,p_mn_rlovr_pct_num_o =>ben_bpr_shd.g_old_rec.mn_rlovr_pct_num
505: ,p_mx_rlovr_pct_num_o =>ben_bpr_shd.g_old_rec.mx_rlovr_pct_num
506: ,p_crs_rlovr_procg_cd_o =>ben_bpr_shd.g_old_rec.crs_rlovr_procg_cd
507: ,p_mx_pct_ttl_crs_cn_roll_num_o =>ben_bpr_shd.g_old_rec.mx_pct_ttl_crs_cn_roll_num
500: ,p_pct_rndg_rl_o =>ben_bpr_shd.g_old_rec.pct_rndg_rl
501: ,p_prtt_elig_rlovr_rl_o =>ben_bpr_shd.g_old_rec.prtt_elig_rlovr_rl
502: ,p_mx_rchd_dflt_ordr_num_o =>ben_bpr_shd.g_old_rec.mx_rchd_dflt_ordr_num
503: ,p_pct_rlovr_incrmt_num_o =>ben_bpr_shd.g_old_rec.pct_rlovr_incrmt_num
504: ,p_mn_rlovr_pct_num_o =>ben_bpr_shd.g_old_rec.mn_rlovr_pct_num
505: ,p_mx_rlovr_pct_num_o =>ben_bpr_shd.g_old_rec.mx_rlovr_pct_num
506: ,p_crs_rlovr_procg_cd_o =>ben_bpr_shd.g_old_rec.crs_rlovr_procg_cd
507: ,p_mx_pct_ttl_crs_cn_roll_num_o =>ben_bpr_shd.g_old_rec.mx_pct_ttl_crs_cn_roll_num
508: ,p_bnft_prvdr_pool_id_o =>ben_bpr_shd.g_old_rec.bnft_prvdr_pool_id
501: ,p_prtt_elig_rlovr_rl_o =>ben_bpr_shd.g_old_rec.prtt_elig_rlovr_rl
502: ,p_mx_rchd_dflt_ordr_num_o =>ben_bpr_shd.g_old_rec.mx_rchd_dflt_ordr_num
503: ,p_pct_rlovr_incrmt_num_o =>ben_bpr_shd.g_old_rec.pct_rlovr_incrmt_num
504: ,p_mn_rlovr_pct_num_o =>ben_bpr_shd.g_old_rec.mn_rlovr_pct_num
505: ,p_mx_rlovr_pct_num_o =>ben_bpr_shd.g_old_rec.mx_rlovr_pct_num
506: ,p_crs_rlovr_procg_cd_o =>ben_bpr_shd.g_old_rec.crs_rlovr_procg_cd
507: ,p_mx_pct_ttl_crs_cn_roll_num_o =>ben_bpr_shd.g_old_rec.mx_pct_ttl_crs_cn_roll_num
508: ,p_bnft_prvdr_pool_id_o =>ben_bpr_shd.g_old_rec.bnft_prvdr_pool_id
509: ,p_acty_base_rt_id_o =>ben_bpr_shd.g_old_rec.acty_base_rt_id
502: ,p_mx_rchd_dflt_ordr_num_o =>ben_bpr_shd.g_old_rec.mx_rchd_dflt_ordr_num
503: ,p_pct_rlovr_incrmt_num_o =>ben_bpr_shd.g_old_rec.pct_rlovr_incrmt_num
504: ,p_mn_rlovr_pct_num_o =>ben_bpr_shd.g_old_rec.mn_rlovr_pct_num
505: ,p_mx_rlovr_pct_num_o =>ben_bpr_shd.g_old_rec.mx_rlovr_pct_num
506: ,p_crs_rlovr_procg_cd_o =>ben_bpr_shd.g_old_rec.crs_rlovr_procg_cd
507: ,p_mx_pct_ttl_crs_cn_roll_num_o =>ben_bpr_shd.g_old_rec.mx_pct_ttl_crs_cn_roll_num
508: ,p_bnft_prvdr_pool_id_o =>ben_bpr_shd.g_old_rec.bnft_prvdr_pool_id
509: ,p_acty_base_rt_id_o =>ben_bpr_shd.g_old_rec.acty_base_rt_id
510: ,p_business_group_id_o =>ben_bpr_shd.g_old_rec.business_group_id
503: ,p_pct_rlovr_incrmt_num_o =>ben_bpr_shd.g_old_rec.pct_rlovr_incrmt_num
504: ,p_mn_rlovr_pct_num_o =>ben_bpr_shd.g_old_rec.mn_rlovr_pct_num
505: ,p_mx_rlovr_pct_num_o =>ben_bpr_shd.g_old_rec.mx_rlovr_pct_num
506: ,p_crs_rlovr_procg_cd_o =>ben_bpr_shd.g_old_rec.crs_rlovr_procg_cd
507: ,p_mx_pct_ttl_crs_cn_roll_num_o =>ben_bpr_shd.g_old_rec.mx_pct_ttl_crs_cn_roll_num
508: ,p_bnft_prvdr_pool_id_o =>ben_bpr_shd.g_old_rec.bnft_prvdr_pool_id
509: ,p_acty_base_rt_id_o =>ben_bpr_shd.g_old_rec.acty_base_rt_id
510: ,p_business_group_id_o =>ben_bpr_shd.g_old_rec.business_group_id
511: ,p_bpr_attribute_category_o =>ben_bpr_shd.g_old_rec.bpr_attribute_category
504: ,p_mn_rlovr_pct_num_o =>ben_bpr_shd.g_old_rec.mn_rlovr_pct_num
505: ,p_mx_rlovr_pct_num_o =>ben_bpr_shd.g_old_rec.mx_rlovr_pct_num
506: ,p_crs_rlovr_procg_cd_o =>ben_bpr_shd.g_old_rec.crs_rlovr_procg_cd
507: ,p_mx_pct_ttl_crs_cn_roll_num_o =>ben_bpr_shd.g_old_rec.mx_pct_ttl_crs_cn_roll_num
508: ,p_bnft_prvdr_pool_id_o =>ben_bpr_shd.g_old_rec.bnft_prvdr_pool_id
509: ,p_acty_base_rt_id_o =>ben_bpr_shd.g_old_rec.acty_base_rt_id
510: ,p_business_group_id_o =>ben_bpr_shd.g_old_rec.business_group_id
511: ,p_bpr_attribute_category_o =>ben_bpr_shd.g_old_rec.bpr_attribute_category
512: ,p_bpr_attribute1_o =>ben_bpr_shd.g_old_rec.bpr_attribute1
505: ,p_mx_rlovr_pct_num_o =>ben_bpr_shd.g_old_rec.mx_rlovr_pct_num
506: ,p_crs_rlovr_procg_cd_o =>ben_bpr_shd.g_old_rec.crs_rlovr_procg_cd
507: ,p_mx_pct_ttl_crs_cn_roll_num_o =>ben_bpr_shd.g_old_rec.mx_pct_ttl_crs_cn_roll_num
508: ,p_bnft_prvdr_pool_id_o =>ben_bpr_shd.g_old_rec.bnft_prvdr_pool_id
509: ,p_acty_base_rt_id_o =>ben_bpr_shd.g_old_rec.acty_base_rt_id
510: ,p_business_group_id_o =>ben_bpr_shd.g_old_rec.business_group_id
511: ,p_bpr_attribute_category_o =>ben_bpr_shd.g_old_rec.bpr_attribute_category
512: ,p_bpr_attribute1_o =>ben_bpr_shd.g_old_rec.bpr_attribute1
513: ,p_bpr_attribute2_o =>ben_bpr_shd.g_old_rec.bpr_attribute2
506: ,p_crs_rlovr_procg_cd_o =>ben_bpr_shd.g_old_rec.crs_rlovr_procg_cd
507: ,p_mx_pct_ttl_crs_cn_roll_num_o =>ben_bpr_shd.g_old_rec.mx_pct_ttl_crs_cn_roll_num
508: ,p_bnft_prvdr_pool_id_o =>ben_bpr_shd.g_old_rec.bnft_prvdr_pool_id
509: ,p_acty_base_rt_id_o =>ben_bpr_shd.g_old_rec.acty_base_rt_id
510: ,p_business_group_id_o =>ben_bpr_shd.g_old_rec.business_group_id
511: ,p_bpr_attribute_category_o =>ben_bpr_shd.g_old_rec.bpr_attribute_category
512: ,p_bpr_attribute1_o =>ben_bpr_shd.g_old_rec.bpr_attribute1
513: ,p_bpr_attribute2_o =>ben_bpr_shd.g_old_rec.bpr_attribute2
514: ,p_bpr_attribute3_o =>ben_bpr_shd.g_old_rec.bpr_attribute3
507: ,p_mx_pct_ttl_crs_cn_roll_num_o =>ben_bpr_shd.g_old_rec.mx_pct_ttl_crs_cn_roll_num
508: ,p_bnft_prvdr_pool_id_o =>ben_bpr_shd.g_old_rec.bnft_prvdr_pool_id
509: ,p_acty_base_rt_id_o =>ben_bpr_shd.g_old_rec.acty_base_rt_id
510: ,p_business_group_id_o =>ben_bpr_shd.g_old_rec.business_group_id
511: ,p_bpr_attribute_category_o =>ben_bpr_shd.g_old_rec.bpr_attribute_category
512: ,p_bpr_attribute1_o =>ben_bpr_shd.g_old_rec.bpr_attribute1
513: ,p_bpr_attribute2_o =>ben_bpr_shd.g_old_rec.bpr_attribute2
514: ,p_bpr_attribute3_o =>ben_bpr_shd.g_old_rec.bpr_attribute3
515: ,p_bpr_attribute4_o =>ben_bpr_shd.g_old_rec.bpr_attribute4
508: ,p_bnft_prvdr_pool_id_o =>ben_bpr_shd.g_old_rec.bnft_prvdr_pool_id
509: ,p_acty_base_rt_id_o =>ben_bpr_shd.g_old_rec.acty_base_rt_id
510: ,p_business_group_id_o =>ben_bpr_shd.g_old_rec.business_group_id
511: ,p_bpr_attribute_category_o =>ben_bpr_shd.g_old_rec.bpr_attribute_category
512: ,p_bpr_attribute1_o =>ben_bpr_shd.g_old_rec.bpr_attribute1
513: ,p_bpr_attribute2_o =>ben_bpr_shd.g_old_rec.bpr_attribute2
514: ,p_bpr_attribute3_o =>ben_bpr_shd.g_old_rec.bpr_attribute3
515: ,p_bpr_attribute4_o =>ben_bpr_shd.g_old_rec.bpr_attribute4
516: ,p_bpr_attribute5_o =>ben_bpr_shd.g_old_rec.bpr_attribute5
509: ,p_acty_base_rt_id_o =>ben_bpr_shd.g_old_rec.acty_base_rt_id
510: ,p_business_group_id_o =>ben_bpr_shd.g_old_rec.business_group_id
511: ,p_bpr_attribute_category_o =>ben_bpr_shd.g_old_rec.bpr_attribute_category
512: ,p_bpr_attribute1_o =>ben_bpr_shd.g_old_rec.bpr_attribute1
513: ,p_bpr_attribute2_o =>ben_bpr_shd.g_old_rec.bpr_attribute2
514: ,p_bpr_attribute3_o =>ben_bpr_shd.g_old_rec.bpr_attribute3
515: ,p_bpr_attribute4_o =>ben_bpr_shd.g_old_rec.bpr_attribute4
516: ,p_bpr_attribute5_o =>ben_bpr_shd.g_old_rec.bpr_attribute5
517: ,p_bpr_attribute6_o =>ben_bpr_shd.g_old_rec.bpr_attribute6
510: ,p_business_group_id_o =>ben_bpr_shd.g_old_rec.business_group_id
511: ,p_bpr_attribute_category_o =>ben_bpr_shd.g_old_rec.bpr_attribute_category
512: ,p_bpr_attribute1_o =>ben_bpr_shd.g_old_rec.bpr_attribute1
513: ,p_bpr_attribute2_o =>ben_bpr_shd.g_old_rec.bpr_attribute2
514: ,p_bpr_attribute3_o =>ben_bpr_shd.g_old_rec.bpr_attribute3
515: ,p_bpr_attribute4_o =>ben_bpr_shd.g_old_rec.bpr_attribute4
516: ,p_bpr_attribute5_o =>ben_bpr_shd.g_old_rec.bpr_attribute5
517: ,p_bpr_attribute6_o =>ben_bpr_shd.g_old_rec.bpr_attribute6
518: ,p_bpr_attribute7_o =>ben_bpr_shd.g_old_rec.bpr_attribute7
511: ,p_bpr_attribute_category_o =>ben_bpr_shd.g_old_rec.bpr_attribute_category
512: ,p_bpr_attribute1_o =>ben_bpr_shd.g_old_rec.bpr_attribute1
513: ,p_bpr_attribute2_o =>ben_bpr_shd.g_old_rec.bpr_attribute2
514: ,p_bpr_attribute3_o =>ben_bpr_shd.g_old_rec.bpr_attribute3
515: ,p_bpr_attribute4_o =>ben_bpr_shd.g_old_rec.bpr_attribute4
516: ,p_bpr_attribute5_o =>ben_bpr_shd.g_old_rec.bpr_attribute5
517: ,p_bpr_attribute6_o =>ben_bpr_shd.g_old_rec.bpr_attribute6
518: ,p_bpr_attribute7_o =>ben_bpr_shd.g_old_rec.bpr_attribute7
519: ,p_bpr_attribute8_o =>ben_bpr_shd.g_old_rec.bpr_attribute8
512: ,p_bpr_attribute1_o =>ben_bpr_shd.g_old_rec.bpr_attribute1
513: ,p_bpr_attribute2_o =>ben_bpr_shd.g_old_rec.bpr_attribute2
514: ,p_bpr_attribute3_o =>ben_bpr_shd.g_old_rec.bpr_attribute3
515: ,p_bpr_attribute4_o =>ben_bpr_shd.g_old_rec.bpr_attribute4
516: ,p_bpr_attribute5_o =>ben_bpr_shd.g_old_rec.bpr_attribute5
517: ,p_bpr_attribute6_o =>ben_bpr_shd.g_old_rec.bpr_attribute6
518: ,p_bpr_attribute7_o =>ben_bpr_shd.g_old_rec.bpr_attribute7
519: ,p_bpr_attribute8_o =>ben_bpr_shd.g_old_rec.bpr_attribute8
520: ,p_bpr_attribute9_o =>ben_bpr_shd.g_old_rec.bpr_attribute9
513: ,p_bpr_attribute2_o =>ben_bpr_shd.g_old_rec.bpr_attribute2
514: ,p_bpr_attribute3_o =>ben_bpr_shd.g_old_rec.bpr_attribute3
515: ,p_bpr_attribute4_o =>ben_bpr_shd.g_old_rec.bpr_attribute4
516: ,p_bpr_attribute5_o =>ben_bpr_shd.g_old_rec.bpr_attribute5
517: ,p_bpr_attribute6_o =>ben_bpr_shd.g_old_rec.bpr_attribute6
518: ,p_bpr_attribute7_o =>ben_bpr_shd.g_old_rec.bpr_attribute7
519: ,p_bpr_attribute8_o =>ben_bpr_shd.g_old_rec.bpr_attribute8
520: ,p_bpr_attribute9_o =>ben_bpr_shd.g_old_rec.bpr_attribute9
521: ,p_bpr_attribute10_o =>ben_bpr_shd.g_old_rec.bpr_attribute10
514: ,p_bpr_attribute3_o =>ben_bpr_shd.g_old_rec.bpr_attribute3
515: ,p_bpr_attribute4_o =>ben_bpr_shd.g_old_rec.bpr_attribute4
516: ,p_bpr_attribute5_o =>ben_bpr_shd.g_old_rec.bpr_attribute5
517: ,p_bpr_attribute6_o =>ben_bpr_shd.g_old_rec.bpr_attribute6
518: ,p_bpr_attribute7_o =>ben_bpr_shd.g_old_rec.bpr_attribute7
519: ,p_bpr_attribute8_o =>ben_bpr_shd.g_old_rec.bpr_attribute8
520: ,p_bpr_attribute9_o =>ben_bpr_shd.g_old_rec.bpr_attribute9
521: ,p_bpr_attribute10_o =>ben_bpr_shd.g_old_rec.bpr_attribute10
522: ,p_bpr_attribute11_o =>ben_bpr_shd.g_old_rec.bpr_attribute11
515: ,p_bpr_attribute4_o =>ben_bpr_shd.g_old_rec.bpr_attribute4
516: ,p_bpr_attribute5_o =>ben_bpr_shd.g_old_rec.bpr_attribute5
517: ,p_bpr_attribute6_o =>ben_bpr_shd.g_old_rec.bpr_attribute6
518: ,p_bpr_attribute7_o =>ben_bpr_shd.g_old_rec.bpr_attribute7
519: ,p_bpr_attribute8_o =>ben_bpr_shd.g_old_rec.bpr_attribute8
520: ,p_bpr_attribute9_o =>ben_bpr_shd.g_old_rec.bpr_attribute9
521: ,p_bpr_attribute10_o =>ben_bpr_shd.g_old_rec.bpr_attribute10
522: ,p_bpr_attribute11_o =>ben_bpr_shd.g_old_rec.bpr_attribute11
523: ,p_bpr_attribute12_o =>ben_bpr_shd.g_old_rec.bpr_attribute12
516: ,p_bpr_attribute5_o =>ben_bpr_shd.g_old_rec.bpr_attribute5
517: ,p_bpr_attribute6_o =>ben_bpr_shd.g_old_rec.bpr_attribute6
518: ,p_bpr_attribute7_o =>ben_bpr_shd.g_old_rec.bpr_attribute7
519: ,p_bpr_attribute8_o =>ben_bpr_shd.g_old_rec.bpr_attribute8
520: ,p_bpr_attribute9_o =>ben_bpr_shd.g_old_rec.bpr_attribute9
521: ,p_bpr_attribute10_o =>ben_bpr_shd.g_old_rec.bpr_attribute10
522: ,p_bpr_attribute11_o =>ben_bpr_shd.g_old_rec.bpr_attribute11
523: ,p_bpr_attribute12_o =>ben_bpr_shd.g_old_rec.bpr_attribute12
524: ,p_bpr_attribute13_o =>ben_bpr_shd.g_old_rec.bpr_attribute13
517: ,p_bpr_attribute6_o =>ben_bpr_shd.g_old_rec.bpr_attribute6
518: ,p_bpr_attribute7_o =>ben_bpr_shd.g_old_rec.bpr_attribute7
519: ,p_bpr_attribute8_o =>ben_bpr_shd.g_old_rec.bpr_attribute8
520: ,p_bpr_attribute9_o =>ben_bpr_shd.g_old_rec.bpr_attribute9
521: ,p_bpr_attribute10_o =>ben_bpr_shd.g_old_rec.bpr_attribute10
522: ,p_bpr_attribute11_o =>ben_bpr_shd.g_old_rec.bpr_attribute11
523: ,p_bpr_attribute12_o =>ben_bpr_shd.g_old_rec.bpr_attribute12
524: ,p_bpr_attribute13_o =>ben_bpr_shd.g_old_rec.bpr_attribute13
525: ,p_bpr_attribute14_o =>ben_bpr_shd.g_old_rec.bpr_attribute14
518: ,p_bpr_attribute7_o =>ben_bpr_shd.g_old_rec.bpr_attribute7
519: ,p_bpr_attribute8_o =>ben_bpr_shd.g_old_rec.bpr_attribute8
520: ,p_bpr_attribute9_o =>ben_bpr_shd.g_old_rec.bpr_attribute9
521: ,p_bpr_attribute10_o =>ben_bpr_shd.g_old_rec.bpr_attribute10
522: ,p_bpr_attribute11_o =>ben_bpr_shd.g_old_rec.bpr_attribute11
523: ,p_bpr_attribute12_o =>ben_bpr_shd.g_old_rec.bpr_attribute12
524: ,p_bpr_attribute13_o =>ben_bpr_shd.g_old_rec.bpr_attribute13
525: ,p_bpr_attribute14_o =>ben_bpr_shd.g_old_rec.bpr_attribute14
526: ,p_bpr_attribute15_o =>ben_bpr_shd.g_old_rec.bpr_attribute15
519: ,p_bpr_attribute8_o =>ben_bpr_shd.g_old_rec.bpr_attribute8
520: ,p_bpr_attribute9_o =>ben_bpr_shd.g_old_rec.bpr_attribute9
521: ,p_bpr_attribute10_o =>ben_bpr_shd.g_old_rec.bpr_attribute10
522: ,p_bpr_attribute11_o =>ben_bpr_shd.g_old_rec.bpr_attribute11
523: ,p_bpr_attribute12_o =>ben_bpr_shd.g_old_rec.bpr_attribute12
524: ,p_bpr_attribute13_o =>ben_bpr_shd.g_old_rec.bpr_attribute13
525: ,p_bpr_attribute14_o =>ben_bpr_shd.g_old_rec.bpr_attribute14
526: ,p_bpr_attribute15_o =>ben_bpr_shd.g_old_rec.bpr_attribute15
527: ,p_bpr_attribute16_o =>ben_bpr_shd.g_old_rec.bpr_attribute16
520: ,p_bpr_attribute9_o =>ben_bpr_shd.g_old_rec.bpr_attribute9
521: ,p_bpr_attribute10_o =>ben_bpr_shd.g_old_rec.bpr_attribute10
522: ,p_bpr_attribute11_o =>ben_bpr_shd.g_old_rec.bpr_attribute11
523: ,p_bpr_attribute12_o =>ben_bpr_shd.g_old_rec.bpr_attribute12
524: ,p_bpr_attribute13_o =>ben_bpr_shd.g_old_rec.bpr_attribute13
525: ,p_bpr_attribute14_o =>ben_bpr_shd.g_old_rec.bpr_attribute14
526: ,p_bpr_attribute15_o =>ben_bpr_shd.g_old_rec.bpr_attribute15
527: ,p_bpr_attribute16_o =>ben_bpr_shd.g_old_rec.bpr_attribute16
528: ,p_bpr_attribute17_o =>ben_bpr_shd.g_old_rec.bpr_attribute17
521: ,p_bpr_attribute10_o =>ben_bpr_shd.g_old_rec.bpr_attribute10
522: ,p_bpr_attribute11_o =>ben_bpr_shd.g_old_rec.bpr_attribute11
523: ,p_bpr_attribute12_o =>ben_bpr_shd.g_old_rec.bpr_attribute12
524: ,p_bpr_attribute13_o =>ben_bpr_shd.g_old_rec.bpr_attribute13
525: ,p_bpr_attribute14_o =>ben_bpr_shd.g_old_rec.bpr_attribute14
526: ,p_bpr_attribute15_o =>ben_bpr_shd.g_old_rec.bpr_attribute15
527: ,p_bpr_attribute16_o =>ben_bpr_shd.g_old_rec.bpr_attribute16
528: ,p_bpr_attribute17_o =>ben_bpr_shd.g_old_rec.bpr_attribute17
529: ,p_bpr_attribute18_o =>ben_bpr_shd.g_old_rec.bpr_attribute18
522: ,p_bpr_attribute11_o =>ben_bpr_shd.g_old_rec.bpr_attribute11
523: ,p_bpr_attribute12_o =>ben_bpr_shd.g_old_rec.bpr_attribute12
524: ,p_bpr_attribute13_o =>ben_bpr_shd.g_old_rec.bpr_attribute13
525: ,p_bpr_attribute14_o =>ben_bpr_shd.g_old_rec.bpr_attribute14
526: ,p_bpr_attribute15_o =>ben_bpr_shd.g_old_rec.bpr_attribute15
527: ,p_bpr_attribute16_o =>ben_bpr_shd.g_old_rec.bpr_attribute16
528: ,p_bpr_attribute17_o =>ben_bpr_shd.g_old_rec.bpr_attribute17
529: ,p_bpr_attribute18_o =>ben_bpr_shd.g_old_rec.bpr_attribute18
530: ,p_bpr_attribute19_o =>ben_bpr_shd.g_old_rec.bpr_attribute19
523: ,p_bpr_attribute12_o =>ben_bpr_shd.g_old_rec.bpr_attribute12
524: ,p_bpr_attribute13_o =>ben_bpr_shd.g_old_rec.bpr_attribute13
525: ,p_bpr_attribute14_o =>ben_bpr_shd.g_old_rec.bpr_attribute14
526: ,p_bpr_attribute15_o =>ben_bpr_shd.g_old_rec.bpr_attribute15
527: ,p_bpr_attribute16_o =>ben_bpr_shd.g_old_rec.bpr_attribute16
528: ,p_bpr_attribute17_o =>ben_bpr_shd.g_old_rec.bpr_attribute17
529: ,p_bpr_attribute18_o =>ben_bpr_shd.g_old_rec.bpr_attribute18
530: ,p_bpr_attribute19_o =>ben_bpr_shd.g_old_rec.bpr_attribute19
531: ,p_bpr_attribute20_o =>ben_bpr_shd.g_old_rec.bpr_attribute20
524: ,p_bpr_attribute13_o =>ben_bpr_shd.g_old_rec.bpr_attribute13
525: ,p_bpr_attribute14_o =>ben_bpr_shd.g_old_rec.bpr_attribute14
526: ,p_bpr_attribute15_o =>ben_bpr_shd.g_old_rec.bpr_attribute15
527: ,p_bpr_attribute16_o =>ben_bpr_shd.g_old_rec.bpr_attribute16
528: ,p_bpr_attribute17_o =>ben_bpr_shd.g_old_rec.bpr_attribute17
529: ,p_bpr_attribute18_o =>ben_bpr_shd.g_old_rec.bpr_attribute18
530: ,p_bpr_attribute19_o =>ben_bpr_shd.g_old_rec.bpr_attribute19
531: ,p_bpr_attribute20_o =>ben_bpr_shd.g_old_rec.bpr_attribute20
532: ,p_bpr_attribute21_o =>ben_bpr_shd.g_old_rec.bpr_attribute21
525: ,p_bpr_attribute14_o =>ben_bpr_shd.g_old_rec.bpr_attribute14
526: ,p_bpr_attribute15_o =>ben_bpr_shd.g_old_rec.bpr_attribute15
527: ,p_bpr_attribute16_o =>ben_bpr_shd.g_old_rec.bpr_attribute16
528: ,p_bpr_attribute17_o =>ben_bpr_shd.g_old_rec.bpr_attribute17
529: ,p_bpr_attribute18_o =>ben_bpr_shd.g_old_rec.bpr_attribute18
530: ,p_bpr_attribute19_o =>ben_bpr_shd.g_old_rec.bpr_attribute19
531: ,p_bpr_attribute20_o =>ben_bpr_shd.g_old_rec.bpr_attribute20
532: ,p_bpr_attribute21_o =>ben_bpr_shd.g_old_rec.bpr_attribute21
533: ,p_bpr_attribute22_o =>ben_bpr_shd.g_old_rec.bpr_attribute22
526: ,p_bpr_attribute15_o =>ben_bpr_shd.g_old_rec.bpr_attribute15
527: ,p_bpr_attribute16_o =>ben_bpr_shd.g_old_rec.bpr_attribute16
528: ,p_bpr_attribute17_o =>ben_bpr_shd.g_old_rec.bpr_attribute17
529: ,p_bpr_attribute18_o =>ben_bpr_shd.g_old_rec.bpr_attribute18
530: ,p_bpr_attribute19_o =>ben_bpr_shd.g_old_rec.bpr_attribute19
531: ,p_bpr_attribute20_o =>ben_bpr_shd.g_old_rec.bpr_attribute20
532: ,p_bpr_attribute21_o =>ben_bpr_shd.g_old_rec.bpr_attribute21
533: ,p_bpr_attribute22_o =>ben_bpr_shd.g_old_rec.bpr_attribute22
534: ,p_bpr_attribute23_o =>ben_bpr_shd.g_old_rec.bpr_attribute23
527: ,p_bpr_attribute16_o =>ben_bpr_shd.g_old_rec.bpr_attribute16
528: ,p_bpr_attribute17_o =>ben_bpr_shd.g_old_rec.bpr_attribute17
529: ,p_bpr_attribute18_o =>ben_bpr_shd.g_old_rec.bpr_attribute18
530: ,p_bpr_attribute19_o =>ben_bpr_shd.g_old_rec.bpr_attribute19
531: ,p_bpr_attribute20_o =>ben_bpr_shd.g_old_rec.bpr_attribute20
532: ,p_bpr_attribute21_o =>ben_bpr_shd.g_old_rec.bpr_attribute21
533: ,p_bpr_attribute22_o =>ben_bpr_shd.g_old_rec.bpr_attribute22
534: ,p_bpr_attribute23_o =>ben_bpr_shd.g_old_rec.bpr_attribute23
535: ,p_bpr_attribute24_o =>ben_bpr_shd.g_old_rec.bpr_attribute24
528: ,p_bpr_attribute17_o =>ben_bpr_shd.g_old_rec.bpr_attribute17
529: ,p_bpr_attribute18_o =>ben_bpr_shd.g_old_rec.bpr_attribute18
530: ,p_bpr_attribute19_o =>ben_bpr_shd.g_old_rec.bpr_attribute19
531: ,p_bpr_attribute20_o =>ben_bpr_shd.g_old_rec.bpr_attribute20
532: ,p_bpr_attribute21_o =>ben_bpr_shd.g_old_rec.bpr_attribute21
533: ,p_bpr_attribute22_o =>ben_bpr_shd.g_old_rec.bpr_attribute22
534: ,p_bpr_attribute23_o =>ben_bpr_shd.g_old_rec.bpr_attribute23
535: ,p_bpr_attribute24_o =>ben_bpr_shd.g_old_rec.bpr_attribute24
536: ,p_bpr_attribute25_o =>ben_bpr_shd.g_old_rec.bpr_attribute25
529: ,p_bpr_attribute18_o =>ben_bpr_shd.g_old_rec.bpr_attribute18
530: ,p_bpr_attribute19_o =>ben_bpr_shd.g_old_rec.bpr_attribute19
531: ,p_bpr_attribute20_o =>ben_bpr_shd.g_old_rec.bpr_attribute20
532: ,p_bpr_attribute21_o =>ben_bpr_shd.g_old_rec.bpr_attribute21
533: ,p_bpr_attribute22_o =>ben_bpr_shd.g_old_rec.bpr_attribute22
534: ,p_bpr_attribute23_o =>ben_bpr_shd.g_old_rec.bpr_attribute23
535: ,p_bpr_attribute24_o =>ben_bpr_shd.g_old_rec.bpr_attribute24
536: ,p_bpr_attribute25_o =>ben_bpr_shd.g_old_rec.bpr_attribute25
537: ,p_bpr_attribute26_o =>ben_bpr_shd.g_old_rec.bpr_attribute26
530: ,p_bpr_attribute19_o =>ben_bpr_shd.g_old_rec.bpr_attribute19
531: ,p_bpr_attribute20_o =>ben_bpr_shd.g_old_rec.bpr_attribute20
532: ,p_bpr_attribute21_o =>ben_bpr_shd.g_old_rec.bpr_attribute21
533: ,p_bpr_attribute22_o =>ben_bpr_shd.g_old_rec.bpr_attribute22
534: ,p_bpr_attribute23_o =>ben_bpr_shd.g_old_rec.bpr_attribute23
535: ,p_bpr_attribute24_o =>ben_bpr_shd.g_old_rec.bpr_attribute24
536: ,p_bpr_attribute25_o =>ben_bpr_shd.g_old_rec.bpr_attribute25
537: ,p_bpr_attribute26_o =>ben_bpr_shd.g_old_rec.bpr_attribute26
538: ,p_bpr_attribute27_o =>ben_bpr_shd.g_old_rec.bpr_attribute27
531: ,p_bpr_attribute20_o =>ben_bpr_shd.g_old_rec.bpr_attribute20
532: ,p_bpr_attribute21_o =>ben_bpr_shd.g_old_rec.bpr_attribute21
533: ,p_bpr_attribute22_o =>ben_bpr_shd.g_old_rec.bpr_attribute22
534: ,p_bpr_attribute23_o =>ben_bpr_shd.g_old_rec.bpr_attribute23
535: ,p_bpr_attribute24_o =>ben_bpr_shd.g_old_rec.bpr_attribute24
536: ,p_bpr_attribute25_o =>ben_bpr_shd.g_old_rec.bpr_attribute25
537: ,p_bpr_attribute26_o =>ben_bpr_shd.g_old_rec.bpr_attribute26
538: ,p_bpr_attribute27_o =>ben_bpr_shd.g_old_rec.bpr_attribute27
539: ,p_bpr_attribute28_o =>ben_bpr_shd.g_old_rec.bpr_attribute28
532: ,p_bpr_attribute21_o =>ben_bpr_shd.g_old_rec.bpr_attribute21
533: ,p_bpr_attribute22_o =>ben_bpr_shd.g_old_rec.bpr_attribute22
534: ,p_bpr_attribute23_o =>ben_bpr_shd.g_old_rec.bpr_attribute23
535: ,p_bpr_attribute24_o =>ben_bpr_shd.g_old_rec.bpr_attribute24
536: ,p_bpr_attribute25_o =>ben_bpr_shd.g_old_rec.bpr_attribute25
537: ,p_bpr_attribute26_o =>ben_bpr_shd.g_old_rec.bpr_attribute26
538: ,p_bpr_attribute27_o =>ben_bpr_shd.g_old_rec.bpr_attribute27
539: ,p_bpr_attribute28_o =>ben_bpr_shd.g_old_rec.bpr_attribute28
540: ,p_bpr_attribute29_o =>ben_bpr_shd.g_old_rec.bpr_attribute29
533: ,p_bpr_attribute22_o =>ben_bpr_shd.g_old_rec.bpr_attribute22
534: ,p_bpr_attribute23_o =>ben_bpr_shd.g_old_rec.bpr_attribute23
535: ,p_bpr_attribute24_o =>ben_bpr_shd.g_old_rec.bpr_attribute24
536: ,p_bpr_attribute25_o =>ben_bpr_shd.g_old_rec.bpr_attribute25
537: ,p_bpr_attribute26_o =>ben_bpr_shd.g_old_rec.bpr_attribute26
538: ,p_bpr_attribute27_o =>ben_bpr_shd.g_old_rec.bpr_attribute27
539: ,p_bpr_attribute28_o =>ben_bpr_shd.g_old_rec.bpr_attribute28
540: ,p_bpr_attribute29_o =>ben_bpr_shd.g_old_rec.bpr_attribute29
541: ,p_bpr_attribute30_o =>ben_bpr_shd.g_old_rec.bpr_attribute30
534: ,p_bpr_attribute23_o =>ben_bpr_shd.g_old_rec.bpr_attribute23
535: ,p_bpr_attribute24_o =>ben_bpr_shd.g_old_rec.bpr_attribute24
536: ,p_bpr_attribute25_o =>ben_bpr_shd.g_old_rec.bpr_attribute25
537: ,p_bpr_attribute26_o =>ben_bpr_shd.g_old_rec.bpr_attribute26
538: ,p_bpr_attribute27_o =>ben_bpr_shd.g_old_rec.bpr_attribute27
539: ,p_bpr_attribute28_o =>ben_bpr_shd.g_old_rec.bpr_attribute28
540: ,p_bpr_attribute29_o =>ben_bpr_shd.g_old_rec.bpr_attribute29
541: ,p_bpr_attribute30_o =>ben_bpr_shd.g_old_rec.bpr_attribute30
542: ,p_object_version_number_o =>ben_bpr_shd.g_old_rec.object_version_number
535: ,p_bpr_attribute24_o =>ben_bpr_shd.g_old_rec.bpr_attribute24
536: ,p_bpr_attribute25_o =>ben_bpr_shd.g_old_rec.bpr_attribute25
537: ,p_bpr_attribute26_o =>ben_bpr_shd.g_old_rec.bpr_attribute26
538: ,p_bpr_attribute27_o =>ben_bpr_shd.g_old_rec.bpr_attribute27
539: ,p_bpr_attribute28_o =>ben_bpr_shd.g_old_rec.bpr_attribute28
540: ,p_bpr_attribute29_o =>ben_bpr_shd.g_old_rec.bpr_attribute29
541: ,p_bpr_attribute30_o =>ben_bpr_shd.g_old_rec.bpr_attribute30
542: ,p_object_version_number_o =>ben_bpr_shd.g_old_rec.object_version_number
543: );
536: ,p_bpr_attribute25_o =>ben_bpr_shd.g_old_rec.bpr_attribute25
537: ,p_bpr_attribute26_o =>ben_bpr_shd.g_old_rec.bpr_attribute26
538: ,p_bpr_attribute27_o =>ben_bpr_shd.g_old_rec.bpr_attribute27
539: ,p_bpr_attribute28_o =>ben_bpr_shd.g_old_rec.bpr_attribute28
540: ,p_bpr_attribute29_o =>ben_bpr_shd.g_old_rec.bpr_attribute29
541: ,p_bpr_attribute30_o =>ben_bpr_shd.g_old_rec.bpr_attribute30
542: ,p_object_version_number_o =>ben_bpr_shd.g_old_rec.object_version_number
543: );
544: --
537: ,p_bpr_attribute26_o =>ben_bpr_shd.g_old_rec.bpr_attribute26
538: ,p_bpr_attribute27_o =>ben_bpr_shd.g_old_rec.bpr_attribute27
539: ,p_bpr_attribute28_o =>ben_bpr_shd.g_old_rec.bpr_attribute28
540: ,p_bpr_attribute29_o =>ben_bpr_shd.g_old_rec.bpr_attribute29
541: ,p_bpr_attribute30_o =>ben_bpr_shd.g_old_rec.bpr_attribute30
542: ,p_object_version_number_o =>ben_bpr_shd.g_old_rec.object_version_number
543: );
544: --
545: exception
538: ,p_bpr_attribute27_o =>ben_bpr_shd.g_old_rec.bpr_attribute27
539: ,p_bpr_attribute28_o =>ben_bpr_shd.g_old_rec.bpr_attribute28
540: ,p_bpr_attribute29_o =>ben_bpr_shd.g_old_rec.bpr_attribute29
541: ,p_bpr_attribute30_o =>ben_bpr_shd.g_old_rec.bpr_attribute30
542: ,p_object_version_number_o =>ben_bpr_shd.g_old_rec.object_version_number
543: );
544: --
545: exception
546: --
600: -- Internal Row Handler Use Only.
601: --
602: -- {End Of Comments}
603: -- ----------------------------------------------------------------------------
604: Procedure convert_defs(p_rec in out nocopy ben_bpr_shd.g_rec_type) is
605: --
606: l_proc varchar2(72) := g_package||'convert_defs';
607: --
608: Begin
615: -- is being used then we must set to the 'current' argument value.
616: --
617: If (p_rec.no_mn_rlovr_pct_dfnd_flag = hr_api.g_varchar2) then
618: p_rec.no_mn_rlovr_pct_dfnd_flag :=
619: ben_bpr_shd.g_old_rec.no_mn_rlovr_pct_dfnd_flag;
620: End If;
621: If (p_rec.no_mx_rlovr_pct_dfnd_flag = hr_api.g_varchar2) then
622: p_rec.no_mx_rlovr_pct_dfnd_flag :=
623: ben_bpr_shd.g_old_rec.no_mx_rlovr_pct_dfnd_flag;
619: ben_bpr_shd.g_old_rec.no_mn_rlovr_pct_dfnd_flag;
620: End If;
621: If (p_rec.no_mx_rlovr_pct_dfnd_flag = hr_api.g_varchar2) then
622: p_rec.no_mx_rlovr_pct_dfnd_flag :=
623: ben_bpr_shd.g_old_rec.no_mx_rlovr_pct_dfnd_flag;
624: End If;
625: If (p_rec.no_mn_rlovr_val_dfnd_flag = hr_api.g_varchar2) then
626: p_rec.no_mn_rlovr_val_dfnd_flag :=
627: ben_bpr_shd.g_old_rec.no_mn_rlovr_val_dfnd_flag;
623: ben_bpr_shd.g_old_rec.no_mx_rlovr_pct_dfnd_flag;
624: End If;
625: If (p_rec.no_mn_rlovr_val_dfnd_flag = hr_api.g_varchar2) then
626: p_rec.no_mn_rlovr_val_dfnd_flag :=
627: ben_bpr_shd.g_old_rec.no_mn_rlovr_val_dfnd_flag;
628: End If;
629: If (p_rec.no_mx_rlovr_val_dfnd_flag = hr_api.g_varchar2) then
630: p_rec.no_mx_rlovr_val_dfnd_flag :=
631: ben_bpr_shd.g_old_rec.no_mx_rlovr_val_dfnd_flag;
627: ben_bpr_shd.g_old_rec.no_mn_rlovr_val_dfnd_flag;
628: End If;
629: If (p_rec.no_mx_rlovr_val_dfnd_flag = hr_api.g_varchar2) then
630: p_rec.no_mx_rlovr_val_dfnd_flag :=
631: ben_bpr_shd.g_old_rec.no_mx_rlovr_val_dfnd_flag;
632: End If;
633: If (p_rec.rlovr_val_incrmt_num = hr_api.g_number) then
634: p_rec.rlovr_val_incrmt_num :=
635: ben_bpr_shd.g_old_rec.rlovr_val_incrmt_num;
631: ben_bpr_shd.g_old_rec.no_mx_rlovr_val_dfnd_flag;
632: End If;
633: If (p_rec.rlovr_val_incrmt_num = hr_api.g_number) then
634: p_rec.rlovr_val_incrmt_num :=
635: ben_bpr_shd.g_old_rec.rlovr_val_incrmt_num;
636: End If;
637: If (p_rec.rlovr_val_rl = hr_api.g_number) then
638: p_rec.rlovr_val_rl :=
639: ben_bpr_shd.g_old_rec.rlovr_val_rl;
635: ben_bpr_shd.g_old_rec.rlovr_val_incrmt_num;
636: End If;
637: If (p_rec.rlovr_val_rl = hr_api.g_number) then
638: p_rec.rlovr_val_rl :=
639: ben_bpr_shd.g_old_rec.rlovr_val_rl;
640: End If;
641: If (p_rec.mn_rlovr_val = hr_api.g_number) then
642: p_rec.mn_rlovr_val :=
643: ben_bpr_shd.g_old_rec.mn_rlovr_val;
639: ben_bpr_shd.g_old_rec.rlovr_val_rl;
640: End If;
641: If (p_rec.mn_rlovr_val = hr_api.g_number) then
642: p_rec.mn_rlovr_val :=
643: ben_bpr_shd.g_old_rec.mn_rlovr_val;
644: End If;
645: If (p_rec.mx_rlovr_val = hr_api.g_number) then
646: p_rec.mx_rlovr_val :=
647: ben_bpr_shd.g_old_rec.mx_rlovr_val;
643: ben_bpr_shd.g_old_rec.mn_rlovr_val;
644: End If;
645: If (p_rec.mx_rlovr_val = hr_api.g_number) then
646: p_rec.mx_rlovr_val :=
647: ben_bpr_shd.g_old_rec.mx_rlovr_val;
648: End If;
649: If (p_rec.val_rndg_cd = hr_api.g_varchar2) then
650: p_rec.val_rndg_cd :=
651: ben_bpr_shd.g_old_rec.val_rndg_cd;
647: ben_bpr_shd.g_old_rec.mx_rlovr_val;
648: End If;
649: If (p_rec.val_rndg_cd = hr_api.g_varchar2) then
650: p_rec.val_rndg_cd :=
651: ben_bpr_shd.g_old_rec.val_rndg_cd;
652: End If;
653: If (p_rec.val_rndg_rl = hr_api.g_number) then
654: p_rec.val_rndg_rl :=
655: ben_bpr_shd.g_old_rec.val_rndg_rl;
651: ben_bpr_shd.g_old_rec.val_rndg_cd;
652: End If;
653: If (p_rec.val_rndg_rl = hr_api.g_number) then
654: p_rec.val_rndg_rl :=
655: ben_bpr_shd.g_old_rec.val_rndg_rl;
656: End If;
657: If (p_rec.pct_rndg_cd = hr_api.g_varchar2) then
658: p_rec.pct_rndg_cd :=
659: ben_bpr_shd.g_old_rec.pct_rndg_cd;
655: ben_bpr_shd.g_old_rec.val_rndg_rl;
656: End If;
657: If (p_rec.pct_rndg_cd = hr_api.g_varchar2) then
658: p_rec.pct_rndg_cd :=
659: ben_bpr_shd.g_old_rec.pct_rndg_cd;
660: End If;
661: If (p_rec.pct_rndg_rl = hr_api.g_number) then
662: p_rec.pct_rndg_rl :=
663: ben_bpr_shd.g_old_rec.pct_rndg_rl;
659: ben_bpr_shd.g_old_rec.pct_rndg_cd;
660: End If;
661: If (p_rec.pct_rndg_rl = hr_api.g_number) then
662: p_rec.pct_rndg_rl :=
663: ben_bpr_shd.g_old_rec.pct_rndg_rl;
664: End If;
665: If (p_rec.prtt_elig_rlovr_rl = hr_api.g_number) then
666: p_rec.prtt_elig_rlovr_rl :=
667: ben_bpr_shd.g_old_rec.prtt_elig_rlovr_rl;
663: ben_bpr_shd.g_old_rec.pct_rndg_rl;
664: End If;
665: If (p_rec.prtt_elig_rlovr_rl = hr_api.g_number) then
666: p_rec.prtt_elig_rlovr_rl :=
667: ben_bpr_shd.g_old_rec.prtt_elig_rlovr_rl;
668: End If;
669: If (p_rec.mx_rchd_dflt_ordr_num = hr_api.g_number) then
670: p_rec.mx_rchd_dflt_ordr_num :=
671: ben_bpr_shd.g_old_rec.mx_rchd_dflt_ordr_num;
667: ben_bpr_shd.g_old_rec.prtt_elig_rlovr_rl;
668: End If;
669: If (p_rec.mx_rchd_dflt_ordr_num = hr_api.g_number) then
670: p_rec.mx_rchd_dflt_ordr_num :=
671: ben_bpr_shd.g_old_rec.mx_rchd_dflt_ordr_num;
672: End If;
673: If (p_rec.pct_rlovr_incrmt_num = hr_api.g_number) then
674: p_rec.pct_rlovr_incrmt_num :=
675: ben_bpr_shd.g_old_rec.pct_rlovr_incrmt_num;
671: ben_bpr_shd.g_old_rec.mx_rchd_dflt_ordr_num;
672: End If;
673: If (p_rec.pct_rlovr_incrmt_num = hr_api.g_number) then
674: p_rec.pct_rlovr_incrmt_num :=
675: ben_bpr_shd.g_old_rec.pct_rlovr_incrmt_num;
676: End If;
677: If (p_rec.mn_rlovr_pct_num = hr_api.g_number) then
678: p_rec.mn_rlovr_pct_num :=
679: ben_bpr_shd.g_old_rec.mn_rlovr_pct_num;
675: ben_bpr_shd.g_old_rec.pct_rlovr_incrmt_num;
676: End If;
677: If (p_rec.mn_rlovr_pct_num = hr_api.g_number) then
678: p_rec.mn_rlovr_pct_num :=
679: ben_bpr_shd.g_old_rec.mn_rlovr_pct_num;
680: End If;
681: If (p_rec.mx_rlovr_pct_num = hr_api.g_number) then
682: p_rec.mx_rlovr_pct_num :=
683: ben_bpr_shd.g_old_rec.mx_rlovr_pct_num;
679: ben_bpr_shd.g_old_rec.mn_rlovr_pct_num;
680: End If;
681: If (p_rec.mx_rlovr_pct_num = hr_api.g_number) then
682: p_rec.mx_rlovr_pct_num :=
683: ben_bpr_shd.g_old_rec.mx_rlovr_pct_num;
684: End If;
685: If (p_rec.crs_rlovr_procg_cd = hr_api.g_varchar2) then
686: p_rec.crs_rlovr_procg_cd :=
687: ben_bpr_shd.g_old_rec.crs_rlovr_procg_cd;
683: ben_bpr_shd.g_old_rec.mx_rlovr_pct_num;
684: End If;
685: If (p_rec.crs_rlovr_procg_cd = hr_api.g_varchar2) then
686: p_rec.crs_rlovr_procg_cd :=
687: ben_bpr_shd.g_old_rec.crs_rlovr_procg_cd;
688: End If;
689: If (p_rec.mx_pct_ttl_crs_cn_roll_num = hr_api.g_number) then
690: p_rec.mx_pct_ttl_crs_cn_roll_num :=
691: ben_bpr_shd.g_old_rec.mx_pct_ttl_crs_cn_roll_num;
687: ben_bpr_shd.g_old_rec.crs_rlovr_procg_cd;
688: End If;
689: If (p_rec.mx_pct_ttl_crs_cn_roll_num = hr_api.g_number) then
690: p_rec.mx_pct_ttl_crs_cn_roll_num :=
691: ben_bpr_shd.g_old_rec.mx_pct_ttl_crs_cn_roll_num;
692: End If;
693: If (p_rec.bnft_prvdr_pool_id = hr_api.g_number) then
694: p_rec.bnft_prvdr_pool_id :=
695: ben_bpr_shd.g_old_rec.bnft_prvdr_pool_id;
691: ben_bpr_shd.g_old_rec.mx_pct_ttl_crs_cn_roll_num;
692: End If;
693: If (p_rec.bnft_prvdr_pool_id = hr_api.g_number) then
694: p_rec.bnft_prvdr_pool_id :=
695: ben_bpr_shd.g_old_rec.bnft_prvdr_pool_id;
696: End If;
697: If (p_rec.acty_base_rt_id = hr_api.g_number) then
698: p_rec.acty_base_rt_id :=
699: ben_bpr_shd.g_old_rec.acty_base_rt_id;
695: ben_bpr_shd.g_old_rec.bnft_prvdr_pool_id;
696: End If;
697: If (p_rec.acty_base_rt_id = hr_api.g_number) then
698: p_rec.acty_base_rt_id :=
699: ben_bpr_shd.g_old_rec.acty_base_rt_id;
700: End If;
701: If (p_rec.business_group_id = hr_api.g_number) then
702: p_rec.business_group_id :=
703: ben_bpr_shd.g_old_rec.business_group_id;
699: ben_bpr_shd.g_old_rec.acty_base_rt_id;
700: End If;
701: If (p_rec.business_group_id = hr_api.g_number) then
702: p_rec.business_group_id :=
703: ben_bpr_shd.g_old_rec.business_group_id;
704: End If;
705: If (p_rec.bpr_attribute_category = hr_api.g_varchar2) then
706: p_rec.bpr_attribute_category :=
707: ben_bpr_shd.g_old_rec.bpr_attribute_category;
703: ben_bpr_shd.g_old_rec.business_group_id;
704: End If;
705: If (p_rec.bpr_attribute_category = hr_api.g_varchar2) then
706: p_rec.bpr_attribute_category :=
707: ben_bpr_shd.g_old_rec.bpr_attribute_category;
708: End If;
709: If (p_rec.bpr_attribute1 = hr_api.g_varchar2) then
710: p_rec.bpr_attribute1 :=
711: ben_bpr_shd.g_old_rec.bpr_attribute1;
707: ben_bpr_shd.g_old_rec.bpr_attribute_category;
708: End If;
709: If (p_rec.bpr_attribute1 = hr_api.g_varchar2) then
710: p_rec.bpr_attribute1 :=
711: ben_bpr_shd.g_old_rec.bpr_attribute1;
712: End If;
713: If (p_rec.bpr_attribute2 = hr_api.g_varchar2) then
714: p_rec.bpr_attribute2 :=
715: ben_bpr_shd.g_old_rec.bpr_attribute2;
711: ben_bpr_shd.g_old_rec.bpr_attribute1;
712: End If;
713: If (p_rec.bpr_attribute2 = hr_api.g_varchar2) then
714: p_rec.bpr_attribute2 :=
715: ben_bpr_shd.g_old_rec.bpr_attribute2;
716: End If;
717: If (p_rec.bpr_attribute3 = hr_api.g_varchar2) then
718: p_rec.bpr_attribute3 :=
719: ben_bpr_shd.g_old_rec.bpr_attribute3;
715: ben_bpr_shd.g_old_rec.bpr_attribute2;
716: End If;
717: If (p_rec.bpr_attribute3 = hr_api.g_varchar2) then
718: p_rec.bpr_attribute3 :=
719: ben_bpr_shd.g_old_rec.bpr_attribute3;
720: End If;
721: If (p_rec.bpr_attribute4 = hr_api.g_varchar2) then
722: p_rec.bpr_attribute4 :=
723: ben_bpr_shd.g_old_rec.bpr_attribute4;
719: ben_bpr_shd.g_old_rec.bpr_attribute3;
720: End If;
721: If (p_rec.bpr_attribute4 = hr_api.g_varchar2) then
722: p_rec.bpr_attribute4 :=
723: ben_bpr_shd.g_old_rec.bpr_attribute4;
724: End If;
725: If (p_rec.bpr_attribute5 = hr_api.g_varchar2) then
726: p_rec.bpr_attribute5 :=
727: ben_bpr_shd.g_old_rec.bpr_attribute5;
723: ben_bpr_shd.g_old_rec.bpr_attribute4;
724: End If;
725: If (p_rec.bpr_attribute5 = hr_api.g_varchar2) then
726: p_rec.bpr_attribute5 :=
727: ben_bpr_shd.g_old_rec.bpr_attribute5;
728: End If;
729: If (p_rec.bpr_attribute6 = hr_api.g_varchar2) then
730: p_rec.bpr_attribute6 :=
731: ben_bpr_shd.g_old_rec.bpr_attribute6;
727: ben_bpr_shd.g_old_rec.bpr_attribute5;
728: End If;
729: If (p_rec.bpr_attribute6 = hr_api.g_varchar2) then
730: p_rec.bpr_attribute6 :=
731: ben_bpr_shd.g_old_rec.bpr_attribute6;
732: End If;
733: If (p_rec.bpr_attribute7 = hr_api.g_varchar2) then
734: p_rec.bpr_attribute7 :=
735: ben_bpr_shd.g_old_rec.bpr_attribute7;
731: ben_bpr_shd.g_old_rec.bpr_attribute6;
732: End If;
733: If (p_rec.bpr_attribute7 = hr_api.g_varchar2) then
734: p_rec.bpr_attribute7 :=
735: ben_bpr_shd.g_old_rec.bpr_attribute7;
736: End If;
737: If (p_rec.bpr_attribute8 = hr_api.g_varchar2) then
738: p_rec.bpr_attribute8 :=
739: ben_bpr_shd.g_old_rec.bpr_attribute8;
735: ben_bpr_shd.g_old_rec.bpr_attribute7;
736: End If;
737: If (p_rec.bpr_attribute8 = hr_api.g_varchar2) then
738: p_rec.bpr_attribute8 :=
739: ben_bpr_shd.g_old_rec.bpr_attribute8;
740: End If;
741: If (p_rec.bpr_attribute9 = hr_api.g_varchar2) then
742: p_rec.bpr_attribute9 :=
743: ben_bpr_shd.g_old_rec.bpr_attribute9;
739: ben_bpr_shd.g_old_rec.bpr_attribute8;
740: End If;
741: If (p_rec.bpr_attribute9 = hr_api.g_varchar2) then
742: p_rec.bpr_attribute9 :=
743: ben_bpr_shd.g_old_rec.bpr_attribute9;
744: End If;
745: If (p_rec.bpr_attribute10 = hr_api.g_varchar2) then
746: p_rec.bpr_attribute10 :=
747: ben_bpr_shd.g_old_rec.bpr_attribute10;
743: ben_bpr_shd.g_old_rec.bpr_attribute9;
744: End If;
745: If (p_rec.bpr_attribute10 = hr_api.g_varchar2) then
746: p_rec.bpr_attribute10 :=
747: ben_bpr_shd.g_old_rec.bpr_attribute10;
748: End If;
749: If (p_rec.bpr_attribute11 = hr_api.g_varchar2) then
750: p_rec.bpr_attribute11 :=
751: ben_bpr_shd.g_old_rec.bpr_attribute11;
747: ben_bpr_shd.g_old_rec.bpr_attribute10;
748: End If;
749: If (p_rec.bpr_attribute11 = hr_api.g_varchar2) then
750: p_rec.bpr_attribute11 :=
751: ben_bpr_shd.g_old_rec.bpr_attribute11;
752: End If;
753: If (p_rec.bpr_attribute12 = hr_api.g_varchar2) then
754: p_rec.bpr_attribute12 :=
755: ben_bpr_shd.g_old_rec.bpr_attribute12;
751: ben_bpr_shd.g_old_rec.bpr_attribute11;
752: End If;
753: If (p_rec.bpr_attribute12 = hr_api.g_varchar2) then
754: p_rec.bpr_attribute12 :=
755: ben_bpr_shd.g_old_rec.bpr_attribute12;
756: End If;
757: If (p_rec.bpr_attribute13 = hr_api.g_varchar2) then
758: p_rec.bpr_attribute13 :=
759: ben_bpr_shd.g_old_rec.bpr_attribute13;
755: ben_bpr_shd.g_old_rec.bpr_attribute12;
756: End If;
757: If (p_rec.bpr_attribute13 = hr_api.g_varchar2) then
758: p_rec.bpr_attribute13 :=
759: ben_bpr_shd.g_old_rec.bpr_attribute13;
760: End If;
761: If (p_rec.bpr_attribute14 = hr_api.g_varchar2) then
762: p_rec.bpr_attribute14 :=
763: ben_bpr_shd.g_old_rec.bpr_attribute14;
759: ben_bpr_shd.g_old_rec.bpr_attribute13;
760: End If;
761: If (p_rec.bpr_attribute14 = hr_api.g_varchar2) then
762: p_rec.bpr_attribute14 :=
763: ben_bpr_shd.g_old_rec.bpr_attribute14;
764: End If;
765: If (p_rec.bpr_attribute15 = hr_api.g_varchar2) then
766: p_rec.bpr_attribute15 :=
767: ben_bpr_shd.g_old_rec.bpr_attribute15;
763: ben_bpr_shd.g_old_rec.bpr_attribute14;
764: End If;
765: If (p_rec.bpr_attribute15 = hr_api.g_varchar2) then
766: p_rec.bpr_attribute15 :=
767: ben_bpr_shd.g_old_rec.bpr_attribute15;
768: End If;
769: If (p_rec.bpr_attribute16 = hr_api.g_varchar2) then
770: p_rec.bpr_attribute16 :=
771: ben_bpr_shd.g_old_rec.bpr_attribute16;
767: ben_bpr_shd.g_old_rec.bpr_attribute15;
768: End If;
769: If (p_rec.bpr_attribute16 = hr_api.g_varchar2) then
770: p_rec.bpr_attribute16 :=
771: ben_bpr_shd.g_old_rec.bpr_attribute16;
772: End If;
773: If (p_rec.bpr_attribute17 = hr_api.g_varchar2) then
774: p_rec.bpr_attribute17 :=
775: ben_bpr_shd.g_old_rec.bpr_attribute17;
771: ben_bpr_shd.g_old_rec.bpr_attribute16;
772: End If;
773: If (p_rec.bpr_attribute17 = hr_api.g_varchar2) then
774: p_rec.bpr_attribute17 :=
775: ben_bpr_shd.g_old_rec.bpr_attribute17;
776: End If;
777: If (p_rec.bpr_attribute18 = hr_api.g_varchar2) then
778: p_rec.bpr_attribute18 :=
779: ben_bpr_shd.g_old_rec.bpr_attribute18;
775: ben_bpr_shd.g_old_rec.bpr_attribute17;
776: End If;
777: If (p_rec.bpr_attribute18 = hr_api.g_varchar2) then
778: p_rec.bpr_attribute18 :=
779: ben_bpr_shd.g_old_rec.bpr_attribute18;
780: End If;
781: If (p_rec.bpr_attribute19 = hr_api.g_varchar2) then
782: p_rec.bpr_attribute19 :=
783: ben_bpr_shd.g_old_rec.bpr_attribute19;
779: ben_bpr_shd.g_old_rec.bpr_attribute18;
780: End If;
781: If (p_rec.bpr_attribute19 = hr_api.g_varchar2) then
782: p_rec.bpr_attribute19 :=
783: ben_bpr_shd.g_old_rec.bpr_attribute19;
784: End If;
785: If (p_rec.bpr_attribute20 = hr_api.g_varchar2) then
786: p_rec.bpr_attribute20 :=
787: ben_bpr_shd.g_old_rec.bpr_attribute20;
783: ben_bpr_shd.g_old_rec.bpr_attribute19;
784: End If;
785: If (p_rec.bpr_attribute20 = hr_api.g_varchar2) then
786: p_rec.bpr_attribute20 :=
787: ben_bpr_shd.g_old_rec.bpr_attribute20;
788: End If;
789: If (p_rec.bpr_attribute21 = hr_api.g_varchar2) then
790: p_rec.bpr_attribute21 :=
791: ben_bpr_shd.g_old_rec.bpr_attribute21;
787: ben_bpr_shd.g_old_rec.bpr_attribute20;
788: End If;
789: If (p_rec.bpr_attribute21 = hr_api.g_varchar2) then
790: p_rec.bpr_attribute21 :=
791: ben_bpr_shd.g_old_rec.bpr_attribute21;
792: End If;
793: If (p_rec.bpr_attribute22 = hr_api.g_varchar2) then
794: p_rec.bpr_attribute22 :=
795: ben_bpr_shd.g_old_rec.bpr_attribute22;
791: ben_bpr_shd.g_old_rec.bpr_attribute21;
792: End If;
793: If (p_rec.bpr_attribute22 = hr_api.g_varchar2) then
794: p_rec.bpr_attribute22 :=
795: ben_bpr_shd.g_old_rec.bpr_attribute22;
796: End If;
797: If (p_rec.bpr_attribute23 = hr_api.g_varchar2) then
798: p_rec.bpr_attribute23 :=
799: ben_bpr_shd.g_old_rec.bpr_attribute23;
795: ben_bpr_shd.g_old_rec.bpr_attribute22;
796: End If;
797: If (p_rec.bpr_attribute23 = hr_api.g_varchar2) then
798: p_rec.bpr_attribute23 :=
799: ben_bpr_shd.g_old_rec.bpr_attribute23;
800: End If;
801: If (p_rec.bpr_attribute24 = hr_api.g_varchar2) then
802: p_rec.bpr_attribute24 :=
803: ben_bpr_shd.g_old_rec.bpr_attribute24;
799: ben_bpr_shd.g_old_rec.bpr_attribute23;
800: End If;
801: If (p_rec.bpr_attribute24 = hr_api.g_varchar2) then
802: p_rec.bpr_attribute24 :=
803: ben_bpr_shd.g_old_rec.bpr_attribute24;
804: End If;
805: If (p_rec.bpr_attribute25 = hr_api.g_varchar2) then
806: p_rec.bpr_attribute25 :=
807: ben_bpr_shd.g_old_rec.bpr_attribute25;
803: ben_bpr_shd.g_old_rec.bpr_attribute24;
804: End If;
805: If (p_rec.bpr_attribute25 = hr_api.g_varchar2) then
806: p_rec.bpr_attribute25 :=
807: ben_bpr_shd.g_old_rec.bpr_attribute25;
808: End If;
809: If (p_rec.bpr_attribute26 = hr_api.g_varchar2) then
810: p_rec.bpr_attribute26 :=
811: ben_bpr_shd.g_old_rec.bpr_attribute26;
807: ben_bpr_shd.g_old_rec.bpr_attribute25;
808: End If;
809: If (p_rec.bpr_attribute26 = hr_api.g_varchar2) then
810: p_rec.bpr_attribute26 :=
811: ben_bpr_shd.g_old_rec.bpr_attribute26;
812: End If;
813: If (p_rec.bpr_attribute27 = hr_api.g_varchar2) then
814: p_rec.bpr_attribute27 :=
815: ben_bpr_shd.g_old_rec.bpr_attribute27;
811: ben_bpr_shd.g_old_rec.bpr_attribute26;
812: End If;
813: If (p_rec.bpr_attribute27 = hr_api.g_varchar2) then
814: p_rec.bpr_attribute27 :=
815: ben_bpr_shd.g_old_rec.bpr_attribute27;
816: End If;
817: If (p_rec.bpr_attribute28 = hr_api.g_varchar2) then
818: p_rec.bpr_attribute28 :=
819: ben_bpr_shd.g_old_rec.bpr_attribute28;
815: ben_bpr_shd.g_old_rec.bpr_attribute27;
816: End If;
817: If (p_rec.bpr_attribute28 = hr_api.g_varchar2) then
818: p_rec.bpr_attribute28 :=
819: ben_bpr_shd.g_old_rec.bpr_attribute28;
820: End If;
821: If (p_rec.bpr_attribute29 = hr_api.g_varchar2) then
822: p_rec.bpr_attribute29 :=
823: ben_bpr_shd.g_old_rec.bpr_attribute29;
819: ben_bpr_shd.g_old_rec.bpr_attribute28;
820: End If;
821: If (p_rec.bpr_attribute29 = hr_api.g_varchar2) then
822: p_rec.bpr_attribute29 :=
823: ben_bpr_shd.g_old_rec.bpr_attribute29;
824: End If;
825: If (p_rec.bpr_attribute30 = hr_api.g_varchar2) then
826: p_rec.bpr_attribute30 :=
827: ben_bpr_shd.g_old_rec.bpr_attribute30;
823: ben_bpr_shd.g_old_rec.bpr_attribute29;
824: End If;
825: If (p_rec.bpr_attribute30 = hr_api.g_varchar2) then
826: p_rec.bpr_attribute30 :=
827: ben_bpr_shd.g_old_rec.bpr_attribute30;
828: End If;
829:
830: --
831: hr_utility.set_location(' Leaving:'||l_proc, 10);
836: -- |---------------------------------< upd >----------------------------------|
837: -- ----------------------------------------------------------------------------
838: Procedure upd
839: (
840: p_rec in out nocopy ben_bpr_shd.g_rec_type,
841: p_effective_date in date,
842: p_datetrack_mode in varchar2
843: ) is
844: --
854: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
855: --
856: -- We must lock the row which we need to update.
857: --
858: ben_bpr_shd.lck
859: (p_effective_date => p_effective_date,
860: p_datetrack_mode => p_datetrack_mode,
861: p_bnft_pool_rlovr_rqmt_id => p_rec.bnft_pool_rlovr_rqmt_id,
862: p_object_version_number => p_rec.object_version_number,
970: p_effective_date in date,
971: p_datetrack_mode in varchar2
972: ) is
973: --
974: l_rec ben_bpr_shd.g_rec_type;
975: l_proc varchar2(72) := g_package||'upd';
976: --
977: Begin
978: hr_utility.set_location('Entering:'||l_proc, 5);
980: -- Call conversion function to turn arguments into the
981: -- l_rec structure.
982: --
983: l_rec :=
984: ben_bpr_shd.convert_args
985: (
986: p_bnft_pool_rlovr_rqmt_id,
987: null,
988: null,