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_VPF_BUS dependencies on BEN_VPF_SHD

Line 48: l_api_updating := ben_vpf_shd.api_updating

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

Line 55: <> ben_vpf_shd.g_old_rec.vrbl_rt_prfl_id) then

51: p_object_version_number => p_object_version_number);
52: --
53: if (l_api_updating
54: and nvl(p_vrbl_rt_prfl_id,hr_api.g_number)
55: <> ben_vpf_shd.g_old_rec.vrbl_rt_prfl_id) then
56: --
57: -- raise error as PK has changed
58: --
59: ben_vpf_shd.constraint_error('BEN_VRBL_RT_PRFL_PK');

Line 59: ben_vpf_shd.constraint_error('BEN_VRBL_RT_PRFL_PK');

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

Line 69: ben_vpf_shd.constraint_error('BEN_VRBL_RT_PRFL_PK');

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

Line 123: l_api_updating := ben_vpf_shd.api_updating

119: Begin
120: --
121: hr_utility.set_location('Entering:'||l_proc, 5);
122: --
123: l_api_updating := ben_vpf_shd.api_updating
124: (p_effective_date => p_effective_date,
125: p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id,
126: p_object_version_number => p_object_version_number);
127: --

Line 130: <> ben_vpf_shd.g_old_rec.vrbl_usg_cd) then

126: p_object_version_number => p_object_version_number);
127: --
128: if (l_api_updating
129: and nvl(p_vrbl_usg_cd,hr_api.g_varchar2)
130: <> ben_vpf_shd.g_old_rec.vrbl_usg_cd) then
131:
132: if ben_vpf_shd.g_old_rec.vrbl_usg_cd = 'RT' then
133: --
134: If (dt_api.rows_exist

Line 132: if ben_vpf_shd.g_old_rec.vrbl_usg_cd = 'RT' then

128: if (l_api_updating
129: and nvl(p_vrbl_usg_cd,hr_api.g_varchar2)
130: <> ben_vpf_shd.g_old_rec.vrbl_usg_cd) then
131:
132: if ben_vpf_shd.g_old_rec.vrbl_usg_cd = 'RT' then
133: --
134: If (dt_api.rows_exist
135: (p_base_table_name => 'ben_acty_vrbl_rt_f',
136: p_base_key_column => 'vrbl_rt_prfl_id',

Line 149: if ben_vpf_shd.g_old_rec.vrbl_usg_cd = 'CVG' then

145: end if;
146: --
147: End If;
148: --
149: if ben_vpf_shd.g_old_rec.vrbl_usg_cd = 'CVG' then
150: --
151: If (dt_api.rows_exist
152: (p_base_table_name => 'ben_bnft_vrbl_rt_f',
153: p_base_key_column => 'vrbl_rt_prfl_id',

Line 167: if ben_vpf_shd.g_old_rec.vrbl_usg_cd = 'ACP' then

163: --
164: End If;
165: --
166: --
167: if ben_vpf_shd.g_old_rec.vrbl_usg_cd = 'ACP' then
168: --
169: If (dt_api.rows_exist
170: (p_base_table_name => 'ben_actl_prem_vrbl_rt_f',
171: p_base_key_column => 'vrbl_rt_prfl_id',

Line 566: l_api_updating := ben_vpf_shd.api_updating

562: Begin
563: --
564: hr_utility.set_location('Entering:'||l_proc, 5);
565: --
566: l_api_updating := ben_vpf_shd.api_updating
567: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id,
568: p_effective_date => p_effective_date,
569: p_object_version_number => p_object_version_number);
570: --

Line 573: <> nvl(ben_vpf_shd.g_old_rec.vrbl_rt_prfl_stat_cd,hr_api.g_varchar2)

569: p_object_version_number => p_object_version_number);
570: --
571: if (l_api_updating
572: and p_vrbl_rt_prfl_stat_cd
573: <> nvl(ben_vpf_shd.g_old_rec.vrbl_rt_prfl_stat_cd,hr_api.g_varchar2)
574: or not l_api_updating)
575: and p_vrbl_rt_prfl_stat_cd is not null then
576: --
577: -- check if value of lookup falls within lookup type.

Line 652: l_api_updating := ben_vpf_shd.api_updating

648: Begin
649: --
650: hr_utility.set_location('Entering:'||l_proc, 5);
651: --
652: l_api_updating := ben_vpf_shd.api_updating
653: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id,
654: p_effective_date => p_effective_date,
655: p_object_version_number => p_object_version_number);
656: --

Line 659: <> ben_vpf_shd.g_old_rec.val_calc_rl

655: p_object_version_number => p_object_version_number);
656: --
657: if (l_api_updating
658: and nvl(p_val_calc_rl,hr_api.g_number)
659: <> ben_vpf_shd.g_old_rec.val_calc_rl
660: or not l_api_updating)
661: and p_val_calc_rl is not null then
662: --
663: -- check if value of formula rule is valid.

Line 745: l_api_updating := ben_vpf_shd.api_updating

741: Begin
742: --
743: hr_utility.set_location('Entering:'||l_proc, 5);
744: --
745: l_api_updating := ben_vpf_shd.api_updating
746: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id,
747: p_effective_date => p_effective_date,
748: p_object_version_number => p_object_version_number);
749: --

Line 752: <> ben_vpf_shd.g_old_rec.rndg_rl

748: p_object_version_number => p_object_version_number);
749: --
750: if (l_api_updating
751: and nvl(p_rndg_rl,hr_api.g_number)
752: <> ben_vpf_shd.g_old_rec.rndg_rl
753: or not l_api_updating)
754: and p_rndg_rl is not null then
755: --
756: -- check if value of formula rule is valid.

Line 838: l_api_updating := ben_vpf_shd.api_updating

834: Begin
835: --
836: hr_utility.set_location('Entering:'||l_proc, 5);
837: --
838: l_api_updating := ben_vpf_shd.api_updating
839: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id,
840: p_effective_date => p_effective_date,
841: p_object_version_number => p_object_version_number);
842: --

