55: ) is
56: --
57: -- Declare cursors and local variables
58: --
59: l_PSTN_RT_id ben_PSTN_RT_f.PSTN_RT_id%TYPE;
60: l_effective_start_date ben_PSTN_RT_f.effective_start_date%TYPE;
61: l_effective_end_date ben_PSTN_RT_f.effective_end_date%TYPE;
62: l_proc varchar2(72) := g_package||'create_PSTN_RT';
63: l_object_version_number ben_PSTN_RT_f.object_version_number%TYPE;
56: --
57: -- Declare cursors and local variables
58: --
59: l_PSTN_RT_id ben_PSTN_RT_f.PSTN_RT_id%TYPE;
60: l_effective_start_date ben_PSTN_RT_f.effective_start_date%TYPE;
61: l_effective_end_date ben_PSTN_RT_f.effective_end_date%TYPE;
62: l_proc varchar2(72) := g_package||'create_PSTN_RT';
63: l_object_version_number ben_PSTN_RT_f.object_version_number%TYPE;
64: --
57: -- Declare cursors and local variables
58: --
59: l_PSTN_RT_id ben_PSTN_RT_f.PSTN_RT_id%TYPE;
60: l_effective_start_date ben_PSTN_RT_f.effective_start_date%TYPE;
61: l_effective_end_date ben_PSTN_RT_f.effective_end_date%TYPE;
62: l_proc varchar2(72) := g_package||'create_PSTN_RT';
63: l_object_version_number ben_PSTN_RT_f.object_version_number%TYPE;
64: --
65: begin
59: l_PSTN_RT_id ben_PSTN_RT_f.PSTN_RT_id%TYPE;
60: l_effective_start_date ben_PSTN_RT_f.effective_start_date%TYPE;
61: l_effective_end_date ben_PSTN_RT_f.effective_end_date%TYPE;
62: l_proc varchar2(72) := g_package||'create_PSTN_RT';
63: l_object_version_number ben_PSTN_RT_f.object_version_number%TYPE;
64: --
65: begin
66: --
67: hr_utility.set_location('Entering:'|| l_proc, 10);
242: p_base_table => 'BEN_VRBL_RT_PRFL_F',
243: p_base_table_column => 'VRBL_RT_PRFL_ID',
244: p_base_table_column_value => p_vrbl_rt_prfl_id,
245: p_base_table_reference_column => 'RT_PSTN_FLAG',
246: p_reference_table => 'BEN_PSTN_RT_F',
247: p_reference_table_column => 'VRBL_RT_PRFL_ID');
248: --
249: hr_utility.set_location(l_proc, 60);
250: --
349: --
350: -- Declare cursors and local variables
351: --
352: l_proc varchar2(72) := g_package||'update_PSTN_RT';
353: l_object_version_number ben_PSTN_RT_f.object_version_number%TYPE;
354: l_effective_start_date ben_PSTN_RT_f.effective_start_date%TYPE;
355: l_effective_end_date ben_PSTN_RT_f.effective_end_date%TYPE;
356: --
357: begin
350: -- Declare cursors and local variables
351: --
352: l_proc varchar2(72) := g_package||'update_PSTN_RT';
353: l_object_version_number ben_PSTN_RT_f.object_version_number%TYPE;
354: l_effective_start_date ben_PSTN_RT_f.effective_start_date%TYPE;
355: l_effective_end_date ben_PSTN_RT_f.effective_end_date%TYPE;
356: --
357: begin
358: --
351: --
352: l_proc varchar2(72) := g_package||'update_PSTN_RT';
353: l_object_version_number ben_PSTN_RT_f.object_version_number%TYPE;
354: l_effective_start_date ben_PSTN_RT_f.effective_start_date%TYPE;
355: l_effective_end_date ben_PSTN_RT_f.effective_end_date%TYPE;
356: --
357: begin
358: --
359: hr_utility.set_location('Entering:'|| l_proc, 10);
595: --
596: -- Declare cursors and local variables
597: --
598: l_proc varchar2(72) := g_package||'update_PSTN_RT';
599: l_object_version_number ben_PSTN_RT_f.object_version_number%TYPE;
600: l_effective_start_date ben_PSTN_RT_f.effective_start_date%TYPE;
601: l_effective_end_date ben_PSTN_RT_f.effective_end_date%TYPE;
602: --
603: begin
596: -- Declare cursors and local variables
597: --
598: l_proc varchar2(72) := g_package||'update_PSTN_RT';
599: l_object_version_number ben_PSTN_RT_f.object_version_number%TYPE;
600: l_effective_start_date ben_PSTN_RT_f.effective_start_date%TYPE;
601: l_effective_end_date ben_PSTN_RT_f.effective_end_date%TYPE;
602: --
603: begin
604: --
597: --
598: l_proc varchar2(72) := g_package||'update_PSTN_RT';
599: l_object_version_number ben_PSTN_RT_f.object_version_number%TYPE;
600: l_effective_start_date ben_PSTN_RT_f.effective_start_date%TYPE;
601: l_effective_end_date ben_PSTN_RT_f.effective_end_date%TYPE;
602: --
603: begin
604: --
605: hr_utility.set_location('Entering:'|| l_proc, 10);
676: p_base_table => 'BEN_VRBL_RT_PRFL_F',
677: p_base_table_column => 'VRBL_RT_PRFL_ID',
678: p_base_table_column_value => ben_pst_shd.g_old_rec.vrbl_rt_prfl_id,
679: p_base_table_reference_column => 'RT_PSTN_FLAG',
680: p_reference_table => 'BEN_PSTN_RT_F',
681: p_reference_table_column => 'VRBL_RT_PRFL_ID');
682: --
683: hr_utility.set_location(l_proc, 60);
684: --