DBA Data[Home] [Help]

APPS.BEN_PLAN_API dependencies on BEN_PL_F

Line 209: l_pl_id ben_pl_f.pl_id%TYPE;

205: ) is
206: --
207: -- Declare cursors and local variables
208: --
209: l_pl_id ben_pl_f.pl_id%TYPE;
210: l_effective_start_date ben_pl_f.effective_start_date%TYPE;
211: l_effective_end_date ben_pl_f.effective_end_date%TYPE;
212: l_proc varchar2(72) := g_package||'create_Plan';
213: l_object_version_number ben_pl_f.object_version_number%TYPE;

Line 210: l_effective_start_date ben_pl_f.effective_start_date%TYPE;

206: --
207: -- Declare cursors and local variables
208: --
209: l_pl_id ben_pl_f.pl_id%TYPE;
210: l_effective_start_date ben_pl_f.effective_start_date%TYPE;
211: l_effective_end_date ben_pl_f.effective_end_date%TYPE;
212: l_proc varchar2(72) := g_package||'create_Plan';
213: l_object_version_number ben_pl_f.object_version_number%TYPE;
214: --

Line 211: l_effective_end_date ben_pl_f.effective_end_date%TYPE;

207: -- Declare cursors and local variables
208: --
209: l_pl_id ben_pl_f.pl_id%TYPE;
210: l_effective_start_date ben_pl_f.effective_start_date%TYPE;
211: l_effective_end_date ben_pl_f.effective_end_date%TYPE;
212: l_proc varchar2(72) := g_package||'create_Plan';
213: l_object_version_number ben_pl_f.object_version_number%TYPE;
214: --
215: begin

Line 213: l_object_version_number ben_pl_f.object_version_number%TYPE;

209: l_pl_id ben_pl_f.pl_id%TYPE;
210: l_effective_start_date ben_pl_f.effective_start_date%TYPE;
211: l_effective_end_date ben_pl_f.effective_end_date%TYPE;
212: l_proc varchar2(72) := g_package||'create_Plan';
213: l_object_version_number ben_pl_f.object_version_number%TYPE;
214: --
215: begin
216: --
217: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 1085: l_object_version_number ben_pl_f.object_version_number%TYPE;

1081: --
1082: -- Declare cursors and local variables
1083: --
1084: l_proc varchar2(72) := g_package||'update_Plan';
1085: l_object_version_number ben_pl_f.object_version_number%TYPE;
1086: l_effective_start_date ben_pl_f.effective_start_date%TYPE;
1087: l_effective_end_date ben_pl_f.effective_end_date%TYPE;
1088: --
1089: begin

Line 1086: l_effective_start_date ben_pl_f.effective_start_date%TYPE;

1082: -- Declare cursors and local variables
1083: --
1084: l_proc varchar2(72) := g_package||'update_Plan';
1085: l_object_version_number ben_pl_f.object_version_number%TYPE;
1086: l_effective_start_date ben_pl_f.effective_start_date%TYPE;
1087: l_effective_end_date ben_pl_f.effective_end_date%TYPE;
1088: --
1089: begin
1090: --

Line 1087: l_effective_end_date ben_pl_f.effective_end_date%TYPE;

1083: --
1084: l_proc varchar2(72) := g_package||'update_Plan';
1085: l_object_version_number ben_pl_f.object_version_number%TYPE;
1086: l_effective_start_date ben_pl_f.effective_start_date%TYPE;
1087: l_effective_end_date ben_pl_f.effective_end_date%TYPE;
1088: --
1089: begin
1090: --
1091: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 1775: l_object_version_number ben_pl_f.object_version_number%TYPE;

1771: --
1772: -- Declare cursors and local variables
1773: --
1774: l_proc varchar2(72) := g_package||'update_Plan';
1775: l_object_version_number ben_pl_f.object_version_number%TYPE;
1776: l_effective_start_date ben_pl_f.effective_start_date%TYPE;
1777: l_effective_end_date ben_pl_f.effective_end_date%TYPE;
1778: --
1779: begin

Line 1776: l_effective_start_date ben_pl_f.effective_start_date%TYPE;

1772: -- Declare cursors and local variables
1773: --
1774: l_proc varchar2(72) := g_package||'update_Plan';
1775: l_object_version_number ben_pl_f.object_version_number%TYPE;
1776: l_effective_start_date ben_pl_f.effective_start_date%TYPE;
1777: l_effective_end_date ben_pl_f.effective_end_date%TYPE;
1778: --
1779: begin
1780: --

Line 1777: l_effective_end_date ben_pl_f.effective_end_date%TYPE;

1773: --
1774: l_proc varchar2(72) := g_package||'update_Plan';
1775: l_object_version_number ben_pl_f.object_version_number%TYPE;
1776: l_effective_start_date ben_pl_f.effective_start_date%TYPE;
1777: l_effective_end_date ben_pl_f.effective_end_date%TYPE;
1778: --
1779: begin
1780: --
1781: hr_utility.set_location('Entering:'|| l_proc, 10);