63: ) is
64: --
65: -- Declare cursors and local variables
66: --
67: l_ler_chg_plip_enrt_id ben_ler_chg_plip_enrt_f.ler_chg_plip_enrt_id%TYPE;
68: l_effective_start_date ben_ler_chg_plip_enrt_f.effective_start_date%TYPE;
69: l_effective_end_date ben_ler_chg_plip_enrt_f.effective_end_date%TYPE;
70: l_proc varchar2(72) := g_package||'create_ler_chg_plan_enrt';
71: l_object_version_number ben_ler_chg_plip_enrt_f.object_version_number%TYPE;
64: --
65: -- Declare cursors and local variables
66: --
67: l_ler_chg_plip_enrt_id ben_ler_chg_plip_enrt_f.ler_chg_plip_enrt_id%TYPE;
68: l_effective_start_date ben_ler_chg_plip_enrt_f.effective_start_date%TYPE;
69: l_effective_end_date ben_ler_chg_plip_enrt_f.effective_end_date%TYPE;
70: l_proc varchar2(72) := g_package||'create_ler_chg_plan_enrt';
71: l_object_version_number ben_ler_chg_plip_enrt_f.object_version_number%TYPE;
72: --
65: -- Declare cursors and local variables
66: --
67: l_ler_chg_plip_enrt_id ben_ler_chg_plip_enrt_f.ler_chg_plip_enrt_id%TYPE;
68: l_effective_start_date ben_ler_chg_plip_enrt_f.effective_start_date%TYPE;
69: l_effective_end_date ben_ler_chg_plip_enrt_f.effective_end_date%TYPE;
70: l_proc varchar2(72) := g_package||'create_ler_chg_plan_enrt';
71: l_object_version_number ben_ler_chg_plip_enrt_f.object_version_number%TYPE;
72: --
73: begin
67: l_ler_chg_plip_enrt_id ben_ler_chg_plip_enrt_f.ler_chg_plip_enrt_id%TYPE;
68: l_effective_start_date ben_ler_chg_plip_enrt_f.effective_start_date%TYPE;
69: l_effective_end_date ben_ler_chg_plip_enrt_f.effective_end_date%TYPE;
70: l_proc varchar2(72) := g_package||'create_ler_chg_plan_enrt';
71: l_object_version_number ben_ler_chg_plip_enrt_f.object_version_number%TYPE;
72: --
73: begin
74: --
75: hr_utility.set_location('Entering:'|| l_proc, 10);
374: --
375: -- Declare cursors and local variables
376: --
377: l_proc varchar2(72) := g_package||'update_ler_chg_plan_enrt';
378: l_object_version_number ben_ler_chg_plip_enrt_f.object_version_number%TYPE;
379: l_effective_start_date ben_ler_chg_plip_enrt_f.effective_start_date%TYPE;
380: l_effective_end_date ben_ler_chg_plip_enrt_f.effective_end_date%TYPE;
381: --
382: begin
375: -- Declare cursors and local variables
376: --
377: l_proc varchar2(72) := g_package||'update_ler_chg_plan_enrt';
378: l_object_version_number ben_ler_chg_plip_enrt_f.object_version_number%TYPE;
379: l_effective_start_date ben_ler_chg_plip_enrt_f.effective_start_date%TYPE;
380: l_effective_end_date ben_ler_chg_plip_enrt_f.effective_end_date%TYPE;
381: --
382: begin
383: --
376: --
377: l_proc varchar2(72) := g_package||'update_ler_chg_plan_enrt';
378: l_object_version_number ben_ler_chg_plip_enrt_f.object_version_number%TYPE;
379: l_effective_start_date ben_ler_chg_plip_enrt_f.effective_start_date%TYPE;
380: l_effective_end_date ben_ler_chg_plip_enrt_f.effective_end_date%TYPE;
381: --
382: begin
383: --
384: hr_utility.set_location('Entering:'|| l_proc, 10);
639: --
640: -- Declare cursors and local variables
641: --
642: l_proc varchar2(72) := g_package||'update_ler_chg_plan_enrt';
643: l_object_version_number ben_ler_chg_plip_enrt_f.object_version_number%TYPE;
644: l_effective_start_date ben_ler_chg_plip_enrt_f.effective_start_date%TYPE;
645: l_effective_end_date ben_ler_chg_plip_enrt_f.effective_end_date%TYPE;
646: --
647: begin
640: -- Declare cursors and local variables
641: --
642: l_proc varchar2(72) := g_package||'update_ler_chg_plan_enrt';
643: l_object_version_number ben_ler_chg_plip_enrt_f.object_version_number%TYPE;
644: l_effective_start_date ben_ler_chg_plip_enrt_f.effective_start_date%TYPE;
645: l_effective_end_date ben_ler_chg_plip_enrt_f.effective_end_date%TYPE;
646: --
647: begin
648: --
641: --
642: l_proc varchar2(72) := g_package||'update_ler_chg_plan_enrt';
643: l_object_version_number ben_ler_chg_plip_enrt_f.object_version_number%TYPE;
644: l_effective_start_date ben_ler_chg_plip_enrt_f.effective_start_date%TYPE;
645: l_effective_end_date ben_ler_chg_plip_enrt_f.effective_end_date%TYPE;
646: --
647: begin
648: --
649: hr_utility.set_location('Entering:'|| l_proc, 10);