53: ) is
54: --
55: -- Declare cursors and local variables
56: --
57: l_svc_area_pstl_zip_rng_id ben_svc_area_pstl_zip_rng_f.svc_area_pstl_zip_rng_id%TYPE;
58: l_effective_start_date ben_svc_area_pstl_zip_rng_f.effective_start_date%TYPE;
59: l_effective_end_date ben_svc_area_pstl_zip_rng_f.effective_end_date%TYPE;
60: l_proc varchar2(72) := g_package||'create_SVC_AREA_PSTL_ZIP_RNG';
61: l_object_version_number ben_svc_area_pstl_zip_rng_f.object_version_number%TYPE;
54: --
55: -- Declare cursors and local variables
56: --
57: l_svc_area_pstl_zip_rng_id ben_svc_area_pstl_zip_rng_f.svc_area_pstl_zip_rng_id%TYPE;
58: l_effective_start_date ben_svc_area_pstl_zip_rng_f.effective_start_date%TYPE;
59: l_effective_end_date ben_svc_area_pstl_zip_rng_f.effective_end_date%TYPE;
60: l_proc varchar2(72) := g_package||'create_SVC_AREA_PSTL_ZIP_RNG';
61: l_object_version_number ben_svc_area_pstl_zip_rng_f.object_version_number%TYPE;
62: --
55: -- Declare cursors and local variables
56: --
57: l_svc_area_pstl_zip_rng_id ben_svc_area_pstl_zip_rng_f.svc_area_pstl_zip_rng_id%TYPE;
58: l_effective_start_date ben_svc_area_pstl_zip_rng_f.effective_start_date%TYPE;
59: l_effective_end_date ben_svc_area_pstl_zip_rng_f.effective_end_date%TYPE;
60: l_proc varchar2(72) := g_package||'create_SVC_AREA_PSTL_ZIP_RNG';
61: l_object_version_number ben_svc_area_pstl_zip_rng_f.object_version_number%TYPE;
62: --
63: begin
57: l_svc_area_pstl_zip_rng_id ben_svc_area_pstl_zip_rng_f.svc_area_pstl_zip_rng_id%TYPE;
58: l_effective_start_date ben_svc_area_pstl_zip_rng_f.effective_start_date%TYPE;
59: l_effective_end_date ben_svc_area_pstl_zip_rng_f.effective_end_date%TYPE;
60: l_proc varchar2(72) := g_package||'create_SVC_AREA_PSTL_ZIP_RNG';
61: l_object_version_number ben_svc_area_pstl_zip_rng_f.object_version_number%TYPE;
62: --
63: begin
64: --
65: hr_utility.set_location('Entering:'|| l_proc, 10);
324: --
325: -- Declare cursors and local variables
326: --
327: l_proc varchar2(72) := g_package||'update_SVC_AREA_PSTL_ZIP_RNG';
328: l_object_version_number ben_svc_area_pstl_zip_rng_f.object_version_number%TYPE;
329: l_effective_start_date ben_svc_area_pstl_zip_rng_f.effective_start_date%TYPE;
330: l_effective_end_date ben_svc_area_pstl_zip_rng_f.effective_end_date%TYPE;
331: --
332: begin
325: -- Declare cursors and local variables
326: --
327: l_proc varchar2(72) := g_package||'update_SVC_AREA_PSTL_ZIP_RNG';
328: l_object_version_number ben_svc_area_pstl_zip_rng_f.object_version_number%TYPE;
329: l_effective_start_date ben_svc_area_pstl_zip_rng_f.effective_start_date%TYPE;
330: l_effective_end_date ben_svc_area_pstl_zip_rng_f.effective_end_date%TYPE;
331: --
332: begin
333: --
326: --
327: l_proc varchar2(72) := g_package||'update_SVC_AREA_PSTL_ZIP_RNG';
328: l_object_version_number ben_svc_area_pstl_zip_rng_f.object_version_number%TYPE;
329: l_effective_start_date ben_svc_area_pstl_zip_rng_f.effective_start_date%TYPE;
330: l_effective_end_date ben_svc_area_pstl_zip_rng_f.effective_end_date%TYPE;
331: --
332: begin
333: --
334: hr_utility.set_location('Entering:'|| l_proc, 10);
558: --
559: -- Declare cursors and local variables
560: --
561: l_proc varchar2(72) := g_package||'update_SVC_AREA_PSTL_ZIP_RNG';
562: l_object_version_number ben_svc_area_pstl_zip_rng_f.object_version_number%TYPE;
563: l_effective_start_date ben_svc_area_pstl_zip_rng_f.effective_start_date%TYPE;
564: l_effective_end_date ben_svc_area_pstl_zip_rng_f.effective_end_date%TYPE;
565: --
566: begin
559: -- Declare cursors and local variables
560: --
561: l_proc varchar2(72) := g_package||'update_SVC_AREA_PSTL_ZIP_RNG';
562: l_object_version_number ben_svc_area_pstl_zip_rng_f.object_version_number%TYPE;
563: l_effective_start_date ben_svc_area_pstl_zip_rng_f.effective_start_date%TYPE;
564: l_effective_end_date ben_svc_area_pstl_zip_rng_f.effective_end_date%TYPE;
565: --
566: begin
567: --
560: --
561: l_proc varchar2(72) := g_package||'update_SVC_AREA_PSTL_ZIP_RNG';
562: l_object_version_number ben_svc_area_pstl_zip_rng_f.object_version_number%TYPE;
563: l_effective_start_date ben_svc_area_pstl_zip_rng_f.effective_start_date%TYPE;
564: l_effective_end_date ben_svc_area_pstl_zip_rng_f.effective_end_date%TYPE;
565: --
566: begin
567: --
568: hr_utility.set_location('Entering:'|| l_proc, 10);