50: --
51: -- {End Of Comments}
52: -- ----------------------------------------------------------------------------
53: Procedure dt_delete_dml
54: (p_rec in out nocopy ben_bpl_shd.g_rec_type,
55: p_effective_date in date,
56: p_datetrack_mode in varchar2,
57: p_validation_start_date in date,
58: p_validation_end_date in date) is
62: Begin
63: hr_utility.set_location('Entering:'||l_proc, 5);
64: If (p_datetrack_mode = 'DELETE_NEXT_CHANGE') then
65: hr_utility.set_location(l_proc, 10);
66: ben_bpl_shd.g_api_dml := true; -- Set the api dml status
67: --
68: -- Delete the where the effective start date is equal
69: -- to the validation end date.
70: --
71: delete from ben_bnft_prvdd_ldgr_f
72: where bnft_prvdd_ldgr_id = p_rec.bnft_prvdd_ldgr_id
73: and effective_start_date = p_validation_start_date;
74: --
75: ben_bpl_shd.g_api_dml := false; -- Unset the api dml status
76: Else
77: hr_utility.set_location(l_proc, 15);
78: ben_bpl_shd.g_api_dml := true; -- Set the api dml status
79: --
74: --
75: ben_bpl_shd.g_api_dml := false; -- Unset the api dml status
76: Else
77: hr_utility.set_location(l_proc, 15);
78: ben_bpl_shd.g_api_dml := true; -- Set the api dml status
79: --
80: -- Delete the row(s) where the effective start date is greater than
81: -- or equal to the validation start date.
82: --
83: delete from ben_bnft_prvdd_ldgr_f
84: where bnft_prvdd_ldgr_id = p_rec.bnft_prvdd_ldgr_id
85: and effective_start_date >= p_validation_start_date;
86: --
87: ben_bpl_shd.g_api_dml := false; -- Unset the api dml status
88: End If;
89: --
90: hr_utility.set_location(' Leaving:'||l_proc, 20);
91: --
90: hr_utility.set_location(' Leaving:'||l_proc, 20);
91: --
92: Exception
93: When Others Then
94: ben_bpl_shd.g_api_dml := false; -- Unset the api dml status
95: Raise;
96: End dt_delete_dml;
97: --
98: -- ----------------------------------------------------------------------------
98: -- ----------------------------------------------------------------------------
99: -- |------------------------------< delete_dml >------------------------------|
100: -- ----------------------------------------------------------------------------
101: Procedure delete_dml
102: (p_rec in out nocopy ben_bpl_shd.g_rec_type,
103: p_effective_date in date,
104: p_datetrack_mode in varchar2,
105: p_validation_start_date in date,
106: p_validation_end_date in date) is
152: --
153: -- {End Of Comments}
154: -- ----------------------------------------------------------------------------
155: Procedure dt_pre_delete
156: (p_rec in out nocopy ben_bpl_shd.g_rec_type,
157: p_effective_date in date,
158: p_datetrack_mode in varchar2,
159: p_validation_start_date in date,
160: p_validation_end_date in date) is
165: hr_utility.set_location('Entering:'||l_proc, 5);
166: --
167: If (p_datetrack_mode <> 'ZAP') then
168: --
169: p_rec.effective_start_date := ben_bpl_shd.g_old_rec.effective_start_date;
170: --
171: If (p_datetrack_mode = 'DELETE') then
172: p_rec.effective_end_date := p_validation_start_date - 1;
173: Else
175: End If;
176: --
177: -- Update the current effective end date record
178: --
179: ben_bpl_shd.upd_effective_end_date
180: (p_effective_date => p_effective_date,
181: p_base_key_value => p_rec.bnft_prvdd_ldgr_id,
182: p_new_effective_end_date => p_rec.effective_end_date,
183: p_validation_start_date => p_validation_start_date,
223: --
224: -- {End Of Comments}
225: -- ----------------------------------------------------------------------------
226: Procedure pre_delete
227: (p_rec in out nocopy ben_bpl_shd.g_rec_type,
228: p_effective_date in date,
229: p_datetrack_mode in varchar2,
230: p_validation_start_date in date,
231: p_validation_end_date in date) is
289: --
290: -- {End Of Comments}
291: -- ----------------------------------------------------------------------------
292: Procedure post_delete
293: (p_rec in ben_bpl_shd.g_rec_type,
294: p_effective_date in date,
295: p_datetrack_mode in varchar2,
296: p_validation_start_date in date,
297: p_validation_end_date in date) is
303: IS
304: SELECT pil_new.per_in_ler_id
305: FROM ben_per_in_ler pil_old, ben_per_in_ler pil_new
306: WHERE pil_old.person_id = pil_new.person_id
307: AND pil_old.per_in_ler_id = ben_bpl_shd.g_old_rec.per_in_ler_id
308: AND pil_new.per_in_ler_stat_cd in ('STRTD','PROCD') -- Bug 7380983
309: ORDER BY pil_new.lf_evt_ocrd_dt desc; -- Bug 7380983
310:
311: --
337: (
338: p_rec.bnft_prvdd_ldgr_id,
339: 'BEN_BNFT_PRVDD_LDGR_F',
340: l_per_in_ler_id,
341: ben_bpl_shd.g_old_rec.effective_start_date ,
342: ben_bpl_shd.g_old_rec.effective_end_date ,
343: ben_bpl_shd.g_old_rec.object_version_number + 1
344: );
345: --
338: p_rec.bnft_prvdd_ldgr_id,
339: 'BEN_BNFT_PRVDD_LDGR_F',
340: l_per_in_ler_id,
341: ben_bpl_shd.g_old_rec.effective_start_date ,
342: ben_bpl_shd.g_old_rec.effective_end_date ,
343: ben_bpl_shd.g_old_rec.object_version_number + 1
344: );
345: --
346: end if;
339: 'BEN_BNFT_PRVDD_LDGR_F',
340: l_per_in_ler_id,
341: ben_bpl_shd.g_old_rec.effective_start_date ,
342: ben_bpl_shd.g_old_rec.effective_end_date ,
343: ben_bpl_shd.g_old_rec.object_version_number + 1
344: );
345: --
346: end if;
347: --
358: ,p_validation_start_date =>p_validation_start_date
359: ,p_validation_end_date =>p_validation_end_date
360: ,p_effective_start_date =>p_rec.effective_start_date
361: ,p_effective_end_date =>p_rec.effective_end_date
362: ,p_effective_start_date_o =>ben_bpl_shd.g_old_rec.effective_start_date
363: ,p_effective_end_date_o =>ben_bpl_shd.g_old_rec.effective_end_date
364: ,p_prtt_ro_of_unusd_amt_flag_o =>ben_bpl_shd.g_old_rec.prtt_ro_of_unusd_amt_flag
365: ,p_frftd_val_o =>ben_bpl_shd.g_old_rec.frftd_val
366: ,p_prvdd_val_o =>ben_bpl_shd.g_old_rec.prvdd_val
359: ,p_validation_end_date =>p_validation_end_date
360: ,p_effective_start_date =>p_rec.effective_start_date
361: ,p_effective_end_date =>p_rec.effective_end_date
362: ,p_effective_start_date_o =>ben_bpl_shd.g_old_rec.effective_start_date
363: ,p_effective_end_date_o =>ben_bpl_shd.g_old_rec.effective_end_date
364: ,p_prtt_ro_of_unusd_amt_flag_o =>ben_bpl_shd.g_old_rec.prtt_ro_of_unusd_amt_flag
365: ,p_frftd_val_o =>ben_bpl_shd.g_old_rec.frftd_val
366: ,p_prvdd_val_o =>ben_bpl_shd.g_old_rec.prvdd_val
367: ,p_used_val_o =>ben_bpl_shd.g_old_rec.used_val
360: ,p_effective_start_date =>p_rec.effective_start_date
361: ,p_effective_end_date =>p_rec.effective_end_date
362: ,p_effective_start_date_o =>ben_bpl_shd.g_old_rec.effective_start_date
363: ,p_effective_end_date_o =>ben_bpl_shd.g_old_rec.effective_end_date
364: ,p_prtt_ro_of_unusd_amt_flag_o =>ben_bpl_shd.g_old_rec.prtt_ro_of_unusd_amt_flag
365: ,p_frftd_val_o =>ben_bpl_shd.g_old_rec.frftd_val
366: ,p_prvdd_val_o =>ben_bpl_shd.g_old_rec.prvdd_val
367: ,p_used_val_o =>ben_bpl_shd.g_old_rec.used_val
368: ,p_bnft_prvdr_pool_id_o =>ben_bpl_shd.g_old_rec.bnft_prvdr_pool_id
361: ,p_effective_end_date =>p_rec.effective_end_date
362: ,p_effective_start_date_o =>ben_bpl_shd.g_old_rec.effective_start_date
363: ,p_effective_end_date_o =>ben_bpl_shd.g_old_rec.effective_end_date
364: ,p_prtt_ro_of_unusd_amt_flag_o =>ben_bpl_shd.g_old_rec.prtt_ro_of_unusd_amt_flag
365: ,p_frftd_val_o =>ben_bpl_shd.g_old_rec.frftd_val
366: ,p_prvdd_val_o =>ben_bpl_shd.g_old_rec.prvdd_val
367: ,p_used_val_o =>ben_bpl_shd.g_old_rec.used_val
368: ,p_bnft_prvdr_pool_id_o =>ben_bpl_shd.g_old_rec.bnft_prvdr_pool_id
369: ,p_acty_base_rt_id_o =>ben_bpl_shd.g_old_rec.acty_base_rt_id
362: ,p_effective_start_date_o =>ben_bpl_shd.g_old_rec.effective_start_date
363: ,p_effective_end_date_o =>ben_bpl_shd.g_old_rec.effective_end_date
364: ,p_prtt_ro_of_unusd_amt_flag_o =>ben_bpl_shd.g_old_rec.prtt_ro_of_unusd_amt_flag
365: ,p_frftd_val_o =>ben_bpl_shd.g_old_rec.frftd_val
366: ,p_prvdd_val_o =>ben_bpl_shd.g_old_rec.prvdd_val
367: ,p_used_val_o =>ben_bpl_shd.g_old_rec.used_val
368: ,p_bnft_prvdr_pool_id_o =>ben_bpl_shd.g_old_rec.bnft_prvdr_pool_id
369: ,p_acty_base_rt_id_o =>ben_bpl_shd.g_old_rec.acty_base_rt_id
370: ,p_per_in_ler_id_o =>ben_bpl_shd.g_old_rec.per_in_ler_id
363: ,p_effective_end_date_o =>ben_bpl_shd.g_old_rec.effective_end_date
364: ,p_prtt_ro_of_unusd_amt_flag_o =>ben_bpl_shd.g_old_rec.prtt_ro_of_unusd_amt_flag
365: ,p_frftd_val_o =>ben_bpl_shd.g_old_rec.frftd_val
366: ,p_prvdd_val_o =>ben_bpl_shd.g_old_rec.prvdd_val
367: ,p_used_val_o =>ben_bpl_shd.g_old_rec.used_val
368: ,p_bnft_prvdr_pool_id_o =>ben_bpl_shd.g_old_rec.bnft_prvdr_pool_id
369: ,p_acty_base_rt_id_o =>ben_bpl_shd.g_old_rec.acty_base_rt_id
370: ,p_per_in_ler_id_o =>ben_bpl_shd.g_old_rec.per_in_ler_id
371: ,p_prtt_enrt_rslt_id_o =>ben_bpl_shd.g_old_rec.prtt_enrt_rslt_id
364: ,p_prtt_ro_of_unusd_amt_flag_o =>ben_bpl_shd.g_old_rec.prtt_ro_of_unusd_amt_flag
365: ,p_frftd_val_o =>ben_bpl_shd.g_old_rec.frftd_val
366: ,p_prvdd_val_o =>ben_bpl_shd.g_old_rec.prvdd_val
367: ,p_used_val_o =>ben_bpl_shd.g_old_rec.used_val
368: ,p_bnft_prvdr_pool_id_o =>ben_bpl_shd.g_old_rec.bnft_prvdr_pool_id
369: ,p_acty_base_rt_id_o =>ben_bpl_shd.g_old_rec.acty_base_rt_id
370: ,p_per_in_ler_id_o =>ben_bpl_shd.g_old_rec.per_in_ler_id
371: ,p_prtt_enrt_rslt_id_o =>ben_bpl_shd.g_old_rec.prtt_enrt_rslt_id
372: ,p_business_group_id_o =>ben_bpl_shd.g_old_rec.business_group_id
365: ,p_frftd_val_o =>ben_bpl_shd.g_old_rec.frftd_val
366: ,p_prvdd_val_o =>ben_bpl_shd.g_old_rec.prvdd_val
367: ,p_used_val_o =>ben_bpl_shd.g_old_rec.used_val
368: ,p_bnft_prvdr_pool_id_o =>ben_bpl_shd.g_old_rec.bnft_prvdr_pool_id
369: ,p_acty_base_rt_id_o =>ben_bpl_shd.g_old_rec.acty_base_rt_id
370: ,p_per_in_ler_id_o =>ben_bpl_shd.g_old_rec.per_in_ler_id
371: ,p_prtt_enrt_rslt_id_o =>ben_bpl_shd.g_old_rec.prtt_enrt_rslt_id
372: ,p_business_group_id_o =>ben_bpl_shd.g_old_rec.business_group_id
373: ,p_bpl_attribute_category_o =>ben_bpl_shd.g_old_rec.bpl_attribute_category
366: ,p_prvdd_val_o =>ben_bpl_shd.g_old_rec.prvdd_val
367: ,p_used_val_o =>ben_bpl_shd.g_old_rec.used_val
368: ,p_bnft_prvdr_pool_id_o =>ben_bpl_shd.g_old_rec.bnft_prvdr_pool_id
369: ,p_acty_base_rt_id_o =>ben_bpl_shd.g_old_rec.acty_base_rt_id
370: ,p_per_in_ler_id_o =>ben_bpl_shd.g_old_rec.per_in_ler_id
371: ,p_prtt_enrt_rslt_id_o =>ben_bpl_shd.g_old_rec.prtt_enrt_rslt_id
372: ,p_business_group_id_o =>ben_bpl_shd.g_old_rec.business_group_id
373: ,p_bpl_attribute_category_o =>ben_bpl_shd.g_old_rec.bpl_attribute_category
374: ,p_bpl_attribute1_o =>ben_bpl_shd.g_old_rec.bpl_attribute1
367: ,p_used_val_o =>ben_bpl_shd.g_old_rec.used_val
368: ,p_bnft_prvdr_pool_id_o =>ben_bpl_shd.g_old_rec.bnft_prvdr_pool_id
369: ,p_acty_base_rt_id_o =>ben_bpl_shd.g_old_rec.acty_base_rt_id
370: ,p_per_in_ler_id_o =>ben_bpl_shd.g_old_rec.per_in_ler_id
371: ,p_prtt_enrt_rslt_id_o =>ben_bpl_shd.g_old_rec.prtt_enrt_rslt_id
372: ,p_business_group_id_o =>ben_bpl_shd.g_old_rec.business_group_id
373: ,p_bpl_attribute_category_o =>ben_bpl_shd.g_old_rec.bpl_attribute_category
374: ,p_bpl_attribute1_o =>ben_bpl_shd.g_old_rec.bpl_attribute1
375: ,p_bpl_attribute2_o =>ben_bpl_shd.g_old_rec.bpl_attribute2
368: ,p_bnft_prvdr_pool_id_o =>ben_bpl_shd.g_old_rec.bnft_prvdr_pool_id
369: ,p_acty_base_rt_id_o =>ben_bpl_shd.g_old_rec.acty_base_rt_id
370: ,p_per_in_ler_id_o =>ben_bpl_shd.g_old_rec.per_in_ler_id
371: ,p_prtt_enrt_rslt_id_o =>ben_bpl_shd.g_old_rec.prtt_enrt_rslt_id
372: ,p_business_group_id_o =>ben_bpl_shd.g_old_rec.business_group_id
373: ,p_bpl_attribute_category_o =>ben_bpl_shd.g_old_rec.bpl_attribute_category
374: ,p_bpl_attribute1_o =>ben_bpl_shd.g_old_rec.bpl_attribute1
375: ,p_bpl_attribute2_o =>ben_bpl_shd.g_old_rec.bpl_attribute2
376: ,p_bpl_attribute3_o =>ben_bpl_shd.g_old_rec.bpl_attribute3
369: ,p_acty_base_rt_id_o =>ben_bpl_shd.g_old_rec.acty_base_rt_id
370: ,p_per_in_ler_id_o =>ben_bpl_shd.g_old_rec.per_in_ler_id
371: ,p_prtt_enrt_rslt_id_o =>ben_bpl_shd.g_old_rec.prtt_enrt_rslt_id
372: ,p_business_group_id_o =>ben_bpl_shd.g_old_rec.business_group_id
373: ,p_bpl_attribute_category_o =>ben_bpl_shd.g_old_rec.bpl_attribute_category
374: ,p_bpl_attribute1_o =>ben_bpl_shd.g_old_rec.bpl_attribute1
375: ,p_bpl_attribute2_o =>ben_bpl_shd.g_old_rec.bpl_attribute2
376: ,p_bpl_attribute3_o =>ben_bpl_shd.g_old_rec.bpl_attribute3
377: ,p_bpl_attribute4_o =>ben_bpl_shd.g_old_rec.bpl_attribute4
370: ,p_per_in_ler_id_o =>ben_bpl_shd.g_old_rec.per_in_ler_id
371: ,p_prtt_enrt_rslt_id_o =>ben_bpl_shd.g_old_rec.prtt_enrt_rslt_id
372: ,p_business_group_id_o =>ben_bpl_shd.g_old_rec.business_group_id
373: ,p_bpl_attribute_category_o =>ben_bpl_shd.g_old_rec.bpl_attribute_category
374: ,p_bpl_attribute1_o =>ben_bpl_shd.g_old_rec.bpl_attribute1
375: ,p_bpl_attribute2_o =>ben_bpl_shd.g_old_rec.bpl_attribute2
376: ,p_bpl_attribute3_o =>ben_bpl_shd.g_old_rec.bpl_attribute3
377: ,p_bpl_attribute4_o =>ben_bpl_shd.g_old_rec.bpl_attribute4
378: ,p_bpl_attribute5_o =>ben_bpl_shd.g_old_rec.bpl_attribute5
371: ,p_prtt_enrt_rslt_id_o =>ben_bpl_shd.g_old_rec.prtt_enrt_rslt_id
372: ,p_business_group_id_o =>ben_bpl_shd.g_old_rec.business_group_id
373: ,p_bpl_attribute_category_o =>ben_bpl_shd.g_old_rec.bpl_attribute_category
374: ,p_bpl_attribute1_o =>ben_bpl_shd.g_old_rec.bpl_attribute1
375: ,p_bpl_attribute2_o =>ben_bpl_shd.g_old_rec.bpl_attribute2
376: ,p_bpl_attribute3_o =>ben_bpl_shd.g_old_rec.bpl_attribute3
377: ,p_bpl_attribute4_o =>ben_bpl_shd.g_old_rec.bpl_attribute4
378: ,p_bpl_attribute5_o =>ben_bpl_shd.g_old_rec.bpl_attribute5
379: ,p_bpl_attribute6_o =>ben_bpl_shd.g_old_rec.bpl_attribute6
372: ,p_business_group_id_o =>ben_bpl_shd.g_old_rec.business_group_id
373: ,p_bpl_attribute_category_o =>ben_bpl_shd.g_old_rec.bpl_attribute_category
374: ,p_bpl_attribute1_o =>ben_bpl_shd.g_old_rec.bpl_attribute1
375: ,p_bpl_attribute2_o =>ben_bpl_shd.g_old_rec.bpl_attribute2
376: ,p_bpl_attribute3_o =>ben_bpl_shd.g_old_rec.bpl_attribute3
377: ,p_bpl_attribute4_o =>ben_bpl_shd.g_old_rec.bpl_attribute4
378: ,p_bpl_attribute5_o =>ben_bpl_shd.g_old_rec.bpl_attribute5
379: ,p_bpl_attribute6_o =>ben_bpl_shd.g_old_rec.bpl_attribute6
380: ,p_bpl_attribute7_o =>ben_bpl_shd.g_old_rec.bpl_attribute7
373: ,p_bpl_attribute_category_o =>ben_bpl_shd.g_old_rec.bpl_attribute_category
374: ,p_bpl_attribute1_o =>ben_bpl_shd.g_old_rec.bpl_attribute1
375: ,p_bpl_attribute2_o =>ben_bpl_shd.g_old_rec.bpl_attribute2
376: ,p_bpl_attribute3_o =>ben_bpl_shd.g_old_rec.bpl_attribute3
377: ,p_bpl_attribute4_o =>ben_bpl_shd.g_old_rec.bpl_attribute4
378: ,p_bpl_attribute5_o =>ben_bpl_shd.g_old_rec.bpl_attribute5
379: ,p_bpl_attribute6_o =>ben_bpl_shd.g_old_rec.bpl_attribute6
380: ,p_bpl_attribute7_o =>ben_bpl_shd.g_old_rec.bpl_attribute7
381: ,p_bpl_attribute8_o =>ben_bpl_shd.g_old_rec.bpl_attribute8
374: ,p_bpl_attribute1_o =>ben_bpl_shd.g_old_rec.bpl_attribute1
375: ,p_bpl_attribute2_o =>ben_bpl_shd.g_old_rec.bpl_attribute2
376: ,p_bpl_attribute3_o =>ben_bpl_shd.g_old_rec.bpl_attribute3
377: ,p_bpl_attribute4_o =>ben_bpl_shd.g_old_rec.bpl_attribute4
378: ,p_bpl_attribute5_o =>ben_bpl_shd.g_old_rec.bpl_attribute5
379: ,p_bpl_attribute6_o =>ben_bpl_shd.g_old_rec.bpl_attribute6
380: ,p_bpl_attribute7_o =>ben_bpl_shd.g_old_rec.bpl_attribute7
381: ,p_bpl_attribute8_o =>ben_bpl_shd.g_old_rec.bpl_attribute8
382: ,p_bpl_attribute9_o =>ben_bpl_shd.g_old_rec.bpl_attribute9
375: ,p_bpl_attribute2_o =>ben_bpl_shd.g_old_rec.bpl_attribute2
376: ,p_bpl_attribute3_o =>ben_bpl_shd.g_old_rec.bpl_attribute3
377: ,p_bpl_attribute4_o =>ben_bpl_shd.g_old_rec.bpl_attribute4
378: ,p_bpl_attribute5_o =>ben_bpl_shd.g_old_rec.bpl_attribute5
379: ,p_bpl_attribute6_o =>ben_bpl_shd.g_old_rec.bpl_attribute6
380: ,p_bpl_attribute7_o =>ben_bpl_shd.g_old_rec.bpl_attribute7
381: ,p_bpl_attribute8_o =>ben_bpl_shd.g_old_rec.bpl_attribute8
382: ,p_bpl_attribute9_o =>ben_bpl_shd.g_old_rec.bpl_attribute9
383: ,p_bpl_attribute10_o =>ben_bpl_shd.g_old_rec.bpl_attribute10
376: ,p_bpl_attribute3_o =>ben_bpl_shd.g_old_rec.bpl_attribute3
377: ,p_bpl_attribute4_o =>ben_bpl_shd.g_old_rec.bpl_attribute4
378: ,p_bpl_attribute5_o =>ben_bpl_shd.g_old_rec.bpl_attribute5
379: ,p_bpl_attribute6_o =>ben_bpl_shd.g_old_rec.bpl_attribute6
380: ,p_bpl_attribute7_o =>ben_bpl_shd.g_old_rec.bpl_attribute7
381: ,p_bpl_attribute8_o =>ben_bpl_shd.g_old_rec.bpl_attribute8
382: ,p_bpl_attribute9_o =>ben_bpl_shd.g_old_rec.bpl_attribute9
383: ,p_bpl_attribute10_o =>ben_bpl_shd.g_old_rec.bpl_attribute10
384: ,p_bpl_attribute11_o =>ben_bpl_shd.g_old_rec.bpl_attribute11
377: ,p_bpl_attribute4_o =>ben_bpl_shd.g_old_rec.bpl_attribute4
378: ,p_bpl_attribute5_o =>ben_bpl_shd.g_old_rec.bpl_attribute5
379: ,p_bpl_attribute6_o =>ben_bpl_shd.g_old_rec.bpl_attribute6
380: ,p_bpl_attribute7_o =>ben_bpl_shd.g_old_rec.bpl_attribute7
381: ,p_bpl_attribute8_o =>ben_bpl_shd.g_old_rec.bpl_attribute8
382: ,p_bpl_attribute9_o =>ben_bpl_shd.g_old_rec.bpl_attribute9
383: ,p_bpl_attribute10_o =>ben_bpl_shd.g_old_rec.bpl_attribute10
384: ,p_bpl_attribute11_o =>ben_bpl_shd.g_old_rec.bpl_attribute11
385: ,p_bpl_attribute12_o =>ben_bpl_shd.g_old_rec.bpl_attribute12
378: ,p_bpl_attribute5_o =>ben_bpl_shd.g_old_rec.bpl_attribute5
379: ,p_bpl_attribute6_o =>ben_bpl_shd.g_old_rec.bpl_attribute6
380: ,p_bpl_attribute7_o =>ben_bpl_shd.g_old_rec.bpl_attribute7
381: ,p_bpl_attribute8_o =>ben_bpl_shd.g_old_rec.bpl_attribute8
382: ,p_bpl_attribute9_o =>ben_bpl_shd.g_old_rec.bpl_attribute9
383: ,p_bpl_attribute10_o =>ben_bpl_shd.g_old_rec.bpl_attribute10
384: ,p_bpl_attribute11_o =>ben_bpl_shd.g_old_rec.bpl_attribute11
385: ,p_bpl_attribute12_o =>ben_bpl_shd.g_old_rec.bpl_attribute12
386: ,p_bpl_attribute13_o =>ben_bpl_shd.g_old_rec.bpl_attribute13
379: ,p_bpl_attribute6_o =>ben_bpl_shd.g_old_rec.bpl_attribute6
380: ,p_bpl_attribute7_o =>ben_bpl_shd.g_old_rec.bpl_attribute7
381: ,p_bpl_attribute8_o =>ben_bpl_shd.g_old_rec.bpl_attribute8
382: ,p_bpl_attribute9_o =>ben_bpl_shd.g_old_rec.bpl_attribute9
383: ,p_bpl_attribute10_o =>ben_bpl_shd.g_old_rec.bpl_attribute10
384: ,p_bpl_attribute11_o =>ben_bpl_shd.g_old_rec.bpl_attribute11
385: ,p_bpl_attribute12_o =>ben_bpl_shd.g_old_rec.bpl_attribute12
386: ,p_bpl_attribute13_o =>ben_bpl_shd.g_old_rec.bpl_attribute13
387: ,p_bpl_attribute14_o =>ben_bpl_shd.g_old_rec.bpl_attribute14
380: ,p_bpl_attribute7_o =>ben_bpl_shd.g_old_rec.bpl_attribute7
381: ,p_bpl_attribute8_o =>ben_bpl_shd.g_old_rec.bpl_attribute8
382: ,p_bpl_attribute9_o =>ben_bpl_shd.g_old_rec.bpl_attribute9
383: ,p_bpl_attribute10_o =>ben_bpl_shd.g_old_rec.bpl_attribute10
384: ,p_bpl_attribute11_o =>ben_bpl_shd.g_old_rec.bpl_attribute11
385: ,p_bpl_attribute12_o =>ben_bpl_shd.g_old_rec.bpl_attribute12
386: ,p_bpl_attribute13_o =>ben_bpl_shd.g_old_rec.bpl_attribute13
387: ,p_bpl_attribute14_o =>ben_bpl_shd.g_old_rec.bpl_attribute14
388: ,p_bpl_attribute15_o =>ben_bpl_shd.g_old_rec.bpl_attribute15
381: ,p_bpl_attribute8_o =>ben_bpl_shd.g_old_rec.bpl_attribute8
382: ,p_bpl_attribute9_o =>ben_bpl_shd.g_old_rec.bpl_attribute9
383: ,p_bpl_attribute10_o =>ben_bpl_shd.g_old_rec.bpl_attribute10
384: ,p_bpl_attribute11_o =>ben_bpl_shd.g_old_rec.bpl_attribute11
385: ,p_bpl_attribute12_o =>ben_bpl_shd.g_old_rec.bpl_attribute12
386: ,p_bpl_attribute13_o =>ben_bpl_shd.g_old_rec.bpl_attribute13
387: ,p_bpl_attribute14_o =>ben_bpl_shd.g_old_rec.bpl_attribute14
388: ,p_bpl_attribute15_o =>ben_bpl_shd.g_old_rec.bpl_attribute15
389: ,p_bpl_attribute16_o =>ben_bpl_shd.g_old_rec.bpl_attribute16
382: ,p_bpl_attribute9_o =>ben_bpl_shd.g_old_rec.bpl_attribute9
383: ,p_bpl_attribute10_o =>ben_bpl_shd.g_old_rec.bpl_attribute10
384: ,p_bpl_attribute11_o =>ben_bpl_shd.g_old_rec.bpl_attribute11
385: ,p_bpl_attribute12_o =>ben_bpl_shd.g_old_rec.bpl_attribute12
386: ,p_bpl_attribute13_o =>ben_bpl_shd.g_old_rec.bpl_attribute13
387: ,p_bpl_attribute14_o =>ben_bpl_shd.g_old_rec.bpl_attribute14
388: ,p_bpl_attribute15_o =>ben_bpl_shd.g_old_rec.bpl_attribute15
389: ,p_bpl_attribute16_o =>ben_bpl_shd.g_old_rec.bpl_attribute16
390: ,p_bpl_attribute17_o =>ben_bpl_shd.g_old_rec.bpl_attribute17
383: ,p_bpl_attribute10_o =>ben_bpl_shd.g_old_rec.bpl_attribute10
384: ,p_bpl_attribute11_o =>ben_bpl_shd.g_old_rec.bpl_attribute11
385: ,p_bpl_attribute12_o =>ben_bpl_shd.g_old_rec.bpl_attribute12
386: ,p_bpl_attribute13_o =>ben_bpl_shd.g_old_rec.bpl_attribute13
387: ,p_bpl_attribute14_o =>ben_bpl_shd.g_old_rec.bpl_attribute14
388: ,p_bpl_attribute15_o =>ben_bpl_shd.g_old_rec.bpl_attribute15
389: ,p_bpl_attribute16_o =>ben_bpl_shd.g_old_rec.bpl_attribute16
390: ,p_bpl_attribute17_o =>ben_bpl_shd.g_old_rec.bpl_attribute17
391: ,p_bpl_attribute18_o =>ben_bpl_shd.g_old_rec.bpl_attribute18
384: ,p_bpl_attribute11_o =>ben_bpl_shd.g_old_rec.bpl_attribute11
385: ,p_bpl_attribute12_o =>ben_bpl_shd.g_old_rec.bpl_attribute12
386: ,p_bpl_attribute13_o =>ben_bpl_shd.g_old_rec.bpl_attribute13
387: ,p_bpl_attribute14_o =>ben_bpl_shd.g_old_rec.bpl_attribute14
388: ,p_bpl_attribute15_o =>ben_bpl_shd.g_old_rec.bpl_attribute15
389: ,p_bpl_attribute16_o =>ben_bpl_shd.g_old_rec.bpl_attribute16
390: ,p_bpl_attribute17_o =>ben_bpl_shd.g_old_rec.bpl_attribute17
391: ,p_bpl_attribute18_o =>ben_bpl_shd.g_old_rec.bpl_attribute18
392: ,p_bpl_attribute19_o =>ben_bpl_shd.g_old_rec.bpl_attribute19
385: ,p_bpl_attribute12_o =>ben_bpl_shd.g_old_rec.bpl_attribute12
386: ,p_bpl_attribute13_o =>ben_bpl_shd.g_old_rec.bpl_attribute13
387: ,p_bpl_attribute14_o =>ben_bpl_shd.g_old_rec.bpl_attribute14
388: ,p_bpl_attribute15_o =>ben_bpl_shd.g_old_rec.bpl_attribute15
389: ,p_bpl_attribute16_o =>ben_bpl_shd.g_old_rec.bpl_attribute16
390: ,p_bpl_attribute17_o =>ben_bpl_shd.g_old_rec.bpl_attribute17
391: ,p_bpl_attribute18_o =>ben_bpl_shd.g_old_rec.bpl_attribute18
392: ,p_bpl_attribute19_o =>ben_bpl_shd.g_old_rec.bpl_attribute19
393: ,p_bpl_attribute20_o =>ben_bpl_shd.g_old_rec.bpl_attribute20
386: ,p_bpl_attribute13_o =>ben_bpl_shd.g_old_rec.bpl_attribute13
387: ,p_bpl_attribute14_o =>ben_bpl_shd.g_old_rec.bpl_attribute14
388: ,p_bpl_attribute15_o =>ben_bpl_shd.g_old_rec.bpl_attribute15
389: ,p_bpl_attribute16_o =>ben_bpl_shd.g_old_rec.bpl_attribute16
390: ,p_bpl_attribute17_o =>ben_bpl_shd.g_old_rec.bpl_attribute17
391: ,p_bpl_attribute18_o =>ben_bpl_shd.g_old_rec.bpl_attribute18
392: ,p_bpl_attribute19_o =>ben_bpl_shd.g_old_rec.bpl_attribute19
393: ,p_bpl_attribute20_o =>ben_bpl_shd.g_old_rec.bpl_attribute20
394: ,p_bpl_attribute21_o =>ben_bpl_shd.g_old_rec.bpl_attribute21
387: ,p_bpl_attribute14_o =>ben_bpl_shd.g_old_rec.bpl_attribute14
388: ,p_bpl_attribute15_o =>ben_bpl_shd.g_old_rec.bpl_attribute15
389: ,p_bpl_attribute16_o =>ben_bpl_shd.g_old_rec.bpl_attribute16
390: ,p_bpl_attribute17_o =>ben_bpl_shd.g_old_rec.bpl_attribute17
391: ,p_bpl_attribute18_o =>ben_bpl_shd.g_old_rec.bpl_attribute18
392: ,p_bpl_attribute19_o =>ben_bpl_shd.g_old_rec.bpl_attribute19
393: ,p_bpl_attribute20_o =>ben_bpl_shd.g_old_rec.bpl_attribute20
394: ,p_bpl_attribute21_o =>ben_bpl_shd.g_old_rec.bpl_attribute21
395: ,p_bpl_attribute22_o =>ben_bpl_shd.g_old_rec.bpl_attribute22
388: ,p_bpl_attribute15_o =>ben_bpl_shd.g_old_rec.bpl_attribute15
389: ,p_bpl_attribute16_o =>ben_bpl_shd.g_old_rec.bpl_attribute16
390: ,p_bpl_attribute17_o =>ben_bpl_shd.g_old_rec.bpl_attribute17
391: ,p_bpl_attribute18_o =>ben_bpl_shd.g_old_rec.bpl_attribute18
392: ,p_bpl_attribute19_o =>ben_bpl_shd.g_old_rec.bpl_attribute19
393: ,p_bpl_attribute20_o =>ben_bpl_shd.g_old_rec.bpl_attribute20
394: ,p_bpl_attribute21_o =>ben_bpl_shd.g_old_rec.bpl_attribute21
395: ,p_bpl_attribute22_o =>ben_bpl_shd.g_old_rec.bpl_attribute22
396: ,p_bpl_attribute23_o =>ben_bpl_shd.g_old_rec.bpl_attribute23
389: ,p_bpl_attribute16_o =>ben_bpl_shd.g_old_rec.bpl_attribute16
390: ,p_bpl_attribute17_o =>ben_bpl_shd.g_old_rec.bpl_attribute17
391: ,p_bpl_attribute18_o =>ben_bpl_shd.g_old_rec.bpl_attribute18
392: ,p_bpl_attribute19_o =>ben_bpl_shd.g_old_rec.bpl_attribute19
393: ,p_bpl_attribute20_o =>ben_bpl_shd.g_old_rec.bpl_attribute20
394: ,p_bpl_attribute21_o =>ben_bpl_shd.g_old_rec.bpl_attribute21
395: ,p_bpl_attribute22_o =>ben_bpl_shd.g_old_rec.bpl_attribute22
396: ,p_bpl_attribute23_o =>ben_bpl_shd.g_old_rec.bpl_attribute23
397: ,p_bpl_attribute24_o =>ben_bpl_shd.g_old_rec.bpl_attribute24
390: ,p_bpl_attribute17_o =>ben_bpl_shd.g_old_rec.bpl_attribute17
391: ,p_bpl_attribute18_o =>ben_bpl_shd.g_old_rec.bpl_attribute18
392: ,p_bpl_attribute19_o =>ben_bpl_shd.g_old_rec.bpl_attribute19
393: ,p_bpl_attribute20_o =>ben_bpl_shd.g_old_rec.bpl_attribute20
394: ,p_bpl_attribute21_o =>ben_bpl_shd.g_old_rec.bpl_attribute21
395: ,p_bpl_attribute22_o =>ben_bpl_shd.g_old_rec.bpl_attribute22
396: ,p_bpl_attribute23_o =>ben_bpl_shd.g_old_rec.bpl_attribute23
397: ,p_bpl_attribute24_o =>ben_bpl_shd.g_old_rec.bpl_attribute24
398: ,p_bpl_attribute25_o =>ben_bpl_shd.g_old_rec.bpl_attribute25
391: ,p_bpl_attribute18_o =>ben_bpl_shd.g_old_rec.bpl_attribute18
392: ,p_bpl_attribute19_o =>ben_bpl_shd.g_old_rec.bpl_attribute19
393: ,p_bpl_attribute20_o =>ben_bpl_shd.g_old_rec.bpl_attribute20
394: ,p_bpl_attribute21_o =>ben_bpl_shd.g_old_rec.bpl_attribute21
395: ,p_bpl_attribute22_o =>ben_bpl_shd.g_old_rec.bpl_attribute22
396: ,p_bpl_attribute23_o =>ben_bpl_shd.g_old_rec.bpl_attribute23
397: ,p_bpl_attribute24_o =>ben_bpl_shd.g_old_rec.bpl_attribute24
398: ,p_bpl_attribute25_o =>ben_bpl_shd.g_old_rec.bpl_attribute25
399: ,p_bpl_attribute26_o =>ben_bpl_shd.g_old_rec.bpl_attribute26
392: ,p_bpl_attribute19_o =>ben_bpl_shd.g_old_rec.bpl_attribute19
393: ,p_bpl_attribute20_o =>ben_bpl_shd.g_old_rec.bpl_attribute20
394: ,p_bpl_attribute21_o =>ben_bpl_shd.g_old_rec.bpl_attribute21
395: ,p_bpl_attribute22_o =>ben_bpl_shd.g_old_rec.bpl_attribute22
396: ,p_bpl_attribute23_o =>ben_bpl_shd.g_old_rec.bpl_attribute23
397: ,p_bpl_attribute24_o =>ben_bpl_shd.g_old_rec.bpl_attribute24
398: ,p_bpl_attribute25_o =>ben_bpl_shd.g_old_rec.bpl_attribute25
399: ,p_bpl_attribute26_o =>ben_bpl_shd.g_old_rec.bpl_attribute26
400: ,p_bpl_attribute27_o =>ben_bpl_shd.g_old_rec.bpl_attribute27
393: ,p_bpl_attribute20_o =>ben_bpl_shd.g_old_rec.bpl_attribute20
394: ,p_bpl_attribute21_o =>ben_bpl_shd.g_old_rec.bpl_attribute21
395: ,p_bpl_attribute22_o =>ben_bpl_shd.g_old_rec.bpl_attribute22
396: ,p_bpl_attribute23_o =>ben_bpl_shd.g_old_rec.bpl_attribute23
397: ,p_bpl_attribute24_o =>ben_bpl_shd.g_old_rec.bpl_attribute24
398: ,p_bpl_attribute25_o =>ben_bpl_shd.g_old_rec.bpl_attribute25
399: ,p_bpl_attribute26_o =>ben_bpl_shd.g_old_rec.bpl_attribute26
400: ,p_bpl_attribute27_o =>ben_bpl_shd.g_old_rec.bpl_attribute27
401: ,p_bpl_attribute28_o =>ben_bpl_shd.g_old_rec.bpl_attribute28
394: ,p_bpl_attribute21_o =>ben_bpl_shd.g_old_rec.bpl_attribute21
395: ,p_bpl_attribute22_o =>ben_bpl_shd.g_old_rec.bpl_attribute22
396: ,p_bpl_attribute23_o =>ben_bpl_shd.g_old_rec.bpl_attribute23
397: ,p_bpl_attribute24_o =>ben_bpl_shd.g_old_rec.bpl_attribute24
398: ,p_bpl_attribute25_o =>ben_bpl_shd.g_old_rec.bpl_attribute25
399: ,p_bpl_attribute26_o =>ben_bpl_shd.g_old_rec.bpl_attribute26
400: ,p_bpl_attribute27_o =>ben_bpl_shd.g_old_rec.bpl_attribute27
401: ,p_bpl_attribute28_o =>ben_bpl_shd.g_old_rec.bpl_attribute28
402: ,p_bpl_attribute29_o =>ben_bpl_shd.g_old_rec.bpl_attribute29
395: ,p_bpl_attribute22_o =>ben_bpl_shd.g_old_rec.bpl_attribute22
396: ,p_bpl_attribute23_o =>ben_bpl_shd.g_old_rec.bpl_attribute23
397: ,p_bpl_attribute24_o =>ben_bpl_shd.g_old_rec.bpl_attribute24
398: ,p_bpl_attribute25_o =>ben_bpl_shd.g_old_rec.bpl_attribute25
399: ,p_bpl_attribute26_o =>ben_bpl_shd.g_old_rec.bpl_attribute26
400: ,p_bpl_attribute27_o =>ben_bpl_shd.g_old_rec.bpl_attribute27
401: ,p_bpl_attribute28_o =>ben_bpl_shd.g_old_rec.bpl_attribute28
402: ,p_bpl_attribute29_o =>ben_bpl_shd.g_old_rec.bpl_attribute29
403: ,p_bpl_attribute30_o =>ben_bpl_shd.g_old_rec.bpl_attribute30
396: ,p_bpl_attribute23_o =>ben_bpl_shd.g_old_rec.bpl_attribute23
397: ,p_bpl_attribute24_o =>ben_bpl_shd.g_old_rec.bpl_attribute24
398: ,p_bpl_attribute25_o =>ben_bpl_shd.g_old_rec.bpl_attribute25
399: ,p_bpl_attribute26_o =>ben_bpl_shd.g_old_rec.bpl_attribute26
400: ,p_bpl_attribute27_o =>ben_bpl_shd.g_old_rec.bpl_attribute27
401: ,p_bpl_attribute28_o =>ben_bpl_shd.g_old_rec.bpl_attribute28
402: ,p_bpl_attribute29_o =>ben_bpl_shd.g_old_rec.bpl_attribute29
403: ,p_bpl_attribute30_o =>ben_bpl_shd.g_old_rec.bpl_attribute30
404: ,p_object_version_number_o =>ben_bpl_shd.g_old_rec.object_version_number
397: ,p_bpl_attribute24_o =>ben_bpl_shd.g_old_rec.bpl_attribute24
398: ,p_bpl_attribute25_o =>ben_bpl_shd.g_old_rec.bpl_attribute25
399: ,p_bpl_attribute26_o =>ben_bpl_shd.g_old_rec.bpl_attribute26
400: ,p_bpl_attribute27_o =>ben_bpl_shd.g_old_rec.bpl_attribute27
401: ,p_bpl_attribute28_o =>ben_bpl_shd.g_old_rec.bpl_attribute28
402: ,p_bpl_attribute29_o =>ben_bpl_shd.g_old_rec.bpl_attribute29
403: ,p_bpl_attribute30_o =>ben_bpl_shd.g_old_rec.bpl_attribute30
404: ,p_object_version_number_o =>ben_bpl_shd.g_old_rec.object_version_number
405: ,p_cash_recd_val_o =>ben_bpl_shd.g_old_rec.cash_recd_val
398: ,p_bpl_attribute25_o =>ben_bpl_shd.g_old_rec.bpl_attribute25
399: ,p_bpl_attribute26_o =>ben_bpl_shd.g_old_rec.bpl_attribute26
400: ,p_bpl_attribute27_o =>ben_bpl_shd.g_old_rec.bpl_attribute27
401: ,p_bpl_attribute28_o =>ben_bpl_shd.g_old_rec.bpl_attribute28
402: ,p_bpl_attribute29_o =>ben_bpl_shd.g_old_rec.bpl_attribute29
403: ,p_bpl_attribute30_o =>ben_bpl_shd.g_old_rec.bpl_attribute30
404: ,p_object_version_number_o =>ben_bpl_shd.g_old_rec.object_version_number
405: ,p_cash_recd_val_o =>ben_bpl_shd.g_old_rec.cash_recd_val
406: ,p_rld_up_val_o =>ben_bpl_shd.g_old_rec.rld_up_val,
399: ,p_bpl_attribute26_o =>ben_bpl_shd.g_old_rec.bpl_attribute26
400: ,p_bpl_attribute27_o =>ben_bpl_shd.g_old_rec.bpl_attribute27
401: ,p_bpl_attribute28_o =>ben_bpl_shd.g_old_rec.bpl_attribute28
402: ,p_bpl_attribute29_o =>ben_bpl_shd.g_old_rec.bpl_attribute29
403: ,p_bpl_attribute30_o =>ben_bpl_shd.g_old_rec.bpl_attribute30
404: ,p_object_version_number_o =>ben_bpl_shd.g_old_rec.object_version_number
405: ,p_cash_recd_val_o =>ben_bpl_shd.g_old_rec.cash_recd_val
406: ,p_rld_up_val_o =>ben_bpl_shd.g_old_rec.rld_up_val,
407: p_acty_ref_perd_cd_o => ben_bpl_shd.g_old_rec.acty_ref_perd_cd,
400: ,p_bpl_attribute27_o =>ben_bpl_shd.g_old_rec.bpl_attribute27
401: ,p_bpl_attribute28_o =>ben_bpl_shd.g_old_rec.bpl_attribute28
402: ,p_bpl_attribute29_o =>ben_bpl_shd.g_old_rec.bpl_attribute29
403: ,p_bpl_attribute30_o =>ben_bpl_shd.g_old_rec.bpl_attribute30
404: ,p_object_version_number_o =>ben_bpl_shd.g_old_rec.object_version_number
405: ,p_cash_recd_val_o =>ben_bpl_shd.g_old_rec.cash_recd_val
406: ,p_rld_up_val_o =>ben_bpl_shd.g_old_rec.rld_up_val,
407: p_acty_ref_perd_cd_o => ben_bpl_shd.g_old_rec.acty_ref_perd_cd,
408: p_cmcd_frftd_val_o => ben_bpl_shd.g_old_rec.cmcd_frftd_val,
401: ,p_bpl_attribute28_o =>ben_bpl_shd.g_old_rec.bpl_attribute28
402: ,p_bpl_attribute29_o =>ben_bpl_shd.g_old_rec.bpl_attribute29
403: ,p_bpl_attribute30_o =>ben_bpl_shd.g_old_rec.bpl_attribute30
404: ,p_object_version_number_o =>ben_bpl_shd.g_old_rec.object_version_number
405: ,p_cash_recd_val_o =>ben_bpl_shd.g_old_rec.cash_recd_val
406: ,p_rld_up_val_o =>ben_bpl_shd.g_old_rec.rld_up_val,
407: p_acty_ref_perd_cd_o => ben_bpl_shd.g_old_rec.acty_ref_perd_cd,
408: p_cmcd_frftd_val_o => ben_bpl_shd.g_old_rec.cmcd_frftd_val,
409: p_cmcd_prvdd_val_o => ben_bpl_shd.g_old_rec.cmcd_prvdd_val,
402: ,p_bpl_attribute29_o =>ben_bpl_shd.g_old_rec.bpl_attribute29
403: ,p_bpl_attribute30_o =>ben_bpl_shd.g_old_rec.bpl_attribute30
404: ,p_object_version_number_o =>ben_bpl_shd.g_old_rec.object_version_number
405: ,p_cash_recd_val_o =>ben_bpl_shd.g_old_rec.cash_recd_val
406: ,p_rld_up_val_o =>ben_bpl_shd.g_old_rec.rld_up_val,
407: p_acty_ref_perd_cd_o => ben_bpl_shd.g_old_rec.acty_ref_perd_cd,
408: p_cmcd_frftd_val_o => ben_bpl_shd.g_old_rec.cmcd_frftd_val,
409: p_cmcd_prvdd_val_o => ben_bpl_shd.g_old_rec.cmcd_prvdd_val,
410: p_cmcd_rld_up_val_o => ben_bpl_shd.g_old_rec.cmcd_rld_up_val,
403: ,p_bpl_attribute30_o =>ben_bpl_shd.g_old_rec.bpl_attribute30
404: ,p_object_version_number_o =>ben_bpl_shd.g_old_rec.object_version_number
405: ,p_cash_recd_val_o =>ben_bpl_shd.g_old_rec.cash_recd_val
406: ,p_rld_up_val_o =>ben_bpl_shd.g_old_rec.rld_up_val,
407: p_acty_ref_perd_cd_o => ben_bpl_shd.g_old_rec.acty_ref_perd_cd,
408: p_cmcd_frftd_val_o => ben_bpl_shd.g_old_rec.cmcd_frftd_val,
409: p_cmcd_prvdd_val_o => ben_bpl_shd.g_old_rec.cmcd_prvdd_val,
410: p_cmcd_rld_up_val_o => ben_bpl_shd.g_old_rec.cmcd_rld_up_val,
411: p_cmcd_used_val_o => ben_bpl_shd.g_old_rec.cmcd_used_val,
404: ,p_object_version_number_o =>ben_bpl_shd.g_old_rec.object_version_number
405: ,p_cash_recd_val_o =>ben_bpl_shd.g_old_rec.cash_recd_val
406: ,p_rld_up_val_o =>ben_bpl_shd.g_old_rec.rld_up_val,
407: p_acty_ref_perd_cd_o => ben_bpl_shd.g_old_rec.acty_ref_perd_cd,
408: p_cmcd_frftd_val_o => ben_bpl_shd.g_old_rec.cmcd_frftd_val,
409: p_cmcd_prvdd_val_o => ben_bpl_shd.g_old_rec.cmcd_prvdd_val,
410: p_cmcd_rld_up_val_o => ben_bpl_shd.g_old_rec.cmcd_rld_up_val,
411: p_cmcd_used_val_o => ben_bpl_shd.g_old_rec.cmcd_used_val,
412: p_cmcd_cash_recd_val_o => ben_bpl_shd.g_old_rec.cmcd_cash_recd_val,
405: ,p_cash_recd_val_o =>ben_bpl_shd.g_old_rec.cash_recd_val
406: ,p_rld_up_val_o =>ben_bpl_shd.g_old_rec.rld_up_val,
407: p_acty_ref_perd_cd_o => ben_bpl_shd.g_old_rec.acty_ref_perd_cd,
408: p_cmcd_frftd_val_o => ben_bpl_shd.g_old_rec.cmcd_frftd_val,
409: p_cmcd_prvdd_val_o => ben_bpl_shd.g_old_rec.cmcd_prvdd_val,
410: p_cmcd_rld_up_val_o => ben_bpl_shd.g_old_rec.cmcd_rld_up_val,
411: p_cmcd_used_val_o => ben_bpl_shd.g_old_rec.cmcd_used_val,
412: p_cmcd_cash_recd_val_o => ben_bpl_shd.g_old_rec.cmcd_cash_recd_val,
413: p_cmcd_ref_perd_cd_o => ben_bpl_shd.g_old_rec.cmcd_ref_perd_cd,
406: ,p_rld_up_val_o =>ben_bpl_shd.g_old_rec.rld_up_val,
407: p_acty_ref_perd_cd_o => ben_bpl_shd.g_old_rec.acty_ref_perd_cd,
408: p_cmcd_frftd_val_o => ben_bpl_shd.g_old_rec.cmcd_frftd_val,
409: p_cmcd_prvdd_val_o => ben_bpl_shd.g_old_rec.cmcd_prvdd_val,
410: p_cmcd_rld_up_val_o => ben_bpl_shd.g_old_rec.cmcd_rld_up_val,
411: p_cmcd_used_val_o => ben_bpl_shd.g_old_rec.cmcd_used_val,
412: p_cmcd_cash_recd_val_o => ben_bpl_shd.g_old_rec.cmcd_cash_recd_val,
413: p_cmcd_ref_perd_cd_o => ben_bpl_shd.g_old_rec.cmcd_ref_perd_cd,
414: p_ann_frftd_val_o => ben_bpl_shd.g_old_rec.ann_frftd_val,
407: p_acty_ref_perd_cd_o => ben_bpl_shd.g_old_rec.acty_ref_perd_cd,
408: p_cmcd_frftd_val_o => ben_bpl_shd.g_old_rec.cmcd_frftd_val,
409: p_cmcd_prvdd_val_o => ben_bpl_shd.g_old_rec.cmcd_prvdd_val,
410: p_cmcd_rld_up_val_o => ben_bpl_shd.g_old_rec.cmcd_rld_up_val,
411: p_cmcd_used_val_o => ben_bpl_shd.g_old_rec.cmcd_used_val,
412: p_cmcd_cash_recd_val_o => ben_bpl_shd.g_old_rec.cmcd_cash_recd_val,
413: p_cmcd_ref_perd_cd_o => ben_bpl_shd.g_old_rec.cmcd_ref_perd_cd,
414: p_ann_frftd_val_o => ben_bpl_shd.g_old_rec.ann_frftd_val,
415: p_ann_prvdd_val_o => ben_bpl_shd.g_old_rec.ann_prvdd_val,
408: p_cmcd_frftd_val_o => ben_bpl_shd.g_old_rec.cmcd_frftd_val,
409: p_cmcd_prvdd_val_o => ben_bpl_shd.g_old_rec.cmcd_prvdd_val,
410: p_cmcd_rld_up_val_o => ben_bpl_shd.g_old_rec.cmcd_rld_up_val,
411: p_cmcd_used_val_o => ben_bpl_shd.g_old_rec.cmcd_used_val,
412: p_cmcd_cash_recd_val_o => ben_bpl_shd.g_old_rec.cmcd_cash_recd_val,
413: p_cmcd_ref_perd_cd_o => ben_bpl_shd.g_old_rec.cmcd_ref_perd_cd,
414: p_ann_frftd_val_o => ben_bpl_shd.g_old_rec.ann_frftd_val,
415: p_ann_prvdd_val_o => ben_bpl_shd.g_old_rec.ann_prvdd_val,
416: p_ann_rld_up_val_o => ben_bpl_shd.g_old_rec.ann_rld_up_val,
409: p_cmcd_prvdd_val_o => ben_bpl_shd.g_old_rec.cmcd_prvdd_val,
410: p_cmcd_rld_up_val_o => ben_bpl_shd.g_old_rec.cmcd_rld_up_val,
411: p_cmcd_used_val_o => ben_bpl_shd.g_old_rec.cmcd_used_val,
412: p_cmcd_cash_recd_val_o => ben_bpl_shd.g_old_rec.cmcd_cash_recd_val,
413: p_cmcd_ref_perd_cd_o => ben_bpl_shd.g_old_rec.cmcd_ref_perd_cd,
414: p_ann_frftd_val_o => ben_bpl_shd.g_old_rec.ann_frftd_val,
415: p_ann_prvdd_val_o => ben_bpl_shd.g_old_rec.ann_prvdd_val,
416: p_ann_rld_up_val_o => ben_bpl_shd.g_old_rec.ann_rld_up_val,
417: p_ann_used_val_o => ben_bpl_shd.g_old_rec.ann_used_val,
410: p_cmcd_rld_up_val_o => ben_bpl_shd.g_old_rec.cmcd_rld_up_val,
411: p_cmcd_used_val_o => ben_bpl_shd.g_old_rec.cmcd_used_val,
412: p_cmcd_cash_recd_val_o => ben_bpl_shd.g_old_rec.cmcd_cash_recd_val,
413: p_cmcd_ref_perd_cd_o => ben_bpl_shd.g_old_rec.cmcd_ref_perd_cd,
414: p_ann_frftd_val_o => ben_bpl_shd.g_old_rec.ann_frftd_val,
415: p_ann_prvdd_val_o => ben_bpl_shd.g_old_rec.ann_prvdd_val,
416: p_ann_rld_up_val_o => ben_bpl_shd.g_old_rec.ann_rld_up_val,
417: p_ann_used_val_o => ben_bpl_shd.g_old_rec.ann_used_val,
418: p_ann_cash_recd_val_o => ben_bpl_shd.g_old_rec.ann_cash_recd_val
411: p_cmcd_used_val_o => ben_bpl_shd.g_old_rec.cmcd_used_val,
412: p_cmcd_cash_recd_val_o => ben_bpl_shd.g_old_rec.cmcd_cash_recd_val,
413: p_cmcd_ref_perd_cd_o => ben_bpl_shd.g_old_rec.cmcd_ref_perd_cd,
414: p_ann_frftd_val_o => ben_bpl_shd.g_old_rec.ann_frftd_val,
415: p_ann_prvdd_val_o => ben_bpl_shd.g_old_rec.ann_prvdd_val,
416: p_ann_rld_up_val_o => ben_bpl_shd.g_old_rec.ann_rld_up_val,
417: p_ann_used_val_o => ben_bpl_shd.g_old_rec.ann_used_val,
418: p_ann_cash_recd_val_o => ben_bpl_shd.g_old_rec.ann_cash_recd_val
419: );
412: p_cmcd_cash_recd_val_o => ben_bpl_shd.g_old_rec.cmcd_cash_recd_val,
413: p_cmcd_ref_perd_cd_o => ben_bpl_shd.g_old_rec.cmcd_ref_perd_cd,
414: p_ann_frftd_val_o => ben_bpl_shd.g_old_rec.ann_frftd_val,
415: p_ann_prvdd_val_o => ben_bpl_shd.g_old_rec.ann_prvdd_val,
416: p_ann_rld_up_val_o => ben_bpl_shd.g_old_rec.ann_rld_up_val,
417: p_ann_used_val_o => ben_bpl_shd.g_old_rec.ann_used_val,
418: p_ann_cash_recd_val_o => ben_bpl_shd.g_old_rec.ann_cash_recd_val
419: );
420: --
413: p_cmcd_ref_perd_cd_o => ben_bpl_shd.g_old_rec.cmcd_ref_perd_cd,
414: p_ann_frftd_val_o => ben_bpl_shd.g_old_rec.ann_frftd_val,
415: p_ann_prvdd_val_o => ben_bpl_shd.g_old_rec.ann_prvdd_val,
416: p_ann_rld_up_val_o => ben_bpl_shd.g_old_rec.ann_rld_up_val,
417: p_ann_used_val_o => ben_bpl_shd.g_old_rec.ann_used_val,
418: p_ann_cash_recd_val_o => ben_bpl_shd.g_old_rec.ann_cash_recd_val
419: );
420: --
421: exception
414: p_ann_frftd_val_o => ben_bpl_shd.g_old_rec.ann_frftd_val,
415: p_ann_prvdd_val_o => ben_bpl_shd.g_old_rec.ann_prvdd_val,
416: p_ann_rld_up_val_o => ben_bpl_shd.g_old_rec.ann_rld_up_val,
417: p_ann_used_val_o => ben_bpl_shd.g_old_rec.ann_used_val,
418: p_ann_cash_recd_val_o => ben_bpl_shd.g_old_rec.ann_cash_recd_val
419: );
420: --
421: exception
422: --
438: -- |---------------------------------< del >----------------------------------|
439: -- ----------------------------------------------------------------------------
440: Procedure del
441: (
442: p_rec in out nocopy ben_bpl_shd.g_rec_type,
443: p_effective_date in date,
444: p_datetrack_mode in varchar2
445: ) is
446: --
456: dt_api.validate_dt_del_mode(p_datetrack_mode => p_datetrack_mode);
457: --
458: -- We must lock the row which we need to delete.
459: --
460: ben_bpl_shd.lck
461: (p_effective_date => p_effective_date,
462: p_datetrack_mode => p_datetrack_mode,
463: p_bnft_prvdd_ldgr_id => p_rec.bnft_prvdd_ldgr_id,
464: p_object_version_number => p_rec.object_version_number,
514: p_effective_date in date,
515: p_datetrack_mode in varchar2
516: ) is
517: --
518: l_rec ben_bpl_shd.g_rec_type;
519: l_proc varchar2(72) := g_package||'del';
520: --
521: Begin
522: hr_utility.set_location('Entering:'||l_proc, 5);