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

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

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

Line 177: and nvl(p_enrt_cvg_strt_dt_rl,hr_api.g_number)

173: p_effective_date => p_effective_date,
174: p_object_version_number => p_object_version_number);
175: --
176: if (l_api_updating
177: and nvl(p_enrt_cvg_strt_dt_rl,hr_api.g_number)
178: <> ben_len_shd.g_old_rec.enrt_cvg_strt_dt_rl
179: or not l_api_updating)
180: and p_enrt_cvg_strt_dt_rl is not null then
181: --

Line 250: and nvl(p_enrt_cvg_end_dt_rl,hr_api.g_number)

246: p_effective_date => p_effective_date,
247: p_object_version_number => p_object_version_number);
248: --
249: if (l_api_updating
250: and nvl(p_enrt_cvg_end_dt_rl,hr_api.g_number)
251: <> ben_len_shd.g_old_rec.enrt_cvg_end_dt_rl
252: or not l_api_updating)
253: and p_enrt_cvg_end_dt_rl is not null then
254: --

Line 323: and nvl(p_rt_strt_dt_rl,hr_api.g_number)

319: p_effective_date => p_effective_date,
320: p_object_version_number => p_object_version_number);
321: --
322: if (l_api_updating
323: and nvl(p_rt_strt_dt_rl,hr_api.g_number)
324: <> ben_len_shd.g_old_rec.rt_strt_dt_rl
325: or not l_api_updating)
326: and p_rt_strt_dt_rl is not null then
327: --

Line 396: <> nvl(ben_len_shd.g_old_rec.rt_strt_dt_cd,hr_api.g_varchar2)

392: p_object_version_number => p_object_version_number);
393: --
394: if (l_api_updating
395: and p_rt_strt_dt_cd
396: <> nvl(ben_len_shd.g_old_rec.rt_strt_dt_cd,hr_api.g_varchar2)
397: or not l_api_updating)
398: and p_rt_strt_dt_cd is not null then
399: --
400: -- check if value of lookup falls within lookup type.

Line 402: if hr_api.not_exists_in_hr_lookups

398: and p_rt_strt_dt_cd is not null then
399: --
400: -- check if value of lookup falls within lookup type.
401: --
402: if hr_api.not_exists_in_hr_lookups
403: (p_lookup_type => 'BEN_RT_STRT',
404: p_lookup_code => p_rt_strt_dt_cd,
405: p_effective_date => p_effective_date) then
406: --

Line 468: and nvl(p_rt_end_dt_rl,hr_api.g_number)

464: p_effective_date => p_effective_date,
465: p_object_version_number => p_object_version_number);
466: --
467: if (l_api_updating
468: and nvl(p_rt_end_dt_rl,hr_api.g_number)
469: <> ben_len_shd.g_old_rec.rt_end_dt_rl
470: or not l_api_updating)
471: and p_rt_end_dt_rl is not null then
472: --

Line 541: <> nvl(ben_len_shd.g_old_rec.rt_end_dt_cd,hr_api.g_varchar2)

537: p_object_version_number => p_object_version_number);
538: --
539: if (l_api_updating
540: and p_rt_end_dt_cd
541: <> nvl(ben_len_shd.g_old_rec.rt_end_dt_cd,hr_api.g_varchar2)
542: or not l_api_updating)
543: and p_rt_end_dt_cd is not null then
544: --
545: -- check if value of lookup falls within lookup type.

Line 547: if hr_api.not_exists_in_hr_lookups

543: and p_rt_end_dt_cd is not null then
544: --
545: -- check if value of lookup falls within lookup type.
546: --
547: if hr_api.not_exists_in_hr_lookups
548: (p_lookup_type => 'BEN_RT_END',
549: p_lookup_code => p_rt_end_dt_cd,
550: p_effective_date => p_effective_date) then
551: --

Line 612: and nvl(p_enrt_perd_end_dt_rl,hr_api.g_number)

608: p_effective_date => p_effective_date,
609: p_object_version_number => p_object_version_number);
610: --
611: if (l_api_updating
612: and nvl(p_enrt_perd_end_dt_rl,hr_api.g_number)
613: <> ben_len_shd.g_old_rec.enrt_perd_end_dt_rl
614: or not l_api_updating)
615: and p_enrt_perd_end_dt_rl is not null then
616: --

Line 685: <> nvl(ben_len_shd.g_old_rec.enrt_perd_end_dt_cd,hr_api.g_varchar2)

