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_ABR_BUS dependencies on HR_API

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

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

Line 413: <> nvl(ben_abr_shd.g_old_rec.ordr_num,hr_api.g_number)

409: p_object_version_number => p_object_version_number);
410: --
411: if (l_api_updating
412: and p_ordr_num
413: <> nvl(ben_abr_shd.g_old_rec.ordr_num,hr_api.g_number)
414: or not l_api_updating)
415: and p_ordr_num is not null then
416: --
417: -- check if value of lookup falls within lookup type.

Line 419: if hr_api.not_exists_in_hr_lookups

415: and p_ordr_num is not null then
416: --
417: -- check if value of lookup falls within lookup type.
418: --
419: if hr_api.not_exists_in_hr_lookups
420: (p_lookup_type => 'BEN_RT_ORDR_NUM',
421: p_lookup_code => to_char(p_ordr_num),
422: p_effective_date => p_effective_date) then
423: --

Line 514: and nvl(p_input_va_calc_rl,hr_api.g_number)

510: p_effective_date => p_effective_date,
511: p_object_version_number => p_object_version_number);
512: --
513: if (l_api_updating
514: and nvl(p_input_va_calc_rl,hr_api.g_number)
515: <> nvl(ben_abr_shd.g_old_rec.input_va_calc_rl,hr_api.g_number)
516: )
517: then
518: open c1;

Line 515: <> nvl(ben_abr_shd.g_old_rec.input_va_calc_rl,hr_api.g_number)

511: p_object_version_number => p_object_version_number);
512: --
513: if (l_api_updating
514: and nvl(p_input_va_calc_rl,hr_api.g_number)
515: <> nvl(ben_abr_shd.g_old_rec.input_va_calc_rl,hr_api.g_number)
516: )
517: then
518: open c1;
519: fetch c1 into l_dummy;

Line 1111: and nvl(p_prtl_mo_det_mthd_rl,hr_api.g_number)

1107: p_effective_date => p_effective_date,
1108: p_object_version_number => p_object_version_number);
1109: --
1110: if (l_api_updating
1111: and nvl(p_prtl_mo_det_mthd_rl,hr_api.g_number)
1112: <> ben_abr_shd.g_old_rec.prtl_mo_det_mthd_rl
1113: or not l_api_updating)
1114: and p_prtl_mo_det_mthd_rl is not null then
1115: --

Line 1140: if nvl(p_prtl_mo_det_mthd_cd,hr_api.g_varchar2) <> 'RL'

1136: --
1137: --
1138: -- Unless Partial Month Determination Method Code = Rule,
1139: -- Partial Month Determination Method rule must be blank.
1140: if nvl(p_prtl_mo_det_mthd_cd,hr_api.g_varchar2) <> 'RL'
1141: and p_prtl_mo_det_mthd_rl is not null then
1142: --
1143: fnd_message.set_name('BEN', 'BEN_91432_PMD_RL_NOT_NULL');
1144: fnd_message.raise_error;

Line 1146: elsif nvl(p_prtl_mo_det_mthd_cd,hr_api.g_varchar2) = 'RL'

1142: --
1143: fnd_message.set_name('BEN', 'BEN_91432_PMD_RL_NOT_NULL');
1144: fnd_message.raise_error;
1145: --
1146: elsif nvl(p_prtl_mo_det_mthd_cd,hr_api.g_varchar2) = 'RL'
1147: and p_prtl_mo_det_mthd_rl is null then
1148: --
1149: fnd_message.set_name('BEN', 'BEN_91434_PMD_RL_NULL');
1150: fnd_message.raise_error;

Line 1157: and nvl(p_prtl_mo_eff_dt_det_rl,hr_api.g_number)

1153: --
1154: end if;
1155: --
1156: if (l_api_updating
1157: and nvl(p_prtl_mo_eff_dt_det_rl,hr_api.g_number)
1158: <> ben_abr_shd.g_old_rec.prtl_mo_eff_dt_det_rl
1159: or not l_api_updating)
1160: and p_prtl_mo_eff_dt_det_rl is not null then
1161: --

Line 1186: if nvl(p_prtl_mo_eff_dt_det_cd,hr_api.g_varchar2) <> 'RL'

1182: --
1183: --
1184: -- Unless Partial Month Effective Date Determination Code = Rule,
1185: -- Partial Month Effective Date Determination rule must be blank.
1186: if nvl(p_prtl_mo_eff_dt_det_cd,hr_api.g_varchar2) <> 'RL'
1187: and p_prtl_mo_eff_dt_det_rl is not null then
1188: --
1189: fnd_message.set_name('BEN', 'BEN_91433_PMEDD_RL_NOT_NULL');
1190: fnd_message.raise_error;

Line 1192: elsif nvl(p_prtl_mo_eff_dt_det_cd,hr_api.g_varchar2) = 'RL'

1188: --
1189: fnd_message.set_name('BEN', 'BEN_91433_PMEDD_RL_NOT_NULL');
1190: fnd_message.raise_error;
1191: --
1192: elsif nvl(p_prtl_mo_eff_dt_det_cd,hr_api.g_varchar2) = 'RL'
1193: and p_prtl_mo_eff_dt_det_rl is null then
1194: --
1195: fnd_message.set_name('BEN', 'BEN_91435_PMEDD_RL_NULL');
1196: fnd_message.raise_error;

Line 1203: and nvl(p_rndg_rl,hr_api.g_number)

1199: --
1200: end if;
1201: --
1202: if (l_api_updating
1203: and nvl(p_rndg_rl,hr_api.g_number)
1204: <> ben_abr_shd.g_old_rec.rndg_rl
1205: or not l_api_updating)
1206: and p_rndg_rl is not null then
1207: --

Line 1231: if nvl(p_rndg_cd,hr_api.g_varchar2) <> 'RL' and p_rndg_rl is not null then

1227: close c1;
1228: --
1229: --
1230: -- Unless Rounding Code = Rule, Rounding rule must be blank.
1231: if nvl(p_rndg_cd,hr_api.g_varchar2) <> 'RL' and p_rndg_rl is not null then
1232: --
1233: fnd_message.set_name('BEN','BEN_91043_RNDG_RL_NOT_NULL');
1234: fnd_message.raise_error;
1235: --

Line 1236: elsif nvl(p_rndg_cd,hr_api.g_varchar2) = 'RL' and p_rndg_rl is null then

1232: --
1233: fnd_message.set_name('BEN','BEN_91043_RNDG_RL_NOT_NULL');
1234: fnd_message.raise_error;
1235: --
1236: elsif nvl(p_rndg_cd,hr_api.g_varchar2) = 'RL' and p_rndg_rl is null then
1237: --
1238: fnd_message.set_name('BEN','BEN_92340_RNDG_RL_NULL');
1239: fnd_message.raise_error;
1240: --

Line 1246: and nvl(p_lwr_lmt_calc_rl,hr_api.g_number)

1242: --
1243: end if;
1244: --
1245: if (l_api_updating
1246: and nvl(p_lwr_lmt_calc_rl,hr_api.g_number)
1247: <> ben_abr_shd.g_old_rec.lwr_lmt_calc_rl
1248: or not l_api_updating)
1249: and p_lwr_lmt_calc_rl is not null then
1250: --

Line 1275: and nvl(p_upr_lmt_calc_rl,hr_api.g_number)

1271: --
1272: end if;
1273: --
1274: if (l_api_updating
1275: and nvl(p_upr_lmt_calc_rl,hr_api.g_number)
1276: <> ben_abr_shd.g_old_rec.upr_lmt_calc_rl
1277: or not l_api_updating)
1278: and p_upr_lmt_calc_rl is not null then
1279: --

Line 1304: and nvl(p_val_calc_rl,hr_api.g_number)

1300: --
1301: end if;
1302: --
1303: if (l_api_updating
1304: and nvl(p_val_calc_rl,hr_api.g_number)
1305: <> ben_abr_shd.g_old_rec.val_calc_rl
1306: or not l_api_updating)
1307: and p_val_calc_rl is not null then
1308: --

Line 1334: and nvl(p_prort_mn_ann_elcn_val_rl,hr_api.g_number)

1330: end if;
1331: --
1332: --
1333: if (l_api_updating
1334: and nvl(p_prort_mn_ann_elcn_val_rl,hr_api.g_number)
1335: <> ben_abr_shd.g_old_rec.prort_mn_ann_elcn_val_rl
1336: or not l_api_updating)
1337: and p_prort_mn_ann_elcn_val_rl is not null then
1338: --

Line 1365: and nvl(p_prort_mx_ann_elcn_val_rl,hr_api.g_number)

1361: --
1362: end if;
1363: --
1364: if (l_api_updating
1365: and nvl(p_prort_mx_ann_elcn_val_rl,hr_api.g_number)
1366: <> ben_abr_shd.g_old_rec.prort_mx_ann_elcn_val_rl
1367: or not l_api_updating)
1368: and p_prort_mx_ann_elcn_val_rl is not null then
1369: --

Line 1397: and nvl(p_mn_mx_elcn_rl,hr_api.g_number)

1393: end if;
1394:
1395: --- Bug 3981982
1396: if (l_api_updating
1397: and nvl(p_mn_mx_elcn_rl,hr_api.g_number)
1398: <> ben_abr_shd.g_old_rec.mn_mx_elcn_rl
1399: or not l_api_updating)
1400: and p_mn_mx_elcn_rl is not null then
1401: --

Line 1428: and nvl(p_element_det_rl,hr_api.g_number)

1424: end if;
1425: --
1426: -- cwb multiple currency
1427: if (l_api_updating
1428: and nvl(p_element_det_rl,hr_api.g_number)
1429: <> ben_abr_shd.g_old_rec.element_det_rl
1430: or not l_api_updating)
1431: and p_element_det_rl is not null then
1432: --

Line 1561: <> nvl(ben_abr_shd.g_old_rec.use_to_calc_net_flx_cr_flag,hr_api.g_varchar2)

1557: p_object_version_number => p_object_version_number);
1558: --
1559: if (l_api_updating
1560: and p_use_to_calc_net_flx_cr_flag
1561: <> nvl(ben_abr_shd.g_old_rec.use_to_calc_net_flx_cr_flag,hr_api.g_varchar2)
1562: or not l_api_updating)
1563: and p_use_to_calc_net_flx_cr_flag is not null then
1564: --
1565: -- check if value of lookup falls within lookup type.

Line 1567: if hr_api.not_exists_in_hr_lookups

1563: and p_use_to_calc_net_flx_cr_flag is not null then
1564: --
1565: -- check if value of lookup falls within lookup type.
1566: --
1567: if hr_api.not_exists_in_hr_lookups
1568: (p_lookup_type => 'YES_NO',
1569: p_lookup_code => p_use_to_calc_net_flx_cr_flag,
1570: p_effective_date => p_effective_date) then
1571: --

Line 1583: <> nvl(ben_abr_shd.g_old_rec.asn_on_enrt_flag,hr_api.g_varchar2)

1579: end if;
1580: --
1581: if (l_api_updating
1582: and p_asn_on_enrt_flag
1583: <> nvl(ben_abr_shd.g_old_rec.asn_on_enrt_flag,hr_api.g_varchar2)
1584: or not l_api_updating)
1585: and p_asn_on_enrt_flag is not null then
1586: --
1587: -- check if value of lookup falls within lookup type.

Line 1589: if hr_api.not_exists_in_hr_lookups

1585: and p_asn_on_enrt_flag is not null then
1586: --
1587: -- check if value of lookup falls within lookup type.
1588: --
1589: if hr_api.not_exists_in_hr_lookups
1590: (p_lookup_type => 'YES_NO',
1591: p_lookup_code => p_asn_on_enrt_flag,
1592: p_effective_date => p_effective_date) then
1593: --

Line 1606: <> nvl(ben_abr_shd.g_old_rec.abv_mx_elcn_val_alwd_flag,hr_api.g_varchar2)

1602: --
1603: --
1604: if (l_api_updating
1605: and p_abv_mx_elcn_val_alwd_flag
1606: <> nvl(ben_abr_shd.g_old_rec.abv_mx_elcn_val_alwd_flag,hr_api.g_varchar2)
1607: or not l_api_updating)
1608: and p_abv_mx_elcn_val_alwd_flag is not null then
1609: --
1610: -- check if value of lookup falls within lookup type.

Line 1612: if hr_api.not_exists_in_hr_lookups

1608: and p_abv_mx_elcn_val_alwd_flag is not null then
1609: --
1610: -- check if value of lookup falls within lookup type.
1611: --
1612: if hr_api.not_exists_in_hr_lookups
1613: (p_lookup_type => 'YES_NO',
1614: p_lookup_code => p_abv_mx_elcn_val_alwd_flag,
1615: p_effective_date => p_effective_date) then
1616: --

Line 1629: <> nvl(ben_abr_shd.g_old_rec.blw_mn_elcn_alwd_flag,hr_api.g_varchar2)

