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

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

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

Line 125: and ler_chg_plip_enrt_id <> nvl(p_ler_chg_plip_enrt_id, hr_api.g_number)

121: cursor chk_unique is
122: select null
123: from ben_ler_chg_plip_enrt_f
124: where ler_id = p_ler_id
125: and ler_chg_plip_enrt_id <> nvl(p_ler_chg_plip_enrt_id, hr_api.g_number)
126: and plip_id = p_plip_id
127: and business_group_id + 0 = p_business_group_id
128: and p_validation_start_date <= effective_end_date
129: and p_validation_end_date >= effective_start_date;

Line 142: <> nvl(ben_lpr_shd.g_old_rec.ler_id,hr_api.g_number)

138: p_object_version_number => p_object_version_number);
139: --
140: if (l_api_updating
141: and p_ler_id
142: <> nvl(ben_lpr_shd.g_old_rec.ler_id,hr_api.g_number)
143: or not l_api_updating) then
144: --
145: -- this value must be unique
146: --

Line 215: <> nvl(ben_lpr_shd.g_old_rec.enrt_cd,hr_api.g_varchar2)

211: p_object_version_number => p_object_version_number);
212: --
213: if (l_api_updating
214: and p_enrt_cd
215: <> nvl(ben_lpr_shd.g_old_rec.enrt_cd,hr_api.g_varchar2)
216: or not l_api_updating)
217: and p_enrt_cd is not null then
218: --
219: -- check if value of lookup falls within lookup type.

Line 221: if hr_api.not_exists_in_hr_lookups

217: and p_enrt_cd is not null then
218: --
219: -- check if value of lookup falls within lookup type.
220: --
221: if hr_api.not_exists_in_hr_lookups
222: (p_lookup_type => 'BEN_ENRT',
223: p_lookup_code => p_enrt_cd,
224: p_effective_date => p_effective_date) then
225: --

Line 286: <> nvl(ben_lpr_shd.g_old_rec.stl_elig_cant_chg_flag,hr_api.g_varchar2)

282: p_object_version_number => p_object_version_number);
283: --
284: if (l_api_updating
285: and p_stl_elig_cant_chg_flag
286: <> nvl(ben_lpr_shd.g_old_rec.stl_elig_cant_chg_flag,hr_api.g_varchar2)
287: or not l_api_updating)
288: and p_stl_elig_cant_chg_flag is not null then
289: --
290: -- check if value of lookup falls within lookup type.

Line 292: if hr_api.not_exists_in_hr_lookups

288: and p_stl_elig_cant_chg_flag is not null then
289: --
290: -- check if value of lookup falls within lookup type.
291: --
292: if hr_api.not_exists_in_hr_lookups
293: (p_lookup_type => 'YES_NO',
294: p_lookup_code => p_stl_elig_cant_chg_flag,
295: p_effective_date => p_effective_date) then
296: --

Line 357: <> nvl(ben_lpr_shd.g_old_rec.enrt_mthd_cd,hr_api.g_varchar2)

353: p_object_version_number => p_object_version_number);
354: --
355: if (l_api_updating
356: and p_enrt_mthd_cd
357: <> nvl(ben_lpr_shd.g_old_rec.enrt_mthd_cd,hr_api.g_varchar2)
358: or not l_api_updating)
359: and p_enrt_mthd_cd is not null then
360: --
361: -- check if value of lookup falls within lookup type.

Line 363: if hr_api.not_exists_in_hr_lookups

359: and p_enrt_mthd_cd is not null then
360: --
361: -- check if value of lookup falls within lookup type.
362: --
363: if hr_api.not_exists_in_hr_lookups
364: (p_lookup_type => 'BEN_ENRT_MTHD',
365: p_lookup_code => p_enrt_mthd_cd,
366: p_effective_date => p_effective_date) then
367: --

Line 428: <> nvl(ben_lpr_shd.g_old_rec.dflt_enrt_cd,hr_api.g_varchar2)

