[Home] [Help]
54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: Procedure dt_update_dml
58: (p_rec in out nocopy ben_lbr_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_ler_bnft_rstrn_f',
78: p_base_key_column => 'ler_bnft_rstrn_id',
79: p_base_key_value => p_rec.ler_bnft_rstrn_id);
80: --
81: ben_lbr_shd.g_api_dml := true; -- Set the api dml status
82: --
83: -- Update the ben_ler_bnft_rstrn_f Row
84: --
85: update ben_ler_bnft_rstrn_f
143: where ler_bnft_rstrn_id = p_rec.ler_bnft_rstrn_id
144: and effective_start_date = p_validation_start_date
145: and effective_end_date = p_validation_end_date;
146: --
147: ben_lbr_shd.g_api_dml := false; -- Unset the api dml status
148: --
149: -- Set the effective start and end dates
150: --
151: p_rec.effective_start_date := p_validation_start_date;
155: hr_utility.set_location(' Leaving:'||l_proc, 15);
156: Exception
157: When hr_api.check_integrity_violated Then
158: -- A check constraint has been violated
159: ben_lbr_shd.g_api_dml := false; -- Unset the api dml status
160: ben_lbr_shd.constraint_error
161: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
162: When hr_api.unique_integrity_violated Then
163: -- Unique integrity has been violated
156: Exception
157: When hr_api.check_integrity_violated Then
158: -- A check constraint has been violated
159: ben_lbr_shd.g_api_dml := false; -- Unset the api dml status
160: ben_lbr_shd.constraint_error
161: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
162: When hr_api.unique_integrity_violated Then
163: -- Unique integrity has been violated
164: ben_lbr_shd.g_api_dml := false; -- Unset the api dml status
160: ben_lbr_shd.constraint_error
161: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
162: When hr_api.unique_integrity_violated Then
163: -- Unique integrity has been violated
164: ben_lbr_shd.g_api_dml := false; -- Unset the api dml status
165: ben_lbr_shd.constraint_error
166: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
167: When Others Then
168: ben_lbr_shd.g_api_dml := false; -- Unset the api dml status
161: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
162: When hr_api.unique_integrity_violated Then
163: -- Unique integrity has been violated
164: ben_lbr_shd.g_api_dml := false; -- Unset the api dml status
165: ben_lbr_shd.constraint_error
166: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
167: When Others Then
168: ben_lbr_shd.g_api_dml := false; -- Unset the api dml status
169: Raise;
164: ben_lbr_shd.g_api_dml := false; -- Unset the api dml status
165: ben_lbr_shd.constraint_error
166: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
167: When Others Then
168: ben_lbr_shd.g_api_dml := false; -- Unset the api dml status
169: Raise;
170: End dt_update_dml;
171: --
172: -- ----------------------------------------------------------------------------
200: --
201: -- {End Of Comments}
202: -- ----------------------------------------------------------------------------
203: Procedure update_dml
204: (p_rec in out nocopy ben_lbr_shd.g_rec_type,
205: p_effective_date in date,
206: p_datetrack_mode in varchar2,
207: p_validation_start_date in date,
208: p_validation_end_date in date) is
264: --
265: -- {End Of Comments}
266: -- ----------------------------------------------------------------------------
267: Procedure dt_pre_update
268: (p_rec in out nocopy ben_lbr_shd.g_rec_type,
269: p_effective_date in date,
270: p_datetrack_mode in varchar2,
271: p_validation_start_date in date,
272: p_validation_end_date in date) is
280: hr_utility.set_location(l_proc, 10);
281: --
282: -- Update the current effective end date
283: --
284: ben_lbr_shd.upd_effective_end_date
285: (p_effective_date => p_effective_date,
286: p_base_key_value => p_rec.ler_bnft_rstrn_id,
287: p_new_effective_end_date => (p_validation_start_date - 1),
288: p_validation_start_date => p_validation_start_date,
349: --
350: -- {End Of Comments}
351: -- ----------------------------------------------------------------------------
352: Procedure pre_update
353: (p_rec in out nocopy ben_lbr_shd.g_rec_type,
354: p_effective_date in date,
355: p_datetrack_mode in varchar2,
356: p_validation_start_date in date,
357: p_validation_end_date in date) is
405: --
406: -- {End Of Comments}
407: -- ----------------------------------------------------------------------------
408: Procedure post_update
409: (p_rec in ben_lbr_shd.g_rec_type,
410: p_effective_date in date,
411: p_datetrack_mode in varchar2,
412: p_validation_start_date in date,
413: p_validation_end_date in date) is
485: ,p_effective_date =>p_effective_date
486: ,p_datetrack_mode =>p_datetrack_mode
487: ,p_validation_start_date =>p_validation_start_date
488: ,p_validation_end_date =>p_validation_end_date
489: ,p_effective_start_date_o =>ben_lbr_shd.g_old_rec.effective_start_date
490: ,p_effective_end_date_o =>ben_lbr_shd.g_old_rec.effective_end_date
491: ,p_no_mx_cvg_amt_apls_flag_o =>ben_lbr_shd.g_old_rec.no_mx_cvg_amt_apls_flag
492: ,p_no_mn_cvg_incr_apls_flag_o =>ben_lbr_shd.g_old_rec.no_mn_cvg_incr_apls_flag
493: ,p_no_mx_cvg_incr_apls_flag_o =>ben_lbr_shd.g_old_rec.no_mx_cvg_incr_apls_flag
486: ,p_datetrack_mode =>p_datetrack_mode
487: ,p_validation_start_date =>p_validation_start_date
488: ,p_validation_end_date =>p_validation_end_date
489: ,p_effective_start_date_o =>ben_lbr_shd.g_old_rec.effective_start_date
490: ,p_effective_end_date_o =>ben_lbr_shd.g_old_rec.effective_end_date
491: ,p_no_mx_cvg_amt_apls_flag_o =>ben_lbr_shd.g_old_rec.no_mx_cvg_amt_apls_flag
492: ,p_no_mn_cvg_incr_apls_flag_o =>ben_lbr_shd.g_old_rec.no_mn_cvg_incr_apls_flag
493: ,p_no_mx_cvg_incr_apls_flag_o =>ben_lbr_shd.g_old_rec.no_mx_cvg_incr_apls_flag
494: ,p_mx_cvg_incr_wcf_alwd_amt_o =>ben_lbr_shd.g_old_rec.mx_cvg_incr_wcf_alwd_amt
487: ,p_validation_start_date =>p_validation_start_date
488: ,p_validation_end_date =>p_validation_end_date
489: ,p_effective_start_date_o =>ben_lbr_shd.g_old_rec.effective_start_date
490: ,p_effective_end_date_o =>ben_lbr_shd.g_old_rec.effective_end_date
491: ,p_no_mx_cvg_amt_apls_flag_o =>ben_lbr_shd.g_old_rec.no_mx_cvg_amt_apls_flag
492: ,p_no_mn_cvg_incr_apls_flag_o =>ben_lbr_shd.g_old_rec.no_mn_cvg_incr_apls_flag
493: ,p_no_mx_cvg_incr_apls_flag_o =>ben_lbr_shd.g_old_rec.no_mx_cvg_incr_apls_flag
494: ,p_mx_cvg_incr_wcf_alwd_amt_o =>ben_lbr_shd.g_old_rec.mx_cvg_incr_wcf_alwd_amt
495: ,p_mx_cvg_incr_alwd_amt_o =>ben_lbr_shd.g_old_rec.mx_cvg_incr_alwd_amt
488: ,p_validation_end_date =>p_validation_end_date
489: ,p_effective_start_date_o =>ben_lbr_shd.g_old_rec.effective_start_date
490: ,p_effective_end_date_o =>ben_lbr_shd.g_old_rec.effective_end_date
491: ,p_no_mx_cvg_amt_apls_flag_o =>ben_lbr_shd.g_old_rec.no_mx_cvg_amt_apls_flag
492: ,p_no_mn_cvg_incr_apls_flag_o =>ben_lbr_shd.g_old_rec.no_mn_cvg_incr_apls_flag
493: ,p_no_mx_cvg_incr_apls_flag_o =>ben_lbr_shd.g_old_rec.no_mx_cvg_incr_apls_flag
494: ,p_mx_cvg_incr_wcf_alwd_amt_o =>ben_lbr_shd.g_old_rec.mx_cvg_incr_wcf_alwd_amt
495: ,p_mx_cvg_incr_alwd_amt_o =>ben_lbr_shd.g_old_rec.mx_cvg_incr_alwd_amt
496: ,p_mx_cvg_alwd_amt_o =>ben_lbr_shd.g_old_rec.mx_cvg_alwd_amt
489: ,p_effective_start_date_o =>ben_lbr_shd.g_old_rec.effective_start_date
490: ,p_effective_end_date_o =>ben_lbr_shd.g_old_rec.effective_end_date
491: ,p_no_mx_cvg_amt_apls_flag_o =>ben_lbr_shd.g_old_rec.no_mx_cvg_amt_apls_flag
492: ,p_no_mn_cvg_incr_apls_flag_o =>ben_lbr_shd.g_old_rec.no_mn_cvg_incr_apls_flag
493: ,p_no_mx_cvg_incr_apls_flag_o =>ben_lbr_shd.g_old_rec.no_mx_cvg_incr_apls_flag
494: ,p_mx_cvg_incr_wcf_alwd_amt_o =>ben_lbr_shd.g_old_rec.mx_cvg_incr_wcf_alwd_amt
495: ,p_mx_cvg_incr_alwd_amt_o =>ben_lbr_shd.g_old_rec.mx_cvg_incr_alwd_amt
496: ,p_mx_cvg_alwd_amt_o =>ben_lbr_shd.g_old_rec.mx_cvg_alwd_amt
497: ,p_mx_cvg_mlt_incr_num_o =>ben_lbr_shd.g_old_rec.mx_cvg_mlt_incr_num
490: ,p_effective_end_date_o =>ben_lbr_shd.g_old_rec.effective_end_date
491: ,p_no_mx_cvg_amt_apls_flag_o =>ben_lbr_shd.g_old_rec.no_mx_cvg_amt_apls_flag
492: ,p_no_mn_cvg_incr_apls_flag_o =>ben_lbr_shd.g_old_rec.no_mn_cvg_incr_apls_flag
493: ,p_no_mx_cvg_incr_apls_flag_o =>ben_lbr_shd.g_old_rec.no_mx_cvg_incr_apls_flag
494: ,p_mx_cvg_incr_wcf_alwd_amt_o =>ben_lbr_shd.g_old_rec.mx_cvg_incr_wcf_alwd_amt
495: ,p_mx_cvg_incr_alwd_amt_o =>ben_lbr_shd.g_old_rec.mx_cvg_incr_alwd_amt
496: ,p_mx_cvg_alwd_amt_o =>ben_lbr_shd.g_old_rec.mx_cvg_alwd_amt
497: ,p_mx_cvg_mlt_incr_num_o =>ben_lbr_shd.g_old_rec.mx_cvg_mlt_incr_num
498: ,p_mx_cvg_mlt_incr_wcf_num_o =>ben_lbr_shd.g_old_rec.mx_cvg_mlt_incr_wcf_num
491: ,p_no_mx_cvg_amt_apls_flag_o =>ben_lbr_shd.g_old_rec.no_mx_cvg_amt_apls_flag
492: ,p_no_mn_cvg_incr_apls_flag_o =>ben_lbr_shd.g_old_rec.no_mn_cvg_incr_apls_flag
493: ,p_no_mx_cvg_incr_apls_flag_o =>ben_lbr_shd.g_old_rec.no_mx_cvg_incr_apls_flag
494: ,p_mx_cvg_incr_wcf_alwd_amt_o =>ben_lbr_shd.g_old_rec.mx_cvg_incr_wcf_alwd_amt
495: ,p_mx_cvg_incr_alwd_amt_o =>ben_lbr_shd.g_old_rec.mx_cvg_incr_alwd_amt
496: ,p_mx_cvg_alwd_amt_o =>ben_lbr_shd.g_old_rec.mx_cvg_alwd_amt
497: ,p_mx_cvg_mlt_incr_num_o =>ben_lbr_shd.g_old_rec.mx_cvg_mlt_incr_num
498: ,p_mx_cvg_mlt_incr_wcf_num_o =>ben_lbr_shd.g_old_rec.mx_cvg_mlt_incr_wcf_num
499: ,p_mx_cvg_rl_o =>ben_lbr_shd.g_old_rec.mx_cvg_rl
492: ,p_no_mn_cvg_incr_apls_flag_o =>ben_lbr_shd.g_old_rec.no_mn_cvg_incr_apls_flag
493: ,p_no_mx_cvg_incr_apls_flag_o =>ben_lbr_shd.g_old_rec.no_mx_cvg_incr_apls_flag
494: ,p_mx_cvg_incr_wcf_alwd_amt_o =>ben_lbr_shd.g_old_rec.mx_cvg_incr_wcf_alwd_amt
495: ,p_mx_cvg_incr_alwd_amt_o =>ben_lbr_shd.g_old_rec.mx_cvg_incr_alwd_amt
496: ,p_mx_cvg_alwd_amt_o =>ben_lbr_shd.g_old_rec.mx_cvg_alwd_amt
497: ,p_mx_cvg_mlt_incr_num_o =>ben_lbr_shd.g_old_rec.mx_cvg_mlt_incr_num
498: ,p_mx_cvg_mlt_incr_wcf_num_o =>ben_lbr_shd.g_old_rec.mx_cvg_mlt_incr_wcf_num
499: ,p_mx_cvg_rl_o =>ben_lbr_shd.g_old_rec.mx_cvg_rl
500: ,p_mx_cvg_wcfn_amt_o =>ben_lbr_shd.g_old_rec.mx_cvg_wcfn_amt
493: ,p_no_mx_cvg_incr_apls_flag_o =>ben_lbr_shd.g_old_rec.no_mx_cvg_incr_apls_flag
494: ,p_mx_cvg_incr_wcf_alwd_amt_o =>ben_lbr_shd.g_old_rec.mx_cvg_incr_wcf_alwd_amt
495: ,p_mx_cvg_incr_alwd_amt_o =>ben_lbr_shd.g_old_rec.mx_cvg_incr_alwd_amt
496: ,p_mx_cvg_alwd_amt_o =>ben_lbr_shd.g_old_rec.mx_cvg_alwd_amt
497: ,p_mx_cvg_mlt_incr_num_o =>ben_lbr_shd.g_old_rec.mx_cvg_mlt_incr_num
498: ,p_mx_cvg_mlt_incr_wcf_num_o =>ben_lbr_shd.g_old_rec.mx_cvg_mlt_incr_wcf_num
499: ,p_mx_cvg_rl_o =>ben_lbr_shd.g_old_rec.mx_cvg_rl
500: ,p_mx_cvg_wcfn_amt_o =>ben_lbr_shd.g_old_rec.mx_cvg_wcfn_amt
501: ,p_mx_cvg_wcfn_mlt_num_o =>ben_lbr_shd.g_old_rec.mx_cvg_wcfn_mlt_num
494: ,p_mx_cvg_incr_wcf_alwd_amt_o =>ben_lbr_shd.g_old_rec.mx_cvg_incr_wcf_alwd_amt
495: ,p_mx_cvg_incr_alwd_amt_o =>ben_lbr_shd.g_old_rec.mx_cvg_incr_alwd_amt
496: ,p_mx_cvg_alwd_amt_o =>ben_lbr_shd.g_old_rec.mx_cvg_alwd_amt
497: ,p_mx_cvg_mlt_incr_num_o =>ben_lbr_shd.g_old_rec.mx_cvg_mlt_incr_num
498: ,p_mx_cvg_mlt_incr_wcf_num_o =>ben_lbr_shd.g_old_rec.mx_cvg_mlt_incr_wcf_num
499: ,p_mx_cvg_rl_o =>ben_lbr_shd.g_old_rec.mx_cvg_rl
500: ,p_mx_cvg_wcfn_amt_o =>ben_lbr_shd.g_old_rec.mx_cvg_wcfn_amt
501: ,p_mx_cvg_wcfn_mlt_num_o =>ben_lbr_shd.g_old_rec.mx_cvg_wcfn_mlt_num
502: ,p_mn_cvg_amt_o =>ben_lbr_shd.g_old_rec.mn_cvg_amt
495: ,p_mx_cvg_incr_alwd_amt_o =>ben_lbr_shd.g_old_rec.mx_cvg_incr_alwd_amt
496: ,p_mx_cvg_alwd_amt_o =>ben_lbr_shd.g_old_rec.mx_cvg_alwd_amt
497: ,p_mx_cvg_mlt_incr_num_o =>ben_lbr_shd.g_old_rec.mx_cvg_mlt_incr_num
498: ,p_mx_cvg_mlt_incr_wcf_num_o =>ben_lbr_shd.g_old_rec.mx_cvg_mlt_incr_wcf_num
499: ,p_mx_cvg_rl_o =>ben_lbr_shd.g_old_rec.mx_cvg_rl
500: ,p_mx_cvg_wcfn_amt_o =>ben_lbr_shd.g_old_rec.mx_cvg_wcfn_amt
501: ,p_mx_cvg_wcfn_mlt_num_o =>ben_lbr_shd.g_old_rec.mx_cvg_wcfn_mlt_num
502: ,p_mn_cvg_amt_o =>ben_lbr_shd.g_old_rec.mn_cvg_amt
503: ,p_mn_cvg_rl_o =>ben_lbr_shd.g_old_rec.mn_cvg_rl
496: ,p_mx_cvg_alwd_amt_o =>ben_lbr_shd.g_old_rec.mx_cvg_alwd_amt
497: ,p_mx_cvg_mlt_incr_num_o =>ben_lbr_shd.g_old_rec.mx_cvg_mlt_incr_num
498: ,p_mx_cvg_mlt_incr_wcf_num_o =>ben_lbr_shd.g_old_rec.mx_cvg_mlt_incr_wcf_num
499: ,p_mx_cvg_rl_o =>ben_lbr_shd.g_old_rec.mx_cvg_rl
500: ,p_mx_cvg_wcfn_amt_o =>ben_lbr_shd.g_old_rec.mx_cvg_wcfn_amt
501: ,p_mx_cvg_wcfn_mlt_num_o =>ben_lbr_shd.g_old_rec.mx_cvg_wcfn_mlt_num
502: ,p_mn_cvg_amt_o =>ben_lbr_shd.g_old_rec.mn_cvg_amt
503: ,p_mn_cvg_rl_o =>ben_lbr_shd.g_old_rec.mn_cvg_rl
504: ,p_cvg_incr_r_decr_only_cd_o =>ben_lbr_shd.g_old_rec.cvg_incr_r_decr_only_cd
497: ,p_mx_cvg_mlt_incr_num_o =>ben_lbr_shd.g_old_rec.mx_cvg_mlt_incr_num
498: ,p_mx_cvg_mlt_incr_wcf_num_o =>ben_lbr_shd.g_old_rec.mx_cvg_mlt_incr_wcf_num
499: ,p_mx_cvg_rl_o =>ben_lbr_shd.g_old_rec.mx_cvg_rl
500: ,p_mx_cvg_wcfn_amt_o =>ben_lbr_shd.g_old_rec.mx_cvg_wcfn_amt
501: ,p_mx_cvg_wcfn_mlt_num_o =>ben_lbr_shd.g_old_rec.mx_cvg_wcfn_mlt_num
502: ,p_mn_cvg_amt_o =>ben_lbr_shd.g_old_rec.mn_cvg_amt
503: ,p_mn_cvg_rl_o =>ben_lbr_shd.g_old_rec.mn_cvg_rl
504: ,p_cvg_incr_r_decr_only_cd_o =>ben_lbr_shd.g_old_rec.cvg_incr_r_decr_only_cd
505: ,p_unsspnd_enrt_cd_o =>ben_lbr_shd.g_old_rec.unsspnd_enrt_cd
498: ,p_mx_cvg_mlt_incr_wcf_num_o =>ben_lbr_shd.g_old_rec.mx_cvg_mlt_incr_wcf_num
499: ,p_mx_cvg_rl_o =>ben_lbr_shd.g_old_rec.mx_cvg_rl
500: ,p_mx_cvg_wcfn_amt_o =>ben_lbr_shd.g_old_rec.mx_cvg_wcfn_amt
501: ,p_mx_cvg_wcfn_mlt_num_o =>ben_lbr_shd.g_old_rec.mx_cvg_wcfn_mlt_num
502: ,p_mn_cvg_amt_o =>ben_lbr_shd.g_old_rec.mn_cvg_amt
503: ,p_mn_cvg_rl_o =>ben_lbr_shd.g_old_rec.mn_cvg_rl
504: ,p_cvg_incr_r_decr_only_cd_o =>ben_lbr_shd.g_old_rec.cvg_incr_r_decr_only_cd
505: ,p_unsspnd_enrt_cd_o =>ben_lbr_shd.g_old_rec.unsspnd_enrt_cd
506: ,p_dflt_to_asn_pndg_ctfn_cd_o =>ben_lbr_shd.g_old_rec.dflt_to_asn_pndg_ctfn_cd
499: ,p_mx_cvg_rl_o =>ben_lbr_shd.g_old_rec.mx_cvg_rl
500: ,p_mx_cvg_wcfn_amt_o =>ben_lbr_shd.g_old_rec.mx_cvg_wcfn_amt
501: ,p_mx_cvg_wcfn_mlt_num_o =>ben_lbr_shd.g_old_rec.mx_cvg_wcfn_mlt_num
502: ,p_mn_cvg_amt_o =>ben_lbr_shd.g_old_rec.mn_cvg_amt
503: ,p_mn_cvg_rl_o =>ben_lbr_shd.g_old_rec.mn_cvg_rl
504: ,p_cvg_incr_r_decr_only_cd_o =>ben_lbr_shd.g_old_rec.cvg_incr_r_decr_only_cd
505: ,p_unsspnd_enrt_cd_o =>ben_lbr_shd.g_old_rec.unsspnd_enrt_cd
506: ,p_dflt_to_asn_pndg_ctfn_cd_o =>ben_lbr_shd.g_old_rec.dflt_to_asn_pndg_ctfn_cd
507: ,p_dflt_to_asn_pndg_ctfn_rl_o =>ben_lbr_shd.g_old_rec.dflt_to_asn_pndg_ctfn_rl
500: ,p_mx_cvg_wcfn_amt_o =>ben_lbr_shd.g_old_rec.mx_cvg_wcfn_amt
501: ,p_mx_cvg_wcfn_mlt_num_o =>ben_lbr_shd.g_old_rec.mx_cvg_wcfn_mlt_num
502: ,p_mn_cvg_amt_o =>ben_lbr_shd.g_old_rec.mn_cvg_amt
503: ,p_mn_cvg_rl_o =>ben_lbr_shd.g_old_rec.mn_cvg_rl
504: ,p_cvg_incr_r_decr_only_cd_o =>ben_lbr_shd.g_old_rec.cvg_incr_r_decr_only_cd
505: ,p_unsspnd_enrt_cd_o =>ben_lbr_shd.g_old_rec.unsspnd_enrt_cd
506: ,p_dflt_to_asn_pndg_ctfn_cd_o =>ben_lbr_shd.g_old_rec.dflt_to_asn_pndg_ctfn_cd
507: ,p_dflt_to_asn_pndg_ctfn_rl_o =>ben_lbr_shd.g_old_rec.dflt_to_asn_pndg_ctfn_rl
508: ,p_ler_id_o =>ben_lbr_shd.g_old_rec.ler_id
501: ,p_mx_cvg_wcfn_mlt_num_o =>ben_lbr_shd.g_old_rec.mx_cvg_wcfn_mlt_num
502: ,p_mn_cvg_amt_o =>ben_lbr_shd.g_old_rec.mn_cvg_amt
503: ,p_mn_cvg_rl_o =>ben_lbr_shd.g_old_rec.mn_cvg_rl
504: ,p_cvg_incr_r_decr_only_cd_o =>ben_lbr_shd.g_old_rec.cvg_incr_r_decr_only_cd
505: ,p_unsspnd_enrt_cd_o =>ben_lbr_shd.g_old_rec.unsspnd_enrt_cd
506: ,p_dflt_to_asn_pndg_ctfn_cd_o =>ben_lbr_shd.g_old_rec.dflt_to_asn_pndg_ctfn_cd
507: ,p_dflt_to_asn_pndg_ctfn_rl_o =>ben_lbr_shd.g_old_rec.dflt_to_asn_pndg_ctfn_rl
508: ,p_ler_id_o =>ben_lbr_shd.g_old_rec.ler_id
509: ,p_pl_id_o =>ben_lbr_shd.g_old_rec.pl_id
502: ,p_mn_cvg_amt_o =>ben_lbr_shd.g_old_rec.mn_cvg_amt
503: ,p_mn_cvg_rl_o =>ben_lbr_shd.g_old_rec.mn_cvg_rl
504: ,p_cvg_incr_r_decr_only_cd_o =>ben_lbr_shd.g_old_rec.cvg_incr_r_decr_only_cd
505: ,p_unsspnd_enrt_cd_o =>ben_lbr_shd.g_old_rec.unsspnd_enrt_cd
506: ,p_dflt_to_asn_pndg_ctfn_cd_o =>ben_lbr_shd.g_old_rec.dflt_to_asn_pndg_ctfn_cd
507: ,p_dflt_to_asn_pndg_ctfn_rl_o =>ben_lbr_shd.g_old_rec.dflt_to_asn_pndg_ctfn_rl
508: ,p_ler_id_o =>ben_lbr_shd.g_old_rec.ler_id
509: ,p_pl_id_o =>ben_lbr_shd.g_old_rec.pl_id
510: ,p_business_group_id_o =>ben_lbr_shd.g_old_rec.business_group_id
503: ,p_mn_cvg_rl_o =>ben_lbr_shd.g_old_rec.mn_cvg_rl
504: ,p_cvg_incr_r_decr_only_cd_o =>ben_lbr_shd.g_old_rec.cvg_incr_r_decr_only_cd
505: ,p_unsspnd_enrt_cd_o =>ben_lbr_shd.g_old_rec.unsspnd_enrt_cd
506: ,p_dflt_to_asn_pndg_ctfn_cd_o =>ben_lbr_shd.g_old_rec.dflt_to_asn_pndg_ctfn_cd
507: ,p_dflt_to_asn_pndg_ctfn_rl_o =>ben_lbr_shd.g_old_rec.dflt_to_asn_pndg_ctfn_rl
508: ,p_ler_id_o =>ben_lbr_shd.g_old_rec.ler_id
509: ,p_pl_id_o =>ben_lbr_shd.g_old_rec.pl_id
510: ,p_business_group_id_o =>ben_lbr_shd.g_old_rec.business_group_id
511: ,p_plip_id_o =>ben_lbr_shd.g_old_rec.plip_id
504: ,p_cvg_incr_r_decr_only_cd_o =>ben_lbr_shd.g_old_rec.cvg_incr_r_decr_only_cd
505: ,p_unsspnd_enrt_cd_o =>ben_lbr_shd.g_old_rec.unsspnd_enrt_cd
506: ,p_dflt_to_asn_pndg_ctfn_cd_o =>ben_lbr_shd.g_old_rec.dflt_to_asn_pndg_ctfn_cd
507: ,p_dflt_to_asn_pndg_ctfn_rl_o =>ben_lbr_shd.g_old_rec.dflt_to_asn_pndg_ctfn_rl
508: ,p_ler_id_o =>ben_lbr_shd.g_old_rec.ler_id
509: ,p_pl_id_o =>ben_lbr_shd.g_old_rec.pl_id
510: ,p_business_group_id_o =>ben_lbr_shd.g_old_rec.business_group_id
511: ,p_plip_id_o =>ben_lbr_shd.g_old_rec.plip_id
512: ,p_lbr_attribute_category_o =>ben_lbr_shd.g_old_rec.lbr_attribute_category
505: ,p_unsspnd_enrt_cd_o =>ben_lbr_shd.g_old_rec.unsspnd_enrt_cd
506: ,p_dflt_to_asn_pndg_ctfn_cd_o =>ben_lbr_shd.g_old_rec.dflt_to_asn_pndg_ctfn_cd
507: ,p_dflt_to_asn_pndg_ctfn_rl_o =>ben_lbr_shd.g_old_rec.dflt_to_asn_pndg_ctfn_rl
508: ,p_ler_id_o =>ben_lbr_shd.g_old_rec.ler_id
509: ,p_pl_id_o =>ben_lbr_shd.g_old_rec.pl_id
510: ,p_business_group_id_o =>ben_lbr_shd.g_old_rec.business_group_id
511: ,p_plip_id_o =>ben_lbr_shd.g_old_rec.plip_id
512: ,p_lbr_attribute_category_o =>ben_lbr_shd.g_old_rec.lbr_attribute_category
513: ,p_lbr_attribute1_o =>ben_lbr_shd.g_old_rec.lbr_attribute1
506: ,p_dflt_to_asn_pndg_ctfn_cd_o =>ben_lbr_shd.g_old_rec.dflt_to_asn_pndg_ctfn_cd
507: ,p_dflt_to_asn_pndg_ctfn_rl_o =>ben_lbr_shd.g_old_rec.dflt_to_asn_pndg_ctfn_rl
508: ,p_ler_id_o =>ben_lbr_shd.g_old_rec.ler_id
509: ,p_pl_id_o =>ben_lbr_shd.g_old_rec.pl_id
510: ,p_business_group_id_o =>ben_lbr_shd.g_old_rec.business_group_id
511: ,p_plip_id_o =>ben_lbr_shd.g_old_rec.plip_id
512: ,p_lbr_attribute_category_o =>ben_lbr_shd.g_old_rec.lbr_attribute_category
513: ,p_lbr_attribute1_o =>ben_lbr_shd.g_old_rec.lbr_attribute1
514: ,p_lbr_attribute2_o =>ben_lbr_shd.g_old_rec.lbr_attribute2
507: ,p_dflt_to_asn_pndg_ctfn_rl_o =>ben_lbr_shd.g_old_rec.dflt_to_asn_pndg_ctfn_rl
508: ,p_ler_id_o =>ben_lbr_shd.g_old_rec.ler_id
509: ,p_pl_id_o =>ben_lbr_shd.g_old_rec.pl_id
510: ,p_business_group_id_o =>ben_lbr_shd.g_old_rec.business_group_id
511: ,p_plip_id_o =>ben_lbr_shd.g_old_rec.plip_id
512: ,p_lbr_attribute_category_o =>ben_lbr_shd.g_old_rec.lbr_attribute_category
513: ,p_lbr_attribute1_o =>ben_lbr_shd.g_old_rec.lbr_attribute1
514: ,p_lbr_attribute2_o =>ben_lbr_shd.g_old_rec.lbr_attribute2
515: ,p_lbr_attribute3_o =>ben_lbr_shd.g_old_rec.lbr_attribute3
508: ,p_ler_id_o =>ben_lbr_shd.g_old_rec.ler_id
509: ,p_pl_id_o =>ben_lbr_shd.g_old_rec.pl_id
510: ,p_business_group_id_o =>ben_lbr_shd.g_old_rec.business_group_id
511: ,p_plip_id_o =>ben_lbr_shd.g_old_rec.plip_id
512: ,p_lbr_attribute_category_o =>ben_lbr_shd.g_old_rec.lbr_attribute_category
513: ,p_lbr_attribute1_o =>ben_lbr_shd.g_old_rec.lbr_attribute1
514: ,p_lbr_attribute2_o =>ben_lbr_shd.g_old_rec.lbr_attribute2
515: ,p_lbr_attribute3_o =>ben_lbr_shd.g_old_rec.lbr_attribute3
516: ,p_lbr_attribute4_o =>ben_lbr_shd.g_old_rec.lbr_attribute4
509: ,p_pl_id_o =>ben_lbr_shd.g_old_rec.pl_id
510: ,p_business_group_id_o =>ben_lbr_shd.g_old_rec.business_group_id
511: ,p_plip_id_o =>ben_lbr_shd.g_old_rec.plip_id
512: ,p_lbr_attribute_category_o =>ben_lbr_shd.g_old_rec.lbr_attribute_category
513: ,p_lbr_attribute1_o =>ben_lbr_shd.g_old_rec.lbr_attribute1
514: ,p_lbr_attribute2_o =>ben_lbr_shd.g_old_rec.lbr_attribute2
515: ,p_lbr_attribute3_o =>ben_lbr_shd.g_old_rec.lbr_attribute3
516: ,p_lbr_attribute4_o =>ben_lbr_shd.g_old_rec.lbr_attribute4
517: ,p_lbr_attribute5_o =>ben_lbr_shd.g_old_rec.lbr_attribute5
510: ,p_business_group_id_o =>ben_lbr_shd.g_old_rec.business_group_id
511: ,p_plip_id_o =>ben_lbr_shd.g_old_rec.plip_id
512: ,p_lbr_attribute_category_o =>ben_lbr_shd.g_old_rec.lbr_attribute_category
513: ,p_lbr_attribute1_o =>ben_lbr_shd.g_old_rec.lbr_attribute1
514: ,p_lbr_attribute2_o =>ben_lbr_shd.g_old_rec.lbr_attribute2
515: ,p_lbr_attribute3_o =>ben_lbr_shd.g_old_rec.lbr_attribute3
516: ,p_lbr_attribute4_o =>ben_lbr_shd.g_old_rec.lbr_attribute4
517: ,p_lbr_attribute5_o =>ben_lbr_shd.g_old_rec.lbr_attribute5
518: ,p_lbr_attribute6_o =>ben_lbr_shd.g_old_rec.lbr_attribute6
511: ,p_plip_id_o =>ben_lbr_shd.g_old_rec.plip_id
512: ,p_lbr_attribute_category_o =>ben_lbr_shd.g_old_rec.lbr_attribute_category
513: ,p_lbr_attribute1_o =>ben_lbr_shd.g_old_rec.lbr_attribute1
514: ,p_lbr_attribute2_o =>ben_lbr_shd.g_old_rec.lbr_attribute2
515: ,p_lbr_attribute3_o =>ben_lbr_shd.g_old_rec.lbr_attribute3
516: ,p_lbr_attribute4_o =>ben_lbr_shd.g_old_rec.lbr_attribute4
517: ,p_lbr_attribute5_o =>ben_lbr_shd.g_old_rec.lbr_attribute5
518: ,p_lbr_attribute6_o =>ben_lbr_shd.g_old_rec.lbr_attribute6
519: ,p_lbr_attribute7_o =>ben_lbr_shd.g_old_rec.lbr_attribute7
512: ,p_lbr_attribute_category_o =>ben_lbr_shd.g_old_rec.lbr_attribute_category
513: ,p_lbr_attribute1_o =>ben_lbr_shd.g_old_rec.lbr_attribute1
514: ,p_lbr_attribute2_o =>ben_lbr_shd.g_old_rec.lbr_attribute2
515: ,p_lbr_attribute3_o =>ben_lbr_shd.g_old_rec.lbr_attribute3
516: ,p_lbr_attribute4_o =>ben_lbr_shd.g_old_rec.lbr_attribute4
517: ,p_lbr_attribute5_o =>ben_lbr_shd.g_old_rec.lbr_attribute5
518: ,p_lbr_attribute6_o =>ben_lbr_shd.g_old_rec.lbr_attribute6
519: ,p_lbr_attribute7_o =>ben_lbr_shd.g_old_rec.lbr_attribute7
520: ,p_lbr_attribute8_o =>ben_lbr_shd.g_old_rec.lbr_attribute8
513: ,p_lbr_attribute1_o =>ben_lbr_shd.g_old_rec.lbr_attribute1
514: ,p_lbr_attribute2_o =>ben_lbr_shd.g_old_rec.lbr_attribute2
515: ,p_lbr_attribute3_o =>ben_lbr_shd.g_old_rec.lbr_attribute3
516: ,p_lbr_attribute4_o =>ben_lbr_shd.g_old_rec.lbr_attribute4
517: ,p_lbr_attribute5_o =>ben_lbr_shd.g_old_rec.lbr_attribute5
518: ,p_lbr_attribute6_o =>ben_lbr_shd.g_old_rec.lbr_attribute6
519: ,p_lbr_attribute7_o =>ben_lbr_shd.g_old_rec.lbr_attribute7
520: ,p_lbr_attribute8_o =>ben_lbr_shd.g_old_rec.lbr_attribute8
521: ,p_lbr_attribute9_o =>ben_lbr_shd.g_old_rec.lbr_attribute9
514: ,p_lbr_attribute2_o =>ben_lbr_shd.g_old_rec.lbr_attribute2
515: ,p_lbr_attribute3_o =>ben_lbr_shd.g_old_rec.lbr_attribute3
516: ,p_lbr_attribute4_o =>ben_lbr_shd.g_old_rec.lbr_attribute4
517: ,p_lbr_attribute5_o =>ben_lbr_shd.g_old_rec.lbr_attribute5
518: ,p_lbr_attribute6_o =>ben_lbr_shd.g_old_rec.lbr_attribute6
519: ,p_lbr_attribute7_o =>ben_lbr_shd.g_old_rec.lbr_attribute7
520: ,p_lbr_attribute8_o =>ben_lbr_shd.g_old_rec.lbr_attribute8
521: ,p_lbr_attribute9_o =>ben_lbr_shd.g_old_rec.lbr_attribute9
522: ,p_lbr_attribute10_o =>ben_lbr_shd.g_old_rec.lbr_attribute10
515: ,p_lbr_attribute3_o =>ben_lbr_shd.g_old_rec.lbr_attribute3
516: ,p_lbr_attribute4_o =>ben_lbr_shd.g_old_rec.lbr_attribute4
517: ,p_lbr_attribute5_o =>ben_lbr_shd.g_old_rec.lbr_attribute5
518: ,p_lbr_attribute6_o =>ben_lbr_shd.g_old_rec.lbr_attribute6
519: ,p_lbr_attribute7_o =>ben_lbr_shd.g_old_rec.lbr_attribute7
520: ,p_lbr_attribute8_o =>ben_lbr_shd.g_old_rec.lbr_attribute8
521: ,p_lbr_attribute9_o =>ben_lbr_shd.g_old_rec.lbr_attribute9
522: ,p_lbr_attribute10_o =>ben_lbr_shd.g_old_rec.lbr_attribute10
523: ,p_lbr_attribute11_o =>ben_lbr_shd.g_old_rec.lbr_attribute11
516: ,p_lbr_attribute4_o =>ben_lbr_shd.g_old_rec.lbr_attribute4
517: ,p_lbr_attribute5_o =>ben_lbr_shd.g_old_rec.lbr_attribute5
518: ,p_lbr_attribute6_o =>ben_lbr_shd.g_old_rec.lbr_attribute6
519: ,p_lbr_attribute7_o =>ben_lbr_shd.g_old_rec.lbr_attribute7
520: ,p_lbr_attribute8_o =>ben_lbr_shd.g_old_rec.lbr_attribute8
521: ,p_lbr_attribute9_o =>ben_lbr_shd.g_old_rec.lbr_attribute9
522: ,p_lbr_attribute10_o =>ben_lbr_shd.g_old_rec.lbr_attribute10
523: ,p_lbr_attribute11_o =>ben_lbr_shd.g_old_rec.lbr_attribute11
524: ,p_lbr_attribute12_o =>ben_lbr_shd.g_old_rec.lbr_attribute12
517: ,p_lbr_attribute5_o =>ben_lbr_shd.g_old_rec.lbr_attribute5
518: ,p_lbr_attribute6_o =>ben_lbr_shd.g_old_rec.lbr_attribute6
519: ,p_lbr_attribute7_o =>ben_lbr_shd.g_old_rec.lbr_attribute7
520: ,p_lbr_attribute8_o =>ben_lbr_shd.g_old_rec.lbr_attribute8
521: ,p_lbr_attribute9_o =>ben_lbr_shd.g_old_rec.lbr_attribute9
522: ,p_lbr_attribute10_o =>ben_lbr_shd.g_old_rec.lbr_attribute10
523: ,p_lbr_attribute11_o =>ben_lbr_shd.g_old_rec.lbr_attribute11
524: ,p_lbr_attribute12_o =>ben_lbr_shd.g_old_rec.lbr_attribute12
525: ,p_lbr_attribute13_o =>ben_lbr_shd.g_old_rec.lbr_attribute13
518: ,p_lbr_attribute6_o =>ben_lbr_shd.g_old_rec.lbr_attribute6
519: ,p_lbr_attribute7_o =>ben_lbr_shd.g_old_rec.lbr_attribute7
520: ,p_lbr_attribute8_o =>ben_lbr_shd.g_old_rec.lbr_attribute8
521: ,p_lbr_attribute9_o =>ben_lbr_shd.g_old_rec.lbr_attribute9
522: ,p_lbr_attribute10_o =>ben_lbr_shd.g_old_rec.lbr_attribute10
523: ,p_lbr_attribute11_o =>ben_lbr_shd.g_old_rec.lbr_attribute11
524: ,p_lbr_attribute12_o =>ben_lbr_shd.g_old_rec.lbr_attribute12
525: ,p_lbr_attribute13_o =>ben_lbr_shd.g_old_rec.lbr_attribute13
526: ,p_lbr_attribute14_o =>ben_lbr_shd.g_old_rec.lbr_attribute14
519: ,p_lbr_attribute7_o =>ben_lbr_shd.g_old_rec.lbr_attribute7
520: ,p_lbr_attribute8_o =>ben_lbr_shd.g_old_rec.lbr_attribute8
521: ,p_lbr_attribute9_o =>ben_lbr_shd.g_old_rec.lbr_attribute9
522: ,p_lbr_attribute10_o =>ben_lbr_shd.g_old_rec.lbr_attribute10
523: ,p_lbr_attribute11_o =>ben_lbr_shd.g_old_rec.lbr_attribute11
524: ,p_lbr_attribute12_o =>ben_lbr_shd.g_old_rec.lbr_attribute12
525: ,p_lbr_attribute13_o =>ben_lbr_shd.g_old_rec.lbr_attribute13
526: ,p_lbr_attribute14_o =>ben_lbr_shd.g_old_rec.lbr_attribute14
527: ,p_lbr_attribute15_o =>ben_lbr_shd.g_old_rec.lbr_attribute15
520: ,p_lbr_attribute8_o =>ben_lbr_shd.g_old_rec.lbr_attribute8
521: ,p_lbr_attribute9_o =>ben_lbr_shd.g_old_rec.lbr_attribute9
522: ,p_lbr_attribute10_o =>ben_lbr_shd.g_old_rec.lbr_attribute10
523: ,p_lbr_attribute11_o =>ben_lbr_shd.g_old_rec.lbr_attribute11
524: ,p_lbr_attribute12_o =>ben_lbr_shd.g_old_rec.lbr_attribute12
525: ,p_lbr_attribute13_o =>ben_lbr_shd.g_old_rec.lbr_attribute13
526: ,p_lbr_attribute14_o =>ben_lbr_shd.g_old_rec.lbr_attribute14
527: ,p_lbr_attribute15_o =>ben_lbr_shd.g_old_rec.lbr_attribute15
528: ,p_lbr_attribute16_o =>ben_lbr_shd.g_old_rec.lbr_attribute16
521: ,p_lbr_attribute9_o =>ben_lbr_shd.g_old_rec.lbr_attribute9
522: ,p_lbr_attribute10_o =>ben_lbr_shd.g_old_rec.lbr_attribute10
523: ,p_lbr_attribute11_o =>ben_lbr_shd.g_old_rec.lbr_attribute11
524: ,p_lbr_attribute12_o =>ben_lbr_shd.g_old_rec.lbr_attribute12
525: ,p_lbr_attribute13_o =>ben_lbr_shd.g_old_rec.lbr_attribute13
526: ,p_lbr_attribute14_o =>ben_lbr_shd.g_old_rec.lbr_attribute14
527: ,p_lbr_attribute15_o =>ben_lbr_shd.g_old_rec.lbr_attribute15
528: ,p_lbr_attribute16_o =>ben_lbr_shd.g_old_rec.lbr_attribute16
529: ,p_lbr_attribute17_o =>ben_lbr_shd.g_old_rec.lbr_attribute17
522: ,p_lbr_attribute10_o =>ben_lbr_shd.g_old_rec.lbr_attribute10
523: ,p_lbr_attribute11_o =>ben_lbr_shd.g_old_rec.lbr_attribute11
524: ,p_lbr_attribute12_o =>ben_lbr_shd.g_old_rec.lbr_attribute12
525: ,p_lbr_attribute13_o =>ben_lbr_shd.g_old_rec.lbr_attribute13
526: ,p_lbr_attribute14_o =>ben_lbr_shd.g_old_rec.lbr_attribute14
527: ,p_lbr_attribute15_o =>ben_lbr_shd.g_old_rec.lbr_attribute15
528: ,p_lbr_attribute16_o =>ben_lbr_shd.g_old_rec.lbr_attribute16
529: ,p_lbr_attribute17_o =>ben_lbr_shd.g_old_rec.lbr_attribute17
530: ,p_lbr_attribute18_o =>ben_lbr_shd.g_old_rec.lbr_attribute18
523: ,p_lbr_attribute11_o =>ben_lbr_shd.g_old_rec.lbr_attribute11
524: ,p_lbr_attribute12_o =>ben_lbr_shd.g_old_rec.lbr_attribute12
525: ,p_lbr_attribute13_o =>ben_lbr_shd.g_old_rec.lbr_attribute13
526: ,p_lbr_attribute14_o =>ben_lbr_shd.g_old_rec.lbr_attribute14
527: ,p_lbr_attribute15_o =>ben_lbr_shd.g_old_rec.lbr_attribute15
528: ,p_lbr_attribute16_o =>ben_lbr_shd.g_old_rec.lbr_attribute16
529: ,p_lbr_attribute17_o =>ben_lbr_shd.g_old_rec.lbr_attribute17
530: ,p_lbr_attribute18_o =>ben_lbr_shd.g_old_rec.lbr_attribute18
531: ,p_lbr_attribute19_o =>ben_lbr_shd.g_old_rec.lbr_attribute19
524: ,p_lbr_attribute12_o =>ben_lbr_shd.g_old_rec.lbr_attribute12
525: ,p_lbr_attribute13_o =>ben_lbr_shd.g_old_rec.lbr_attribute13
526: ,p_lbr_attribute14_o =>ben_lbr_shd.g_old_rec.lbr_attribute14
527: ,p_lbr_attribute15_o =>ben_lbr_shd.g_old_rec.lbr_attribute15
528: ,p_lbr_attribute16_o =>ben_lbr_shd.g_old_rec.lbr_attribute16
529: ,p_lbr_attribute17_o =>ben_lbr_shd.g_old_rec.lbr_attribute17
530: ,p_lbr_attribute18_o =>ben_lbr_shd.g_old_rec.lbr_attribute18
531: ,p_lbr_attribute19_o =>ben_lbr_shd.g_old_rec.lbr_attribute19
532: ,p_lbr_attribute20_o =>ben_lbr_shd.g_old_rec.lbr_attribute20
525: ,p_lbr_attribute13_o =>ben_lbr_shd.g_old_rec.lbr_attribute13
526: ,p_lbr_attribute14_o =>ben_lbr_shd.g_old_rec.lbr_attribute14
527: ,p_lbr_attribute15_o =>ben_lbr_shd.g_old_rec.lbr_attribute15
528: ,p_lbr_attribute16_o =>ben_lbr_shd.g_old_rec.lbr_attribute16
529: ,p_lbr_attribute17_o =>ben_lbr_shd.g_old_rec.lbr_attribute17
530: ,p_lbr_attribute18_o =>ben_lbr_shd.g_old_rec.lbr_attribute18
531: ,p_lbr_attribute19_o =>ben_lbr_shd.g_old_rec.lbr_attribute19
532: ,p_lbr_attribute20_o =>ben_lbr_shd.g_old_rec.lbr_attribute20
533: ,p_lbr_attribute21_o =>ben_lbr_shd.g_old_rec.lbr_attribute21
526: ,p_lbr_attribute14_o =>ben_lbr_shd.g_old_rec.lbr_attribute14
527: ,p_lbr_attribute15_o =>ben_lbr_shd.g_old_rec.lbr_attribute15
528: ,p_lbr_attribute16_o =>ben_lbr_shd.g_old_rec.lbr_attribute16
529: ,p_lbr_attribute17_o =>ben_lbr_shd.g_old_rec.lbr_attribute17
530: ,p_lbr_attribute18_o =>ben_lbr_shd.g_old_rec.lbr_attribute18
531: ,p_lbr_attribute19_o =>ben_lbr_shd.g_old_rec.lbr_attribute19
532: ,p_lbr_attribute20_o =>ben_lbr_shd.g_old_rec.lbr_attribute20
533: ,p_lbr_attribute21_o =>ben_lbr_shd.g_old_rec.lbr_attribute21
534: ,p_lbr_attribute22_o =>ben_lbr_shd.g_old_rec.lbr_attribute22
527: ,p_lbr_attribute15_o =>ben_lbr_shd.g_old_rec.lbr_attribute15
528: ,p_lbr_attribute16_o =>ben_lbr_shd.g_old_rec.lbr_attribute16
529: ,p_lbr_attribute17_o =>ben_lbr_shd.g_old_rec.lbr_attribute17
530: ,p_lbr_attribute18_o =>ben_lbr_shd.g_old_rec.lbr_attribute18
531: ,p_lbr_attribute19_o =>ben_lbr_shd.g_old_rec.lbr_attribute19
532: ,p_lbr_attribute20_o =>ben_lbr_shd.g_old_rec.lbr_attribute20
533: ,p_lbr_attribute21_o =>ben_lbr_shd.g_old_rec.lbr_attribute21
534: ,p_lbr_attribute22_o =>ben_lbr_shd.g_old_rec.lbr_attribute22
535: ,p_lbr_attribute23_o =>ben_lbr_shd.g_old_rec.lbr_attribute23
528: ,p_lbr_attribute16_o =>ben_lbr_shd.g_old_rec.lbr_attribute16
529: ,p_lbr_attribute17_o =>ben_lbr_shd.g_old_rec.lbr_attribute17
530: ,p_lbr_attribute18_o =>ben_lbr_shd.g_old_rec.lbr_attribute18
531: ,p_lbr_attribute19_o =>ben_lbr_shd.g_old_rec.lbr_attribute19
532: ,p_lbr_attribute20_o =>ben_lbr_shd.g_old_rec.lbr_attribute20
533: ,p_lbr_attribute21_o =>ben_lbr_shd.g_old_rec.lbr_attribute21
534: ,p_lbr_attribute22_o =>ben_lbr_shd.g_old_rec.lbr_attribute22
535: ,p_lbr_attribute23_o =>ben_lbr_shd.g_old_rec.lbr_attribute23
536: ,p_lbr_attribute24_o =>ben_lbr_shd.g_old_rec.lbr_attribute24
529: ,p_lbr_attribute17_o =>ben_lbr_shd.g_old_rec.lbr_attribute17
530: ,p_lbr_attribute18_o =>ben_lbr_shd.g_old_rec.lbr_attribute18
531: ,p_lbr_attribute19_o =>ben_lbr_shd.g_old_rec.lbr_attribute19
532: ,p_lbr_attribute20_o =>ben_lbr_shd.g_old_rec.lbr_attribute20
533: ,p_lbr_attribute21_o =>ben_lbr_shd.g_old_rec.lbr_attribute21
534: ,p_lbr_attribute22_o =>ben_lbr_shd.g_old_rec.lbr_attribute22
535: ,p_lbr_attribute23_o =>ben_lbr_shd.g_old_rec.lbr_attribute23
536: ,p_lbr_attribute24_o =>ben_lbr_shd.g_old_rec.lbr_attribute24
537: ,p_lbr_attribute25_o =>ben_lbr_shd.g_old_rec.lbr_attribute25
530: ,p_lbr_attribute18_o =>ben_lbr_shd.g_old_rec.lbr_attribute18
531: ,p_lbr_attribute19_o =>ben_lbr_shd.g_old_rec.lbr_attribute19
532: ,p_lbr_attribute20_o =>ben_lbr_shd.g_old_rec.lbr_attribute20
533: ,p_lbr_attribute21_o =>ben_lbr_shd.g_old_rec.lbr_attribute21
534: ,p_lbr_attribute22_o =>ben_lbr_shd.g_old_rec.lbr_attribute22
535: ,p_lbr_attribute23_o =>ben_lbr_shd.g_old_rec.lbr_attribute23
536: ,p_lbr_attribute24_o =>ben_lbr_shd.g_old_rec.lbr_attribute24
537: ,p_lbr_attribute25_o =>ben_lbr_shd.g_old_rec.lbr_attribute25
538: ,p_lbr_attribute26_o =>ben_lbr_shd.g_old_rec.lbr_attribute26
531: ,p_lbr_attribute19_o =>ben_lbr_shd.g_old_rec.lbr_attribute19
532: ,p_lbr_attribute20_o =>ben_lbr_shd.g_old_rec.lbr_attribute20
533: ,p_lbr_attribute21_o =>ben_lbr_shd.g_old_rec.lbr_attribute21
534: ,p_lbr_attribute22_o =>ben_lbr_shd.g_old_rec.lbr_attribute22
535: ,p_lbr_attribute23_o =>ben_lbr_shd.g_old_rec.lbr_attribute23
536: ,p_lbr_attribute24_o =>ben_lbr_shd.g_old_rec.lbr_attribute24
537: ,p_lbr_attribute25_o =>ben_lbr_shd.g_old_rec.lbr_attribute25
538: ,p_lbr_attribute26_o =>ben_lbr_shd.g_old_rec.lbr_attribute26
539: ,p_lbr_attribute27_o =>ben_lbr_shd.g_old_rec.lbr_attribute27
532: ,p_lbr_attribute20_o =>ben_lbr_shd.g_old_rec.lbr_attribute20
533: ,p_lbr_attribute21_o =>ben_lbr_shd.g_old_rec.lbr_attribute21
534: ,p_lbr_attribute22_o =>ben_lbr_shd.g_old_rec.lbr_attribute22
535: ,p_lbr_attribute23_o =>ben_lbr_shd.g_old_rec.lbr_attribute23
536: ,p_lbr_attribute24_o =>ben_lbr_shd.g_old_rec.lbr_attribute24
537: ,p_lbr_attribute25_o =>ben_lbr_shd.g_old_rec.lbr_attribute25
538: ,p_lbr_attribute26_o =>ben_lbr_shd.g_old_rec.lbr_attribute26
539: ,p_lbr_attribute27_o =>ben_lbr_shd.g_old_rec.lbr_attribute27
540: ,p_lbr_attribute28_o =>ben_lbr_shd.g_old_rec.lbr_attribute28
533: ,p_lbr_attribute21_o =>ben_lbr_shd.g_old_rec.lbr_attribute21
534: ,p_lbr_attribute22_o =>ben_lbr_shd.g_old_rec.lbr_attribute22
535: ,p_lbr_attribute23_o =>ben_lbr_shd.g_old_rec.lbr_attribute23
536: ,p_lbr_attribute24_o =>ben_lbr_shd.g_old_rec.lbr_attribute24
537: ,p_lbr_attribute25_o =>ben_lbr_shd.g_old_rec.lbr_attribute25
538: ,p_lbr_attribute26_o =>ben_lbr_shd.g_old_rec.lbr_attribute26
539: ,p_lbr_attribute27_o =>ben_lbr_shd.g_old_rec.lbr_attribute27
540: ,p_lbr_attribute28_o =>ben_lbr_shd.g_old_rec.lbr_attribute28
541: ,p_lbr_attribute29_o =>ben_lbr_shd.g_old_rec.lbr_attribute29
534: ,p_lbr_attribute22_o =>ben_lbr_shd.g_old_rec.lbr_attribute22
535: ,p_lbr_attribute23_o =>ben_lbr_shd.g_old_rec.lbr_attribute23
536: ,p_lbr_attribute24_o =>ben_lbr_shd.g_old_rec.lbr_attribute24
537: ,p_lbr_attribute25_o =>ben_lbr_shd.g_old_rec.lbr_attribute25
538: ,p_lbr_attribute26_o =>ben_lbr_shd.g_old_rec.lbr_attribute26
539: ,p_lbr_attribute27_o =>ben_lbr_shd.g_old_rec.lbr_attribute27
540: ,p_lbr_attribute28_o =>ben_lbr_shd.g_old_rec.lbr_attribute28
541: ,p_lbr_attribute29_o =>ben_lbr_shd.g_old_rec.lbr_attribute29
542: ,p_lbr_attribute30_o =>ben_lbr_shd.g_old_rec.lbr_attribute30
535: ,p_lbr_attribute23_o =>ben_lbr_shd.g_old_rec.lbr_attribute23
536: ,p_lbr_attribute24_o =>ben_lbr_shd.g_old_rec.lbr_attribute24
537: ,p_lbr_attribute25_o =>ben_lbr_shd.g_old_rec.lbr_attribute25
538: ,p_lbr_attribute26_o =>ben_lbr_shd.g_old_rec.lbr_attribute26
539: ,p_lbr_attribute27_o =>ben_lbr_shd.g_old_rec.lbr_attribute27
540: ,p_lbr_attribute28_o =>ben_lbr_shd.g_old_rec.lbr_attribute28
541: ,p_lbr_attribute29_o =>ben_lbr_shd.g_old_rec.lbr_attribute29
542: ,p_lbr_attribute30_o =>ben_lbr_shd.g_old_rec.lbr_attribute30
543: ,p_susp_if_ctfn_not_prvd_flag_o =>ben_lbr_shd.g_old_rec.susp_if_ctfn_not_prvd_flag
536: ,p_lbr_attribute24_o =>ben_lbr_shd.g_old_rec.lbr_attribute24
537: ,p_lbr_attribute25_o =>ben_lbr_shd.g_old_rec.lbr_attribute25
538: ,p_lbr_attribute26_o =>ben_lbr_shd.g_old_rec.lbr_attribute26
539: ,p_lbr_attribute27_o =>ben_lbr_shd.g_old_rec.lbr_attribute27
540: ,p_lbr_attribute28_o =>ben_lbr_shd.g_old_rec.lbr_attribute28
541: ,p_lbr_attribute29_o =>ben_lbr_shd.g_old_rec.lbr_attribute29
542: ,p_lbr_attribute30_o =>ben_lbr_shd.g_old_rec.lbr_attribute30
543: ,p_susp_if_ctfn_not_prvd_flag_o =>ben_lbr_shd.g_old_rec.susp_if_ctfn_not_prvd_flag
544: ,p_ctfn_determine_cd_o =>ben_lbr_shd.g_old_rec.ctfn_determine_cd
537: ,p_lbr_attribute25_o =>ben_lbr_shd.g_old_rec.lbr_attribute25
538: ,p_lbr_attribute26_o =>ben_lbr_shd.g_old_rec.lbr_attribute26
539: ,p_lbr_attribute27_o =>ben_lbr_shd.g_old_rec.lbr_attribute27
540: ,p_lbr_attribute28_o =>ben_lbr_shd.g_old_rec.lbr_attribute28
541: ,p_lbr_attribute29_o =>ben_lbr_shd.g_old_rec.lbr_attribute29
542: ,p_lbr_attribute30_o =>ben_lbr_shd.g_old_rec.lbr_attribute30
543: ,p_susp_if_ctfn_not_prvd_flag_o =>ben_lbr_shd.g_old_rec.susp_if_ctfn_not_prvd_flag
544: ,p_ctfn_determine_cd_o =>ben_lbr_shd.g_old_rec.ctfn_determine_cd
545: ,p_object_version_number_o =>ben_lbr_shd.g_old_rec.object_version_number
538: ,p_lbr_attribute26_o =>ben_lbr_shd.g_old_rec.lbr_attribute26
539: ,p_lbr_attribute27_o =>ben_lbr_shd.g_old_rec.lbr_attribute27
540: ,p_lbr_attribute28_o =>ben_lbr_shd.g_old_rec.lbr_attribute28
541: ,p_lbr_attribute29_o =>ben_lbr_shd.g_old_rec.lbr_attribute29
542: ,p_lbr_attribute30_o =>ben_lbr_shd.g_old_rec.lbr_attribute30
543: ,p_susp_if_ctfn_not_prvd_flag_o =>ben_lbr_shd.g_old_rec.susp_if_ctfn_not_prvd_flag
544: ,p_ctfn_determine_cd_o =>ben_lbr_shd.g_old_rec.ctfn_determine_cd
545: ,p_object_version_number_o =>ben_lbr_shd.g_old_rec.object_version_number
546: );
539: ,p_lbr_attribute27_o =>ben_lbr_shd.g_old_rec.lbr_attribute27
540: ,p_lbr_attribute28_o =>ben_lbr_shd.g_old_rec.lbr_attribute28
541: ,p_lbr_attribute29_o =>ben_lbr_shd.g_old_rec.lbr_attribute29
542: ,p_lbr_attribute30_o =>ben_lbr_shd.g_old_rec.lbr_attribute30
543: ,p_susp_if_ctfn_not_prvd_flag_o =>ben_lbr_shd.g_old_rec.susp_if_ctfn_not_prvd_flag
544: ,p_ctfn_determine_cd_o =>ben_lbr_shd.g_old_rec.ctfn_determine_cd
545: ,p_object_version_number_o =>ben_lbr_shd.g_old_rec.object_version_number
546: );
547: --
540: ,p_lbr_attribute28_o =>ben_lbr_shd.g_old_rec.lbr_attribute28
541: ,p_lbr_attribute29_o =>ben_lbr_shd.g_old_rec.lbr_attribute29
542: ,p_lbr_attribute30_o =>ben_lbr_shd.g_old_rec.lbr_attribute30
543: ,p_susp_if_ctfn_not_prvd_flag_o =>ben_lbr_shd.g_old_rec.susp_if_ctfn_not_prvd_flag
544: ,p_ctfn_determine_cd_o =>ben_lbr_shd.g_old_rec.ctfn_determine_cd
545: ,p_object_version_number_o =>ben_lbr_shd.g_old_rec.object_version_number
546: );
547: --
548: exception
541: ,p_lbr_attribute29_o =>ben_lbr_shd.g_old_rec.lbr_attribute29
542: ,p_lbr_attribute30_o =>ben_lbr_shd.g_old_rec.lbr_attribute30
543: ,p_susp_if_ctfn_not_prvd_flag_o =>ben_lbr_shd.g_old_rec.susp_if_ctfn_not_prvd_flag
544: ,p_ctfn_determine_cd_o =>ben_lbr_shd.g_old_rec.ctfn_determine_cd
545: ,p_object_version_number_o =>ben_lbr_shd.g_old_rec.object_version_number
546: );
547: --
548: exception
549: --
603: -- Internal Row Handler Use Only.
604: --
605: -- {End Of Comments}
606: -- ----------------------------------------------------------------------------
607: Procedure convert_defs(p_rec in out nocopy ben_lbr_shd.g_rec_type) is
608: --
609: l_proc varchar2(72) := g_package||'convert_defs';
610: --
611: Begin
618: -- is being used then we must set to the 'current' argument value.
619: --
620: If (p_rec.no_mx_cvg_amt_apls_flag = hr_api.g_varchar2) then
621: p_rec.no_mx_cvg_amt_apls_flag :=
622: ben_lbr_shd.g_old_rec.no_mx_cvg_amt_apls_flag;
623: End If;
624: If (p_rec.no_mn_cvg_incr_apls_flag = hr_api.g_varchar2) then
625: p_rec.no_mn_cvg_incr_apls_flag :=
626: ben_lbr_shd.g_old_rec.no_mn_cvg_incr_apls_flag;
622: ben_lbr_shd.g_old_rec.no_mx_cvg_amt_apls_flag;
623: End If;
624: If (p_rec.no_mn_cvg_incr_apls_flag = hr_api.g_varchar2) then
625: p_rec.no_mn_cvg_incr_apls_flag :=
626: ben_lbr_shd.g_old_rec.no_mn_cvg_incr_apls_flag;
627: End If;
628: If (p_rec.no_mx_cvg_incr_apls_flag = hr_api.g_varchar2) then
629: p_rec.no_mx_cvg_incr_apls_flag :=
630: ben_lbr_shd.g_old_rec.no_mx_cvg_incr_apls_flag;
626: ben_lbr_shd.g_old_rec.no_mn_cvg_incr_apls_flag;
627: End If;
628: If (p_rec.no_mx_cvg_incr_apls_flag = hr_api.g_varchar2) then
629: p_rec.no_mx_cvg_incr_apls_flag :=
630: ben_lbr_shd.g_old_rec.no_mx_cvg_incr_apls_flag;
631: End If;
632: If (p_rec.mx_cvg_incr_wcf_alwd_amt = hr_api.g_number) then
633: p_rec.mx_cvg_incr_wcf_alwd_amt :=
634: ben_lbr_shd.g_old_rec.mx_cvg_incr_wcf_alwd_amt;
630: ben_lbr_shd.g_old_rec.no_mx_cvg_incr_apls_flag;
631: End If;
632: If (p_rec.mx_cvg_incr_wcf_alwd_amt = hr_api.g_number) then
633: p_rec.mx_cvg_incr_wcf_alwd_amt :=
634: ben_lbr_shd.g_old_rec.mx_cvg_incr_wcf_alwd_amt;
635: End If;
636: If (p_rec.mx_cvg_incr_alwd_amt = hr_api.g_number) then
637: p_rec.mx_cvg_incr_alwd_amt :=
638: ben_lbr_shd.g_old_rec.mx_cvg_incr_alwd_amt;
634: ben_lbr_shd.g_old_rec.mx_cvg_incr_wcf_alwd_amt;
635: End If;
636: If (p_rec.mx_cvg_incr_alwd_amt = hr_api.g_number) then
637: p_rec.mx_cvg_incr_alwd_amt :=
638: ben_lbr_shd.g_old_rec.mx_cvg_incr_alwd_amt;
639: End If;
640: If (p_rec.mx_cvg_alwd_amt = hr_api.g_number) then
641: p_rec.mx_cvg_alwd_amt :=
642: ben_lbr_shd.g_old_rec.mx_cvg_alwd_amt;
638: ben_lbr_shd.g_old_rec.mx_cvg_incr_alwd_amt;
639: End If;
640: If (p_rec.mx_cvg_alwd_amt = hr_api.g_number) then
641: p_rec.mx_cvg_alwd_amt :=
642: ben_lbr_shd.g_old_rec.mx_cvg_alwd_amt;
643: End If;
644: If (p_rec.mx_cvg_mlt_incr_num = hr_api.g_number) then
645: p_rec.mx_cvg_mlt_incr_num :=
646: ben_lbr_shd.g_old_rec.mx_cvg_mlt_incr_num;
642: ben_lbr_shd.g_old_rec.mx_cvg_alwd_amt;
643: End If;
644: If (p_rec.mx_cvg_mlt_incr_num = hr_api.g_number) then
645: p_rec.mx_cvg_mlt_incr_num :=
646: ben_lbr_shd.g_old_rec.mx_cvg_mlt_incr_num;
647: End If;
648: If (p_rec.mx_cvg_mlt_incr_wcf_num = hr_api.g_number) then
649: p_rec.mx_cvg_mlt_incr_wcf_num :=
650: ben_lbr_shd.g_old_rec.mx_cvg_mlt_incr_wcf_num;
646: ben_lbr_shd.g_old_rec.mx_cvg_mlt_incr_num;
647: End If;
648: If (p_rec.mx_cvg_mlt_incr_wcf_num = hr_api.g_number) then
649: p_rec.mx_cvg_mlt_incr_wcf_num :=
650: ben_lbr_shd.g_old_rec.mx_cvg_mlt_incr_wcf_num;
651: End If;
652: If (p_rec.mx_cvg_rl = hr_api.g_number) then
653: p_rec.mx_cvg_rl :=
654: ben_lbr_shd.g_old_rec.mx_cvg_rl;
650: ben_lbr_shd.g_old_rec.mx_cvg_mlt_incr_wcf_num;
651: End If;
652: If (p_rec.mx_cvg_rl = hr_api.g_number) then
653: p_rec.mx_cvg_rl :=
654: ben_lbr_shd.g_old_rec.mx_cvg_rl;
655: End If;
656: If (p_rec.mx_cvg_wcfn_amt = hr_api.g_number) then
657: p_rec.mx_cvg_wcfn_amt :=
658: ben_lbr_shd.g_old_rec.mx_cvg_wcfn_amt;
654: ben_lbr_shd.g_old_rec.mx_cvg_rl;
655: End If;
656: If (p_rec.mx_cvg_wcfn_amt = hr_api.g_number) then
657: p_rec.mx_cvg_wcfn_amt :=
658: ben_lbr_shd.g_old_rec.mx_cvg_wcfn_amt;
659: End If;
660: If (p_rec.mx_cvg_wcfn_mlt_num = hr_api.g_number) then
661: p_rec.mx_cvg_wcfn_mlt_num :=
662: ben_lbr_shd.g_old_rec.mx_cvg_wcfn_mlt_num;
658: ben_lbr_shd.g_old_rec.mx_cvg_wcfn_amt;
659: End If;
660: If (p_rec.mx_cvg_wcfn_mlt_num = hr_api.g_number) then
661: p_rec.mx_cvg_wcfn_mlt_num :=
662: ben_lbr_shd.g_old_rec.mx_cvg_wcfn_mlt_num;
663: End If;
664: If (p_rec.mn_cvg_amt = hr_api.g_number) then
665: p_rec.mn_cvg_amt :=
666: ben_lbr_shd.g_old_rec.mn_cvg_amt;
662: ben_lbr_shd.g_old_rec.mx_cvg_wcfn_mlt_num;
663: End If;
664: If (p_rec.mn_cvg_amt = hr_api.g_number) then
665: p_rec.mn_cvg_amt :=
666: ben_lbr_shd.g_old_rec.mn_cvg_amt;
667: End If;
668: If (p_rec.mn_cvg_rl = hr_api.g_number) then
669: p_rec.mn_cvg_rl :=
670: ben_lbr_shd.g_old_rec.mn_cvg_rl;
666: ben_lbr_shd.g_old_rec.mn_cvg_amt;
667: End If;
668: If (p_rec.mn_cvg_rl = hr_api.g_number) then
669: p_rec.mn_cvg_rl :=
670: ben_lbr_shd.g_old_rec.mn_cvg_rl;
671: End If;
672: If (p_rec.cvg_incr_r_decr_only_cd = hr_api.g_varchar2) then
673: p_rec.cvg_incr_r_decr_only_cd :=
674: ben_lbr_shd.g_old_rec.cvg_incr_r_decr_only_cd;
670: ben_lbr_shd.g_old_rec.mn_cvg_rl;
671: End If;
672: If (p_rec.cvg_incr_r_decr_only_cd = hr_api.g_varchar2) then
673: p_rec.cvg_incr_r_decr_only_cd :=
674: ben_lbr_shd.g_old_rec.cvg_incr_r_decr_only_cd;
675: End If;
676: If (p_rec.unsspnd_enrt_cd = hr_api.g_varchar2) then
677: p_rec.unsspnd_enrt_cd :=
678: ben_lbr_shd.g_old_rec.unsspnd_enrt_cd;
674: ben_lbr_shd.g_old_rec.cvg_incr_r_decr_only_cd;
675: End If;
676: If (p_rec.unsspnd_enrt_cd = hr_api.g_varchar2) then
677: p_rec.unsspnd_enrt_cd :=
678: ben_lbr_shd.g_old_rec.unsspnd_enrt_cd;
679: End If;
680: If (p_rec.dflt_to_asn_pndg_ctfn_cd = hr_api.g_varchar2) then
681: p_rec.dflt_to_asn_pndg_ctfn_cd :=
682: ben_lbr_shd.g_old_rec.dflt_to_asn_pndg_ctfn_cd;
678: ben_lbr_shd.g_old_rec.unsspnd_enrt_cd;
679: End If;
680: If (p_rec.dflt_to_asn_pndg_ctfn_cd = hr_api.g_varchar2) then
681: p_rec.dflt_to_asn_pndg_ctfn_cd :=
682: ben_lbr_shd.g_old_rec.dflt_to_asn_pndg_ctfn_cd;
683: End If;
684: If (p_rec.dflt_to_asn_pndg_ctfn_rl = hr_api.g_number) then
685: p_rec.dflt_to_asn_pndg_ctfn_rl :=
686: ben_lbr_shd.g_old_rec.dflt_to_asn_pndg_ctfn_rl;
682: ben_lbr_shd.g_old_rec.dflt_to_asn_pndg_ctfn_cd;
683: End If;
684: If (p_rec.dflt_to_asn_pndg_ctfn_rl = hr_api.g_number) then
685: p_rec.dflt_to_asn_pndg_ctfn_rl :=
686: ben_lbr_shd.g_old_rec.dflt_to_asn_pndg_ctfn_rl;
687: End If;
688: If (p_rec.ler_id = hr_api.g_number) then
689: p_rec.ler_id :=
690: ben_lbr_shd.g_old_rec.ler_id;
686: ben_lbr_shd.g_old_rec.dflt_to_asn_pndg_ctfn_rl;
687: End If;
688: If (p_rec.ler_id = hr_api.g_number) then
689: p_rec.ler_id :=
690: ben_lbr_shd.g_old_rec.ler_id;
691: End If;
692: If (p_rec.pl_id = hr_api.g_number) then
693: p_rec.pl_id :=
694: ben_lbr_shd.g_old_rec.pl_id;
690: ben_lbr_shd.g_old_rec.ler_id;
691: End If;
692: If (p_rec.pl_id = hr_api.g_number) then
693: p_rec.pl_id :=
694: ben_lbr_shd.g_old_rec.pl_id;
695: End If;
696: If (p_rec.business_group_id = hr_api.g_number) then
697: p_rec.business_group_id :=
698: ben_lbr_shd.g_old_rec.business_group_id;
694: ben_lbr_shd.g_old_rec.pl_id;
695: End If;
696: If (p_rec.business_group_id = hr_api.g_number) then
697: p_rec.business_group_id :=
698: ben_lbr_shd.g_old_rec.business_group_id;
699: End If;
700: If (p_rec.plip_id = hr_api.g_number) then
701: p_rec.plip_id :=
702: ben_lbr_shd.g_old_rec.plip_id;
698: ben_lbr_shd.g_old_rec.business_group_id;
699: End If;
700: If (p_rec.plip_id = hr_api.g_number) then
701: p_rec.plip_id :=
702: ben_lbr_shd.g_old_rec.plip_id;
703: End If;
704: If (p_rec.lbr_attribute_category = hr_api.g_varchar2) then
705: p_rec.lbr_attribute_category :=
706: ben_lbr_shd.g_old_rec.lbr_attribute_category;
702: ben_lbr_shd.g_old_rec.plip_id;
703: End If;
704: If (p_rec.lbr_attribute_category = hr_api.g_varchar2) then
705: p_rec.lbr_attribute_category :=
706: ben_lbr_shd.g_old_rec.lbr_attribute_category;
707: End If;
708: If (p_rec.lbr_attribute1 = hr_api.g_varchar2) then
709: p_rec.lbr_attribute1 :=
710: ben_lbr_shd.g_old_rec.lbr_attribute1;
706: ben_lbr_shd.g_old_rec.lbr_attribute_category;
707: End If;
708: If (p_rec.lbr_attribute1 = hr_api.g_varchar2) then
709: p_rec.lbr_attribute1 :=
710: ben_lbr_shd.g_old_rec.lbr_attribute1;
711: End If;
712: If (p_rec.lbr_attribute2 = hr_api.g_varchar2) then
713: p_rec.lbr_attribute2 :=
714: ben_lbr_shd.g_old_rec.lbr_attribute2;
710: ben_lbr_shd.g_old_rec.lbr_attribute1;
711: End If;
712: If (p_rec.lbr_attribute2 = hr_api.g_varchar2) then
713: p_rec.lbr_attribute2 :=
714: ben_lbr_shd.g_old_rec.lbr_attribute2;
715: End If;
716: If (p_rec.lbr_attribute3 = hr_api.g_varchar2) then
717: p_rec.lbr_attribute3 :=
718: ben_lbr_shd.g_old_rec.lbr_attribute3;
714: ben_lbr_shd.g_old_rec.lbr_attribute2;
715: End If;
716: If (p_rec.lbr_attribute3 = hr_api.g_varchar2) then
717: p_rec.lbr_attribute3 :=
718: ben_lbr_shd.g_old_rec.lbr_attribute3;
719: End If;
720: If (p_rec.lbr_attribute4 = hr_api.g_varchar2) then
721: p_rec.lbr_attribute4 :=
722: ben_lbr_shd.g_old_rec.lbr_attribute4;
718: ben_lbr_shd.g_old_rec.lbr_attribute3;
719: End If;
720: If (p_rec.lbr_attribute4 = hr_api.g_varchar2) then
721: p_rec.lbr_attribute4 :=
722: ben_lbr_shd.g_old_rec.lbr_attribute4;
723: End If;
724: If (p_rec.lbr_attribute5 = hr_api.g_varchar2) then
725: p_rec.lbr_attribute5 :=
726: ben_lbr_shd.g_old_rec.lbr_attribute5;
722: ben_lbr_shd.g_old_rec.lbr_attribute4;
723: End If;
724: If (p_rec.lbr_attribute5 = hr_api.g_varchar2) then
725: p_rec.lbr_attribute5 :=
726: ben_lbr_shd.g_old_rec.lbr_attribute5;
727: End If;
728: If (p_rec.lbr_attribute6 = hr_api.g_varchar2) then
729: p_rec.lbr_attribute6 :=
730: ben_lbr_shd.g_old_rec.lbr_attribute6;
726: ben_lbr_shd.g_old_rec.lbr_attribute5;
727: End If;
728: If (p_rec.lbr_attribute6 = hr_api.g_varchar2) then
729: p_rec.lbr_attribute6 :=
730: ben_lbr_shd.g_old_rec.lbr_attribute6;
731: End If;
732: If (p_rec.lbr_attribute7 = hr_api.g_varchar2) then
733: p_rec.lbr_attribute7 :=
734: ben_lbr_shd.g_old_rec.lbr_attribute7;
730: ben_lbr_shd.g_old_rec.lbr_attribute6;
731: End If;
732: If (p_rec.lbr_attribute7 = hr_api.g_varchar2) then
733: p_rec.lbr_attribute7 :=
734: ben_lbr_shd.g_old_rec.lbr_attribute7;
735: End If;
736: If (p_rec.lbr_attribute8 = hr_api.g_varchar2) then
737: p_rec.lbr_attribute8 :=
738: ben_lbr_shd.g_old_rec.lbr_attribute8;
734: ben_lbr_shd.g_old_rec.lbr_attribute7;
735: End If;
736: If (p_rec.lbr_attribute8 = hr_api.g_varchar2) then
737: p_rec.lbr_attribute8 :=
738: ben_lbr_shd.g_old_rec.lbr_attribute8;
739: End If;
740: If (p_rec.lbr_attribute9 = hr_api.g_varchar2) then
741: p_rec.lbr_attribute9 :=
742: ben_lbr_shd.g_old_rec.lbr_attribute9;
738: ben_lbr_shd.g_old_rec.lbr_attribute8;
739: End If;
740: If (p_rec.lbr_attribute9 = hr_api.g_varchar2) then
741: p_rec.lbr_attribute9 :=
742: ben_lbr_shd.g_old_rec.lbr_attribute9;
743: End If;
744: If (p_rec.lbr_attribute10 = hr_api.g_varchar2) then
745: p_rec.lbr_attribute10 :=
746: ben_lbr_shd.g_old_rec.lbr_attribute10;
742: ben_lbr_shd.g_old_rec.lbr_attribute9;
743: End If;
744: If (p_rec.lbr_attribute10 = hr_api.g_varchar2) then
745: p_rec.lbr_attribute10 :=
746: ben_lbr_shd.g_old_rec.lbr_attribute10;
747: End If;
748: If (p_rec.lbr_attribute11 = hr_api.g_varchar2) then
749: p_rec.lbr_attribute11 :=
750: ben_lbr_shd.g_old_rec.lbr_attribute11;
746: ben_lbr_shd.g_old_rec.lbr_attribute10;
747: End If;
748: If (p_rec.lbr_attribute11 = hr_api.g_varchar2) then
749: p_rec.lbr_attribute11 :=
750: ben_lbr_shd.g_old_rec.lbr_attribute11;
751: End If;
752: If (p_rec.lbr_attribute12 = hr_api.g_varchar2) then
753: p_rec.lbr_attribute12 :=
754: ben_lbr_shd.g_old_rec.lbr_attribute12;
750: ben_lbr_shd.g_old_rec.lbr_attribute11;
751: End If;
752: If (p_rec.lbr_attribute12 = hr_api.g_varchar2) then
753: p_rec.lbr_attribute12 :=
754: ben_lbr_shd.g_old_rec.lbr_attribute12;
755: End If;
756: If (p_rec.lbr_attribute13 = hr_api.g_varchar2) then
757: p_rec.lbr_attribute13 :=
758: ben_lbr_shd.g_old_rec.lbr_attribute13;
754: ben_lbr_shd.g_old_rec.lbr_attribute12;
755: End If;
756: If (p_rec.lbr_attribute13 = hr_api.g_varchar2) then
757: p_rec.lbr_attribute13 :=
758: ben_lbr_shd.g_old_rec.lbr_attribute13;
759: End If;
760: If (p_rec.lbr_attribute14 = hr_api.g_varchar2) then
761: p_rec.lbr_attribute14 :=
762: ben_lbr_shd.g_old_rec.lbr_attribute14;
758: ben_lbr_shd.g_old_rec.lbr_attribute13;
759: End If;
760: If (p_rec.lbr_attribute14 = hr_api.g_varchar2) then
761: p_rec.lbr_attribute14 :=
762: ben_lbr_shd.g_old_rec.lbr_attribute14;
763: End If;
764: If (p_rec.lbr_attribute15 = hr_api.g_varchar2) then
765: p_rec.lbr_attribute15 :=
766: ben_lbr_shd.g_old_rec.lbr_attribute15;
762: ben_lbr_shd.g_old_rec.lbr_attribute14;
763: End If;
764: If (p_rec.lbr_attribute15 = hr_api.g_varchar2) then
765: p_rec.lbr_attribute15 :=
766: ben_lbr_shd.g_old_rec.lbr_attribute15;
767: End If;
768: If (p_rec.lbr_attribute16 = hr_api.g_varchar2) then
769: p_rec.lbr_attribute16 :=
770: ben_lbr_shd.g_old_rec.lbr_attribute16;
766: ben_lbr_shd.g_old_rec.lbr_attribute15;
767: End If;
768: If (p_rec.lbr_attribute16 = hr_api.g_varchar2) then
769: p_rec.lbr_attribute16 :=
770: ben_lbr_shd.g_old_rec.lbr_attribute16;
771: End If;
772: If (p_rec.lbr_attribute17 = hr_api.g_varchar2) then
773: p_rec.lbr_attribute17 :=
774: ben_lbr_shd.g_old_rec.lbr_attribute17;
770: ben_lbr_shd.g_old_rec.lbr_attribute16;
771: End If;
772: If (p_rec.lbr_attribute17 = hr_api.g_varchar2) then
773: p_rec.lbr_attribute17 :=
774: ben_lbr_shd.g_old_rec.lbr_attribute17;
775: End If;
776: If (p_rec.lbr_attribute18 = hr_api.g_varchar2) then
777: p_rec.lbr_attribute18 :=
778: ben_lbr_shd.g_old_rec.lbr_attribute18;
774: ben_lbr_shd.g_old_rec.lbr_attribute17;
775: End If;
776: If (p_rec.lbr_attribute18 = hr_api.g_varchar2) then
777: p_rec.lbr_attribute18 :=
778: ben_lbr_shd.g_old_rec.lbr_attribute18;
779: End If;
780: If (p_rec.lbr_attribute19 = hr_api.g_varchar2) then
781: p_rec.lbr_attribute19 :=
782: ben_lbr_shd.g_old_rec.lbr_attribute19;
778: ben_lbr_shd.g_old_rec.lbr_attribute18;
779: End If;
780: If (p_rec.lbr_attribute19 = hr_api.g_varchar2) then
781: p_rec.lbr_attribute19 :=
782: ben_lbr_shd.g_old_rec.lbr_attribute19;
783: End If;
784: If (p_rec.lbr_attribute20 = hr_api.g_varchar2) then
785: p_rec.lbr_attribute20 :=
786: ben_lbr_shd.g_old_rec.lbr_attribute20;
782: ben_lbr_shd.g_old_rec.lbr_attribute19;
783: End If;
784: If (p_rec.lbr_attribute20 = hr_api.g_varchar2) then
785: p_rec.lbr_attribute20 :=
786: ben_lbr_shd.g_old_rec.lbr_attribute20;
787: End If;
788: If (p_rec.lbr_attribute21 = hr_api.g_varchar2) then
789: p_rec.lbr_attribute21 :=
790: ben_lbr_shd.g_old_rec.lbr_attribute21;
786: ben_lbr_shd.g_old_rec.lbr_attribute20;
787: End If;
788: If (p_rec.lbr_attribute21 = hr_api.g_varchar2) then
789: p_rec.lbr_attribute21 :=
790: ben_lbr_shd.g_old_rec.lbr_attribute21;
791: End If;
792: If (p_rec.lbr_attribute22 = hr_api.g_varchar2) then
793: p_rec.lbr_attribute22 :=
794: ben_lbr_shd.g_old_rec.lbr_attribute22;
790: ben_lbr_shd.g_old_rec.lbr_attribute21;
791: End If;
792: If (p_rec.lbr_attribute22 = hr_api.g_varchar2) then
793: p_rec.lbr_attribute22 :=
794: ben_lbr_shd.g_old_rec.lbr_attribute22;
795: End If;
796: If (p_rec.lbr_attribute23 = hr_api.g_varchar2) then
797: p_rec.lbr_attribute23 :=
798: ben_lbr_shd.g_old_rec.lbr_attribute23;
794: ben_lbr_shd.g_old_rec.lbr_attribute22;
795: End If;
796: If (p_rec.lbr_attribute23 = hr_api.g_varchar2) then
797: p_rec.lbr_attribute23 :=
798: ben_lbr_shd.g_old_rec.lbr_attribute23;
799: End If;
800: If (p_rec.lbr_attribute24 = hr_api.g_varchar2) then
801: p_rec.lbr_attribute24 :=
802: ben_lbr_shd.g_old_rec.lbr_attribute24;
798: ben_lbr_shd.g_old_rec.lbr_attribute23;
799: End If;
800: If (p_rec.lbr_attribute24 = hr_api.g_varchar2) then
801: p_rec.lbr_attribute24 :=
802: ben_lbr_shd.g_old_rec.lbr_attribute24;
803: End If;
804: If (p_rec.lbr_attribute25 = hr_api.g_varchar2) then
805: p_rec.lbr_attribute25 :=
806: ben_lbr_shd.g_old_rec.lbr_attribute25;
802: ben_lbr_shd.g_old_rec.lbr_attribute24;
803: End If;
804: If (p_rec.lbr_attribute25 = hr_api.g_varchar2) then
805: p_rec.lbr_attribute25 :=
806: ben_lbr_shd.g_old_rec.lbr_attribute25;
807: End If;
808: If (p_rec.lbr_attribute26 = hr_api.g_varchar2) then
809: p_rec.lbr_attribute26 :=
810: ben_lbr_shd.g_old_rec.lbr_attribute26;
806: ben_lbr_shd.g_old_rec.lbr_attribute25;
807: End If;
808: If (p_rec.lbr_attribute26 = hr_api.g_varchar2) then
809: p_rec.lbr_attribute26 :=
810: ben_lbr_shd.g_old_rec.lbr_attribute26;
811: End If;
812: If (p_rec.lbr_attribute27 = hr_api.g_varchar2) then
813: p_rec.lbr_attribute27 :=
814: ben_lbr_shd.g_old_rec.lbr_attribute27;
810: ben_lbr_shd.g_old_rec.lbr_attribute26;
811: End If;
812: If (p_rec.lbr_attribute27 = hr_api.g_varchar2) then
813: p_rec.lbr_attribute27 :=
814: ben_lbr_shd.g_old_rec.lbr_attribute27;
815: End If;
816: If (p_rec.lbr_attribute28 = hr_api.g_varchar2) then
817: p_rec.lbr_attribute28 :=
818: ben_lbr_shd.g_old_rec.lbr_attribute28;
814: ben_lbr_shd.g_old_rec.lbr_attribute27;
815: End If;
816: If (p_rec.lbr_attribute28 = hr_api.g_varchar2) then
817: p_rec.lbr_attribute28 :=
818: ben_lbr_shd.g_old_rec.lbr_attribute28;
819: End If;
820: If (p_rec.lbr_attribute29 = hr_api.g_varchar2) then
821: p_rec.lbr_attribute29 :=
822: ben_lbr_shd.g_old_rec.lbr_attribute29;
818: ben_lbr_shd.g_old_rec.lbr_attribute28;
819: End If;
820: If (p_rec.lbr_attribute29 = hr_api.g_varchar2) then
821: p_rec.lbr_attribute29 :=
822: ben_lbr_shd.g_old_rec.lbr_attribute29;
823: End If;
824: If (p_rec.lbr_attribute30 = hr_api.g_varchar2) then
825: p_rec.lbr_attribute30 :=
826: ben_lbr_shd.g_old_rec.lbr_attribute30;
822: ben_lbr_shd.g_old_rec.lbr_attribute29;
823: End If;
824: If (p_rec.lbr_attribute30 = hr_api.g_varchar2) then
825: p_rec.lbr_attribute30 :=
826: ben_lbr_shd.g_old_rec.lbr_attribute30;
827: End If;
828: If (p_rec.susp_if_ctfn_not_prvd_flag = hr_api.g_varchar2) then
829: p_rec.susp_if_ctfn_not_prvd_flag :=
830: ben_lbr_shd.g_old_rec.susp_if_ctfn_not_prvd_flag;
826: ben_lbr_shd.g_old_rec.lbr_attribute30;
827: End If;
828: If (p_rec.susp_if_ctfn_not_prvd_flag = hr_api.g_varchar2) then
829: p_rec.susp_if_ctfn_not_prvd_flag :=
830: ben_lbr_shd.g_old_rec.susp_if_ctfn_not_prvd_flag;
831: End If;
832: If (p_rec.ctfn_determine_cd = hr_api.g_varchar2) then
833: p_rec.ctfn_determine_cd :=
834: ben_lbr_shd.g_old_rec.ctfn_determine_cd;
830: ben_lbr_shd.g_old_rec.susp_if_ctfn_not_prvd_flag;
831: End If;
832: If (p_rec.ctfn_determine_cd = hr_api.g_varchar2) then
833: p_rec.ctfn_determine_cd :=
834: ben_lbr_shd.g_old_rec.ctfn_determine_cd;
835: End If;
836:
837: --
838: hr_utility.set_location(' Leaving:'||l_proc, 10);
843: -- |---------------------------------< upd >----------------------------------|
844: -- ----------------------------------------------------------------------------
845: Procedure upd
846: (
847: p_rec in out nocopy ben_lbr_shd.g_rec_type,
848: p_effective_date in date,
849: p_datetrack_mode in varchar2
850: ) is
851: --
861: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
862: --
863: -- We must lock the row which we need to update.
864: --
865: ben_lbr_shd.lck
866: (p_effective_date => p_effective_date,
867: p_datetrack_mode => p_datetrack_mode,
868: p_ler_bnft_rstrn_id => p_rec.ler_bnft_rstrn_id,
869: p_object_version_number => p_rec.object_version_number,
978: p_effective_date in date,
979: p_datetrack_mode in varchar2
980: ) is
981: --
982: l_rec ben_lbr_shd.g_rec_type;
983: l_proc varchar2(72) := g_package||'upd';
984: --
985: Begin
986: hr_utility.set_location('Entering:'||l_proc, 5);
988: -- Call conversion function to turn arguments into the
989: -- l_rec structure.
990: --
991: l_rec :=
992: ben_lbr_shd.convert_args
993: (
994: p_ler_bnft_rstrn_id,
995: null,
996: null,