DBA Data[Home] [Help]

APPS.BEN_LER_RQRS_ENRT_CTFN_API dependencies on BEN_LER_RQRS_ENRT_CTFN_F

Line 62: l_ler_rqrs_enrt_ctfn_id ben_ler_rqrs_enrt_ctfn_f.ler_rqrs_enrt_ctfn_id%TYPE;

58: ) is
59: --
60: -- Declare cursors and local variables
61: --
62: l_ler_rqrs_enrt_ctfn_id ben_ler_rqrs_enrt_ctfn_f.ler_rqrs_enrt_ctfn_id%TYPE;
63: l_effective_start_date ben_ler_rqrs_enrt_ctfn_f.effective_start_date%TYPE;
64: l_effective_end_date ben_ler_rqrs_enrt_ctfn_f.effective_end_date%TYPE;
65: l_proc varchar2(72) := g_package||'create_ler_rqrs_enrt_ctfn';
66: l_object_version_number ben_ler_rqrs_enrt_ctfn_f.object_version_number%TYPE;

Line 63: l_effective_start_date ben_ler_rqrs_enrt_ctfn_f.effective_start_date%TYPE;

59: --
60: -- Declare cursors and local variables
61: --
62: l_ler_rqrs_enrt_ctfn_id ben_ler_rqrs_enrt_ctfn_f.ler_rqrs_enrt_ctfn_id%TYPE;
63: l_effective_start_date ben_ler_rqrs_enrt_ctfn_f.effective_start_date%TYPE;
64: l_effective_end_date ben_ler_rqrs_enrt_ctfn_f.effective_end_date%TYPE;
65: l_proc varchar2(72) := g_package||'create_ler_rqrs_enrt_ctfn';
66: l_object_version_number ben_ler_rqrs_enrt_ctfn_f.object_version_number%TYPE;
67: --

Line 64: l_effective_end_date ben_ler_rqrs_enrt_ctfn_f.effective_end_date%TYPE;

60: -- Declare cursors and local variables
61: --
62: l_ler_rqrs_enrt_ctfn_id ben_ler_rqrs_enrt_ctfn_f.ler_rqrs_enrt_ctfn_id%TYPE;
63: l_effective_start_date ben_ler_rqrs_enrt_ctfn_f.effective_start_date%TYPE;
64: l_effective_end_date ben_ler_rqrs_enrt_ctfn_f.effective_end_date%TYPE;
65: l_proc varchar2(72) := g_package||'create_ler_rqrs_enrt_ctfn';
66: l_object_version_number ben_ler_rqrs_enrt_ctfn_f.object_version_number%TYPE;
67: --
68: begin

Line 66: l_object_version_number ben_ler_rqrs_enrt_ctfn_f.object_version_number%TYPE;

62: l_ler_rqrs_enrt_ctfn_id ben_ler_rqrs_enrt_ctfn_f.ler_rqrs_enrt_ctfn_id%TYPE;
63: l_effective_start_date ben_ler_rqrs_enrt_ctfn_f.effective_start_date%TYPE;
64: l_effective_end_date ben_ler_rqrs_enrt_ctfn_f.effective_end_date%TYPE;
65: l_proc varchar2(72) := g_package||'create_ler_rqrs_enrt_ctfn';
66: l_object_version_number ben_ler_rqrs_enrt_ctfn_f.object_version_number%TYPE;
67: --
68: begin
69: --
70: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 353: l_object_version_number ben_ler_rqrs_enrt_ctfn_f.object_version_number%TYPE;

349: --
350: -- Declare cursors and local variables
351: --
352: l_proc varchar2(72) := g_package||'update_ler_rqrs_enrt_ctfn';
353: l_object_version_number ben_ler_rqrs_enrt_ctfn_f.object_version_number%TYPE;
354: l_effective_start_date ben_ler_rqrs_enrt_ctfn_f.effective_start_date%TYPE;
355: l_effective_end_date ben_ler_rqrs_enrt_ctfn_f.effective_end_date%TYPE;
356: --
357: begin

Line 354: l_effective_start_date ben_ler_rqrs_enrt_ctfn_f.effective_start_date%TYPE;

350: -- Declare cursors and local variables
351: --
352: l_proc varchar2(72) := g_package||'update_ler_rqrs_enrt_ctfn';
353: l_object_version_number ben_ler_rqrs_enrt_ctfn_f.object_version_number%TYPE;
354: l_effective_start_date ben_ler_rqrs_enrt_ctfn_f.effective_start_date%TYPE;
355: l_effective_end_date ben_ler_rqrs_enrt_ctfn_f.effective_end_date%TYPE;
356: --
357: begin
358: --

Line 355: l_effective_end_date ben_ler_rqrs_enrt_ctfn_f.effective_end_date%TYPE;

351: --
352: l_proc varchar2(72) := g_package||'update_ler_rqrs_enrt_ctfn';
353: l_object_version_number ben_ler_rqrs_enrt_ctfn_f.object_version_number%TYPE;
354: l_effective_start_date ben_ler_rqrs_enrt_ctfn_f.effective_start_date%TYPE;
355: l_effective_end_date ben_ler_rqrs_enrt_ctfn_f.effective_end_date%TYPE;
356: --
357: begin
358: --
359: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 603: l_object_version_number ben_ler_rqrs_enrt_ctfn_f.object_version_number%TYPE;

599: --
600: -- Declare cursors and local variables
601: --
602: l_proc varchar2(72) := g_package||'update_ler_rqrs_enrt_ctfn';
603: l_object_version_number ben_ler_rqrs_enrt_ctfn_f.object_version_number%TYPE;
604: l_effective_start_date ben_ler_rqrs_enrt_ctfn_f.effective_start_date%TYPE;
605: l_effective_end_date ben_ler_rqrs_enrt_ctfn_f.effective_end_date%TYPE;
606: --
607: begin

Line 604: l_effective_start_date ben_ler_rqrs_enrt_ctfn_f.effective_start_date%TYPE;

600: -- Declare cursors and local variables
601: --
602: l_proc varchar2(72) := g_package||'update_ler_rqrs_enrt_ctfn';
603: l_object_version_number ben_ler_rqrs_enrt_ctfn_f.object_version_number%TYPE;
604: l_effective_start_date ben_ler_rqrs_enrt_ctfn_f.effective_start_date%TYPE;
605: l_effective_end_date ben_ler_rqrs_enrt_ctfn_f.effective_end_date%TYPE;
606: --
607: begin
608: --

Line 605: l_effective_end_date ben_ler_rqrs_enrt_ctfn_f.effective_end_date%TYPE;

601: --
602: l_proc varchar2(72) := g_package||'update_ler_rqrs_enrt_ctfn';
603: l_object_version_number ben_ler_rqrs_enrt_ctfn_f.object_version_number%TYPE;
604: l_effective_start_date ben_ler_rqrs_enrt_ctfn_f.effective_start_date%TYPE;
605: l_effective_end_date ben_ler_rqrs_enrt_ctfn_f.effective_end_date%TYPE;
606: --
607: begin
608: --
609: hr_utility.set_location('Entering:'|| l_proc, 10);