DBA Data[Home] [Help]

APPS.OKC_UTIL dependencies on USER_TAB_COLUMNS

Line 229: FROM user_tab_columns

225: p_view_name IN VARCHAR2,
226: x_return_status OUT NOCOPY VARCHAR2) IS
227: cursor av_csr is select table_name,Column_Name ,data_type,data_length,NVL(data_precision,OKC_API.G_MISS_NUM)
228: data_precision,NVL(data_scale,0) data_scale
229: FROM user_tab_columns
230: WHERE table_name = UPPER( p_view_name) and (data_type='VARCHAR2' OR data_type='NUMBER');
231: var1 av_csr%rowtype;
232: i number:=1;
233: found Boolean:=FALSE;