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.OKE_VERSION_PVT dependencies on DBMS_SQL

Line 218: c := dbms_sql.open_cursor;

214:
215: --
216: -- Parse, bind and execute the SQL
217: --
218: c := dbms_sql.open_cursor;
219: dbms_sql.parse(c, statement, dbms_sql.native);
220: dbms_sql.bind_variable(c, 'mv', p_prev_vers_num);
221: dbms_sql.bind_variable(c, 'id', p_header_id);
222: row_processed := dbms_sql.execute(c);

Line 219: dbms_sql.parse(c, statement, dbms_sql.native);

215: --
216: -- Parse, bind and execute the SQL
217: --
218: c := dbms_sql.open_cursor;
219: dbms_sql.parse(c, statement, dbms_sql.native);
220: dbms_sql.bind_variable(c, 'mv', p_prev_vers_num);
221: dbms_sql.bind_variable(c, 'id', p_header_id);
222: row_processed := dbms_sql.execute(c);
223: dbms_sql.close_cursor(c);

Line 220: dbms_sql.bind_variable(c, 'mv', p_prev_vers_num);

216: -- Parse, bind and execute the SQL
217: --
218: c := dbms_sql.open_cursor;
219: dbms_sql.parse(c, statement, dbms_sql.native);
220: dbms_sql.bind_variable(c, 'mv', p_prev_vers_num);
221: dbms_sql.bind_variable(c, 'id', p_header_id);
222: row_processed := dbms_sql.execute(c);
223: dbms_sql.close_cursor(c);
224:

Line 221: dbms_sql.bind_variable(c, 'id', p_header_id);

217: --
218: c := dbms_sql.open_cursor;
219: dbms_sql.parse(c, statement, dbms_sql.native);
220: dbms_sql.bind_variable(c, 'mv', p_prev_vers_num);
221: dbms_sql.bind_variable(c, 'id', p_header_id);
222: row_processed := dbms_sql.execute(c);
223: dbms_sql.close_cursor(c);
224:
225:

Line 222: row_processed := dbms_sql.execute(c);

218: c := dbms_sql.open_cursor;
219: dbms_sql.parse(c, statement, dbms_sql.native);
220: dbms_sql.bind_variable(c, 'mv', p_prev_vers_num);
221: dbms_sql.bind_variable(c, 'id', p_header_id);
222: row_processed := dbms_sql.execute(c);
223: dbms_sql.close_cursor(c);
224:
225:
226: --

Line 223: dbms_sql.close_cursor(c);

219: dbms_sql.parse(c, statement, dbms_sql.native);
220: dbms_sql.bind_variable(c, 'mv', p_prev_vers_num);
221: dbms_sql.bind_variable(c, 'id', p_header_id);
222: row_processed := dbms_sql.execute(c);
223: dbms_sql.close_cursor(c);
224:
225:
226: --
227: -- store previous amounts of versions for funding

Line 232: c := dbms_sql.open_cursor;

228: --
229:
230: IF p_table_name='OKE_K_FUNDING_SOURCES' OR p_table_name='OKE_K_FUND_ALLOCATIONS' THEN
231: statement := 'UPDATE '||p_table_name|| ' set PREVIOUS_AMOUNT=AMOUNT WHERE ' ||p_where_clause;
232: c := dbms_sql.open_cursor;
233: dbms_sql.parse(c, statement, dbms_sql.native);
234: dbms_sql.bind_variable(c, 'id', p_header_id);
235: row_processed := dbms_sql.execute(c);
236: dbms_sql.close_cursor(c);

Line 233: dbms_sql.parse(c, statement, dbms_sql.native);

229:
230: IF p_table_name='OKE_K_FUNDING_SOURCES' OR p_table_name='OKE_K_FUND_ALLOCATIONS' THEN
231: statement := 'UPDATE '||p_table_name|| ' set PREVIOUS_AMOUNT=AMOUNT WHERE ' ||p_where_clause;
232: c := dbms_sql.open_cursor;
233: dbms_sql.parse(c, statement, dbms_sql.native);
234: dbms_sql.bind_variable(c, 'id', p_header_id);
235: row_processed := dbms_sql.execute(c);
236: dbms_sql.close_cursor(c);
237: END IF;

Line 234: dbms_sql.bind_variable(c, 'id', p_header_id);

