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

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

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

Line 124: <> nvl(ben_lop_shd.g_old_rec.auto_enrt_flag,hr_api.g_varchar2)

120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating
123: and p_auto_enrt_flag
124: <> nvl(ben_lop_shd.g_old_rec.auto_enrt_flag,hr_api.g_varchar2)
125: or not l_api_updating)
126: and p_auto_enrt_flag is not null then
127: --
128: -- check if value of lookup falls within lookup type.

Line 130: if hr_api.not_exists_in_hr_lookups

126: and p_auto_enrt_flag is not null then
127: --
128: -- check if value of lookup falls within lookup type.
129: --
130: if hr_api.not_exists_in_hr_lookups
131: (p_lookup_type => 'YES_NO',
132: p_lookup_code => p_auto_enrt_flag,
133: p_effective_date => p_effective_date) then
134: --

Line 195: <> nvl(ben_lop_shd.g_old_rec.stl_elig_cant_chg_flag,hr_api.g_varchar2)

191: p_object_version_number => p_object_version_number);
192: --
193: if (l_api_updating
194: and p_stl_elig_cant_chg_flag
195: <> nvl(ben_lop_shd.g_old_rec.stl_elig_cant_chg_flag,hr_api.g_varchar2)
196: or not l_api_updating)
197: and p_stl_elig_cant_chg_flag is not null then
198: --
199: -- check if value of lookup falls within lookup type.

Line 201: if hr_api.not_exists_in_hr_lookups

197: and p_stl_elig_cant_chg_flag is not null then
198: --
199: -- check if value of lookup falls within lookup type.
200: --
201: if hr_api.not_exists_in_hr_lookups
202: (p_lookup_type => 'YES_NO',
203: p_lookup_code => p_stl_elig_cant_chg_flag,
204: p_effective_date => p_effective_date) then
205: --

Line 264: <> nvl(ben_lop_shd.g_old_rec.dflt_flag,hr_api.g_varchar2)

260: p_object_version_number => p_object_version_number);
261: --
262: if (l_api_updating
263: and p_dflt_flag
264: <> nvl(ben_lop_shd.g_old_rec.dflt_flag,hr_api.g_varchar2)
265: or not l_api_updating)
266: and p_dflt_flag is not null then
267: --
268: -- check if value of lookup falls within lookup type.

Line 270: if hr_api.not_exists_in_hr_lookups

266: and p_dflt_flag is not null then
267: --
268: -- check if value of lookup falls within lookup type.
269: --
270: if hr_api.not_exists_in_hr_lookups
271: (p_lookup_type => 'YES_NO',
272: p_lookup_code => p_dflt_flag,
273: p_effective_date => p_effective_date) then
274: --

Line 333: <> nvl(ben_lop_shd.g_old_rec.dflt_enrt_cd,hr_api.g_varchar2)

329: p_object_version_number => p_object_version_number);
330: --
331: if (l_api_updating
332: and p_dflt_enrt_cd
333: <> nvl(ben_lop_shd.g_old_rec.dflt_enrt_cd,hr_api.g_varchar2)
334: or not l_api_updating)
335: and p_dflt_enrt_cd is not null then
336: --
337: -- check if value of lookup falls within lookup type.

Line 339: if hr_api.not_exists_in_hr_lookups

335: and p_dflt_enrt_cd is not null then
336: --
337: -- check if value of lookup falls within lookup type.
338: --
339: if hr_api.not_exists_in_hr_lookups
340: (p_lookup_type => 'BEN_DFLT_ENRT',
341: p_lookup_code => p_dflt_enrt_cd,
342: p_effective_date => p_effective_date) then
343: --

Line 420: <> nvl(ben_lop_shd.g_old_rec.dflt_enrt_rl,hr_api.g_number)

