eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_PGM_BUS dependencies on HR_API

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

50: p_pgm_id => p_pgm_id,
51: p_object_version_number => p_object_version_number);
52: --
53: if (l_api_updating
54: and nvl(p_pgm_id,hr_api.g_number)
55: <> ben_pgm_shd.g_old_rec.pgm_id) then
56: --
57: -- raise error as PK has changed
58: --

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

136: p_effective_date => p_effective_date,
137: p_object_version_number => p_object_version_number);
138: --
139: if (l_api_updating
140: and nvl(p_auto_enrt_mthd_rl,hr_api.g_number)
141: <> ben_pgm_shd.g_old_rec.auto_enrt_mthd_rl
142: or not l_api_updating)
143: and p_auto_enrt_mthd_rl is not null then
144: --

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

281: p_effective_date => p_effective_date,
282: p_object_version_number => p_object_version_number);
283: --
284: if (l_api_updating
285: and nvl(p_enrt_rl,hr_api.g_number)
286: <> ben_pgm_shd.g_old_rec.enrt_rl
287: or not l_api_updating)
288: and p_enrt_rl is not null then
289: --

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

374: p_effective_date => p_effective_date,
375: p_object_version_number => p_object_version_number);
376: --
377: if (l_api_updating
378: and nvl(p_enrt_cvg_strt_dt_rl,hr_api.g_number)
379: <> ben_pgm_shd.g_old_rec.enrt_cvg_strt_dt_rl
380: or not l_api_updating)
381: and p_enrt_cvg_strt_dt_rl is not null then
382: --

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

467: p_effective_date => p_effective_date,
468: p_object_version_number => p_object_version_number);
469: --
470: if (l_api_updating
471: and nvl(p_enrt_cvg_end_dt_rl,hr_api.g_number)
472: <> ben_pgm_shd.g_old_rec.enrt_cvg_end_dt_rl
473: or not l_api_updating)
474: and p_enrt_cvg_end_dt_rl is not null then
475: --

Line 524: <> nvl(ben_pgm_shd.g_old_rec.vrfy_fmly_mmbr_cd,hr_api.g_varchar2)

520: p_object_version_number => p_object_version_number);
521: --
522: if (l_api_updating
523: and p_vrfy_fmly_mmbr_cd
524: <> nvl(ben_pgm_shd.g_old_rec.vrfy_fmly_mmbr_cd,hr_api.g_varchar2)
525: or not l_api_updating)
526: and p_vrfy_fmly_mmbr_cd is not null
527: then
528: --

Line 532: if hr_api.not_exists_in_hr_lookups

528: --
529: -- check if value of lookup falls within lookup type.
530: --
531:
532: if hr_api.not_exists_in_hr_lookups
533: (p_lookup_type => 'BEN_FMLY_MMBR',
534: p_lookup_code => p_vrfy_fmly_mmbr_cd,
535: p_effective_date => p_effective_date) then
536: --

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

574: p_pgm_id => p_pgm_id,
575: p_object_version_number => p_object_version_number);
576: --
577: if (l_api_updating
578: and nvl(p_vrfy_fmly_mmbr_rl,hr_api.g_number)
579: <> ben_pgm_shd.g_old_rec.vrfy_fmly_mmbr_rl
580: or not l_api_updating)
581: and p_vrfy_fmly_mmbr_rl is not null then
582: --

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

667: p_effective_date => p_effective_date,
668: p_object_version_number => p_object_version_number);
669: --
670: if (l_api_updating
671: and nvl(p_dpnt_cvg_strt_dt_rl,hr_api.g_number)
672: <> ben_pgm_shd.g_old_rec.dpnt_cvg_strt_dt_rl
673: or not l_api_updating)
674: and p_dpnt_cvg_strt_dt_rl is not null then
675: --

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

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

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

853: p_effective_date => p_effective_date,
854: p_object_version_number => p_object_version_number);
855: --
856: if (l_api_updating
857: and nvl(p_rt_strt_dt_rl,hr_api.g_number)
858: <> ben_pgm_shd.g_old_rec.rt_strt_dt_rl
859: or not l_api_updating)
860: and p_rt_strt_dt_rl is not null then
861: --

Line 952: and nvl(p_dpnt_cvg_end_dt_rl,hr_api.g_number)

948: p_effective_date => p_effective_date,
949: p_object_version_number => p_object_version_number);
950: --
951: if (l_api_updating
952: and nvl(p_dpnt_cvg_end_dt_rl,hr_api.g_number)
953: <> ben_pgm_shd.g_old_rec.dpnt_cvg_end_dt_rl
954: or not l_api_updating)
955: and p_dpnt_cvg_end_dt_rl is not null then
956: --

Line 1044: and nvl(p_prtn_end_dt_rl,hr_api.g_number)

1040: p_effective_date => p_effective_date,
1041: p_object_version_number => p_object_version_number);
1042: --
1043: if (l_api_updating
1044: and nvl(p_prtn_end_dt_rl,hr_api.g_number)
1045: <> ben_pgm_shd.g_old_rec.prtn_end_dt_rl
1046: or not l_api_updating)
1047: and p_prtn_end_dt_rl is not null then
1048: --

Line 1138: and nvl(p_prtn_strt_dt_rl,hr_api.g_number)

1134: p_effective_date => p_effective_date,
1135: p_object_version_number => p_object_version_number);
1136: --
1137: if (l_api_updating
1138: and nvl(p_prtn_strt_dt_rl,hr_api.g_number)
1139: <> ben_pgm_shd.g_old_rec.prtn_strt_dt_rl
1140: or not l_api_updating)
1141: and p_prtn_strt_dt_rl is not null then
1142: --

Line 1218: <> nvl(ben_pgm_shd.g_old_rec.dpnt_adrs_rqd_flag,hr_api.g_varchar2)

1214: p_object_version_number => p_object_version_number);
1215: --
1216: if (l_api_updating
1217: and p_dpnt_adrs_rqd_flag
1218: <> nvl(ben_pgm_shd.g_old_rec.dpnt_adrs_rqd_flag,hr_api.g_varchar2)
1219: or not l_api_updating)
1220: and p_dpnt_adrs_rqd_flag is not null then
1221: --
1222: -- check if value of lookup falls within lookup type.

Line 1224: if hr_api.not_exists_in_hr_lookups

1220: and p_dpnt_adrs_rqd_flag is not null then
1221: --
1222: -- check if value of lookup falls within lookup type.
1223: --
1224: if hr_api.not_exists_in_hr_lookups
1225: (p_lookup_type => 'YES_NO',
1226: p_lookup_code => p_dpnt_adrs_rqd_flag,
1227: p_effective_date => p_effective_date) then
1228: --

Line 1289: <> nvl(ben_pgm_shd.g_old_rec.elig_apls_to_all_pls_flag,hr_api.g_varchar2)

1285: p_object_version_number => p_object_version_number);
1286: --
1287: if (l_api_updating
1288: and p_elig_apls_to_all_pls_flag
1289: <> nvl(ben_pgm_shd.g_old_rec.elig_apls_to_all_pls_flag,hr_api.g_varchar2)
1290: or not l_api_updating)
1291: and p_elig_apls_to_all_pls_flag is not null then
1292: --
1293: -- check if value of lookup falls within lookup type.

Line 1295: if hr_api.not_exists_in_hr_lookups

1291: and p_elig_apls_to_all_pls_flag is not null then
1292: --
1293: -- check if value of lookup falls within lookup type.
1294: --
1295: if hr_api.not_exists_in_hr_lookups
1296: (p_lookup_type => 'YES_NO',
1297: p_lookup_code => p_elig_apls_to_all_pls_flag,
1298: p_effective_date => p_effective_date) then
1299: --

Line 1360: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dob_rqd_flag,hr_api.g_varchar2)

1356: p_object_version_number => p_object_version_number);
1357: --
1358: if (l_api_updating
1359: and p_dpnt_dob_rqd_flag
1360: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dob_rqd_flag,hr_api.g_varchar2)
1361: or not l_api_updating)
1362: and p_dpnt_dob_rqd_flag is not null then
1363: --
1364: -- check if value of lookup falls within lookup type.

Line 1366: if hr_api.not_exists_in_hr_lookups

1362: and p_dpnt_dob_rqd_flag is not null then
1363: --
1364: -- check if value of lookup falls within lookup type.
1365: --
1366: if hr_api.not_exists_in_hr_lookups
1367: (p_lookup_type => 'YES_NO',
1368: p_lookup_code => p_dpnt_dob_rqd_flag,
1369: p_effective_date => p_effective_date) then
1370: --

Line 1430: <> nvl(ben_pgm_shd.g_old_rec.pgm_prvds_no_auto_enrt_flag,hr_api.g_varchar2)

1426: p_object_version_number => p_object_version_number);
1427: --
1428: if (l_api_updating
1429: and p_pgm_prvds_no_auto_enrt_flag
1430: <> nvl(ben_pgm_shd.g_old_rec.pgm_prvds_no_auto_enrt_flag,hr_api.g_varchar2)
1431: or not l_api_updating)
1432: and p_pgm_prvds_no_auto_enrt_flag is not null then
1433: --
1434: -- check if value of lookup falls within lookup type.

Line 1436: if hr_api.not_exists_in_hr_lookups

1432: and p_pgm_prvds_no_auto_enrt_flag is not null then
1433: --
1434: -- check if value of lookup falls within lookup type.
1435: --
1436: if hr_api.not_exists_in_hr_lookups
1437: (p_lookup_type => 'YES_NO',
1438: p_lookup_code => p_pgm_prvds_no_auto_enrt_flag,
1439: p_effective_date => p_effective_date) then
1440: --

Line 1500: <> nvl(ben_pgm_shd.g_old_rec.pgm_prvds_no_dflt_enrt_flag,hr_api.g_varchar2)

1496: p_object_version_number => p_object_version_number);
1497: --
1498: if (l_api_updating
1499: and p_pgm_prvds_no_dflt_enrt_flag
1500: <> nvl(ben_pgm_shd.g_old_rec.pgm_prvds_no_dflt_enrt_flag,hr_api.g_varchar2)
1501: or not l_api_updating)
1502: and p_pgm_prvds_no_dflt_enrt_flag is not null then
1503: --
1504: -- check if value of lookup falls within lookup type.

Line 1506: if hr_api.not_exists_in_hr_lookups

1502: and p_pgm_prvds_no_dflt_enrt_flag is not null then
1503: --
1504: -- check if value of lookup falls within lookup type.
1505: --
1506: if hr_api.not_exists_in_hr_lookups
1507: (p_lookup_type => 'YES_NO',
1508: p_lookup_code => p_pgm_prvds_no_dflt_enrt_flag,
1509: p_effective_date => p_effective_date) then
1510: --

Line 1570: <> nvl(ben_pgm_shd.g_old_rec.dpnt_legv_id_rqd_flag,hr_api.g_varchar2)

1566: p_object_version_number => p_object_version_number);
1567: --
1568: if (l_api_updating
1569: and p_dpnt_legv_id_rqd_flag
1570: <> nvl(ben_pgm_shd.g_old_rec.dpnt_legv_id_rqd_flag,hr_api.g_varchar2)
1571: or not l_api_updating)
1572: and p_dpnt_legv_id_rqd_flag is not null then
1573: --
1574: -- check if value of lookup falls within lookup type.

Line 1576: if hr_api.not_exists_in_hr_lookups

1572: and p_dpnt_legv_id_rqd_flag is not null then
1573: --
1574: -- check if value of lookup falls within lookup type.
1575: --
1576: if hr_api.not_exists_in_hr_lookups
1577: (p_lookup_type => 'YES_NO',
1578: p_lookup_code => p_dpnt_legv_id_rqd_flag,
1579: p_effective_date => p_effective_date) then
1580: --

Line 1640: <> nvl(ben_pgm_shd.g_old_rec.elig_apls_flag,hr_api.g_varchar2)

1636: p_object_version_number => p_object_version_number);
1637: --
1638: if (l_api_updating
1639: and p_elig_apls_flag
1640: <> nvl(ben_pgm_shd.g_old_rec.elig_apls_flag,hr_api.g_varchar2)
1641: or not l_api_updating)
1642: and p_elig_apls_flag is not null then
1643: --
1644: -- check if value of lookup falls within lookup type.

Line 1646: if hr_api.not_exists_in_hr_lookups

1642: and p_elig_apls_flag is not null then
1643: --
1644: -- check if value of lookup falls within lookup type.
1645: --
1646: if hr_api.not_exists_in_hr_lookups
1647: (p_lookup_type => 'YES_NO',
1648: p_lookup_code => p_elig_apls_flag,
1649: p_effective_date => p_effective_date) then
1650: --

Line 1710: <> nvl(ben_pgm_shd.g_old_rec.uses_all_asmts_for_rts_flag,hr_api.g_varchar2)

1706: p_object_version_number => p_object_version_number);
1707: --
1708: if (l_api_updating
1709: and p_uses_all_asmts_for_rts_flag
1710: <> nvl(ben_pgm_shd.g_old_rec.uses_all_asmts_for_rts_flag,hr_api.g_varchar2)
1711: or not l_api_updating)
1712: and p_uses_all_asmts_for_rts_flag is not null then
1713: --
1714: -- check if value of lookup falls within lookup type.

Line 1716: if hr_api.not_exists_in_hr_lookups

1712: and p_uses_all_asmts_for_rts_flag is not null then
1713: --
1714: -- check if value of lookup falls within lookup type.
1715: --
1716: if hr_api.not_exists_in_hr_lookups
1717: (p_lookup_type => 'YES_NO',
1718: p_lookup_code => p_uses_all_asmts_for_rts_flag,
1719: p_effective_date => p_effective_date) then
1720: --

Line 1780: <> nvl(ben_pgm_shd.g_old_rec.prtn_elig_ovrid_alwd_flag,hr_api.g_varchar2)

1776: p_object_version_number => p_object_version_number);
1777: --
1778: if (l_api_updating
1779: and p_prtn_elig_ovrid_alwd_flag
1780: <> nvl(ben_pgm_shd.g_old_rec.prtn_elig_ovrid_alwd_flag,hr_api.g_varchar2)
1781: or not l_api_updating)
1782: and p_prtn_elig_ovrid_alwd_flag is not null then
1783: --
1784: -- check if value of lookup falls within lookup type.

