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.GHR_PRE_UPD dependencies on HR_API

Line 77: When hr_api.check_integrity_violated Then

73: --
74: hr_utility.set_location(' Leaving:'||l_proc, 10);
75: --
76: Exception
77: When hr_api.check_integrity_violated Then
78: -- A check constraint has been violated
79: ghr_pre_shd.constraint_error
80: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
81: When hr_api.parent_integrity_violated Then

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

76: Exception
77: When hr_api.check_integrity_violated Then
78: -- A check constraint has been violated
79: ghr_pre_shd.constraint_error
80: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
81: When hr_api.parent_integrity_violated Then
82: -- Parent integrity has been violated
83: ghr_pre_shd.constraint_error
84: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 81: When hr_api.parent_integrity_violated Then

77: When hr_api.check_integrity_violated Then
78: -- A check constraint has been violated
79: ghr_pre_shd.constraint_error
80: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
81: When hr_api.parent_integrity_violated Then
82: -- Parent integrity has been violated
83: ghr_pre_shd.constraint_error
84: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
85: When hr_api.unique_integrity_violated Then

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

80: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
81: When hr_api.parent_integrity_violated Then
82: -- Parent integrity has been violated
83: ghr_pre_shd.constraint_error
84: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
85: When hr_api.unique_integrity_violated Then
86: -- Unique integrity has been violated
87: ghr_pre_shd.constraint_error
88: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 85: When hr_api.unique_integrity_violated Then

81: When hr_api.parent_integrity_violated Then
82: -- Parent integrity has been violated
83: ghr_pre_shd.constraint_error
84: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
85: When hr_api.unique_integrity_violated Then
86: -- Unique integrity has been violated
87: ghr_pre_shd.constraint_error
88: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
89: When Others 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.unique_integrity_violated Then
86: -- Unique integrity has been violated
87: ghr_pre_shd.constraint_error
88: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
89: When Others Then
90: Raise;
91: End update_dml;
92: --

Line 205: when hr_api.cannot_find_prog_unit then

201: p_object_version_number_o =>
202: ghr_pre_shd.g_old_rec.object_version_number
203: );
204: exception
205: when hr_api.cannot_find_prog_unit then
206: hr_api.cannot_find_prog_unit_error
207: ( p_module_name => 'GHR_PA_REMARKS'
208: ,p_hook_type => 'AU'
209: );

Line 206: hr_api.cannot_find_prog_unit_error

202: ghr_pre_shd.g_old_rec.object_version_number
203: );
204: exception
205: when hr_api.cannot_find_prog_unit then
206: hr_api.cannot_find_prog_unit_error
207: ( p_module_name => 'GHR_PA_REMARKS'
208: ,p_hook_type => 'AU'
209: );
210: end;

Line 273: If (p_rec.pa_request_id = hr_api.g_number) then

269: -- p_rec plsql record structure
270: -- to see if a system default is being used. If a system default
271: -- is being used then we must set to the 'current' argument value.
272: --
273: If (p_rec.pa_request_id = hr_api.g_number) then
274: p_rec.pa_request_id :=
275: ghr_pre_shd.g_old_rec.pa_request_id;
276: End If;
277: If (p_rec.remark_id = hr_api.g_number) then

Line 277: If (p_rec.remark_id = hr_api.g_number) then

273: If (p_rec.pa_request_id = hr_api.g_number) then
274: p_rec.pa_request_id :=
275: ghr_pre_shd.g_old_rec.pa_request_id;
276: End If;
277: If (p_rec.remark_id = hr_api.g_number) then
278: p_rec.remark_id :=
279: ghr_pre_shd.g_old_rec.remark_id;
280: End If;
281: If (p_rec.description = hr_api.g_varchar2) then

Line 281: If (p_rec.description = hr_api.g_varchar2) then

277: If (p_rec.remark_id = hr_api.g_number) then
278: p_rec.remark_id :=
279: ghr_pre_shd.g_old_rec.remark_id;
280: End If;
281: If (p_rec.description = hr_api.g_varchar2) then
282: p_rec.description :=
283: ghr_pre_shd.g_old_rec.description;
284: End If;
285:

Line 346: Raise HR_Api.Validate_Enabled;

342: --
343: -- If we are validating then raise the Validate_Enabled exception
344: --
345: If p_validate then
346: Raise HR_Api.Validate_Enabled;
347: End If;
348: --
349: hr_utility.set_location(' Leaving:'||l_proc, 10);
350: Exception

Line 351: When HR_Api.Validate_Enabled Then

