60: ) is
61: --
62: -- Declare cursors and local variables
63: --
64: l_pl_regn_id ben_pl_regn_f.pl_regn_id%TYPE;
65: l_effective_end_date ben_pl_regn_f.effective_end_date%TYPE;
66: l_effective_start_date ben_pl_regn_f.effective_start_date%TYPE;
67: l_proc varchar2(72) := g_package||'create_Plan_regulation';
68: l_object_version_number ben_pl_regn_f.object_version_number%TYPE;
61: --
62: -- Declare cursors and local variables
63: --
64: l_pl_regn_id ben_pl_regn_f.pl_regn_id%TYPE;
65: l_effective_end_date ben_pl_regn_f.effective_end_date%TYPE;
66: l_effective_start_date ben_pl_regn_f.effective_start_date%TYPE;
67: l_proc varchar2(72) := g_package||'create_Plan_regulation';
68: l_object_version_number ben_pl_regn_f.object_version_number%TYPE;
69: --
62: -- Declare cursors and local variables
63: --
64: l_pl_regn_id ben_pl_regn_f.pl_regn_id%TYPE;
65: l_effective_end_date ben_pl_regn_f.effective_end_date%TYPE;
66: l_effective_start_date ben_pl_regn_f.effective_start_date%TYPE;
67: l_proc varchar2(72) := g_package||'create_Plan_regulation';
68: l_object_version_number ben_pl_regn_f.object_version_number%TYPE;
69: --
70: begin
64: l_pl_regn_id ben_pl_regn_f.pl_regn_id%TYPE;
65: l_effective_end_date ben_pl_regn_f.effective_end_date%TYPE;
66: l_effective_start_date ben_pl_regn_f.effective_start_date%TYPE;
67: l_proc varchar2(72) := g_package||'create_Plan_regulation';
68: l_object_version_number ben_pl_regn_f.object_version_number%TYPE;
69: --
70: begin
71: --
72: hr_utility.set_location('Entering:'|| l_proc, 10);
359: --
360: -- Declare cursors and local variables
361: --
362: l_proc varchar2(72) := g_package||'update_Plan_regulation';
363: l_object_version_number ben_pl_regn_f.object_version_number%TYPE;
364: l_effective_end_date ben_pl_regn_f.effective_end_date%TYPE;
365: l_effective_start_date ben_pl_regn_f.effective_start_date%TYPE;
366: --
367: begin
360: -- Declare cursors and local variables
361: --
362: l_proc varchar2(72) := g_package||'update_Plan_regulation';
363: l_object_version_number ben_pl_regn_f.object_version_number%TYPE;
364: l_effective_end_date ben_pl_regn_f.effective_end_date%TYPE;
365: l_effective_start_date ben_pl_regn_f.effective_start_date%TYPE;
366: --
367: begin
368: --
361: --
362: l_proc varchar2(72) := g_package||'update_Plan_regulation';
363: l_object_version_number ben_pl_regn_f.object_version_number%TYPE;
364: l_effective_end_date ben_pl_regn_f.effective_end_date%TYPE;
365: l_effective_start_date ben_pl_regn_f.effective_start_date%TYPE;
366: --
367: begin
368: --
369: hr_utility.set_location('Entering:'|| l_proc, 10);
617: --
618: -- Declare cursors and local variables
619: --
620: l_proc varchar2(72) := g_package||'update_Plan_regulation';
621: l_object_version_number ben_pl_regn_f.object_version_number%TYPE;
622: l_effective_end_date ben_pl_regn_f.effective_end_date%TYPE;
623: l_effective_start_date ben_pl_regn_f.effective_start_date%TYPE;
624: --
625: begin
618: -- Declare cursors and local variables
619: --
620: l_proc varchar2(72) := g_package||'update_Plan_regulation';
621: l_object_version_number ben_pl_regn_f.object_version_number%TYPE;
622: l_effective_end_date ben_pl_regn_f.effective_end_date%TYPE;
623: l_effective_start_date ben_pl_regn_f.effective_start_date%TYPE;
624: --
625: begin
626: --
619: --
620: l_proc varchar2(72) := g_package||'update_Plan_regulation';
621: l_object_version_number ben_pl_regn_f.object_version_number%TYPE;
622: l_effective_end_date ben_pl_regn_f.effective_end_date%TYPE;
623: l_effective_start_date ben_pl_regn_f.effective_start_date%TYPE;
624: --
625: begin
626: --
627: hr_utility.set_location('Entering:'|| l_proc, 10);