44: ) is
45: --
46: -- Declare cursors and local variables
47: --
48: l_elig_obj_elig_prfl_id ben_elig_obj_elig_profl_f.elig_obj_elig_prfl_id%TYPE;
49: l_effective_start_date ben_elig_obj_elig_profl_f.effective_start_date%TYPE;
50: l_effective_end_date ben_elig_obj_elig_profl_f.effective_end_date%TYPE;
51: l_proc varchar2(72) := g_package||'create_ELIG_OBJ_ELIG_PROFL';
52: l_object_version_number ben_elig_obj_elig_profl_f.object_version_number%TYPE;
45: --
46: -- Declare cursors and local variables
47: --
48: l_elig_obj_elig_prfl_id ben_elig_obj_elig_profl_f.elig_obj_elig_prfl_id%TYPE;
49: l_effective_start_date ben_elig_obj_elig_profl_f.effective_start_date%TYPE;
50: l_effective_end_date ben_elig_obj_elig_profl_f.effective_end_date%TYPE;
51: l_proc varchar2(72) := g_package||'create_ELIG_OBJ_ELIG_PROFL';
52: l_object_version_number ben_elig_obj_elig_profl_f.object_version_number%TYPE;
53: --
46: -- Declare cursors and local variables
47: --
48: l_elig_obj_elig_prfl_id ben_elig_obj_elig_profl_f.elig_obj_elig_prfl_id%TYPE;
49: l_effective_start_date ben_elig_obj_elig_profl_f.effective_start_date%TYPE;
50: l_effective_end_date ben_elig_obj_elig_profl_f.effective_end_date%TYPE;
51: l_proc varchar2(72) := g_package||'create_ELIG_OBJ_ELIG_PROFL';
52: l_object_version_number ben_elig_obj_elig_profl_f.object_version_number%TYPE;
53: --
54: begin
48: l_elig_obj_elig_prfl_id ben_elig_obj_elig_profl_f.elig_obj_elig_prfl_id%TYPE;
49: l_effective_start_date ben_elig_obj_elig_profl_f.effective_start_date%TYPE;
50: l_effective_end_date ben_elig_obj_elig_profl_f.effective_end_date%TYPE;
51: l_proc varchar2(72) := g_package||'create_ELIG_OBJ_ELIG_PROFL';
52: l_object_version_number ben_elig_obj_elig_profl_f.object_version_number%TYPE;
53: --
54: begin
55: --
56: hr_utility.set_location('Entering:'|| l_proc, 10);
275: --
276: -- Declare cursors and local variables
277: --
278: l_proc varchar2(72) := g_package||'update_ELIG_OBJ_ELIG_PROFL';
279: l_object_version_number ben_elig_obj_elig_profl_f.object_version_number%TYPE;
280: l_effective_start_date ben_elig_obj_elig_profl_f.effective_start_date%TYPE;
281: l_effective_end_date ben_elig_obj_elig_profl_f.effective_end_date%TYPE;
282: --
283: begin
276: -- Declare cursors and local variables
277: --
278: l_proc varchar2(72) := g_package||'update_ELIG_OBJ_ELIG_PROFL';
279: l_object_version_number ben_elig_obj_elig_profl_f.object_version_number%TYPE;
280: l_effective_start_date ben_elig_obj_elig_profl_f.effective_start_date%TYPE;
281: l_effective_end_date ben_elig_obj_elig_profl_f.effective_end_date%TYPE;
282: --
283: begin
284: --
277: --
278: l_proc varchar2(72) := g_package||'update_ELIG_OBJ_ELIG_PROFL';
279: l_object_version_number ben_elig_obj_elig_profl_f.object_version_number%TYPE;
280: l_effective_start_date ben_elig_obj_elig_profl_f.effective_start_date%TYPE;
281: l_effective_end_date ben_elig_obj_elig_profl_f.effective_end_date%TYPE;
282: --
283: begin
284: --
285: hr_utility.set_location('Entering:'|| l_proc, 10);
480: --
481: -- Declare cursors and local variables
482: --
483: l_proc varchar2(72) := g_package||'update_ELIG_OBJ_ELIG_PROFL';
484: l_object_version_number ben_elig_obj_elig_profl_f.object_version_number%TYPE;
485: l_effective_start_date ben_elig_obj_elig_profl_f.effective_start_date%TYPE;
486: l_effective_end_date ben_elig_obj_elig_profl_f.effective_end_date%TYPE;
487: --
488: begin
481: -- Declare cursors and local variables
482: --
483: l_proc varchar2(72) := g_package||'update_ELIG_OBJ_ELIG_PROFL';
484: l_object_version_number ben_elig_obj_elig_profl_f.object_version_number%TYPE;
485: l_effective_start_date ben_elig_obj_elig_profl_f.effective_start_date%TYPE;
486: l_effective_end_date ben_elig_obj_elig_profl_f.effective_end_date%TYPE;
487: --
488: begin
489: --
482: --
483: l_proc varchar2(72) := g_package||'update_ELIG_OBJ_ELIG_PROFL';
484: l_object_version_number ben_elig_obj_elig_profl_f.object_version_number%TYPE;
485: l_effective_start_date ben_elig_obj_elig_profl_f.effective_start_date%TYPE;
486: l_effective_end_date ben_elig_obj_elig_profl_f.effective_end_date%TYPE;
487: --
488: begin
489: --
490: hr_utility.set_location('Entering:'|| l_proc, 10);