49: where pa_request_id = p_pa_request_id
50: )
51: )
52: and
53: nvl(nre.required_flag,hr_api.g_varchar2) = 'Y';
54:
55:
56: l_proc varchar2(72) := g_package || 'create_pa_remarks';
57: l_exists boolean := false;
87: ,p_remark_code_information4 => p_remark_code_information4
88: ,p_remark_code_information5 => p_remark_code_information5
89: );
90: exception
91: when hr_api.cannot_find_prog_unit then
92: hr_api.cannot_find_prog_unit_error
93: (p_module_name => 'create_ghr_pa_remarks',
94: p_hook_type => 'BP'
95: );
88: ,p_remark_code_information5 => p_remark_code_information5
89: );
90: exception
91: when hr_api.cannot_find_prog_unit then
92: hr_api.cannot_find_prog_unit_error
93: (p_module_name => 'create_ghr_pa_remarks',
94: p_hook_type => 'BP'
95: );
96: end;
149: ,p_remark_code_information5 => p_remark_code_information5
150: ,p_object_version_number => l_object_version_number
151: );
152: exception
153: when hr_api.cannot_find_prog_unit then
154: hr_api.cannot_find_prog_unit_error
155: (p_module_name => 'create_ghr_pa_remarks',
156: p_hook_type => 'AP'
157: );
150: ,p_object_version_number => l_object_version_number
151: );
152: exception
153: when hr_api.cannot_find_prog_unit then
154: hr_api.cannot_find_prog_unit_error
155: (p_module_name => 'create_ghr_pa_remarks',
156: p_hook_type => 'AP'
157: );
158: end;
159: --
160: -- End of Before Process User Hook call
161: --
162: if p_validate then
163: raise hr_api.validate_enabled;
164: end if;
165: --
166: -- Set all output arguments
167: --
170:
171: --
172: hr_utility.set_location(' Leaving:'||l_proc, 11);
173: exception
174: when hr_api.validate_enabled then
175: --
176: -- As the Validate_Enabled exception has been raised
177: -- we must rollback to the savepoint
178: --
203: procedure update_pa_remarks
204: (p_validate in boolean default false
205: ,p_pa_remark_id in number
206: ,p_object_version_number in out nocopy number
207: ,p_remark_code_information1 in varchar2 default hr_api.g_varchar2
208: ,p_remark_code_information2 in varchar2 default hr_api.g_varchar2
209: ,p_remark_code_information3 in varchar2 default hr_api.g_varchar2
210: ,p_remark_code_information4 in varchar2 default hr_api.g_varchar2
211: ,p_remark_code_information5 in varchar2 default hr_api.g_varchar2
204: (p_validate in boolean default false
205: ,p_pa_remark_id in number
206: ,p_object_version_number in out nocopy number
207: ,p_remark_code_information1 in varchar2 default hr_api.g_varchar2
208: ,p_remark_code_information2 in varchar2 default hr_api.g_varchar2
209: ,p_remark_code_information3 in varchar2 default hr_api.g_varchar2
210: ,p_remark_code_information4 in varchar2 default hr_api.g_varchar2
211: ,p_remark_code_information5 in varchar2 default hr_api.g_varchar2
212: ,p_description in varchar2 default hr_api.g_varchar2
205: ,p_pa_remark_id in number
206: ,p_object_version_number in out nocopy number
207: ,p_remark_code_information1 in varchar2 default hr_api.g_varchar2
208: ,p_remark_code_information2 in varchar2 default hr_api.g_varchar2
209: ,p_remark_code_information3 in varchar2 default hr_api.g_varchar2
210: ,p_remark_code_information4 in varchar2 default hr_api.g_varchar2
211: ,p_remark_code_information5 in varchar2 default hr_api.g_varchar2
212: ,p_description in varchar2 default hr_api.g_varchar2
213: )
206: ,p_object_version_number in out nocopy number
207: ,p_remark_code_information1 in varchar2 default hr_api.g_varchar2
208: ,p_remark_code_information2 in varchar2 default hr_api.g_varchar2
209: ,p_remark_code_information3 in varchar2 default hr_api.g_varchar2
210: ,p_remark_code_information4 in varchar2 default hr_api.g_varchar2
211: ,p_remark_code_information5 in varchar2 default hr_api.g_varchar2
212: ,p_description in varchar2 default hr_api.g_varchar2
213: )
214: is
207: ,p_remark_code_information1 in varchar2 default hr_api.g_varchar2
208: ,p_remark_code_information2 in varchar2 default hr_api.g_varchar2
209: ,p_remark_code_information3 in varchar2 default hr_api.g_varchar2
210: ,p_remark_code_information4 in varchar2 default hr_api.g_varchar2
211: ,p_remark_code_information5 in varchar2 default hr_api.g_varchar2
212: ,p_description in varchar2 default hr_api.g_varchar2
213: )
214: is
215: l_proc varchar2(72) := g_package || 'update_pa_remarks';
208: ,p_remark_code_information2 in varchar2 default hr_api.g_varchar2
209: ,p_remark_code_information3 in varchar2 default hr_api.g_varchar2
210: ,p_remark_code_information4 in varchar2 default hr_api.g_varchar2
211: ,p_remark_code_information5 in varchar2 default hr_api.g_varchar2
212: ,p_description in varchar2 default hr_api.g_varchar2
213: )
214: is
215: l_proc varchar2(72) := g_package || 'update_pa_remarks';
216: l_object_version_number ghr_pa_remarks.object_version_number%TYPE;
235: ,p_remark_code_information5 => p_remark_code_information5
236: ,p_object_version_number => p_object_version_number
237: );
238: exception
239: when hr_api.cannot_find_prog_unit then
240: hr_api.cannot_find_prog_unit_error
241: (p_module_name => 'update_ghr_pa_remarks',
242: p_hook_type => 'BP'
243: );
236: ,p_object_version_number => p_object_version_number
237: );
238: exception
239: when hr_api.cannot_find_prog_unit then
240: hr_api.cannot_find_prog_unit_error
241: (p_module_name => 'update_ghr_pa_remarks',
242: p_hook_type => 'BP'
243: );
244: end;
277: ,p_remark_code_information5 => p_remark_code_information5
278: ,p_object_version_number => l_object_version_number
279: );
280: exception
281: when hr_api.cannot_find_prog_unit then
282: hr_api.cannot_find_prog_unit_error
283: (p_module_name => 'update_ghr_pa_remarks',
284: p_hook_type => 'AP'
285: );
278: ,p_object_version_number => l_object_version_number
279: );
280: exception
281: when hr_api.cannot_find_prog_unit then
282: hr_api.cannot_find_prog_unit_error
283: (p_module_name => 'update_ghr_pa_remarks',
284: p_hook_type => 'AP'
285: );
286: end;
287: --
288: -- End of After Process User Hook call
289: --
290: if p_validate then
291: raise hr_api.validate_enabled;
292: end if;
293: --
294: -- Set all output arguments
295: --
296: -- p_object_version_number := l_object_version_number;
297: --
298: hr_utility.set_location(' Leaving:'||l_proc, 11);
299: exception
300: when hr_api.validate_enabled then
301: --
302: -- As the Validate_Enabled exception has been raised
303: -- we must rollback to the savepoint
304: --
384: p_pa_remark_id => p_pa_remark_id
385: ,p_object_version_number => p_object_version_number
386: );
387: exception
388: when hr_api.cannot_find_prog_unit then
389: hr_api.cannot_find_prog_unit_error
390: (p_module_name => 'delete_ghr_pa_remarks',
391: p_hook_type => 'BP'
392: );
385: ,p_object_version_number => p_object_version_number
386: );
387: exception
388: when hr_api.cannot_find_prog_unit then
389: hr_api.cannot_find_prog_unit_error
390: (p_module_name => 'delete_ghr_pa_remarks',
391: p_hook_type => 'BP'
392: );
393: end;
438: p_pa_remark_id => p_pa_remark_id
439: ,p_object_version_number => p_object_version_number
440: );
441: exception
442: when hr_api.cannot_find_prog_unit then
443: hr_api.cannot_find_prog_unit_error
444: (p_module_name => 'delete_ghr_pa_remarks',
445: p_hook_type => 'AP'
446: );
439: ,p_object_version_number => p_object_version_number
440: );
441: exception
442: when hr_api.cannot_find_prog_unit then
443: hr_api.cannot_find_prog_unit_error
444: (p_module_name => 'delete_ghr_pa_remarks',
445: p_hook_type => 'AP'
446: );
447: end;
450: --
451: -- When in validation only mode raise the Validate_Enabled exception
452: --
453: if p_validate then
454: raise hr_api.validate_enabled;
455: end if;
456: --
457: hr_utility.set_location(' Leaving:'||l_proc, 11);
458: exception
455: end if;
456: --
457: hr_utility.set_location(' Leaving:'||l_proc, 11);
458: exception
459: when hr_api.validate_enabled then
460: --
461: -- As the Validate_Enabled exception has been raised
462: -- we must rollback to the savepoint
463: --