416: p_object_version_number => p_object_version_number);
417: --
418: if (l_api_updating
419: and p_dflt_enrt_rl
420: <> nvl(ben_lop_shd.g_old_rec.dflt_enrt_rl,hr_api.g_number)
421: or not l_api_updating)
422: and p_dflt_enrt_rl is not null then
423: --
424: -- check if value of formula rule is valid.

Line 498: <> nvl(ben_lop_shd.g_old_rec.enrt_cd,hr_api.g_varchar2)

494: p_object_version_number => p_object_version_number);
495: --
496: if (l_api_updating
497: and p_enrt_cd
498: <> nvl(ben_lop_shd.g_old_rec.enrt_cd,hr_api.g_varchar2)
499: or not l_api_updating)
500: and p_enrt_cd is not null then
501: --
502: -- check if value of lookup falls within lookup type.

Line 504: if hr_api.not_exists_in_hr_lookups

500: and p_enrt_cd is not null then
501: --
502: -- check if value of lookup falls within lookup type.
503: --
504: if hr_api.not_exists_in_hr_lookups
505: (p_lookup_type => 'BEN_ENRT',
506: p_lookup_code => p_enrt_cd,
507: p_effective_date => p_effective_date) then
508: --

Line 585: <> nvl(ben_lop_shd.g_old_rec.enrt_rl,hr_api.g_number)

581: p_object_version_number => p_object_version_number);
582: --
583: if (l_api_updating
584: and p_enrt_rl
585: <> nvl(ben_lop_shd.g_old_rec.enrt_rl,hr_api.g_number)
586: or not l_api_updating)
587: and p_enrt_rl is not null then
588: --
589: -- check if value of formula rule is valid.

Line 681: <> nvl(ben_lop_shd.g_old_rec.auto_enrt_mthd_rl,hr_api.g_number)

677: p_object_version_number => p_object_version_number);
678: --
679: if (l_api_updating
680: and p_auto_enrt_mthd_rl
681: <> nvl(ben_lop_shd.g_old_rec.auto_enrt_mthd_rl,hr_api.g_number)
682: or not l_api_updating)
683: and p_auto_enrt_mthd_rl is not null then
684: --
685: -- check if value of formula rule is valid.

Line 761: <> nvl(ben_lop_shd.g_old_rec.use_schedd_enrt_dfns_flag,hr_api.g_varchar2)

757: p_object_version_number => p_object_version_number);
758: --
759: if (l_api_updating
760: and p_use_schedd_enrt_dfns_flag
761: <> nvl(ben_lop_shd.g_old_rec.use_schedd_enrt_dfns_flag,hr_api.g_varchar2)
762: or not l_api_updating)
763: and p_use_schedd_enrt_dfns_flag is not null then
764: --
765: -- check if value of lookup falls within lookup type.

Line 767: if hr_api.not_exists_in_hr_lookups

763: and p_use_schedd_enrt_dfns_flag is not null then
764: --
765: -- check if value of lookup falls within lookup type.
766: --
767: if hr_api.not_exists_in_hr_lookups
768: (p_lookup_type => 'YES_NO',
769: p_lookup_code => p_use_schedd_enrt_dfns_flag,
770: p_effective_date => p_effective_date) then
771: --

Line 834: <> nvl(ben_lop_shd.g_old_rec.use_schedd_enrt_dflts_flag,hr_api.g_varchar2)

830: p_object_version_number => p_object_version_number);
831: --
832: if (l_api_updating
833: and p_use_schedd_enrt_dflts_flag
834: <> nvl(ben_lop_shd.g_old_rec.use_schedd_enrt_dflts_flag,hr_api.g_varchar2)
835: or not l_api_updating)
836: and p_use_schedd_enrt_dflts_flag is not null then
837: --
838: -- check if value of lookup falls within lookup type.

Line 840: if hr_api.not_exists_in_hr_lookups

