77: --
78: hr_utility.set_location(' Leaving:'||l_proc, 10);
79: --
80: Exception
81: When hr_api.check_integrity_violated Then
82: -- A check constraint has been violated
83: pqh_cef_shd.constraint_error
84: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
85: When hr_api.parent_integrity_violated Then
80: Exception
81: When hr_api.check_integrity_violated Then
82: -- A check constraint has been violated
83: pqh_cef_shd.constraint_error
84: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
85: When hr_api.parent_integrity_violated Then
86: -- Parent integrity has been violated
87: pqh_cef_shd.constraint_error
88: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
81: When hr_api.check_integrity_violated Then
82: -- A check constraint has been violated
83: pqh_cef_shd.constraint_error
84: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
85: When hr_api.parent_integrity_violated Then
86: -- Parent integrity has been violated
87: pqh_cef_shd.constraint_error
88: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
89: When hr_api.unique_integrity_violated Then
84: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
85: When hr_api.parent_integrity_violated Then
86: -- Parent integrity has been violated
87: pqh_cef_shd.constraint_error
88: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
89: When hr_api.unique_integrity_violated Then
90: -- Unique integrity has been violated
91: pqh_cef_shd.constraint_error
92: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
85: When hr_api.parent_integrity_violated Then
86: -- Parent integrity has been violated
87: pqh_cef_shd.constraint_error
88: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
89: When hr_api.unique_integrity_violated Then
90: -- Unique integrity has been violated
91: pqh_cef_shd.constraint_error
92: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
93: When Others Then
88: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
89: When hr_api.unique_integrity_violated Then
90: -- Unique integrity has been violated
91: pqh_cef_shd.constraint_error
92: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
93: When Others Then
94: Raise;
95: End update_dml;
96: --
202: );
203: --
204: exception
205: --
206: when hr_api.cannot_find_prog_unit then
207: --
208: hr_api.cannot_find_prog_unit_error
209: (p_module_name => 'pqh_copy_entity_functions'
210: ,p_hook_type => 'AU');
204: exception
205: --
206: when hr_api.cannot_find_prog_unit then
207: --
208: hr_api.cannot_find_prog_unit_error
209: (p_module_name => 'pqh_copy_entity_functions'
210: ,p_hook_type => 'AU');
211: --
212: end;
272: -- p_rec plsql record structure
273: -- to see if a system default is being used. If a system default
274: -- is being used then we must set to the 'current' argument value.
275: --
276: If (p_rec.table_route_id = hr_api.g_number) then
277: p_rec.table_route_id :=
278: pqh_cef_shd.g_old_rec.table_route_id;
279: End If;
280: If (p_rec.function_type_cd = hr_api.g_varchar2) then
276: If (p_rec.table_route_id = hr_api.g_number) then
277: p_rec.table_route_id :=
278: pqh_cef_shd.g_old_rec.table_route_id;
279: End If;
280: If (p_rec.function_type_cd = hr_api.g_varchar2) then
281: p_rec.function_type_cd :=
282: pqh_cef_shd.g_old_rec.function_type_cd;
283: End If;
284: If (p_rec.pre_copy_function_name = hr_api.g_varchar2) then
280: If (p_rec.function_type_cd = hr_api.g_varchar2) then
281: p_rec.function_type_cd :=
282: pqh_cef_shd.g_old_rec.function_type_cd;
283: End If;
284: If (p_rec.pre_copy_function_name = hr_api.g_varchar2) then
285: p_rec.pre_copy_function_name :=
286: pqh_cef_shd.g_old_rec.pre_copy_function_name;
287: End If;
288: If (p_rec.copy_function_name = hr_api.g_varchar2) then
284: If (p_rec.pre_copy_function_name = hr_api.g_varchar2) then
285: p_rec.pre_copy_function_name :=
286: pqh_cef_shd.g_old_rec.pre_copy_function_name;
287: End If;
288: If (p_rec.copy_function_name = hr_api.g_varchar2) then
289: p_rec.copy_function_name :=
290: pqh_cef_shd.g_old_rec.copy_function_name;
291: End If;
292: If (p_rec.post_copy_function_name = hr_api.g_varchar2) then
288: If (p_rec.copy_function_name = hr_api.g_varchar2) then
289: p_rec.copy_function_name :=
290: pqh_cef_shd.g_old_rec.copy_function_name;
291: End If;
292: If (p_rec.post_copy_function_name = hr_api.g_varchar2) then
293: p_rec.post_copy_function_name :=
294: pqh_cef_shd.g_old_rec.post_copy_function_name;
295: End If;
296: If (p_rec.context = hr_api.g_varchar2) then
292: If (p_rec.post_copy_function_name = hr_api.g_varchar2) then
293: p_rec.post_copy_function_name :=
294: pqh_cef_shd.g_old_rec.post_copy_function_name;
295: End If;
296: If (p_rec.context = hr_api.g_varchar2) then
297: p_rec.context :=
298: pqh_cef_shd.g_old_rec.context;
299: End If;
300: --
354: Procedure upd
355: (
356: p_effective_date in date,
357: p_copy_entity_function_id in number,
358: p_table_route_id in number default hr_api.g_number,
359: p_function_type_cd in varchar2 default hr_api.g_varchar2,
360: p_pre_copy_function_name in varchar2 default hr_api.g_varchar2,
361: p_copy_function_name in varchar2 default hr_api.g_varchar2,
362: p_post_copy_function_name in varchar2 default hr_api.g_varchar2,
355: (
356: p_effective_date in date,
357: p_copy_entity_function_id in number,
358: p_table_route_id in number default hr_api.g_number,
359: p_function_type_cd in varchar2 default hr_api.g_varchar2,
360: p_pre_copy_function_name in varchar2 default hr_api.g_varchar2,
361: p_copy_function_name in varchar2 default hr_api.g_varchar2,
362: p_post_copy_function_name in varchar2 default hr_api.g_varchar2,
363: p_object_version_number in out nocopy number,
356: p_effective_date in date,
357: p_copy_entity_function_id in number,
358: p_table_route_id in number default hr_api.g_number,
359: p_function_type_cd in varchar2 default hr_api.g_varchar2,
360: p_pre_copy_function_name in varchar2 default hr_api.g_varchar2,
361: p_copy_function_name in varchar2 default hr_api.g_varchar2,
362: p_post_copy_function_name in varchar2 default hr_api.g_varchar2,
363: p_object_version_number in out nocopy number,
364: p_context in varchar2 default hr_api.g_varchar2
357: p_copy_entity_function_id in number,
358: p_table_route_id in number default hr_api.g_number,
359: p_function_type_cd in varchar2 default hr_api.g_varchar2,
360: p_pre_copy_function_name in varchar2 default hr_api.g_varchar2,
361: p_copy_function_name in varchar2 default hr_api.g_varchar2,
362: p_post_copy_function_name in varchar2 default hr_api.g_varchar2,
363: p_object_version_number in out nocopy number,
364: p_context in varchar2 default hr_api.g_varchar2
365: ) is
358: p_table_route_id in number default hr_api.g_number,
359: p_function_type_cd in varchar2 default hr_api.g_varchar2,
360: p_pre_copy_function_name in varchar2 default hr_api.g_varchar2,
361: p_copy_function_name in varchar2 default hr_api.g_varchar2,
362: p_post_copy_function_name in varchar2 default hr_api.g_varchar2,
363: p_object_version_number in out nocopy number,
364: p_context in varchar2 default hr_api.g_varchar2
365: ) is
366: --
360: p_pre_copy_function_name in varchar2 default hr_api.g_varchar2,
361: p_copy_function_name in varchar2 default hr_api.g_varchar2,
362: p_post_copy_function_name in varchar2 default hr_api.g_varchar2,
363: p_object_version_number in out nocopy number,
364: p_context in varchar2 default hr_api.g_varchar2
365: ) is
366: --
367: l_rec pqh_cef_shd.g_rec_type;
368: l_proc varchar2(72) := g_package||'upd';