59: ) is
60: --
61: -- Declare cursors and local variables
62: --
63: l_pl_bnf_ctfn_id ben_pl_bnf_ctfn_f.pl_bnf_ctfn_id%TYPE;
64: l_effective_start_date ben_pl_bnf_ctfn_f.effective_start_date%TYPE;
65: l_effective_end_date ben_pl_bnf_ctfn_f.effective_end_date%TYPE;
66: l_proc varchar2(72) := g_package||'create_Plan_Beneficiary_Ctfn';
67: l_object_version_number ben_pl_bnf_ctfn_f.object_version_number%TYPE;
60: --
61: -- Declare cursors and local variables
62: --
63: l_pl_bnf_ctfn_id ben_pl_bnf_ctfn_f.pl_bnf_ctfn_id%TYPE;
64: l_effective_start_date ben_pl_bnf_ctfn_f.effective_start_date%TYPE;
65: l_effective_end_date ben_pl_bnf_ctfn_f.effective_end_date%TYPE;
66: l_proc varchar2(72) := g_package||'create_Plan_Beneficiary_Ctfn';
67: l_object_version_number ben_pl_bnf_ctfn_f.object_version_number%TYPE;
68: --
61: -- Declare cursors and local variables
62: --
63: l_pl_bnf_ctfn_id ben_pl_bnf_ctfn_f.pl_bnf_ctfn_id%TYPE;
64: l_effective_start_date ben_pl_bnf_ctfn_f.effective_start_date%TYPE;
65: l_effective_end_date ben_pl_bnf_ctfn_f.effective_end_date%TYPE;
66: l_proc varchar2(72) := g_package||'create_Plan_Beneficiary_Ctfn';
67: l_object_version_number ben_pl_bnf_ctfn_f.object_version_number%TYPE;
68: --
69: begin
63: l_pl_bnf_ctfn_id ben_pl_bnf_ctfn_f.pl_bnf_ctfn_id%TYPE;
64: l_effective_start_date ben_pl_bnf_ctfn_f.effective_start_date%TYPE;
65: l_effective_end_date ben_pl_bnf_ctfn_f.effective_end_date%TYPE;
66: l_proc varchar2(72) := g_package||'create_Plan_Beneficiary_Ctfn';
67: l_object_version_number ben_pl_bnf_ctfn_f.object_version_number%TYPE;
68: --
69: begin
70: --
71: hr_utility.set_location('Entering:'|| l_proc, 10);
357: --
358: -- Declare cursors and local variables
359: --
360: l_proc varchar2(72) := g_package||'update_Plan_Beneficiary_Ctfn';
361: l_object_version_number ben_pl_bnf_ctfn_f.object_version_number%TYPE;
362: l_effective_start_date ben_pl_bnf_ctfn_f.effective_start_date%TYPE;
363: l_effective_end_date ben_pl_bnf_ctfn_f.effective_end_date%TYPE;
364: --
365: begin
358: -- Declare cursors and local variables
359: --
360: l_proc varchar2(72) := g_package||'update_Plan_Beneficiary_Ctfn';
361: l_object_version_number ben_pl_bnf_ctfn_f.object_version_number%TYPE;
362: l_effective_start_date ben_pl_bnf_ctfn_f.effective_start_date%TYPE;
363: l_effective_end_date ben_pl_bnf_ctfn_f.effective_end_date%TYPE;
364: --
365: begin
366: --
359: --
360: l_proc varchar2(72) := g_package||'update_Plan_Beneficiary_Ctfn';
361: l_object_version_number ben_pl_bnf_ctfn_f.object_version_number%TYPE;
362: l_effective_start_date ben_pl_bnf_ctfn_f.effective_start_date%TYPE;
363: l_effective_end_date ben_pl_bnf_ctfn_f.effective_end_date%TYPE;
364: --
365: begin
366: --
367: hr_utility.set_location('Entering:'|| l_proc, 10);
613: --
614: -- Declare cursors and local variables
615: --
616: l_proc varchar2(72) := g_package||'update_Plan_Beneficiary_Ctfn';
617: l_object_version_number ben_pl_bnf_ctfn_f.object_version_number%TYPE;
618: l_effective_start_date ben_pl_bnf_ctfn_f.effective_start_date%TYPE;
619: l_effective_end_date ben_pl_bnf_ctfn_f.effective_end_date%TYPE;
620: --
621: begin
614: -- Declare cursors and local variables
615: --
616: l_proc varchar2(72) := g_package||'update_Plan_Beneficiary_Ctfn';
617: l_object_version_number ben_pl_bnf_ctfn_f.object_version_number%TYPE;
618: l_effective_start_date ben_pl_bnf_ctfn_f.effective_start_date%TYPE;
619: l_effective_end_date ben_pl_bnf_ctfn_f.effective_end_date%TYPE;
620: --
621: begin
622: --
615: --
616: l_proc varchar2(72) := g_package||'update_Plan_Beneficiary_Ctfn';
617: l_object_version_number ben_pl_bnf_ctfn_f.object_version_number%TYPE;
618: l_effective_start_date ben_pl_bnf_ctfn_f.effective_start_date%TYPE;
619: l_effective_end_date ben_pl_bnf_ctfn_f.effective_end_date%TYPE;
620: --
621: begin
622: --
623: hr_utility.set_location('Entering:'|| l_proc, 10);