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_MRS_UPGRADE dependencies on DBMS_LOB

Line 403: ,dbms_lob.substr(irs.posting_url) posting_url

399: --
400: cursor csr_rec_sites is
401: select irs.recruiting_site_id recruiting_site_id
402: ,irs.site_name site_name
403: ,dbms_lob.substr(irs.posting_url) posting_url
404: ,dbms_lob.substr(irs.redirection_url) redirection_url
405: from irc_all_recruiting_sites irs
406: where not exists (select null
407: from irc_all_recruiting_sites_tl itl

Line 404: ,dbms_lob.substr(irs.redirection_url) redirection_url

400: cursor csr_rec_sites is
401: select irs.recruiting_site_id recruiting_site_id
402: ,irs.site_name site_name
403: ,dbms_lob.substr(irs.posting_url) posting_url
404: ,dbms_lob.substr(irs.redirection_url) redirection_url
405: from irc_all_recruiting_sites irs
406: where not exists (select null
407: from irc_all_recruiting_sites_tl itl
408: where itl.recruiting_site_id = irs.recruiting_site_id)