DBA Data[Home] [Help]

APPS.BEN_PLAN_API dependencies on BEN_PL_F

Line 210: l_pl_id ben_pl_f.pl_id%TYPE;

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

Line 211: l_effective_start_date ben_pl_f.effective_start_date%TYPE;

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

Line 212: l_effective_end_date ben_pl_f.effective_end_date%TYPE;

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

Line 214: l_object_version_number ben_pl_f.object_version_number%TYPE;

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

Line 1091: l_object_version_number ben_pl_f.object_version_number%TYPE;

1087: --
1088: -- Declare cursors and local variables
1089: --
1090: l_proc varchar2(72) := g_package||'update_Plan';
1091: l_object_version_number ben_pl_f.object_version_number%TYPE;
1092: l_effective_start_date ben_pl_f.effective_start_date%TYPE;
1093: l_effective_end_date ben_pl_f.effective_end_date%TYPE;
1094: --
1095: begin

Line 1092: l_effective_start_date ben_pl_f.effective_start_date%TYPE;

1088: -- Declare cursors and local variables
1089: --
1090: l_proc varchar2(72) := g_package||'update_Plan';
1091: l_object_version_number ben_pl_f.object_version_number%TYPE;
1092: l_effective_start_date ben_pl_f.effective_start_date%TYPE;
1093: l_effective_end_date ben_pl_f.effective_end_date%TYPE;
1094: --
1095: begin
1096: --

Line 1093: l_effective_end_date ben_pl_f.effective_end_date%TYPE;

1089: --
1090: l_proc varchar2(72) := g_package||'update_Plan';
1091: l_object_version_number ben_pl_f.object_version_number%TYPE;
1092: l_effective_start_date ben_pl_f.effective_start_date%TYPE;
1093: l_effective_end_date ben_pl_f.effective_end_date%TYPE;
1094: --
1095: begin
1096: --
1097: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 1786: l_object_version_number ben_pl_f.object_version_number%TYPE;

1782: --
1783: -- Declare cursors and local variables
1784: --
1785: l_proc varchar2(72) := g_package||'update_Plan';
1786: l_object_version_number ben_pl_f.object_version_number%TYPE;
1787: l_effective_start_date ben_pl_f.effective_start_date%TYPE;
1788: l_effective_end_date ben_pl_f.effective_end_date%TYPE;
1789: --
1790: begin

Line 1787: l_effective_start_date ben_pl_f.effective_start_date%TYPE;

1783: -- Declare cursors and local variables
1784: --
1785: l_proc varchar2(72) := g_package||'update_Plan';
1786: l_object_version_number ben_pl_f.object_version_number%TYPE;
1787: l_effective_start_date ben_pl_f.effective_start_date%TYPE;
1788: l_effective_end_date ben_pl_f.effective_end_date%TYPE;
1789: --
1790: begin
1791: --

Line 1788: l_effective_end_date ben_pl_f.effective_end_date%TYPE;

1784: --
1785: l_proc varchar2(72) := g_package||'update_Plan';
1786: l_object_version_number ben_pl_f.object_version_number%TYPE;
1787: l_effective_start_date ben_pl_f.effective_start_date%TYPE;
1788: l_effective_end_date ben_pl_f.effective_end_date%TYPE;
1789: --
1790: begin
1791: --
1792: hr_utility.set_location('Entering:'|| l_proc, 10);