DBA Data[Home] [Help]

APPS.BEN_ACTY_VRBL_RATE_API dependencies on BEN_DERIVABLE_RATE

Line 251: ben_derivable_rate.rate_prfl_handler('CREATE','ben_pgm_f','pgm_id',l_c1.pgm_id);

247: Open c1;
248: fetch c1 into l_c1;
249: close c1;
250: if l_c1.pgm_id is not null then
251: ben_derivable_rate.rate_prfl_handler('CREATE','ben_pgm_f','pgm_id',l_c1.pgm_id);
252: elsif l_c1.pl_id is not null then
253: ben_derivable_rate.rate_prfl_handler('CREATE','ben_pl_f','pl_id',l_c1.pl_id);
254: elsif l_c1.plip_id is not null then
255: ben_derivable_rate.rate_prfl_handler('CREATE','ben_plip_f','plip_id',l_c1.plip_id);

Line 253: ben_derivable_rate.rate_prfl_handler('CREATE','ben_pl_f','pl_id',l_c1.pl_id);

249: close c1;
250: if l_c1.pgm_id is not null then
251: ben_derivable_rate.rate_prfl_handler('CREATE','ben_pgm_f','pgm_id',l_c1.pgm_id);
252: elsif l_c1.pl_id is not null then
253: ben_derivable_rate.rate_prfl_handler('CREATE','ben_pl_f','pl_id',l_c1.pl_id);
254: elsif l_c1.plip_id is not null then
255: ben_derivable_rate.rate_prfl_handler('CREATE','ben_plip_f','plip_id',l_c1.plip_id);
256: elsif l_c1.ptip_id is not null then
257: ben_derivable_rate.rate_prfl_handler('CREATE','ben_ptip_f','ptip_id',l_c1.ptip_id);

Line 255: ben_derivable_rate.rate_prfl_handler('CREATE','ben_plip_f','plip_id',l_c1.plip_id);

251: ben_derivable_rate.rate_prfl_handler('CREATE','ben_pgm_f','pgm_id',l_c1.pgm_id);
252: elsif l_c1.pl_id is not null then
253: ben_derivable_rate.rate_prfl_handler('CREATE','ben_pl_f','pl_id',l_c1.pl_id);
254: elsif l_c1.plip_id is not null then
255: ben_derivable_rate.rate_prfl_handler('CREATE','ben_plip_f','plip_id',l_c1.plip_id);
256: elsif l_c1.ptip_id is not null then
257: ben_derivable_rate.rate_prfl_handler('CREATE','ben_ptip_f','ptip_id',l_c1.ptip_id);
258: elsif l_c1.oipl_id is not null then
259: ben_derivable_rate.rate_prfl_handler('CREATE','ben_oipl_f','oipl_id',l_c1.oipl_id);

Line 257: ben_derivable_rate.rate_prfl_handler('CREATE','ben_ptip_f','ptip_id',l_c1.ptip_id);

253: ben_derivable_rate.rate_prfl_handler('CREATE','ben_pl_f','pl_id',l_c1.pl_id);
254: elsif l_c1.plip_id is not null then
255: ben_derivable_rate.rate_prfl_handler('CREATE','ben_plip_f','plip_id',l_c1.plip_id);
256: elsif l_c1.ptip_id is not null then
257: ben_derivable_rate.rate_prfl_handler('CREATE','ben_ptip_f','ptip_id',l_c1.ptip_id);
258: elsif l_c1.oipl_id is not null then
259: ben_derivable_rate.rate_prfl_handler('CREATE','ben_oipl_f','oipl_id',l_c1.oipl_id);
260: elsif l_c1.opt_id is not null then
261: --

Line 259: ben_derivable_rate.rate_prfl_handler('CREATE','ben_oipl_f','oipl_id',l_c1.oipl_id);

255: ben_derivable_rate.rate_prfl_handler('CREATE','ben_plip_f','plip_id',l_c1.plip_id);
256: elsif l_c1.ptip_id is not null then
257: ben_derivable_rate.rate_prfl_handler('CREATE','ben_ptip_f','ptip_id',l_c1.ptip_id);
258: elsif l_c1.oipl_id is not null then
259: ben_derivable_rate.rate_prfl_handler('CREATE','ben_oipl_f','oipl_id',l_c1.oipl_id);
260: elsif l_c1.opt_id is not null then
261: --
262: --START Option Level Rates
263: for l_oipl in c_oipl(l_c1.opt_id) loop

Line 264: ben_derivable_rate.rate_prfl_handler('CREATE','ben_oipl_f','oipl_id',l_oipl.oipl_id);

260: elsif l_c1.opt_id is not null then
261: --
262: --START Option Level Rates
263: for l_oipl in c_oipl(l_c1.opt_id) loop
264: ben_derivable_rate.rate_prfl_handler('CREATE','ben_oipl_f','oipl_id',l_oipl.oipl_id);
265: end loop ;
266: --END Option Level Rates
267: --
268: end if;

