APPS.BEN_BDI_BUS dependencies on HR_API

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

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

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

124: (p_batch_dpnt_id => p_batch_dpnt_id,
125: p_object_version_number => p_object_version_number);
126: --
127: if (l_api_updating
128: and nvl(p_person_id,hr_api.g_number)
129: <> nvl(ben_bdi_shd.g_old_rec.person_id,hr_api.g_number)
130: or not l_api_updating) then
131: --
132: -- check if person_id value exists in per_all_people_f table

Line 129: <> nvl(ben_bdi_shd.g_old_rec.person_id,hr_api.g_number)

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

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

204: (p_batch_dpnt_id => p_batch_dpnt_id,
205: p_object_version_number => p_object_version_number);
206: --
207: if ((l_api_updating
208: and nvl(p_oipl_id,hr_api.g_number)
209: <> nvl(ben_bdi_shd.g_old_rec.oipl_id,hr_api.g_number)
210: or not l_api_updating) and
211: p_oipl_id is not null) then
212: --

Line 209: <> nvl(ben_bdi_shd.g_old_rec.oipl_id,hr_api.g_number)

205: p_object_version_number => p_object_version_number);
206: --
207: if ((l_api_updating
208: and nvl(p_oipl_id,hr_api.g_number)
209: <> nvl(ben_bdi_shd.g_old_rec.oipl_id,hr_api.g_number)
210: or not l_api_updating) and
211: p_oipl_id is not null) then
212: --
213: -- check if oipl_id value exists in ben_oipl_f table

Line 289: and nvl(p_pl_id,hr_api.g_number)

285: (p_batch_dpnt_id => p_batch_dpnt_id,
286: p_object_version_number => p_object_version_number);
287: --
288: if ((l_api_updating
289: and nvl(p_pl_id,hr_api.g_number)
290: <> nvl(ben_bdi_shd.g_old_rec.pl_id,hr_api.g_number)
291: or not l_api_updating) and
292: p_pl_id is not null) then -- Bug 6407095
293: --

Line 290: <> nvl(ben_bdi_shd.g_old_rec.pl_id,hr_api.g_number)

286: p_object_version_number => p_object_version_number);
287: --
288: if ((l_api_updating
289: and nvl(p_pl_id,hr_api.g_number)
290: <> nvl(ben_bdi_shd.g_old_rec.pl_id,hr_api.g_number)
291: or not l_api_updating) and
292: p_pl_id is not null) then -- Bug 6407095
293: --
294: -- check if pl_id value exists in ben_pl_f table

Line 370: and nvl(p_pgm_id,hr_api.g_number)

366: (p_batch_dpnt_id => p_batch_dpnt_id,
367: p_object_version_number => p_object_version_number);
368: --
369: if ((l_api_updating
370: and nvl(p_pgm_id,hr_api.g_number)
371: <> nvl(ben_bdi_shd.g_old_rec.pgm_id,hr_api.g_number)
372: or not l_api_updating) and
373: p_pgm_id is not null) then
374: --

Line 371: <> nvl(ben_bdi_shd.g_old_rec.pgm_id,hr_api.g_number)

367: p_object_version_number => p_object_version_number);
368: --
369: if ((l_api_updating
370: and nvl(p_pgm_id,hr_api.g_number)
371: <> nvl(ben_bdi_shd.g_old_rec.pgm_id,hr_api.g_number)
372: or not l_api_updating) and
373: p_pgm_id is not null) then
374: --
375: -- check if pgm_id value exists in ben_pgm_f table

Line 446: and nvl(p_benefit_action_id,hr_api.g_number)

442: (p_batch_dpnt_id => p_batch_dpnt_id,
443: p_object_version_number => p_object_version_number);
444: --
445: if (l_api_updating
446: and nvl(p_benefit_action_id,hr_api.g_number)
447: <> nvl(ben_bdi_shd.g_old_rec.benefit_action_id,hr_api.g_number)
448: or not l_api_updating) then
449: --
450: -- check if benefit_action_id value exists in ben_benefit_actions table

Line 447: <> nvl(ben_bdi_shd.g_old_rec.benefit_action_id,hr_api.g_number)

443: p_object_version_number => p_object_version_number);
444: --
445: if (l_api_updating
446: and nvl(p_benefit_action_id,hr_api.g_number)
447: <> nvl(ben_bdi_shd.g_old_rec.benefit_action_id,hr_api.g_number)
448: or not l_api_updating) then
449: --
450: -- check if benefit_action_id value exists in ben_benefit_actions table
451: --

Line 518: <> nvl(ben_bdi_shd.g_old_rec.contact_typ_cd,hr_api.g_varchar2)

514: p_object_version_number => p_object_version_number);
515: --
516: if (l_api_updating
517: and p_contact_typ_cd
518: <> nvl(ben_bdi_shd.g_old_rec.contact_typ_cd,hr_api.g_varchar2)
519: or not l_api_updating)
520: and p_contact_typ_cd is not null then
521: --
522: -- check if value of lookup falls within lookup type.

Line 524: if hr_api.not_exists_in_hr_lookups

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

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

554: --
555: -- Call all supporting business operations
556: --
557: --
558: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
559: --
560: chk_batch_dpnt_id
561: (p_batch_dpnt_id => p_rec.batch_dpnt_id,
562: p_object_version_number => p_rec.object_version_number);

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

618: --
619: -- Call all supporting business operations
620: --
621: --
622: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
623: --
624: chk_batch_dpnt_id
625: (p_batch_dpnt_id => p_rec.batch_dpnt_id,
626: p_object_version_number => p_rec.object_version_number);

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

712: hr_utility.set_location('Entering:'|| l_proc, 10);
713: --
714: -- Ensure that all the mandatory parameter are not null
715: --
716: hr_api.mandatory_arg_error(p_api_name => l_proc,
717: p_argument => 'batch_dpnt_id',
718: p_argument_value => p_batch_dpnt_id);
719: --
720: open csr_leg_code;