DBA Data[Home] [Help]

APPS.BEN_CLPSE_LF_EVT_API dependencies on BEN_CLPSE_LF_EVT_F

Line 80: l_clpse_lf_evt_id ben_clpse_lf_evt_f.clpse_lf_evt_id%TYPE;

76: ,p_effective_date in date) is
77: --
78: -- Declare cursors and local variables
79: --
80: l_clpse_lf_evt_id ben_clpse_lf_evt_f.clpse_lf_evt_id%TYPE;
81: l_effective_start_date ben_clpse_lf_evt_f.effective_start_date%TYPE;
82: l_effective_end_date ben_clpse_lf_evt_f.effective_end_date%TYPE;
83: l_proc varchar2(72) := g_package||'create_clpse_lf_evt';
84: l_object_version_number ben_clpse_lf_evt_f.object_version_number%TYPE;

Line 81: l_effective_start_date ben_clpse_lf_evt_f.effective_start_date%TYPE;

77: --
78: -- Declare cursors and local variables
79: --
80: l_clpse_lf_evt_id ben_clpse_lf_evt_f.clpse_lf_evt_id%TYPE;
81: l_effective_start_date ben_clpse_lf_evt_f.effective_start_date%TYPE;
82: l_effective_end_date ben_clpse_lf_evt_f.effective_end_date%TYPE;
83: l_proc varchar2(72) := g_package||'create_clpse_lf_evt';
84: l_object_version_number ben_clpse_lf_evt_f.object_version_number%TYPE;
85: --

Line 82: l_effective_end_date ben_clpse_lf_evt_f.effective_end_date%TYPE;

78: -- Declare cursors and local variables
79: --
80: l_clpse_lf_evt_id ben_clpse_lf_evt_f.clpse_lf_evt_id%TYPE;
81: l_effective_start_date ben_clpse_lf_evt_f.effective_start_date%TYPE;
82: l_effective_end_date ben_clpse_lf_evt_f.effective_end_date%TYPE;
83: l_proc varchar2(72) := g_package||'create_clpse_lf_evt';
84: l_object_version_number ben_clpse_lf_evt_f.object_version_number%TYPE;
85: --
86: begin

Line 84: l_object_version_number ben_clpse_lf_evt_f.object_version_number%TYPE;

80: l_clpse_lf_evt_id ben_clpse_lf_evt_f.clpse_lf_evt_id%TYPE;
81: l_effective_start_date ben_clpse_lf_evt_f.effective_start_date%TYPE;
82: l_effective_end_date ben_clpse_lf_evt_f.effective_end_date%TYPE;
83: l_proc varchar2(72) := g_package||'create_clpse_lf_evt';
84: l_object_version_number ben_clpse_lf_evt_f.object_version_number%TYPE;
85: --
86: begin
87: --
88: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 441: l_object_version_number ben_clpse_lf_evt_f.object_version_number%TYPE;

437: --
438: -- Declare cursors and local variables
439: --
440: l_proc varchar2(72) := g_package||'update_clpse_lf_evt';
441: l_object_version_number ben_clpse_lf_evt_f.object_version_number%TYPE;
442: l_effective_start_date ben_clpse_lf_evt_f.effective_start_date%TYPE;
443: l_effective_end_date ben_clpse_lf_evt_f.effective_end_date%TYPE;
444: --
445: begin

Line 442: l_effective_start_date ben_clpse_lf_evt_f.effective_start_date%TYPE;

438: -- Declare cursors and local variables
439: --
440: l_proc varchar2(72) := g_package||'update_clpse_lf_evt';
441: l_object_version_number ben_clpse_lf_evt_f.object_version_number%TYPE;
442: l_effective_start_date ben_clpse_lf_evt_f.effective_start_date%TYPE;
443: l_effective_end_date ben_clpse_lf_evt_f.effective_end_date%TYPE;
444: --
445: begin
446: --

Line 443: l_effective_end_date ben_clpse_lf_evt_f.effective_end_date%TYPE;

439: --
440: l_proc varchar2(72) := g_package||'update_clpse_lf_evt';
441: l_object_version_number ben_clpse_lf_evt_f.object_version_number%TYPE;
442: l_effective_start_date ben_clpse_lf_evt_f.effective_start_date%TYPE;
443: l_effective_end_date ben_clpse_lf_evt_f.effective_end_date%TYPE;
444: --
445: begin
446: --
447: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 744: l_object_version_number ben_clpse_lf_evt_f.object_version_number%TYPE;

740: --
741: -- Declare cursors and local variables
742: --
743: l_proc varchar2(72) := g_package||'update_clpse_lf_evt';
744: l_object_version_number ben_clpse_lf_evt_f.object_version_number%TYPE;
745: l_effective_start_date ben_clpse_lf_evt_f.effective_start_date%TYPE;
746: l_effective_end_date ben_clpse_lf_evt_f.effective_end_date%TYPE;
747: --
748: begin

Line 745: l_effective_start_date ben_clpse_lf_evt_f.effective_start_date%TYPE;

741: -- Declare cursors and local variables
742: --
743: l_proc varchar2(72) := g_package||'update_clpse_lf_evt';
744: l_object_version_number ben_clpse_lf_evt_f.object_version_number%TYPE;
745: l_effective_start_date ben_clpse_lf_evt_f.effective_start_date%TYPE;
746: l_effective_end_date ben_clpse_lf_evt_f.effective_end_date%TYPE;
747: --
748: begin
749: --

Line 746: l_effective_end_date ben_clpse_lf_evt_f.effective_end_date%TYPE;

742: --
743: l_proc varchar2(72) := g_package||'update_clpse_lf_evt';
744: l_object_version_number ben_clpse_lf_evt_f.object_version_number%TYPE;
745: l_effective_start_date ben_clpse_lf_evt_f.effective_start_date%TYPE;
746: l_effective_end_date ben_clpse_lf_evt_f.effective_end_date%TYPE;
747: --
748: begin
749: --
750: hr_utility.set_location('Entering:'|| l_proc, 10);