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 1423: (l_get_end_date_version.effective_end_date <> hr_api.g_eot) then

1419: hr_utility.set_location('uxx effective_end_date'||l_get_end_date_version.effective_end_date,10);
1420: hr_utility.set_location('uxx object_version'||l_get_end_date_version.object_version_number,10);
1421:
1422: if (l_get_end_date_version.effective_end_date is not null) and
1423: (l_get_end_date_version.effective_end_date <> hr_api.g_eot) then
1424:
1425: open c_get_option(l_fut_elig_per_rec.elig_per_id,p_effective_date);
1426: loop
1427: fetch c_get_option into l_get_option;

Line 1439: (l_get_end_date_version_opt.effective_end_date <> hr_api.g_eot) then

1435:
1436: hr_utility.set_location('uxx2 opt effective_end_date'||l_get_end_date_version_opt.effective_end_date,20);
1437: hr_utility.set_location('uxx2 opt object version'||l_get_end_date_version_opt.object_version_number,20);
1438: if (l_get_end_date_version_opt.effective_end_date is not null) and
1439: (l_get_end_date_version_opt.effective_end_date <> hr_api.g_eot) then
1440:
1441: open c_get_elig_per_opt_rec(l_get_option.elig_per_opt_id
1442: ,l_prev_pil_id
1443: ,p_effective_date);

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

