APPS.AP_ACCTG_DATA_FIX_PKG dependencies on ALL_TAB_COLUMNS

Line 136: l_all_tab_columns varchar2(100) := 'ALL_TAB_COLUMNS';

132: TYPE sqlCurTyp IS REF CURSOR;
133: cur sqlCurTyp;
134: stmt_str VARCHAR2(500);
135: col_name varchar2(100);
136: l_all_tab_columns varchar2(100) := 'ALL_TAB_COLUMNS';
137: l_calling_sequence VARCHAR2(2000);
138: l_message varchar2(500);
139:
140: begin

Line 144: stmt_str := 'select column_name from '|| l_all_tab_columns ||

140: begin
141:
142: l_calling_sequence :=
143: 'AP_Acctg_Data_Fix_PKG.Get_Cols<-' ;
144: stmt_str := 'select column_name from '|| l_all_tab_columns ||
145: ' where table_name=:1 and column_name<>''DATAFIX_UPDATE_DATE''';
146: OPEN cur FOR stmt_str USING TAB_NAME;
147: LOOP
148: FETCH cur INTO COL_NAME;

Line 369: FROM all_tab_columns

365: --print(colname (col_count));
366:
367: SELECT data_type,DATA_LENGTH
368: INTO coltype (col_count) ,collen(col_count)
369: FROM all_tab_columns
370: WHERE owner = owner_nm
371: AND table_name = table_nm
372: AND column_name=colname (col_count);
373: --print('stg7');