APPS.CE_CEPURGE_XMLP_PKG dependencies on CE_ARCH_INTERFACE_HEADERS

Line 239: CE_ARCH_INTERFACE_HEADERS

235: COUNT(*)
236: INTO
237: COUNT_INT_HEADERS
238: FROM
239: CE_ARCH_INTERFACE_HEADERS
240: WHERE NVL(INTRA_DAY_FLAG
241: ,'N') = 'N';
242: SELECT
243: COUNT(*)

Line 252: CE_ARCH_INTERFACE_HEADERS

248: WHERE BANK_ACCOUNT_NUM || '-' || STATEMENT_NUMBER IN (
249: SELECT
250: BANK_ACCOUNT_NUM || '-' || STATEMENT_NUMBER
251: FROM
252: CE_ARCH_INTERFACE_HEADERS
253: WHERE NVL(INTRA_DAY_FLAG
254: ,'N') = 'N' );
255: END IF;
256: END IF;

Line 278: CE_ARCH_INTERFACE_HEADERS

274: COUNT(*)
275: INTO
276: COUNT_INTRA_INT_HEADERS
277: FROM
278: CE_ARCH_INTERFACE_HEADERS
279: WHERE NVL(INTRA_DAY_FLAG
280: ,'N') = 'Y';
281: SELECT
282: COUNT(*)

Line 291: CE_ARCH_INTERFACE_HEADERS

287: WHERE BANK_ACCOUNT_NUM || '-' || STATEMENT_NUMBER IN (
288: SELECT
289: BANK_ACCOUNT_NUM || '-' || STATEMENT_NUMBER
290: FROM
291: CE_ARCH_INTERFACE_HEADERS
292: WHERE NVL(INTRA_DAY_FLAG
293: ,'N') = 'Y' );
294: END IF;
295: END IF;

Line 325: CE_ARCH_INTERFACE_HEADERS

321: WHERE BANK_ACCOUNT_NUM || '-' || STATEMENT_NUMBER IN (
322: SELECT
323: BANK_ACCOUNT_NUM || '-' || STATEMENT_NUMBER
324: FROM
325: CE_ARCH_INTERFACE_HEADERS
326: WHERE NVL(INTRA_DAY_FLAG
327: ,'N') = 'N' );
328: END IF;
329: IF (COUNT_INT_HEADERS > 0) THEN

Line 330: DELETE FROM CE_ARCH_INTERFACE_HEADERS

326: WHERE NVL(INTRA_DAY_FLAG
327: ,'N') = 'N' );
328: END IF;
329: IF (COUNT_INT_HEADERS > 0) THEN
330: DELETE FROM CE_ARCH_INTERFACE_HEADERS
331: WHERE NVL(INTRA_DAY_FLAG
332: ,'N') = 'N';
333: END IF;
334: IF (COUNT_INTRA_HEADERS > 0) THEN

Line 346: CE_ARCH_INTERFACE_HEADERS

342: WHERE BANK_ACCOUNT_NUM || '-' || STATEMENT_NUMBER IN (
343: SELECT
344: BANK_ACCOUNT_NUM || '-' || STATEMENT_NUMBER
345: FROM
346: CE_ARCH_INTERFACE_HEADERS
347: WHERE NVL(INTRA_DAY_FLAG
348: ,'N') = 'Y' );
349: END IF;
350: IF (COUNT_INTRA_INT_HEADERS > 0) THEN

Line 351: DELETE FROM CE_ARCH_INTERFACE_HEADERS

347: WHERE NVL(INTRA_DAY_FLAG
348: ,'N') = 'Y' );
349: END IF;
350: IF (COUNT_INTRA_INT_HEADERS > 0) THEN
351: DELETE FROM CE_ARCH_INTERFACE_HEADERS
352: WHERE NVL(INTRA_DAY_FLAG
353: ,'N') = 'Y';
354: END IF;
355: END IF;

Line 950: INSERT INTO CE_ARCH_INTERFACE_HEADERS

946: C_PURGE_STAT_ERRORS := PURGE_RECON_ERRORS;
947: END IF;
948: IF (P_OBJECTS in ('BOTH','INTERFACE')) THEN
949: IF (P_OPTION = 'BOTH') THEN
950: INSERT INTO CE_ARCH_INTERFACE_HEADERS
951: (STATEMENT_NUMBER
952: ,BANK_ACCOUNT_NUM
953: ,STATEMENT_DATE
954: ,BANK_NAME

Line 1154: CE_ARCH_INTERFACE_HEADERS )

1150: WHERE CSL.BANK_ACCOUNT_NUM IN (
1151: SELECT
1152: BANK_ACCOUNT_NUM
1153: FROM
1154: CE_ARCH_INTERFACE_HEADERS )
1155: AND STATEMENT_NUMBER IN (
1156: SELECT
1157: STATEMENT_NUMBER
1158: FROM

Line 1159: CE_ARCH_INTERFACE_HEADERS

1155: AND STATEMENT_NUMBER IN (
1156: SELECT
1157: STATEMENT_NUMBER
1158: FROM
1159: CE_ARCH_INTERFACE_HEADERS
1160: WHERE CSL.BANK_ACCOUNT_NUM = BANK_ACCOUNT_NUM
1161: AND NVL(INTRA_DAY_FLAG
1162: ,'N') = 'N' );
1163: C_ARCHIVE_INF_LINES := SQL%ROWCOUNT;

Line 1675: INSERT INTO CE_ARCH_INTERFACE_HEADERS

1671: C_PURGE_STAT_HEADERS2 := PURGE_HEADERS;
1672: END IF;
1673: IF (P_OBJECTS in ('BOTH','INTERFACE')) THEN
1674: IF (P_OPTION = 'BOTH') THEN
1675: INSERT INTO CE_ARCH_INTERFACE_HEADERS
1676: (STATEMENT_NUMBER
1677: ,BANK_ACCOUNT_NUM
1678: ,STATEMENT_DATE
1679: ,BANK_NAME

Line 1880: CE_ARCH_INTERFACE_HEADERS )

1876: WHERE CSL.BANK_ACCOUNT_NUM IN (
1877: SELECT
1878: BANK_ACCOUNT_NUM
1879: FROM
1880: CE_ARCH_INTERFACE_HEADERS )
1881: AND STATEMENT_NUMBER IN (
1882: SELECT
1883: STATEMENT_NUMBER
1884: FROM

Line 1885: CE_ARCH_INTERFACE_HEADERS

1881: AND STATEMENT_NUMBER IN (
1882: SELECT
1883: STATEMENT_NUMBER
1884: FROM
1885: CE_ARCH_INTERFACE_HEADERS
1886: WHERE CSL.BANK_ACCOUNT_NUM = BANK_ACCOUNT_NUM
1887: AND INTRA_DAY_FLAG = 'Y' );
1888: C_ARCHIVE_INF_LINES2 := SQL%ROWCOUNT;
1889: END IF;