54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: Procedure dt_update_dml
58: (p_rec in out nocopy ben_dpnt_edc_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_dpnt_eligy_crit_values_f',
78: p_base_key_column => 'dpnt_eligy_crit_values_id',
79: p_base_key_value => p_rec.dpnt_eligy_crit_values_id);
80: --
81: ben_dpnt_edc_shd.g_api_dml := true; -- Set the api dml status
82: --
83: -- Update the ben_eligy_crit_vlaues_f Row
84: --
85: update ben_dpnt_eligy_crit_values_f
139: where dpnt_eligy_crit_values_id = p_rec.dpnt_eligy_crit_values_id
140: and effective_start_date = p_validation_start_date
141: and effective_end_date = p_validation_end_date;
142: --
143: ben_dpnt_edc_shd.g_api_dml := false; --unset the api dml status
144: --
145: --
146: -- Set the effective start and end dates
147: --
152: hr_utility.set_location(' Leaving:'||l_proc, 15);
153: Exception
154: When hr_api.check_integrity_violated Then
155: -- A check constraint has been violated
156: ben_dpnt_edc_shd.g_api_dml := false; --unset the api dml status
157: ben_dpnt_edc_shd.constraint_error
158: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
159: When hr_api.unique_integrity_violated Then
160: -- Unique integrity has been violated
153: Exception
154: When hr_api.check_integrity_violated Then
155: -- A check constraint has been violated
156: ben_dpnt_edc_shd.g_api_dml := false; --unset the api dml status
157: ben_dpnt_edc_shd.constraint_error
158: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
159: When hr_api.unique_integrity_violated Then
160: -- Unique integrity has been violated
161: ben_dpnt_edc_shd.g_api_dml := false; -- Unset the api dml status
157: ben_dpnt_edc_shd.constraint_error
158: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
159: When hr_api.unique_integrity_violated Then
160: -- Unique integrity has been violated
161: ben_dpnt_edc_shd.g_api_dml := false; -- Unset the api dml status
162: ben_dpnt_edc_shd.constraint_error
163: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
164: When Others Then
165: ben_dpnt_edc_shd.g_api_dml := false; -- Unset the api dml status
158: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
159: When hr_api.unique_integrity_violated Then
160: -- Unique integrity has been violated
161: ben_dpnt_edc_shd.g_api_dml := false; -- Unset the api dml status
162: ben_dpnt_edc_shd.constraint_error
163: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
164: When Others Then
165: ben_dpnt_edc_shd.g_api_dml := false; -- Unset the api dml status
166: Raise;
161: ben_dpnt_edc_shd.g_api_dml := false; -- Unset the api dml status
162: ben_dpnt_edc_shd.constraint_error
163: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
164: When Others Then
165: ben_dpnt_edc_shd.g_api_dml := false; -- Unset the api dml status
166: Raise;
167: End dt_update_dml;
168: --
169: -- ----------------------------------------------------------------------------
197: --
198: -- {End Of Comments}
199: -- ----------------------------------------------------------------------------
200: Procedure update_dml
201: (p_rec in out nocopy ben_dpnt_edc_shd.g_rec_type,
202: p_effective_date in date,
203: p_datetrack_mode in varchar2,
204: p_validation_start_date in date,
205: p_validation_end_date in date) is
261: --
262: -- {End Of Comments}
263: -- ----------------------------------------------------------------------------
264: Procedure dt_pre_update
265: (p_rec in out nocopy ben_dpnt_edc_shd.g_rec_type,
266: p_effective_date in date,
267: p_datetrack_mode in varchar2,
268: p_validation_start_date in date,
269: p_validation_end_date in date) is
277: hr_utility.set_location(l_proc, 10);
278: --
279: -- Update the current effective end date
280: --
281: ben_dpnt_edc_shd.upd_effective_end_date
282: (p_effective_date => p_effective_date,
283: p_base_key_value => p_rec.dpnt_eligy_crit_values_id,
284: p_new_effective_end_date => (p_validation_start_date - 1),
285: p_validation_start_date => p_validation_start_date,
346: --
347: -- {End Of Comments}
348: -- ----------------------------------------------------------------------------
349: Procedure pre_update
350: (p_rec in out nocopy ben_dpnt_edc_shd.g_rec_type,
351: p_effective_date in date,
352: p_datetrack_mode in varchar2,
353: p_validation_start_date in date,
354: p_validation_end_date in date) is
402: --
403: -- {End Of Comments}
404: -- ----------------------------------------------------------------------------
405: Procedure post_update
406: (p_rec in ben_dpnt_edc_shd.g_rec_type,
407: p_effective_date in date,
408: p_datetrack_mode in varchar2,
409: p_validation_start_date in date,
410: p_validation_end_date in date) is
476: ,p_number_value3 =>p_rec.number_value3
477: ,p_number_value4 =>p_rec.number_value4
478: ,p_date_value3 =>p_rec.date_value3
479: ,p_date_value4 =>p_rec.date_value4
480: ,p_dpnt_cvg_eligy_prfl_id_o =>ben_dpnt_edc_shd.g_old_rec.dpnt_cvg_eligy_prfl_id
481: ,p_eligy_criteria_dpnt_id_o =>ben_dpnt_edc_shd.g_old_rec.eligy_criteria_dpnt_id
482: ,p_effective_start_date_o =>ben_dpnt_edc_shd.g_old_rec.effective_start_date
483: ,p_effective_end_date_o =>ben_dpnt_edc_shd.g_old_rec.effective_end_date
484: ,p_ordr_num_o =>ben_dpnt_edc_shd.g_old_rec.ordr_num
477: ,p_number_value4 =>p_rec.number_value4
478: ,p_date_value3 =>p_rec.date_value3
479: ,p_date_value4 =>p_rec.date_value4
480: ,p_dpnt_cvg_eligy_prfl_id_o =>ben_dpnt_edc_shd.g_old_rec.dpnt_cvg_eligy_prfl_id
481: ,p_eligy_criteria_dpnt_id_o =>ben_dpnt_edc_shd.g_old_rec.eligy_criteria_dpnt_id
482: ,p_effective_start_date_o =>ben_dpnt_edc_shd.g_old_rec.effective_start_date
483: ,p_effective_end_date_o =>ben_dpnt_edc_shd.g_old_rec.effective_end_date
484: ,p_ordr_num_o =>ben_dpnt_edc_shd.g_old_rec.ordr_num
485: ,p_number_value1_o =>ben_dpnt_edc_shd.g_old_rec.number_value1
478: ,p_date_value3 =>p_rec.date_value3
479: ,p_date_value4 =>p_rec.date_value4
480: ,p_dpnt_cvg_eligy_prfl_id_o =>ben_dpnt_edc_shd.g_old_rec.dpnt_cvg_eligy_prfl_id
481: ,p_eligy_criteria_dpnt_id_o =>ben_dpnt_edc_shd.g_old_rec.eligy_criteria_dpnt_id
482: ,p_effective_start_date_o =>ben_dpnt_edc_shd.g_old_rec.effective_start_date
483: ,p_effective_end_date_o =>ben_dpnt_edc_shd.g_old_rec.effective_end_date
484: ,p_ordr_num_o =>ben_dpnt_edc_shd.g_old_rec.ordr_num
485: ,p_number_value1_o =>ben_dpnt_edc_shd.g_old_rec.number_value1
486: ,p_number_value2_o =>ben_dpnt_edc_shd.g_old_rec.number_value2
479: ,p_date_value4 =>p_rec.date_value4
480: ,p_dpnt_cvg_eligy_prfl_id_o =>ben_dpnt_edc_shd.g_old_rec.dpnt_cvg_eligy_prfl_id
481: ,p_eligy_criteria_dpnt_id_o =>ben_dpnt_edc_shd.g_old_rec.eligy_criteria_dpnt_id
482: ,p_effective_start_date_o =>ben_dpnt_edc_shd.g_old_rec.effective_start_date
483: ,p_effective_end_date_o =>ben_dpnt_edc_shd.g_old_rec.effective_end_date
484: ,p_ordr_num_o =>ben_dpnt_edc_shd.g_old_rec.ordr_num
485: ,p_number_value1_o =>ben_dpnt_edc_shd.g_old_rec.number_value1
486: ,p_number_value2_o =>ben_dpnt_edc_shd.g_old_rec.number_value2
487: ,p_char_value1_o =>ben_dpnt_edc_shd.g_old_rec.char_value1
480: ,p_dpnt_cvg_eligy_prfl_id_o =>ben_dpnt_edc_shd.g_old_rec.dpnt_cvg_eligy_prfl_id
481: ,p_eligy_criteria_dpnt_id_o =>ben_dpnt_edc_shd.g_old_rec.eligy_criteria_dpnt_id
482: ,p_effective_start_date_o =>ben_dpnt_edc_shd.g_old_rec.effective_start_date
483: ,p_effective_end_date_o =>ben_dpnt_edc_shd.g_old_rec.effective_end_date
484: ,p_ordr_num_o =>ben_dpnt_edc_shd.g_old_rec.ordr_num
485: ,p_number_value1_o =>ben_dpnt_edc_shd.g_old_rec.number_value1
486: ,p_number_value2_o =>ben_dpnt_edc_shd.g_old_rec.number_value2
487: ,p_char_value1_o =>ben_dpnt_edc_shd.g_old_rec.char_value1
488: ,p_char_value2_o =>ben_dpnt_edc_shd.g_old_rec.char_value2
481: ,p_eligy_criteria_dpnt_id_o =>ben_dpnt_edc_shd.g_old_rec.eligy_criteria_dpnt_id
482: ,p_effective_start_date_o =>ben_dpnt_edc_shd.g_old_rec.effective_start_date
483: ,p_effective_end_date_o =>ben_dpnt_edc_shd.g_old_rec.effective_end_date
484: ,p_ordr_num_o =>ben_dpnt_edc_shd.g_old_rec.ordr_num
485: ,p_number_value1_o =>ben_dpnt_edc_shd.g_old_rec.number_value1
486: ,p_number_value2_o =>ben_dpnt_edc_shd.g_old_rec.number_value2
487: ,p_char_value1_o =>ben_dpnt_edc_shd.g_old_rec.char_value1
488: ,p_char_value2_o =>ben_dpnt_edc_shd.g_old_rec.char_value2
489: ,p_date_value1_o =>ben_dpnt_edc_shd.g_old_rec.date_value1
482: ,p_effective_start_date_o =>ben_dpnt_edc_shd.g_old_rec.effective_start_date
483: ,p_effective_end_date_o =>ben_dpnt_edc_shd.g_old_rec.effective_end_date
484: ,p_ordr_num_o =>ben_dpnt_edc_shd.g_old_rec.ordr_num
485: ,p_number_value1_o =>ben_dpnt_edc_shd.g_old_rec.number_value1
486: ,p_number_value2_o =>ben_dpnt_edc_shd.g_old_rec.number_value2
487: ,p_char_value1_o =>ben_dpnt_edc_shd.g_old_rec.char_value1
488: ,p_char_value2_o =>ben_dpnt_edc_shd.g_old_rec.char_value2
489: ,p_date_value1_o =>ben_dpnt_edc_shd.g_old_rec.date_value1
490: ,p_date_value2_o =>ben_dpnt_edc_shd.g_old_rec.date_value2
483: ,p_effective_end_date_o =>ben_dpnt_edc_shd.g_old_rec.effective_end_date
484: ,p_ordr_num_o =>ben_dpnt_edc_shd.g_old_rec.ordr_num
485: ,p_number_value1_o =>ben_dpnt_edc_shd.g_old_rec.number_value1
486: ,p_number_value2_o =>ben_dpnt_edc_shd.g_old_rec.number_value2
487: ,p_char_value1_o =>ben_dpnt_edc_shd.g_old_rec.char_value1
488: ,p_char_value2_o =>ben_dpnt_edc_shd.g_old_rec.char_value2
489: ,p_date_value1_o =>ben_dpnt_edc_shd.g_old_rec.date_value1
490: ,p_date_value2_o =>ben_dpnt_edc_shd.g_old_rec.date_value2
491: ,p_excld_flag_o =>ben_dpnt_edc_shd.g_old_rec.excld_flag
484: ,p_ordr_num_o =>ben_dpnt_edc_shd.g_old_rec.ordr_num
485: ,p_number_value1_o =>ben_dpnt_edc_shd.g_old_rec.number_value1
486: ,p_number_value2_o =>ben_dpnt_edc_shd.g_old_rec.number_value2
487: ,p_char_value1_o =>ben_dpnt_edc_shd.g_old_rec.char_value1
488: ,p_char_value2_o =>ben_dpnt_edc_shd.g_old_rec.char_value2
489: ,p_date_value1_o =>ben_dpnt_edc_shd.g_old_rec.date_value1
490: ,p_date_value2_o =>ben_dpnt_edc_shd.g_old_rec.date_value2
491: ,p_excld_flag_o =>ben_dpnt_edc_shd.g_old_rec.excld_flag
492: ,p_business_group_id_o =>ben_dpnt_edc_shd.g_old_rec.business_group_id
485: ,p_number_value1_o =>ben_dpnt_edc_shd.g_old_rec.number_value1
486: ,p_number_value2_o =>ben_dpnt_edc_shd.g_old_rec.number_value2
487: ,p_char_value1_o =>ben_dpnt_edc_shd.g_old_rec.char_value1
488: ,p_char_value2_o =>ben_dpnt_edc_shd.g_old_rec.char_value2
489: ,p_date_value1_o =>ben_dpnt_edc_shd.g_old_rec.date_value1
490: ,p_date_value2_o =>ben_dpnt_edc_shd.g_old_rec.date_value2
491: ,p_excld_flag_o =>ben_dpnt_edc_shd.g_old_rec.excld_flag
492: ,p_business_group_id_o =>ben_dpnt_edc_shd.g_old_rec.business_group_id
493: ,p_edc_attribute_category_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute_category
486: ,p_number_value2_o =>ben_dpnt_edc_shd.g_old_rec.number_value2
487: ,p_char_value1_o =>ben_dpnt_edc_shd.g_old_rec.char_value1
488: ,p_char_value2_o =>ben_dpnt_edc_shd.g_old_rec.char_value2
489: ,p_date_value1_o =>ben_dpnt_edc_shd.g_old_rec.date_value1
490: ,p_date_value2_o =>ben_dpnt_edc_shd.g_old_rec.date_value2
491: ,p_excld_flag_o =>ben_dpnt_edc_shd.g_old_rec.excld_flag
492: ,p_business_group_id_o =>ben_dpnt_edc_shd.g_old_rec.business_group_id
493: ,p_edc_attribute_category_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute_category
494: ,p_edc_attribute1_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute1
487: ,p_char_value1_o =>ben_dpnt_edc_shd.g_old_rec.char_value1
488: ,p_char_value2_o =>ben_dpnt_edc_shd.g_old_rec.char_value2
489: ,p_date_value1_o =>ben_dpnt_edc_shd.g_old_rec.date_value1
490: ,p_date_value2_o =>ben_dpnt_edc_shd.g_old_rec.date_value2
491: ,p_excld_flag_o =>ben_dpnt_edc_shd.g_old_rec.excld_flag
492: ,p_business_group_id_o =>ben_dpnt_edc_shd.g_old_rec.business_group_id
493: ,p_edc_attribute_category_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute_category
494: ,p_edc_attribute1_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute1
495: ,p_edc_attribute2_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute2
488: ,p_char_value2_o =>ben_dpnt_edc_shd.g_old_rec.char_value2
489: ,p_date_value1_o =>ben_dpnt_edc_shd.g_old_rec.date_value1
490: ,p_date_value2_o =>ben_dpnt_edc_shd.g_old_rec.date_value2
491: ,p_excld_flag_o =>ben_dpnt_edc_shd.g_old_rec.excld_flag
492: ,p_business_group_id_o =>ben_dpnt_edc_shd.g_old_rec.business_group_id
493: ,p_edc_attribute_category_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute_category
494: ,p_edc_attribute1_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute1
495: ,p_edc_attribute2_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute2
496: ,p_edc_attribute3_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute3
489: ,p_date_value1_o =>ben_dpnt_edc_shd.g_old_rec.date_value1
490: ,p_date_value2_o =>ben_dpnt_edc_shd.g_old_rec.date_value2
491: ,p_excld_flag_o =>ben_dpnt_edc_shd.g_old_rec.excld_flag
492: ,p_business_group_id_o =>ben_dpnt_edc_shd.g_old_rec.business_group_id
493: ,p_edc_attribute_category_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute_category
494: ,p_edc_attribute1_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute1
495: ,p_edc_attribute2_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute2
496: ,p_edc_attribute3_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute3
497: ,p_edc_attribute4_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute4
490: ,p_date_value2_o =>ben_dpnt_edc_shd.g_old_rec.date_value2
491: ,p_excld_flag_o =>ben_dpnt_edc_shd.g_old_rec.excld_flag
492: ,p_business_group_id_o =>ben_dpnt_edc_shd.g_old_rec.business_group_id
493: ,p_edc_attribute_category_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute_category
494: ,p_edc_attribute1_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute1
495: ,p_edc_attribute2_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute2
496: ,p_edc_attribute3_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute3
497: ,p_edc_attribute4_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute4
498: ,p_edc_attribute5_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute5
491: ,p_excld_flag_o =>ben_dpnt_edc_shd.g_old_rec.excld_flag
492: ,p_business_group_id_o =>ben_dpnt_edc_shd.g_old_rec.business_group_id
493: ,p_edc_attribute_category_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute_category
494: ,p_edc_attribute1_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute1
495: ,p_edc_attribute2_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute2
496: ,p_edc_attribute3_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute3
497: ,p_edc_attribute4_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute4
498: ,p_edc_attribute5_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute5
499: ,p_edc_attribute6_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute6
492: ,p_business_group_id_o =>ben_dpnt_edc_shd.g_old_rec.business_group_id
493: ,p_edc_attribute_category_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute_category
494: ,p_edc_attribute1_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute1
495: ,p_edc_attribute2_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute2
496: ,p_edc_attribute3_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute3
497: ,p_edc_attribute4_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute4
498: ,p_edc_attribute5_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute5
499: ,p_edc_attribute6_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute6
500: ,p_edc_attribute7_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute7
493: ,p_edc_attribute_category_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute_category
494: ,p_edc_attribute1_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute1
495: ,p_edc_attribute2_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute2
496: ,p_edc_attribute3_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute3
497: ,p_edc_attribute4_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute4
498: ,p_edc_attribute5_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute5
499: ,p_edc_attribute6_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute6
500: ,p_edc_attribute7_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute7
501: ,p_edc_attribute8_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute8
494: ,p_edc_attribute1_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute1
495: ,p_edc_attribute2_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute2
496: ,p_edc_attribute3_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute3
497: ,p_edc_attribute4_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute4
498: ,p_edc_attribute5_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute5
499: ,p_edc_attribute6_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute6
500: ,p_edc_attribute7_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute7
501: ,p_edc_attribute8_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute8
502: ,p_edc_attribute9_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute9
495: ,p_edc_attribute2_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute2
496: ,p_edc_attribute3_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute3
497: ,p_edc_attribute4_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute4
498: ,p_edc_attribute5_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute5
499: ,p_edc_attribute6_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute6
500: ,p_edc_attribute7_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute7
501: ,p_edc_attribute8_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute8
502: ,p_edc_attribute9_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute9
503: ,p_edc_attribute10_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute10
496: ,p_edc_attribute3_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute3
497: ,p_edc_attribute4_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute4
498: ,p_edc_attribute5_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute5
499: ,p_edc_attribute6_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute6
500: ,p_edc_attribute7_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute7
501: ,p_edc_attribute8_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute8
502: ,p_edc_attribute9_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute9
503: ,p_edc_attribute10_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute10
504: ,p_edc_attribute11_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute11
497: ,p_edc_attribute4_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute4
498: ,p_edc_attribute5_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute5
499: ,p_edc_attribute6_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute6
500: ,p_edc_attribute7_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute7
501: ,p_edc_attribute8_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute8
502: ,p_edc_attribute9_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute9
503: ,p_edc_attribute10_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute10
504: ,p_edc_attribute11_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute11
505: ,p_edc_attribute12_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute12
498: ,p_edc_attribute5_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute5
499: ,p_edc_attribute6_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute6
500: ,p_edc_attribute7_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute7
501: ,p_edc_attribute8_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute8
502: ,p_edc_attribute9_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute9
503: ,p_edc_attribute10_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute10
504: ,p_edc_attribute11_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute11
505: ,p_edc_attribute12_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute12
506: ,p_edc_attribute13_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute13
499: ,p_edc_attribute6_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute6
500: ,p_edc_attribute7_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute7
501: ,p_edc_attribute8_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute8
502: ,p_edc_attribute9_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute9
503: ,p_edc_attribute10_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute10
504: ,p_edc_attribute11_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute11
505: ,p_edc_attribute12_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute12
506: ,p_edc_attribute13_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute13
507: ,p_edc_attribute14_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute14
500: ,p_edc_attribute7_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute7
501: ,p_edc_attribute8_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute8
502: ,p_edc_attribute9_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute9
503: ,p_edc_attribute10_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute10
504: ,p_edc_attribute11_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute11
505: ,p_edc_attribute12_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute12
506: ,p_edc_attribute13_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute13
507: ,p_edc_attribute14_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute14
508: ,p_edc_attribute15_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute15
501: ,p_edc_attribute8_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute8
502: ,p_edc_attribute9_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute9
503: ,p_edc_attribute10_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute10
504: ,p_edc_attribute11_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute11
505: ,p_edc_attribute12_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute12
506: ,p_edc_attribute13_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute13
507: ,p_edc_attribute14_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute14
508: ,p_edc_attribute15_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute15
509: ,p_edc_attribute16_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute16
502: ,p_edc_attribute9_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute9
503: ,p_edc_attribute10_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute10
504: ,p_edc_attribute11_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute11
505: ,p_edc_attribute12_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute12
506: ,p_edc_attribute13_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute13
507: ,p_edc_attribute14_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute14
508: ,p_edc_attribute15_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute15
509: ,p_edc_attribute16_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute16
510: ,p_edc_attribute17_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute17
503: ,p_edc_attribute10_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute10
504: ,p_edc_attribute11_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute11
505: ,p_edc_attribute12_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute12
506: ,p_edc_attribute13_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute13
507: ,p_edc_attribute14_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute14
508: ,p_edc_attribute15_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute15
509: ,p_edc_attribute16_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute16
510: ,p_edc_attribute17_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute17
511: ,p_edc_attribute18_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute18
504: ,p_edc_attribute11_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute11
505: ,p_edc_attribute12_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute12
506: ,p_edc_attribute13_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute13
507: ,p_edc_attribute14_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute14
508: ,p_edc_attribute15_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute15
509: ,p_edc_attribute16_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute16
510: ,p_edc_attribute17_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute17
511: ,p_edc_attribute18_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute18
512: ,p_edc_attribute19_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute19
505: ,p_edc_attribute12_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute12
506: ,p_edc_attribute13_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute13
507: ,p_edc_attribute14_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute14
508: ,p_edc_attribute15_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute15
509: ,p_edc_attribute16_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute16
510: ,p_edc_attribute17_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute17
511: ,p_edc_attribute18_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute18
512: ,p_edc_attribute19_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute19
513: ,p_edc_attribute20_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute20
506: ,p_edc_attribute13_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute13
507: ,p_edc_attribute14_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute14
508: ,p_edc_attribute15_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute15
509: ,p_edc_attribute16_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute16
510: ,p_edc_attribute17_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute17
511: ,p_edc_attribute18_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute18
512: ,p_edc_attribute19_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute19
513: ,p_edc_attribute20_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute20
514: ,p_edc_attribute21_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute21
507: ,p_edc_attribute14_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute14
508: ,p_edc_attribute15_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute15
509: ,p_edc_attribute16_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute16
510: ,p_edc_attribute17_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute17
511: ,p_edc_attribute18_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute18
512: ,p_edc_attribute19_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute19
513: ,p_edc_attribute20_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute20
514: ,p_edc_attribute21_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute21
515: ,p_edc_attribute22_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute22
508: ,p_edc_attribute15_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute15
509: ,p_edc_attribute16_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute16
510: ,p_edc_attribute17_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute17
511: ,p_edc_attribute18_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute18
512: ,p_edc_attribute19_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute19
513: ,p_edc_attribute20_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute20
514: ,p_edc_attribute21_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute21
515: ,p_edc_attribute22_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute22
516: ,p_edc_attribute23_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute23
509: ,p_edc_attribute16_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute16
510: ,p_edc_attribute17_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute17
511: ,p_edc_attribute18_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute18
512: ,p_edc_attribute19_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute19
513: ,p_edc_attribute20_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute20
514: ,p_edc_attribute21_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute21
515: ,p_edc_attribute22_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute22
516: ,p_edc_attribute23_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute23
517: ,p_edc_attribute24_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute24
510: ,p_edc_attribute17_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute17
511: ,p_edc_attribute18_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute18
512: ,p_edc_attribute19_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute19
513: ,p_edc_attribute20_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute20
514: ,p_edc_attribute21_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute21
515: ,p_edc_attribute22_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute22
516: ,p_edc_attribute23_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute23
517: ,p_edc_attribute24_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute24
518: ,p_edc_attribute25_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute25
511: ,p_edc_attribute18_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute18
512: ,p_edc_attribute19_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute19
513: ,p_edc_attribute20_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute20
514: ,p_edc_attribute21_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute21
515: ,p_edc_attribute22_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute22
516: ,p_edc_attribute23_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute23
517: ,p_edc_attribute24_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute24
518: ,p_edc_attribute25_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute25
519: ,p_edc_attribute26_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute26
512: ,p_edc_attribute19_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute19
513: ,p_edc_attribute20_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute20
514: ,p_edc_attribute21_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute21
515: ,p_edc_attribute22_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute22
516: ,p_edc_attribute23_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute23
517: ,p_edc_attribute24_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute24
518: ,p_edc_attribute25_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute25
519: ,p_edc_attribute26_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute26
520: ,p_edc_attribute27_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute27
513: ,p_edc_attribute20_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute20
514: ,p_edc_attribute21_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute21
515: ,p_edc_attribute22_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute22
516: ,p_edc_attribute23_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute23
517: ,p_edc_attribute24_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute24
518: ,p_edc_attribute25_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute25
519: ,p_edc_attribute26_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute26
520: ,p_edc_attribute27_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute27
521: ,p_edc_attribute28_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute28
514: ,p_edc_attribute21_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute21
515: ,p_edc_attribute22_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute22
516: ,p_edc_attribute23_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute23
517: ,p_edc_attribute24_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute24
518: ,p_edc_attribute25_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute25
519: ,p_edc_attribute26_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute26
520: ,p_edc_attribute27_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute27
521: ,p_edc_attribute28_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute28
522: ,p_edc_attribute29_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute29
515: ,p_edc_attribute22_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute22
516: ,p_edc_attribute23_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute23
517: ,p_edc_attribute24_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute24
518: ,p_edc_attribute25_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute25
519: ,p_edc_attribute26_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute26
520: ,p_edc_attribute27_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute27
521: ,p_edc_attribute28_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute28
522: ,p_edc_attribute29_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute29
523: ,p_edc_attribute30_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute30
516: ,p_edc_attribute23_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute23
517: ,p_edc_attribute24_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute24
518: ,p_edc_attribute25_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute25
519: ,p_edc_attribute26_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute26
520: ,p_edc_attribute27_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute27
521: ,p_edc_attribute28_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute28
522: ,p_edc_attribute29_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute29
523: ,p_edc_attribute30_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute30
524: ,p_object_version_number_o =>ben_dpnt_edc_shd.g_old_rec.object_version_number
517: ,p_edc_attribute24_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute24
518: ,p_edc_attribute25_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute25
519: ,p_edc_attribute26_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute26
520: ,p_edc_attribute27_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute27
521: ,p_edc_attribute28_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute28
522: ,p_edc_attribute29_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute29
523: ,p_edc_attribute30_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute30
524: ,p_object_version_number_o =>ben_dpnt_edc_shd.g_old_rec.object_version_number
525: ,p_char_value3_o =>ben_dpnt_edc_shd.g_old_rec.char_value3
518: ,p_edc_attribute25_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute25
519: ,p_edc_attribute26_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute26
520: ,p_edc_attribute27_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute27
521: ,p_edc_attribute28_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute28
522: ,p_edc_attribute29_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute29
523: ,p_edc_attribute30_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute30
524: ,p_object_version_number_o =>ben_dpnt_edc_shd.g_old_rec.object_version_number
525: ,p_char_value3_o =>ben_dpnt_edc_shd.g_old_rec.char_value3
526: ,p_char_value4_o =>ben_dpnt_edc_shd.g_old_rec.char_value4
519: ,p_edc_attribute26_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute26
520: ,p_edc_attribute27_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute27
521: ,p_edc_attribute28_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute28
522: ,p_edc_attribute29_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute29
523: ,p_edc_attribute30_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute30
524: ,p_object_version_number_o =>ben_dpnt_edc_shd.g_old_rec.object_version_number
525: ,p_char_value3_o =>ben_dpnt_edc_shd.g_old_rec.char_value3
526: ,p_char_value4_o =>ben_dpnt_edc_shd.g_old_rec.char_value4
527: ,p_number_value3_o =>ben_dpnt_edc_shd.g_old_rec.number_value3
520: ,p_edc_attribute27_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute27
521: ,p_edc_attribute28_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute28
522: ,p_edc_attribute29_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute29
523: ,p_edc_attribute30_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute30
524: ,p_object_version_number_o =>ben_dpnt_edc_shd.g_old_rec.object_version_number
525: ,p_char_value3_o =>ben_dpnt_edc_shd.g_old_rec.char_value3
526: ,p_char_value4_o =>ben_dpnt_edc_shd.g_old_rec.char_value4
527: ,p_number_value3_o =>ben_dpnt_edc_shd.g_old_rec.number_value3
528: ,p_number_value4_o =>ben_dpnt_edc_shd.g_old_rec.number_value4
521: ,p_edc_attribute28_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute28
522: ,p_edc_attribute29_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute29
523: ,p_edc_attribute30_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute30
524: ,p_object_version_number_o =>ben_dpnt_edc_shd.g_old_rec.object_version_number
525: ,p_char_value3_o =>ben_dpnt_edc_shd.g_old_rec.char_value3
526: ,p_char_value4_o =>ben_dpnt_edc_shd.g_old_rec.char_value4
527: ,p_number_value3_o =>ben_dpnt_edc_shd.g_old_rec.number_value3
528: ,p_number_value4_o =>ben_dpnt_edc_shd.g_old_rec.number_value4
529: ,p_date_value3_o =>ben_dpnt_edc_shd.g_old_rec.date_value3
522: ,p_edc_attribute29_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute29
523: ,p_edc_attribute30_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute30
524: ,p_object_version_number_o =>ben_dpnt_edc_shd.g_old_rec.object_version_number
525: ,p_char_value3_o =>ben_dpnt_edc_shd.g_old_rec.char_value3
526: ,p_char_value4_o =>ben_dpnt_edc_shd.g_old_rec.char_value4
527: ,p_number_value3_o =>ben_dpnt_edc_shd.g_old_rec.number_value3
528: ,p_number_value4_o =>ben_dpnt_edc_shd.g_old_rec.number_value4
529: ,p_date_value3_o =>ben_dpnt_edc_shd.g_old_rec.date_value3
530: ,p_date_value4_o =>ben_dpnt_edc_shd.g_old_rec.date_value4
523: ,p_edc_attribute30_o =>ben_dpnt_edc_shd.g_old_rec.edc_attribute30
524: ,p_object_version_number_o =>ben_dpnt_edc_shd.g_old_rec.object_version_number
525: ,p_char_value3_o =>ben_dpnt_edc_shd.g_old_rec.char_value3
526: ,p_char_value4_o =>ben_dpnt_edc_shd.g_old_rec.char_value4
527: ,p_number_value3_o =>ben_dpnt_edc_shd.g_old_rec.number_value3
528: ,p_number_value4_o =>ben_dpnt_edc_shd.g_old_rec.number_value4
529: ,p_date_value3_o =>ben_dpnt_edc_shd.g_old_rec.date_value3
530: ,p_date_value4_o =>ben_dpnt_edc_shd.g_old_rec.date_value4
531: );
524: ,p_object_version_number_o =>ben_dpnt_edc_shd.g_old_rec.object_version_number
525: ,p_char_value3_o =>ben_dpnt_edc_shd.g_old_rec.char_value3
526: ,p_char_value4_o =>ben_dpnt_edc_shd.g_old_rec.char_value4
527: ,p_number_value3_o =>ben_dpnt_edc_shd.g_old_rec.number_value3
528: ,p_number_value4_o =>ben_dpnt_edc_shd.g_old_rec.number_value4
529: ,p_date_value3_o =>ben_dpnt_edc_shd.g_old_rec.date_value3
530: ,p_date_value4_o =>ben_dpnt_edc_shd.g_old_rec.date_value4
531: );
532: --
525: ,p_char_value3_o =>ben_dpnt_edc_shd.g_old_rec.char_value3
526: ,p_char_value4_o =>ben_dpnt_edc_shd.g_old_rec.char_value4
527: ,p_number_value3_o =>ben_dpnt_edc_shd.g_old_rec.number_value3
528: ,p_number_value4_o =>ben_dpnt_edc_shd.g_old_rec.number_value4
529: ,p_date_value3_o =>ben_dpnt_edc_shd.g_old_rec.date_value3
530: ,p_date_value4_o =>ben_dpnt_edc_shd.g_old_rec.date_value4
531: );
532: --
533: exception
526: ,p_char_value4_o =>ben_dpnt_edc_shd.g_old_rec.char_value4
527: ,p_number_value3_o =>ben_dpnt_edc_shd.g_old_rec.number_value3
528: ,p_number_value4_o =>ben_dpnt_edc_shd.g_old_rec.number_value4
529: ,p_date_value3_o =>ben_dpnt_edc_shd.g_old_rec.date_value3
530: ,p_date_value4_o =>ben_dpnt_edc_shd.g_old_rec.date_value4
531: );
532: --
533: exception
534: --
589: -- Internal Row Handler Use Only.
590: --
591: -- {End Of Comments}
592: -- ----------------------------------------------------------------------------
593: Procedure convert_defs(p_rec in out nocopy ben_dpnt_edc_shd.g_rec_type) is
594: --
595: l_proc varchar2(72) := g_package||'convert_defs';
596: --
597: Begin
603: -- to see if a system default is being used. If a system default
604: -- is being used then we must set to the 'current' argument value.
605: --
606: If (p_rec.dpnt_cvg_eligy_prfl_id = hr_api.g_number) then
607: p_rec.dpnt_cvg_eligy_prfl_id := ben_dpnt_edc_shd.g_old_rec.dpnt_cvg_eligy_prfl_id;
608: end if;
609: If (p_rec.eligy_criteria_dpnt_id = hr_api.g_number) then
610: p_rec.eligy_criteria_dpnt_id := ben_dpnt_edc_shd.g_old_rec.eligy_criteria_dpnt_id;
611: end if;
606: If (p_rec.dpnt_cvg_eligy_prfl_id = hr_api.g_number) then
607: p_rec.dpnt_cvg_eligy_prfl_id := ben_dpnt_edc_shd.g_old_rec.dpnt_cvg_eligy_prfl_id;
608: end if;
609: If (p_rec.eligy_criteria_dpnt_id = hr_api.g_number) then
610: p_rec.eligy_criteria_dpnt_id := ben_dpnt_edc_shd.g_old_rec.eligy_criteria_dpnt_id;
611: end if;
612: If (p_rec.number_value1 = hr_api.g_number) then
613: p_rec.number_value1 := ben_dpnt_edc_shd.g_old_rec.number_value1;
614: end if;
609: If (p_rec.eligy_criteria_dpnt_id = hr_api.g_number) then
610: p_rec.eligy_criteria_dpnt_id := ben_dpnt_edc_shd.g_old_rec.eligy_criteria_dpnt_id;
611: end if;
612: If (p_rec.number_value1 = hr_api.g_number) then
613: p_rec.number_value1 := ben_dpnt_edc_shd.g_old_rec.number_value1;
614: end if;
615: If (p_rec.number_value2 = hr_api.g_number) then
616: p_rec.number_value2 := ben_dpnt_edc_shd.g_old_rec.number_value2;
617: end if;
612: If (p_rec.number_value1 = hr_api.g_number) then
613: p_rec.number_value1 := ben_dpnt_edc_shd.g_old_rec.number_value1;
614: end if;
615: If (p_rec.number_value2 = hr_api.g_number) then
616: p_rec.number_value2 := ben_dpnt_edc_shd.g_old_rec.number_value2;
617: end if;
618: If (p_rec.char_value1 = hr_api.g_varchar2) then
619: p_rec.char_value1 := ben_dpnt_edc_shd.g_old_rec.char_value1;
620: end if;
615: If (p_rec.number_value2 = hr_api.g_number) then
616: p_rec.number_value2 := ben_dpnt_edc_shd.g_old_rec.number_value2;
617: end if;
618: If (p_rec.char_value1 = hr_api.g_varchar2) then
619: p_rec.char_value1 := ben_dpnt_edc_shd.g_old_rec.char_value1;
620: end if;
621: If (p_rec.char_value2 = hr_api.g_varchar2) then
622: p_rec.char_value2 := ben_dpnt_edc_shd.g_old_rec.char_value2;
623: end if;
618: If (p_rec.char_value1 = hr_api.g_varchar2) then
619: p_rec.char_value1 := ben_dpnt_edc_shd.g_old_rec.char_value1;
620: end if;
621: If (p_rec.char_value2 = hr_api.g_varchar2) then
622: p_rec.char_value2 := ben_dpnt_edc_shd.g_old_rec.char_value2;
623: end if;
624: If (p_rec.date_value1 = hr_api.g_date) then
625: p_rec.date_value1 := ben_dpnt_edc_shd.g_old_rec.date_value1;
626: end if;
621: If (p_rec.char_value2 = hr_api.g_varchar2) then
622: p_rec.char_value2 := ben_dpnt_edc_shd.g_old_rec.char_value2;
623: end if;
624: If (p_rec.date_value1 = hr_api.g_date) then
625: p_rec.date_value1 := ben_dpnt_edc_shd.g_old_rec.date_value1;
626: end if;
627: If (p_rec.date_value2 = hr_api.g_date) then
628: p_rec.date_value2 := ben_dpnt_edc_shd.g_old_rec.date_value2;
629: end if;
624: If (p_rec.date_value1 = hr_api.g_date) then
625: p_rec.date_value1 := ben_dpnt_edc_shd.g_old_rec.date_value1;
626: end if;
627: If (p_rec.date_value2 = hr_api.g_date) then
628: p_rec.date_value2 := ben_dpnt_edc_shd.g_old_rec.date_value2;
629: end if;
630: If (p_rec.excld_flag = hr_api.g_varchar2) then
631: p_rec.excld_flag := ben_dpnt_edc_shd.g_old_rec.excld_flag;
632: end if;
627: If (p_rec.date_value2 = hr_api.g_date) then
628: p_rec.date_value2 := ben_dpnt_edc_shd.g_old_rec.date_value2;
629: end if;
630: If (p_rec.excld_flag = hr_api.g_varchar2) then
631: p_rec.excld_flag := ben_dpnt_edc_shd.g_old_rec.excld_flag;
632: end if;
633: If (p_rec.business_group_id = hr_api.g_number) then
634: p_rec.business_group_id := ben_dpnt_edc_shd.g_old_rec.business_group_id;
635: end if;
630: If (p_rec.excld_flag = hr_api.g_varchar2) then
631: p_rec.excld_flag := ben_dpnt_edc_shd.g_old_rec.excld_flag;
632: end if;
633: If (p_rec.business_group_id = hr_api.g_number) then
634: p_rec.business_group_id := ben_dpnt_edc_shd.g_old_rec.business_group_id;
635: end if;
636: If (p_rec.edc_attribute_category = hr_api.g_varchar2) then
637: p_rec.edc_attribute_category := ben_dpnt_edc_shd.g_old_rec.edc_attribute_category;
638: end if;
633: If (p_rec.business_group_id = hr_api.g_number) then
634: p_rec.business_group_id := ben_dpnt_edc_shd.g_old_rec.business_group_id;
635: end if;
636: If (p_rec.edc_attribute_category = hr_api.g_varchar2) then
637: p_rec.edc_attribute_category := ben_dpnt_edc_shd.g_old_rec.edc_attribute_category;
638: end if;
639: If (p_rec.edc_attribute1 = hr_api.g_varchar2) then
640: p_rec.edc_attribute1 := ben_dpnt_edc_shd.g_old_rec.edc_attribute1;
641: end if;
636: If (p_rec.edc_attribute_category = hr_api.g_varchar2) then
637: p_rec.edc_attribute_category := ben_dpnt_edc_shd.g_old_rec.edc_attribute_category;
638: end if;
639: If (p_rec.edc_attribute1 = hr_api.g_varchar2) then
640: p_rec.edc_attribute1 := ben_dpnt_edc_shd.g_old_rec.edc_attribute1;
641: end if;
642: If (p_rec.edc_attribute2 = hr_api.g_varchar2) then
643: p_rec.edc_attribute2 := ben_dpnt_edc_shd.g_old_rec.edc_attribute2;
644: end if;
639: If (p_rec.edc_attribute1 = hr_api.g_varchar2) then
640: p_rec.edc_attribute1 := ben_dpnt_edc_shd.g_old_rec.edc_attribute1;
641: end if;
642: If (p_rec.edc_attribute2 = hr_api.g_varchar2) then
643: p_rec.edc_attribute2 := ben_dpnt_edc_shd.g_old_rec.edc_attribute2;
644: end if;
645: If (p_rec.edc_attribute3 = hr_api.g_varchar2) then
646: p_rec.edc_attribute3 := ben_dpnt_edc_shd.g_old_rec.edc_attribute3;
647: end if;
642: If (p_rec.edc_attribute2 = hr_api.g_varchar2) then
643: p_rec.edc_attribute2 := ben_dpnt_edc_shd.g_old_rec.edc_attribute2;
644: end if;
645: If (p_rec.edc_attribute3 = hr_api.g_varchar2) then
646: p_rec.edc_attribute3 := ben_dpnt_edc_shd.g_old_rec.edc_attribute3;
647: end if;
648: If (p_rec.edc_attribute4 = hr_api.g_varchar2) then
649: p_rec.edc_attribute4 := ben_dpnt_edc_shd.g_old_rec.edc_attribute4;
650: end if;
645: If (p_rec.edc_attribute3 = hr_api.g_varchar2) then
646: p_rec.edc_attribute3 := ben_dpnt_edc_shd.g_old_rec.edc_attribute3;
647: end if;
648: If (p_rec.edc_attribute4 = hr_api.g_varchar2) then
649: p_rec.edc_attribute4 := ben_dpnt_edc_shd.g_old_rec.edc_attribute4;
650: end if;
651: If (p_rec.edc_attribute5 = hr_api.g_varchar2) then
652: p_rec.edc_attribute5 := ben_dpnt_edc_shd.g_old_rec.edc_attribute5;
653: end if;
648: If (p_rec.edc_attribute4 = hr_api.g_varchar2) then
649: p_rec.edc_attribute4 := ben_dpnt_edc_shd.g_old_rec.edc_attribute4;
650: end if;
651: If (p_rec.edc_attribute5 = hr_api.g_varchar2) then
652: p_rec.edc_attribute5 := ben_dpnt_edc_shd.g_old_rec.edc_attribute5;
653: end if;
654: If (p_rec.edc_attribute6 = hr_api.g_varchar2) then
655: p_rec.edc_attribute6 := ben_dpnt_edc_shd.g_old_rec.edc_attribute6;
656: end if;
651: If (p_rec.edc_attribute5 = hr_api.g_varchar2) then
652: p_rec.edc_attribute5 := ben_dpnt_edc_shd.g_old_rec.edc_attribute5;
653: end if;
654: If (p_rec.edc_attribute6 = hr_api.g_varchar2) then
655: p_rec.edc_attribute6 := ben_dpnt_edc_shd.g_old_rec.edc_attribute6;
656: end if;
657: If (p_rec.edc_attribute7 = hr_api.g_varchar2) then
658: p_rec.edc_attribute7 := ben_dpnt_edc_shd.g_old_rec.edc_attribute7;
659: end if;
654: If (p_rec.edc_attribute6 = hr_api.g_varchar2) then
655: p_rec.edc_attribute6 := ben_dpnt_edc_shd.g_old_rec.edc_attribute6;
656: end if;
657: If (p_rec.edc_attribute7 = hr_api.g_varchar2) then
658: p_rec.edc_attribute7 := ben_dpnt_edc_shd.g_old_rec.edc_attribute7;
659: end if;
660: If (p_rec.edc_attribute8 = hr_api.g_varchar2) then
661: p_rec.edc_attribute8 := ben_dpnt_edc_shd.g_old_rec.edc_attribute8;
662: end if;
657: If (p_rec.edc_attribute7 = hr_api.g_varchar2) then
658: p_rec.edc_attribute7 := ben_dpnt_edc_shd.g_old_rec.edc_attribute7;
659: end if;
660: If (p_rec.edc_attribute8 = hr_api.g_varchar2) then
661: p_rec.edc_attribute8 := ben_dpnt_edc_shd.g_old_rec.edc_attribute8;
662: end if;
663: If (p_rec.edc_attribute9 = hr_api.g_varchar2) then
664: p_rec.edc_attribute9 := ben_dpnt_edc_shd.g_old_rec.edc_attribute9;
665: end if;
660: If (p_rec.edc_attribute8 = hr_api.g_varchar2) then
661: p_rec.edc_attribute8 := ben_dpnt_edc_shd.g_old_rec.edc_attribute8;
662: end if;
663: If (p_rec.edc_attribute9 = hr_api.g_varchar2) then
664: p_rec.edc_attribute9 := ben_dpnt_edc_shd.g_old_rec.edc_attribute9;
665: end if;
666: If (p_rec.edc_attribute10 = hr_api.g_varchar2) then
667: p_rec.edc_attribute10 := ben_dpnt_edc_shd.g_old_rec.edc_attribute10;
668: end if;
663: If (p_rec.edc_attribute9 = hr_api.g_varchar2) then
664: p_rec.edc_attribute9 := ben_dpnt_edc_shd.g_old_rec.edc_attribute9;
665: end if;
666: If (p_rec.edc_attribute10 = hr_api.g_varchar2) then
667: p_rec.edc_attribute10 := ben_dpnt_edc_shd.g_old_rec.edc_attribute10;
668: end if;
669: If (p_rec.edc_attribute11 = hr_api.g_varchar2) then
670: p_rec.edc_attribute11 := ben_dpnt_edc_shd.g_old_rec.edc_attribute11;
671: end if;
666: If (p_rec.edc_attribute10 = hr_api.g_varchar2) then
667: p_rec.edc_attribute10 := ben_dpnt_edc_shd.g_old_rec.edc_attribute10;
668: end if;
669: If (p_rec.edc_attribute11 = hr_api.g_varchar2) then
670: p_rec.edc_attribute11 := ben_dpnt_edc_shd.g_old_rec.edc_attribute11;
671: end if;
672: If (p_rec.edc_attribute12 = hr_api.g_varchar2) then
673: p_rec.edc_attribute12 := ben_dpnt_edc_shd.g_old_rec.edc_attribute12;
674: end if;
669: If (p_rec.edc_attribute11 = hr_api.g_varchar2) then
670: p_rec.edc_attribute11 := ben_dpnt_edc_shd.g_old_rec.edc_attribute11;
671: end if;
672: If (p_rec.edc_attribute12 = hr_api.g_varchar2) then
673: p_rec.edc_attribute12 := ben_dpnt_edc_shd.g_old_rec.edc_attribute12;
674: end if;
675: If (p_rec.edc_attribute13 = hr_api.g_varchar2) then
676: p_rec.edc_attribute13 := ben_dpnt_edc_shd.g_old_rec.edc_attribute13;
677: end if;
672: If (p_rec.edc_attribute12 = hr_api.g_varchar2) then
673: p_rec.edc_attribute12 := ben_dpnt_edc_shd.g_old_rec.edc_attribute12;
674: end if;
675: If (p_rec.edc_attribute13 = hr_api.g_varchar2) then
676: p_rec.edc_attribute13 := ben_dpnt_edc_shd.g_old_rec.edc_attribute13;
677: end if;
678: If (p_rec.edc_attribute14 = hr_api.g_varchar2) then
679: p_rec.edc_attribute14 := ben_dpnt_edc_shd.g_old_rec.edc_attribute14;
680: end if;
675: If (p_rec.edc_attribute13 = hr_api.g_varchar2) then
676: p_rec.edc_attribute13 := ben_dpnt_edc_shd.g_old_rec.edc_attribute13;
677: end if;
678: If (p_rec.edc_attribute14 = hr_api.g_varchar2) then
679: p_rec.edc_attribute14 := ben_dpnt_edc_shd.g_old_rec.edc_attribute14;
680: end if;
681: If (p_rec.edc_attribute15 = hr_api.g_varchar2) then
682: p_rec.edc_attribute15 := ben_dpnt_edc_shd.g_old_rec.edc_attribute15;
683: end if;
678: If (p_rec.edc_attribute14 = hr_api.g_varchar2) then
679: p_rec.edc_attribute14 := ben_dpnt_edc_shd.g_old_rec.edc_attribute14;
680: end if;
681: If (p_rec.edc_attribute15 = hr_api.g_varchar2) then
682: p_rec.edc_attribute15 := ben_dpnt_edc_shd.g_old_rec.edc_attribute15;
683: end if;
684: If (p_rec.edc_attribute16 = hr_api.g_varchar2) then
685: p_rec.edc_attribute16 := ben_dpnt_edc_shd.g_old_rec.edc_attribute16;
686: end if;
681: If (p_rec.edc_attribute15 = hr_api.g_varchar2) then
682: p_rec.edc_attribute15 := ben_dpnt_edc_shd.g_old_rec.edc_attribute15;
683: end if;
684: If (p_rec.edc_attribute16 = hr_api.g_varchar2) then
685: p_rec.edc_attribute16 := ben_dpnt_edc_shd.g_old_rec.edc_attribute16;
686: end if;
687: If (p_rec.edc_attribute17 = hr_api.g_varchar2) then
688: p_rec.edc_attribute17 := ben_dpnt_edc_shd.g_old_rec.edc_attribute17;
689: end if;
684: If (p_rec.edc_attribute16 = hr_api.g_varchar2) then
685: p_rec.edc_attribute16 := ben_dpnt_edc_shd.g_old_rec.edc_attribute16;
686: end if;
687: If (p_rec.edc_attribute17 = hr_api.g_varchar2) then
688: p_rec.edc_attribute17 := ben_dpnt_edc_shd.g_old_rec.edc_attribute17;
689: end if;
690: If (p_rec.edc_attribute18 = hr_api.g_varchar2) then
691: p_rec.edc_attribute18 := ben_dpnt_edc_shd.g_old_rec.edc_attribute18;
692: end if;
687: If (p_rec.edc_attribute17 = hr_api.g_varchar2) then
688: p_rec.edc_attribute17 := ben_dpnt_edc_shd.g_old_rec.edc_attribute17;
689: end if;
690: If (p_rec.edc_attribute18 = hr_api.g_varchar2) then
691: p_rec.edc_attribute18 := ben_dpnt_edc_shd.g_old_rec.edc_attribute18;
692: end if;
693: If (p_rec.edc_attribute19 = hr_api.g_varchar2) then
694: p_rec.edc_attribute19 := ben_dpnt_edc_shd.g_old_rec.edc_attribute19;
695: end if;
690: If (p_rec.edc_attribute18 = hr_api.g_varchar2) then
691: p_rec.edc_attribute18 := ben_dpnt_edc_shd.g_old_rec.edc_attribute18;
692: end if;
693: If (p_rec.edc_attribute19 = hr_api.g_varchar2) then
694: p_rec.edc_attribute19 := ben_dpnt_edc_shd.g_old_rec.edc_attribute19;
695: end if;
696: If (p_rec.edc_attribute20 = hr_api.g_varchar2) then
697: p_rec.edc_attribute20 := ben_dpnt_edc_shd.g_old_rec.edc_attribute20;
698: end if;
693: If (p_rec.edc_attribute19 = hr_api.g_varchar2) then
694: p_rec.edc_attribute19 := ben_dpnt_edc_shd.g_old_rec.edc_attribute19;
695: end if;
696: If (p_rec.edc_attribute20 = hr_api.g_varchar2) then
697: p_rec.edc_attribute20 := ben_dpnt_edc_shd.g_old_rec.edc_attribute20;
698: end if;
699: If (p_rec.edc_attribute21 = hr_api.g_varchar2) then
700: p_rec.edc_attribute21 := ben_dpnt_edc_shd.g_old_rec.edc_attribute21;
701: end if;
696: If (p_rec.edc_attribute20 = hr_api.g_varchar2) then
697: p_rec.edc_attribute20 := ben_dpnt_edc_shd.g_old_rec.edc_attribute20;
698: end if;
699: If (p_rec.edc_attribute21 = hr_api.g_varchar2) then
700: p_rec.edc_attribute21 := ben_dpnt_edc_shd.g_old_rec.edc_attribute21;
701: end if;
702: If (p_rec.edc_attribute22 = hr_api.g_varchar2) then
703: p_rec.edc_attribute22 := ben_dpnt_edc_shd.g_old_rec.edc_attribute22;
704: end if;
699: If (p_rec.edc_attribute21 = hr_api.g_varchar2) then
700: p_rec.edc_attribute21 := ben_dpnt_edc_shd.g_old_rec.edc_attribute21;
701: end if;
702: If (p_rec.edc_attribute22 = hr_api.g_varchar2) then
703: p_rec.edc_attribute22 := ben_dpnt_edc_shd.g_old_rec.edc_attribute22;
704: end if;
705: If (p_rec.edc_attribute23 = hr_api.g_varchar2) then
706: p_rec.edc_attribute23 := ben_dpnt_edc_shd.g_old_rec.edc_attribute23;
707: end if;
702: If (p_rec.edc_attribute22 = hr_api.g_varchar2) then
703: p_rec.edc_attribute22 := ben_dpnt_edc_shd.g_old_rec.edc_attribute22;
704: end if;
705: If (p_rec.edc_attribute23 = hr_api.g_varchar2) then
706: p_rec.edc_attribute23 := ben_dpnt_edc_shd.g_old_rec.edc_attribute23;
707: end if;
708: If (p_rec.edc_attribute24 = hr_api.g_varchar2) then
709: p_rec.edc_attribute24 := ben_dpnt_edc_shd.g_old_rec.edc_attribute24;
710: end if;
705: If (p_rec.edc_attribute23 = hr_api.g_varchar2) then
706: p_rec.edc_attribute23 := ben_dpnt_edc_shd.g_old_rec.edc_attribute23;
707: end if;
708: If (p_rec.edc_attribute24 = hr_api.g_varchar2) then
709: p_rec.edc_attribute24 := ben_dpnt_edc_shd.g_old_rec.edc_attribute24;
710: end if;
711: If (p_rec.edc_attribute25 = hr_api.g_varchar2) then
712: p_rec.edc_attribute25 := ben_dpnt_edc_shd.g_old_rec.edc_attribute25;
713: end if;
708: If (p_rec.edc_attribute24 = hr_api.g_varchar2) then
709: p_rec.edc_attribute24 := ben_dpnt_edc_shd.g_old_rec.edc_attribute24;
710: end if;
711: If (p_rec.edc_attribute25 = hr_api.g_varchar2) then
712: p_rec.edc_attribute25 := ben_dpnt_edc_shd.g_old_rec.edc_attribute25;
713: end if;
714: If (p_rec.edc_attribute26 = hr_api.g_varchar2) then
715: p_rec.edc_attribute26 := ben_dpnt_edc_shd.g_old_rec.edc_attribute26;
716: end if;
711: If (p_rec.edc_attribute25 = hr_api.g_varchar2) then
712: p_rec.edc_attribute25 := ben_dpnt_edc_shd.g_old_rec.edc_attribute25;
713: end if;
714: If (p_rec.edc_attribute26 = hr_api.g_varchar2) then
715: p_rec.edc_attribute26 := ben_dpnt_edc_shd.g_old_rec.edc_attribute26;
716: end if;
717: If (p_rec.edc_attribute27 = hr_api.g_varchar2) then
718: p_rec.edc_attribute27 := ben_dpnt_edc_shd.g_old_rec.edc_attribute27;
719: end if;
714: If (p_rec.edc_attribute26 = hr_api.g_varchar2) then
715: p_rec.edc_attribute26 := ben_dpnt_edc_shd.g_old_rec.edc_attribute26;
716: end if;
717: If (p_rec.edc_attribute27 = hr_api.g_varchar2) then
718: p_rec.edc_attribute27 := ben_dpnt_edc_shd.g_old_rec.edc_attribute27;
719: end if;
720: If (p_rec.edc_attribute28 = hr_api.g_varchar2) then
721: p_rec.edc_attribute28 := ben_dpnt_edc_shd.g_old_rec.edc_attribute28;
722: end if;
717: If (p_rec.edc_attribute27 = hr_api.g_varchar2) then
718: p_rec.edc_attribute27 := ben_dpnt_edc_shd.g_old_rec.edc_attribute27;
719: end if;
720: If (p_rec.edc_attribute28 = hr_api.g_varchar2) then
721: p_rec.edc_attribute28 := ben_dpnt_edc_shd.g_old_rec.edc_attribute28;
722: end if;
723: If (p_rec.edc_attribute29 = hr_api.g_varchar2) then
724: p_rec.edc_attribute29 := ben_dpnt_edc_shd.g_old_rec.edc_attribute29;
725: end if;
720: If (p_rec.edc_attribute28 = hr_api.g_varchar2) then
721: p_rec.edc_attribute28 := ben_dpnt_edc_shd.g_old_rec.edc_attribute28;
722: end if;
723: If (p_rec.edc_attribute29 = hr_api.g_varchar2) then
724: p_rec.edc_attribute29 := ben_dpnt_edc_shd.g_old_rec.edc_attribute29;
725: end if;
726: If (p_rec.edc_attribute30 = hr_api.g_varchar2) then
727: p_rec.edc_attribute30 := ben_dpnt_edc_shd.g_old_rec.edc_attribute30;
728: end if;
723: If (p_rec.edc_attribute29 = hr_api.g_varchar2) then
724: p_rec.edc_attribute29 := ben_dpnt_edc_shd.g_old_rec.edc_attribute29;
725: end if;
726: If (p_rec.edc_attribute30 = hr_api.g_varchar2) then
727: p_rec.edc_attribute30 := ben_dpnt_edc_shd.g_old_rec.edc_attribute30;
728: end if;
729: If (p_rec.Char_value3 = hr_api.g_varchar2) then
730: p_rec.Char_value3 := ben_dpnt_edc_shd.g_old_rec.Char_value3;
731: end if;
726: If (p_rec.edc_attribute30 = hr_api.g_varchar2) then
727: p_rec.edc_attribute30 := ben_dpnt_edc_shd.g_old_rec.edc_attribute30;
728: end if;
729: If (p_rec.Char_value3 = hr_api.g_varchar2) then
730: p_rec.Char_value3 := ben_dpnt_edc_shd.g_old_rec.Char_value3;
731: end if;
732: If (p_rec.Char_value4 = hr_api.g_varchar2) then
733: p_rec.Char_value4 := ben_dpnt_edc_shd.g_old_rec.Char_value4;
734: end if;
729: If (p_rec.Char_value3 = hr_api.g_varchar2) then
730: p_rec.Char_value3 := ben_dpnt_edc_shd.g_old_rec.Char_value3;
731: end if;
732: If (p_rec.Char_value4 = hr_api.g_varchar2) then
733: p_rec.Char_value4 := ben_dpnt_edc_shd.g_old_rec.Char_value4;
734: end if;
735: If (p_rec.Number_value3 = hr_api.g_number) then
736: p_rec.Number_value3 := ben_dpnt_edc_shd.g_old_rec.Number_value3;
737: end if;
732: If (p_rec.Char_value4 = hr_api.g_varchar2) then
733: p_rec.Char_value4 := ben_dpnt_edc_shd.g_old_rec.Char_value4;
734: end if;
735: If (p_rec.Number_value3 = hr_api.g_number) then
736: p_rec.Number_value3 := ben_dpnt_edc_shd.g_old_rec.Number_value3;
737: end if;
738: If (p_rec.Number_value4 = hr_api.g_number) then
739: p_rec.Number_value4 := ben_dpnt_edc_shd.g_old_rec.Number_value4;
740: end if;
735: If (p_rec.Number_value3 = hr_api.g_number) then
736: p_rec.Number_value3 := ben_dpnt_edc_shd.g_old_rec.Number_value3;
737: end if;
738: If (p_rec.Number_value4 = hr_api.g_number) then
739: p_rec.Number_value4 := ben_dpnt_edc_shd.g_old_rec.Number_value4;
740: end if;
741: If (p_rec.Date_value3 = hr_api.g_date) then
742: p_rec.Date_value3 := ben_dpnt_edc_shd.g_old_rec.Date_value3;
743: end if;
738: If (p_rec.Number_value4 = hr_api.g_number) then
739: p_rec.Number_value4 := ben_dpnt_edc_shd.g_old_rec.Number_value4;
740: end if;
741: If (p_rec.Date_value3 = hr_api.g_date) then
742: p_rec.Date_value3 := ben_dpnt_edc_shd.g_old_rec.Date_value3;
743: end if;
744: If (p_rec.Date_value4 = hr_api.g_date) then
745: p_rec.Date_value4 := ben_dpnt_edc_shd.g_old_rec.Date_value4;
746: end if;
741: If (p_rec.Date_value3 = hr_api.g_date) then
742: p_rec.Date_value3 := ben_dpnt_edc_shd.g_old_rec.Date_value3;
743: end if;
744: If (p_rec.Date_value4 = hr_api.g_date) then
745: p_rec.Date_value4 := ben_dpnt_edc_shd.g_old_rec.Date_value4;
746: end if;
747:
748: --
749: hr_utility.set_location(' Leaving:'||l_proc, 10);
754: -- |---------------------------------< upd >----------------------------------|
755: -- ----------------------------------------------------------------------------
756: Procedure upd
757: (
758: p_rec in out nocopy ben_dpnt_edc_shd.g_rec_type,
759: p_effective_date in date,
760: p_datetrack_mode in varchar2
761: ) is
762: --
772: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
773: --
774: -- We must lock the row which we need to update.
775: --
776: ben_dpnt_edc_shd.lck
777: (p_effective_date => p_effective_date,
778: p_datetrack_mode => p_datetrack_mode,
779: p_dpnt_eligy_crit_values_id => p_rec.dpnt_eligy_crit_values_id,
780: p_object_version_number => p_rec.object_version_number,
883: ,p_Date_value3 In Date default hr_api.g_date
884: ,p_Date_value4 In Date default hr_api.g_date
885: ) is
886: --
887: l_rec ben_dpnt_edc_shd.g_rec_type;
888: l_proc varchar2(72) := g_package||'upd';
889: --
890: Begin
891: hr_utility.set_location('Entering:'||l_proc, 5);
893: -- Call conversion function to turn arguments into the
894: -- l_rec structure.
895: --
896: l_rec :=
897: ben_dpnt_edc_shd.convert_args
898: (
899: p_dpnt_eligy_crit_values_id,
900: p_dpnt_cvg_eligy_prfl_id,
901: p_eligy_criteria_dpnt_id,