DBA Data[Home] [Help]

APPS.BEN_LIFE_EVENT_ENROLL_RSN_API dependencies on BEN_LEE_RSN_F

Line 80: l_lee_rsn_id ben_lee_rsn_f.lee_rsn_id%TYPE;

76: ) is
77: --
78: -- Declare cursors and local variables
79: --
80: l_lee_rsn_id ben_lee_rsn_f.lee_rsn_id%TYPE;
81: l_effective_start_date ben_lee_rsn_f.effective_start_date%TYPE;
82: l_effective_end_date ben_lee_rsn_f.effective_end_date%TYPE;
83: l_proc varchar2(72) := g_package||'create_Life_Event_Enroll_Rsn';
84: l_object_version_number ben_lee_rsn_f.object_version_number%TYPE;

Line 81: l_effective_start_date ben_lee_rsn_f.effective_start_date%TYPE;

77: --
78: -- Declare cursors and local variables
79: --
80: l_lee_rsn_id ben_lee_rsn_f.lee_rsn_id%TYPE;
81: l_effective_start_date ben_lee_rsn_f.effective_start_date%TYPE;
82: l_effective_end_date ben_lee_rsn_f.effective_end_date%TYPE;
83: l_proc varchar2(72) := g_package||'create_Life_Event_Enroll_Rsn';
84: l_object_version_number ben_lee_rsn_f.object_version_number%TYPE;
85: --

Line 82: l_effective_end_date ben_lee_rsn_f.effective_end_date%TYPE;

78: -- Declare cursors and local variables
79: --
80: l_lee_rsn_id ben_lee_rsn_f.lee_rsn_id%TYPE;
81: l_effective_start_date ben_lee_rsn_f.effective_start_date%TYPE;
82: l_effective_end_date ben_lee_rsn_f.effective_end_date%TYPE;
83: l_proc varchar2(72) := g_package||'create_Life_Event_Enroll_Rsn';
84: l_object_version_number ben_lee_rsn_f.object_version_number%TYPE;
85: --
86: begin

Line 84: l_object_version_number ben_lee_rsn_f.object_version_number%TYPE;

80: l_lee_rsn_id ben_lee_rsn_f.lee_rsn_id%TYPE;
81: l_effective_start_date ben_lee_rsn_f.effective_start_date%TYPE;
82: l_effective_end_date ben_lee_rsn_f.effective_end_date%TYPE;
83: l_proc varchar2(72) := g_package||'create_Life_Event_Enroll_Rsn';
84: l_object_version_number ben_lee_rsn_f.object_version_number%TYPE;
85: --
86: begin
87: --
88: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 439: l_object_version_number ben_lee_rsn_f.object_version_number%TYPE;

435: --
436: -- Declare cursors and local variables
437: --
438: l_proc varchar2(72) := g_package||'update_Life_Event_Enroll_Rsn';
439: l_object_version_number ben_lee_rsn_f.object_version_number%TYPE;
440: l_effective_start_date ben_lee_rsn_f.effective_start_date%TYPE;
441: l_effective_end_date ben_lee_rsn_f.effective_end_date%TYPE;
442: --
443: begin

Line 440: l_effective_start_date ben_lee_rsn_f.effective_start_date%TYPE;

436: -- Declare cursors and local variables
437: --
438: l_proc varchar2(72) := g_package||'update_Life_Event_Enroll_Rsn';
439: l_object_version_number ben_lee_rsn_f.object_version_number%TYPE;
440: l_effective_start_date ben_lee_rsn_f.effective_start_date%TYPE;
441: l_effective_end_date ben_lee_rsn_f.effective_end_date%TYPE;
442: --
443: begin
444: --

Line 441: l_effective_end_date ben_lee_rsn_f.effective_end_date%TYPE;

437: --
438: l_proc varchar2(72) := g_package||'update_Life_Event_Enroll_Rsn';
439: l_object_version_number ben_lee_rsn_f.object_version_number%TYPE;
440: l_effective_start_date ben_lee_rsn_f.effective_start_date%TYPE;
441: l_effective_end_date ben_lee_rsn_f.effective_end_date%TYPE;
442: --
443: begin
444: --
445: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 744: l_object_version_number ben_lee_rsn_f.object_version_number%TYPE;

740: --
741: -- Declare cursors and local variables
742: --
743: l_proc varchar2(72) := g_package||'update_Life_Event_Enroll_Rsn';
744: l_object_version_number ben_lee_rsn_f.object_version_number%TYPE;
745: l_effective_start_date ben_lee_rsn_f.effective_start_date%TYPE;
746: l_effective_end_date ben_lee_rsn_f.effective_end_date%TYPE;
747: --
748: begin

Line 745: l_effective_start_date ben_lee_rsn_f.effective_start_date%TYPE;

741: -- Declare cursors and local variables
742: --
743: l_proc varchar2(72) := g_package||'update_Life_Event_Enroll_Rsn';
744: l_object_version_number ben_lee_rsn_f.object_version_number%TYPE;
745: l_effective_start_date ben_lee_rsn_f.effective_start_date%TYPE;
746: l_effective_end_date ben_lee_rsn_f.effective_end_date%TYPE;
747: --
748: begin
749: --

Line 746: l_effective_end_date ben_lee_rsn_f.effective_end_date%TYPE;

742: --
743: l_proc varchar2(72) := g_package||'update_Life_Event_Enroll_Rsn';
744: l_object_version_number ben_lee_rsn_f.object_version_number%TYPE;
745: l_effective_start_date ben_lee_rsn_f.effective_start_date%TYPE;
746: l_effective_end_date ben_lee_rsn_f.effective_end_date%TYPE;
747: --
748: begin
749: --
750: hr_utility.set_location('Entering:'|| l_proc, 10);