73: ) is
74: --
75: -- Declare cursors and local variables
76: --
77: l_ler_bnft_rstrn_id ben_ler_bnft_rstrn_f.ler_bnft_rstrn_id%TYPE;
78: l_effective_start_date ben_ler_bnft_rstrn_f.effective_start_date%TYPE;
79: l_effective_end_date ben_ler_bnft_rstrn_f.effective_end_date%TYPE;
80: l_proc varchar2(72) := g_package||'create_LER_BNFT_RSTRN';
81: l_object_version_number ben_ler_bnft_rstrn_f.object_version_number%TYPE;
74: --
75: -- Declare cursors and local variables
76: --
77: l_ler_bnft_rstrn_id ben_ler_bnft_rstrn_f.ler_bnft_rstrn_id%TYPE;
78: l_effective_start_date ben_ler_bnft_rstrn_f.effective_start_date%TYPE;
79: l_effective_end_date ben_ler_bnft_rstrn_f.effective_end_date%TYPE;
80: l_proc varchar2(72) := g_package||'create_LER_BNFT_RSTRN';
81: l_object_version_number ben_ler_bnft_rstrn_f.object_version_number%TYPE;
82: --
75: -- Declare cursors and local variables
76: --
77: l_ler_bnft_rstrn_id ben_ler_bnft_rstrn_f.ler_bnft_rstrn_id%TYPE;
78: l_effective_start_date ben_ler_bnft_rstrn_f.effective_start_date%TYPE;
79: l_effective_end_date ben_ler_bnft_rstrn_f.effective_end_date%TYPE;
80: l_proc varchar2(72) := g_package||'create_LER_BNFT_RSTRN';
81: l_object_version_number ben_ler_bnft_rstrn_f.object_version_number%TYPE;
82: --
83: begin
77: l_ler_bnft_rstrn_id ben_ler_bnft_rstrn_f.ler_bnft_rstrn_id%TYPE;
78: l_effective_start_date ben_ler_bnft_rstrn_f.effective_start_date%TYPE;
79: l_effective_end_date ben_ler_bnft_rstrn_f.effective_end_date%TYPE;
80: l_proc varchar2(72) := g_package||'create_LER_BNFT_RSTRN';
81: l_object_version_number ben_ler_bnft_rstrn_f.object_version_number%TYPE;
82: --
83: begin
84: --
85: hr_utility.set_location('Entering:'|| l_proc, 10);
420: --
421: -- Declare cursors and local variables
422: --
423: l_proc varchar2(72) := g_package||'update_LER_BNFT_RSTRN';
424: l_object_version_number ben_ler_bnft_rstrn_f.object_version_number%TYPE;
425: l_effective_start_date ben_ler_bnft_rstrn_f.effective_start_date%TYPE;
426: l_effective_end_date ben_ler_bnft_rstrn_f.effective_end_date%TYPE;
427: --
428: begin
421: -- Declare cursors and local variables
422: --
423: l_proc varchar2(72) := g_package||'update_LER_BNFT_RSTRN';
424: l_object_version_number ben_ler_bnft_rstrn_f.object_version_number%TYPE;
425: l_effective_start_date ben_ler_bnft_rstrn_f.effective_start_date%TYPE;
426: l_effective_end_date ben_ler_bnft_rstrn_f.effective_end_date%TYPE;
427: --
428: begin
429: --
422: --
423: l_proc varchar2(72) := g_package||'update_LER_BNFT_RSTRN';
424: l_object_version_number ben_ler_bnft_rstrn_f.object_version_number%TYPE;
425: l_effective_start_date ben_ler_bnft_rstrn_f.effective_start_date%TYPE;
426: l_effective_end_date ben_ler_bnft_rstrn_f.effective_end_date%TYPE;
427: --
428: begin
429: --
430: hr_utility.set_location('Entering:'|| l_proc, 10);
716: --
717: -- Declare cursors and local variables
718: --
719: l_proc varchar2(72) := g_package||'update_LER_BNFT_RSTRN';
720: l_object_version_number ben_ler_bnft_rstrn_f.object_version_number%TYPE;
721: l_effective_start_date ben_ler_bnft_rstrn_f.effective_start_date%TYPE;
722: l_effective_end_date ben_ler_bnft_rstrn_f.effective_end_date%TYPE;
723: --
724: begin
717: -- Declare cursors and local variables
718: --
719: l_proc varchar2(72) := g_package||'update_LER_BNFT_RSTRN';
720: l_object_version_number ben_ler_bnft_rstrn_f.object_version_number%TYPE;
721: l_effective_start_date ben_ler_bnft_rstrn_f.effective_start_date%TYPE;
722: l_effective_end_date ben_ler_bnft_rstrn_f.effective_end_date%TYPE;
723: --
724: begin
725: --
718: --
719: l_proc varchar2(72) := g_package||'update_LER_BNFT_RSTRN';
720: l_object_version_number ben_ler_bnft_rstrn_f.object_version_number%TYPE;
721: l_effective_start_date ben_ler_bnft_rstrn_f.effective_start_date%TYPE;
722: l_effective_end_date ben_ler_bnft_rstrn_f.effective_end_date%TYPE;
723: --
724: begin
725: --
726: hr_utility.set_location('Entering:'|| l_proc, 10);