APPS.CE_PURGE dependencies on CE_ARCH_INTERFACE_HEADERS

Line 319: DELETE FROM CE_ARCH_INTERFACE_HEADERS cah

315: IF( G_Archive_Purge_Option = 'Restore' ) THEN
316: G_Purge_Inf_Lines := SQL%ROWCOUNT;
317: END IF;
318:
319: DELETE FROM CE_ARCH_INTERFACE_HEADERS cah
320: WHERE cah.statement_number ||'-'|| cah.bank_account_num IN
321: ( SELECT csh.statement_number ||'-'|| csh.bank_account_num
322: FROM ce_statement_headers_int csh
323: WHERE NVL(csh.bank_branch_name,CE_PURGE.G_BANK_BRANCH_NAME) IN

Line 417: DELETE FROM CE_ARCH_INTERFACE_HEADERS cah

413: G_Purge_Inf_Lines2 := SQL%ROWCOUNT;
414: END IF;
415:
416:
417: DELETE FROM CE_ARCH_INTERFACE_HEADERS cah
418: WHERE cah.statement_number ||'-'|| cah.bank_account_num IN
419: (SELECT csh.statement_number ||'-'|| csh.bank_account_num
420: FROM ce_statement_headers_int csh
421: WHERE NVL(csh.bank_branch_name,CE_PURGE.G_BANK_BRANCH_NAME) IN

Line 487: FROM CE_ARCH_INTERFACE_HEADERS

483:
484: DELETE FROM CE_ARCH_INTERFACE_LINES
485: WHERE BANK_ACCOUNT_NUM || '-' || STATEMENT_NUMBER IN
486: (SELECT BANK_ACCOUNT_NUM || '-' || STATEMENT_NUMBER
487: FROM CE_ARCH_INTERFACE_HEADERS
488: WHERE NVL(INTRA_DAY_FLAG, 'N') = 'N');
489:
490: DELETE FROM CE_ARCH_INTERFACE_HEADERS
491: WHERE NVL(INTRA_DAY_FLAG, 'N') = 'N';

Line 490: DELETE FROM CE_ARCH_INTERFACE_HEADERS

486: (SELECT BANK_ACCOUNT_NUM || '-' || STATEMENT_NUMBER
487: FROM CE_ARCH_INTERFACE_HEADERS
488: WHERE NVL(INTRA_DAY_FLAG, 'N') = 'N');
489:
490: DELETE FROM CE_ARCH_INTERFACE_HEADERS
491: WHERE NVL(INTRA_DAY_FLAG, 'N') = 'N';
492:
493: END IF;
494: END IF;

Line 510: FROM CE_ARCH_INTERFACE_HEADERS

506:
507: DELETE FROM CE_ARCH_INTERFACE_LINES
508: WHERE BANK_ACCOUNT_NUM || '-' || STATEMENT_NUMBER IN
509: (SELECT BANK_ACCOUNT_NUM || '-' || STATEMENT_NUMBER
510: FROM CE_ARCH_INTERFACE_HEADERS
511: WHERE NVL(INTRA_DAY_FLAG, 'N') = 'Y');
512:
513: DELETE FROM CE_ARCH_INTERFACE_HEADERS
514: WHERE NVL(INTRA_DAY_FLAG, 'N') = 'Y';

Line 513: DELETE FROM CE_ARCH_INTERFACE_HEADERS

509: (SELECT BANK_ACCOUNT_NUM || '-' || STATEMENT_NUMBER
510: FROM CE_ARCH_INTERFACE_HEADERS
511: WHERE NVL(INTRA_DAY_FLAG, 'N') = 'Y');
512:
513: DELETE FROM CE_ARCH_INTERFACE_HEADERS
514: WHERE NVL(INTRA_DAY_FLAG, 'N') = 'Y';
515:
516: END IF;
517: END IF;

Line 1104: INSERT INTO ce_arch_interface_headers

1100: PROCEDURE arch_ce_interface(p_intra_day_flag IN VARCHAR2)
1101: IS
1102: BEGIN
1103:
1104: INSERT INTO ce_arch_interface_headers
1105: (STATEMENT_NUMBER,
1106: BANK_ACCOUNT_NUM,
1107: STATEMENT_DATE,
1108: BANK_NAME,

Line 2859: FROM ce_arch_interface_headers csh

2855: LAST_UPDATED_BY,
2856: LAST_UPDATE_DATE,
2857: intra_day_flag,
2858: ORG_ID
2859: FROM ce_arch_interface_headers csh
2860: WHERE NVL(csh.bank_branch_name,CE_PURGE.G_BANK_BRANCH_NAME) IN (SELECT bb.bank_branch_name
2861: FROM ce_bank_branches_v bb, ce_bank_accts_gt_v ba
2862: WHERE bb.branch_party_id = ba.bank_branch_id
2863: AND ba.bank_account_id = NVL(CE_PURGE.G_BANK_ACCOUNT_ID,ba.bank_account_id)

Line 3129: DELETE FROM ce_arch_interface_headers

3125: cep_standard.debug('>> G_Archive_Inf_Lines2: '||G_Archive_Inf_Lines2);
3126: END IF;
3127: END IF;
3128:
3129: DELETE FROM ce_arch_interface_headers
3130: WHERE CURRENT OF C_Restore_interface;
3131:
3132: DELETE FROM ce_arch_interface_lines csl
3133: WHERE csl.statement_number ||'-'|| csl.bank_account_num =