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

Line 60: and nvl(p_pil_elctbl_chc_popl_id,hr_api.g_number)

56: (p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
57: p_object_version_number => p_object_version_number);
58: --
59: if (l_api_updating
60: and nvl(p_pil_elctbl_chc_popl_id,hr_api.g_number)
61: <> nvl(ben_epe_shd.g_old_rec.pil_elctbl_chc_popl_id,hr_api.g_number)
62: or not l_api_updating) and
63: p_pil_elctbl_chc_popl_id is not null then
64: --

Line 61: <> nvl(ben_epe_shd.g_old_rec.pil_elctbl_chc_popl_id,hr_api.g_number)

57: p_object_version_number => p_object_version_number);
58: --
59: if (l_api_updating
60: and nvl(p_pil_elctbl_chc_popl_id,hr_api.g_number)
61: <> nvl(ben_epe_shd.g_old_rec.pil_elctbl_chc_popl_id,hr_api.g_number)
62: or not l_api_updating) and
63: p_pil_elctbl_chc_popl_id is not null then
64: --
65: -- check if pil_elctbl_chc_popl_id value exists in ben_pil_elctbl_chc_popl table

Line 139: and nvl(p_pl_typ_id,hr_api.g_number)

135: (p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
136: p_object_version_number => p_object_version_number);
137: --
138: if (l_api_updating
139: and nvl(p_pl_typ_id,hr_api.g_number)
140: <> nvl(ben_epe_shd.g_old_rec.pl_typ_id,hr_api.g_number)
141: or not l_api_updating) and
142: p_pl_typ_id is not null then
143: --

Line 140: <> nvl(ben_epe_shd.g_old_rec.pl_typ_id,hr_api.g_number)

136: p_object_version_number => p_object_version_number);
137: --
138: if (l_api_updating
139: and nvl(p_pl_typ_id,hr_api.g_number)
140: <> nvl(ben_epe_shd.g_old_rec.pl_typ_id,hr_api.g_number)
141: or not l_api_updating) and
142: p_pl_typ_id is not null then
143: --
144: -- check if pl_typ_id value exists in ben_pl_typ table

Line 217: and nvl(p_spcl_rt_oipl_id,hr_api.g_number)

213: (p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
214: p_object_version_number => p_object_version_number);
215: --
216: if (l_api_updating
217: and nvl(p_spcl_rt_oipl_id,hr_api.g_number)
218: <> nvl(ben_epe_shd.g_old_rec.spcl_rt_oipl_id,hr_api.g_number)
219: or not l_api_updating) and
220: p_spcl_rt_oipl_id is not null then
221: --

Line 218: <> nvl(ben_epe_shd.g_old_rec.spcl_rt_oipl_id,hr_api.g_number)

214: p_object_version_number => p_object_version_number);
215: --
216: if (l_api_updating
217: and nvl(p_spcl_rt_oipl_id,hr_api.g_number)
218: <> nvl(ben_epe_shd.g_old_rec.spcl_rt_oipl_id,hr_api.g_number)
219: or not l_api_updating) and
220: p_spcl_rt_oipl_id is not null then
221: --
222: -- check if spcl_rt_oipl_id value exists in ben_spcl_rt_oipl table

Line 295: and nvl(p_spcl_rt_pl_id,hr_api.g_number)

291: (p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
292: p_object_version_number => p_object_version_number);
293: --
294: if (l_api_updating
295: and nvl(p_spcl_rt_pl_id,hr_api.g_number)
296: <> nvl(ben_epe_shd.g_old_rec.spcl_rt_pl_id,hr_api.g_number)
297: or not l_api_updating) and
298: p_spcl_rt_pl_id is not null then
299: --

Line 296: <> nvl(ben_epe_shd.g_old_rec.spcl_rt_pl_id,hr_api.g_number)

292: p_object_version_number => p_object_version_number);
293: --
294: if (l_api_updating
295: and nvl(p_spcl_rt_pl_id,hr_api.g_number)
296: <> nvl(ben_epe_shd.g_old_rec.spcl_rt_pl_id,hr_api.g_number)
297: or not l_api_updating) and
298: p_spcl_rt_pl_id is not null then
299: --
300: -- check if spcl_rt_pl_id value exists in ben_spcl_rt_pl table

Line 373: and nvl(p_plip_id,hr_api.g_number)

