[Home] [Help]
50: p_pl_id => p_pl_id,
51: p_object_version_number => p_object_version_number);
52: --
53: if (l_api_updating
54: and nvl(p_pl_id,hr_api.g_number)
55: <> ben_pln_shd.g_old_rec.pl_id) then
56: --
57: -- raise error as PK has changed
58: --
150: p_effective_date => p_effective_date,
151: p_object_version_number => p_object_version_number);
152: --
153: if (l_api_updating
154: and p_pl_typ_id <> nvl(ben_pln_shd.g_old_rec.pl_typ_id,hr_api.g_number) )
155: then
156: --
157: -- Get Option Code for old plan type
158: --
459: p_pl_id => p_pl_id,
460: p_object_version_number => p_object_version_number);
461: --
462: if (l_api_updating
463: and nvl(p_name,hr_api.g_varchar2)
464: <> ben_pln_shd.g_old_rec.name
465: or not l_api_updating) then
466: --
467: -- Check if plan name is unique.
588: p_pl_id => p_pl_id,
589: p_object_version_number => p_object_version_number);
590: --
591: if (l_api_updating
592: and p_pl_typ_id <> nvl(ben_pln_shd.g_old_rec.pl_typ_id,hr_api.g_number) ) then
593: --
594: open c_epe_exist;
595: --
596: fetch c_epe_exist into l_dummy;
871: p_pl_id => p_pl_id,
872: p_object_version_number => p_object_version_number);
873: --
874: if ( (l_api_updating
875: and nvl(p_dflt_to_asn_pndg_ctfn_cd,hr_api.g_varchar2)
876: <> nvl(ben_pln_shd.g_old_rec.dflt_to_asn_pndg_ctfn_cd, '***'))
877: or not l_api_updating)
878: and p_dflt_to_asn_pndg_ctfn_cd is not null then
879: --
1085: p_pl_id => p_pl_id,
1086: p_object_version_number => p_object_version_number);
1087: --
1088: if (l_api_updating
1089: and nvl(p_vrfy_fmly_mmbr_rl,hr_api.g_number)
1090: <> ben_pln_shd.g_old_rec.vrfy_fmly_mmbr_rl
1091: or not l_api_updating)
1092: and p_vrfy_fmly_mmbr_rl is not null then
1093: --
1194: p_object_version_number => p_object_version_number);
1195: --
1196: if (l_api_updating
1197: and p_vrfy_fmly_mmbr_cd
1198: <> nvl(ben_pln_shd.g_old_rec.vrfy_fmly_mmbr_cd,hr_api.g_varchar2)
1199: or not l_api_updating)
1200: and p_vrfy_fmly_mmbr_cd is not null
1201: then
1202: --
1202: --
1203: -- check if value of lookup falls within lookup type.
1204: --
1205:
1206: if hr_api.not_exists_in_hr_lookups
1207: (p_lookup_type => 'BEN_FMLY_MMBR',
1208: p_lookup_code => p_vrfy_fmly_mmbr_cd,
1209: p_effective_date => p_effective_date) then
1210: --
1242: p_object_version_number => p_object_version_number);
1243: --
1244: if (l_api_updating
1245: and p_use_csd_rsd_prccng_cd
1246: <> nvl(ben_pln_shd.g_old_rec.use_csd_rsd_prccng_cd,hr_api.g_varchar2)
1247: or not l_api_updating)
1248: and p_use_csd_rsd_prccng_cd is not null
1249: then
1250: --
1250: --
1251: -- check if value of lookup falls within lookup type.
1252: --
1253:
1254: if hr_api.not_exists_in_hr_lookups
1255: (p_lookup_type => 'BEN_USE_CSD_RSD_PRCCNG',
1256: p_lookup_code => p_use_csd_rsd_prccng_cd,
1257: p_effective_date => p_effective_date) then
1258: --
1777: p_object_version_number => p_object_version_number);
1778: --
1779: if (l_api_updating
1780: and p_alws_qdro_flag
1781: <> nvl(ben_pln_shd.g_old_rec.alws_qdro_flag,hr_api.g_varchar2)
1782: or not l_api_updating)
1783: and p_alws_qdro_flag is not null then
1784: --
1785: -- check if value of lookup falls within lookup type.
1783: and p_alws_qdro_flag is not null then
1784: --
1785: -- check if value of lookup falls within lookup type.
1786: --
1787: if hr_api.not_exists_in_hr_lookups
1788: (p_lookup_type => 'YES_NO',
1789: p_lookup_code => p_alws_qdro_flag,
1790: p_effective_date => p_effective_date) then
1791: --
1799: end if;
1800: --
1801: if (l_api_updating
1802: and p_alws_qmcso_flag
1803: <> nvl(ben_pln_shd.g_old_rec.alws_qmcso_flag,hr_api.g_varchar2)
1804: or not l_api_updating)
1805: and p_alws_qmcso_flag is not null then
1806: --
1807: -- check if value of lookup falls within lookup type.
1805: and p_alws_qmcso_flag is not null then
1806: --
1807: -- check if value of lookup falls within lookup type.
1808: --
1809: if hr_api.not_exists_in_hr_lookups
1810: (p_lookup_type => 'YES_NO',
1811: p_lookup_code => p_alws_qmcso_flag,
1812: p_effective_date => p_effective_date) then
1813: --
1821: end if;
1822: --
1823: if (l_api_updating
1824: and p_enrt_pl_opt_flag
1825: <> nvl(ben_pln_shd.g_old_rec.enrt_pl_opt_flag,hr_api.g_varchar2)
1826: or not l_api_updating)
1827: and p_enrt_pl_opt_flag is not null then
1828: --
1829: -- check if value of lookup falls within lookup type.
1827: and p_enrt_pl_opt_flag is not null then
1828: --
1829: -- check if value of lookup falls within lookup type.
1830: --
1831: if hr_api.not_exists_in_hr_lookups
1832: (p_lookup_type => 'YES_NO',
1833: p_lookup_code => p_enrt_pl_opt_flag,
1834: p_effective_date => p_effective_date) then
1835: --
1843: end if;
1844: --
1845: if (l_api_updating
1846: and p_alws_reimbmts_flag
1847: <> nvl(ben_pln_shd.g_old_rec.alws_reimbmts_flag,hr_api.g_varchar2)
1848: or not l_api_updating)
1849: and p_alws_reimbmts_flag is not null then
1850: --
1851: -- check if value of lookup falls within lookup type.
1849: and p_alws_reimbmts_flag is not null then
1850: --
1851: -- check if value of lookup falls within lookup type.
1852: --
1853: if hr_api.not_exists_in_hr_lookups
1854: (p_lookup_type => 'YES_NO',
1855: p_lookup_code => p_alws_reimbmts_flag,
1856: p_effective_date => p_effective_date) then
1857: --
1865: end if;
1866: --
1867: if (l_api_updating
1868: and p_bnf_addl_instn_txt_alwd_flag
1869: <> nvl(ben_pln_shd.g_old_rec.bnf_addl_instn_txt_alwd_flag,hr_api.g_varchar2)
1870: or not l_api_updating)
1871: and p_bnf_addl_instn_txt_alwd_flag is not null then
1872: --
1873: -- check if value of lookup falls within lookup type.
1871: and p_bnf_addl_instn_txt_alwd_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_bnf_addl_instn_txt_alwd_flag,
1878: p_effective_date => p_effective_date) then
1879: --
1887: end if;
1888: --
1889: if (l_api_updating
1890: and p_bnf_adrs_rqd_flag
1891: <> nvl(ben_pln_shd.g_old_rec.bnf_adrs_rqd_flag,hr_api.g_varchar2)
1892: or not l_api_updating)
1893: and p_bnf_adrs_rqd_flag is not null then
1894: --
1895: -- check if value of lookup falls within lookup type.
1893: and p_bnf_adrs_rqd_flag is not null then
1894: --
1895: -- check if value of lookup falls within lookup type.
1896: --
1897: if hr_api.not_exists_in_hr_lookups
1898: (p_lookup_type => 'YES_NO',
1899: p_lookup_code => p_bnf_adrs_rqd_flag,
1900: p_effective_date => p_effective_date) then
1901: --
1909: end if;
1910: --
1911: if (l_api_updating
1912: and p_bnf_cntngt_bnfs_alwd_flag
1913: <> nvl(ben_pln_shd.g_old_rec.bnf_cntngt_bnfs_alwd_flag,hr_api.g_varchar2)
1914: or not l_api_updating)
1915: and p_bnf_cntngt_bnfs_alwd_flag is not null then
1916: --
1917: -- check if value of lookup falls within lookup type.
1915: and p_bnf_cntngt_bnfs_alwd_flag is not null then
1916: --
1917: -- check if value of lookup falls within lookup type.
1918: --
1919: if hr_api.not_exists_in_hr_lookups
1920: (p_lookup_type => 'YES_NO',
1921: p_lookup_code => p_bnf_cntngt_bnfs_alwd_flag,
1922: p_effective_date => p_effective_date) then
1923: --
1931: end if;
1932: --
1933: if (l_api_updating
1934: and p_bnf_ctfn_rqd_flag
1935: <> nvl(ben_pln_shd.g_old_rec.bnf_ctfn_rqd_flag,hr_api.g_varchar2)
1936: or not l_api_updating)
1937: and p_bnf_ctfn_rqd_flag is not null then
1938: --
1939: -- check if value of lookup falls within lookup type.
1937: and p_bnf_ctfn_rqd_flag is not null then
1938: --
1939: -- check if value of lookup falls within lookup type.
1940: --
1941: if hr_api.not_exists_in_hr_lookups
1942: (p_lookup_type => 'YES_NO',
1943: p_lookup_code => p_bnf_ctfn_rqd_flag,
1944: p_effective_date => p_effective_date) then
1945: --
1953: end if;
1954: --
1955: if (l_api_updating
1956: and p_bnf_dob_rqd_flag
1957: <> nvl(ben_pln_shd.g_old_rec.bnf_dob_rqd_flag,hr_api.g_varchar2)
1958: or not l_api_updating)
1959: and p_bnf_dob_rqd_flag is not null then
1960: --
1961: -- check if value of lookup falls within lookup type.
1959: and p_bnf_dob_rqd_flag is not null then
1960: --
1961: -- check if value of lookup falls within lookup type.
1962: --
1963: if hr_api.not_exists_in_hr_lookups
1964: (p_lookup_type => 'YES_NO',
1965: p_lookup_code => p_bnf_dob_rqd_flag,
1966: p_effective_date => p_effective_date) then
1967: --
1975: end if;
1976: --
1977: if (l_api_updating
1978: and p_bnf_dsge_mnr_ttee_rqd_flag
1979: <> nvl(ben_pln_shd.g_old_rec.bnf_dsge_mnr_ttee_rqd_flag,hr_api.g_varchar2)
1980: or not l_api_updating)
1981: and p_bnf_dsge_mnr_ttee_rqd_flag is not null then
1982: --
1983: -- check if value of lookup falls within lookup type.
1981: and p_bnf_dsge_mnr_ttee_rqd_flag is not null then
1982: --
1983: -- check if value of lookup falls within lookup type.
1984: --
1985: if hr_api.not_exists_in_hr_lookups
1986: (p_lookup_type => 'YES_NO',
1987: p_lookup_code => p_bnf_dsge_mnr_ttee_rqd_flag,
1988: p_effective_date => p_effective_date) then
1989: --
1997: end if;
1998: --
1999: if (l_api_updating
2000: and p_bnf_legv_id_rqd_flag
2001: <> nvl(ben_pln_shd.g_old_rec.bnf_legv_id_rqd_flag,hr_api.g_varchar2)
2002: or not l_api_updating)
2003: and p_bnf_legv_id_rqd_flag is not null then
2004: --
2005: -- check if value of lookup falls within lookup type.
2003: and p_bnf_legv_id_rqd_flag is not null then
2004: --
2005: -- check if value of lookup falls within lookup type.
2006: --
2007: if hr_api.not_exists_in_hr_lookups
2008: (p_lookup_type => 'YES_NO',
2009: p_lookup_code => p_bnf_legv_id_rqd_flag,
2010: p_effective_date => p_effective_date) then
2011: --
2019: end if;
2020: --
2021: if (l_api_updating
2022: and p_bnf_may_dsgt_org_flag
2023: <> nvl(ben_pln_shd.g_old_rec.bnf_may_dsgt_org_flag,hr_api.g_varchar2)
2024: or not l_api_updating)
2025: and p_bnf_may_dsgt_org_flag is not null then
2026: --
2027: -- check if value of lookup falls within lookup type.
2025: and p_bnf_may_dsgt_org_flag is not null then
2026: --
2027: -- check if value of lookup falls within lookup type.
2028: --
2029: if hr_api.not_exists_in_hr_lookups
2030: (p_lookup_type => 'YES_NO',
2031: p_lookup_code => p_bnf_may_dsgt_org_flag,
2032: p_effective_date => p_effective_date) then
2033: --
2041: end if;
2042: --
2043: if (l_api_updating
2044: and p_bnf_qdro_rl_apls_flag
2045: <> nvl(ben_pln_shd.g_old_rec.bnf_qdro_rl_apls_flag,hr_api.g_varchar2)
2046: or not l_api_updating)
2047: and p_bnf_qdro_rl_apls_flag is not null then
2048: --
2049: -- check if value of lookup falls within lookup type.
2047: and p_bnf_qdro_rl_apls_flag is not null then
2048: --
2049: -- check if value of lookup falls within lookup type.
2050: --
2051: if hr_api.not_exists_in_hr_lookups
2052: (p_lookup_type => 'YES_NO',
2053: p_lookup_code => p_bnf_qdro_rl_apls_flag,
2054: p_effective_date => p_effective_date) then
2055: --
2063: end if;
2064: --
2065: if (l_api_updating
2066: and p_drvbl_fctr_apls_rts_flag
2067: <> nvl(ben_pln_shd.g_old_rec.drvbl_fctr_apls_rts_flag,hr_api.g_varchar2)
2068: or not l_api_updating)
2069: and p_drvbl_fctr_apls_rts_flag is not null then
2070: --
2071: -- check if value of lookup falls within lookup type.
2069: and p_drvbl_fctr_apls_rts_flag is not null then
2070: --
2071: -- check if value of lookup falls within lookup type.
2072: --
2073: if hr_api.not_exists_in_hr_lookups
2074: (p_lookup_type => 'YES_NO',
2075: p_lookup_code => p_drvbl_fctr_apls_rts_flag,
2076: p_effective_date => p_effective_date) then
2077: --
2085: end if;
2086: --
2087: if (l_api_updating
2088: and p_drvbl_fctr_prtn_elig_flag
2089: <> nvl(ben_pln_shd.g_old_rec.drvbl_fctr_prtn_elig_flag,hr_api.g_varchar2)
2090: or not l_api_updating)
2091: and p_drvbl_fctr_prtn_elig_flag is not null then
2092: --
2093: -- check if value of lookup falls within lookup type.
2091: and p_drvbl_fctr_prtn_elig_flag is not null then
2092: --
2093: -- check if value of lookup falls within lookup type.
2094: --
2095: if hr_api.not_exists_in_hr_lookups
2096: (p_lookup_type => 'YES_NO',
2097: p_lookup_code => p_drvbl_fctr_prtn_elig_flag,
2098: p_effective_date => p_effective_date) then
2099: --
2107: end if;
2108: --
2109: if (l_api_updating
2110: and p_elig_apls_flag
2111: <> nvl(ben_pln_shd.g_old_rec.elig_apls_flag,hr_api.g_varchar2)
2112: or not l_api_updating)
2113: and p_elig_apls_flag is not null then
2114: --
2115: -- check if value of lookup falls within lookup type.
2113: and p_elig_apls_flag is not null then
2114: --
2115: -- check if value of lookup falls within lookup type.
2116: --
2117: if hr_api.not_exists_in_hr_lookups
2118: (p_lookup_type => 'YES_NO',
2119: p_lookup_code => p_elig_apls_flag,
2120: p_effective_date => p_effective_date) then
2121: --
2129: end if;
2130: --
2131: if (l_api_updating
2132: and p_invk_dcln_prtn_pl_flag
2133: <> nvl(ben_pln_shd.g_old_rec.invk_dcln_prtn_pl_flag,hr_api.g_varchar2)
2134: or not l_api_updating)
2135: and p_invk_dcln_prtn_pl_flag is not null then
2136: --
2137: -- check if value of lookup falls within lookup type.
2135: and p_invk_dcln_prtn_pl_flag is not null then
2136: --
2137: -- check if value of lookup falls within lookup type.
2138: --
2139: if hr_api.not_exists_in_hr_lookups
2140: (p_lookup_type => 'YES_NO',
2141: p_lookup_code => p_invk_dcln_prtn_pl_flag,
2142: p_effective_date => p_effective_date) then
2143: --
2151: end if;
2152: --
2153: if (l_api_updating
2154: and p_invk_flx_cr_pl_flag
2155: <> nvl(ben_pln_shd.g_old_rec.invk_flx_cr_pl_flag,hr_api.g_varchar2)
2156: or not l_api_updating)
2157: and p_invk_flx_cr_pl_flag is not null then
2158: --
2159: -- check if value of lookup falls within lookup type.
2157: and p_invk_flx_cr_pl_flag is not null then
2158: --
2159: -- check if value of lookup falls within lookup type.
2160: --
2161: if hr_api.not_exists_in_hr_lookups
2162: (p_lookup_type => 'YES_NO',
2163: p_lookup_code => p_invk_flx_cr_pl_flag,
2164: p_effective_date => p_effective_date) then
2165: --
2173: end if;
2174: --
2175: if (l_api_updating
2176: and p_drvbl_dpnt_elig_flag
2177: <> nvl(ben_pln_shd.g_old_rec.drvbl_dpnt_elig_flag,hr_api.g_varchar2)
2178: or not l_api_updating)
2179: and p_drvbl_dpnt_elig_flag is not null then
2180: --
2181: -- check if value of lookup falls within lookup type.
2179: and p_drvbl_dpnt_elig_flag is not null then
2180: --
2181: -- check if value of lookup falls within lookup type.
2182: --
2183: if hr_api.not_exists_in_hr_lookups
2184: (p_lookup_type => 'YES_NO',
2185: p_lookup_code => p_drvbl_dpnt_elig_flag,
2186: p_effective_date => p_effective_date) then
2187: --
2195: end if;
2196: --
2197: if (l_api_updating
2198: and p_dpnt_adrs_rqd_flag
2199: <> nvl(ben_pln_shd.g_old_rec.dpnt_adrs_rqd_flag,hr_api.g_varchar2)
2200: or not l_api_updating)
2201: and p_dpnt_adrs_rqd_flag is not null then
2202: --
2203: -- check if value of lookup falls within lookup type.
2201: and p_dpnt_adrs_rqd_flag is not null then
2202: --
2203: -- check if value of lookup falls within lookup type.
2204: --
2205: if hr_api.not_exists_in_hr_lookups
2206: (p_lookup_type => 'YES_NO',
2207: p_lookup_code => p_dpnt_adrs_rqd_flag,
2208: p_effective_date => p_effective_date) then
2209: --
2217: end if;
2218: --
2219: if (l_api_updating
2220: and p_trk_inelig_per_flag
2221: <> nvl(ben_pln_shd.g_old_rec.trk_inelig_per_flag,hr_api.g_varchar2)
2222: or not l_api_updating)
2223: and p_trk_inelig_per_flag is not null then
2224: --
2225: -- check if value of lookup falls within lookup type.
2223: and p_trk_inelig_per_flag is not null then
2224: --
2225: -- check if value of lookup falls within lookup type.
2226: --
2227: if hr_api.not_exists_in_hr_lookups
2228: (p_lookup_type => 'YES_NO',
2229: p_lookup_code => p_trk_inelig_per_flag,
2230: p_effective_date => p_effective_date) then
2231: --
2239: end if;
2240: --
2241: if (l_api_updating
2242: and p_svgs_pl_flag
2243: <> nvl(ben_pln_shd.g_old_rec.svgs_pl_flag,hr_api.g_varchar2)
2244: or not l_api_updating)
2245: and p_svgs_pl_flag is not null then
2246: --
2247: -- check if value of lookup falls within lookup type.
2245: and p_svgs_pl_flag is not null then
2246: --
2247: -- check if value of lookup falls within lookup type.
2248: --
2249: if hr_api.not_exists_in_hr_lookups
2250: (p_lookup_type => 'YES_NO',
2251: p_lookup_code => p_svgs_pl_flag,
2252: p_effective_date => p_effective_date) then
2253: --
2261: end if;
2262: --
2263: if (l_api_updating
2264: and p_dpnt_cvd_by_othr_apls_flag
2265: <> nvl(ben_pln_shd.g_old_rec.dpnt_cvd_by_othr_apls_flag,hr_api.g_varchar2)
2266: or not l_api_updating)
2267: and p_dpnt_cvd_by_othr_apls_flag is not null then
2268: --
2269: -- check if value of lookup falls within lookup type.
2267: and p_dpnt_cvd_by_othr_apls_flag is not null then
2268: --
2269: -- check if value of lookup falls within lookup type.
2270: --
2271: if hr_api.not_exists_in_hr_lookups
2272: (p_lookup_type => 'YES_NO',
2273: p_lookup_code => p_dpnt_cvd_by_othr_apls_flag,
2274: p_effective_date => p_effective_date) then
2275: --
2283: end if;
2284: --
2285: if (l_api_updating
2286: and p_frfs_aply_flag
2287: <> nvl(ben_pln_shd.g_old_rec.frfs_aply_flag,hr_api.g_varchar2)
2288: or not l_api_updating)
2289: and p_frfs_aply_flag is not null then
2290: --
2291: -- check if value of lookup falls within lookup type.
2289: and p_frfs_aply_flag is not null then
2290: --
2291: -- check if value of lookup falls within lookup type.
2292: --
2293: if hr_api.not_exists_in_hr_lookups
2294: (p_lookup_type => 'YES_NO',
2295: p_lookup_code => p_frfs_aply_flag,
2296: p_effective_date => p_effective_date) then
2297: --
2305: end if;
2306: --
2307: if (l_api_updating
2308: and p_hc_pl_subj_hcfa_aprvl_flag
2309: <> nvl(ben_pln_shd.g_old_rec.hc_pl_subj_hcfa_aprvl_flag,hr_api.g_varchar2)
2310: or not l_api_updating)
2311: and p_hc_pl_subj_hcfa_aprvl_flag is not null then
2312: --
2313: -- check if value of lookup falls within lookup type.
2311: and p_hc_pl_subj_hcfa_aprvl_flag is not null then
2312: --
2313: -- check if value of lookup falls within lookup type.
2314: --
2315: if hr_api.not_exists_in_hr_lookups
2316: (p_lookup_type => 'YES_NO',
2317: p_lookup_code => p_hc_pl_subj_hcfa_aprvl_flag,
2318: p_effective_date => p_effective_date) then
2319: --
2327: end if;
2328: --
2329: if (l_api_updating
2330: and p_hghly_cmpd_rl_apls_flag
2331: <> nvl(ben_pln_shd.g_old_rec.hghly_cmpd_rl_apls_flag,hr_api.g_varchar2)
2332: or not l_api_updating)
2333: and p_hghly_cmpd_rl_apls_flag is not null then
2334: --
2335: -- check if value of lookup falls within lookup type.
2333: and p_hghly_cmpd_rl_apls_flag is not null then
2334: --
2335: -- check if value of lookup falls within lookup type.
2336: --
2337: if hr_api.not_exists_in_hr_lookups
2338: (p_lookup_type => 'YES_NO',
2339: p_lookup_code => p_hghly_cmpd_rl_apls_flag,
2340: p_effective_date => p_effective_date) then
2341: --
2349: end if;
2350: --
2351: if (l_api_updating
2352: and p_dpnt_leg_id_rqd_flag
2353: <> nvl(ben_pln_shd.g_old_rec.dpnt_leg_id_rqd_flag,hr_api.g_varchar2)
2354: or not l_api_updating)
2355: and p_dpnt_leg_id_rqd_flag is not null then
2356: --
2357: -- check if value of lookup falls within lookup type.
2355: and p_dpnt_leg_id_rqd_flag is not null then
2356: --
2357: -- check if value of lookup falls within lookup type.
2358: --
2359: if hr_api.not_exists_in_hr_lookups
2360: (p_lookup_type => 'YES_NO',
2361: p_lookup_code => p_dpnt_leg_id_rqd_flag,
2362: p_effective_date => p_effective_date) then
2363: --
2371: end if;
2372: --
2373: if (l_api_updating
2374: and p_dpnt_dob_rqd_flag
2375: <> nvl(ben_pln_shd.g_old_rec.dpnt_dob_rqd_flag,hr_api.g_varchar2)
2376: or not l_api_updating)
2377: and p_dpnt_dob_rqd_flag is not null then
2378: --
2379: -- check if value of lookup falls within lookup type.
2377: and p_dpnt_dob_rqd_flag is not null then
2378: --
2379: -- check if value of lookup falls within lookup type.
2380: --
2381: if hr_api.not_exists_in_hr_lookups
2382: (p_lookup_type => 'YES_NO',
2383: p_lookup_code => p_dpnt_dob_rqd_flag,
2384: p_effective_date => p_effective_date) then
2385: --
2393: end if;
2394: --
2395: if (l_api_updating
2396: and p_dpnt_no_ctfn_rqd_flag
2397: <> nvl(ben_pln_shd.g_old_rec.dpnt_no_ctfn_rqd_flag,hr_api.g_varchar2)
2398: or not l_api_updating)
2399: and p_dpnt_no_ctfn_rqd_flag is not null then
2400: --
2401: -- check if value of lookup falls within lookup type.
2399: and p_dpnt_no_ctfn_rqd_flag is not null then
2400: --
2401: -- check if value of lookup falls within lookup type.
2402: --
2403: if hr_api.not_exists_in_hr_lookups
2404: (p_lookup_type => 'YES_NO',
2405: p_lookup_code => p_dpnt_no_ctfn_rqd_flag,
2406: p_effective_date => p_effective_date) then
2407: --
2415: end if;
2416: --
2417: if (l_api_updating
2418: and p_no_mn_cvg_amt_apls_flag
2419: <> nvl(ben_pln_shd.g_old_rec.no_mn_cvg_amt_apls_flag,hr_api.g_varchar2)
2420: or not l_api_updating)
2421: and p_no_mn_cvg_amt_apls_flag is not null then
2422: --
2423: -- check if value of lookup falls within lookup type.
2421: and p_no_mn_cvg_amt_apls_flag is not null then
2422: --
2423: -- check if value of lookup falls within lookup type.
2424: --
2425: if hr_api.not_exists_in_hr_lookups
2426: (p_lookup_type => 'YES_NO',
2427: p_lookup_code => p_no_mn_cvg_amt_apls_flag,
2428: p_effective_date => p_effective_date) then
2429: --
2437: end if;
2438: --
2439: if (l_api_updating
2440: and p_no_mn_cvg_incr_apls_flag
2441: <> nvl(ben_pln_shd.g_old_rec.no_mn_cvg_incr_apls_flag,hr_api.g_varchar2)
2442: or not l_api_updating)
2443: and p_no_mn_cvg_incr_apls_flag is not null then
2444: --
2445: -- check if value of lookup falls within lookup type.
2443: and p_no_mn_cvg_incr_apls_flag is not null then
2444: --
2445: -- check if value of lookup falls within lookup type.
2446: --
2447: if hr_api.not_exists_in_hr_lookups
2448: (p_lookup_type => 'YES_NO',
2449: p_lookup_code => p_no_mn_cvg_incr_apls_flag,
2450: p_effective_date => p_effective_date) then
2451: --
2459: end if;
2460: --
2461: if (l_api_updating
2462: and p_no_mn_opts_num_apls_flag
2463: <> nvl(ben_pln_shd.g_old_rec.no_mn_opts_num_apls_flag,hr_api.g_varchar2)
2464: or not l_api_updating)
2465: and p_no_mn_opts_num_apls_flag is not null then
2466: --
2467: -- check if value of lookup falls within lookup type.
2465: and p_no_mn_opts_num_apls_flag is not null then
2466: --
2467: -- check if value of lookup falls within lookup type.
2468: --
2469: if hr_api.not_exists_in_hr_lookups
2470: (p_lookup_type => 'YES_NO',
2471: p_lookup_code => p_no_mn_opts_num_apls_flag,
2472: p_effective_date => p_effective_date) then
2473: --
2481: end if;
2482: --
2483: if (l_api_updating
2484: and p_no_mx_cvg_amt_apls_flag
2485: <> nvl(ben_pln_shd.g_old_rec.no_mx_cvg_amt_apls_flag,hr_api.g_varchar2)
2486: or not l_api_updating)
2487: and p_no_mx_cvg_amt_apls_flag is not null then
2488: --
2489: -- check if value of lookup falls within lookup type.
2487: and p_no_mx_cvg_amt_apls_flag is not null then
2488: --
2489: -- check if value of lookup falls within lookup type.
2490: --
2491: if hr_api.not_exists_in_hr_lookups
2492: (p_lookup_type => 'YES_NO',
2493: p_lookup_code => p_no_mx_cvg_amt_apls_flag,
2494: p_effective_date => p_effective_date) then
2495: --
2503: end if;
2504: --
2505: if (l_api_updating
2506: and p_no_mx_cvg_incr_apls_flag
2507: <> nvl(ben_pln_shd.g_old_rec.no_mx_cvg_incr_apls_flag,hr_api.g_varchar2)
2508: or not l_api_updating)
2509: and p_no_mx_cvg_incr_apls_flag is not null then
2510: --
2511: -- check if value of lookup falls within lookup type.
2509: and p_no_mx_cvg_incr_apls_flag is not null then
2510: --
2511: -- check if value of lookup falls within lookup type.
2512: --
2513: if hr_api.not_exists_in_hr_lookups
2514: (p_lookup_type => 'YES_NO',
2515: p_lookup_code => p_no_mx_cvg_incr_apls_flag,
2516: p_effective_date => p_effective_date) then
2517: --
2525: end if;
2526: --
2527: if (l_api_updating
2528: and p_no_mx_opts_num_apls_flag
2529: <> nvl(ben_pln_shd.g_old_rec.no_mx_opts_num_apls_flag,hr_api.g_varchar2)
2530: or not l_api_updating)
2531: and p_no_mx_opts_num_apls_flag is not null then
2532: --
2533: -- check if value of lookup falls within lookup type.
2531: and p_no_mx_opts_num_apls_flag is not null then
2532: --
2533: -- check if value of lookup falls within lookup type.
2534: --
2535: if hr_api.not_exists_in_hr_lookups
2536: (p_lookup_type => 'YES_NO',
2537: p_lookup_code => p_no_mx_opts_num_apls_flag,
2538: p_effective_date => p_effective_date) then
2539: --
2547: end if;
2548: --
2549: if (l_api_updating
2550: and p_prtn_elig_ovrid_alwd_flag
2551: <> nvl(ben_pln_shd.g_old_rec.prtn_elig_ovrid_alwd_flag,hr_api.g_varchar2)
2552: or not l_api_updating)
2553: and p_prtn_elig_ovrid_alwd_flag is not null then
2554: --
2555: -- check if value of lookup falls within lookup type.
2553: and p_prtn_elig_ovrid_alwd_flag is not null then
2554: --
2555: -- check if value of lookup falls within lookup type.
2556: --
2557: if hr_api.not_exists_in_hr_lookups
2558: (p_lookup_type => 'YES_NO',
2559: p_lookup_code => p_prtn_elig_ovrid_alwd_flag,
2560: p_effective_date => p_effective_date) then
2561: --
2569: end if;
2570: --
2571: if (l_api_updating
2572: and p_subj_to_imptd_incm_typ_cd
2573: <> nvl(ben_pln_shd.g_old_rec.subj_to_imptd_incm_typ_cd,hr_api.g_varchar2)
2574: or not l_api_updating)
2575: and p_subj_to_imptd_incm_typ_cd is not null then
2576: --
2577: -- check if value of lookup falls within lookup type.
2575: and p_subj_to_imptd_incm_typ_cd is not null then
2576: --
2577: -- check if value of lookup falls within lookup type.
2578: --
2579: if hr_api.not_exists_in_hr_lookups
2580: (p_lookup_type => 'BEN_IMPTD_INCM_TYP',
2581: p_lookup_code => p_subj_to_imptd_incm_typ_cd,
2582: p_effective_date => p_effective_date) then
2583: --
2593: end if;
2594: --
2595: if (l_api_updating
2596: and p_use_all_asnts_elig_flag
2597: <> nvl(ben_pln_shd.g_old_rec.use_all_asnts_elig_flag,hr_api.g_varchar2)
2598: or not l_api_updating)
2599: and p_use_all_asnts_elig_flag is not null then
2600: --
2601: -- check if value of lookup falls within lookup type.
2599: and p_use_all_asnts_elig_flag is not null then
2600: --
2601: -- check if value of lookup falls within lookup type.
2602: --
2603: if hr_api.not_exists_in_hr_lookups
2604: (p_lookup_type => 'YES_NO',
2605: p_lookup_code => p_use_all_asnts_elig_flag,
2606: p_effective_date => p_effective_date) then
2607: --
2615: end if;
2616: --
2617: if (l_api_updating
2618: and p_use_all_asnts_for_rt_flag
2619: <> nvl(ben_pln_shd.g_old_rec.use_all_asnts_for_rt_flag,hr_api.g_varchar2)
2620: or not l_api_updating)
2621: and p_use_all_asnts_for_rt_flag is not null then
2622: --
2623: -- check if value of lookup falls within lookup type.
2621: and p_use_all_asnts_for_rt_flag is not null then
2622: --
2623: -- check if value of lookup falls within lookup type.
2624: --
2625: if hr_api.not_exists_in_hr_lookups
2626: (p_lookup_type => 'YES_NO',
2627: p_lookup_code => p_use_all_asnts_for_rt_flag,
2628: p_effective_date => p_effective_date) then
2629: --
2637: end if;
2638: --
2639: if (l_api_updating
2640: and p_vstg_apls_flag
2641: <> nvl(ben_pln_shd.g_old_rec.vstg_apls_flag,hr_api.g_varchar2)
2642: or not l_api_updating)
2643: and p_vstg_apls_flag is not null then
2644: --
2645: -- check if value of lookup falls within lookup type.
2643: and p_vstg_apls_flag is not null then
2644: --
2645: -- check if value of lookup falls within lookup type.
2646: --
2647: if hr_api.not_exists_in_hr_lookups
2648: (p_lookup_type => 'YES_NO',
2649: p_lookup_code => p_vstg_apls_flag,
2650: p_effective_date => p_effective_date) then
2651: --
2659: end if;
2660: --
2661: if (l_api_updating
2662: and p_wvbl_flag
2663: <> nvl(ben_pln_shd.g_old_rec.wvbl_flag,hr_api.g_varchar2)
2664: or not l_api_updating)
2665: and p_wvbl_flag is not null then
2666: --
2667: -- check if value of lookup falls within lookup type.
2665: and p_wvbl_flag is not null then
2666: --
2667: -- check if value of lookup falls within lookup type.
2668: --
2669: if hr_api.not_exists_in_hr_lookups
2670: (p_lookup_type => 'YES_NO',
2671: p_lookup_code => p_wvbl_flag,
2672: p_effective_date => p_effective_date) then
2673: --
2680: --
2681: --
2682: -- check if value of lookup falls within lookup type.
2683: --
2684: if hr_api.not_exists_in_hr_lookups
2685: (p_lookup_type => 'YES_NO',
2686: p_lookup_code => p_MAY_ENRL_PL_N_OIPL_flag,
2687: p_effective_date => p_effective_date) then
2688: --
2695: --
2696: --
2697: -- check if value of lookup falls within lookup type.
2698: --
2699: if hr_api.not_exists_in_hr_lookups
2700: (p_lookup_type => 'YES_NO',
2701: p_lookup_code => p_ALWS_UNRSTRCTD_ENRT_flag,
2702: p_effective_date => p_effective_date) then
2703: --
2711: --
2712: --
2713: -- check if value of lookup falls within lookup type.
2714: --
2715: if hr_api.not_exists_in_hr_lookups
2716: (p_lookup_type => 'YES_NO',
2717: p_lookup_code => p_ALWS_TMPRY_ID_CRD_flag,
2718: p_effective_date => p_effective_date) then
2719: --
2837: p_object_version_number => p_object_version_number);
2838: --
2839: if (l_api_updating
2840: and p_bnf_dflt_bnf_cd
2841: <> nvl(ben_pln_shd.g_old_rec.bnf_dflt_bnf_cd,hr_api.g_varchar2)
2842: or not l_api_updating)
2843: and p_bnf_dflt_bnf_cd is not null then
2844: --
2845: -- check if value of lookup falls within lookup type.
2843: and p_bnf_dflt_bnf_cd is not null then
2844: --
2845: -- check if value of lookup falls within lookup type.
2846: --
2847: if hr_api.not_exists_in_hr_lookups
2848: (p_lookup_type => 'BEN_BNF_DFLT',
2849: p_lookup_code => p_bnf_dflt_bnf_cd,
2850: p_effective_date => p_effective_date) then
2851: --
2861: end if;
2862: --
2863: if (l_api_updating
2864: and p_bnf_pct_amt_alwd_cd
2865: <> nvl(ben_pln_shd.g_old_rec.bnf_pct_amt_alwd_cd,hr_api.g_varchar2)
2866: or not l_api_updating)
2867: and p_bnf_pct_amt_alwd_cd is not null then
2868: --
2869: -- check if value of lookup falls within lookup type.
2867: and p_bnf_pct_amt_alwd_cd is not null then
2868: --
2869: -- check if value of lookup falls within lookup type.
2870: --
2871: if hr_api.not_exists_in_hr_lookups
2872: (p_lookup_type => 'BEN_BNF_PCT_AMT_ALWD',
2873: p_lookup_code => p_bnf_pct_amt_alwd_cd,
2874: p_effective_date => p_effective_date) then
2875: --
2885: end if;
2886: --
2887: if (l_api_updating
2888: and p_dpnt_dsgn_cd
2889: <> nvl(ben_pln_shd.g_old_rec.dpnt_dsgn_cd,hr_api.g_varchar2)
2890: or not l_api_updating)
2891: and p_dpnt_dsgn_cd is not null then
2892: --
2893: -- check if value of lookup falls within lookup type.
2891: and p_dpnt_dsgn_cd is not null then
2892: --
2893: -- check if value of lookup falls within lookup type.
2894: --
2895: if hr_api.not_exists_in_hr_lookups
2896: (p_lookup_type => 'BEN_DPNT_DSGN',
2897: p_lookup_code => p_dpnt_dsgn_cd,
2898: p_effective_date => p_effective_date) then
2899: --
2909: end if;
2910: --
2911: if (l_api_updating
2912: and p_pl_cd
2913: <> nvl(ben_pln_shd.g_old_rec.pl_cd,hr_api.g_varchar2)
2914: or not l_api_updating)
2915: and p_pl_cd is not null then
2916: --
2917: -- check if value of lookup falls within lookup type.
2915: and p_pl_cd is not null then
2916: --
2917: -- check if value of lookup falls within lookup type.
2918: --
2919: if hr_api.not_exists_in_hr_lookups
2920: (p_lookup_type => 'BEN_PL',
2921: p_lookup_code => p_pl_cd,
2922: p_effective_date => p_effective_date) then
2923: --
2933: end if;
2934: --
2935: if (l_api_updating
2936: and p_cmpr_clms_to_cvg_or_bal_cd
2937: <> nvl(ben_pln_shd.g_old_rec.cmpr_clms_to_cvg_or_bal_cd,hr_api.g_varchar2)
2938: or not l_api_updating)
2939: and p_cmpr_clms_to_cvg_or_bal_cd is not null then
2940: --
2941: -- check if value of lookup falls within lookup type.
2939: and p_cmpr_clms_to_cvg_or_bal_cd is not null then
2940: --
2941: -- check if value of lookup falls within lookup type.
2942: --
2943: if hr_api.not_exists_in_hr_lookups
2944: (p_lookup_type => 'BEN_CMPR_CLMS_TO_CVG_OR_BAL',
2945: p_lookup_code => p_cmpr_clms_to_cvg_or_bal_cd,
2946: p_effective_date => p_effective_date) then
2947: --
2957: end if;
2958: --
2959: if (l_api_updating
2960: and p_enrt_mthd_cd
2961: <> nvl(ben_pln_shd.g_old_rec.enrt_mthd_cd,hr_api.g_varchar2)
2962: or not l_api_updating)
2963: and p_enrt_mthd_cd is not null then
2964: --
2965: -- check if value of lookup falls within lookup type.
2963: and p_enrt_mthd_cd is not null then
2964: --
2965: -- check if value of lookup falls within lookup type.
2966: --
2967: if hr_api.not_exists_in_hr_lookups
2968: (p_lookup_type => 'BEN_ENRT_MTHD',
2969: p_lookup_code => p_enrt_mthd_cd,
2970: p_effective_date => p_effective_date) then
2971: --
2981: end if;
2982: --
2983: if (l_api_updating
2984: and p_enrt_cd
2985: <> nvl(ben_pln_shd.g_old_rec.enrt_cd,hr_api.g_varchar2)
2986: or not l_api_updating)
2987: and p_enrt_cd is not null then
2988: --
2989: -- check if value of lookup falls within lookup type.
2987: and p_enrt_cd is not null then
2988: --
2989: -- check if value of lookup falls within lookup type.
2990: --
2991: if hr_api.not_exists_in_hr_lookups
2992: (p_lookup_type => 'BEN_ENRT',
2993: p_lookup_code => p_enrt_cd,
2994: p_effective_date => p_effective_date) then
2995: --
3005: end if;
3006: --
3007: if (l_api_updating
3008: and p_dflt_to_asn_pndg_ctfn_cd
3009: <> nvl(ben_pln_shd.g_old_rec.dflt_to_asn_pndg_ctfn_cd,hr_api.g_varchar2)
3010: or not l_api_updating)
3011: and p_dflt_to_asn_pndg_ctfn_cd is not null then
3012: --
3013: -- check if value of lookup falls within lookup type.
3011: and p_dflt_to_asn_pndg_ctfn_cd is not null then
3012: --
3013: -- check if value of lookup falls within lookup type.
3014: --
3015: if hr_api.not_exists_in_hr_lookups
3016: (p_lookup_type => 'BEN_DFLT_TO_ASN_PNDG_CTFN',
3017: p_lookup_code => p_dflt_to_asn_pndg_ctfn_cd,
3018: p_effective_date => p_effective_date) then
3019: --
3029: end if;
3030: --
3031: if (l_api_updating
3032: and p_enrt_cvg_strt_dt_cd
3033: <> nvl(ben_pln_shd.g_old_rec.enrt_cvg_strt_dt_cd,hr_api.g_varchar2)
3034: or not l_api_updating)
3035: and p_enrt_cvg_strt_dt_cd is not null then
3036: --
3037: -- check if value of lookup falls within lookup type.
3035: and p_enrt_cvg_strt_dt_cd is not null then
3036: --
3037: -- check if value of lookup falls within lookup type.
3038: --
3039: if hr_api.not_exists_in_hr_lookups
3040: (p_lookup_type => 'BEN_ENRT_CVG_STRT',
3041: p_lookup_code => p_enrt_cvg_strt_dt_cd,
3042: p_effective_date => p_effective_date) then
3043: --
3053: end if;
3054: --
3055: if (l_api_updating
3056: and p_enrt_cvg_end_dt_cd
3057: <> nvl(ben_pln_shd.g_old_rec.enrt_cvg_end_dt_cd,hr_api.g_varchar2)
3058: or not l_api_updating)
3059: and p_enrt_cvg_end_dt_cd is not null then
3060: --
3061: -- check if value of lookup falls within lookup type.
3059: and p_enrt_cvg_end_dt_cd is not null then
3060: --
3061: -- check if value of lookup falls within lookup type.
3062: --
3063: if hr_api.not_exists_in_hr_lookups
3064: (p_lookup_type => 'BEN_ENRT_CVG_END',
3065: p_lookup_code => p_enrt_cvg_end_dt_cd,
3066: p_effective_date => p_effective_date) then
3067: --
3077: end if;
3078: --
3079: if (l_api_updating
3080: and p_mx_wtg_perd_prte_uom
3081: <> nvl(ben_pln_shd.g_old_rec.mx_wtg_perd_prte_uom,hr_api.g_varchar2)
3082: or not l_api_updating)
3083: and p_mx_wtg_perd_prte_uom is not null then
3084: --
3085: -- check if value of lookup falls within lookup type.
3083: and p_mx_wtg_perd_prte_uom is not null then
3084: --
3085: -- check if value of lookup falls within lookup type.
3086: --
3087: if hr_api.not_exists_in_hr_lookups
3088: (p_lookup_type => 'BEN_TM_UOM',
3089: p_lookup_code => p_mx_wtg_perd_prte_uom,
3090: p_effective_date => p_effective_date) then
3091: --
3101: end if;
3102: --
3103: if (l_api_updating
3104: and p_nip_dflt_enrt_cd
3105: <> nvl(ben_pln_shd.g_old_rec.nip_dflt_enrt_cd,hr_api.g_varchar2)
3106: or not l_api_updating)
3107: and p_nip_dflt_enrt_cd is not null then
3108: --
3109: -- check if value of lookup falls within lookup type.
3107: and p_nip_dflt_enrt_cd is not null then
3108: --
3109: -- check if value of lookup falls within lookup type.
3110: --
3111: if hr_api.not_exists_in_hr_lookups
3112: (p_lookup_type => 'BEN_DFLT_ENRT',
3113: p_lookup_code => p_nip_dflt_enrt_cd,
3114: p_effective_date => p_effective_date) then
3115: --
3125: end if;
3126: --
3127: if (l_api_updating
3128: and p_dpnt_cvg_end_dt_cd
3129: <> nvl(ben_pln_shd.g_old_rec.dpnt_cvg_end_dt_cd,hr_api.g_varchar2)
3130: or not l_api_updating)
3131: and p_dpnt_cvg_end_dt_cd is not null then
3132: --
3133: -- check if value of lookup falls within lookup type.
3131: and p_dpnt_cvg_end_dt_cd is not null then
3132: --
3133: -- check if value of lookup falls within lookup type.
3134: --
3135: if hr_api.not_exists_in_hr_lookups
3136: (p_lookup_type => 'BEN_DPNT_CVG_END',
3137: p_lookup_code => p_dpnt_cvg_end_dt_cd,
3138: p_effective_date => p_effective_date) then
3139: --
3149: end if;
3150: --
3151: if (l_api_updating
3152: and p_dpnt_cvg_strt_dt_cd
3153: <> nvl(ben_pln_shd.g_old_rec.dpnt_cvg_strt_dt_cd,hr_api.g_varchar2)
3154: or not l_api_updating)
3155: and p_dpnt_cvg_strt_dt_cd is not null then
3156: --
3157: -- check if value of lookup falls within lookup type.
3155: and p_dpnt_cvg_strt_dt_cd is not null then
3156: --
3157: -- check if value of lookup falls within lookup type.
3158: --
3159: if hr_api.not_exists_in_hr_lookups
3160: (p_lookup_type => 'BEN_DPNT_CVG_STRT',
3161: p_lookup_code => p_dpnt_cvg_strt_dt_cd,
3162: p_effective_date => p_effective_date) then
3163: --
3173: end if;
3174: --
3175: if (l_api_updating
3176: and p_nip_pl_uom
3177: <> nvl(ben_pln_shd.g_old_rec.nip_pl_uom,hr_api.g_varchar2)
3178: or not l_api_updating)
3179: and p_nip_pl_uom is not null then
3180: --
3181: -- check if value of lookup falls within fnd_currencies.
3195: --
3196:
3197: if (l_api_updating
3198: and p_nip_acty_ref_perd_cd
3199: <> nvl(ben_pln_shd.g_old_rec.nip_acty_ref_perd_cd,hr_api.g_varchar2)
3200: or not l_api_updating)
3201: and p_nip_acty_ref_perd_cd is not null then
3202: --
3203: -- check if value of lookup falls within lookup type.
3201: and p_nip_acty_ref_perd_cd is not null then
3202: --
3203: -- check if value of lookup falls within lookup type.
3204: --
3205: if hr_api.not_exists_in_hr_lookups
3206: (p_lookup_type => 'BEN_ACTY_REF_PERD',
3207: p_lookup_code => p_nip_acty_ref_perd_cd,
3208: p_effective_date => p_effective_date) then
3209: --
3219: end if;
3220: --
3221: if (l_api_updating
3222: and p_nip_enrt_info_rt_freq_cd
3223: <> nvl(ben_pln_shd.g_old_rec.nip_enrt_info_rt_freq_cd,hr_api.g_varchar2)
3224: or not l_api_updating)
3225: and p_nip_enrt_info_rt_freq_cd is not null then
3226: --
3227: -- check if value of lookup falls within lookup type.
3225: and p_nip_enrt_info_rt_freq_cd is not null then
3226: --
3227: -- check if value of lookup falls within lookup type.
3228: --
3229: if hr_api.not_exists_in_hr_lookups
3230: (p_lookup_type => 'BEN_ENRT_INFO_RT_FREQ',
3231: p_lookup_code => p_nip_enrt_info_rt_freq_cd,
3232: p_effective_date => p_effective_date) then
3233: --
3243: end if;
3244: --
3245: if (l_api_updating
3246: and p_prort_prtl_yr_cvg_rstrn_cd
3247: <> nvl(ben_pln_shd.g_old_rec.prort_prtl_yr_cvg_rstrn_cd,hr_api.g_varchar2)
3248: or not l_api_updating)
3249: and p_prort_prtl_yr_cvg_rstrn_cd is not null then
3250: --
3251: -- check if value of lookup falls within lookup type.
3249: and p_prort_prtl_yr_cvg_rstrn_cd is not null then
3250: --
3251: -- check if value of lookup falls within lookup type.
3252: --
3253: if hr_api.not_exists_in_hr_lookups
3254: (p_lookup_type => 'BEN_PRORT_PRTL_YR_CVG_RSTRN',
3255: p_lookup_code => p_prort_prtl_yr_cvg_rstrn_cd,
3256: p_effective_date => p_effective_date) then
3257: --
3267: end if;
3268: --
3269: if (l_api_updating
3270: and p_hc_svc_typ_cd
3271: <> nvl(ben_pln_shd.g_old_rec.hc_svc_typ_cd,hr_api.g_varchar2)
3272: or not l_api_updating)
3273: and p_hc_svc_typ_cd is not null then
3274: --
3275: -- check if value of lookup falls within lookup type.
3273: and p_hc_svc_typ_cd is not null then
3274: --
3275: -- check if value of lookup falls within lookup type.
3276: --
3277: if hr_api.not_exists_in_hr_lookups
3278: (p_lookup_type => 'BEN_HLTH_CARE_SVC_TYP',
3279: p_lookup_code => p_hc_svc_typ_cd,
3280: p_effective_date => p_effective_date) then
3281: --
3291: end if;
3292: --
3293: if (l_api_updating
3294: and p_pl_stat_cd
3295: <> nvl(ben_pln_shd.g_old_rec.pl_stat_cd,hr_api.g_varchar2)
3296: or not l_api_updating)
3297: and p_pl_stat_cd is not null then
3298: --
3299: -- check if value of lookup falls within lookup type.
3297: and p_pl_stat_cd is not null then
3298: --
3299: -- check if value of lookup falls within lookup type.
3300: --
3301: if hr_api.not_exists_in_hr_lookups
3302: (p_lookup_type => 'BEN_STAT',
3303: p_lookup_code => p_pl_stat_cd,
3304: p_effective_date => p_effective_date) then
3305: --
3315: end if;
3316: --
3317: if (l_api_updating
3318: and p_prmry_fndg_mthd_cd
3319: <> nvl(ben_pln_shd.g_old_rec.prmry_fndg_mthd_cd,hr_api.g_varchar2)
3320: or not l_api_updating)
3321: and p_prmry_fndg_mthd_cd is not null then
3322: --
3323: -- check if value of lookup falls within lookup type.
3321: and p_prmry_fndg_mthd_cd is not null then
3322: --
3323: -- check if value of lookup falls within lookup type.
3324: --
3325: if hr_api.not_exists_in_hr_lookups
3326: (p_lookup_type => 'BEN_PRMRY_FNDG_MTHD',
3327: p_lookup_code => p_prmry_fndg_mthd_cd,
3328: p_effective_date => p_effective_date) then
3329: --
3339: end if;
3340: --
3341: if (l_api_updating
3342: and p_rt_end_dt_cd
3343: <> nvl(ben_pln_shd.g_old_rec.rt_end_dt_cd,hr_api.g_varchar2)
3344: or not l_api_updating)
3345: and p_rt_end_dt_cd is not null then
3346: --
3347: -- check if value of lookup falls within lookup type.
3345: and p_rt_end_dt_cd is not null then
3346: --
3347: -- check if value of lookup falls within lookup type.
3348: --
3349: if hr_api.not_exists_in_hr_lookups
3350: (p_lookup_type => 'BEN_RT_END',
3351: p_lookup_code => p_rt_end_dt_cd,
3352: p_effective_date => p_effective_date) then
3353: --
3363: end if;
3364: --
3365: if (l_api_updating
3366: and p_rt_strt_dt_cd
3367: <> nvl(ben_pln_shd.g_old_rec.rt_strt_dt_cd,hr_api.g_varchar2)
3368: or not l_api_updating)
3369: and p_rt_strt_dt_cd is not null then
3370: --
3371: -- check if value of lookup falls within lookup type.
3369: and p_rt_strt_dt_cd is not null then
3370: --
3371: -- check if value of lookup falls within lookup type.
3372: --
3373: if hr_api.not_exists_in_hr_lookups
3374: (p_lookup_type => 'BEN_RT_STRT',
3375: p_lookup_code => p_rt_strt_dt_cd,
3376: p_effective_date => p_effective_date) then
3377: --
3387: end if;
3388: --
3389: if (l_api_updating
3390: and p_bnf_dsgn_cd
3391: <> nvl(ben_pln_shd.g_old_rec.bnf_dsgn_cd,hr_api.g_varchar2)
3392: or not l_api_updating)
3393: and p_bnf_dsgn_cd is not null then
3394: --
3395: -- check if value of lookup falls within lookup type.
3393: and p_bnf_dsgn_cd is not null then
3394: --
3395: -- check if value of lookup falls within lookup type.
3396: --
3397: if hr_api.not_exists_in_hr_lookups
3398: (p_lookup_type => 'BEN_BNF_DSGN',
3399: p_lookup_code => p_bnf_dsgn_cd,
3400: p_effective_date => p_effective_date) then
3401: --
3411: end if;
3412: --
3413: if (l_api_updating
3414: and p_per_cvrd_cd
3415: <> nvl(ben_pln_shd.g_old_rec.per_cvrd_cd,hr_api.g_varchar2)
3416: or not l_api_updating)
3417: and p_per_cvrd_cd is not null then
3418: --
3419: -- check if value of lookup falls within lookup type.
3417: and p_per_cvrd_cd is not null then
3418: --
3419: -- check if value of lookup falls within lookup type.
3420: --
3421: if hr_api.not_exists_in_hr_lookups
3422: (p_lookup_type => 'BEN_PER_CVRD',
3423: p_lookup_code => p_per_cvrd_cd,
3424: p_effective_date => p_effective_date) then
3425: --
3435: end if;
3436: --
3437: if (l_api_updating
3438: and p_mx_wtg_dt_to_use_cd
3439: <> nvl(ben_pln_shd.g_old_rec.mx_wtg_dt_to_use_cd,hr_api.g_varchar2)
3440: or not l_api_updating)
3441: and p_mx_wtg_dt_to_use_cd is not null then
3442: --
3443: -- check if value of lookup falls within lookup type.
3441: and p_mx_wtg_dt_to_use_cd is not null then
3442: --
3443: -- check if value of lookup falls within lookup type.
3444: --
3445: if hr_api.not_exists_in_hr_lookups
3446: (p_lookup_type => 'BEN_MX_WTG_DT_TO_USE',
3447: p_lookup_code => p_mx_wtg_dt_to_use_cd,
3448: p_effective_date => p_effective_date) then
3449: --
3459: end if;
3460: --
3461: if (l_api_updating
3462: and p_BNFT_OR_OPTION_RSTRCTN_cd
3463: <> nvl(ben_pln_shd.g_old_rec.BNFT_OR_OPTION_RSTRCTN_cd,hr_api.g_varchar2)
3464: or not l_api_updating)
3465: and p_BNFT_OR_OPTION_RSTRCTN_cd is not null then
3466: --
3467: -- check if value of lookup falls within lookup type.
3465: and p_BNFT_OR_OPTION_RSTRCTN_cd is not null then
3466: --
3467: -- check if value of lookup falls within lookup type.
3468: --
3469: if hr_api.not_exists_in_hr_lookups
3470: (p_lookup_type => 'BEN_BNFT_R_OPT_RSTRN',
3471: p_lookup_code => p_BNFT_OR_OPTION_RSTRCTN_cd,
3472: p_effective_date => p_effective_date) then
3473: --
3482: --
3483: end if;
3484: if (l_api_updating
3485: and p_CVG_INCR_R_DECR_ONLY_cd
3486: <> nvl(ben_pln_shd.g_old_rec.CVG_INCR_R_DECR_ONLY_cd,hr_api.g_varchar2)
3487: or not l_api_updating)
3488: and p_CVG_INCR_R_DECR_ONLY_cd is not null then
3489: --
3490: -- check if value of lookup falls within lookup type.
3488: and p_CVG_INCR_R_DECR_ONLY_cd is not null then
3489: --
3490: -- check if value of lookup falls within lookup type.
3491: --
3492: if hr_api.not_exists_in_hr_lookups
3493: (p_lookup_type => 'BEN_CVG_INCR_R_DECR_ONLY',
3494: p_lookup_code => p_CVG_INCR_R_DECR_ONLY_cd,
3495: p_effective_date => p_effective_date) then
3496: --
3505: --
3506: end if;
3507: if (l_api_updating
3508: and p_unsspnd_enrt_cd
3509: <> nvl(ben_pln_shd.g_old_rec.unsspnd_enrt_cd,hr_api.g_varchar2)
3510: or not l_api_updating)
3511: and p_unsspnd_enrt_cd is not null then
3512: --
3513: -- check if value of lookup falls within lookup type.
3511: and p_unsspnd_enrt_cd is not null then
3512: --
3513: -- check if value of lookup falls within lookup type.
3514: --
3515: if hr_api.not_exists_in_hr_lookups
3516: (p_lookup_type => 'BEN_UNSSPND_ENRT',
3517: p_lookup_code => p_unsspnd_enrt_cd,
3518: p_effective_date => p_effective_date) then
3519: --
3529: end if;
3530: --
3531: if (l_api_updating
3532: and p_imptd_incm_calc_cd
3533: <> nvl(ben_pln_shd.g_old_rec.imptd_incm_calc_cd,hr_api.g_varchar2)
3534: or not l_api_updating)
3535: and p_imptd_incm_calc_cd is not null then
3536: --
3537: -- check if value of lookup falls within lookup type.
3535: and p_imptd_incm_calc_cd is not null then
3536: --
3537: -- check if value of lookup falls within lookup type.
3538: --
3539: if hr_api.not_exists_in_hr_lookups
3540: (p_lookup_type => 'BEN_IMPTD_INCM_TYP',
3541: p_lookup_code => p_imptd_incm_calc_cd,
3542: p_effective_date => p_effective_date) then
3543: --
3636: p_effective_date => p_effective_date,
3637: p_object_version_number => p_object_version_number);
3638: --
3639: if (l_api_updating
3640: and nvl(p_auto_enrt_mthd_rl,hr_api.g_number)
3641: <> ben_pln_shd.g_old_rec.auto_enrt_mthd_rl
3642: or not l_api_updating)
3643: and p_auto_enrt_mthd_rl is not null then
3644: --
3667: --
3668: end if;
3669: --
3670: if (l_api_updating
3671: and nvl(p_mn_cvg_rl,hr_api.g_number)
3672: <> ben_pln_shd.g_old_rec.mn_cvg_rl
3673: or not l_api_updating)
3674: and p_mn_cvg_rl is not null then
3675: --
3698: --
3699: end if;
3700: --
3701: if (l_api_updating
3702: and nvl(p_mx_cvg_rl,hr_api.g_number)
3703: <> ben_pln_shd.g_old_rec.mx_cvg_rl
3704: or not l_api_updating)
3705: and p_mx_cvg_rl is not null then
3706: --
3729: --
3730: end if;
3731: --
3732: if (l_api_updating
3733: and nvl(p_mx_wtg_perd_rl,hr_api.g_number)
3734: <> ben_pln_shd.g_old_rec.mx_wtg_perd_rl
3735: or not l_api_updating)
3736: and p_mx_wtg_perd_rl is not null then
3737: --
3760: --
3761: end if;
3762: --
3763: if (l_api_updating
3764: and nvl(p_rqd_perd_enrt_nenrt_rl,hr_api.g_number)
3765: <> ben_pln_shd.g_old_rec.rqd_perd_enrt_nenrt_rl
3766: or not l_api_updating)
3767: and p_rqd_perd_enrt_nenrt_rl is not null then
3768: --
3791: --
3792: end if;
3793: --
3794: if (l_api_updating
3795: and nvl(p_nip_dflt_enrt_det_rl,hr_api.g_number)
3796: <> ben_pln_shd.g_old_rec.nip_dflt_enrt_det_rl
3797: or not l_api_updating)
3798: and p_nip_dflt_enrt_det_rl is not null then
3799: --
3822: --
3823: end if;
3824: --
3825: if (l_api_updating
3826: and nvl(p_dpnt_cvg_end_dt_rl,hr_api.g_number)
3827: <> ben_pln_shd.g_old_rec.dpnt_cvg_end_dt_rl
3828: or not l_api_updating)
3829: and p_dpnt_cvg_end_dt_rl is not null then
3830: --
3853: --
3854: end if;
3855: --
3856: if (l_api_updating
3857: and nvl(p_dpnt_cvg_strt_dt_rl,hr_api.g_number)
3858: <> ben_pln_shd.g_old_rec.dpnt_cvg_strt_dt_rl
3859: or not l_api_updating)
3860: and p_dpnt_cvg_strt_dt_rl is not null then
3861: --
3884: --
3885: end if;
3886: --
3887: if (l_api_updating
3888: and nvl(p_dflt_to_asn_pndg_ctfn_rl,hr_api.g_number)
3889: <> ben_pln_shd.g_old_rec.dflt_to_asn_pndg_ctfn_rl
3890: or not l_api_updating)
3891: and p_dflt_to_asn_pndg_ctfn_rl is not null then
3892: --
3915: --
3916: end if;
3917: --
3918: if (l_api_updating
3919: and nvl(p_postelcn_edit_rl,hr_api.g_number)
3920: <> ben_pln_shd.g_old_rec.postelcn_edit_rl
3921: or not l_api_updating)
3922: and p_postelcn_edit_rl is not null then
3923: --
3946: --
3947: end if;
3948: --
3949: if (l_api_updating
3950: and nvl(p_prort_prtl_yr_cvg_rstrn_rl,hr_api.g_number)
3951: <> ben_pln_shd.g_old_rec.prort_prtl_yr_cvg_rstrn_rl
3952: or not l_api_updating)
3953: and p_prort_prtl_yr_cvg_rstrn_rl is not null then
3954: --
3977: --
3978: end if;
3979: --
3980: if (l_api_updating
3981: and nvl(p_rt_end_dt_rl,hr_api.g_number)
3982: <> ben_pln_shd.g_old_rec.rt_end_dt_rl
3983: or not l_api_updating)
3984: and p_rt_end_dt_rl is not null then
3985: --
4008: --
4009: end if;
4010: --
4011: if (l_api_updating
4012: and nvl(p_rt_strt_dt_rl,hr_api.g_number)
4013: <> ben_pln_shd.g_old_rec.rt_strt_dt_rl
4014: or not l_api_updating)
4015: and p_rt_strt_dt_rl is not null then
4016: --
4039: --
4040: end if;
4041: --
4042: if (l_api_updating
4043: and nvl(p_mx_wtg_dt_to_use_rl,hr_api.g_number)
4044: <> ben_pln_shd.g_old_rec.mx_wtg_dt_to_use_rl
4045: or not l_api_updating)
4046: and p_mx_wtg_dt_to_use_rl is not null then
4047: --
4070: --
4071: end if;
4072: --
4073: if (l_api_updating
4074: and nvl(p_enrt_cvg_strt_dt_rl,hr_api.g_number)
4075: <> ben_pln_shd.g_old_rec.enrt_cvg_strt_dt_rl
4076: or not l_api_updating)
4077: and p_enrt_cvg_strt_dt_rl is not null then
4078: --
4101: --
4102: end if;
4103: --
4104: if (l_api_updating
4105: and nvl(p_enrt_cvg_end_dt_rl,hr_api.g_number)
4106: <> ben_pln_shd.g_old_rec.enrt_cvg_end_dt_rl
4107: or not l_api_updating)
4108: and p_enrt_cvg_end_dt_rl is not null then
4109: --
4132: --
4133: end if;
4134: --
4135: if (l_api_updating
4136: and nvl(p_enrt_rl,hr_api.g_number)
4137: <> ben_pln_shd.g_old_rec.enrt_rl
4138: or not l_api_updating)
4139: and p_enrt_rl is not null then
4140: --
4753: --
4754: -- {End Of Comments}
4755: -- ----------------------------------------------------------------------------
4756: Procedure dt_update_validate
4757: (p_auto_enrt_mthd_rl in number default hr_api.g_number,
4758: p_mn_cvg_rl in number default hr_api.g_number,
4759: p_mx_cvg_rl in number default hr_api.g_number,
4760: p_mx_wtg_perd_rl in number default hr_api.g_number,
4761: p_nip_dflt_enrt_det_rl in number default hr_api.g_number,
4754: -- {End Of Comments}
4755: -- ----------------------------------------------------------------------------
4756: Procedure dt_update_validate
4757: (p_auto_enrt_mthd_rl in number default hr_api.g_number,
4758: p_mn_cvg_rl in number default hr_api.g_number,
4759: p_mx_cvg_rl in number default hr_api.g_number,
4760: p_mx_wtg_perd_rl in number default hr_api.g_number,
4761: p_nip_dflt_enrt_det_rl in number default hr_api.g_number,
4762: p_prort_prtl_yr_cvg_rstrn_rl in number default hr_api.g_number,
4755: -- ----------------------------------------------------------------------------
4756: Procedure dt_update_validate
4757: (p_auto_enrt_mthd_rl in number default hr_api.g_number,
4758: p_mn_cvg_rl in number default hr_api.g_number,
4759: p_mx_cvg_rl in number default hr_api.g_number,
4760: p_mx_wtg_perd_rl in number default hr_api.g_number,
4761: p_nip_dflt_enrt_det_rl in number default hr_api.g_number,
4762: p_prort_prtl_yr_cvg_rstrn_rl in number default hr_api.g_number,
4763: p_pl_typ_id in number default hr_api.g_number,
4756: Procedure dt_update_validate
4757: (p_auto_enrt_mthd_rl in number default hr_api.g_number,
4758: p_mn_cvg_rl in number default hr_api.g_number,
4759: p_mx_cvg_rl in number default hr_api.g_number,
4760: p_mx_wtg_perd_rl in number default hr_api.g_number,
4761: p_nip_dflt_enrt_det_rl in number default hr_api.g_number,
4762: p_prort_prtl_yr_cvg_rstrn_rl in number default hr_api.g_number,
4763: p_pl_typ_id in number default hr_api.g_number,
4764: p_actl_prem_id in number default hr_api.g_number,
4757: (p_auto_enrt_mthd_rl in number default hr_api.g_number,
4758: p_mn_cvg_rl in number default hr_api.g_number,
4759: p_mx_cvg_rl in number default hr_api.g_number,
4760: p_mx_wtg_perd_rl in number default hr_api.g_number,
4761: p_nip_dflt_enrt_det_rl in number default hr_api.g_number,
4762: p_prort_prtl_yr_cvg_rstrn_rl in number default hr_api.g_number,
4763: p_pl_typ_id in number default hr_api.g_number,
4764: p_actl_prem_id in number default hr_api.g_number,
4765: p_mx_wtg_dt_to_use_rl in number default hr_api.g_number,
4758: p_mn_cvg_rl in number default hr_api.g_number,
4759: p_mx_cvg_rl in number default hr_api.g_number,
4760: p_mx_wtg_perd_rl in number default hr_api.g_number,
4761: p_nip_dflt_enrt_det_rl in number default hr_api.g_number,
4762: p_prort_prtl_yr_cvg_rstrn_rl in number default hr_api.g_number,
4763: p_pl_typ_id in number default hr_api.g_number,
4764: p_actl_prem_id in number default hr_api.g_number,
4765: p_mx_wtg_dt_to_use_rl in number default hr_api.g_number,
4766: p_dflt_to_asn_pndg_ctfn_rl in number default hr_api.g_number,
4759: p_mx_cvg_rl in number default hr_api.g_number,
4760: p_mx_wtg_perd_rl in number default hr_api.g_number,
4761: p_nip_dflt_enrt_det_rl in number default hr_api.g_number,
4762: p_prort_prtl_yr_cvg_rstrn_rl in number default hr_api.g_number,
4763: p_pl_typ_id in number default hr_api.g_number,
4764: p_actl_prem_id in number default hr_api.g_number,
4765: p_mx_wtg_dt_to_use_rl in number default hr_api.g_number,
4766: p_dflt_to_asn_pndg_ctfn_rl in number default hr_api.g_number,
4767: p_dpnt_cvg_end_dt_rl in number default hr_api.g_number,
4760: p_mx_wtg_perd_rl in number default hr_api.g_number,
4761: p_nip_dflt_enrt_det_rl in number default hr_api.g_number,
4762: p_prort_prtl_yr_cvg_rstrn_rl in number default hr_api.g_number,
4763: p_pl_typ_id in number default hr_api.g_number,
4764: p_actl_prem_id in number default hr_api.g_number,
4765: p_mx_wtg_dt_to_use_rl in number default hr_api.g_number,
4766: p_dflt_to_asn_pndg_ctfn_rl in number default hr_api.g_number,
4767: p_dpnt_cvg_end_dt_rl in number default hr_api.g_number,
4768: p_dpnt_cvg_strt_dt_rl in number default hr_api.g_number,
4761: p_nip_dflt_enrt_det_rl in number default hr_api.g_number,
4762: p_prort_prtl_yr_cvg_rstrn_rl in number default hr_api.g_number,
4763: p_pl_typ_id in number default hr_api.g_number,
4764: p_actl_prem_id in number default hr_api.g_number,
4765: p_mx_wtg_dt_to_use_rl in number default hr_api.g_number,
4766: p_dflt_to_asn_pndg_ctfn_rl in number default hr_api.g_number,
4767: p_dpnt_cvg_end_dt_rl in number default hr_api.g_number,
4768: p_dpnt_cvg_strt_dt_rl in number default hr_api.g_number,
4769: p_enrt_cvg_end_dt_rl in number default hr_api.g_number,
4762: p_prort_prtl_yr_cvg_rstrn_rl in number default hr_api.g_number,
4763: p_pl_typ_id in number default hr_api.g_number,
4764: p_actl_prem_id in number default hr_api.g_number,
4765: p_mx_wtg_dt_to_use_rl in number default hr_api.g_number,
4766: p_dflt_to_asn_pndg_ctfn_rl in number default hr_api.g_number,
4767: p_dpnt_cvg_end_dt_rl in number default hr_api.g_number,
4768: p_dpnt_cvg_strt_dt_rl in number default hr_api.g_number,
4769: p_enrt_cvg_end_dt_rl in number default hr_api.g_number,
4770: p_enrt_cvg_strt_dt_rl in number default hr_api.g_number,
4763: p_pl_typ_id in number default hr_api.g_number,
4764: p_actl_prem_id in number default hr_api.g_number,
4765: p_mx_wtg_dt_to_use_rl in number default hr_api.g_number,
4766: p_dflt_to_asn_pndg_ctfn_rl in number default hr_api.g_number,
4767: p_dpnt_cvg_end_dt_rl in number default hr_api.g_number,
4768: p_dpnt_cvg_strt_dt_rl in number default hr_api.g_number,
4769: p_enrt_cvg_end_dt_rl in number default hr_api.g_number,
4770: p_enrt_cvg_strt_dt_rl in number default hr_api.g_number,
4771: p_postelcn_edit_rl in number default hr_api.g_number,
4764: p_actl_prem_id in number default hr_api.g_number,
4765: p_mx_wtg_dt_to_use_rl in number default hr_api.g_number,
4766: p_dflt_to_asn_pndg_ctfn_rl in number default hr_api.g_number,
4767: p_dpnt_cvg_end_dt_rl in number default hr_api.g_number,
4768: p_dpnt_cvg_strt_dt_rl in number default hr_api.g_number,
4769: p_enrt_cvg_end_dt_rl in number default hr_api.g_number,
4770: p_enrt_cvg_strt_dt_rl in number default hr_api.g_number,
4771: p_postelcn_edit_rl in number default hr_api.g_number,
4772: p_rt_end_dt_rl in number default hr_api.g_number,
4765: p_mx_wtg_dt_to_use_rl in number default hr_api.g_number,
4766: p_dflt_to_asn_pndg_ctfn_rl in number default hr_api.g_number,
4767: p_dpnt_cvg_end_dt_rl in number default hr_api.g_number,
4768: p_dpnt_cvg_strt_dt_rl in number default hr_api.g_number,
4769: p_enrt_cvg_end_dt_rl in number default hr_api.g_number,
4770: p_enrt_cvg_strt_dt_rl in number default hr_api.g_number,
4771: p_postelcn_edit_rl in number default hr_api.g_number,
4772: p_rt_end_dt_rl in number default hr_api.g_number,
4773: p_rt_strt_dt_rl in number default hr_api.g_number,
4766: p_dflt_to_asn_pndg_ctfn_rl in number default hr_api.g_number,
4767: p_dpnt_cvg_end_dt_rl in number default hr_api.g_number,
4768: p_dpnt_cvg_strt_dt_rl in number default hr_api.g_number,
4769: p_enrt_cvg_end_dt_rl in number default hr_api.g_number,
4770: p_enrt_cvg_strt_dt_rl in number default hr_api.g_number,
4771: p_postelcn_edit_rl in number default hr_api.g_number,
4772: p_rt_end_dt_rl in number default hr_api.g_number,
4773: p_rt_strt_dt_rl in number default hr_api.g_number,
4774: p_ENRT_RL in NUMBER default hr_api.g_NUMBER,
4767: p_dpnt_cvg_end_dt_rl in number default hr_api.g_number,
4768: p_dpnt_cvg_strt_dt_rl in number default hr_api.g_number,
4769: p_enrt_cvg_end_dt_rl in number default hr_api.g_number,
4770: p_enrt_cvg_strt_dt_rl in number default hr_api.g_number,
4771: p_postelcn_edit_rl in number default hr_api.g_number,
4772: p_rt_end_dt_rl in number default hr_api.g_number,
4773: p_rt_strt_dt_rl in number default hr_api.g_number,
4774: p_ENRT_RL in NUMBER default hr_api.g_NUMBER,
4775: p_rqd_perd_enrt_nenrt_rl in NUMBER default hr_api.g_NUMBER,
4768: p_dpnt_cvg_strt_dt_rl in number default hr_api.g_number,
4769: p_enrt_cvg_end_dt_rl in number default hr_api.g_number,
4770: p_enrt_cvg_strt_dt_rl in number default hr_api.g_number,
4771: p_postelcn_edit_rl in number default hr_api.g_number,
4772: p_rt_end_dt_rl in number default hr_api.g_number,
4773: p_rt_strt_dt_rl in number default hr_api.g_number,
4774: p_ENRT_RL in NUMBER default hr_api.g_NUMBER,
4775: p_rqd_perd_enrt_nenrt_rl in NUMBER default hr_api.g_NUMBER,
4776: p_bnft_prvdr_pool_id in number default hr_api.g_NUMBER,
4769: p_enrt_cvg_end_dt_rl in number default hr_api.g_number,
4770: p_enrt_cvg_strt_dt_rl in number default hr_api.g_number,
4771: p_postelcn_edit_rl in number default hr_api.g_number,
4772: p_rt_end_dt_rl in number default hr_api.g_number,
4773: p_rt_strt_dt_rl in number default hr_api.g_number,
4774: p_ENRT_RL in NUMBER default hr_api.g_NUMBER,
4775: p_rqd_perd_enrt_nenrt_rl in NUMBER default hr_api.g_NUMBER,
4776: p_bnft_prvdr_pool_id in number default hr_api.g_NUMBER,
4777: p_datetrack_mode in varchar2,
4770: p_enrt_cvg_strt_dt_rl in number default hr_api.g_number,
4771: p_postelcn_edit_rl in number default hr_api.g_number,
4772: p_rt_end_dt_rl in number default hr_api.g_number,
4773: p_rt_strt_dt_rl in number default hr_api.g_number,
4774: p_ENRT_RL in NUMBER default hr_api.g_NUMBER,
4775: p_rqd_perd_enrt_nenrt_rl in NUMBER default hr_api.g_NUMBER,
4776: p_bnft_prvdr_pool_id in number default hr_api.g_NUMBER,
4777: p_datetrack_mode in varchar2,
4778: p_validation_start_date in date,
4771: p_postelcn_edit_rl in number default hr_api.g_number,
4772: p_rt_end_dt_rl in number default hr_api.g_number,
4773: p_rt_strt_dt_rl in number default hr_api.g_number,
4774: p_ENRT_RL in NUMBER default hr_api.g_NUMBER,
4775: p_rqd_perd_enrt_nenrt_rl in NUMBER default hr_api.g_NUMBER,
4776: p_bnft_prvdr_pool_id in number default hr_api.g_NUMBER,
4777: p_datetrack_mode in varchar2,
4778: p_validation_start_date in date,
4779: p_validation_end_date in date) Is
4772: p_rt_end_dt_rl in number default hr_api.g_number,
4773: p_rt_strt_dt_rl in number default hr_api.g_number,
4774: p_ENRT_RL in NUMBER default hr_api.g_NUMBER,
4775: p_rqd_perd_enrt_nenrt_rl in NUMBER default hr_api.g_NUMBER,
4776: p_bnft_prvdr_pool_id in number default hr_api.g_NUMBER,
4777: p_datetrack_mode in varchar2,
4778: p_validation_start_date in date,
4779: p_validation_end_date in date) Is
4780: --
4786: hr_utility.set_location('Entering:'||l_proc, 5);
4787: --
4788: -- Ensure that the p_datetrack_mode argument is not null
4789: --
4790: hr_api.mandatory_arg_error
4791: (p_api_name => l_proc,
4792: p_argument => 'datetrack_mode',
4793: p_argument_value => p_datetrack_mode);
4794: --
4798: --
4799: --
4800: -- Ensure the arguments are not null
4801: --
4802: hr_api.mandatory_arg_error
4803: (p_api_name => l_proc,
4804: p_argument => 'validation_start_date',
4805: p_argument_value => p_validation_start_date);
4806: --
4803: (p_api_name => l_proc,
4804: p_argument => 'validation_start_date',
4805: p_argument_value => p_validation_start_date);
4806: --
4807: hr_api.mandatory_arg_error
4808: (p_api_name => l_proc,
4809: p_argument => 'validation_end_date',
4810: p_argument_value => p_validation_end_date);
4811: --
4808: (p_api_name => l_proc,
4809: p_argument => 'validation_end_date',
4810: p_argument_value => p_validation_end_date);
4811: --
4812: If ((nvl(p_auto_enrt_mthd_rl, hr_api.g_number) <> hr_api.g_number) and
4813: NOT (dt_api.check_min_max_dates
4814: (p_base_table_name => 'ff_formulas_f',
4815: p_base_key_column => 'formula_id',
4816: p_base_key_value => p_auto_enrt_mthd_rl,
4818: p_to_date => p_validation_end_date))) Then
4819: l_table_name := 'ff_formulas_f';
4820: Raise l_integrity_error;
4821: End If;
4822: If ((nvl(p_mn_cvg_rl, hr_api.g_number) <> hr_api.g_number) and
4823: NOT (dt_api.check_min_max_dates
4824: (p_base_table_name => 'ff_formulas_f',
4825: p_base_key_column => 'formula_id',
4826: p_base_key_value => p_mn_cvg_rl,
4828: p_to_date => p_validation_end_date))) Then
4829: l_table_name := 'ff_formulas_f';
4830: Raise l_integrity_error;
4831: End If;
4832: If ((nvl(p_mx_cvg_rl, hr_api.g_number) <> hr_api.g_number) and
4833: NOT (dt_api.check_min_max_dates
4834: (p_base_table_name => 'ff_formulas_f',
4835: p_base_key_column => 'formula_id',
4836: p_base_key_value => p_mx_cvg_rl,
4838: p_to_date => p_validation_end_date))) Then
4839: l_table_name := 'ff_formulas_f';
4840: Raise l_integrity_error;
4841: End If;
4842: If ((nvl(p_bnft_prvdr_pool_id, hr_api.g_number) <> hr_api.g_number) and
4843: NOT (dt_api.check_min_max_dates
4844: (p_base_table_name => 'ben_bnft_prvdr_pool_f',
4845: p_base_key_column => 'bnft_prvdr_pool_id',
4846: p_base_key_value => p_bnft_prvdr_pool_id,
4848: p_to_date => p_validation_end_date))) Then
4849: l_table_name := 'ff_formulas_f';
4850: Raise l_integrity_error;
4851: End If;
4852: If ((nvl(p_enrt_rl, hr_api.g_number) <> hr_api.g_number) and
4853: NOT (dt_api.check_min_max_dates
4854: (p_base_table_name => 'ff_formulas_f',
4855: p_base_key_column => 'formula_id',
4856: p_base_key_value => p_enrt_rl,
4858: p_to_date => p_validation_end_date))) Then
4859: l_table_name := 'ff_formulas_f';
4860: Raise l_integrity_error;
4861: End If;
4862: If ((nvl(p_rqd_perd_enrt_nenrt_rl, hr_api.g_number) <> hr_api.g_number) and
4863: NOT (dt_api.check_min_max_dates
4864: (p_base_table_name => 'ff_formulas_f',
4865: p_base_key_column => 'formula_id',
4866: p_base_key_value => p_rqd_perd_enrt_nenrt_rl,
4868: p_to_date => p_validation_end_date))) Then
4869: l_table_name := 'ff_formulas_f';
4870: Raise l_integrity_error;
4871: End If;
4872: If ((nvl(p_mx_wtg_perd_rl, hr_api.g_number) <> hr_api.g_number) and
4873: NOT (dt_api.check_min_max_dates
4874: (p_base_table_name => 'ff_formulas_f',
4875: p_base_key_column => 'formula_id',
4876: p_base_key_value => p_mx_wtg_perd_rl,
4878: p_to_date => p_validation_end_date))) Then
4879: l_table_name := 'ff_formulas_f';
4880: Raise l_integrity_error;
4881: End If;
4882: If ((nvl(p_nip_dflt_enrt_det_rl, hr_api.g_number) <> hr_api.g_number) and
4883: NOT (dt_api.check_min_max_dates
4884: (p_base_table_name => 'ff_formulas_f',
4885: p_base_key_column => 'formula_id',
4886: p_base_key_value => p_nip_dflt_enrt_det_rl,
4888: p_to_date => p_validation_end_date))) Then
4889: l_table_name := 'ff_formulas_f';
4890: Raise l_integrity_error;
4891: End If;
4892: If ((nvl(p_dpnt_cvg_end_dt_rl, hr_api.g_number) <> hr_api.g_number) and
4893: NOT (dt_api.check_min_max_dates
4894: (p_base_table_name => 'ff_formulas_f',
4895: p_base_key_column => 'formula_id',
4896: p_base_key_value => p_dpnt_cvg_end_dt_rl,
4898: p_to_date => p_validation_end_date))) Then
4899: l_table_name := 'ff_formulas_f';
4900: Raise l_integrity_error;
4901: End If;
4902: If ((nvl(p_dpnt_cvg_strt_dt_rl, hr_api.g_number) <> hr_api.g_number) and
4903: NOT (dt_api.check_min_max_dates
4904: (p_base_table_name => 'ff_formulas_f',
4905: p_base_key_column => 'formula_id',
4906: p_base_key_value => p_dpnt_cvg_strt_dt_rl,
4908: p_to_date => p_validation_end_date))) Then
4909: l_table_name := 'ff_formulas_f';
4910: Raise l_integrity_error;
4911: End If;
4912: If ((nvl(p_prort_prtl_yr_cvg_rstrn_rl, hr_api.g_number) <> hr_api.g_number) and
4913: NOT (dt_api.check_min_max_dates
4914: (p_base_table_name => 'ff_formulas_f',
4915: p_base_key_column => 'formula_id',
4916: p_base_key_value => p_prort_prtl_yr_cvg_rstrn_rl,
4918: p_to_date => p_validation_end_date))) Then
4919: l_table_name := 'ff_formulas_f';
4920: Raise l_integrity_error;
4921: End If;
4922: If ((nvl(p_pl_typ_id, hr_api.g_number) <> hr_api.g_number) and
4923: NOT (dt_api.check_min_max_dates
4924: (p_base_table_name => 'ben_pl_typ_f',
4925: p_base_key_column => 'pl_typ_id',
4926: p_base_key_value => p_pl_typ_id,
4932: --
4933:
4934: -- Commented out because actl_prem_f is parent of plan!!!!!!!!!
4935: --
4936: -- If ((nvl(p_actl_prem_id, hr_api.g_number) <> hr_api.g_number) and
4937: -- NOT (dt_api.check_min_max_dates
4938: -- (p_base_table_name => 'ben_actl_prem_f',
4939: -- p_base_key_column => 'actl_prem_id',
4940: -- p_base_key_value => p_actl_prem_id,
4943: -- l_table_name := 'ben_actl_prem_f';
4944: -- Raise l_integrity_error;
4945: -- End If;
4946: --
4947: If ((nvl(p_dflt_to_asn_pndg_ctfn_rl, hr_api.g_number) <> hr_api.g_number) and
4948: NOT (dt_api.check_min_max_dates
4949: (p_base_table_name => 'ff_formulas_f',
4950: p_base_key_column => 'formula_id',
4951: p_base_key_value => p_dflt_to_asn_pndg_ctfn_rl,
4954: l_table_name := 'ff_formulas_f';
4955: Raise l_integrity_error;
4956: End If;
4957: --
4958: If ((nvl(p_dpnt_cvg_end_dt_rl, hr_api.g_number) <> hr_api.g_number) and
4959: NOT (dt_api.check_min_max_dates
4960: (p_base_table_name => 'ff_formulas_f',
4961: p_base_key_column => 'formula_id',
4962: p_base_key_value => p_dpnt_cvg_end_dt_rl,
4965: l_table_name := 'ff_formulas_f';
4966: Raise l_integrity_error;
4967: End If;
4968: --
4969: If ((nvl(p_dpnt_cvg_strt_dt_rl, hr_api.g_number) <> hr_api.g_number) and
4970: NOT (dt_api.check_min_max_dates
4971: (p_base_table_name => 'ff_formulas_f',
4972: p_base_key_column => 'formula_id',
4973: p_base_key_value => p_dpnt_cvg_strt_dt_rl,
4976: l_table_name := 'ff_formulas_f';
4977: Raise l_integrity_error;
4978: End If;
4979: --
4980: If ((nvl(p_enrt_cvg_end_dt_rl, hr_api.g_number) <> hr_api.g_number) and
4981: NOT (dt_api.check_min_max_dates
4982: (p_base_table_name => 'ff_formulas_f',
4983: p_base_key_column => 'formula_id',
4984: p_base_key_value => p_enrt_cvg_end_dt_rl,
4987: l_table_name := 'ff_formulas_f';
4988: Raise l_integrity_error;
4989: End If;
4990: --
4991: If ((nvl(p_enrt_cvg_strt_dt_rl, hr_api.g_number) <> hr_api.g_number) and
4992: NOT (dt_api.check_min_max_dates
4993: (p_base_table_name => 'ff_formulas_f',
4994: p_base_key_column => 'formula_id',
4995: p_base_key_value => p_enrt_cvg_strt_dt_rl,
4998: l_table_name := 'ff_formulas_f';
4999: Raise l_integrity_error;
5000: End If;
5001: --
5002: If ((nvl(p_postelcn_edit_rl, hr_api.g_number) <> hr_api.g_number) and
5003: NOT (dt_api.check_min_max_dates
5004: (p_base_table_name => 'ff_formulas_f',
5005: p_base_key_column => 'formula_id',
5006: p_base_key_value => p_postelcn_edit_rl,
5009: l_table_name := 'ff_formulas_f';
5010: Raise l_integrity_error;
5011: End If;
5012: --
5013: If ((nvl(p_rt_end_dt_rl, hr_api.g_number) <> hr_api.g_number) and
5014: NOT (dt_api.check_min_max_dates
5015: (p_base_table_name => 'ff_formulas_f',
5016: p_base_key_column => 'formula_id',
5017: p_base_key_value => p_rt_end_dt_rl,
5020: l_table_name := 'ff_formulas_f';
5021: Raise l_integrity_error;
5022: End If;
5023: --
5024: If ((nvl(p_rt_strt_dt_rl, hr_api.g_number) <> hr_api.g_number) and
5025: NOT (dt_api.check_min_max_dates
5026: (p_base_table_name => 'ff_formulas_f',
5027: p_base_key_column => 'formula_id',
5028: p_base_key_value => p_rt_strt_dt_rl,
5116: hr_utility.set_location('Entering:'||l_proc, 5);
5117: --
5118: -- Ensure that the p_datetrack_mode argument is not null
5119: --
5120: hr_api.mandatory_arg_error
5121: (p_api_name => l_proc,
5122: p_argument => 'datetrack_mode',
5123: p_argument_value => p_datetrack_mode);
5124: --
5130: --
5131: --
5132: -- Ensure the arguments are not null
5133: --
5134: hr_api.mandatory_arg_error
5135: (p_api_name => l_proc,
5136: p_argument => 'validation_start_date',
5137: p_argument_value => p_validation_start_date);
5138: --
5135: (p_api_name => l_proc,
5136: p_argument => 'validation_start_date',
5137: p_argument_value => p_validation_start_date);
5138: --
5139: hr_api.mandatory_arg_error
5140: (p_api_name => l_proc,
5141: p_argument => 'validation_end_date',
5142: p_argument_value => p_validation_end_date);
5143: --
5140: (p_api_name => l_proc,
5141: p_argument => 'validation_end_date',
5142: p_argument_value => p_validation_end_date);
5143: --
5144: hr_api.mandatory_arg_error
5145: (p_api_name => l_proc,
5146: p_argument => 'pl_id',
5147: p_argument_value => p_pl_id);
5148: --
5471: --
5472: -- Call all supporting business operations
5473: --
5474: if p_rec.business_group_id is not null and p_rec.legislation_code is null then
5475: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
5476: end if;
5477: --
5478: chk_pl_id
5479: (p_pl_id => p_rec.pl_id,
5765: --
5766: -- Call all supporting business operations
5767: --
5768: if p_rec.business_group_id is not null and p_rec.legislation_code is null then
5769: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
5770: end if;
5771: --
5772: chk_pl_id
5773: (p_pl_id => p_rec.pl_id,
6195: hr_utility.set_location('Entering:'|| l_proc, 10);
6196: --
6197: -- Ensure that all the mandatory parameter are not null
6198: --
6199: hr_api.mandatory_arg_error(p_api_name => l_proc,
6200: p_argument => 'pl_id',
6201: p_argument_value => p_pl_id);
6202: --
6203: open csr_leg_code;