61: --
62: --
63: --
64: --
65: -- Insert the row into: per_abs_attendance_types_tl
66: --
67: insert into per_abs_attendance_types_tl
68: (absence_attendance_type_id
69: ,name
63: --
64: --
65: -- Insert the row into: per_abs_attendance_types_tl
66: --
67: insert into per_abs_attendance_types_tl
68: (absence_attendance_type_id
69: ,name
70: ,language
71: ,source_lang
210: --
211: when hr_api.cannot_find_prog_unit then
212: --
213: hr_api.cannot_find_prog_unit_error
214: (p_module_name => 'PER_ABS_ATTENDANCE_TYPES_TL'
215: ,p_hook_type => 'AI');
216: --
217: end;
218: --
323: select l.language_code
324: from fnd_languages l
325: where l.installed_flag in ('I','B')
326: and not exists (select null
327: from per_abs_attendance_types_tl abt
328: where abt.absence_attendance_type_id = p_absence_attendance_type_id
329: and abt.language = l.language_code);
330: --
331: l_proc varchar2(72) := g_package || 'ins_tl';