230: IF p_table_name='OKE_K_FUNDING_SOURCES' OR p_table_name='OKE_K_FUND_ALLOCATIONS' THEN
231: statement := 'UPDATE '||p_table_name|| ' set PREVIOUS_AMOUNT=AMOUNT WHERE ' ||p_where_clause;
232: c := dbms_sql.open_cursor;
233: dbms_sql.parse(c, statement, dbms_sql.native);
234: dbms_sql.bind_variable(c, 'id', p_header_id);
235: row_processed := dbms_sql.execute(c);
236: dbms_sql.close_cursor(c);
237: END IF;
238:

Line 235: row_processed := dbms_sql.execute(c);

231: statement := 'UPDATE '||p_table_name|| ' set PREVIOUS_AMOUNT=AMOUNT WHERE ' ||p_where_clause;
232: c := dbms_sql.open_cursor;
233: dbms_sql.parse(c, statement, dbms_sql.native);
234: dbms_sql.bind_variable(c, 'id', p_header_id);
235: row_processed := dbms_sql.execute(c);
236: dbms_sql.close_cursor(c);
237: END IF;
238:
239:

Line 236: dbms_sql.close_cursor(c);

232: c := dbms_sql.open_cursor;
233: dbms_sql.parse(c, statement, dbms_sql.native);
234: dbms_sql.bind_variable(c, 'id', p_header_id);
235: row_processed := dbms_sql.execute(c);
236: dbms_sql.close_cursor(c);
237: END IF;
238:
239:
240:

Line 359: c := dbms_sql.open_cursor;

355:
356: --
357: -- Parse, bind and execute the SQL
358: --
359: c := dbms_sql.open_cursor;
360: dbms_sql.parse(c, statement, dbms_sql.native);
361: dbms_sql.bind_variable(c, 'id', p_header_id);
362: row_processed := dbms_sql.execute(c);
363: dbms_sql.close_cursor(c);

Line 360: dbms_sql.parse(c, statement, dbms_sql.native);

356: --
357: -- Parse, bind and execute the SQL
358: --
359: c := dbms_sql.open_cursor;
360: dbms_sql.parse(c, statement, dbms_sql.native);
361: dbms_sql.bind_variable(c, 'id', p_header_id);
362: row_processed := dbms_sql.execute(c);
363: dbms_sql.close_cursor(c);
364:

Line 361: dbms_sql.bind_variable(c, 'id', p_header_id);

357: -- Parse, bind and execute the SQL
358: --
359: c := dbms_sql.open_cursor;
360: dbms_sql.parse(c, statement, dbms_sql.native);
361: dbms_sql.bind_variable(c, 'id', p_header_id);
362: row_processed := dbms_sql.execute(c);
363: dbms_sql.close_cursor(c);
364:
365: --

Line 362: row_processed := dbms_sql.execute(c);

358: --
359: c := dbms_sql.open_cursor;
360: dbms_sql.parse(c, statement, dbms_sql.native);
361: dbms_sql.bind_variable(c, 'id', p_header_id);
362: row_processed := dbms_sql.execute(c);
363: dbms_sql.close_cursor(c);
364:
365: --
366: -- Now, construct the insert statement.

Line 363: dbms_sql.close_cursor(c);

359: c := dbms_sql.open_cursor;
360: dbms_sql.parse(c, statement, dbms_sql.native);
361: dbms_sql.bind_variable(c, 'id', p_header_id);
362: row_processed := dbms_sql.execute(c);
363: dbms_sql.close_cursor(c);
364:
365: --
366: -- Now, construct the insert statement.
367: --

Line 377: c := dbms_sql.open_cursor;

373:
374: --
375: -- Parse, bind and execute the SQL
376: --
377: c := dbms_sql.open_cursor;
378: dbms_sql.parse(c, statement, dbms_sql.native);
379: dbms_sql.bind_variable(c, 'id', p_header_id);
380: dbms_sql.bind_variable(c, 'mv', p_rstr_from_ver);
381: row_processed := dbms_sql.execute(c);

Line 378: dbms_sql.parse(c, statement, dbms_sql.native);

374: --
375: -- Parse, bind and execute the SQL
376: --
377: c := dbms_sql.open_cursor;
378: dbms_sql.parse(c, statement, dbms_sql.native);
379: dbms_sql.bind_variable(c, 'id', p_header_id);
380: dbms_sql.bind_variable(c, 'mv', p_rstr_from_ver);
381: row_processed := dbms_sql.execute(c);
382: dbms_sql.close_cursor(c);

Line 379: dbms_sql.bind_variable(c, 'id', p_header_id);

