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_DICTIONARY_PKG dependencies on FND_INDEX_COLUMNS

Line 1162: from fnd_index_columns

1158:
1159: -- Check index column
1160: cnt := 0;
1161: select count(*) into cnt
1162: from fnd_index_columns
1163: where application_id = appl_id
1164: and table_id = tab_id
1165: and column_id = col_id;
1166: if (cnt > 0) then

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 1278: delete from fnd_index_columns

1274: return;
1275: end;
1276:
1277: -- Delete index columns
1278: delete from fnd_index_columns
1279: where application_id = appl_id
1280: and table_id = tab_id
1281: and index_id = ind_id;
1282:

Line 2083: delete from FND_INDEX_COLUMNS

2079:
2080: -- Bug3230044 Delete any child records with a negative
2081: -- value for COLUMN_ID.
2082:
2083: delete from FND_INDEX_COLUMNS
2084: where APPLICATION_ID = appl_id
2085: and TABLE_ID = tab_id
2086: and INDEX_ID = ind_id
2087: and COLUMN_ID < 0;

Line 2094: update FND_INDEX_COLUMNS

2090: -- and COLUMN_ID values to a negative value in order to
2091: -- prevent unique constraints while processing the
2092: -- PARENT/CHILD entity.
2093:
2094: update FND_INDEX_COLUMNS
2095: set COLUMN_SEQUENCE = -1 * COLUMN_SEQUENCE,
2096: COLUMN_ID = -1 * COLUMN_ID
2097: where APPLICATION_ID = appl_id
2098: and TABLE_ID = tab_id

Line 2103: update FND_INDEX_COLUMNS

2099: and INDEX_ID = ind_id;
2100:
2101: /*Bug2773876 - Handle special case where COLUMN_SEQUENCE = 0 */
2102:
2103: update FND_INDEX_COLUMNS
2104: set COLUMN_SEQUENCE = -1000
2105: where APPLICATION_ID = appl_id
2106: and TABLE_ID = tab_id
2107: and INDEX_ID = ind_id

Line 2148: from fnd_index_columns

2144: -- and the file entity.
2145:
2146: select max(last_update_date)
2147: into child_db_ludate
2148: from fnd_index_columns
2149: where application_id = appl_id
2150: and table_id = tab_id
2151: and index_id = ind_id
2152: and column_sequence < 0

Line 2159: from fnd_index_columns

2155: -- Bug3139883 changed select to also include value if column_sequence =0
2156:
2157: select max(last_update_date)
2158: into child_file_ludate
2159: from fnd_index_columns
2160: where application_id = appl_id
2161: and table_id = tab_id
2162: and index_id = ind_id
2163: and column_sequence >= 0

Line 2182: from fnd_index_columns

2178:
2179: -- If any non-seed owners, set owner to user
2180: select max(-1)
2181: into child_db_luby
2182: from fnd_index_columns
2183: where application_id = appl_id
2184: and table_id = tab_id
2185: and index_id = ind_id
2186: and column_sequence < 0

Line 2197: from fnd_index_columns

2193:
2194: -- If any non-seed owners, set owner to user
2195: select max(-1)
2196: into child_file_luby
2197: from fnd_index_columns
2198: where application_id = appl_id
2199: and table_id = tab_id
2200: and index_id = ind_id
2201: and column_sequence > 0

Line 2216: delete from fnd_index_columns

2212:
2213: -- The new child entity rows from the data file are kept so
2214: -- delete the existing db child entity rows.
2215:
2216: delete from fnd_index_columns
2217: where application_id = appl_id
2218: and table_id = tab_id
2219: and index_id = ind_id
2220: and column_sequence < 0

Line 2229: delete from fnd_index_columns

2225: -- The existing db child entity rows are kept so delete the new child
2226: -- entity rows from the data file
2227: -- Bug3139883 - Modified delete to include the value column_sequence = 0
2228:
2229: delete from fnd_index_columns
2230: where application_id = appl_id
2231: and table_id = tab_id
2232: and index_id = ind_id
2233: and column_sequence >= 0

Line 2240: update FND_INDEX_COLUMNS

2236: -- Rename the existing db entity rows back to normal since
2237: -- it was not replaced by the new child entity rows
2238: -- from the data file.
2239:
2240: update FND_INDEX_COLUMNS
2241: set COLUMN_SEQUENCE = -1 * COLUMN_SEQUENCE,
2242: COLUMN_ID = -1 * COLUMN_ID
2243: where APPLICATION_ID = appl_id
2244: and TABLE_ID = tab_id

Line 2249: update FND_INDEX_COLUMNS

2245: and INDEX_ID = ind_id;
2246:
2247: /*Bug2773876 - Handle special case where COLUMN_SEQUENCE = 0 */
2248:
2249: update FND_INDEX_COLUMNS
2250: set COLUMN_SEQUENCE = 0
2251: where APPLICATION_ID = appl_id
2252: and TABLE_ID = tab_id
2253: and INDEX_ID = ind_id

Line 2269: update FND_INDEX_COLUMNS

2265: -- Rename the existing db entity rows back to normal since
2266: -- it was not replaced by the new child entity rows
2267: -- from the data file.
2268:
2269: update FND_INDEX_COLUMNS
2270: set COLUMN_SEQUENCE = -1 * COLUMN_SEQUENCE,
2271: COLUMN_ID = -1 * COLUMN_ID
2272: where APPLICATION_ID = appl_id
2273: and TABLE_ID = tab_id

Line 2278: update FND_INDEX_COLUMNS

2274: and INDEX_ID = ind_id;
2275:
2276: /*Bug2773876 - Handle special case where COLUMN_SEQUENCE = 0 */
2277:
2278: update FND_INDEX_COLUMNS
2279: set COLUMN_SEQUENCE = 0
2280: where APPLICATION_ID = appl_id
2281: and TABLE_ID = tab_id
2282: and INDEX_ID = ind_id

Line 2355: insert into FND_INDEX_COLUMNS(

2351: -- index columns from the data file to determine which will be
2352: -- updated into the database based on the date and custom factirs.
2353:
2354: begin
2355: insert into FND_INDEX_COLUMNS(
2356: APPLICATION_ID,
2357: TABLE_ID,
2358: INDEX_ID,
2359: COLUMN_ID,