eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_ENROLLMENT_PROCESS dependencies on HR_API

Line 313: and pen.effective_end_date = hr_api.g_eot

309: select 'x'
310: from ben_prtt_enrt_rslt_f pen
311: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
312: and pen.prtt_enrt_rslt_stat_cd is null
313: and pen.effective_end_date = hr_api.g_eot
314: and pen.enrt_cvg_thru_dt = hr_api.g_eot ;
315: --
316: l_dummy varchar2(30);
317: --

Line 314: and pen.enrt_cvg_thru_dt = hr_api.g_eot ;

310: from ben_prtt_enrt_rslt_f pen
311: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
312: and pen.prtt_enrt_rslt_stat_cd is null
313: and pen.effective_end_date = hr_api.g_eot
314: and pen.enrt_cvg_thru_dt = hr_api.g_eot ;
315: --
316: l_dummy varchar2(30);
317: --
318: begin

Line 428: and pen.effective_end_date = hr_api.g_eot

424: pen.object_version_number
425: from ben_prtt_enrt_rslt_f pen
426: where pen.pl_id = p_pl_id
427: and pen.person_id = p_person_id
428: and pen.effective_end_date = hr_api.g_eot
429: and pen.enrt_cvg_thru_dt = hr_api.g_eot
430: and ( p_bnft_val is NULL or
431: pen.bnft_amt = p_bnft_val)
432: and prtt_enrt_rslt_stat_cd is null;

Line 429: and pen.enrt_cvg_thru_dt = hr_api.g_eot

425: from ben_prtt_enrt_rslt_f pen
426: where pen.pl_id = p_pl_id
427: and pen.person_id = p_person_id
428: and pen.effective_end_date = hr_api.g_eot
429: and pen.enrt_cvg_thru_dt = hr_api.g_eot
430: and ( p_bnft_val is NULL or
431: pen.bnft_amt = p_bnft_val)
432: and prtt_enrt_rslt_stat_cd is null;
433: --

Line 440: and pen.effective_end_date = hr_api.g_eot

436: pen.object_version_number
437: from ben_prtt_enrt_rslt_f pen
438: where pen.oipl_id = l_oipl_id
439: and pen.person_id = p_person_id
440: and pen.effective_end_date = hr_api.g_eot
441: and pen.enrt_cvg_thru_dt = hr_api.g_eot
442: and ( p_bnft_val is NULL or
443: pen.bnft_amt = p_bnft_val)
444: and prtt_enrt_rslt_stat_cd is null;

Line 441: and pen.enrt_cvg_thru_dt = hr_api.g_eot

437: from ben_prtt_enrt_rslt_f pen
438: where pen.oipl_id = l_oipl_id
439: and pen.person_id = p_person_id
440: and pen.effective_end_date = hr_api.g_eot
441: and pen.enrt_cvg_thru_dt = hr_api.g_eot
442: and ( p_bnft_val is NULL or
443: pen.bnft_amt = p_bnft_val)
444: and prtt_enrt_rslt_stat_cd is null;
445: --

Line 453: and pen.effective_end_date = hr_api.g_eot

449: from ben_prtt_enrt_rslt_f pen
450: where pen.pgm_id = p_pgm_id
451: and pen.pl_id = p_pl_id
452: and pen.person_id = p_person_id
453: and pen.effective_end_date = hr_api.g_eot
454: and pen.enrt_cvg_thru_dt = hr_api.g_eot
455: and ( p_bnft_val is NULL or
456: pen.bnft_amt = p_bnft_val)
457: and prtt_enrt_rslt_stat_cd is null;

Line 454: and pen.enrt_cvg_thru_dt = hr_api.g_eot

450: where pen.pgm_id = p_pgm_id
451: and pen.pl_id = p_pl_id
452: and pen.person_id = p_person_id
453: and pen.effective_end_date = hr_api.g_eot
454: and pen.enrt_cvg_thru_dt = hr_api.g_eot
455: and ( p_bnft_val is NULL or
456: pen.bnft_amt = p_bnft_val)
457: and prtt_enrt_rslt_stat_cd is null;
458: --

