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 316: and pen.effective_end_date = hr_api.g_eot

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

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

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

Line 431: and pen.effective_end_date = hr_api.g_eot

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

Line 432: and pen.enrt_cvg_thru_dt = hr_api.g_eot

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

Line 443: and pen.effective_end_date = hr_api.g_eot

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

Line 444: and pen.enrt_cvg_thru_dt = hr_api.g_eot

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

Line 456: and pen.effective_end_date = hr_api.g_eot

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

Line 457: and pen.enrt_cvg_thru_dt = hr_api.g_eot

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

Line 469: and pen.effective_end_date = hr_api.g_eot

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

Line 470: and pen.enrt_cvg_thru_dt = hr_api.g_eot

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 2171: IF l_person_id = hr_api.g_number THEN

2167: p_benefit_action_id => null);
2168: --
2169: -- END IF;
2170: --
2171: IF l_person_id = hr_api.g_number THEN
2172: l_person_id := null;
2173: END IF;
2174: --
2175: IF l_pgm_id = hr_api.g_number THEN

Line 2175: IF l_pgm_id = hr_api.g_number THEN

2171: IF l_person_id = hr_api.g_number THEN
2172: l_person_id := null;
2173: END IF;
2174: --
2175: IF l_pgm_id = hr_api.g_number THEN
2176: l_pgm_id := null;
2177: END IF;
2178: --
2179: IF l_pl_id = hr_api.g_number THEN

Line 2179: IF l_pl_id = hr_api.g_number THEN

2175: IF l_pgm_id = hr_api.g_number THEN
2176: l_pgm_id := null;
2177: END IF;
2178: --
2179: IF l_pl_id = hr_api.g_number THEN
2180: l_pl_id := null;
2181: END IF;
2182: --
2183: IF l_opt_id = hr_api.g_number THEN

Line 2183: IF l_opt_id = hr_api.g_number THEN

2179: IF l_pl_id = hr_api.g_number THEN
2180: l_pl_id := null;
2181: END IF;
2182: --
2183: IF l_opt_id = hr_api.g_number THEN
2184: l_opt_id := null;
2185: END IF;
2186: --
2187: IF l_ler_id = hr_api.g_number THEN

Line 2187: IF l_ler_id = hr_api.g_number THEN

2183: IF l_opt_id = hr_api.g_number THEN
2184: l_opt_id := null;
2185: END IF;
2186: --
2187: IF l_ler_id = hr_api.g_number THEN
2188: l_ler_id := null;
2189: END IF;
2190: --
2191: IF l_life_event_date = hr_api.g_date THEN

Line 2191: IF l_life_event_date = hr_api.g_date THEN

2187: IF l_ler_id = hr_api.g_number THEN
2188: l_ler_id := null;
2189: END IF;
2190: --
2191: IF l_life_event_date = hr_api.g_date THEN
2192: l_life_event_date := null;
2193: END IF;
2194: --
2195: IF l_contact_person_id = hr_api.g_number THEN

Line 2195: IF l_contact_person_id = hr_api.g_number THEN

2191: IF l_life_event_date = hr_api.g_date THEN
2192: l_life_event_date := null;
2193: END IF;
2194: --
2195: IF l_contact_person_id = hr_api.g_number THEN
2196: l_contact_person_id := null;
2197: END IF;
2198: --
2199: IF l_cvg_strt_dt = hr_api.g_date THEN

Line 2199: IF l_cvg_strt_dt = hr_api.g_date THEN

2195: IF l_contact_person_id = hr_api.g_number THEN
2196: l_contact_person_id := null;
2197: END IF;
2198: --
2199: IF l_cvg_strt_dt = hr_api.g_date THEN
2200: l_cvg_strt_dt := null;
2201: END IF;
2202: --
2203: IF l_cvg_thru_dt = hr_api.g_date THEN

Line 2203: IF l_cvg_thru_dt = hr_api.g_date THEN

2199: IF l_cvg_strt_dt = hr_api.g_date THEN
2200: l_cvg_strt_dt := null;
2201: END IF;
2202: --
2203: IF l_cvg_thru_dt = hr_api.g_date THEN
2204: l_cvg_thru_dt := null;
2205: END IF;
2206: --
2207: IF l_record_typ_cd = hr_api.g_varchar2 THEN

Line 2207: IF l_record_typ_cd = hr_api.g_varchar2 THEN

2203: IF l_cvg_thru_dt = hr_api.g_date THEN
2204: l_cvg_thru_dt := null;
2205: END IF;
2206: --
2207: IF l_record_typ_cd = hr_api.g_varchar2 THEN
2208: l_record_typ_cd := 'ENROLL' ;
2209: END IF;
2210: --
2211: fnd_file.put_line

Line 2574: IF l_dsgn_strt_dt = hr_api.g_date THEN

2570: p_benefit_action_id => null);
2571: --
2572: -- END IF;
2573: --
2574: IF l_dsgn_strt_dt = hr_api.g_date THEN
2575: l_dsgn_strt_dt := NULL;
2576: END IF;
2577: --
2578: IF l_dsgn_thru_dt = hr_api.g_date THEN

Line 2578: IF l_dsgn_thru_dt = hr_api.g_date THEN

