The following lines contain the word 'select', 'insert', 'update' or 'delete':
select 1
from hr_calendars
where upper(calendar_name) = upper (p_calendar_name)
and (p_calendar_id is null or calendar_id <> p_calendar_id);
select count (*)
from hr_pattern_constructions
where pattern_id = p_pattern_id;
select bit1.time_unit_multiplier,
bit1.base_time_unit,
con1.sequence_no,
0
from hr_pattern_constructions CON1,
hr_pattern_bits BIT1
where bit1.pattern_bit_id = con1.pattern_bit_id
and con1.pattern_id = p_pattern_id
union all
select bit2.time_unit_multiplier,
bit2.base_time_unit,
con2.sequence_no,
con3.sequence_no
from hr_pattern_bits BIT2,
hr_pattern_constructions CON2,
hr_pattern_constructions CON3
where bit2.pattern_bit_id = con3.pattern_bit_id
and con2.component_pattern_id = con3.pattern_id
and con2.pattern_id = p_pattern_id
order by 3,4;
select *
from hr_patterns
where pattern_id = p_pattern_id;
Procedure insert_validate(p_rec in hr_cal_shd.g_rec_type) is
--
l_proc varchar2(72) := g_package||'insert_validate';
End insert_validate;
Procedure update_validate(p_rec in hr_cal_shd.g_rec_type) is
--
l_proc varchar2(72) := g_package||'update_validate';
End update_validate;
Procedure delete_validate(p_rec in hr_cal_shd.g_rec_type) is
--
l_proc varchar2(72) := g_package||'delete_validate';
End delete_validate;