APPS.OKL_PURGE_STRM_INTF_PVT dependencies on OKL_STREAM_TRX_DATA

Line 140: FND_FILE.Put_Line(FND_FILE.LOG,'Deleting records from okl_stream_trx_data');

136: 'PROCESSING_REQUEST', 'RET_DATA_RECEIVED'));
137: commit;
138:
139: --Added by bkatraga
140: FND_FILE.Put_Line(FND_FILE.LOG,'Deleting records from okl_stream_trx_data');
141:
142: DELETE FROM okl_stream_trx_data
143: WHERE transaction_number IN (SELECT transaction_number FROM okl_stream_interfaces
144: WHERE creation_date < l_end_date

Line 142: DELETE FROM okl_stream_trx_data

138:
139: --Added by bkatraga
140: FND_FILE.Put_Line(FND_FILE.LOG,'Deleting records from okl_stream_trx_data');
141:
142: DELETE FROM okl_stream_trx_data
143: WHERE transaction_number IN (SELECT transaction_number FROM okl_stream_interfaces
144: WHERE creation_date < l_end_date
145: AND sis_code NOT IN ('DATA_ENTERED', 'HDR_INSERTED',
146: 'PROCESSING_REQUEST', 'RET_DATA_RECEIVED'));