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

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

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

Line 312: and nvl(p_comp_lvl_fctr_id,hr_api.g_number)

308: p_effective_date => p_effective_date,
309: p_object_version_number => p_object_version_number);
310: --
311: if (l_api_updating
312: and nvl(p_comp_lvl_fctr_id,hr_api.g_number)
313: <> nvl(ben_ccm_shd.g_old_rec.comp_lvl_fctr_id,hr_api.g_number)
314: or not l_api_updating) and
315: p_comp_lvl_fctr_id is not null then
316: --

Line 313: <> nvl(ben_ccm_shd.g_old_rec.comp_lvl_fctr_id,hr_api.g_number)

309: p_object_version_number => p_object_version_number);
310: --
311: if (l_api_updating
312: and nvl(p_comp_lvl_fctr_id,hr_api.g_number)
313: <> nvl(ben_ccm_shd.g_old_rec.comp_lvl_fctr_id,hr_api.g_number)
314: or not l_api_updating) and
315: p_comp_lvl_fctr_id is not null then
316: --
317: -- check if comp_lvl_fctr_id value exists in ben_comp_lvl_fctr table

Line 453: <> nvl(ben_ccm_shd.g_old_rec.rt_typ_cd,hr_api.g_varchar2)

449: p_object_version_number => p_object_version_number);
450: --
451: if (l_api_updating
452: and p_rt_typ_cd
453: <> nvl(ben_ccm_shd.g_old_rec.rt_typ_cd,hr_api.g_varchar2)
454: or not l_api_updating)
455: and p_rt_typ_cd is not null then
456: --
457: -- check if value of lookup falls within lookup type.

Line 459: if hr_api.not_exists_in_hr_lookups

455: and p_rt_typ_cd is not null then
456: --
457: -- check if value of lookup falls within lookup type.
458: --
459: if hr_api.not_exists_in_hr_lookups
460: (p_lookup_type => 'BEN_RT_TYP',
461: p_lookup_code => p_rt_typ_cd,
462: p_effective_date => p_effective_date) then
463: --

Line 522: <> nvl(ben_ccm_shd.g_old_rec.entr_val_at_enrt_flag,hr_api.g_varchar2)

518: p_object_version_number => p_object_version_number);
519: --
520: if (l_api_updating
521: and p_entr_val_at_enrt_flag
522: <> nvl(ben_ccm_shd.g_old_rec.entr_val_at_enrt_flag,hr_api.g_varchar2)
523: or not l_api_updating) then
524: --
525: -- check if value of lookup falls within lookup type.
526: --

Line 528: if hr_api.not_exists_in_hr_lookups

524: --
525: -- check if value of lookup falls within lookup type.
526: --
527: --
528: if hr_api.not_exists_in_hr_lookups
529: (p_lookup_type => 'YES_NO',
530: p_lookup_code => p_entr_val_at_enrt_flag,
531: p_effective_date => p_effective_date) then
532: --

Line 591: <> nvl(ben_ccm_shd.g_old_rec.dflt_flag,hr_api.g_varchar2)

587: p_object_version_number => p_object_version_number);
588: --
589: if (l_api_updating
590: and p_dflt_flag
591: <> nvl(ben_ccm_shd.g_old_rec.dflt_flag,hr_api.g_varchar2)
592: or not l_api_updating) then
593: --
594: -- check if value of lookup falls within lookup type.
595: --

Line 597: if hr_api.not_exists_in_hr_lookups

593: --
594: -- check if value of lookup falls within lookup type.
595: --
596: --
597: if hr_api.not_exists_in_hr_lookups
598: (p_lookup_type => 'YES_NO',
599: p_lookup_code => p_dflt_flag,
600: p_effective_date => p_effective_date) then
601: --

Line 660: <> nvl(ben_ccm_shd.g_old_rec.cvg_mlt_cd,hr_api.g_varchar2)

656: p_object_version_number => p_object_version_number);
657: --
658: if (l_api_updating
659: and p_cvg_mlt_cd
660: <> nvl(ben_ccm_shd.g_old_rec.cvg_mlt_cd,hr_api.g_varchar2)
661: or not l_api_updating)
662: and p_cvg_mlt_cd is not null then
663: --
664: -- check if value of lookup falls within lookup type.

Line 666: if hr_api.not_exists_in_hr_lookups

662: and p_cvg_mlt_cd is not null then
663: --
664: -- check if value of lookup falls within lookup type.
665: --
666: if hr_api.not_exists_in_hr_lookups
667: (p_lookup_type => 'BEN_CVG_MLT',
668: p_lookup_code => p_cvg_mlt_cd,
669: p_effective_date => p_effective_date) then
670: --

