54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: Procedure dt_update_dml
58: (p_rec in out nocopy ben_bpl_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_bnft_prvdd_ldgr_f',
78: p_base_key_column => 'bnft_prvdd_ldgr_id',
79: p_base_key_value => p_rec.bnft_prvdd_ldgr_id);
80: --
81: ben_bpl_shd.g_api_dml := true; -- Set the api dml status
82: --
83: -- Update the ben_bnft_prvdd_ldgr_f Row
84: --
85: update ben_bnft_prvdd_ldgr_f
143: where bnft_prvdd_ldgr_id = p_rec.bnft_prvdd_ldgr_id
144: and effective_start_date = p_validation_start_date
145: and effective_end_date = p_validation_end_date;
146: --
147: ben_bpl_shd.g_api_dml := false; -- Unset the api dml status
148: --
149: -- Set the effective start and end dates
150: --
151: p_rec.effective_start_date := p_validation_start_date;
155: hr_utility.set_location(' Leaving:'||l_proc, 15);
156: Exception
157: When hr_api.check_integrity_violated Then
158: -- A check constraint has been violated
159: ben_bpl_shd.g_api_dml := false; -- Unset the api dml status
160: ben_bpl_shd.constraint_error
161: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
162: When hr_api.unique_integrity_violated Then
163: -- Unique integrity has been violated
156: Exception
157: When hr_api.check_integrity_violated Then
158: -- A check constraint has been violated
159: ben_bpl_shd.g_api_dml := false; -- Unset the api dml status
160: ben_bpl_shd.constraint_error
161: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
162: When hr_api.unique_integrity_violated Then
163: -- Unique integrity has been violated
164: ben_bpl_shd.g_api_dml := false; -- Unset the api dml status
160: ben_bpl_shd.constraint_error
161: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
162: When hr_api.unique_integrity_violated Then
163: -- Unique integrity has been violated
164: ben_bpl_shd.g_api_dml := false; -- Unset the api dml status
165: ben_bpl_shd.constraint_error
166: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
167: When Others Then
168: ben_bpl_shd.g_api_dml := false; -- Unset the api dml status
161: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
162: When hr_api.unique_integrity_violated Then
163: -- Unique integrity has been violated
164: ben_bpl_shd.g_api_dml := false; -- Unset the api dml status
165: ben_bpl_shd.constraint_error
166: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
167: When Others Then
168: ben_bpl_shd.g_api_dml := false; -- Unset the api dml status
169: Raise;
164: ben_bpl_shd.g_api_dml := false; -- Unset the api dml status
165: ben_bpl_shd.constraint_error
166: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
167: When Others Then
168: ben_bpl_shd.g_api_dml := false; -- Unset the api dml status
169: Raise;
170: End dt_update_dml;
171: --
172: -- ----------------------------------------------------------------------------
200: --
201: -- {End Of Comments}
202: -- ----------------------------------------------------------------------------
203: Procedure update_dml
204: (p_rec in out nocopy ben_bpl_shd.g_rec_type,
205: p_effective_date in date,
206: p_datetrack_mode in varchar2,
207: p_validation_start_date in date,
208: p_validation_end_date in date) is
264: --
265: -- {End Of Comments}
266: -- ----------------------------------------------------------------------------
267: Procedure dt_pre_update
268: (p_rec in out nocopy ben_bpl_shd.g_rec_type,
269: p_effective_date in date,
270: p_datetrack_mode in varchar2,
271: p_validation_start_date in date,
272: p_validation_end_date in date) is
280: hr_utility.set_location(l_proc, 10);
281: --
282: -- Update the current effective end date
283: --
284: ben_bpl_shd.upd_effective_end_date
285: (p_effective_date => p_effective_date,
286: p_base_key_value => p_rec.bnft_prvdd_ldgr_id,
287: p_new_effective_end_date => (p_validation_start_date - 1),
288: p_validation_start_date => p_validation_start_date,
349: --
350: -- {End Of Comments}
351: -- ----------------------------------------------------------------------------
352: Procedure pre_update
353: (p_rec in out nocopy ben_bpl_shd.g_rec_type,
354: p_effective_date in date,
355: p_datetrack_mode in varchar2,
356: p_validation_start_date in date,
357: p_validation_end_date in date) is
405: --
406: -- {End Of Comments}
407: -- ----------------------------------------------------------------------------
408: Procedure post_update
409: (p_rec in ben_bpl_shd.g_rec_type,
410: p_effective_date in date,
411: p_datetrack_mode in varchar2,
412: p_validation_start_date in date,
413: p_validation_end_date in date) is
485: p_ann_prvdd_val => p_rec.ann_prvdd_val,
486: p_ann_rld_up_val => p_rec.ann_rld_up_val,
487: p_ann_used_val => p_rec.ann_used_val,
488: p_ann_cash_recd_val => p_rec.ann_cash_recd_val
489: ,p_effective_start_date_o =>ben_bpl_shd.g_old_rec.effective_start_date
490: ,p_effective_end_date_o =>ben_bpl_shd.g_old_rec.effective_end_date
491: ,p_prtt_ro_of_unusd_amt_flag_o =>ben_bpl_shd.g_old_rec.prtt_ro_of_unusd_amt_flag
492: ,p_frftd_val_o =>ben_bpl_shd.g_old_rec.frftd_val
493: ,p_prvdd_val_o =>ben_bpl_shd.g_old_rec.prvdd_val
486: p_ann_rld_up_val => p_rec.ann_rld_up_val,
487: p_ann_used_val => p_rec.ann_used_val,
488: p_ann_cash_recd_val => p_rec.ann_cash_recd_val
489: ,p_effective_start_date_o =>ben_bpl_shd.g_old_rec.effective_start_date
490: ,p_effective_end_date_o =>ben_bpl_shd.g_old_rec.effective_end_date
491: ,p_prtt_ro_of_unusd_amt_flag_o =>ben_bpl_shd.g_old_rec.prtt_ro_of_unusd_amt_flag
492: ,p_frftd_val_o =>ben_bpl_shd.g_old_rec.frftd_val
493: ,p_prvdd_val_o =>ben_bpl_shd.g_old_rec.prvdd_val
494: ,p_used_val_o =>ben_bpl_shd.g_old_rec.used_val
487: p_ann_used_val => p_rec.ann_used_val,
488: p_ann_cash_recd_val => p_rec.ann_cash_recd_val
489: ,p_effective_start_date_o =>ben_bpl_shd.g_old_rec.effective_start_date
490: ,p_effective_end_date_o =>ben_bpl_shd.g_old_rec.effective_end_date
491: ,p_prtt_ro_of_unusd_amt_flag_o =>ben_bpl_shd.g_old_rec.prtt_ro_of_unusd_amt_flag
492: ,p_frftd_val_o =>ben_bpl_shd.g_old_rec.frftd_val
493: ,p_prvdd_val_o =>ben_bpl_shd.g_old_rec.prvdd_val
494: ,p_used_val_o =>ben_bpl_shd.g_old_rec.used_val
495: ,p_bnft_prvdr_pool_id_o =>ben_bpl_shd.g_old_rec.bnft_prvdr_pool_id
488: p_ann_cash_recd_val => p_rec.ann_cash_recd_val
489: ,p_effective_start_date_o =>ben_bpl_shd.g_old_rec.effective_start_date
490: ,p_effective_end_date_o =>ben_bpl_shd.g_old_rec.effective_end_date
491: ,p_prtt_ro_of_unusd_amt_flag_o =>ben_bpl_shd.g_old_rec.prtt_ro_of_unusd_amt_flag
492: ,p_frftd_val_o =>ben_bpl_shd.g_old_rec.frftd_val
493: ,p_prvdd_val_o =>ben_bpl_shd.g_old_rec.prvdd_val
494: ,p_used_val_o =>ben_bpl_shd.g_old_rec.used_val
495: ,p_bnft_prvdr_pool_id_o =>ben_bpl_shd.g_old_rec.bnft_prvdr_pool_id
496: ,p_acty_base_rt_id_o =>ben_bpl_shd.g_old_rec.acty_base_rt_id
489: ,p_effective_start_date_o =>ben_bpl_shd.g_old_rec.effective_start_date
490: ,p_effective_end_date_o =>ben_bpl_shd.g_old_rec.effective_end_date
491: ,p_prtt_ro_of_unusd_amt_flag_o =>ben_bpl_shd.g_old_rec.prtt_ro_of_unusd_amt_flag
492: ,p_frftd_val_o =>ben_bpl_shd.g_old_rec.frftd_val
493: ,p_prvdd_val_o =>ben_bpl_shd.g_old_rec.prvdd_val
494: ,p_used_val_o =>ben_bpl_shd.g_old_rec.used_val
495: ,p_bnft_prvdr_pool_id_o =>ben_bpl_shd.g_old_rec.bnft_prvdr_pool_id
496: ,p_acty_base_rt_id_o =>ben_bpl_shd.g_old_rec.acty_base_rt_id
497: ,p_per_in_ler_id_o =>ben_bpl_shd.g_old_rec.per_in_ler_id
490: ,p_effective_end_date_o =>ben_bpl_shd.g_old_rec.effective_end_date
491: ,p_prtt_ro_of_unusd_amt_flag_o =>ben_bpl_shd.g_old_rec.prtt_ro_of_unusd_amt_flag
492: ,p_frftd_val_o =>ben_bpl_shd.g_old_rec.frftd_val
493: ,p_prvdd_val_o =>ben_bpl_shd.g_old_rec.prvdd_val
494: ,p_used_val_o =>ben_bpl_shd.g_old_rec.used_val
495: ,p_bnft_prvdr_pool_id_o =>ben_bpl_shd.g_old_rec.bnft_prvdr_pool_id
496: ,p_acty_base_rt_id_o =>ben_bpl_shd.g_old_rec.acty_base_rt_id
497: ,p_per_in_ler_id_o =>ben_bpl_shd.g_old_rec.per_in_ler_id
498: ,p_prtt_enrt_rslt_id_o =>ben_bpl_shd.g_old_rec.prtt_enrt_rslt_id
491: ,p_prtt_ro_of_unusd_amt_flag_o =>ben_bpl_shd.g_old_rec.prtt_ro_of_unusd_amt_flag
492: ,p_frftd_val_o =>ben_bpl_shd.g_old_rec.frftd_val
493: ,p_prvdd_val_o =>ben_bpl_shd.g_old_rec.prvdd_val
494: ,p_used_val_o =>ben_bpl_shd.g_old_rec.used_val
495: ,p_bnft_prvdr_pool_id_o =>ben_bpl_shd.g_old_rec.bnft_prvdr_pool_id
496: ,p_acty_base_rt_id_o =>ben_bpl_shd.g_old_rec.acty_base_rt_id
497: ,p_per_in_ler_id_o =>ben_bpl_shd.g_old_rec.per_in_ler_id
498: ,p_prtt_enrt_rslt_id_o =>ben_bpl_shd.g_old_rec.prtt_enrt_rslt_id
499: ,p_business_group_id_o =>ben_bpl_shd.g_old_rec.business_group_id
492: ,p_frftd_val_o =>ben_bpl_shd.g_old_rec.frftd_val
493: ,p_prvdd_val_o =>ben_bpl_shd.g_old_rec.prvdd_val
494: ,p_used_val_o =>ben_bpl_shd.g_old_rec.used_val
495: ,p_bnft_prvdr_pool_id_o =>ben_bpl_shd.g_old_rec.bnft_prvdr_pool_id
496: ,p_acty_base_rt_id_o =>ben_bpl_shd.g_old_rec.acty_base_rt_id
497: ,p_per_in_ler_id_o =>ben_bpl_shd.g_old_rec.per_in_ler_id
498: ,p_prtt_enrt_rslt_id_o =>ben_bpl_shd.g_old_rec.prtt_enrt_rslt_id
499: ,p_business_group_id_o =>ben_bpl_shd.g_old_rec.business_group_id
500: ,p_bpl_attribute_category_o =>ben_bpl_shd.g_old_rec.bpl_attribute_category
493: ,p_prvdd_val_o =>ben_bpl_shd.g_old_rec.prvdd_val
494: ,p_used_val_o =>ben_bpl_shd.g_old_rec.used_val
495: ,p_bnft_prvdr_pool_id_o =>ben_bpl_shd.g_old_rec.bnft_prvdr_pool_id
496: ,p_acty_base_rt_id_o =>ben_bpl_shd.g_old_rec.acty_base_rt_id
497: ,p_per_in_ler_id_o =>ben_bpl_shd.g_old_rec.per_in_ler_id
498: ,p_prtt_enrt_rslt_id_o =>ben_bpl_shd.g_old_rec.prtt_enrt_rslt_id
499: ,p_business_group_id_o =>ben_bpl_shd.g_old_rec.business_group_id
500: ,p_bpl_attribute_category_o =>ben_bpl_shd.g_old_rec.bpl_attribute_category
501: ,p_bpl_attribute1_o =>ben_bpl_shd.g_old_rec.bpl_attribute1
494: ,p_used_val_o =>ben_bpl_shd.g_old_rec.used_val
495: ,p_bnft_prvdr_pool_id_o =>ben_bpl_shd.g_old_rec.bnft_prvdr_pool_id
496: ,p_acty_base_rt_id_o =>ben_bpl_shd.g_old_rec.acty_base_rt_id
497: ,p_per_in_ler_id_o =>ben_bpl_shd.g_old_rec.per_in_ler_id
498: ,p_prtt_enrt_rslt_id_o =>ben_bpl_shd.g_old_rec.prtt_enrt_rslt_id
499: ,p_business_group_id_o =>ben_bpl_shd.g_old_rec.business_group_id
500: ,p_bpl_attribute_category_o =>ben_bpl_shd.g_old_rec.bpl_attribute_category
501: ,p_bpl_attribute1_o =>ben_bpl_shd.g_old_rec.bpl_attribute1
502: ,p_bpl_attribute2_o =>ben_bpl_shd.g_old_rec.bpl_attribute2
495: ,p_bnft_prvdr_pool_id_o =>ben_bpl_shd.g_old_rec.bnft_prvdr_pool_id
496: ,p_acty_base_rt_id_o =>ben_bpl_shd.g_old_rec.acty_base_rt_id
497: ,p_per_in_ler_id_o =>ben_bpl_shd.g_old_rec.per_in_ler_id
498: ,p_prtt_enrt_rslt_id_o =>ben_bpl_shd.g_old_rec.prtt_enrt_rslt_id
499: ,p_business_group_id_o =>ben_bpl_shd.g_old_rec.business_group_id
500: ,p_bpl_attribute_category_o =>ben_bpl_shd.g_old_rec.bpl_attribute_category
501: ,p_bpl_attribute1_o =>ben_bpl_shd.g_old_rec.bpl_attribute1
502: ,p_bpl_attribute2_o =>ben_bpl_shd.g_old_rec.bpl_attribute2
503: ,p_bpl_attribute3_o =>ben_bpl_shd.g_old_rec.bpl_attribute3
496: ,p_acty_base_rt_id_o =>ben_bpl_shd.g_old_rec.acty_base_rt_id
497: ,p_per_in_ler_id_o =>ben_bpl_shd.g_old_rec.per_in_ler_id
498: ,p_prtt_enrt_rslt_id_o =>ben_bpl_shd.g_old_rec.prtt_enrt_rslt_id
499: ,p_business_group_id_o =>ben_bpl_shd.g_old_rec.business_group_id
500: ,p_bpl_attribute_category_o =>ben_bpl_shd.g_old_rec.bpl_attribute_category
501: ,p_bpl_attribute1_o =>ben_bpl_shd.g_old_rec.bpl_attribute1
502: ,p_bpl_attribute2_o =>ben_bpl_shd.g_old_rec.bpl_attribute2
503: ,p_bpl_attribute3_o =>ben_bpl_shd.g_old_rec.bpl_attribute3
504: ,p_bpl_attribute4_o =>ben_bpl_shd.g_old_rec.bpl_attribute4
497: ,p_per_in_ler_id_o =>ben_bpl_shd.g_old_rec.per_in_ler_id
498: ,p_prtt_enrt_rslt_id_o =>ben_bpl_shd.g_old_rec.prtt_enrt_rslt_id
499: ,p_business_group_id_o =>ben_bpl_shd.g_old_rec.business_group_id
500: ,p_bpl_attribute_category_o =>ben_bpl_shd.g_old_rec.bpl_attribute_category
501: ,p_bpl_attribute1_o =>ben_bpl_shd.g_old_rec.bpl_attribute1
502: ,p_bpl_attribute2_o =>ben_bpl_shd.g_old_rec.bpl_attribute2
503: ,p_bpl_attribute3_o =>ben_bpl_shd.g_old_rec.bpl_attribute3
504: ,p_bpl_attribute4_o =>ben_bpl_shd.g_old_rec.bpl_attribute4
505: ,p_bpl_attribute5_o =>ben_bpl_shd.g_old_rec.bpl_attribute5
498: ,p_prtt_enrt_rslt_id_o =>ben_bpl_shd.g_old_rec.prtt_enrt_rslt_id
499: ,p_business_group_id_o =>ben_bpl_shd.g_old_rec.business_group_id
500: ,p_bpl_attribute_category_o =>ben_bpl_shd.g_old_rec.bpl_attribute_category
501: ,p_bpl_attribute1_o =>ben_bpl_shd.g_old_rec.bpl_attribute1
502: ,p_bpl_attribute2_o =>ben_bpl_shd.g_old_rec.bpl_attribute2
503: ,p_bpl_attribute3_o =>ben_bpl_shd.g_old_rec.bpl_attribute3
504: ,p_bpl_attribute4_o =>ben_bpl_shd.g_old_rec.bpl_attribute4
505: ,p_bpl_attribute5_o =>ben_bpl_shd.g_old_rec.bpl_attribute5
506: ,p_bpl_attribute6_o =>ben_bpl_shd.g_old_rec.bpl_attribute6
499: ,p_business_group_id_o =>ben_bpl_shd.g_old_rec.business_group_id
500: ,p_bpl_attribute_category_o =>ben_bpl_shd.g_old_rec.bpl_attribute_category
501: ,p_bpl_attribute1_o =>ben_bpl_shd.g_old_rec.bpl_attribute1
502: ,p_bpl_attribute2_o =>ben_bpl_shd.g_old_rec.bpl_attribute2
503: ,p_bpl_attribute3_o =>ben_bpl_shd.g_old_rec.bpl_attribute3
504: ,p_bpl_attribute4_o =>ben_bpl_shd.g_old_rec.bpl_attribute4
505: ,p_bpl_attribute5_o =>ben_bpl_shd.g_old_rec.bpl_attribute5
506: ,p_bpl_attribute6_o =>ben_bpl_shd.g_old_rec.bpl_attribute6
507: ,p_bpl_attribute7_o =>ben_bpl_shd.g_old_rec.bpl_attribute7
500: ,p_bpl_attribute_category_o =>ben_bpl_shd.g_old_rec.bpl_attribute_category
501: ,p_bpl_attribute1_o =>ben_bpl_shd.g_old_rec.bpl_attribute1
502: ,p_bpl_attribute2_o =>ben_bpl_shd.g_old_rec.bpl_attribute2
503: ,p_bpl_attribute3_o =>ben_bpl_shd.g_old_rec.bpl_attribute3
504: ,p_bpl_attribute4_o =>ben_bpl_shd.g_old_rec.bpl_attribute4
505: ,p_bpl_attribute5_o =>ben_bpl_shd.g_old_rec.bpl_attribute5
506: ,p_bpl_attribute6_o =>ben_bpl_shd.g_old_rec.bpl_attribute6
507: ,p_bpl_attribute7_o =>ben_bpl_shd.g_old_rec.bpl_attribute7
508: ,p_bpl_attribute8_o =>ben_bpl_shd.g_old_rec.bpl_attribute8
501: ,p_bpl_attribute1_o =>ben_bpl_shd.g_old_rec.bpl_attribute1
502: ,p_bpl_attribute2_o =>ben_bpl_shd.g_old_rec.bpl_attribute2
503: ,p_bpl_attribute3_o =>ben_bpl_shd.g_old_rec.bpl_attribute3
504: ,p_bpl_attribute4_o =>ben_bpl_shd.g_old_rec.bpl_attribute4
505: ,p_bpl_attribute5_o =>ben_bpl_shd.g_old_rec.bpl_attribute5
506: ,p_bpl_attribute6_o =>ben_bpl_shd.g_old_rec.bpl_attribute6
507: ,p_bpl_attribute7_o =>ben_bpl_shd.g_old_rec.bpl_attribute7
508: ,p_bpl_attribute8_o =>ben_bpl_shd.g_old_rec.bpl_attribute8
509: ,p_bpl_attribute9_o =>ben_bpl_shd.g_old_rec.bpl_attribute9
502: ,p_bpl_attribute2_o =>ben_bpl_shd.g_old_rec.bpl_attribute2
503: ,p_bpl_attribute3_o =>ben_bpl_shd.g_old_rec.bpl_attribute3
504: ,p_bpl_attribute4_o =>ben_bpl_shd.g_old_rec.bpl_attribute4
505: ,p_bpl_attribute5_o =>ben_bpl_shd.g_old_rec.bpl_attribute5
506: ,p_bpl_attribute6_o =>ben_bpl_shd.g_old_rec.bpl_attribute6
507: ,p_bpl_attribute7_o =>ben_bpl_shd.g_old_rec.bpl_attribute7
508: ,p_bpl_attribute8_o =>ben_bpl_shd.g_old_rec.bpl_attribute8
509: ,p_bpl_attribute9_o =>ben_bpl_shd.g_old_rec.bpl_attribute9
510: ,p_bpl_attribute10_o =>ben_bpl_shd.g_old_rec.bpl_attribute10
503: ,p_bpl_attribute3_o =>ben_bpl_shd.g_old_rec.bpl_attribute3
504: ,p_bpl_attribute4_o =>ben_bpl_shd.g_old_rec.bpl_attribute4
505: ,p_bpl_attribute5_o =>ben_bpl_shd.g_old_rec.bpl_attribute5
506: ,p_bpl_attribute6_o =>ben_bpl_shd.g_old_rec.bpl_attribute6
507: ,p_bpl_attribute7_o =>ben_bpl_shd.g_old_rec.bpl_attribute7
508: ,p_bpl_attribute8_o =>ben_bpl_shd.g_old_rec.bpl_attribute8
509: ,p_bpl_attribute9_o =>ben_bpl_shd.g_old_rec.bpl_attribute9
510: ,p_bpl_attribute10_o =>ben_bpl_shd.g_old_rec.bpl_attribute10
511: ,p_bpl_attribute11_o =>ben_bpl_shd.g_old_rec.bpl_attribute11
504: ,p_bpl_attribute4_o =>ben_bpl_shd.g_old_rec.bpl_attribute4
505: ,p_bpl_attribute5_o =>ben_bpl_shd.g_old_rec.bpl_attribute5
506: ,p_bpl_attribute6_o =>ben_bpl_shd.g_old_rec.bpl_attribute6
507: ,p_bpl_attribute7_o =>ben_bpl_shd.g_old_rec.bpl_attribute7
508: ,p_bpl_attribute8_o =>ben_bpl_shd.g_old_rec.bpl_attribute8
509: ,p_bpl_attribute9_o =>ben_bpl_shd.g_old_rec.bpl_attribute9
510: ,p_bpl_attribute10_o =>ben_bpl_shd.g_old_rec.bpl_attribute10
511: ,p_bpl_attribute11_o =>ben_bpl_shd.g_old_rec.bpl_attribute11
512: ,p_bpl_attribute12_o =>ben_bpl_shd.g_old_rec.bpl_attribute12
505: ,p_bpl_attribute5_o =>ben_bpl_shd.g_old_rec.bpl_attribute5
506: ,p_bpl_attribute6_o =>ben_bpl_shd.g_old_rec.bpl_attribute6
507: ,p_bpl_attribute7_o =>ben_bpl_shd.g_old_rec.bpl_attribute7
508: ,p_bpl_attribute8_o =>ben_bpl_shd.g_old_rec.bpl_attribute8
509: ,p_bpl_attribute9_o =>ben_bpl_shd.g_old_rec.bpl_attribute9
510: ,p_bpl_attribute10_o =>ben_bpl_shd.g_old_rec.bpl_attribute10
511: ,p_bpl_attribute11_o =>ben_bpl_shd.g_old_rec.bpl_attribute11
512: ,p_bpl_attribute12_o =>ben_bpl_shd.g_old_rec.bpl_attribute12
513: ,p_bpl_attribute13_o =>ben_bpl_shd.g_old_rec.bpl_attribute13
506: ,p_bpl_attribute6_o =>ben_bpl_shd.g_old_rec.bpl_attribute6
507: ,p_bpl_attribute7_o =>ben_bpl_shd.g_old_rec.bpl_attribute7
508: ,p_bpl_attribute8_o =>ben_bpl_shd.g_old_rec.bpl_attribute8
509: ,p_bpl_attribute9_o =>ben_bpl_shd.g_old_rec.bpl_attribute9
510: ,p_bpl_attribute10_o =>ben_bpl_shd.g_old_rec.bpl_attribute10
511: ,p_bpl_attribute11_o =>ben_bpl_shd.g_old_rec.bpl_attribute11
512: ,p_bpl_attribute12_o =>ben_bpl_shd.g_old_rec.bpl_attribute12
513: ,p_bpl_attribute13_o =>ben_bpl_shd.g_old_rec.bpl_attribute13
514: ,p_bpl_attribute14_o =>ben_bpl_shd.g_old_rec.bpl_attribute14
507: ,p_bpl_attribute7_o =>ben_bpl_shd.g_old_rec.bpl_attribute7
508: ,p_bpl_attribute8_o =>ben_bpl_shd.g_old_rec.bpl_attribute8
509: ,p_bpl_attribute9_o =>ben_bpl_shd.g_old_rec.bpl_attribute9
510: ,p_bpl_attribute10_o =>ben_bpl_shd.g_old_rec.bpl_attribute10
511: ,p_bpl_attribute11_o =>ben_bpl_shd.g_old_rec.bpl_attribute11
512: ,p_bpl_attribute12_o =>ben_bpl_shd.g_old_rec.bpl_attribute12
513: ,p_bpl_attribute13_o =>ben_bpl_shd.g_old_rec.bpl_attribute13
514: ,p_bpl_attribute14_o =>ben_bpl_shd.g_old_rec.bpl_attribute14
515: ,p_bpl_attribute15_o =>ben_bpl_shd.g_old_rec.bpl_attribute15
508: ,p_bpl_attribute8_o =>ben_bpl_shd.g_old_rec.bpl_attribute8
509: ,p_bpl_attribute9_o =>ben_bpl_shd.g_old_rec.bpl_attribute9
510: ,p_bpl_attribute10_o =>ben_bpl_shd.g_old_rec.bpl_attribute10
511: ,p_bpl_attribute11_o =>ben_bpl_shd.g_old_rec.bpl_attribute11
512: ,p_bpl_attribute12_o =>ben_bpl_shd.g_old_rec.bpl_attribute12
513: ,p_bpl_attribute13_o =>ben_bpl_shd.g_old_rec.bpl_attribute13
514: ,p_bpl_attribute14_o =>ben_bpl_shd.g_old_rec.bpl_attribute14
515: ,p_bpl_attribute15_o =>ben_bpl_shd.g_old_rec.bpl_attribute15
516: ,p_bpl_attribute16_o =>ben_bpl_shd.g_old_rec.bpl_attribute16
509: ,p_bpl_attribute9_o =>ben_bpl_shd.g_old_rec.bpl_attribute9
510: ,p_bpl_attribute10_o =>ben_bpl_shd.g_old_rec.bpl_attribute10
511: ,p_bpl_attribute11_o =>ben_bpl_shd.g_old_rec.bpl_attribute11
512: ,p_bpl_attribute12_o =>ben_bpl_shd.g_old_rec.bpl_attribute12
513: ,p_bpl_attribute13_o =>ben_bpl_shd.g_old_rec.bpl_attribute13
514: ,p_bpl_attribute14_o =>ben_bpl_shd.g_old_rec.bpl_attribute14
515: ,p_bpl_attribute15_o =>ben_bpl_shd.g_old_rec.bpl_attribute15
516: ,p_bpl_attribute16_o =>ben_bpl_shd.g_old_rec.bpl_attribute16
517: ,p_bpl_attribute17_o =>ben_bpl_shd.g_old_rec.bpl_attribute17
510: ,p_bpl_attribute10_o =>ben_bpl_shd.g_old_rec.bpl_attribute10
511: ,p_bpl_attribute11_o =>ben_bpl_shd.g_old_rec.bpl_attribute11
512: ,p_bpl_attribute12_o =>ben_bpl_shd.g_old_rec.bpl_attribute12
513: ,p_bpl_attribute13_o =>ben_bpl_shd.g_old_rec.bpl_attribute13
514: ,p_bpl_attribute14_o =>ben_bpl_shd.g_old_rec.bpl_attribute14
515: ,p_bpl_attribute15_o =>ben_bpl_shd.g_old_rec.bpl_attribute15
516: ,p_bpl_attribute16_o =>ben_bpl_shd.g_old_rec.bpl_attribute16
517: ,p_bpl_attribute17_o =>ben_bpl_shd.g_old_rec.bpl_attribute17
518: ,p_bpl_attribute18_o =>ben_bpl_shd.g_old_rec.bpl_attribute18
511: ,p_bpl_attribute11_o =>ben_bpl_shd.g_old_rec.bpl_attribute11
512: ,p_bpl_attribute12_o =>ben_bpl_shd.g_old_rec.bpl_attribute12
513: ,p_bpl_attribute13_o =>ben_bpl_shd.g_old_rec.bpl_attribute13
514: ,p_bpl_attribute14_o =>ben_bpl_shd.g_old_rec.bpl_attribute14
515: ,p_bpl_attribute15_o =>ben_bpl_shd.g_old_rec.bpl_attribute15
516: ,p_bpl_attribute16_o =>ben_bpl_shd.g_old_rec.bpl_attribute16
517: ,p_bpl_attribute17_o =>ben_bpl_shd.g_old_rec.bpl_attribute17
518: ,p_bpl_attribute18_o =>ben_bpl_shd.g_old_rec.bpl_attribute18
519: ,p_bpl_attribute19_o =>ben_bpl_shd.g_old_rec.bpl_attribute19
512: ,p_bpl_attribute12_o =>ben_bpl_shd.g_old_rec.bpl_attribute12
513: ,p_bpl_attribute13_o =>ben_bpl_shd.g_old_rec.bpl_attribute13
514: ,p_bpl_attribute14_o =>ben_bpl_shd.g_old_rec.bpl_attribute14
515: ,p_bpl_attribute15_o =>ben_bpl_shd.g_old_rec.bpl_attribute15
516: ,p_bpl_attribute16_o =>ben_bpl_shd.g_old_rec.bpl_attribute16
517: ,p_bpl_attribute17_o =>ben_bpl_shd.g_old_rec.bpl_attribute17
518: ,p_bpl_attribute18_o =>ben_bpl_shd.g_old_rec.bpl_attribute18
519: ,p_bpl_attribute19_o =>ben_bpl_shd.g_old_rec.bpl_attribute19
520: ,p_bpl_attribute20_o =>ben_bpl_shd.g_old_rec.bpl_attribute20
513: ,p_bpl_attribute13_o =>ben_bpl_shd.g_old_rec.bpl_attribute13
514: ,p_bpl_attribute14_o =>ben_bpl_shd.g_old_rec.bpl_attribute14
515: ,p_bpl_attribute15_o =>ben_bpl_shd.g_old_rec.bpl_attribute15
516: ,p_bpl_attribute16_o =>ben_bpl_shd.g_old_rec.bpl_attribute16
517: ,p_bpl_attribute17_o =>ben_bpl_shd.g_old_rec.bpl_attribute17
518: ,p_bpl_attribute18_o =>ben_bpl_shd.g_old_rec.bpl_attribute18
519: ,p_bpl_attribute19_o =>ben_bpl_shd.g_old_rec.bpl_attribute19
520: ,p_bpl_attribute20_o =>ben_bpl_shd.g_old_rec.bpl_attribute20
521: ,p_bpl_attribute21_o =>ben_bpl_shd.g_old_rec.bpl_attribute21
514: ,p_bpl_attribute14_o =>ben_bpl_shd.g_old_rec.bpl_attribute14
515: ,p_bpl_attribute15_o =>ben_bpl_shd.g_old_rec.bpl_attribute15
516: ,p_bpl_attribute16_o =>ben_bpl_shd.g_old_rec.bpl_attribute16
517: ,p_bpl_attribute17_o =>ben_bpl_shd.g_old_rec.bpl_attribute17
518: ,p_bpl_attribute18_o =>ben_bpl_shd.g_old_rec.bpl_attribute18
519: ,p_bpl_attribute19_o =>ben_bpl_shd.g_old_rec.bpl_attribute19
520: ,p_bpl_attribute20_o =>ben_bpl_shd.g_old_rec.bpl_attribute20
521: ,p_bpl_attribute21_o =>ben_bpl_shd.g_old_rec.bpl_attribute21
522: ,p_bpl_attribute22_o =>ben_bpl_shd.g_old_rec.bpl_attribute22
515: ,p_bpl_attribute15_o =>ben_bpl_shd.g_old_rec.bpl_attribute15
516: ,p_bpl_attribute16_o =>ben_bpl_shd.g_old_rec.bpl_attribute16
517: ,p_bpl_attribute17_o =>ben_bpl_shd.g_old_rec.bpl_attribute17
518: ,p_bpl_attribute18_o =>ben_bpl_shd.g_old_rec.bpl_attribute18
519: ,p_bpl_attribute19_o =>ben_bpl_shd.g_old_rec.bpl_attribute19
520: ,p_bpl_attribute20_o =>ben_bpl_shd.g_old_rec.bpl_attribute20
521: ,p_bpl_attribute21_o =>ben_bpl_shd.g_old_rec.bpl_attribute21
522: ,p_bpl_attribute22_o =>ben_bpl_shd.g_old_rec.bpl_attribute22
523: ,p_bpl_attribute23_o =>ben_bpl_shd.g_old_rec.bpl_attribute23
516: ,p_bpl_attribute16_o =>ben_bpl_shd.g_old_rec.bpl_attribute16
517: ,p_bpl_attribute17_o =>ben_bpl_shd.g_old_rec.bpl_attribute17
518: ,p_bpl_attribute18_o =>ben_bpl_shd.g_old_rec.bpl_attribute18
519: ,p_bpl_attribute19_o =>ben_bpl_shd.g_old_rec.bpl_attribute19
520: ,p_bpl_attribute20_o =>ben_bpl_shd.g_old_rec.bpl_attribute20
521: ,p_bpl_attribute21_o =>ben_bpl_shd.g_old_rec.bpl_attribute21
522: ,p_bpl_attribute22_o =>ben_bpl_shd.g_old_rec.bpl_attribute22
523: ,p_bpl_attribute23_o =>ben_bpl_shd.g_old_rec.bpl_attribute23
524: ,p_bpl_attribute24_o =>ben_bpl_shd.g_old_rec.bpl_attribute24
517: ,p_bpl_attribute17_o =>ben_bpl_shd.g_old_rec.bpl_attribute17
518: ,p_bpl_attribute18_o =>ben_bpl_shd.g_old_rec.bpl_attribute18
519: ,p_bpl_attribute19_o =>ben_bpl_shd.g_old_rec.bpl_attribute19
520: ,p_bpl_attribute20_o =>ben_bpl_shd.g_old_rec.bpl_attribute20
521: ,p_bpl_attribute21_o =>ben_bpl_shd.g_old_rec.bpl_attribute21
522: ,p_bpl_attribute22_o =>ben_bpl_shd.g_old_rec.bpl_attribute22
523: ,p_bpl_attribute23_o =>ben_bpl_shd.g_old_rec.bpl_attribute23
524: ,p_bpl_attribute24_o =>ben_bpl_shd.g_old_rec.bpl_attribute24
525: ,p_bpl_attribute25_o =>ben_bpl_shd.g_old_rec.bpl_attribute25
518: ,p_bpl_attribute18_o =>ben_bpl_shd.g_old_rec.bpl_attribute18
519: ,p_bpl_attribute19_o =>ben_bpl_shd.g_old_rec.bpl_attribute19
520: ,p_bpl_attribute20_o =>ben_bpl_shd.g_old_rec.bpl_attribute20
521: ,p_bpl_attribute21_o =>ben_bpl_shd.g_old_rec.bpl_attribute21
522: ,p_bpl_attribute22_o =>ben_bpl_shd.g_old_rec.bpl_attribute22
523: ,p_bpl_attribute23_o =>ben_bpl_shd.g_old_rec.bpl_attribute23
524: ,p_bpl_attribute24_o =>ben_bpl_shd.g_old_rec.bpl_attribute24
525: ,p_bpl_attribute25_o =>ben_bpl_shd.g_old_rec.bpl_attribute25
526: ,p_bpl_attribute26_o =>ben_bpl_shd.g_old_rec.bpl_attribute26
519: ,p_bpl_attribute19_o =>ben_bpl_shd.g_old_rec.bpl_attribute19
520: ,p_bpl_attribute20_o =>ben_bpl_shd.g_old_rec.bpl_attribute20
521: ,p_bpl_attribute21_o =>ben_bpl_shd.g_old_rec.bpl_attribute21
522: ,p_bpl_attribute22_o =>ben_bpl_shd.g_old_rec.bpl_attribute22
523: ,p_bpl_attribute23_o =>ben_bpl_shd.g_old_rec.bpl_attribute23
524: ,p_bpl_attribute24_o =>ben_bpl_shd.g_old_rec.bpl_attribute24
525: ,p_bpl_attribute25_o =>ben_bpl_shd.g_old_rec.bpl_attribute25
526: ,p_bpl_attribute26_o =>ben_bpl_shd.g_old_rec.bpl_attribute26
527: ,p_bpl_attribute27_o =>ben_bpl_shd.g_old_rec.bpl_attribute27
520: ,p_bpl_attribute20_o =>ben_bpl_shd.g_old_rec.bpl_attribute20
521: ,p_bpl_attribute21_o =>ben_bpl_shd.g_old_rec.bpl_attribute21
522: ,p_bpl_attribute22_o =>ben_bpl_shd.g_old_rec.bpl_attribute22
523: ,p_bpl_attribute23_o =>ben_bpl_shd.g_old_rec.bpl_attribute23
524: ,p_bpl_attribute24_o =>ben_bpl_shd.g_old_rec.bpl_attribute24
525: ,p_bpl_attribute25_o =>ben_bpl_shd.g_old_rec.bpl_attribute25
526: ,p_bpl_attribute26_o =>ben_bpl_shd.g_old_rec.bpl_attribute26
527: ,p_bpl_attribute27_o =>ben_bpl_shd.g_old_rec.bpl_attribute27
528: ,p_bpl_attribute28_o =>ben_bpl_shd.g_old_rec.bpl_attribute28
521: ,p_bpl_attribute21_o =>ben_bpl_shd.g_old_rec.bpl_attribute21
522: ,p_bpl_attribute22_o =>ben_bpl_shd.g_old_rec.bpl_attribute22
523: ,p_bpl_attribute23_o =>ben_bpl_shd.g_old_rec.bpl_attribute23
524: ,p_bpl_attribute24_o =>ben_bpl_shd.g_old_rec.bpl_attribute24
525: ,p_bpl_attribute25_o =>ben_bpl_shd.g_old_rec.bpl_attribute25
526: ,p_bpl_attribute26_o =>ben_bpl_shd.g_old_rec.bpl_attribute26
527: ,p_bpl_attribute27_o =>ben_bpl_shd.g_old_rec.bpl_attribute27
528: ,p_bpl_attribute28_o =>ben_bpl_shd.g_old_rec.bpl_attribute28
529: ,p_bpl_attribute29_o =>ben_bpl_shd.g_old_rec.bpl_attribute29
522: ,p_bpl_attribute22_o =>ben_bpl_shd.g_old_rec.bpl_attribute22
523: ,p_bpl_attribute23_o =>ben_bpl_shd.g_old_rec.bpl_attribute23
524: ,p_bpl_attribute24_o =>ben_bpl_shd.g_old_rec.bpl_attribute24
525: ,p_bpl_attribute25_o =>ben_bpl_shd.g_old_rec.bpl_attribute25
526: ,p_bpl_attribute26_o =>ben_bpl_shd.g_old_rec.bpl_attribute26
527: ,p_bpl_attribute27_o =>ben_bpl_shd.g_old_rec.bpl_attribute27
528: ,p_bpl_attribute28_o =>ben_bpl_shd.g_old_rec.bpl_attribute28
529: ,p_bpl_attribute29_o =>ben_bpl_shd.g_old_rec.bpl_attribute29
530: ,p_bpl_attribute30_o =>ben_bpl_shd.g_old_rec.bpl_attribute30
523: ,p_bpl_attribute23_o =>ben_bpl_shd.g_old_rec.bpl_attribute23
524: ,p_bpl_attribute24_o =>ben_bpl_shd.g_old_rec.bpl_attribute24
525: ,p_bpl_attribute25_o =>ben_bpl_shd.g_old_rec.bpl_attribute25
526: ,p_bpl_attribute26_o =>ben_bpl_shd.g_old_rec.bpl_attribute26
527: ,p_bpl_attribute27_o =>ben_bpl_shd.g_old_rec.bpl_attribute27
528: ,p_bpl_attribute28_o =>ben_bpl_shd.g_old_rec.bpl_attribute28
529: ,p_bpl_attribute29_o =>ben_bpl_shd.g_old_rec.bpl_attribute29
530: ,p_bpl_attribute30_o =>ben_bpl_shd.g_old_rec.bpl_attribute30
531: ,p_object_version_number_o =>ben_bpl_shd.g_old_rec.object_version_number
524: ,p_bpl_attribute24_o =>ben_bpl_shd.g_old_rec.bpl_attribute24
525: ,p_bpl_attribute25_o =>ben_bpl_shd.g_old_rec.bpl_attribute25
526: ,p_bpl_attribute26_o =>ben_bpl_shd.g_old_rec.bpl_attribute26
527: ,p_bpl_attribute27_o =>ben_bpl_shd.g_old_rec.bpl_attribute27
528: ,p_bpl_attribute28_o =>ben_bpl_shd.g_old_rec.bpl_attribute28
529: ,p_bpl_attribute29_o =>ben_bpl_shd.g_old_rec.bpl_attribute29
530: ,p_bpl_attribute30_o =>ben_bpl_shd.g_old_rec.bpl_attribute30
531: ,p_object_version_number_o =>ben_bpl_shd.g_old_rec.object_version_number
532: ,p_cash_recd_val_o =>ben_bpl_shd.g_old_rec.cash_recd_val
525: ,p_bpl_attribute25_o =>ben_bpl_shd.g_old_rec.bpl_attribute25
526: ,p_bpl_attribute26_o =>ben_bpl_shd.g_old_rec.bpl_attribute26
527: ,p_bpl_attribute27_o =>ben_bpl_shd.g_old_rec.bpl_attribute27
528: ,p_bpl_attribute28_o =>ben_bpl_shd.g_old_rec.bpl_attribute28
529: ,p_bpl_attribute29_o =>ben_bpl_shd.g_old_rec.bpl_attribute29
530: ,p_bpl_attribute30_o =>ben_bpl_shd.g_old_rec.bpl_attribute30
531: ,p_object_version_number_o =>ben_bpl_shd.g_old_rec.object_version_number
532: ,p_cash_recd_val_o =>ben_bpl_shd.g_old_rec.cash_recd_val
533: ,p_rld_up_val_o =>ben_bpl_shd.g_old_rec.rld_up_val,
526: ,p_bpl_attribute26_o =>ben_bpl_shd.g_old_rec.bpl_attribute26
527: ,p_bpl_attribute27_o =>ben_bpl_shd.g_old_rec.bpl_attribute27
528: ,p_bpl_attribute28_o =>ben_bpl_shd.g_old_rec.bpl_attribute28
529: ,p_bpl_attribute29_o =>ben_bpl_shd.g_old_rec.bpl_attribute29
530: ,p_bpl_attribute30_o =>ben_bpl_shd.g_old_rec.bpl_attribute30
531: ,p_object_version_number_o =>ben_bpl_shd.g_old_rec.object_version_number
532: ,p_cash_recd_val_o =>ben_bpl_shd.g_old_rec.cash_recd_val
533: ,p_rld_up_val_o =>ben_bpl_shd.g_old_rec.rld_up_val,
534: p_acty_ref_perd_cd_o => ben_bpl_shd.g_old_rec.acty_ref_perd_cd,
527: ,p_bpl_attribute27_o =>ben_bpl_shd.g_old_rec.bpl_attribute27
528: ,p_bpl_attribute28_o =>ben_bpl_shd.g_old_rec.bpl_attribute28
529: ,p_bpl_attribute29_o =>ben_bpl_shd.g_old_rec.bpl_attribute29
530: ,p_bpl_attribute30_o =>ben_bpl_shd.g_old_rec.bpl_attribute30
531: ,p_object_version_number_o =>ben_bpl_shd.g_old_rec.object_version_number
532: ,p_cash_recd_val_o =>ben_bpl_shd.g_old_rec.cash_recd_val
533: ,p_rld_up_val_o =>ben_bpl_shd.g_old_rec.rld_up_val,
534: p_acty_ref_perd_cd_o => ben_bpl_shd.g_old_rec.acty_ref_perd_cd,
535: p_cmcd_frftd_val_o => ben_bpl_shd.g_old_rec.cmcd_frftd_val,
528: ,p_bpl_attribute28_o =>ben_bpl_shd.g_old_rec.bpl_attribute28
529: ,p_bpl_attribute29_o =>ben_bpl_shd.g_old_rec.bpl_attribute29
530: ,p_bpl_attribute30_o =>ben_bpl_shd.g_old_rec.bpl_attribute30
531: ,p_object_version_number_o =>ben_bpl_shd.g_old_rec.object_version_number
532: ,p_cash_recd_val_o =>ben_bpl_shd.g_old_rec.cash_recd_val
533: ,p_rld_up_val_o =>ben_bpl_shd.g_old_rec.rld_up_val,
534: p_acty_ref_perd_cd_o => ben_bpl_shd.g_old_rec.acty_ref_perd_cd,
535: p_cmcd_frftd_val_o => ben_bpl_shd.g_old_rec.cmcd_frftd_val,
536: p_cmcd_prvdd_val_o => ben_bpl_shd.g_old_rec.cmcd_prvdd_val,
529: ,p_bpl_attribute29_o =>ben_bpl_shd.g_old_rec.bpl_attribute29
530: ,p_bpl_attribute30_o =>ben_bpl_shd.g_old_rec.bpl_attribute30
531: ,p_object_version_number_o =>ben_bpl_shd.g_old_rec.object_version_number
532: ,p_cash_recd_val_o =>ben_bpl_shd.g_old_rec.cash_recd_val
533: ,p_rld_up_val_o =>ben_bpl_shd.g_old_rec.rld_up_val,
534: p_acty_ref_perd_cd_o => ben_bpl_shd.g_old_rec.acty_ref_perd_cd,
535: p_cmcd_frftd_val_o => ben_bpl_shd.g_old_rec.cmcd_frftd_val,
536: p_cmcd_prvdd_val_o => ben_bpl_shd.g_old_rec.cmcd_prvdd_val,
537: p_cmcd_rld_up_val_o => ben_bpl_shd.g_old_rec.cmcd_rld_up_val,
530: ,p_bpl_attribute30_o =>ben_bpl_shd.g_old_rec.bpl_attribute30
531: ,p_object_version_number_o =>ben_bpl_shd.g_old_rec.object_version_number
532: ,p_cash_recd_val_o =>ben_bpl_shd.g_old_rec.cash_recd_val
533: ,p_rld_up_val_o =>ben_bpl_shd.g_old_rec.rld_up_val,
534: p_acty_ref_perd_cd_o => ben_bpl_shd.g_old_rec.acty_ref_perd_cd,
535: p_cmcd_frftd_val_o => ben_bpl_shd.g_old_rec.cmcd_frftd_val,
536: p_cmcd_prvdd_val_o => ben_bpl_shd.g_old_rec.cmcd_prvdd_val,
537: p_cmcd_rld_up_val_o => ben_bpl_shd.g_old_rec.cmcd_rld_up_val,
538: p_cmcd_used_val_o => ben_bpl_shd.g_old_rec.cmcd_used_val,
531: ,p_object_version_number_o =>ben_bpl_shd.g_old_rec.object_version_number
532: ,p_cash_recd_val_o =>ben_bpl_shd.g_old_rec.cash_recd_val
533: ,p_rld_up_val_o =>ben_bpl_shd.g_old_rec.rld_up_val,
534: p_acty_ref_perd_cd_o => ben_bpl_shd.g_old_rec.acty_ref_perd_cd,
535: p_cmcd_frftd_val_o => ben_bpl_shd.g_old_rec.cmcd_frftd_val,
536: p_cmcd_prvdd_val_o => ben_bpl_shd.g_old_rec.cmcd_prvdd_val,
537: p_cmcd_rld_up_val_o => ben_bpl_shd.g_old_rec.cmcd_rld_up_val,
538: p_cmcd_used_val_o => ben_bpl_shd.g_old_rec.cmcd_used_val,
539: p_cmcd_cash_recd_val_o => ben_bpl_shd.g_old_rec.cmcd_cash_recd_val,
532: ,p_cash_recd_val_o =>ben_bpl_shd.g_old_rec.cash_recd_val
533: ,p_rld_up_val_o =>ben_bpl_shd.g_old_rec.rld_up_val,
534: p_acty_ref_perd_cd_o => ben_bpl_shd.g_old_rec.acty_ref_perd_cd,
535: p_cmcd_frftd_val_o => ben_bpl_shd.g_old_rec.cmcd_frftd_val,
536: p_cmcd_prvdd_val_o => ben_bpl_shd.g_old_rec.cmcd_prvdd_val,
537: p_cmcd_rld_up_val_o => ben_bpl_shd.g_old_rec.cmcd_rld_up_val,
538: p_cmcd_used_val_o => ben_bpl_shd.g_old_rec.cmcd_used_val,
539: p_cmcd_cash_recd_val_o => ben_bpl_shd.g_old_rec.cmcd_cash_recd_val,
540: p_cmcd_ref_perd_cd_o => ben_bpl_shd.g_old_rec.cmcd_ref_perd_cd,
533: ,p_rld_up_val_o =>ben_bpl_shd.g_old_rec.rld_up_val,
534: p_acty_ref_perd_cd_o => ben_bpl_shd.g_old_rec.acty_ref_perd_cd,
535: p_cmcd_frftd_val_o => ben_bpl_shd.g_old_rec.cmcd_frftd_val,
536: p_cmcd_prvdd_val_o => ben_bpl_shd.g_old_rec.cmcd_prvdd_val,
537: p_cmcd_rld_up_val_o => ben_bpl_shd.g_old_rec.cmcd_rld_up_val,
538: p_cmcd_used_val_o => ben_bpl_shd.g_old_rec.cmcd_used_val,
539: p_cmcd_cash_recd_val_o => ben_bpl_shd.g_old_rec.cmcd_cash_recd_val,
540: p_cmcd_ref_perd_cd_o => ben_bpl_shd.g_old_rec.cmcd_ref_perd_cd,
541: p_ann_frftd_val_o => ben_bpl_shd.g_old_rec.ann_frftd_val,
534: p_acty_ref_perd_cd_o => ben_bpl_shd.g_old_rec.acty_ref_perd_cd,
535: p_cmcd_frftd_val_o => ben_bpl_shd.g_old_rec.cmcd_frftd_val,
536: p_cmcd_prvdd_val_o => ben_bpl_shd.g_old_rec.cmcd_prvdd_val,
537: p_cmcd_rld_up_val_o => ben_bpl_shd.g_old_rec.cmcd_rld_up_val,
538: p_cmcd_used_val_o => ben_bpl_shd.g_old_rec.cmcd_used_val,
539: p_cmcd_cash_recd_val_o => ben_bpl_shd.g_old_rec.cmcd_cash_recd_val,
540: p_cmcd_ref_perd_cd_o => ben_bpl_shd.g_old_rec.cmcd_ref_perd_cd,
541: p_ann_frftd_val_o => ben_bpl_shd.g_old_rec.ann_frftd_val,
542: p_ann_prvdd_val_o => ben_bpl_shd.g_old_rec.ann_prvdd_val,
535: p_cmcd_frftd_val_o => ben_bpl_shd.g_old_rec.cmcd_frftd_val,
536: p_cmcd_prvdd_val_o => ben_bpl_shd.g_old_rec.cmcd_prvdd_val,
537: p_cmcd_rld_up_val_o => ben_bpl_shd.g_old_rec.cmcd_rld_up_val,
538: p_cmcd_used_val_o => ben_bpl_shd.g_old_rec.cmcd_used_val,
539: p_cmcd_cash_recd_val_o => ben_bpl_shd.g_old_rec.cmcd_cash_recd_val,
540: p_cmcd_ref_perd_cd_o => ben_bpl_shd.g_old_rec.cmcd_ref_perd_cd,
541: p_ann_frftd_val_o => ben_bpl_shd.g_old_rec.ann_frftd_val,
542: p_ann_prvdd_val_o => ben_bpl_shd.g_old_rec.ann_prvdd_val,
543: p_ann_rld_up_val_o => ben_bpl_shd.g_old_rec.ann_rld_up_val,
536: p_cmcd_prvdd_val_o => ben_bpl_shd.g_old_rec.cmcd_prvdd_val,
537: p_cmcd_rld_up_val_o => ben_bpl_shd.g_old_rec.cmcd_rld_up_val,
538: p_cmcd_used_val_o => ben_bpl_shd.g_old_rec.cmcd_used_val,
539: p_cmcd_cash_recd_val_o => ben_bpl_shd.g_old_rec.cmcd_cash_recd_val,
540: p_cmcd_ref_perd_cd_o => ben_bpl_shd.g_old_rec.cmcd_ref_perd_cd,
541: p_ann_frftd_val_o => ben_bpl_shd.g_old_rec.ann_frftd_val,
542: p_ann_prvdd_val_o => ben_bpl_shd.g_old_rec.ann_prvdd_val,
543: p_ann_rld_up_val_o => ben_bpl_shd.g_old_rec.ann_rld_up_val,
544: p_ann_used_val_o => ben_bpl_shd.g_old_rec.ann_used_val,
537: p_cmcd_rld_up_val_o => ben_bpl_shd.g_old_rec.cmcd_rld_up_val,
538: p_cmcd_used_val_o => ben_bpl_shd.g_old_rec.cmcd_used_val,
539: p_cmcd_cash_recd_val_o => ben_bpl_shd.g_old_rec.cmcd_cash_recd_val,
540: p_cmcd_ref_perd_cd_o => ben_bpl_shd.g_old_rec.cmcd_ref_perd_cd,
541: p_ann_frftd_val_o => ben_bpl_shd.g_old_rec.ann_frftd_val,
542: p_ann_prvdd_val_o => ben_bpl_shd.g_old_rec.ann_prvdd_val,
543: p_ann_rld_up_val_o => ben_bpl_shd.g_old_rec.ann_rld_up_val,
544: p_ann_used_val_o => ben_bpl_shd.g_old_rec.ann_used_val,
545: p_ann_cash_recd_val_o => ben_bpl_shd.g_old_rec.ann_cash_recd_val
538: p_cmcd_used_val_o => ben_bpl_shd.g_old_rec.cmcd_used_val,
539: p_cmcd_cash_recd_val_o => ben_bpl_shd.g_old_rec.cmcd_cash_recd_val,
540: p_cmcd_ref_perd_cd_o => ben_bpl_shd.g_old_rec.cmcd_ref_perd_cd,
541: p_ann_frftd_val_o => ben_bpl_shd.g_old_rec.ann_frftd_val,
542: p_ann_prvdd_val_o => ben_bpl_shd.g_old_rec.ann_prvdd_val,
543: p_ann_rld_up_val_o => ben_bpl_shd.g_old_rec.ann_rld_up_val,
544: p_ann_used_val_o => ben_bpl_shd.g_old_rec.ann_used_val,
545: p_ann_cash_recd_val_o => ben_bpl_shd.g_old_rec.ann_cash_recd_val
546: );
539: p_cmcd_cash_recd_val_o => ben_bpl_shd.g_old_rec.cmcd_cash_recd_val,
540: p_cmcd_ref_perd_cd_o => ben_bpl_shd.g_old_rec.cmcd_ref_perd_cd,
541: p_ann_frftd_val_o => ben_bpl_shd.g_old_rec.ann_frftd_val,
542: p_ann_prvdd_val_o => ben_bpl_shd.g_old_rec.ann_prvdd_val,
543: p_ann_rld_up_val_o => ben_bpl_shd.g_old_rec.ann_rld_up_val,
544: p_ann_used_val_o => ben_bpl_shd.g_old_rec.ann_used_val,
545: p_ann_cash_recd_val_o => ben_bpl_shd.g_old_rec.ann_cash_recd_val
546: );
547: --
540: p_cmcd_ref_perd_cd_o => ben_bpl_shd.g_old_rec.cmcd_ref_perd_cd,
541: p_ann_frftd_val_o => ben_bpl_shd.g_old_rec.ann_frftd_val,
542: p_ann_prvdd_val_o => ben_bpl_shd.g_old_rec.ann_prvdd_val,
543: p_ann_rld_up_val_o => ben_bpl_shd.g_old_rec.ann_rld_up_val,
544: p_ann_used_val_o => ben_bpl_shd.g_old_rec.ann_used_val,
545: p_ann_cash_recd_val_o => ben_bpl_shd.g_old_rec.ann_cash_recd_val
546: );
547: --
548: exception
541: p_ann_frftd_val_o => ben_bpl_shd.g_old_rec.ann_frftd_val,
542: p_ann_prvdd_val_o => ben_bpl_shd.g_old_rec.ann_prvdd_val,
543: p_ann_rld_up_val_o => ben_bpl_shd.g_old_rec.ann_rld_up_val,
544: p_ann_used_val_o => ben_bpl_shd.g_old_rec.ann_used_val,
545: p_ann_cash_recd_val_o => ben_bpl_shd.g_old_rec.ann_cash_recd_val
546: );
547: --
548: exception
549: --
603: -- Internal Row Handler Use Only.
604: --
605: -- {End Of Comments}
606: -- ----------------------------------------------------------------------------
607: Procedure convert_defs(p_rec in out nocopy ben_bpl_shd.g_rec_type) is
608: --
609: l_proc varchar2(72) := g_package||'convert_defs';
610: --
611: Begin
618: -- is being used then we must set to the 'current' argument value.
619: --
620: If (p_rec.prtt_ro_of_unusd_amt_flag = hr_api.g_varchar2) then
621: p_rec.prtt_ro_of_unusd_amt_flag :=
622: ben_bpl_shd.g_old_rec.prtt_ro_of_unusd_amt_flag;
623: End If;
624: If (p_rec.frftd_val = hr_api.g_number) then
625: p_rec.frftd_val :=
626: ben_bpl_shd.g_old_rec.frftd_val;
622: ben_bpl_shd.g_old_rec.prtt_ro_of_unusd_amt_flag;
623: End If;
624: If (p_rec.frftd_val = hr_api.g_number) then
625: p_rec.frftd_val :=
626: ben_bpl_shd.g_old_rec.frftd_val;
627: End If;
628: If (p_rec.prvdd_val = hr_api.g_number) then
629: p_rec.prvdd_val :=
630: ben_bpl_shd.g_old_rec.prvdd_val;
626: ben_bpl_shd.g_old_rec.frftd_val;
627: End If;
628: If (p_rec.prvdd_val = hr_api.g_number) then
629: p_rec.prvdd_val :=
630: ben_bpl_shd.g_old_rec.prvdd_val;
631: End If;
632: If (p_rec.used_val = hr_api.g_number) then
633: p_rec.used_val :=
634: ben_bpl_shd.g_old_rec.used_val;
630: ben_bpl_shd.g_old_rec.prvdd_val;
631: End If;
632: If (p_rec.used_val = hr_api.g_number) then
633: p_rec.used_val :=
634: ben_bpl_shd.g_old_rec.used_val;
635: End If;
636: If (p_rec.bnft_prvdr_pool_id = hr_api.g_number) then
637: p_rec.bnft_prvdr_pool_id :=
638: ben_bpl_shd.g_old_rec.bnft_prvdr_pool_id;
634: ben_bpl_shd.g_old_rec.used_val;
635: End If;
636: If (p_rec.bnft_prvdr_pool_id = hr_api.g_number) then
637: p_rec.bnft_prvdr_pool_id :=
638: ben_bpl_shd.g_old_rec.bnft_prvdr_pool_id;
639: End If;
640: If (p_rec.acty_base_rt_id = hr_api.g_number) then
641: p_rec.acty_base_rt_id :=
642: ben_bpl_shd.g_old_rec.acty_base_rt_id;
638: ben_bpl_shd.g_old_rec.bnft_prvdr_pool_id;
639: End If;
640: If (p_rec.acty_base_rt_id = hr_api.g_number) then
641: p_rec.acty_base_rt_id :=
642: ben_bpl_shd.g_old_rec.acty_base_rt_id;
643: End If;
644: If (p_rec.per_in_ler_id = hr_api.g_number) then
645: p_rec.per_in_ler_id :=
646: ben_bpl_shd.g_old_rec.per_in_ler_id;
642: ben_bpl_shd.g_old_rec.acty_base_rt_id;
643: End If;
644: If (p_rec.per_in_ler_id = hr_api.g_number) then
645: p_rec.per_in_ler_id :=
646: ben_bpl_shd.g_old_rec.per_in_ler_id;
647: End If;
648: If (p_rec.prtt_enrt_rslt_id = hr_api.g_number) then
649: p_rec.prtt_enrt_rslt_id :=
650: ben_bpl_shd.g_old_rec.prtt_enrt_rslt_id;
646: ben_bpl_shd.g_old_rec.per_in_ler_id;
647: End If;
648: If (p_rec.prtt_enrt_rslt_id = hr_api.g_number) then
649: p_rec.prtt_enrt_rslt_id :=
650: ben_bpl_shd.g_old_rec.prtt_enrt_rslt_id;
651: End If;
652: If (p_rec.business_group_id = hr_api.g_number) then
653: p_rec.business_group_id :=
654: ben_bpl_shd.g_old_rec.business_group_id;
650: ben_bpl_shd.g_old_rec.prtt_enrt_rslt_id;
651: End If;
652: If (p_rec.business_group_id = hr_api.g_number) then
653: p_rec.business_group_id :=
654: ben_bpl_shd.g_old_rec.business_group_id;
655: End If;
656: If (p_rec.bpl_attribute_category = hr_api.g_varchar2) then
657: p_rec.bpl_attribute_category :=
658: ben_bpl_shd.g_old_rec.bpl_attribute_category;
654: ben_bpl_shd.g_old_rec.business_group_id;
655: End If;
656: If (p_rec.bpl_attribute_category = hr_api.g_varchar2) then
657: p_rec.bpl_attribute_category :=
658: ben_bpl_shd.g_old_rec.bpl_attribute_category;
659: End If;
660: If (p_rec.bpl_attribute1 = hr_api.g_varchar2) then
661: p_rec.bpl_attribute1 :=
662: ben_bpl_shd.g_old_rec.bpl_attribute1;
658: ben_bpl_shd.g_old_rec.bpl_attribute_category;
659: End If;
660: If (p_rec.bpl_attribute1 = hr_api.g_varchar2) then
661: p_rec.bpl_attribute1 :=
662: ben_bpl_shd.g_old_rec.bpl_attribute1;
663: End If;
664: If (p_rec.bpl_attribute2 = hr_api.g_varchar2) then
665: p_rec.bpl_attribute2 :=
666: ben_bpl_shd.g_old_rec.bpl_attribute2;
662: ben_bpl_shd.g_old_rec.bpl_attribute1;
663: End If;
664: If (p_rec.bpl_attribute2 = hr_api.g_varchar2) then
665: p_rec.bpl_attribute2 :=
666: ben_bpl_shd.g_old_rec.bpl_attribute2;
667: End If;
668: If (p_rec.bpl_attribute3 = hr_api.g_varchar2) then
669: p_rec.bpl_attribute3 :=
670: ben_bpl_shd.g_old_rec.bpl_attribute3;
666: ben_bpl_shd.g_old_rec.bpl_attribute2;
667: End If;
668: If (p_rec.bpl_attribute3 = hr_api.g_varchar2) then
669: p_rec.bpl_attribute3 :=
670: ben_bpl_shd.g_old_rec.bpl_attribute3;
671: End If;
672: If (p_rec.bpl_attribute4 = hr_api.g_varchar2) then
673: p_rec.bpl_attribute4 :=
674: ben_bpl_shd.g_old_rec.bpl_attribute4;
670: ben_bpl_shd.g_old_rec.bpl_attribute3;
671: End If;
672: If (p_rec.bpl_attribute4 = hr_api.g_varchar2) then
673: p_rec.bpl_attribute4 :=
674: ben_bpl_shd.g_old_rec.bpl_attribute4;
675: End If;
676: If (p_rec.bpl_attribute5 = hr_api.g_varchar2) then
677: p_rec.bpl_attribute5 :=
678: ben_bpl_shd.g_old_rec.bpl_attribute5;
674: ben_bpl_shd.g_old_rec.bpl_attribute4;
675: End If;
676: If (p_rec.bpl_attribute5 = hr_api.g_varchar2) then
677: p_rec.bpl_attribute5 :=
678: ben_bpl_shd.g_old_rec.bpl_attribute5;
679: End If;
680: If (p_rec.bpl_attribute6 = hr_api.g_varchar2) then
681: p_rec.bpl_attribute6 :=
682: ben_bpl_shd.g_old_rec.bpl_attribute6;
678: ben_bpl_shd.g_old_rec.bpl_attribute5;
679: End If;
680: If (p_rec.bpl_attribute6 = hr_api.g_varchar2) then
681: p_rec.bpl_attribute6 :=
682: ben_bpl_shd.g_old_rec.bpl_attribute6;
683: End If;
684: If (p_rec.bpl_attribute7 = hr_api.g_varchar2) then
685: p_rec.bpl_attribute7 :=
686: ben_bpl_shd.g_old_rec.bpl_attribute7;
682: ben_bpl_shd.g_old_rec.bpl_attribute6;
683: End If;
684: If (p_rec.bpl_attribute7 = hr_api.g_varchar2) then
685: p_rec.bpl_attribute7 :=
686: ben_bpl_shd.g_old_rec.bpl_attribute7;
687: End If;
688: If (p_rec.bpl_attribute8 = hr_api.g_varchar2) then
689: p_rec.bpl_attribute8 :=
690: ben_bpl_shd.g_old_rec.bpl_attribute8;
686: ben_bpl_shd.g_old_rec.bpl_attribute7;
687: End If;
688: If (p_rec.bpl_attribute8 = hr_api.g_varchar2) then
689: p_rec.bpl_attribute8 :=
690: ben_bpl_shd.g_old_rec.bpl_attribute8;
691: End If;
692: If (p_rec.bpl_attribute9 = hr_api.g_varchar2) then
693: p_rec.bpl_attribute9 :=
694: ben_bpl_shd.g_old_rec.bpl_attribute9;
690: ben_bpl_shd.g_old_rec.bpl_attribute8;
691: End If;
692: If (p_rec.bpl_attribute9 = hr_api.g_varchar2) then
693: p_rec.bpl_attribute9 :=
694: ben_bpl_shd.g_old_rec.bpl_attribute9;
695: End If;
696: If (p_rec.bpl_attribute10 = hr_api.g_varchar2) then
697: p_rec.bpl_attribute10 :=
698: ben_bpl_shd.g_old_rec.bpl_attribute10;
694: ben_bpl_shd.g_old_rec.bpl_attribute9;
695: End If;
696: If (p_rec.bpl_attribute10 = hr_api.g_varchar2) then
697: p_rec.bpl_attribute10 :=
698: ben_bpl_shd.g_old_rec.bpl_attribute10;
699: End If;
700: If (p_rec.bpl_attribute11 = hr_api.g_varchar2) then
701: p_rec.bpl_attribute11 :=
702: ben_bpl_shd.g_old_rec.bpl_attribute11;
698: ben_bpl_shd.g_old_rec.bpl_attribute10;
699: End If;
700: If (p_rec.bpl_attribute11 = hr_api.g_varchar2) then
701: p_rec.bpl_attribute11 :=
702: ben_bpl_shd.g_old_rec.bpl_attribute11;
703: End If;
704: If (p_rec.bpl_attribute12 = hr_api.g_varchar2) then
705: p_rec.bpl_attribute12 :=
706: ben_bpl_shd.g_old_rec.bpl_attribute12;
702: ben_bpl_shd.g_old_rec.bpl_attribute11;
703: End If;
704: If (p_rec.bpl_attribute12 = hr_api.g_varchar2) then
705: p_rec.bpl_attribute12 :=
706: ben_bpl_shd.g_old_rec.bpl_attribute12;
707: End If;
708: If (p_rec.bpl_attribute13 = hr_api.g_varchar2) then
709: p_rec.bpl_attribute13 :=
710: ben_bpl_shd.g_old_rec.bpl_attribute13;
706: ben_bpl_shd.g_old_rec.bpl_attribute12;
707: End If;
708: If (p_rec.bpl_attribute13 = hr_api.g_varchar2) then
709: p_rec.bpl_attribute13 :=
710: ben_bpl_shd.g_old_rec.bpl_attribute13;
711: End If;
712: If (p_rec.bpl_attribute14 = hr_api.g_varchar2) then
713: p_rec.bpl_attribute14 :=
714: ben_bpl_shd.g_old_rec.bpl_attribute14;
710: ben_bpl_shd.g_old_rec.bpl_attribute13;
711: End If;
712: If (p_rec.bpl_attribute14 = hr_api.g_varchar2) then
713: p_rec.bpl_attribute14 :=
714: ben_bpl_shd.g_old_rec.bpl_attribute14;
715: End If;
716: If (p_rec.bpl_attribute15 = hr_api.g_varchar2) then
717: p_rec.bpl_attribute15 :=
718: ben_bpl_shd.g_old_rec.bpl_attribute15;
714: ben_bpl_shd.g_old_rec.bpl_attribute14;
715: End If;
716: If (p_rec.bpl_attribute15 = hr_api.g_varchar2) then
717: p_rec.bpl_attribute15 :=
718: ben_bpl_shd.g_old_rec.bpl_attribute15;
719: End If;
720: If (p_rec.bpl_attribute16 = hr_api.g_varchar2) then
721: p_rec.bpl_attribute16 :=
722: ben_bpl_shd.g_old_rec.bpl_attribute16;
718: ben_bpl_shd.g_old_rec.bpl_attribute15;
719: End If;
720: If (p_rec.bpl_attribute16 = hr_api.g_varchar2) then
721: p_rec.bpl_attribute16 :=
722: ben_bpl_shd.g_old_rec.bpl_attribute16;
723: End If;
724: If (p_rec.bpl_attribute17 = hr_api.g_varchar2) then
725: p_rec.bpl_attribute17 :=
726: ben_bpl_shd.g_old_rec.bpl_attribute17;
722: ben_bpl_shd.g_old_rec.bpl_attribute16;
723: End If;
724: If (p_rec.bpl_attribute17 = hr_api.g_varchar2) then
725: p_rec.bpl_attribute17 :=
726: ben_bpl_shd.g_old_rec.bpl_attribute17;
727: End If;
728: If (p_rec.bpl_attribute18 = hr_api.g_varchar2) then
729: p_rec.bpl_attribute18 :=
730: ben_bpl_shd.g_old_rec.bpl_attribute18;
726: ben_bpl_shd.g_old_rec.bpl_attribute17;
727: End If;
728: If (p_rec.bpl_attribute18 = hr_api.g_varchar2) then
729: p_rec.bpl_attribute18 :=
730: ben_bpl_shd.g_old_rec.bpl_attribute18;
731: End If;
732: If (p_rec.bpl_attribute19 = hr_api.g_varchar2) then
733: p_rec.bpl_attribute19 :=
734: ben_bpl_shd.g_old_rec.bpl_attribute19;
730: ben_bpl_shd.g_old_rec.bpl_attribute18;
731: End If;
732: If (p_rec.bpl_attribute19 = hr_api.g_varchar2) then
733: p_rec.bpl_attribute19 :=
734: ben_bpl_shd.g_old_rec.bpl_attribute19;
735: End If;
736: If (p_rec.bpl_attribute20 = hr_api.g_varchar2) then
737: p_rec.bpl_attribute20 :=
738: ben_bpl_shd.g_old_rec.bpl_attribute20;
734: ben_bpl_shd.g_old_rec.bpl_attribute19;
735: End If;
736: If (p_rec.bpl_attribute20 = hr_api.g_varchar2) then
737: p_rec.bpl_attribute20 :=
738: ben_bpl_shd.g_old_rec.bpl_attribute20;
739: End If;
740: If (p_rec.bpl_attribute21 = hr_api.g_varchar2) then
741: p_rec.bpl_attribute21 :=
742: ben_bpl_shd.g_old_rec.bpl_attribute21;
738: ben_bpl_shd.g_old_rec.bpl_attribute20;
739: End If;
740: If (p_rec.bpl_attribute21 = hr_api.g_varchar2) then
741: p_rec.bpl_attribute21 :=
742: ben_bpl_shd.g_old_rec.bpl_attribute21;
743: End If;
744: If (p_rec.bpl_attribute22 = hr_api.g_varchar2) then
745: p_rec.bpl_attribute22 :=
746: ben_bpl_shd.g_old_rec.bpl_attribute22;
742: ben_bpl_shd.g_old_rec.bpl_attribute21;
743: End If;
744: If (p_rec.bpl_attribute22 = hr_api.g_varchar2) then
745: p_rec.bpl_attribute22 :=
746: ben_bpl_shd.g_old_rec.bpl_attribute22;
747: End If;
748: If (p_rec.bpl_attribute23 = hr_api.g_varchar2) then
749: p_rec.bpl_attribute23 :=
750: ben_bpl_shd.g_old_rec.bpl_attribute23;
746: ben_bpl_shd.g_old_rec.bpl_attribute22;
747: End If;
748: If (p_rec.bpl_attribute23 = hr_api.g_varchar2) then
749: p_rec.bpl_attribute23 :=
750: ben_bpl_shd.g_old_rec.bpl_attribute23;
751: End If;
752: If (p_rec.bpl_attribute24 = hr_api.g_varchar2) then
753: p_rec.bpl_attribute24 :=
754: ben_bpl_shd.g_old_rec.bpl_attribute24;
750: ben_bpl_shd.g_old_rec.bpl_attribute23;
751: End If;
752: If (p_rec.bpl_attribute24 = hr_api.g_varchar2) then
753: p_rec.bpl_attribute24 :=
754: ben_bpl_shd.g_old_rec.bpl_attribute24;
755: End If;
756: If (p_rec.bpl_attribute25 = hr_api.g_varchar2) then
757: p_rec.bpl_attribute25 :=
758: ben_bpl_shd.g_old_rec.bpl_attribute25;
754: ben_bpl_shd.g_old_rec.bpl_attribute24;
755: End If;
756: If (p_rec.bpl_attribute25 = hr_api.g_varchar2) then
757: p_rec.bpl_attribute25 :=
758: ben_bpl_shd.g_old_rec.bpl_attribute25;
759: End If;
760: If (p_rec.bpl_attribute26 = hr_api.g_varchar2) then
761: p_rec.bpl_attribute26 :=
762: ben_bpl_shd.g_old_rec.bpl_attribute26;
758: ben_bpl_shd.g_old_rec.bpl_attribute25;
759: End If;
760: If (p_rec.bpl_attribute26 = hr_api.g_varchar2) then
761: p_rec.bpl_attribute26 :=
762: ben_bpl_shd.g_old_rec.bpl_attribute26;
763: End If;
764: If (p_rec.bpl_attribute27 = hr_api.g_varchar2) then
765: p_rec.bpl_attribute27 :=
766: ben_bpl_shd.g_old_rec.bpl_attribute27;
762: ben_bpl_shd.g_old_rec.bpl_attribute26;
763: End If;
764: If (p_rec.bpl_attribute27 = hr_api.g_varchar2) then
765: p_rec.bpl_attribute27 :=
766: ben_bpl_shd.g_old_rec.bpl_attribute27;
767: End If;
768: If (p_rec.bpl_attribute28 = hr_api.g_varchar2) then
769: p_rec.bpl_attribute28 :=
770: ben_bpl_shd.g_old_rec.bpl_attribute28;
766: ben_bpl_shd.g_old_rec.bpl_attribute27;
767: End If;
768: If (p_rec.bpl_attribute28 = hr_api.g_varchar2) then
769: p_rec.bpl_attribute28 :=
770: ben_bpl_shd.g_old_rec.bpl_attribute28;
771: End If;
772: If (p_rec.bpl_attribute29 = hr_api.g_varchar2) then
773: p_rec.bpl_attribute29 :=
774: ben_bpl_shd.g_old_rec.bpl_attribute29;
770: ben_bpl_shd.g_old_rec.bpl_attribute28;
771: End If;
772: If (p_rec.bpl_attribute29 = hr_api.g_varchar2) then
773: p_rec.bpl_attribute29 :=
774: ben_bpl_shd.g_old_rec.bpl_attribute29;
775: End If;
776: If (p_rec.bpl_attribute30 = hr_api.g_varchar2) then
777: p_rec.bpl_attribute30 :=
778: ben_bpl_shd.g_old_rec.bpl_attribute30;
774: ben_bpl_shd.g_old_rec.bpl_attribute29;
775: End If;
776: If (p_rec.bpl_attribute30 = hr_api.g_varchar2) then
777: p_rec.bpl_attribute30 :=
778: ben_bpl_shd.g_old_rec.bpl_attribute30;
779: End If;
780: If (p_rec.cash_recd_val = hr_api.g_number) then
781: p_rec.cash_recd_val :=
782: ben_bpl_shd.g_old_rec.cash_recd_val;
778: ben_bpl_shd.g_old_rec.bpl_attribute30;
779: End If;
780: If (p_rec.cash_recd_val = hr_api.g_number) then
781: p_rec.cash_recd_val :=
782: ben_bpl_shd.g_old_rec.cash_recd_val;
783: End If;
784: If (p_rec.rld_up_val = hr_api.g_number) then
785: p_rec.rld_up_val :=
786: ben_bpl_shd.g_old_rec.rld_up_val;
782: ben_bpl_shd.g_old_rec.cash_recd_val;
783: End If;
784: If (p_rec.rld_up_val = hr_api.g_number) then
785: p_rec.rld_up_val :=
786: ben_bpl_shd.g_old_rec.rld_up_val;
787: End If;
788:
789:
790: If (p_rec.acty_ref_perd_cd = hr_api.g_varchar2) then
788:
789:
790: If (p_rec.acty_ref_perd_cd = hr_api.g_varchar2) then
791: p_rec.acty_ref_perd_cd :=
792: ben_bpl_shd.g_old_rec.acty_ref_perd_cd;
793: End If;
794: If (p_rec.cmcd_frftd_val = hr_api.g_number) then
795: p_rec.cmcd_frftd_val :=
796: ben_bpl_shd.g_old_rec.cmcd_frftd_val;
792: ben_bpl_shd.g_old_rec.acty_ref_perd_cd;
793: End If;
794: If (p_rec.cmcd_frftd_val = hr_api.g_number) then
795: p_rec.cmcd_frftd_val :=
796: ben_bpl_shd.g_old_rec.cmcd_frftd_val;
797: End If;
798: If (p_rec.cmcd_prvdd_val = hr_api.g_number) then
799: p_rec.cmcd_prvdd_val :=
800: ben_bpl_shd.g_old_rec.cmcd_prvdd_val;
796: ben_bpl_shd.g_old_rec.cmcd_frftd_val;
797: End If;
798: If (p_rec.cmcd_prvdd_val = hr_api.g_number) then
799: p_rec.cmcd_prvdd_val :=
800: ben_bpl_shd.g_old_rec.cmcd_prvdd_val;
801: End If;
802: If (p_rec.cmcd_rld_up_val = hr_api.g_number) then
803: p_rec.cmcd_rld_up_val :=
804: ben_bpl_shd.g_old_rec.cmcd_rld_up_val;
800: ben_bpl_shd.g_old_rec.cmcd_prvdd_val;
801: End If;
802: If (p_rec.cmcd_rld_up_val = hr_api.g_number) then
803: p_rec.cmcd_rld_up_val :=
804: ben_bpl_shd.g_old_rec.cmcd_rld_up_val;
805: End If;
806: If (p_rec.cmcd_used_val = hr_api.g_number) then
807: p_rec.cmcd_used_val :=
808: ben_bpl_shd.g_old_rec.cmcd_used_val;
804: ben_bpl_shd.g_old_rec.cmcd_rld_up_val;
805: End If;
806: If (p_rec.cmcd_used_val = hr_api.g_number) then
807: p_rec.cmcd_used_val :=
808: ben_bpl_shd.g_old_rec.cmcd_used_val;
809: End If;
810: If (p_rec.cmcd_cash_recd_val = hr_api.g_number) then
811: p_rec.cmcd_cash_recd_val :=
812: ben_bpl_shd.g_old_rec.cmcd_cash_recd_val;
808: ben_bpl_shd.g_old_rec.cmcd_used_val;
809: End If;
810: If (p_rec.cmcd_cash_recd_val = hr_api.g_number) then
811: p_rec.cmcd_cash_recd_val :=
812: ben_bpl_shd.g_old_rec.cmcd_cash_recd_val;
813: End If;
814: If (p_rec.cmcd_ref_perd_cd = hr_api.g_varchar2) then
815: p_rec.cmcd_ref_perd_cd :=
816: ben_bpl_shd.g_old_rec.cmcd_ref_perd_cd;
812: ben_bpl_shd.g_old_rec.cmcd_cash_recd_val;
813: End If;
814: If (p_rec.cmcd_ref_perd_cd = hr_api.g_varchar2) then
815: p_rec.cmcd_ref_perd_cd :=
816: ben_bpl_shd.g_old_rec.cmcd_ref_perd_cd;
817: End If;
818:
819: If (p_rec.ann_frftd_val = hr_api.g_number) then
820: p_rec.ann_frftd_val :=
817: End If;
818:
819: If (p_rec.ann_frftd_val = hr_api.g_number) then
820: p_rec.ann_frftd_val :=
821: ben_bpl_shd.g_old_rec.ann_frftd_val;
822: End If;
823: If (p_rec.ann_prvdd_val = hr_api.g_number) then
824: p_rec.ann_prvdd_val :=
825: ben_bpl_shd.g_old_rec.ann_prvdd_val;
821: ben_bpl_shd.g_old_rec.ann_frftd_val;
822: End If;
823: If (p_rec.ann_prvdd_val = hr_api.g_number) then
824: p_rec.ann_prvdd_val :=
825: ben_bpl_shd.g_old_rec.ann_prvdd_val;
826: End If;
827: If (p_rec.ann_rld_up_val = hr_api.g_number) then
828: p_rec.ann_rld_up_val :=
829: ben_bpl_shd.g_old_rec.ann_rld_up_val;
825: ben_bpl_shd.g_old_rec.ann_prvdd_val;
826: End If;
827: If (p_rec.ann_rld_up_val = hr_api.g_number) then
828: p_rec.ann_rld_up_val :=
829: ben_bpl_shd.g_old_rec.ann_rld_up_val;
830: End If;
831: If (p_rec.ann_used_val = hr_api.g_number) then
832: p_rec.ann_used_val :=
833: ben_bpl_shd.g_old_rec.ann_used_val;
829: ben_bpl_shd.g_old_rec.ann_rld_up_val;
830: End If;
831: If (p_rec.ann_used_val = hr_api.g_number) then
832: p_rec.ann_used_val :=
833: ben_bpl_shd.g_old_rec.ann_used_val;
834: End If;
835: If (p_rec.ann_cash_recd_val = hr_api.g_number) then
836: p_rec.ann_cash_recd_val :=
837: ben_bpl_shd.g_old_rec.ann_cash_recd_val;
833: ben_bpl_shd.g_old_rec.ann_used_val;
834: End If;
835: If (p_rec.ann_cash_recd_val = hr_api.g_number) then
836: p_rec.ann_cash_recd_val :=
837: ben_bpl_shd.g_old_rec.ann_cash_recd_val;
838: End If;
839:
840:
841: --
847: -- |---------------------------------< upd >----------------------------------|
848: -- ----------------------------------------------------------------------------
849: Procedure upd
850: (
851: p_rec in out nocopy ben_bpl_shd.g_rec_type,
852: p_effective_date in date,
853: p_datetrack_mode in varchar2
854: ) is
855: --
865: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
866: --
867: -- We must lock the row which we need to update.
868: --
869: ben_bpl_shd.lck
870: (p_effective_date => p_effective_date,
871: p_datetrack_mode => p_datetrack_mode,
872: p_bnft_prvdd_ldgr_id => p_rec.bnft_prvdd_ldgr_id,
873: p_object_version_number => p_rec.object_version_number,
982: p_ann_cash_recd_val in number default hr_api.g_number,
983: p_object_version_number in out nocopy number
984: ) is
985: --
986: l_rec ben_bpl_shd.g_rec_type;
987: l_proc varchar2(72) := g_package||'upd';
988: --
989: Begin
990: hr_utility.set_location('Entering:'||l_proc, 5);
992: -- Call conversion function to turn arguments into the
993: -- l_rec structure.
994: --
995: l_rec :=
996: ben_bpl_shd.convert_args
997: (
998: p_bnft_prvdd_ldgr_id,
999: null,
1000: null,