58: ) is
59: --
60: -- Declare cursors and local variables
61: --
62: l_pl_gd_or_svc_id ben_pl_gd_or_svc_f.pl_gd_or_svc_id%TYPE;
63: l_effective_start_date ben_pl_gd_or_svc_f.effective_start_date%TYPE;
64: l_effective_end_date ben_pl_gd_or_svc_f.effective_end_date%TYPE;
65: l_proc varchar2(72) := g_package||'create_Plan_goods_services';
66: l_object_version_number ben_pl_gd_or_svc_f.object_version_number%TYPE;
59: --
60: -- Declare cursors and local variables
61: --
62: l_pl_gd_or_svc_id ben_pl_gd_or_svc_f.pl_gd_or_svc_id%TYPE;
63: l_effective_start_date ben_pl_gd_or_svc_f.effective_start_date%TYPE;
64: l_effective_end_date ben_pl_gd_or_svc_f.effective_end_date%TYPE;
65: l_proc varchar2(72) := g_package||'create_Plan_goods_services';
66: l_object_version_number ben_pl_gd_or_svc_f.object_version_number%TYPE;
67: --
60: -- Declare cursors and local variables
61: --
62: l_pl_gd_or_svc_id ben_pl_gd_or_svc_f.pl_gd_or_svc_id%TYPE;
63: l_effective_start_date ben_pl_gd_or_svc_f.effective_start_date%TYPE;
64: l_effective_end_date ben_pl_gd_or_svc_f.effective_end_date%TYPE;
65: l_proc varchar2(72) := g_package||'create_Plan_goods_services';
66: l_object_version_number ben_pl_gd_or_svc_f.object_version_number%TYPE;
67: --
68: begin
62: l_pl_gd_or_svc_id ben_pl_gd_or_svc_f.pl_gd_or_svc_id%TYPE;
63: l_effective_start_date ben_pl_gd_or_svc_f.effective_start_date%TYPE;
64: l_effective_end_date ben_pl_gd_or_svc_f.effective_end_date%TYPE;
65: l_proc varchar2(72) := g_package||'create_Plan_goods_services';
66: l_object_version_number ben_pl_gd_or_svc_f.object_version_number%TYPE;
67: --
68: begin
69: --
70: hr_utility.set_location('Entering:'|| l_proc, 10);
351: --
352: -- Declare cursors and local variables
353: --
354: l_proc varchar2(72) := g_package||'update_Plan_goods_services';
355: l_object_version_number ben_pl_gd_or_svc_f.object_version_number%TYPE;
356: l_effective_start_date ben_pl_gd_or_svc_f.effective_start_date%TYPE;
357: l_effective_end_date ben_pl_gd_or_svc_f.effective_end_date%TYPE;
358: --
359: begin
352: -- Declare cursors and local variables
353: --
354: l_proc varchar2(72) := g_package||'update_Plan_goods_services';
355: l_object_version_number ben_pl_gd_or_svc_f.object_version_number%TYPE;
356: l_effective_start_date ben_pl_gd_or_svc_f.effective_start_date%TYPE;
357: l_effective_end_date ben_pl_gd_or_svc_f.effective_end_date%TYPE;
358: --
359: begin
360: --
353: --
354: l_proc varchar2(72) := g_package||'update_Plan_goods_services';
355: l_object_version_number ben_pl_gd_or_svc_f.object_version_number%TYPE;
356: l_effective_start_date ben_pl_gd_or_svc_f.effective_start_date%TYPE;
357: l_effective_end_date ben_pl_gd_or_svc_f.effective_end_date%TYPE;
358: --
359: begin
360: --
361: hr_utility.set_location('Entering:'|| l_proc, 10);
605: --
606: -- Declare cursors and local variables
607: --
608: l_proc varchar2(72) := g_package||'update_Plan_goods_services';
609: l_object_version_number ben_pl_gd_or_svc_f.object_version_number%TYPE;
610: l_effective_start_date ben_pl_gd_or_svc_f.effective_start_date%TYPE;
611: l_effective_end_date ben_pl_gd_or_svc_f.effective_end_date%TYPE;
612: --
613: begin
606: -- Declare cursors and local variables
607: --
608: l_proc varchar2(72) := g_package||'update_Plan_goods_services';
609: l_object_version_number ben_pl_gd_or_svc_f.object_version_number%TYPE;
610: l_effective_start_date ben_pl_gd_or_svc_f.effective_start_date%TYPE;
611: l_effective_end_date ben_pl_gd_or_svc_f.effective_end_date%TYPE;
612: --
613: begin
614: --
607: --
608: l_proc varchar2(72) := g_package||'update_Plan_goods_services';
609: l_object_version_number ben_pl_gd_or_svc_f.object_version_number%TYPE;
610: l_effective_start_date ben_pl_gd_or_svc_f.effective_start_date%TYPE;
611: l_effective_end_date ben_pl_gd_or_svc_f.effective_end_date%TYPE;
612: --
613: begin
614: --
615: hr_utility.set_location('Entering:'|| l_proc, 10);