eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FND_XDF_UTIL_PKG dependencies on FND_XDF_TABLE_OF_VARCHAR2_30

Line 10: p_columns_list out NOCOPY FND_XDF_TABLE_OF_VARCHAR2_30,

6: * columns.
7: */
8: function get_hashcode_table( p_tablename in varchar2 ,
9: p_owner in varchar2,
10: p_columns_list out NOCOPY FND_XDF_TABLE_OF_VARCHAR2_30,
11: table_hash_val out NOCOPY number )
12: return FND_XDF_TABLE_OF_NUMBER is
13: l_hashVal number;
14: l_hashCode_List FND_XDF_TABLE_OF_NUMBER := FND_XDF_TABLE_OF_NUMBER();

Line 15: l_column_List FND_XDF_TABLE_OF_VARCHAR2_30 := FND_XDF_TABLE_OF_VARCHAR2_30();

11: table_hash_val out NOCOPY number )
12: return FND_XDF_TABLE_OF_NUMBER is
13: l_hashVal number;
14: l_hashCode_List FND_XDF_TABLE_OF_NUMBER := FND_XDF_TABLE_OF_NUMBER();
15: l_column_List FND_XDF_TABLE_OF_VARCHAR2_30 := FND_XDF_TABLE_OF_VARCHAR2_30();
16: ind integer;
17: tmp_str varchar2(32000);
18:
19: begin

Line 142: function get_hashcode_index(p_indexList in FND_XDF_TABLE_OF_VARCHAR2_30, p_owner in varchar2)

138: /*
139: * Function that generates the hashcode for an array of indexes.
140: */
141: /*
142: function get_hashcode_index(p_indexList in FND_XDF_TABLE_OF_VARCHAR2_30, p_owner in varchar2)
143: return FND_XDF_TABLE_OF_NUMBER is
144: indexHashcodes FND_XDF_TABLE_OF_NUMBER := FND_XDF_TABLE_OF_NUMBER();
145:
146: TYPE typIndxDetails IS REF CURSOR;

Line 178: ||'FROM ALL_INDEXES , TABLE(FND_XDF_TABLE_OF_VARCHAR2_30(' || l_indexListstr ||')) FND_TAB '

174: ||'NVL(DECODE(LTRIM(DEGREE), ''DEFAULT'', 65536, DEGREE),0) || NVL(PARTITIONED, ''NO'') || '
175: ||'NVL(funcidx_status, ''DISABLED'') || TABLE_NAME || NVL(tablespace_name, '' '') || TABLE_OWNER || '
176: ||'TABLE_TYPE || NVL(ITYP_OWNER, ''-1'') || NVL(ITYP_NAME,''-1'') || NVL(PARAMETERS, ''-1'') hashstr,'
177: ||'index_name '
178: ||'FROM ALL_INDEXES , TABLE(FND_XDF_TABLE_OF_VARCHAR2_30(' || l_indexListstr ||')) FND_TAB '
179: ||'WHERE index_name = FND_TAB.COLUMN_VALUE AND OWNER = ''' || p_owner || ''''
180: ||' UNION ALL '
181: ||'SELECT ''NULL'', C.COLUMN_VALUE FROM TABLE(FND_XDF_TABLE_OF_VARCHAR2_30('|| l_indexListstr || ')) C '
182: ||'WHERE C.COLUMN_VALUE NOT IN '

Line 181: ||'SELECT ''NULL'', C.COLUMN_VALUE FROM TABLE(FND_XDF_TABLE_OF_VARCHAR2_30('|| l_indexListstr || ')) C '

177: ||'index_name '
178: ||'FROM ALL_INDEXES , TABLE(FND_XDF_TABLE_OF_VARCHAR2_30(' || l_indexListstr ||')) FND_TAB '
179: ||'WHERE index_name = FND_TAB.COLUMN_VALUE AND OWNER = ''' || p_owner || ''''
180: ||' UNION ALL '
181: ||'SELECT ''NULL'', C.COLUMN_VALUE FROM TABLE(FND_XDF_TABLE_OF_VARCHAR2_30('|| l_indexListstr || ')) C '
182: ||'WHERE C.COLUMN_VALUE NOT IN '
183: ||'(SELECT B.INDEX_NAME FROM ALL_INDEXES B WHERE OWNER = '''|| p_owner || ''' AND C.COLUMN_VALUE = B.INDEX_NAME) ';
184:
185: --DBMS_OUTPUT.PUT_LINE(l_indexListStr);

Line 223: function get_hashcode_index(p_indexList in FND_XDF_TABLE_OF_VARCHAR2_30, p_owner in varchar2)

219:
220: /*
221: * Function that generates the hashcode for an array of indexes.
222: */
223: function get_hashcode_index(p_indexList in FND_XDF_TABLE_OF_VARCHAR2_30, p_owner in varchar2)
224: return FND_XDF_TABLE_OF_NUMBER is
225: indexHashcodes FND_XDF_TABLE_OF_NUMBER := FND_XDF_TABLE_OF_NUMBER();
226: selQry varchar2(32000);
227: cursor col_cur (p_indexname varchar2) is