DBA Data[Home] [Help]

APPS.IRC_IRT_INS dependencies on IRC_ALL_RECRUITING_SITES_TL

Line 67: -- Insert the row into: irc_all_recruiting_sites_tl

63: --
64: --
65: --
66: --
67: -- Insert the row into: irc_all_recruiting_sites_tl
68: --
69: insert into irc_all_recruiting_sites_tl
70: (recruiting_site_id
71: ,language

Line 69: insert into irc_all_recruiting_sites_tl

65: --
66: --
67: -- Insert the row into: irc_all_recruiting_sites_tl
68: --
69: insert into irc_all_recruiting_sites_tl
70: (recruiting_site_id
71: ,language
72: ,source_lang
73: ,site_name

Line 240: (p_module_name => 'IRC_ALL_RECRUITING_SITES_TL'

236: --
237: when hr_api.cannot_find_prog_unit then
238: --
239: hr_api.cannot_find_prog_unit_error
240: (p_module_name => 'IRC_ALL_RECRUITING_SITES_TL'
241: ,p_hook_type => 'AI');
242: --
243: end;
244: --

Line 359: from irc_all_recruiting_sites_tl irt

355: select l.language_code
356: from fnd_languages l
357: where l.installed_flag in ('I','B')
358: and not exists (select null
359: from irc_all_recruiting_sites_tl irt
360: where irt.recruiting_site_id = p_recruiting_site_id
361: and irt.language = l.language_code);
362: --
363: l_proc varchar2(72) := g_package || 'ins_tl';