83: ) is
84: --
85: -- Declare cursors and local variables
86: --
87: l_actl_prem_id ben_actl_prem_f.actl_prem_id%TYPE;
88: l_effective_start_date ben_actl_prem_f.effective_start_date%TYPE;
89: l_effective_end_date ben_actl_prem_f.effective_end_date%TYPE;
90: l_proc varchar2(72) := g_package||'create_actual_premium';
91: l_object_version_number ben_actl_prem_f.object_version_number%TYPE;
84: --
85: -- Declare cursors and local variables
86: --
87: l_actl_prem_id ben_actl_prem_f.actl_prem_id%TYPE;
88: l_effective_start_date ben_actl_prem_f.effective_start_date%TYPE;
89: l_effective_end_date ben_actl_prem_f.effective_end_date%TYPE;
90: l_proc varchar2(72) := g_package||'create_actual_premium';
91: l_object_version_number ben_actl_prem_f.object_version_number%TYPE;
92: --
85: -- Declare cursors and local variables
86: --
87: l_actl_prem_id ben_actl_prem_f.actl_prem_id%TYPE;
88: l_effective_start_date ben_actl_prem_f.effective_start_date%TYPE;
89: l_effective_end_date ben_actl_prem_f.effective_end_date%TYPE;
90: l_proc varchar2(72) := g_package||'create_actual_premium';
91: l_object_version_number ben_actl_prem_f.object_version_number%TYPE;
92: --
93: begin
87: l_actl_prem_id ben_actl_prem_f.actl_prem_id%TYPE;
88: l_effective_start_date ben_actl_prem_f.effective_start_date%TYPE;
89: l_effective_end_date ben_actl_prem_f.effective_end_date%TYPE;
90: l_proc varchar2(72) := g_package||'create_actual_premium';
91: l_object_version_number ben_actl_prem_f.object_version_number%TYPE;
92: --
93: begin
94: --
95: hr_utility.set_location('Entering:'|| l_proc, 10);
474: --
475: -- Declare cursors and local variables
476: --
477: l_proc varchar2(72) := g_package||'update_actual_premium';
478: l_object_version_number ben_actl_prem_f.object_version_number%TYPE;
479: l_effective_start_date ben_actl_prem_f.effective_start_date%TYPE;
480: l_effective_end_date ben_actl_prem_f.effective_end_date%TYPE;
481: l_in_object_version_number number := p_object_version_number ;
482:
475: -- Declare cursors and local variables
476: --
477: l_proc varchar2(72) := g_package||'update_actual_premium';
478: l_object_version_number ben_actl_prem_f.object_version_number%TYPE;
479: l_effective_start_date ben_actl_prem_f.effective_start_date%TYPE;
480: l_effective_end_date ben_actl_prem_f.effective_end_date%TYPE;
481: l_in_object_version_number number := p_object_version_number ;
482:
483: --
476: --
477: l_proc varchar2(72) := g_package||'update_actual_premium';
478: l_object_version_number ben_actl_prem_f.object_version_number%TYPE;
479: l_effective_start_date ben_actl_prem_f.effective_start_date%TYPE;
480: l_effective_end_date ben_actl_prem_f.effective_end_date%TYPE;
481: l_in_object_version_number number := p_object_version_number ;
482:
483: --
484: begin
802: --
803: -- Declare cursors and local variables
804: --
805: l_proc varchar2(72) := g_package||'update_actual_premium';
806: l_object_version_number ben_actl_prem_f.object_version_number%TYPE;
807: l_effective_start_date ben_actl_prem_f.effective_start_date%TYPE;
808: l_effective_end_date ben_actl_prem_f.effective_end_date%TYPE;
809: --
810: l_in_object_version_number number := p_object_version_number ;
803: -- Declare cursors and local variables
804: --
805: l_proc varchar2(72) := g_package||'update_actual_premium';
806: l_object_version_number ben_actl_prem_f.object_version_number%TYPE;
807: l_effective_start_date ben_actl_prem_f.effective_start_date%TYPE;
808: l_effective_end_date ben_actl_prem_f.effective_end_date%TYPE;
809: --
810: l_in_object_version_number number := p_object_version_number ;
811: begin
804: --
805: l_proc varchar2(72) := g_package||'update_actual_premium';
806: l_object_version_number ben_actl_prem_f.object_version_number%TYPE;
807: l_effective_start_date ben_actl_prem_f.effective_start_date%TYPE;
808: l_effective_end_date ben_actl_prem_f.effective_end_date%TYPE;
809: --
810: l_in_object_version_number number := p_object_version_number ;
811: begin
812: --