424: p_object_version_number => p_object_version_number);
425: --
426: if (l_api_updating
427: and p_dflt_enrt_cd
428: <> nvl(ben_lpr_shd.g_old_rec.dflt_enrt_cd,hr_api.g_varchar2)
429: or not l_api_updating)
430: and p_dflt_enrt_cd is not null then
431: --
432: -- check if value of lookup falls within lookup type.

Line 434: if hr_api.not_exists_in_hr_lookups

430: and p_dflt_enrt_cd is not null then
431: --
432: -- check if value of lookup falls within lookup type.
433: --
434: if hr_api.not_exists_in_hr_lookups
435: (p_lookup_type => 'BEN_DFLT_ENRT',
436: p_lookup_code => p_dflt_enrt_cd,
437: p_effective_date => p_effective_date) then
438: --

Line 516: <> nvl(ben_lpr_shd.g_old_rec.enrt_rl,hr_api.g_number)

512: p_object_version_number => p_object_version_number);
513: --
514: if (l_api_updating
515: and p_enrt_rl
516: <> nvl(ben_lpr_shd.g_old_rec.enrt_rl,hr_api.g_number)
517: or not l_api_updating)
518: and p_enrt_rl is not null then
519: --
520: -- check if value of formula rule is valid.

Line 611: <> nvl(ben_lpr_shd.g_old_rec.dflt_enrt_rl,hr_api.g_number)

607: p_object_version_number => p_object_version_number);
608: --
609: if (l_api_updating
610: and p_dflt_enrt_rl
611: <> nvl(ben_lpr_shd.g_old_rec.dflt_enrt_rl,hr_api.g_number)
612: or not l_api_updating)
613: and p_dflt_enrt_rl is not null then
614: --
615: -- check if value of formula rule is valid.

Line 692: and ler_chg_plip_enrt_id <> nvl(p_ler_chg_plip_enrt_id, hr_api.g_number)

688: select null
689: from ben_ler_chg_plip_enrt_f
690: where dflt_flag = p_dflt_flag
691: and dflt_flag = 'Y'
692: and ler_chg_plip_enrt_id <> nvl(p_ler_chg_plip_enrt_id, hr_api.g_number)
693: and plip_id = p_plip_id
694: and business_group_id + 0 = p_business_group_id
695: and p_validation_start_date <= effective_end_date
696: and p_validation_end_date >= effective_start_date;

Line 709: <> nvl(ben_lpr_shd.g_old_rec.dflt_flag,hr_api.g_varchar2)

705: p_object_version_number => p_object_version_number);
706: --
707: if (l_api_updating
708: and p_dflt_flag
709: <> nvl(ben_lpr_shd.g_old_rec.dflt_flag,hr_api.g_varchar2)
710: or not l_api_updating)
711: and p_dflt_flag is not null then
712: --
713: -- check if value of lookup falls within lookup type.

Line 715: if hr_api.not_exists_in_hr_lookups

711: and p_dflt_flag is not null then
712: --
713: -- check if value of lookup falls within lookup type.
714: --
715: if hr_api.not_exists_in_hr_lookups
716: (p_lookup_type => 'YES_NO',
717: p_lookup_code => p_dflt_flag,
718: p_effective_date => p_effective_date) then
719: --

Line 798: <> nvl(ben_lpr_shd.g_old_rec.crnt_enrt_prclds_chg_flag,hr_api.g_varchar2)

794: p_object_version_number => p_object_version_number);
795: --
796: if (l_api_updating
797: and p_crnt_enrt_prclds_chg_flag
798: <> nvl(ben_lpr_shd.g_old_rec.crnt_enrt_prclds_chg_flag,hr_api.g_varchar2)
799: or not l_api_updating)
800: and p_crnt_enrt_prclds_chg_flag 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_crnt_enrt_prclds_chg_flag 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 => 'YES_NO',
806: p_lookup_code => p_crnt_enrt_prclds_chg_flag,
807: p_effective_date => p_effective_date) then
808: --