681: p_object_version_number => p_object_version_number);
682: --
683: if (l_api_updating
684: and p_enrt_perd_end_dt_cd
685: <> nvl(ben_len_shd.g_old_rec.enrt_perd_end_dt_cd,hr_api.g_varchar2)
686: or not l_api_updating)
687: and p_enrt_perd_end_dt_cd is not null then
688: --
689: -- check if value of lookup falls within lookup type.

Line 691: if hr_api.not_exists_in_hr_lookups

687: and p_enrt_perd_end_dt_cd is not null then
688: --
689: -- check if value of lookup falls within lookup type.
690: --
691: if hr_api.not_exists_in_hr_lookups
692: (p_lookup_type => 'BEN_ENRT_PERD_END',
693: p_lookup_code => p_enrt_perd_end_dt_cd,
694: p_effective_date => p_effective_date) then
695: --

Line 756: and nvl(p_enrt_perd_strt_dt_rl,hr_api.g_number)

752: p_effective_date => p_effective_date,
753: p_object_version_number => p_object_version_number);
754: --
755: if (l_api_updating
756: and nvl(p_enrt_perd_strt_dt_rl,hr_api.g_number)
757: <> ben_len_shd.g_old_rec.enrt_perd_strt_dt_rl
758: or not l_api_updating)
759: and p_enrt_perd_strt_dt_rl is not null then
760: --

Line 829: <> nvl(ben_len_shd.g_old_rec.enrt_perd_strt_dt_cd,hr_api.g_varchar2)

825: p_object_version_number => p_object_version_number);
826: --
827: if (l_api_updating
828: and p_enrt_perd_strt_dt_cd
829: <> nvl(ben_len_shd.g_old_rec.enrt_perd_strt_dt_cd,hr_api.g_varchar2)
830: or not l_api_updating)
831: and p_enrt_perd_strt_dt_cd is not null then
832: --
833: -- check if value of lookup falls within lookup type.

Line 835: if hr_api.not_exists_in_hr_lookups

831: and p_enrt_perd_strt_dt_cd is not null then
832: --
833: -- check if value of lookup falls within lookup type.
834: --
835: if hr_api.not_exists_in_hr_lookups
836: (p_lookup_type => 'BEN_ENRT_PERD_STRT',
837: p_lookup_code => p_enrt_perd_strt_dt_cd,
838: p_effective_date => p_effective_date) then
839: --

Line 900: <> nvl(ben_len_shd.g_old_rec.enrt_cvg_strt_dt_cd,hr_api.g_varchar2)

896: p_object_version_number => p_object_version_number);
897: --
898: if (l_api_updating
899: and p_enrt_cvg_strt_dt_cd
900: <> nvl(ben_len_shd.g_old_rec.enrt_cvg_strt_dt_cd,hr_api.g_varchar2)
901: or not l_api_updating)
902: and p_enrt_cvg_strt_dt_cd is not null then
903: --
904: -- check if value of lookup falls within lookup type.

Line 906: if hr_api.not_exists_in_hr_lookups

902: and p_enrt_cvg_strt_dt_cd is not null then
903: --
904: -- check if value of lookup falls within lookup type.
905: --
906: if hr_api.not_exists_in_hr_lookups
907: (p_lookup_type => 'BEN_ENRT_CVG_STRT',
908: p_lookup_code => p_enrt_cvg_strt_dt_cd,
909: p_effective_date => p_effective_date) then
910: --

Line 972: <> nvl(ben_len_shd.g_old_rec.reinstate_ovrdn_cd,hr_api.g_varchar2)

968: p_object_version_number => p_object_version_number);
969: --
970: if (l_api_updating
971: and p_reinstate_ovrdn_cd
972: <> nvl(ben_len_shd.g_old_rec.reinstate_ovrdn_cd,hr_api.g_varchar2)
973: or not l_api_updating)
974: and p_reinstate_ovrdn_cd is not null then
975: --
976: -- check if value of lookup falls within lookup type.

Line 978: if hr_api.not_exists_in_hr_lookups

974: and p_reinstate_ovrdn_cd is not null then
975: --
976: -- check if value of lookup falls within lookup type.
977: --
978: if hr_api.not_exists_in_hr_lookups
979: (p_lookup_type => 'BEN_REINSTATE_OVRDN',
980: p_lookup_code => p_reinstate_ovrdn_cd,
981: p_effective_date => p_effective_date) then
982: --

Line 1044: <> nvl(ben_len_shd.g_old_rec.reinstate_cd,hr_api.g_varchar2)

1040: p_object_version_number => p_object_version_number);
1041: --
1042: if (l_api_updating
1043: and p_reinstate_cd
1044: <> nvl(ben_len_shd.g_old_rec.reinstate_cd,hr_api.g_varchar2)
1045: or not l_api_updating)
1046: and p_reinstate_cd is not null then
1047: --
1048: -- check if value of lookup falls within lookup type.

