APPS.OKL_PURGE_STRM_INTF_PVT dependencies on OKL_SIF_RETS

Line 111: WHERE sir_id IN (SELECT rets.id from OKL_SIF_RETS rets, okl_stream_interfaces str

107: FND_FILE.Put_Line(FND_FILE.LOG,'Deleting records from OKL_SIF_RET_LEVELS');
108:
109:
110: DELETE FROM OKL_SIF_RET_LEVELS
111: WHERE sir_id IN (SELECT rets.id from OKL_SIF_RETS rets, okl_stream_interfaces str
112: WHERE rets.transaction_number = str.transaction_number
113: and str.creation_date < l_end_date
114: AND str.sis_code NOT IN ('DATA_ENTERED', 'HDR_INSERTED',
115: 'PROCESSING_REQUEST', 'RET_DATA_RECEIVED'));

Line 121: WHERE sir_id IN (SELECT rets.id from OKL_SIF_RETS rets, okl_stream_interfaces str

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',
125: 'PROCESSING_REQUEST', 'RET_DATA_RECEIVED'));

Line 132: WHERE sir_id IN (SELECT rets.id from OKL_SIF_RETS rets, okl_stream_interfaces str

128: FND_FILE.Put_Line(FND_FILE.LOG,'Deleting records from OKL_SIF_RET_STRMS');
129:
130:
131: DELETE FROM OKL_SIF_RET_STRMS
132: WHERE sir_id IN (SELECT rets.id from OKL_SIF_RETS rets, okl_stream_interfaces str
133: WHERE rets.transaction_number = str.transaction_number
134: and str.creation_date < l_end_date
135: AND str.sis_code NOT IN ('DATA_ENTERED', 'HDR_INSERTED',
136: 'PROCESSING_REQUEST', 'RET_DATA_RECEIVED'));

Line 151: FND_FILE.Put_Line(FND_FILE.LOG,'Deleting records from OKL_SIF_RETS');

147:
148: commit;
149: --end bkatraga
150:
151: FND_FILE.Put_Line(FND_FILE.LOG,'Deleting records from OKL_SIF_RETS');
152:
153: DELETE FROM OKL_SIF_RETS
154: WHERE transaction_number IN (SELECT transaction_number FROM okl_stream_interfaces
155: WHERE creation_date < l_end_date

Line 153: DELETE FROM OKL_SIF_RETS

149: --end bkatraga
150:
151: FND_FILE.Put_Line(FND_FILE.LOG,'Deleting records from OKL_SIF_RETS');
152:
153: DELETE FROM OKL_SIF_RETS
154: WHERE transaction_number IN (SELECT transaction_number FROM okl_stream_interfaces
155: WHERE creation_date < l_end_date
156: AND sis_code NOT IN ('DATA_ENTERED', 'HDR_INSERTED',
157: 'PROCESSING_REQUEST', 'RET_DATA_RECEIVED'));