65: ) is
66: --
67: -- Declare cursors and local variables
68: --
69: l_opt_id ben_opt_f.opt_id%TYPE;
70: l_effective_start_date ben_opt_f.effective_start_date%TYPE;
71: l_effective_end_date ben_opt_f.effective_end_date%TYPE;
72: l_proc varchar2(72) := g_package||'create_option_definition';
73: l_object_version_number ben_opt_f.object_version_number%TYPE;
66: --
67: -- Declare cursors and local variables
68: --
69: l_opt_id ben_opt_f.opt_id%TYPE;
70: l_effective_start_date ben_opt_f.effective_start_date%TYPE;
71: l_effective_end_date ben_opt_f.effective_end_date%TYPE;
72: l_proc varchar2(72) := g_package||'create_option_definition';
73: l_object_version_number ben_opt_f.object_version_number%TYPE;
74: --
67: -- Declare cursors and local variables
68: --
69: l_opt_id ben_opt_f.opt_id%TYPE;
70: l_effective_start_date ben_opt_f.effective_start_date%TYPE;
71: l_effective_end_date ben_opt_f.effective_end_date%TYPE;
72: l_proc varchar2(72) := g_package||'create_option_definition';
73: l_object_version_number ben_opt_f.object_version_number%TYPE;
74: --
75: begin
69: l_opt_id ben_opt_f.opt_id%TYPE;
70: l_effective_start_date ben_opt_f.effective_start_date%TYPE;
71: l_effective_end_date ben_opt_f.effective_end_date%TYPE;
72: l_proc varchar2(72) := g_package||'create_option_definition';
73: l_object_version_number ben_opt_f.object_version_number%TYPE;
74: --
75: begin
76: --
77: hr_utility.set_location('Entering:'|| l_proc, 10);
386: --
387: -- Declare cursors and local variables
388: --
389: l_proc varchar2(72) := g_package||'update_option_definition';
390: l_object_version_number ben_opt_f.object_version_number%TYPE;
391: l_effective_start_date ben_opt_f.effective_start_date%TYPE;
392: l_effective_end_date ben_opt_f.effective_end_date%TYPE;
393: --
394: l_group_opt_id number(15) ;
387: -- Declare cursors and local variables
388: --
389: l_proc varchar2(72) := g_package||'update_option_definition';
390: l_object_version_number ben_opt_f.object_version_number%TYPE;
391: l_effective_start_date ben_opt_f.effective_start_date%TYPE;
392: l_effective_end_date ben_opt_f.effective_end_date%TYPE;
393: --
394: l_group_opt_id number(15) ;
395: cursor c_ptp (p_opt_id in number) is
388: --
389: l_proc varchar2(72) := g_package||'update_option_definition';
390: l_object_version_number ben_opt_f.object_version_number%TYPE;
391: l_effective_start_date ben_opt_f.effective_start_date%TYPE;
392: l_effective_end_date ben_opt_f.effective_end_date%TYPE;
393: --
394: l_group_opt_id number(15) ;
395: cursor c_ptp (p_opt_id in number) is
396: select count(*)
684: --
685: -- Declare cursors and local variables
686: --
687: l_proc varchar2(72) := g_package||'update_option_definition';
688: l_object_version_number ben_opt_f.object_version_number%TYPE;
689: l_effective_start_date ben_opt_f.effective_start_date%TYPE;
690: l_effective_end_date ben_opt_f.effective_end_date%TYPE;
691: --
692: begin
685: -- Declare cursors and local variables
686: --
687: l_proc varchar2(72) := g_package||'update_option_definition';
688: l_object_version_number ben_opt_f.object_version_number%TYPE;
689: l_effective_start_date ben_opt_f.effective_start_date%TYPE;
690: l_effective_end_date ben_opt_f.effective_end_date%TYPE;
691: --
692: begin
693: --
686: --
687: l_proc varchar2(72) := g_package||'update_option_definition';
688: l_object_version_number ben_opt_f.object_version_number%TYPE;
689: l_effective_start_date ben_opt_f.effective_start_date%TYPE;
690: l_effective_end_date ben_opt_f.effective_end_date%TYPE;
691: --
692: begin
693: --
694: hr_utility.set_location('Entering:'|| l_proc, 10);