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 HR_API

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

273: p_plip_id => p_plip_id,
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: --

Line 364: and nvl(p_dflt_enrt_det_rl,hr_api.g_number)

360: p_effective_date => p_effective_date,
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: --

Line 460: and nvl(p_auto_enrt_mthd_rl,hr_api.g_number)

456: p_effective_date => p_effective_date,
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: --

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 521: if hr_api.not_exists_in_hr_lookups

517: --
518: -- check if value of lookup falls within lookup type.
519: --
520:
521: if hr_api.not_exists_in_hr_lookups
522: (p_lookup_type => 'BEN_FMLY_MMBR',
523: p_lookup_code => p_vrfy_fmly_mmbr_cd,
524: p_effective_date => p_effective_date) then
525: --

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 571: if hr_api.not_exists_in_hr_lookups

567: then
568: -- check if value of lookup falls within lookup type.
569: --
570:
571: if hr_api.not_exists_in_hr_lookups
572: (p_lookup_type => 'BEN_USE_CSD_RSD_PRCCNG',
573: p_lookup_code => p_use_csd_rsd_prccng_cd,
574: p_effective_date => p_effective_date) then
575: --

Line 615: and nvl(p_vrfy_fmly_mmbr_rl,hr_api.g_number)

611: p_plip_id => p_plip_id,
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: --

Line 708: and nvl(p_enrt_rl,hr_api.g_number)

704: p_effective_date => p_effective_date,
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: --

Line 802: and nvl(p_dflt_to_asn_pndg_ctfn_rl,hr_api.g_number)

798: p_effective_date => p_effective_date,
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: --

Line 898: and nvl(p_mn_cvg_rl,hr_api.g_number)

894: p_effective_date => p_effective_date,
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: --

Line 994: and nvl(p_mx_cvg_rl,hr_api.g_number)

990: p_effective_date => p_effective_date,
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: --

Line 1090: and nvl(p_prort_prtl_yr_cvg_rstrn_rl,hr_api.g_number)

1086: p_effective_date => p_effective_date,
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: --

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 1175: if hr_api.not_exists_in_hr_lookups

1171: and p_dflt_enrt_cd is not null then
1172: --
1173: -- check if value of lookup falls within lookup type.
1174: --
1175: if hr_api.not_exists_in_hr_lookups
1176: (p_lookup_type => 'BEN_DFLT_ENRT',
1177: p_lookup_code => p_dflt_enrt_cd,
1178: p_effective_date => p_effective_date) then
1179: --

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 1244: if hr_api.not_exists_in_hr_lookups

1240: and p_dflt_to_asn_pndg_ctfn_cd is not null then
1241: --
1242: -- check if value of lookup falls within lookup type.
1243: --
1244: if hr_api.not_exists_in_hr_lookups
1245: (p_lookup_type => 'BEN_DFLT_TO_ASN_PNDG_CTFN',
1246: p_lookup_code => p_dflt_to_asn_pndg_ctfn_cd,
1247: p_effective_date => p_effective_date) then
1248: --

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 1315: if hr_api.not_exists_in_hr_lookups

1311: and p_unsspnd_enrt_cd is not null then
1312: --
1313: -- check if value of lookup falls within lookup type.
1314: --
1315: if hr_api.not_exists_in_hr_lookups
1316: (p_lookup_type => 'BEN_UNSSPND_ENRT',
1317: p_lookup_code => p_unsspnd_enrt_cd,
1318: p_effective_date => p_effective_date) then
1319: --

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 1386: if hr_api.not_exists_in_hr_lookups

1382: and p_prort_prtl_yr_cvg_rstrn_cd is not null then
1383: --
1384: -- check if value of lookup falls within lookup type.
1385: --
1386: if hr_api.not_exists_in_hr_lookups
1387: (p_lookup_type => 'BEN_PRORT_PRTL_YR_CVG_RSTRN',
1388: p_lookup_code => p_prort_prtl_yr_cvg_rstrn_cd,
1389: p_effective_date => p_effective_date) then
1390: --

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 1457: if hr_api.not_exists_in_hr_lookups

