APPS.CE_CEPURGE_XMLP_PKG dependencies on CE_ARCH_INTERFACE_LINES

Line 247: CE_ARCH_INTERFACE_LINES

243: COUNT(*)
244: INTO
245: COUNT_INT_LINES
246: FROM
247: CE_ARCH_INTERFACE_LINES
248: WHERE BANK_ACCOUNT_NUM || '-' || STATEMENT_NUMBER IN (
249: SELECT
250: BANK_ACCOUNT_NUM || '-' || STATEMENT_NUMBER
251: FROM

Line 286: CE_ARCH_INTERFACE_LINES

282: COUNT(*)
283: INTO
284: COUNT_INTRA_INT_LINES
285: FROM
286: CE_ARCH_INTERFACE_LINES
287: WHERE BANK_ACCOUNT_NUM || '-' || STATEMENT_NUMBER IN (
288: SELECT
289: BANK_ACCOUNT_NUM || '-' || STATEMENT_NUMBER
290: FROM

Line 320: DELETE FROM CE_ARCH_INTERFACE_LINES

316: IF (COUNT_ERRORS > 0) THEN
317: DELETE FROM CE_ARCH_RECON_ERRORS;
318: END IF;
319: IF (COUNT_INT_LINES > 0) THEN
320: DELETE FROM CE_ARCH_INTERFACE_LINES
321: WHERE BANK_ACCOUNT_NUM || '-' || STATEMENT_NUMBER IN (
322: SELECT
323: BANK_ACCOUNT_NUM || '-' || STATEMENT_NUMBER
324: FROM

Line 341: DELETE FROM CE_ARCH_INTERFACE_LINES

337: IF (COUNT_INTRA_LINES > 0) THEN
338: DELETE FROM CE_ARCH_INTRA_LINES;
339: END IF;
340: IF (COUNT_INTRA_INT_LINES > 0) THEN
341: DELETE FROM CE_ARCH_INTERFACE_LINES
342: WHERE BANK_ACCOUNT_NUM || '-' || STATEMENT_NUMBER IN (
343: SELECT
344: BANK_ACCOUNT_NUM || '-' || STATEMENT_NUMBER
345: FROM

Line 1072: INSERT INTO CE_ARCH_INTERFACE_LINES

1068: ,'T') )
1069: AND NVL(CSH.INTRA_DAY_FLAG
1070: ,'N') = 'N';
1071: C_ARCHIVE_INF_HEADERS := SQL%ROWCOUNT;
1072: INSERT INTO CE_ARCH_INTERFACE_LINES
1073: (EXCHANGE_RATE_DATE
1074: ,EXCHANGE_RATE
1075: ,BANK_TRX_NUMBER
1076: ,CUSTOMER_TEXT

Line 1798: INSERT INTO CE_ARCH_INTERFACE_LINES

1794: ,RECORD_STATUS_FLAG
1795: ,'T') )
1796: AND CSH.INTRA_DAY_FLAG = 'Y';
1797: C_ARCHIVE_INF_HEADERS2 := SQL%ROWCOUNT;
1798: INSERT INTO CE_ARCH_INTERFACE_LINES
1799: (EXCHANGE_RATE_DATE
1800: ,EXCHANGE_RATE
1801: ,BANK_TRX_NUMBER
1802: ,CUSTOMER_TEXT