Line 869: <> nvl(ben_lpr_shd.g_old_rec.tco_chg_enrt_cd,hr_api.g_varchar2)

865: p_object_version_number => p_object_version_number);
866: --
867: if (l_api_updating
868: and p_tco_chg_enrt_cd
869: <> nvl(ben_lpr_shd.g_old_rec.tco_chg_enrt_cd,hr_api.g_varchar2)
870: or not l_api_updating)
871: and p_tco_chg_enrt_cd is not null then
872: --
873: -- check if value of lookup falls within lookup type.

Line 876: if hr_api.not_exists_in_hr_lookups

872: --
873: -- check if value of lookup falls within lookup type.
874: --
875: --
876: if hr_api.not_exists_in_hr_lookups
877: (p_lookup_type => 'BEN_TCO_CHG_ENRT',
878: p_lookup_code => p_tco_chg_enrt_cd,
879: p_effective_date => p_effective_date) then
880: --

Line 958: and nvl(p_auto_enrt_mthd_rl,hr_api.g_number)

954: p_effective_date => p_effective_date,
955: p_object_version_number => p_object_version_number);
956: --
957: if (l_api_updating
958: and nvl(p_auto_enrt_mthd_rl,hr_api.g_number)
959: <> nvl(ben_lpr_shd.g_old_rec.auto_enrt_mthd_rl,hr_api.g_number)
960: or not l_api_updating) and p_auto_enrt_mthd_rl is not null then
961: --
962: -- check if value of formula rule is valid.

Line 959: <> nvl(ben_lpr_shd.g_old_rec.auto_enrt_mthd_rl,hr_api.g_number)

955: p_object_version_number => p_object_version_number);
956: --
957: if (l_api_updating
958: and nvl(p_auto_enrt_mthd_rl,hr_api.g_number)
959: <> nvl(ben_lpr_shd.g_old_rec.auto_enrt_mthd_rl,hr_api.g_number)
960: or not l_api_updating) and p_auto_enrt_mthd_rl is not null then
961: --
962: -- check if value of formula rule is valid.
963: --

