APPS.CE_CEPURGE_XMLP_PKG dependencies on CE_ARCH_INTRA_HEADERS

Line 264: CE_ARCH_INTRA_HEADERS;

260: COUNT(*)
261: INTO
262: COUNT_INTRA_HEADERS
263: FROM
264: CE_ARCH_INTRA_HEADERS;
265: SELECT
266: COUNT(*)
267: INTO
268: COUNT_INTRA_LINES

Line 335: DELETE FROM CE_ARCH_INTRA_HEADERS;

331: WHERE NVL(INTRA_DAY_FLAG
332: ,'N') = 'N';
333: END IF;
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;

Line 1258: INSERT INTO CE_ARCH_INTRA_HEADERS

1254: IF (P_STATEMENT_TYPE in ('BOTH','INTRADAY')) THEN
1255: IF (P_OBJECTS in ('BOTH','STATEMENT')) THEN
1256: IF (P_OPTION in ('BOTH')) THEN
1257: IF (P_BANK_ACCOUNT IS NOT NULL) THEN
1258: INSERT INTO CE_ARCH_INTRA_HEADERS
1259: (STATEMENT_COMPLETE_FLAG
1260: ,DOC_SEQUENCE_ID
1261: ,DOC_SEQUENCE_VALUE
1262: ,STATEMENT_HEADER_ID

Line 1353: INSERT INTO CE_ARCH_INTRA_HEADERS

1349: AND TRUNC(CSH.STATEMENT_DATE) <= NVL(P_STATEMENT_DATE_TO1
1350: ,TRUNC(CSH.STATEMENT_DATE));
1351: C_ARCHIVE_STAT_HEADERS2 := SQL%ROWCOUNT;
1352: ELSIF (P_BANK_BRANCH IS NOT NULL) THEN
1353: INSERT INTO CE_ARCH_INTRA_HEADERS
1354: (STATEMENT_COMPLETE_FLAG
1355: ,DOC_SEQUENCE_ID
1356: ,DOC_SEQUENCE_VALUE
1357: ,STATEMENT_HEADER_ID

Line 1453: INSERT INTO CE_ARCH_INTRA_HEADERS

1449: AND TRUNC(CSH.STATEMENT_DATE) <= NVL(P_STATEMENT_DATE_TO1
1450: ,TRUNC(CSH.STATEMENT_DATE));
1451: C_ARCHIVE_STAT_HEADERS2 := SQL%ROWCOUNT;
1452: ELSE
1453: INSERT INTO CE_ARCH_INTRA_HEADERS
1454: (STATEMENT_COMPLETE_FLAG
1455: ,DOC_SEQUENCE_ID
1456: ,DOC_SEQUENCE_VALUE
1457: ,STATEMENT_HEADER_ID

Line 1637: CE_ARCH_INTRA_HEADERS );

1633: WHERE STATEMENT_HEADER_ID IN (
1634: SELECT
1635: STATEMENT_HEADER_ID
1636: FROM
1637: CE_ARCH_INTRA_HEADERS );
1638: C_ARCHIVE_STAT_LINES2 := SQL%ROWCOUNT;
1639: END IF;
1640: OPEN C_PURGE_INTRA_HEADERS;
1641: FETCH C_PURGE_INTRA_HEADERS