375: -- Parse, bind and execute the SQL
376: --
377: c := dbms_sql.open_cursor;
378: dbms_sql.parse(c, statement, dbms_sql.native);
379: dbms_sql.bind_variable(c, 'id', p_header_id);
380: dbms_sql.bind_variable(c, 'mv', p_rstr_from_ver);
381: row_processed := dbms_sql.execute(c);
382: dbms_sql.close_cursor(c);
383:

Line 380: dbms_sql.bind_variable(c, 'mv', p_rstr_from_ver);

376: --
377: c := dbms_sql.open_cursor;
378: dbms_sql.parse(c, statement, dbms_sql.native);
379: dbms_sql.bind_variable(c, 'id', p_header_id);
380: dbms_sql.bind_variable(c, 'mv', p_rstr_from_ver);
381: row_processed := dbms_sql.execute(c);
382: dbms_sql.close_cursor(c);
383:
384:

Line 381: row_processed := dbms_sql.execute(c);

377: c := dbms_sql.open_cursor;
378: dbms_sql.parse(c, statement, dbms_sql.native);
379: dbms_sql.bind_variable(c, 'id', p_header_id);
380: dbms_sql.bind_variable(c, 'mv', p_rstr_from_ver);
381: row_processed := dbms_sql.execute(c);
382: dbms_sql.close_cursor(c);
383:
384:
385: --

Line 382: dbms_sql.close_cursor(c);

378: dbms_sql.parse(c, statement, dbms_sql.native);
379: dbms_sql.bind_variable(c, 'id', p_header_id);
380: dbms_sql.bind_variable(c, 'mv', p_rstr_from_ver);
381: row_processed := dbms_sql.execute(c);
382: dbms_sql.close_cursor(c);
383:
384:
385: --
386: -- store previous amounts of versions for funding

Line 412: c := dbms_sql.open_cursor;

408: ELSE
409: statement := 'UPDATE '||p_table_name|| ' set PREVIOUS_AMOUNT=(SELECT AMOUNT FROM '||
410: p_hist_table_name ||' WHERE '||p_where_clause||' AND MAJOR_VERSION = :mv)'
411: || 'WHERE ' ||p_where_clause;
412: c := dbms_sql.open_cursor;
413: dbms_sql.parse(c, statement, dbms_sql.native);
414: dbms_sql.bind_variable(c, 'id', p_header_id);
415: row_processed := dbms_sql.execute(c);
416: dbms_sql.close_cursor(c);

Line 413: dbms_sql.parse(c, statement, dbms_sql.native);

409: statement := 'UPDATE '||p_table_name|| ' set PREVIOUS_AMOUNT=(SELECT AMOUNT FROM '||
410: p_hist_table_name ||' WHERE '||p_where_clause||' AND MAJOR_VERSION = :mv)'
411: || 'WHERE ' ||p_where_clause;
412: c := dbms_sql.open_cursor;
413: dbms_sql.parse(c, statement, dbms_sql.native);
414: dbms_sql.bind_variable(c, 'id', p_header_id);
415: row_processed := dbms_sql.execute(c);
416: dbms_sql.close_cursor(c);
417: END IF;

Line 414: dbms_sql.bind_variable(c, 'id', p_header_id);

410: p_hist_table_name ||' WHERE '||p_where_clause||' AND MAJOR_VERSION = :mv)'
411: || 'WHERE ' ||p_where_clause;
412: c := dbms_sql.open_cursor;
413: dbms_sql.parse(c, statement, dbms_sql.native);
414: dbms_sql.bind_variable(c, 'id', p_header_id);
415: row_processed := dbms_sql.execute(c);
416: dbms_sql.close_cursor(c);
417: END IF;
418: */

Line 415: row_processed := dbms_sql.execute(c);

411: || 'WHERE ' ||p_where_clause;
412: c := dbms_sql.open_cursor;
413: dbms_sql.parse(c, statement, dbms_sql.native);
414: dbms_sql.bind_variable(c, 'id', p_header_id);
415: row_processed := dbms_sql.execute(c);
416: dbms_sql.close_cursor(c);
417: END IF;
418: */
419:

Line 416: dbms_sql.close_cursor(c);

412: c := dbms_sql.open_cursor;
413: dbms_sql.parse(c, statement, dbms_sql.native);
414: dbms_sql.bind_variable(c, 'id', p_header_id);
415: row_processed := dbms_sql.execute(c);
416: dbms_sql.close_cursor(c);
417: END IF;
418: */
419:
420: