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_CPP_BUS dependencies on BEN_CPP_SHD

Line 271: l_api_updating := ben_cpp_shd.api_updating

267: Begin
268: --
269: hr_utility.set_location('Entering:'||l_proc, 5);
270: --
271: l_api_updating := ben_cpp_shd.api_updating
272: (p_effective_date => p_effective_date,
273: p_plip_id => p_plip_id,
274: p_object_version_number => p_object_version_number);
275: --

Line 278: <> ben_cpp_shd.g_old_rec.plip_id) then

274: p_object_version_number => p_object_version_number);
275: --
276: if (l_api_updating
277: and nvl(p_plip_id,hr_api.g_number)
278: <> ben_cpp_shd.g_old_rec.plip_id) then
279: --
280: -- raise error as PK has changed
281: --
282: ben_cpp_shd.constraint_error('BEN_PLIP_PK');

Line 282: ben_cpp_shd.constraint_error('BEN_PLIP_PK');

278: <> ben_cpp_shd.g_old_rec.plip_id) then
279: --
280: -- raise error as PK has changed
281: --
282: ben_cpp_shd.constraint_error('BEN_PLIP_PK');
283: --
284: elsif not l_api_updating then
285: --
286: -- check if PK is null

Line 292: ben_cpp_shd.constraint_error('BEN_PLIP_PK');

288: if p_plip_id is not null then
289: --
290: -- raise error as PK is not null
291: --
292: ben_cpp_shd.constraint_error('BEN_PLIP_PK');
293: --
294: end if;
295: --
296: end if;

Line 358: l_api_updating := ben_cpp_shd.api_updating

354: Begin
355: --
356: hr_utility.set_location('Entering:'||l_proc, 5);
357: --
358: l_api_updating := ben_cpp_shd.api_updating
359: (p_plip_id => p_plip_id,
360: p_effective_date => p_effective_date,
361: p_object_version_number => p_object_version_number);
362: --

Line 365: <> ben_cpp_shd.g_old_rec.dflt_enrt_det_rl

361: p_object_version_number => p_object_version_number);
362: --
363: if (l_api_updating
364: and nvl(p_dflt_enrt_det_rl,hr_api.g_number)
365: <> ben_cpp_shd.g_old_rec.dflt_enrt_det_rl
366: or not l_api_updating)
367: and p_dflt_enrt_det_rl is not null then
368: --
369: -- check if value of formula rule is valid.

Line 454: l_api_updating := ben_cpp_shd.api_updating

450: Begin
451: --
452: hr_utility.set_location('Entering:'||l_proc, 5);
453: --
454: l_api_updating := ben_cpp_shd.api_updating
455: (p_plip_id => p_plip_id,
456: p_effective_date => p_effective_date,
457: p_object_version_number => p_object_version_number);
458: --

Line 461: <> ben_cpp_shd.g_old_rec.auto_enrt_mthd_rl

457: p_object_version_number => p_object_version_number);
458: --
459: if (l_api_updating
460: and nvl(p_auto_enrt_mthd_rl,hr_api.g_number)
461: <> ben_cpp_shd.g_old_rec.auto_enrt_mthd_rl
462: or not l_api_updating)
463: and p_auto_enrt_mthd_rl is not null then
464: --
465: -- check if value of formula rule is valid.

Line 506: l_api_updating := ben_cpp_shd.api_updating

502: Begin
503: --
504: hr_utility.set_location('Entering:'||l_proc, 5);
505: --
506: l_api_updating := ben_cpp_shd.api_updating
507: (p_plip_id => p_plip_id,
508: p_effective_date => p_effective_date,
509: p_object_version_number => p_object_version_number);
510: --

Line 513: <> nvl(ben_cpp_shd.g_old_rec.vrfy_fmly_mmbr_cd,hr_api.g_varchar2)

509: p_object_version_number => p_object_version_number);
510: --
511: if (l_api_updating
512: and p_vrfy_fmly_mmbr_cd
513: <> nvl(ben_cpp_shd.g_old_rec.vrfy_fmly_mmbr_cd,hr_api.g_varchar2)
514: or not l_api_updating)
515: and p_vrfy_fmly_mmbr_cd is not null
516: then
517: --

Line 557: l_api_updating := ben_cpp_shd.api_updating

553: Begin
554: --
555: hr_utility.set_location('Entering:'||l_proc, 5);
556: --
557: l_api_updating := ben_cpp_shd.api_updating
558: (p_plip_id => p_plip_id,
559: p_effective_date => p_effective_date,
560: p_object_version_number => p_object_version_number);
561: --

Line 564: <> nvl(ben_cpp_shd.g_old_rec.use_csd_rsd_prccng_cd,hr_api.g_varchar2)

560: p_object_version_number => p_object_version_number);
561: --
562: if (l_api_updating
563: and p_use_csd_rsd_prccng_cd
564: <> nvl(ben_cpp_shd.g_old_rec.use_csd_rsd_prccng_cd,hr_api.g_varchar2)
565: or not l_api_updating)
566: and p_use_csd_rsd_prccng_cd is not null
567: then
568: -- check if value of lookup falls within lookup type.

Line 609: l_api_updating := ben_cpp_shd.api_updating

605: Begin
606: --
607: hr_utility.set_location('Entering:'||l_proc, 5);
608: --
609: l_api_updating := ben_cpp_shd.api_updating
610: (p_effective_date => p_effective_date,
611: p_plip_id => p_plip_id,
612: p_object_version_number => p_object_version_number);
613: --

Line 616: <> ben_cpp_shd.g_old_rec.vrfy_fmly_mmbr_rl

612: p_object_version_number => p_object_version_number);
613: --
614: if (l_api_updating
615: and nvl(p_vrfy_fmly_mmbr_rl,hr_api.g_number)
616: <> ben_cpp_shd.g_old_rec.vrfy_fmly_mmbr_rl
617: or not l_api_updating)
618: and p_vrfy_fmly_mmbr_rl is not null then
619: --
620: -- check if value of formula rule is valid.

