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 HR_API

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

50: p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id,
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: --

Line 129: and nvl(p_vrbl_usg_cd,hr_api.g_varchar2)

125: p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id,
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: --

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 579: if hr_api.not_exists_in_hr_lookups

575: and p_vrbl_rt_prfl_stat_cd is not null then
576: --
577: -- check if value of lookup falls within lookup type.
578: --
579: if hr_api.not_exists_in_hr_lookups
580: (p_lookup_type => 'BEN_STAT',
581: p_lookup_code => p_vrbl_rt_prfl_stat_cd,
582: p_effective_date => p_effective_date) then
583: --

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

654: p_effective_date => p_effective_date,
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: --

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

747: p_effective_date => p_effective_date,
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: --

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

840: p_effective_date => p_effective_date,
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: --

Line 938: and nvl(p_ultmt_lwr_lmt_calc_rl,hr_api.g_number)

934: p_effective_date => p_effective_date,
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: --

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

1031: p_effective_date => p_effective_date,
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: --

Line 1129: and nvl(p_ultmt_upr_lmt_calc_rl,hr_api.g_number)

1125: p_effective_date => p_effective_date,
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: --

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 1218: if hr_api.not_exists_in_hr_lookups

1214: --
1215: -- check if value of lookup falls within lookup type.
1216: --
1217: --
1218: if hr_api.not_exists_in_hr_lookups
1219: (p_lookup_type => 'YES_NO',
1220: p_lookup_code => p_no_mx_elcn_val_dfnd_flag,
1221: p_effective_date => p_effective_date) then
1222: --

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 1288: if hr_api.not_exists_in_hr_lookups

1284: --
1285: -- check if value of lookup falls within lookup type.
1286: --
1287: --
1288: if hr_api.not_exists_in_hr_lookups
1289: (p_lookup_type => 'YES_NO',
1290: p_lookup_code => p_no_mn_elcn_val_dfnd_flag,
1291: p_effective_date => p_effective_date) then
1292: --

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 1358: if hr_api.not_exists_in_hr_lookups

1354: --
1355: -- check if value of lookup falls within lookup type.
1356: --
1357: --
1358: if hr_api.not_exists_in_hr_lookups
1359: (p_lookup_type => 'YES_NO',
1360: p_lookup_code => p_alwys_sum_all_cvg_flag,
1361: p_effective_date => p_effective_date) then
1362: --

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 1428: if hr_api.not_exists_in_hr_lookups

1424: --
1425: -- check if value of lookup falls within lookup type.
1426: --
1427: --
1428: if hr_api.not_exists_in_hr_lookups
1429: (p_lookup_type => 'YES_NO',
1430: p_lookup_code => p_alwys_cnt_all_prtts_flag,
1431: p_effective_date => p_effective_date) then
1432: --

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 1507: if hr_api.not_exists_in_hr_lookups

1503: elsif p_vrbl_usg_cd = 'ACP' THEN
1504: l_lookup_code := 'BEN_ACTL_PREM_MLT';
1505: end if;
1506: --
1507: if hr_api.not_exists_in_hr_lookups
1508: (p_lookup_type => l_lookup_code,
1509: p_lookup_code => p_mlt_cd,
1510: p_effective_date => p_effective_date) then
1511: --

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 1585: if hr_api.not_exists_in_hr_lookups

1581: --
1582: -- check if value of lookup falls within lookup type.
1583: --
1584: --
1585: if hr_api.not_exists_in_hr_lookups
1586: (p_lookup_type => 'BEN_VRBL_USG',
1587: p_lookup_code => p_vrbl_usg_cd,
1588: p_effective_date => p_effective_date) then
1589: --

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 1654: if hr_api.not_exists_in_hr_lookups

1650: --
1651: -- check if value of lookup falls within lookup type.
1652: --
1653: --
1654: if hr_api.not_exists_in_hr_lookups
1655: (p_lookup_type => 'BEN_ASMT_TO_USE',
1656: p_lookup_code => p_asmt_to_use_cd,
1657: p_effective_date => p_effective_date) then
1658: --

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 1726: if hr_api.not_exists_in_hr_lookups

1722: --
1723: -- check if value of lookup falls within lookup type.
1724: --
1725: --
1726: if hr_api.not_exists_in_hr_lookups
1727: (p_lookup_type => 'BEN_RNDG',
1728: p_lookup_code => p_rndg_cd,
1729: p_effective_date => p_effective_date) then
1730: --

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 1852: if hr_api.not_exists_in_hr_lookups

1848: --
1849: -- check if value of lookup falls within lookup type.
1850: --
1851: --
1852: if hr_api.not_exists_in_hr_lookups
1853: (p_lookup_type => 'BEN_ACTY_REF_PERD',
1854: p_lookup_code => p_acty_ref_perd_cd,
1855: p_effective_date => p_effective_date) then
1856: --

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 2040: if hr_api.not_exists_in_hr_lookups

