76: ,p_effective_date in date) is
77: --
78: -- Declare cursors and local variables
79: --
80: l_elig_to_prte_rsn_id ben_elig_to_prte_rsn_f.elig_to_prte_rsn_id%TYPE;
81: l_effective_start_date ben_elig_to_prte_rsn_f.effective_start_date%TYPE;
82: l_effective_end_date ben_elig_to_prte_rsn_f.effective_end_date%TYPE;
83: l_proc varchar2(72) := g_package||'create_ELIG_TO_PRTE_REASON';
84: l_object_version_number ben_elig_to_prte_rsn_f.object_version_number%TYPE;
77: --
78: -- Declare cursors and local variables
79: --
80: l_elig_to_prte_rsn_id ben_elig_to_prte_rsn_f.elig_to_prte_rsn_id%TYPE;
81: l_effective_start_date ben_elig_to_prte_rsn_f.effective_start_date%TYPE;
82: l_effective_end_date ben_elig_to_prte_rsn_f.effective_end_date%TYPE;
83: l_proc varchar2(72) := g_package||'create_ELIG_TO_PRTE_REASON';
84: l_object_version_number ben_elig_to_prte_rsn_f.object_version_number%TYPE;
85: --
78: -- Declare cursors and local variables
79: --
80: l_elig_to_prte_rsn_id ben_elig_to_prte_rsn_f.elig_to_prte_rsn_id%TYPE;
81: l_effective_start_date ben_elig_to_prte_rsn_f.effective_start_date%TYPE;
82: l_effective_end_date ben_elig_to_prte_rsn_f.effective_end_date%TYPE;
83: l_proc varchar2(72) := g_package||'create_ELIG_TO_PRTE_REASON';
84: l_object_version_number ben_elig_to_prte_rsn_f.object_version_number%TYPE;
85: --
86: begin
80: l_elig_to_prte_rsn_id ben_elig_to_prte_rsn_f.elig_to_prte_rsn_id%TYPE;
81: l_effective_start_date ben_elig_to_prte_rsn_f.effective_start_date%TYPE;
82: l_effective_end_date ben_elig_to_prte_rsn_f.effective_end_date%TYPE;
83: l_proc varchar2(72) := g_package||'create_ELIG_TO_PRTE_REASON';
84: l_object_version_number ben_elig_to_prte_rsn_f.object_version_number%TYPE;
85: --
86: begin
87: --
88: hr_utility.set_location('Entering:'|| l_proc, 10);
440: --
441: -- Declare cursors and local variables
442: --
443: l_proc varchar2(72) := g_package||'update_ELIG_TO_PRTE_REASON';
444: l_object_version_number ben_elig_to_prte_rsn_f.object_version_number%TYPE;
445: l_effective_start_date ben_elig_to_prte_rsn_f.effective_start_date%TYPE;
446: l_effective_end_date ben_elig_to_prte_rsn_f.effective_end_date%TYPE;
447: --
448: begin
441: -- Declare cursors and local variables
442: --
443: l_proc varchar2(72) := g_package||'update_ELIG_TO_PRTE_REASON';
444: l_object_version_number ben_elig_to_prte_rsn_f.object_version_number%TYPE;
445: l_effective_start_date ben_elig_to_prte_rsn_f.effective_start_date%TYPE;
446: l_effective_end_date ben_elig_to_prte_rsn_f.effective_end_date%TYPE;
447: --
448: begin
449: --
442: --
443: l_proc varchar2(72) := g_package||'update_ELIG_TO_PRTE_REASON';
444: l_object_version_number ben_elig_to_prte_rsn_f.object_version_number%TYPE;
445: l_effective_start_date ben_elig_to_prte_rsn_f.effective_start_date%TYPE;
446: l_effective_end_date ben_elig_to_prte_rsn_f.effective_end_date%TYPE;
447: --
448: begin
449: --
450: hr_utility.set_location('Entering:'|| l_proc, 10);
745: --
746: -- Declare cursors and local variables
747: --
748: l_proc varchar2(72) := g_package||'update_ELIG_TO_PRTE_REASON';
749: l_object_version_number ben_elig_to_prte_rsn_f.object_version_number%TYPE;
750: l_effective_start_date ben_elig_to_prte_rsn_f.effective_start_date%TYPE;
751: l_effective_end_date ben_elig_to_prte_rsn_f.effective_end_date%TYPE;
752: --
753: begin
746: -- Declare cursors and local variables
747: --
748: l_proc varchar2(72) := g_package||'update_ELIG_TO_PRTE_REASON';
749: l_object_version_number ben_elig_to_prte_rsn_f.object_version_number%TYPE;
750: l_effective_start_date ben_elig_to_prte_rsn_f.effective_start_date%TYPE;
751: l_effective_end_date ben_elig_to_prte_rsn_f.effective_end_date%TYPE;
752: --
753: begin
754: --
747: --
748: l_proc varchar2(72) := g_package||'update_ELIG_TO_PRTE_REASON';
749: l_object_version_number ben_elig_to_prte_rsn_f.object_version_number%TYPE;
750: l_effective_start_date ben_elig_to_prte_rsn_f.effective_start_date%TYPE;
751: l_effective_end_date ben_elig_to_prte_rsn_f.effective_end_date%TYPE;
752: --
753: begin
754: --
755: hr_utility.set_location('Entering:'|| l_proc, 10);