Line 845: <> ben_vpf_shd.g_old_rec.lwr_lmt_calc_rl

841: p_object_version_number => p_object_version_number);
842: --
843: if (l_api_updating
844: and nvl(p_lwr_lmt_calc_rl,hr_api.g_number)
845: <> ben_vpf_shd.g_old_rec.lwr_lmt_calc_rl
846: or not l_api_updating)
847: and p_lwr_lmt_calc_rl is not null then
848: --
849: -- check if value of formula rule is valid.

Line 932: l_api_updating := ben_vpf_shd.api_updating

928: Begin
929: --
930: hr_utility.set_location('Entering:'||l_proc, 5);
931: --
932: l_api_updating := ben_vpf_shd.api_updating
933: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id,
934: p_effective_date => p_effective_date,
935: p_object_version_number => p_object_version_number);
936: --

Line 939: <> ben_vpf_shd.g_old_rec.ultmt_lwr_lmt_calc_rl

935: p_object_version_number => p_object_version_number);
936: --
937: if (l_api_updating
938: and nvl(p_ultmt_lwr_lmt_calc_rl,hr_api.g_number)
939: <> ben_vpf_shd.g_old_rec.ultmt_lwr_lmt_calc_rl
940: or not l_api_updating)
941: and p_ultmt_lwr_lmt_calc_rl is not null then
942: --
943: --

Line 1029: l_api_updating := ben_vpf_shd.api_updating

1025: Begin
1026: --
1027: hr_utility.set_location('Entering:'||l_proc, 5);
1028: --
1029: l_api_updating := ben_vpf_shd.api_updating
1030: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id,
1031: p_effective_date => p_effective_date,
1032: p_object_version_number => p_object_version_number);
1033: --

Line 1036: <> ben_vpf_shd.g_old_rec.upr_lmt_calc_rl

1032: p_object_version_number => p_object_version_number);
1033: --
1034: if (l_api_updating
1035: and nvl(p_upr_lmt_calc_rl,hr_api.g_number)
1036: <> ben_vpf_shd.g_old_rec.upr_lmt_calc_rl
1037: or not l_api_updating)
1038: and p_upr_lmt_calc_rl is not null then
1039: --
1040: -- check if value of formula rule is valid.

Line 1123: l_api_updating := ben_vpf_shd.api_updating