Line 702: l_api_updating := ben_cpp_shd.api_updating

698: Begin
699: --
700: hr_utility.set_location('Entering:'||l_proc, 5);
701: --
702: l_api_updating := ben_cpp_shd.api_updating
703: (p_plip_id => p_plip_id,
704: p_effective_date => p_effective_date,
705: p_object_version_number => p_object_version_number);
706: --

Line 709: <> ben_cpp_shd.g_old_rec.enrt_rl

705: p_object_version_number => p_object_version_number);
706: --
707: if (l_api_updating
708: and nvl(p_enrt_rl,hr_api.g_number)
709: <> ben_cpp_shd.g_old_rec.enrt_rl
710: or not l_api_updating)
711: and p_enrt_rl is not null then
712: --
713: -- check if value of formula rule is valid.

Line 796: l_api_updating := ben_cpp_shd.api_updating

792: Begin
793: --
794: hr_utility.set_location('Entering:'||l_proc, 5);
795: --
796: l_api_updating := ben_cpp_shd.api_updating
797: (p_plip_id => p_plip_id,
798: p_effective_date => p_effective_date,
799: p_object_version_number => p_object_version_number);
800: --

Line 803: <> ben_cpp_shd.g_old_rec.dflt_to_asn_pndg_ctfn_rl

799: p_object_version_number => p_object_version_number);
800: --
801: if (l_api_updating
802: and nvl(p_dflt_to_asn_pndg_ctfn_rl,hr_api.g_number)
803: <> ben_cpp_shd.g_old_rec.dflt_to_asn_pndg_ctfn_rl
804: or not l_api_updating)
805: and p_dflt_to_asn_pndg_ctfn_rl is not null then
806: --
807: -- check if value of formula rule is valid.

Line 892: l_api_updating := ben_cpp_shd.api_updating

888: Begin
889: --
890: hr_utility.set_location('Entering:'||l_proc, 5);
891: --
892: l_api_updating := ben_cpp_shd.api_updating
893: (p_plip_id => p_plip_id,
894: p_effective_date => p_effective_date,
895: p_object_version_number => p_object_version_number);
896: --

Line 899: <> ben_cpp_shd.g_old_rec.mn_cvg_rl

895: p_object_version_number => p_object_version_number);
896: --
897: if (l_api_updating
898: and nvl(p_mn_cvg_rl,hr_api.g_number)
899: <> ben_cpp_shd.g_old_rec.mn_cvg_rl
900: or not l_api_updating)
901: and p_mn_cvg_rl is not null then
902: --
903: -- check if value of formula rule is valid.

Line 988: l_api_updating := ben_cpp_shd.api_updating

984: Begin
985: --
986: hr_utility.set_location('Entering:'||l_proc, 5);
987: --
988: l_api_updating := ben_cpp_shd.api_updating
989: (p_plip_id => p_plip_id,
990: p_effective_date => p_effective_date,
991: p_object_version_number => p_object_version_number);
992: --

Line 995: <> ben_cpp_shd.g_old_rec.mx_cvg_rl

991: p_object_version_number => p_object_version_number);
992: --
993: if (l_api_updating
994: and nvl(p_mx_cvg_rl,hr_api.g_number)
995: <> ben_cpp_shd.g_old_rec.mx_cvg_rl
996: or not l_api_updating)
997: and p_mx_cvg_rl is not null then
998: --
999: -- check if value of formula rule is valid.

Line 1084: l_api_updating := ben_cpp_shd.api_updating

1080: Begin
1081: --
1082: hr_utility.set_location('Entering:'||l_proc, 5);
1083: --
1084: l_api_updating := ben_cpp_shd.api_updating
1085: (p_plip_id => p_plip_id,
1086: p_effective_date => p_effective_date,
1087: p_object_version_number => p_object_version_number);
1088: --

Line 1091: <> ben_cpp_shd.g_old_rec.prort_prtl_yr_cvg_rstrn_rl

1087: p_object_version_number => p_object_version_number);
1088: --
1089: if (l_api_updating
1090: and nvl(p_prort_prtl_yr_cvg_rstrn_rl,hr_api.g_number)
1091: <> ben_cpp_shd.g_old_rec.prort_prtl_yr_cvg_rstrn_rl
1092: or not l_api_updating)
1093: and p_prort_prtl_yr_cvg_rstrn_rl is not null then
1094: --
1095: -- check if value of formula rule is valid.

Line 1162: l_api_updating := ben_cpp_shd.api_updating

1158: Begin
1159: --
1160: hr_utility.set_location('Entering:'||l_proc, 5);
1161: --
1162: l_api_updating := ben_cpp_shd.api_updating
1163: (p_plip_id => p_plip_id,
1164: p_effective_date => p_effective_date,
1165: p_object_version_number => p_object_version_number);
1166: --

Line 1169: <> nvl(ben_cpp_shd.g_old_rec.dflt_enrt_cd,hr_api.g_varchar2)

1165: p_object_version_number => p_object_version_number);
1166: --
1167: if (l_api_updating
1168: and p_dflt_enrt_cd
1169: <> nvl(ben_cpp_shd.g_old_rec.dflt_enrt_cd,hr_api.g_varchar2)
1170: or not l_api_updating)
1171: and p_dflt_enrt_cd is not null then
1172: --
1173: -- check if value of lookup falls within lookup type.

Line 1231: l_api_updating := ben_cpp_shd.api_updating

1227: Begin
1228: --
1229: hr_utility.set_location('Entering:'||l_proc, 5);
1230: --
1231: l_api_updating := ben_cpp_shd.api_updating
1232: (p_plip_id => p_plip_id,
1233: p_effective_date => p_effective_date,
1234: p_object_version_number => p_object_version_number);
1235: --

Line 1238: <> nvl(ben_cpp_shd.g_old_rec.dflt_to_asn_pndg_ctfn_cd,hr_api.g_varchar2)

