eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_CEF_UPD dependencies on HR_API

Line 81: When hr_api.check_integrity_violated Then

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

Line 84: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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));

Line 85: When hr_api.parent_integrity_violated Then

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

Line 88: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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));

Line 89: When hr_api.unique_integrity_violated Then

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

Line 92: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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: --

Line 206: when hr_api.cannot_find_prog_unit then

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');

Line 208: hr_api.cannot_find_prog_unit_error

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;

Line 276: If (p_rec.table_route_id = hr_api.g_number) then

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

Line 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

Line 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

Line 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

Line 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

Line 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: --

Line 358: p_table_route_id in number default hr_api.g_number,

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,

Line 359: p_function_type_cd 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,

Line 360: p_pre_copy_function_name in varchar2 default hr_api.g_varchar2,

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

Line 361: p_copy_function_name 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

Line 362: p_post_copy_function_name in varchar2 default hr_api.g_varchar2,

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: --

Line 364: p_context 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: --
367: l_rec pqh_cef_shd.g_rec_type;
368: l_proc varchar2(72) := g_package||'upd';