DBA Data[Home] [Help]

APPS.BEN_PARTICIPATION_ELIG_API dependencies on BEN_PRTN_ELIG_F

Line 76: l_prtn_elig_id ben_prtn_elig_f.prtn_elig_id%TYPE;

72: ) is
73: --
74: -- Declare cursors and local variables
75: --
76: l_prtn_elig_id ben_prtn_elig_f.prtn_elig_id%TYPE;
77: l_effective_start_date ben_prtn_elig_f.effective_start_date%TYPE;
78: l_effective_end_date ben_prtn_elig_f.effective_end_date%TYPE;
79: l_proc varchar2(72) := g_package||'create_Participation_Elig';
80: l_object_version_number ben_prtn_elig_f.object_version_number%TYPE;

Line 77: l_effective_start_date ben_prtn_elig_f.effective_start_date%TYPE;

73: --
74: -- Declare cursors and local variables
75: --
76: l_prtn_elig_id ben_prtn_elig_f.prtn_elig_id%TYPE;
77: l_effective_start_date ben_prtn_elig_f.effective_start_date%TYPE;
78: l_effective_end_date ben_prtn_elig_f.effective_end_date%TYPE;
79: l_proc varchar2(72) := g_package||'create_Participation_Elig';
80: l_object_version_number ben_prtn_elig_f.object_version_number%TYPE;
81: --

Line 78: l_effective_end_date ben_prtn_elig_f.effective_end_date%TYPE;

74: -- Declare cursors and local variables
75: --
76: l_prtn_elig_id ben_prtn_elig_f.prtn_elig_id%TYPE;
77: l_effective_start_date ben_prtn_elig_f.effective_start_date%TYPE;
78: l_effective_end_date ben_prtn_elig_f.effective_end_date%TYPE;
79: l_proc varchar2(72) := g_package||'create_Participation_Elig';
80: l_object_version_number ben_prtn_elig_f.object_version_number%TYPE;
81: --
82: begin

Line 80: l_object_version_number ben_prtn_elig_f.object_version_number%TYPE;

76: l_prtn_elig_id ben_prtn_elig_f.prtn_elig_id%TYPE;
77: l_effective_start_date ben_prtn_elig_f.effective_start_date%TYPE;
78: l_effective_end_date ben_prtn_elig_f.effective_end_date%TYPE;
79: l_proc varchar2(72) := g_package||'create_Participation_Elig';
80: l_object_version_number ben_prtn_elig_f.object_version_number%TYPE;
81: --
82: begin
83: --
84: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 421: l_object_version_number ben_prtn_elig_f.object_version_number%TYPE;

417: --
418: -- Declare cursors and local variables
419: --
420: l_proc varchar2(72) := g_package||'update_Participation_Elig';
421: l_object_version_number ben_prtn_elig_f.object_version_number%TYPE;
422: l_effective_start_date ben_prtn_elig_f.effective_start_date%TYPE;
423: l_effective_end_date ben_prtn_elig_f.effective_end_date%TYPE;
424: --
425: begin

Line 422: l_effective_start_date ben_prtn_elig_f.effective_start_date%TYPE;

418: -- Declare cursors and local variables
419: --
420: l_proc varchar2(72) := g_package||'update_Participation_Elig';
421: l_object_version_number ben_prtn_elig_f.object_version_number%TYPE;
422: l_effective_start_date ben_prtn_elig_f.effective_start_date%TYPE;
423: l_effective_end_date ben_prtn_elig_f.effective_end_date%TYPE;
424: --
425: begin
426: --

Line 423: l_effective_end_date ben_prtn_elig_f.effective_end_date%TYPE;

419: --
420: l_proc varchar2(72) := g_package||'update_Participation_Elig';
421: l_object_version_number ben_prtn_elig_f.object_version_number%TYPE;
422: l_effective_start_date ben_prtn_elig_f.effective_start_date%TYPE;
423: l_effective_end_date ben_prtn_elig_f.effective_end_date%TYPE;
424: --
425: begin
426: --
427: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 713: l_object_version_number ben_prtn_elig_f.object_version_number%TYPE;

709: --
710: -- Declare cursors and local variables
711: --
712: l_proc varchar2(72) := g_package||'update_Participation_Elig';
713: l_object_version_number ben_prtn_elig_f.object_version_number%TYPE;
714: l_effective_start_date ben_prtn_elig_f.effective_start_date%TYPE;
715: l_effective_end_date ben_prtn_elig_f.effective_end_date%TYPE;
716: --
717: begin

Line 714: l_effective_start_date ben_prtn_elig_f.effective_start_date%TYPE;

710: -- Declare cursors and local variables
711: --
712: l_proc varchar2(72) := g_package||'update_Participation_Elig';
713: l_object_version_number ben_prtn_elig_f.object_version_number%TYPE;
714: l_effective_start_date ben_prtn_elig_f.effective_start_date%TYPE;
715: l_effective_end_date ben_prtn_elig_f.effective_end_date%TYPE;
716: --
717: begin
718: --

Line 715: l_effective_end_date ben_prtn_elig_f.effective_end_date%TYPE;

711: --
712: l_proc varchar2(72) := g_package||'update_Participation_Elig';
713: l_object_version_number ben_prtn_elig_f.object_version_number%TYPE;
714: l_effective_start_date ben_prtn_elig_f.effective_start_date%TYPE;
715: l_effective_end_date ben_prtn_elig_f.effective_end_date%TYPE;
716: --
717: begin
718: --
719: hr_utility.set_location('Entering:'|| l_proc, 10);