DBA Data[Home] [Help]

APPS.BEN_OPTION_DEFINITION_API dependencies on BEN_OPT_F

Line 69: l_opt_id ben_opt_f.opt_id%TYPE;

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;

Line 70: l_effective_start_date ben_opt_f.effective_start_date%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: --

Line 71: l_effective_end_date ben_opt_f.effective_end_date%TYPE;

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

Line 73: l_object_version_number ben_opt_f.object_version_number%TYPE;

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);

Line 390: l_object_version_number ben_opt_f.object_version_number%TYPE;

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) ;

Line 391: l_effective_start_date ben_opt_f.effective_start_date%TYPE;

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

Line 392: l_effective_end_date ben_opt_f.effective_end_date%TYPE;

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(*)

Line 688: l_object_version_number ben_opt_f.object_version_number%TYPE;

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

Line 689: l_effective_start_date ben_opt_f.effective_start_date%TYPE;

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: --

Line 690: l_effective_end_date ben_opt_f.effective_end_date%TYPE;

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);