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 239: c := dbms_sql.open_cursor;

235:
236: --
237: -- Parse, bind and execute the SQL
238: --
239: c := dbms_sql.open_cursor;
240: dbms_sql.parse(c, statement, dbms_sql.native);
241: dbms_sql.bind_variable(c, 'mv', p_prev_vers_num);
242: dbms_sql.bind_variable(c, 'id', p_header_id);
243: row_processed := dbms_sql.execute(c);

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

236: --
237: -- Parse, bind and execute the SQL
238: --
239: c := dbms_sql.open_cursor;
240: dbms_sql.parse(c, statement, dbms_sql.native);
241: dbms_sql.bind_variable(c, 'mv', p_prev_vers_num);
242: dbms_sql.bind_variable(c, 'id', p_header_id);
243: row_processed := dbms_sql.execute(c);
244: dbms_sql.close_cursor(c);

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

237: -- Parse, bind and execute the SQL
238: --
239: c := dbms_sql.open_cursor;
240: dbms_sql.parse(c, statement, dbms_sql.native);
241: dbms_sql.bind_variable(c, 'mv', p_prev_vers_num);
242: dbms_sql.bind_variable(c, 'id', p_header_id);
243: row_processed := dbms_sql.execute(c);
244: dbms_sql.close_cursor(c);
245:

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

238: --
239: c := dbms_sql.open_cursor;
240: dbms_sql.parse(c, statement, dbms_sql.native);
241: dbms_sql.bind_variable(c, 'mv', p_prev_vers_num);
242: dbms_sql.bind_variable(c, 'id', p_header_id);
243: row_processed := dbms_sql.execute(c);
244: dbms_sql.close_cursor(c);
245:
246:

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

239: c := dbms_sql.open_cursor;
240: dbms_sql.parse(c, statement, dbms_sql.native);
241: dbms_sql.bind_variable(c, 'mv', p_prev_vers_num);
242: dbms_sql.bind_variable(c, 'id', p_header_id);
243: row_processed := dbms_sql.execute(c);
244: dbms_sql.close_cursor(c);
245:
246:
247: --

Line 244: dbms_sql.close_cursor(c);

240: dbms_sql.parse(c, statement, dbms_sql.native);
241: dbms_sql.bind_variable(c, 'mv', p_prev_vers_num);
242: dbms_sql.bind_variable(c, 'id', p_header_id);
243: row_processed := dbms_sql.execute(c);
244: dbms_sql.close_cursor(c);
245:
246:
247: --
248: -- store previous amounts of versions for funding

Line 253: c := dbms_sql.open_cursor;

249: --
250:
251: IF p_table_name='OKE_K_FUNDING_SOURCES' OR p_table_name='OKE_K_FUND_ALLOCATIONS' THEN
252: statement := 'UPDATE '||p_table_name|| ' set PREVIOUS_AMOUNT=AMOUNT WHERE ' ||p_where_clause;
253: c := dbms_sql.open_cursor;
254: dbms_sql.parse(c, statement, dbms_sql.native);
255: dbms_sql.bind_variable(c, 'id', p_header_id);
256: row_processed := dbms_sql.execute(c);
257: dbms_sql.close_cursor(c);

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

250:
251: IF p_table_name='OKE_K_FUNDING_SOURCES' OR p_table_name='OKE_K_FUND_ALLOCATIONS' THEN
252: statement := 'UPDATE '||p_table_name|| ' set PREVIOUS_AMOUNT=AMOUNT WHERE ' ||p_where_clause;
253: c := dbms_sql.open_cursor;
254: dbms_sql.parse(c, statement, dbms_sql.native);
255: dbms_sql.bind_variable(c, 'id', p_header_id);
256: row_processed := dbms_sql.execute(c);
257: dbms_sql.close_cursor(c);
258: END IF;

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

