DBA Data[Home] [Help]

APPS.BEN_PRTN_ELIG_PRFL_API dependencies on BEN_DERIVABLE_FACTOR

Line 337: ben_derivable_factor.eligy_prfl_handler('CREATE','ben_pgm_f','pgm_id',l_pgm_id);

333: end if;
334: --
335:
336: if l_pgm_id is not null then
337: ben_derivable_factor.eligy_prfl_handler('CREATE','ben_pgm_f','pgm_id',l_pgm_id);
338: end if;
339: --
340: if l_pl_id is not null then
341: ben_derivable_factor.eligy_prfl_handler('CREATE','ben_pl_f','pl_id',l_pl_id);

Line 341: ben_derivable_factor.eligy_prfl_handler('CREATE','ben_pl_f','pl_id',l_pl_id);

337: ben_derivable_factor.eligy_prfl_handler('CREATE','ben_pgm_f','pgm_id',l_pgm_id);
338: end if;
339: --
340: if l_pl_id is not null then
341: ben_derivable_factor.eligy_prfl_handler('CREATE','ben_pl_f','pl_id',l_pl_id);
342: end if;
343: --
344: if l_plip_id is not null then
345: ben_derivable_factor.eligy_prfl_handler('CREATE','ben_plip_f','plip_id',l_plip_id);

Line 345: ben_derivable_factor.eligy_prfl_handler('CREATE','ben_plip_f','plip_id',l_plip_id);

341: ben_derivable_factor.eligy_prfl_handler('CREATE','ben_pl_f','pl_id',l_pl_id);
342: end if;
343: --
344: if l_plip_id is not null then
345: ben_derivable_factor.eligy_prfl_handler('CREATE','ben_plip_f','plip_id',l_plip_id);
346: end if;
347: --
348: if l_ptip_id is not null then
349: ben_derivable_factor.eligy_prfl_handler('CREATE','ben_ptip_f','ptip_id',l_ptip_id);

Line 349: ben_derivable_factor.eligy_prfl_handler('CREATE','ben_ptip_f','ptip_id',l_ptip_id);

345: ben_derivable_factor.eligy_prfl_handler('CREATE','ben_plip_f','plip_id',l_plip_id);
346: end if;
347: --
348: if l_ptip_id is not null then
349: ben_derivable_factor.eligy_prfl_handler('CREATE','ben_ptip_f','ptip_id',l_ptip_id);
350: end if;
351: --
352: if l_oipl_id is not null then
353: ben_derivable_factor.eligy_prfl_handler('CREATE','ben_oipl_f','oipl_id',l_oipl_id);

Line 353: ben_derivable_factor.eligy_prfl_handler('CREATE','ben_oipl_f','oipl_id',l_oipl_id);

349: ben_derivable_factor.eligy_prfl_handler('CREATE','ben_ptip_f','ptip_id',l_ptip_id);
350: end if;
351: --
352: if l_oipl_id is not null then
353: ben_derivable_factor.eligy_prfl_handler('CREATE','ben_oipl_f','oipl_id',l_oipl_id);
354: end if;
355: --
356: -- Set all output arguments
357: p_prtn_elig_prfl_id := l_prtn_elig_prfl_id;

Line 722: ben_derivable_factor.eligy_prfl_handler('CREATE','ben_pgm_f','pgm_id',l_c1.pgm_id);

718:
719: hr_utility.set_location( ' old pgm flag ' || l_drvbl_fctr_prtn_elig_flag , 11);
720:
721: if nvl( l_drvbl_fctr_prtn_elig_flag,'N') = 'N' then
722: ben_derivable_factor.eligy_prfl_handler('CREATE','ben_pgm_f','pgm_id',l_c1.pgm_id);
723: else
724: ben_derivable_factor.eligy_prfl_handler('DELETE','ben_pgm_f','pgm_id',l_c1.pgm_id);
725: end if ;
726: end if;

Line 724: ben_derivable_factor.eligy_prfl_handler('DELETE','ben_pgm_f','pgm_id',l_c1.pgm_id);

