[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
grade_id
,language
,source_lang
,name
from per_grades_tl
where grade_id = p_grade_id
and language = p_language;
select
grade_id
,language
,source_lang
,name
from per_grades_tl
where grade_id = p_grade_id
and language = p_language
for update nowait;
select gdt.grade_id
, gd.id_flex_num
, gd.grade_definition_id
, gdt.created_by
, gdt.creation_date
, gdt.last_updated_by
, gdt.last_update_date
, gdt.last_update_login
, l.language_code
, gdt.source_lang
, l.nls_language
, gdt.name
from per_grades grd
, per_grade_definitions gd
, per_grades_tl gdt
, fnd_languages l
where grd.grade_definition_id = gd.grade_definition_id
and grd.grade_id = gdt.grade_id
and gdt.language = userenv('LANG')
and l.installed_flag in ('I', 'B')
and not exists (select null
from per_grades_tl t
where t.grade_id = gdt.grade_id
and t.language = l.language_code)
order by l.language_code;
delete from PER_GRADES_TL T
where not exists
(select NULL
from PER_GRADES B
where B.GRADE_ID = T.GRADE_ID
);
insert into per_grades_tl (
grade_id
, name
, created_by
, creation_date
, last_updated_by
, last_update_date
, last_update_login
, language
, source_lang)
values (l_grades_tl.grade_id
, nvl(fnd_flex_ext.get_segs( g_app_code
, g_flex_code
, l_grades_tl.id_flex_num
, l_grades_tl.grade_definition_id
)
, l_grades_tl.name
)
, l_grades_tl.created_by
, l_grades_tl.creation_date
, l_grades_tl.last_updated_by
, l_grades_tl.last_update_date
, l_grades_tl.last_update_login
, l_grades_tl.language_code
, l_grades_tl.source_lang);