APPS.CE_CEPURGE_XMLP_PKG dependencies on CE_ARCH_LINES

Line 219: CE_ARCH_LINES;

215: COUNT(*)
216: INTO
217: COUNT_LINES
218: FROM
219: CE_ARCH_LINES;
220: SELECT
221: COUNT(*)
222: INTO
223: COUNT_RECONS

Line 300: DELETE FROM CE_ARCH_LINES;

296: IF (COUNT_HEADERS > 0) THEN
297: DELETE FROM CE_ARCH_HEADERS;
298: END IF;
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 (

Line 733: INSERT INTO CE_ARCH_LINES

729: WHERE LBG.ORGANIZATION_ID = SR.ORG_ID
730: OR SR.LEGAL_ENTITY_ID = LBG.ORGANIZATION_ID ) );
731: C_ARCHIVE_STAT_HEADERS := SQL%ROWCOUNT;
732: END IF;
733: INSERT INTO CE_ARCH_LINES
734: (STATEMENT_LINE_ID
735: ,STATEMENT_HEADER_ID
736: ,LINE_NUMBER
737: ,TRX_DATE

Line 873: CE_ARCH_LINES );

869: WHERE STATEMENT_LINE_ID IN (
870: SELECT
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

Line 895: CE_ARCH_LINES );

891: WHERE STATEMENT_LINE_ID IN (
892: SELECT
893: STATEMENT_LINE_ID
894: FROM
895: CE_ARCH_LINES );
896: C_ARCHIVE_STAT_ERRORS := SQL%ROWCOUNT;
897: END IF;
898: OPEN C_PURGE_HEADERS;
899: FETCH C_PURGE_HEADERS