Line 466: and pen.effective_end_date = hr_api.g_eot

462: from ben_prtt_enrt_rslt_f pen
463: where pen.pgm_id = p_pgm_id
464: and pen.oipl_id = l_oipl_id
465: and pen.person_id = p_person_id
466: and pen.effective_end_date = hr_api.g_eot
467: and pen.enrt_cvg_thru_dt = hr_api.g_eot
468: and ( p_bnft_val is NULL or
469: pen.bnft_amt = p_bnft_val)
470: and prtt_enrt_rslt_stat_cd is null;

Line 467: and pen.enrt_cvg_thru_dt = hr_api.g_eot

463: where pen.pgm_id = p_pgm_id
464: and pen.oipl_id = l_oipl_id
465: and pen.person_id = p_person_id
466: and pen.effective_end_date = hr_api.g_eot
467: and pen.enrt_cvg_thru_dt = hr_api.g_eot
468: and ( p_bnft_val is NULL or
469: pen.bnft_amt = p_bnft_val)
470: and prtt_enrt_rslt_stat_cd is null;
471: --

Line 542: and (pen.effective_end_date <> hr_api.g_eot

538: pen.object_version_number
539: from ben_prtt_enrt_rslt_f pen
540: where pen.pl_id = p_pl_id
541: and pen.person_id = p_person_id
542: and (pen.effective_end_date <> hr_api.g_eot
543: or pen.enrt_cvg_thru_dt <> hr_api.g_eot);
544: --
545: cursor c_pen_oiplnip is
546: select pen.prtt_enrt_rslt_id,

Line 543: or pen.enrt_cvg_thru_dt <> hr_api.g_eot);

539: from ben_prtt_enrt_rslt_f pen
540: where pen.pl_id = p_pl_id
541: and pen.person_id = p_person_id
542: and (pen.effective_end_date <> hr_api.g_eot
543: or pen.enrt_cvg_thru_dt <> hr_api.g_eot);
544: --
545: cursor c_pen_oiplnip is
546: select pen.prtt_enrt_rslt_id,
547: pen.object_version_number

Line 551: and (pen.effective_end_date <> hr_api.g_eot

547: pen.object_version_number
548: from ben_prtt_enrt_rslt_f pen
549: where pen.oipl_id = l_oipl_id
550: and pen.person_id = p_person_id
551: and (pen.effective_end_date <> hr_api.g_eot
552: or pen.enrt_cvg_thru_dt <> hr_api.g_eot);
553: --
554: cursor c_pen_pl is
555: select pen.prtt_enrt_rslt_id,

Line 552: or pen.enrt_cvg_thru_dt <> hr_api.g_eot);

548: from ben_prtt_enrt_rslt_f pen
549: where pen.oipl_id = l_oipl_id
550: and pen.person_id = p_person_id
551: and (pen.effective_end_date <> hr_api.g_eot
552: or pen.enrt_cvg_thru_dt <> hr_api.g_eot);
553: --
554: cursor c_pen_pl is
555: select pen.prtt_enrt_rslt_id,
556: pen.object_version_number

Line 561: and (pen.effective_end_date <> hr_api.g_eot

557: from ben_prtt_enrt_rslt_f pen
558: where pen.pgm_id = p_pgm_id
559: and pen.pl_id = p_pl_id
560: and pen.person_id = p_person_id
561: and (pen.effective_end_date <> hr_api.g_eot
562: or pen.enrt_cvg_thru_dt <> hr_api.g_eot);
563: --
564: cursor c_pen_oipl is
565: select pen.prtt_enrt_rslt_id,

Line 562: or pen.enrt_cvg_thru_dt <> hr_api.g_eot);

