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

Line 54: and nvl(p_elig_cvrd_dpnt_id,hr_api.g_number)

50: p_elig_cvrd_dpnt_id => p_elig_cvrd_dpnt_id,
51: p_object_version_number => p_object_version_number);
52: --
53: if (l_api_updating
54: and nvl(p_elig_cvrd_dpnt_id,hr_api.g_number)
55: <> ben_pdp_shd.g_old_rec.elig_cvrd_dpnt_id) then
56: --
57: -- raise error as PK has changed
58: --

Line 118: <> nvl(ben_pdp_shd.g_old_rec.ovrdn_flag,hr_api.g_varchar2)

114: p_object_version_number => p_object_version_number);
115: --
116: if (l_api_updating
117: and p_ovrdn_flag
118: <> nvl(ben_pdp_shd.g_old_rec.ovrdn_flag,hr_api.g_varchar2)
119: or not l_api_updating) then
120: --
121: -- check if value of lookup falls within lookup type.
122: --

Line 124: if hr_api.not_exists_in_hr_lookups

120: --
121: -- check if value of lookup falls within lookup type.
122: --
123: --
124: if hr_api.not_exists_in_hr_lookups
125: (p_lookup_type => 'YES_NO',
126: p_lookup_code => p_ovrdn_flag,
127: p_effective_date => p_effective_date) then
128: --

Line 182: <> nvl(ben_pdp_shd.g_old_rec.cvg_pndg_flag,hr_api.g_varchar2)

178: p_object_version_number => p_object_version_number);
179: --
180: if (l_api_updating
181: and p_cvg_pndg_flag
182: <> nvl(ben_pdp_shd.g_old_rec.cvg_pndg_flag,hr_api.g_varchar2)
183: or not l_api_updating) then
184: --
185: -- check if value of lookup falls within lookup type.
186: --

Line 188: if hr_api.not_exists_in_hr_lookups

184: --
185: -- check if value of lookup falls within lookup type.
186: --
187: --
188: if hr_api.not_exists_in_hr_lookups
189: (p_lookup_type => 'YES_NO',
190: p_lookup_code => p_cvg_pndg_flag,
191: p_effective_date => p_effective_date) then
192: --

Line 306: and ecd.elig_cvrd_dpnt_id <> nvl(p_elig_cvrd_dpnt_id, hr_api.g_number)

302: from ben_elig_cvrd_dpnt_f ecd
303: ,ben_per_in_ler pil
304: where ecd.dpnt_person_id = p_dpnt_person_id
305: and ecd.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
306: and ecd.elig_cvrd_dpnt_id <> nvl(p_elig_cvrd_dpnt_id, hr_api.g_number)
307: and ecd.business_group_id = p_business_group_id
308: and p_cvg_strt_dt between ecd.cvg_strt_dt and ecd.cvg_thru_dt
309: and ecd.cvg_thru_dt <= ecd.effective_end_date
310: and ecd.per_in_ler_id = pil.per_in_ler_id(+)

Line 335: and nvl(p_dpnt_person_id,hr_api.g_number)

331: p_effective_date => p_effective_date,
332: p_object_version_number => p_object_version_number);
333: --
334: if (l_api_updating
335: and nvl(p_dpnt_person_id,hr_api.g_number)
336: <> nvl(ben_pdp_shd.g_old_rec.dpnt_person_id, hr_api.g_number)
337: or not l_api_updating) then
338: --
339: -- check if dpnt_person_id value exists in per_all_people_f table

Line 336: <> nvl(ben_pdp_shd.g_old_rec.dpnt_person_id, hr_api.g_number)

332: p_object_version_number => p_object_version_number);
333: --
334: if (l_api_updating
335: and nvl(p_dpnt_person_id,hr_api.g_number)
336: <> nvl(ben_pdp_shd.g_old_rec.dpnt_person_id, hr_api.g_number)
337: or not l_api_updating) then
338: --
339: -- check if dpnt_person_id value exists in per_all_people_f table
340: --

Line 440: and nvl(p_prtt_enrt_rslt_id, hr_api.g_number)

