DBA Data[Home] [Help]

APPS.BEN_ELIG_PER_WV_PL_TYP_API dependencies on BEN_ELIG_PER_WV_PL_TYP_F

Line 60: l_elig_per_wv_pl_typ_id ben_elig_per_wv_pl_typ_f.elig_per_wv_pl_typ_id%TYPE;

56: ) is
57: --
58: -- Declare cursors and local variables
59: --
60: l_elig_per_wv_pl_typ_id ben_elig_per_wv_pl_typ_f.elig_per_wv_pl_typ_id%TYPE;
61: l_effective_start_date ben_elig_per_wv_pl_typ_f.effective_start_date%TYPE;
62: l_effective_end_date ben_elig_per_wv_pl_typ_f.effective_end_date%TYPE;
63: l_proc varchar2(72) := g_package||'create_elig_per_wv_pl_typ';
64: l_object_version_number ben_elig_per_wv_pl_typ_f.object_version_number%TYPE;

Line 61: l_effective_start_date ben_elig_per_wv_pl_typ_f.effective_start_date%TYPE;

57: --
58: -- Declare cursors and local variables
59: --
60: l_elig_per_wv_pl_typ_id ben_elig_per_wv_pl_typ_f.elig_per_wv_pl_typ_id%TYPE;
61: l_effective_start_date ben_elig_per_wv_pl_typ_f.effective_start_date%TYPE;
62: l_effective_end_date ben_elig_per_wv_pl_typ_f.effective_end_date%TYPE;
63: l_proc varchar2(72) := g_package||'create_elig_per_wv_pl_typ';
64: l_object_version_number ben_elig_per_wv_pl_typ_f.object_version_number%TYPE;
65: --

Line 62: l_effective_end_date ben_elig_per_wv_pl_typ_f.effective_end_date%TYPE;

58: -- Declare cursors and local variables
59: --
60: l_elig_per_wv_pl_typ_id ben_elig_per_wv_pl_typ_f.elig_per_wv_pl_typ_id%TYPE;
61: l_effective_start_date ben_elig_per_wv_pl_typ_f.effective_start_date%TYPE;
62: l_effective_end_date ben_elig_per_wv_pl_typ_f.effective_end_date%TYPE;
63: l_proc varchar2(72) := g_package||'create_elig_per_wv_pl_typ';
64: l_object_version_number ben_elig_per_wv_pl_typ_f.object_version_number%TYPE;
65: --
66: begin

Line 64: l_object_version_number ben_elig_per_wv_pl_typ_f.object_version_number%TYPE;

60: l_elig_per_wv_pl_typ_id ben_elig_per_wv_pl_typ_f.elig_per_wv_pl_typ_id%TYPE;
61: l_effective_start_date ben_elig_per_wv_pl_typ_f.effective_start_date%TYPE;
62: l_effective_end_date ben_elig_per_wv_pl_typ_f.effective_end_date%TYPE;
63: l_proc varchar2(72) := g_package||'create_elig_per_wv_pl_typ';
64: l_object_version_number ben_elig_per_wv_pl_typ_f.object_version_number%TYPE;
65: --
66: begin
67: --
68: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 345: l_object_version_number ben_elig_per_wv_pl_typ_f.object_version_number%TYPE;

341: --
342: -- Declare cursors and local variables
343: --
344: l_proc varchar2(72) := g_package||'update_elig_per_wv_pl_typ';
345: l_object_version_number ben_elig_per_wv_pl_typ_f.object_version_number%TYPE;
346: l_effective_start_date ben_elig_per_wv_pl_typ_f.effective_start_date%TYPE;
347: l_effective_end_date ben_elig_per_wv_pl_typ_f.effective_end_date%TYPE;
348: --
349: begin

Line 346: l_effective_start_date ben_elig_per_wv_pl_typ_f.effective_start_date%TYPE;

342: -- Declare cursors and local variables
343: --
344: l_proc varchar2(72) := g_package||'update_elig_per_wv_pl_typ';
345: l_object_version_number ben_elig_per_wv_pl_typ_f.object_version_number%TYPE;
346: l_effective_start_date ben_elig_per_wv_pl_typ_f.effective_start_date%TYPE;
347: l_effective_end_date ben_elig_per_wv_pl_typ_f.effective_end_date%TYPE;
348: --
349: begin
350: --

Line 347: l_effective_end_date ben_elig_per_wv_pl_typ_f.effective_end_date%TYPE;

343: --
344: l_proc varchar2(72) := g_package||'update_elig_per_wv_pl_typ';
345: l_object_version_number ben_elig_per_wv_pl_typ_f.object_version_number%TYPE;
346: l_effective_start_date ben_elig_per_wv_pl_typ_f.effective_start_date%TYPE;
347: l_effective_end_date ben_elig_per_wv_pl_typ_f.effective_end_date%TYPE;
348: --
349: begin
350: --
351: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 591: l_object_version_number ben_elig_per_wv_pl_typ_f.object_version_number%TYPE;

587: --
588: -- Declare cursors and local variables
589: --
590: l_proc varchar2(72) := g_package||'update_elig_per_wv_pl_typ';
591: l_object_version_number ben_elig_per_wv_pl_typ_f.object_version_number%TYPE;
592: l_effective_start_date ben_elig_per_wv_pl_typ_f.effective_start_date%TYPE;
593: l_effective_end_date ben_elig_per_wv_pl_typ_f.effective_end_date%TYPE;
594: --
595: begin

Line 592: l_effective_start_date ben_elig_per_wv_pl_typ_f.effective_start_date%TYPE;

588: -- Declare cursors and local variables
589: --
590: l_proc varchar2(72) := g_package||'update_elig_per_wv_pl_typ';
591: l_object_version_number ben_elig_per_wv_pl_typ_f.object_version_number%TYPE;
592: l_effective_start_date ben_elig_per_wv_pl_typ_f.effective_start_date%TYPE;
593: l_effective_end_date ben_elig_per_wv_pl_typ_f.effective_end_date%TYPE;
594: --
595: begin
596: --

Line 593: l_effective_end_date ben_elig_per_wv_pl_typ_f.effective_end_date%TYPE;

589: --
590: l_proc varchar2(72) := g_package||'update_elig_per_wv_pl_typ';
591: l_object_version_number ben_elig_per_wv_pl_typ_f.object_version_number%TYPE;
592: l_effective_start_date ben_elig_per_wv_pl_typ_f.effective_start_date%TYPE;
593: l_effective_end_date ben_elig_per_wv_pl_typ_f.effective_end_date%TYPE;
594: --
595: begin
596: --
597: hr_utility.set_location('Entering:'|| l_proc, 10);