50: p_grade_rt_id => p_grade_rt_id,
51: p_object_version_number => p_object_version_number);
52: --
53: if (l_api_updating
54: and nvl(p_grade_rt_id,hr_api.g_number)
55: <> ben_grr_shd.g_old_rec.grade_rt_id) then
56: --
57: -- raise error as PK has changed
58: --
183: select null
184: from ben_grade_rt_f
185: where grade_id = p_grade_id
186: and vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
187: and grade_rt_id <> nvl(p_grade_rt_id,hr_api.g_number)
188: and business_group_id + 0 = p_business_group_id
189: and p_validation_start_date <= effective_end_date
190: and p_validation_end_date >= effective_start_date;
191: --
198: p_effective_date => p_effective_date,
199: p_object_version_number => p_object_version_number);
200: --
201: if (l_api_updating
202: and p_grade_id <> nvl(ben_grr_shd.g_old_rec.grade_id,hr_api.g_number)
203: or not l_api_updating) then
204:
205: open c_dup;
206: fetch c_dup into l_exists;
333: p_object_version_number => p_object_version_number);
334: --
335: if (l_api_updating
336: and p_excld_flag
337: <> nvl(ben_grr_shd.g_old_rec.excld_flag,hr_api.g_varchar2)
338: or not l_api_updating) then
339: --
340: -- check if value of lookup falls within lookup type.
341: --
339: --
340: -- check if value of lookup falls within lookup type.
341: --
342: --
343: if hr_api.not_exists_in_hr_lookups
344: (p_lookup_type => 'YES_NO',
345: p_lookup_code => p_excld_flag,
346: p_effective_date => p_effective_date) then
347: --
387: --
388: -- {End Of Comments}
389: -- ----------------------------------------------------------------------------
390: Procedure dt_update_validate
391: (p_vrbl_rt_prfl_id in number default hr_api.g_number,
392: p_datetrack_mode in varchar2,
393: p_validation_start_date in date,
394: p_validation_end_date in date) Is
395: --
401: hr_utility.set_location('Entering:'||l_proc, 5);
402: --
403: -- Ensure that the p_datetrack_mode argument is not null
404: --
405: hr_api.mandatory_arg_error
406: (p_api_name => l_proc,
407: p_argument => 'datetrack_mode',
408: p_argument_value => p_datetrack_mode);
409: --
413: --
414: --
415: -- Ensure the arguments are not null
416: --
417: hr_api.mandatory_arg_error
418: (p_api_name => l_proc,
419: p_argument => 'validation_start_date',
420: p_argument_value => p_validation_start_date);
421: --
418: (p_api_name => l_proc,
419: p_argument => 'validation_start_date',
420: p_argument_value => p_validation_start_date);
421: --
422: hr_api.mandatory_arg_error
423: (p_api_name => l_proc,
424: p_argument => 'validation_end_date',
425: p_argument_value => p_validation_end_date);
426: --
423: (p_api_name => l_proc,
424: p_argument => 'validation_end_date',
425: p_argument_value => p_validation_end_date);
426: --
427: If ((nvl(p_vrbl_rt_prfl_id, hr_api.g_number) <> hr_api.g_number) and
428: NOT (dt_api.check_min_max_dates
429: (p_base_table_name => 'ben_vrbl_rt_prfl_f',
430: p_base_key_column => 'vrbl_rt_prfl_id',
431: p_base_key_value => p_vrbl_rt_prfl_id,
506: hr_utility.set_location('Entering:'||l_proc, 5);
507: --
508: -- Ensure that the p_datetrack_mode argument is not null
509: --
510: hr_api.mandatory_arg_error
511: (p_api_name => l_proc,
512: p_argument => 'datetrack_mode',
513: p_argument_value => p_datetrack_mode);
514: --
520: --
521: --
522: -- Ensure the arguments are not null
523: --
524: hr_api.mandatory_arg_error
525: (p_api_name => l_proc,
526: p_argument => 'validation_start_date',
527: p_argument_value => p_validation_start_date);
528: --
525: (p_api_name => l_proc,
526: p_argument => 'validation_start_date',
527: p_argument_value => p_validation_start_date);
528: --
529: hr_api.mandatory_arg_error
530: (p_api_name => l_proc,
531: p_argument => 'validation_end_date',
532: p_argument_value => p_validation_end_date);
533: --
530: (p_api_name => l_proc,
531: p_argument => 'validation_end_date',
532: p_argument_value => p_validation_end_date);
533: --
534: hr_api.mandatory_arg_error
535: (p_api_name => l_proc,
536: p_argument => 'grade_rt_id',
537: p_argument_value => p_grade_rt_id);
538: --
578: --
579: -- Call all supporting business operations
580: --
581: --
582: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
583: --
584: chk_grade_rt_id
585: (p_grade_rt_id => p_rec.grade_rt_id,
586: p_effective_date => p_effective_date,
634: --
635: -- Call all supporting business operations
636: --
637: --
638: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
639: --
640: chk_grade_rt_id
641: (p_grade_rt_id => p_rec.grade_rt_id,
642: p_effective_date => p_effective_date,
734: hr_utility.set_location('Entering:'|| l_proc, 10);
735: --
736: -- Ensure that all the mandatory parameter are not null
737: --
738: hr_api.mandatory_arg_error(p_api_name => l_proc,
739: p_argument => 'grade_rt_id',
740: p_argument_value => p_grade_rt_id);
741: --
742: open csr_leg_code;