Line 729: <> nvl(ben_ccm_shd.g_old_rec.bnft_typ_cd,hr_api.g_varchar2)

725: p_object_version_number => p_object_version_number);
726: --
727: if (l_api_updating
728: and p_bnft_typ_cd
729: <> nvl(ben_ccm_shd.g_old_rec.bnft_typ_cd,hr_api.g_varchar2)
730: or not l_api_updating)
731: and p_bnft_typ_cd is not null then
732: --
733: -- check if value of lookup falls within lookup type.

Line 735: if hr_api.not_exists_in_hr_lookups

731: and p_bnft_typ_cd is not null then
732: --
733: -- check if value of lookup falls within lookup type.
734: --
735: if hr_api.not_exists_in_hr_lookups
736: (p_lookup_type => 'BEN_BNFT_TYP',
737: p_lookup_code => p_bnft_typ_cd,
738: p_effective_date => p_effective_date) then
739: --

Line 798: <> nvl(ben_ccm_shd.g_old_rec.bndry_perd_cd,hr_api.g_varchar2)

794: p_object_version_number => p_object_version_number);
795: --
796: if (l_api_updating
797: and p_bndry_perd_cd
798: <> nvl(ben_ccm_shd.g_old_rec.bndry_perd_cd,hr_api.g_varchar2)
799: or not l_api_updating)
800: and p_bndry_perd_cd is not null then
801: --
802: -- check if value of lookup falls within lookup type.

Line 804: if hr_api.not_exists_in_hr_lookups

800: and p_bndry_perd_cd is not null then
801: --
802: -- check if value of lookup falls within lookup type.
803: --
804: if hr_api.not_exists_in_hr_lookups
805: (p_lookup_type => 'BEN_BNDRY_PERD',
806: p_lookup_code => p_bndry_perd_cd,
807: p_effective_date => p_effective_date) then
808: --

Line 867: <> nvl(ben_ccm_shd.g_old_rec.nnmntry_uom,hr_api.g_varchar2)

863: p_object_version_number => p_object_version_number);
864: --
865: if (l_api_updating
866: and p_nnmntry_uom
867: <> nvl(ben_ccm_shd.g_old_rec.nnmntry_uom,hr_api.g_varchar2)
868: or not l_api_updating)
869: and p_nnmntry_uom is not null then
870: --
871: -- check if value of lookup falls within lookup type.

Line 873: if hr_api.not_exists_in_hr_lookups

869: and p_nnmntry_uom is not null then
870: --
871: -- check if value of lookup falls within lookup type.
872: --
873: if hr_api.not_exists_in_hr_lookups
874: (p_lookup_type => 'BEN_NNMNTRY_UOM',
875: p_lookup_code => p_nnmntry_uom,
876: p_effective_date => p_effective_date) then
877: --

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

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

Line 1031: <> nvl(ben_ccm_shd.g_old_rec.val_ovrid_alwd_flag,hr_api.g_varchar2)

1027: p_object_version_number => p_object_version_number);
1028: --
1029: if (l_api_updating
1030: and p_val_ovrid_alwd_flag
1031: <> nvl(ben_ccm_shd.g_old_rec.val_ovrid_alwd_flag,hr_api.g_varchar2)
1032: or not l_api_updating) then
1033: --
1034: -- check if value of lookup falls within lookup type.
1035: --

Line 1037: if hr_api.not_exists_in_hr_lookups

1033: --
1034: -- check if value of lookup falls within lookup type.
1035: --
1036: --
1037: if hr_api.not_exists_in_hr_lookups
1038: (p_lookup_type => 'YES_NO',
1039: p_lookup_code => p_val_ovrid_alwd_flag,
1040: p_effective_date => p_effective_date) then
1041: --

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

1112: p_effective_date => p_effective_date,
1113: p_object_version_number => p_object_version_number);
1114: --
1115: if (l_api_updating
1116: and nvl(p_rndg_rl,hr_api.g_number)
1117: <> ben_ccm_shd.g_old_rec.rndg_rl
1118: or not l_api_updating)
1119: and p_rndg_rl is not null then
1120: --

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

1205: p_effective_date => p_effective_date,
1206: p_object_version_number => p_object_version_number);
1207: --
1208: if (l_api_updating
1209: and nvl(p_lwr_lmt_calc_rl,hr_api.g_number)
1210: <> ben_ccm_shd.g_old_rec.lwr_lmt_calc_rl
1211: or not l_api_updating)
1212: and p_lwr_lmt_calc_rl is not null then
1213: --

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

