114: AND str.sis_code NOT IN ('DATA_ENTERED', 'HDR_INSERTED',
115: 'PROCESSING_REQUEST', 'RET_DATA_RECEIVED'));
116: commit;
117:
118: FND_FILE.Put_Line(FND_FILE.LOG,'Deleting records from OKL_SIF_RET_ERRORS');
119:
120: DELETE FROM OKL_SIF_RET_ERRORS
121: WHERE sir_id IN (SELECT rets.id from OKL_SIF_RETS rets, okl_stream_interfaces str
122: WHERE rets.transaction_number = str.transaction_number
116: commit;
117:
118: FND_FILE.Put_Line(FND_FILE.LOG,'Deleting records from OKL_SIF_RET_ERRORS');
119:
120: DELETE FROM OKL_SIF_RET_ERRORS
121: WHERE sir_id IN (SELECT rets.id from OKL_SIF_RETS rets, okl_stream_interfaces str
122: WHERE rets.transaction_number = str.transaction_number
123: and str.creation_date < l_end_date
124: AND str.sis_code NOT IN ('DATA_ENTERED', 'HDR_INSERTED',