The following lines contain the word 'select', 'insert', 'update' or 'delete':
select hpe.rowid
from hr_pattern_exceptions hpe
where upper(hpe.exception_name) = upper(p_exception_name);
select h.rowid
from hr_lookups h
where h.lookup_type = 'EXCEPTION_CATEGORY'
and h.lookup_code = p_exception_category;
select bit1.time_unit_multiplier tum,
bit1.base_time_unit btu,
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 tum,
bit2.base_time_unit btu,
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;
Procedure insert_validate(p_rec in out hr_pae_shd.g_rec_type) is
--
l_proc varchar2(72) := g_package||'insert_validate';
End insert_validate;
Procedure update_validate(p_rec in out hr_pae_shd.g_rec_type) is
--
l_proc varchar2(72) := g_package||'update_validate';
End update_validate;
Procedure delete_validate(p_rec in hr_pae_shd.g_rec_type) is
--
l_proc varchar2(72) := g_package||'delete_validate';
End delete_validate;