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

Line 241: l_theCursor := dbms_sql.open_cursor ;

237: l_theStatement varchar2(2000) ;
238: l_theCursor integer ;
239: begin
240:
241: l_theCursor := dbms_sql.open_cursor ;
242: l_theStatement := build_sql( p_table ) ;
243:
244: dbms_sql.parse( l_theCursor, l_theStatement, dbms_sql.v7 ) ;
245: dbms_sql.define_column( l_theCursor, 1 , g_temp_row.id_value) ;

Line 244: dbms_sql.parse( l_theCursor, l_theStatement, dbms_sql.v7 ) ;

240:
241: l_theCursor := dbms_sql.open_cursor ;
242: l_theStatement := build_sql( p_table ) ;
243:
244: dbms_sql.parse( l_theCursor, l_theStatement, dbms_sql.v7 ) ;
245: dbms_sql.define_column( l_theCursor, 1 , g_temp_row.id_value) ;
246: dbms_sql.define_column( l_theCursor, 2 , g_temp_row.effective_start_date) ;
247: dbms_sql.define_column( l_theCursor, 3 , g_temp_row.effective_end_date) ;
248:

Line 245: dbms_sql.define_column( l_theCursor, 1 , g_temp_row.id_value) ;

241: l_theCursor := dbms_sql.open_cursor ;
242: l_theStatement := build_sql( p_table ) ;
243:
244: dbms_sql.parse( l_theCursor, l_theStatement, dbms_sql.v7 ) ;
245: dbms_sql.define_column( l_theCursor, 1 , g_temp_row.id_value) ;
246: dbms_sql.define_column( l_theCursor, 2 , g_temp_row.effective_start_date) ;
247: dbms_sql.define_column( l_theCursor, 3 , g_temp_row.effective_end_date) ;
248:
249: if ( p_table.has_who_cols )

Line 246: dbms_sql.define_column( l_theCursor, 2 , g_temp_row.effective_start_date) ;

242: l_theStatement := build_sql( p_table ) ;
243:
244: dbms_sql.parse( l_theCursor, l_theStatement, dbms_sql.v7 ) ;
245: dbms_sql.define_column( l_theCursor, 1 , g_temp_row.id_value) ;
246: dbms_sql.define_column( l_theCursor, 2 , g_temp_row.effective_start_date) ;
247: dbms_sql.define_column( l_theCursor, 3 , g_temp_row.effective_end_date) ;
248:
249: if ( p_table.has_who_cols )
250: then

Line 247: dbms_sql.define_column( l_theCursor, 3 , g_temp_row.effective_end_date) ;

243:
244: dbms_sql.parse( l_theCursor, l_theStatement, dbms_sql.v7 ) ;
245: dbms_sql.define_column( l_theCursor, 1 , g_temp_row.id_value) ;
246: dbms_sql.define_column( l_theCursor, 2 , g_temp_row.effective_start_date) ;
247: dbms_sql.define_column( l_theCursor, 3 , g_temp_row.effective_end_date) ;
248:
249: if ( p_table.has_who_cols )
250: then
251:

Line 252: dbms_sql.define_column( l_theCursor, 4 , g_temp_row.creation_date) ;

248:
249: if ( p_table.has_who_cols )
250: then
251:
252: dbms_sql.define_column( l_theCursor, 4 , g_temp_row.creation_date) ;
253: dbms_sql.define_column( l_theCursor, 5 , g_temp_row.last_update_date) ;
254:
255: end if;
256:

Line 253: dbms_sql.define_column( l_theCursor, 5 , g_temp_row.last_update_date) ;

249: if ( p_table.has_who_cols )
250: then
251:
252: dbms_sql.define_column( l_theCursor, 4 , g_temp_row.creation_date) ;
253: dbms_sql.define_column( l_theCursor, 5 , g_temp_row.last_update_date) ;
254:
255: end if;
256:
257: return ( l_theCursor ) ;

Line 267: dbms_sql.column_value( p_cursor, 1 , l_theRow.id_value) ;

263: function copy_to_row ( p_cursor in integer , p_table table_info ) return dt_row is
264: l_theRow dt_row ;
265: begin
266:
267: dbms_sql.column_value( p_cursor, 1 , l_theRow.id_value) ;
268: dbms_sql.column_value( p_cursor, 2 , l_theRow.effective_start_date) ;
269: dbms_sql.column_value( p_cursor, 3 , l_theRow.effective_end_date) ;
270:
271: if ( p_table.has_who_cols )

Line 268: dbms_sql.column_value( p_cursor, 2 , l_theRow.effective_start_date) ;

264: l_theRow dt_row ;
265: begin
266:
267: dbms_sql.column_value( p_cursor, 1 , l_theRow.id_value) ;
268: dbms_sql.column_value( p_cursor, 2 , l_theRow.effective_start_date) ;
269: dbms_sql.column_value( p_cursor, 3 , l_theRow.effective_end_date) ;
270:
271: if ( p_table.has_who_cols )
272: then

Line 269: dbms_sql.column_value( p_cursor, 3 , l_theRow.effective_end_date) ;

265: begin
266:
267: dbms_sql.column_value( p_cursor, 1 , l_theRow.id_value) ;
268: dbms_sql.column_value( p_cursor, 2 , l_theRow.effective_start_date) ;
269: dbms_sql.column_value( p_cursor, 3 , l_theRow.effective_end_date) ;
270:
271: if ( p_table.has_who_cols )
272: then
273:

Line 274: dbms_sql.column_value( p_cursor, 4 , l_theRow.creation_date) ;

270:
271: if ( p_table.has_who_cols )
272: then
273:
274: dbms_sql.column_value( p_cursor, 4 , l_theRow.creation_date) ;
275: dbms_sql.column_value( p_cursor, 5 , l_theRow.last_update_date) ;
276:
277: end if;
278:

Line 275: dbms_sql.column_value( p_cursor, 5 , l_theRow.last_update_date) ;

271: if ( p_table.has_who_cols )
272: then
273:
274: dbms_sql.column_value( p_cursor, 4 , l_theRow.creation_date) ;
275: dbms_sql.column_value( p_cursor, 5 , l_theRow.last_update_date) ;
276:
277: end if;
278:
279: return ( l_theRow ) ;

Line 473: l_ignore := dbms_sql.execute(l_cursor) ;

469:
470:
471: l_cursor := prepare_cursor( l_thetable ) ;
472:
473: l_ignore := dbms_sql.execute(l_cursor) ;
474:
475:
476: errors_found := false ;
477: row_count := 0 ;

Line 485: if ( dbms_sql.fetch_rows ( l_cursor ) > 0 ) then

481: total_keys := 0 ;
482:
483: loop
484:
485: if ( dbms_sql.fetch_rows ( l_cursor ) > 0 ) then
486:
487:
488: l_current_row := copy_to_row ( l_cursor , l_thetable ) ;
489: error_text := null ;

Line 533: dbms_sql.close_cursor(l_cursor ) ;

529:
530: end loop ;
531:
532:
533: dbms_sql.close_cursor(l_cursor ) ;
534:
535: if ( errors_found ) then
536:
537: output_table(l_thetable.has_who_cols) ;