Line 1786: if hr_api.not_exists_in_hr_lookups

1782: and p_prtn_elig_ovrid_alwd_flag is not null then
1783: --
1784: -- check if value of lookup falls within lookup type.
1785: --
1786: if hr_api.not_exists_in_hr_lookups
1787: (p_lookup_type => 'YES_NO',
1788: p_lookup_code => p_prtn_elig_ovrid_alwd_flag,
1789: p_effective_date => p_effective_date) then
1790: --

Line 1852: <> nvl(ben_pgm_shd.g_old_rec.tmprl_fctr_apls_rts_flag,hr_api.g_varchar2)

1848: p_object_version_number => p_object_version_number);
1849: --
1850: if (l_api_updating
1851: and p_tmprl_fctr_apls_rts_flag
1852: <> nvl(ben_pgm_shd.g_old_rec.tmprl_fctr_apls_rts_flag,hr_api.g_varchar2)
1853: or not l_api_updating)
1854: and p_tmprl_fctr_apls_rts_flag is not null then
1855: --
1856: -- check if value of lookup falls within lookup type.

Line 1858: if hr_api.not_exists_in_hr_lookups

1854: and p_tmprl_fctr_apls_rts_flag is not null then
1855: --
1856: -- check if value of lookup falls within lookup type.
1857: --
1858: if hr_api.not_exists_in_hr_lookups
1859: (p_lookup_type => 'YES_NO',
1860: p_lookup_code => p_tmprl_fctr_apls_rts_flag,
1861: p_effective_date => p_effective_date) then
1862: --

Line 1923: <> nvl(ben_pgm_shd.g_old_rec.pgm_use_all_asnts_elig_flag,hr_api.g_varchar2)

1919: p_object_version_number => p_object_version_number);
1920: --
1921: if (l_api_updating
1922: and p_pgm_use_all_asnts_elig_flag
1923: <> nvl(ben_pgm_shd.g_old_rec.pgm_use_all_asnts_elig_flag,hr_api.g_varchar2)
1924: or not l_api_updating)
1925: and p_pgm_use_all_asnts_elig_flag is not null then
1926: --
1927: -- check if value of lookup falls within lookup type.

Line 1929: if hr_api.not_exists_in_hr_lookups

1925: and p_pgm_use_all_asnts_elig_flag is not null then
1926: --
1927: -- check if value of lookup falls within lookup type.
1928: --
1929: if hr_api.not_exists_in_hr_lookups
1930: (p_lookup_type => 'YES_NO',
1931: p_lookup_code => p_pgm_use_all_asnts_elig_flag,
1932: p_effective_date => p_effective_date) then
1933: --

Line 1994: <> nvl(ben_pgm_shd.g_old_rec.coord_cvg_for_all_pls_flg,hr_api.g_varchar2)

1990: p_object_version_number => p_object_version_number);
1991: --
1992: if (l_api_updating
1993: and p_coord_cvg_for_all_pls_flg
1994: <> nvl(ben_pgm_shd.g_old_rec.coord_cvg_for_all_pls_flg,hr_api.g_varchar2)
1995: or not l_api_updating)
1996: and p_coord_cvg_for_all_pls_flg is not null then
1997: --
1998: -- check if value of lookup falls within lookup type.

Line 2000: if hr_api.not_exists_in_hr_lookups

1996: and p_coord_cvg_for_all_pls_flg is not null then
1997: --
1998: -- check if value of lookup falls within lookup type.
1999: --
2000: if hr_api.not_exists_in_hr_lookups
2001: (p_lookup_type => 'YES_NO',
2002: p_lookup_code => p_coord_cvg_for_all_pls_flg,
2003: p_effective_date => p_effective_date) then
2004: --

Line 2065: <> nvl(ben_pgm_shd.g_old_rec.drvbl_fctr_dpnt_elig_flag,hr_api.g_varchar2)

2061: p_object_version_number => p_object_version_number);
2062: --
2063: if (l_api_updating
2064: and p_drvbl_fctr_dpnt_elig_flag
2065: <> nvl(ben_pgm_shd.g_old_rec.drvbl_fctr_dpnt_elig_flag,hr_api.g_varchar2)
2066: or not l_api_updating)
2067: and p_drvbl_fctr_dpnt_elig_flag is not null then
2068: --
2069: -- check if value of lookup falls within lookup type.

Line 2071: if hr_api.not_exists_in_hr_lookups

2067: and p_drvbl_fctr_dpnt_elig_flag is not null then
2068: --
2069: -- check if value of lookup falls within lookup type.
2070: --
2071: if hr_api.not_exists_in_hr_lookups
2072: (p_lookup_type => 'YES_NO',
2073: p_lookup_code => p_drvbl_fctr_dpnt_elig_flag,
2074: p_effective_date => p_effective_date) then
2075: --

Line 2137: <> nvl(ben_pgm_shd.g_old_rec.mt_one_dpnt_cvg_elig_flag,hr_api.g_varchar2)

2133: p_object_version_number => p_object_version_number);
2134: --
2135: if (l_api_updating
2136: and p_mt_one_dpnt_cvg_elig_flag
2137: <> nvl(ben_pgm_shd.g_old_rec.mt_one_dpnt_cvg_elig_flag,hr_api.g_varchar2)
2138: or not l_api_updating)
2139: and p_mt_one_dpnt_cvg_elig_flag is not null then
2140: --
2141: -- check if value of lookup falls within lookup type.

Line 2143: if hr_api.not_exists_in_hr_lookups

2139: and p_mt_one_dpnt_cvg_elig_flag is not null then
2140: --
2141: -- check if value of lookup falls within lookup type.
2142: --
2143: if hr_api.not_exists_in_hr_lookups
2144: (p_lookup_type => 'YES_NO',
2145: p_lookup_code => p_mt_one_dpnt_cvg_elig_flag,
2146: p_effective_date => p_effective_date) then
2147: --

Line 2208: <> nvl(ben_pgm_shd.g_old_rec.drvbl_fctr_prtn_elig_flag,hr_api.g_varchar2)

2204: p_object_version_number => p_object_version_number);
2205: --
2206: if (l_api_updating
2207: and p_drvbl_fctr_prtn_elig_flag
2208: <> nvl(ben_pgm_shd.g_old_rec.drvbl_fctr_prtn_elig_flag,hr_api.g_varchar2)
2209: or not l_api_updating)
2210: and p_drvbl_fctr_prtn_elig_flag is not null then
2211: --
2212: -- check if value of lookup falls within lookup type.

Line 2214: if hr_api.not_exists_in_hr_lookups

2210: and p_drvbl_fctr_prtn_elig_flag is not null then
2211: --
2212: -- check if value of lookup falls within lookup type.
2213: --
2214: if hr_api.not_exists_in_hr_lookups
2215: (p_lookup_type => 'YES_NO',
2216: p_lookup_code => p_drvbl_fctr_prtn_elig_flag,
2217: p_effective_date => p_effective_date) then
2218: --

Line 2281: <> nvl(ben_pgm_shd.g_old_rec.alws_unrstrctd_enrt_flag,hr_api.g_varchar2)

2277: p_object_version_number => p_object_version_number);
2278: --
2279: if (l_api_updating
2280: and p_alws_unrstrctd_enrt_flag
2281: <> nvl(ben_pgm_shd.g_old_rec.alws_unrstrctd_enrt_flag,hr_api.g_varchar2)
2282: or not l_api_updating)
2283: and p_alws_unrstrctd_enrt_flag is not null then
2284: --
2285: -- check if value of lookup falls within lookup type.

Line 2287: if hr_api.not_exists_in_hr_lookups

2283: and p_alws_unrstrctd_enrt_flag is not null then
2284: --
2285: -- check if value of lookup falls within lookup type.
2286: --
2287: if hr_api.not_exists_in_hr_lookups
2288: (p_lookup_type => 'YES_NO',
2289: p_lookup_code => p_alws_unrstrctd_enrt_flag,
2290: p_effective_date => p_effective_date) then
2291: --

Line 2351: <> nvl(ben_pgm_shd.g_old_rec.drvbl_fctr_apls_rts_flag,hr_api.g_varchar2)

2347: p_object_version_number => p_object_version_number);
2348: --
2349: if (l_api_updating
2350: and p_drvbl_fctr_apls_rts_flag
2351: <> nvl(ben_pgm_shd.g_old_rec.drvbl_fctr_apls_rts_flag,hr_api.g_varchar2)
2352: or not l_api_updating)
2353: and p_drvbl_fctr_apls_rts_flag is not null then
2354: --
2355: -- check if value of lookup falls within lookup type.

Line 2357: if hr_api.not_exists_in_hr_lookups

2353: and p_drvbl_fctr_apls_rts_flag is not null then
2354: --
2355: -- check if value of lookup falls within lookup type.
2356: --
2357: if hr_api.not_exists_in_hr_lookups
2358: (p_lookup_type => 'YES_NO',
2359: p_lookup_code => p_drvbl_fctr_apls_rts_flag,
2360: p_effective_date => p_effective_date) then
2361: --

Line 2423: <> nvl(ben_pgm_shd.g_old_rec.tmprl_fctr_dpnt_elig_flag,hr_api.g_varchar2)

2419: p_object_version_number => p_object_version_number);
2420: --
2421: if (l_api_updating
2422: and p_tmprl_fctr_dpnt_elig_flag
2423: <> nvl(ben_pgm_shd.g_old_rec.tmprl_fctr_dpnt_elig_flag,hr_api.g_varchar2)
2424: or not l_api_updating)
2425: and p_tmprl_fctr_dpnt_elig_flag is not null then
2426: --
2427: -- check if value of lookup falls within lookup type.

Line 2429: if hr_api.not_exists_in_hr_lookups

2425: and p_tmprl_fctr_dpnt_elig_flag is not null then
2426: --
2427: -- check if value of lookup falls within lookup type.
2428: --
2429: if hr_api.not_exists_in_hr_lookups
2430: (p_lookup_type => 'YES_NO',
2431: p_lookup_code => p_tmprl_fctr_dpnt_elig_flag,
2432: p_effective_date => p_effective_date) then
2433: --

Line 2494: <> nvl(ben_pgm_shd.g_old_rec.tmprl_fctr_prtn_elig_flag,hr_api.g_varchar2)

2490: p_object_version_number => p_object_version_number);
2491: --
2492: if (l_api_updating
2493: and p_tmprl_fctr_prtn_elig_flag
2494: <> nvl(ben_pgm_shd.g_old_rec.tmprl_fctr_prtn_elig_flag,hr_api.g_varchar2)
2495: or not l_api_updating)
2496: and p_tmprl_fctr_prtn_elig_flag is not null then
2497: --
2498: -- check if value of lookup falls within lookup type.

Line 2500: if hr_api.not_exists_in_hr_lookups

2496: and p_tmprl_fctr_prtn_elig_flag is not null then
2497: --
2498: -- check if value of lookup falls within lookup type.
2499: --
2500: if hr_api.not_exists_in_hr_lookups
2501: (p_lookup_type => 'YES_NO',
2502: p_lookup_code => p_tmprl_fctr_prtn_elig_flag,
2503: p_effective_date => p_effective_date) then
2504: --

Line 2565: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dsgn_no_ctfn_rqd_flag,hr_api.g_varchar2)

2561: p_object_version_number => p_object_version_number);
2562: --
2563: if (l_api_updating
2564: and p_dpnt_dsgn_no_ctfn_rqd_flag
2565: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dsgn_no_ctfn_rqd_flag,hr_api.g_varchar2)
2566: or not l_api_updating)
2567: and p_dpnt_dsgn_no_ctfn_rqd_flag is not null then
2568: --
2569: -- check if value of lookup falls within lookup type.

Line 2571: if hr_api.not_exists_in_hr_lookups

2567: and p_dpnt_dsgn_no_ctfn_rqd_flag is not null then
2568: --
2569: -- check if value of lookup falls within lookup type.
2570: --
2571: if hr_api.not_exists_in_hr_lookups
2572: (p_lookup_type => 'YES_NO',
2573: p_lookup_code => p_dpnt_dsgn_no_ctfn_rqd_flag,
2574: p_effective_date => p_effective_date) then
2575: --

Line 2636: <> nvl(ben_pgm_shd.g_old_rec.trk_inelig_per_flag,hr_api.g_varchar2)

2632: p_object_version_number => p_object_version_number);
2633: --
2634: if (l_api_updating
2635: and p_trk_inelig_per_flag
2636: <> nvl(ben_pgm_shd.g_old_rec.trk_inelig_per_flag,hr_api.g_varchar2)
2637: or not l_api_updating)
2638: and p_trk_inelig_per_flag is not null then
2639: --
2640: -- check if value of lookup falls within lookup type.

Line 2642: if hr_api.not_exists_in_hr_lookups

2638: and p_trk_inelig_per_flag is not null then
2639: --
2640: -- check if value of lookup falls within lookup type.
2641: --
2642: if hr_api.not_exists_in_hr_lookups
2643: (p_lookup_type => 'YES_NO',
2644: p_lookup_code => p_trk_inelig_per_flag,
2645: p_effective_date => p_effective_date) then
2646: --

Line 2919: <> nvl(ben_pgm_shd.g_old_rec.enrt_mthd_cd,hr_api.g_varchar2)

2915: p_object_version_number => p_object_version_number);
2916: --
2917: if (l_api_updating
2918: and p_enrt_mthd_cd
2919: <> nvl(ben_pgm_shd.g_old_rec.enrt_mthd_cd,hr_api.g_varchar2)
2920: or not l_api_updating)
2921: and p_enrt_mthd_cd is not null then
2922: --
2923: -- check if value of lookup falls within lookup type.

Line 2926: if hr_api.not_exists_in_hr_lookups

2922: --
2923: -- check if value of lookup falls within lookup type.
2924: --
2925: --
2926: if hr_api.not_exists_in_hr_lookups
2927: (p_lookup_type => 'BEN_ENRT_MTHD',
2928: p_lookup_code => p_enrt_mthd_cd,
2929: p_effective_date => p_effective_date) then
2930: --