558: where pen.pgm_id = p_pgm_id
559: and pen.pl_id = p_pl_id
560: and pen.person_id = p_person_id
561: and (pen.effective_end_date <> hr_api.g_eot
562: or pen.enrt_cvg_thru_dt <> hr_api.g_eot);
563: --
564: cursor c_pen_oipl is
565: select pen.prtt_enrt_rslt_id,
566: pen.object_version_number

Line 571: and (pen.effective_end_date <> hr_api.g_eot

567: from ben_prtt_enrt_rslt_f pen
568: where pen.pgm_id = p_pgm_id
569: and pen.oipl_id = l_oipl_id
570: and pen.person_id = p_person_id
571: and (pen.effective_end_date <> hr_api.g_eot
572: or pen.enrt_cvg_thru_dt <> hr_api.g_eot);
573: --
574: l_pen c_pen_plnip%ROWTYPE;
575: --

Line 572: or pen.enrt_cvg_thru_dt <> hr_api.g_eot);

568: where pen.pgm_id = p_pgm_id
569: and pen.oipl_id = l_oipl_id
570: and pen.person_id = p_person_id
571: and (pen.effective_end_date <> hr_api.g_eot
572: or pen.enrt_cvg_thru_dt <> hr_api.g_eot);
573: --
574: l_pen c_pen_plnip%ROWTYPE;
575: --
576: begin

Line 2129: l_dt_mode varchar2(30) := hr_api.g_update; --5675220

2125: l_pil c_pil%ROWTYPE;
2126: --
2127: l_epe c_epe_oipl%ROWTYPE;
2128: l_egd c_egd%ROWTYPE;
2129: l_dt_mode varchar2(30) := hr_api.g_update; --5675220
2130: l_elig_cvrd_dpnt_id number;
2131: l_dummy_date date;
2132: l_ovn number;
2133: l_person_id number := p_person_id;

Line 2164: IF l_person_id = hr_api.g_number THEN

2160: p_benefit_action_id => null);
2161: --
2162: -- END IF;
2163: --
2164: IF l_person_id = hr_api.g_number THEN
2165: l_person_id := null;
2166: END IF;
2167: --
2168: IF l_pgm_id = hr_api.g_number THEN

Line 2168: IF l_pgm_id = hr_api.g_number THEN

2164: IF l_person_id = hr_api.g_number THEN
2165: l_person_id := null;
2166: END IF;
2167: --
2168: IF l_pgm_id = hr_api.g_number THEN
2169: l_pgm_id := null;
2170: END IF;
2171: --
2172: IF l_pl_id = hr_api.g_number THEN

Line 2172: IF l_pl_id = hr_api.g_number THEN

2168: IF l_pgm_id = hr_api.g_number THEN
2169: l_pgm_id := null;
2170: END IF;
2171: --
2172: IF l_pl_id = hr_api.g_number THEN
2173: l_pl_id := null;
2174: END IF;
2175: --
2176: IF l_opt_id = hr_api.g_number THEN

Line 2176: IF l_opt_id = hr_api.g_number THEN

2172: IF l_pl_id = hr_api.g_number THEN
2173: l_pl_id := null;
2174: END IF;
2175: --
2176: IF l_opt_id = hr_api.g_number THEN
2177: l_opt_id := null;
2178: END IF;
2179: --
2180: IF l_ler_id = hr_api.g_number THEN

Line 2180: IF l_ler_id = hr_api.g_number THEN

2176: IF l_opt_id = hr_api.g_number THEN
2177: l_opt_id := null;
2178: END IF;
2179: --
2180: IF l_ler_id = hr_api.g_number THEN
2181: l_ler_id := null;
2182: END IF;
2183: --
2184: IF l_life_event_date = hr_api.g_date THEN

Line 2184: IF l_life_event_date = hr_api.g_date THEN

2180: IF l_ler_id = hr_api.g_number THEN
2181: l_ler_id := null;
2182: END IF;
2183: --
2184: IF l_life_event_date = hr_api.g_date THEN
2185: l_life_event_date := null;
2186: END IF;
2187: --
2188: IF l_contact_person_id = hr_api.g_number THEN

