[Home] [Help]
59: l_assessment_id per_assessments.assessment_id%TYPE;
60: l_object_version_number per_assessments.object_version_number%TYPE;
61: --
62: begin
63: hr_utility.set_location('Entering:'|| l_proc, 5);
64: --
65: -- Issue a savepoint.
66: --
67: savepoint create_assess;
64: --
65: -- Issue a savepoint.
66: --
67: savepoint create_assess;
68: hr_utility.set_location(l_proc, 6);
69: --
70: -- Call Before Process User Hook
71: --
72: begin
118: -- End of Before Process User Hook call
119: --
120: -- Validation in addition to Table Handlers
121: --
122: hr_utility.set_location(l_proc, 7);
123: --
124: -- Process Logic
125: --
126: per_asn_ins.ins (
164: ,p_validate => p_validate
165: ,p_effective_date => p_effective_date
166: );
167: --
168: hr_utility.set_location(l_proc, 8);
169: --
170: -- Call After Process User Hook
171: --
172: begin
229: --
230: p_assessment_id := l_assessment_id;
231: p_object_version_number := l_object_version_number;
232: --
233: hr_utility.set_location(' Leaving:'||l_proc, 11);
234: exception
235: when hr_api.validate_enabled then
236: --
237: -- As the Validate_Enabled exception has been raised
256: raise;
257: --
258: -- End of fix.
259: --
260: hr_utility.set_location(' Leaving:'||l_proc, 12);
261: end create_assessment;
262: --
263: --
264: -- ---------------------------------------------------------------------------
310: --
311: lv_object_version_number per_assessments.object_version_number%TYPE := p_object_version_number ;
312: --
313: begin
314: hr_utility.set_location('Entering:'|| l_proc, 5);
315: --
316: -- Issue a savepoint.
317: --
318: savepoint update_assess;
315: --
316: -- Issue a savepoint.
317: --
318: savepoint update_assess;
319: hr_utility.set_location(l_proc, 6);
320: --
321: -- Call Before Process User Hook
322: --
323: begin
366: -- End of Before Process User Hook call
367: --
368: -- Validation in addition to Table Handlers
369: --
370: hr_utility.set_location(l_proc, 7);
371: --
372: -- Process Logic
373: --
374: l_object_version_number := p_object_version_number;
410: p_effective_date => p_effective_date
411: );
412: --
413: --
414: hr_utility.set_location(l_proc, 8);
415: --
416: -- Call After Process User Hook
417: --
418: begin
470: -- object version number as the update was successful
471: --
472: p_object_version_number := l_object_version_number;
473: --
474: hr_utility.set_location(' Leaving:'||l_proc, 11);
475: exception
476: when hr_api.validate_enabled then
477: --
478: -- As the Validate_Enabled exception has been raised
499: raise;
500: --
501: -- End of fix.
502: --
503: hr_utility.set_location(' Leaving:'||l_proc, 12);
504: --
505: end update_assessment;
506: --
507: --
518: -- Declare cursors and local variables
519: --
520: l_proc varchar2(72) := g_package||'delete_assessment';
521: begin
522: hr_utility.set_location('Entering:'|| l_proc, 5);
523: --
524: -- Issue a savepoint.
525: --
526: savepoint delete_assess;
523: --
524: -- Issue a savepoint.
525: --
526: savepoint delete_assess;
527: hr_utility.set_location(l_proc, 6);
528: --
529: -- Call Before Process User Hook
530: --
531: begin
545: -- End of Before Process User hook
546: --
547: -- Validation in addition to Table Handlers
548: --
549: hr_utility.set_location(l_proc, 7);
550: --
551: -- Process Logic
552: --
553: -- The check to see whether the assessment_type is being used by an
558: ,p_assessment_id => p_assessment_id
559: ,p_object_version_number => p_object_version_number
560: );
561: --
562: hr_utility.set_location(l_proc, 8);
563: --
564: -- Call After Process User Hook
565: --
566: begin
583: if p_validate then
584: raise hr_api.validate_enabled;
585: end if;
586: --
587: hr_utility.set_location(' Leaving:'||l_proc, 11);
588: exception
589: when hr_api.validate_enabled then
590: --
591: -- As the Validate_Enabled exception has been raised
604: raise;
605: --
606: -- End of fix.
607: --
608: hr_utility.set_location(' Leaving:'||l_proc, 12);
609: end delete_assessment;
610: --
611: end hr_assessments_api;