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_INTRA_LINES

Line 270: CE_ARCH_INTRA_LINES;

266: COUNT(*)
267: INTO
268: COUNT_INTRA_LINES
269: FROM
270: CE_ARCH_INTRA_LINES;
271: END IF;
272: IF (P_OBJECTS in ('BOTH','INTERFACE')) THEN
273: SELECT
274: COUNT(*)

Line 338: DELETE FROM CE_ARCH_INTRA_LINES;

334: IF (COUNT_INTRA_HEADERS > 0) THEN
335: DELETE FROM CE_ARCH_INTRA_HEADERS;
336: END IF;
337: IF (COUNT_INTRA_LINES > 0) THEN
338: DELETE FROM CE_ARCH_INTRA_LINES;
339: END IF;
340: IF (COUNT_INTRA_INT_LINES > 0) THEN
341: DELETE FROM CE_ARCH_INTERFACE_LINES
342: WHERE BANK_ACCOUNT_NUM || '-' || STATEMENT_NUMBER IN (

Line 1547: INSERT INTO CE_ARCH_INTRA_LINES

1543: AND TRUNC(CSH.STATEMENT_DATE) <= NVL(P_STATEMENT_DATE_TO1
1544: ,TRUNC(CSH.STATEMENT_DATE));
1545: C_ARCHIVE_STAT_HEADERS2 := SQL%ROWCOUNT;
1546: END IF;
1547: INSERT INTO CE_ARCH_INTRA_LINES
1548: (STATEMENT_LINE_ID
1549: ,STATEMENT_HEADER_ID
1550: ,LINE_NUMBER
1551: ,TRX_DATE