1453: and p_cvg_incr_r_decr_only_cd is not null then
1454: --
1455: -- check if value of lookup falls within lookup type.
1456: --
1457: if hr_api.not_exists_in_hr_lookups
1458: (p_lookup_type => 'BEN_CVG_INCR_R_DECR_ONLY',
1459: p_lookup_code => p_cvg_incr_r_decr_only_cd,
1460: p_effective_date => p_effective_date) then
1461: --

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 1528: if hr_api.not_exists_in_hr_lookups

1524: and p_bnft_or_option_rstrctn_cd is not null then
1525: --
1526: -- check if value of lookup falls within lookup type.
1527: --
1528: if hr_api.not_exists_in_hr_lookups
1529: (p_lookup_type => 'BEN_BNFT_R_OPT_RSTRN',
1530: p_lookup_code => p_bnft_or_option_rstrctn_cd,
1531: p_effective_date => p_effective_date) then
1532: --

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 1599: if hr_api.not_exists_in_hr_lookups

1595: and p_enrt_mthd_cd is not null then
1596: --
1597: -- check if value of lookup falls within lookup type.
1598: --
1599: if hr_api.not_exists_in_hr_lookups
1600: (p_lookup_type => 'BEN_ENRT_MTHD',
1601: p_lookup_code => p_enrt_mthd_cd,
1602: p_effective_date => p_effective_date) then
1603: --

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 1668: if hr_api.not_exists_in_hr_lookups

1664: and p_enrt_cd is not null then
1665: --
1666: -- check if value of lookup falls within lookup type.
1667: --
1668: if hr_api.not_exists_in_hr_lookups
1669: (p_lookup_type => 'BEN_ENRT',
1670: p_lookup_code => p_enrt_cd,
1671: p_effective_date => p_effective_date) then
1672: --

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 1737: if hr_api.not_exists_in_hr_lookups

1733: --
1734: -- check if value of lookup falls within lookup type.
1735: --
1736: --
1737: if hr_api.not_exists_in_hr_lookups
1738: (p_lookup_type => 'BEN_STAT',
1739: p_lookup_code => p_plip_stat_cd,
1740: p_effective_date => p_effective_date) then
1741: --

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 1806: if hr_api.not_exists_in_hr_lookups

1802: and p_dflt_flag is not null then
1803: --
1804: -- check if value of lookup falls within lookup type.
1805: --
1806: if hr_api.not_exists_in_hr_lookups
1807: (p_lookup_type => 'YES_NO',
1808: p_lookup_code => p_dflt_flag,
1809: p_effective_date => p_effective_date) then
1810: --

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 1875: if hr_api.not_exists_in_hr_lookups

1871: and p_alws_unrstrctd_enrt_flag is not null then
1872: --
1873: -- check if value of lookup falls within lookup type.
1874: --
1875: if hr_api.not_exists_in_hr_lookups
1876: (p_lookup_type => 'YES_NO',
1877: p_lookup_code => p_alws_unrstrctd_enrt_flag,
1878: p_effective_date => p_effective_date) then
1879: --

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 1944: if hr_api.not_exists_in_hr_lookups

1940: and p_no_mn_cvg_amt_apls_flag is not null then
1941: --
1942: -- check if value of lookup falls within lookup type.
1943: --
1944: if hr_api.not_exists_in_hr_lookups
1945: (p_lookup_type => 'YES_NO',
1946: p_lookup_code => p_no_mn_cvg_amt_apls_flag,
1947: p_effective_date => p_effective_date) then
1948: --

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 2015: if hr_api.not_exists_in_hr_lookups

2011: and p_no_mn_cvg_incr_apls_flag is not null then
2012: --
2013: -- check if value of lookup falls within lookup type.
2014: --
2015: if hr_api.not_exists_in_hr_lookups
2016: (p_lookup_type => 'YES_NO',
2017: p_lookup_code => p_no_mn_cvg_incr_apls_flag,
2018: p_effective_date => p_effective_date) then
2019: --

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 2086: if hr_api.not_exists_in_hr_lookups