Line 1050: if hr_api.not_exists_in_hr_lookups

1046: and p_reinstate_cd is not null then
1047: --
1048: -- check if value of lookup falls within lookup type.
1049: --
1050: if hr_api.not_exists_in_hr_lookups
1051: (p_lookup_type => 'BEN_REINSTATE',
1052: p_lookup_code => p_reinstate_cd,
1053: p_effective_date => p_effective_date) then
1054: --

Line 1115: <> nvl(ben_len_shd.g_old_rec.enrt_cvg_end_dt_cd,hr_api.g_varchar2)

1111: p_object_version_number => p_object_version_number);
1112: --
1113: if (l_api_updating
1114: and p_enrt_cvg_end_dt_cd
1115: <> nvl(ben_len_shd.g_old_rec.enrt_cvg_end_dt_cd,hr_api.g_varchar2)
1116: or not l_api_updating)
1117: and p_enrt_cvg_end_dt_cd is not null then
1118: --
1119: -- check if value of lookup falls within lookup type.

Line 1121: if hr_api.not_exists_in_hr_lookups

1117: and p_enrt_cvg_end_dt_cd is not null then
1118: --
1119: -- check if value of lookup falls within lookup type.
1120: --
1121: if hr_api.not_exists_in_hr_lookups
1122: (p_lookup_type => 'BEN_ENRT_CVG_END',
1123: p_lookup_code => p_enrt_cvg_end_dt_cd,
1124: p_effective_date => p_effective_date) then
1125: --

Line 1186: <> nvl(ben_len_shd.g_old_rec.cls_enrt_dt_to_use_cd,hr_api.g_varchar2)

1182: p_object_version_number => p_object_version_number);
1183: --
1184: if (l_api_updating
1185: and p_cls_enrt_dt_to_use_cd
1186: <> nvl(ben_len_shd.g_old_rec.cls_enrt_dt_to_use_cd,hr_api.g_varchar2)
1187: or not l_api_updating)
1188: and p_cls_enrt_dt_to_use_cd is not null then
1189: --
1190: -- check if value of lookup falls within lookup type.

Line 1192: if hr_api.not_exists_in_hr_lookups

1188: and p_cls_enrt_dt_to_use_cd is not null then
1189: --
1190: -- check if value of lookup falls within lookup type.
1191: --
1192: if hr_api.not_exists_in_hr_lookups
1193: (p_lookup_type => 'BEN_CLS_ENRT_DT_TO_USE',
1194: p_lookup_code => p_cls_enrt_dt_to_use_cd,
1195: p_effective_date => p_effective_date) then
1196: --

Line 1448: and p_defer_deenrol_flag <> nvl(ben_len_shd.g_old_rec.defer_deenrol_flag,hr_api.g_varchar2)

1444: p_lee_rsn_id => p_lee_rsn_id,
1445: p_object_version_number => p_object_version_number);
1446: --
1447: if (l_api_updating
1448: and p_defer_deenrol_flag <> nvl(ben_len_shd.g_old_rec.defer_deenrol_flag,hr_api.g_varchar2)
1449: or not l_api_updating)
1450: and p_defer_deenrol_flag is not null then
1451: --
1452: open c_pl_cd;

Line 1515: and p_defer_deenrol_flag <> nvl(ben_len_shd.g_old_rec.defer_deenrol_flag,hr_api.g_varchar2)

1511: p_lee_rsn_id => p_lee_rsn_id,
1512: p_object_version_number => p_object_version_number);
1513: --
1514: if (l_api_updating
1515: and p_defer_deenrol_flag <> nvl(ben_len_shd.g_old_rec.defer_deenrol_flag,hr_api.g_varchar2)
1516: or not l_api_updating)
1517: and p_defer_deenrol_flag is not null then
1518: --
1519: if hr_api.not_exists_in_hr_lookups

Line 1519: if hr_api.not_exists_in_hr_lookups

1515: and p_defer_deenrol_flag <> nvl(ben_len_shd.g_old_rec.defer_deenrol_flag,hr_api.g_varchar2)
1516: or not l_api_updating)
1517: and p_defer_deenrol_flag is not null then
1518: --
1519: if hr_api.not_exists_in_hr_lookups
1520: (p_lookup_type => 'YES_NO',
1521: p_lookup_code => p_defer_deenrol_flag,
1522: p_effective_date => p_effective_date) then
1523: --

