DBA Data[Home] [Help]

APPS.BEN_CLP_DEL dependencies on BEN_CLP_SHD

Line 54: (p_rec in out nocopy ben_clp_shd.g_rec_type,

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

Line 66: ben_clp_shd.g_api_dml := true; -- Set the api dml status

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: --

Line 75: ben_clp_shd.g_api_dml := false; -- Unset the api dml status

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: --

Line 78: ben_clp_shd.g_api_dml := true; -- Set the api dml status

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: --

Line 87: ben_clp_shd.g_api_dml := false; -- Unset the api dml status

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: --

Line 94: ben_clp_shd.g_api_dml := false; -- Unset the api dml status

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: -- ----------------------------------------------------------------------------

Line 102: (p_rec in out nocopy ben_clp_shd.g_rec_type,

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

Line 156: (p_rec in out nocopy ben_clp_shd.g_rec_type,

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

Line 169: p_rec.effective_start_date := ben_clp_shd.g_old_rec.effective_start_date;

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

Line 179: ben_clp_shd.upd_effective_end_date

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,

Line 227: (p_rec in out nocopy ben_clp_shd.g_rec_type,

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

Line 285: (p_rec in ben_clp_shd.g_rec_type,

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

Line 307: ,p_effective_start_date_o => ben_clp_shd.g_old_rec.effective_start_date

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

Line 308: ,p_effective_end_date_o => ben_clp_shd.g_old_rec.effective_end_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
312: ,p_bool1_cd_o => ben_clp_shd.g_old_rec.bool1_cd

Line 309: ,p_business_group_id_o => ben_clp_shd.g_old_rec.business_group_id

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

Line 310: ,p_seq_o => ben_clp_shd.g_old_rec.seq

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

Line 311: ,p_ler1_id_o => ben_clp_shd.g_old_rec.ler1_id

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

Line 312: ,p_bool1_cd_o => ben_clp_shd.g_old_rec.bool1_cd

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

Line 313: ,p_ler2_id_o => ben_clp_shd.g_old_rec.ler2_id

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

Line 314: ,p_bool2_cd_o => ben_clp_shd.g_old_rec.bool2_cd

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

Line 315: ,p_ler3_id_o => ben_clp_shd.g_old_rec.ler3_id

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

Line 316: ,p_bool3_cd_o => ben_clp_shd.g_old_rec.bool3_cd

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

Line 317: ,p_ler4_id_o => ben_clp_shd.g_old_rec.ler4_id

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

Line 318: ,p_bool4_cd_o => ben_clp_shd.g_old_rec.bool4_cd

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

Line 319: ,p_ler5_id_o => ben_clp_shd.g_old_rec.ler5_id

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

Line 320: ,p_bool5_cd_o => ben_clp_shd.g_old_rec.bool5_cd

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

Line 321: ,p_ler6_id_o => ben_clp_shd.g_old_rec.ler6_id

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

Line 322: ,p_bool6_cd_o => ben_clp_shd.g_old_rec.bool6_cd

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

Line 323: ,p_ler7_id_o => ben_clp_shd.g_old_rec.ler7_id

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

Line 324: ,p_bool7_cd_o => ben_clp_shd.g_old_rec.bool7_cd

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

Line 325: ,p_ler8_id_o => ben_clp_shd.g_old_rec.ler8_id

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

Line 326: ,p_bool8_cd_o => ben_clp_shd.g_old_rec.bool8_cd

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

Line 327: ,p_ler9_id_o => ben_clp_shd.g_old_rec.ler9_id

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

Line 328: ,p_bool9_cd_o => ben_clp_shd.g_old_rec.bool9_cd

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

Line 329: ,p_ler10_id_o => ben_clp_shd.g_old_rec.ler10_id

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

Line 330: ,p_eval_cd_o => ben_clp_shd.g_old_rec.eval_cd

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

Line 331: ,p_eval_rl_o => ben_clp_shd.g_old_rec.eval_rl

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

Line 332: ,p_tlrnc_dys_num_o => ben_clp_shd.g_old_rec.tlrnc_dys_num

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

Line 333: ,p_eval_ler_id_o => ben_clp_shd.g_old_rec.eval_ler_id

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

Line 334: ,p_eval_ler_det_cd_o => ben_clp_shd.g_old_rec.eval_ler_det_cd

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

Line 335: ,p_eval_ler_det_rl_o => ben_clp_shd.g_old_rec.eval_ler_det_rl

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

Line 336: ,p_clp_attribute_category_o => ben_clp_shd.g_old_rec.clp_attribute_category

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

Line 337: ,p_clp_attribute1_o => ben_clp_shd.g_old_rec.clp_attribute1

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

Line 338: ,p_clp_attribute2_o => ben_clp_shd.g_old_rec.clp_attribute2

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

Line 339: ,p_clp_attribute3_o => ben_clp_shd.g_old_rec.clp_attribute3

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

Line 340: ,p_clp_attribute4_o => ben_clp_shd.g_old_rec.clp_attribute4

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

Line 341: ,p_clp_attribute5_o => ben_clp_shd.g_old_rec.clp_attribute5

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

Line 342: ,p_clp_attribute6_o => ben_clp_shd.g_old_rec.clp_attribute6

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

Line 343: ,p_clp_attribute7_o => ben_clp_shd.g_old_rec.clp_attribute7

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

Line 344: ,p_clp_attribute8_o => ben_clp_shd.g_old_rec.clp_attribute8

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

Line 345: ,p_clp_attribute9_o => ben_clp_shd.g_old_rec.clp_attribute9

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

Line 346: ,p_clp_attribute10_o => ben_clp_shd.g_old_rec.clp_attribute10

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

Line 347: ,p_clp_attribute11_o => ben_clp_shd.g_old_rec.clp_attribute11

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

Line 348: ,p_clp_attribute12_o => ben_clp_shd.g_old_rec.clp_attribute12

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

Line 349: ,p_clp_attribute13_o => ben_clp_shd.g_old_rec.clp_attribute13

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

Line 350: ,p_clp_attribute14_o => ben_clp_shd.g_old_rec.clp_attribute14

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

Line 351: ,p_clp_attribute15_o => ben_clp_shd.g_old_rec.clp_attribute15

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

Line 352: ,p_clp_attribute16_o => ben_clp_shd.g_old_rec.clp_attribute16

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

Line 353: ,p_clp_attribute17_o => ben_clp_shd.g_old_rec.clp_attribute17

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

Line 354: ,p_clp_attribute18_o => ben_clp_shd.g_old_rec.clp_attribute18

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

Line 355: ,p_clp_attribute19_o => ben_clp_shd.g_old_rec.clp_attribute19

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

Line 356: ,p_clp_attribute20_o => ben_clp_shd.g_old_rec.clp_attribute20

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

Line 357: ,p_clp_attribute21_o => ben_clp_shd.g_old_rec.clp_attribute21

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

Line 358: ,p_clp_attribute22_o => ben_clp_shd.g_old_rec.clp_attribute22

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

Line 359: ,p_clp_attribute23_o => ben_clp_shd.g_old_rec.clp_attribute23

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

Line 360: ,p_clp_attribute24_o => ben_clp_shd.g_old_rec.clp_attribute24

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

Line 361: ,p_clp_attribute25_o => ben_clp_shd.g_old_rec.clp_attribute25

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

Line 362: ,p_clp_attribute26_o => ben_clp_shd.g_old_rec.clp_attribute26

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

Line 363: ,p_clp_attribute27_o => ben_clp_shd.g_old_rec.clp_attribute27

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);

Line 364: ,p_clp_attribute28_o => ben_clp_shd.g_old_rec.clp_attribute28

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: --

Line 365: ,p_clp_attribute29_o => ben_clp_shd.g_old_rec.clp_attribute29

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

Line 366: ,p_clp_attribute30_o => ben_clp_shd.g_old_rec.clp_attribute30

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: --

Line 367: ,p_object_version_number_o => ben_clp_shd.g_old_rec.object_version_number);

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

Line 390: p_rec in out nocopy ben_clp_shd.g_rec_type,

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: --

Line 408: ben_clp_shd.lck

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,

Line 466: l_rec ben_clp_shd.g_rec_type;

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);