APPS.EDW_OWB_COLLECTION_UTIL dependencies on ALL_TAB_COLUMNS

Line 652: select column_name,data_type,data_length,num_distinct,num_nulls,avg_col_len from all_tab_columns

648: p_avg_col_length out NOCOPY numberTableType,
649: p_number_columns out NOCOPY number,
650: p_owner varchar2) return boolean is
651: cursor cv(p_table varchar2,p_owner varchar2) is
652: select column_name,data_type,data_length,num_distinct,num_nulls,avg_col_len from all_tab_columns
653: where table_name=p_table and owner=p_owner;
654: l_table varchar2(80);
655: l_owner varchar2(80);
656: Begin

Line 673: 'avg_col_len from all_tab_columns where table_name='||l_table||' and owner='||l_owner);

669: end if;
670: p_number_columns:=1;
671: if g_debug then
672: write_to_log_file_n('select column_name,data_type,data_length,num_distinct,num_nulls,'||
673: 'avg_col_len from all_tab_columns where table_name='||l_table||' and owner='||l_owner);
674: end if;
675: open cv(l_table,l_owner);
676: loop
677: fetch cv into p_columns(p_number_columns),

Line 3728: l_stmt:='select 1 from all_tab_columns where table_name=:a and column_name=:b and owner=:c';

3724: if l_owner is null then
3725: l_owner:=get_table_owner(l_table);
3726: end if;
3727: if l_owner is not null then
3728: l_stmt:='select 1 from all_tab_columns where table_name=:a and column_name=:b and owner=:c';
3729: if g_debug then
3730: write_to_log_file_n(l_stmt||' '||l_table||' '||upper(p_column)||' '||l_owner);
3731: end if;
3732: open cv for l_stmt using l_table,upper(p_column),l_owner;

Line 3734: l_stmt:='select 1 from all_tab_columns,user_synonyms syn where all_tab_columns.table_name=:a '||

3730: write_to_log_file_n(l_stmt||' '||l_table||' '||upper(p_column)||' '||l_owner);
3731: end if;
3732: open cv for l_stmt using l_table,upper(p_column),l_owner;
3733: else
3734: l_stmt:='select 1 from all_tab_columns,user_synonyms syn where all_tab_columns.table_name=:a '||
3735: 'and column_name=:b and syn.table_name=all_tab_columns.table_name and syn.table_owner=all_tab_columns.owner';
3736: if g_debug then
3737: write_to_log_file_n(l_stmt||' '||l_table||' '||upper(p_column));
3738: end if;

Line 3735: 'and column_name=:b and syn.table_name=all_tab_columns.table_name and syn.table_owner=all_tab_columns.owner';

3731: end if;
3732: open cv for l_stmt using l_table,upper(p_column),l_owner;
3733: else
3734: l_stmt:='select 1 from all_tab_columns,user_synonyms syn where all_tab_columns.table_name=:a '||
3735: 'and column_name=:b and syn.table_name=all_tab_columns.table_name and syn.table_owner=all_tab_columns.owner';
3736: if g_debug then
3737: write_to_log_file_n(l_stmt||' '||l_table||' '||upper(p_column));
3738: end if;
3739: open cv for l_stmt using l_table,upper(p_column);

Line 5258: g_stmt:='select 1 from all_tab_columns where table_name=:1 and owner=:2 and column_name=:3';

5254: l_owner:=p_owner;
5255: if l_owner is null then
5256: l_owner:=get_table_owner(p_table);
5257: end if;
5258: g_stmt:='select 1 from all_tab_columns where table_name=:1 and owner=:2 and column_name=:3';
5259: if g_debug then
5260: write_to_log_file_n(g_stmt||' '||p_table||' '||l_owner||' '||p_col);
5261: end if;
5262: open cv for g_stmt using p_table,l_owner,p_col;