[Home] [Help]
54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: Procedure dt_update_dml
58: (p_rec in out nocopy ben_pen_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_prtt_enrt_rslt_f',
78: p_base_key_column => 'prtt_enrt_rslt_id',
79: p_base_key_value => p_rec.prtt_enrt_rslt_id);
80: --
81: ben_pen_shd.g_api_dml := true; -- Set the api dml status
82: --
83: -- Update the ben_prtt_enrt_rslt_f Row
84: --
85: update ben_prtt_enrt_rslt_f
157: where prtt_enrt_rslt_id = p_rec.prtt_enrt_rslt_id
158: and effective_start_date = p_validation_start_date
159: and effective_end_date = p_validation_end_date;
160: --
161: ben_pen_shd.g_api_dml := false; -- Unset the api dml status
162: --
163: -- Set the effective start and end dates
164: --
165: p_rec.effective_start_date := p_validation_start_date;
169: hr_utility.set_location(' Leaving:'||l_proc, 15);
170: Exception
171: When hr_api.check_integrity_violated Then
172: -- A check constraint has been violated
173: ben_pen_shd.g_api_dml := false; -- Unset the api dml status
174: ben_pen_shd.constraint_error
175: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
176: When hr_api.unique_integrity_violated Then
177: -- Unique integrity has been violated
170: Exception
171: When hr_api.check_integrity_violated Then
172: -- A check constraint has been violated
173: ben_pen_shd.g_api_dml := false; -- Unset the api dml status
174: ben_pen_shd.constraint_error
175: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
176: When hr_api.unique_integrity_violated Then
177: -- Unique integrity has been violated
178: ben_pen_shd.g_api_dml := false; -- Unset the api dml status
174: ben_pen_shd.constraint_error
175: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
176: When hr_api.unique_integrity_violated Then
177: -- Unique integrity has been violated
178: ben_pen_shd.g_api_dml := false; -- Unset the api dml status
179: ben_pen_shd.constraint_error
180: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
181: When Others Then
182: ben_pen_shd.g_api_dml := false; -- Unset the api dml status
175: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
176: When hr_api.unique_integrity_violated Then
177: -- Unique integrity has been violated
178: ben_pen_shd.g_api_dml := false; -- Unset the api dml status
179: ben_pen_shd.constraint_error
180: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
181: When Others Then
182: ben_pen_shd.g_api_dml := false; -- Unset the api dml status
183: Raise;
178: ben_pen_shd.g_api_dml := false; -- Unset the api dml status
179: ben_pen_shd.constraint_error
180: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
181: When Others Then
182: ben_pen_shd.g_api_dml := false; -- Unset the api dml status
183: Raise;
184: End dt_update_dml;
185: --
186: -- ----------------------------------------------------------------------------
214: --
215: -- {End Of Comments}
216: -- ----------------------------------------------------------------------------
217: Procedure update_dml
218: (p_rec in out nocopy ben_pen_shd.g_rec_type,
219: p_effective_date in date,
220: p_datetrack_mode in varchar2,
221: p_validation_start_date in date,
222: p_validation_end_date in date) is
278: --
279: -- {End Of Comments}
280: -- ----------------------------------------------------------------------------
281: Procedure dt_pre_update
282: (p_rec in out nocopy ben_pen_shd.g_rec_type,
283: p_effective_date in date,
284: p_datetrack_mode in varchar2,
285: p_validation_start_date in date,
286: p_validation_end_date in date) is
300: --
301: if (p_rec.prtt_enrt_rslt_stat_cd = 'VOIDD' /* or
302: p_rec.prtt_enrt_rslt_stat_cd = 'BCKDT' */ ) then
303: --
304: ben_pen_shd.upd_effective_end_date
305: (p_effective_date => p_effective_date,
306: p_base_key_value => p_rec.prtt_enrt_rslt_id,
307: p_new_effective_end_date => (p_validation_start_date - 1),
308: p_validation_start_date => p_validation_start_date,
312: -- 3843657 Ends
313: --
314: else
315: --
316: ben_pen_shd.upd_effective_end_date
317: (p_effective_date => p_effective_date,
318: p_base_key_value => p_rec.prtt_enrt_rslt_id,
319: p_new_effective_end_date => (p_validation_start_date - 1),
320: p_validation_start_date => p_validation_start_date,
383: --
384: -- {End Of Comments}
385: -- ----------------------------------------------------------------------------
386: Procedure pre_update
387: (p_rec in out nocopy ben_pen_shd.g_rec_type,
388: p_effective_date in date,
389: p_datetrack_mode in varchar2,
390: p_validation_start_date in date,
391: p_validation_end_date in date) is
514: --
515: -- {End Of Comments}
516: -- ----------------------------------------------------------------------------
517: Procedure post_update
518: (p_rec in ben_pen_shd.g_rec_type,
519: p_effective_date in date,
520: p_datetrack_mode in varchar2,
521: p_validation_start_date in date,
522: p_validation_end_date in date) is
607: ,p_effective_date =>p_effective_date
608: ,p_datetrack_mode =>p_datetrack_mode
609: ,p_validation_start_date =>p_validation_start_date
610: ,p_validation_end_date =>p_validation_end_date
611: ,p_effective_start_date_o =>ben_pen_shd.g_old_rec.effective_start_date
612: ,p_effective_end_date_o =>ben_pen_shd.g_old_rec.effective_end_date
613: ,p_business_group_id_o =>ben_pen_shd.g_old_rec.business_group_id
614: ,p_oipl_id_o =>ben_pen_shd.g_old_rec.oipl_id
615: ,p_person_id_o =>ben_pen_shd.g_old_rec.person_id
608: ,p_datetrack_mode =>p_datetrack_mode
609: ,p_validation_start_date =>p_validation_start_date
610: ,p_validation_end_date =>p_validation_end_date
611: ,p_effective_start_date_o =>ben_pen_shd.g_old_rec.effective_start_date
612: ,p_effective_end_date_o =>ben_pen_shd.g_old_rec.effective_end_date
613: ,p_business_group_id_o =>ben_pen_shd.g_old_rec.business_group_id
614: ,p_oipl_id_o =>ben_pen_shd.g_old_rec.oipl_id
615: ,p_person_id_o =>ben_pen_shd.g_old_rec.person_id
616: ,p_assignment_id_o =>ben_pen_shd.g_old_rec.assignment_id
609: ,p_validation_start_date =>p_validation_start_date
610: ,p_validation_end_date =>p_validation_end_date
611: ,p_effective_start_date_o =>ben_pen_shd.g_old_rec.effective_start_date
612: ,p_effective_end_date_o =>ben_pen_shd.g_old_rec.effective_end_date
613: ,p_business_group_id_o =>ben_pen_shd.g_old_rec.business_group_id
614: ,p_oipl_id_o =>ben_pen_shd.g_old_rec.oipl_id
615: ,p_person_id_o =>ben_pen_shd.g_old_rec.person_id
616: ,p_assignment_id_o =>ben_pen_shd.g_old_rec.assignment_id
617: ,p_pgm_id_o =>ben_pen_shd.g_old_rec.pgm_id
610: ,p_validation_end_date =>p_validation_end_date
611: ,p_effective_start_date_o =>ben_pen_shd.g_old_rec.effective_start_date
612: ,p_effective_end_date_o =>ben_pen_shd.g_old_rec.effective_end_date
613: ,p_business_group_id_o =>ben_pen_shd.g_old_rec.business_group_id
614: ,p_oipl_id_o =>ben_pen_shd.g_old_rec.oipl_id
615: ,p_person_id_o =>ben_pen_shd.g_old_rec.person_id
616: ,p_assignment_id_o =>ben_pen_shd.g_old_rec.assignment_id
617: ,p_pgm_id_o =>ben_pen_shd.g_old_rec.pgm_id
618: ,p_pl_id_o =>ben_pen_shd.g_old_rec.pl_id
611: ,p_effective_start_date_o =>ben_pen_shd.g_old_rec.effective_start_date
612: ,p_effective_end_date_o =>ben_pen_shd.g_old_rec.effective_end_date
613: ,p_business_group_id_o =>ben_pen_shd.g_old_rec.business_group_id
614: ,p_oipl_id_o =>ben_pen_shd.g_old_rec.oipl_id
615: ,p_person_id_o =>ben_pen_shd.g_old_rec.person_id
616: ,p_assignment_id_o =>ben_pen_shd.g_old_rec.assignment_id
617: ,p_pgm_id_o =>ben_pen_shd.g_old_rec.pgm_id
618: ,p_pl_id_o =>ben_pen_shd.g_old_rec.pl_id
619: ,p_rplcs_sspndd_rslt_id_o =>ben_pen_shd.g_old_rec.rplcs_sspndd_rslt_id
612: ,p_effective_end_date_o =>ben_pen_shd.g_old_rec.effective_end_date
613: ,p_business_group_id_o =>ben_pen_shd.g_old_rec.business_group_id
614: ,p_oipl_id_o =>ben_pen_shd.g_old_rec.oipl_id
615: ,p_person_id_o =>ben_pen_shd.g_old_rec.person_id
616: ,p_assignment_id_o =>ben_pen_shd.g_old_rec.assignment_id
617: ,p_pgm_id_o =>ben_pen_shd.g_old_rec.pgm_id
618: ,p_pl_id_o =>ben_pen_shd.g_old_rec.pl_id
619: ,p_rplcs_sspndd_rslt_id_o =>ben_pen_shd.g_old_rec.rplcs_sspndd_rslt_id
620: ,p_ptip_id_o =>ben_pen_shd.g_old_rec.ptip_id
613: ,p_business_group_id_o =>ben_pen_shd.g_old_rec.business_group_id
614: ,p_oipl_id_o =>ben_pen_shd.g_old_rec.oipl_id
615: ,p_person_id_o =>ben_pen_shd.g_old_rec.person_id
616: ,p_assignment_id_o =>ben_pen_shd.g_old_rec.assignment_id
617: ,p_pgm_id_o =>ben_pen_shd.g_old_rec.pgm_id
618: ,p_pl_id_o =>ben_pen_shd.g_old_rec.pl_id
619: ,p_rplcs_sspndd_rslt_id_o =>ben_pen_shd.g_old_rec.rplcs_sspndd_rslt_id
620: ,p_ptip_id_o =>ben_pen_shd.g_old_rec.ptip_id
621: ,p_pl_typ_id_o =>ben_pen_shd.g_old_rec.pl_typ_id
614: ,p_oipl_id_o =>ben_pen_shd.g_old_rec.oipl_id
615: ,p_person_id_o =>ben_pen_shd.g_old_rec.person_id
616: ,p_assignment_id_o =>ben_pen_shd.g_old_rec.assignment_id
617: ,p_pgm_id_o =>ben_pen_shd.g_old_rec.pgm_id
618: ,p_pl_id_o =>ben_pen_shd.g_old_rec.pl_id
619: ,p_rplcs_sspndd_rslt_id_o =>ben_pen_shd.g_old_rec.rplcs_sspndd_rslt_id
620: ,p_ptip_id_o =>ben_pen_shd.g_old_rec.ptip_id
621: ,p_pl_typ_id_o =>ben_pen_shd.g_old_rec.pl_typ_id
622: ,p_ler_id_o =>ben_pen_shd.g_old_rec.ler_id
615: ,p_person_id_o =>ben_pen_shd.g_old_rec.person_id
616: ,p_assignment_id_o =>ben_pen_shd.g_old_rec.assignment_id
617: ,p_pgm_id_o =>ben_pen_shd.g_old_rec.pgm_id
618: ,p_pl_id_o =>ben_pen_shd.g_old_rec.pl_id
619: ,p_rplcs_sspndd_rslt_id_o =>ben_pen_shd.g_old_rec.rplcs_sspndd_rslt_id
620: ,p_ptip_id_o =>ben_pen_shd.g_old_rec.ptip_id
621: ,p_pl_typ_id_o =>ben_pen_shd.g_old_rec.pl_typ_id
622: ,p_ler_id_o =>ben_pen_shd.g_old_rec.ler_id
623: ,p_sspndd_flag_o =>ben_pen_shd.g_old_rec.sspndd_flag
616: ,p_assignment_id_o =>ben_pen_shd.g_old_rec.assignment_id
617: ,p_pgm_id_o =>ben_pen_shd.g_old_rec.pgm_id
618: ,p_pl_id_o =>ben_pen_shd.g_old_rec.pl_id
619: ,p_rplcs_sspndd_rslt_id_o =>ben_pen_shd.g_old_rec.rplcs_sspndd_rslt_id
620: ,p_ptip_id_o =>ben_pen_shd.g_old_rec.ptip_id
621: ,p_pl_typ_id_o =>ben_pen_shd.g_old_rec.pl_typ_id
622: ,p_ler_id_o =>ben_pen_shd.g_old_rec.ler_id
623: ,p_sspndd_flag_o =>ben_pen_shd.g_old_rec.sspndd_flag
624: ,p_prtt_is_cvrd_flag_o =>ben_pen_shd.g_old_rec.prtt_is_cvrd_flag
617: ,p_pgm_id_o =>ben_pen_shd.g_old_rec.pgm_id
618: ,p_pl_id_o =>ben_pen_shd.g_old_rec.pl_id
619: ,p_rplcs_sspndd_rslt_id_o =>ben_pen_shd.g_old_rec.rplcs_sspndd_rslt_id
620: ,p_ptip_id_o =>ben_pen_shd.g_old_rec.ptip_id
621: ,p_pl_typ_id_o =>ben_pen_shd.g_old_rec.pl_typ_id
622: ,p_ler_id_o =>ben_pen_shd.g_old_rec.ler_id
623: ,p_sspndd_flag_o =>ben_pen_shd.g_old_rec.sspndd_flag
624: ,p_prtt_is_cvrd_flag_o =>ben_pen_shd.g_old_rec.prtt_is_cvrd_flag
625: ,p_bnft_amt_o =>ben_pen_shd.g_old_rec.bnft_amt
618: ,p_pl_id_o =>ben_pen_shd.g_old_rec.pl_id
619: ,p_rplcs_sspndd_rslt_id_o =>ben_pen_shd.g_old_rec.rplcs_sspndd_rslt_id
620: ,p_ptip_id_o =>ben_pen_shd.g_old_rec.ptip_id
621: ,p_pl_typ_id_o =>ben_pen_shd.g_old_rec.pl_typ_id
622: ,p_ler_id_o =>ben_pen_shd.g_old_rec.ler_id
623: ,p_sspndd_flag_o =>ben_pen_shd.g_old_rec.sspndd_flag
624: ,p_prtt_is_cvrd_flag_o =>ben_pen_shd.g_old_rec.prtt_is_cvrd_flag
625: ,p_bnft_amt_o =>ben_pen_shd.g_old_rec.bnft_amt
626: ,p_uom_o =>ben_pen_shd.g_old_rec.uom
619: ,p_rplcs_sspndd_rslt_id_o =>ben_pen_shd.g_old_rec.rplcs_sspndd_rslt_id
620: ,p_ptip_id_o =>ben_pen_shd.g_old_rec.ptip_id
621: ,p_pl_typ_id_o =>ben_pen_shd.g_old_rec.pl_typ_id
622: ,p_ler_id_o =>ben_pen_shd.g_old_rec.ler_id
623: ,p_sspndd_flag_o =>ben_pen_shd.g_old_rec.sspndd_flag
624: ,p_prtt_is_cvrd_flag_o =>ben_pen_shd.g_old_rec.prtt_is_cvrd_flag
625: ,p_bnft_amt_o =>ben_pen_shd.g_old_rec.bnft_amt
626: ,p_uom_o =>ben_pen_shd.g_old_rec.uom
627: ,p_orgnl_enrt_dt_o =>ben_pen_shd.g_old_rec.orgnl_enrt_dt
620: ,p_ptip_id_o =>ben_pen_shd.g_old_rec.ptip_id
621: ,p_pl_typ_id_o =>ben_pen_shd.g_old_rec.pl_typ_id
622: ,p_ler_id_o =>ben_pen_shd.g_old_rec.ler_id
623: ,p_sspndd_flag_o =>ben_pen_shd.g_old_rec.sspndd_flag
624: ,p_prtt_is_cvrd_flag_o =>ben_pen_shd.g_old_rec.prtt_is_cvrd_flag
625: ,p_bnft_amt_o =>ben_pen_shd.g_old_rec.bnft_amt
626: ,p_uom_o =>ben_pen_shd.g_old_rec.uom
627: ,p_orgnl_enrt_dt_o =>ben_pen_shd.g_old_rec.orgnl_enrt_dt
628: ,p_enrt_mthd_cd_o =>ben_pen_shd.g_old_rec.enrt_mthd_cd
621: ,p_pl_typ_id_o =>ben_pen_shd.g_old_rec.pl_typ_id
622: ,p_ler_id_o =>ben_pen_shd.g_old_rec.ler_id
623: ,p_sspndd_flag_o =>ben_pen_shd.g_old_rec.sspndd_flag
624: ,p_prtt_is_cvrd_flag_o =>ben_pen_shd.g_old_rec.prtt_is_cvrd_flag
625: ,p_bnft_amt_o =>ben_pen_shd.g_old_rec.bnft_amt
626: ,p_uom_o =>ben_pen_shd.g_old_rec.uom
627: ,p_orgnl_enrt_dt_o =>ben_pen_shd.g_old_rec.orgnl_enrt_dt
628: ,p_enrt_mthd_cd_o =>ben_pen_shd.g_old_rec.enrt_mthd_cd
629: ,p_no_lngr_elig_flag_o =>ben_pen_shd.g_old_rec.no_lngr_elig_flag
622: ,p_ler_id_o =>ben_pen_shd.g_old_rec.ler_id
623: ,p_sspndd_flag_o =>ben_pen_shd.g_old_rec.sspndd_flag
624: ,p_prtt_is_cvrd_flag_o =>ben_pen_shd.g_old_rec.prtt_is_cvrd_flag
625: ,p_bnft_amt_o =>ben_pen_shd.g_old_rec.bnft_amt
626: ,p_uom_o =>ben_pen_shd.g_old_rec.uom
627: ,p_orgnl_enrt_dt_o =>ben_pen_shd.g_old_rec.orgnl_enrt_dt
628: ,p_enrt_mthd_cd_o =>ben_pen_shd.g_old_rec.enrt_mthd_cd
629: ,p_no_lngr_elig_flag_o =>ben_pen_shd.g_old_rec.no_lngr_elig_flag
630: ,p_enrt_ovridn_flag_o =>ben_pen_shd.g_old_rec.enrt_ovridn_flag
623: ,p_sspndd_flag_o =>ben_pen_shd.g_old_rec.sspndd_flag
624: ,p_prtt_is_cvrd_flag_o =>ben_pen_shd.g_old_rec.prtt_is_cvrd_flag
625: ,p_bnft_amt_o =>ben_pen_shd.g_old_rec.bnft_amt
626: ,p_uom_o =>ben_pen_shd.g_old_rec.uom
627: ,p_orgnl_enrt_dt_o =>ben_pen_shd.g_old_rec.orgnl_enrt_dt
628: ,p_enrt_mthd_cd_o =>ben_pen_shd.g_old_rec.enrt_mthd_cd
629: ,p_no_lngr_elig_flag_o =>ben_pen_shd.g_old_rec.no_lngr_elig_flag
630: ,p_enrt_ovridn_flag_o =>ben_pen_shd.g_old_rec.enrt_ovridn_flag
631: ,p_enrt_ovrid_rsn_cd_o =>ben_pen_shd.g_old_rec.enrt_ovrid_rsn_cd
624: ,p_prtt_is_cvrd_flag_o =>ben_pen_shd.g_old_rec.prtt_is_cvrd_flag
625: ,p_bnft_amt_o =>ben_pen_shd.g_old_rec.bnft_amt
626: ,p_uom_o =>ben_pen_shd.g_old_rec.uom
627: ,p_orgnl_enrt_dt_o =>ben_pen_shd.g_old_rec.orgnl_enrt_dt
628: ,p_enrt_mthd_cd_o =>ben_pen_shd.g_old_rec.enrt_mthd_cd
629: ,p_no_lngr_elig_flag_o =>ben_pen_shd.g_old_rec.no_lngr_elig_flag
630: ,p_enrt_ovridn_flag_o =>ben_pen_shd.g_old_rec.enrt_ovridn_flag
631: ,p_enrt_ovrid_rsn_cd_o =>ben_pen_shd.g_old_rec.enrt_ovrid_rsn_cd
632: ,p_erlst_deenrt_dt_o =>ben_pen_shd.g_old_rec.erlst_deenrt_dt
625: ,p_bnft_amt_o =>ben_pen_shd.g_old_rec.bnft_amt
626: ,p_uom_o =>ben_pen_shd.g_old_rec.uom
627: ,p_orgnl_enrt_dt_o =>ben_pen_shd.g_old_rec.orgnl_enrt_dt
628: ,p_enrt_mthd_cd_o =>ben_pen_shd.g_old_rec.enrt_mthd_cd
629: ,p_no_lngr_elig_flag_o =>ben_pen_shd.g_old_rec.no_lngr_elig_flag
630: ,p_enrt_ovridn_flag_o =>ben_pen_shd.g_old_rec.enrt_ovridn_flag
631: ,p_enrt_ovrid_rsn_cd_o =>ben_pen_shd.g_old_rec.enrt_ovrid_rsn_cd
632: ,p_erlst_deenrt_dt_o =>ben_pen_shd.g_old_rec.erlst_deenrt_dt
633: ,p_enrt_cvg_strt_dt_o =>ben_pen_shd.g_old_rec.enrt_cvg_strt_dt
626: ,p_uom_o =>ben_pen_shd.g_old_rec.uom
627: ,p_orgnl_enrt_dt_o =>ben_pen_shd.g_old_rec.orgnl_enrt_dt
628: ,p_enrt_mthd_cd_o =>ben_pen_shd.g_old_rec.enrt_mthd_cd
629: ,p_no_lngr_elig_flag_o =>ben_pen_shd.g_old_rec.no_lngr_elig_flag
630: ,p_enrt_ovridn_flag_o =>ben_pen_shd.g_old_rec.enrt_ovridn_flag
631: ,p_enrt_ovrid_rsn_cd_o =>ben_pen_shd.g_old_rec.enrt_ovrid_rsn_cd
632: ,p_erlst_deenrt_dt_o =>ben_pen_shd.g_old_rec.erlst_deenrt_dt
633: ,p_enrt_cvg_strt_dt_o =>ben_pen_shd.g_old_rec.enrt_cvg_strt_dt
634: ,p_enrt_cvg_thru_dt_o =>ben_pen_shd.g_old_rec.enrt_cvg_thru_dt
627: ,p_orgnl_enrt_dt_o =>ben_pen_shd.g_old_rec.orgnl_enrt_dt
628: ,p_enrt_mthd_cd_o =>ben_pen_shd.g_old_rec.enrt_mthd_cd
629: ,p_no_lngr_elig_flag_o =>ben_pen_shd.g_old_rec.no_lngr_elig_flag
630: ,p_enrt_ovridn_flag_o =>ben_pen_shd.g_old_rec.enrt_ovridn_flag
631: ,p_enrt_ovrid_rsn_cd_o =>ben_pen_shd.g_old_rec.enrt_ovrid_rsn_cd
632: ,p_erlst_deenrt_dt_o =>ben_pen_shd.g_old_rec.erlst_deenrt_dt
633: ,p_enrt_cvg_strt_dt_o =>ben_pen_shd.g_old_rec.enrt_cvg_strt_dt
634: ,p_enrt_cvg_thru_dt_o =>ben_pen_shd.g_old_rec.enrt_cvg_thru_dt
635: ,p_enrt_ovrid_thru_dt_o =>ben_pen_shd.g_old_rec.enrt_ovrid_thru_dt
628: ,p_enrt_mthd_cd_o =>ben_pen_shd.g_old_rec.enrt_mthd_cd
629: ,p_no_lngr_elig_flag_o =>ben_pen_shd.g_old_rec.no_lngr_elig_flag
630: ,p_enrt_ovridn_flag_o =>ben_pen_shd.g_old_rec.enrt_ovridn_flag
631: ,p_enrt_ovrid_rsn_cd_o =>ben_pen_shd.g_old_rec.enrt_ovrid_rsn_cd
632: ,p_erlst_deenrt_dt_o =>ben_pen_shd.g_old_rec.erlst_deenrt_dt
633: ,p_enrt_cvg_strt_dt_o =>ben_pen_shd.g_old_rec.enrt_cvg_strt_dt
634: ,p_enrt_cvg_thru_dt_o =>ben_pen_shd.g_old_rec.enrt_cvg_thru_dt
635: ,p_enrt_ovrid_thru_dt_o =>ben_pen_shd.g_old_rec.enrt_ovrid_thru_dt
636: ,p_pl_ordr_num_o =>ben_pen_shd.g_old_rec.pl_ordr_num
629: ,p_no_lngr_elig_flag_o =>ben_pen_shd.g_old_rec.no_lngr_elig_flag
630: ,p_enrt_ovridn_flag_o =>ben_pen_shd.g_old_rec.enrt_ovridn_flag
631: ,p_enrt_ovrid_rsn_cd_o =>ben_pen_shd.g_old_rec.enrt_ovrid_rsn_cd
632: ,p_erlst_deenrt_dt_o =>ben_pen_shd.g_old_rec.erlst_deenrt_dt
633: ,p_enrt_cvg_strt_dt_o =>ben_pen_shd.g_old_rec.enrt_cvg_strt_dt
634: ,p_enrt_cvg_thru_dt_o =>ben_pen_shd.g_old_rec.enrt_cvg_thru_dt
635: ,p_enrt_ovrid_thru_dt_o =>ben_pen_shd.g_old_rec.enrt_ovrid_thru_dt
636: ,p_pl_ordr_num_o =>ben_pen_shd.g_old_rec.pl_ordr_num
637: ,p_plip_ordr_num_o =>ben_pen_shd.g_old_rec.plip_ordr_num
630: ,p_enrt_ovridn_flag_o =>ben_pen_shd.g_old_rec.enrt_ovridn_flag
631: ,p_enrt_ovrid_rsn_cd_o =>ben_pen_shd.g_old_rec.enrt_ovrid_rsn_cd
632: ,p_erlst_deenrt_dt_o =>ben_pen_shd.g_old_rec.erlst_deenrt_dt
633: ,p_enrt_cvg_strt_dt_o =>ben_pen_shd.g_old_rec.enrt_cvg_strt_dt
634: ,p_enrt_cvg_thru_dt_o =>ben_pen_shd.g_old_rec.enrt_cvg_thru_dt
635: ,p_enrt_ovrid_thru_dt_o =>ben_pen_shd.g_old_rec.enrt_ovrid_thru_dt
636: ,p_pl_ordr_num_o =>ben_pen_shd.g_old_rec.pl_ordr_num
637: ,p_plip_ordr_num_o =>ben_pen_shd.g_old_rec.plip_ordr_num
638: ,p_ptip_ordr_num_o =>ben_pen_shd.g_old_rec.ptip_ordr_num
631: ,p_enrt_ovrid_rsn_cd_o =>ben_pen_shd.g_old_rec.enrt_ovrid_rsn_cd
632: ,p_erlst_deenrt_dt_o =>ben_pen_shd.g_old_rec.erlst_deenrt_dt
633: ,p_enrt_cvg_strt_dt_o =>ben_pen_shd.g_old_rec.enrt_cvg_strt_dt
634: ,p_enrt_cvg_thru_dt_o =>ben_pen_shd.g_old_rec.enrt_cvg_thru_dt
635: ,p_enrt_ovrid_thru_dt_o =>ben_pen_shd.g_old_rec.enrt_ovrid_thru_dt
636: ,p_pl_ordr_num_o =>ben_pen_shd.g_old_rec.pl_ordr_num
637: ,p_plip_ordr_num_o =>ben_pen_shd.g_old_rec.plip_ordr_num
638: ,p_ptip_ordr_num_o =>ben_pen_shd.g_old_rec.ptip_ordr_num
639: ,p_oipl_ordr_num_o =>ben_pen_shd.g_old_rec.oipl_ordr_num
632: ,p_erlst_deenrt_dt_o =>ben_pen_shd.g_old_rec.erlst_deenrt_dt
633: ,p_enrt_cvg_strt_dt_o =>ben_pen_shd.g_old_rec.enrt_cvg_strt_dt
634: ,p_enrt_cvg_thru_dt_o =>ben_pen_shd.g_old_rec.enrt_cvg_thru_dt
635: ,p_enrt_ovrid_thru_dt_o =>ben_pen_shd.g_old_rec.enrt_ovrid_thru_dt
636: ,p_pl_ordr_num_o =>ben_pen_shd.g_old_rec.pl_ordr_num
637: ,p_plip_ordr_num_o =>ben_pen_shd.g_old_rec.plip_ordr_num
638: ,p_ptip_ordr_num_o =>ben_pen_shd.g_old_rec.ptip_ordr_num
639: ,p_oipl_ordr_num_o =>ben_pen_shd.g_old_rec.oipl_ordr_num
640: ,p_pen_attribute_category_o =>ben_pen_shd.g_old_rec.pen_attribute_category
633: ,p_enrt_cvg_strt_dt_o =>ben_pen_shd.g_old_rec.enrt_cvg_strt_dt
634: ,p_enrt_cvg_thru_dt_o =>ben_pen_shd.g_old_rec.enrt_cvg_thru_dt
635: ,p_enrt_ovrid_thru_dt_o =>ben_pen_shd.g_old_rec.enrt_ovrid_thru_dt
636: ,p_pl_ordr_num_o =>ben_pen_shd.g_old_rec.pl_ordr_num
637: ,p_plip_ordr_num_o =>ben_pen_shd.g_old_rec.plip_ordr_num
638: ,p_ptip_ordr_num_o =>ben_pen_shd.g_old_rec.ptip_ordr_num
639: ,p_oipl_ordr_num_o =>ben_pen_shd.g_old_rec.oipl_ordr_num
640: ,p_pen_attribute_category_o =>ben_pen_shd.g_old_rec.pen_attribute_category
641: ,p_pen_attribute1_o =>ben_pen_shd.g_old_rec.pen_attribute1
634: ,p_enrt_cvg_thru_dt_o =>ben_pen_shd.g_old_rec.enrt_cvg_thru_dt
635: ,p_enrt_ovrid_thru_dt_o =>ben_pen_shd.g_old_rec.enrt_ovrid_thru_dt
636: ,p_pl_ordr_num_o =>ben_pen_shd.g_old_rec.pl_ordr_num
637: ,p_plip_ordr_num_o =>ben_pen_shd.g_old_rec.plip_ordr_num
638: ,p_ptip_ordr_num_o =>ben_pen_shd.g_old_rec.ptip_ordr_num
639: ,p_oipl_ordr_num_o =>ben_pen_shd.g_old_rec.oipl_ordr_num
640: ,p_pen_attribute_category_o =>ben_pen_shd.g_old_rec.pen_attribute_category
641: ,p_pen_attribute1_o =>ben_pen_shd.g_old_rec.pen_attribute1
642: ,p_pen_attribute2_o =>ben_pen_shd.g_old_rec.pen_attribute2
635: ,p_enrt_ovrid_thru_dt_o =>ben_pen_shd.g_old_rec.enrt_ovrid_thru_dt
636: ,p_pl_ordr_num_o =>ben_pen_shd.g_old_rec.pl_ordr_num
637: ,p_plip_ordr_num_o =>ben_pen_shd.g_old_rec.plip_ordr_num
638: ,p_ptip_ordr_num_o =>ben_pen_shd.g_old_rec.ptip_ordr_num
639: ,p_oipl_ordr_num_o =>ben_pen_shd.g_old_rec.oipl_ordr_num
640: ,p_pen_attribute_category_o =>ben_pen_shd.g_old_rec.pen_attribute_category
641: ,p_pen_attribute1_o =>ben_pen_shd.g_old_rec.pen_attribute1
642: ,p_pen_attribute2_o =>ben_pen_shd.g_old_rec.pen_attribute2
643: ,p_pen_attribute3_o =>ben_pen_shd.g_old_rec.pen_attribute3
636: ,p_pl_ordr_num_o =>ben_pen_shd.g_old_rec.pl_ordr_num
637: ,p_plip_ordr_num_o =>ben_pen_shd.g_old_rec.plip_ordr_num
638: ,p_ptip_ordr_num_o =>ben_pen_shd.g_old_rec.ptip_ordr_num
639: ,p_oipl_ordr_num_o =>ben_pen_shd.g_old_rec.oipl_ordr_num
640: ,p_pen_attribute_category_o =>ben_pen_shd.g_old_rec.pen_attribute_category
641: ,p_pen_attribute1_o =>ben_pen_shd.g_old_rec.pen_attribute1
642: ,p_pen_attribute2_o =>ben_pen_shd.g_old_rec.pen_attribute2
643: ,p_pen_attribute3_o =>ben_pen_shd.g_old_rec.pen_attribute3
644: ,p_pen_attribute4_o =>ben_pen_shd.g_old_rec.pen_attribute4
637: ,p_plip_ordr_num_o =>ben_pen_shd.g_old_rec.plip_ordr_num
638: ,p_ptip_ordr_num_o =>ben_pen_shd.g_old_rec.ptip_ordr_num
639: ,p_oipl_ordr_num_o =>ben_pen_shd.g_old_rec.oipl_ordr_num
640: ,p_pen_attribute_category_o =>ben_pen_shd.g_old_rec.pen_attribute_category
641: ,p_pen_attribute1_o =>ben_pen_shd.g_old_rec.pen_attribute1
642: ,p_pen_attribute2_o =>ben_pen_shd.g_old_rec.pen_attribute2
643: ,p_pen_attribute3_o =>ben_pen_shd.g_old_rec.pen_attribute3
644: ,p_pen_attribute4_o =>ben_pen_shd.g_old_rec.pen_attribute4
645: ,p_pen_attribute5_o =>ben_pen_shd.g_old_rec.pen_attribute5
638: ,p_ptip_ordr_num_o =>ben_pen_shd.g_old_rec.ptip_ordr_num
639: ,p_oipl_ordr_num_o =>ben_pen_shd.g_old_rec.oipl_ordr_num
640: ,p_pen_attribute_category_o =>ben_pen_shd.g_old_rec.pen_attribute_category
641: ,p_pen_attribute1_o =>ben_pen_shd.g_old_rec.pen_attribute1
642: ,p_pen_attribute2_o =>ben_pen_shd.g_old_rec.pen_attribute2
643: ,p_pen_attribute3_o =>ben_pen_shd.g_old_rec.pen_attribute3
644: ,p_pen_attribute4_o =>ben_pen_shd.g_old_rec.pen_attribute4
645: ,p_pen_attribute5_o =>ben_pen_shd.g_old_rec.pen_attribute5
646: ,p_pen_attribute6_o =>ben_pen_shd.g_old_rec.pen_attribute6
639: ,p_oipl_ordr_num_o =>ben_pen_shd.g_old_rec.oipl_ordr_num
640: ,p_pen_attribute_category_o =>ben_pen_shd.g_old_rec.pen_attribute_category
641: ,p_pen_attribute1_o =>ben_pen_shd.g_old_rec.pen_attribute1
642: ,p_pen_attribute2_o =>ben_pen_shd.g_old_rec.pen_attribute2
643: ,p_pen_attribute3_o =>ben_pen_shd.g_old_rec.pen_attribute3
644: ,p_pen_attribute4_o =>ben_pen_shd.g_old_rec.pen_attribute4
645: ,p_pen_attribute5_o =>ben_pen_shd.g_old_rec.pen_attribute5
646: ,p_pen_attribute6_o =>ben_pen_shd.g_old_rec.pen_attribute6
647: ,p_pen_attribute7_o =>ben_pen_shd.g_old_rec.pen_attribute7
640: ,p_pen_attribute_category_o =>ben_pen_shd.g_old_rec.pen_attribute_category
641: ,p_pen_attribute1_o =>ben_pen_shd.g_old_rec.pen_attribute1
642: ,p_pen_attribute2_o =>ben_pen_shd.g_old_rec.pen_attribute2
643: ,p_pen_attribute3_o =>ben_pen_shd.g_old_rec.pen_attribute3
644: ,p_pen_attribute4_o =>ben_pen_shd.g_old_rec.pen_attribute4
645: ,p_pen_attribute5_o =>ben_pen_shd.g_old_rec.pen_attribute5
646: ,p_pen_attribute6_o =>ben_pen_shd.g_old_rec.pen_attribute6
647: ,p_pen_attribute7_o =>ben_pen_shd.g_old_rec.pen_attribute7
648: ,p_pen_attribute8_o =>ben_pen_shd.g_old_rec.pen_attribute8
641: ,p_pen_attribute1_o =>ben_pen_shd.g_old_rec.pen_attribute1
642: ,p_pen_attribute2_o =>ben_pen_shd.g_old_rec.pen_attribute2
643: ,p_pen_attribute3_o =>ben_pen_shd.g_old_rec.pen_attribute3
644: ,p_pen_attribute4_o =>ben_pen_shd.g_old_rec.pen_attribute4
645: ,p_pen_attribute5_o =>ben_pen_shd.g_old_rec.pen_attribute5
646: ,p_pen_attribute6_o =>ben_pen_shd.g_old_rec.pen_attribute6
647: ,p_pen_attribute7_o =>ben_pen_shd.g_old_rec.pen_attribute7
648: ,p_pen_attribute8_o =>ben_pen_shd.g_old_rec.pen_attribute8
649: ,p_pen_attribute9_o =>ben_pen_shd.g_old_rec.pen_attribute9
642: ,p_pen_attribute2_o =>ben_pen_shd.g_old_rec.pen_attribute2
643: ,p_pen_attribute3_o =>ben_pen_shd.g_old_rec.pen_attribute3
644: ,p_pen_attribute4_o =>ben_pen_shd.g_old_rec.pen_attribute4
645: ,p_pen_attribute5_o =>ben_pen_shd.g_old_rec.pen_attribute5
646: ,p_pen_attribute6_o =>ben_pen_shd.g_old_rec.pen_attribute6
647: ,p_pen_attribute7_o =>ben_pen_shd.g_old_rec.pen_attribute7
648: ,p_pen_attribute8_o =>ben_pen_shd.g_old_rec.pen_attribute8
649: ,p_pen_attribute9_o =>ben_pen_shd.g_old_rec.pen_attribute9
650: ,p_pen_attribute10_o =>ben_pen_shd.g_old_rec.pen_attribute10
643: ,p_pen_attribute3_o =>ben_pen_shd.g_old_rec.pen_attribute3
644: ,p_pen_attribute4_o =>ben_pen_shd.g_old_rec.pen_attribute4
645: ,p_pen_attribute5_o =>ben_pen_shd.g_old_rec.pen_attribute5
646: ,p_pen_attribute6_o =>ben_pen_shd.g_old_rec.pen_attribute6
647: ,p_pen_attribute7_o =>ben_pen_shd.g_old_rec.pen_attribute7
648: ,p_pen_attribute8_o =>ben_pen_shd.g_old_rec.pen_attribute8
649: ,p_pen_attribute9_o =>ben_pen_shd.g_old_rec.pen_attribute9
650: ,p_pen_attribute10_o =>ben_pen_shd.g_old_rec.pen_attribute10
651: ,p_pen_attribute11_o =>ben_pen_shd.g_old_rec.pen_attribute11
644: ,p_pen_attribute4_o =>ben_pen_shd.g_old_rec.pen_attribute4
645: ,p_pen_attribute5_o =>ben_pen_shd.g_old_rec.pen_attribute5
646: ,p_pen_attribute6_o =>ben_pen_shd.g_old_rec.pen_attribute6
647: ,p_pen_attribute7_o =>ben_pen_shd.g_old_rec.pen_attribute7
648: ,p_pen_attribute8_o =>ben_pen_shd.g_old_rec.pen_attribute8
649: ,p_pen_attribute9_o =>ben_pen_shd.g_old_rec.pen_attribute9
650: ,p_pen_attribute10_o =>ben_pen_shd.g_old_rec.pen_attribute10
651: ,p_pen_attribute11_o =>ben_pen_shd.g_old_rec.pen_attribute11
652: ,p_pen_attribute12_o =>ben_pen_shd.g_old_rec.pen_attribute12
645: ,p_pen_attribute5_o =>ben_pen_shd.g_old_rec.pen_attribute5
646: ,p_pen_attribute6_o =>ben_pen_shd.g_old_rec.pen_attribute6
647: ,p_pen_attribute7_o =>ben_pen_shd.g_old_rec.pen_attribute7
648: ,p_pen_attribute8_o =>ben_pen_shd.g_old_rec.pen_attribute8
649: ,p_pen_attribute9_o =>ben_pen_shd.g_old_rec.pen_attribute9
650: ,p_pen_attribute10_o =>ben_pen_shd.g_old_rec.pen_attribute10
651: ,p_pen_attribute11_o =>ben_pen_shd.g_old_rec.pen_attribute11
652: ,p_pen_attribute12_o =>ben_pen_shd.g_old_rec.pen_attribute12
653: ,p_pen_attribute13_o =>ben_pen_shd.g_old_rec.pen_attribute13
646: ,p_pen_attribute6_o =>ben_pen_shd.g_old_rec.pen_attribute6
647: ,p_pen_attribute7_o =>ben_pen_shd.g_old_rec.pen_attribute7
648: ,p_pen_attribute8_o =>ben_pen_shd.g_old_rec.pen_attribute8
649: ,p_pen_attribute9_o =>ben_pen_shd.g_old_rec.pen_attribute9
650: ,p_pen_attribute10_o =>ben_pen_shd.g_old_rec.pen_attribute10
651: ,p_pen_attribute11_o =>ben_pen_shd.g_old_rec.pen_attribute11
652: ,p_pen_attribute12_o =>ben_pen_shd.g_old_rec.pen_attribute12
653: ,p_pen_attribute13_o =>ben_pen_shd.g_old_rec.pen_attribute13
654: ,p_pen_attribute14_o =>ben_pen_shd.g_old_rec.pen_attribute14
647: ,p_pen_attribute7_o =>ben_pen_shd.g_old_rec.pen_attribute7
648: ,p_pen_attribute8_o =>ben_pen_shd.g_old_rec.pen_attribute8
649: ,p_pen_attribute9_o =>ben_pen_shd.g_old_rec.pen_attribute9
650: ,p_pen_attribute10_o =>ben_pen_shd.g_old_rec.pen_attribute10
651: ,p_pen_attribute11_o =>ben_pen_shd.g_old_rec.pen_attribute11
652: ,p_pen_attribute12_o =>ben_pen_shd.g_old_rec.pen_attribute12
653: ,p_pen_attribute13_o =>ben_pen_shd.g_old_rec.pen_attribute13
654: ,p_pen_attribute14_o =>ben_pen_shd.g_old_rec.pen_attribute14
655: ,p_pen_attribute15_o =>ben_pen_shd.g_old_rec.pen_attribute15
648: ,p_pen_attribute8_o =>ben_pen_shd.g_old_rec.pen_attribute8
649: ,p_pen_attribute9_o =>ben_pen_shd.g_old_rec.pen_attribute9
650: ,p_pen_attribute10_o =>ben_pen_shd.g_old_rec.pen_attribute10
651: ,p_pen_attribute11_o =>ben_pen_shd.g_old_rec.pen_attribute11
652: ,p_pen_attribute12_o =>ben_pen_shd.g_old_rec.pen_attribute12
653: ,p_pen_attribute13_o =>ben_pen_shd.g_old_rec.pen_attribute13
654: ,p_pen_attribute14_o =>ben_pen_shd.g_old_rec.pen_attribute14
655: ,p_pen_attribute15_o =>ben_pen_shd.g_old_rec.pen_attribute15
656: ,p_pen_attribute16_o =>ben_pen_shd.g_old_rec.pen_attribute16
649: ,p_pen_attribute9_o =>ben_pen_shd.g_old_rec.pen_attribute9
650: ,p_pen_attribute10_o =>ben_pen_shd.g_old_rec.pen_attribute10
651: ,p_pen_attribute11_o =>ben_pen_shd.g_old_rec.pen_attribute11
652: ,p_pen_attribute12_o =>ben_pen_shd.g_old_rec.pen_attribute12
653: ,p_pen_attribute13_o =>ben_pen_shd.g_old_rec.pen_attribute13
654: ,p_pen_attribute14_o =>ben_pen_shd.g_old_rec.pen_attribute14
655: ,p_pen_attribute15_o =>ben_pen_shd.g_old_rec.pen_attribute15
656: ,p_pen_attribute16_o =>ben_pen_shd.g_old_rec.pen_attribute16
657: ,p_pen_attribute17_o =>ben_pen_shd.g_old_rec.pen_attribute17
650: ,p_pen_attribute10_o =>ben_pen_shd.g_old_rec.pen_attribute10
651: ,p_pen_attribute11_o =>ben_pen_shd.g_old_rec.pen_attribute11
652: ,p_pen_attribute12_o =>ben_pen_shd.g_old_rec.pen_attribute12
653: ,p_pen_attribute13_o =>ben_pen_shd.g_old_rec.pen_attribute13
654: ,p_pen_attribute14_o =>ben_pen_shd.g_old_rec.pen_attribute14
655: ,p_pen_attribute15_o =>ben_pen_shd.g_old_rec.pen_attribute15
656: ,p_pen_attribute16_o =>ben_pen_shd.g_old_rec.pen_attribute16
657: ,p_pen_attribute17_o =>ben_pen_shd.g_old_rec.pen_attribute17
658: ,p_pen_attribute18_o =>ben_pen_shd.g_old_rec.pen_attribute18
651: ,p_pen_attribute11_o =>ben_pen_shd.g_old_rec.pen_attribute11
652: ,p_pen_attribute12_o =>ben_pen_shd.g_old_rec.pen_attribute12
653: ,p_pen_attribute13_o =>ben_pen_shd.g_old_rec.pen_attribute13
654: ,p_pen_attribute14_o =>ben_pen_shd.g_old_rec.pen_attribute14
655: ,p_pen_attribute15_o =>ben_pen_shd.g_old_rec.pen_attribute15
656: ,p_pen_attribute16_o =>ben_pen_shd.g_old_rec.pen_attribute16
657: ,p_pen_attribute17_o =>ben_pen_shd.g_old_rec.pen_attribute17
658: ,p_pen_attribute18_o =>ben_pen_shd.g_old_rec.pen_attribute18
659: ,p_pen_attribute19_o =>ben_pen_shd.g_old_rec.pen_attribute19
652: ,p_pen_attribute12_o =>ben_pen_shd.g_old_rec.pen_attribute12
653: ,p_pen_attribute13_o =>ben_pen_shd.g_old_rec.pen_attribute13
654: ,p_pen_attribute14_o =>ben_pen_shd.g_old_rec.pen_attribute14
655: ,p_pen_attribute15_o =>ben_pen_shd.g_old_rec.pen_attribute15
656: ,p_pen_attribute16_o =>ben_pen_shd.g_old_rec.pen_attribute16
657: ,p_pen_attribute17_o =>ben_pen_shd.g_old_rec.pen_attribute17
658: ,p_pen_attribute18_o =>ben_pen_shd.g_old_rec.pen_attribute18
659: ,p_pen_attribute19_o =>ben_pen_shd.g_old_rec.pen_attribute19
660: ,p_pen_attribute20_o =>ben_pen_shd.g_old_rec.pen_attribute20
653: ,p_pen_attribute13_o =>ben_pen_shd.g_old_rec.pen_attribute13
654: ,p_pen_attribute14_o =>ben_pen_shd.g_old_rec.pen_attribute14
655: ,p_pen_attribute15_o =>ben_pen_shd.g_old_rec.pen_attribute15
656: ,p_pen_attribute16_o =>ben_pen_shd.g_old_rec.pen_attribute16
657: ,p_pen_attribute17_o =>ben_pen_shd.g_old_rec.pen_attribute17
658: ,p_pen_attribute18_o =>ben_pen_shd.g_old_rec.pen_attribute18
659: ,p_pen_attribute19_o =>ben_pen_shd.g_old_rec.pen_attribute19
660: ,p_pen_attribute20_o =>ben_pen_shd.g_old_rec.pen_attribute20
661: ,p_pen_attribute21_o =>ben_pen_shd.g_old_rec.pen_attribute21
654: ,p_pen_attribute14_o =>ben_pen_shd.g_old_rec.pen_attribute14
655: ,p_pen_attribute15_o =>ben_pen_shd.g_old_rec.pen_attribute15
656: ,p_pen_attribute16_o =>ben_pen_shd.g_old_rec.pen_attribute16
657: ,p_pen_attribute17_o =>ben_pen_shd.g_old_rec.pen_attribute17
658: ,p_pen_attribute18_o =>ben_pen_shd.g_old_rec.pen_attribute18
659: ,p_pen_attribute19_o =>ben_pen_shd.g_old_rec.pen_attribute19
660: ,p_pen_attribute20_o =>ben_pen_shd.g_old_rec.pen_attribute20
661: ,p_pen_attribute21_o =>ben_pen_shd.g_old_rec.pen_attribute21
662: ,p_pen_attribute22_o =>ben_pen_shd.g_old_rec.pen_attribute22
655: ,p_pen_attribute15_o =>ben_pen_shd.g_old_rec.pen_attribute15
656: ,p_pen_attribute16_o =>ben_pen_shd.g_old_rec.pen_attribute16
657: ,p_pen_attribute17_o =>ben_pen_shd.g_old_rec.pen_attribute17
658: ,p_pen_attribute18_o =>ben_pen_shd.g_old_rec.pen_attribute18
659: ,p_pen_attribute19_o =>ben_pen_shd.g_old_rec.pen_attribute19
660: ,p_pen_attribute20_o =>ben_pen_shd.g_old_rec.pen_attribute20
661: ,p_pen_attribute21_o =>ben_pen_shd.g_old_rec.pen_attribute21
662: ,p_pen_attribute22_o =>ben_pen_shd.g_old_rec.pen_attribute22
663: ,p_pen_attribute23_o =>ben_pen_shd.g_old_rec.pen_attribute23
656: ,p_pen_attribute16_o =>ben_pen_shd.g_old_rec.pen_attribute16
657: ,p_pen_attribute17_o =>ben_pen_shd.g_old_rec.pen_attribute17
658: ,p_pen_attribute18_o =>ben_pen_shd.g_old_rec.pen_attribute18
659: ,p_pen_attribute19_o =>ben_pen_shd.g_old_rec.pen_attribute19
660: ,p_pen_attribute20_o =>ben_pen_shd.g_old_rec.pen_attribute20
661: ,p_pen_attribute21_o =>ben_pen_shd.g_old_rec.pen_attribute21
662: ,p_pen_attribute22_o =>ben_pen_shd.g_old_rec.pen_attribute22
663: ,p_pen_attribute23_o =>ben_pen_shd.g_old_rec.pen_attribute23
664: ,p_pen_attribute24_o =>ben_pen_shd.g_old_rec.pen_attribute24
657: ,p_pen_attribute17_o =>ben_pen_shd.g_old_rec.pen_attribute17
658: ,p_pen_attribute18_o =>ben_pen_shd.g_old_rec.pen_attribute18
659: ,p_pen_attribute19_o =>ben_pen_shd.g_old_rec.pen_attribute19
660: ,p_pen_attribute20_o =>ben_pen_shd.g_old_rec.pen_attribute20
661: ,p_pen_attribute21_o =>ben_pen_shd.g_old_rec.pen_attribute21
662: ,p_pen_attribute22_o =>ben_pen_shd.g_old_rec.pen_attribute22
663: ,p_pen_attribute23_o =>ben_pen_shd.g_old_rec.pen_attribute23
664: ,p_pen_attribute24_o =>ben_pen_shd.g_old_rec.pen_attribute24
665: ,p_pen_attribute25_o =>ben_pen_shd.g_old_rec.pen_attribute25
658: ,p_pen_attribute18_o =>ben_pen_shd.g_old_rec.pen_attribute18
659: ,p_pen_attribute19_o =>ben_pen_shd.g_old_rec.pen_attribute19
660: ,p_pen_attribute20_o =>ben_pen_shd.g_old_rec.pen_attribute20
661: ,p_pen_attribute21_o =>ben_pen_shd.g_old_rec.pen_attribute21
662: ,p_pen_attribute22_o =>ben_pen_shd.g_old_rec.pen_attribute22
663: ,p_pen_attribute23_o =>ben_pen_shd.g_old_rec.pen_attribute23
664: ,p_pen_attribute24_o =>ben_pen_shd.g_old_rec.pen_attribute24
665: ,p_pen_attribute25_o =>ben_pen_shd.g_old_rec.pen_attribute25
666: ,p_pen_attribute26_o =>ben_pen_shd.g_old_rec.pen_attribute26
659: ,p_pen_attribute19_o =>ben_pen_shd.g_old_rec.pen_attribute19
660: ,p_pen_attribute20_o =>ben_pen_shd.g_old_rec.pen_attribute20
661: ,p_pen_attribute21_o =>ben_pen_shd.g_old_rec.pen_attribute21
662: ,p_pen_attribute22_o =>ben_pen_shd.g_old_rec.pen_attribute22
663: ,p_pen_attribute23_o =>ben_pen_shd.g_old_rec.pen_attribute23
664: ,p_pen_attribute24_o =>ben_pen_shd.g_old_rec.pen_attribute24
665: ,p_pen_attribute25_o =>ben_pen_shd.g_old_rec.pen_attribute25
666: ,p_pen_attribute26_o =>ben_pen_shd.g_old_rec.pen_attribute26
667: ,p_pen_attribute27_o =>ben_pen_shd.g_old_rec.pen_attribute27
660: ,p_pen_attribute20_o =>ben_pen_shd.g_old_rec.pen_attribute20
661: ,p_pen_attribute21_o =>ben_pen_shd.g_old_rec.pen_attribute21
662: ,p_pen_attribute22_o =>ben_pen_shd.g_old_rec.pen_attribute22
663: ,p_pen_attribute23_o =>ben_pen_shd.g_old_rec.pen_attribute23
664: ,p_pen_attribute24_o =>ben_pen_shd.g_old_rec.pen_attribute24
665: ,p_pen_attribute25_o =>ben_pen_shd.g_old_rec.pen_attribute25
666: ,p_pen_attribute26_o =>ben_pen_shd.g_old_rec.pen_attribute26
667: ,p_pen_attribute27_o =>ben_pen_shd.g_old_rec.pen_attribute27
668: ,p_pen_attribute28_o =>ben_pen_shd.g_old_rec.pen_attribute28
661: ,p_pen_attribute21_o =>ben_pen_shd.g_old_rec.pen_attribute21
662: ,p_pen_attribute22_o =>ben_pen_shd.g_old_rec.pen_attribute22
663: ,p_pen_attribute23_o =>ben_pen_shd.g_old_rec.pen_attribute23
664: ,p_pen_attribute24_o =>ben_pen_shd.g_old_rec.pen_attribute24
665: ,p_pen_attribute25_o =>ben_pen_shd.g_old_rec.pen_attribute25
666: ,p_pen_attribute26_o =>ben_pen_shd.g_old_rec.pen_attribute26
667: ,p_pen_attribute27_o =>ben_pen_shd.g_old_rec.pen_attribute27
668: ,p_pen_attribute28_o =>ben_pen_shd.g_old_rec.pen_attribute28
669: ,p_pen_attribute29_o =>ben_pen_shd.g_old_rec.pen_attribute29
662: ,p_pen_attribute22_o =>ben_pen_shd.g_old_rec.pen_attribute22
663: ,p_pen_attribute23_o =>ben_pen_shd.g_old_rec.pen_attribute23
664: ,p_pen_attribute24_o =>ben_pen_shd.g_old_rec.pen_attribute24
665: ,p_pen_attribute25_o =>ben_pen_shd.g_old_rec.pen_attribute25
666: ,p_pen_attribute26_o =>ben_pen_shd.g_old_rec.pen_attribute26
667: ,p_pen_attribute27_o =>ben_pen_shd.g_old_rec.pen_attribute27
668: ,p_pen_attribute28_o =>ben_pen_shd.g_old_rec.pen_attribute28
669: ,p_pen_attribute29_o =>ben_pen_shd.g_old_rec.pen_attribute29
670: ,p_pen_attribute30_o =>ben_pen_shd.g_old_rec.pen_attribute30
663: ,p_pen_attribute23_o =>ben_pen_shd.g_old_rec.pen_attribute23
664: ,p_pen_attribute24_o =>ben_pen_shd.g_old_rec.pen_attribute24
665: ,p_pen_attribute25_o =>ben_pen_shd.g_old_rec.pen_attribute25
666: ,p_pen_attribute26_o =>ben_pen_shd.g_old_rec.pen_attribute26
667: ,p_pen_attribute27_o =>ben_pen_shd.g_old_rec.pen_attribute27
668: ,p_pen_attribute28_o =>ben_pen_shd.g_old_rec.pen_attribute28
669: ,p_pen_attribute29_o =>ben_pen_shd.g_old_rec.pen_attribute29
670: ,p_pen_attribute30_o =>ben_pen_shd.g_old_rec.pen_attribute30
671: ,p_request_id_o =>ben_pen_shd.g_old_rec.request_id
664: ,p_pen_attribute24_o =>ben_pen_shd.g_old_rec.pen_attribute24
665: ,p_pen_attribute25_o =>ben_pen_shd.g_old_rec.pen_attribute25
666: ,p_pen_attribute26_o =>ben_pen_shd.g_old_rec.pen_attribute26
667: ,p_pen_attribute27_o =>ben_pen_shd.g_old_rec.pen_attribute27
668: ,p_pen_attribute28_o =>ben_pen_shd.g_old_rec.pen_attribute28
669: ,p_pen_attribute29_o =>ben_pen_shd.g_old_rec.pen_attribute29
670: ,p_pen_attribute30_o =>ben_pen_shd.g_old_rec.pen_attribute30
671: ,p_request_id_o =>ben_pen_shd.g_old_rec.request_id
672: ,p_program_application_id_o =>ben_pen_shd.g_old_rec.program_application_id
665: ,p_pen_attribute25_o =>ben_pen_shd.g_old_rec.pen_attribute25
666: ,p_pen_attribute26_o =>ben_pen_shd.g_old_rec.pen_attribute26
667: ,p_pen_attribute27_o =>ben_pen_shd.g_old_rec.pen_attribute27
668: ,p_pen_attribute28_o =>ben_pen_shd.g_old_rec.pen_attribute28
669: ,p_pen_attribute29_o =>ben_pen_shd.g_old_rec.pen_attribute29
670: ,p_pen_attribute30_o =>ben_pen_shd.g_old_rec.pen_attribute30
671: ,p_request_id_o =>ben_pen_shd.g_old_rec.request_id
672: ,p_program_application_id_o =>ben_pen_shd.g_old_rec.program_application_id
673: ,p_program_id_o =>ben_pen_shd.g_old_rec.program_id
666: ,p_pen_attribute26_o =>ben_pen_shd.g_old_rec.pen_attribute26
667: ,p_pen_attribute27_o =>ben_pen_shd.g_old_rec.pen_attribute27
668: ,p_pen_attribute28_o =>ben_pen_shd.g_old_rec.pen_attribute28
669: ,p_pen_attribute29_o =>ben_pen_shd.g_old_rec.pen_attribute29
670: ,p_pen_attribute30_o =>ben_pen_shd.g_old_rec.pen_attribute30
671: ,p_request_id_o =>ben_pen_shd.g_old_rec.request_id
672: ,p_program_application_id_o =>ben_pen_shd.g_old_rec.program_application_id
673: ,p_program_id_o =>ben_pen_shd.g_old_rec.program_id
674: ,p_program_update_date_o =>ben_pen_shd.g_old_rec.program_update_date
667: ,p_pen_attribute27_o =>ben_pen_shd.g_old_rec.pen_attribute27
668: ,p_pen_attribute28_o =>ben_pen_shd.g_old_rec.pen_attribute28
669: ,p_pen_attribute29_o =>ben_pen_shd.g_old_rec.pen_attribute29
670: ,p_pen_attribute30_o =>ben_pen_shd.g_old_rec.pen_attribute30
671: ,p_request_id_o =>ben_pen_shd.g_old_rec.request_id
672: ,p_program_application_id_o =>ben_pen_shd.g_old_rec.program_application_id
673: ,p_program_id_o =>ben_pen_shd.g_old_rec.program_id
674: ,p_program_update_date_o =>ben_pen_shd.g_old_rec.program_update_date
675: ,p_object_version_number_o =>ben_pen_shd.g_old_rec.object_version_number
668: ,p_pen_attribute28_o =>ben_pen_shd.g_old_rec.pen_attribute28
669: ,p_pen_attribute29_o =>ben_pen_shd.g_old_rec.pen_attribute29
670: ,p_pen_attribute30_o =>ben_pen_shd.g_old_rec.pen_attribute30
671: ,p_request_id_o =>ben_pen_shd.g_old_rec.request_id
672: ,p_program_application_id_o =>ben_pen_shd.g_old_rec.program_application_id
673: ,p_program_id_o =>ben_pen_shd.g_old_rec.program_id
674: ,p_program_update_date_o =>ben_pen_shd.g_old_rec.program_update_date
675: ,p_object_version_number_o =>ben_pen_shd.g_old_rec.object_version_number
676: ,p_per_in_ler_id_o =>ben_pen_shd.g_old_rec.per_in_ler_id
669: ,p_pen_attribute29_o =>ben_pen_shd.g_old_rec.pen_attribute29
670: ,p_pen_attribute30_o =>ben_pen_shd.g_old_rec.pen_attribute30
671: ,p_request_id_o =>ben_pen_shd.g_old_rec.request_id
672: ,p_program_application_id_o =>ben_pen_shd.g_old_rec.program_application_id
673: ,p_program_id_o =>ben_pen_shd.g_old_rec.program_id
674: ,p_program_update_date_o =>ben_pen_shd.g_old_rec.program_update_date
675: ,p_object_version_number_o =>ben_pen_shd.g_old_rec.object_version_number
676: ,p_per_in_ler_id_o =>ben_pen_shd.g_old_rec.per_in_ler_id
677: ,p_bnft_typ_cd_o =>ben_pen_shd.g_old_rec.bnft_typ_cd
670: ,p_pen_attribute30_o =>ben_pen_shd.g_old_rec.pen_attribute30
671: ,p_request_id_o =>ben_pen_shd.g_old_rec.request_id
672: ,p_program_application_id_o =>ben_pen_shd.g_old_rec.program_application_id
673: ,p_program_id_o =>ben_pen_shd.g_old_rec.program_id
674: ,p_program_update_date_o =>ben_pen_shd.g_old_rec.program_update_date
675: ,p_object_version_number_o =>ben_pen_shd.g_old_rec.object_version_number
676: ,p_per_in_ler_id_o =>ben_pen_shd.g_old_rec.per_in_ler_id
677: ,p_bnft_typ_cd_o =>ben_pen_shd.g_old_rec.bnft_typ_cd
678: ,p_bnft_ordr_num_o =>ben_pen_shd.g_old_rec.bnft_ordr_num
671: ,p_request_id_o =>ben_pen_shd.g_old_rec.request_id
672: ,p_program_application_id_o =>ben_pen_shd.g_old_rec.program_application_id
673: ,p_program_id_o =>ben_pen_shd.g_old_rec.program_id
674: ,p_program_update_date_o =>ben_pen_shd.g_old_rec.program_update_date
675: ,p_object_version_number_o =>ben_pen_shd.g_old_rec.object_version_number
676: ,p_per_in_ler_id_o =>ben_pen_shd.g_old_rec.per_in_ler_id
677: ,p_bnft_typ_cd_o =>ben_pen_shd.g_old_rec.bnft_typ_cd
678: ,p_bnft_ordr_num_o =>ben_pen_shd.g_old_rec.bnft_ordr_num
679: ,p_prtt_enrt_rslt_stat_cd_o =>ben_pen_shd.g_old_rec.prtt_enrt_rslt_stat_cd
672: ,p_program_application_id_o =>ben_pen_shd.g_old_rec.program_application_id
673: ,p_program_id_o =>ben_pen_shd.g_old_rec.program_id
674: ,p_program_update_date_o =>ben_pen_shd.g_old_rec.program_update_date
675: ,p_object_version_number_o =>ben_pen_shd.g_old_rec.object_version_number
676: ,p_per_in_ler_id_o =>ben_pen_shd.g_old_rec.per_in_ler_id
677: ,p_bnft_typ_cd_o =>ben_pen_shd.g_old_rec.bnft_typ_cd
678: ,p_bnft_ordr_num_o =>ben_pen_shd.g_old_rec.bnft_ordr_num
679: ,p_prtt_enrt_rslt_stat_cd_o =>ben_pen_shd.g_old_rec.prtt_enrt_rslt_stat_cd
680: ,p_bnft_nnmntry_uom_o =>ben_pen_shd.g_old_rec.bnft_nnmntry_uom
673: ,p_program_id_o =>ben_pen_shd.g_old_rec.program_id
674: ,p_program_update_date_o =>ben_pen_shd.g_old_rec.program_update_date
675: ,p_object_version_number_o =>ben_pen_shd.g_old_rec.object_version_number
676: ,p_per_in_ler_id_o =>ben_pen_shd.g_old_rec.per_in_ler_id
677: ,p_bnft_typ_cd_o =>ben_pen_shd.g_old_rec.bnft_typ_cd
678: ,p_bnft_ordr_num_o =>ben_pen_shd.g_old_rec.bnft_ordr_num
679: ,p_prtt_enrt_rslt_stat_cd_o =>ben_pen_shd.g_old_rec.prtt_enrt_rslt_stat_cd
680: ,p_bnft_nnmntry_uom_o =>ben_pen_shd.g_old_rec.bnft_nnmntry_uom
681: ,p_comp_lvl_cd_o =>ben_pen_shd.g_old_rec.comp_lvl_cd
674: ,p_program_update_date_o =>ben_pen_shd.g_old_rec.program_update_date
675: ,p_object_version_number_o =>ben_pen_shd.g_old_rec.object_version_number
676: ,p_per_in_ler_id_o =>ben_pen_shd.g_old_rec.per_in_ler_id
677: ,p_bnft_typ_cd_o =>ben_pen_shd.g_old_rec.bnft_typ_cd
678: ,p_bnft_ordr_num_o =>ben_pen_shd.g_old_rec.bnft_ordr_num
679: ,p_prtt_enrt_rslt_stat_cd_o =>ben_pen_shd.g_old_rec.prtt_enrt_rslt_stat_cd
680: ,p_bnft_nnmntry_uom_o =>ben_pen_shd.g_old_rec.bnft_nnmntry_uom
681: ,p_comp_lvl_cd_o =>ben_pen_shd.g_old_rec.comp_lvl_cd
682: );
675: ,p_object_version_number_o =>ben_pen_shd.g_old_rec.object_version_number
676: ,p_per_in_ler_id_o =>ben_pen_shd.g_old_rec.per_in_ler_id
677: ,p_bnft_typ_cd_o =>ben_pen_shd.g_old_rec.bnft_typ_cd
678: ,p_bnft_ordr_num_o =>ben_pen_shd.g_old_rec.bnft_ordr_num
679: ,p_prtt_enrt_rslt_stat_cd_o =>ben_pen_shd.g_old_rec.prtt_enrt_rslt_stat_cd
680: ,p_bnft_nnmntry_uom_o =>ben_pen_shd.g_old_rec.bnft_nnmntry_uom
681: ,p_comp_lvl_cd_o =>ben_pen_shd.g_old_rec.comp_lvl_cd
682: );
683:
676: ,p_per_in_ler_id_o =>ben_pen_shd.g_old_rec.per_in_ler_id
677: ,p_bnft_typ_cd_o =>ben_pen_shd.g_old_rec.bnft_typ_cd
678: ,p_bnft_ordr_num_o =>ben_pen_shd.g_old_rec.bnft_ordr_num
679: ,p_prtt_enrt_rslt_stat_cd_o =>ben_pen_shd.g_old_rec.prtt_enrt_rslt_stat_cd
680: ,p_bnft_nnmntry_uom_o =>ben_pen_shd.g_old_rec.bnft_nnmntry_uom
681: ,p_comp_lvl_cd_o =>ben_pen_shd.g_old_rec.comp_lvl_cd
682: );
683:
684: exception
677: ,p_bnft_typ_cd_o =>ben_pen_shd.g_old_rec.bnft_typ_cd
678: ,p_bnft_ordr_num_o =>ben_pen_shd.g_old_rec.bnft_ordr_num
679: ,p_prtt_enrt_rslt_stat_cd_o =>ben_pen_shd.g_old_rec.prtt_enrt_rslt_stat_cd
680: ,p_bnft_nnmntry_uom_o =>ben_pen_shd.g_old_rec.bnft_nnmntry_uom
681: ,p_comp_lvl_cd_o =>ben_pen_shd.g_old_rec.comp_lvl_cd
682: );
683:
684: exception
685: when hr_api.cannot_find_prog_unit then
736: -- Internal Row Handler Use Only.
737: --
738: -- {End Of Comments}
739: -- ----------------------------------------------------------------------------
740: Procedure convert_defs(p_rec in out nocopy ben_pen_shd.g_rec_type) is
741: --
742: l_proc varchar2(72) := g_package||'convert_defs';
743: --
744: Begin
751: -- is being used then we must set to the 'current' argument value.
752: --
753: If (p_rec.business_group_id = hr_api.g_number) then
754: p_rec.business_group_id :=
755: ben_pen_shd.g_old_rec.business_group_id;
756: End If;
757: If (p_rec.oipl_id = hr_api.g_number) then
758: p_rec.oipl_id :=
759: ben_pen_shd.g_old_rec.oipl_id;
755: ben_pen_shd.g_old_rec.business_group_id;
756: End If;
757: If (p_rec.oipl_id = hr_api.g_number) then
758: p_rec.oipl_id :=
759: ben_pen_shd.g_old_rec.oipl_id;
760: End If;
761: If (p_rec.person_id = hr_api.g_number) then
762: p_rec.person_id :=
763: ben_pen_shd.g_old_rec.person_id;
759: ben_pen_shd.g_old_rec.oipl_id;
760: End If;
761: If (p_rec.person_id = hr_api.g_number) then
762: p_rec.person_id :=
763: ben_pen_shd.g_old_rec.person_id;
764: End If;
765: If (p_rec.assignment_id = hr_api.g_number) then
766: p_rec.assignment_id :=
767: ben_pen_shd.g_old_rec.assignment_id;
763: ben_pen_shd.g_old_rec.person_id;
764: End If;
765: If (p_rec.assignment_id = hr_api.g_number) then
766: p_rec.assignment_id :=
767: ben_pen_shd.g_old_rec.assignment_id;
768: End If;
769: If (p_rec.pgm_id = hr_api.g_number) then
770: p_rec.pgm_id :=
771: ben_pen_shd.g_old_rec.pgm_id;
767: ben_pen_shd.g_old_rec.assignment_id;
768: End If;
769: If (p_rec.pgm_id = hr_api.g_number) then
770: p_rec.pgm_id :=
771: ben_pen_shd.g_old_rec.pgm_id;
772: End If;
773: If (p_rec.pl_id = hr_api.g_number) then
774: p_rec.pl_id :=
775: ben_pen_shd.g_old_rec.pl_id;
771: ben_pen_shd.g_old_rec.pgm_id;
772: End If;
773: If (p_rec.pl_id = hr_api.g_number) then
774: p_rec.pl_id :=
775: ben_pen_shd.g_old_rec.pl_id;
776: End If;
777: If (p_rec.rplcs_sspndd_rslt_id = hr_api.g_number) then
778: p_rec.rplcs_sspndd_rslt_id :=
779: ben_pen_shd.g_old_rec.rplcs_sspndd_rslt_id;
775: ben_pen_shd.g_old_rec.pl_id;
776: End If;
777: If (p_rec.rplcs_sspndd_rslt_id = hr_api.g_number) then
778: p_rec.rplcs_sspndd_rslt_id :=
779: ben_pen_shd.g_old_rec.rplcs_sspndd_rslt_id;
780: End If;
781: If (p_rec.ptip_id = hr_api.g_number) then
782: p_rec.ptip_id :=
783: ben_pen_shd.g_old_rec.ptip_id;
779: ben_pen_shd.g_old_rec.rplcs_sspndd_rslt_id;
780: End If;
781: If (p_rec.ptip_id = hr_api.g_number) then
782: p_rec.ptip_id :=
783: ben_pen_shd.g_old_rec.ptip_id;
784: End If;
785: If (p_rec.pl_typ_id = hr_api.g_number) then
786: p_rec.pl_typ_id :=
787: ben_pen_shd.g_old_rec.pl_typ_id;
783: ben_pen_shd.g_old_rec.ptip_id;
784: End If;
785: If (p_rec.pl_typ_id = hr_api.g_number) then
786: p_rec.pl_typ_id :=
787: ben_pen_shd.g_old_rec.pl_typ_id;
788: End If;
789: If (p_rec.ler_id = hr_api.g_number) then
790: p_rec.ler_id :=
791: ben_pen_shd.g_old_rec.ler_id;
787: ben_pen_shd.g_old_rec.pl_typ_id;
788: End If;
789: If (p_rec.ler_id = hr_api.g_number) then
790: p_rec.ler_id :=
791: ben_pen_shd.g_old_rec.ler_id;
792: End If;
793: If (p_rec.sspndd_flag = hr_api.g_varchar2) then
794: p_rec.sspndd_flag :=
795: ben_pen_shd.g_old_rec.sspndd_flag;
791: ben_pen_shd.g_old_rec.ler_id;
792: End If;
793: If (p_rec.sspndd_flag = hr_api.g_varchar2) then
794: p_rec.sspndd_flag :=
795: ben_pen_shd.g_old_rec.sspndd_flag;
796: End If;
797: If (p_rec.prtt_is_cvrd_flag = hr_api.g_varchar2) then
798: p_rec.prtt_is_cvrd_flag :=
799: ben_pen_shd.g_old_rec.prtt_is_cvrd_flag;
795: ben_pen_shd.g_old_rec.sspndd_flag;
796: End If;
797: If (p_rec.prtt_is_cvrd_flag = hr_api.g_varchar2) then
798: p_rec.prtt_is_cvrd_flag :=
799: ben_pen_shd.g_old_rec.prtt_is_cvrd_flag;
800: End If;
801: If (p_rec.bnft_amt = hr_api.g_number) then
802: p_rec.bnft_amt :=
803: ben_pen_shd.g_old_rec.bnft_amt;
799: ben_pen_shd.g_old_rec.prtt_is_cvrd_flag;
800: End If;
801: If (p_rec.bnft_amt = hr_api.g_number) then
802: p_rec.bnft_amt :=
803: ben_pen_shd.g_old_rec.bnft_amt;
804: End If;
805: If (p_rec.uom = hr_api.g_varchar2) then
806: p_rec.uom :=
807: ben_pen_shd.g_old_rec.uom ;
803: ben_pen_shd.g_old_rec.bnft_amt;
804: End If;
805: If (p_rec.uom = hr_api.g_varchar2) then
806: p_rec.uom :=
807: ben_pen_shd.g_old_rec.uom ;
808: End If;
809: If (p_rec.orgnl_enrt_dt = hr_api.g_date) then
810: p_rec.orgnl_enrt_dt :=
811: ben_pen_shd.g_old_rec.orgnl_enrt_dt;
807: ben_pen_shd.g_old_rec.uom ;
808: End If;
809: If (p_rec.orgnl_enrt_dt = hr_api.g_date) then
810: p_rec.orgnl_enrt_dt :=
811: ben_pen_shd.g_old_rec.orgnl_enrt_dt;
812: End If;
813: If (p_rec.enrt_mthd_cd = hr_api.g_varchar2) then
814: p_rec.enrt_mthd_cd :=
815: ben_pen_shd.g_old_rec.enrt_mthd_cd;
811: ben_pen_shd.g_old_rec.orgnl_enrt_dt;
812: End If;
813: If (p_rec.enrt_mthd_cd = hr_api.g_varchar2) then
814: p_rec.enrt_mthd_cd :=
815: ben_pen_shd.g_old_rec.enrt_mthd_cd;
816: End If;
817: If (p_rec.no_lngr_elig_flag = hr_api.g_varchar2) then
818: p_rec.no_lngr_elig_flag :=
819: ben_pen_shd.g_old_rec.no_lngr_elig_flag;
815: ben_pen_shd.g_old_rec.enrt_mthd_cd;
816: End If;
817: If (p_rec.no_lngr_elig_flag = hr_api.g_varchar2) then
818: p_rec.no_lngr_elig_flag :=
819: ben_pen_shd.g_old_rec.no_lngr_elig_flag;
820: End If;
821: If (p_rec.enrt_ovridn_flag = hr_api.g_varchar2) then
822: p_rec.enrt_ovridn_flag :=
823: ben_pen_shd.g_old_rec.enrt_ovridn_flag;
819: ben_pen_shd.g_old_rec.no_lngr_elig_flag;
820: End If;
821: If (p_rec.enrt_ovridn_flag = hr_api.g_varchar2) then
822: p_rec.enrt_ovridn_flag :=
823: ben_pen_shd.g_old_rec.enrt_ovridn_flag;
824: End If;
825: If (p_rec.enrt_ovrid_rsn_cd = hr_api.g_varchar2) then
826: p_rec.enrt_ovrid_rsn_cd :=
827: ben_pen_shd.g_old_rec.enrt_ovrid_rsn_cd;
823: ben_pen_shd.g_old_rec.enrt_ovridn_flag;
824: End If;
825: If (p_rec.enrt_ovrid_rsn_cd = hr_api.g_varchar2) then
826: p_rec.enrt_ovrid_rsn_cd :=
827: ben_pen_shd.g_old_rec.enrt_ovrid_rsn_cd;
828: End If;
829: If (p_rec.erlst_deenrt_dt = hr_api.g_date) then
830: p_rec.erlst_deenrt_dt :=
831: ben_pen_shd.g_old_rec.erlst_deenrt_dt;
827: ben_pen_shd.g_old_rec.enrt_ovrid_rsn_cd;
828: End If;
829: If (p_rec.erlst_deenrt_dt = hr_api.g_date) then
830: p_rec.erlst_deenrt_dt :=
831: ben_pen_shd.g_old_rec.erlst_deenrt_dt;
832: End If;
833: If (p_rec.enrt_cvg_strt_dt = hr_api.g_date) then
834: p_rec.enrt_cvg_strt_dt :=
835: ben_pen_shd.g_old_rec.enrt_cvg_strt_dt;
831: ben_pen_shd.g_old_rec.erlst_deenrt_dt;
832: End If;
833: If (p_rec.enrt_cvg_strt_dt = hr_api.g_date) then
834: p_rec.enrt_cvg_strt_dt :=
835: ben_pen_shd.g_old_rec.enrt_cvg_strt_dt;
836: End If;
837: If (p_rec.enrt_cvg_thru_dt = hr_api.g_date) then
838: p_rec.enrt_cvg_thru_dt :=
839: ben_pen_shd.g_old_rec.enrt_cvg_thru_dt;
835: ben_pen_shd.g_old_rec.enrt_cvg_strt_dt;
836: End If;
837: If (p_rec.enrt_cvg_thru_dt = hr_api.g_date) then
838: p_rec.enrt_cvg_thru_dt :=
839: ben_pen_shd.g_old_rec.enrt_cvg_thru_dt;
840: End If;
841: If (p_rec.enrt_ovrid_thru_dt = hr_api.g_date) then
842: p_rec.enrt_ovrid_thru_dt :=
843: ben_pen_shd.g_old_rec.enrt_ovrid_thru_dt;
839: ben_pen_shd.g_old_rec.enrt_cvg_thru_dt;
840: End If;
841: If (p_rec.enrt_ovrid_thru_dt = hr_api.g_date) then
842: p_rec.enrt_ovrid_thru_dt :=
843: ben_pen_shd.g_old_rec.enrt_ovrid_thru_dt;
844: End If;
845: If (p_rec.pl_ordr_num = hr_api.g_number) then
846: p_rec.pl_ordr_num :=
847: ben_pen_shd.g_old_rec.pl_ordr_num;
843: ben_pen_shd.g_old_rec.enrt_ovrid_thru_dt;
844: End If;
845: If (p_rec.pl_ordr_num = hr_api.g_number) then
846: p_rec.pl_ordr_num :=
847: ben_pen_shd.g_old_rec.pl_ordr_num;
848: End If;
849: If (p_rec.plip_ordr_num = hr_api.g_number) then
850: p_rec.plip_ordr_num :=
851: ben_pen_shd.g_old_rec.plip_ordr_num;
847: ben_pen_shd.g_old_rec.pl_ordr_num;
848: End If;
849: If (p_rec.plip_ordr_num = hr_api.g_number) then
850: p_rec.plip_ordr_num :=
851: ben_pen_shd.g_old_rec.plip_ordr_num;
852: End If;
853: If (p_rec.ptip_ordr_num = hr_api.g_number) then
854: p_rec.ptip_ordr_num :=
855: ben_pen_shd.g_old_rec.ptip_ordr_num;
851: ben_pen_shd.g_old_rec.plip_ordr_num;
852: End If;
853: If (p_rec.ptip_ordr_num = hr_api.g_number) then
854: p_rec.ptip_ordr_num :=
855: ben_pen_shd.g_old_rec.ptip_ordr_num;
856: End If;
857: If (p_rec.oipl_ordr_num = hr_api.g_number) then
858: p_rec.oipl_ordr_num :=
859: ben_pen_shd.g_old_rec.oipl_ordr_num;
855: ben_pen_shd.g_old_rec.ptip_ordr_num;
856: End If;
857: If (p_rec.oipl_ordr_num = hr_api.g_number) then
858: p_rec.oipl_ordr_num :=
859: ben_pen_shd.g_old_rec.oipl_ordr_num;
860: End If;
861: If (p_rec.pen_attribute_category = hr_api.g_varchar2) then
862: p_rec.pen_attribute_category :=
863: ben_pen_shd.g_old_rec.pen_attribute_category;
859: ben_pen_shd.g_old_rec.oipl_ordr_num;
860: End If;
861: If (p_rec.pen_attribute_category = hr_api.g_varchar2) then
862: p_rec.pen_attribute_category :=
863: ben_pen_shd.g_old_rec.pen_attribute_category;
864: End If;
865: If (p_rec.pen_attribute1 = hr_api.g_varchar2) then
866: p_rec.pen_attribute1 :=
867: ben_pen_shd.g_old_rec.pen_attribute1;
863: ben_pen_shd.g_old_rec.pen_attribute_category;
864: End If;
865: If (p_rec.pen_attribute1 = hr_api.g_varchar2) then
866: p_rec.pen_attribute1 :=
867: ben_pen_shd.g_old_rec.pen_attribute1;
868: End If;
869: If (p_rec.pen_attribute2 = hr_api.g_varchar2) then
870: p_rec.pen_attribute2 :=
871: ben_pen_shd.g_old_rec.pen_attribute2;
867: ben_pen_shd.g_old_rec.pen_attribute1;
868: End If;
869: If (p_rec.pen_attribute2 = hr_api.g_varchar2) then
870: p_rec.pen_attribute2 :=
871: ben_pen_shd.g_old_rec.pen_attribute2;
872: End If;
873: If (p_rec.pen_attribute3 = hr_api.g_varchar2) then
874: p_rec.pen_attribute3 :=
875: ben_pen_shd.g_old_rec.pen_attribute3;
871: ben_pen_shd.g_old_rec.pen_attribute2;
872: End If;
873: If (p_rec.pen_attribute3 = hr_api.g_varchar2) then
874: p_rec.pen_attribute3 :=
875: ben_pen_shd.g_old_rec.pen_attribute3;
876: End If;
877: If (p_rec.pen_attribute4 = hr_api.g_varchar2) then
878: p_rec.pen_attribute4 :=
879: ben_pen_shd.g_old_rec.pen_attribute4;
875: ben_pen_shd.g_old_rec.pen_attribute3;
876: End If;
877: If (p_rec.pen_attribute4 = hr_api.g_varchar2) then
878: p_rec.pen_attribute4 :=
879: ben_pen_shd.g_old_rec.pen_attribute4;
880: End If;
881: If (p_rec.pen_attribute5 = hr_api.g_varchar2) then
882: p_rec.pen_attribute5 :=
883: ben_pen_shd.g_old_rec.pen_attribute5;
879: ben_pen_shd.g_old_rec.pen_attribute4;
880: End If;
881: If (p_rec.pen_attribute5 = hr_api.g_varchar2) then
882: p_rec.pen_attribute5 :=
883: ben_pen_shd.g_old_rec.pen_attribute5;
884: End If;
885: If (p_rec.pen_attribute6 = hr_api.g_varchar2) then
886: p_rec.pen_attribute6 :=
887: ben_pen_shd.g_old_rec.pen_attribute6;
883: ben_pen_shd.g_old_rec.pen_attribute5;
884: End If;
885: If (p_rec.pen_attribute6 = hr_api.g_varchar2) then
886: p_rec.pen_attribute6 :=
887: ben_pen_shd.g_old_rec.pen_attribute6;
888: End If;
889: If (p_rec.pen_attribute7 = hr_api.g_varchar2) then
890: p_rec.pen_attribute7 :=
891: ben_pen_shd.g_old_rec.pen_attribute7;
887: ben_pen_shd.g_old_rec.pen_attribute6;
888: End If;
889: If (p_rec.pen_attribute7 = hr_api.g_varchar2) then
890: p_rec.pen_attribute7 :=
891: ben_pen_shd.g_old_rec.pen_attribute7;
892: End If;
893: If (p_rec.pen_attribute8 = hr_api.g_varchar2) then
894: p_rec.pen_attribute8 :=
895: ben_pen_shd.g_old_rec.pen_attribute8;
891: ben_pen_shd.g_old_rec.pen_attribute7;
892: End If;
893: If (p_rec.pen_attribute8 = hr_api.g_varchar2) then
894: p_rec.pen_attribute8 :=
895: ben_pen_shd.g_old_rec.pen_attribute8;
896: End If;
897: If (p_rec.pen_attribute9 = hr_api.g_varchar2) then
898: p_rec.pen_attribute9 :=
899: ben_pen_shd.g_old_rec.pen_attribute9;
895: ben_pen_shd.g_old_rec.pen_attribute8;
896: End If;
897: If (p_rec.pen_attribute9 = hr_api.g_varchar2) then
898: p_rec.pen_attribute9 :=
899: ben_pen_shd.g_old_rec.pen_attribute9;
900: End If;
901: If (p_rec.pen_attribute10 = hr_api.g_varchar2) then
902: p_rec.pen_attribute10 :=
903: ben_pen_shd.g_old_rec.pen_attribute10;
899: ben_pen_shd.g_old_rec.pen_attribute9;
900: End If;
901: If (p_rec.pen_attribute10 = hr_api.g_varchar2) then
902: p_rec.pen_attribute10 :=
903: ben_pen_shd.g_old_rec.pen_attribute10;
904: End If;
905: If (p_rec.pen_attribute11 = hr_api.g_varchar2) then
906: p_rec.pen_attribute11 :=
907: ben_pen_shd.g_old_rec.pen_attribute11;
903: ben_pen_shd.g_old_rec.pen_attribute10;
904: End If;
905: If (p_rec.pen_attribute11 = hr_api.g_varchar2) then
906: p_rec.pen_attribute11 :=
907: ben_pen_shd.g_old_rec.pen_attribute11;
908: End If;
909: If (p_rec.pen_attribute12 = hr_api.g_varchar2) then
910: p_rec.pen_attribute12 :=
911: ben_pen_shd.g_old_rec.pen_attribute12;
907: ben_pen_shd.g_old_rec.pen_attribute11;
908: End If;
909: If (p_rec.pen_attribute12 = hr_api.g_varchar2) then
910: p_rec.pen_attribute12 :=
911: ben_pen_shd.g_old_rec.pen_attribute12;
912: End If;
913: If (p_rec.pen_attribute13 = hr_api.g_varchar2) then
914: p_rec.pen_attribute13 :=
915: ben_pen_shd.g_old_rec.pen_attribute13;
911: ben_pen_shd.g_old_rec.pen_attribute12;
912: End If;
913: If (p_rec.pen_attribute13 = hr_api.g_varchar2) then
914: p_rec.pen_attribute13 :=
915: ben_pen_shd.g_old_rec.pen_attribute13;
916: End If;
917: If (p_rec.pen_attribute14 = hr_api.g_varchar2) then
918: p_rec.pen_attribute14 :=
919: ben_pen_shd.g_old_rec.pen_attribute14;
915: ben_pen_shd.g_old_rec.pen_attribute13;
916: End If;
917: If (p_rec.pen_attribute14 = hr_api.g_varchar2) then
918: p_rec.pen_attribute14 :=
919: ben_pen_shd.g_old_rec.pen_attribute14;
920: End If;
921: If (p_rec.pen_attribute15 = hr_api.g_varchar2) then
922: p_rec.pen_attribute15 :=
923: ben_pen_shd.g_old_rec.pen_attribute15;
919: ben_pen_shd.g_old_rec.pen_attribute14;
920: End If;
921: If (p_rec.pen_attribute15 = hr_api.g_varchar2) then
922: p_rec.pen_attribute15 :=
923: ben_pen_shd.g_old_rec.pen_attribute15;
924: End If;
925: If (p_rec.pen_attribute16 = hr_api.g_varchar2) then
926: p_rec.pen_attribute16 :=
927: ben_pen_shd.g_old_rec.pen_attribute16;
923: ben_pen_shd.g_old_rec.pen_attribute15;
924: End If;
925: If (p_rec.pen_attribute16 = hr_api.g_varchar2) then
926: p_rec.pen_attribute16 :=
927: ben_pen_shd.g_old_rec.pen_attribute16;
928: End If;
929: If (p_rec.pen_attribute17 = hr_api.g_varchar2) then
930: p_rec.pen_attribute17 :=
931: ben_pen_shd.g_old_rec.pen_attribute17;
927: ben_pen_shd.g_old_rec.pen_attribute16;
928: End If;
929: If (p_rec.pen_attribute17 = hr_api.g_varchar2) then
930: p_rec.pen_attribute17 :=
931: ben_pen_shd.g_old_rec.pen_attribute17;
932: End If;
933: If (p_rec.pen_attribute18 = hr_api.g_varchar2) then
934: p_rec.pen_attribute18 :=
935: ben_pen_shd.g_old_rec.pen_attribute18;
931: ben_pen_shd.g_old_rec.pen_attribute17;
932: End If;
933: If (p_rec.pen_attribute18 = hr_api.g_varchar2) then
934: p_rec.pen_attribute18 :=
935: ben_pen_shd.g_old_rec.pen_attribute18;
936: End If;
937: If (p_rec.pen_attribute19 = hr_api.g_varchar2) then
938: p_rec.pen_attribute19 :=
939: ben_pen_shd.g_old_rec.pen_attribute19;
935: ben_pen_shd.g_old_rec.pen_attribute18;
936: End If;
937: If (p_rec.pen_attribute19 = hr_api.g_varchar2) then
938: p_rec.pen_attribute19 :=
939: ben_pen_shd.g_old_rec.pen_attribute19;
940: End If;
941: If (p_rec.pen_attribute20 = hr_api.g_varchar2) then
942: p_rec.pen_attribute20 :=
943: ben_pen_shd.g_old_rec.pen_attribute20;
939: ben_pen_shd.g_old_rec.pen_attribute19;
940: End If;
941: If (p_rec.pen_attribute20 = hr_api.g_varchar2) then
942: p_rec.pen_attribute20 :=
943: ben_pen_shd.g_old_rec.pen_attribute20;
944: End If;
945: If (p_rec.pen_attribute21 = hr_api.g_varchar2) then
946: p_rec.pen_attribute21 :=
947: ben_pen_shd.g_old_rec.pen_attribute21;
943: ben_pen_shd.g_old_rec.pen_attribute20;
944: End If;
945: If (p_rec.pen_attribute21 = hr_api.g_varchar2) then
946: p_rec.pen_attribute21 :=
947: ben_pen_shd.g_old_rec.pen_attribute21;
948: End If;
949: If (p_rec.pen_attribute22 = hr_api.g_varchar2) then
950: p_rec.pen_attribute22 :=
951: ben_pen_shd.g_old_rec.pen_attribute22;
947: ben_pen_shd.g_old_rec.pen_attribute21;
948: End If;
949: If (p_rec.pen_attribute22 = hr_api.g_varchar2) then
950: p_rec.pen_attribute22 :=
951: ben_pen_shd.g_old_rec.pen_attribute22;
952: End If;
953: If (p_rec.pen_attribute23 = hr_api.g_varchar2) then
954: p_rec.pen_attribute23 :=
955: ben_pen_shd.g_old_rec.pen_attribute23;
951: ben_pen_shd.g_old_rec.pen_attribute22;
952: End If;
953: If (p_rec.pen_attribute23 = hr_api.g_varchar2) then
954: p_rec.pen_attribute23 :=
955: ben_pen_shd.g_old_rec.pen_attribute23;
956: End If;
957: If (p_rec.pen_attribute24 = hr_api.g_varchar2) then
958: p_rec.pen_attribute24 :=
959: ben_pen_shd.g_old_rec.pen_attribute24;
955: ben_pen_shd.g_old_rec.pen_attribute23;
956: End If;
957: If (p_rec.pen_attribute24 = hr_api.g_varchar2) then
958: p_rec.pen_attribute24 :=
959: ben_pen_shd.g_old_rec.pen_attribute24;
960: End If;
961: If (p_rec.pen_attribute25 = hr_api.g_varchar2) then
962: p_rec.pen_attribute25 :=
963: ben_pen_shd.g_old_rec.pen_attribute25;
959: ben_pen_shd.g_old_rec.pen_attribute24;
960: End If;
961: If (p_rec.pen_attribute25 = hr_api.g_varchar2) then
962: p_rec.pen_attribute25 :=
963: ben_pen_shd.g_old_rec.pen_attribute25;
964: End If;
965: If (p_rec.pen_attribute26 = hr_api.g_varchar2) then
966: p_rec.pen_attribute26 :=
967: ben_pen_shd.g_old_rec.pen_attribute26;
963: ben_pen_shd.g_old_rec.pen_attribute25;
964: End If;
965: If (p_rec.pen_attribute26 = hr_api.g_varchar2) then
966: p_rec.pen_attribute26 :=
967: ben_pen_shd.g_old_rec.pen_attribute26;
968: End If;
969: If (p_rec.pen_attribute27 = hr_api.g_varchar2) then
970: p_rec.pen_attribute27 :=
971: ben_pen_shd.g_old_rec.pen_attribute27;
967: ben_pen_shd.g_old_rec.pen_attribute26;
968: End If;
969: If (p_rec.pen_attribute27 = hr_api.g_varchar2) then
970: p_rec.pen_attribute27 :=
971: ben_pen_shd.g_old_rec.pen_attribute27;
972: End If;
973: If (p_rec.pen_attribute28 = hr_api.g_varchar2) then
974: p_rec.pen_attribute28 :=
975: ben_pen_shd.g_old_rec.pen_attribute28;
971: ben_pen_shd.g_old_rec.pen_attribute27;
972: End If;
973: If (p_rec.pen_attribute28 = hr_api.g_varchar2) then
974: p_rec.pen_attribute28 :=
975: ben_pen_shd.g_old_rec.pen_attribute28;
976: End If;
977: If (p_rec.pen_attribute29 = hr_api.g_varchar2) then
978: p_rec.pen_attribute29 :=
979: ben_pen_shd.g_old_rec.pen_attribute29;
975: ben_pen_shd.g_old_rec.pen_attribute28;
976: End If;
977: If (p_rec.pen_attribute29 = hr_api.g_varchar2) then
978: p_rec.pen_attribute29 :=
979: ben_pen_shd.g_old_rec.pen_attribute29;
980: End If;
981: If (p_rec.pen_attribute30 = hr_api.g_varchar2) then
982: p_rec.pen_attribute30 :=
983: ben_pen_shd.g_old_rec.pen_attribute30;
979: ben_pen_shd.g_old_rec.pen_attribute29;
980: End If;
981: If (p_rec.pen_attribute30 = hr_api.g_varchar2) then
982: p_rec.pen_attribute30 :=
983: ben_pen_shd.g_old_rec.pen_attribute30;
984: End If;
985: If (p_rec.request_id = hr_api.g_number) then
986: p_rec.request_id :=
987: ben_pen_shd.g_old_rec.request_id;
983: ben_pen_shd.g_old_rec.pen_attribute30;
984: End If;
985: If (p_rec.request_id = hr_api.g_number) then
986: p_rec.request_id :=
987: ben_pen_shd.g_old_rec.request_id;
988: End If;
989: If (p_rec.program_application_id = hr_api.g_number) then
990: p_rec.program_application_id :=
991: ben_pen_shd.g_old_rec.program_application_id;
987: ben_pen_shd.g_old_rec.request_id;
988: End If;
989: If (p_rec.program_application_id = hr_api.g_number) then
990: p_rec.program_application_id :=
991: ben_pen_shd.g_old_rec.program_application_id;
992: End If;
993: If (p_rec.program_id = hr_api.g_number) then
994: p_rec.program_id :=
995: ben_pen_shd.g_old_rec.program_id;
991: ben_pen_shd.g_old_rec.program_application_id;
992: End If;
993: If (p_rec.program_id = hr_api.g_number) then
994: p_rec.program_id :=
995: ben_pen_shd.g_old_rec.program_id;
996: End If;
997: If (p_rec.program_update_date = hr_api.g_date) then
998: p_rec.program_update_date :=
999: ben_pen_shd.g_old_rec.program_update_date;
995: ben_pen_shd.g_old_rec.program_id;
996: End If;
997: If (p_rec.program_update_date = hr_api.g_date) then
998: p_rec.program_update_date :=
999: ben_pen_shd.g_old_rec.program_update_date;
1000: End If;
1001: If (p_rec.per_in_ler_id = hr_api.g_number) then
1002: p_rec.per_in_ler_id :=
1003: ben_pen_shd.g_old_rec.per_in_ler_id;
999: ben_pen_shd.g_old_rec.program_update_date;
1000: End If;
1001: If (p_rec.per_in_ler_id = hr_api.g_number) then
1002: p_rec.per_in_ler_id :=
1003: ben_pen_shd.g_old_rec.per_in_ler_id;
1004: End If;
1005: If (p_rec.bnft_typ_cd = hr_api.g_varchar2) then
1006: p_rec.bnft_typ_cd :=
1007: ben_pen_shd.g_old_rec.bnft_typ_cd;
1003: ben_pen_shd.g_old_rec.per_in_ler_id;
1004: End If;
1005: If (p_rec.bnft_typ_cd = hr_api.g_varchar2) then
1006: p_rec.bnft_typ_cd :=
1007: ben_pen_shd.g_old_rec.bnft_typ_cd;
1008: End If;
1009: If (p_rec.bnft_ordr_num = hr_api.g_number) then
1010: p_rec.bnft_ordr_num :=
1011: ben_pen_shd.g_old_rec.bnft_ordr_num;
1007: ben_pen_shd.g_old_rec.bnft_typ_cd;
1008: End If;
1009: If (p_rec.bnft_ordr_num = hr_api.g_number) then
1010: p_rec.bnft_ordr_num :=
1011: ben_pen_shd.g_old_rec.bnft_ordr_num;
1012: End If;
1013: If (p_rec.prtt_enrt_rslt_stat_cd = hr_api.g_varchar2) then
1014: p_rec.prtt_enrt_rslt_stat_cd :=
1015: ben_pen_shd.g_old_rec.prtt_enrt_rslt_stat_cd;
1011: ben_pen_shd.g_old_rec.bnft_ordr_num;
1012: End If;
1013: If (p_rec.prtt_enrt_rslt_stat_cd = hr_api.g_varchar2) then
1014: p_rec.prtt_enrt_rslt_stat_cd :=
1015: ben_pen_shd.g_old_rec.prtt_enrt_rslt_stat_cd;
1016: End If;
1017: If (p_rec.bnft_nnmntry_uom = hr_api.g_varchar2) then
1018: p_rec.bnft_nnmntry_uom :=
1019: ben_pen_shd.g_old_rec.bnft_nnmntry_uom;
1015: ben_pen_shd.g_old_rec.prtt_enrt_rslt_stat_cd;
1016: End If;
1017: If (p_rec.bnft_nnmntry_uom = hr_api.g_varchar2) then
1018: p_rec.bnft_nnmntry_uom :=
1019: ben_pen_shd.g_old_rec.bnft_nnmntry_uom;
1020: End If;
1021: If (p_rec.comp_lvl_cd = hr_api.g_varchar2) then
1022: p_rec.comp_lvl_cd :=
1023: ben_pen_shd.g_old_rec.comp_lvl_cd;
1019: ben_pen_shd.g_old_rec.bnft_nnmntry_uom;
1020: End If;
1021: If (p_rec.comp_lvl_cd = hr_api.g_varchar2) then
1022: p_rec.comp_lvl_cd :=
1023: ben_pen_shd.g_old_rec.comp_lvl_cd;
1024: End If;
1025:
1026: --
1027: hr_utility.set_location(' Leaving:'||l_proc, 10);
1032: -- |---------------------------------< upd >----------------------------------|
1033: -- ----------------------------------------------------------------------------
1034: Procedure upd
1035: (
1036: p_rec in out nocopy ben_pen_shd.g_rec_type,
1037: p_effective_date in date,
1038: p_datetrack_mode in varchar2
1039: ) is
1040: --
1050: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
1051: --
1052: -- We must lock the row which we need to update.
1053: --
1054: ben_pen_shd.lck
1055: (p_effective_date => p_effective_date,
1056: p_datetrack_mode => p_datetrack_mode,
1057: p_prtt_enrt_rslt_id => p_rec.prtt_enrt_rslt_id,
1058: p_object_version_number => p_rec.object_version_number,
1205: p_effective_date in date,
1206: p_datetrack_mode in varchar2
1207: ) is
1208: --
1209: l_rec ben_pen_shd.g_rec_type;
1210: l_proc varchar2(72) := g_package||'upd';
1211: --
1212: Begin
1213: hr_utility.set_location('Entering:'||l_proc, 5);
1215: -- Call conversion function to turn arguments into the
1216: -- l_rec structure.
1217: --
1218: l_rec :=
1219: ben_pen_shd.convert_args
1220: (
1221: p_prtt_enrt_rslt_id,
1222: null,
1223: null,