65: l_object_version_number ben_elig_mrtl_stat_cvg_f.object_version_number%TYPE;
66: --
67: begin
68: --
69: hr_utility.set_location('Entering:'|| l_proc, 10);
70: --
71: -- Issue a savepoint if operating in validation only mode
72: --
73: savepoint create_Elig_Mrtl_Stat_Cvg;
71: -- Issue a savepoint if operating in validation only mode
72: --
73: savepoint create_Elig_Mrtl_Stat_Cvg;
74: --
75: hr_utility.set_location(l_proc, 20);
76: --
77: -- Process Logic
78: --
79: begin
241: -- End of API User Hook for the after hook of create_Elig_Mrtl_Stat_Cvg
242: --
243: end;
244: --
245: hr_utility.set_location(l_proc, 60);
246: --
247: ben_profile_handler.event_handler
248: (p_event => 'CREATE',
249: p_base_table => 'BEN_DPNT_CVG_ELIGY_PRFL_F',
266: p_effective_start_date := l_effective_start_date;
267: p_effective_end_date := l_effective_end_date;
268: p_object_version_number := l_object_version_number;
269: --
270: hr_utility.set_location(' Leaving:'||l_proc, 70);
271: --
272: exception
273: --
274: when hr_api.validate_enabled then
285: p_elig_mrtl_stat_cvg_id := null;
286: p_effective_start_date := null;
287: p_effective_end_date := null;
288: p_object_version_number := null;
289: hr_utility.set_location(' Leaving:'||l_proc, 80);
290: --
291: when others then
292: --
293: -- A validation or unexpected error has occured
360: l_effective_end_date ben_elig_mrtl_stat_cvg_f.effective_end_date%TYPE;
361: --
362: begin
363: --
364: hr_utility.set_location('Entering:'|| l_proc, 10);
365: --
366: -- Issue a savepoint if operating in validation only mode
367: --
368: savepoint update_Elig_Mrtl_Stat_Cvg;
366: -- Issue a savepoint if operating in validation only mode
367: --
368: savepoint update_Elig_Mrtl_Stat_Cvg;
369: --
370: hr_utility.set_location(l_proc, 20);
371: --
372: -- Process Logic
373: --
374: l_object_version_number := p_object_version_number;
542: -- End of API User Hook for the after hook of update_Elig_Mrtl_Stat_Cvg
543: --
544: end;
545: --
546: hr_utility.set_location(l_proc, 60);
547: --
548: -- When in validation only mode raise the Validate_Enabled exception
549: --
550: if p_validate then
556: p_object_version_number := l_object_version_number;
557: p_effective_start_date := l_effective_start_date;
558: p_effective_end_date := l_effective_end_date;
559: --
560: hr_utility.set_location(' Leaving:'||l_proc, 70);
561: --
562: exception
563: --
564: when hr_api.validate_enabled then
574: -- Only set output warning arguments
575: -- (Any key or derived arguments must be set to null
576: -- when validation only mode is being used.)
577: --
578: hr_utility.set_location(' Leaving:'||l_proc, 80);
579: --
580: when others then
581: --
582: -- A validation or unexpected error has occured
610: l_effective_end_date ben_elig_mrtl_stat_cvg_f.effective_end_date%TYPE;
611: --
612: begin
613: --
614: hr_utility.set_location('Entering:'|| l_proc, 10);
615: --
616: -- Issue a savepoint if operating in validation only mode
617: --
618: savepoint delete_Elig_Mrtl_Stat_Cvg;
616: -- Issue a savepoint if operating in validation only mode
617: --
618: savepoint delete_Elig_Mrtl_Stat_Cvg;
619: --
620: hr_utility.set_location(l_proc, 20);
621: --
622: -- Process Logic
623: --
624: l_object_version_number := p_object_version_number;
679: -- End of API User Hook for the after hook of delete_Elig_Mrtl_Stat_Cvg
680: --
681: end;
682: --
683: hr_utility.set_location(l_proc, 60);
684: --
685: ben_profile_handler.event_handler
686: (p_event => 'DELETE',
687: p_base_table => 'BEN_DPNT_CVG_ELIGY_PRFL_F',
696: if p_validate then
697: raise hr_api.validate_enabled;
698: end if;
699: --
700: hr_utility.set_location(' Leaving:'||l_proc, 70);
701: --
702: exception
703: --
704: when hr_api.validate_enabled then
749: l_validation_end_date date;
750: --
751: begin
752: --
753: hr_utility.set_location('Entering:'|| l_proc, 10);
754: --
755: ben_ems_shd.lck
756: (
757: p_elig_mrtl_stat_cvg_id => p_elig_mrtl_stat_cvg_id
761: ,p_effective_date => p_effective_date
762: ,p_datetrack_mode => p_datetrack_mode
763: );
764: --
765: hr_utility.set_location(' Leaving:'||l_proc, 70);
766: --
767: end lck;
768: --
769: end ben_Elig_Mrtl_Stat_Cvg_api;