2082: and p_no_mx_cvg_amt_apls_flag is not null then
2083: --
2084: -- check if value of lookup falls within lookup type.
2085: --
2086: if hr_api.not_exists_in_hr_lookups
2087: (p_lookup_type => 'YES_NO',
2088: p_lookup_code => p_no_mx_cvg_amt_apls_flag,
2089: p_effective_date => p_effective_date) then
2090: --

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 2157: if hr_api.not_exists_in_hr_lookups

2153: and p_no_mx_cvg_incr_apls_flag is not null then
2154: --
2155: -- check if value of lookup falls within lookup type.
2156: --
2157: if hr_api.not_exists_in_hr_lookups
2158: (p_lookup_type => 'YES_NO',
2159: p_lookup_code => p_no_mx_cvg_incr_apls_flag,
2160: p_effective_date => p_effective_date) then
2161: --

Line 2423: and nvl(p_dflt_enrt_cd,hr_api.g_varchar2)

2419: p_object_version_number => p_object_version_number);
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'.

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 2516: (nvl(p_dflt_enrt_cd,hr_api.g_varchar2)

2512: --
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)

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 2518: nvl(p_dflt_enrt_det_rl,hr_api.g_number)

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)
2522: )

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 2520: nvl(p_dflt_flag,hr_api.g_varchar2)

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
2524: --

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 2597: (nvl(p_dflt_enrt_cd,hr_api.g_varchar2)

2593: p_object_version_number => p_object_version_number);
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: )

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 2599: nvl(p_dflt_flag,hr_api.g_varchar2)

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
2603: --

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 2668: (nvl(p_dflt_enrt_cd,hr_api.g_varchar2)

2664: p_object_version_number => p_object_version_number);
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

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 2670: nvl(p_dflt_enrt_det_rl,hr_api.g_number)

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: --
2674: if (p_dflt_enrt_cd = 'RL' and p_dflt_enrt_det_rl is null) then

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 2681: if nvl(p_dflt_enrt_cd,hr_api.g_varchar2) <> 'RL' and p_dflt_enrt_det_rl is not null then

2677: fnd_message.raise_error;
2678: --
2679: end if;
2680: --
2681: if nvl(p_dflt_enrt_cd,hr_api.g_varchar2) <> 'RL' and p_dflt_enrt_det_rl is not null then
2682: --
2683: fnd_message.set_name('BEN','BEN_91223_DFLT_ENRT_MTHD_RWOC');
2684: fnd_message.raise_error;
2685: --

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

2952: p_effective_date => p_effective_date,
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: --

Line 3049: and nvl(p_enrt_cvg_end_dt_rl,hr_api.g_number)

3045: p_effective_date => p_effective_date,
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: --

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 3133: if hr_api.not_exists_in_hr_lookups

3129: -- check if value of lookup falls within lookup type.
3130: --
3131: --
3132: if p_enrt_cvg_strt_dt_cd is not null then
3133: if hr_api.not_exists_in_hr_lookups
3134: (p_lookup_type => 'BEN_ENRT_CVG_STRT',
3135: p_lookup_code => p_enrt_cvg_strt_dt_cd,
3136: p_effective_date => p_effective_date) then
3137: --

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 3204: if hr_api.not_exists_in_hr_lookups

3200: -- check if value of lookup falls within lookup type.
3201: --
3202: --
3203: if p_enrt_cvg_end_dt_cd is not null then
3204: if hr_api.not_exists_in_hr_lookups
3205: (p_lookup_type => 'BEN_ENRT_CVG_END',
3206: p_lookup_code => p_enrt_cvg_end_dt_cd,
3207: p_effective_date => p_effective_date) then
3208: --

Line 3284: and nvl(p_rt_strt_dt_rl,hr_api.g_number)

3280: p_effective_date => p_effective_date,
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: --

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 3369: if hr_api.not_exists_in_hr_lookups

3365: and p_rt_strt_dt_cd is not null then
3366: --
3367: -- check if value of lookup falls within lookup type.
3368: --
3369: if hr_api.not_exists_in_hr_lookups
3370: (p_lookup_type => 'BEN_RT_STRT',
3371: p_lookup_code => p_rt_strt_dt_cd,
3372: p_effective_date => p_effective_date) then
3373: --

Line 3450: and nvl(p_rt_end_dt_rl,hr_api.g_number)

3446: p_effective_date => p_effective_date,
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: --

