The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
application_id
,item_class_id
,item_id_query
,item_class_order_number
,item_class_par_mode
,item_class_sublist_mode
,start_date
,end_date
,object_version_number
from ame_item_class_usages
where item_class_id = p_item_class_id
and application_id = p_application_id
and p_effective_date
between start_date and nvl(end_date - (1/86400),p_effective_date);
update ame_item_class_usages t
set t.end_date = p_new_effective_end_date
,t.last_updated_by = l_current_user_id
,t.last_update_date = p_new_effective_end_date
,t.last_update_login = l_current_user_id
,t.object_version_number = l_object_version_number
where t.item_class_id = p_item_class_id
and t.application_id = p_application_id
and p_effective_date between t.start_date
and nvl(t.end_date - (1/86400),sysdate);
select
application_id
,item_class_id
,item_id_query
,item_class_order_number
,item_class_par_mode
,item_class_sublist_mode
,start_date
,end_date
,object_version_number
from ame_item_class_usages
where item_class_id = p_item_class_id
and application_id = p_application_id
and p_effective_date
between start_date and nvl(end_date - (1/86400), sysdate)
for update nowait;
If (p_datetrack_mode <> hr_api.g_insert) then
--
-- We must select and lock the current row.
--
Open C_Sel1;
if (p_datetrack_mode = hr_api.g_update) then
p_validation_start_date := p_effective_date;
elsif (p_datetrack_mode = hr_api.g_delete) then
p_validation_start_date := p_effective_date;
select nvl(max(t.object_version_number),0) + 1
into l_ovn
from ame_item_class_usages t
where t.item_class_id = p_item_class_id
and t.application_id = p_application_id;
select count(*)
from
ame_attribute_usages attru,
ame_attributes attr
where attru.attribute_id = attr.attribute_id
and attru.application_id = p_application_id
and attr.item_class_id = p_item_class_id
and p_start_date BETWEEN attru.start_date
and nvl(attru.end_date -(1/86400),p_start_date)
and p_start_date BETWEEN attr.start_date
and nvl(attr.end_date - (1/86400),p_start_date);
select count(*)
from
ame_rule_usages rlu,
ame_rules rl
where rlu.rule_id = rl.rule_id
and rlu.item_id = p_application_id
and rl.item_class_id = p_item_class_id
and ((p_start_date between rl.start_date and nvl(rl.end_date - ame_util.oneSecond, p_start_date)) or
(p_start_date < rl.start_date and rl.start_date < nvl(rl.end_date,rl.start_date + ame_util.oneSecond)))
and ((p_start_date between rlu.start_date and nvl(rlu.end_date - ame_util.oneSecond, p_start_date)) or
(p_start_date < rlu.start_date and rlu.start_date < nvl(rlu.end_date,rlu.start_date + ame_util.oneSecond)));