1958: -- BENMNGLE process.
1959: --
1960: -- Check if mandatory arguments have been stipulated
1961: --
1962: hr_api.mandatory_arg_error(p_api_name => l_package,
1963: p_argument => 'p_business_group_id',
1964: p_argument_value => p_business_group_id);
1965: --
1966: hr_api.mandatory_arg_error(p_api_name => l_package,

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

1962: hr_api.mandatory_arg_error(p_api_name => l_package,
1963: p_argument => 'p_business_group_id',
1964: p_argument_value => p_business_group_id);
1965: --
1966: hr_api.mandatory_arg_error(p_api_name => l_package,
1967: p_argument => 'p_mode',
1968: p_argument_value => p_mode);
1969: --
1970: hr_api.mandatory_arg_error(p_api_name => l_package,

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

1966: hr_api.mandatory_arg_error(p_api_name => l_package,
1967: p_argument => 'p_mode',
1968: p_argument_value => p_mode);
1969: --
1970: hr_api.mandatory_arg_error(p_api_name => l_package,
1971: p_argument => 'p_effective_date',
1972: p_argument_value => p_effective_date);
1973: --
1974: --

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

1971: p_argument => 'p_effective_date',
1972: p_argument_value => p_effective_date);
1973: --
1974: --
1975: hr_api.mandatory_arg_error(p_api_name => l_package,
1976: p_argument => 'p_no_programs',
1977: p_argument_value => p_no_programs);
1978: --
1979: hr_api.mandatory_arg_error(p_api_name => l_package,

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

1975: hr_api.mandatory_arg_error(p_api_name => l_package,
1976: p_argument => 'p_no_programs',
1977: p_argument_value => p_no_programs);
1978: --
1979: hr_api.mandatory_arg_error(p_api_name => l_package,
1980: p_argument => 'p_no_plans',
1981: p_argument_value => p_no_plans);
1982: --
1983: hr_api.mandatory_arg_error(p_api_name => l_package,

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

1979: hr_api.mandatory_arg_error(p_api_name => l_package,
1980: p_argument => 'p_no_plans',
1981: p_argument_value => p_no_plans);
1982: --
1983: hr_api.mandatory_arg_error(p_api_name => l_package,
1984: p_argument => 'p_validate',
1985: p_argument_value => p_validate);
1986: --
1987: -- Business Rule Checks

Line 2325: if hr_api.not_exists_in_hr_lookups

2321: if g_debug then
2322: hr_utility.set_location ('BEN_BENMNGLE_MD '||l_package,50);
2323: end if;
2324: --
2325: if hr_api.not_exists_in_hr_lookups
2326: (p_lookup_type => 'BEN_BENMNGLE_MD',
2327: p_lookup_code => p_mode,
2328: p_effective_date => p_effective_date) then
2329: --

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

2840: where pen.pgm_id = p_pgm_id
2841: and pen.person_id = pil.person_id
2842: and pil.per_in_ler_id = p_per_in_ler_id
2843: and pen.prtt_enrt_rslt_stat_cd is null
2844: and pen.effective_end_date = hr_api.g_eot;
2845: --
2846: cursor c_result_pln (p_pl_id number) is
2847: select effective_start_date
2848: from ben_prtt_enrt_rslt_f pen,

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

2850: where pen.pl_id = p_pl_id
2851: and pen.person_id = pil.person_id
2852: and pil.per_in_ler_id = p_per_in_ler_id
2853: and pen.prtt_enrt_rslt_stat_cd is null
2854: and pen.effective_end_date = hr_api.g_eot;
2855: --
2856: l_effective_start_date date;
2857:
2858: begin

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

3422: -- Bug 2541072 : Do not consider all per in ler's.
3423: --
3424: and pel.per_in_ler_id = pil.per_in_ler_id
3425: and pil.per_in_ler_stat_cd = 'STRTD'
3426: and ((cv_pl_id = -1 and cv_lf_evt_ocrd_dt = hr_api.g_eot)
3427: or
3428: (pil.lf_evt_ocrd_dt = cv_lf_evt_ocrd_dt and pel.pl_id = cv_pl_id)
3429: )
3430: and cwb.lvl_num = -1;

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

3543: ben_per_in_ler pil
3544: where pel.pil_elctbl_chc_popl_id = cwh.emp_pil_elctbl_chc_popl_id
3545: and pel.per_in_ler_id = pil.per_in_ler_id
3546: and pil.per_in_ler_stat_cd = 'STRTD'
3547: and ((cv_pl_id = -1 and cv_lf_evt_ocrd_dt = hr_api.g_eot)
3548: or
3549: (pil.lf_evt_ocrd_dt = cv_lf_evt_ocrd_dt and pel.pl_id = cv_pl_id)
3550: )
3551: ) ;

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

3578: ben_per_in_ler pil
3579: where pel.pil_elctbl_chc_popl_id = cwh.emp_pil_elctbl_chc_popl_id
3580: and pel.per_in_ler_id = pil.per_in_ler_id
3581: and pil.per_in_ler_stat_cd = 'STRTD'
3582: and ((cv_pl_id = -1 and cv_lf_evt_ocrd_dt = hr_api.g_eot)
3583: or
3584: (pil.lf_evt_ocrd_dt = cv_lf_evt_ocrd_dt and pel.pl_id = cv_pl_id)
3585: )
3586: ) ;

Line 3619: lv_lf_evt_ocrd_dt := hr_api.g_eot;

3615: hr_utility.set_location('Entering: '||l_proc,10);
3616: end if;
3617: --
3618: lv_pl_id := -1;
3619: lv_lf_evt_ocrd_dt := hr_api.g_eot;
3620: --
3621: if benutils.g_benefit_action_id is not null then
3622: --
3623: benutils.get_batch_parameters

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

3870: -- Bug 2541072 : Do not consider all per in ler's.
3871: --
3872: and epe.per_in_ler_id = pil.per_in_ler_id
3873: and pil.per_in_ler_stat_cd = 'STRTD'
3874: and ((cv_pl_id = -1 and cv_lf_evt_ocrd_dt = hr_api.g_eot)
3875: or
3876: (pil.lf_evt_ocrd_dt = cv_lf_evt_ocrd_dt and epe.pl_id = cv_pl_id)
3877: )
3878: and cwb.lvl_num = -1;

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

4000: ben_per_in_ler pil
4001: where epe.elig_per_elctbl_chc_id = cwh.emp_elig_per_elctbl_chc_id
4002: and epe.per_in_ler_id = pil.per_in_ler_id
4003: and pil.per_in_ler_stat_cd = 'STRTD'
4004: and ((cv_pl_id = -1 and cv_lf_evt_ocrd_dt = hr_api.g_eot)
4005: or
4006: (pil.lf_evt_ocrd_dt = cv_lf_evt_ocrd_dt and epe.pl_id = cv_pl_id)
4007: )
4008: ) ;

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

