47: l_assessment_group_id per_assessment_groups.assessment_group_id%TYPE;
48: l_object_version_number per_assessment_groups.object_version_number%TYPE;
49: --
50: begin
51: hr_utility.set_location('Entering:'|| l_proc, 5);
52: --
53: -- Issue a savepoint.
54: --
55: savepoint create_assess_group;
52: --
53: -- Issue a savepoint.
54: --
55: savepoint create_assess_group;
56: hr_utility.set_location(l_proc, 6);
57: --
58: -- Call Before Process User Hook
59: --
60: begin
95: -- End of Before Process User Hook call
96: --
97: -- Validation in addition to Table Handlers
98: --
99: hr_utility.set_location(l_proc, 7);
100: --
101: -- Process Logic
102: --
103: per_asr_ins.ins (p_assessment_group_id => l_assessment_group_id
129: ,p_validate => p_validate
130: ,p_effective_date => p_effective_date
131: );
132: --
133: hr_utility.set_location(l_proc, 8);
134: --
135: -- Call After Process User Hook
136: --
137: begin
184: --
185: p_assessment_group_id := l_assessment_group_id;
186: p_object_version_number := l_object_version_number;
187: --
188: hr_utility.set_location(' Leaving:'||l_proc, 11);
189: exception
190: when hr_api.validate_enabled then
191: --
192: -- As the Validate_Enabled exception has been raised
211: raise;
212: --
213: -- End of fix.
214: --
215: hr_utility.set_location(' Leaving:'||l_proc, 12);
216: end create_assessment_group;
217: --
218: --
219: -- ---------------------------------------------------------------------------
256: l_proc varchar2(72) := g_package||'update_assessment_group';
257: l_object_version_number per_assessment_groups.object_version_number%TYPE;
258: --
259: begin
260: hr_utility.set_location('Entering:'|| l_proc, 5);
261: --
262: -- Issue a savepoint.
263: --
264: savepoint update_assess_group;
261: --
262: -- Issue a savepoint.
263: --
264: savepoint update_assess_group;
265: hr_utility.set_location(l_proc, 6);
266: --
267: -- Call Before Process User Hook
268: --
269: begin
305: -- End of Before Process User Hook call
306: --
307: -- Validation in addition to Table Handlers
308: --
309: hr_utility.set_location(l_proc, 7);
310: --
311: -- Process Logic
312: --
313: l_object_version_number := p_object_version_number;
341: p_effective_date => p_effective_date
342: );
343: --
344: --
345: hr_utility.set_location(l_proc, 8);
346: --
347: -- Call After Process User Hook
348: --
349: begin
394: -- object version number as the update was successful
395: --
396: p_object_version_number := l_object_version_number;
397: --
398: hr_utility.set_location(' Leaving:'||l_proc, 11);
399: exception
400: when hr_api.validate_enabled then
401: --
402: -- As the Validate_Enabled exception has been raised
421: raise;
422: --
423: -- End of fix.
424: --
425: hr_utility.set_location(' Leaving:'||l_proc, 12);
426: --
427: end update_assessment_group;
428: --
429: --
440: -- Declare cursors and local variables
441: --
442: l_proc varchar2(72) := g_package||'delete_assessment_group';
443: begin
444: hr_utility.set_location('Entering:'|| l_proc, 5);
445: --
446: -- Issue a savepoint.
447: --
448: savepoint delete_assess_group;
445: --
446: -- Issue a savepoint.
447: --
448: savepoint delete_assess_group;
449: hr_utility.set_location(l_proc, 6);
450: --
451: -- Call Before Process User Hook
452: --
453: begin
467: -- End of Before Process User hook
468: --
469: -- Validation in addition to Table Handlers
470: --
471: hr_utility.set_location(l_proc, 7);
472: --
473: -- Process Logic
474: --
475: -- The check to see whether the assessment_type is being used by an
480: ,p_assessment_group_id => p_assessment_group_id
481: ,p_object_version_number => p_object_version_number
482: );
483: --
484: hr_utility.set_location(l_proc, 8);
485: --
486: -- Call After Process User Hook
487: --
488: begin
505: if p_validate then
506: raise hr_api.validate_enabled;
507: end if;
508: --
509: hr_utility.set_location(' Leaving:'||l_proc, 11);
510: exception
511: when hr_api.validate_enabled then
512: --
513: -- As the Validate_Enabled exception has been raised
526: raise;
527: --
528: -- End of fix.
529: --
530: hr_utility.set_location(' Leaving:'||l_proc, 12);
531: end delete_assessment_group;
532: --
533: end hr_assessment_groups_api;