1119: Begin
1120: --
1121: hr_utility.set_location('Entering:'||l_proc, 5);
1122: --
1123: l_api_updating := ben_vpf_shd.api_updating
1124: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id,
1125: p_effective_date => p_effective_date,
1126: p_object_version_number => p_object_version_number);
1127: --

Line 1130: <> ben_vpf_shd.g_old_rec.ultmt_upr_lmt_calc_rl

1126: p_object_version_number => p_object_version_number);
1127: --
1128: if (l_api_updating
1129: and nvl(p_ultmt_upr_lmt_calc_rl,hr_api.g_number)
1130: <> ben_vpf_shd.g_old_rec.ultmt_upr_lmt_calc_rl
1131: or not l_api_updating)
1132: and p_ultmt_upr_lmt_calc_rl is not null then
1133: --
1134:

Line 1205: l_api_updating := ben_vpf_shd.api_updating

1201: Begin
1202: --
1203: hr_utility.set_location('Entering:'||l_proc, 5);
1204: --
1205: l_api_updating := ben_vpf_shd.api_updating
1206: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id,
1207: p_effective_date => p_effective_date,
1208: p_object_version_number => p_object_version_number);
1209: --

Line 1212: <> nvl(ben_vpf_shd.g_old_rec.no_mx_elcn_val_dfnd_flag,hr_api.g_varchar2)

1208: p_object_version_number => p_object_version_number);
1209: --
1210: if (l_api_updating
1211: and p_no_mx_elcn_val_dfnd_flag
1212: <> nvl(ben_vpf_shd.g_old_rec.no_mx_elcn_val_dfnd_flag,hr_api.g_varchar2)
1213: or not l_api_updating) then
1214: --
1215: -- check if value of lookup falls within lookup type.
1216: --

Line 1275: l_api_updating := ben_vpf_shd.api_updating

1271: Begin
1272: --
1273: hr_utility.set_location('Entering:'||l_proc, 5);
1274: --
1275: l_api_updating := ben_vpf_shd.api_updating
1276: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id,
1277: p_effective_date => p_effective_date,
1278: p_object_version_number => p_object_version_number);
1279: --

Line 1282: <> nvl(ben_vpf_shd.g_old_rec.no_mn_elcn_val_dfnd_flag,hr_api.g_varchar2)

1278: p_object_version_number => p_object_version_number);
1279: --
1280: if (l_api_updating
1281: and p_no_mn_elcn_val_dfnd_flag
1282: <> nvl(ben_vpf_shd.g_old_rec.no_mn_elcn_val_dfnd_flag,hr_api.g_varchar2)
1283: or not l_api_updating) then
1284: --
1285: -- check if value of lookup falls within lookup type.
1286: --

Line 1345: l_api_updating := ben_vpf_shd.api_updating

1341: Begin
1342: --
1343: hr_utility.set_location('Entering:'||l_proc, 5);
1344: --
1345: l_api_updating := ben_vpf_shd.api_updating
1346: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id,
1347: p_effective_date => p_effective_date,
1348: p_object_version_number => p_object_version_number);
1349: --

Line 1352: <> nvl(ben_vpf_shd.g_old_rec.alwys_sum_all_cvg_flag,hr_api.g_varchar2)

1348: p_object_version_number => p_object_version_number);
1349: --
1350: if (l_api_updating
1351: and p_alwys_sum_all_cvg_flag
1352: <> nvl(ben_vpf_shd.g_old_rec.alwys_sum_all_cvg_flag,hr_api.g_varchar2)
1353: or not l_api_updating) then
1354: --
1355: -- check if value of lookup falls within lookup type.
1356: --

Line 1415: l_api_updating := ben_vpf_shd.api_updating

1411: Begin
1412: --
1413: hr_utility.set_location('Entering:'||l_proc, 5);
1414: --
1415: l_api_updating := ben_vpf_shd.api_updating
1416: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id,
1417: p_effective_date => p_effective_date,
1418: p_object_version_number => p_object_version_number);
1419: --

Line 1422: <> nvl(ben_vpf_shd.g_old_rec.alwys_cnt_all_prtts_flag,hr_api.g_varchar2)

