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 BEN_ABR_SHD

Line 48: l_api_updating := ben_abr_shd.api_updating

44: Begin
45: --
46: hr_utility.set_location('Entering:'||l_proc, 5);
47: --
48: l_api_updating := ben_abr_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_acty_base_rt_id => p_acty_base_rt_id,
51: p_object_version_number => p_object_version_number);
52: --

Line 55: <> ben_abr_shd.g_old_rec.acty_base_rt_id) then

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: --
59: ben_abr_shd.constraint_error('BEN_ACTY_BASE_RT_F_PK');

Line 59: ben_abr_shd.constraint_error('BEN_ACTY_BASE_RT_F_PK');

55: <> ben_abr_shd.g_old_rec.acty_base_rt_id) then
56: --
57: -- raise error as PK has changed
58: --
59: ben_abr_shd.constraint_error('BEN_ACTY_BASE_RT_F_PK');
60: --
61: elsif not l_api_updating then
62: --
63: -- check if PK is null

Line 69: ben_abr_shd.constraint_error('BEN_ACTY_BASE_RT_F_PK');

65: if p_acty_base_rt_id is not null then
66: --
67: -- raise error as PK is not null
68: --
69: ben_abr_shd.constraint_error('BEN_ACTY_BASE_RT_F_PK');
70: --
71: end if;
72: --
73: end if;

Line 166: ,p_rec in ben_abr_shd.g_rec_type)

162: ,p_effective_date in date
163: ,p_business_group_id in number
164: ,p_element_type_id in number
165: ,p_rt_mlt_cd in varchar2
166: ,p_rec in ben_abr_shd.g_rec_type)
167: is
168: l_proc varchar2(72) := g_package||'chk_elem_unique';
169: --
170: cursor c_oipl is

Line 406: l_api_updating := ben_abr_shd.api_updating

402: Begin
403: --
404: hr_utility.set_location('Entering:'||l_proc, 5);
405: --
406: l_api_updating := ben_abr_shd.api_updating
407: (p_acty_base_rt_id => p_acty_base_rt_id,
408: p_effective_date => p_effective_date,
409: p_object_version_number => p_object_version_number);
410: --

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 508: l_api_updating := ben_abr_shd.api_updating

504: --
505: Begin
506: hr_utility.set_location('Entering:'||l_proc, 5);
507: --
508: l_api_updating := ben_abr_shd.api_updating
509: (p_acty_base_rt_id => p_acty_base_rt_id,
510: p_effective_date => p_effective_date,
511: p_object_version_number => p_object_version_number);
512: --

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 700: ben_abr_shd.constraint_error('BEN_OIPL_PK') ;

696: open c_oipl ;
697: fetch c_oipl into l_pl_id ;
698: If c_oipl%notfound then
699: close c_oipl ;
700: ben_abr_shd.constraint_error('BEN_OIPL_PK') ;
701: end if ;
702: close c_oipl ;
703: else
704: l_pl_id := p_pl_id ;

Line 718: ben_abr_shd.constraint_error('BEN_OIPLIP_PK') ;

714: open c_oiplip ;
715: fetch c_oiplip into l_oipl_id ;
716: If c_oiplip%notfound then
717: close c_oiplip ;
718: ben_abr_shd.constraint_error('BEN_OIPLIP_PK') ;
719: end if ;
720: close c_oiplip ;
721: else
722: l_oipl_id := p_oipl_id ;