4021: ben_per_in_ler pil
4022: where epe.elig_per_elctbl_chc_id = cwh.emp_elig_per_elctbl_chc_id
4023: and epe.per_in_ler_id = pil.per_in_ler_id
4024: and pil.per_in_ler_stat_cd = 'STRTD'
4025: and ((cv_pl_id = -1 and cv_lf_evt_ocrd_dt = hr_api.g_eot)
4026: or
4027: (pil.lf_evt_ocrd_dt = cv_lf_evt_ocrd_dt and epe.pl_id = cv_pl_id)
4028: )
4029: ) ;

Line 4043: lv_lf_evt_ocrd_dt := hr_api.g_eot;

4039: hr_utility.set_location('Entering: '||l_proc,10);
4040: end if;
4041: --
4042: lv_pl_id := -1;
4043: lv_lf_evt_ocrd_dt := hr_api.g_eot;
4044: --
4045: if benutils.g_benefit_action_id is not null then
4046: --
4047: benutils.get_batch_parameters

Line 4303: AND pen.effective_end_date = hr_api.g_eot

4299: WHERE pen.person_id = cv_person_id
4300: AND pen.business_group_id = cv_business_group_id
4301: AND pen.sspndd_flag = 'N'
4302: AND pen.prtt_enrt_rslt_stat_cd IS NULL
4303: AND pen.effective_end_date = hr_api.g_eot
4304: AND cv_lf_evt_ocrd_dt <= pen.enrt_cvg_thru_dt
4305: AND pen.enrt_cvg_strt_dt < pen.effective_end_date
4306: AND cv_pl_id = pen.pl_id
4307: AND (

Line 4818: AND pen.effective_end_date = hr_api.g_eot

4814: WHERE pen.person_id = cv_person_id
4815: AND pen.business_group_id = cv_business_group_id
4816: AND pen.sspndd_flag = 'N'
4817: AND pen.prtt_enrt_rslt_stat_cd IS NULL
4818: AND pen.effective_end_date = hr_api.g_eot
4819: AND cv_lf_evt_ocrd_dt <= pen.enrt_cvg_thru_dt
4820: AND pen.enrt_cvg_strt_dt < pen.effective_end_date
4821: AND cv_pl_id = pen.pl_id
4822: AND (

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

9012: ben_person_object.get_object
9013: (p_soft_coding_keyflex_id => l_ass_rec.soft_coding_keyflex_id,
9014: p_rec => l_hsc_rec);
9015: --
9016: if l_hsc_rec.segment1 is not null and hr_api.return_legislation_code(p_business_group_id) = 'US'
9017: then
9018: --
9019: ben_org_object.get_object(p_organization_id => l_hsc_rec.segment1,
9020: p_rec => l_org2_rec);

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

9067: substr(l_org_rec.name,1,45)||
9068: benutils.id(l_ass_rec.organization_id);
9069: benutils.write(p_text => l_output_string);
9070: --
9071: if hr_api.return_legislation_code(p_business_group_id) = 'US'
9072: then
9073: l_output_string := 'Gre: '||
9074: substr(l_org2_rec.name,1,45);
9075: benutils.write(p_text => l_output_string);

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

9212: p_rec => l_hsc_rec
9213: );
9214:
9215: --
9216: IF l_hsc_rec.segment1 IS NOT NULL and hr_api.return_legislation_code(p_business_group_id) = 'US'
9217: THEN
9218: --
9219: ben_org_object.get_object (p_organization_id => l_hsc_rec.segment1,
9220: p_rec => l_org2_rec

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

9286: || SUBSTR (l_org_rec.NAME, 1, 45)
9287: || benutils.ID (l_ass_rec.organization_id);
9288: benutils.WRITE (p_text => l_output_string);
9289: --
9290: if hr_api.return_legislation_code(p_business_group_id) = 'US'
9291: then
9292: l_output_string := 'Gre: ' || SUBSTR (l_org2_rec.NAME, 1, 45);
9293: benutils.WRITE (p_text => l_output_string);
9294: else

Line 10136: and pen.effective_end_date = hr_api.g_eot

10132: ,ben_elig_dpnt egd
10133: ,ben_prtt_enrt_rslt_f pen
10134: where pdp.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
10135: and pen.person_id = p_person_id
10136: and pen.effective_end_date = hr_api.g_eot
10137: and pen.business_group_id = p_business_group_id
10138: and nvl(pdp.cvg_thru_dt,hr_api.g_eot) <> hr_api.g_eot
10139: and pdp.business_group_id = pen.business_group_id
10140: and pdp.elig_cvrd_dpnt_id = egd.elig_cvrd_dpnt_id

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

10134: where pdp.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
10135: and pen.person_id = p_person_id
10136: and pen.effective_end_date = hr_api.g_eot
10137: and pen.business_group_id = p_business_group_id
10138: and nvl(pdp.cvg_thru_dt,hr_api.g_eot) <> hr_api.g_eot
10139: and pdp.business_group_id = pen.business_group_id
10140: and pdp.elig_cvrd_dpnt_id = egd.elig_cvrd_dpnt_id
10141: and egd.dpnt_inelig_flag = 'Y'
10142: and egd.per_in_ler_id = p_per_in_ler_id

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

10198: from ben_prtt_enrt_rslt_f pen
10199: where pen.person_id = p_person_id
10200: and pen.prtt_enrt_rslt_stat_cd is null
10201: and pen.sspndd_flag = 'N'
10202: and pen.enrt_cvg_thru_dt <> hr_api.g_eot
10203: and pen.effective_end_date = hr_api.g_eot
10204: and p_effective_date between pen.effective_start_date
10205: and pen.effective_end_date
10206: and pen.business_group_id = p_business_group_id

Line 10203: and pen.effective_end_date = hr_api.g_eot

10199: where pen.person_id = p_person_id
10200: and pen.prtt_enrt_rslt_stat_cd is null
10201: and pen.sspndd_flag = 'N'
10202: and pen.enrt_cvg_thru_dt <> hr_api.g_eot
10203: and pen.effective_end_date = hr_api.g_eot
10204: and p_effective_date between pen.effective_start_date
10205: and pen.effective_end_date
10206: and pen.business_group_id = p_business_group_id
10207: and pen.comp_lvl_cd not in ('PLANFC', 'PLANIMP')

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

10214: and pen.prtt_enrt_rslt_stat_cd is null
10215: and pen.sspndd_flag = 'N'
10216: and pen.ptip_id = p_ptip_id
10217: and pen.comp_lvl_cd not in ('PLANFC', 'PLANIMP')
10218: and ( pen.enrt_cvg_thru_dt = hr_api.g_eot
10219: or ( pen.enrt_cvg_thru_dt >= p_effective_date
10220: and nvl(pen.enrt_ovridn_flag,'N') = 'Y'
10221: )
10222: )

Line 10223: and pen.effective_end_date = hr_api.g_eot

10219: or ( pen.enrt_cvg_thru_dt >= p_effective_date
10220: and nvl(pen.enrt_ovridn_flag,'N') = 'Y'
10221: )
10222: )
10223: and pen.effective_end_date = hr_api.g_eot
10224: and p_effective_date between pen.effective_start_date
10225: and pen.effective_end_date
10226: and pen.business_group_id = p_business_group_id
10227: ;

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

11431: --
11432: -- If previous cvg start date and current date is different then
11433: -- clear the caches.
11434: --
11435: if nvl(l_fonm_cvg_strt_dt, hr_api.g_sot) <>
11436: l_rec_enrt_cvg_strt_dt
11437: then
11438: --
11439: hr_utility.set_location('clearing cache bnmngle '||l_fonm_cvg_strt_dt || ' / ' || l_rec_enrt_cvg_strt_dt ,10);