APPS.BEN_EEI_BUS dependencies on HR_API

Line 54: and nvl(p_elig_enrld_anthr_oipl_id,hr_api.g_number)

50: p_elig_enrld_anthr_oipl_id => p_elig_enrld_anthr_oipl_id,
51: p_object_version_number => p_object_version_number);
52: --
53: if (l_api_updating
54: and nvl(p_elig_enrld_anthr_oipl_id,hr_api.g_number)
55: <> ben_eei_shd.g_old_rec.elig_enrld_anthr_oipl_id) then
56: --
57: -- raise error as PK has changed
58: --

Line 132: and eei.elig_enrld_anthr_oipl_id <> nvl(p_elig_enrld_anthr_oipl_id,hr_api.g_number)

128: select null
129: from ben_elig_enrld_anthr_oipl_f eei
130: where eei.oipl_id = p_oipl_id
131: and eei.eligy_prfl_id = p_eligy_prfl_id
132: and eei.elig_enrld_anthr_oipl_id <> nvl(p_elig_enrld_anthr_oipl_id,hr_api.g_number)
133:
134: and eei.business_group_id + 0 = p_business_group_id
135: and p_validation_start_date <= eei.effective_end_date
136: and p_validation_end_date >= eei.effective_start_date;

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

144: p_effective_date => p_effective_date,
145: p_object_version_number => p_object_version_number);
146: --
147: if (l_api_updating
148: and nvl(p_oipl_id,hr_api.g_number)
149: <> nvl(ben_eei_shd.g_old_rec.oipl_id,hr_api.g_number)
150: or not l_api_updating) then
151: --
152: -- check if oipl_id value exists in the oipl table

Line 149: <> nvl(ben_eei_shd.g_old_rec.oipl_id,hr_api.g_number)

145: p_object_version_number => p_object_version_number);
146: --
147: if (l_api_updating
148: and nvl(p_oipl_id,hr_api.g_number)
149: <> nvl(ben_eei_shd.g_old_rec.oipl_id,hr_api.g_number)
150: or not l_api_updating) then
151: --
152: -- check if oipl_id value exists in the oipl table
153: open c1;

Line 234: <> nvl(ben_eei_shd.g_old_rec.enrl_det_dt_cd,hr_api.g_varchar2)

230: p_object_version_number => p_object_version_number);
231: --
232: if (l_api_updating
233: and p_enrl_det_dt_cd
234: <> nvl(ben_eei_shd.g_old_rec.enrl_det_dt_cd,hr_api.g_varchar2)
235: or not l_api_updating)
236: and p_enrl_det_dt_cd is not null then
237: --
238: -- check if value of lookup falls within lookup type.

Line 240: if hr_api.not_exists_in_hr_lookups

236: and p_enrl_det_dt_cd is not null then
237: --
238: -- check if value of lookup falls within lookup type.
239: --
240: if hr_api.not_exists_in_hr_lookups
241: (p_lookup_type => 'BEN_ENRL_DET_DT',
242: p_lookup_code => p_enrl_det_dt_cd,
243: p_effective_date => p_effective_date) then
244: --

Line 305: <> nvl(ben_eei_shd.g_old_rec.excld_flag,hr_api.g_varchar2)

301: p_object_version_number => p_object_version_number);
302: --
303: if (l_api_updating
304: and p_excld_flag
305: <> nvl(ben_eei_shd.g_old_rec.excld_flag,hr_api.g_varchar2)
306: or not l_api_updating) then
307: --
308: -- check if value of lookup falls within lookup type.
309: --

Line 311: if hr_api.not_exists_in_hr_lookups

307: --
308: -- check if value of lookup falls within lookup type.
309: --
310: --
311: if hr_api.not_exists_in_hr_lookups
312: (p_lookup_type => 'YES_NO',
313: p_lookup_code => p_excld_flag,
314: p_effective_date => p_effective_date) then
315: --