1418: p_object_version_number => p_object_version_number);
1419: --
1420: if (l_api_updating
1421: and p_alwys_cnt_all_prtts_flag
1422: <> nvl(ben_vpf_shd.g_old_rec.alwys_cnt_all_prtts_flag,hr_api.g_varchar2)
1423: or not l_api_updating) then
1424: --
1425: -- check if value of lookup falls within lookup type.
1426: --

Line 1486: l_api_updating := ben_vpf_shd.api_updating

1482: Begin
1483: --
1484: hr_utility.set_location('Entering:'||l_proc, 5);
1485: --
1486: l_api_updating := ben_vpf_shd.api_updating
1487: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id,
1488: p_effective_date => p_effective_date,
1489: p_object_version_number => p_object_version_number);
1490: --

Line 1493: <> nvl(ben_vpf_shd.g_old_rec.mlt_cd,hr_api.g_varchar2)

1489: p_object_version_number => p_object_version_number);
1490: --
1491: if (l_api_updating
1492: and p_mlt_cd
1493: <> nvl(ben_vpf_shd.g_old_rec.mlt_cd,hr_api.g_varchar2)
1494: or not l_api_updating) then
1495: --
1496: -- check if value of lookup falls within lookup type.
1497: --

Line 1572: l_api_updating := ben_vpf_shd.api_updating

1568: Begin
1569: --
1570: hr_utility.set_location('Entering:'||l_proc, 5);
1571: --
1572: l_api_updating := ben_vpf_shd.api_updating
1573: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id,
1574: p_effective_date => p_effective_date,
1575: p_object_version_number => p_object_version_number);
1576: --

Line 1579: <> nvl(ben_vpf_shd.g_old_rec.vrbl_usg_cd,hr_api.g_varchar2)

1575: p_object_version_number => p_object_version_number);
1576: --
1577: if (l_api_updating
1578: and p_vrbl_usg_cd
1579: <> nvl(ben_vpf_shd.g_old_rec.vrbl_usg_cd,hr_api.g_varchar2)
1580: or not l_api_updating) then
1581: --
1582: -- check if value of lookup falls within lookup type.
1583: --

Line 1641: l_api_updating := ben_vpf_shd.api_updating

1637: Begin
1638: --
1639: hr_utility.set_location('Entering:'||l_proc, 5);
1640: --
1641: l_api_updating := ben_vpf_shd.api_updating
1642: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id,
1643: p_effective_date => p_effective_date,
1644: p_object_version_number => p_object_version_number);
1645: --

Line 1648: <> nvl(ben_vpf_shd.g_old_rec.asmt_to_use_cd,hr_api.g_varchar2)

1644: p_object_version_number => p_object_version_number);
1645: --
1646: if (l_api_updating
1647: and p_asmt_to_use_cd
1648: <> nvl(ben_vpf_shd.g_old_rec.asmt_to_use_cd,hr_api.g_varchar2)
1649: or not l_api_updating) then
1650: --
1651: -- check if value of lookup falls within lookup type.
1652: --

Line 1712: l_api_updating := ben_vpf_shd.api_updating

1708: Begin
1709: --
1710: hr_utility.set_location('Entering:'||l_proc, 5);
1711: --
1712: l_api_updating := ben_vpf_shd.api_updating
1713: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id,
1714: p_effective_date => p_effective_date,
1715: p_object_version_number => p_object_version_number);
1716: --

Line 1720: <> nvl(ben_vpf_shd.g_old_rec.rndg_cd,hr_api.g_varchar2)

1716: --
1717: if p_rndg_cd is not null then
1718: if (l_api_updating
1719: and p_rndg_cd
1720: <> nvl(ben_vpf_shd.g_old_rec.rndg_cd,hr_api.g_varchar2)
1721: or not l_api_updating) then
1722: --
1723: -- check if value of lookup falls within lookup type.
1724: --

Line 1839: l_api_updating := ben_vpf_shd.api_updating

1835: Begin
1836: --
1837: hr_utility.set_location('Entering:'||l_proc, 5);
1838: --
1839: l_api_updating := ben_vpf_shd.api_updating
1840: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id,
1841: p_effective_date => p_effective_date,
1842: p_object_version_number => p_object_version_number);
1843: --

Line 1846: <> nvl(ben_vpf_shd.g_old_rec.acty_ref_perd_cd,hr_api.g_varchar2)

