APPS.PER_SEC_PROFILE_ASG_API dependencies on HR_GENERAL

Line 168: AND p_start_date <= NVL(l_clashing_end_date, hr_general.end_of_time)

164: hr_utility.set_location('Entering ' || l_proc ,35);
165: IF l_clashing_id IS NOT NULL THEN
166: --
167: IF p_start_date >= l_clashing_start_date
168: AND p_start_date <= NVL(l_clashing_end_date, hr_general.end_of_time)
169: THEN
170: --
171: -- A previous record exists which has either not been end-dated, or has
172: -- an end-date of more than the start date of this record.

Line 198: ELSIF NVL(p_end_date, hr_general.end_of_time) >= l_clashing_start_date

194: ,p_start_date => l_clashing_start_date
195: ,p_end_date => p_start_date - 1
196: );
197: hr_utility.set_location('Entering ' || l_proc ,45);
198: ELSIF NVL(p_end_date, hr_general.end_of_time) >= l_clashing_start_date
199: AND NVL(p_end_date, hr_general.end_of_time) <= NVL(l_clashing_end_date, hr_general.end_of_time)
200: THEN
201: --
202: -- A future record exists with a start date of less than the old date

Line 199: AND NVL(p_end_date, hr_general.end_of_time) <= NVL(l_clashing_end_date, hr_general.end_of_time)

195: ,p_end_date => p_start_date - 1
196: );
197: hr_utility.set_location('Entering ' || l_proc ,45);
198: ELSIF NVL(p_end_date, hr_general.end_of_time) >= l_clashing_start_date
199: AND NVL(p_end_date, hr_general.end_of_time) <= NVL(l_clashing_end_date, hr_general.end_of_time)
200: THEN
201: --
202: -- A future record exists with a start date of less than the old date
203: -- (The id of the record is in l_id

Line 209: OR p_end_date + 1 >= NVL(l_clashing_end_date, hr_general.end_of_time)

205: -- Check if moving the end date of the earlier
206: -- record would break the start/end date constraint
207: --
208: IF p_end_date IS NULL
209: OR p_end_date + 1 >= NVL(l_clashing_end_date, hr_general.end_of_time)
210: THEN
211: hr_utility.set_message
212: (800
213: ,'PER_52550_ASP_END_DATE_ERR'