369: (p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
370: p_object_version_number => p_object_version_number);
371: --
372: if (l_api_updating
373: and nvl(p_plip_id,hr_api.g_number)
374: <> nvl(ben_epe_shd.g_old_rec.plip_id,hr_api.g_number)
375: or not l_api_updating) and
376: p_plip_id is not null then
377: --

Line 374: <> nvl(ben_epe_shd.g_old_rec.plip_id,hr_api.g_number)

370: p_object_version_number => p_object_version_number);
371: --
372: if (l_api_updating
373: and nvl(p_plip_id,hr_api.g_number)
374: <> nvl(ben_epe_shd.g_old_rec.plip_id,hr_api.g_number)
375: or not l_api_updating) and
376: p_plip_id is not null then
377: --
378: -- check if plip_id value exists in ben_plip table

Line 451: and nvl(p_cmbn_ptip_id,hr_api.g_number)

447: (p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
448: p_object_version_number => p_object_version_number);
449: --
450: if (l_api_updating
451: and nvl(p_cmbn_ptip_id,hr_api.g_number)
452: <> nvl(ben_epe_shd.g_old_rec.cmbn_ptip_id,hr_api.g_number)
453: or not l_api_updating) and
454: p_cmbn_ptip_id is not null then
455: --

Line 452: <> nvl(ben_epe_shd.g_old_rec.cmbn_ptip_id,hr_api.g_number)

448: p_object_version_number => p_object_version_number);
449: --
450: if (l_api_updating
451: and nvl(p_cmbn_ptip_id,hr_api.g_number)
452: <> nvl(ben_epe_shd.g_old_rec.cmbn_ptip_id,hr_api.g_number)
453: or not l_api_updating) and
454: p_cmbn_ptip_id is not null then
455: --
456: -- check if cmbn_ptip_id value exists in ben_cmbn_ptip table

Line 529: and nvl(p_cmbn_plip_id,hr_api.g_number)

525: (p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
526: p_object_version_number => p_object_version_number);
527: --
528: if (l_api_updating
529: and nvl(p_cmbn_plip_id,hr_api.g_number)
530: <> nvl(ben_epe_shd.g_old_rec.cmbn_plip_id,hr_api.g_number)
531: or not l_api_updating) and
532: p_cmbn_plip_id is not null then
533: --

Line 530: <> nvl(ben_epe_shd.g_old_rec.cmbn_plip_id,hr_api.g_number)

526: p_object_version_number => p_object_version_number);
527: --
528: if (l_api_updating
529: and nvl(p_cmbn_plip_id,hr_api.g_number)
530: <> nvl(ben_epe_shd.g_old_rec.cmbn_plip_id,hr_api.g_number)
531: or not l_api_updating) and
532: p_cmbn_plip_id is not null then
533: --
534: -- check if cmbn_plip_id value exists in ben_cmbn_plip table

Line 607: and nvl(p_ptip_id,hr_api.g_number)

603: (p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
604: p_object_version_number => p_object_version_number);
605: --
606: if (l_api_updating
607: and nvl(p_ptip_id,hr_api.g_number)
608: <> nvl(ben_epe_shd.g_old_rec.ptip_id,hr_api.g_number)
609: or not l_api_updating) and
610: p_ptip_id is not null then
611: --

Line 608: <> nvl(ben_epe_shd.g_old_rec.ptip_id,hr_api.g_number)

604: p_object_version_number => p_object_version_number);
605: --
606: if (l_api_updating
607: and nvl(p_ptip_id,hr_api.g_number)
608: <> nvl(ben_epe_shd.g_old_rec.ptip_id,hr_api.g_number)
609: or not l_api_updating) and
610: p_ptip_id is not null then
611: --
612: -- check if ptip_id value exists in ben_ptip table

Line 685: and nvl(p_cmbn_ptip_opt_id,hr_api.g_number)

681: (p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
682: p_object_version_number => p_object_version_number);
683: --
684: if (l_api_updating
685: and nvl(p_cmbn_ptip_opt_id,hr_api.g_number)
686: <> nvl(ben_epe_shd.g_old_rec.cmbn_ptip_opt_id,hr_api.g_number)
687: or not l_api_updating) and
688: p_cmbn_ptip_opt_id is not null then
689: --

Line 686: <> nvl(ben_epe_shd.g_old_rec.cmbn_ptip_opt_id,hr_api.g_number)

