55: ) is
56: --
57: -- Declare cursors and local variables
58: --
59: l_ler_bnft_rstrn_ctfn_id ben_ler_bnft_rstrn_ctfn_f.ler_bnft_rstrn_ctfn_id%TYPE;
60: l_effective_start_date ben_ler_bnft_rstrn_ctfn_f.effective_start_date%TYPE;
61: l_effective_end_date ben_ler_bnft_rstrn_ctfn_f.effective_end_date%TYPE;
62: l_proc varchar2(72) := g_package||'create_LER_BNFT_RSTRN_CTFN';
63: l_object_version_number ben_ler_bnft_rstrn_ctfn_f.object_version_number%TYPE;
56: --
57: -- Declare cursors and local variables
58: --
59: l_ler_bnft_rstrn_ctfn_id ben_ler_bnft_rstrn_ctfn_f.ler_bnft_rstrn_ctfn_id%TYPE;
60: l_effective_start_date ben_ler_bnft_rstrn_ctfn_f.effective_start_date%TYPE;
61: l_effective_end_date ben_ler_bnft_rstrn_ctfn_f.effective_end_date%TYPE;
62: l_proc varchar2(72) := g_package||'create_LER_BNFT_RSTRN_CTFN';
63: l_object_version_number ben_ler_bnft_rstrn_ctfn_f.object_version_number%TYPE;
64: --
57: -- Declare cursors and local variables
58: --
59: l_ler_bnft_rstrn_ctfn_id ben_ler_bnft_rstrn_ctfn_f.ler_bnft_rstrn_ctfn_id%TYPE;
60: l_effective_start_date ben_ler_bnft_rstrn_ctfn_f.effective_start_date%TYPE;
61: l_effective_end_date ben_ler_bnft_rstrn_ctfn_f.effective_end_date%TYPE;
62: l_proc varchar2(72) := g_package||'create_LER_BNFT_RSTRN_CTFN';
63: l_object_version_number ben_ler_bnft_rstrn_ctfn_f.object_version_number%TYPE;
64: --
65: begin
59: l_ler_bnft_rstrn_ctfn_id ben_ler_bnft_rstrn_ctfn_f.ler_bnft_rstrn_ctfn_id%TYPE;
60: l_effective_start_date ben_ler_bnft_rstrn_ctfn_f.effective_start_date%TYPE;
61: l_effective_end_date ben_ler_bnft_rstrn_ctfn_f.effective_end_date%TYPE;
62: l_proc varchar2(72) := g_package||'create_LER_BNFT_RSTRN_CTFN';
63: l_object_version_number ben_ler_bnft_rstrn_ctfn_f.object_version_number%TYPE;
64: --
65: begin
66: --
67: hr_utility.set_location('Entering:'|| l_proc, 10);
334: --
335: -- Declare cursors and local variables
336: --
337: l_proc varchar2(72) := g_package||'update_LER_BNFT_RSTRN_CTFN';
338: l_object_version_number ben_ler_bnft_rstrn_ctfn_f.object_version_number%TYPE;
339: l_effective_start_date ben_ler_bnft_rstrn_ctfn_f.effective_start_date%TYPE;
340: l_effective_end_date ben_ler_bnft_rstrn_ctfn_f.effective_end_date%TYPE;
341: --
342: begin
335: -- Declare cursors and local variables
336: --
337: l_proc varchar2(72) := g_package||'update_LER_BNFT_RSTRN_CTFN';
338: l_object_version_number ben_ler_bnft_rstrn_ctfn_f.object_version_number%TYPE;
339: l_effective_start_date ben_ler_bnft_rstrn_ctfn_f.effective_start_date%TYPE;
340: l_effective_end_date ben_ler_bnft_rstrn_ctfn_f.effective_end_date%TYPE;
341: --
342: begin
343: --
336: --
337: l_proc varchar2(72) := g_package||'update_LER_BNFT_RSTRN_CTFN';
338: l_object_version_number ben_ler_bnft_rstrn_ctfn_f.object_version_number%TYPE;
339: l_effective_start_date ben_ler_bnft_rstrn_ctfn_f.effective_start_date%TYPE;
340: l_effective_end_date ben_ler_bnft_rstrn_ctfn_f.effective_end_date%TYPE;
341: --
342: begin
343: --
344: hr_utility.set_location('Entering:'|| l_proc, 10);
576: --
577: -- Declare cursors and local variables
578: --
579: l_proc varchar2(72) := g_package||'update_LER_BNFT_RSTRN_CTFN';
580: l_object_version_number ben_ler_bnft_rstrn_ctfn_f.object_version_number%TYPE;
581: l_effective_start_date ben_ler_bnft_rstrn_ctfn_f.effective_start_date%TYPE;
582: l_effective_end_date ben_ler_bnft_rstrn_ctfn_f.effective_end_date%TYPE;
583: --
584: begin
577: -- Declare cursors and local variables
578: --
579: l_proc varchar2(72) := g_package||'update_LER_BNFT_RSTRN_CTFN';
580: l_object_version_number ben_ler_bnft_rstrn_ctfn_f.object_version_number%TYPE;
581: l_effective_start_date ben_ler_bnft_rstrn_ctfn_f.effective_start_date%TYPE;
582: l_effective_end_date ben_ler_bnft_rstrn_ctfn_f.effective_end_date%TYPE;
583: --
584: begin
585: --
578: --
579: l_proc varchar2(72) := g_package||'update_LER_BNFT_RSTRN_CTFN';
580: l_object_version_number ben_ler_bnft_rstrn_ctfn_f.object_version_number%TYPE;
581: l_effective_start_date ben_ler_bnft_rstrn_ctfn_f.effective_start_date%TYPE;
582: l_effective_end_date ben_ler_bnft_rstrn_ctfn_f.effective_end_date%TYPE;
583: --
584: begin
585: --
586: hr_utility.set_location('Entering:'|| l_proc, 10);