1234: p_object_version_number => p_object_version_number);
1235: --
1236: if (l_api_updating
1237: and p_dflt_to_asn_pndg_ctfn_cd
1238: <> nvl(ben_cpp_shd.g_old_rec.dflt_to_asn_pndg_ctfn_cd,hr_api.g_varchar2)
1239: or not l_api_updating)
1240: and p_dflt_to_asn_pndg_ctfn_cd is not null then
1241: --
1242: -- check if value of lookup falls within lookup type.

Line 1302: l_api_updating := ben_cpp_shd.api_updating

1298: Begin
1299: --
1300: hr_utility.set_location('Entering:'||l_proc, 5);
1301: --
1302: l_api_updating := ben_cpp_shd.api_updating
1303: (p_plip_id => p_plip_id,
1304: p_effective_date => p_effective_date,
1305: p_object_version_number => p_object_version_number);
1306: --

Line 1309: <> nvl(ben_cpp_shd.g_old_rec.unsspnd_enrt_cd,hr_api.g_varchar2)

1305: p_object_version_number => p_object_version_number);
1306: --
1307: if (l_api_updating
1308: and p_unsspnd_enrt_cd
1309: <> nvl(ben_cpp_shd.g_old_rec.unsspnd_enrt_cd,hr_api.g_varchar2)
1310: or not l_api_updating)
1311: and p_unsspnd_enrt_cd is not null then
1312: --
1313: -- check if value of lookup falls within lookup type.

Line 1373: l_api_updating := ben_cpp_shd.api_updating

1369: Begin
1370: --
1371: hr_utility.set_location('Entering:'||l_proc, 5);
1372: --
1373: l_api_updating := ben_cpp_shd.api_updating
1374: (p_plip_id => p_plip_id,
1375: p_effective_date => p_effective_date,
1376: p_object_version_number => p_object_version_number);
1377: --

Line 1380: <> nvl(ben_cpp_shd.g_old_rec.prort_prtl_yr_cvg_rstrn_cd,hr_api.g_varchar2)

1376: p_object_version_number => p_object_version_number);
1377: --
1378: if (l_api_updating
1379: and p_prort_prtl_yr_cvg_rstrn_cd
1380: <> nvl(ben_cpp_shd.g_old_rec.prort_prtl_yr_cvg_rstrn_cd,hr_api.g_varchar2)
1381: or not l_api_updating)
1382: and p_prort_prtl_yr_cvg_rstrn_cd is not null then
1383: --
1384: -- check if value of lookup falls within lookup type.

Line 1444: l_api_updating := ben_cpp_shd.api_updating

1440: Begin
1441: --
1442: hr_utility.set_location('Entering:'||l_proc, 5);
1443: --
1444: l_api_updating := ben_cpp_shd.api_updating
1445: (p_plip_id => p_plip_id,
1446: p_effective_date => p_effective_date,
1447: p_object_version_number => p_object_version_number);
1448: --

Line 1451: <> nvl(ben_cpp_shd.g_old_rec.cvg_incr_r_decr_only_cd,hr_api.g_varchar2)

1447: p_object_version_number => p_object_version_number);
1448: --
1449: if (l_api_updating
1450: and p_cvg_incr_r_decr_only_cd
1451: <> nvl(ben_cpp_shd.g_old_rec.cvg_incr_r_decr_only_cd,hr_api.g_varchar2)
1452: or not l_api_updating)
1453: and p_cvg_incr_r_decr_only_cd is not null then
1454: --
1455: -- check if value of lookup falls within lookup type.

Line 1515: l_api_updating := ben_cpp_shd.api_updating

1511: Begin
1512: --
1513: hr_utility.set_location('Entering:'||l_proc, 5);
1514: --
1515: l_api_updating := ben_cpp_shd.api_updating
1516: (p_plip_id => p_plip_id,
1517: p_effective_date => p_effective_date,
1518: p_object_version_number => p_object_version_number);
1519: --

Line 1522: <> nvl(ben_cpp_shd.g_old_rec.bnft_or_option_rstrctn_cd,hr_api.g_varchar2)

1518: p_object_version_number => p_object_version_number);
1519: --
1520: if (l_api_updating
1521: and p_bnft_or_option_rstrctn_cd
1522: <> nvl(ben_cpp_shd.g_old_rec.bnft_or_option_rstrctn_cd,hr_api.g_varchar2)
1523: or not l_api_updating)
1524: and p_bnft_or_option_rstrctn_cd is not null then
1525: --
1526: -- check if value of lookup falls within lookup type.

Line 1586: l_api_updating := ben_cpp_shd.api_updating

1582: Begin
1583: --
1584: hr_utility.set_location('Entering:'||l_proc, 5);
1585: --
1586: l_api_updating := ben_cpp_shd.api_updating
1587: (p_plip_id => p_plip_id,
1588: p_effective_date => p_effective_date,
1589: p_object_version_number => p_object_version_number);
1590: --

Line 1593: <> nvl(ben_cpp_shd.g_old_rec.enrt_mthd_cd,hr_api.g_varchar2)

1589: p_object_version_number => p_object_version_number);
1590: --
1591: if (l_api_updating
1592: and p_enrt_mthd_cd
1593: <> nvl(ben_cpp_shd.g_old_rec.enrt_mthd_cd,hr_api.g_varchar2)
1594: or not l_api_updating)
1595: and p_enrt_mthd_cd is not null then
1596: --
1597: -- check if value of lookup falls within lookup type.

Line 1655: l_api_updating := ben_cpp_shd.api_updating

1651: Begin
1652: --
1653: hr_utility.set_location('Entering:'||l_proc, 5);
1654: --
1655: l_api_updating := ben_cpp_shd.api_updating
1656: (p_plip_id => p_plip_id,
1657: p_effective_date => p_effective_date,
1658: p_object_version_number => p_object_version_number);
1659: --

Line 1662: <> nvl(ben_cpp_shd.g_old_rec.enrt_cd,hr_api.g_varchar2)