Line 2991: <> nvl(ben_pgm_shd.g_old_rec.poe_lvl_cd,hr_api.g_varchar2)

2987: p_object_version_number => p_object_version_number);
2988: --
2989: if (l_api_updating
2990: and p_poe_lvl_cd
2991: <> nvl(ben_pgm_shd.g_old_rec.poe_lvl_cd,hr_api.g_varchar2)
2992: or not l_api_updating)
2993: and p_poe_lvl_cd is not null then
2994: --
2995: -- check if value of lookup falls within lookup type.

Line 2998: if hr_api.not_exists_in_hr_lookups

2994: --
2995: -- check if value of lookup falls within lookup type.
2996: --
2997: --
2998: if hr_api.not_exists_in_hr_lookups
2999: (p_lookup_type => 'BEN_POE_LVL',
3000: p_lookup_code => p_poe_lvl_cd,
3001: p_effective_date => p_effective_date) then
3002: --

Line 3064: <> nvl(ben_pgm_shd.g_old_rec.enrt_cd,hr_api.g_varchar2)

3060: p_object_version_number => p_object_version_number);
3061: --
3062: if (l_api_updating
3063: and p_enrt_cd
3064: <> nvl(ben_pgm_shd.g_old_rec.enrt_cd,hr_api.g_varchar2)
3065: or not l_api_updating)
3066: and p_enrt_cd is not null then
3067: --
3068: -- check if value of lookup falls within lookup type.

Line 3071: if hr_api.not_exists_in_hr_lookups

3067: --
3068: -- check if value of lookup falls within lookup type.
3069: --
3070: --
3071: if hr_api.not_exists_in_hr_lookups
3072: (p_lookup_type => 'BEN_ENRT',
3073: p_lookup_code => p_enrt_cd,
3074: p_effective_date => p_effective_date) then
3075: --

Line 3135: <> nvl(ben_pgm_shd.g_old_rec.pgm_stat_cd,hr_api.g_varchar2)

3131: p_object_version_number => p_object_version_number);
3132: --
3133: if (l_api_updating
3134: and p_pgm_stat_cd
3135: <> nvl(ben_pgm_shd.g_old_rec.pgm_stat_cd,hr_api.g_varchar2)
3136: or not l_api_updating) then
3137: --
3138: -- check if value of lookup falls within lookup type.
3139: --

Line 3141: if hr_api.not_exists_in_hr_lookups

3137: --
3138: -- check if value of lookup falls within lookup type.
3139: --
3140: --
3141: if hr_api.not_exists_in_hr_lookups
3142: (p_lookup_type => 'BEN_STAT',
3143: p_lookup_code => p_pgm_stat_cd,
3144: p_effective_date => p_effective_date) then
3145: --

Line 3204: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dsgn_lvl_cd,hr_api.g_varchar2)

3200: p_object_version_number => p_object_version_number);
3201: --
3202: if (l_api_updating
3203: and p_dpnt_dsgn_lvl_cd
3204: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dsgn_lvl_cd,hr_api.g_varchar2)
3205: or not l_api_updating) then
3206: --
3207: -- check if value of lookup falls within lookup type.
3208: --

Line 3211: if hr_api.not_exists_in_hr_lookups

3207: -- check if value of lookup falls within lookup type.
3208: --
3209: --
3210: if p_dpnt_dsgn_lvl_cd is not null then
3211: if hr_api.not_exists_in_hr_lookups
3212: (p_lookup_type => 'BEN_DPNT_DSGN_LVL',
3213: p_lookup_code => p_dpnt_dsgn_lvl_cd,
3214: p_effective_date => p_effective_date) then
3215: --

Line 3275: <> nvl(ben_pgm_shd.g_old_rec.pgm_typ_cd,hr_api.g_varchar2)

3271: p_object_version_number => p_object_version_number);
3272: --
3273: if (l_api_updating
3274: and p_pgm_typ_cd
3275: <> nvl(ben_pgm_shd.g_old_rec.pgm_typ_cd,hr_api.g_varchar2)
3276: or not l_api_updating) then
3277: --
3278: -- check if value of lookup falls within lookup type.
3279: --

Line 3280: if hr_api.not_exists_in_hr_lookups

3276: or not l_api_updating) then
3277: --
3278: -- check if value of lookup falls within lookup type.
3279: --
3280: if hr_api.not_exists_in_hr_lookups
3281: (p_lookup_type => 'BEN_PGM_TYP',
3282: p_lookup_code => p_pgm_typ_cd,
3283: p_effective_date => p_effective_date) then
3284: --

Line 3351: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dsgn_cd,hr_api.g_varchar2)

3347: p_object_version_number => p_object_version_number);
3348: --
3349: if (l_api_updating
3350: and p_dpnt_dsgn_cd
3351: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dsgn_cd,hr_api.g_varchar2)
3352: or not l_api_updating) then
3353: --
3354: -- check if value of lookup falls within lookup type.
3355: --

Line 3358: if hr_api.not_exists_in_hr_lookups

3354: -- check if value of lookup falls within lookup type.
3355: --
3356: --
3357: if p_dpnt_dsgn_cd is not null then
3358: if hr_api.not_exists_in_hr_lookups
3359: (p_lookup_type => 'BEN_DPNT_DSGN',
3360: p_lookup_code => p_dpnt_dsgn_cd,
3361: p_effective_date => p_effective_date) then
3362: --

Line 3442: <> nvl(ben_pgm_shd.g_old_rec.pgm_grp_cd,hr_api.g_varchar2)

3438: p_object_version_number => p_object_version_number);
3439: --
3440: if (l_api_updating
3441: and p_pgm_grp_cd
3442: <> nvl(ben_pgm_shd.g_old_rec.pgm_grp_cd,hr_api.g_varchar2)
3443: or not l_api_updating) then
3444: --
3445: -- check if value of lookup falls within lookup type.
3446: --

Line 3449: if hr_api.not_exists_in_hr_lookups

3445: -- check if value of lookup falls within lookup type.
3446: --
3447: --
3448: if p_pgm_grp_cd is not null then
3449: if hr_api.not_exists_in_hr_lookups
3450: (p_lookup_type => 'BEN_PGM_GRP',
3451: p_lookup_code => p_pgm_grp_cd,
3452: p_effective_date => p_effective_date) then
3453: --

Line 3513: <> nvl(ben_pgm_shd.g_old_rec.acty_ref_perd_cd,hr_api.g_varchar2)

3509: p_object_version_number => p_object_version_number);
3510: --
3511: if (l_api_updating
3512: and p_acty_ref_perd_cd
3513: <> nvl(ben_pgm_shd.g_old_rec.acty_ref_perd_cd,hr_api.g_varchar2)
3514: or not l_api_updating) then
3515: --
3516: -- check if value of lookup falls within lookup type.
3517: --

Line 3520: if hr_api.not_exists_in_hr_lookups

3516: -- check if value of lookup falls within lookup type.
3517: --
3518: --
3519: if p_acty_ref_perd_cd is not null then
3520: if hr_api.not_exists_in_hr_lookups
3521: (p_lookup_type => 'BEN_ACTY_REF_PERD',
3522: p_lookup_code => p_acty_ref_perd_cd,
3523: p_effective_date => p_effective_date) then
3524: --

Line 3584: <> nvl(ben_pgm_shd.g_old_rec.enrt_cvg_strt_dt_cd,hr_api.g_varchar2)

3580: p_object_version_number => p_object_version_number);
3581: --
3582: if (l_api_updating
3583: and p_enrt_cvg_strt_dt_cd
3584: <> nvl(ben_pgm_shd.g_old_rec.enrt_cvg_strt_dt_cd,hr_api.g_varchar2)
3585: or not l_api_updating) then
3586: --
3587: -- check if value of lookup falls within lookup type.
3588: --

Line 3591: if hr_api.not_exists_in_hr_lookups

3587: -- check if value of lookup falls within lookup type.
3588: --
3589: --
3590: if p_enrt_cvg_strt_dt_cd is not null then
3591: if hr_api.not_exists_in_hr_lookups
3592: (p_lookup_type => 'BEN_ENRT_CVG_STRT',
3593: p_lookup_code => p_enrt_cvg_strt_dt_cd,
3594: p_effective_date => p_effective_date) then
3595: --

Line 3655: <> nvl(ben_pgm_shd.g_old_rec.enrt_cvg_end_dt_cd,hr_api.g_varchar2)

3651: p_object_version_number => p_object_version_number);
3652: --
3653: if (l_api_updating
3654: and p_enrt_cvg_end_dt_cd
3655: <> nvl(ben_pgm_shd.g_old_rec.enrt_cvg_end_dt_cd,hr_api.g_varchar2)
3656: or not l_api_updating) then
3657: --
3658: -- check if value of lookup falls within lookup type.
3659: --

Line 3662: if hr_api.not_exists_in_hr_lookups

3658: -- check if value of lookup falls within lookup type.
3659: --
3660: --
3661: if p_enrt_cvg_end_dt_cd is not null then
3662: if hr_api.not_exists_in_hr_lookups
3663: (p_lookup_type => 'BEN_ENRT_CVG_END',
3664: p_lookup_code => p_enrt_cvg_end_dt_cd,
3665: p_effective_date => p_effective_date) then
3666: --

Line 3727: <> nvl(ben_pgm_shd.g_old_rec.prtn_strt_dt_cd,hr_api.g_varchar2)

3723: p_object_version_number => p_object_version_number);
3724: --
3725: if (l_api_updating
3726: and p_prtn_strt_dt_cd
3727: <> nvl(ben_pgm_shd.g_old_rec.prtn_strt_dt_cd,hr_api.g_varchar2)
3728: or not l_api_updating) then
3729: --
3730: -- check if value of lookup falls within lookup type.
3731: --

Line 3734: if hr_api.not_exists_in_hr_lookups

3730: -- check if value of lookup falls within lookup type.
3731: --
3732: --
3733: if p_prtn_strt_dt_cd is not null then
3734: if hr_api.not_exists_in_hr_lookups
3735: (p_lookup_type => 'BEN_PRTN_ELIG_STRT',
3736: p_lookup_code => p_prtn_strt_dt_cd,
3737: p_effective_date => p_effective_date) then
3738: --

Line 3798: <> nvl(ben_pgm_shd.g_old_rec.prtn_end_dt_cd,hr_api.g_varchar2)

3794: p_object_version_number => p_object_version_number);
3795: --
3796: if (l_api_updating
3797: and p_prtn_end_dt_cd
3798: <> nvl(ben_pgm_shd.g_old_rec.prtn_end_dt_cd,hr_api.g_varchar2)
3799: or not l_api_updating) then
3800: --
3801: -- check if value of lookup falls within lookup type.
3802: --

Line 3805: if hr_api.not_exists_in_hr_lookups

3801: -- check if value of lookup falls within lookup type.
3802: --
3803: --
3804: if p_prtn_end_dt_cd is not null then
3805: if hr_api.not_exists_in_hr_lookups
3806: (p_lookup_type => 'BEN_PRTN_ELIG_END',
3807: p_lookup_code => p_prtn_end_dt_cd,
3808: p_effective_date => p_effective_date) then
3809: --

Line 3877: <> nvl(ben_pgm_shd.g_old_rec.pgm_uom,hr_api.g_varchar2)

3873: p_object_version_number => p_object_version_number);
3874: --
3875: if (l_api_updating
3876: and p_pgm_uom
3877: <> nvl(ben_pgm_shd.g_old_rec.pgm_uom,hr_api.g_varchar2)
3878: or not l_api_updating)
3879: and p_pgm_uom is not null then
3880: --
3881: -- check if value of lookup falls within fnd_currencies.

Line 3963: and nvl(p_Dflt_step_rl,hr_api.g_number)

3959: p_effective_date => p_effective_date,
3960: p_object_version_number => p_object_version_number);
3961: --
3962: if (l_api_updating
3963: and nvl(p_Dflt_step_rl,hr_api.g_number)
3964: <> ben_pgm_shd.g_old_rec.Dflt_step_rl
3965: or not l_api_updating)
3966: and p_Dflt_step_rl is not null then
3967: --

Line 3994: and nvl(p_Scores_calc_rl,hr_api.g_number)

3990: --
3991: end if;
3992: --
3993: if (l_api_updating
3994: and nvl(p_Scores_calc_rl,hr_api.g_number)
3995: <> ben_pgm_shd.g_old_rec.Scores_calc_rl
3996: or not l_api_updating)
3997: and p_Scores_calc_rl is not null then
3998: --

Line 4074: <> nvl(ben_pgm_shd.g_old_rec.Dflt_step_cd,hr_api.g_varchar2)

4070: p_object_version_number => p_object_version_number);
4071: --
4072: if (l_api_updating
4073: and p_Dflt_step_cd
4074: <> nvl(ben_pgm_shd.g_old_rec.Dflt_step_cd,hr_api.g_varchar2)
4075: or not l_api_updating) then
4076: --
4077: -- check if value of lookup falls within lookup type.
4078: --

Line 4081: if hr_api.not_exists_in_hr_lookups

4077: -- check if value of lookup falls within lookup type.
4078: --
4079: --
4080: if p_Dflt_step_cd is not null then
4081: if hr_api.not_exists_in_hr_lookups
4082: (p_lookup_type => 'BEN_GL_PROG_STYLE',
4083: p_lookup_code => p_dflt_step_cd,
4084: p_effective_date => p_effective_date) then
4085: --

Line 4102: <> nvl(ben_pgm_shd.g_old_rec.Update_salary_cd,hr_api.g_varchar2)

4098: --
4099: --
4100: if (l_api_updating
4101: and p_Update_salary_cd
4102: <> nvl(ben_pgm_shd.g_old_rec.Update_salary_cd,hr_api.g_varchar2)
4103: or not l_api_updating) then
4104: --
4105: -- check if value of lookup falls within lookup type.
4106: --

Line 4109: if hr_api.not_exists_in_hr_lookups

4105: -- check if value of lookup falls within lookup type.
4106: --
4107: --
4108: if p_Update_salary_cd is not null then
4109: if hr_api.not_exists_in_hr_lookups
4110: (p_lookup_type => 'PQH_GSP_SAL_UPD_MTHD',
4111: p_lookup_code => p_Update_salary_cd,
4112: p_effective_date => p_effective_date) then
4113: --