436: p_object_version_number => p_object_version_number);
437: --
438: if p_prtt_enrt_rslt_id is not null
439: and (l_api_updating
440: and nvl(p_prtt_enrt_rslt_id, hr_api.g_number)
441: <> nvl(ben_pdp_shd.g_old_rec.prtt_enrt_rslt_id, hr_api.g_number)
442: or not l_api_updating) then
443: --
444: -- check if prtt_enrt_rslt_id value exists in ben_prtt_enrt_rslt_f table

Line 441: <> nvl(ben_pdp_shd.g_old_rec.prtt_enrt_rslt_id, hr_api.g_number)

437: --
438: if p_prtt_enrt_rslt_id is not null
439: and (l_api_updating
440: and nvl(p_prtt_enrt_rslt_id, hr_api.g_number)
441: <> nvl(ben_pdp_shd.g_old_rec.prtt_enrt_rslt_id, hr_api.g_number)
442: or not l_api_updating) then
443: --
444: -- check if prtt_enrt_rslt_id value exists in ben_prtt_enrt_rslt_f table
445: --

Line 563: ((nvl(pl_id, hr_api.g_number) = l_pl_id)

559: ,no_mx_num_dfnd_flag
560: ,decode(oipl_id, null, decode(opt_id, null, 3, 2), 1) heir
561: from ben_dsgn_rqmt_f
562: where
563: ((nvl(pl_id, hr_api.g_number) = l_pl_id)
564: or (nvl(oipl_id, hr_api.g_number) = l_oipl_id)
565: or (nvl(opt_id, hr_api.g_number) = l_opt_id))
566: and dsgn_typ_cd = 'DPNT'
567: and grp_rlshp_cd is null

Line 564: or (nvl(oipl_id, hr_api.g_number) = l_oipl_id)

560: ,decode(oipl_id, null, decode(opt_id, null, 3, 2), 1) heir
561: from ben_dsgn_rqmt_f
562: where
563: ((nvl(pl_id, hr_api.g_number) = l_pl_id)
564: or (nvl(oipl_id, hr_api.g_number) = l_oipl_id)
565: or (nvl(opt_id, hr_api.g_number) = l_opt_id))
566: and dsgn_typ_cd = 'DPNT'
567: and grp_rlshp_cd is null
568: and business_group_id + 0 = p_business_group_id

Line 565: or (nvl(opt_id, hr_api.g_number) = l_opt_id))

561: from ben_dsgn_rqmt_f
562: where
563: ((nvl(pl_id, hr_api.g_number) = l_pl_id)
564: or (nvl(oipl_id, hr_api.g_number) = l_oipl_id)
565: or (nvl(opt_id, hr_api.g_number) = l_opt_id))
566: and dsgn_typ_cd = 'DPNT'
567: and grp_rlshp_cd is null
568: and business_group_id + 0 = p_business_group_id
569: and p_effective_date between effective_start_date

Line 580: where ((nvl(pl_id, hr_api.g_number) = l_pl_id)

576: --
577: cursor any_rqmt_c is
578: select 's'
579: from ben_dsgn_rqmt_f r
580: where ((nvl(pl_id, hr_api.g_number) = l_pl_id)
581: or (nvl(oipl_id, hr_api.g_number) = l_oipl_id)
582: or (nvl(opt_id, hr_api.g_number) = l_opt_id))
583: and r.dsgn_typ_cd = 'DPNT'
584: and r.business_group_id + 0 = p_business_group_id

Line 581: or (nvl(oipl_id, hr_api.g_number) = l_oipl_id)

577: cursor any_rqmt_c is
578: select 's'
579: from ben_dsgn_rqmt_f r
580: where ((nvl(pl_id, hr_api.g_number) = l_pl_id)
581: or (nvl(oipl_id, hr_api.g_number) = l_oipl_id)
582: or (nvl(opt_id, hr_api.g_number) = l_opt_id))
583: and r.dsgn_typ_cd = 'DPNT'
584: and r.business_group_id + 0 = p_business_group_id
585: and p_effective_date between nvl(r.effective_start_date, p_effective_date)

Line 582: or (nvl(opt_id, hr_api.g_number) = l_opt_id))

