The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
rule_id
,action_id
,start_date
,end_date
,object_version_number
from ame_action_usages
where action_id = p_action_id
and rule_id = p_rule_id
and ( p_effective_date
between start_date and nvl(end_date - ame_util.oneSecond,p_effective_date)
or
(p_effective_date < start_date and
start_date < nvl(end_date,start_date + ame_util.oneSecond)));
update ame_action_usages t
set t.end_date = p_new_end_date
,t.last_updated_by = l_current_user_id
,t.last_update_date = p_new_end_date
,t.last_update_login = l_current_user_id
, t.object_version_number = l_object_version_number
where t.action_id = p_action_id
and t.rule_id = p_rule_id
and ( p_effective_date
between t.start_date and nvl(t.end_date - ame_util.oneSecond,p_effective_date)
or
(p_effective_date < t.start_date and
t.start_date < nvl(t.end_date,t.start_date + ame_util.oneSecond)));
select
rule_id
,action_id
,start_date
,end_date
,object_version_number
from ame_action_usages
where action_id = p_action_id
and rule_id = p_rule_id
and ( p_effective_date
between start_date and nvl(end_date - ame_util.oneSecond,p_effective_date)
or
(p_effective_date < start_date and
start_date < nvl(end_date,start_date + ame_util.oneSecond)))
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 null
into l_dummy
from ame_actions
where action_id = p_action_id
and p_effective_date between start_date and
nvl(end_date - ame_util.oneSecond, p_effective_date)
for update of end_date nowait;
/*select null
into l_dummy
from ame_rules
where rule_id = p_rule_id and
((p_effective_date between start_date and
nvl(end_date - ame_util.oneSecond, p_effective_date)) or
(p_effective_date < start_date and
start_date < nvl(end_date,start_date + ame_util.oneSecond)))
for update of end_date nowait;*/
select nvl(max(t.object_version_number),0) + 1
into l_ovn
from ame_action_usages t
where t.action_id = p_action_id
and t.rule_id = p_rule_id;