2036: --
2037: -- check if value of lookup falls within lookup type.
2038: --
2039: --
2040: if hr_api.not_exists_in_hr_lookups
2041: (p_lookup_type => 'BEN_RT_TRTMT',
2042: p_lookup_code => p_vrbl_rt_trtmt_cd,
2043: p_effective_date => p_effective_date) then
2044: --

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 2110: if hr_api.not_exists_in_hr_lookups

2106: -- check if value of lookup falls within lookup type.
2107: --
2108: --
2109: hr_utility.set_location('lookup code is'||p_tx_typ_cd,20);
2110: if hr_api.not_exists_in_hr_lookups
2111: (p_lookup_type => 'BEN_TX_TYP',
2112: p_lookup_code => p_tx_typ_cd,
2113: p_effective_date => p_effective_date) then
2114: --

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 2179: if hr_api.not_exists_in_hr_lookups

2175: and p_bnft_rt_typ_cd is not null then
2176: --
2177: -- check if value of lookup falls within lookup type.
2178: --
2179: if hr_api.not_exists_in_hr_lookups
2180: (p_lookup_type => 'BEN_RT_TYP',
2181: p_lookup_code => p_bnft_rt_typ_cd,
2182: p_effective_date => p_effective_date) then
2183: --

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 2248: if hr_api.not_exists_in_hr_lookups

2244: and p_rt_typ_cd is not null then
2245: --
2246: -- check if value of lookup falls within lookup type.
2247: --
2248: if hr_api.not_exists_in_hr_lookups
2249: (p_lookup_type => 'BEN_RT_TYP',
2250: p_lookup_code => p_rt_typ_cd,
2251: p_effective_date => p_effective_date) then
2252: --

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 2318: if hr_api.not_exists_in_hr_lookups

2314: --
2315: -- check if value of lookup falls within lookup type.
2316: --
2317: --
2318: if hr_api.not_exists_in_hr_lookups
2319: (p_lookup_type => 'BEN_ACTY_TYP',
2320: p_lookup_code => p_acty_typ_cd,
2321: p_effective_date => p_effective_date) then
2322: --

Line 3037: if hr_api.not_exists_in_hr_lookups

3033: Begin
3034: --
3035: hr_utility.set_location('Entering:'||l_proc, 5);
3036: --
3037: if hr_api.not_exists_in_hr_lookups
3038: (p_lookup_type => 'YES_NO',
3039: p_lookup_code => p_rt_hrly_slrd_flag,
3040: p_effective_date => p_effective_date) then
3041: --

Line 3051: if hr_api.not_exists_in_hr_lookups

3047: fnd_message.raise_error;
3048: --
3049: end if;
3050: --
3051: if hr_api.not_exists_in_hr_lookups
3052: (p_lookup_type => 'YES_NO',
3053: p_lookup_code => p_rt_pstl_cd_flag,
3054: p_effective_date => p_effective_date) then
3055: --

Line 3065: if hr_api.not_exists_in_hr_lookups

3061: fnd_message.raise_error;
3062: --
3063: end if;
3064: --
3065: if hr_api.not_exists_in_hr_lookups
3066: (p_lookup_type => 'YES_NO',
3067: p_lookup_code => p_rt_lbr_mmbr_flag,
3068: p_effective_date => p_effective_date) then
3069: --

Line 3079: if hr_api.not_exists_in_hr_lookups

3075: fnd_message.raise_error;
3076: --
3077: end if;
3078: --
3079: if hr_api.not_exists_in_hr_lookups
3080: (p_lookup_type => 'YES_NO',
3081: p_lookup_code => p_rt_lgl_enty_flag,
3082: p_effective_date => p_effective_date) then
3083: --

Line 3093: if hr_api.not_exists_in_hr_lookups

3089: fnd_message.raise_error;
3090: --
3091: end if;
3092: --
3093: if hr_api.not_exists_in_hr_lookups
3094: (p_lookup_type => 'YES_NO',
3095: p_lookup_code => p_rt_benfts_grp_flag,
3096: p_effective_date => p_effective_date) then
3097: --

Line 3107: if hr_api.not_exists_in_hr_lookups

3103: fnd_message.raise_error;
3104: --
3105: end if;
3106: --
3107: if hr_api.not_exists_in_hr_lookups
3108: (p_lookup_type => 'YES_NO',
3109: p_lookup_code => p_rt_wk_loc_flag,
3110: p_effective_date => p_effective_date) then
3111: --

Line 3121: if hr_api.not_exists_in_hr_lookups

