77: end if;
78: l_last_updated_by := l_current_user_id;
79: l_last_update_login := l_current_user_id;
80: --
81: -- Insert the row into: ame_calling_apps_tl
82: --
83: insert into ame_calling_apps_tl
84: (application_id
85: ,language
79: l_last_update_login := l_current_user_id;
80: --
81: -- Insert the row into: ame_calling_apps_tl
82: --
83: insert into ame_calling_apps_tl
84: (application_id
85: ,language
86: ,source_lang
87: ,application_name
236: --
237: when hr_api.cannot_find_prog_unit then
238: --
239: hr_api.cannot_find_prog_unit_error
240: (p_module_name => 'AME_CALLING_APPS_TL'
241: ,p_hook_type => 'AI');
242: --
243: end;
244: --
348: select l.language_code
349: from fnd_languages l
350: where l.installed_flag in ('I','B')
351: and not exists (select null
352: from ame_calling_apps_tl cal
353: where cal.application_id = p_application_id
354: and cal.language = l.language_code);
355: --
356: l_proc varchar2(72) := g_package || 'ins_tl';