The following lines contain the word 'select', 'insert', 'update' or 'delete':
select language_code,
nls_Language
from fnd_languages
where installed_flag in ('I', 'B');
delete from per_abs_attendance_types_tl t
where not exists
(select null
from per_absence_attendance_types b
where b.absence_attendance_type_id = t.absence_attendance_type_id
);
** For each installed language insert a new record into the TL table for
** each record in the range provided that is present in the base table.
*/
for c_language in csr_installed_languages loop
/*
** Set language for iteration....
*/
hr_kflex_utility.set_session_nls_language(c_language.nls_language);
** Insert the TL rows.
*/
insert into per_abs_attendance_types_tl(
absence_attendance_type_id,
language,
source_lang,
name,
created_by,
creation_date,
last_updated_by,
last_update_date,
last_update_login)
select b.absence_attendance_type_id,
l_current_language,
l_userenv_language_code,
b.name,
b.created_by,
b.creation_date,
b.last_updated_by,
b.last_update_date,
b.last_update_login
from per_absence_attendance_types b
where not exists (select '1'
from per_abs_attendance_types_tl tl
where tl.absence_attendance_type_id = b.absence_attendance_type_id
and tl.language = l_current_language);