Line 419: (p_eligy_prfl_id in number default hr_api.g_number,

415: --
416: -- {End Of Comments}
417: -- ----------------------------------------------------------------------------
418: Procedure dt_update_validate
419: (p_eligy_prfl_id in number default hr_api.g_number,
420: p_oipl_id in number default hr_api.g_number,
421: p_datetrack_mode in varchar2,
422: p_validation_start_date in date,
423: p_validation_end_date in date) Is

Line 420: p_oipl_id in number default hr_api.g_number,

416: -- {End Of Comments}
417: -- ----------------------------------------------------------------------------
418: Procedure dt_update_validate
419: (p_eligy_prfl_id in number default hr_api.g_number,
420: p_oipl_id in number default hr_api.g_number,
421: p_datetrack_mode in varchar2,
422: p_validation_start_date in date,
423: p_validation_end_date in date) Is
424: --

Line 434: hr_api.mandatory_arg_error

430: hr_utility.set_location('Entering:'||l_proc, 5);
431: --
432: -- Ensure that the p_datetrack_mode argument is not null
433: --
434: hr_api.mandatory_arg_error
435: (p_api_name => l_proc,
436: p_argument => 'datetrack_mode',
437: p_argument_value => p_datetrack_mode);
438: --

Line 446: hr_api.mandatory_arg_error

442: --
443: --
444: -- Ensure the arguments are not null
445: --
446: hr_api.mandatory_arg_error
447: (p_api_name => l_proc,
448: p_argument => 'validation_start_date',
449: p_argument_value => p_validation_start_date);
450: --

Line 451: hr_api.mandatory_arg_error

447: (p_api_name => l_proc,
448: p_argument => 'validation_start_date',
449: p_argument_value => p_validation_start_date);
450: --
451: hr_api.mandatory_arg_error
452: (p_api_name => l_proc,
453: p_argument => 'validation_end_date',
454: p_argument_value => p_validation_end_date);
455: --

Line 456: If ((nvl(p_eligy_prfl_id, hr_api.g_number) <> hr_api.g_number) and

452: (p_api_name => l_proc,
453: p_argument => 'validation_end_date',
454: p_argument_value => p_validation_end_date);
455: --
456: If ((nvl(p_eligy_prfl_id, hr_api.g_number) <> hr_api.g_number) and
457: NOT (dt_api.check_min_max_dates
458: (p_base_table_name => 'ben_eligy_prfl_f',
459: p_base_key_column => 'eligy_prfl_id',
460: p_base_key_value => p_eligy_prfl_id,

Line 466: If ((nvl(p_oipl_id, hr_api.g_number) <> hr_api.g_number) and

462: p_to_date => p_validation_end_date))) Then
463: l_table_name := 'ben_eligy_prfl_f';
464: Raise l_integrity_error;
465: End If;
466: If ((nvl(p_oipl_id, hr_api.g_number) <> hr_api.g_number) and
467: NOT (dt_api.check_min_max_dates
468: (p_base_table_name => 'ben_oipl_f',
469: p_base_key_column => 'oipl_id',
470: p_base_key_value => p_oipl_id,

Line 548: hr_api.mandatory_arg_error

544: hr_utility.set_location('Entering:'||l_proc, 5);
545: --
546: -- Ensure that the p_datetrack_mode argument is not null
547: --
548: hr_api.mandatory_arg_error
549: (p_api_name => l_proc,
550: p_argument => 'datetrack_mode',
551: p_argument_value => p_datetrack_mode);
552: --

Line 562: hr_api.mandatory_arg_error

558: --
559: --
560: -- Ensure the arguments are not null
561: --
562: hr_api.mandatory_arg_error
563: (p_api_name => l_proc,
564: p_argument => 'validation_start_date',
565: p_argument_value => p_validation_start_date);
566: --

Line 567: hr_api.mandatory_arg_error

563: (p_api_name => l_proc,
564: p_argument => 'validation_start_date',
565: p_argument_value => p_validation_start_date);
566: --
567: hr_api.mandatory_arg_error
568: (p_api_name => l_proc,
569: p_argument => 'validation_end_date',
570: p_argument_value => p_validation_end_date);
571: --

Line 572: hr_api.mandatory_arg_error

568: (p_api_name => l_proc,
569: p_argument => 'validation_end_date',
570: p_argument_value => p_validation_end_date);
571: --
572: hr_api.mandatory_arg_error
573: (p_api_name => l_proc,
574: p_argument => 'elig_enrld_anthr_oipl_id',
575: p_argument_value => p_elig_enrld_anthr_oipl_id);
576: --

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

616: --
617: -- Call all supporting business operations
618: --
619: --
620: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
621: --
622: chk_elig_enrld_anthr_oipl_id
623: (p_elig_enrld_anthr_oipl_id => p_rec.elig_enrld_anthr_oipl_id,
624: p_effective_date => p_effective_date,

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

672: --
673: -- Call all supporting business operations
674: --
675: --
676: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
677: --
678: chk_elig_enrld_anthr_oipl_id
679: (p_elig_enrld_anthr_oipl_id => p_rec.elig_enrld_anthr_oipl_id,
680: p_effective_date => p_effective_date,

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

773: hr_utility.set_location('Entering:'|| l_proc, 10);
774: --
775: -- Ensure that all the mandatory parameter are not null
776: --
777: hr_api.mandatory_arg_error(p_api_name => l_proc,
778: p_argument => 'elig_enrld_anthr_oipl_id',
779: p_argument_value => p_elig_enrld_anthr_oipl_id);
780: --
781: open csr_leg_code;