APPS.OKS_IMPORT_PURGE_WORKER dependencies on OKS_HEADERS_INTERFACE

Line 61: l_table_name varchar2(30) := 'OKS_HEADERS_INTERFACE';

57: IS
58: l_stmt_num NUMBER := 0;
59: l_routine CONSTANT VARCHAR2(30) := 'Worker_purge';
60: l_product varchar2(30) := 'OKS';
61: l_table_name varchar2(30) := 'OKS_HEADERS_INTERFACE';
62: l_update_name varchar2(30);
63: l_status varchar2(30);
64: l_industry varchar2(30);
65: l_retstatus boolean;

Line 76: -- Worker processing for OKS_HEADERS_INTERFACE table

72: l_msg_count NUMBER;
73: l_row_count NUMBER := 0;
74: BEGIN
75: --
76: -- Worker processing for OKS_HEADERS_INTERFACE table
77: --
78: IF G_PROCEDURE_LOG THEN
79: fnd_log.string(fnd_log.level_procedure,
80: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,

Line 135: SELECT count(1) INTO l_row_count FROM OKS_HEADERS_INTERFACE

131:
132: WHILE (l_any_rows_to_process = TRUE)
133: LOOP
134:
135: SELECT count(1) INTO l_row_count FROM OKS_HEADERS_INTERFACE
136: WHERE ROWID BETWEEN l_start_rowid AND l_end_rowid
137: AND BATCH_ID = P_batch_id
138: AND INTERFACE_STATUS = 'S'
139: AND rownum = 1;

Line 146: WHERE HEADER_INTERFACE_ID IN (SELECT HEADER_INTERFACE_ID FROM OKS_HEADERS_INTERFACE

142:
143: l_stmt_num := 40;
144:
145: DELETE FROM OKS_SALES_CREDITS_INTERFACE
146: WHERE HEADER_INTERFACE_ID IN (SELECT HEADER_INTERFACE_ID FROM OKS_HEADERS_INTERFACE
147: WHERE ROWID BETWEEN l_start_rowid AND l_end_rowid
148: AND BATCH_ID = P_batch_id
149: AND INTERFACE_STATUS = 'S');
150: l_stmt_num := 50;

Line 153: WHERE HEADER_INTERFACE_ID IN (SELECT HEADER_INTERFACE_ID FROM OKS_HEADERS_INTERFACE

149: AND INTERFACE_STATUS = 'S');
150: l_stmt_num := 50;
151:
152: DELETE FROM OKS_NOTES_INTERFACE
153: WHERE HEADER_INTERFACE_ID IN (SELECT HEADER_INTERFACE_ID FROM OKS_HEADERS_INTERFACE
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

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 185: WHERE HEADER_INTERFACE_ID IN (SELECT HEADER_INTERFACE_ID FROM OKS_HEADERS_INTERFACE

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

Line 192: DELETE FROM OKS_HEADERS_INTERFACE

188: AND INTERFACE_STATUS = 'S');
189:
190: l_stmt_num := 90;
191:
192: DELETE FROM OKS_HEADERS_INTERFACE
193: WHERE ROWID BETWEEN l_start_rowid AND l_end_rowid
194: AND BATCH_ID = P_batch_id
195: AND INTERFACE_STATUS = 'S';
196: