APPS.FND_DICTIONARY_PKG dependencies on FND_INDEXES

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

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

Line 301: insert into FND_INDEXES (

297: ) is
298:
299: begin
300:
301: insert into FND_INDEXES (
302: APPLICATION_ID,
303: TABLE_ID,
304: INDEX_ID,
305: INDEX_NAME,

Line 325: FND_INDEXES_S.NEXTVAL,

321: CREATED_BY)
322: values (
323: x_application_id,
324: x_table_id,
325: FND_INDEXES_S.NEXTVAL,
326: x_index_name,
327: x_uniqueness,
328: x_auto_size,
329: x_description,

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

1215: end RemoveColumn;
1216:
1217: --
1218: -- RemoveIndex (PUBLIC)
1219: -- Remove index from FND_INDEXES and FND_INDEX_COLUMNS table.
1220: --
1221: procedure RemoveIndex(
1222: x_application_short_name in varchar2,
1223: x_table_name in varchar2,

Line 1263: from fnd_indexes

1259:
1260: begin
1261: select index_id
1262: into ind_id
1263: from fnd_indexes
1264: where application_id = appl_id
1265: and table_id = tab_id
1266: and index_name = upper(x_index_name);
1267: exception

Line 1270: fnd_message.set_token('TABLE', 'FND_INDEXES');

1266: and index_name = upper(x_index_name);
1267: exception
1268: when no_data_found then
1269: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
1270: fnd_message.set_token('TABLE', 'FND_INDEXES');
1271: fnd_message.set_token('COLUMN', 'INDEX_NAME');
1272: fnd_message.set_token('VALUE', x_index_name);
1273: app_exception.raise_exception;
1274: return;

Line 1283: delete from fnd_indexes

1279: where application_id = appl_id
1280: and table_id = tab_id
1281: and index_id = ind_id;
1282:
1283: delete from fnd_indexes
1284: where application_id = appl_id
1285: and table_id = tab_id
1286: and index_id = ind_id;
1287:

Line 1560: from fnd_indexes

1556: tab_id number;
1557:
1558: cursor ind is
1559: select index_name
1560: from fnd_indexes
1561: where application_id = appl_id
1562: and table_id = tab_id;
1563:
1564: cursor fk is

Line 2044: from FND_INDEXES

2040: begin
2041:
2042: select INDEX_ID
2043: into ind_id
2044: from FND_INDEXES
2045: where APPLICATION_ID = appl_id
2046: and TABLE_ID = tab_id
2047: and INDEX_NAME = x_index_name;
2048:

Line 2051: from FND_INDEXES

2047: and INDEX_NAME = x_index_name;
2048:
2049: select LAST_UPDATED_BY, LAST_UPDATE_DATE
2050: into db_luby, db_ludate
2051: from FND_INDEXES
2052: where APPLICATION_ID = appl_id
2053: and TABLE_ID = tab_id
2054: and INDEX_NAME = x_index_name;
2055:

Line 2059: update FND_INDEXES set

2055:
2056: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
2057: db_ludate, X_CUSTOM_MODE)) then
2058:
2059: update FND_INDEXES set
2060: UNIQUENESS = x_uniqueness,
2061: AUTO_SIZE = x_auto_size,
2062: DESCRIPTION = x_description,
2063: INITIAL_EXTENT = x_initial_extent,

Line 2138: from FND_INDEXES

2134: else -- phase_mode = 'END'
2135:
2136: select INDEX_ID
2137: into ind_id
2138: from FND_INDEXES
2139: where APPLICATION_ID = appl_id
2140: and TABLE_ID = tab_id
2141: and INDEX_NAME = x_index_name;
2142:

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

2320: select T.TABLE_ID into tab_id from FND_TABLES T
2321: where T.APPLICATION_ID = appl_id
2322: and T.TABLE_NAME = x_table_name;
2323:
2324: select I.INDEX_ID into idx_id from FND_INDEXES I
2325: where I.APPLICATION_ID = appl_id
2326: and I.TABLE_ID = tab_id
2327: and I.INDEX_NAME = x_index_name;
2328: