58: l_object_version_number ben_actn_typ.object_version_number%TYPE;
59: --
60: begin
61: --
62: hr_utility.set_location('Entering:'|| l_proc, 10);
63: --
64: -- Issue a savepoint if operating in validation only mode
65: --
66: savepoint create_ACTION_TYPE;
64: -- Issue a savepoint if operating in validation only mode
65: --
66: savepoint create_ACTION_TYPE;
67: --
68: hr_utility.set_location(l_proc, 20);
69: --
70: -- Process Logic
71: --
72: begin
221: -- End of API User Hook for the after hook of create_ACTION_TYPE
222: --
223: end;
224: --
225: hr_utility.set_location(l_proc, 60);
226: --
227: -- When in validation only mode raise the Validate_Enabled exception
228: --
229: if p_validate then
234: --
235: p_actn_typ_id := l_actn_typ_id;
236: p_object_version_number := l_object_version_number;
237: --
238: hr_utility.set_location(' Leaving:'||l_proc, 70);
239: --
240: exception
241: --
242: when hr_api.validate_enabled then
251: -- when validation only mode is being used.)
252: --
253: p_actn_typ_id := null;
254: p_object_version_number := null;
255: hr_utility.set_location(' Leaving:'||l_proc, 80);
256: --
257: when others then
258: --
259: -- A validation or unexpected error has occured
316: l_object_version_number ben_actn_typ.object_version_number%TYPE;
317: --
318: begin
319: --
320: hr_utility.set_location('Entering:'|| l_proc, 10);
321: --
322: -- Issue a savepoint if operating in validation only mode
323: --
324: savepoint update_ACTION_TYPE;
322: -- Issue a savepoint if operating in validation only mode
323: --
324: savepoint update_ACTION_TYPE;
325: --
326: hr_utility.set_location(l_proc, 20);
327: --
328: -- Process Logic
329: --
330: l_object_version_number := p_object_version_number;
482: -- End of API User Hook for the after hook of update_ACTION_TYPE
483: --
484: end;
485: --
486: hr_utility.set_location(l_proc, 60);
487: --
488: -- When in validation only mode raise the Validate_Enabled exception
489: --
490: if p_validate then
494: -- Set all output arguments
495: --
496: p_object_version_number := l_object_version_number;
497: --
498: hr_utility.set_location(' Leaving:'||l_proc, 70);
499: --
500: exception
501: --
502: when hr_api.validate_enabled then
509: -- Only set output warning arguments
510: -- (Any key or derived arguments must be set to null
511: -- when validation only mode is being used.)
512: --
513: hr_utility.set_location(' Leaving:'||l_proc, 80);
514: --
515: when others then
516: --
517: -- A validation or unexpected error has occured
537: l_object_version_number ben_actn_typ.object_version_number%TYPE;
538: --
539: begin
540: --
541: hr_utility.set_location('Entering:'|| l_proc, 10);
542: --
543: -- Issue a savepoint if operating in validation only mode
544: --
545: savepoint delete_ACTION_TYPE;
543: -- Issue a savepoint if operating in validation only mode
544: --
545: savepoint delete_ACTION_TYPE;
546: --
547: hr_utility.set_location(l_proc, 20);
548: --
549: -- Process Logic
550: --
551: l_object_version_number := p_object_version_number;
599: -- End of API User Hook for the after hook of delete_ACTION_TYPE
600: --
601: end;
602: --
603: hr_utility.set_location(l_proc, 60);
604: --
605: -- When in validation only mode raise the Validate_Enabled exception
606: --
607: if p_validate then
607: if p_validate then
608: raise hr_api.validate_enabled;
609: end if;
610: --
611: hr_utility.set_location(' Leaving:'||l_proc, 70);
612: --
613: exception
614: --
615: when hr_api.validate_enabled then
649: l_proc varchar2(72) := g_package||'lck';
650: --
651: begin
652: --
653: hr_utility.set_location('Entering:'|| l_proc, 10);
654: --
655: ben_eat_shd.lck
656: (
657: p_actn_typ_id => p_actn_typ_id
657: p_actn_typ_id => p_actn_typ_id
658: ,p_object_version_number => p_object_version_number
659: );
660: --
661: hr_utility.set_location(' Leaving:'||l_proc, 70);
662: --
663: end lck;
664: --
665: end ben_ACTION_TYPE_api;