Line 3545: and nvl(p_postelcn_edit_rl,hr_api.g_number)

3541: p_effective_date => p_effective_date,
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: --

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 3630: if hr_api.not_exists_in_hr_lookups

3626: and p_rt_end_dt_cd is not null then
3627: --
3628: -- check if value of lookup falls within lookup type.
3629: --
3630: if hr_api.not_exists_in_hr_lookups
3631: (p_lookup_type => 'BEN_RT_END',
3632: p_lookup_code => p_rt_end_dt_cd,
3633: p_effective_date => p_effective_date) then
3634: --

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 3701: if hr_api.not_exists_in_hr_lookups

3697: and p_drvbl_fctr_apls_rts_flag is not null then
3698: --
3699: -- check if value of lookup falls within lookup type.
3700: --
3701: if hr_api.not_exists_in_hr_lookups
3702: (p_lookup_type => 'YES_NO',
3703: p_lookup_code => p_drvbl_fctr_apls_rts_flag,
3704: p_effective_date => p_effective_date) then
3705: --

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 3771: if hr_api.not_exists_in_hr_lookups

3767: and p_drvbl_fctr_prtn_elig_flag is not null then
3768: --
3769: -- check if value of lookup falls within lookup type.
3770: --
3771: if hr_api.not_exists_in_hr_lookups
3772: (p_lookup_type => 'YES_NO',
3773: p_lookup_code => p_drvbl_fctr_prtn_elig_flag,
3774: p_effective_date => p_effective_date) then
3775: --

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 3842: if hr_api.not_exists_in_hr_lookups

3838: and p_elig_apls_flag is not null then
3839: --
3840: -- check if value of lookup falls within lookup type.
3841: --
3842: if hr_api.not_exists_in_hr_lookups
3843: (p_lookup_type => 'YES_NO',
3844: p_lookup_code => p_elig_apls_flag,
3845: p_effective_date => p_effective_date) then
3846: --

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 3914: if hr_api.not_exists_in_hr_lookups

3910: and p_prtn_elig_ovrid_alwd_flag is not null then
3911: --
3912: -- check if value of lookup falls within lookup type.
3913: --
3914: if hr_api.not_exists_in_hr_lookups
3915: (p_lookup_type => 'YES_NO',
3916: p_lookup_code => p_prtn_elig_ovrid_alwd_flag,
3917: p_effective_date => p_effective_date) then
3918: --

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 3986: if hr_api.not_exists_in_hr_lookups

3982: and p_trk_inelig_per_flag is not null then
3983: --
3984: -- check if value of lookup falls within lookup type.
3985: --
3986: if hr_api.not_exists_in_hr_lookups
3987: (p_lookup_type => 'YES_NO',
3988: p_lookup_code => p_trk_inelig_per_flag,
3989: p_effective_date => p_effective_date) then
3990: --

Line 4063: and nvl(p_dflt_to_asn_pndg_ctfn_cd,hr_api.g_varchar2)

4059: p_plip_id => p_plip_id,
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: --

Line 4240: hr_api.mandatory_arg_error

4236: hr_utility.set_location('Entering:'||l_proc, 5);
4237: --
4238: -- Ensure that the p_datetrack_mode argument is not null
4239: --
4240: hr_api.mandatory_arg_error
4241: (p_api_name => l_proc,
4242: p_argument => 'datetrack_mode',
4243: p_argument_value => p_datetrack_mode);
4244: --

Line 4252: hr_api.mandatory_arg_error

4248: --
4249: --
4250: -- Ensure the arguments are not null
4251: --
4252: hr_api.mandatory_arg_error
4253: (p_api_name => l_proc,
4254: p_argument => 'validation_start_date',
4255: p_argument_value => p_validation_start_date);
4256: --

Line 4257: hr_api.mandatory_arg_error

4253: (p_api_name => l_proc,
4254: p_argument => 'validation_start_date',
4255: p_argument_value => p_validation_start_date);
4256: --
4257: hr_api.mandatory_arg_error
4258: (p_api_name => l_proc,
4259: p_argument => 'validation_end_date',
4260: p_argument_value => p_validation_end_date);
4261: --