Line 764: (p_rec in ben_abr_shd.g_rec_type,

760: -- Internal table handler use only.
761: --
762: ------------------------------------------------------------------------------
763: procedure chk_elmt_typ_input_val_rqd
764: (p_rec in ben_abr_shd.g_rec_type,
765: p_acty_base_rt_stat_cd in varchar2,
766: p_input_value_id in number,
767: p_ele_rqd_flag in varchar2,
768: p_effective_date in date,

Line 1105: l_api_updating := ben_abr_shd.api_updating

1101:
1102: Begin
1103: --
1104: hr_utility.set_location('Entering:'||l_proc, 5);
1105: l_api_updating := ben_abr_shd.api_updating
1106: (p_acty_base_rt_id => p_acty_base_rt_id,
1107: p_effective_date => p_effective_date,
1108: p_object_version_number => p_object_version_number);
1109: --

Line 1112: <> ben_abr_shd.g_old_rec.prtl_mo_det_mthd_rl

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: --
1116: -- check if value of formula rule is valid.

Line 1158: <> ben_abr_shd.g_old_rec.prtl_mo_eff_dt_det_rl

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: --
1162: -- check if value of formula rule is valid.

Line 1204: <> ben_abr_shd.g_old_rec.rndg_rl

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: --
1208: -- check if value of formula rule is valid.

Line 1247: <> ben_abr_shd.g_old_rec.lwr_lmt_calc_rl

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: --
1251: -- check if value of formula rule is valid.

Line 1276: <> ben_abr_shd.g_old_rec.upr_lmt_calc_rl

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: --
1280: -- check if value of formula rule is valid.

Line 1305: <> ben_abr_shd.g_old_rec.val_calc_rl

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: --
1309: -- check if value of formula rule is valid.

Line 1335: <> ben_abr_shd.g_old_rec.prort_mn_ann_elcn_val_rl

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: --
1339: -- check if value of formula rule is valid.

Line 1366: <> ben_abr_shd.g_old_rec.prort_mx_ann_elcn_val_rl

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: --
1370: -- check if value of formula rule is valid.

Line 1398: <> ben_abr_shd.g_old_rec.mn_mx_elcn_rl

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: --
1402: -- check if value of formula rule is valid.

Line 1429: <> ben_abr_shd.g_old_rec.element_det_rl

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: --
1433: -- check if value of formula rule is valid.

Line 1554: l_api_updating := ben_abr_shd.api_updating

1550: Begin
1551: --
1552: hr_utility.set_location('Entering:'||l_proc, 5);
1553: --
1554: l_api_updating := ben_abr_shd.api_updating
1555: (p_acty_base_rt_id => p_acty_base_rt_id,
1556: p_effective_date => p_effective_date,
1557: p_object_version_number => p_object_version_number);
1558: --

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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 2684: l_api_updating := ben_abr_shd.api_updating

2680: Begin
2681: --
2682: hr_utility.set_location('Entering:'||l_proc, 5);
2683: --
2684: l_api_updating := ben_abr_shd.api_updating
2685: (p_acty_base_rt_id => p_acty_base_rt_id,
2686: p_effective_date => p_effective_date,
2687: p_object_version_number => p_object_version_number);
2688: --

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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 3669: l_api_updating := ben_abr_shd.api_updating

3665: Begin
3666: --
3667: hr_utility.set_location('Entering:'||l_proc,5);
3668: --
3669: l_api_updating := ben_abr_shd.api_updating
3670: (p_acty_base_rt_id => p_acty_base_rt_id,
3671: p_effective_date => p_effective_date,
3672: p_object_version_number => p_object_version_number);
3673: --

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 3691: ben_abr_shd.constraint_error('BEN_ACTY_BASE_RT_FK4');

3687: --
3688: -- raise error as FK does not relate to PK in hr_organization_units
3689: -- table.
3690: --
3691: ben_abr_shd.constraint_error('BEN_ACTY_BASE_RT_FK4');
3692: --
3693: end if;
3694: --
3695: close c1;

Line 3765: l_api_updating := ben_abr_shd.api_updating

3761: Begin
3762: --
3763: hr_utility.set_location('Entering:'||l_proc,5);
3764: --
3765: l_api_updating := ben_abr_shd.api_updating
3766: (p_acty_base_rt_id => p_acty_base_rt_id,
3767: p_effective_date => p_effective_date,
3768: p_object_version_number => p_object_version_number);
3769: --

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 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 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 3873: l_api_updating := ben_abr_shd.api_updating

3869: Begin
3870: --
3871: hr_utility.set_location('Entering:'||l_proc,5);
3872: --
3873: l_api_updating := ben_abr_shd.api_updating
3874: (p_acty_base_rt_id => p_acty_base_rt_id,
3875: p_effective_date => p_effective_date,
3876: p_object_version_number => p_object_version_number);
3877: --

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 3961: l_api_updating := ben_abr_shd.api_updating

3957: Begin
3958: --
3959: hr_utility.set_location('Entering:'||l_proc,5);
3960: --
3961: l_api_updating := ben_abr_shd.api_updating
3962: (p_acty_base_rt_id => p_acty_base_rt_id,
3963: p_effective_date => p_effective_date,
3964: p_object_version_number => p_object_version_number);
3965: --

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 3983: ben_abr_shd.constraint_error('BEN_ACTY_BASE_RT_FK3');

3979: --
3980: -- raise error as FK does not relate to PK in hr_organization_units
3981: -- table.
3982: --
3983: ben_abr_shd.constraint_error('BEN_ACTY_BASE_RT_FK3');
3984: --
3985: end if;
3986: --
3987: close c1;

Line 4071: l_api_updating := ben_abr_shd.api_updating

4067: Begin
4068: --
4069: hr_utility.set_location('Entering:'||l_proc,5);
4070: --
4071: l_api_updating := ben_abr_shd.api_updating
4072: (p_acty_base_rt_id => p_acty_base_rt_id,
4073: p_effective_date => p_effective_date,
4074: p_object_version_number => p_object_version_number);
4075: --

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 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 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 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 4195: l_api_updating := ben_abr_shd.api_updating

4191: Begin
4192: --
4193: hr_utility.set_location('Entering:'||l_proc,5);
4194: --
4195: l_api_updating := ben_abr_shd.api_updating
4196: (p_acty_base_rt_id => p_acty_base_rt_id,
4197: p_effective_date => p_effective_date,
4198: p_object_version_number => p_object_version_number);
4199: --

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 4325: l_curr_uses_varbl_rt_flag := ben_abr_shd.g_old_rec.uses_varbl_rt_flag;

4321: Begin
4322: --
4323: hr_utility.set_location('Entering: '||l_proc,9);
4324: --
4325: l_curr_uses_varbl_rt_flag := ben_abr_shd.g_old_rec.uses_varbl_rt_flag;
4326: --
4327: If l_curr_uses_varbl_rt_flag = 'N' then
4328: --
4329: -- Get next validation start and end dates

Line 4919: l_api_updating := ben_abr_shd.api_updating

4915: Begin
4916: --
4917: hr_utility.set_location('Entering:'||l_proc, 5);
4918: --
4919: l_api_updating := ben_abr_shd.api_updating
4920: (p_acty_base_rt_id => p_acty_base_rt_id,
4921: p_effective_date => p_effective_date,
4922: p_object_version_number => p_object_version_number);
4923: --

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 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 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 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 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 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 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 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 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 5368: (p_rec in ben_abr_shd.g_rec_type,

5364: -- ----------------------------------------------------------------------------
5365: -- |---------------------------< insert_validate >----------------------------|
5366: -- ----------------------------------------------------------------------------
5367: Procedure insert_validate
5368: (p_rec in ben_abr_shd.g_rec_type,
5369: p_effective_date in date,
5370: p_datetrack_mode in varchar2,
5371: p_validation_start_date in date,
5372: p_validation_end_date in date) is

Line 5731: (p_rec in ben_abr_shd.g_rec_type,

5727: -- ----------------------------------------------------------------------------
5728: -- |---------------------------< update_validate >----------------------------|
5729: -- ----------------------------------------------------------------------------
5730: Procedure update_validate
5731: (p_rec in ben_abr_shd.g_rec_type,
5732: p_effective_date in date,
5733: p_datetrack_mode in varchar2,
5734: p_validation_start_date in date,
5735: p_validation_end_date in date) is

Line 6126: (p_rec in ben_abr_shd.g_rec_type,

6122: -- ----------------------------------------------------------------------------
6123: -- |---------------------------< delete_validate >----------------------------|
6124: -- ----------------------------------------------------------------------------
6125: Procedure delete_validate
6126: (p_rec in ben_abr_shd.g_rec_type,
6127: p_effective_date in date,
6128: p_datetrack_mode in varchar2,
6129: p_validation_start_date in date,
6130: p_validation_end_date in date) is