3117: fnd_message.raise_error;
3118: --
3119: end if;
3120: --
3121: if hr_api.not_exists_in_hr_lookups
3122: (p_lookup_type => 'YES_NO',
3123: p_lookup_code => p_rt_brgng_unit_flag,
3124: p_effective_date => p_effective_date) then
3125: --

Line 3135: if hr_api.not_exists_in_hr_lookups

3131: fnd_message.raise_error;
3132: --
3133: end if;
3134: --
3135: if hr_api.not_exists_in_hr_lookups
3136: (p_lookup_type => 'YES_NO',
3137: p_lookup_code => p_rt_age_flag,
3138: p_effective_date => p_effective_date) then
3139: --

Line 3149: if hr_api.not_exists_in_hr_lookups

3145: fnd_message.raise_error;
3146: --
3147: end if;
3148: --
3149: if hr_api.not_exists_in_hr_lookups
3150: (p_lookup_type => 'YES_NO',
3151: p_lookup_code => p_rt_los_flag,
3152: p_effective_date => p_effective_date) then
3153: --

Line 3163: if hr_api.not_exists_in_hr_lookups

3159: fnd_message.raise_error;
3160: --
3161: end if;
3162: --
3163: if hr_api.not_exists_in_hr_lookups
3164: (p_lookup_type => 'YES_NO',
3165: p_lookup_code => p_rt_per_typ_flag,
3166: p_effective_date => p_effective_date) then
3167: --

Line 3177: if hr_api.not_exists_in_hr_lookups

3173: fnd_message.raise_error;
3174: --
3175: end if;
3176: --
3177: if hr_api.not_exists_in_hr_lookups
3178: (p_lookup_type => 'YES_NO',
3179: p_lookup_code => p_rt_fl_tm_pt_tm_flag,
3180: p_effective_date => p_effective_date) then
3181: --

Line 3191: if hr_api.not_exists_in_hr_lookups

3187: fnd_message.raise_error;
3188: --
3189: end if;
3190: --
3191: if hr_api.not_exists_in_hr_lookups
3192: (p_lookup_type => 'YES_NO',
3193: p_lookup_code => p_rt_ee_stat_flag,
3194: p_effective_date => p_effective_date) then
3195: --

Line 3205: if hr_api.not_exists_in_hr_lookups

3201: fnd_message.raise_error;
3202: --
3203: end if;
3204: --
3205: if hr_api.not_exists_in_hr_lookups
3206: (p_lookup_type => 'YES_NO',
3207: p_lookup_code => p_rt_grd_flag,
3208: p_effective_date => p_effective_date) then
3209: --

Line 3219: if hr_api.not_exists_in_hr_lookups

3215: fnd_message.raise_error;
3216: --
3217: end if;
3218: --
3219: if hr_api.not_exists_in_hr_lookups
3220: (p_lookup_type => 'YES_NO',
3221: p_lookup_code => p_rt_pct_fl_tm_flag,
3222: p_effective_date => p_effective_date) then
3223: --

Line 3233: if hr_api.not_exists_in_hr_lookups

3229: fnd_message.raise_error;
3230: --
3231: end if;
3232: --
3233: if hr_api.not_exists_in_hr_lookups
3234: (p_lookup_type => 'YES_NO',
3235: p_lookup_code => p_rt_asnt_set_flag,
3236: p_effective_date => p_effective_date) then
3237: --

Line 3247: if hr_api.not_exists_in_hr_lookups

3243: fnd_message.raise_error;
3244: --
3245: end if;
3246: --
3247: if hr_api.not_exists_in_hr_lookups
3248: (p_lookup_type => 'YES_NO',
3249: p_lookup_code => p_rt_hrs_wkd_flag,
3250: p_effective_date => p_effective_date) then
3251: --

Line 3261: if hr_api.not_exists_in_hr_lookups

3257: fnd_message.raise_error;
3258: --
3259: end if;
3260: --
3261: if hr_api.not_exists_in_hr_lookups
3262: (p_lookup_type => 'YES_NO',
3263: p_lookup_code => p_rt_comp_lvl_flag,
3264: p_effective_date => p_effective_date) then
3265: --

Line 3275: if hr_api.not_exists_in_hr_lookups

3271: fnd_message.raise_error;
3272: --
3273: end if;
3274: --
3275: if hr_api.not_exists_in_hr_lookups
3276: (p_lookup_type => 'YES_NO',
3277: p_lookup_code => p_rt_org_unit_flag,
3278: p_effective_date => p_effective_date) then
3279: --

Line 3289: if hr_api.not_exists_in_hr_lookups

