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