APPS.OKS_IMPORT_PURGE_WORKER dependencies on OKS_LINES_INTERFACE

Line 158: FROM OKS_LINES_INTERFACE OLI, OKS_HEADERS_INTERFACE OHI

154: WHERE ROWID BETWEEN l_start_rowid AND l_end_rowid
155: AND BATCH_ID = P_batch_id
156: AND INTERFACE_STATUS = 'S')
157: OR LINE_INTERFACE_ID IN (SELECT OLI.LINE_INTERFACE_ID
158: FROM OKS_LINES_INTERFACE OLI, OKS_HEADERS_INTERFACE OHI
159: WHERE OHI.ROWID BETWEEN l_start_rowid AND l_end_rowid
160: AND OHI.BATCH_ID = P_batch_id
161: AND OHI.INTERFACE_STATUS = 'S'
162: AND OLI.HEADER_INTERFACE_ID = OHI.HEADER_INTERFACE_ID);

Line 167: FROM OKS_LINES_INTERFACE OLI, OKS_HEADERS_INTERFACE OHI

163: l_stmt_num := 60;
164:
165: DELETE FROM OKS_COVERED_LEVELS_INTERFACE
166: WHERE LINE_INTERFACE_ID IN (SELECT OLI.LINE_INTERFACE_ID
167: FROM OKS_LINES_INTERFACE OLI, OKS_HEADERS_INTERFACE OHI
168: WHERE OHI.ROWID BETWEEN l_start_rowid AND l_end_rowid
169: AND OHI.BATCH_ID = P_batch_id
170: AND OHI.INTERFACE_STATUS = 'S'
171: AND OLI.HEADER_INTERFACE_ID = OHI.HEADER_INTERFACE_ID);

Line 176: FROM OKS_LINES_INTERFACE OLI, OKS_HEADERS_INTERFACE OHI

172: l_stmt_num := 70;
173:
174: DELETE FROM OKS_USAGE_COUNTERS_INTERFACE
175: WHERE LINE_INTERFACE_ID IN (SELECT OLI.LINE_INTERFACE_ID
176: FROM OKS_LINES_INTERFACE OLI, OKS_HEADERS_INTERFACE OHI
177: WHERE OHI.ROWID BETWEEN l_start_rowid AND l_end_rowid
178: AND OHI.BATCH_ID = P_batch_id
179: AND OHI.INTERFACE_STATUS = 'S'
180: AND OLI.HEADER_INTERFACE_ID = OHI.HEADER_INTERFACE_ID);

Line 184: DELETE FROM OKS_LINES_INTERFACE

180: AND OLI.HEADER_INTERFACE_ID = OHI.HEADER_INTERFACE_ID);
181:
182: l_stmt_num := 80;
183:
184: DELETE FROM OKS_LINES_INTERFACE
185: WHERE HEADER_INTERFACE_ID IN (SELECT HEADER_INTERFACE_ID FROM OKS_HEADERS_INTERFACE
186: WHERE ROWID BETWEEN l_start_rowid AND l_end_rowid
187: AND BATCH_ID = P_batch_id
188: AND INTERFACE_STATUS = 'S');