3285: fnd_message.raise_error;
3286: --
3287: end if;
3288: --
3289: if hr_api.not_exists_in_hr_lookups
3290: (p_lookup_type => 'YES_NO',
3291: p_lookup_code => p_rt_loa_rsn_flag,
3292: p_effective_date => p_effective_date) then
3293: --

Line 3303: if hr_api.not_exists_in_hr_lookups

3299: fnd_message.raise_error;
3300: --
3301: end if;
3302: --
3303: if hr_api.not_exists_in_hr_lookups
3304: (p_lookup_type => 'YES_NO',
3305: p_lookup_code => p_rt_pyrl_flag,
3306: p_effective_date => p_effective_date) then
3307: --

Line 3317: if hr_api.not_exists_in_hr_lookups

3313: fnd_message.raise_error;
3314: --
3315: end if;
3316: --
3317: if hr_api.not_exists_in_hr_lookups
3318: (p_lookup_type => 'YES_NO',
3319: p_lookup_code => p_rt_schedd_hrs_flag,
3320: p_effective_date => p_effective_date) then
3321: --

Line 3331: if hr_api.not_exists_in_hr_lookups

3327: fnd_message.raise_error;
3328: --
3329: end if;
3330: --
3331: if hr_api.not_exists_in_hr_lookups
3332: (p_lookup_type => 'YES_NO',
3333: p_lookup_code => p_rt_py_bss_flag,
3334: p_effective_date => p_effective_date) then
3335: --

Line 3345: if hr_api.not_exists_in_hr_lookups

3341: fnd_message.raise_error;
3342: --
3343: end if;
3344: --
3345: if hr_api.not_exists_in_hr_lookups
3346: (p_lookup_type => 'YES_NO',
3347: p_lookup_code => p_rt_prfl_rl_flag,
3348: p_effective_date => p_effective_date) then
3349: --

Line 3359: if hr_api.not_exists_in_hr_lookups

3355: fnd_message.raise_error;
3356: --
3357: end if;
3358: --
3359: if hr_api.not_exists_in_hr_lookups
3360: (p_lookup_type => 'YES_NO',
3361: p_lookup_code => p_rt_cmbn_age_los_flag,
3362: p_effective_date => p_effective_date) then
3363: --

Line 3373: if hr_api.not_exists_in_hr_lookups

3369: fnd_message.raise_error;
3370: --
3371: end if;
3372: --
3373: if hr_api.not_exists_in_hr_lookups
3374: (p_lookup_type => 'YES_NO',
3375: p_lookup_code => p_rt_prtt_pl_flag,
3376: p_effective_date => p_effective_date) then
3377: --

Line 3387: if hr_api.not_exists_in_hr_lookups

3383: fnd_message.raise_error;
3384: --
3385: end if;
3386: --
3387: if hr_api.not_exists_in_hr_lookups
3388: (p_lookup_type => 'YES_NO',
3389: p_lookup_code => p_rt_svc_area_flag,
3390: p_effective_date => p_effective_date) then
3391: --

Line 3401: if hr_api.not_exists_in_hr_lookups

3397: fnd_message.raise_error;
3398: --
3399: end if;
3400: --
3401: if hr_api.not_exists_in_hr_lookups
3402: (p_lookup_type => 'YES_NO',
3403: p_lookup_code => p_rt_ppl_grp_flag,
3404: p_effective_date => p_effective_date) then
3405: --

Line 3415: if hr_api.not_exists_in_hr_lookups

3411: fnd_message.raise_error;
3412: --
3413: end if;
3414: --
3415: if hr_api.not_exists_in_hr_lookups
3416: (p_lookup_type => 'YES_NO',
3417: p_lookup_code => p_rt_dsbld_flag,
3418: p_effective_date => p_effective_date) then
3419: --

Line 3429: if hr_api.not_exists_in_hr_lookups

3425: fnd_message.raise_error;
3426: --
3427: end if;
3428: --
3429: if hr_api.not_exists_in_hr_lookups
3430: (p_lookup_type => 'YES_NO',
3431: p_lookup_code => p_rt_hlth_cvg_flag,
3432: p_effective_date => p_effective_date) then
3433: --

Line 3443: if hr_api.not_exists_in_hr_lookups

3439: fnd_message.raise_error;
3440: --
3441: end if;
3442: --
3443: if hr_api.not_exists_in_hr_lookups
3444: (p_lookup_type => 'YES_NO',
3445: p_lookup_code => p_rt_poe_flag,
3446: p_effective_date => p_effective_date) then
3447: --

Line 3457: if hr_api.not_exists_in_hr_lookups

3453: fnd_message.raise_error;
3454: --
3455: end if;
3456: --
3457: if hr_api.not_exists_in_hr_lookups
3458: (p_lookup_type => 'YES_NO',
3459: p_lookup_code => p_rt_ttl_cvg_vol_flag,
3460: p_effective_date => p_effective_date) then
3461: --

