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

Line 55: and nvl(p_ler_chg_pl_nip_enrt_id,hr_api.g_number)

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

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

137: p_effective_date => p_effective_date,
138: p_object_version_number => p_object_version_number);
139: --
140: if (l_api_updating
141: and nvl(p_auto_enrt_mthd_rl,hr_api.g_number)
142: <> ben_lpe_shd.g_old_rec.auto_enrt_mthd_rl
143: or not l_api_updating)
144: and p_auto_enrt_mthd_rl is not null then
145: --

Line 220: <> nvl(ben_lpe_shd.g_old_rec.enrt_mthd_cd,hr_api.g_varchar2)

216: p_object_version_number => p_object_version_number);
217: --
218: if (l_api_updating
219: and p_enrt_mthd_cd
220: <> nvl(ben_lpe_shd.g_old_rec.enrt_mthd_cd,hr_api.g_varchar2)
221: or not l_api_updating)
222: and p_enrt_mthd_cd is not null then
223: --
224: -- check if value of lookup falls within lookup type.

Line 226: if hr_api.not_exists_in_hr_lookups

222: and p_enrt_mthd_cd is not null then
223: --
224: -- check if value of lookup falls within lookup type.
225: --
226: if hr_api.not_exists_in_hr_lookups
227: (p_lookup_type => 'BEN_ENRT_MTHD',
228: p_lookup_code => p_enrt_mthd_cd,
229: p_effective_date => p_effective_date) then
230: --

Line 291: <> nvl(ben_lpe_shd.g_old_rec.stl_elig_cant_chg_flag,hr_api.g_varchar2)

287: p_object_version_number => p_object_version_number);
288: --
289: if (l_api_updating
290: and p_stl_elig_cant_chg_flag
291: <> nvl(ben_lpe_shd.g_old_rec.stl_elig_cant_chg_flag,hr_api.g_varchar2)
292: or not l_api_updating) then
293: --
294: -- check if value of lookup falls within lookup type.
295: --

Line 297: if hr_api.not_exists_in_hr_lookups

293: --
294: -- check if value of lookup falls within lookup type.
295: --
296: --
297: if hr_api.not_exists_in_hr_lookups
298: (p_lookup_type => 'YES_NO',
299: p_lookup_code => p_stl_elig_cant_chg_flag,
300: p_effective_date => p_effective_date) then
301: --

Line 362: <> nvl(ben_lpe_shd.g_old_rec.enrt_cd,hr_api.g_varchar2)

358: p_object_version_number => p_object_version_number);
359: --
360: if (l_api_updating
361: and p_enrt_cd
362: <> nvl(ben_lpe_shd.g_old_rec.enrt_cd,hr_api.g_varchar2)
363: or not l_api_updating)
364: and p_enrt_cd is not null then
365: --
366: -- check if value of lookup falls within lookup type.

Line 368: if hr_api.not_exists_in_hr_lookups

364: and p_enrt_cd is not null then
365: --
366: -- check if value of lookup falls within lookup type.
367: --
368: if hr_api.not_exists_in_hr_lookups
369: (p_lookup_type => 'BEN_ENRT',
370: p_lookup_code => p_enrt_cd,
371: p_effective_date => p_effective_date) then
372: --

Line 450: and nvl(p_enrt_rl,hr_api.g_number)

446: p_effective_date => p_effective_date,
447: p_object_version_number => p_object_version_number);
448: --
449: if (l_api_updating
450: and nvl(p_enrt_rl,hr_api.g_number)
451: <> ben_lpe_shd.g_old_rec.enrt_rl
452: or not l_api_updating)
453: and p_enrt_rl is not null then
454: --

Line 529: <> nvl(ben_lpe_shd.g_old_rec.dflt_flag,hr_api.g_varchar2)

525: p_object_version_number => p_object_version_number);
526: --
527: if (l_api_updating
528: and p_dflt_flag
529: <> nvl(ben_lpe_shd.g_old_rec.dflt_flag,hr_api.g_varchar2)
530: or not l_api_updating) then
531: --
532: -- check if value of lookup falls within lookup type.
533: --

Line 535: if hr_api.not_exists_in_hr_lookups

531: --
532: -- check if value of lookup falls within lookup type.
533: --
534: --
535: if hr_api.not_exists_in_hr_lookups
536: (p_lookup_type => 'YES_NO',
537: p_lookup_code => p_dflt_flag,
538: p_effective_date => p_effective_date) then
539: --

Line 617: and nvl(p_dflt_enrt_rl,hr_api.g_number)

613: p_effective_date => p_effective_date,
614: p_object_version_number => p_object_version_number);
615: --
616: if (l_api_updating
617: and nvl(p_dflt_enrt_rl,hr_api.g_number)
618: <> ben_lpe_shd.g_old_rec.dflt_enrt_rl
619: or not l_api_updating)
620: and p_dflt_enrt_rl is not null then
621: --

Line 696: <> nvl(ben_lpe_shd.g_old_rec.dflt_enrt_cd,hr_api.g_varchar2)

692: p_object_version_number => p_object_version_number);
693: --
694: if (l_api_updating
695: and p_dflt_enrt_cd
696: <> nvl(ben_lpe_shd.g_old_rec.dflt_enrt_cd,hr_api.g_varchar2)
697: or not l_api_updating)
698: and p_dflt_enrt_cd is not null then
699: --
700: -- check if value of lookup falls within lookup type.

