57: ) is
58: --
59: -- Declare cursors and local variables
60: --
61: l_elig_stdnt_stat_cvg_id ben_elig_stdnt_stat_cvg_f.elig_stdnt_stat_cvg_id%TYPE;
62: l_effective_start_date ben_elig_stdnt_stat_cvg_f.effective_start_date%TYPE;
63: l_effective_end_date ben_elig_stdnt_stat_cvg_f.effective_end_date%TYPE;
64: l_proc varchar2(72) := g_package||'create_ELIG_STDNT_STAT_CVG';
65: l_object_version_number ben_elig_stdnt_stat_cvg_f.object_version_number%TYPE;
58: --
59: -- Declare cursors and local variables
60: --
61: l_elig_stdnt_stat_cvg_id ben_elig_stdnt_stat_cvg_f.elig_stdnt_stat_cvg_id%TYPE;
62: l_effective_start_date ben_elig_stdnt_stat_cvg_f.effective_start_date%TYPE;
63: l_effective_end_date ben_elig_stdnt_stat_cvg_f.effective_end_date%TYPE;
64: l_proc varchar2(72) := g_package||'create_ELIG_STDNT_STAT_CVG';
65: l_object_version_number ben_elig_stdnt_stat_cvg_f.object_version_number%TYPE;
66: --
59: -- Declare cursors and local variables
60: --
61: l_elig_stdnt_stat_cvg_id ben_elig_stdnt_stat_cvg_f.elig_stdnt_stat_cvg_id%TYPE;
62: l_effective_start_date ben_elig_stdnt_stat_cvg_f.effective_start_date%TYPE;
63: l_effective_end_date ben_elig_stdnt_stat_cvg_f.effective_end_date%TYPE;
64: l_proc varchar2(72) := g_package||'create_ELIG_STDNT_STAT_CVG';
65: l_object_version_number ben_elig_stdnt_stat_cvg_f.object_version_number%TYPE;
66: --
67: begin
61: l_elig_stdnt_stat_cvg_id ben_elig_stdnt_stat_cvg_f.elig_stdnt_stat_cvg_id%TYPE;
62: l_effective_start_date ben_elig_stdnt_stat_cvg_f.effective_start_date%TYPE;
63: l_effective_end_date ben_elig_stdnt_stat_cvg_f.effective_end_date%TYPE;
64: l_proc varchar2(72) := g_package||'create_ELIG_STDNT_STAT_CVG';
65: l_object_version_number ben_elig_stdnt_stat_cvg_f.object_version_number%TYPE;
66: --
67: begin
68: --
69: hr_utility.set_location('Entering:'|| l_proc, 10);
249: p_base_table => 'BEN_DPNT_CVG_ELIGY_PRFL_F',
250: p_base_table_column => 'DPNT_CVG_ELIGY_PRFL_ID',
251: p_base_table_column_value => p_dpnt_cvg_eligy_prfl_id,
252: p_base_table_reference_column => 'DPNT_STUD_FLAG',
253: p_reference_table => 'BEN_ELIG_STDNT_STAT_CVG_F',
254: p_reference_table_column => 'DPNT_CVG_ELIGY_PRFL_ID');
255: --
256:
257: -- When in validation only mode raise the Validate_Enabled exception
355: --
356: -- Declare cursors and local variables
357: --
358: l_proc varchar2(72) := g_package||'update_ELIG_STDNT_STAT_CVG';
359: l_object_version_number ben_elig_stdnt_stat_cvg_f.object_version_number%TYPE;
360: l_effective_start_date ben_elig_stdnt_stat_cvg_f.effective_start_date%TYPE;
361: l_effective_end_date ben_elig_stdnt_stat_cvg_f.effective_end_date%TYPE;
362: --
363: begin
356: -- Declare cursors and local variables
357: --
358: l_proc varchar2(72) := g_package||'update_ELIG_STDNT_STAT_CVG';
359: l_object_version_number ben_elig_stdnt_stat_cvg_f.object_version_number%TYPE;
360: l_effective_start_date ben_elig_stdnt_stat_cvg_f.effective_start_date%TYPE;
361: l_effective_end_date ben_elig_stdnt_stat_cvg_f.effective_end_date%TYPE;
362: --
363: begin
364: --
357: --
358: l_proc varchar2(72) := g_package||'update_ELIG_STDNT_STAT_CVG';
359: l_object_version_number ben_elig_stdnt_stat_cvg_f.object_version_number%TYPE;
360: l_effective_start_date ben_elig_stdnt_stat_cvg_f.effective_start_date%TYPE;
361: l_effective_end_date ben_elig_stdnt_stat_cvg_f.effective_end_date%TYPE;
362: --
363: begin
364: --
365: hr_utility.set_location('Entering:'|| l_proc, 10);
602: --
603: -- Declare cursors and local variables
604: --
605: l_proc varchar2(72) := g_package||'update_ELIG_STDNT_STAT_CVG';
606: l_object_version_number ben_elig_stdnt_stat_cvg_f.object_version_number%TYPE;
607: l_effective_start_date ben_elig_stdnt_stat_cvg_f.effective_start_date%TYPE;
608: l_effective_end_date ben_elig_stdnt_stat_cvg_f.effective_end_date%TYPE;
609: --
610: begin
603: -- Declare cursors and local variables
604: --
605: l_proc varchar2(72) := g_package||'update_ELIG_STDNT_STAT_CVG';
606: l_object_version_number ben_elig_stdnt_stat_cvg_f.object_version_number%TYPE;
607: l_effective_start_date ben_elig_stdnt_stat_cvg_f.effective_start_date%TYPE;
608: l_effective_end_date ben_elig_stdnt_stat_cvg_f.effective_end_date%TYPE;
609: --
610: begin
611: --
604: --
605: l_proc varchar2(72) := g_package||'update_ELIG_STDNT_STAT_CVG';
606: l_object_version_number ben_elig_stdnt_stat_cvg_f.object_version_number%TYPE;
607: l_effective_start_date ben_elig_stdnt_stat_cvg_f.effective_start_date%TYPE;
608: l_effective_end_date ben_elig_stdnt_stat_cvg_f.effective_end_date%TYPE;
609: --
610: begin
611: --
612: hr_utility.set_location('Entering:'|| l_proc, 10);
685: p_base_table => 'BEN_DPNT_CVG_ELIGY_PRFL_F',
686: p_base_table_column => 'DPNT_CVG_ELIGY_PRFL_ID',
687: p_base_table_column_value => ben_esc_shd.g_old_rec.dpnt_cvg_eligy_prfl_id,
688: p_base_table_reference_column => 'DPNT_STUD_FLAG',
689: p_reference_table => 'BEN_ELIG_STDNT_STAT_CVG_F',
690: p_reference_table_column => 'DPNT_CVG_ELIGY_PRFL_ID');
691: --
692: -- When in validation only mode raise the Validate_Enabled exception
693: --