206: ) is
207: --
208: -- Declare cursors and local variables
209: --
210: l_pl_id ben_pl_f.pl_id%TYPE;
211: l_effective_start_date ben_pl_f.effective_start_date%TYPE;
212: l_effective_end_date ben_pl_f.effective_end_date%TYPE;
213: l_proc varchar2(72) := g_package||'create_Plan';
214: l_object_version_number ben_pl_f.object_version_number%TYPE;
207: --
208: -- Declare cursors and local variables
209: --
210: l_pl_id ben_pl_f.pl_id%TYPE;
211: l_effective_start_date ben_pl_f.effective_start_date%TYPE;
212: l_effective_end_date ben_pl_f.effective_end_date%TYPE;
213: l_proc varchar2(72) := g_package||'create_Plan';
214: l_object_version_number ben_pl_f.object_version_number%TYPE;
215: --
208: -- Declare cursors and local variables
209: --
210: l_pl_id ben_pl_f.pl_id%TYPE;
211: l_effective_start_date ben_pl_f.effective_start_date%TYPE;
212: l_effective_end_date ben_pl_f.effective_end_date%TYPE;
213: l_proc varchar2(72) := g_package||'create_Plan';
214: l_object_version_number ben_pl_f.object_version_number%TYPE;
215: --
216: begin
210: l_pl_id ben_pl_f.pl_id%TYPE;
211: l_effective_start_date ben_pl_f.effective_start_date%TYPE;
212: l_effective_end_date ben_pl_f.effective_end_date%TYPE;
213: l_proc varchar2(72) := g_package||'create_Plan';
214: l_object_version_number ben_pl_f.object_version_number%TYPE;
215: --
216: begin
217: --
218: hr_utility.set_location('Entering:'|| l_proc, 10);
1087: --
1088: -- Declare cursors and local variables
1089: --
1090: l_proc varchar2(72) := g_package||'update_Plan';
1091: l_object_version_number ben_pl_f.object_version_number%TYPE;
1092: l_effective_start_date ben_pl_f.effective_start_date%TYPE;
1093: l_effective_end_date ben_pl_f.effective_end_date%TYPE;
1094: --
1095: begin
1088: -- Declare cursors and local variables
1089: --
1090: l_proc varchar2(72) := g_package||'update_Plan';
1091: l_object_version_number ben_pl_f.object_version_number%TYPE;
1092: l_effective_start_date ben_pl_f.effective_start_date%TYPE;
1093: l_effective_end_date ben_pl_f.effective_end_date%TYPE;
1094: --
1095: begin
1096: --
1089: --
1090: l_proc varchar2(72) := g_package||'update_Plan';
1091: l_object_version_number ben_pl_f.object_version_number%TYPE;
1092: l_effective_start_date ben_pl_f.effective_start_date%TYPE;
1093: l_effective_end_date ben_pl_f.effective_end_date%TYPE;
1094: --
1095: begin
1096: --
1097: hr_utility.set_location('Entering:'|| l_proc, 10);
1782: --
1783: -- Declare cursors and local variables
1784: --
1785: l_proc varchar2(72) := g_package||'update_Plan';
1786: l_object_version_number ben_pl_f.object_version_number%TYPE;
1787: l_effective_start_date ben_pl_f.effective_start_date%TYPE;
1788: l_effective_end_date ben_pl_f.effective_end_date%TYPE;
1789: --
1790: begin
1783: -- Declare cursors and local variables
1784: --
1785: l_proc varchar2(72) := g_package||'update_Plan';
1786: l_object_version_number ben_pl_f.object_version_number%TYPE;
1787: l_effective_start_date ben_pl_f.effective_start_date%TYPE;
1788: l_effective_end_date ben_pl_f.effective_end_date%TYPE;
1789: --
1790: begin
1791: --
1784: --
1785: l_proc varchar2(72) := g_package||'update_Plan';
1786: l_object_version_number ben_pl_f.object_version_number%TYPE;
1787: l_effective_start_date ben_pl_f.effective_start_date%TYPE;
1788: l_effective_end_date ben_pl_f.effective_end_date%TYPE;
1789: --
1790: begin
1791: --
1792: hr_utility.set_location('Entering:'|| l_proc, 10);