eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CE_FORECAST_REMOTE_SOURCES dependencies on DBMS_SQL

Line 68: cursor_id := DBMS_SQL.open_cursor;

64:
65: BEGIN
66: BEGIN
67: main_query1 := 'SELECT count(*) from ' || source_view;
68: cursor_id := DBMS_SQL.open_cursor;
69: DBMS_SQL.Parse(cursor_id, main_query1, DBMS_SQL.v7);
70: DBMS_SQL.Define_Column(cursor_id, 1, dummy);
71: exec_id := dbms_sql.execute(cursor_id);
72: DBMS_SQL.CLOSE_CURSOR(CURSOR_ID);

Line 69: DBMS_SQL.Parse(cursor_id, main_query1, DBMS_SQL.v7);

65: BEGIN
66: BEGIN
67: main_query1 := 'SELECT count(*) from ' || source_view;
68: cursor_id := DBMS_SQL.open_cursor;
69: DBMS_SQL.Parse(cursor_id, main_query1, DBMS_SQL.v7);
70: DBMS_SQL.Define_Column(cursor_id, 1, dummy);
71: exec_id := dbms_sql.execute(cursor_id);
72: DBMS_SQL.CLOSE_CURSOR(CURSOR_ID);
73: EXCEPTION

Line 70: DBMS_SQL.Define_Column(cursor_id, 1, dummy);

66: BEGIN
67: main_query1 := 'SELECT count(*) from ' || source_view;
68: cursor_id := DBMS_SQL.open_cursor;
69: DBMS_SQL.Parse(cursor_id, main_query1, DBMS_SQL.v7);
70: DBMS_SQL.Define_Column(cursor_id, 1, dummy);
71: exec_id := dbms_sql.execute(cursor_id);
72: DBMS_SQL.CLOSE_CURSOR(CURSOR_ID);
73: EXCEPTION
74: WHEN OTHERS THEN

Line 71: exec_id := dbms_sql.execute(cursor_id);

67: main_query1 := 'SELECT count(*) from ' || source_view;
68: cursor_id := DBMS_SQL.open_cursor;
69: DBMS_SQL.Parse(cursor_id, main_query1, DBMS_SQL.v7);
70: DBMS_SQL.Define_Column(cursor_id, 1, dummy);
71: exec_id := dbms_sql.execute(cursor_id);
72: DBMS_SQL.CLOSE_CURSOR(CURSOR_ID);
73: EXCEPTION
74: WHEN OTHERS THEN
75: IF DBMS_SQL.is_open(cursor_id) THEN

Line 72: DBMS_SQL.CLOSE_CURSOR(CURSOR_ID);

68: cursor_id := DBMS_SQL.open_cursor;
69: DBMS_SQL.Parse(cursor_id, main_query1, DBMS_SQL.v7);
70: DBMS_SQL.Define_Column(cursor_id, 1, dummy);
71: exec_id := dbms_sql.execute(cursor_id);
72: DBMS_SQL.CLOSE_CURSOR(CURSOR_ID);
73: EXCEPTION
74: WHEN OTHERS THEN
75: IF DBMS_SQL.is_open(cursor_id) THEN
76: DBMS_SQL.close_cursor(cursor_id);

Line 75: IF DBMS_SQL.is_open(cursor_id) THEN

71: exec_id := dbms_sql.execute(cursor_id);
72: DBMS_SQL.CLOSE_CURSOR(CURSOR_ID);
73: EXCEPTION
74: WHEN OTHERS THEN
75: IF DBMS_SQL.is_open(cursor_id) THEN
76: DBMS_SQL.close_cursor(cursor_id);
77: END IF;
78: return (-1);
79: END;

Line 76: DBMS_SQL.close_cursor(cursor_id);

72: DBMS_SQL.CLOSE_CURSOR(CURSOR_ID);
73: EXCEPTION
74: WHEN OTHERS THEN
75: IF DBMS_SQL.is_open(cursor_id) THEN
76: DBMS_SQL.close_cursor(cursor_id);
77: END IF;
78: return (-1);
79: END;
80:

Line 204: cursor_id := DBMS_SQL.open_cursor;

200: --
201: -- Execute the dynamic SQL statement and prepare the forecast values into
202: -- amount_table, which will be returned to the local database
203: --
204: cursor_id := DBMS_SQL.open_cursor;
205:
206: DBMS_SQL.Parse(cursor_id, main_query1, DBMS_SQL.v7);
207:
208: DBMS_SQL.Define_Column(cursor_id, 1, forecast_column_id);

