57: ) is
58: --
59: -- Declare cursors and local variables
60: --
61: l_elig_pct_fl_tm_prte_id ben_elig_pct_fl_tm_prte_f.elig_pct_fl_tm_prte_id%TYPE;
62: l_effective_start_date ben_elig_pct_fl_tm_prte_f.effective_start_date%TYPE;
63: l_effective_end_date ben_elig_pct_fl_tm_prte_f.effective_end_date%TYPE;
64: l_proc varchar2(72) := g_package||'create_ELIG_PCT_FL_TM_PRTE';
65: l_object_version_number ben_elig_pct_fl_tm_prte_f.object_version_number%TYPE;
58: --
59: -- Declare cursors and local variables
60: --
61: l_elig_pct_fl_tm_prte_id ben_elig_pct_fl_tm_prte_f.elig_pct_fl_tm_prte_id%TYPE;
62: l_effective_start_date ben_elig_pct_fl_tm_prte_f.effective_start_date%TYPE;
63: l_effective_end_date ben_elig_pct_fl_tm_prte_f.effective_end_date%TYPE;
64: l_proc varchar2(72) := g_package||'create_ELIG_PCT_FL_TM_PRTE';
65: l_object_version_number ben_elig_pct_fl_tm_prte_f.object_version_number%TYPE;
66: --
59: -- Declare cursors and local variables
60: --
61: l_elig_pct_fl_tm_prte_id ben_elig_pct_fl_tm_prte_f.elig_pct_fl_tm_prte_id%TYPE;
62: l_effective_start_date ben_elig_pct_fl_tm_prte_f.effective_start_date%TYPE;
63: l_effective_end_date ben_elig_pct_fl_tm_prte_f.effective_end_date%TYPE;
64: l_proc varchar2(72) := g_package||'create_ELIG_PCT_FL_TM_PRTE';
65: l_object_version_number ben_elig_pct_fl_tm_prte_f.object_version_number%TYPE;
66: --
67: begin
61: l_elig_pct_fl_tm_prte_id ben_elig_pct_fl_tm_prte_f.elig_pct_fl_tm_prte_id%TYPE;
62: l_effective_start_date ben_elig_pct_fl_tm_prte_f.effective_start_date%TYPE;
63: l_effective_end_date ben_elig_pct_fl_tm_prte_f.effective_end_date%TYPE;
64: l_proc varchar2(72) := g_package||'create_ELIG_PCT_FL_TM_PRTE';
65: l_object_version_number ben_elig_pct_fl_tm_prte_f.object_version_number%TYPE;
66: --
67: begin
68: --
69: hr_utility.set_location('Entering:'|| l_proc, 10);
249: p_base_table => 'BEN_ELIGY_PRFL_F',
250: p_base_table_column => 'ELIGY_PRFL_ID',
251: p_base_table_column_value => p_eligy_prfl_id,
252: p_base_table_reference_column => 'ELIG_PCT_FL_TM_FLAG',
253: p_reference_table => 'BEN_ELIG_PCT_FL_TM_PRTE_F',
254: p_reference_table_column => 'ELIGY_PRFL_ID');
255: --
256: ben_derivable_factor.derivable_factor_handler
257: (p_event => 'CREATE',
349: --
350: -- Declare cursors and local variables
351: --
352: l_proc varchar2(72) := g_package||'update_ELIG_PCT_FL_TM_PRTE';
353: l_object_version_number ben_elig_pct_fl_tm_prte_f.object_version_number%TYPE;
354: l_effective_start_date ben_elig_pct_fl_tm_prte_f.effective_start_date%TYPE;
355: l_effective_end_date ben_elig_pct_fl_tm_prte_f.effective_end_date%TYPE;
356: --
357: begin
350: -- Declare cursors and local variables
351: --
352: l_proc varchar2(72) := g_package||'update_ELIG_PCT_FL_TM_PRTE';
353: l_object_version_number ben_elig_pct_fl_tm_prte_f.object_version_number%TYPE;
354: l_effective_start_date ben_elig_pct_fl_tm_prte_f.effective_start_date%TYPE;
355: l_effective_end_date ben_elig_pct_fl_tm_prte_f.effective_end_date%TYPE;
356: --
357: begin
358: --
351: --
352: l_proc varchar2(72) := g_package||'update_ELIG_PCT_FL_TM_PRTE';
353: l_object_version_number ben_elig_pct_fl_tm_prte_f.object_version_number%TYPE;
354: l_effective_start_date ben_elig_pct_fl_tm_prte_f.effective_start_date%TYPE;
355: l_effective_end_date ben_elig_pct_fl_tm_prte_f.effective_end_date%TYPE;
356: --
357: begin
358: --
359: hr_utility.set_location('Entering:'|| l_proc, 10);
588: --
589: -- Declare cursors and local variables
590: --
591: l_proc varchar2(72) := g_package||'update_ELIG_PCT_FL_TM_PRTE';
592: l_object_version_number ben_elig_pct_fl_tm_prte_f.object_version_number%TYPE;
593: l_effective_start_date ben_elig_pct_fl_tm_prte_f.effective_start_date%TYPE;
594: l_effective_end_date ben_elig_pct_fl_tm_prte_f.effective_end_date%TYPE;
595: --
596: begin
589: -- Declare cursors and local variables
590: --
591: l_proc varchar2(72) := g_package||'update_ELIG_PCT_FL_TM_PRTE';
592: l_object_version_number ben_elig_pct_fl_tm_prte_f.object_version_number%TYPE;
593: l_effective_start_date ben_elig_pct_fl_tm_prte_f.effective_start_date%TYPE;
594: l_effective_end_date ben_elig_pct_fl_tm_prte_f.effective_end_date%TYPE;
595: --
596: begin
597: --
590: --
591: l_proc varchar2(72) := g_package||'update_ELIG_PCT_FL_TM_PRTE';
592: l_object_version_number ben_elig_pct_fl_tm_prte_f.object_version_number%TYPE;
593: l_effective_start_date ben_elig_pct_fl_tm_prte_f.effective_start_date%TYPE;
594: l_effective_end_date ben_elig_pct_fl_tm_prte_f.effective_end_date%TYPE;
595: --
596: begin
597: --
598: hr_utility.set_location('Entering:'|| l_proc, 10);
671: p_base_table => 'BEN_ELIGY_PRFL_F',
672: p_base_table_column => 'ELIGY_PRFL_ID',
673: p_base_table_column_value => ben_epf_shd.g_old_rec.eligy_prfl_id,
674: p_base_table_reference_column => 'ELIG_PCT_FL_TM_FLAG',
675: p_reference_table => 'BEN_ELIG_PCT_FL_TM_PRTE_F',
676: p_reference_table_column => 'ELIGY_PRFL_ID');
677: --
678: ben_derivable_factor.derivable_factor_handler
679: (p_event => 'DELETE',