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 507: from irc_documents

503: cursor csr_doc is
504: select binary_doc,
505: mime_type,
506: file_name
507: from irc_documents
508: where document_id = p_document_id;
509: begin
510: p_document_id := document_id;
511: open csr_doc;

Line 532: from irc_documents

528: l_intw_status varchar2(100);
529: l_intw_id number;
530: cursor chkResumeExts(c_person_id in number ) is
531: select count(*)
532: from irc_documents
533: where type = 'RESUME'
534: and party_id =
535: (select party_id
536: from per_all_people_f

Line 542: from irc_documents

538: and trunc(sysdate) between effective_start_date and effective_end_Date)
539: and end_date is null;
540: cursor getDocIdList(c_personIdIn in number,c_doc_type in varchar2) is
541: select document_id
542: from irc_documents
543: where type = c_doc_type
544: and party_id =
545: (select party_id
546: from per_all_people_f