55: ) is
56: --
57: -- Declare cursors and local variables
58: --
59: l_qua_in_gr_rt_id ben_qua_in_gr_rt_f.qua_in_gr_rt_id%TYPE;
60: l_effective_start_date ben_qua_in_gr_rt_f.effective_start_date%TYPE;
61: l_effective_end_date ben_qua_in_gr_rt_f.effective_end_date%TYPE;
62: l_proc varchar2(72) := g_package||'create_QUA_IN_GR_RT';
63: l_object_version_number ben_qua_in_gr_rt_f.object_version_number%TYPE;
56: --
57: -- Declare cursors and local variables
58: --
59: l_qua_in_gr_rt_id ben_qua_in_gr_rt_f.qua_in_gr_rt_id%TYPE;
60: l_effective_start_date ben_qua_in_gr_rt_f.effective_start_date%TYPE;
61: l_effective_end_date ben_qua_in_gr_rt_f.effective_end_date%TYPE;
62: l_proc varchar2(72) := g_package||'create_QUA_IN_GR_RT';
63: l_object_version_number ben_qua_in_gr_rt_f.object_version_number%TYPE;
64: --
57: -- Declare cursors and local variables
58: --
59: l_qua_in_gr_rt_id ben_qua_in_gr_rt_f.qua_in_gr_rt_id%TYPE;
60: l_effective_start_date ben_qua_in_gr_rt_f.effective_start_date%TYPE;
61: l_effective_end_date ben_qua_in_gr_rt_f.effective_end_date%TYPE;
62: l_proc varchar2(72) := g_package||'create_QUA_IN_GR_RT';
63: l_object_version_number ben_qua_in_gr_rt_f.object_version_number%TYPE;
64: --
65: begin
59: l_qua_in_gr_rt_id ben_qua_in_gr_rt_f.qua_in_gr_rt_id%TYPE;
60: l_effective_start_date ben_qua_in_gr_rt_f.effective_start_date%TYPE;
61: l_effective_end_date ben_qua_in_gr_rt_f.effective_end_date%TYPE;
62: l_proc varchar2(72) := g_package||'create_QUA_IN_GR_RT';
63: l_object_version_number ben_qua_in_gr_rt_f.object_version_number%TYPE;
64: --
65: begin
66: --
67: hr_utility.set_location('Entering:'|| l_proc, 10);
240: p_base_table => 'BEN_VRBL_RT_PRFL_F',
241: p_base_table_column => 'VRBL_RT_PRFL_ID',
242: p_base_table_column_value => p_vrbl_rt_prfl_id,
243: p_base_table_reference_column => 'RT_QUA_IN_GR_FLAG',
244: p_reference_table => 'BEN_QUA_IN_GR_RT_F',
245: p_reference_table_column => 'VRBL_RT_PRFL_ID');
246: --
247: hr_utility.set_location(l_proc, 60);
248: --
347: --
348: -- Declare cursors and local variables
349: --
350: l_proc varchar2(72) := g_package||'update_QUA_IN_GR_RT';
351: l_object_version_number ben_qua_in_gr_rt_f.object_version_number%TYPE;
352: l_effective_start_date ben_qua_in_gr_rt_f.effective_start_date%TYPE;
353: l_effective_end_date ben_qua_in_gr_rt_f.effective_end_date%TYPE;
354: --
355: begin
348: -- Declare cursors and local variables
349: --
350: l_proc varchar2(72) := g_package||'update_QUA_IN_GR_RT';
351: l_object_version_number ben_qua_in_gr_rt_f.object_version_number%TYPE;
352: l_effective_start_date ben_qua_in_gr_rt_f.effective_start_date%TYPE;
353: l_effective_end_date ben_qua_in_gr_rt_f.effective_end_date%TYPE;
354: --
355: begin
356: --
349: --
350: l_proc varchar2(72) := g_package||'update_QUA_IN_GR_RT';
351: l_object_version_number ben_qua_in_gr_rt_f.object_version_number%TYPE;
352: l_effective_start_date ben_qua_in_gr_rt_f.effective_start_date%TYPE;
353: l_effective_end_date ben_qua_in_gr_rt_f.effective_end_date%TYPE;
354: --
355: begin
356: --
357: hr_utility.set_location('Entering:'|| l_proc, 10);
593: --
594: -- Declare cursors and local variables
595: --
596: l_proc varchar2(72) := g_package||'update_QUA_IN_GR_RT';
597: l_object_version_number ben_qua_in_gr_rt_f.object_version_number%TYPE;
598: l_effective_start_date ben_qua_in_gr_rt_f.effective_start_date%TYPE;
599: l_effective_end_date ben_qua_in_gr_rt_f.effective_end_date%TYPE;
600: --
601: begin
594: -- Declare cursors and local variables
595: --
596: l_proc varchar2(72) := g_package||'update_QUA_IN_GR_RT';
597: l_object_version_number ben_qua_in_gr_rt_f.object_version_number%TYPE;
598: l_effective_start_date ben_qua_in_gr_rt_f.effective_start_date%TYPE;
599: l_effective_end_date ben_qua_in_gr_rt_f.effective_end_date%TYPE;
600: --
601: begin
602: --
595: --
596: l_proc varchar2(72) := g_package||'update_QUA_IN_GR_RT';
597: l_object_version_number ben_qua_in_gr_rt_f.object_version_number%TYPE;
598: l_effective_start_date ben_qua_in_gr_rt_f.effective_start_date%TYPE;
599: l_effective_end_date ben_qua_in_gr_rt_f.effective_end_date%TYPE;
600: --
601: begin
602: --
603: hr_utility.set_location('Entering:'|| l_proc, 10);
674: p_base_table => 'BEN_VRBL_RT_PRFL_F',
675: p_base_table_column => 'VRBL_RT_PRFL_ID',
676: p_base_table_column_value => ben_qig_shd.g_old_rec.vrbl_rt_prfl_id,
677: p_base_table_reference_column => 'RT_QUA_IN_GR_FLAG',
678: p_reference_table => 'BEN_QUA_IN_GR_RT_F',
679: p_reference_table_column => 'VRBL_RT_PRFL_ID');
680: --
681: hr_utility.set_location(l_proc, 60);
682: --