54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: Procedure dt_update_dml
58: (p_rec in out nocopy ben_ecv_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_eligy_crit_values_f',
78: p_base_key_column => 'eligy_crit_values_id',
79: p_base_key_value => p_rec.eligy_crit_values_id);
80: --
81: ben_ecv_shd.g_api_dml := true; -- Set the api dml status
82: --
83: -- Update the ben_eligy_crit_vlaues_f Row
84: --
85: update ben_eligy_crit_values_f
142: where eligy_crit_values_id = p_rec.eligy_crit_values_id
143: and effective_start_date = p_validation_start_date
144: and effective_end_date = p_validation_end_date;
145: --
146: ben_ecv_shd.g_api_dml := false; --unset the api dml status
147: --
148: --
149: -- Set the effective start and end dates
150: --
155: hr_utility.set_location(' Leaving:'||l_proc, 15);
156: Exception
157: When hr_api.check_integrity_violated Then
158: -- A check constraint has been violated
159: ben_ecv_shd.g_api_dml := false; --unset the api dml status
160: ben_ecv_shd.constraint_error
161: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
162: When hr_api.unique_integrity_violated Then
163: -- Unique integrity has been violated
156: Exception
157: When hr_api.check_integrity_violated Then
158: -- A check constraint has been violated
159: ben_ecv_shd.g_api_dml := false; --unset the api dml status
160: ben_ecv_shd.constraint_error
161: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
162: When hr_api.unique_integrity_violated Then
163: -- Unique integrity has been violated
164: ben_ecv_shd.g_api_dml := false; -- Unset the api dml status
160: ben_ecv_shd.constraint_error
161: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
162: When hr_api.unique_integrity_violated Then
163: -- Unique integrity has been violated
164: ben_ecv_shd.g_api_dml := false; -- Unset the api dml status
165: ben_ecv_shd.constraint_error
166: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
167: When Others Then
168: ben_ecv_shd.g_api_dml := false; -- Unset the api dml status
161: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
162: When hr_api.unique_integrity_violated Then
163: -- Unique integrity has been violated
164: ben_ecv_shd.g_api_dml := false; -- Unset the api dml status
165: ben_ecv_shd.constraint_error
166: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
167: When Others Then
168: ben_ecv_shd.g_api_dml := false; -- Unset the api dml status
169: Raise;
164: ben_ecv_shd.g_api_dml := false; -- Unset the api dml status
165: ben_ecv_shd.constraint_error
166: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
167: When Others Then
168: ben_ecv_shd.g_api_dml := false; -- Unset the api dml status
169: Raise;
170: End dt_update_dml;
171: --
172: -- ----------------------------------------------------------------------------
200: --
201: -- {End Of Comments}
202: -- ----------------------------------------------------------------------------
203: Procedure update_dml
204: (p_rec in out nocopy ben_ecv_shd.g_rec_type,
205: p_effective_date in date,
206: p_datetrack_mode in varchar2,
207: p_validation_start_date in date,
208: p_validation_end_date in date) is
264: --
265: -- {End Of Comments}
266: -- ----------------------------------------------------------------------------
267: Procedure dt_pre_update
268: (p_rec in out nocopy ben_ecv_shd.g_rec_type,
269: p_effective_date in date,
270: p_datetrack_mode in varchar2,
271: p_validation_start_date in date,
272: p_validation_end_date in date) is
280: hr_utility.set_location(l_proc, 10);
281: --
282: -- Update the current effective end date
283: --
284: ben_ecv_shd.upd_effective_end_date
285: (p_effective_date => p_effective_date,
286: p_base_key_value => p_rec.eligy_crit_values_id,
287: p_new_effective_end_date => (p_validation_start_date - 1),
288: p_validation_start_date => p_validation_start_date,
349: --
350: -- {End Of Comments}
351: -- ----------------------------------------------------------------------------
352: Procedure pre_update
353: (p_rec in out nocopy ben_ecv_shd.g_rec_type,
354: p_effective_date in date,
355: p_datetrack_mode in varchar2,
356: p_validation_start_date in date,
357: p_validation_end_date in date) is
405: --
406: -- {End Of Comments}
407: -- ----------------------------------------------------------------------------
408: Procedure post_update
409: (p_rec in ben_ecv_shd.g_rec_type,
410: p_effective_date in date,
411: p_datetrack_mode in varchar2,
412: p_validation_start_date in date,
413: p_validation_end_date in date) is
482: ,p_number_value3 =>p_rec.number_value3
483: ,p_number_value4 =>p_rec.number_value4
484: ,p_date_value3 =>p_rec.date_value3
485: ,p_date_value4 =>p_rec.date_value4
486: ,p_eligy_prfl_id_o =>ben_ecv_shd.g_old_rec.eligy_prfl_id
487: ,p_eligy_criteria_id_o =>ben_ecv_shd.g_old_rec.eligy_criteria_id
488: ,p_effective_start_date_o =>ben_ecv_shd.g_old_rec.effective_start_date
489: ,p_effective_end_date_o =>ben_ecv_shd.g_old_rec.effective_end_date
490: ,p_ordr_num_o =>ben_ecv_shd.g_old_rec.ordr_num
483: ,p_number_value4 =>p_rec.number_value4
484: ,p_date_value3 =>p_rec.date_value3
485: ,p_date_value4 =>p_rec.date_value4
486: ,p_eligy_prfl_id_o =>ben_ecv_shd.g_old_rec.eligy_prfl_id
487: ,p_eligy_criteria_id_o =>ben_ecv_shd.g_old_rec.eligy_criteria_id
488: ,p_effective_start_date_o =>ben_ecv_shd.g_old_rec.effective_start_date
489: ,p_effective_end_date_o =>ben_ecv_shd.g_old_rec.effective_end_date
490: ,p_ordr_num_o =>ben_ecv_shd.g_old_rec.ordr_num
491: ,p_number_value1_o =>ben_ecv_shd.g_old_rec.number_value1
484: ,p_date_value3 =>p_rec.date_value3
485: ,p_date_value4 =>p_rec.date_value4
486: ,p_eligy_prfl_id_o =>ben_ecv_shd.g_old_rec.eligy_prfl_id
487: ,p_eligy_criteria_id_o =>ben_ecv_shd.g_old_rec.eligy_criteria_id
488: ,p_effective_start_date_o =>ben_ecv_shd.g_old_rec.effective_start_date
489: ,p_effective_end_date_o =>ben_ecv_shd.g_old_rec.effective_end_date
490: ,p_ordr_num_o =>ben_ecv_shd.g_old_rec.ordr_num
491: ,p_number_value1_o =>ben_ecv_shd.g_old_rec.number_value1
492: ,p_number_value2_o =>ben_ecv_shd.g_old_rec.number_value2
485: ,p_date_value4 =>p_rec.date_value4
486: ,p_eligy_prfl_id_o =>ben_ecv_shd.g_old_rec.eligy_prfl_id
487: ,p_eligy_criteria_id_o =>ben_ecv_shd.g_old_rec.eligy_criteria_id
488: ,p_effective_start_date_o =>ben_ecv_shd.g_old_rec.effective_start_date
489: ,p_effective_end_date_o =>ben_ecv_shd.g_old_rec.effective_end_date
490: ,p_ordr_num_o =>ben_ecv_shd.g_old_rec.ordr_num
491: ,p_number_value1_o =>ben_ecv_shd.g_old_rec.number_value1
492: ,p_number_value2_o =>ben_ecv_shd.g_old_rec.number_value2
493: ,p_char_value1_o =>ben_ecv_shd.g_old_rec.char_value1
486: ,p_eligy_prfl_id_o =>ben_ecv_shd.g_old_rec.eligy_prfl_id
487: ,p_eligy_criteria_id_o =>ben_ecv_shd.g_old_rec.eligy_criteria_id
488: ,p_effective_start_date_o =>ben_ecv_shd.g_old_rec.effective_start_date
489: ,p_effective_end_date_o =>ben_ecv_shd.g_old_rec.effective_end_date
490: ,p_ordr_num_o =>ben_ecv_shd.g_old_rec.ordr_num
491: ,p_number_value1_o =>ben_ecv_shd.g_old_rec.number_value1
492: ,p_number_value2_o =>ben_ecv_shd.g_old_rec.number_value2
493: ,p_char_value1_o =>ben_ecv_shd.g_old_rec.char_value1
494: ,p_char_value2_o =>ben_ecv_shd.g_old_rec.char_value2
487: ,p_eligy_criteria_id_o =>ben_ecv_shd.g_old_rec.eligy_criteria_id
488: ,p_effective_start_date_o =>ben_ecv_shd.g_old_rec.effective_start_date
489: ,p_effective_end_date_o =>ben_ecv_shd.g_old_rec.effective_end_date
490: ,p_ordr_num_o =>ben_ecv_shd.g_old_rec.ordr_num
491: ,p_number_value1_o =>ben_ecv_shd.g_old_rec.number_value1
492: ,p_number_value2_o =>ben_ecv_shd.g_old_rec.number_value2
493: ,p_char_value1_o =>ben_ecv_shd.g_old_rec.char_value1
494: ,p_char_value2_o =>ben_ecv_shd.g_old_rec.char_value2
495: ,p_date_value1_o =>ben_ecv_shd.g_old_rec.date_value1
488: ,p_effective_start_date_o =>ben_ecv_shd.g_old_rec.effective_start_date
489: ,p_effective_end_date_o =>ben_ecv_shd.g_old_rec.effective_end_date
490: ,p_ordr_num_o =>ben_ecv_shd.g_old_rec.ordr_num
491: ,p_number_value1_o =>ben_ecv_shd.g_old_rec.number_value1
492: ,p_number_value2_o =>ben_ecv_shd.g_old_rec.number_value2
493: ,p_char_value1_o =>ben_ecv_shd.g_old_rec.char_value1
494: ,p_char_value2_o =>ben_ecv_shd.g_old_rec.char_value2
495: ,p_date_value1_o =>ben_ecv_shd.g_old_rec.date_value1
496: ,p_date_value2_o =>ben_ecv_shd.g_old_rec.date_value2
489: ,p_effective_end_date_o =>ben_ecv_shd.g_old_rec.effective_end_date
490: ,p_ordr_num_o =>ben_ecv_shd.g_old_rec.ordr_num
491: ,p_number_value1_o =>ben_ecv_shd.g_old_rec.number_value1
492: ,p_number_value2_o =>ben_ecv_shd.g_old_rec.number_value2
493: ,p_char_value1_o =>ben_ecv_shd.g_old_rec.char_value1
494: ,p_char_value2_o =>ben_ecv_shd.g_old_rec.char_value2
495: ,p_date_value1_o =>ben_ecv_shd.g_old_rec.date_value1
496: ,p_date_value2_o =>ben_ecv_shd.g_old_rec.date_value2
497: ,p_excld_flag_o =>ben_ecv_shd.g_old_rec.excld_flag
490: ,p_ordr_num_o =>ben_ecv_shd.g_old_rec.ordr_num
491: ,p_number_value1_o =>ben_ecv_shd.g_old_rec.number_value1
492: ,p_number_value2_o =>ben_ecv_shd.g_old_rec.number_value2
493: ,p_char_value1_o =>ben_ecv_shd.g_old_rec.char_value1
494: ,p_char_value2_o =>ben_ecv_shd.g_old_rec.char_value2
495: ,p_date_value1_o =>ben_ecv_shd.g_old_rec.date_value1
496: ,p_date_value2_o =>ben_ecv_shd.g_old_rec.date_value2
497: ,p_excld_flag_o =>ben_ecv_shd.g_old_rec.excld_flag
498: ,p_business_group_id_o =>ben_ecv_shd.g_old_rec.business_group_id
491: ,p_number_value1_o =>ben_ecv_shd.g_old_rec.number_value1
492: ,p_number_value2_o =>ben_ecv_shd.g_old_rec.number_value2
493: ,p_char_value1_o =>ben_ecv_shd.g_old_rec.char_value1
494: ,p_char_value2_o =>ben_ecv_shd.g_old_rec.char_value2
495: ,p_date_value1_o =>ben_ecv_shd.g_old_rec.date_value1
496: ,p_date_value2_o =>ben_ecv_shd.g_old_rec.date_value2
497: ,p_excld_flag_o =>ben_ecv_shd.g_old_rec.excld_flag
498: ,p_business_group_id_o =>ben_ecv_shd.g_old_rec.business_group_id
499: ,p_legislation_code_o =>ben_ecv_shd.g_old_rec.legislation_code
492: ,p_number_value2_o =>ben_ecv_shd.g_old_rec.number_value2
493: ,p_char_value1_o =>ben_ecv_shd.g_old_rec.char_value1
494: ,p_char_value2_o =>ben_ecv_shd.g_old_rec.char_value2
495: ,p_date_value1_o =>ben_ecv_shd.g_old_rec.date_value1
496: ,p_date_value2_o =>ben_ecv_shd.g_old_rec.date_value2
497: ,p_excld_flag_o =>ben_ecv_shd.g_old_rec.excld_flag
498: ,p_business_group_id_o =>ben_ecv_shd.g_old_rec.business_group_id
499: ,p_legislation_code_o =>ben_ecv_shd.g_old_rec.legislation_code
500: ,p_ecv_attribute_category_o =>ben_ecv_shd.g_old_rec.ecv_attribute_category
493: ,p_char_value1_o =>ben_ecv_shd.g_old_rec.char_value1
494: ,p_char_value2_o =>ben_ecv_shd.g_old_rec.char_value2
495: ,p_date_value1_o =>ben_ecv_shd.g_old_rec.date_value1
496: ,p_date_value2_o =>ben_ecv_shd.g_old_rec.date_value2
497: ,p_excld_flag_o =>ben_ecv_shd.g_old_rec.excld_flag
498: ,p_business_group_id_o =>ben_ecv_shd.g_old_rec.business_group_id
499: ,p_legislation_code_o =>ben_ecv_shd.g_old_rec.legislation_code
500: ,p_ecv_attribute_category_o =>ben_ecv_shd.g_old_rec.ecv_attribute_category
501: ,p_ecv_attribute1_o =>ben_ecv_shd.g_old_rec.ecv_attribute1
494: ,p_char_value2_o =>ben_ecv_shd.g_old_rec.char_value2
495: ,p_date_value1_o =>ben_ecv_shd.g_old_rec.date_value1
496: ,p_date_value2_o =>ben_ecv_shd.g_old_rec.date_value2
497: ,p_excld_flag_o =>ben_ecv_shd.g_old_rec.excld_flag
498: ,p_business_group_id_o =>ben_ecv_shd.g_old_rec.business_group_id
499: ,p_legislation_code_o =>ben_ecv_shd.g_old_rec.legislation_code
500: ,p_ecv_attribute_category_o =>ben_ecv_shd.g_old_rec.ecv_attribute_category
501: ,p_ecv_attribute1_o =>ben_ecv_shd.g_old_rec.ecv_attribute1
502: ,p_ecv_attribute2_o =>ben_ecv_shd.g_old_rec.ecv_attribute2
495: ,p_date_value1_o =>ben_ecv_shd.g_old_rec.date_value1
496: ,p_date_value2_o =>ben_ecv_shd.g_old_rec.date_value2
497: ,p_excld_flag_o =>ben_ecv_shd.g_old_rec.excld_flag
498: ,p_business_group_id_o =>ben_ecv_shd.g_old_rec.business_group_id
499: ,p_legislation_code_o =>ben_ecv_shd.g_old_rec.legislation_code
500: ,p_ecv_attribute_category_o =>ben_ecv_shd.g_old_rec.ecv_attribute_category
501: ,p_ecv_attribute1_o =>ben_ecv_shd.g_old_rec.ecv_attribute1
502: ,p_ecv_attribute2_o =>ben_ecv_shd.g_old_rec.ecv_attribute2
503: ,p_ecv_attribute3_o =>ben_ecv_shd.g_old_rec.ecv_attribute3
496: ,p_date_value2_o =>ben_ecv_shd.g_old_rec.date_value2
497: ,p_excld_flag_o =>ben_ecv_shd.g_old_rec.excld_flag
498: ,p_business_group_id_o =>ben_ecv_shd.g_old_rec.business_group_id
499: ,p_legislation_code_o =>ben_ecv_shd.g_old_rec.legislation_code
500: ,p_ecv_attribute_category_o =>ben_ecv_shd.g_old_rec.ecv_attribute_category
501: ,p_ecv_attribute1_o =>ben_ecv_shd.g_old_rec.ecv_attribute1
502: ,p_ecv_attribute2_o =>ben_ecv_shd.g_old_rec.ecv_attribute2
503: ,p_ecv_attribute3_o =>ben_ecv_shd.g_old_rec.ecv_attribute3
504: ,p_ecv_attribute4_o =>ben_ecv_shd.g_old_rec.ecv_attribute4
497: ,p_excld_flag_o =>ben_ecv_shd.g_old_rec.excld_flag
498: ,p_business_group_id_o =>ben_ecv_shd.g_old_rec.business_group_id
499: ,p_legislation_code_o =>ben_ecv_shd.g_old_rec.legislation_code
500: ,p_ecv_attribute_category_o =>ben_ecv_shd.g_old_rec.ecv_attribute_category
501: ,p_ecv_attribute1_o =>ben_ecv_shd.g_old_rec.ecv_attribute1
502: ,p_ecv_attribute2_o =>ben_ecv_shd.g_old_rec.ecv_attribute2
503: ,p_ecv_attribute3_o =>ben_ecv_shd.g_old_rec.ecv_attribute3
504: ,p_ecv_attribute4_o =>ben_ecv_shd.g_old_rec.ecv_attribute4
505: ,p_ecv_attribute5_o =>ben_ecv_shd.g_old_rec.ecv_attribute5
498: ,p_business_group_id_o =>ben_ecv_shd.g_old_rec.business_group_id
499: ,p_legislation_code_o =>ben_ecv_shd.g_old_rec.legislation_code
500: ,p_ecv_attribute_category_o =>ben_ecv_shd.g_old_rec.ecv_attribute_category
501: ,p_ecv_attribute1_o =>ben_ecv_shd.g_old_rec.ecv_attribute1
502: ,p_ecv_attribute2_o =>ben_ecv_shd.g_old_rec.ecv_attribute2
503: ,p_ecv_attribute3_o =>ben_ecv_shd.g_old_rec.ecv_attribute3
504: ,p_ecv_attribute4_o =>ben_ecv_shd.g_old_rec.ecv_attribute4
505: ,p_ecv_attribute5_o =>ben_ecv_shd.g_old_rec.ecv_attribute5
506: ,p_ecv_attribute6_o =>ben_ecv_shd.g_old_rec.ecv_attribute6
499: ,p_legislation_code_o =>ben_ecv_shd.g_old_rec.legislation_code
500: ,p_ecv_attribute_category_o =>ben_ecv_shd.g_old_rec.ecv_attribute_category
501: ,p_ecv_attribute1_o =>ben_ecv_shd.g_old_rec.ecv_attribute1
502: ,p_ecv_attribute2_o =>ben_ecv_shd.g_old_rec.ecv_attribute2
503: ,p_ecv_attribute3_o =>ben_ecv_shd.g_old_rec.ecv_attribute3
504: ,p_ecv_attribute4_o =>ben_ecv_shd.g_old_rec.ecv_attribute4
505: ,p_ecv_attribute5_o =>ben_ecv_shd.g_old_rec.ecv_attribute5
506: ,p_ecv_attribute6_o =>ben_ecv_shd.g_old_rec.ecv_attribute6
507: ,p_ecv_attribute7_o =>ben_ecv_shd.g_old_rec.ecv_attribute7
500: ,p_ecv_attribute_category_o =>ben_ecv_shd.g_old_rec.ecv_attribute_category
501: ,p_ecv_attribute1_o =>ben_ecv_shd.g_old_rec.ecv_attribute1
502: ,p_ecv_attribute2_o =>ben_ecv_shd.g_old_rec.ecv_attribute2
503: ,p_ecv_attribute3_o =>ben_ecv_shd.g_old_rec.ecv_attribute3
504: ,p_ecv_attribute4_o =>ben_ecv_shd.g_old_rec.ecv_attribute4
505: ,p_ecv_attribute5_o =>ben_ecv_shd.g_old_rec.ecv_attribute5
506: ,p_ecv_attribute6_o =>ben_ecv_shd.g_old_rec.ecv_attribute6
507: ,p_ecv_attribute7_o =>ben_ecv_shd.g_old_rec.ecv_attribute7
508: ,p_ecv_attribute8_o =>ben_ecv_shd.g_old_rec.ecv_attribute8
501: ,p_ecv_attribute1_o =>ben_ecv_shd.g_old_rec.ecv_attribute1
502: ,p_ecv_attribute2_o =>ben_ecv_shd.g_old_rec.ecv_attribute2
503: ,p_ecv_attribute3_o =>ben_ecv_shd.g_old_rec.ecv_attribute3
504: ,p_ecv_attribute4_o =>ben_ecv_shd.g_old_rec.ecv_attribute4
505: ,p_ecv_attribute5_o =>ben_ecv_shd.g_old_rec.ecv_attribute5
506: ,p_ecv_attribute6_o =>ben_ecv_shd.g_old_rec.ecv_attribute6
507: ,p_ecv_attribute7_o =>ben_ecv_shd.g_old_rec.ecv_attribute7
508: ,p_ecv_attribute8_o =>ben_ecv_shd.g_old_rec.ecv_attribute8
509: ,p_ecv_attribute9_o =>ben_ecv_shd.g_old_rec.ecv_attribute9
502: ,p_ecv_attribute2_o =>ben_ecv_shd.g_old_rec.ecv_attribute2
503: ,p_ecv_attribute3_o =>ben_ecv_shd.g_old_rec.ecv_attribute3
504: ,p_ecv_attribute4_o =>ben_ecv_shd.g_old_rec.ecv_attribute4
505: ,p_ecv_attribute5_o =>ben_ecv_shd.g_old_rec.ecv_attribute5
506: ,p_ecv_attribute6_o =>ben_ecv_shd.g_old_rec.ecv_attribute6
507: ,p_ecv_attribute7_o =>ben_ecv_shd.g_old_rec.ecv_attribute7
508: ,p_ecv_attribute8_o =>ben_ecv_shd.g_old_rec.ecv_attribute8
509: ,p_ecv_attribute9_o =>ben_ecv_shd.g_old_rec.ecv_attribute9
510: ,p_ecv_attribute10_o =>ben_ecv_shd.g_old_rec.ecv_attribute10
503: ,p_ecv_attribute3_o =>ben_ecv_shd.g_old_rec.ecv_attribute3
504: ,p_ecv_attribute4_o =>ben_ecv_shd.g_old_rec.ecv_attribute4
505: ,p_ecv_attribute5_o =>ben_ecv_shd.g_old_rec.ecv_attribute5
506: ,p_ecv_attribute6_o =>ben_ecv_shd.g_old_rec.ecv_attribute6
507: ,p_ecv_attribute7_o =>ben_ecv_shd.g_old_rec.ecv_attribute7
508: ,p_ecv_attribute8_o =>ben_ecv_shd.g_old_rec.ecv_attribute8
509: ,p_ecv_attribute9_o =>ben_ecv_shd.g_old_rec.ecv_attribute9
510: ,p_ecv_attribute10_o =>ben_ecv_shd.g_old_rec.ecv_attribute10
511: ,p_ecv_attribute11_o =>ben_ecv_shd.g_old_rec.ecv_attribute11
504: ,p_ecv_attribute4_o =>ben_ecv_shd.g_old_rec.ecv_attribute4
505: ,p_ecv_attribute5_o =>ben_ecv_shd.g_old_rec.ecv_attribute5
506: ,p_ecv_attribute6_o =>ben_ecv_shd.g_old_rec.ecv_attribute6
507: ,p_ecv_attribute7_o =>ben_ecv_shd.g_old_rec.ecv_attribute7
508: ,p_ecv_attribute8_o =>ben_ecv_shd.g_old_rec.ecv_attribute8
509: ,p_ecv_attribute9_o =>ben_ecv_shd.g_old_rec.ecv_attribute9
510: ,p_ecv_attribute10_o =>ben_ecv_shd.g_old_rec.ecv_attribute10
511: ,p_ecv_attribute11_o =>ben_ecv_shd.g_old_rec.ecv_attribute11
512: ,p_ecv_attribute12_o =>ben_ecv_shd.g_old_rec.ecv_attribute12
505: ,p_ecv_attribute5_o =>ben_ecv_shd.g_old_rec.ecv_attribute5
506: ,p_ecv_attribute6_o =>ben_ecv_shd.g_old_rec.ecv_attribute6
507: ,p_ecv_attribute7_o =>ben_ecv_shd.g_old_rec.ecv_attribute7
508: ,p_ecv_attribute8_o =>ben_ecv_shd.g_old_rec.ecv_attribute8
509: ,p_ecv_attribute9_o =>ben_ecv_shd.g_old_rec.ecv_attribute9
510: ,p_ecv_attribute10_o =>ben_ecv_shd.g_old_rec.ecv_attribute10
511: ,p_ecv_attribute11_o =>ben_ecv_shd.g_old_rec.ecv_attribute11
512: ,p_ecv_attribute12_o =>ben_ecv_shd.g_old_rec.ecv_attribute12
513: ,p_ecv_attribute13_o =>ben_ecv_shd.g_old_rec.ecv_attribute13
506: ,p_ecv_attribute6_o =>ben_ecv_shd.g_old_rec.ecv_attribute6
507: ,p_ecv_attribute7_o =>ben_ecv_shd.g_old_rec.ecv_attribute7
508: ,p_ecv_attribute8_o =>ben_ecv_shd.g_old_rec.ecv_attribute8
509: ,p_ecv_attribute9_o =>ben_ecv_shd.g_old_rec.ecv_attribute9
510: ,p_ecv_attribute10_o =>ben_ecv_shd.g_old_rec.ecv_attribute10
511: ,p_ecv_attribute11_o =>ben_ecv_shd.g_old_rec.ecv_attribute11
512: ,p_ecv_attribute12_o =>ben_ecv_shd.g_old_rec.ecv_attribute12
513: ,p_ecv_attribute13_o =>ben_ecv_shd.g_old_rec.ecv_attribute13
514: ,p_ecv_attribute14_o =>ben_ecv_shd.g_old_rec.ecv_attribute14
507: ,p_ecv_attribute7_o =>ben_ecv_shd.g_old_rec.ecv_attribute7
508: ,p_ecv_attribute8_o =>ben_ecv_shd.g_old_rec.ecv_attribute8
509: ,p_ecv_attribute9_o =>ben_ecv_shd.g_old_rec.ecv_attribute9
510: ,p_ecv_attribute10_o =>ben_ecv_shd.g_old_rec.ecv_attribute10
511: ,p_ecv_attribute11_o =>ben_ecv_shd.g_old_rec.ecv_attribute11
512: ,p_ecv_attribute12_o =>ben_ecv_shd.g_old_rec.ecv_attribute12
513: ,p_ecv_attribute13_o =>ben_ecv_shd.g_old_rec.ecv_attribute13
514: ,p_ecv_attribute14_o =>ben_ecv_shd.g_old_rec.ecv_attribute14
515: ,p_ecv_attribute15_o =>ben_ecv_shd.g_old_rec.ecv_attribute15
508: ,p_ecv_attribute8_o =>ben_ecv_shd.g_old_rec.ecv_attribute8
509: ,p_ecv_attribute9_o =>ben_ecv_shd.g_old_rec.ecv_attribute9
510: ,p_ecv_attribute10_o =>ben_ecv_shd.g_old_rec.ecv_attribute10
511: ,p_ecv_attribute11_o =>ben_ecv_shd.g_old_rec.ecv_attribute11
512: ,p_ecv_attribute12_o =>ben_ecv_shd.g_old_rec.ecv_attribute12
513: ,p_ecv_attribute13_o =>ben_ecv_shd.g_old_rec.ecv_attribute13
514: ,p_ecv_attribute14_o =>ben_ecv_shd.g_old_rec.ecv_attribute14
515: ,p_ecv_attribute15_o =>ben_ecv_shd.g_old_rec.ecv_attribute15
516: ,p_ecv_attribute16_o =>ben_ecv_shd.g_old_rec.ecv_attribute16
509: ,p_ecv_attribute9_o =>ben_ecv_shd.g_old_rec.ecv_attribute9
510: ,p_ecv_attribute10_o =>ben_ecv_shd.g_old_rec.ecv_attribute10
511: ,p_ecv_attribute11_o =>ben_ecv_shd.g_old_rec.ecv_attribute11
512: ,p_ecv_attribute12_o =>ben_ecv_shd.g_old_rec.ecv_attribute12
513: ,p_ecv_attribute13_o =>ben_ecv_shd.g_old_rec.ecv_attribute13
514: ,p_ecv_attribute14_o =>ben_ecv_shd.g_old_rec.ecv_attribute14
515: ,p_ecv_attribute15_o =>ben_ecv_shd.g_old_rec.ecv_attribute15
516: ,p_ecv_attribute16_o =>ben_ecv_shd.g_old_rec.ecv_attribute16
517: ,p_ecv_attribute17_o =>ben_ecv_shd.g_old_rec.ecv_attribute17
510: ,p_ecv_attribute10_o =>ben_ecv_shd.g_old_rec.ecv_attribute10
511: ,p_ecv_attribute11_o =>ben_ecv_shd.g_old_rec.ecv_attribute11
512: ,p_ecv_attribute12_o =>ben_ecv_shd.g_old_rec.ecv_attribute12
513: ,p_ecv_attribute13_o =>ben_ecv_shd.g_old_rec.ecv_attribute13
514: ,p_ecv_attribute14_o =>ben_ecv_shd.g_old_rec.ecv_attribute14
515: ,p_ecv_attribute15_o =>ben_ecv_shd.g_old_rec.ecv_attribute15
516: ,p_ecv_attribute16_o =>ben_ecv_shd.g_old_rec.ecv_attribute16
517: ,p_ecv_attribute17_o =>ben_ecv_shd.g_old_rec.ecv_attribute17
518: ,p_ecv_attribute18_o =>ben_ecv_shd.g_old_rec.ecv_attribute18
511: ,p_ecv_attribute11_o =>ben_ecv_shd.g_old_rec.ecv_attribute11
512: ,p_ecv_attribute12_o =>ben_ecv_shd.g_old_rec.ecv_attribute12
513: ,p_ecv_attribute13_o =>ben_ecv_shd.g_old_rec.ecv_attribute13
514: ,p_ecv_attribute14_o =>ben_ecv_shd.g_old_rec.ecv_attribute14
515: ,p_ecv_attribute15_o =>ben_ecv_shd.g_old_rec.ecv_attribute15
516: ,p_ecv_attribute16_o =>ben_ecv_shd.g_old_rec.ecv_attribute16
517: ,p_ecv_attribute17_o =>ben_ecv_shd.g_old_rec.ecv_attribute17
518: ,p_ecv_attribute18_o =>ben_ecv_shd.g_old_rec.ecv_attribute18
519: ,p_ecv_attribute19_o =>ben_ecv_shd.g_old_rec.ecv_attribute19
512: ,p_ecv_attribute12_o =>ben_ecv_shd.g_old_rec.ecv_attribute12
513: ,p_ecv_attribute13_o =>ben_ecv_shd.g_old_rec.ecv_attribute13
514: ,p_ecv_attribute14_o =>ben_ecv_shd.g_old_rec.ecv_attribute14
515: ,p_ecv_attribute15_o =>ben_ecv_shd.g_old_rec.ecv_attribute15
516: ,p_ecv_attribute16_o =>ben_ecv_shd.g_old_rec.ecv_attribute16
517: ,p_ecv_attribute17_o =>ben_ecv_shd.g_old_rec.ecv_attribute17
518: ,p_ecv_attribute18_o =>ben_ecv_shd.g_old_rec.ecv_attribute18
519: ,p_ecv_attribute19_o =>ben_ecv_shd.g_old_rec.ecv_attribute19
520: ,p_ecv_attribute20_o =>ben_ecv_shd.g_old_rec.ecv_attribute20
513: ,p_ecv_attribute13_o =>ben_ecv_shd.g_old_rec.ecv_attribute13
514: ,p_ecv_attribute14_o =>ben_ecv_shd.g_old_rec.ecv_attribute14
515: ,p_ecv_attribute15_o =>ben_ecv_shd.g_old_rec.ecv_attribute15
516: ,p_ecv_attribute16_o =>ben_ecv_shd.g_old_rec.ecv_attribute16
517: ,p_ecv_attribute17_o =>ben_ecv_shd.g_old_rec.ecv_attribute17
518: ,p_ecv_attribute18_o =>ben_ecv_shd.g_old_rec.ecv_attribute18
519: ,p_ecv_attribute19_o =>ben_ecv_shd.g_old_rec.ecv_attribute19
520: ,p_ecv_attribute20_o =>ben_ecv_shd.g_old_rec.ecv_attribute20
521: ,p_ecv_attribute21_o =>ben_ecv_shd.g_old_rec.ecv_attribute21
514: ,p_ecv_attribute14_o =>ben_ecv_shd.g_old_rec.ecv_attribute14
515: ,p_ecv_attribute15_o =>ben_ecv_shd.g_old_rec.ecv_attribute15
516: ,p_ecv_attribute16_o =>ben_ecv_shd.g_old_rec.ecv_attribute16
517: ,p_ecv_attribute17_o =>ben_ecv_shd.g_old_rec.ecv_attribute17
518: ,p_ecv_attribute18_o =>ben_ecv_shd.g_old_rec.ecv_attribute18
519: ,p_ecv_attribute19_o =>ben_ecv_shd.g_old_rec.ecv_attribute19
520: ,p_ecv_attribute20_o =>ben_ecv_shd.g_old_rec.ecv_attribute20
521: ,p_ecv_attribute21_o =>ben_ecv_shd.g_old_rec.ecv_attribute21
522: ,p_ecv_attribute22_o =>ben_ecv_shd.g_old_rec.ecv_attribute22
515: ,p_ecv_attribute15_o =>ben_ecv_shd.g_old_rec.ecv_attribute15
516: ,p_ecv_attribute16_o =>ben_ecv_shd.g_old_rec.ecv_attribute16
517: ,p_ecv_attribute17_o =>ben_ecv_shd.g_old_rec.ecv_attribute17
518: ,p_ecv_attribute18_o =>ben_ecv_shd.g_old_rec.ecv_attribute18
519: ,p_ecv_attribute19_o =>ben_ecv_shd.g_old_rec.ecv_attribute19
520: ,p_ecv_attribute20_o =>ben_ecv_shd.g_old_rec.ecv_attribute20
521: ,p_ecv_attribute21_o =>ben_ecv_shd.g_old_rec.ecv_attribute21
522: ,p_ecv_attribute22_o =>ben_ecv_shd.g_old_rec.ecv_attribute22
523: ,p_ecv_attribute23_o =>ben_ecv_shd.g_old_rec.ecv_attribute23
516: ,p_ecv_attribute16_o =>ben_ecv_shd.g_old_rec.ecv_attribute16
517: ,p_ecv_attribute17_o =>ben_ecv_shd.g_old_rec.ecv_attribute17
518: ,p_ecv_attribute18_o =>ben_ecv_shd.g_old_rec.ecv_attribute18
519: ,p_ecv_attribute19_o =>ben_ecv_shd.g_old_rec.ecv_attribute19
520: ,p_ecv_attribute20_o =>ben_ecv_shd.g_old_rec.ecv_attribute20
521: ,p_ecv_attribute21_o =>ben_ecv_shd.g_old_rec.ecv_attribute21
522: ,p_ecv_attribute22_o =>ben_ecv_shd.g_old_rec.ecv_attribute22
523: ,p_ecv_attribute23_o =>ben_ecv_shd.g_old_rec.ecv_attribute23
524: ,p_ecv_attribute24_o =>ben_ecv_shd.g_old_rec.ecv_attribute24
517: ,p_ecv_attribute17_o =>ben_ecv_shd.g_old_rec.ecv_attribute17
518: ,p_ecv_attribute18_o =>ben_ecv_shd.g_old_rec.ecv_attribute18
519: ,p_ecv_attribute19_o =>ben_ecv_shd.g_old_rec.ecv_attribute19
520: ,p_ecv_attribute20_o =>ben_ecv_shd.g_old_rec.ecv_attribute20
521: ,p_ecv_attribute21_o =>ben_ecv_shd.g_old_rec.ecv_attribute21
522: ,p_ecv_attribute22_o =>ben_ecv_shd.g_old_rec.ecv_attribute22
523: ,p_ecv_attribute23_o =>ben_ecv_shd.g_old_rec.ecv_attribute23
524: ,p_ecv_attribute24_o =>ben_ecv_shd.g_old_rec.ecv_attribute24
525: ,p_ecv_attribute25_o =>ben_ecv_shd.g_old_rec.ecv_attribute25
518: ,p_ecv_attribute18_o =>ben_ecv_shd.g_old_rec.ecv_attribute18
519: ,p_ecv_attribute19_o =>ben_ecv_shd.g_old_rec.ecv_attribute19
520: ,p_ecv_attribute20_o =>ben_ecv_shd.g_old_rec.ecv_attribute20
521: ,p_ecv_attribute21_o =>ben_ecv_shd.g_old_rec.ecv_attribute21
522: ,p_ecv_attribute22_o =>ben_ecv_shd.g_old_rec.ecv_attribute22
523: ,p_ecv_attribute23_o =>ben_ecv_shd.g_old_rec.ecv_attribute23
524: ,p_ecv_attribute24_o =>ben_ecv_shd.g_old_rec.ecv_attribute24
525: ,p_ecv_attribute25_o =>ben_ecv_shd.g_old_rec.ecv_attribute25
526: ,p_ecv_attribute26_o =>ben_ecv_shd.g_old_rec.ecv_attribute26
519: ,p_ecv_attribute19_o =>ben_ecv_shd.g_old_rec.ecv_attribute19
520: ,p_ecv_attribute20_o =>ben_ecv_shd.g_old_rec.ecv_attribute20
521: ,p_ecv_attribute21_o =>ben_ecv_shd.g_old_rec.ecv_attribute21
522: ,p_ecv_attribute22_o =>ben_ecv_shd.g_old_rec.ecv_attribute22
523: ,p_ecv_attribute23_o =>ben_ecv_shd.g_old_rec.ecv_attribute23
524: ,p_ecv_attribute24_o =>ben_ecv_shd.g_old_rec.ecv_attribute24
525: ,p_ecv_attribute25_o =>ben_ecv_shd.g_old_rec.ecv_attribute25
526: ,p_ecv_attribute26_o =>ben_ecv_shd.g_old_rec.ecv_attribute26
527: ,p_ecv_attribute27_o =>ben_ecv_shd.g_old_rec.ecv_attribute27
520: ,p_ecv_attribute20_o =>ben_ecv_shd.g_old_rec.ecv_attribute20
521: ,p_ecv_attribute21_o =>ben_ecv_shd.g_old_rec.ecv_attribute21
522: ,p_ecv_attribute22_o =>ben_ecv_shd.g_old_rec.ecv_attribute22
523: ,p_ecv_attribute23_o =>ben_ecv_shd.g_old_rec.ecv_attribute23
524: ,p_ecv_attribute24_o =>ben_ecv_shd.g_old_rec.ecv_attribute24
525: ,p_ecv_attribute25_o =>ben_ecv_shd.g_old_rec.ecv_attribute25
526: ,p_ecv_attribute26_o =>ben_ecv_shd.g_old_rec.ecv_attribute26
527: ,p_ecv_attribute27_o =>ben_ecv_shd.g_old_rec.ecv_attribute27
528: ,p_ecv_attribute28_o =>ben_ecv_shd.g_old_rec.ecv_attribute28
521: ,p_ecv_attribute21_o =>ben_ecv_shd.g_old_rec.ecv_attribute21
522: ,p_ecv_attribute22_o =>ben_ecv_shd.g_old_rec.ecv_attribute22
523: ,p_ecv_attribute23_o =>ben_ecv_shd.g_old_rec.ecv_attribute23
524: ,p_ecv_attribute24_o =>ben_ecv_shd.g_old_rec.ecv_attribute24
525: ,p_ecv_attribute25_o =>ben_ecv_shd.g_old_rec.ecv_attribute25
526: ,p_ecv_attribute26_o =>ben_ecv_shd.g_old_rec.ecv_attribute26
527: ,p_ecv_attribute27_o =>ben_ecv_shd.g_old_rec.ecv_attribute27
528: ,p_ecv_attribute28_o =>ben_ecv_shd.g_old_rec.ecv_attribute28
529: ,p_ecv_attribute29_o =>ben_ecv_shd.g_old_rec.ecv_attribute29
522: ,p_ecv_attribute22_o =>ben_ecv_shd.g_old_rec.ecv_attribute22
523: ,p_ecv_attribute23_o =>ben_ecv_shd.g_old_rec.ecv_attribute23
524: ,p_ecv_attribute24_o =>ben_ecv_shd.g_old_rec.ecv_attribute24
525: ,p_ecv_attribute25_o =>ben_ecv_shd.g_old_rec.ecv_attribute25
526: ,p_ecv_attribute26_o =>ben_ecv_shd.g_old_rec.ecv_attribute26
527: ,p_ecv_attribute27_o =>ben_ecv_shd.g_old_rec.ecv_attribute27
528: ,p_ecv_attribute28_o =>ben_ecv_shd.g_old_rec.ecv_attribute28
529: ,p_ecv_attribute29_o =>ben_ecv_shd.g_old_rec.ecv_attribute29
530: ,p_ecv_attribute30_o =>ben_ecv_shd.g_old_rec.ecv_attribute30
523: ,p_ecv_attribute23_o =>ben_ecv_shd.g_old_rec.ecv_attribute23
524: ,p_ecv_attribute24_o =>ben_ecv_shd.g_old_rec.ecv_attribute24
525: ,p_ecv_attribute25_o =>ben_ecv_shd.g_old_rec.ecv_attribute25
526: ,p_ecv_attribute26_o =>ben_ecv_shd.g_old_rec.ecv_attribute26
527: ,p_ecv_attribute27_o =>ben_ecv_shd.g_old_rec.ecv_attribute27
528: ,p_ecv_attribute28_o =>ben_ecv_shd.g_old_rec.ecv_attribute28
529: ,p_ecv_attribute29_o =>ben_ecv_shd.g_old_rec.ecv_attribute29
530: ,p_ecv_attribute30_o =>ben_ecv_shd.g_old_rec.ecv_attribute30
531: ,p_object_version_number_o =>ben_ecv_shd.g_old_rec.object_version_number
524: ,p_ecv_attribute24_o =>ben_ecv_shd.g_old_rec.ecv_attribute24
525: ,p_ecv_attribute25_o =>ben_ecv_shd.g_old_rec.ecv_attribute25
526: ,p_ecv_attribute26_o =>ben_ecv_shd.g_old_rec.ecv_attribute26
527: ,p_ecv_attribute27_o =>ben_ecv_shd.g_old_rec.ecv_attribute27
528: ,p_ecv_attribute28_o =>ben_ecv_shd.g_old_rec.ecv_attribute28
529: ,p_ecv_attribute29_o =>ben_ecv_shd.g_old_rec.ecv_attribute29
530: ,p_ecv_attribute30_o =>ben_ecv_shd.g_old_rec.ecv_attribute30
531: ,p_object_version_number_o =>ben_ecv_shd.g_old_rec.object_version_number
532: ,p_criteria_score_o =>ben_ecv_shd.g_old_rec.criteria_score
525: ,p_ecv_attribute25_o =>ben_ecv_shd.g_old_rec.ecv_attribute25
526: ,p_ecv_attribute26_o =>ben_ecv_shd.g_old_rec.ecv_attribute26
527: ,p_ecv_attribute27_o =>ben_ecv_shd.g_old_rec.ecv_attribute27
528: ,p_ecv_attribute28_o =>ben_ecv_shd.g_old_rec.ecv_attribute28
529: ,p_ecv_attribute29_o =>ben_ecv_shd.g_old_rec.ecv_attribute29
530: ,p_ecv_attribute30_o =>ben_ecv_shd.g_old_rec.ecv_attribute30
531: ,p_object_version_number_o =>ben_ecv_shd.g_old_rec.object_version_number
532: ,p_criteria_score_o =>ben_ecv_shd.g_old_rec.criteria_score
533: ,p_criteria_weight_o =>ben_ecv_shd.g_old_rec.criteria_weight
526: ,p_ecv_attribute26_o =>ben_ecv_shd.g_old_rec.ecv_attribute26
527: ,p_ecv_attribute27_o =>ben_ecv_shd.g_old_rec.ecv_attribute27
528: ,p_ecv_attribute28_o =>ben_ecv_shd.g_old_rec.ecv_attribute28
529: ,p_ecv_attribute29_o =>ben_ecv_shd.g_old_rec.ecv_attribute29
530: ,p_ecv_attribute30_o =>ben_ecv_shd.g_old_rec.ecv_attribute30
531: ,p_object_version_number_o =>ben_ecv_shd.g_old_rec.object_version_number
532: ,p_criteria_score_o =>ben_ecv_shd.g_old_rec.criteria_score
533: ,p_criteria_weight_o =>ben_ecv_shd.g_old_rec.criteria_weight
534: ,p_char_value3_o =>ben_ecv_shd.g_old_rec.char_value3
527: ,p_ecv_attribute27_o =>ben_ecv_shd.g_old_rec.ecv_attribute27
528: ,p_ecv_attribute28_o =>ben_ecv_shd.g_old_rec.ecv_attribute28
529: ,p_ecv_attribute29_o =>ben_ecv_shd.g_old_rec.ecv_attribute29
530: ,p_ecv_attribute30_o =>ben_ecv_shd.g_old_rec.ecv_attribute30
531: ,p_object_version_number_o =>ben_ecv_shd.g_old_rec.object_version_number
532: ,p_criteria_score_o =>ben_ecv_shd.g_old_rec.criteria_score
533: ,p_criteria_weight_o =>ben_ecv_shd.g_old_rec.criteria_weight
534: ,p_char_value3_o =>ben_ecv_shd.g_old_rec.char_value3
535: ,p_char_value4_o =>ben_ecv_shd.g_old_rec.char_value4
528: ,p_ecv_attribute28_o =>ben_ecv_shd.g_old_rec.ecv_attribute28
529: ,p_ecv_attribute29_o =>ben_ecv_shd.g_old_rec.ecv_attribute29
530: ,p_ecv_attribute30_o =>ben_ecv_shd.g_old_rec.ecv_attribute30
531: ,p_object_version_number_o =>ben_ecv_shd.g_old_rec.object_version_number
532: ,p_criteria_score_o =>ben_ecv_shd.g_old_rec.criteria_score
533: ,p_criteria_weight_o =>ben_ecv_shd.g_old_rec.criteria_weight
534: ,p_char_value3_o =>ben_ecv_shd.g_old_rec.char_value3
535: ,p_char_value4_o =>ben_ecv_shd.g_old_rec.char_value4
536: ,p_number_value3_o =>ben_ecv_shd.g_old_rec.number_value3
529: ,p_ecv_attribute29_o =>ben_ecv_shd.g_old_rec.ecv_attribute29
530: ,p_ecv_attribute30_o =>ben_ecv_shd.g_old_rec.ecv_attribute30
531: ,p_object_version_number_o =>ben_ecv_shd.g_old_rec.object_version_number
532: ,p_criteria_score_o =>ben_ecv_shd.g_old_rec.criteria_score
533: ,p_criteria_weight_o =>ben_ecv_shd.g_old_rec.criteria_weight
534: ,p_char_value3_o =>ben_ecv_shd.g_old_rec.char_value3
535: ,p_char_value4_o =>ben_ecv_shd.g_old_rec.char_value4
536: ,p_number_value3_o =>ben_ecv_shd.g_old_rec.number_value3
537: ,p_number_value4_o =>ben_ecv_shd.g_old_rec.number_value4
530: ,p_ecv_attribute30_o =>ben_ecv_shd.g_old_rec.ecv_attribute30
531: ,p_object_version_number_o =>ben_ecv_shd.g_old_rec.object_version_number
532: ,p_criteria_score_o =>ben_ecv_shd.g_old_rec.criteria_score
533: ,p_criteria_weight_o =>ben_ecv_shd.g_old_rec.criteria_weight
534: ,p_char_value3_o =>ben_ecv_shd.g_old_rec.char_value3
535: ,p_char_value4_o =>ben_ecv_shd.g_old_rec.char_value4
536: ,p_number_value3_o =>ben_ecv_shd.g_old_rec.number_value3
537: ,p_number_value4_o =>ben_ecv_shd.g_old_rec.number_value4
538: ,p_date_value3_o =>ben_ecv_shd.g_old_rec.date_value3
531: ,p_object_version_number_o =>ben_ecv_shd.g_old_rec.object_version_number
532: ,p_criteria_score_o =>ben_ecv_shd.g_old_rec.criteria_score
533: ,p_criteria_weight_o =>ben_ecv_shd.g_old_rec.criteria_weight
534: ,p_char_value3_o =>ben_ecv_shd.g_old_rec.char_value3
535: ,p_char_value4_o =>ben_ecv_shd.g_old_rec.char_value4
536: ,p_number_value3_o =>ben_ecv_shd.g_old_rec.number_value3
537: ,p_number_value4_o =>ben_ecv_shd.g_old_rec.number_value4
538: ,p_date_value3_o =>ben_ecv_shd.g_old_rec.date_value3
539: ,p_date_value4_o =>ben_ecv_shd.g_old_rec.date_value4
532: ,p_criteria_score_o =>ben_ecv_shd.g_old_rec.criteria_score
533: ,p_criteria_weight_o =>ben_ecv_shd.g_old_rec.criteria_weight
534: ,p_char_value3_o =>ben_ecv_shd.g_old_rec.char_value3
535: ,p_char_value4_o =>ben_ecv_shd.g_old_rec.char_value4
536: ,p_number_value3_o =>ben_ecv_shd.g_old_rec.number_value3
537: ,p_number_value4_o =>ben_ecv_shd.g_old_rec.number_value4
538: ,p_date_value3_o =>ben_ecv_shd.g_old_rec.date_value3
539: ,p_date_value4_o =>ben_ecv_shd.g_old_rec.date_value4
540: );
533: ,p_criteria_weight_o =>ben_ecv_shd.g_old_rec.criteria_weight
534: ,p_char_value3_o =>ben_ecv_shd.g_old_rec.char_value3
535: ,p_char_value4_o =>ben_ecv_shd.g_old_rec.char_value4
536: ,p_number_value3_o =>ben_ecv_shd.g_old_rec.number_value3
537: ,p_number_value4_o =>ben_ecv_shd.g_old_rec.number_value4
538: ,p_date_value3_o =>ben_ecv_shd.g_old_rec.date_value3
539: ,p_date_value4_o =>ben_ecv_shd.g_old_rec.date_value4
540: );
541: --
534: ,p_char_value3_o =>ben_ecv_shd.g_old_rec.char_value3
535: ,p_char_value4_o =>ben_ecv_shd.g_old_rec.char_value4
536: ,p_number_value3_o =>ben_ecv_shd.g_old_rec.number_value3
537: ,p_number_value4_o =>ben_ecv_shd.g_old_rec.number_value4
538: ,p_date_value3_o =>ben_ecv_shd.g_old_rec.date_value3
539: ,p_date_value4_o =>ben_ecv_shd.g_old_rec.date_value4
540: );
541: --
542: exception
535: ,p_char_value4_o =>ben_ecv_shd.g_old_rec.char_value4
536: ,p_number_value3_o =>ben_ecv_shd.g_old_rec.number_value3
537: ,p_number_value4_o =>ben_ecv_shd.g_old_rec.number_value4
538: ,p_date_value3_o =>ben_ecv_shd.g_old_rec.date_value3
539: ,p_date_value4_o =>ben_ecv_shd.g_old_rec.date_value4
540: );
541: --
542: exception
543: --
598: -- Internal Row Handler Use Only.
599: --
600: -- {End Of Comments}
601: -- ----------------------------------------------------------------------------
602: Procedure convert_defs(p_rec in out nocopy ben_ecv_shd.g_rec_type) is
603: --
604: l_proc varchar2(72) := g_package||'convert_defs';
605: --
606: Begin
612: -- to see if a system default is being used. If a system default
613: -- is being used then we must set to the 'current' argument value.
614: --
615: If (p_rec.eligy_prfl_id = hr_api.g_number) then
616: p_rec.eligy_prfl_id := ben_ecv_shd.g_old_rec.eligy_prfl_id;
617: end if;
618: If (p_rec.eligy_criteria_id = hr_api.g_number) then
619: p_rec.eligy_criteria_id := ben_ecv_shd.g_old_rec.eligy_criteria_id;
620: end if;
615: If (p_rec.eligy_prfl_id = hr_api.g_number) then
616: p_rec.eligy_prfl_id := ben_ecv_shd.g_old_rec.eligy_prfl_id;
617: end if;
618: If (p_rec.eligy_criteria_id = hr_api.g_number) then
619: p_rec.eligy_criteria_id := ben_ecv_shd.g_old_rec.eligy_criteria_id;
620: end if;
621: If (p_rec.number_value1 = hr_api.g_number) then
622: p_rec.number_value1 := ben_ecv_shd.g_old_rec.number_value1;
623: end if;
618: If (p_rec.eligy_criteria_id = hr_api.g_number) then
619: p_rec.eligy_criteria_id := ben_ecv_shd.g_old_rec.eligy_criteria_id;
620: end if;
621: If (p_rec.number_value1 = hr_api.g_number) then
622: p_rec.number_value1 := ben_ecv_shd.g_old_rec.number_value1;
623: end if;
624: If (p_rec.number_value2 = hr_api.g_number) then
625: p_rec.number_value2 := ben_ecv_shd.g_old_rec.number_value2;
626: end if;
621: If (p_rec.number_value1 = hr_api.g_number) then
622: p_rec.number_value1 := ben_ecv_shd.g_old_rec.number_value1;
623: end if;
624: If (p_rec.number_value2 = hr_api.g_number) then
625: p_rec.number_value2 := ben_ecv_shd.g_old_rec.number_value2;
626: end if;
627: If (p_rec.char_value1 = hr_api.g_varchar2) then
628: p_rec.char_value1 := ben_ecv_shd.g_old_rec.char_value1;
629: end if;
624: If (p_rec.number_value2 = hr_api.g_number) then
625: p_rec.number_value2 := ben_ecv_shd.g_old_rec.number_value2;
626: end if;
627: If (p_rec.char_value1 = hr_api.g_varchar2) then
628: p_rec.char_value1 := ben_ecv_shd.g_old_rec.char_value1;
629: end if;
630: If (p_rec.char_value2 = hr_api.g_varchar2) then
631: p_rec.char_value2 := ben_ecv_shd.g_old_rec.char_value2;
632: end if;
627: If (p_rec.char_value1 = hr_api.g_varchar2) then
628: p_rec.char_value1 := ben_ecv_shd.g_old_rec.char_value1;
629: end if;
630: If (p_rec.char_value2 = hr_api.g_varchar2) then
631: p_rec.char_value2 := ben_ecv_shd.g_old_rec.char_value2;
632: end if;
633: If (p_rec.date_value1 = hr_api.g_date) then
634: p_rec.date_value1 := ben_ecv_shd.g_old_rec.date_value1;
635: end if;
630: If (p_rec.char_value2 = hr_api.g_varchar2) then
631: p_rec.char_value2 := ben_ecv_shd.g_old_rec.char_value2;
632: end if;
633: If (p_rec.date_value1 = hr_api.g_date) then
634: p_rec.date_value1 := ben_ecv_shd.g_old_rec.date_value1;
635: end if;
636: If (p_rec.date_value2 = hr_api.g_date) then
637: p_rec.date_value2 := ben_ecv_shd.g_old_rec.date_value2;
638: end if;
633: If (p_rec.date_value1 = hr_api.g_date) then
634: p_rec.date_value1 := ben_ecv_shd.g_old_rec.date_value1;
635: end if;
636: If (p_rec.date_value2 = hr_api.g_date) then
637: p_rec.date_value2 := ben_ecv_shd.g_old_rec.date_value2;
638: end if;
639: If (p_rec.excld_flag = hr_api.g_varchar2) then
640: p_rec.excld_flag := ben_ecv_shd.g_old_rec.excld_flag;
641: end if;
636: If (p_rec.date_value2 = hr_api.g_date) then
637: p_rec.date_value2 := ben_ecv_shd.g_old_rec.date_value2;
638: end if;
639: If (p_rec.excld_flag = hr_api.g_varchar2) then
640: p_rec.excld_flag := ben_ecv_shd.g_old_rec.excld_flag;
641: end if;
642: If (p_rec.business_group_id = hr_api.g_number) then
643: p_rec.business_group_id := ben_ecv_shd.g_old_rec.business_group_id;
644: end if;
639: If (p_rec.excld_flag = hr_api.g_varchar2) then
640: p_rec.excld_flag := ben_ecv_shd.g_old_rec.excld_flag;
641: end if;
642: If (p_rec.business_group_id = hr_api.g_number) then
643: p_rec.business_group_id := ben_ecv_shd.g_old_rec.business_group_id;
644: end if;
645: If (p_rec.legislation_code = hr_api.g_varchar2) then
646: p_rec.legislation_code := ben_ecv_shd.g_old_rec.legislation_code;
647: end if;
642: If (p_rec.business_group_id = hr_api.g_number) then
643: p_rec.business_group_id := ben_ecv_shd.g_old_rec.business_group_id;
644: end if;
645: If (p_rec.legislation_code = hr_api.g_varchar2) then
646: p_rec.legislation_code := ben_ecv_shd.g_old_rec.legislation_code;
647: end if;
648: If (p_rec.ecv_attribute_category = hr_api.g_varchar2) then
649: p_rec.ecv_attribute_category := ben_ecv_shd.g_old_rec.ecv_attribute_category;
650: end if;
645: If (p_rec.legislation_code = hr_api.g_varchar2) then
646: p_rec.legislation_code := ben_ecv_shd.g_old_rec.legislation_code;
647: end if;
648: If (p_rec.ecv_attribute_category = hr_api.g_varchar2) then
649: p_rec.ecv_attribute_category := ben_ecv_shd.g_old_rec.ecv_attribute_category;
650: end if;
651: If (p_rec.ecv_attribute1 = hr_api.g_varchar2) then
652: p_rec.ecv_attribute1 := ben_ecv_shd.g_old_rec.ecv_attribute1;
653: end if;
648: If (p_rec.ecv_attribute_category = hr_api.g_varchar2) then
649: p_rec.ecv_attribute_category := ben_ecv_shd.g_old_rec.ecv_attribute_category;
650: end if;
651: If (p_rec.ecv_attribute1 = hr_api.g_varchar2) then
652: p_rec.ecv_attribute1 := ben_ecv_shd.g_old_rec.ecv_attribute1;
653: end if;
654: If (p_rec.ecv_attribute2 = hr_api.g_varchar2) then
655: p_rec.ecv_attribute2 := ben_ecv_shd.g_old_rec.ecv_attribute2;
656: end if;
651: If (p_rec.ecv_attribute1 = hr_api.g_varchar2) then
652: p_rec.ecv_attribute1 := ben_ecv_shd.g_old_rec.ecv_attribute1;
653: end if;
654: If (p_rec.ecv_attribute2 = hr_api.g_varchar2) then
655: p_rec.ecv_attribute2 := ben_ecv_shd.g_old_rec.ecv_attribute2;
656: end if;
657: If (p_rec.ecv_attribute3 = hr_api.g_varchar2) then
658: p_rec.ecv_attribute3 := ben_ecv_shd.g_old_rec.ecv_attribute3;
659: end if;
654: If (p_rec.ecv_attribute2 = hr_api.g_varchar2) then
655: p_rec.ecv_attribute2 := ben_ecv_shd.g_old_rec.ecv_attribute2;
656: end if;
657: If (p_rec.ecv_attribute3 = hr_api.g_varchar2) then
658: p_rec.ecv_attribute3 := ben_ecv_shd.g_old_rec.ecv_attribute3;
659: end if;
660: If (p_rec.ecv_attribute4 = hr_api.g_varchar2) then
661: p_rec.ecv_attribute4 := ben_ecv_shd.g_old_rec.ecv_attribute4;
662: end if;
657: If (p_rec.ecv_attribute3 = hr_api.g_varchar2) then
658: p_rec.ecv_attribute3 := ben_ecv_shd.g_old_rec.ecv_attribute3;
659: end if;
660: If (p_rec.ecv_attribute4 = hr_api.g_varchar2) then
661: p_rec.ecv_attribute4 := ben_ecv_shd.g_old_rec.ecv_attribute4;
662: end if;
663: If (p_rec.ecv_attribute5 = hr_api.g_varchar2) then
664: p_rec.ecv_attribute5 := ben_ecv_shd.g_old_rec.ecv_attribute5;
665: end if;
660: If (p_rec.ecv_attribute4 = hr_api.g_varchar2) then
661: p_rec.ecv_attribute4 := ben_ecv_shd.g_old_rec.ecv_attribute4;
662: end if;
663: If (p_rec.ecv_attribute5 = hr_api.g_varchar2) then
664: p_rec.ecv_attribute5 := ben_ecv_shd.g_old_rec.ecv_attribute5;
665: end if;
666: If (p_rec.ecv_attribute6 = hr_api.g_varchar2) then
667: p_rec.ecv_attribute6 := ben_ecv_shd.g_old_rec.ecv_attribute6;
668: end if;
663: If (p_rec.ecv_attribute5 = hr_api.g_varchar2) then
664: p_rec.ecv_attribute5 := ben_ecv_shd.g_old_rec.ecv_attribute5;
665: end if;
666: If (p_rec.ecv_attribute6 = hr_api.g_varchar2) then
667: p_rec.ecv_attribute6 := ben_ecv_shd.g_old_rec.ecv_attribute6;
668: end if;
669: If (p_rec.ecv_attribute7 = hr_api.g_varchar2) then
670: p_rec.ecv_attribute7 := ben_ecv_shd.g_old_rec.ecv_attribute7;
671: end if;
666: If (p_rec.ecv_attribute6 = hr_api.g_varchar2) then
667: p_rec.ecv_attribute6 := ben_ecv_shd.g_old_rec.ecv_attribute6;
668: end if;
669: If (p_rec.ecv_attribute7 = hr_api.g_varchar2) then
670: p_rec.ecv_attribute7 := ben_ecv_shd.g_old_rec.ecv_attribute7;
671: end if;
672: If (p_rec.ecv_attribute8 = hr_api.g_varchar2) then
673: p_rec.ecv_attribute8 := ben_ecv_shd.g_old_rec.ecv_attribute8;
674: end if;
669: If (p_rec.ecv_attribute7 = hr_api.g_varchar2) then
670: p_rec.ecv_attribute7 := ben_ecv_shd.g_old_rec.ecv_attribute7;
671: end if;
672: If (p_rec.ecv_attribute8 = hr_api.g_varchar2) then
673: p_rec.ecv_attribute8 := ben_ecv_shd.g_old_rec.ecv_attribute8;
674: end if;
675: If (p_rec.ecv_attribute9 = hr_api.g_varchar2) then
676: p_rec.ecv_attribute9 := ben_ecv_shd.g_old_rec.ecv_attribute9;
677: end if;
672: If (p_rec.ecv_attribute8 = hr_api.g_varchar2) then
673: p_rec.ecv_attribute8 := ben_ecv_shd.g_old_rec.ecv_attribute8;
674: end if;
675: If (p_rec.ecv_attribute9 = hr_api.g_varchar2) then
676: p_rec.ecv_attribute9 := ben_ecv_shd.g_old_rec.ecv_attribute9;
677: end if;
678: If (p_rec.ecv_attribute10 = hr_api.g_varchar2) then
679: p_rec.ecv_attribute10 := ben_ecv_shd.g_old_rec.ecv_attribute10;
680: end if;
675: If (p_rec.ecv_attribute9 = hr_api.g_varchar2) then
676: p_rec.ecv_attribute9 := ben_ecv_shd.g_old_rec.ecv_attribute9;
677: end if;
678: If (p_rec.ecv_attribute10 = hr_api.g_varchar2) then
679: p_rec.ecv_attribute10 := ben_ecv_shd.g_old_rec.ecv_attribute10;
680: end if;
681: If (p_rec.ecv_attribute11 = hr_api.g_varchar2) then
682: p_rec.ecv_attribute11 := ben_ecv_shd.g_old_rec.ecv_attribute11;
683: end if;
678: If (p_rec.ecv_attribute10 = hr_api.g_varchar2) then
679: p_rec.ecv_attribute10 := ben_ecv_shd.g_old_rec.ecv_attribute10;
680: end if;
681: If (p_rec.ecv_attribute11 = hr_api.g_varchar2) then
682: p_rec.ecv_attribute11 := ben_ecv_shd.g_old_rec.ecv_attribute11;
683: end if;
684: If (p_rec.ecv_attribute12 = hr_api.g_varchar2) then
685: p_rec.ecv_attribute12 := ben_ecv_shd.g_old_rec.ecv_attribute12;
686: end if;
681: If (p_rec.ecv_attribute11 = hr_api.g_varchar2) then
682: p_rec.ecv_attribute11 := ben_ecv_shd.g_old_rec.ecv_attribute11;
683: end if;
684: If (p_rec.ecv_attribute12 = hr_api.g_varchar2) then
685: p_rec.ecv_attribute12 := ben_ecv_shd.g_old_rec.ecv_attribute12;
686: end if;
687: If (p_rec.ecv_attribute13 = hr_api.g_varchar2) then
688: p_rec.ecv_attribute13 := ben_ecv_shd.g_old_rec.ecv_attribute13;
689: end if;
684: If (p_rec.ecv_attribute12 = hr_api.g_varchar2) then
685: p_rec.ecv_attribute12 := ben_ecv_shd.g_old_rec.ecv_attribute12;
686: end if;
687: If (p_rec.ecv_attribute13 = hr_api.g_varchar2) then
688: p_rec.ecv_attribute13 := ben_ecv_shd.g_old_rec.ecv_attribute13;
689: end if;
690: If (p_rec.ecv_attribute14 = hr_api.g_varchar2) then
691: p_rec.ecv_attribute14 := ben_ecv_shd.g_old_rec.ecv_attribute14;
692: end if;
687: If (p_rec.ecv_attribute13 = hr_api.g_varchar2) then
688: p_rec.ecv_attribute13 := ben_ecv_shd.g_old_rec.ecv_attribute13;
689: end if;
690: If (p_rec.ecv_attribute14 = hr_api.g_varchar2) then
691: p_rec.ecv_attribute14 := ben_ecv_shd.g_old_rec.ecv_attribute14;
692: end if;
693: If (p_rec.ecv_attribute15 = hr_api.g_varchar2) then
694: p_rec.ecv_attribute15 := ben_ecv_shd.g_old_rec.ecv_attribute15;
695: end if;
690: If (p_rec.ecv_attribute14 = hr_api.g_varchar2) then
691: p_rec.ecv_attribute14 := ben_ecv_shd.g_old_rec.ecv_attribute14;
692: end if;
693: If (p_rec.ecv_attribute15 = hr_api.g_varchar2) then
694: p_rec.ecv_attribute15 := ben_ecv_shd.g_old_rec.ecv_attribute15;
695: end if;
696: If (p_rec.ecv_attribute16 = hr_api.g_varchar2) then
697: p_rec.ecv_attribute16 := ben_ecv_shd.g_old_rec.ecv_attribute16;
698: end if;
693: If (p_rec.ecv_attribute15 = hr_api.g_varchar2) then
694: p_rec.ecv_attribute15 := ben_ecv_shd.g_old_rec.ecv_attribute15;
695: end if;
696: If (p_rec.ecv_attribute16 = hr_api.g_varchar2) then
697: p_rec.ecv_attribute16 := ben_ecv_shd.g_old_rec.ecv_attribute16;
698: end if;
699: If (p_rec.ecv_attribute17 = hr_api.g_varchar2) then
700: p_rec.ecv_attribute17 := ben_ecv_shd.g_old_rec.ecv_attribute17;
701: end if;
696: If (p_rec.ecv_attribute16 = hr_api.g_varchar2) then
697: p_rec.ecv_attribute16 := ben_ecv_shd.g_old_rec.ecv_attribute16;
698: end if;
699: If (p_rec.ecv_attribute17 = hr_api.g_varchar2) then
700: p_rec.ecv_attribute17 := ben_ecv_shd.g_old_rec.ecv_attribute17;
701: end if;
702: If (p_rec.ecv_attribute18 = hr_api.g_varchar2) then
703: p_rec.ecv_attribute18 := ben_ecv_shd.g_old_rec.ecv_attribute18;
704: end if;
699: If (p_rec.ecv_attribute17 = hr_api.g_varchar2) then
700: p_rec.ecv_attribute17 := ben_ecv_shd.g_old_rec.ecv_attribute17;
701: end if;
702: If (p_rec.ecv_attribute18 = hr_api.g_varchar2) then
703: p_rec.ecv_attribute18 := ben_ecv_shd.g_old_rec.ecv_attribute18;
704: end if;
705: If (p_rec.ecv_attribute19 = hr_api.g_varchar2) then
706: p_rec.ecv_attribute19 := ben_ecv_shd.g_old_rec.ecv_attribute19;
707: end if;
702: If (p_rec.ecv_attribute18 = hr_api.g_varchar2) then
703: p_rec.ecv_attribute18 := ben_ecv_shd.g_old_rec.ecv_attribute18;
704: end if;
705: If (p_rec.ecv_attribute19 = hr_api.g_varchar2) then
706: p_rec.ecv_attribute19 := ben_ecv_shd.g_old_rec.ecv_attribute19;
707: end if;
708: If (p_rec.ecv_attribute20 = hr_api.g_varchar2) then
709: p_rec.ecv_attribute20 := ben_ecv_shd.g_old_rec.ecv_attribute20;
710: end if;
705: If (p_rec.ecv_attribute19 = hr_api.g_varchar2) then
706: p_rec.ecv_attribute19 := ben_ecv_shd.g_old_rec.ecv_attribute19;
707: end if;
708: If (p_rec.ecv_attribute20 = hr_api.g_varchar2) then
709: p_rec.ecv_attribute20 := ben_ecv_shd.g_old_rec.ecv_attribute20;
710: end if;
711: If (p_rec.ecv_attribute21 = hr_api.g_varchar2) then
712: p_rec.ecv_attribute21 := ben_ecv_shd.g_old_rec.ecv_attribute21;
713: end if;
708: If (p_rec.ecv_attribute20 = hr_api.g_varchar2) then
709: p_rec.ecv_attribute20 := ben_ecv_shd.g_old_rec.ecv_attribute20;
710: end if;
711: If (p_rec.ecv_attribute21 = hr_api.g_varchar2) then
712: p_rec.ecv_attribute21 := ben_ecv_shd.g_old_rec.ecv_attribute21;
713: end if;
714: If (p_rec.ecv_attribute22 = hr_api.g_varchar2) then
715: p_rec.ecv_attribute22 := ben_ecv_shd.g_old_rec.ecv_attribute22;
716: end if;
711: If (p_rec.ecv_attribute21 = hr_api.g_varchar2) then
712: p_rec.ecv_attribute21 := ben_ecv_shd.g_old_rec.ecv_attribute21;
713: end if;
714: If (p_rec.ecv_attribute22 = hr_api.g_varchar2) then
715: p_rec.ecv_attribute22 := ben_ecv_shd.g_old_rec.ecv_attribute22;
716: end if;
717: If (p_rec.ecv_attribute23 = hr_api.g_varchar2) then
718: p_rec.ecv_attribute23 := ben_ecv_shd.g_old_rec.ecv_attribute23;
719: end if;
714: If (p_rec.ecv_attribute22 = hr_api.g_varchar2) then
715: p_rec.ecv_attribute22 := ben_ecv_shd.g_old_rec.ecv_attribute22;
716: end if;
717: If (p_rec.ecv_attribute23 = hr_api.g_varchar2) then
718: p_rec.ecv_attribute23 := ben_ecv_shd.g_old_rec.ecv_attribute23;
719: end if;
720: If (p_rec.ecv_attribute24 = hr_api.g_varchar2) then
721: p_rec.ecv_attribute24 := ben_ecv_shd.g_old_rec.ecv_attribute24;
722: end if;
717: If (p_rec.ecv_attribute23 = hr_api.g_varchar2) then
718: p_rec.ecv_attribute23 := ben_ecv_shd.g_old_rec.ecv_attribute23;
719: end if;
720: If (p_rec.ecv_attribute24 = hr_api.g_varchar2) then
721: p_rec.ecv_attribute24 := ben_ecv_shd.g_old_rec.ecv_attribute24;
722: end if;
723: If (p_rec.ecv_attribute25 = hr_api.g_varchar2) then
724: p_rec.ecv_attribute25 := ben_ecv_shd.g_old_rec.ecv_attribute25;
725: end if;
720: If (p_rec.ecv_attribute24 = hr_api.g_varchar2) then
721: p_rec.ecv_attribute24 := ben_ecv_shd.g_old_rec.ecv_attribute24;
722: end if;
723: If (p_rec.ecv_attribute25 = hr_api.g_varchar2) then
724: p_rec.ecv_attribute25 := ben_ecv_shd.g_old_rec.ecv_attribute25;
725: end if;
726: If (p_rec.ecv_attribute26 = hr_api.g_varchar2) then
727: p_rec.ecv_attribute26 := ben_ecv_shd.g_old_rec.ecv_attribute26;
728: end if;
723: If (p_rec.ecv_attribute25 = hr_api.g_varchar2) then
724: p_rec.ecv_attribute25 := ben_ecv_shd.g_old_rec.ecv_attribute25;
725: end if;
726: If (p_rec.ecv_attribute26 = hr_api.g_varchar2) then
727: p_rec.ecv_attribute26 := ben_ecv_shd.g_old_rec.ecv_attribute26;
728: end if;
729: If (p_rec.ecv_attribute27 = hr_api.g_varchar2) then
730: p_rec.ecv_attribute27 := ben_ecv_shd.g_old_rec.ecv_attribute27;
731: end if;
726: If (p_rec.ecv_attribute26 = hr_api.g_varchar2) then
727: p_rec.ecv_attribute26 := ben_ecv_shd.g_old_rec.ecv_attribute26;
728: end if;
729: If (p_rec.ecv_attribute27 = hr_api.g_varchar2) then
730: p_rec.ecv_attribute27 := ben_ecv_shd.g_old_rec.ecv_attribute27;
731: end if;
732: If (p_rec.ecv_attribute28 = hr_api.g_varchar2) then
733: p_rec.ecv_attribute28 := ben_ecv_shd.g_old_rec.ecv_attribute28;
734: end if;
729: If (p_rec.ecv_attribute27 = hr_api.g_varchar2) then
730: p_rec.ecv_attribute27 := ben_ecv_shd.g_old_rec.ecv_attribute27;
731: end if;
732: If (p_rec.ecv_attribute28 = hr_api.g_varchar2) then
733: p_rec.ecv_attribute28 := ben_ecv_shd.g_old_rec.ecv_attribute28;
734: end if;
735: If (p_rec.ecv_attribute29 = hr_api.g_varchar2) then
736: p_rec.ecv_attribute29 := ben_ecv_shd.g_old_rec.ecv_attribute29;
737: end if;
732: If (p_rec.ecv_attribute28 = hr_api.g_varchar2) then
733: p_rec.ecv_attribute28 := ben_ecv_shd.g_old_rec.ecv_attribute28;
734: end if;
735: If (p_rec.ecv_attribute29 = hr_api.g_varchar2) then
736: p_rec.ecv_attribute29 := ben_ecv_shd.g_old_rec.ecv_attribute29;
737: end if;
738: If (p_rec.ecv_attribute30 = hr_api.g_varchar2) then
739: p_rec.ecv_attribute30 := ben_ecv_shd.g_old_rec.ecv_attribute30;
740: end if;
735: If (p_rec.ecv_attribute29 = hr_api.g_varchar2) then
736: p_rec.ecv_attribute29 := ben_ecv_shd.g_old_rec.ecv_attribute29;
737: end if;
738: If (p_rec.ecv_attribute30 = hr_api.g_varchar2) then
739: p_rec.ecv_attribute30 := ben_ecv_shd.g_old_rec.ecv_attribute30;
740: end if;
741: If (p_rec.criteria_score = hr_api.g_number) then
742: p_rec.criteria_score := ben_ecv_shd.g_old_rec.criteria_score;
743: end if;
738: If (p_rec.ecv_attribute30 = hr_api.g_varchar2) then
739: p_rec.ecv_attribute30 := ben_ecv_shd.g_old_rec.ecv_attribute30;
740: end if;
741: If (p_rec.criteria_score = hr_api.g_number) then
742: p_rec.criteria_score := ben_ecv_shd.g_old_rec.criteria_score;
743: end if;
744: If (p_rec.criteria_weight = hr_api.g_number) then
745: p_rec.criteria_weight := ben_ecv_shd.g_old_rec.criteria_weight;
746: end if;
741: If (p_rec.criteria_score = hr_api.g_number) then
742: p_rec.criteria_score := ben_ecv_shd.g_old_rec.criteria_score;
743: end if;
744: If (p_rec.criteria_weight = hr_api.g_number) then
745: p_rec.criteria_weight := ben_ecv_shd.g_old_rec.criteria_weight;
746: end if;
747: If (p_rec.Char_value3 = hr_api.g_varchar2) then
748: p_rec.Char_value3 := ben_ecv_shd.g_old_rec.Char_value3;
749: end if;
744: If (p_rec.criteria_weight = hr_api.g_number) then
745: p_rec.criteria_weight := ben_ecv_shd.g_old_rec.criteria_weight;
746: end if;
747: If (p_rec.Char_value3 = hr_api.g_varchar2) then
748: p_rec.Char_value3 := ben_ecv_shd.g_old_rec.Char_value3;
749: end if;
750: If (p_rec.Char_value4 = hr_api.g_varchar2) then
751: p_rec.Char_value4 := ben_ecv_shd.g_old_rec.Char_value4;
752: end if;
747: If (p_rec.Char_value3 = hr_api.g_varchar2) then
748: p_rec.Char_value3 := ben_ecv_shd.g_old_rec.Char_value3;
749: end if;
750: If (p_rec.Char_value4 = hr_api.g_varchar2) then
751: p_rec.Char_value4 := ben_ecv_shd.g_old_rec.Char_value4;
752: end if;
753: If (p_rec.Number_value3 = hr_api.g_number) then
754: p_rec.Number_value3 := ben_ecv_shd.g_old_rec.Number_value3;
755: end if;
750: If (p_rec.Char_value4 = hr_api.g_varchar2) then
751: p_rec.Char_value4 := ben_ecv_shd.g_old_rec.Char_value4;
752: end if;
753: If (p_rec.Number_value3 = hr_api.g_number) then
754: p_rec.Number_value3 := ben_ecv_shd.g_old_rec.Number_value3;
755: end if;
756: If (p_rec.Number_value4 = hr_api.g_number) then
757: p_rec.Number_value4 := ben_ecv_shd.g_old_rec.Number_value4;
758: end if;
753: If (p_rec.Number_value3 = hr_api.g_number) then
754: p_rec.Number_value3 := ben_ecv_shd.g_old_rec.Number_value3;
755: end if;
756: If (p_rec.Number_value4 = hr_api.g_number) then
757: p_rec.Number_value4 := ben_ecv_shd.g_old_rec.Number_value4;
758: end if;
759: If (p_rec.Date_value3 = hr_api.g_date) then
760: p_rec.Date_value3 := ben_ecv_shd.g_old_rec.Date_value3;
761: end if;
756: If (p_rec.Number_value4 = hr_api.g_number) then
757: p_rec.Number_value4 := ben_ecv_shd.g_old_rec.Number_value4;
758: end if;
759: If (p_rec.Date_value3 = hr_api.g_date) then
760: p_rec.Date_value3 := ben_ecv_shd.g_old_rec.Date_value3;
761: end if;
762: If (p_rec.Date_value4 = hr_api.g_date) then
763: p_rec.Date_value4 := ben_ecv_shd.g_old_rec.Date_value4;
764: end if;
759: If (p_rec.Date_value3 = hr_api.g_date) then
760: p_rec.Date_value3 := ben_ecv_shd.g_old_rec.Date_value3;
761: end if;
762: If (p_rec.Date_value4 = hr_api.g_date) then
763: p_rec.Date_value4 := ben_ecv_shd.g_old_rec.Date_value4;
764: end if;
765:
766: --
767: hr_utility.set_location(' Leaving:'||l_proc, 10);
772: -- |---------------------------------< upd >----------------------------------|
773: -- ----------------------------------------------------------------------------
774: Procedure upd
775: (
776: p_rec in out nocopy ben_ecv_shd.g_rec_type,
777: p_effective_date in date,
778: p_datetrack_mode in varchar2
779: ) is
780: --
790: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
791: --
792: -- We must lock the row which we need to update.
793: --
794: ben_ecv_shd.lck
795: (p_effective_date => p_effective_date,
796: p_datetrack_mode => p_datetrack_mode,
797: p_eligy_crit_values_id => p_rec.eligy_crit_values_id,
798: p_object_version_number => p_rec.object_version_number,
904: ,p_Date_value3 In Date default hr_api.g_date
905: ,p_Date_value4 In Date default hr_api.g_date
906: ) is
907: --
908: l_rec ben_ecv_shd.g_rec_type;
909: l_proc varchar2(72) := g_package||'upd';
910: --
911: Begin
912: hr_utility.set_location('Entering:'||l_proc, 5);
914: -- Call conversion function to turn arguments into the
915: -- l_rec structure.
916: --
917: l_rec :=
918: ben_ecv_shd.convert_args
919: (
920: p_eligy_crit_values_id,
921: p_eligy_prfl_id,
922: p_eligy_criteria_id,