50: --
51: -- {End Of Comments}
52: -- ----------------------------------------------------------------------------
53: Procedure dt_delete_dml
54: (p_rec in out nocopy ben_ler_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_ler_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: --
75: delete from ben_ler_f_tl
76: where ler_id = p_rec.ler_id
77: and effective_start_date = p_validation_start_date;
78: --
79: ben_ler_shd.g_api_dml := false; -- Unset the api dml status
80: Else
81: hr_utility.set_location(l_proc, 15);
82: ben_ler_shd.g_api_dml := true; -- Set the api dml status
83: --
78: --
79: ben_ler_shd.g_api_dml := false; -- Unset the api dml status
80: Else
81: hr_utility.set_location(l_proc, 15);
82: ben_ler_shd.g_api_dml := true; -- Set the api dml status
83: --
84: -- Delete the row(s) where the effective start date is greater than
85: -- or equal to the validation start date.
86: --
91: delete from ben_ler_f_tl
92: where ler_id = p_rec.ler_id
93: and effective_start_date >= p_validation_start_date;
94: --
95: ben_ler_shd.g_api_dml := false; -- Unset the api dml status
96: End If;
97: --
98: hr_utility.set_location(' Leaving:'||l_proc, 20);
99: --
98: hr_utility.set_location(' Leaving:'||l_proc, 20);
99: --
100: Exception
101: When Others Then
102: ben_ler_shd.g_api_dml := false; -- Unset the api dml status
103: Raise;
104: End dt_delete_dml;
105: --
106: -- ----------------------------------------------------------------------------
106: -- ----------------------------------------------------------------------------
107: -- |------------------------------< delete_dml >------------------------------|
108: -- ----------------------------------------------------------------------------
109: Procedure delete_dml
110: (p_rec in out nocopy ben_ler_shd.g_rec_type,
111: p_effective_date in date,
112: p_datetrack_mode in varchar2,
113: p_validation_start_date in date,
114: p_validation_end_date in date) is
160: --
161: -- {End Of Comments}
162: -- ----------------------------------------------------------------------------
163: Procedure dt_pre_delete
164: (p_rec in out nocopy ben_ler_shd.g_rec_type,
165: p_effective_date in date,
166: p_datetrack_mode in varchar2,
167: p_validation_start_date in date,
168: p_validation_end_date in date) is
173: hr_utility.set_location('Entering:'||l_proc, 5);
174: --
175: If (p_datetrack_mode <> 'ZAP') then
176: --
177: p_rec.effective_start_date := ben_ler_shd.g_old_rec.effective_start_date;
178: --
179: If (p_datetrack_mode = 'DELETE') then
180: p_rec.effective_end_date := p_validation_start_date - 1;
181: Else
183: End If;
184: --
185: -- Update the current effective end date record
186: --
187: ben_ler_shd.upd_effective_end_date
188: (p_effective_date => p_effective_date,
189: p_base_key_value => p_rec.ler_id,
190: p_new_effective_end_date => p_rec.effective_end_date,
191: p_validation_start_date => p_validation_start_date,
231: --
232: -- {End Of Comments}
233: -- ----------------------------------------------------------------------------
234: Procedure pre_delete
235: (p_rec in out nocopy ben_ler_shd.g_rec_type,
236: p_effective_date in date,
237: p_datetrack_mode in varchar2,
238: p_validation_start_date in date,
239: p_validation_end_date in date) is
289: --
290: -- {End Of Comments}
291: -- ----------------------------------------------------------------------------
292: Procedure post_delete
293: (p_rec in ben_ler_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
313: ,p_validation_start_date =>p_validation_start_date
314: ,p_validation_end_date =>p_validation_end_date
315: ,p_effective_start_date =>p_rec.effective_start_date
316: ,p_effective_end_date =>p_rec.effective_end_date
317: ,p_effective_start_date_o =>ben_ler_shd.g_old_rec.effective_start_date
318: ,p_effective_end_date_o =>ben_ler_shd.g_old_rec.effective_end_date
319: ,p_name_o =>ben_ler_shd.g_old_rec.name
320: ,p_business_group_id_o =>ben_ler_shd.g_old_rec.business_group_id
321: ,p_typ_cd_o =>ben_ler_shd.g_old_rec.typ_cd
314: ,p_validation_end_date =>p_validation_end_date
315: ,p_effective_start_date =>p_rec.effective_start_date
316: ,p_effective_end_date =>p_rec.effective_end_date
317: ,p_effective_start_date_o =>ben_ler_shd.g_old_rec.effective_start_date
318: ,p_effective_end_date_o =>ben_ler_shd.g_old_rec.effective_end_date
319: ,p_name_o =>ben_ler_shd.g_old_rec.name
320: ,p_business_group_id_o =>ben_ler_shd.g_old_rec.business_group_id
321: ,p_typ_cd_o =>ben_ler_shd.g_old_rec.typ_cd
322: ,p_lf_evt_oper_cd_o =>ben_ler_shd.g_old_rec.lf_evt_oper_cd
315: ,p_effective_start_date =>p_rec.effective_start_date
316: ,p_effective_end_date =>p_rec.effective_end_date
317: ,p_effective_start_date_o =>ben_ler_shd.g_old_rec.effective_start_date
318: ,p_effective_end_date_o =>ben_ler_shd.g_old_rec.effective_end_date
319: ,p_name_o =>ben_ler_shd.g_old_rec.name
320: ,p_business_group_id_o =>ben_ler_shd.g_old_rec.business_group_id
321: ,p_typ_cd_o =>ben_ler_shd.g_old_rec.typ_cd
322: ,p_lf_evt_oper_cd_o =>ben_ler_shd.g_old_rec.lf_evt_oper_cd
323: ,p_short_name_o =>ben_ler_shd.g_old_rec.short_name
316: ,p_effective_end_date =>p_rec.effective_end_date
317: ,p_effective_start_date_o =>ben_ler_shd.g_old_rec.effective_start_date
318: ,p_effective_end_date_o =>ben_ler_shd.g_old_rec.effective_end_date
319: ,p_name_o =>ben_ler_shd.g_old_rec.name
320: ,p_business_group_id_o =>ben_ler_shd.g_old_rec.business_group_id
321: ,p_typ_cd_o =>ben_ler_shd.g_old_rec.typ_cd
322: ,p_lf_evt_oper_cd_o =>ben_ler_shd.g_old_rec.lf_evt_oper_cd
323: ,p_short_name_o =>ben_ler_shd.g_old_rec.short_name
324: ,p_short_code_o =>ben_ler_shd.g_old_rec.short_code
317: ,p_effective_start_date_o =>ben_ler_shd.g_old_rec.effective_start_date
318: ,p_effective_end_date_o =>ben_ler_shd.g_old_rec.effective_end_date
319: ,p_name_o =>ben_ler_shd.g_old_rec.name
320: ,p_business_group_id_o =>ben_ler_shd.g_old_rec.business_group_id
321: ,p_typ_cd_o =>ben_ler_shd.g_old_rec.typ_cd
322: ,p_lf_evt_oper_cd_o =>ben_ler_shd.g_old_rec.lf_evt_oper_cd
323: ,p_short_name_o =>ben_ler_shd.g_old_rec.short_name
324: ,p_short_code_o =>ben_ler_shd.g_old_rec.short_code
325: ,p_ptnl_ler_trtmt_cd_o =>ben_ler_shd.g_old_rec.ptnl_ler_trtmt_cd
318: ,p_effective_end_date_o =>ben_ler_shd.g_old_rec.effective_end_date
319: ,p_name_o =>ben_ler_shd.g_old_rec.name
320: ,p_business_group_id_o =>ben_ler_shd.g_old_rec.business_group_id
321: ,p_typ_cd_o =>ben_ler_shd.g_old_rec.typ_cd
322: ,p_lf_evt_oper_cd_o =>ben_ler_shd.g_old_rec.lf_evt_oper_cd
323: ,p_short_name_o =>ben_ler_shd.g_old_rec.short_name
324: ,p_short_code_o =>ben_ler_shd.g_old_rec.short_code
325: ,p_ptnl_ler_trtmt_cd_o =>ben_ler_shd.g_old_rec.ptnl_ler_trtmt_cd
326: ,p_ck_rltd_per_elig_flag_o =>ben_ler_shd.g_old_rec.ck_rltd_per_elig_flag
319: ,p_name_o =>ben_ler_shd.g_old_rec.name
320: ,p_business_group_id_o =>ben_ler_shd.g_old_rec.business_group_id
321: ,p_typ_cd_o =>ben_ler_shd.g_old_rec.typ_cd
322: ,p_lf_evt_oper_cd_o =>ben_ler_shd.g_old_rec.lf_evt_oper_cd
323: ,p_short_name_o =>ben_ler_shd.g_old_rec.short_name
324: ,p_short_code_o =>ben_ler_shd.g_old_rec.short_code
325: ,p_ptnl_ler_trtmt_cd_o =>ben_ler_shd.g_old_rec.ptnl_ler_trtmt_cd
326: ,p_ck_rltd_per_elig_flag_o =>ben_ler_shd.g_old_rec.ck_rltd_per_elig_flag
327: ,p_ler_eval_rl_o =>ben_ler_shd.g_old_rec.ler_eval_rl
320: ,p_business_group_id_o =>ben_ler_shd.g_old_rec.business_group_id
321: ,p_typ_cd_o =>ben_ler_shd.g_old_rec.typ_cd
322: ,p_lf_evt_oper_cd_o =>ben_ler_shd.g_old_rec.lf_evt_oper_cd
323: ,p_short_name_o =>ben_ler_shd.g_old_rec.short_name
324: ,p_short_code_o =>ben_ler_shd.g_old_rec.short_code
325: ,p_ptnl_ler_trtmt_cd_o =>ben_ler_shd.g_old_rec.ptnl_ler_trtmt_cd
326: ,p_ck_rltd_per_elig_flag_o =>ben_ler_shd.g_old_rec.ck_rltd_per_elig_flag
327: ,p_ler_eval_rl_o =>ben_ler_shd.g_old_rec.ler_eval_rl
328: ,p_cm_aply_flag_o =>ben_ler_shd.g_old_rec.cm_aply_flag
321: ,p_typ_cd_o =>ben_ler_shd.g_old_rec.typ_cd
322: ,p_lf_evt_oper_cd_o =>ben_ler_shd.g_old_rec.lf_evt_oper_cd
323: ,p_short_name_o =>ben_ler_shd.g_old_rec.short_name
324: ,p_short_code_o =>ben_ler_shd.g_old_rec.short_code
325: ,p_ptnl_ler_trtmt_cd_o =>ben_ler_shd.g_old_rec.ptnl_ler_trtmt_cd
326: ,p_ck_rltd_per_elig_flag_o =>ben_ler_shd.g_old_rec.ck_rltd_per_elig_flag
327: ,p_ler_eval_rl_o =>ben_ler_shd.g_old_rec.ler_eval_rl
328: ,p_cm_aply_flag_o =>ben_ler_shd.g_old_rec.cm_aply_flag
329: ,p_ovridg_le_flag_o =>ben_ler_shd.g_old_rec.ovridg_le_flag
322: ,p_lf_evt_oper_cd_o =>ben_ler_shd.g_old_rec.lf_evt_oper_cd
323: ,p_short_name_o =>ben_ler_shd.g_old_rec.short_name
324: ,p_short_code_o =>ben_ler_shd.g_old_rec.short_code
325: ,p_ptnl_ler_trtmt_cd_o =>ben_ler_shd.g_old_rec.ptnl_ler_trtmt_cd
326: ,p_ck_rltd_per_elig_flag_o =>ben_ler_shd.g_old_rec.ck_rltd_per_elig_flag
327: ,p_ler_eval_rl_o =>ben_ler_shd.g_old_rec.ler_eval_rl
328: ,p_cm_aply_flag_o =>ben_ler_shd.g_old_rec.cm_aply_flag
329: ,p_ovridg_le_flag_o =>ben_ler_shd.g_old_rec.ovridg_le_flag
330: ,p_qualg_evt_flag_o =>ben_ler_shd.g_old_rec.qualg_evt_flag
323: ,p_short_name_o =>ben_ler_shd.g_old_rec.short_name
324: ,p_short_code_o =>ben_ler_shd.g_old_rec.short_code
325: ,p_ptnl_ler_trtmt_cd_o =>ben_ler_shd.g_old_rec.ptnl_ler_trtmt_cd
326: ,p_ck_rltd_per_elig_flag_o =>ben_ler_shd.g_old_rec.ck_rltd_per_elig_flag
327: ,p_ler_eval_rl_o =>ben_ler_shd.g_old_rec.ler_eval_rl
328: ,p_cm_aply_flag_o =>ben_ler_shd.g_old_rec.cm_aply_flag
329: ,p_ovridg_le_flag_o =>ben_ler_shd.g_old_rec.ovridg_le_flag
330: ,p_qualg_evt_flag_o =>ben_ler_shd.g_old_rec.qualg_evt_flag
331: ,p_whn_to_prcs_cd_o =>ben_ler_shd.g_old_rec.whn_to_prcs_cd
324: ,p_short_code_o =>ben_ler_shd.g_old_rec.short_code
325: ,p_ptnl_ler_trtmt_cd_o =>ben_ler_shd.g_old_rec.ptnl_ler_trtmt_cd
326: ,p_ck_rltd_per_elig_flag_o =>ben_ler_shd.g_old_rec.ck_rltd_per_elig_flag
327: ,p_ler_eval_rl_o =>ben_ler_shd.g_old_rec.ler_eval_rl
328: ,p_cm_aply_flag_o =>ben_ler_shd.g_old_rec.cm_aply_flag
329: ,p_ovridg_le_flag_o =>ben_ler_shd.g_old_rec.ovridg_le_flag
330: ,p_qualg_evt_flag_o =>ben_ler_shd.g_old_rec.qualg_evt_flag
331: ,p_whn_to_prcs_cd_o =>ben_ler_shd.g_old_rec.whn_to_prcs_cd
332: ,p_desc_txt_o =>ben_ler_shd.g_old_rec.desc_txt
325: ,p_ptnl_ler_trtmt_cd_o =>ben_ler_shd.g_old_rec.ptnl_ler_trtmt_cd
326: ,p_ck_rltd_per_elig_flag_o =>ben_ler_shd.g_old_rec.ck_rltd_per_elig_flag
327: ,p_ler_eval_rl_o =>ben_ler_shd.g_old_rec.ler_eval_rl
328: ,p_cm_aply_flag_o =>ben_ler_shd.g_old_rec.cm_aply_flag
329: ,p_ovridg_le_flag_o =>ben_ler_shd.g_old_rec.ovridg_le_flag
330: ,p_qualg_evt_flag_o =>ben_ler_shd.g_old_rec.qualg_evt_flag
331: ,p_whn_to_prcs_cd_o =>ben_ler_shd.g_old_rec.whn_to_prcs_cd
332: ,p_desc_txt_o =>ben_ler_shd.g_old_rec.desc_txt
333: ,p_tmlns_eval_cd_o =>ben_ler_shd.g_old_rec.tmlns_eval_cd
326: ,p_ck_rltd_per_elig_flag_o =>ben_ler_shd.g_old_rec.ck_rltd_per_elig_flag
327: ,p_ler_eval_rl_o =>ben_ler_shd.g_old_rec.ler_eval_rl
328: ,p_cm_aply_flag_o =>ben_ler_shd.g_old_rec.cm_aply_flag
329: ,p_ovridg_le_flag_o =>ben_ler_shd.g_old_rec.ovridg_le_flag
330: ,p_qualg_evt_flag_o =>ben_ler_shd.g_old_rec.qualg_evt_flag
331: ,p_whn_to_prcs_cd_o =>ben_ler_shd.g_old_rec.whn_to_prcs_cd
332: ,p_desc_txt_o =>ben_ler_shd.g_old_rec.desc_txt
333: ,p_tmlns_eval_cd_o =>ben_ler_shd.g_old_rec.tmlns_eval_cd
334: ,p_tmlns_perd_cd_o =>ben_ler_shd.g_old_rec.tmlns_perd_cd
327: ,p_ler_eval_rl_o =>ben_ler_shd.g_old_rec.ler_eval_rl
328: ,p_cm_aply_flag_o =>ben_ler_shd.g_old_rec.cm_aply_flag
329: ,p_ovridg_le_flag_o =>ben_ler_shd.g_old_rec.ovridg_le_flag
330: ,p_qualg_evt_flag_o =>ben_ler_shd.g_old_rec.qualg_evt_flag
331: ,p_whn_to_prcs_cd_o =>ben_ler_shd.g_old_rec.whn_to_prcs_cd
332: ,p_desc_txt_o =>ben_ler_shd.g_old_rec.desc_txt
333: ,p_tmlns_eval_cd_o =>ben_ler_shd.g_old_rec.tmlns_eval_cd
334: ,p_tmlns_perd_cd_o =>ben_ler_shd.g_old_rec.tmlns_perd_cd
335: ,p_tmlns_dys_num_o =>ben_ler_shd.g_old_rec.tmlns_dys_num
328: ,p_cm_aply_flag_o =>ben_ler_shd.g_old_rec.cm_aply_flag
329: ,p_ovridg_le_flag_o =>ben_ler_shd.g_old_rec.ovridg_le_flag
330: ,p_qualg_evt_flag_o =>ben_ler_shd.g_old_rec.qualg_evt_flag
331: ,p_whn_to_prcs_cd_o =>ben_ler_shd.g_old_rec.whn_to_prcs_cd
332: ,p_desc_txt_o =>ben_ler_shd.g_old_rec.desc_txt
333: ,p_tmlns_eval_cd_o =>ben_ler_shd.g_old_rec.tmlns_eval_cd
334: ,p_tmlns_perd_cd_o =>ben_ler_shd.g_old_rec.tmlns_perd_cd
335: ,p_tmlns_dys_num_o =>ben_ler_shd.g_old_rec.tmlns_dys_num
336: ,p_tmlns_perd_rl_o =>ben_ler_shd.g_old_rec.tmlns_perd_rl
329: ,p_ovridg_le_flag_o =>ben_ler_shd.g_old_rec.ovridg_le_flag
330: ,p_qualg_evt_flag_o =>ben_ler_shd.g_old_rec.qualg_evt_flag
331: ,p_whn_to_prcs_cd_o =>ben_ler_shd.g_old_rec.whn_to_prcs_cd
332: ,p_desc_txt_o =>ben_ler_shd.g_old_rec.desc_txt
333: ,p_tmlns_eval_cd_o =>ben_ler_shd.g_old_rec.tmlns_eval_cd
334: ,p_tmlns_perd_cd_o =>ben_ler_shd.g_old_rec.tmlns_perd_cd
335: ,p_tmlns_dys_num_o =>ben_ler_shd.g_old_rec.tmlns_dys_num
336: ,p_tmlns_perd_rl_o =>ben_ler_shd.g_old_rec.tmlns_perd_rl
337: ,p_ocrd_dt_det_cd_o =>ben_ler_shd.g_old_rec.ocrd_dt_det_cd
330: ,p_qualg_evt_flag_o =>ben_ler_shd.g_old_rec.qualg_evt_flag
331: ,p_whn_to_prcs_cd_o =>ben_ler_shd.g_old_rec.whn_to_prcs_cd
332: ,p_desc_txt_o =>ben_ler_shd.g_old_rec.desc_txt
333: ,p_tmlns_eval_cd_o =>ben_ler_shd.g_old_rec.tmlns_eval_cd
334: ,p_tmlns_perd_cd_o =>ben_ler_shd.g_old_rec.tmlns_perd_cd
335: ,p_tmlns_dys_num_o =>ben_ler_shd.g_old_rec.tmlns_dys_num
336: ,p_tmlns_perd_rl_o =>ben_ler_shd.g_old_rec.tmlns_perd_rl
337: ,p_ocrd_dt_det_cd_o =>ben_ler_shd.g_old_rec.ocrd_dt_det_cd
338: ,p_ler_stat_cd_o =>ben_ler_shd.g_old_rec.ler_stat_cd
331: ,p_whn_to_prcs_cd_o =>ben_ler_shd.g_old_rec.whn_to_prcs_cd
332: ,p_desc_txt_o =>ben_ler_shd.g_old_rec.desc_txt
333: ,p_tmlns_eval_cd_o =>ben_ler_shd.g_old_rec.tmlns_eval_cd
334: ,p_tmlns_perd_cd_o =>ben_ler_shd.g_old_rec.tmlns_perd_cd
335: ,p_tmlns_dys_num_o =>ben_ler_shd.g_old_rec.tmlns_dys_num
336: ,p_tmlns_perd_rl_o =>ben_ler_shd.g_old_rec.tmlns_perd_rl
337: ,p_ocrd_dt_det_cd_o =>ben_ler_shd.g_old_rec.ocrd_dt_det_cd
338: ,p_ler_stat_cd_o =>ben_ler_shd.g_old_rec.ler_stat_cd
339: ,p_slctbl_slf_svc_cd_o =>ben_ler_shd.g_old_rec.slctbl_slf_svc_cd
332: ,p_desc_txt_o =>ben_ler_shd.g_old_rec.desc_txt
333: ,p_tmlns_eval_cd_o =>ben_ler_shd.g_old_rec.tmlns_eval_cd
334: ,p_tmlns_perd_cd_o =>ben_ler_shd.g_old_rec.tmlns_perd_cd
335: ,p_tmlns_dys_num_o =>ben_ler_shd.g_old_rec.tmlns_dys_num
336: ,p_tmlns_perd_rl_o =>ben_ler_shd.g_old_rec.tmlns_perd_rl
337: ,p_ocrd_dt_det_cd_o =>ben_ler_shd.g_old_rec.ocrd_dt_det_cd
338: ,p_ler_stat_cd_o =>ben_ler_shd.g_old_rec.ler_stat_cd
339: ,p_slctbl_slf_svc_cd_o =>ben_ler_shd.g_old_rec.slctbl_slf_svc_cd
340: ,p_ss_pcp_disp_cd_o =>ben_ler_shd.g_old_rec.ss_pcp_disp_cd
333: ,p_tmlns_eval_cd_o =>ben_ler_shd.g_old_rec.tmlns_eval_cd
334: ,p_tmlns_perd_cd_o =>ben_ler_shd.g_old_rec.tmlns_perd_cd
335: ,p_tmlns_dys_num_o =>ben_ler_shd.g_old_rec.tmlns_dys_num
336: ,p_tmlns_perd_rl_o =>ben_ler_shd.g_old_rec.tmlns_perd_rl
337: ,p_ocrd_dt_det_cd_o =>ben_ler_shd.g_old_rec.ocrd_dt_det_cd
338: ,p_ler_stat_cd_o =>ben_ler_shd.g_old_rec.ler_stat_cd
339: ,p_slctbl_slf_svc_cd_o =>ben_ler_shd.g_old_rec.slctbl_slf_svc_cd
340: ,p_ss_pcp_disp_cd_o =>ben_ler_shd.g_old_rec.ss_pcp_disp_cd
341: ,p_ler_attribute_category_o =>ben_ler_shd.g_old_rec.ler_attribute_category
334: ,p_tmlns_perd_cd_o =>ben_ler_shd.g_old_rec.tmlns_perd_cd
335: ,p_tmlns_dys_num_o =>ben_ler_shd.g_old_rec.tmlns_dys_num
336: ,p_tmlns_perd_rl_o =>ben_ler_shd.g_old_rec.tmlns_perd_rl
337: ,p_ocrd_dt_det_cd_o =>ben_ler_shd.g_old_rec.ocrd_dt_det_cd
338: ,p_ler_stat_cd_o =>ben_ler_shd.g_old_rec.ler_stat_cd
339: ,p_slctbl_slf_svc_cd_o =>ben_ler_shd.g_old_rec.slctbl_slf_svc_cd
340: ,p_ss_pcp_disp_cd_o =>ben_ler_shd.g_old_rec.ss_pcp_disp_cd
341: ,p_ler_attribute_category_o =>ben_ler_shd.g_old_rec.ler_attribute_category
342: ,p_ler_attribute1_o =>ben_ler_shd.g_old_rec.ler_attribute1
335: ,p_tmlns_dys_num_o =>ben_ler_shd.g_old_rec.tmlns_dys_num
336: ,p_tmlns_perd_rl_o =>ben_ler_shd.g_old_rec.tmlns_perd_rl
337: ,p_ocrd_dt_det_cd_o =>ben_ler_shd.g_old_rec.ocrd_dt_det_cd
338: ,p_ler_stat_cd_o =>ben_ler_shd.g_old_rec.ler_stat_cd
339: ,p_slctbl_slf_svc_cd_o =>ben_ler_shd.g_old_rec.slctbl_slf_svc_cd
340: ,p_ss_pcp_disp_cd_o =>ben_ler_shd.g_old_rec.ss_pcp_disp_cd
341: ,p_ler_attribute_category_o =>ben_ler_shd.g_old_rec.ler_attribute_category
342: ,p_ler_attribute1_o =>ben_ler_shd.g_old_rec.ler_attribute1
343: ,p_ler_attribute2_o =>ben_ler_shd.g_old_rec.ler_attribute2
336: ,p_tmlns_perd_rl_o =>ben_ler_shd.g_old_rec.tmlns_perd_rl
337: ,p_ocrd_dt_det_cd_o =>ben_ler_shd.g_old_rec.ocrd_dt_det_cd
338: ,p_ler_stat_cd_o =>ben_ler_shd.g_old_rec.ler_stat_cd
339: ,p_slctbl_slf_svc_cd_o =>ben_ler_shd.g_old_rec.slctbl_slf_svc_cd
340: ,p_ss_pcp_disp_cd_o =>ben_ler_shd.g_old_rec.ss_pcp_disp_cd
341: ,p_ler_attribute_category_o =>ben_ler_shd.g_old_rec.ler_attribute_category
342: ,p_ler_attribute1_o =>ben_ler_shd.g_old_rec.ler_attribute1
343: ,p_ler_attribute2_o =>ben_ler_shd.g_old_rec.ler_attribute2
344: ,p_ler_attribute3_o =>ben_ler_shd.g_old_rec.ler_attribute3
337: ,p_ocrd_dt_det_cd_o =>ben_ler_shd.g_old_rec.ocrd_dt_det_cd
338: ,p_ler_stat_cd_o =>ben_ler_shd.g_old_rec.ler_stat_cd
339: ,p_slctbl_slf_svc_cd_o =>ben_ler_shd.g_old_rec.slctbl_slf_svc_cd
340: ,p_ss_pcp_disp_cd_o =>ben_ler_shd.g_old_rec.ss_pcp_disp_cd
341: ,p_ler_attribute_category_o =>ben_ler_shd.g_old_rec.ler_attribute_category
342: ,p_ler_attribute1_o =>ben_ler_shd.g_old_rec.ler_attribute1
343: ,p_ler_attribute2_o =>ben_ler_shd.g_old_rec.ler_attribute2
344: ,p_ler_attribute3_o =>ben_ler_shd.g_old_rec.ler_attribute3
345: ,p_ler_attribute4_o =>ben_ler_shd.g_old_rec.ler_attribute4
338: ,p_ler_stat_cd_o =>ben_ler_shd.g_old_rec.ler_stat_cd
339: ,p_slctbl_slf_svc_cd_o =>ben_ler_shd.g_old_rec.slctbl_slf_svc_cd
340: ,p_ss_pcp_disp_cd_o =>ben_ler_shd.g_old_rec.ss_pcp_disp_cd
341: ,p_ler_attribute_category_o =>ben_ler_shd.g_old_rec.ler_attribute_category
342: ,p_ler_attribute1_o =>ben_ler_shd.g_old_rec.ler_attribute1
343: ,p_ler_attribute2_o =>ben_ler_shd.g_old_rec.ler_attribute2
344: ,p_ler_attribute3_o =>ben_ler_shd.g_old_rec.ler_attribute3
345: ,p_ler_attribute4_o =>ben_ler_shd.g_old_rec.ler_attribute4
346: ,p_ler_attribute5_o =>ben_ler_shd.g_old_rec.ler_attribute5
339: ,p_slctbl_slf_svc_cd_o =>ben_ler_shd.g_old_rec.slctbl_slf_svc_cd
340: ,p_ss_pcp_disp_cd_o =>ben_ler_shd.g_old_rec.ss_pcp_disp_cd
341: ,p_ler_attribute_category_o =>ben_ler_shd.g_old_rec.ler_attribute_category
342: ,p_ler_attribute1_o =>ben_ler_shd.g_old_rec.ler_attribute1
343: ,p_ler_attribute2_o =>ben_ler_shd.g_old_rec.ler_attribute2
344: ,p_ler_attribute3_o =>ben_ler_shd.g_old_rec.ler_attribute3
345: ,p_ler_attribute4_o =>ben_ler_shd.g_old_rec.ler_attribute4
346: ,p_ler_attribute5_o =>ben_ler_shd.g_old_rec.ler_attribute5
347: ,p_ler_attribute6_o =>ben_ler_shd.g_old_rec.ler_attribute6
340: ,p_ss_pcp_disp_cd_o =>ben_ler_shd.g_old_rec.ss_pcp_disp_cd
341: ,p_ler_attribute_category_o =>ben_ler_shd.g_old_rec.ler_attribute_category
342: ,p_ler_attribute1_o =>ben_ler_shd.g_old_rec.ler_attribute1
343: ,p_ler_attribute2_o =>ben_ler_shd.g_old_rec.ler_attribute2
344: ,p_ler_attribute3_o =>ben_ler_shd.g_old_rec.ler_attribute3
345: ,p_ler_attribute4_o =>ben_ler_shd.g_old_rec.ler_attribute4
346: ,p_ler_attribute5_o =>ben_ler_shd.g_old_rec.ler_attribute5
347: ,p_ler_attribute6_o =>ben_ler_shd.g_old_rec.ler_attribute6
348: ,p_ler_attribute7_o =>ben_ler_shd.g_old_rec.ler_attribute7
341: ,p_ler_attribute_category_o =>ben_ler_shd.g_old_rec.ler_attribute_category
342: ,p_ler_attribute1_o =>ben_ler_shd.g_old_rec.ler_attribute1
343: ,p_ler_attribute2_o =>ben_ler_shd.g_old_rec.ler_attribute2
344: ,p_ler_attribute3_o =>ben_ler_shd.g_old_rec.ler_attribute3
345: ,p_ler_attribute4_o =>ben_ler_shd.g_old_rec.ler_attribute4
346: ,p_ler_attribute5_o =>ben_ler_shd.g_old_rec.ler_attribute5
347: ,p_ler_attribute6_o =>ben_ler_shd.g_old_rec.ler_attribute6
348: ,p_ler_attribute7_o =>ben_ler_shd.g_old_rec.ler_attribute7
349: ,p_ler_attribute8_o =>ben_ler_shd.g_old_rec.ler_attribute8
342: ,p_ler_attribute1_o =>ben_ler_shd.g_old_rec.ler_attribute1
343: ,p_ler_attribute2_o =>ben_ler_shd.g_old_rec.ler_attribute2
344: ,p_ler_attribute3_o =>ben_ler_shd.g_old_rec.ler_attribute3
345: ,p_ler_attribute4_o =>ben_ler_shd.g_old_rec.ler_attribute4
346: ,p_ler_attribute5_o =>ben_ler_shd.g_old_rec.ler_attribute5
347: ,p_ler_attribute6_o =>ben_ler_shd.g_old_rec.ler_attribute6
348: ,p_ler_attribute7_o =>ben_ler_shd.g_old_rec.ler_attribute7
349: ,p_ler_attribute8_o =>ben_ler_shd.g_old_rec.ler_attribute8
350: ,p_ler_attribute9_o =>ben_ler_shd.g_old_rec.ler_attribute9
343: ,p_ler_attribute2_o =>ben_ler_shd.g_old_rec.ler_attribute2
344: ,p_ler_attribute3_o =>ben_ler_shd.g_old_rec.ler_attribute3
345: ,p_ler_attribute4_o =>ben_ler_shd.g_old_rec.ler_attribute4
346: ,p_ler_attribute5_o =>ben_ler_shd.g_old_rec.ler_attribute5
347: ,p_ler_attribute6_o =>ben_ler_shd.g_old_rec.ler_attribute6
348: ,p_ler_attribute7_o =>ben_ler_shd.g_old_rec.ler_attribute7
349: ,p_ler_attribute8_o =>ben_ler_shd.g_old_rec.ler_attribute8
350: ,p_ler_attribute9_o =>ben_ler_shd.g_old_rec.ler_attribute9
351: ,p_ler_attribute10_o =>ben_ler_shd.g_old_rec.ler_attribute10
344: ,p_ler_attribute3_o =>ben_ler_shd.g_old_rec.ler_attribute3
345: ,p_ler_attribute4_o =>ben_ler_shd.g_old_rec.ler_attribute4
346: ,p_ler_attribute5_o =>ben_ler_shd.g_old_rec.ler_attribute5
347: ,p_ler_attribute6_o =>ben_ler_shd.g_old_rec.ler_attribute6
348: ,p_ler_attribute7_o =>ben_ler_shd.g_old_rec.ler_attribute7
349: ,p_ler_attribute8_o =>ben_ler_shd.g_old_rec.ler_attribute8
350: ,p_ler_attribute9_o =>ben_ler_shd.g_old_rec.ler_attribute9
351: ,p_ler_attribute10_o =>ben_ler_shd.g_old_rec.ler_attribute10
352: ,p_ler_attribute11_o =>ben_ler_shd.g_old_rec.ler_attribute11
345: ,p_ler_attribute4_o =>ben_ler_shd.g_old_rec.ler_attribute4
346: ,p_ler_attribute5_o =>ben_ler_shd.g_old_rec.ler_attribute5
347: ,p_ler_attribute6_o =>ben_ler_shd.g_old_rec.ler_attribute6
348: ,p_ler_attribute7_o =>ben_ler_shd.g_old_rec.ler_attribute7
349: ,p_ler_attribute8_o =>ben_ler_shd.g_old_rec.ler_attribute8
350: ,p_ler_attribute9_o =>ben_ler_shd.g_old_rec.ler_attribute9
351: ,p_ler_attribute10_o =>ben_ler_shd.g_old_rec.ler_attribute10
352: ,p_ler_attribute11_o =>ben_ler_shd.g_old_rec.ler_attribute11
353: ,p_ler_attribute12_o =>ben_ler_shd.g_old_rec.ler_attribute12
346: ,p_ler_attribute5_o =>ben_ler_shd.g_old_rec.ler_attribute5
347: ,p_ler_attribute6_o =>ben_ler_shd.g_old_rec.ler_attribute6
348: ,p_ler_attribute7_o =>ben_ler_shd.g_old_rec.ler_attribute7
349: ,p_ler_attribute8_o =>ben_ler_shd.g_old_rec.ler_attribute8
350: ,p_ler_attribute9_o =>ben_ler_shd.g_old_rec.ler_attribute9
351: ,p_ler_attribute10_o =>ben_ler_shd.g_old_rec.ler_attribute10
352: ,p_ler_attribute11_o =>ben_ler_shd.g_old_rec.ler_attribute11
353: ,p_ler_attribute12_o =>ben_ler_shd.g_old_rec.ler_attribute12
354: ,p_ler_attribute13_o =>ben_ler_shd.g_old_rec.ler_attribute13
347: ,p_ler_attribute6_o =>ben_ler_shd.g_old_rec.ler_attribute6
348: ,p_ler_attribute7_o =>ben_ler_shd.g_old_rec.ler_attribute7
349: ,p_ler_attribute8_o =>ben_ler_shd.g_old_rec.ler_attribute8
350: ,p_ler_attribute9_o =>ben_ler_shd.g_old_rec.ler_attribute9
351: ,p_ler_attribute10_o =>ben_ler_shd.g_old_rec.ler_attribute10
352: ,p_ler_attribute11_o =>ben_ler_shd.g_old_rec.ler_attribute11
353: ,p_ler_attribute12_o =>ben_ler_shd.g_old_rec.ler_attribute12
354: ,p_ler_attribute13_o =>ben_ler_shd.g_old_rec.ler_attribute13
355: ,p_ler_attribute14_o =>ben_ler_shd.g_old_rec.ler_attribute14
348: ,p_ler_attribute7_o =>ben_ler_shd.g_old_rec.ler_attribute7
349: ,p_ler_attribute8_o =>ben_ler_shd.g_old_rec.ler_attribute8
350: ,p_ler_attribute9_o =>ben_ler_shd.g_old_rec.ler_attribute9
351: ,p_ler_attribute10_o =>ben_ler_shd.g_old_rec.ler_attribute10
352: ,p_ler_attribute11_o =>ben_ler_shd.g_old_rec.ler_attribute11
353: ,p_ler_attribute12_o =>ben_ler_shd.g_old_rec.ler_attribute12
354: ,p_ler_attribute13_o =>ben_ler_shd.g_old_rec.ler_attribute13
355: ,p_ler_attribute14_o =>ben_ler_shd.g_old_rec.ler_attribute14
356: ,p_ler_attribute15_o =>ben_ler_shd.g_old_rec.ler_attribute15
349: ,p_ler_attribute8_o =>ben_ler_shd.g_old_rec.ler_attribute8
350: ,p_ler_attribute9_o =>ben_ler_shd.g_old_rec.ler_attribute9
351: ,p_ler_attribute10_o =>ben_ler_shd.g_old_rec.ler_attribute10
352: ,p_ler_attribute11_o =>ben_ler_shd.g_old_rec.ler_attribute11
353: ,p_ler_attribute12_o =>ben_ler_shd.g_old_rec.ler_attribute12
354: ,p_ler_attribute13_o =>ben_ler_shd.g_old_rec.ler_attribute13
355: ,p_ler_attribute14_o =>ben_ler_shd.g_old_rec.ler_attribute14
356: ,p_ler_attribute15_o =>ben_ler_shd.g_old_rec.ler_attribute15
357: ,p_ler_attribute16_o =>ben_ler_shd.g_old_rec.ler_attribute16
350: ,p_ler_attribute9_o =>ben_ler_shd.g_old_rec.ler_attribute9
351: ,p_ler_attribute10_o =>ben_ler_shd.g_old_rec.ler_attribute10
352: ,p_ler_attribute11_o =>ben_ler_shd.g_old_rec.ler_attribute11
353: ,p_ler_attribute12_o =>ben_ler_shd.g_old_rec.ler_attribute12
354: ,p_ler_attribute13_o =>ben_ler_shd.g_old_rec.ler_attribute13
355: ,p_ler_attribute14_o =>ben_ler_shd.g_old_rec.ler_attribute14
356: ,p_ler_attribute15_o =>ben_ler_shd.g_old_rec.ler_attribute15
357: ,p_ler_attribute16_o =>ben_ler_shd.g_old_rec.ler_attribute16
358: ,p_ler_attribute17_o =>ben_ler_shd.g_old_rec.ler_attribute17
351: ,p_ler_attribute10_o =>ben_ler_shd.g_old_rec.ler_attribute10
352: ,p_ler_attribute11_o =>ben_ler_shd.g_old_rec.ler_attribute11
353: ,p_ler_attribute12_o =>ben_ler_shd.g_old_rec.ler_attribute12
354: ,p_ler_attribute13_o =>ben_ler_shd.g_old_rec.ler_attribute13
355: ,p_ler_attribute14_o =>ben_ler_shd.g_old_rec.ler_attribute14
356: ,p_ler_attribute15_o =>ben_ler_shd.g_old_rec.ler_attribute15
357: ,p_ler_attribute16_o =>ben_ler_shd.g_old_rec.ler_attribute16
358: ,p_ler_attribute17_o =>ben_ler_shd.g_old_rec.ler_attribute17
359: ,p_ler_attribute18_o =>ben_ler_shd.g_old_rec.ler_attribute18
352: ,p_ler_attribute11_o =>ben_ler_shd.g_old_rec.ler_attribute11
353: ,p_ler_attribute12_o =>ben_ler_shd.g_old_rec.ler_attribute12
354: ,p_ler_attribute13_o =>ben_ler_shd.g_old_rec.ler_attribute13
355: ,p_ler_attribute14_o =>ben_ler_shd.g_old_rec.ler_attribute14
356: ,p_ler_attribute15_o =>ben_ler_shd.g_old_rec.ler_attribute15
357: ,p_ler_attribute16_o =>ben_ler_shd.g_old_rec.ler_attribute16
358: ,p_ler_attribute17_o =>ben_ler_shd.g_old_rec.ler_attribute17
359: ,p_ler_attribute18_o =>ben_ler_shd.g_old_rec.ler_attribute18
360: ,p_ler_attribute19_o =>ben_ler_shd.g_old_rec.ler_attribute19
353: ,p_ler_attribute12_o =>ben_ler_shd.g_old_rec.ler_attribute12
354: ,p_ler_attribute13_o =>ben_ler_shd.g_old_rec.ler_attribute13
355: ,p_ler_attribute14_o =>ben_ler_shd.g_old_rec.ler_attribute14
356: ,p_ler_attribute15_o =>ben_ler_shd.g_old_rec.ler_attribute15
357: ,p_ler_attribute16_o =>ben_ler_shd.g_old_rec.ler_attribute16
358: ,p_ler_attribute17_o =>ben_ler_shd.g_old_rec.ler_attribute17
359: ,p_ler_attribute18_o =>ben_ler_shd.g_old_rec.ler_attribute18
360: ,p_ler_attribute19_o =>ben_ler_shd.g_old_rec.ler_attribute19
361: ,p_ler_attribute20_o =>ben_ler_shd.g_old_rec.ler_attribute20
354: ,p_ler_attribute13_o =>ben_ler_shd.g_old_rec.ler_attribute13
355: ,p_ler_attribute14_o =>ben_ler_shd.g_old_rec.ler_attribute14
356: ,p_ler_attribute15_o =>ben_ler_shd.g_old_rec.ler_attribute15
357: ,p_ler_attribute16_o =>ben_ler_shd.g_old_rec.ler_attribute16
358: ,p_ler_attribute17_o =>ben_ler_shd.g_old_rec.ler_attribute17
359: ,p_ler_attribute18_o =>ben_ler_shd.g_old_rec.ler_attribute18
360: ,p_ler_attribute19_o =>ben_ler_shd.g_old_rec.ler_attribute19
361: ,p_ler_attribute20_o =>ben_ler_shd.g_old_rec.ler_attribute20
362: ,p_ler_attribute21_o =>ben_ler_shd.g_old_rec.ler_attribute21
355: ,p_ler_attribute14_o =>ben_ler_shd.g_old_rec.ler_attribute14
356: ,p_ler_attribute15_o =>ben_ler_shd.g_old_rec.ler_attribute15
357: ,p_ler_attribute16_o =>ben_ler_shd.g_old_rec.ler_attribute16
358: ,p_ler_attribute17_o =>ben_ler_shd.g_old_rec.ler_attribute17
359: ,p_ler_attribute18_o =>ben_ler_shd.g_old_rec.ler_attribute18
360: ,p_ler_attribute19_o =>ben_ler_shd.g_old_rec.ler_attribute19
361: ,p_ler_attribute20_o =>ben_ler_shd.g_old_rec.ler_attribute20
362: ,p_ler_attribute21_o =>ben_ler_shd.g_old_rec.ler_attribute21
363: ,p_ler_attribute22_o =>ben_ler_shd.g_old_rec.ler_attribute22
356: ,p_ler_attribute15_o =>ben_ler_shd.g_old_rec.ler_attribute15
357: ,p_ler_attribute16_o =>ben_ler_shd.g_old_rec.ler_attribute16
358: ,p_ler_attribute17_o =>ben_ler_shd.g_old_rec.ler_attribute17
359: ,p_ler_attribute18_o =>ben_ler_shd.g_old_rec.ler_attribute18
360: ,p_ler_attribute19_o =>ben_ler_shd.g_old_rec.ler_attribute19
361: ,p_ler_attribute20_o =>ben_ler_shd.g_old_rec.ler_attribute20
362: ,p_ler_attribute21_o =>ben_ler_shd.g_old_rec.ler_attribute21
363: ,p_ler_attribute22_o =>ben_ler_shd.g_old_rec.ler_attribute22
364: ,p_ler_attribute23_o =>ben_ler_shd.g_old_rec.ler_attribute23
357: ,p_ler_attribute16_o =>ben_ler_shd.g_old_rec.ler_attribute16
358: ,p_ler_attribute17_o =>ben_ler_shd.g_old_rec.ler_attribute17
359: ,p_ler_attribute18_o =>ben_ler_shd.g_old_rec.ler_attribute18
360: ,p_ler_attribute19_o =>ben_ler_shd.g_old_rec.ler_attribute19
361: ,p_ler_attribute20_o =>ben_ler_shd.g_old_rec.ler_attribute20
362: ,p_ler_attribute21_o =>ben_ler_shd.g_old_rec.ler_attribute21
363: ,p_ler_attribute22_o =>ben_ler_shd.g_old_rec.ler_attribute22
364: ,p_ler_attribute23_o =>ben_ler_shd.g_old_rec.ler_attribute23
365: ,p_ler_attribute24_o =>ben_ler_shd.g_old_rec.ler_attribute24
358: ,p_ler_attribute17_o =>ben_ler_shd.g_old_rec.ler_attribute17
359: ,p_ler_attribute18_o =>ben_ler_shd.g_old_rec.ler_attribute18
360: ,p_ler_attribute19_o =>ben_ler_shd.g_old_rec.ler_attribute19
361: ,p_ler_attribute20_o =>ben_ler_shd.g_old_rec.ler_attribute20
362: ,p_ler_attribute21_o =>ben_ler_shd.g_old_rec.ler_attribute21
363: ,p_ler_attribute22_o =>ben_ler_shd.g_old_rec.ler_attribute22
364: ,p_ler_attribute23_o =>ben_ler_shd.g_old_rec.ler_attribute23
365: ,p_ler_attribute24_o =>ben_ler_shd.g_old_rec.ler_attribute24
366: ,p_ler_attribute25_o =>ben_ler_shd.g_old_rec.ler_attribute25
359: ,p_ler_attribute18_o =>ben_ler_shd.g_old_rec.ler_attribute18
360: ,p_ler_attribute19_o =>ben_ler_shd.g_old_rec.ler_attribute19
361: ,p_ler_attribute20_o =>ben_ler_shd.g_old_rec.ler_attribute20
362: ,p_ler_attribute21_o =>ben_ler_shd.g_old_rec.ler_attribute21
363: ,p_ler_attribute22_o =>ben_ler_shd.g_old_rec.ler_attribute22
364: ,p_ler_attribute23_o =>ben_ler_shd.g_old_rec.ler_attribute23
365: ,p_ler_attribute24_o =>ben_ler_shd.g_old_rec.ler_attribute24
366: ,p_ler_attribute25_o =>ben_ler_shd.g_old_rec.ler_attribute25
367: ,p_ler_attribute26_o =>ben_ler_shd.g_old_rec.ler_attribute26
360: ,p_ler_attribute19_o =>ben_ler_shd.g_old_rec.ler_attribute19
361: ,p_ler_attribute20_o =>ben_ler_shd.g_old_rec.ler_attribute20
362: ,p_ler_attribute21_o =>ben_ler_shd.g_old_rec.ler_attribute21
363: ,p_ler_attribute22_o =>ben_ler_shd.g_old_rec.ler_attribute22
364: ,p_ler_attribute23_o =>ben_ler_shd.g_old_rec.ler_attribute23
365: ,p_ler_attribute24_o =>ben_ler_shd.g_old_rec.ler_attribute24
366: ,p_ler_attribute25_o =>ben_ler_shd.g_old_rec.ler_attribute25
367: ,p_ler_attribute26_o =>ben_ler_shd.g_old_rec.ler_attribute26
368: ,p_ler_attribute27_o =>ben_ler_shd.g_old_rec.ler_attribute27
361: ,p_ler_attribute20_o =>ben_ler_shd.g_old_rec.ler_attribute20
362: ,p_ler_attribute21_o =>ben_ler_shd.g_old_rec.ler_attribute21
363: ,p_ler_attribute22_o =>ben_ler_shd.g_old_rec.ler_attribute22
364: ,p_ler_attribute23_o =>ben_ler_shd.g_old_rec.ler_attribute23
365: ,p_ler_attribute24_o =>ben_ler_shd.g_old_rec.ler_attribute24
366: ,p_ler_attribute25_o =>ben_ler_shd.g_old_rec.ler_attribute25
367: ,p_ler_attribute26_o =>ben_ler_shd.g_old_rec.ler_attribute26
368: ,p_ler_attribute27_o =>ben_ler_shd.g_old_rec.ler_attribute27
369: ,p_ler_attribute28_o =>ben_ler_shd.g_old_rec.ler_attribute28
362: ,p_ler_attribute21_o =>ben_ler_shd.g_old_rec.ler_attribute21
363: ,p_ler_attribute22_o =>ben_ler_shd.g_old_rec.ler_attribute22
364: ,p_ler_attribute23_o =>ben_ler_shd.g_old_rec.ler_attribute23
365: ,p_ler_attribute24_o =>ben_ler_shd.g_old_rec.ler_attribute24
366: ,p_ler_attribute25_o =>ben_ler_shd.g_old_rec.ler_attribute25
367: ,p_ler_attribute26_o =>ben_ler_shd.g_old_rec.ler_attribute26
368: ,p_ler_attribute27_o =>ben_ler_shd.g_old_rec.ler_attribute27
369: ,p_ler_attribute28_o =>ben_ler_shd.g_old_rec.ler_attribute28
370: ,p_ler_attribute29_o =>ben_ler_shd.g_old_rec.ler_attribute29
363: ,p_ler_attribute22_o =>ben_ler_shd.g_old_rec.ler_attribute22
364: ,p_ler_attribute23_o =>ben_ler_shd.g_old_rec.ler_attribute23
365: ,p_ler_attribute24_o =>ben_ler_shd.g_old_rec.ler_attribute24
366: ,p_ler_attribute25_o =>ben_ler_shd.g_old_rec.ler_attribute25
367: ,p_ler_attribute26_o =>ben_ler_shd.g_old_rec.ler_attribute26
368: ,p_ler_attribute27_o =>ben_ler_shd.g_old_rec.ler_attribute27
369: ,p_ler_attribute28_o =>ben_ler_shd.g_old_rec.ler_attribute28
370: ,p_ler_attribute29_o =>ben_ler_shd.g_old_rec.ler_attribute29
371: ,p_ler_attribute30_o =>ben_ler_shd.g_old_rec.ler_attribute30
364: ,p_ler_attribute23_o =>ben_ler_shd.g_old_rec.ler_attribute23
365: ,p_ler_attribute24_o =>ben_ler_shd.g_old_rec.ler_attribute24
366: ,p_ler_attribute25_o =>ben_ler_shd.g_old_rec.ler_attribute25
367: ,p_ler_attribute26_o =>ben_ler_shd.g_old_rec.ler_attribute26
368: ,p_ler_attribute27_o =>ben_ler_shd.g_old_rec.ler_attribute27
369: ,p_ler_attribute28_o =>ben_ler_shd.g_old_rec.ler_attribute28
370: ,p_ler_attribute29_o =>ben_ler_shd.g_old_rec.ler_attribute29
371: ,p_ler_attribute30_o =>ben_ler_shd.g_old_rec.ler_attribute30
372: ,p_object_version_number_o =>ben_ler_shd.g_old_rec.object_version_number
365: ,p_ler_attribute24_o =>ben_ler_shd.g_old_rec.ler_attribute24
366: ,p_ler_attribute25_o =>ben_ler_shd.g_old_rec.ler_attribute25
367: ,p_ler_attribute26_o =>ben_ler_shd.g_old_rec.ler_attribute26
368: ,p_ler_attribute27_o =>ben_ler_shd.g_old_rec.ler_attribute27
369: ,p_ler_attribute28_o =>ben_ler_shd.g_old_rec.ler_attribute28
370: ,p_ler_attribute29_o =>ben_ler_shd.g_old_rec.ler_attribute29
371: ,p_ler_attribute30_o =>ben_ler_shd.g_old_rec.ler_attribute30
372: ,p_object_version_number_o =>ben_ler_shd.g_old_rec.object_version_number
373: );
366: ,p_ler_attribute25_o =>ben_ler_shd.g_old_rec.ler_attribute25
367: ,p_ler_attribute26_o =>ben_ler_shd.g_old_rec.ler_attribute26
368: ,p_ler_attribute27_o =>ben_ler_shd.g_old_rec.ler_attribute27
369: ,p_ler_attribute28_o =>ben_ler_shd.g_old_rec.ler_attribute28
370: ,p_ler_attribute29_o =>ben_ler_shd.g_old_rec.ler_attribute29
371: ,p_ler_attribute30_o =>ben_ler_shd.g_old_rec.ler_attribute30
372: ,p_object_version_number_o =>ben_ler_shd.g_old_rec.object_version_number
373: );
374: --
367: ,p_ler_attribute26_o =>ben_ler_shd.g_old_rec.ler_attribute26
368: ,p_ler_attribute27_o =>ben_ler_shd.g_old_rec.ler_attribute27
369: ,p_ler_attribute28_o =>ben_ler_shd.g_old_rec.ler_attribute28
370: ,p_ler_attribute29_o =>ben_ler_shd.g_old_rec.ler_attribute29
371: ,p_ler_attribute30_o =>ben_ler_shd.g_old_rec.ler_attribute30
372: ,p_object_version_number_o =>ben_ler_shd.g_old_rec.object_version_number
373: );
374: --
375: exception
368: ,p_ler_attribute27_o =>ben_ler_shd.g_old_rec.ler_attribute27
369: ,p_ler_attribute28_o =>ben_ler_shd.g_old_rec.ler_attribute28
370: ,p_ler_attribute29_o =>ben_ler_shd.g_old_rec.ler_attribute29
371: ,p_ler_attribute30_o =>ben_ler_shd.g_old_rec.ler_attribute30
372: ,p_object_version_number_o =>ben_ler_shd.g_old_rec.object_version_number
373: );
374: --
375: exception
376: --
392: -- |---------------------------------< del >----------------------------------|
393: -- ----------------------------------------------------------------------------
394: Procedure del
395: (
396: p_rec in out nocopy ben_ler_shd.g_rec_type,
397: p_effective_date in date,
398: p_datetrack_mode in varchar2
399: ) is
400: --
410: dt_api.validate_dt_del_mode(p_datetrack_mode => p_datetrack_mode);
411: --
412: -- We must lock the row which we need to delete.
413: --
414: ben_ler_shd.lck
415: (p_effective_date => p_effective_date,
416: p_datetrack_mode => p_datetrack_mode,
417: p_ler_id => p_rec.ler_id,
418: p_object_version_number => p_rec.object_version_number,
468: p_effective_date in date,
469: p_datetrack_mode in varchar2
470: ) is
471: --
472: l_rec ben_ler_shd.g_rec_type;
473: l_proc varchar2(72) := g_package||'del';
474: --
475: Begin
476: hr_utility.set_location('Entering:'||l_proc, 5);