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

Line 51: and nvl(p_per_in_ler_id,hr_api.g_number)

47: (p_per_in_ler_id => p_per_in_ler_id,
48: p_object_version_number => p_object_version_number);
49: --
50: if (l_api_updating
51: and nvl(p_per_in_ler_id,hr_api.g_number)
52: <> ben_pil_shd.g_old_rec.per_in_ler_id) then
53: --
54: -- raise error as PK has changed
55: --

Line 128: and nvl(p_ler_id,hr_api.g_number)

124: (p_per_in_ler_id => p_per_in_ler_id,
125: p_object_version_number => p_object_version_number);
126: --
127: if (l_api_updating
128: and nvl(p_ler_id,hr_api.g_number)
129: <> nvl(ben_pil_shd.g_old_rec.ler_id,hr_api.g_number)
130: or not l_api_updating) then
131: --
132: -- check if ler_id value exists in ben_ler_f table

Line 129: <> nvl(ben_pil_shd.g_old_rec.ler_id,hr_api.g_number)

125: p_object_version_number => p_object_version_number);
126: --
127: if (l_api_updating
128: and nvl(p_ler_id,hr_api.g_number)
129: <> nvl(ben_pil_shd.g_old_rec.ler_id,hr_api.g_number)
130: or not l_api_updating) then
131: --
132: -- check if ler_id value exists in ben_ler_f table
133: --

Line 208: and nvl(p_person_id,hr_api.g_number)

204: (p_per_in_ler_id => p_per_in_ler_id,
205: p_object_version_number => p_object_version_number);
206: --
207: if (l_api_updating
208: and nvl(p_person_id,hr_api.g_number)
209: <> nvl(ben_pil_shd.g_old_rec.person_id,hr_api.g_number)
210: or not l_api_updating) then
211: --
212: -- check if person_id value exists in per_all_people_f table

Line 209: <> nvl(ben_pil_shd.g_old_rec.person_id,hr_api.g_number)

205: p_object_version_number => p_object_version_number);
206: --
207: if (l_api_updating
208: and nvl(p_person_id,hr_api.g_number)
209: <> nvl(ben_pil_shd.g_old_rec.person_id,hr_api.g_number)
210: or not l_api_updating) then
211: --
212: -- check if person_id value exists in per_all_people_f table
213: --

Line 281: <> nvl(ben_pil_shd.g_old_rec.prvs_stat_cd,hr_api.g_varchar2)

277: p_object_version_number => p_object_version_number);
278: --
279: if (l_api_updating
280: and p_prvs_stat_cd
281: <> nvl(ben_pil_shd.g_old_rec.prvs_stat_cd,hr_api.g_varchar2)
282: or not l_api_updating)
283: and p_prvs_stat_cd is not null then
284: --
285: -- check if value of lookup falls within lookup type.

Line 287: if hr_api.not_exists_in_hr_lookups

283: and p_prvs_stat_cd is not null then
284: --
285: -- check if value of lookup falls within lookup type.
286: --
287: if hr_api.not_exists_in_hr_lookups
288: (p_lookup_type => 'BEN_PER_IN_LER_STAT',
289: p_lookup_code => p_prvs_stat_cd,
290: p_effective_date => p_effective_date) then
291: --

Line 351: <> nvl(ben_pil_shd.g_old_rec.per_in_ler_stat_cd,hr_api.g_varchar2)

347: p_object_version_number => p_object_version_number);
348: --
349: if (l_api_updating
350: and p_per_in_ler_stat_cd
351: <> nvl(ben_pil_shd.g_old_rec.per_in_ler_stat_cd,hr_api.g_varchar2)
352: or not l_api_updating)
353: and p_per_in_ler_stat_cd is not null then
354: --
355: -- check if value of lookup falls within lookup type.

Line 357: if hr_api.not_exists_in_hr_lookups

353: and p_per_in_ler_stat_cd is not null then
354: --
355: -- check if value of lookup falls within lookup type.
356: --
357: if hr_api.not_exists_in_hr_lookups
358: (p_lookup_type => 'BEN_PER_IN_LER_STAT',
359: p_lookup_code => p_per_in_ler_stat_cd,
360: p_effective_date => p_effective_date) then
361: --

Line 426: and nvl(p_bckt_per_in_ler_id,hr_api.g_number)

422: (p_per_in_ler_id => p_per_in_ler_id,
423: p_object_version_number => p_object_version_number);
424: --
425: if (l_api_updating
426: and nvl(p_bckt_per_in_ler_id,hr_api.g_number)
427: <> nvl(ben_pil_shd.g_old_rec.bckt_per_in_ler_id,hr_api.g_number)
428: or not l_api_updating)
429: and p_bckt_per_in_ler_id is not null
430: then

Line 427: <> nvl(ben_pil_shd.g_old_rec.bckt_per_in_ler_id,hr_api.g_number)

423: p_object_version_number => p_object_version_number);
424: --
425: if (l_api_updating
426: and nvl(p_bckt_per_in_ler_id,hr_api.g_number)
427: <> nvl(ben_pil_shd.g_old_rec.bckt_per_in_ler_id,hr_api.g_number)
428: or not l_api_updating)
429: and p_bckt_per_in_ler_id is not null
430: then
431: --

Line 500: <> nvl(ben_pil_shd.g_old_rec.ws_mgr_id,hr_api.g_number)) then

496:
497: hr_utility.set_location(' Entering:'||l_proc, 10);
498:
499: if (p_ws_mgr_id
500: <> nvl(ben_pil_shd.g_old_rec.ws_mgr_id,hr_api.g_number)) then
501:
502: open c1;
503: fetch c1 into l_person1,l_person2;
504: if c1%found then

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

527: --
528: -- Call all supporting business operations
529: --
530: --
531: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
532: --
533: chk_per_in_ler_id
534: (p_per_in_ler_id => p_rec.per_in_ler_id,
535: p_object_version_number => p_rec.object_version_number);

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

569: --
570: -- Call all supporting business operations
571: --
572: --
573: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
574: --
575: chk_per_in_ler_id
576: (p_per_in_ler_id => p_rec.per_in_ler_id,
577: p_object_version_number => p_rec.object_version_number);

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

645: hr_utility.set_location('Entering:'|| l_proc, 10);
646: --
647: -- Ensure that all the mandatory parameter are not null
648: --
649: hr_api.mandatory_arg_error(p_api_name => l_proc,
650: p_argument => 'per_in_ler_id',
651: p_argument_value => p_per_in_ler_id);
652: --
653: open csr_leg_code;