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_MANAGE_LIFE_EVENTS dependencies on HR_API

Line 1570: hr_api.mandatory_arg_error(p_api_name => l_package,

1566: -- BENMNGLE process.
1567: --
1568: -- Check if mandatory arguments have been stipulated
1569: --
1570: hr_api.mandatory_arg_error(p_api_name => l_package,
1571: p_argument => 'p_business_group_id',
1572: p_argument_value => p_business_group_id);
1573: --
1574: hr_api.mandatory_arg_error(p_api_name => l_package,

Line 1574: hr_api.mandatory_arg_error(p_api_name => l_package,

1570: hr_api.mandatory_arg_error(p_api_name => l_package,
1571: p_argument => 'p_business_group_id',
1572: p_argument_value => p_business_group_id);
1573: --
1574: hr_api.mandatory_arg_error(p_api_name => l_package,
1575: p_argument => 'p_mode',
1576: p_argument_value => p_mode);
1577: --
1578: hr_api.mandatory_arg_error(p_api_name => l_package,

Line 1578: hr_api.mandatory_arg_error(p_api_name => l_package,

1574: hr_api.mandatory_arg_error(p_api_name => l_package,
1575: p_argument => 'p_mode',
1576: p_argument_value => p_mode);
1577: --
1578: hr_api.mandatory_arg_error(p_api_name => l_package,
1579: p_argument => 'p_effective_date',
1580: p_argument_value => p_effective_date);
1581: --
1582: --

Line 1583: hr_api.mandatory_arg_error(p_api_name => l_package,

1579: p_argument => 'p_effective_date',
1580: p_argument_value => p_effective_date);
1581: --
1582: --
1583: hr_api.mandatory_arg_error(p_api_name => l_package,
1584: p_argument => 'p_no_programs',
1585: p_argument_value => p_no_programs);
1586: --
1587: hr_api.mandatory_arg_error(p_api_name => l_package,

Line 1587: hr_api.mandatory_arg_error(p_api_name => l_package,

1583: hr_api.mandatory_arg_error(p_api_name => l_package,
1584: p_argument => 'p_no_programs',
1585: p_argument_value => p_no_programs);
1586: --
1587: hr_api.mandatory_arg_error(p_api_name => l_package,
1588: p_argument => 'p_no_plans',
1589: p_argument_value => p_no_plans);
1590: --
1591: hr_api.mandatory_arg_error(p_api_name => l_package,

Line 1591: hr_api.mandatory_arg_error(p_api_name => l_package,

1587: hr_api.mandatory_arg_error(p_api_name => l_package,
1588: p_argument => 'p_no_plans',
1589: p_argument_value => p_no_plans);
1590: --
1591: hr_api.mandatory_arg_error(p_api_name => l_package,
1592: p_argument => 'p_validate',
1593: p_argument_value => p_validate);
1594: --
1595: -- Business Rule Checks

Line 1933: if hr_api.not_exists_in_hr_lookups

1929: if g_debug then
1930: hr_utility.set_location ('BEN_BENMNGLE_MD '||l_package,50);
1931: end if;
1932: --
1933: if hr_api.not_exists_in_hr_lookups
1934: (p_lookup_type => 'BEN_BENMNGLE_MD',
1935: p_lookup_code => p_mode,
1936: p_effective_date => p_effective_date) then
1937: --

Line 2452: and pen.effective_end_date = hr_api.g_eot;

2448: where pen.pgm_id = p_pgm_id
2449: and pen.person_id = pil.person_id
2450: and pil.per_in_ler_id = p_per_in_ler_id
2451: and pen.prtt_enrt_rslt_stat_cd is null
2452: and pen.effective_end_date = hr_api.g_eot;
2453: --
2454: cursor c_result_pln (p_pl_id number) is
2455: select effective_start_date
2456: from ben_prtt_enrt_rslt_f pen,

Line 2462: and pen.effective_end_date = hr_api.g_eot;

2458: where pen.pl_id = p_pl_id
2459: and pen.person_id = pil.person_id
2460: and pil.per_in_ler_id = p_per_in_ler_id
2461: and pen.prtt_enrt_rslt_stat_cd is null
2462: and pen.effective_end_date = hr_api.g_eot;
2463: --
2464: l_effective_start_date date;
2465:
2466: begin

Line 3034: and ((cv_pl_id = -1 and cv_lf_evt_ocrd_dt = hr_api.g_eot)

3030: -- Bug 2541072 : Do not consider all per in ler's.
3031: --
3032: and pel.per_in_ler_id = pil.per_in_ler_id
3033: and pil.per_in_ler_stat_cd = 'STRTD'
3034: and ((cv_pl_id = -1 and cv_lf_evt_ocrd_dt = hr_api.g_eot)
3035: or
3036: (pil.lf_evt_ocrd_dt = cv_lf_evt_ocrd_dt and pel.pl_id = cv_pl_id)
3037: )
3038: and cwb.lvl_num = -1;

Line 3155: and ((cv_pl_id = -1 and cv_lf_evt_ocrd_dt = hr_api.g_eot)

3151: ben_per_in_ler pil
3152: where pel.pil_elctbl_chc_popl_id = cwh.emp_pil_elctbl_chc_popl_id
3153: and pel.per_in_ler_id = pil.per_in_ler_id
3154: and pil.per_in_ler_stat_cd = 'STRTD'
3155: and ((cv_pl_id = -1 and cv_lf_evt_ocrd_dt = hr_api.g_eot)
3156: or
3157: (pil.lf_evt_ocrd_dt = cv_lf_evt_ocrd_dt and pel.pl_id = cv_pl_id)
3158: )
3159: ) ;

Line 3190: and ((cv_pl_id = -1 and cv_lf_evt_ocrd_dt = hr_api.g_eot)

3186: ben_per_in_ler pil
3187: where pel.pil_elctbl_chc_popl_id = cwh.emp_pil_elctbl_chc_popl_id
3188: and pel.per_in_ler_id = pil.per_in_ler_id
3189: and pil.per_in_ler_stat_cd = 'STRTD'
3190: and ((cv_pl_id = -1 and cv_lf_evt_ocrd_dt = hr_api.g_eot)
3191: or
3192: (pil.lf_evt_ocrd_dt = cv_lf_evt_ocrd_dt and pel.pl_id = cv_pl_id)
3193: )
3194: ) ;

Line 3227: lv_lf_evt_ocrd_dt := hr_api.g_eot;

3223: hr_utility.set_location('Entering: '||l_proc,10);
3224: end if;
3225: --
3226: lv_pl_id := -1;
3227: lv_lf_evt_ocrd_dt := hr_api.g_eot;
3228: --
3229: if benutils.g_benefit_action_id is not null then
3230: --
3231: benutils.get_batch_parameters

Line 3482: and ((cv_pl_id = -1 and cv_lf_evt_ocrd_dt = hr_api.g_eot)

3478: -- Bug 2541072 : Do not consider all per in ler's.
3479: --
3480: and epe.per_in_ler_id = pil.per_in_ler_id
3481: and pil.per_in_ler_stat_cd = 'STRTD'
3482: and ((cv_pl_id = -1 and cv_lf_evt_ocrd_dt = hr_api.g_eot)
3483: or
3484: (pil.lf_evt_ocrd_dt = cv_lf_evt_ocrd_dt and epe.pl_id = cv_pl_id)
3485: )
3486: and cwb.lvl_num = -1;

Line 3612: and ((cv_pl_id = -1 and cv_lf_evt_ocrd_dt = hr_api.g_eot)

3608: ben_per_in_ler pil
3609: where epe.elig_per_elctbl_chc_id = cwh.emp_elig_per_elctbl_chc_id
3610: and epe.per_in_ler_id = pil.per_in_ler_id
3611: and pil.per_in_ler_stat_cd = 'STRTD'
3612: and ((cv_pl_id = -1 and cv_lf_evt_ocrd_dt = hr_api.g_eot)
3613: or
3614: (pil.lf_evt_ocrd_dt = cv_lf_evt_ocrd_dt and epe.pl_id = cv_pl_id)
3615: )
3616: ) ;

Line 3633: and ((cv_pl_id = -1 and cv_lf_evt_ocrd_dt = hr_api.g_eot)

3629: ben_per_in_ler pil
3630: where epe.elig_per_elctbl_chc_id = cwh.emp_elig_per_elctbl_chc_id
3631: and epe.per_in_ler_id = pil.per_in_ler_id
3632: and pil.per_in_ler_stat_cd = 'STRTD'
3633: and ((cv_pl_id = -1 and cv_lf_evt_ocrd_dt = hr_api.g_eot)
3634: or
3635: (pil.lf_evt_ocrd_dt = cv_lf_evt_ocrd_dt and epe.pl_id = cv_pl_id)
3636: )
3637: ) ;

Line 3651: lv_lf_evt_ocrd_dt := hr_api.g_eot;

3647: hr_utility.set_location('Entering: '||l_proc,10);
3648: end if;
3649: --
3650: lv_pl_id := -1;
3651: lv_lf_evt_ocrd_dt := hr_api.g_eot;
3652: --
3653: if benutils.g_benefit_action_id is not null then
3654: --
3655: benutils.get_batch_parameters

Line 3911: AND pen.effective_end_date = hr_api.g_eot

3907: WHERE pen.person_id = cv_person_id
3908: AND pen.business_group_id = cv_business_group_id
3909: AND pen.sspndd_flag = 'N'
3910: AND pen.prtt_enrt_rslt_stat_cd IS NULL
3911: AND pen.effective_end_date = hr_api.g_eot
3912: AND cv_lf_evt_ocrd_dt <= pen.enrt_cvg_thru_dt
3913: AND pen.enrt_cvg_strt_dt < pen.effective_end_date
3914: AND cv_pl_id = pen.pl_id
3915: AND (

Line 4426: AND pen.effective_end_date = hr_api.g_eot

4422: WHERE pen.person_id = cv_person_id
4423: AND pen.business_group_id = cv_business_group_id
4424: AND pen.sspndd_flag = 'N'
4425: AND pen.prtt_enrt_rslt_stat_cd IS NULL
4426: AND pen.effective_end_date = hr_api.g_eot
4427: AND cv_lf_evt_ocrd_dt <= pen.enrt_cvg_thru_dt
4428: AND pen.enrt_cvg_strt_dt < pen.effective_end_date
4429: AND cv_pl_id = pen.pl_id
4430: AND (

Line 8608: if l_hsc_rec.segment1 is not null and hr_api.return_legislation_code(p_business_group_id) = 'US'

8604: ben_person_object.get_object
8605: (p_soft_coding_keyflex_id => l_ass_rec.soft_coding_keyflex_id,
8606: p_rec => l_hsc_rec);
8607: --
8608: if l_hsc_rec.segment1 is not null and hr_api.return_legislation_code(p_business_group_id) = 'US'
8609: then
8610: --
8611: ben_org_object.get_object(p_organization_id => l_hsc_rec.segment1,
8612: p_rec => l_org2_rec);

Line 8663: if hr_api.return_legislation_code(p_business_group_id) = 'US'

8659: substr(l_org_rec.name,1,45)||
8660: benutils.id(l_ass_rec.organization_id);
8661: benutils.write(p_text => l_output_string);
8662: --
8663: if hr_api.return_legislation_code(p_business_group_id) = 'US'
8664: then
8665: l_output_string := 'Gre: '||
8666: substr(l_org2_rec.name,1,45);
8667: benutils.write(p_text => l_output_string);

Line 8808: IF l_hsc_rec.segment1 IS NOT NULL and hr_api.return_legislation_code(p_business_group_id) = 'US'

8804: p_rec => l_hsc_rec
8805: );
8806:
8807: --
8808: IF l_hsc_rec.segment1 IS NOT NULL and hr_api.return_legislation_code(p_business_group_id) = 'US'
8809: THEN
8810: --
8811: ben_org_object.get_object (p_organization_id => l_hsc_rec.segment1,
8812: p_rec => l_org2_rec

Line 8882: if hr_api.return_legislation_code(p_business_group_id) = 'US'

8878: || SUBSTR (l_org_rec.NAME, 1, 45)
8879: || benutils.ID (l_ass_rec.organization_id);
8880: benutils.WRITE (p_text => l_output_string);
8881: --
8882: if hr_api.return_legislation_code(p_business_group_id) = 'US'
8883: then
8884: l_output_string := 'Gre: ' || SUBSTR (l_org2_rec.NAME, 1, 45);
8885: benutils.WRITE (p_text => l_output_string);
8886: else

Line 9728: and pen.effective_end_date = hr_api.g_eot

9724: ,ben_elig_dpnt egd
9725: ,ben_prtt_enrt_rslt_f pen
9726: where pdp.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
9727: and pen.person_id = p_person_id
9728: and pen.effective_end_date = hr_api.g_eot
9729: and pen.business_group_id = p_business_group_id
9730: and nvl(pdp.cvg_thru_dt,hr_api.g_eot) <> hr_api.g_eot
9731: and pdp.business_group_id = pen.business_group_id
9732: and pdp.elig_cvrd_dpnt_id = egd.elig_cvrd_dpnt_id

Line 9730: and nvl(pdp.cvg_thru_dt,hr_api.g_eot) <> hr_api.g_eot

9726: where pdp.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
9727: and pen.person_id = p_person_id
9728: and pen.effective_end_date = hr_api.g_eot
9729: and pen.business_group_id = p_business_group_id
9730: and nvl(pdp.cvg_thru_dt,hr_api.g_eot) <> hr_api.g_eot
9731: and pdp.business_group_id = pen.business_group_id
9732: and pdp.elig_cvrd_dpnt_id = egd.elig_cvrd_dpnt_id
9733: and egd.dpnt_inelig_flag = 'Y'
9734: and egd.per_in_ler_id = p_per_in_ler_id

Line 9794: and pen.enrt_cvg_thru_dt <> hr_api.g_eot

9790: from ben_prtt_enrt_rslt_f pen
9791: where pen.person_id = p_person_id
9792: and pen.prtt_enrt_rslt_stat_cd is null
9793: and pen.sspndd_flag = 'N'
9794: and pen.enrt_cvg_thru_dt <> hr_api.g_eot
9795: and pen.effective_end_date = hr_api.g_eot
9796: and p_effective_date between pen.effective_start_date
9797: and pen.effective_end_date
9798: and pen.business_group_id = p_business_group_id

Line 9795: and pen.effective_end_date = hr_api.g_eot

9791: where pen.person_id = p_person_id
9792: and pen.prtt_enrt_rslt_stat_cd is null
9793: and pen.sspndd_flag = 'N'
9794: and pen.enrt_cvg_thru_dt <> hr_api.g_eot
9795: and pen.effective_end_date = hr_api.g_eot
9796: and p_effective_date between pen.effective_start_date
9797: and pen.effective_end_date
9798: and pen.business_group_id = p_business_group_id
9799: and pen.comp_lvl_cd not in ('PLANFC', 'PLANIMP')

Line 9810: and ( pen.enrt_cvg_thru_dt = hr_api.g_eot

9806: and pen.prtt_enrt_rslt_stat_cd is null
9807: and pen.sspndd_flag = 'N'
9808: and pen.ptip_id = p_ptip_id
9809: and pen.comp_lvl_cd not in ('PLANFC', 'PLANIMP')
9810: and ( pen.enrt_cvg_thru_dt = hr_api.g_eot
9811: or ( pen.enrt_cvg_thru_dt >= p_effective_date
9812: and nvl(pen.enrt_ovridn_flag,'N') = 'Y'
9813: )
9814: )

Line 9815: and pen.effective_end_date = hr_api.g_eot

9811: or ( pen.enrt_cvg_thru_dt >= p_effective_date
9812: and nvl(pen.enrt_ovridn_flag,'N') = 'Y'
9813: )
9814: )
9815: and pen.effective_end_date = hr_api.g_eot
9816: and p_effective_date between pen.effective_start_date
9817: and pen.effective_end_date
9818: and pen.business_group_id = p_business_group_id
9819: ;

Line 10925: if nvl(l_fonm_cvg_strt_dt, hr_api.g_sot) <>

10921: --
10922: -- If previous cvg start date and current date is different then
10923: -- clear the caches.
10924: --
10925: if nvl(l_fonm_cvg_strt_dt, hr_api.g_sot) <>
10926: l_rec_enrt_cvg_strt_dt
10927: then
10928: --
10929: hr_utility.set_location('clearing cache bnmngle '||l_fonm_cvg_strt_dt || ' / ' || l_rec_enrt_cvg_strt_dt ,10);