APPS.CE_PURGE dependencies on CE_ARCH_HEADERS

Line 223: FROM ce_arch_headers cah ,

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
226: AND csh.statement_number = cah.statement_number
227: AND csh.org_id = cah.org_id

Line 241: FROM ce_arch_headers cah ,

237: END IF;
238:
239: DELETE FROM CE_ARCH_RECON_ERRORS cre
240: WHERE cre.statement_line_id IN (SELECT cah.statement_header_id
241: FROM ce_arch_headers cah ,
242: ce_statement_headers csh
243: WHERE cah.bank_account_id = csh.bank_account_id
244: AND csh.statement_number = cah.statement_number
245: AND csh.org_id = cah.org_id

Line 259: FROM ce_arch_headers cah ,

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
262: AND csh.statement_number = cah.statement_number
263: AND csh.org_id = cah.org_id

Line 275: DELETE FROM CE_ARCH_HEADERS

271: IF( G_Archive_Purge_Option = 'Restore' ) THEN
272: G_Purge_Stat_Lines := SQL%ROWCOUNT;
273: END IF;
274:
275: DELETE FROM CE_ARCH_HEADERS
276: WHERE statement_header_id IN (SELECT cah.statement_header_id
277: FROM ce_arch_headers cah ,
278: ce_statement_headers csh
279: WHERE cah.bank_account_id = csh.bank_account_id

Line 277: FROM ce_arch_headers cah ,

273: END IF;
274:
275: DELETE FROM CE_ARCH_HEADERS
276: WHERE statement_header_id IN (SELECT cah.statement_header_id
277: FROM ce_arch_headers cah ,
278: ce_statement_headers csh
279: WHERE cah.bank_account_id = csh.bank_account_id
280: AND csh.statement_number = cah.statement_number
281: AND csh.org_id = cah.org_id

Line 478: DELETE FROM CE_ARCH_HEADERS;

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;
481:
482: IF (G_OBJECTS IN ('BOTH','INTERFACE')) THEN

Line 554: INSERT INTO ce_arch_headers (

550: -- org (ce_statement_reconcils_all.org_id and ce_statement_reconcils_all.legal_entity_id)
551: -- This is to ensure that there are no orphan trx data in the system
552:
553:
554: INSERT INTO ce_arch_headers (
555: STATEMENT_COMPLETE_FLAG,
556: --ORG_ID,
557: DOC_SEQUENCE_ID,
558: DOC_SEQUENCE_VALUE,

Line 680: INSERT INTO ce_arch_headers (

676: ELSIF (CE_PURGE.G_BANK_BRANCH_ID IS NOT NULL) THEN
677:
678: fnd_file.put_line(fnd_file.log, 'IF (CE_PURGE.G_BANK_BRANCH_ID IS NOT NULL ');
679:
680: INSERT INTO ce_arch_headers (
681: STATEMENT_COMPLETE_FLAG,
682: --ORG_ID,
683: DOC_SEQUENCE_ID,
684: DOC_SEQUENCE_VALUE,

Line 805: INSERT INTO ce_arch_headers (

801: ) OR CE_PURGE.G_Only_Unrec = 'N'); /*10400780 end*/
802:
803: G_Archive_Stat_Headers := SQL%ROWCOUNT;
804: ELSE
805: INSERT INTO ce_arch_headers (
806: STATEMENT_COMPLETE_FLAG,
807: --ORG_ID,
808: DOC_SEQUENCE_ID,
809: DOC_SEQUENCE_VALUE,

Line 1011: FROM ce_arch_headers );

1007: RECONCILE_TO_STATEMENT_FLAG
1008: FROM ce_statement_lines
1009: WHERE statement_header_id IN
1010: ( SELECT statement_header_id
1011: FROM ce_arch_headers );
1012: G_Archive_Stat_Lines := SQL%ROWCOUNT;
1013:
1014: INSERT INTO ce_arch_reconciliations_all
1015: (STATEMENT_LINE_ID,

Line 2103: FROM ce_arch_headers csh

2099: CREATED_BY,
2100: CREATION_DATE,
2101: LAST_UPDATED_BY,
2102: LAST_UPDATE_DATE
2103: FROM ce_arch_headers csh
2104: WHERE ( csh.bank_account_id = Nvl(CE_PURGE.G_BANK_ACCOUNT_ID,-1)
2105: OR
2106: (CE_PURGE.G_BANK_ACCOUNT_ID IS NULL
2107: AND (csh.bank_account_id in (SELECT aba.bank_account_id

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 2443: DELETE FROM ce_arch_headers

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;
2445:
2446: EXCEPTION
2447: WHEN DUP_VAL_ON_INDEX THEN