Line 3471: if hr_api.not_exists_in_hr_lookups

3467: fnd_message.raise_error;
3468: --
3469: end if;
3470: --
3471: if hr_api.not_exists_in_hr_lookups
3472: (p_lookup_type => 'YES_NO',
3473: p_lookup_code => p_rt_ttl_prtt_flag,
3474: p_effective_date => p_effective_date) then
3475: --

Line 3485: if hr_api.not_exists_in_hr_lookups

3481: fnd_message.raise_error;
3482: --
3483: end if;
3484: --
3485: if hr_api.not_exists_in_hr_lookups
3486: (p_lookup_type => 'YES_NO',
3487: p_lookup_code => p_rt_gndr_flag,
3488: p_effective_date => p_effective_date) then
3489: --

Line 3499: if hr_api.not_exists_in_hr_lookups

3495: fnd_message.raise_error;
3496: --
3497: end if;
3498: --
3499: if hr_api.not_exists_in_hr_lookups
3500: (p_lookup_type => 'YES_NO',
3501: p_lookup_code => p_rt_tbco_use_flag,
3502: p_effective_date => p_effective_date) then
3503: --

Line 3514: if hr_api.not_exists_in_hr_lookups

3510: --
3511: end if;
3512:
3513:
3514: if hr_api.not_exists_in_hr_lookups
3515: (p_lookup_type => 'YES_NO',
3516: p_lookup_code => p_rt_cntng_prtn_prfl_flag,
3517: p_effective_date => p_effective_date) then
3518: --

Line 3528: if hr_api.not_exists_in_hr_lookups

3524: fnd_message.raise_error;
3525: --
3526: end if;
3527:
3528: if hr_api.not_exists_in_hr_lookups
3529: (p_lookup_type => 'YES_NO',
3530: p_lookup_code => p_rt_cbr_quald_bnf_flag,
3531: p_effective_date => p_effective_date) then
3532: --

Line 3542: if hr_api.not_exists_in_hr_lookups

3538: fnd_message.raise_error;
3539: --
3540: end if;
3541:
3542: if hr_api.not_exists_in_hr_lookups
3543: (p_lookup_type => 'YES_NO',
3544: p_lookup_code => p_rt_optd_mdcr_flag,
3545: p_effective_date => p_effective_date) then
3546: --

Line 3556: if hr_api.not_exists_in_hr_lookups

3552: fnd_message.raise_error;
3553: --
3554: end if;
3555:
3556: if hr_api.not_exists_in_hr_lookups
3557: (p_lookup_type => 'YES_NO',
3558: p_lookup_code => p_rt_lvg_rsn_flag,
3559: p_effective_date => p_effective_date) then
3560: --

Line 3570: if hr_api.not_exists_in_hr_lookups

3566: fnd_message.raise_error;
3567: --
3568: end if;
3569:
3570: if hr_api.not_exists_in_hr_lookups
3571: (p_lookup_type => 'YES_NO',
3572: p_lookup_code => p_rt_pstn_flag,
3573: p_effective_date => p_effective_date) then
3574: --

Line 3584: if hr_api.not_exists_in_hr_lookups

3580: fnd_message.raise_error;
3581: --
3582: end if;
3583:
3584: if hr_api.not_exists_in_hr_lookups
3585: (p_lookup_type => 'YES_NO',
3586: p_lookup_code => p_rt_comptncy_flag,
3587: p_effective_date => p_effective_date) then
3588: --

Line 3598: if hr_api.not_exists_in_hr_lookups

3594: fnd_message.raise_error;
3595: --
3596: end if;
3597:
3598: if hr_api.not_exists_in_hr_lookups
3599: (p_lookup_type => 'YES_NO',
3600: p_lookup_code => p_rt_job_flag,
3601: p_effective_date => p_effective_date) then
3602: --

Line 3612: if hr_api.not_exists_in_hr_lookups

3608: fnd_message.raise_error;
3609: --
3610: end if;
3611:
3612: if hr_api.not_exists_in_hr_lookups
3613: (p_lookup_type => 'YES_NO',
3614: p_lookup_code => p_rt_qual_titl_flag,
3615: p_effective_date => p_effective_date) then
3616: --

Line 3626: if hr_api.not_exists_in_hr_lookups

3622: fnd_message.raise_error;
3623: --
3624: end if;
3625:
3626: if hr_api.not_exists_in_hr_lookups
3627: (p_lookup_type => 'YES_NO',
3628: p_lookup_code => p_rt_dpnt_cvrd_pl_flag,
3629: p_effective_date => p_effective_date) then
3630: --

Line 3640: if hr_api.not_exists_in_hr_lookups

