72: ) is
73: --
74: -- Declare cursors and local variables
75: --
76: l_prtn_elig_id ben_prtn_elig_f.prtn_elig_id%TYPE;
77: l_effective_start_date ben_prtn_elig_f.effective_start_date%TYPE;
78: l_effective_end_date ben_prtn_elig_f.effective_end_date%TYPE;
79: l_proc varchar2(72) := g_package||'create_Participation_Elig';
80: l_object_version_number ben_prtn_elig_f.object_version_number%TYPE;
73: --
74: -- Declare cursors and local variables
75: --
76: l_prtn_elig_id ben_prtn_elig_f.prtn_elig_id%TYPE;
77: l_effective_start_date ben_prtn_elig_f.effective_start_date%TYPE;
78: l_effective_end_date ben_prtn_elig_f.effective_end_date%TYPE;
79: l_proc varchar2(72) := g_package||'create_Participation_Elig';
80: l_object_version_number ben_prtn_elig_f.object_version_number%TYPE;
81: --
74: -- Declare cursors and local variables
75: --
76: l_prtn_elig_id ben_prtn_elig_f.prtn_elig_id%TYPE;
77: l_effective_start_date ben_prtn_elig_f.effective_start_date%TYPE;
78: l_effective_end_date ben_prtn_elig_f.effective_end_date%TYPE;
79: l_proc varchar2(72) := g_package||'create_Participation_Elig';
80: l_object_version_number ben_prtn_elig_f.object_version_number%TYPE;
81: --
82: begin
76: l_prtn_elig_id ben_prtn_elig_f.prtn_elig_id%TYPE;
77: l_effective_start_date ben_prtn_elig_f.effective_start_date%TYPE;
78: l_effective_end_date ben_prtn_elig_f.effective_end_date%TYPE;
79: l_proc varchar2(72) := g_package||'create_Participation_Elig';
80: l_object_version_number ben_prtn_elig_f.object_version_number%TYPE;
81: --
82: begin
83: --
84: hr_utility.set_location('Entering:'|| l_proc, 10);
417: --
418: -- Declare cursors and local variables
419: --
420: l_proc varchar2(72) := g_package||'update_Participation_Elig';
421: l_object_version_number ben_prtn_elig_f.object_version_number%TYPE;
422: l_effective_start_date ben_prtn_elig_f.effective_start_date%TYPE;
423: l_effective_end_date ben_prtn_elig_f.effective_end_date%TYPE;
424: --
425: begin
418: -- Declare cursors and local variables
419: --
420: l_proc varchar2(72) := g_package||'update_Participation_Elig';
421: l_object_version_number ben_prtn_elig_f.object_version_number%TYPE;
422: l_effective_start_date ben_prtn_elig_f.effective_start_date%TYPE;
423: l_effective_end_date ben_prtn_elig_f.effective_end_date%TYPE;
424: --
425: begin
426: --
419: --
420: l_proc varchar2(72) := g_package||'update_Participation_Elig';
421: l_object_version_number ben_prtn_elig_f.object_version_number%TYPE;
422: l_effective_start_date ben_prtn_elig_f.effective_start_date%TYPE;
423: l_effective_end_date ben_prtn_elig_f.effective_end_date%TYPE;
424: --
425: begin
426: --
427: hr_utility.set_location('Entering:'|| l_proc, 10);
709: --
710: -- Declare cursors and local variables
711: --
712: l_proc varchar2(72) := g_package||'update_Participation_Elig';
713: l_object_version_number ben_prtn_elig_f.object_version_number%TYPE;
714: l_effective_start_date ben_prtn_elig_f.effective_start_date%TYPE;
715: l_effective_end_date ben_prtn_elig_f.effective_end_date%TYPE;
716: --
717: begin
710: -- Declare cursors and local variables
711: --
712: l_proc varchar2(72) := g_package||'update_Participation_Elig';
713: l_object_version_number ben_prtn_elig_f.object_version_number%TYPE;
714: l_effective_start_date ben_prtn_elig_f.effective_start_date%TYPE;
715: l_effective_end_date ben_prtn_elig_f.effective_end_date%TYPE;
716: --
717: begin
718: --
711: --
712: l_proc varchar2(72) := g_package||'update_Participation_Elig';
713: l_object_version_number ben_prtn_elig_f.object_version_number%TYPE;
714: l_effective_start_date ben_prtn_elig_f.effective_start_date%TYPE;
715: l_effective_end_date ben_prtn_elig_f.effective_end_date%TYPE;
716: --
717: begin
718: --
719: hr_utility.set_location('Entering:'|| l_proc, 10);