[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
approver_type_id
,orig_system
,query_variable_1_label
,query_variable_2_label
,query_variable_3_label
,query_variable_4_label
,query_variable_5_label
,variable_1_lov_query
,variable_2_lov_query
,variable_3_lov_query
,variable_4_lov_query
,variable_5_lov_query
,query_procedure
,start_date
,end_date
,object_version_number
from ame_approver_types
where approver_type_id = p_approver_type_id
and p_effective_date between start_date
and nvl(end_date - (1/86400),p_effective_date);
update ame_approver_types 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.approver_type_id = p_approver_type_id
and p_effective_date between t.start_date
and nvl(t.end_date - (1/86400),sysdate);
select
approver_type_id
,orig_system
,query_variable_1_label
,query_variable_2_label
,query_variable_3_label
,query_variable_4_label
,query_variable_5_label
,variable_1_lov_query
,variable_2_lov_query
,variable_3_lov_query
,variable_4_lov_query
,variable_5_lov_query
,query_procedure
,start_date
,end_date
,object_version_number
from ame_approver_types
where approver_type_id = p_approver_type_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_approver_types t
where t.approver_type_id = p_approver_type_id;