Line 4129: <> nvl(ben_pgm_shd.g_old_rec.Scores_calc_mthd_cd,hr_api.g_varchar2)

4125: end if;
4126: --
4127: if (l_api_updating
4128: and p_Scores_calc_mthd_cd
4129: <> nvl(ben_pgm_shd.g_old_rec.Scores_calc_mthd_cd,hr_api.g_varchar2)
4130: or not l_api_updating) then
4131: --
4132: -- check if value of lookup falls within lookup type.
4133: --

Line 4136: if hr_api.not_exists_in_hr_lookups

4132: -- check if value of lookup falls within lookup type.
4133: --
4134: --
4135: if p_Scores_calc_mthd_cd is not null then
4136: if hr_api.not_exists_in_hr_lookups
4137: (p_lookup_type => 'BEN_SCORES_CALC_MTHD',
4138: p_lookup_code => p_Scores_calc_mthd_cd,
4139: p_effective_date => p_effective_date) then
4140: --

Line 4157: <> nvl(ben_pgm_shd.g_old_rec.salary_calc_mthd_cd,hr_api.g_varchar2)

4153: --
4154: --
4155: if (l_api_updating
4156: and p_salary_calc_mthd_cd
4157: <> nvl(ben_pgm_shd.g_old_rec.salary_calc_mthd_cd,hr_api.g_varchar2)
4158: or not l_api_updating) then
4159: --
4160: -- check if value of lookup falls within lookup type.
4161: --

Line 4164: if hr_api.not_exists_in_hr_lookups

4160: -- check if value of lookup falls within lookup type.
4161: --
4162: --
4163: if p_Scores_calc_mthd_cd is not null then
4164: if hr_api.not_exists_in_hr_lookups
4165: (p_lookup_type => 'PQH_GSP_SAL_CALC_METH',
4166: p_lookup_code => p_salary_calc_mthd_cd,
4167: p_effective_date => p_effective_date) then
4168: --

Line 4233: <> nvl(ben_pgm_shd.g_old_rec.enrt_info_rt_freq_cd,hr_api.g_varchar2)

4229: p_object_version_number => p_object_version_number);
4230: --
4231: if (l_api_updating
4232: and p_enrt_info_rt_freq_cd
4233: <> nvl(ben_pgm_shd.g_old_rec.enrt_info_rt_freq_cd,hr_api.g_varchar2)
4234: or not l_api_updating) then
4235: --
4236: -- check if value of lookup falls within lookup type.
4237: --

Line 4240: if hr_api.not_exists_in_hr_lookups

4236: -- check if value of lookup falls within lookup type.
4237: --
4238: --
4239: if p_enrt_info_rt_freq_cd is not null then
4240: if hr_api.not_exists_in_hr_lookups
4241: (p_lookup_type => 'BEN_ENRT_INFO_RT_FREQ',
4242: p_lookup_code => p_enrt_info_rt_freq_cd,
4243: p_effective_date => p_effective_date) then
4244: --

Line 4304: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_strt_dt_cd,hr_api.g_varchar2)

4300: p_object_version_number => p_object_version_number);
4301: --
4302: if (l_api_updating
4303: and p_dpnt_cvg_strt_dt_cd
4304: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_strt_dt_cd,hr_api.g_varchar2)
4305: or not l_api_updating) then
4306: --
4307: -- check if value of lookup falls within lookup type.
4308: --

Line 4311: if hr_api.not_exists_in_hr_lookups

4307: -- check if value of lookup falls within lookup type.
4308: --
4309: --
4310: if p_dpnt_cvg_strt_dt_cd is not null then
4311: if hr_api.not_exists_in_hr_lookups
4312: (p_lookup_type => 'BEN_DPNT_CVG_STRT',
4313: p_lookup_code => p_dpnt_cvg_strt_dt_cd,
4314: p_effective_date => p_effective_date) then
4315: --

Line 4375: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_end_dt_cd,hr_api.g_varchar2)

4371: p_object_version_number => p_object_version_number);
4372: --
4373: if (l_api_updating
4374: and p_dpnt_cvg_end_dt_cd
4375: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_end_dt_cd,hr_api.g_varchar2)
4376: or not l_api_updating) then
4377: --
4378: -- check if value of lookup falls within lookup type.
4379: --

Line 4382: if hr_api.not_exists_in_hr_lookups

4378: -- check if value of lookup falls within lookup type.
4379: --
4380: --
4381: if p_dpnt_cvg_end_dt_cd is not null then
4382: if hr_api.not_exists_in_hr_lookups
4383: (p_lookup_type => 'BEN_DPNT_CVG_END',
4384: p_lookup_code => p_dpnt_cvg_end_dt_cd,
4385: p_effective_date => p_effective_date) then
4386: --

Line 4450: and (nvl(p_enrt_cvg_strt_dt_cd,hr_api.g_varchar2)

4446: p_effective_date => p_effective_date,
4447: p_object_version_number => p_object_version_number);
4448: --
4449: if (l_api_updating
4450: and (nvl(p_enrt_cvg_strt_dt_cd,hr_api.g_varchar2)
4451: <> nvl(ben_pgm_shd.g_old_rec.enrt_cvg_strt_dt_cd,hr_api.g_varchar2) or
4452: nvl(p_enrt_cvg_strt_dt_rl,hr_api.g_number)
4453: <> nvl(ben_pgm_shd.g_old_rec.enrt_cvg_strt_dt_rl,hr_api.g_number))
4454: or not l_api_updating) then

Line 4451: <> nvl(ben_pgm_shd.g_old_rec.enrt_cvg_strt_dt_cd,hr_api.g_varchar2) or

4447: p_object_version_number => p_object_version_number);
4448: --
4449: if (l_api_updating
4450: and (nvl(p_enrt_cvg_strt_dt_cd,hr_api.g_varchar2)
4451: <> nvl(ben_pgm_shd.g_old_rec.enrt_cvg_strt_dt_cd,hr_api.g_varchar2) or
4452: nvl(p_enrt_cvg_strt_dt_rl,hr_api.g_number)
4453: <> nvl(ben_pgm_shd.g_old_rec.enrt_cvg_strt_dt_rl,hr_api.g_number))
4454: or not l_api_updating) then
4455: --

Line 4452: nvl(p_enrt_cvg_strt_dt_rl,hr_api.g_number)

4448: --
4449: if (l_api_updating
4450: and (nvl(p_enrt_cvg_strt_dt_cd,hr_api.g_varchar2)
4451: <> nvl(ben_pgm_shd.g_old_rec.enrt_cvg_strt_dt_cd,hr_api.g_varchar2) or
4452: nvl(p_enrt_cvg_strt_dt_rl,hr_api.g_number)
4453: <> nvl(ben_pgm_shd.g_old_rec.enrt_cvg_strt_dt_rl,hr_api.g_number))
4454: or not l_api_updating) then
4455: --
4456: if (p_enrt_cvg_strt_dt_cd = 'RL' and p_enrt_cvg_strt_dt_rl is null) then

Line 4453: <> nvl(ben_pgm_shd.g_old_rec.enrt_cvg_strt_dt_rl,hr_api.g_number))

4449: if (l_api_updating
4450: and (nvl(p_enrt_cvg_strt_dt_cd,hr_api.g_varchar2)
4451: <> nvl(ben_pgm_shd.g_old_rec.enrt_cvg_strt_dt_cd,hr_api.g_varchar2) or
4452: nvl(p_enrt_cvg_strt_dt_rl,hr_api.g_number)
4453: <> nvl(ben_pgm_shd.g_old_rec.enrt_cvg_strt_dt_rl,hr_api.g_number))
4454: or not l_api_updating) then
4455: --
4456: if (p_enrt_cvg_strt_dt_cd = 'RL' and p_enrt_cvg_strt_dt_rl is null) then
4457: --

Line 4463: if nvl(p_enrt_cvg_strt_dt_cd,hr_api.g_varchar2) <> 'RL'

4459: fnd_message.raise_error;
4460: --
4461: end if;
4462: --
4463: if nvl(p_enrt_cvg_strt_dt_cd,hr_api.g_varchar2) <> 'RL'
4464: and p_enrt_cvg_strt_dt_rl is not null then
4465: --
4466: fnd_message.set_name('BEN','BEN_91311_ENRT_STRT_RWOC');
4467: fnd_message.raise_error;

Line 4527: (nvl(p_enrt_cvg_end_dt_cd,hr_api.g_varchar2)

4523: p_object_version_number => p_object_version_number);
4524: --
4525: if (l_api_updating
4526: and
4527: (nvl(p_enrt_cvg_end_dt_cd,hr_api.g_varchar2)
4528: <> nvl(ben_pgm_shd.g_old_rec.enrt_cvg_end_dt_cd,hr_api.g_varchar2) or
4529: nvl(p_enrt_cvg_end_dt_rl,hr_api.g_number)
4530: <> nvl(ben_pgm_shd.g_old_rec.enrt_cvg_end_dt_rl,hr_api.g_number))
4531: or not l_api_updating) then

Line 4528: <> nvl(ben_pgm_shd.g_old_rec.enrt_cvg_end_dt_cd,hr_api.g_varchar2) or

4524: --
4525: if (l_api_updating
4526: and
4527: (nvl(p_enrt_cvg_end_dt_cd,hr_api.g_varchar2)
4528: <> nvl(ben_pgm_shd.g_old_rec.enrt_cvg_end_dt_cd,hr_api.g_varchar2) or
4529: nvl(p_enrt_cvg_end_dt_rl,hr_api.g_number)
4530: <> nvl(ben_pgm_shd.g_old_rec.enrt_cvg_end_dt_rl,hr_api.g_number))
4531: or not l_api_updating) then
4532: --

Line 4529: nvl(p_enrt_cvg_end_dt_rl,hr_api.g_number)

4525: if (l_api_updating
4526: and
4527: (nvl(p_enrt_cvg_end_dt_cd,hr_api.g_varchar2)
4528: <> nvl(ben_pgm_shd.g_old_rec.enrt_cvg_end_dt_cd,hr_api.g_varchar2) or
4529: nvl(p_enrt_cvg_end_dt_rl,hr_api.g_number)
4530: <> nvl(ben_pgm_shd.g_old_rec.enrt_cvg_end_dt_rl,hr_api.g_number))
4531: or not l_api_updating) then
4532: --
4533: if (p_enrt_cvg_end_dt_cd = 'RL' and p_enrt_cvg_end_dt_rl is null) then

Line 4530: <> nvl(ben_pgm_shd.g_old_rec.enrt_cvg_end_dt_rl,hr_api.g_number))

4526: and
4527: (nvl(p_enrt_cvg_end_dt_cd,hr_api.g_varchar2)
4528: <> nvl(ben_pgm_shd.g_old_rec.enrt_cvg_end_dt_cd,hr_api.g_varchar2) or
4529: nvl(p_enrt_cvg_end_dt_rl,hr_api.g_number)
4530: <> nvl(ben_pgm_shd.g_old_rec.enrt_cvg_end_dt_rl,hr_api.g_number))
4531: or not l_api_updating) then
4532: --
4533: if (p_enrt_cvg_end_dt_cd = 'RL' and p_enrt_cvg_end_dt_rl is null) then
4534: --

Line 4540: if nvl(p_enrt_cvg_end_dt_cd,hr_api.g_varchar2) <> 'RL'

4536: fnd_message.raise_error;
4537: --
4538: end if;
4539: --
4540: if nvl(p_enrt_cvg_end_dt_cd,hr_api.g_varchar2) <> 'RL'
4541: and p_enrt_cvg_end_dt_rl is not null then
4542: --
4543: fnd_message.set_name('BEN','BEN_91379_DFLT_DENRL_END_DT2');
4544: fnd_message.raise_error;

Line 4603: (nvl(p_dpnt_cvg_strt_dt_cd,hr_api.g_varchar2)

4599: p_object_version_number => p_object_version_number);
4600: --
4601: if (l_api_updating
4602: and
4603: (nvl(p_dpnt_cvg_strt_dt_cd,hr_api.g_varchar2)
4604: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_strt_dt_cd,hr_api.g_varchar2) or
4605: nvl(p_dpnt_cvg_strt_dt_rl,hr_api.g_number)
4606: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_strt_dt_rl,hr_api.g_number))
4607: or not l_api_updating) then

Line 4604: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_strt_dt_cd,hr_api.g_varchar2) or

4600: --
4601: if (l_api_updating
4602: and
4603: (nvl(p_dpnt_cvg_strt_dt_cd,hr_api.g_varchar2)
4604: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_strt_dt_cd,hr_api.g_varchar2) or
4605: nvl(p_dpnt_cvg_strt_dt_rl,hr_api.g_number)
4606: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_strt_dt_rl,hr_api.g_number))
4607: or not l_api_updating) then
4608: --

Line 4605: nvl(p_dpnt_cvg_strt_dt_rl,hr_api.g_number)

4601: if (l_api_updating
4602: and
4603: (nvl(p_dpnt_cvg_strt_dt_cd,hr_api.g_varchar2)
4604: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_strt_dt_cd,hr_api.g_varchar2) or
4605: nvl(p_dpnt_cvg_strt_dt_rl,hr_api.g_number)
4606: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_strt_dt_rl,hr_api.g_number))
4607: or not l_api_updating) then
4608: --
4609: if (p_dpnt_cvg_strt_dt_cd = 'RL' and p_dpnt_cvg_strt_dt_rl is null) then

Line 4606: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_strt_dt_rl,hr_api.g_number))

4602: and
4603: (nvl(p_dpnt_cvg_strt_dt_cd,hr_api.g_varchar2)
4604: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_strt_dt_cd,hr_api.g_varchar2) or
4605: nvl(p_dpnt_cvg_strt_dt_rl,hr_api.g_number)
4606: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_strt_dt_rl,hr_api.g_number))
4607: or not l_api_updating) then
4608: --
4609: if (p_dpnt_cvg_strt_dt_cd = 'RL' and p_dpnt_cvg_strt_dt_rl is null) then
4610: --

Line 4616: if nvl(p_dpnt_cvg_strt_dt_cd,hr_api.g_varchar2) <> 'RL' and p_dpnt_cvg_strt_dt_rl is not null then

