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: --
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: --
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
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: --
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
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: --
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
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
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: --
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
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: --
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: --
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: --
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);
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);
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;