The following lines contain the word 'select', 'insert', 'update' or 'delete':
select c.rowid
from hr_calendars c
where c.calendar_id = p_calendar_id;
select u.rowid
from hr_calendar_usages u
where u.calendar_usage_id = p_calendar_usage_id;
select '1'
from hr_calendar_usages hcu,
hr_calendars hc,
hr_patterns hp,
hr_pattern_purposes hpp
where hcu.calendar_usage_id = p_calendar_usage_id
and hcu.calendar_id = hc.calendar_id
and hc.pattern_id = hp.pattern_id
and hp.pattern_id = hpp.pattern_id
and hpp.pattern_purpose = 'SSP';
select '1'
from hr_pattern_constructions hpc1,
hr_pattern_exceptions hpe1
where hpc1.pattern_id = hpe1.pattern_id
and hpe1.exception_id = p_exception_id
and not ( hpc1.availability = 'QUALIFYING'
or hpc1.availability = 'NON QUALIFYING')
UNION ALL
select '1'
from hr_pattern_constructions hpc2,
hr_pattern_constructions hpc3,
hr_pattern_exceptions hpe2
where hpc2.component_pattern_id = hpc3.pattern_id
and hpc2.pattern_id = hpe2.pattern_id
and hpe2.exception_id = p_exception_id
and not ( hpc2.availability = 'QUALIFYING'
or hpc2.availability = 'NON QUALIFYING');
select exp.exception_start_time start_time,
exp.exception_end_time end_time
from hr_pattern_exceptions exp
where exp.exception_id = p_exception_id;
select '1'
from hr_exception_usages u,
hr_pattern_exceptions e
where u.calendar_id = p_calendar_id
and u.exception_id = e.exception_id
and e.exception_start_time <= c1_rec.end_time
and e.exception_end_time >= c1_rec.start_time
UNION ALL
select '1'
from hr_exception_usages u,
hr_pattern_exceptions e
where u.calendar_usage_id = p_calendar_usage_id
and u.exception_id = e.exception_id
and e.exception_start_time <= c1_rec.end_time
and e.exception_end_time >= c1_rec.start_time;
Procedure insert_validate(p_rec in hr_exu_shd.g_rec_type) is
--
l_proc varchar2(72) := g_package||'insert_validate';
End insert_validate;
Procedure update_validate(p_rec in hr_exu_shd.g_rec_type) is
--
l_proc varchar2(72) := g_package||'update_validate';
End update_validate;
Procedure delete_validate(p_rec in hr_exu_shd.g_rec_type) is
--
l_proc varchar2(72) := g_package||'delete_validate';
End delete_validate;