APPS.CE_PURGE dependencies on CE_ARCH_INTRA_HEADERS

Line 352: FROM ce_intra_stmt_headers csh , CE_ARCH_INTRA_HEADERS cah

348:
349: delete FROM CE_ARCH_INTRA_LINES cal
350: WHERE cal.statement_header_id IN (
351: SELECT cah.statement_header_id
352: FROM ce_intra_stmt_headers csh , CE_ARCH_INTRA_HEADERS cah
353: WHERE cah.statement_number = csh.statement_number
354: AND cah.org_id = csh.org_id
355: AND cah.bank_account_id = csh.bank_account_id
356: AND csh.bank_account_id = NVL(CE_PURGE.G_BANK_ACCOUNT_ID,csh.bank_account_id)

Line 368: DELETE from CE_ARCH_INTRA_HEADERS cah2

364: IF( G_Archive_Purge_Option = 'Restore' ) THEN
365: G_Purge_Stat_Lines2 := SQL%ROWCOUNT;
366: END IF;
367:
368: DELETE from CE_ARCH_INTRA_HEADERS cah2
369: WHERE cah2.statement_header_id IN (
370: SELECT cah.statement_header_id
371: FROM ce_intra_stmt_headers csh , CE_ARCH_INTRA_HEADERS cah
372: WHERE cah.statement_number = csh.statement_number

Line 371: FROM ce_intra_stmt_headers csh , CE_ARCH_INTRA_HEADERS cah

367:
368: DELETE from CE_ARCH_INTRA_HEADERS cah2
369: WHERE cah2.statement_header_id IN (
370: SELECT cah.statement_header_id
371: FROM ce_intra_stmt_headers csh , CE_ARCH_INTRA_HEADERS cah
372: WHERE cah.statement_number = csh.statement_number
373: AND cah.org_id = csh.org_id
374: AND cah.bank_account_id = csh.bank_account_id
375: AND csh.bank_account_id = NVL(CE_PURGE.G_BANK_ACCOUNT_ID,csh.bank_account_id)

Line 499: DELETE FROM CE_ARCH_INTRA_HEADERS;

495:
496: IF (G_STATEMENT_TYPE IN ('BOTH','INTRADAY')) THEN
497: IF (G_OBJECTS IN ('BOTH','STATEMENT')) THEN
498:
499: DELETE FROM CE_ARCH_INTRA_HEADERS;
500:
501: DELETE FROM CE_ARCH_INTRA_LINES;
502:
503: END IF;

Line 1333: INSERT INTO ce_arch_intra_headers (

1329: is
1330: BEGIN
1331:
1332: IF (G_BANK_ACCOUNT_ID IS NOT NULL) THEN
1333: INSERT INTO ce_arch_intra_headers (
1334: STATEMENT_COMPLETE_FLAG,
1335: --ORG_ID,
1336: DOC_SEQUENCE_ID,
1337: DOC_SEQUENCE_VALUE,

Line 1429: INSERT INTO ce_arch_intra_headers (

1425: G_Archive_Stat_Headers2 := SQL%ROWCOUNT;
1426:
1427: ELSIF (G_BANK_BRANCH_ID IS NOT NULL) THEN
1428:
1429: INSERT INTO ce_arch_intra_headers (
1430: STATEMENT_COMPLETE_FLAG,
1431: --ORG_ID,
1432: DOC_SEQUENCE_ID,
1433: DOC_SEQUENCE_VALUE,

Line 1527: INSERT INTO ce_arch_intra_headers (

1523: G_Archive_Stat_Headers2 := SQL%ROWCOUNT;
1524:
1525: ELSE
1526:
1527: INSERT INTO ce_arch_intra_headers (
1528: STATEMENT_COMPLETE_FLAG,
1529: --ORG_ID,
1530: DOC_SEQUENCE_ID,
1531: DOC_SEQUENCE_VALUE,

Line 1710: FROM ce_arch_intra_headers );

1706: RECONCILE_TO_STATEMENT_FLAG
1707: FROM ce_intra_stmt_lines
1708: WHERE statement_header_id IN
1709: ( SELECT statement_header_id
1710: FROM ce_arch_intra_headers );
1711:
1712: G_Archive_Stat_Lines2 := SQL%ROWCOUNT;
1713:
1714: END arch_ce_intra_statements;

Line 2533: FROM ce_arch_intra_headers csh

2529: CREATED_BY,
2530: CREATION_DATE,
2531: LAST_UPDATED_BY,
2532: LAST_UPDATE_DATE
2533: FROM ce_arch_intra_headers csh
2534: WHERE ( csh.bank_account_id = Nvl(CE_PURGE.G_BANK_ACCOUNT_ID,-1)
2535: OR
2536: (CE_PURGE.G_BANK_ACCOUNT_ID IS NULL
2537: AND csh.bank_account_id IN (SELECT aba.bank_account_id

Line 2767: DELETE FROM ce_arch_intra_headers

2763: /* Delete Restored Lines */
2764: DELETE FROM ce_arch_intra_lines
2765: WHERE statement_header_id = r_intraStmt.statement_header_id;
2766:
2767: DELETE FROM ce_arch_intra_headers
2768: WHERE CURRENT OF C_Restore_Intra_Stmts;
2769:
2770: EXCEPTION
2771: WHEN Dup_Val_On_Index THEN