4612: fnd_message.raise_error;
4613: --
4614: end if;
4615: --
4616: if nvl(p_dpnt_cvg_strt_dt_cd,hr_api.g_varchar2) <> 'RL' and p_dpnt_cvg_strt_dt_rl is not null then
4617: --
4618: fnd_message.set_name('BEN','BEN_91381_DPNT_CVG_ST_DT_2');
4619: fnd_message.raise_error;
4620: --

Line 4678: (nvl(p_dpnt_cvg_end_dt_cd,hr_api.g_varchar2)

4674: p_object_version_number => p_object_version_number);
4675: --
4676: if (l_api_updating
4677: and
4678: (nvl(p_dpnt_cvg_end_dt_cd,hr_api.g_varchar2)
4679: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_end_dt_cd,hr_api.g_varchar2) or
4680: nvl(p_dpnt_cvg_end_dt_rl,hr_api.g_number)
4681: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_end_dt_rl,hr_api.g_number))
4682: or not l_api_updating) then

Line 4679: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_end_dt_cd,hr_api.g_varchar2) or

4675: --
4676: if (l_api_updating
4677: and
4678: (nvl(p_dpnt_cvg_end_dt_cd,hr_api.g_varchar2)
4679: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_end_dt_cd,hr_api.g_varchar2) or
4680: nvl(p_dpnt_cvg_end_dt_rl,hr_api.g_number)
4681: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_end_dt_rl,hr_api.g_number))
4682: or not l_api_updating) then
4683: --

Line 4680: nvl(p_dpnt_cvg_end_dt_rl,hr_api.g_number)

4676: if (l_api_updating
4677: and
4678: (nvl(p_dpnt_cvg_end_dt_cd,hr_api.g_varchar2)
4679: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_end_dt_cd,hr_api.g_varchar2) or
4680: nvl(p_dpnt_cvg_end_dt_rl,hr_api.g_number)
4681: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_end_dt_rl,hr_api.g_number))
4682: or not l_api_updating) then
4683: --
4684: if (p_dpnt_cvg_end_dt_cd = 'RL' and p_dpnt_cvg_end_dt_rl is null) then

Line 4681: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_end_dt_rl,hr_api.g_number))

4677: and
4678: (nvl(p_dpnt_cvg_end_dt_cd,hr_api.g_varchar2)
4679: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_end_dt_cd,hr_api.g_varchar2) or
4680: nvl(p_dpnt_cvg_end_dt_rl,hr_api.g_number)
4681: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_end_dt_rl,hr_api.g_number))
4682: or not l_api_updating) then
4683: --
4684: if (p_dpnt_cvg_end_dt_cd = 'RL' and p_dpnt_cvg_end_dt_rl is null) then
4685: --

Line 4691: if nvl(p_dpnt_cvg_end_dt_cd,hr_api.g_varchar2) <> 'RL' and p_dpnt_cvg_end_dt_rl is not null then

4687: fnd_message.raise_error;
4688: --
4689: end if;
4690: --
4691: if nvl(p_dpnt_cvg_end_dt_cd,hr_api.g_varchar2) <> 'RL' and p_dpnt_cvg_end_dt_rl is not null then
4692: --
4693: fnd_message.set_name('BEN','BEN_91353_DPNT_CVG_END_R_NO_CD');
4694: fnd_message.raise_error;
4695: --

Line 4770: (nvl(p_dpnt_cvg_end_dt_cd,hr_api.g_varchar2)

4766: p_object_version_number => p_object_version_number);
4767: --
4768: if (l_api_updating
4769: and
4770: (nvl(p_dpnt_cvg_end_dt_cd,hr_api.g_varchar2)
4771: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_end_dt_cd,hr_api.g_varchar2) or
4772: nvl(p_dpnt_cvg_end_dt_rl,hr_api.g_number)
4773: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_end_dt_rl,hr_api.g_number) or
4774: nvl(p_dpnt_dsgn_cd,hr_api.g_varchar2)

Line 4771: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_end_dt_cd,hr_api.g_varchar2) or

4767: --
4768: if (l_api_updating
4769: and
4770: (nvl(p_dpnt_cvg_end_dt_cd,hr_api.g_varchar2)
4771: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_end_dt_cd,hr_api.g_varchar2) or
4772: nvl(p_dpnt_cvg_end_dt_rl,hr_api.g_number)
4773: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_end_dt_rl,hr_api.g_number) or
4774: nvl(p_dpnt_dsgn_cd,hr_api.g_varchar2)
4775: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dsgn_cd,hr_api.g_varchar2) or

Line 4772: nvl(p_dpnt_cvg_end_dt_rl,hr_api.g_number)

4768: if (l_api_updating
4769: and
4770: (nvl(p_dpnt_cvg_end_dt_cd,hr_api.g_varchar2)
4771: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_end_dt_cd,hr_api.g_varchar2) or
4772: nvl(p_dpnt_cvg_end_dt_rl,hr_api.g_number)
4773: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_end_dt_rl,hr_api.g_number) or
4774: nvl(p_dpnt_dsgn_cd,hr_api.g_varchar2)
4775: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dsgn_cd,hr_api.g_varchar2) or
4776: nvl(p_dpnt_cvg_strt_dt_cd,hr_api.g_varchar2)

Line 4773: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_end_dt_rl,hr_api.g_number) or

4769: and
4770: (nvl(p_dpnt_cvg_end_dt_cd,hr_api.g_varchar2)
4771: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_end_dt_cd,hr_api.g_varchar2) or
4772: nvl(p_dpnt_cvg_end_dt_rl,hr_api.g_number)
4773: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_end_dt_rl,hr_api.g_number) or
4774: nvl(p_dpnt_dsgn_cd,hr_api.g_varchar2)
4775: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dsgn_cd,hr_api.g_varchar2) or
4776: nvl(p_dpnt_cvg_strt_dt_cd,hr_api.g_varchar2)
4777: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_strt_dt_cd,hr_api.g_varchar2) or

Line 4774: nvl(p_dpnt_dsgn_cd,hr_api.g_varchar2)

4770: (nvl(p_dpnt_cvg_end_dt_cd,hr_api.g_varchar2)
4771: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_end_dt_cd,hr_api.g_varchar2) or
4772: nvl(p_dpnt_cvg_end_dt_rl,hr_api.g_number)
4773: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_end_dt_rl,hr_api.g_number) or
4774: nvl(p_dpnt_dsgn_cd,hr_api.g_varchar2)
4775: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dsgn_cd,hr_api.g_varchar2) or
4776: nvl(p_dpnt_cvg_strt_dt_cd,hr_api.g_varchar2)
4777: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_strt_dt_cd,hr_api.g_varchar2) or
4778: nvl(p_dpnt_cvg_strt_dt_rl,hr_api.g_number)

Line 4775: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dsgn_cd,hr_api.g_varchar2) or

4771: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_end_dt_cd,hr_api.g_varchar2) or
4772: nvl(p_dpnt_cvg_end_dt_rl,hr_api.g_number)
4773: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_end_dt_rl,hr_api.g_number) or
4774: nvl(p_dpnt_dsgn_cd,hr_api.g_varchar2)
4775: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dsgn_cd,hr_api.g_varchar2) or
4776: nvl(p_dpnt_cvg_strt_dt_cd,hr_api.g_varchar2)
4777: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_strt_dt_cd,hr_api.g_varchar2) or
4778: nvl(p_dpnt_cvg_strt_dt_rl,hr_api.g_number)
4779: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_strt_dt_rl,hr_api.g_number) or

Line 4776: nvl(p_dpnt_cvg_strt_dt_cd,hr_api.g_varchar2)

4772: nvl(p_dpnt_cvg_end_dt_rl,hr_api.g_number)
4773: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_end_dt_rl,hr_api.g_number) or
4774: nvl(p_dpnt_dsgn_cd,hr_api.g_varchar2)
4775: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dsgn_cd,hr_api.g_varchar2) or
4776: nvl(p_dpnt_cvg_strt_dt_cd,hr_api.g_varchar2)
4777: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_strt_dt_cd,hr_api.g_varchar2) or
4778: nvl(p_dpnt_cvg_strt_dt_rl,hr_api.g_number)
4779: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_strt_dt_rl,hr_api.g_number) or
4780: nvl(p_dpnt_adrs_rqd_flag,hr_api.g_varchar2)

Line 4777: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_strt_dt_cd,hr_api.g_varchar2) or

4773: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_end_dt_rl,hr_api.g_number) or
4774: nvl(p_dpnt_dsgn_cd,hr_api.g_varchar2)
4775: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dsgn_cd,hr_api.g_varchar2) or
4776: nvl(p_dpnt_cvg_strt_dt_cd,hr_api.g_varchar2)
4777: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_strt_dt_cd,hr_api.g_varchar2) or
4778: nvl(p_dpnt_cvg_strt_dt_rl,hr_api.g_number)
4779: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_strt_dt_rl,hr_api.g_number) or
4780: nvl(p_dpnt_adrs_rqd_flag,hr_api.g_varchar2)
4781: <> nvl(ben_pgm_shd.g_old_rec.dpnt_adrs_rqd_flag,hr_api.g_varchar2) or

Line 4778: nvl(p_dpnt_cvg_strt_dt_rl,hr_api.g_number)

4774: nvl(p_dpnt_dsgn_cd,hr_api.g_varchar2)
4775: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dsgn_cd,hr_api.g_varchar2) or
4776: nvl(p_dpnt_cvg_strt_dt_cd,hr_api.g_varchar2)
4777: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_strt_dt_cd,hr_api.g_varchar2) or
4778: nvl(p_dpnt_cvg_strt_dt_rl,hr_api.g_number)
4779: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_strt_dt_rl,hr_api.g_number) or
4780: nvl(p_dpnt_adrs_rqd_flag,hr_api.g_varchar2)
4781: <> nvl(ben_pgm_shd.g_old_rec.dpnt_adrs_rqd_flag,hr_api.g_varchar2) or
4782: nvl(p_dpnt_dob_rqd_flag,hr_api.g_varchar2)

Line 4779: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_strt_dt_rl,hr_api.g_number) or

4775: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dsgn_cd,hr_api.g_varchar2) or
4776: nvl(p_dpnt_cvg_strt_dt_cd,hr_api.g_varchar2)
4777: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_strt_dt_cd,hr_api.g_varchar2) or
4778: nvl(p_dpnt_cvg_strt_dt_rl,hr_api.g_number)
4779: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_strt_dt_rl,hr_api.g_number) or
4780: nvl(p_dpnt_adrs_rqd_flag,hr_api.g_varchar2)
4781: <> nvl(ben_pgm_shd.g_old_rec.dpnt_adrs_rqd_flag,hr_api.g_varchar2) or
4782: nvl(p_dpnt_dob_rqd_flag,hr_api.g_varchar2)
4783: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dob_rqd_flag,hr_api.g_varchar2) or

Line 4780: nvl(p_dpnt_adrs_rqd_flag,hr_api.g_varchar2)

4776: nvl(p_dpnt_cvg_strt_dt_cd,hr_api.g_varchar2)
4777: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_strt_dt_cd,hr_api.g_varchar2) or
4778: nvl(p_dpnt_cvg_strt_dt_rl,hr_api.g_number)
4779: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_strt_dt_rl,hr_api.g_number) or
4780: nvl(p_dpnt_adrs_rqd_flag,hr_api.g_varchar2)
4781: <> nvl(ben_pgm_shd.g_old_rec.dpnt_adrs_rqd_flag,hr_api.g_varchar2) or
4782: nvl(p_dpnt_dob_rqd_flag,hr_api.g_varchar2)
4783: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dob_rqd_flag,hr_api.g_varchar2) or
4784: nvl(p_dpnt_legv_id_rqd_flag,hr_api.g_varchar2)

Line 4781: <> nvl(ben_pgm_shd.g_old_rec.dpnt_adrs_rqd_flag,hr_api.g_varchar2) or

4777: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_strt_dt_cd,hr_api.g_varchar2) or
4778: nvl(p_dpnt_cvg_strt_dt_rl,hr_api.g_number)
4779: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_strt_dt_rl,hr_api.g_number) or
4780: nvl(p_dpnt_adrs_rqd_flag,hr_api.g_varchar2)
4781: <> nvl(ben_pgm_shd.g_old_rec.dpnt_adrs_rqd_flag,hr_api.g_varchar2) or
4782: nvl(p_dpnt_dob_rqd_flag,hr_api.g_varchar2)
4783: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dob_rqd_flag,hr_api.g_varchar2) or
4784: nvl(p_dpnt_legv_id_rqd_flag,hr_api.g_varchar2)
4785: <> nvl(ben_pgm_shd.g_old_rec.dpnt_legv_id_rqd_flag,hr_api.g_varchar2) or

Line 4782: nvl(p_dpnt_dob_rqd_flag,hr_api.g_varchar2)

4778: nvl(p_dpnt_cvg_strt_dt_rl,hr_api.g_number)
4779: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_strt_dt_rl,hr_api.g_number) or
4780: nvl(p_dpnt_adrs_rqd_flag,hr_api.g_varchar2)
4781: <> nvl(ben_pgm_shd.g_old_rec.dpnt_adrs_rqd_flag,hr_api.g_varchar2) or
4782: nvl(p_dpnt_dob_rqd_flag,hr_api.g_varchar2)
4783: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dob_rqd_flag,hr_api.g_varchar2) or
4784: nvl(p_dpnt_legv_id_rqd_flag,hr_api.g_varchar2)
4785: <> nvl(ben_pgm_shd.g_old_rec.dpnt_legv_id_rqd_flag,hr_api.g_varchar2) or
4786: nvl(p_dpnt_dsgn_no_ctfn_rqd_flag,hr_api.g_varchar2)

Line 4783: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dob_rqd_flag,hr_api.g_varchar2) or