1298: p_effective_date => p_effective_date,
1299: p_object_version_number => p_object_version_number);
1300: --
1301: if (l_api_updating
1302: and nvl(p_upr_lmt_calc_rl,hr_api.g_number)
1303: <> ben_ccm_shd.g_old_rec.upr_lmt_calc_rl
1304: or not l_api_updating)
1305: and p_upr_lmt_calc_rl is not null then
1306: --

Line 1379: <> nvl(ben_ccm_shd.g_old_rec.rndg_cd,hr_api.g_varchar2)

1375: p_object_version_number => p_object_version_number);
1376: --
1377: if (l_api_updating
1378: and p_rndg_cd
1379: <> nvl(ben_ccm_shd.g_old_rec.rndg_cd,hr_api.g_varchar2)
1380: or not l_api_updating)
1381: and p_rndg_cd is not null then
1382: --
1383: -- check if value of lookup falls within lookup type.

Line 1385: if hr_api.not_exists_in_hr_lookups

1381: and p_rndg_cd is not null then
1382: --
1383: -- check if value of lookup falls within lookup type.
1384: --
1385: if hr_api.not_exists_in_hr_lookups
1386: (p_lookup_type => 'BEN_RNDG',
1387: p_lookup_code => p_rndg_cd,
1388: p_effective_date => p_effective_date) then
1389: --

Line 1448: <> nvl(ben_ccm_shd.g_old_rec.no_mn_val_dfnd_flag,hr_api.g_varchar2)

1444: p_object_version_number => p_object_version_number);
1445: --
1446: if (l_api_updating
1447: and p_no_mn_val_dfnd_flag
1448: <> nvl(ben_ccm_shd.g_old_rec.no_mn_val_dfnd_flag,hr_api.g_varchar2)
1449: or not l_api_updating) then
1450: --
1451: -- check if value of lookup falls within lookup type.
1452: --

Line 1454: if hr_api.not_exists_in_hr_lookups

1450: --
1451: -- check if value of lookup falls within lookup type.
1452: --
1453: --
1454: if hr_api.not_exists_in_hr_lookups
1455: (p_lookup_type => 'YES_NO',
1456: p_lookup_code => p_no_mn_val_dfnd_flag,
1457: p_effective_date => p_effective_date) then
1458: --

Line 1517: <> nvl(ben_ccm_shd.g_old_rec.no_mx_val_dfnd_flag,hr_api.g_varchar2)

1513: p_object_version_number => p_object_version_number);
1514: --
1515: if (l_api_updating
1516: and p_no_mx_val_dfnd_flag
1517: <> nvl(ben_ccm_shd.g_old_rec.no_mx_val_dfnd_flag,hr_api.g_varchar2)
1518: or not l_api_updating) then
1519: --
1520: -- check if value of lookup falls within lookup type.
1521: --

Line 1523: if hr_api.not_exists_in_hr_lookups

1519: --
1520: -- check if value of lookup falls within lookup type.
1521: --
1522: --
1523: if hr_api.not_exists_in_hr_lookups
1524: (p_lookup_type => 'YES_NO',
1525: p_lookup_code => p_no_mx_val_dfnd_flag,
1526: p_effective_date => p_effective_date) then
1527: --

Line 1701: -- <> nvl(ben_ccm_shd.g_old_rec.cvg_det_cd,hr_api.g_varchar2)

1697: -- p_object_version_number => p_object_version_number);
1698: --
1699: -- if (l_api_updating
1700: -- and p_cvg_det_cd
1701: -- <> nvl(ben_ccm_shd.g_old_rec.cvg_det_cd,hr_api.g_varchar2)
1702: -- or not l_api_updating)
1703: -- and p_cvg_det_cd is not null then
1704: --
1705: -- check if value of lookup falls within lookup type.

Line 1707: -- if hr_api.not_exists_in_hr_lookups

1703: -- and p_cvg_det_cd is not null then
1704: --
1705: -- check if value of lookup falls within lookup type.
1706: --
1707: -- if hr_api.not_exists_in_hr_lookups
1708: -- (p_lookup_type => 'BEN_CVG_DET',
1709: -- p_lookup_code => p_cvg_det_cd,
1710: -- p_effective_date => p_effective_date) then
1711: --

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

