50: p_elig_dsblty_ctg_prte_id => p_elig_dsblty_ctg_prte_id,
51: p_object_version_number => p_object_version_number);
52: --
53: if (l_api_updating
54: and nvl(p_elig_dsblty_ctg_prte_id,hr_api.g_number)
55: <> ben_ect_shd.g_old_rec.elig_dsblty_ctg_prte_id) then
56: --
57: -- raise error as PK has changed
58: --
133: select null
134: from ben_elig_dsblty_ctg_prte_f
135: where category = p_category
136: and eligy_prfl_id = p_eligy_prfl_id
137: and elig_dsblty_ctg_prte_id <> nvl(p_elig_dsblty_ctg_prte_id,hr_api.g_number)
138: and business_group_id + 0 = p_business_group_id
139: and p_validation_start_date <= effective_end_date
140: and p_validation_end_date >= effective_start_date
141: ;
188: p_effective_date => p_effective_date,
189: p_object_version_number => p_object_version_number);
190: --
191: if (l_api_updating
192: and nvl(p_category,hr_api.g_number)
193: <> nvl(ben_ect_shd.g_old_rec.category,hr_api.g_number)
194: or not l_api_updating) then
195: --
196: -- check if category value exists in per_person_types table
189: p_object_version_number => p_object_version_number);
190: --
191: if (l_api_updating
192: and nvl(p_category,hr_api.g_number)
193: <> nvl(ben_ect_shd.g_old_rec.category,hr_api.g_number)
194: or not l_api_updating) then
195: --
196: -- check if category value exists in per_person_types table
197: --
305: p_object_version_number =>p_object_version_number);
306: --
307: if (l_api_updating
308: and p_category
309: <>nvl(ben_ect_shd.g_old_rec.category,hr_api.g_varchar2)
310: or not l_api_updating)
311: and p_category is not null then
312: --
313: open c1;
375: p_object_version_number => p_object_version_number);
376: --
377: if (l_api_updating
378: and p_excld_flag
379: <> nvl(ben_ect_shd.g_old_rec.excld_flag,hr_api.g_varchar2)
380: or not l_api_updating) then
381: --
382: -- check if value of lookup falls within lookup type.
383: --
381: --
382: -- check if value of lookup falls within lookup type.
383: --
384: --
385: if hr_api.not_exists_in_hr_lookups
386: (p_lookup_type => 'YES_NO',
387: p_lookup_code => p_excld_flag,
388: p_effective_date => p_effective_date) then
389: --
429: --
430: -- {End Of Comments}
431: -- ----------------------------------------------------------------------------
432: Procedure dt_update_validate
433: (p_eligy_prfl_id in number default hr_api.g_number,
434: p_datetrack_mode in varchar2,
435: p_validation_start_date in date,
436: p_validation_end_date in date) Is
437: --
443: hr_utility.set_location('Entering:'||l_proc, 5);
444: --
445: -- Ensure that the p_datetrack_mode argument is not null
446: --
447: hr_api.mandatory_arg_error
448: (p_api_name => l_proc,
449: p_argument => 'datetrack_mode',
450: p_argument_value => p_datetrack_mode);
451: --
455: --
456: --
457: -- Ensure the arguments are not null
458: --
459: hr_api.mandatory_arg_error
460: (p_api_name => l_proc,
461: p_argument => 'validation_start_date',
462: p_argument_value => p_validation_start_date);
463: --
460: (p_api_name => l_proc,
461: p_argument => 'validation_start_date',
462: p_argument_value => p_validation_start_date);
463: --
464: hr_api.mandatory_arg_error
465: (p_api_name => l_proc,
466: p_argument => 'validation_end_date',
467: p_argument_value => p_validation_end_date);
468: --
465: (p_api_name => l_proc,
466: p_argument => 'validation_end_date',
467: p_argument_value => p_validation_end_date);
468: --
469: If ((nvl(p_eligy_prfl_id, hr_api.g_number) <> hr_api.g_number) and
470: NOT (dt_api.check_min_max_dates
471: (p_base_table_name => 'ben_eligy_prfl_f',
472: p_base_key_column => 'eligy_prfl_id',
473: p_base_key_value => p_eligy_prfl_id,
549: hr_utility.set_location('Entering:'||l_proc, 5);
550: --
551: -- Ensure that the p_datetrack_mode argument is not null
552: --
553: hr_api.mandatory_arg_error
554: (p_api_name => l_proc,
555: p_argument => 'datetrack_mode',
556: p_argument_value => p_datetrack_mode);
557: --
563: --
564: --
565: -- Ensure the arguments are not null
566: --
567: hr_api.mandatory_arg_error
568: (p_api_name => l_proc,
569: p_argument => 'validation_start_date',
570: p_argument_value => p_validation_start_date);
571: --
568: (p_api_name => l_proc,
569: p_argument => 'validation_start_date',
570: p_argument_value => p_validation_start_date);
571: --
572: hr_api.mandatory_arg_error
573: (p_api_name => l_proc,
574: p_argument => 'validation_end_date',
575: p_argument_value => p_validation_end_date);
576: --
573: (p_api_name => l_proc,
574: p_argument => 'validation_end_date',
575: p_argument_value => p_validation_end_date);
576: --
577: hr_api.mandatory_arg_error
578: (p_api_name => l_proc,
579: p_argument => 'elig_dsblty_ctg_prte_id',
580: p_argument_value => p_elig_dsblty_ctg_prte_id);
581: --
621: --
622: -- Call all supporting business operations
623: --
624: --
625: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
626: --
627: chk_elig_dsblty_ctg_prte_id
628: (p_elig_dsblty_ctg_prte_id => p_rec.elig_dsblty_ctg_prte_id,
629: p_effective_date => p_effective_date,
673: --
674: -- Call all supporting business operations
675: --
676: --
677: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
678: --
679: chk_elig_dsblty_ctg_prte_id
680: (p_elig_dsblty_ctg_prte_id => p_rec.elig_dsblty_ctg_prte_id,
681: p_effective_date => p_effective_date,
769: hr_utility.set_location('Entering:'|| l_proc, 10);
770: --
771: -- Ensure that all the mandatory parameter are not null
772: --
773: hr_api.mandatory_arg_error(p_api_name => l_proc,
774: p_argument => 'elig_dsblty_ctg_prte_id',
775: p_argument_value => p_elig_dsblty_ctg_prte_id);
776: --
777: open csr_leg_code;