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

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

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

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

124: (p_elig_dpnt_id => p_elig_dpnt_id,
125: p_object_version_number => p_object_version_number);
126: --
127: if (l_api_updating
128: and nvl(p_elig_per_opt_id,hr_api.g_number)
129: <> nvl(ben_egd_shd.g_old_rec.elig_per_opt_id,hr_api.g_number)
130: or not l_api_updating)
131: and p_elig_per_opt_id is not null then
132: --

Line 129: <> nvl(ben_egd_shd.g_old_rec.elig_per_opt_id,hr_api.g_number)

125: p_object_version_number => p_object_version_number);
126: --
127: if (l_api_updating
128: and nvl(p_elig_per_opt_id,hr_api.g_number)
129: <> nvl(ben_egd_shd.g_old_rec.elig_per_opt_id,hr_api.g_number)
130: or not l_api_updating)
131: and p_elig_per_opt_id is not null then
132: --
133: -- check if elig_per_opt_id value exists in ben_elig_per_opt_f table

Line 209: and nvl(p_elig_per_id,hr_api.g_number)

205: (p_elig_dpnt_id => p_elig_dpnt_id,
206: p_object_version_number => p_object_version_number);
207: --
208: if (l_api_updating
209: and nvl(p_elig_per_id,hr_api.g_number)
210: <> nvl(ben_egd_shd.g_old_rec.elig_per_id,hr_api.g_number)
211: or not l_api_updating)
212: and p_elig_per_id is not null then
213: --

Line 210: <> nvl(ben_egd_shd.g_old_rec.elig_per_id,hr_api.g_number)

206: p_object_version_number => p_object_version_number);
207: --
208: if (l_api_updating
209: and nvl(p_elig_per_id,hr_api.g_number)
210: <> nvl(ben_egd_shd.g_old_rec.elig_per_id,hr_api.g_number)
211: or not l_api_updating)
212: and p_elig_per_id is not null then
213: --
214: -- check if elig_per_id value exists in ben_elig_per_f table

Line 290: and nvl(p_dpnt_person_id,hr_api.g_number)

286: (p_elig_dpnt_id => p_elig_dpnt_id,
287: p_object_version_number => p_object_version_number);
288: --
289: if (l_api_updating
290: and nvl(p_dpnt_person_id,hr_api.g_number)
291: <> nvl(ben_egd_shd.g_old_rec.dpnt_person_id,hr_api.g_number)
292: or not l_api_updating) then
293: --
294: -- check if person_id value exists in per_all_people_f table

Line 291: <> nvl(ben_egd_shd.g_old_rec.dpnt_person_id,hr_api.g_number)

287: p_object_version_number => p_object_version_number);
288: --
289: if (l_api_updating
290: and nvl(p_dpnt_person_id,hr_api.g_number)
291: <> nvl(ben_egd_shd.g_old_rec.dpnt_person_id,hr_api.g_number)
292: or not l_api_updating) then
293: --
294: -- check if person_id value exists in per_all_people_f table
295: --

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

369: (p_elig_dpnt_id => p_elig_dpnt_id,
370: p_object_version_number => p_object_version_number);
371: --
372: if (l_api_updating
373: and nvl(p_per_in_ler_id,hr_api.g_number)
374: <> nvl(ben_egd_shd.g_old_rec.per_in_ler_id,hr_api.g_number)
375: or not l_api_updating) and
376: p_per_in_ler_id is not null then
377: --

Line 374: <> nvl(ben_egd_shd.g_old_rec.per_in_ler_id,hr_api.g_number)

370: p_object_version_number => p_object_version_number);
371: --
372: if (l_api_updating
373: and nvl(p_per_in_ler_id,hr_api.g_number)
374: <> nvl(ben_egd_shd.g_old_rec.per_in_ler_id,hr_api.g_number)
375: or not l_api_updating) and
376: p_per_in_ler_id is not null then
377: --
378: -- check if per_in_ler_id value exists in ben_per_in_ler table

Line 446: <> nvl(ben_egd_shd.g_old_rec.dpnt_inelig_flag,hr_api.g_varchar2)

442: p_object_version_number => p_object_version_number);
443: --
444: if (l_api_updating
445: and p_dpnt_inelig_flag
446: <> nvl(ben_egd_shd.g_old_rec.dpnt_inelig_flag,hr_api.g_varchar2)
447: or not l_api_updating) then
448: --
449: -- check if value of lookup falls within lookup type.
450: --

Line 452: if hr_api.not_exists_in_hr_lookups

448: --
449: -- check if value of lookup falls within lookup type.
450: --
451: --
452: if hr_api.not_exists_in_hr_lookups
453: (p_lookup_type => 'YES_NO',
454: p_lookup_code => p_dpnt_inelig_flag,
455: p_effective_date => p_effective_date) then
456: --

Line 516: <> nvl(ben_egd_shd.g_old_rec.inelg_rsn_cd,hr_api.g_varchar2)

512: p_object_version_number => p_object_version_number);
513: --
514: if (l_api_updating
515: and p_inelg_rsn_cd
516: <> nvl(ben_egd_shd.g_old_rec.inelg_rsn_cd,hr_api.g_varchar2)
517: or not l_api_updating)
518: and p_inelg_rsn_cd is not null then
519: --
520: -- check if value of lookup falls within lookup type.

Line 522: if hr_api.not_exists_in_hr_lookups

518: and p_inelg_rsn_cd is not null then
519: --
520: -- check if value of lookup falls within lookup type.
521: --
522: if hr_api.not_exists_in_hr_lookups
523: (p_lookup_type => 'BEN_INELG_RSN',
524: p_lookup_code => p_inelg_rsn_cd,
525: p_effective_date => p_effective_date) then
526: --

Line 586: <> nvl(ben_egd_shd.g_old_rec.ovrdn_flag,hr_api.g_varchar2)

582: p_object_version_number => p_object_version_number);
583: --
584: if (l_api_updating
585: and p_ovrdn_flag
586: <> nvl(ben_egd_shd.g_old_rec.ovrdn_flag,hr_api.g_varchar2)
587: or not l_api_updating) then
588: --
589: -- check if value of lookup falls within lookup type.
590: --

Line 592: if hr_api.not_exists_in_hr_lookups

588: --
589: -- check if value of lookup falls within lookup type.
590: --
591: --
592: if hr_api.not_exists_in_hr_lookups
593: (p_lookup_type => 'YES_NO',
594: p_lookup_code => p_ovrdn_flag,
595: p_effective_date => p_effective_date) then
596: --

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

622: --
623: -- Call all supporting business operations
624: --
625: --
626: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
627: --
628: chk_elig_dpnt_id
629: (p_elig_dpnt_id => p_rec.elig_dpnt_id,
630: p_object_version_number => p_rec.object_version_number);

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

687: --
688: -- Call all supporting business operations
689: --
690: --
691: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
692: --
693: chk_elig_dpnt_id
694: (p_elig_dpnt_id => p_rec.elig_dpnt_id,
695: p_object_version_number => p_rec.object_version_number);

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

782: hr_utility.set_location('Entering:'|| l_proc, 10);
783: --
784: -- Ensure that all the mandatory parameter are not null
785: --
786: hr_api.mandatory_arg_error(p_api_name => l_proc,
787: p_argument => 'elig_dpnt_id',
788: p_argument_value => p_elig_dpnt_id);
789: --
790: open csr_leg_code;