APPS.BEN_EAO_BUS dependencies on HR_API

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

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

Line 132: and eao.enrld_anthr_oipl_rt_id <> nvl(p_enrld_anthr_oipl_rt_id,hr_api.g_number)

128: select null
129: from ben_enrld_anthr_oipl_rt_f eao
130: where eao.oipl_id = p_oipl_id
131: and eao.vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
132: and eao.enrld_anthr_oipl_rt_id <> nvl(p_enrld_anthr_oipl_rt_id,hr_api.g_number)
133:
134: and eao.business_group_id + 0 = p_business_group_id
135: and p_validation_start_date <= eao.effective_end_date
136: and p_validation_end_date >= eao.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_eao_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_eao_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_eao_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 236: <> nvl(ben_eao_shd.g_old_rec.enrl_det_dt_cd,hr_api.g_varchar2)

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

Line 242: if hr_api.not_exists_in_hr_lookups

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

Line 307: <> nvl(ben_eao_shd.g_old_rec.excld_flag,hr_api.g_varchar2)

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

Line 313: if hr_api.not_exists_in_hr_lookups

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

Line 434: (p_vrbl_rt_prfl_id in number default hr_api.g_number,

430: --
431: -- {End Of Comments}
432: -- ----------------------------------------------------------------------------
433: Procedure dt_update_validate
434: (p_vrbl_rt_prfl_id in number default hr_api.g_number,
435: p_oipl_id in number default hr_api.g_number,
436: p_datetrack_mode in varchar2,
437: p_validation_start_date in date,
438: p_validation_end_date in date) Is

Line 435: p_oipl_id in number default hr_api.g_number,

431: -- {End Of Comments}
432: -- ----------------------------------------------------------------------------
433: Procedure dt_update_validate
434: (p_vrbl_rt_prfl_id in number default hr_api.g_number,
435: p_oipl_id in number default hr_api.g_number,
436: p_datetrack_mode in varchar2,
437: p_validation_start_date in date,
438: p_validation_end_date in date) Is
439: --

Line 449: hr_api.mandatory_arg_error

445: hr_utility.set_location('Entering:'||l_proc, 5);
446: --
447: -- Ensure that the p_datetrack_mode argument is not null
448: --
449: hr_api.mandatory_arg_error
450: (p_api_name => l_proc,
451: p_argument => 'datetrack_mode',
452: p_argument_value => p_datetrack_mode);
453: --

Line 461: hr_api.mandatory_arg_error

457: --
458: --
459: -- Ensure the arguments are not null
460: --
461: hr_api.mandatory_arg_error
462: (p_api_name => l_proc,
463: p_argument => 'validation_start_date',
464: p_argument_value => p_validation_start_date);
465: --

Line 466: hr_api.mandatory_arg_error

462: (p_api_name => l_proc,
463: p_argument => 'validation_start_date',
464: p_argument_value => p_validation_start_date);
465: --
466: hr_api.mandatory_arg_error
467: (p_api_name => l_proc,
468: p_argument => 'validation_end_date',
469: p_argument_value => p_validation_end_date);
470: --

Line 471: If ((nvl(p_vrbl_rt_prfl_id, hr_api.g_number) <> hr_api.g_number) and

467: (p_api_name => l_proc,
468: p_argument => 'validation_end_date',
469: p_argument_value => p_validation_end_date);
470: --
471: If ((nvl(p_vrbl_rt_prfl_id, hr_api.g_number) <> hr_api.g_number) and
472: NOT (dt_api.check_min_max_dates
473: (p_base_table_name => 'ben_vrbl_rt_prfl_f',
474: p_base_key_column => 'vrbl_rt_prfl_id',
475: p_base_key_value => p_vrbl_rt_prfl_id,

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

477: p_to_date => p_validation_end_date))) Then
478: l_table_name := 'ben_vrbl_rt_prfl_f';
479: Raise l_integrity_error;
480: End If;
481: If ((nvl(p_oipl_id, hr_api.g_number) <> hr_api.g_number) and
482: NOT (dt_api.check_min_max_dates
483: (p_base_table_name => 'ben_oipl_f',
484: p_base_key_column => 'oipl_id',
485: p_base_key_value => p_oipl_id,

Line 563: hr_api.mandatory_arg_error

559: hr_utility.set_location('Entering:'||l_proc, 5);
560: --
561: -- Ensure that the p_datetrack_mode argument is not null
562: --
563: hr_api.mandatory_arg_error
564: (p_api_name => l_proc,
565: p_argument => 'datetrack_mode',
566: p_argument_value => p_datetrack_mode);
567: --

Line 577: hr_api.mandatory_arg_error

573: --
574: --
575: -- Ensure the arguments are not null
576: --
577: hr_api.mandatory_arg_error
578: (p_api_name => l_proc,
579: p_argument => 'validation_start_date',
580: p_argument_value => p_validation_start_date);
581: --

Line 582: hr_api.mandatory_arg_error

578: (p_api_name => l_proc,
579: p_argument => 'validation_start_date',
580: p_argument_value => p_validation_start_date);
581: --
582: hr_api.mandatory_arg_error
583: (p_api_name => l_proc,
584: p_argument => 'validation_end_date',
585: p_argument_value => p_validation_end_date);
586: --

Line 587: hr_api.mandatory_arg_error

583: (p_api_name => l_proc,
584: p_argument => 'validation_end_date',
585: p_argument_value => p_validation_end_date);
586: --
587: hr_api.mandatory_arg_error
588: (p_api_name => l_proc,
589: p_argument => 'enrld_anthr_oipl_rt_id',
590: p_argument_value => p_enrld_anthr_oipl_rt_id);
591: --

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

631: --
632: -- Call all supporting business operations
633: --
634: --
635: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
636: --
637: chk_enrld_anthr_oipl_rt_id
638: (p_enrld_anthr_oipl_rt_id => p_rec.enrld_anthr_oipl_rt_id,
639: p_effective_date => p_effective_date,

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

690: --
691: -- Call all supporting business operations
692: --
693: --
694: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
695: --
696: chk_enrld_anthr_oipl_rt_id
697: (p_enrld_anthr_oipl_rt_id => p_rec.enrld_anthr_oipl_rt_id,
698: p_effective_date => p_effective_date,

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

794: hr_utility.set_location('Entering:'|| l_proc, 10);
795: --
796: -- Ensure that all the mandatory parameter are not null
797: --
798: hr_api.mandatory_arg_error(p_api_name => l_proc,
799: p_argument => 'enrld_anthr_oipl_rt_id',
800: p_argument_value => p_enrld_anthr_oipl_rt_id);
801: --
802: open csr_leg_code;