1658: p_object_version_number => p_object_version_number);
1659: --
1660: if (l_api_updating
1661: and p_enrt_cd
1662: <> nvl(ben_cpp_shd.g_old_rec.enrt_cd,hr_api.g_varchar2)
1663: or not l_api_updating)
1664: and p_enrt_cd is not null then
1665: --
1666: -- check if value of lookup falls within lookup type.

Line 1724: l_api_updating := ben_cpp_shd.api_updating

1720: Begin
1721: --
1722: hr_utility.set_location('Entering:'||l_proc, 5);
1723: --
1724: l_api_updating := ben_cpp_shd.api_updating
1725: (p_plip_id => p_plip_id,
1726: p_effective_date => p_effective_date,
1727: p_object_version_number => p_object_version_number);
1728: --

Line 1731: <> nvl(ben_cpp_shd.g_old_rec.plip_stat_cd,hr_api.g_varchar2)

1727: p_object_version_number => p_object_version_number);
1728: --
1729: if (l_api_updating
1730: and p_plip_stat_cd
1731: <> nvl(ben_cpp_shd.g_old_rec.plip_stat_cd,hr_api.g_varchar2)
1732: or not l_api_updating) then
1733: --
1734: -- check if value of lookup falls within lookup type.
1735: --

Line 1793: l_api_updating := ben_cpp_shd.api_updating

1789: Begin
1790: --
1791: hr_utility.set_location('Entering:'||l_proc, 5);
1792: --
1793: l_api_updating := ben_cpp_shd.api_updating
1794: (p_plip_id => p_plip_id,
1795: p_effective_date => p_effective_date,
1796: p_object_version_number => p_object_version_number);
1797: --

Line 1800: <> nvl(ben_cpp_shd.g_old_rec.dflt_flag,hr_api.g_varchar2)

1796: p_object_version_number => p_object_version_number);
1797: --
1798: if (l_api_updating
1799: and p_dflt_flag
1800: <> nvl(ben_cpp_shd.g_old_rec.dflt_flag,hr_api.g_varchar2)
1801: or not l_api_updating)
1802: and p_dflt_flag is not null then
1803: --
1804: -- check if value of lookup falls within lookup type.

Line 1862: l_api_updating := ben_cpp_shd.api_updating

1858: Begin
1859: --
1860: hr_utility.set_location('Entering:'||l_proc, 5);
1861: --
1862: l_api_updating := ben_cpp_shd.api_updating
1863: (p_plip_id => p_plip_id,
1864: p_effective_date => p_effective_date,
1865: p_object_version_number => p_object_version_number);
1866: --

Line 1869: <> nvl(ben_cpp_shd.g_old_rec.alws_unrstrctd_enrt_flag,hr_api.g_varchar2)

1865: p_object_version_number => p_object_version_number);
1866: --
1867: if (l_api_updating
1868: and p_alws_unrstrctd_enrt_flag
1869: <> nvl(ben_cpp_shd.g_old_rec.alws_unrstrctd_enrt_flag,hr_api.g_varchar2)
1870: or not l_api_updating)
1871: and p_alws_unrstrctd_enrt_flag is not null then
1872: --
1873: -- check if value of lookup falls within lookup type.

Line 1931: l_api_updating := ben_cpp_shd.api_updating

1927: Begin
1928: --
1929: hr_utility.set_location('Entering:'||l_proc, 5);
1930: --
1931: l_api_updating := ben_cpp_shd.api_updating
1932: (p_plip_id => p_plip_id,
1933: p_effective_date => p_effective_date,
1934: p_object_version_number => p_object_version_number);
1935: --

Line 1938: <> nvl(ben_cpp_shd.g_old_rec.no_mn_cvg_amt_apls_flag,hr_api.g_varchar2)

1934: p_object_version_number => p_object_version_number);
1935: --
1936: if (l_api_updating
1937: and p_no_mn_cvg_amt_apls_flag
1938: <> nvl(ben_cpp_shd.g_old_rec.no_mn_cvg_amt_apls_flag,hr_api.g_varchar2)
1939: or not l_api_updating)
1940: and p_no_mn_cvg_amt_apls_flag is not null then
1941: --
1942: -- check if value of lookup falls within lookup type.

Line 2002: l_api_updating := ben_cpp_shd.api_updating

1998: Begin
1999: --
2000: hr_utility.set_location('Entering:'||l_proc, 5);
2001: --
2002: l_api_updating := ben_cpp_shd.api_updating
2003: (p_plip_id => p_plip_id,
2004: p_effective_date => p_effective_date,
2005: p_object_version_number => p_object_version_number);
2006: --

Line 2009: <> nvl(ben_cpp_shd.g_old_rec.no_mn_cvg_incr_apls_flag,hr_api.g_varchar2)

2005: p_object_version_number => p_object_version_number);
2006: --
2007: if (l_api_updating
2008: and p_no_mn_cvg_incr_apls_flag
2009: <> nvl(ben_cpp_shd.g_old_rec.no_mn_cvg_incr_apls_flag,hr_api.g_varchar2)
2010: or not l_api_updating)
2011: and p_no_mn_cvg_incr_apls_flag is not null then
2012: --
2013: -- check if value of lookup falls within lookup type.

Line 2073: l_api_updating := ben_cpp_shd.api_updating

2069: Begin
2070: --
2071: hr_utility.set_location('Entering:'||l_proc, 5);
2072: --
2073: l_api_updating := ben_cpp_shd.api_updating
2074: (p_plip_id => p_plip_id,
2075: p_effective_date => p_effective_date,
2076: p_object_version_number => p_object_version_number);
2077: --

Line 2080: <> nvl(ben_cpp_shd.g_old_rec.no_mx_cvg_amt_apls_flag,hr_api.g_varchar2)

2076: p_object_version_number => p_object_version_number);
2077: --
2078: if (l_api_updating
2079: and p_no_mx_cvg_amt_apls_flag
2080: <> nvl(ben_cpp_shd.g_old_rec.no_mx_cvg_amt_apls_flag,hr_api.g_varchar2)
2081: or not l_api_updating)
2082: and p_no_mx_cvg_amt_apls_flag is not null then
2083: --
2084: -- check if value of lookup falls within lookup type.

