[Home] [Help]
54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: Procedure dt_update_dml
58: (p_rec in out nocopy ben_ccm_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_cvg_amt_calc_mthd_f',
78: p_base_key_column => 'cvg_amt_calc_mthd_id',
79: p_base_key_value => p_rec.cvg_amt_calc_mthd_id);
80: --
81: ben_ccm_shd.g_api_dml := true; -- Set the api dml status
82: --
83: -- Update the ben_cvg_amt_calc_mthd_f Row
84: --
85: update ben_cvg_amt_calc_mthd_f
149: where cvg_amt_calc_mthd_id = p_rec.cvg_amt_calc_mthd_id
150: and effective_start_date = p_validation_start_date
151: and effective_end_date = p_validation_end_date;
152: --
153: ben_ccm_shd.g_api_dml := false; -- Unset the api dml status
154: --
155: -- Set the effective start and end dates
156: --
157: p_rec.effective_start_date := p_validation_start_date;
161: hr_utility.set_location(' Leaving:'||l_proc, 15);
162: Exception
163: When hr_api.check_integrity_violated Then
164: -- A check constraint has been violated
165: ben_ccm_shd.g_api_dml := false; -- Unset the api dml status
166: ben_ccm_shd.constraint_error
167: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
168: When hr_api.unique_integrity_violated Then
169: -- Unique integrity has been violated
162: Exception
163: When hr_api.check_integrity_violated Then
164: -- A check constraint has been violated
165: ben_ccm_shd.g_api_dml := false; -- Unset the api dml status
166: ben_ccm_shd.constraint_error
167: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
168: When hr_api.unique_integrity_violated Then
169: -- Unique integrity has been violated
170: ben_ccm_shd.g_api_dml := false; -- Unset the api dml status
166: ben_ccm_shd.constraint_error
167: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
168: When hr_api.unique_integrity_violated Then
169: -- Unique integrity has been violated
170: ben_ccm_shd.g_api_dml := false; -- Unset the api dml status
171: ben_ccm_shd.constraint_error
172: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
173: When Others Then
174: ben_ccm_shd.g_api_dml := false; -- Unset the api dml status
167: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
168: When hr_api.unique_integrity_violated Then
169: -- Unique integrity has been violated
170: ben_ccm_shd.g_api_dml := false; -- Unset the api dml status
171: ben_ccm_shd.constraint_error
172: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
173: When Others Then
174: ben_ccm_shd.g_api_dml := false; -- Unset the api dml status
175: Raise;
170: ben_ccm_shd.g_api_dml := false; -- Unset the api dml status
171: ben_ccm_shd.constraint_error
172: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
173: When Others Then
174: ben_ccm_shd.g_api_dml := false; -- Unset the api dml status
175: Raise;
176: End dt_update_dml;
177: --
178: -- ----------------------------------------------------------------------------
206: --
207: -- {End Of Comments}
208: -- ----------------------------------------------------------------------------
209: Procedure update_dml
210: (p_rec in out nocopy ben_ccm_shd.g_rec_type,
211: p_effective_date in date,
212: p_datetrack_mode in varchar2,
213: p_validation_start_date in date,
214: p_validation_end_date in date) is
270: --
271: -- {End Of Comments}
272: -- ----------------------------------------------------------------------------
273: Procedure dt_pre_update
274: (p_rec in out nocopy ben_ccm_shd.g_rec_type,
275: p_effective_date in date,
276: p_datetrack_mode in varchar2,
277: p_validation_start_date in date,
278: p_validation_end_date in date) is
286: hr_utility.set_location(l_proc, 10);
287: --
288: -- Update the current effective end date
289: --
290: ben_ccm_shd.upd_effective_end_date
291: (p_effective_date => p_effective_date,
292: p_base_key_value => p_rec.cvg_amt_calc_mthd_id,
293: p_new_effective_end_date => (p_validation_start_date - 1),
294: p_validation_start_date => p_validation_start_date,
355: --
356: -- {End Of Comments}
357: -- ----------------------------------------------------------------------------
358: Procedure pre_update
359: (p_rec in out nocopy ben_ccm_shd.g_rec_type,
360: p_effective_date in date,
361: p_datetrack_mode in varchar2,
362: p_validation_start_date in date,
363: p_validation_end_date in date) is
411: --
412: -- {End Of Comments}
413: -- ----------------------------------------------------------------------------
414: Procedure post_update
415: (p_rec in ben_ccm_shd.g_rec_type,
416: p_effective_date in date,
417: p_datetrack_mode in varchar2,
418: p_validation_start_date in date,
419: p_validation_end_date in date) is
497: ,p_effective_date =>p_effective_date
498: ,p_datetrack_mode =>p_datetrack_mode
499: ,p_validation_start_date =>p_validation_start_date
500: ,p_validation_end_date =>p_validation_end_date
501: ,p_effective_start_date_o =>ben_ccm_shd.g_old_rec.effective_start_date
502: ,p_effective_end_date_o =>ben_ccm_shd.g_old_rec.effective_end_date
503: ,p_name_o =>ben_ccm_shd.g_old_rec.name
504: ,p_incrmt_val_o =>ben_ccm_shd.g_old_rec.incrmt_val
505: ,p_mx_val_o =>ben_ccm_shd.g_old_rec.mx_val
498: ,p_datetrack_mode =>p_datetrack_mode
499: ,p_validation_start_date =>p_validation_start_date
500: ,p_validation_end_date =>p_validation_end_date
501: ,p_effective_start_date_o =>ben_ccm_shd.g_old_rec.effective_start_date
502: ,p_effective_end_date_o =>ben_ccm_shd.g_old_rec.effective_end_date
503: ,p_name_o =>ben_ccm_shd.g_old_rec.name
504: ,p_incrmt_val_o =>ben_ccm_shd.g_old_rec.incrmt_val
505: ,p_mx_val_o =>ben_ccm_shd.g_old_rec.mx_val
506: ,p_mn_val_o =>ben_ccm_shd.g_old_rec.mn_val
499: ,p_validation_start_date =>p_validation_start_date
500: ,p_validation_end_date =>p_validation_end_date
501: ,p_effective_start_date_o =>ben_ccm_shd.g_old_rec.effective_start_date
502: ,p_effective_end_date_o =>ben_ccm_shd.g_old_rec.effective_end_date
503: ,p_name_o =>ben_ccm_shd.g_old_rec.name
504: ,p_incrmt_val_o =>ben_ccm_shd.g_old_rec.incrmt_val
505: ,p_mx_val_o =>ben_ccm_shd.g_old_rec.mx_val
506: ,p_mn_val_o =>ben_ccm_shd.g_old_rec.mn_val
507: ,p_no_mx_val_dfnd_flag_o =>ben_ccm_shd.g_old_rec.no_mx_val_dfnd_flag
500: ,p_validation_end_date =>p_validation_end_date
501: ,p_effective_start_date_o =>ben_ccm_shd.g_old_rec.effective_start_date
502: ,p_effective_end_date_o =>ben_ccm_shd.g_old_rec.effective_end_date
503: ,p_name_o =>ben_ccm_shd.g_old_rec.name
504: ,p_incrmt_val_o =>ben_ccm_shd.g_old_rec.incrmt_val
505: ,p_mx_val_o =>ben_ccm_shd.g_old_rec.mx_val
506: ,p_mn_val_o =>ben_ccm_shd.g_old_rec.mn_val
507: ,p_no_mx_val_dfnd_flag_o =>ben_ccm_shd.g_old_rec.no_mx_val_dfnd_flag
508: ,p_no_mn_val_dfnd_flag_o =>ben_ccm_shd.g_old_rec.no_mn_val_dfnd_flag
501: ,p_effective_start_date_o =>ben_ccm_shd.g_old_rec.effective_start_date
502: ,p_effective_end_date_o =>ben_ccm_shd.g_old_rec.effective_end_date
503: ,p_name_o =>ben_ccm_shd.g_old_rec.name
504: ,p_incrmt_val_o =>ben_ccm_shd.g_old_rec.incrmt_val
505: ,p_mx_val_o =>ben_ccm_shd.g_old_rec.mx_val
506: ,p_mn_val_o =>ben_ccm_shd.g_old_rec.mn_val
507: ,p_no_mx_val_dfnd_flag_o =>ben_ccm_shd.g_old_rec.no_mx_val_dfnd_flag
508: ,p_no_mn_val_dfnd_flag_o =>ben_ccm_shd.g_old_rec.no_mn_val_dfnd_flag
509: ,p_rndg_cd_o =>ben_ccm_shd.g_old_rec.rndg_cd
502: ,p_effective_end_date_o =>ben_ccm_shd.g_old_rec.effective_end_date
503: ,p_name_o =>ben_ccm_shd.g_old_rec.name
504: ,p_incrmt_val_o =>ben_ccm_shd.g_old_rec.incrmt_val
505: ,p_mx_val_o =>ben_ccm_shd.g_old_rec.mx_val
506: ,p_mn_val_o =>ben_ccm_shd.g_old_rec.mn_val
507: ,p_no_mx_val_dfnd_flag_o =>ben_ccm_shd.g_old_rec.no_mx_val_dfnd_flag
508: ,p_no_mn_val_dfnd_flag_o =>ben_ccm_shd.g_old_rec.no_mn_val_dfnd_flag
509: ,p_rndg_cd_o =>ben_ccm_shd.g_old_rec.rndg_cd
510: ,p_rndg_rl_o =>ben_ccm_shd.g_old_rec.rndg_rl
503: ,p_name_o =>ben_ccm_shd.g_old_rec.name
504: ,p_incrmt_val_o =>ben_ccm_shd.g_old_rec.incrmt_val
505: ,p_mx_val_o =>ben_ccm_shd.g_old_rec.mx_val
506: ,p_mn_val_o =>ben_ccm_shd.g_old_rec.mn_val
507: ,p_no_mx_val_dfnd_flag_o =>ben_ccm_shd.g_old_rec.no_mx_val_dfnd_flag
508: ,p_no_mn_val_dfnd_flag_o =>ben_ccm_shd.g_old_rec.no_mn_val_dfnd_flag
509: ,p_rndg_cd_o =>ben_ccm_shd.g_old_rec.rndg_cd
510: ,p_rndg_rl_o =>ben_ccm_shd.g_old_rec.rndg_rl
511: ,p_lwr_lmt_val_o =>ben_ccm_shd.g_old_rec.lwr_lmt_val
504: ,p_incrmt_val_o =>ben_ccm_shd.g_old_rec.incrmt_val
505: ,p_mx_val_o =>ben_ccm_shd.g_old_rec.mx_val
506: ,p_mn_val_o =>ben_ccm_shd.g_old_rec.mn_val
507: ,p_no_mx_val_dfnd_flag_o =>ben_ccm_shd.g_old_rec.no_mx_val_dfnd_flag
508: ,p_no_mn_val_dfnd_flag_o =>ben_ccm_shd.g_old_rec.no_mn_val_dfnd_flag
509: ,p_rndg_cd_o =>ben_ccm_shd.g_old_rec.rndg_cd
510: ,p_rndg_rl_o =>ben_ccm_shd.g_old_rec.rndg_rl
511: ,p_lwr_lmt_val_o =>ben_ccm_shd.g_old_rec.lwr_lmt_val
512: ,p_lwr_lmt_calc_rl_o =>ben_ccm_shd.g_old_rec.lwr_lmt_calc_rl
505: ,p_mx_val_o =>ben_ccm_shd.g_old_rec.mx_val
506: ,p_mn_val_o =>ben_ccm_shd.g_old_rec.mn_val
507: ,p_no_mx_val_dfnd_flag_o =>ben_ccm_shd.g_old_rec.no_mx_val_dfnd_flag
508: ,p_no_mn_val_dfnd_flag_o =>ben_ccm_shd.g_old_rec.no_mn_val_dfnd_flag
509: ,p_rndg_cd_o =>ben_ccm_shd.g_old_rec.rndg_cd
510: ,p_rndg_rl_o =>ben_ccm_shd.g_old_rec.rndg_rl
511: ,p_lwr_lmt_val_o =>ben_ccm_shd.g_old_rec.lwr_lmt_val
512: ,p_lwr_lmt_calc_rl_o =>ben_ccm_shd.g_old_rec.lwr_lmt_calc_rl
513: ,p_upr_lmt_val_o =>ben_ccm_shd.g_old_rec.upr_lmt_val
506: ,p_mn_val_o =>ben_ccm_shd.g_old_rec.mn_val
507: ,p_no_mx_val_dfnd_flag_o =>ben_ccm_shd.g_old_rec.no_mx_val_dfnd_flag
508: ,p_no_mn_val_dfnd_flag_o =>ben_ccm_shd.g_old_rec.no_mn_val_dfnd_flag
509: ,p_rndg_cd_o =>ben_ccm_shd.g_old_rec.rndg_cd
510: ,p_rndg_rl_o =>ben_ccm_shd.g_old_rec.rndg_rl
511: ,p_lwr_lmt_val_o =>ben_ccm_shd.g_old_rec.lwr_lmt_val
512: ,p_lwr_lmt_calc_rl_o =>ben_ccm_shd.g_old_rec.lwr_lmt_calc_rl
513: ,p_upr_lmt_val_o =>ben_ccm_shd.g_old_rec.upr_lmt_val
514: ,p_upr_lmt_calc_rl_o =>ben_ccm_shd.g_old_rec.upr_lmt_calc_rl
507: ,p_no_mx_val_dfnd_flag_o =>ben_ccm_shd.g_old_rec.no_mx_val_dfnd_flag
508: ,p_no_mn_val_dfnd_flag_o =>ben_ccm_shd.g_old_rec.no_mn_val_dfnd_flag
509: ,p_rndg_cd_o =>ben_ccm_shd.g_old_rec.rndg_cd
510: ,p_rndg_rl_o =>ben_ccm_shd.g_old_rec.rndg_rl
511: ,p_lwr_lmt_val_o =>ben_ccm_shd.g_old_rec.lwr_lmt_val
512: ,p_lwr_lmt_calc_rl_o =>ben_ccm_shd.g_old_rec.lwr_lmt_calc_rl
513: ,p_upr_lmt_val_o =>ben_ccm_shd.g_old_rec.upr_lmt_val
514: ,p_upr_lmt_calc_rl_o =>ben_ccm_shd.g_old_rec.upr_lmt_calc_rl
515: ,p_val_o =>ben_ccm_shd.g_old_rec.val
508: ,p_no_mn_val_dfnd_flag_o =>ben_ccm_shd.g_old_rec.no_mn_val_dfnd_flag
509: ,p_rndg_cd_o =>ben_ccm_shd.g_old_rec.rndg_cd
510: ,p_rndg_rl_o =>ben_ccm_shd.g_old_rec.rndg_rl
511: ,p_lwr_lmt_val_o =>ben_ccm_shd.g_old_rec.lwr_lmt_val
512: ,p_lwr_lmt_calc_rl_o =>ben_ccm_shd.g_old_rec.lwr_lmt_calc_rl
513: ,p_upr_lmt_val_o =>ben_ccm_shd.g_old_rec.upr_lmt_val
514: ,p_upr_lmt_calc_rl_o =>ben_ccm_shd.g_old_rec.upr_lmt_calc_rl
515: ,p_val_o =>ben_ccm_shd.g_old_rec.val
516: ,p_val_ovrid_alwd_flag_o =>ben_ccm_shd.g_old_rec.val_ovrid_alwd_flag
509: ,p_rndg_cd_o =>ben_ccm_shd.g_old_rec.rndg_cd
510: ,p_rndg_rl_o =>ben_ccm_shd.g_old_rec.rndg_rl
511: ,p_lwr_lmt_val_o =>ben_ccm_shd.g_old_rec.lwr_lmt_val
512: ,p_lwr_lmt_calc_rl_o =>ben_ccm_shd.g_old_rec.lwr_lmt_calc_rl
513: ,p_upr_lmt_val_o =>ben_ccm_shd.g_old_rec.upr_lmt_val
514: ,p_upr_lmt_calc_rl_o =>ben_ccm_shd.g_old_rec.upr_lmt_calc_rl
515: ,p_val_o =>ben_ccm_shd.g_old_rec.val
516: ,p_val_ovrid_alwd_flag_o =>ben_ccm_shd.g_old_rec.val_ovrid_alwd_flag
517: ,p_val_calc_rl_o =>ben_ccm_shd.g_old_rec.val_calc_rl
510: ,p_rndg_rl_o =>ben_ccm_shd.g_old_rec.rndg_rl
511: ,p_lwr_lmt_val_o =>ben_ccm_shd.g_old_rec.lwr_lmt_val
512: ,p_lwr_lmt_calc_rl_o =>ben_ccm_shd.g_old_rec.lwr_lmt_calc_rl
513: ,p_upr_lmt_val_o =>ben_ccm_shd.g_old_rec.upr_lmt_val
514: ,p_upr_lmt_calc_rl_o =>ben_ccm_shd.g_old_rec.upr_lmt_calc_rl
515: ,p_val_o =>ben_ccm_shd.g_old_rec.val
516: ,p_val_ovrid_alwd_flag_o =>ben_ccm_shd.g_old_rec.val_ovrid_alwd_flag
517: ,p_val_calc_rl_o =>ben_ccm_shd.g_old_rec.val_calc_rl
518: ,p_uom_o =>ben_ccm_shd.g_old_rec.uom
511: ,p_lwr_lmt_val_o =>ben_ccm_shd.g_old_rec.lwr_lmt_val
512: ,p_lwr_lmt_calc_rl_o =>ben_ccm_shd.g_old_rec.lwr_lmt_calc_rl
513: ,p_upr_lmt_val_o =>ben_ccm_shd.g_old_rec.upr_lmt_val
514: ,p_upr_lmt_calc_rl_o =>ben_ccm_shd.g_old_rec.upr_lmt_calc_rl
515: ,p_val_o =>ben_ccm_shd.g_old_rec.val
516: ,p_val_ovrid_alwd_flag_o =>ben_ccm_shd.g_old_rec.val_ovrid_alwd_flag
517: ,p_val_calc_rl_o =>ben_ccm_shd.g_old_rec.val_calc_rl
518: ,p_uom_o =>ben_ccm_shd.g_old_rec.uom
519: ,p_nnmntry_uom_o =>ben_ccm_shd.g_old_rec.nnmntry_uom
512: ,p_lwr_lmt_calc_rl_o =>ben_ccm_shd.g_old_rec.lwr_lmt_calc_rl
513: ,p_upr_lmt_val_o =>ben_ccm_shd.g_old_rec.upr_lmt_val
514: ,p_upr_lmt_calc_rl_o =>ben_ccm_shd.g_old_rec.upr_lmt_calc_rl
515: ,p_val_o =>ben_ccm_shd.g_old_rec.val
516: ,p_val_ovrid_alwd_flag_o =>ben_ccm_shd.g_old_rec.val_ovrid_alwd_flag
517: ,p_val_calc_rl_o =>ben_ccm_shd.g_old_rec.val_calc_rl
518: ,p_uom_o =>ben_ccm_shd.g_old_rec.uom
519: ,p_nnmntry_uom_o =>ben_ccm_shd.g_old_rec.nnmntry_uom
520: ,p_bndry_perd_cd_o =>ben_ccm_shd.g_old_rec.bndry_perd_cd
513: ,p_upr_lmt_val_o =>ben_ccm_shd.g_old_rec.upr_lmt_val
514: ,p_upr_lmt_calc_rl_o =>ben_ccm_shd.g_old_rec.upr_lmt_calc_rl
515: ,p_val_o =>ben_ccm_shd.g_old_rec.val
516: ,p_val_ovrid_alwd_flag_o =>ben_ccm_shd.g_old_rec.val_ovrid_alwd_flag
517: ,p_val_calc_rl_o =>ben_ccm_shd.g_old_rec.val_calc_rl
518: ,p_uom_o =>ben_ccm_shd.g_old_rec.uom
519: ,p_nnmntry_uom_o =>ben_ccm_shd.g_old_rec.nnmntry_uom
520: ,p_bndry_perd_cd_o =>ben_ccm_shd.g_old_rec.bndry_perd_cd
521: ,p_bnft_typ_cd_o =>ben_ccm_shd.g_old_rec.bnft_typ_cd
514: ,p_upr_lmt_calc_rl_o =>ben_ccm_shd.g_old_rec.upr_lmt_calc_rl
515: ,p_val_o =>ben_ccm_shd.g_old_rec.val
516: ,p_val_ovrid_alwd_flag_o =>ben_ccm_shd.g_old_rec.val_ovrid_alwd_flag
517: ,p_val_calc_rl_o =>ben_ccm_shd.g_old_rec.val_calc_rl
518: ,p_uom_o =>ben_ccm_shd.g_old_rec.uom
519: ,p_nnmntry_uom_o =>ben_ccm_shd.g_old_rec.nnmntry_uom
520: ,p_bndry_perd_cd_o =>ben_ccm_shd.g_old_rec.bndry_perd_cd
521: ,p_bnft_typ_cd_o =>ben_ccm_shd.g_old_rec.bnft_typ_cd
522: ,p_cvg_mlt_cd_o =>ben_ccm_shd.g_old_rec.cvg_mlt_cd
515: ,p_val_o =>ben_ccm_shd.g_old_rec.val
516: ,p_val_ovrid_alwd_flag_o =>ben_ccm_shd.g_old_rec.val_ovrid_alwd_flag
517: ,p_val_calc_rl_o =>ben_ccm_shd.g_old_rec.val_calc_rl
518: ,p_uom_o =>ben_ccm_shd.g_old_rec.uom
519: ,p_nnmntry_uom_o =>ben_ccm_shd.g_old_rec.nnmntry_uom
520: ,p_bndry_perd_cd_o =>ben_ccm_shd.g_old_rec.bndry_perd_cd
521: ,p_bnft_typ_cd_o =>ben_ccm_shd.g_old_rec.bnft_typ_cd
522: ,p_cvg_mlt_cd_o =>ben_ccm_shd.g_old_rec.cvg_mlt_cd
523: ,p_rt_typ_cd_o =>ben_ccm_shd.g_old_rec.rt_typ_cd
516: ,p_val_ovrid_alwd_flag_o =>ben_ccm_shd.g_old_rec.val_ovrid_alwd_flag
517: ,p_val_calc_rl_o =>ben_ccm_shd.g_old_rec.val_calc_rl
518: ,p_uom_o =>ben_ccm_shd.g_old_rec.uom
519: ,p_nnmntry_uom_o =>ben_ccm_shd.g_old_rec.nnmntry_uom
520: ,p_bndry_perd_cd_o =>ben_ccm_shd.g_old_rec.bndry_perd_cd
521: ,p_bnft_typ_cd_o =>ben_ccm_shd.g_old_rec.bnft_typ_cd
522: ,p_cvg_mlt_cd_o =>ben_ccm_shd.g_old_rec.cvg_mlt_cd
523: ,p_rt_typ_cd_o =>ben_ccm_shd.g_old_rec.rt_typ_cd
524: ,p_dflt_val_o =>ben_ccm_shd.g_old_rec.dflt_val
517: ,p_val_calc_rl_o =>ben_ccm_shd.g_old_rec.val_calc_rl
518: ,p_uom_o =>ben_ccm_shd.g_old_rec.uom
519: ,p_nnmntry_uom_o =>ben_ccm_shd.g_old_rec.nnmntry_uom
520: ,p_bndry_perd_cd_o =>ben_ccm_shd.g_old_rec.bndry_perd_cd
521: ,p_bnft_typ_cd_o =>ben_ccm_shd.g_old_rec.bnft_typ_cd
522: ,p_cvg_mlt_cd_o =>ben_ccm_shd.g_old_rec.cvg_mlt_cd
523: ,p_rt_typ_cd_o =>ben_ccm_shd.g_old_rec.rt_typ_cd
524: ,p_dflt_val_o =>ben_ccm_shd.g_old_rec.dflt_val
525: ,p_entr_val_at_enrt_flag_o =>ben_ccm_shd.g_old_rec.entr_val_at_enrt_flag
518: ,p_uom_o =>ben_ccm_shd.g_old_rec.uom
519: ,p_nnmntry_uom_o =>ben_ccm_shd.g_old_rec.nnmntry_uom
520: ,p_bndry_perd_cd_o =>ben_ccm_shd.g_old_rec.bndry_perd_cd
521: ,p_bnft_typ_cd_o =>ben_ccm_shd.g_old_rec.bnft_typ_cd
522: ,p_cvg_mlt_cd_o =>ben_ccm_shd.g_old_rec.cvg_mlt_cd
523: ,p_rt_typ_cd_o =>ben_ccm_shd.g_old_rec.rt_typ_cd
524: ,p_dflt_val_o =>ben_ccm_shd.g_old_rec.dflt_val
525: ,p_entr_val_at_enrt_flag_o =>ben_ccm_shd.g_old_rec.entr_val_at_enrt_flag
526: ,p_dflt_flag_o =>ben_ccm_shd.g_old_rec.dflt_flag
519: ,p_nnmntry_uom_o =>ben_ccm_shd.g_old_rec.nnmntry_uom
520: ,p_bndry_perd_cd_o =>ben_ccm_shd.g_old_rec.bndry_perd_cd
521: ,p_bnft_typ_cd_o =>ben_ccm_shd.g_old_rec.bnft_typ_cd
522: ,p_cvg_mlt_cd_o =>ben_ccm_shd.g_old_rec.cvg_mlt_cd
523: ,p_rt_typ_cd_o =>ben_ccm_shd.g_old_rec.rt_typ_cd
524: ,p_dflt_val_o =>ben_ccm_shd.g_old_rec.dflt_val
525: ,p_entr_val_at_enrt_flag_o =>ben_ccm_shd.g_old_rec.entr_val_at_enrt_flag
526: ,p_dflt_flag_o =>ben_ccm_shd.g_old_rec.dflt_flag
527: ,p_comp_lvl_fctr_id_o =>ben_ccm_shd.g_old_rec.comp_lvl_fctr_id
520: ,p_bndry_perd_cd_o =>ben_ccm_shd.g_old_rec.bndry_perd_cd
521: ,p_bnft_typ_cd_o =>ben_ccm_shd.g_old_rec.bnft_typ_cd
522: ,p_cvg_mlt_cd_o =>ben_ccm_shd.g_old_rec.cvg_mlt_cd
523: ,p_rt_typ_cd_o =>ben_ccm_shd.g_old_rec.rt_typ_cd
524: ,p_dflt_val_o =>ben_ccm_shd.g_old_rec.dflt_val
525: ,p_entr_val_at_enrt_flag_o =>ben_ccm_shd.g_old_rec.entr_val_at_enrt_flag
526: ,p_dflt_flag_o =>ben_ccm_shd.g_old_rec.dflt_flag
527: ,p_comp_lvl_fctr_id_o =>ben_ccm_shd.g_old_rec.comp_lvl_fctr_id
528: ,p_oipl_id_o =>ben_ccm_shd.g_old_rec.oipl_id
521: ,p_bnft_typ_cd_o =>ben_ccm_shd.g_old_rec.bnft_typ_cd
522: ,p_cvg_mlt_cd_o =>ben_ccm_shd.g_old_rec.cvg_mlt_cd
523: ,p_rt_typ_cd_o =>ben_ccm_shd.g_old_rec.rt_typ_cd
524: ,p_dflt_val_o =>ben_ccm_shd.g_old_rec.dflt_val
525: ,p_entr_val_at_enrt_flag_o =>ben_ccm_shd.g_old_rec.entr_val_at_enrt_flag
526: ,p_dflt_flag_o =>ben_ccm_shd.g_old_rec.dflt_flag
527: ,p_comp_lvl_fctr_id_o =>ben_ccm_shd.g_old_rec.comp_lvl_fctr_id
528: ,p_oipl_id_o =>ben_ccm_shd.g_old_rec.oipl_id
529: ,p_pl_id_o =>ben_ccm_shd.g_old_rec.pl_id
522: ,p_cvg_mlt_cd_o =>ben_ccm_shd.g_old_rec.cvg_mlt_cd
523: ,p_rt_typ_cd_o =>ben_ccm_shd.g_old_rec.rt_typ_cd
524: ,p_dflt_val_o =>ben_ccm_shd.g_old_rec.dflt_val
525: ,p_entr_val_at_enrt_flag_o =>ben_ccm_shd.g_old_rec.entr_val_at_enrt_flag
526: ,p_dflt_flag_o =>ben_ccm_shd.g_old_rec.dflt_flag
527: ,p_comp_lvl_fctr_id_o =>ben_ccm_shd.g_old_rec.comp_lvl_fctr_id
528: ,p_oipl_id_o =>ben_ccm_shd.g_old_rec.oipl_id
529: ,p_pl_id_o =>ben_ccm_shd.g_old_rec.pl_id
530: ,p_plip_id_o =>ben_ccm_shd.g_old_rec.plip_id
523: ,p_rt_typ_cd_o =>ben_ccm_shd.g_old_rec.rt_typ_cd
524: ,p_dflt_val_o =>ben_ccm_shd.g_old_rec.dflt_val
525: ,p_entr_val_at_enrt_flag_o =>ben_ccm_shd.g_old_rec.entr_val_at_enrt_flag
526: ,p_dflt_flag_o =>ben_ccm_shd.g_old_rec.dflt_flag
527: ,p_comp_lvl_fctr_id_o =>ben_ccm_shd.g_old_rec.comp_lvl_fctr_id
528: ,p_oipl_id_o =>ben_ccm_shd.g_old_rec.oipl_id
529: ,p_pl_id_o =>ben_ccm_shd.g_old_rec.pl_id
530: ,p_plip_id_o =>ben_ccm_shd.g_old_rec.plip_id
531: ,p_business_group_id_o =>ben_ccm_shd.g_old_rec.business_group_id
524: ,p_dflt_val_o =>ben_ccm_shd.g_old_rec.dflt_val
525: ,p_entr_val_at_enrt_flag_o =>ben_ccm_shd.g_old_rec.entr_val_at_enrt_flag
526: ,p_dflt_flag_o =>ben_ccm_shd.g_old_rec.dflt_flag
527: ,p_comp_lvl_fctr_id_o =>ben_ccm_shd.g_old_rec.comp_lvl_fctr_id
528: ,p_oipl_id_o =>ben_ccm_shd.g_old_rec.oipl_id
529: ,p_pl_id_o =>ben_ccm_shd.g_old_rec.pl_id
530: ,p_plip_id_o =>ben_ccm_shd.g_old_rec.plip_id
531: ,p_business_group_id_o =>ben_ccm_shd.g_old_rec.business_group_id
532: ,p_ccm_attribute_category_o =>ben_ccm_shd.g_old_rec.ccm_attribute_category
525: ,p_entr_val_at_enrt_flag_o =>ben_ccm_shd.g_old_rec.entr_val_at_enrt_flag
526: ,p_dflt_flag_o =>ben_ccm_shd.g_old_rec.dflt_flag
527: ,p_comp_lvl_fctr_id_o =>ben_ccm_shd.g_old_rec.comp_lvl_fctr_id
528: ,p_oipl_id_o =>ben_ccm_shd.g_old_rec.oipl_id
529: ,p_pl_id_o =>ben_ccm_shd.g_old_rec.pl_id
530: ,p_plip_id_o =>ben_ccm_shd.g_old_rec.plip_id
531: ,p_business_group_id_o =>ben_ccm_shd.g_old_rec.business_group_id
532: ,p_ccm_attribute_category_o =>ben_ccm_shd.g_old_rec.ccm_attribute_category
533: ,p_ccm_attribute1_o =>ben_ccm_shd.g_old_rec.ccm_attribute1
526: ,p_dflt_flag_o =>ben_ccm_shd.g_old_rec.dflt_flag
527: ,p_comp_lvl_fctr_id_o =>ben_ccm_shd.g_old_rec.comp_lvl_fctr_id
528: ,p_oipl_id_o =>ben_ccm_shd.g_old_rec.oipl_id
529: ,p_pl_id_o =>ben_ccm_shd.g_old_rec.pl_id
530: ,p_plip_id_o =>ben_ccm_shd.g_old_rec.plip_id
531: ,p_business_group_id_o =>ben_ccm_shd.g_old_rec.business_group_id
532: ,p_ccm_attribute_category_o =>ben_ccm_shd.g_old_rec.ccm_attribute_category
533: ,p_ccm_attribute1_o =>ben_ccm_shd.g_old_rec.ccm_attribute1
534: ,p_ccm_attribute2_o =>ben_ccm_shd.g_old_rec.ccm_attribute2
527: ,p_comp_lvl_fctr_id_o =>ben_ccm_shd.g_old_rec.comp_lvl_fctr_id
528: ,p_oipl_id_o =>ben_ccm_shd.g_old_rec.oipl_id
529: ,p_pl_id_o =>ben_ccm_shd.g_old_rec.pl_id
530: ,p_plip_id_o =>ben_ccm_shd.g_old_rec.plip_id
531: ,p_business_group_id_o =>ben_ccm_shd.g_old_rec.business_group_id
532: ,p_ccm_attribute_category_o =>ben_ccm_shd.g_old_rec.ccm_attribute_category
533: ,p_ccm_attribute1_o =>ben_ccm_shd.g_old_rec.ccm_attribute1
534: ,p_ccm_attribute2_o =>ben_ccm_shd.g_old_rec.ccm_attribute2
535: ,p_ccm_attribute3_o =>ben_ccm_shd.g_old_rec.ccm_attribute3
528: ,p_oipl_id_o =>ben_ccm_shd.g_old_rec.oipl_id
529: ,p_pl_id_o =>ben_ccm_shd.g_old_rec.pl_id
530: ,p_plip_id_o =>ben_ccm_shd.g_old_rec.plip_id
531: ,p_business_group_id_o =>ben_ccm_shd.g_old_rec.business_group_id
532: ,p_ccm_attribute_category_o =>ben_ccm_shd.g_old_rec.ccm_attribute_category
533: ,p_ccm_attribute1_o =>ben_ccm_shd.g_old_rec.ccm_attribute1
534: ,p_ccm_attribute2_o =>ben_ccm_shd.g_old_rec.ccm_attribute2
535: ,p_ccm_attribute3_o =>ben_ccm_shd.g_old_rec.ccm_attribute3
536: ,p_ccm_attribute4_o =>ben_ccm_shd.g_old_rec.ccm_attribute4
529: ,p_pl_id_o =>ben_ccm_shd.g_old_rec.pl_id
530: ,p_plip_id_o =>ben_ccm_shd.g_old_rec.plip_id
531: ,p_business_group_id_o =>ben_ccm_shd.g_old_rec.business_group_id
532: ,p_ccm_attribute_category_o =>ben_ccm_shd.g_old_rec.ccm_attribute_category
533: ,p_ccm_attribute1_o =>ben_ccm_shd.g_old_rec.ccm_attribute1
534: ,p_ccm_attribute2_o =>ben_ccm_shd.g_old_rec.ccm_attribute2
535: ,p_ccm_attribute3_o =>ben_ccm_shd.g_old_rec.ccm_attribute3
536: ,p_ccm_attribute4_o =>ben_ccm_shd.g_old_rec.ccm_attribute4
537: ,p_ccm_attribute5_o =>ben_ccm_shd.g_old_rec.ccm_attribute5
530: ,p_plip_id_o =>ben_ccm_shd.g_old_rec.plip_id
531: ,p_business_group_id_o =>ben_ccm_shd.g_old_rec.business_group_id
532: ,p_ccm_attribute_category_o =>ben_ccm_shd.g_old_rec.ccm_attribute_category
533: ,p_ccm_attribute1_o =>ben_ccm_shd.g_old_rec.ccm_attribute1
534: ,p_ccm_attribute2_o =>ben_ccm_shd.g_old_rec.ccm_attribute2
535: ,p_ccm_attribute3_o =>ben_ccm_shd.g_old_rec.ccm_attribute3
536: ,p_ccm_attribute4_o =>ben_ccm_shd.g_old_rec.ccm_attribute4
537: ,p_ccm_attribute5_o =>ben_ccm_shd.g_old_rec.ccm_attribute5
538: ,p_ccm_attribute6_o =>ben_ccm_shd.g_old_rec.ccm_attribute6
531: ,p_business_group_id_o =>ben_ccm_shd.g_old_rec.business_group_id
532: ,p_ccm_attribute_category_o =>ben_ccm_shd.g_old_rec.ccm_attribute_category
533: ,p_ccm_attribute1_o =>ben_ccm_shd.g_old_rec.ccm_attribute1
534: ,p_ccm_attribute2_o =>ben_ccm_shd.g_old_rec.ccm_attribute2
535: ,p_ccm_attribute3_o =>ben_ccm_shd.g_old_rec.ccm_attribute3
536: ,p_ccm_attribute4_o =>ben_ccm_shd.g_old_rec.ccm_attribute4
537: ,p_ccm_attribute5_o =>ben_ccm_shd.g_old_rec.ccm_attribute5
538: ,p_ccm_attribute6_o =>ben_ccm_shd.g_old_rec.ccm_attribute6
539: ,p_ccm_attribute7_o =>ben_ccm_shd.g_old_rec.ccm_attribute7
532: ,p_ccm_attribute_category_o =>ben_ccm_shd.g_old_rec.ccm_attribute_category
533: ,p_ccm_attribute1_o =>ben_ccm_shd.g_old_rec.ccm_attribute1
534: ,p_ccm_attribute2_o =>ben_ccm_shd.g_old_rec.ccm_attribute2
535: ,p_ccm_attribute3_o =>ben_ccm_shd.g_old_rec.ccm_attribute3
536: ,p_ccm_attribute4_o =>ben_ccm_shd.g_old_rec.ccm_attribute4
537: ,p_ccm_attribute5_o =>ben_ccm_shd.g_old_rec.ccm_attribute5
538: ,p_ccm_attribute6_o =>ben_ccm_shd.g_old_rec.ccm_attribute6
539: ,p_ccm_attribute7_o =>ben_ccm_shd.g_old_rec.ccm_attribute7
540: ,p_ccm_attribute8_o =>ben_ccm_shd.g_old_rec.ccm_attribute8
533: ,p_ccm_attribute1_o =>ben_ccm_shd.g_old_rec.ccm_attribute1
534: ,p_ccm_attribute2_o =>ben_ccm_shd.g_old_rec.ccm_attribute2
535: ,p_ccm_attribute3_o =>ben_ccm_shd.g_old_rec.ccm_attribute3
536: ,p_ccm_attribute4_o =>ben_ccm_shd.g_old_rec.ccm_attribute4
537: ,p_ccm_attribute5_o =>ben_ccm_shd.g_old_rec.ccm_attribute5
538: ,p_ccm_attribute6_o =>ben_ccm_shd.g_old_rec.ccm_attribute6
539: ,p_ccm_attribute7_o =>ben_ccm_shd.g_old_rec.ccm_attribute7
540: ,p_ccm_attribute8_o =>ben_ccm_shd.g_old_rec.ccm_attribute8
541: ,p_ccm_attribute9_o =>ben_ccm_shd.g_old_rec.ccm_attribute9
534: ,p_ccm_attribute2_o =>ben_ccm_shd.g_old_rec.ccm_attribute2
535: ,p_ccm_attribute3_o =>ben_ccm_shd.g_old_rec.ccm_attribute3
536: ,p_ccm_attribute4_o =>ben_ccm_shd.g_old_rec.ccm_attribute4
537: ,p_ccm_attribute5_o =>ben_ccm_shd.g_old_rec.ccm_attribute5
538: ,p_ccm_attribute6_o =>ben_ccm_shd.g_old_rec.ccm_attribute6
539: ,p_ccm_attribute7_o =>ben_ccm_shd.g_old_rec.ccm_attribute7
540: ,p_ccm_attribute8_o =>ben_ccm_shd.g_old_rec.ccm_attribute8
541: ,p_ccm_attribute9_o =>ben_ccm_shd.g_old_rec.ccm_attribute9
542: ,p_ccm_attribute10_o =>ben_ccm_shd.g_old_rec.ccm_attribute10
535: ,p_ccm_attribute3_o =>ben_ccm_shd.g_old_rec.ccm_attribute3
536: ,p_ccm_attribute4_o =>ben_ccm_shd.g_old_rec.ccm_attribute4
537: ,p_ccm_attribute5_o =>ben_ccm_shd.g_old_rec.ccm_attribute5
538: ,p_ccm_attribute6_o =>ben_ccm_shd.g_old_rec.ccm_attribute6
539: ,p_ccm_attribute7_o =>ben_ccm_shd.g_old_rec.ccm_attribute7
540: ,p_ccm_attribute8_o =>ben_ccm_shd.g_old_rec.ccm_attribute8
541: ,p_ccm_attribute9_o =>ben_ccm_shd.g_old_rec.ccm_attribute9
542: ,p_ccm_attribute10_o =>ben_ccm_shd.g_old_rec.ccm_attribute10
543: ,p_ccm_attribute11_o =>ben_ccm_shd.g_old_rec.ccm_attribute11
536: ,p_ccm_attribute4_o =>ben_ccm_shd.g_old_rec.ccm_attribute4
537: ,p_ccm_attribute5_o =>ben_ccm_shd.g_old_rec.ccm_attribute5
538: ,p_ccm_attribute6_o =>ben_ccm_shd.g_old_rec.ccm_attribute6
539: ,p_ccm_attribute7_o =>ben_ccm_shd.g_old_rec.ccm_attribute7
540: ,p_ccm_attribute8_o =>ben_ccm_shd.g_old_rec.ccm_attribute8
541: ,p_ccm_attribute9_o =>ben_ccm_shd.g_old_rec.ccm_attribute9
542: ,p_ccm_attribute10_o =>ben_ccm_shd.g_old_rec.ccm_attribute10
543: ,p_ccm_attribute11_o =>ben_ccm_shd.g_old_rec.ccm_attribute11
544: ,p_ccm_attribute12_o =>ben_ccm_shd.g_old_rec.ccm_attribute12
537: ,p_ccm_attribute5_o =>ben_ccm_shd.g_old_rec.ccm_attribute5
538: ,p_ccm_attribute6_o =>ben_ccm_shd.g_old_rec.ccm_attribute6
539: ,p_ccm_attribute7_o =>ben_ccm_shd.g_old_rec.ccm_attribute7
540: ,p_ccm_attribute8_o =>ben_ccm_shd.g_old_rec.ccm_attribute8
541: ,p_ccm_attribute9_o =>ben_ccm_shd.g_old_rec.ccm_attribute9
542: ,p_ccm_attribute10_o =>ben_ccm_shd.g_old_rec.ccm_attribute10
543: ,p_ccm_attribute11_o =>ben_ccm_shd.g_old_rec.ccm_attribute11
544: ,p_ccm_attribute12_o =>ben_ccm_shd.g_old_rec.ccm_attribute12
545: ,p_ccm_attribute13_o =>ben_ccm_shd.g_old_rec.ccm_attribute13
538: ,p_ccm_attribute6_o =>ben_ccm_shd.g_old_rec.ccm_attribute6
539: ,p_ccm_attribute7_o =>ben_ccm_shd.g_old_rec.ccm_attribute7
540: ,p_ccm_attribute8_o =>ben_ccm_shd.g_old_rec.ccm_attribute8
541: ,p_ccm_attribute9_o =>ben_ccm_shd.g_old_rec.ccm_attribute9
542: ,p_ccm_attribute10_o =>ben_ccm_shd.g_old_rec.ccm_attribute10
543: ,p_ccm_attribute11_o =>ben_ccm_shd.g_old_rec.ccm_attribute11
544: ,p_ccm_attribute12_o =>ben_ccm_shd.g_old_rec.ccm_attribute12
545: ,p_ccm_attribute13_o =>ben_ccm_shd.g_old_rec.ccm_attribute13
546: ,p_ccm_attribute14_o =>ben_ccm_shd.g_old_rec.ccm_attribute14
539: ,p_ccm_attribute7_o =>ben_ccm_shd.g_old_rec.ccm_attribute7
540: ,p_ccm_attribute8_o =>ben_ccm_shd.g_old_rec.ccm_attribute8
541: ,p_ccm_attribute9_o =>ben_ccm_shd.g_old_rec.ccm_attribute9
542: ,p_ccm_attribute10_o =>ben_ccm_shd.g_old_rec.ccm_attribute10
543: ,p_ccm_attribute11_o =>ben_ccm_shd.g_old_rec.ccm_attribute11
544: ,p_ccm_attribute12_o =>ben_ccm_shd.g_old_rec.ccm_attribute12
545: ,p_ccm_attribute13_o =>ben_ccm_shd.g_old_rec.ccm_attribute13
546: ,p_ccm_attribute14_o =>ben_ccm_shd.g_old_rec.ccm_attribute14
547: ,p_ccm_attribute15_o =>ben_ccm_shd.g_old_rec.ccm_attribute15
540: ,p_ccm_attribute8_o =>ben_ccm_shd.g_old_rec.ccm_attribute8
541: ,p_ccm_attribute9_o =>ben_ccm_shd.g_old_rec.ccm_attribute9
542: ,p_ccm_attribute10_o =>ben_ccm_shd.g_old_rec.ccm_attribute10
543: ,p_ccm_attribute11_o =>ben_ccm_shd.g_old_rec.ccm_attribute11
544: ,p_ccm_attribute12_o =>ben_ccm_shd.g_old_rec.ccm_attribute12
545: ,p_ccm_attribute13_o =>ben_ccm_shd.g_old_rec.ccm_attribute13
546: ,p_ccm_attribute14_o =>ben_ccm_shd.g_old_rec.ccm_attribute14
547: ,p_ccm_attribute15_o =>ben_ccm_shd.g_old_rec.ccm_attribute15
548: ,p_ccm_attribute16_o =>ben_ccm_shd.g_old_rec.ccm_attribute16
541: ,p_ccm_attribute9_o =>ben_ccm_shd.g_old_rec.ccm_attribute9
542: ,p_ccm_attribute10_o =>ben_ccm_shd.g_old_rec.ccm_attribute10
543: ,p_ccm_attribute11_o =>ben_ccm_shd.g_old_rec.ccm_attribute11
544: ,p_ccm_attribute12_o =>ben_ccm_shd.g_old_rec.ccm_attribute12
545: ,p_ccm_attribute13_o =>ben_ccm_shd.g_old_rec.ccm_attribute13
546: ,p_ccm_attribute14_o =>ben_ccm_shd.g_old_rec.ccm_attribute14
547: ,p_ccm_attribute15_o =>ben_ccm_shd.g_old_rec.ccm_attribute15
548: ,p_ccm_attribute16_o =>ben_ccm_shd.g_old_rec.ccm_attribute16
549: ,p_ccm_attribute17_o =>ben_ccm_shd.g_old_rec.ccm_attribute17
542: ,p_ccm_attribute10_o =>ben_ccm_shd.g_old_rec.ccm_attribute10
543: ,p_ccm_attribute11_o =>ben_ccm_shd.g_old_rec.ccm_attribute11
544: ,p_ccm_attribute12_o =>ben_ccm_shd.g_old_rec.ccm_attribute12
545: ,p_ccm_attribute13_o =>ben_ccm_shd.g_old_rec.ccm_attribute13
546: ,p_ccm_attribute14_o =>ben_ccm_shd.g_old_rec.ccm_attribute14
547: ,p_ccm_attribute15_o =>ben_ccm_shd.g_old_rec.ccm_attribute15
548: ,p_ccm_attribute16_o =>ben_ccm_shd.g_old_rec.ccm_attribute16
549: ,p_ccm_attribute17_o =>ben_ccm_shd.g_old_rec.ccm_attribute17
550: ,p_ccm_attribute18_o =>ben_ccm_shd.g_old_rec.ccm_attribute18
543: ,p_ccm_attribute11_o =>ben_ccm_shd.g_old_rec.ccm_attribute11
544: ,p_ccm_attribute12_o =>ben_ccm_shd.g_old_rec.ccm_attribute12
545: ,p_ccm_attribute13_o =>ben_ccm_shd.g_old_rec.ccm_attribute13
546: ,p_ccm_attribute14_o =>ben_ccm_shd.g_old_rec.ccm_attribute14
547: ,p_ccm_attribute15_o =>ben_ccm_shd.g_old_rec.ccm_attribute15
548: ,p_ccm_attribute16_o =>ben_ccm_shd.g_old_rec.ccm_attribute16
549: ,p_ccm_attribute17_o =>ben_ccm_shd.g_old_rec.ccm_attribute17
550: ,p_ccm_attribute18_o =>ben_ccm_shd.g_old_rec.ccm_attribute18
551: ,p_ccm_attribute19_o =>ben_ccm_shd.g_old_rec.ccm_attribute19
544: ,p_ccm_attribute12_o =>ben_ccm_shd.g_old_rec.ccm_attribute12
545: ,p_ccm_attribute13_o =>ben_ccm_shd.g_old_rec.ccm_attribute13
546: ,p_ccm_attribute14_o =>ben_ccm_shd.g_old_rec.ccm_attribute14
547: ,p_ccm_attribute15_o =>ben_ccm_shd.g_old_rec.ccm_attribute15
548: ,p_ccm_attribute16_o =>ben_ccm_shd.g_old_rec.ccm_attribute16
549: ,p_ccm_attribute17_o =>ben_ccm_shd.g_old_rec.ccm_attribute17
550: ,p_ccm_attribute18_o =>ben_ccm_shd.g_old_rec.ccm_attribute18
551: ,p_ccm_attribute19_o =>ben_ccm_shd.g_old_rec.ccm_attribute19
552: ,p_ccm_attribute20_o =>ben_ccm_shd.g_old_rec.ccm_attribute20
545: ,p_ccm_attribute13_o =>ben_ccm_shd.g_old_rec.ccm_attribute13
546: ,p_ccm_attribute14_o =>ben_ccm_shd.g_old_rec.ccm_attribute14
547: ,p_ccm_attribute15_o =>ben_ccm_shd.g_old_rec.ccm_attribute15
548: ,p_ccm_attribute16_o =>ben_ccm_shd.g_old_rec.ccm_attribute16
549: ,p_ccm_attribute17_o =>ben_ccm_shd.g_old_rec.ccm_attribute17
550: ,p_ccm_attribute18_o =>ben_ccm_shd.g_old_rec.ccm_attribute18
551: ,p_ccm_attribute19_o =>ben_ccm_shd.g_old_rec.ccm_attribute19
552: ,p_ccm_attribute20_o =>ben_ccm_shd.g_old_rec.ccm_attribute20
553: ,p_ccm_attribute21_o =>ben_ccm_shd.g_old_rec.ccm_attribute21
546: ,p_ccm_attribute14_o =>ben_ccm_shd.g_old_rec.ccm_attribute14
547: ,p_ccm_attribute15_o =>ben_ccm_shd.g_old_rec.ccm_attribute15
548: ,p_ccm_attribute16_o =>ben_ccm_shd.g_old_rec.ccm_attribute16
549: ,p_ccm_attribute17_o =>ben_ccm_shd.g_old_rec.ccm_attribute17
550: ,p_ccm_attribute18_o =>ben_ccm_shd.g_old_rec.ccm_attribute18
551: ,p_ccm_attribute19_o =>ben_ccm_shd.g_old_rec.ccm_attribute19
552: ,p_ccm_attribute20_o =>ben_ccm_shd.g_old_rec.ccm_attribute20
553: ,p_ccm_attribute21_o =>ben_ccm_shd.g_old_rec.ccm_attribute21
554: ,p_ccm_attribute22_o =>ben_ccm_shd.g_old_rec.ccm_attribute22
547: ,p_ccm_attribute15_o =>ben_ccm_shd.g_old_rec.ccm_attribute15
548: ,p_ccm_attribute16_o =>ben_ccm_shd.g_old_rec.ccm_attribute16
549: ,p_ccm_attribute17_o =>ben_ccm_shd.g_old_rec.ccm_attribute17
550: ,p_ccm_attribute18_o =>ben_ccm_shd.g_old_rec.ccm_attribute18
551: ,p_ccm_attribute19_o =>ben_ccm_shd.g_old_rec.ccm_attribute19
552: ,p_ccm_attribute20_o =>ben_ccm_shd.g_old_rec.ccm_attribute20
553: ,p_ccm_attribute21_o =>ben_ccm_shd.g_old_rec.ccm_attribute21
554: ,p_ccm_attribute22_o =>ben_ccm_shd.g_old_rec.ccm_attribute22
555: ,p_ccm_attribute23_o =>ben_ccm_shd.g_old_rec.ccm_attribute23
548: ,p_ccm_attribute16_o =>ben_ccm_shd.g_old_rec.ccm_attribute16
549: ,p_ccm_attribute17_o =>ben_ccm_shd.g_old_rec.ccm_attribute17
550: ,p_ccm_attribute18_o =>ben_ccm_shd.g_old_rec.ccm_attribute18
551: ,p_ccm_attribute19_o =>ben_ccm_shd.g_old_rec.ccm_attribute19
552: ,p_ccm_attribute20_o =>ben_ccm_shd.g_old_rec.ccm_attribute20
553: ,p_ccm_attribute21_o =>ben_ccm_shd.g_old_rec.ccm_attribute21
554: ,p_ccm_attribute22_o =>ben_ccm_shd.g_old_rec.ccm_attribute22
555: ,p_ccm_attribute23_o =>ben_ccm_shd.g_old_rec.ccm_attribute23
556: ,p_ccm_attribute24_o =>ben_ccm_shd.g_old_rec.ccm_attribute24
549: ,p_ccm_attribute17_o =>ben_ccm_shd.g_old_rec.ccm_attribute17
550: ,p_ccm_attribute18_o =>ben_ccm_shd.g_old_rec.ccm_attribute18
551: ,p_ccm_attribute19_o =>ben_ccm_shd.g_old_rec.ccm_attribute19
552: ,p_ccm_attribute20_o =>ben_ccm_shd.g_old_rec.ccm_attribute20
553: ,p_ccm_attribute21_o =>ben_ccm_shd.g_old_rec.ccm_attribute21
554: ,p_ccm_attribute22_o =>ben_ccm_shd.g_old_rec.ccm_attribute22
555: ,p_ccm_attribute23_o =>ben_ccm_shd.g_old_rec.ccm_attribute23
556: ,p_ccm_attribute24_o =>ben_ccm_shd.g_old_rec.ccm_attribute24
557: ,p_ccm_attribute25_o =>ben_ccm_shd.g_old_rec.ccm_attribute25
550: ,p_ccm_attribute18_o =>ben_ccm_shd.g_old_rec.ccm_attribute18
551: ,p_ccm_attribute19_o =>ben_ccm_shd.g_old_rec.ccm_attribute19
552: ,p_ccm_attribute20_o =>ben_ccm_shd.g_old_rec.ccm_attribute20
553: ,p_ccm_attribute21_o =>ben_ccm_shd.g_old_rec.ccm_attribute21
554: ,p_ccm_attribute22_o =>ben_ccm_shd.g_old_rec.ccm_attribute22
555: ,p_ccm_attribute23_o =>ben_ccm_shd.g_old_rec.ccm_attribute23
556: ,p_ccm_attribute24_o =>ben_ccm_shd.g_old_rec.ccm_attribute24
557: ,p_ccm_attribute25_o =>ben_ccm_shd.g_old_rec.ccm_attribute25
558: ,p_ccm_attribute26_o =>ben_ccm_shd.g_old_rec.ccm_attribute26
551: ,p_ccm_attribute19_o =>ben_ccm_shd.g_old_rec.ccm_attribute19
552: ,p_ccm_attribute20_o =>ben_ccm_shd.g_old_rec.ccm_attribute20
553: ,p_ccm_attribute21_o =>ben_ccm_shd.g_old_rec.ccm_attribute21
554: ,p_ccm_attribute22_o =>ben_ccm_shd.g_old_rec.ccm_attribute22
555: ,p_ccm_attribute23_o =>ben_ccm_shd.g_old_rec.ccm_attribute23
556: ,p_ccm_attribute24_o =>ben_ccm_shd.g_old_rec.ccm_attribute24
557: ,p_ccm_attribute25_o =>ben_ccm_shd.g_old_rec.ccm_attribute25
558: ,p_ccm_attribute26_o =>ben_ccm_shd.g_old_rec.ccm_attribute26
559: ,p_ccm_attribute27_o =>ben_ccm_shd.g_old_rec.ccm_attribute27
552: ,p_ccm_attribute20_o =>ben_ccm_shd.g_old_rec.ccm_attribute20
553: ,p_ccm_attribute21_o =>ben_ccm_shd.g_old_rec.ccm_attribute21
554: ,p_ccm_attribute22_o =>ben_ccm_shd.g_old_rec.ccm_attribute22
555: ,p_ccm_attribute23_o =>ben_ccm_shd.g_old_rec.ccm_attribute23
556: ,p_ccm_attribute24_o =>ben_ccm_shd.g_old_rec.ccm_attribute24
557: ,p_ccm_attribute25_o =>ben_ccm_shd.g_old_rec.ccm_attribute25
558: ,p_ccm_attribute26_o =>ben_ccm_shd.g_old_rec.ccm_attribute26
559: ,p_ccm_attribute27_o =>ben_ccm_shd.g_old_rec.ccm_attribute27
560: ,p_ccm_attribute28_o =>ben_ccm_shd.g_old_rec.ccm_attribute28
553: ,p_ccm_attribute21_o =>ben_ccm_shd.g_old_rec.ccm_attribute21
554: ,p_ccm_attribute22_o =>ben_ccm_shd.g_old_rec.ccm_attribute22
555: ,p_ccm_attribute23_o =>ben_ccm_shd.g_old_rec.ccm_attribute23
556: ,p_ccm_attribute24_o =>ben_ccm_shd.g_old_rec.ccm_attribute24
557: ,p_ccm_attribute25_o =>ben_ccm_shd.g_old_rec.ccm_attribute25
558: ,p_ccm_attribute26_o =>ben_ccm_shd.g_old_rec.ccm_attribute26
559: ,p_ccm_attribute27_o =>ben_ccm_shd.g_old_rec.ccm_attribute27
560: ,p_ccm_attribute28_o =>ben_ccm_shd.g_old_rec.ccm_attribute28
561: ,p_ccm_attribute29_o =>ben_ccm_shd.g_old_rec.ccm_attribute29
554: ,p_ccm_attribute22_o =>ben_ccm_shd.g_old_rec.ccm_attribute22
555: ,p_ccm_attribute23_o =>ben_ccm_shd.g_old_rec.ccm_attribute23
556: ,p_ccm_attribute24_o =>ben_ccm_shd.g_old_rec.ccm_attribute24
557: ,p_ccm_attribute25_o =>ben_ccm_shd.g_old_rec.ccm_attribute25
558: ,p_ccm_attribute26_o =>ben_ccm_shd.g_old_rec.ccm_attribute26
559: ,p_ccm_attribute27_o =>ben_ccm_shd.g_old_rec.ccm_attribute27
560: ,p_ccm_attribute28_o =>ben_ccm_shd.g_old_rec.ccm_attribute28
561: ,p_ccm_attribute29_o =>ben_ccm_shd.g_old_rec.ccm_attribute29
562: ,p_ccm_attribute30_o =>ben_ccm_shd.g_old_rec.ccm_attribute30
555: ,p_ccm_attribute23_o =>ben_ccm_shd.g_old_rec.ccm_attribute23
556: ,p_ccm_attribute24_o =>ben_ccm_shd.g_old_rec.ccm_attribute24
557: ,p_ccm_attribute25_o =>ben_ccm_shd.g_old_rec.ccm_attribute25
558: ,p_ccm_attribute26_o =>ben_ccm_shd.g_old_rec.ccm_attribute26
559: ,p_ccm_attribute27_o =>ben_ccm_shd.g_old_rec.ccm_attribute27
560: ,p_ccm_attribute28_o =>ben_ccm_shd.g_old_rec.ccm_attribute28
561: ,p_ccm_attribute29_o =>ben_ccm_shd.g_old_rec.ccm_attribute29
562: ,p_ccm_attribute30_o =>ben_ccm_shd.g_old_rec.ccm_attribute30
563: ,p_object_version_number_o =>ben_ccm_shd.g_old_rec.object_version_number
556: ,p_ccm_attribute24_o =>ben_ccm_shd.g_old_rec.ccm_attribute24
557: ,p_ccm_attribute25_o =>ben_ccm_shd.g_old_rec.ccm_attribute25
558: ,p_ccm_attribute26_o =>ben_ccm_shd.g_old_rec.ccm_attribute26
559: ,p_ccm_attribute27_o =>ben_ccm_shd.g_old_rec.ccm_attribute27
560: ,p_ccm_attribute28_o =>ben_ccm_shd.g_old_rec.ccm_attribute28
561: ,p_ccm_attribute29_o =>ben_ccm_shd.g_old_rec.ccm_attribute29
562: ,p_ccm_attribute30_o =>ben_ccm_shd.g_old_rec.ccm_attribute30
563: ,p_object_version_number_o =>ben_ccm_shd.g_old_rec.object_version_number
564: );
557: ,p_ccm_attribute25_o =>ben_ccm_shd.g_old_rec.ccm_attribute25
558: ,p_ccm_attribute26_o =>ben_ccm_shd.g_old_rec.ccm_attribute26
559: ,p_ccm_attribute27_o =>ben_ccm_shd.g_old_rec.ccm_attribute27
560: ,p_ccm_attribute28_o =>ben_ccm_shd.g_old_rec.ccm_attribute28
561: ,p_ccm_attribute29_o =>ben_ccm_shd.g_old_rec.ccm_attribute29
562: ,p_ccm_attribute30_o =>ben_ccm_shd.g_old_rec.ccm_attribute30
563: ,p_object_version_number_o =>ben_ccm_shd.g_old_rec.object_version_number
564: );
565: --
558: ,p_ccm_attribute26_o =>ben_ccm_shd.g_old_rec.ccm_attribute26
559: ,p_ccm_attribute27_o =>ben_ccm_shd.g_old_rec.ccm_attribute27
560: ,p_ccm_attribute28_o =>ben_ccm_shd.g_old_rec.ccm_attribute28
561: ,p_ccm_attribute29_o =>ben_ccm_shd.g_old_rec.ccm_attribute29
562: ,p_ccm_attribute30_o =>ben_ccm_shd.g_old_rec.ccm_attribute30
563: ,p_object_version_number_o =>ben_ccm_shd.g_old_rec.object_version_number
564: );
565: --
566: exception
559: ,p_ccm_attribute27_o =>ben_ccm_shd.g_old_rec.ccm_attribute27
560: ,p_ccm_attribute28_o =>ben_ccm_shd.g_old_rec.ccm_attribute28
561: ,p_ccm_attribute29_o =>ben_ccm_shd.g_old_rec.ccm_attribute29
562: ,p_ccm_attribute30_o =>ben_ccm_shd.g_old_rec.ccm_attribute30
563: ,p_object_version_number_o =>ben_ccm_shd.g_old_rec.object_version_number
564: );
565: --
566: exception
567: --
621: -- Internal Row Handler Use Only.
622: --
623: -- {End Of Comments}
624: -- ----------------------------------------------------------------------------
625: Procedure convert_defs(p_rec in out nocopy ben_ccm_shd.g_rec_type) is
626: --
627: l_proc varchar2(72) := g_package||'convert_defs';
628: --
629: Begin
636: -- is being used then we must set to the 'current' argument value.
637: --
638: If (p_rec.name = hr_api.g_varchar2) then
639: p_rec.name :=
640: ben_ccm_shd.g_old_rec.name;
641: End If;
642: If (p_rec.incrmt_val = hr_api.g_number) then
643: p_rec.incrmt_val :=
644: ben_ccm_shd.g_old_rec.incrmt_val;
640: ben_ccm_shd.g_old_rec.name;
641: End If;
642: If (p_rec.incrmt_val = hr_api.g_number) then
643: p_rec.incrmt_val :=
644: ben_ccm_shd.g_old_rec.incrmt_val;
645: End If;
646: If (p_rec.mx_val = hr_api.g_number) then
647: p_rec.mx_val :=
648: ben_ccm_shd.g_old_rec.mx_val;
644: ben_ccm_shd.g_old_rec.incrmt_val;
645: End If;
646: If (p_rec.mx_val = hr_api.g_number) then
647: p_rec.mx_val :=
648: ben_ccm_shd.g_old_rec.mx_val;
649: End If;
650: If (p_rec.mn_val = hr_api.g_number) then
651: p_rec.mn_val :=
652: ben_ccm_shd.g_old_rec.mn_val;
648: ben_ccm_shd.g_old_rec.mx_val;
649: End If;
650: If (p_rec.mn_val = hr_api.g_number) then
651: p_rec.mn_val :=
652: ben_ccm_shd.g_old_rec.mn_val;
653: End If;
654: If (p_rec.no_mx_val_dfnd_flag = hr_api.g_varchar2) then
655: p_rec.no_mx_val_dfnd_flag :=
656: ben_ccm_shd.g_old_rec.no_mx_val_dfnd_flag;
652: ben_ccm_shd.g_old_rec.mn_val;
653: End If;
654: If (p_rec.no_mx_val_dfnd_flag = hr_api.g_varchar2) then
655: p_rec.no_mx_val_dfnd_flag :=
656: ben_ccm_shd.g_old_rec.no_mx_val_dfnd_flag;
657: End If;
658: If (p_rec.no_mn_val_dfnd_flag = hr_api.g_varchar2) then
659: p_rec.no_mn_val_dfnd_flag :=
660: ben_ccm_shd.g_old_rec.no_mn_val_dfnd_flag;
656: ben_ccm_shd.g_old_rec.no_mx_val_dfnd_flag;
657: End If;
658: If (p_rec.no_mn_val_dfnd_flag = hr_api.g_varchar2) then
659: p_rec.no_mn_val_dfnd_flag :=
660: ben_ccm_shd.g_old_rec.no_mn_val_dfnd_flag;
661: End If;
662: If (p_rec.rndg_cd = hr_api.g_varchar2) then
663: p_rec.rndg_cd :=
664: ben_ccm_shd.g_old_rec.rndg_cd;
660: ben_ccm_shd.g_old_rec.no_mn_val_dfnd_flag;
661: End If;
662: If (p_rec.rndg_cd = hr_api.g_varchar2) then
663: p_rec.rndg_cd :=
664: ben_ccm_shd.g_old_rec.rndg_cd;
665: End If;
666: If (p_rec.rndg_rl = hr_api.g_number) then
667: p_rec.rndg_rl :=
668: ben_ccm_shd.g_old_rec.rndg_rl;
664: ben_ccm_shd.g_old_rec.rndg_cd;
665: End If;
666: If (p_rec.rndg_rl = hr_api.g_number) then
667: p_rec.rndg_rl :=
668: ben_ccm_shd.g_old_rec.rndg_rl;
669: End If;
670: If (p_rec.lwr_lmt_val = hr_api.g_number) then
671: p_rec.lwr_lmt_val :=
672: ben_ccm_shd.g_old_rec.lwr_lmt_val;
668: ben_ccm_shd.g_old_rec.rndg_rl;
669: End If;
670: If (p_rec.lwr_lmt_val = hr_api.g_number) then
671: p_rec.lwr_lmt_val :=
672: ben_ccm_shd.g_old_rec.lwr_lmt_val;
673: End If;
674: If (p_rec.lwr_lmt_calc_rl = hr_api.g_number) then
675: p_rec.lwr_lmt_calc_rl :=
676: ben_ccm_shd.g_old_rec.lwr_lmt_calc_rl;
672: ben_ccm_shd.g_old_rec.lwr_lmt_val;
673: End If;
674: If (p_rec.lwr_lmt_calc_rl = hr_api.g_number) then
675: p_rec.lwr_lmt_calc_rl :=
676: ben_ccm_shd.g_old_rec.lwr_lmt_calc_rl;
677: End If;
678: If (p_rec.upr_lmt_val = hr_api.g_number) then
679: p_rec.upr_lmt_val :=
680: ben_ccm_shd.g_old_rec.upr_lmt_val;
676: ben_ccm_shd.g_old_rec.lwr_lmt_calc_rl;
677: End If;
678: If (p_rec.upr_lmt_val = hr_api.g_number) then
679: p_rec.upr_lmt_val :=
680: ben_ccm_shd.g_old_rec.upr_lmt_val;
681: End If;
682: If (p_rec.upr_lmt_calc_rl = hr_api.g_number) then
683: p_rec.upr_lmt_calc_rl :=
684: ben_ccm_shd.g_old_rec.upr_lmt_calc_rl;
680: ben_ccm_shd.g_old_rec.upr_lmt_val;
681: End If;
682: If (p_rec.upr_lmt_calc_rl = hr_api.g_number) then
683: p_rec.upr_lmt_calc_rl :=
684: ben_ccm_shd.g_old_rec.upr_lmt_calc_rl;
685: End If;
686: If (p_rec.val = hr_api.g_number) then
687: p_rec.val :=
688: ben_ccm_shd.g_old_rec.val;
684: ben_ccm_shd.g_old_rec.upr_lmt_calc_rl;
685: End If;
686: If (p_rec.val = hr_api.g_number) then
687: p_rec.val :=
688: ben_ccm_shd.g_old_rec.val;
689: End If;
690: If (p_rec.val_ovrid_alwd_flag = hr_api.g_varchar2) then
691: p_rec.val_ovrid_alwd_flag :=
692: ben_ccm_shd.g_old_rec.val_ovrid_alwd_flag;
688: ben_ccm_shd.g_old_rec.val;
689: End If;
690: If (p_rec.val_ovrid_alwd_flag = hr_api.g_varchar2) then
691: p_rec.val_ovrid_alwd_flag :=
692: ben_ccm_shd.g_old_rec.val_ovrid_alwd_flag;
693: End If;
694: If (p_rec.val_calc_rl = hr_api.g_number) then
695: p_rec.val_calc_rl :=
696: ben_ccm_shd.g_old_rec.val_calc_rl;
692: ben_ccm_shd.g_old_rec.val_ovrid_alwd_flag;
693: End If;
694: If (p_rec.val_calc_rl = hr_api.g_number) then
695: p_rec.val_calc_rl :=
696: ben_ccm_shd.g_old_rec.val_calc_rl;
697: End If;
698: If (p_rec.uom = hr_api.g_varchar2) then
699: p_rec.uom :=
700: ben_ccm_shd.g_old_rec.uom;
696: ben_ccm_shd.g_old_rec.val_calc_rl;
697: End If;
698: If (p_rec.uom = hr_api.g_varchar2) then
699: p_rec.uom :=
700: ben_ccm_shd.g_old_rec.uom;
701: End If;
702: If (p_rec.nnmntry_uom = hr_api.g_varchar2) then
703: p_rec.nnmntry_uom :=
704: ben_ccm_shd.g_old_rec.nnmntry_uom;
700: ben_ccm_shd.g_old_rec.uom;
701: End If;
702: If (p_rec.nnmntry_uom = hr_api.g_varchar2) then
703: p_rec.nnmntry_uom :=
704: ben_ccm_shd.g_old_rec.nnmntry_uom;
705: End If;
706: If (p_rec.bndry_perd_cd = hr_api.g_varchar2) then
707: p_rec.bndry_perd_cd :=
708: ben_ccm_shd.g_old_rec.bndry_perd_cd;
704: ben_ccm_shd.g_old_rec.nnmntry_uom;
705: End If;
706: If (p_rec.bndry_perd_cd = hr_api.g_varchar2) then
707: p_rec.bndry_perd_cd :=
708: ben_ccm_shd.g_old_rec.bndry_perd_cd;
709: End If;
710: If (p_rec.bnft_typ_cd = hr_api.g_varchar2) then
711: p_rec.bnft_typ_cd :=
712: ben_ccm_shd.g_old_rec.bnft_typ_cd;
708: ben_ccm_shd.g_old_rec.bndry_perd_cd;
709: End If;
710: If (p_rec.bnft_typ_cd = hr_api.g_varchar2) then
711: p_rec.bnft_typ_cd :=
712: ben_ccm_shd.g_old_rec.bnft_typ_cd;
713: End If;
714: If (p_rec.cvg_mlt_cd = hr_api.g_varchar2) then
715: p_rec.cvg_mlt_cd :=
716: ben_ccm_shd.g_old_rec.cvg_mlt_cd;
712: ben_ccm_shd.g_old_rec.bnft_typ_cd;
713: End If;
714: If (p_rec.cvg_mlt_cd = hr_api.g_varchar2) then
715: p_rec.cvg_mlt_cd :=
716: ben_ccm_shd.g_old_rec.cvg_mlt_cd;
717: End If;
718: If (p_rec.rt_typ_cd = hr_api.g_varchar2) then
719: p_rec.rt_typ_cd :=
720: ben_ccm_shd.g_old_rec.rt_typ_cd;
716: ben_ccm_shd.g_old_rec.cvg_mlt_cd;
717: End If;
718: If (p_rec.rt_typ_cd = hr_api.g_varchar2) then
719: p_rec.rt_typ_cd :=
720: ben_ccm_shd.g_old_rec.rt_typ_cd;
721: End If;
722:
723: If (p_rec.dflt_val = hr_api.g_number) then
724: p_rec.dflt_val :=
721: End If;
722:
723: If (p_rec.dflt_val = hr_api.g_number) then
724: p_rec.dflt_val :=
725: ben_ccm_shd.g_old_rec.dflt_val ;
726: End If;
727: If (p_rec.entr_val_at_enrt_flag = hr_api.g_varchar2) then
728: p_rec.entr_val_at_enrt_flag :=
729: ben_ccm_shd.g_old_rec.entr_val_at_enrt_flag ;
725: ben_ccm_shd.g_old_rec.dflt_val ;
726: End If;
727: If (p_rec.entr_val_at_enrt_flag = hr_api.g_varchar2) then
728: p_rec.entr_val_at_enrt_flag :=
729: ben_ccm_shd.g_old_rec.entr_val_at_enrt_flag ;
730: End If;
731: If (p_rec.dflt_flag = hr_api.g_varchar2) then
732: p_rec.dflt_flag :=
733: ben_ccm_shd.g_old_rec.dflt_flag ;
729: ben_ccm_shd.g_old_rec.entr_val_at_enrt_flag ;
730: End If;
731: If (p_rec.dflt_flag = hr_api.g_varchar2) then
732: p_rec.dflt_flag :=
733: ben_ccm_shd.g_old_rec.dflt_flag ;
734: End If;
735: If (p_rec.comp_lvl_fctr_id = hr_api.g_number) then
736: p_rec.comp_lvl_fctr_id :=
737: ben_ccm_shd.g_old_rec.comp_lvl_fctr_id;
733: ben_ccm_shd.g_old_rec.dflt_flag ;
734: End If;
735: If (p_rec.comp_lvl_fctr_id = hr_api.g_number) then
736: p_rec.comp_lvl_fctr_id :=
737: ben_ccm_shd.g_old_rec.comp_lvl_fctr_id;
738: End If;
739: If (p_rec.oipl_id = hr_api.g_number) then
740: p_rec.oipl_id :=
741: ben_ccm_shd.g_old_rec.oipl_id;
737: ben_ccm_shd.g_old_rec.comp_lvl_fctr_id;
738: End If;
739: If (p_rec.oipl_id = hr_api.g_number) then
740: p_rec.oipl_id :=
741: ben_ccm_shd.g_old_rec.oipl_id;
742: End If;
743: If (p_rec.pl_id = hr_api.g_number) then
744: p_rec.pl_id :=
745: ben_ccm_shd.g_old_rec.pl_id;
741: ben_ccm_shd.g_old_rec.oipl_id;
742: End If;
743: If (p_rec.pl_id = hr_api.g_number) then
744: p_rec.pl_id :=
745: ben_ccm_shd.g_old_rec.pl_id;
746: End If;
747: If (p_rec.plip_id = hr_api.g_number) then
748: p_rec.plip_id :=
749: ben_ccm_shd.g_old_rec.plip_id;
745: ben_ccm_shd.g_old_rec.pl_id;
746: End If;
747: If (p_rec.plip_id = hr_api.g_number) then
748: p_rec.plip_id :=
749: ben_ccm_shd.g_old_rec.plip_id;
750: End If;
751: If (p_rec.business_group_id = hr_api.g_number) then
752: p_rec.business_group_id :=
753: ben_ccm_shd.g_old_rec.business_group_id;
749: ben_ccm_shd.g_old_rec.plip_id;
750: End If;
751: If (p_rec.business_group_id = hr_api.g_number) then
752: p_rec.business_group_id :=
753: ben_ccm_shd.g_old_rec.business_group_id;
754: End If;
755: If (p_rec.ccm_attribute_category = hr_api.g_varchar2) then
756: p_rec.ccm_attribute_category :=
757: ben_ccm_shd.g_old_rec.ccm_attribute_category;
753: ben_ccm_shd.g_old_rec.business_group_id;
754: End If;
755: If (p_rec.ccm_attribute_category = hr_api.g_varchar2) then
756: p_rec.ccm_attribute_category :=
757: ben_ccm_shd.g_old_rec.ccm_attribute_category;
758: End If;
759: If (p_rec.ccm_attribute1 = hr_api.g_varchar2) then
760: p_rec.ccm_attribute1 :=
761: ben_ccm_shd.g_old_rec.ccm_attribute1;
757: ben_ccm_shd.g_old_rec.ccm_attribute_category;
758: End If;
759: If (p_rec.ccm_attribute1 = hr_api.g_varchar2) then
760: p_rec.ccm_attribute1 :=
761: ben_ccm_shd.g_old_rec.ccm_attribute1;
762: End If;
763: If (p_rec.ccm_attribute2 = hr_api.g_varchar2) then
764: p_rec.ccm_attribute2 :=
765: ben_ccm_shd.g_old_rec.ccm_attribute2;
761: ben_ccm_shd.g_old_rec.ccm_attribute1;
762: End If;
763: If (p_rec.ccm_attribute2 = hr_api.g_varchar2) then
764: p_rec.ccm_attribute2 :=
765: ben_ccm_shd.g_old_rec.ccm_attribute2;
766: End If;
767: If (p_rec.ccm_attribute3 = hr_api.g_varchar2) then
768: p_rec.ccm_attribute3 :=
769: ben_ccm_shd.g_old_rec.ccm_attribute3;
765: ben_ccm_shd.g_old_rec.ccm_attribute2;
766: End If;
767: If (p_rec.ccm_attribute3 = hr_api.g_varchar2) then
768: p_rec.ccm_attribute3 :=
769: ben_ccm_shd.g_old_rec.ccm_attribute3;
770: End If;
771: If (p_rec.ccm_attribute4 = hr_api.g_varchar2) then
772: p_rec.ccm_attribute4 :=
773: ben_ccm_shd.g_old_rec.ccm_attribute4;
769: ben_ccm_shd.g_old_rec.ccm_attribute3;
770: End If;
771: If (p_rec.ccm_attribute4 = hr_api.g_varchar2) then
772: p_rec.ccm_attribute4 :=
773: ben_ccm_shd.g_old_rec.ccm_attribute4;
774: End If;
775: If (p_rec.ccm_attribute5 = hr_api.g_varchar2) then
776: p_rec.ccm_attribute5 :=
777: ben_ccm_shd.g_old_rec.ccm_attribute5;
773: ben_ccm_shd.g_old_rec.ccm_attribute4;
774: End If;
775: If (p_rec.ccm_attribute5 = hr_api.g_varchar2) then
776: p_rec.ccm_attribute5 :=
777: ben_ccm_shd.g_old_rec.ccm_attribute5;
778: End If;
779: If (p_rec.ccm_attribute6 = hr_api.g_varchar2) then
780: p_rec.ccm_attribute6 :=
781: ben_ccm_shd.g_old_rec.ccm_attribute6;
777: ben_ccm_shd.g_old_rec.ccm_attribute5;
778: End If;
779: If (p_rec.ccm_attribute6 = hr_api.g_varchar2) then
780: p_rec.ccm_attribute6 :=
781: ben_ccm_shd.g_old_rec.ccm_attribute6;
782: End If;
783: If (p_rec.ccm_attribute7 = hr_api.g_varchar2) then
784: p_rec.ccm_attribute7 :=
785: ben_ccm_shd.g_old_rec.ccm_attribute7;
781: ben_ccm_shd.g_old_rec.ccm_attribute6;
782: End If;
783: If (p_rec.ccm_attribute7 = hr_api.g_varchar2) then
784: p_rec.ccm_attribute7 :=
785: ben_ccm_shd.g_old_rec.ccm_attribute7;
786: End If;
787: If (p_rec.ccm_attribute8 = hr_api.g_varchar2) then
788: p_rec.ccm_attribute8 :=
789: ben_ccm_shd.g_old_rec.ccm_attribute8;
785: ben_ccm_shd.g_old_rec.ccm_attribute7;
786: End If;
787: If (p_rec.ccm_attribute8 = hr_api.g_varchar2) then
788: p_rec.ccm_attribute8 :=
789: ben_ccm_shd.g_old_rec.ccm_attribute8;
790: End If;
791: If (p_rec.ccm_attribute9 = hr_api.g_varchar2) then
792: p_rec.ccm_attribute9 :=
793: ben_ccm_shd.g_old_rec.ccm_attribute9;
789: ben_ccm_shd.g_old_rec.ccm_attribute8;
790: End If;
791: If (p_rec.ccm_attribute9 = hr_api.g_varchar2) then
792: p_rec.ccm_attribute9 :=
793: ben_ccm_shd.g_old_rec.ccm_attribute9;
794: End If;
795: If (p_rec.ccm_attribute10 = hr_api.g_varchar2) then
796: p_rec.ccm_attribute10 :=
797: ben_ccm_shd.g_old_rec.ccm_attribute10;
793: ben_ccm_shd.g_old_rec.ccm_attribute9;
794: End If;
795: If (p_rec.ccm_attribute10 = hr_api.g_varchar2) then
796: p_rec.ccm_attribute10 :=
797: ben_ccm_shd.g_old_rec.ccm_attribute10;
798: End If;
799: If (p_rec.ccm_attribute11 = hr_api.g_varchar2) then
800: p_rec.ccm_attribute11 :=
801: ben_ccm_shd.g_old_rec.ccm_attribute11;
797: ben_ccm_shd.g_old_rec.ccm_attribute10;
798: End If;
799: If (p_rec.ccm_attribute11 = hr_api.g_varchar2) then
800: p_rec.ccm_attribute11 :=
801: ben_ccm_shd.g_old_rec.ccm_attribute11;
802: End If;
803: If (p_rec.ccm_attribute12 = hr_api.g_varchar2) then
804: p_rec.ccm_attribute12 :=
805: ben_ccm_shd.g_old_rec.ccm_attribute12;
801: ben_ccm_shd.g_old_rec.ccm_attribute11;
802: End If;
803: If (p_rec.ccm_attribute12 = hr_api.g_varchar2) then
804: p_rec.ccm_attribute12 :=
805: ben_ccm_shd.g_old_rec.ccm_attribute12;
806: End If;
807: If (p_rec.ccm_attribute13 = hr_api.g_varchar2) then
808: p_rec.ccm_attribute13 :=
809: ben_ccm_shd.g_old_rec.ccm_attribute13;
805: ben_ccm_shd.g_old_rec.ccm_attribute12;
806: End If;
807: If (p_rec.ccm_attribute13 = hr_api.g_varchar2) then
808: p_rec.ccm_attribute13 :=
809: ben_ccm_shd.g_old_rec.ccm_attribute13;
810: End If;
811: If (p_rec.ccm_attribute14 = hr_api.g_varchar2) then
812: p_rec.ccm_attribute14 :=
813: ben_ccm_shd.g_old_rec.ccm_attribute14;
809: ben_ccm_shd.g_old_rec.ccm_attribute13;
810: End If;
811: If (p_rec.ccm_attribute14 = hr_api.g_varchar2) then
812: p_rec.ccm_attribute14 :=
813: ben_ccm_shd.g_old_rec.ccm_attribute14;
814: End If;
815: If (p_rec.ccm_attribute15 = hr_api.g_varchar2) then
816: p_rec.ccm_attribute15 :=
817: ben_ccm_shd.g_old_rec.ccm_attribute15;
813: ben_ccm_shd.g_old_rec.ccm_attribute14;
814: End If;
815: If (p_rec.ccm_attribute15 = hr_api.g_varchar2) then
816: p_rec.ccm_attribute15 :=
817: ben_ccm_shd.g_old_rec.ccm_attribute15;
818: End If;
819: If (p_rec.ccm_attribute16 = hr_api.g_varchar2) then
820: p_rec.ccm_attribute16 :=
821: ben_ccm_shd.g_old_rec.ccm_attribute16;
817: ben_ccm_shd.g_old_rec.ccm_attribute15;
818: End If;
819: If (p_rec.ccm_attribute16 = hr_api.g_varchar2) then
820: p_rec.ccm_attribute16 :=
821: ben_ccm_shd.g_old_rec.ccm_attribute16;
822: End If;
823: If (p_rec.ccm_attribute17 = hr_api.g_varchar2) then
824: p_rec.ccm_attribute17 :=
825: ben_ccm_shd.g_old_rec.ccm_attribute17;
821: ben_ccm_shd.g_old_rec.ccm_attribute16;
822: End If;
823: If (p_rec.ccm_attribute17 = hr_api.g_varchar2) then
824: p_rec.ccm_attribute17 :=
825: ben_ccm_shd.g_old_rec.ccm_attribute17;
826: End If;
827: If (p_rec.ccm_attribute18 = hr_api.g_varchar2) then
828: p_rec.ccm_attribute18 :=
829: ben_ccm_shd.g_old_rec.ccm_attribute18;
825: ben_ccm_shd.g_old_rec.ccm_attribute17;
826: End If;
827: If (p_rec.ccm_attribute18 = hr_api.g_varchar2) then
828: p_rec.ccm_attribute18 :=
829: ben_ccm_shd.g_old_rec.ccm_attribute18;
830: End If;
831: If (p_rec.ccm_attribute19 = hr_api.g_varchar2) then
832: p_rec.ccm_attribute19 :=
833: ben_ccm_shd.g_old_rec.ccm_attribute19;
829: ben_ccm_shd.g_old_rec.ccm_attribute18;
830: End If;
831: If (p_rec.ccm_attribute19 = hr_api.g_varchar2) then
832: p_rec.ccm_attribute19 :=
833: ben_ccm_shd.g_old_rec.ccm_attribute19;
834: End If;
835: If (p_rec.ccm_attribute20 = hr_api.g_varchar2) then
836: p_rec.ccm_attribute20 :=
837: ben_ccm_shd.g_old_rec.ccm_attribute20;
833: ben_ccm_shd.g_old_rec.ccm_attribute19;
834: End If;
835: If (p_rec.ccm_attribute20 = hr_api.g_varchar2) then
836: p_rec.ccm_attribute20 :=
837: ben_ccm_shd.g_old_rec.ccm_attribute20;
838: End If;
839: If (p_rec.ccm_attribute21 = hr_api.g_varchar2) then
840: p_rec.ccm_attribute21 :=
841: ben_ccm_shd.g_old_rec.ccm_attribute21;
837: ben_ccm_shd.g_old_rec.ccm_attribute20;
838: End If;
839: If (p_rec.ccm_attribute21 = hr_api.g_varchar2) then
840: p_rec.ccm_attribute21 :=
841: ben_ccm_shd.g_old_rec.ccm_attribute21;
842: End If;
843: If (p_rec.ccm_attribute22 = hr_api.g_varchar2) then
844: p_rec.ccm_attribute22 :=
845: ben_ccm_shd.g_old_rec.ccm_attribute22;
841: ben_ccm_shd.g_old_rec.ccm_attribute21;
842: End If;
843: If (p_rec.ccm_attribute22 = hr_api.g_varchar2) then
844: p_rec.ccm_attribute22 :=
845: ben_ccm_shd.g_old_rec.ccm_attribute22;
846: End If;
847: If (p_rec.ccm_attribute23 = hr_api.g_varchar2) then
848: p_rec.ccm_attribute23 :=
849: ben_ccm_shd.g_old_rec.ccm_attribute23;
845: ben_ccm_shd.g_old_rec.ccm_attribute22;
846: End If;
847: If (p_rec.ccm_attribute23 = hr_api.g_varchar2) then
848: p_rec.ccm_attribute23 :=
849: ben_ccm_shd.g_old_rec.ccm_attribute23;
850: End If;
851: If (p_rec.ccm_attribute24 = hr_api.g_varchar2) then
852: p_rec.ccm_attribute24 :=
853: ben_ccm_shd.g_old_rec.ccm_attribute24;
849: ben_ccm_shd.g_old_rec.ccm_attribute23;
850: End If;
851: If (p_rec.ccm_attribute24 = hr_api.g_varchar2) then
852: p_rec.ccm_attribute24 :=
853: ben_ccm_shd.g_old_rec.ccm_attribute24;
854: End If;
855: If (p_rec.ccm_attribute25 = hr_api.g_varchar2) then
856: p_rec.ccm_attribute25 :=
857: ben_ccm_shd.g_old_rec.ccm_attribute25;
853: ben_ccm_shd.g_old_rec.ccm_attribute24;
854: End If;
855: If (p_rec.ccm_attribute25 = hr_api.g_varchar2) then
856: p_rec.ccm_attribute25 :=
857: ben_ccm_shd.g_old_rec.ccm_attribute25;
858: End If;
859: If (p_rec.ccm_attribute26 = hr_api.g_varchar2) then
860: p_rec.ccm_attribute26 :=
861: ben_ccm_shd.g_old_rec.ccm_attribute26;
857: ben_ccm_shd.g_old_rec.ccm_attribute25;
858: End If;
859: If (p_rec.ccm_attribute26 = hr_api.g_varchar2) then
860: p_rec.ccm_attribute26 :=
861: ben_ccm_shd.g_old_rec.ccm_attribute26;
862: End If;
863: If (p_rec.ccm_attribute27 = hr_api.g_varchar2) then
864: p_rec.ccm_attribute27 :=
865: ben_ccm_shd.g_old_rec.ccm_attribute27;
861: ben_ccm_shd.g_old_rec.ccm_attribute26;
862: End If;
863: If (p_rec.ccm_attribute27 = hr_api.g_varchar2) then
864: p_rec.ccm_attribute27 :=
865: ben_ccm_shd.g_old_rec.ccm_attribute27;
866: End If;
867: If (p_rec.ccm_attribute28 = hr_api.g_varchar2) then
868: p_rec.ccm_attribute28 :=
869: ben_ccm_shd.g_old_rec.ccm_attribute28;
865: ben_ccm_shd.g_old_rec.ccm_attribute27;
866: End If;
867: If (p_rec.ccm_attribute28 = hr_api.g_varchar2) then
868: p_rec.ccm_attribute28 :=
869: ben_ccm_shd.g_old_rec.ccm_attribute28;
870: End If;
871: If (p_rec.ccm_attribute29 = hr_api.g_varchar2) then
872: p_rec.ccm_attribute29 :=
873: ben_ccm_shd.g_old_rec.ccm_attribute29;
869: ben_ccm_shd.g_old_rec.ccm_attribute28;
870: End If;
871: If (p_rec.ccm_attribute29 = hr_api.g_varchar2) then
872: p_rec.ccm_attribute29 :=
873: ben_ccm_shd.g_old_rec.ccm_attribute29;
874: End If;
875: If (p_rec.ccm_attribute30 = hr_api.g_varchar2) then
876: p_rec.ccm_attribute30 :=
877: ben_ccm_shd.g_old_rec.ccm_attribute30;
873: ben_ccm_shd.g_old_rec.ccm_attribute29;
874: End If;
875: If (p_rec.ccm_attribute30 = hr_api.g_varchar2) then
876: p_rec.ccm_attribute30 :=
877: ben_ccm_shd.g_old_rec.ccm_attribute30;
878: End If;
879:
880: --
881: hr_utility.set_location(' Leaving:'||l_proc, 10);
886: -- |---------------------------------< upd >----------------------------------|
887: -- ----------------------------------------------------------------------------
888: Procedure upd
889: (
890: p_rec in out nocopy ben_ccm_shd.g_rec_type,
891: p_effective_date in date,
892: p_datetrack_mode in varchar2
893: ) is
894: --
904: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
905: --
906: -- We must lock the row which we need to update.
907: --
908: ben_ccm_shd.lck
909: (p_effective_date => p_effective_date,
910: p_datetrack_mode => p_datetrack_mode,
911: p_cvg_amt_calc_mthd_id => p_rec.cvg_amt_calc_mthd_id,
912: p_object_version_number => p_rec.object_version_number,
1027: p_effective_date in date,
1028: p_datetrack_mode in varchar2
1029: ) is
1030: --
1031: l_rec ben_ccm_shd.g_rec_type;
1032: l_proc varchar2(72) := g_package||'upd';
1033: --
1034: Begin
1035: hr_utility.set_location('Entering:'||l_proc, 5);
1037: -- Call conversion function to turn arguments into the
1038: -- l_rec structure.
1039: --
1040: l_rec :=
1041: ben_ccm_shd.convert_args
1042: (
1043: p_cvg_amt_calc_mthd_id,
1044: null,
1045: null,