578: select 's'
579: from ben_dsgn_rqmt_f r
580: where ((nvl(pl_id, hr_api.g_number) = l_pl_id)
581: or (nvl(oipl_id, hr_api.g_number) = l_oipl_id)
582: or (nvl(opt_id, hr_api.g_number) = l_opt_id))
583: and r.dsgn_typ_cd = 'DPNT'
584: and r.business_group_id + 0 = p_business_group_id
585: and p_effective_date between nvl(r.effective_start_date, p_effective_date)
586: and nvl(r.effective_end_date, p_effective_date)

Line 599: where ((nvl(pl_id, hr_api.g_number) = l_pl_id)

595: ,r.dsgn_rqmt_id
596: ,decode(oipl_id, null, decode(opt_id, null, 3, 2), 1) heir
597: from ben_dsgn_rqmt_f r,
598: ben_dsgn_rqmt_rlshp_typ dr
599: where ((nvl(pl_id, hr_api.g_number) = l_pl_id)
600: or (nvl(oipl_id, hr_api.g_number) = l_oipl_id)
601: or (nvl(opt_id, hr_api.g_number) = l_opt_id))
602: and r.dsgn_typ_cd = 'DPNT'
603: and r.business_group_id + 0 = p_business_group_id

Line 600: or (nvl(oipl_id, hr_api.g_number) = l_oipl_id)

596: ,decode(oipl_id, null, decode(opt_id, null, 3, 2), 1) heir
597: from ben_dsgn_rqmt_f r,
598: ben_dsgn_rqmt_rlshp_typ dr
599: where ((nvl(pl_id, hr_api.g_number) = l_pl_id)
600: or (nvl(oipl_id, hr_api.g_number) = l_oipl_id)
601: or (nvl(opt_id, hr_api.g_number) = l_opt_id))
602: and r.dsgn_typ_cd = 'DPNT'
603: and r.business_group_id + 0 = p_business_group_id
604: and p_effective_date between nvl(r.effective_start_date, p_effective_date)

Line 601: or (nvl(opt_id, hr_api.g_number) = l_opt_id))

597: from ben_dsgn_rqmt_f r,
598: ben_dsgn_rqmt_rlshp_typ dr
599: where ((nvl(pl_id, hr_api.g_number) = l_pl_id)
600: or (nvl(oipl_id, hr_api.g_number) = l_oipl_id)
601: or (nvl(opt_id, hr_api.g_number) = l_opt_id))
602: and r.dsgn_typ_cd = 'DPNT'
603: and r.business_group_id + 0 = p_business_group_id
604: and p_effective_date between nvl(r.effective_start_date, p_effective_date)
605: and nvl(r.effective_end_date, p_effective_date)

Line 618: and cvg_thru_dt = hr_api.g_eot

614: select count(elig_cvrd_dpnt_id)
615: from ben_elig_cvrd_dpnt_f
616: where prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
617: and cvg_strt_dt is not null
618: and cvg_thru_dt = hr_api.g_eot
619: -- and cvrd_flag = 'Y'
620: and business_group_id + 0 = p_business_group_id
621: and p_effective_date between effective_start_date
622: and effective_end_date

Line 623: and p_cvg_strt_dt <= nvl(cvg_thru_dt, hr_api.g_date)

619: -- and cvrd_flag = 'Y'
620: and business_group_id + 0 = p_business_group_id
621: and p_effective_date between effective_start_date
622: and effective_end_date
623: and p_cvg_strt_dt <= nvl(cvg_thru_dt, hr_api.g_date)
624: and nvl(p_cvg_thru_dt, hr_api.g_date) >= cvg_strt_dt
625: ;
626: --
627: --

Line 624: and nvl(p_cvg_thru_dt, hr_api.g_date) >= cvg_strt_dt

620: and business_group_id + 0 = p_business_group_id
621: and p_effective_date between effective_start_date
622: and effective_end_date
623: and p_cvg_strt_dt <= nvl(cvg_thru_dt, hr_api.g_date)
624: and nvl(p_cvg_thru_dt, hr_api.g_date) >= cvg_strt_dt
625: ;
626: --
627: --
628: -- number of covered dependents of any of the rel types covered

Line 640: and d.cvg_thru_dt = hr_api.g_eot

