APPS.IRC_IRT_DEL dependencies on IRC_ALL_RECRUITING_SITES_TL

Line 62: -- Delete the irc_all_recruiting_sites_tl row.

58: hr_utility.set_location('Entering:'||l_proc, 5);
59: --
60: --
61: --
62: -- Delete the irc_all_recruiting_sites_tl row.
63: --
64: delete from irc_all_recruiting_sites_tl
65: where recruiting_site_id = p_rec.recruiting_site_id
66: and language = p_rec.language;

Line 64: delete from irc_all_recruiting_sites_tl

60: --
61: --
62: -- Delete the irc_all_recruiting_sites_tl row.
63: --
64: delete from irc_all_recruiting_sites_tl
65: where recruiting_site_id = p_rec.recruiting_site_id
66: and language = p_rec.language;
67: --
68: --

Line 185: (p_module_name => 'IRC_ALL_RECRUITING_SITES_TL'

181: --
182: when hr_api.cannot_find_prog_unit then
183: --
184: hr_api.cannot_find_prog_unit_error
185: (p_module_name => 'IRC_ALL_RECRUITING_SITES_TL'
186: ,p_hook_type => 'AD');
187: --
188: end;
189: --

Line 280: from irc_all_recruiting_sites_tl irt

276: -- Cursor to obtain all the translation rows.
277: --
278: cursor csr_del_langs is
279: select irt.language
280: from irc_all_recruiting_sites_tl irt
281: where irt.recruiting_site_id = p_recruiting_site_id;
282: --
283: l_proc varchar2(72) := g_package||'del_tl';
284: --