2574: IF l_dsgn_strt_dt = hr_api.g_date THEN
2575: l_dsgn_strt_dt := NULL;
2576: END IF;
2577: --
2578: IF l_dsgn_thru_dt = hr_api.g_date THEN
2579: l_dsgn_thru_dt := NULL;
2580: END IF;
2581: --
2582: IF l_bnft_val = hr_api.g_number THEN

Line 2582: IF l_bnft_val = hr_api.g_number THEN

2578: IF l_dsgn_thru_dt = hr_api.g_date THEN
2579: l_dsgn_thru_dt := NULL;
2580: END IF;
2581: --
2582: IF l_bnft_val = hr_api.g_number THEN
2583: l_bnft_val := null;
2584: END IF;
2585: --
2586: IF l_amt_dsgd_val = hr_api.g_number THEN

Line 2586: IF l_amt_dsgd_val = hr_api.g_number THEN

2582: IF l_bnft_val = hr_api.g_number THEN
2583: l_bnft_val := null;
2584: END IF;
2585: --
2586: IF l_amt_dsgd_val = hr_api.g_number THEN
2587: l_amt_dsgd_val := null;
2588: END IF;
2589: --
2590: IF l_amt_dsgd_uom = hr_api.g_varchar2 THEN

Line 2590: IF l_amt_dsgd_uom = hr_api.g_varchar2 THEN

2586: IF l_amt_dsgd_val = hr_api.g_number THEN
2587: l_amt_dsgd_val := null;
2588: END IF;
2589: --
2590: IF l_amt_dsgd_uom = hr_api.g_varchar2 THEN
2591: l_amt_dsgd_uom := null;
2592: END IF;
2593: --
2594: IF l_addl_instrn_txt = hr_api.g_varchar2 THEN

Line 2594: IF l_addl_instrn_txt = hr_api.g_varchar2 THEN

2590: IF l_amt_dsgd_uom = hr_api.g_varchar2 THEN
2591: l_amt_dsgd_uom := null;
2592: END IF;
2593: --
2594: IF l_addl_instrn_txt = hr_api.g_varchar2 THEN
2595: l_addl_instrn_txt := null;
2596: END IF;
2597: --
2598: IF l_organization_id = hr_api.g_number THEN

Line 2598: IF l_organization_id = hr_api.g_number THEN

2594: IF l_addl_instrn_txt = hr_api.g_varchar2 THEN
2595: l_addl_instrn_txt := null;
2596: END IF;
2597: --
2598: IF l_organization_id = hr_api.g_number THEN
2599: l_organization_id := NULL ;
2600: END IF;
2601: --
2602: IF l_ttee_person_id = hr_api.g_number THEN

Line 2602: IF l_ttee_person_id = hr_api.g_number THEN

2598: IF l_organization_id = hr_api.g_number THEN
2599: l_organization_id := NULL ;
2600: END IF;
2601: --
2602: IF l_ttee_person_id = hr_api.g_number THEN
2603: l_ttee_person_id := NULL;
2604: END IF;
2605: --
2606: IF l_record_typ_cd = hr_api.g_varchar2 THEN

Line 2606: IF l_record_typ_cd = hr_api.g_varchar2 THEN

2602: IF l_ttee_person_id = hr_api.g_number THEN
2603: l_ttee_person_id := NULL;
2604: END IF;
2605: --
2606: IF l_record_typ_cd = hr_api.g_varchar2 THEN
2607: l_record_typ_cd := 'ENROLL';
2608: END IF;
2609: --
2610: fnd_file.put_line

Line 2728: l_dt_mode := hr_api.g_update ;

2724: --
2725: ELSIF l_bnf.pl_bnf_id IS NOT NULL and l_dsgn_thru_dt IS NULL THEN
2726: --
2727: IF l_bnf.effective_start_date < p_effective_date THEN
2728: l_dt_mode := hr_api.g_update ;
2729: ELSE
2730: l_dt_mode := hr_api.g_correction ;
2731: END IF ;
2732: --

Line 2730: l_dt_mode := hr_api.g_correction ;

2726: --
2727: IF l_bnf.effective_start_date < p_effective_date THEN
2728: l_dt_mode := hr_api.g_update ;
2729: ELSE
2730: l_dt_mode := hr_api.g_correction ;
2731: END IF ;
2732: --
2733: ben_plan_beneficiary_api.update_plan_beneficiary
2734: ( p_validate => p_validate

Line 2758: l_dt_mode := hr_api.g_update ;

2754: --
2755: ELSIF l_bnf.pl_bnf_id IS NOT NULL AND l_dsgn_thru_dt IS NOT NULL THEN
2756: --
2757: IF l_bnf.effective_start_date < p_effective_date THEN
2758: l_dt_mode := hr_api.g_update ;
2759: ben_plan_beneficiary_api.update_plan_beneficiary
2760: ( p_validate => p_validate
2761: ,p_pl_bnf_id => l_bnf.pl_bnf_id
2762: ,p_effective_start_date => l_dummy_date

Line 2783: l_dt_mode := hr_api.g_zap ;

2779: );
2780: --
2781: ELSE
2782: --
2783: l_dt_mode := hr_api.g_zap ;
2784: ben_plan_beneficiary_api.delete_plan_beneficiary
2785: (p_validate => p_validate
2786: ,p_pl_bnf_id => l_bnf.pl_bnf_id
2787: ,p_effective_start_date => l_dummy_date