DBA Data[Home] [Help]

APPS.BEN_BEI_BUS dependencies on HR_API

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

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

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

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

Line 129: <> nvl(ben_bei_shd.g_old_rec.oipl_id,hr_api.g_number)

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

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

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

Line 210: <> nvl(ben_bei_shd.g_old_rec.pl_id,hr_api.g_number)

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

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

286: (p_batch_elig_id => p_batch_elig_id,
287: p_object_version_number => p_object_version_number);
288: --
289: if (l_api_updating
290: and nvl(p_pgm_id,hr_api.g_number)
291: <> nvl(ben_bei_shd.g_old_rec.pgm_id,hr_api.g_number)
292: or not l_api_updating)
293: and p_pgm_id is not null then
294: --

Line 291: <> nvl(ben_bei_shd.g_old_rec.pgm_id,hr_api.g_number)

287: p_object_version_number => p_object_version_number);
288: --
289: if (l_api_updating
290: and nvl(p_pgm_id,hr_api.g_number)
291: <> nvl(ben_bei_shd.g_old_rec.pgm_id,hr_api.g_number)
292: or not l_api_updating)
293: and p_pgm_id is not null then
294: --
295: -- check if pgm_id value exists in ben_pgm_f table

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

367: (p_batch_elig_id => p_batch_elig_id,
368: p_object_version_number => p_object_version_number);
369: --
370: if (l_api_updating
371: and nvl(p_person_id,hr_api.g_number)
372: <> nvl(ben_bei_shd.g_old_rec.person_id,hr_api.g_number)
373: or not l_api_updating) then
374: --
375: -- check if person_id value exists in per_all_people_f table

Line 372: <> nvl(ben_bei_shd.g_old_rec.person_id,hr_api.g_number)

368: p_object_version_number => p_object_version_number);
369: --
370: if (l_api_updating
371: and nvl(p_person_id,hr_api.g_number)
372: <> nvl(ben_bei_shd.g_old_rec.person_id,hr_api.g_number)
373: or not l_api_updating) then
374: --
375: -- check if person_id value exists in per_all_people_f table
376: --

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

442: (p_batch_elig_id => p_batch_elig_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_bei_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_bei_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_bei_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_bei_shd.g_old_rec.elig_flag,hr_api.g_varchar2)

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

Line 524: if hr_api.not_exists_in_hr_lookups

520: --
521: -- check if value of lookup falls within lookup type.
522: --
523: --
524: if hr_api.not_exists_in_hr_lookups
525: (p_lookup_type => 'YES_NO',
526: p_lookup_code => p_elig_flag,
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_elig_id
561: (p_batch_elig_id => p_rec.batch_elig_id,
562: p_object_version_number => p_rec.object_version_number);

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

612: --
613: -- Call all supporting business operations
614: --
615: --
616: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
617: --
618: chk_batch_elig_id
619: (p_batch_elig_id => p_rec.batch_elig_id,
620: p_object_version_number => p_rec.object_version_number);

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

700: hr_utility.set_location('Entering:'|| l_proc, 10);
701: --
702: -- Ensure that all the mandatory parameter are not null
703: --
704: hr_api.mandatory_arg_error(p_api_name => l_proc,
705: p_argument => 'batch_elig_id',
706: p_argument_value => p_batch_elig_id);
707: --
708: open csr_leg_code;