DBA Data[Home] [Help]

APPS.BEN_LER_BNFT_RSTRN_API dependencies on BEN_LER_BNFT_RSTRN_F

Line 77: l_ler_bnft_rstrn_id ben_ler_bnft_rstrn_f.ler_bnft_rstrn_id%TYPE;

73: ) is
74: --
75: -- Declare cursors and local variables
76: --
77: l_ler_bnft_rstrn_id ben_ler_bnft_rstrn_f.ler_bnft_rstrn_id%TYPE;
78: l_effective_start_date ben_ler_bnft_rstrn_f.effective_start_date%TYPE;
79: l_effective_end_date ben_ler_bnft_rstrn_f.effective_end_date%TYPE;
80: l_proc varchar2(72) := g_package||'create_LER_BNFT_RSTRN';
81: l_object_version_number ben_ler_bnft_rstrn_f.object_version_number%TYPE;

Line 78: l_effective_start_date ben_ler_bnft_rstrn_f.effective_start_date%TYPE;

74: --
75: -- Declare cursors and local variables
76: --
77: l_ler_bnft_rstrn_id ben_ler_bnft_rstrn_f.ler_bnft_rstrn_id%TYPE;
78: l_effective_start_date ben_ler_bnft_rstrn_f.effective_start_date%TYPE;
79: l_effective_end_date ben_ler_bnft_rstrn_f.effective_end_date%TYPE;
80: l_proc varchar2(72) := g_package||'create_LER_BNFT_RSTRN';
81: l_object_version_number ben_ler_bnft_rstrn_f.object_version_number%TYPE;
82: --

Line 79: l_effective_end_date ben_ler_bnft_rstrn_f.effective_end_date%TYPE;

75: -- Declare cursors and local variables
76: --
77: l_ler_bnft_rstrn_id ben_ler_bnft_rstrn_f.ler_bnft_rstrn_id%TYPE;
78: l_effective_start_date ben_ler_bnft_rstrn_f.effective_start_date%TYPE;
79: l_effective_end_date ben_ler_bnft_rstrn_f.effective_end_date%TYPE;
80: l_proc varchar2(72) := g_package||'create_LER_BNFT_RSTRN';
81: l_object_version_number ben_ler_bnft_rstrn_f.object_version_number%TYPE;
82: --
83: begin

Line 81: l_object_version_number ben_ler_bnft_rstrn_f.object_version_number%TYPE;

77: l_ler_bnft_rstrn_id ben_ler_bnft_rstrn_f.ler_bnft_rstrn_id%TYPE;
78: l_effective_start_date ben_ler_bnft_rstrn_f.effective_start_date%TYPE;
79: l_effective_end_date ben_ler_bnft_rstrn_f.effective_end_date%TYPE;
80: l_proc varchar2(72) := g_package||'create_LER_BNFT_RSTRN';
81: l_object_version_number ben_ler_bnft_rstrn_f.object_version_number%TYPE;
82: --
83: begin
84: --
85: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 424: l_object_version_number ben_ler_bnft_rstrn_f.object_version_number%TYPE;

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

Line 425: l_effective_start_date ben_ler_bnft_rstrn_f.effective_start_date%TYPE;

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

Line 426: l_effective_end_date ben_ler_bnft_rstrn_f.effective_end_date%TYPE;

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

Line 720: l_object_version_number ben_ler_bnft_rstrn_f.object_version_number%TYPE;

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

Line 721: l_effective_start_date ben_ler_bnft_rstrn_f.effective_start_date%TYPE;

717: -- Declare cursors and local variables
718: --
719: l_proc varchar2(72) := g_package||'update_LER_BNFT_RSTRN';
720: l_object_version_number ben_ler_bnft_rstrn_f.object_version_number%TYPE;
721: l_effective_start_date ben_ler_bnft_rstrn_f.effective_start_date%TYPE;
722: l_effective_end_date ben_ler_bnft_rstrn_f.effective_end_date%TYPE;
723: --
724: begin
725: --

Line 722: l_effective_end_date ben_ler_bnft_rstrn_f.effective_end_date%TYPE;

718: --
719: l_proc varchar2(72) := g_package||'update_LER_BNFT_RSTRN';
720: l_object_version_number ben_ler_bnft_rstrn_f.object_version_number%TYPE;
721: l_effective_start_date ben_ler_bnft_rstrn_f.effective_start_date%TYPE;
722: l_effective_end_date ben_ler_bnft_rstrn_f.effective_end_date%TYPE;
723: --
724: begin
725: --
726: hr_utility.set_location('Entering:'|| l_proc, 10);