Line 2144: l_api_updating := ben_cpp_shd.api_updating

2140: Begin
2141: --
2142: hr_utility.set_location('Entering:'||l_proc, 5);
2143: --
2144: l_api_updating := ben_cpp_shd.api_updating
2145: (p_plip_id => p_plip_id,
2146: p_effective_date => p_effective_date,
2147: p_object_version_number => p_object_version_number);
2148: --

Line 2151: <> nvl(ben_cpp_shd.g_old_rec.no_mx_cvg_incr_apls_flag,hr_api.g_varchar2)

2147: p_object_version_number => p_object_version_number);
2148: --
2149: if (l_api_updating
2150: and p_no_mx_cvg_incr_apls_flag
2151: <> nvl(ben_cpp_shd.g_old_rec.no_mx_cvg_incr_apls_flag,hr_api.g_varchar2)
2152: or not l_api_updating)
2153: and p_no_mx_cvg_incr_apls_flag is not null then
2154: --
2155: -- check if value of lookup falls within lookup type.

Line 2416: l_api_updating := ben_cpp_shd.api_updating

2412: Begin
2413: --
2414: hr_utility.set_location('Entering:'||l_proc, 5);
2415: --
2416: l_api_updating := ben_cpp_shd.api_updating
2417: (p_plip_id => p_plip_id,
2418: p_effective_date => p_effective_date,
2419: p_object_version_number => p_object_version_number);
2420: --

Line 2424: <> nvl(ben_cpp_shd.g_old_rec.dflt_enrt_cd,hr_api.g_varchar2)

2420: --
2421:
2422: if (l_api_updating
2423: and nvl(p_dflt_enrt_cd,hr_api.g_varchar2)
2424: <> nvl(ben_cpp_shd.g_old_rec.dflt_enrt_cd,hr_api.g_varchar2)
2425: or not l_api_updating) then
2426: --
2427: -- If pgm provides no auto enroll flag = 'Y' then enrt mthd code can't be 'A'.
2428: -- Bypass this edit if mthd is null.

Line 2508: l_api_updating := ben_cpp_shd.api_updating

2504: Begin
2505: --
2506: hr_utility.set_location('Entering:'||l_proc, 5);
2507: --
2508: l_api_updating := ben_cpp_shd.api_updating
2509: (p_plip_id => p_plip_id,
2510: p_effective_date => p_effective_date,
2511: p_object_version_number => p_object_version_number);
2512: --

Line 2517: <> nvl(ben_cpp_shd.g_old_rec.dflt_enrt_cd,hr_api.g_varchar2) or

2513:
2514: if (l_api_updating
2515: and
2516: (nvl(p_dflt_enrt_cd,hr_api.g_varchar2)
2517: <> nvl(ben_cpp_shd.g_old_rec.dflt_enrt_cd,hr_api.g_varchar2) or
2518: nvl(p_dflt_enrt_det_rl,hr_api.g_number)
2519: <> nvl(ben_cpp_shd.g_old_rec.dflt_enrt_det_rl,hr_api.g_number) or
2520: nvl(p_dflt_flag,hr_api.g_varchar2)
2521: <> nvl(ben_cpp_shd.g_old_rec.dflt_flag,hr_api.g_varchar2)

Line 2519: <> nvl(ben_cpp_shd.g_old_rec.dflt_enrt_det_rl,hr_api.g_number) or

2515: and
2516: (nvl(p_dflt_enrt_cd,hr_api.g_varchar2)
2517: <> nvl(ben_cpp_shd.g_old_rec.dflt_enrt_cd,hr_api.g_varchar2) or
2518: nvl(p_dflt_enrt_det_rl,hr_api.g_number)
2519: <> nvl(ben_cpp_shd.g_old_rec.dflt_enrt_det_rl,hr_api.g_number) or
2520: nvl(p_dflt_flag,hr_api.g_varchar2)
2521: <> nvl(ben_cpp_shd.g_old_rec.dflt_flag,hr_api.g_varchar2)
2522: )
2523: or not l_api_updating) then

Line 2521: <> nvl(ben_cpp_shd.g_old_rec.dflt_flag,hr_api.g_varchar2)

2517: <> nvl(ben_cpp_shd.g_old_rec.dflt_enrt_cd,hr_api.g_varchar2) or
2518: nvl(p_dflt_enrt_det_rl,hr_api.g_number)
2519: <> nvl(ben_cpp_shd.g_old_rec.dflt_enrt_det_rl,hr_api.g_number) or
2520: nvl(p_dflt_flag,hr_api.g_varchar2)
2521: <> nvl(ben_cpp_shd.g_old_rec.dflt_flag,hr_api.g_varchar2)
2522: )
2523: or not l_api_updating) then
2524: --
2525: -- If pgm provides no dflt enroll flag = 'Y' then dflt fields must be null

Line 2590: l_api_updating := ben_cpp_shd.api_updating

2586: Begin
2587: --
2588: hr_utility.set_location('Entering:'||l_proc, 5);
2589: --
2590: l_api_updating := ben_cpp_shd.api_updating
2591: (p_plip_id => p_plip_id,
2592: p_effective_date => p_effective_date,
2593: p_object_version_number => p_object_version_number);
2594: --

Line 2598: <> nvl(ben_cpp_shd.g_old_rec.dflt_enrt_cd,hr_api.g_varchar2) or

2594: --
2595: if (l_api_updating
2596: and
2597: (nvl(p_dflt_enrt_cd,hr_api.g_varchar2)
2598: <> nvl(ben_cpp_shd.g_old_rec.dflt_enrt_cd,hr_api.g_varchar2) or
2599: nvl(p_dflt_flag,hr_api.g_varchar2)
2600: <> nvl(ben_cpp_shd.g_old_rec.dflt_flag,hr_api.g_varchar2)
2601: )
2602: or not l_api_updating) then

Line 2600: <> nvl(ben_cpp_shd.g_old_rec.dflt_flag,hr_api.g_varchar2)

