DBA Data[Home] [Help]

APPS.FND_XDF_UTIL_PKG dependencies on ALL_TAB_COLUMNS

Line 34: DATA_PRECISION, DATA_SCALE, DATA_DEFAULT from all_tab_columns where

30: LOGGING|| CACHE|| IOT_TYPE || ROW_MOVEMENT into tmp_str
31: FROM ALL_TABLES WHERE TABLE_NAME=p_tablename AND OWNER=p_owner;
32:
33: for x in ( select COLUMN_NAME, DATA_TYPE, DATA_LENGTH, NULLABLE,
34: DATA_PRECISION, DATA_SCALE, DATA_DEFAULT from all_tab_columns where
35: table_name =p_tablename and owner = p_owner order by column_name)
36: loop
37:
38: l_hashVal := dbms_utility.get_hash_value(x.COLUMN_NAME || x.DATA_TYPE || x.DATA_LENGTH || x.NULLABLE || x.DATA_PRECISION || x.DATA_SCALE || x.DATA_DEFAULT, 1, 999999999);