DBA Data[Home] [Help]

APPS.BEN_ELIG_TO_PRTE_REASON_API dependencies on BEN_ELIG_TO_PRTE_RSN_F

Line 80: l_elig_to_prte_rsn_id ben_elig_to_prte_rsn_f.elig_to_prte_rsn_id%TYPE;

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

Line 81: l_effective_start_date ben_elig_to_prte_rsn_f.effective_start_date%TYPE;

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

Line 82: l_effective_end_date ben_elig_to_prte_rsn_f.effective_end_date%TYPE;

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

Line 84: l_object_version_number ben_elig_to_prte_rsn_f.object_version_number%TYPE;

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

Line 444: l_object_version_number ben_elig_to_prte_rsn_f.object_version_number%TYPE;

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

Line 445: l_effective_start_date ben_elig_to_prte_rsn_f.effective_start_date%TYPE;

441: -- Declare cursors and local variables
442: --
443: l_proc varchar2(72) := g_package||'update_ELIG_TO_PRTE_REASON';
444: l_object_version_number ben_elig_to_prte_rsn_f.object_version_number%TYPE;
445: l_effective_start_date ben_elig_to_prte_rsn_f.effective_start_date%TYPE;
446: l_effective_end_date ben_elig_to_prte_rsn_f.effective_end_date%TYPE;
447: --
448: begin
449: --

Line 446: l_effective_end_date ben_elig_to_prte_rsn_f.effective_end_date%TYPE;

442: --
443: l_proc varchar2(72) := g_package||'update_ELIG_TO_PRTE_REASON';
444: l_object_version_number ben_elig_to_prte_rsn_f.object_version_number%TYPE;
445: l_effective_start_date ben_elig_to_prte_rsn_f.effective_start_date%TYPE;
446: l_effective_end_date ben_elig_to_prte_rsn_f.effective_end_date%TYPE;
447: --
448: begin
449: --
450: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 749: l_object_version_number ben_elig_to_prte_rsn_f.object_version_number%TYPE;

745: --
746: -- Declare cursors and local variables
747: --
748: l_proc varchar2(72) := g_package||'update_ELIG_TO_PRTE_REASON';
749: l_object_version_number ben_elig_to_prte_rsn_f.object_version_number%TYPE;
750: l_effective_start_date ben_elig_to_prte_rsn_f.effective_start_date%TYPE;
751: l_effective_end_date ben_elig_to_prte_rsn_f.effective_end_date%TYPE;
752: --
753: begin

Line 750: l_effective_start_date ben_elig_to_prte_rsn_f.effective_start_date%TYPE;

746: -- Declare cursors and local variables
747: --
748: l_proc varchar2(72) := g_package||'update_ELIG_TO_PRTE_REASON';
749: l_object_version_number ben_elig_to_prte_rsn_f.object_version_number%TYPE;
750: l_effective_start_date ben_elig_to_prte_rsn_f.effective_start_date%TYPE;
751: l_effective_end_date ben_elig_to_prte_rsn_f.effective_end_date%TYPE;
752: --
753: begin
754: --

Line 751: l_effective_end_date ben_elig_to_prte_rsn_f.effective_end_date%TYPE;

747: --
748: l_proc varchar2(72) := g_package||'update_ELIG_TO_PRTE_REASON';
749: l_object_version_number ben_elig_to_prte_rsn_f.object_version_number%TYPE;
750: l_effective_start_date ben_elig_to_prte_rsn_f.effective_start_date%TYPE;
751: l_effective_end_date ben_elig_to_prte_rsn_f.effective_end_date%TYPE;
752: --
753: begin
754: --
755: hr_utility.set_location('Entering:'|| l_proc, 10);