836: and p_use_schedd_enrt_dflts_flag is not null then
837: --
838: -- check if value of lookup falls within lookup type.
839: --
840: if hr_api.not_exists_in_hr_lookups
841: (p_lookup_type => 'YES_NO',
842: p_lookup_code => p_use_schedd_enrt_dflts_flag,
843: p_effective_date => p_effective_date) then
844: --

Line 906: <> nvl(ben_lop_shd.g_old_rec.new_crnt_enrl_cd,hr_api.g_varchar2)

902: p_object_version_number => p_object_version_number);
903: --
904: if (l_api_updating
905: and p_new_crnt_enrl_cd
906: <> nvl(ben_lop_shd.g_old_rec.new_crnt_enrl_cd,hr_api.g_varchar2)
907: or not l_api_updating) then
908: --
909: -- check if value of lookup falls within lookup type.
910: --

Line 912: if hr_api.not_exists_in_hr_lookups

908: --
909: -- check if value of lookup falls within lookup type.
910: --
911: --
912: if hr_api.not_exists_in_hr_lookups
913: (p_lookup_type => 'BEN_NEW_CRNT_ENRT',
914: p_lookup_code => p_new_crnt_enrl_cd,
915: p_effective_date => p_effective_date) then
916: --

Line 976: <> nvl(ben_lop_shd.g_old_rec.crnt_enrt_prclds_chg_flag,hr_api.g_varchar2)

972: p_object_version_number => p_object_version_number);
973: --
974: if (l_api_updating
975: and p_crnt_enrt_prclds_chg_flag
976: <> nvl(ben_lop_shd.g_old_rec.crnt_enrt_prclds_chg_flag,hr_api.g_varchar2)
977: or not l_api_updating)
978: and p_crnt_enrt_prclds_chg_flag is not null then
979: --
980: -- check if value of lookup falls within lookup type.

Line 982: if hr_api.not_exists_in_hr_lookups

978: and p_crnt_enrt_prclds_chg_flag is not null then
979: --
980: -- check if value of lookup falls within lookup type.
981: --
982: if hr_api.not_exists_in_hr_lookups
983: (p_lookup_type => 'YES_NO',
984: p_lookup_code => p_crnt_enrt_prclds_chg_flag,
985: p_effective_date => p_effective_date) then
986: --