Line 206: DBMS_SQL.Parse(cursor_id, main_query1, DBMS_SQL.v7);

202: -- amount_table, which will be returned to the local database
203: --
204: cursor_id := DBMS_SQL.open_cursor;
205:
206: DBMS_SQL.Parse(cursor_id, main_query1, DBMS_SQL.v7);
207:
208: DBMS_SQL.Define_Column(cursor_id, 1, forecast_column_id);
209: DBMS_SQL.Define_Column(cursor_id, 2, forecast_amount);
210: DBMS_SQL.Define_Column(cursor_id, 3, trx_amount);

Line 208: DBMS_SQL.Define_Column(cursor_id, 1, forecast_column_id);

204: cursor_id := DBMS_SQL.open_cursor;
205:
206: DBMS_SQL.Parse(cursor_id, main_query1, DBMS_SQL.v7);
207:
208: DBMS_SQL.Define_Column(cursor_id, 1, forecast_column_id);
209: DBMS_SQL.Define_Column(cursor_id, 2, forecast_amount);
210: DBMS_SQL.Define_Column(cursor_id, 3, trx_amount);
211: DBMS_SQL.Define_Column(cursor_id, 4, currency_code,15);
212: DBMS_SQL.Define_Column(cursor_id, 5, trx_date);

Line 209: DBMS_SQL.Define_Column(cursor_id, 2, forecast_amount);

205:
206: DBMS_SQL.Parse(cursor_id, main_query1, DBMS_SQL.v7);
207:
208: DBMS_SQL.Define_Column(cursor_id, 1, forecast_column_id);
209: DBMS_SQL.Define_Column(cursor_id, 2, forecast_amount);
210: DBMS_SQL.Define_Column(cursor_id, 3, trx_amount);
211: DBMS_SQL.Define_Column(cursor_id, 4, currency_code,15);
212: DBMS_SQL.Define_Column(cursor_id, 5, trx_date);
213: DBMS_SQL.Define_Column(cursor_id, 6, bank_account_id);

Line 210: DBMS_SQL.Define_Column(cursor_id, 3, trx_amount);

206: DBMS_SQL.Parse(cursor_id, main_query1, DBMS_SQL.v7);
207:
208: DBMS_SQL.Define_Column(cursor_id, 1, forecast_column_id);
209: DBMS_SQL.Define_Column(cursor_id, 2, forecast_amount);
210: DBMS_SQL.Define_Column(cursor_id, 3, trx_amount);
211: DBMS_SQL.Define_Column(cursor_id, 4, currency_code,15);
212: DBMS_SQL.Define_Column(cursor_id, 5, trx_date);
213: DBMS_SQL.Define_Column(cursor_id, 6, bank_account_id);
214:

Line 211: DBMS_SQL.Define_Column(cursor_id, 4, currency_code,15);

207:
208: DBMS_SQL.Define_Column(cursor_id, 1, forecast_column_id);
209: DBMS_SQL.Define_Column(cursor_id, 2, forecast_amount);
210: DBMS_SQL.Define_Column(cursor_id, 3, trx_amount);
211: DBMS_SQL.Define_Column(cursor_id, 4, currency_code,15);
212: DBMS_SQL.Define_Column(cursor_id, 5, trx_date);
213: DBMS_SQL.Define_Column(cursor_id, 6, bank_account_id);
214:
215: exec_id := dbms_sql.execute(cursor_id);

Line 212: DBMS_SQL.Define_Column(cursor_id, 5, trx_date);

208: DBMS_SQL.Define_Column(cursor_id, 1, forecast_column_id);
209: DBMS_SQL.Define_Column(cursor_id, 2, forecast_amount);
210: DBMS_SQL.Define_Column(cursor_id, 3, trx_amount);
211: DBMS_SQL.Define_Column(cursor_id, 4, currency_code,15);
212: DBMS_SQL.Define_Column(cursor_id, 5, trx_date);
213: DBMS_SQL.Define_Column(cursor_id, 6, bank_account_id);
214:
215: exec_id := dbms_sql.execute(cursor_id);
216: i := 0;

Line 213: DBMS_SQL.Define_Column(cursor_id, 6, bank_account_id);

209: DBMS_SQL.Define_Column(cursor_id, 2, forecast_amount);
210: DBMS_SQL.Define_Column(cursor_id, 3, trx_amount);
211: DBMS_SQL.Define_Column(cursor_id, 4, currency_code,15);
212: DBMS_SQL.Define_Column(cursor_id, 5, trx_date);
213: DBMS_SQL.Define_Column(cursor_id, 6, bank_account_id);
214:
215: exec_id := dbms_sql.execute(cursor_id);
216: i := 0;
217: LOOP