1842: p_object_version_number => p_object_version_number);
1843: --
1844: if (l_api_updating
1845: and p_acty_ref_perd_cd
1846: <> nvl(ben_vpf_shd.g_old_rec.acty_ref_perd_cd,hr_api.g_varchar2)
1847: or not l_api_updating) then
1848: --
1849: -- check if value of lookup falls within lookup type.
1850: --

Line 2027: l_api_updating := ben_vpf_shd.api_updating

2023: Begin
2024: --
2025: hr_utility.set_location('Entering:'||l_proc, 5);
2026: --
2027: l_api_updating := ben_vpf_shd.api_updating
2028: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id,
2029: p_effective_date => p_effective_date,
2030: p_object_version_number => p_object_version_number);
2031: --

Line 2034: <> nvl(ben_vpf_shd.g_old_rec.vrbl_rt_trtmt_cd,hr_api.g_varchar2)

2030: p_object_version_number => p_object_version_number);
2031: --
2032: if (l_api_updating
2033: and p_vrbl_rt_trtmt_cd
2034: <> nvl(ben_vpf_shd.g_old_rec.vrbl_rt_trtmt_cd,hr_api.g_varchar2)
2035: or not l_api_updating) then
2036: --
2037: -- check if value of lookup falls within lookup type.
2038: --

Line 2096: l_api_updating := ben_vpf_shd.api_updating

2092: Begin
2093: --
2094: hr_utility.set_location('Entering:'||l_proc, 5);
2095: --
2096: l_api_updating := ben_vpf_shd.api_updating
2097: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id,
2098: p_effective_date => p_effective_date,
2099: p_object_version_number => p_object_version_number);
2100: --

Line 2103: <> nvl(ben_vpf_shd.g_old_rec.tx_typ_cd,hr_api.g_varchar2)

2099: p_object_version_number => p_object_version_number);
2100: --
2101: if (l_api_updating
2102: and p_tx_typ_cd
2103: <> nvl(ben_vpf_shd.g_old_rec.tx_typ_cd,hr_api.g_varchar2)
2104: or not l_api_updating) then
2105: --
2106: -- check if value of lookup falls within lookup type.
2107: --

Line 2166: l_api_updating := ben_vpf_shd.api_updating

2162: Begin
2163: --
2164: hr_utility.set_location('Entering:'||l_proc, 5);
2165: --
2166: l_api_updating := ben_vpf_shd.api_updating
2167: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id,
2168: p_effective_date => p_effective_date,
2169: p_object_version_number => p_object_version_number);
2170: --

Line 2173: <> nvl(ben_vpf_shd.g_old_rec.bnft_rt_typ_cd,hr_api.g_varchar2)

2169: p_object_version_number => p_object_version_number);
2170: --
2171: if (l_api_updating
2172: and p_bnft_rt_typ_cd
2173: <> nvl(ben_vpf_shd.g_old_rec.bnft_rt_typ_cd,hr_api.g_varchar2)
2174: or not l_api_updating)
2175: and p_bnft_rt_typ_cd is not null then
2176: --
2177: -- check if value of lookup falls within lookup type.

Line 2235: l_api_updating := ben_vpf_shd.api_updating

2231: Begin
2232: --
2233: hr_utility.set_location('Entering:'||l_proc, 5);
2234: --
2235: l_api_updating := ben_vpf_shd.api_updating
2236: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id,
2237: p_effective_date => p_effective_date,
2238: p_object_version_number => p_object_version_number);
2239: --

Line 2242: <> nvl(ben_vpf_shd.g_old_rec.rt_typ_cd,hr_api.g_varchar2)

2238: p_object_version_number => p_object_version_number);
2239: --
2240: if (l_api_updating
2241: and p_rt_typ_cd
2242: <> nvl(ben_vpf_shd.g_old_rec.rt_typ_cd,hr_api.g_varchar2)
2243: or not l_api_updating)
2244: and p_rt_typ_cd is not null then
2245: --
2246: -- check if value of lookup falls within lookup type.

Line 2304: l_api_updating := ben_vpf_shd.api_updating

