[Home] [Help]
51: l_object_version_number per_performance_ratings.object_version_number%TYPE;
52: --
53: begin
54: --
55: hr_utility.set_location('Entering:'|| l_proc, 10);
56: --
57: -- Issue a savepoint.
58: --
59: savepoint create_performance_rating;
100: end;
101: --
102: -- End of Before Process User Hook call
103: --
104: hr_utility.set_location(l_proc, 20);
105: --
106: -- Validation in addition to Row Handlers
107: --
108: hr_utility.set_location(l_proc, 30);
104: hr_utility.set_location(l_proc, 20);
105: --
106: -- Validation in addition to Row Handlers
107: --
108: hr_utility.set_location(l_proc, 30);
109: --
110: -- Process Logic
111: --
112: per_prt_ins.ins
142: ,p_object_version_number => l_object_version_number
143: ,p_appr_line_score => p_appr_line_score
144: );
145:
146: hr_utility.set_location(l_proc, 40);
147: --
148: -- Call After Process User Hook
149: --
150: begin
200: --
201: p_performance_rating_id := l_performance_rating_id;
202: p_object_version_number := l_object_version_number;
203: --
204: hr_utility.set_location(' Leaving:'||l_proc, 50);
205: --
206: exception
207: when hr_api.validate_enabled then
208: --
231: raise;
232: --
233: -- End of fix.
234: --
235: hr_utility.set_location(' Leaving:'||l_proc, 60);
236: end create_performance_rating;
237: --
238: -- ----------------------------------------------------------------------------
239: -- |---------------------<
250: l_proc varchar2(72) := g_package||'delete_performance_rating';
251: --
252: begin
253: --
254: hr_utility.set_location('Entering:'|| l_proc, 10);
255: --
256: -- Issue a savepoint.
257: --
258: savepoint delete_performance_rating;
274: end;
275: --
276: -- End of Before Process User hook
277: --
278: hr_utility.set_location(l_proc, 20);
279: --
280: -- Delete the performance_rating
281: --
282: per_prt_del.del
284: ,p_performance_rating_id => p_performance_rating_id
285: ,p_object_version_number => p_object_version_number
286: );
287: --
288: hr_utility.set_location(l_proc, 30);
289: --
290: -- Call After Process User Hook
291: --
292: begin
309: if p_validate then
310: raise hr_api.validate_enabled;
311: end if;
312: --
313: hr_utility.set_location(' Leaving:'||l_proc, 40);
314: --
315: exception
316: when hr_api.validate_enabled then
317: --
331: raise;
332: --
333: -- End of fix.
334: --
335: hr_utility.set_location(' Leaving:'||l_proc, 50);
336: --
337: end delete_performance_rating;
338: --
339: -- ----------------------------------------------------------------------------
380: l_object_version_number per_performance_ratings.object_version_number%TYPE;
381: l_temp_ovn number := p_object_version_number;
382: --
383: begin
384: hr_utility.set_location('Entering:'|| l_proc, 10);
385: --
386: -- Issue a savepoint.
387: --
388: savepoint update_performance_rating;
431: end;
432: --
433: -- End of Before Process User Hook call
434: --
435: hr_utility.set_location(l_proc, 20);
436: --
437: -- Process Logic
438: --
439: l_object_version_number := p_object_version_number;
469: ,p_attribute20 => p_attribute20
470: ,p_appr_line_score => p_appr_line_score
471: );
472: --
473: hr_utility.set_location(l_proc, 30);
474: --
475: -- Call After Process User Hook
476: --
477: begin
527: -- object version number as the update was successful
528: --
529: p_object_version_number := l_object_version_number;
530: --
531: hr_utility.set_location(' Leaving:'||l_proc, 40);
532: exception
533: when hr_api.validate_enabled then
534: --
535: -- As the Validate_Enabled exception has been raised
556: raise;
557: --
558: -- End of fix.
559: --
560: hr_utility.set_location(' Leaving:'||l_proc, 50);
561: --
562: end update_performance_rating;
563: --
564: end hr_performance_ratings_api;