2596: and
2597: (nvl(p_dflt_enrt_cd,hr_api.g_varchar2)
2598: <> nvl(ben_cpp_shd.g_old_rec.dflt_enrt_cd,hr_api.g_varchar2) or
2599: nvl(p_dflt_flag,hr_api.g_varchar2)
2600: <> nvl(ben_cpp_shd.g_old_rec.dflt_flag,hr_api.g_varchar2)
2601: )
2602: or not l_api_updating) then
2603: --
2604: -- check dependency

Line 2661: l_api_updating := ben_cpp_shd.api_updating

2657: Begin
2658: --
2659: hr_utility.set_location('Entering:'||l_proc, 5);
2660: --
2661: l_api_updating := ben_cpp_shd.api_updating
2662: (p_plip_id => p_plip_id,
2663: p_effective_date => p_effective_date,
2664: p_object_version_number => p_object_version_number);
2665: --

Line 2669: <> nvl(ben_cpp_shd.g_old_rec.dflt_enrt_cd,hr_api.g_varchar2) or

2665: --
2666: if (l_api_updating
2667: and
2668: (nvl(p_dflt_enrt_cd,hr_api.g_varchar2)
2669: <> nvl(ben_cpp_shd.g_old_rec.dflt_enrt_cd,hr_api.g_varchar2) or
2670: nvl(p_dflt_enrt_det_rl,hr_api.g_number)
2671: <> nvl(ben_cpp_shd.g_old_rec.dflt_enrt_det_rl,hr_api.g_number))
2672: or not l_api_updating) then
2673: --

Line 2671: <> nvl(ben_cpp_shd.g_old_rec.dflt_enrt_det_rl,hr_api.g_number))

2667: and
2668: (nvl(p_dflt_enrt_cd,hr_api.g_varchar2)
2669: <> nvl(ben_cpp_shd.g_old_rec.dflt_enrt_cd,hr_api.g_varchar2) or
2670: nvl(p_dflt_enrt_det_rl,hr_api.g_number)
2671: <> nvl(ben_cpp_shd.g_old_rec.dflt_enrt_det_rl,hr_api.g_number))
2672: or not l_api_updating) then
2673: --
2674: if (p_dflt_enrt_cd = 'RL' and p_dflt_enrt_det_rl is null) then
2675: --

Line 2950: l_api_updating := ben_cpp_shd.api_updating

2946: Begin
2947: --
2948: hr_utility.set_location('Entering:'||l_proc, 5);
2949: --
2950: l_api_updating := ben_cpp_shd.api_updating
2951: (p_plip_id => p_plip_id,
2952: p_effective_date => p_effective_date,
2953: p_object_version_number => p_object_version_number);
2954: --

Line 2957: <> ben_cpp_shd.g_old_rec.enrt_cvg_strt_dt_rl

2953: p_object_version_number => p_object_version_number);
2954: --
2955: if (l_api_updating
2956: and nvl(p_enrt_cvg_strt_dt_rl,hr_api.g_number)
2957: <> ben_cpp_shd.g_old_rec.enrt_cvg_strt_dt_rl
2958: or not l_api_updating)
2959: and p_enrt_cvg_strt_dt_rl is not null then
2960: --
2961: -- check if value of formula rule is valid.

Line 3043: l_api_updating := ben_cpp_shd.api_updating

3039: Begin
3040: --
3041: hr_utility.set_location('Entering:'||l_proc, 5);
3042: --
3043: l_api_updating := ben_cpp_shd.api_updating
3044: (p_plip_id => p_plip_id,
3045: p_effective_date => p_effective_date,
3046: p_object_version_number => p_object_version_number);
3047: --

Line 3050: <> ben_cpp_shd.g_old_rec.enrt_cvg_end_dt_rl

3046: p_object_version_number => p_object_version_number);
3047: --
3048: if (l_api_updating
3049: and nvl(p_enrt_cvg_end_dt_rl,hr_api.g_number)
3050: <> ben_cpp_shd.g_old_rec.enrt_cvg_end_dt_rl
3051: or not l_api_updating)
3052: and p_enrt_cvg_end_dt_rl is not null then
3053: --
3054: -- check if value of formula rule is valid.

Line 3119: l_api_updating := ben_cpp_shd.api_updating

3115: Begin
3116: --
3117: hr_utility.set_location('Entering:'||l_proc, 5);
3118: --
3119: l_api_updating := ben_cpp_shd.api_updating
3120: (p_plip_id => p_plip_id,
3121: p_effective_date => p_effective_date,
3122: p_object_version_number => p_object_version_number);
3123: --

Line 3126: <> nvl(ben_cpp_shd.g_old_rec.enrt_cvg_strt_dt_cd,hr_api.g_varchar2)

3122: p_object_version_number => p_object_version_number);
3123: --
3124: if (l_api_updating
3125: and p_enrt_cvg_strt_dt_cd
3126: <> nvl(ben_cpp_shd.g_old_rec.enrt_cvg_strt_dt_cd,hr_api.g_varchar2)
3127: or not l_api_updating) then
3128: --
3129: -- check if value of lookup falls within lookup type.
3130: --

Line 3190: l_api_updating := ben_cpp_shd.api_updating

3186: Begin
3187: --
3188: hr_utility.set_location('Entering:'||l_proc, 5);
3189: --
3190: l_api_updating := ben_cpp_shd.api_updating
3191: (p_plip_id => p_plip_id,
3192: p_effective_date => p_effective_date,
3193: p_object_version_number => p_object_version_number);
3194: --

Line 3197: <> nvl(ben_cpp_shd.g_old_rec.enrt_cvg_end_dt_cd,hr_api.g_varchar2)

3193: p_object_version_number => p_object_version_number);
3194: --
3195: if (l_api_updating
3196: and p_enrt_cvg_end_dt_cd
3197: <> nvl(ben_cpp_shd.g_old_rec.enrt_cvg_end_dt_cd,hr_api.g_varchar2)
3198: or not l_api_updating) then
3199: --
3200: -- check if value of lookup falls within lookup type.
3201: --

