246: close c1;
247: --
248: if l_c1.pl_id is not null then
249: --
250: ben_derivable_rate.rate_prfl_handler('CREATE','ben_pl_f','pl_id',l_c1.pl_id);
251: --
252: elsif l_c1.oipl_id is not null then
253: --
254: ben_derivable_rate.rate_prfl_handler('CREATE','ben_oipl_f','oipl_id',l_c1.oipl_id);
250: ben_derivable_rate.rate_prfl_handler('CREATE','ben_pl_f','pl_id',l_c1.pl_id);
251: --
252: elsif l_c1.oipl_id is not null then
253: --
254: ben_derivable_rate.rate_prfl_handler('CREATE','ben_oipl_f','oipl_id',l_c1.oipl_id);
255: --
256: elsif l_c1.plip_id is not null then
257: --
258: ben_derivable_rate.rate_prfl_handler('CREATE','ben_plip_f','plip_id',l_c1.plip_id);
254: ben_derivable_rate.rate_prfl_handler('CREATE','ben_oipl_f','oipl_id',l_c1.oipl_id);
255: --
256: elsif l_c1.plip_id is not null then
257: --
258: ben_derivable_rate.rate_prfl_handler('CREATE','ben_plip_f','plip_id',l_c1.plip_id);
259: --
260: end if;
261: --
262: hr_utility.set_location(l_proc, 60);
694: close c1;
695: --
696: if l_c1.pl_id is not null then
697: --
698: ben_derivable_rate.rate_prfl_handler('DELETE','ben_pl_f','pl_id',l_c1.pl_id);
699: --
700: elsif l_c1.oipl_id is not null then
701: --
702: ben_derivable_rate.rate_prfl_handler('DELETE','ben_oipl_f','oipl_id',l_c1.oipl_id);
698: ben_derivable_rate.rate_prfl_handler('DELETE','ben_pl_f','pl_id',l_c1.pl_id);
699: --
700: elsif l_c1.oipl_id is not null then
701: --
702: ben_derivable_rate.rate_prfl_handler('DELETE','ben_oipl_f','oipl_id',l_c1.oipl_id);
703: --
704: elsif l_c1.plip_id is not null then
705: --
706: ben_derivable_rate.rate_prfl_handler('DELETE','ben_plip_f','plip_id',l_c1.plip_id);
702: ben_derivable_rate.rate_prfl_handler('DELETE','ben_oipl_f','oipl_id',l_c1.oipl_id);
703: --
704: elsif l_c1.plip_id is not null then
705: --
706: ben_derivable_rate.rate_prfl_handler('DELETE','ben_plip_f','plip_id',l_c1.plip_id);
707: --
708: end if;
709: --
710: hr_utility.set_location(l_proc, 60);