Line 215: exec_id := dbms_sql.execute(cursor_id);

211: DBMS_SQL.Define_Column(cursor_id, 4, currency_code,15);
212: DBMS_SQL.Define_Column(cursor_id, 5, trx_date);
213: DBMS_SQL.Define_Column(cursor_id, 6, bank_account_id);
214:
215: exec_id := dbms_sql.execute(cursor_id);
216: i := 0;
217: LOOP
218: IF (DBMS_SQL.FETCH_ROWS(cursor_id) >0 ) THEN
219: DBMS_SQL.COLUMN_VALUE(cursor_id, 1, forecast_column_id);

Line 218: IF (DBMS_SQL.FETCH_ROWS(cursor_id) >0 ) THEN

214:
215: exec_id := dbms_sql.execute(cursor_id);
216: i := 0;
217: LOOP
218: IF (DBMS_SQL.FETCH_ROWS(cursor_id) >0 ) THEN
219: DBMS_SQL.COLUMN_VALUE(cursor_id, 1, forecast_column_id);
220: DBMS_SQL.COLUMN_VALUE(cursor_id, 2, forecast_amount);
221: DBMS_SQL.COLUMN_VALUE(cursor_id, 3, trx_amount);
222: DBMS_SQL.COLUMN_VALUE(cursor_id, 4, currency_code);

Line 219: DBMS_SQL.COLUMN_VALUE(cursor_id, 1, forecast_column_id);

215: exec_id := dbms_sql.execute(cursor_id);
216: i := 0;
217: LOOP
218: IF (DBMS_SQL.FETCH_ROWS(cursor_id) >0 ) THEN
219: DBMS_SQL.COLUMN_VALUE(cursor_id, 1, forecast_column_id);
220: DBMS_SQL.COLUMN_VALUE(cursor_id, 2, forecast_amount);
221: DBMS_SQL.COLUMN_VALUE(cursor_id, 3, trx_amount);
222: DBMS_SQL.COLUMN_VALUE(cursor_id, 4, currency_code);
223: DBMS_SQL.COLUMN_VALUE(cursor_id, 5, trx_date);

Line 220: DBMS_SQL.COLUMN_VALUE(cursor_id, 2, forecast_amount);

216: i := 0;
217: LOOP
218: IF (DBMS_SQL.FETCH_ROWS(cursor_id) >0 ) THEN
219: DBMS_SQL.COLUMN_VALUE(cursor_id, 1, forecast_column_id);
220: DBMS_SQL.COLUMN_VALUE(cursor_id, 2, forecast_amount);
221: DBMS_SQL.COLUMN_VALUE(cursor_id, 3, trx_amount);
222: DBMS_SQL.COLUMN_VALUE(cursor_id, 4, currency_code);
223: DBMS_SQL.COLUMN_VALUE(cursor_id, 5, trx_date);
224: DBMS_SQL.COLUMN_VALUE(cursor_id, 6, bank_account_id);

Line 221: DBMS_SQL.COLUMN_VALUE(cursor_id, 3, trx_amount);

217: LOOP
218: IF (DBMS_SQL.FETCH_ROWS(cursor_id) >0 ) THEN
219: DBMS_SQL.COLUMN_VALUE(cursor_id, 1, forecast_column_id);
220: DBMS_SQL.COLUMN_VALUE(cursor_id, 2, forecast_amount);
221: DBMS_SQL.COLUMN_VALUE(cursor_id, 3, trx_amount);
222: DBMS_SQL.COLUMN_VALUE(cursor_id, 4, currency_code);
223: DBMS_SQL.COLUMN_VALUE(cursor_id, 5, trx_date);
224: DBMS_SQL.COLUMN_VALUE(cursor_id, 6, bank_account_id);
225:

Line 222: DBMS_SQL.COLUMN_VALUE(cursor_id, 4, currency_code);

218: IF (DBMS_SQL.FETCH_ROWS(cursor_id) >0 ) THEN
219: DBMS_SQL.COLUMN_VALUE(cursor_id, 1, forecast_column_id);
220: DBMS_SQL.COLUMN_VALUE(cursor_id, 2, forecast_amount);
221: DBMS_SQL.COLUMN_VALUE(cursor_id, 3, trx_amount);
222: DBMS_SQL.COLUMN_VALUE(cursor_id, 4, currency_code);
223: DBMS_SQL.COLUMN_VALUE(cursor_id, 5, trx_date);
224: DBMS_SQL.COLUMN_VALUE(cursor_id, 6, bank_account_id);
225:
226: i := i + 1;

