63: l_object_version_number ben_dsbld_rt_f.object_version_number%TYPE;
64: --
65: begin
66: --
67: hr_utility.set_location('Entering:'|| l_proc, 10);
68: --
69: -- Issue a savepoint if operating in validation only mode
70: --
71: savepoint create_DSBLD_RT;
69: -- Issue a savepoint if operating in validation only mode
70: --
71: savepoint create_DSBLD_RT;
72: --
73: hr_utility.set_location(l_proc, 20);
74: --
75: -- Process Logic
76: --
77: begin
242: p_base_table_reference_column => 'RT_DSBLD_FLAG',
243: p_reference_table => 'BEN_DSBLD_RT_F',
244: p_reference_table_column => 'VRBL_RT_PRFL_ID');
245: --
246: hr_utility.set_location(l_proc, 60);
247: --
248: -- When in validation only mode raise the Validate_Enabled exception
249: --
250: if p_validate then
257: p_effective_start_date := l_effective_start_date;
258: p_effective_end_date := l_effective_end_date;
259: p_object_version_number := l_object_version_number;
260: --
261: hr_utility.set_location(' Leaving:'||l_proc, 70);
262: --
263: exception
264: --
265: when hr_api.validate_enabled then
276: p_dsbld_rt_id := null;
277: p_effective_start_date := null;
278: p_effective_end_date := null;
279: p_object_version_number := null;
280: hr_utility.set_location(' Leaving:'||l_proc, 80);
281: --
282: when others then
283: --
284: -- A validation or unexpected error has occured
350: l_effective_end_date ben_dsbld_rt_f.effective_end_date%TYPE;
351: --
352: begin
353: --
354: hr_utility.set_location('Entering:'|| l_proc, 10);
355: --
356: -- Issue a savepoint if operating in validation only mode
357: --
358: savepoint update_DSBLD_RT;
356: -- Issue a savepoint if operating in validation only mode
357: --
358: savepoint update_DSBLD_RT;
359: --
360: hr_utility.set_location(l_proc, 20);
361: --
362: -- Process Logic
363: --
364: l_object_version_number := p_object_version_number;
526: -- End of API User Hook for the after hook of update_DSBLD_RT
527: --
528: end;
529: --
530: hr_utility.set_location(l_proc, 60);
531: --
532: -- When in validation only mode raise the Validate_Enabled exception
533: --
534: if p_validate then
540: p_object_version_number := l_object_version_number;
541: p_effective_start_date := l_effective_start_date;
542: p_effective_end_date := l_effective_end_date;
543: --
544: hr_utility.set_location(' Leaving:'||l_proc, 70);
545: --
546: exception
547: --
548: when hr_api.validate_enabled then
555: -- Only set output warning arguments
556: -- (Any key or derived arguments must be set to null
557: -- when validation only mode is being used.)
558: --
559: hr_utility.set_location(' Leaving:'||l_proc, 80);
560: --
561: when others then
562: --
563: -- A validation or unexpected error has occured
592: l_effective_end_date ben_dsbld_rt_f.effective_end_date%TYPE;
593: --
594: begin
595: --
596: hr_utility.set_location('Entering:'|| l_proc, 10);
597: --
598: -- Issue a savepoint if operating in validation only mode
599: --
600: savepoint delete_DSBLD_RT;
598: -- Issue a savepoint if operating in validation only mode
599: --
600: savepoint delete_DSBLD_RT;
601: --
602: hr_utility.set_location(l_proc, 20);
603: --
604: -- Process Logic
605: --
606: l_object_version_number := p_object_version_number;
670: p_base_table_reference_column => 'RT_DSBLD_FLAG',
671: p_reference_table => 'BEN_DSBLD_RT_F',
672: p_reference_table_column => 'VRBL_RT_PRFL_ID');
673: --
674: hr_utility.set_location(l_proc, 60);
675: --
676: -- When in validation only mode raise the Validate_Enabled exception
677: --
678: if p_validate then
678: if p_validate then
679: raise hr_api.validate_enabled;
680: end if;
681: --
682: hr_utility.set_location(' Leaving:'||l_proc, 70);
683: --
684: exception
685: --
686: when hr_api.validate_enabled then
731: l_validation_end_date date;
732: --
733: begin
734: --
735: hr_utility.set_location('Entering:'|| l_proc, 10);
736: --
737: ben_dbr_shd.lck
738: (
739: p_dsbld_rt_id => p_dsbld_rt_id
743: ,p_effective_date => p_effective_date
744: ,p_datetrack_mode => p_datetrack_mode
745: );
746: --
747: hr_utility.set_location(' Leaving:'||l_proc, 70);
748: --
749: end lck;
750: --
751: end ben_DSBLD_RT_api;