Line 4262: If ((nvl(p_dflt_enrt_det_rl, hr_api.g_number) <> hr_api.g_number) and

4258: (p_api_name => l_proc,
4259: p_argument => 'validation_end_date',
4260: p_argument_value => p_validation_end_date);
4261: --
4262: If ((nvl(p_dflt_enrt_det_rl, hr_api.g_number) <> hr_api.g_number) and
4263: NOT (dt_api.check_min_max_dates
4264: (p_base_table_name => 'ff_formulas_f',
4265: p_base_key_column => 'formula_id',
4266: p_base_key_value => p_dflt_enrt_det_rl,

Line 4272: If ((nvl(p_pl_id, hr_api.g_number) <> hr_api.g_number) and

4268: p_to_date => p_validation_end_date))) Then
4269: l_table_name := 'ff_formulas_f';
4270: Raise l_integrity_error;
4271: End If;
4272: If ((nvl(p_pl_id, hr_api.g_number) <> hr_api.g_number) and
4273: NOT (dt_api.check_min_max_dates
4274: (p_base_table_name => 'ben_pl_f',
4275: p_base_key_column => 'pl_id',
4276: p_base_key_value => p_pl_id,

Line 4282: If ((nvl(p_pgm_id, hr_api.g_number) <> hr_api.g_number) and

4278: p_to_date => p_validation_end_date))) Then
4279: l_table_name := 'ben_pl_f';
4280: Raise l_integrity_error;
4281: End If;
4282: If ((nvl(p_pgm_id, hr_api.g_number) <> hr_api.g_number) and
4283: NOT (dt_api.check_min_max_dates
4284: (p_base_table_name => 'ben_pgm_f',
4285: p_base_key_column => 'pgm_id',
4286: p_base_key_value => p_pgm_id,

Line 4364: hr_api.mandatory_arg_error

4360: hr_utility.set_location('Entering:'||l_proc, 5);
4361: --
4362: -- Ensure that the p_datetrack_mode argument is not null
4363: --
4364: hr_api.mandatory_arg_error
4365: (p_api_name => l_proc,
4366: p_argument => 'datetrack_mode',
4367: p_argument_value => p_datetrack_mode);
4368: --

Line 4378: hr_api.mandatory_arg_error

4374: --
4375: --
4376: -- Ensure the arguments are not null
4377: --
4378: hr_api.mandatory_arg_error
4379: (p_api_name => l_proc,
4380: p_argument => 'validation_start_date',
4381: p_argument_value => p_validation_start_date);
4382: --

Line 4383: hr_api.mandatory_arg_error

4379: (p_api_name => l_proc,
4380: p_argument => 'validation_start_date',
4381: p_argument_value => p_validation_start_date);
4382: --
4383: hr_api.mandatory_arg_error
4384: (p_api_name => l_proc,
4385: p_argument => 'validation_end_date',
4386: p_argument_value => p_validation_end_date);
4387: --

Line 4388: hr_api.mandatory_arg_error

4384: (p_api_name => l_proc,
4385: p_argument => 'validation_end_date',
4386: p_argument_value => p_validation_end_date);
4387: --
4388: hr_api.mandatory_arg_error
4389: (p_api_name => l_proc,
4390: p_argument => 'plip_id',
4391: p_argument_value => p_plip_id);
4392: --

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

4448: -- Call all supporting business operations
4449: --
4450: --
4451: if p_rec.business_group_id is not null and p_rec.legislation_code is null then
4452: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
4453: end if;
4454: --
4455: chk_plip_id
4456: (p_plip_id => p_rec.plip_id,

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

4828: -- Call all supporting business operations
4829: --
4830: --
4831: if p_rec.business_group_id is not null and p_rec.legislation_code is null then
4832: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
4833: end if;
4834: --
4835: chk_plip_id
4836: (p_plip_id => p_rec.plip_id,

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

5265: hr_utility.set_location('Entering:'|| l_proc, 10);
5266: --
5267: -- Ensure that all the mandatory parameter are not null
5268: --
5269: hr_api.mandatory_arg_error(p_api_name => l_proc,
5270: p_argument => 'plip_id',
5271: p_argument_value => p_plip_id);
5272: --
5273: open csr_leg_code;