DBA Data[Home] [Help]

APPS.EDW_COLLECTION_UTIL dependencies on ALL_TAB_COLUMNS

Line 1862: l_column all_tab_columns.column_name%TYPE;

1858: RETURN NUMBER
1859: IS
1860: cv curtyp;
1861: l_stmt VARCHAR2 (30000);
1862: l_column all_tab_columns.column_name%TYPE;
1863: l_collist VARCHAR2 (10000);
1864: l_scollist VARCHAR2 (10000);
1865: l_edw_extent PLS_INTEGER := 0;
1866: row_count PLS_INTEGER := 0;

Line 1969: 'SELECT column_name FROM all_tab_columns WHERE table_name =:t AND column_name not in ( ''COLLECTION_STATUS'',''REQUEST_ID'')'

1965:
1966: -- Get list of columns
1967: l_colcount := 0;
1968: l_stmt :=
1969: 'SELECT column_name FROM all_tab_columns WHERE table_name =:t AND column_name not in ( ''COLLECTION_STATUS'',''REQUEST_ID'')'
1970: || ' AND owner = :o';
1971: put_debug_msg ( 'Running for '
1972: || l_stgtbl_name);
1973: put_debug_msg (l_stmt);