APPS.FND_XDF_UTIL_PKG dependencies on DBMS_UTILITY

Line 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);

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);
39: ind := ind + 1;
40: l_hashCode_List.EXTEND;
41: l_hashCode_List(ind) := l_hashVal;
42:

Line 54: l_hashVal := dbms_utility.get_hash_value(x.PARTITION_NAME || x.HIGH_VALUE || x.SUBPARTITION_COUNT,1,999999999);

50: WHERE TABLE_NAME = p_tablename
51: and TABLE_OWNER = p_owner ORDER BY PARTITION_POSITION)
52: loop
53:
54: l_hashVal := dbms_utility.get_hash_value(x.PARTITION_NAME || x.HIGH_VALUE || x.SUBPARTITION_COUNT,1,999999999);
55: tmp_str := tmp_str || l_hashVal;
56: end loop;
57:
58: for x in ( SELECT COLUMN_NAME FROM DBA_PART_KEY_COLUMNS

Line 61: l_hashVal := dbms_utility.get_hash_value(x.COLUMN_NAME,1,999999999);

57:
58: for x in ( SELECT COLUMN_NAME FROM DBA_PART_KEY_COLUMNS
59: WHERE NAME = p_tablename AND OWNER =p_owner ORDER BY COLUMN_POSITION)
60: loop
61: l_hashVal := dbms_utility.get_hash_value(x.COLUMN_NAME,1,999999999);
62: tmp_str := tmp_str || l_hashVal;
63: end loop;
64:
65: table_hash_val := dbms_utility.get_hash_value(tmp_str , 1, 999999999);

Line 65: table_hash_val := dbms_utility.get_hash_value(tmp_str , 1, 999999999);

61: l_hashVal := dbms_utility.get_hash_value(x.COLUMN_NAME,1,999999999);
62: tmp_str := tmp_str || l_hashVal;
63: end loop;
64:
65: table_hash_val := dbms_utility.get_hash_value(tmp_str , 1, 999999999);
66: p_columns_list := l_column_List;
67: return l_hashCode_List;
68: exception
69: WHEN NO_DATA_FOUND THEN

Line 84: return DBMS_UTILITY.GET_HASH_VALUE(l_hashstr,1,999999999);

80: MESSAGE_GROUPING || PRIMARY_INSTANCE || SECONDARY_INSTANCE ||
81: USER_COMMENT INTO l_hashstr
82: FROM ALL_QUEUE_TABLES
83: WHERE QUEUE_TABLE=p_qtablename AND OWNER= p_owner;
84: return DBMS_UTILITY.GET_HASH_VALUE(l_hashstr,1,999999999);
85: exception
86: WHEN NO_DATA_FOUND THEN
87: return 0;
88: end;

Line 101: return DBMS_UTILITY.GET_HASH_VALUE(l_hashstr,1,999999999);

97: dequeue_enabled || retry_delay || retention || user_comment
98: INTO l_hashstr
99: FROM ALL_QUEUES
100: WHERE OWNER=p_owner AND NAME = p_queuename;
101: return DBMS_UTILITY.GET_HASH_VALUE(l_hashstr,1,999999999);
102: exception
103: WHEN NO_DATA_FOUND THEN
104: return 0;
105: end;

Line 132: return DBMS_UTILITY.GET_HASH_VALUE(l_hashstr,1,999999999);

128:
129: for c in col_cur loop
130: l_hashstr := l_hashstr || c.column_name;
131: end loop;
132: return DBMS_UTILITY.GET_HASH_VALUE(l_hashstr,1,999999999);
133: exception
134: WHEN NO_DATA_FOUND THEN
135: return 0;
136: end;

Line 209: indexHashcodes(i) := DBMS_UTILITY.GET_HASH_VALUE(l_hashstr,1,999999999);

205: --DBMS_OUTPUT.PUT_LINE(l_hashstr);
206:
207: indexHashcodes.EXTEND;
208: if l_hashstr <>'NULL' then
209: indexHashcodes(i) := DBMS_UTILITY.GET_HASH_VALUE(l_hashstr,1,999999999);
210: else
211: indexHashcodes(i) := 0;
212: end if;
213: i := i+1;

Line 269: indexHashcodes(i) := DBMS_UTILITY.GET_HASH_VALUE(l_hashstr,1,999999999);

265:
266:
267: indexHashcodes.EXTEND;
268: if l_hashstr <>'NULL' then
269: indexHashcodes(i) := DBMS_UTILITY.GET_HASH_VALUE(l_hashstr,1,999999999);
270: else
271: indexHashcodes(i) := 0;
272: end if;
273: i := i+1;