[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
job_id
,language
,source_lang
,name
from per_jobs_tl
where job_id = p_job_id
and language = p_language;
select
job_id
,language
,source_lang
,name
from per_jobs_tl
where job_id = p_job_id
and language = p_language
for update nowait;
select jbt.job_id
, jb.id_flex_num
, jb.job_definition_id
, jbt.created_by
, jbt.creation_date
, jbt.last_updated_by
, jbt.last_update_date
, jbt.last_update_login
, l.language_code
, jbt.source_lang
, l.nls_language
, jbt.name
from per_jobs job
, per_job_definitions jb
, per_jobs_tl jbt
, fnd_languages l
where job.job_definition_id = jb.job_definition_id
and job.job_id = jbt.job_id
and jbt.language = userenv('LANG')
and l.installed_flag in ('I', 'B')
and not exists (select null
from per_jobs_tl t
where t.job_id = jbt.job_id
and t.language = l.language_code)
order by l.language_code;
delete from PER_JOBS_TL T
where not exists
(select NULL
from PER_JOBS B
where B.JOB_ID = T.JOB_ID
);
insert into per_jobs_tl (
job_id
, name
, created_by
, creation_date
, last_updated_by
, last_update_date
, last_update_login
, language
, source_lang)
values (l_jobs_tl.job_id
, nvl(fnd_flex_ext.get_segs( g_app_code
, g_flex_code
, l_jobs_tl.id_flex_num
, l_jobs_tl.job_definition_id
)
, l_jobs_tl.name
)
, l_jobs_tl.created_by
, l_jobs_tl.creation_date
, l_jobs_tl.last_updated_by
, l_jobs_tl.last_update_date
, l_jobs_tl.last_update_login
, l_jobs_tl.language_code
, l_jobs_tl.source_lang);