APPS.BEN_CEP_BUS dependencies on HR_API

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

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

Line 124: <> nvl(ben_CEP_shd.g_old_rec.mndtry_flag,hr_api.g_varchar2)

120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating
123: and p_mndtry_flag
124: <> nvl(ben_CEP_shd.g_old_rec.mndtry_flag,hr_api.g_varchar2)
125: or not l_api_updating)
126: and p_mndtry_flag is not null then
127: --
128: -- check if value of lookup falls within lookup type.

Line 130: if hr_api.not_exists_in_hr_lookups

126: and p_mndtry_flag is not null then
127: --
128: -- check if value of lookup falls within lookup type.
129: --
130: if hr_api.not_exists_in_hr_lookups
131: (p_lookup_type => 'YES_NO',
132: p_lookup_code => p_mndtry_flag,
133: p_effective_date => p_effective_date) then
134: --

Line 200: <> nvl(ben_CEP_shd.g_old_rec.compute_score_flag,hr_api.g_varchar2)

196: p_object_version_number => p_object_version_number);
197: --
198: if (l_api_updating
199: and p_compute_score_flag
200: <> nvl(ben_CEP_shd.g_old_rec.compute_score_flag,hr_api.g_varchar2)
201: or not l_api_updating)
202: and p_compute_score_flag is not null then
203: --
204: -- check if value of lookup falls within lookup type.

Line 206: if hr_api.not_exists_in_hr_lookups

202: and p_compute_score_flag is not null then
203: --
204: -- check if value of lookup falls within lookup type.
205: --
206: if hr_api.not_exists_in_hr_lookups
207: (p_lookup_type => 'YES_NO',
208: p_lookup_code => p_compute_score_flag,
209: p_effective_date => p_effective_date) then
210: --

Line 273: and prtn_elig_prfl_id <> nvl(p_prtn_elig_prfl_id, hr_api.g_number)

269: select null
270: from ben_prtn_elig_prfl_f
271: where eligy_prfl_id = p_eligy_prfl_id
272: and prtn_elig_id = p_prtn_elig_id
273: and prtn_elig_prfl_id <> nvl(p_prtn_elig_prfl_id, hr_api.g_number)
274: and business_group_id + 0 = p_business_group_id
275: and p_validation_start_date <= effective_end_date
276: and p_validation_end_date >= effective_start_date
277: ;

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

286: p_effective_date => p_effective_date,
287: p_object_version_number => p_object_version_number);
288: --
289: if (l_api_updating
290: and nvl(p_eligy_prfl_id, hr_api.g_number)
291: <> nvl(ben_cep_shd.g_old_rec.eligy_prfl_id, hr_api.g_number)
292: or not l_api_updating) then
293: --
294: --

Line 291: <> nvl(ben_cep_shd.g_old_rec.eligy_prfl_id, hr_api.g_number)

287: p_object_version_number => p_object_version_number);
288: --
289: if (l_api_updating
290: and nvl(p_eligy_prfl_id, hr_api.g_number)
291: <> nvl(ben_cep_shd.g_old_rec.eligy_prfl_id, hr_api.g_number)
292: or not l_api_updating) then
293: --
294: --
295: open c1;

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

440: --
441: -- {End Of Comments}
442: -- ----------------------------------------------------------------------------
443: Procedure dt_update_validate
444: (p_eligy_prfl_id in number default hr_api.g_number,
445: p_prtn_elig_id in number default hr_api.g_number,
446: p_datetrack_mode in varchar2,
447: p_validation_start_date in date,
448: p_validation_end_date in date) Is

Line 445: p_prtn_elig_id in number default hr_api.g_number,

441: -- {End Of Comments}
442: -- ----------------------------------------------------------------------------
443: Procedure dt_update_validate
444: (p_eligy_prfl_id in number default hr_api.g_number,
445: p_prtn_elig_id in number default hr_api.g_number,
446: p_datetrack_mode in varchar2,
447: p_validation_start_date in date,
448: p_validation_end_date in date) Is
449: --

Line 459: hr_api.mandatory_arg_error

455: hr_utility.set_location('Entering:'||l_proc, 5);
456: --
457: -- Ensure that the p_datetrack_mode argument is not null
458: --
459: hr_api.mandatory_arg_error
460: (p_api_name => l_proc,
461: p_argument => 'datetrack_mode',
462: p_argument_value => p_datetrack_mode);
463: --

