DBA Data[Home] [Help]

APPS.BEN_PLAN_DPNT_CVG_CTFN_API dependencies on BEN_PL_DPNT_CVG_CTFN_F

Line 66: l_pl_dpnt_cvg_ctfn_id ben_pl_dpnt_cvg_ctfn_f.pl_dpnt_cvg_ctfn_id%TYPE;

62: ) is
63: --
64: -- Declare cursors and local variables
65: --
66: l_pl_dpnt_cvg_ctfn_id ben_pl_dpnt_cvg_ctfn_f.pl_dpnt_cvg_ctfn_id%TYPE;
67: l_effective_start_date ben_pl_dpnt_cvg_ctfn_f.effective_start_date%TYPE;
68: l_effective_end_date ben_pl_dpnt_cvg_ctfn_f.effective_end_date%TYPE;
69: l_proc varchar2(72) := g_package||'create_Plan_Dpnt_Cvg_Ctfn';
70: l_object_version_number ben_pl_dpnt_cvg_ctfn_f.object_version_number%TYPE;

Line 67: l_effective_start_date ben_pl_dpnt_cvg_ctfn_f.effective_start_date%TYPE;

63: --
64: -- Declare cursors and local variables
65: --
66: l_pl_dpnt_cvg_ctfn_id ben_pl_dpnt_cvg_ctfn_f.pl_dpnt_cvg_ctfn_id%TYPE;
67: l_effective_start_date ben_pl_dpnt_cvg_ctfn_f.effective_start_date%TYPE;
68: l_effective_end_date ben_pl_dpnt_cvg_ctfn_f.effective_end_date%TYPE;
69: l_proc varchar2(72) := g_package||'create_Plan_Dpnt_Cvg_Ctfn';
70: l_object_version_number ben_pl_dpnt_cvg_ctfn_f.object_version_number%TYPE;
71: --

Line 68: l_effective_end_date ben_pl_dpnt_cvg_ctfn_f.effective_end_date%TYPE;

64: -- Declare cursors and local variables
65: --
66: l_pl_dpnt_cvg_ctfn_id ben_pl_dpnt_cvg_ctfn_f.pl_dpnt_cvg_ctfn_id%TYPE;
67: l_effective_start_date ben_pl_dpnt_cvg_ctfn_f.effective_start_date%TYPE;
68: l_effective_end_date ben_pl_dpnt_cvg_ctfn_f.effective_end_date%TYPE;
69: l_proc varchar2(72) := g_package||'create_Plan_Dpnt_Cvg_Ctfn';
70: l_object_version_number ben_pl_dpnt_cvg_ctfn_f.object_version_number%TYPE;
71: --
72: begin

Line 70: l_object_version_number ben_pl_dpnt_cvg_ctfn_f.object_version_number%TYPE;

66: l_pl_dpnt_cvg_ctfn_id ben_pl_dpnt_cvg_ctfn_f.pl_dpnt_cvg_ctfn_id%TYPE;
67: l_effective_start_date ben_pl_dpnt_cvg_ctfn_f.effective_start_date%TYPE;
68: l_effective_end_date ben_pl_dpnt_cvg_ctfn_f.effective_end_date%TYPE;
69: l_proc varchar2(72) := g_package||'create_Plan_Dpnt_Cvg_Ctfn';
70: l_object_version_number ben_pl_dpnt_cvg_ctfn_f.object_version_number%TYPE;
71: --
72: begin
73: --
74: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 374: l_object_version_number ben_pl_dpnt_cvg_ctfn_f.object_version_number%TYPE;

370: --
371: -- Declare cursors and local variables
372: --
373: l_proc varchar2(72) := g_package||'update_Plan_Dpnt_Cvg_Ctfn';
374: l_object_version_number ben_pl_dpnt_cvg_ctfn_f.object_version_number%TYPE;
375: l_effective_start_date ben_pl_dpnt_cvg_ctfn_f.effective_start_date%TYPE;
376: l_effective_end_date ben_pl_dpnt_cvg_ctfn_f.effective_end_date%TYPE;
377: --
378: begin

Line 375: l_effective_start_date ben_pl_dpnt_cvg_ctfn_f.effective_start_date%TYPE;

371: -- Declare cursors and local variables
372: --
373: l_proc varchar2(72) := g_package||'update_Plan_Dpnt_Cvg_Ctfn';
374: l_object_version_number ben_pl_dpnt_cvg_ctfn_f.object_version_number%TYPE;
375: l_effective_start_date ben_pl_dpnt_cvg_ctfn_f.effective_start_date%TYPE;
376: l_effective_end_date ben_pl_dpnt_cvg_ctfn_f.effective_end_date%TYPE;
377: --
378: begin
379: --

Line 376: l_effective_end_date ben_pl_dpnt_cvg_ctfn_f.effective_end_date%TYPE;

372: --
373: l_proc varchar2(72) := g_package||'update_Plan_Dpnt_Cvg_Ctfn';
374: l_object_version_number ben_pl_dpnt_cvg_ctfn_f.object_version_number%TYPE;
375: l_effective_start_date ben_pl_dpnt_cvg_ctfn_f.effective_start_date%TYPE;
376: l_effective_end_date ben_pl_dpnt_cvg_ctfn_f.effective_end_date%TYPE;
377: --
378: begin
379: --
380: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 637: l_object_version_number ben_pl_dpnt_cvg_ctfn_f.object_version_number%TYPE;

633: --
634: -- Declare cursors and local variables
635: --
636: l_proc varchar2(72) := g_package||'update_Plan_Dpnt_Cvg_Ctfn';
637: l_object_version_number ben_pl_dpnt_cvg_ctfn_f.object_version_number%TYPE;
638: l_effective_start_date ben_pl_dpnt_cvg_ctfn_f.effective_start_date%TYPE;
639: l_effective_end_date ben_pl_dpnt_cvg_ctfn_f.effective_end_date%TYPE;
640: --
641: begin

Line 638: l_effective_start_date ben_pl_dpnt_cvg_ctfn_f.effective_start_date%TYPE;

634: -- Declare cursors and local variables
635: --
636: l_proc varchar2(72) := g_package||'update_Plan_Dpnt_Cvg_Ctfn';
637: l_object_version_number ben_pl_dpnt_cvg_ctfn_f.object_version_number%TYPE;
638: l_effective_start_date ben_pl_dpnt_cvg_ctfn_f.effective_start_date%TYPE;
639: l_effective_end_date ben_pl_dpnt_cvg_ctfn_f.effective_end_date%TYPE;
640: --
641: begin
642: --

Line 639: l_effective_end_date ben_pl_dpnt_cvg_ctfn_f.effective_end_date%TYPE;

635: --
636: l_proc varchar2(72) := g_package||'update_Plan_Dpnt_Cvg_Ctfn';
637: l_object_version_number ben_pl_dpnt_cvg_ctfn_f.object_version_number%TYPE;
638: l_effective_start_date ben_pl_dpnt_cvg_ctfn_f.effective_start_date%TYPE;
639: l_effective_end_date ben_pl_dpnt_cvg_ctfn_f.effective_end_date%TYPE;
640: --
641: begin
642: --
643: hr_utility.set_location('Entering:'|| l_proc, 10);