[Home] [Help]
54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: Procedure dt_update_dml
58: (p_rec in out nocopy ben_len_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_lee_rsn_f',
78: p_base_key_column => 'lee_rsn_id',
79: p_base_key_value => p_rec.lee_rsn_id);
80: --
81: ben_len_shd.g_api_dml := true; -- Set the api dml status
82: --
83: -- Update the ben_lee_rsn_f Row
84: --
85: update ben_lee_rsn_f
147: where lee_rsn_id = p_rec.lee_rsn_id
148: and effective_start_date = p_validation_start_date
149: and effective_end_date = p_validation_end_date;
150: --
151: ben_len_shd.g_api_dml := false; -- Unset the api dml status
152: --
153: -- Set the effective start and end dates
154: --
155: p_rec.effective_start_date := p_validation_start_date;
159: hr_utility.set_location(' Leaving:'||l_proc, 15);
160: Exception
161: When hr_api.check_integrity_violated Then
162: -- A check constraint has been violated
163: ben_len_shd.g_api_dml := false; -- Unset the api dml status
164: ben_len_shd.constraint_error
165: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
166: When hr_api.unique_integrity_violated Then
167: -- Unique integrity has been violated
160: Exception
161: When hr_api.check_integrity_violated Then
162: -- A check constraint has been violated
163: ben_len_shd.g_api_dml := false; -- Unset the api dml status
164: ben_len_shd.constraint_error
165: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
166: When hr_api.unique_integrity_violated Then
167: -- Unique integrity has been violated
168: ben_len_shd.g_api_dml := false; -- Unset the api dml status
164: ben_len_shd.constraint_error
165: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
166: When hr_api.unique_integrity_violated Then
167: -- Unique integrity has been violated
168: ben_len_shd.g_api_dml := false; -- Unset the api dml status
169: ben_len_shd.constraint_error
170: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
171: When Others Then
172: ben_len_shd.g_api_dml := false; -- Unset the api dml status
165: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
166: When hr_api.unique_integrity_violated Then
167: -- Unique integrity has been violated
168: ben_len_shd.g_api_dml := false; -- Unset the api dml status
169: ben_len_shd.constraint_error
170: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
171: When Others Then
172: ben_len_shd.g_api_dml := false; -- Unset the api dml status
173: Raise;
168: ben_len_shd.g_api_dml := false; -- Unset the api dml status
169: ben_len_shd.constraint_error
170: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
171: When Others Then
172: ben_len_shd.g_api_dml := false; -- Unset the api dml status
173: Raise;
174: End dt_update_dml;
175: --
176: -- ----------------------------------------------------------------------------
204: --
205: -- {End Of Comments}
206: -- ----------------------------------------------------------------------------
207: Procedure update_dml
208: (p_rec in out nocopy ben_len_shd.g_rec_type,
209: p_effective_date in date,
210: p_datetrack_mode in varchar2,
211: p_validation_start_date in date,
212: p_validation_end_date in date) is
268: --
269: -- {End Of Comments}
270: -- ----------------------------------------------------------------------------
271: Procedure dt_pre_update
272: (p_rec in out nocopy ben_len_shd.g_rec_type,
273: p_effective_date in date,
274: p_datetrack_mode in varchar2,
275: p_validation_start_date in date,
276: p_validation_end_date in date) is
284: hr_utility.set_location(l_proc, 10);
285: --
286: -- Update the current effective end date
287: --
288: ben_len_shd.upd_effective_end_date
289: (p_effective_date => p_effective_date,
290: p_base_key_value => p_rec.lee_rsn_id,
291: p_new_effective_end_date => (p_validation_start_date - 1),
292: p_validation_start_date => p_validation_start_date,
353: --
354: -- {End Of Comments}
355: -- ----------------------------------------------------------------------------
356: Procedure pre_update
357: (p_rec in out nocopy ben_len_shd.g_rec_type,
358: p_effective_date in date,
359: p_datetrack_mode in varchar2,
360: p_validation_start_date in date,
361: p_validation_end_date in date) is
409: --
410: -- {End Of Comments}
411: -- ----------------------------------------------------------------------------
412: Procedure post_update
413: (p_rec in ben_len_shd.g_rec_type,
414: p_effective_date in date,
415: p_datetrack_mode in varchar2,
416: p_validation_start_date in date,
417: p_validation_end_date in date) is
493: ,p_reopen_le_on_reprocess => p_rec.reopen_le_on_reprocess
494: ,p_ENRT_PERD_STRT_DAYS =>p_rec.ENRT_PERD_STRT_DAYS
495: ,p_ENRT_PERD_END_DAYS =>p_rec.ENRT_PERD_END_DAYS
496: ,p_defer_deenrol_flag =>p_rec.defer_deenrol_flag
497: ,p_effective_start_date_o =>ben_len_shd.g_old_rec.effective_start_date
498: ,p_effective_end_date_o =>ben_len_shd.g_old_rec.effective_end_date
499: ,p_business_group_id_o =>ben_len_shd.g_old_rec.business_group_id
500: ,p_popl_enrt_typ_cycl_id_o =>ben_len_shd.g_old_rec.popl_enrt_typ_cycl_id
501: ,p_ler_id_o =>ben_len_shd.g_old_rec.ler_id
494: ,p_ENRT_PERD_STRT_DAYS =>p_rec.ENRT_PERD_STRT_DAYS
495: ,p_ENRT_PERD_END_DAYS =>p_rec.ENRT_PERD_END_DAYS
496: ,p_defer_deenrol_flag =>p_rec.defer_deenrol_flag
497: ,p_effective_start_date_o =>ben_len_shd.g_old_rec.effective_start_date
498: ,p_effective_end_date_o =>ben_len_shd.g_old_rec.effective_end_date
499: ,p_business_group_id_o =>ben_len_shd.g_old_rec.business_group_id
500: ,p_popl_enrt_typ_cycl_id_o =>ben_len_shd.g_old_rec.popl_enrt_typ_cycl_id
501: ,p_ler_id_o =>ben_len_shd.g_old_rec.ler_id
502: ,p_cls_enrt_dt_to_use_cd_o =>ben_len_shd.g_old_rec.cls_enrt_dt_to_use_cd
495: ,p_ENRT_PERD_END_DAYS =>p_rec.ENRT_PERD_END_DAYS
496: ,p_defer_deenrol_flag =>p_rec.defer_deenrol_flag
497: ,p_effective_start_date_o =>ben_len_shd.g_old_rec.effective_start_date
498: ,p_effective_end_date_o =>ben_len_shd.g_old_rec.effective_end_date
499: ,p_business_group_id_o =>ben_len_shd.g_old_rec.business_group_id
500: ,p_popl_enrt_typ_cycl_id_o =>ben_len_shd.g_old_rec.popl_enrt_typ_cycl_id
501: ,p_ler_id_o =>ben_len_shd.g_old_rec.ler_id
502: ,p_cls_enrt_dt_to_use_cd_o =>ben_len_shd.g_old_rec.cls_enrt_dt_to_use_cd
503: ,p_dys_aftr_end_to_dflt_num_o =>ben_len_shd.g_old_rec.dys_aftr_end_to_dflt_num
496: ,p_defer_deenrol_flag =>p_rec.defer_deenrol_flag
497: ,p_effective_start_date_o =>ben_len_shd.g_old_rec.effective_start_date
498: ,p_effective_end_date_o =>ben_len_shd.g_old_rec.effective_end_date
499: ,p_business_group_id_o =>ben_len_shd.g_old_rec.business_group_id
500: ,p_popl_enrt_typ_cycl_id_o =>ben_len_shd.g_old_rec.popl_enrt_typ_cycl_id
501: ,p_ler_id_o =>ben_len_shd.g_old_rec.ler_id
502: ,p_cls_enrt_dt_to_use_cd_o =>ben_len_shd.g_old_rec.cls_enrt_dt_to_use_cd
503: ,p_dys_aftr_end_to_dflt_num_o =>ben_len_shd.g_old_rec.dys_aftr_end_to_dflt_num
504: ,p_enrt_cvg_end_dt_cd_o =>ben_len_shd.g_old_rec.enrt_cvg_end_dt_cd
497: ,p_effective_start_date_o =>ben_len_shd.g_old_rec.effective_start_date
498: ,p_effective_end_date_o =>ben_len_shd.g_old_rec.effective_end_date
499: ,p_business_group_id_o =>ben_len_shd.g_old_rec.business_group_id
500: ,p_popl_enrt_typ_cycl_id_o =>ben_len_shd.g_old_rec.popl_enrt_typ_cycl_id
501: ,p_ler_id_o =>ben_len_shd.g_old_rec.ler_id
502: ,p_cls_enrt_dt_to_use_cd_o =>ben_len_shd.g_old_rec.cls_enrt_dt_to_use_cd
503: ,p_dys_aftr_end_to_dflt_num_o =>ben_len_shd.g_old_rec.dys_aftr_end_to_dflt_num
504: ,p_enrt_cvg_end_dt_cd_o =>ben_len_shd.g_old_rec.enrt_cvg_end_dt_cd
505: ,p_enrt_cvg_strt_dt_cd_o =>ben_len_shd.g_old_rec.enrt_cvg_strt_dt_cd
498: ,p_effective_end_date_o =>ben_len_shd.g_old_rec.effective_end_date
499: ,p_business_group_id_o =>ben_len_shd.g_old_rec.business_group_id
500: ,p_popl_enrt_typ_cycl_id_o =>ben_len_shd.g_old_rec.popl_enrt_typ_cycl_id
501: ,p_ler_id_o =>ben_len_shd.g_old_rec.ler_id
502: ,p_cls_enrt_dt_to_use_cd_o =>ben_len_shd.g_old_rec.cls_enrt_dt_to_use_cd
503: ,p_dys_aftr_end_to_dflt_num_o =>ben_len_shd.g_old_rec.dys_aftr_end_to_dflt_num
504: ,p_enrt_cvg_end_dt_cd_o =>ben_len_shd.g_old_rec.enrt_cvg_end_dt_cd
505: ,p_enrt_cvg_strt_dt_cd_o =>ben_len_shd.g_old_rec.enrt_cvg_strt_dt_cd
506: ,p_enrt_perd_strt_dt_cd_o =>ben_len_shd.g_old_rec.enrt_perd_strt_dt_cd
499: ,p_business_group_id_o =>ben_len_shd.g_old_rec.business_group_id
500: ,p_popl_enrt_typ_cycl_id_o =>ben_len_shd.g_old_rec.popl_enrt_typ_cycl_id
501: ,p_ler_id_o =>ben_len_shd.g_old_rec.ler_id
502: ,p_cls_enrt_dt_to_use_cd_o =>ben_len_shd.g_old_rec.cls_enrt_dt_to_use_cd
503: ,p_dys_aftr_end_to_dflt_num_o =>ben_len_shd.g_old_rec.dys_aftr_end_to_dflt_num
504: ,p_enrt_cvg_end_dt_cd_o =>ben_len_shd.g_old_rec.enrt_cvg_end_dt_cd
505: ,p_enrt_cvg_strt_dt_cd_o =>ben_len_shd.g_old_rec.enrt_cvg_strt_dt_cd
506: ,p_enrt_perd_strt_dt_cd_o =>ben_len_shd.g_old_rec.enrt_perd_strt_dt_cd
507: ,p_enrt_perd_strt_dt_rl_o =>ben_len_shd.g_old_rec.enrt_perd_strt_dt_rl
500: ,p_popl_enrt_typ_cycl_id_o =>ben_len_shd.g_old_rec.popl_enrt_typ_cycl_id
501: ,p_ler_id_o =>ben_len_shd.g_old_rec.ler_id
502: ,p_cls_enrt_dt_to_use_cd_o =>ben_len_shd.g_old_rec.cls_enrt_dt_to_use_cd
503: ,p_dys_aftr_end_to_dflt_num_o =>ben_len_shd.g_old_rec.dys_aftr_end_to_dflt_num
504: ,p_enrt_cvg_end_dt_cd_o =>ben_len_shd.g_old_rec.enrt_cvg_end_dt_cd
505: ,p_enrt_cvg_strt_dt_cd_o =>ben_len_shd.g_old_rec.enrt_cvg_strt_dt_cd
506: ,p_enrt_perd_strt_dt_cd_o =>ben_len_shd.g_old_rec.enrt_perd_strt_dt_cd
507: ,p_enrt_perd_strt_dt_rl_o =>ben_len_shd.g_old_rec.enrt_perd_strt_dt_rl
508: ,p_enrt_perd_end_dt_cd_o =>ben_len_shd.g_old_rec.enrt_perd_end_dt_cd
501: ,p_ler_id_o =>ben_len_shd.g_old_rec.ler_id
502: ,p_cls_enrt_dt_to_use_cd_o =>ben_len_shd.g_old_rec.cls_enrt_dt_to_use_cd
503: ,p_dys_aftr_end_to_dflt_num_o =>ben_len_shd.g_old_rec.dys_aftr_end_to_dflt_num
504: ,p_enrt_cvg_end_dt_cd_o =>ben_len_shd.g_old_rec.enrt_cvg_end_dt_cd
505: ,p_enrt_cvg_strt_dt_cd_o =>ben_len_shd.g_old_rec.enrt_cvg_strt_dt_cd
506: ,p_enrt_perd_strt_dt_cd_o =>ben_len_shd.g_old_rec.enrt_perd_strt_dt_cd
507: ,p_enrt_perd_strt_dt_rl_o =>ben_len_shd.g_old_rec.enrt_perd_strt_dt_rl
508: ,p_enrt_perd_end_dt_cd_o =>ben_len_shd.g_old_rec.enrt_perd_end_dt_cd
509: ,p_enrt_perd_end_dt_rl_o =>ben_len_shd.g_old_rec.enrt_perd_end_dt_rl
502: ,p_cls_enrt_dt_to_use_cd_o =>ben_len_shd.g_old_rec.cls_enrt_dt_to_use_cd
503: ,p_dys_aftr_end_to_dflt_num_o =>ben_len_shd.g_old_rec.dys_aftr_end_to_dflt_num
504: ,p_enrt_cvg_end_dt_cd_o =>ben_len_shd.g_old_rec.enrt_cvg_end_dt_cd
505: ,p_enrt_cvg_strt_dt_cd_o =>ben_len_shd.g_old_rec.enrt_cvg_strt_dt_cd
506: ,p_enrt_perd_strt_dt_cd_o =>ben_len_shd.g_old_rec.enrt_perd_strt_dt_cd
507: ,p_enrt_perd_strt_dt_rl_o =>ben_len_shd.g_old_rec.enrt_perd_strt_dt_rl
508: ,p_enrt_perd_end_dt_cd_o =>ben_len_shd.g_old_rec.enrt_perd_end_dt_cd
509: ,p_enrt_perd_end_dt_rl_o =>ben_len_shd.g_old_rec.enrt_perd_end_dt_rl
510: ,p_addl_procg_dys_num_o =>ben_len_shd.g_old_rec.addl_procg_dys_num
503: ,p_dys_aftr_end_to_dflt_num_o =>ben_len_shd.g_old_rec.dys_aftr_end_to_dflt_num
504: ,p_enrt_cvg_end_dt_cd_o =>ben_len_shd.g_old_rec.enrt_cvg_end_dt_cd
505: ,p_enrt_cvg_strt_dt_cd_o =>ben_len_shd.g_old_rec.enrt_cvg_strt_dt_cd
506: ,p_enrt_perd_strt_dt_cd_o =>ben_len_shd.g_old_rec.enrt_perd_strt_dt_cd
507: ,p_enrt_perd_strt_dt_rl_o =>ben_len_shd.g_old_rec.enrt_perd_strt_dt_rl
508: ,p_enrt_perd_end_dt_cd_o =>ben_len_shd.g_old_rec.enrt_perd_end_dt_cd
509: ,p_enrt_perd_end_dt_rl_o =>ben_len_shd.g_old_rec.enrt_perd_end_dt_rl
510: ,p_addl_procg_dys_num_o =>ben_len_shd.g_old_rec.addl_procg_dys_num
511: ,p_dys_no_enrl_not_elig_num_o =>ben_len_shd.g_old_rec.dys_no_enrl_not_elig_num
504: ,p_enrt_cvg_end_dt_cd_o =>ben_len_shd.g_old_rec.enrt_cvg_end_dt_cd
505: ,p_enrt_cvg_strt_dt_cd_o =>ben_len_shd.g_old_rec.enrt_cvg_strt_dt_cd
506: ,p_enrt_perd_strt_dt_cd_o =>ben_len_shd.g_old_rec.enrt_perd_strt_dt_cd
507: ,p_enrt_perd_strt_dt_rl_o =>ben_len_shd.g_old_rec.enrt_perd_strt_dt_rl
508: ,p_enrt_perd_end_dt_cd_o =>ben_len_shd.g_old_rec.enrt_perd_end_dt_cd
509: ,p_enrt_perd_end_dt_rl_o =>ben_len_shd.g_old_rec.enrt_perd_end_dt_rl
510: ,p_addl_procg_dys_num_o =>ben_len_shd.g_old_rec.addl_procg_dys_num
511: ,p_dys_no_enrl_not_elig_num_o =>ben_len_shd.g_old_rec.dys_no_enrl_not_elig_num
512: ,p_dys_no_enrl_cant_enrl_num_o =>ben_len_shd.g_old_rec.dys_no_enrl_cant_enrl_num
505: ,p_enrt_cvg_strt_dt_cd_o =>ben_len_shd.g_old_rec.enrt_cvg_strt_dt_cd
506: ,p_enrt_perd_strt_dt_cd_o =>ben_len_shd.g_old_rec.enrt_perd_strt_dt_cd
507: ,p_enrt_perd_strt_dt_rl_o =>ben_len_shd.g_old_rec.enrt_perd_strt_dt_rl
508: ,p_enrt_perd_end_dt_cd_o =>ben_len_shd.g_old_rec.enrt_perd_end_dt_cd
509: ,p_enrt_perd_end_dt_rl_o =>ben_len_shd.g_old_rec.enrt_perd_end_dt_rl
510: ,p_addl_procg_dys_num_o =>ben_len_shd.g_old_rec.addl_procg_dys_num
511: ,p_dys_no_enrl_not_elig_num_o =>ben_len_shd.g_old_rec.dys_no_enrl_not_elig_num
512: ,p_dys_no_enrl_cant_enrl_num_o =>ben_len_shd.g_old_rec.dys_no_enrl_cant_enrl_num
513: ,p_rt_end_dt_cd_o =>ben_len_shd.g_old_rec.rt_end_dt_cd
506: ,p_enrt_perd_strt_dt_cd_o =>ben_len_shd.g_old_rec.enrt_perd_strt_dt_cd
507: ,p_enrt_perd_strt_dt_rl_o =>ben_len_shd.g_old_rec.enrt_perd_strt_dt_rl
508: ,p_enrt_perd_end_dt_cd_o =>ben_len_shd.g_old_rec.enrt_perd_end_dt_cd
509: ,p_enrt_perd_end_dt_rl_o =>ben_len_shd.g_old_rec.enrt_perd_end_dt_rl
510: ,p_addl_procg_dys_num_o =>ben_len_shd.g_old_rec.addl_procg_dys_num
511: ,p_dys_no_enrl_not_elig_num_o =>ben_len_shd.g_old_rec.dys_no_enrl_not_elig_num
512: ,p_dys_no_enrl_cant_enrl_num_o =>ben_len_shd.g_old_rec.dys_no_enrl_cant_enrl_num
513: ,p_rt_end_dt_cd_o =>ben_len_shd.g_old_rec.rt_end_dt_cd
514: ,p_rt_end_dt_rl_o =>ben_len_shd.g_old_rec.rt_end_dt_rl
507: ,p_enrt_perd_strt_dt_rl_o =>ben_len_shd.g_old_rec.enrt_perd_strt_dt_rl
508: ,p_enrt_perd_end_dt_cd_o =>ben_len_shd.g_old_rec.enrt_perd_end_dt_cd
509: ,p_enrt_perd_end_dt_rl_o =>ben_len_shd.g_old_rec.enrt_perd_end_dt_rl
510: ,p_addl_procg_dys_num_o =>ben_len_shd.g_old_rec.addl_procg_dys_num
511: ,p_dys_no_enrl_not_elig_num_o =>ben_len_shd.g_old_rec.dys_no_enrl_not_elig_num
512: ,p_dys_no_enrl_cant_enrl_num_o =>ben_len_shd.g_old_rec.dys_no_enrl_cant_enrl_num
513: ,p_rt_end_dt_cd_o =>ben_len_shd.g_old_rec.rt_end_dt_cd
514: ,p_rt_end_dt_rl_o =>ben_len_shd.g_old_rec.rt_end_dt_rl
515: ,p_rt_strt_dt_cd_o =>ben_len_shd.g_old_rec.rt_strt_dt_cd
508: ,p_enrt_perd_end_dt_cd_o =>ben_len_shd.g_old_rec.enrt_perd_end_dt_cd
509: ,p_enrt_perd_end_dt_rl_o =>ben_len_shd.g_old_rec.enrt_perd_end_dt_rl
510: ,p_addl_procg_dys_num_o =>ben_len_shd.g_old_rec.addl_procg_dys_num
511: ,p_dys_no_enrl_not_elig_num_o =>ben_len_shd.g_old_rec.dys_no_enrl_not_elig_num
512: ,p_dys_no_enrl_cant_enrl_num_o =>ben_len_shd.g_old_rec.dys_no_enrl_cant_enrl_num
513: ,p_rt_end_dt_cd_o =>ben_len_shd.g_old_rec.rt_end_dt_cd
514: ,p_rt_end_dt_rl_o =>ben_len_shd.g_old_rec.rt_end_dt_rl
515: ,p_rt_strt_dt_cd_o =>ben_len_shd.g_old_rec.rt_strt_dt_cd
516: ,p_rt_strt_dt_rl_o =>ben_len_shd.g_old_rec.rt_strt_dt_rl
509: ,p_enrt_perd_end_dt_rl_o =>ben_len_shd.g_old_rec.enrt_perd_end_dt_rl
510: ,p_addl_procg_dys_num_o =>ben_len_shd.g_old_rec.addl_procg_dys_num
511: ,p_dys_no_enrl_not_elig_num_o =>ben_len_shd.g_old_rec.dys_no_enrl_not_elig_num
512: ,p_dys_no_enrl_cant_enrl_num_o =>ben_len_shd.g_old_rec.dys_no_enrl_cant_enrl_num
513: ,p_rt_end_dt_cd_o =>ben_len_shd.g_old_rec.rt_end_dt_cd
514: ,p_rt_end_dt_rl_o =>ben_len_shd.g_old_rec.rt_end_dt_rl
515: ,p_rt_strt_dt_cd_o =>ben_len_shd.g_old_rec.rt_strt_dt_cd
516: ,p_rt_strt_dt_rl_o =>ben_len_shd.g_old_rec.rt_strt_dt_rl
517: ,p_enrt_cvg_end_dt_rl_o =>ben_len_shd.g_old_rec.enrt_cvg_end_dt_rl
510: ,p_addl_procg_dys_num_o =>ben_len_shd.g_old_rec.addl_procg_dys_num
511: ,p_dys_no_enrl_not_elig_num_o =>ben_len_shd.g_old_rec.dys_no_enrl_not_elig_num
512: ,p_dys_no_enrl_cant_enrl_num_o =>ben_len_shd.g_old_rec.dys_no_enrl_cant_enrl_num
513: ,p_rt_end_dt_cd_o =>ben_len_shd.g_old_rec.rt_end_dt_cd
514: ,p_rt_end_dt_rl_o =>ben_len_shd.g_old_rec.rt_end_dt_rl
515: ,p_rt_strt_dt_cd_o =>ben_len_shd.g_old_rec.rt_strt_dt_cd
516: ,p_rt_strt_dt_rl_o =>ben_len_shd.g_old_rec.rt_strt_dt_rl
517: ,p_enrt_cvg_end_dt_rl_o =>ben_len_shd.g_old_rec.enrt_cvg_end_dt_rl
518: ,p_enrt_cvg_strt_dt_rl_o =>ben_len_shd.g_old_rec.enrt_cvg_strt_dt_rl
511: ,p_dys_no_enrl_not_elig_num_o =>ben_len_shd.g_old_rec.dys_no_enrl_not_elig_num
512: ,p_dys_no_enrl_cant_enrl_num_o =>ben_len_shd.g_old_rec.dys_no_enrl_cant_enrl_num
513: ,p_rt_end_dt_cd_o =>ben_len_shd.g_old_rec.rt_end_dt_cd
514: ,p_rt_end_dt_rl_o =>ben_len_shd.g_old_rec.rt_end_dt_rl
515: ,p_rt_strt_dt_cd_o =>ben_len_shd.g_old_rec.rt_strt_dt_cd
516: ,p_rt_strt_dt_rl_o =>ben_len_shd.g_old_rec.rt_strt_dt_rl
517: ,p_enrt_cvg_end_dt_rl_o =>ben_len_shd.g_old_rec.enrt_cvg_end_dt_rl
518: ,p_enrt_cvg_strt_dt_rl_o =>ben_len_shd.g_old_rec.enrt_cvg_strt_dt_rl
519: ,p_len_attribute_category_o =>ben_len_shd.g_old_rec.len_attribute_category
512: ,p_dys_no_enrl_cant_enrl_num_o =>ben_len_shd.g_old_rec.dys_no_enrl_cant_enrl_num
513: ,p_rt_end_dt_cd_o =>ben_len_shd.g_old_rec.rt_end_dt_cd
514: ,p_rt_end_dt_rl_o =>ben_len_shd.g_old_rec.rt_end_dt_rl
515: ,p_rt_strt_dt_cd_o =>ben_len_shd.g_old_rec.rt_strt_dt_cd
516: ,p_rt_strt_dt_rl_o =>ben_len_shd.g_old_rec.rt_strt_dt_rl
517: ,p_enrt_cvg_end_dt_rl_o =>ben_len_shd.g_old_rec.enrt_cvg_end_dt_rl
518: ,p_enrt_cvg_strt_dt_rl_o =>ben_len_shd.g_old_rec.enrt_cvg_strt_dt_rl
519: ,p_len_attribute_category_o =>ben_len_shd.g_old_rec.len_attribute_category
520: ,p_len_attribute1_o =>ben_len_shd.g_old_rec.len_attribute1
513: ,p_rt_end_dt_cd_o =>ben_len_shd.g_old_rec.rt_end_dt_cd
514: ,p_rt_end_dt_rl_o =>ben_len_shd.g_old_rec.rt_end_dt_rl
515: ,p_rt_strt_dt_cd_o =>ben_len_shd.g_old_rec.rt_strt_dt_cd
516: ,p_rt_strt_dt_rl_o =>ben_len_shd.g_old_rec.rt_strt_dt_rl
517: ,p_enrt_cvg_end_dt_rl_o =>ben_len_shd.g_old_rec.enrt_cvg_end_dt_rl
518: ,p_enrt_cvg_strt_dt_rl_o =>ben_len_shd.g_old_rec.enrt_cvg_strt_dt_rl
519: ,p_len_attribute_category_o =>ben_len_shd.g_old_rec.len_attribute_category
520: ,p_len_attribute1_o =>ben_len_shd.g_old_rec.len_attribute1
521: ,p_len_attribute2_o =>ben_len_shd.g_old_rec.len_attribute2
514: ,p_rt_end_dt_rl_o =>ben_len_shd.g_old_rec.rt_end_dt_rl
515: ,p_rt_strt_dt_cd_o =>ben_len_shd.g_old_rec.rt_strt_dt_cd
516: ,p_rt_strt_dt_rl_o =>ben_len_shd.g_old_rec.rt_strt_dt_rl
517: ,p_enrt_cvg_end_dt_rl_o =>ben_len_shd.g_old_rec.enrt_cvg_end_dt_rl
518: ,p_enrt_cvg_strt_dt_rl_o =>ben_len_shd.g_old_rec.enrt_cvg_strt_dt_rl
519: ,p_len_attribute_category_o =>ben_len_shd.g_old_rec.len_attribute_category
520: ,p_len_attribute1_o =>ben_len_shd.g_old_rec.len_attribute1
521: ,p_len_attribute2_o =>ben_len_shd.g_old_rec.len_attribute2
522: ,p_len_attribute3_o =>ben_len_shd.g_old_rec.len_attribute3
515: ,p_rt_strt_dt_cd_o =>ben_len_shd.g_old_rec.rt_strt_dt_cd
516: ,p_rt_strt_dt_rl_o =>ben_len_shd.g_old_rec.rt_strt_dt_rl
517: ,p_enrt_cvg_end_dt_rl_o =>ben_len_shd.g_old_rec.enrt_cvg_end_dt_rl
518: ,p_enrt_cvg_strt_dt_rl_o =>ben_len_shd.g_old_rec.enrt_cvg_strt_dt_rl
519: ,p_len_attribute_category_o =>ben_len_shd.g_old_rec.len_attribute_category
520: ,p_len_attribute1_o =>ben_len_shd.g_old_rec.len_attribute1
521: ,p_len_attribute2_o =>ben_len_shd.g_old_rec.len_attribute2
522: ,p_len_attribute3_o =>ben_len_shd.g_old_rec.len_attribute3
523: ,p_len_attribute4_o =>ben_len_shd.g_old_rec.len_attribute4
516: ,p_rt_strt_dt_rl_o =>ben_len_shd.g_old_rec.rt_strt_dt_rl
517: ,p_enrt_cvg_end_dt_rl_o =>ben_len_shd.g_old_rec.enrt_cvg_end_dt_rl
518: ,p_enrt_cvg_strt_dt_rl_o =>ben_len_shd.g_old_rec.enrt_cvg_strt_dt_rl
519: ,p_len_attribute_category_o =>ben_len_shd.g_old_rec.len_attribute_category
520: ,p_len_attribute1_o =>ben_len_shd.g_old_rec.len_attribute1
521: ,p_len_attribute2_o =>ben_len_shd.g_old_rec.len_attribute2
522: ,p_len_attribute3_o =>ben_len_shd.g_old_rec.len_attribute3
523: ,p_len_attribute4_o =>ben_len_shd.g_old_rec.len_attribute4
524: ,p_len_attribute5_o =>ben_len_shd.g_old_rec.len_attribute5
517: ,p_enrt_cvg_end_dt_rl_o =>ben_len_shd.g_old_rec.enrt_cvg_end_dt_rl
518: ,p_enrt_cvg_strt_dt_rl_o =>ben_len_shd.g_old_rec.enrt_cvg_strt_dt_rl
519: ,p_len_attribute_category_o =>ben_len_shd.g_old_rec.len_attribute_category
520: ,p_len_attribute1_o =>ben_len_shd.g_old_rec.len_attribute1
521: ,p_len_attribute2_o =>ben_len_shd.g_old_rec.len_attribute2
522: ,p_len_attribute3_o =>ben_len_shd.g_old_rec.len_attribute3
523: ,p_len_attribute4_o =>ben_len_shd.g_old_rec.len_attribute4
524: ,p_len_attribute5_o =>ben_len_shd.g_old_rec.len_attribute5
525: ,p_len_attribute6_o =>ben_len_shd.g_old_rec.len_attribute6
518: ,p_enrt_cvg_strt_dt_rl_o =>ben_len_shd.g_old_rec.enrt_cvg_strt_dt_rl
519: ,p_len_attribute_category_o =>ben_len_shd.g_old_rec.len_attribute_category
520: ,p_len_attribute1_o =>ben_len_shd.g_old_rec.len_attribute1
521: ,p_len_attribute2_o =>ben_len_shd.g_old_rec.len_attribute2
522: ,p_len_attribute3_o =>ben_len_shd.g_old_rec.len_attribute3
523: ,p_len_attribute4_o =>ben_len_shd.g_old_rec.len_attribute4
524: ,p_len_attribute5_o =>ben_len_shd.g_old_rec.len_attribute5
525: ,p_len_attribute6_o =>ben_len_shd.g_old_rec.len_attribute6
526: ,p_len_attribute7_o =>ben_len_shd.g_old_rec.len_attribute7
519: ,p_len_attribute_category_o =>ben_len_shd.g_old_rec.len_attribute_category
520: ,p_len_attribute1_o =>ben_len_shd.g_old_rec.len_attribute1
521: ,p_len_attribute2_o =>ben_len_shd.g_old_rec.len_attribute2
522: ,p_len_attribute3_o =>ben_len_shd.g_old_rec.len_attribute3
523: ,p_len_attribute4_o =>ben_len_shd.g_old_rec.len_attribute4
524: ,p_len_attribute5_o =>ben_len_shd.g_old_rec.len_attribute5
525: ,p_len_attribute6_o =>ben_len_shd.g_old_rec.len_attribute6
526: ,p_len_attribute7_o =>ben_len_shd.g_old_rec.len_attribute7
527: ,p_len_attribute8_o =>ben_len_shd.g_old_rec.len_attribute8
520: ,p_len_attribute1_o =>ben_len_shd.g_old_rec.len_attribute1
521: ,p_len_attribute2_o =>ben_len_shd.g_old_rec.len_attribute2
522: ,p_len_attribute3_o =>ben_len_shd.g_old_rec.len_attribute3
523: ,p_len_attribute4_o =>ben_len_shd.g_old_rec.len_attribute4
524: ,p_len_attribute5_o =>ben_len_shd.g_old_rec.len_attribute5
525: ,p_len_attribute6_o =>ben_len_shd.g_old_rec.len_attribute6
526: ,p_len_attribute7_o =>ben_len_shd.g_old_rec.len_attribute7
527: ,p_len_attribute8_o =>ben_len_shd.g_old_rec.len_attribute8
528: ,p_len_attribute9_o =>ben_len_shd.g_old_rec.len_attribute9
521: ,p_len_attribute2_o =>ben_len_shd.g_old_rec.len_attribute2
522: ,p_len_attribute3_o =>ben_len_shd.g_old_rec.len_attribute3
523: ,p_len_attribute4_o =>ben_len_shd.g_old_rec.len_attribute4
524: ,p_len_attribute5_o =>ben_len_shd.g_old_rec.len_attribute5
525: ,p_len_attribute6_o =>ben_len_shd.g_old_rec.len_attribute6
526: ,p_len_attribute7_o =>ben_len_shd.g_old_rec.len_attribute7
527: ,p_len_attribute8_o =>ben_len_shd.g_old_rec.len_attribute8
528: ,p_len_attribute9_o =>ben_len_shd.g_old_rec.len_attribute9
529: ,p_len_attribute10_o =>ben_len_shd.g_old_rec.len_attribute10
522: ,p_len_attribute3_o =>ben_len_shd.g_old_rec.len_attribute3
523: ,p_len_attribute4_o =>ben_len_shd.g_old_rec.len_attribute4
524: ,p_len_attribute5_o =>ben_len_shd.g_old_rec.len_attribute5
525: ,p_len_attribute6_o =>ben_len_shd.g_old_rec.len_attribute6
526: ,p_len_attribute7_o =>ben_len_shd.g_old_rec.len_attribute7
527: ,p_len_attribute8_o =>ben_len_shd.g_old_rec.len_attribute8
528: ,p_len_attribute9_o =>ben_len_shd.g_old_rec.len_attribute9
529: ,p_len_attribute10_o =>ben_len_shd.g_old_rec.len_attribute10
530: ,p_len_attribute11_o =>ben_len_shd.g_old_rec.len_attribute11
523: ,p_len_attribute4_o =>ben_len_shd.g_old_rec.len_attribute4
524: ,p_len_attribute5_o =>ben_len_shd.g_old_rec.len_attribute5
525: ,p_len_attribute6_o =>ben_len_shd.g_old_rec.len_attribute6
526: ,p_len_attribute7_o =>ben_len_shd.g_old_rec.len_attribute7
527: ,p_len_attribute8_o =>ben_len_shd.g_old_rec.len_attribute8
528: ,p_len_attribute9_o =>ben_len_shd.g_old_rec.len_attribute9
529: ,p_len_attribute10_o =>ben_len_shd.g_old_rec.len_attribute10
530: ,p_len_attribute11_o =>ben_len_shd.g_old_rec.len_attribute11
531: ,p_len_attribute12_o =>ben_len_shd.g_old_rec.len_attribute12
524: ,p_len_attribute5_o =>ben_len_shd.g_old_rec.len_attribute5
525: ,p_len_attribute6_o =>ben_len_shd.g_old_rec.len_attribute6
526: ,p_len_attribute7_o =>ben_len_shd.g_old_rec.len_attribute7
527: ,p_len_attribute8_o =>ben_len_shd.g_old_rec.len_attribute8
528: ,p_len_attribute9_o =>ben_len_shd.g_old_rec.len_attribute9
529: ,p_len_attribute10_o =>ben_len_shd.g_old_rec.len_attribute10
530: ,p_len_attribute11_o =>ben_len_shd.g_old_rec.len_attribute11
531: ,p_len_attribute12_o =>ben_len_shd.g_old_rec.len_attribute12
532: ,p_len_attribute13_o =>ben_len_shd.g_old_rec.len_attribute13
525: ,p_len_attribute6_o =>ben_len_shd.g_old_rec.len_attribute6
526: ,p_len_attribute7_o =>ben_len_shd.g_old_rec.len_attribute7
527: ,p_len_attribute8_o =>ben_len_shd.g_old_rec.len_attribute8
528: ,p_len_attribute9_o =>ben_len_shd.g_old_rec.len_attribute9
529: ,p_len_attribute10_o =>ben_len_shd.g_old_rec.len_attribute10
530: ,p_len_attribute11_o =>ben_len_shd.g_old_rec.len_attribute11
531: ,p_len_attribute12_o =>ben_len_shd.g_old_rec.len_attribute12
532: ,p_len_attribute13_o =>ben_len_shd.g_old_rec.len_attribute13
533: ,p_len_attribute14_o =>ben_len_shd.g_old_rec.len_attribute14
526: ,p_len_attribute7_o =>ben_len_shd.g_old_rec.len_attribute7
527: ,p_len_attribute8_o =>ben_len_shd.g_old_rec.len_attribute8
528: ,p_len_attribute9_o =>ben_len_shd.g_old_rec.len_attribute9
529: ,p_len_attribute10_o =>ben_len_shd.g_old_rec.len_attribute10
530: ,p_len_attribute11_o =>ben_len_shd.g_old_rec.len_attribute11
531: ,p_len_attribute12_o =>ben_len_shd.g_old_rec.len_attribute12
532: ,p_len_attribute13_o =>ben_len_shd.g_old_rec.len_attribute13
533: ,p_len_attribute14_o =>ben_len_shd.g_old_rec.len_attribute14
534: ,p_len_attribute15_o =>ben_len_shd.g_old_rec.len_attribute15
527: ,p_len_attribute8_o =>ben_len_shd.g_old_rec.len_attribute8
528: ,p_len_attribute9_o =>ben_len_shd.g_old_rec.len_attribute9
529: ,p_len_attribute10_o =>ben_len_shd.g_old_rec.len_attribute10
530: ,p_len_attribute11_o =>ben_len_shd.g_old_rec.len_attribute11
531: ,p_len_attribute12_o =>ben_len_shd.g_old_rec.len_attribute12
532: ,p_len_attribute13_o =>ben_len_shd.g_old_rec.len_attribute13
533: ,p_len_attribute14_o =>ben_len_shd.g_old_rec.len_attribute14
534: ,p_len_attribute15_o =>ben_len_shd.g_old_rec.len_attribute15
535: ,p_len_attribute16_o =>ben_len_shd.g_old_rec.len_attribute16
528: ,p_len_attribute9_o =>ben_len_shd.g_old_rec.len_attribute9
529: ,p_len_attribute10_o =>ben_len_shd.g_old_rec.len_attribute10
530: ,p_len_attribute11_o =>ben_len_shd.g_old_rec.len_attribute11
531: ,p_len_attribute12_o =>ben_len_shd.g_old_rec.len_attribute12
532: ,p_len_attribute13_o =>ben_len_shd.g_old_rec.len_attribute13
533: ,p_len_attribute14_o =>ben_len_shd.g_old_rec.len_attribute14
534: ,p_len_attribute15_o =>ben_len_shd.g_old_rec.len_attribute15
535: ,p_len_attribute16_o =>ben_len_shd.g_old_rec.len_attribute16
536: ,p_len_attribute17_o =>ben_len_shd.g_old_rec.len_attribute17
529: ,p_len_attribute10_o =>ben_len_shd.g_old_rec.len_attribute10
530: ,p_len_attribute11_o =>ben_len_shd.g_old_rec.len_attribute11
531: ,p_len_attribute12_o =>ben_len_shd.g_old_rec.len_attribute12
532: ,p_len_attribute13_o =>ben_len_shd.g_old_rec.len_attribute13
533: ,p_len_attribute14_o =>ben_len_shd.g_old_rec.len_attribute14
534: ,p_len_attribute15_o =>ben_len_shd.g_old_rec.len_attribute15
535: ,p_len_attribute16_o =>ben_len_shd.g_old_rec.len_attribute16
536: ,p_len_attribute17_o =>ben_len_shd.g_old_rec.len_attribute17
537: ,p_len_attribute18_o =>ben_len_shd.g_old_rec.len_attribute18
530: ,p_len_attribute11_o =>ben_len_shd.g_old_rec.len_attribute11
531: ,p_len_attribute12_o =>ben_len_shd.g_old_rec.len_attribute12
532: ,p_len_attribute13_o =>ben_len_shd.g_old_rec.len_attribute13
533: ,p_len_attribute14_o =>ben_len_shd.g_old_rec.len_attribute14
534: ,p_len_attribute15_o =>ben_len_shd.g_old_rec.len_attribute15
535: ,p_len_attribute16_o =>ben_len_shd.g_old_rec.len_attribute16
536: ,p_len_attribute17_o =>ben_len_shd.g_old_rec.len_attribute17
537: ,p_len_attribute18_o =>ben_len_shd.g_old_rec.len_attribute18
538: ,p_len_attribute19_o =>ben_len_shd.g_old_rec.len_attribute19
531: ,p_len_attribute12_o =>ben_len_shd.g_old_rec.len_attribute12
532: ,p_len_attribute13_o =>ben_len_shd.g_old_rec.len_attribute13
533: ,p_len_attribute14_o =>ben_len_shd.g_old_rec.len_attribute14
534: ,p_len_attribute15_o =>ben_len_shd.g_old_rec.len_attribute15
535: ,p_len_attribute16_o =>ben_len_shd.g_old_rec.len_attribute16
536: ,p_len_attribute17_o =>ben_len_shd.g_old_rec.len_attribute17
537: ,p_len_attribute18_o =>ben_len_shd.g_old_rec.len_attribute18
538: ,p_len_attribute19_o =>ben_len_shd.g_old_rec.len_attribute19
539: ,p_len_attribute20_o =>ben_len_shd.g_old_rec.len_attribute20
532: ,p_len_attribute13_o =>ben_len_shd.g_old_rec.len_attribute13
533: ,p_len_attribute14_o =>ben_len_shd.g_old_rec.len_attribute14
534: ,p_len_attribute15_o =>ben_len_shd.g_old_rec.len_attribute15
535: ,p_len_attribute16_o =>ben_len_shd.g_old_rec.len_attribute16
536: ,p_len_attribute17_o =>ben_len_shd.g_old_rec.len_attribute17
537: ,p_len_attribute18_o =>ben_len_shd.g_old_rec.len_attribute18
538: ,p_len_attribute19_o =>ben_len_shd.g_old_rec.len_attribute19
539: ,p_len_attribute20_o =>ben_len_shd.g_old_rec.len_attribute20
540: ,p_len_attribute21_o =>ben_len_shd.g_old_rec.len_attribute21
533: ,p_len_attribute14_o =>ben_len_shd.g_old_rec.len_attribute14
534: ,p_len_attribute15_o =>ben_len_shd.g_old_rec.len_attribute15
535: ,p_len_attribute16_o =>ben_len_shd.g_old_rec.len_attribute16
536: ,p_len_attribute17_o =>ben_len_shd.g_old_rec.len_attribute17
537: ,p_len_attribute18_o =>ben_len_shd.g_old_rec.len_attribute18
538: ,p_len_attribute19_o =>ben_len_shd.g_old_rec.len_attribute19
539: ,p_len_attribute20_o =>ben_len_shd.g_old_rec.len_attribute20
540: ,p_len_attribute21_o =>ben_len_shd.g_old_rec.len_attribute21
541: ,p_len_attribute22_o =>ben_len_shd.g_old_rec.len_attribute22
534: ,p_len_attribute15_o =>ben_len_shd.g_old_rec.len_attribute15
535: ,p_len_attribute16_o =>ben_len_shd.g_old_rec.len_attribute16
536: ,p_len_attribute17_o =>ben_len_shd.g_old_rec.len_attribute17
537: ,p_len_attribute18_o =>ben_len_shd.g_old_rec.len_attribute18
538: ,p_len_attribute19_o =>ben_len_shd.g_old_rec.len_attribute19
539: ,p_len_attribute20_o =>ben_len_shd.g_old_rec.len_attribute20
540: ,p_len_attribute21_o =>ben_len_shd.g_old_rec.len_attribute21
541: ,p_len_attribute22_o =>ben_len_shd.g_old_rec.len_attribute22
542: ,p_len_attribute23_o =>ben_len_shd.g_old_rec.len_attribute23
535: ,p_len_attribute16_o =>ben_len_shd.g_old_rec.len_attribute16
536: ,p_len_attribute17_o =>ben_len_shd.g_old_rec.len_attribute17
537: ,p_len_attribute18_o =>ben_len_shd.g_old_rec.len_attribute18
538: ,p_len_attribute19_o =>ben_len_shd.g_old_rec.len_attribute19
539: ,p_len_attribute20_o =>ben_len_shd.g_old_rec.len_attribute20
540: ,p_len_attribute21_o =>ben_len_shd.g_old_rec.len_attribute21
541: ,p_len_attribute22_o =>ben_len_shd.g_old_rec.len_attribute22
542: ,p_len_attribute23_o =>ben_len_shd.g_old_rec.len_attribute23
543: ,p_len_attribute24_o =>ben_len_shd.g_old_rec.len_attribute24
536: ,p_len_attribute17_o =>ben_len_shd.g_old_rec.len_attribute17
537: ,p_len_attribute18_o =>ben_len_shd.g_old_rec.len_attribute18
538: ,p_len_attribute19_o =>ben_len_shd.g_old_rec.len_attribute19
539: ,p_len_attribute20_o =>ben_len_shd.g_old_rec.len_attribute20
540: ,p_len_attribute21_o =>ben_len_shd.g_old_rec.len_attribute21
541: ,p_len_attribute22_o =>ben_len_shd.g_old_rec.len_attribute22
542: ,p_len_attribute23_o =>ben_len_shd.g_old_rec.len_attribute23
543: ,p_len_attribute24_o =>ben_len_shd.g_old_rec.len_attribute24
544: ,p_len_attribute25_o =>ben_len_shd.g_old_rec.len_attribute25
537: ,p_len_attribute18_o =>ben_len_shd.g_old_rec.len_attribute18
538: ,p_len_attribute19_o =>ben_len_shd.g_old_rec.len_attribute19
539: ,p_len_attribute20_o =>ben_len_shd.g_old_rec.len_attribute20
540: ,p_len_attribute21_o =>ben_len_shd.g_old_rec.len_attribute21
541: ,p_len_attribute22_o =>ben_len_shd.g_old_rec.len_attribute22
542: ,p_len_attribute23_o =>ben_len_shd.g_old_rec.len_attribute23
543: ,p_len_attribute24_o =>ben_len_shd.g_old_rec.len_attribute24
544: ,p_len_attribute25_o =>ben_len_shd.g_old_rec.len_attribute25
545: ,p_len_attribute26_o =>ben_len_shd.g_old_rec.len_attribute26
538: ,p_len_attribute19_o =>ben_len_shd.g_old_rec.len_attribute19
539: ,p_len_attribute20_o =>ben_len_shd.g_old_rec.len_attribute20
540: ,p_len_attribute21_o =>ben_len_shd.g_old_rec.len_attribute21
541: ,p_len_attribute22_o =>ben_len_shd.g_old_rec.len_attribute22
542: ,p_len_attribute23_o =>ben_len_shd.g_old_rec.len_attribute23
543: ,p_len_attribute24_o =>ben_len_shd.g_old_rec.len_attribute24
544: ,p_len_attribute25_o =>ben_len_shd.g_old_rec.len_attribute25
545: ,p_len_attribute26_o =>ben_len_shd.g_old_rec.len_attribute26
546: ,p_len_attribute27_o =>ben_len_shd.g_old_rec.len_attribute27
539: ,p_len_attribute20_o =>ben_len_shd.g_old_rec.len_attribute20
540: ,p_len_attribute21_o =>ben_len_shd.g_old_rec.len_attribute21
541: ,p_len_attribute22_o =>ben_len_shd.g_old_rec.len_attribute22
542: ,p_len_attribute23_o =>ben_len_shd.g_old_rec.len_attribute23
543: ,p_len_attribute24_o =>ben_len_shd.g_old_rec.len_attribute24
544: ,p_len_attribute25_o =>ben_len_shd.g_old_rec.len_attribute25
545: ,p_len_attribute26_o =>ben_len_shd.g_old_rec.len_attribute26
546: ,p_len_attribute27_o =>ben_len_shd.g_old_rec.len_attribute27
547: ,p_len_attribute28_o =>ben_len_shd.g_old_rec.len_attribute28
540: ,p_len_attribute21_o =>ben_len_shd.g_old_rec.len_attribute21
541: ,p_len_attribute22_o =>ben_len_shd.g_old_rec.len_attribute22
542: ,p_len_attribute23_o =>ben_len_shd.g_old_rec.len_attribute23
543: ,p_len_attribute24_o =>ben_len_shd.g_old_rec.len_attribute24
544: ,p_len_attribute25_o =>ben_len_shd.g_old_rec.len_attribute25
545: ,p_len_attribute26_o =>ben_len_shd.g_old_rec.len_attribute26
546: ,p_len_attribute27_o =>ben_len_shd.g_old_rec.len_attribute27
547: ,p_len_attribute28_o =>ben_len_shd.g_old_rec.len_attribute28
548: ,p_len_attribute29_o =>ben_len_shd.g_old_rec.len_attribute29
541: ,p_len_attribute22_o =>ben_len_shd.g_old_rec.len_attribute22
542: ,p_len_attribute23_o =>ben_len_shd.g_old_rec.len_attribute23
543: ,p_len_attribute24_o =>ben_len_shd.g_old_rec.len_attribute24
544: ,p_len_attribute25_o =>ben_len_shd.g_old_rec.len_attribute25
545: ,p_len_attribute26_o =>ben_len_shd.g_old_rec.len_attribute26
546: ,p_len_attribute27_o =>ben_len_shd.g_old_rec.len_attribute27
547: ,p_len_attribute28_o =>ben_len_shd.g_old_rec.len_attribute28
548: ,p_len_attribute29_o =>ben_len_shd.g_old_rec.len_attribute29
549: ,p_len_attribute30_o =>ben_len_shd.g_old_rec.len_attribute30
542: ,p_len_attribute23_o =>ben_len_shd.g_old_rec.len_attribute23
543: ,p_len_attribute24_o =>ben_len_shd.g_old_rec.len_attribute24
544: ,p_len_attribute25_o =>ben_len_shd.g_old_rec.len_attribute25
545: ,p_len_attribute26_o =>ben_len_shd.g_old_rec.len_attribute26
546: ,p_len_attribute27_o =>ben_len_shd.g_old_rec.len_attribute27
547: ,p_len_attribute28_o =>ben_len_shd.g_old_rec.len_attribute28
548: ,p_len_attribute29_o =>ben_len_shd.g_old_rec.len_attribute29
549: ,p_len_attribute30_o =>ben_len_shd.g_old_rec.len_attribute30
550: ,p_object_version_number_o =>ben_len_shd.g_old_rec.object_version_number
543: ,p_len_attribute24_o =>ben_len_shd.g_old_rec.len_attribute24
544: ,p_len_attribute25_o =>ben_len_shd.g_old_rec.len_attribute25
545: ,p_len_attribute26_o =>ben_len_shd.g_old_rec.len_attribute26
546: ,p_len_attribute27_o =>ben_len_shd.g_old_rec.len_attribute27
547: ,p_len_attribute28_o =>ben_len_shd.g_old_rec.len_attribute28
548: ,p_len_attribute29_o =>ben_len_shd.g_old_rec.len_attribute29
549: ,p_len_attribute30_o =>ben_len_shd.g_old_rec.len_attribute30
550: ,p_object_version_number_o =>ben_len_shd.g_old_rec.object_version_number
551: --,p_enrt_perd_det_ovrlp_bckdt_cd_o =>ben_len_shd.g_old_rec.enrt_perd_det_ovrlp_bckdt_cd
544: ,p_len_attribute25_o =>ben_len_shd.g_old_rec.len_attribute25
545: ,p_len_attribute26_o =>ben_len_shd.g_old_rec.len_attribute26
546: ,p_len_attribute27_o =>ben_len_shd.g_old_rec.len_attribute27
547: ,p_len_attribute28_o =>ben_len_shd.g_old_rec.len_attribute28
548: ,p_len_attribute29_o =>ben_len_shd.g_old_rec.len_attribute29
549: ,p_len_attribute30_o =>ben_len_shd.g_old_rec.len_attribute30
550: ,p_object_version_number_o =>ben_len_shd.g_old_rec.object_version_number
551: --,p_enrt_perd_det_ovrlp_bckdt_cd_o =>ben_len_shd.g_old_rec.enrt_perd_det_ovrlp_bckdt_cd
552: ,p_enrt_perd_det_ovrlp_cd_o =>ben_len_shd.g_old_rec.enrt_perd_det_ovrlp_bckdt_cd
545: ,p_len_attribute26_o =>ben_len_shd.g_old_rec.len_attribute26
546: ,p_len_attribute27_o =>ben_len_shd.g_old_rec.len_attribute27
547: ,p_len_attribute28_o =>ben_len_shd.g_old_rec.len_attribute28
548: ,p_len_attribute29_o =>ben_len_shd.g_old_rec.len_attribute29
549: ,p_len_attribute30_o =>ben_len_shd.g_old_rec.len_attribute30
550: ,p_object_version_number_o =>ben_len_shd.g_old_rec.object_version_number
551: --,p_enrt_perd_det_ovrlp_bckdt_cd_o =>ben_len_shd.g_old_rec.enrt_perd_det_ovrlp_bckdt_cd
552: ,p_enrt_perd_det_ovrlp_cd_o =>ben_len_shd.g_old_rec.enrt_perd_det_ovrlp_bckdt_cd
553: ,p_reinstate_cd_o =>ben_len_shd.g_old_rec.reinstate_cd
546: ,p_len_attribute27_o =>ben_len_shd.g_old_rec.len_attribute27
547: ,p_len_attribute28_o =>ben_len_shd.g_old_rec.len_attribute28
548: ,p_len_attribute29_o =>ben_len_shd.g_old_rec.len_attribute29
549: ,p_len_attribute30_o =>ben_len_shd.g_old_rec.len_attribute30
550: ,p_object_version_number_o =>ben_len_shd.g_old_rec.object_version_number
551: --,p_enrt_perd_det_ovrlp_bckdt_cd_o =>ben_len_shd.g_old_rec.enrt_perd_det_ovrlp_bckdt_cd
552: ,p_enrt_perd_det_ovrlp_cd_o =>ben_len_shd.g_old_rec.enrt_perd_det_ovrlp_bckdt_cd
553: ,p_reinstate_cd_o =>ben_len_shd.g_old_rec.reinstate_cd
554: ,p_reinstate_ovrdn_cd_o =>ben_len_shd.g_old_rec.reinstate_ovrdn_cd
547: ,p_len_attribute28_o =>ben_len_shd.g_old_rec.len_attribute28
548: ,p_len_attribute29_o =>ben_len_shd.g_old_rec.len_attribute29
549: ,p_len_attribute30_o =>ben_len_shd.g_old_rec.len_attribute30
550: ,p_object_version_number_o =>ben_len_shd.g_old_rec.object_version_number
551: --,p_enrt_perd_det_ovrlp_bckdt_cd_o =>ben_len_shd.g_old_rec.enrt_perd_det_ovrlp_bckdt_cd
552: ,p_enrt_perd_det_ovrlp_cd_o =>ben_len_shd.g_old_rec.enrt_perd_det_ovrlp_bckdt_cd
553: ,p_reinstate_cd_o =>ben_len_shd.g_old_rec.reinstate_cd
554: ,p_reinstate_ovrdn_cd_o =>ben_len_shd.g_old_rec.reinstate_ovrdn_cd
555: ,p_reopen_le_on_reprocess_o =>ben_len_shd.g_old_rec.reopen_le_on_reprocess
548: ,p_len_attribute29_o =>ben_len_shd.g_old_rec.len_attribute29
549: ,p_len_attribute30_o =>ben_len_shd.g_old_rec.len_attribute30
550: ,p_object_version_number_o =>ben_len_shd.g_old_rec.object_version_number
551: --,p_enrt_perd_det_ovrlp_bckdt_cd_o =>ben_len_shd.g_old_rec.enrt_perd_det_ovrlp_bckdt_cd
552: ,p_enrt_perd_det_ovrlp_cd_o =>ben_len_shd.g_old_rec.enrt_perd_det_ovrlp_bckdt_cd
553: ,p_reinstate_cd_o =>ben_len_shd.g_old_rec.reinstate_cd
554: ,p_reinstate_ovrdn_cd_o =>ben_len_shd.g_old_rec.reinstate_ovrdn_cd
555: ,p_reopen_le_on_reprocess_o =>ben_len_shd.g_old_rec.reopen_le_on_reprocess
556: ,p_ENRT_PERD_STRT_DAYS_o =>ben_len_shd.g_old_rec.ENRT_PERD_STRT_DAYS
549: ,p_len_attribute30_o =>ben_len_shd.g_old_rec.len_attribute30
550: ,p_object_version_number_o =>ben_len_shd.g_old_rec.object_version_number
551: --,p_enrt_perd_det_ovrlp_bckdt_cd_o =>ben_len_shd.g_old_rec.enrt_perd_det_ovrlp_bckdt_cd
552: ,p_enrt_perd_det_ovrlp_cd_o =>ben_len_shd.g_old_rec.enrt_perd_det_ovrlp_bckdt_cd
553: ,p_reinstate_cd_o =>ben_len_shd.g_old_rec.reinstate_cd
554: ,p_reinstate_ovrdn_cd_o =>ben_len_shd.g_old_rec.reinstate_ovrdn_cd
555: ,p_reopen_le_on_reprocess_o =>ben_len_shd.g_old_rec.reopen_le_on_reprocess
556: ,p_ENRT_PERD_STRT_DAYS_o =>ben_len_shd.g_old_rec.ENRT_PERD_STRT_DAYS
557: ,p_ENRT_PERD_END_DAYS_o =>ben_len_shd.g_old_rec.ENRT_PERD_END_DAYS
550: ,p_object_version_number_o =>ben_len_shd.g_old_rec.object_version_number
551: --,p_enrt_perd_det_ovrlp_bckdt_cd_o =>ben_len_shd.g_old_rec.enrt_perd_det_ovrlp_bckdt_cd
552: ,p_enrt_perd_det_ovrlp_cd_o =>ben_len_shd.g_old_rec.enrt_perd_det_ovrlp_bckdt_cd
553: ,p_reinstate_cd_o =>ben_len_shd.g_old_rec.reinstate_cd
554: ,p_reinstate_ovrdn_cd_o =>ben_len_shd.g_old_rec.reinstate_ovrdn_cd
555: ,p_reopen_le_on_reprocess_o =>ben_len_shd.g_old_rec.reopen_le_on_reprocess
556: ,p_ENRT_PERD_STRT_DAYS_o =>ben_len_shd.g_old_rec.ENRT_PERD_STRT_DAYS
557: ,p_ENRT_PERD_END_DAYS_o =>ben_len_shd.g_old_rec.ENRT_PERD_END_DAYS
558: ,p_defer_deenrol_flag_o =>ben_len_shd.g_old_rec.defer_deenrol_flag
551: --,p_enrt_perd_det_ovrlp_bckdt_cd_o =>ben_len_shd.g_old_rec.enrt_perd_det_ovrlp_bckdt_cd
552: ,p_enrt_perd_det_ovrlp_cd_o =>ben_len_shd.g_old_rec.enrt_perd_det_ovrlp_bckdt_cd
553: ,p_reinstate_cd_o =>ben_len_shd.g_old_rec.reinstate_cd
554: ,p_reinstate_ovrdn_cd_o =>ben_len_shd.g_old_rec.reinstate_ovrdn_cd
555: ,p_reopen_le_on_reprocess_o =>ben_len_shd.g_old_rec.reopen_le_on_reprocess
556: ,p_ENRT_PERD_STRT_DAYS_o =>ben_len_shd.g_old_rec.ENRT_PERD_STRT_DAYS
557: ,p_ENRT_PERD_END_DAYS_o =>ben_len_shd.g_old_rec.ENRT_PERD_END_DAYS
558: ,p_defer_deenrol_flag_o =>ben_len_shd.g_old_rec.defer_deenrol_flag
559: );
552: ,p_enrt_perd_det_ovrlp_cd_o =>ben_len_shd.g_old_rec.enrt_perd_det_ovrlp_bckdt_cd
553: ,p_reinstate_cd_o =>ben_len_shd.g_old_rec.reinstate_cd
554: ,p_reinstate_ovrdn_cd_o =>ben_len_shd.g_old_rec.reinstate_ovrdn_cd
555: ,p_reopen_le_on_reprocess_o =>ben_len_shd.g_old_rec.reopen_le_on_reprocess
556: ,p_ENRT_PERD_STRT_DAYS_o =>ben_len_shd.g_old_rec.ENRT_PERD_STRT_DAYS
557: ,p_ENRT_PERD_END_DAYS_o =>ben_len_shd.g_old_rec.ENRT_PERD_END_DAYS
558: ,p_defer_deenrol_flag_o =>ben_len_shd.g_old_rec.defer_deenrol_flag
559: );
560: --
553: ,p_reinstate_cd_o =>ben_len_shd.g_old_rec.reinstate_cd
554: ,p_reinstate_ovrdn_cd_o =>ben_len_shd.g_old_rec.reinstate_ovrdn_cd
555: ,p_reopen_le_on_reprocess_o =>ben_len_shd.g_old_rec.reopen_le_on_reprocess
556: ,p_ENRT_PERD_STRT_DAYS_o =>ben_len_shd.g_old_rec.ENRT_PERD_STRT_DAYS
557: ,p_ENRT_PERD_END_DAYS_o =>ben_len_shd.g_old_rec.ENRT_PERD_END_DAYS
558: ,p_defer_deenrol_flag_o =>ben_len_shd.g_old_rec.defer_deenrol_flag
559: );
560: --
561: exception
554: ,p_reinstate_ovrdn_cd_o =>ben_len_shd.g_old_rec.reinstate_ovrdn_cd
555: ,p_reopen_le_on_reprocess_o =>ben_len_shd.g_old_rec.reopen_le_on_reprocess
556: ,p_ENRT_PERD_STRT_DAYS_o =>ben_len_shd.g_old_rec.ENRT_PERD_STRT_DAYS
557: ,p_ENRT_PERD_END_DAYS_o =>ben_len_shd.g_old_rec.ENRT_PERD_END_DAYS
558: ,p_defer_deenrol_flag_o =>ben_len_shd.g_old_rec.defer_deenrol_flag
559: );
560: --
561: exception
562: --
616: -- Internal Row Handler Use Only.
617: --
618: -- {End Of Comments}
619: -- ----------------------------------------------------------------------------
620: Procedure convert_defs(p_rec in out nocopy ben_len_shd.g_rec_type) is
621: --
622: l_proc varchar2(72) := g_package||'convert_defs';
623: --
624: Begin
631: -- is being used then we must set to the 'current' argument value.
632: --
633: If (p_rec.business_group_id = hr_api.g_number) then
634: p_rec.business_group_id :=
635: ben_len_shd.g_old_rec.business_group_id;
636: End If;
637: If (p_rec.popl_enrt_typ_cycl_id = hr_api.g_number) then
638: p_rec.popl_enrt_typ_cycl_id :=
639: ben_len_shd.g_old_rec.popl_enrt_typ_cycl_id;
635: ben_len_shd.g_old_rec.business_group_id;
636: End If;
637: If (p_rec.popl_enrt_typ_cycl_id = hr_api.g_number) then
638: p_rec.popl_enrt_typ_cycl_id :=
639: ben_len_shd.g_old_rec.popl_enrt_typ_cycl_id;
640: End If;
641: If (p_rec.ler_id = hr_api.g_number) then
642: p_rec.ler_id :=
643: ben_len_shd.g_old_rec.ler_id;
639: ben_len_shd.g_old_rec.popl_enrt_typ_cycl_id;
640: End If;
641: If (p_rec.ler_id = hr_api.g_number) then
642: p_rec.ler_id :=
643: ben_len_shd.g_old_rec.ler_id;
644: End If;
645: If (p_rec.cls_enrt_dt_to_use_cd = hr_api.g_varchar2) then
646: p_rec.cls_enrt_dt_to_use_cd :=
647: ben_len_shd.g_old_rec.cls_enrt_dt_to_use_cd;
643: ben_len_shd.g_old_rec.ler_id;
644: End If;
645: If (p_rec.cls_enrt_dt_to_use_cd = hr_api.g_varchar2) then
646: p_rec.cls_enrt_dt_to_use_cd :=
647: ben_len_shd.g_old_rec.cls_enrt_dt_to_use_cd;
648: End If;
649: If (p_rec.dys_aftr_end_to_dflt_num = hr_api.g_number) then
650: p_rec.dys_aftr_end_to_dflt_num :=
651: ben_len_shd.g_old_rec.dys_aftr_end_to_dflt_num;
647: ben_len_shd.g_old_rec.cls_enrt_dt_to_use_cd;
648: End If;
649: If (p_rec.dys_aftr_end_to_dflt_num = hr_api.g_number) then
650: p_rec.dys_aftr_end_to_dflt_num :=
651: ben_len_shd.g_old_rec.dys_aftr_end_to_dflt_num;
652: End If;
653: If (p_rec.enrt_cvg_end_dt_cd = hr_api.g_varchar2) then
654: p_rec.enrt_cvg_end_dt_cd :=
655: ben_len_shd.g_old_rec.enrt_cvg_end_dt_cd;
651: ben_len_shd.g_old_rec.dys_aftr_end_to_dflt_num;
652: End If;
653: If (p_rec.enrt_cvg_end_dt_cd = hr_api.g_varchar2) then
654: p_rec.enrt_cvg_end_dt_cd :=
655: ben_len_shd.g_old_rec.enrt_cvg_end_dt_cd;
656: End If;
657: If (p_rec.enrt_cvg_strt_dt_cd = hr_api.g_varchar2) then
658: p_rec.enrt_cvg_strt_dt_cd :=
659: ben_len_shd.g_old_rec.enrt_cvg_strt_dt_cd;
655: ben_len_shd.g_old_rec.enrt_cvg_end_dt_cd;
656: End If;
657: If (p_rec.enrt_cvg_strt_dt_cd = hr_api.g_varchar2) then
658: p_rec.enrt_cvg_strt_dt_cd :=
659: ben_len_shd.g_old_rec.enrt_cvg_strt_dt_cd;
660: End If;
661: If (p_rec.enrt_perd_strt_dt_cd = hr_api.g_varchar2) then
662: p_rec.enrt_perd_strt_dt_cd :=
663: ben_len_shd.g_old_rec.enrt_perd_strt_dt_cd;
659: ben_len_shd.g_old_rec.enrt_cvg_strt_dt_cd;
660: End If;
661: If (p_rec.enrt_perd_strt_dt_cd = hr_api.g_varchar2) then
662: p_rec.enrt_perd_strt_dt_cd :=
663: ben_len_shd.g_old_rec.enrt_perd_strt_dt_cd;
664: End If;
665: If (p_rec.enrt_perd_strt_dt_rl = hr_api.g_number) then
666: p_rec.enrt_perd_strt_dt_rl :=
667: ben_len_shd.g_old_rec.enrt_perd_strt_dt_rl;
663: ben_len_shd.g_old_rec.enrt_perd_strt_dt_cd;
664: End If;
665: If (p_rec.enrt_perd_strt_dt_rl = hr_api.g_number) then
666: p_rec.enrt_perd_strt_dt_rl :=
667: ben_len_shd.g_old_rec.enrt_perd_strt_dt_rl;
668: End If;
669: If (p_rec.enrt_perd_end_dt_cd = hr_api.g_varchar2) then
670: p_rec.enrt_perd_end_dt_cd :=
671: ben_len_shd.g_old_rec.enrt_perd_end_dt_cd;
667: ben_len_shd.g_old_rec.enrt_perd_strt_dt_rl;
668: End If;
669: If (p_rec.enrt_perd_end_dt_cd = hr_api.g_varchar2) then
670: p_rec.enrt_perd_end_dt_cd :=
671: ben_len_shd.g_old_rec.enrt_perd_end_dt_cd;
672: End If;
673: If (p_rec.enrt_perd_end_dt_rl = hr_api.g_number) then
674: p_rec.enrt_perd_end_dt_rl :=
675: ben_len_shd.g_old_rec.enrt_perd_end_dt_rl;
671: ben_len_shd.g_old_rec.enrt_perd_end_dt_cd;
672: End If;
673: If (p_rec.enrt_perd_end_dt_rl = hr_api.g_number) then
674: p_rec.enrt_perd_end_dt_rl :=
675: ben_len_shd.g_old_rec.enrt_perd_end_dt_rl;
676: End If;
677: If (p_rec.addl_procg_dys_num = hr_api.g_number) then
678: p_rec.addl_procg_dys_num :=
679: ben_len_shd.g_old_rec.addl_procg_dys_num;
675: ben_len_shd.g_old_rec.enrt_perd_end_dt_rl;
676: End If;
677: If (p_rec.addl_procg_dys_num = hr_api.g_number) then
678: p_rec.addl_procg_dys_num :=
679: ben_len_shd.g_old_rec.addl_procg_dys_num;
680: End If;
681: If (p_rec.dys_no_enrl_not_elig_num = hr_api.g_number) then
682: p_rec.dys_no_enrl_not_elig_num :=
683: ben_len_shd.g_old_rec.dys_no_enrl_not_elig_num;
679: ben_len_shd.g_old_rec.addl_procg_dys_num;
680: End If;
681: If (p_rec.dys_no_enrl_not_elig_num = hr_api.g_number) then
682: p_rec.dys_no_enrl_not_elig_num :=
683: ben_len_shd.g_old_rec.dys_no_enrl_not_elig_num;
684: End If;
685: If (p_rec.dys_no_enrl_cant_enrl_num = hr_api.g_number) then
686: p_rec.dys_no_enrl_cant_enrl_num :=
687: ben_len_shd.g_old_rec.dys_no_enrl_cant_enrl_num;
683: ben_len_shd.g_old_rec.dys_no_enrl_not_elig_num;
684: End If;
685: If (p_rec.dys_no_enrl_cant_enrl_num = hr_api.g_number) then
686: p_rec.dys_no_enrl_cant_enrl_num :=
687: ben_len_shd.g_old_rec.dys_no_enrl_cant_enrl_num;
688: End If;
689: If (p_rec.rt_end_dt_cd = hr_api.g_varchar2) then
690: p_rec.rt_end_dt_cd :=
691: ben_len_shd.g_old_rec.rt_end_dt_cd;
687: ben_len_shd.g_old_rec.dys_no_enrl_cant_enrl_num;
688: End If;
689: If (p_rec.rt_end_dt_cd = hr_api.g_varchar2) then
690: p_rec.rt_end_dt_cd :=
691: ben_len_shd.g_old_rec.rt_end_dt_cd;
692: End If;
693: If (p_rec.rt_end_dt_rl = hr_api.g_number) then
694: p_rec.rt_end_dt_rl :=
695: ben_len_shd.g_old_rec.rt_end_dt_rl;
691: ben_len_shd.g_old_rec.rt_end_dt_cd;
692: End If;
693: If (p_rec.rt_end_dt_rl = hr_api.g_number) then
694: p_rec.rt_end_dt_rl :=
695: ben_len_shd.g_old_rec.rt_end_dt_rl;
696: End If;
697: If (p_rec.rt_strt_dt_cd = hr_api.g_varchar2) then
698: p_rec.rt_strt_dt_cd :=
699: ben_len_shd.g_old_rec.rt_strt_dt_cd;
695: ben_len_shd.g_old_rec.rt_end_dt_rl;
696: End If;
697: If (p_rec.rt_strt_dt_cd = hr_api.g_varchar2) then
698: p_rec.rt_strt_dt_cd :=
699: ben_len_shd.g_old_rec.rt_strt_dt_cd;
700: End If;
701: If (p_rec.rt_strt_dt_rl = hr_api.g_number) then
702: p_rec.rt_strt_dt_rl :=
703: ben_len_shd.g_old_rec.rt_strt_dt_rl;
699: ben_len_shd.g_old_rec.rt_strt_dt_cd;
700: End If;
701: If (p_rec.rt_strt_dt_rl = hr_api.g_number) then
702: p_rec.rt_strt_dt_rl :=
703: ben_len_shd.g_old_rec.rt_strt_dt_rl;
704: End If;
705: If (p_rec.enrt_cvg_end_dt_rl = hr_api.g_number) then
706: p_rec.enrt_cvg_end_dt_rl :=
707: ben_len_shd.g_old_rec.enrt_cvg_end_dt_rl;
703: ben_len_shd.g_old_rec.rt_strt_dt_rl;
704: End If;
705: If (p_rec.enrt_cvg_end_dt_rl = hr_api.g_number) then
706: p_rec.enrt_cvg_end_dt_rl :=
707: ben_len_shd.g_old_rec.enrt_cvg_end_dt_rl;
708: End If;
709: If (p_rec.enrt_cvg_strt_dt_rl = hr_api.g_number) then
710: p_rec.enrt_cvg_strt_dt_rl :=
711: ben_len_shd.g_old_rec.enrt_cvg_strt_dt_rl;
707: ben_len_shd.g_old_rec.enrt_cvg_end_dt_rl;
708: End If;
709: If (p_rec.enrt_cvg_strt_dt_rl = hr_api.g_number) then
710: p_rec.enrt_cvg_strt_dt_rl :=
711: ben_len_shd.g_old_rec.enrt_cvg_strt_dt_rl;
712: End If;
713: If (p_rec.len_attribute_category = hr_api.g_varchar2) then
714: p_rec.len_attribute_category :=
715: ben_len_shd.g_old_rec.len_attribute_category;
711: ben_len_shd.g_old_rec.enrt_cvg_strt_dt_rl;
712: End If;
713: If (p_rec.len_attribute_category = hr_api.g_varchar2) then
714: p_rec.len_attribute_category :=
715: ben_len_shd.g_old_rec.len_attribute_category;
716: End If;
717: If (p_rec.len_attribute1 = hr_api.g_varchar2) then
718: p_rec.len_attribute1 :=
719: ben_len_shd.g_old_rec.len_attribute1;
715: ben_len_shd.g_old_rec.len_attribute_category;
716: End If;
717: If (p_rec.len_attribute1 = hr_api.g_varchar2) then
718: p_rec.len_attribute1 :=
719: ben_len_shd.g_old_rec.len_attribute1;
720: End If;
721: If (p_rec.len_attribute2 = hr_api.g_varchar2) then
722: p_rec.len_attribute2 :=
723: ben_len_shd.g_old_rec.len_attribute2;
719: ben_len_shd.g_old_rec.len_attribute1;
720: End If;
721: If (p_rec.len_attribute2 = hr_api.g_varchar2) then
722: p_rec.len_attribute2 :=
723: ben_len_shd.g_old_rec.len_attribute2;
724: End If;
725: If (p_rec.len_attribute3 = hr_api.g_varchar2) then
726: p_rec.len_attribute3 :=
727: ben_len_shd.g_old_rec.len_attribute3;
723: ben_len_shd.g_old_rec.len_attribute2;
724: End If;
725: If (p_rec.len_attribute3 = hr_api.g_varchar2) then
726: p_rec.len_attribute3 :=
727: ben_len_shd.g_old_rec.len_attribute3;
728: End If;
729: If (p_rec.len_attribute4 = hr_api.g_varchar2) then
730: p_rec.len_attribute4 :=
731: ben_len_shd.g_old_rec.len_attribute4;
727: ben_len_shd.g_old_rec.len_attribute3;
728: End If;
729: If (p_rec.len_attribute4 = hr_api.g_varchar2) then
730: p_rec.len_attribute4 :=
731: ben_len_shd.g_old_rec.len_attribute4;
732: End If;
733: If (p_rec.len_attribute5 = hr_api.g_varchar2) then
734: p_rec.len_attribute5 :=
735: ben_len_shd.g_old_rec.len_attribute5;
731: ben_len_shd.g_old_rec.len_attribute4;
732: End If;
733: If (p_rec.len_attribute5 = hr_api.g_varchar2) then
734: p_rec.len_attribute5 :=
735: ben_len_shd.g_old_rec.len_attribute5;
736: End If;
737: If (p_rec.len_attribute6 = hr_api.g_varchar2) then
738: p_rec.len_attribute6 :=
739: ben_len_shd.g_old_rec.len_attribute6;
735: ben_len_shd.g_old_rec.len_attribute5;
736: End If;
737: If (p_rec.len_attribute6 = hr_api.g_varchar2) then
738: p_rec.len_attribute6 :=
739: ben_len_shd.g_old_rec.len_attribute6;
740: End If;
741: If (p_rec.len_attribute7 = hr_api.g_varchar2) then
742: p_rec.len_attribute7 :=
743: ben_len_shd.g_old_rec.len_attribute7;
739: ben_len_shd.g_old_rec.len_attribute6;
740: End If;
741: If (p_rec.len_attribute7 = hr_api.g_varchar2) then
742: p_rec.len_attribute7 :=
743: ben_len_shd.g_old_rec.len_attribute7;
744: End If;
745: If (p_rec.len_attribute8 = hr_api.g_varchar2) then
746: p_rec.len_attribute8 :=
747: ben_len_shd.g_old_rec.len_attribute8;
743: ben_len_shd.g_old_rec.len_attribute7;
744: End If;
745: If (p_rec.len_attribute8 = hr_api.g_varchar2) then
746: p_rec.len_attribute8 :=
747: ben_len_shd.g_old_rec.len_attribute8;
748: End If;
749: If (p_rec.len_attribute9 = hr_api.g_varchar2) then
750: p_rec.len_attribute9 :=
751: ben_len_shd.g_old_rec.len_attribute9;
747: ben_len_shd.g_old_rec.len_attribute8;
748: End If;
749: If (p_rec.len_attribute9 = hr_api.g_varchar2) then
750: p_rec.len_attribute9 :=
751: ben_len_shd.g_old_rec.len_attribute9;
752: End If;
753: If (p_rec.len_attribute10 = hr_api.g_varchar2) then
754: p_rec.len_attribute10 :=
755: ben_len_shd.g_old_rec.len_attribute10;
751: ben_len_shd.g_old_rec.len_attribute9;
752: End If;
753: If (p_rec.len_attribute10 = hr_api.g_varchar2) then
754: p_rec.len_attribute10 :=
755: ben_len_shd.g_old_rec.len_attribute10;
756: End If;
757: If (p_rec.len_attribute11 = hr_api.g_varchar2) then
758: p_rec.len_attribute11 :=
759: ben_len_shd.g_old_rec.len_attribute11;
755: ben_len_shd.g_old_rec.len_attribute10;
756: End If;
757: If (p_rec.len_attribute11 = hr_api.g_varchar2) then
758: p_rec.len_attribute11 :=
759: ben_len_shd.g_old_rec.len_attribute11;
760: End If;
761: If (p_rec.len_attribute12 = hr_api.g_varchar2) then
762: p_rec.len_attribute12 :=
763: ben_len_shd.g_old_rec.len_attribute12;
759: ben_len_shd.g_old_rec.len_attribute11;
760: End If;
761: If (p_rec.len_attribute12 = hr_api.g_varchar2) then
762: p_rec.len_attribute12 :=
763: ben_len_shd.g_old_rec.len_attribute12;
764: End If;
765: If (p_rec.len_attribute13 = hr_api.g_varchar2) then
766: p_rec.len_attribute13 :=
767: ben_len_shd.g_old_rec.len_attribute13;
763: ben_len_shd.g_old_rec.len_attribute12;
764: End If;
765: If (p_rec.len_attribute13 = hr_api.g_varchar2) then
766: p_rec.len_attribute13 :=
767: ben_len_shd.g_old_rec.len_attribute13;
768: End If;
769: If (p_rec.len_attribute14 = hr_api.g_varchar2) then
770: p_rec.len_attribute14 :=
771: ben_len_shd.g_old_rec.len_attribute14;
767: ben_len_shd.g_old_rec.len_attribute13;
768: End If;
769: If (p_rec.len_attribute14 = hr_api.g_varchar2) then
770: p_rec.len_attribute14 :=
771: ben_len_shd.g_old_rec.len_attribute14;
772: End If;
773: If (p_rec.len_attribute15 = hr_api.g_varchar2) then
774: p_rec.len_attribute15 :=
775: ben_len_shd.g_old_rec.len_attribute15;
771: ben_len_shd.g_old_rec.len_attribute14;
772: End If;
773: If (p_rec.len_attribute15 = hr_api.g_varchar2) then
774: p_rec.len_attribute15 :=
775: ben_len_shd.g_old_rec.len_attribute15;
776: End If;
777: If (p_rec.len_attribute16 = hr_api.g_varchar2) then
778: p_rec.len_attribute16 :=
779: ben_len_shd.g_old_rec.len_attribute16;
775: ben_len_shd.g_old_rec.len_attribute15;
776: End If;
777: If (p_rec.len_attribute16 = hr_api.g_varchar2) then
778: p_rec.len_attribute16 :=
779: ben_len_shd.g_old_rec.len_attribute16;
780: End If;
781: If (p_rec.len_attribute17 = hr_api.g_varchar2) then
782: p_rec.len_attribute17 :=
783: ben_len_shd.g_old_rec.len_attribute17;
779: ben_len_shd.g_old_rec.len_attribute16;
780: End If;
781: If (p_rec.len_attribute17 = hr_api.g_varchar2) then
782: p_rec.len_attribute17 :=
783: ben_len_shd.g_old_rec.len_attribute17;
784: End If;
785: If (p_rec.len_attribute18 = hr_api.g_varchar2) then
786: p_rec.len_attribute18 :=
787: ben_len_shd.g_old_rec.len_attribute18;
783: ben_len_shd.g_old_rec.len_attribute17;
784: End If;
785: If (p_rec.len_attribute18 = hr_api.g_varchar2) then
786: p_rec.len_attribute18 :=
787: ben_len_shd.g_old_rec.len_attribute18;
788: End If;
789: If (p_rec.len_attribute19 = hr_api.g_varchar2) then
790: p_rec.len_attribute19 :=
791: ben_len_shd.g_old_rec.len_attribute19;
787: ben_len_shd.g_old_rec.len_attribute18;
788: End If;
789: If (p_rec.len_attribute19 = hr_api.g_varchar2) then
790: p_rec.len_attribute19 :=
791: ben_len_shd.g_old_rec.len_attribute19;
792: End If;
793: If (p_rec.len_attribute20 = hr_api.g_varchar2) then
794: p_rec.len_attribute20 :=
795: ben_len_shd.g_old_rec.len_attribute20;
791: ben_len_shd.g_old_rec.len_attribute19;
792: End If;
793: If (p_rec.len_attribute20 = hr_api.g_varchar2) then
794: p_rec.len_attribute20 :=
795: ben_len_shd.g_old_rec.len_attribute20;
796: End If;
797: If (p_rec.len_attribute21 = hr_api.g_varchar2) then
798: p_rec.len_attribute21 :=
799: ben_len_shd.g_old_rec.len_attribute21;
795: ben_len_shd.g_old_rec.len_attribute20;
796: End If;
797: If (p_rec.len_attribute21 = hr_api.g_varchar2) then
798: p_rec.len_attribute21 :=
799: ben_len_shd.g_old_rec.len_attribute21;
800: End If;
801: If (p_rec.len_attribute22 = hr_api.g_varchar2) then
802: p_rec.len_attribute22 :=
803: ben_len_shd.g_old_rec.len_attribute22;
799: ben_len_shd.g_old_rec.len_attribute21;
800: End If;
801: If (p_rec.len_attribute22 = hr_api.g_varchar2) then
802: p_rec.len_attribute22 :=
803: ben_len_shd.g_old_rec.len_attribute22;
804: End If;
805: If (p_rec.len_attribute23 = hr_api.g_varchar2) then
806: p_rec.len_attribute23 :=
807: ben_len_shd.g_old_rec.len_attribute23;
803: ben_len_shd.g_old_rec.len_attribute22;
804: End If;
805: If (p_rec.len_attribute23 = hr_api.g_varchar2) then
806: p_rec.len_attribute23 :=
807: ben_len_shd.g_old_rec.len_attribute23;
808: End If;
809: If (p_rec.len_attribute24 = hr_api.g_varchar2) then
810: p_rec.len_attribute24 :=
811: ben_len_shd.g_old_rec.len_attribute24;
807: ben_len_shd.g_old_rec.len_attribute23;
808: End If;
809: If (p_rec.len_attribute24 = hr_api.g_varchar2) then
810: p_rec.len_attribute24 :=
811: ben_len_shd.g_old_rec.len_attribute24;
812: End If;
813: If (p_rec.len_attribute25 = hr_api.g_varchar2) then
814: p_rec.len_attribute25 :=
815: ben_len_shd.g_old_rec.len_attribute25;
811: ben_len_shd.g_old_rec.len_attribute24;
812: End If;
813: If (p_rec.len_attribute25 = hr_api.g_varchar2) then
814: p_rec.len_attribute25 :=
815: ben_len_shd.g_old_rec.len_attribute25;
816: End If;
817: If (p_rec.len_attribute26 = hr_api.g_varchar2) then
818: p_rec.len_attribute26 :=
819: ben_len_shd.g_old_rec.len_attribute26;
815: ben_len_shd.g_old_rec.len_attribute25;
816: End If;
817: If (p_rec.len_attribute26 = hr_api.g_varchar2) then
818: p_rec.len_attribute26 :=
819: ben_len_shd.g_old_rec.len_attribute26;
820: End If;
821: If (p_rec.len_attribute27 = hr_api.g_varchar2) then
822: p_rec.len_attribute27 :=
823: ben_len_shd.g_old_rec.len_attribute27;
819: ben_len_shd.g_old_rec.len_attribute26;
820: End If;
821: If (p_rec.len_attribute27 = hr_api.g_varchar2) then
822: p_rec.len_attribute27 :=
823: ben_len_shd.g_old_rec.len_attribute27;
824: End If;
825: If (p_rec.len_attribute28 = hr_api.g_varchar2) then
826: p_rec.len_attribute28 :=
827: ben_len_shd.g_old_rec.len_attribute28;
823: ben_len_shd.g_old_rec.len_attribute27;
824: End If;
825: If (p_rec.len_attribute28 = hr_api.g_varchar2) then
826: p_rec.len_attribute28 :=
827: ben_len_shd.g_old_rec.len_attribute28;
828: End If;
829: If (p_rec.len_attribute29 = hr_api.g_varchar2) then
830: p_rec.len_attribute29 :=
831: ben_len_shd.g_old_rec.len_attribute29;
827: ben_len_shd.g_old_rec.len_attribute28;
828: End If;
829: If (p_rec.len_attribute29 = hr_api.g_varchar2) then
830: p_rec.len_attribute29 :=
831: ben_len_shd.g_old_rec.len_attribute29;
832: End If;
833: If (p_rec.len_attribute30 = hr_api.g_varchar2) then
834: p_rec.len_attribute30 :=
835: ben_len_shd.g_old_rec.len_attribute30;
831: ben_len_shd.g_old_rec.len_attribute29;
832: End If;
833: If (p_rec.len_attribute30 = hr_api.g_varchar2) then
834: p_rec.len_attribute30 :=
835: ben_len_shd.g_old_rec.len_attribute30;
836: End If;
837: If (p_rec.reinstate_cd = hr_api.g_varchar2) then
838: p_rec.reinstate_cd := ben_len_shd.g_old_rec.reinstate_cd;
839: End If;
834: p_rec.len_attribute30 :=
835: ben_len_shd.g_old_rec.len_attribute30;
836: End If;
837: If (p_rec.reinstate_cd = hr_api.g_varchar2) then
838: p_rec.reinstate_cd := ben_len_shd.g_old_rec.reinstate_cd;
839: End If;
840:
841: If (p_rec.reinstate_ovrdn_cd = hr_api.g_varchar2) then
842: p_rec.reinstate_ovrdn_cd := ben_len_shd.g_old_rec.reinstate_ovrdn_cd;
838: p_rec.reinstate_cd := ben_len_shd.g_old_rec.reinstate_cd;
839: End If;
840:
841: If (p_rec.reinstate_ovrdn_cd = hr_api.g_varchar2) then
842: p_rec.reinstate_ovrdn_cd := ben_len_shd.g_old_rec.reinstate_ovrdn_cd;
843: End If;
844:
845: If (p_rec.ENRT_PERD_STRT_DAYS = hr_api.g_number) then
846: p_rec.ENRT_PERD_STRT_DAYS := ben_len_shd.g_old_rec.ENRT_PERD_STRT_DAYS;
842: p_rec.reinstate_ovrdn_cd := ben_len_shd.g_old_rec.reinstate_ovrdn_cd;
843: End If;
844:
845: If (p_rec.ENRT_PERD_STRT_DAYS = hr_api.g_number) then
846: p_rec.ENRT_PERD_STRT_DAYS := ben_len_shd.g_old_rec.ENRT_PERD_STRT_DAYS;
847: End If;
848: If (p_rec.ENRT_PERD_END_DAYS = hr_api.g_number) then
849: p_rec.ENRT_PERD_END_DAYS := ben_len_shd.g_old_rec.ENRT_PERD_END_DAYS;
850: End If;
845: If (p_rec.ENRT_PERD_STRT_DAYS = hr_api.g_number) then
846: p_rec.ENRT_PERD_STRT_DAYS := ben_len_shd.g_old_rec.ENRT_PERD_STRT_DAYS;
847: End If;
848: If (p_rec.ENRT_PERD_END_DAYS = hr_api.g_number) then
849: p_rec.ENRT_PERD_END_DAYS := ben_len_shd.g_old_rec.ENRT_PERD_END_DAYS;
850: End If;
851: If (p_rec.defer_deenrol_flag = hr_api.g_varchar2) then
852: p_rec.defer_deenrol_flag := ben_len_shd.g_old_rec.defer_deenrol_flag;
853: End If;
848: If (p_rec.ENRT_PERD_END_DAYS = hr_api.g_number) then
849: p_rec.ENRT_PERD_END_DAYS := ben_len_shd.g_old_rec.ENRT_PERD_END_DAYS;
850: End If;
851: If (p_rec.defer_deenrol_flag = hr_api.g_varchar2) then
852: p_rec.defer_deenrol_flag := ben_len_shd.g_old_rec.defer_deenrol_flag;
853: End If;
854: If (p_rec.reopen_le_on_reprocess = hr_api.g_varchar2) then
855: p_rec.reopen_le_on_reprocess := ben_len_shd.g_old_rec.reopen_le_on_reprocess;
856: End If;
851: If (p_rec.defer_deenrol_flag = hr_api.g_varchar2) then
852: p_rec.defer_deenrol_flag := ben_len_shd.g_old_rec.defer_deenrol_flag;
853: End If;
854: If (p_rec.reopen_le_on_reprocess = hr_api.g_varchar2) then
855: p_rec.reopen_le_on_reprocess := ben_len_shd.g_old_rec.reopen_le_on_reprocess;
856: End If;
857:
858: --
859: hr_utility.set_location(' Leaving:'||l_proc, 10);
864: -- |---------------------------------< upd >----------------------------------|
865: -- ----------------------------------------------------------------------------
866: Procedure upd
867: (
868: p_rec in out nocopy ben_len_shd.g_rec_type,
869: p_effective_date in date,
870: p_datetrack_mode in varchar2
871: ) is
872: --
882: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
883: --
884: -- We must lock the row which we need to update.
885: --
886: ben_len_shd.lck
887: (p_effective_date => p_effective_date,
888: p_datetrack_mode => p_datetrack_mode,
889: p_lee_rsn_id => p_rec.lee_rsn_id,
890: p_object_version_number => p_rec.object_version_number,
1003: p_ENRT_PERD_END_DAYS in number default hr_api.g_number ,
1004: p_defer_deenrol_flag in varchar2 default hr_api.g_varchar2
1005: ) is
1006: --
1007: l_rec ben_len_shd.g_rec_type;
1008: l_proc varchar2(72) := g_package||'upd';
1009: --
1010: Begin
1011: hr_utility.set_location('Entering:'||l_proc, 5);
1013: -- Call conversion function to turn arguments into the
1014: -- l_rec structure.
1015: --
1016: l_rec :=
1017: ben_len_shd.convert_args
1018: (
1019: p_lee_rsn_id,
1020: null,
1021: null,