78: ,p_effective_date in date) is
79: --
80: -- Declare cursors and local variables
81: --
82: l_cvg_amt_calc_mthd_id ben_cvg_amt_calc_mthd_f.cvg_amt_calc_mthd_id%TYPE;
83: l_effective_start_date ben_cvg_amt_calc_mthd_f.effective_start_date%TYPE;
84: l_effective_end_date ben_cvg_amt_calc_mthd_f.effective_end_date%TYPE;
85: l_proc varchar2(72) := g_package||'create_Cvg_Amt_Calc';
86: l_object_version_number ben_cvg_amt_calc_mthd_f.object_version_number%TYPE;
79: --
80: -- Declare cursors and local variables
81: --
82: l_cvg_amt_calc_mthd_id ben_cvg_amt_calc_mthd_f.cvg_amt_calc_mthd_id%TYPE;
83: l_effective_start_date ben_cvg_amt_calc_mthd_f.effective_start_date%TYPE;
84: l_effective_end_date ben_cvg_amt_calc_mthd_f.effective_end_date%TYPE;
85: l_proc varchar2(72) := g_package||'create_Cvg_Amt_Calc';
86: l_object_version_number ben_cvg_amt_calc_mthd_f.object_version_number%TYPE;
87: --
80: -- Declare cursors and local variables
81: --
82: l_cvg_amt_calc_mthd_id ben_cvg_amt_calc_mthd_f.cvg_amt_calc_mthd_id%TYPE;
83: l_effective_start_date ben_cvg_amt_calc_mthd_f.effective_start_date%TYPE;
84: l_effective_end_date ben_cvg_amt_calc_mthd_f.effective_end_date%TYPE;
85: l_proc varchar2(72) := g_package||'create_Cvg_Amt_Calc';
86: l_object_version_number ben_cvg_amt_calc_mthd_f.object_version_number%TYPE;
87: --
88: begin
82: l_cvg_amt_calc_mthd_id ben_cvg_amt_calc_mthd_f.cvg_amt_calc_mthd_id%TYPE;
83: l_effective_start_date ben_cvg_amt_calc_mthd_f.effective_start_date%TYPE;
84: l_effective_end_date ben_cvg_amt_calc_mthd_f.effective_end_date%TYPE;
85: l_proc varchar2(72) := g_package||'create_Cvg_Amt_Calc';
86: l_object_version_number ben_cvg_amt_calc_mthd_f.object_version_number%TYPE;
87: --
88: begin
89: --
90: hr_utility.set_location('Entering:'|| l_proc, 10);
450: --
451: -- Declare cursors and local variables
452: --
453: l_proc varchar2(72) := g_package||'update_Cvg_Amt_Calc';
454: l_object_version_number ben_cvg_amt_calc_mthd_f.object_version_number%TYPE;
455: l_effective_start_date ben_cvg_amt_calc_mthd_f.effective_start_date%TYPE;
456: l_effective_end_date ben_cvg_amt_calc_mthd_f.effective_end_date%TYPE;
457: --
458: begin
451: -- Declare cursors and local variables
452: --
453: l_proc varchar2(72) := g_package||'update_Cvg_Amt_Calc';
454: l_object_version_number ben_cvg_amt_calc_mthd_f.object_version_number%TYPE;
455: l_effective_start_date ben_cvg_amt_calc_mthd_f.effective_start_date%TYPE;
456: l_effective_end_date ben_cvg_amt_calc_mthd_f.effective_end_date%TYPE;
457: --
458: begin
459: --
452: --
453: l_proc varchar2(72) := g_package||'update_Cvg_Amt_Calc';
454: l_object_version_number ben_cvg_amt_calc_mthd_f.object_version_number%TYPE;
455: l_effective_start_date ben_cvg_amt_calc_mthd_f.effective_start_date%TYPE;
456: l_effective_end_date ben_cvg_amt_calc_mthd_f.effective_end_date%TYPE;
457: --
458: begin
459: --
460: hr_utility.set_location('Entering:'|| l_proc, 10);
762: --
763: -- Declare cursors and local variables
764: --
765: l_proc varchar2(72) := g_package||'update_Cvg_Amt_Calc';
766: l_object_version_number ben_cvg_amt_calc_mthd_f.object_version_number%TYPE;
767: l_effective_start_date ben_cvg_amt_calc_mthd_f.effective_start_date%TYPE;
768: l_effective_end_date ben_cvg_amt_calc_mthd_f.effective_end_date%TYPE;
769: --
770: begin
763: -- Declare cursors and local variables
764: --
765: l_proc varchar2(72) := g_package||'update_Cvg_Amt_Calc';
766: l_object_version_number ben_cvg_amt_calc_mthd_f.object_version_number%TYPE;
767: l_effective_start_date ben_cvg_amt_calc_mthd_f.effective_start_date%TYPE;
768: l_effective_end_date ben_cvg_amt_calc_mthd_f.effective_end_date%TYPE;
769: --
770: begin
771: --
764: --
765: l_proc varchar2(72) := g_package||'update_Cvg_Amt_Calc';
766: l_object_version_number ben_cvg_amt_calc_mthd_f.object_version_number%TYPE;
767: l_effective_start_date ben_cvg_amt_calc_mthd_f.effective_start_date%TYPE;
768: l_effective_end_date ben_cvg_amt_calc_mthd_f.effective_end_date%TYPE;
769: --
770: begin
771: --
772: hr_utility.set_location('Entering:'|| l_proc, 10);