273: CURSOR C1 IS SELECT per_periods_of_service_s.NEXTVAL FROM sys.dual;
274: --
275: -- START WWBUG 1390173 fix
276: --
277: l_old ben_pps_ler.g_pps_ler_rec;
278: l_new ben_pps_ler.g_pps_ler_rec;
279: --
280: l_proc varchar2(24) := 'Insert_period_of_Service';
281: --
274: --
275: -- START WWBUG 1390173 fix
276: --
277: l_old ben_pps_ler.g_pps_ler_rec;
278: l_new ben_pps_ler.g_pps_ler_rec;
279: --
280: l_proc varchar2(24) := 'Insert_period_of_Service';
281: --
282: -- END WWBUG 1390173 fix
325: --
326: IF g_debug THEN
327: hr_utility.set_location('Entering: '|| g_package || l_proc, 20);
328: END IF;
329: ben_pps_ler.ler_chk(p_old => l_old
330: ,p_new => l_new
331: ,p_event => 'INSERTING'
332: ,p_effective_date => x_date_start);
333: --