68: l_object_version_number ben_poe_rt_f.object_version_number%TYPE;
69: --
70: begin
71: --
72: hr_utility.set_location('Entering:'|| l_proc, 10);
73: --
74: -- Issue a savepoint if operating in validation only mode
75: --
76: savepoint create_POE_RT;
74: -- Issue a savepoint if operating in validation only mode
75: --
76: savepoint create_POE_RT;
77: --
78: hr_utility.set_location(l_proc, 20);
79: --
80: -- Process Logic
81: --
82: begin
262: p_base_table_reference_column => 'RT_POE_FLAG',
263: p_reference_table => 'BEN_POE_RT_F',
264: p_reference_table_column => 'VRBL_RT_PRFL_ID');
265: --
266: hr_utility.set_location(l_proc, 60);
267: --
268: -- When in validation only mode raise the Validate_Enabled exception
269: --
270: if p_validate then
277: p_effective_start_date := l_effective_start_date;
278: p_effective_end_date := l_effective_end_date;
279: p_object_version_number := l_object_version_number;
280: --
281: hr_utility.set_location(' Leaving:'||l_proc, 70);
282: --
283: exception
284: --
285: when hr_api.validate_enabled then
296: p_poe_rt_id := null;
297: p_effective_start_date := null;
298: p_effective_end_date := null;
299: p_object_version_number := null;
300: hr_utility.set_location(' Leaving:'||l_proc, 80);
301: --
302: when others then
303: --
304: -- A validation or unexpected error has occured
374: l_effective_end_date ben_poe_rt_f.effective_end_date%TYPE;
375: --
376: begin
377: --
378: hr_utility.set_location('Entering:'|| l_proc, 10);
379: --
380: -- Issue a savepoint if operating in validation only mode
381: --
382: savepoint update_POE_RT;
380: -- Issue a savepoint if operating in validation only mode
381: --
382: savepoint update_POE_RT;
383: --
384: hr_utility.set_location(l_proc, 20);
385: --
386: -- Process Logic
387: --
388: l_object_version_number := p_object_version_number;
565: -- End of API User Hook for the after hook of update_POE_RT
566: --
567: end;
568: --
569: hr_utility.set_location(l_proc, 60);
570: --
571: -- When in validation only mode raise the Validate_Enabled exception
572: --
573: if p_validate then
579: p_object_version_number := l_object_version_number;
580: p_effective_start_date := l_effective_start_date;
581: p_effective_end_date := l_effective_end_date;
582: --
583: hr_utility.set_location(' Leaving:'||l_proc, 70);
584: --
585: exception
586: --
587: when hr_api.validate_enabled then
596: -- when validation only mode is being used.)
597: --
598: p_effective_start_date := null;
599: p_effective_end_date := null;
600: hr_utility.set_location(' Leaving:'||l_proc, 80);
601: --
602: when others then
603: --
604: -- A validation or unexpected error has occured
631: l_effective_end_date ben_poe_rt_f.effective_end_date%TYPE;
632: --
633: begin
634: --
635: hr_utility.set_location('Entering:'|| l_proc, 10);
636: --
637: -- Issue a savepoint if operating in validation only mode
638: --
639: savepoint delete_POE_RT;
637: -- Issue a savepoint if operating in validation only mode
638: --
639: savepoint delete_POE_RT;
640: --
641: hr_utility.set_location(l_proc, 20);
642: --
643: -- Process Logic
644: --
645: l_object_version_number := p_object_version_number;
709: p_base_table_reference_column => 'RT_POE_FLAG',
710: p_reference_table => 'BEN_POE_RT_F',
711: p_reference_table_column => 'VRBL_RT_PRFL_ID');
712: --
713: hr_utility.set_location(l_proc, 60);
714: --
715: -- When in validation only mode raise the Validate_Enabled exception
716: --
717: if p_validate then
717: if p_validate then
718: raise hr_api.validate_enabled;
719: end if;
720: --
721: hr_utility.set_location(' Leaving:'||l_proc, 70);
722: --
723: exception
724: --
725: when hr_api.validate_enabled then
769: l_validation_end_date date;
770: --
771: begin
772: --
773: hr_utility.set_location('Entering:'|| l_proc, 10);
774: --
775: ben_prt_shd.lck
776: (
777: p_poe_rt_id => p_poe_rt_id
781: ,p_effective_date => p_effective_date
782: ,p_datetrack_mode => p_datetrack_mode
783: );
784: --
785: hr_utility.set_location(' Leaving:'||l_proc, 70);
786: --
787: end lck;
788: --
789: end ben_POE_RT_api;