56: ) is
57: --
58: -- Declare cursors and local variables
59: --
60: l_enrld_anthr_pl_rt_id ben_enrld_anthr_pl_rt_f.enrld_anthr_pl_rt_id%TYPE;
61: l_effective_start_date ben_enrld_anthr_pl_rt_f.effective_start_date%TYPE;
62: l_effective_end_date ben_enrld_anthr_pl_rt_f.effective_end_date%TYPE;
63: l_proc varchar2(72) := g_package||'create_ENRLD_ANTHR_PL_RT';
64: l_object_version_number ben_enrld_anthr_pl_rt_f.object_version_number%TYPE;
57: --
58: -- Declare cursors and local variables
59: --
60: l_enrld_anthr_pl_rt_id ben_enrld_anthr_pl_rt_f.enrld_anthr_pl_rt_id%TYPE;
61: l_effective_start_date ben_enrld_anthr_pl_rt_f.effective_start_date%TYPE;
62: l_effective_end_date ben_enrld_anthr_pl_rt_f.effective_end_date%TYPE;
63: l_proc varchar2(72) := g_package||'create_ENRLD_ANTHR_PL_RT';
64: l_object_version_number ben_enrld_anthr_pl_rt_f.object_version_number%TYPE;
65: --
58: -- Declare cursors and local variables
59: --
60: l_enrld_anthr_pl_rt_id ben_enrld_anthr_pl_rt_f.enrld_anthr_pl_rt_id%TYPE;
61: l_effective_start_date ben_enrld_anthr_pl_rt_f.effective_start_date%TYPE;
62: l_effective_end_date ben_enrld_anthr_pl_rt_f.effective_end_date%TYPE;
63: l_proc varchar2(72) := g_package||'create_ENRLD_ANTHR_PL_RT';
64: l_object_version_number ben_enrld_anthr_pl_rt_f.object_version_number%TYPE;
65: --
66: begin
60: l_enrld_anthr_pl_rt_id ben_enrld_anthr_pl_rt_f.enrld_anthr_pl_rt_id%TYPE;
61: l_effective_start_date ben_enrld_anthr_pl_rt_f.effective_start_date%TYPE;
62: l_effective_end_date ben_enrld_anthr_pl_rt_f.effective_end_date%TYPE;
63: l_proc varchar2(72) := g_package||'create_ENRLD_ANTHR_PL_RT';
64: l_object_version_number ben_enrld_anthr_pl_rt_f.object_version_number%TYPE;
65: --
66: begin
67: --
68: hr_utility.set_location('Entering:'|| l_proc, 10);
243: p_base_table => 'BEN_VRBL_RT_PRFL_F',
244: p_base_table_column => 'VRBL_RT_PRFL_ID',
245: p_base_table_column_value => p_vrbl_rt_prfl_id,
246: p_base_table_reference_column => 'RT_ENRLD_PL_FLAG',
247: p_reference_table => 'BEN_ENRLD_ANTHR_PL_RT_F',
248: p_reference_table_column => 'VRBL_RT_PRFL_ID');
249: --
250: hr_utility.set_location(l_proc, 60);
251: --
348: --
349: -- Declare cursors and local variables
350: --
351: l_proc varchar2(72) := g_package||'update_ENRLD_ANTHR_PL_RT';
352: l_object_version_number ben_enrld_anthr_pl_rt_f.object_version_number%TYPE;
353: l_effective_start_date ben_enrld_anthr_pl_rt_f.effective_start_date%TYPE;
354: l_effective_end_date ben_enrld_anthr_pl_rt_f.effective_end_date%TYPE;
355: --
356: begin
349: -- Declare cursors and local variables
350: --
351: l_proc varchar2(72) := g_package||'update_ENRLD_ANTHR_PL_RT';
352: l_object_version_number ben_enrld_anthr_pl_rt_f.object_version_number%TYPE;
353: l_effective_start_date ben_enrld_anthr_pl_rt_f.effective_start_date%TYPE;
354: l_effective_end_date ben_enrld_anthr_pl_rt_f.effective_end_date%TYPE;
355: --
356: begin
357: --
350: --
351: l_proc varchar2(72) := g_package||'update_ENRLD_ANTHR_PL_RT';
352: l_object_version_number ben_enrld_anthr_pl_rt_f.object_version_number%TYPE;
353: l_effective_start_date ben_enrld_anthr_pl_rt_f.effective_start_date%TYPE;
354: l_effective_end_date ben_enrld_anthr_pl_rt_f.effective_end_date%TYPE;
355: --
356: begin
357: --
358: hr_utility.set_location('Entering:'|| l_proc, 10);
592: --
593: -- Declare cursors and local variables
594: --
595: l_proc varchar2(72) := g_package||'update_ENRLD_ANTHR_PL_RT';
596: l_object_version_number ben_enrld_anthr_pl_rt_f.object_version_number%TYPE;
597: l_effective_start_date ben_enrld_anthr_pl_rt_f.effective_start_date%TYPE;
598: l_effective_end_date ben_enrld_anthr_pl_rt_f.effective_end_date%TYPE;
599: --
600: begin
593: -- Declare cursors and local variables
594: --
595: l_proc varchar2(72) := g_package||'update_ENRLD_ANTHR_PL_RT';
596: l_object_version_number ben_enrld_anthr_pl_rt_f.object_version_number%TYPE;
597: l_effective_start_date ben_enrld_anthr_pl_rt_f.effective_start_date%TYPE;
598: l_effective_end_date ben_enrld_anthr_pl_rt_f.effective_end_date%TYPE;
599: --
600: begin
601: --
594: --
595: l_proc varchar2(72) := g_package||'update_ENRLD_ANTHR_PL_RT';
596: l_object_version_number ben_enrld_anthr_pl_rt_f.object_version_number%TYPE;
597: l_effective_start_date ben_enrld_anthr_pl_rt_f.effective_start_date%TYPE;
598: l_effective_end_date ben_enrld_anthr_pl_rt_f.effective_end_date%TYPE;
599: --
600: begin
601: --
602: hr_utility.set_location('Entering:'|| l_proc, 10);
673: p_base_table => 'BEN_VRBL_RT_PRFL_F',
674: p_base_table_column => 'VRBL_RT_PRFL_ID',
675: p_base_table_column_value => ben_enl_shd.g_old_rec.vrbl_rt_prfl_id,
676: p_base_table_reference_column => 'RT_ENRLD_PL_FLAG',
677: p_reference_table => 'BEN_ENRLD_ANTHR_PL_RT_F',
678: p_reference_table_column => 'VRBL_RT_PRFL_ID');
679: --
680: hr_utility.set_location(l_proc, 60);
681: --