Line 3278: l_api_updating := ben_cpp_shd.api_updating

3274: Begin
3275: --
3276: hr_utility.set_location('Entering:'||l_proc, 5);
3277: --
3278: l_api_updating := ben_cpp_shd.api_updating
3279: (p_plip_id => p_plip_id,
3280: p_effective_date => p_effective_date,
3281: p_object_version_number => p_object_version_number);
3282: --

Line 3285: <> ben_cpp_shd.g_old_rec.rt_strt_dt_rl

3281: p_object_version_number => p_object_version_number);
3282: --
3283: if (l_api_updating
3284: and nvl(p_rt_strt_dt_rl,hr_api.g_number)
3285: <> ben_cpp_shd.g_old_rec.rt_strt_dt_rl
3286: or not l_api_updating)
3287: and p_rt_strt_dt_rl is not null then
3288: --
3289: -- check if value of formula rule is valid.

Line 3356: l_api_updating := ben_cpp_shd.api_updating

3352: Begin
3353: --
3354: hr_utility.set_location('Entering:'||l_proc, 5);
3355: --
3356: l_api_updating := ben_cpp_shd.api_updating
3357: (p_plip_id => p_plip_id,
3358: p_effective_date => p_effective_date,
3359: p_object_version_number => p_object_version_number);
3360: --

Line 3363: <> nvl(ben_cpp_shd.g_old_rec.rt_strt_dt_cd,hr_api.g_varchar2)

3359: p_object_version_number => p_object_version_number);
3360: --
3361: if (l_api_updating
3362: and p_rt_strt_dt_cd
3363: <> nvl(ben_cpp_shd.g_old_rec.rt_strt_dt_cd,hr_api.g_varchar2)
3364: or not l_api_updating)
3365: and p_rt_strt_dt_cd is not null then
3366: --
3367: -- check if value of lookup falls within lookup type.

Line 3444: l_api_updating := ben_cpp_shd.api_updating

3440: Begin
3441: --
3442: hr_utility.set_location('Entering:'||l_proc, 5);
3443: --
3444: l_api_updating := ben_cpp_shd.api_updating
3445: (p_plip_id => p_plip_id,
3446: p_effective_date => p_effective_date,
3447: p_object_version_number => p_object_version_number);
3448: --

Line 3451: <> ben_cpp_shd.g_old_rec.rt_end_dt_rl

3447: p_object_version_number => p_object_version_number);
3448: --
3449: if (l_api_updating
3450: and nvl(p_rt_end_dt_rl,hr_api.g_number)
3451: <> ben_cpp_shd.g_old_rec.rt_end_dt_rl
3452: or not l_api_updating)
3453: and p_rt_end_dt_rl is not null then
3454: --
3455: -- check if value of formula rule is valid.

Line 3539: l_api_updating := ben_cpp_shd.api_updating

3535: Begin
3536: --
3537: hr_utility.set_location('Entering:'||l_proc, 5);
3538: --
3539: l_api_updating := ben_cpp_shd.api_updating
3540: (p_plip_id => p_plip_id,
3541: p_effective_date => p_effective_date,
3542: p_object_version_number => p_object_version_number);
3543: --

Line 3546: <> ben_cpp_shd.g_old_rec.postelcn_edit_rl

3542: p_object_version_number => p_object_version_number);
3543: --
3544: if (l_api_updating
3545: and nvl(p_postelcn_edit_rl,hr_api.g_number)
3546: <> ben_cpp_shd.g_old_rec.postelcn_edit_rl
3547: or not l_api_updating)
3548: and p_postelcn_edit_rl is not null then
3549: --
3550: -- check if value of formula rule is valid.

Line 3617: l_api_updating := ben_cpp_shd.api_updating

3613: Begin
3614: --
3615: hr_utility.set_location('Entering:'||l_proc, 5);
3616: --
3617: l_api_updating := ben_cpp_shd.api_updating
3618: (p_plip_id => p_plip_id,
3619: p_effective_date => p_effective_date,
3620: p_object_version_number => p_object_version_number);
3621: --

Line 3624: <> nvl(ben_cpp_shd.g_old_rec.rt_end_dt_cd,hr_api.g_varchar2)

3620: p_object_version_number => p_object_version_number);
3621: --
3622: if (l_api_updating
3623: and p_rt_end_dt_cd
3624: <> nvl(ben_cpp_shd.g_old_rec.rt_end_dt_cd,hr_api.g_varchar2)
3625: or not l_api_updating)
3626: and p_rt_end_dt_cd is not null then
3627: --
3628: -- check if value of lookup falls within lookup type.

Line 3688: l_api_updating := ben_cpp_shd.api_updating

3684: Begin
3685: --
3686: hr_utility.set_location('Entering:'||l_proc, 5);
3687: --
3688: l_api_updating := ben_cpp_shd.api_updating
3689: (p_plip_id => p_plip_id,
3690: p_effective_date => p_effective_date,
3691: p_object_version_number => p_object_version_number);
3692: --

Line 3695: <> nvl(ben_cpp_shd.g_old_rec.drvbl_fctr_apls_rts_flag,hr_api.g_varchar2)

3691: p_object_version_number => p_object_version_number);
3692: --
3693: if (l_api_updating
3694: and p_drvbl_fctr_apls_rts_flag
3695: <> nvl(ben_cpp_shd.g_old_rec.drvbl_fctr_apls_rts_flag,hr_api.g_varchar2)
3696: or not l_api_updating)
3697: and p_drvbl_fctr_apls_rts_flag is not null then
3698: --
3699: -- check if value of lookup falls within lookup type.

Line 3758: l_api_updating := ben_cpp_shd.api_updating

3754: Begin
3755: --
3756: hr_utility.set_location('Entering:'||l_proc, 5);
3757: --
3758: l_api_updating := ben_cpp_shd.api_updating
3759: (p_plip_id => p_plip_id,
3760: p_effective_date => p_effective_date,
3761: p_object_version_number => p_object_version_number);
3762: --

