DBA Data[Home] [Help]

APPS.CE_CEPURGE_XMLP_PKG dependencies on CE_ARCH_RECONCILIATIONS

Line 225: CE_ARCH_RECONCILIATIONS;

221: COUNT(*)
222: INTO
223: COUNT_RECONS
224: FROM
225: CE_ARCH_RECONCILIATIONS;
226: SELECT
227: COUNT(*)
228: INTO
229: COUNT_ERRORS

Line 303: DELETE FROM CE_ARCH_RECONCILIATIONS_ALL

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

Line 825: INSERT INTO CE_ARCH_RECONCILIATIONS_ALL

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