682: p_object_version_number => p_object_version_number);
683: --
684: if (l_api_updating
685: and nvl(p_cmbn_ptip_opt_id,hr_api.g_number)
686: <> nvl(ben_epe_shd.g_old_rec.cmbn_ptip_opt_id,hr_api.g_number)
687: or not l_api_updating) and
688: p_cmbn_ptip_opt_id is not null then
689: --
690: -- check if cmbn_ptip_opt_id value exists in ben_cmbn_ptip_opt table

Line 763: and nvl(p_pgm_id,hr_api.g_number)

759: (p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
760: p_object_version_number => p_object_version_number);
761: --
762: if (l_api_updating
763: and nvl(p_pgm_id,hr_api.g_number)
764: <> nvl(ben_epe_shd.g_old_rec.pgm_id,hr_api.g_number)
765: or not l_api_updating) and
766: p_pgm_id is not null then
767: --

Line 764: <> nvl(ben_epe_shd.g_old_rec.pgm_id,hr_api.g_number)

760: p_object_version_number => p_object_version_number);
761: --
762: if (l_api_updating
763: and nvl(p_pgm_id,hr_api.g_number)
764: <> nvl(ben_epe_shd.g_old_rec.pgm_id,hr_api.g_number)
765: or not l_api_updating) and
766: p_pgm_id is not null then
767: --
768: -- check if pgm_id value exists in ben_pgm table

Line 841: and nvl(p_oipl_id,hr_api.g_number)

837: (p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
838: p_object_version_number => p_object_version_number);
839: --
840: if (l_api_updating
841: and nvl(p_oipl_id,hr_api.g_number)
842: <> nvl(ben_epe_shd.g_old_rec.oipl_id,hr_api.g_number)
843: or not l_api_updating) and
844: p_oipl_id is not null then
845: --

Line 842: <> nvl(ben_epe_shd.g_old_rec.oipl_id,hr_api.g_number)

838: p_object_version_number => p_object_version_number);
839: --
840: if (l_api_updating
841: and nvl(p_oipl_id,hr_api.g_number)
842: <> nvl(ben_epe_shd.g_old_rec.oipl_id,hr_api.g_number)
843: or not l_api_updating) and
844: p_oipl_id is not null then
845: --
846: -- check if oipl_id value exists in ben_oipl table

Line 919: and nvl(p_pl_id,hr_api.g_number)

915: (p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
916: p_object_version_number => p_object_version_number);
917: --
918: if (l_api_updating
919: and nvl(p_pl_id,hr_api.g_number)
920: <> nvl(ben_epe_shd.g_old_rec.pl_id,hr_api.g_number)
921: or not l_api_updating) and
922: p_pl_id is not null then
923: --

Line 920: <> nvl(ben_epe_shd.g_old_rec.pl_id,hr_api.g_number)

916: p_object_version_number => p_object_version_number);
917: --
918: if (l_api_updating
919: and nvl(p_pl_id,hr_api.g_number)
920: <> nvl(ben_epe_shd.g_old_rec.pl_id,hr_api.g_number)
921: or not l_api_updating) and
922: p_pl_id is not null then
923: --
924: -- check if pl_id value exists in ben_pl table

Line 997: and nvl(p_bnft_prvdr_pool_id,hr_api.g_number)

993: (p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
994: p_object_version_number => p_object_version_number);
995: --
996: if (l_api_updating
997: and nvl(p_bnft_prvdr_pool_id,hr_api.g_number)
998: <> nvl(ben_epe_shd.g_old_rec.bnft_prvdr_pool_id,hr_api.g_number)
999: or not l_api_updating) and
1000: p_bnft_prvdr_pool_id is not null then
1001: --

Line 998: <> nvl(ben_epe_shd.g_old_rec.bnft_prvdr_pool_id,hr_api.g_number)

994: p_object_version_number => p_object_version_number);
995: --
996: if (l_api_updating
997: and nvl(p_bnft_prvdr_pool_id,hr_api.g_number)
998: <> nvl(ben_epe_shd.g_old_rec.bnft_prvdr_pool_id,hr_api.g_number)
999: or not l_api_updating) and
1000: p_bnft_prvdr_pool_id is not null then
1001: --
1002: -- check if bnft_prvdr_pool_id value exists in ben_bnft_prvdr_pool table

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

1072: (p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
1073: p_object_version_number => p_object_version_number);
1074: --
1075: if (l_api_updating
1076: and nvl(p_prtt_enrt_rslt_id,hr_api.g_number)
1077: <> nvl(ben_epe_shd.g_old_rec.prtt_enrt_rslt_id,hr_api.g_number)
1078: or not l_api_updating) and
1079: p_prtt_enrt_rslt_id is not null then
1080: --