Line 223: DBMS_SQL.COLUMN_VALUE(cursor_id, 5, trx_date);

219: DBMS_SQL.COLUMN_VALUE(cursor_id, 1, forecast_column_id);
220: DBMS_SQL.COLUMN_VALUE(cursor_id, 2, forecast_amount);
221: DBMS_SQL.COLUMN_VALUE(cursor_id, 3, trx_amount);
222: DBMS_SQL.COLUMN_VALUE(cursor_id, 4, currency_code);
223: DBMS_SQL.COLUMN_VALUE(cursor_id, 5, trx_date);
224: DBMS_SQL.COLUMN_VALUE(cursor_id, 6, bank_account_id);
225:
226: i := i + 1;
227: amount_table(i).forecast_column_id := forecast_column_id;

Line 224: DBMS_SQL.COLUMN_VALUE(cursor_id, 6, bank_account_id);

220: DBMS_SQL.COLUMN_VALUE(cursor_id, 2, forecast_amount);
221: DBMS_SQL.COLUMN_VALUE(cursor_id, 3, trx_amount);
222: DBMS_SQL.COLUMN_VALUE(cursor_id, 4, currency_code);
223: DBMS_SQL.COLUMN_VALUE(cursor_id, 5, trx_date);
224: DBMS_SQL.COLUMN_VALUE(cursor_id, 6, bank_account_id);
225:
226: i := i + 1;
227: amount_table(i).forecast_column_id := forecast_column_id;
228: amount_table(i).forecast_amount := forecast_amount;

Line 237: DBMS_SQL.close_cursor(cursor_id);

233: ELSE
234: EXIT;
235: END IF;
236: END LOOP;
237: DBMS_SQL.close_cursor(cursor_id);
238: EXCEPTION
239: WHEN OTHERS THEN
240: IF DBMS_SQL.is_open(cursor_id) THEN
241: DBMS_SQL.close_cursor(cursor_id);

Line 240: IF DBMS_SQL.is_open(cursor_id) THEN

236: END LOOP;
237: DBMS_SQL.close_cursor(cursor_id);
238: EXCEPTION
239: WHEN OTHERS THEN
240: IF DBMS_SQL.is_open(cursor_id) THEN
241: DBMS_SQL.close_cursor(cursor_id);
242: END IF;
243: cursor_id := DBMS_SQL.open_cursor;
244:

Line 241: DBMS_SQL.close_cursor(cursor_id);

237: DBMS_SQL.close_cursor(cursor_id);
238: EXCEPTION
239: WHEN OTHERS THEN
240: IF DBMS_SQL.is_open(cursor_id) THEN
241: DBMS_SQL.close_cursor(cursor_id);
242: END IF;
243: cursor_id := DBMS_SQL.open_cursor;
244:
245: DBMS_SQL.Parse(cursor_id, main_query2, DBMS_SQL.v7);

Line 243: cursor_id := DBMS_SQL.open_cursor;

239: WHEN OTHERS THEN
240: IF DBMS_SQL.is_open(cursor_id) THEN
241: DBMS_SQL.close_cursor(cursor_id);
242: END IF;
243: cursor_id := DBMS_SQL.open_cursor;
244:
245: DBMS_SQL.Parse(cursor_id, main_query2, DBMS_SQL.v7);
246:
247: DBMS_SQL.Define_Column(cursor_id, 1, forecast_column_id);

Line 245: DBMS_SQL.Parse(cursor_id, main_query2, DBMS_SQL.v7);

241: DBMS_SQL.close_cursor(cursor_id);
242: END IF;
243: cursor_id := DBMS_SQL.open_cursor;
244:
245: DBMS_SQL.Parse(cursor_id, main_query2, DBMS_SQL.v7);
246:
247: DBMS_SQL.Define_Column(cursor_id, 1, forecast_column_id);
248: DBMS_SQL.Define_Column(cursor_id, 2, forecast_amount);
249: DBMS_SQL.Define_Column(cursor_id, 3, trx_amount);

Line 247: DBMS_SQL.Define_Column(cursor_id, 1, forecast_column_id);

