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

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

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

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

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

Line 132: <> nvl(ben_ppl_shd.g_old_rec.ler_id,hr_api.g_number)

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

Line 160: and nvl(p_enrt_perd_id,hr_api.g_number)

156: null;
157: /*
158: -- PB : 5422 :
159: if (l_api_updating
160: and nvl(p_enrt_perd_id,hr_api.g_number)
161: = nvl(ben_ppl_shd.g_old_rec.enrt_perd_id,hr_api.g_number)
162: or (not l_api_updating and p_enrt_perd_id is null )) and
163: (l_typ_cd like 'SCHEDD%' and l_typ_cd <> 'SCHEDDU')
164: then

Line 161: = nvl(ben_ppl_shd.g_old_rec.enrt_perd_id,hr_api.g_number)

157: /*
158: -- PB : 5422 :
159: if (l_api_updating
160: and nvl(p_enrt_perd_id,hr_api.g_number)
161: = nvl(ben_ppl_shd.g_old_rec.enrt_perd_id,hr_api.g_number)
162: or (not l_api_updating and p_enrt_perd_id is null )) and
163: (l_typ_cd like 'SCHEDD%' and l_typ_cd <> 'SCHEDDU')
164: then
165: --

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

236: (p_ptnl_ler_for_per_id => p_ptnl_ler_for_per_id,
237: p_object_version_number => p_object_version_number);
238: --
239: if ((l_api_updating
240: and (nvl(p_ler_id,hr_api.g_number)
241: <> nvl(ben_ppl_shd.g_old_rec.ler_id,hr_api.g_number)
242: or nvl(p_lf_evt_ocrd_dt,hr_api.g_date)
243: <> nvl(ben_ppl_shd.g_old_rec.lf_evt_ocrd_dt,hr_api.g_date)
244: or nvl(p_ptnl_ler_for_per_stat_cd,hr_api.g_varchar2)

Line 241: <> nvl(ben_ppl_shd.g_old_rec.ler_id,hr_api.g_number)

237: p_object_version_number => p_object_version_number);
238: --
239: if ((l_api_updating
240: and (nvl(p_ler_id,hr_api.g_number)
241: <> nvl(ben_ppl_shd.g_old_rec.ler_id,hr_api.g_number)
242: or nvl(p_lf_evt_ocrd_dt,hr_api.g_date)
243: <> nvl(ben_ppl_shd.g_old_rec.lf_evt_ocrd_dt,hr_api.g_date)
244: or nvl(p_ptnl_ler_for_per_stat_cd,hr_api.g_varchar2)
245: <> nvl(ben_ppl_shd.g_old_rec.ptnl_ler_for_per_stat_cd,hr_api.g_varchar2)

Line 242: or nvl(p_lf_evt_ocrd_dt,hr_api.g_date)

238: --
239: if ((l_api_updating
240: and (nvl(p_ler_id,hr_api.g_number)
241: <> nvl(ben_ppl_shd.g_old_rec.ler_id,hr_api.g_number)
242: or nvl(p_lf_evt_ocrd_dt,hr_api.g_date)
243: <> nvl(ben_ppl_shd.g_old_rec.lf_evt_ocrd_dt,hr_api.g_date)
244: or nvl(p_ptnl_ler_for_per_stat_cd,hr_api.g_varchar2)
245: <> nvl(ben_ppl_shd.g_old_rec.ptnl_ler_for_per_stat_cd,hr_api.g_varchar2)
246: )

Line 243: <> nvl(ben_ppl_shd.g_old_rec.lf_evt_ocrd_dt,hr_api.g_date)

239: if ((l_api_updating
240: and (nvl(p_ler_id,hr_api.g_number)
241: <> nvl(ben_ppl_shd.g_old_rec.ler_id,hr_api.g_number)
242: or nvl(p_lf_evt_ocrd_dt,hr_api.g_date)
243: <> nvl(ben_ppl_shd.g_old_rec.lf_evt_ocrd_dt,hr_api.g_date)
244: or nvl(p_ptnl_ler_for_per_stat_cd,hr_api.g_varchar2)
245: <> nvl(ben_ppl_shd.g_old_rec.ptnl_ler_for_per_stat_cd,hr_api.g_varchar2)
246: )
247: )

Line 244: or nvl(p_ptnl_ler_for_per_stat_cd,hr_api.g_varchar2)

240: and (nvl(p_ler_id,hr_api.g_number)
241: <> nvl(ben_ppl_shd.g_old_rec.ler_id,hr_api.g_number)
242: or nvl(p_lf_evt_ocrd_dt,hr_api.g_date)
243: <> nvl(ben_ppl_shd.g_old_rec.lf_evt_ocrd_dt,hr_api.g_date)
244: or nvl(p_ptnl_ler_for_per_stat_cd,hr_api.g_varchar2)
245: <> nvl(ben_ppl_shd.g_old_rec.ptnl_ler_for_per_stat_cd,hr_api.g_varchar2)
246: )
247: )
248: or not l_api_updating) then

Line 245: <> nvl(ben_ppl_shd.g_old_rec.ptnl_ler_for_per_stat_cd,hr_api.g_varchar2)

241: <> nvl(ben_ppl_shd.g_old_rec.ler_id,hr_api.g_number)
242: or nvl(p_lf_evt_ocrd_dt,hr_api.g_date)
243: <> nvl(ben_ppl_shd.g_old_rec.lf_evt_ocrd_dt,hr_api.g_date)
244: or nvl(p_ptnl_ler_for_per_stat_cd,hr_api.g_varchar2)
245: <> nvl(ben_ppl_shd.g_old_rec.ptnl_ler_for_per_stat_cd,hr_api.g_varchar2)
246: )
247: )
248: or not l_api_updating) then
249: --

Line 311: and nvl(p_csd_by_ptnl_ler_for_per_id,hr_api.g_number)

307: (p_ptnl_ler_for_per_id => p_ptnl_ler_for_per_id,
308: p_object_version_number => p_object_version_number);
309: --
310: if (l_api_updating
311: and nvl(p_csd_by_ptnl_ler_for_per_id,hr_api.g_number)
312: <> nvl(ben_ppl_shd.g_old_rec.csd_by_ptnl_ler_for_per_id,hr_api.g_number)
313: or (not l_api_updating and p_csd_by_ptnl_ler_for_per_id is not null )) then
314: --
315: -- check if csd_by_ptnl_ler_for_per_id value exists in ben_enrt_perd table

Line 312: <> nvl(ben_ppl_shd.g_old_rec.csd_by_ptnl_ler_for_per_id,hr_api.g_number)

308: p_object_version_number => p_object_version_number);
309: --
310: if (l_api_updating
311: and nvl(p_csd_by_ptnl_ler_for_per_id,hr_api.g_number)
312: <> nvl(ben_ppl_shd.g_old_rec.csd_by_ptnl_ler_for_per_id,hr_api.g_number)
313: or (not l_api_updating and p_csd_by_ptnl_ler_for_per_id is not null )) then
314: --
315: -- check if csd_by_ptnl_ler_for_per_id value exists in ben_enrt_perd table
316: --

Line 387: and nvl(p_enrt_perd_id,hr_api.g_number)

383: (p_ptnl_ler_for_per_id => p_ptnl_ler_for_per_id,
384: p_object_version_number => p_object_version_number);
385: --
386: if (l_api_updating
387: and nvl(p_enrt_perd_id,hr_api.g_number)
388: <> nvl(ben_ppl_shd.g_old_rec.enrt_perd_id,hr_api.g_number)
389: or (not l_api_updating and p_enrt_perd_id is not null )) then
390: --
391: -- check if enrt_perd_id value exists in ben_enrt_perd table

Line 388: <> nvl(ben_ppl_shd.g_old_rec.enrt_perd_id,hr_api.g_number)

384: p_object_version_number => p_object_version_number);
385: --
386: if (l_api_updating
387: and nvl(p_enrt_perd_id,hr_api.g_number)
388: <> nvl(ben_ppl_shd.g_old_rec.enrt_perd_id,hr_api.g_number)
389: or (not l_api_updating and p_enrt_perd_id is not null )) then
390: --
391: -- check if enrt_perd_id value exists in ben_enrt_perd table
392: --

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

503: (p_ptnl_ler_for_per_id => p_ptnl_ler_for_per_id,
504: p_object_version_number => p_object_version_number);
505: --
506: if (l_api_updating
507: and nvl(p_person_id,hr_api.g_number)
508: <> nvl(ben_ppl_shd.g_old_rec.person_id,hr_api.g_number)
509: or not l_api_updating) then
510: --
511: -- check if person_id value exists in per_all_people_f table

Line 508: <> nvl(ben_ppl_shd.g_old_rec.person_id,hr_api.g_number)

504: p_object_version_number => p_object_version_number);
505: --
506: if (l_api_updating
507: and nvl(p_person_id,hr_api.g_number)
508: <> nvl(ben_ppl_shd.g_old_rec.person_id,hr_api.g_number)
509: or not l_api_updating) then
510: --
511: -- check if person_id value exists in per_all_people_f table
512: hr_utility.set_location('ace p_lf_evt_ocrd_dt = ' || p_lf_evt_ocrd_dt, 9999);

Line 617: <> nvl(ben_ppl_shd.g_old_rec.ptnl_ler_for_per_src_cd,hr_api.g_varchar2)

613: p_object_version_number => p_object_version_number);
614: --
615: if (l_api_updating
616: and p_ptnl_ler_for_per_src_cd
617: <> nvl(ben_ppl_shd.g_old_rec.ptnl_ler_for_per_src_cd,hr_api.g_varchar2)
618: or not l_api_updating)
619: and p_ptnl_ler_for_per_src_cd is not null then
620: --
621: -- check if value of lookup falls within lookup type.

Line 623: if hr_api.not_exists_in_hr_lookups

619: and p_ptnl_ler_for_per_src_cd is not null then
620: --
621: -- check if value of lookup falls within lookup type.
622: --
623: if hr_api.not_exists_in_hr_lookups
624: (p_lookup_type => 'BEN_PTNL_LER_FOR_PER_SRC',
625: p_lookup_code => p_ptnl_ler_for_per_src_cd,
626: p_effective_date => p_effective_date) then
627: --

Line 687: <> nvl(ben_ppl_shd.g_old_rec.ptnl_ler_for_per_stat_cd,hr_api.g_varchar2)

683: p_object_version_number => p_object_version_number);
684: --
685: if (l_api_updating
686: and p_ptnl_ler_for_per_stat_cd
687: <> nvl(ben_ppl_shd.g_old_rec.ptnl_ler_for_per_stat_cd,hr_api.g_varchar2)
688: or not l_api_updating) then
689: --
690: -- check if value of lookup falls within lookup type.
691: --

Line 692: if hr_api.not_exists_in_hr_lookups

688: or not l_api_updating) then
689: --
690: -- check if value of lookup falls within lookup type.
691: --
692: if hr_api.not_exists_in_hr_lookups
693: (p_lookup_type => 'BEN_PTNL_LER_FOR_PER_STAT',
694: p_lookup_code => p_ptnl_ler_for_per_stat_cd,
695: p_effective_date => p_effective_date) then
696: --

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

941: --
942: -- Call all supporting business operations
943: --
944: --
945: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
946: --
947: chk_ptnl_ler_for_per_id
948: (p_ptnl_ler_for_per_id => p_rec.ptnl_ler_for_per_id,
949: p_object_version_number => p_rec.object_version_number);

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

1021: --
1022: -- Call all supporting business operations
1023: --
1024: --
1025: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1026: --
1027: chk_ptnl_ler_for_per_id
1028: (p_ptnl_ler_for_per_id => p_rec.ptnl_ler_for_per_id,
1029: p_object_version_number => p_rec.object_version_number);

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

1129: hr_utility.set_location('Entering:'|| l_proc, 10);
1130: --
1131: -- Ensure that all the mandatory parameter are not null
1132: --
1133: hr_api.mandatory_arg_error(p_api_name => l_proc,
1134: p_argument => 'ptnl_ler_for_per_id',
1135: p_argument_value => p_ptnl_ler_for_per_id);
1136: --
1137: open csr_leg_code;