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.CE_CEPURGE_XMLP_PKG dependencies on CE_ARCH_RECON_ERRORS

Line 231: CE_ARCH_RECON_ERRORS;

227: COUNT(*)
228: INTO
229: COUNT_ERRORS
230: FROM
231: CE_ARCH_RECON_ERRORS;
232: END IF;
233: IF (P_OBJECTS in ('BOTH','INTERFACE')) THEN
234: SELECT
235: COUNT(*)

Line 317: DELETE FROM CE_ARCH_RECON_ERRORS;

313: CE_SECURITY_PROFILES_GT )
314: OR REFERENCE_TYPE in ( 'JE_LINE' , 'ROI_LINE' , 'STATEMENT' );
315: END IF;
316: IF (COUNT_ERRORS > 0) THEN
317: DELETE FROM CE_ARCH_RECON_ERRORS;
318: END IF;
319: IF (COUNT_INT_LINES > 0) THEN
320: DELETE FROM CE_ARCH_INTERFACE_LINES
321: WHERE BANK_ACCOUNT_NUM || '-' || STATEMENT_NUMBER IN (

Line 875: INSERT INTO CE_ARCH_RECON_ERRORS

871: STATEMENT_LINE_ID
872: FROM
873: CE_ARCH_LINES );
874: C_ARCHIVE_STAT_REC := SQL%ROWCOUNT;
875: INSERT INTO CE_ARCH_RECON_ERRORS
876: (STATEMENT_LINE_ID
877: ,MESSAGE_NAME
878: ,CREATION_DATE
879: ,CREATED_BY