50: --
51: -- {End Of Comments}
52: -- ----------------------------------------------------------------------------
53: Procedure dt_delete_dml
54: (p_rec in out nocopy ben_bpp_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_bpp_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_prvdr_pool_f
72: where bnft_prvdr_pool_id = p_rec.bnft_prvdr_pool_id
73: and effective_start_date = p_validation_start_date;
74: --
75: ben_bpp_shd.g_api_dml := false; -- Unset the api dml status
76: Else
77: hr_utility.set_location(l_proc, 15);
78: ben_bpp_shd.g_api_dml := true; -- Set the api dml status
79: --
74: --
75: ben_bpp_shd.g_api_dml := false; -- Unset the api dml status
76: Else
77: hr_utility.set_location(l_proc, 15);
78: ben_bpp_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_prvdr_pool_f
84: where bnft_prvdr_pool_id = p_rec.bnft_prvdr_pool_id
85: and effective_start_date >= p_validation_start_date;
86: --
87: ben_bpp_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_bpp_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_bpp_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_bpp_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_bpp_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_bpp_shd.upd_effective_end_date
180: (p_effective_date => p_effective_date,
181: p_base_key_value => p_rec.bnft_prvdr_pool_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_bpp_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
281: --
282: -- {End Of Comments}
283: -- ----------------------------------------------------------------------------
284: Procedure post_delete
285: (p_rec in ben_bpp_shd.g_rec_type,
286: p_effective_date in date,
287: p_datetrack_mode in varchar2,
288: p_validation_start_date in date,
289: p_validation_end_date in date) is
304: ,p_validation_start_date => p_validation_start_date
305: ,p_validation_end_date => p_validation_end_date
306: ,p_effective_start_date => p_rec.effective_start_date
307: ,p_effective_end_date => p_rec.effective_end_date
308: ,p_effective_start_date_o => ben_bpp_shd.g_old_rec.effective_start_date
309: ,p_effective_end_date_o => ben_bpp_shd.g_old_rec.effective_end_date
310: ,p_name_o => ben_bpp_shd.g_old_rec.name
311: ,p_pgm_pool_flag_o => ben_bpp_shd.g_old_rec.pgm_pool_flag
312: ,p_excs_alwys_fftd_flag_o => ben_bpp_shd.g_old_rec.excs_alwys_fftd_flag
305: ,p_validation_end_date => p_validation_end_date
306: ,p_effective_start_date => p_rec.effective_start_date
307: ,p_effective_end_date => p_rec.effective_end_date
308: ,p_effective_start_date_o => ben_bpp_shd.g_old_rec.effective_start_date
309: ,p_effective_end_date_o => ben_bpp_shd.g_old_rec.effective_end_date
310: ,p_name_o => ben_bpp_shd.g_old_rec.name
311: ,p_pgm_pool_flag_o => ben_bpp_shd.g_old_rec.pgm_pool_flag
312: ,p_excs_alwys_fftd_flag_o => ben_bpp_shd.g_old_rec.excs_alwys_fftd_flag
313: ,p_use_for_pgm_pool_flag_o => ben_bpp_shd.g_old_rec.use_for_pgm_pool_flag
306: ,p_effective_start_date => p_rec.effective_start_date
307: ,p_effective_end_date => p_rec.effective_end_date
308: ,p_effective_start_date_o => ben_bpp_shd.g_old_rec.effective_start_date
309: ,p_effective_end_date_o => ben_bpp_shd.g_old_rec.effective_end_date
310: ,p_name_o => ben_bpp_shd.g_old_rec.name
311: ,p_pgm_pool_flag_o => ben_bpp_shd.g_old_rec.pgm_pool_flag
312: ,p_excs_alwys_fftd_flag_o => ben_bpp_shd.g_old_rec.excs_alwys_fftd_flag
313: ,p_use_for_pgm_pool_flag_o => ben_bpp_shd.g_old_rec.use_for_pgm_pool_flag
314: ,p_pct_rndg_cd_o => ben_bpp_shd.g_old_rec.pct_rndg_cd
307: ,p_effective_end_date => p_rec.effective_end_date
308: ,p_effective_start_date_o => ben_bpp_shd.g_old_rec.effective_start_date
309: ,p_effective_end_date_o => ben_bpp_shd.g_old_rec.effective_end_date
310: ,p_name_o => ben_bpp_shd.g_old_rec.name
311: ,p_pgm_pool_flag_o => ben_bpp_shd.g_old_rec.pgm_pool_flag
312: ,p_excs_alwys_fftd_flag_o => ben_bpp_shd.g_old_rec.excs_alwys_fftd_flag
313: ,p_use_for_pgm_pool_flag_o => ben_bpp_shd.g_old_rec.use_for_pgm_pool_flag
314: ,p_pct_rndg_cd_o => ben_bpp_shd.g_old_rec.pct_rndg_cd
315: ,p_pct_rndg_rl_o => ben_bpp_shd.g_old_rec.pct_rndg_rl
308: ,p_effective_start_date_o => ben_bpp_shd.g_old_rec.effective_start_date
309: ,p_effective_end_date_o => ben_bpp_shd.g_old_rec.effective_end_date
310: ,p_name_o => ben_bpp_shd.g_old_rec.name
311: ,p_pgm_pool_flag_o => ben_bpp_shd.g_old_rec.pgm_pool_flag
312: ,p_excs_alwys_fftd_flag_o => ben_bpp_shd.g_old_rec.excs_alwys_fftd_flag
313: ,p_use_for_pgm_pool_flag_o => ben_bpp_shd.g_old_rec.use_for_pgm_pool_flag
314: ,p_pct_rndg_cd_o => ben_bpp_shd.g_old_rec.pct_rndg_cd
315: ,p_pct_rndg_rl_o => ben_bpp_shd.g_old_rec.pct_rndg_rl
316: ,p_val_rndg_cd_o => ben_bpp_shd.g_old_rec.val_rndg_cd
309: ,p_effective_end_date_o => ben_bpp_shd.g_old_rec.effective_end_date
310: ,p_name_o => ben_bpp_shd.g_old_rec.name
311: ,p_pgm_pool_flag_o => ben_bpp_shd.g_old_rec.pgm_pool_flag
312: ,p_excs_alwys_fftd_flag_o => ben_bpp_shd.g_old_rec.excs_alwys_fftd_flag
313: ,p_use_for_pgm_pool_flag_o => ben_bpp_shd.g_old_rec.use_for_pgm_pool_flag
314: ,p_pct_rndg_cd_o => ben_bpp_shd.g_old_rec.pct_rndg_cd
315: ,p_pct_rndg_rl_o => ben_bpp_shd.g_old_rec.pct_rndg_rl
316: ,p_val_rndg_cd_o => ben_bpp_shd.g_old_rec.val_rndg_cd
317: ,p_val_rndg_rl_o => ben_bpp_shd.g_old_rec.val_rndg_rl
310: ,p_name_o => ben_bpp_shd.g_old_rec.name
311: ,p_pgm_pool_flag_o => ben_bpp_shd.g_old_rec.pgm_pool_flag
312: ,p_excs_alwys_fftd_flag_o => ben_bpp_shd.g_old_rec.excs_alwys_fftd_flag
313: ,p_use_for_pgm_pool_flag_o => ben_bpp_shd.g_old_rec.use_for_pgm_pool_flag
314: ,p_pct_rndg_cd_o => ben_bpp_shd.g_old_rec.pct_rndg_cd
315: ,p_pct_rndg_rl_o => ben_bpp_shd.g_old_rec.pct_rndg_rl
316: ,p_val_rndg_cd_o => ben_bpp_shd.g_old_rec.val_rndg_cd
317: ,p_val_rndg_rl_o => ben_bpp_shd.g_old_rec.val_rndg_rl
318: ,p_dflt_excs_trtmt_cd_o => ben_bpp_shd.g_old_rec.dflt_excs_trtmt_cd
311: ,p_pgm_pool_flag_o => ben_bpp_shd.g_old_rec.pgm_pool_flag
312: ,p_excs_alwys_fftd_flag_o => ben_bpp_shd.g_old_rec.excs_alwys_fftd_flag
313: ,p_use_for_pgm_pool_flag_o => ben_bpp_shd.g_old_rec.use_for_pgm_pool_flag
314: ,p_pct_rndg_cd_o => ben_bpp_shd.g_old_rec.pct_rndg_cd
315: ,p_pct_rndg_rl_o => ben_bpp_shd.g_old_rec.pct_rndg_rl
316: ,p_val_rndg_cd_o => ben_bpp_shd.g_old_rec.val_rndg_cd
317: ,p_val_rndg_rl_o => ben_bpp_shd.g_old_rec.val_rndg_rl
318: ,p_dflt_excs_trtmt_cd_o => ben_bpp_shd.g_old_rec.dflt_excs_trtmt_cd
319: ,p_dflt_excs_trtmt_rl_o => ben_bpp_shd.g_old_rec.dflt_excs_trtmt_rl
312: ,p_excs_alwys_fftd_flag_o => ben_bpp_shd.g_old_rec.excs_alwys_fftd_flag
313: ,p_use_for_pgm_pool_flag_o => ben_bpp_shd.g_old_rec.use_for_pgm_pool_flag
314: ,p_pct_rndg_cd_o => ben_bpp_shd.g_old_rec.pct_rndg_cd
315: ,p_pct_rndg_rl_o => ben_bpp_shd.g_old_rec.pct_rndg_rl
316: ,p_val_rndg_cd_o => ben_bpp_shd.g_old_rec.val_rndg_cd
317: ,p_val_rndg_rl_o => ben_bpp_shd.g_old_rec.val_rndg_rl
318: ,p_dflt_excs_trtmt_cd_o => ben_bpp_shd.g_old_rec.dflt_excs_trtmt_cd
319: ,p_dflt_excs_trtmt_rl_o => ben_bpp_shd.g_old_rec.dflt_excs_trtmt_rl
320: ,p_rlovr_rstrcn_cd_o => ben_bpp_shd.g_old_rec.rlovr_rstrcn_cd
313: ,p_use_for_pgm_pool_flag_o => ben_bpp_shd.g_old_rec.use_for_pgm_pool_flag
314: ,p_pct_rndg_cd_o => ben_bpp_shd.g_old_rec.pct_rndg_cd
315: ,p_pct_rndg_rl_o => ben_bpp_shd.g_old_rec.pct_rndg_rl
316: ,p_val_rndg_cd_o => ben_bpp_shd.g_old_rec.val_rndg_cd
317: ,p_val_rndg_rl_o => ben_bpp_shd.g_old_rec.val_rndg_rl
318: ,p_dflt_excs_trtmt_cd_o => ben_bpp_shd.g_old_rec.dflt_excs_trtmt_cd
319: ,p_dflt_excs_trtmt_rl_o => ben_bpp_shd.g_old_rec.dflt_excs_trtmt_rl
320: ,p_rlovr_rstrcn_cd_o => ben_bpp_shd.g_old_rec.rlovr_rstrcn_cd
321: ,p_no_mn_dstrbl_pct_flag_o => ben_bpp_shd.g_old_rec.no_mn_dstrbl_pct_flag
314: ,p_pct_rndg_cd_o => ben_bpp_shd.g_old_rec.pct_rndg_cd
315: ,p_pct_rndg_rl_o => ben_bpp_shd.g_old_rec.pct_rndg_rl
316: ,p_val_rndg_cd_o => ben_bpp_shd.g_old_rec.val_rndg_cd
317: ,p_val_rndg_rl_o => ben_bpp_shd.g_old_rec.val_rndg_rl
318: ,p_dflt_excs_trtmt_cd_o => ben_bpp_shd.g_old_rec.dflt_excs_trtmt_cd
319: ,p_dflt_excs_trtmt_rl_o => ben_bpp_shd.g_old_rec.dflt_excs_trtmt_rl
320: ,p_rlovr_rstrcn_cd_o => ben_bpp_shd.g_old_rec.rlovr_rstrcn_cd
321: ,p_no_mn_dstrbl_pct_flag_o => ben_bpp_shd.g_old_rec.no_mn_dstrbl_pct_flag
322: ,p_no_mn_dstrbl_val_flag_o => ben_bpp_shd.g_old_rec.no_mn_dstrbl_val_flag
315: ,p_pct_rndg_rl_o => ben_bpp_shd.g_old_rec.pct_rndg_rl
316: ,p_val_rndg_cd_o => ben_bpp_shd.g_old_rec.val_rndg_cd
317: ,p_val_rndg_rl_o => ben_bpp_shd.g_old_rec.val_rndg_rl
318: ,p_dflt_excs_trtmt_cd_o => ben_bpp_shd.g_old_rec.dflt_excs_trtmt_cd
319: ,p_dflt_excs_trtmt_rl_o => ben_bpp_shd.g_old_rec.dflt_excs_trtmt_rl
320: ,p_rlovr_rstrcn_cd_o => ben_bpp_shd.g_old_rec.rlovr_rstrcn_cd
321: ,p_no_mn_dstrbl_pct_flag_o => ben_bpp_shd.g_old_rec.no_mn_dstrbl_pct_flag
322: ,p_no_mn_dstrbl_val_flag_o => ben_bpp_shd.g_old_rec.no_mn_dstrbl_val_flag
323: ,p_no_mx_dstrbl_pct_flag_o => ben_bpp_shd.g_old_rec.no_mx_dstrbl_pct_flag
316: ,p_val_rndg_cd_o => ben_bpp_shd.g_old_rec.val_rndg_cd
317: ,p_val_rndg_rl_o => ben_bpp_shd.g_old_rec.val_rndg_rl
318: ,p_dflt_excs_trtmt_cd_o => ben_bpp_shd.g_old_rec.dflt_excs_trtmt_cd
319: ,p_dflt_excs_trtmt_rl_o => ben_bpp_shd.g_old_rec.dflt_excs_trtmt_rl
320: ,p_rlovr_rstrcn_cd_o => ben_bpp_shd.g_old_rec.rlovr_rstrcn_cd
321: ,p_no_mn_dstrbl_pct_flag_o => ben_bpp_shd.g_old_rec.no_mn_dstrbl_pct_flag
322: ,p_no_mn_dstrbl_val_flag_o => ben_bpp_shd.g_old_rec.no_mn_dstrbl_val_flag
323: ,p_no_mx_dstrbl_pct_flag_o => ben_bpp_shd.g_old_rec.no_mx_dstrbl_pct_flag
324: ,p_no_mx_dstrbl_val_flag_o => ben_bpp_shd.g_old_rec.no_mx_dstrbl_val_flag
317: ,p_val_rndg_rl_o => ben_bpp_shd.g_old_rec.val_rndg_rl
318: ,p_dflt_excs_trtmt_cd_o => ben_bpp_shd.g_old_rec.dflt_excs_trtmt_cd
319: ,p_dflt_excs_trtmt_rl_o => ben_bpp_shd.g_old_rec.dflt_excs_trtmt_rl
320: ,p_rlovr_rstrcn_cd_o => ben_bpp_shd.g_old_rec.rlovr_rstrcn_cd
321: ,p_no_mn_dstrbl_pct_flag_o => ben_bpp_shd.g_old_rec.no_mn_dstrbl_pct_flag
322: ,p_no_mn_dstrbl_val_flag_o => ben_bpp_shd.g_old_rec.no_mn_dstrbl_val_flag
323: ,p_no_mx_dstrbl_pct_flag_o => ben_bpp_shd.g_old_rec.no_mx_dstrbl_pct_flag
324: ,p_no_mx_dstrbl_val_flag_o => ben_bpp_shd.g_old_rec.no_mx_dstrbl_val_flag
325: ,p_auto_alct_excs_flag_o => ben_bpp_shd.g_old_rec.auto_alct_excs_flag
318: ,p_dflt_excs_trtmt_cd_o => ben_bpp_shd.g_old_rec.dflt_excs_trtmt_cd
319: ,p_dflt_excs_trtmt_rl_o => ben_bpp_shd.g_old_rec.dflt_excs_trtmt_rl
320: ,p_rlovr_rstrcn_cd_o => ben_bpp_shd.g_old_rec.rlovr_rstrcn_cd
321: ,p_no_mn_dstrbl_pct_flag_o => ben_bpp_shd.g_old_rec.no_mn_dstrbl_pct_flag
322: ,p_no_mn_dstrbl_val_flag_o => ben_bpp_shd.g_old_rec.no_mn_dstrbl_val_flag
323: ,p_no_mx_dstrbl_pct_flag_o => ben_bpp_shd.g_old_rec.no_mx_dstrbl_pct_flag
324: ,p_no_mx_dstrbl_val_flag_o => ben_bpp_shd.g_old_rec.no_mx_dstrbl_val_flag
325: ,p_auto_alct_excs_flag_o => ben_bpp_shd.g_old_rec.auto_alct_excs_flag
326: ,p_alws_ngtv_crs_flag_o => ben_bpp_shd.g_old_rec.alws_ngtv_crs_flag
319: ,p_dflt_excs_trtmt_rl_o => ben_bpp_shd.g_old_rec.dflt_excs_trtmt_rl
320: ,p_rlovr_rstrcn_cd_o => ben_bpp_shd.g_old_rec.rlovr_rstrcn_cd
321: ,p_no_mn_dstrbl_pct_flag_o => ben_bpp_shd.g_old_rec.no_mn_dstrbl_pct_flag
322: ,p_no_mn_dstrbl_val_flag_o => ben_bpp_shd.g_old_rec.no_mn_dstrbl_val_flag
323: ,p_no_mx_dstrbl_pct_flag_o => ben_bpp_shd.g_old_rec.no_mx_dstrbl_pct_flag
324: ,p_no_mx_dstrbl_val_flag_o => ben_bpp_shd.g_old_rec.no_mx_dstrbl_val_flag
325: ,p_auto_alct_excs_flag_o => ben_bpp_shd.g_old_rec.auto_alct_excs_flag
326: ,p_alws_ngtv_crs_flag_o => ben_bpp_shd.g_old_rec.alws_ngtv_crs_flag
327: ,p_uses_net_crs_mthd_flag_o => ben_bpp_shd.g_old_rec.uses_net_crs_mthd_flag
320: ,p_rlovr_rstrcn_cd_o => ben_bpp_shd.g_old_rec.rlovr_rstrcn_cd
321: ,p_no_mn_dstrbl_pct_flag_o => ben_bpp_shd.g_old_rec.no_mn_dstrbl_pct_flag
322: ,p_no_mn_dstrbl_val_flag_o => ben_bpp_shd.g_old_rec.no_mn_dstrbl_val_flag
323: ,p_no_mx_dstrbl_pct_flag_o => ben_bpp_shd.g_old_rec.no_mx_dstrbl_pct_flag
324: ,p_no_mx_dstrbl_val_flag_o => ben_bpp_shd.g_old_rec.no_mx_dstrbl_val_flag
325: ,p_auto_alct_excs_flag_o => ben_bpp_shd.g_old_rec.auto_alct_excs_flag
326: ,p_alws_ngtv_crs_flag_o => ben_bpp_shd.g_old_rec.alws_ngtv_crs_flag
327: ,p_uses_net_crs_mthd_flag_o => ben_bpp_shd.g_old_rec.uses_net_crs_mthd_flag
328: ,p_mx_dfcit_pct_pool_crs_num_o => ben_bpp_shd.g_old_rec.mx_dfcit_pct_pool_crs_num
321: ,p_no_mn_dstrbl_pct_flag_o => ben_bpp_shd.g_old_rec.no_mn_dstrbl_pct_flag
322: ,p_no_mn_dstrbl_val_flag_o => ben_bpp_shd.g_old_rec.no_mn_dstrbl_val_flag
323: ,p_no_mx_dstrbl_pct_flag_o => ben_bpp_shd.g_old_rec.no_mx_dstrbl_pct_flag
324: ,p_no_mx_dstrbl_val_flag_o => ben_bpp_shd.g_old_rec.no_mx_dstrbl_val_flag
325: ,p_auto_alct_excs_flag_o => ben_bpp_shd.g_old_rec.auto_alct_excs_flag
326: ,p_alws_ngtv_crs_flag_o => ben_bpp_shd.g_old_rec.alws_ngtv_crs_flag
327: ,p_uses_net_crs_mthd_flag_o => ben_bpp_shd.g_old_rec.uses_net_crs_mthd_flag
328: ,p_mx_dfcit_pct_pool_crs_num_o => ben_bpp_shd.g_old_rec.mx_dfcit_pct_pool_crs_num
329: ,p_mx_dfcit_pct_comp_num_o => ben_bpp_shd.g_old_rec.mx_dfcit_pct_comp_num
322: ,p_no_mn_dstrbl_val_flag_o => ben_bpp_shd.g_old_rec.no_mn_dstrbl_val_flag
323: ,p_no_mx_dstrbl_pct_flag_o => ben_bpp_shd.g_old_rec.no_mx_dstrbl_pct_flag
324: ,p_no_mx_dstrbl_val_flag_o => ben_bpp_shd.g_old_rec.no_mx_dstrbl_val_flag
325: ,p_auto_alct_excs_flag_o => ben_bpp_shd.g_old_rec.auto_alct_excs_flag
326: ,p_alws_ngtv_crs_flag_o => ben_bpp_shd.g_old_rec.alws_ngtv_crs_flag
327: ,p_uses_net_crs_mthd_flag_o => ben_bpp_shd.g_old_rec.uses_net_crs_mthd_flag
328: ,p_mx_dfcit_pct_pool_crs_num_o => ben_bpp_shd.g_old_rec.mx_dfcit_pct_pool_crs_num
329: ,p_mx_dfcit_pct_comp_num_o => ben_bpp_shd.g_old_rec.mx_dfcit_pct_comp_num
330: ,p_comp_lvl_fctr_id_o => ben_bpp_shd.g_old_rec.comp_lvl_fctr_id
323: ,p_no_mx_dstrbl_pct_flag_o => ben_bpp_shd.g_old_rec.no_mx_dstrbl_pct_flag
324: ,p_no_mx_dstrbl_val_flag_o => ben_bpp_shd.g_old_rec.no_mx_dstrbl_val_flag
325: ,p_auto_alct_excs_flag_o => ben_bpp_shd.g_old_rec.auto_alct_excs_flag
326: ,p_alws_ngtv_crs_flag_o => ben_bpp_shd.g_old_rec.alws_ngtv_crs_flag
327: ,p_uses_net_crs_mthd_flag_o => ben_bpp_shd.g_old_rec.uses_net_crs_mthd_flag
328: ,p_mx_dfcit_pct_pool_crs_num_o => ben_bpp_shd.g_old_rec.mx_dfcit_pct_pool_crs_num
329: ,p_mx_dfcit_pct_comp_num_o => ben_bpp_shd.g_old_rec.mx_dfcit_pct_comp_num
330: ,p_comp_lvl_fctr_id_o => ben_bpp_shd.g_old_rec.comp_lvl_fctr_id
331: ,p_mn_dstrbl_pct_num_o => ben_bpp_shd.g_old_rec.mn_dstrbl_pct_num
324: ,p_no_mx_dstrbl_val_flag_o => ben_bpp_shd.g_old_rec.no_mx_dstrbl_val_flag
325: ,p_auto_alct_excs_flag_o => ben_bpp_shd.g_old_rec.auto_alct_excs_flag
326: ,p_alws_ngtv_crs_flag_o => ben_bpp_shd.g_old_rec.alws_ngtv_crs_flag
327: ,p_uses_net_crs_mthd_flag_o => ben_bpp_shd.g_old_rec.uses_net_crs_mthd_flag
328: ,p_mx_dfcit_pct_pool_crs_num_o => ben_bpp_shd.g_old_rec.mx_dfcit_pct_pool_crs_num
329: ,p_mx_dfcit_pct_comp_num_o => ben_bpp_shd.g_old_rec.mx_dfcit_pct_comp_num
330: ,p_comp_lvl_fctr_id_o => ben_bpp_shd.g_old_rec.comp_lvl_fctr_id
331: ,p_mn_dstrbl_pct_num_o => ben_bpp_shd.g_old_rec.mn_dstrbl_pct_num
332: ,p_mn_dstrbl_val_o => ben_bpp_shd.g_old_rec.mn_dstrbl_val
325: ,p_auto_alct_excs_flag_o => ben_bpp_shd.g_old_rec.auto_alct_excs_flag
326: ,p_alws_ngtv_crs_flag_o => ben_bpp_shd.g_old_rec.alws_ngtv_crs_flag
327: ,p_uses_net_crs_mthd_flag_o => ben_bpp_shd.g_old_rec.uses_net_crs_mthd_flag
328: ,p_mx_dfcit_pct_pool_crs_num_o => ben_bpp_shd.g_old_rec.mx_dfcit_pct_pool_crs_num
329: ,p_mx_dfcit_pct_comp_num_o => ben_bpp_shd.g_old_rec.mx_dfcit_pct_comp_num
330: ,p_comp_lvl_fctr_id_o => ben_bpp_shd.g_old_rec.comp_lvl_fctr_id
331: ,p_mn_dstrbl_pct_num_o => ben_bpp_shd.g_old_rec.mn_dstrbl_pct_num
332: ,p_mn_dstrbl_val_o => ben_bpp_shd.g_old_rec.mn_dstrbl_val
333: ,p_mx_dstrbl_pct_num_o => ben_bpp_shd.g_old_rec.mx_dstrbl_pct_num
326: ,p_alws_ngtv_crs_flag_o => ben_bpp_shd.g_old_rec.alws_ngtv_crs_flag
327: ,p_uses_net_crs_mthd_flag_o => ben_bpp_shd.g_old_rec.uses_net_crs_mthd_flag
328: ,p_mx_dfcit_pct_pool_crs_num_o => ben_bpp_shd.g_old_rec.mx_dfcit_pct_pool_crs_num
329: ,p_mx_dfcit_pct_comp_num_o => ben_bpp_shd.g_old_rec.mx_dfcit_pct_comp_num
330: ,p_comp_lvl_fctr_id_o => ben_bpp_shd.g_old_rec.comp_lvl_fctr_id
331: ,p_mn_dstrbl_pct_num_o => ben_bpp_shd.g_old_rec.mn_dstrbl_pct_num
332: ,p_mn_dstrbl_val_o => ben_bpp_shd.g_old_rec.mn_dstrbl_val
333: ,p_mx_dstrbl_pct_num_o => ben_bpp_shd.g_old_rec.mx_dstrbl_pct_num
334: ,p_mx_dstrbl_val_o => ben_bpp_shd.g_old_rec.mx_dstrbl_val
327: ,p_uses_net_crs_mthd_flag_o => ben_bpp_shd.g_old_rec.uses_net_crs_mthd_flag
328: ,p_mx_dfcit_pct_pool_crs_num_o => ben_bpp_shd.g_old_rec.mx_dfcit_pct_pool_crs_num
329: ,p_mx_dfcit_pct_comp_num_o => ben_bpp_shd.g_old_rec.mx_dfcit_pct_comp_num
330: ,p_comp_lvl_fctr_id_o => ben_bpp_shd.g_old_rec.comp_lvl_fctr_id
331: ,p_mn_dstrbl_pct_num_o => ben_bpp_shd.g_old_rec.mn_dstrbl_pct_num
332: ,p_mn_dstrbl_val_o => ben_bpp_shd.g_old_rec.mn_dstrbl_val
333: ,p_mx_dstrbl_pct_num_o => ben_bpp_shd.g_old_rec.mx_dstrbl_pct_num
334: ,p_mx_dstrbl_val_o => ben_bpp_shd.g_old_rec.mx_dstrbl_val
335: ,p_excs_trtmt_cd_o => ben_bpp_shd.g_old_rec.excs_trtmt_cd
328: ,p_mx_dfcit_pct_pool_crs_num_o => ben_bpp_shd.g_old_rec.mx_dfcit_pct_pool_crs_num
329: ,p_mx_dfcit_pct_comp_num_o => ben_bpp_shd.g_old_rec.mx_dfcit_pct_comp_num
330: ,p_comp_lvl_fctr_id_o => ben_bpp_shd.g_old_rec.comp_lvl_fctr_id
331: ,p_mn_dstrbl_pct_num_o => ben_bpp_shd.g_old_rec.mn_dstrbl_pct_num
332: ,p_mn_dstrbl_val_o => ben_bpp_shd.g_old_rec.mn_dstrbl_val
333: ,p_mx_dstrbl_pct_num_o => ben_bpp_shd.g_old_rec.mx_dstrbl_pct_num
334: ,p_mx_dstrbl_val_o => ben_bpp_shd.g_old_rec.mx_dstrbl_val
335: ,p_excs_trtmt_cd_o => ben_bpp_shd.g_old_rec.excs_trtmt_cd
336: ,p_ptip_id_o => ben_bpp_shd.g_old_rec.ptip_id
329: ,p_mx_dfcit_pct_comp_num_o => ben_bpp_shd.g_old_rec.mx_dfcit_pct_comp_num
330: ,p_comp_lvl_fctr_id_o => ben_bpp_shd.g_old_rec.comp_lvl_fctr_id
331: ,p_mn_dstrbl_pct_num_o => ben_bpp_shd.g_old_rec.mn_dstrbl_pct_num
332: ,p_mn_dstrbl_val_o => ben_bpp_shd.g_old_rec.mn_dstrbl_val
333: ,p_mx_dstrbl_pct_num_o => ben_bpp_shd.g_old_rec.mx_dstrbl_pct_num
334: ,p_mx_dstrbl_val_o => ben_bpp_shd.g_old_rec.mx_dstrbl_val
335: ,p_excs_trtmt_cd_o => ben_bpp_shd.g_old_rec.excs_trtmt_cd
336: ,p_ptip_id_o => ben_bpp_shd.g_old_rec.ptip_id
337: ,p_plip_id_o => ben_bpp_shd.g_old_rec.plip_id
330: ,p_comp_lvl_fctr_id_o => ben_bpp_shd.g_old_rec.comp_lvl_fctr_id
331: ,p_mn_dstrbl_pct_num_o => ben_bpp_shd.g_old_rec.mn_dstrbl_pct_num
332: ,p_mn_dstrbl_val_o => ben_bpp_shd.g_old_rec.mn_dstrbl_val
333: ,p_mx_dstrbl_pct_num_o => ben_bpp_shd.g_old_rec.mx_dstrbl_pct_num
334: ,p_mx_dstrbl_val_o => ben_bpp_shd.g_old_rec.mx_dstrbl_val
335: ,p_excs_trtmt_cd_o => ben_bpp_shd.g_old_rec.excs_trtmt_cd
336: ,p_ptip_id_o => ben_bpp_shd.g_old_rec.ptip_id
337: ,p_plip_id_o => ben_bpp_shd.g_old_rec.plip_id
338: ,p_pgm_id_o => ben_bpp_shd.g_old_rec.pgm_id
331: ,p_mn_dstrbl_pct_num_o => ben_bpp_shd.g_old_rec.mn_dstrbl_pct_num
332: ,p_mn_dstrbl_val_o => ben_bpp_shd.g_old_rec.mn_dstrbl_val
333: ,p_mx_dstrbl_pct_num_o => ben_bpp_shd.g_old_rec.mx_dstrbl_pct_num
334: ,p_mx_dstrbl_val_o => ben_bpp_shd.g_old_rec.mx_dstrbl_val
335: ,p_excs_trtmt_cd_o => ben_bpp_shd.g_old_rec.excs_trtmt_cd
336: ,p_ptip_id_o => ben_bpp_shd.g_old_rec.ptip_id
337: ,p_plip_id_o => ben_bpp_shd.g_old_rec.plip_id
338: ,p_pgm_id_o => ben_bpp_shd.g_old_rec.pgm_id
339: ,p_oiplip_id_o => ben_bpp_shd.g_old_rec.oiplip_id
332: ,p_mn_dstrbl_val_o => ben_bpp_shd.g_old_rec.mn_dstrbl_val
333: ,p_mx_dstrbl_pct_num_o => ben_bpp_shd.g_old_rec.mx_dstrbl_pct_num
334: ,p_mx_dstrbl_val_o => ben_bpp_shd.g_old_rec.mx_dstrbl_val
335: ,p_excs_trtmt_cd_o => ben_bpp_shd.g_old_rec.excs_trtmt_cd
336: ,p_ptip_id_o => ben_bpp_shd.g_old_rec.ptip_id
337: ,p_plip_id_o => ben_bpp_shd.g_old_rec.plip_id
338: ,p_pgm_id_o => ben_bpp_shd.g_old_rec.pgm_id
339: ,p_oiplip_id_o => ben_bpp_shd.g_old_rec.oiplip_id
340: ,p_cmbn_plip_id_o => ben_bpp_shd.g_old_rec.cmbn_plip_id
333: ,p_mx_dstrbl_pct_num_o => ben_bpp_shd.g_old_rec.mx_dstrbl_pct_num
334: ,p_mx_dstrbl_val_o => ben_bpp_shd.g_old_rec.mx_dstrbl_val
335: ,p_excs_trtmt_cd_o => ben_bpp_shd.g_old_rec.excs_trtmt_cd
336: ,p_ptip_id_o => ben_bpp_shd.g_old_rec.ptip_id
337: ,p_plip_id_o => ben_bpp_shd.g_old_rec.plip_id
338: ,p_pgm_id_o => ben_bpp_shd.g_old_rec.pgm_id
339: ,p_oiplip_id_o => ben_bpp_shd.g_old_rec.oiplip_id
340: ,p_cmbn_plip_id_o => ben_bpp_shd.g_old_rec.cmbn_plip_id
341: ,p_cmbn_ptip_id_o => ben_bpp_shd.g_old_rec.cmbn_ptip_id
334: ,p_mx_dstrbl_val_o => ben_bpp_shd.g_old_rec.mx_dstrbl_val
335: ,p_excs_trtmt_cd_o => ben_bpp_shd.g_old_rec.excs_trtmt_cd
336: ,p_ptip_id_o => ben_bpp_shd.g_old_rec.ptip_id
337: ,p_plip_id_o => ben_bpp_shd.g_old_rec.plip_id
338: ,p_pgm_id_o => ben_bpp_shd.g_old_rec.pgm_id
339: ,p_oiplip_id_o => ben_bpp_shd.g_old_rec.oiplip_id
340: ,p_cmbn_plip_id_o => ben_bpp_shd.g_old_rec.cmbn_plip_id
341: ,p_cmbn_ptip_id_o => ben_bpp_shd.g_old_rec.cmbn_ptip_id
342: ,p_cmbn_ptip_opt_id_o => ben_bpp_shd.g_old_rec.cmbn_ptip_opt_id
335: ,p_excs_trtmt_cd_o => ben_bpp_shd.g_old_rec.excs_trtmt_cd
336: ,p_ptip_id_o => ben_bpp_shd.g_old_rec.ptip_id
337: ,p_plip_id_o => ben_bpp_shd.g_old_rec.plip_id
338: ,p_pgm_id_o => ben_bpp_shd.g_old_rec.pgm_id
339: ,p_oiplip_id_o => ben_bpp_shd.g_old_rec.oiplip_id
340: ,p_cmbn_plip_id_o => ben_bpp_shd.g_old_rec.cmbn_plip_id
341: ,p_cmbn_ptip_id_o => ben_bpp_shd.g_old_rec.cmbn_ptip_id
342: ,p_cmbn_ptip_opt_id_o => ben_bpp_shd.g_old_rec.cmbn_ptip_opt_id
343: ,p_business_group_id_o => ben_bpp_shd.g_old_rec.business_group_id
336: ,p_ptip_id_o => ben_bpp_shd.g_old_rec.ptip_id
337: ,p_plip_id_o => ben_bpp_shd.g_old_rec.plip_id
338: ,p_pgm_id_o => ben_bpp_shd.g_old_rec.pgm_id
339: ,p_oiplip_id_o => ben_bpp_shd.g_old_rec.oiplip_id
340: ,p_cmbn_plip_id_o => ben_bpp_shd.g_old_rec.cmbn_plip_id
341: ,p_cmbn_ptip_id_o => ben_bpp_shd.g_old_rec.cmbn_ptip_id
342: ,p_cmbn_ptip_opt_id_o => ben_bpp_shd.g_old_rec.cmbn_ptip_opt_id
343: ,p_business_group_id_o => ben_bpp_shd.g_old_rec.business_group_id
344: ,p_bpp_attribute_category_o => ben_bpp_shd.g_old_rec.bpp_attribute_category
337: ,p_plip_id_o => ben_bpp_shd.g_old_rec.plip_id
338: ,p_pgm_id_o => ben_bpp_shd.g_old_rec.pgm_id
339: ,p_oiplip_id_o => ben_bpp_shd.g_old_rec.oiplip_id
340: ,p_cmbn_plip_id_o => ben_bpp_shd.g_old_rec.cmbn_plip_id
341: ,p_cmbn_ptip_id_o => ben_bpp_shd.g_old_rec.cmbn_ptip_id
342: ,p_cmbn_ptip_opt_id_o => ben_bpp_shd.g_old_rec.cmbn_ptip_opt_id
343: ,p_business_group_id_o => ben_bpp_shd.g_old_rec.business_group_id
344: ,p_bpp_attribute_category_o => ben_bpp_shd.g_old_rec.bpp_attribute_category
345: ,p_bpp_attribute1_o => ben_bpp_shd.g_old_rec.bpp_attribute1
338: ,p_pgm_id_o => ben_bpp_shd.g_old_rec.pgm_id
339: ,p_oiplip_id_o => ben_bpp_shd.g_old_rec.oiplip_id
340: ,p_cmbn_plip_id_o => ben_bpp_shd.g_old_rec.cmbn_plip_id
341: ,p_cmbn_ptip_id_o => ben_bpp_shd.g_old_rec.cmbn_ptip_id
342: ,p_cmbn_ptip_opt_id_o => ben_bpp_shd.g_old_rec.cmbn_ptip_opt_id
343: ,p_business_group_id_o => ben_bpp_shd.g_old_rec.business_group_id
344: ,p_bpp_attribute_category_o => ben_bpp_shd.g_old_rec.bpp_attribute_category
345: ,p_bpp_attribute1_o => ben_bpp_shd.g_old_rec.bpp_attribute1
346: ,p_bpp_attribute2_o => ben_bpp_shd.g_old_rec.bpp_attribute2
339: ,p_oiplip_id_o => ben_bpp_shd.g_old_rec.oiplip_id
340: ,p_cmbn_plip_id_o => ben_bpp_shd.g_old_rec.cmbn_plip_id
341: ,p_cmbn_ptip_id_o => ben_bpp_shd.g_old_rec.cmbn_ptip_id
342: ,p_cmbn_ptip_opt_id_o => ben_bpp_shd.g_old_rec.cmbn_ptip_opt_id
343: ,p_business_group_id_o => ben_bpp_shd.g_old_rec.business_group_id
344: ,p_bpp_attribute_category_o => ben_bpp_shd.g_old_rec.bpp_attribute_category
345: ,p_bpp_attribute1_o => ben_bpp_shd.g_old_rec.bpp_attribute1
346: ,p_bpp_attribute2_o => ben_bpp_shd.g_old_rec.bpp_attribute2
347: ,p_bpp_attribute3_o => ben_bpp_shd.g_old_rec.bpp_attribute3
340: ,p_cmbn_plip_id_o => ben_bpp_shd.g_old_rec.cmbn_plip_id
341: ,p_cmbn_ptip_id_o => ben_bpp_shd.g_old_rec.cmbn_ptip_id
342: ,p_cmbn_ptip_opt_id_o => ben_bpp_shd.g_old_rec.cmbn_ptip_opt_id
343: ,p_business_group_id_o => ben_bpp_shd.g_old_rec.business_group_id
344: ,p_bpp_attribute_category_o => ben_bpp_shd.g_old_rec.bpp_attribute_category
345: ,p_bpp_attribute1_o => ben_bpp_shd.g_old_rec.bpp_attribute1
346: ,p_bpp_attribute2_o => ben_bpp_shd.g_old_rec.bpp_attribute2
347: ,p_bpp_attribute3_o => ben_bpp_shd.g_old_rec.bpp_attribute3
348: ,p_bpp_attribute4_o => ben_bpp_shd.g_old_rec.bpp_attribute4
341: ,p_cmbn_ptip_id_o => ben_bpp_shd.g_old_rec.cmbn_ptip_id
342: ,p_cmbn_ptip_opt_id_o => ben_bpp_shd.g_old_rec.cmbn_ptip_opt_id
343: ,p_business_group_id_o => ben_bpp_shd.g_old_rec.business_group_id
344: ,p_bpp_attribute_category_o => ben_bpp_shd.g_old_rec.bpp_attribute_category
345: ,p_bpp_attribute1_o => ben_bpp_shd.g_old_rec.bpp_attribute1
346: ,p_bpp_attribute2_o => ben_bpp_shd.g_old_rec.bpp_attribute2
347: ,p_bpp_attribute3_o => ben_bpp_shd.g_old_rec.bpp_attribute3
348: ,p_bpp_attribute4_o => ben_bpp_shd.g_old_rec.bpp_attribute4
349: ,p_bpp_attribute5_o => ben_bpp_shd.g_old_rec.bpp_attribute5
342: ,p_cmbn_ptip_opt_id_o => ben_bpp_shd.g_old_rec.cmbn_ptip_opt_id
343: ,p_business_group_id_o => ben_bpp_shd.g_old_rec.business_group_id
344: ,p_bpp_attribute_category_o => ben_bpp_shd.g_old_rec.bpp_attribute_category
345: ,p_bpp_attribute1_o => ben_bpp_shd.g_old_rec.bpp_attribute1
346: ,p_bpp_attribute2_o => ben_bpp_shd.g_old_rec.bpp_attribute2
347: ,p_bpp_attribute3_o => ben_bpp_shd.g_old_rec.bpp_attribute3
348: ,p_bpp_attribute4_o => ben_bpp_shd.g_old_rec.bpp_attribute4
349: ,p_bpp_attribute5_o => ben_bpp_shd.g_old_rec.bpp_attribute5
350: ,p_bpp_attribute6_o => ben_bpp_shd.g_old_rec.bpp_attribute6
343: ,p_business_group_id_o => ben_bpp_shd.g_old_rec.business_group_id
344: ,p_bpp_attribute_category_o => ben_bpp_shd.g_old_rec.bpp_attribute_category
345: ,p_bpp_attribute1_o => ben_bpp_shd.g_old_rec.bpp_attribute1
346: ,p_bpp_attribute2_o => ben_bpp_shd.g_old_rec.bpp_attribute2
347: ,p_bpp_attribute3_o => ben_bpp_shd.g_old_rec.bpp_attribute3
348: ,p_bpp_attribute4_o => ben_bpp_shd.g_old_rec.bpp_attribute4
349: ,p_bpp_attribute5_o => ben_bpp_shd.g_old_rec.bpp_attribute5
350: ,p_bpp_attribute6_o => ben_bpp_shd.g_old_rec.bpp_attribute6
351: ,p_bpp_attribute7_o => ben_bpp_shd.g_old_rec.bpp_attribute7
344: ,p_bpp_attribute_category_o => ben_bpp_shd.g_old_rec.bpp_attribute_category
345: ,p_bpp_attribute1_o => ben_bpp_shd.g_old_rec.bpp_attribute1
346: ,p_bpp_attribute2_o => ben_bpp_shd.g_old_rec.bpp_attribute2
347: ,p_bpp_attribute3_o => ben_bpp_shd.g_old_rec.bpp_attribute3
348: ,p_bpp_attribute4_o => ben_bpp_shd.g_old_rec.bpp_attribute4
349: ,p_bpp_attribute5_o => ben_bpp_shd.g_old_rec.bpp_attribute5
350: ,p_bpp_attribute6_o => ben_bpp_shd.g_old_rec.bpp_attribute6
351: ,p_bpp_attribute7_o => ben_bpp_shd.g_old_rec.bpp_attribute7
352: ,p_bpp_attribute8_o => ben_bpp_shd.g_old_rec.bpp_attribute8
345: ,p_bpp_attribute1_o => ben_bpp_shd.g_old_rec.bpp_attribute1
346: ,p_bpp_attribute2_o => ben_bpp_shd.g_old_rec.bpp_attribute2
347: ,p_bpp_attribute3_o => ben_bpp_shd.g_old_rec.bpp_attribute3
348: ,p_bpp_attribute4_o => ben_bpp_shd.g_old_rec.bpp_attribute4
349: ,p_bpp_attribute5_o => ben_bpp_shd.g_old_rec.bpp_attribute5
350: ,p_bpp_attribute6_o => ben_bpp_shd.g_old_rec.bpp_attribute6
351: ,p_bpp_attribute7_o => ben_bpp_shd.g_old_rec.bpp_attribute7
352: ,p_bpp_attribute8_o => ben_bpp_shd.g_old_rec.bpp_attribute8
353: ,p_bpp_attribute9_o => ben_bpp_shd.g_old_rec.bpp_attribute9
346: ,p_bpp_attribute2_o => ben_bpp_shd.g_old_rec.bpp_attribute2
347: ,p_bpp_attribute3_o => ben_bpp_shd.g_old_rec.bpp_attribute3
348: ,p_bpp_attribute4_o => ben_bpp_shd.g_old_rec.bpp_attribute4
349: ,p_bpp_attribute5_o => ben_bpp_shd.g_old_rec.bpp_attribute5
350: ,p_bpp_attribute6_o => ben_bpp_shd.g_old_rec.bpp_attribute6
351: ,p_bpp_attribute7_o => ben_bpp_shd.g_old_rec.bpp_attribute7
352: ,p_bpp_attribute8_o => ben_bpp_shd.g_old_rec.bpp_attribute8
353: ,p_bpp_attribute9_o => ben_bpp_shd.g_old_rec.bpp_attribute9
354: ,p_bpp_attribute10_o => ben_bpp_shd.g_old_rec.bpp_attribute10
347: ,p_bpp_attribute3_o => ben_bpp_shd.g_old_rec.bpp_attribute3
348: ,p_bpp_attribute4_o => ben_bpp_shd.g_old_rec.bpp_attribute4
349: ,p_bpp_attribute5_o => ben_bpp_shd.g_old_rec.bpp_attribute5
350: ,p_bpp_attribute6_o => ben_bpp_shd.g_old_rec.bpp_attribute6
351: ,p_bpp_attribute7_o => ben_bpp_shd.g_old_rec.bpp_attribute7
352: ,p_bpp_attribute8_o => ben_bpp_shd.g_old_rec.bpp_attribute8
353: ,p_bpp_attribute9_o => ben_bpp_shd.g_old_rec.bpp_attribute9
354: ,p_bpp_attribute10_o => ben_bpp_shd.g_old_rec.bpp_attribute10
355: ,p_bpp_attribute11_o => ben_bpp_shd.g_old_rec.bpp_attribute11
348: ,p_bpp_attribute4_o => ben_bpp_shd.g_old_rec.bpp_attribute4
349: ,p_bpp_attribute5_o => ben_bpp_shd.g_old_rec.bpp_attribute5
350: ,p_bpp_attribute6_o => ben_bpp_shd.g_old_rec.bpp_attribute6
351: ,p_bpp_attribute7_o => ben_bpp_shd.g_old_rec.bpp_attribute7
352: ,p_bpp_attribute8_o => ben_bpp_shd.g_old_rec.bpp_attribute8
353: ,p_bpp_attribute9_o => ben_bpp_shd.g_old_rec.bpp_attribute9
354: ,p_bpp_attribute10_o => ben_bpp_shd.g_old_rec.bpp_attribute10
355: ,p_bpp_attribute11_o => ben_bpp_shd.g_old_rec.bpp_attribute11
356: ,p_bpp_attribute12_o => ben_bpp_shd.g_old_rec.bpp_attribute12
349: ,p_bpp_attribute5_o => ben_bpp_shd.g_old_rec.bpp_attribute5
350: ,p_bpp_attribute6_o => ben_bpp_shd.g_old_rec.bpp_attribute6
351: ,p_bpp_attribute7_o => ben_bpp_shd.g_old_rec.bpp_attribute7
352: ,p_bpp_attribute8_o => ben_bpp_shd.g_old_rec.bpp_attribute8
353: ,p_bpp_attribute9_o => ben_bpp_shd.g_old_rec.bpp_attribute9
354: ,p_bpp_attribute10_o => ben_bpp_shd.g_old_rec.bpp_attribute10
355: ,p_bpp_attribute11_o => ben_bpp_shd.g_old_rec.bpp_attribute11
356: ,p_bpp_attribute12_o => ben_bpp_shd.g_old_rec.bpp_attribute12
357: ,p_bpp_attribute13_o => ben_bpp_shd.g_old_rec.bpp_attribute13
350: ,p_bpp_attribute6_o => ben_bpp_shd.g_old_rec.bpp_attribute6
351: ,p_bpp_attribute7_o => ben_bpp_shd.g_old_rec.bpp_attribute7
352: ,p_bpp_attribute8_o => ben_bpp_shd.g_old_rec.bpp_attribute8
353: ,p_bpp_attribute9_o => ben_bpp_shd.g_old_rec.bpp_attribute9
354: ,p_bpp_attribute10_o => ben_bpp_shd.g_old_rec.bpp_attribute10
355: ,p_bpp_attribute11_o => ben_bpp_shd.g_old_rec.bpp_attribute11
356: ,p_bpp_attribute12_o => ben_bpp_shd.g_old_rec.bpp_attribute12
357: ,p_bpp_attribute13_o => ben_bpp_shd.g_old_rec.bpp_attribute13
358: ,p_bpp_attribute14_o => ben_bpp_shd.g_old_rec.bpp_attribute14
351: ,p_bpp_attribute7_o => ben_bpp_shd.g_old_rec.bpp_attribute7
352: ,p_bpp_attribute8_o => ben_bpp_shd.g_old_rec.bpp_attribute8
353: ,p_bpp_attribute9_o => ben_bpp_shd.g_old_rec.bpp_attribute9
354: ,p_bpp_attribute10_o => ben_bpp_shd.g_old_rec.bpp_attribute10
355: ,p_bpp_attribute11_o => ben_bpp_shd.g_old_rec.bpp_attribute11
356: ,p_bpp_attribute12_o => ben_bpp_shd.g_old_rec.bpp_attribute12
357: ,p_bpp_attribute13_o => ben_bpp_shd.g_old_rec.bpp_attribute13
358: ,p_bpp_attribute14_o => ben_bpp_shd.g_old_rec.bpp_attribute14
359: ,p_bpp_attribute15_o => ben_bpp_shd.g_old_rec.bpp_attribute15
352: ,p_bpp_attribute8_o => ben_bpp_shd.g_old_rec.bpp_attribute8
353: ,p_bpp_attribute9_o => ben_bpp_shd.g_old_rec.bpp_attribute9
354: ,p_bpp_attribute10_o => ben_bpp_shd.g_old_rec.bpp_attribute10
355: ,p_bpp_attribute11_o => ben_bpp_shd.g_old_rec.bpp_attribute11
356: ,p_bpp_attribute12_o => ben_bpp_shd.g_old_rec.bpp_attribute12
357: ,p_bpp_attribute13_o => ben_bpp_shd.g_old_rec.bpp_attribute13
358: ,p_bpp_attribute14_o => ben_bpp_shd.g_old_rec.bpp_attribute14
359: ,p_bpp_attribute15_o => ben_bpp_shd.g_old_rec.bpp_attribute15
360: ,p_bpp_attribute16_o => ben_bpp_shd.g_old_rec.bpp_attribute16
353: ,p_bpp_attribute9_o => ben_bpp_shd.g_old_rec.bpp_attribute9
354: ,p_bpp_attribute10_o => ben_bpp_shd.g_old_rec.bpp_attribute10
355: ,p_bpp_attribute11_o => ben_bpp_shd.g_old_rec.bpp_attribute11
356: ,p_bpp_attribute12_o => ben_bpp_shd.g_old_rec.bpp_attribute12
357: ,p_bpp_attribute13_o => ben_bpp_shd.g_old_rec.bpp_attribute13
358: ,p_bpp_attribute14_o => ben_bpp_shd.g_old_rec.bpp_attribute14
359: ,p_bpp_attribute15_o => ben_bpp_shd.g_old_rec.bpp_attribute15
360: ,p_bpp_attribute16_o => ben_bpp_shd.g_old_rec.bpp_attribute16
361: ,p_bpp_attribute17_o => ben_bpp_shd.g_old_rec.bpp_attribute17
354: ,p_bpp_attribute10_o => ben_bpp_shd.g_old_rec.bpp_attribute10
355: ,p_bpp_attribute11_o => ben_bpp_shd.g_old_rec.bpp_attribute11
356: ,p_bpp_attribute12_o => ben_bpp_shd.g_old_rec.bpp_attribute12
357: ,p_bpp_attribute13_o => ben_bpp_shd.g_old_rec.bpp_attribute13
358: ,p_bpp_attribute14_o => ben_bpp_shd.g_old_rec.bpp_attribute14
359: ,p_bpp_attribute15_o => ben_bpp_shd.g_old_rec.bpp_attribute15
360: ,p_bpp_attribute16_o => ben_bpp_shd.g_old_rec.bpp_attribute16
361: ,p_bpp_attribute17_o => ben_bpp_shd.g_old_rec.bpp_attribute17
362: ,p_bpp_attribute18_o => ben_bpp_shd.g_old_rec.bpp_attribute18
355: ,p_bpp_attribute11_o => ben_bpp_shd.g_old_rec.bpp_attribute11
356: ,p_bpp_attribute12_o => ben_bpp_shd.g_old_rec.bpp_attribute12
357: ,p_bpp_attribute13_o => ben_bpp_shd.g_old_rec.bpp_attribute13
358: ,p_bpp_attribute14_o => ben_bpp_shd.g_old_rec.bpp_attribute14
359: ,p_bpp_attribute15_o => ben_bpp_shd.g_old_rec.bpp_attribute15
360: ,p_bpp_attribute16_o => ben_bpp_shd.g_old_rec.bpp_attribute16
361: ,p_bpp_attribute17_o => ben_bpp_shd.g_old_rec.bpp_attribute17
362: ,p_bpp_attribute18_o => ben_bpp_shd.g_old_rec.bpp_attribute18
363: ,p_bpp_attribute19_o => ben_bpp_shd.g_old_rec.bpp_attribute19
356: ,p_bpp_attribute12_o => ben_bpp_shd.g_old_rec.bpp_attribute12
357: ,p_bpp_attribute13_o => ben_bpp_shd.g_old_rec.bpp_attribute13
358: ,p_bpp_attribute14_o => ben_bpp_shd.g_old_rec.bpp_attribute14
359: ,p_bpp_attribute15_o => ben_bpp_shd.g_old_rec.bpp_attribute15
360: ,p_bpp_attribute16_o => ben_bpp_shd.g_old_rec.bpp_attribute16
361: ,p_bpp_attribute17_o => ben_bpp_shd.g_old_rec.bpp_attribute17
362: ,p_bpp_attribute18_o => ben_bpp_shd.g_old_rec.bpp_attribute18
363: ,p_bpp_attribute19_o => ben_bpp_shd.g_old_rec.bpp_attribute19
364: ,p_bpp_attribute20_o => ben_bpp_shd.g_old_rec.bpp_attribute20
357: ,p_bpp_attribute13_o => ben_bpp_shd.g_old_rec.bpp_attribute13
358: ,p_bpp_attribute14_o => ben_bpp_shd.g_old_rec.bpp_attribute14
359: ,p_bpp_attribute15_o => ben_bpp_shd.g_old_rec.bpp_attribute15
360: ,p_bpp_attribute16_o => ben_bpp_shd.g_old_rec.bpp_attribute16
361: ,p_bpp_attribute17_o => ben_bpp_shd.g_old_rec.bpp_attribute17
362: ,p_bpp_attribute18_o => ben_bpp_shd.g_old_rec.bpp_attribute18
363: ,p_bpp_attribute19_o => ben_bpp_shd.g_old_rec.bpp_attribute19
364: ,p_bpp_attribute20_o => ben_bpp_shd.g_old_rec.bpp_attribute20
365: ,p_bpp_attribute21_o => ben_bpp_shd.g_old_rec.bpp_attribute21
358: ,p_bpp_attribute14_o => ben_bpp_shd.g_old_rec.bpp_attribute14
359: ,p_bpp_attribute15_o => ben_bpp_shd.g_old_rec.bpp_attribute15
360: ,p_bpp_attribute16_o => ben_bpp_shd.g_old_rec.bpp_attribute16
361: ,p_bpp_attribute17_o => ben_bpp_shd.g_old_rec.bpp_attribute17
362: ,p_bpp_attribute18_o => ben_bpp_shd.g_old_rec.bpp_attribute18
363: ,p_bpp_attribute19_o => ben_bpp_shd.g_old_rec.bpp_attribute19
364: ,p_bpp_attribute20_o => ben_bpp_shd.g_old_rec.bpp_attribute20
365: ,p_bpp_attribute21_o => ben_bpp_shd.g_old_rec.bpp_attribute21
366: ,p_bpp_attribute22_o => ben_bpp_shd.g_old_rec.bpp_attribute22
359: ,p_bpp_attribute15_o => ben_bpp_shd.g_old_rec.bpp_attribute15
360: ,p_bpp_attribute16_o => ben_bpp_shd.g_old_rec.bpp_attribute16
361: ,p_bpp_attribute17_o => ben_bpp_shd.g_old_rec.bpp_attribute17
362: ,p_bpp_attribute18_o => ben_bpp_shd.g_old_rec.bpp_attribute18
363: ,p_bpp_attribute19_o => ben_bpp_shd.g_old_rec.bpp_attribute19
364: ,p_bpp_attribute20_o => ben_bpp_shd.g_old_rec.bpp_attribute20
365: ,p_bpp_attribute21_o => ben_bpp_shd.g_old_rec.bpp_attribute21
366: ,p_bpp_attribute22_o => ben_bpp_shd.g_old_rec.bpp_attribute22
367: ,p_bpp_attribute23_o => ben_bpp_shd.g_old_rec.bpp_attribute23
360: ,p_bpp_attribute16_o => ben_bpp_shd.g_old_rec.bpp_attribute16
361: ,p_bpp_attribute17_o => ben_bpp_shd.g_old_rec.bpp_attribute17
362: ,p_bpp_attribute18_o => ben_bpp_shd.g_old_rec.bpp_attribute18
363: ,p_bpp_attribute19_o => ben_bpp_shd.g_old_rec.bpp_attribute19
364: ,p_bpp_attribute20_o => ben_bpp_shd.g_old_rec.bpp_attribute20
365: ,p_bpp_attribute21_o => ben_bpp_shd.g_old_rec.bpp_attribute21
366: ,p_bpp_attribute22_o => ben_bpp_shd.g_old_rec.bpp_attribute22
367: ,p_bpp_attribute23_o => ben_bpp_shd.g_old_rec.bpp_attribute23
368: ,p_bpp_attribute24_o => ben_bpp_shd.g_old_rec.bpp_attribute24
361: ,p_bpp_attribute17_o => ben_bpp_shd.g_old_rec.bpp_attribute17
362: ,p_bpp_attribute18_o => ben_bpp_shd.g_old_rec.bpp_attribute18
363: ,p_bpp_attribute19_o => ben_bpp_shd.g_old_rec.bpp_attribute19
364: ,p_bpp_attribute20_o => ben_bpp_shd.g_old_rec.bpp_attribute20
365: ,p_bpp_attribute21_o => ben_bpp_shd.g_old_rec.bpp_attribute21
366: ,p_bpp_attribute22_o => ben_bpp_shd.g_old_rec.bpp_attribute22
367: ,p_bpp_attribute23_o => ben_bpp_shd.g_old_rec.bpp_attribute23
368: ,p_bpp_attribute24_o => ben_bpp_shd.g_old_rec.bpp_attribute24
369: ,p_bpp_attribute25_o => ben_bpp_shd.g_old_rec.bpp_attribute25
362: ,p_bpp_attribute18_o => ben_bpp_shd.g_old_rec.bpp_attribute18
363: ,p_bpp_attribute19_o => ben_bpp_shd.g_old_rec.bpp_attribute19
364: ,p_bpp_attribute20_o => ben_bpp_shd.g_old_rec.bpp_attribute20
365: ,p_bpp_attribute21_o => ben_bpp_shd.g_old_rec.bpp_attribute21
366: ,p_bpp_attribute22_o => ben_bpp_shd.g_old_rec.bpp_attribute22
367: ,p_bpp_attribute23_o => ben_bpp_shd.g_old_rec.bpp_attribute23
368: ,p_bpp_attribute24_o => ben_bpp_shd.g_old_rec.bpp_attribute24
369: ,p_bpp_attribute25_o => ben_bpp_shd.g_old_rec.bpp_attribute25
370: ,p_bpp_attribute26_o => ben_bpp_shd.g_old_rec.bpp_attribute26
363: ,p_bpp_attribute19_o => ben_bpp_shd.g_old_rec.bpp_attribute19
364: ,p_bpp_attribute20_o => ben_bpp_shd.g_old_rec.bpp_attribute20
365: ,p_bpp_attribute21_o => ben_bpp_shd.g_old_rec.bpp_attribute21
366: ,p_bpp_attribute22_o => ben_bpp_shd.g_old_rec.bpp_attribute22
367: ,p_bpp_attribute23_o => ben_bpp_shd.g_old_rec.bpp_attribute23
368: ,p_bpp_attribute24_o => ben_bpp_shd.g_old_rec.bpp_attribute24
369: ,p_bpp_attribute25_o => ben_bpp_shd.g_old_rec.bpp_attribute25
370: ,p_bpp_attribute26_o => ben_bpp_shd.g_old_rec.bpp_attribute26
371: ,p_bpp_attribute27_o => ben_bpp_shd.g_old_rec.bpp_attribute27
364: ,p_bpp_attribute20_o => ben_bpp_shd.g_old_rec.bpp_attribute20
365: ,p_bpp_attribute21_o => ben_bpp_shd.g_old_rec.bpp_attribute21
366: ,p_bpp_attribute22_o => ben_bpp_shd.g_old_rec.bpp_attribute22
367: ,p_bpp_attribute23_o => ben_bpp_shd.g_old_rec.bpp_attribute23
368: ,p_bpp_attribute24_o => ben_bpp_shd.g_old_rec.bpp_attribute24
369: ,p_bpp_attribute25_o => ben_bpp_shd.g_old_rec.bpp_attribute25
370: ,p_bpp_attribute26_o => ben_bpp_shd.g_old_rec.bpp_attribute26
371: ,p_bpp_attribute27_o => ben_bpp_shd.g_old_rec.bpp_attribute27
372: ,p_bpp_attribute28_o => ben_bpp_shd.g_old_rec.bpp_attribute28
365: ,p_bpp_attribute21_o => ben_bpp_shd.g_old_rec.bpp_attribute21
366: ,p_bpp_attribute22_o => ben_bpp_shd.g_old_rec.bpp_attribute22
367: ,p_bpp_attribute23_o => ben_bpp_shd.g_old_rec.bpp_attribute23
368: ,p_bpp_attribute24_o => ben_bpp_shd.g_old_rec.bpp_attribute24
369: ,p_bpp_attribute25_o => ben_bpp_shd.g_old_rec.bpp_attribute25
370: ,p_bpp_attribute26_o => ben_bpp_shd.g_old_rec.bpp_attribute26
371: ,p_bpp_attribute27_o => ben_bpp_shd.g_old_rec.bpp_attribute27
372: ,p_bpp_attribute28_o => ben_bpp_shd.g_old_rec.bpp_attribute28
373: ,p_bpp_attribute29_o => ben_bpp_shd.g_old_rec.bpp_attribute29
366: ,p_bpp_attribute22_o => ben_bpp_shd.g_old_rec.bpp_attribute22
367: ,p_bpp_attribute23_o => ben_bpp_shd.g_old_rec.bpp_attribute23
368: ,p_bpp_attribute24_o => ben_bpp_shd.g_old_rec.bpp_attribute24
369: ,p_bpp_attribute25_o => ben_bpp_shd.g_old_rec.bpp_attribute25
370: ,p_bpp_attribute26_o => ben_bpp_shd.g_old_rec.bpp_attribute26
371: ,p_bpp_attribute27_o => ben_bpp_shd.g_old_rec.bpp_attribute27
372: ,p_bpp_attribute28_o => ben_bpp_shd.g_old_rec.bpp_attribute28
373: ,p_bpp_attribute29_o => ben_bpp_shd.g_old_rec.bpp_attribute29
374: ,p_bpp_attribute30_o => ben_bpp_shd.g_old_rec.bpp_attribute30
367: ,p_bpp_attribute23_o => ben_bpp_shd.g_old_rec.bpp_attribute23
368: ,p_bpp_attribute24_o => ben_bpp_shd.g_old_rec.bpp_attribute24
369: ,p_bpp_attribute25_o => ben_bpp_shd.g_old_rec.bpp_attribute25
370: ,p_bpp_attribute26_o => ben_bpp_shd.g_old_rec.bpp_attribute26
371: ,p_bpp_attribute27_o => ben_bpp_shd.g_old_rec.bpp_attribute27
372: ,p_bpp_attribute28_o => ben_bpp_shd.g_old_rec.bpp_attribute28
373: ,p_bpp_attribute29_o => ben_bpp_shd.g_old_rec.bpp_attribute29
374: ,p_bpp_attribute30_o => ben_bpp_shd.g_old_rec.bpp_attribute30
375: ,p_object_version_number_o => ben_bpp_shd.g_old_rec.object_version_number
368: ,p_bpp_attribute24_o => ben_bpp_shd.g_old_rec.bpp_attribute24
369: ,p_bpp_attribute25_o => ben_bpp_shd.g_old_rec.bpp_attribute25
370: ,p_bpp_attribute26_o => ben_bpp_shd.g_old_rec.bpp_attribute26
371: ,p_bpp_attribute27_o => ben_bpp_shd.g_old_rec.bpp_attribute27
372: ,p_bpp_attribute28_o => ben_bpp_shd.g_old_rec.bpp_attribute28
373: ,p_bpp_attribute29_o => ben_bpp_shd.g_old_rec.bpp_attribute29
374: ,p_bpp_attribute30_o => ben_bpp_shd.g_old_rec.bpp_attribute30
375: ,p_object_version_number_o => ben_bpp_shd.g_old_rec.object_version_number
376: );
369: ,p_bpp_attribute25_o => ben_bpp_shd.g_old_rec.bpp_attribute25
370: ,p_bpp_attribute26_o => ben_bpp_shd.g_old_rec.bpp_attribute26
371: ,p_bpp_attribute27_o => ben_bpp_shd.g_old_rec.bpp_attribute27
372: ,p_bpp_attribute28_o => ben_bpp_shd.g_old_rec.bpp_attribute28
373: ,p_bpp_attribute29_o => ben_bpp_shd.g_old_rec.bpp_attribute29
374: ,p_bpp_attribute30_o => ben_bpp_shd.g_old_rec.bpp_attribute30
375: ,p_object_version_number_o => ben_bpp_shd.g_old_rec.object_version_number
376: );
377: --
370: ,p_bpp_attribute26_o => ben_bpp_shd.g_old_rec.bpp_attribute26
371: ,p_bpp_attribute27_o => ben_bpp_shd.g_old_rec.bpp_attribute27
372: ,p_bpp_attribute28_o => ben_bpp_shd.g_old_rec.bpp_attribute28
373: ,p_bpp_attribute29_o => ben_bpp_shd.g_old_rec.bpp_attribute29
374: ,p_bpp_attribute30_o => ben_bpp_shd.g_old_rec.bpp_attribute30
375: ,p_object_version_number_o => ben_bpp_shd.g_old_rec.object_version_number
376: );
377: --
378: exception
371: ,p_bpp_attribute27_o => ben_bpp_shd.g_old_rec.bpp_attribute27
372: ,p_bpp_attribute28_o => ben_bpp_shd.g_old_rec.bpp_attribute28
373: ,p_bpp_attribute29_o => ben_bpp_shd.g_old_rec.bpp_attribute29
374: ,p_bpp_attribute30_o => ben_bpp_shd.g_old_rec.bpp_attribute30
375: ,p_object_version_number_o => ben_bpp_shd.g_old_rec.object_version_number
376: );
377: --
378: exception
379: --
394: -- |---------------------------------< del >----------------------------------|
395: -- ----------------------------------------------------------------------------
396: Procedure del
397: (
398: p_rec in out nocopy ben_bpp_shd.g_rec_type,
399: p_effective_date in date,
400: p_datetrack_mode in varchar2
401: ) is
402: --
412: dt_api.validate_dt_del_mode(p_datetrack_mode => p_datetrack_mode);
413: --
414: -- We must lock the row which we need to delete.
415: --
416: ben_bpp_shd.lck
417: (p_effective_date => p_effective_date,
418: p_datetrack_mode => p_datetrack_mode,
419: p_bnft_prvdr_pool_id => p_rec.bnft_prvdr_pool_id,
420: p_object_version_number => p_rec.object_version_number,
470: p_effective_date in date,
471: p_datetrack_mode in varchar2
472: ) is
473: --
474: l_rec ben_bpp_shd.g_rec_type;
475: l_proc varchar2(72) := g_package||'del';
476: --
477: Begin
478: hr_utility.set_location('Entering:'||l_proc, 5);