251: IF p_table_name='OKE_K_FUNDING_SOURCES' OR p_table_name='OKE_K_FUND_ALLOCATIONS' THEN
252: statement := 'UPDATE '||p_table_name|| ' set PREVIOUS_AMOUNT=AMOUNT WHERE ' ||p_where_clause;
253: c := dbms_sql.open_cursor;
254: dbms_sql.parse(c, statement, dbms_sql.native);
255: dbms_sql.bind_variable(c, 'id', p_header_id);
256: row_processed := dbms_sql.execute(c);
257: dbms_sql.close_cursor(c);
258: END IF;
259:

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

252: statement := 'UPDATE '||p_table_name|| ' set PREVIOUS_AMOUNT=AMOUNT WHERE ' ||p_where_clause;
253: c := dbms_sql.open_cursor;
254: dbms_sql.parse(c, statement, dbms_sql.native);
255: dbms_sql.bind_variable(c, 'id', p_header_id);
256: row_processed := dbms_sql.execute(c);
257: dbms_sql.close_cursor(c);
258: END IF;
259:
260:

Line 257: dbms_sql.close_cursor(c);

253: c := dbms_sql.open_cursor;
254: dbms_sql.parse(c, statement, dbms_sql.native);
255: dbms_sql.bind_variable(c, 'id', p_header_id);
256: row_processed := dbms_sql.execute(c);
257: dbms_sql.close_cursor(c);
258: END IF;
259:
260:
261:

Line 401: c := dbms_sql.open_cursor;

397:
398: --
399: -- Parse, bind and execute the SQL
400: --
401: c := dbms_sql.open_cursor;
402: dbms_sql.parse(c, statement, dbms_sql.native);
403: dbms_sql.bind_variable(c, 'id', p_header_id);
404: row_processed := dbms_sql.execute(c);
405: dbms_sql.close_cursor(c);

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

398: --
399: -- Parse, bind and execute the SQL
400: --
401: c := dbms_sql.open_cursor;
402: dbms_sql.parse(c, statement, dbms_sql.native);
403: dbms_sql.bind_variable(c, 'id', p_header_id);
404: row_processed := dbms_sql.execute(c);
405: dbms_sql.close_cursor(c);
406:

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

399: -- Parse, bind and execute the SQL
400: --
401: c := dbms_sql.open_cursor;
402: dbms_sql.parse(c, statement, dbms_sql.native);
403: dbms_sql.bind_variable(c, 'id', p_header_id);
404: row_processed := dbms_sql.execute(c);
405: dbms_sql.close_cursor(c);
406:
407: --

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

400: --
401: c := dbms_sql.open_cursor;
402: dbms_sql.parse(c, statement, dbms_sql.native);
403: dbms_sql.bind_variable(c, 'id', p_header_id);
404: row_processed := dbms_sql.execute(c);
405: dbms_sql.close_cursor(c);
406:
407: --
408: -- Now, construct the insert statement.

Line 405: dbms_sql.close_cursor(c);

401: c := dbms_sql.open_cursor;
402: dbms_sql.parse(c, statement, dbms_sql.native);
403: dbms_sql.bind_variable(c, 'id', p_header_id);
404: row_processed := dbms_sql.execute(c);
405: dbms_sql.close_cursor(c);
406:
407: --
408: -- Now, construct the insert statement.
409: --

Line 419: c := dbms_sql.open_cursor;

415:
416: --
417: -- Parse, bind and execute the SQL
418: --
419: c := dbms_sql.open_cursor;
420: dbms_sql.parse(c, statement, dbms_sql.native);
421: dbms_sql.bind_variable(c, 'id', p_header_id);
422: dbms_sql.bind_variable(c, 'mv', p_rstr_from_ver);
423: row_processed := dbms_sql.execute(c);

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

416: --
417: -- Parse, bind and execute the SQL
418: --
419: c := dbms_sql.open_cursor;
420: dbms_sql.parse(c, statement, dbms_sql.native);
421: dbms_sql.bind_variable(c, 'id', p_header_id);
422: dbms_sql.bind_variable(c, 'mv', p_rstr_from_ver);
423: row_processed := dbms_sql.execute(c);
424: dbms_sql.close_cursor(c);

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