4779: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_strt_dt_rl,hr_api.g_number) or
4780: nvl(p_dpnt_adrs_rqd_flag,hr_api.g_varchar2)
4781: <> nvl(ben_pgm_shd.g_old_rec.dpnt_adrs_rqd_flag,hr_api.g_varchar2) or
4782: nvl(p_dpnt_dob_rqd_flag,hr_api.g_varchar2)
4783: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dob_rqd_flag,hr_api.g_varchar2) or
4784: nvl(p_dpnt_legv_id_rqd_flag,hr_api.g_varchar2)
4785: <> nvl(ben_pgm_shd.g_old_rec.dpnt_legv_id_rqd_flag,hr_api.g_varchar2) or
4786: nvl(p_dpnt_dsgn_no_ctfn_rqd_flag,hr_api.g_varchar2)
4787: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dsgn_no_ctfn_rqd_flag,hr_api.g_varchar2) or

Line 4784: nvl(p_dpnt_legv_id_rqd_flag,hr_api.g_varchar2)

4780: nvl(p_dpnt_adrs_rqd_flag,hr_api.g_varchar2)
4781: <> nvl(ben_pgm_shd.g_old_rec.dpnt_adrs_rqd_flag,hr_api.g_varchar2) or
4782: nvl(p_dpnt_dob_rqd_flag,hr_api.g_varchar2)
4783: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dob_rqd_flag,hr_api.g_varchar2) or
4784: nvl(p_dpnt_legv_id_rqd_flag,hr_api.g_varchar2)
4785: <> nvl(ben_pgm_shd.g_old_rec.dpnt_legv_id_rqd_flag,hr_api.g_varchar2) or
4786: nvl(p_dpnt_dsgn_no_ctfn_rqd_flag,hr_api.g_varchar2)
4787: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dsgn_no_ctfn_rqd_flag,hr_api.g_varchar2) or
4788: nvl(p_drvbl_fctr_dpnt_elig_flag,hr_api.g_varchar2)

Line 4785: <> nvl(ben_pgm_shd.g_old_rec.dpnt_legv_id_rqd_flag,hr_api.g_varchar2) or

4781: <> nvl(ben_pgm_shd.g_old_rec.dpnt_adrs_rqd_flag,hr_api.g_varchar2) or
4782: nvl(p_dpnt_dob_rqd_flag,hr_api.g_varchar2)
4783: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dob_rqd_flag,hr_api.g_varchar2) or
4784: nvl(p_dpnt_legv_id_rqd_flag,hr_api.g_varchar2)
4785: <> nvl(ben_pgm_shd.g_old_rec.dpnt_legv_id_rqd_flag,hr_api.g_varchar2) or
4786: nvl(p_dpnt_dsgn_no_ctfn_rqd_flag,hr_api.g_varchar2)
4787: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dsgn_no_ctfn_rqd_flag,hr_api.g_varchar2) or
4788: nvl(p_drvbl_fctr_dpnt_elig_flag,hr_api.g_varchar2)
4789: <> nvl(ben_pgm_shd.g_old_rec.drvbl_fctr_dpnt_elig_flag,hr_api.g_varchar2)) or

Line 4786: nvl(p_dpnt_dsgn_no_ctfn_rqd_flag,hr_api.g_varchar2)

4782: nvl(p_dpnt_dob_rqd_flag,hr_api.g_varchar2)
4783: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dob_rqd_flag,hr_api.g_varchar2) or
4784: nvl(p_dpnt_legv_id_rqd_flag,hr_api.g_varchar2)
4785: <> nvl(ben_pgm_shd.g_old_rec.dpnt_legv_id_rqd_flag,hr_api.g_varchar2) or
4786: nvl(p_dpnt_dsgn_no_ctfn_rqd_flag,hr_api.g_varchar2)
4787: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dsgn_no_ctfn_rqd_flag,hr_api.g_varchar2) or
4788: nvl(p_drvbl_fctr_dpnt_elig_flag,hr_api.g_varchar2)
4789: <> nvl(ben_pgm_shd.g_old_rec.drvbl_fctr_dpnt_elig_flag,hr_api.g_varchar2)) or
4790: not l_api_updating) then

Line 4787: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dsgn_no_ctfn_rqd_flag,hr_api.g_varchar2) or

4783: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dob_rqd_flag,hr_api.g_varchar2) or
4784: nvl(p_dpnt_legv_id_rqd_flag,hr_api.g_varchar2)
4785: <> nvl(ben_pgm_shd.g_old_rec.dpnt_legv_id_rqd_flag,hr_api.g_varchar2) or
4786: nvl(p_dpnt_dsgn_no_ctfn_rqd_flag,hr_api.g_varchar2)
4787: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dsgn_no_ctfn_rqd_flag,hr_api.g_varchar2) or
4788: nvl(p_drvbl_fctr_dpnt_elig_flag,hr_api.g_varchar2)
4789: <> nvl(ben_pgm_shd.g_old_rec.drvbl_fctr_dpnt_elig_flag,hr_api.g_varchar2)) or
4790: not l_api_updating) then
4791: --

Line 4788: nvl(p_drvbl_fctr_dpnt_elig_flag,hr_api.g_varchar2)

4784: nvl(p_dpnt_legv_id_rqd_flag,hr_api.g_varchar2)
4785: <> nvl(ben_pgm_shd.g_old_rec.dpnt_legv_id_rqd_flag,hr_api.g_varchar2) or
4786: nvl(p_dpnt_dsgn_no_ctfn_rqd_flag,hr_api.g_varchar2)
4787: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dsgn_no_ctfn_rqd_flag,hr_api.g_varchar2) or
4788: nvl(p_drvbl_fctr_dpnt_elig_flag,hr_api.g_varchar2)
4789: <> nvl(ben_pgm_shd.g_old_rec.drvbl_fctr_dpnt_elig_flag,hr_api.g_varchar2)) or
4790: not l_api_updating) then
4791: --
4792: if nvl(p_dpnt_dsgn_cd,'X') not in ('R','O') and

Line 4789: <> nvl(ben_pgm_shd.g_old_rec.drvbl_fctr_dpnt_elig_flag,hr_api.g_varchar2)) or

4785: <> nvl(ben_pgm_shd.g_old_rec.dpnt_legv_id_rqd_flag,hr_api.g_varchar2) or
4786: nvl(p_dpnt_dsgn_no_ctfn_rqd_flag,hr_api.g_varchar2)
4787: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dsgn_no_ctfn_rqd_flag,hr_api.g_varchar2) or
4788: nvl(p_drvbl_fctr_dpnt_elig_flag,hr_api.g_varchar2)
4789: <> nvl(ben_pgm_shd.g_old_rec.drvbl_fctr_dpnt_elig_flag,hr_api.g_varchar2)) or
4790: not l_api_updating) then
4791: --
4792: if nvl(p_dpnt_dsgn_cd,'X') not in ('R','O') and
4793: (p_dpnt_cvg_strt_dt_cd is not null or

Line 4875: and nvl(p_pgm_prvds_no_auto_enrt_flag,hr_api.g_varchar2)

4871: p_object_version_number => p_object_version_number);
4872: --
4873:
4874: if (l_api_updating
4875: and nvl(p_pgm_prvds_no_auto_enrt_flag,hr_api.g_varchar2)
4876: <> nvl(ben_pgm_shd.g_old_rec.pgm_prvds_no_auto_enrt_flag,hr_api.g_varchar2)
4877: or not l_api_updating) then
4878: --
4879: -- If pgm provides no auto enroll flag = 'Y' then enrt mthd code can't be 'A'.

Line 4876: <> nvl(ben_pgm_shd.g_old_rec.pgm_prvds_no_auto_enrt_flag,hr_api.g_varchar2)

4872: --
4873:
4874: if (l_api_updating
4875: and nvl(p_pgm_prvds_no_auto_enrt_flag,hr_api.g_varchar2)
4876: <> nvl(ben_pgm_shd.g_old_rec.pgm_prvds_no_auto_enrt_flag,hr_api.g_varchar2)
4877: or not l_api_updating) then
4878: --
4879: -- If pgm provides no auto enroll flag = 'Y' then enrt mthd code can't be 'A'.
4880: --

Line 4963: and nvl(p_pgm_prvds_no_dflt_enrt_flag,hr_api.g_varchar2)

4959: p_object_version_number => p_object_version_number);
4960: --
4961:
4962: if (l_api_updating
4963: and nvl(p_pgm_prvds_no_dflt_enrt_flag,hr_api.g_varchar2)
4964: <> nvl(ben_pgm_shd.g_old_rec.pgm_prvds_no_dflt_enrt_flag,hr_api.g_varchar2)
4965: or not l_api_updating) then
4966: --
4967: -- If pgm provides no dflt enroll flag = 'Y' dflt fields must be null.

Line 4964: <> nvl(ben_pgm_shd.g_old_rec.pgm_prvds_no_dflt_enrt_flag,hr_api.g_varchar2)

4960: --
4961:
4962: if (l_api_updating
4963: and nvl(p_pgm_prvds_no_dflt_enrt_flag,hr_api.g_varchar2)
4964: <> nvl(ben_pgm_shd.g_old_rec.pgm_prvds_no_dflt_enrt_flag,hr_api.g_varchar2)
4965: or not l_api_updating) then
4966: --
4967: -- If pgm provides no dflt enroll flag = 'Y' dflt fields must be null.
4968: --

Line 5055: and nvl(p_pgm_prvds_no_dflt_enrt_flag,hr_api.g_varchar2)

5051: p_object_version_number => p_object_version_number);
5052: --
5053:
5054: if (l_api_updating
5055: and nvl(p_pgm_prvds_no_dflt_enrt_flag,hr_api.g_varchar2)
5056: <> nvl(ben_pgm_shd.g_old_rec.pgm_prvds_no_dflt_enrt_flag,hr_api.g_varchar2)
5057: or not l_api_updating) then
5058: --
5059: -- If cursor is found then at least one dflt num was found.

Line 5056: <> nvl(ben_pgm_shd.g_old_rec.pgm_prvds_no_dflt_enrt_flag,hr_api.g_varchar2)

5052: --
5053:
5054: if (l_api_updating
5055: and nvl(p_pgm_prvds_no_dflt_enrt_flag,hr_api.g_varchar2)
5056: <> nvl(ben_pgm_shd.g_old_rec.pgm_prvds_no_dflt_enrt_flag,hr_api.g_varchar2)
5057: or not l_api_updating) then
5058: --
5059: -- If cursor is found then at least one dflt num was found.
5060: --

Line 5149: (nvl(p_dpnt_cvg_end_dt_cd,hr_api.g_varchar2)

5145: p_object_version_number => p_object_version_number);
5146: --
5147: if (l_api_updating
5148: and
5149: (nvl(p_dpnt_cvg_end_dt_cd,hr_api.g_varchar2)
5150: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_end_dt_cd,hr_api.g_varchar2) or
5151: nvl(p_dpnt_cvg_end_dt_rl,hr_api.g_number)
5152: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_end_dt_rl,hr_api.g_number) or
5153: nvl(p_dpnt_dsgn_cd,hr_api.g_varchar2)

Line 5150: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_end_dt_cd,hr_api.g_varchar2) or

5146: --
5147: if (l_api_updating
5148: and
5149: (nvl(p_dpnt_cvg_end_dt_cd,hr_api.g_varchar2)
5150: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_end_dt_cd,hr_api.g_varchar2) or
5151: nvl(p_dpnt_cvg_end_dt_rl,hr_api.g_number)
5152: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_end_dt_rl,hr_api.g_number) or
5153: nvl(p_dpnt_dsgn_cd,hr_api.g_varchar2)
5154: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dsgn_cd,hr_api.g_varchar2) or

Line 5151: nvl(p_dpnt_cvg_end_dt_rl,hr_api.g_number)

5147: if (l_api_updating
5148: and
5149: (nvl(p_dpnt_cvg_end_dt_cd,hr_api.g_varchar2)
5150: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_end_dt_cd,hr_api.g_varchar2) or
5151: nvl(p_dpnt_cvg_end_dt_rl,hr_api.g_number)
5152: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_end_dt_rl,hr_api.g_number) or
5153: nvl(p_dpnt_dsgn_cd,hr_api.g_varchar2)
5154: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dsgn_cd,hr_api.g_varchar2) or
5155: nvl(p_dpnt_dsgn_lvl_cd,hr_api.g_varchar2)

Line 5152: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_end_dt_rl,hr_api.g_number) or

5148: and
5149: (nvl(p_dpnt_cvg_end_dt_cd,hr_api.g_varchar2)
5150: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_end_dt_cd,hr_api.g_varchar2) or
5151: nvl(p_dpnt_cvg_end_dt_rl,hr_api.g_number)
5152: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_end_dt_rl,hr_api.g_number) or
5153: nvl(p_dpnt_dsgn_cd,hr_api.g_varchar2)
5154: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dsgn_cd,hr_api.g_varchar2) or
5155: nvl(p_dpnt_dsgn_lvl_cd,hr_api.g_varchar2)
5156: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dsgn_lvl_cd,hr_api.g_varchar2) or

Line 5153: nvl(p_dpnt_dsgn_cd,hr_api.g_varchar2)

5149: (nvl(p_dpnt_cvg_end_dt_cd,hr_api.g_varchar2)
5150: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_end_dt_cd,hr_api.g_varchar2) or
5151: nvl(p_dpnt_cvg_end_dt_rl,hr_api.g_number)
5152: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_end_dt_rl,hr_api.g_number) or
5153: nvl(p_dpnt_dsgn_cd,hr_api.g_varchar2)
5154: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dsgn_cd,hr_api.g_varchar2) or
5155: nvl(p_dpnt_dsgn_lvl_cd,hr_api.g_varchar2)
5156: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dsgn_lvl_cd,hr_api.g_varchar2) or
5157: nvl(p_dpnt_cvg_strt_dt_cd,hr_api.g_varchar2)

Line 5154: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dsgn_cd,hr_api.g_varchar2) or

5150: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_end_dt_cd,hr_api.g_varchar2) or
5151: nvl(p_dpnt_cvg_end_dt_rl,hr_api.g_number)
5152: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_end_dt_rl,hr_api.g_number) or
5153: nvl(p_dpnt_dsgn_cd,hr_api.g_varchar2)
5154: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dsgn_cd,hr_api.g_varchar2) or
5155: nvl(p_dpnt_dsgn_lvl_cd,hr_api.g_varchar2)
5156: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dsgn_lvl_cd,hr_api.g_varchar2) or
5157: nvl(p_dpnt_cvg_strt_dt_cd,hr_api.g_varchar2)
5158: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_strt_dt_cd,hr_api.g_varchar2) or

