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: --
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: ;
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: --
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: --
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: --
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: --
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: --
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: --
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: --
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,
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: --
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: --
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: --
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: --
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,
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,
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;