243: cursor_id := DBMS_SQL.open_cursor;
244:
245: DBMS_SQL.Parse(cursor_id, main_query2, DBMS_SQL.v7);
246:
247: DBMS_SQL.Define_Column(cursor_id, 1, forecast_column_id);
248: DBMS_SQL.Define_Column(cursor_id, 2, forecast_amount);
249: DBMS_SQL.Define_Column(cursor_id, 3, trx_amount);
250: DBMS_SQL.Define_Column(cursor_id, 4, currency_code,15);
251: DBMS_SQL.Define_Column(cursor_id, 5, trx_date);

Line 248: DBMS_SQL.Define_Column(cursor_id, 2, forecast_amount);

244:
245: DBMS_SQL.Parse(cursor_id, main_query2, DBMS_SQL.v7);
246:
247: DBMS_SQL.Define_Column(cursor_id, 1, forecast_column_id);
248: DBMS_SQL.Define_Column(cursor_id, 2, forecast_amount);
249: DBMS_SQL.Define_Column(cursor_id, 3, trx_amount);
250: DBMS_SQL.Define_Column(cursor_id, 4, currency_code,15);
251: DBMS_SQL.Define_Column(cursor_id, 5, trx_date);
252:

Line 249: DBMS_SQL.Define_Column(cursor_id, 3, trx_amount);

245: DBMS_SQL.Parse(cursor_id, main_query2, DBMS_SQL.v7);
246:
247: DBMS_SQL.Define_Column(cursor_id, 1, forecast_column_id);
248: DBMS_SQL.Define_Column(cursor_id, 2, forecast_amount);
249: DBMS_SQL.Define_Column(cursor_id, 3, trx_amount);
250: DBMS_SQL.Define_Column(cursor_id, 4, currency_code,15);
251: DBMS_SQL.Define_Column(cursor_id, 5, trx_date);
252:
253: exec_id := dbms_sql.execute(cursor_id);

Line 250: DBMS_SQL.Define_Column(cursor_id, 4, currency_code,15);

246:
247: DBMS_SQL.Define_Column(cursor_id, 1, forecast_column_id);
248: DBMS_SQL.Define_Column(cursor_id, 2, forecast_amount);
249: DBMS_SQL.Define_Column(cursor_id, 3, trx_amount);
250: DBMS_SQL.Define_Column(cursor_id, 4, currency_code,15);
251: DBMS_SQL.Define_Column(cursor_id, 5, trx_date);
252:
253: exec_id := dbms_sql.execute(cursor_id);
254: i := 0;

Line 251: DBMS_SQL.Define_Column(cursor_id, 5, trx_date);

247: DBMS_SQL.Define_Column(cursor_id, 1, forecast_column_id);
248: DBMS_SQL.Define_Column(cursor_id, 2, forecast_amount);
249: DBMS_SQL.Define_Column(cursor_id, 3, trx_amount);
250: DBMS_SQL.Define_Column(cursor_id, 4, currency_code,15);
251: DBMS_SQL.Define_Column(cursor_id, 5, trx_date);
252:
253: exec_id := dbms_sql.execute(cursor_id);
254: i := 0;
255: LOOP

Line 253: exec_id := dbms_sql.execute(cursor_id);

249: DBMS_SQL.Define_Column(cursor_id, 3, trx_amount);
250: DBMS_SQL.Define_Column(cursor_id, 4, currency_code,15);
251: DBMS_SQL.Define_Column(cursor_id, 5, trx_date);
252:
253: exec_id := dbms_sql.execute(cursor_id);
254: i := 0;
255: LOOP
256: IF (DBMS_SQL.FETCH_ROWS(cursor_id) >0 ) THEN
257: DBMS_SQL.COLUMN_VALUE(cursor_id, 1, forecast_column_id);

Line 256: IF (DBMS_SQL.FETCH_ROWS(cursor_id) >0 ) THEN

252:
253: exec_id := dbms_sql.execute(cursor_id);
254: i := 0;
255: LOOP
256: IF (DBMS_SQL.FETCH_ROWS(cursor_id) >0 ) THEN
257: DBMS_SQL.COLUMN_VALUE(cursor_id, 1, forecast_column_id);
258: DBMS_SQL.COLUMN_VALUE(cursor_id, 2, forecast_amount);
259: DBMS_SQL.COLUMN_VALUE(cursor_id, 3, trx_amount);
260: DBMS_SQL.COLUMN_VALUE(cursor_id, 4, currency_code);

Line 257: DBMS_SQL.COLUMN_VALUE(cursor_id, 1, forecast_column_id);

