APPS.CE_PURGE dependencies on CE_ARCH_LINES

Line 221: (SELECT cl.statement_line_id FROM ce_arch_lines cl WHERE

217: IF (G_OBJECTS IN ('BOTH','STATEMENT')) THEN
218:
219: DELETE FROM CE_ARCH_RECONCILIATIONS car
220: WHERE car.statement_line_id IN
221: (SELECT cl.statement_line_id FROM ce_arch_lines cl WHERE
222: cl.statement_header_id IN (SELECT cah.statement_header_id
223: FROM ce_arch_headers cah ,
224: ce_statement_headers csh
225: WHERE cah.bank_account_id = csh.bank_account_id

Line 257: DELETE FROM CE_ARCH_LINES

253: IF( G_Archive_Purge_Option = 'Restore' ) THEN
254: G_Purge_Stat_Errors := SQL%ROWCOUNT;
255: END IF;
256:
257: DELETE FROM CE_ARCH_LINES
258: WHERE statement_header_id IN (SELECT cah.statement_header_id
259: FROM ce_arch_headers cah ,
260: ce_statement_headers csh
261: WHERE cah.bank_account_id = csh.bank_account_id

Line 476: DELETE FROM CE_ARCH_LINES;

472: REFERENCE_TYPE in ('JE_LINE', 'ROI_LINE','STATEMENT');
473:
474: DELETE FROM CE_ARCH_RECON_ERRORS;
475:
476: DELETE FROM CE_ARCH_LINES;
477:
478: DELETE FROM CE_ARCH_HEADERS;
479:
480: END IF;

Line 924: INSERT INTO ce_arch_lines

920:
921: G_Archive_Stat_Headers := SQL%ROWCOUNT;
922: END IF;
923:
924: INSERT INTO ce_arch_lines
925: (STATEMENT_LINE_ID,
926: STATEMENT_HEADER_ID,
927: LINE_NUMBER,
928: TRX_DATE,

Line 1059: FROM ce_arch_lines );

1055: AMOUNT
1056: FROM ce_statement_recon_gt_v --ce_statement_reconciliations
1057: WHERE statement_line_id IN
1058: ( SELECT statement_line_id
1059: FROM ce_arch_lines );
1060: G_Archive_Stat_Rec := SQL%ROWCOUNT;
1061:
1062: INSERT INTO ce_arch_recon_errors
1063: (STATEMENT_LINE_ID,

Line 1079: FROM ce_arch_lines );

1075: STATEMENT_HEADER_ID
1076: FROM ce_reconciliation_errors
1077: WHERE statement_line_id IN
1078: ( SELECT statement_line_id
1079: FROM ce_arch_lines );
1080: G_Archive_Stat_Errors := SQL%ROWCOUNT;
1081:
1082: END arch_ce_statements;
1083:

Line 2114: from ce_arch_headers sh, ce_arch_lines sl , ce_arch_reconciliations_all sr

2110: AND csh.statement_date >= NVL(CE_PURGE.G_STATEMENT_DATE_FROM, csh.statement_date)
2111: AND csh.statement_date <= NVL(CE_PURGE.G_STATEMENT_DATE_TO, csh.statement_date)
2112: AND not exists
2113: (select 1 -- find all stmts that are not in ce_security_profiles_gt (cannot delete these stmts)
2114: from ce_arch_headers sh, ce_arch_lines sl , ce_arch_reconciliations_all sr
2115: where sh.statement_header_id = sl.statement_header_id
2116: and sl.statement_line_id= sr.statement_line_id
2117: and sh.statement_header_id= csh.statement_header_id
2118: and ( csh.bank_account_id = Nvl(CE_PURGE.G_BANK_ACCOUNT_ID,-1)

Line 2337: FROM ce_arch_lines

2333: CREATION_DATE,
2334: LAST_UPDATED_BY,
2335: LAST_UPDATE_DATE,
2336: RECONCILE_TO_STATEMENT_FLAG
2337: FROM ce_arch_lines
2338: WHERE statement_header_id = r_stmt.STATEMENT_HEADER_ID;
2339:
2340:
2341: G_Archive_Stat_Lines := SQL%ROWCOUNT;

Line 2390: FROM ce_arch_lines

2386: AMOUNT
2387: FROM ce_arch_reconciliations_all --ce_statement_reconciliations
2388: WHERE statement_line_id IN
2389: ( SELECT statement_line_id
2390: FROM ce_arch_lines
2391: WHERE statement_header_id = r_stmt.STATEMENT_HEADER_ID );
2392:
2393: G_Archive_Stat_Rec := SQL%ROWCOUNT;
2394:

Line 2434: FROM ce_arch_lines

2430:
2431: DELETE FROM ce_arch_reconciliations_all --ce_statement_reconciliations
2432: WHERE statement_line_id IN
2433: ( SELECT statement_line_id
2434: FROM ce_arch_lines
2435: WHERE statement_header_id = r_stmt.STATEMENT_HEADER_ID );
2436:
2437: DELETE FROM ce_arch_recon_errors
2438: WHERE statement_header_id = r_stmt.STATEMENT_HEADER_ID;

Line 2440: DELETE FROM ce_arch_lines

2436:
2437: DELETE FROM ce_arch_recon_errors
2438: WHERE statement_header_id = r_stmt.STATEMENT_HEADER_ID;
2439:
2440: DELETE FROM ce_arch_lines
2441: WHERE statement_header_id = r_stmt.STATEMENT_HEADER_ID;
2442:
2443: DELETE FROM ce_arch_headers
2444: WHERE CURRENT OF C_restore_stmts;