Line 5155: nvl(p_dpnt_dsgn_lvl_cd,hr_api.g_varchar2)

5151: nvl(p_dpnt_cvg_end_dt_rl,hr_api.g_number)
5152: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_end_dt_rl,hr_api.g_number) or
5153: nvl(p_dpnt_dsgn_cd,hr_api.g_varchar2)
5154: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dsgn_cd,hr_api.g_varchar2) or
5155: nvl(p_dpnt_dsgn_lvl_cd,hr_api.g_varchar2)
5156: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dsgn_lvl_cd,hr_api.g_varchar2) or
5157: nvl(p_dpnt_cvg_strt_dt_cd,hr_api.g_varchar2)
5158: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_strt_dt_cd,hr_api.g_varchar2) or
5159: nvl(p_dpnt_cvg_strt_dt_rl,hr_api.g_number)

Line 5156: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dsgn_lvl_cd,hr_api.g_varchar2) or

5152: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_end_dt_rl,hr_api.g_number) or
5153: nvl(p_dpnt_dsgn_cd,hr_api.g_varchar2)
5154: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dsgn_cd,hr_api.g_varchar2) or
5155: nvl(p_dpnt_dsgn_lvl_cd,hr_api.g_varchar2)
5156: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dsgn_lvl_cd,hr_api.g_varchar2) or
5157: nvl(p_dpnt_cvg_strt_dt_cd,hr_api.g_varchar2)
5158: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_strt_dt_cd,hr_api.g_varchar2) or
5159: nvl(p_dpnt_cvg_strt_dt_rl,hr_api.g_number)
5160: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_strt_dt_rl,hr_api.g_number) or

Line 5157: nvl(p_dpnt_cvg_strt_dt_cd,hr_api.g_varchar2)

5153: nvl(p_dpnt_dsgn_cd,hr_api.g_varchar2)
5154: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dsgn_cd,hr_api.g_varchar2) or
5155: nvl(p_dpnt_dsgn_lvl_cd,hr_api.g_varchar2)
5156: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dsgn_lvl_cd,hr_api.g_varchar2) or
5157: nvl(p_dpnt_cvg_strt_dt_cd,hr_api.g_varchar2)
5158: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_strt_dt_cd,hr_api.g_varchar2) or
5159: nvl(p_dpnt_cvg_strt_dt_rl,hr_api.g_number)
5160: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_strt_dt_rl,hr_api.g_number) or
5161: nvl(p_dpnt_adrs_rqd_flag ,hr_api.g_varchar2)

Line 5158: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_strt_dt_cd,hr_api.g_varchar2) or

5154: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dsgn_cd,hr_api.g_varchar2) or
5155: nvl(p_dpnt_dsgn_lvl_cd,hr_api.g_varchar2)
5156: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dsgn_lvl_cd,hr_api.g_varchar2) or
5157: nvl(p_dpnt_cvg_strt_dt_cd,hr_api.g_varchar2)
5158: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_strt_dt_cd,hr_api.g_varchar2) or
5159: nvl(p_dpnt_cvg_strt_dt_rl,hr_api.g_number)
5160: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_strt_dt_rl,hr_api.g_number) or
5161: nvl(p_dpnt_adrs_rqd_flag ,hr_api.g_varchar2)
5162: <> nvl(ben_pgm_shd.g_old_rec.dpnt_adrs_rqd_flag ,hr_api.g_varchar2) or

Line 5159: nvl(p_dpnt_cvg_strt_dt_rl,hr_api.g_number)

5155: nvl(p_dpnt_dsgn_lvl_cd,hr_api.g_varchar2)
5156: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dsgn_lvl_cd,hr_api.g_varchar2) or
5157: nvl(p_dpnt_cvg_strt_dt_cd,hr_api.g_varchar2)
5158: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_strt_dt_cd,hr_api.g_varchar2) or
5159: nvl(p_dpnt_cvg_strt_dt_rl,hr_api.g_number)
5160: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_strt_dt_rl,hr_api.g_number) or
5161: nvl(p_dpnt_adrs_rqd_flag ,hr_api.g_varchar2)
5162: <> nvl(ben_pgm_shd.g_old_rec.dpnt_adrs_rqd_flag ,hr_api.g_varchar2) or
5163: nvl(p_dpnt_dob_rqd_flag ,hr_api.g_varchar2)

Line 5160: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_strt_dt_rl,hr_api.g_number) or

5156: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dsgn_lvl_cd,hr_api.g_varchar2) or
5157: nvl(p_dpnt_cvg_strt_dt_cd,hr_api.g_varchar2)
5158: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_strt_dt_cd,hr_api.g_varchar2) or
5159: nvl(p_dpnt_cvg_strt_dt_rl,hr_api.g_number)
5160: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_strt_dt_rl,hr_api.g_number) or
5161: nvl(p_dpnt_adrs_rqd_flag ,hr_api.g_varchar2)
5162: <> nvl(ben_pgm_shd.g_old_rec.dpnt_adrs_rqd_flag ,hr_api.g_varchar2) or
5163: nvl(p_dpnt_dob_rqd_flag ,hr_api.g_varchar2)
5164: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dob_rqd_flag ,hr_api.g_varchar2) or

Line 5161: nvl(p_dpnt_adrs_rqd_flag ,hr_api.g_varchar2)

5157: nvl(p_dpnt_cvg_strt_dt_cd,hr_api.g_varchar2)
5158: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_strt_dt_cd,hr_api.g_varchar2) or
5159: nvl(p_dpnt_cvg_strt_dt_rl,hr_api.g_number)
5160: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_strt_dt_rl,hr_api.g_number) or
5161: nvl(p_dpnt_adrs_rqd_flag ,hr_api.g_varchar2)
5162: <> nvl(ben_pgm_shd.g_old_rec.dpnt_adrs_rqd_flag ,hr_api.g_varchar2) or
5163: nvl(p_dpnt_dob_rqd_flag ,hr_api.g_varchar2)
5164: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dob_rqd_flag ,hr_api.g_varchar2) or
5165: nvl(p_dpnt_legv_id_rqd_flag,hr_api.g_varchar2)

Line 5162: <> nvl(ben_pgm_shd.g_old_rec.dpnt_adrs_rqd_flag ,hr_api.g_varchar2) or

5158: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_strt_dt_cd,hr_api.g_varchar2) or
5159: nvl(p_dpnt_cvg_strt_dt_rl,hr_api.g_number)
5160: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_strt_dt_rl,hr_api.g_number) or
5161: nvl(p_dpnt_adrs_rqd_flag ,hr_api.g_varchar2)
5162: <> nvl(ben_pgm_shd.g_old_rec.dpnt_adrs_rqd_flag ,hr_api.g_varchar2) or
5163: nvl(p_dpnt_dob_rqd_flag ,hr_api.g_varchar2)
5164: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dob_rqd_flag ,hr_api.g_varchar2) or
5165: nvl(p_dpnt_legv_id_rqd_flag,hr_api.g_varchar2)
5166: <> nvl(ben_pgm_shd.g_old_rec.dpnt_legv_id_rqd_flag,hr_api.g_varchar2) or

Line 5163: nvl(p_dpnt_dob_rqd_flag ,hr_api.g_varchar2)

5159: nvl(p_dpnt_cvg_strt_dt_rl,hr_api.g_number)
5160: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_strt_dt_rl,hr_api.g_number) or
5161: nvl(p_dpnt_adrs_rqd_flag ,hr_api.g_varchar2)
5162: <> nvl(ben_pgm_shd.g_old_rec.dpnt_adrs_rqd_flag ,hr_api.g_varchar2) or
5163: nvl(p_dpnt_dob_rqd_flag ,hr_api.g_varchar2)
5164: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dob_rqd_flag ,hr_api.g_varchar2) or
5165: nvl(p_dpnt_legv_id_rqd_flag,hr_api.g_varchar2)
5166: <> nvl(ben_pgm_shd.g_old_rec.dpnt_legv_id_rqd_flag,hr_api.g_varchar2) or
5167: nvl(p_dpnt_dsgn_no_ctfn_rqd_flag,hr_api.g_varchar2)

Line 5164: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dob_rqd_flag ,hr_api.g_varchar2) or

5160: <> nvl(ben_pgm_shd.g_old_rec.dpnt_cvg_strt_dt_rl,hr_api.g_number) or
5161: nvl(p_dpnt_adrs_rqd_flag ,hr_api.g_varchar2)
5162: <> nvl(ben_pgm_shd.g_old_rec.dpnt_adrs_rqd_flag ,hr_api.g_varchar2) or
5163: nvl(p_dpnt_dob_rqd_flag ,hr_api.g_varchar2)
5164: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dob_rqd_flag ,hr_api.g_varchar2) or
5165: nvl(p_dpnt_legv_id_rqd_flag,hr_api.g_varchar2)
5166: <> nvl(ben_pgm_shd.g_old_rec.dpnt_legv_id_rqd_flag,hr_api.g_varchar2) or
5167: nvl(p_dpnt_dsgn_no_ctfn_rqd_flag,hr_api.g_varchar2)
5168: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dsgn_no_ctfn_rqd_flag,hr_api.g_varchar2) or

Line 5165: nvl(p_dpnt_legv_id_rqd_flag,hr_api.g_varchar2)

5161: nvl(p_dpnt_adrs_rqd_flag ,hr_api.g_varchar2)
5162: <> nvl(ben_pgm_shd.g_old_rec.dpnt_adrs_rqd_flag ,hr_api.g_varchar2) or
5163: nvl(p_dpnt_dob_rqd_flag ,hr_api.g_varchar2)
5164: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dob_rqd_flag ,hr_api.g_varchar2) or
5165: nvl(p_dpnt_legv_id_rqd_flag,hr_api.g_varchar2)
5166: <> nvl(ben_pgm_shd.g_old_rec.dpnt_legv_id_rqd_flag,hr_api.g_varchar2) or
5167: nvl(p_dpnt_dsgn_no_ctfn_rqd_flag,hr_api.g_varchar2)
5168: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dsgn_no_ctfn_rqd_flag,hr_api.g_varchar2) or
5169: nvl(p_drvbl_fctr_dpnt_elig_flag,hr_api.g_varchar2)

Line 5166: <> nvl(ben_pgm_shd.g_old_rec.dpnt_legv_id_rqd_flag,hr_api.g_varchar2) or

5162: <> nvl(ben_pgm_shd.g_old_rec.dpnt_adrs_rqd_flag ,hr_api.g_varchar2) or
5163: nvl(p_dpnt_dob_rqd_flag ,hr_api.g_varchar2)
5164: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dob_rqd_flag ,hr_api.g_varchar2) or
5165: nvl(p_dpnt_legv_id_rqd_flag,hr_api.g_varchar2)
5166: <> nvl(ben_pgm_shd.g_old_rec.dpnt_legv_id_rqd_flag,hr_api.g_varchar2) or
5167: nvl(p_dpnt_dsgn_no_ctfn_rqd_flag,hr_api.g_varchar2)
5168: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dsgn_no_ctfn_rqd_flag,hr_api.g_varchar2) or
5169: nvl(p_drvbl_fctr_dpnt_elig_flag,hr_api.g_varchar2)
5170: <> nvl(ben_pgm_shd.g_old_rec.drvbl_fctr_dpnt_elig_flag,hr_api.g_varchar2) or

Line 5167: nvl(p_dpnt_dsgn_no_ctfn_rqd_flag,hr_api.g_varchar2)

5163: nvl(p_dpnt_dob_rqd_flag ,hr_api.g_varchar2)
5164: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dob_rqd_flag ,hr_api.g_varchar2) or
5165: nvl(p_dpnt_legv_id_rqd_flag,hr_api.g_varchar2)
5166: <> nvl(ben_pgm_shd.g_old_rec.dpnt_legv_id_rqd_flag,hr_api.g_varchar2) or
5167: nvl(p_dpnt_dsgn_no_ctfn_rqd_flag,hr_api.g_varchar2)
5168: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dsgn_no_ctfn_rqd_flag,hr_api.g_varchar2) or
5169: nvl(p_drvbl_fctr_dpnt_elig_flag,hr_api.g_varchar2)
5170: <> nvl(ben_pgm_shd.g_old_rec.drvbl_fctr_dpnt_elig_flag,hr_api.g_varchar2) or
5171: not l_api_updating)) then

Line 5168: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dsgn_no_ctfn_rqd_flag,hr_api.g_varchar2) or

5164: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dob_rqd_flag ,hr_api.g_varchar2) or
5165: nvl(p_dpnt_legv_id_rqd_flag,hr_api.g_varchar2)
5166: <> nvl(ben_pgm_shd.g_old_rec.dpnt_legv_id_rqd_flag,hr_api.g_varchar2) or
5167: nvl(p_dpnt_dsgn_no_ctfn_rqd_flag,hr_api.g_varchar2)
5168: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dsgn_no_ctfn_rqd_flag,hr_api.g_varchar2) or
5169: nvl(p_drvbl_fctr_dpnt_elig_flag,hr_api.g_varchar2)
5170: <> nvl(ben_pgm_shd.g_old_rec.drvbl_fctr_dpnt_elig_flag,hr_api.g_varchar2) or
5171: not l_api_updating)) then
5172: --

Line 5169: nvl(p_drvbl_fctr_dpnt_elig_flag,hr_api.g_varchar2)

5165: nvl(p_dpnt_legv_id_rqd_flag,hr_api.g_varchar2)
5166: <> nvl(ben_pgm_shd.g_old_rec.dpnt_legv_id_rqd_flag,hr_api.g_varchar2) or
5167: nvl(p_dpnt_dsgn_no_ctfn_rqd_flag,hr_api.g_varchar2)
5168: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dsgn_no_ctfn_rqd_flag,hr_api.g_varchar2) or
5169: nvl(p_drvbl_fctr_dpnt_elig_flag,hr_api.g_varchar2)
5170: <> nvl(ben_pgm_shd.g_old_rec.drvbl_fctr_dpnt_elig_flag,hr_api.g_varchar2) or
5171: not l_api_updating)) then
5172: --
5173: if nvl(p_dpnt_dsgn_lvl_cd,'X') not in ('PGM') and

