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.

APPS.IRC_IRT_SHD dependencies on DBMS_LOB

Line 100: := dbms_lob.substr(irc_irt_shd.g_old_rec.redirection_url_c);

96: End If;
97: Close C_Sel1;
98: --
99: irc_irt_shd.g_old_rec.redirection_url
100: := dbms_lob.substr(irc_irt_shd.g_old_rec.redirection_url_c);
101: irc_irt_shd.g_old_rec.posting_url
102: := dbms_lob.substr(irc_irt_shd.g_old_rec.posting_url_c);
103: l_fct_ret := true;
104: End If;

Line 102: := dbms_lob.substr(irc_irt_shd.g_old_rec.posting_url_c);

98: --
99: irc_irt_shd.g_old_rec.redirection_url
100: := dbms_lob.substr(irc_irt_shd.g_old_rec.redirection_url_c);
101: irc_irt_shd.g_old_rec.posting_url
102: := dbms_lob.substr(irc_irt_shd.g_old_rec.posting_url_c);
103: l_fct_ret := true;
104: End If;
105: End If;
106: Return (l_fct_ret);

Line 165: := dbms_lob.substr(irc_irt_shd.g_old_rec.redirection_url_c);

161: End If;
162: Close C_Sel1;
163: --
164: irc_irt_shd.g_old_rec.redirection_url
165: := dbms_lob.substr(irc_irt_shd.g_old_rec.redirection_url_c);
166: irc_irt_shd.g_old_rec.posting_url
167: := dbms_lob.substr(irc_irt_shd.g_old_rec.posting_url_c);
168: --
169: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 167: := dbms_lob.substr(irc_irt_shd.g_old_rec.posting_url_c);

163: --
164: irc_irt_shd.g_old_rec.redirection_url
165: := dbms_lob.substr(irc_irt_shd.g_old_rec.redirection_url_c);
166: irc_irt_shd.g_old_rec.posting_url
167: := dbms_lob.substr(irc_irt_shd.g_old_rec.posting_url_c);
168: --
169: hr_utility.set_location(' Leaving:'||l_proc, 10);
170: --
171: -- We need to trap the ORA LOCK exception

Line 218: or dbms_lob.compare(SUBB.REDIRECTION_URL,SUBT.REDIRECTION_URL) <> 0

214: from IRC_ALL_RECRUITING_SITES_TL SUBB, IRC_ALL_RECRUITING_SITES_TL SUBT
215: where SUBB.RECRUITING_SITE_ID = SUBT.RECRUITING_SITE_ID
216: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
217: and (SUBB.SITE_NAME <> SUBT.SITE_NAME
218: or dbms_lob.compare(SUBB.REDIRECTION_URL,SUBT.REDIRECTION_URL) <> 0
219: or (SUBB.REDIRECTION_URL is null and SUBT.REDIRECTION_URL is not null)
220: or (SUBB.REDIRECTION_URL is not null and SUBT.REDIRECTION_URL is null)
221: or dbms_lob.compare(SUBB.POSTING_URL,SUBT.POSTING_URL) <> 0
222: or (SUBB.POSTING_URL is null and SUBT.POSTING_URL is not null)

Line 221: or dbms_lob.compare(SUBB.POSTING_URL,SUBT.POSTING_URL) <> 0

217: and (SUBB.SITE_NAME <> SUBT.SITE_NAME
218: or dbms_lob.compare(SUBB.REDIRECTION_URL,SUBT.REDIRECTION_URL) <> 0
219: or (SUBB.REDIRECTION_URL is null and SUBT.REDIRECTION_URL is not null)
220: or (SUBB.REDIRECTION_URL is not null and SUBT.REDIRECTION_URL is null)
221: or dbms_lob.compare(SUBB.POSTING_URL,SUBT.POSTING_URL) <> 0
222: or (SUBB.POSTING_URL is null and SUBT.POSTING_URL is not null)
223: or (SUBB.POSTING_URL is not null and SUBT.POSTING_URL is null)
224: ));
225: