61: --
62: --
63: --
64: --
65: -- Insert the row into: irc_default_postings_tl
66: --
67: insert into irc_default_postings_tl
68: (default_posting_id
69: ,language
63: --
64: --
65: -- Insert the row into: irc_default_postings_tl
66: --
67: insert into irc_default_postings_tl
68: (default_posting_id
69: ,language
70: ,source_language
71: ,org_name
247: --
248: when hr_api.cannot_find_prog_unit then
249: --
250: hr_api.cannot_find_prog_unit_error
251: (p_module_name => 'IRC_DEFAULT_POSTINGS_TL'
252: ,p_hook_type => 'AI');
253: --
254: end;
255: --
380: select l.language_code
381: from fnd_languages l
382: where l.installed_flag in ('I','B')
383: and not exists (select null
384: from irc_default_postings_tl idt
385: where idt.default_posting_id = p_default_posting_id
386: and idt.language = l.language_code);
387: --
388: l_proc varchar2(72) := g_package || 'ins_tl';