57: ) is
58: --
59: -- Declare cursors and local variables
60: --
61: l_pl_regy_bod_id ben_pl_regy_bod_f.pl_regy_bod_id%TYPE;
62: l_effective_start_date ben_pl_regy_bod_f.effective_start_date%TYPE;
63: l_effective_end_date ben_pl_regy_bod_f.effective_end_date%TYPE;
64: l_proc varchar2(72) := g_package||'create_Plan_Regulatory_body';
65: l_object_version_number ben_pl_regy_bod_f.object_version_number%TYPE;
58: --
59: -- Declare cursors and local variables
60: --
61: l_pl_regy_bod_id ben_pl_regy_bod_f.pl_regy_bod_id%TYPE;
62: l_effective_start_date ben_pl_regy_bod_f.effective_start_date%TYPE;
63: l_effective_end_date ben_pl_regy_bod_f.effective_end_date%TYPE;
64: l_proc varchar2(72) := g_package||'create_Plan_Regulatory_body';
65: l_object_version_number ben_pl_regy_bod_f.object_version_number%TYPE;
66: --
59: -- Declare cursors and local variables
60: --
61: l_pl_regy_bod_id ben_pl_regy_bod_f.pl_regy_bod_id%TYPE;
62: l_effective_start_date ben_pl_regy_bod_f.effective_start_date%TYPE;
63: l_effective_end_date ben_pl_regy_bod_f.effective_end_date%TYPE;
64: l_proc varchar2(72) := g_package||'create_Plan_Regulatory_body';
65: l_object_version_number ben_pl_regy_bod_f.object_version_number%TYPE;
66: --
67: begin
61: l_pl_regy_bod_id ben_pl_regy_bod_f.pl_regy_bod_id%TYPE;
62: l_effective_start_date ben_pl_regy_bod_f.effective_start_date%TYPE;
63: l_effective_end_date ben_pl_regy_bod_f.effective_end_date%TYPE;
64: l_proc varchar2(72) := g_package||'create_Plan_Regulatory_body';
65: l_object_version_number ben_pl_regy_bod_f.object_version_number%TYPE;
66: --
67: begin
68: --
69: hr_utility.set_location('Entering:'|| l_proc, 10);
335: --
336: -- Declare cursors and local variables
337: --
338: l_proc varchar2(72) := g_package||'update_Plan_Regulatory_body';
339: l_object_version_number ben_pl_regy_bod_f.object_version_number%TYPE;
340: l_effective_start_date ben_pl_regy_bod_f.effective_start_date%TYPE;
341: l_effective_end_date ben_pl_regy_bod_f.effective_end_date%TYPE;
342: --
343: begin
336: -- Declare cursors and local variables
337: --
338: l_proc varchar2(72) := g_package||'update_Plan_Regulatory_body';
339: l_object_version_number ben_pl_regy_bod_f.object_version_number%TYPE;
340: l_effective_start_date ben_pl_regy_bod_f.effective_start_date%TYPE;
341: l_effective_end_date ben_pl_regy_bod_f.effective_end_date%TYPE;
342: --
343: begin
344: --
337: --
338: l_proc varchar2(72) := g_package||'update_Plan_Regulatory_body';
339: l_object_version_number ben_pl_regy_bod_f.object_version_number%TYPE;
340: l_effective_start_date ben_pl_regy_bod_f.effective_start_date%TYPE;
341: l_effective_end_date ben_pl_regy_bod_f.effective_end_date%TYPE;
342: --
343: begin
344: --
345: hr_utility.set_location('Entering:'|| l_proc, 10);
574: --
575: -- Declare cursors and local variables
576: --
577: l_proc varchar2(72) := g_package||'update_Plan_Regulatory_body';
578: l_object_version_number ben_pl_regy_bod_f.object_version_number%TYPE;
579: l_effective_start_date ben_pl_regy_bod_f.effective_start_date%TYPE;
580: l_effective_end_date ben_pl_regy_bod_f.effective_end_date%TYPE;
581: --
582: begin
575: -- Declare cursors and local variables
576: --
577: l_proc varchar2(72) := g_package||'update_Plan_Regulatory_body';
578: l_object_version_number ben_pl_regy_bod_f.object_version_number%TYPE;
579: l_effective_start_date ben_pl_regy_bod_f.effective_start_date%TYPE;
580: l_effective_end_date ben_pl_regy_bod_f.effective_end_date%TYPE;
581: --
582: begin
583: --
576: --
577: l_proc varchar2(72) := g_package||'update_Plan_Regulatory_body';
578: l_object_version_number ben_pl_regy_bod_f.object_version_number%TYPE;
579: l_effective_start_date ben_pl_regy_bod_f.effective_start_date%TYPE;
580: l_effective_end_date ben_pl_regy_bod_f.effective_end_date%TYPE;
581: --
582: begin
583: --
584: hr_utility.set_location('Entering:'|| l_proc, 10);