APPS.FND_SEED_STAGE_UTIL dependencies on DBMS_SQL

Line 96: l_upload_arr DBMS_SQL.VARCHAR2S;

92:
93: status_csr csr_type;
94: l_str VARCHAR2(4000);
95:
96: l_upload_arr DBMS_SQL.VARCHAR2S;
97: l_upload_stmt VARCHAR2(32767);
98: l_amt BINARY_INTEGER;
99: l_offset INTEGER;
100: l_read_cnt PLS_INTEGER;

Line 177: l_csr := DBMS_SQL.OPEN_CURSOR;

173: EXCEPTION WHEN NO_DATA_FOUND THEN
174: NULL;
175: END;
176:
177: l_csr := DBMS_SQL.OPEN_CURSOR;
178:
179: BEGIN
180: DBMS_SQL.PARSE(l_csr, l_upload_arr, 1, l_read_cnt-1, FALSE, DBMS_SQL.NATIVE);
181: EXCEPTION WHEN OTHERS THEN

Line 180: DBMS_SQL.PARSE(l_csr, l_upload_arr, 1, l_read_cnt-1, FALSE, DBMS_SQL.NATIVE);

176:
177: l_csr := DBMS_SQL.OPEN_CURSOR;
178:
179: BEGIN
180: DBMS_SQL.PARSE(l_csr, l_upload_arr, 1, l_read_cnt-1, FALSE, DBMS_SQL.NATIVE);
181: EXCEPTION WHEN OTHERS THEN
182: DBMS_SQL.CLOSE_CURSOR(l_csr);
183: l_msg := SUBSTR('Error parsing the generated plsql wrapper statement '||sqlerrm(sqlcode), 1, 4000);
184: x_abort := 1;

Line 182: DBMS_SQL.CLOSE_CURSOR(l_csr);

178:
179: BEGIN
180: DBMS_SQL.PARSE(l_csr, l_upload_arr, 1, l_read_cnt-1, FALSE, DBMS_SQL.NATIVE);
181: EXCEPTION WHEN OTHERS THEN
182: DBMS_SQL.CLOSE_CURSOR(l_csr);
183: l_msg := SUBSTR('Error parsing the generated plsql wrapper statement '||sqlerrm(sqlcode), 1, 4000);
184: x_abort := 1;
185: x_err_count := 1;
186: x_err_tab(1) := l_msg;

Line 190: l_ret := DBMS_SQL.EXECUTE(l_csr);

186: x_err_tab(1) := l_msg;
187: RETURN;
188: END;
189:
190: l_ret := DBMS_SQL.EXECUTE(l_csr);
191:
192: DBMS_SQL.CLOSE_CURSOR(l_csr);
193:
194: end if;

Line 192: DBMS_SQL.CLOSE_CURSOR(l_csr);

188: END;
189:
190: l_ret := DBMS_SQL.EXECUTE(l_csr);
191:
192: DBMS_SQL.CLOSE_CURSOR(l_csr);
193:
194: end if;
195: END;
196:

Line 235: if DBMS_SQL.IS_OPEN(l_csr) then

231: EXCEPTION WHEN OTHERS THEN
232: if config_csr%ISOPEN then
233: CLOSE config_csr;
234: end if;
235: if DBMS_SQL.IS_OPEN(l_csr) then
236: DBMS_SQL.CLOSE_CURSOR(l_csr);
237: end if;
238: if status_csr%ISOPEN then
239: CLOSE status_csr;

Line 236: DBMS_SQL.CLOSE_CURSOR(l_csr);

232: if config_csr%ISOPEN then
233: CLOSE config_csr;
234: end if;
235: if DBMS_SQL.IS_OPEN(l_csr) then
236: DBMS_SQL.CLOSE_CURSOR(l_csr);
237: end if;
238: if status_csr%ISOPEN then
239: CLOSE status_csr;
240: end if;