Line 702: if hr_api.not_exists_in_hr_lookups

698: and p_dflt_enrt_cd is not null then
699: --
700: -- check if value of lookup falls within lookup type.
701: --
702: if hr_api.not_exists_in_hr_lookups
703: (p_lookup_type => 'BEN_DFLT_ENRT',
704: p_lookup_code => p_dflt_enrt_cd,
705: p_effective_date => p_effective_date) then
706: --

Line 767: <> nvl(ben_lpe_shd.g_old_rec.crnt_enrt_prclds_chg_flag,hr_api.g_varchar2)

763: p_object_version_number => p_object_version_number);
764: --
765: if (l_api_updating
766: and p_crnt_enrt_prclds_chg_flag
767: <> nvl(ben_lpe_shd.g_old_rec.crnt_enrt_prclds_chg_flag,hr_api.g_varchar2)
768: or not l_api_updating) then
769: --
770: -- check if value of lookup falls within lookup type.
771: --

Line 773: if hr_api.not_exists_in_hr_lookups

769: --
770: -- check if value of lookup falls within lookup type.
771: --
772: --
773: if hr_api.not_exists_in_hr_lookups
774: (p_lookup_type => 'YES_NO',
775: p_lookup_code => p_crnt_enrt_prclds_chg_flag,
776: p_effective_date => p_effective_date) then
777: --

Line 839: <> nvl(ben_lpe_shd.g_old_rec.tco_chg_enrt_cd,hr_api.g_varchar2)

835: --
836: if (l_api_updating
837: and p_tco_chg_enrt_cd is not null
838: and p_tco_chg_enrt_cd
839: <> nvl(ben_lpe_shd.g_old_rec.tco_chg_enrt_cd,hr_api.g_varchar2)
840: or not l_api_updating)and p_tco_chg_enrt_cd is not null then
841: --
842: -- check if value of lookup falls within lookup type.
843: --

Line 845: if hr_api.not_exists_in_hr_lookups

841: --
842: -- check if value of lookup falls within lookup type.
843: --
844: --
845: if hr_api.not_exists_in_hr_lookups
846: (p_lookup_type => 'BEN_TCO_CHG_ENRT',
847: p_lookup_code => p_tco_chg_enrt_cd,
848: p_effective_date => p_effective_date) then
849: --

Line 895: (p_pl_id in number default hr_api.g_number,

891: --
892: -- {End Of Comments}
893: -- ----------------------------------------------------------------------------
894: Procedure dt_update_validate
895: (p_pl_id in number default hr_api.g_number,
896: p_datetrack_mode in varchar2,
897: p_validation_start_date in date,
898: p_validation_end_date in date) Is
899: --

Line 909: hr_api.mandatory_arg_error

905: hr_utility.set_location('Entering:'||l_proc, 5);
906: --
907: -- Ensure that the p_datetrack_mode argument is not null
908: --
909: hr_api.mandatory_arg_error
910: (p_api_name => l_proc,
911: p_argument => 'datetrack_mode',
912: p_argument_value => p_datetrack_mode);
913: --

Line 921: hr_api.mandatory_arg_error

917: --
918: --
919: -- Ensure the arguments are not null
920: --
921: hr_api.mandatory_arg_error
922: (p_api_name => l_proc,
923: p_argument => 'validation_start_date',
924: p_argument_value => p_validation_start_date);
925: --

Line 926: hr_api.mandatory_arg_error

922: (p_api_name => l_proc,
923: p_argument => 'validation_start_date',
924: p_argument_value => p_validation_start_date);
925: --
926: hr_api.mandatory_arg_error
927: (p_api_name => l_proc,
928: p_argument => 'validation_end_date',
929: p_argument_value => p_validation_end_date);
930: --

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

927: (p_api_name => l_proc,
928: p_argument => 'validation_end_date',
929: p_argument_value => p_validation_end_date);
930: --
931: If ((nvl(p_pl_id, hr_api.g_number) <> hr_api.g_number) and
932: NOT (dt_api.check_min_max_dates
933: (p_base_table_name => 'ben_pl_f',
934: p_base_key_column => 'pl_id',
935: p_base_key_value => p_pl_id,

Line 1015: hr_api.mandatory_arg_error

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

Line 1029: hr_api.mandatory_arg_error

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

Line 1034: hr_api.mandatory_arg_error

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

Line 1039: hr_api.mandatory_arg_error

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

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

1091: --
1092: -- Call all supporting business operations
1093: --
1094: --
1095: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1096: --
1097: chk_ler_chg_pl_nip_enrt_id
1098: (p_ler_chg_pl_nip_enrt_id => p_rec.ler_chg_pl_nip_enrt_id,
1099: p_effective_date => p_effective_date,

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

1182: --
1183: -- Call all supporting business operations
1184: --
1185: --
1186: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1187: --
1188: chk_ler_chg_pl_nip_enrt_id
1189: (p_ler_chg_pl_nip_enrt_id => p_rec.ler_chg_pl_nip_enrt_id,
1190: p_effective_date => p_effective_date,

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

1317: hr_utility.set_location('Entering:'|| l_proc, 10);
1318: --
1319: -- Ensure that all the mandatory parameter are not null
1320: --
1321: hr_api.mandatory_arg_error(p_api_name => l_proc,
1322: p_argument => 'ler_chg_pl_nip_enrt_id',
1323: p_argument_value => p_ler_chg_pl_nip_enrt_id);
1324: --
1325: open csr_leg_code;