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

Line 323: from irc_documents

319: cursor csr_doc is
320: select binary_doc,
321: mime_type,
322: file_name
323: from irc_documents
324: where document_id = p_document_id;
325: begin
326: p_document_id := document_id;
327: open csr_doc;

Line 347: from irc_documents

343: l_intw_status varchar2(100);
344: l_intw_id number;
345: cursor chkResumeExts(c_person_id in number ) is
346: select count(*)
347: from irc_documents
348: where type = 'RESUME'
349: and party_id =
350: (select party_id
351: from per_all_people_f

Line 357: from irc_documents

353: and trunc(sysdate) between effective_start_date and effective_end_Date)
354: and end_date is null;
355: cursor getDocIdList(c_personIdIn in number,c_doc_type in varchar2) is
356: select document_id
357: from irc_documents
358: where type = c_doc_type
359: and party_id =
360: (select party_id
361: from per_all_people_f