2300: Begin
2301: --
2302: hr_utility.set_location('Entering:'||l_proc, 5);
2303: --
2304: l_api_updating := ben_vpf_shd.api_updating
2305: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id,
2306: p_effective_date => p_effective_date,
2307: p_object_version_number => p_object_version_number);
2308: --

Line 2311: <> nvl(ben_vpf_shd.g_old_rec.acty_typ_cd,hr_api.g_varchar2)

2307: p_object_version_number => p_object_version_number);
2308: --
2309: if (l_api_updating
2310: and p_acty_typ_cd
2311: <> nvl(ben_vpf_shd.g_old_rec.acty_typ_cd,hr_api.g_varchar2)
2312: or not l_api_updating)
2313: and p_acty_typ_cd is not null then
2314: --
2315: -- check if value of lookup falls within lookup type.

Line 4753: l_api_updating := ben_vpf_shd.api_updating

4749: Begin
4750: --
4751: hr_utility.set_location('Entering:'||l_proc, 5);
4752: --
4753: l_api_updating := ben_vpf_shd.api_updating
4754: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id,
4755: p_effective_date => p_effective_date,
4756: p_object_version_number => p_object_version_number);
4757: --

Line 4761: <> nvl(ben_vpf_shd.g_old_rec.mlt_cd,hr_api.g_varchar2) or

4757: --
4758: if (l_api_updating
4759: and
4760: (nvl(p_mlt_cd,hr_api.g_varchar2)
4761: <> nvl(ben_vpf_shd.g_old_rec.mlt_cd,hr_api.g_varchar2) or
4762: nvl(p_val,hr_api.g_number)
4763: <> nvl(ben_vpf_shd.g_old_rec.val,hr_api.g_number) or
4764: nvl(p_mn_elcn_val,hr_api.g_number)
4765: <> nvl(ben_vpf_shd.g_old_rec.mn_elcn_val,hr_api.g_number) or

Line 4763: <> nvl(ben_vpf_shd.g_old_rec.val,hr_api.g_number) or

4759: and
4760: (nvl(p_mlt_cd,hr_api.g_varchar2)
4761: <> nvl(ben_vpf_shd.g_old_rec.mlt_cd,hr_api.g_varchar2) or
4762: nvl(p_val,hr_api.g_number)
4763: <> nvl(ben_vpf_shd.g_old_rec.val,hr_api.g_number) or
4764: nvl(p_mn_elcn_val,hr_api.g_number)
4765: <> nvl(ben_vpf_shd.g_old_rec.mn_elcn_val,hr_api.g_number) or
4766: nvl(p_mx_elcn_val,hr_api.g_number)
4767: <> nvl(ben_vpf_shd.g_old_rec.mx_elcn_val,hr_api.g_number) or

Line 4765: <> nvl(ben_vpf_shd.g_old_rec.mn_elcn_val,hr_api.g_number) or

4761: <> nvl(ben_vpf_shd.g_old_rec.mlt_cd,hr_api.g_varchar2) or
4762: nvl(p_val,hr_api.g_number)
4763: <> nvl(ben_vpf_shd.g_old_rec.val,hr_api.g_number) or
4764: nvl(p_mn_elcn_val,hr_api.g_number)
4765: <> nvl(ben_vpf_shd.g_old_rec.mn_elcn_val,hr_api.g_number) or
4766: nvl(p_mx_elcn_val,hr_api.g_number)
4767: <> nvl(ben_vpf_shd.g_old_rec.mx_elcn_val,hr_api.g_number) or
4768: nvl(p_incrmnt_elcn_val,hr_api.g_number)
4769: <> nvl(ben_vpf_shd.g_old_rec.incrmnt_elcn_val,hr_api.g_number) or

Line 4767: <> nvl(ben_vpf_shd.g_old_rec.mx_elcn_val,hr_api.g_number) or

4763: <> nvl(ben_vpf_shd.g_old_rec.val,hr_api.g_number) or
4764: nvl(p_mn_elcn_val,hr_api.g_number)
4765: <> nvl(ben_vpf_shd.g_old_rec.mn_elcn_val,hr_api.g_number) or
4766: nvl(p_mx_elcn_val,hr_api.g_number)
4767: <> nvl(ben_vpf_shd.g_old_rec.mx_elcn_val,hr_api.g_number) or
4768: nvl(p_incrmnt_elcn_val,hr_api.g_number)
4769: <> nvl(ben_vpf_shd.g_old_rec.incrmnt_elcn_val,hr_api.g_number) or
4770: --Bug : 4237447
4771: nvl(p_dflt_elcn_val,hr_api.g_number)

Line 4769: <> nvl(ben_vpf_shd.g_old_rec.incrmnt_elcn_val,hr_api.g_number) or

4765: <> nvl(ben_vpf_shd.g_old_rec.mn_elcn_val,hr_api.g_number) or
4766: nvl(p_mx_elcn_val,hr_api.g_number)
4767: <> nvl(ben_vpf_shd.g_old_rec.mx_elcn_val,hr_api.g_number) or
4768: nvl(p_incrmnt_elcn_val,hr_api.g_number)
4769: <> nvl(ben_vpf_shd.g_old_rec.incrmnt_elcn_val,hr_api.g_number) or
4770: --Bug : 4237447
4771: nvl(p_dflt_elcn_val,hr_api.g_number)
4772: <> nvl(ben_vpf_shd.g_old_rec.dflt_elcn_val,hr_api.g_number) or
4773: -- End Bug: 4237447

Line 4772: <> nvl(ben_vpf_shd.g_old_rec.dflt_elcn_val,hr_api.g_number) or

4768: nvl(p_incrmnt_elcn_val,hr_api.g_number)
4769: <> nvl(ben_vpf_shd.g_old_rec.incrmnt_elcn_val,hr_api.g_number) or
4770: --Bug : 4237447
4771: nvl(p_dflt_elcn_val,hr_api.g_number)
4772: <> nvl(ben_vpf_shd.g_old_rec.dflt_elcn_val,hr_api.g_number) or
4773: -- End Bug: 4237447
4774: nvl(p_rt_typ_cd,hr_api.g_varchar2)
4775: <> nvl(ben_vpf_shd.g_old_rec.rt_typ_cd,hr_api.g_varchar2) or
4776: nvl(p_bnft_rt_typ_cd,hr_api.g_varchar2)

Line 4775: <> nvl(ben_vpf_shd.g_old_rec.rt_typ_cd,hr_api.g_varchar2) or

4771: nvl(p_dflt_elcn_val,hr_api.g_number)
4772: <> nvl(ben_vpf_shd.g_old_rec.dflt_elcn_val,hr_api.g_number) or
4773: -- End Bug: 4237447
4774: nvl(p_rt_typ_cd,hr_api.g_varchar2)
4775: <> nvl(ben_vpf_shd.g_old_rec.rt_typ_cd,hr_api.g_varchar2) or
4776: nvl(p_bnft_rt_typ_cd,hr_api.g_varchar2)
4777: <> nvl(ben_vpf_shd.g_old_rec.bnft_rt_typ_cd,hr_api.g_varchar2) or
4778: nvl(p_val_calc_rl,hr_api.g_number)
4779: <> nvl(ben_vpf_shd.g_old_rec.val_calc_rl,hr_api.g_number) or

Line 4777: <> nvl(ben_vpf_shd.g_old_rec.bnft_rt_typ_cd,hr_api.g_varchar2) or

4773: -- End Bug: 4237447
4774: nvl(p_rt_typ_cd,hr_api.g_varchar2)
4775: <> nvl(ben_vpf_shd.g_old_rec.rt_typ_cd,hr_api.g_varchar2) or
4776: nvl(p_bnft_rt_typ_cd,hr_api.g_varchar2)
4777: <> nvl(ben_vpf_shd.g_old_rec.bnft_rt_typ_cd,hr_api.g_varchar2) or
4778: nvl(p_val_calc_rl,hr_api.g_number)
4779: <> nvl(ben_vpf_shd.g_old_rec.val_calc_rl,hr_api.g_number) or
4780: nvl(p_comp_lvl_fctr_id ,hr_api.g_number)
4781: <> nvl(ben_vpf_shd.g_old_rec.comp_lvl_fctr_id,hr_api.g_number) or

Line 4779: <> nvl(ben_vpf_shd.g_old_rec.val_calc_rl,hr_api.g_number) or

4775: <> nvl(ben_vpf_shd.g_old_rec.rt_typ_cd,hr_api.g_varchar2) or
4776: nvl(p_bnft_rt_typ_cd,hr_api.g_varchar2)
4777: <> nvl(ben_vpf_shd.g_old_rec.bnft_rt_typ_cd,hr_api.g_varchar2) or
4778: nvl(p_val_calc_rl,hr_api.g_number)
4779: <> nvl(ben_vpf_shd.g_old_rec.val_calc_rl,hr_api.g_number) or
4780: nvl(p_comp_lvl_fctr_id ,hr_api.g_number)
4781: <> nvl(ben_vpf_shd.g_old_rec.comp_lvl_fctr_id,hr_api.g_number) or
4782: nvl(p_no_mn_elcn_val_dfnd_flag,hr_api.g_varchar2)
4783: <> nvl(ben_vpf_shd.g_old_rec.no_mn_elcn_val_dfnd_flag,hr_api.g_varchar2)

Line 4781: <> nvl(ben_vpf_shd.g_old_rec.comp_lvl_fctr_id,hr_api.g_number) or

4777: <> nvl(ben_vpf_shd.g_old_rec.bnft_rt_typ_cd,hr_api.g_varchar2) or
4778: nvl(p_val_calc_rl,hr_api.g_number)
4779: <> nvl(ben_vpf_shd.g_old_rec.val_calc_rl,hr_api.g_number) or
4780: nvl(p_comp_lvl_fctr_id ,hr_api.g_number)
4781: <> nvl(ben_vpf_shd.g_old_rec.comp_lvl_fctr_id,hr_api.g_number) or
4782: nvl(p_no_mn_elcn_val_dfnd_flag,hr_api.g_varchar2)
4783: <> nvl(ben_vpf_shd.g_old_rec.no_mn_elcn_val_dfnd_flag,hr_api.g_varchar2)
4784: ))
4785: or

Line 4783: <> nvl(ben_vpf_shd.g_old_rec.no_mn_elcn_val_dfnd_flag,hr_api.g_varchar2)

4779: <> nvl(ben_vpf_shd.g_old_rec.val_calc_rl,hr_api.g_number) or
4780: nvl(p_comp_lvl_fctr_id ,hr_api.g_number)
4781: <> nvl(ben_vpf_shd.g_old_rec.comp_lvl_fctr_id,hr_api.g_number) or
4782: nvl(p_no_mn_elcn_val_dfnd_flag,hr_api.g_varchar2)
4783: <> nvl(ben_vpf_shd.g_old_rec.no_mn_elcn_val_dfnd_flag,hr_api.g_varchar2)
4784: ))
4785: or
4786: not l_api_updating then
4787: --

