DBA Data[Home] [Help]

APPS.BEN_LIFE_EVENT_ENROLL_RSN_API dependencies on BEN_LEE_RSN_F

Line 81: l_lee_rsn_id ben_lee_rsn_f.lee_rsn_id%TYPE;

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

Line 82: l_effective_start_date ben_lee_rsn_f.effective_start_date%TYPE;

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

Line 83: l_effective_end_date ben_lee_rsn_f.effective_end_date%TYPE;

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

Line 85: l_object_version_number ben_lee_rsn_f.object_version_number%TYPE;

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

Line 444: l_object_version_number ben_lee_rsn_f.object_version_number%TYPE;

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

Line 445: l_effective_start_date ben_lee_rsn_f.effective_start_date%TYPE;

441: -- Declare cursors and local variables
442: --
443: l_proc varchar2(72) := g_package||'update_Life_Event_Enroll_Rsn';
444: l_object_version_number ben_lee_rsn_f.object_version_number%TYPE;
445: l_effective_start_date ben_lee_rsn_f.effective_start_date%TYPE;
446: l_effective_end_date ben_lee_rsn_f.effective_end_date%TYPE;
447: --
448: begin
449: --

Line 446: l_effective_end_date ben_lee_rsn_f.effective_end_date%TYPE;

442: --
443: l_proc varchar2(72) := g_package||'update_Life_Event_Enroll_Rsn';
444: l_object_version_number ben_lee_rsn_f.object_version_number%TYPE;
445: l_effective_start_date ben_lee_rsn_f.effective_start_date%TYPE;
446: l_effective_end_date ben_lee_rsn_f.effective_end_date%TYPE;
447: --
448: begin
449: --
450: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 752: l_object_version_number ben_lee_rsn_f.object_version_number%TYPE;

748: --
749: -- Declare cursors and local variables
750: --
751: l_proc varchar2(72) := g_package||'update_Life_Event_Enroll_Rsn';
752: l_object_version_number ben_lee_rsn_f.object_version_number%TYPE;
753: l_effective_start_date ben_lee_rsn_f.effective_start_date%TYPE;
754: l_effective_end_date ben_lee_rsn_f.effective_end_date%TYPE;
755: --
756: begin

Line 753: l_effective_start_date ben_lee_rsn_f.effective_start_date%TYPE;

749: -- Declare cursors and local variables
750: --
751: l_proc varchar2(72) := g_package||'update_Life_Event_Enroll_Rsn';
752: l_object_version_number ben_lee_rsn_f.object_version_number%TYPE;
753: l_effective_start_date ben_lee_rsn_f.effective_start_date%TYPE;
754: l_effective_end_date ben_lee_rsn_f.effective_end_date%TYPE;
755: --
756: begin
757: --

Line 754: l_effective_end_date ben_lee_rsn_f.effective_end_date%TYPE;

750: --
751: l_proc varchar2(72) := g_package||'update_Life_Event_Enroll_Rsn';
752: l_object_version_number ben_lee_rsn_f.object_version_number%TYPE;
753: l_effective_start_date ben_lee_rsn_f.effective_start_date%TYPE;
754: l_effective_end_date ben_lee_rsn_f.effective_end_date%TYPE;
755: --
756: begin
757: --
758: hr_utility.set_location('Entering:'|| l_proc, 10);