eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.IRC_RECRUITING_SITES_SWI dependencies on IRC_ALL_RECRUITING_SITES

Line 217: l_object_version_number irc_all_recruiting_sites.object_version_number%TYPE;

213: -- Variables for IN/OUT parameters
214: --
215: -- Other variables
216: l_proc varchar2(72) := g_package ||'delete_recruiting_site';
217: l_object_version_number irc_all_recruiting_sites.object_version_number%TYPE;
218:
219: cursor get_object_version_number(p_recruiting_site_id irc_all_recruiting_sites.recruiting_site_id%TYPE) is
220: select object_version_number
221: from irc_all_recruiting_sites

Line 219: cursor get_object_version_number(p_recruiting_site_id irc_all_recruiting_sites.recruiting_site_id%TYPE) is

215: -- Other variables
216: l_proc varchar2(72) := g_package ||'delete_recruiting_site';
217: l_object_version_number irc_all_recruiting_sites.object_version_number%TYPE;
218:
219: cursor get_object_version_number(p_recruiting_site_id irc_all_recruiting_sites.recruiting_site_id%TYPE) is
220: select object_version_number
221: from irc_all_recruiting_sites
222: where recruiting_site_id = p_recruiting_site_id;
223: Begin

Line 221: from irc_all_recruiting_sites

217: l_object_version_number irc_all_recruiting_sites.object_version_number%TYPE;
218:
219: cursor get_object_version_number(p_recruiting_site_id irc_all_recruiting_sites.recruiting_site_id%TYPE) is
220: select object_version_number
221: from irc_all_recruiting_sites
222: where recruiting_site_id = p_recruiting_site_id;
223: Begin
224: hr_utility.set_location(' Entering:' || l_proc,10);
225: --