Line 2188: IF l_contact_person_id = hr_api.g_number THEN

2184: IF l_life_event_date = hr_api.g_date THEN
2185: l_life_event_date := null;
2186: END IF;
2187: --
2188: IF l_contact_person_id = hr_api.g_number THEN
2189: l_contact_person_id := null;
2190: END IF;
2191: --
2192: IF l_cvg_strt_dt = hr_api.g_date THEN

Line 2192: IF l_cvg_strt_dt = hr_api.g_date THEN

2188: IF l_contact_person_id = hr_api.g_number THEN
2189: l_contact_person_id := null;
2190: END IF;
2191: --
2192: IF l_cvg_strt_dt = hr_api.g_date THEN
2193: l_cvg_strt_dt := null;
2194: END IF;
2195: --
2196: IF l_cvg_thru_dt = hr_api.g_date THEN

Line 2196: IF l_cvg_thru_dt = hr_api.g_date THEN

2192: IF l_cvg_strt_dt = hr_api.g_date THEN
2193: l_cvg_strt_dt := null;
2194: END IF;
2195: --
2196: IF l_cvg_thru_dt = hr_api.g_date THEN
2197: l_cvg_thru_dt := null;
2198: END IF;
2199: --
2200: IF l_record_typ_cd = hr_api.g_varchar2 THEN

Line 2200: IF l_record_typ_cd = hr_api.g_varchar2 THEN

2196: IF l_cvg_thru_dt = hr_api.g_date THEN
2197: l_cvg_thru_dt := null;
2198: END IF;
2199: --
2200: IF l_record_typ_cd = hr_api.g_varchar2 THEN
2201: l_record_typ_cd := 'ENROLL' ;
2202: END IF;
2203: --
2204: fnd_file.put_line

Line 2541: IF l_dsgn_strt_dt = hr_api.g_date THEN

2537: p_benefit_action_id => null);
2538: --
2539: -- END IF;
2540: --
2541: IF l_dsgn_strt_dt = hr_api.g_date THEN
2542: l_dsgn_strt_dt := NULL;
2543: END IF;
2544: --
2545: IF l_dsgn_thru_dt = hr_api.g_date THEN

Line 2545: IF l_dsgn_thru_dt = hr_api.g_date THEN

2541: IF l_dsgn_strt_dt = hr_api.g_date THEN
2542: l_dsgn_strt_dt := NULL;
2543: END IF;
2544: --
2545: IF l_dsgn_thru_dt = hr_api.g_date THEN
2546: l_dsgn_thru_dt := NULL;
2547: END IF;
2548: --
2549: IF l_bnft_val = hr_api.g_number THEN

Line 2549: IF l_bnft_val = hr_api.g_number THEN

2545: IF l_dsgn_thru_dt = hr_api.g_date THEN
2546: l_dsgn_thru_dt := NULL;
2547: END IF;
2548: --
2549: IF l_bnft_val = hr_api.g_number THEN
2550: l_bnft_val := null;
2551: END IF;
2552: --
2553: IF l_amt_dsgd_val = hr_api.g_number THEN

Line 2553: IF l_amt_dsgd_val = hr_api.g_number THEN

2549: IF l_bnft_val = hr_api.g_number THEN
2550: l_bnft_val := null;
2551: END IF;
2552: --
2553: IF l_amt_dsgd_val = hr_api.g_number THEN
2554: l_amt_dsgd_val := null;
2555: END IF;
2556: --
2557: IF l_amt_dsgd_uom = hr_api.g_varchar2 THEN

Line 2557: IF l_amt_dsgd_uom = hr_api.g_varchar2 THEN

