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

Line 190: x_cursor_id := dbms_sql.open_cursor ;

186: n_rows_fetched integer ;
187:
188: begin
189:
190: x_cursor_id := dbms_sql.open_cursor ;
191: dbms_sql.parse(x_cursor_id, x_statement, dbms_sql.native) ;
192: dbms_sql.bind_variable_rowid(x_cursor_id, ':x_row_id', current_rowid) ;
193: n_rows_fetched := dbms_sql.execute_and_fetch(x_cursor_id) ;
194: dbms_sql.close_cursor(x_cursor_id) ;

Line 191: dbms_sql.parse(x_cursor_id, x_statement, dbms_sql.native) ;

187:
188: begin
189:
190: x_cursor_id := dbms_sql.open_cursor ;
191: dbms_sql.parse(x_cursor_id, x_statement, dbms_sql.native) ;
192: dbms_sql.bind_variable_rowid(x_cursor_id, ':x_row_id', current_rowid) ;
193: n_rows_fetched := dbms_sql.execute_and_fetch(x_cursor_id) ;
194: dbms_sql.close_cursor(x_cursor_id) ;
195:

Line 192: dbms_sql.bind_variable_rowid(x_cursor_id, ':x_row_id', current_rowid) ;

188: begin
189:
190: x_cursor_id := dbms_sql.open_cursor ;
191: dbms_sql.parse(x_cursor_id, x_statement, dbms_sql.native) ;
192: dbms_sql.bind_variable_rowid(x_cursor_id, ':x_row_id', current_rowid) ;
193: n_rows_fetched := dbms_sql.execute_and_fetch(x_cursor_id) ;
194: dbms_sql.close_cursor(x_cursor_id) ;
195:
196: return (n_rows_fetched > 0) ;

Line 193: n_rows_fetched := dbms_sql.execute_and_fetch(x_cursor_id) ;

189:
190: x_cursor_id := dbms_sql.open_cursor ;
191: dbms_sql.parse(x_cursor_id, x_statement, dbms_sql.native) ;
192: dbms_sql.bind_variable_rowid(x_cursor_id, ':x_row_id', current_rowid) ;
193: n_rows_fetched := dbms_sql.execute_and_fetch(x_cursor_id) ;
194: dbms_sql.close_cursor(x_cursor_id) ;
195:
196: return (n_rows_fetched > 0) ;
197:

Line 194: dbms_sql.close_cursor(x_cursor_id) ;

190: x_cursor_id := dbms_sql.open_cursor ;
191: dbms_sql.parse(x_cursor_id, x_statement, dbms_sql.native) ;
192: dbms_sql.bind_variable_rowid(x_cursor_id, ':x_row_id', current_rowid) ;
193: n_rows_fetched := dbms_sql.execute_and_fetch(x_cursor_id) ;
194: dbms_sql.close_cursor(x_cursor_id) ;
195:
196: return (n_rows_fetched > 0) ;
197:
198: exception when others then

Line 265: x_cursor_id := dbms_sql.open_cursor ;

261: p_column || ' is null and ' ||
262: replace(p_condition, ' ', ' ') ;
263:
264:
265: x_cursor_id := dbms_sql.open_cursor ;
266: dbms_sql.parse(x_cursor_id, x_statement, dbms_sql.native) ;
267: dbms_sql.bind_variable_rowid(x_cursor_id, ':x_row_id', current_rowid) ;
268: x_dummy := dbms_sql.execute(x_cursor_id) ;
269: dbms_sql.close_cursor(x_cursor_id) ;

Line 266: dbms_sql.parse(x_cursor_id, x_statement, dbms_sql.native) ;

262: replace(p_condition, ' ', ' ') ;
263:
264:
265: x_cursor_id := dbms_sql.open_cursor ;
266: dbms_sql.parse(x_cursor_id, x_statement, dbms_sql.native) ;
267: dbms_sql.bind_variable_rowid(x_cursor_id, ':x_row_id', current_rowid) ;
268: x_dummy := dbms_sql.execute(x_cursor_id) ;
269: dbms_sql.close_cursor(x_cursor_id) ;
270:

Line 267: dbms_sql.bind_variable_rowid(x_cursor_id, ':x_row_id', current_rowid) ;

263:
264:
265: x_cursor_id := dbms_sql.open_cursor ;
266: dbms_sql.parse(x_cursor_id, x_statement, dbms_sql.native) ;
267: dbms_sql.bind_variable_rowid(x_cursor_id, ':x_row_id', current_rowid) ;
268: x_dummy := dbms_sql.execute(x_cursor_id) ;
269: dbms_sql.close_cursor(x_cursor_id) ;
270:
271: exception when others then

Line 268: x_dummy := dbms_sql.execute(x_cursor_id) ;

264:
265: x_cursor_id := dbms_sql.open_cursor ;
266: dbms_sql.parse(x_cursor_id, x_statement, dbms_sql.native) ;
267: dbms_sql.bind_variable_rowid(x_cursor_id, ':x_row_id', current_rowid) ;
268: x_dummy := dbms_sql.execute(x_cursor_id) ;
269: dbms_sql.close_cursor(x_cursor_id) ;
270:
271: exception when others then
272: record_error_text(sql_error_prefix || x_statement) ;

Line 269: dbms_sql.close_cursor(x_cursor_id) ;

265: x_cursor_id := dbms_sql.open_cursor ;
266: dbms_sql.parse(x_cursor_id, x_statement, dbms_sql.native) ;
267: dbms_sql.bind_variable_rowid(x_cursor_id, ':x_row_id', current_rowid) ;
268: x_dummy := dbms_sql.execute(x_cursor_id) ;
269: dbms_sql.close_cursor(x_cursor_id) ;
270:
271: exception when others then
272: record_error_text(sql_error_prefix || x_statement) ;
273: abort_request ;