Line 1569: (p_popl_enrt_typ_cycl_id in number default hr_api.g_number,

1565: --
1566: -- {End Of Comments}
1567: -- ----------------------------------------------------------------------------
1568: Procedure dt_update_validate
1569: (p_popl_enrt_typ_cycl_id in number default hr_api.g_number,
1570: p_datetrack_mode in varchar2,
1571: p_validation_start_date in date,
1572: p_validation_end_date in date) Is
1573: --

Line 1583: hr_api.mandatory_arg_error

1579: hr_utility.set_location('Entering:'||l_proc, 5);
1580: --
1581: -- Ensure that the p_datetrack_mode argument is not null
1582: --
1583: hr_api.mandatory_arg_error
1584: (p_api_name => l_proc,
1585: p_argument => 'datetrack_mode',
1586: p_argument_value => p_datetrack_mode);
1587: --

Line 1595: hr_api.mandatory_arg_error

1591: --
1592: --
1593: -- Ensure the arguments are not null
1594: --
1595: hr_api.mandatory_arg_error
1596: (p_api_name => l_proc,
1597: p_argument => 'validation_start_date',
1598: p_argument_value => p_validation_start_date);
1599: --

Line 1600: hr_api.mandatory_arg_error

1596: (p_api_name => l_proc,
1597: p_argument => 'validation_start_date',
1598: p_argument_value => p_validation_start_date);
1599: --
1600: hr_api.mandatory_arg_error
1601: (p_api_name => l_proc,
1602: p_argument => 'validation_end_date',
1603: p_argument_value => p_validation_end_date);
1604: --

Line 1605: If ((nvl(p_popl_enrt_typ_cycl_id, hr_api.g_number) <> hr_api.g_number) and

1601: (p_api_name => l_proc,
1602: p_argument => 'validation_end_date',
1603: p_argument_value => p_validation_end_date);
1604: --
1605: If ((nvl(p_popl_enrt_typ_cycl_id, hr_api.g_number) <> hr_api.g_number) and
1606: NOT (dt_api.check_min_max_dates
1607: (p_base_table_name => 'ben_popl_enrt_typ_cycl_f',
1608: p_base_key_column => 'popl_enrt_typ_cycl_id',
1609: p_base_key_value => p_popl_enrt_typ_cycl_id,

Line 1689: hr_api.mandatory_arg_error

1685: hr_utility.set_location('Entering:'||l_proc, 5);
1686: --
1687: -- Ensure that the p_datetrack_mode argument is not null
1688: --
1689: hr_api.mandatory_arg_error
1690: (p_api_name => l_proc,
1691: p_argument => 'datetrack_mode',
1692: p_argument_value => p_datetrack_mode);
1693: --

Line 1703: hr_api.mandatory_arg_error

1699: --
1700: --
1701: -- Ensure the arguments are not null
1702: --
1703: hr_api.mandatory_arg_error
1704: (p_api_name => l_proc,
1705: p_argument => 'validation_start_date',
1706: p_argument_value => p_validation_start_date);
1707: --

Line 1708: hr_api.mandatory_arg_error

1704: (p_api_name => l_proc,
1705: p_argument => 'validation_start_date',
1706: p_argument_value => p_validation_start_date);
1707: --
1708: hr_api.mandatory_arg_error
1709: (p_api_name => l_proc,
1710: p_argument => 'validation_end_date',
1711: p_argument_value => p_validation_end_date);
1712: --

Line 1713: hr_api.mandatory_arg_error

1709: (p_api_name => l_proc,
1710: p_argument => 'validation_end_date',
1711: p_argument_value => p_validation_end_date);
1712: --
1713: hr_api.mandatory_arg_error
1714: (p_api_name => l_proc,
1715: p_argument => 'lee_rsn_id',
1716: p_argument_value => p_lee_rsn_id);
1717: --

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

1774: --
1775: -- Call all supporting business operations
1776: --
1777: --
1778: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1779: --
1780: chk_lee_rsn_id
1781: (p_lee_rsn_id => p_rec.lee_rsn_id,
1782: p_effective_date => p_effective_date,

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

1957: --
1958: -- Call all supporting business operations
1959: --
1960: --
1961: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1962: --
1963: chk_lee_rsn_id
1964: (p_lee_rsn_id => p_rec.lee_rsn_id,
1965: p_effective_date => p_effective_date,

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

2185: hr_utility.set_location('Entering:'|| l_proc, 10);
2186: --
2187: -- Ensure that all the mandatory parameter are not null
2188: --
2189: hr_api.mandatory_arg_error(p_api_name => l_proc,
2190: p_argument => 'lee_rsn_id',
2191: p_argument_value => p_lee_rsn_id);
2192: --
2193: open csr_leg_code;