72: ) is
73: --
74: -- Declare cursors and local variables
75: --
76: l_bnft_pool_rlovr_rqmt_id ben_bnft_pool_rlovr_rqmt_f.bnft_pool_rlovr_rqmt_id%TYPE;
77: l_effective_start_date ben_bnft_pool_rlovr_rqmt_f.effective_start_date%TYPE;
78: l_effective_end_date ben_bnft_pool_rlovr_rqmt_f.effective_end_date%TYPE;
79: l_proc varchar2(72) := g_package||'create_Bnft_Pool_Rlovr_Rqmt';
80: l_object_version_number ben_bnft_pool_rlovr_rqmt_f.object_version_number%TYPE;
73: --
74: -- Declare cursors and local variables
75: --
76: l_bnft_pool_rlovr_rqmt_id ben_bnft_pool_rlovr_rqmt_f.bnft_pool_rlovr_rqmt_id%TYPE;
77: l_effective_start_date ben_bnft_pool_rlovr_rqmt_f.effective_start_date%TYPE;
78: l_effective_end_date ben_bnft_pool_rlovr_rqmt_f.effective_end_date%TYPE;
79: l_proc varchar2(72) := g_package||'create_Bnft_Pool_Rlovr_Rqmt';
80: l_object_version_number ben_bnft_pool_rlovr_rqmt_f.object_version_number%TYPE;
81: --
74: -- Declare cursors and local variables
75: --
76: l_bnft_pool_rlovr_rqmt_id ben_bnft_pool_rlovr_rqmt_f.bnft_pool_rlovr_rqmt_id%TYPE;
77: l_effective_start_date ben_bnft_pool_rlovr_rqmt_f.effective_start_date%TYPE;
78: l_effective_end_date ben_bnft_pool_rlovr_rqmt_f.effective_end_date%TYPE;
79: l_proc varchar2(72) := g_package||'create_Bnft_Pool_Rlovr_Rqmt';
80: l_object_version_number ben_bnft_pool_rlovr_rqmt_f.object_version_number%TYPE;
81: --
82: begin
76: l_bnft_pool_rlovr_rqmt_id ben_bnft_pool_rlovr_rqmt_f.bnft_pool_rlovr_rqmt_id%TYPE;
77: l_effective_start_date ben_bnft_pool_rlovr_rqmt_f.effective_start_date%TYPE;
78: l_effective_end_date ben_bnft_pool_rlovr_rqmt_f.effective_end_date%TYPE;
79: l_proc varchar2(72) := g_package||'create_Bnft_Pool_Rlovr_Rqmt';
80: l_object_version_number ben_bnft_pool_rlovr_rqmt_f.object_version_number%TYPE;
81: --
82: begin
83: --
84: hr_utility.set_location('Entering:'|| l_proc, 10);
415: --
416: -- Declare cursors and local variables
417: --
418: l_proc varchar2(72) := g_package||'update_Bnft_Pool_Rlovr_Rqmt';
419: l_object_version_number ben_bnft_pool_rlovr_rqmt_f.object_version_number%TYPE;
420: l_effective_start_date ben_bnft_pool_rlovr_rqmt_f.effective_start_date%TYPE;
421: l_effective_end_date ben_bnft_pool_rlovr_rqmt_f.effective_end_date%TYPE;
422: --
423: begin
416: -- Declare cursors and local variables
417: --
418: l_proc varchar2(72) := g_package||'update_Bnft_Pool_Rlovr_Rqmt';
419: l_object_version_number ben_bnft_pool_rlovr_rqmt_f.object_version_number%TYPE;
420: l_effective_start_date ben_bnft_pool_rlovr_rqmt_f.effective_start_date%TYPE;
421: l_effective_end_date ben_bnft_pool_rlovr_rqmt_f.effective_end_date%TYPE;
422: --
423: begin
424: --
417: --
418: l_proc varchar2(72) := g_package||'update_Bnft_Pool_Rlovr_Rqmt';
419: l_object_version_number ben_bnft_pool_rlovr_rqmt_f.object_version_number%TYPE;
420: l_effective_start_date ben_bnft_pool_rlovr_rqmt_f.effective_start_date%TYPE;
421: l_effective_end_date ben_bnft_pool_rlovr_rqmt_f.effective_end_date%TYPE;
422: --
423: begin
424: --
425: hr_utility.set_location('Entering:'|| l_proc, 10);
704: --
705: -- Declare cursors and local variables
706: --
707: l_proc varchar2(72) := g_package||'update_Bnft_Pool_Rlovr_Rqmt';
708: l_object_version_number ben_bnft_pool_rlovr_rqmt_f.object_version_number%TYPE;
709: l_effective_start_date ben_bnft_pool_rlovr_rqmt_f.effective_start_date%TYPE;
710: l_effective_end_date ben_bnft_pool_rlovr_rqmt_f.effective_end_date%TYPE;
711: --
712: begin
705: -- Declare cursors and local variables
706: --
707: l_proc varchar2(72) := g_package||'update_Bnft_Pool_Rlovr_Rqmt';
708: l_object_version_number ben_bnft_pool_rlovr_rqmt_f.object_version_number%TYPE;
709: l_effective_start_date ben_bnft_pool_rlovr_rqmt_f.effective_start_date%TYPE;
710: l_effective_end_date ben_bnft_pool_rlovr_rqmt_f.effective_end_date%TYPE;
711: --
712: begin
713: --
706: --
707: l_proc varchar2(72) := g_package||'update_Bnft_Pool_Rlovr_Rqmt';
708: l_object_version_number ben_bnft_pool_rlovr_rqmt_f.object_version_number%TYPE;
709: l_effective_start_date ben_bnft_pool_rlovr_rqmt_f.effective_start_date%TYPE;
710: l_effective_end_date ben_bnft_pool_rlovr_rqmt_f.effective_end_date%TYPE;
711: --
712: begin
713: --
714: hr_utility.set_location('Entering:'|| l_proc, 10);