APPS.FND_SEED_STAGE_UTIL dependencies on DBMS_SQL

Line 81: l_upload_arr DBMS_SQL.VARCHAR2S;

77:
78: status_csr csr_type;
79: l_str VARCHAR2(4000);
80:
81: l_upload_arr DBMS_SQL.VARCHAR2S;
82: l_upload_stmt VARCHAR2(32767);
83: l_amt BINARY_INTEGER;
84: l_offset INTEGER;
85: l_read_cnt PLS_INTEGER;

Line 162: l_csr := DBMS_SQL.OPEN_CURSOR;

158: EXCEPTION WHEN NO_DATA_FOUND THEN
159: NULL;
160: END;
161:
162: l_csr := DBMS_SQL.OPEN_CURSOR;
163:
164: BEGIN
165: DBMS_SQL.PARSE(l_csr, l_upload_arr, 1, l_read_cnt-1, FALSE, DBMS_SQL.NATIVE);
166: EXCEPTION WHEN OTHERS THEN

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

161:
162: l_csr := DBMS_SQL.OPEN_CURSOR;
163:
164: BEGIN
165: DBMS_SQL.PARSE(l_csr, l_upload_arr, 1, l_read_cnt-1, FALSE, DBMS_SQL.NATIVE);
166: EXCEPTION WHEN OTHERS THEN
167: DBMS_SQL.CLOSE_CURSOR(l_csr);
168: l_msg := SUBSTR('Error parsing the generated plsql wrapper statement '||sqlerrm(sqlcode), 1, 4000);
169: x_abort := 1;

Line 167: DBMS_SQL.CLOSE_CURSOR(l_csr);

163:
164: BEGIN
165: DBMS_SQL.PARSE(l_csr, l_upload_arr, 1, l_read_cnt-1, FALSE, DBMS_SQL.NATIVE);
166: EXCEPTION WHEN OTHERS THEN
167: DBMS_SQL.CLOSE_CURSOR(l_csr);
168: l_msg := SUBSTR('Error parsing the generated plsql wrapper statement '||sqlerrm(sqlcode), 1, 4000);
169: x_abort := 1;
170: x_err_count := 1;
171: x_err_tab(1) := l_msg;

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

171: x_err_tab(1) := l_msg;
172: RETURN;
173: END;
174:
175: l_ret := DBMS_SQL.EXECUTE(l_csr);
176:
177: DBMS_SQL.CLOSE_CURSOR(l_csr);
178:
179: end if;

Line 177: DBMS_SQL.CLOSE_CURSOR(l_csr);

173: END;
174:
175: l_ret := DBMS_SQL.EXECUTE(l_csr);
176:
177: DBMS_SQL.CLOSE_CURSOR(l_csr);
178:
179: end if;
180: END;
181:

Line 220: if DBMS_SQL.IS_OPEN(l_csr) then

216: EXCEPTION WHEN OTHERS THEN
217: if config_csr%ISOPEN then
218: CLOSE config_csr;
219: end if;
220: if DBMS_SQL.IS_OPEN(l_csr) then
221: DBMS_SQL.CLOSE_CURSOR(l_csr);
222: end if;
223: if status_csr%ISOPEN then
224: CLOSE status_csr;

Line 221: DBMS_SQL.CLOSE_CURSOR(l_csr);

217: if config_csr%ISOPEN then
218: CLOSE config_csr;
219: end if;
220: if DBMS_SQL.IS_OPEN(l_csr) then
221: DBMS_SQL.CLOSE_CURSOR(l_csr);
222: end if;
223: if status_csr%ISOPEN then
224: CLOSE status_csr;
225: end if;