The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
layout_id
,display_layout_name
,language
,source_lang
from hxc_layouts_tl
where layout_id = p_layout_id
AND language = p_language;
select
layout_id
,display_layout_name
,language
,source_lang
from hxc_layouts_tl
WHERE layout_id = p_layout_id
AND language = p_language
for update nowait;
delete from hxc_layouts_tl t
where not exists
(select null
from hxc_layouts b
where b.layout_id = t.layout_id
);
update hxc_layouts_tl t
set (display_layout_name) =
(select b.display_layout_name
from hxc_layouts_tl b
where b.layout_id = t.layout_id
and b.language = t.source_lang)
where (t.layout_id
,t.language)
in (select subt.layout_id
,subt.language
from hxc_layouts_tl subb
,hxc_layouts_tl subt
where subb.layout_id = subt.layout_id
and subb.language = subt.source_lang
and subb.display_layout_name <> subt.display_layout_name
);
insert into hxc_layouts_tl
(layout_id
,display_layout_name
,language
,source_lang
,last_update_date
,last_updated_by
,last_update_login
,created_by
,creation_date
)
select b.layout_id
,b.display_layout_name
,l.language_code
,b.source_lang
,b.last_update_date
,b.last_updated_by
,b.last_update_login
,b.created_by
,b.creation_date
from hxc_layouts_tl b
,fnd_languages l
where l.installed_flag in ('I', 'B')
and b.language = userenv('LANG')
and not exists
(select null
from hxc_layouts_tl t
where t.layout_id = b.layout_id
and t.language = l.language_code
);