Line 1077: <> nvl(ben_epe_shd.g_old_rec.prtt_enrt_rslt_id,hr_api.g_number)

1073: p_object_version_number => p_object_version_number);
1074: --
1075: if (l_api_updating
1076: and nvl(p_prtt_enrt_rslt_id,hr_api.g_number)
1077: <> nvl(ben_epe_shd.g_old_rec.prtt_enrt_rslt_id,hr_api.g_number)
1078: or not l_api_updating) and
1079: p_prtt_enrt_rslt_id is not null then
1080: --
1081: -- check if prtt_enrt_rslt_id value exists in ben_prtt_enrt_rslt table.

Line 1157: and nvl(p_per_in_ler_id,hr_api.g_number)

1153: (p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
1154: p_object_version_number => p_object_version_number);
1155: --
1156: if (l_api_updating
1157: and nvl(p_per_in_ler_id,hr_api.g_number)
1158: <> nvl(ben_epe_shd.g_old_rec.per_in_ler_id,hr_api.g_number)
1159: or not l_api_updating) and
1160: p_per_in_ler_id is not null then
1161: --

Line 1158: <> nvl(ben_epe_shd.g_old_rec.per_in_ler_id,hr_api.g_number)

1154: p_object_version_number => p_object_version_number);
1155: --
1156: if (l_api_updating
1157: and nvl(p_per_in_ler_id,hr_api.g_number)
1158: <> nvl(ben_epe_shd.g_old_rec.per_in_ler_id,hr_api.g_number)
1159: or not l_api_updating) and
1160: p_per_in_ler_id is not null then
1161: --
1162: -- check if per_in_ler_id value exists in ben_per_in_ler table, and that

Line 1236: and nvl(p_must_enrl_anthr_pl_id,hr_api.g_number)

1232: (p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
1233: p_object_version_number => p_object_version_number);
1234: --
1235: if (l_api_updating
1236: and nvl(p_must_enrl_anthr_pl_id,hr_api.g_number)
1237: <> nvl(ben_epe_shd.g_old_rec.must_enrl_anthr_pl_id,hr_api.g_number)
1238: or not l_api_updating) and
1239: p_must_enrl_anthr_pl_id is not null then
1240: --

Line 1237: <> nvl(ben_epe_shd.g_old_rec.must_enrl_anthr_pl_id,hr_api.g_number)

1233: p_object_version_number => p_object_version_number);
1234: --
1235: if (l_api_updating
1236: and nvl(p_must_enrl_anthr_pl_id,hr_api.g_number)
1237: <> nvl(ben_epe_shd.g_old_rec.must_enrl_anthr_pl_id,hr_api.g_number)
1238: or not l_api_updating) and
1239: p_must_enrl_anthr_pl_id is not null then
1240: --
1241: -- check if must_enrl_anthr_pl_id value exists in ben_must_enrl_anthr_pl table

Line 1314: and nvl(p_int_elig_per_elctbl_chc_id,hr_api.g_number)

1310: (p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
1311: p_object_version_number => p_object_version_number);
1312: --
1313: if (l_api_updating
1314: and nvl(p_int_elig_per_elctbl_chc_id,hr_api.g_number)
1315: <> nvl(ben_epe_shd.g_old_rec.int_elig_per_elctbl_chc_id,hr_api.g_number)
1316: or not l_api_updating) and
1317: p_int_elig_per_elctbl_chc_id is not null then
1318: --

Line 1315: <> nvl(ben_epe_shd.g_old_rec.int_elig_per_elctbl_chc_id,hr_api.g_number)

1311: p_object_version_number => p_object_version_number);
1312: --
1313: if (l_api_updating
1314: and nvl(p_int_elig_per_elctbl_chc_id,hr_api.g_number)
1315: <> nvl(ben_epe_shd.g_old_rec.int_elig_per_elctbl_chc_id,hr_api.g_number)
1316: or not l_api_updating) and
1317: p_int_elig_per_elctbl_chc_id is not null then
1318: --
1319: -- check if int_elig_per_elctbl_chc_id value exists in table

Line 1392: and nvl(p_yr_perd_id,hr_api.g_number)

1388: (p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
1389: p_object_version_number => p_object_version_number);
1390: --
1391: if (l_api_updating
1392: and nvl(p_yr_perd_id,hr_api.g_number)
1393: <> nvl(ben_epe_shd.g_old_rec.yr_perd_id,hr_api.g_number)
1394: or not l_api_updating) and
1395: p_yr_perd_id is not null then
1396: --

