50: p_elig_hrly_slrd_prte_id => p_elig_hrly_slrd_prte_id,
51: p_object_version_number => p_object_version_number);
52: --
53: if (l_api_updating
54: and nvl(p_elig_hrly_slrd_prte_id,hr_api.g_number)
55: <> ben_ehs_shd.g_old_rec.elig_hrly_slrd_prte_id) then
56: --
57: -- raise error as PK has changed
58: --
120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating
123: and p_excld_flag
124: <> nvl(ben_ehs_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: --
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: --
189: select null
190: from ben_elig_hrly_slrd_prte_f
191: where hrly_slrd_cd = p_hrly_slrd_cd
192: and eligy_prfl_id = p_eligy_prfl_id
193: and elig_hrly_slrd_prte_id <> nvl(p_elig_hrly_slrd_prte_id,hr_api.g_number)
194: and business_group_id + 0 = p_business_group_id
195: and p_validation_start_date <= effective_end_date
196: and p_validation_end_date >= effective_start_date
197: ;
206: p_object_version_number => p_object_version_number);
207: --
208: if (l_api_updating
209: and p_hrly_slrd_cd
210: <> nvl(ben_ehs_shd.g_old_rec.hrly_slrd_cd,hr_api.g_varchar2)
211: or not l_api_updating) then
212: --
213: -- check if value of lookup falls within lookup type.
214: --
212: --
213: -- check if value of lookup falls within lookup type.
214: --
215: --
216: if hr_api.not_exists_in_hr_lookups
217: (p_lookup_type => 'HOURLY_SALARIED_CODE',
218: p_lookup_code => p_hrly_slrd_cd,
219: p_effective_date => p_effective_date) then
220: --
333: --
334: -- {End Of Comments}
335: -- ----------------------------------------------------------------------------
336: Procedure dt_update_validate
337: (p_eligy_prfl_id in number default hr_api.g_number,
338: p_datetrack_mode in varchar2,
339: p_validation_start_date in date,
340: p_validation_end_date in date) Is
341: --
347: hr_utility.set_location('Entering:'||l_proc, 5);
348: --
349: -- Ensure that the p_datetrack_mode argument is not null
350: --
351: hr_api.mandatory_arg_error
352: (p_api_name => l_proc,
353: p_argument => 'datetrack_mode',
354: p_argument_value => p_datetrack_mode);
355: --
359: --
360: --
361: -- Ensure the arguments are not null
362: --
363: hr_api.mandatory_arg_error
364: (p_api_name => l_proc,
365: p_argument => 'validation_start_date',
366: p_argument_value => p_validation_start_date);
367: --
364: (p_api_name => l_proc,
365: p_argument => 'validation_start_date',
366: p_argument_value => p_validation_start_date);
367: --
368: hr_api.mandatory_arg_error
369: (p_api_name => l_proc,
370: p_argument => 'validation_end_date',
371: p_argument_value => p_validation_end_date);
372: --
369: (p_api_name => l_proc,
370: p_argument => 'validation_end_date',
371: p_argument_value => p_validation_end_date);
372: --
373: If ((nvl(p_eligy_prfl_id, hr_api.g_number) <> hr_api.g_number) and
374: NOT (dt_api.check_min_max_dates
375: (p_base_table_name => 'ben_eligy_prfl_f',
376: p_base_key_column => 'eligy_prfl_id',
377: p_base_key_value => p_eligy_prfl_id,
452: hr_utility.set_location('Entering:'||l_proc, 5);
453: --
454: -- Ensure that the p_datetrack_mode argument is not null
455: --
456: hr_api.mandatory_arg_error
457: (p_api_name => l_proc,
458: p_argument => 'datetrack_mode',
459: p_argument_value => p_datetrack_mode);
460: --
466: --
467: --
468: -- Ensure the arguments are not null
469: --
470: hr_api.mandatory_arg_error
471: (p_api_name => l_proc,
472: p_argument => 'validation_start_date',
473: p_argument_value => p_validation_start_date);
474: --
471: (p_api_name => l_proc,
472: p_argument => 'validation_start_date',
473: p_argument_value => p_validation_start_date);
474: --
475: hr_api.mandatory_arg_error
476: (p_api_name => l_proc,
477: p_argument => 'validation_end_date',
478: p_argument_value => p_validation_end_date);
479: --
476: (p_api_name => l_proc,
477: p_argument => 'validation_end_date',
478: p_argument_value => p_validation_end_date);
479: --
480: hr_api.mandatory_arg_error
481: (p_api_name => l_proc,
482: p_argument => 'elig_hrly_slrd_prte_id',
483: p_argument_value => p_elig_hrly_slrd_prte_id);
484: --
523: --
524: -- Call all supporting business operations
525: --
526: --
527: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
528: --
529: chk_elig_hrly_slrd_prte_id
530: (p_elig_hrly_slrd_prte_id => p_rec.elig_hrly_slrd_prte_id,
531: p_effective_date => p_effective_date,
573: --
574: -- Call all supporting business operations
575: --
576: --
577: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
578: --
579: chk_elig_hrly_slrd_prte_id
580: (p_elig_hrly_slrd_prte_id => p_rec.elig_hrly_slrd_prte_id,
581: p_effective_date => p_effective_date,
668: hr_utility.set_location('Entering:'|| l_proc, 10);
669: --
670: -- Ensure that all the mandatory parameter are not null
671: --
672: hr_api.mandatory_arg_error(p_api_name => l_proc,
673: p_argument => 'elig_hrly_slrd_prte_id',
674: p_argument_value => p_elig_hrly_slrd_prte_id);
675: --
676: open csr_leg_code;