Line 5170: <> nvl(ben_pgm_shd.g_old_rec.drvbl_fctr_dpnt_elig_flag,hr_api.g_varchar2) or

5166: <> nvl(ben_pgm_shd.g_old_rec.dpnt_legv_id_rqd_flag,hr_api.g_varchar2) or
5167: nvl(p_dpnt_dsgn_no_ctfn_rqd_flag,hr_api.g_varchar2)
5168: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dsgn_no_ctfn_rqd_flag,hr_api.g_varchar2) or
5169: nvl(p_drvbl_fctr_dpnt_elig_flag,hr_api.g_varchar2)
5170: <> nvl(ben_pgm_shd.g_old_rec.drvbl_fctr_dpnt_elig_flag,hr_api.g_varchar2) or
5171: not l_api_updating)) then
5172: --
5173: if nvl(p_dpnt_dsgn_lvl_cd,'X') not in ('PGM') and
5174: (p_dpnt_dsgn_cd is not null or

Line 5273: and nvl(p_dpnt_dsgn_cd,hr_api.g_varchar2)

5269: p_object_version_number => p_object_version_number);
5270: --
5271:
5272: if (l_api_updating
5273: and nvl(p_dpnt_dsgn_cd,hr_api.g_varchar2)
5274: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dsgn_cd,hr_api.g_varchar2)
5275: or not l_api_updating) then
5276: null;
5277: --

Line 5274: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dsgn_cd,hr_api.g_varchar2)

5270: --
5271:
5272: if (l_api_updating
5273: and nvl(p_dpnt_dsgn_cd,hr_api.g_varchar2)
5274: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dsgn_cd,hr_api.g_varchar2)
5275: or not l_api_updating) then
5276: null;
5277: --
5278: -- If ldc records exists and designation is null then error

Line 5411: and nvl(p_dpnt_dsgn_lvl_cd,hr_api.g_varchar2)

5407: p_object_version_number => p_object_version_number);
5408: --
5409:
5410: if (l_api_updating
5411: and nvl(p_dpnt_dsgn_lvl_cd,hr_api.g_varchar2)
5412: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dsgn_lvl_cd,hr_api.g_varchar2)
5413: or not l_api_updating) then
5414: null;
5415: --

Line 5412: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dsgn_lvl_cd,hr_api.g_varchar2)

5408: --
5409:
5410: if (l_api_updating
5411: and nvl(p_dpnt_dsgn_lvl_cd,hr_api.g_varchar2)
5412: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dsgn_lvl_cd,hr_api.g_varchar2)
5413: or not l_api_updating) then
5414: null;
5415: --
5416: -- If ldc records exists and designation level not 'PGM' then error

Line 5536: and nvl(p_dpnt_dsgn_lvl_cd,hr_api.g_varchar2)

5532: p_object_version_number => p_object_version_number);
5533: --
5534:
5535: if (l_api_updating
5536: and nvl(p_dpnt_dsgn_lvl_cd,hr_api.g_varchar2)
5537: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dsgn_lvl_cd,hr_api.g_varchar2)
5538: or not l_api_updating) then
5539: --
5540: -- If dsgn_lvl not = PTIP and cursor found then error.

Line 5537: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dsgn_lvl_cd,hr_api.g_varchar2)

5533: --
5534:
5535: if (l_api_updating
5536: and nvl(p_dpnt_dsgn_lvl_cd,hr_api.g_varchar2)
5537: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dsgn_lvl_cd,hr_api.g_varchar2)
5538: or not l_api_updating) then
5539: --
5540: -- If dsgn_lvl not = PTIP and cursor found then error.
5541: --

Line 5649: and nvl(p_dpnt_dsgn_lvl_cd,hr_api.g_varchar2)

5645: p_object_version_number => p_object_version_number);
5646: --
5647:
5648: if (l_api_updating
5649: and nvl(p_dpnt_dsgn_lvl_cd,hr_api.g_varchar2)
5650: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dsgn_lvl_cd,hr_api.g_varchar2)
5651: or not l_api_updating) then null;
5652: --
5653: -- If ldc records exists and designation level not 'PTIP' then error

Line 5650: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dsgn_lvl_cd,hr_api.g_varchar2)

5646: --
5647:
5648: if (l_api_updating
5649: and nvl(p_dpnt_dsgn_lvl_cd,hr_api.g_varchar2)
5650: <> nvl(ben_pgm_shd.g_old_rec.dpnt_dsgn_lvl_cd,hr_api.g_varchar2)
5651: or not l_api_updating) then null;
5652: --
5653: -- If ldc records exists and designation level not 'PTIP' then error
5654: --

Line 5757: p_enrt_cd <> nvl(ben_pgm_shd.g_old_rec.enrt_cd,hr_api.g_varchar2)

5753: p_object_version_number => p_object_version_number);
5754: --
5755: if (l_api_updating
5756: and (
5757: p_enrt_cd <> nvl(ben_pgm_shd.g_old_rec.enrt_cd,hr_api.g_varchar2)
5758: or p_pgm_typ_cd <> nvl(ben_pgm_shd.g_old_rec.pgm_typ_cd,hr_api.g_varchar2)
5759: )
5760: or not l_api_updating)
5761: and p_enrt_cd is not null then

Line 5758: or p_pgm_typ_cd <> nvl(ben_pgm_shd.g_old_rec.pgm_typ_cd,hr_api.g_varchar2)

5754: --
5755: if (l_api_updating
5756: and (
5757: p_enrt_cd <> nvl(ben_pgm_shd.g_old_rec.enrt_cd,hr_api.g_varchar2)
5758: or p_pgm_typ_cd <> nvl(ben_pgm_shd.g_old_rec.pgm_typ_cd,hr_api.g_varchar2)
5759: )
5760: or not l_api_updating)
5761: and p_enrt_cd is not null then
5762: --

Line 5815: (p_dpnt_cvg_strt_dt_rl in number default hr_api.g_number,

5811: --
5812: -- {End Of Comments}
5813: -- ----------------------------------------------------------------------------
5814: Procedure dt_update_validate
5815: (p_dpnt_cvg_strt_dt_rl in number default hr_api.g_number,
5816: p_dpnt_cvg_end_dt_rl in number default hr_api.g_number,
5817: p_datetrack_mode in varchar2,
5818: p_enrt_cvg_strt_dt_rl in number,
5819: p_enrt_cvg_end_dt_rl in number,

Line 5816: p_dpnt_cvg_end_dt_rl in number default hr_api.g_number,

5812: -- {End Of Comments}
5813: -- ----------------------------------------------------------------------------
5814: Procedure dt_update_validate
5815: (p_dpnt_cvg_strt_dt_rl in number default hr_api.g_number,
5816: p_dpnt_cvg_end_dt_rl in number default hr_api.g_number,
5817: p_datetrack_mode in varchar2,
5818: p_enrt_cvg_strt_dt_rl in number,
5819: p_enrt_cvg_end_dt_rl in number,
5820: p_validation_start_date in date,

Line 5832: hr_api.mandatory_arg_error

5828: hr_utility.set_location('Entering:'||l_proc, 5);
5829: --
5830: -- Ensure that the p_datetrack_mode argument is not null
5831: --
5832: hr_api.mandatory_arg_error
5833: (p_api_name => l_proc,
5834: p_argument => 'datetrack_mode',
5835: p_argument_value => p_datetrack_mode);
5836: --

Line 5844: hr_api.mandatory_arg_error

5840: --
5841: --
5842: -- Ensure the arguments are not null
5843: --
5844: hr_api.mandatory_arg_error
5845: (p_api_name => l_proc,
5846: p_argument => 'validation_start_date',
5847: p_argument_value => p_validation_start_date);
5848: --

Line 5849: hr_api.mandatory_arg_error

5845: (p_api_name => l_proc,
5846: p_argument => 'validation_start_date',
5847: p_argument_value => p_validation_start_date);
5848: --
5849: hr_api.mandatory_arg_error
5850: (p_api_name => l_proc,
5851: p_argument => 'validation_end_date',
5852: p_argument_value => p_validation_end_date);
5853: --

Line 5855: If ((nvl(p_enrt_cvg_end_dt_rl, hr_api.g_number) <> hr_api.g_number) and

5851: p_argument => 'validation_end_date',
5852: p_argument_value => p_validation_end_date);
5853: --
5854:
5855: If ((nvl(p_enrt_cvg_end_dt_rl, hr_api.g_number) <> hr_api.g_number) and
5856: NOT (dt_api.check_min_max_dates
5857: (p_base_table_name => 'ff_formulas_f',
5858: p_base_key_column => 'formula_id',
5859: p_base_key_value => p_enrt_cvg_end_dt_rl,

Line 5865: If ((nvl(p_enrt_cvg_strt_dt_rl, hr_api.g_number) <> hr_api.g_number) and

5861: p_to_date => p_validation_end_date))) Then
5862: l_table_name := 'ff_formulas_f';
5863: Raise l_integrity_error;
5864: End If;
5865: If ((nvl(p_enrt_cvg_strt_dt_rl, hr_api.g_number) <> hr_api.g_number) and
5866: NOT (dt_api.check_min_max_dates
5867: (p_base_table_name => 'ff_formulas_f',
5868: p_base_key_column => 'formula_id',
5869: p_base_key_value => p_enrt_cvg_strt_dt_rl,

Line 5875: If ((nvl(p_dpnt_cvg_strt_dt_rl, hr_api.g_number) <> hr_api.g_number) and

5871: p_to_date => p_validation_end_date))) Then
5872: l_table_name := 'ff_formulas_f';
5873: Raise l_integrity_error;
5874: End If;
5875: If ((nvl(p_dpnt_cvg_strt_dt_rl, hr_api.g_number) <> hr_api.g_number) and
5876: NOT (dt_api.check_min_max_dates
5877: (p_base_table_name => 'ff_formulas_f',
5878: p_base_key_column => 'formula_id',
5879: p_base_key_value => p_dpnt_cvg_strt_dt_rl,

Line 5885: If ((nvl(p_dpnt_cvg_end_dt_rl, hr_api.g_number) <> hr_api.g_number) and

5881: p_to_date => p_validation_end_date))) Then
5882: l_table_name := 'ff_formulas_f';
5883: Raise l_integrity_error;
5884: End If;
5885: If ((nvl(p_dpnt_cvg_end_dt_rl, hr_api.g_number) <> hr_api.g_number) and
5886: NOT (dt_api.check_min_max_dates
5887: (p_base_table_name => 'ff_formulas_f',
5888: p_base_key_column => 'formula_id',
5889: p_base_key_value => p_dpnt_cvg_end_dt_rl,

Line 5896: If ((nvl(p_prtn_end_dt_rl, hr_api.g_number) <> hr_api.g_number) and

5892: l_table_name := 'ff_formulas_f';
5893: Raise l_integrity_error;
5894: End If;
5895: /*
5896: If ((nvl(p_prtn_end_dt_rl, hr_api.g_number) <> hr_api.g_number) and
5897: NOT (dt_api.check_min_max_dates
5898: (p_base_table_name => 'ff_formulas_f',
5899: p_base_key_column => 'formula_id',
5900: p_base_key_value => p_prtn_end_dt_rl,

Line 5906: If ((nvl(p_prtn_strt_dt_rl, hr_api.g_number) <> hr_api.g_number) and

5902: p_to_date => p_validation_end_date))) Then
5903: l_table_name := 'ff_formulas_f';
5904: Raise l_integrity_error;
5905: End If;
5906: If ((nvl(p_prtn_strt_dt_rl, hr_api.g_number) <> hr_api.g_number) and
5907: NOT (dt_api.check_min_max_dates
5908: (p_base_table_name => 'ff_formulas_f',
5909: p_base_key_column => 'formula_id',
5910: p_base_key_value => p_prtn_strt_dt_rl,

Line 5996: hr_api.mandatory_arg_error

5992: hr_utility.set_location('Entering:'||l_proc, 5);
5993: --
5994: -- Ensure that the p_datetrack_mode argument is not null
5995: --
5996: hr_api.mandatory_arg_error
5997: (p_api_name => l_proc,
5998: p_argument => 'datetrack_mode',
5999: p_argument_value => p_datetrack_mode);
6000: --

Line 6010: hr_api.mandatory_arg_error

6006: --
6007: --
6008: -- Ensure the arguments are not null
6009: --
6010: hr_api.mandatory_arg_error
6011: (p_api_name => l_proc,
6012: p_argument => 'validation_start_date',
6013: p_argument_value => p_validation_start_date);
6014: --

Line 6015: hr_api.mandatory_arg_error

6011: (p_api_name => l_proc,
6012: p_argument => 'validation_start_date',
6013: p_argument_value => p_validation_start_date);
6014: --
6015: hr_api.mandatory_arg_error
6016: (p_api_name => l_proc,
6017: p_argument => 'validation_end_date',
6018: p_argument_value => p_validation_end_date);
6019: --

Line 6020: hr_api.mandatory_arg_error

6016: (p_api_name => l_proc,
6017: p_argument => 'validation_end_date',
6018: p_argument_value => p_validation_end_date);
6019: --
6020: hr_api.mandatory_arg_error
6021: (p_api_name => l_proc,
6022: p_argument => 'pgm_id',
6023: p_argument_value => p_pgm_id);
6024: --

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

6712: p_object_version_number => p_rec.object_version_number);
6713:
6714: --
6715: if p_rec.business_group_id is not null and p_rec.legislation_code is null then
6716: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
6717: end if;
6718: --
6719: hr_utility.set_location(' Leaving:'||l_proc, 10);
6720: End insert_validate;

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

6737: -- Call all supporting business operations
6738: --
6739: --
6740: if p_rec.business_group_id is not null and p_rec.legislation_code is null then
6741: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
6742: end if;
6743: --
6744: chk_pgm_id
6745: (p_pgm_id => p_rec.pgm_id,

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

7287: hr_utility.set_location('Entering:'|| l_proc, 10);
7288: --
7289: -- Ensure that all the mandatory parameter are not null
7290: --
7291: hr_api.mandatory_arg_error(p_api_name => l_proc,
7292: p_argument => 'pgm_id',
7293: p_argument_value => p_pgm_id);
7294: --
7295: open csr_leg_code;