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