Line 1393: <> nvl(ben_epe_shd.g_old_rec.yr_perd_id,hr_api.g_number)

1389: p_object_version_number => p_object_version_number);
1390: --
1391: if (l_api_updating
1392: and nvl(p_yr_perd_id,hr_api.g_number)
1393: <> nvl(ben_epe_shd.g_old_rec.yr_perd_id,hr_api.g_number)
1394: or not l_api_updating) and
1395: p_yr_perd_id is not null then
1396: --
1397: -- check if yr_perd_id value exists in ben_yr_perd table

Line 1470: <> nvl(p_old_cd,hr_api.g_varchar2)

1466: p_object_version_number => p_object_version_number);
1467:
1468: if (l_api_updating
1469: and p_cd
1470: <> nvl(p_old_cd,hr_api.g_varchar2)
1471: or not l_api_updating)
1472: and p_cd is not null then
1473: --
1474: -- check if value of lookup falls within lookup type.

Line 1479: if hr_api.not_exists_in_hr_lookups

1475: --
1476: /*
1477: hr_utility.set_location('HRAPI_NEIHL:'||l_proc, 5);
1478: */
1479: if hr_api.not_exists_in_hr_lookups
1480: (p_lookup_type => p_lookup_type,
1481: p_lookup_code => p_cd,
1482: p_effective_date => p_effective_date) then
1483: --

Line 1557: <> nvl(p_old_flag,hr_api.g_varchar2)

1553: hr_utility.set_location(l_proc||' pflag='||p_flag, 30);
1554: */
1555: if (l_api_updating
1556: and p_flag
1557: <> nvl(p_old_flag,hr_api.g_varchar2)
1558: or not l_api_updating) then
1559: --
1560: -- check if value of lookup falls within lookup type.
1561: --

Line 1566: if hr_api.not_exists_in_hr_lookups

1562: --
1563: /*
1564: hr_utility.set_location('HRAPI_NEIHL:'||l_proc, 5);
1565: */
1566: if hr_api.not_exists_in_hr_lookups
1567: (p_lookup_type => 'YES_NO',
1568: p_lookup_code => p_flag,
1569: p_effective_date => p_effective_date) then
1570: --

Line 1655: and nvl(p_enrt_cvg_strt_dt_rl,hr_api.g_number)

1651: (p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
1652: p_object_version_number => p_object_version_number);
1653: --
1654: if (l_api_updating
1655: and nvl(p_enrt_cvg_strt_dt_rl,hr_api.g_number)
1656: <> ben_epe_shd.g_old_rec.enrt_cvg_strt_dt_rl
1657: or not l_api_updating)
1658: and p_enrt_cvg_strt_dt_rl is not null then
1659: --

Line 1750: and nvl(p_dpnt_cvg_strt_dt_rl,hr_api.g_number)

1746: (p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
1747: p_object_version_number => p_object_version_number);
1748: --
1749: if (l_api_updating
1750: and nvl(p_dpnt_cvg_strt_dt_rl,hr_api.g_number)
1751: <> ben_epe_shd.g_old_rec.dpnt_cvg_strt_dt_rl
1752: or not l_api_updating)
1753: and p_dpnt_cvg_strt_dt_rl is not null then
1754: --

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

1826: hr_utility.set_location('Entering:'|| l_proc, 10);
1827: --
1828: -- Ensure that all the mandatory parameter are not null
1829: --
1830: hr_api.mandatory_arg_error(p_api_name => l_proc,
1831: p_argument => 'elig_per_elctbl_chc_id',
1832: p_argument_value => p_elig_per_elctbl_chc_id);
1833: --
1834: open csr_leg_code;

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

1874: /*
1875: --
1876: -- Call all supporting business operations
1877: --
1878: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1879: */
1880: chk_yr_perd_id
1881: (p_elig_per_elctbl_chc_id => p_rec.elig_per_elctbl_chc_id,
1882: p_yr_perd_id => p_rec.yr_perd_id,

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

2149: /*
2150: --
2151: -- Call all supporting business operations
2152: --
2153: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
2154: */
2155: chk_yr_perd_id
2156: (p_elig_per_elctbl_chc_id => p_rec.elig_per_elctbl_chc_id,
2157: p_yr_perd_id => p_rec.yr_perd_id,