APPS.BEN_ELIGY_PROFILE_API dependencies on BEN_ELIGY_PRFL_F

Line 124: l_eligy_prfl_id ben_eligy_prfl_f.eligy_prfl_id%TYPE;

120: ) is
121: --
122: -- Declare cursors and local variables
123: --
124: l_eligy_prfl_id ben_eligy_prfl_f.eligy_prfl_id%TYPE;
125: l_effective_start_date ben_eligy_prfl_f.effective_start_date%TYPE;
126: l_effective_end_date ben_eligy_prfl_f.effective_end_date%TYPE;
127: l_proc varchar2(72) := g_package||'create_ELIGY_PROFILE';
128: l_object_version_number ben_eligy_prfl_f.object_version_number%TYPE;

Line 125: l_effective_start_date ben_eligy_prfl_f.effective_start_date%TYPE;

121: --
122: -- Declare cursors and local variables
123: --
124: l_eligy_prfl_id ben_eligy_prfl_f.eligy_prfl_id%TYPE;
125: l_effective_start_date ben_eligy_prfl_f.effective_start_date%TYPE;
126: l_effective_end_date ben_eligy_prfl_f.effective_end_date%TYPE;
127: l_proc varchar2(72) := g_package||'create_ELIGY_PROFILE';
128: l_object_version_number ben_eligy_prfl_f.object_version_number%TYPE;
129: --

Line 126: l_effective_end_date ben_eligy_prfl_f.effective_end_date%TYPE;

122: -- Declare cursors and local variables
123: --
124: l_eligy_prfl_id ben_eligy_prfl_f.eligy_prfl_id%TYPE;
125: l_effective_start_date ben_eligy_prfl_f.effective_start_date%TYPE;
126: l_effective_end_date ben_eligy_prfl_f.effective_end_date%TYPE;
127: l_proc varchar2(72) := g_package||'create_ELIGY_PROFILE';
128: l_object_version_number ben_eligy_prfl_f.object_version_number%TYPE;
129: --
130: begin

Line 128: l_object_version_number ben_eligy_prfl_f.object_version_number%TYPE;

124: l_eligy_prfl_id ben_eligy_prfl_f.eligy_prfl_id%TYPE;
125: l_effective_start_date ben_eligy_prfl_f.effective_start_date%TYPE;
126: l_effective_end_date ben_eligy_prfl_f.effective_end_date%TYPE;
127: l_proc varchar2(72) := g_package||'create_ELIGY_PROFILE';
128: l_object_version_number ben_eligy_prfl_f.object_version_number%TYPE;
129: --
130: begin
131: --
132: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 661: l_object_version_number ben_eligy_prfl_f.object_version_number%TYPE;

657: --
658: -- Declare cursors and local variables
659: --
660: l_proc varchar2(72) := g_package||'update_ELIGY_PROFILE';
661: l_object_version_number ben_eligy_prfl_f.object_version_number%TYPE;
662: l_effective_start_date ben_eligy_prfl_f.effective_start_date%TYPE;
663: l_effective_end_date ben_eligy_prfl_f.effective_end_date%TYPE;
664: --
665: begin

Line 662: l_effective_start_date ben_eligy_prfl_f.effective_start_date%TYPE;

658: -- Declare cursors and local variables
659: --
660: l_proc varchar2(72) := g_package||'update_ELIGY_PROFILE';
661: l_object_version_number ben_eligy_prfl_f.object_version_number%TYPE;
662: l_effective_start_date ben_eligy_prfl_f.effective_start_date%TYPE;
663: l_effective_end_date ben_eligy_prfl_f.effective_end_date%TYPE;
664: --
665: begin
666: --

Line 663: l_effective_end_date ben_eligy_prfl_f.effective_end_date%TYPE;

659: --
660: l_proc varchar2(72) := g_package||'update_ELIGY_PROFILE';
661: l_object_version_number ben_eligy_prfl_f.object_version_number%TYPE;
662: l_effective_start_date ben_eligy_prfl_f.effective_start_date%TYPE;
663: l_effective_end_date ben_eligy_prfl_f.effective_end_date%TYPE;
664: --
665: begin
666: --
667: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 2696: l_object_version_number ben_eligy_prfl_f.object_version_number%TYPE;

2692: --
2693: -- Declare cursors and local variables
2694: --
2695: l_proc varchar2(72) := g_package||'update_ELIGY_PROFILE';
2696: l_object_version_number ben_eligy_prfl_f.object_version_number%TYPE;
2697: l_effective_start_date ben_eligy_prfl_f.effective_start_date%TYPE;
2698: l_effective_end_date ben_eligy_prfl_f.effective_end_date%TYPE;
2699: --
2700: begin

Line 2697: l_effective_start_date ben_eligy_prfl_f.effective_start_date%TYPE;

2693: -- Declare cursors and local variables
2694: --
2695: l_proc varchar2(72) := g_package||'update_ELIGY_PROFILE';
2696: l_object_version_number ben_eligy_prfl_f.object_version_number%TYPE;
2697: l_effective_start_date ben_eligy_prfl_f.effective_start_date%TYPE;
2698: l_effective_end_date ben_eligy_prfl_f.effective_end_date%TYPE;
2699: --
2700: begin
2701: --

Line 2698: l_effective_end_date ben_eligy_prfl_f.effective_end_date%TYPE;

2694: --
2695: l_proc varchar2(72) := g_package||'update_ELIGY_PROFILE';
2696: l_object_version_number ben_eligy_prfl_f.object_version_number%TYPE;
2697: l_effective_start_date ben_eligy_prfl_f.effective_start_date%TYPE;
2698: l_effective_end_date ben_eligy_prfl_f.effective_end_date%TYPE;
2699: --
2700: begin
2701: --
2702: hr_utility.set_location('Entering:'|| l_proc, 10);