[Home] [Help]
138:
139: cursor c2 is
140: select '1'
141: from hr_pattern_constructions hpc1,
142: hr_pattern_exceptions hpe1
143: where hpc1.pattern_id = hpe1.pattern_id
144: and hpe1.exception_id = p_exception_id
145: and not ( hpc1.availability = 'QUALIFYING'
146: or hpc1.availability = 'NON QUALIFYING')
147: UNION ALL
148: select '1'
149: from hr_pattern_constructions hpc2,
150: hr_pattern_constructions hpc3,
151: hr_pattern_exceptions hpe2
152: where hpc2.component_pattern_id = hpc3.pattern_id
153: and hpc2.pattern_id = hpe2.pattern_id
154: and hpe2.exception_id = p_exception_id
155: and not ( hpc2.availability = 'QUALIFYING'
174: -- ------------------------------------------------------------------------
175: --
176: -- PUBLIC
177: -- Description:
178: -- Ensure that a valid exception_id from hr_pattern_exceptions is
179: -- entered.
180: -- SSP_specific Rules:
181: -- ------------------
182: -- If the Calendar_usage_id is not null and the calendar usage is for
225:
226: cursor c1 is
227: select exp.exception_start_time start_time,
228: exp.exception_end_time end_time
229: from hr_pattern_exceptions exp
230: where exp.exception_id = p_exception_id;
231:
232: c1_rec c1%ROWTYPE;
233:
233:
234: cursor c2 is
235: select '1'
236: from hr_exception_usages u,
237: hr_pattern_exceptions e
238: where u.calendar_id = p_calendar_id
239: and u.exception_id = e.exception_id
240: and e.exception_start_time <= c1_rec.end_time
241: and e.exception_end_time >= c1_rec.start_time
241: and e.exception_end_time >= c1_rec.start_time
242: UNION ALL
243: select '1'
244: from hr_exception_usages u,
245: hr_pattern_exceptions e
246: where u.calendar_usage_id = p_calendar_usage_id
247: and u.exception_id = e.exception_id
248: and e.exception_start_time <= c1_rec.end_time
249: and e.exception_end_time >= c1_rec.start_time;