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_UTILITIES_PKG dependencies on IRC_DOCUMENTS

Line 2444: FROM irc_documents idoc3

2440: l_doc_id number;
2441: cursor c_doc_Id(c_person_id in number, c_assignment_id in number) is
2442: select nvl(
2443: (SELECT max (idoc3.document_id)
2444: FROM irc_documents idoc3
2445: WHERE idoc3.person_id = c_person_id
2446: AND idoc3.type IN ('RESUME','AUTO_RESUME')
2447: AND
2448: (

Line 2460: FROM irc_documents idoc3

2456:
2457: cursor c_doc_id_party(c_party_id in number,c_assignment_id in number) is
2458: select nvl(
2459: (SELECT max (idoc3.document_id)
2460: FROM irc_documents idoc3
2461: WHERE idoc3.party_id = c_party_id
2462: AND idoc3.type IN ('RESUME','AUTO_RESUME')
2463: AND
2464: (

Line 2493: select nvl((select file_name from irc_documents

2489: is
2490: l_doc_name varchar2(100);
2491: begin
2492:
2493: select nvl((select file_name from irc_documents
2494: where document_id=p_doc_id),-1) into l_doc_name from dual;
2495:
2496:
2497: return l_doc_name;