253: exec_id := dbms_sql.execute(cursor_id);
254: i := 0;
255: LOOP
256: IF (DBMS_SQL.FETCH_ROWS(cursor_id) >0 ) THEN
257: DBMS_SQL.COLUMN_VALUE(cursor_id, 1, forecast_column_id);
258: DBMS_SQL.COLUMN_VALUE(cursor_id, 2, forecast_amount);
259: DBMS_SQL.COLUMN_VALUE(cursor_id, 3, trx_amount);
260: DBMS_SQL.COLUMN_VALUE(cursor_id, 4, currency_code);
261: DBMS_SQL.COLUMN_VALUE(cursor_id, 5, trx_date);

Line 258: DBMS_SQL.COLUMN_VALUE(cursor_id, 2, forecast_amount);

254: i := 0;
255: LOOP
256: IF (DBMS_SQL.FETCH_ROWS(cursor_id) >0 ) THEN
257: DBMS_SQL.COLUMN_VALUE(cursor_id, 1, forecast_column_id);
258: DBMS_SQL.COLUMN_VALUE(cursor_id, 2, forecast_amount);
259: DBMS_SQL.COLUMN_VALUE(cursor_id, 3, trx_amount);
260: DBMS_SQL.COLUMN_VALUE(cursor_id, 4, currency_code);
261: DBMS_SQL.COLUMN_VALUE(cursor_id, 5, trx_date);
262:

Line 259: DBMS_SQL.COLUMN_VALUE(cursor_id, 3, trx_amount);

255: LOOP
256: IF (DBMS_SQL.FETCH_ROWS(cursor_id) >0 ) THEN
257: DBMS_SQL.COLUMN_VALUE(cursor_id, 1, forecast_column_id);
258: DBMS_SQL.COLUMN_VALUE(cursor_id, 2, forecast_amount);
259: DBMS_SQL.COLUMN_VALUE(cursor_id, 3, trx_amount);
260: DBMS_SQL.COLUMN_VALUE(cursor_id, 4, currency_code);
261: DBMS_SQL.COLUMN_VALUE(cursor_id, 5, trx_date);
262:
263: i := i + 1;

Line 260: DBMS_SQL.COLUMN_VALUE(cursor_id, 4, currency_code);

256: IF (DBMS_SQL.FETCH_ROWS(cursor_id) >0 ) THEN
257: DBMS_SQL.COLUMN_VALUE(cursor_id, 1, forecast_column_id);
258: DBMS_SQL.COLUMN_VALUE(cursor_id, 2, forecast_amount);
259: DBMS_SQL.COLUMN_VALUE(cursor_id, 3, trx_amount);
260: DBMS_SQL.COLUMN_VALUE(cursor_id, 4, currency_code);
261: DBMS_SQL.COLUMN_VALUE(cursor_id, 5, trx_date);
262:
263: i := i + 1;
264: amount_table(i).forecast_column_id := forecast_column_id;

Line 261: DBMS_SQL.COLUMN_VALUE(cursor_id, 5, trx_date);

257: DBMS_SQL.COLUMN_VALUE(cursor_id, 1, forecast_column_id);
258: DBMS_SQL.COLUMN_VALUE(cursor_id, 2, forecast_amount);
259: DBMS_SQL.COLUMN_VALUE(cursor_id, 3, trx_amount);
260: DBMS_SQL.COLUMN_VALUE(cursor_id, 4, currency_code);
261: DBMS_SQL.COLUMN_VALUE(cursor_id, 5, trx_date);
262:
263: i := i + 1;
264: amount_table(i).forecast_column_id := forecast_column_id;
265: amount_table(i).forecast_amount := forecast_amount;

Line 274: DBMS_SQL.close_cursor(cursor_id);

270: ELSE
271: EXIT;
272: END IF;
273: END LOOP;
274: DBMS_SQL.close_cursor(cursor_id);
275:
276: END;
277:
278: --

Line 293: IF DBMS_SQL.is_open(cursor_id) THEN

289: return (0);
290:
291: EXCEPTION
292: WHEN OTHERS THEN
293: IF DBMS_SQL.is_open(cursor_id) THEN
294: DBMS_SQL.close_cursor(cursor_id);
295: END IF;
296: return (-3);
297: END Populate_Remote_Amounts;

Line 294: DBMS_SQL.close_cursor(cursor_id);

290:
291: EXCEPTION
292: WHEN OTHERS THEN
293: IF DBMS_SQL.is_open(cursor_id) THEN
294: DBMS_SQL.close_cursor(cursor_id);
295: END IF;
296: return (-3);
297: END Populate_Remote_Amounts;
298: