50: --
51: -- {End Of Comments}
52: -- ----------------------------------------------------------------------------
53: Procedure dt_delete_dml
54: (p_rec in out nocopy ben_clp_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_clp_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_clpse_lf_evt_f
72: where clpse_lf_evt_id = p_rec.clpse_lf_evt_id
73: and effective_start_date = p_validation_start_date;
74: --
75: ben_clp_shd.g_api_dml := false; -- Unset the api dml status
76: Else
77: hr_utility.set_location(l_proc, 15);
78: ben_clp_shd.g_api_dml := true; -- Set the api dml status
79: --
74: --
75: ben_clp_shd.g_api_dml := false; -- Unset the api dml status
76: Else
77: hr_utility.set_location(l_proc, 15);
78: ben_clp_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_clpse_lf_evt_f
84: where clpse_lf_evt_id = p_rec.clpse_lf_evt_id
85: and effective_start_date >= p_validation_start_date;
86: --
87: ben_clp_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_clp_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_clp_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_clp_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_clp_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_clp_shd.upd_effective_end_date
180: (p_effective_date => p_effective_date,
181: p_base_key_value => p_rec.clpse_lf_evt_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_clp_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_clp_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
303: ,p_validation_start_date => p_validation_start_date
304: ,p_validation_end_date => p_validation_end_date
305: ,p_effective_start_date => p_rec.effective_start_date
306: ,p_effective_end_date => p_rec.effective_end_date
307: ,p_effective_start_date_o => ben_clp_shd.g_old_rec.effective_start_date
308: ,p_effective_end_date_o => ben_clp_shd.g_old_rec.effective_end_date
309: ,p_business_group_id_o => ben_clp_shd.g_old_rec.business_group_id
310: ,p_seq_o => ben_clp_shd.g_old_rec.seq
311: ,p_ler1_id_o => ben_clp_shd.g_old_rec.ler1_id
304: ,p_validation_end_date => p_validation_end_date
305: ,p_effective_start_date => p_rec.effective_start_date
306: ,p_effective_end_date => p_rec.effective_end_date
307: ,p_effective_start_date_o => ben_clp_shd.g_old_rec.effective_start_date
308: ,p_effective_end_date_o => ben_clp_shd.g_old_rec.effective_end_date
309: ,p_business_group_id_o => ben_clp_shd.g_old_rec.business_group_id
310: ,p_seq_o => ben_clp_shd.g_old_rec.seq
311: ,p_ler1_id_o => ben_clp_shd.g_old_rec.ler1_id
312: ,p_bool1_cd_o => ben_clp_shd.g_old_rec.bool1_cd
305: ,p_effective_start_date => p_rec.effective_start_date
306: ,p_effective_end_date => p_rec.effective_end_date
307: ,p_effective_start_date_o => ben_clp_shd.g_old_rec.effective_start_date
308: ,p_effective_end_date_o => ben_clp_shd.g_old_rec.effective_end_date
309: ,p_business_group_id_o => ben_clp_shd.g_old_rec.business_group_id
310: ,p_seq_o => ben_clp_shd.g_old_rec.seq
311: ,p_ler1_id_o => ben_clp_shd.g_old_rec.ler1_id
312: ,p_bool1_cd_o => ben_clp_shd.g_old_rec.bool1_cd
313: ,p_ler2_id_o => ben_clp_shd.g_old_rec.ler2_id
306: ,p_effective_end_date => p_rec.effective_end_date
307: ,p_effective_start_date_o => ben_clp_shd.g_old_rec.effective_start_date
308: ,p_effective_end_date_o => ben_clp_shd.g_old_rec.effective_end_date
309: ,p_business_group_id_o => ben_clp_shd.g_old_rec.business_group_id
310: ,p_seq_o => ben_clp_shd.g_old_rec.seq
311: ,p_ler1_id_o => ben_clp_shd.g_old_rec.ler1_id
312: ,p_bool1_cd_o => ben_clp_shd.g_old_rec.bool1_cd
313: ,p_ler2_id_o => ben_clp_shd.g_old_rec.ler2_id
314: ,p_bool2_cd_o => ben_clp_shd.g_old_rec.bool2_cd
307: ,p_effective_start_date_o => ben_clp_shd.g_old_rec.effective_start_date
308: ,p_effective_end_date_o => ben_clp_shd.g_old_rec.effective_end_date
309: ,p_business_group_id_o => ben_clp_shd.g_old_rec.business_group_id
310: ,p_seq_o => ben_clp_shd.g_old_rec.seq
311: ,p_ler1_id_o => ben_clp_shd.g_old_rec.ler1_id
312: ,p_bool1_cd_o => ben_clp_shd.g_old_rec.bool1_cd
313: ,p_ler2_id_o => ben_clp_shd.g_old_rec.ler2_id
314: ,p_bool2_cd_o => ben_clp_shd.g_old_rec.bool2_cd
315: ,p_ler3_id_o => ben_clp_shd.g_old_rec.ler3_id
308: ,p_effective_end_date_o => ben_clp_shd.g_old_rec.effective_end_date
309: ,p_business_group_id_o => ben_clp_shd.g_old_rec.business_group_id
310: ,p_seq_o => ben_clp_shd.g_old_rec.seq
311: ,p_ler1_id_o => ben_clp_shd.g_old_rec.ler1_id
312: ,p_bool1_cd_o => ben_clp_shd.g_old_rec.bool1_cd
313: ,p_ler2_id_o => ben_clp_shd.g_old_rec.ler2_id
314: ,p_bool2_cd_o => ben_clp_shd.g_old_rec.bool2_cd
315: ,p_ler3_id_o => ben_clp_shd.g_old_rec.ler3_id
316: ,p_bool3_cd_o => ben_clp_shd.g_old_rec.bool3_cd
309: ,p_business_group_id_o => ben_clp_shd.g_old_rec.business_group_id
310: ,p_seq_o => ben_clp_shd.g_old_rec.seq
311: ,p_ler1_id_o => ben_clp_shd.g_old_rec.ler1_id
312: ,p_bool1_cd_o => ben_clp_shd.g_old_rec.bool1_cd
313: ,p_ler2_id_o => ben_clp_shd.g_old_rec.ler2_id
314: ,p_bool2_cd_o => ben_clp_shd.g_old_rec.bool2_cd
315: ,p_ler3_id_o => ben_clp_shd.g_old_rec.ler3_id
316: ,p_bool3_cd_o => ben_clp_shd.g_old_rec.bool3_cd
317: ,p_ler4_id_o => ben_clp_shd.g_old_rec.ler4_id
310: ,p_seq_o => ben_clp_shd.g_old_rec.seq
311: ,p_ler1_id_o => ben_clp_shd.g_old_rec.ler1_id
312: ,p_bool1_cd_o => ben_clp_shd.g_old_rec.bool1_cd
313: ,p_ler2_id_o => ben_clp_shd.g_old_rec.ler2_id
314: ,p_bool2_cd_o => ben_clp_shd.g_old_rec.bool2_cd
315: ,p_ler3_id_o => ben_clp_shd.g_old_rec.ler3_id
316: ,p_bool3_cd_o => ben_clp_shd.g_old_rec.bool3_cd
317: ,p_ler4_id_o => ben_clp_shd.g_old_rec.ler4_id
318: ,p_bool4_cd_o => ben_clp_shd.g_old_rec.bool4_cd
311: ,p_ler1_id_o => ben_clp_shd.g_old_rec.ler1_id
312: ,p_bool1_cd_o => ben_clp_shd.g_old_rec.bool1_cd
313: ,p_ler2_id_o => ben_clp_shd.g_old_rec.ler2_id
314: ,p_bool2_cd_o => ben_clp_shd.g_old_rec.bool2_cd
315: ,p_ler3_id_o => ben_clp_shd.g_old_rec.ler3_id
316: ,p_bool3_cd_o => ben_clp_shd.g_old_rec.bool3_cd
317: ,p_ler4_id_o => ben_clp_shd.g_old_rec.ler4_id
318: ,p_bool4_cd_o => ben_clp_shd.g_old_rec.bool4_cd
319: ,p_ler5_id_o => ben_clp_shd.g_old_rec.ler5_id
312: ,p_bool1_cd_o => ben_clp_shd.g_old_rec.bool1_cd
313: ,p_ler2_id_o => ben_clp_shd.g_old_rec.ler2_id
314: ,p_bool2_cd_o => ben_clp_shd.g_old_rec.bool2_cd
315: ,p_ler3_id_o => ben_clp_shd.g_old_rec.ler3_id
316: ,p_bool3_cd_o => ben_clp_shd.g_old_rec.bool3_cd
317: ,p_ler4_id_o => ben_clp_shd.g_old_rec.ler4_id
318: ,p_bool4_cd_o => ben_clp_shd.g_old_rec.bool4_cd
319: ,p_ler5_id_o => ben_clp_shd.g_old_rec.ler5_id
320: ,p_bool5_cd_o => ben_clp_shd.g_old_rec.bool5_cd
313: ,p_ler2_id_o => ben_clp_shd.g_old_rec.ler2_id
314: ,p_bool2_cd_o => ben_clp_shd.g_old_rec.bool2_cd
315: ,p_ler3_id_o => ben_clp_shd.g_old_rec.ler3_id
316: ,p_bool3_cd_o => ben_clp_shd.g_old_rec.bool3_cd
317: ,p_ler4_id_o => ben_clp_shd.g_old_rec.ler4_id
318: ,p_bool4_cd_o => ben_clp_shd.g_old_rec.bool4_cd
319: ,p_ler5_id_o => ben_clp_shd.g_old_rec.ler5_id
320: ,p_bool5_cd_o => ben_clp_shd.g_old_rec.bool5_cd
321: ,p_ler6_id_o => ben_clp_shd.g_old_rec.ler6_id
314: ,p_bool2_cd_o => ben_clp_shd.g_old_rec.bool2_cd
315: ,p_ler3_id_o => ben_clp_shd.g_old_rec.ler3_id
316: ,p_bool3_cd_o => ben_clp_shd.g_old_rec.bool3_cd
317: ,p_ler4_id_o => ben_clp_shd.g_old_rec.ler4_id
318: ,p_bool4_cd_o => ben_clp_shd.g_old_rec.bool4_cd
319: ,p_ler5_id_o => ben_clp_shd.g_old_rec.ler5_id
320: ,p_bool5_cd_o => ben_clp_shd.g_old_rec.bool5_cd
321: ,p_ler6_id_o => ben_clp_shd.g_old_rec.ler6_id
322: ,p_bool6_cd_o => ben_clp_shd.g_old_rec.bool6_cd
315: ,p_ler3_id_o => ben_clp_shd.g_old_rec.ler3_id
316: ,p_bool3_cd_o => ben_clp_shd.g_old_rec.bool3_cd
317: ,p_ler4_id_o => ben_clp_shd.g_old_rec.ler4_id
318: ,p_bool4_cd_o => ben_clp_shd.g_old_rec.bool4_cd
319: ,p_ler5_id_o => ben_clp_shd.g_old_rec.ler5_id
320: ,p_bool5_cd_o => ben_clp_shd.g_old_rec.bool5_cd
321: ,p_ler6_id_o => ben_clp_shd.g_old_rec.ler6_id
322: ,p_bool6_cd_o => ben_clp_shd.g_old_rec.bool6_cd
323: ,p_ler7_id_o => ben_clp_shd.g_old_rec.ler7_id
316: ,p_bool3_cd_o => ben_clp_shd.g_old_rec.bool3_cd
317: ,p_ler4_id_o => ben_clp_shd.g_old_rec.ler4_id
318: ,p_bool4_cd_o => ben_clp_shd.g_old_rec.bool4_cd
319: ,p_ler5_id_o => ben_clp_shd.g_old_rec.ler5_id
320: ,p_bool5_cd_o => ben_clp_shd.g_old_rec.bool5_cd
321: ,p_ler6_id_o => ben_clp_shd.g_old_rec.ler6_id
322: ,p_bool6_cd_o => ben_clp_shd.g_old_rec.bool6_cd
323: ,p_ler7_id_o => ben_clp_shd.g_old_rec.ler7_id
324: ,p_bool7_cd_o => ben_clp_shd.g_old_rec.bool7_cd
317: ,p_ler4_id_o => ben_clp_shd.g_old_rec.ler4_id
318: ,p_bool4_cd_o => ben_clp_shd.g_old_rec.bool4_cd
319: ,p_ler5_id_o => ben_clp_shd.g_old_rec.ler5_id
320: ,p_bool5_cd_o => ben_clp_shd.g_old_rec.bool5_cd
321: ,p_ler6_id_o => ben_clp_shd.g_old_rec.ler6_id
322: ,p_bool6_cd_o => ben_clp_shd.g_old_rec.bool6_cd
323: ,p_ler7_id_o => ben_clp_shd.g_old_rec.ler7_id
324: ,p_bool7_cd_o => ben_clp_shd.g_old_rec.bool7_cd
325: ,p_ler8_id_o => ben_clp_shd.g_old_rec.ler8_id
318: ,p_bool4_cd_o => ben_clp_shd.g_old_rec.bool4_cd
319: ,p_ler5_id_o => ben_clp_shd.g_old_rec.ler5_id
320: ,p_bool5_cd_o => ben_clp_shd.g_old_rec.bool5_cd
321: ,p_ler6_id_o => ben_clp_shd.g_old_rec.ler6_id
322: ,p_bool6_cd_o => ben_clp_shd.g_old_rec.bool6_cd
323: ,p_ler7_id_o => ben_clp_shd.g_old_rec.ler7_id
324: ,p_bool7_cd_o => ben_clp_shd.g_old_rec.bool7_cd
325: ,p_ler8_id_o => ben_clp_shd.g_old_rec.ler8_id
326: ,p_bool8_cd_o => ben_clp_shd.g_old_rec.bool8_cd
319: ,p_ler5_id_o => ben_clp_shd.g_old_rec.ler5_id
320: ,p_bool5_cd_o => ben_clp_shd.g_old_rec.bool5_cd
321: ,p_ler6_id_o => ben_clp_shd.g_old_rec.ler6_id
322: ,p_bool6_cd_o => ben_clp_shd.g_old_rec.bool6_cd
323: ,p_ler7_id_o => ben_clp_shd.g_old_rec.ler7_id
324: ,p_bool7_cd_o => ben_clp_shd.g_old_rec.bool7_cd
325: ,p_ler8_id_o => ben_clp_shd.g_old_rec.ler8_id
326: ,p_bool8_cd_o => ben_clp_shd.g_old_rec.bool8_cd
327: ,p_ler9_id_o => ben_clp_shd.g_old_rec.ler9_id
320: ,p_bool5_cd_o => ben_clp_shd.g_old_rec.bool5_cd
321: ,p_ler6_id_o => ben_clp_shd.g_old_rec.ler6_id
322: ,p_bool6_cd_o => ben_clp_shd.g_old_rec.bool6_cd
323: ,p_ler7_id_o => ben_clp_shd.g_old_rec.ler7_id
324: ,p_bool7_cd_o => ben_clp_shd.g_old_rec.bool7_cd
325: ,p_ler8_id_o => ben_clp_shd.g_old_rec.ler8_id
326: ,p_bool8_cd_o => ben_clp_shd.g_old_rec.bool8_cd
327: ,p_ler9_id_o => ben_clp_shd.g_old_rec.ler9_id
328: ,p_bool9_cd_o => ben_clp_shd.g_old_rec.bool9_cd
321: ,p_ler6_id_o => ben_clp_shd.g_old_rec.ler6_id
322: ,p_bool6_cd_o => ben_clp_shd.g_old_rec.bool6_cd
323: ,p_ler7_id_o => ben_clp_shd.g_old_rec.ler7_id
324: ,p_bool7_cd_o => ben_clp_shd.g_old_rec.bool7_cd
325: ,p_ler8_id_o => ben_clp_shd.g_old_rec.ler8_id
326: ,p_bool8_cd_o => ben_clp_shd.g_old_rec.bool8_cd
327: ,p_ler9_id_o => ben_clp_shd.g_old_rec.ler9_id
328: ,p_bool9_cd_o => ben_clp_shd.g_old_rec.bool9_cd
329: ,p_ler10_id_o => ben_clp_shd.g_old_rec.ler10_id
322: ,p_bool6_cd_o => ben_clp_shd.g_old_rec.bool6_cd
323: ,p_ler7_id_o => ben_clp_shd.g_old_rec.ler7_id
324: ,p_bool7_cd_o => ben_clp_shd.g_old_rec.bool7_cd
325: ,p_ler8_id_o => ben_clp_shd.g_old_rec.ler8_id
326: ,p_bool8_cd_o => ben_clp_shd.g_old_rec.bool8_cd
327: ,p_ler9_id_o => ben_clp_shd.g_old_rec.ler9_id
328: ,p_bool9_cd_o => ben_clp_shd.g_old_rec.bool9_cd
329: ,p_ler10_id_o => ben_clp_shd.g_old_rec.ler10_id
330: ,p_eval_cd_o => ben_clp_shd.g_old_rec.eval_cd
323: ,p_ler7_id_o => ben_clp_shd.g_old_rec.ler7_id
324: ,p_bool7_cd_o => ben_clp_shd.g_old_rec.bool7_cd
325: ,p_ler8_id_o => ben_clp_shd.g_old_rec.ler8_id
326: ,p_bool8_cd_o => ben_clp_shd.g_old_rec.bool8_cd
327: ,p_ler9_id_o => ben_clp_shd.g_old_rec.ler9_id
328: ,p_bool9_cd_o => ben_clp_shd.g_old_rec.bool9_cd
329: ,p_ler10_id_o => ben_clp_shd.g_old_rec.ler10_id
330: ,p_eval_cd_o => ben_clp_shd.g_old_rec.eval_cd
331: ,p_eval_rl_o => ben_clp_shd.g_old_rec.eval_rl
324: ,p_bool7_cd_o => ben_clp_shd.g_old_rec.bool7_cd
325: ,p_ler8_id_o => ben_clp_shd.g_old_rec.ler8_id
326: ,p_bool8_cd_o => ben_clp_shd.g_old_rec.bool8_cd
327: ,p_ler9_id_o => ben_clp_shd.g_old_rec.ler9_id
328: ,p_bool9_cd_o => ben_clp_shd.g_old_rec.bool9_cd
329: ,p_ler10_id_o => ben_clp_shd.g_old_rec.ler10_id
330: ,p_eval_cd_o => ben_clp_shd.g_old_rec.eval_cd
331: ,p_eval_rl_o => ben_clp_shd.g_old_rec.eval_rl
332: ,p_tlrnc_dys_num_o => ben_clp_shd.g_old_rec.tlrnc_dys_num
325: ,p_ler8_id_o => ben_clp_shd.g_old_rec.ler8_id
326: ,p_bool8_cd_o => ben_clp_shd.g_old_rec.bool8_cd
327: ,p_ler9_id_o => ben_clp_shd.g_old_rec.ler9_id
328: ,p_bool9_cd_o => ben_clp_shd.g_old_rec.bool9_cd
329: ,p_ler10_id_o => ben_clp_shd.g_old_rec.ler10_id
330: ,p_eval_cd_o => ben_clp_shd.g_old_rec.eval_cd
331: ,p_eval_rl_o => ben_clp_shd.g_old_rec.eval_rl
332: ,p_tlrnc_dys_num_o => ben_clp_shd.g_old_rec.tlrnc_dys_num
333: ,p_eval_ler_id_o => ben_clp_shd.g_old_rec.eval_ler_id
326: ,p_bool8_cd_o => ben_clp_shd.g_old_rec.bool8_cd
327: ,p_ler9_id_o => ben_clp_shd.g_old_rec.ler9_id
328: ,p_bool9_cd_o => ben_clp_shd.g_old_rec.bool9_cd
329: ,p_ler10_id_o => ben_clp_shd.g_old_rec.ler10_id
330: ,p_eval_cd_o => ben_clp_shd.g_old_rec.eval_cd
331: ,p_eval_rl_o => ben_clp_shd.g_old_rec.eval_rl
332: ,p_tlrnc_dys_num_o => ben_clp_shd.g_old_rec.tlrnc_dys_num
333: ,p_eval_ler_id_o => ben_clp_shd.g_old_rec.eval_ler_id
334: ,p_eval_ler_det_cd_o => ben_clp_shd.g_old_rec.eval_ler_det_cd
327: ,p_ler9_id_o => ben_clp_shd.g_old_rec.ler9_id
328: ,p_bool9_cd_o => ben_clp_shd.g_old_rec.bool9_cd
329: ,p_ler10_id_o => ben_clp_shd.g_old_rec.ler10_id
330: ,p_eval_cd_o => ben_clp_shd.g_old_rec.eval_cd
331: ,p_eval_rl_o => ben_clp_shd.g_old_rec.eval_rl
332: ,p_tlrnc_dys_num_o => ben_clp_shd.g_old_rec.tlrnc_dys_num
333: ,p_eval_ler_id_o => ben_clp_shd.g_old_rec.eval_ler_id
334: ,p_eval_ler_det_cd_o => ben_clp_shd.g_old_rec.eval_ler_det_cd
335: ,p_eval_ler_det_rl_o => ben_clp_shd.g_old_rec.eval_ler_det_rl
328: ,p_bool9_cd_o => ben_clp_shd.g_old_rec.bool9_cd
329: ,p_ler10_id_o => ben_clp_shd.g_old_rec.ler10_id
330: ,p_eval_cd_o => ben_clp_shd.g_old_rec.eval_cd
331: ,p_eval_rl_o => ben_clp_shd.g_old_rec.eval_rl
332: ,p_tlrnc_dys_num_o => ben_clp_shd.g_old_rec.tlrnc_dys_num
333: ,p_eval_ler_id_o => ben_clp_shd.g_old_rec.eval_ler_id
334: ,p_eval_ler_det_cd_o => ben_clp_shd.g_old_rec.eval_ler_det_cd
335: ,p_eval_ler_det_rl_o => ben_clp_shd.g_old_rec.eval_ler_det_rl
336: ,p_clp_attribute_category_o => ben_clp_shd.g_old_rec.clp_attribute_category
329: ,p_ler10_id_o => ben_clp_shd.g_old_rec.ler10_id
330: ,p_eval_cd_o => ben_clp_shd.g_old_rec.eval_cd
331: ,p_eval_rl_o => ben_clp_shd.g_old_rec.eval_rl
332: ,p_tlrnc_dys_num_o => ben_clp_shd.g_old_rec.tlrnc_dys_num
333: ,p_eval_ler_id_o => ben_clp_shd.g_old_rec.eval_ler_id
334: ,p_eval_ler_det_cd_o => ben_clp_shd.g_old_rec.eval_ler_det_cd
335: ,p_eval_ler_det_rl_o => ben_clp_shd.g_old_rec.eval_ler_det_rl
336: ,p_clp_attribute_category_o => ben_clp_shd.g_old_rec.clp_attribute_category
337: ,p_clp_attribute1_o => ben_clp_shd.g_old_rec.clp_attribute1
330: ,p_eval_cd_o => ben_clp_shd.g_old_rec.eval_cd
331: ,p_eval_rl_o => ben_clp_shd.g_old_rec.eval_rl
332: ,p_tlrnc_dys_num_o => ben_clp_shd.g_old_rec.tlrnc_dys_num
333: ,p_eval_ler_id_o => ben_clp_shd.g_old_rec.eval_ler_id
334: ,p_eval_ler_det_cd_o => ben_clp_shd.g_old_rec.eval_ler_det_cd
335: ,p_eval_ler_det_rl_o => ben_clp_shd.g_old_rec.eval_ler_det_rl
336: ,p_clp_attribute_category_o => ben_clp_shd.g_old_rec.clp_attribute_category
337: ,p_clp_attribute1_o => ben_clp_shd.g_old_rec.clp_attribute1
338: ,p_clp_attribute2_o => ben_clp_shd.g_old_rec.clp_attribute2
331: ,p_eval_rl_o => ben_clp_shd.g_old_rec.eval_rl
332: ,p_tlrnc_dys_num_o => ben_clp_shd.g_old_rec.tlrnc_dys_num
333: ,p_eval_ler_id_o => ben_clp_shd.g_old_rec.eval_ler_id
334: ,p_eval_ler_det_cd_o => ben_clp_shd.g_old_rec.eval_ler_det_cd
335: ,p_eval_ler_det_rl_o => ben_clp_shd.g_old_rec.eval_ler_det_rl
336: ,p_clp_attribute_category_o => ben_clp_shd.g_old_rec.clp_attribute_category
337: ,p_clp_attribute1_o => ben_clp_shd.g_old_rec.clp_attribute1
338: ,p_clp_attribute2_o => ben_clp_shd.g_old_rec.clp_attribute2
339: ,p_clp_attribute3_o => ben_clp_shd.g_old_rec.clp_attribute3
332: ,p_tlrnc_dys_num_o => ben_clp_shd.g_old_rec.tlrnc_dys_num
333: ,p_eval_ler_id_o => ben_clp_shd.g_old_rec.eval_ler_id
334: ,p_eval_ler_det_cd_o => ben_clp_shd.g_old_rec.eval_ler_det_cd
335: ,p_eval_ler_det_rl_o => ben_clp_shd.g_old_rec.eval_ler_det_rl
336: ,p_clp_attribute_category_o => ben_clp_shd.g_old_rec.clp_attribute_category
337: ,p_clp_attribute1_o => ben_clp_shd.g_old_rec.clp_attribute1
338: ,p_clp_attribute2_o => ben_clp_shd.g_old_rec.clp_attribute2
339: ,p_clp_attribute3_o => ben_clp_shd.g_old_rec.clp_attribute3
340: ,p_clp_attribute4_o => ben_clp_shd.g_old_rec.clp_attribute4
333: ,p_eval_ler_id_o => ben_clp_shd.g_old_rec.eval_ler_id
334: ,p_eval_ler_det_cd_o => ben_clp_shd.g_old_rec.eval_ler_det_cd
335: ,p_eval_ler_det_rl_o => ben_clp_shd.g_old_rec.eval_ler_det_rl
336: ,p_clp_attribute_category_o => ben_clp_shd.g_old_rec.clp_attribute_category
337: ,p_clp_attribute1_o => ben_clp_shd.g_old_rec.clp_attribute1
338: ,p_clp_attribute2_o => ben_clp_shd.g_old_rec.clp_attribute2
339: ,p_clp_attribute3_o => ben_clp_shd.g_old_rec.clp_attribute3
340: ,p_clp_attribute4_o => ben_clp_shd.g_old_rec.clp_attribute4
341: ,p_clp_attribute5_o => ben_clp_shd.g_old_rec.clp_attribute5
334: ,p_eval_ler_det_cd_o => ben_clp_shd.g_old_rec.eval_ler_det_cd
335: ,p_eval_ler_det_rl_o => ben_clp_shd.g_old_rec.eval_ler_det_rl
336: ,p_clp_attribute_category_o => ben_clp_shd.g_old_rec.clp_attribute_category
337: ,p_clp_attribute1_o => ben_clp_shd.g_old_rec.clp_attribute1
338: ,p_clp_attribute2_o => ben_clp_shd.g_old_rec.clp_attribute2
339: ,p_clp_attribute3_o => ben_clp_shd.g_old_rec.clp_attribute3
340: ,p_clp_attribute4_o => ben_clp_shd.g_old_rec.clp_attribute4
341: ,p_clp_attribute5_o => ben_clp_shd.g_old_rec.clp_attribute5
342: ,p_clp_attribute6_o => ben_clp_shd.g_old_rec.clp_attribute6
335: ,p_eval_ler_det_rl_o => ben_clp_shd.g_old_rec.eval_ler_det_rl
336: ,p_clp_attribute_category_o => ben_clp_shd.g_old_rec.clp_attribute_category
337: ,p_clp_attribute1_o => ben_clp_shd.g_old_rec.clp_attribute1
338: ,p_clp_attribute2_o => ben_clp_shd.g_old_rec.clp_attribute2
339: ,p_clp_attribute3_o => ben_clp_shd.g_old_rec.clp_attribute3
340: ,p_clp_attribute4_o => ben_clp_shd.g_old_rec.clp_attribute4
341: ,p_clp_attribute5_o => ben_clp_shd.g_old_rec.clp_attribute5
342: ,p_clp_attribute6_o => ben_clp_shd.g_old_rec.clp_attribute6
343: ,p_clp_attribute7_o => ben_clp_shd.g_old_rec.clp_attribute7
336: ,p_clp_attribute_category_o => ben_clp_shd.g_old_rec.clp_attribute_category
337: ,p_clp_attribute1_o => ben_clp_shd.g_old_rec.clp_attribute1
338: ,p_clp_attribute2_o => ben_clp_shd.g_old_rec.clp_attribute2
339: ,p_clp_attribute3_o => ben_clp_shd.g_old_rec.clp_attribute3
340: ,p_clp_attribute4_o => ben_clp_shd.g_old_rec.clp_attribute4
341: ,p_clp_attribute5_o => ben_clp_shd.g_old_rec.clp_attribute5
342: ,p_clp_attribute6_o => ben_clp_shd.g_old_rec.clp_attribute6
343: ,p_clp_attribute7_o => ben_clp_shd.g_old_rec.clp_attribute7
344: ,p_clp_attribute8_o => ben_clp_shd.g_old_rec.clp_attribute8
337: ,p_clp_attribute1_o => ben_clp_shd.g_old_rec.clp_attribute1
338: ,p_clp_attribute2_o => ben_clp_shd.g_old_rec.clp_attribute2
339: ,p_clp_attribute3_o => ben_clp_shd.g_old_rec.clp_attribute3
340: ,p_clp_attribute4_o => ben_clp_shd.g_old_rec.clp_attribute4
341: ,p_clp_attribute5_o => ben_clp_shd.g_old_rec.clp_attribute5
342: ,p_clp_attribute6_o => ben_clp_shd.g_old_rec.clp_attribute6
343: ,p_clp_attribute7_o => ben_clp_shd.g_old_rec.clp_attribute7
344: ,p_clp_attribute8_o => ben_clp_shd.g_old_rec.clp_attribute8
345: ,p_clp_attribute9_o => ben_clp_shd.g_old_rec.clp_attribute9
338: ,p_clp_attribute2_o => ben_clp_shd.g_old_rec.clp_attribute2
339: ,p_clp_attribute3_o => ben_clp_shd.g_old_rec.clp_attribute3
340: ,p_clp_attribute4_o => ben_clp_shd.g_old_rec.clp_attribute4
341: ,p_clp_attribute5_o => ben_clp_shd.g_old_rec.clp_attribute5
342: ,p_clp_attribute6_o => ben_clp_shd.g_old_rec.clp_attribute6
343: ,p_clp_attribute7_o => ben_clp_shd.g_old_rec.clp_attribute7
344: ,p_clp_attribute8_o => ben_clp_shd.g_old_rec.clp_attribute8
345: ,p_clp_attribute9_o => ben_clp_shd.g_old_rec.clp_attribute9
346: ,p_clp_attribute10_o => ben_clp_shd.g_old_rec.clp_attribute10
339: ,p_clp_attribute3_o => ben_clp_shd.g_old_rec.clp_attribute3
340: ,p_clp_attribute4_o => ben_clp_shd.g_old_rec.clp_attribute4
341: ,p_clp_attribute5_o => ben_clp_shd.g_old_rec.clp_attribute5
342: ,p_clp_attribute6_o => ben_clp_shd.g_old_rec.clp_attribute6
343: ,p_clp_attribute7_o => ben_clp_shd.g_old_rec.clp_attribute7
344: ,p_clp_attribute8_o => ben_clp_shd.g_old_rec.clp_attribute8
345: ,p_clp_attribute9_o => ben_clp_shd.g_old_rec.clp_attribute9
346: ,p_clp_attribute10_o => ben_clp_shd.g_old_rec.clp_attribute10
347: ,p_clp_attribute11_o => ben_clp_shd.g_old_rec.clp_attribute11
340: ,p_clp_attribute4_o => ben_clp_shd.g_old_rec.clp_attribute4
341: ,p_clp_attribute5_o => ben_clp_shd.g_old_rec.clp_attribute5
342: ,p_clp_attribute6_o => ben_clp_shd.g_old_rec.clp_attribute6
343: ,p_clp_attribute7_o => ben_clp_shd.g_old_rec.clp_attribute7
344: ,p_clp_attribute8_o => ben_clp_shd.g_old_rec.clp_attribute8
345: ,p_clp_attribute9_o => ben_clp_shd.g_old_rec.clp_attribute9
346: ,p_clp_attribute10_o => ben_clp_shd.g_old_rec.clp_attribute10
347: ,p_clp_attribute11_o => ben_clp_shd.g_old_rec.clp_attribute11
348: ,p_clp_attribute12_o => ben_clp_shd.g_old_rec.clp_attribute12
341: ,p_clp_attribute5_o => ben_clp_shd.g_old_rec.clp_attribute5
342: ,p_clp_attribute6_o => ben_clp_shd.g_old_rec.clp_attribute6
343: ,p_clp_attribute7_o => ben_clp_shd.g_old_rec.clp_attribute7
344: ,p_clp_attribute8_o => ben_clp_shd.g_old_rec.clp_attribute8
345: ,p_clp_attribute9_o => ben_clp_shd.g_old_rec.clp_attribute9
346: ,p_clp_attribute10_o => ben_clp_shd.g_old_rec.clp_attribute10
347: ,p_clp_attribute11_o => ben_clp_shd.g_old_rec.clp_attribute11
348: ,p_clp_attribute12_o => ben_clp_shd.g_old_rec.clp_attribute12
349: ,p_clp_attribute13_o => ben_clp_shd.g_old_rec.clp_attribute13
342: ,p_clp_attribute6_o => ben_clp_shd.g_old_rec.clp_attribute6
343: ,p_clp_attribute7_o => ben_clp_shd.g_old_rec.clp_attribute7
344: ,p_clp_attribute8_o => ben_clp_shd.g_old_rec.clp_attribute8
345: ,p_clp_attribute9_o => ben_clp_shd.g_old_rec.clp_attribute9
346: ,p_clp_attribute10_o => ben_clp_shd.g_old_rec.clp_attribute10
347: ,p_clp_attribute11_o => ben_clp_shd.g_old_rec.clp_attribute11
348: ,p_clp_attribute12_o => ben_clp_shd.g_old_rec.clp_attribute12
349: ,p_clp_attribute13_o => ben_clp_shd.g_old_rec.clp_attribute13
350: ,p_clp_attribute14_o => ben_clp_shd.g_old_rec.clp_attribute14
343: ,p_clp_attribute7_o => ben_clp_shd.g_old_rec.clp_attribute7
344: ,p_clp_attribute8_o => ben_clp_shd.g_old_rec.clp_attribute8
345: ,p_clp_attribute9_o => ben_clp_shd.g_old_rec.clp_attribute9
346: ,p_clp_attribute10_o => ben_clp_shd.g_old_rec.clp_attribute10
347: ,p_clp_attribute11_o => ben_clp_shd.g_old_rec.clp_attribute11
348: ,p_clp_attribute12_o => ben_clp_shd.g_old_rec.clp_attribute12
349: ,p_clp_attribute13_o => ben_clp_shd.g_old_rec.clp_attribute13
350: ,p_clp_attribute14_o => ben_clp_shd.g_old_rec.clp_attribute14
351: ,p_clp_attribute15_o => ben_clp_shd.g_old_rec.clp_attribute15
344: ,p_clp_attribute8_o => ben_clp_shd.g_old_rec.clp_attribute8
345: ,p_clp_attribute9_o => ben_clp_shd.g_old_rec.clp_attribute9
346: ,p_clp_attribute10_o => ben_clp_shd.g_old_rec.clp_attribute10
347: ,p_clp_attribute11_o => ben_clp_shd.g_old_rec.clp_attribute11
348: ,p_clp_attribute12_o => ben_clp_shd.g_old_rec.clp_attribute12
349: ,p_clp_attribute13_o => ben_clp_shd.g_old_rec.clp_attribute13
350: ,p_clp_attribute14_o => ben_clp_shd.g_old_rec.clp_attribute14
351: ,p_clp_attribute15_o => ben_clp_shd.g_old_rec.clp_attribute15
352: ,p_clp_attribute16_o => ben_clp_shd.g_old_rec.clp_attribute16
345: ,p_clp_attribute9_o => ben_clp_shd.g_old_rec.clp_attribute9
346: ,p_clp_attribute10_o => ben_clp_shd.g_old_rec.clp_attribute10
347: ,p_clp_attribute11_o => ben_clp_shd.g_old_rec.clp_attribute11
348: ,p_clp_attribute12_o => ben_clp_shd.g_old_rec.clp_attribute12
349: ,p_clp_attribute13_o => ben_clp_shd.g_old_rec.clp_attribute13
350: ,p_clp_attribute14_o => ben_clp_shd.g_old_rec.clp_attribute14
351: ,p_clp_attribute15_o => ben_clp_shd.g_old_rec.clp_attribute15
352: ,p_clp_attribute16_o => ben_clp_shd.g_old_rec.clp_attribute16
353: ,p_clp_attribute17_o => ben_clp_shd.g_old_rec.clp_attribute17
346: ,p_clp_attribute10_o => ben_clp_shd.g_old_rec.clp_attribute10
347: ,p_clp_attribute11_o => ben_clp_shd.g_old_rec.clp_attribute11
348: ,p_clp_attribute12_o => ben_clp_shd.g_old_rec.clp_attribute12
349: ,p_clp_attribute13_o => ben_clp_shd.g_old_rec.clp_attribute13
350: ,p_clp_attribute14_o => ben_clp_shd.g_old_rec.clp_attribute14
351: ,p_clp_attribute15_o => ben_clp_shd.g_old_rec.clp_attribute15
352: ,p_clp_attribute16_o => ben_clp_shd.g_old_rec.clp_attribute16
353: ,p_clp_attribute17_o => ben_clp_shd.g_old_rec.clp_attribute17
354: ,p_clp_attribute18_o => ben_clp_shd.g_old_rec.clp_attribute18
347: ,p_clp_attribute11_o => ben_clp_shd.g_old_rec.clp_attribute11
348: ,p_clp_attribute12_o => ben_clp_shd.g_old_rec.clp_attribute12
349: ,p_clp_attribute13_o => ben_clp_shd.g_old_rec.clp_attribute13
350: ,p_clp_attribute14_o => ben_clp_shd.g_old_rec.clp_attribute14
351: ,p_clp_attribute15_o => ben_clp_shd.g_old_rec.clp_attribute15
352: ,p_clp_attribute16_o => ben_clp_shd.g_old_rec.clp_attribute16
353: ,p_clp_attribute17_o => ben_clp_shd.g_old_rec.clp_attribute17
354: ,p_clp_attribute18_o => ben_clp_shd.g_old_rec.clp_attribute18
355: ,p_clp_attribute19_o => ben_clp_shd.g_old_rec.clp_attribute19
348: ,p_clp_attribute12_o => ben_clp_shd.g_old_rec.clp_attribute12
349: ,p_clp_attribute13_o => ben_clp_shd.g_old_rec.clp_attribute13
350: ,p_clp_attribute14_o => ben_clp_shd.g_old_rec.clp_attribute14
351: ,p_clp_attribute15_o => ben_clp_shd.g_old_rec.clp_attribute15
352: ,p_clp_attribute16_o => ben_clp_shd.g_old_rec.clp_attribute16
353: ,p_clp_attribute17_o => ben_clp_shd.g_old_rec.clp_attribute17
354: ,p_clp_attribute18_o => ben_clp_shd.g_old_rec.clp_attribute18
355: ,p_clp_attribute19_o => ben_clp_shd.g_old_rec.clp_attribute19
356: ,p_clp_attribute20_o => ben_clp_shd.g_old_rec.clp_attribute20
349: ,p_clp_attribute13_o => ben_clp_shd.g_old_rec.clp_attribute13
350: ,p_clp_attribute14_o => ben_clp_shd.g_old_rec.clp_attribute14
351: ,p_clp_attribute15_o => ben_clp_shd.g_old_rec.clp_attribute15
352: ,p_clp_attribute16_o => ben_clp_shd.g_old_rec.clp_attribute16
353: ,p_clp_attribute17_o => ben_clp_shd.g_old_rec.clp_attribute17
354: ,p_clp_attribute18_o => ben_clp_shd.g_old_rec.clp_attribute18
355: ,p_clp_attribute19_o => ben_clp_shd.g_old_rec.clp_attribute19
356: ,p_clp_attribute20_o => ben_clp_shd.g_old_rec.clp_attribute20
357: ,p_clp_attribute21_o => ben_clp_shd.g_old_rec.clp_attribute21
350: ,p_clp_attribute14_o => ben_clp_shd.g_old_rec.clp_attribute14
351: ,p_clp_attribute15_o => ben_clp_shd.g_old_rec.clp_attribute15
352: ,p_clp_attribute16_o => ben_clp_shd.g_old_rec.clp_attribute16
353: ,p_clp_attribute17_o => ben_clp_shd.g_old_rec.clp_attribute17
354: ,p_clp_attribute18_o => ben_clp_shd.g_old_rec.clp_attribute18
355: ,p_clp_attribute19_o => ben_clp_shd.g_old_rec.clp_attribute19
356: ,p_clp_attribute20_o => ben_clp_shd.g_old_rec.clp_attribute20
357: ,p_clp_attribute21_o => ben_clp_shd.g_old_rec.clp_attribute21
358: ,p_clp_attribute22_o => ben_clp_shd.g_old_rec.clp_attribute22
351: ,p_clp_attribute15_o => ben_clp_shd.g_old_rec.clp_attribute15
352: ,p_clp_attribute16_o => ben_clp_shd.g_old_rec.clp_attribute16
353: ,p_clp_attribute17_o => ben_clp_shd.g_old_rec.clp_attribute17
354: ,p_clp_attribute18_o => ben_clp_shd.g_old_rec.clp_attribute18
355: ,p_clp_attribute19_o => ben_clp_shd.g_old_rec.clp_attribute19
356: ,p_clp_attribute20_o => ben_clp_shd.g_old_rec.clp_attribute20
357: ,p_clp_attribute21_o => ben_clp_shd.g_old_rec.clp_attribute21
358: ,p_clp_attribute22_o => ben_clp_shd.g_old_rec.clp_attribute22
359: ,p_clp_attribute23_o => ben_clp_shd.g_old_rec.clp_attribute23
352: ,p_clp_attribute16_o => ben_clp_shd.g_old_rec.clp_attribute16
353: ,p_clp_attribute17_o => ben_clp_shd.g_old_rec.clp_attribute17
354: ,p_clp_attribute18_o => ben_clp_shd.g_old_rec.clp_attribute18
355: ,p_clp_attribute19_o => ben_clp_shd.g_old_rec.clp_attribute19
356: ,p_clp_attribute20_o => ben_clp_shd.g_old_rec.clp_attribute20
357: ,p_clp_attribute21_o => ben_clp_shd.g_old_rec.clp_attribute21
358: ,p_clp_attribute22_o => ben_clp_shd.g_old_rec.clp_attribute22
359: ,p_clp_attribute23_o => ben_clp_shd.g_old_rec.clp_attribute23
360: ,p_clp_attribute24_o => ben_clp_shd.g_old_rec.clp_attribute24
353: ,p_clp_attribute17_o => ben_clp_shd.g_old_rec.clp_attribute17
354: ,p_clp_attribute18_o => ben_clp_shd.g_old_rec.clp_attribute18
355: ,p_clp_attribute19_o => ben_clp_shd.g_old_rec.clp_attribute19
356: ,p_clp_attribute20_o => ben_clp_shd.g_old_rec.clp_attribute20
357: ,p_clp_attribute21_o => ben_clp_shd.g_old_rec.clp_attribute21
358: ,p_clp_attribute22_o => ben_clp_shd.g_old_rec.clp_attribute22
359: ,p_clp_attribute23_o => ben_clp_shd.g_old_rec.clp_attribute23
360: ,p_clp_attribute24_o => ben_clp_shd.g_old_rec.clp_attribute24
361: ,p_clp_attribute25_o => ben_clp_shd.g_old_rec.clp_attribute25
354: ,p_clp_attribute18_o => ben_clp_shd.g_old_rec.clp_attribute18
355: ,p_clp_attribute19_o => ben_clp_shd.g_old_rec.clp_attribute19
356: ,p_clp_attribute20_o => ben_clp_shd.g_old_rec.clp_attribute20
357: ,p_clp_attribute21_o => ben_clp_shd.g_old_rec.clp_attribute21
358: ,p_clp_attribute22_o => ben_clp_shd.g_old_rec.clp_attribute22
359: ,p_clp_attribute23_o => ben_clp_shd.g_old_rec.clp_attribute23
360: ,p_clp_attribute24_o => ben_clp_shd.g_old_rec.clp_attribute24
361: ,p_clp_attribute25_o => ben_clp_shd.g_old_rec.clp_attribute25
362: ,p_clp_attribute26_o => ben_clp_shd.g_old_rec.clp_attribute26
355: ,p_clp_attribute19_o => ben_clp_shd.g_old_rec.clp_attribute19
356: ,p_clp_attribute20_o => ben_clp_shd.g_old_rec.clp_attribute20
357: ,p_clp_attribute21_o => ben_clp_shd.g_old_rec.clp_attribute21
358: ,p_clp_attribute22_o => ben_clp_shd.g_old_rec.clp_attribute22
359: ,p_clp_attribute23_o => ben_clp_shd.g_old_rec.clp_attribute23
360: ,p_clp_attribute24_o => ben_clp_shd.g_old_rec.clp_attribute24
361: ,p_clp_attribute25_o => ben_clp_shd.g_old_rec.clp_attribute25
362: ,p_clp_attribute26_o => ben_clp_shd.g_old_rec.clp_attribute26
363: ,p_clp_attribute27_o => ben_clp_shd.g_old_rec.clp_attribute27
356: ,p_clp_attribute20_o => ben_clp_shd.g_old_rec.clp_attribute20
357: ,p_clp_attribute21_o => ben_clp_shd.g_old_rec.clp_attribute21
358: ,p_clp_attribute22_o => ben_clp_shd.g_old_rec.clp_attribute22
359: ,p_clp_attribute23_o => ben_clp_shd.g_old_rec.clp_attribute23
360: ,p_clp_attribute24_o => ben_clp_shd.g_old_rec.clp_attribute24
361: ,p_clp_attribute25_o => ben_clp_shd.g_old_rec.clp_attribute25
362: ,p_clp_attribute26_o => ben_clp_shd.g_old_rec.clp_attribute26
363: ,p_clp_attribute27_o => ben_clp_shd.g_old_rec.clp_attribute27
364: ,p_clp_attribute28_o => ben_clp_shd.g_old_rec.clp_attribute28
357: ,p_clp_attribute21_o => ben_clp_shd.g_old_rec.clp_attribute21
358: ,p_clp_attribute22_o => ben_clp_shd.g_old_rec.clp_attribute22
359: ,p_clp_attribute23_o => ben_clp_shd.g_old_rec.clp_attribute23
360: ,p_clp_attribute24_o => ben_clp_shd.g_old_rec.clp_attribute24
361: ,p_clp_attribute25_o => ben_clp_shd.g_old_rec.clp_attribute25
362: ,p_clp_attribute26_o => ben_clp_shd.g_old_rec.clp_attribute26
363: ,p_clp_attribute27_o => ben_clp_shd.g_old_rec.clp_attribute27
364: ,p_clp_attribute28_o => ben_clp_shd.g_old_rec.clp_attribute28
365: ,p_clp_attribute29_o => ben_clp_shd.g_old_rec.clp_attribute29
358: ,p_clp_attribute22_o => ben_clp_shd.g_old_rec.clp_attribute22
359: ,p_clp_attribute23_o => ben_clp_shd.g_old_rec.clp_attribute23
360: ,p_clp_attribute24_o => ben_clp_shd.g_old_rec.clp_attribute24
361: ,p_clp_attribute25_o => ben_clp_shd.g_old_rec.clp_attribute25
362: ,p_clp_attribute26_o => ben_clp_shd.g_old_rec.clp_attribute26
363: ,p_clp_attribute27_o => ben_clp_shd.g_old_rec.clp_attribute27
364: ,p_clp_attribute28_o => ben_clp_shd.g_old_rec.clp_attribute28
365: ,p_clp_attribute29_o => ben_clp_shd.g_old_rec.clp_attribute29
366: ,p_clp_attribute30_o => ben_clp_shd.g_old_rec.clp_attribute30
359: ,p_clp_attribute23_o => ben_clp_shd.g_old_rec.clp_attribute23
360: ,p_clp_attribute24_o => ben_clp_shd.g_old_rec.clp_attribute24
361: ,p_clp_attribute25_o => ben_clp_shd.g_old_rec.clp_attribute25
362: ,p_clp_attribute26_o => ben_clp_shd.g_old_rec.clp_attribute26
363: ,p_clp_attribute27_o => ben_clp_shd.g_old_rec.clp_attribute27
364: ,p_clp_attribute28_o => ben_clp_shd.g_old_rec.clp_attribute28
365: ,p_clp_attribute29_o => ben_clp_shd.g_old_rec.clp_attribute29
366: ,p_clp_attribute30_o => ben_clp_shd.g_old_rec.clp_attribute30
367: ,p_object_version_number_o => ben_clp_shd.g_old_rec.object_version_number);
360: ,p_clp_attribute24_o => ben_clp_shd.g_old_rec.clp_attribute24
361: ,p_clp_attribute25_o => ben_clp_shd.g_old_rec.clp_attribute25
362: ,p_clp_attribute26_o => ben_clp_shd.g_old_rec.clp_attribute26
363: ,p_clp_attribute27_o => ben_clp_shd.g_old_rec.clp_attribute27
364: ,p_clp_attribute28_o => ben_clp_shd.g_old_rec.clp_attribute28
365: ,p_clp_attribute29_o => ben_clp_shd.g_old_rec.clp_attribute29
366: ,p_clp_attribute30_o => ben_clp_shd.g_old_rec.clp_attribute30
367: ,p_object_version_number_o => ben_clp_shd.g_old_rec.object_version_number);
368: --
361: ,p_clp_attribute25_o => ben_clp_shd.g_old_rec.clp_attribute25
362: ,p_clp_attribute26_o => ben_clp_shd.g_old_rec.clp_attribute26
363: ,p_clp_attribute27_o => ben_clp_shd.g_old_rec.clp_attribute27
364: ,p_clp_attribute28_o => ben_clp_shd.g_old_rec.clp_attribute28
365: ,p_clp_attribute29_o => ben_clp_shd.g_old_rec.clp_attribute29
366: ,p_clp_attribute30_o => ben_clp_shd.g_old_rec.clp_attribute30
367: ,p_object_version_number_o => ben_clp_shd.g_old_rec.object_version_number);
368: --
369: exception
362: ,p_clp_attribute26_o => ben_clp_shd.g_old_rec.clp_attribute26
363: ,p_clp_attribute27_o => ben_clp_shd.g_old_rec.clp_attribute27
364: ,p_clp_attribute28_o => ben_clp_shd.g_old_rec.clp_attribute28
365: ,p_clp_attribute29_o => ben_clp_shd.g_old_rec.clp_attribute29
366: ,p_clp_attribute30_o => ben_clp_shd.g_old_rec.clp_attribute30
367: ,p_object_version_number_o => ben_clp_shd.g_old_rec.object_version_number);
368: --
369: exception
370: --
363: ,p_clp_attribute27_o => ben_clp_shd.g_old_rec.clp_attribute27
364: ,p_clp_attribute28_o => ben_clp_shd.g_old_rec.clp_attribute28
365: ,p_clp_attribute29_o => ben_clp_shd.g_old_rec.clp_attribute29
366: ,p_clp_attribute30_o => ben_clp_shd.g_old_rec.clp_attribute30
367: ,p_object_version_number_o => ben_clp_shd.g_old_rec.object_version_number);
368: --
369: exception
370: --
371: when hr_api.cannot_find_prog_unit then
386: -- |---------------------------------< del >----------------------------------|
387: -- ----------------------------------------------------------------------------
388: Procedure del
389: (
390: p_rec in out nocopy ben_clp_shd.g_rec_type,
391: p_effective_date in date,
392: p_datetrack_mode in varchar2
393: ) is
394: --
404: dt_api.validate_dt_del_mode(p_datetrack_mode => p_datetrack_mode);
405: --
406: -- We must lock the row which we need to delete.
407: --
408: ben_clp_shd.lck
409: (p_effective_date => p_effective_date,
410: p_datetrack_mode => p_datetrack_mode,
411: p_clpse_lf_evt_id => p_rec.clpse_lf_evt_id,
412: p_object_version_number => p_rec.object_version_number,
462: p_effective_date in date,
463: p_datetrack_mode in varchar2
464: ) is
465: --
466: l_rec ben_clp_shd.g_rec_type;
467: l_proc varchar2(72) := g_package||'del';
468: --
469: Begin
470: hr_utility.set_location('Entering:'||l_proc, 5);