720:
721: if nvl( l_drvbl_fctr_prtn_elig_flag,'N') = 'N' then
722: ben_derivable_factor.eligy_prfl_handler('CREATE','ben_pgm_f','pgm_id',l_c1.pgm_id);
723: else
724: ben_derivable_factor.eligy_prfl_handler('DELETE','ben_pgm_f','pgm_id',l_c1.pgm_id);
725: end if ;
726: end if;
727: --
728: if l_c1.pl_id is not null then

Line 738: ben_derivable_factor.eligy_prfl_handler('CREATE','ben_pl_f','pl_id',l_c1.pl_id);

734: hr_utility.set_location( ' old pl flag ' || l_drvbl_fctr_prtn_elig_flag , 11);
735:
736:
737: if nvl( l_drvbl_fctr_prtn_elig_flag,'N') = 'N' then
738: ben_derivable_factor.eligy_prfl_handler('CREATE','ben_pl_f','pl_id',l_c1.pl_id);
739: else
740: ben_derivable_factor.eligy_prfl_handler('DELETE','ben_pl_f','pl_id',l_c1.pl_id);
741: end if ;
742: end if;

Line 740: ben_derivable_factor.eligy_prfl_handler('DELETE','ben_pl_f','pl_id',l_c1.pl_id);

736:
737: if nvl( l_drvbl_fctr_prtn_elig_flag,'N') = 'N' then
738: ben_derivable_factor.eligy_prfl_handler('CREATE','ben_pl_f','pl_id',l_c1.pl_id);
739: else
740: ben_derivable_factor.eligy_prfl_handler('DELETE','ben_pl_f','pl_id',l_c1.pl_id);
741: end if ;
742: end if;
743: --
744: if l_c1.plip_id is not null then

Line 753: ben_derivable_factor.eligy_prfl_handler('CREATE','ben_plip_f','plip_id',l_c1.plip_id);

749:
750: hr_utility.set_location( ' old plip flag ' || l_drvbl_fctr_prtn_elig_flag , 11);
751:
752: if nvl( l_drvbl_fctr_prtn_elig_flag,'N') = 'N' then
753: ben_derivable_factor.eligy_prfl_handler('CREATE','ben_plip_f','plip_id',l_c1.plip_id);
754: else
755: ben_derivable_factor.eligy_prfl_handler('DELETE','ben_plip_f','plip_id',l_c1.plip_id);
756: end if ;
757: end if;

Line 755: ben_derivable_factor.eligy_prfl_handler('DELETE','ben_plip_f','plip_id',l_c1.plip_id);

751:
752: if nvl( l_drvbl_fctr_prtn_elig_flag,'N') = 'N' then
753: ben_derivable_factor.eligy_prfl_handler('CREATE','ben_plip_f','plip_id',l_c1.plip_id);
754: else
755: ben_derivable_factor.eligy_prfl_handler('DELETE','ben_plip_f','plip_id',l_c1.plip_id);
756: end if ;
757: end if;
758: --
759: if l_c1.ptip_id is not null then

Line 768: ben_derivable_factor.eligy_prfl_handler('CREATE','ben_ptip_f','ptip_id',l_c1.ptip_id);

764:
765: hr_utility.set_location( ' old ptip flag ' || l_drvbl_fctr_prtn_elig_flag , 11);
766:
767: if nvl( l_drvbl_fctr_prtn_elig_flag,'N') = 'N' then
768: ben_derivable_factor.eligy_prfl_handler('CREATE','ben_ptip_f','ptip_id',l_c1.ptip_id);
769: else
770: ben_derivable_factor.eligy_prfl_handler('DELETE','ben_ptip_f','ptip_id',l_c1.ptip_id);
771: end if ;
772: end if;

Line 770: ben_derivable_factor.eligy_prfl_handler('DELETE','ben_ptip_f','ptip_id',l_c1.ptip_id);

766:
767: if nvl( l_drvbl_fctr_prtn_elig_flag,'N') = 'N' then
768: ben_derivable_factor.eligy_prfl_handler('CREATE','ben_ptip_f','ptip_id',l_c1.ptip_id);
769: else
770: ben_derivable_factor.eligy_prfl_handler('DELETE','ben_ptip_f','ptip_id',l_c1.ptip_id);
771: end if ;
772: end if;
773: --
774: if l_c1.oipl_id is not null then

Line 784: ben_derivable_factor.eligy_prfl_handler('CREATE','ben_oipl_f','oipl_id',l_c1.oipl_id);