347: End If;
348: --
349: hr_utility.set_location(' Leaving:'||l_proc, 10);
350: Exception
351: When HR_Api.Validate_Enabled Then
352: --
353: -- As the Validate_Enabled exception has been raised
354: -- we must rollback to the savepoint
355: --

Line 365: p_description in varchar2 default hr_api.g_varchar2,

361: -- ----------------------------------------------------------------------------
362: Procedure upd
363: (
364: p_pa_remark_id in number,
365: p_description in varchar2 default hr_api.g_varchar2,
366: p_object_version_number in out NOCOPY number,
367: p_remark_code_information1 in varchar2 default hr_api.g_varchar2,
368: p_remark_code_information2 in varchar2 default hr_api.g_varchar2,
369: p_remark_code_information3 in varchar2 default hr_api.g_varchar2,

Line 367: p_remark_code_information1 in varchar2 default hr_api.g_varchar2,

363: (
364: p_pa_remark_id in number,
365: p_description in varchar2 default hr_api.g_varchar2,
366: p_object_version_number in out NOCOPY number,
367: p_remark_code_information1 in varchar2 default hr_api.g_varchar2,
368: p_remark_code_information2 in varchar2 default hr_api.g_varchar2,
369: p_remark_code_information3 in varchar2 default hr_api.g_varchar2,
370: p_remark_code_information4 in varchar2 default hr_api.g_varchar2,
371: p_remark_code_information5 in varchar2 default hr_api.g_varchar2,

Line 368: p_remark_code_information2 in varchar2 default hr_api.g_varchar2,

364: p_pa_remark_id in number,
365: p_description in varchar2 default hr_api.g_varchar2,
366: p_object_version_number in out NOCOPY number,
367: p_remark_code_information1 in varchar2 default hr_api.g_varchar2,
368: p_remark_code_information2 in varchar2 default hr_api.g_varchar2,
369: p_remark_code_information3 in varchar2 default hr_api.g_varchar2,
370: p_remark_code_information4 in varchar2 default hr_api.g_varchar2,
371: p_remark_code_information5 in varchar2 default hr_api.g_varchar2,
372: p_validate in boolean default false

Line 369: p_remark_code_information3 in varchar2 default hr_api.g_varchar2,

365: p_description in varchar2 default hr_api.g_varchar2,
366: p_object_version_number in out NOCOPY number,
367: p_remark_code_information1 in varchar2 default hr_api.g_varchar2,
368: p_remark_code_information2 in varchar2 default hr_api.g_varchar2,
369: p_remark_code_information3 in varchar2 default hr_api.g_varchar2,
370: p_remark_code_information4 in varchar2 default hr_api.g_varchar2,
371: p_remark_code_information5 in varchar2 default hr_api.g_varchar2,
372: p_validate in boolean default false
373: ) is

Line 370: p_remark_code_information4 in varchar2 default hr_api.g_varchar2,

366: p_object_version_number in out NOCOPY number,
367: p_remark_code_information1 in varchar2 default hr_api.g_varchar2,
368: p_remark_code_information2 in varchar2 default hr_api.g_varchar2,
369: p_remark_code_information3 in varchar2 default hr_api.g_varchar2,
370: p_remark_code_information4 in varchar2 default hr_api.g_varchar2,
371: p_remark_code_information5 in varchar2 default hr_api.g_varchar2,
372: p_validate in boolean default false
373: ) is
374: --

Line 371: p_remark_code_information5 in varchar2 default hr_api.g_varchar2,

367: p_remark_code_information1 in varchar2 default hr_api.g_varchar2,
368: p_remark_code_information2 in varchar2 default hr_api.g_varchar2,
369: p_remark_code_information3 in varchar2 default hr_api.g_varchar2,
370: p_remark_code_information4 in varchar2 default hr_api.g_varchar2,
371: p_remark_code_information5 in varchar2 default hr_api.g_varchar2,
372: p_validate in boolean default false
373: ) is
374: --
375: l_rec ghr_pre_shd.g_rec_type;

Line 388: hr_api.g_number,

384: l_rec :=
385: ghr_pre_shd.convert_args
386: (
387: p_pa_remark_id,
388: hr_api.g_number,
389: hr_api.g_number,
390: p_description,
391: p_remark_code_information1,
392: p_remark_code_information2,

Line 389: hr_api.g_number,

385: ghr_pre_shd.convert_args
386: (
387: p_pa_remark_id,
388: hr_api.g_number,
389: hr_api.g_number,
390: p_description,
391: p_remark_code_information1,
392: p_remark_code_information2,
393: p_remark_code_information3,