77: ) is
78: --
79: -- Declare cursors and local variables
80: --
81: l_lee_rsn_id ben_lee_rsn_f.lee_rsn_id%TYPE;
82: l_effective_start_date ben_lee_rsn_f.effective_start_date%TYPE;
83: l_effective_end_date ben_lee_rsn_f.effective_end_date%TYPE;
84: l_proc varchar2(72) := g_package||'create_Life_Event_Enroll_Rsn';
85: l_object_version_number ben_lee_rsn_f.object_version_number%TYPE;
78: --
79: -- Declare cursors and local variables
80: --
81: l_lee_rsn_id ben_lee_rsn_f.lee_rsn_id%TYPE;
82: l_effective_start_date ben_lee_rsn_f.effective_start_date%TYPE;
83: l_effective_end_date ben_lee_rsn_f.effective_end_date%TYPE;
84: l_proc varchar2(72) := g_package||'create_Life_Event_Enroll_Rsn';
85: l_object_version_number ben_lee_rsn_f.object_version_number%TYPE;
86: --
79: -- Declare cursors and local variables
80: --
81: l_lee_rsn_id ben_lee_rsn_f.lee_rsn_id%TYPE;
82: l_effective_start_date ben_lee_rsn_f.effective_start_date%TYPE;
83: l_effective_end_date ben_lee_rsn_f.effective_end_date%TYPE;
84: l_proc varchar2(72) := g_package||'create_Life_Event_Enroll_Rsn';
85: l_object_version_number ben_lee_rsn_f.object_version_number%TYPE;
86: --
87: begin
81: l_lee_rsn_id ben_lee_rsn_f.lee_rsn_id%TYPE;
82: l_effective_start_date ben_lee_rsn_f.effective_start_date%TYPE;
83: l_effective_end_date ben_lee_rsn_f.effective_end_date%TYPE;
84: l_proc varchar2(72) := g_package||'create_Life_Event_Enroll_Rsn';
85: l_object_version_number ben_lee_rsn_f.object_version_number%TYPE;
86: --
87: begin
88: --
89: hr_utility.set_location('Entering:'|| l_proc, 10);
440: --
441: -- Declare cursors and local variables
442: --
443: l_proc varchar2(72) := g_package||'update_Life_Event_Enroll_Rsn';
444: l_object_version_number ben_lee_rsn_f.object_version_number%TYPE;
445: l_effective_start_date ben_lee_rsn_f.effective_start_date%TYPE;
446: l_effective_end_date ben_lee_rsn_f.effective_end_date%TYPE;
447: --
448: begin
441: -- Declare cursors and local variables
442: --
443: l_proc varchar2(72) := g_package||'update_Life_Event_Enroll_Rsn';
444: l_object_version_number ben_lee_rsn_f.object_version_number%TYPE;
445: l_effective_start_date ben_lee_rsn_f.effective_start_date%TYPE;
446: l_effective_end_date ben_lee_rsn_f.effective_end_date%TYPE;
447: --
448: begin
449: --
442: --
443: l_proc varchar2(72) := g_package||'update_Life_Event_Enroll_Rsn';
444: l_object_version_number ben_lee_rsn_f.object_version_number%TYPE;
445: l_effective_start_date ben_lee_rsn_f.effective_start_date%TYPE;
446: l_effective_end_date ben_lee_rsn_f.effective_end_date%TYPE;
447: --
448: begin
449: --
450: hr_utility.set_location('Entering:'|| l_proc, 10);
748: --
749: -- Declare cursors and local variables
750: --
751: l_proc varchar2(72) := g_package||'update_Life_Event_Enroll_Rsn';
752: l_object_version_number ben_lee_rsn_f.object_version_number%TYPE;
753: l_effective_start_date ben_lee_rsn_f.effective_start_date%TYPE;
754: l_effective_end_date ben_lee_rsn_f.effective_end_date%TYPE;
755: --
756: begin
749: -- Declare cursors and local variables
750: --
751: l_proc varchar2(72) := g_package||'update_Life_Event_Enroll_Rsn';
752: l_object_version_number ben_lee_rsn_f.object_version_number%TYPE;
753: l_effective_start_date ben_lee_rsn_f.effective_start_date%TYPE;
754: l_effective_end_date ben_lee_rsn_f.effective_end_date%TYPE;
755: --
756: begin
757: --
750: --
751: l_proc varchar2(72) := g_package||'update_Life_Event_Enroll_Rsn';
752: l_object_version_number ben_lee_rsn_f.object_version_number%TYPE;
753: l_effective_start_date ben_lee_rsn_f.effective_start_date%TYPE;
754: l_effective_end_date ben_lee_rsn_f.effective_end_date%TYPE;
755: --
756: begin
757: --
758: hr_utility.set_location('Entering:'|| l_proc, 10);