2553: IF l_amt_dsgd_val = hr_api.g_number THEN
2554: l_amt_dsgd_val := null;
2555: END IF;
2556: --
2557: IF l_amt_dsgd_uom = hr_api.g_varchar2 THEN
2558: l_amt_dsgd_uom := null;
2559: END IF;
2560: --
2561: IF l_addl_instrn_txt = hr_api.g_varchar2 THEN

Line 2561: IF l_addl_instrn_txt = hr_api.g_varchar2 THEN

2557: IF l_amt_dsgd_uom = hr_api.g_varchar2 THEN
2558: l_amt_dsgd_uom := null;
2559: END IF;
2560: --
2561: IF l_addl_instrn_txt = hr_api.g_varchar2 THEN
2562: l_addl_instrn_txt := null;
2563: END IF;
2564: --
2565: IF l_organization_id = hr_api.g_number THEN

Line 2565: IF l_organization_id = hr_api.g_number THEN

2561: IF l_addl_instrn_txt = hr_api.g_varchar2 THEN
2562: l_addl_instrn_txt := null;
2563: END IF;
2564: --
2565: IF l_organization_id = hr_api.g_number THEN
2566: l_organization_id := NULL ;
2567: END IF;
2568: --
2569: IF l_ttee_person_id = hr_api.g_number THEN

Line 2569: IF l_ttee_person_id = hr_api.g_number THEN

2565: IF l_organization_id = hr_api.g_number THEN
2566: l_organization_id := NULL ;
2567: END IF;
2568: --
2569: IF l_ttee_person_id = hr_api.g_number THEN
2570: l_ttee_person_id := NULL;
2571: END IF;
2572: --
2573: IF l_record_typ_cd = hr_api.g_varchar2 THEN

Line 2573: IF l_record_typ_cd = hr_api.g_varchar2 THEN

2569: IF l_ttee_person_id = hr_api.g_number THEN
2570: l_ttee_person_id := NULL;
2571: END IF;
2572: --
2573: IF l_record_typ_cd = hr_api.g_varchar2 THEN
2574: l_record_typ_cd := 'ENROLL';
2575: END IF;
2576: --
2577: fnd_file.put_line

Line 2695: l_dt_mode := hr_api.g_update ;

2691: --
2692: ELSIF l_bnf.pl_bnf_id IS NOT NULL and l_dsgn_thru_dt IS NULL THEN
2693: --
2694: IF l_bnf.effective_start_date < p_effective_date THEN
2695: l_dt_mode := hr_api.g_update ;
2696: ELSE
2697: l_dt_mode := hr_api.g_correction ;
2698: END IF ;
2699: --

Line 2697: l_dt_mode := hr_api.g_correction ;

2693: --
2694: IF l_bnf.effective_start_date < p_effective_date THEN
2695: l_dt_mode := hr_api.g_update ;
2696: ELSE
2697: l_dt_mode := hr_api.g_correction ;
2698: END IF ;
2699: --
2700: ben_plan_beneficiary_api.update_plan_beneficiary
2701: ( p_validate => p_validate

Line 2725: l_dt_mode := hr_api.g_update ;

2721: --
2722: ELSIF l_bnf.pl_bnf_id IS NOT NULL AND l_dsgn_thru_dt IS NOT NULL THEN
2723: --
2724: IF l_bnf.effective_start_date < p_effective_date THEN
2725: l_dt_mode := hr_api.g_update ;
2726: ben_plan_beneficiary_api.update_plan_beneficiary
2727: ( p_validate => p_validate
2728: ,p_pl_bnf_id => l_bnf.pl_bnf_id
2729: ,p_effective_start_date => l_dummy_date

Line 2750: l_dt_mode := hr_api.g_zap ;

2746: );
2747: --
2748: ELSE
2749: --
2750: l_dt_mode := hr_api.g_zap ;
2751: ben_plan_beneficiary_api.delete_plan_beneficiary
2752: (p_validate => p_validate
2753: ,p_pl_bnf_id => l_bnf.pl_bnf_id
2754: ,p_effective_start_date => l_dummy_date