APPS.FA_ASSET_TRACE_PVT SQL Statements

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

Line: 61

  g_anchor_tbl.delete;

Line: 62

  g_options_tbl.delete;

Line: 63

  g_col_exclusions.delete;

Line: 163

			         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: 165

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

Line: 224

   l_stmt :='SELECT table_name, column_name
             FROM all_tab_columns
             WHERE owner = ''' || p_schema || ''' ' ||
            'AND table_name = '||''''||p_tbl||''''||fnd_global.local_chr(10);

Line: 305

   l_select_clause   varchar2(32767);

Line: 375

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

Line: 379

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

Line: 380

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

Line: 381

        g_sel_tbl(l_idx)  := l_select_clause;

Line: 392

        l_select_clause := fafsc(l_col_tbl(i));

Line: 402

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

Line: 431

   l_insert         VARCHAR2(4000);

Line: 432

   l_hdr_insert     VARCHAR2(4000);

Line: 466

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

Line: 470

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

Line: 479

     EXECUTE IMMEDIATE l_hdr_insert INTO g_output_tbl(l_counter);

Line: 501

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

Line: 517

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

Line: 836

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

Line: 880

     SELECT count(*)
     INTO l_both
     FROM dba_tab_columns
     WHERE column_name IN (l_primary_column,l_secondary_column)
     AND owner = p_schema
     AND table_name = p_table;

Line: 893

       SELECT count(*)
       INTO l_secondary
       FROM dba_tab_columns
       WHERE column_name = l_secondary_column
       AND owner = p_schema
       AND table_name = p_table;

Line: 1156

   g_output_tbl.delete; g_no_rec_tbl.delete;