63: ) is
64: --
65: -- Declare cursors and local variables
66: --
67: l_ler_chg_pl_nip_enrt_id ben_ler_chg_pl_nip_enrt_f.ler_chg_pl_nip_enrt_id%TYPE;
68: l_effective_start_date ben_ler_chg_pl_nip_enrt_f.effective_start_date%TYPE;
69: l_effective_end_date ben_ler_chg_pl_nip_enrt_f.effective_end_date%TYPE;
70: l_proc varchar2(72) := g_package||'create_Ler_Chg_Pl_Nip_Enrt';
71: l_object_version_number ben_ler_chg_pl_nip_enrt_f.object_version_number%TYPE;
64: --
65: -- Declare cursors and local variables
66: --
67: l_ler_chg_pl_nip_enrt_id ben_ler_chg_pl_nip_enrt_f.ler_chg_pl_nip_enrt_id%TYPE;
68: l_effective_start_date ben_ler_chg_pl_nip_enrt_f.effective_start_date%TYPE;
69: l_effective_end_date ben_ler_chg_pl_nip_enrt_f.effective_end_date%TYPE;
70: l_proc varchar2(72) := g_package||'create_Ler_Chg_Pl_Nip_Enrt';
71: l_object_version_number ben_ler_chg_pl_nip_enrt_f.object_version_number%TYPE;
72: --
65: -- Declare cursors and local variables
66: --
67: l_ler_chg_pl_nip_enrt_id ben_ler_chg_pl_nip_enrt_f.ler_chg_pl_nip_enrt_id%TYPE;
68: l_effective_start_date ben_ler_chg_pl_nip_enrt_f.effective_start_date%TYPE;
69: l_effective_end_date ben_ler_chg_pl_nip_enrt_f.effective_end_date%TYPE;
70: l_proc varchar2(72) := g_package||'create_Ler_Chg_Pl_Nip_Enrt';
71: l_object_version_number ben_ler_chg_pl_nip_enrt_f.object_version_number%TYPE;
72: --
73: begin
67: l_ler_chg_pl_nip_enrt_id ben_ler_chg_pl_nip_enrt_f.ler_chg_pl_nip_enrt_id%TYPE;
68: l_effective_start_date ben_ler_chg_pl_nip_enrt_f.effective_start_date%TYPE;
69: l_effective_end_date ben_ler_chg_pl_nip_enrt_f.effective_end_date%TYPE;
70: l_proc varchar2(72) := g_package||'create_Ler_Chg_Pl_Nip_Enrt';
71: l_object_version_number ben_ler_chg_pl_nip_enrt_f.object_version_number%TYPE;
72: --
73: begin
74: --
75: hr_utility.set_location('Entering:'|| l_proc, 10);
370: --
371: -- Declare cursors and local variables
372: --
373: l_proc varchar2(72) := g_package||'update_Ler_Chg_Pl_Nip_Enrt';
374: l_object_version_number ben_ler_chg_pl_nip_enrt_f.object_version_number%TYPE;
375: l_effective_start_date ben_ler_chg_pl_nip_enrt_f.effective_start_date%TYPE;
376: l_effective_end_date ben_ler_chg_pl_nip_enrt_f.effective_end_date%TYPE;
377: --
378: begin
371: -- Declare cursors and local variables
372: --
373: l_proc varchar2(72) := g_package||'update_Ler_Chg_Pl_Nip_Enrt';
374: l_object_version_number ben_ler_chg_pl_nip_enrt_f.object_version_number%TYPE;
375: l_effective_start_date ben_ler_chg_pl_nip_enrt_f.effective_start_date%TYPE;
376: l_effective_end_date ben_ler_chg_pl_nip_enrt_f.effective_end_date%TYPE;
377: --
378: begin
379: --
372: --
373: l_proc varchar2(72) := g_package||'update_Ler_Chg_Pl_Nip_Enrt';
374: l_object_version_number ben_ler_chg_pl_nip_enrt_f.object_version_number%TYPE;
375: l_effective_start_date ben_ler_chg_pl_nip_enrt_f.effective_start_date%TYPE;
376: l_effective_end_date ben_ler_chg_pl_nip_enrt_f.effective_end_date%TYPE;
377: --
378: begin
379: --
380: hr_utility.set_location('Entering:'|| l_proc, 10);
632: --
633: -- Declare cursors and local variables
634: --
635: l_proc varchar2(72) := g_package||'update_Ler_Chg_Pl_Nip_Enrt';
636: l_object_version_number ben_ler_chg_pl_nip_enrt_f.object_version_number%TYPE;
637: l_effective_start_date ben_ler_chg_pl_nip_enrt_f.effective_start_date%TYPE;
638: l_effective_end_date ben_ler_chg_pl_nip_enrt_f.effective_end_date%TYPE;
639: --
640: begin
633: -- Declare cursors and local variables
634: --
635: l_proc varchar2(72) := g_package||'update_Ler_Chg_Pl_Nip_Enrt';
636: l_object_version_number ben_ler_chg_pl_nip_enrt_f.object_version_number%TYPE;
637: l_effective_start_date ben_ler_chg_pl_nip_enrt_f.effective_start_date%TYPE;
638: l_effective_end_date ben_ler_chg_pl_nip_enrt_f.effective_end_date%TYPE;
639: --
640: begin
641: --
634: --
635: l_proc varchar2(72) := g_package||'update_Ler_Chg_Pl_Nip_Enrt';
636: l_object_version_number ben_ler_chg_pl_nip_enrt_f.object_version_number%TYPE;
637: l_effective_start_date ben_ler_chg_pl_nip_enrt_f.effective_start_date%TYPE;
638: l_effective_end_date ben_ler_chg_pl_nip_enrt_f.effective_end_date%TYPE;
639: --
640: begin
641: --
642: hr_utility.set_location('Entering:'|| l_proc, 10);