1625: --
1626: --
1627: if (l_api_updating
1628: and p_blw_mn_elcn_alwd_flag
1629: <> nvl(ben_abr_shd.g_old_rec.blw_mn_elcn_alwd_flag,hr_api.g_varchar2)
1630: or not l_api_updating)
1631: and p_blw_mn_elcn_alwd_flag is not null then
1632: --
1633: -- check if value of lookup falls within lookup type.

Line 1635: if hr_api.not_exists_in_hr_lookups

1631: and p_blw_mn_elcn_alwd_flag is not null then
1632: --
1633: -- check if value of lookup falls within lookup type.
1634: --
1635: if hr_api.not_exists_in_hr_lookups
1636: (p_lookup_type => 'YES_NO',
1637: p_lookup_code => p_blw_mn_elcn_alwd_flag,
1638: p_effective_date => p_effective_date) then
1639: --

Line 1651: <> nvl(ben_abr_shd.g_old_rec.dsply_on_enrt_flag,hr_api.g_varchar2)

1647: end if;
1648: --
1649: if (l_api_updating
1650: and p_dsply_on_enrt_flag
1651: <> nvl(ben_abr_shd.g_old_rec.dsply_on_enrt_flag,hr_api.g_varchar2)
1652: or not l_api_updating)
1653: and p_dsply_on_enrt_flag is not null then
1654: --
1655: -- check if value of lookup falls within lookup type.

Line 1657: if hr_api.not_exists_in_hr_lookups

1653: and p_dsply_on_enrt_flag is not null then
1654: --
1655: -- check if value of lookup falls within lookup type.
1656: --
1657: if hr_api.not_exists_in_hr_lookups
1658: (p_lookup_type => 'YES_NO',
1659: p_lookup_code => p_dsply_on_enrt_flag,
1660: p_effective_date => p_effective_date) then
1661: --

Line 1673: <> nvl(ben_abr_shd.g_old_rec.use_calc_acty_bs_rt_flag,hr_api.g_varchar2)

1669: end if;
1670: --
1671: if (l_api_updating
1672: and p_use_calc_acty_bs_rt_flag
1673: <> nvl(ben_abr_shd.g_old_rec.use_calc_acty_bs_rt_flag,hr_api.g_varchar2)
1674: or not l_api_updating)
1675: and p_use_calc_acty_bs_rt_flag is not null then
1676: --
1677: -- check if value of lookup falls within lookup type.

Line 1679: if hr_api.not_exists_in_hr_lookups

1675: and p_use_calc_acty_bs_rt_flag is not null then
1676: --
1677: -- check if value of lookup falls within lookup type.
1678: --
1679: if hr_api.not_exists_in_hr_lookups
1680: (p_lookup_type => 'YES_NO',
1681: p_lookup_code => p_use_calc_acty_bs_rt_flag,
1682: p_effective_date => p_effective_date) then
1683: --

Line 1697: <> nvl(ben_abr_shd.g_old_rec.uses_ded_sched_flag,hr_api.g_varchar2)

1693: --
1694: --
1695: if (l_api_updating
1696: and p_uses_ded_sched_flag
1697: <> nvl(ben_abr_shd.g_old_rec.uses_ded_sched_flag,hr_api.g_varchar2)
1698: or not l_api_updating)
1699: and p_uses_ded_sched_flag is not null then
1700: --
1701: -- check if value of lookup falls within lookup type.

Line 1703: if hr_api.not_exists_in_hr_lookups

1699: and p_uses_ded_sched_flag is not null then
1700: --
1701: -- check if value of lookup falls within lookup type.
1702: --
1703: if hr_api.not_exists_in_hr_lookups
1704: (p_lookup_type => 'YES_NO',
1705: p_lookup_code => p_uses_ded_sched_flag,
1706: p_effective_date => p_effective_date) then
1707: --

Line 1719: <> nvl(ben_abr_shd.g_old_rec.uses_varbl_rt_flag,hr_api.g_varchar2)

1715: end if;
1716: --
1717: if (l_api_updating
1718: and p_uses_varbl_rt_flag
1719: <> nvl(ben_abr_shd.g_old_rec.uses_varbl_rt_flag,hr_api.g_varchar2)
1720: or not l_api_updating)
1721: and p_uses_varbl_rt_flag is not null then
1722: --
1723: -- check if value of lookup falls within lookup type.

Line 1725: if hr_api.not_exists_in_hr_lookups

1721: and p_uses_varbl_rt_flag is not null then
1722: --
1723: -- check if value of lookup falls within lookup type.
1724: --
1725: if hr_api.not_exists_in_hr_lookups
1726: (p_lookup_type => 'YES_NO',
1727: p_lookup_code => p_uses_varbl_rt_flag,
1728: p_effective_date => p_effective_date) then
1729: --

Line 1747: <> nvl(ben_abr_shd.g_old_rec.uses_varbl_rt_flag,hr_api.g_varchar2)

1743:
1744:
1745: if (l_api_updating
1746: and p_uses_varbl_rt_flag
1747: <> nvl(ben_abr_shd.g_old_rec.uses_varbl_rt_flag,hr_api.g_varchar2)
1748: ) and p_uses_varbl_rt_flag is not null and p_acty_base_rt_id is not null
1749: and p_uses_varbl_rt_flag = 'N' --bug 3960628
1750: then
1751: open c1;

Line 1765: <> nvl(ben_abr_shd.g_old_rec.vstg_sched_apls_fLag,hr_api.g_varchar2)

1761: end if;
1762: --
1763: if (l_api_updating
1764: and p_vstg_sched_apls_fLag
1765: <> nvl(ben_abr_shd.g_old_rec.vstg_sched_apls_fLag,hr_api.g_varchar2)
1766: or not l_api_updating)
1767: and p_vstg_sched_apls_fLag is not null then
1768: --
1769: -- check if value of lookup falls within lookup type.

Line 1771: if hr_api.not_exists_in_hr_lookups

1767: and p_vstg_sched_apls_fLag is not null then
1768: --
1769: -- check if value of lookup falls within lookup type.
1770: --
1771: if hr_api.not_exists_in_hr_lookups
1772: (p_lookup_type => 'YES_NO',
1773: p_lookup_code => p_vstg_sched_apls_fLag,
1774: p_effective_date => p_effective_date) then
1775: --

Line 1787: <> nvl(ben_abr_shd.g_old_rec.proc_each_pp_dflt_flag,hr_api.g_varchar2)

1783: end if;
1784: --
1785: if (l_api_updating
1786: and p_proc_each_pp_dflt_flag
1787: <> nvl(ben_abr_shd.g_old_rec.proc_each_pp_dflt_flag,hr_api.g_varchar2)
1788: or not l_api_updating)
1789: and p_proc_each_pp_dflt_flag is not null then
1790: --
1791: -- check if value of lookup falls within lookup type.

Line 1793: if hr_api.not_exists_in_hr_lookups

1789: and p_proc_each_pp_dflt_flag is not null then
1790: --
1791: -- check if value of lookup falls within lookup type.
1792: --
1793: if hr_api.not_exists_in_hr_lookups
1794: (p_lookup_type => 'YES_NO',
1795: p_lookup_code => p_proc_each_pp_dflt_flag,
1796: p_effective_date => p_effective_date) then
1797: --

Line 1809: <> nvl(ben_abr_shd.g_old_rec.prdct_flx_cr_when_elig_flag,hr_api.g_varchar2)

1805: end if;
1806: --
1807: if (l_api_updating
1808: and p_prdct_flx_cr_when_elig_flag
1809: <> nvl(ben_abr_shd.g_old_rec.prdct_flx_cr_when_elig_flag,hr_api.g_varchar2)
1810: or not l_api_updating)
1811: and p_prdct_flx_cr_when_elig_flag is not null then
1812: --
1813: -- check if value of lookup falls within lookup type.

Line 1815: if hr_api.not_exists_in_hr_lookups

1811: and p_prdct_flx_cr_when_elig_flag is not null then
1812: --
1813: -- check if value of lookup falls within lookup type.
1814: --
1815: if hr_api.not_exists_in_hr_lookups
1816: (p_lookup_type => 'YES_NO',
1817: p_lookup_code => p_prdct_flx_cr_when_elig_flag,
1818: p_effective_date => p_effective_date) then
1819: --

Line 1831: <> nvl(ben_abr_shd.g_old_rec.no_std_rt_used_flag,hr_api.g_varchar2)

1827: end if;
1828: --
1829: if (l_api_updating
1830: and p_no_std_rt_used_flag
1831: <> nvl(ben_abr_shd.g_old_rec.no_std_rt_used_flag,hr_api.g_varchar2)
1832: or not l_api_updating)
1833: and p_no_std_rt_used_flag is not null then
1834: --
1835: -- check if value of lookup falls within lookup type.

Line 1837: if hr_api.not_exists_in_hr_lookups

1833: and p_no_std_rt_used_flag is not null then
1834: --
1835: -- check if value of lookup falls within lookup type.
1836: --
1837: if hr_api.not_exists_in_hr_lookups
1838: (p_lookup_type => 'YES_NO',
1839: p_lookup_code => p_no_std_rt_used_flag,
1840: p_effective_date => p_effective_date) then
1841: --

Line 1860: <> nvl(ben_abr_shd.g_old_rec.uses_pymt_sched_flag,hr_api.g_varchar2)

1856: end if;
1857: --
1858: if (l_api_updating
1859: and p_uses_pymt_sched_flag
1860: <> nvl(ben_abr_shd.g_old_rec.uses_pymt_sched_flag,hr_api.g_varchar2)
1861: or not l_api_updating)
1862: and p_uses_pymt_sched_flag is not null then
1863: --
1864: -- check if value of lookup falls within lookup type.

Line 1866: if hr_api.not_exists_in_hr_lookups

1862: and p_uses_pymt_sched_flag is not null then
1863: --
1864: -- check if value of lookup falls within lookup type.
1865: --
1866: if hr_api.not_exists_in_hr_lookups
1867: (p_lookup_type => 'YES_NO',
1868: p_lookup_code => p_uses_pymt_sched_flag,
1869: p_effective_date => p_effective_date) then
1870: --

Line 1893: <> nvl(ben_abr_shd.g_old_rec.val_ovrid_alwd_flag,hr_api.g_varchar2)

1889: end if;
1890: --
1891: if (l_api_updating
1892: and p_val_ovrid_alwd_flag
1893: <> nvl(ben_abr_shd.g_old_rec.val_ovrid_alwd_flag,hr_api.g_varchar2)
1894: or not l_api_updating)
1895: and p_val_ovrid_alwd_flag is not null then
1896: --
1897: -- check if value of lookup falls within lookup type.

Line 1899: if hr_api.not_exists_in_hr_lookups

1895: and p_val_ovrid_alwd_flag is not null then
1896: --
1897: -- check if value of lookup falls within lookup type.
1898: --
1899: if hr_api.not_exists_in_hr_lookups
1900: (p_lookup_type => 'YES_NO',
1901: p_lookup_code => p_val_ovrid_alwd_flag,
1902: p_effective_date => p_effective_date) then
1903: --

Line 1915: <> nvl(ben_abr_shd.g_old_rec.no_mx_elcn_val_dfnd_flag,hr_api.g_varchar2)

1911: end if;
1912: --
1913: if (l_api_updating
1914: and p_no_mx_elcn_val_dfnd_flag
1915: <> nvl(ben_abr_shd.g_old_rec.no_mx_elcn_val_dfnd_flag,hr_api.g_varchar2)
1916: or not l_api_updating)
1917: and p_no_mx_elcn_val_dfnd_flag is not null then
1918: --
1919: -- check if value of lookup falls within lookup type.

Line 1921: if hr_api.not_exists_in_hr_lookups

1917: and p_no_mx_elcn_val_dfnd_flag is not null then
1918: --
1919: -- check if value of lookup falls within lookup type.
1920: --
1921: if hr_api.not_exists_in_hr_lookups
1922: (p_lookup_type => 'YES_NO',
1923: p_lookup_code => p_no_mx_elcn_val_dfnd_flag,
1924: p_effective_date => p_effective_date) then
1925: --

Line 1937: <> nvl(ben_abr_shd.g_old_rec.entr_val_at_enrt_flag,hr_api.g_varchar2)

1933: end if;
1934: --
1935: if (l_api_updating
1936: and p_entr_val_at_enrt_flag
1937: <> nvl(ben_abr_shd.g_old_rec.entr_val_at_enrt_flag,hr_api.g_varchar2)
1938: or not l_api_updating)
1939: and p_entr_val_at_enrt_flag is not null then
1940: --
1941: -- check if value of lookup falls within lookup type.

Line 1943: if hr_api.not_exists_in_hr_lookups

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

Line 1959: <> nvl(ben_abr_shd.g_old_rec.entr_ann_val_flag,hr_api.g_varchar2)