2025: --
2026: -- {End Of Comments}
2027: -- ----------------------------------------------------------------------------
2028: Procedure dt_update_validate
2029: (p_oipl_id in number default hr_api.g_number,
2030: p_pl_id in number default hr_api.g_number,
2031: p_plip_id in number default hr_api.g_number,
2032: p_datetrack_mode in varchar2,
2033: p_validation_start_date in date,

Line 2030: p_pl_id in number default hr_api.g_number,

2026: -- {End Of Comments}
2027: -- ----------------------------------------------------------------------------
2028: Procedure dt_update_validate
2029: (p_oipl_id in number default hr_api.g_number,
2030: p_pl_id in number default hr_api.g_number,
2031: p_plip_id in number default hr_api.g_number,
2032: p_datetrack_mode in varchar2,
2033: p_validation_start_date in date,
2034: p_validation_end_date in date) Is

Line 2031: p_plip_id in number default hr_api.g_number,

2027: -- ----------------------------------------------------------------------------
2028: Procedure dt_update_validate
2029: (p_oipl_id in number default hr_api.g_number,
2030: p_pl_id in number default hr_api.g_number,
2031: p_plip_id in number default hr_api.g_number,
2032: p_datetrack_mode in varchar2,
2033: p_validation_start_date in date,
2034: p_validation_end_date in date) Is
2035: --

Line 2045: hr_api.mandatory_arg_error

2041: hr_utility.set_location('Entering:'||l_proc, 5);
2042: --
2043: -- Ensure that the p_datetrack_mode argument is not null
2044: --
2045: hr_api.mandatory_arg_error
2046: (p_api_name => l_proc,
2047: p_argument => 'datetrack_mode',
2048: p_argument_value => p_datetrack_mode);
2049: --

Line 2057: hr_api.mandatory_arg_error

2053: --
2054: --
2055: -- Ensure the arguments are not null
2056: --
2057: hr_api.mandatory_arg_error
2058: (p_api_name => l_proc,
2059: p_argument => 'validation_start_date',
2060: p_argument_value => p_validation_start_date);
2061: --

Line 2062: hr_api.mandatory_arg_error

2058: (p_api_name => l_proc,
2059: p_argument => 'validation_start_date',
2060: p_argument_value => p_validation_start_date);
2061: --
2062: hr_api.mandatory_arg_error
2063: (p_api_name => l_proc,
2064: p_argument => 'validation_end_date',
2065: p_argument_value => p_validation_end_date);
2066: --

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

2063: (p_api_name => l_proc,
2064: p_argument => 'validation_end_date',
2065: p_argument_value => p_validation_end_date);
2066: --
2067: If ((nvl(p_oipl_id, hr_api.g_number) <> hr_api.g_number) and
2068: NOT (dt_api.check_min_max_dates
2069: (p_base_table_name => 'ben_oipl_f',
2070: p_base_key_column => 'oipl_id',
2071: p_base_key_value => p_oipl_id,

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

2073: p_to_date => p_validation_end_date))) Then
2074: l_table_name := 'ben_oipl_f';
2075: Raise l_integrity_error;
2076: End If;
2077: If ((nvl(p_pl_id, hr_api.g_number) <> hr_api.g_number) and
2078: NOT (dt_api.check_min_max_dates
2079: (p_base_table_name => 'ben_pl_f',
2080: p_base_key_column => 'pl_id',
2081: p_base_key_value => p_pl_id,

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

2083: p_to_date => p_validation_end_date))) Then
2084: l_table_name := 'ben_pl_f';
2085: Raise l_integrity_error;
2086: End If;
2087: If ((nvl(p_plip_id, hr_api.g_number) <> hr_api.g_number) and
2088: NOT (dt_api.check_min_max_dates
2089: (p_base_table_name => 'ben_plip_f',
2090: p_base_key_column => 'plip_id',
2091: p_base_key_value => p_plip_id,

Line 2170: hr_api.mandatory_arg_error

2166: hr_utility.set_location('Entering:'||l_proc, 5);
2167: --
2168: -- Ensure that the p_datetrack_mode argument is not null
2169: --
2170: hr_api.mandatory_arg_error
2171: (p_api_name => l_proc,
2172: p_argument => 'datetrack_mode',
2173: p_argument_value => p_datetrack_mode);
2174: --

Line 2184: hr_api.mandatory_arg_error

2180: --
2181: --
2182: -- Ensure the arguments are not null
2183: --
2184: hr_api.mandatory_arg_error
2185: (p_api_name => l_proc,
2186: p_argument => 'validation_start_date',
2187: p_argument_value => p_validation_start_date);
2188: --

Line 2189: hr_api.mandatory_arg_error

2185: (p_api_name => l_proc,
2186: p_argument => 'validation_start_date',
2187: p_argument_value => p_validation_start_date);
2188: --
2189: hr_api.mandatory_arg_error
2190: (p_api_name => l_proc,
2191: p_argument => 'validation_end_date',
2192: p_argument_value => p_validation_end_date);
2193: --

Line 2194: hr_api.mandatory_arg_error

2190: (p_api_name => l_proc,
2191: p_argument => 'validation_end_date',
2192: p_argument_value => p_validation_end_date);
2193: --
2194: hr_api.mandatory_arg_error
2195: (p_api_name => l_proc,
2196: p_argument => 'cvg_amt_calc_mthd_id',
2197: p_argument_value => p_cvg_amt_calc_mthd_id);
2198: --

Line 2310: (nvl(p_cvg_mlt_cd,hr_api.g_varchar2)

2306: p_object_version_number => p_object_version_number);
2307: --
2308: if (l_api_updating
2309: and
2310: (nvl(p_cvg_mlt_cd,hr_api.g_varchar2)
2311: <> nvl(ben_ccm_shd.g_old_rec.cvg_mlt_cd,hr_api.g_varchar2) or
2312: nvl(p_val,hr_api.g_number)
2313: <> nvl(ben_ccm_shd.g_old_rec.val,hr_api.g_number) or
2314: nvl(p_mn_val,hr_api.g_number)

Line 2311: <> nvl(ben_ccm_shd.g_old_rec.cvg_mlt_cd,hr_api.g_varchar2) or

2307: --
2308: if (l_api_updating
2309: and
2310: (nvl(p_cvg_mlt_cd,hr_api.g_varchar2)
2311: <> nvl(ben_ccm_shd.g_old_rec.cvg_mlt_cd,hr_api.g_varchar2) or
2312: nvl(p_val,hr_api.g_number)
2313: <> nvl(ben_ccm_shd.g_old_rec.val,hr_api.g_number) or
2314: nvl(p_mn_val,hr_api.g_number)
2315: <> nvl(ben_ccm_shd.g_old_rec.mn_val,hr_api.g_number) or

Line 2312: nvl(p_val,hr_api.g_number)

2308: if (l_api_updating
2309: and
2310: (nvl(p_cvg_mlt_cd,hr_api.g_varchar2)
2311: <> nvl(ben_ccm_shd.g_old_rec.cvg_mlt_cd,hr_api.g_varchar2) or
2312: nvl(p_val,hr_api.g_number)
2313: <> nvl(ben_ccm_shd.g_old_rec.val,hr_api.g_number) or
2314: nvl(p_mn_val,hr_api.g_number)
2315: <> nvl(ben_ccm_shd.g_old_rec.mn_val,hr_api.g_number) or
2316: nvl(p_mx_val,hr_api.g_number)

Line 2313: <> nvl(ben_ccm_shd.g_old_rec.val,hr_api.g_number) or

2309: and
2310: (nvl(p_cvg_mlt_cd,hr_api.g_varchar2)
2311: <> nvl(ben_ccm_shd.g_old_rec.cvg_mlt_cd,hr_api.g_varchar2) or
2312: nvl(p_val,hr_api.g_number)
2313: <> nvl(ben_ccm_shd.g_old_rec.val,hr_api.g_number) or
2314: nvl(p_mn_val,hr_api.g_number)
2315: <> nvl(ben_ccm_shd.g_old_rec.mn_val,hr_api.g_number) or
2316: nvl(p_mx_val,hr_api.g_number)
2317: <> nvl(ben_ccm_shd.g_old_rec.mx_val,hr_api.g_number) or

Line 2314: nvl(p_mn_val,hr_api.g_number)

2310: (nvl(p_cvg_mlt_cd,hr_api.g_varchar2)
2311: <> nvl(ben_ccm_shd.g_old_rec.cvg_mlt_cd,hr_api.g_varchar2) or
2312: nvl(p_val,hr_api.g_number)
2313: <> nvl(ben_ccm_shd.g_old_rec.val,hr_api.g_number) or
2314: nvl(p_mn_val,hr_api.g_number)
2315: <> nvl(ben_ccm_shd.g_old_rec.mn_val,hr_api.g_number) or
2316: nvl(p_mx_val,hr_api.g_number)
2317: <> nvl(ben_ccm_shd.g_old_rec.mx_val,hr_api.g_number) or
2318: nvl(p_incrmt_val,hr_api.g_number)

Line 2315: <> nvl(ben_ccm_shd.g_old_rec.mn_val,hr_api.g_number) or

2311: <> nvl(ben_ccm_shd.g_old_rec.cvg_mlt_cd,hr_api.g_varchar2) or
2312: nvl(p_val,hr_api.g_number)
2313: <> nvl(ben_ccm_shd.g_old_rec.val,hr_api.g_number) or
2314: nvl(p_mn_val,hr_api.g_number)
2315: <> nvl(ben_ccm_shd.g_old_rec.mn_val,hr_api.g_number) or
2316: nvl(p_mx_val,hr_api.g_number)
2317: <> nvl(ben_ccm_shd.g_old_rec.mx_val,hr_api.g_number) or
2318: nvl(p_incrmt_val,hr_api.g_number)
2319: <> nvl(ben_ccm_shd.g_old_rec.incrmt_val,hr_api.g_number) or

Line 2316: nvl(p_mx_val,hr_api.g_number)

2312: nvl(p_val,hr_api.g_number)
2313: <> nvl(ben_ccm_shd.g_old_rec.val,hr_api.g_number) or
2314: nvl(p_mn_val,hr_api.g_number)
2315: <> nvl(ben_ccm_shd.g_old_rec.mn_val,hr_api.g_number) or
2316: nvl(p_mx_val,hr_api.g_number)
2317: <> nvl(ben_ccm_shd.g_old_rec.mx_val,hr_api.g_number) or
2318: nvl(p_incrmt_val,hr_api.g_number)
2319: <> nvl(ben_ccm_shd.g_old_rec.incrmt_val,hr_api.g_number) or
2320: nvl(p_dflt_val,hr_api.g_number)

Line 2317: <> nvl(ben_ccm_shd.g_old_rec.mx_val,hr_api.g_number) or

2313: <> nvl(ben_ccm_shd.g_old_rec.val,hr_api.g_number) or
2314: nvl(p_mn_val,hr_api.g_number)
2315: <> nvl(ben_ccm_shd.g_old_rec.mn_val,hr_api.g_number) or
2316: nvl(p_mx_val,hr_api.g_number)
2317: <> nvl(ben_ccm_shd.g_old_rec.mx_val,hr_api.g_number) or
2318: nvl(p_incrmt_val,hr_api.g_number)
2319: <> nvl(ben_ccm_shd.g_old_rec.incrmt_val,hr_api.g_number) or
2320: nvl(p_dflt_val,hr_api.g_number)
2321: <> nvl(ben_ccm_shd.g_old_rec.dflt_val,hr_api.g_number) or

Line 2318: nvl(p_incrmt_val,hr_api.g_number)

2314: nvl(p_mn_val,hr_api.g_number)
2315: <> nvl(ben_ccm_shd.g_old_rec.mn_val,hr_api.g_number) or
2316: nvl(p_mx_val,hr_api.g_number)
2317: <> nvl(ben_ccm_shd.g_old_rec.mx_val,hr_api.g_number) or
2318: nvl(p_incrmt_val,hr_api.g_number)
2319: <> nvl(ben_ccm_shd.g_old_rec.incrmt_val,hr_api.g_number) or
2320: nvl(p_dflt_val,hr_api.g_number)
2321: <> nvl(ben_ccm_shd.g_old_rec.dflt_val,hr_api.g_number) or
2322: nvl(p_rt_typ_cd,hr_api.g_varchar2)

Line 2319: <> nvl(ben_ccm_shd.g_old_rec.incrmt_val,hr_api.g_number) or

2315: <> nvl(ben_ccm_shd.g_old_rec.mn_val,hr_api.g_number) or
2316: nvl(p_mx_val,hr_api.g_number)
2317: <> nvl(ben_ccm_shd.g_old_rec.mx_val,hr_api.g_number) or
2318: nvl(p_incrmt_val,hr_api.g_number)
2319: <> nvl(ben_ccm_shd.g_old_rec.incrmt_val,hr_api.g_number) or
2320: nvl(p_dflt_val,hr_api.g_number)
2321: <> nvl(ben_ccm_shd.g_old_rec.dflt_val,hr_api.g_number) or
2322: nvl(p_rt_typ_cd,hr_api.g_varchar2)
2323: <> nvl(ben_ccm_shd.g_old_rec.rt_typ_cd,hr_api.g_varchar2) or

Line 2320: nvl(p_dflt_val,hr_api.g_number)

2316: nvl(p_mx_val,hr_api.g_number)
2317: <> nvl(ben_ccm_shd.g_old_rec.mx_val,hr_api.g_number) or
2318: nvl(p_incrmt_val,hr_api.g_number)
2319: <> nvl(ben_ccm_shd.g_old_rec.incrmt_val,hr_api.g_number) or
2320: nvl(p_dflt_val,hr_api.g_number)
2321: <> nvl(ben_ccm_shd.g_old_rec.dflt_val,hr_api.g_number) or
2322: nvl(p_rt_typ_cd,hr_api.g_varchar2)
2323: <> nvl(ben_ccm_shd.g_old_rec.rt_typ_cd,hr_api.g_varchar2) or
2324: nvl(p_val_calc_rl,hr_api.g_number)

Line 2321: <> nvl(ben_ccm_shd.g_old_rec.dflt_val,hr_api.g_number) or

2317: <> nvl(ben_ccm_shd.g_old_rec.mx_val,hr_api.g_number) or
2318: nvl(p_incrmt_val,hr_api.g_number)
2319: <> nvl(ben_ccm_shd.g_old_rec.incrmt_val,hr_api.g_number) or
2320: nvl(p_dflt_val,hr_api.g_number)
2321: <> nvl(ben_ccm_shd.g_old_rec.dflt_val,hr_api.g_number) or
2322: nvl(p_rt_typ_cd,hr_api.g_varchar2)
2323: <> nvl(ben_ccm_shd.g_old_rec.rt_typ_cd,hr_api.g_varchar2) or
2324: nvl(p_val_calc_rl,hr_api.g_number)
2325: <> nvl(ben_ccm_shd.g_old_rec.val_calc_rl,hr_api.g_number) or

Line 2322: nvl(p_rt_typ_cd,hr_api.g_varchar2)

2318: nvl(p_incrmt_val,hr_api.g_number)
2319: <> nvl(ben_ccm_shd.g_old_rec.incrmt_val,hr_api.g_number) or
2320: nvl(p_dflt_val,hr_api.g_number)
2321: <> nvl(ben_ccm_shd.g_old_rec.dflt_val,hr_api.g_number) or
2322: nvl(p_rt_typ_cd,hr_api.g_varchar2)
2323: <> nvl(ben_ccm_shd.g_old_rec.rt_typ_cd,hr_api.g_varchar2) or
2324: nvl(p_val_calc_rl,hr_api.g_number)
2325: <> nvl(ben_ccm_shd.g_old_rec.val_calc_rl,hr_api.g_number) or
2326: nvl(p_comp_lvl_fctr_id,hr_api.g_number)

Line 2323: <> nvl(ben_ccm_shd.g_old_rec.rt_typ_cd,hr_api.g_varchar2) or

2319: <> nvl(ben_ccm_shd.g_old_rec.incrmt_val,hr_api.g_number) or
2320: nvl(p_dflt_val,hr_api.g_number)
2321: <> nvl(ben_ccm_shd.g_old_rec.dflt_val,hr_api.g_number) or
2322: nvl(p_rt_typ_cd,hr_api.g_varchar2)
2323: <> nvl(ben_ccm_shd.g_old_rec.rt_typ_cd,hr_api.g_varchar2) or
2324: nvl(p_val_calc_rl,hr_api.g_number)
2325: <> nvl(ben_ccm_shd.g_old_rec.val_calc_rl,hr_api.g_number) or
2326: nvl(p_comp_lvl_fctr_id,hr_api.g_number)
2327: <> nvl(ben_ccm_shd.g_old_rec.comp_lvl_fctr_id,hr_api.g_number) or

Line 2324: nvl(p_val_calc_rl,hr_api.g_number)

2320: nvl(p_dflt_val,hr_api.g_number)
2321: <> nvl(ben_ccm_shd.g_old_rec.dflt_val,hr_api.g_number) or
2322: nvl(p_rt_typ_cd,hr_api.g_varchar2)
2323: <> nvl(ben_ccm_shd.g_old_rec.rt_typ_cd,hr_api.g_varchar2) or
2324: nvl(p_val_calc_rl,hr_api.g_number)
2325: <> nvl(ben_ccm_shd.g_old_rec.val_calc_rl,hr_api.g_number) or
2326: nvl(p_comp_lvl_fctr_id,hr_api.g_number)
2327: <> nvl(ben_ccm_shd.g_old_rec.comp_lvl_fctr_id,hr_api.g_number) or
2328: nvl(p_entr_val_at_enrt_flag,hr_api.g_varchar2)

Line 2325: <> nvl(ben_ccm_shd.g_old_rec.val_calc_rl,hr_api.g_number) or

2321: <> nvl(ben_ccm_shd.g_old_rec.dflt_val,hr_api.g_number) or
2322: nvl(p_rt_typ_cd,hr_api.g_varchar2)
2323: <> nvl(ben_ccm_shd.g_old_rec.rt_typ_cd,hr_api.g_varchar2) or
2324: nvl(p_val_calc_rl,hr_api.g_number)
2325: <> nvl(ben_ccm_shd.g_old_rec.val_calc_rl,hr_api.g_number) or
2326: nvl(p_comp_lvl_fctr_id,hr_api.g_number)
2327: <> nvl(ben_ccm_shd.g_old_rec.comp_lvl_fctr_id,hr_api.g_number) or
2328: nvl(p_entr_val_at_enrt_flag,hr_api.g_varchar2)
2329: <> nvl(ben_ccm_shd.g_old_rec.entr_val_at_enrt_flag,hr_api.g_varchar2)

Line 2326: nvl(p_comp_lvl_fctr_id,hr_api.g_number)

2322: nvl(p_rt_typ_cd,hr_api.g_varchar2)
2323: <> nvl(ben_ccm_shd.g_old_rec.rt_typ_cd,hr_api.g_varchar2) or
2324: nvl(p_val_calc_rl,hr_api.g_number)
2325: <> nvl(ben_ccm_shd.g_old_rec.val_calc_rl,hr_api.g_number) or
2326: nvl(p_comp_lvl_fctr_id,hr_api.g_number)
2327: <> nvl(ben_ccm_shd.g_old_rec.comp_lvl_fctr_id,hr_api.g_number) or
2328: nvl(p_entr_val_at_enrt_flag,hr_api.g_varchar2)
2329: <> nvl(ben_ccm_shd.g_old_rec.entr_val_at_enrt_flag,hr_api.g_varchar2)
2330: )

Line 2327: <> nvl(ben_ccm_shd.g_old_rec.comp_lvl_fctr_id,hr_api.g_number) or

2323: <> nvl(ben_ccm_shd.g_old_rec.rt_typ_cd,hr_api.g_varchar2) or
2324: nvl(p_val_calc_rl,hr_api.g_number)
2325: <> nvl(ben_ccm_shd.g_old_rec.val_calc_rl,hr_api.g_number) or
2326: nvl(p_comp_lvl_fctr_id,hr_api.g_number)
2327: <> nvl(ben_ccm_shd.g_old_rec.comp_lvl_fctr_id,hr_api.g_number) or
2328: nvl(p_entr_val_at_enrt_flag,hr_api.g_varchar2)
2329: <> nvl(ben_ccm_shd.g_old_rec.entr_val_at_enrt_flag,hr_api.g_varchar2)
2330: )
2331: or

Line 2328: nvl(p_entr_val_at_enrt_flag,hr_api.g_varchar2)

2324: nvl(p_val_calc_rl,hr_api.g_number)
2325: <> nvl(ben_ccm_shd.g_old_rec.val_calc_rl,hr_api.g_number) or
2326: nvl(p_comp_lvl_fctr_id,hr_api.g_number)
2327: <> nvl(ben_ccm_shd.g_old_rec.comp_lvl_fctr_id,hr_api.g_number) or
2328: nvl(p_entr_val_at_enrt_flag,hr_api.g_varchar2)
2329: <> nvl(ben_ccm_shd.g_old_rec.entr_val_at_enrt_flag,hr_api.g_varchar2)
2330: )
2331: or
2332: not l_api_updating)

Line 2329: <> nvl(ben_ccm_shd.g_old_rec.entr_val_at_enrt_flag,hr_api.g_varchar2)

2325: <> nvl(ben_ccm_shd.g_old_rec.val_calc_rl,hr_api.g_number) or
2326: nvl(p_comp_lvl_fctr_id,hr_api.g_number)
2327: <> nvl(ben_ccm_shd.g_old_rec.comp_lvl_fctr_id,hr_api.g_number) or
2328: nvl(p_entr_val_at_enrt_flag,hr_api.g_varchar2)
2329: <> nvl(ben_ccm_shd.g_old_rec.entr_val_at_enrt_flag,hr_api.g_varchar2)
2330: )
2331: or
2332: not l_api_updating)
2333: then

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

2596: --
2597: -- Call all supporting business operations
2598: --
2599: --
2600: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
2601: --
2602: chk_cvg_amt_calc_mthd_id
2603: (p_cvg_amt_calc_mthd_id => p_rec.cvg_amt_calc_mthd_id,
2604: p_effective_date => p_effective_date,

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

2794: --
2795: -- Call all supporting business operations
2796: --
2797: --
2798: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
2799: --
2800: chk_cvg_amt_calc_mthd_id
2801: (p_cvg_amt_calc_mthd_id => p_rec.cvg_amt_calc_mthd_id,
2802: p_effective_date => p_effective_date,

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

3045: hr_utility.set_location('Entering:'|| l_proc, 10);
3046: --
3047: -- Ensure that all the mandatory parameter are not null
3048: --
3049: hr_api.mandatory_arg_error(p_api_name => l_proc,
3050: p_argument => 'cvg_amt_calc_mthd_id',
3051: p_argument_value => p_cvg_amt_calc_mthd_id);
3052: --
3053: open csr_leg_code;