[Home] [Help]
33: hr_utility.set_location('Entering: '||l_proc, 10);
34: --
35: --Ensure that all the mandatory parameters are not null
36: --
37: hr_api.mandatory_arg_error(p_api_name => l_proc,
38: p_argument => 'elig_per_id',
39: p_argument_value => p_elig_per_id);
40: --
41: open csr_leg_code;
104: p_elig_per_id => p_elig_per_id,
105: p_object_version_number => p_object_version_number);
106: --
107: if (l_api_updating
108: and nvl(p_elig_per_id, hr_api.g_number)
109: <> ben_pep_shd.g_old_rec.elig_per_id) then
110: --
111: -- raise error as PK as changed
112: --
204: p_object_version_number => p_object_version_number);
205: --
206: if (l_api_updating
207: and p_comp_ref_uom
208: <> nvl(ben_pep_shd.g_old_rec.comp_ref_uom,hr_api.g_varchar2)
209: or not l_api_updating) and p_comp_ref_uom IS NOT NULL then
210: --
211: -- check if comp_ref_uom value exists in hr_lookups table
212: --
229: end if;
230: --
231: if (l_api_updating
232: and p_rt_comp_ref_uom
233: <> nvl(ben_pep_shd.g_old_rec.rt_comp_ref_uom,hr_api.g_varchar2)
234: or not l_api_updating) and p_rt_comp_ref_uom IS NOT NULL then
235: --
236: -- check if rt_comp_ref_uom value exists in hr_lookups table
237: --
391: p_effective_date => p_effective_date,
392: p_object_version_number => p_object_version_number);
393: --
394: if (l_api_updating
395: and nvl(p_wv_prtn_rsn_cd,hr_api.g_varchar2)
396: <> nvl(ben_pep_shd.g_old_rec.wv_prtn_rsn_cd,hr_api.g_varchar2)
397: or not l_api_updating) and p_wv_prtn_rsn_cd IS NOT NULL then
398: --
399: -- check if value of lookup falls within lookup type.
392: p_object_version_number => p_object_version_number);
393: --
394: if (l_api_updating
395: and nvl(p_wv_prtn_rsn_cd,hr_api.g_varchar2)
396: <> nvl(ben_pep_shd.g_old_rec.wv_prtn_rsn_cd,hr_api.g_varchar2)
397: or not l_api_updating) and p_wv_prtn_rsn_cd IS NOT NULL then
398: --
399: -- check if value of lookup falls within lookup type.
400: --
397: or not l_api_updating) and p_wv_prtn_rsn_cd IS NOT NULL then
398: --
399: -- check if value of lookup falls within lookup type.
400: --
401: if hr_api.not_exists_in_hr_lookups
402: (p_lookup_type => 'BEN_WV_PRTN_RSN',
403: p_lookup_code => p_wv_prtn_rsn_cd,
404: p_effective_date => p_effective_date) then
405: --
462: p_effective_date => p_effective_date,
463: p_object_version_number => p_object_version_number);
464: --
465: if (l_api_updating
466: and nvl(p_hrs_wkd_bndry_perd_cd,hr_api.g_varchar2)
467: <> nvl(ben_pep_shd.g_old_rec.hrs_wkd_bndry_perd_cd,hr_api.g_varchar2)
468: or not l_api_updating) and p_hrs_wkd_bndry_perd_cd IS NOT NULL then
469: --
470: -- check if value of lookup falls within lookup type.
463: p_object_version_number => p_object_version_number);
464: --
465: if (l_api_updating
466: and nvl(p_hrs_wkd_bndry_perd_cd,hr_api.g_varchar2)
467: <> nvl(ben_pep_shd.g_old_rec.hrs_wkd_bndry_perd_cd,hr_api.g_varchar2)
468: or not l_api_updating) and p_hrs_wkd_bndry_perd_cd IS NOT NULL then
469: --
470: -- check if value of lookup falls within lookup type.
471: --
469: --
470: -- check if value of lookup falls within lookup type.
471: --
472: --
473: if hr_api.not_exists_in_hr_lookups
474: (p_lookup_type => 'BEN_BNDRY_PERD',
475: p_lookup_code => p_hrs_wkd_bndry_perd_cd,
476: p_effective_date => p_effective_date) then
477: --
486: --
487: end if;
488: --
489: if (l_api_updating
490: and nvl(p_rt_hrs_wkd_bndry_perd_cd,hr_api.g_varchar2)
491: <> nvl(ben_pep_shd.g_old_rec.rt_hrs_wkd_bndry_perd_cd,hr_api.g_varchar2)
492: or not l_api_updating) and p_rt_hrs_wkd_bndry_perd_cd IS NOT NULL then
493: --
494: -- check if value of lookup falls within lookup type.
487: end if;
488: --
489: if (l_api_updating
490: and nvl(p_rt_hrs_wkd_bndry_perd_cd,hr_api.g_varchar2)
491: <> nvl(ben_pep_shd.g_old_rec.rt_hrs_wkd_bndry_perd_cd,hr_api.g_varchar2)
492: or not l_api_updating) and p_rt_hrs_wkd_bndry_perd_cd IS NOT NULL then
493: --
494: -- check if value of lookup falls within lookup type.
495: --
493: --
494: -- check if value of lookup falls within lookup type.
495: --
496: --
497: if hr_api.not_exists_in_hr_lookups
498: (p_lookup_type => 'BEN_BNDRY_PERD',
499: p_lookup_code => p_rt_hrs_wkd_bndry_perd_cd,
500: p_effective_date => p_effective_date) then
501: --
613: p_object_version_number => p_object_version_number);
614: --
615: if (l_api_updating
616: and p_wv_ctfn_typ_cd
617: <> nvl(ben_pep_shd.g_old_rec.wv_ctfn_typ_cd,hr_api.g_varchar2)
618: or not l_api_updating) and p_wv_ctfn_typ_cd IS NOT NULL then
619: --
620: -- check if value of lookup falls within lookup type.
621: --
619: --
620: -- check if value of lookup falls within lookup type.
621: --
622: --
623: if hr_api.not_exists_in_hr_lookups
624: (p_lookup_type => 'BEN_WV_PRTN_CTFN_TYP',
625: p_lookup_code => p_wv_ctfn_typ_cd,
626: p_effective_date => p_effective_date) then
627: --
692: p_object_version_number => p_object_version_number);
693: --
694: if (l_api_updating
695: and p_prtn_ovridn_rsn_cd
696: <> nvl(ben_pep_shd.g_old_rec.prtn_ovridn_rsn_cd,hr_api.g_varchar2)
697: or not l_api_updating) and p_prtn_ovridn_rsn_cd IS NOT NULL then
698: --
699: -- check if value of lookup falls within lookup type.
700: --
697: or not l_api_updating) and p_prtn_ovridn_rsn_cd IS NOT NULL then
698: --
699: -- check if value of lookup falls within lookup type.
700: --
701: if hr_api.not_exists_in_hr_lookups
702: (p_lookup_type => 'BEN_OVRID_RSN',
703: p_lookup_code => p_prtn_ovridn_rsn_cd,
704: p_effective_date => p_effective_date) then
705: --
781: p_object_version_number => p_object_version_number);
782: --
783: if (l_api_updating
784: and p_age_uom
785: <> nvl(ben_pep_shd.g_old_rec.age_uom,hr_api.g_varchar2)
786: or not l_api_updating) and p_age_uom IS NOT NULL then
787: --
788: -- check if value of lookup falls within lookup type.
789: --
786: or not l_api_updating) and p_age_uom IS NOT NULL then
787: --
788: -- check if value of lookup falls within lookup type.
789: --
790: if hr_api.not_exists_in_hr_lookups
791: (p_lookup_type => 'BEN_TM_UOM',
792: p_lookup_code => p_age_uom,
793: p_effective_date => p_effective_date) then
794: --
804: end if;
805: --
806: if (l_api_updating
807: and p_rt_age_uom
808: <> nvl(ben_pep_shd.g_old_rec.rt_age_uom,hr_api.g_varchar2)
809: or not l_api_updating) and p_rt_age_uom IS NOT NULL then
810: --
811: -- check if value of lookup falls within lookup type.
812: --
809: or not l_api_updating) and p_rt_age_uom IS NOT NULL then
810: --
811: -- check if value of lookup falls within lookup type.
812: --
813: if hr_api.not_exists_in_hr_lookups
814: (p_lookup_type => 'BEN_TM_UOM',
815: p_lookup_code => p_rt_age_uom,
816: p_effective_date => p_effective_date) then
817: --
893: p_object_version_number => p_object_version_number);
894: --
895: if (l_api_updating
896: and p_los_uom
897: <> nvl(ben_pep_shd.g_old_rec.los_uom,hr_api.g_varchar2)
898: or not l_api_updating) and p_los_uom IS NOT NULL then
899: --
900: -- check if value of lookup falls within lookup type.
901: --
898: or not l_api_updating) and p_los_uom IS NOT NULL then
899: --
900: -- check if value of lookup falls within lookup type.
901: --
902: if hr_api.not_exists_in_hr_lookups
903: (p_lookup_type => 'BEN_TM_UOM',
904: p_lookup_code => p_los_uom,
905: p_effective_date => p_effective_date) then
906: --
916: end if;
917: --
918: if (l_api_updating
919: and p_rt_los_uom
920: <> nvl(ben_pep_shd.g_old_rec.rt_los_uom,hr_api.g_varchar2)
921: or not l_api_updating) and p_rt_los_uom IS NOT NULL then
922: --
923: -- check if value of lookup falls within lookup type.
924: --
921: or not l_api_updating) and p_rt_los_uom IS NOT NULL then
922: --
923: -- check if value of lookup falls within lookup type.
924: --
925: if hr_api.not_exists_in_hr_lookups
926: (p_lookup_type => 'BEN_TM_UOM',
927: p_lookup_code => p_rt_los_uom,
928: p_effective_date => p_effective_date) then
929: --
987: p_effective_date => p_effective_date,
988: p_object_version_number => p_object_version_number);
989: --
990: if (l_api_updating and p_once_r_cntug_cd
991: <> nvl(ben_pep_shd.g_old_rec.once_r_cntug_cd,hr_api.g_varchar2)
992: or not l_api_updating)
993: and p_once_r_cntug_cd is not null then
994: --
995: -- check if value of lookup falls within lookup type.
993: and p_once_r_cntug_cd is not null then
994: --
995: -- check if value of lookup falls within lookup type.
996: --
997: if hr_api.not_exists_in_hr_lookups
998: (p_lookup_type => 'BEN_ONCE_R_CNTNG',
999: p_lookup_code => p_once_r_cntug_cd,
1000: p_effective_date => p_effective_date) then
1001: --
1058: p_effective_date => p_effective_date,
1059: p_object_version_number => p_object_version_number);
1060: --
1061: if (l_api_updating and p_no_mx_prtn_ovrid_thru_flag
1062: <> nvl(ben_pep_shd.g_old_rec.no_mx_prtn_ovrid_thru_flag,hr_api.g_varchar2)
1063: or not l_api_updating)
1064: and p_no_mx_prtn_ovrid_thru_flag is not null then
1065: --
1066: -- check if value of lookup falls within lookup type.
1064: and p_no_mx_prtn_ovrid_thru_flag is not null then
1065: --
1066: -- check if value of lookup falls within lookup type.
1067: --
1068: if hr_api.not_exists_in_hr_lookups
1069: (p_lookup_type => 'YES_NO',
1070: p_lookup_code => p_no_mx_prtn_ovrid_thru_flag,
1071: p_effective_date => p_effective_date) then
1072: --
1133: p_effective_date => p_effective_date,
1134: p_object_version_number => p_object_version_number);
1135: --
1136: if (l_api_updating and p_frz_comb_age_and_los_flag
1137: <> nvl(ben_pep_shd.g_old_rec.frz_comb_age_and_los_flag,hr_api.g_varchar2)
1138: or not l_api_updating)
1139: and p_frz_comb_age_and_los_flag is not null then
1140: --
1141: -- check if value of lookup falls within lookup type.
1142: --
1143: /*
1144: hr_utility.set_location('HRAPI_NEIHL:'||l_proc, 5);
1145: */
1146: if hr_api.not_exists_in_hr_lookups
1147: (p_lookup_type => 'YES_NO',
1148: p_lookup_code => p_frz_comb_age_and_los_flag,
1149: p_effective_date => p_effective_date) then
1150: --
1162: --
1163: end if;
1164: --
1165: if (l_api_updating and p_rt_frz_comb_age_and_los_flag
1166: <> nvl(ben_pep_shd.g_old_rec.rt_frz_comb_age_and_los_flag,hr_api.g_varchar2)
1167: or not l_api_updating)
1168: and p_rt_frz_comb_age_and_los_flag is not null then
1169: --
1170: -- check if value of lookup falls within lookup type.
1171: --
1172: /*
1173: hr_utility.set_location('HRAPI_NEIHL:'||l_proc, 5);
1174: */
1175: if hr_api.not_exists_in_hr_lookups
1176: (p_lookup_type => 'YES_NO',
1177: p_lookup_code => p_rt_frz_comb_age_and_los_flag,
1178: p_effective_date => p_effective_date) then
1179: --
1245: p_effective_date => p_effective_date,
1246: p_object_version_number => p_object_version_number);
1247: --
1248: if (l_api_updating and p_dpnt_othr_pl_cvrd_rl_flag
1249: <> nvl(ben_pep_shd.g_old_rec.dpnt_othr_pl_cvrd_rl_flag,hr_api.g_varchar2)
1250: or not l_api_updating)
1251: and p_dpnt_othr_pl_cvrd_rl_flag is not null then
1252: --
1253: -- check if value of lookup falls within lookup type.
1251: and p_dpnt_othr_pl_cvrd_rl_flag is not null then
1252: --
1253: -- check if value of lookup falls within lookup type.
1254: --
1255: if hr_api.not_exists_in_hr_lookups
1256: (p_lookup_type => 'YES_NO',
1257: p_lookup_code => p_dpnt_othr_pl_cvrd_rl_flag,
1258: p_effective_date => p_effective_date) then
1259: --
1317: p_effective_date => p_effective_date,
1318: p_object_version_number => p_object_version_number);
1319: --
1320: if (l_api_updating and p_pl_key_ee_flag
1321: <> nvl(ben_pep_shd.g_old_rec.pl_key_ee_flag, hr_api.g_varchar2)
1322: or not l_api_updating)
1323: and p_pl_key_ee_flag is not null then
1324: --
1325: -- check if value of lookup falls within lookup type.
1323: and p_pl_key_ee_flag is not null then
1324: --
1325: -- check if value of lookup falls within lookup type.
1326: --
1327: if hr_api.not_exists_in_hr_lookups
1328: (p_lookup_type => 'YES_NO',
1329: p_lookup_code => p_pl_key_ee_flag,
1330: p_effective_date => p_effective_date) then
1331: --
1389: p_effective_date => p_effective_date,
1390: p_object_version_number => p_object_version_number);
1391: --
1392: if (l_api_updating and p_prtn_ovridn_flag
1393: <> nvl(ben_pep_shd.g_old_rec.prtn_ovridn_flag,hr_api.g_varchar2)
1394: or not l_api_updating)
1395: and p_prtn_ovridn_flag is not null then
1396: --
1397: -- check if value of lookup falls within lookup type.
1395: and p_prtn_ovridn_flag is not null then
1396: --
1397: -- check if value of lookup falls within lookup type.
1398: --
1399: if hr_api.not_exists_in_hr_lookups
1400: (p_lookup_type => 'YES_NO',
1401: p_lookup_code => p_prtn_ovridn_flag,
1402: p_effective_date => p_effective_date) then
1403: --
1461: p_effective_date => p_effective_date,
1462: p_object_version_number => p_object_version_number);
1463: --
1464: if (l_api_updating and p_pl_hghly_compd_flag
1465: <> nvl(ben_pep_shd.g_old_rec.pl_hghly_compd_flag,hr_api.g_varchar2)
1466: or not l_api_updating)
1467: and p_pl_hghly_compd_flag is not null then
1468: --
1469: -- check if value of lookup falls within lookup type.
1468: --
1469: -- check if value of lookup falls within lookup type.
1470: --
1471: hr_utility.set_location('HRAPI_NEIHL:'||l_proc, 5);
1472: if hr_api.not_exists_in_hr_lookups
1473: (p_lookup_type => 'YES_NO',
1474: p_lookup_code => p_pl_hghly_compd_flag,
1475: p_effective_date => p_effective_date) then
1476: --
1538: p_effective_date => p_effective_date,
1539: p_object_version_number => p_object_version_number);
1540: --
1541: if (l_api_updating and p_frz_los_flag
1542: <> nvl(ben_pep_shd.g_old_rec.frz_los_flag,hr_api.g_varchar2)
1543: or not l_api_updating)
1544: and p_frz_los_flag is not null then
1545: --
1546: -- check if value of lookup falls within lookup type.
1547: --
1548: /*
1549: hr_utility.set_location('HRAPI_NEIHL:'||l_proc, 5);
1550: */
1551: if hr_api.not_exists_in_hr_lookups
1552: (p_lookup_type => 'YES_NO',
1553: p_lookup_code => p_frz_los_flag,
1554: p_effective_date => p_effective_date) then
1555: --
1567: --
1568: end if;
1569: --
1570: if (l_api_updating and p_rt_frz_los_flag
1571: <> nvl(ben_pep_shd.g_old_rec.rt_frz_los_flag,hr_api.g_varchar2)
1572: or not l_api_updating)
1573: and p_rt_frz_los_flag is not null then
1574: --
1575: -- check if value of lookup falls within lookup type.
1576: --
1577: /*
1578: hr_utility.set_location('HRAPI_NEIHL:'||l_proc, 5);
1579: */
1580: if hr_api.not_exists_in_hr_lookups
1581: (p_lookup_type => 'YES_NO',
1582: p_lookup_code => p_rt_frz_los_flag,
1583: p_effective_date => p_effective_date) then
1584: --
1650: p_effective_date => p_effective_date,
1651: p_object_version_number => p_object_version_number);
1652: --
1653: if (l_api_updating and p_frz_age_flag
1654: <> nvl(ben_pep_shd.g_old_rec.frz_age_flag,hr_api.g_varchar2)
1655: or not l_api_updating)
1656: and p_frz_age_flag is not null then
1657: --
1658: -- check if value of lookup falls within lookup type.
1659: --
1660: /*
1661: hr_utility.set_location('HRAPI_NEIHL:'||l_proc, 5);
1662: */
1663: if hr_api.not_exists_in_hr_lookups
1664: (p_lookup_type => 'YES_NO',
1665: p_lookup_code => p_frz_age_flag,
1666: p_effective_date => p_effective_date) then
1667: --
1679: --
1680: end if;
1681: --
1682: if (l_api_updating and p_rt_frz_age_flag
1683: <> nvl(ben_pep_shd.g_old_rec.rt_frz_age_flag,hr_api.g_varchar2)
1684: or not l_api_updating)
1685: and p_rt_frz_age_flag is not null then
1686: --
1687: -- check if value of lookup falls within lookup type.
1688: --
1689: /*
1690: hr_utility.set_location('HRAPI_NEIHL:'||l_proc, 5);
1691: */
1692: if hr_api.not_exists_in_hr_lookups
1693: (p_lookup_type => 'YES_NO',
1694: p_lookup_code => p_rt_frz_age_flag,
1695: p_effective_date => p_effective_date) then
1696: --
1762: p_effective_date => p_effective_date,
1763: p_object_version_number => p_object_version_number);
1764: --
1765: if (l_api_updating and p_frz_cmp_lvl_flag
1766: <> nvl(ben_pep_shd.g_old_rec.frz_cmp_lvl_flag,hr_api.g_varchar2)
1767: or not l_api_updating)
1768: and p_frz_cmp_lvl_flag is not null then
1769: --
1770: -- check if value of lookup falls within lookup type.
1771: --
1772: /*
1773: hr_utility.set_location('HRAPI_NEIHL:'||l_proc, 5);
1774: */
1775: if hr_api.not_exists_in_hr_lookups
1776: (p_lookup_type => 'YES_NO',
1777: p_lookup_code => p_frz_cmp_lvl_flag,
1778: p_effective_date => p_effective_date) then
1779: --
1791: --
1792: end if;
1793: --
1794: if (l_api_updating and p_rt_frz_cmp_lvl_flag
1795: <> nvl(ben_pep_shd.g_old_rec.rt_frz_cmp_lvl_flag,hr_api.g_varchar2)
1796: or not l_api_updating)
1797: and p_rt_frz_cmp_lvl_flag is not null then
1798: --
1799: -- check if value of lookup falls within lookup type.
1800: --
1801: /*
1802: hr_utility.set_location('HRAPI_NEIHL:'||l_proc, 5);
1803: */
1804: if hr_api.not_exists_in_hr_lookups
1805: (p_lookup_type => 'YES_NO',
1806: p_lookup_code => p_rt_frz_cmp_lvl_flag,
1807: p_effective_date => p_effective_date) then
1808: --
1874: p_effective_date => p_effective_date,
1875: p_object_version_number => p_object_version_number);
1876: --
1877: if (l_api_updating and p_frz_pct_fl_tm_flag
1878: <> nvl(ben_pep_shd.g_old_rec.frz_pct_fl_tm_flag,hr_api.g_varchar2)
1879: or not l_api_updating)
1880: and p_frz_pct_fl_tm_flag is not null then
1881: --
1882: -- check if value of lookup falls within lookup type.
1883: --
1884: /*
1885: hr_utility.set_location('HRAPI_NEIHL:'||l_proc, 5);
1886: */
1887: if hr_api.not_exists_in_hr_lookups
1888: (p_lookup_type => 'YES_NO',
1889: p_lookup_code => p_frz_pct_fl_tm_flag,
1890: p_effective_date => p_effective_date) then
1891: --
1903: --
1904: end if;
1905: --
1906: if (l_api_updating and p_rt_frz_pct_fl_tm_flag
1907: <> nvl(ben_pep_shd.g_old_rec.rt_frz_pct_fl_tm_flag,hr_api.g_varchar2)
1908: or not l_api_updating)
1909: and p_rt_frz_pct_fl_tm_flag is not null then
1910: --
1911: -- check if value of lookup falls within lookup type.
1912: --
1913: /*
1914: hr_utility.set_location('HRAPI_NEIHL:'||l_proc, 5);
1915: */
1916: if hr_api.not_exists_in_hr_lookups
1917: (p_lookup_type => 'YES_NO',
1918: p_lookup_code => p_rt_frz_pct_fl_tm_flag,
1919: p_effective_date => p_effective_date) then
1920: --
1984: p_effective_date => p_effective_date,
1985: p_object_version_number => p_object_version_number);
1986: --
1987: if (l_api_updating and p_frz_hrs_wkd_flag
1988: <> nvl(ben_pep_shd.g_old_rec.frz_hrs_wkd_flag,hr_api.g_varchar2)
1989: or not l_api_updating)
1990: and p_frz_hrs_wkd_flag is not null then
1991: --
1992: -- check if value of lookup falls within lookup type.
1991: --
1992: -- check if value of lookup falls within lookup type.
1993: --
1994: hr_utility.set_location('HRAPI_NEIHL:'||l_proc, 5);
1995: if hr_api.not_exists_in_hr_lookups
1996: (p_lookup_type => 'YES_NO',
1997: p_lookup_code => p_frz_hrs_wkd_flag,
1998: p_effective_date => p_effective_date) then
1999: --
2009: --
2010: end if;
2011: --
2012: if (l_api_updating and p_rt_frz_hrs_wkd_flag
2013: <> nvl(ben_pep_shd.g_old_rec.rt_frz_hrs_wkd_flag,hr_api.g_varchar2)
2014: or not l_api_updating)
2015: and p_rt_frz_hrs_wkd_flag is not null then
2016: --
2017: -- check if value of lookup falls within lookup type.
2015: and p_rt_frz_hrs_wkd_flag is not null then
2016: --
2017: -- check if value of lookup falls within lookup type.
2018: --
2019: if hr_api.not_exists_in_hr_lookups
2020: (p_lookup_type => 'YES_NO',
2021: p_lookup_code => p_rt_frz_hrs_wkd_flag,
2022: p_effective_date => p_effective_date) then
2023: --
2081: p_effective_date => p_effective_date,
2082: p_object_version_number => p_object_version_number);
2083: --
2084: if (l_api_updating and p_dstr_rstcn_flag
2085: <> nvl(ben_pep_shd.g_old_rec.dstr_rstcn_flag,hr_api.g_varchar2)
2086: or not l_api_updating)
2087: and p_dstr_rstcn_flag is not null then
2088: --
2089: -- check if value of lookup falls within lookup type.
2087: and p_dstr_rstcn_flag is not null then
2088: --
2089: -- check if value of lookup falls within lookup type.
2090: --
2091: if hr_api.not_exists_in_hr_lookups
2092: (p_lookup_type => 'YES_NO',
2093: p_lookup_code => p_dstr_rstcn_flag,
2094: p_effective_date => p_effective_date) then
2095: --
2153: p_effective_date => p_effective_date,
2154: p_object_version_number => p_object_version_number);
2155: --
2156: if (l_api_updating and p_elig_flag
2157: <> nvl(ben_pep_shd.g_old_rec.elig_flag,hr_api.g_varchar2)
2158: or not l_api_updating)
2159: and p_elig_flag is not null then
2160: --
2161: -- check if value of lookup falls within lookup type.
2159: and p_elig_flag is not null then
2160: --
2161: -- check if value of lookup falls within lookup type.
2162: --
2163: if hr_api.not_exists_in_hr_lookups
2164: (p_lookup_type => 'YES_NO',
2165: p_lookup_code => p_elig_flag,
2166: p_effective_date => p_effective_date) then
2167: --
2225: p_effective_date => p_effective_date,
2226: p_object_version_number => p_object_version_number);
2227: --
2228: if (l_api_updating and p_inelg_rsn_cd
2229: <> nvl(ben_pep_shd.g_old_rec.inelg_rsn_cd,hr_api.g_varchar2)
2230: or not l_api_updating)
2231: and p_inelg_rsn_cd is not null then
2232: --
2233: -- check if value of lookup falls within lookup type.
2231: and p_inelg_rsn_cd is not null then
2232: --
2233: -- check if value of lookup falls within lookup type.
2234: --
2235: if hr_api.not_exists_in_hr_lookups
2236: (p_lookup_type => 'BEN_INELG_RSN',
2237: p_lookup_code => p_inelg_rsn_cd,
2238: p_effective_date => p_effective_date) then
2239: --
2297: p_effective_date => p_effective_date,
2298: p_object_version_number => p_object_version_number);
2299: --
2300: if (l_api_updating and p_pl_wvd_flag
2301: <> nvl(ben_pep_shd.g_old_rec.pl_wvd_flag,hr_api.g_varchar2)
2302: or not l_api_updating)
2303: and p_pl_wvd_flag is not null then
2304: --
2305: -- check if value of lookup falls within lookup type.
2303: and p_pl_wvd_flag is not null then
2304: --
2305: -- check if value of lookup falls within lookup type.
2306: --
2307: if hr_api.not_exists_in_hr_lookups
2308: (p_lookup_type => 'YES_NO',
2309: p_lookup_code => p_pl_wvd_flag,
2310: p_effective_date => p_effective_date) then
2311: --
2353: --
2354: -- {End Of Comments}
2355: -- ----------------------------------------------------------------------------
2356: Procedure dt_update_validate
2357: (p_ler_id in number default hr_api.g_number,
2358: p_pgm_id in number default hr_api.g_number,
2359: p_plip_id in number default hr_api.g_number,
2360: p_ptip_id in number default hr_api.g_number,
2361: p_pl_id in number default hr_api.g_number,
2354: -- {End Of Comments}
2355: -- ----------------------------------------------------------------------------
2356: Procedure dt_update_validate
2357: (p_ler_id in number default hr_api.g_number,
2358: p_pgm_id in number default hr_api.g_number,
2359: p_plip_id in number default hr_api.g_number,
2360: p_ptip_id in number default hr_api.g_number,
2361: p_pl_id in number default hr_api.g_number,
2362: p_datetrack_mode in varchar2,
2355: -- ----------------------------------------------------------------------------
2356: Procedure dt_update_validate
2357: (p_ler_id in number default hr_api.g_number,
2358: p_pgm_id in number default hr_api.g_number,
2359: p_plip_id in number default hr_api.g_number,
2360: p_ptip_id in number default hr_api.g_number,
2361: p_pl_id in number default hr_api.g_number,
2362: p_datetrack_mode in varchar2,
2363: p_validation_start_date in date,
2356: Procedure dt_update_validate
2357: (p_ler_id in number default hr_api.g_number,
2358: p_pgm_id in number default hr_api.g_number,
2359: p_plip_id in number default hr_api.g_number,
2360: p_ptip_id in number default hr_api.g_number,
2361: p_pl_id in number default hr_api.g_number,
2362: p_datetrack_mode in varchar2,
2363: p_validation_start_date in date,
2364: p_validation_end_date in date) Is
2357: (p_ler_id in number default hr_api.g_number,
2358: p_pgm_id in number default hr_api.g_number,
2359: p_plip_id in number default hr_api.g_number,
2360: p_ptip_id in number default hr_api.g_number,
2361: p_pl_id in number default hr_api.g_number,
2362: p_datetrack_mode in varchar2,
2363: p_validation_start_date in date,
2364: p_validation_end_date in date) Is
2365: --
2371: hr_utility.set_location('Entering:'||l_proc, 5);
2372: --
2373: -- Ensure that the p_datetrack_mode argument is not null
2374: --
2375: hr_api.mandatory_arg_error
2376: (p_api_name => l_proc,
2377: p_argument => 'datetrack_mode',
2378: p_argument_value => p_datetrack_mode);
2379: --
2383: --
2384: --
2385: -- Ensure the arguments are not null
2386: --
2387: hr_api.mandatory_arg_error
2388: (p_api_name => l_proc,
2389: p_argument => 'validation_start_date',
2390: p_argument_value => p_validation_start_date);
2391: --
2388: (p_api_name => l_proc,
2389: p_argument => 'validation_start_date',
2390: p_argument_value => p_validation_start_date);
2391: --
2392: hr_api.mandatory_arg_error
2393: (p_api_name => l_proc,
2394: p_argument => 'validation_end_date',
2395: p_argument_value => p_validation_end_date);
2396: --
2393: (p_api_name => l_proc,
2394: p_argument => 'validation_end_date',
2395: p_argument_value => p_validation_end_date);
2396: --
2397: If ((nvl(p_ler_id, hr_api.g_number) <> hr_api.g_number) and
2398: NOT (dt_api.check_min_max_dates
2399: (p_base_table_name => 'ben_ler_f',
2400: p_base_key_column => 'ler_id',
2401: p_base_key_value => p_ler_id,
2403: p_to_date => p_validation_end_date))) Then
2404: l_table_name := 'ben_ler_f';
2405: Raise l_integrity_error;
2406: End If;
2407: If ((nvl(p_pgm_id, hr_api.g_number) <> hr_api.g_number) and
2408: NOT (dt_api.check_min_max_dates
2409: (p_base_table_name => 'ben_pgm_f',
2410: p_base_key_column => 'pgm_id',
2411: p_base_key_value => p_pgm_id,
2413: p_to_date => p_validation_end_date))) Then
2414: l_table_name := 'ben_pgm_f';
2415: Raise l_integrity_error;
2416: End If;
2417: If ((nvl(p_pl_id, hr_api.g_number) <> hr_api.g_number) and
2418: NOT (dt_api.check_min_max_dates
2419: (p_base_table_name => 'ben_pl_f',
2420: p_base_key_column => 'pl_id',
2421: p_base_key_value => p_pl_id,
2423: p_to_date => p_validation_end_date))) Then
2424: l_table_name := 'ben_pl_f';
2425: Raise l_integrity_error;
2426: End If;
2427: If ((nvl(p_plip_id, hr_api.g_number) <> hr_api.g_number) and
2428: NOT (dt_api.check_min_max_dates
2429: (p_base_table_name => 'ben_plip_f',
2430: p_base_key_column => 'plip_id',
2431: p_base_key_value => p_plip_id,
2433: p_to_date => p_validation_end_date))) Then
2434: l_table_name := 'ben_plip_f';
2435: Raise l_integrity_error;
2436: End If;
2437: If ((nvl(p_ptip_id, hr_api.g_number) <> hr_api.g_number) and
2438: NOT (dt_api.check_min_max_dates
2439: (p_base_table_name => 'ben_ptip_f',
2440: p_base_key_column => 'ptip_id',
2441: p_base_key_value => p_ptip_id,
2517: hr_utility.set_location('Entering:'||l_proc, 5);
2518: --
2519: -- Ensure that the p_datetrack_mode argument is not null
2520: --
2521: hr_api.mandatory_arg_error
2522: (p_api_name => l_proc,
2523: p_argument => 'datetrack_mode',
2524: p_argument_value => p_datetrack_mode);
2525: --
2531: --
2532: --
2533: -- Ensure the arguments are not null
2534: --
2535: hr_api.mandatory_arg_error
2536: (p_api_name => l_proc,
2537: p_argument => 'validation_start_date',
2538: p_argument_value => p_validation_start_date);
2539: --
2536: (p_api_name => l_proc,
2537: p_argument => 'validation_start_date',
2538: p_argument_value => p_validation_start_date);
2539: --
2540: hr_api.mandatory_arg_error
2541: (p_api_name => l_proc,
2542: p_argument => 'validation_end_date',
2543: p_argument_value => p_validation_end_date);
2544: --
2541: (p_api_name => l_proc,
2542: p_argument => 'validation_end_date',
2543: p_argument_value => p_validation_end_date);
2544: --
2545: hr_api.mandatory_arg_error
2546: (p_api_name => l_proc,
2547: p_argument => 'elig_per_id',
2548: p_argument_value => p_elig_per_id);
2549: --
2596: hr_utility.set_location('Entering:'||l_proc, 5);
2597: --
2598: -- Call all supporting business operations
2599: --
2600: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
2601: --
2602: chk_elig_per_id
2603: (p_elig_per_id => p_rec.elig_per_id,
2604: p_effective_date => p_effective_date,
2793: hr_utility.set_location('Entering:'||l_proc, 5);
2794: --
2795: -- Call all supporting business operations
2796: --
2797: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
2798: --
2799: chk_elig_per_id
2800: (p_elig_per_id => p_rec.elig_per_id,
2801: p_effective_date => p_effective_date,