151: l_effective_end_date ben_ptip_f.effective_end_date%TYPE;
152: l_proc varchar2(72) := g_package||'create_Plan_Type_In_Program';
153: l_object_version_number ben_ptip_f.object_version_number%TYPE;
154: --
155: -- ben_optip_f
156: l_optip_id ben_optip_f.optip_id%type;
157: l_otp_effective_start_date ben_optip_f.effective_start_date%type;
158: l_otp_effective_end_date ben_optip_f.effective_end_date%type;
159: l_otp_object_version_number ben_optip_f.object_version_number%type;
152: l_proc varchar2(72) := g_package||'create_Plan_Type_In_Program';
153: l_object_version_number ben_ptip_f.object_version_number%TYPE;
154: --
155: -- ben_optip_f
156: l_optip_id ben_optip_f.optip_id%type;
157: l_otp_effective_start_date ben_optip_f.effective_start_date%type;
158: l_otp_effective_end_date ben_optip_f.effective_end_date%type;
159: l_otp_object_version_number ben_optip_f.object_version_number%type;
160:
153: l_object_version_number ben_ptip_f.object_version_number%TYPE;
154: --
155: -- ben_optip_f
156: l_optip_id ben_optip_f.optip_id%type;
157: l_otp_effective_start_date ben_optip_f.effective_start_date%type;
158: l_otp_effective_end_date ben_optip_f.effective_end_date%type;
159: l_otp_object_version_number ben_optip_f.object_version_number%type;
160:
161: begin
154: --
155: -- ben_optip_f
156: l_optip_id ben_optip_f.optip_id%type;
157: l_otp_effective_start_date ben_optip_f.effective_start_date%type;
158: l_otp_effective_end_date ben_optip_f.effective_end_date%type;
159: l_otp_object_version_number ben_optip_f.object_version_number%type;
160:
161: begin
162: --
155: -- ben_optip_f
156: l_optip_id ben_optip_f.optip_id%type;
157: l_otp_effective_start_date ben_optip_f.effective_start_date%type;
158: l_otp_effective_end_date ben_optip_f.effective_end_date%type;
159: l_otp_object_version_number ben_optip_f.object_version_number%type;
160:
161: begin
162: --
163: hr_utility.set_location('Entering:'|| l_proc, 10);