[Home] [Help]
66: l_object_version_number ben_pl_gd_or_svc_f.object_version_number%TYPE;
67: --
68: begin
69: --
70: hr_utility.set_location('Entering:'|| l_proc, 10);
71: --
72: -- Issue a savepoint if operating in validation only mode
73: --
74: savepoint create_Plan_goods_services;
72: -- Issue a savepoint if operating in validation only mode
73: --
74: savepoint create_Plan_goods_services;
75: --
76: hr_utility.set_location(l_proc, 20);
77: --
78: -- Process Logic
79: --
80: begin
245: -- End of API User Hook for the after hook of create_Plan_goods_services
246: --
247: end;
248: --
249: hr_utility.set_location(l_proc, 60);
250: --
251: -- When in validation only mode raise the Validate_Enabled exception
252: --
253: if p_validate then
260: p_effective_start_date := l_effective_start_date;
261: p_effective_end_date := l_effective_end_date;
262: p_object_version_number := l_object_version_number;
263: --
264: hr_utility.set_location(' Leaving:'||l_proc, 70);
265: --
266: exception
267: --
268: when hr_api.validate_enabled then
279: p_pl_gd_or_svc_id := null;
280: p_effective_start_date := null;
281: p_effective_end_date := null;
282: p_object_version_number := null;
283: hr_utility.set_location(' Leaving:'||l_proc, 80);
284: --
285: when others then
286: --
287: -- A validation or unexpected error has occured
291: p_pl_gd_or_svc_id := null;
292: p_effective_start_date := null;
293: p_effective_end_date := null;
294: p_object_version_number := null ;
295: hr_utility.set_location(' Leaving:'||l_proc, 90);
296: raise;
297: --
298: end create_Plan_goods_services;
299: -- ----------------------------------------------------------------------------
357: l_effective_end_date ben_pl_gd_or_svc_f.effective_end_date%TYPE;
358: --
359: begin
360: --
361: hr_utility.set_location('Entering:'|| l_proc, 10);
362: --
363: -- Issue a savepoint if operating in validation only mode
364: --
365: savepoint update_Plan_goods_services;
363: -- Issue a savepoint if operating in validation only mode
364: --
365: savepoint update_Plan_goods_services;
366: --
367: hr_utility.set_location(l_proc, 20);
368: --
369: -- Process Logic
370: --
371: l_object_version_number := p_object_version_number;
544: -- End of API User Hook for the after hook of update_Plan_goods_services
545: --
546: end;
547: --
548: hr_utility.set_location(l_proc, 60);
549: --
550: -- When in validation only mode raise the Validate_Enabled exception
551: --
552: if p_validate then
558: p_object_version_number := l_object_version_number;
559: p_effective_start_date := l_effective_start_date;
560: p_effective_end_date := l_effective_end_date;
561: --
562: hr_utility.set_location(' Leaving:'||l_proc, 70);
563: --
564: exception
565: --
566: when hr_api.validate_enabled then
573: -- Only set output warning arguments
574: -- (Any key or derived arguments must be set to null
575: -- when validation only mode is being used.)
576: --
577: hr_utility.set_location(' Leaving:'||l_proc, 80);
578: --
579: when others then
580: --
581: -- A validation or unexpected error has occured
584: -- NOCOPY Changes
585: p_effective_start_date := null;
586: p_effective_end_date := null;
587: p_object_version_number := l_object_version_number ;
588: hr_utility.set_location(' Leaving:'||l_proc, 90);
589: raise;
590: --
591: end update_Plan_goods_services;
592: -- ----------------------------------------------------------------------------
611: l_effective_end_date ben_pl_gd_or_svc_f.effective_end_date%TYPE;
612: --
613: begin
614: --
615: hr_utility.set_location('Entering:'|| l_proc, 10);
616: --
617: -- Issue a savepoint if operating in validation only mode
618: --
619: savepoint delete_Plan_goods_services;
617: -- Issue a savepoint if operating in validation only mode
618: --
619: savepoint delete_Plan_goods_services;
620: --
621: hr_utility.set_location(l_proc, 20);
622: --
623: -- Process Logic
624: --
625: l_object_version_number := p_object_version_number;
680: -- End of API User Hook for the after hook of delete_Plan_goods_services
681: --
682: end;
683: --
684: hr_utility.set_location(l_proc, 60);
685: --
686: -- When in validation only mode raise the Validate_Enabled exception
687: --
688: if p_validate then
688: if p_validate then
689: raise hr_api.validate_enabled;
690: end if;
691: --
692: hr_utility.set_location(' Leaving:'||l_proc, 70);
693: --
694: exception
695: --
696: when hr_api.validate_enabled then
715: -- NOCOPY Changes
716: p_effective_start_date := null;
717: p_effective_end_date := null;
718: p_object_version_number := l_object_version_number ;
719: hr_utility.set_location(' Leaving:'||l_proc, 90);
720: raise;
721: --
722: end delete_Plan_goods_services;
723: --
743: l_validation_end_date date;
744: --
745: begin
746: --
747: hr_utility.set_location('Entering:'|| l_proc, 10);
748: --
749: ben_vgs_shd.lck
750: (
751: p_pl_gd_or_svc_id => p_pl_gd_or_svc_id
755: ,p_effective_date => p_effective_date
756: ,p_datetrack_mode => p_datetrack_mode
757: );
758: --
759: hr_utility.set_location(' Leaving:'||l_proc, 70);
760: --
761: end lck;
762: --
763: end ben_Plan_goods_services_api;