66: ) is
67: --
68: -- Declare cursors and local variables
69: --
70: l_dpnt_cvg_eligy_prfl_id ben_dpnt_cvg_eligy_prfl_f.dpnt_cvg_eligy_prfl_id%TYPE;
71: l_effective_end_date ben_dpnt_cvg_eligy_prfl_f.effective_end_date%TYPE;
72: l_effective_start_date ben_dpnt_cvg_eligy_prfl_f.effective_start_date%TYPE;
73: l_proc varchar2(72) := g_package||'create_DPNT_CVG_ELIG_PRFL';
74: l_object_version_number ben_dpnt_cvg_eligy_prfl_f.object_version_number%TYPE;
67: --
68: -- Declare cursors and local variables
69: --
70: l_dpnt_cvg_eligy_prfl_id ben_dpnt_cvg_eligy_prfl_f.dpnt_cvg_eligy_prfl_id%TYPE;
71: l_effective_end_date ben_dpnt_cvg_eligy_prfl_f.effective_end_date%TYPE;
72: l_effective_start_date ben_dpnt_cvg_eligy_prfl_f.effective_start_date%TYPE;
73: l_proc varchar2(72) := g_package||'create_DPNT_CVG_ELIG_PRFL';
74: l_object_version_number ben_dpnt_cvg_eligy_prfl_f.object_version_number%TYPE;
75: --
68: -- Declare cursors and local variables
69: --
70: l_dpnt_cvg_eligy_prfl_id ben_dpnt_cvg_eligy_prfl_f.dpnt_cvg_eligy_prfl_id%TYPE;
71: l_effective_end_date ben_dpnt_cvg_eligy_prfl_f.effective_end_date%TYPE;
72: l_effective_start_date ben_dpnt_cvg_eligy_prfl_f.effective_start_date%TYPE;
73: l_proc varchar2(72) := g_package||'create_DPNT_CVG_ELIG_PRFL';
74: l_object_version_number ben_dpnt_cvg_eligy_prfl_f.object_version_number%TYPE;
75: --
76: begin
70: l_dpnt_cvg_eligy_prfl_id ben_dpnt_cvg_eligy_prfl_f.dpnt_cvg_eligy_prfl_id%TYPE;
71: l_effective_end_date ben_dpnt_cvg_eligy_prfl_f.effective_end_date%TYPE;
72: l_effective_start_date ben_dpnt_cvg_eligy_prfl_f.effective_start_date%TYPE;
73: l_proc varchar2(72) := g_package||'create_DPNT_CVG_ELIG_PRFL';
74: l_object_version_number ben_dpnt_cvg_eligy_prfl_f.object_version_number%TYPE;
75: --
76: begin
77: --
78: hr_utility.set_location('Entering:'|| l_proc, 10);
390: --
391: -- Declare cursors and local variables
392: --
393: l_proc varchar2(72) := g_package||'update_DPNT_CVG_ELIG_PRFL';
394: l_object_version_number ben_dpnt_cvg_eligy_prfl_f.object_version_number%TYPE;
395: l_effective_end_date ben_dpnt_cvg_eligy_prfl_f.effective_end_date%TYPE;
396: l_effective_start_date ben_dpnt_cvg_eligy_prfl_f.effective_start_date%TYPE;
397: --
398: begin
391: -- Declare cursors and local variables
392: --
393: l_proc varchar2(72) := g_package||'update_DPNT_CVG_ELIG_PRFL';
394: l_object_version_number ben_dpnt_cvg_eligy_prfl_f.object_version_number%TYPE;
395: l_effective_end_date ben_dpnt_cvg_eligy_prfl_f.effective_end_date%TYPE;
396: l_effective_start_date ben_dpnt_cvg_eligy_prfl_f.effective_start_date%TYPE;
397: --
398: begin
399: --
392: --
393: l_proc varchar2(72) := g_package||'update_DPNT_CVG_ELIG_PRFL';
394: l_object_version_number ben_dpnt_cvg_eligy_prfl_f.object_version_number%TYPE;
395: l_effective_end_date ben_dpnt_cvg_eligy_prfl_f.effective_end_date%TYPE;
396: l_effective_start_date ben_dpnt_cvg_eligy_prfl_f.effective_start_date%TYPE;
397: --
398: begin
399: --
400: hr_utility.set_location('Entering:'|| l_proc, 10);
665: --
666: -- Declare cursors and local variables
667: --
668: l_proc varchar2(72) := g_package||'update_DPNT_CVG_ELIG_PRFL';
669: l_object_version_number ben_dpnt_cvg_eligy_prfl_f.object_version_number%TYPE;
670: l_effective_end_date ben_dpnt_cvg_eligy_prfl_f.effective_end_date%TYPE;
671: l_effective_start_date ben_dpnt_cvg_eligy_prfl_f.effective_start_date%TYPE;
672: --
673: begin
666: -- Declare cursors and local variables
667: --
668: l_proc varchar2(72) := g_package||'update_DPNT_CVG_ELIG_PRFL';
669: l_object_version_number ben_dpnt_cvg_eligy_prfl_f.object_version_number%TYPE;
670: l_effective_end_date ben_dpnt_cvg_eligy_prfl_f.effective_end_date%TYPE;
671: l_effective_start_date ben_dpnt_cvg_eligy_prfl_f.effective_start_date%TYPE;
672: --
673: begin
674: --
667: --
668: l_proc varchar2(72) := g_package||'update_DPNT_CVG_ELIG_PRFL';
669: l_object_version_number ben_dpnt_cvg_eligy_prfl_f.object_version_number%TYPE;
670: l_effective_end_date ben_dpnt_cvg_eligy_prfl_f.effective_end_date%TYPE;
671: l_effective_start_date ben_dpnt_cvg_eligy_prfl_f.effective_start_date%TYPE;
672: --
673: begin
674: --
675: hr_utility.set_location('Entering:'|| l_proc, 10);