APPS.DT_CHECKINT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 19

			  last_update_date     date  ) ;

Line: 36

  g_tab_last_update_date     tab_effective_start_date;

Line: 124

		  ' '    ||to_char(p_row.LAST_UPDATE_DATE ,l_who_col_fmt)||'  '|| p_message   ) ;

Line: 131

			 p_last_update_date	in date,
			 p_message              in varchar2 ) is
  l_dt_row dt_row ;

Line: 140

      l_dt_row.last_update_date     := p_last_update_date ;

Line: 156

	  'select :id_col , effective_start_date , effective_end_date  :who_cols
	   from   :table_name
           order by 1 , 2 , 3 ' ;

Line: 162

    select ind.column_name
    from   all_ind_columns ind,
           all_constraints cons
    where  cons.owner           = p_schema
    and    cons.table_name      = p_table_name
    and    cons.constraint_type = 'P'
    and    cons.constraint_name = ind.index_name
    and    ind.table_owner      = p_schema
    and    ind.table_name       = p_table_name
    and    ind.column_position  = 1 ;

Line: 188

    select 1
    from   all_tab_columns col
    where  col.owner       = p_schema
    and    col.table_name  = p_table_name
    and    col.column_name = 'CREATION_DATE' ;

Line: 218

			                ',CREATION_DATE, LAST_UPDATE_DATE ' ) ;

Line: 253

       dbms_sql.define_column( l_theCursor, 5 , g_temp_row.last_update_date) ;

Line: 275

       dbms_sql.column_value( p_cursor, 5 , l_theRow.last_update_date) ;

Line: 293

	  g_tab_last_update_date(i)     := null ;

Line: 307

     g_tab_last_update_date(p_index)     := p_row.last_update_date ;

Line: 325

     output_line('         ID EFF. START  EFF. END             DATE CREATED         LAST UPDATE           ERROR');

Line: 342

	             g_tab_last_update_date(i),
		     g_tab_message(i) ) ;