Line 1021: (p_plip_id in number default hr_api.g_number,

1017: --
1018: -- {End Of Comments}
1019: -- ----------------------------------------------------------------------------
1020: Procedure dt_update_validate
1021: (p_plip_id in number default hr_api.g_number,
1022: p_ler_id in number default hr_api.g_number,
1023: p_datetrack_mode in varchar2,
1024: p_validation_start_date in date,
1025: p_validation_end_date in date) Is

Line 1022: p_ler_id in number default hr_api.g_number,

1018: -- {End Of Comments}
1019: -- ----------------------------------------------------------------------------
1020: Procedure dt_update_validate
1021: (p_plip_id in number default hr_api.g_number,
1022: p_ler_id in number default hr_api.g_number,
1023: p_datetrack_mode in varchar2,
1024: p_validation_start_date in date,
1025: p_validation_end_date in date) Is
1026: --

Line 1036: hr_api.mandatory_arg_error

1032: hr_utility.set_location('Entering:'||l_proc, 5);
1033: --
1034: -- Ensure that the p_datetrack_mode argument is not null
1035: --
1036: hr_api.mandatory_arg_error
1037: (p_api_name => l_proc,
1038: p_argument => 'datetrack_mode',
1039: p_argument_value => p_datetrack_mode);
1040: --

Line 1048: hr_api.mandatory_arg_error

1044: --
1045: --
1046: -- Ensure the arguments are not null
1047: --
1048: hr_api.mandatory_arg_error
1049: (p_api_name => l_proc,
1050: p_argument => 'validation_start_date',
1051: p_argument_value => p_validation_start_date);
1052: --

Line 1053: hr_api.mandatory_arg_error

1049: (p_api_name => l_proc,
1050: p_argument => 'validation_start_date',
1051: p_argument_value => p_validation_start_date);
1052: --
1053: hr_api.mandatory_arg_error
1054: (p_api_name => l_proc,
1055: p_argument => 'validation_end_date',
1056: p_argument_value => p_validation_end_date);
1057: --

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

1054: (p_api_name => l_proc,
1055: p_argument => 'validation_end_date',
1056: p_argument_value => p_validation_end_date);
1057: --
1058: If ((nvl(p_plip_id, hr_api.g_number) <> hr_api.g_number) and
1059: NOT (dt_api.check_min_max_dates
1060: (p_base_table_name => 'ben_plip_f',
1061: p_base_key_column => 'plip_id',
1062: p_base_key_value => p_plip_id,

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

1064: p_to_date => p_validation_end_date))) Then
1065: l_table_name := 'ben_plip_f';
1066: Raise l_integrity_error;
1067: End If;
1068: If ((nvl(p_ler_id, hr_api.g_number) <> hr_api.g_number) and
1069: NOT (dt_api.check_min_max_dates
1070: (p_base_table_name => 'ben_ler_f',
1071: p_base_key_column => 'ler_id',
1072: p_base_key_value => p_ler_id,

Line 1150: hr_api.mandatory_arg_error

1146: hr_utility.set_location('Entering:'||l_proc, 5);
1147: --
1148: -- Ensure that the p_datetrack_mode argument is not null
1149: --
1150: hr_api.mandatory_arg_error
1151: (p_api_name => l_proc,
1152: p_argument => 'datetrack_mode',
1153: p_argument_value => p_datetrack_mode);
1154: --

Line 1164: hr_api.mandatory_arg_error

1160: --
1161: --
1162: -- Ensure the arguments are not null
1163: --
1164: hr_api.mandatory_arg_error
1165: (p_api_name => l_proc,
1166: p_argument => 'validation_start_date',
1167: p_argument_value => p_validation_start_date);
1168: --

Line 1169: hr_api.mandatory_arg_error

1165: (p_api_name => l_proc,
1166: p_argument => 'validation_start_date',
1167: p_argument_value => p_validation_start_date);
1168: --
1169: hr_api.mandatory_arg_error
1170: (p_api_name => l_proc,
1171: p_argument => 'validation_end_date',
1172: p_argument_value => p_validation_end_date);
1173: --

Line 1174: hr_api.mandatory_arg_error

1170: (p_api_name => l_proc,
1171: p_argument => 'validation_end_date',
1172: p_argument_value => p_validation_end_date);
1173: --
1174: hr_api.mandatory_arg_error
1175: (p_api_name => l_proc,
1176: p_argument => 'ler_chg_plip_enrt_id',
1177: p_argument_value => p_ler_chg_plip_enrt_id);
1178: --

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

1224: --
1225: -- Call all supporting business operations
1226: --
1227: --
1228: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1229: --
1230: chk_ler_chg_plip_enrt_id
1231: (p_ler_chg_plip_enrt_id => p_rec.ler_chg_plip_enrt_id,
1232: p_effective_date => p_effective_date,

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

1329: --
1330: -- Call all supporting business operations
1331: --
1332: --
1333: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1334: --
1335: chk_ler_chg_plip_enrt_id
1336: (p_ler_chg_plip_enrt_id => p_rec.ler_chg_plip_enrt_id,
1337: p_effective_date => p_effective_date,

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

1479: hr_utility.set_location('Entering:'|| l_proc, 10);
1480: --
1481: -- Ensure that all the mandatory parameter are not null
1482: --
1483: hr_api.mandatory_arg_error(p_api_name => l_proc,
1484: p_argument => 'ler_chg_plip_enrt_id',
1485: p_argument_value => p_ler_chg_plip_enrt_id);
1486: --
1487: open csr_leg_code;