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 2147: delete from FND_INDEX_COLUMNS

2143:
2144: -- Bug3230044 Delete any child records with a negative
2145: -- value for COLUMN_ID.
2146:
2147: delete from FND_INDEX_COLUMNS
2148: where APPLICATION_ID = appl_id
2149: and TABLE_ID = tab_id
2150: and INDEX_ID = ind_id
2151: and COLUMN_ID < 0;

Line 2158: update FND_INDEX_COLUMNS

2154: -- and COLUMN_ID values to a negative value in order to
2155: -- prevent unique constraints while processing the
2156: -- PARENT/CHILD entity.
2157:
2158: update FND_INDEX_COLUMNS
2159: set COLUMN_SEQUENCE = -1 * COLUMN_SEQUENCE,
2160: COLUMN_ID = -1 * COLUMN_ID
2161: where APPLICATION_ID = appl_id
2162: and TABLE_ID = tab_id

Line 2167: update FND_INDEX_COLUMNS

2163: and INDEX_ID = ind_id;
2164:
2165: /*Bug2773876 - Handle special case where COLUMN_SEQUENCE = 0 */
2166:
2167: update FND_INDEX_COLUMNS
2168: set COLUMN_SEQUENCE = -1000
2169: where APPLICATION_ID = appl_id
2170: and TABLE_ID = tab_id
2171: and INDEX_ID = ind_id

Line 2212: from fnd_index_columns

2208: -- and the file entity.
2209:
2210: select max(last_update_date)
2211: into child_db_ludate
2212: from fnd_index_columns
2213: where application_id = appl_id
2214: and table_id = tab_id
2215: and index_id = ind_id
2216: and column_sequence < 0

Line 2223: from fnd_index_columns

2219: -- Bug3139883 changed select to also include value if column_sequence =0
2220:
2221: select max(last_update_date)
2222: into child_file_ludate
2223: from fnd_index_columns
2224: where application_id = appl_id
2225: and table_id = tab_id
2226: and index_id = ind_id
2227: and column_sequence >= 0

Line 2246: from fnd_index_columns

2242:
2243: -- If any non-seed owners, set owner to user
2244: select max(-1)
2245: into child_db_luby
2246: from fnd_index_columns
2247: where application_id = appl_id
2248: and table_id = tab_id
2249: and index_id = ind_id
2250: and column_sequence < 0

Line 2261: from fnd_index_columns

2257:
2258: -- If any non-seed owners, set owner to user
2259: select max(-1)
2260: into child_file_luby
2261: from fnd_index_columns
2262: where application_id = appl_id
2263: and table_id = tab_id
2264: and index_id = ind_id
2265: and column_sequence > 0

Line 2280: delete from fnd_index_columns

2276:
2277: -- The new child entity rows from the data file are kept so
2278: -- delete the existing db child entity rows.
2279:
2280: delete from fnd_index_columns
2281: where application_id = appl_id
2282: and table_id = tab_id
2283: and index_id = ind_id
2284: and column_sequence < 0

Line 2293: delete from fnd_index_columns

2289: -- The existing db child entity rows are kept so delete the new child
2290: -- entity rows from the data file
2291: -- Bug3139883 - Modified delete to include the value column_sequence = 0
2292:
2293: delete from fnd_index_columns
2294: where application_id = appl_id
2295: and table_id = tab_id
2296: and index_id = ind_id
2297: and column_sequence >= 0

Line 2304: update FND_INDEX_COLUMNS

2300: -- Rename the existing db entity rows back to normal since
2301: -- it was not replaced by the new child entity rows
2302: -- from the data file.
2303:
2304: update FND_INDEX_COLUMNS
2305: set COLUMN_SEQUENCE = -1 * COLUMN_SEQUENCE,
2306: COLUMN_ID = -1 * COLUMN_ID
2307: where APPLICATION_ID = appl_id
2308: and TABLE_ID = tab_id

Line 2313: update FND_INDEX_COLUMNS

2309: and INDEX_ID = ind_id;
2310:
2311: /*Bug2773876 - Handle special case where COLUMN_SEQUENCE = 0 */
2312:
2313: update FND_INDEX_COLUMNS
2314: set COLUMN_SEQUENCE = 0
2315: where APPLICATION_ID = appl_id
2316: and TABLE_ID = tab_id
2317: and INDEX_ID = ind_id

Line 2333: update FND_INDEX_COLUMNS

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

Line 2342: update FND_INDEX_COLUMNS

2338: and INDEX_ID = ind_id;
2339:
2340: /*Bug2773876 - Handle special case where COLUMN_SEQUENCE = 0 */
2341:
2342: update FND_INDEX_COLUMNS
2343: set COLUMN_SEQUENCE = 0
2344: where APPLICATION_ID = appl_id
2345: and TABLE_ID = tab_id
2346: and INDEX_ID = ind_id

Line 2419: insert into FND_INDEX_COLUMNS(

2415: -- index columns from the data file to determine which will be
2416: -- updated into the database based on the date and custom factirs.
2417:
2418: begin
2419: insert into FND_INDEX_COLUMNS(
2420: APPLICATION_ID,
2421: TABLE_ID,
2422: INDEX_ID,
2423: COLUMN_ID,