[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
position_id
,language
,source_lang
,name
from hr_all_positions_f_tl
where position_id = p_position_id
and language = p_language;
select
position_id
,language
,source_lang
,name
from hr_all_positions_f_tl
where position_id = p_position_id
and language = p_language
for update nowait;
select psf.position_id
, psd.id_flex_num
, psd.position_definition_id
, pft.created_by
, pft.creation_date
, pft.last_updated_by
, pft.last_update_date
, pft.last_update_login
, l.language_code
, pft.source_lang
, l.nls_language
, pft.name
from per_position_definitions psd
, hr_all_positions_f_tl pft
, hr_all_positions_f psf
, fnd_languages l
where psf.effective_end_date = hr_api.g_eot
and psd.position_definition_id = psf.position_definition_id
and psf.position_id = pft.position_id
and pft.language = userenv('LANG')
and l.installed_flag in ('I', 'B')
and not exists (select null
from hr_all_positions_f_tl pft2
where pft2.position_id = pft.position_id
and pft2.language = l.language_code)
order by l.language_code;
delete from HR_ALL_POSITIONS_F_TL T
where not exists
(select NULL
from HR_ALL_POSITIONS_F B
where B.POSITION_ID = T.POSITION_ID
);
insert into hr_all_positions_f_tl (
position_id
, name
, created_by
, creation_date
, last_updated_by
, last_update_date
, last_update_login
, language
, source_lang)
values (l_position_tl.position_id
, nvl(fnd_flex_ext.get_segs( g_app_code
, g_flex_code
, l_position_tl.id_flex_num
, l_position_tl.position_definition_id
)
, l_position_tl.name
)
, l_position_tl.created_by
, l_position_tl.creation_date
, l_position_tl.last_updated_by
, l_position_tl.last_update_date
, l_position_tl.last_update_login
, l_position_tl.language_code
, l_position_tl.source_lang);