65: ) is
66: --
67: -- Declare cursors and local variables
68: --
69: l_vrbl_mtchg_rt_id ben_vrbl_mtchg_rt_f.vrbl_mtchg_rt_id%TYPE;
70: l_effective_end_date ben_vrbl_mtchg_rt_f.effective_end_date%TYPE;
71: l_effective_start_date ben_vrbl_mtchg_rt_f.effective_start_date%TYPE;
72: l_proc varchar2(72) := g_package||'create_VRBL_MATCHING_RATE';
73: l_object_version_number ben_vrbl_mtchg_rt_f.object_version_number%TYPE;
66: --
67: -- Declare cursors and local variables
68: --
69: l_vrbl_mtchg_rt_id ben_vrbl_mtchg_rt_f.vrbl_mtchg_rt_id%TYPE;
70: l_effective_end_date ben_vrbl_mtchg_rt_f.effective_end_date%TYPE;
71: l_effective_start_date ben_vrbl_mtchg_rt_f.effective_start_date%TYPE;
72: l_proc varchar2(72) := g_package||'create_VRBL_MATCHING_RATE';
73: l_object_version_number ben_vrbl_mtchg_rt_f.object_version_number%TYPE;
74: --
67: -- Declare cursors and local variables
68: --
69: l_vrbl_mtchg_rt_id ben_vrbl_mtchg_rt_f.vrbl_mtchg_rt_id%TYPE;
70: l_effective_end_date ben_vrbl_mtchg_rt_f.effective_end_date%TYPE;
71: l_effective_start_date ben_vrbl_mtchg_rt_f.effective_start_date%TYPE;
72: l_proc varchar2(72) := g_package||'create_VRBL_MATCHING_RATE';
73: l_object_version_number ben_vrbl_mtchg_rt_f.object_version_number%TYPE;
74: --
75: begin
69: l_vrbl_mtchg_rt_id ben_vrbl_mtchg_rt_f.vrbl_mtchg_rt_id%TYPE;
70: l_effective_end_date ben_vrbl_mtchg_rt_f.effective_end_date%TYPE;
71: l_effective_start_date ben_vrbl_mtchg_rt_f.effective_start_date%TYPE;
72: l_proc varchar2(72) := g_package||'create_VRBL_MATCHING_RATE';
73: l_object_version_number ben_vrbl_mtchg_rt_f.object_version_number%TYPE;
74: --
75: begin
76: --
77: hr_utility.set_location('Entering:'|| l_proc, 10);
380: --
381: -- Declare cursors and local variables
382: --
383: l_proc varchar2(72) := g_package||'update_VRBL_MATCHING_RATE';
384: l_object_version_number ben_vrbl_mtchg_rt_f.object_version_number%TYPE;
385: l_effective_end_date ben_vrbl_mtchg_rt_f.effective_end_date%TYPE;
386: l_effective_start_date ben_vrbl_mtchg_rt_f.effective_start_date%TYPE;
387: --
388: begin
381: -- Declare cursors and local variables
382: --
383: l_proc varchar2(72) := g_package||'update_VRBL_MATCHING_RATE';
384: l_object_version_number ben_vrbl_mtchg_rt_f.object_version_number%TYPE;
385: l_effective_end_date ben_vrbl_mtchg_rt_f.effective_end_date%TYPE;
386: l_effective_start_date ben_vrbl_mtchg_rt_f.effective_start_date%TYPE;
387: --
388: begin
389: --
382: --
383: l_proc varchar2(72) := g_package||'update_VRBL_MATCHING_RATE';
384: l_object_version_number ben_vrbl_mtchg_rt_f.object_version_number%TYPE;
385: l_effective_end_date ben_vrbl_mtchg_rt_f.effective_end_date%TYPE;
386: l_effective_start_date ben_vrbl_mtchg_rt_f.effective_start_date%TYPE;
387: --
388: begin
389: --
390: hr_utility.set_location('Entering:'|| l_proc, 10);
652: --
653: -- Declare cursors and local variables
654: --
655: l_proc varchar2(72) := g_package||'update_VRBL_MATCHING_RATE';
656: l_object_version_number ben_vrbl_mtchg_rt_f.object_version_number%TYPE;
657: l_effective_end_date ben_vrbl_mtchg_rt_f.effective_end_date%TYPE;
658: l_effective_start_date ben_vrbl_mtchg_rt_f.effective_start_date%TYPE;
659: --
660: begin
653: -- Declare cursors and local variables
654: --
655: l_proc varchar2(72) := g_package||'update_VRBL_MATCHING_RATE';
656: l_object_version_number ben_vrbl_mtchg_rt_f.object_version_number%TYPE;
657: l_effective_end_date ben_vrbl_mtchg_rt_f.effective_end_date%TYPE;
658: l_effective_start_date ben_vrbl_mtchg_rt_f.effective_start_date%TYPE;
659: --
660: begin
661: --
654: --
655: l_proc varchar2(72) := g_package||'update_VRBL_MATCHING_RATE';
656: l_object_version_number ben_vrbl_mtchg_rt_f.object_version_number%TYPE;
657: l_effective_end_date ben_vrbl_mtchg_rt_f.effective_end_date%TYPE;
658: l_effective_start_date ben_vrbl_mtchg_rt_f.effective_start_date%TYPE;
659: --
660: begin
661: --
662: hr_utility.set_location('Entering:'|| l_proc, 10);