54: ) is
55: --
56: -- Declare cursors and local variables
57: --
58: l_css_rltd_per_per_in_ler_id ben_css_rltd_per_per_in_ler_f.css_rltd_per_per_in_ler_id%TYPE;
59: l_effective_start_date ben_css_rltd_per_per_in_ler_f.effective_start_date%TYPE;
60: l_effective_end_date ben_css_rltd_per_per_in_ler_f.effective_end_date%TYPE;
61: l_proc varchar2(72) := g_package||'create_Css_Rltd_Per_in_Ler';
62: l_object_version_number ben_css_rltd_per_per_in_ler_f.object_version_number%TYPE;
55: --
56: -- Declare cursors and local variables
57: --
58: l_css_rltd_per_per_in_ler_id ben_css_rltd_per_per_in_ler_f.css_rltd_per_per_in_ler_id%TYPE;
59: l_effective_start_date ben_css_rltd_per_per_in_ler_f.effective_start_date%TYPE;
60: l_effective_end_date ben_css_rltd_per_per_in_ler_f.effective_end_date%TYPE;
61: l_proc varchar2(72) := g_package||'create_Css_Rltd_Per_in_Ler';
62: l_object_version_number ben_css_rltd_per_per_in_ler_f.object_version_number%TYPE;
63: --
56: -- Declare cursors and local variables
57: --
58: l_css_rltd_per_per_in_ler_id ben_css_rltd_per_per_in_ler_f.css_rltd_per_per_in_ler_id%TYPE;
59: l_effective_start_date ben_css_rltd_per_per_in_ler_f.effective_start_date%TYPE;
60: l_effective_end_date ben_css_rltd_per_per_in_ler_f.effective_end_date%TYPE;
61: l_proc varchar2(72) := g_package||'create_Css_Rltd_Per_in_Ler';
62: l_object_version_number ben_css_rltd_per_per_in_ler_f.object_version_number%TYPE;
63: --
64: begin
58: l_css_rltd_per_per_in_ler_id ben_css_rltd_per_per_in_ler_f.css_rltd_per_per_in_ler_id%TYPE;
59: l_effective_start_date ben_css_rltd_per_per_in_ler_f.effective_start_date%TYPE;
60: l_effective_end_date ben_css_rltd_per_per_in_ler_f.effective_end_date%TYPE;
61: l_proc varchar2(72) := g_package||'create_Css_Rltd_Per_in_Ler';
62: l_object_version_number ben_css_rltd_per_per_in_ler_f.object_version_number%TYPE;
63: --
64: begin
65: --
66: hr_utility.set_location('Entering:'|| l_proc, 10);
329: --
330: -- Declare cursors and local variables
331: --
332: l_proc varchar2(72) := g_package||'update_Css_Rltd_Per_in_Ler';
333: l_object_version_number ben_css_rltd_per_per_in_ler_f.object_version_number%TYPE;
334: l_effective_start_date ben_css_rltd_per_per_in_ler_f.effective_start_date%TYPE;
335: l_effective_end_date ben_css_rltd_per_per_in_ler_f.effective_end_date%TYPE;
336: --
337: begin
330: -- Declare cursors and local variables
331: --
332: l_proc varchar2(72) := g_package||'update_Css_Rltd_Per_in_Ler';
333: l_object_version_number ben_css_rltd_per_per_in_ler_f.object_version_number%TYPE;
334: l_effective_start_date ben_css_rltd_per_per_in_ler_f.effective_start_date%TYPE;
335: l_effective_end_date ben_css_rltd_per_per_in_ler_f.effective_end_date%TYPE;
336: --
337: begin
338: --
331: --
332: l_proc varchar2(72) := g_package||'update_Css_Rltd_Per_in_Ler';
333: l_object_version_number ben_css_rltd_per_per_in_ler_f.object_version_number%TYPE;
334: l_effective_start_date ben_css_rltd_per_per_in_ler_f.effective_start_date%TYPE;
335: l_effective_end_date ben_css_rltd_per_per_in_ler_f.effective_end_date%TYPE;
336: --
337: begin
338: --
339: hr_utility.set_location('Entering:'|| l_proc, 10);
569: --
570: -- Declare cursors and local variables
571: --
572: l_proc varchar2(72) := g_package||'update_Css_Rltd_Per_in_Ler';
573: l_object_version_number ben_css_rltd_per_per_in_ler_f.object_version_number%TYPE;
574: l_effective_start_date ben_css_rltd_per_per_in_ler_f.effective_start_date%TYPE;
575: l_effective_end_date ben_css_rltd_per_per_in_ler_f.effective_end_date%TYPE;
576: --
577: begin
570: -- Declare cursors and local variables
571: --
572: l_proc varchar2(72) := g_package||'update_Css_Rltd_Per_in_Ler';
573: l_object_version_number ben_css_rltd_per_per_in_ler_f.object_version_number%TYPE;
574: l_effective_start_date ben_css_rltd_per_per_in_ler_f.effective_start_date%TYPE;
575: l_effective_end_date ben_css_rltd_per_per_in_ler_f.effective_end_date%TYPE;
576: --
577: begin
578: --
571: --
572: l_proc varchar2(72) := g_package||'update_Css_Rltd_Per_in_Ler';
573: l_object_version_number ben_css_rltd_per_per_in_ler_f.object_version_number%TYPE;
574: l_effective_start_date ben_css_rltd_per_per_in_ler_f.effective_start_date%TYPE;
575: l_effective_end_date ben_css_rltd_per_per_in_ler_f.effective_end_date%TYPE;
576: --
577: begin
578: --
579: hr_utility.set_location('Entering:'|| l_proc, 10);