DBA Data[Home] [Help]

APPS.BEN_LIFE_EVENT_REASON_API dependencies on BEN_LER_F

Line 76: l_ler_id ben_ler_f.ler_id%TYPE;

72: ) is
73: --
74: -- Declare cursors and local variables
75: --
76: l_ler_id ben_ler_f.ler_id%TYPE;
77: l_effective_start_date ben_ler_f.effective_start_date%TYPE;
78: l_effective_end_date ben_ler_f.effective_end_date%TYPE;
79: l_proc varchar2(72) := g_package||'create_Life_Event_Reason';
80: l_object_version_number ben_ler_f.object_version_number%TYPE;

Line 77: l_effective_start_date ben_ler_f.effective_start_date%TYPE;

73: --
74: -- Declare cursors and local variables
75: --
76: l_ler_id ben_ler_f.ler_id%TYPE;
77: l_effective_start_date ben_ler_f.effective_start_date%TYPE;
78: l_effective_end_date ben_ler_f.effective_end_date%TYPE;
79: l_proc varchar2(72) := g_package||'create_Life_Event_Reason';
80: l_object_version_number ben_ler_f.object_version_number%TYPE;
81: --

Line 78: l_effective_end_date ben_ler_f.effective_end_date%TYPE;

74: -- Declare cursors and local variables
75: --
76: l_ler_id ben_ler_f.ler_id%TYPE;
77: l_effective_start_date ben_ler_f.effective_start_date%TYPE;
78: l_effective_end_date ben_ler_f.effective_end_date%TYPE;
79: l_proc varchar2(72) := g_package||'create_Life_Event_Reason';
80: l_object_version_number ben_ler_f.object_version_number%TYPE;
81: --
82: begin

Line 80: l_object_version_number ben_ler_f.object_version_number%TYPE;

76: l_ler_id ben_ler_f.ler_id%TYPE;
77: l_effective_start_date ben_ler_f.effective_start_date%TYPE;
78: l_effective_end_date ben_ler_f.effective_end_date%TYPE;
79: l_proc varchar2(72) := g_package||'create_Life_Event_Reason';
80: l_object_version_number ben_ler_f.object_version_number%TYPE;
81: --
82: begin
83: --
84: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 424: l_object_version_number ben_ler_f.object_version_number%TYPE;

420: --
421: -- Declare cursors and local variables
422: --
423: l_proc varchar2(72) := g_package||'update_Life_Event_Reason';
424: l_object_version_number ben_ler_f.object_version_number%TYPE;
425: l_effective_start_date ben_ler_f.effective_start_date%TYPE;
426: l_effective_end_date ben_ler_f.effective_end_date%TYPE;
427: --
428: begin

Line 425: l_effective_start_date ben_ler_f.effective_start_date%TYPE;

421: -- Declare cursors and local variables
422: --
423: l_proc varchar2(72) := g_package||'update_Life_Event_Reason';
424: l_object_version_number ben_ler_f.object_version_number%TYPE;
425: l_effective_start_date ben_ler_f.effective_start_date%TYPE;
426: l_effective_end_date ben_ler_f.effective_end_date%TYPE;
427: --
428: begin
429: --

Line 426: l_effective_end_date ben_ler_f.effective_end_date%TYPE;

422: --
423: l_proc varchar2(72) := g_package||'update_Life_Event_Reason';
424: l_object_version_number ben_ler_f.object_version_number%TYPE;
425: l_effective_start_date ben_ler_f.effective_start_date%TYPE;
426: l_effective_end_date ben_ler_f.effective_end_date%TYPE;
427: --
428: begin
429: --
430: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 717: l_object_version_number ben_ler_f.object_version_number%TYPE;

713: --
714: -- Declare cursors and local variables
715: --
716: l_proc varchar2(72) := g_package||'update_Life_Event_Reason';
717: l_object_version_number ben_ler_f.object_version_number%TYPE;
718: l_effective_start_date ben_ler_f.effective_start_date%TYPE;
719: l_effective_end_date ben_ler_f.effective_end_date%TYPE;
720: --
721: begin

Line 718: l_effective_start_date ben_ler_f.effective_start_date%TYPE;

714: -- Declare cursors and local variables
715: --
716: l_proc varchar2(72) := g_package||'update_Life_Event_Reason';
717: l_object_version_number ben_ler_f.object_version_number%TYPE;
718: l_effective_start_date ben_ler_f.effective_start_date%TYPE;
719: l_effective_end_date ben_ler_f.effective_end_date%TYPE;
720: --
721: begin
722: --

Line 719: l_effective_end_date ben_ler_f.effective_end_date%TYPE;

715: --
716: l_proc varchar2(72) := g_package||'update_Life_Event_Reason';
717: l_object_version_number ben_ler_f.object_version_number%TYPE;
718: l_effective_start_date ben_ler_f.effective_start_date%TYPE;
719: l_effective_end_date ben_ler_f.effective_end_date%TYPE;
720: --
721: begin
722: --
723: hr_utility.set_location('Entering:'|| l_proc, 10);