57: ) is
58: --
59: -- Declare cursors and local variables
60: --
61: l_elig_dsbld_stat_cvg_id ben_elig_dsbld_stat_cvg_f.elig_dsbld_stat_cvg_id%TYPE;
62: l_effective_start_date ben_elig_dsbld_stat_cvg_f.effective_start_date%TYPE;
63: l_effective_end_date ben_elig_dsbld_stat_cvg_f.effective_end_date%TYPE;
64: l_proc varchar2(72) := g_package||'create_ELIG_DSBLD_STAT_CVG';
65: l_object_version_number ben_elig_dsbld_stat_cvg_f.object_version_number%TYPE;
58: --
59: -- Declare cursors and local variables
60: --
61: l_elig_dsbld_stat_cvg_id ben_elig_dsbld_stat_cvg_f.elig_dsbld_stat_cvg_id%TYPE;
62: l_effective_start_date ben_elig_dsbld_stat_cvg_f.effective_start_date%TYPE;
63: l_effective_end_date ben_elig_dsbld_stat_cvg_f.effective_end_date%TYPE;
64: l_proc varchar2(72) := g_package||'create_ELIG_DSBLD_STAT_CVG';
65: l_object_version_number ben_elig_dsbld_stat_cvg_f.object_version_number%TYPE;
66: --
59: -- Declare cursors and local variables
60: --
61: l_elig_dsbld_stat_cvg_id ben_elig_dsbld_stat_cvg_f.elig_dsbld_stat_cvg_id%TYPE;
62: l_effective_start_date ben_elig_dsbld_stat_cvg_f.effective_start_date%TYPE;
63: l_effective_end_date ben_elig_dsbld_stat_cvg_f.effective_end_date%TYPE;
64: l_proc varchar2(72) := g_package||'create_ELIG_DSBLD_STAT_CVG';
65: l_object_version_number ben_elig_dsbld_stat_cvg_f.object_version_number%TYPE;
66: --
67: begin
61: l_elig_dsbld_stat_cvg_id ben_elig_dsbld_stat_cvg_f.elig_dsbld_stat_cvg_id%TYPE;
62: l_effective_start_date ben_elig_dsbld_stat_cvg_f.effective_start_date%TYPE;
63: l_effective_end_date ben_elig_dsbld_stat_cvg_f.effective_end_date%TYPE;
64: l_proc varchar2(72) := g_package||'create_ELIG_DSBLD_STAT_CVG';
65: l_object_version_number ben_elig_dsbld_stat_cvg_f.object_version_number%TYPE;
66: --
67: begin
68: --
69: hr_utility.set_location('Entering:'|| l_proc, 10);
247: p_base_table => 'BEN_DPNT_CVG_ELIGY_PRFL_F',
248: p_base_table_column => 'DPNT_CVG_ELIGY_PRFL_ID',
249: p_base_table_column_value => p_dpnt_cvg_eligy_prfl_id,
250: p_base_table_reference_column => 'DPNT_DSBLD_FLAG',
251: p_reference_table => 'BEN_ELIG_DSBLD_STAT_CVG_F',
252: p_reference_table_column => 'DPNT_CVG_ELIGY_PRFL_ID');
253: --
254:
255: hr_utility.set_location(l_proc, 60);
356: --
357: -- Declare cursors and local variables
358: --
359: l_proc varchar2(72) := g_package||'update_ELIG_DSBLD_STAT_CVG';
360: l_object_version_number ben_elig_dsbld_stat_cvg_f.object_version_number%TYPE;
361: l_effective_start_date ben_elig_dsbld_stat_cvg_f.effective_start_date%TYPE;
362: l_effective_end_date ben_elig_dsbld_stat_cvg_f.effective_end_date%TYPE;
363: --
364: begin
357: -- Declare cursors and local variables
358: --
359: l_proc varchar2(72) := g_package||'update_ELIG_DSBLD_STAT_CVG';
360: l_object_version_number ben_elig_dsbld_stat_cvg_f.object_version_number%TYPE;
361: l_effective_start_date ben_elig_dsbld_stat_cvg_f.effective_start_date%TYPE;
362: l_effective_end_date ben_elig_dsbld_stat_cvg_f.effective_end_date%TYPE;
363: --
364: begin
365: --
358: --
359: l_proc varchar2(72) := g_package||'update_ELIG_DSBLD_STAT_CVG';
360: l_object_version_number ben_elig_dsbld_stat_cvg_f.object_version_number%TYPE;
361: l_effective_start_date ben_elig_dsbld_stat_cvg_f.effective_start_date%TYPE;
362: l_effective_end_date ben_elig_dsbld_stat_cvg_f.effective_end_date%TYPE;
363: --
364: begin
365: --
366: hr_utility.set_location('Entering:'|| l_proc, 10);
605: --
606: -- Declare cursors and local variables
607: --
608: l_proc varchar2(72) := g_package||'update_ELIG_DSBLD_STAT_CVG';
609: l_object_version_number ben_elig_dsbld_stat_cvg_f.object_version_number%TYPE;
610: l_effective_start_date ben_elig_dsbld_stat_cvg_f.effective_start_date%TYPE;
611: l_effective_end_date ben_elig_dsbld_stat_cvg_f.effective_end_date%TYPE;
612: --
613: begin
606: -- Declare cursors and local variables
607: --
608: l_proc varchar2(72) := g_package||'update_ELIG_DSBLD_STAT_CVG';
609: l_object_version_number ben_elig_dsbld_stat_cvg_f.object_version_number%TYPE;
610: l_effective_start_date ben_elig_dsbld_stat_cvg_f.effective_start_date%TYPE;
611: l_effective_end_date ben_elig_dsbld_stat_cvg_f.effective_end_date%TYPE;
612: --
613: begin
614: --
607: --
608: l_proc varchar2(72) := g_package||'update_ELIG_DSBLD_STAT_CVG';
609: l_object_version_number ben_elig_dsbld_stat_cvg_f.object_version_number%TYPE;
610: l_effective_start_date ben_elig_dsbld_stat_cvg_f.effective_start_date%TYPE;
611: l_effective_end_date ben_elig_dsbld_stat_cvg_f.effective_end_date%TYPE;
612: --
613: begin
614: --
615: hr_utility.set_location('Entering:'|| l_proc, 10);
686: p_base_table => 'BEN_DPNT_CVG_ELIGY_PRFL_F',
687: p_base_table_column => 'DPNT_CVG_ELIGY_PRFL_ID',
688: p_base_table_column_value => ben_edc_shd.g_old_rec.dpnt_cvg_eligy_prfl_id,
689: p_base_table_reference_column => 'DPNT_DSBLD_FLAG',
690: p_reference_table => 'BEN_ELIG_DSBLD_STAT_CVG_F',
691: p_reference_table_column => 'DPNT_CVG_ELIGY_PRFL_ID');
692: --
693: hr_utility.set_location(l_proc, 60);
694: --