53: ) is
54: --
55: -- Declare cursors and local variables
56: --
57: l_svc_area_id ben_svc_area_f.svc_area_id%TYPE;
58: l_effective_start_date ben_svc_area_f.effective_start_date%TYPE;
59: l_effective_end_date ben_svc_area_f.effective_end_date%TYPE;
60: l_proc varchar2(72) := g_package||'create_SERVICE_AREA';
61: l_object_version_number ben_svc_area_f.object_version_number%TYPE;
54: --
55: -- Declare cursors and local variables
56: --
57: l_svc_area_id ben_svc_area_f.svc_area_id%TYPE;
58: l_effective_start_date ben_svc_area_f.effective_start_date%TYPE;
59: l_effective_end_date ben_svc_area_f.effective_end_date%TYPE;
60: l_proc varchar2(72) := g_package||'create_SERVICE_AREA';
61: l_object_version_number ben_svc_area_f.object_version_number%TYPE;
62: --
55: -- Declare cursors and local variables
56: --
57: l_svc_area_id ben_svc_area_f.svc_area_id%TYPE;
58: l_effective_start_date ben_svc_area_f.effective_start_date%TYPE;
59: l_effective_end_date ben_svc_area_f.effective_end_date%TYPE;
60: l_proc varchar2(72) := g_package||'create_SERVICE_AREA';
61: l_object_version_number ben_svc_area_f.object_version_number%TYPE;
62: --
63: begin
57: l_svc_area_id ben_svc_area_f.svc_area_id%TYPE;
58: l_effective_start_date ben_svc_area_f.effective_start_date%TYPE;
59: l_effective_end_date ben_svc_area_f.effective_end_date%TYPE;
60: l_proc varchar2(72) := g_package||'create_SERVICE_AREA';
61: l_object_version_number ben_svc_area_f.object_version_number%TYPE;
62: --
63: begin
64: --
65: hr_utility.set_location('Entering:'|| l_proc, 10);
327: --
328: -- Declare cursors and local variables
329: --
330: l_proc varchar2(72) := g_package||'update_SERVICE_AREA';
331: l_object_version_number ben_svc_area_f.object_version_number%TYPE;
332: l_effective_start_date ben_svc_area_f.effective_start_date%TYPE;
333: l_effective_end_date ben_svc_area_f.effective_end_date%TYPE;
334: --
335: begin
328: -- Declare cursors and local variables
329: --
330: l_proc varchar2(72) := g_package||'update_SERVICE_AREA';
331: l_object_version_number ben_svc_area_f.object_version_number%TYPE;
332: l_effective_start_date ben_svc_area_f.effective_start_date%TYPE;
333: l_effective_end_date ben_svc_area_f.effective_end_date%TYPE;
334: --
335: begin
336: --
329: --
330: l_proc varchar2(72) := g_package||'update_SERVICE_AREA';
331: l_object_version_number ben_svc_area_f.object_version_number%TYPE;
332: l_effective_start_date ben_svc_area_f.effective_start_date%TYPE;
333: l_effective_end_date ben_svc_area_f.effective_end_date%TYPE;
334: --
335: begin
336: --
337: hr_utility.set_location('Entering:'|| l_proc, 10);
565: --
566: -- Declare cursors and local variables
567: --
568: l_proc varchar2(72) := g_package||'update_SERVICE_AREA';
569: l_object_version_number ben_svc_area_f.object_version_number%TYPE;
570: l_effective_start_date ben_svc_area_f.effective_start_date%TYPE;
571: l_effective_end_date ben_svc_area_f.effective_end_date%TYPE;
572: --
573: begin
566: -- Declare cursors and local variables
567: --
568: l_proc varchar2(72) := g_package||'update_SERVICE_AREA';
569: l_object_version_number ben_svc_area_f.object_version_number%TYPE;
570: l_effective_start_date ben_svc_area_f.effective_start_date%TYPE;
571: l_effective_end_date ben_svc_area_f.effective_end_date%TYPE;
572: --
573: begin
574: --
567: --
568: l_proc varchar2(72) := g_package||'update_SERVICE_AREA';
569: l_object_version_number ben_svc_area_f.object_version_number%TYPE;
570: l_effective_start_date ben_svc_area_f.effective_start_date%TYPE;
571: l_effective_end_date ben_svc_area_f.effective_end_date%TYPE;
572: --
573: begin
574: --
575: hr_utility.set_location('Entering:'|| l_proc, 10);