56: ) is
57: --
58: -- Declare cursors and local variables
59: --
60: l_vrbl_rt_rl_id ben_vrbl_rt_rl_f.vrbl_rt_rl_id%TYPE;
61: l_effective_start_date ben_vrbl_rt_rl_f.effective_start_date%TYPE;
62: l_effective_end_date ben_vrbl_rt_rl_f.effective_end_date%TYPE;
63: l_proc varchar2(72) := g_package||'create_Vrbl_Rate_Rule';
64: l_object_version_number ben_vrbl_rt_rl_f.object_version_number%TYPE;
57: --
58: -- Declare cursors and local variables
59: --
60: l_vrbl_rt_rl_id ben_vrbl_rt_rl_f.vrbl_rt_rl_id%TYPE;
61: l_effective_start_date ben_vrbl_rt_rl_f.effective_start_date%TYPE;
62: l_effective_end_date ben_vrbl_rt_rl_f.effective_end_date%TYPE;
63: l_proc varchar2(72) := g_package||'create_Vrbl_Rate_Rule';
64: l_object_version_number ben_vrbl_rt_rl_f.object_version_number%TYPE;
65: --
58: -- Declare cursors and local variables
59: --
60: l_vrbl_rt_rl_id ben_vrbl_rt_rl_f.vrbl_rt_rl_id%TYPE;
61: l_effective_start_date ben_vrbl_rt_rl_f.effective_start_date%TYPE;
62: l_effective_end_date ben_vrbl_rt_rl_f.effective_end_date%TYPE;
63: l_proc varchar2(72) := g_package||'create_Vrbl_Rate_Rule';
64: l_object_version_number ben_vrbl_rt_rl_f.object_version_number%TYPE;
65: --
66: begin
60: l_vrbl_rt_rl_id ben_vrbl_rt_rl_f.vrbl_rt_rl_id%TYPE;
61: l_effective_start_date ben_vrbl_rt_rl_f.effective_start_date%TYPE;
62: l_effective_end_date ben_vrbl_rt_rl_f.effective_end_date%TYPE;
63: l_proc varchar2(72) := g_package||'create_Vrbl_Rate_Rule';
64: l_object_version_number ben_vrbl_rt_rl_f.object_version_number%TYPE;
65: --
66: begin
67: --
68: hr_utility.set_location('Entering:'|| l_proc, 10);
339: --
340: -- Declare cursors and local variables
341: --
342: l_proc varchar2(72) := g_package||'update_Vrbl_Rate_Rule';
343: l_object_version_number ben_vrbl_rt_rl_f.object_version_number%TYPE;
344: l_effective_start_date ben_vrbl_rt_rl_f.effective_start_date%TYPE;
345: l_effective_end_date ben_vrbl_rt_rl_f.effective_end_date%TYPE;
346: --
347: begin
340: -- Declare cursors and local variables
341: --
342: l_proc varchar2(72) := g_package||'update_Vrbl_Rate_Rule';
343: l_object_version_number ben_vrbl_rt_rl_f.object_version_number%TYPE;
344: l_effective_start_date ben_vrbl_rt_rl_f.effective_start_date%TYPE;
345: l_effective_end_date ben_vrbl_rt_rl_f.effective_end_date%TYPE;
346: --
347: begin
348: --
341: --
342: l_proc varchar2(72) := g_package||'update_Vrbl_Rate_Rule';
343: l_object_version_number ben_vrbl_rt_rl_f.object_version_number%TYPE;
344: l_effective_start_date ben_vrbl_rt_rl_f.effective_start_date%TYPE;
345: l_effective_end_date ben_vrbl_rt_rl_f.effective_end_date%TYPE;
346: --
347: begin
348: --
349: hr_utility.set_location('Entering:'|| l_proc, 10);
584: --
585: -- Declare cursors and local variables
586: --
587: l_proc varchar2(72) := g_package||'update_Vrbl_Rate_Rule';
588: l_object_version_number ben_vrbl_rt_rl_f.object_version_number%TYPE;
589: l_effective_start_date ben_vrbl_rt_rl_f.effective_start_date%TYPE;
590: l_effective_end_date ben_vrbl_rt_rl_f.effective_end_date%TYPE;
591: --
592: begin
585: -- Declare cursors and local variables
586: --
587: l_proc varchar2(72) := g_package||'update_Vrbl_Rate_Rule';
588: l_object_version_number ben_vrbl_rt_rl_f.object_version_number%TYPE;
589: l_effective_start_date ben_vrbl_rt_rl_f.effective_start_date%TYPE;
590: l_effective_end_date ben_vrbl_rt_rl_f.effective_end_date%TYPE;
591: --
592: begin
593: --
586: --
587: l_proc varchar2(72) := g_package||'update_Vrbl_Rate_Rule';
588: l_object_version_number ben_vrbl_rt_rl_f.object_version_number%TYPE;
589: l_effective_start_date ben_vrbl_rt_rl_f.effective_start_date%TYPE;
590: l_effective_end_date ben_vrbl_rt_rl_f.effective_end_date%TYPE;
591: --
592: begin
593: --
594: hr_utility.set_location('Entering:'|| l_proc, 10);