65: ) is
66: --
67: -- Declare cursors and local variables
68: --
69: l_dpnt_cvg_eligy_prfl_id ben_dpnt_cvg_eligy_prfl_f.dpnt_cvg_eligy_prfl_id%TYPE;
70: l_effective_end_date ben_dpnt_cvg_eligy_prfl_f.effective_end_date%TYPE;
71: l_effective_start_date ben_dpnt_cvg_eligy_prfl_f.effective_start_date%TYPE;
72: l_proc varchar2(72) := g_package||'create_DPNT_CVG_ELIG_PRFL';
73: l_object_version_number ben_dpnt_cvg_eligy_prfl_f.object_version_number%TYPE;
66: --
67: -- Declare cursors and local variables
68: --
69: l_dpnt_cvg_eligy_prfl_id ben_dpnt_cvg_eligy_prfl_f.dpnt_cvg_eligy_prfl_id%TYPE;
70: l_effective_end_date ben_dpnt_cvg_eligy_prfl_f.effective_end_date%TYPE;
71: l_effective_start_date ben_dpnt_cvg_eligy_prfl_f.effective_start_date%TYPE;
72: l_proc varchar2(72) := g_package||'create_DPNT_CVG_ELIG_PRFL';
73: l_object_version_number ben_dpnt_cvg_eligy_prfl_f.object_version_number%TYPE;
74: --
67: -- Declare cursors and local variables
68: --
69: l_dpnt_cvg_eligy_prfl_id ben_dpnt_cvg_eligy_prfl_f.dpnt_cvg_eligy_prfl_id%TYPE;
70: l_effective_end_date ben_dpnt_cvg_eligy_prfl_f.effective_end_date%TYPE;
71: l_effective_start_date ben_dpnt_cvg_eligy_prfl_f.effective_start_date%TYPE;
72: l_proc varchar2(72) := g_package||'create_DPNT_CVG_ELIG_PRFL';
73: l_object_version_number ben_dpnt_cvg_eligy_prfl_f.object_version_number%TYPE;
74: --
75: begin
69: l_dpnt_cvg_eligy_prfl_id ben_dpnt_cvg_eligy_prfl_f.dpnt_cvg_eligy_prfl_id%TYPE;
70: l_effective_end_date ben_dpnt_cvg_eligy_prfl_f.effective_end_date%TYPE;
71: l_effective_start_date ben_dpnt_cvg_eligy_prfl_f.effective_start_date%TYPE;
72: l_proc varchar2(72) := g_package||'create_DPNT_CVG_ELIG_PRFL';
73: l_object_version_number ben_dpnt_cvg_eligy_prfl_f.object_version_number%TYPE;
74: --
75: begin
76: --
77: hr_utility.set_location('Entering:'|| l_proc, 10);
385: --
386: -- Declare cursors and local variables
387: --
388: l_proc varchar2(72) := g_package||'update_DPNT_CVG_ELIG_PRFL';
389: l_object_version_number ben_dpnt_cvg_eligy_prfl_f.object_version_number%TYPE;
390: l_effective_end_date ben_dpnt_cvg_eligy_prfl_f.effective_end_date%TYPE;
391: l_effective_start_date ben_dpnt_cvg_eligy_prfl_f.effective_start_date%TYPE;
392: --
393: begin
386: -- Declare cursors and local variables
387: --
388: l_proc varchar2(72) := g_package||'update_DPNT_CVG_ELIG_PRFL';
389: l_object_version_number ben_dpnt_cvg_eligy_prfl_f.object_version_number%TYPE;
390: l_effective_end_date ben_dpnt_cvg_eligy_prfl_f.effective_end_date%TYPE;
391: l_effective_start_date ben_dpnt_cvg_eligy_prfl_f.effective_start_date%TYPE;
392: --
393: begin
394: --
387: --
388: l_proc varchar2(72) := g_package||'update_DPNT_CVG_ELIG_PRFL';
389: l_object_version_number ben_dpnt_cvg_eligy_prfl_f.object_version_number%TYPE;
390: l_effective_end_date ben_dpnt_cvg_eligy_prfl_f.effective_end_date%TYPE;
391: l_effective_start_date ben_dpnt_cvg_eligy_prfl_f.effective_start_date%TYPE;
392: --
393: begin
394: --
395: hr_utility.set_location('Entering:'|| l_proc, 10);
657: --
658: -- Declare cursors and local variables
659: --
660: l_proc varchar2(72) := g_package||'update_DPNT_CVG_ELIG_PRFL';
661: l_object_version_number ben_dpnt_cvg_eligy_prfl_f.object_version_number%TYPE;
662: l_effective_end_date ben_dpnt_cvg_eligy_prfl_f.effective_end_date%TYPE;
663: l_effective_start_date ben_dpnt_cvg_eligy_prfl_f.effective_start_date%TYPE;
664: --
665: begin
658: -- Declare cursors and local variables
659: --
660: l_proc varchar2(72) := g_package||'update_DPNT_CVG_ELIG_PRFL';
661: l_object_version_number ben_dpnt_cvg_eligy_prfl_f.object_version_number%TYPE;
662: l_effective_end_date ben_dpnt_cvg_eligy_prfl_f.effective_end_date%TYPE;
663: l_effective_start_date ben_dpnt_cvg_eligy_prfl_f.effective_start_date%TYPE;
664: --
665: begin
666: --
659: --
660: l_proc varchar2(72) := g_package||'update_DPNT_CVG_ELIG_PRFL';
661: l_object_version_number ben_dpnt_cvg_eligy_prfl_f.object_version_number%TYPE;
662: l_effective_end_date ben_dpnt_cvg_eligy_prfl_f.effective_end_date%TYPE;
663: l_effective_start_date ben_dpnt_cvg_eligy_prfl_f.effective_start_date%TYPE;
664: --
665: begin
666: --
667: hr_utility.set_location('Entering:'|| l_proc, 10);