Line 3765: <> nvl(ben_cpp_shd.g_old_rec.drvbl_fctr_prtn_elig_flag,hr_api.g_varchar2)

3761: p_object_version_number => p_object_version_number);
3762: --
3763: if (l_api_updating
3764: and p_drvbl_fctr_prtn_elig_flag
3765: <> nvl(ben_cpp_shd.g_old_rec.drvbl_fctr_prtn_elig_flag,hr_api.g_varchar2)
3766: or not l_api_updating)
3767: and p_drvbl_fctr_prtn_elig_flag is not null then
3768: --
3769: -- check if value of lookup falls within lookup type.

Line 3829: l_api_updating := ben_cpp_shd.api_updating

3825: Begin
3826: --
3827: hr_utility.set_location('Entering:'||l_proc, 5);
3828: --
3829: l_api_updating := ben_cpp_shd.api_updating
3830: (p_plip_id => p_plip_id,
3831: p_effective_date => p_effective_date,
3832: p_object_version_number => p_object_version_number);
3833: --

Line 3836: <> nvl(ben_cpp_shd.g_old_rec.elig_apls_flag,hr_api.g_varchar2)

3832: p_object_version_number => p_object_version_number);
3833: --
3834: if (l_api_updating
3835: and p_elig_apls_flag
3836: <> nvl(ben_cpp_shd.g_old_rec.elig_apls_flag,hr_api.g_varchar2)
3837: or not l_api_updating)
3838: and p_elig_apls_flag is not null then
3839: --
3840: -- check if value of lookup falls within lookup type.

Line 3901: l_api_updating := ben_cpp_shd.api_updating

3897: Begin
3898: --
3899: hr_utility.set_location('Entering:'||l_proc, 5);
3900: --
3901: l_api_updating := ben_cpp_shd.api_updating
3902: (p_plip_id => p_plip_id,
3903: p_effective_date => p_effective_date,
3904: p_object_version_number => p_object_version_number);
3905: --

Line 3908: <> nvl(ben_cpp_shd.g_old_rec.prtn_elig_ovrid_alwd_flag,hr_api.g_varchar2)

3904: p_object_version_number => p_object_version_number);
3905: --
3906: if (l_api_updating
3907: and p_prtn_elig_ovrid_alwd_flag
3908: <> nvl(ben_cpp_shd.g_old_rec.prtn_elig_ovrid_alwd_flag,hr_api.g_varchar2)
3909: or not l_api_updating)
3910: and p_prtn_elig_ovrid_alwd_flag is not null then
3911: --
3912: -- check if value of lookup falls within lookup type.

Line 3973: l_api_updating := ben_cpp_shd.api_updating

3969: Begin
3970: --
3971: hr_utility.set_location('Entering:'||l_proc, 5);
3972: --
3973: l_api_updating := ben_cpp_shd.api_updating
3974: (p_plip_id => p_plip_id,
3975: p_effective_date => p_effective_date,
3976: p_object_version_number => p_object_version_number);
3977: --

Line 3980: <> nvl(ben_cpp_shd.g_old_rec.trk_inelig_per_flag,hr_api.g_varchar2)

3976: p_object_version_number => p_object_version_number);
3977: --
3978: if (l_api_updating
3979: and p_trk_inelig_per_flag
3980: <> nvl(ben_cpp_shd.g_old_rec.trk_inelig_per_flag,hr_api.g_varchar2)
3981: or not l_api_updating)
3982: and p_trk_inelig_per_flag is not null then
3983: --
3984: -- check if value of lookup falls within lookup type.

Line 4057: l_api_updating := ben_cpp_shd.api_updating

4053: Begin
4054: --
4055: hr_utility.set_location('Entering:'||l_proc, 5);
4056: --
4057: l_api_updating := ben_cpp_shd.api_updating
4058: (p_effective_date => p_effective_date,
4059: p_plip_id => p_plip_id,
4060: p_object_version_number => p_object_version_number);
4061: --

Line 4064: <> nvl(ben_cpp_shd.g_old_rec.dflt_to_asn_pndg_ctfn_cd, '***')

4060: p_object_version_number => p_object_version_number);
4061: --
4062: if (l_api_updating
4063: and nvl(p_dflt_to_asn_pndg_ctfn_cd,hr_api.g_varchar2)
4064: <> nvl(ben_cpp_shd.g_old_rec.dflt_to_asn_pndg_ctfn_cd, '***')
4065: or not l_api_updating)
4066: and p_dflt_to_asn_pndg_ctfn_cd is not null then
4067: --
4068: hr_utility.set_location(l_proc, 15);

Line 4437: (p_rec in ben_cpp_shd.g_rec_type,

4433: -- ----------------------------------------------------------------------------
4434: -- |---------------------------< insert_validate >----------------------------|
4435: -- ----------------------------------------------------------------------------
4436: Procedure insert_validate
4437: (p_rec in ben_cpp_shd.g_rec_type,
4438: p_effective_date in date,
4439: p_datetrack_mode in varchar2,
4440: p_validation_start_date in date,
4441: p_validation_end_date in date) is

Line 4817: (p_rec in ben_cpp_shd.g_rec_type,

4813: -- ----------------------------------------------------------------------------
4814: -- |---------------------------< update_validate >----------------------------|
4815: -- ----------------------------------------------------------------------------
4816: Procedure update_validate
4817: (p_rec in ben_cpp_shd.g_rec_type,
4818: p_effective_date in date,
4819: p_datetrack_mode in varchar2,
4820: p_validation_start_date in date,
4821: p_validation_end_date in date) is

Line 5210: (p_rec in ben_cpp_shd.g_rec_type,

5206: -- ----------------------------------------------------------------------------
5207: -- |---------------------------< delete_validate >----------------------------|
5208: -- ----------------------------------------------------------------------------
5209: Procedure delete_validate
5210: (p_rec in ben_cpp_shd.g_rec_type,
5211: p_effective_date in date,
5212: p_datetrack_mode in varchar2,
5213: p_validation_start_date in date,
5214: p_validation_end_date in date) is