Line 4921: (p_rec in ben_vpf_shd.g_rec_type,

4917: -- ----------------------------------------------------------------------------
4918: -- |---------------------------< insert_validate >----------------------------|
4919: -- ----------------------------------------------------------------------------
4920: Procedure insert_validate
4921: (p_rec in ben_vpf_shd.g_rec_type,
4922: p_effective_date in date,
4923: p_datetrack_mode in varchar2,
4924: p_validation_start_date in date,
4925: p_validation_end_date in date) is

Line 5219: (p_rec in ben_vpf_shd.g_rec_type,

5215: -- ----------------------------------------------------------------------------
5216: -- |---------------------------< update_validate >----------------------------|
5217: -- ----------------------------------------------------------------------------
5218: Procedure update_validate
5219: (p_rec in ben_vpf_shd.g_rec_type,
5220: p_effective_date in date,
5221: p_datetrack_mode in varchar2,
5222: p_validation_start_date in date,
5223: p_validation_end_date in date) is

Line 5537: (p_rec in ben_vpf_shd.g_rec_type,

5533: -- ----------------------------------------------------------------------------
5534: -- |---------------------------< delete_validate >----------------------------|
5535: -- ----------------------------------------------------------------------------
5536: Procedure delete_validate
5537: (p_rec in ben_vpf_shd.g_rec_type,
5538: p_effective_date in date,
5539: p_datetrack_mode in varchar2,
5540: p_validation_start_date in date,
5541: p_validation_end_date in date) is