Line 471: hr_api.mandatory_arg_error

467: --
468: --
469: -- Ensure the arguments are not null
470: --
471: hr_api.mandatory_arg_error
472: (p_api_name => l_proc,
473: p_argument => 'validation_start_date',
474: p_argument_value => p_validation_start_date);
475: --

Line 476: hr_api.mandatory_arg_error

472: (p_api_name => l_proc,
473: p_argument => 'validation_start_date',
474: p_argument_value => p_validation_start_date);
475: --
476: hr_api.mandatory_arg_error
477: (p_api_name => l_proc,
478: p_argument => 'validation_end_date',
479: p_argument_value => p_validation_end_date);
480: --

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

477: (p_api_name => l_proc,
478: p_argument => 'validation_end_date',
479: p_argument_value => p_validation_end_date);
480: --
481: If ((nvl(p_eligy_prfl_id, hr_api.g_number) <> hr_api.g_number) and
482: NOT (dt_api.check_min_max_dates
483: (p_base_table_name => 'ben_eligy_prfl_f',
484: p_base_key_column => 'eligy_prfl_id',
485: p_base_key_value => p_eligy_prfl_id,

Line 491: If ((nvl(p_prtn_elig_id, hr_api.g_number) <> hr_api.g_number) and

487: p_to_date => p_validation_end_date))) Then
488: l_table_name := 'ben_eligy_prfl_f';
489: Raise l_integrity_error;
490: End If;
491: If ((nvl(p_prtn_elig_id, hr_api.g_number) <> hr_api.g_number) and
492: NOT (dt_api.check_min_max_dates
493: (p_base_table_name => 'ben_prtn_elig_f',
494: p_base_key_column => 'prtn_elig_id',
495: p_base_key_value => p_prtn_elig_id,

Line 575: hr_api.mandatory_arg_error

571: hr_utility.set_location('Entering:'||l_proc, 5);
572: --
573: -- Ensure that the p_datetrack_mode argument is not null
574: --
575: hr_api.mandatory_arg_error
576: (p_api_name => l_proc,
577: p_argument => 'datetrack_mode',
578: p_argument_value => p_datetrack_mode);
579: --

Line 589: hr_api.mandatory_arg_error

585: --
586: --
587: -- Ensure the arguments are not null
588: --
589: hr_api.mandatory_arg_error
590: (p_api_name => l_proc,
591: p_argument => 'validation_start_date',
592: p_argument_value => p_validation_start_date);
593: --

Line 594: hr_api.mandatory_arg_error

590: (p_api_name => l_proc,
591: p_argument => 'validation_start_date',
592: p_argument_value => p_validation_start_date);
593: --
594: hr_api.mandatory_arg_error
595: (p_api_name => l_proc,
596: p_argument => 'validation_end_date',
597: p_argument_value => p_validation_end_date);
598: --

Line 599: hr_api.mandatory_arg_error

595: (p_api_name => l_proc,
596: p_argument => 'validation_end_date',
597: p_argument_value => p_validation_end_date);
598: --
599: hr_api.mandatory_arg_error
600: (p_api_name => l_proc,
601: p_argument => 'prtn_elig_prfl_id',
602: p_argument_value => p_prtn_elig_prfl_id);
603: --

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

657: --
658: -- Call all supporting business operations
659: --
660: --
661: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
662: --
663: chk_prtn_elig_prfl_id
664: (p_prtn_elig_prfl_id => p_rec.prtn_elig_prfl_id,
665: p_effective_date => p_effective_date,

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

712: --
713: -- Call all supporting business operations
714: --
715: --
716: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
717: --
718: chk_prtn_elig_prfl_id
719: (p_prtn_elig_prfl_id => p_rec.prtn_elig_prfl_id,
720: p_effective_date => p_effective_date,

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

812: hr_utility.set_location('Entering:'|| l_proc, 10);
813: --
814: -- Ensure that all the mandatory parameter are not null
815: --
816: hr_api.mandatory_arg_error(p_api_name => l_proc,
817: p_argument => 'prtn_elig_prfl_id',
818: p_argument_value => p_prtn_elig_prfl_id);
819: --
820: open csr_leg_code;