1955: end if;
1956: --
1957: if (l_api_updating
1958: and p_entr_ann_val_flag
1959: <> nvl(ben_abr_shd.g_old_rec.entr_ann_val_flag,hr_api.g_varchar2)
1960: or not l_api_updating)
1961: and p_entr_ann_val_flag is not null then
1962: --
1963: -- check if value of lookup falls within lookup type.

Line 1965: if hr_api.not_exists_in_hr_lookups

1961: and p_entr_ann_val_flag is not null then
1962: --
1963: -- check if value of lookup falls within lookup type.
1964: --
1965: if hr_api.not_exists_in_hr_lookups
1966: (p_lookup_type => 'YES_NO',
1967: p_lookup_code => p_entr_ann_val_flag,
1968: p_effective_date => p_effective_date) then
1969: --

Line 2008: <> nvl(ben_abr_shd.g_old_rec.no_mn_elcn_val_dfnd_flag,hr_api.g_varchar2)

2004: end if;
2005:
2006: if (l_api_updating
2007: and p_no_mn_elcn_val_dfnd_flag
2008: <> nvl(ben_abr_shd.g_old_rec.no_mn_elcn_val_dfnd_flag,hr_api.g_varchar2)
2009: or not l_api_updating)
2010: and p_no_mn_elcn_val_dfnd_flag is not null then
2011: --
2012: -- check if value of lookup falls within lookup type.

Line 2014: if hr_api.not_exists_in_hr_lookups

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

Line 2029: <> nvl(ben_abr_shd.g_old_rec.only_one_bal_typ_alwd_flag,hr_api.g_varchar2)

2025: end if;
2026: --
2027: if (l_api_updating
2028: and p_only_one_bal_typ_alwd_flag
2029: <> nvl(ben_abr_shd.g_old_rec.only_one_bal_typ_alwd_flag,hr_api.g_varchar2)
2030: or not l_api_updating)
2031: and p_only_one_bal_typ_alwd_flag is not null then
2032: --
2033: -- check if value of lookup falls within lookup type.

Line 2035: if hr_api.not_exists_in_hr_lookups

2031: and p_only_one_bal_typ_alwd_flag is not null then
2032: --
2033: -- check if value of lookup falls within lookup type.
2034: --
2035: if hr_api.not_exists_in_hr_lookups
2036: (p_lookup_type => 'YES_NO',
2037: p_lookup_code => p_only_one_bal_typ_alwd_flag,
2038: p_effective_date => p_effective_date) then
2039: --

Line 2051: <> nvl(ben_abr_shd.g_old_rec.ele_rqd_flag,hr_api.g_varchar2)

2047: end if;
2048: --
2049: if (l_api_updating
2050: and p_ele_rqd_flag
2051: <> nvl(ben_abr_shd.g_old_rec.ele_rqd_flag,hr_api.g_varchar2)
2052: or not l_api_updating)
2053: and p_ele_rqd_flag is not null then
2054: --
2055: -- check if value of lookup falls within lookup type.

Line 2057: if hr_api.not_exists_in_hr_lookups

2053: and p_ele_rqd_flag is not null then
2054: --
2055: -- check if value of lookup falls within lookup type.
2056: --
2057: if hr_api.not_exists_in_hr_lookups
2058: (p_lookup_type => 'YES_NO',
2059: p_lookup_code => p_ele_rqd_flag,
2060: p_effective_date => p_effective_date) then
2061: --

Line 2076: <> nvl(ben_abr_shd.g_old_rec.subj_to_imptd_incm_flag,hr_api.g_varchar2)

2072: end if;
2073: --
2074: if (l_api_updating
2075: and p_subj_to_imptd_incm_flag
2076: <> nvl(ben_abr_shd.g_old_rec.subj_to_imptd_incm_flag,hr_api.g_varchar2)
2077: or not l_api_updating)
2078: and p_subj_to_imptd_incm_flag is not null then
2079: --
2080: -- check if value of lookup falls within lookup type.

Line 2082: if hr_api.not_exists_in_hr_lookups

2078: and p_subj_to_imptd_incm_flag is not null then
2079: --
2080: -- check if value of lookup falls within lookup type.
2081: --
2082: if hr_api.not_exists_in_hr_lookups
2083: (p_lookup_type => 'YES_NO',
2084: p_lookup_code => p_subj_to_imptd_incm_flag,
2085: p_effective_date => p_effective_date) then
2086: --

Line 2273: if hr_api.not_exists_in_hr_lookups

2269: fnd_message.set_name('BEN','BEN_93739_CWB_SACTY_NOT_NULL');
2270: fnd_message.raise_error;
2271: end if ;
2272: */
2273: if hr_api.not_exists_in_hr_lookups
2274: (p_lookup_type => 'BEN_SUB_ACTY_TYP',
2275: p_lookup_code => p_sub_acty_typ_cd ,
2276: p_effective_date => p_effective_start_date) then
2277: --

Line 2691: <> nvl(ben_abr_shd.g_old_rec.rt_usg_cd,hr_api.g_varchar2)

2687: p_object_version_number => p_object_version_number);
2688: --
2689: if (l_api_updating
2690: and p_rt_usg_cd
2691: <> nvl(ben_abr_shd.g_old_rec.rt_usg_cd,hr_api.g_varchar2)
2692: or not l_api_updating)
2693: and p_rt_usg_cd is not null then
2694: --
2695: -- check if value of lookup falls within lookup type.

Line 2697: if hr_api.not_exists_in_hr_lookups

2693: and p_rt_usg_cd is not null then
2694: --
2695: -- check if value of lookup falls within lookup type.
2696: --
2697: if hr_api.not_exists_in_hr_lookups
2698: (p_lookup_type => 'BEN_RT_USG',
2699: p_lookup_code => p_rt_usg_cd,
2700: p_effective_date => p_effective_date) then
2701: --

Line 2713: <> nvl(ben_abr_shd.g_old_rec.prort_mn_ann_elcn_val_cd,hr_api.g_varchar2)

2709: end if;
2710: --
2711: if (l_api_updating
2712: and p_prort_mn_ann_elcn_val_cd
2713: <> nvl(ben_abr_shd.g_old_rec.prort_mn_ann_elcn_val_cd,hr_api.g_varchar2)
2714: or not l_api_updating)
2715: and p_prort_mn_ann_elcn_val_cd is not null then
2716: --
2717: -- check if value of lookup falls within lookup type.

Line 2719: if hr_api.not_exists_in_hr_lookups

2715: and p_prort_mn_ann_elcn_val_cd is not null then
2716: --
2717: -- check if value of lookup falls within lookup type.
2718: --
2719: if hr_api.not_exists_in_hr_lookups
2720: (p_lookup_type => 'BEN_PRORT_ANN_ELCN_VAL',
2721: p_lookup_code => p_prort_mn_ann_elcn_val_cd,
2722: p_effective_date => p_effective_date) then
2723: --

Line 2738: <> nvl(ben_abr_shd.g_old_rec.prort_mx_ann_elcn_val_cd,hr_api.g_varchar2)

2734: end if;
2735: --
2736: if (l_api_updating
2737: and p_prort_mx_ann_elcn_val_cd
2738: <> nvl(ben_abr_shd.g_old_rec.prort_mx_ann_elcn_val_cd,hr_api.g_varchar2)
2739: or not l_api_updating)
2740: and p_prort_mx_ann_elcn_val_cd is not null then
2741: --
2742: -- check if value of lookup falls within lookup type.

Line 2744: if hr_api.not_exists_in_hr_lookups

2740: and p_prort_mx_ann_elcn_val_cd is not null then
2741: --
2742: -- check if value of lookup falls within lookup type.
2743: --
2744: if hr_api.not_exists_in_hr_lookups
2745: (p_lookup_type => 'BEN_PRORT_ANN_ELCN_VAL',
2746: p_lookup_code => p_prort_mx_ann_elcn_val_cd,
2747: p_effective_date => p_effective_date) then
2748: --

Line 2763: <> nvl(ben_abr_shd.g_old_rec.one_ann_pymt_cd,hr_api.g_varchar2)

2759: end if;
2760: --
2761: if (l_api_updating
2762: and p_one_ann_pymt_cd
2763: <> nvl(ben_abr_shd.g_old_rec.one_ann_pymt_cd,hr_api.g_varchar2)
2764: or not l_api_updating)
2765: and p_one_ann_pymt_cd is not null then
2766: --
2767: -- check if value of lookup falls within lookup type.

Line 2769: if hr_api.not_exists_in_hr_lookups

2765: and p_one_ann_pymt_cd is not null then
2766: --
2767: -- check if value of lookup falls within lookup type.
2768: --
2769: if hr_api.not_exists_in_hr_lookups
2770: (p_lookup_type => 'BEN_ONE_ANN_PYMT',
2771: p_lookup_code => p_one_ann_pymt_cd,
2772: p_effective_date => p_effective_date) then
2773: --

Line 2788: <> nvl(ben_abr_shd.g_old_rec.acty_typ_cd,hr_api.g_varchar2)

2784: end if;
2785: --
2786: if (l_api_updating
2787: and p_acty_typ_cd
2788: <> nvl(ben_abr_shd.g_old_rec.acty_typ_cd,hr_api.g_varchar2)
2789: or not l_api_updating)
2790: and p_acty_typ_cd is not null then
2791: --
2792: -- check if value of lookup falls within lookup type.

Line 2794: if hr_api.not_exists_in_hr_lookups

2790: and p_acty_typ_cd is not null then
2791: --
2792: -- check if value of lookup falls within lookup type.
2793: --
2794: if hr_api.not_exists_in_hr_lookups
2795: (p_lookup_type => 'BEN_ACTY_TYP',
2796: p_lookup_code => p_acty_typ_cd,
2797: p_effective_date => p_effective_date) then
2798: --

Line 2819: <> nvl(ben_abr_shd.g_old_rec.rt_typ_cd,hr_api.g_varchar2)

2815: --
2816: --
2817: if (l_api_updating
2818: and p_rt_typ_cd
2819: <> nvl(ben_abr_shd.g_old_rec.rt_typ_cd,hr_api.g_varchar2)
2820: or not l_api_updating)
2821: and p_rt_typ_cd is not null then
2822: --
2823: -- check if value of lookup falls within lookup type.

Line 2825: if hr_api.not_exists_in_hr_lookups

2821: and p_rt_typ_cd is not null then
2822: --
2823: -- check if value of lookup falls within lookup type.
2824: --
2825: if hr_api.not_exists_in_hr_lookups
2826: (p_lookup_type => 'BEN_RT_TYP',
2827: p_lookup_code => p_rt_typ_cd,
2828: p_effective_date => p_effective_date) then
2829: --

Line 2841: <> nvl(ben_abr_shd.g_old_rec.bnft_rt_typ_cd,hr_api.g_varchar2)

2837: end if;
2838: --
2839: if (l_api_updating
2840: and p_bnft_rt_typ_cd
2841: <> nvl(ben_abr_shd.g_old_rec.bnft_rt_typ_cd,hr_api.g_varchar2)
2842: or not l_api_updating)
2843: and p_bnft_rt_typ_cd is not null then
2844: --
2845: -- check if value of lookup falls within lookup type.

Line 2847: if hr_api.not_exists_in_hr_lookups

2843: and p_bnft_rt_typ_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_RT_TYP',
2849: p_lookup_code => p_bnft_rt_typ_cd,
2850: p_effective_date => p_effective_date) then
2851: --

Line 2864: <> nvl(ben_abr_shd.g_old_rec.tx_typ_cd,hr_api.g_varchar2)

2860: --
2861: --
2862: if (l_api_updating
2863: and p_tx_typ_cd
2864: <> nvl(ben_abr_shd.g_old_rec.tx_typ_cd,hr_api.g_varchar2)
2865: or not l_api_updating)
2866: and p_tx_typ_cd is not null then
2867: --
2868: -- check if value of lookup falls within lookup type.

Line 2870: if hr_api.not_exists_in_hr_lookups

2866: and p_tx_typ_cd is not null then
2867: --
2868: -- check if value of lookup falls within lookup type.
2869: --
2870: if hr_api.not_exists_in_hr_lookups
2871: (p_lookup_type => 'BEN_TX_TYP',
2872: p_lookup_code => p_tx_typ_cd,
2873: p_effective_date => p_effective_date) then
2874: --

Line 2887: <> nvl(ben_abr_shd.g_old_rec.parnt_chld_cd,hr_api.g_varchar2)

2883: --
2884: --
2885: if (l_api_updating
2886: and p_parnt_chld_cd
2887: <> nvl(ben_abr_shd.g_old_rec.parnt_chld_cd,hr_api.g_varchar2)
2888: or not l_api_updating)
2889: and p_parnt_chld_cd is not null then
2890: --
2891: -- check if value of lookup falls within lookup type.

Line 2893: if hr_api.not_exists_in_hr_lookups