780: hr_utility.set_location( ' old oipl flag ' || l_drvbl_fctr_prtn_elig_flag , 11);
781:
782:
783: if nvl( l_drvbl_fctr_prtn_elig_flag,'N') = 'N' then
784: ben_derivable_factor.eligy_prfl_handler('CREATE','ben_oipl_f','oipl_id',l_c1.oipl_id);
785: else
786: ben_derivable_factor.eligy_prfl_handler('DELETE','ben_oipl_f','oipl_id',l_c1.oipl_id);
787: end if;
788:

Line 786: ben_derivable_factor.eligy_prfl_handler('DELETE','ben_oipl_f','oipl_id',l_c1.oipl_id);

782:
783: if nvl( l_drvbl_fctr_prtn_elig_flag,'N') = 'N' then
784: ben_derivable_factor.eligy_prfl_handler('CREATE','ben_oipl_f','oipl_id',l_c1.oipl_id);
785: else
786: ben_derivable_factor.eligy_prfl_handler('DELETE','ben_oipl_f','oipl_id',l_c1.oipl_id);
787: end if;
788:
789: end if;
790: end if ;

Line 956: ben_derivable_factor.eligy_prfl_handler('DELETE','ben_pgm_f','pgm_id',l_c1.pgm_id);

952: where a.prtn_elig_id = b.prtn_elig_id
953: and a.pgm_id = c.pgm_id)
954: and c.pgm_id = l_c1.pgm_id;
955: -- updates drvbl_fctr_prtn_elig_flag
956: ben_derivable_factor.eligy_prfl_handler('DELETE','ben_pgm_f','pgm_id',l_c1.pgm_id);
957: --
958: --updates elig_apls_flag to 'N' in ben_plip_f table only when
959: --no record found in profile and rule tables.
960: elsif l_c1.plip_id is not null then

Line 979: ben_derivable_factor.eligy_prfl_handler('DELETE','ben_plip_f','plip_id',l_c1.plip_id);

975: and a.plip_id = c.plip_id)
976: and c.plip_id = l_c1.plip_id;
977: --
978: -- updates drvbl_fctr_prtn_elig_flag
979: ben_derivable_factor.eligy_prfl_handler('DELETE','ben_plip_f','plip_id',l_c1.plip_id);
980: --
981: --
982: --updates elig_apls_flag to 'N' in ben_ptip_f table only when
983: --no record found in profile and rule tables.

Line 1002: ben_derivable_factor.eligy_prfl_handler('DELETE','ben_ptip_f','ptip_id',l_c1.ptip_id);

998: and a.ptip_id = c.ptip_id)
999: and c.ptip_id = l_c1.ptip_id;
1000: --
1001: -- updates drvbl_fctr_prtn_elig_flag
1002: ben_derivable_factor.eligy_prfl_handler('DELETE','ben_ptip_f','ptip_id',l_c1.ptip_id);
1003: --
1004: --updates elig_apls_flag to 'N' in ben_pl_f table only when
1005: --no record found in profile and rule tables.
1006: elsif l_c1.pl_id is not null then

Line 1024: ben_derivable_factor.eligy_prfl_handler('DELETE','ben_pl_f','pl_id',l_c1.pl_id);

1020: and a.pl_id = c.pl_id)
1021: and c.pl_id = l_c1.pl_id;
1022: --
1023: -- updates drvbl_fctr_prtn_elig_flag
1024: ben_derivable_factor.eligy_prfl_handler('DELETE','ben_pl_f','pl_id',l_c1.pl_id);
1025: --
1026: --
1027: --updates elig_apls_flag to 'N' in ben_oipl_f table only when
1028: --no record found in profile and rule tables.

Line 1047: ben_derivable_factor.eligy_prfl_handler('DELETE','ben_oipl_f','oipl_id',l_c1.oipl_id);

1043: and a.oipl_id = c.oipl_id)
1044: and c.oipl_id = l_c1.oipl_id;
1045: --
1046: -- updates drvbl_fctr_prtn_elig_flag
1047: ben_derivable_factor.eligy_prfl_handler('DELETE','ben_oipl_f','oipl_id',l_c1.oipl_id);
1048: --
1049: end if;
1050: --
1051: hr_utility.set_location(l_proc, 60);