DBA Data[Home] [Help]

APPS.OKL_AM_UTIL_PVT dependencies on USER_TAB_COLUMNS

Line 2682: FROM user_tab_columns

2678: p_view_name IN VARCHAR2,
2679: x_return_status OUT NOCOPY VARCHAR2) IS
2680: cursor av_csr is select table_name,Column_Name ,data_type,data_length,NVL(data_precision,OKC_API.G_MISS_NUM)
2681: data_precision,NVL(data_scale,0) data_scale
2682: FROM user_tab_columns
2683: WHERE table_name = UPPER( p_view_name) and (data_type='VARCHAR2' OR data_type='NUMBER');
2684: var1 av_csr%rowtype;
2685: i number:=1;
2686: found Boolean:=FALSE;