636: c.person_id = l_person_id
637: and c.contact_person_id = d.dpnt_person_id
638: and d.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
639: and d.cvg_strt_dt is not null
640: and d.cvg_thru_dt = hr_api.g_eot
641: and p_cvg_strt_dt <= nvl(d.cvg_thru_dt, hr_api.g_date)
642: and nvl(p_cvg_thru_dt, hr_api.g_date) >= d.cvg_strt_dt
643: and c.business_group_id + 0 = p_business_group_id
644: and p_effective_date between nvl(c.date_start, p_effective_date)

Line 641: and p_cvg_strt_dt <= nvl(d.cvg_thru_dt, hr_api.g_date)

637: and c.contact_person_id = d.dpnt_person_id
638: and d.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
639: and d.cvg_strt_dt is not null
640: and d.cvg_thru_dt = hr_api.g_eot
641: and p_cvg_strt_dt <= nvl(d.cvg_thru_dt, hr_api.g_date)
642: and nvl(p_cvg_thru_dt, hr_api.g_date) >= d.cvg_strt_dt
643: and c.business_group_id + 0 = p_business_group_id
644: and p_effective_date between nvl(c.date_start, p_effective_date)
645: and nvl(c.date_end, p_effective_date)

Line 642: and nvl(p_cvg_thru_dt, hr_api.g_date) >= d.cvg_strt_dt

638: and d.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
639: and d.cvg_strt_dt is not null
640: and d.cvg_thru_dt = hr_api.g_eot
641: and p_cvg_strt_dt <= nvl(d.cvg_thru_dt, hr_api.g_date)
642: and nvl(p_cvg_thru_dt, hr_api.g_date) >= d.cvg_strt_dt
643: and c.business_group_id + 0 = p_business_group_id
644: and p_effective_date between nvl(c.date_start, p_effective_date)
645: and nvl(c.date_end, p_effective_date)
646: and d.effective_end_date = hr_api.g_eot -- bug 1237204

Line 646: and d.effective_end_date = hr_api.g_eot -- bug 1237204