417: -- Parse, bind and execute the SQL
418: --
419: c := dbms_sql.open_cursor;
420: dbms_sql.parse(c, statement, dbms_sql.native);
421: dbms_sql.bind_variable(c, 'id', p_header_id);
422: dbms_sql.bind_variable(c, 'mv', p_rstr_from_ver);
423: row_processed := dbms_sql.execute(c);
424: dbms_sql.close_cursor(c);
425:

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

418: --
419: c := dbms_sql.open_cursor;
420: dbms_sql.parse(c, statement, dbms_sql.native);
421: dbms_sql.bind_variable(c, 'id', p_header_id);
422: dbms_sql.bind_variable(c, 'mv', p_rstr_from_ver);
423: row_processed := dbms_sql.execute(c);
424: dbms_sql.close_cursor(c);
425:
426:

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

419: c := dbms_sql.open_cursor;
420: dbms_sql.parse(c, statement, dbms_sql.native);
421: dbms_sql.bind_variable(c, 'id', p_header_id);
422: dbms_sql.bind_variable(c, 'mv', p_rstr_from_ver);
423: row_processed := dbms_sql.execute(c);
424: dbms_sql.close_cursor(c);
425:
426:
427: --

Line 424: dbms_sql.close_cursor(c);

420: dbms_sql.parse(c, statement, dbms_sql.native);
421: dbms_sql.bind_variable(c, 'id', p_header_id);
422: dbms_sql.bind_variable(c, 'mv', p_rstr_from_ver);
423: row_processed := dbms_sql.execute(c);
424: dbms_sql.close_cursor(c);
425:
426:
427: --
428: -- store previous amounts of versions for funding

Line 454: c := dbms_sql.open_cursor;

450: ELSE
451: statement := 'UPDATE '||p_table_name|| ' set PREVIOUS_AMOUNT=(SELECT AMOUNT FROM '||
452: p_hist_table_name ||' WHERE '||p_where_clause||' AND MAJOR_VERSION = :mv)'
453: || 'WHERE ' ||p_where_clause;
454: c := dbms_sql.open_cursor;
455: dbms_sql.parse(c, statement, dbms_sql.native);
456: dbms_sql.bind_variable(c, 'id', p_header_id);
457: row_processed := dbms_sql.execute(c);
458: dbms_sql.close_cursor(c);

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

451: statement := 'UPDATE '||p_table_name|| ' set PREVIOUS_AMOUNT=(SELECT AMOUNT FROM '||
452: p_hist_table_name ||' WHERE '||p_where_clause||' AND MAJOR_VERSION = :mv)'
453: || 'WHERE ' ||p_where_clause;
454: c := dbms_sql.open_cursor;
455: dbms_sql.parse(c, statement, dbms_sql.native);
456: dbms_sql.bind_variable(c, 'id', p_header_id);
457: row_processed := dbms_sql.execute(c);
458: dbms_sql.close_cursor(c);
459: END IF;

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

452: p_hist_table_name ||' WHERE '||p_where_clause||' AND MAJOR_VERSION = :mv)'
453: || 'WHERE ' ||p_where_clause;
454: c := dbms_sql.open_cursor;
455: dbms_sql.parse(c, statement, dbms_sql.native);
456: dbms_sql.bind_variable(c, 'id', p_header_id);
457: row_processed := dbms_sql.execute(c);
458: dbms_sql.close_cursor(c);
459: END IF;
460: */

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

453: || 'WHERE ' ||p_where_clause;
454: c := dbms_sql.open_cursor;
455: dbms_sql.parse(c, statement, dbms_sql.native);
456: dbms_sql.bind_variable(c, 'id', p_header_id);
457: row_processed := dbms_sql.execute(c);
458: dbms_sql.close_cursor(c);
459: END IF;
460: */
461:

Line 458: dbms_sql.close_cursor(c);

454: c := dbms_sql.open_cursor;
455: dbms_sql.parse(c, statement, dbms_sql.native);
456: dbms_sql.bind_variable(c, 'id', p_header_id);
457: row_processed := dbms_sql.execute(c);
458: dbms_sql.close_cursor(c);
459: END IF;
460: */
461:
462: