56: ) is
57: --
58: -- Declare cursors and local variables
59: --
60: l_ELIG_HLTH_CVG_PRTE_id ben_ELIG_HLTH_CVG_PRTE_f.ELIG_HLTH_CVG_PRTE_id%TYPE;
61: l_effective_start_date ben_ELIG_HLTH_CVG_PRTE_f.effective_start_date%TYPE;
62: l_effective_end_date ben_ELIG_HLTH_CVG_PRTE_f.effective_end_date%TYPE;
63: l_proc varchar2(72) := g_package||'create_ELIG_HLTH_CVG_PRTE';
64: l_object_version_number ben_ELIG_HLTH_CVG_PRTE_f.object_version_number%TYPE;
57: --
58: -- Declare cursors and local variables
59: --
60: l_ELIG_HLTH_CVG_PRTE_id ben_ELIG_HLTH_CVG_PRTE_f.ELIG_HLTH_CVG_PRTE_id%TYPE;
61: l_effective_start_date ben_ELIG_HLTH_CVG_PRTE_f.effective_start_date%TYPE;
62: l_effective_end_date ben_ELIG_HLTH_CVG_PRTE_f.effective_end_date%TYPE;
63: l_proc varchar2(72) := g_package||'create_ELIG_HLTH_CVG_PRTE';
64: l_object_version_number ben_ELIG_HLTH_CVG_PRTE_f.object_version_number%TYPE;
65: --
58: -- Declare cursors and local variables
59: --
60: l_ELIG_HLTH_CVG_PRTE_id ben_ELIG_HLTH_CVG_PRTE_f.ELIG_HLTH_CVG_PRTE_id%TYPE;
61: l_effective_start_date ben_ELIG_HLTH_CVG_PRTE_f.effective_start_date%TYPE;
62: l_effective_end_date ben_ELIG_HLTH_CVG_PRTE_f.effective_end_date%TYPE;
63: l_proc varchar2(72) := g_package||'create_ELIG_HLTH_CVG_PRTE';
64: l_object_version_number ben_ELIG_HLTH_CVG_PRTE_f.object_version_number%TYPE;
65: --
66: begin
60: l_ELIG_HLTH_CVG_PRTE_id ben_ELIG_HLTH_CVG_PRTE_f.ELIG_HLTH_CVG_PRTE_id%TYPE;
61: l_effective_start_date ben_ELIG_HLTH_CVG_PRTE_f.effective_start_date%TYPE;
62: l_effective_end_date ben_ELIG_HLTH_CVG_PRTE_f.effective_end_date%TYPE;
63: l_proc varchar2(72) := g_package||'create_ELIG_HLTH_CVG_PRTE';
64: l_object_version_number ben_ELIG_HLTH_CVG_PRTE_f.object_version_number%TYPE;
65: --
66: begin
67: --
68: hr_utility.set_location('Entering:'|| l_proc, 10);
246: p_base_table => 'BEN_ELIGY_PRFL_F',
247: p_base_table_column => 'ELIGY_PRFL_ID',
248: p_base_table_column_value => p_eligy_prfl_id,
249: p_base_table_reference_column => 'ELIG_HLTH_CVG_FLAG',
250: p_reference_table => 'BEN_ELIG_HLTH_CVG_PRTE_F',
251: p_reference_table_column => 'ELIGY_PRFL_ID');
252: --
253: hr_utility.set_location(l_proc, 60);
254: --
352: --
353: -- Declare cursors and local variables
354: --
355: l_proc varchar2(72) := g_package||'update_ELIG_HLTH_CVG_PRTE';
356: l_object_version_number ben_ELIG_HLTH_CVG_PRTE_f.object_version_number%TYPE;
357: l_effective_start_date ben_ELIG_HLTH_CVG_PRTE_f.effective_start_date%TYPE;
358: l_effective_end_date ben_ELIG_HLTH_CVG_PRTE_f.effective_end_date%TYPE;
359: --
360: begin
353: -- Declare cursors and local variables
354: --
355: l_proc varchar2(72) := g_package||'update_ELIG_HLTH_CVG_PRTE';
356: l_object_version_number ben_ELIG_HLTH_CVG_PRTE_f.object_version_number%TYPE;
357: l_effective_start_date ben_ELIG_HLTH_CVG_PRTE_f.effective_start_date%TYPE;
358: l_effective_end_date ben_ELIG_HLTH_CVG_PRTE_f.effective_end_date%TYPE;
359: --
360: begin
361: --
354: --
355: l_proc varchar2(72) := g_package||'update_ELIG_HLTH_CVG_PRTE';
356: l_object_version_number ben_ELIG_HLTH_CVG_PRTE_f.object_version_number%TYPE;
357: l_effective_start_date ben_ELIG_HLTH_CVG_PRTE_f.effective_start_date%TYPE;
358: l_effective_end_date ben_ELIG_HLTH_CVG_PRTE_f.effective_end_date%TYPE;
359: --
360: begin
361: --
362: hr_utility.set_location('Entering:'|| l_proc, 10);
597: --
598: -- Declare cursors and local variables
599: --
600: l_proc varchar2(72) := g_package||'update_ELIG_HLTH_CVG_PRTE';
601: l_object_version_number ben_ELIG_HLTH_CVG_PRTE_f.object_version_number%TYPE;
602: l_effective_start_date ben_ELIG_HLTH_CVG_PRTE_f.effective_start_date%TYPE;
603: l_effective_end_date ben_ELIG_HLTH_CVG_PRTE_f.effective_end_date%TYPE;
604: --
605: begin
598: -- Declare cursors and local variables
599: --
600: l_proc varchar2(72) := g_package||'update_ELIG_HLTH_CVG_PRTE';
601: l_object_version_number ben_ELIG_HLTH_CVG_PRTE_f.object_version_number%TYPE;
602: l_effective_start_date ben_ELIG_HLTH_CVG_PRTE_f.effective_start_date%TYPE;
603: l_effective_end_date ben_ELIG_HLTH_CVG_PRTE_f.effective_end_date%TYPE;
604: --
605: begin
606: --
599: --
600: l_proc varchar2(72) := g_package||'update_ELIG_HLTH_CVG_PRTE';
601: l_object_version_number ben_ELIG_HLTH_CVG_PRTE_f.object_version_number%TYPE;
602: l_effective_start_date ben_ELIG_HLTH_CVG_PRTE_f.effective_start_date%TYPE;
603: l_effective_end_date ben_ELIG_HLTH_CVG_PRTE_f.effective_end_date%TYPE;
604: --
605: begin
606: --
607: hr_utility.set_location('Entering:'|| l_proc, 10);
678: p_base_table => 'BEN_ELIGY_PRFL_F',
679: p_base_table_column => 'ELIGY_PRFL_ID',
680: p_base_table_column_value => ben_ehc_shd.g_old_rec.eligy_prfl_id,
681: p_base_table_reference_column => 'ELIG_HLTH_CVG_FLAG',
682: p_reference_table => 'BEN_ELIG_HLTH_CVG_PRTE_F',
683: p_reference_table_column => 'ELIGY_PRFL_ID');
684: --
685: hr_utility.set_location(l_proc, 60);
686: --