58: ) is
59: --
60: -- Declare cursors and local variables
61: --
62: l_ler_rqrs_enrt_ctfn_id ben_ler_rqrs_enrt_ctfn_f.ler_rqrs_enrt_ctfn_id%TYPE;
63: l_effective_start_date ben_ler_rqrs_enrt_ctfn_f.effective_start_date%TYPE;
64: l_effective_end_date ben_ler_rqrs_enrt_ctfn_f.effective_end_date%TYPE;
65: l_proc varchar2(72) := g_package||'create_ler_rqrs_enrt_ctfn';
66: l_object_version_number ben_ler_rqrs_enrt_ctfn_f.object_version_number%TYPE;
59: --
60: -- Declare cursors and local variables
61: --
62: l_ler_rqrs_enrt_ctfn_id ben_ler_rqrs_enrt_ctfn_f.ler_rqrs_enrt_ctfn_id%TYPE;
63: l_effective_start_date ben_ler_rqrs_enrt_ctfn_f.effective_start_date%TYPE;
64: l_effective_end_date ben_ler_rqrs_enrt_ctfn_f.effective_end_date%TYPE;
65: l_proc varchar2(72) := g_package||'create_ler_rqrs_enrt_ctfn';
66: l_object_version_number ben_ler_rqrs_enrt_ctfn_f.object_version_number%TYPE;
67: --
60: -- Declare cursors and local variables
61: --
62: l_ler_rqrs_enrt_ctfn_id ben_ler_rqrs_enrt_ctfn_f.ler_rqrs_enrt_ctfn_id%TYPE;
63: l_effective_start_date ben_ler_rqrs_enrt_ctfn_f.effective_start_date%TYPE;
64: l_effective_end_date ben_ler_rqrs_enrt_ctfn_f.effective_end_date%TYPE;
65: l_proc varchar2(72) := g_package||'create_ler_rqrs_enrt_ctfn';
66: l_object_version_number ben_ler_rqrs_enrt_ctfn_f.object_version_number%TYPE;
67: --
68: begin
62: l_ler_rqrs_enrt_ctfn_id ben_ler_rqrs_enrt_ctfn_f.ler_rqrs_enrt_ctfn_id%TYPE;
63: l_effective_start_date ben_ler_rqrs_enrt_ctfn_f.effective_start_date%TYPE;
64: l_effective_end_date ben_ler_rqrs_enrt_ctfn_f.effective_end_date%TYPE;
65: l_proc varchar2(72) := g_package||'create_ler_rqrs_enrt_ctfn';
66: l_object_version_number ben_ler_rqrs_enrt_ctfn_f.object_version_number%TYPE;
67: --
68: begin
69: --
70: hr_utility.set_location('Entering:'|| l_proc, 10);
349: --
350: -- Declare cursors and local variables
351: --
352: l_proc varchar2(72) := g_package||'update_ler_rqrs_enrt_ctfn';
353: l_object_version_number ben_ler_rqrs_enrt_ctfn_f.object_version_number%TYPE;
354: l_effective_start_date ben_ler_rqrs_enrt_ctfn_f.effective_start_date%TYPE;
355: l_effective_end_date ben_ler_rqrs_enrt_ctfn_f.effective_end_date%TYPE;
356: --
357: begin
350: -- Declare cursors and local variables
351: --
352: l_proc varchar2(72) := g_package||'update_ler_rqrs_enrt_ctfn';
353: l_object_version_number ben_ler_rqrs_enrt_ctfn_f.object_version_number%TYPE;
354: l_effective_start_date ben_ler_rqrs_enrt_ctfn_f.effective_start_date%TYPE;
355: l_effective_end_date ben_ler_rqrs_enrt_ctfn_f.effective_end_date%TYPE;
356: --
357: begin
358: --
351: --
352: l_proc varchar2(72) := g_package||'update_ler_rqrs_enrt_ctfn';
353: l_object_version_number ben_ler_rqrs_enrt_ctfn_f.object_version_number%TYPE;
354: l_effective_start_date ben_ler_rqrs_enrt_ctfn_f.effective_start_date%TYPE;
355: l_effective_end_date ben_ler_rqrs_enrt_ctfn_f.effective_end_date%TYPE;
356: --
357: begin
358: --
359: hr_utility.set_location('Entering:'|| l_proc, 10);
599: --
600: -- Declare cursors and local variables
601: --
602: l_proc varchar2(72) := g_package||'update_ler_rqrs_enrt_ctfn';
603: l_object_version_number ben_ler_rqrs_enrt_ctfn_f.object_version_number%TYPE;
604: l_effective_start_date ben_ler_rqrs_enrt_ctfn_f.effective_start_date%TYPE;
605: l_effective_end_date ben_ler_rqrs_enrt_ctfn_f.effective_end_date%TYPE;
606: --
607: begin
600: -- Declare cursors and local variables
601: --
602: l_proc varchar2(72) := g_package||'update_ler_rqrs_enrt_ctfn';
603: l_object_version_number ben_ler_rqrs_enrt_ctfn_f.object_version_number%TYPE;
604: l_effective_start_date ben_ler_rqrs_enrt_ctfn_f.effective_start_date%TYPE;
605: l_effective_end_date ben_ler_rqrs_enrt_ctfn_f.effective_end_date%TYPE;
606: --
607: begin
608: --
601: --
602: l_proc varchar2(72) := g_package||'update_ler_rqrs_enrt_ctfn';
603: l_object_version_number ben_ler_rqrs_enrt_ctfn_f.object_version_number%TYPE;
604: l_effective_start_date ben_ler_rqrs_enrt_ctfn_f.effective_start_date%TYPE;
605: l_effective_end_date ben_ler_rqrs_enrt_ctfn_f.effective_end_date%TYPE;
606: --
607: begin
608: --
609: hr_utility.set_location('Entering:'|| l_proc, 10);