50: p_hrs_wkd_in_perd_rt_id => p_hrs_wkd_in_perd_rt_id,
51: p_object_version_number => p_object_version_number);
52: --
53: if (l_api_updating
54: and nvl(p_hrs_wkd_in_perd_rt_id,hr_api.g_number)
55: <> ben_hwr_shd.g_old_rec.hrs_wkd_in_perd_rt_id) then
56: --
57: -- raise error as PK has changed
58: --
125: p_effective_date => p_effective_date,
126: p_object_version_number => p_object_version_number);
127: --
128: if (l_api_updating
129: and nvl(p_hrs_wkd_in_perd_fctr_id,hr_api.g_number)
130: <> nvl(ben_hwr_shd.g_old_rec.hrs_wkd_in_perd_fctr_id,hr_api.g_number)
131: or not l_api_updating) and
132: p_hrs_wkd_in_perd_fctr_id is not null then
133: --
126: p_object_version_number => p_object_version_number);
127: --
128: if (l_api_updating
129: and nvl(p_hrs_wkd_in_perd_fctr_id,hr_api.g_number)
130: <> nvl(ben_hwr_shd.g_old_rec.hrs_wkd_in_perd_fctr_id,hr_api.g_number)
131: or not l_api_updating) and
132: p_hrs_wkd_in_perd_fctr_id is not null then
133: --
134: -- check if hrs_wkd_in_perd_fctr_id value exists in ben_hrs_wkd_in_perd_fctr table
203: select null
204: from ben_hrs_wkd_in_perd_rt_f
205: where hrs_wkd_in_perd_fctr_id = p_hrs_wkd_in_perd_fctr_id
206: and vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
207: and hrs_wkd_in_perd_rt_id <> nvl(p_hrs_wkd_in_perd_rt_id,hr_api.g_number)
208: and business_group_id + 0 = p_business_group_id
209: and p_validation_start_date <= effective_end_date
210: and p_validation_end_date >= effective_start_date;
211: --
218: p_effective_date => p_effective_date,
219: p_object_version_number => p_object_version_number);
220: --
221: if (l_api_updating
222: and p_hrs_wkd_in_perd_fctr_id <> nvl(ben_hwr_shd.g_old_rec.hrs_wkd_in_perd_fctr_id,hr_api.g_number)
223: or not l_api_updating) then
224:
225: open c_dup;
226: fetch c_dup into l_exists;
351: p_object_version_number => p_object_version_number);
352: --
353: if (l_api_updating
354: and p_excld_flag
355: <> nvl(ben_hwr_shd.g_old_rec.excld_flag,hr_api.g_varchar2)
356: or not l_api_updating) then
357: --
358: -- check if value of lookup falls within lookup type.
359: --
357: --
358: -- check if value of lookup falls within lookup type.
359: --
360: --
361: if hr_api.not_exists_in_hr_lookups
362: (p_lookup_type => 'YES_NO',
363: p_lookup_code => p_excld_flag,
364: p_effective_date => p_effective_date) then
365: --
459: --
460: -- {End Of Comments}
461: -- ----------------------------------------------------------------------------
462: Procedure dt_update_validate
463: (p_vrbl_rt_prfl_id in number default hr_api.g_number,
464: p_datetrack_mode in varchar2,
465: p_validation_start_date in date,
466: p_validation_end_date in date) Is
467: --
473: hr_utility.set_location('Entering:'||l_proc, 5);
474: --
475: -- Ensure that the p_datetrack_mode argument is not null
476: --
477: hr_api.mandatory_arg_error
478: (p_api_name => l_proc,
479: p_argument => 'datetrack_mode',
480: p_argument_value => p_datetrack_mode);
481: --
485: --
486: --
487: -- Ensure the arguments are not null
488: --
489: hr_api.mandatory_arg_error
490: (p_api_name => l_proc,
491: p_argument => 'validation_start_date',
492: p_argument_value => p_validation_start_date);
493: --
490: (p_api_name => l_proc,
491: p_argument => 'validation_start_date',
492: p_argument_value => p_validation_start_date);
493: --
494: hr_api.mandatory_arg_error
495: (p_api_name => l_proc,
496: p_argument => 'validation_end_date',
497: p_argument_value => p_validation_end_date);
498: --
495: (p_api_name => l_proc,
496: p_argument => 'validation_end_date',
497: p_argument_value => p_validation_end_date);
498: --
499: If ((nvl(p_vrbl_rt_prfl_id, hr_api.g_number) <> hr_api.g_number) and
500: NOT (dt_api.check_min_max_dates
501: (p_base_table_name => 'ben_vrbl_rt_prfl_f',
502: p_base_key_column => 'vrbl_rt_prfl_id',
503: p_base_key_value => p_vrbl_rt_prfl_id,
578: hr_utility.set_location('Entering:'||l_proc, 5);
579: --
580: -- Ensure that the p_datetrack_mode argument is not null
581: --
582: hr_api.mandatory_arg_error
583: (p_api_name => l_proc,
584: p_argument => 'datetrack_mode',
585: p_argument_value => p_datetrack_mode);
586: --
592: --
593: --
594: -- Ensure the arguments are not null
595: --
596: hr_api.mandatory_arg_error
597: (p_api_name => l_proc,
598: p_argument => 'validation_start_date',
599: p_argument_value => p_validation_start_date);
600: --
597: (p_api_name => l_proc,
598: p_argument => 'validation_start_date',
599: p_argument_value => p_validation_start_date);
600: --
601: hr_api.mandatory_arg_error
602: (p_api_name => l_proc,
603: p_argument => 'validation_end_date',
604: p_argument_value => p_validation_end_date);
605: --
602: (p_api_name => l_proc,
603: p_argument => 'validation_end_date',
604: p_argument_value => p_validation_end_date);
605: --
606: hr_api.mandatory_arg_error
607: (p_api_name => l_proc,
608: p_argument => 'hrs_wkd_in_perd_rt_id',
609: p_argument_value => p_hrs_wkd_in_perd_rt_id);
610: --
650: --
651: -- Call all supporting business operations
652: --
653: --
654: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
655: --
656: chk_hrs_wkd_in_perd_rt_id
657: (p_hrs_wkd_in_perd_rt_id => p_rec.hrs_wkd_in_perd_rt_id,
658: p_effective_date => p_effective_date,
712: --
713: -- Call all supporting business operations
714: --
715: --
716: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
717: --
718: chk_hrs_wkd_in_perd_rt_id
719: (p_hrs_wkd_in_perd_rt_id => p_rec.hrs_wkd_in_perd_rt_id,
720: p_effective_date => p_effective_date,
818: hr_utility.set_location('Entering:'|| l_proc, 10);
819: --
820: -- Ensure that all the mandatory parameter are not null
821: --
822: hr_api.mandatory_arg_error(p_api_name => l_proc,
823: p_argument => 'hrs_wkd_in_perd_rt_id',
824: p_argument_value => p_hrs_wkd_in_perd_rt_id);
825: --
826: open csr_leg_code;