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_XDFDICTIONARY_PKG dependencies on FND_INDEXES

Line 269: -- Add a new index into FND_INDEXES. This is only called after checking

265: end InsertColumn;
266:
267: --
268: -- InsertIndex (PRIVATE))
269: -- Add a new index into FND_INDEXES. This is only called after checking
270: -- there is no such index exists in UploadIndex().
271: --
272: procedure InsertIndex (
273: x_application_id in number,

Line 297: insert into FND_INDEXES (

293: ) is
294:
295: begin
296:
297: insert into FND_INDEXES (
298: APPLICATION_ID,
299: TABLE_ID,
300: INDEX_ID,
301: INDEX_NAME,

Line 321: FND_INDEXES_S.NEXTVAL,

317: CREATED_BY)
318: values (
319: x_application_id,
320: x_table_id,
321: FND_INDEXES_S.NEXTVAL,
322: x_index_name,
323: x_uniqueness,
324: x_auto_size,
325: x_description,

Line 1214: -- Remove index from FND_INDEXES and FND_INDEX_COLUMNS table.

1210: end RemoveColumn;
1211:
1212: --
1213: -- RemoveIndex (PUBLIC)
1214: -- Remove index from FND_INDEXES and FND_INDEX_COLUMNS table.
1215: --
1216: procedure RemoveIndex(
1217: x_application_short_name in varchar2,
1218: x_table_name in varchar2,

Line 1254: from fnd_indexes

1250:
1251: begin
1252: select index_id
1253: into ind_id
1254: from fnd_indexes
1255: where application_id = appl_id
1256: and table_id = tab_id
1257: and index_name = upper(x_index_name);
1258: exception

Line 1261: -20001, 'No data found in fnd_indexes for index name '

1257: and index_name = upper(x_index_name);
1258: exception
1259: when no_data_found then
1260: RAISE_APPLICATION_ERROR(
1261: -20001, 'No data found in fnd_indexes for index name '
1262: || x_index_name , TRUE);
1263: return;
1264: end;
1265:

Line 1272: delete from fnd_indexes

1268: where application_id = appl_id
1269: and table_id = tab_id
1270: and index_id = ind_id;
1271:
1272: delete from fnd_indexes
1273: where application_id = appl_id
1274: and table_id = tab_id
1275: and index_id = ind_id;
1276:

Line 1529: from fnd_indexes

1525: tab_id number;
1526:
1527: cursor ind is
1528: select index_name
1529: from fnd_indexes
1530: where application_id = appl_id
1531: and table_id = tab_id;
1532:
1533: cursor fk is

Line 2133: from FND_INDEXES

2129: begin
2130:
2131: select INDEX_ID
2132: into ind_id
2133: from FND_INDEXES
2134: where APPLICATION_ID = appl_id
2135: and TABLE_ID = tab_id
2136: and INDEX_NAME = x_index_name;
2137:

Line 2140: from FND_INDEXES

2136: and INDEX_NAME = x_index_name;
2137:
2138: select LAST_UPDATED_BY, LAST_UPDATE_DATE
2139: into db_luby, db_ludate
2140: from FND_INDEXES
2141: where APPLICATION_ID = appl_id
2142: and TABLE_ID = tab_id
2143: and INDEX_NAME = x_index_name;
2144:

Line 2148: update FND_INDEXES set

2144:
2145: if (upload_test(f_luby, f_ludate, db_luby,
2146: db_ludate, X_CUSTOM_MODE)) then
2147:
2148: update FND_INDEXES set
2149: UNIQUENESS = x_uniqueness,
2150: AUTO_SIZE = x_auto_size,
2151: DESCRIPTION = x_description,
2152: INITIAL_EXTENT = x_initial_extent,

Line 2227: from FND_INDEXES

2223: else -- phase_mode = 'END'
2224:
2225: select INDEX_ID
2226: into ind_id
2227: from FND_INDEXES
2228: where APPLICATION_ID = appl_id
2229: and TABLE_ID = tab_id
2230: and INDEX_NAME = x_index_name;
2231:

Line 2413: select I.INDEX_ID into idx_id from FND_INDEXES I

2409: select T.TABLE_ID into tab_id from FND_TABLES T
2410: where T.APPLICATION_ID = appl_id
2411: and T.TABLE_NAME = x_table_name;
2412:
2413: select I.INDEX_ID into idx_id from FND_INDEXES I
2414: where I.APPLICATION_ID = appl_id
2415: and I.TABLE_ID = tab_id
2416: and I.INDEX_NAME = x_index_name;
2417: