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
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));
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
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));
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
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: --
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: );
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;
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
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
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:
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
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: --
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 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,
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 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,
364: p_pa_remark_id in number,
365: p_description in varchar2 default hr_api.g_varchar2,
366: p_object_version_number in out 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
365: p_description in varchar2 default hr_api.g_varchar2,
366: p_object_version_number in out 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
366: p_object_version_number in out 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: --
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;
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,
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,