APPS.FA_ASSET_TRACE_PVT SQL Statements

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

Line: 67

  g_anchor_tbl.delete;

Line: 68

  g_options_tbl.delete;

Line: 69

  g_col_exclusions.delete;

Line: 169

			         IF (nvl(l_primary_tbls(i).l_gen_select, 'N') = 'Y') THEN
			           g_chk_cnt :=get_tbl_cnt (l_cur_tab_name,NULL,l_schema);

Line: 171

			         ELSIF nvl(l_primary_tbls(i).l_gen_select, 'N') = 'N' THEN
			           g_chk_cnt := TRUE;

Line: 230

   l_stmt :='SELECT syn.synonym_name, column_name
             FROM user_synonyms syn,all_tab_columns col
             WHERE col.owner      =  syn.table_owner
	     AND col.table_name = syn.table_name
             AND syn.synonym_name = '||''''||p_tbl||''''||fnd_global.local_chr(10);

Line: 312

   l_select_clause   varchar2(32767);

Line: 382

          l_select_clause := l_select_clause||fafsc(l_col_tbl(i));

Line: 386

        l_select_clause   := substr(l_select_clause, 1, length(l_select_clause) -6);

Line: 387

        l_select_clause   := l_select_clause ||'||'||''''||''||'''';

Line: 388

        g_sel_tbl(l_idx)  := l_select_clause;

Line: 399

        l_select_clause := fafsc(l_col_tbl(i));

Line: 409

        l_select_clause := l_select_clause||fafsc(l_col_tbl(i));

Line: 438

   l_insert         VARCHAR2(4000);

Line: 439

   l_hdr_insert     VARCHAR2(4000);

Line: 473

   l_hdr_insert := 'SELECT '||''''||g_dyn_head||''''||' FROM DUAL';

Line: 477

      log(l_calling_fn,'l_hdr_insert is: '||l_hdr_insert);

Line: 486

     EXECUTE IMMEDIATE l_hdr_insert INTO g_output_tbl(l_counter);

Line: 508

      log(l_calling_fn,'In exec-sql exception, l_hdr_insert is: '||l_hdr_insert);

Line: 524

   l_sql_stmt        VARCHAR2(32767) := ' SELECT '||''''||''||''''||'||';

Line: 848

   l_sql_stmt :=  ' SELECT count(*) FROM ' || p_table || get_param(l_chk_col);

Line: 892

     SELECT count(*)
     INTO l_both
     FROM dba_tab_columns col,
          user_synonyms syn
     WHERE syn.synonym_name = p_table
     AND   col.owner        =  syn.table_owner
     AND   col.table_name = syn.table_name
     AND   col.column_name IN (l_primary_column,l_secondary_column);

Line: 907

       SELECT count(*)
       INTO l_secondary
       FROM dba_tab_columns col,
            user_synonyms syn
       WHERE syn.synonym_name = p_table
       AND   col.owner        =  syn.table_owner
       AND   col.table_name = syn.table_name
       AND   column_name = l_secondary_column;

Line: 1172

   g_output_tbl.delete; g_no_rec_tbl.delete;