APPS.OKL_PURGE_STRM_INTF_PVT dependencies on OKL_SIF_LINES

Line 61: FND_FILE.Put_Line(FND_FILE.LOG,'Deleting records from OKL_SIF_LINES');

57: WHERE creation_date < l_end_date
58: AND sis_code NOT IN ('DATA_ENTERED', 'HDR_INSERTED',
59: 'PROCESSING_REQUEST', 'RET_DATA_RECEIVED'));
60: commit;
61: FND_FILE.Put_Line(FND_FILE.LOG,'Deleting records from OKL_SIF_LINES');
62:
63: DELETE FROM OKL_SIF_LINES
64: WHERE sif_id IN (SELECT id FROM okl_stream_interfaces
65: WHERE creation_date < l_end_date

Line 63: DELETE FROM OKL_SIF_LINES

59: 'PROCESSING_REQUEST', 'RET_DATA_RECEIVED'));
60: commit;
61: FND_FILE.Put_Line(FND_FILE.LOG,'Deleting records from OKL_SIF_LINES');
62:
63: DELETE FROM OKL_SIF_LINES
64: WHERE sif_id IN (SELECT id FROM okl_stream_interfaces
65: WHERE creation_date < l_end_date
66: AND sis_code NOT IN ('DATA_ENTERED', 'HDR_INSERTED',
67: 'PROCESSING_REQUEST', 'RET_DATA_RECEIVED'));