3636: fnd_message.raise_error;
3637: --
3638: end if;
3639:
3640: if hr_api.not_exists_in_hr_lookups
3641: (p_lookup_type => 'YES_NO',
3642: p_lookup_code => p_rt_dpnt_cvrd_plip_flag,
3643: p_effective_date => p_effective_date) then
3644: --

Line 3654: if hr_api.not_exists_in_hr_lookups

3650: fnd_message.raise_error;
3651: --
3652: end if;
3653:
3654: if hr_api.not_exists_in_hr_lookups
3655: (p_lookup_type => 'YES_NO',
3656: p_lookup_code => p_rt_dpnt_cvrd_ptip_flag,
3657: p_effective_date => p_effective_date) then
3658: --

Line 3668: if hr_api.not_exists_in_hr_lookups

3664: fnd_message.raise_error;
3665: --
3666: end if;
3667:
3668: if hr_api.not_exists_in_hr_lookups
3669: (p_lookup_type => 'YES_NO',
3670: p_lookup_code => p_rt_dpnt_cvrd_pgm_flag,
3671: p_effective_date => p_effective_date) then
3672: --

Line 3682: if hr_api.not_exists_in_hr_lookups

3678: fnd_message.raise_error;
3679: --
3680: end if;
3681:
3682: if hr_api.not_exists_in_hr_lookups
3683: (p_lookup_type => 'YES_NO',
3684: p_lookup_code => p_rt_enrld_oipl_flag,
3685: p_effective_date => p_effective_date) then
3686: --

Line 3696: if hr_api.not_exists_in_hr_lookups

3692: fnd_message.raise_error;
3693: --
3694: end if;
3695:
3696: if hr_api.not_exists_in_hr_lookups
3697: (p_lookup_type => 'YES_NO',
3698: p_lookup_code => p_rt_enrld_pl_flag,
3699: p_effective_date => p_effective_date) then
3700: --

Line 3710: if hr_api.not_exists_in_hr_lookups

3706: fnd_message.raise_error;
3707: --
3708: end if;
3709:
3710: if hr_api.not_exists_in_hr_lookups
3711: (p_lookup_type => 'YES_NO',
3712: p_lookup_code => p_rt_enrld_plip_flag,
3713: p_effective_date => p_effective_date) then
3714: --

Line 3724: if hr_api.not_exists_in_hr_lookups

3720: fnd_message.raise_error;
3721: --
3722: end if;
3723:
3724: if hr_api.not_exists_in_hr_lookups
3725: (p_lookup_type => 'YES_NO',
3726: p_lookup_code => p_rt_enrld_ptip_flag,
3727: p_effective_date => p_effective_date) then
3728: --

Line 3738: if hr_api.not_exists_in_hr_lookups

3734: fnd_message.raise_error;
3735: --
3736: end if;
3737:
3738: if hr_api.not_exists_in_hr_lookups
3739: (p_lookup_type => 'YES_NO',
3740: p_lookup_code => p_rt_enrld_pgm_flag,
3741: p_effective_date => p_effective_date) then
3742: --

Line 3752: if hr_api.not_exists_in_hr_lookups

3748: fnd_message.raise_error;
3749: --
3750: end if;
3751:
3752: if hr_api.not_exists_in_hr_lookups
3753: (p_lookup_type => 'YES_NO',
3754: p_lookup_code => p_rt_prtt_anthr_pl_flag,
3755: p_effective_date => p_effective_date) then
3756: --

Line 3766: if hr_api.not_exists_in_hr_lookups

3762: fnd_message.raise_error;
3763: --
3764: end if;
3765:
3766: if hr_api.not_exists_in_hr_lookups
3767: (p_lookup_type => 'YES_NO',
3768: p_lookup_code => p_rt_othr_ptip_flag,
3769: p_effective_date => p_effective_date) then
3770: --

Line 3780: if hr_api.not_exists_in_hr_lookups

3776: fnd_message.raise_error;
3777: --
3778: end if;
3779:
3780: if hr_api.not_exists_in_hr_lookups
3781: (p_lookup_type => 'YES_NO',
3782: p_lookup_code => p_rt_no_othr_cvg_flag,
3783: p_effective_date => p_effective_date) then
3784: --

Line 3794: if hr_api.not_exists_in_hr_lookups

3790: fnd_message.raise_error;
3791: --
3792: end if;
3793:
3794: if hr_api.not_exists_in_hr_lookups
3795: (p_lookup_type => 'YES_NO',
3796: p_lookup_code => p_rt_dpnt_othr_ptip_flag,
3797: p_effective_date => p_effective_date) then
3798: --

Line 3808: if hr_api.not_exists_in_hr_lookups