2889: and p_parnt_chld_cd is not null then
2890: --
2891: -- check if value of lookup falls within lookup type.
2892: --
2893: if hr_api.not_exists_in_hr_lookups
2894: (p_lookup_type => 'BEN_PRNT_CHLD',
2895: p_lookup_code => p_parnt_chld_cd,
2896: p_effective_date => p_effective_date) then
2897: --

Line 2910: <> nvl(ben_abr_shd.g_old_rec.rt_mlt_cd,hr_api.g_varchar2)

2906: --
2907: --
2908: if (l_api_updating
2909: and p_rt_mlt_cd
2910: <> nvl(ben_abr_shd.g_old_rec.rt_mlt_cd,hr_api.g_varchar2)
2911: or not l_api_updating)
2912: and p_rt_mlt_cd is not null then
2913: --
2914: -- check if value of lookup falls within lookup type.

Line 2916: if hr_api.not_exists_in_hr_lookups

2912: and p_rt_mlt_cd is not null then
2913: --
2914: -- check if value of lookup falls within lookup type.
2915: --
2916: if hr_api.not_exists_in_hr_lookups
2917: (p_lookup_type => 'BEN_MLT',
2918: p_lookup_code => p_rt_mlt_cd,
2919: p_effective_date => p_effective_date) then
2920: --

Line 2941: <> nvl(ben_abr_shd.g_old_rec.rcrrg_cd,hr_api.g_varchar2)

2937: --
2938: --
2939: if (l_api_updating
2940: and p_rcrrg_cd
2941: <> nvl(ben_abr_shd.g_old_rec.rcrrg_cd,hr_api.g_varchar2)
2942: or not l_api_updating)
2943: and p_rcrrg_cd is not null then
2944: --
2945: -- check if value of lookup falls within lookup type.

Line 2947: if hr_api.not_exists_in_hr_lookups

2943: and p_rcrrg_cd is not null then
2944: --
2945: -- check if value of lookup falls within lookup type.
2946: --
2947: if hr_api.not_exists_in_hr_lookups
2948: (p_lookup_type => 'BEN_RCRRG',
2949: p_lookup_code => p_rcrrg_cd,
2950: p_effective_date => p_effective_date) then
2951: --

Line 2964: <> nvl(ben_abr_shd.g_old_rec.rndg_cd,hr_api.g_varchar2)

2960: --
2961: --
2962: if (l_api_updating
2963: and p_rndg_cd
2964: <> nvl(ben_abr_shd.g_old_rec.rndg_cd,hr_api.g_varchar2)
2965: or not l_api_updating)
2966: and p_rndg_cd is not null then
2967: --
2968: -- check if value of lookup falls within lookup type.

Line 2970: if hr_api.not_exists_in_hr_lookups

2966: and p_rndg_cd is not null then
2967: --
2968: -- check if value of lookup falls within lookup type.
2969: --
2970: if hr_api.not_exists_in_hr_lookups
2971: (p_lookup_type => 'BEN_RNDG',
2972: p_lookup_code => p_rndg_cd,
2973: p_effective_date => p_effective_date) then
2974: --

Line 2987: <> nvl(ben_abr_shd.g_old_rec.prtl_mo_det_mthd_cd,hr_api.g_varchar2)

2983: --
2984: --
2985: if (l_api_updating
2986: and p_prtl_mo_det_mthd_cd
2987: <> nvl(ben_abr_shd.g_old_rec.prtl_mo_det_mthd_cd,hr_api.g_varchar2)
2988: or not l_api_updating)
2989: and p_prtl_mo_det_mthd_cd is not null then
2990: --
2991: -- check if value of lookup falls within lookup type.

Line 2993: if hr_api.not_exists_in_hr_lookups

2989: and p_prtl_mo_det_mthd_cd is not null then
2990: --
2991: -- check if value of lookup falls within lookup type.
2992: --
2993: if hr_api.not_exists_in_hr_lookups
2994: (p_lookup_type => 'BEN_PRTL_MO_DET_MTHD',
2995: p_lookup_code => p_prtl_mo_det_mthd_cd,
2996: p_effective_date => p_effective_date) then
2997: --

Line 3010: <> nvl(ben_abr_shd.g_old_rec.acty_base_rt_stat_cd,hr_api.g_varchar2)

3006: --
3007: --
3008: if (l_api_updating
3009: and p_acty_base_rt_stat_cd
3010: <> nvl(ben_abr_shd.g_old_rec.acty_base_rt_stat_cd,hr_api.g_varchar2)
3011: or not l_api_updating)
3012: and p_acty_base_rt_stat_cd is not null then
3013: --
3014: -- check if value of lookup falls within lookup type.

Line 3016: if hr_api.not_exists_in_hr_lookups

3012: and p_acty_base_rt_stat_cd is not null then
3013: --
3014: -- check if value of lookup falls within lookup type.
3015: --
3016: if hr_api.not_exists_in_hr_lookups
3017: (p_lookup_type => 'BEN_STAT',
3018: p_lookup_code => p_acty_base_rt_stat_cd,
3019: p_effective_date => p_effective_date) then
3020: --

Line 3033: <> nvl(ben_abr_shd.g_old_rec.procg_src_cd,hr_api.g_varchar2)

3029: --
3030: --
3031: if (l_api_updating
3032: and p_procg_src_cd
3033: <> nvl(ben_abr_shd.g_old_rec.procg_src_cd,hr_api.g_varchar2)
3034: or not l_api_updating)
3035: and p_procg_src_cd is not null then
3036: --
3037: -- check if value of lookup falls within lookup type.

Line 3039: if hr_api.not_exists_in_hr_lookups

3035: and p_procg_src_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_PROCG_SRC',
3041: p_lookup_code => p_procg_src_cd,
3042: p_effective_date => p_effective_date) then
3043: --

Line 3056: <> nvl(ben_abr_shd.g_old_rec.frgn_erg_ded_typ_cd,hr_api.g_varchar2)

3052: --
3053: --
3054: if (l_api_updating
3055: and p_frgn_erg_ded_typ_cd
3056: <> nvl(ben_abr_shd.g_old_rec.frgn_erg_ded_typ_cd,hr_api.g_varchar2)
3057: or not l_api_updating)
3058: and p_frgn_erg_ded_typ_cd is not null then
3059: --
3060: -- check if value of lookup falls within lookup type.

Line 3062: if hr_api.not_exists_in_hr_lookups

3058: and p_frgn_erg_ded_typ_cd is not null then
3059: --
3060: -- check if value of lookup falls within lookup type.
3061: --
3062: if hr_api.not_exists_in_hr_lookups
3063: (p_lookup_type => 'BEN_ERG_DED',
3064: p_lookup_code => p_frgn_erg_ded_typ_cd,
3065: p_effective_date => p_effective_date) then
3066: --

Line 3079: <> nvl(ben_abr_shd.g_old_rec.prtl_mo_eff_dt_det_cd,hr_api.g_varchar2)

3075: --
3076: --
3077: if (l_api_updating
3078: and p_prtl_mo_eff_dt_det_cd
3079: <> nvl(ben_abr_shd.g_old_rec.prtl_mo_eff_dt_det_cd,hr_api.g_varchar2)
3080: or not l_api_updating)
3081: and p_prtl_mo_eff_dt_det_cd is not null then
3082: --
3083: -- check if value of lookup falls within lookup type.

Line 3085: if hr_api.not_exists_in_hr_lookups

3081: and p_prtl_mo_eff_dt_det_cd is not null then
3082: --
3083: -- check if value of lookup falls within lookup type.
3084: --
3085: if hr_api.not_exists_in_hr_lookups
3086: (p_lookup_type => 'BEN_PRTL_MO_EFF_DT_DET',
3087: p_lookup_code => p_prtl_mo_eff_dt_det_cd,
3088: p_effective_date => p_effective_date) then
3089: --

Line 3101: <> nvl(ben_abr_shd.g_old_rec.det_pl_ytd_cntrs_cd,hr_api.g_varchar2)

3097: end if;
3098: --
3099: if (l_api_updating
3100: and p_det_pl_ytd_cntrs_cd
3101: <> nvl(ben_abr_shd.g_old_rec.det_pl_ytd_cntrs_cd,hr_api.g_varchar2)
3102: or not l_api_updating)
3103: and p_det_pl_ytd_cntrs_cd is not null then
3104: --
3105: -- check if value of lookup falls within lookup type.

Line 3107: if hr_api.not_exists_in_hr_lookups

3103: and p_det_pl_ytd_cntrs_cd is not null then
3104: --
3105: -- check if value of lookup falls within lookup type.
3106: --
3107: if hr_api.not_exists_in_hr_lookups
3108: (p_lookup_type => 'BEN_DET_PL_YTD_CNTRS',
3109: p_lookup_code => p_det_pl_ytd_cntrs_cd,
3110: p_effective_date => p_effective_date) then
3111: --

Line 3126: <> nvl(ben_abr_shd.g_old_rec.asmt_to_use_cd,hr_api.g_varchar2)

3122: end if;
3123: --
3124: if (l_api_updating
3125: and p_asmt_to_use_cd
3126: <> nvl(ben_abr_shd.g_old_rec.asmt_to_use_cd,hr_api.g_varchar2)
3127: or not l_api_updating)
3128: and p_asmt_to_use_cd is not null then
3129: --
3130: -- check if value of lookup falls within lookup type.

Line 3132: if hr_api.not_exists_in_hr_lookups

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

Line 3151: <> nvl(ben_abr_shd.g_old_rec.currency_det_cd,hr_api.g_varchar2)

3147: end if;
3148: --
3149: if (l_api_updating
3150: and p_currency_det_cd
3151: <> nvl(ben_abr_shd.g_old_rec.currency_det_cd,hr_api.g_varchar2)
3152: or not l_api_updating)
3153: and p_currency_det_cd is not null then
3154: --
3155: -- check if value of lookup falls within lookup type.

Line 3157: if hr_api.not_exists_in_hr_lookups

3153: and p_currency_det_cd is not null then
3154: --
3155: -- check if value of lookup falls within lookup type.
3156: --
3157: if hr_api.not_exists_in_hr_lookups
3158: (p_lookup_type => 'BEN_CUR_DET',
3159: p_lookup_code => p_currency_det_cd,
3160: p_effective_date => p_effective_date) then
3161: --

Line 3416: if nvl(id, hr_api.g_number) <> hr_api.g_number then

3412: -- Local function only used by chk_only_one_id.
3413: --
3414: function is_id_not_null (id in number) return number is
3415: begin
3416: if nvl(id, hr_api.g_number) <> hr_api.g_number then
3417: return 1;
3418: else
3419: return 0;
3420: end if;

Line 3675: and nvl(p_organization_id,hr_api.g_number)

3671: p_effective_date => p_effective_date,
3672: p_object_version_number => p_object_version_number);
3673: --
3674: if (l_api_updating
3675: and nvl(p_organization_id,hr_api.g_number)
3676: <> nvl(ben_abr_shd.g_old_rec.organization_id,hr_api.g_number)
3677: or not l_api_updating) then
3678: --
3679: -- check if organization_id value exists in hr_organization_units table

Line 3676: <> nvl(ben_abr_shd.g_old_rec.organization_id,hr_api.g_number)

3672: p_object_version_number => p_object_version_number);
3673: --
3674: if (l_api_updating
3675: and nvl(p_organization_id,hr_api.g_number)
3676: <> nvl(ben_abr_shd.g_old_rec.organization_id,hr_api.g_number)
3677: or not l_api_updating) then
3678: --
3679: -- check if organization_id value exists in hr_organization_units table
3680: --

