APPS.BEN_ELR_BUS dependencies on HR_API

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

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

Line 124: <> nvl(ben_elr_shd.g_old_rec.excld_flag,hr_api.g_varchar2)

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

Line 130: if hr_api.not_exists_in_hr_lookups

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

Line 202: and nvl(p_absence_attendance_type_id,hr_api.g_number)

198: p_effective_date => p_effective_date,
199: p_object_version_number => p_object_version_number);
200: --
201: if (l_api_updating
202: and nvl(p_absence_attendance_type_id,hr_api.g_number)
203: <> nvl(ben_elr_shd.g_old_rec.absence_attendance_type_id,hr_api.g_number)
204: or not l_api_updating)
205: and p_absence_attendance_type_id is not null then
206: --

Line 203: <> nvl(ben_elr_shd.g_old_rec.absence_attendance_type_id,hr_api.g_number)

199: p_object_version_number => p_object_version_number);
200: --
201: if (l_api_updating
202: and nvl(p_absence_attendance_type_id,hr_api.g_number)
203: <> nvl(ben_elr_shd.g_old_rec.absence_attendance_type_id,hr_api.g_number)
204: or not l_api_updating)
205: and p_absence_attendance_type_id is not null then
206: --
207: -- check if absence_attendance_type_id value exists in

Line 283: and nvl(p_abs_attendance_reason_id,hr_api.g_number)

279: p_effective_date => p_effective_date,
280: p_object_version_number => p_object_version_number);
281: --
282: if (l_api_updating
283: and nvl(p_abs_attendance_reason_id,hr_api.g_number)
284: <> nvl(ben_elr_shd.g_old_rec.abs_attendance_reason_id,hr_api.g_number)
285: or not l_api_updating)
286: and p_abs_attendance_reason_id is not null then
287: --

Line 284: <> nvl(ben_elr_shd.g_old_rec.abs_attendance_reason_id,hr_api.g_number)

280: p_object_version_number => p_object_version_number);
281: --
282: if (l_api_updating
283: and nvl(p_abs_attendance_reason_id,hr_api.g_number)
284: <> nvl(ben_elr_shd.g_old_rec.abs_attendance_reason_id,hr_api.g_number)
285: or not l_api_updating)
286: and p_abs_attendance_reason_id is not null then
287: --
288: -- check if abs_attendance_reason_id value exists in

Line 360: and elr.elig_loa_rsn_prte_id <> nvl(p_elig_loa_rsn_prte_id,hr_api.g_number)

356: from ben_elig_loa_rsn_prte_f elr
357: where nvl(elr.absence_attendance_type_id,-1) = nvl(p_absence_attendance_type_id, -1)
358: and nvl(elr.abs_attendance_reason_id,-1) = nvl(p_abs_attendance_reason_id,-1)
359: and elr.eligy_prfl_id = p_eligy_prfl_id
360: and elr.elig_loa_rsn_prte_id <> nvl(p_elig_loa_rsn_prte_id,hr_api.g_number)
361: and elr.business_group_id = p_business_group_id
362: and p_validation_start_date <= elr.effective_end_date
363: and p_validation_end_date >= elr.effective_start_date;
364:

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

475: --
476: -- {End Of Comments}
477: -- ----------------------------------------------------------------------------
478: Procedure dt_update_validate
479: (p_eligy_prfl_id in number default hr_api.g_number,
480: p_datetrack_mode in varchar2,
481: p_validation_start_date in date,
482: p_validation_end_date in date) Is
483: --

Line 493: hr_api.mandatory_arg_error

489: hr_utility.set_location('Entering:'||l_proc, 5);
490: --
491: -- Ensure that the p_datetrack_mode argument is not null
492: --
493: hr_api.mandatory_arg_error
494: (p_api_name => l_proc,
495: p_argument => 'datetrack_mode',
496: p_argument_value => p_datetrack_mode);
497: --

Line 505: hr_api.mandatory_arg_error

501: --
502: --
503: -- Ensure the arguments are not null
504: --
505: hr_api.mandatory_arg_error
506: (p_api_name => l_proc,
507: p_argument => 'validation_start_date',
508: p_argument_value => p_validation_start_date);
509: --

Line 510: hr_api.mandatory_arg_error

506: (p_api_name => l_proc,
507: p_argument => 'validation_start_date',
508: p_argument_value => p_validation_start_date);
509: --
510: hr_api.mandatory_arg_error
511: (p_api_name => l_proc,
512: p_argument => 'validation_end_date',
513: p_argument_value => p_validation_end_date);
514: --

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

511: (p_api_name => l_proc,
512: p_argument => 'validation_end_date',
513: p_argument_value => p_validation_end_date);
514: --
515: If ((nvl(p_eligy_prfl_id, hr_api.g_number) <> hr_api.g_number) and
516: NOT (dt_api.check_min_max_dates
517: (p_base_table_name => 'ben_eligy_prfl_f',
518: p_base_key_column => 'eligy_prfl_id',
519: p_base_key_value => p_eligy_prfl_id,

Line 598: hr_api.mandatory_arg_error

594: hr_utility.set_location('Entering:'||l_proc, 5);
595: --
596: -- Ensure that the p_datetrack_mode argument is not null
597: --
598: hr_api.mandatory_arg_error
599: (p_api_name => l_proc,
600: p_argument => 'datetrack_mode',
601: p_argument_value => p_datetrack_mode);
602: --

Line 612: hr_api.mandatory_arg_error

608: --
609: --
610: -- Ensure the arguments are not null
611: --
612: hr_api.mandatory_arg_error
613: (p_api_name => l_proc,
614: p_argument => 'validation_start_date',
615: p_argument_value => p_validation_start_date);
616: --

Line 617: hr_api.mandatory_arg_error

613: (p_api_name => l_proc,
614: p_argument => 'validation_start_date',
615: p_argument_value => p_validation_start_date);
616: --
617: hr_api.mandatory_arg_error
618: (p_api_name => l_proc,
619: p_argument => 'validation_end_date',
620: p_argument_value => p_validation_end_date);
621: --

Line 622: hr_api.mandatory_arg_error

618: (p_api_name => l_proc,
619: p_argument => 'validation_end_date',
620: p_argument_value => p_validation_end_date);
621: --
622: hr_api.mandatory_arg_error
623: (p_api_name => l_proc,
624: p_argument => 'elig_loa_rsn_prte_id',
625: p_argument_value => p_elig_loa_rsn_prte_id);
626: --

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

666: --
667: -- Call all supporting business operations
668: --
669: --
670: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
671: --
672: chk_elig_loa_rsn_prte_id
673: (p_elig_loa_rsn_prte_id => p_rec.elig_loa_rsn_prte_id,
674: p_effective_date => p_effective_date,

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

729: --
730: -- Call all supporting business operations
731: --
732: --
733: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
734: --
735: chk_elig_loa_rsn_prte_id
736: (p_elig_loa_rsn_prte_id => p_rec.elig_loa_rsn_prte_id,
737: p_effective_date => p_effective_date,

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

837: hr_utility.set_location('Entering:'|| l_proc, 10);
838: --
839: -- Ensure that all the mandatory parameter are not null
840: --
841: hr_api.mandatory_arg_error(p_api_name => l_proc,
842: p_argument => 'elig_loa_rsn_prte_id',
843: p_argument_value => p_elig_loa_rsn_prte_id);
844: --
845: open csr_leg_code;