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_INDEX_COLUMNS

Line 1157: from fnd_index_columns

1153:
1154: -- Check index column
1155: cnt := 0;
1156: select count(*) into cnt
1157: from fnd_index_columns
1158: where application_id = appl_id
1159: and table_id = tab_id
1160: and column_id = col_id;
1161: if (cnt > 0) then

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

1263: return;
1264: end;
1265:
1266: -- Delete index columns
1267: delete from fnd_index_columns
1268: where application_id = appl_id
1269: and table_id = tab_id
1270: and index_id = ind_id;
1271:

Line 2172: delete from FND_INDEX_COLUMNS

2168:
2169: -- Bug3230044 Delete any child records with a negative
2170: -- value for COLUMN_ID.
2171:
2172: delete from FND_INDEX_COLUMNS
2173: where APPLICATION_ID = appl_id
2174: and TABLE_ID = tab_id
2175: and INDEX_ID = ind_id
2176: and COLUMN_ID < 0;

Line 2183: update FND_INDEX_COLUMNS

2179: -- and COLUMN_ID values to a negative value in order to
2180: -- prevent unique constraints while processing the
2181: -- PARENT/CHILD entity.
2182:
2183: update FND_INDEX_COLUMNS
2184: set COLUMN_SEQUENCE = -1 * COLUMN_SEQUENCE,
2185: COLUMN_ID = -1 * COLUMN_ID
2186: where APPLICATION_ID = appl_id
2187: and TABLE_ID = tab_id

Line 2192: update FND_INDEX_COLUMNS

2188: and INDEX_ID = ind_id;
2189:
2190: /*Bug2773876 - Handle special case where COLUMN_SEQUENCE = 0 */
2191:
2192: update FND_INDEX_COLUMNS
2193: set COLUMN_SEQUENCE = -1000
2194: where APPLICATION_ID = appl_id
2195: and TABLE_ID = tab_id
2196: and INDEX_ID = ind_id

Line 2237: from fnd_index_columns

2233: -- and the file entity.
2234:
2235: select max(last_update_date)
2236: into child_db_ludate
2237: from fnd_index_columns
2238: where application_id = appl_id
2239: and table_id = tab_id
2240: and index_id = ind_id
2241: and column_sequence < 0

Line 2248: from fnd_index_columns

2244: -- Bug3139883 changed select to also include value if column_sequence =0
2245:
2246: select max(last_update_date)
2247: into child_file_ludate
2248: from fnd_index_columns
2249: where application_id = appl_id
2250: and table_id = tab_id
2251: and index_id = ind_id
2252: and column_sequence >= 0

Line 2271: from fnd_index_columns

2267:
2268: -- If any non-seed owners, set owner to user
2269: select max(-1)
2270: into child_db_luby
2271: from fnd_index_columns
2272: where application_id = appl_id
2273: and table_id = tab_id
2274: and index_id = ind_id
2275: and column_sequence < 0

Line 2286: from fnd_index_columns

2282:
2283: -- If any non-seed owners, set owner to user
2284: select max(-1)
2285: into child_file_luby
2286: from fnd_index_columns
2287: where application_id = appl_id
2288: and table_id = tab_id
2289: and index_id = ind_id
2290: and column_sequence > 0

Line 2305: delete from fnd_index_columns

2301:
2302: -- The new child entity rows from the data file are kept so
2303: -- delete the existing db child entity rows.
2304:
2305: delete from fnd_index_columns
2306: where application_id = appl_id
2307: and table_id = tab_id
2308: and index_id = ind_id
2309: and column_sequence < 0

Line 2318: delete from fnd_index_columns

2314: -- The existing db child entity rows are kept so delete the new child
2315: -- entity rows from the data file
2316: -- Bug3139883 - Modified delete to include the value column_sequence = 0
2317:
2318: delete from fnd_index_columns
2319: where application_id = appl_id
2320: and table_id = tab_id
2321: and index_id = ind_id
2322: and column_sequence >= 0

Line 2329: update FND_INDEX_COLUMNS

2325: -- Rename the existing db entity rows back to normal since
2326: -- it was not replaced by the new child entity rows
2327: -- from the data file.
2328:
2329: update FND_INDEX_COLUMNS
2330: set COLUMN_SEQUENCE = -1 * COLUMN_SEQUENCE,
2331: COLUMN_ID = -1 * COLUMN_ID
2332: where APPLICATION_ID = appl_id
2333: and TABLE_ID = tab_id

Line 2338: update FND_INDEX_COLUMNS

2334: and INDEX_ID = ind_id;
2335:
2336: /*Bug2773876 - Handle special case where COLUMN_SEQUENCE = 0 */
2337:
2338: update FND_INDEX_COLUMNS
2339: set COLUMN_SEQUENCE = 0
2340: where APPLICATION_ID = appl_id
2341: and TABLE_ID = tab_id
2342: and INDEX_ID = ind_id

Line 2358: update FND_INDEX_COLUMNS

2354: -- Rename the existing db entity rows back to normal since
2355: -- it was not replaced by the new child entity rows
2356: -- from the data file.
2357:
2358: update FND_INDEX_COLUMNS
2359: set COLUMN_SEQUENCE = -1 * COLUMN_SEQUENCE,
2360: COLUMN_ID = -1 * COLUMN_ID
2361: where APPLICATION_ID = appl_id
2362: and TABLE_ID = tab_id

Line 2367: update FND_INDEX_COLUMNS

2363: and INDEX_ID = ind_id;
2364:
2365: /*Bug2773876 - Handle special case where COLUMN_SEQUENCE = 0 */
2366:
2367: update FND_INDEX_COLUMNS
2368: set COLUMN_SEQUENCE = 0
2369: where APPLICATION_ID = appl_id
2370: and TABLE_ID = tab_id
2371: and INDEX_ID = ind_id

Line 2444: insert into FND_INDEX_COLUMNS(

2440: -- index columns from the data file to determine which will be
2441: -- updated into the database based on the date and custom factirs.
2442:
2443: begin
2444: insert into FND_INDEX_COLUMNS(
2445: APPLICATION_ID,
2446: TABLE_ID,
2447: INDEX_ID,
2448: COLUMN_ID,