APPS.OKL_PURGE_STRM_INTF_PVT dependencies on OKL_STREAM_INTERFACES

Line 56: WHERE sif_id IN (SELECT id FROM okl_stream_interfaces

52:
53: FND_FILE.Put_Line(FND_FILE.LOG,'Deleting records from OKL_SIF_FEES');
54:
55: DELETE FROM OKL_SIF_FEES
56: WHERE sif_id IN (SELECT id FROM okl_stream_interfaces
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;

Line 64: WHERE sif_id IN (SELECT id FROM okl_stream_interfaces

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'));
68: commit;

Line 74: WHERE sif_id IN (SELECT id FROM okl_stream_interfaces

70: FND_FILE.Put_Line(FND_FILE.LOG,'Deleting records from OKL_SIF_STREAM_TYPES');
71:
72:
73: DELETE FROM OKL_SIF_STREAM_TYPES
74: WHERE sif_id IN (SELECT id FROM okl_stream_interfaces
75: WHERE creation_date < l_end_date
76: AND sis_code NOT IN ('DATA_ENTERED', 'HDR_INSERTED',
77: 'PROCESSING_REQUEST', 'RET_DATA_RECEIVED'));
78: commit;

Line 83: WHERE sif_id IN (SELECT id FROM okl_stream_interfaces

79:
80: FND_FILE.Put_Line(FND_FILE.LOG,'Deleting records from OKL_SIF_YIELDS');
81:
82: DELETE FROM OKL_SIF_YIELDS
83: WHERE sif_id IN (SELECT id FROM okl_stream_interfaces
84: WHERE creation_date < l_end_date
85: AND sis_code NOT IN ('DATA_ENTERED', 'HDR_INSERTED',
86: 'PROCESSING_REQUEST', 'RET_DATA_RECEIVED'));
87: commit;

Line 92: WHERE sif_id IN (SELECT id FROM okl_stream_interfaces

88:
89: FND_FILE.Put_Line(FND_FILE.LOG,'Deleting records from OKL_SIF_PRICING_PARAMS');
90:
91: DELETE FROM OKL_SIF_PRICING_PARAMS
92: WHERE sif_id IN (SELECT id FROM okl_stream_interfaces
93: WHERE creation_date < l_end_date
94: AND sis_code NOT IN ('DATA_ENTERED', 'HDR_INSERTED',
95: 'PROCESSING_REQUEST', 'RET_DATA_RECEIVED'));
96: commit;

Line 101: WHERE sif_id IN (SELECT id FROM okl_stream_interfaces

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'));
105: commit;

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 143: WHERE transaction_number IN (SELECT transaction_number FROM okl_stream_interfaces

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'));
147:

Line 154: WHERE transaction_number IN (SELECT transaction_number FROM okl_stream_interfaces

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'));
158: commit;

Line 160: FND_FILE.Put_Line(FND_FILE.LOG,'Deleting records from OKL_STREAM_INTERFACES');

156: AND sis_code NOT IN ('DATA_ENTERED', 'HDR_INSERTED',
157: 'PROCESSING_REQUEST', 'RET_DATA_RECEIVED'));
158: commit;
159:
160: FND_FILE.Put_Line(FND_FILE.LOG,'Deleting records from OKL_STREAM_INTERFACES');
161:
162: DELETE FROM OKL_STREAM_INTERFACES
163: WHERE creation_date < l_end_date
164: AND sis_code NOT IN ('DATA_ENTERED', 'HDR_INSERTED',

Line 162: DELETE FROM OKL_STREAM_INTERFACES

158: commit;
159:
160: FND_FILE.Put_Line(FND_FILE.LOG,'Deleting records from OKL_STREAM_INTERFACES');
161:
162: DELETE FROM OKL_STREAM_INTERFACES
163: WHERE creation_date < l_end_date
164: AND sis_code NOT IN ('DATA_ENTERED', 'HDR_INSERTED',
165: 'PROCESSING_REQUEST', 'RET_DATA_RECEIVED');
166: