APPS.BEN_PRTN_ELIG_PRFL_API dependencies on BEN_PGM_F

Line 275: --updates elig_apls_flag to 'Y' in ben_pgm_f table.

271: fetch c1 into l_pgm_id,l_pl_id,l_ptip_id,l_plip_id,l_oipl_id;
272: close c1;
273: --
274: --update statements
275: --updates elig_apls_flag to 'Y' in ben_pgm_f table.
276: --
277: if l_pgm_id is not null then
278: update ben_pgm_f c
279: set c.elig_apls_flag = 'Y'

Line 278: update ben_pgm_f c

274: --update statements
275: --updates elig_apls_flag to 'Y' in ben_pgm_f table.
276: --
277: if l_pgm_id is not null then
278: update ben_pgm_f c
279: set c.elig_apls_flag = 'Y'
280: where c.business_group_id = p_business_group_id
281: and c.elig_apls_flag <> 'Y'
282: and c.pgm_id = l_pgm_id ;

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 464: from ben_pgm_f

460: l_c1 c1%rowtype;
461: --
462: cursor c_pgm_flag (c_id number) is
463: select drvbl_fctr_prtn_elig_flag
464: from ben_pgm_f
465: where pgm_id = c_id
466: and p_effective_date between effective_start_date and effective_end_date ;
467:
468: cursor c_pl_flag (c_id number) is

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 936: --updates elig_apls_flag to 'N' in ben_pgm_f table only when

932: -- End of API User Hook for the after hook of delete_PRTN_ELIG_PRFL
933: --
934: end;
935: --
936: --updates elig_apls_flag to 'N' in ben_pgm_f table only when
937: --no record found in profile and rule tables.
938: if l_c1.pgm_id is not null then
939: --
940: update ben_pgm_f c

Line 940: update ben_pgm_f c

936: --updates elig_apls_flag to 'N' in ben_pgm_f table only when
937: --no record found in profile and rule tables.
938: if l_c1.pgm_id is not null then
939: --
940: update ben_pgm_f c
941: set c.elig_apls_flag = 'N'
942: where not exists
943: (select a.pgm_id
944: from ben_prtn_elig_f a,

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