221: COUNT(*)
222: INTO
223: COUNT_RECONS
224: FROM
225: CE_ARCH_RECONCILIATIONS;
226: SELECT
227: COUNT(*)
228: INTO
229: COUNT_ERRORS
299: IF (COUNT_LINES > 0) THEN
300: DELETE FROM CE_ARCH_LINES;
301: END IF;
302: IF (COUNT_RECONS > 0) THEN
303: DELETE FROM CE_ARCH_RECONCILIATIONS_ALL
304: WHERE ORG_ID in (
305: SELECT
306: ORG_ID
307: FROM
821: STATEMENT_HEADER_ID
822: FROM
823: CE_ARCH_HEADERS );
824: C_ARCHIVE_STAT_LINES := SQL%ROWCOUNT;
825: INSERT INTO CE_ARCH_RECONCILIATIONS_ALL
826: (STATEMENT_LINE_ID
827: ,REFERENCE_TYPE
828: ,REFERENCE_ID
829: ,JE_HEADER_ID