50: -- Internal Row Handler Use Only.
51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml(p_rec in out nocopy ben_dpnt_egd_shd.g_rec_type) is
55: --
56: l_proc varchar2(72) := g_package||'update_dml';
57: --
58: Begin
61: -- Increment the object version
62: --
63: p_rec.object_version_number := p_rec.object_version_number + 1;
64: --
65: ben_dpnt_egd_shd.g_api_dml := true; -- Set the api dml status
66: --
67: -- Update the ben_eligy_criteria Row
68: --
69: update ben_eligy_criteria_dpnt
130:
131:
132: where eligy_criteria_dpnt_id = p_rec.eligy_criteria_dpnt_id;
133: --
134: ben_dpnt_egd_shd.g_api_dml := false; -- Unset the api dml status
135: --
136: hr_utility.set_location(' Leaving:'||l_proc, 10);
137: --
138: Exception
137: --
138: Exception
139: When hr_api.check_integrity_violated Then
140: -- A check constraint has been violated
141: ben_dpnt_egd_shd.g_api_dml := false; -- Unset the api dml status
142: ben_dpnt_egd_shd.constraint_error
143: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
144: When hr_api.parent_integrity_violated Then
145: -- Parent integrity has been violated
138: Exception
139: When hr_api.check_integrity_violated Then
140: -- A check constraint has been violated
141: ben_dpnt_egd_shd.g_api_dml := false; -- Unset the api dml status
142: ben_dpnt_egd_shd.constraint_error
143: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
144: When hr_api.parent_integrity_violated Then
145: -- Parent integrity has been violated
146: ben_dpnt_egd_shd.g_api_dml := false; -- Unset the api dml status
142: ben_dpnt_egd_shd.constraint_error
143: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
144: When hr_api.parent_integrity_violated Then
145: -- Parent integrity has been violated
146: ben_dpnt_egd_shd.g_api_dml := false; -- Unset the api dml status
147: ben_dpnt_egd_shd.constraint_error
148: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
149: When hr_api.unique_integrity_violated Then
150: -- Unique integrity has been violated
143: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
144: When hr_api.parent_integrity_violated Then
145: -- Parent integrity has been violated
146: ben_dpnt_egd_shd.g_api_dml := false; -- Unset the api dml status
147: ben_dpnt_egd_shd.constraint_error
148: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
149: When hr_api.unique_integrity_violated Then
150: -- Unique integrity has been violated
151: ben_dpnt_egd_shd.g_api_dml := false; -- Unset the api dml status
147: ben_dpnt_egd_shd.constraint_error
148: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
149: When hr_api.unique_integrity_violated Then
150: -- Unique integrity has been violated
151: ben_dpnt_egd_shd.g_api_dml := false; -- Unset the api dml status
152: ben_dpnt_egd_shd.constraint_error
153: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
154: When Others Then
155: ben_dpnt_egd_shd.g_api_dml := false; -- Unset the api dml status
148: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
149: When hr_api.unique_integrity_violated Then
150: -- Unique integrity has been violated
151: ben_dpnt_egd_shd.g_api_dml := false; -- Unset the api dml status
152: ben_dpnt_egd_shd.constraint_error
153: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
154: When Others Then
155: ben_dpnt_egd_shd.g_api_dml := false; -- Unset the api dml status
156: Raise;
151: ben_dpnt_egd_shd.g_api_dml := false; -- Unset the api dml status
152: ben_dpnt_egd_shd.constraint_error
153: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
154: When Others Then
155: ben_dpnt_egd_shd.g_api_dml := false; -- Unset the api dml status
156: Raise;
157: End update_dml;
158: --
159: -- ----------------------------------------------------------------------------
187: -- Internal Row Handler Use Only.
188: --
189: -- {End Of Comments}
190: -- ----------------------------------------------------------------------------
191: Procedure pre_update(p_rec in ben_dpnt_egd_shd.g_rec_type) is
192: --
193: l_proc varchar2(72) := g_package||'pre_update';
194: --
195: Begin
229: -- Internal Row Handler Use Only.
230: --
231: -- {End Of Comments}
232: -- ----------------------------------------------------------------------------
233: Procedure post_update( p_rec in ben_dpnt_egd_shd.g_rec_type
234: ,p_effective_date in date) is
235: --
236: l_proc varchar2(72) := g_package||'post_update';
237: --
305: ,p_effective_date => p_effective_date
306: ,p_allow_range_validation_flag2 => p_rec.allow_range_validation_flag2
307: ,p_time_access_calc_rule1 => p_rec.time_access_calc_rule1
308: ,p_time_access_calc_rule2 => p_rec.time_access_calc_rule2
309: ,p_name_o => ben_dpnt_egd_shd.g_old_rec.name
310: ,p_short_code_o => ben_dpnt_egd_shd.g_old_rec.short_code
311: ,p_description_o => ben_dpnt_egd_shd.g_old_rec.description
312: ,p_criteria_type_o => ben_dpnt_egd_shd.g_old_rec.criteria_type
313: ,p_crit_col1_val_type_cd_o => ben_dpnt_egd_shd.g_old_rec.crit_col1_val_type_cd
306: ,p_allow_range_validation_flag2 => p_rec.allow_range_validation_flag2
307: ,p_time_access_calc_rule1 => p_rec.time_access_calc_rule1
308: ,p_time_access_calc_rule2 => p_rec.time_access_calc_rule2
309: ,p_name_o => ben_dpnt_egd_shd.g_old_rec.name
310: ,p_short_code_o => ben_dpnt_egd_shd.g_old_rec.short_code
311: ,p_description_o => ben_dpnt_egd_shd.g_old_rec.description
312: ,p_criteria_type_o => ben_dpnt_egd_shd.g_old_rec.criteria_type
313: ,p_crit_col1_val_type_cd_o => ben_dpnt_egd_shd.g_old_rec.crit_col1_val_type_cd
314: ,p_crit_col1_datatype_o => ben_dpnt_egd_shd.g_old_rec.crit_col1_datatype
307: ,p_time_access_calc_rule1 => p_rec.time_access_calc_rule1
308: ,p_time_access_calc_rule2 => p_rec.time_access_calc_rule2
309: ,p_name_o => ben_dpnt_egd_shd.g_old_rec.name
310: ,p_short_code_o => ben_dpnt_egd_shd.g_old_rec.short_code
311: ,p_description_o => ben_dpnt_egd_shd.g_old_rec.description
312: ,p_criteria_type_o => ben_dpnt_egd_shd.g_old_rec.criteria_type
313: ,p_crit_col1_val_type_cd_o => ben_dpnt_egd_shd.g_old_rec.crit_col1_val_type_cd
314: ,p_crit_col1_datatype_o => ben_dpnt_egd_shd.g_old_rec.crit_col1_datatype
315: ,p_col1_lookup_type_o => ben_dpnt_egd_shd.g_old_rec.col1_lookup_type
308: ,p_time_access_calc_rule2 => p_rec.time_access_calc_rule2
309: ,p_name_o => ben_dpnt_egd_shd.g_old_rec.name
310: ,p_short_code_o => ben_dpnt_egd_shd.g_old_rec.short_code
311: ,p_description_o => ben_dpnt_egd_shd.g_old_rec.description
312: ,p_criteria_type_o => ben_dpnt_egd_shd.g_old_rec.criteria_type
313: ,p_crit_col1_val_type_cd_o => ben_dpnt_egd_shd.g_old_rec.crit_col1_val_type_cd
314: ,p_crit_col1_datatype_o => ben_dpnt_egd_shd.g_old_rec.crit_col1_datatype
315: ,p_col1_lookup_type_o => ben_dpnt_egd_shd.g_old_rec.col1_lookup_type
316: ,p_col1_value_set_id_o => ben_dpnt_egd_shd.g_old_rec.col1_value_set_id
309: ,p_name_o => ben_dpnt_egd_shd.g_old_rec.name
310: ,p_short_code_o => ben_dpnt_egd_shd.g_old_rec.short_code
311: ,p_description_o => ben_dpnt_egd_shd.g_old_rec.description
312: ,p_criteria_type_o => ben_dpnt_egd_shd.g_old_rec.criteria_type
313: ,p_crit_col1_val_type_cd_o => ben_dpnt_egd_shd.g_old_rec.crit_col1_val_type_cd
314: ,p_crit_col1_datatype_o => ben_dpnt_egd_shd.g_old_rec.crit_col1_datatype
315: ,p_col1_lookup_type_o => ben_dpnt_egd_shd.g_old_rec.col1_lookup_type
316: ,p_col1_value_set_id_o => ben_dpnt_egd_shd.g_old_rec.col1_value_set_id
317: ,p_access_table_name1_o => ben_dpnt_egd_shd.g_old_rec.access_table_name1
310: ,p_short_code_o => ben_dpnt_egd_shd.g_old_rec.short_code
311: ,p_description_o => ben_dpnt_egd_shd.g_old_rec.description
312: ,p_criteria_type_o => ben_dpnt_egd_shd.g_old_rec.criteria_type
313: ,p_crit_col1_val_type_cd_o => ben_dpnt_egd_shd.g_old_rec.crit_col1_val_type_cd
314: ,p_crit_col1_datatype_o => ben_dpnt_egd_shd.g_old_rec.crit_col1_datatype
315: ,p_col1_lookup_type_o => ben_dpnt_egd_shd.g_old_rec.col1_lookup_type
316: ,p_col1_value_set_id_o => ben_dpnt_egd_shd.g_old_rec.col1_value_set_id
317: ,p_access_table_name1_o => ben_dpnt_egd_shd.g_old_rec.access_table_name1
318: ,p_access_column_name1_o => ben_dpnt_egd_shd.g_old_rec.access_column_name1
311: ,p_description_o => ben_dpnt_egd_shd.g_old_rec.description
312: ,p_criteria_type_o => ben_dpnt_egd_shd.g_old_rec.criteria_type
313: ,p_crit_col1_val_type_cd_o => ben_dpnt_egd_shd.g_old_rec.crit_col1_val_type_cd
314: ,p_crit_col1_datatype_o => ben_dpnt_egd_shd.g_old_rec.crit_col1_datatype
315: ,p_col1_lookup_type_o => ben_dpnt_egd_shd.g_old_rec.col1_lookup_type
316: ,p_col1_value_set_id_o => ben_dpnt_egd_shd.g_old_rec.col1_value_set_id
317: ,p_access_table_name1_o => ben_dpnt_egd_shd.g_old_rec.access_table_name1
318: ,p_access_column_name1_o => ben_dpnt_egd_shd.g_old_rec.access_column_name1
319: ,p_time_entry_access_tab_nam1_o => ben_dpnt_egd_shd.g_old_rec.time_entry_access_tab_nam1
312: ,p_criteria_type_o => ben_dpnt_egd_shd.g_old_rec.criteria_type
313: ,p_crit_col1_val_type_cd_o => ben_dpnt_egd_shd.g_old_rec.crit_col1_val_type_cd
314: ,p_crit_col1_datatype_o => ben_dpnt_egd_shd.g_old_rec.crit_col1_datatype
315: ,p_col1_lookup_type_o => ben_dpnt_egd_shd.g_old_rec.col1_lookup_type
316: ,p_col1_value_set_id_o => ben_dpnt_egd_shd.g_old_rec.col1_value_set_id
317: ,p_access_table_name1_o => ben_dpnt_egd_shd.g_old_rec.access_table_name1
318: ,p_access_column_name1_o => ben_dpnt_egd_shd.g_old_rec.access_column_name1
319: ,p_time_entry_access_tab_nam1_o => ben_dpnt_egd_shd.g_old_rec.time_entry_access_tab_nam1
320: ,p_time_entry_access_col_nam1_o => ben_dpnt_egd_shd.g_old_rec.time_entry_access_col_nam1
313: ,p_crit_col1_val_type_cd_o => ben_dpnt_egd_shd.g_old_rec.crit_col1_val_type_cd
314: ,p_crit_col1_datatype_o => ben_dpnt_egd_shd.g_old_rec.crit_col1_datatype
315: ,p_col1_lookup_type_o => ben_dpnt_egd_shd.g_old_rec.col1_lookup_type
316: ,p_col1_value_set_id_o => ben_dpnt_egd_shd.g_old_rec.col1_value_set_id
317: ,p_access_table_name1_o => ben_dpnt_egd_shd.g_old_rec.access_table_name1
318: ,p_access_column_name1_o => ben_dpnt_egd_shd.g_old_rec.access_column_name1
319: ,p_time_entry_access_tab_nam1_o => ben_dpnt_egd_shd.g_old_rec.time_entry_access_tab_nam1
320: ,p_time_entry_access_col_nam1_o => ben_dpnt_egd_shd.g_old_rec.time_entry_access_col_nam1
321: ,p_crit_col2_val_type_cd_o => ben_dpnt_egd_shd.g_old_rec.crit_col2_val_type_cd
314: ,p_crit_col1_datatype_o => ben_dpnt_egd_shd.g_old_rec.crit_col1_datatype
315: ,p_col1_lookup_type_o => ben_dpnt_egd_shd.g_old_rec.col1_lookup_type
316: ,p_col1_value_set_id_o => ben_dpnt_egd_shd.g_old_rec.col1_value_set_id
317: ,p_access_table_name1_o => ben_dpnt_egd_shd.g_old_rec.access_table_name1
318: ,p_access_column_name1_o => ben_dpnt_egd_shd.g_old_rec.access_column_name1
319: ,p_time_entry_access_tab_nam1_o => ben_dpnt_egd_shd.g_old_rec.time_entry_access_tab_nam1
320: ,p_time_entry_access_col_nam1_o => ben_dpnt_egd_shd.g_old_rec.time_entry_access_col_nam1
321: ,p_crit_col2_val_type_cd_o => ben_dpnt_egd_shd.g_old_rec.crit_col2_val_type_cd
322: ,p_crit_col2_datatype_o => ben_dpnt_egd_shd.g_old_rec.crit_col2_datatype
315: ,p_col1_lookup_type_o => ben_dpnt_egd_shd.g_old_rec.col1_lookup_type
316: ,p_col1_value_set_id_o => ben_dpnt_egd_shd.g_old_rec.col1_value_set_id
317: ,p_access_table_name1_o => ben_dpnt_egd_shd.g_old_rec.access_table_name1
318: ,p_access_column_name1_o => ben_dpnt_egd_shd.g_old_rec.access_column_name1
319: ,p_time_entry_access_tab_nam1_o => ben_dpnt_egd_shd.g_old_rec.time_entry_access_tab_nam1
320: ,p_time_entry_access_col_nam1_o => ben_dpnt_egd_shd.g_old_rec.time_entry_access_col_nam1
321: ,p_crit_col2_val_type_cd_o => ben_dpnt_egd_shd.g_old_rec.crit_col2_val_type_cd
322: ,p_crit_col2_datatype_o => ben_dpnt_egd_shd.g_old_rec.crit_col2_datatype
323: ,p_col2_lookup_type_o => ben_dpnt_egd_shd.g_old_rec.col2_lookup_type
316: ,p_col1_value_set_id_o => ben_dpnt_egd_shd.g_old_rec.col1_value_set_id
317: ,p_access_table_name1_o => ben_dpnt_egd_shd.g_old_rec.access_table_name1
318: ,p_access_column_name1_o => ben_dpnt_egd_shd.g_old_rec.access_column_name1
319: ,p_time_entry_access_tab_nam1_o => ben_dpnt_egd_shd.g_old_rec.time_entry_access_tab_nam1
320: ,p_time_entry_access_col_nam1_o => ben_dpnt_egd_shd.g_old_rec.time_entry_access_col_nam1
321: ,p_crit_col2_val_type_cd_o => ben_dpnt_egd_shd.g_old_rec.crit_col2_val_type_cd
322: ,p_crit_col2_datatype_o => ben_dpnt_egd_shd.g_old_rec.crit_col2_datatype
323: ,p_col2_lookup_type_o => ben_dpnt_egd_shd.g_old_rec.col2_lookup_type
324: ,p_col2_value_set_id_o => ben_dpnt_egd_shd.g_old_rec.col2_value_set_id
317: ,p_access_table_name1_o => ben_dpnt_egd_shd.g_old_rec.access_table_name1
318: ,p_access_column_name1_o => ben_dpnt_egd_shd.g_old_rec.access_column_name1
319: ,p_time_entry_access_tab_nam1_o => ben_dpnt_egd_shd.g_old_rec.time_entry_access_tab_nam1
320: ,p_time_entry_access_col_nam1_o => ben_dpnt_egd_shd.g_old_rec.time_entry_access_col_nam1
321: ,p_crit_col2_val_type_cd_o => ben_dpnt_egd_shd.g_old_rec.crit_col2_val_type_cd
322: ,p_crit_col2_datatype_o => ben_dpnt_egd_shd.g_old_rec.crit_col2_datatype
323: ,p_col2_lookup_type_o => ben_dpnt_egd_shd.g_old_rec.col2_lookup_type
324: ,p_col2_value_set_id_o => ben_dpnt_egd_shd.g_old_rec.col2_value_set_id
325: ,p_access_table_name2_o => ben_dpnt_egd_shd.g_old_rec.access_table_name2
318: ,p_access_column_name1_o => ben_dpnt_egd_shd.g_old_rec.access_column_name1
319: ,p_time_entry_access_tab_nam1_o => ben_dpnt_egd_shd.g_old_rec.time_entry_access_tab_nam1
320: ,p_time_entry_access_col_nam1_o => ben_dpnt_egd_shd.g_old_rec.time_entry_access_col_nam1
321: ,p_crit_col2_val_type_cd_o => ben_dpnt_egd_shd.g_old_rec.crit_col2_val_type_cd
322: ,p_crit_col2_datatype_o => ben_dpnt_egd_shd.g_old_rec.crit_col2_datatype
323: ,p_col2_lookup_type_o => ben_dpnt_egd_shd.g_old_rec.col2_lookup_type
324: ,p_col2_value_set_id_o => ben_dpnt_egd_shd.g_old_rec.col2_value_set_id
325: ,p_access_table_name2_o => ben_dpnt_egd_shd.g_old_rec.access_table_name2
326: ,p_access_column_name2_o => ben_dpnt_egd_shd.g_old_rec.access_column_name2
319: ,p_time_entry_access_tab_nam1_o => ben_dpnt_egd_shd.g_old_rec.time_entry_access_tab_nam1
320: ,p_time_entry_access_col_nam1_o => ben_dpnt_egd_shd.g_old_rec.time_entry_access_col_nam1
321: ,p_crit_col2_val_type_cd_o => ben_dpnt_egd_shd.g_old_rec.crit_col2_val_type_cd
322: ,p_crit_col2_datatype_o => ben_dpnt_egd_shd.g_old_rec.crit_col2_datatype
323: ,p_col2_lookup_type_o => ben_dpnt_egd_shd.g_old_rec.col2_lookup_type
324: ,p_col2_value_set_id_o => ben_dpnt_egd_shd.g_old_rec.col2_value_set_id
325: ,p_access_table_name2_o => ben_dpnt_egd_shd.g_old_rec.access_table_name2
326: ,p_access_column_name2_o => ben_dpnt_egd_shd.g_old_rec.access_column_name2
327: ,p_time_entry_access_tab_nam2_o => ben_dpnt_egd_shd.g_old_rec.time_entry_access_tab_nam2
320: ,p_time_entry_access_col_nam1_o => ben_dpnt_egd_shd.g_old_rec.time_entry_access_col_nam1
321: ,p_crit_col2_val_type_cd_o => ben_dpnt_egd_shd.g_old_rec.crit_col2_val_type_cd
322: ,p_crit_col2_datatype_o => ben_dpnt_egd_shd.g_old_rec.crit_col2_datatype
323: ,p_col2_lookup_type_o => ben_dpnt_egd_shd.g_old_rec.col2_lookup_type
324: ,p_col2_value_set_id_o => ben_dpnt_egd_shd.g_old_rec.col2_value_set_id
325: ,p_access_table_name2_o => ben_dpnt_egd_shd.g_old_rec.access_table_name2
326: ,p_access_column_name2_o => ben_dpnt_egd_shd.g_old_rec.access_column_name2
327: ,p_time_entry_access_tab_nam2_o => ben_dpnt_egd_shd.g_old_rec.time_entry_access_tab_nam2
328: ,p_time_entry_access_col_nam2_o => ben_dpnt_egd_shd.g_old_rec.time_entry_access_col_nam2
321: ,p_crit_col2_val_type_cd_o => ben_dpnt_egd_shd.g_old_rec.crit_col2_val_type_cd
322: ,p_crit_col2_datatype_o => ben_dpnt_egd_shd.g_old_rec.crit_col2_datatype
323: ,p_col2_lookup_type_o => ben_dpnt_egd_shd.g_old_rec.col2_lookup_type
324: ,p_col2_value_set_id_o => ben_dpnt_egd_shd.g_old_rec.col2_value_set_id
325: ,p_access_table_name2_o => ben_dpnt_egd_shd.g_old_rec.access_table_name2
326: ,p_access_column_name2_o => ben_dpnt_egd_shd.g_old_rec.access_column_name2
327: ,p_time_entry_access_tab_nam2_o => ben_dpnt_egd_shd.g_old_rec.time_entry_access_tab_nam2
328: ,p_time_entry_access_col_nam2_o => ben_dpnt_egd_shd.g_old_rec.time_entry_access_col_nam2
329: ,p_allow_range_validation_flg_o => ben_dpnt_egd_shd.g_old_rec.allow_range_validation_flg
322: ,p_crit_col2_datatype_o => ben_dpnt_egd_shd.g_old_rec.crit_col2_datatype
323: ,p_col2_lookup_type_o => ben_dpnt_egd_shd.g_old_rec.col2_lookup_type
324: ,p_col2_value_set_id_o => ben_dpnt_egd_shd.g_old_rec.col2_value_set_id
325: ,p_access_table_name2_o => ben_dpnt_egd_shd.g_old_rec.access_table_name2
326: ,p_access_column_name2_o => ben_dpnt_egd_shd.g_old_rec.access_column_name2
327: ,p_time_entry_access_tab_nam2_o => ben_dpnt_egd_shd.g_old_rec.time_entry_access_tab_nam2
328: ,p_time_entry_access_col_nam2_o => ben_dpnt_egd_shd.g_old_rec.time_entry_access_col_nam2
329: ,p_allow_range_validation_flg_o => ben_dpnt_egd_shd.g_old_rec.allow_range_validation_flg
330: ,p_user_defined_flag_o => ben_dpnt_egd_shd.g_old_rec.user_defined_flag
323: ,p_col2_lookup_type_o => ben_dpnt_egd_shd.g_old_rec.col2_lookup_type
324: ,p_col2_value_set_id_o => ben_dpnt_egd_shd.g_old_rec.col2_value_set_id
325: ,p_access_table_name2_o => ben_dpnt_egd_shd.g_old_rec.access_table_name2
326: ,p_access_column_name2_o => ben_dpnt_egd_shd.g_old_rec.access_column_name2
327: ,p_time_entry_access_tab_nam2_o => ben_dpnt_egd_shd.g_old_rec.time_entry_access_tab_nam2
328: ,p_time_entry_access_col_nam2_o => ben_dpnt_egd_shd.g_old_rec.time_entry_access_col_nam2
329: ,p_allow_range_validation_flg_o => ben_dpnt_egd_shd.g_old_rec.allow_range_validation_flg
330: ,p_user_defined_flag_o => ben_dpnt_egd_shd.g_old_rec.user_defined_flag
331: ,p_business_group_id_o => ben_dpnt_egd_shd.g_old_rec.business_group_id
324: ,p_col2_value_set_id_o => ben_dpnt_egd_shd.g_old_rec.col2_value_set_id
325: ,p_access_table_name2_o => ben_dpnt_egd_shd.g_old_rec.access_table_name2
326: ,p_access_column_name2_o => ben_dpnt_egd_shd.g_old_rec.access_column_name2
327: ,p_time_entry_access_tab_nam2_o => ben_dpnt_egd_shd.g_old_rec.time_entry_access_tab_nam2
328: ,p_time_entry_access_col_nam2_o => ben_dpnt_egd_shd.g_old_rec.time_entry_access_col_nam2
329: ,p_allow_range_validation_flg_o => ben_dpnt_egd_shd.g_old_rec.allow_range_validation_flg
330: ,p_user_defined_flag_o => ben_dpnt_egd_shd.g_old_rec.user_defined_flag
331: ,p_business_group_id_o => ben_dpnt_egd_shd.g_old_rec.business_group_id
332: ,p_egd_attribute_category_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute_category
325: ,p_access_table_name2_o => ben_dpnt_egd_shd.g_old_rec.access_table_name2
326: ,p_access_column_name2_o => ben_dpnt_egd_shd.g_old_rec.access_column_name2
327: ,p_time_entry_access_tab_nam2_o => ben_dpnt_egd_shd.g_old_rec.time_entry_access_tab_nam2
328: ,p_time_entry_access_col_nam2_o => ben_dpnt_egd_shd.g_old_rec.time_entry_access_col_nam2
329: ,p_allow_range_validation_flg_o => ben_dpnt_egd_shd.g_old_rec.allow_range_validation_flg
330: ,p_user_defined_flag_o => ben_dpnt_egd_shd.g_old_rec.user_defined_flag
331: ,p_business_group_id_o => ben_dpnt_egd_shd.g_old_rec.business_group_id
332: ,p_egd_attribute_category_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute_category
333: ,p_egd_attribute1_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute1
326: ,p_access_column_name2_o => ben_dpnt_egd_shd.g_old_rec.access_column_name2
327: ,p_time_entry_access_tab_nam2_o => ben_dpnt_egd_shd.g_old_rec.time_entry_access_tab_nam2
328: ,p_time_entry_access_col_nam2_o => ben_dpnt_egd_shd.g_old_rec.time_entry_access_col_nam2
329: ,p_allow_range_validation_flg_o => ben_dpnt_egd_shd.g_old_rec.allow_range_validation_flg
330: ,p_user_defined_flag_o => ben_dpnt_egd_shd.g_old_rec.user_defined_flag
331: ,p_business_group_id_o => ben_dpnt_egd_shd.g_old_rec.business_group_id
332: ,p_egd_attribute_category_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute_category
333: ,p_egd_attribute1_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute1
334: ,p_egd_attribute2_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute2
327: ,p_time_entry_access_tab_nam2_o => ben_dpnt_egd_shd.g_old_rec.time_entry_access_tab_nam2
328: ,p_time_entry_access_col_nam2_o => ben_dpnt_egd_shd.g_old_rec.time_entry_access_col_nam2
329: ,p_allow_range_validation_flg_o => ben_dpnt_egd_shd.g_old_rec.allow_range_validation_flg
330: ,p_user_defined_flag_o => ben_dpnt_egd_shd.g_old_rec.user_defined_flag
331: ,p_business_group_id_o => ben_dpnt_egd_shd.g_old_rec.business_group_id
332: ,p_egd_attribute_category_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute_category
333: ,p_egd_attribute1_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute1
334: ,p_egd_attribute2_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute2
335: ,p_egd_attribute3_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute3
328: ,p_time_entry_access_col_nam2_o => ben_dpnt_egd_shd.g_old_rec.time_entry_access_col_nam2
329: ,p_allow_range_validation_flg_o => ben_dpnt_egd_shd.g_old_rec.allow_range_validation_flg
330: ,p_user_defined_flag_o => ben_dpnt_egd_shd.g_old_rec.user_defined_flag
331: ,p_business_group_id_o => ben_dpnt_egd_shd.g_old_rec.business_group_id
332: ,p_egd_attribute_category_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute_category
333: ,p_egd_attribute1_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute1
334: ,p_egd_attribute2_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute2
335: ,p_egd_attribute3_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute3
336: ,p_egd_attribute4_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute4
329: ,p_allow_range_validation_flg_o => ben_dpnt_egd_shd.g_old_rec.allow_range_validation_flg
330: ,p_user_defined_flag_o => ben_dpnt_egd_shd.g_old_rec.user_defined_flag
331: ,p_business_group_id_o => ben_dpnt_egd_shd.g_old_rec.business_group_id
332: ,p_egd_attribute_category_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute_category
333: ,p_egd_attribute1_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute1
334: ,p_egd_attribute2_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute2
335: ,p_egd_attribute3_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute3
336: ,p_egd_attribute4_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute4
337: ,p_egd_attribute5_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute5
330: ,p_user_defined_flag_o => ben_dpnt_egd_shd.g_old_rec.user_defined_flag
331: ,p_business_group_id_o => ben_dpnt_egd_shd.g_old_rec.business_group_id
332: ,p_egd_attribute_category_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute_category
333: ,p_egd_attribute1_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute1
334: ,p_egd_attribute2_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute2
335: ,p_egd_attribute3_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute3
336: ,p_egd_attribute4_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute4
337: ,p_egd_attribute5_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute5
338: ,p_egd_attribute6_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute6
331: ,p_business_group_id_o => ben_dpnt_egd_shd.g_old_rec.business_group_id
332: ,p_egd_attribute_category_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute_category
333: ,p_egd_attribute1_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute1
334: ,p_egd_attribute2_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute2
335: ,p_egd_attribute3_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute3
336: ,p_egd_attribute4_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute4
337: ,p_egd_attribute5_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute5
338: ,p_egd_attribute6_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute6
339: ,p_egd_attribute7_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute7
332: ,p_egd_attribute_category_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute_category
333: ,p_egd_attribute1_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute1
334: ,p_egd_attribute2_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute2
335: ,p_egd_attribute3_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute3
336: ,p_egd_attribute4_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute4
337: ,p_egd_attribute5_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute5
338: ,p_egd_attribute6_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute6
339: ,p_egd_attribute7_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute7
340: ,p_egd_attribute8_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute8
333: ,p_egd_attribute1_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute1
334: ,p_egd_attribute2_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute2
335: ,p_egd_attribute3_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute3
336: ,p_egd_attribute4_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute4
337: ,p_egd_attribute5_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute5
338: ,p_egd_attribute6_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute6
339: ,p_egd_attribute7_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute7
340: ,p_egd_attribute8_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute8
341: ,p_egd_attribute9_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute9
334: ,p_egd_attribute2_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute2
335: ,p_egd_attribute3_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute3
336: ,p_egd_attribute4_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute4
337: ,p_egd_attribute5_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute5
338: ,p_egd_attribute6_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute6
339: ,p_egd_attribute7_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute7
340: ,p_egd_attribute8_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute8
341: ,p_egd_attribute9_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute9
342: ,p_egd_attribute10_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute10
335: ,p_egd_attribute3_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute3
336: ,p_egd_attribute4_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute4
337: ,p_egd_attribute5_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute5
338: ,p_egd_attribute6_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute6
339: ,p_egd_attribute7_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute7
340: ,p_egd_attribute8_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute8
341: ,p_egd_attribute9_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute9
342: ,p_egd_attribute10_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute10
343: ,p_egd_attribute11_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute11
336: ,p_egd_attribute4_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute4
337: ,p_egd_attribute5_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute5
338: ,p_egd_attribute6_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute6
339: ,p_egd_attribute7_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute7
340: ,p_egd_attribute8_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute8
341: ,p_egd_attribute9_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute9
342: ,p_egd_attribute10_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute10
343: ,p_egd_attribute11_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute11
344: ,p_egd_attribute12_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute12
337: ,p_egd_attribute5_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute5
338: ,p_egd_attribute6_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute6
339: ,p_egd_attribute7_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute7
340: ,p_egd_attribute8_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute8
341: ,p_egd_attribute9_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute9
342: ,p_egd_attribute10_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute10
343: ,p_egd_attribute11_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute11
344: ,p_egd_attribute12_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute12
345: ,p_egd_attribute13_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute13
338: ,p_egd_attribute6_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute6
339: ,p_egd_attribute7_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute7
340: ,p_egd_attribute8_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute8
341: ,p_egd_attribute9_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute9
342: ,p_egd_attribute10_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute10
343: ,p_egd_attribute11_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute11
344: ,p_egd_attribute12_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute12
345: ,p_egd_attribute13_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute13
346: ,p_egd_attribute14_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute14
339: ,p_egd_attribute7_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute7
340: ,p_egd_attribute8_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute8
341: ,p_egd_attribute9_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute9
342: ,p_egd_attribute10_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute10
343: ,p_egd_attribute11_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute11
344: ,p_egd_attribute12_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute12
345: ,p_egd_attribute13_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute13
346: ,p_egd_attribute14_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute14
347: ,p_egd_attribute15_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute15
340: ,p_egd_attribute8_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute8
341: ,p_egd_attribute9_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute9
342: ,p_egd_attribute10_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute10
343: ,p_egd_attribute11_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute11
344: ,p_egd_attribute12_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute12
345: ,p_egd_attribute13_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute13
346: ,p_egd_attribute14_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute14
347: ,p_egd_attribute15_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute15
348: ,p_egd_attribute16_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute16
341: ,p_egd_attribute9_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute9
342: ,p_egd_attribute10_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute10
343: ,p_egd_attribute11_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute11
344: ,p_egd_attribute12_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute12
345: ,p_egd_attribute13_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute13
346: ,p_egd_attribute14_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute14
347: ,p_egd_attribute15_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute15
348: ,p_egd_attribute16_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute16
349: ,p_egd_attribute17_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute17
342: ,p_egd_attribute10_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute10
343: ,p_egd_attribute11_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute11
344: ,p_egd_attribute12_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute12
345: ,p_egd_attribute13_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute13
346: ,p_egd_attribute14_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute14
347: ,p_egd_attribute15_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute15
348: ,p_egd_attribute16_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute16
349: ,p_egd_attribute17_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute17
350: ,p_egd_attribute18_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute18
343: ,p_egd_attribute11_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute11
344: ,p_egd_attribute12_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute12
345: ,p_egd_attribute13_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute13
346: ,p_egd_attribute14_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute14
347: ,p_egd_attribute15_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute15
348: ,p_egd_attribute16_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute16
349: ,p_egd_attribute17_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute17
350: ,p_egd_attribute18_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute18
351: ,p_egd_attribute19_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute19
344: ,p_egd_attribute12_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute12
345: ,p_egd_attribute13_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute13
346: ,p_egd_attribute14_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute14
347: ,p_egd_attribute15_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute15
348: ,p_egd_attribute16_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute16
349: ,p_egd_attribute17_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute17
350: ,p_egd_attribute18_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute18
351: ,p_egd_attribute19_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute19
352: ,p_egd_attribute20_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute20
345: ,p_egd_attribute13_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute13
346: ,p_egd_attribute14_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute14
347: ,p_egd_attribute15_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute15
348: ,p_egd_attribute16_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute16
349: ,p_egd_attribute17_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute17
350: ,p_egd_attribute18_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute18
351: ,p_egd_attribute19_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute19
352: ,p_egd_attribute20_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute20
353: ,p_egd_attribute21_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute21
346: ,p_egd_attribute14_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute14
347: ,p_egd_attribute15_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute15
348: ,p_egd_attribute16_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute16
349: ,p_egd_attribute17_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute17
350: ,p_egd_attribute18_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute18
351: ,p_egd_attribute19_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute19
352: ,p_egd_attribute20_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute20
353: ,p_egd_attribute21_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute21
354: ,p_egd_attribute22_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute22
347: ,p_egd_attribute15_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute15
348: ,p_egd_attribute16_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute16
349: ,p_egd_attribute17_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute17
350: ,p_egd_attribute18_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute18
351: ,p_egd_attribute19_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute19
352: ,p_egd_attribute20_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute20
353: ,p_egd_attribute21_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute21
354: ,p_egd_attribute22_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute22
355: ,p_egd_attribute23_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute23
348: ,p_egd_attribute16_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute16
349: ,p_egd_attribute17_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute17
350: ,p_egd_attribute18_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute18
351: ,p_egd_attribute19_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute19
352: ,p_egd_attribute20_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute20
353: ,p_egd_attribute21_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute21
354: ,p_egd_attribute22_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute22
355: ,p_egd_attribute23_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute23
356: ,p_egd_attribute24_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute24
349: ,p_egd_attribute17_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute17
350: ,p_egd_attribute18_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute18
351: ,p_egd_attribute19_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute19
352: ,p_egd_attribute20_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute20
353: ,p_egd_attribute21_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute21
354: ,p_egd_attribute22_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute22
355: ,p_egd_attribute23_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute23
356: ,p_egd_attribute24_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute24
357: ,p_egd_attribute25_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute25
350: ,p_egd_attribute18_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute18
351: ,p_egd_attribute19_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute19
352: ,p_egd_attribute20_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute20
353: ,p_egd_attribute21_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute21
354: ,p_egd_attribute22_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute22
355: ,p_egd_attribute23_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute23
356: ,p_egd_attribute24_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute24
357: ,p_egd_attribute25_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute25
358: ,p_egd_attribute26_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute26
351: ,p_egd_attribute19_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute19
352: ,p_egd_attribute20_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute20
353: ,p_egd_attribute21_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute21
354: ,p_egd_attribute22_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute22
355: ,p_egd_attribute23_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute23
356: ,p_egd_attribute24_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute24
357: ,p_egd_attribute25_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute25
358: ,p_egd_attribute26_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute26
359: ,p_egd_attribute27_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute27
352: ,p_egd_attribute20_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute20
353: ,p_egd_attribute21_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute21
354: ,p_egd_attribute22_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute22
355: ,p_egd_attribute23_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute23
356: ,p_egd_attribute24_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute24
357: ,p_egd_attribute25_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute25
358: ,p_egd_attribute26_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute26
359: ,p_egd_attribute27_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute27
360: ,p_egd_attribute28_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute28
353: ,p_egd_attribute21_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute21
354: ,p_egd_attribute22_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute22
355: ,p_egd_attribute23_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute23
356: ,p_egd_attribute24_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute24
357: ,p_egd_attribute25_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute25
358: ,p_egd_attribute26_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute26
359: ,p_egd_attribute27_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute27
360: ,p_egd_attribute28_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute28
361: ,p_egd_attribute29_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute29
354: ,p_egd_attribute22_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute22
355: ,p_egd_attribute23_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute23
356: ,p_egd_attribute24_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute24
357: ,p_egd_attribute25_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute25
358: ,p_egd_attribute26_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute26
359: ,p_egd_attribute27_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute27
360: ,p_egd_attribute28_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute28
361: ,p_egd_attribute29_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute29
362: ,p_egd_attribute30_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute30
355: ,p_egd_attribute23_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute23
356: ,p_egd_attribute24_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute24
357: ,p_egd_attribute25_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute25
358: ,p_egd_attribute26_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute26
359: ,p_egd_attribute27_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute27
360: ,p_egd_attribute28_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute28
361: ,p_egd_attribute29_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute29
362: ,p_egd_attribute30_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute30
363: ,p_object_version_number_o => ben_dpnt_egd_shd.g_old_rec.object_version_number
356: ,p_egd_attribute24_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute24
357: ,p_egd_attribute25_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute25
358: ,p_egd_attribute26_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute26
359: ,p_egd_attribute27_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute27
360: ,p_egd_attribute28_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute28
361: ,p_egd_attribute29_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute29
362: ,p_egd_attribute30_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute30
363: ,p_object_version_number_o => ben_dpnt_egd_shd.g_old_rec.object_version_number
364: ,p_allw_range_validation_flg2_o => ben_dpnt_egd_shd.g_old_rec.allow_range_validation_flag2
357: ,p_egd_attribute25_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute25
358: ,p_egd_attribute26_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute26
359: ,p_egd_attribute27_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute27
360: ,p_egd_attribute28_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute28
361: ,p_egd_attribute29_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute29
362: ,p_egd_attribute30_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute30
363: ,p_object_version_number_o => ben_dpnt_egd_shd.g_old_rec.object_version_number
364: ,p_allw_range_validation_flg2_o => ben_dpnt_egd_shd.g_old_rec.allow_range_validation_flag2
365: ,p_time_access_calc_rule1_o => ben_dpnt_egd_shd.g_old_rec.time_access_calc_rule1
358: ,p_egd_attribute26_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute26
359: ,p_egd_attribute27_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute27
360: ,p_egd_attribute28_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute28
361: ,p_egd_attribute29_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute29
362: ,p_egd_attribute30_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute30
363: ,p_object_version_number_o => ben_dpnt_egd_shd.g_old_rec.object_version_number
364: ,p_allw_range_validation_flg2_o => ben_dpnt_egd_shd.g_old_rec.allow_range_validation_flag2
365: ,p_time_access_calc_rule1_o => ben_dpnt_egd_shd.g_old_rec.time_access_calc_rule1
366: ,p_time_access_calc_rule2_o => ben_dpnt_egd_shd.g_old_rec.time_access_calc_rule2
359: ,p_egd_attribute27_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute27
360: ,p_egd_attribute28_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute28
361: ,p_egd_attribute29_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute29
362: ,p_egd_attribute30_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute30
363: ,p_object_version_number_o => ben_dpnt_egd_shd.g_old_rec.object_version_number
364: ,p_allw_range_validation_flg2_o => ben_dpnt_egd_shd.g_old_rec.allow_range_validation_flag2
365: ,p_time_access_calc_rule1_o => ben_dpnt_egd_shd.g_old_rec.time_access_calc_rule1
366: ,p_time_access_calc_rule2_o => ben_dpnt_egd_shd.g_old_rec.time_access_calc_rule2
367: );
360: ,p_egd_attribute28_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute28
361: ,p_egd_attribute29_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute29
362: ,p_egd_attribute30_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute30
363: ,p_object_version_number_o => ben_dpnt_egd_shd.g_old_rec.object_version_number
364: ,p_allw_range_validation_flg2_o => ben_dpnt_egd_shd.g_old_rec.allow_range_validation_flag2
365: ,p_time_access_calc_rule1_o => ben_dpnt_egd_shd.g_old_rec.time_access_calc_rule1
366: ,p_time_access_calc_rule2_o => ben_dpnt_egd_shd.g_old_rec.time_access_calc_rule2
367: );
368: --
361: ,p_egd_attribute29_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute29
362: ,p_egd_attribute30_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute30
363: ,p_object_version_number_o => ben_dpnt_egd_shd.g_old_rec.object_version_number
364: ,p_allw_range_validation_flg2_o => ben_dpnt_egd_shd.g_old_rec.allow_range_validation_flag2
365: ,p_time_access_calc_rule1_o => ben_dpnt_egd_shd.g_old_rec.time_access_calc_rule1
366: ,p_time_access_calc_rule2_o => ben_dpnt_egd_shd.g_old_rec.time_access_calc_rule2
367: );
368: --
369: exception
362: ,p_egd_attribute30_o => ben_dpnt_egd_shd.g_old_rec.egd_attribute30
363: ,p_object_version_number_o => ben_dpnt_egd_shd.g_old_rec.object_version_number
364: ,p_allw_range_validation_flg2_o => ben_dpnt_egd_shd.g_old_rec.allow_range_validation_flag2
365: ,p_time_access_calc_rule1_o => ben_dpnt_egd_shd.g_old_rec.time_access_calc_rule1
366: ,p_time_access_calc_rule2_o => ben_dpnt_egd_shd.g_old_rec.time_access_calc_rule2
367: );
368: --
369: exception
370: --
424: -- Internal Row Handler Use Only.
425: --
426: -- {End Of Comments}
427: -- ----------------------------------------------------------------------------
428: Procedure convert_defs(p_rec in out nocopy ben_dpnt_egd_shd.g_rec_type) is
429: --
430: l_proc varchar2(72) := g_package||'convert_defs';
431: --
432: Begin
440: --
441:
442: If (p_rec.name = hr_api.g_varchar2) then
443: p_rec.name :=
444: ben_dpnt_egd_shd.g_old_rec.name;
445: End If;
446: If (p_rec.short_code = hr_api.g_varchar2) then
447: p_rec.short_code :=
448: ben_dpnt_egd_shd.g_old_rec.short_code;
444: ben_dpnt_egd_shd.g_old_rec.name;
445: End If;
446: If (p_rec.short_code = hr_api.g_varchar2) then
447: p_rec.short_code :=
448: ben_dpnt_egd_shd.g_old_rec.short_code;
449: End If;
450: If (p_rec.description = hr_api.g_varchar2) then
451: p_rec.description :=
452: ben_dpnt_egd_shd.g_old_rec.description;
448: ben_dpnt_egd_shd.g_old_rec.short_code;
449: End If;
450: If (p_rec.description = hr_api.g_varchar2) then
451: p_rec.description :=
452: ben_dpnt_egd_shd.g_old_rec.description;
453: End If;
454: If (p_rec.criteria_type = hr_api.g_varchar2) then
455: p_rec.criteria_type :=
456: ben_dpnt_egd_shd.g_old_rec.criteria_type;
452: ben_dpnt_egd_shd.g_old_rec.description;
453: End If;
454: If (p_rec.criteria_type = hr_api.g_varchar2) then
455: p_rec.criteria_type :=
456: ben_dpnt_egd_shd.g_old_rec.criteria_type;
457: End If;
458: If (p_rec.crit_col1_val_type_cd = hr_api.g_varchar2) then
459: p_rec.crit_col1_val_type_cd :=
460: ben_dpnt_egd_shd.g_old_rec.crit_col1_val_type_cd;
456: ben_dpnt_egd_shd.g_old_rec.criteria_type;
457: End If;
458: If (p_rec.crit_col1_val_type_cd = hr_api.g_varchar2) then
459: p_rec.crit_col1_val_type_cd :=
460: ben_dpnt_egd_shd.g_old_rec.crit_col1_val_type_cd;
461: End If;
462: If (p_rec.crit_col1_datatype = hr_api.g_varchar2) then
463: p_rec.crit_col1_datatype :=
464: ben_dpnt_egd_shd.g_old_rec.crit_col1_datatype;
460: ben_dpnt_egd_shd.g_old_rec.crit_col1_val_type_cd;
461: End If;
462: If (p_rec.crit_col1_datatype = hr_api.g_varchar2) then
463: p_rec.crit_col1_datatype :=
464: ben_dpnt_egd_shd.g_old_rec.crit_col1_datatype;
465: End If;
466: If (p_rec.col1_lookup_type = hr_api.g_varchar2) then
467: p_rec.col1_lookup_type :=
468: ben_dpnt_egd_shd.g_old_rec.col1_lookup_type;
464: ben_dpnt_egd_shd.g_old_rec.crit_col1_datatype;
465: End If;
466: If (p_rec.col1_lookup_type = hr_api.g_varchar2) then
467: p_rec.col1_lookup_type :=
468: ben_dpnt_egd_shd.g_old_rec.col1_lookup_type;
469: End If;
470: If (p_rec.col1_value_set_id = hr_api.g_number) then
471: p_rec.col1_value_set_id :=
472: ben_dpnt_egd_shd.g_old_rec.col1_value_set_id;
468: ben_dpnt_egd_shd.g_old_rec.col1_lookup_type;
469: End If;
470: If (p_rec.col1_value_set_id = hr_api.g_number) then
471: p_rec.col1_value_set_id :=
472: ben_dpnt_egd_shd.g_old_rec.col1_value_set_id;
473: End If;
474: If (p_rec.access_table_name1 = hr_api.g_varchar2) then
475: p_rec.access_table_name1 :=
476: ben_dpnt_egd_shd.g_old_rec.access_table_name1;
472: ben_dpnt_egd_shd.g_old_rec.col1_value_set_id;
473: End If;
474: If (p_rec.access_table_name1 = hr_api.g_varchar2) then
475: p_rec.access_table_name1 :=
476: ben_dpnt_egd_shd.g_old_rec.access_table_name1;
477: End If;
478: If (p_rec.access_column_name1 = hr_api.g_varchar2) then
479: p_rec.access_column_name1 :=
480: ben_dpnt_egd_shd.g_old_rec.access_column_name1;
476: ben_dpnt_egd_shd.g_old_rec.access_table_name1;
477: End If;
478: If (p_rec.access_column_name1 = hr_api.g_varchar2) then
479: p_rec.access_column_name1 :=
480: ben_dpnt_egd_shd.g_old_rec.access_column_name1;
481: End If;
482: If (p_rec.time_entry_access_tab_nam1 = hr_api.g_varchar2) then
483: p_rec.time_entry_access_tab_nam1 :=
484: ben_dpnt_egd_shd.g_old_rec.time_entry_access_tab_nam1;
480: ben_dpnt_egd_shd.g_old_rec.access_column_name1;
481: End If;
482: If (p_rec.time_entry_access_tab_nam1 = hr_api.g_varchar2) then
483: p_rec.time_entry_access_tab_nam1 :=
484: ben_dpnt_egd_shd.g_old_rec.time_entry_access_tab_nam1;
485: End If;
486: If (p_rec.time_entry_access_col_nam1 = hr_api.g_varchar2) then
487: p_rec.time_entry_access_col_nam1 :=
488: ben_dpnt_egd_shd.g_old_rec.time_entry_access_col_nam1;
484: ben_dpnt_egd_shd.g_old_rec.time_entry_access_tab_nam1;
485: End If;
486: If (p_rec.time_entry_access_col_nam1 = hr_api.g_varchar2) then
487: p_rec.time_entry_access_col_nam1 :=
488: ben_dpnt_egd_shd.g_old_rec.time_entry_access_col_nam1;
489: End If;
490: If (p_rec.crit_col2_val_type_cd = hr_api.g_varchar2) then
491: p_rec.crit_col2_val_type_cd :=
492: ben_dpnt_egd_shd.g_old_rec.crit_col2_val_type_cd;
488: ben_dpnt_egd_shd.g_old_rec.time_entry_access_col_nam1;
489: End If;
490: If (p_rec.crit_col2_val_type_cd = hr_api.g_varchar2) then
491: p_rec.crit_col2_val_type_cd :=
492: ben_dpnt_egd_shd.g_old_rec.crit_col2_val_type_cd;
493: End If;
494: If (p_rec.crit_col2_datatype = hr_api.g_varchar2) then
495: p_rec.crit_col2_datatype :=
496: ben_dpnt_egd_shd.g_old_rec.crit_col2_datatype;
492: ben_dpnt_egd_shd.g_old_rec.crit_col2_val_type_cd;
493: End If;
494: If (p_rec.crit_col2_datatype = hr_api.g_varchar2) then
495: p_rec.crit_col2_datatype :=
496: ben_dpnt_egd_shd.g_old_rec.crit_col2_datatype;
497: End If;
498: If (p_rec.col2_lookup_type = hr_api.g_varchar2) then
499: p_rec.col2_lookup_type :=
500: ben_dpnt_egd_shd.g_old_rec.col2_lookup_type;
496: ben_dpnt_egd_shd.g_old_rec.crit_col2_datatype;
497: End If;
498: If (p_rec.col2_lookup_type = hr_api.g_varchar2) then
499: p_rec.col2_lookup_type :=
500: ben_dpnt_egd_shd.g_old_rec.col2_lookup_type;
501: End If;
502: If (p_rec.col2_value_set_id = hr_api.g_number) then
503: p_rec.col2_value_set_id :=
504: ben_dpnt_egd_shd.g_old_rec.col2_value_set_id;
500: ben_dpnt_egd_shd.g_old_rec.col2_lookup_type;
501: End If;
502: If (p_rec.col2_value_set_id = hr_api.g_number) then
503: p_rec.col2_value_set_id :=
504: ben_dpnt_egd_shd.g_old_rec.col2_value_set_id;
505: End If;
506: If (p_rec.access_table_name2 = hr_api.g_varchar2) then
507: p_rec.access_table_name2 :=
508: ben_dpnt_egd_shd.g_old_rec.access_table_name2;
504: ben_dpnt_egd_shd.g_old_rec.col2_value_set_id;
505: End If;
506: If (p_rec.access_table_name2 = hr_api.g_varchar2) then
507: p_rec.access_table_name2 :=
508: ben_dpnt_egd_shd.g_old_rec.access_table_name2;
509: End If;
510: If (p_rec.access_column_name2 = hr_api.g_varchar2) then
511: p_rec.access_column_name2 :=
512: ben_dpnt_egd_shd.g_old_rec.access_column_name2;
508: ben_dpnt_egd_shd.g_old_rec.access_table_name2;
509: End If;
510: If (p_rec.access_column_name2 = hr_api.g_varchar2) then
511: p_rec.access_column_name2 :=
512: ben_dpnt_egd_shd.g_old_rec.access_column_name2;
513: End If;
514: If (p_rec.time_entry_access_tab_nam2 = hr_api.g_varchar2) then
515: p_rec.time_entry_access_tab_nam2 :=
516: ben_dpnt_egd_shd.g_old_rec.time_entry_access_tab_nam2;
512: ben_dpnt_egd_shd.g_old_rec.access_column_name2;
513: End If;
514: If (p_rec.time_entry_access_tab_nam2 = hr_api.g_varchar2) then
515: p_rec.time_entry_access_tab_nam2 :=
516: ben_dpnt_egd_shd.g_old_rec.time_entry_access_tab_nam2;
517: End If;
518: If (p_rec.time_entry_access_col_nam2 = hr_api.g_varchar2) then
519: p_rec.time_entry_access_col_nam2 :=
520: ben_dpnt_egd_shd.g_old_rec.time_entry_access_col_nam2;
516: ben_dpnt_egd_shd.g_old_rec.time_entry_access_tab_nam2;
517: End If;
518: If (p_rec.time_entry_access_col_nam2 = hr_api.g_varchar2) then
519: p_rec.time_entry_access_col_nam2 :=
520: ben_dpnt_egd_shd.g_old_rec.time_entry_access_col_nam2;
521: End If;
522: If (p_rec.allow_range_validation_flg = hr_api.g_varchar2) then
523: p_rec.allow_range_validation_flg :=
524: ben_dpnt_egd_shd.g_old_rec.allow_range_validation_flg;
520: ben_dpnt_egd_shd.g_old_rec.time_entry_access_col_nam2;
521: End If;
522: If (p_rec.allow_range_validation_flg = hr_api.g_varchar2) then
523: p_rec.allow_range_validation_flg :=
524: ben_dpnt_egd_shd.g_old_rec.allow_range_validation_flg;
525: End If;
526: If (p_rec.user_defined_flag = hr_api.g_varchar2) then
527: p_rec.user_defined_flag :=
528: ben_dpnt_egd_shd.g_old_rec.user_defined_flag;
524: ben_dpnt_egd_shd.g_old_rec.allow_range_validation_flg;
525: End If;
526: If (p_rec.user_defined_flag = hr_api.g_varchar2) then
527: p_rec.user_defined_flag :=
528: ben_dpnt_egd_shd.g_old_rec.user_defined_flag;
529: End If;
530: If (p_rec.business_group_id = hr_api.g_number) then
531: p_rec.business_group_id :=
532: ben_dpnt_egd_shd.g_old_rec.business_group_id;
528: ben_dpnt_egd_shd.g_old_rec.user_defined_flag;
529: End If;
530: If (p_rec.business_group_id = hr_api.g_number) then
531: p_rec.business_group_id :=
532: ben_dpnt_egd_shd.g_old_rec.business_group_id;
533: End If;
534:
535: If (p_rec.egd_attribute_category = hr_api.g_varchar2) then
536: p_rec.egd_attribute_category :=
533: End If;
534:
535: If (p_rec.egd_attribute_category = hr_api.g_varchar2) then
536: p_rec.egd_attribute_category :=
537: ben_dpnt_egd_shd.g_old_rec.egd_attribute_category;
538: End If;
539: If (p_rec.egd_attribute1 = hr_api.g_varchar2) then
540: p_rec.egd_attribute1 :=
541: ben_dpnt_egd_shd.g_old_rec.egd_attribute1;
537: ben_dpnt_egd_shd.g_old_rec.egd_attribute_category;
538: End If;
539: If (p_rec.egd_attribute1 = hr_api.g_varchar2) then
540: p_rec.egd_attribute1 :=
541: ben_dpnt_egd_shd.g_old_rec.egd_attribute1;
542: End If;
543: If (p_rec.egd_attribute2 = hr_api.g_varchar2) then
544: p_rec.egd_attribute2 :=
545: ben_dpnt_egd_shd.g_old_rec.egd_attribute2;
541: ben_dpnt_egd_shd.g_old_rec.egd_attribute1;
542: End If;
543: If (p_rec.egd_attribute2 = hr_api.g_varchar2) then
544: p_rec.egd_attribute2 :=
545: ben_dpnt_egd_shd.g_old_rec.egd_attribute2;
546: End If;
547: If (p_rec.egd_attribute3 = hr_api.g_varchar2) then
548: p_rec.egd_attribute3 :=
549: ben_dpnt_egd_shd.g_old_rec.egd_attribute3;
545: ben_dpnt_egd_shd.g_old_rec.egd_attribute2;
546: End If;
547: If (p_rec.egd_attribute3 = hr_api.g_varchar2) then
548: p_rec.egd_attribute3 :=
549: ben_dpnt_egd_shd.g_old_rec.egd_attribute3;
550: End If;
551: If (p_rec.egd_attribute4 = hr_api.g_varchar2) then
552: p_rec.egd_attribute4 :=
553: ben_dpnt_egd_shd.g_old_rec.egd_attribute4;
549: ben_dpnt_egd_shd.g_old_rec.egd_attribute3;
550: End If;
551: If (p_rec.egd_attribute4 = hr_api.g_varchar2) then
552: p_rec.egd_attribute4 :=
553: ben_dpnt_egd_shd.g_old_rec.egd_attribute4;
554: End If;
555: If (p_rec.egd_attribute5 = hr_api.g_varchar2) then
556: p_rec.egd_attribute5 :=
557: ben_dpnt_egd_shd.g_old_rec.egd_attribute5;
553: ben_dpnt_egd_shd.g_old_rec.egd_attribute4;
554: End If;
555: If (p_rec.egd_attribute5 = hr_api.g_varchar2) then
556: p_rec.egd_attribute5 :=
557: ben_dpnt_egd_shd.g_old_rec.egd_attribute5;
558: End If;
559: If (p_rec.egd_attribute6 = hr_api.g_varchar2) then
560: p_rec.egd_attribute6 :=
561: ben_dpnt_egd_shd.g_old_rec.egd_attribute6;
557: ben_dpnt_egd_shd.g_old_rec.egd_attribute5;
558: End If;
559: If (p_rec.egd_attribute6 = hr_api.g_varchar2) then
560: p_rec.egd_attribute6 :=
561: ben_dpnt_egd_shd.g_old_rec.egd_attribute6;
562: End If;
563: If (p_rec.egd_attribute7 = hr_api.g_varchar2) then
564: p_rec.egd_attribute7 :=
565: ben_dpnt_egd_shd.g_old_rec.egd_attribute7;
561: ben_dpnt_egd_shd.g_old_rec.egd_attribute6;
562: End If;
563: If (p_rec.egd_attribute7 = hr_api.g_varchar2) then
564: p_rec.egd_attribute7 :=
565: ben_dpnt_egd_shd.g_old_rec.egd_attribute7;
566: End If;
567: If (p_rec.egd_attribute8 = hr_api.g_varchar2) then
568: p_rec.egd_attribute8 :=
569: ben_dpnt_egd_shd.g_old_rec.egd_attribute8;
565: ben_dpnt_egd_shd.g_old_rec.egd_attribute7;
566: End If;
567: If (p_rec.egd_attribute8 = hr_api.g_varchar2) then
568: p_rec.egd_attribute8 :=
569: ben_dpnt_egd_shd.g_old_rec.egd_attribute8;
570: End If;
571: If (p_rec.egd_attribute9 = hr_api.g_varchar2) then
572: p_rec.egd_attribute9 :=
573: ben_dpnt_egd_shd.g_old_rec.egd_attribute9;
569: ben_dpnt_egd_shd.g_old_rec.egd_attribute8;
570: End If;
571: If (p_rec.egd_attribute9 = hr_api.g_varchar2) then
572: p_rec.egd_attribute9 :=
573: ben_dpnt_egd_shd.g_old_rec.egd_attribute9;
574: End If;
575: If (p_rec.egd_attribute10 = hr_api.g_varchar2) then
576: p_rec.egd_attribute10 :=
577: ben_dpnt_egd_shd.g_old_rec.egd_attribute10;
573: ben_dpnt_egd_shd.g_old_rec.egd_attribute9;
574: End If;
575: If (p_rec.egd_attribute10 = hr_api.g_varchar2) then
576: p_rec.egd_attribute10 :=
577: ben_dpnt_egd_shd.g_old_rec.egd_attribute10;
578: End If;
579: If (p_rec.egd_attribute11 = hr_api.g_varchar2) then
580: p_rec.egd_attribute11 :=
581: ben_dpnt_egd_shd.g_old_rec.egd_attribute11;
577: ben_dpnt_egd_shd.g_old_rec.egd_attribute10;
578: End If;
579: If (p_rec.egd_attribute11 = hr_api.g_varchar2) then
580: p_rec.egd_attribute11 :=
581: ben_dpnt_egd_shd.g_old_rec.egd_attribute11;
582: End If;
583: If (p_rec.egd_attribute12 = hr_api.g_varchar2) then
584: p_rec.egd_attribute12 :=
585: ben_dpnt_egd_shd.g_old_rec.egd_attribute12;
581: ben_dpnt_egd_shd.g_old_rec.egd_attribute11;
582: End If;
583: If (p_rec.egd_attribute12 = hr_api.g_varchar2) then
584: p_rec.egd_attribute12 :=
585: ben_dpnt_egd_shd.g_old_rec.egd_attribute12;
586: End If;
587: If (p_rec.egd_attribute13 = hr_api.g_varchar2) then
588: p_rec.egd_attribute13 :=
589: ben_dpnt_egd_shd.g_old_rec.egd_attribute13;
585: ben_dpnt_egd_shd.g_old_rec.egd_attribute12;
586: End If;
587: If (p_rec.egd_attribute13 = hr_api.g_varchar2) then
588: p_rec.egd_attribute13 :=
589: ben_dpnt_egd_shd.g_old_rec.egd_attribute13;
590: End If;
591: If (p_rec.egd_attribute14 = hr_api.g_varchar2) then
592: p_rec.egd_attribute14 :=
593: ben_dpnt_egd_shd.g_old_rec.egd_attribute14;
589: ben_dpnt_egd_shd.g_old_rec.egd_attribute13;
590: End If;
591: If (p_rec.egd_attribute14 = hr_api.g_varchar2) then
592: p_rec.egd_attribute14 :=
593: ben_dpnt_egd_shd.g_old_rec.egd_attribute14;
594: End If;
595: If (p_rec.egd_attribute15 = hr_api.g_varchar2) then
596: p_rec.egd_attribute15 :=
597: ben_dpnt_egd_shd.g_old_rec.egd_attribute15;
593: ben_dpnt_egd_shd.g_old_rec.egd_attribute14;
594: End If;
595: If (p_rec.egd_attribute15 = hr_api.g_varchar2) then
596: p_rec.egd_attribute15 :=
597: ben_dpnt_egd_shd.g_old_rec.egd_attribute15;
598: End If;
599: If (p_rec.egd_attribute16 = hr_api.g_varchar2) then
600: p_rec.egd_attribute16 :=
601: ben_dpnt_egd_shd.g_old_rec.egd_attribute16;
597: ben_dpnt_egd_shd.g_old_rec.egd_attribute15;
598: End If;
599: If (p_rec.egd_attribute16 = hr_api.g_varchar2) then
600: p_rec.egd_attribute16 :=
601: ben_dpnt_egd_shd.g_old_rec.egd_attribute16;
602: End If;
603: If (p_rec.egd_attribute17 = hr_api.g_varchar2) then
604: p_rec.egd_attribute17 :=
605: ben_dpnt_egd_shd.g_old_rec.egd_attribute17;
601: ben_dpnt_egd_shd.g_old_rec.egd_attribute16;
602: End If;
603: If (p_rec.egd_attribute17 = hr_api.g_varchar2) then
604: p_rec.egd_attribute17 :=
605: ben_dpnt_egd_shd.g_old_rec.egd_attribute17;
606: End If;
607: If (p_rec.egd_attribute18 = hr_api.g_varchar2) then
608: p_rec.egd_attribute18 :=
609: ben_dpnt_egd_shd.g_old_rec.egd_attribute18;
605: ben_dpnt_egd_shd.g_old_rec.egd_attribute17;
606: End If;
607: If (p_rec.egd_attribute18 = hr_api.g_varchar2) then
608: p_rec.egd_attribute18 :=
609: ben_dpnt_egd_shd.g_old_rec.egd_attribute18;
610: End If;
611: If (p_rec.egd_attribute19 = hr_api.g_varchar2) then
612: p_rec.egd_attribute19 :=
613: ben_dpnt_egd_shd.g_old_rec.egd_attribute19;
609: ben_dpnt_egd_shd.g_old_rec.egd_attribute18;
610: End If;
611: If (p_rec.egd_attribute19 = hr_api.g_varchar2) then
612: p_rec.egd_attribute19 :=
613: ben_dpnt_egd_shd.g_old_rec.egd_attribute19;
614: End If;
615: If (p_rec.egd_attribute20 = hr_api.g_varchar2) then
616: p_rec.egd_attribute20 :=
617: ben_dpnt_egd_shd.g_old_rec.egd_attribute20;
613: ben_dpnt_egd_shd.g_old_rec.egd_attribute19;
614: End If;
615: If (p_rec.egd_attribute20 = hr_api.g_varchar2) then
616: p_rec.egd_attribute20 :=
617: ben_dpnt_egd_shd.g_old_rec.egd_attribute20;
618: End If;
619: If (p_rec.egd_attribute21 = hr_api.g_varchar2) then
620: p_rec.egd_attribute21 :=
621: ben_dpnt_egd_shd.g_old_rec.egd_attribute21;
617: ben_dpnt_egd_shd.g_old_rec.egd_attribute20;
618: End If;
619: If (p_rec.egd_attribute21 = hr_api.g_varchar2) then
620: p_rec.egd_attribute21 :=
621: ben_dpnt_egd_shd.g_old_rec.egd_attribute21;
622: End If;
623: If (p_rec.egd_attribute22 = hr_api.g_varchar2) then
624: p_rec.egd_attribute22 :=
625: ben_dpnt_egd_shd.g_old_rec.egd_attribute22;
621: ben_dpnt_egd_shd.g_old_rec.egd_attribute21;
622: End If;
623: If (p_rec.egd_attribute22 = hr_api.g_varchar2) then
624: p_rec.egd_attribute22 :=
625: ben_dpnt_egd_shd.g_old_rec.egd_attribute22;
626: End If;
627: If (p_rec.egd_attribute23 = hr_api.g_varchar2) then
628: p_rec.egd_attribute23 :=
629: ben_dpnt_egd_shd.g_old_rec.egd_attribute23;
625: ben_dpnt_egd_shd.g_old_rec.egd_attribute22;
626: End If;
627: If (p_rec.egd_attribute23 = hr_api.g_varchar2) then
628: p_rec.egd_attribute23 :=
629: ben_dpnt_egd_shd.g_old_rec.egd_attribute23;
630: End If;
631: If (p_rec.egd_attribute24 = hr_api.g_varchar2) then
632: p_rec.egd_attribute24 :=
633: ben_dpnt_egd_shd.g_old_rec.egd_attribute24;
629: ben_dpnt_egd_shd.g_old_rec.egd_attribute23;
630: End If;
631: If (p_rec.egd_attribute24 = hr_api.g_varchar2) then
632: p_rec.egd_attribute24 :=
633: ben_dpnt_egd_shd.g_old_rec.egd_attribute24;
634: End If;
635: If (p_rec.egd_attribute25 = hr_api.g_varchar2) then
636: p_rec.egd_attribute25 :=
637: ben_dpnt_egd_shd.g_old_rec.egd_attribute25;
633: ben_dpnt_egd_shd.g_old_rec.egd_attribute24;
634: End If;
635: If (p_rec.egd_attribute25 = hr_api.g_varchar2) then
636: p_rec.egd_attribute25 :=
637: ben_dpnt_egd_shd.g_old_rec.egd_attribute25;
638: End If;
639: If (p_rec.egd_attribute26 = hr_api.g_varchar2) then
640: p_rec.egd_attribute26 :=
641: ben_dpnt_egd_shd.g_old_rec.egd_attribute26;
637: ben_dpnt_egd_shd.g_old_rec.egd_attribute25;
638: End If;
639: If (p_rec.egd_attribute26 = hr_api.g_varchar2) then
640: p_rec.egd_attribute26 :=
641: ben_dpnt_egd_shd.g_old_rec.egd_attribute26;
642: End If;
643: If (p_rec.egd_attribute27 = hr_api.g_varchar2) then
644: p_rec.egd_attribute27 :=
645: ben_dpnt_egd_shd.g_old_rec.egd_attribute27;
641: ben_dpnt_egd_shd.g_old_rec.egd_attribute26;
642: End If;
643: If (p_rec.egd_attribute27 = hr_api.g_varchar2) then
644: p_rec.egd_attribute27 :=
645: ben_dpnt_egd_shd.g_old_rec.egd_attribute27;
646: End If;
647: If (p_rec.egd_attribute28 = hr_api.g_varchar2) then
648: p_rec.egd_attribute28 :=
649: ben_dpnt_egd_shd.g_old_rec.egd_attribute28;
645: ben_dpnt_egd_shd.g_old_rec.egd_attribute27;
646: End If;
647: If (p_rec.egd_attribute28 = hr_api.g_varchar2) then
648: p_rec.egd_attribute28 :=
649: ben_dpnt_egd_shd.g_old_rec.egd_attribute28;
650: End If;
651: If (p_rec.egd_attribute29 = hr_api.g_varchar2) then
652: p_rec.egd_attribute29 :=
653: ben_dpnt_egd_shd.g_old_rec.egd_attribute29;
649: ben_dpnt_egd_shd.g_old_rec.egd_attribute28;
650: End If;
651: If (p_rec.egd_attribute29 = hr_api.g_varchar2) then
652: p_rec.egd_attribute29 :=
653: ben_dpnt_egd_shd.g_old_rec.egd_attribute29;
654: End If;
655: If (p_rec.egd_attribute30 = hr_api.g_varchar2) then
656: p_rec.egd_attribute30 :=
657: ben_dpnt_egd_shd.g_old_rec.egd_attribute30;
653: ben_dpnt_egd_shd.g_old_rec.egd_attribute29;
654: End If;
655: If (p_rec.egd_attribute30 = hr_api.g_varchar2) then
656: p_rec.egd_attribute30 :=
657: ben_dpnt_egd_shd.g_old_rec.egd_attribute30;
658: End If;
659: If (p_rec.allow_range_validation_flag2 = hr_api.g_varchar2) then
660: p_rec.allow_range_validation_flag2 :=
661: ben_dpnt_egd_shd.g_old_rec.allow_range_validation_flag2;
657: ben_dpnt_egd_shd.g_old_rec.egd_attribute30;
658: End If;
659: If (p_rec.allow_range_validation_flag2 = hr_api.g_varchar2) then
660: p_rec.allow_range_validation_flag2 :=
661: ben_dpnt_egd_shd.g_old_rec.allow_range_validation_flag2;
662: End If;
663: If (p_rec.time_access_calc_rule1 = hr_api.g_number) then
664: p_rec.time_access_calc_rule1 :=
665: ben_dpnt_egd_shd.g_old_rec.time_access_calc_rule1;
661: ben_dpnt_egd_shd.g_old_rec.allow_range_validation_flag2;
662: End If;
663: If (p_rec.time_access_calc_rule1 = hr_api.g_number) then
664: p_rec.time_access_calc_rule1 :=
665: ben_dpnt_egd_shd.g_old_rec.time_access_calc_rule1;
666: End If;
667: If (p_rec.time_access_calc_rule2 = hr_api.g_number) then
668: p_rec.time_access_calc_rule2 :=
669: ben_dpnt_egd_shd.g_old_rec.time_access_calc_rule2;
665: ben_dpnt_egd_shd.g_old_rec.time_access_calc_rule1;
666: End If;
667: If (p_rec.time_access_calc_rule2 = hr_api.g_number) then
668: p_rec.time_access_calc_rule2 :=
669: ben_dpnt_egd_shd.g_old_rec.time_access_calc_rule2;
670: End If;
671:
672: --
673: hr_utility.set_location(' Leaving:'||l_proc, 10);
678: -- |---------------------------------< upd >----------------------------------|
679: -- ----------------------------------------------------------------------------
680: Procedure upd
681: (
682: p_rec in out nocopy ben_dpnt_egd_shd.g_rec_type
683: ,p_effective_date in date
684: ) is
685: --
686: l_proc varchar2(72) := g_package||'upd';
690: --
691: -- We must lock the row which we need to update.
692:
693: --
694: ben_dpnt_egd_shd.lck(p_rec.eligy_criteria_dpnt_id,
695: p_rec.object_version_number);
696: --
697: -- 1. During an update system defaults are used to determine if
698: -- arguments have been defaulted or not. We must therefore
782: ,p_time_access_calc_rule1 in number default hr_api.g_number
783: ,p_time_access_calc_rule2 in number default hr_api.g_number
784: ) is
785: --
786: l_rec ben_dpnt_egd_shd.g_rec_type;
787: l_proc varchar2(72) := g_package||'upd';
788: --
789: Begin
790: hr_utility.set_location('Entering:'||l_proc, 5);
792: -- Call conversion function to turn arguments into the
793: -- l_rec structure.
794: --
795: l_rec :=
796: ben_dpnt_egd_shd.convert_args
797: (
798: p_eligy_criteria_dpnt_id
799: ,p_name
800: ,p_short_code