56: ) is
57: --
58: -- Declare cursors and local variables
59: --
60: l_elig_enrld_anthr_pgm_id ben_elig_enrld_anthr_pgm_f.elig_enrld_anthr_pgm_id%TYPE;
61: l_effective_start_date ben_elig_enrld_anthr_pgm_f.effective_start_date%TYPE;
62: l_effective_end_date ben_elig_enrld_anthr_pgm_f.effective_end_date%TYPE;
63: l_proc varchar2(72) := g_package||'create_ELIG_ENRLD_ANTHR_PGM';
64: l_object_version_number ben_elig_enrld_anthr_pgm_f.object_version_number%TYPE;
57: --
58: -- Declare cursors and local variables
59: --
60: l_elig_enrld_anthr_pgm_id ben_elig_enrld_anthr_pgm_f.elig_enrld_anthr_pgm_id%TYPE;
61: l_effective_start_date ben_elig_enrld_anthr_pgm_f.effective_start_date%TYPE;
62: l_effective_end_date ben_elig_enrld_anthr_pgm_f.effective_end_date%TYPE;
63: l_proc varchar2(72) := g_package||'create_ELIG_ENRLD_ANTHR_PGM';
64: l_object_version_number ben_elig_enrld_anthr_pgm_f.object_version_number%TYPE;
65: --
58: -- Declare cursors and local variables
59: --
60: l_elig_enrld_anthr_pgm_id ben_elig_enrld_anthr_pgm_f.elig_enrld_anthr_pgm_id%TYPE;
61: l_effective_start_date ben_elig_enrld_anthr_pgm_f.effective_start_date%TYPE;
62: l_effective_end_date ben_elig_enrld_anthr_pgm_f.effective_end_date%TYPE;
63: l_proc varchar2(72) := g_package||'create_ELIG_ENRLD_ANTHR_PGM';
64: l_object_version_number ben_elig_enrld_anthr_pgm_f.object_version_number%TYPE;
65: --
66: begin
60: l_elig_enrld_anthr_pgm_id ben_elig_enrld_anthr_pgm_f.elig_enrld_anthr_pgm_id%TYPE;
61: l_effective_start_date ben_elig_enrld_anthr_pgm_f.effective_start_date%TYPE;
62: l_effective_end_date ben_elig_enrld_anthr_pgm_f.effective_end_date%TYPE;
63: l_proc varchar2(72) := g_package||'create_ELIG_ENRLD_ANTHR_PGM';
64: l_object_version_number ben_elig_enrld_anthr_pgm_f.object_version_number%TYPE;
65: --
66: begin
67: --
68: hr_utility.set_location('Entering:'|| l_proc, 10);
243: p_base_table => 'BEN_ELIGY_PRFL_F',
244: p_base_table_column => 'ELIGY_PRFL_ID',
245: p_base_table_column_value => p_eligy_prfl_id,
246: p_base_table_reference_column => 'ELIG_ENRLD_PGM_FLAG',
247: p_reference_table => 'BEN_ELIG_ENRLD_ANTHR_PGM_F',
248: p_reference_table_column => 'ELIGY_PRFL_ID');
249: --
250: hr_utility.set_location(l_proc, 60);
251: --
344: --
345: -- Declare cursors and local variables
346: --
347: l_proc varchar2(72) := g_package||'update_ELIG_ENRLD_ANTHR_PGM';
348: l_object_version_number ben_elig_enrld_anthr_pgm_f.object_version_number%TYPE;
349: l_effective_start_date ben_elig_enrld_anthr_pgm_f.effective_start_date%TYPE;
350: l_effective_end_date ben_elig_enrld_anthr_pgm_f.effective_end_date%TYPE;
351: l_in_object_version_number number := p_object_version_number ;
352: --
345: -- Declare cursors and local variables
346: --
347: l_proc varchar2(72) := g_package||'update_ELIG_ENRLD_ANTHR_PGM';
348: l_object_version_number ben_elig_enrld_anthr_pgm_f.object_version_number%TYPE;
349: l_effective_start_date ben_elig_enrld_anthr_pgm_f.effective_start_date%TYPE;
350: l_effective_end_date ben_elig_enrld_anthr_pgm_f.effective_end_date%TYPE;
351: l_in_object_version_number number := p_object_version_number ;
352: --
353: begin
346: --
347: l_proc varchar2(72) := g_package||'update_ELIG_ENRLD_ANTHR_PGM';
348: l_object_version_number ben_elig_enrld_anthr_pgm_f.object_version_number%TYPE;
349: l_effective_start_date ben_elig_enrld_anthr_pgm_f.effective_start_date%TYPE;
350: l_effective_end_date ben_elig_enrld_anthr_pgm_f.effective_end_date%TYPE;
351: l_in_object_version_number number := p_object_version_number ;
352: --
353: begin
354: --
587: --
588: -- Declare cursors and local variables
589: --
590: l_proc varchar2(72) := g_package||'update_ELIG_ENRLD_ANTHR_PGM';
591: l_object_version_number ben_elig_enrld_anthr_pgm_f.object_version_number%TYPE;
592: l_effective_start_date ben_elig_enrld_anthr_pgm_f.effective_start_date%TYPE;
593: l_effective_end_date ben_elig_enrld_anthr_pgm_f.effective_end_date%TYPE;
594: l_in_object_version_number number := p_object_version_number ;
595: --
588: -- Declare cursors and local variables
589: --
590: l_proc varchar2(72) := g_package||'update_ELIG_ENRLD_ANTHR_PGM';
591: l_object_version_number ben_elig_enrld_anthr_pgm_f.object_version_number%TYPE;
592: l_effective_start_date ben_elig_enrld_anthr_pgm_f.effective_start_date%TYPE;
593: l_effective_end_date ben_elig_enrld_anthr_pgm_f.effective_end_date%TYPE;
594: l_in_object_version_number number := p_object_version_number ;
595: --
596: begin
589: --
590: l_proc varchar2(72) := g_package||'update_ELIG_ENRLD_ANTHR_PGM';
591: l_object_version_number ben_elig_enrld_anthr_pgm_f.object_version_number%TYPE;
592: l_effective_start_date ben_elig_enrld_anthr_pgm_f.effective_start_date%TYPE;
593: l_effective_end_date ben_elig_enrld_anthr_pgm_f.effective_end_date%TYPE;
594: l_in_object_version_number number := p_object_version_number ;
595: --
596: begin
597: --
669: p_base_table => 'BEN_ELIGY_PRFL_F',
670: p_base_table_column => 'ELIGY_PRFL_ID',
671: p_base_table_column_value => ben_eeg_shd.g_old_rec.eligy_prfl_id,
672: p_base_table_reference_column => 'ELIG_ENRLD_PGM_FLAG',
673: p_reference_table => 'BEN_ELIG_ENRLD_ANTHR_PGM_F',
674: p_reference_table_column => 'ELIGY_PRFL_ID');
675: --
676: hr_utility.set_location(l_proc, 60);
677: --