DBA Data[Home] [Help]

APPS.BEN_ELIG_RSLT_API dependencies on BEN_ELIG_RSLT_F

Line 28: l_elig_rslt_id ben_elig_rslt_f.elig_rslt_id%TYPE;

24: ) is
25: --
26: -- Declare cursors and local variables
27: --
28: l_elig_rslt_id ben_elig_rslt_f.elig_rslt_id%TYPE;
29: l_effective_start_date ben_elig_rslt_f.effective_start_date%TYPE;
30: l_effective_end_date ben_elig_rslt_f.effective_end_date%TYPE;
31: l_proc varchar2(72) := g_package||'create_ELIG_RSLT';
32: l_object_version_number ben_elig_rslt_f.object_version_number%TYPE;

Line 29: l_effective_start_date ben_elig_rslt_f.effective_start_date%TYPE;

25: --
26: -- Declare cursors and local variables
27: --
28: l_elig_rslt_id ben_elig_rslt_f.elig_rslt_id%TYPE;
29: l_effective_start_date ben_elig_rslt_f.effective_start_date%TYPE;
30: l_effective_end_date ben_elig_rslt_f.effective_end_date%TYPE;
31: l_proc varchar2(72) := g_package||'create_ELIG_RSLT';
32: l_object_version_number ben_elig_rslt_f.object_version_number%TYPE;
33: --

Line 30: l_effective_end_date ben_elig_rslt_f.effective_end_date%TYPE;

26: -- Declare cursors and local variables
27: --
28: l_elig_rslt_id ben_elig_rslt_f.elig_rslt_id%TYPE;
29: l_effective_start_date ben_elig_rslt_f.effective_start_date%TYPE;
30: l_effective_end_date ben_elig_rslt_f.effective_end_date%TYPE;
31: l_proc varchar2(72) := g_package||'create_ELIG_RSLT';
32: l_object_version_number ben_elig_rslt_f.object_version_number%TYPE;
33: --
34: begin

Line 32: l_object_version_number ben_elig_rslt_f.object_version_number%TYPE;

28: l_elig_rslt_id ben_elig_rslt_f.elig_rslt_id%TYPE;
29: l_effective_start_date ben_elig_rslt_f.effective_start_date%TYPE;
30: l_effective_end_date ben_elig_rslt_f.effective_end_date%TYPE;
31: l_proc varchar2(72) := g_package||'create_ELIG_RSLT';
32: l_object_version_number ben_elig_rslt_f.object_version_number%TYPE;
33: --
34: begin
35: --
36: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 179: l_object_version_number ben_elig_rslt_f.object_version_number%TYPE;

175: --
176: -- Declare cursors and local variables
177: --
178: l_proc varchar2(72) := g_package||'update_ELIG_RSLT';
179: l_object_version_number ben_elig_rslt_f.object_version_number%TYPE;
180: l_effective_start_date ben_elig_rslt_f.effective_start_date%TYPE;
181: l_effective_end_date ben_elig_rslt_f.effective_end_date%TYPE;
182: --
183: begin

Line 180: l_effective_start_date ben_elig_rslt_f.effective_start_date%TYPE;

176: -- Declare cursors and local variables
177: --
178: l_proc varchar2(72) := g_package||'update_ELIG_RSLT';
179: l_object_version_number ben_elig_rslt_f.object_version_number%TYPE;
180: l_effective_start_date ben_elig_rslt_f.effective_start_date%TYPE;
181: l_effective_end_date ben_elig_rslt_f.effective_end_date%TYPE;
182: --
183: begin
184: --

Line 181: l_effective_end_date ben_elig_rslt_f.effective_end_date%TYPE;

177: --
178: l_proc varchar2(72) := g_package||'update_ELIG_RSLT';
179: l_object_version_number ben_elig_rslt_f.object_version_number%TYPE;
180: l_effective_start_date ben_elig_rslt_f.effective_start_date%TYPE;
181: l_effective_end_date ben_elig_rslt_f.effective_end_date%TYPE;
182: --
183: begin
184: --
185: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 324: l_object_version_number ben_elig_rslt_f.object_version_number%TYPE;

320: --
321: -- Declare cursors and local variables
322: --
323: l_proc varchar2(72) := g_package||'update_ELIG_RSLT';
324: l_object_version_number ben_elig_rslt_f.object_version_number%TYPE;
325: l_effective_start_date ben_elig_rslt_f.effective_start_date%TYPE;
326: l_effective_end_date ben_elig_rslt_f.effective_end_date%TYPE;
327: --
328: begin

Line 325: l_effective_start_date ben_elig_rslt_f.effective_start_date%TYPE;

321: -- Declare cursors and local variables
322: --
323: l_proc varchar2(72) := g_package||'update_ELIG_RSLT';
324: l_object_version_number ben_elig_rslt_f.object_version_number%TYPE;
325: l_effective_start_date ben_elig_rslt_f.effective_start_date%TYPE;
326: l_effective_end_date ben_elig_rslt_f.effective_end_date%TYPE;
327: --
328: begin
329: --

Line 326: l_effective_end_date ben_elig_rslt_f.effective_end_date%TYPE;

322: --
323: l_proc varchar2(72) := g_package||'update_ELIG_RSLT';
324: l_object_version_number ben_elig_rslt_f.object_version_number%TYPE;
325: l_effective_start_date ben_elig_rslt_f.effective_start_date%TYPE;
326: l_effective_end_date ben_elig_rslt_f.effective_end_date%TYPE;
327: --
328: begin
329: --
330: hr_utility.set_location('Entering:'|| l_proc, 10);