Line 3772: ( nvl(p_pay_rate_grade_rule_id,hr_api.g_number)

3768: p_object_version_number => p_object_version_number);
3769: --
3770: if (l_api_updating
3771: and
3772: ( nvl(p_pay_rate_grade_rule_id,hr_api.g_number)
3773: <> nvl(ben_abr_shd.g_old_rec.pay_rate_grade_rule_id,hr_api.g_number)
3774: or
3775: nvl(p_pl_id,hr_api.g_number)
3776: <> nvl(ben_abr_shd.g_old_rec.pl_id,hr_api.g_number)

Line 3773: <> nvl(ben_abr_shd.g_old_rec.pay_rate_grade_rule_id,hr_api.g_number)

3769: --
3770: if (l_api_updating
3771: and
3772: ( nvl(p_pay_rate_grade_rule_id,hr_api.g_number)
3773: <> nvl(ben_abr_shd.g_old_rec.pay_rate_grade_rule_id,hr_api.g_number)
3774: or
3775: nvl(p_pl_id,hr_api.g_number)
3776: <> nvl(ben_abr_shd.g_old_rec.pl_id,hr_api.g_number)
3777: or

Line 3775: nvl(p_pl_id,hr_api.g_number)

3771: and
3772: ( nvl(p_pay_rate_grade_rule_id,hr_api.g_number)
3773: <> nvl(ben_abr_shd.g_old_rec.pay_rate_grade_rule_id,hr_api.g_number)
3774: or
3775: nvl(p_pl_id,hr_api.g_number)
3776: <> nvl(ben_abr_shd.g_old_rec.pl_id,hr_api.g_number)
3777: or
3778: nvl(p_opt_id,hr_api.g_number)
3779: <> nvl(ben_abr_shd.g_old_rec.opt_id,hr_api.g_number)

Line 3776: <> nvl(ben_abr_shd.g_old_rec.pl_id,hr_api.g_number)

3772: ( nvl(p_pay_rate_grade_rule_id,hr_api.g_number)
3773: <> nvl(ben_abr_shd.g_old_rec.pay_rate_grade_rule_id,hr_api.g_number)
3774: or
3775: nvl(p_pl_id,hr_api.g_number)
3776: <> nvl(ben_abr_shd.g_old_rec.pl_id,hr_api.g_number)
3777: or
3778: nvl(p_opt_id,hr_api.g_number)
3779: <> nvl(ben_abr_shd.g_old_rec.opt_id,hr_api.g_number)
3780: )

Line 3778: nvl(p_opt_id,hr_api.g_number)

3774: or
3775: nvl(p_pl_id,hr_api.g_number)
3776: <> nvl(ben_abr_shd.g_old_rec.pl_id,hr_api.g_number)
3777: or
3778: nvl(p_opt_id,hr_api.g_number)
3779: <> nvl(ben_abr_shd.g_old_rec.opt_id,hr_api.g_number)
3780: )
3781: or not l_api_updating) then
3782: --

Line 3779: <> nvl(ben_abr_shd.g_old_rec.opt_id,hr_api.g_number)

3775: nvl(p_pl_id,hr_api.g_number)
3776: <> nvl(ben_abr_shd.g_old_rec.pl_id,hr_api.g_number)
3777: or
3778: nvl(p_opt_id,hr_api.g_number)
3779: <> nvl(ben_abr_shd.g_old_rec.opt_id,hr_api.g_number)
3780: )
3781: or not l_api_updating) then
3782: --
3783: -- check if organization_id value exists in hr_organization_units table

Line 3879: and nvl(p_nnmntry_uom,hr_api.g_varchar2)

3875: p_effective_date => p_effective_date,
3876: p_object_version_number => p_object_version_number);
3877: --
3878: if (l_api_updating
3879: and nvl(p_nnmntry_uom,hr_api.g_varchar2)
3880: <> nvl(ben_abr_shd.g_old_rec.nnmntry_uom,hr_api.g_varchar2)
3881: or not l_api_updating) then
3882: --
3883: -- check if nnmntry_uom value exists in fnd_currency_tl table

Line 3880: <> nvl(ben_abr_shd.g_old_rec.nnmntry_uom,hr_api.g_varchar2)

3876: p_object_version_number => p_object_version_number);
3877: --
3878: if (l_api_updating
3879: and nvl(p_nnmntry_uom,hr_api.g_varchar2)
3880: <> nvl(ben_abr_shd.g_old_rec.nnmntry_uom,hr_api.g_varchar2)
3881: or not l_api_updating) then
3882: --
3883: -- check if nnmntry_uom value exists in fnd_currency_tl table
3884: --

Line 3891: if hr_api.not_exists_in_hr_lookups

3887: --
3888: fetch c1 into l_dummy;
3889: if c1%notfound then
3890: --
3891: if hr_api.not_exists_in_hr_lookups
3892: (p_lookup_type => 'BEN_NNMNTRY_UOM',
3893: p_lookup_code => p_nnmntry_uom,
3894: p_effective_date => p_effective_date) then
3895: --

Line 3967: and nvl(p_oab_element_typ_id,hr_api.g_number)

3963: p_effective_date => p_effective_date,
3964: p_object_version_number => p_object_version_number);
3965: --
3966: if (l_api_updating
3967: and nvl(p_oab_element_typ_id,hr_api.g_number)
3968: <> nvl(ben_abr_shd.g_old_rec.oab_element_typ_id,hr_api.g_number)
3969: or not l_api_updating) then
3970: --
3971: -- check if oab_element_typ_id value exists in hr_organization_units table

Line 3968: <> nvl(ben_abr_shd.g_old_rec.oab_element_typ_id,hr_api.g_number)

3964: p_object_version_number => p_object_version_number);
3965: --
3966: if (l_api_updating
3967: and nvl(p_oab_element_typ_id,hr_api.g_number)
3968: <> nvl(ben_abr_shd.g_old_rec.oab_element_typ_id,hr_api.g_number)
3969: or not l_api_updating) then
3970: --
3971: -- check if oab_element_typ_id value exists in hr_organization_units table
3972: --

Line 4077: and (nvl(p_acty_typ_cd,hr_api.g_varchar2)

4073: p_effective_date => p_effective_date,
4074: p_object_version_number => p_object_version_number);
4075: --
4076: if (l_api_updating
4077: and (nvl(p_acty_typ_cd,hr_api.g_varchar2)
4078: <> nvl(ben_abr_shd.g_old_rec.acty_typ_cd,hr_api.g_varchar2)
4079: or
4080: nvl(p_pl_id,hr_api.g_number)
4081: <> nvl(ben_abr_shd.g_old_rec.pl_id,hr_api.g_number)

Line 4078: <> nvl(ben_abr_shd.g_old_rec.acty_typ_cd,hr_api.g_varchar2)

4074: p_object_version_number => p_object_version_number);
4075: --
4076: if (l_api_updating
4077: and (nvl(p_acty_typ_cd,hr_api.g_varchar2)
4078: <> nvl(ben_abr_shd.g_old_rec.acty_typ_cd,hr_api.g_varchar2)
4079: or
4080: nvl(p_pl_id,hr_api.g_number)
4081: <> nvl(ben_abr_shd.g_old_rec.pl_id,hr_api.g_number)
4082: or

Line 4080: nvl(p_pl_id,hr_api.g_number)

4076: if (l_api_updating
4077: and (nvl(p_acty_typ_cd,hr_api.g_varchar2)
4078: <> nvl(ben_abr_shd.g_old_rec.acty_typ_cd,hr_api.g_varchar2)
4079: or
4080: nvl(p_pl_id,hr_api.g_number)
4081: <> nvl(ben_abr_shd.g_old_rec.pl_id,hr_api.g_number)
4082: or
4083: nvl(p_oipl_id,hr_api.g_number)
4084: <> nvl(ben_abr_shd.g_old_rec.oipl_id,hr_api.g_number)

Line 4081: <> nvl(ben_abr_shd.g_old_rec.pl_id,hr_api.g_number)

4077: and (nvl(p_acty_typ_cd,hr_api.g_varchar2)
4078: <> nvl(ben_abr_shd.g_old_rec.acty_typ_cd,hr_api.g_varchar2)
4079: or
4080: nvl(p_pl_id,hr_api.g_number)
4081: <> nvl(ben_abr_shd.g_old_rec.pl_id,hr_api.g_number)
4082: or
4083: nvl(p_oipl_id,hr_api.g_number)
4084: <> nvl(ben_abr_shd.g_old_rec.oipl_id,hr_api.g_number)
4085: or

Line 4083: nvl(p_oipl_id,hr_api.g_number)

4079: or
4080: nvl(p_pl_id,hr_api.g_number)
4081: <> nvl(ben_abr_shd.g_old_rec.pl_id,hr_api.g_number)
4082: or
4083: nvl(p_oipl_id,hr_api.g_number)
4084: <> nvl(ben_abr_shd.g_old_rec.oipl_id,hr_api.g_number)
4085: or
4086: nvl(p_acty_base_rt_stat_cd,hr_api.g_varchar2)
4087: <> nvl(ben_abr_shd.g_old_rec.acty_base_rt_stat_cd,hr_api.g_varchar2)

Line 4084: <> nvl(ben_abr_shd.g_old_rec.oipl_id,hr_api.g_number)

4080: nvl(p_pl_id,hr_api.g_number)
4081: <> nvl(ben_abr_shd.g_old_rec.pl_id,hr_api.g_number)
4082: or
4083: nvl(p_oipl_id,hr_api.g_number)
4084: <> nvl(ben_abr_shd.g_old_rec.oipl_id,hr_api.g_number)
4085: or
4086: nvl(p_acty_base_rt_stat_cd,hr_api.g_varchar2)
4087: <> nvl(ben_abr_shd.g_old_rec.acty_base_rt_stat_cd,hr_api.g_varchar2)
4088: )

Line 4086: nvl(p_acty_base_rt_stat_cd,hr_api.g_varchar2)

4082: or
4083: nvl(p_oipl_id,hr_api.g_number)
4084: <> nvl(ben_abr_shd.g_old_rec.oipl_id,hr_api.g_number)
4085: or
4086: nvl(p_acty_base_rt_stat_cd,hr_api.g_varchar2)
4087: <> nvl(ben_abr_shd.g_old_rec.acty_base_rt_stat_cd,hr_api.g_varchar2)
4088: )
4089: or not l_api_updating) and p_acty_base_rt_stat_cd = 'A' then
4090: --

Line 4087: <> nvl(ben_abr_shd.g_old_rec.acty_base_rt_stat_cd,hr_api.g_varchar2)

4083: nvl(p_oipl_id,hr_api.g_number)
4084: <> nvl(ben_abr_shd.g_old_rec.oipl_id,hr_api.g_number)
4085: or
4086: nvl(p_acty_base_rt_stat_cd,hr_api.g_varchar2)
4087: <> nvl(ben_abr_shd.g_old_rec.acty_base_rt_stat_cd,hr_api.g_varchar2)
4088: )
4089: or not l_api_updating) and p_acty_base_rt_stat_cd = 'A' then
4090: --
4091: -- if the activity type code is not 'CWBAHE' then check if any

Line 4201: and nvl(p_acty_typ_cd,hr_api.g_varchar2)

4197: p_effective_date => p_effective_date,
4198: p_object_version_number => p_object_version_number);
4199: --
4200: if (l_api_updating
4201: and nvl(p_acty_typ_cd,hr_api.g_varchar2)
4202: <> nvl(ben_abr_shd.g_old_rec.acty_typ_cd,hr_api.g_varchar2)
4203: or not l_api_updating) then
4204: --
4205: -- check if nnmntry_uom value exists in fnd_currency_tl table

Line 4202: <> nvl(ben_abr_shd.g_old_rec.acty_typ_cd,hr_api.g_varchar2)

4198: p_object_version_number => p_object_version_number);
4199: --
4200: if (l_api_updating
4201: and nvl(p_acty_typ_cd,hr_api.g_varchar2)
4202: <> nvl(ben_abr_shd.g_old_rec.acty_typ_cd,hr_api.g_varchar2)
4203: or not l_api_updating) then
4204: --
4205: -- check if nnmntry_uom value exists in fnd_currency_tl table
4206: --

Line 4378: (p_prtl_mo_det_mthd_rl in number default hr_api.g_number,

4374: --
4375: -- {End Of Comments}
4376: -- ----------------------------------------------------------------------------
4377: Procedure dt_update_validate
4378: (p_prtl_mo_det_mthd_rl in number default hr_api.g_number,
4379: p_prtl_mo_eff_dt_det_rl in number default hr_api.g_number,
4380: p_rndg_rl in number default hr_api.g_number,
4381: p_lwr_lmt_calc_rl in number default hr_api.g_number,
4382: p_upr_lmt_calc_rl in number default hr_api.g_number,

Line 4379: p_prtl_mo_eff_dt_det_rl in number default hr_api.g_number,

4375: -- {End Of Comments}
4376: -- ----------------------------------------------------------------------------
4377: Procedure dt_update_validate
4378: (p_prtl_mo_det_mthd_rl in number default hr_api.g_number,
4379: p_prtl_mo_eff_dt_det_rl in number default hr_api.g_number,
4380: p_rndg_rl in number default hr_api.g_number,
4381: p_lwr_lmt_calc_rl in number default hr_api.g_number,
4382: p_upr_lmt_calc_rl in number default hr_api.g_number,
4383: p_val_calc_rl in number default hr_api.g_number,

Line 4380: p_rndg_rl in number default hr_api.g_number,

4376: -- ----------------------------------------------------------------------------
4377: Procedure dt_update_validate
4378: (p_prtl_mo_det_mthd_rl in number default hr_api.g_number,
4379: p_prtl_mo_eff_dt_det_rl in number default hr_api.g_number,
4380: p_rndg_rl in number default hr_api.g_number,
4381: p_lwr_lmt_calc_rl in number default hr_api.g_number,
4382: p_upr_lmt_calc_rl in number default hr_api.g_number,
4383: p_val_calc_rl in number default hr_api.g_number,
4384: p_vstg_for_acty_rt_id in number default hr_api.g_number,

Line 4381: p_lwr_lmt_calc_rl in number default hr_api.g_number,

4377: Procedure dt_update_validate
4378: (p_prtl_mo_det_mthd_rl in number default hr_api.g_number,
4379: p_prtl_mo_eff_dt_det_rl in number default hr_api.g_number,
4380: p_rndg_rl in number default hr_api.g_number,
4381: p_lwr_lmt_calc_rl in number default hr_api.g_number,
4382: p_upr_lmt_calc_rl in number default hr_api.g_number,
4383: p_val_calc_rl in number default hr_api.g_number,
4384: p_vstg_for_acty_rt_id in number default hr_api.g_number,
4385: p_actl_prem_id in number default hr_api.g_number,

Line 4382: p_upr_lmt_calc_rl in number default hr_api.g_number,

4378: (p_prtl_mo_det_mthd_rl in number default hr_api.g_number,
4379: p_prtl_mo_eff_dt_det_rl in number default hr_api.g_number,
4380: p_rndg_rl in number default hr_api.g_number,
4381: p_lwr_lmt_calc_rl in number default hr_api.g_number,
4382: p_upr_lmt_calc_rl in number default hr_api.g_number,
4383: p_val_calc_rl in number default hr_api.g_number,
4384: p_vstg_for_acty_rt_id in number default hr_api.g_number,
4385: p_actl_prem_id in number default hr_api.g_number,
4386: p_parnt_acty_base_rt_id in number default hr_api.g_number,

Line 4383: p_val_calc_rl in number default hr_api.g_number,

4379: p_prtl_mo_eff_dt_det_rl in number default hr_api.g_number,
4380: p_rndg_rl in number default hr_api.g_number,
4381: p_lwr_lmt_calc_rl in number default hr_api.g_number,
4382: p_upr_lmt_calc_rl in number default hr_api.g_number,
4383: p_val_calc_rl in number default hr_api.g_number,
4384: p_vstg_for_acty_rt_id in number default hr_api.g_number,
4385: p_actl_prem_id in number default hr_api.g_number,
4386: p_parnt_acty_base_rt_id in number default hr_api.g_number,
4387: p_pgm_id in number default hr_api.g_number,

Line 4384: p_vstg_for_acty_rt_id in number default hr_api.g_number,

4380: p_rndg_rl in number default hr_api.g_number,
4381: p_lwr_lmt_calc_rl in number default hr_api.g_number,
4382: p_upr_lmt_calc_rl in number default hr_api.g_number,
4383: p_val_calc_rl in number default hr_api.g_number,
4384: p_vstg_for_acty_rt_id in number default hr_api.g_number,
4385: p_actl_prem_id in number default hr_api.g_number,
4386: p_parnt_acty_base_rt_id in number default hr_api.g_number,
4387: p_pgm_id in number default hr_api.g_number,
4388: p_ptip_id in number default hr_api.g_number,

Line 4385: p_actl_prem_id in number default hr_api.g_number,

4381: p_lwr_lmt_calc_rl in number default hr_api.g_number,
4382: p_upr_lmt_calc_rl in number default hr_api.g_number,
4383: p_val_calc_rl in number default hr_api.g_number,
4384: p_vstg_for_acty_rt_id in number default hr_api.g_number,
4385: p_actl_prem_id in number default hr_api.g_number,
4386: p_parnt_acty_base_rt_id in number default hr_api.g_number,
4387: p_pgm_id in number default hr_api.g_number,
4388: p_ptip_id in number default hr_api.g_number,
4389: p_oipl_id in number default hr_api.g_number,

Line 4386: p_parnt_acty_base_rt_id in number default hr_api.g_number,

4382: p_upr_lmt_calc_rl in number default hr_api.g_number,
4383: p_val_calc_rl in number default hr_api.g_number,
4384: p_vstg_for_acty_rt_id in number default hr_api.g_number,
4385: p_actl_prem_id in number default hr_api.g_number,
4386: p_parnt_acty_base_rt_id in number default hr_api.g_number,
4387: p_pgm_id in number default hr_api.g_number,
4388: p_ptip_id in number default hr_api.g_number,
4389: p_oipl_id in number default hr_api.g_number,
4390: p_opt_id in number default hr_api.g_number,

Line 4387: p_pgm_id in number default hr_api.g_number,

4383: p_val_calc_rl in number default hr_api.g_number,
4384: p_vstg_for_acty_rt_id in number default hr_api.g_number,
4385: p_actl_prem_id in number default hr_api.g_number,
4386: p_parnt_acty_base_rt_id in number default hr_api.g_number,
4387: p_pgm_id in number default hr_api.g_number,
4388: p_ptip_id in number default hr_api.g_number,
4389: p_oipl_id in number default hr_api.g_number,
4390: p_opt_id in number default hr_api.g_number,
4391: p_oiplip_id in number default hr_api.g_number,

Line 4388: p_ptip_id in number default hr_api.g_number,

4384: p_vstg_for_acty_rt_id in number default hr_api.g_number,
4385: p_actl_prem_id in number default hr_api.g_number,
4386: p_parnt_acty_base_rt_id in number default hr_api.g_number,
4387: p_pgm_id in number default hr_api.g_number,
4388: p_ptip_id in number default hr_api.g_number,
4389: p_oipl_id in number default hr_api.g_number,
4390: p_opt_id in number default hr_api.g_number,
4391: p_oiplip_id in number default hr_api.g_number,
4392: p_plip_id in number default hr_api.g_number,

Line 4389: p_oipl_id in number default hr_api.g_number,

4385: p_actl_prem_id in number default hr_api.g_number,
4386: p_parnt_acty_base_rt_id in number default hr_api.g_number,
4387: p_pgm_id in number default hr_api.g_number,
4388: p_ptip_id in number default hr_api.g_number,
4389: p_oipl_id in number default hr_api.g_number,
4390: p_opt_id in number default hr_api.g_number,
4391: p_oiplip_id in number default hr_api.g_number,
4392: p_plip_id in number default hr_api.g_number,
4393: p_pl_id in number default hr_api.g_number,

Line 4390: p_opt_id in number default hr_api.g_number,

4386: p_parnt_acty_base_rt_id in number default hr_api.g_number,
4387: p_pgm_id in number default hr_api.g_number,
4388: p_ptip_id in number default hr_api.g_number,
4389: p_oipl_id in number default hr_api.g_number,
4390: p_opt_id in number default hr_api.g_number,
4391: p_oiplip_id in number default hr_api.g_number,
4392: p_plip_id in number default hr_api.g_number,
4393: p_pl_id in number default hr_api.g_number,
4394: -- bug: 5367301 start

Line 4391: p_oiplip_id in number default hr_api.g_number,

4387: p_pgm_id in number default hr_api.g_number,
4388: p_ptip_id in number default hr_api.g_number,
4389: p_oipl_id in number default hr_api.g_number,
4390: p_opt_id in number default hr_api.g_number,
4391: p_oiplip_id in number default hr_api.g_number,
4392: p_plip_id in number default hr_api.g_number,
4393: p_pl_id in number default hr_api.g_number,
4394: -- bug: 5367301 start
4395: p_element_type_id in number default hr_api.g_number,

Line 4392: p_plip_id in number default hr_api.g_number,

4388: p_ptip_id in number default hr_api.g_number,
4389: p_oipl_id in number default hr_api.g_number,
4390: p_opt_id in number default hr_api.g_number,
4391: p_oiplip_id in number default hr_api.g_number,
4392: p_plip_id in number default hr_api.g_number,
4393: p_pl_id in number default hr_api.g_number,
4394: -- bug: 5367301 start
4395: p_element_type_id in number default hr_api.g_number,
4396: p_input_va_calc_rl in number default hr_api.g_number,

Line 4393: p_pl_id in number default hr_api.g_number,

4389: p_oipl_id in number default hr_api.g_number,
4390: p_opt_id in number default hr_api.g_number,
4391: p_oiplip_id in number default hr_api.g_number,
4392: p_plip_id in number default hr_api.g_number,
4393: p_pl_id in number default hr_api.g_number,
4394: -- bug: 5367301 start
4395: p_element_type_id in number default hr_api.g_number,
4396: p_input_va_calc_rl in number default hr_api.g_number,
4397: p_element_det_rl in number default hr_api.g_number,

Line 4395: p_element_type_id in number default hr_api.g_number,

4391: p_oiplip_id in number default hr_api.g_number,
4392: p_plip_id in number default hr_api.g_number,
4393: p_pl_id in number default hr_api.g_number,
4394: -- bug: 5367301 start
4395: p_element_type_id in number default hr_api.g_number,
4396: p_input_va_calc_rl in number default hr_api.g_number,
4397: p_element_det_rl in number default hr_api.g_number,
4398: -- bug: 5367301 end
4399: p_datetrack_mode in varchar2,

Line 4396: p_input_va_calc_rl in number default hr_api.g_number,

4392: p_plip_id in number default hr_api.g_number,
4393: p_pl_id in number default hr_api.g_number,
4394: -- bug: 5367301 start
4395: p_element_type_id in number default hr_api.g_number,
4396: p_input_va_calc_rl in number default hr_api.g_number,
4397: p_element_det_rl in number default hr_api.g_number,
4398: -- bug: 5367301 end
4399: p_datetrack_mode in varchar2,
4400: p_validation_start_date in date,

Line 4397: p_element_det_rl in number default hr_api.g_number,

4393: p_pl_id in number default hr_api.g_number,
4394: -- bug: 5367301 start
4395: p_element_type_id in number default hr_api.g_number,
4396: p_input_va_calc_rl in number default hr_api.g_number,
4397: p_element_det_rl in number default hr_api.g_number,
4398: -- bug: 5367301 end
4399: p_datetrack_mode in varchar2,
4400: p_validation_start_date in date,
4401: p_validation_end_date in date) Is

Line 4412: hr_api.mandatory_arg_error

4408: hr_utility.set_location('Entering:'||l_proc, 5);
4409: --
4410: -- Ensure that the p_datetrack_mode argument is not null
4411: --
4412: hr_api.mandatory_arg_error
4413: (p_api_name => l_proc,
4414: p_argument => 'datetrack_mode',
4415: p_argument_value => p_datetrack_mode);
4416: --

Line 4424: hr_api.mandatory_arg_error

4420: --
4421: --
4422: -- Ensure the arguments are not null
4423: --
4424: hr_api.mandatory_arg_error
4425: (p_api_name => l_proc,
4426: p_argument => 'validation_start_date',
4427: p_argument_value => p_validation_start_date);
4428: --

Line 4429: hr_api.mandatory_arg_error

4425: (p_api_name => l_proc,
4426: p_argument => 'validation_start_date',
4427: p_argument_value => p_validation_start_date);
4428: --
4429: hr_api.mandatory_arg_error
4430: (p_api_name => l_proc,
4431: p_argument => 'validation_end_date',
4432: p_argument_value => p_validation_end_date);
4433: --

Line 4434: If ((nvl(p_prtl_mo_det_mthd_rl, hr_api.g_number) <> hr_api.g_number) and

4430: (p_api_name => l_proc,
4431: p_argument => 'validation_end_date',
4432: p_argument_value => p_validation_end_date);
4433: --
4434: If ((nvl(p_prtl_mo_det_mthd_rl, hr_api.g_number) <> hr_api.g_number) and
4435: NOT (dt_api.check_min_max_dates
4436: (p_base_table_name => 'ff_formulas_f',
4437: p_base_key_column => 'formula_id',
4438: p_base_key_value => p_prtl_mo_det_mthd_rl,

Line 4444: If ((nvl(p_prtl_mo_eff_dt_det_rl, hr_api.g_number) <> hr_api.g_number) and

4440: p_to_date => p_validation_end_date))) Then
4441: l_table_name := 'ff_formulas_f';
4442: Raise l_integrity_error;
4443: End If;
4444: If ((nvl(p_prtl_mo_eff_dt_det_rl, hr_api.g_number) <> hr_api.g_number) and
4445: NOT (dt_api.check_min_max_dates
4446: (p_base_table_name => 'ff_formulas_f',
4447: p_base_key_column => 'formula_id',
4448: p_base_key_value => p_prtl_mo_eff_dt_det_rl,

Line 4454: If ((nvl(p_rndg_rl, hr_api.g_number) <> hr_api.g_number) and

4450: p_to_date => p_validation_end_date))) Then
4451: l_table_name := 'ff_formulas_f';
4452: Raise l_integrity_error;
4453: End If;
4454: If ((nvl(p_rndg_rl, hr_api.g_number) <> hr_api.g_number) and
4455: NOT (dt_api.check_min_max_dates
4456: (p_base_table_name => 'ff_formulas_f',
4457: p_base_key_column => 'formula_id',
4458: p_base_key_value => p_rndg_rl,

Line 4464: If ((nvl(p_lwr_lmt_calc_rl, hr_api.g_number) <> hr_api.g_number) and

4460: p_to_date => p_validation_end_date))) Then
4461: l_table_name := 'ff_formulas_f';
4462: Raise l_integrity_error;
4463: End If;
4464: If ((nvl(p_lwr_lmt_calc_rl, hr_api.g_number) <> hr_api.g_number) and
4465: NOT (dt_api.check_min_max_dates
4466: (p_base_table_name => 'ff_formulas_f',
4467: p_base_key_column => 'formula_id',
4468: p_base_key_value => p_lwr_lmt_calc_rl,

Line 4474: If ((nvl(p_upr_lmt_calc_rl, hr_api.g_number) <> hr_api.g_number) and

4470: p_to_date => p_validation_end_date))) Then
4471: l_table_name := 'ff_formulas_f';
4472: Raise l_integrity_error;
4473: End If;
4474: If ((nvl(p_upr_lmt_calc_rl, hr_api.g_number) <> hr_api.g_number) and
4475: NOT (dt_api.check_min_max_dates
4476: (p_base_table_name => 'ff_formulas_f',
4477: p_base_key_column => 'formula_id',
4478: p_base_key_value => p_upr_lmt_calc_rl,

Line 4484: If ((nvl(p_val_calc_rl, hr_api.g_number) <> hr_api.g_number) and

4480: p_to_date => p_validation_end_date))) Then
4481: l_table_name := 'ff_formulas_f';
4482: Raise l_integrity_error;
4483: End If;
4484: If ((nvl(p_val_calc_rl, hr_api.g_number) <> hr_api.g_number) and
4485: NOT (dt_api.check_min_max_dates
4486: (p_base_table_name => 'ff_formulas_f',
4487: p_base_key_column => 'formula_id',
4488: p_base_key_value => p_val_calc_rl,

Line 4494: If ((nvl(p_vstg_for_acty_rt_id, hr_api.g_number) <> hr_api.g_number) and

4490: p_to_date => p_validation_end_date))) Then
4491: l_table_name := 'ff_formulas_f';
4492: Raise l_integrity_error;
4493: End If;
4494: If ((nvl(p_vstg_for_acty_rt_id, hr_api.g_number) <> hr_api.g_number) and
4495: NOT (dt_api.check_min_max_dates
4496: (p_base_table_name => 'ben_vstg_for_acty_rt_f',
4497: p_base_key_column => 'vstg_for_acty_rt_id',
4498: p_base_key_value => p_vstg_for_acty_rt_id,

Line 4504: If ((nvl(p_actl_prem_id, hr_api.g_number) <> hr_api.g_number) and

4500: p_to_date => p_validation_end_date))) Then
4501: l_table_name := 'ben_vstg_for_acty_rt_f';
4502: Raise l_integrity_error;
4503: End If;
4504: If ((nvl(p_actl_prem_id, hr_api.g_number) <> hr_api.g_number) and
4505: NOT (dt_api.check_min_max_dates
4506: (p_base_table_name => 'ben_actl_prem_f',
4507: p_base_key_column => 'actl_prem_id',
4508: p_base_key_value => p_actl_prem_id,

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

4510: p_to_date => p_validation_end_date))) Then
4511: l_table_name := 'ben_vstg_for_acty_rt_f';
4512: Raise l_integrity_error;
4513: End If;
4514: If ((nvl(p_pgm_id, hr_api.g_number) <> hr_api.g_number) and
4515: NOT (dt_api.check_min_max_dates
4516: (p_base_table_name => 'ben_pgm_f',
4517: p_base_key_column => 'pgm_id',
4518: p_base_key_value => p_pgm_id,

Line 4524: If ((nvl(p_parnt_acty_base_rt_id, hr_api.g_number) <> hr_api.g_number) and

4520: p_to_date => p_validation_end_date))) Then
4521: l_table_name := 'ben_pgm_f';
4522: Raise l_integrity_error;
4523: End If;
4524: If ((nvl(p_parnt_acty_base_rt_id, hr_api.g_number) <> hr_api.g_number) and
4525: NOT (dt_api.check_min_max_dates
4526: (p_base_table_name => 'ben_acty_base_rt_f',
4527: p_base_key_column => 'acty_base_rt_id',
4528: p_base_key_value => p_parnt_acty_base_rt_id,

Line 4534: If ((nvl(p_ptip_id, hr_api.g_number) <> hr_api.g_number) and

4530: p_to_date => p_validation_end_date))) Then
4531: l_table_name := 'ben_acty_base_rt_f';
4532: Raise l_integrity_error;
4533: End If;
4534: If ((nvl(p_ptip_id, hr_api.g_number) <> hr_api.g_number) and
4535: NOT (dt_api.check_min_max_dates
4536: (p_base_table_name => 'ben_ptip_f',
4537: p_base_key_column => 'ptip_id',
4538: p_base_key_value => p_ptip_id,

Line 4544: If ((nvl(p_oipl_id, hr_api.g_number) <> hr_api.g_number) and

4540: p_to_date => p_validation_end_date))) Then
4541: l_table_name := 'ben_ptip_f';
4542: Raise l_integrity_error;
4543: End If;
4544: If ((nvl(p_oipl_id, hr_api.g_number) <> hr_api.g_number) and
4545: NOT (dt_api.check_min_max_dates
4546: (p_base_table_name => 'ben_oipl_f',
4547: p_base_key_column => 'oipl_id',
4548: p_base_key_value => p_oipl_id,

Line 4554: If ((nvl(p_opt_id, hr_api.g_number) <> hr_api.g_number) and

4550: p_to_date => p_validation_end_date))) Then
4551: l_table_name := 'ben_oipl_f';
4552: Raise l_integrity_error;
4553: End If;
4554: If ((nvl(p_opt_id, hr_api.g_number) <> hr_api.g_number) and
4555: NOT (dt_api.check_min_max_dates
4556: (p_base_table_name => 'ben_opt_f',
4557: p_base_key_column => 'opt_id',
4558: p_base_key_value => p_opt_id,

Line 4564: If ((nvl(p_oiplip_id, hr_api.g_number) <> hr_api.g_number) and

4560: p_to_date => p_validation_end_date))) Then
4561: l_table_name := 'ben_opt_f';
4562: Raise l_integrity_error;
4563: End If;
4564: If ((nvl(p_oiplip_id, hr_api.g_number) <> hr_api.g_number) and
4565: NOT (dt_api.check_min_max_dates
4566: (p_base_table_name => 'ben_oiplip_f',
4567: p_base_key_column => 'oiplip_id',
4568: p_base_key_value => p_oiplip_id,

Line 4574: If ((nvl(p_plip_id, hr_api.g_number) <> hr_api.g_number) and

4570: p_to_date => p_validation_end_date))) Then
4571: l_table_name := 'ben_oiplip_f';
4572: Raise l_integrity_error;
4573: End If;
4574: If ((nvl(p_plip_id, hr_api.g_number) <> hr_api.g_number) and
4575: NOT (dt_api.check_min_max_dates
4576: (p_base_table_name => 'ben_plip_f',
4577: p_base_key_column => 'plip_id',
4578: p_base_key_value => p_plip_id,

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

4580: p_to_date => p_validation_end_date))) Then
4581: l_table_name := 'ben_plip_f';
4582: Raise l_integrity_error;
4583: End If;
4584: If ((nvl(p_pl_id, hr_api.g_number) <> hr_api.g_number) and
4585: NOT (dt_api.check_min_max_dates
4586: (p_base_table_name => 'ben_pl_f',
4587: p_base_key_column => 'pl_id',
4588: p_base_key_value => p_pl_id,

Line 4596: If ((nvl(p_element_type_id, hr_api.g_number) <> hr_api.g_number) and

4592: Raise l_integrity_error;
4593: End If;
4594: -- ELEMENT_TYPE
4595: -- Bug: 5367301 start
4596: If ((nvl(p_element_type_id, hr_api.g_number) <> hr_api.g_number) and
4597: NOT (dt_api.check_min_max_dates
4598: (p_base_table_name => 'pay_element_types_f',
4599: p_base_key_column => 'element_type_id',
4600: p_base_key_value => p_element_type_id,

Line 4607: If ((nvl(p_input_va_calc_rl, hr_api.g_number) <> hr_api.g_number) and

4603: l_table_name := 'pay_element_types_f';
4604: Raise l_integrity_error;
4605: End If;
4606: --
4607: If ((nvl(p_input_va_calc_rl, hr_api.g_number) <> hr_api.g_number) and
4608: NOT (dt_api.check_min_max_dates
4609: (p_base_table_name => 'ff_formulas_f',
4610: p_base_key_column => 'formula_id',
4611: p_base_key_value => p_input_va_calc_rl,

Line 4618: If ((nvl(p_element_det_rl, hr_api.g_number) <> hr_api.g_number) and

4614: l_table_name := 'ff_formulas_f';
4615: Raise l_integrity_error;
4616: End If;
4617: --
4618: If ((nvl(p_element_det_rl, hr_api.g_number) <> hr_api.g_number) and
4619: NOT (dt_api.check_min_max_dates
4620: (p_base_table_name => 'ff_formulas_f',
4621: p_base_key_column => 'formula_id',
4622: p_base_key_value => p_element_det_rl,

Line 4706: hr_api.mandatory_arg_error

4702: hr_utility.set_location('Entering:'||l_proc, 5);
4703: --
4704: -- Ensure that the p_datetrack_mode argument is not null
4705: --
4706: hr_api.mandatory_arg_error
4707: (p_api_name => l_proc,
4708: p_argument => 'datetrack_mode',
4709: p_argument_value => p_datetrack_mode);
4710: --

Line 4720: hr_api.mandatory_arg_error

4716: --
4717: --
4718: -- Ensure the arguments are not null
4719: --
4720: hr_api.mandatory_arg_error
4721: (p_api_name => l_proc,
4722: p_argument => 'validation_start_date',
4723: p_argument_value => p_validation_start_date);
4724: --

Line 4725: hr_api.mandatory_arg_error

4721: (p_api_name => l_proc,
4722: p_argument => 'validation_start_date',
4723: p_argument_value => p_validation_start_date);
4724: --
4725: hr_api.mandatory_arg_error
4726: (p_api_name => l_proc,
4727: p_argument => 'validation_end_date',
4728: p_argument_value => p_validation_end_date);
4729: --

Line 4730: hr_api.mandatory_arg_error

4726: (p_api_name => l_proc,
4727: p_argument => 'validation_end_date',
4728: p_argument_value => p_validation_end_date);
4729: --
4730: hr_api.mandatory_arg_error
4731: (p_api_name => l_proc,
4732: p_argument => 'acty_base_rt_id',
4733: p_argument_value => p_acty_base_rt_id);
4734: --

Line 4926: (nvl(p_rt_mlt_cd,hr_api.g_varchar2)

4922: p_object_version_number => p_object_version_number);
4923: --
4924: if (l_api_updating
4925: and
4926: (nvl(p_rt_mlt_cd,hr_api.g_varchar2)
4927: <> nvl(ben_abr_shd.g_old_rec.rt_mlt_cd,hr_api.g_varchar2) or
4928: nvl(p_val,hr_api.g_number)
4929: <> nvl(ben_abr_shd.g_old_rec.val,hr_api.g_number) or
4930: nvl(p_mn_elcn_val,hr_api.g_number)

Line 4927: <> nvl(ben_abr_shd.g_old_rec.rt_mlt_cd,hr_api.g_varchar2) or

4923: --
4924: if (l_api_updating
4925: and
4926: (nvl(p_rt_mlt_cd,hr_api.g_varchar2)
4927: <> nvl(ben_abr_shd.g_old_rec.rt_mlt_cd,hr_api.g_varchar2) or
4928: nvl(p_val,hr_api.g_number)
4929: <> nvl(ben_abr_shd.g_old_rec.val,hr_api.g_number) or
4930: nvl(p_mn_elcn_val,hr_api.g_number)
4931: <> nvl(ben_abr_shd.g_old_rec.mn_elcn_val,hr_api.g_number) or

Line 4928: nvl(p_val,hr_api.g_number)

4924: if (l_api_updating
4925: and
4926: (nvl(p_rt_mlt_cd,hr_api.g_varchar2)
4927: <> nvl(ben_abr_shd.g_old_rec.rt_mlt_cd,hr_api.g_varchar2) or
4928: nvl(p_val,hr_api.g_number)
4929: <> nvl(ben_abr_shd.g_old_rec.val,hr_api.g_number) or
4930: nvl(p_mn_elcn_val,hr_api.g_number)
4931: <> nvl(ben_abr_shd.g_old_rec.mn_elcn_val,hr_api.g_number) or
4932: nvl(p_mx_elcn_val,hr_api.g_number)

Line 4929: <> nvl(ben_abr_shd.g_old_rec.val,hr_api.g_number) or

4925: and
4926: (nvl(p_rt_mlt_cd,hr_api.g_varchar2)
4927: <> nvl(ben_abr_shd.g_old_rec.rt_mlt_cd,hr_api.g_varchar2) or
4928: nvl(p_val,hr_api.g_number)
4929: <> nvl(ben_abr_shd.g_old_rec.val,hr_api.g_number) or
4930: nvl(p_mn_elcn_val,hr_api.g_number)
4931: <> nvl(ben_abr_shd.g_old_rec.mn_elcn_val,hr_api.g_number) or
4932: nvl(p_mx_elcn_val,hr_api.g_number)
4933: <> nvl(ben_abr_shd.g_old_rec.mx_elcn_val,hr_api.g_number) or

Line 4930: nvl(p_mn_elcn_val,hr_api.g_number)

4926: (nvl(p_rt_mlt_cd,hr_api.g_varchar2)
4927: <> nvl(ben_abr_shd.g_old_rec.rt_mlt_cd,hr_api.g_varchar2) or
4928: nvl(p_val,hr_api.g_number)
4929: <> nvl(ben_abr_shd.g_old_rec.val,hr_api.g_number) or
4930: nvl(p_mn_elcn_val,hr_api.g_number)
4931: <> nvl(ben_abr_shd.g_old_rec.mn_elcn_val,hr_api.g_number) or
4932: nvl(p_mx_elcn_val,hr_api.g_number)
4933: <> nvl(ben_abr_shd.g_old_rec.mx_elcn_val,hr_api.g_number) or
4934: nvl(p_incrmt_elcn_val,hr_api.g_number)

Line 4931: <> nvl(ben_abr_shd.g_old_rec.mn_elcn_val,hr_api.g_number) or

4927: <> nvl(ben_abr_shd.g_old_rec.rt_mlt_cd,hr_api.g_varchar2) or
4928: nvl(p_val,hr_api.g_number)
4929: <> nvl(ben_abr_shd.g_old_rec.val,hr_api.g_number) or
4930: nvl(p_mn_elcn_val,hr_api.g_number)
4931: <> nvl(ben_abr_shd.g_old_rec.mn_elcn_val,hr_api.g_number) or
4932: nvl(p_mx_elcn_val,hr_api.g_number)
4933: <> nvl(ben_abr_shd.g_old_rec.mx_elcn_val,hr_api.g_number) or
4934: nvl(p_incrmt_elcn_val,hr_api.g_number)
4935: <> nvl(ben_abr_shd.g_old_rec.incrmt_elcn_val,hr_api.g_number) or

Line 4932: nvl(p_mx_elcn_val,hr_api.g_number)

4928: nvl(p_val,hr_api.g_number)
4929: <> nvl(ben_abr_shd.g_old_rec.val,hr_api.g_number) or
4930: nvl(p_mn_elcn_val,hr_api.g_number)
4931: <> nvl(ben_abr_shd.g_old_rec.mn_elcn_val,hr_api.g_number) or
4932: nvl(p_mx_elcn_val,hr_api.g_number)
4933: <> nvl(ben_abr_shd.g_old_rec.mx_elcn_val,hr_api.g_number) or
4934: nvl(p_incrmt_elcn_val,hr_api.g_number)
4935: <> nvl(ben_abr_shd.g_old_rec.incrmt_elcn_val,hr_api.g_number) or
4936: -- begin bug 2282186

Line 4933: <> nvl(ben_abr_shd.g_old_rec.mx_elcn_val,hr_api.g_number) or

4929: <> nvl(ben_abr_shd.g_old_rec.val,hr_api.g_number) or
4930: nvl(p_mn_elcn_val,hr_api.g_number)
4931: <> nvl(ben_abr_shd.g_old_rec.mn_elcn_val,hr_api.g_number) or
4932: nvl(p_mx_elcn_val,hr_api.g_number)
4933: <> nvl(ben_abr_shd.g_old_rec.mx_elcn_val,hr_api.g_number) or
4934: nvl(p_incrmt_elcn_val,hr_api.g_number)
4935: <> nvl(ben_abr_shd.g_old_rec.incrmt_elcn_val,hr_api.g_number) or
4936: -- begin bug 2282186
4937: nvl(p_dflt_val,hr_api.g_number)

Line 4934: nvl(p_incrmt_elcn_val,hr_api.g_number)

4930: nvl(p_mn_elcn_val,hr_api.g_number)
4931: <> nvl(ben_abr_shd.g_old_rec.mn_elcn_val,hr_api.g_number) or
4932: nvl(p_mx_elcn_val,hr_api.g_number)
4933: <> nvl(ben_abr_shd.g_old_rec.mx_elcn_val,hr_api.g_number) or
4934: nvl(p_incrmt_elcn_val,hr_api.g_number)
4935: <> nvl(ben_abr_shd.g_old_rec.incrmt_elcn_val,hr_api.g_number) or
4936: -- begin bug 2282186
4937: nvl(p_dflt_val,hr_api.g_number)
4938: <> nvl(ben_abr_shd.g_old_rec.dflt_val,hr_api.g_number) or

Line 4935: <> nvl(ben_abr_shd.g_old_rec.incrmt_elcn_val,hr_api.g_number) or

4931: <> nvl(ben_abr_shd.g_old_rec.mn_elcn_val,hr_api.g_number) or
4932: nvl(p_mx_elcn_val,hr_api.g_number)
4933: <> nvl(ben_abr_shd.g_old_rec.mx_elcn_val,hr_api.g_number) or
4934: nvl(p_incrmt_elcn_val,hr_api.g_number)
4935: <> nvl(ben_abr_shd.g_old_rec.incrmt_elcn_val,hr_api.g_number) or
4936: -- begin bug 2282186
4937: nvl(p_dflt_val,hr_api.g_number)
4938: <> nvl(ben_abr_shd.g_old_rec.dflt_val,hr_api.g_number) or
4939: -- end bug 2282186

Line 4937: nvl(p_dflt_val,hr_api.g_number)

4933: <> nvl(ben_abr_shd.g_old_rec.mx_elcn_val,hr_api.g_number) or
4934: nvl(p_incrmt_elcn_val,hr_api.g_number)
4935: <> nvl(ben_abr_shd.g_old_rec.incrmt_elcn_val,hr_api.g_number) or
4936: -- begin bug 2282186
4937: nvl(p_dflt_val,hr_api.g_number)
4938: <> nvl(ben_abr_shd.g_old_rec.dflt_val,hr_api.g_number) or
4939: -- end bug 2282186
4940: nvl(p_rt_typ_cd,hr_api.g_varchar2)
4941: <> nvl(ben_abr_shd.g_old_rec.rt_typ_cd,hr_api.g_varchar2) or

Line 4938: <> nvl(ben_abr_shd.g_old_rec.dflt_val,hr_api.g_number) or

4934: nvl(p_incrmt_elcn_val,hr_api.g_number)
4935: <> nvl(ben_abr_shd.g_old_rec.incrmt_elcn_val,hr_api.g_number) or
4936: -- begin bug 2282186
4937: nvl(p_dflt_val,hr_api.g_number)
4938: <> nvl(ben_abr_shd.g_old_rec.dflt_val,hr_api.g_number) or
4939: -- end bug 2282186
4940: nvl(p_rt_typ_cd,hr_api.g_varchar2)
4941: <> nvl(ben_abr_shd.g_old_rec.rt_typ_cd,hr_api.g_varchar2) or
4942: nvl(p_bnft_rt_typ_cd,hr_api.g_varchar2)

Line 4940: nvl(p_rt_typ_cd,hr_api.g_varchar2)

4936: -- begin bug 2282186
4937: nvl(p_dflt_val,hr_api.g_number)
4938: <> nvl(ben_abr_shd.g_old_rec.dflt_val,hr_api.g_number) or
4939: -- end bug 2282186
4940: nvl(p_rt_typ_cd,hr_api.g_varchar2)
4941: <> nvl(ben_abr_shd.g_old_rec.rt_typ_cd,hr_api.g_varchar2) or
4942: nvl(p_bnft_rt_typ_cd,hr_api.g_varchar2)
4943: <> nvl(ben_abr_shd.g_old_rec.bnft_rt_typ_cd,hr_api.g_varchar2) or
4944: nvl(p_val_calc_rl,hr_api.g_number)

Line 4941: <> nvl(ben_abr_shd.g_old_rec.rt_typ_cd,hr_api.g_varchar2) or

4937: nvl(p_dflt_val,hr_api.g_number)
4938: <> nvl(ben_abr_shd.g_old_rec.dflt_val,hr_api.g_number) or
4939: -- end bug 2282186
4940: nvl(p_rt_typ_cd,hr_api.g_varchar2)
4941: <> nvl(ben_abr_shd.g_old_rec.rt_typ_cd,hr_api.g_varchar2) or
4942: nvl(p_bnft_rt_typ_cd,hr_api.g_varchar2)
4943: <> nvl(ben_abr_shd.g_old_rec.bnft_rt_typ_cd,hr_api.g_varchar2) or
4944: nvl(p_val_calc_rl,hr_api.g_number)
4945: <> nvl(ben_abr_shd.g_old_rec.val_calc_rl,hr_api.g_number)

Line 4942: nvl(p_bnft_rt_typ_cd,hr_api.g_varchar2)

4938: <> nvl(ben_abr_shd.g_old_rec.dflt_val,hr_api.g_number) or
4939: -- end bug 2282186
4940: nvl(p_rt_typ_cd,hr_api.g_varchar2)
4941: <> nvl(ben_abr_shd.g_old_rec.rt_typ_cd,hr_api.g_varchar2) or
4942: nvl(p_bnft_rt_typ_cd,hr_api.g_varchar2)
4943: <> nvl(ben_abr_shd.g_old_rec.bnft_rt_typ_cd,hr_api.g_varchar2) or
4944: nvl(p_val_calc_rl,hr_api.g_number)
4945: <> nvl(ben_abr_shd.g_old_rec.val_calc_rl,hr_api.g_number)
4946: )

Line 4943: <> nvl(ben_abr_shd.g_old_rec.bnft_rt_typ_cd,hr_api.g_varchar2) or

4939: -- end bug 2282186
4940: nvl(p_rt_typ_cd,hr_api.g_varchar2)
4941: <> nvl(ben_abr_shd.g_old_rec.rt_typ_cd,hr_api.g_varchar2) or
4942: nvl(p_bnft_rt_typ_cd,hr_api.g_varchar2)
4943: <> nvl(ben_abr_shd.g_old_rec.bnft_rt_typ_cd,hr_api.g_varchar2) or
4944: nvl(p_val_calc_rl,hr_api.g_number)
4945: <> nvl(ben_abr_shd.g_old_rec.val_calc_rl,hr_api.g_number)
4946: )
4947: or

Line 4944: nvl(p_val_calc_rl,hr_api.g_number)

4940: nvl(p_rt_typ_cd,hr_api.g_varchar2)
4941: <> nvl(ben_abr_shd.g_old_rec.rt_typ_cd,hr_api.g_varchar2) or
4942: nvl(p_bnft_rt_typ_cd,hr_api.g_varchar2)
4943: <> nvl(ben_abr_shd.g_old_rec.bnft_rt_typ_cd,hr_api.g_varchar2) or
4944: nvl(p_val_calc_rl,hr_api.g_number)
4945: <> nvl(ben_abr_shd.g_old_rec.val_calc_rl,hr_api.g_number)
4946: )
4947: or
4948: not l_api_updating)

Line 4945: <> nvl(ben_abr_shd.g_old_rec.val_calc_rl,hr_api.g_number)

4941: <> nvl(ben_abr_shd.g_old_rec.rt_typ_cd,hr_api.g_varchar2) or
4942: nvl(p_bnft_rt_typ_cd,hr_api.g_varchar2)
4943: <> nvl(ben_abr_shd.g_old_rec.bnft_rt_typ_cd,hr_api.g_varchar2) or
4944: nvl(p_val_calc_rl,hr_api.g_number)
4945: <> nvl(ben_abr_shd.g_old_rec.val_calc_rl,hr_api.g_number)
4946: )
4947: or
4948: not l_api_updating)
4949: then

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

5378:
5379: -- Call all supporting business operations
5380: --
5381:
5382: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
5383:
5384: chk_acty_base_rt_id(p_acty_base_rt_id => p_rec.acty_base_rt_id,
5385: p_effective_date => p_effective_date,
5386: p_object_version_number => p_rec.object_version_number);

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

5741: --
5742: -- Call all supporting business operations
5743: --
5744: --
5745: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
5746: --
5747: -- Call the datetrack update integrity operation
5748: --
5749:

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

6172: hr_utility.set_location('Entering:'|| l_proc, 10);
6173: --
6174: -- Ensure that all the mandatory parameter are not null
6175: --
6176: hr_api.mandatory_arg_error(p_api_name => l_proc,
6177: p_argument => 'acty_base_rt_id',
6178: p_argument_value => p_acty_base_rt_id);
6179: --
6180: open csr_leg_code;