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

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

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

Line 124: <> nvl(ben_lbr_shd.g_old_rec.no_mx_cvg_incr_apls_flag,hr_api.g_varchar2)

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

Line 130: if hr_api.not_exists_in_hr_lookups

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

Line 195: <> nvl(ben_lbr_shd.g_old_rec.no_mn_cvg_incr_apls_flag,hr_api.g_varchar2)

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

Line 201: if hr_api.not_exists_in_hr_lookups

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

Line 266: <> nvl(ben_lbr_shd.g_old_rec.no_mx_cvg_amt_apls_flag,hr_api.g_varchar2)

262: p_object_version_number => p_object_version_number);
263: --
264: if (l_api_updating
265: and p_no_mx_cvg_amt_apls_flag
266: <> nvl(ben_lbr_shd.g_old_rec.no_mx_cvg_amt_apls_flag,hr_api.g_varchar2)
267: or not l_api_updating) then
268: --
269: -- check if value of lookup falls within lookup type.
270: --

Line 272: if hr_api.not_exists_in_hr_lookups

268: --
269: -- check if value of lookup falls within lookup type.
270: --
271: --
272: if hr_api.not_exists_in_hr_lookups
273: (p_lookup_type => 'YES_NO',
274: p_lookup_code => p_no_mx_cvg_amt_apls_flag,
275: p_effective_date => p_effective_date) then
276: --

Line 337: <> nvl(ben_lbr_shd.g_old_rec.cvg_incr_r_decr_only_cd,hr_api.g_varchar2)

333: p_object_version_number => p_object_version_number);
334: --
335: if (l_api_updating
336: and p_cvg_incr_r_decr_only_cd
337: <> nvl(ben_lbr_shd.g_old_rec.cvg_incr_r_decr_only_cd,hr_api.g_varchar2)
338: or not l_api_updating)
339: and p_cvg_incr_r_decr_only_cd is not null then
340: --
341: -- check if value of lookup falls within lookup type.

Line 343: if hr_api.not_exists_in_hr_lookups

339: and p_cvg_incr_r_decr_only_cd is not null then
340: --
341: -- check if value of lookup falls within lookup type.
342: --
343: if hr_api.not_exists_in_hr_lookups
344: (p_lookup_type => 'BEN_CVG_INCR_R_DECR_ONLY',
345: p_lookup_code => p_cvg_incr_r_decr_only_cd,
346: p_effective_date => p_effective_date) then
347: --

Line 408: <> nvl(ben_lbr_shd.g_old_rec.unsspnd_enrt_cd,hr_api.g_varchar2)

404: p_object_version_number => p_object_version_number);
405: --
406: if (l_api_updating
407: and p_unsspnd_enrt_cd
408: <> nvl(ben_lbr_shd.g_old_rec.unsspnd_enrt_cd,hr_api.g_varchar2)
409: or not l_api_updating)
410: and p_unsspnd_enrt_cd is not null then
411: --
412: -- check if value of lookup falls within lookup type.

Line 414: if hr_api.not_exists_in_hr_lookups

410: and p_unsspnd_enrt_cd is not null then
411: --
412: -- check if value of lookup falls within lookup type.
413: --
414: if hr_api.not_exists_in_hr_lookups
415: (p_lookup_type => 'BEN_UNSSPND_ENRT',
416: p_lookup_code => p_unsspnd_enrt_cd,
417: p_effective_date => p_effective_date) then
418: --

Line 479: <> nvl(ben_lbr_shd.g_old_rec.dflt_to_asn_pndg_ctfn_cd,hr_api.g_varchar2)

475: p_object_version_number => p_object_version_number);
476: --
477: if (l_api_updating
478: and p_dflt_to_asn_pndg_ctfn_cd
479: <> nvl(ben_lbr_shd.g_old_rec.dflt_to_asn_pndg_ctfn_cd,hr_api.g_varchar2)
480: or not l_api_updating)
481: and p_dflt_to_asn_pndg_ctfn_cd is not null then
482: --
483: -- check if value of lookup falls within lookup type.

Line 485: if hr_api.not_exists_in_hr_lookups

481: and p_dflt_to_asn_pndg_ctfn_cd is not null then
482: --
483: -- check if value of lookup falls within lookup type.
484: --
485: if hr_api.not_exists_in_hr_lookups
486: (p_lookup_type => 'BEN_DFLT_TO_ASN_PNDG_CTFN',
487: p_lookup_code => p_dflt_to_asn_pndg_ctfn_cd,
488: p_effective_date => p_effective_date) then
489: --

Line 551: and nvl(p_dflt_to_asn_pndg_ctfn_rl,hr_api.g_number)

547: p_effective_date => p_effective_date,
548: p_object_version_number => p_object_version_number);
549: --
550: if (l_api_updating
551: and nvl(p_dflt_to_asn_pndg_ctfn_rl,hr_api.g_number)
552: <> ben_lbr_shd.g_old_rec.dflt_to_asn_pndg_ctfn_rl
553: or not l_api_updating)
554: and p_dflt_to_asn_pndg_ctfn_rl is not null then
555: --

Line 624: and nvl(p_mn_cvg_rl,hr_api.g_number)

620: p_effective_date => p_effective_date,
621: p_object_version_number => p_object_version_number);
622: --
623: if (l_api_updating
624: and nvl(p_mn_cvg_rl,hr_api.g_number)
625: <> ben_lbr_shd.g_old_rec.mn_cvg_rl
626: or not l_api_updating)
627: and p_mn_cvg_rl is not null then
628: --

Line 697: and nvl(p_mx_cvg_rl,hr_api.g_number)

693: p_effective_date => p_effective_date,
694: p_object_version_number => p_object_version_number);
695: --
696: if (l_api_updating
697: and nvl(p_mx_cvg_rl,hr_api.g_number)
698: <> ben_lbr_shd.g_old_rec.mx_cvg_rl
699: or not l_api_updating)
700: and p_mx_cvg_rl is not null then
701: --

Line 801: and nvl(p_dflt_to_asn_pndg_ctfn_cd,hr_api.g_varchar2)

797: p_ler_bnft_rstrn_id => p_ler_bnft_rstrn_id,
798: p_object_version_number => p_object_version_number);
799: --
800: if (l_api_updating
801: and nvl(p_dflt_to_asn_pndg_ctfn_cd,hr_api.g_varchar2)
802: <> nvl(ben_lbr_shd.g_old_rec.dflt_to_asn_pndg_ctfn_cd, '***')
803: or not l_api_updating)
804: and p_dflt_to_asn_pndg_ctfn_cd is not null then
805: --

Line 900: hr_api.mandatory_arg_error

896: hr_utility.set_location('Entering:'||l_proc, 5);
897: --
898: -- Ensure that the p_datetrack_mode argument is not null
899: --
900: hr_api.mandatory_arg_error
901: (p_api_name => l_proc,
902: p_argument => 'datetrack_mode',
903: p_argument_value => p_datetrack_mode);
904: --

Line 912: hr_api.mandatory_arg_error

908: --
909: --
910: -- Ensure the arguments are not null
911: --
912: hr_api.mandatory_arg_error
913: (p_api_name => l_proc,
914: p_argument => 'validation_start_date',
915: p_argument_value => p_validation_start_date);
916: --

Line 917: hr_api.mandatory_arg_error

913: (p_api_name => l_proc,
914: p_argument => 'validation_start_date',
915: p_argument_value => p_validation_start_date);
916: --
917: hr_api.mandatory_arg_error
918: (p_api_name => l_proc,
919: p_argument => 'validation_end_date',
920: p_argument_value => p_validation_end_date);
921: --

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

918: (p_api_name => l_proc,
919: p_argument => 'validation_end_date',
920: p_argument_value => p_validation_end_date);
921: --
922: If ((nvl(p_ler_id, hr_api.g_number) <> hr_api.g_number) and
923: NOT (dt_api.check_min_max_dates
924: (p_base_table_name => 'ben_ler_f',
925: p_base_key_column => 'ler_id',
926: p_base_key_value => p_ler_id,

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

928: p_to_date => p_validation_end_date))) Then
929: l_table_name := 'ben_ler_f';
930: Raise l_integrity_error;
931: End If;
932: If ((nvl(p_pl_id, hr_api.g_number) <> hr_api.g_number) and
933: NOT (dt_api.check_min_max_dates
934: (p_base_table_name => 'ben_pl_f',
935: p_base_key_column => 'pl_id',
936: p_base_key_value => p_pl_id,

Line 1016: hr_api.mandatory_arg_error

1012: hr_utility.set_location('Entering:'||l_proc, 5);
1013: --
1014: -- Ensure that the p_datetrack_mode argument is not null
1015: --
1016: hr_api.mandatory_arg_error
1017: (p_api_name => l_proc,
1018: p_argument => 'datetrack_mode',
1019: p_argument_value => p_datetrack_mode);
1020: --

Line 1030: hr_api.mandatory_arg_error

1026: --
1027: --
1028: -- Ensure the arguments are not null
1029: --
1030: hr_api.mandatory_arg_error
1031: (p_api_name => l_proc,
1032: p_argument => 'validation_start_date',
1033: p_argument_value => p_validation_start_date);
1034: --

Line 1035: hr_api.mandatory_arg_error

1031: (p_api_name => l_proc,
1032: p_argument => 'validation_start_date',
1033: p_argument_value => p_validation_start_date);
1034: --
1035: hr_api.mandatory_arg_error
1036: (p_api_name => l_proc,
1037: p_argument => 'validation_end_date',
1038: p_argument_value => p_validation_end_date);
1039: --

Line 1040: hr_api.mandatory_arg_error

1036: (p_api_name => l_proc,
1037: p_argument => 'validation_end_date',
1038: p_argument_value => p_validation_end_date);
1039: --
1040: hr_api.mandatory_arg_error
1041: (p_api_name => l_proc,
1042: p_argument => 'ler_bnft_rstrn_id',
1043: p_argument_value => p_ler_bnft_rstrn_id);
1044: --

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

1169: p_mx_cvg_rl => p_rec.mx_cvg_rl,
1170: p_effective_date => p_effective_date,
1171: p_object_version_number => p_rec.object_version_number);
1172: --
1173: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1174: --
1175: hr_utility.set_location(' Leaving:'||l_proc, 10);
1176: End insert_validate;
1177: --

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

1269: p_mx_cvg_rl => p_rec.mx_cvg_rl,
1270: p_effective_date => p_effective_date,
1271: p_object_version_number => p_rec.object_version_number);
1272: --
1273: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1274: --
1275: -- Call the datetrack update integrity operation
1276: --
1277: dt_update_validate

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

1337: hr_utility.set_location('Entering:'|| l_proc, 10);
1338: --
1339: -- Ensure that all the mandatory parameter are not null
1340: --
1341: hr_api.mandatory_arg_error(p_api_name => l_proc,
1342: p_argument => 'ler_bnft_rstrn_id',
1343: p_argument_value => p_ler_bnft_rstrn_id);
1344: --
1345: open csr_leg_code;