54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: Procedure dt_update_dml
58: (p_rec in out nocopy ben_clp_shd.g_rec_type,
59: p_effective_date in date,
60: p_datetrack_mode in varchar2,
61: p_validation_start_date in date,
62: p_validation_end_date in date) is
77: (p_base_table_name => 'ben_clpse_lf_evt_f',
78: p_base_key_column => 'clpse_lf_evt_id',
79: p_base_key_value => p_rec.clpse_lf_evt_id);
80: --
81: ben_clp_shd.g_api_dml := true; -- Set the api dml status
82: --
83: -- Update the ben_clpse_lf_evt_f Row
84: --
85: update ben_clpse_lf_evt_f
147: where clpse_lf_evt_id = p_rec.clpse_lf_evt_id
148: and effective_start_date = p_validation_start_date
149: and effective_end_date = p_validation_end_date;
150: --
151: ben_clp_shd.g_api_dml := false; -- Unset the api dml status
152: --
153: -- Set the effective start and end dates
154: --
155: p_rec.effective_start_date := p_validation_start_date;
159: hr_utility.set_location(' Leaving:'||l_proc, 15);
160: Exception
161: When hr_api.check_integrity_violated Then
162: -- A check constraint has been violated
163: ben_clp_shd.g_api_dml := false; -- Unset the api dml status
164: ben_clp_shd.constraint_error
165: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
166: When hr_api.unique_integrity_violated Then
167: -- Unique integrity has been violated
160: Exception
161: When hr_api.check_integrity_violated Then
162: -- A check constraint has been violated
163: ben_clp_shd.g_api_dml := false; -- Unset the api dml status
164: ben_clp_shd.constraint_error
165: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
166: When hr_api.unique_integrity_violated Then
167: -- Unique integrity has been violated
168: ben_clp_shd.g_api_dml := false; -- Unset the api dml status
164: ben_clp_shd.constraint_error
165: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
166: When hr_api.unique_integrity_violated Then
167: -- Unique integrity has been violated
168: ben_clp_shd.g_api_dml := false; -- Unset the api dml status
169: ben_clp_shd.constraint_error
170: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
171: When Others Then
172: ben_clp_shd.g_api_dml := false; -- Unset the api dml status
165: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
166: When hr_api.unique_integrity_violated Then
167: -- Unique integrity has been violated
168: ben_clp_shd.g_api_dml := false; -- Unset the api dml status
169: ben_clp_shd.constraint_error
170: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
171: When Others Then
172: ben_clp_shd.g_api_dml := false; -- Unset the api dml status
173: Raise;
168: ben_clp_shd.g_api_dml := false; -- Unset the api dml status
169: ben_clp_shd.constraint_error
170: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
171: When Others Then
172: ben_clp_shd.g_api_dml := false; -- Unset the api dml status
173: Raise;
174: End dt_update_dml;
175: --
176: -- ----------------------------------------------------------------------------
204: --
205: -- {End Of Comments}
206: -- ----------------------------------------------------------------------------
207: Procedure update_dml
208: (p_rec in out nocopy ben_clp_shd.g_rec_type,
209: p_effective_date in date,
210: p_datetrack_mode in varchar2,
211: p_validation_start_date in date,
212: p_validation_end_date in date) is
268: --
269: -- {End Of Comments}
270: -- ----------------------------------------------------------------------------
271: Procedure dt_pre_update
272: (p_rec in out nocopy ben_clp_shd.g_rec_type,
273: p_effective_date in date,
274: p_datetrack_mode in varchar2,
275: p_validation_start_date in date,
276: p_validation_end_date in date) is
284: hr_utility.set_location(l_proc, 10);
285: --
286: -- Update the current effective end date
287: --
288: ben_clp_shd.upd_effective_end_date
289: (p_effective_date => p_effective_date,
290: p_base_key_value => p_rec.clpse_lf_evt_id,
291: p_new_effective_end_date => (p_validation_start_date - 1),
292: p_validation_start_date => p_validation_start_date,
353: --
354: -- {End Of Comments}
355: -- ----------------------------------------------------------------------------
356: Procedure pre_update
357: (p_rec in out nocopy ben_clp_shd.g_rec_type,
358: p_effective_date in date,
359: p_datetrack_mode in varchar2,
360: p_validation_start_date in date,
361: p_validation_end_date in date) is
409: --
410: -- {End Of Comments}
411: -- ----------------------------------------------------------------------------
412: Procedure post_update
413: (p_rec in ben_clp_shd.g_rec_type,
414: p_effective_date in date,
415: p_datetrack_mode in varchar2,
416: p_validation_start_date in date,
417: p_validation_end_date in date) is
491: ,p_effective_date => p_effective_date
492: ,p_datetrack_mode => p_datetrack_mode
493: ,p_validation_start_date => p_validation_start_date
494: ,p_validation_end_date => p_validation_end_date
495: ,p_effective_start_date_o => ben_clp_shd.g_old_rec.effective_start_date
496: ,p_effective_end_date_o => ben_clp_shd.g_old_rec.effective_end_date
497: ,p_business_group_id_o => ben_clp_shd.g_old_rec.business_group_id
498: ,p_seq_o => ben_clp_shd.g_old_rec.seq
499: ,p_ler1_id_o => ben_clp_shd.g_old_rec.ler1_id
492: ,p_datetrack_mode => p_datetrack_mode
493: ,p_validation_start_date => p_validation_start_date
494: ,p_validation_end_date => p_validation_end_date
495: ,p_effective_start_date_o => ben_clp_shd.g_old_rec.effective_start_date
496: ,p_effective_end_date_o => ben_clp_shd.g_old_rec.effective_end_date
497: ,p_business_group_id_o => ben_clp_shd.g_old_rec.business_group_id
498: ,p_seq_o => ben_clp_shd.g_old_rec.seq
499: ,p_ler1_id_o => ben_clp_shd.g_old_rec.ler1_id
500: ,p_bool1_cd_o => ben_clp_shd.g_old_rec.bool1_cd
493: ,p_validation_start_date => p_validation_start_date
494: ,p_validation_end_date => p_validation_end_date
495: ,p_effective_start_date_o => ben_clp_shd.g_old_rec.effective_start_date
496: ,p_effective_end_date_o => ben_clp_shd.g_old_rec.effective_end_date
497: ,p_business_group_id_o => ben_clp_shd.g_old_rec.business_group_id
498: ,p_seq_o => ben_clp_shd.g_old_rec.seq
499: ,p_ler1_id_o => ben_clp_shd.g_old_rec.ler1_id
500: ,p_bool1_cd_o => ben_clp_shd.g_old_rec.bool1_cd
501: ,p_ler2_id_o => ben_clp_shd.g_old_rec.ler2_id
494: ,p_validation_end_date => p_validation_end_date
495: ,p_effective_start_date_o => ben_clp_shd.g_old_rec.effective_start_date
496: ,p_effective_end_date_o => ben_clp_shd.g_old_rec.effective_end_date
497: ,p_business_group_id_o => ben_clp_shd.g_old_rec.business_group_id
498: ,p_seq_o => ben_clp_shd.g_old_rec.seq
499: ,p_ler1_id_o => ben_clp_shd.g_old_rec.ler1_id
500: ,p_bool1_cd_o => ben_clp_shd.g_old_rec.bool1_cd
501: ,p_ler2_id_o => ben_clp_shd.g_old_rec.ler2_id
502: ,p_bool2_cd_o => ben_clp_shd.g_old_rec.bool2_cd
495: ,p_effective_start_date_o => ben_clp_shd.g_old_rec.effective_start_date
496: ,p_effective_end_date_o => ben_clp_shd.g_old_rec.effective_end_date
497: ,p_business_group_id_o => ben_clp_shd.g_old_rec.business_group_id
498: ,p_seq_o => ben_clp_shd.g_old_rec.seq
499: ,p_ler1_id_o => ben_clp_shd.g_old_rec.ler1_id
500: ,p_bool1_cd_o => ben_clp_shd.g_old_rec.bool1_cd
501: ,p_ler2_id_o => ben_clp_shd.g_old_rec.ler2_id
502: ,p_bool2_cd_o => ben_clp_shd.g_old_rec.bool2_cd
503: ,p_ler3_id_o => ben_clp_shd.g_old_rec.ler3_id
496: ,p_effective_end_date_o => ben_clp_shd.g_old_rec.effective_end_date
497: ,p_business_group_id_o => ben_clp_shd.g_old_rec.business_group_id
498: ,p_seq_o => ben_clp_shd.g_old_rec.seq
499: ,p_ler1_id_o => ben_clp_shd.g_old_rec.ler1_id
500: ,p_bool1_cd_o => ben_clp_shd.g_old_rec.bool1_cd
501: ,p_ler2_id_o => ben_clp_shd.g_old_rec.ler2_id
502: ,p_bool2_cd_o => ben_clp_shd.g_old_rec.bool2_cd
503: ,p_ler3_id_o => ben_clp_shd.g_old_rec.ler3_id
504: ,p_bool3_cd_o => ben_clp_shd.g_old_rec.bool3_cd
497: ,p_business_group_id_o => ben_clp_shd.g_old_rec.business_group_id
498: ,p_seq_o => ben_clp_shd.g_old_rec.seq
499: ,p_ler1_id_o => ben_clp_shd.g_old_rec.ler1_id
500: ,p_bool1_cd_o => ben_clp_shd.g_old_rec.bool1_cd
501: ,p_ler2_id_o => ben_clp_shd.g_old_rec.ler2_id
502: ,p_bool2_cd_o => ben_clp_shd.g_old_rec.bool2_cd
503: ,p_ler3_id_o => ben_clp_shd.g_old_rec.ler3_id
504: ,p_bool3_cd_o => ben_clp_shd.g_old_rec.bool3_cd
505: ,p_ler4_id_o => ben_clp_shd.g_old_rec.ler4_id
498: ,p_seq_o => ben_clp_shd.g_old_rec.seq
499: ,p_ler1_id_o => ben_clp_shd.g_old_rec.ler1_id
500: ,p_bool1_cd_o => ben_clp_shd.g_old_rec.bool1_cd
501: ,p_ler2_id_o => ben_clp_shd.g_old_rec.ler2_id
502: ,p_bool2_cd_o => ben_clp_shd.g_old_rec.bool2_cd
503: ,p_ler3_id_o => ben_clp_shd.g_old_rec.ler3_id
504: ,p_bool3_cd_o => ben_clp_shd.g_old_rec.bool3_cd
505: ,p_ler4_id_o => ben_clp_shd.g_old_rec.ler4_id
506: ,p_bool4_cd_o => ben_clp_shd.g_old_rec.bool4_cd
499: ,p_ler1_id_o => ben_clp_shd.g_old_rec.ler1_id
500: ,p_bool1_cd_o => ben_clp_shd.g_old_rec.bool1_cd
501: ,p_ler2_id_o => ben_clp_shd.g_old_rec.ler2_id
502: ,p_bool2_cd_o => ben_clp_shd.g_old_rec.bool2_cd
503: ,p_ler3_id_o => ben_clp_shd.g_old_rec.ler3_id
504: ,p_bool3_cd_o => ben_clp_shd.g_old_rec.bool3_cd
505: ,p_ler4_id_o => ben_clp_shd.g_old_rec.ler4_id
506: ,p_bool4_cd_o => ben_clp_shd.g_old_rec.bool4_cd
507: ,p_ler5_id_o => ben_clp_shd.g_old_rec.ler5_id
500: ,p_bool1_cd_o => ben_clp_shd.g_old_rec.bool1_cd
501: ,p_ler2_id_o => ben_clp_shd.g_old_rec.ler2_id
502: ,p_bool2_cd_o => ben_clp_shd.g_old_rec.bool2_cd
503: ,p_ler3_id_o => ben_clp_shd.g_old_rec.ler3_id
504: ,p_bool3_cd_o => ben_clp_shd.g_old_rec.bool3_cd
505: ,p_ler4_id_o => ben_clp_shd.g_old_rec.ler4_id
506: ,p_bool4_cd_o => ben_clp_shd.g_old_rec.bool4_cd
507: ,p_ler5_id_o => ben_clp_shd.g_old_rec.ler5_id
508: ,p_bool5_cd_o => ben_clp_shd.g_old_rec.bool5_cd
501: ,p_ler2_id_o => ben_clp_shd.g_old_rec.ler2_id
502: ,p_bool2_cd_o => ben_clp_shd.g_old_rec.bool2_cd
503: ,p_ler3_id_o => ben_clp_shd.g_old_rec.ler3_id
504: ,p_bool3_cd_o => ben_clp_shd.g_old_rec.bool3_cd
505: ,p_ler4_id_o => ben_clp_shd.g_old_rec.ler4_id
506: ,p_bool4_cd_o => ben_clp_shd.g_old_rec.bool4_cd
507: ,p_ler5_id_o => ben_clp_shd.g_old_rec.ler5_id
508: ,p_bool5_cd_o => ben_clp_shd.g_old_rec.bool5_cd
509: ,p_ler6_id_o => ben_clp_shd.g_old_rec.ler6_id
502: ,p_bool2_cd_o => ben_clp_shd.g_old_rec.bool2_cd
503: ,p_ler3_id_o => ben_clp_shd.g_old_rec.ler3_id
504: ,p_bool3_cd_o => ben_clp_shd.g_old_rec.bool3_cd
505: ,p_ler4_id_o => ben_clp_shd.g_old_rec.ler4_id
506: ,p_bool4_cd_o => ben_clp_shd.g_old_rec.bool4_cd
507: ,p_ler5_id_o => ben_clp_shd.g_old_rec.ler5_id
508: ,p_bool5_cd_o => ben_clp_shd.g_old_rec.bool5_cd
509: ,p_ler6_id_o => ben_clp_shd.g_old_rec.ler6_id
510: ,p_bool6_cd_o => ben_clp_shd.g_old_rec.bool6_cd
503: ,p_ler3_id_o => ben_clp_shd.g_old_rec.ler3_id
504: ,p_bool3_cd_o => ben_clp_shd.g_old_rec.bool3_cd
505: ,p_ler4_id_o => ben_clp_shd.g_old_rec.ler4_id
506: ,p_bool4_cd_o => ben_clp_shd.g_old_rec.bool4_cd
507: ,p_ler5_id_o => ben_clp_shd.g_old_rec.ler5_id
508: ,p_bool5_cd_o => ben_clp_shd.g_old_rec.bool5_cd
509: ,p_ler6_id_o => ben_clp_shd.g_old_rec.ler6_id
510: ,p_bool6_cd_o => ben_clp_shd.g_old_rec.bool6_cd
511: ,p_ler7_id_o => ben_clp_shd.g_old_rec.ler7_id
504: ,p_bool3_cd_o => ben_clp_shd.g_old_rec.bool3_cd
505: ,p_ler4_id_o => ben_clp_shd.g_old_rec.ler4_id
506: ,p_bool4_cd_o => ben_clp_shd.g_old_rec.bool4_cd
507: ,p_ler5_id_o => ben_clp_shd.g_old_rec.ler5_id
508: ,p_bool5_cd_o => ben_clp_shd.g_old_rec.bool5_cd
509: ,p_ler6_id_o => ben_clp_shd.g_old_rec.ler6_id
510: ,p_bool6_cd_o => ben_clp_shd.g_old_rec.bool6_cd
511: ,p_ler7_id_o => ben_clp_shd.g_old_rec.ler7_id
512: ,p_bool7_cd_o => ben_clp_shd.g_old_rec.bool7_cd
505: ,p_ler4_id_o => ben_clp_shd.g_old_rec.ler4_id
506: ,p_bool4_cd_o => ben_clp_shd.g_old_rec.bool4_cd
507: ,p_ler5_id_o => ben_clp_shd.g_old_rec.ler5_id
508: ,p_bool5_cd_o => ben_clp_shd.g_old_rec.bool5_cd
509: ,p_ler6_id_o => ben_clp_shd.g_old_rec.ler6_id
510: ,p_bool6_cd_o => ben_clp_shd.g_old_rec.bool6_cd
511: ,p_ler7_id_o => ben_clp_shd.g_old_rec.ler7_id
512: ,p_bool7_cd_o => ben_clp_shd.g_old_rec.bool7_cd
513: ,p_ler8_id_o => ben_clp_shd.g_old_rec.ler8_id
506: ,p_bool4_cd_o => ben_clp_shd.g_old_rec.bool4_cd
507: ,p_ler5_id_o => ben_clp_shd.g_old_rec.ler5_id
508: ,p_bool5_cd_o => ben_clp_shd.g_old_rec.bool5_cd
509: ,p_ler6_id_o => ben_clp_shd.g_old_rec.ler6_id
510: ,p_bool6_cd_o => ben_clp_shd.g_old_rec.bool6_cd
511: ,p_ler7_id_o => ben_clp_shd.g_old_rec.ler7_id
512: ,p_bool7_cd_o => ben_clp_shd.g_old_rec.bool7_cd
513: ,p_ler8_id_o => ben_clp_shd.g_old_rec.ler8_id
514: ,p_bool8_cd_o => ben_clp_shd.g_old_rec.bool8_cd
507: ,p_ler5_id_o => ben_clp_shd.g_old_rec.ler5_id
508: ,p_bool5_cd_o => ben_clp_shd.g_old_rec.bool5_cd
509: ,p_ler6_id_o => ben_clp_shd.g_old_rec.ler6_id
510: ,p_bool6_cd_o => ben_clp_shd.g_old_rec.bool6_cd
511: ,p_ler7_id_o => ben_clp_shd.g_old_rec.ler7_id
512: ,p_bool7_cd_o => ben_clp_shd.g_old_rec.bool7_cd
513: ,p_ler8_id_o => ben_clp_shd.g_old_rec.ler8_id
514: ,p_bool8_cd_o => ben_clp_shd.g_old_rec.bool8_cd
515: ,p_ler9_id_o => ben_clp_shd.g_old_rec.ler9_id
508: ,p_bool5_cd_o => ben_clp_shd.g_old_rec.bool5_cd
509: ,p_ler6_id_o => ben_clp_shd.g_old_rec.ler6_id
510: ,p_bool6_cd_o => ben_clp_shd.g_old_rec.bool6_cd
511: ,p_ler7_id_o => ben_clp_shd.g_old_rec.ler7_id
512: ,p_bool7_cd_o => ben_clp_shd.g_old_rec.bool7_cd
513: ,p_ler8_id_o => ben_clp_shd.g_old_rec.ler8_id
514: ,p_bool8_cd_o => ben_clp_shd.g_old_rec.bool8_cd
515: ,p_ler9_id_o => ben_clp_shd.g_old_rec.ler9_id
516: ,p_bool9_cd_o => ben_clp_shd.g_old_rec.bool9_cd
509: ,p_ler6_id_o => ben_clp_shd.g_old_rec.ler6_id
510: ,p_bool6_cd_o => ben_clp_shd.g_old_rec.bool6_cd
511: ,p_ler7_id_o => ben_clp_shd.g_old_rec.ler7_id
512: ,p_bool7_cd_o => ben_clp_shd.g_old_rec.bool7_cd
513: ,p_ler8_id_o => ben_clp_shd.g_old_rec.ler8_id
514: ,p_bool8_cd_o => ben_clp_shd.g_old_rec.bool8_cd
515: ,p_ler9_id_o => ben_clp_shd.g_old_rec.ler9_id
516: ,p_bool9_cd_o => ben_clp_shd.g_old_rec.bool9_cd
517: ,p_ler10_id_o => ben_clp_shd.g_old_rec.ler10_id
510: ,p_bool6_cd_o => ben_clp_shd.g_old_rec.bool6_cd
511: ,p_ler7_id_o => ben_clp_shd.g_old_rec.ler7_id
512: ,p_bool7_cd_o => ben_clp_shd.g_old_rec.bool7_cd
513: ,p_ler8_id_o => ben_clp_shd.g_old_rec.ler8_id
514: ,p_bool8_cd_o => ben_clp_shd.g_old_rec.bool8_cd
515: ,p_ler9_id_o => ben_clp_shd.g_old_rec.ler9_id
516: ,p_bool9_cd_o => ben_clp_shd.g_old_rec.bool9_cd
517: ,p_ler10_id_o => ben_clp_shd.g_old_rec.ler10_id
518: ,p_eval_cd_o => ben_clp_shd.g_old_rec.eval_cd
511: ,p_ler7_id_o => ben_clp_shd.g_old_rec.ler7_id
512: ,p_bool7_cd_o => ben_clp_shd.g_old_rec.bool7_cd
513: ,p_ler8_id_o => ben_clp_shd.g_old_rec.ler8_id
514: ,p_bool8_cd_o => ben_clp_shd.g_old_rec.bool8_cd
515: ,p_ler9_id_o => ben_clp_shd.g_old_rec.ler9_id
516: ,p_bool9_cd_o => ben_clp_shd.g_old_rec.bool9_cd
517: ,p_ler10_id_o => ben_clp_shd.g_old_rec.ler10_id
518: ,p_eval_cd_o => ben_clp_shd.g_old_rec.eval_cd
519: ,p_eval_rl_o => ben_clp_shd.g_old_rec.eval_rl
512: ,p_bool7_cd_o => ben_clp_shd.g_old_rec.bool7_cd
513: ,p_ler8_id_o => ben_clp_shd.g_old_rec.ler8_id
514: ,p_bool8_cd_o => ben_clp_shd.g_old_rec.bool8_cd
515: ,p_ler9_id_o => ben_clp_shd.g_old_rec.ler9_id
516: ,p_bool9_cd_o => ben_clp_shd.g_old_rec.bool9_cd
517: ,p_ler10_id_o => ben_clp_shd.g_old_rec.ler10_id
518: ,p_eval_cd_o => ben_clp_shd.g_old_rec.eval_cd
519: ,p_eval_rl_o => ben_clp_shd.g_old_rec.eval_rl
520: ,p_tlrnc_dys_num_o => ben_clp_shd.g_old_rec.tlrnc_dys_num
513: ,p_ler8_id_o => ben_clp_shd.g_old_rec.ler8_id
514: ,p_bool8_cd_o => ben_clp_shd.g_old_rec.bool8_cd
515: ,p_ler9_id_o => ben_clp_shd.g_old_rec.ler9_id
516: ,p_bool9_cd_o => ben_clp_shd.g_old_rec.bool9_cd
517: ,p_ler10_id_o => ben_clp_shd.g_old_rec.ler10_id
518: ,p_eval_cd_o => ben_clp_shd.g_old_rec.eval_cd
519: ,p_eval_rl_o => ben_clp_shd.g_old_rec.eval_rl
520: ,p_tlrnc_dys_num_o => ben_clp_shd.g_old_rec.tlrnc_dys_num
521: ,p_eval_ler_id_o => ben_clp_shd.g_old_rec.eval_ler_id
514: ,p_bool8_cd_o => ben_clp_shd.g_old_rec.bool8_cd
515: ,p_ler9_id_o => ben_clp_shd.g_old_rec.ler9_id
516: ,p_bool9_cd_o => ben_clp_shd.g_old_rec.bool9_cd
517: ,p_ler10_id_o => ben_clp_shd.g_old_rec.ler10_id
518: ,p_eval_cd_o => ben_clp_shd.g_old_rec.eval_cd
519: ,p_eval_rl_o => ben_clp_shd.g_old_rec.eval_rl
520: ,p_tlrnc_dys_num_o => ben_clp_shd.g_old_rec.tlrnc_dys_num
521: ,p_eval_ler_id_o => ben_clp_shd.g_old_rec.eval_ler_id
522: ,p_eval_ler_det_cd_o => ben_clp_shd.g_old_rec.eval_ler_det_cd
515: ,p_ler9_id_o => ben_clp_shd.g_old_rec.ler9_id
516: ,p_bool9_cd_o => ben_clp_shd.g_old_rec.bool9_cd
517: ,p_ler10_id_o => ben_clp_shd.g_old_rec.ler10_id
518: ,p_eval_cd_o => ben_clp_shd.g_old_rec.eval_cd
519: ,p_eval_rl_o => ben_clp_shd.g_old_rec.eval_rl
520: ,p_tlrnc_dys_num_o => ben_clp_shd.g_old_rec.tlrnc_dys_num
521: ,p_eval_ler_id_o => ben_clp_shd.g_old_rec.eval_ler_id
522: ,p_eval_ler_det_cd_o => ben_clp_shd.g_old_rec.eval_ler_det_cd
523: ,p_eval_ler_det_rl_o => ben_clp_shd.g_old_rec.eval_ler_det_rl
516: ,p_bool9_cd_o => ben_clp_shd.g_old_rec.bool9_cd
517: ,p_ler10_id_o => ben_clp_shd.g_old_rec.ler10_id
518: ,p_eval_cd_o => ben_clp_shd.g_old_rec.eval_cd
519: ,p_eval_rl_o => ben_clp_shd.g_old_rec.eval_rl
520: ,p_tlrnc_dys_num_o => ben_clp_shd.g_old_rec.tlrnc_dys_num
521: ,p_eval_ler_id_o => ben_clp_shd.g_old_rec.eval_ler_id
522: ,p_eval_ler_det_cd_o => ben_clp_shd.g_old_rec.eval_ler_det_cd
523: ,p_eval_ler_det_rl_o => ben_clp_shd.g_old_rec.eval_ler_det_rl
524: ,p_clp_attribute_category_o => ben_clp_shd.g_old_rec.clp_attribute_category
517: ,p_ler10_id_o => ben_clp_shd.g_old_rec.ler10_id
518: ,p_eval_cd_o => ben_clp_shd.g_old_rec.eval_cd
519: ,p_eval_rl_o => ben_clp_shd.g_old_rec.eval_rl
520: ,p_tlrnc_dys_num_o => ben_clp_shd.g_old_rec.tlrnc_dys_num
521: ,p_eval_ler_id_o => ben_clp_shd.g_old_rec.eval_ler_id
522: ,p_eval_ler_det_cd_o => ben_clp_shd.g_old_rec.eval_ler_det_cd
523: ,p_eval_ler_det_rl_o => ben_clp_shd.g_old_rec.eval_ler_det_rl
524: ,p_clp_attribute_category_o => ben_clp_shd.g_old_rec.clp_attribute_category
525: ,p_clp_attribute1_o => ben_clp_shd.g_old_rec.clp_attribute1
518: ,p_eval_cd_o => ben_clp_shd.g_old_rec.eval_cd
519: ,p_eval_rl_o => ben_clp_shd.g_old_rec.eval_rl
520: ,p_tlrnc_dys_num_o => ben_clp_shd.g_old_rec.tlrnc_dys_num
521: ,p_eval_ler_id_o => ben_clp_shd.g_old_rec.eval_ler_id
522: ,p_eval_ler_det_cd_o => ben_clp_shd.g_old_rec.eval_ler_det_cd
523: ,p_eval_ler_det_rl_o => ben_clp_shd.g_old_rec.eval_ler_det_rl
524: ,p_clp_attribute_category_o => ben_clp_shd.g_old_rec.clp_attribute_category
525: ,p_clp_attribute1_o => ben_clp_shd.g_old_rec.clp_attribute1
526: ,p_clp_attribute2_o => ben_clp_shd.g_old_rec.clp_attribute2
519: ,p_eval_rl_o => ben_clp_shd.g_old_rec.eval_rl
520: ,p_tlrnc_dys_num_o => ben_clp_shd.g_old_rec.tlrnc_dys_num
521: ,p_eval_ler_id_o => ben_clp_shd.g_old_rec.eval_ler_id
522: ,p_eval_ler_det_cd_o => ben_clp_shd.g_old_rec.eval_ler_det_cd
523: ,p_eval_ler_det_rl_o => ben_clp_shd.g_old_rec.eval_ler_det_rl
524: ,p_clp_attribute_category_o => ben_clp_shd.g_old_rec.clp_attribute_category
525: ,p_clp_attribute1_o => ben_clp_shd.g_old_rec.clp_attribute1
526: ,p_clp_attribute2_o => ben_clp_shd.g_old_rec.clp_attribute2
527: ,p_clp_attribute3_o => ben_clp_shd.g_old_rec.clp_attribute3
520: ,p_tlrnc_dys_num_o => ben_clp_shd.g_old_rec.tlrnc_dys_num
521: ,p_eval_ler_id_o => ben_clp_shd.g_old_rec.eval_ler_id
522: ,p_eval_ler_det_cd_o => ben_clp_shd.g_old_rec.eval_ler_det_cd
523: ,p_eval_ler_det_rl_o => ben_clp_shd.g_old_rec.eval_ler_det_rl
524: ,p_clp_attribute_category_o => ben_clp_shd.g_old_rec.clp_attribute_category
525: ,p_clp_attribute1_o => ben_clp_shd.g_old_rec.clp_attribute1
526: ,p_clp_attribute2_o => ben_clp_shd.g_old_rec.clp_attribute2
527: ,p_clp_attribute3_o => ben_clp_shd.g_old_rec.clp_attribute3
528: ,p_clp_attribute4_o => ben_clp_shd.g_old_rec.clp_attribute4
521: ,p_eval_ler_id_o => ben_clp_shd.g_old_rec.eval_ler_id
522: ,p_eval_ler_det_cd_o => ben_clp_shd.g_old_rec.eval_ler_det_cd
523: ,p_eval_ler_det_rl_o => ben_clp_shd.g_old_rec.eval_ler_det_rl
524: ,p_clp_attribute_category_o => ben_clp_shd.g_old_rec.clp_attribute_category
525: ,p_clp_attribute1_o => ben_clp_shd.g_old_rec.clp_attribute1
526: ,p_clp_attribute2_o => ben_clp_shd.g_old_rec.clp_attribute2
527: ,p_clp_attribute3_o => ben_clp_shd.g_old_rec.clp_attribute3
528: ,p_clp_attribute4_o => ben_clp_shd.g_old_rec.clp_attribute4
529: ,p_clp_attribute5_o => ben_clp_shd.g_old_rec.clp_attribute5
522: ,p_eval_ler_det_cd_o => ben_clp_shd.g_old_rec.eval_ler_det_cd
523: ,p_eval_ler_det_rl_o => ben_clp_shd.g_old_rec.eval_ler_det_rl
524: ,p_clp_attribute_category_o => ben_clp_shd.g_old_rec.clp_attribute_category
525: ,p_clp_attribute1_o => ben_clp_shd.g_old_rec.clp_attribute1
526: ,p_clp_attribute2_o => ben_clp_shd.g_old_rec.clp_attribute2
527: ,p_clp_attribute3_o => ben_clp_shd.g_old_rec.clp_attribute3
528: ,p_clp_attribute4_o => ben_clp_shd.g_old_rec.clp_attribute4
529: ,p_clp_attribute5_o => ben_clp_shd.g_old_rec.clp_attribute5
530: ,p_clp_attribute6_o => ben_clp_shd.g_old_rec.clp_attribute6
523: ,p_eval_ler_det_rl_o => ben_clp_shd.g_old_rec.eval_ler_det_rl
524: ,p_clp_attribute_category_o => ben_clp_shd.g_old_rec.clp_attribute_category
525: ,p_clp_attribute1_o => ben_clp_shd.g_old_rec.clp_attribute1
526: ,p_clp_attribute2_o => ben_clp_shd.g_old_rec.clp_attribute2
527: ,p_clp_attribute3_o => ben_clp_shd.g_old_rec.clp_attribute3
528: ,p_clp_attribute4_o => ben_clp_shd.g_old_rec.clp_attribute4
529: ,p_clp_attribute5_o => ben_clp_shd.g_old_rec.clp_attribute5
530: ,p_clp_attribute6_o => ben_clp_shd.g_old_rec.clp_attribute6
531: ,p_clp_attribute7_o => ben_clp_shd.g_old_rec.clp_attribute7
524: ,p_clp_attribute_category_o => ben_clp_shd.g_old_rec.clp_attribute_category
525: ,p_clp_attribute1_o => ben_clp_shd.g_old_rec.clp_attribute1
526: ,p_clp_attribute2_o => ben_clp_shd.g_old_rec.clp_attribute2
527: ,p_clp_attribute3_o => ben_clp_shd.g_old_rec.clp_attribute3
528: ,p_clp_attribute4_o => ben_clp_shd.g_old_rec.clp_attribute4
529: ,p_clp_attribute5_o => ben_clp_shd.g_old_rec.clp_attribute5
530: ,p_clp_attribute6_o => ben_clp_shd.g_old_rec.clp_attribute6
531: ,p_clp_attribute7_o => ben_clp_shd.g_old_rec.clp_attribute7
532: ,p_clp_attribute8_o => ben_clp_shd.g_old_rec.clp_attribute8
525: ,p_clp_attribute1_o => ben_clp_shd.g_old_rec.clp_attribute1
526: ,p_clp_attribute2_o => ben_clp_shd.g_old_rec.clp_attribute2
527: ,p_clp_attribute3_o => ben_clp_shd.g_old_rec.clp_attribute3
528: ,p_clp_attribute4_o => ben_clp_shd.g_old_rec.clp_attribute4
529: ,p_clp_attribute5_o => ben_clp_shd.g_old_rec.clp_attribute5
530: ,p_clp_attribute6_o => ben_clp_shd.g_old_rec.clp_attribute6
531: ,p_clp_attribute7_o => ben_clp_shd.g_old_rec.clp_attribute7
532: ,p_clp_attribute8_o => ben_clp_shd.g_old_rec.clp_attribute8
533: ,p_clp_attribute9_o => ben_clp_shd.g_old_rec.clp_attribute9
526: ,p_clp_attribute2_o => ben_clp_shd.g_old_rec.clp_attribute2
527: ,p_clp_attribute3_o => ben_clp_shd.g_old_rec.clp_attribute3
528: ,p_clp_attribute4_o => ben_clp_shd.g_old_rec.clp_attribute4
529: ,p_clp_attribute5_o => ben_clp_shd.g_old_rec.clp_attribute5
530: ,p_clp_attribute6_o => ben_clp_shd.g_old_rec.clp_attribute6
531: ,p_clp_attribute7_o => ben_clp_shd.g_old_rec.clp_attribute7
532: ,p_clp_attribute8_o => ben_clp_shd.g_old_rec.clp_attribute8
533: ,p_clp_attribute9_o => ben_clp_shd.g_old_rec.clp_attribute9
534: ,p_clp_attribute10_o => ben_clp_shd.g_old_rec.clp_attribute10
527: ,p_clp_attribute3_o => ben_clp_shd.g_old_rec.clp_attribute3
528: ,p_clp_attribute4_o => ben_clp_shd.g_old_rec.clp_attribute4
529: ,p_clp_attribute5_o => ben_clp_shd.g_old_rec.clp_attribute5
530: ,p_clp_attribute6_o => ben_clp_shd.g_old_rec.clp_attribute6
531: ,p_clp_attribute7_o => ben_clp_shd.g_old_rec.clp_attribute7
532: ,p_clp_attribute8_o => ben_clp_shd.g_old_rec.clp_attribute8
533: ,p_clp_attribute9_o => ben_clp_shd.g_old_rec.clp_attribute9
534: ,p_clp_attribute10_o => ben_clp_shd.g_old_rec.clp_attribute10
535: ,p_clp_attribute11_o => ben_clp_shd.g_old_rec.clp_attribute11
528: ,p_clp_attribute4_o => ben_clp_shd.g_old_rec.clp_attribute4
529: ,p_clp_attribute5_o => ben_clp_shd.g_old_rec.clp_attribute5
530: ,p_clp_attribute6_o => ben_clp_shd.g_old_rec.clp_attribute6
531: ,p_clp_attribute7_o => ben_clp_shd.g_old_rec.clp_attribute7
532: ,p_clp_attribute8_o => ben_clp_shd.g_old_rec.clp_attribute8
533: ,p_clp_attribute9_o => ben_clp_shd.g_old_rec.clp_attribute9
534: ,p_clp_attribute10_o => ben_clp_shd.g_old_rec.clp_attribute10
535: ,p_clp_attribute11_o => ben_clp_shd.g_old_rec.clp_attribute11
536: ,p_clp_attribute12_o => ben_clp_shd.g_old_rec.clp_attribute12
529: ,p_clp_attribute5_o => ben_clp_shd.g_old_rec.clp_attribute5
530: ,p_clp_attribute6_o => ben_clp_shd.g_old_rec.clp_attribute6
531: ,p_clp_attribute7_o => ben_clp_shd.g_old_rec.clp_attribute7
532: ,p_clp_attribute8_o => ben_clp_shd.g_old_rec.clp_attribute8
533: ,p_clp_attribute9_o => ben_clp_shd.g_old_rec.clp_attribute9
534: ,p_clp_attribute10_o => ben_clp_shd.g_old_rec.clp_attribute10
535: ,p_clp_attribute11_o => ben_clp_shd.g_old_rec.clp_attribute11
536: ,p_clp_attribute12_o => ben_clp_shd.g_old_rec.clp_attribute12
537: ,p_clp_attribute13_o => ben_clp_shd.g_old_rec.clp_attribute13
530: ,p_clp_attribute6_o => ben_clp_shd.g_old_rec.clp_attribute6
531: ,p_clp_attribute7_o => ben_clp_shd.g_old_rec.clp_attribute7
532: ,p_clp_attribute8_o => ben_clp_shd.g_old_rec.clp_attribute8
533: ,p_clp_attribute9_o => ben_clp_shd.g_old_rec.clp_attribute9
534: ,p_clp_attribute10_o => ben_clp_shd.g_old_rec.clp_attribute10
535: ,p_clp_attribute11_o => ben_clp_shd.g_old_rec.clp_attribute11
536: ,p_clp_attribute12_o => ben_clp_shd.g_old_rec.clp_attribute12
537: ,p_clp_attribute13_o => ben_clp_shd.g_old_rec.clp_attribute13
538: ,p_clp_attribute14_o => ben_clp_shd.g_old_rec.clp_attribute14
531: ,p_clp_attribute7_o => ben_clp_shd.g_old_rec.clp_attribute7
532: ,p_clp_attribute8_o => ben_clp_shd.g_old_rec.clp_attribute8
533: ,p_clp_attribute9_o => ben_clp_shd.g_old_rec.clp_attribute9
534: ,p_clp_attribute10_o => ben_clp_shd.g_old_rec.clp_attribute10
535: ,p_clp_attribute11_o => ben_clp_shd.g_old_rec.clp_attribute11
536: ,p_clp_attribute12_o => ben_clp_shd.g_old_rec.clp_attribute12
537: ,p_clp_attribute13_o => ben_clp_shd.g_old_rec.clp_attribute13
538: ,p_clp_attribute14_o => ben_clp_shd.g_old_rec.clp_attribute14
539: ,p_clp_attribute15_o => ben_clp_shd.g_old_rec.clp_attribute15
532: ,p_clp_attribute8_o => ben_clp_shd.g_old_rec.clp_attribute8
533: ,p_clp_attribute9_o => ben_clp_shd.g_old_rec.clp_attribute9
534: ,p_clp_attribute10_o => ben_clp_shd.g_old_rec.clp_attribute10
535: ,p_clp_attribute11_o => ben_clp_shd.g_old_rec.clp_attribute11
536: ,p_clp_attribute12_o => ben_clp_shd.g_old_rec.clp_attribute12
537: ,p_clp_attribute13_o => ben_clp_shd.g_old_rec.clp_attribute13
538: ,p_clp_attribute14_o => ben_clp_shd.g_old_rec.clp_attribute14
539: ,p_clp_attribute15_o => ben_clp_shd.g_old_rec.clp_attribute15
540: ,p_clp_attribute16_o => ben_clp_shd.g_old_rec.clp_attribute16
533: ,p_clp_attribute9_o => ben_clp_shd.g_old_rec.clp_attribute9
534: ,p_clp_attribute10_o => ben_clp_shd.g_old_rec.clp_attribute10
535: ,p_clp_attribute11_o => ben_clp_shd.g_old_rec.clp_attribute11
536: ,p_clp_attribute12_o => ben_clp_shd.g_old_rec.clp_attribute12
537: ,p_clp_attribute13_o => ben_clp_shd.g_old_rec.clp_attribute13
538: ,p_clp_attribute14_o => ben_clp_shd.g_old_rec.clp_attribute14
539: ,p_clp_attribute15_o => ben_clp_shd.g_old_rec.clp_attribute15
540: ,p_clp_attribute16_o => ben_clp_shd.g_old_rec.clp_attribute16
541: ,p_clp_attribute17_o => ben_clp_shd.g_old_rec.clp_attribute17
534: ,p_clp_attribute10_o => ben_clp_shd.g_old_rec.clp_attribute10
535: ,p_clp_attribute11_o => ben_clp_shd.g_old_rec.clp_attribute11
536: ,p_clp_attribute12_o => ben_clp_shd.g_old_rec.clp_attribute12
537: ,p_clp_attribute13_o => ben_clp_shd.g_old_rec.clp_attribute13
538: ,p_clp_attribute14_o => ben_clp_shd.g_old_rec.clp_attribute14
539: ,p_clp_attribute15_o => ben_clp_shd.g_old_rec.clp_attribute15
540: ,p_clp_attribute16_o => ben_clp_shd.g_old_rec.clp_attribute16
541: ,p_clp_attribute17_o => ben_clp_shd.g_old_rec.clp_attribute17
542: ,p_clp_attribute18_o => ben_clp_shd.g_old_rec.clp_attribute18
535: ,p_clp_attribute11_o => ben_clp_shd.g_old_rec.clp_attribute11
536: ,p_clp_attribute12_o => ben_clp_shd.g_old_rec.clp_attribute12
537: ,p_clp_attribute13_o => ben_clp_shd.g_old_rec.clp_attribute13
538: ,p_clp_attribute14_o => ben_clp_shd.g_old_rec.clp_attribute14
539: ,p_clp_attribute15_o => ben_clp_shd.g_old_rec.clp_attribute15
540: ,p_clp_attribute16_o => ben_clp_shd.g_old_rec.clp_attribute16
541: ,p_clp_attribute17_o => ben_clp_shd.g_old_rec.clp_attribute17
542: ,p_clp_attribute18_o => ben_clp_shd.g_old_rec.clp_attribute18
543: ,p_clp_attribute19_o => ben_clp_shd.g_old_rec.clp_attribute19
536: ,p_clp_attribute12_o => ben_clp_shd.g_old_rec.clp_attribute12
537: ,p_clp_attribute13_o => ben_clp_shd.g_old_rec.clp_attribute13
538: ,p_clp_attribute14_o => ben_clp_shd.g_old_rec.clp_attribute14
539: ,p_clp_attribute15_o => ben_clp_shd.g_old_rec.clp_attribute15
540: ,p_clp_attribute16_o => ben_clp_shd.g_old_rec.clp_attribute16
541: ,p_clp_attribute17_o => ben_clp_shd.g_old_rec.clp_attribute17
542: ,p_clp_attribute18_o => ben_clp_shd.g_old_rec.clp_attribute18
543: ,p_clp_attribute19_o => ben_clp_shd.g_old_rec.clp_attribute19
544: ,p_clp_attribute20_o => ben_clp_shd.g_old_rec.clp_attribute20
537: ,p_clp_attribute13_o => ben_clp_shd.g_old_rec.clp_attribute13
538: ,p_clp_attribute14_o => ben_clp_shd.g_old_rec.clp_attribute14
539: ,p_clp_attribute15_o => ben_clp_shd.g_old_rec.clp_attribute15
540: ,p_clp_attribute16_o => ben_clp_shd.g_old_rec.clp_attribute16
541: ,p_clp_attribute17_o => ben_clp_shd.g_old_rec.clp_attribute17
542: ,p_clp_attribute18_o => ben_clp_shd.g_old_rec.clp_attribute18
543: ,p_clp_attribute19_o => ben_clp_shd.g_old_rec.clp_attribute19
544: ,p_clp_attribute20_o => ben_clp_shd.g_old_rec.clp_attribute20
545: ,p_clp_attribute21_o => ben_clp_shd.g_old_rec.clp_attribute21
538: ,p_clp_attribute14_o => ben_clp_shd.g_old_rec.clp_attribute14
539: ,p_clp_attribute15_o => ben_clp_shd.g_old_rec.clp_attribute15
540: ,p_clp_attribute16_o => ben_clp_shd.g_old_rec.clp_attribute16
541: ,p_clp_attribute17_o => ben_clp_shd.g_old_rec.clp_attribute17
542: ,p_clp_attribute18_o => ben_clp_shd.g_old_rec.clp_attribute18
543: ,p_clp_attribute19_o => ben_clp_shd.g_old_rec.clp_attribute19
544: ,p_clp_attribute20_o => ben_clp_shd.g_old_rec.clp_attribute20
545: ,p_clp_attribute21_o => ben_clp_shd.g_old_rec.clp_attribute21
546: ,p_clp_attribute22_o => ben_clp_shd.g_old_rec.clp_attribute22
539: ,p_clp_attribute15_o => ben_clp_shd.g_old_rec.clp_attribute15
540: ,p_clp_attribute16_o => ben_clp_shd.g_old_rec.clp_attribute16
541: ,p_clp_attribute17_o => ben_clp_shd.g_old_rec.clp_attribute17
542: ,p_clp_attribute18_o => ben_clp_shd.g_old_rec.clp_attribute18
543: ,p_clp_attribute19_o => ben_clp_shd.g_old_rec.clp_attribute19
544: ,p_clp_attribute20_o => ben_clp_shd.g_old_rec.clp_attribute20
545: ,p_clp_attribute21_o => ben_clp_shd.g_old_rec.clp_attribute21
546: ,p_clp_attribute22_o => ben_clp_shd.g_old_rec.clp_attribute22
547: ,p_clp_attribute23_o => ben_clp_shd.g_old_rec.clp_attribute23
540: ,p_clp_attribute16_o => ben_clp_shd.g_old_rec.clp_attribute16
541: ,p_clp_attribute17_o => ben_clp_shd.g_old_rec.clp_attribute17
542: ,p_clp_attribute18_o => ben_clp_shd.g_old_rec.clp_attribute18
543: ,p_clp_attribute19_o => ben_clp_shd.g_old_rec.clp_attribute19
544: ,p_clp_attribute20_o => ben_clp_shd.g_old_rec.clp_attribute20
545: ,p_clp_attribute21_o => ben_clp_shd.g_old_rec.clp_attribute21
546: ,p_clp_attribute22_o => ben_clp_shd.g_old_rec.clp_attribute22
547: ,p_clp_attribute23_o => ben_clp_shd.g_old_rec.clp_attribute23
548: ,p_clp_attribute24_o => ben_clp_shd.g_old_rec.clp_attribute24
541: ,p_clp_attribute17_o => ben_clp_shd.g_old_rec.clp_attribute17
542: ,p_clp_attribute18_o => ben_clp_shd.g_old_rec.clp_attribute18
543: ,p_clp_attribute19_o => ben_clp_shd.g_old_rec.clp_attribute19
544: ,p_clp_attribute20_o => ben_clp_shd.g_old_rec.clp_attribute20
545: ,p_clp_attribute21_o => ben_clp_shd.g_old_rec.clp_attribute21
546: ,p_clp_attribute22_o => ben_clp_shd.g_old_rec.clp_attribute22
547: ,p_clp_attribute23_o => ben_clp_shd.g_old_rec.clp_attribute23
548: ,p_clp_attribute24_o => ben_clp_shd.g_old_rec.clp_attribute24
549: ,p_clp_attribute25_o => ben_clp_shd.g_old_rec.clp_attribute25
542: ,p_clp_attribute18_o => ben_clp_shd.g_old_rec.clp_attribute18
543: ,p_clp_attribute19_o => ben_clp_shd.g_old_rec.clp_attribute19
544: ,p_clp_attribute20_o => ben_clp_shd.g_old_rec.clp_attribute20
545: ,p_clp_attribute21_o => ben_clp_shd.g_old_rec.clp_attribute21
546: ,p_clp_attribute22_o => ben_clp_shd.g_old_rec.clp_attribute22
547: ,p_clp_attribute23_o => ben_clp_shd.g_old_rec.clp_attribute23
548: ,p_clp_attribute24_o => ben_clp_shd.g_old_rec.clp_attribute24
549: ,p_clp_attribute25_o => ben_clp_shd.g_old_rec.clp_attribute25
550: ,p_clp_attribute26_o => ben_clp_shd.g_old_rec.clp_attribute26
543: ,p_clp_attribute19_o => ben_clp_shd.g_old_rec.clp_attribute19
544: ,p_clp_attribute20_o => ben_clp_shd.g_old_rec.clp_attribute20
545: ,p_clp_attribute21_o => ben_clp_shd.g_old_rec.clp_attribute21
546: ,p_clp_attribute22_o => ben_clp_shd.g_old_rec.clp_attribute22
547: ,p_clp_attribute23_o => ben_clp_shd.g_old_rec.clp_attribute23
548: ,p_clp_attribute24_o => ben_clp_shd.g_old_rec.clp_attribute24
549: ,p_clp_attribute25_o => ben_clp_shd.g_old_rec.clp_attribute25
550: ,p_clp_attribute26_o => ben_clp_shd.g_old_rec.clp_attribute26
551: ,p_clp_attribute27_o => ben_clp_shd.g_old_rec.clp_attribute27
544: ,p_clp_attribute20_o => ben_clp_shd.g_old_rec.clp_attribute20
545: ,p_clp_attribute21_o => ben_clp_shd.g_old_rec.clp_attribute21
546: ,p_clp_attribute22_o => ben_clp_shd.g_old_rec.clp_attribute22
547: ,p_clp_attribute23_o => ben_clp_shd.g_old_rec.clp_attribute23
548: ,p_clp_attribute24_o => ben_clp_shd.g_old_rec.clp_attribute24
549: ,p_clp_attribute25_o => ben_clp_shd.g_old_rec.clp_attribute25
550: ,p_clp_attribute26_o => ben_clp_shd.g_old_rec.clp_attribute26
551: ,p_clp_attribute27_o => ben_clp_shd.g_old_rec.clp_attribute27
552: ,p_clp_attribute28_o => ben_clp_shd.g_old_rec.clp_attribute28
545: ,p_clp_attribute21_o => ben_clp_shd.g_old_rec.clp_attribute21
546: ,p_clp_attribute22_o => ben_clp_shd.g_old_rec.clp_attribute22
547: ,p_clp_attribute23_o => ben_clp_shd.g_old_rec.clp_attribute23
548: ,p_clp_attribute24_o => ben_clp_shd.g_old_rec.clp_attribute24
549: ,p_clp_attribute25_o => ben_clp_shd.g_old_rec.clp_attribute25
550: ,p_clp_attribute26_o => ben_clp_shd.g_old_rec.clp_attribute26
551: ,p_clp_attribute27_o => ben_clp_shd.g_old_rec.clp_attribute27
552: ,p_clp_attribute28_o => ben_clp_shd.g_old_rec.clp_attribute28
553: ,p_clp_attribute29_o => ben_clp_shd.g_old_rec.clp_attribute29
546: ,p_clp_attribute22_o => ben_clp_shd.g_old_rec.clp_attribute22
547: ,p_clp_attribute23_o => ben_clp_shd.g_old_rec.clp_attribute23
548: ,p_clp_attribute24_o => ben_clp_shd.g_old_rec.clp_attribute24
549: ,p_clp_attribute25_o => ben_clp_shd.g_old_rec.clp_attribute25
550: ,p_clp_attribute26_o => ben_clp_shd.g_old_rec.clp_attribute26
551: ,p_clp_attribute27_o => ben_clp_shd.g_old_rec.clp_attribute27
552: ,p_clp_attribute28_o => ben_clp_shd.g_old_rec.clp_attribute28
553: ,p_clp_attribute29_o => ben_clp_shd.g_old_rec.clp_attribute29
554: ,p_clp_attribute30_o => ben_clp_shd.g_old_rec.clp_attribute30
547: ,p_clp_attribute23_o => ben_clp_shd.g_old_rec.clp_attribute23
548: ,p_clp_attribute24_o => ben_clp_shd.g_old_rec.clp_attribute24
549: ,p_clp_attribute25_o => ben_clp_shd.g_old_rec.clp_attribute25
550: ,p_clp_attribute26_o => ben_clp_shd.g_old_rec.clp_attribute26
551: ,p_clp_attribute27_o => ben_clp_shd.g_old_rec.clp_attribute27
552: ,p_clp_attribute28_o => ben_clp_shd.g_old_rec.clp_attribute28
553: ,p_clp_attribute29_o => ben_clp_shd.g_old_rec.clp_attribute29
554: ,p_clp_attribute30_o => ben_clp_shd.g_old_rec.clp_attribute30
555: ,p_object_version_number_o => ben_clp_shd.g_old_rec.object_version_number);
548: ,p_clp_attribute24_o => ben_clp_shd.g_old_rec.clp_attribute24
549: ,p_clp_attribute25_o => ben_clp_shd.g_old_rec.clp_attribute25
550: ,p_clp_attribute26_o => ben_clp_shd.g_old_rec.clp_attribute26
551: ,p_clp_attribute27_o => ben_clp_shd.g_old_rec.clp_attribute27
552: ,p_clp_attribute28_o => ben_clp_shd.g_old_rec.clp_attribute28
553: ,p_clp_attribute29_o => ben_clp_shd.g_old_rec.clp_attribute29
554: ,p_clp_attribute30_o => ben_clp_shd.g_old_rec.clp_attribute30
555: ,p_object_version_number_o => ben_clp_shd.g_old_rec.object_version_number);
556: --
549: ,p_clp_attribute25_o => ben_clp_shd.g_old_rec.clp_attribute25
550: ,p_clp_attribute26_o => ben_clp_shd.g_old_rec.clp_attribute26
551: ,p_clp_attribute27_o => ben_clp_shd.g_old_rec.clp_attribute27
552: ,p_clp_attribute28_o => ben_clp_shd.g_old_rec.clp_attribute28
553: ,p_clp_attribute29_o => ben_clp_shd.g_old_rec.clp_attribute29
554: ,p_clp_attribute30_o => ben_clp_shd.g_old_rec.clp_attribute30
555: ,p_object_version_number_o => ben_clp_shd.g_old_rec.object_version_number);
556: --
557: exception
550: ,p_clp_attribute26_o => ben_clp_shd.g_old_rec.clp_attribute26
551: ,p_clp_attribute27_o => ben_clp_shd.g_old_rec.clp_attribute27
552: ,p_clp_attribute28_o => ben_clp_shd.g_old_rec.clp_attribute28
553: ,p_clp_attribute29_o => ben_clp_shd.g_old_rec.clp_attribute29
554: ,p_clp_attribute30_o => ben_clp_shd.g_old_rec.clp_attribute30
555: ,p_object_version_number_o => ben_clp_shd.g_old_rec.object_version_number);
556: --
557: exception
558: --
551: ,p_clp_attribute27_o => ben_clp_shd.g_old_rec.clp_attribute27
552: ,p_clp_attribute28_o => ben_clp_shd.g_old_rec.clp_attribute28
553: ,p_clp_attribute29_o => ben_clp_shd.g_old_rec.clp_attribute29
554: ,p_clp_attribute30_o => ben_clp_shd.g_old_rec.clp_attribute30
555: ,p_object_version_number_o => ben_clp_shd.g_old_rec.object_version_number);
556: --
557: exception
558: --
559: when hr_api.cannot_find_prog_unit then
613: -- Internal Row Handler Use Only.
614: --
615: -- {End Of Comments}
616: -- ----------------------------------------------------------------------------
617: Procedure convert_defs(p_rec in out nocopy ben_clp_shd.g_rec_type) is
618: --
619: l_proc varchar2(72) := g_package||'convert_defs';
620: --
621: Begin
628: -- is being used then we must set to the 'current' argument value.
629: --
630: If (p_rec.business_group_id = hr_api.g_number) then
631: p_rec.business_group_id :=
632: ben_clp_shd.g_old_rec.business_group_id;
633: End If;
634: If (p_rec.seq = hr_api.g_number) then
635: p_rec.seq :=
636: ben_clp_shd.g_old_rec.seq;
632: ben_clp_shd.g_old_rec.business_group_id;
633: End If;
634: If (p_rec.seq = hr_api.g_number) then
635: p_rec.seq :=
636: ben_clp_shd.g_old_rec.seq;
637: End If;
638: If (p_rec.ler1_id = hr_api.g_number) then
639: p_rec.ler1_id :=
640: ben_clp_shd.g_old_rec.ler1_id;
636: ben_clp_shd.g_old_rec.seq;
637: End If;
638: If (p_rec.ler1_id = hr_api.g_number) then
639: p_rec.ler1_id :=
640: ben_clp_shd.g_old_rec.ler1_id;
641: End If;
642: If (p_rec.bool1_cd = hr_api.g_varchar2) then
643: p_rec.bool1_cd :=
644: ben_clp_shd.g_old_rec.bool1_cd;
640: ben_clp_shd.g_old_rec.ler1_id;
641: End If;
642: If (p_rec.bool1_cd = hr_api.g_varchar2) then
643: p_rec.bool1_cd :=
644: ben_clp_shd.g_old_rec.bool1_cd;
645: End If;
646: If (p_rec.ler2_id = hr_api.g_number) then
647: p_rec.ler2_id :=
648: ben_clp_shd.g_old_rec.ler2_id;
644: ben_clp_shd.g_old_rec.bool1_cd;
645: End If;
646: If (p_rec.ler2_id = hr_api.g_number) then
647: p_rec.ler2_id :=
648: ben_clp_shd.g_old_rec.ler2_id;
649: End If;
650: If (p_rec.bool2_cd = hr_api.g_varchar2) then
651: p_rec.bool2_cd :=
652: ben_clp_shd.g_old_rec.bool2_cd;
648: ben_clp_shd.g_old_rec.ler2_id;
649: End If;
650: If (p_rec.bool2_cd = hr_api.g_varchar2) then
651: p_rec.bool2_cd :=
652: ben_clp_shd.g_old_rec.bool2_cd;
653: End If;
654: If (p_rec.ler3_id = hr_api.g_number) then
655: p_rec.ler3_id :=
656: ben_clp_shd.g_old_rec.ler3_id;
652: ben_clp_shd.g_old_rec.bool2_cd;
653: End If;
654: If (p_rec.ler3_id = hr_api.g_number) then
655: p_rec.ler3_id :=
656: ben_clp_shd.g_old_rec.ler3_id;
657: End If;
658: If (p_rec.bool3_cd = hr_api.g_varchar2) then
659: p_rec.bool3_cd :=
660: ben_clp_shd.g_old_rec.bool3_cd;
656: ben_clp_shd.g_old_rec.ler3_id;
657: End If;
658: If (p_rec.bool3_cd = hr_api.g_varchar2) then
659: p_rec.bool3_cd :=
660: ben_clp_shd.g_old_rec.bool3_cd;
661: End If;
662: If (p_rec.ler4_id = hr_api.g_number) then
663: p_rec.ler4_id :=
664: ben_clp_shd.g_old_rec.ler4_id;
660: ben_clp_shd.g_old_rec.bool3_cd;
661: End If;
662: If (p_rec.ler4_id = hr_api.g_number) then
663: p_rec.ler4_id :=
664: ben_clp_shd.g_old_rec.ler4_id;
665: End If;
666: If (p_rec.bool4_cd = hr_api.g_varchar2) then
667: p_rec.bool4_cd :=
668: ben_clp_shd.g_old_rec.bool4_cd;
664: ben_clp_shd.g_old_rec.ler4_id;
665: End If;
666: If (p_rec.bool4_cd = hr_api.g_varchar2) then
667: p_rec.bool4_cd :=
668: ben_clp_shd.g_old_rec.bool4_cd;
669: End If;
670: If (p_rec.ler5_id = hr_api.g_number) then
671: p_rec.ler5_id :=
672: ben_clp_shd.g_old_rec.ler5_id;
668: ben_clp_shd.g_old_rec.bool4_cd;
669: End If;
670: If (p_rec.ler5_id = hr_api.g_number) then
671: p_rec.ler5_id :=
672: ben_clp_shd.g_old_rec.ler5_id;
673: End If;
674: If (p_rec.bool5_cd = hr_api.g_varchar2) then
675: p_rec.bool5_cd :=
676: ben_clp_shd.g_old_rec.bool5_cd;
672: ben_clp_shd.g_old_rec.ler5_id;
673: End If;
674: If (p_rec.bool5_cd = hr_api.g_varchar2) then
675: p_rec.bool5_cd :=
676: ben_clp_shd.g_old_rec.bool5_cd;
677: End If;
678: If (p_rec.ler6_id = hr_api.g_number) then
679: p_rec.ler6_id :=
680: ben_clp_shd.g_old_rec.ler6_id;
676: ben_clp_shd.g_old_rec.bool5_cd;
677: End If;
678: If (p_rec.ler6_id = hr_api.g_number) then
679: p_rec.ler6_id :=
680: ben_clp_shd.g_old_rec.ler6_id;
681: End If;
682: If (p_rec.bool6_cd = hr_api.g_varchar2) then
683: p_rec.bool6_cd :=
684: ben_clp_shd.g_old_rec.bool6_cd;
680: ben_clp_shd.g_old_rec.ler6_id;
681: End If;
682: If (p_rec.bool6_cd = hr_api.g_varchar2) then
683: p_rec.bool6_cd :=
684: ben_clp_shd.g_old_rec.bool6_cd;
685: End If;
686: If (p_rec.ler7_id = hr_api.g_number) then
687: p_rec.ler7_id :=
688: ben_clp_shd.g_old_rec.ler7_id;
684: ben_clp_shd.g_old_rec.bool6_cd;
685: End If;
686: If (p_rec.ler7_id = hr_api.g_number) then
687: p_rec.ler7_id :=
688: ben_clp_shd.g_old_rec.ler7_id;
689: End If;
690: If (p_rec.bool7_cd = hr_api.g_varchar2) then
691: p_rec.bool7_cd :=
692: ben_clp_shd.g_old_rec.bool7_cd;
688: ben_clp_shd.g_old_rec.ler7_id;
689: End If;
690: If (p_rec.bool7_cd = hr_api.g_varchar2) then
691: p_rec.bool7_cd :=
692: ben_clp_shd.g_old_rec.bool7_cd;
693: End If;
694: If (p_rec.ler8_id = hr_api.g_number) then
695: p_rec.ler8_id :=
696: ben_clp_shd.g_old_rec.ler8_id;
692: ben_clp_shd.g_old_rec.bool7_cd;
693: End If;
694: If (p_rec.ler8_id = hr_api.g_number) then
695: p_rec.ler8_id :=
696: ben_clp_shd.g_old_rec.ler8_id;
697: End If;
698: If (p_rec.bool8_cd = hr_api.g_varchar2) then
699: p_rec.bool8_cd :=
700: ben_clp_shd.g_old_rec.bool8_cd;
696: ben_clp_shd.g_old_rec.ler8_id;
697: End If;
698: If (p_rec.bool8_cd = hr_api.g_varchar2) then
699: p_rec.bool8_cd :=
700: ben_clp_shd.g_old_rec.bool8_cd;
701: End If;
702: If (p_rec.ler9_id = hr_api.g_number) then
703: p_rec.ler9_id :=
704: ben_clp_shd.g_old_rec.ler9_id;
700: ben_clp_shd.g_old_rec.bool8_cd;
701: End If;
702: If (p_rec.ler9_id = hr_api.g_number) then
703: p_rec.ler9_id :=
704: ben_clp_shd.g_old_rec.ler9_id;
705: End If;
706: If (p_rec.bool9_cd = hr_api.g_varchar2) then
707: p_rec.bool9_cd :=
708: ben_clp_shd.g_old_rec.bool9_cd;
704: ben_clp_shd.g_old_rec.ler9_id;
705: End If;
706: If (p_rec.bool9_cd = hr_api.g_varchar2) then
707: p_rec.bool9_cd :=
708: ben_clp_shd.g_old_rec.bool9_cd;
709: End If;
710: If (p_rec.ler10_id = hr_api.g_number) then
711: p_rec.ler10_id :=
712: ben_clp_shd.g_old_rec.ler10_id;
708: ben_clp_shd.g_old_rec.bool9_cd;
709: End If;
710: If (p_rec.ler10_id = hr_api.g_number) then
711: p_rec.ler10_id :=
712: ben_clp_shd.g_old_rec.ler10_id;
713: End If;
714: If (p_rec.eval_cd = hr_api.g_varchar2) then
715: p_rec.eval_cd :=
716: ben_clp_shd.g_old_rec.eval_cd;
712: ben_clp_shd.g_old_rec.ler10_id;
713: End If;
714: If (p_rec.eval_cd = hr_api.g_varchar2) then
715: p_rec.eval_cd :=
716: ben_clp_shd.g_old_rec.eval_cd;
717: End If;
718: If (p_rec.eval_rl = hr_api.g_number) then
719: p_rec.eval_rl :=
720: ben_clp_shd.g_old_rec.eval_rl;
716: ben_clp_shd.g_old_rec.eval_cd;
717: End If;
718: If (p_rec.eval_rl = hr_api.g_number) then
719: p_rec.eval_rl :=
720: ben_clp_shd.g_old_rec.eval_rl;
721: End If;
722: If (p_rec.tlrnc_dys_num = hr_api.g_number) then
723: p_rec.tlrnc_dys_num :=
724: ben_clp_shd.g_old_rec.tlrnc_dys_num;
720: ben_clp_shd.g_old_rec.eval_rl;
721: End If;
722: If (p_rec.tlrnc_dys_num = hr_api.g_number) then
723: p_rec.tlrnc_dys_num :=
724: ben_clp_shd.g_old_rec.tlrnc_dys_num;
725: End If;
726: If (p_rec.eval_ler_id = hr_api.g_number) then
727: p_rec.eval_ler_id :=
728: ben_clp_shd.g_old_rec.eval_ler_id;
724: ben_clp_shd.g_old_rec.tlrnc_dys_num;
725: End If;
726: If (p_rec.eval_ler_id = hr_api.g_number) then
727: p_rec.eval_ler_id :=
728: ben_clp_shd.g_old_rec.eval_ler_id;
729: End If;
730: If (p_rec.eval_ler_det_cd = hr_api.g_varchar2) then
731: p_rec.eval_ler_det_cd :=
732: ben_clp_shd.g_old_rec.eval_ler_det_cd;
728: ben_clp_shd.g_old_rec.eval_ler_id;
729: End If;
730: If (p_rec.eval_ler_det_cd = hr_api.g_varchar2) then
731: p_rec.eval_ler_det_cd :=
732: ben_clp_shd.g_old_rec.eval_ler_det_cd;
733: End If;
734: If (p_rec.eval_ler_det_rl = hr_api.g_number) then
735: p_rec.eval_ler_det_rl :=
736: ben_clp_shd.g_old_rec.eval_ler_det_rl;
732: ben_clp_shd.g_old_rec.eval_ler_det_cd;
733: End If;
734: If (p_rec.eval_ler_det_rl = hr_api.g_number) then
735: p_rec.eval_ler_det_rl :=
736: ben_clp_shd.g_old_rec.eval_ler_det_rl;
737: End If;
738: If (p_rec.clp_attribute_category = hr_api.g_varchar2) then
739: p_rec.clp_attribute_category :=
740: ben_clp_shd.g_old_rec.clp_attribute_category;
736: ben_clp_shd.g_old_rec.eval_ler_det_rl;
737: End If;
738: If (p_rec.clp_attribute_category = hr_api.g_varchar2) then
739: p_rec.clp_attribute_category :=
740: ben_clp_shd.g_old_rec.clp_attribute_category;
741: End If;
742: If (p_rec.clp_attribute1 = hr_api.g_varchar2) then
743: p_rec.clp_attribute1 :=
744: ben_clp_shd.g_old_rec.clp_attribute1;
740: ben_clp_shd.g_old_rec.clp_attribute_category;
741: End If;
742: If (p_rec.clp_attribute1 = hr_api.g_varchar2) then
743: p_rec.clp_attribute1 :=
744: ben_clp_shd.g_old_rec.clp_attribute1;
745: End If;
746: If (p_rec.clp_attribute2 = hr_api.g_varchar2) then
747: p_rec.clp_attribute2 :=
748: ben_clp_shd.g_old_rec.clp_attribute2;
744: ben_clp_shd.g_old_rec.clp_attribute1;
745: End If;
746: If (p_rec.clp_attribute2 = hr_api.g_varchar2) then
747: p_rec.clp_attribute2 :=
748: ben_clp_shd.g_old_rec.clp_attribute2;
749: End If;
750: If (p_rec.clp_attribute3 = hr_api.g_varchar2) then
751: p_rec.clp_attribute3 :=
752: ben_clp_shd.g_old_rec.clp_attribute3;
748: ben_clp_shd.g_old_rec.clp_attribute2;
749: End If;
750: If (p_rec.clp_attribute3 = hr_api.g_varchar2) then
751: p_rec.clp_attribute3 :=
752: ben_clp_shd.g_old_rec.clp_attribute3;
753: End If;
754: If (p_rec.clp_attribute4 = hr_api.g_varchar2) then
755: p_rec.clp_attribute4 :=
756: ben_clp_shd.g_old_rec.clp_attribute4;
752: ben_clp_shd.g_old_rec.clp_attribute3;
753: End If;
754: If (p_rec.clp_attribute4 = hr_api.g_varchar2) then
755: p_rec.clp_attribute4 :=
756: ben_clp_shd.g_old_rec.clp_attribute4;
757: End If;
758: If (p_rec.clp_attribute5 = hr_api.g_varchar2) then
759: p_rec.clp_attribute5 :=
760: ben_clp_shd.g_old_rec.clp_attribute5;
756: ben_clp_shd.g_old_rec.clp_attribute4;
757: End If;
758: If (p_rec.clp_attribute5 = hr_api.g_varchar2) then
759: p_rec.clp_attribute5 :=
760: ben_clp_shd.g_old_rec.clp_attribute5;
761: End If;
762: If (p_rec.clp_attribute6 = hr_api.g_varchar2) then
763: p_rec.clp_attribute6 :=
764: ben_clp_shd.g_old_rec.clp_attribute6;
760: ben_clp_shd.g_old_rec.clp_attribute5;
761: End If;
762: If (p_rec.clp_attribute6 = hr_api.g_varchar2) then
763: p_rec.clp_attribute6 :=
764: ben_clp_shd.g_old_rec.clp_attribute6;
765: End If;
766: If (p_rec.clp_attribute7 = hr_api.g_varchar2) then
767: p_rec.clp_attribute7 :=
768: ben_clp_shd.g_old_rec.clp_attribute7;
764: ben_clp_shd.g_old_rec.clp_attribute6;
765: End If;
766: If (p_rec.clp_attribute7 = hr_api.g_varchar2) then
767: p_rec.clp_attribute7 :=
768: ben_clp_shd.g_old_rec.clp_attribute7;
769: End If;
770: If (p_rec.clp_attribute8 = hr_api.g_varchar2) then
771: p_rec.clp_attribute8 :=
772: ben_clp_shd.g_old_rec.clp_attribute8;
768: ben_clp_shd.g_old_rec.clp_attribute7;
769: End If;
770: If (p_rec.clp_attribute8 = hr_api.g_varchar2) then
771: p_rec.clp_attribute8 :=
772: ben_clp_shd.g_old_rec.clp_attribute8;
773: End If;
774: If (p_rec.clp_attribute9 = hr_api.g_varchar2) then
775: p_rec.clp_attribute9 :=
776: ben_clp_shd.g_old_rec.clp_attribute9;
772: ben_clp_shd.g_old_rec.clp_attribute8;
773: End If;
774: If (p_rec.clp_attribute9 = hr_api.g_varchar2) then
775: p_rec.clp_attribute9 :=
776: ben_clp_shd.g_old_rec.clp_attribute9;
777: End If;
778: If (p_rec.clp_attribute10 = hr_api.g_varchar2) then
779: p_rec.clp_attribute10 :=
780: ben_clp_shd.g_old_rec.clp_attribute10;
776: ben_clp_shd.g_old_rec.clp_attribute9;
777: End If;
778: If (p_rec.clp_attribute10 = hr_api.g_varchar2) then
779: p_rec.clp_attribute10 :=
780: ben_clp_shd.g_old_rec.clp_attribute10;
781: End If;
782: If (p_rec.clp_attribute11 = hr_api.g_varchar2) then
783: p_rec.clp_attribute11 :=
784: ben_clp_shd.g_old_rec.clp_attribute11;
780: ben_clp_shd.g_old_rec.clp_attribute10;
781: End If;
782: If (p_rec.clp_attribute11 = hr_api.g_varchar2) then
783: p_rec.clp_attribute11 :=
784: ben_clp_shd.g_old_rec.clp_attribute11;
785: End If;
786: If (p_rec.clp_attribute12 = hr_api.g_varchar2) then
787: p_rec.clp_attribute12 :=
788: ben_clp_shd.g_old_rec.clp_attribute12;
784: ben_clp_shd.g_old_rec.clp_attribute11;
785: End If;
786: If (p_rec.clp_attribute12 = hr_api.g_varchar2) then
787: p_rec.clp_attribute12 :=
788: ben_clp_shd.g_old_rec.clp_attribute12;
789: End If;
790: If (p_rec.clp_attribute13 = hr_api.g_varchar2) then
791: p_rec.clp_attribute13 :=
792: ben_clp_shd.g_old_rec.clp_attribute13;
788: ben_clp_shd.g_old_rec.clp_attribute12;
789: End If;
790: If (p_rec.clp_attribute13 = hr_api.g_varchar2) then
791: p_rec.clp_attribute13 :=
792: ben_clp_shd.g_old_rec.clp_attribute13;
793: End If;
794: If (p_rec.clp_attribute14 = hr_api.g_varchar2) then
795: p_rec.clp_attribute14 :=
796: ben_clp_shd.g_old_rec.clp_attribute14;
792: ben_clp_shd.g_old_rec.clp_attribute13;
793: End If;
794: If (p_rec.clp_attribute14 = hr_api.g_varchar2) then
795: p_rec.clp_attribute14 :=
796: ben_clp_shd.g_old_rec.clp_attribute14;
797: End If;
798: If (p_rec.clp_attribute15 = hr_api.g_varchar2) then
799: p_rec.clp_attribute15 :=
800: ben_clp_shd.g_old_rec.clp_attribute15;
796: ben_clp_shd.g_old_rec.clp_attribute14;
797: End If;
798: If (p_rec.clp_attribute15 = hr_api.g_varchar2) then
799: p_rec.clp_attribute15 :=
800: ben_clp_shd.g_old_rec.clp_attribute15;
801: End If;
802: If (p_rec.clp_attribute16 = hr_api.g_varchar2) then
803: p_rec.clp_attribute16 :=
804: ben_clp_shd.g_old_rec.clp_attribute16;
800: ben_clp_shd.g_old_rec.clp_attribute15;
801: End If;
802: If (p_rec.clp_attribute16 = hr_api.g_varchar2) then
803: p_rec.clp_attribute16 :=
804: ben_clp_shd.g_old_rec.clp_attribute16;
805: End If;
806: If (p_rec.clp_attribute17 = hr_api.g_varchar2) then
807: p_rec.clp_attribute17 :=
808: ben_clp_shd.g_old_rec.clp_attribute17;
804: ben_clp_shd.g_old_rec.clp_attribute16;
805: End If;
806: If (p_rec.clp_attribute17 = hr_api.g_varchar2) then
807: p_rec.clp_attribute17 :=
808: ben_clp_shd.g_old_rec.clp_attribute17;
809: End If;
810: If (p_rec.clp_attribute18 = hr_api.g_varchar2) then
811: p_rec.clp_attribute18 :=
812: ben_clp_shd.g_old_rec.clp_attribute18;
808: ben_clp_shd.g_old_rec.clp_attribute17;
809: End If;
810: If (p_rec.clp_attribute18 = hr_api.g_varchar2) then
811: p_rec.clp_attribute18 :=
812: ben_clp_shd.g_old_rec.clp_attribute18;
813: End If;
814: If (p_rec.clp_attribute19 = hr_api.g_varchar2) then
815: p_rec.clp_attribute19 :=
816: ben_clp_shd.g_old_rec.clp_attribute19;
812: ben_clp_shd.g_old_rec.clp_attribute18;
813: End If;
814: If (p_rec.clp_attribute19 = hr_api.g_varchar2) then
815: p_rec.clp_attribute19 :=
816: ben_clp_shd.g_old_rec.clp_attribute19;
817: End If;
818: If (p_rec.clp_attribute20 = hr_api.g_varchar2) then
819: p_rec.clp_attribute20 :=
820: ben_clp_shd.g_old_rec.clp_attribute20;
816: ben_clp_shd.g_old_rec.clp_attribute19;
817: End If;
818: If (p_rec.clp_attribute20 = hr_api.g_varchar2) then
819: p_rec.clp_attribute20 :=
820: ben_clp_shd.g_old_rec.clp_attribute20;
821: End If;
822: If (p_rec.clp_attribute21 = hr_api.g_varchar2) then
823: p_rec.clp_attribute21 :=
824: ben_clp_shd.g_old_rec.clp_attribute21;
820: ben_clp_shd.g_old_rec.clp_attribute20;
821: End If;
822: If (p_rec.clp_attribute21 = hr_api.g_varchar2) then
823: p_rec.clp_attribute21 :=
824: ben_clp_shd.g_old_rec.clp_attribute21;
825: End If;
826: If (p_rec.clp_attribute22 = hr_api.g_varchar2) then
827: p_rec.clp_attribute22 :=
828: ben_clp_shd.g_old_rec.clp_attribute22;
824: ben_clp_shd.g_old_rec.clp_attribute21;
825: End If;
826: If (p_rec.clp_attribute22 = hr_api.g_varchar2) then
827: p_rec.clp_attribute22 :=
828: ben_clp_shd.g_old_rec.clp_attribute22;
829: End If;
830: If (p_rec.clp_attribute23 = hr_api.g_varchar2) then
831: p_rec.clp_attribute23 :=
832: ben_clp_shd.g_old_rec.clp_attribute23;
828: ben_clp_shd.g_old_rec.clp_attribute22;
829: End If;
830: If (p_rec.clp_attribute23 = hr_api.g_varchar2) then
831: p_rec.clp_attribute23 :=
832: ben_clp_shd.g_old_rec.clp_attribute23;
833: End If;
834: If (p_rec.clp_attribute24 = hr_api.g_varchar2) then
835: p_rec.clp_attribute24 :=
836: ben_clp_shd.g_old_rec.clp_attribute24;
832: ben_clp_shd.g_old_rec.clp_attribute23;
833: End If;
834: If (p_rec.clp_attribute24 = hr_api.g_varchar2) then
835: p_rec.clp_attribute24 :=
836: ben_clp_shd.g_old_rec.clp_attribute24;
837: End If;
838: If (p_rec.clp_attribute25 = hr_api.g_varchar2) then
839: p_rec.clp_attribute25 :=
840: ben_clp_shd.g_old_rec.clp_attribute25;
836: ben_clp_shd.g_old_rec.clp_attribute24;
837: End If;
838: If (p_rec.clp_attribute25 = hr_api.g_varchar2) then
839: p_rec.clp_attribute25 :=
840: ben_clp_shd.g_old_rec.clp_attribute25;
841: End If;
842: If (p_rec.clp_attribute26 = hr_api.g_varchar2) then
843: p_rec.clp_attribute26 :=
844: ben_clp_shd.g_old_rec.clp_attribute26;
840: ben_clp_shd.g_old_rec.clp_attribute25;
841: End If;
842: If (p_rec.clp_attribute26 = hr_api.g_varchar2) then
843: p_rec.clp_attribute26 :=
844: ben_clp_shd.g_old_rec.clp_attribute26;
845: End If;
846: If (p_rec.clp_attribute27 = hr_api.g_varchar2) then
847: p_rec.clp_attribute27 :=
848: ben_clp_shd.g_old_rec.clp_attribute27;
844: ben_clp_shd.g_old_rec.clp_attribute26;
845: End If;
846: If (p_rec.clp_attribute27 = hr_api.g_varchar2) then
847: p_rec.clp_attribute27 :=
848: ben_clp_shd.g_old_rec.clp_attribute27;
849: End If;
850: If (p_rec.clp_attribute28 = hr_api.g_varchar2) then
851: p_rec.clp_attribute28 :=
852: ben_clp_shd.g_old_rec.clp_attribute28;
848: ben_clp_shd.g_old_rec.clp_attribute27;
849: End If;
850: If (p_rec.clp_attribute28 = hr_api.g_varchar2) then
851: p_rec.clp_attribute28 :=
852: ben_clp_shd.g_old_rec.clp_attribute28;
853: End If;
854: If (p_rec.clp_attribute29 = hr_api.g_varchar2) then
855: p_rec.clp_attribute29 :=
856: ben_clp_shd.g_old_rec.clp_attribute29;
852: ben_clp_shd.g_old_rec.clp_attribute28;
853: End If;
854: If (p_rec.clp_attribute29 = hr_api.g_varchar2) then
855: p_rec.clp_attribute29 :=
856: ben_clp_shd.g_old_rec.clp_attribute29;
857: End If;
858: If (p_rec.clp_attribute30 = hr_api.g_varchar2) then
859: p_rec.clp_attribute30 :=
860: ben_clp_shd.g_old_rec.clp_attribute30;
856: ben_clp_shd.g_old_rec.clp_attribute29;
857: End If;
858: If (p_rec.clp_attribute30 = hr_api.g_varchar2) then
859: p_rec.clp_attribute30 :=
860: ben_clp_shd.g_old_rec.clp_attribute30;
861: End If;
862: --
863: hr_utility.set_location(' Leaving:'||l_proc, 10);
864: --
868: -- |---------------------------------< upd >----------------------------------|
869: -- ----------------------------------------------------------------------------
870: Procedure upd
871: (
872: p_rec in out nocopy ben_clp_shd.g_rec_type,
873: p_effective_date in date,
874: p_datetrack_mode in varchar2
875: ) is
876: --
886: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
887: --
888: -- We must lock the row which we need to update.
889: --
890: ben_clp_shd.lck
891: (p_effective_date => p_effective_date,
892: p_datetrack_mode => p_datetrack_mode,
893: p_clpse_lf_evt_id => p_rec.clpse_lf_evt_id,
894: p_object_version_number => p_rec.object_version_number,
1007: p_effective_date in date,
1008: p_datetrack_mode in varchar2
1009: ) is
1010: --
1011: l_rec ben_clp_shd.g_rec_type;
1012: l_proc varchar2(72) := g_package||'upd';
1013: --
1014: Begin
1015: hr_utility.set_location('Entering:'||l_proc, 5);
1017: -- Call conversion function to turn arguments into the
1018: -- l_rec structure.
1019: --
1020: l_rec :=
1021: ben_clp_shd.convert_args
1022: (
1023: p_clpse_lf_evt_id,
1024: null,
1025: null,