DBA Data[Home] [Help]

APPS.BEN_ENRT_CTFN_API dependencies on BEN_ENRT_CTFN_F

Line 60: l_enrt_ctfn_id ben_enrt_ctfn_f.enrt_ctfn_id%TYPE;

56: ) is
57: --
58: -- Declare cursors and local variables
59: --
60: l_enrt_ctfn_id ben_enrt_ctfn_f.enrt_ctfn_id%TYPE;
61: l_effective_start_date ben_enrt_ctfn_f.effective_start_date%TYPE;
62: l_effective_end_date ben_enrt_ctfn_f.effective_end_date%TYPE;
63: l_proc varchar2(72) := g_package||'create_Enrt_Ctfn';
64: l_object_version_number ben_enrt_ctfn_f.object_version_number%TYPE;

Line 61: l_effective_start_date ben_enrt_ctfn_f.effective_start_date%TYPE;

57: --
58: -- Declare cursors and local variables
59: --
60: l_enrt_ctfn_id ben_enrt_ctfn_f.enrt_ctfn_id%TYPE;
61: l_effective_start_date ben_enrt_ctfn_f.effective_start_date%TYPE;
62: l_effective_end_date ben_enrt_ctfn_f.effective_end_date%TYPE;
63: l_proc varchar2(72) := g_package||'create_Enrt_Ctfn';
64: l_object_version_number ben_enrt_ctfn_f.object_version_number%TYPE;
65: --

Line 62: l_effective_end_date ben_enrt_ctfn_f.effective_end_date%TYPE;

58: -- Declare cursors and local variables
59: --
60: l_enrt_ctfn_id ben_enrt_ctfn_f.enrt_ctfn_id%TYPE;
61: l_effective_start_date ben_enrt_ctfn_f.effective_start_date%TYPE;
62: l_effective_end_date ben_enrt_ctfn_f.effective_end_date%TYPE;
63: l_proc varchar2(72) := g_package||'create_Enrt_Ctfn';
64: l_object_version_number ben_enrt_ctfn_f.object_version_number%TYPE;
65: --
66: begin

Line 64: l_object_version_number ben_enrt_ctfn_f.object_version_number%TYPE;

60: l_enrt_ctfn_id ben_enrt_ctfn_f.enrt_ctfn_id%TYPE;
61: l_effective_start_date ben_enrt_ctfn_f.effective_start_date%TYPE;
62: l_effective_end_date ben_enrt_ctfn_f.effective_end_date%TYPE;
63: l_proc varchar2(72) := g_package||'create_Enrt_Ctfn';
64: l_object_version_number ben_enrt_ctfn_f.object_version_number%TYPE;
65: --
66: begin
67: --
68: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 344: l_object_version_number ben_enrt_ctfn_f.object_version_number%TYPE;

340: --
341: -- Declare cursors and local variables
342: --
343: l_proc varchar2(72) := g_package||'update_Enrt_Ctfn';
344: l_object_version_number ben_enrt_ctfn_f.object_version_number%TYPE;
345: l_effective_start_date ben_enrt_ctfn_f.effective_start_date%TYPE;
346: l_effective_end_date ben_enrt_ctfn_f.effective_end_date%TYPE;
347: --
348: begin

Line 345: l_effective_start_date ben_enrt_ctfn_f.effective_start_date%TYPE;

341: -- Declare cursors and local variables
342: --
343: l_proc varchar2(72) := g_package||'update_Enrt_Ctfn';
344: l_object_version_number ben_enrt_ctfn_f.object_version_number%TYPE;
345: l_effective_start_date ben_enrt_ctfn_f.effective_start_date%TYPE;
346: l_effective_end_date ben_enrt_ctfn_f.effective_end_date%TYPE;
347: --
348: begin
349: --

Line 346: l_effective_end_date ben_enrt_ctfn_f.effective_end_date%TYPE;

342: --
343: l_proc varchar2(72) := g_package||'update_Enrt_Ctfn';
344: l_object_version_number ben_enrt_ctfn_f.object_version_number%TYPE;
345: l_effective_start_date ben_enrt_ctfn_f.effective_start_date%TYPE;
346: l_effective_end_date ben_enrt_ctfn_f.effective_end_date%TYPE;
347: --
348: begin
349: --
350: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 588: l_object_version_number ben_enrt_ctfn_f.object_version_number%TYPE;

584: --
585: -- Declare cursors and local variables
586: --
587: l_proc varchar2(72) := g_package||'update_Enrt_Ctfn';
588: l_object_version_number ben_enrt_ctfn_f.object_version_number%TYPE;
589: l_effective_start_date ben_enrt_ctfn_f.effective_start_date%TYPE;
590: l_effective_end_date ben_enrt_ctfn_f.effective_end_date%TYPE;
591: --
592: begin

Line 589: l_effective_start_date ben_enrt_ctfn_f.effective_start_date%TYPE;

585: -- Declare cursors and local variables
586: --
587: l_proc varchar2(72) := g_package||'update_Enrt_Ctfn';
588: l_object_version_number ben_enrt_ctfn_f.object_version_number%TYPE;
589: l_effective_start_date ben_enrt_ctfn_f.effective_start_date%TYPE;
590: l_effective_end_date ben_enrt_ctfn_f.effective_end_date%TYPE;
591: --
592: begin
593: --

Line 590: l_effective_end_date ben_enrt_ctfn_f.effective_end_date%TYPE;

586: --
587: l_proc varchar2(72) := g_package||'update_Enrt_Ctfn';
588: l_object_version_number ben_enrt_ctfn_f.object_version_number%TYPE;
589: l_effective_start_date ben_enrt_ctfn_f.effective_start_date%TYPE;
590: l_effective_end_date ben_enrt_ctfn_f.effective_end_date%TYPE;
591: --
592: begin
593: --
594: hr_utility.set_location('Entering:'|| l_proc, 10);