24: ) is
25: --
26: -- Declare cursors and local variables
27: --
28: l_elig_rslt_id ben_elig_rslt_f.elig_rslt_id%TYPE;
29: l_effective_start_date ben_elig_rslt_f.effective_start_date%TYPE;
30: l_effective_end_date ben_elig_rslt_f.effective_end_date%TYPE;
31: l_proc varchar2(72) := g_package||'create_ELIG_RSLT';
32: l_object_version_number ben_elig_rslt_f.object_version_number%TYPE;
25: --
26: -- Declare cursors and local variables
27: --
28: l_elig_rslt_id ben_elig_rslt_f.elig_rslt_id%TYPE;
29: l_effective_start_date ben_elig_rslt_f.effective_start_date%TYPE;
30: l_effective_end_date ben_elig_rslt_f.effective_end_date%TYPE;
31: l_proc varchar2(72) := g_package||'create_ELIG_RSLT';
32: l_object_version_number ben_elig_rslt_f.object_version_number%TYPE;
33: --
26: -- Declare cursors and local variables
27: --
28: l_elig_rslt_id ben_elig_rslt_f.elig_rslt_id%TYPE;
29: l_effective_start_date ben_elig_rslt_f.effective_start_date%TYPE;
30: l_effective_end_date ben_elig_rslt_f.effective_end_date%TYPE;
31: l_proc varchar2(72) := g_package||'create_ELIG_RSLT';
32: l_object_version_number ben_elig_rslt_f.object_version_number%TYPE;
33: --
34: begin
28: l_elig_rslt_id ben_elig_rslt_f.elig_rslt_id%TYPE;
29: l_effective_start_date ben_elig_rslt_f.effective_start_date%TYPE;
30: l_effective_end_date ben_elig_rslt_f.effective_end_date%TYPE;
31: l_proc varchar2(72) := g_package||'create_ELIG_RSLT';
32: l_object_version_number ben_elig_rslt_f.object_version_number%TYPE;
33: --
34: begin
35: --
36: hr_utility.set_location('Entering:'|| l_proc, 10);
175: --
176: -- Declare cursors and local variables
177: --
178: l_proc varchar2(72) := g_package||'update_ELIG_RSLT';
179: l_object_version_number ben_elig_rslt_f.object_version_number%TYPE;
180: l_effective_start_date ben_elig_rslt_f.effective_start_date%TYPE;
181: l_effective_end_date ben_elig_rslt_f.effective_end_date%TYPE;
182: --
183: begin
176: -- Declare cursors and local variables
177: --
178: l_proc varchar2(72) := g_package||'update_ELIG_RSLT';
179: l_object_version_number ben_elig_rslt_f.object_version_number%TYPE;
180: l_effective_start_date ben_elig_rslt_f.effective_start_date%TYPE;
181: l_effective_end_date ben_elig_rslt_f.effective_end_date%TYPE;
182: --
183: begin
184: --
177: --
178: l_proc varchar2(72) := g_package||'update_ELIG_RSLT';
179: l_object_version_number ben_elig_rslt_f.object_version_number%TYPE;
180: l_effective_start_date ben_elig_rslt_f.effective_start_date%TYPE;
181: l_effective_end_date ben_elig_rslt_f.effective_end_date%TYPE;
182: --
183: begin
184: --
185: hr_utility.set_location('Entering:'|| l_proc, 10);
320: --
321: -- Declare cursors and local variables
322: --
323: l_proc varchar2(72) := g_package||'update_ELIG_RSLT';
324: l_object_version_number ben_elig_rslt_f.object_version_number%TYPE;
325: l_effective_start_date ben_elig_rslt_f.effective_start_date%TYPE;
326: l_effective_end_date ben_elig_rslt_f.effective_end_date%TYPE;
327: --
328: begin
321: -- Declare cursors and local variables
322: --
323: l_proc varchar2(72) := g_package||'update_ELIG_RSLT';
324: l_object_version_number ben_elig_rslt_f.object_version_number%TYPE;
325: l_effective_start_date ben_elig_rslt_f.effective_start_date%TYPE;
326: l_effective_end_date ben_elig_rslt_f.effective_end_date%TYPE;
327: --
328: begin
329: --
322: --
323: l_proc varchar2(72) := g_package||'update_ELIG_RSLT';
324: l_object_version_number ben_elig_rslt_f.object_version_number%TYPE;
325: l_effective_start_date ben_elig_rslt_f.effective_start_date%TYPE;
326: l_effective_end_date ben_elig_rslt_f.effective_end_date%TYPE;
327: --
328: begin
329: --
330: hr_utility.set_location('Entering:'|| l_proc, 10);