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.EDR_PSIG_RULE dependencies on EDR_REDLINE_TRANS_DATA

Line 116: insert into EDR_REDLINE_TRANS_DATA (EVENT_ID,PRE_XML_DATA,POST_XML_DATA,ERR_CODE,ERR_MSG,DIFF_XML,APPENDIX_GEN_XML) values (p_event_id,L_XML_DOCUMENT,empty_clob(), retcode, errmsg, empty_clob(),empty_clob());

112: i_ret_code => retcode,
113: i_errbuf => errmsg,
114: i_log_file => logfile
115: );
116: insert into EDR_REDLINE_TRANS_DATA (EVENT_ID,PRE_XML_DATA,POST_XML_DATA,ERR_CODE,ERR_MSG,DIFF_XML,APPENDIX_GEN_XML) values (p_event_id,L_XML_DOCUMENT,empty_clob(), retcode, errmsg, empty_clob(),empty_clob());
117: commit;
118: return true;
119: exception
120: when others then

Line 875: select DIFF_XML into x_output from EDR_REDLINE_TRANS_DATA where EVENT_ID = p_edr_event_id ;

871:
872: dbms_lob.createtemporary(X_DIFF_XML,TRUE);
873: dbms_lob.open( X_DIFF_XML, dbms_lob.lob_readwrite );
874:
875: select DIFF_XML into x_output from EDR_REDLINE_TRANS_DATA where EVENT_ID = p_edr_event_id ;
876:
877: l_clob_len := dbms_lob.getlength(x_output);
878: WHILE l_pos < l_clob_len LOOP
879: dbms_lob.read(x_output, l_amount, l_pos, vBuffer);

Line 2622: select DIFF_XML into L_XML_DOCUMENT from EDR_REDLINE_TRANS_DATA where EVENT_ID = l_edr_event_id ;

2618: --Bug 3761813 : start
2619: --Bug 4306292: Start
2620: --Commenting changes made for red lining.
2621: if (l_style_sheet_type = 'XSL' and nvl(l_redline_required,'N') = 'Y' ) then
2622: select DIFF_XML into L_XML_DOCUMENT from EDR_REDLINE_TRANS_DATA where EVENT_ID = l_edr_event_id ;
2623: -- Bug 5167207 : start
2624: --Set the XML document to CLOB datatype of the event
2625: P_EVENT.setEventData(L_XML_DOCUMENT);
2626: -- Bug 5167207 : end