APPS.CE_PURGE dependencies on CE_ARCH_INTERFACE_LINES

Line 297: DELETE FROM CE_ARCH_INTERFACE_LINES cal

293: END IF;
294:
295: IF (G_OBJECTS IN ('BOTH','INTERFACE')) THEN
296:
297: DELETE FROM CE_ARCH_INTERFACE_LINES cal
298: WHERE cal.statement_number ||'-'|| cal.bank_account_num IN
299: ( SELECT csh.statement_number ||'-'|| csh.bank_account_num
300: FROM ce_statement_headers_int csh
301: WHERE NVL(csh.bank_branch_name,CE_PURGE.G_BANK_BRANCH_NAME) IN (SELECT bb.bank_branch_name

Line 392: DELETE FROM CE_ARCH_INTERFACE_LINES cal

388: END IF;
389:
390: IF (G_OBJECTS IN ('BOTH','INTERFACE')) THEN
391:
392: DELETE FROM CE_ARCH_INTERFACE_LINES cal
393: WHERE cal.statement_number ||'-'|| cal.bank_account_num IN
394: ( SELECT csh.statement_number ||'-'|| csh.bank_account_num
395: FROM ce_statement_headers_int csh
396: WHERE NVL(csh.bank_branch_name,CE_PURGE.G_BANK_BRANCH_NAME) IN (

Line 484: DELETE FROM CE_ARCH_INTERFACE_LINES

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

Line 507: DELETE FROM CE_ARCH_INTERFACE_LINES

503: END IF;
504:
505: IF (G_OBJECTS IN ('BOTH','INTERFACE')) THEN
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');

Line 1210: INSERT INTO ce_arch_interface_lines

1206: G_Archive_Inf_Headers2 := SQL%ROWCOUNT;
1207: END IF;
1208:
1209:
1210: INSERT INTO ce_arch_interface_lines
1211: (EXCHANGE_RATE_DATE,
1212: EXCHANGE_RATE,
1213: BANK_TRX_NUMBER,
1214: CUSTOMER_TEXT,

Line 3097: FROM ce_arch_interface_lines csl

3093: AMOUNT,
3094: CHARGES_AMOUNT,
3095: CURRENCY_CODE,
3096: USER_EXCHANGE_RATE_TYPE
3097: FROM ce_arch_interface_lines csl
3098: WHERE csl.statement_number ||'-'|| csl.bank_account_num =
3099: r_interface.statement_number ||'-'|| r_interface.bank_account_num;
3100:
3101: IF( p_intra_day_flag = 'N' ) THEN

Line 3132: DELETE FROM ce_arch_interface_lines csl

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 =
3134: r_interface.statement_number ||'-'|| r_interface.bank_account_num;
3135:
3136: