64: ) is
65: --
66: -- Declare cursors and local variables
67: --
68: l_ler_chg_dpnt_cvg_id ben_ler_chg_dpnt_cvg_f.ler_chg_dpnt_cvg_id%TYPE;
69: l_effective_start_date ben_ler_chg_dpnt_cvg_f.effective_start_date%TYPE;
70: l_effective_end_date ben_ler_chg_dpnt_cvg_f.effective_end_date%TYPE;
71: l_proc varchar2(72) := g_package||'create_Ler_Chg_Dependent_Cvg';
72: l_object_version_number ben_ler_chg_dpnt_cvg_f.object_version_number%TYPE;
65: --
66: -- Declare cursors and local variables
67: --
68: l_ler_chg_dpnt_cvg_id ben_ler_chg_dpnt_cvg_f.ler_chg_dpnt_cvg_id%TYPE;
69: l_effective_start_date ben_ler_chg_dpnt_cvg_f.effective_start_date%TYPE;
70: l_effective_end_date ben_ler_chg_dpnt_cvg_f.effective_end_date%TYPE;
71: l_proc varchar2(72) := g_package||'create_Ler_Chg_Dependent_Cvg';
72: l_object_version_number ben_ler_chg_dpnt_cvg_f.object_version_number%TYPE;
73: --
66: -- Declare cursors and local variables
67: --
68: l_ler_chg_dpnt_cvg_id ben_ler_chg_dpnt_cvg_f.ler_chg_dpnt_cvg_id%TYPE;
69: l_effective_start_date ben_ler_chg_dpnt_cvg_f.effective_start_date%TYPE;
70: l_effective_end_date ben_ler_chg_dpnt_cvg_f.effective_end_date%TYPE;
71: l_proc varchar2(72) := g_package||'create_Ler_Chg_Dependent_Cvg';
72: l_object_version_number ben_ler_chg_dpnt_cvg_f.object_version_number%TYPE;
73: --
74: begin
68: l_ler_chg_dpnt_cvg_id ben_ler_chg_dpnt_cvg_f.ler_chg_dpnt_cvg_id%TYPE;
69: l_effective_start_date ben_ler_chg_dpnt_cvg_f.effective_start_date%TYPE;
70: l_effective_end_date ben_ler_chg_dpnt_cvg_f.effective_end_date%TYPE;
71: l_proc varchar2(72) := g_package||'create_Ler_Chg_Dependent_Cvg';
72: l_object_version_number ben_ler_chg_dpnt_cvg_f.object_version_number%TYPE;
73: --
74: begin
75: --
76: hr_utility.set_location('Entering:'|| l_proc, 10);
375: --
376: -- Declare cursors and local variables
377: --
378: l_proc varchar2(72) := g_package||'update_Ler_Chg_Dependent_Cvg';
379: l_object_version_number ben_ler_chg_dpnt_cvg_f.object_version_number%TYPE;
380: l_effective_start_date ben_ler_chg_dpnt_cvg_f.effective_start_date%TYPE;
381: l_effective_end_date ben_ler_chg_dpnt_cvg_f.effective_end_date%TYPE;
382: --
383: begin
376: -- Declare cursors and local variables
377: --
378: l_proc varchar2(72) := g_package||'update_Ler_Chg_Dependent_Cvg';
379: l_object_version_number ben_ler_chg_dpnt_cvg_f.object_version_number%TYPE;
380: l_effective_start_date ben_ler_chg_dpnt_cvg_f.effective_start_date%TYPE;
381: l_effective_end_date ben_ler_chg_dpnt_cvg_f.effective_end_date%TYPE;
382: --
383: begin
384: --
377: --
378: l_proc varchar2(72) := g_package||'update_Ler_Chg_Dependent_Cvg';
379: l_object_version_number ben_ler_chg_dpnt_cvg_f.object_version_number%TYPE;
380: l_effective_start_date ben_ler_chg_dpnt_cvg_f.effective_start_date%TYPE;
381: l_effective_end_date ben_ler_chg_dpnt_cvg_f.effective_end_date%TYPE;
382: --
383: begin
384: --
385: hr_utility.set_location('Entering:'|| l_proc, 10);
644: --
645: -- Declare cursors and local variables
646: --
647: l_proc varchar2(72) := g_package||'update_Ler_Chg_Dependent_Cvg';
648: l_object_version_number ben_ler_chg_dpnt_cvg_f.object_version_number%TYPE;
649: l_effective_start_date ben_ler_chg_dpnt_cvg_f.effective_start_date%TYPE;
650: l_effective_end_date ben_ler_chg_dpnt_cvg_f.effective_end_date%TYPE;
651: --
652: begin
645: -- Declare cursors and local variables
646: --
647: l_proc varchar2(72) := g_package||'update_Ler_Chg_Dependent_Cvg';
648: l_object_version_number ben_ler_chg_dpnt_cvg_f.object_version_number%TYPE;
649: l_effective_start_date ben_ler_chg_dpnt_cvg_f.effective_start_date%TYPE;
650: l_effective_end_date ben_ler_chg_dpnt_cvg_f.effective_end_date%TYPE;
651: --
652: begin
653: --
646: --
647: l_proc varchar2(72) := g_package||'update_Ler_Chg_Dependent_Cvg';
648: l_object_version_number ben_ler_chg_dpnt_cvg_f.object_version_number%TYPE;
649: l_effective_start_date ben_ler_chg_dpnt_cvg_f.effective_start_date%TYPE;
650: l_effective_end_date ben_ler_chg_dpnt_cvg_f.effective_end_date%TYPE;
651: --
652: begin
653: --
654: hr_utility.set_location('Entering:'|| l_proc, 10);