50: -- Internal Row Handler Use Only.
51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml(p_rec in out nocopy ben_egl_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_egl_shd.g_api_dml := true; -- Set the api dml status
66: --
67: -- Update the ben_eligy_criteria Row
68: --
69: update ben_eligy_criteria
133:
134:
135: where eligy_criteria_id = p_rec.eligy_criteria_id;
136: --
137: ben_egl_shd.g_api_dml := false; -- Unset the api dml status
138: --
139: hr_utility.set_location(' Leaving:'||l_proc, 10);
140: --
141: Exception
140: --
141: Exception
142: When hr_api.check_integrity_violated Then
143: -- A check constraint has been violated
144: ben_egl_shd.g_api_dml := false; -- Unset the api dml status
145: ben_egl_shd.constraint_error
146: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
147: When hr_api.parent_integrity_violated Then
148: -- Parent integrity has been violated
141: Exception
142: When hr_api.check_integrity_violated Then
143: -- A check constraint has been violated
144: ben_egl_shd.g_api_dml := false; -- Unset the api dml status
145: ben_egl_shd.constraint_error
146: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
147: When hr_api.parent_integrity_violated Then
148: -- Parent integrity has been violated
149: ben_egl_shd.g_api_dml := false; -- Unset the api dml status
145: ben_egl_shd.constraint_error
146: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
147: When hr_api.parent_integrity_violated Then
148: -- Parent integrity has been violated
149: ben_egl_shd.g_api_dml := false; -- Unset the api dml status
150: ben_egl_shd.constraint_error
151: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
152: When hr_api.unique_integrity_violated Then
153: -- Unique integrity has been violated
146: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
147: When hr_api.parent_integrity_violated Then
148: -- Parent integrity has been violated
149: ben_egl_shd.g_api_dml := false; -- Unset the api dml status
150: ben_egl_shd.constraint_error
151: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
152: When hr_api.unique_integrity_violated Then
153: -- Unique integrity has been violated
154: ben_egl_shd.g_api_dml := false; -- Unset the api dml status
150: ben_egl_shd.constraint_error
151: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
152: When hr_api.unique_integrity_violated Then
153: -- Unique integrity has been violated
154: ben_egl_shd.g_api_dml := false; -- Unset the api dml status
155: ben_egl_shd.constraint_error
156: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
157: When Others Then
158: ben_egl_shd.g_api_dml := false; -- Unset the api dml status
151: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
152: When hr_api.unique_integrity_violated Then
153: -- Unique integrity has been violated
154: ben_egl_shd.g_api_dml := false; -- Unset the api dml status
155: ben_egl_shd.constraint_error
156: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
157: When Others Then
158: ben_egl_shd.g_api_dml := false; -- Unset the api dml status
159: Raise;
154: ben_egl_shd.g_api_dml := false; -- Unset the api dml status
155: ben_egl_shd.constraint_error
156: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
157: When Others Then
158: ben_egl_shd.g_api_dml := false; -- Unset the api dml status
159: Raise;
160: End update_dml;
161: --
162: -- ----------------------------------------------------------------------------
190: -- Internal Row Handler Use Only.
191: --
192: -- {End Of Comments}
193: -- ----------------------------------------------------------------------------
194: Procedure pre_update(p_rec in ben_egl_shd.g_rec_type) is
195: --
196: l_proc varchar2(72) := g_package||'pre_update';
197: --
198: Begin
232: -- Internal Row Handler Use Only.
233: --
234: -- {End Of Comments}
235: -- ----------------------------------------------------------------------------
236: Procedure post_update( p_rec in ben_egl_shd.g_rec_type
237: ,p_effective_date in date) is
238: --
239: l_proc varchar2(72) := g_package||'post_update';
240: --
310: ,p_allow_range_validation_flag2 => p_rec.allow_range_validation_flag2
311: ,p_access_calc_rule2 => p_rec.access_calc_rule2
312: ,p_time_access_calc_rule1 => p_rec.time_access_calc_rule1
313: ,p_time_access_calc_rule2 => p_rec.time_access_calc_rule2
314: ,p_name_o => ben_egl_shd.g_old_rec.name
315: ,p_short_code_o => ben_egl_shd.g_old_rec.short_code
316: ,p_description_o => ben_egl_shd.g_old_rec.description
317: ,p_criteria_type_o => ben_egl_shd.g_old_rec.criteria_type
318: ,p_crit_col1_val_type_cd_o => ben_egl_shd.g_old_rec.crit_col1_val_type_cd
311: ,p_access_calc_rule2 => p_rec.access_calc_rule2
312: ,p_time_access_calc_rule1 => p_rec.time_access_calc_rule1
313: ,p_time_access_calc_rule2 => p_rec.time_access_calc_rule2
314: ,p_name_o => ben_egl_shd.g_old_rec.name
315: ,p_short_code_o => ben_egl_shd.g_old_rec.short_code
316: ,p_description_o => ben_egl_shd.g_old_rec.description
317: ,p_criteria_type_o => ben_egl_shd.g_old_rec.criteria_type
318: ,p_crit_col1_val_type_cd_o => ben_egl_shd.g_old_rec.crit_col1_val_type_cd
319: ,p_crit_col1_datatype_o => ben_egl_shd.g_old_rec.crit_col1_datatype
312: ,p_time_access_calc_rule1 => p_rec.time_access_calc_rule1
313: ,p_time_access_calc_rule2 => p_rec.time_access_calc_rule2
314: ,p_name_o => ben_egl_shd.g_old_rec.name
315: ,p_short_code_o => ben_egl_shd.g_old_rec.short_code
316: ,p_description_o => ben_egl_shd.g_old_rec.description
317: ,p_criteria_type_o => ben_egl_shd.g_old_rec.criteria_type
318: ,p_crit_col1_val_type_cd_o => ben_egl_shd.g_old_rec.crit_col1_val_type_cd
319: ,p_crit_col1_datatype_o => ben_egl_shd.g_old_rec.crit_col1_datatype
320: ,p_col1_lookup_type_o => ben_egl_shd.g_old_rec.col1_lookup_type
313: ,p_time_access_calc_rule2 => p_rec.time_access_calc_rule2
314: ,p_name_o => ben_egl_shd.g_old_rec.name
315: ,p_short_code_o => ben_egl_shd.g_old_rec.short_code
316: ,p_description_o => ben_egl_shd.g_old_rec.description
317: ,p_criteria_type_o => ben_egl_shd.g_old_rec.criteria_type
318: ,p_crit_col1_val_type_cd_o => ben_egl_shd.g_old_rec.crit_col1_val_type_cd
319: ,p_crit_col1_datatype_o => ben_egl_shd.g_old_rec.crit_col1_datatype
320: ,p_col1_lookup_type_o => ben_egl_shd.g_old_rec.col1_lookup_type
321: ,p_col1_value_set_id_o => ben_egl_shd.g_old_rec.col1_value_set_id
314: ,p_name_o => ben_egl_shd.g_old_rec.name
315: ,p_short_code_o => ben_egl_shd.g_old_rec.short_code
316: ,p_description_o => ben_egl_shd.g_old_rec.description
317: ,p_criteria_type_o => ben_egl_shd.g_old_rec.criteria_type
318: ,p_crit_col1_val_type_cd_o => ben_egl_shd.g_old_rec.crit_col1_val_type_cd
319: ,p_crit_col1_datatype_o => ben_egl_shd.g_old_rec.crit_col1_datatype
320: ,p_col1_lookup_type_o => ben_egl_shd.g_old_rec.col1_lookup_type
321: ,p_col1_value_set_id_o => ben_egl_shd.g_old_rec.col1_value_set_id
322: ,p_access_table_name1_o => ben_egl_shd.g_old_rec.access_table_name1
315: ,p_short_code_o => ben_egl_shd.g_old_rec.short_code
316: ,p_description_o => ben_egl_shd.g_old_rec.description
317: ,p_criteria_type_o => ben_egl_shd.g_old_rec.criteria_type
318: ,p_crit_col1_val_type_cd_o => ben_egl_shd.g_old_rec.crit_col1_val_type_cd
319: ,p_crit_col1_datatype_o => ben_egl_shd.g_old_rec.crit_col1_datatype
320: ,p_col1_lookup_type_o => ben_egl_shd.g_old_rec.col1_lookup_type
321: ,p_col1_value_set_id_o => ben_egl_shd.g_old_rec.col1_value_set_id
322: ,p_access_table_name1_o => ben_egl_shd.g_old_rec.access_table_name1
323: ,p_access_column_name1_o => ben_egl_shd.g_old_rec.access_column_name1
316: ,p_description_o => ben_egl_shd.g_old_rec.description
317: ,p_criteria_type_o => ben_egl_shd.g_old_rec.criteria_type
318: ,p_crit_col1_val_type_cd_o => ben_egl_shd.g_old_rec.crit_col1_val_type_cd
319: ,p_crit_col1_datatype_o => ben_egl_shd.g_old_rec.crit_col1_datatype
320: ,p_col1_lookup_type_o => ben_egl_shd.g_old_rec.col1_lookup_type
321: ,p_col1_value_set_id_o => ben_egl_shd.g_old_rec.col1_value_set_id
322: ,p_access_table_name1_o => ben_egl_shd.g_old_rec.access_table_name1
323: ,p_access_column_name1_o => ben_egl_shd.g_old_rec.access_column_name1
324: ,p_time_entry_access_tab_nam1_o => ben_egl_shd.g_old_rec.time_entry_access_tab_nam1
317: ,p_criteria_type_o => ben_egl_shd.g_old_rec.criteria_type
318: ,p_crit_col1_val_type_cd_o => ben_egl_shd.g_old_rec.crit_col1_val_type_cd
319: ,p_crit_col1_datatype_o => ben_egl_shd.g_old_rec.crit_col1_datatype
320: ,p_col1_lookup_type_o => ben_egl_shd.g_old_rec.col1_lookup_type
321: ,p_col1_value_set_id_o => ben_egl_shd.g_old_rec.col1_value_set_id
322: ,p_access_table_name1_o => ben_egl_shd.g_old_rec.access_table_name1
323: ,p_access_column_name1_o => ben_egl_shd.g_old_rec.access_column_name1
324: ,p_time_entry_access_tab_nam1_o => ben_egl_shd.g_old_rec.time_entry_access_tab_nam1
325: ,p_time_entry_access_col_nam1_o => ben_egl_shd.g_old_rec.time_entry_access_col_nam1
318: ,p_crit_col1_val_type_cd_o => ben_egl_shd.g_old_rec.crit_col1_val_type_cd
319: ,p_crit_col1_datatype_o => ben_egl_shd.g_old_rec.crit_col1_datatype
320: ,p_col1_lookup_type_o => ben_egl_shd.g_old_rec.col1_lookup_type
321: ,p_col1_value_set_id_o => ben_egl_shd.g_old_rec.col1_value_set_id
322: ,p_access_table_name1_o => ben_egl_shd.g_old_rec.access_table_name1
323: ,p_access_column_name1_o => ben_egl_shd.g_old_rec.access_column_name1
324: ,p_time_entry_access_tab_nam1_o => ben_egl_shd.g_old_rec.time_entry_access_tab_nam1
325: ,p_time_entry_access_col_nam1_o => ben_egl_shd.g_old_rec.time_entry_access_col_nam1
326: ,p_crit_col2_val_type_cd_o => ben_egl_shd.g_old_rec.crit_col2_val_type_cd
319: ,p_crit_col1_datatype_o => ben_egl_shd.g_old_rec.crit_col1_datatype
320: ,p_col1_lookup_type_o => ben_egl_shd.g_old_rec.col1_lookup_type
321: ,p_col1_value_set_id_o => ben_egl_shd.g_old_rec.col1_value_set_id
322: ,p_access_table_name1_o => ben_egl_shd.g_old_rec.access_table_name1
323: ,p_access_column_name1_o => ben_egl_shd.g_old_rec.access_column_name1
324: ,p_time_entry_access_tab_nam1_o => ben_egl_shd.g_old_rec.time_entry_access_tab_nam1
325: ,p_time_entry_access_col_nam1_o => ben_egl_shd.g_old_rec.time_entry_access_col_nam1
326: ,p_crit_col2_val_type_cd_o => ben_egl_shd.g_old_rec.crit_col2_val_type_cd
327: ,p_crit_col2_datatype_o => ben_egl_shd.g_old_rec.crit_col2_datatype
320: ,p_col1_lookup_type_o => ben_egl_shd.g_old_rec.col1_lookup_type
321: ,p_col1_value_set_id_o => ben_egl_shd.g_old_rec.col1_value_set_id
322: ,p_access_table_name1_o => ben_egl_shd.g_old_rec.access_table_name1
323: ,p_access_column_name1_o => ben_egl_shd.g_old_rec.access_column_name1
324: ,p_time_entry_access_tab_nam1_o => ben_egl_shd.g_old_rec.time_entry_access_tab_nam1
325: ,p_time_entry_access_col_nam1_o => ben_egl_shd.g_old_rec.time_entry_access_col_nam1
326: ,p_crit_col2_val_type_cd_o => ben_egl_shd.g_old_rec.crit_col2_val_type_cd
327: ,p_crit_col2_datatype_o => ben_egl_shd.g_old_rec.crit_col2_datatype
328: ,p_col2_lookup_type_o => ben_egl_shd.g_old_rec.col2_lookup_type
321: ,p_col1_value_set_id_o => ben_egl_shd.g_old_rec.col1_value_set_id
322: ,p_access_table_name1_o => ben_egl_shd.g_old_rec.access_table_name1
323: ,p_access_column_name1_o => ben_egl_shd.g_old_rec.access_column_name1
324: ,p_time_entry_access_tab_nam1_o => ben_egl_shd.g_old_rec.time_entry_access_tab_nam1
325: ,p_time_entry_access_col_nam1_o => ben_egl_shd.g_old_rec.time_entry_access_col_nam1
326: ,p_crit_col2_val_type_cd_o => ben_egl_shd.g_old_rec.crit_col2_val_type_cd
327: ,p_crit_col2_datatype_o => ben_egl_shd.g_old_rec.crit_col2_datatype
328: ,p_col2_lookup_type_o => ben_egl_shd.g_old_rec.col2_lookup_type
329: ,p_col2_value_set_id_o => ben_egl_shd.g_old_rec.col2_value_set_id
322: ,p_access_table_name1_o => ben_egl_shd.g_old_rec.access_table_name1
323: ,p_access_column_name1_o => ben_egl_shd.g_old_rec.access_column_name1
324: ,p_time_entry_access_tab_nam1_o => ben_egl_shd.g_old_rec.time_entry_access_tab_nam1
325: ,p_time_entry_access_col_nam1_o => ben_egl_shd.g_old_rec.time_entry_access_col_nam1
326: ,p_crit_col2_val_type_cd_o => ben_egl_shd.g_old_rec.crit_col2_val_type_cd
327: ,p_crit_col2_datatype_o => ben_egl_shd.g_old_rec.crit_col2_datatype
328: ,p_col2_lookup_type_o => ben_egl_shd.g_old_rec.col2_lookup_type
329: ,p_col2_value_set_id_o => ben_egl_shd.g_old_rec.col2_value_set_id
330: ,p_access_table_name2_o => ben_egl_shd.g_old_rec.access_table_name2
323: ,p_access_column_name1_o => ben_egl_shd.g_old_rec.access_column_name1
324: ,p_time_entry_access_tab_nam1_o => ben_egl_shd.g_old_rec.time_entry_access_tab_nam1
325: ,p_time_entry_access_col_nam1_o => ben_egl_shd.g_old_rec.time_entry_access_col_nam1
326: ,p_crit_col2_val_type_cd_o => ben_egl_shd.g_old_rec.crit_col2_val_type_cd
327: ,p_crit_col2_datatype_o => ben_egl_shd.g_old_rec.crit_col2_datatype
328: ,p_col2_lookup_type_o => ben_egl_shd.g_old_rec.col2_lookup_type
329: ,p_col2_value_set_id_o => ben_egl_shd.g_old_rec.col2_value_set_id
330: ,p_access_table_name2_o => ben_egl_shd.g_old_rec.access_table_name2
331: ,p_access_column_name2_o => ben_egl_shd.g_old_rec.access_column_name2
324: ,p_time_entry_access_tab_nam1_o => ben_egl_shd.g_old_rec.time_entry_access_tab_nam1
325: ,p_time_entry_access_col_nam1_o => ben_egl_shd.g_old_rec.time_entry_access_col_nam1
326: ,p_crit_col2_val_type_cd_o => ben_egl_shd.g_old_rec.crit_col2_val_type_cd
327: ,p_crit_col2_datatype_o => ben_egl_shd.g_old_rec.crit_col2_datatype
328: ,p_col2_lookup_type_o => ben_egl_shd.g_old_rec.col2_lookup_type
329: ,p_col2_value_set_id_o => ben_egl_shd.g_old_rec.col2_value_set_id
330: ,p_access_table_name2_o => ben_egl_shd.g_old_rec.access_table_name2
331: ,p_access_column_name2_o => ben_egl_shd.g_old_rec.access_column_name2
332: ,p_time_entry_access_tab_nam2_o => ben_egl_shd.g_old_rec.time_entry_access_tab_nam2
325: ,p_time_entry_access_col_nam1_o => ben_egl_shd.g_old_rec.time_entry_access_col_nam1
326: ,p_crit_col2_val_type_cd_o => ben_egl_shd.g_old_rec.crit_col2_val_type_cd
327: ,p_crit_col2_datatype_o => ben_egl_shd.g_old_rec.crit_col2_datatype
328: ,p_col2_lookup_type_o => ben_egl_shd.g_old_rec.col2_lookup_type
329: ,p_col2_value_set_id_o => ben_egl_shd.g_old_rec.col2_value_set_id
330: ,p_access_table_name2_o => ben_egl_shd.g_old_rec.access_table_name2
331: ,p_access_column_name2_o => ben_egl_shd.g_old_rec.access_column_name2
332: ,p_time_entry_access_tab_nam2_o => ben_egl_shd.g_old_rec.time_entry_access_tab_nam2
333: ,p_time_entry_access_col_nam2_o => ben_egl_shd.g_old_rec.time_entry_access_col_nam2
326: ,p_crit_col2_val_type_cd_o => ben_egl_shd.g_old_rec.crit_col2_val_type_cd
327: ,p_crit_col2_datatype_o => ben_egl_shd.g_old_rec.crit_col2_datatype
328: ,p_col2_lookup_type_o => ben_egl_shd.g_old_rec.col2_lookup_type
329: ,p_col2_value_set_id_o => ben_egl_shd.g_old_rec.col2_value_set_id
330: ,p_access_table_name2_o => ben_egl_shd.g_old_rec.access_table_name2
331: ,p_access_column_name2_o => ben_egl_shd.g_old_rec.access_column_name2
332: ,p_time_entry_access_tab_nam2_o => ben_egl_shd.g_old_rec.time_entry_access_tab_nam2
333: ,p_time_entry_access_col_nam2_o => ben_egl_shd.g_old_rec.time_entry_access_col_nam2
334: ,p_access_calc_rule_o => ben_egl_shd.g_old_rec.access_calc_rule
327: ,p_crit_col2_datatype_o => ben_egl_shd.g_old_rec.crit_col2_datatype
328: ,p_col2_lookup_type_o => ben_egl_shd.g_old_rec.col2_lookup_type
329: ,p_col2_value_set_id_o => ben_egl_shd.g_old_rec.col2_value_set_id
330: ,p_access_table_name2_o => ben_egl_shd.g_old_rec.access_table_name2
331: ,p_access_column_name2_o => ben_egl_shd.g_old_rec.access_column_name2
332: ,p_time_entry_access_tab_nam2_o => ben_egl_shd.g_old_rec.time_entry_access_tab_nam2
333: ,p_time_entry_access_col_nam2_o => ben_egl_shd.g_old_rec.time_entry_access_col_nam2
334: ,p_access_calc_rule_o => ben_egl_shd.g_old_rec.access_calc_rule
335: ,p_allow_range_validation_flg_o => ben_egl_shd.g_old_rec.allow_range_validation_flg
328: ,p_col2_lookup_type_o => ben_egl_shd.g_old_rec.col2_lookup_type
329: ,p_col2_value_set_id_o => ben_egl_shd.g_old_rec.col2_value_set_id
330: ,p_access_table_name2_o => ben_egl_shd.g_old_rec.access_table_name2
331: ,p_access_column_name2_o => ben_egl_shd.g_old_rec.access_column_name2
332: ,p_time_entry_access_tab_nam2_o => ben_egl_shd.g_old_rec.time_entry_access_tab_nam2
333: ,p_time_entry_access_col_nam2_o => ben_egl_shd.g_old_rec.time_entry_access_col_nam2
334: ,p_access_calc_rule_o => ben_egl_shd.g_old_rec.access_calc_rule
335: ,p_allow_range_validation_flg_o => ben_egl_shd.g_old_rec.allow_range_validation_flg
336: ,p_user_defined_flag_o => ben_egl_shd.g_old_rec.user_defined_flag
329: ,p_col2_value_set_id_o => ben_egl_shd.g_old_rec.col2_value_set_id
330: ,p_access_table_name2_o => ben_egl_shd.g_old_rec.access_table_name2
331: ,p_access_column_name2_o => ben_egl_shd.g_old_rec.access_column_name2
332: ,p_time_entry_access_tab_nam2_o => ben_egl_shd.g_old_rec.time_entry_access_tab_nam2
333: ,p_time_entry_access_col_nam2_o => ben_egl_shd.g_old_rec.time_entry_access_col_nam2
334: ,p_access_calc_rule_o => ben_egl_shd.g_old_rec.access_calc_rule
335: ,p_allow_range_validation_flg_o => ben_egl_shd.g_old_rec.allow_range_validation_flg
336: ,p_user_defined_flag_o => ben_egl_shd.g_old_rec.user_defined_flag
337: ,p_business_group_id_o => ben_egl_shd.g_old_rec.business_group_id
330: ,p_access_table_name2_o => ben_egl_shd.g_old_rec.access_table_name2
331: ,p_access_column_name2_o => ben_egl_shd.g_old_rec.access_column_name2
332: ,p_time_entry_access_tab_nam2_o => ben_egl_shd.g_old_rec.time_entry_access_tab_nam2
333: ,p_time_entry_access_col_nam2_o => ben_egl_shd.g_old_rec.time_entry_access_col_nam2
334: ,p_access_calc_rule_o => ben_egl_shd.g_old_rec.access_calc_rule
335: ,p_allow_range_validation_flg_o => ben_egl_shd.g_old_rec.allow_range_validation_flg
336: ,p_user_defined_flag_o => ben_egl_shd.g_old_rec.user_defined_flag
337: ,p_business_group_id_o => ben_egl_shd.g_old_rec.business_group_id
338: ,p_legislation_code_o => ben_egl_shd.g_old_rec.legislation_code
331: ,p_access_column_name2_o => ben_egl_shd.g_old_rec.access_column_name2
332: ,p_time_entry_access_tab_nam2_o => ben_egl_shd.g_old_rec.time_entry_access_tab_nam2
333: ,p_time_entry_access_col_nam2_o => ben_egl_shd.g_old_rec.time_entry_access_col_nam2
334: ,p_access_calc_rule_o => ben_egl_shd.g_old_rec.access_calc_rule
335: ,p_allow_range_validation_flg_o => ben_egl_shd.g_old_rec.allow_range_validation_flg
336: ,p_user_defined_flag_o => ben_egl_shd.g_old_rec.user_defined_flag
337: ,p_business_group_id_o => ben_egl_shd.g_old_rec.business_group_id
338: ,p_legislation_code_o => ben_egl_shd.g_old_rec.legislation_code
339: ,p_egl_attribute_category_o => ben_egl_shd.g_old_rec.egl_attribute_category
332: ,p_time_entry_access_tab_nam2_o => ben_egl_shd.g_old_rec.time_entry_access_tab_nam2
333: ,p_time_entry_access_col_nam2_o => ben_egl_shd.g_old_rec.time_entry_access_col_nam2
334: ,p_access_calc_rule_o => ben_egl_shd.g_old_rec.access_calc_rule
335: ,p_allow_range_validation_flg_o => ben_egl_shd.g_old_rec.allow_range_validation_flg
336: ,p_user_defined_flag_o => ben_egl_shd.g_old_rec.user_defined_flag
337: ,p_business_group_id_o => ben_egl_shd.g_old_rec.business_group_id
338: ,p_legislation_code_o => ben_egl_shd.g_old_rec.legislation_code
339: ,p_egl_attribute_category_o => ben_egl_shd.g_old_rec.egl_attribute_category
340: ,p_egl_attribute1_o => ben_egl_shd.g_old_rec.egl_attribute1
333: ,p_time_entry_access_col_nam2_o => ben_egl_shd.g_old_rec.time_entry_access_col_nam2
334: ,p_access_calc_rule_o => ben_egl_shd.g_old_rec.access_calc_rule
335: ,p_allow_range_validation_flg_o => ben_egl_shd.g_old_rec.allow_range_validation_flg
336: ,p_user_defined_flag_o => ben_egl_shd.g_old_rec.user_defined_flag
337: ,p_business_group_id_o => ben_egl_shd.g_old_rec.business_group_id
338: ,p_legislation_code_o => ben_egl_shd.g_old_rec.legislation_code
339: ,p_egl_attribute_category_o => ben_egl_shd.g_old_rec.egl_attribute_category
340: ,p_egl_attribute1_o => ben_egl_shd.g_old_rec.egl_attribute1
341: ,p_egl_attribute2_o => ben_egl_shd.g_old_rec.egl_attribute2
334: ,p_access_calc_rule_o => ben_egl_shd.g_old_rec.access_calc_rule
335: ,p_allow_range_validation_flg_o => ben_egl_shd.g_old_rec.allow_range_validation_flg
336: ,p_user_defined_flag_o => ben_egl_shd.g_old_rec.user_defined_flag
337: ,p_business_group_id_o => ben_egl_shd.g_old_rec.business_group_id
338: ,p_legislation_code_o => ben_egl_shd.g_old_rec.legislation_code
339: ,p_egl_attribute_category_o => ben_egl_shd.g_old_rec.egl_attribute_category
340: ,p_egl_attribute1_o => ben_egl_shd.g_old_rec.egl_attribute1
341: ,p_egl_attribute2_o => ben_egl_shd.g_old_rec.egl_attribute2
342: ,p_egl_attribute3_o => ben_egl_shd.g_old_rec.egl_attribute3
335: ,p_allow_range_validation_flg_o => ben_egl_shd.g_old_rec.allow_range_validation_flg
336: ,p_user_defined_flag_o => ben_egl_shd.g_old_rec.user_defined_flag
337: ,p_business_group_id_o => ben_egl_shd.g_old_rec.business_group_id
338: ,p_legislation_code_o => ben_egl_shd.g_old_rec.legislation_code
339: ,p_egl_attribute_category_o => ben_egl_shd.g_old_rec.egl_attribute_category
340: ,p_egl_attribute1_o => ben_egl_shd.g_old_rec.egl_attribute1
341: ,p_egl_attribute2_o => ben_egl_shd.g_old_rec.egl_attribute2
342: ,p_egl_attribute3_o => ben_egl_shd.g_old_rec.egl_attribute3
343: ,p_egl_attribute4_o => ben_egl_shd.g_old_rec.egl_attribute4
336: ,p_user_defined_flag_o => ben_egl_shd.g_old_rec.user_defined_flag
337: ,p_business_group_id_o => ben_egl_shd.g_old_rec.business_group_id
338: ,p_legislation_code_o => ben_egl_shd.g_old_rec.legislation_code
339: ,p_egl_attribute_category_o => ben_egl_shd.g_old_rec.egl_attribute_category
340: ,p_egl_attribute1_o => ben_egl_shd.g_old_rec.egl_attribute1
341: ,p_egl_attribute2_o => ben_egl_shd.g_old_rec.egl_attribute2
342: ,p_egl_attribute3_o => ben_egl_shd.g_old_rec.egl_attribute3
343: ,p_egl_attribute4_o => ben_egl_shd.g_old_rec.egl_attribute4
344: ,p_egl_attribute5_o => ben_egl_shd.g_old_rec.egl_attribute5
337: ,p_business_group_id_o => ben_egl_shd.g_old_rec.business_group_id
338: ,p_legislation_code_o => ben_egl_shd.g_old_rec.legislation_code
339: ,p_egl_attribute_category_o => ben_egl_shd.g_old_rec.egl_attribute_category
340: ,p_egl_attribute1_o => ben_egl_shd.g_old_rec.egl_attribute1
341: ,p_egl_attribute2_o => ben_egl_shd.g_old_rec.egl_attribute2
342: ,p_egl_attribute3_o => ben_egl_shd.g_old_rec.egl_attribute3
343: ,p_egl_attribute4_o => ben_egl_shd.g_old_rec.egl_attribute4
344: ,p_egl_attribute5_o => ben_egl_shd.g_old_rec.egl_attribute5
345: ,p_egl_attribute6_o => ben_egl_shd.g_old_rec.egl_attribute6
338: ,p_legislation_code_o => ben_egl_shd.g_old_rec.legislation_code
339: ,p_egl_attribute_category_o => ben_egl_shd.g_old_rec.egl_attribute_category
340: ,p_egl_attribute1_o => ben_egl_shd.g_old_rec.egl_attribute1
341: ,p_egl_attribute2_o => ben_egl_shd.g_old_rec.egl_attribute2
342: ,p_egl_attribute3_o => ben_egl_shd.g_old_rec.egl_attribute3
343: ,p_egl_attribute4_o => ben_egl_shd.g_old_rec.egl_attribute4
344: ,p_egl_attribute5_o => ben_egl_shd.g_old_rec.egl_attribute5
345: ,p_egl_attribute6_o => ben_egl_shd.g_old_rec.egl_attribute6
346: ,p_egl_attribute7_o => ben_egl_shd.g_old_rec.egl_attribute7
339: ,p_egl_attribute_category_o => ben_egl_shd.g_old_rec.egl_attribute_category
340: ,p_egl_attribute1_o => ben_egl_shd.g_old_rec.egl_attribute1
341: ,p_egl_attribute2_o => ben_egl_shd.g_old_rec.egl_attribute2
342: ,p_egl_attribute3_o => ben_egl_shd.g_old_rec.egl_attribute3
343: ,p_egl_attribute4_o => ben_egl_shd.g_old_rec.egl_attribute4
344: ,p_egl_attribute5_o => ben_egl_shd.g_old_rec.egl_attribute5
345: ,p_egl_attribute6_o => ben_egl_shd.g_old_rec.egl_attribute6
346: ,p_egl_attribute7_o => ben_egl_shd.g_old_rec.egl_attribute7
347: ,p_egl_attribute8_o => ben_egl_shd.g_old_rec.egl_attribute8
340: ,p_egl_attribute1_o => ben_egl_shd.g_old_rec.egl_attribute1
341: ,p_egl_attribute2_o => ben_egl_shd.g_old_rec.egl_attribute2
342: ,p_egl_attribute3_o => ben_egl_shd.g_old_rec.egl_attribute3
343: ,p_egl_attribute4_o => ben_egl_shd.g_old_rec.egl_attribute4
344: ,p_egl_attribute5_o => ben_egl_shd.g_old_rec.egl_attribute5
345: ,p_egl_attribute6_o => ben_egl_shd.g_old_rec.egl_attribute6
346: ,p_egl_attribute7_o => ben_egl_shd.g_old_rec.egl_attribute7
347: ,p_egl_attribute8_o => ben_egl_shd.g_old_rec.egl_attribute8
348: ,p_egl_attribute9_o => ben_egl_shd.g_old_rec.egl_attribute9
341: ,p_egl_attribute2_o => ben_egl_shd.g_old_rec.egl_attribute2
342: ,p_egl_attribute3_o => ben_egl_shd.g_old_rec.egl_attribute3
343: ,p_egl_attribute4_o => ben_egl_shd.g_old_rec.egl_attribute4
344: ,p_egl_attribute5_o => ben_egl_shd.g_old_rec.egl_attribute5
345: ,p_egl_attribute6_o => ben_egl_shd.g_old_rec.egl_attribute6
346: ,p_egl_attribute7_o => ben_egl_shd.g_old_rec.egl_attribute7
347: ,p_egl_attribute8_o => ben_egl_shd.g_old_rec.egl_attribute8
348: ,p_egl_attribute9_o => ben_egl_shd.g_old_rec.egl_attribute9
349: ,p_egl_attribute10_o => ben_egl_shd.g_old_rec.egl_attribute10
342: ,p_egl_attribute3_o => ben_egl_shd.g_old_rec.egl_attribute3
343: ,p_egl_attribute4_o => ben_egl_shd.g_old_rec.egl_attribute4
344: ,p_egl_attribute5_o => ben_egl_shd.g_old_rec.egl_attribute5
345: ,p_egl_attribute6_o => ben_egl_shd.g_old_rec.egl_attribute6
346: ,p_egl_attribute7_o => ben_egl_shd.g_old_rec.egl_attribute7
347: ,p_egl_attribute8_o => ben_egl_shd.g_old_rec.egl_attribute8
348: ,p_egl_attribute9_o => ben_egl_shd.g_old_rec.egl_attribute9
349: ,p_egl_attribute10_o => ben_egl_shd.g_old_rec.egl_attribute10
350: ,p_egl_attribute11_o => ben_egl_shd.g_old_rec.egl_attribute11
343: ,p_egl_attribute4_o => ben_egl_shd.g_old_rec.egl_attribute4
344: ,p_egl_attribute5_o => ben_egl_shd.g_old_rec.egl_attribute5
345: ,p_egl_attribute6_o => ben_egl_shd.g_old_rec.egl_attribute6
346: ,p_egl_attribute7_o => ben_egl_shd.g_old_rec.egl_attribute7
347: ,p_egl_attribute8_o => ben_egl_shd.g_old_rec.egl_attribute8
348: ,p_egl_attribute9_o => ben_egl_shd.g_old_rec.egl_attribute9
349: ,p_egl_attribute10_o => ben_egl_shd.g_old_rec.egl_attribute10
350: ,p_egl_attribute11_o => ben_egl_shd.g_old_rec.egl_attribute11
351: ,p_egl_attribute12_o => ben_egl_shd.g_old_rec.egl_attribute12
344: ,p_egl_attribute5_o => ben_egl_shd.g_old_rec.egl_attribute5
345: ,p_egl_attribute6_o => ben_egl_shd.g_old_rec.egl_attribute6
346: ,p_egl_attribute7_o => ben_egl_shd.g_old_rec.egl_attribute7
347: ,p_egl_attribute8_o => ben_egl_shd.g_old_rec.egl_attribute8
348: ,p_egl_attribute9_o => ben_egl_shd.g_old_rec.egl_attribute9
349: ,p_egl_attribute10_o => ben_egl_shd.g_old_rec.egl_attribute10
350: ,p_egl_attribute11_o => ben_egl_shd.g_old_rec.egl_attribute11
351: ,p_egl_attribute12_o => ben_egl_shd.g_old_rec.egl_attribute12
352: ,p_egl_attribute13_o => ben_egl_shd.g_old_rec.egl_attribute13
345: ,p_egl_attribute6_o => ben_egl_shd.g_old_rec.egl_attribute6
346: ,p_egl_attribute7_o => ben_egl_shd.g_old_rec.egl_attribute7
347: ,p_egl_attribute8_o => ben_egl_shd.g_old_rec.egl_attribute8
348: ,p_egl_attribute9_o => ben_egl_shd.g_old_rec.egl_attribute9
349: ,p_egl_attribute10_o => ben_egl_shd.g_old_rec.egl_attribute10
350: ,p_egl_attribute11_o => ben_egl_shd.g_old_rec.egl_attribute11
351: ,p_egl_attribute12_o => ben_egl_shd.g_old_rec.egl_attribute12
352: ,p_egl_attribute13_o => ben_egl_shd.g_old_rec.egl_attribute13
353: ,p_egl_attribute14_o => ben_egl_shd.g_old_rec.egl_attribute14
346: ,p_egl_attribute7_o => ben_egl_shd.g_old_rec.egl_attribute7
347: ,p_egl_attribute8_o => ben_egl_shd.g_old_rec.egl_attribute8
348: ,p_egl_attribute9_o => ben_egl_shd.g_old_rec.egl_attribute9
349: ,p_egl_attribute10_o => ben_egl_shd.g_old_rec.egl_attribute10
350: ,p_egl_attribute11_o => ben_egl_shd.g_old_rec.egl_attribute11
351: ,p_egl_attribute12_o => ben_egl_shd.g_old_rec.egl_attribute12
352: ,p_egl_attribute13_o => ben_egl_shd.g_old_rec.egl_attribute13
353: ,p_egl_attribute14_o => ben_egl_shd.g_old_rec.egl_attribute14
354: ,p_egl_attribute15_o => ben_egl_shd.g_old_rec.egl_attribute15
347: ,p_egl_attribute8_o => ben_egl_shd.g_old_rec.egl_attribute8
348: ,p_egl_attribute9_o => ben_egl_shd.g_old_rec.egl_attribute9
349: ,p_egl_attribute10_o => ben_egl_shd.g_old_rec.egl_attribute10
350: ,p_egl_attribute11_o => ben_egl_shd.g_old_rec.egl_attribute11
351: ,p_egl_attribute12_o => ben_egl_shd.g_old_rec.egl_attribute12
352: ,p_egl_attribute13_o => ben_egl_shd.g_old_rec.egl_attribute13
353: ,p_egl_attribute14_o => ben_egl_shd.g_old_rec.egl_attribute14
354: ,p_egl_attribute15_o => ben_egl_shd.g_old_rec.egl_attribute15
355: ,p_egl_attribute16_o => ben_egl_shd.g_old_rec.egl_attribute16
348: ,p_egl_attribute9_o => ben_egl_shd.g_old_rec.egl_attribute9
349: ,p_egl_attribute10_o => ben_egl_shd.g_old_rec.egl_attribute10
350: ,p_egl_attribute11_o => ben_egl_shd.g_old_rec.egl_attribute11
351: ,p_egl_attribute12_o => ben_egl_shd.g_old_rec.egl_attribute12
352: ,p_egl_attribute13_o => ben_egl_shd.g_old_rec.egl_attribute13
353: ,p_egl_attribute14_o => ben_egl_shd.g_old_rec.egl_attribute14
354: ,p_egl_attribute15_o => ben_egl_shd.g_old_rec.egl_attribute15
355: ,p_egl_attribute16_o => ben_egl_shd.g_old_rec.egl_attribute16
356: ,p_egl_attribute17_o => ben_egl_shd.g_old_rec.egl_attribute17
349: ,p_egl_attribute10_o => ben_egl_shd.g_old_rec.egl_attribute10
350: ,p_egl_attribute11_o => ben_egl_shd.g_old_rec.egl_attribute11
351: ,p_egl_attribute12_o => ben_egl_shd.g_old_rec.egl_attribute12
352: ,p_egl_attribute13_o => ben_egl_shd.g_old_rec.egl_attribute13
353: ,p_egl_attribute14_o => ben_egl_shd.g_old_rec.egl_attribute14
354: ,p_egl_attribute15_o => ben_egl_shd.g_old_rec.egl_attribute15
355: ,p_egl_attribute16_o => ben_egl_shd.g_old_rec.egl_attribute16
356: ,p_egl_attribute17_o => ben_egl_shd.g_old_rec.egl_attribute17
357: ,p_egl_attribute18_o => ben_egl_shd.g_old_rec.egl_attribute18
350: ,p_egl_attribute11_o => ben_egl_shd.g_old_rec.egl_attribute11
351: ,p_egl_attribute12_o => ben_egl_shd.g_old_rec.egl_attribute12
352: ,p_egl_attribute13_o => ben_egl_shd.g_old_rec.egl_attribute13
353: ,p_egl_attribute14_o => ben_egl_shd.g_old_rec.egl_attribute14
354: ,p_egl_attribute15_o => ben_egl_shd.g_old_rec.egl_attribute15
355: ,p_egl_attribute16_o => ben_egl_shd.g_old_rec.egl_attribute16
356: ,p_egl_attribute17_o => ben_egl_shd.g_old_rec.egl_attribute17
357: ,p_egl_attribute18_o => ben_egl_shd.g_old_rec.egl_attribute18
358: ,p_egl_attribute19_o => ben_egl_shd.g_old_rec.egl_attribute19
351: ,p_egl_attribute12_o => ben_egl_shd.g_old_rec.egl_attribute12
352: ,p_egl_attribute13_o => ben_egl_shd.g_old_rec.egl_attribute13
353: ,p_egl_attribute14_o => ben_egl_shd.g_old_rec.egl_attribute14
354: ,p_egl_attribute15_o => ben_egl_shd.g_old_rec.egl_attribute15
355: ,p_egl_attribute16_o => ben_egl_shd.g_old_rec.egl_attribute16
356: ,p_egl_attribute17_o => ben_egl_shd.g_old_rec.egl_attribute17
357: ,p_egl_attribute18_o => ben_egl_shd.g_old_rec.egl_attribute18
358: ,p_egl_attribute19_o => ben_egl_shd.g_old_rec.egl_attribute19
359: ,p_egl_attribute20_o => ben_egl_shd.g_old_rec.egl_attribute20
352: ,p_egl_attribute13_o => ben_egl_shd.g_old_rec.egl_attribute13
353: ,p_egl_attribute14_o => ben_egl_shd.g_old_rec.egl_attribute14
354: ,p_egl_attribute15_o => ben_egl_shd.g_old_rec.egl_attribute15
355: ,p_egl_attribute16_o => ben_egl_shd.g_old_rec.egl_attribute16
356: ,p_egl_attribute17_o => ben_egl_shd.g_old_rec.egl_attribute17
357: ,p_egl_attribute18_o => ben_egl_shd.g_old_rec.egl_attribute18
358: ,p_egl_attribute19_o => ben_egl_shd.g_old_rec.egl_attribute19
359: ,p_egl_attribute20_o => ben_egl_shd.g_old_rec.egl_attribute20
360: ,p_egl_attribute21_o => ben_egl_shd.g_old_rec.egl_attribute21
353: ,p_egl_attribute14_o => ben_egl_shd.g_old_rec.egl_attribute14
354: ,p_egl_attribute15_o => ben_egl_shd.g_old_rec.egl_attribute15
355: ,p_egl_attribute16_o => ben_egl_shd.g_old_rec.egl_attribute16
356: ,p_egl_attribute17_o => ben_egl_shd.g_old_rec.egl_attribute17
357: ,p_egl_attribute18_o => ben_egl_shd.g_old_rec.egl_attribute18
358: ,p_egl_attribute19_o => ben_egl_shd.g_old_rec.egl_attribute19
359: ,p_egl_attribute20_o => ben_egl_shd.g_old_rec.egl_attribute20
360: ,p_egl_attribute21_o => ben_egl_shd.g_old_rec.egl_attribute21
361: ,p_egl_attribute22_o => ben_egl_shd.g_old_rec.egl_attribute22
354: ,p_egl_attribute15_o => ben_egl_shd.g_old_rec.egl_attribute15
355: ,p_egl_attribute16_o => ben_egl_shd.g_old_rec.egl_attribute16
356: ,p_egl_attribute17_o => ben_egl_shd.g_old_rec.egl_attribute17
357: ,p_egl_attribute18_o => ben_egl_shd.g_old_rec.egl_attribute18
358: ,p_egl_attribute19_o => ben_egl_shd.g_old_rec.egl_attribute19
359: ,p_egl_attribute20_o => ben_egl_shd.g_old_rec.egl_attribute20
360: ,p_egl_attribute21_o => ben_egl_shd.g_old_rec.egl_attribute21
361: ,p_egl_attribute22_o => ben_egl_shd.g_old_rec.egl_attribute22
362: ,p_egl_attribute23_o => ben_egl_shd.g_old_rec.egl_attribute23
355: ,p_egl_attribute16_o => ben_egl_shd.g_old_rec.egl_attribute16
356: ,p_egl_attribute17_o => ben_egl_shd.g_old_rec.egl_attribute17
357: ,p_egl_attribute18_o => ben_egl_shd.g_old_rec.egl_attribute18
358: ,p_egl_attribute19_o => ben_egl_shd.g_old_rec.egl_attribute19
359: ,p_egl_attribute20_o => ben_egl_shd.g_old_rec.egl_attribute20
360: ,p_egl_attribute21_o => ben_egl_shd.g_old_rec.egl_attribute21
361: ,p_egl_attribute22_o => ben_egl_shd.g_old_rec.egl_attribute22
362: ,p_egl_attribute23_o => ben_egl_shd.g_old_rec.egl_attribute23
363: ,p_egl_attribute24_o => ben_egl_shd.g_old_rec.egl_attribute24
356: ,p_egl_attribute17_o => ben_egl_shd.g_old_rec.egl_attribute17
357: ,p_egl_attribute18_o => ben_egl_shd.g_old_rec.egl_attribute18
358: ,p_egl_attribute19_o => ben_egl_shd.g_old_rec.egl_attribute19
359: ,p_egl_attribute20_o => ben_egl_shd.g_old_rec.egl_attribute20
360: ,p_egl_attribute21_o => ben_egl_shd.g_old_rec.egl_attribute21
361: ,p_egl_attribute22_o => ben_egl_shd.g_old_rec.egl_attribute22
362: ,p_egl_attribute23_o => ben_egl_shd.g_old_rec.egl_attribute23
363: ,p_egl_attribute24_o => ben_egl_shd.g_old_rec.egl_attribute24
364: ,p_egl_attribute25_o => ben_egl_shd.g_old_rec.egl_attribute25
357: ,p_egl_attribute18_o => ben_egl_shd.g_old_rec.egl_attribute18
358: ,p_egl_attribute19_o => ben_egl_shd.g_old_rec.egl_attribute19
359: ,p_egl_attribute20_o => ben_egl_shd.g_old_rec.egl_attribute20
360: ,p_egl_attribute21_o => ben_egl_shd.g_old_rec.egl_attribute21
361: ,p_egl_attribute22_o => ben_egl_shd.g_old_rec.egl_attribute22
362: ,p_egl_attribute23_o => ben_egl_shd.g_old_rec.egl_attribute23
363: ,p_egl_attribute24_o => ben_egl_shd.g_old_rec.egl_attribute24
364: ,p_egl_attribute25_o => ben_egl_shd.g_old_rec.egl_attribute25
365: ,p_egl_attribute26_o => ben_egl_shd.g_old_rec.egl_attribute26
358: ,p_egl_attribute19_o => ben_egl_shd.g_old_rec.egl_attribute19
359: ,p_egl_attribute20_o => ben_egl_shd.g_old_rec.egl_attribute20
360: ,p_egl_attribute21_o => ben_egl_shd.g_old_rec.egl_attribute21
361: ,p_egl_attribute22_o => ben_egl_shd.g_old_rec.egl_attribute22
362: ,p_egl_attribute23_o => ben_egl_shd.g_old_rec.egl_attribute23
363: ,p_egl_attribute24_o => ben_egl_shd.g_old_rec.egl_attribute24
364: ,p_egl_attribute25_o => ben_egl_shd.g_old_rec.egl_attribute25
365: ,p_egl_attribute26_o => ben_egl_shd.g_old_rec.egl_attribute26
366: ,p_egl_attribute27_o => ben_egl_shd.g_old_rec.egl_attribute27
359: ,p_egl_attribute20_o => ben_egl_shd.g_old_rec.egl_attribute20
360: ,p_egl_attribute21_o => ben_egl_shd.g_old_rec.egl_attribute21
361: ,p_egl_attribute22_o => ben_egl_shd.g_old_rec.egl_attribute22
362: ,p_egl_attribute23_o => ben_egl_shd.g_old_rec.egl_attribute23
363: ,p_egl_attribute24_o => ben_egl_shd.g_old_rec.egl_attribute24
364: ,p_egl_attribute25_o => ben_egl_shd.g_old_rec.egl_attribute25
365: ,p_egl_attribute26_o => ben_egl_shd.g_old_rec.egl_attribute26
366: ,p_egl_attribute27_o => ben_egl_shd.g_old_rec.egl_attribute27
367: ,p_egl_attribute28_o => ben_egl_shd.g_old_rec.egl_attribute28
360: ,p_egl_attribute21_o => ben_egl_shd.g_old_rec.egl_attribute21
361: ,p_egl_attribute22_o => ben_egl_shd.g_old_rec.egl_attribute22
362: ,p_egl_attribute23_o => ben_egl_shd.g_old_rec.egl_attribute23
363: ,p_egl_attribute24_o => ben_egl_shd.g_old_rec.egl_attribute24
364: ,p_egl_attribute25_o => ben_egl_shd.g_old_rec.egl_attribute25
365: ,p_egl_attribute26_o => ben_egl_shd.g_old_rec.egl_attribute26
366: ,p_egl_attribute27_o => ben_egl_shd.g_old_rec.egl_attribute27
367: ,p_egl_attribute28_o => ben_egl_shd.g_old_rec.egl_attribute28
368: ,p_egl_attribute29_o => ben_egl_shd.g_old_rec.egl_attribute29
361: ,p_egl_attribute22_o => ben_egl_shd.g_old_rec.egl_attribute22
362: ,p_egl_attribute23_o => ben_egl_shd.g_old_rec.egl_attribute23
363: ,p_egl_attribute24_o => ben_egl_shd.g_old_rec.egl_attribute24
364: ,p_egl_attribute25_o => ben_egl_shd.g_old_rec.egl_attribute25
365: ,p_egl_attribute26_o => ben_egl_shd.g_old_rec.egl_attribute26
366: ,p_egl_attribute27_o => ben_egl_shd.g_old_rec.egl_attribute27
367: ,p_egl_attribute28_o => ben_egl_shd.g_old_rec.egl_attribute28
368: ,p_egl_attribute29_o => ben_egl_shd.g_old_rec.egl_attribute29
369: ,p_egl_attribute30_o => ben_egl_shd.g_old_rec.egl_attribute30
362: ,p_egl_attribute23_o => ben_egl_shd.g_old_rec.egl_attribute23
363: ,p_egl_attribute24_o => ben_egl_shd.g_old_rec.egl_attribute24
364: ,p_egl_attribute25_o => ben_egl_shd.g_old_rec.egl_attribute25
365: ,p_egl_attribute26_o => ben_egl_shd.g_old_rec.egl_attribute26
366: ,p_egl_attribute27_o => ben_egl_shd.g_old_rec.egl_attribute27
367: ,p_egl_attribute28_o => ben_egl_shd.g_old_rec.egl_attribute28
368: ,p_egl_attribute29_o => ben_egl_shd.g_old_rec.egl_attribute29
369: ,p_egl_attribute30_o => ben_egl_shd.g_old_rec.egl_attribute30
370: ,p_object_version_number_o => ben_egl_shd.g_old_rec.object_version_number
363: ,p_egl_attribute24_o => ben_egl_shd.g_old_rec.egl_attribute24
364: ,p_egl_attribute25_o => ben_egl_shd.g_old_rec.egl_attribute25
365: ,p_egl_attribute26_o => ben_egl_shd.g_old_rec.egl_attribute26
366: ,p_egl_attribute27_o => ben_egl_shd.g_old_rec.egl_attribute27
367: ,p_egl_attribute28_o => ben_egl_shd.g_old_rec.egl_attribute28
368: ,p_egl_attribute29_o => ben_egl_shd.g_old_rec.egl_attribute29
369: ,p_egl_attribute30_o => ben_egl_shd.g_old_rec.egl_attribute30
370: ,p_object_version_number_o => ben_egl_shd.g_old_rec.object_version_number
371: ,p_allw_range_validation_flg2_o => ben_egl_shd.g_old_rec.allow_range_validation_flag2
364: ,p_egl_attribute25_o => ben_egl_shd.g_old_rec.egl_attribute25
365: ,p_egl_attribute26_o => ben_egl_shd.g_old_rec.egl_attribute26
366: ,p_egl_attribute27_o => ben_egl_shd.g_old_rec.egl_attribute27
367: ,p_egl_attribute28_o => ben_egl_shd.g_old_rec.egl_attribute28
368: ,p_egl_attribute29_o => ben_egl_shd.g_old_rec.egl_attribute29
369: ,p_egl_attribute30_o => ben_egl_shd.g_old_rec.egl_attribute30
370: ,p_object_version_number_o => ben_egl_shd.g_old_rec.object_version_number
371: ,p_allw_range_validation_flg2_o => ben_egl_shd.g_old_rec.allow_range_validation_flag2
372: ,p_access_calc_rule2_o => ben_egl_shd.g_old_rec.access_calc_rule2
365: ,p_egl_attribute26_o => ben_egl_shd.g_old_rec.egl_attribute26
366: ,p_egl_attribute27_o => ben_egl_shd.g_old_rec.egl_attribute27
367: ,p_egl_attribute28_o => ben_egl_shd.g_old_rec.egl_attribute28
368: ,p_egl_attribute29_o => ben_egl_shd.g_old_rec.egl_attribute29
369: ,p_egl_attribute30_o => ben_egl_shd.g_old_rec.egl_attribute30
370: ,p_object_version_number_o => ben_egl_shd.g_old_rec.object_version_number
371: ,p_allw_range_validation_flg2_o => ben_egl_shd.g_old_rec.allow_range_validation_flag2
372: ,p_access_calc_rule2_o => ben_egl_shd.g_old_rec.access_calc_rule2
373: ,p_time_access_calc_rule1_o => ben_egl_shd.g_old_rec.time_access_calc_rule1
366: ,p_egl_attribute27_o => ben_egl_shd.g_old_rec.egl_attribute27
367: ,p_egl_attribute28_o => ben_egl_shd.g_old_rec.egl_attribute28
368: ,p_egl_attribute29_o => ben_egl_shd.g_old_rec.egl_attribute29
369: ,p_egl_attribute30_o => ben_egl_shd.g_old_rec.egl_attribute30
370: ,p_object_version_number_o => ben_egl_shd.g_old_rec.object_version_number
371: ,p_allw_range_validation_flg2_o => ben_egl_shd.g_old_rec.allow_range_validation_flag2
372: ,p_access_calc_rule2_o => ben_egl_shd.g_old_rec.access_calc_rule2
373: ,p_time_access_calc_rule1_o => ben_egl_shd.g_old_rec.time_access_calc_rule1
374: ,p_time_access_calc_rule2_o => ben_egl_shd.g_old_rec.time_access_calc_rule2
367: ,p_egl_attribute28_o => ben_egl_shd.g_old_rec.egl_attribute28
368: ,p_egl_attribute29_o => ben_egl_shd.g_old_rec.egl_attribute29
369: ,p_egl_attribute30_o => ben_egl_shd.g_old_rec.egl_attribute30
370: ,p_object_version_number_o => ben_egl_shd.g_old_rec.object_version_number
371: ,p_allw_range_validation_flg2_o => ben_egl_shd.g_old_rec.allow_range_validation_flag2
372: ,p_access_calc_rule2_o => ben_egl_shd.g_old_rec.access_calc_rule2
373: ,p_time_access_calc_rule1_o => ben_egl_shd.g_old_rec.time_access_calc_rule1
374: ,p_time_access_calc_rule2_o => ben_egl_shd.g_old_rec.time_access_calc_rule2
375: );
368: ,p_egl_attribute29_o => ben_egl_shd.g_old_rec.egl_attribute29
369: ,p_egl_attribute30_o => ben_egl_shd.g_old_rec.egl_attribute30
370: ,p_object_version_number_o => ben_egl_shd.g_old_rec.object_version_number
371: ,p_allw_range_validation_flg2_o => ben_egl_shd.g_old_rec.allow_range_validation_flag2
372: ,p_access_calc_rule2_o => ben_egl_shd.g_old_rec.access_calc_rule2
373: ,p_time_access_calc_rule1_o => ben_egl_shd.g_old_rec.time_access_calc_rule1
374: ,p_time_access_calc_rule2_o => ben_egl_shd.g_old_rec.time_access_calc_rule2
375: );
376: --
369: ,p_egl_attribute30_o => ben_egl_shd.g_old_rec.egl_attribute30
370: ,p_object_version_number_o => ben_egl_shd.g_old_rec.object_version_number
371: ,p_allw_range_validation_flg2_o => ben_egl_shd.g_old_rec.allow_range_validation_flag2
372: ,p_access_calc_rule2_o => ben_egl_shd.g_old_rec.access_calc_rule2
373: ,p_time_access_calc_rule1_o => ben_egl_shd.g_old_rec.time_access_calc_rule1
374: ,p_time_access_calc_rule2_o => ben_egl_shd.g_old_rec.time_access_calc_rule2
375: );
376: --
377: exception
370: ,p_object_version_number_o => ben_egl_shd.g_old_rec.object_version_number
371: ,p_allw_range_validation_flg2_o => ben_egl_shd.g_old_rec.allow_range_validation_flag2
372: ,p_access_calc_rule2_o => ben_egl_shd.g_old_rec.access_calc_rule2
373: ,p_time_access_calc_rule1_o => ben_egl_shd.g_old_rec.time_access_calc_rule1
374: ,p_time_access_calc_rule2_o => ben_egl_shd.g_old_rec.time_access_calc_rule2
375: );
376: --
377: exception
378: --
432: -- Internal Row Handler Use Only.
433: --
434: -- {End Of Comments}
435: -- ----------------------------------------------------------------------------
436: Procedure convert_defs(p_rec in out nocopy ben_egl_shd.g_rec_type) is
437: --
438: l_proc varchar2(72) := g_package||'convert_defs';
439: --
440: Begin
448: --
449:
450: If (p_rec.name = hr_api.g_varchar2) then
451: p_rec.name :=
452: ben_egl_shd.g_old_rec.name;
453: End If;
454: If (p_rec.short_code = hr_api.g_varchar2) then
455: p_rec.short_code :=
456: ben_egl_shd.g_old_rec.short_code;
452: ben_egl_shd.g_old_rec.name;
453: End If;
454: If (p_rec.short_code = hr_api.g_varchar2) then
455: p_rec.short_code :=
456: ben_egl_shd.g_old_rec.short_code;
457: End If;
458: If (p_rec.description = hr_api.g_varchar2) then
459: p_rec.description :=
460: ben_egl_shd.g_old_rec.description;
456: ben_egl_shd.g_old_rec.short_code;
457: End If;
458: If (p_rec.description = hr_api.g_varchar2) then
459: p_rec.description :=
460: ben_egl_shd.g_old_rec.description;
461: End If;
462: If (p_rec.criteria_type = hr_api.g_varchar2) then
463: p_rec.criteria_type :=
464: ben_egl_shd.g_old_rec.criteria_type;
460: ben_egl_shd.g_old_rec.description;
461: End If;
462: If (p_rec.criteria_type = hr_api.g_varchar2) then
463: p_rec.criteria_type :=
464: ben_egl_shd.g_old_rec.criteria_type;
465: End If;
466: If (p_rec.crit_col1_val_type_cd = hr_api.g_varchar2) then
467: p_rec.crit_col1_val_type_cd :=
468: ben_egl_shd.g_old_rec.crit_col1_val_type_cd;
464: ben_egl_shd.g_old_rec.criteria_type;
465: End If;
466: If (p_rec.crit_col1_val_type_cd = hr_api.g_varchar2) then
467: p_rec.crit_col1_val_type_cd :=
468: ben_egl_shd.g_old_rec.crit_col1_val_type_cd;
469: End If;
470: If (p_rec.crit_col1_datatype = hr_api.g_varchar2) then
471: p_rec.crit_col1_datatype :=
472: ben_egl_shd.g_old_rec.crit_col1_datatype;
468: ben_egl_shd.g_old_rec.crit_col1_val_type_cd;
469: End If;
470: If (p_rec.crit_col1_datatype = hr_api.g_varchar2) then
471: p_rec.crit_col1_datatype :=
472: ben_egl_shd.g_old_rec.crit_col1_datatype;
473: End If;
474: If (p_rec.col1_lookup_type = hr_api.g_varchar2) then
475: p_rec.col1_lookup_type :=
476: ben_egl_shd.g_old_rec.col1_lookup_type;
472: ben_egl_shd.g_old_rec.crit_col1_datatype;
473: End If;
474: If (p_rec.col1_lookup_type = hr_api.g_varchar2) then
475: p_rec.col1_lookup_type :=
476: ben_egl_shd.g_old_rec.col1_lookup_type;
477: End If;
478: If (p_rec.col1_value_set_id = hr_api.g_number) then
479: p_rec.col1_value_set_id :=
480: ben_egl_shd.g_old_rec.col1_value_set_id;
476: ben_egl_shd.g_old_rec.col1_lookup_type;
477: End If;
478: If (p_rec.col1_value_set_id = hr_api.g_number) then
479: p_rec.col1_value_set_id :=
480: ben_egl_shd.g_old_rec.col1_value_set_id;
481: End If;
482: If (p_rec.access_table_name1 = hr_api.g_varchar2) then
483: p_rec.access_table_name1 :=
484: ben_egl_shd.g_old_rec.access_table_name1;
480: ben_egl_shd.g_old_rec.col1_value_set_id;
481: End If;
482: If (p_rec.access_table_name1 = hr_api.g_varchar2) then
483: p_rec.access_table_name1 :=
484: ben_egl_shd.g_old_rec.access_table_name1;
485: End If;
486: If (p_rec.access_column_name1 = hr_api.g_varchar2) then
487: p_rec.access_column_name1 :=
488: ben_egl_shd.g_old_rec.access_column_name1;
484: ben_egl_shd.g_old_rec.access_table_name1;
485: End If;
486: If (p_rec.access_column_name1 = hr_api.g_varchar2) then
487: p_rec.access_column_name1 :=
488: ben_egl_shd.g_old_rec.access_column_name1;
489: End If;
490: If (p_rec.time_entry_access_tab_nam1 = hr_api.g_varchar2) then
491: p_rec.time_entry_access_tab_nam1 :=
492: ben_egl_shd.g_old_rec.time_entry_access_tab_nam1;
488: ben_egl_shd.g_old_rec.access_column_name1;
489: End If;
490: If (p_rec.time_entry_access_tab_nam1 = hr_api.g_varchar2) then
491: p_rec.time_entry_access_tab_nam1 :=
492: ben_egl_shd.g_old_rec.time_entry_access_tab_nam1;
493: End If;
494: If (p_rec.time_entry_access_col_nam1 = hr_api.g_varchar2) then
495: p_rec.time_entry_access_col_nam1 :=
496: ben_egl_shd.g_old_rec.time_entry_access_col_nam1;
492: ben_egl_shd.g_old_rec.time_entry_access_tab_nam1;
493: End If;
494: If (p_rec.time_entry_access_col_nam1 = hr_api.g_varchar2) then
495: p_rec.time_entry_access_col_nam1 :=
496: ben_egl_shd.g_old_rec.time_entry_access_col_nam1;
497: End If;
498: If (p_rec.crit_col2_val_type_cd = hr_api.g_varchar2) then
499: p_rec.crit_col2_val_type_cd :=
500: ben_egl_shd.g_old_rec.crit_col2_val_type_cd;
496: ben_egl_shd.g_old_rec.time_entry_access_col_nam1;
497: End If;
498: If (p_rec.crit_col2_val_type_cd = hr_api.g_varchar2) then
499: p_rec.crit_col2_val_type_cd :=
500: ben_egl_shd.g_old_rec.crit_col2_val_type_cd;
501: End If;
502: If (p_rec.crit_col2_datatype = hr_api.g_varchar2) then
503: p_rec.crit_col2_datatype :=
504: ben_egl_shd.g_old_rec.crit_col2_datatype;
500: ben_egl_shd.g_old_rec.crit_col2_val_type_cd;
501: End If;
502: If (p_rec.crit_col2_datatype = hr_api.g_varchar2) then
503: p_rec.crit_col2_datatype :=
504: ben_egl_shd.g_old_rec.crit_col2_datatype;
505: End If;
506: If (p_rec.col2_lookup_type = hr_api.g_varchar2) then
507: p_rec.col2_lookup_type :=
508: ben_egl_shd.g_old_rec.col2_lookup_type;
504: ben_egl_shd.g_old_rec.crit_col2_datatype;
505: End If;
506: If (p_rec.col2_lookup_type = hr_api.g_varchar2) then
507: p_rec.col2_lookup_type :=
508: ben_egl_shd.g_old_rec.col2_lookup_type;
509: End If;
510: If (p_rec.col2_value_set_id = hr_api.g_number) then
511: p_rec.col2_value_set_id :=
512: ben_egl_shd.g_old_rec.col2_value_set_id;
508: ben_egl_shd.g_old_rec.col2_lookup_type;
509: End If;
510: If (p_rec.col2_value_set_id = hr_api.g_number) then
511: p_rec.col2_value_set_id :=
512: ben_egl_shd.g_old_rec.col2_value_set_id;
513: End If;
514: If (p_rec.access_table_name2 = hr_api.g_varchar2) then
515: p_rec.access_table_name2 :=
516: ben_egl_shd.g_old_rec.access_table_name2;
512: ben_egl_shd.g_old_rec.col2_value_set_id;
513: End If;
514: If (p_rec.access_table_name2 = hr_api.g_varchar2) then
515: p_rec.access_table_name2 :=
516: ben_egl_shd.g_old_rec.access_table_name2;
517: End If;
518: If (p_rec.access_column_name2 = hr_api.g_varchar2) then
519: p_rec.access_column_name2 :=
520: ben_egl_shd.g_old_rec.access_column_name2;
516: ben_egl_shd.g_old_rec.access_table_name2;
517: End If;
518: If (p_rec.access_column_name2 = hr_api.g_varchar2) then
519: p_rec.access_column_name2 :=
520: ben_egl_shd.g_old_rec.access_column_name2;
521: End If;
522: If (p_rec.time_entry_access_tab_nam2 = hr_api.g_varchar2) then
523: p_rec.time_entry_access_tab_nam2 :=
524: ben_egl_shd.g_old_rec.time_entry_access_tab_nam2;
520: ben_egl_shd.g_old_rec.access_column_name2;
521: End If;
522: If (p_rec.time_entry_access_tab_nam2 = hr_api.g_varchar2) then
523: p_rec.time_entry_access_tab_nam2 :=
524: ben_egl_shd.g_old_rec.time_entry_access_tab_nam2;
525: End If;
526: If (p_rec.time_entry_access_col_nam2 = hr_api.g_varchar2) then
527: p_rec.time_entry_access_col_nam2 :=
528: ben_egl_shd.g_old_rec.time_entry_access_col_nam2;
524: ben_egl_shd.g_old_rec.time_entry_access_tab_nam2;
525: End If;
526: If (p_rec.time_entry_access_col_nam2 = hr_api.g_varchar2) then
527: p_rec.time_entry_access_col_nam2 :=
528: ben_egl_shd.g_old_rec.time_entry_access_col_nam2;
529: End If;
530: If (p_rec.access_calc_rule = hr_api.g_number) then
531: p_rec.access_calc_rule :=
532: ben_egl_shd.g_old_rec.access_calc_rule;
528: ben_egl_shd.g_old_rec.time_entry_access_col_nam2;
529: End If;
530: If (p_rec.access_calc_rule = hr_api.g_number) then
531: p_rec.access_calc_rule :=
532: ben_egl_shd.g_old_rec.access_calc_rule;
533: End If;
534: If (p_rec.allow_range_validation_flg = hr_api.g_varchar2) then
535: p_rec.allow_range_validation_flg :=
536: ben_egl_shd.g_old_rec.allow_range_validation_flg;
532: ben_egl_shd.g_old_rec.access_calc_rule;
533: End If;
534: If (p_rec.allow_range_validation_flg = hr_api.g_varchar2) then
535: p_rec.allow_range_validation_flg :=
536: ben_egl_shd.g_old_rec.allow_range_validation_flg;
537: End If;
538: If (p_rec.user_defined_flag = hr_api.g_varchar2) then
539: p_rec.user_defined_flag :=
540: ben_egl_shd.g_old_rec.user_defined_flag;
536: ben_egl_shd.g_old_rec.allow_range_validation_flg;
537: End If;
538: If (p_rec.user_defined_flag = hr_api.g_varchar2) then
539: p_rec.user_defined_flag :=
540: ben_egl_shd.g_old_rec.user_defined_flag;
541: End If;
542: If (p_rec.legislation_code = hr_api.g_varchar2) then
543: p_rec.legislation_code :=
544: ben_egl_shd.g_old_rec.legislation_code;
540: ben_egl_shd.g_old_rec.user_defined_flag;
541: End If;
542: If (p_rec.legislation_code = hr_api.g_varchar2) then
543: p_rec.legislation_code :=
544: ben_egl_shd.g_old_rec.legislation_code;
545: End If;
546: If (p_rec.business_group_id = hr_api.g_number) then
547: p_rec.business_group_id :=
548: ben_egl_shd.g_old_rec.business_group_id;
544: ben_egl_shd.g_old_rec.legislation_code;
545: End If;
546: If (p_rec.business_group_id = hr_api.g_number) then
547: p_rec.business_group_id :=
548: ben_egl_shd.g_old_rec.business_group_id;
549: End If;
550:
551: If (p_rec.egl_attribute_category = hr_api.g_varchar2) then
552: p_rec.egl_attribute_category :=
549: End If;
550:
551: If (p_rec.egl_attribute_category = hr_api.g_varchar2) then
552: p_rec.egl_attribute_category :=
553: ben_egl_shd.g_old_rec.egl_attribute_category;
554: End If;
555: If (p_rec.egl_attribute1 = hr_api.g_varchar2) then
556: p_rec.egl_attribute1 :=
557: ben_egl_shd.g_old_rec.egl_attribute1;
553: ben_egl_shd.g_old_rec.egl_attribute_category;
554: End If;
555: If (p_rec.egl_attribute1 = hr_api.g_varchar2) then
556: p_rec.egl_attribute1 :=
557: ben_egl_shd.g_old_rec.egl_attribute1;
558: End If;
559: If (p_rec.egl_attribute2 = hr_api.g_varchar2) then
560: p_rec.egl_attribute2 :=
561: ben_egl_shd.g_old_rec.egl_attribute2;
557: ben_egl_shd.g_old_rec.egl_attribute1;
558: End If;
559: If (p_rec.egl_attribute2 = hr_api.g_varchar2) then
560: p_rec.egl_attribute2 :=
561: ben_egl_shd.g_old_rec.egl_attribute2;
562: End If;
563: If (p_rec.egl_attribute3 = hr_api.g_varchar2) then
564: p_rec.egl_attribute3 :=
565: ben_egl_shd.g_old_rec.egl_attribute3;
561: ben_egl_shd.g_old_rec.egl_attribute2;
562: End If;
563: If (p_rec.egl_attribute3 = hr_api.g_varchar2) then
564: p_rec.egl_attribute3 :=
565: ben_egl_shd.g_old_rec.egl_attribute3;
566: End If;
567: If (p_rec.egl_attribute4 = hr_api.g_varchar2) then
568: p_rec.egl_attribute4 :=
569: ben_egl_shd.g_old_rec.egl_attribute4;
565: ben_egl_shd.g_old_rec.egl_attribute3;
566: End If;
567: If (p_rec.egl_attribute4 = hr_api.g_varchar2) then
568: p_rec.egl_attribute4 :=
569: ben_egl_shd.g_old_rec.egl_attribute4;
570: End If;
571: If (p_rec.egl_attribute5 = hr_api.g_varchar2) then
572: p_rec.egl_attribute5 :=
573: ben_egl_shd.g_old_rec.egl_attribute5;
569: ben_egl_shd.g_old_rec.egl_attribute4;
570: End If;
571: If (p_rec.egl_attribute5 = hr_api.g_varchar2) then
572: p_rec.egl_attribute5 :=
573: ben_egl_shd.g_old_rec.egl_attribute5;
574: End If;
575: If (p_rec.egl_attribute6 = hr_api.g_varchar2) then
576: p_rec.egl_attribute6 :=
577: ben_egl_shd.g_old_rec.egl_attribute6;
573: ben_egl_shd.g_old_rec.egl_attribute5;
574: End If;
575: If (p_rec.egl_attribute6 = hr_api.g_varchar2) then
576: p_rec.egl_attribute6 :=
577: ben_egl_shd.g_old_rec.egl_attribute6;
578: End If;
579: If (p_rec.egl_attribute7 = hr_api.g_varchar2) then
580: p_rec.egl_attribute7 :=
581: ben_egl_shd.g_old_rec.egl_attribute7;
577: ben_egl_shd.g_old_rec.egl_attribute6;
578: End If;
579: If (p_rec.egl_attribute7 = hr_api.g_varchar2) then
580: p_rec.egl_attribute7 :=
581: ben_egl_shd.g_old_rec.egl_attribute7;
582: End If;
583: If (p_rec.egl_attribute8 = hr_api.g_varchar2) then
584: p_rec.egl_attribute8 :=
585: ben_egl_shd.g_old_rec.egl_attribute8;
581: ben_egl_shd.g_old_rec.egl_attribute7;
582: End If;
583: If (p_rec.egl_attribute8 = hr_api.g_varchar2) then
584: p_rec.egl_attribute8 :=
585: ben_egl_shd.g_old_rec.egl_attribute8;
586: End If;
587: If (p_rec.egl_attribute9 = hr_api.g_varchar2) then
588: p_rec.egl_attribute9 :=
589: ben_egl_shd.g_old_rec.egl_attribute9;
585: ben_egl_shd.g_old_rec.egl_attribute8;
586: End If;
587: If (p_rec.egl_attribute9 = hr_api.g_varchar2) then
588: p_rec.egl_attribute9 :=
589: ben_egl_shd.g_old_rec.egl_attribute9;
590: End If;
591: If (p_rec.egl_attribute10 = hr_api.g_varchar2) then
592: p_rec.egl_attribute10 :=
593: ben_egl_shd.g_old_rec.egl_attribute10;
589: ben_egl_shd.g_old_rec.egl_attribute9;
590: End If;
591: If (p_rec.egl_attribute10 = hr_api.g_varchar2) then
592: p_rec.egl_attribute10 :=
593: ben_egl_shd.g_old_rec.egl_attribute10;
594: End If;
595: If (p_rec.egl_attribute11 = hr_api.g_varchar2) then
596: p_rec.egl_attribute11 :=
597: ben_egl_shd.g_old_rec.egl_attribute11;
593: ben_egl_shd.g_old_rec.egl_attribute10;
594: End If;
595: If (p_rec.egl_attribute11 = hr_api.g_varchar2) then
596: p_rec.egl_attribute11 :=
597: ben_egl_shd.g_old_rec.egl_attribute11;
598: End If;
599: If (p_rec.egl_attribute12 = hr_api.g_varchar2) then
600: p_rec.egl_attribute12 :=
601: ben_egl_shd.g_old_rec.egl_attribute12;
597: ben_egl_shd.g_old_rec.egl_attribute11;
598: End If;
599: If (p_rec.egl_attribute12 = hr_api.g_varchar2) then
600: p_rec.egl_attribute12 :=
601: ben_egl_shd.g_old_rec.egl_attribute12;
602: End If;
603: If (p_rec.egl_attribute13 = hr_api.g_varchar2) then
604: p_rec.egl_attribute13 :=
605: ben_egl_shd.g_old_rec.egl_attribute13;
601: ben_egl_shd.g_old_rec.egl_attribute12;
602: End If;
603: If (p_rec.egl_attribute13 = hr_api.g_varchar2) then
604: p_rec.egl_attribute13 :=
605: ben_egl_shd.g_old_rec.egl_attribute13;
606: End If;
607: If (p_rec.egl_attribute14 = hr_api.g_varchar2) then
608: p_rec.egl_attribute14 :=
609: ben_egl_shd.g_old_rec.egl_attribute14;
605: ben_egl_shd.g_old_rec.egl_attribute13;
606: End If;
607: If (p_rec.egl_attribute14 = hr_api.g_varchar2) then
608: p_rec.egl_attribute14 :=
609: ben_egl_shd.g_old_rec.egl_attribute14;
610: End If;
611: If (p_rec.egl_attribute15 = hr_api.g_varchar2) then
612: p_rec.egl_attribute15 :=
613: ben_egl_shd.g_old_rec.egl_attribute15;
609: ben_egl_shd.g_old_rec.egl_attribute14;
610: End If;
611: If (p_rec.egl_attribute15 = hr_api.g_varchar2) then
612: p_rec.egl_attribute15 :=
613: ben_egl_shd.g_old_rec.egl_attribute15;
614: End If;
615: If (p_rec.egl_attribute16 = hr_api.g_varchar2) then
616: p_rec.egl_attribute16 :=
617: ben_egl_shd.g_old_rec.egl_attribute16;
613: ben_egl_shd.g_old_rec.egl_attribute15;
614: End If;
615: If (p_rec.egl_attribute16 = hr_api.g_varchar2) then
616: p_rec.egl_attribute16 :=
617: ben_egl_shd.g_old_rec.egl_attribute16;
618: End If;
619: If (p_rec.egl_attribute17 = hr_api.g_varchar2) then
620: p_rec.egl_attribute17 :=
621: ben_egl_shd.g_old_rec.egl_attribute17;
617: ben_egl_shd.g_old_rec.egl_attribute16;
618: End If;
619: If (p_rec.egl_attribute17 = hr_api.g_varchar2) then
620: p_rec.egl_attribute17 :=
621: ben_egl_shd.g_old_rec.egl_attribute17;
622: End If;
623: If (p_rec.egl_attribute18 = hr_api.g_varchar2) then
624: p_rec.egl_attribute18 :=
625: ben_egl_shd.g_old_rec.egl_attribute18;
621: ben_egl_shd.g_old_rec.egl_attribute17;
622: End If;
623: If (p_rec.egl_attribute18 = hr_api.g_varchar2) then
624: p_rec.egl_attribute18 :=
625: ben_egl_shd.g_old_rec.egl_attribute18;
626: End If;
627: If (p_rec.egl_attribute19 = hr_api.g_varchar2) then
628: p_rec.egl_attribute19 :=
629: ben_egl_shd.g_old_rec.egl_attribute19;
625: ben_egl_shd.g_old_rec.egl_attribute18;
626: End If;
627: If (p_rec.egl_attribute19 = hr_api.g_varchar2) then
628: p_rec.egl_attribute19 :=
629: ben_egl_shd.g_old_rec.egl_attribute19;
630: End If;
631: If (p_rec.egl_attribute20 = hr_api.g_varchar2) then
632: p_rec.egl_attribute20 :=
633: ben_egl_shd.g_old_rec.egl_attribute20;
629: ben_egl_shd.g_old_rec.egl_attribute19;
630: End If;
631: If (p_rec.egl_attribute20 = hr_api.g_varchar2) then
632: p_rec.egl_attribute20 :=
633: ben_egl_shd.g_old_rec.egl_attribute20;
634: End If;
635: If (p_rec.egl_attribute21 = hr_api.g_varchar2) then
636: p_rec.egl_attribute21 :=
637: ben_egl_shd.g_old_rec.egl_attribute21;
633: ben_egl_shd.g_old_rec.egl_attribute20;
634: End If;
635: If (p_rec.egl_attribute21 = hr_api.g_varchar2) then
636: p_rec.egl_attribute21 :=
637: ben_egl_shd.g_old_rec.egl_attribute21;
638: End If;
639: If (p_rec.egl_attribute22 = hr_api.g_varchar2) then
640: p_rec.egl_attribute22 :=
641: ben_egl_shd.g_old_rec.egl_attribute22;
637: ben_egl_shd.g_old_rec.egl_attribute21;
638: End If;
639: If (p_rec.egl_attribute22 = hr_api.g_varchar2) then
640: p_rec.egl_attribute22 :=
641: ben_egl_shd.g_old_rec.egl_attribute22;
642: End If;
643: If (p_rec.egl_attribute23 = hr_api.g_varchar2) then
644: p_rec.egl_attribute23 :=
645: ben_egl_shd.g_old_rec.egl_attribute23;
641: ben_egl_shd.g_old_rec.egl_attribute22;
642: End If;
643: If (p_rec.egl_attribute23 = hr_api.g_varchar2) then
644: p_rec.egl_attribute23 :=
645: ben_egl_shd.g_old_rec.egl_attribute23;
646: End If;
647: If (p_rec.egl_attribute24 = hr_api.g_varchar2) then
648: p_rec.egl_attribute24 :=
649: ben_egl_shd.g_old_rec.egl_attribute24;
645: ben_egl_shd.g_old_rec.egl_attribute23;
646: End If;
647: If (p_rec.egl_attribute24 = hr_api.g_varchar2) then
648: p_rec.egl_attribute24 :=
649: ben_egl_shd.g_old_rec.egl_attribute24;
650: End If;
651: If (p_rec.egl_attribute25 = hr_api.g_varchar2) then
652: p_rec.egl_attribute25 :=
653: ben_egl_shd.g_old_rec.egl_attribute25;
649: ben_egl_shd.g_old_rec.egl_attribute24;
650: End If;
651: If (p_rec.egl_attribute25 = hr_api.g_varchar2) then
652: p_rec.egl_attribute25 :=
653: ben_egl_shd.g_old_rec.egl_attribute25;
654: End If;
655: If (p_rec.egl_attribute26 = hr_api.g_varchar2) then
656: p_rec.egl_attribute26 :=
657: ben_egl_shd.g_old_rec.egl_attribute26;
653: ben_egl_shd.g_old_rec.egl_attribute25;
654: End If;
655: If (p_rec.egl_attribute26 = hr_api.g_varchar2) then
656: p_rec.egl_attribute26 :=
657: ben_egl_shd.g_old_rec.egl_attribute26;
658: End If;
659: If (p_rec.egl_attribute27 = hr_api.g_varchar2) then
660: p_rec.egl_attribute27 :=
661: ben_egl_shd.g_old_rec.egl_attribute27;
657: ben_egl_shd.g_old_rec.egl_attribute26;
658: End If;
659: If (p_rec.egl_attribute27 = hr_api.g_varchar2) then
660: p_rec.egl_attribute27 :=
661: ben_egl_shd.g_old_rec.egl_attribute27;
662: End If;
663: If (p_rec.egl_attribute28 = hr_api.g_varchar2) then
664: p_rec.egl_attribute28 :=
665: ben_egl_shd.g_old_rec.egl_attribute28;
661: ben_egl_shd.g_old_rec.egl_attribute27;
662: End If;
663: If (p_rec.egl_attribute28 = hr_api.g_varchar2) then
664: p_rec.egl_attribute28 :=
665: ben_egl_shd.g_old_rec.egl_attribute28;
666: End If;
667: If (p_rec.egl_attribute29 = hr_api.g_varchar2) then
668: p_rec.egl_attribute29 :=
669: ben_egl_shd.g_old_rec.egl_attribute29;
665: ben_egl_shd.g_old_rec.egl_attribute28;
666: End If;
667: If (p_rec.egl_attribute29 = hr_api.g_varchar2) then
668: p_rec.egl_attribute29 :=
669: ben_egl_shd.g_old_rec.egl_attribute29;
670: End If;
671: If (p_rec.egl_attribute30 = hr_api.g_varchar2) then
672: p_rec.egl_attribute30 :=
673: ben_egl_shd.g_old_rec.egl_attribute30;
669: ben_egl_shd.g_old_rec.egl_attribute29;
670: End If;
671: If (p_rec.egl_attribute30 = hr_api.g_varchar2) then
672: p_rec.egl_attribute30 :=
673: ben_egl_shd.g_old_rec.egl_attribute30;
674: End If;
675: If (p_rec.allow_range_validation_flag2 = hr_api.g_varchar2) then
676: p_rec.allow_range_validation_flag2 :=
677: ben_egl_shd.g_old_rec.allow_range_validation_flag2;
673: ben_egl_shd.g_old_rec.egl_attribute30;
674: End If;
675: If (p_rec.allow_range_validation_flag2 = hr_api.g_varchar2) then
676: p_rec.allow_range_validation_flag2 :=
677: ben_egl_shd.g_old_rec.allow_range_validation_flag2;
678: End If;
679: If (p_rec.access_calc_rule2 = hr_api.g_number) then
680: p_rec.access_calc_rule2 :=
681: ben_egl_shd.g_old_rec.access_calc_rule2;
677: ben_egl_shd.g_old_rec.allow_range_validation_flag2;
678: End If;
679: If (p_rec.access_calc_rule2 = hr_api.g_number) then
680: p_rec.access_calc_rule2 :=
681: ben_egl_shd.g_old_rec.access_calc_rule2;
682: End If;
683: If (p_rec.time_access_calc_rule1 = hr_api.g_number) then
684: p_rec.time_access_calc_rule1 :=
685: ben_egl_shd.g_old_rec.time_access_calc_rule1;
681: ben_egl_shd.g_old_rec.access_calc_rule2;
682: End If;
683: If (p_rec.time_access_calc_rule1 = hr_api.g_number) then
684: p_rec.time_access_calc_rule1 :=
685: ben_egl_shd.g_old_rec.time_access_calc_rule1;
686: End If;
687: If (p_rec.time_access_calc_rule2 = hr_api.g_number) then
688: p_rec.time_access_calc_rule2 :=
689: ben_egl_shd.g_old_rec.time_access_calc_rule2;
685: ben_egl_shd.g_old_rec.time_access_calc_rule1;
686: End If;
687: If (p_rec.time_access_calc_rule2 = hr_api.g_number) then
688: p_rec.time_access_calc_rule2 :=
689: ben_egl_shd.g_old_rec.time_access_calc_rule2;
690: End If;
691:
692: --
693: hr_utility.set_location(' Leaving:'||l_proc, 10);
698: -- |---------------------------------< upd >----------------------------------|
699: -- ----------------------------------------------------------------------------
700: Procedure upd
701: (
702: p_rec in out nocopy ben_egl_shd.g_rec_type
703: ,p_effective_date in date
704: ) is
705: --
706: l_proc varchar2(72) := g_package||'upd';
710: --
711: -- We must lock the row which we need to update.
712:
713: --
714: ben_egl_shd.lck(p_rec.eligy_criteria_id,
715: p_rec.object_version_number);
716: --
717: -- 1. During an update system defaults are used to determine if
718: -- arguments have been defaulted or not. We must therefore
805: ,p_time_access_calc_rule1 in number default hr_api.g_number
806: ,p_time_access_calc_rule2 in number default hr_api.g_number
807: ) is
808: --
809: l_rec ben_egl_shd.g_rec_type;
810: l_proc varchar2(72) := g_package||'upd';
811: --
812: Begin
813: hr_utility.set_location('Entering:'||l_proc, 5);
815: -- Call conversion function to turn arguments into the
816: -- l_rec structure.
817: --
818: l_rec :=
819: ben_egl_shd.convert_args
820: (
821: p_eligy_criteria_id
822: ,p_name
823: ,p_short_code