Line 1030: (p_ler_id in number default hr_api.g_number,

1026: --
1027: -- {End Of Comments}
1028: -- ----------------------------------------------------------------------------
1029: Procedure dt_update_validate
1030: (p_ler_id in number default hr_api.g_number,
1031: p_oipl_id in number default hr_api.g_number,
1032: p_datetrack_mode in varchar2,
1033: p_validation_start_date in date,
1034: p_validation_end_date in date) Is

Line 1031: p_oipl_id in number default hr_api.g_number,

1027: -- {End Of Comments}
1028: -- ----------------------------------------------------------------------------
1029: Procedure dt_update_validate
1030: (p_ler_id in number default hr_api.g_number,
1031: p_oipl_id in number default hr_api.g_number,
1032: p_datetrack_mode in varchar2,
1033: p_validation_start_date in date,
1034: p_validation_end_date in date) Is
1035: --

Line 1045: hr_api.mandatory_arg_error

1041: hr_utility.set_location('Entering:'||l_proc, 5);
1042: --
1043: -- Ensure that the p_datetrack_mode argument is not null
1044: --
1045: hr_api.mandatory_arg_error
1046: (p_api_name => l_proc,
1047: p_argument => 'datetrack_mode',
1048: p_argument_value => p_datetrack_mode);
1049: --

Line 1057: hr_api.mandatory_arg_error

1053: --
1054: --
1055: -- Ensure the arguments are not null
1056: --
1057: hr_api.mandatory_arg_error
1058: (p_api_name => l_proc,
1059: p_argument => 'validation_start_date',
1060: p_argument_value => p_validation_start_date);
1061: --

Line 1062: hr_api.mandatory_arg_error

1058: (p_api_name => l_proc,
1059: p_argument => 'validation_start_date',
1060: p_argument_value => p_validation_start_date);
1061: --
1062: hr_api.mandatory_arg_error
1063: (p_api_name => l_proc,
1064: p_argument => 'validation_end_date',
1065: p_argument_value => p_validation_end_date);
1066: --

Line 1067: If ((nvl(p_ler_id, hr_api.g_number) <> hr_api.g_number) and

1063: (p_api_name => l_proc,
1064: p_argument => 'validation_end_date',
1065: p_argument_value => p_validation_end_date);
1066: --
1067: If ((nvl(p_ler_id, hr_api.g_number) <> hr_api.g_number) and
1068: NOT (dt_api.check_min_max_dates
1069: (p_base_table_name => 'ben_ler_f',
1070: p_base_key_column => 'ler_id',
1071: p_base_key_value => p_ler_id,

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

1073: p_to_date => p_validation_end_date))) Then
1074: l_table_name := 'ben_ler_f';
1075: Raise l_integrity_error;
1076: End If;
1077: If ((nvl(p_oipl_id, hr_api.g_number) <> hr_api.g_number) and
1078: NOT (dt_api.check_min_max_dates
1079: (p_base_table_name => 'ben_oipl_f',
1080: p_base_key_column => 'oipl_id',
1081: p_base_key_value => p_oipl_id,

Line 1160: hr_api.mandatory_arg_error

1156: hr_utility.set_location('Entering:'||l_proc, 5);
1157: --
1158: -- Ensure that the p_datetrack_mode argument is not null
1159: --
1160: hr_api.mandatory_arg_error
1161: (p_api_name => l_proc,
1162: p_argument => 'datetrack_mode',
1163: p_argument_value => p_datetrack_mode);
1164: --

Line 1174: hr_api.mandatory_arg_error

1170: --
1171: --
1172: -- Ensure the arguments are not null
1173: --
1174: hr_api.mandatory_arg_error
1175: (p_api_name => l_proc,
1176: p_argument => 'validation_start_date',
1177: p_argument_value => p_validation_start_date);
1178: --

Line 1179: hr_api.mandatory_arg_error

1175: (p_api_name => l_proc,
1176: p_argument => 'validation_start_date',
1177: p_argument_value => p_validation_start_date);
1178: --
1179: hr_api.mandatory_arg_error
1180: (p_api_name => l_proc,
1181: p_argument => 'validation_end_date',
1182: p_argument_value => p_validation_end_date);
1183: --

Line 1184: hr_api.mandatory_arg_error

1180: (p_api_name => l_proc,
1181: p_argument => 'validation_end_date',
1182: p_argument_value => p_validation_end_date);
1183: --
1184: hr_api.mandatory_arg_error
1185: (p_api_name => l_proc,
1186: p_argument => 'ler_chg_oipl_enrt_id',
1187: p_argument_value => p_ler_chg_oipl_enrt_id);
1188: --

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

1235: --
1236: -- Call all supporting business operations
1237: --
1238: --
1239: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1240: --
1241: chk_ler_chg_oipl_enrt_id
1242: (p_ler_chg_oipl_enrt_id => p_rec.ler_chg_oipl_enrt_id,
1243: p_effective_date => p_effective_date,

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

1342: --
1343: -- Call all supporting business operations
1344: --
1345: --
1346: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1347: --
1348: chk_ler_chg_oipl_enrt_id
1349: (p_ler_chg_oipl_enrt_id => p_rec.ler_chg_oipl_enrt_id,
1350: p_effective_date => p_effective_date,

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

1493: hr_utility.set_location('Entering:'|| l_proc, 10);
1494: --
1495: -- Ensure that all the mandatory parameter are not null
1496: --
1497: hr_api.mandatory_arg_error(p_api_name => l_proc,
1498: p_argument => 'ler_chg_oipl_enrt_id',
1499: p_argument_value => p_ler_chg_oipl_enrt_id);
1500: --
1501: open csr_leg_code;