DBA Data[Home] [Help]

APPS.CE_PURGE dependencies on CE_RECONCILIATION_ERRORS

Line 1076: FROM ce_reconciliation_errors

1072: CREATION_DATE,
1073: CREATED_BY,
1074: APPLICATION_SHORT_NAME,
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;

Line 1875: DELETE FROM ce_reconciliation_errors

1871: );
1872:
1873: purge_recons := purge_recons + SQL%ROWCOUNT;
1874:
1875: DELETE FROM ce_reconciliation_errors
1876: WHERE statement_line_id = X_line_id;
1877: purge_recon_errors := purge_recon_errors + SQL%ROWCOUNT;
1878:
1879: FETCH C_PURGE_LINES INTO X_line_id;

Line 2397: INSERT INTO ce_reconciliation_errors

2393: G_Archive_Stat_Rec := SQL%ROWCOUNT;
2394:
2395: cep_standard.debug('>>CE_PURGE.restore_statements G_Archive_Stat_Rec: '||G_Archive_Stat_Rec);
2396:
2397: INSERT INTO ce_reconciliation_errors
2398: (STATEMENT_LINE_ID,
2399: MESSAGE_NAME,
2400: CREATION_DATE,
2401: CREATED_BY,