Line 716: ben_derivable_rate.rate_prfl_handler('DELETE','ben_pgm_f','pgm_id',l_c1.pgm_id);

712: --
713: end;
714: --
715: if l_c1.pgm_id is not null then
716: ben_derivable_rate.rate_prfl_handler('DELETE','ben_pgm_f','pgm_id',l_c1.pgm_id);
717: elsif l_c1.pl_id is not null then
718: ben_derivable_rate.rate_prfl_handler('DELETE','ben_pl_f','pl_id',l_c1.pl_id);
719: elsif l_c1.plip_id is not null then
720: ben_derivable_rate.rate_prfl_handler('DELETE','ben_plip_f','plip_id',l_c1.plip_id);

Line 718: ben_derivable_rate.rate_prfl_handler('DELETE','ben_pl_f','pl_id',l_c1.pl_id);

714: --
715: if l_c1.pgm_id is not null then
716: ben_derivable_rate.rate_prfl_handler('DELETE','ben_pgm_f','pgm_id',l_c1.pgm_id);
717: elsif l_c1.pl_id is not null then
718: ben_derivable_rate.rate_prfl_handler('DELETE','ben_pl_f','pl_id',l_c1.pl_id);
719: elsif l_c1.plip_id is not null then
720: ben_derivable_rate.rate_prfl_handler('DELETE','ben_plip_f','plip_id',l_c1.plip_id);
721: elsif l_c1.ptip_id is not null then
722: ben_derivable_rate.rate_prfl_handler('DELETE','ben_ptip_f','ptip_id',l_c1.ptip_id);

Line 720: ben_derivable_rate.rate_prfl_handler('DELETE','ben_plip_f','plip_id',l_c1.plip_id);

716: ben_derivable_rate.rate_prfl_handler('DELETE','ben_pgm_f','pgm_id',l_c1.pgm_id);
717: elsif l_c1.pl_id is not null then
718: ben_derivable_rate.rate_prfl_handler('DELETE','ben_pl_f','pl_id',l_c1.pl_id);
719: elsif l_c1.plip_id is not null then
720: ben_derivable_rate.rate_prfl_handler('DELETE','ben_plip_f','plip_id',l_c1.plip_id);
721: elsif l_c1.ptip_id is not null then
722: ben_derivable_rate.rate_prfl_handler('DELETE','ben_ptip_f','ptip_id',l_c1.ptip_id);
723: elsif l_c1.oipl_id is not null then
724: ben_derivable_rate.rate_prfl_handler('DELETE','ben_oipl_f','oipl_id',l_c1.oipl_id);

Line 722: ben_derivable_rate.rate_prfl_handler('DELETE','ben_ptip_f','ptip_id',l_c1.ptip_id);

718: ben_derivable_rate.rate_prfl_handler('DELETE','ben_pl_f','pl_id',l_c1.pl_id);
719: elsif l_c1.plip_id is not null then
720: ben_derivable_rate.rate_prfl_handler('DELETE','ben_plip_f','plip_id',l_c1.plip_id);
721: elsif l_c1.ptip_id is not null then
722: ben_derivable_rate.rate_prfl_handler('DELETE','ben_ptip_f','ptip_id',l_c1.ptip_id);
723: elsif l_c1.oipl_id is not null then
724: ben_derivable_rate.rate_prfl_handler('DELETE','ben_oipl_f','oipl_id',l_c1.oipl_id);
725: elsif l_c1.opt_id is not null then
726: --

Line 724: ben_derivable_rate.rate_prfl_handler('DELETE','ben_oipl_f','oipl_id',l_c1.oipl_id);

720: ben_derivable_rate.rate_prfl_handler('DELETE','ben_plip_f','plip_id',l_c1.plip_id);
721: elsif l_c1.ptip_id is not null then
722: ben_derivable_rate.rate_prfl_handler('DELETE','ben_ptip_f','ptip_id',l_c1.ptip_id);
723: elsif l_c1.oipl_id is not null then
724: ben_derivable_rate.rate_prfl_handler('DELETE','ben_oipl_f','oipl_id',l_c1.oipl_id);
725: elsif l_c1.opt_id is not null then
726: --
727: for l_oipl in c_oipl(l_c1.opt_id) loop
728: --

Line 729: ben_derivable_rate.rate_prfl_handler('DELETE','ben_oipl_f','oipl_id',l_oipl.oipl_id);

725: elsif l_c1.opt_id is not null then
726: --
727: for l_oipl in c_oipl(l_c1.opt_id) loop
728: --
729: ben_derivable_rate.rate_prfl_handler('DELETE','ben_oipl_f','oipl_id',l_oipl.oipl_id);
730: --
731: end loop ;
732: --
733: end if;