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_PURGE dependencies on CE_ARCH_INTRA_LINES

Line 349: delete FROM CE_ARCH_INTRA_LINES cal

345:
346: IF (G_STATEMENT_TYPE IN ('BOTH','INTRADAY')) THEN
347: IF (G_OBJECTS IN ('BOTH','STATEMENT')) THEN
348:
349: delete FROM CE_ARCH_INTRA_LINES cal
350: WHERE cal.statement_header_id IN (
351: SELECT cah.statement_header_id
352: FROM ce_intra_stmt_headers csh , CE_ARCH_INTRA_HEADERS cah
353: WHERE cah.statement_number = csh.statement_number

Line 501: DELETE FROM CE_ARCH_INTRA_LINES;

497: IF (G_OBJECTS IN ('BOTH','STATEMENT')) THEN
498:
499: DELETE FROM CE_ARCH_INTRA_HEADERS;
500:
501: DELETE FROM CE_ARCH_INTRA_LINES;
502:
503: END IF;
504:
505: IF (G_OBJECTS IN ('BOTH','INTERFACE')) THEN

Line 1623: INSERT INTO ce_arch_intra_lines

1619: G_Archive_Stat_Headers2 := SQL%ROWCOUNT;
1620:
1621: END IF;
1622:
1623: INSERT INTO ce_arch_intra_lines
1624: (STATEMENT_LINE_ID,
1625: STATEMENT_HEADER_ID,
1626: LINE_NUMBER,
1627: TRX_DATE,

Line 2747: FROM ce_arch_intra_lines

2743: CREATION_DATE,
2744: LAST_UPDATED_BY,
2745: LAST_UPDATE_DATE,
2746: RECONCILE_TO_STATEMENT_FLAG
2747: FROM ce_arch_intra_lines
2748: WHERE statement_header_id = r_intraStmt.statement_header_id;
2749:
2750: G_Archive_Stat_Lines2 := SQL%ROWCOUNT;
2751:

Line 2764: DELETE FROM ce_arch_intra_lines

2760: put_Element('INTRA_STMT_LINES',Nvl(G_Archive_Stat_Lines2,0));
2761: put_endtag('IntraStmtRestored');
2762:
2763: /* Delete Restored Lines */
2764: DELETE FROM ce_arch_intra_lines
2765: WHERE statement_header_id = r_intraStmt.statement_header_id;
2766:
2767: DELETE FROM ce_arch_intra_headers
2768: WHERE CURRENT OF C_Restore_Intra_Stmts;