84: ) is
85: --
86: -- Declare cursors and local variables
87: --
88: l_bnft_prvdr_pool_id ben_bnft_prvdr_pool_f.bnft_prvdr_pool_id%TYPE;
89: l_effective_start_date ben_bnft_prvdr_pool_f.effective_start_date%TYPE;
90: l_effective_end_date ben_bnft_prvdr_pool_f.effective_end_date%TYPE;
91: l_proc varchar2(72) := g_package||'create_Benefit_Prvdr_Pool';
92: l_object_version_number ben_bnft_prvdr_pool_f.object_version_number%TYPE;
85: --
86: -- Declare cursors and local variables
87: --
88: l_bnft_prvdr_pool_id ben_bnft_prvdr_pool_f.bnft_prvdr_pool_id%TYPE;
89: l_effective_start_date ben_bnft_prvdr_pool_f.effective_start_date%TYPE;
90: l_effective_end_date ben_bnft_prvdr_pool_f.effective_end_date%TYPE;
91: l_proc varchar2(72) := g_package||'create_Benefit_Prvdr_Pool';
92: l_object_version_number ben_bnft_prvdr_pool_f.object_version_number%TYPE;
93: --
86: -- Declare cursors and local variables
87: --
88: l_bnft_prvdr_pool_id ben_bnft_prvdr_pool_f.bnft_prvdr_pool_id%TYPE;
89: l_effective_start_date ben_bnft_prvdr_pool_f.effective_start_date%TYPE;
90: l_effective_end_date ben_bnft_prvdr_pool_f.effective_end_date%TYPE;
91: l_proc varchar2(72) := g_package||'create_Benefit_Prvdr_Pool';
92: l_object_version_number ben_bnft_prvdr_pool_f.object_version_number%TYPE;
93: --
94: begin
88: l_bnft_prvdr_pool_id ben_bnft_prvdr_pool_f.bnft_prvdr_pool_id%TYPE;
89: l_effective_start_date ben_bnft_prvdr_pool_f.effective_start_date%TYPE;
90: l_effective_end_date ben_bnft_prvdr_pool_f.effective_end_date%TYPE;
91: l_proc varchar2(72) := g_package||'create_Benefit_Prvdr_Pool';
92: l_object_version_number ben_bnft_prvdr_pool_f.object_version_number%TYPE;
93: --
94: begin
95: --
96: hr_utility.set_location('Entering:'|| l_proc, 10);
475: --
476: -- Declare cursors and local variables
477: --
478: l_proc varchar2(72) := g_package||'update_Benefit_Prvdr_Pool';
479: l_object_version_number ben_bnft_prvdr_pool_f.object_version_number%TYPE;
480: l_effective_start_date ben_bnft_prvdr_pool_f.effective_start_date%TYPE;
481: l_effective_end_date ben_bnft_prvdr_pool_f.effective_end_date%TYPE;
482: --
483: begin
476: -- Declare cursors and local variables
477: --
478: l_proc varchar2(72) := g_package||'update_Benefit_Prvdr_Pool';
479: l_object_version_number ben_bnft_prvdr_pool_f.object_version_number%TYPE;
480: l_effective_start_date ben_bnft_prvdr_pool_f.effective_start_date%TYPE;
481: l_effective_end_date ben_bnft_prvdr_pool_f.effective_end_date%TYPE;
482: --
483: begin
484: --
477: --
478: l_proc varchar2(72) := g_package||'update_Benefit_Prvdr_Pool';
479: l_object_version_number ben_bnft_prvdr_pool_f.object_version_number%TYPE;
480: l_effective_start_date ben_bnft_prvdr_pool_f.effective_start_date%TYPE;
481: l_effective_end_date ben_bnft_prvdr_pool_f.effective_end_date%TYPE;
482: --
483: begin
484: --
485: hr_utility.set_location('Entering:'|| l_proc, 10);
801: --
802: -- Declare cursors and local variables
803: --
804: l_proc varchar2(72) := g_package||'update_Benefit_Prvdr_Pool';
805: l_object_version_number ben_bnft_prvdr_pool_f.object_version_number%TYPE;
806: l_effective_start_date ben_bnft_prvdr_pool_f.effective_start_date%TYPE;
807: l_effective_end_date ben_bnft_prvdr_pool_f.effective_end_date%TYPE;
808: --
809: begin
802: -- Declare cursors and local variables
803: --
804: l_proc varchar2(72) := g_package||'update_Benefit_Prvdr_Pool';
805: l_object_version_number ben_bnft_prvdr_pool_f.object_version_number%TYPE;
806: l_effective_start_date ben_bnft_prvdr_pool_f.effective_start_date%TYPE;
807: l_effective_end_date ben_bnft_prvdr_pool_f.effective_end_date%TYPE;
808: --
809: begin
810: --
803: --
804: l_proc varchar2(72) := g_package||'update_Benefit_Prvdr_Pool';
805: l_object_version_number ben_bnft_prvdr_pool_f.object_version_number%TYPE;
806: l_effective_start_date ben_bnft_prvdr_pool_f.effective_start_date%TYPE;
807: l_effective_end_date ben_bnft_prvdr_pool_f.effective_end_date%TYPE;
808: --
809: begin
810: --
811: hr_utility.set_location('Entering:'|| l_proc, 10);