64: l_object_version_number ben_vrbl_rt_rl_f.object_version_number%TYPE;
65: --
66: begin
67: --
68: hr_utility.set_location('Entering:'|| l_proc, 10);
69: --
70: -- Issue a savepoint if operating in validation only mode
71: --
72: savepoint create_Vrbl_Rate_Rule;
70: -- Issue a savepoint if operating in validation only mode
71: --
72: savepoint create_Vrbl_Rate_Rule;
73: --
74: hr_utility.set_location(l_proc, 20);
75: --
76: -- Process Logic
77: --
78: begin
237: -- End of API User Hook for the after hook of create_Vrbl_Rate_Rule
238: --
239: end;
240: --
241: hr_utility.set_location(l_proc, 60);
242: --
243: -- When in validation only mode raise the Validate_Enabled exception
244: --
245: if p_validate then
252: p_effective_start_date := l_effective_start_date;
253: p_effective_end_date := l_effective_end_date;
254: p_object_version_number := l_object_version_number;
255: --
256: hr_utility.set_location(' Leaving:'||l_proc, 70);
257: --
258: exception
259: --
260: when hr_api.validate_enabled then
271: p_vrbl_rt_rl_id := null;
272: p_effective_start_date := null;
273: p_effective_end_date := null;
274: p_object_version_number := null;
275: hr_utility.set_location(' Leaving:'||l_proc, 80);
276: --
277: when others then
278: --
279: -- A validation or unexpected error has occured
345: l_effective_end_date ben_vrbl_rt_rl_f.effective_end_date%TYPE;
346: --
347: begin
348: --
349: hr_utility.set_location('Entering:'|| l_proc, 10);
350: --
351: -- Issue a savepoint if operating in validation only mode
352: --
353: savepoint update_Vrbl_Rate_Rule;
351: -- Issue a savepoint if operating in validation only mode
352: --
353: savepoint update_Vrbl_Rate_Rule;
354: --
355: hr_utility.set_location(l_proc, 20);
356: --
357: -- Process Logic
358: --
359: l_object_version_number := p_object_version_number;
524: -- End of API User Hook for the after hook of update_Vrbl_Rate_Rule
525: --
526: end;
527: --
528: hr_utility.set_location(l_proc, 60);
529: --
530: -- When in validation only mode raise the Validate_Enabled exception
531: --
532: if p_validate then
538: p_object_version_number := l_object_version_number;
539: p_effective_start_date := l_effective_start_date;
540: p_effective_end_date := l_effective_end_date;
541: --
542: hr_utility.set_location(' Leaving:'||l_proc, 70);
543: --
544: exception
545: --
546: when hr_api.validate_enabled then
553: -- Only set output warning arguments
554: -- (Any key or derived arguments must be set to null
555: -- when validation only mode is being used.)
556: --
557: hr_utility.set_location(' Leaving:'||l_proc, 80);
558: --
559: when others then
560: --
561: -- A validation or unexpected error has occured
590: l_effective_end_date ben_vrbl_rt_rl_f.effective_end_date%TYPE;
591: --
592: begin
593: --
594: hr_utility.set_location('Entering:'|| l_proc, 10);
595: --
596: -- Issue a savepoint if operating in validation only mode
597: --
598: savepoint delete_Vrbl_Rate_Rule;
596: -- Issue a savepoint if operating in validation only mode
597: --
598: savepoint delete_Vrbl_Rate_Rule;
599: --
600: hr_utility.set_location(l_proc, 20);
601: --
602: -- Process Logic
603: --
604: l_object_version_number := p_object_version_number;
659: -- End of API User Hook for the after hook of delete_Vrbl_Rate_Rule
660: --
661: end;
662: --
663: hr_utility.set_location(l_proc, 60);
664: --
665: -- When in validation only mode raise the Validate_Enabled exception
666: --
667: if p_validate then
667: if p_validate then
668: raise hr_api.validate_enabled;
669: end if;
670: --
671: hr_utility.set_location(' Leaving:'||l_proc, 70);
672: --
673: exception
674: --
675: when hr_api.validate_enabled then
720: l_validation_end_date date;
721: --
722: begin
723: --
724: hr_utility.set_location('Entering:'|| l_proc, 10);
725: --
726: ben_vrr_shd.lck
727: (
728: p_vrbl_rt_rl_id => p_vrbl_rt_rl_id
732: ,p_effective_date => p_effective_date
733: ,p_datetrack_mode => p_datetrack_mode
734: );
735: --
736: hr_utility.set_location(' Leaving:'||l_proc, 70);
737: --
738: end lck;
739: --
740: end ben_Vrbl_Rate_Rule_api;