55: ) is
56: --
57: -- Declare cursors and local variables
58: --
59: l_pct_fl_tm_rt_id ben_pct_fl_tm_rt_f.pct_fl_tm_rt_id%TYPE;
60: l_effective_start_date ben_pct_fl_tm_rt_f.effective_start_date%TYPE;
61: l_effective_end_date ben_pct_fl_tm_rt_f.effective_end_date%TYPE;
62: l_proc varchar2(72) := g_package||'create_PCT_FULL_TIME_RATE';
63: l_object_version_number ben_pct_fl_tm_rt_f.object_version_number%TYPE;
56: --
57: -- Declare cursors and local variables
58: --
59: l_pct_fl_tm_rt_id ben_pct_fl_tm_rt_f.pct_fl_tm_rt_id%TYPE;
60: l_effective_start_date ben_pct_fl_tm_rt_f.effective_start_date%TYPE;
61: l_effective_end_date ben_pct_fl_tm_rt_f.effective_end_date%TYPE;
62: l_proc varchar2(72) := g_package||'create_PCT_FULL_TIME_RATE';
63: l_object_version_number ben_pct_fl_tm_rt_f.object_version_number%TYPE;
64: --
57: -- Declare cursors and local variables
58: --
59: l_pct_fl_tm_rt_id ben_pct_fl_tm_rt_f.pct_fl_tm_rt_id%TYPE;
60: l_effective_start_date ben_pct_fl_tm_rt_f.effective_start_date%TYPE;
61: l_effective_end_date ben_pct_fl_tm_rt_f.effective_end_date%TYPE;
62: l_proc varchar2(72) := g_package||'create_PCT_FULL_TIME_RATE';
63: l_object_version_number ben_pct_fl_tm_rt_f.object_version_number%TYPE;
64: --
65: begin
59: l_pct_fl_tm_rt_id ben_pct_fl_tm_rt_f.pct_fl_tm_rt_id%TYPE;
60: l_effective_start_date ben_pct_fl_tm_rt_f.effective_start_date%TYPE;
61: l_effective_end_date ben_pct_fl_tm_rt_f.effective_end_date%TYPE;
62: l_proc varchar2(72) := g_package||'create_PCT_FULL_TIME_RATE';
63: l_object_version_number ben_pct_fl_tm_rt_f.object_version_number%TYPE;
64: --
65: begin
66: --
67: hr_utility.set_location('Entering:'|| l_proc, 10);
239: p_base_table => 'BEN_VRBL_RT_PRFL_F',
240: p_base_table_column => 'VRBL_RT_PRFL_ID',
241: p_base_table_column_value => p_vrbl_rt_prfl_id,
242: p_base_table_reference_column => 'RT_PCT_FL_TM_FLAG',
243: p_reference_table => 'BEN_PCT_FL_TM_RT_F',
244: p_reference_table_column => 'VRBL_RT_PRFL_ID');
245: --
246: ben_derivable_rate.derivable_rate_handler
247: (p_event =>'CREATE',
347: --
348: -- Declare cursors and local variables
349: --
350: l_proc varchar2(72) := g_package||'update_PCT_FULL_TIME_RATE';
351: l_object_version_number ben_pct_fl_tm_rt_f.object_version_number%TYPE;
352: l_effective_start_date ben_pct_fl_tm_rt_f.effective_start_date%TYPE;
353: l_effective_end_date ben_pct_fl_tm_rt_f.effective_end_date%TYPE;
354: --
355: begin
348: -- Declare cursors and local variables
349: --
350: l_proc varchar2(72) := g_package||'update_PCT_FULL_TIME_RATE';
351: l_object_version_number ben_pct_fl_tm_rt_f.object_version_number%TYPE;
352: l_effective_start_date ben_pct_fl_tm_rt_f.effective_start_date%TYPE;
353: l_effective_end_date ben_pct_fl_tm_rt_f.effective_end_date%TYPE;
354: --
355: begin
356: --
349: --
350: l_proc varchar2(72) := g_package||'update_PCT_FULL_TIME_RATE';
351: l_object_version_number ben_pct_fl_tm_rt_f.object_version_number%TYPE;
352: l_effective_start_date ben_pct_fl_tm_rt_f.effective_start_date%TYPE;
353: l_effective_end_date ben_pct_fl_tm_rt_f.effective_end_date%TYPE;
354: --
355: begin
356: --
357: hr_utility.set_location('Entering:'|| l_proc, 10);
589: --
590: -- Declare cursors and local variables
591: --
592: l_proc varchar2(72) := g_package||'update_PCT_FULL_TIME_RATE';
593: l_object_version_number ben_pct_fl_tm_rt_f.object_version_number%TYPE;
594: l_effective_start_date ben_pct_fl_tm_rt_f.effective_start_date%TYPE;
595: l_effective_end_date ben_pct_fl_tm_rt_f.effective_end_date%TYPE;
596: --
597: begin
590: -- Declare cursors and local variables
591: --
592: l_proc varchar2(72) := g_package||'update_PCT_FULL_TIME_RATE';
593: l_object_version_number ben_pct_fl_tm_rt_f.object_version_number%TYPE;
594: l_effective_start_date ben_pct_fl_tm_rt_f.effective_start_date%TYPE;
595: l_effective_end_date ben_pct_fl_tm_rt_f.effective_end_date%TYPE;
596: --
597: begin
598: --
591: --
592: l_proc varchar2(72) := g_package||'update_PCT_FULL_TIME_RATE';
593: l_object_version_number ben_pct_fl_tm_rt_f.object_version_number%TYPE;
594: l_effective_start_date ben_pct_fl_tm_rt_f.effective_start_date%TYPE;
595: l_effective_end_date ben_pct_fl_tm_rt_f.effective_end_date%TYPE;
596: --
597: begin
598: --
599: hr_utility.set_location('Entering:'|| l_proc, 10);
670: p_base_table => 'BEN_VRBL_RT_PRFL_F',
671: p_base_table_column => 'VRBL_RT_PRFL_ID',
672: p_base_table_column_value => ben_pfr_shd.g_old_rec.vrbl_rt_prfl_id,
673: p_base_table_reference_column => 'RT_PCT_FL_TM_FLAG',
674: p_reference_table => 'BEN_PCT_FL_TM_RT_F',
675: p_reference_table_column => 'VRBL_RT_PRFL_ID');
676: --
677: ben_derivable_rate.derivable_rate_handler
678: (p_event =>'DELETE',