642: and nvl(p_cvg_thru_dt, hr_api.g_date) >= d.cvg_strt_dt
643: and c.business_group_id + 0 = p_business_group_id
644: and p_effective_date between nvl(c.date_start, p_effective_date)
645: and nvl(c.date_end, p_effective_date)
646: and d.effective_end_date = hr_api.g_eot -- bug 1237204
647: and d.business_group_id + 0 = p_business_group_id
648: and c.contact_type in
649: (select rlshp_typ_cd
650: from ben_dsgn_rqmt_rlshp_typ

Line 670: p_cvg_thru_dt = hr_api.g_eot and

666: -- existing not-covered dependent to 'covered'.
667:
668: if p_prtt_enrt_rslt_id is not null and
669: p_cvg_strt_dt is not null and
670: p_cvg_thru_dt = hr_api.g_eot and
671: (not l_api_updating or
672: ben_pdp_shd.g_old_rec.cvg_strt_dt = null)
673: then
674: --

Line 773: if p_cvg_thru_dt <> hr_api.g_eot then

769: --
770: hr_utility.set_location('Entering:'||l_proc, 5);
771: --
772: --
773: if p_cvg_thru_dt <> hr_api.g_eot then
774: --
775: -- check if there is an active court order.
776: --
777: open c1;

Line 1401: (p_prtt_enrt_rslt_id in number default hr_api.g_number,

1397: --
1398: -- {End Of Comments}
1399: -- ----------------------------------------------------------------------------
1400: Procedure dt_update_validate
1401: (p_prtt_enrt_rslt_id in number default hr_api.g_number,
1402: p_datetrack_mode in varchar2,
1403: p_validation_start_date in date,
1404: p_validation_end_date in date) Is
1405: --

Line 1415: hr_api.mandatory_arg_error

1411: hr_utility.set_location('Entering:'||l_proc, 5);
1412: --
1413: -- Ensure that the p_datetrack_mode argument is not null
1414: --
1415: hr_api.mandatory_arg_error
1416: (p_api_name => l_proc,
1417: p_argument => 'datetrack_mode',
1418: p_argument_value => p_datetrack_mode);
1419: --

Line 1427: hr_api.mandatory_arg_error

1423: --
1424: --
1425: -- Ensure the arguments are not null
1426: --
1427: hr_api.mandatory_arg_error
1428: (p_api_name => l_proc,
1429: p_argument => 'validation_start_date',
1430: p_argument_value => p_validation_start_date);
1431: --

Line 1432: hr_api.mandatory_arg_error

1428: (p_api_name => l_proc,
1429: p_argument => 'validation_start_date',
1430: p_argument_value => p_validation_start_date);
1431: --
1432: hr_api.mandatory_arg_error
1433: (p_api_name => l_proc,
1434: p_argument => 'validation_end_date',
1435: p_argument_value => p_validation_end_date);
1436: --

Line 1438: If ((nvl(p_prtt_enrt_rslt_id, hr_api.g_number) <> hr_api.g_number) and

1434: p_argument => 'validation_end_date',
1435: p_argument_value => p_validation_end_date);
1436: --
1437: /*
1438: If ((nvl(p_prtt_enrt_rslt_id, hr_api.g_number) <> hr_api.g_number) and
1439: NOT (dt_api.check_min_max_dates
1440: (p_base_table_name => 'ben_prtt_enrt_rslt_f',
1441: p_base_key_column => 'prtt_enrt_rslt_id',
1442: p_base_key_value => p_prtt_enrt_rslt_id,

Line 1524: hr_api.mandatory_arg_error

1520: hr_utility.set_location('Entering:'||l_proc, 5);
1521: --
1522: -- Ensure that the p_datetrack_mode argument is not null
1523: --
1524: hr_api.mandatory_arg_error
1525: (p_api_name => l_proc,
1526: p_argument => 'datetrack_mode',
1527: p_argument_value => p_datetrack_mode);
1528: --

Line 1538: hr_api.mandatory_arg_error

1534: --
1535: --
1536: -- Ensure the arguments are not null
1537: --
1538: hr_api.mandatory_arg_error
1539: (p_api_name => l_proc,
1540: p_argument => 'validation_start_date',
1541: p_argument_value => p_validation_start_date);
1542: --

Line 1543: hr_api.mandatory_arg_error

1539: (p_api_name => l_proc,
1540: p_argument => 'validation_start_date',
1541: p_argument_value => p_validation_start_date);
1542: --
1543: hr_api.mandatory_arg_error
1544: (p_api_name => l_proc,
1545: p_argument => 'validation_end_date',
1546: p_argument_value => p_validation_end_date);
1547: --

Line 1548: hr_api.mandatory_arg_error

1544: (p_api_name => l_proc,
1545: p_argument => 'validation_end_date',
1546: p_argument_value => p_validation_end_date);
1547: --
1548: hr_api.mandatory_arg_error
1549: (p_api_name => l_proc,
1550: p_argument => 'elig_cvrd_dpnt_id',
1551: p_argument_value => p_elig_cvrd_dpnt_id);
1552: --

Line 1603: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

1599: hr_utility.set_location('Entering:'||l_proc, 5);
1600: --
1601: -- Call all supporting business operations
1602: --
1603: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1604: --
1605: chk_elig_cvrd_dpnt_id
1606: (p_elig_cvrd_dpnt_id => p_rec.elig_cvrd_dpnt_id,
1607: p_effective_date => p_effective_date,

Line 1693: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

1689: hr_utility.set_location('Entering:'||l_proc, 5);
1690: --
1691: -- Call all supporting business operations
1692: --
1693: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1694: --
1695: chk_elig_cvrd_dpnt_id
1696: (p_elig_cvrd_dpnt_id => p_rec.elig_cvrd_dpnt_id,
1697: p_effective_date => p_effective_date,

Line 1842: hr_api.mandatory_arg_error(p_api_name => l_proc,

1838: hr_utility.set_location('Entering:'|| l_proc, 10);
1839: --
1840: -- Ensure that all the mandatory parameter are not null
1841: --
1842: hr_api.mandatory_arg_error(p_api_name => l_proc,
1843: p_argument => 'elig_cvrd_dpnt_id',
1844: p_argument_value => p_elig_cvrd_dpnt_id);
1845: --
1846: open csr_leg_code;