DBA Data[Home] [Help]

APPS.BEN_ELIG_OBJ_ELIG_PROFL_API dependencies on BEN_ELIG_OBJ_ELIG_PROFL_F

Line 48: l_elig_obj_elig_prfl_id ben_elig_obj_elig_profl_f.elig_obj_elig_prfl_id%TYPE;

44: ) is
45: --
46: -- Declare cursors and local variables
47: --
48: l_elig_obj_elig_prfl_id ben_elig_obj_elig_profl_f.elig_obj_elig_prfl_id%TYPE;
49: l_effective_start_date ben_elig_obj_elig_profl_f.effective_start_date%TYPE;
50: l_effective_end_date ben_elig_obj_elig_profl_f.effective_end_date%TYPE;
51: l_proc varchar2(72) := g_package||'create_ELIG_OBJ_ELIG_PROFL';
52: l_object_version_number ben_elig_obj_elig_profl_f.object_version_number%TYPE;

Line 49: l_effective_start_date ben_elig_obj_elig_profl_f.effective_start_date%TYPE;

45: --
46: -- Declare cursors and local variables
47: --
48: l_elig_obj_elig_prfl_id ben_elig_obj_elig_profl_f.elig_obj_elig_prfl_id%TYPE;
49: l_effective_start_date ben_elig_obj_elig_profl_f.effective_start_date%TYPE;
50: l_effective_end_date ben_elig_obj_elig_profl_f.effective_end_date%TYPE;
51: l_proc varchar2(72) := g_package||'create_ELIG_OBJ_ELIG_PROFL';
52: l_object_version_number ben_elig_obj_elig_profl_f.object_version_number%TYPE;
53: --

Line 50: l_effective_end_date ben_elig_obj_elig_profl_f.effective_end_date%TYPE;

46: -- Declare cursors and local variables
47: --
48: l_elig_obj_elig_prfl_id ben_elig_obj_elig_profl_f.elig_obj_elig_prfl_id%TYPE;
49: l_effective_start_date ben_elig_obj_elig_profl_f.effective_start_date%TYPE;
50: l_effective_end_date ben_elig_obj_elig_profl_f.effective_end_date%TYPE;
51: l_proc varchar2(72) := g_package||'create_ELIG_OBJ_ELIG_PROFL';
52: l_object_version_number ben_elig_obj_elig_profl_f.object_version_number%TYPE;
53: --
54: begin

Line 52: l_object_version_number ben_elig_obj_elig_profl_f.object_version_number%TYPE;

48: l_elig_obj_elig_prfl_id ben_elig_obj_elig_profl_f.elig_obj_elig_prfl_id%TYPE;
49: l_effective_start_date ben_elig_obj_elig_profl_f.effective_start_date%TYPE;
50: l_effective_end_date ben_elig_obj_elig_profl_f.effective_end_date%TYPE;
51: l_proc varchar2(72) := g_package||'create_ELIG_OBJ_ELIG_PROFL';
52: l_object_version_number ben_elig_obj_elig_profl_f.object_version_number%TYPE;
53: --
54: begin
55: --
56: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 279: l_object_version_number ben_elig_obj_elig_profl_f.object_version_number%TYPE;

275: --
276: -- Declare cursors and local variables
277: --
278: l_proc varchar2(72) := g_package||'update_ELIG_OBJ_ELIG_PROFL';
279: l_object_version_number ben_elig_obj_elig_profl_f.object_version_number%TYPE;
280: l_effective_start_date ben_elig_obj_elig_profl_f.effective_start_date%TYPE;
281: l_effective_end_date ben_elig_obj_elig_profl_f.effective_end_date%TYPE;
282: --
283: begin

Line 280: l_effective_start_date ben_elig_obj_elig_profl_f.effective_start_date%TYPE;

276: -- Declare cursors and local variables
277: --
278: l_proc varchar2(72) := g_package||'update_ELIG_OBJ_ELIG_PROFL';
279: l_object_version_number ben_elig_obj_elig_profl_f.object_version_number%TYPE;
280: l_effective_start_date ben_elig_obj_elig_profl_f.effective_start_date%TYPE;
281: l_effective_end_date ben_elig_obj_elig_profl_f.effective_end_date%TYPE;
282: --
283: begin
284: --

Line 281: l_effective_end_date ben_elig_obj_elig_profl_f.effective_end_date%TYPE;

277: --
278: l_proc varchar2(72) := g_package||'update_ELIG_OBJ_ELIG_PROFL';
279: l_object_version_number ben_elig_obj_elig_profl_f.object_version_number%TYPE;
280: l_effective_start_date ben_elig_obj_elig_profl_f.effective_start_date%TYPE;
281: l_effective_end_date ben_elig_obj_elig_profl_f.effective_end_date%TYPE;
282: --
283: begin
284: --
285: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 484: l_object_version_number ben_elig_obj_elig_profl_f.object_version_number%TYPE;

480: --
481: -- Declare cursors and local variables
482: --
483: l_proc varchar2(72) := g_package||'update_ELIG_OBJ_ELIG_PROFL';
484: l_object_version_number ben_elig_obj_elig_profl_f.object_version_number%TYPE;
485: l_effective_start_date ben_elig_obj_elig_profl_f.effective_start_date%TYPE;
486: l_effective_end_date ben_elig_obj_elig_profl_f.effective_end_date%TYPE;
487: --
488: begin

Line 485: l_effective_start_date ben_elig_obj_elig_profl_f.effective_start_date%TYPE;

481: -- Declare cursors and local variables
482: --
483: l_proc varchar2(72) := g_package||'update_ELIG_OBJ_ELIG_PROFL';
484: l_object_version_number ben_elig_obj_elig_profl_f.object_version_number%TYPE;
485: l_effective_start_date ben_elig_obj_elig_profl_f.effective_start_date%TYPE;
486: l_effective_end_date ben_elig_obj_elig_profl_f.effective_end_date%TYPE;
487: --
488: begin
489: --

Line 486: l_effective_end_date ben_elig_obj_elig_profl_f.effective_end_date%TYPE;

482: --
483: l_proc varchar2(72) := g_package||'update_ELIG_OBJ_ELIG_PROFL';
484: l_object_version_number ben_elig_obj_elig_profl_f.object_version_number%TYPE;
485: l_effective_start_date ben_elig_obj_elig_profl_f.effective_start_date%TYPE;
486: l_effective_end_date ben_elig_obj_elig_profl_f.effective_end_date%TYPE;
487: --
488: begin
489: --
490: hr_utility.set_location('Entering:'|| l_proc, 10);