APPS.BEN_EES_BUS dependencies on HR_API

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

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

Line 171: and elig_ee_stat_prte_id <> nvl(p_elig_ee_stat_prte_id,hr_api.g_number)

167: select null
168: from ben_elig_ee_stat_prte_f
169: where assignment_status_type_id = p_assignment_status_type_id
170: and eligy_prfl_id = p_eligy_prfl_id
171: and elig_ee_stat_prte_id <> nvl(p_elig_ee_stat_prte_id,hr_api.g_number)
172: and business_group_id + 0 = p_business_group_id
173: and p_validation_start_date <= effective_end_date
174: and p_validation_end_date >= effective_start_date
175: ;

Line 189: <> nvl(ben_ees_shd.g_old_rec.assignment_status_type_id,hr_api.g_number)

185: p_object_version_number => p_object_version_number);
186: --
187: if (l_api_updating
188: and p_assignment_status_type_id
189: <> nvl(ben_ees_shd.g_old_rec.assignment_status_type_id,hr_api.g_number)
190: or not l_api_updating) then
191: --
192: -- check if assignment_status_type_id value exists in per_assignment_status_types table
193: --

Line 293: <> nvl(ben_ees_shd.g_old_rec.excld_flag,hr_api.g_varchar2)

289: p_object_version_number => p_object_version_number);
290: --
291: if (l_api_updating
292: and p_excld_flag
293: <> nvl(ben_ees_shd.g_old_rec.excld_flag,hr_api.g_varchar2)
294: or not l_api_updating) then
295: --
296: -- check if value of lookup falls within lookup type.
297: --

Line 299: if hr_api.not_exists_in_hr_lookups

295: --
296: -- check if value of lookup falls within lookup type.
297: --
298: --
299: if hr_api.not_exists_in_hr_lookups
300: (p_lookup_type => 'YES_NO',
301: p_lookup_code => p_excld_flag,
302: p_effective_date => p_effective_date) then
303: --

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

401: --
402: -- {End Of Comments}
403: -- ----------------------------------------------------------------------------
404: Procedure dt_update_validate
405: (p_eligy_prfl_id in number default hr_api.g_number,
406: p_datetrack_mode in varchar2,
407: p_validation_start_date in date,
408: p_validation_end_date in date) Is
409: --

Line 419: hr_api.mandatory_arg_error

415: hr_utility.set_location('Entering:'||l_proc, 5);
416: --
417: -- Ensure that the p_datetrack_mode argument is not null
418: --
419: hr_api.mandatory_arg_error
420: (p_api_name => l_proc,
421: p_argument => 'datetrack_mode',
422: p_argument_value => p_datetrack_mode);
423: --

Line 431: hr_api.mandatory_arg_error

427: --
428: --
429: -- Ensure the arguments are not null
430: --
431: hr_api.mandatory_arg_error
432: (p_api_name => l_proc,
433: p_argument => 'validation_start_date',
434: p_argument_value => p_validation_start_date);
435: --

Line 436: hr_api.mandatory_arg_error

432: (p_api_name => l_proc,
433: p_argument => 'validation_start_date',
434: p_argument_value => p_validation_start_date);
435: --
436: hr_api.mandatory_arg_error
437: (p_api_name => l_proc,
438: p_argument => 'validation_end_date',
439: p_argument_value => p_validation_end_date);
440: --

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

437: (p_api_name => l_proc,
438: p_argument => 'validation_end_date',
439: p_argument_value => p_validation_end_date);
440: --
441: If ((nvl(p_eligy_prfl_id, hr_api.g_number) <> hr_api.g_number) and
442: NOT (dt_api.check_min_max_dates
443: (p_base_table_name => 'ben_eligy_prfl_f',
444: p_base_key_column => 'eligy_prfl_id',
445: p_base_key_value => p_eligy_prfl_id,

Line 524: hr_api.mandatory_arg_error

520: hr_utility.set_location('Entering:'||l_proc, 5);
521: --
522: -- Ensure that the p_datetrack_mode argument is not null
523: --
524: hr_api.mandatory_arg_error
525: (p_api_name => l_proc,
526: p_argument => 'datetrack_mode',
527: p_argument_value => p_datetrack_mode);
528: --

Line 538: hr_api.mandatory_arg_error

534: --
535: --
536: -- Ensure the arguments are not null
537: --
538: hr_api.mandatory_arg_error
539: (p_api_name => l_proc,
540: p_argument => 'validation_start_date',
541: p_argument_value => p_validation_start_date);
542: --

Line 543: hr_api.mandatory_arg_error

539: (p_api_name => l_proc,
540: p_argument => 'validation_start_date',
541: p_argument_value => p_validation_start_date);
542: --
543: hr_api.mandatory_arg_error
544: (p_api_name => l_proc,
545: p_argument => 'validation_end_date',
546: p_argument_value => p_validation_end_date);
547: --

Line 548: hr_api.mandatory_arg_error

544: (p_api_name => l_proc,
545: p_argument => 'validation_end_date',
546: p_argument_value => p_validation_end_date);
547: --
548: hr_api.mandatory_arg_error
549: (p_api_name => l_proc,
550: p_argument => 'elig_ee_stat_prte_id',
551: p_argument_value => p_elig_ee_stat_prte_id);
552: --

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

591: --
592: -- Call all supporting business operations
593: --
594: --
595: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
596: --
597: chk_elig_ee_stat_prte_id
598: (p_elig_ee_stat_prte_id => p_rec.elig_ee_stat_prte_id,
599: p_effective_date => p_effective_date,

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

642: --
643: -- Call all supporting business operations
644: --
645: --
646: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
647: --
648: chk_elig_ee_stat_prte_id
649: (p_elig_ee_stat_prte_id => p_rec.elig_ee_stat_prte_id,
650: p_effective_date => p_effective_date,

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

737: hr_utility.set_location('Entering:'|| l_proc, 10);
738: --
739: -- Ensure that all the mandatory parameter are not null
740: --
741: hr_api.mandatory_arg_error(p_api_name => l_proc,
742: p_argument => 'elig_ee_stat_prte_id',
743: p_argument_value => p_elig_ee_stat_prte_id);
744: --
745: open csr_leg_code;