3804: fnd_message.raise_error;
3805: --
3806: end if;
3807:
3808: if hr_api.not_exists_in_hr_lookups
3809: (p_lookup_type => 'YES_NO',
3810: p_lookup_code => p_rt_qua_in_gr_flag,
3811: p_effective_date => p_effective_date) then
3812: --

Line 3822: if hr_api.not_exists_in_hr_lookups

3818: fnd_message.raise_error;
3819: --
3820: end if;
3821:
3822: if hr_api.not_exists_in_hr_lookups
3823: (p_lookup_type => 'YES_NO',
3824: p_lookup_code => p_rt_perf_rtng_flag,
3825: p_effective_date => p_effective_date) then
3826: --

Line 3836: if hr_api.not_exists_in_hr_lookups

3832: fnd_message.raise_error;
3833: --
3834: end if;
3835:
3836: if hr_api.not_exists_in_hr_lookups
3837: (p_lookup_type => 'YES_NO',
3838: p_lookup_code => p_rt_elig_prfl_flag,
3839: p_effective_date => p_effective_date) then
3840: --

Line 3884: (p_oipl_id in number default hr_api.g_number,

3880: --
3881: -- {End Of Comments}
3882: -- ----------------------------------------------------------------------------
3883: Procedure dt_update_validate
3884: (p_oipl_id in number default hr_api.g_number,
3885: p_pl_typ_opt_typ_id in number default hr_api.g_number,
3886: p_pl_id in number default hr_api.g_number,
3887: p_datetrack_mode in varchar2,
3888: p_validation_start_date in date,

Line 3885: p_pl_typ_opt_typ_id in number default hr_api.g_number,

3881: -- {End Of Comments}
3882: -- ----------------------------------------------------------------------------
3883: Procedure dt_update_validate
3884: (p_oipl_id in number default hr_api.g_number,
3885: p_pl_typ_opt_typ_id in number default hr_api.g_number,
3886: p_pl_id in number default hr_api.g_number,
3887: p_datetrack_mode in varchar2,
3888: p_validation_start_date in date,
3889: p_validation_end_date in date) Is

Line 3886: p_pl_id in number default hr_api.g_number,

3882: -- ----------------------------------------------------------------------------
3883: Procedure dt_update_validate
3884: (p_oipl_id in number default hr_api.g_number,
3885: p_pl_typ_opt_typ_id in number default hr_api.g_number,
3886: p_pl_id in number default hr_api.g_number,
3887: p_datetrack_mode in varchar2,
3888: p_validation_start_date in date,
3889: p_validation_end_date in date) Is
3890: --

Line 3900: hr_api.mandatory_arg_error

3896: hr_utility.set_location('Entering:'||l_proc, 5);
3897: --
3898: -- Ensure that the p_datetrack_mode argument is not null
3899: --
3900: hr_api.mandatory_arg_error
3901: (p_api_name => l_proc,
3902: p_argument => 'datetrack_mode',
3903: p_argument_value => p_datetrack_mode);
3904: --

Line 3912: hr_api.mandatory_arg_error

3908: --
3909: --
3910: -- Ensure the arguments are not null
3911: --
3912: hr_api.mandatory_arg_error
3913: (p_api_name => l_proc,
3914: p_argument => 'validation_start_date',
3915: p_argument_value => p_validation_start_date);
3916: --

Line 3917: hr_api.mandatory_arg_error

3913: (p_api_name => l_proc,
3914: p_argument => 'validation_start_date',
3915: p_argument_value => p_validation_start_date);
3916: --
3917: hr_api.mandatory_arg_error
3918: (p_api_name => l_proc,
3919: p_argument => 'validation_end_date',
3920: p_argument_value => p_validation_end_date);
3921: --

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

3918: (p_api_name => l_proc,
3919: p_argument => 'validation_end_date',
3920: p_argument_value => p_validation_end_date);
3921: --
3922: If ((nvl(p_oipl_id, hr_api.g_number) <> hr_api.g_number) and
3923: NOT (dt_api.check_min_max_dates
3924: (p_base_table_name => 'ben_oipl_f',
3925: p_base_key_column => 'oipl_id',
3926: p_base_key_value => p_oipl_id,

Line 3932: --If ((nvl(p_pl_typ_opt_typ_id, hr_api.g_number) <> hr_api.g_number) and

3928: p_to_date => p_validation_end_date))) Then
3929: l_table_name := 'ben_oipl_f';
3930: Raise l_integrity_error;
3931: End If;
3932: --If ((nvl(p_pl_typ_opt_typ_id, hr_api.g_number) <> hr_api.g_number) and
3933: --NOT (dt_api.check_min_max_dates
3934: -- (p_base_table_name => 'ben_pl_typ_opt_typ_f',
3935: -- p_base_key_column => 'pl_typ_opt_typ_id',
3936: -- p_base_key_value => p_pl_typ_opt_typ_id,

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

3938: -- p_to_date => p_validation_end_date))) Then
3939: --l_table_name := 'ben_pl_typ_opt_typ_f';
3940: --Raise l_integrity_error;
3941: --End If;
3942: If ((nvl(p_pl_id, hr_api.g_number) <> hr_api.g_number) and
3943: NOT (dt_api.check_min_max_dates
3944: (p_base_table_name => 'ben_pl_f',
3945: p_base_key_column => 'pl_id',
3946: p_base_key_value => p_pl_id,

Line 4028: hr_api.mandatory_arg_error

4024: hr_utility.set_location('Entering:'||l_proc, 5);
4025: --
4026: -- Ensure that the p_datetrack_mode argument is not null
4027: --
4028: hr_api.mandatory_arg_error
4029: (p_api_name => l_proc,
4030: p_argument => 'datetrack_mode',
4031: p_argument_value => p_datetrack_mode);
4032: --

Line 4042: hr_api.mandatory_arg_error

4038: --
4039: --
4040: -- Ensure the arguments are not null
4041: --
4042: hr_api.mandatory_arg_error
4043: (p_api_name => l_proc,
4044: p_argument => 'validation_start_date',
4045: p_argument_value => p_validation_start_date);
4046: --

Line 4047: hr_api.mandatory_arg_error

4043: (p_api_name => l_proc,
4044: p_argument => 'validation_start_date',
4045: p_argument_value => p_validation_start_date);
4046: --
4047: hr_api.mandatory_arg_error
4048: (p_api_name => l_proc,
4049: p_argument => 'validation_end_date',
4050: p_argument_value => p_validation_end_date);
4051: --

Line 4052: hr_api.mandatory_arg_error

4048: (p_api_name => l_proc,
4049: p_argument => 'validation_end_date',
4050: p_argument_value => p_validation_end_date);
4051: --
4052: hr_api.mandatory_arg_error
4053: (p_api_name => l_proc,
4054: p_argument => 'vrbl_rt_prfl_id',
4055: p_argument_value => p_vrbl_rt_prfl_id);
4056: --

Line 4760: (nvl(p_mlt_cd,hr_api.g_varchar2)

4756: p_object_version_number => p_object_version_number);
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)

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 4762: nvl(p_val,hr_api.g_number)

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
4766: nvl(p_mx_elcn_val,hr_api.g_number)

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 4764: nvl(p_mn_elcn_val,hr_api.g_number)

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
4768: nvl(p_incrmnt_elcn_val,hr_api.g_number)

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 4766: nvl(p_mx_elcn_val,hr_api.g_number)

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
4770: --Bug : 4237447

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 4768: nvl(p_incrmnt_elcn_val,hr_api.g_number)

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)
4772: <> nvl(ben_vpf_shd.g_old_rec.dflt_elcn_val,hr_api.g_number) or

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 4771: nvl(p_dflt_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
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

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 4774: nvl(p_rt_typ_cd,hr_api.g_varchar2)

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)
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)

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 4776: nvl(p_bnft_rt_typ_cd,hr_api.g_varchar2)

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
4780: nvl(p_comp_lvl_fctr_id ,hr_api.g_number)

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 4778: nvl(p_val_calc_rl,hr_api.g_number)

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
4782: nvl(p_no_mn_elcn_val_dfnd_flag,hr_api.g_varchar2)

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 4780: nvl(p_comp_lvl_fctr_id ,hr_api.g_number)

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)
4784: ))

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 4782: nvl(p_no_mn_elcn_val_dfnd_flag,hr_api.g_varchar2)

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
4786: not l_api_updating then

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 4935: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

4931: --
4932: -- Call all supporting business operations
4933: --
4934: --
4935: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
4936: --
4937: chk_vrbl_rt_prfl_id
4938: (p_vrbl_rt_prfl_id => p_rec.vrbl_rt_prfl_id,
4939: p_effective_date => p_effective_date,

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

5229: --
5230: -- Call all supporting business operations
5231: --
5232: --
5233: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
5234: --
5235: chk_vrbl_rt_prfl_id
5236: (p_vrbl_rt_prfl_id => p_rec.vrbl_rt_prfl_id,
5237: p_effective_date => p_effective_date,

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

5600: hr_utility.set_location('Entering:'|| l_proc, 10);
5601: --
5602: -- Ensure that all the mandatory parameter are not null
5603: --
5604: hr_api.mandatory_arg_error(p_api_name => l_proc,
5605: p_argument => 'vrbl_rt_prfl_id',
5606: p_argument_value => p_vrbl_rt_prfl_id);
5607: --
5608: open csr_leg_code;