APPS.OKL_PURGE_STRM_INTF_PVT dependencies on OKL_SIF_TRX_PARMS

Line 98: FND_FILE.Put_Line(FND_FILE.LOG,'Deleting records from OKL_SIF_TRX_PARMS');

94: AND sis_code NOT IN ('DATA_ENTERED', 'HDR_INSERTED',
95: 'PROCESSING_REQUEST', 'RET_DATA_RECEIVED'));
96: commit;
97:
98: FND_FILE.Put_Line(FND_FILE.LOG,'Deleting records from OKL_SIF_TRX_PARMS');
99:
100: DELETE FROM OKL_SIF_TRX_PARMS
101: WHERE sif_id IN (SELECT id FROM okl_stream_interfaces
102: WHERE creation_date < l_end_date

Line 100: DELETE FROM OKL_SIF_TRX_PARMS

96: commit;
97:
98: FND_FILE.Put_Line(FND_FILE.LOG,'Deleting records from OKL_SIF_TRX_PARMS');
99:
100: DELETE FROM OKL_SIF_TRX_PARMS
101: WHERE sif_id IN (SELECT id FROM okl_stream_interfaces
102: WHERE creation_date < l_end_date
103: AND sis_code NOT IN ('DATA_ENTERED', 'HDR_INSERTED',
104: 'PROCESSING_REQUEST', 'RET_DATA_RECEIVED'));